Index: branches/5.1.x/core/install/install_schema.sql =================================================================== diff -u -N -r13140 -r13151 --- branches/5.1.x/core/install/install_schema.sql (.../install_schema.sql) (revision 13140) +++ branches/5.1.x/core/install/install_schema.sql (.../install_schema.sql) (revision 13151) @@ -112,11 +112,7 @@ FrontEndOnly tinyint(3) unsigned NOT NULL DEFAULT '0', FromUserId int(11) DEFAULT NULL, Module varchar(40) NOT NULL DEFAULT '', - l1_Description text, - l2_Description text, - l3_Description text, - l4_Description text, - l5_Description text, + Description text, `Type` int(11) NOT NULL DEFAULT '0', PRIMARY KEY (EventId), KEY `Type` (`Type`), @@ -185,18 +181,20 @@ CREATE TABLE Phrase ( Phrase varchar(255) NOT NULL DEFAULT '', PhraseKey varchar(255) NOT NULL DEFAULT '', - Translation text, + l1_Translation text, + l2_Translation text, + l3_Translation text, + l4_Translation text, + l5_Translation text, 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 DEFAULT NULL, 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 PhraseKey (PhraseKey) + KEY PhraseKey (PhraseKey), + KEY l1_Translation (l1_Translation(5)) ); CREATE TABLE PhraseCache (