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);
