Merge ~ruinedyourlife/launchpad:db-archive-metadata-overrides into launchpad:db-devel

Proposed by Quentin Debhi
Status: Merged
Approved by: Quentin Debhi
Approved revision: 01093af301f6004eb7e8422196f7e4715339f936
Merge reported by: Otto Co-Pilot
Merged at revision: not available
Proposed branch: ~ruinedyourlife/launchpad:db-archive-metadata-overrides
Merge into: launchpad:db-devel
Diff against target: 16 lines (+10/-0)
1 file modified
database/schema/patch-2211-27-0.sql (+10/-0)
Reviewer Review Type Date Requested Status
William Grant db Approve
Jürgen Gmach Approve
Ines Almeida Approve
Guruprasad Approve
Review via email: mp+462936@code.launchpad.net

Commit message

Add new field Archive.metadata_overrides to db

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

To post a comment you must log in.
Revision history for this message
Guruprasad (lgp171188) wrote :

LGTM 👍

review: Approve
Revision history for this message
Ines Almeida (ines-almeida) wrote :

LGTM2!

review: Approve
Revision history for this message
Jürgen Gmach (jugmac00) :
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-2211-27-0.sql b/database/schema/patch-2211-27-0.sql
2new file mode 100644
3index 0000000..b0e0f69
4--- /dev/null
5+++ b/database/schema/patch-2211-27-0.sql
6@@ -0,0 +1,10 @@
7+-- Copyright 2024 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+ALTER TABLE Archive ADD COLUMN metadata_overrides jsonb;
13+
14+COMMENT ON COLUMN Archive.metadata_overrides IS 'A JSON object containing metadata overrides for this archive.';
15+
16+INSERT INTO LaunchpadDatabaseRevision VALUES (2211, 27, 0);

Subscribers

People subscribed via source and target branches

to status/vote changes: