Index: branches/5.3.x/core/install/install_schema.sql =================================================================== diff -u -N -r15578 -r15584 --- branches/5.3.x/core/install/install_schema.sql (.../install_schema.sql) (revision 15578) +++ branches/5.3.x/core/install/install_schema.sql (.../install_schema.sql) (revision 15584) @@ -110,6 +110,11 @@ l3_PlainTextBody longtext, l4_PlainTextBody longtext, l5_PlainTextBody longtext, + l1_TranslateFrom int(11) NOT NULL DEFAULT '0', + l2_TranslateFrom int(11) NOT NULL DEFAULT '0', + l3_TranslateFrom int(11) NOT NULL DEFAULT '0', + l4_TranslateFrom int(11) NOT NULL DEFAULT '0', + l5_TranslateFrom int(11) NOT NULL DEFAULT '0', Headers text, Enabled int(11) NOT NULL DEFAULT '1', FrontEndOnly tinyint(3) unsigned NOT NULL DEFAULT '0', @@ -137,7 +142,8 @@ KEY l2_PlainTextBody (l2_PlainTextBody(5)), KEY l3_PlainTextBody (l3_PlainTextBody(5)), KEY l4_PlainTextBody (l4_PlainTextBody(5)), - KEY l5_PlainTextBody (l5_PlainTextBody(5)) + KEY l5_PlainTextBody (l5_PlainTextBody(5)), + KEY l1_TranslateFrom (l1_TranslateFrom) ); CREATE TABLE SystemEventSubscriptions ( @@ -236,6 +242,11 @@ l3_ColumnTranslation text, l4_ColumnTranslation text, l5_ColumnTranslation text, + l1_TranslateFrom int(11) NOT NULL DEFAULT '0', + l2_TranslateFrom int(11) NOT NULL DEFAULT '0', + l3_TranslateFrom int(11) NOT NULL DEFAULT '0', + l4_TranslateFrom int(11) NOT NULL DEFAULT '0', + l5_TranslateFrom int(11) NOT NULL DEFAULT '0', PhraseType int(11) NOT NULL DEFAULT '0', LastChanged int(10) unsigned DEFAULT NULL, LastChangeIP varchar(15) NOT NULL DEFAULT '', @@ -245,7 +256,8 @@ KEY PhraseKey (PhraseKey), KEY l1_Translation (l1_Translation(5)), KEY l1_HintTranslation (l1_HintTranslation(5)), - KEY l1_ColumnTranslation (l1_ColumnTranslation(5)) + KEY l1_ColumnTranslation (l1_ColumnTranslation(5)), + KEY l1_TranslateFrom (l1_TranslateFrom) ); CREATE TABLE PhraseCache (