From eb2be90e74adfa06ee251f80c08243d0301ce467 Mon Sep 17 00:00:00 2001 From: 疯狂的狮子li <15040126243@163.com> Date: 星期三, 28 七月 2021 10:49:16 +0800 Subject: [PATCH] Merge remote-tracking branch 'origin/dev' --- sql/oss.sql | 27 +++++++++++++++++++++++++++ 1 files changed, 27 insertions(+), 0 deletions(-) diff --git a/sql/oss.sql b/sql/oss.sql new file mode 100644 index 0000000..3b20c07 --- /dev/null +++ b/sql/oss.sql @@ -0,0 +1,27 @@ +-- ---------------------------- +-- OSS浜戝瓨鍌ㄨ〃 +-- ---------------------------- +drop table if exists sys_oss; +create table sys_oss ( + oss_id bigint(20) not null auto_increment comment '浜戝瓨鍌ㄤ富閿�', + file_name varchar(64) not null default '' comment '鏂囦欢鍚�', + original_name varchar(64) not null default '' comment '鍘熷悕', + file_suffix varchar(10) not null default '' comment '鏂囦欢鍚庣紑鍚�', + url varchar(200) not null comment 'URL鍦板潃', + create_time datetime default null comment '鍒涘缓鏃堕棿', + 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 '鏈嶅姟鍟�', + primary key (oss_id) +) engine=innodb comment ='OSS浜戝瓨鍌ㄨ〃'; + +insert into sys_config values(10, 'OSS浜戝瓨鍌ㄦ湇鍔″晢', 'sys.oss.cloudStorageService', 'minio', 'Y', 'admin', sysdate(), '', null, 'OSS浜戝瓨鍌ㄦ湇鍔″晢(qiniu:涓冪墰浜�, aliyun:闃块噷浜�, qcloud:鑵捐浜�, minio: Minio)'); +insert into sys_config values(11, 'OSS棰勮鍒楄〃璧勬簮寮�鍏�', 'sys.oss.previewListResource', 'true', 'Y', 'admin', sysdate(), '', null, 'true:寮�鍚�, false:鍏抽棴'); + +insert into sys_menu values('118', '鏂囦欢绠$悊', '1', '10', 'oss', 'system/oss/index', 1, 0, 'C', '0', '0', 'system:oss:list', 'upload', 'admin', sysdate(), '', null, '鏂囦欢绠$悊鑿滃崟'); + +insert into sys_menu values('1600', '鏂囦欢鏌ヨ', '118', '1', '#', '', 1, 0, 'F', '0', '0', 'system:oss:query', '#', 'admin', sysdate(), '', null, ''); +insert into sys_menu values('1601', '鏂囦欢涓婁紶', '118', '2', '#', '', 1, 0, 'F', '0', '0', 'system:oss:upload', '#', 'admin', sysdate(), '', null, ''); +insert into sys_menu values('1602', '鏂囦欢涓嬭浇', '118', '3', '#', '', 1, 0, 'F', '0', '0', 'system:oss:download', '#', 'admin', sysdate(), '', null, ''); +insert into sys_menu values('1603', '鏂囦欢鍒犻櫎', '118', '4', '#', '', 1, 0, 'F', '0', '0', 'system:oss:remove', '#', 'admin', sysdate(), '', null, ''); -- Gitblit v1.9.3