1/** 2 * @version v1.7 3 * 4 * @schema c0fd16f4eaf99b920be9f7fc6ebead32 5 */ 6 7-- Increment varchar size for various fields... based on feedback from users. 8 9ALTER TABLE `%TABLE_PREFIX%session` 10 CHANGE `session_id` `session_id` VARCHAR(255) collate ascii_general_ci NOT NULL DEFAULT ''; 11 12ALTER TABLE `%TABLE_PREFIX%ticket` 13 CHANGE `name` `name` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', 14 CHANGE `email` `email` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', 15 CHANGE `subject` `subject` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '[no subject]'; 16 17ALTER TABLE `%TABLE_PREFIX%email` 18 CHANGE `email` `email` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', 19 CHANGE `name` `name` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT '', 20 CHANGE `userid` `userid` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, 21 CHANGE `mail_host` `mail_host` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, 22 CHANGE `smtp_host` `smtp_host` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL; 23 24ALTER TABLE `%TABLE_PREFIX%department` 25 CHANGE `dept_name` `dept_name` VARCHAR( 128 ) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL DEFAULT ''; 26 27UPDATE `%TABLE_PREFIX%config` 28 SET `schema_signature`='c0fd16f4eaf99b920be9f7fc6ebead32'; 29