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 | 19 +++++++++++-------- 1 files changed, 11 insertions(+), 8 deletions(-) diff --git a/script/sql/ry_vue_4.X.sql b/script/sql/ry_vue_4.X.sql index 47f5da6..560f3fc 100644 --- a/script/sql/ry_vue_4.X.sql +++ b/script/sql/ry_vue_4.X.sql @@ -5,7 +5,7 @@ create table sys_dept ( dept_id bigint(20) not null comment '閮ㄩ棬id', parent_id bigint(20) default 0 comment '鐖堕儴闂╥d', - ancestors varchar(50) default '' comment '绁栫骇鍒楄〃', + ancestors varchar(500) default '' comment '绁栫骇鍒楄〃', dept_name varchar(30) default '' comment '閮ㄩ棬鍚嶇О', order_num int(4) default 0 comment '鏄剧ず椤哄簭', leader varchar(20) default null comment '璐熻矗浜�', @@ -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 '鍒楃被鍨�', @@ -668,6 +668,7 @@ bucket_name varchar(255) default '' comment '妗跺悕绉�', prefix varchar(255) default '' comment '鍓嶇紑', endpoint varchar(255) default '' comment '璁块棶绔欑偣', + domain varchar(255) default '' comment '鑷畾涔夊煙鍚�', is_https char(1) default 'N' comment '鏄惁https锛圷=鏄�,N=鍚︼級', region varchar(255) default '' comment '鍩�', status char(1) default '1' comment '鐘舵�侊紙0=姝ｅ父,1=鍋滅敤锛�', @@ -680,7 +681,9 @@ primary key (oss_config_id) ) engine=innodb comment='瀵硅薄瀛樺偍閰嶇疆琛�'; -insert into sys_oss_config values (1, 'minio', 'ruoyi', 'ruoyi123', 'ruoyi', '', 'http://localhost:9000', 'N', '', '0', '', 'admin', sysdate(), 'admin', sysdate(), NULL); -insert into sys_oss_config values (2, 'qiniu', 'XXXXXXXXXXXXXXX', 'XXXXXXXXXXXXXXX', 'ruoyi', '', 'http://XXX.XXXX.com', 'N', 'z0', '1', '', 'admin', sysdate(), 'admin', sysdate(), NULL); -insert into sys_oss_config values (3, 'aliyun', 'XXXXXXXXXXXXXXX', 'XXXXXXXXXXXXXXX', 'ruoyi', '', 'http://oss-cn-beijing.aliyuncs.com', 'N', '', '1', '', 'admin', sysdate(), 'admin', sysdate(), NULL); -insert into sys_oss_config values (4, 'qcloud', 'XXXXXXXXXXXXXXX', 'XXXXXXXXXXXXXXX', 'ruoyi-1250000000', '', 'http://cos.ap-beijing.myqcloud.com', 'N', 'ap-beijing', '1', '', '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', '127.0.0.1:9000', '','N', '', '1', '', 'admin', sysdate(), 'admin', sysdate(), NULL); + -- Gitblit v1.9.3