From 181eaefea86ccef7ca60dd8e186ec8ece353ddf5 Mon Sep 17 00:00:00 2001 From: 疯狂的狮子Li <15040126243@163.com> Date: 星期二, 28 六月 2022 21:09:30 +0800 Subject: [PATCH] fix 修复 mysql sys_notice 与 sys_config 表主键类型长度不够问题 --- script/sql/update/update-4.1-4.2.sql | 4 ++++ 1 files changed, 4 insertions(+), 0 deletions(-) diff --git a/script/sql/update/update-4.1-4.2.sql b/script/sql/update/update-4.1-4.2.sql index 2d47677..1d9cf50 100644 --- a/script/sql/update/update-4.1-4.2.sql +++ b/script/sql/update/update-4.1-4.2.sql @@ -8,3 +8,7 @@ insert into sys_oss_config values (5, 'image', 'ruoyi', 'ruoyi123', 'ruoyi', 'image', '127.0.0.1:9000', 'N', '', '1', '', 'admin', sysdate(), 'admin', sysdate(), NULL, ''); alter table gen_table_column modify column table_id bigint(0) null default null COMMENT '褰掑睘琛ㄧ紪鍙�'; + +alter table sys_notice modify column notice_id bigint(0) not null COMMENT '鍏憡ID'; + +alter table sys_config modify column config_id bigint(0) not null COMMENT '鍙傛暟涓婚敭'; -- Gitblit v1.9.3