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/ry_vue_4.X.sql | 4 ++-- 1 files changed, 2 insertions(+), 2 deletions(-) diff --git a/script/sql/ry_vue_4.X.sql b/script/sql/ry_vue_4.X.sql index 07fe33e..560f3fc 100644 --- a/script/sql/ry_vue_4.X.sql +++ b/script/sql/ry_vue_4.X.sql @@ -515,7 +515,7 @@ -- ---------------------------- drop table if exists sys_config; create table sys_config ( - config_id int(5) not null comment '鍙傛暟涓婚敭', + config_id bigint(20) not null comment '鍙傛暟涓婚敭', config_name varchar(100) default '' comment '鍙傛暟鍚嶇О', config_key varchar(100) default '' comment '鍙傛暟閿悕', config_value varchar(500) default '' comment '鍙傛暟閿��', @@ -559,7 +559,7 @@ -- ---------------------------- drop table if exists sys_notice; create table sys_notice ( - notice_id int(4) not null comment '鍏憡ID', + notice_id bigint(20) not null comment '鍏憡ID', notice_title varchar(50) not null comment '鍏憡鏍囬', notice_type char(1) not null comment '鍏憡绫诲瀷锛�1閫氱煡 2鍏憡锛�', notice_content longblob default null comment '鍏憡鍐呭', -- Gitblit v1.9.3