|
7675.1127.1
by Raphael Badin
Adapt DSD's unique constraint to multi-parents case. |
1 |
-- Copyright 2011 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 |
-- In DistroSeriesDifference, the constraint UNIQUE (derived_series, source_package_name)
|
|
7 |
-- should be UNIQUE (derived_series, parent_series, source_package_name).
|
|
8 |
ALTER TABLE DistroSeriesDifference |
|
9 |
DROP CONSTRAINT "distroseriesdifference__derived_series__source_package_name__key"; |
|
10 |
||
11 |
ALTER TABLE DistroSeriesDifference |
|
12 |
ADD CONSTRAINT distroseriesdifference__derived_series__parent_series__source_package_name__key |
|
13 |
UNIQUE (derived_series, parent_series, source_package_name); |
|
14 |
||
|
7675.1127.2
by Raphael Badin
Patch 67. |
15 |
INSERT INTO LaunchpadDatabaseRevision VALUES (2208, 67, 0); |