Merge ~ines-almeida/launchpad:pro-enable-core18/db-patch into launchpad:db-devel

[Ines Almeida]

Add pro_enable field to Snap table

Snap recipes will gain a pro_enable field, which if set will permit the use of private archive dependencies of the base.

See LP125 spec for more details

[Colin Watson (cjwatson)]

review: Approve (db)

26867ae... by Ines Almeida on 2023-09-26

Address MP comments

[William Grant (wgrant)]

review: Approve (db)

diff --git a/database/schema/patch-2211-23-0.sql b/database/schema/patch-2211-23-0.sql
new file mode 100644
index 0000000..5e1bc83
--- /dev/null
+++ b/database/schema/patch-2211-23-0.sql
@@ -0,0 +1,10 @@
+-- Copyright 2023 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 Snap ADD COLUMN pro_enable boolean;
+
+COMMENT ON COLUMN Snap.pro_enable IS 'Whether the use of private archive dependencies of the base is allowed.';
+
+INSERT INTO LaunchpadDatabaseRevision VALUES (2211, 23, 0);