Index: branches/5.2.x/core/install/install_schema.sql =================================================================== diff -u -N -r14789 -r14853 --- branches/5.2.x/core/install/install_schema.sql (.../install_schema.sql) (revision 14789) +++ branches/5.2.x/core/install/install_schema.sql (.../install_schema.sql) (revision 14853) @@ -1242,4 +1242,34 @@ KEY ResponseDate (ResponseDate), KEY ResponseHttpCode (ResponseHttpCode), KEY CurlError (CurlError) +); + +CREATE TABLE PromoBlocks ( + BlockId int(11) NOT NULL AUTO_INCREMENT, + Title varchar(50) NOT NULL DEFAULT '', + Priority int(11) NOT NULL DEFAULT '0', + Status tinyint(1) NOT NULL DEFAULT '0', + 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) NOT NULL DEFAULT '0', + ExternalLink varchar(255) NOT NULL DEFAULT '', + OpenInNewWindow tinyint(3) unsigned NOT NULL DEFAULT '0', + ScheduleFromDate int(11) DEFAULT NULL, + ScheduleToDate int(11) DEFAULT NULL, + NumberOfClicks int(11) NOT NULL DEFAULT '0', + NumberOfViews int(11) NOT NULL DEFAULT '0', + Sticky tinyint(1) NOT NULL DEFAULT '0', + Html text, + l1_Html text, + l2_Html text, + l3_Html text, + l4_Html text, + l5_Html text, + PRIMARY KEY (BlockId), + KEY OpenInNewWindow (OpenInNewWindow) ); \ No newline at end of file