Index: branches/5.0.x/core/install/install_schema.sql
===================================================================
diff -u -r12399 -r12591
--- branches/5.0.x/core/install/install_schema.sql	(.../install_schema.sql)	(revision 12399)
+++ branches/5.0.x/core/install/install_schema.sql	(.../install_schema.sql)	(revision 12591)
@@ -177,18 +177,20 @@
 );
 
 CREATE TABLE Phrase (
-  Phrase varchar(255) NOT NULL default '',
+  Phrase varchar(255) NOT NULL DEFAULT '',
+  PhraseKey varchar(255) NOT NULL,
   Translation text NOT NULL,
-  PhraseType int(11) NOT NULL default '0',
-  PhraseId int(11) NOT NULL auto_increment,
-  LanguageId int(11) NOT NULL default '0',
-  LastChanged int(10) unsigned NOT NULL default '0',
-  LastChangeIP varchar(15) NOT NULL default '',
-  Module varchar(30) NOT NULL default 'In-Portal',
-  PRIMARY KEY  (PhraseId),
+  PhraseType int(11) NOT NULL DEFAULT '0',
+  PhraseId int(11) NOT NULL AUTO_INCREMENT,
+  LanguageId int(11) NOT NULL DEFAULT '0',
+  LastChanged int(10) unsigned NOT NULL DEFAULT '0',
+  LastChangeIP varchar(15) NOT NULL DEFAULT '',
+  Module varchar(30) NOT NULL DEFAULT 'In-Portal',
+  PRIMARY KEY (PhraseId),
   UNIQUE KEY LanguageId_2 (LanguageId,Phrase),
   KEY LanguageId (LanguageId),
-  KEY Phrase_Index (Phrase)
+  KEY Phrase_Index (Phrase),
+  KEY PhraseKey (PhraseKey)
 );
 
 CREATE TABLE PhraseCache (
