-- Copyright 2009 Canonical Ltd.  This software is licensed under the
-- GNU Affero General Public License version 3 (see the file LICENSE).


-- Index for PPA expiry
create index sbpph__dateremoved__idx ON SecureBinaryPackagePublishingHistory(dateremoved) WHERE dateremoved IS NOT NULL;

-- Looking for expired or unexpirable files
CREATE INDEX libraryfilealias__expires__idx ON LibraryFileAlias(expires);

insert into launchpaddatabaserevision values (2109, 21, 1);

