Index: branches/5.2.x/core/install/install_schema.sql =================================================================== diff -u -N -r14892 -r14929 --- branches/5.2.x/core/install/install_schema.sql (.../install_schema.sql) (revision 14892) +++ branches/5.2.x/core/install/install_schema.sql (.../install_schema.sql) (revision 14929) @@ -478,6 +478,7 @@ LiveRevisionNumber int(11) NOT NULL DEFAULT '1', DirectLinkEnabled tinyint(4) NOT NULL DEFAULT '1', DirectLinkAuthKey varchar(20) NOT NULL, + PromoBlockGroupId int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (CategoryId), UNIQUE KEY ResourceId (ResourceId), KEY ParentId (ParentId), @@ -506,7 +507,8 @@ KEY OverridePageCacheKey (OverridePageCacheKey), KEY PageExpiration (PageExpiration), KEY Protected (Protected), - KEY LiveRevisionNumber (LiveRevisionNumber) + KEY LiveRevisionNumber (LiveRevisionNumber), + KEY PromoBlockGroupId (PromoBlockGroupId) ); CREATE TABLE CategoryCustomData ( @@ -1304,6 +1306,21 @@ l3_Html text, l4_Html text, l5_Html text, + PromoBlockGroupId int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (BlockId), - KEY OpenInNewWindow (OpenInNewWindow) + KEY OpenInNewWindow (OpenInNewWindow), + KEY PromoBlockGroupId (PromoBlockGroupId) +); + +CREATE TABLE PromoBlockGroups ( + PromoBlockGroupId int(11) NOT NULL AUTO_INCREMENT, + Title varchar(255) NOT NULL DEFAULT '', + CreatedOn int(10) unsigned DEFAULT NULL, + `Status` tinyint(1) NOT NULL DEFAULT '1', + RotationDelay decimal(9,2) DEFAULT NULL, + TransitionTime decimal(9,2) DEFAULT NULL, + TransitionControls tinyint(1) NOT NULL DEFAULT '1', + TransitionEffect varchar(255) NOT NULL DEFAULT '', + TransitionEffectCustom varchar(255) NOT NULL DEFAULT '', + PRIMARY KEY (PromoBlockGroupId) ); \ No newline at end of file