sys_oss_config.sql 1.8 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445
  1. /*
  2. Navicat MySQL Data Transfer
  3. Source Server : mysql57
  4. Source Server Version : 50735
  5. Source Host : localhost:3306
  6. Source Database : ry-vue
  7. Target Server Type : MYSQL
  8. Target Server Version : 50735
  9. File Encoding : 65001
  10. Date: 2021-08-12 09:01:33
  11. */
  12. SET FOREIGN_KEY_CHECKS=0;
  13. -- ----------------------------
  14. -- Table structure for sys_oss_config
  15. -- ----------------------------
  16. DROP TABLE IF EXISTS `sys_oss_config`;
  17. CREATE TABLE `sys_oss_config` (
  18. `oss_config_id` int(5) NOT NULL AUTO_INCREMENT COMMENT '主建',
  19. `config_key` varchar(255) NOT NULL DEFAULT '' COMMENT '配置key',
  20. `access_key` varchar(255) DEFAULT '' COMMENT 'access_key',
  21. `secret_key` varchar(255) DEFAULT '' COMMENT '秘钥',
  22. `bucket_name` varchar(255) DEFAULT '' COMMENT '桶名称',
  23. `prefix` varchar(255) DEFAULT '' COMMENT '前缀',
  24. `endpoint` varchar(255) DEFAULT '' COMMENT '访问站点',
  25. `is_https` char(1) DEFAULT '0' COMMENT '是否htpps(0否 1是)',
  26. `region` varchar(255) DEFAULT '' COMMENT '域',
  27. `status` char(1) DEFAULT '0' COMMENT '状态(0正常 1停用)',
  28. `ext1` varchar(255) DEFAULT '' COMMENT '扩展字段',
  29. `create_by` varchar(64) DEFAULT '' COMMENT '创建者',
  30. `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  31. `update_by` varchar(64) DEFAULT '' COMMENT '更新者',
  32. `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  33. `remark` varchar(500) DEFAULT NULL COMMENT '备注',
  34. PRIMARY KEY (`oss_config_id`)
  35. ) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COMMENT='云存储配置表';
  36. -- ----------------------------
  37. -- Records of sys_oss_config
  38. -- ----------------------------
  39. INSERT INTO `sys_oss_config` VALUES ('1', 'minio3', 'ruoyi', 'ruoyi123', 'ruoyi', '', 'http://localhost:9000', '0', '', '0', '', 'admin', '2021-08-11 21:29:37', 'admin', '2021-08-11 22:52:41', null);