1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
|
SET client_min_messages=ERROR;
CREATE TABLE PackagingJob (
id SERIAL PRIMARY KEY,
job INTEGER NOT NULL CONSTRAINT job_fk REFERENCES Job ON DELETE CASCADE,
job_type INTEGER NOT NULL,
productseries INTEGER NOT NULL CONSTRAINT productseries_fk REFERENCES ProductSeries,
sourcepackagename INTEGER NOT NULL CONSTRAINT sourcepackagename_fk REFERENCES SourcePackageName,
distroseries INTEGER NOT NULL CONSTRAINT distroseries_fk REFERENCES DistroSeries
);
CREATE INDEX packagingjob__job__idx ON PackagingJob(job);
INSERT INTO LaunchpadDatabaseRevision VALUES (2208, 47, 0);
|