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 | 10 +++++----- 1 files changed, 5 insertions(+), 5 deletions(-) diff --git a/script/sql/ry_vue_4.X.sql b/script/sql/ry_vue_4.X.sql index 2384b14..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 '鍏憡鍐呭', @@ -614,7 +614,7 @@ drop table if exists gen_table_column; create table gen_table_column ( column_id bigint(20) not null comment '缂栧彿', - table_id varchar(64) comment '褰掑睘琛ㄧ紪鍙�', + table_id bigint(20) comment '褰掑睘琛ㄧ紪鍙�', column_name varchar(200) comment '鍒楀悕绉�', column_comment varchar(500) comment '鍒楁弿杩�', column_type varchar(100) comment '鍒楃被鍨�', @@ -681,9 +681,9 @@ primary key (oss_config_id) ) engine=innodb comment='瀵硅薄瀛樺偍閰嶇疆琛�'; -insert into sys_oss_config values (1, 'minio', 'ruoyi', 'ruoyi123', 'ruoyi', '', 'localhost:9000', '','N', '', '0', '', 'admin', sysdate(), 'admin', sysdate(), NULL); +insert into sys_oss_config values (1, 'minio', 'ruoyi', 'ruoyi123', 'ruoyi', '', '127.0.0.1:9000', '','N', '', '0', '', 'admin', sysdate(), 'admin', sysdate(), NULL); insert into sys_oss_config values (2, 'qiniu', 'XXXXXXXXXXXXXXX', 'XXXXXXXXXXXXXXX', 'ruoyi', '', 's3-cn-north-1.qiniucs.com', '','N', '', '1', '', 'admin', sysdate(), 'admin', sysdate(), NULL); insert into sys_oss_config values (3, 'aliyun', 'XXXXXXXXXXXXXXX', 'XXXXXXXXXXXXXXX', 'ruoyi', '', 'oss-cn-beijing.aliyuncs.com', '','N', '', '1', '', 'admin', sysdate(), 'admin', sysdate(), NULL); insert into sys_oss_config values (4, 'qcloud', 'XXXXXXXXXXXXXXX', 'XXXXXXXXXXXXXXX', 'ruoyi-1250000000', '', 'cos.ap-beijing.myqcloud.com', '','N', 'ap-beijing', '1', '', 'admin', sysdate(), 'admin', sysdate(), NULL); -insert into sys_oss_config values (5, 'image', 'ruoyi', 'ruoyi123', 'ruoyi', 'image', 'localhost:9000', '','N', '', '1', '', 'admin', sysdate(), 'admin', sysdate(), NULL); +insert into sys_oss_config values (5, 'image', 'ruoyi', 'ruoyi123', 'ruoyi', 'image', '127.0.0.1:9000', '','N', '', '1', '', 'admin', sysdate(), 'admin', sysdate(), NULL); -- Gitblit v1.9.3