Jürgen Gmach has proposed merging ~jugmac00/launchpad:fix-webhook-constraint
into launchpad:db-devel.
Commit message:
Fix constraint for webhook table
Requested reviews:
Launchpad code reviewers (launchpad-reviewers)
For more details, see:
https://code.launchpad.net/~jugmac00/launchpad/+git/launchpad/+merge/472488
--
Your team Launchpad code reviewers is requested to review the proposed merge of
~jugmac00/launchpad:fix-webhook-constraint into launchpad:db-devel.
diff --git a/database/schema/patch-2211-28-0.sql b/database/schema/patch-2211-28-0.sql
index a3aa9a7..fd01255 100644
--- a/database/schema/patch-2211-28-0.sql
+++ b/database/schema/patch-2211-28-0.sql
@@ -197,7 +197,7 @@ ALTER TABLE Webhook DROP CONSTRAINT one_target;
ALTER TABLE Webhook
ADD CONSTRAINT one_target CHECK (
null_count(ARRAY[git_repository, branch, snap, livefs, oci_recipe,
- rock_recipe]) = 5);
+ charm_recipe, rock_recipe]) = 6);
CREATE INDEX webhook__rock_recipe__id__idx
ON Webhook (rock_recipe, id) WHERE rock_recipe IS NOT NULL;
_______________________________________________
Mailing list: https://launchpad.net/~launchpad-reviewers
Post to : launchpad-reviewers@lists.launchpad.net
Unsubscribe : https://launchpad.net/~launchpad-reviewers
More help : https://help.launchpad.net/ListHelp
