launchpad-reviewers team mailing list archive

[Quentin Debhi <mp+462936@xxxxxxxxxxxxxxxxxx>]

Quentin Debhi has proposed merging ~ruinedyourlife/launchpad:db-archive-metadata-overrides into launchpad:db-devel.

Commit message:
Add new field Archive.metadata_overrides to db

This field can be used for storing per-archive metadata overrides

Requested reviews:
  Launchpad code reviewers (launchpad-reviewers)

For more details, see:
https://code.launchpad.net/~ruinedyourlife/launchpad/+git/launchpad/+merge/462936
-- 
Your team Launchpad code reviewers is requested to review the proposed merge of ~ruinedyourlife/launchpad:db-archive-metadata-overrides into launchpad:db-devel.

diff --git a/database/schema/patch-2211-27-0.sql b/database/schema/patch-2211-27-0.sql
new file mode 100644
index 0000000..c7e8da3
--- /dev/null
+++ b/database/schema/patch-2211-27-0.sql
@@ -0,0 +1,10 @@
+-- Copyright 2024 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 Archive ADD COLUMN metadata_overrides jsonb;
+
+COMMENT ON COLUMN Archive.metadata_overrides IS 'A JSON object containing metadata overrides for this archive.';
+
+INSERT INTO LaunchpadDatabaseRevision VALUES (2211, 27, 0);
\ No newline at end of file