~launchpad-results/launchpad-results/trunk

« back to all changes in this revision

Viewing changes to lib/lpresults/scripts/schema/__init__.py

  • Committer: Marc Tardif
  • Date: 2011-09-14 01:25:40 UTC
  • Revision ID: marc.tardif@canonical.com-20110914012540-1gs255vhv6kb0mg4
Added updating of submissions periodically.

Show diffs side-by-side

added added

removed removed

Lines of Context:
9
9
 
10
10
 
11
11
def create():
12
 
    from lpresults.services import schema as patch_package
 
12
    from lpresults.scripts import schema as patch_package
13
13
 
14
14
    return ZSchema(CREATES, DROPS, DELETES, patch_package)
15
15
 
29
29
    date_completed TIMESTAMP WITHOUT TIME ZONE NOT NULL)
30
30
""",
31
31
"""
32
 
GRANT SELECT, INSERT, UPDATE, DELETE
 
32
GRANT SELECT, INSERT, DELETE
33
33
    ON TABLE activity
34
34
    TO lpresults
35
35
""",
 
36
"""
 
37
GRANT SELECT, UPDATE
 
38
    ON TABLE activity_id_seq
 
39
    TO lpresults
 
40
""",
36
41
]
37
42
 
38
43
DROPS = [