← Back to branch summary

~launchpad-pqm/launchpad/devel

« back to all changes in this revision

Viewing changes to database/schema/patch-2208-67-0.sql

Merge db-devel.

Show diffs side-by-side

added added

removed removed

Lines of Context:
database/schema/patch-2208-67-0.sql
 
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
 
 
15
INSERT INTO LaunchpadDatabaseRevision VALUES (2208, 67, 0);