Merge lp:~stevenk/launchpad/db-searchablenames-for-pu into lp:launchpad/db-devel

[Steve Kowalik]

Add a searchable_names column to PackageUpload. This is supplemented by a trigram index that allows us to do efficient substring matching. This column will be set by methods on PackageUpload, such as addSource() and addBuild() as well as a garbo job to populate old records.

[Stuart Bishop (stub)]

Fine for the ALTER TABLE, but the index creation needs to be done in a separate patch (even if all 4 million+ rows are all NULL, the index build is still to slow for fast downtime).

Best time to build the index is after the column has been populated if you are going to backfill.

review: Approve (db)

=== added file 'database/schema/patch-2209-40-0.sql'
--- database/schema/patch-2209-40-0.sql	1970-01-01 00:00:00 +0000
+++ database/schema/patch-2209-40-0.sql	2012-11-28 12:35:24 +0000
@@ -0,0 +1,8 @@
+-- Copyright 2012 Canonical Ltd.  This software is licensed under the
+-- GNU Affero General Public License version 3 (see the file LICENSE).
+
+SET client_min_messages=ERROR;
+
+ALTER TABLE packageupload ADD COLUMN searchable_names TEXT;
+
+INSERT INTO LaunchpadDatabaseRevision VALUES (2209, 40, 0);