ALTER TABLE `pre_forum_collection` CHANGE `lastsubject` `lastsubject` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '';
ALTER TABLE `pre_forum_forumrecommend` CHANGE `subject` `subject` CHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;
ALTER TABLE `pre_forum_post` CHANGE `subject` `subject` VARCHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;
ALTER TABLE `pre_forum_rsscache` CHANGE `subject` `subject` CHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;
ALTER TABLE `pre_forum_thread` CHANGE `subject` `subject` CHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL;
ALTER TABLE `pre_home_blog` CHANGE `subject` `subject` CHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '';
ALTER TABLE `pre_portal_rsscache` CHANGE `subject` `subject` CHAR(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '';
INSERT INTO pre_common_setting VALUES ('maxsubjectsize','80');
INSERT INTO pre_common_setting VALUES ('minsubjectsize','1');