From 78290128e77c56ef1ae236b2f4128d49df4d8773 Mon Sep 17 00:00:00 2001 From: 疯狂的狮子li <15040126243@163.com> Date: 星期四, 03 十一月 2022 11:38:40 +0800 Subject: [PATCH] add 增加 4.3-4.4 更新 sql 文件 --- script/sql/ry_vue_4.X.sql | 19 ++++++++++--------- 1 files changed, 10 insertions(+), 9 deletions(-) diff --git a/script/sql/ry_vue_4.X.sql b/script/sql/ry_vue_4.X.sql index 2bb428e..d8bac36 100644 --- a/script/sql/ry_vue_4.X.sql +++ b/script/sql/ry_vue_4.X.sql @@ -141,7 +141,7 @@ is_frame int(1) default 1 comment '鏄惁涓哄閾撅紙0鏄� 1鍚︼級', is_cache int(1) default 0 comment '鏄惁缂撳瓨锛�0缂撳瓨 1涓嶇紦瀛橈級', menu_type char(1) default '' comment '鑿滃崟绫诲瀷锛圡鐩綍 C鑿滃崟 F鎸夐挳锛�', - visible char(1) default 0 comment '鑿滃崟鐘舵�侊紙0鏄剧ず 1闅愯棌锛�', + visible char(1) default 0 comment '鏄剧ず鐘舵�侊紙0鏄剧ず 1闅愯棌锛�', status char(1) default 0 comment '鑿滃崟鐘舵�侊紙0姝ｅ父 1鍋滅敤锛�', perms varchar(100) default null comment '鏉冮檺鏍囪瘑', icon varchar(100) default '#' comment '鑿滃崟鍥炬爣', @@ -499,6 +499,7 @@ insert into sys_dict_data values(15, 2, '鍏憡', '2', 'sys_notice_type', '', 'success', 'N', '0', 'admin', sysdate(), '', null, '鍏憡'); insert into sys_dict_data values(16, 1, '姝ｅ父', '0', 'sys_notice_status', '', 'primary', 'Y', '0', 'admin', sysdate(), '', null, '姝ｅ父鐘舵��'); insert into sys_dict_data values(17, 2, '鍏抽棴', '1', 'sys_notice_status', '', 'danger', 'N', '0', 'admin', sysdate(), '', null, '鍏抽棴鐘舵��'); +insert into sys_dict_data values(29, 99, '鍏朵粬', '0', 'sys_oper_type', '', 'info', 'N', '0', 'admin', sysdate(), '', null, '鍏朵粬鎿嶄綔'); insert into sys_dict_data values(18, 1, '鏂板', '1', 'sys_oper_type', '', 'info', 'N', '0', 'admin', sysdate(), '', null, '鏂板鎿嶄綔'); insert into sys_dict_data values(19, 2, '淇敼', '2', 'sys_oper_type', '', 'info', 'N', '0', 'admin', sysdate(), '', null, '淇敼鎿嶄綔'); insert into sys_dict_data values(20, 3, '鍒犻櫎', '3', 'sys_oper_type', '', 'danger', 'N', '0', 'admin', sysdate(), '', null, '鍒犻櫎鎿嶄綔'); @@ -654,7 +655,7 @@ create_by varchar(64) default '' comment '涓婁紶浜�', update_time datetime default null comment '鏇存柊鏃堕棿', update_by varchar(64) default '' comment '鏇存柊浜�', - service varchar(10) not null default 'minio' comment '鏈嶅姟鍟�', + service varchar(20) not null default 'minio' comment '鏈嶅姟鍟�', primary key (oss_id) ) engine=innodb comment ='OSS瀵硅薄瀛樺偍琛�'; @@ -664,7 +665,7 @@ drop table if exists sys_oss_config; create table sys_oss_config ( oss_config_id bigint(20) not null comment '涓诲缓', - config_key varchar(255) not null default '' comment '閰嶇疆key', + config_key varchar(20) not null default '' comment '閰嶇疆key', access_key varchar(255) default '' comment 'accessKey', secret_key varchar(255) default '' comment '绉橀挜', bucket_name varchar(255) default '' comment '妗跺悕绉�', @@ -673,6 +674,7 @@ domain varchar(255) default '' comment '鑷畾涔夊煙鍚�', is_https char(1) default 'N' comment '鏄惁https锛圷=鏄�,N=鍚︼級', region varchar(255) default '' comment '鍩�', + access_policy char(1) not null default '1' comment '妗舵潈闄愮被鍨�(0=private 1=public 2=custom)', status char(1) default '1' comment '鐘舵�侊紙0=姝ｅ父,1=鍋滅敤锛�', ext1 varchar(255) default '' comment '鎵╁睍瀛楁', create_by varchar(64) default '' comment '鍒涘缓鑰�', @@ -683,9 +685,8 @@ primary key (oss_config_id) ) engine=innodb comment='瀵硅薄瀛樺偍閰嶇疆琛�'; -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); - +insert into sys_oss_config values (1, 'minio', 'ruoyi', 'ruoyi123', 'ruoyi', '', '127.0.0.1:9000', '','N', '', '1' ,'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' ,'1', '', 'admin', sysdate(), 'admin', sysdate(), NULL); +insert into sys_oss_config values (3, 'aliyun', 'XXXXXXXXXXXXXXX', 'XXXXXXXXXXXXXXX', 'ruoyi', '', 'oss-cn-beijing.aliyuncs.com', '','N', '', '1' ,'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' ,'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' ,'1', '', 'admin', sysdate(), 'admin', sysdate(), NULL); -- Gitblit v1.9.3