title

Update database release Tiny Marbles 2.8

In case your are running Tiny Marbles CMS release 2.7 you have to update your existing database. Here you find the SQL commands as an example for the database MySQL. If you use an older release than 2.7 you have to follow all update scripts mentioned below (starting from release 2.6).

Create table:

CREATE TABLE `cms_tag_normalizedname` (
`tag_id` bigint(20) NOT NULL,
`normalizedname` varchar(255) NOT NULL,
`locale` varchar(255) NOT NULL,
PRIMARY KEY (`tag_id`,`locale`),
KEY `FK69C637FD15815823` (`tag_id`),
CONSTRAINT `FK69C637FD15815823` FOREIGN KEY (`tag_id`) REFERENCES `cms_tag` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `cms_image_publictag` (
`tag_id` bigint(20) NOT NULL,
`image_id` bigint(20) NOT NULL,
PRIMARY KEY (`tag_id`,`image_id`),
KEY `FK66B79BB716CB8AC2` (`image_id`),
KEY `FK66B79BB7ED848D65` (`tag_id`),
CONSTRAINT `FK66B79BB7ED848D65` FOREIGN KEY (`tag_id`) REFERENCES `cms_image` (`id`),
CONSTRAINT `FK66B79BB716CB8AC2` FOREIGN KEY (`image_id`) REFERENCES `cms_tag` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

CREATE TABLE `cms_keyword` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`name` varchar(255) DEFAULT NULL,
`normalizedName` varchar(255) DEFAULT NULL,
`type` varchar(255) NOT NULL,
`zone_id` bigint(20) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `FK8E78ECF3BD4ED661` (`zone_id`),
CONSTRAINT `FK8E78ECF3BD4ED661` FOREIGN KEY (`zone_id`) REFERENCES `mum_zone` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

CREATE TABLE `cms_imagedescription_keyword` (
`imagedescription_id` bigint(20) NOT NULL,
`keyword_id` bigint(20) NOT NULL,
PRIMARY KEY (`imagedescription_id`,`keyword_id`),
KEY `FKB41D5DA17C0C0543` (`keyword_id`),
KEY `FKB41D5DA1301A8790` (`imagedescription_id`),
CONSTRAINT `FKB41D5DA1301A8790` FOREIGN KEY (`imagedescription_id`)
REFERENCES `cms_imagedescription` (`id`),
CONSTRAINT `FKB41D5DA17C0C0543` FOREIGN KEY (`keyword_id`) REFERENCES `cms_keyword` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Update table:

ALTER TABLE `cms_tag` ADD COLUMN `showPublic` BIT(1) NULL AFTER `zone_id`;
ALTER TABLE `cms_imagedescription` CHANGE `description` `description` LONGTEXT NULL;
ALTER TABLE `cms_imagedescription` ADD COLUMN `caption` TEXT NULL AFTER `title`;
ALTER TABLE `cms_articlecategory` ADD COLUMN `type` INT(11) NULL AFTER `isLink`;
ALTER TABLE `cms_articlecategory` ADD COLUMN `linkTarget` VARCHAR(255) NULL AFTER `type`,
ADD COLUMN `linkValue` VARCHAR(255) NULL AFTER `linkTarget`;
ALTER TABLE `cms_articlecategory` DROP COLUMN `isLink`;
ALTER TABLE `cms_imagedescription` ADD COLUMN `normalizedName` VARCHAR(255) NULL AFTER
`title`;
ALTER TABLE `cms_image` ADD COLUMN `views` BIGINT(20) NOT NULL AFTER `zone_id`;

UPDATE `cms_imagedescription` SET description="";
UPDATE `cms_imagedescription` SET caption="";
UPDATE `cms_imagedescription` SET normalizedName="";
UPDATE `cms_image` SET views='0';
UPDATE `cms_articlecategory` SET linkTarget="";
UPDATE `cms_articlecategory` SET linkValue="";
UPDATE `cms_tag` SET showPublic=false;
UPDATE `cms_articlecategory` SET type='0';

Update scripts:

You have to fill in some data to the new fields and tables in your database. Furthermore you have to create new image sizes for the image library. Therefore you have to run the following scripts which comes with the release 2.8. To start the scripts you need a working deployment of the release 2.8 with the SQL updates above. After login in the admin area of Tiny Marbles CMS you call following actions:

http:// [your domain] /admin/tag/updateAllTags.action
http:// [your domain] /admin/image/updateImageLibrary.action

In both cases you should get a success message after the scripts are finished. Attention: the script for the image library you have to run for each zone of your installation. This procedure can take a couple of minutes in case your image library has a lot of images stored.


title

Update database release Tiny Marbles 2.7

In case your are running already either a Tiny Marbles CMS release 2.6 or 2.6.1 you have to update in both cases your existing database. Here you find the SQL commands as an example for the database MySQL:

Create table:

CREATE TABLE 'cms_articlecategory_normalizedname' (
'articlecategory_id' bigint(20) NOT NULL,
'normalizedName' varchar(255) DEFAULT NULL,
'locale' varchar(255) NOT NULL,
PRIMARY KEY ('articlecategory_id','locale'),
KEY 'FKE16657834381FBC5' ('articlecategory_id'),
CONSTRAINT 'FKE16657834381FBC5' FOREIGN KEY ('articlecategory_id')
REFERENCES 'cms_articlecategory' ('id')
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Update table:

ALTER TABLE `cms`.`cms_document` ADD COLUMN `systemId` VARCHAR(255) NULL AFTER `zone_id`;

title

Update database release Tiny Marbles CMS 2.6

In case your are running already either a Tiny Marbles CMS release 2.5 or the CMS modul release 2.5 you have to update in both cases your existing database. Here you find the SQL commands as an example for the database MySQL:

Create table:

CREATE TABLE 'cms_comments' (
'id' bigint(20) NOT NULL AUTO_INCREMENT,
'answer' longtext,
'content' longtext,
'date' bigint(20),
'email' varchar(255) DEFAULT NULL,
'website' varchar(255) DEFAULT NULL,
'locale' varchar(255) DEFAULT NULL,
'name' varchar(255) DEFAULT NULL,
'newEntry' tinyint(4) NOT NULL,
'published' bit(1) DEFAULT NULL,
'signature' varchar(255) DEFAULT NULL,
'article_id' bigint(20) DEFAULT NULL,
'zone_id' bigint(20) DEFAULT NULL,
PRIMARY KEY ('id'),
KEY 'FKFD8DF02AD498E8FF' ('article_id'),
KEY 'FKFD8DF02ABD4ED661' ('zone_id'),
CONSTRAINT 'FKFD8DF02ABD4ED661' FOREIGN KEY ('zone_id') REFERENCES 'mum_zone' ('id'),
CONSTRAINT 'FKFD8DF02AD498E8FF' FOREIGN KEY ('article_id') REFERENCES 'cms_article' ('id')
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

Update table:

ALTER TABLE cms_articlecategory ADD COLUMN isLink BIT(1) NULL AFTER action;
UPDATE cms_articlecategory SET isLink = FALSE;
ALTER TABLE mum_user ADD COLUMN email VARCHAR(255) NULL AFTER signature;
ALTER TABLE cms_article ADD COLUMN showImageDescription BIT(1) NULL AFTER isPublished;
UPDATE cms_article SET showImageDescription = FALSE;
ALTER TABLE cms_article ADD COLUMN closeComments BIT(1) NULL AFTER showImageDescription;
UPDATE cms_article SET closeComments = FALSE;
ALTER TABLE mum_zone ADD COLUMN defaultLocale VARCHAR(255) NULL AFTER systemId;
UPDATE mum_zone SET defaultLocale = 'none';
ALTER TABLE mum_zone ADD COLUMN defaultAdminLocale VARCHAR(255) NULL AFTER defaultLocale;
UPDATE mum_zone SET defaultAdminLocale = 'none';
UPDATE cms_articlecategory SET ACTION = 'news' WHERE layout = 'News';
UPDATE cms_articlecategory SET ACTION = 'html' WHERE layout = 'Html';
UPDATE cms_articlecategory SET ACTION = 'listnews' WHERE layout = 'ListNews';

Insert for each zone, using 'your_zone_id', step 1 - 5:

1) Create board_id: INSERT INTO mum_board (defaultSize, freemarkerTmpl, systemId, zone_id)
VALUES ('1', '/admin/article/comments/dashboard.ftl', 'recent_comments', 'your_zone_id');
2) Create authorization_id: INSERT INTO mum_board_permissions (use_or, board_id)
VALUES ('1', 'board_id');
3) INSERT INTO mum_board_authorization (mum_board_id, authorization_id, talos_category)
VALUES ('board_id', 'authorization_id', 'org.cws.cms.model.article.version.News');
4) INSERT INTO mum_board_single_permissions (Permissions_id, talos_permission)
VALUES ('authorization_id', 'org.cws.cms.model.article.version.News.list');
5) INSERT INTO mum_board_single_permissions (Permissions_id, talos_permission)
VALUES ('authorization_id', 'org.cws.cms.model.article.version.News.my'); 

watch world cup 2014 online . benefits of coq10