| 12345678910111213141516171819202122232425262728293031 |
- create table sys_oss_config
- (
- oss_config_id bigint not null comment '主键'
- primary key,
- tenant_id varchar(20) default '000000' null comment '租户编号',
- config_key varchar(20) default '' not null comment '配置key',
- access_key varchar(255) default '' null comment 'accessKey',
- secret_key varchar(255) default '' null comment '秘钥',
- bucket_name varchar(255) default '' null comment '桶名称',
- prefix varchar(255) default '' null comment '前缀',
- endpoint varchar(255) default '' null comment '访问站点',
- domain varchar(255) default '' null comment '自定义域名',
- is_https char default 'N' null comment '是否https（Y=是,N=否）',
- region varchar(255) default '' null comment '域',
- access_policy char default '1' not null comment '桶权限类型(0=private 1=public 2=custom)',
- status char default '1' null comment '是否默认（0=是,1=否）',
- ext1 varchar(255) default '' null comment '扩展字段',
- create_dept bigint null comment '创建部门',
- create_by bigint null comment '创建者',
- create_time datetime null comment '创建时间',
- update_by bigint null comment '更新者',
- update_time datetime null comment '更新时间',
- remark varchar(500) null comment '备注'
- )
- comment '对象存储配置表';
- INSERT INTO ruoyi.sys_oss_config (oss_config_id, tenant_id, config_key, access_key, secret_key, bucket_name, prefix, endpoint, domain, is_https, region, access_policy, status, ext1, create_dept, create_by, create_time, update_by, update_time, remark) VALUES (1, '000000', 'minio', 'ruoyi', 'ruoyi123', 'ruoyi', '', '127.0.0.1:9000', '', 'N', '', '1', '0', '', 103, 1, '2025-08-23 21:51:26', 1, '2025-08-23 21:51:26', null);
- INSERT INTO ruoyi.sys_oss_config (oss_config_id, tenant_id, config_key, access_key, secret_key, bucket_name, prefix, endpoint, domain, is_https, region, access_policy, status, ext1, create_dept, create_by, create_time, update_by, update_time, remark) VALUES (2, '000000', 'qiniu', 'XXXXXXXXXXXXXXX', 'XXXXXXXXXXXXXXX', 'ruoyi', '', 's3-cn-north-1.qiniucs.com', '', 'N', '', '1', '1', '', 103, 1, '2025-08-23 21:51:27', 1, '2025-08-23 21:51:27', null);
- INSERT INTO ruoyi.sys_oss_config (oss_config_id, tenant_id, config_key, access_key, secret_key, bucket_name, prefix, endpoint, domain, is_https, region, access_policy, status, ext1, create_dept, create_by, create_time, update_by, update_time, remark) VALUES (3, '000000', 'aliyun', 'XXXXXXXXXXXXXXX', 'XXXXXXXXXXXXXXX', 'ruoyi', '', 'oss-cn-beijing.aliyuncs.com', '', 'N', '', '1', '1', '', 103, 1, '2025-08-23 21:51:27', 1, '2025-08-23 21:51:27', null);
- INSERT INTO ruoyi.sys_oss_config (oss_config_id, tenant_id, config_key, access_key, secret_key, bucket_name, prefix, endpoint, domain, is_https, region, access_policy, status, ext1, create_dept, create_by, create_time, update_by, update_time, remark) VALUES (4, '000000', 'qcloud', 'XXXXXXXXXXXXXXX', 'XXXXXXXXXXXXXXX', 'ruoyi-1240000000', '', 'cos.ap-beijing.myqcloud.com', '', 'N', 'ap-beijing', '1', '1', '', 103, 1, '2025-08-23 21:51:27', 1, '2025-08-23 21:51:27', null);
- INSERT INTO ruoyi.sys_oss_config (oss_config_id, tenant_id, config_key, access_key, secret_key, bucket_name, prefix, endpoint, domain, is_https, region, access_policy, status, ext1, create_dept, create_by, create_time, update_by, update_time, remark) VALUES (5, '000000', 'image', 'ruoyi', 'ruoyi123', 'ruoyi', 'image', '127.0.0.1:9000', '', 'N', '', '1', '1', '', 103, 1, '2025-08-23 21:51:27', 1, '2025-08-23 21:51:27', null);
|
