buff2.0/docs/system_config.sql

/*
 Navicat Premium Dump SQL

 Source Server         : 47.99.164.66  hn02le.34lkdLKD
 Source Server Type    : MySQL
 Source Server Version : 50736 (5.7.36)
 Source Host           : 47.99.164.66:3306
 Source Schema         : buff

 Target Server Type    : MySQL
 Target Server Version : 50736 (5.7.36)
 File Encoding         : 65001

 Date: 19/02/2026 19:47:12
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for system_config
-- ----------------------------
DROP TABLE IF EXISTS `system_config`;
CREATE TABLE `system_config` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `config_key` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '配置键名',
  `config_value` varchar(500) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '配置值',
  `config_type` enum('int','string','bool','json') COLLATE utf8mb4_unicode_ci DEFAULT 'string' COMMENT '配置值类型',
  `app_name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT 'backend-admin' COMMENT '所属应用：backend-admin、backend-client，多个用逗号拼接',
  `description` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '配置描述',
  `is_system` tinyint(1) DEFAULT '1' COMMENT '是否为系统配置：1-是，0-否',
  `is_editable` tinyint(1) DEFAULT '1' COMMENT '是否可编辑：1-是，0-否',
  `is_deleted` tinyint(1) DEFAULT '0' COMMENT '是否删除：0-否，1-是',
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_config_key` (`config_key`,`is_deleted`) COMMENT '配置键唯一约束'
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='系统配置表（纵表设计）';

-- ----------------------------
-- Records of system_config
-- ----------------------------
BEGIN;
INSERT INTO `system_config` (`id`, `config_key`, `config_value`, `config_type`, `app_name`, `description`, `is_system`, `is_editable`, `is_deleted`, `created_at`, `updated_at`) VALUES (23, 'key_expire_minutes', '60', 'int', 'backend-admin', '密钥过期时间（分钟）', 1, 1, 0, '2026-02-01 10:40:06', '2026-02-01 10:40:06');
INSERT INTO `system_config` (`id`, `config_key`, `config_value`, `config_type`, `app_name`, `description`, `is_system`, `is_editable`, `is_deleted`, `created_at`, `updated_at`) VALUES (24, 'key_advance_generate_minutes', '30', 'int', 'backend-admin', '提前生成新密钥的时间（分钟），在密钥过期前此时间自动生成新密钥', 1, 1, 0, '2026-02-01 10:40:06', '2026-02-01 10:40:34');
INSERT INTO `system_config` (`id`, `config_key`, `config_value`, `config_type`, `app_name`, `description`, `is_system`, `is_editable`, `is_deleted`, `created_at`, `updated_at`) VALUES (25, 'key_expiry_check_interval_seconds', '60', 'int', 'backend-admin', '密钥过期检查任务的执行间隔（秒）', 1, 1, 0, '2026-02-01 10:40:06', '2026-02-01 10:40:06');
INSERT INTO `system_config` (`id`, `config_key`, `config_value`, `config_type`, `app_name`, `description`, `is_system`, `is_editable`, `is_deleted`, `created_at`, `updated_at`) VALUES (26, 'admin_config_refresh_interval_seconds', '60', 'int', 'backend-admin', '管理端配置缓存刷新间隔（秒）', 1, 1, 0, '2026-02-01 11:16:27', '2026-02-01 11:16:27');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;