← Back to branch summary

~launchpad-pqm/launchpad/devel

« back to all changes in this revision

Viewing changes to database/schema/patch-2208-88-1.sql

[r=stub][no-qa] Add libraryfilealias__expires_content_not_null_idx to
 make librarian-gc not slow (DB patch applied live).

Show diffs side-by-side

added added

removed removed

Lines of Context:
database/schema/patch-2208-88-1.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
SET client_min_messages=ERROR;
 
4
 
 
5
CREATE INDEX libraryfilealias__expires_content_not_null_idx
 
6
    ON libraryfilealias(expires) WHERE content IS NOT NULL;
 
7
 
 
8
INSERT INTO LaunchpadDatabaseRevision VALUES (2208, 88, 1);