buff2.0/backend-client/migrations/api_nonces@api_nonces_his.sql

/*
 api_nonces / api_nonces_his 表结构（与 ORM 模型一致）
 - api_nonces: 防重放，主键 id，nonce 唯一
 - api_nonces_his: 历史记录，主键 (id, his_created_at)，id 为原表主键

 Target Server Type    : MySQL
 Source Schema         : buff
 Date: 15/02/2026
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for api_nonces
-- ----------------------------
DROP TABLE IF EXISTS `api_nonces`;
CREATE TABLE `api_nonces` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `nonce` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '随机字符串',
  `endpoint` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '接口路径',
  `session_id` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '会话ID',
  `user_id` int(11) DEFAULT NULL COMMENT '用户ID',
  `expires_at` datetime NOT NULL COMMENT '过期时间',
  `created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `uk_api_nonces_nonce` (`nonce`),
  KEY `idx_api_nonces_expires_at` (`expires_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='API Nonce防重放表';

-- ----------------------------
-- Records of api_nonces (无初始数据)
-- ----------------------------
-- BEGIN;
-- COMMIT;

-- ----------------------------
-- Table structure for api_nonces_his
-- ----------------------------
DROP TABLE IF EXISTS `api_nonces_his`;
CREATE TABLE `api_nonces_his` (
  `id` int(11) NOT NULL COMMENT '原表主键ID',
  `nonce` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '随机字符串',
  `endpoint` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '接口路径',
  `session_id` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '会话ID',
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `expires_at` datetime NOT NULL COMMENT '过期时间',
  `his_created_at` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '历史记录创建时间',
  `his_operation` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '操作类型: INSERT/UPDATE/DELETE',
  PRIMARY KEY (`id`, `his_created_at`),
  KEY `idx_his_created_at` (`his_created_at`),
  KEY `idx_nonce` (`nonce`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='API Nonce表历史记录';

-- ----------------------------
-- Records of api_nonces_his (无初始数据)
-- ----------------------------
-- BEGIN;
-- COMMIT;

SET FOREIGN_KEY_CHECKS = 1;