Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
beebol opened this issue Jul 28, 2023 · 0 comments
Open

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

beebol opened this issue Jul 28, 2023 · 0 comments

Comments

@beebol
Copy link

beebol commented Jul 28, 2023

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 报异常

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant