scripts

ALTER TABLE `book` CHANGE `pc_description` `pc_description_tmp` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL ,
CHANGE `ez_description` `ez_description_tmp` VARCHAR( 1024 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL ,
CHANGE `pc_summary` `pc_summary_tmp` VARCHAR( 1024 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL ,
CHANGE `ez_summary` `ez_summary_tmp` VARCHAR( 512 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL;

ALTER TABLE `book` CHANGE `pc_description_tmp` `pc_summary` VARCHAR( 1024 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL ,
CHANGE `ez_description_tmp` `ez_summary` VARCHAR( 512 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL ,
CHANGE `pc_summary_tmp` `pc_description` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL ,
CHANGE `ez_summary_tmp` `ez_description` VARCHAR( 1024 ) CHARACTER SET utf8 COLLATE utf8_unicode_ci NULL DEFAULT NULL;

CREATE DATABASE supportdb
DEFAULT CHARACTER SET UTF8
DEFAULT COLLATE utf8_unicode_ci;

GRANT ALL PRIVILEGES ON supportdb.* to 'supportdb'@'localhost'
IDENTIFIED BY 'supportdb' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON supportdb.* to 'supportdb'@'%'
IDENTIFIED BY 'supportdb' WITH GRANT OPTION;