hanchuanchuan / goInception

一个集审核、执行、备份及生成回滚语句于一身的MySQL运维工具
https://hanchuanchuan.github.io/goInception/
GNU General Public License v3.0
1.6k stars 545 forks source link

text类型不为not null时不提示警告 #593

Open beebol opened 1 year ago

beebol commented 1 year ago
CREATE TABLE `app_icon` ( `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID', `icon_name` varchar(64) NOT NULL DEFAULT '' COMMENT '名称', `file_name` varchar(20) NOT NULL DEFAULT '' COMMENT '文件名称', `introduce` varchar(64) NOT NULL DEFAULT '' COMMENT '介绍文案', `get_desc` varchar(64) NOT NULL DEFAULT '' COMMENT '获取方式', `app_version` varchar(64) NOT NULL DEFAULT '' COMMENT '已预埋版本号', `zip_file` text COMMENT 'app图标zip文件url', PRIMARY KEY (`id`) /*T![clustered_index] CLUSTERED */, UNIQUE KEY `uniq_file_name` (`file_name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='app'

如上表,会提示警告如下:

Column 'zip_file' in table 'app_icon' is not allowed to been nullable.

text/blob 可以不需要设置not null,如果设置not null就警告(这个已经有了),设置default 报异常