1 2 3 4 5 6 7 8 9 10 11 12 13 14 |
SET client_min_messages=ERROR; CREATE TABLE ApportJob( id serial NOT NULL PRIMARY KEY, job integer NOT NULL REFERENCES Job(id), blob integer NOT NULL REFERENCES TemporaryBlobStorage(id), job_type integer NOT NULL, json_data text ); ALTER TABLE ApportJob ADD CONSTRAINT apportjob__job__key UNIQUE (job); CREATE INDEX apportjob__blob__idx ON ApportJob(blob); INSERT INTO LaunchpadDatabaseRevision VALUES (2207, 30, 0) |