← Back to branch summary

~launchpad-pqm/launchpad/devel

« back to all changes in this revision

Viewing changes to database/schema/patch-2208-70-0.sql

  • Committer: Curtis Hovey
  • Date: 2011-05-27 21:53:34 UTC
  • mto: This revision was merged to the branch mainline in revision 13136.
  • Revision ID: curtis.hovey@canonical.com-20110527215334-jqlkmt52nnl4bpeh
Moved launchpad.event into registry interfaces.

Show diffs side-by-side

added added

removed removed

Lines of Context:
database/schema/patch-2208-70-0.sql
1
 
 
2
 
SET client_min_messages=ERROR;
3
 
 
4
 
 
5
 
CREATE TABLE BugMute (
6
 
    person integer REFERENCES Person(id)
7
 
        ON DELETE CASCADE NOT NULL,
8
 
    bug integer REFERENCES Bug(id)
9
 
        ON DELETE CASCADE NOT NULL,
10
 
    date_created timestamp without time zone
11
 
        DEFAULT timezone('UTC'::text, now()) NOT NULL,
12
 
    CONSTRAINT bugmute_pkey PRIMARY KEY (person, bug)
13
 
);
14
 
 
15
 
CREATE INDEX bugmute__bug__idx
16
 
    ON BugMute(bug);
17
 
 
18
 
INSERT INTO BugMute (person, bug, date_created)
19
 
    SELECT person, bug, date_created
20
 
        FROM BugSubscription
21
 
        WHERE bug_notification_level=10;
22
 
DELETE
23
 
    FROM BugSubscription
24
 
    WHERE bug_notification_level=10;
25
 
 
26
 
INSERT INTO LaunchpadDatabaseRevision VALUES (2208, 70, 0);