~launchpad-pqm/launchpad/devel

« back to all changes in this revision

Viewing changes to database/schema/patch-2208-87-2.sql

[r=stub][no-qa] Add indicies for the denormalisation columns of SPPH
 and BPPH.

Show diffs side-by-side

added added

removed removed

Lines of Context:
 
1
-- Copyright 2011 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
CREATE INDEX binarypackagepublishinghistory__binarypackagename__idx ON BinaryPackagePublishingHistory(binarypackagename);
 
6
CREATE INDEX sourcepackagepublishinghistory__sourcepackagename__idx ON SourcePackagePublishingHistory(sourcepackagename);
 
7
 
 
8
INSERT INTO LaunchpadDatabaseRevision VALUES (2208, 87, 2);
 
9