Index: branches/5.2.x/core/install/install_schema.sql =================================================================== diff -u -r15363 -r15373 --- branches/5.2.x/core/install/install_schema.sql (.../install_schema.sql) (revision 15363) +++ branches/5.2.x/core/install/install_schema.sql (.../install_schema.sql) (revision 15373) @@ -1324,17 +1324,26 @@ CREATE TABLE PromoBlocks ( BlockId int(11) NOT NULL AUTO_INCREMENT, - Title varchar(50) NOT NULL DEFAULT '', + l1_Title varchar(50) NOT NULL DEFAULT '', + l2_Title varchar(50) NOT NULL DEFAULT '', + l3_Title varchar(50) NOT NULL DEFAULT '', + l4_Title varchar(50) NOT NULL DEFAULT '', + l5_Title varchar(50) NOT NULL DEFAULT '', + l1_ButtonText varchar(255) NOT NULL DEFAULT '', + l2_ButtonText varchar(255) NOT NULL DEFAULT '', + l3_ButtonText varchar(255) NOT NULL DEFAULT '', + l4_ButtonText varchar(255) NOT NULL DEFAULT '', + l5_ButtonText varchar(255) NOT NULL DEFAULT '', Priority int(11) NOT NULL DEFAULT '0', - Status tinyint(1) NOT NULL DEFAULT '1', + `Status` tinyint(1) NOT NULL DEFAULT '1', l1_Image varchar(255) NOT NULL DEFAULT '', l2_Image varchar(255) NOT NULL DEFAULT '', l3_Image varchar(255) NOT NULL DEFAULT '', l4_Image varchar(255) NOT NULL DEFAULT '', l5_Image varchar(255) NOT NULL DEFAULT '', CSSClassName varchar(255) NOT NULL DEFAULT '', LinkType tinyint(1) NOT NULL DEFAULT '1', - CategoryId INT(11) DEFAULT NULL, + CategoryId int(11) DEFAULT NULL, ExternalLink varchar(255) NOT NULL DEFAULT '', OpenInNewWindow tinyint(3) unsigned NOT NULL DEFAULT '0', ScheduleFromDate int(11) DEFAULT NULL, @@ -1350,7 +1359,17 @@ PromoBlockGroupId int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (BlockId), KEY OpenInNewWindow (OpenInNewWindow), - KEY PromoBlockGroupId (PromoBlockGroupId) + KEY PromoBlockGroupId (PromoBlockGroupId), + KEY l1_Title (l1_Title(5)), + KEY l2_Title (l2_Title(5)), + KEY l3_Title (l3_Title(5)), + KEY l4_Title (l4_Title(5)), + KEY l5_Title (l5_Title(5)), + KEY l1_ButtonText (l1_ButtonText(5)), + KEY l2_ButtonText (l2_ButtonText(5)), + KEY l3_ButtonText (l3_ButtonText(5)), + KEY l4_ButtonText (l4_ButtonText(5)), + KEY l5_ButtonText (l5_ButtonText(5)) ); CREATE TABLE PromoBlockGroups (