Thiago F. Pappacena has proposed merging ~pappacena/launchpad:db-patch-async-request-oci-recipe-build into launchpad:master.
Commit message: Database patch adding OCIRecipeJob table. Requested reviews: Launchpad code reviewers (launchpad-reviewers) For more details, see: https://code.launchpad.net/~pappacena/launchpad/+git/launchpad/+merge/382224 Code branch is here: https://code.launchpad.net/~pappacena/launchpad/+git/launchpad/+merge/382233 -- Your team Launchpad code reviewers is requested to review the proposed merge of ~pappacena/launchpad:db-patch-async-request-oci-recipe-build into launchpad:master.
diff --git a/database/schema/patch-2210-15-0.sql b/database/schema/patch-2210-15-0.sql new file mode 100644 index 0000000..89ee14e --- /dev/null +++ b/database/schema/patch-2210-15-0.sql @@ -0,0 +1,17 @@ +-- Copyright 2020 Canonical Ltd. This software is licensed under the +-- GNU Affero General Public License version 3 (see the file LICENSE). + +SET client_min_messages=ERROR; + +CREATE TABLE OCIRecipeJob ( + id serial PRIMARY KEY, + job INTEGER NOT NULL REFERENCES Job, + oci_recipe INTEGER NOT NULL REFERENCES OCIRecipe, + job_type INTEGER NOT NULL, + json_data TEXT NOT NULL +); + +CREATE INDEX ocirecipejob__oci_recipe__job_type__job__idx + ON OCIRecipeJob(oci_recipe, job_type, job); + +INSERT INTO LaunchpadDatabaseRevision VALUES (2210, 15, 0); diff --git a/database/schema/security.cfg b/database/schema/security.cfg index 942c5b4..76a166c 100644 --- a/database/schema/security.cfg +++ b/database/schema/security.cfg @@ -247,6 +247,7 @@ public.ociprojectname = SELECT, INSERT, UPDATE public.ociprojectseries = SELECT, INSERT, UPDATE, DELETE public.ocipushrule = SELECT, INSERT, UPDATE, DELETE public.ocirecipe = SELECT, INSERT, UPDATE, DELETE +public.ocirecipejob = SELECT, INSERT, UPDATE, DELETE public.ocirecipearch = SELECT, INSERT, DELETE public.ocirecipebuild = SELECT, INSERT, UPDATE, DELETE public.ocirecipebuildjob = SELECT, INSERT, UPDATE, DELETE
_______________________________________________ Mailing list: https://launchpad.net/~launchpad-reviewers Post to : [email protected] Unsubscribe : https://launchpad.net/~launchpad-reviewers More help : https://help.launchpad.net/ListHelp
