← Back to branch summary

~launchpad-pqm/launchpad/devel

« back to all changes in this revision

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

  • Committer: Raphael Badin
  • Date: 2011-05-20 09:42:59 UTC
  • mto: (7675.1045.395 db-devel)
  • mto: This revision was merged to the branch mainline in revision 13163.
  • Revision ID: raphael.badin@canonical.com-20110520094259-ukdthnmw19o3sxfe
Add ordering for DSPs.

Show diffs side-by-side

added added

removed removed

Lines of Context:
database/schema/patch-2208-99-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
-- Add a column to order DSP (will be used to control the build order
 
7
-- for overlays).
 
8
ALTER TABLE DistroSeriesParent
 
9
    ADD COLUMN ordering INTEGER NOT NULL DEFAULT 1;
 
10
 
 
11
-- Update existing DSPs.
 
12
UPDATE DistroSeriesParent
 
13
    SET ordering = 1;
 
14
 
 
15
-- Create index.
 
16
CREATE INDEX distroseriesparent__ordering
 
17
    ON DistroSeriesParent (ordering);
 
18
 
 
19
INSERT INTO LaunchpadDatabaseRevision VALUES (2208, 99, 0);