launchpad-reviewers team mailing list archive

[Colin Watson <cjwatson@xxxxxxxxxxxxx>]

Colin Watson has proposed merging ~cjwatson/launchpad:db-remove-buildd-secret into launchpad:db-devel.

Commit message:
Drop valid_buildd_secret constraint on Archive

Requested reviews:
  Launchpad code reviewers (launchpad-reviewers): db

For more details, see:
https://code.launchpad.net/~cjwatson/launchpad/+git/launchpad/+merge/402376

We no longer need this to support building from private archives.  Once the constraint has been removed from production, we'll be able to remove the remaining references to it from Launchpad's code.
-- 
Your team Launchpad code reviewers is requested to review the proposed merge of ~cjwatson/launchpad:db-remove-buildd-secret into launchpad:db-devel.

diff --git a/database/schema/patch-2210-32-0.sql b/database/schema/patch-2210-32-0.sql
new file mode 100644
index 0000000..3e39105
--- /dev/null
+++ b/database/schema/patch-2210-32-0.sql
@@ -0,0 +1,9 @@
+-- Copyright 2021 Canonical Ltd.  This software is licensed under the
+-- GNU Affero General Public License version 3 (see the file LICENSE).
+
+SET client_min_messages=ERROR;
+
+-- Archive.buildd_secret is no longer used.
+ALTER TABLE Archive DROP CONSTRAINT valid_buildd_secret;
+
+INSERT INTO LaunchpadDatabaseRevision VALUES (2210, 32, 0);