Merge ~andrey-fedoseev/launchpad:add-snap-build-target-architectures into launchpad:db-devel

Proposed by Andrey Fedoseev
Status: Merged
Approved by: Andrey Fedoseev
Approved revision: 125b7f203cfb3f69c43d05b71a9360af0c6e6253
Merge reported by: Otto Co-Pilot
Merged at revision: not available
Proposed branch: ~andrey-fedoseev/launchpad:add-snap-build-target-architectures
Merge into: launchpad:db-devel
Diff against target: 17 lines (+11/-0)
1 file modified
database/schema/patch-2210-48-0.sql (+11/-0)
Reviewer Review Type Date Requested Status
William Grant db Approve
Colin Watson (community) db Approve
Review via email: mp+423916@code.launchpad.net

Commit message

Add `SnapBuild.target_architectures` column

To post a comment you must log in.
Revision history for this message
Colin Watson (cjwatson) :
review: Approve (db)
Revision history for this message
Colin Watson (cjwatson) wrote :

Adding William for a second DB review.

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-48-0.sql b/database/schema/patch-2210-48-0.sql
2new file mode 100644
3index 0000000..af790aa
4--- /dev/null
5+++ b/database/schema/patch-2210-48-0.sql
6@@ -0,0 +1,11 @@
7+-- Copyright 2022 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 SnapBuild
13+ ADD COLUMN target_architectures text[];
14+
15+COMMENT ON COLUMN SnapBuild.target_architectures IS 'A list of target architectures for a snap build.';
16+
17+INSERT INTO LaunchpadDatabaseRevision VALUES (2210, 48, 0);

Subscribers

People subscribed via source and target branches

to status/vote changes: