#405 (bug) - CMS Image editor bug - "View original" button text keep
adding new image size on each click
#403 (new feature) - Add facility for users to assign tags to site
sections and to control which sections are visible based on those tags
#404 (new feature) - Implement bootstrap as a layout/css provider
Requires following SQL update (pelorous database):
DROP TABLE IF EXISTS `userWorkspacePreference`;
CREATE TABLE `userWorkspacePreference` (
`userId` SMALLINT UNSIGNED NOT NULL DEFAULT 0 ,
`workspaceId` SMALLINT UNSIGNED NOT NULL DEFAULT 0 ,
`preference` VARCHAR(255) NOT NULL ,
`value` LONGTEXT NULL ,
PRIMARY KEY (`userId`, `workspaceId`, `preference`) ,
INDEX `userId_idx` (`userId` ASC, `workspaceId` ASC) ,
INDEX `workspaceId_idx` (`workspaceId` ASC) )
ENGINE=InnoDB;
Requires following SQL update (site_manager module):
DROP TABLE IF EXISTS `site_sectionSectionTag`;
CREATE TABLE `site_sectionSectionTag` (
`sectionId` INT UNSIGNED NOT NULL DEFAULT 0 ,
`sectionTagId` INT UNSIGNED NOT NULL DEFAULT 0 ,
PRIMARY KEY (`sectionId`, `sectionTagId`) ,
INDEX `sectionId_idx` (`sectionId` ASC) ,
INDEX `sectionTagId_idx` (`sectionTagId` ASC) )
ENGINE = InnoDB;
DROP TABLE IF EXISTS `site_sectionTag`;
CREATE TABLE `site_sectionTag` (
`sectionTagId` INT UNSIGNED NOT NULL AUTO_INCREMENT ,
`tag` VARCHAR(255) NULL ,
PRIMARY KEY (`sectionTagId`) )
ENGINE = InnoDB;
ALTER TABLE `site_layoutSite` ADD COLUMN `rowConfig` LONGTEXT NULL
AFTER `siteId` ;
ALTER TABLE `site_layout` ADD COLUMN `handler` ENUM('bootstrap','yui2')
NOT NULL DEFAULT 'yui2' AFTER `layoutId` ;
UPDATE site_layout SET handler='yui2';
UPDATE `site_item` SET `handler`='Pelorous_Site_Layout_Yui2' WHERE
`handler`='Pelorous_Site_Layout';
UPDATE `_publish_updateLogQueryData` SET
`params`=REPLACE(params,'Pelorous_Site_Layout"',
'Pelorous_Site_Layout_Yui2"') where params like
'%Pelorous_Site_Layout"%';
ALTER TABLE `site_contentContainer` ADD COLUMN `config` text NOT NULL
AFTER `primary`;