Merge lp:~wgrant/launchpad/tm-performance-0-db into lp:launchpad/db-devel

[William Grant]

Denormalise msgid and suggestiveness through a few Translations tables.

Denormalise msgid and suggestiveness through a few Translations tables.

TranslationTemplateItem gains msgid_singular and msgid_plural from POTMsgSet, for POFile:+translate filter performance.

TranslationMessage gains the msgid_* and suggestive columns for suggestion performance. POTMsgSet grows a suggestive flag too, to optimise TM cache updates. POTemplate.suggestive replaces the existing SuggestivePOTemplate for consistency.

[Stuart Bishop (stub)]

Ok.

review: Approve (db)

=== added file 'database/schema/patch-2209-62-1.sql'
--- database/schema/patch-2209-62-1.sql	1970-01-01 00:00:00 +0000
+++ database/schema/patch-2209-62-1.sql	2015-03-06 06:35:08 +0000
@@ -0,0 +1,16 @@
+-- Copyright 2015 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 translationtemplateitem
+    ADD COLUMN msgid_singular integer REFERENCES pomsgid,
+    ADD COLUMN msgid_plural integer REFERENCES pomsgid;
+ALTER TABLE potemplate ADD COLUMN suggestive bool;
+ALTER TABLE potmsgset ADD COLUMN suggestive bool;
+ALTER TABLE translationmessage
+    ADD COLUMN msgid_singular integer REFERENCES pomsgid,
+    ADD COLUMN msgid_plural integer REFERENCES pomsgid,
+    ADD COLUMN suggestive bool;
+
+INSERT INTO LaunchpadDatabaseRevision VALUES (2209, 62, 1);