# Linea21 DB patch - UTF-8 format
# patch v2.5.x To v2.6




# Adding `comment_title` field in table l21_comment
ALTER TABLE `l21_comment` ADD `comment_title` VARCHAR(500) NOT NULL DEFAULT '' AFTER `comment_url`;

# We regenerate FULLTEXT index 
ALTER TABLE `l21_comment` DROP INDEX `comment_index`, ADD FULLTEXT `comment_index` (`comment_name`, `comment_email`, `comment_body`, `comment_title`); 

# Adding `workcom_visible` field in table l21_workshop_report
ALTER TABLE `l21_workshop_report` ADD `workrep_visible` INT NOT NULL DEFAULT '1' AFTER `workrep_comment`; 

# Adding `sdii_mcolor`, `sdii_tcolor` fields in table l21_sdi_info
ALTER TABLE `l21_sdi_info` ADD `sdii_mcolor` VARCHAR(500) NOT NULL DEFAULT '#4AC0F2' AFTER `sdii_detail_viz`, ADD `sdii_tcolor` VARCHAR(100) NOT NULL DEFAULT '#FE9440' AFTER `sdii_mcolor`; 
