1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
|
SET client_min_messages=ERROR;
CREATE TABLE BugWatchActivity(
id serial NOT NULL PRIMARY KEY,
bug_watch integer NOT NULL REFERENCES BugWatch(id),
activity_date timestamp without time zone
DEFAULT timezone('UTC'::text, now()) NOT NULL,
result integer,
message text,
oops_id text
);
CREATE INDEX bugwatchactivity__date__idx ON BugWatchActivity(activity_date);
CREATE INDEX bugwatchactivity__bug_watch__idx ON BugWatchActivity(bug_watch);
INSERT INTO LaunchpadDatabaseRevision VALUES (2207, 39, 0);
|