← Back to branch summary

~launchpad-pqm/launchpad/devel

7675.822.1 by Jeroen Vermeulen
Create a TranslationTemplatesBuild/BuildFarmJob in addition to TranslationTemplatesBuildJob/BuildQueue/Job/BranchJob. 
1
 
-- Copyright 2010 Canonical Ltd.  This software is licensed under the

2
 
-- GNU Affero General Public License version 3 (see the file LICENSE).

3
 









4



SET client_min_messages=ERROR;










5












6



CREATE TABLE TranslationTemplatesBuild (










7



    id SERIAL PRIMARY KEY,








7675.823.4
by Jeroen Vermeulen


FKs are NOT NULL.



8



    build_farm_job integer NOT NULL REFERENCES BuildFarmJob(id),










9



    branch integer NOT NULL REFERENCES Branch(id));








7675.822.1
by Jeroen Vermeulen


Create a TranslationTemplatesBuild/BuildFarmJob in addition to TranslationTemplatesBuildJob/BuildQueue/Job/BranchJob.



10












11



CREATE INDEX translationtemplatesbuild__build_farm_job__idx ON










12



    TranslationTemplatesBuild(build_farm_job);










13












14



CREATE INDEX translationtemplatesbuild__branch__idx ON










15



    TranslationTemplatesBuild(branch);










16










7675.822.15
by Jeroen Vermeulen


Patch number.



17



INSERT INTO LaunchpadDatabaseRevision VALUES (2208, 13, 0);