launchpad-reviewers team mailing list archive

[Enrique Sánchez <mp+485989@xxxxxxxxxxxxxxxxxx>]

Enrique Sánchez has proposed merging ~enriqueesanchz/launchpad:update-bugattachment-reference-constraint-hot into launchpad:master.

Commit message:
DB hot patch: validate constraint data
    
Validate exactly_one_reference constraint data


Requested reviews:
  Launchpad code reviewers (launchpad-reviewers)

For more details, see:
https://code.launchpad.net/~enriqueesanchz/launchpad/+git/launchpad/+merge/485989
-- 
Your team Launchpad code reviewers is requested to review the proposed merge of ~enriqueesanchz/launchpad:update-bugattachment-reference-constraint-hot into launchpad:master.

diff --git a/database/schema/patch-2211-38-1.sql b/database/schema/patch-2211-38-1.sql
new file mode 100644
index 0000000..e1dd61e
--- /dev/null
+++ b/database/schema/patch-2211-38-1.sql
@@ -0,0 +1,8 @@
+-- Copyright 2025 Canonical Ltd.  This software is licensed under the
+-- GNU Affero General Public License version 3 (see the file LICENSE).
+
+SET client_min_messages=ERROR;
+
+ALTER TABLE bugattachment VALIDATE CONSTRAINT exactly_one_reference;
+
+INSERT INTO LaunchpadDatabaseRevision VALUES (2211, 38, 1);