launchpad-reviewers team mailing list archive

[Jürgen Gmach <mp+472488@xxxxxxxxxxxxxxxxxx>]

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;