Merge ~cjwatson/launchpad:db-remove-buildd-secret into launchpad:db-devel

Proposed by Colin Watson
Status: Merged
Approved by: Colin Watson
Approved revision: 8118cf40e4a0d5d3923d445e443598c6f77caf23
Merge reported by: Otto Co-Pilot
Merged at revision: not available
Proposed branch: ~cjwatson/launchpad:db-remove-buildd-secret
Merge into: launchpad:db-devel
Diff against target: 15 lines (+9/-0)
1 file modified
database/schema/patch-2210-32-0.sql (+9/-0)
Reviewer Review Type Date Requested Status
William Grant db Approve
Cristian Gonzalez (community) Approve
Review via email: mp+402376@code.launchpad.net

Commit message

Drop valid_buildd_secret constraint on Archive

Description of the change

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.

To post a comment you must log in.
Revision history for this message
Cristian Gonzalez (cristiangsp) wrote :

Looks good!

review: Approve
Revision history for this message
William Grant (wgrant) :
review: Approve (db)

Preview Diff

[H/L] Next/Prev Comment, [J/K] Next/Prev File, [N/P] Next/Prev Hunk
1diff --git a/database/schema/patch-2210-32-0.sql b/database/schema/patch-2210-32-0.sql
2new file mode 100644
3index 0000000..3e39105
4--- /dev/null
5+++ b/database/schema/patch-2210-32-0.sql
6@@ -0,0 +1,9 @@
7+-- Copyright 2021 Canonical Ltd. This software is licensed under the
8+-- GNU Affero General Public License version 3 (see the file LICENSE).
9+
10+SET client_min_messages=ERROR;
11+
12+-- Archive.buildd_secret is no longer used.
13+ALTER TABLE Archive DROP CONSTRAINT valid_buildd_secret;
14+
15+INSERT INTO LaunchpadDatabaseRevision VALUES (2210, 32, 0);

Subscribers

People subscribed via source and target branches

to status/vote changes: