|
7675.368.1
by William Grant
Add DB patch for SourcePackageFormatSelection. |
1 |
-- Copyright 2009 Canonical Ltd. This software is licensed under the
|
2 |
-- GNU Affero General Public License version 3 (see the file LICENSE).
|
|
3 |
||
4 |
SET client_min_messages=ERROR; |
|
5 |
||
6 |
CREATE TABLE sourcepackageformatselection ( |
|
7 |
id serial PRIMARY KEY, |
|
8 |
distroseries integer NOT NULL |
|
9 |
CONSTRAINT sourceformatselection__distroseries__fk |
|
10 |
REFERENCES distroseries, |
|
11 |
format integer NOT NULL, |
|
12 |
CONSTRAINT sourceformatselection__distroseries__format__key |
|
13 |
UNIQUE (distroseries, format) |
|
14 |
);
|
|
15 |
||
16 |
-- Allow all series to accept format 1.0 by default.
|
|
17 |
INSERT INTO sourcepackageformatselection (distroseries, format) |
|
18 |
SELECT id, 0 AS format FROM distroseries; |
|
19 |
||
|
7675.368.2
by William Grant
Renumber patch to 2207-08-0. |
20 |
INSERT INTO LaunchpadDatabaseRevision VALUES (2207, 08, 0); |