~launchpad-pqm/launchpad/devel

7675.912.1 by Abel Deuring
Add a column file_bug_duplicate_search to the tables Product and DistributionSourcePackage.
1
-- Copyright 2010 Canonical Ltd.  This software is licensed under the
2
-- GNU Affero General Public License version 3 (see the file LICENSE).
3
SET client_min_messages=ERROR;
4
5
ALTER TABLE Product
7675.912.3 by Abel Deuring
renamed the new columns from disable.* to enable.*; renamed DB patch file
6
    ADD COLUMN enable_bugfiling_duplicate_search
7
        BOOLEAN NOT NULL DEFAULT True;
7675.912.1 by Abel Deuring
Add a column file_bug_duplicate_search to the tables Product and DistributionSourcePackage.
8
ALTER TABLE DistributionSourcePackage
7675.912.3 by Abel Deuring
renamed the new columns from disable.* to enable.*; renamed DB patch file
9
    ADD COLUMN enable_bugfiling_duplicate_search
10
        BOOLEAN NOT NULL DEFAULT True;
11
12
CLUSTER DistributionSourcePackage USING
13
    distributionpackage__sourcepackagename__distribution__key;
14
CLUSTER Product USING product_name_key;
15
16
INSERT INTO LaunchpadDatabaseRevision VALUES (2208, 31, 0);