/*
 Navicat Premium Dump SQL

 Source Server         : zbw
 Source Server Type    : MySQL
 Source Server Version : 80042 (8.0.42)
 Source Host           : localhost:3306
 Source Schema         : ry_vue_5.x

 Target Server Type    : MySQL
 Target Server Version : 80042 (8.0.42)
 File Encoding         : 65001

 Date: 30/12/2025 15:16:29
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for sys_config
-- ----------------------------
DROP TABLE IF EXISTS `sys_config`;
CREATE TABLE `sys_config`  (
  `config_id` bigint NOT NULL COMMENT '参数主键',
  `tenant_id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '000000' COMMENT '租户编号',
  `config_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '参数名称',
  `config_key` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '参数键名',
  `config_value` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '' COMMENT '参数键值',
  `config_type` char(1) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT 'N' COMMENT '系统内置（Y是 N否）',
  `create_dept` bigint NULL DEFAULT NULL COMMENT '创建部门',
  `create_by` bigint NULL DEFAULT NULL COMMENT '创建者',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  `update_by` bigint NULL DEFAULT NULL COMMENT '更新者',
  `update_time` datetime NULL DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`config_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '参数配置表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of sys_config
-- ----------------------------
INSERT INTO `sys_config` VALUES (1, '000000', '主框架页-默认皮肤样式名称', 'sys.index.skinName', 'skin-blue', 'Y', 103, 1, '2025-12-19 11:57:51', NULL, NULL, '蓝色 skin-blue、绿色 skin-green、紫色 skin-purple、红色 skin-red、黄色 skin-yellow');
INSERT INTO `sys_config` VALUES (2, '000000', '用户管理-账号初始密码', 'sys.user.initPassword', '123456', 'Y', 103, 1, '2025-12-19 11:57:51', NULL, NULL, '初始化密码 123456');
INSERT INTO `sys_config` VALUES (3, '000000', '主框架页-侧边栏主题', 'sys.index.sideTheme', 'theme-dark', 'Y', 103, 1, '2025-12-19 11:57:51', NULL, NULL, '深色主题theme-dark，浅色主题theme-light');
INSERT INTO `sys_config` VALUES (5, '000000', '账号自助-是否开启用户注册功能', 'sys.account.registerUser', 'false', 'Y', 103, 1, '2025-12-19 11:57:51', NULL, NULL, '是否开启注册用户功能（true开启，false关闭）');
INSERT INTO `sys_config` VALUES (11, '000000', 'OSS预览列表资源开关', 'sys.oss.previewListResource', 'true', 'Y', 103, 1, '2025-12-19 11:57:51', NULL, NULL, 'true:开启, false:关闭');
INSERT INTO `sys_config` VALUES (100, '000000', '超短池订阅价格', 'payment.short.price', '0.01', 'N', 103, 1, '2025-12-29 16:47:32', NULL, NULL, '超短池订阅价格（元），有效期到当日24:00');
INSERT INTO `sys_config` VALUES (101, '000000', '强势池订阅价格', 'payment.strong.price', '0.01', 'N', 103, 1, '2025-12-29 16:47:32', NULL, NULL, '强势池订阅价格（元），有效期1年');
INSERT INTO `sys_config` VALUES (104, '000000', '微信支付商户号', 'payment.mch.id', '', 'N', 103, 1, '2025-12-29 17:24:57', NULL, NULL, '微信支付商户号MCHID');
INSERT INTO `sys_config` VALUES (105, '000000', '微信支付APIv3密钥', 'payment.api.v3.key', '', 'N', 103, 1, '2025-12-29 17:24:57', NULL, NULL, '微信支付APIv3密钥');
INSERT INTO `sys_config` VALUES (106, '000000', '支付证书文件路径', 'payment.cert.path', '', 'N', 103, 1, '2025-12-29 17:24:57', NULL, NULL, '微信支付证书文件路径(apiclient_cert.pem)');
INSERT INTO `sys_config` VALUES (107, '000000', '支付回调地址', 'payment.notify.url', '', 'N', 103, 1, '2025-12-29 17:24:57', NULL, NULL, '微信支付回调地址');
INSERT INTO `sys_config` VALUES (108, '000000', '商户私钥文件路径', 'payment.private.key.path', '', 'N', 103, 1, '2025-12-30 09:44:32', NULL, NULL, '微信支付商户私钥文件路径(apiclient_key.pem)');

SET FOREIGN_KEY_CHECKS = 1;
