本文的三条sql为修改小说相关表的字段长度,可选更新不会影响程序使用。
//数据量大的用户,请慎用。
ALTER TABLE `wm_novel_content` CHANGE `content` `content` MEDIUMTEXT NOT NULL COMMENT '内容';
ALTER TABLE `wm_novel_chapter` CHANGE `chapter_name` `chapter_name` VARCHAR(100) CHARSET utf8 COLLATE utf8_general_ci NULL COMMENT '章节名';
ALTER TABLE `wm_novel_novel` CHANGE `novel_name` `novel_name` VARCHAR(100) CHARSET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '小说名', CHANGE `novel_wordname` `novel_wordname` VARCHAR(50) CHARSET utf8 COLLATE utf8_general_ci NULL COMMENT '全文字书名', CHANGE `novel_author` `novel_author` VARCHAR(50) CHARSET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '作者', CHANGE `novel_cover` `novel_cover` VARCHAR(250) CHARSET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '封面', CHANGE `novel_info` `novel_info` VARCHAR(2000) CHARSET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '小说简介', CHANGE `novel_tags` `novel_tags` VARCHAR(80) CHARSET utf8 COLLATE utf8_general_ci NULL COMMENT '小说标签';