~launchpad-pqm/launchpad/devel

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);