buff/.history/游铛铛-数据库设计_20251227130533.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: 27/12/2025 13:01:12
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for admins
-- ----------------------------
DROP TABLE IF EXISTS `admins`;
CREATE TABLE `admins` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `username` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '管理员用户名',
  `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '密码（加密存储）',
  `real_name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '真实姓名',
  `email` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '邮箱',
  `role` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT 'admin' COMMENT '角色：admin-管理员，super_admin-超级管理员',
  `last_login_time` datetime DEFAULT NULL COMMENT '最后登录时间',
  `last_login_ip` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '最后登录IP',
  `status` 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 `username` (`username`),
  KEY `idx_username` (`username`),
  KEY `idx_role` (`role`),
  KEY `idx_status` (`status`),
  KEY `idx_is_deleted` (`is_deleted`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='管理员表';

-- ----------------------------
-- Table structure for admins_his
-- ----------------------------
DROP TABLE IF EXISTS `admins_his`;
CREATE TABLE `admins_his` (
  `id` int(11) NOT NULL COMMENT '原表主键ID',
  `username` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '管理员用户名',
  `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '密码（加密存储）',
  `real_name` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '真实姓名',
  `email` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '邮箱',
  `role` varchar(20) COLLATE utf8mb4_unicode_ci DEFAULT 'admin' COMMENT '角色：admin-管理员，super_admin-超级管理员',
  `last_login_time` datetime DEFAULT NULL COMMENT '最后登录时间',
  `last_login_ip` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '最后登录IP',
  `status` 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 '更新时间',
  `his_created_at` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '历史记录创建时间',
  `his_operation` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '操作类型：INSERT/UPDATE/DELETE'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='管理员表历史记录';

-- ----------------------------
-- Records of admins
-- ----------------------------
BEGIN;
INSERT INTO `admins` (`id`, `username`, `password`, `real_name`, `email`, `role`, `last_login_time`, `last_login_ip`, `status`, `created_at`, `updated_at`) VALUES (1, 'admin', '$2b$12$Vo1C3bBYpHncLaxwNhzRsuVuuqSdeLQYgFTTd/u8.Q5v3EQ5Tl2OK', '系统管理员', NULL, 'super_admin', '2025-12-27 12:04:59', '127.0.0.1', 1, '2025-11-10 11:40:12', '2025-12-27 12:04:59');
COMMIT;

-- ----------------------------
-- Table structure for announcements
-- ----------------------------
DROP TABLE IF EXISTS `announcements`;
CREATE TABLE `announcements` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `title` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '公告标题',
  `content` text COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '公告内容',
  `priority` tinyint(4) DEFAULT '0' COMMENT '优先级：0-普通，1-重要，2-紧急',
  `is_active` tinyint(1) DEFAULT '1' COMMENT '是否启用：1-启用，0-禁用',
  `publish_time` datetime DEFAULT NULL COMMENT '发布时间',
  `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`),
  KEY `idx_is_active` (`is_active`),
  KEY `idx_priority` (`priority`),
  KEY `idx_publish_time` (`publish_time`),
  KEY `idx_is_deleted` (`is_deleted`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='公告表';

-- ----------------------------
-- Table structure for announcements_his
-- ----------------------------
DROP TABLE IF EXISTS `announcements_his`;
CREATE TABLE `announcements_his` (
  `id` int(11) NOT NULL COMMENT '原表主键ID',
  `title` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '公告标题',
  `content` text COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '公告内容',
  `priority` tinyint(4) DEFAULT '0' COMMENT '优先级：0-普通，1-重要，2-紧急',
  `is_active` tinyint(1) DEFAULT '1' COMMENT '是否启用：1-启用，0-禁用',
  `publish_time` datetime DEFAULT NULL COMMENT '发布时间',
  `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 '更新时间',
  `his_created_at` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '历史记录创建时间',
  `his_operation` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '操作类型：INSERT/UPDATE/DELETE'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='公告表历史记录';

-- ----------------------------
-- Records of announcements
-- ----------------------------
BEGIN;
INSERT INTO `announcements` (`id`, `title`, `content`, `priority`, `is_active`, `publish_time`, `created_at`, `updated_at`) VALUES (1, '系统维护通知', '系统将于本周六晚上进行维护，预计维护时间2小时，期间可能无法正常使用，请提前做好准备。', 1, 1, '2025-10-18 12:10:36', '2025-10-14 12:10:36', '2025-11-10 12:10:36');
INSERT INTO `announcements` (`id`, `title`, `content`, `priority`, `is_active`, `publish_time`, `created_at`, `updated_at`) VALUES (2, '新功能上线', '我们很高兴地宣布，新版本已经上线，包含以下新功能：\n1. 优化了用户体验\n2. 增加了新的功能模块\n3. 修复了已知问题', 2, 1, '2025-10-28 12:10:36', '2025-10-17 12:10:36', '2025-11-10 12:10:36');
INSERT INTO `announcements` (`id`, `title`, `content`, `priority`, `is_active`, `publish_time`, `created_at`, `updated_at`) VALUES (3, '优惠活动', '限时优惠活动正在进行中，购买年卡可享受8折优惠，活动时间有限，请抓紧时间！', 3, 1, '2025-11-07 12:10:36', '2025-10-14 12:10:36', '2025-11-10 12:10:36');
COMMIT;

-- ----------------------------
-- Table structure for api_keys
-- ----------------------------
DROP TABLE IF EXISTS `api_keys`;
CREATE TABLE `api_keys` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `public_key` text COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'RSA公钥（PEM格式）',
  `private_key` text COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'RSA私钥（PEM格式，加密存储）',
  `key_version` int(11) NOT NULL COMMENT '密钥版本号',
  `is_active` tinyint(1) DEFAULT '1' COMMENT '是否激活：1-激活，0-非激活',
  `is_deleted` tinyint(1) DEFAULT '0' COMMENT '是否删除：0-否，1-是',
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `expire_at` datetime DEFAULT NULL COMMENT '过期时间（创建时间+10天）',
  PRIMARY KEY (`id`),
  KEY `idx_key_version` (`key_version`),
  KEY `idx_is_active` (`is_active`),
  KEY `idx_expire_at` (`expire_at`),
  KEY `idx_is_deleted` (`is_deleted`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='API密钥表';

-- ----------------------------
-- Table structure for api_keys_his
-- ----------------------------
DROP TABLE IF EXISTS `api_keys_his`;
CREATE TABLE `api_keys_his` (
  `id` int(11) NOT NULL COMMENT '原表主键ID',
  `public_key` text COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'RSA公钥（PEM格式）',
  `private_key` text COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'RSA私钥（PEM格式，加密存储）',
  `key_version` int(11) NOT NULL COMMENT '密钥版本号',
  `is_active` tinyint(1) DEFAULT '1' COMMENT '是否激活：1-激活，0-非激活',
  `is_deleted` tinyint(1) DEFAULT '0' COMMENT '是否删除：0-否，1-是',
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `expire_at` datetime DEFAULT NULL COMMENT '过期时间（创建时间+10天）',
  `his_created_at` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '历史记录创建时间',
  `his_operation` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '操作类型：INSERT/UPDATE/DELETE'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='API密钥表历史记录';

-- ----------------------------
-- Records of api_keys
-- ----------------------------
BEGIN;
INSERT INTO `api_keys` (`id`, `public_key`, `private_key`, `key_version`, `is_active`, `created_at`, `expire_at`) VALUES (1, '-----BEGIN PUBLIC KEY-----\nMIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEAon/etf2FNhx0jpJN1L21\nJEXT0vtWxTH8IesGTBwsywJ8BHR8eI0qTUQ6pdmJnG908FVG99BDq+SwOx2FrQC9\nI6TnfyaAcis8itUhiW0PCn63DfYD8GZMsbQnUD5wUYCfbNEJlQIl5u4vIpUUs4jJ\nUPULX0UWHGh8kiZQDpdlwoZ21Zn0tuRqJM5U23JTsXis++6D9H+OgkfYKNydj9t6\n1ky7xEjj3jCDhw3TyEhDNixYc4QLO9na1tMQZhi6rVhy0twffzowHUv2UPBgZ0tN\ntyKlHzHofVLYfidSzTlJRjbBLIpaj+gZduK01VdBjaLwcCg9V0Xdby7Hqnl6Gi8n\nbwIDAQAB\n-----END PUBLIC KEY-----\n', '-----BEGIN PRIVATE KEY-----\nMIIEvgIBADANBgkqhkiG9w0BAQEFAASCBKgwggSkAgEAAoIBAQCif961/YU2HHSO\nkk3UvbUkRdPS+1bFMfwh6wZMHCzLAnwEdHx4jSpNRDql2Ymcb3TwVUb30EOr5LA7\nHYWtAL0jpOd/JoByKzyK1SGJbQ8KfrcN9gPwZkyxtCdQPnBRgJ9s0QmVAiXm7i8i\nlRSziMlQ9QtfRRYcaHySJlAOl2XChnbVmfS25GokzlTbclOxeKz77oP0f46CR9go\n3J2P23rWTLvESOPeMIOHDdPISEM2LFhzhAs72drW0xBmGLqtWHLS3B9/OjAdS/ZQ\n8GBnS023IqUfMeh9Uth+J1LNOUlGNsEsilqP6Bl24rTVV0GNovBwKD1XRd1vLseq\neXoaLydvAgMBAAECggEAM8VYX5PbLm+nZMrQ2B/uh5VllJi1vtKbePTnRzVMwgrT\nFxpDk6ap3P8JTlB9qqTJ1U3d89La1Hdh/Bt+PK15FNOTW2uZTYZf3f1kF2PzAE15\npY2FGMCG27DBO6wA3b6ETEdW7a3HBIlK5BIqC77fIJdJXbtlfXx+f5OMOvHaHjx1\nfqMxuj0k8hpHMfBHB5r3LQXvWUhO3CEjkBBwJj49C/cSm1Zh89yL42T15GyM9Vj/\np5y+Nk1YEnCwQRWLhkvv+P6ayMRNYESdi1dKg5KA+UiozigoffXPpo4buaQHr1mH\nGseGQK4eLKCr0VudN1+uAtxyq7RK8SNUgGvtRESEHQKBgQDZz+661lgV0VOLuy3w\nmTG+U1P1ud0YNpDSF2XFiznRNpaSWR3uyUtJxSuHhiq6pNRZy7tq9evoE+m7m9XT\nO2m6Z/Edtuo5atG9gCgXPzlfdiIR8xM3bkXDce426gblGWHzitod7d+uqfOlJM30\nrMkpG6EZGwZC9yNIelJSvAqxwwKBgQC+/VXWUez1+2trT0T1JbPnL46tKRM/asP4\nAjlY1ZNn5Bz/pabvcEs1SGr0HdengMk3pHMzbVXJa6Xep1Ur3+syvqomXtAf1mhr\n6C8mV/RZ0h6rAnhla5eV1+DgZqkUCjEadEXRjn2eyI8BJdxthd7YASFW6FFAReHs\nvd1PhQMM5QKBgQC3WB5+S3suMlv/HPqYsnt62C2uhFulzBivoF5coMt0Xlz0p+tY\nWzzyxfPUSo2hOqo9RA9pA8UmP8zZzV16R2LCNEh0WMpktpQCzePxXZjv0ELxlQkx\n+bLjx/1bYDeZlXosRU9BLkDBh/G9q3NqaB+UaNt8hJEKwXmDwuOVHRBrfQKBgFtg\nI0A9xAxP9K3LqCdNmYwDMdTg8QeHUikHD17UGAk9ly4sl/i4lhLxCdKvsGzAbgTE\nFiXFqqSKbzpefp5WLFYD6K4g8Jw63Yy68kv7CroqkGeq7+U+G7EiLsHN/BjNY37P\noFPJQ4rDU7/t2E9CHELmD4hf7/e7N4Mnt4mDDtmNAoGBAKaM0lm64sRYXvqCt8wC\nQkWL2V72HH6xrbKHSUTw8xdPO0dIMFn/afdaPS0ziZwrKApyshJSDqpzSXUJI9fm\nIj8SMG4Q+VKQX5kEyykzA5g8GBRpTcYJWaKzGZPtBSyOAu9rQkP3zpdLTmWZwkZm\nA6njBsNfHxr1hh8n17zV8SI1\n-----END PRIVATE KEY-----\n', 1, 1, '2025-11-10 11:44:23', '2025-11-20 11:44:23');
COMMIT;

-- ----------------------------
-- Table structure for api_logs
-- ----------------------------
DROP TABLE IF EXISTS `api_logs`;
CREATE TABLE `api_logs` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `user_id` int(11) DEFAULT NULL COMMENT '用户ID（可为NULL，如登录接口）',
  `endpoint` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '接口路径',
  `method` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'HTTP方法：GET、POST等',
  `request_data` text COLLATE utf8mb4_unicode_ci COMMENT '请求数据（加密前或解密后）',
  `response_data` text COLLATE utf8mb4_unicode_ci COMMENT '响应数据（加密前或解密后）',
  `ip_address` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '客户端IP地址',
  `user_agent` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '用户代理',
  `response_code` int(11) DEFAULT NULL COMMENT '响应状态码',
  `execution_time` int(11) DEFAULT NULL COMMENT '执行时间（毫秒）',
  `is_deleted` tinyint(1) DEFAULT '0' COMMENT '是否删除：0-否，1-是',
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  PRIMARY KEY (`id`),
  KEY `idx_user_id` (`user_id`),
  KEY `idx_endpoint` (`endpoint`),
  KEY `idx_method` (`method`),
  KEY `idx_ip_address` (`ip_address`),
  KEY `idx_created_at` (`created_at`),
  KEY `idx_response_code` (`response_code`),
  KEY `idx_is_deleted` (`is_deleted`)
) ENGINE=InnoDB AUTO_INCREMENT=1526 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='API日志表';

-- ----------------------------
-- Table structure for api_logs_his
-- ----------------------------
DROP TABLE IF EXISTS `api_logs_his`;
CREATE TABLE `api_logs_his` (
  `id` bigint(20) NOT NULL COMMENT '原表主键ID',
  `user_id` int(11) DEFAULT NULL COMMENT '用户ID（可为NULL，如登录接口）',
  `endpoint` varchar(200) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '接口路径',
  `method` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'HTTP方法：GET、POST等',
  `request_data` text COLLATE utf8mb4_unicode_ci COMMENT '请求数据（加密前或解密后）',
  `response_data` text COLLATE utf8mb4_unicode_ci COMMENT '响应数据（加密前或解密后）',
  `ip_address` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '客户端IP地址',
  `user_agent` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '用户代理',
  `response_code` int(11) DEFAULT NULL COMMENT '响应状态码',
  `execution_time` int(11) DEFAULT NULL COMMENT '执行时间（毫秒）',
  `is_deleted` tinyint(1) DEFAULT '0' COMMENT '是否删除：0-否，1-是',
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `his_created_at` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '历史记录创建时间',
  `his_operation` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '操作类型：INSERT/UPDATE/DELETE'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='API日志表历史记录';

-- ----------------------------
-- Records of api_logs
-- ----------------------------
BEGIN;
INSERT INTO `api_logs` (`id`, `user_id`, `endpoint`, `method`, `request_data`, `response_data`, `ip_address`, `user_agent`, `response_code`, `execution_time`, `created_at`) VALUES (1508, NULL, 'http://localhost:8000/admin/logs', 'DELETE', '', NULL, '127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Safari/537.36', 200, 125, '2025-12-27 12:28:45');
INSERT INTO `api_logs` (`id`, `user_id`, `endpoint`, `method`, `request_data`, `response_data`, `ip_address`, `user_agent`, `response_code`, `execution_time`, `created_at`) VALUES (1509, NULL, 'http://localhost:8000/admin/logs?page=1&page_size=10', 'GET', '', NULL, '127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Safari/537.36', 200, 117, '2025-12-27 12:28:45');
INSERT INTO `api_logs` (`id`, `user_id`, `endpoint`, `method`, `request_data`, `response_data`, `ip_address`, `user_agent`, `response_code`, `execution_time`, `created_at`) VALUES (1510, NULL, 'http://localhost:8000/admin/keys/history', 'GET', '', NULL, '127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Safari/537.36', 200, 113, '2025-12-27 12:28:49');
INSERT INTO `api_logs` (`id`, `user_id`, `endpoint`, `method`, `request_data`, `response_data`, `ip_address`, `user_agent`, `response_code`, `execution_time`, `created_at`) VALUES (1511, NULL, 'http://localhost:8000/admin/keys/current', 'GET', '', NULL, '127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Safari/537.36', 200, 190, '2025-12-27 12:28:49');
INSERT INTO `api_logs` (`id`, `user_id`, `endpoint`, `method`, `request_data`, `response_data`, `ip_address`, `user_agent`, `response_code`, `execution_time`, `created_at`) VALUES (1512, NULL, 'http://localhost:8000/admin/keys/history', 'GET', '', NULL, '127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Safari/537.36', 200, 111, '2025-12-27 12:28:49');
INSERT INTO `api_logs` (`id`, `user_id`, `endpoint`, `method`, `request_data`, `response_data`, `ip_address`, `user_agent`, `response_code`, `execution_time`, `created_at`) VALUES (1513, NULL, 'http://localhost:8000/admin/keys/current', 'GET', '', NULL, '127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Safari/537.36', 200, 185, '2025-12-27 12:28:49');
INSERT INTO `api_logs` (`id`, `user_id`, `endpoint`, `method`, `request_data`, `response_data`, `ip_address`, `user_agent`, `response_code`, `execution_time`, `created_at`) VALUES (1514, NULL, 'http://localhost:8000/admin/announcements?page=1&page_size=10', 'GET', '', NULL, '127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Safari/537.36', 200, 109, '2025-12-27 12:28:50');
INSERT INTO `api_logs` (`id`, `user_id`, `endpoint`, `method`, `request_data`, `response_data`, `ip_address`, `user_agent`, `response_code`, `execution_time`, `created_at`) VALUES (1515, NULL, 'http://localhost:8000/admin/announcements?page=1&page_size=10', 'GET', '', NULL, '127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Safari/537.36', 200, 123, '2025-12-27 12:28:50');
INSERT INTO `api_logs` (`id`, `user_id`, `endpoint`, `method`, `request_data`, `response_data`, `ip_address`, `user_agent`, `response_code`, `execution_time`, `created_at`) VALUES (1516, NULL, 'http://localhost:8000/admin/admins?page=1&page_size=10', 'OPTIONS', '', NULL, '127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Safari/537.36', 200, 8, '2025-12-27 12:32:16');
INSERT INTO `api_logs` (`id`, `user_id`, `endpoint`, `method`, `request_data`, `response_data`, `ip_address`, `user_agent`, `response_code`, `execution_time`, `created_at`) VALUES (1517, NULL, 'http://localhost:8000/admin/admins?page=1&page_size=10', 'OPTIONS', '', NULL, '127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Safari/537.36', 200, 128, '2025-12-27 12:32:16');
INSERT INTO `api_logs` (`id`, `user_id`, `endpoint`, `method`, `request_data`, `response_data`, `ip_address`, `user_agent`, `response_code`, `execution_time`, `created_at`) VALUES (1518, NULL, 'http://localhost:8000/admin/admins?page=1&page_size=10', 'GET', '', NULL, '127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Safari/537.36', 200, 122, '2025-12-27 12:32:16');
INSERT INTO `api_logs` (`id`, `user_id`, `endpoint`, `method`, `request_data`, `response_data`, `ip_address`, `user_agent`, `response_code`, `execution_time`, `created_at`) VALUES (1519, NULL, 'http://localhost:8000/admin/admins?page=1&page_size=10', 'GET', '', NULL, '127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Safari/537.36', 200, 103, '2025-12-27 12:32:16');
INSERT INTO `api_logs` (`id`, `user_id`, `endpoint`, `method`, `request_data`, `response_data`, `ip_address`, `user_agent`, `response_code`, `execution_time`, `created_at`) VALUES (1520, NULL, 'http://localhost:8000/admin/admins', 'OPTIONS', '', NULL, '127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Safari/537.36', 200, 1, '2025-12-27 12:32:26');
INSERT INTO `api_logs` (`id`, `user_id`, `endpoint`, `method`, `request_data`, `response_data`, `ip_address`, `user_agent`, `response_code`, `execution_time`, `created_at`) VALUES (1521, NULL, 'http://localhost:8000/admin/admins', 'POST', '{\"username\":\"ruoyi\",\"password\":\"773340\",\"real_name\":\"111\",\"email\":\"18655955207@163.com\",\"role\":\"admin\"}', NULL, '127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Safari/537.36', 200, 366, '2025-12-27 12:32:27');
INSERT INTO `api_logs` (`id`, `user_id`, `endpoint`, `method`, `request_data`, `response_data`, `ip_address`, `user_agent`, `response_code`, `execution_time`, `created_at`) VALUES (1522, NULL, 'http://localhost:8000/admin/admins?page=1&page_size=10', 'GET', '', NULL, '127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Safari/537.36', 200, 129, '2025-12-27 12:32:27');
INSERT INTO `api_logs` (`id`, `user_id`, `endpoint`, `method`, `request_data`, `response_data`, `ip_address`, `user_agent`, `response_code`, `execution_time`, `created_at`) VALUES (1523, NULL, 'http://localhost:8000/admin/admins/2', 'OPTIONS', '', NULL, '127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Safari/537.36', 200, 0, '2025-12-27 12:32:31');
INSERT INTO `api_logs` (`id`, `user_id`, `endpoint`, `method`, `request_data`, `response_data`, `ip_address`, `user_agent`, `response_code`, `execution_time`, `created_at`) VALUES (1524, NULL, 'http://localhost:8000/admin/admins/2', 'DELETE', '', NULL, '127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Safari/537.36', 200, 150, '2025-12-27 12:32:31');
INSERT INTO `api_logs` (`id`, `user_id`, `endpoint`, `method`, `request_data`, `response_data`, `ip_address`, `user_agent`, `response_code`, `execution_time`, `created_at`) VALUES (1525, NULL, 'http://localhost:8000/admin/admins?page=1&page_size=10', 'GET', '', NULL, '127.0.0.1', 'Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/143.0.0.0 Safari/537.36', 200, 89, '2025-12-27 12:32:31');
COMMIT;

-- ----------------------------
-- Table structure for cards
-- ----------------------------
DROP TABLE IF EXISTS `cards`;
CREATE TABLE `cards` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `card_code` varchar(32) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '卡密代码（唯一）',
  `software_code` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '软件特征码',
  `days` int(11) NOT NULL COMMENT '天数',
  `discount` decimal(5,2) DEFAULT '1.00' COMMENT '折扣（0.01-1.00）',
  `user_id` int(11) DEFAULT NULL COMMENT '激活用户ID（NULL表示未激活）',
  `activated_at` datetime DEFAULT NULL COMMENT '激活时间',
  `expire_time` datetime DEFAULT NULL COMMENT '到期时间（激活时间+天数）',
  `status` tinyint(1) DEFAULT '0' COMMENT '状态：0-未激活，1-已激活，2-已过期',
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `card_code` (`card_code`),
  KEY `idx_card_code` (`card_code`),
  KEY `idx_software_code` (`software_code`),
  KEY `idx_user_id` (`user_id`),
  KEY `idx_status` (`status`),
  KEY `idx_expire_time` (`expire_time`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='卡密表';

-- ----------------------------
-- Records of cards
-- ----------------------------
BEGIN;
INSERT INTO `cards` (`id`, `card_code`, `software_code`, `days`, `discount`, `user_id`, `activated_at`, `expire_time`, `status`, `created_at`, `updated_at`) VALUES (1, 'CARDG0HIYYR4M6', 'buff-xp-steam-sh', 90, 90.00, 2, '2025-11-06 12:10:36', '2026-02-08 12:10:36', 1, '2025-10-15 12:10:36', '2025-11-10 12:10:36');
INSERT INTO `cards` (`id`, `card_code`, `software_code`, `days`, `discount`, `user_id`, `activated_at`, `expire_time`, `status`, `created_at`, `updated_at`) VALUES (2, 'CARD6BWIY4SSZY', 'buff-xp-steam-sh', 30, 85.00, 11, '2025-11-03 12:10:36', '2025-12-10 12:10:36', 1, '2025-10-24 12:10:36', '2025-11-10 12:10:36');
INSERT INTO `cards` (`id`, `card_code`, `software_code`, `days`, `discount`, `user_id`, `activated_at`, `expire_time`, `status`, `created_at`, `updated_at`) VALUES (3, 'CARDG058LNCLQE', 'buff-xp-steam-sh', 7, 90.00, 14, '2025-11-09 12:10:36', '2025-11-17 12:10:36', 1, '2025-09-17 12:10:36', '2025-11-10 12:10:36');
INSERT INTO `cards` (`id`, `card_code`, `software_code`, `days`, `discount`, `user_id`, `activated_at`, `expire_time`, `status`, `created_at`, `updated_at`) VALUES (4, 'CARDBTR39SK77V', 'buff-xp-steam-sh', 90, 100.00, 2, '2025-10-18 12:10:36', '2026-02-08 12:10:36', 1, '2025-10-26 12:10:36', '2025-11-10 12:10:36');
INSERT INTO `cards` (`id`, `card_code`, `software_code`, `days`, `discount`, `user_id`, `activated_at`, `expire_time`, `status`, `created_at`, `updated_at`) VALUES (5, 'CARDBKWZ86ZYIR', 'buff-xp-steam-sh', 90, 85.00, 11, '2025-10-15 12:10:36', '2026-02-08 12:10:36', 1, '2025-10-08 12:10:36', '2025-11-10 12:10:36');
INSERT INTO `cards` (`id`, `card_code`, `software_code`, `days`, `discount`, `user_id`, `activated_at`, `expire_time`, `status`, `created_at`, `updated_at`) VALUES (6, 'CARDRTPB61TQ2R', 'buff-xp-steam-sh', 30, 95.00, 1, '2025-10-27 12:10:36', '2025-12-10 12:10:36', 1, '2025-11-07 12:10:36', '2025-11-10 12:10:36');
INSERT INTO `cards` (`id`, `card_code`, `software_code`, `days`, `discount`, `user_id`, `activated_at`, `expire_time`, `status`, `created_at`, `updated_at`) VALUES (7, 'CARDOC1P65DYBH', 'buff-xp-steam-sh', 365, 95.00, 3, '2025-10-25 12:10:36', '2026-11-10 12:10:36', 1, '2025-09-28 12:10:36', '2025-11-10 12:10:36');
INSERT INTO `cards` (`id`, `card_code`, `software_code`, `days`, `discount`, `user_id`, `activated_at`, `expire_time`, `status`, `created_at`, `updated_at`) VALUES (8, 'CARDGXKWPRR1LE', 'buff-xp-steam-sh', 90, 85.00, 5, '2025-10-21 12:10:36', '2026-02-08 12:10:36', 1, '2025-11-04 12:10:36', '2025-11-10 12:10:36');
INSERT INTO `cards` (`id`, `card_code`, `software_code`, `days`, `discount`, `user_id`, `activated_at`, `expire_time`, `status`, `created_at`, `updated_at`) VALUES (9, 'CARDX3P5L9HUUU', 'buff-xp-steam-sh', 7, 85.00, 10, '2025-10-14 12:10:36', '2025-11-17 12:10:36', 1, '2025-09-22 12:10:36', '2025-11-10 12:10:36');
INSERT INTO `cards` (`id`, `card_code`, `software_code`, `days`, `discount`, `user_id`, `activated_at`, `expire_time`, `status`, `created_at`, `updated_at`) VALUES (10, 'CARDM4ACLPEOSG', 'buff-xp-steam-sh', 30, 85.00, 20, '2025-10-17 12:10:36', '2025-12-10 12:10:36', 1, '2025-11-02 12:10:36', '2025-11-10 12:10:36');
INSERT INTO `cards` (`id`, `card_code`, `software_code`, `days`, `discount`, `user_id`, `activated_at`, `expire_time`, `status`, `created_at`, `updated_at`) VALUES (11, 'XJUG0K2NPGFFG4E4', 'buff-xp-steam-sh', 30, 0.90, 22, '2025-11-10 12:43:02', '2025-12-10 12:43:02', 1, '2025-11-10 12:37:11', '2025-11-10 12:43:02');
COMMIT;

-- ----------------------------
-- Table structure for key_rotation_config
-- ----------------------------
DROP TABLE IF EXISTS `key_rotation_config`;
CREATE TABLE `key_rotation_config` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `rotation_days` int(11) DEFAULT '10' COMMENT '密钥轮换周期（天）',
  `is_auto_rotate` tinyint(1) DEFAULT '1' COMMENT '是否自动轮换：1-是，0-否',
  `last_rotation_time` datetime DEFAULT NULL COMMENT '最后轮换时间',
  `next_rotation_time` datetime DEFAULT NULL COMMENT '下次轮换时间',
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='密钥轮换配置表';

-- ----------------------------
-- Records of key_rotation_config
-- ----------------------------
BEGIN;
INSERT INTO `key_rotation_config` (`id`, `rotation_days`, `is_auto_rotate`, `last_rotation_time`, `next_rotation_time`, `updated_at`) VALUES (1, 10, 1, NULL, NULL, '2025-11-10 11:40:12');
COMMIT;

-- ----------------------------
-- Table structure for operation_logs
-- ----------------------------
DROP TABLE IF EXISTS `operation_logs`;
CREATE TABLE `operation_logs` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `admin_id` int(11) DEFAULT NULL COMMENT '管理员ID',
  `module` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '操作模块',
  `action` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '操作动作',
  `description` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '操作描述',
  `old_data` text COLLATE utf8mb4_unicode_ci COMMENT '操作前数据（JSON）',
  `new_data` text COLLATE utf8mb4_unicode_ci COMMENT '操作后数据（JSON）',
  `ip_address` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'IP地址',
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '操作时间',
  PRIMARY KEY (`id`),
  KEY `idx_admin_id` (`admin_id`),
  KEY `idx_module` (`module`),
  KEY `idx_action` (`action`),
  KEY `idx_created_at` (`created_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='操作日志表';

-- ----------------------------
-- Records of operation_logs
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for recharge_records
-- ----------------------------
DROP TABLE IF EXISTS `recharge_records`;
CREATE TABLE `recharge_records` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `user_id` int(11) NOT NULL COMMENT '用户ID',
  `card_id` int(11) DEFAULT NULL COMMENT '使用的卡密ID',
  `software_code` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '软件特征码',
  `days` int(11) NOT NULL COMMENT '充值天数',
  `amount` decimal(10,2) DEFAULT NULL COMMENT '充值金额（可选，用于统计）',
  `expire_time_before` datetime DEFAULT NULL COMMENT '充值前到期时间',
  `expire_time_after` datetime DEFAULT NULL COMMENT '充值后到期时间',
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '充值时间',
  PRIMARY KEY (`id`),
  KEY `idx_user_id` (`user_id`),
  KEY `idx_card_id` (`card_id`),
  KEY `idx_software_code` (`software_code`),
  KEY `idx_created_at` (`created_at`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='充值记录表';

-- ----------------------------
-- Records of recharge_records
-- ----------------------------
BEGIN;
INSERT INTO `recharge_records` (`id`, `user_id`, `card_id`, `software_code`, `days`, `amount`, `expire_time_before`, `expire_time_after`, `created_at`) VALUES (1, 22, 11, 'buff-xp-steam-sh', 30, NULL, NULL, '2025-12-10 12:43:02', '2025-11-10 12:43:02');
COMMIT;

-- ----------------------------
-- Table structure for software
-- ----------------------------
DROP TABLE IF EXISTS `software`;
CREATE TABLE `software` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `code` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '软件特征码，如：buff-xp-steam-sh',
  `name` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '软件名称',
  `description` text COLLATE utf8mb4_unicode_ci COMMENT '软件描述',
  `daily_price` decimal(10,2) NOT NULL DEFAULT '0.00' COMMENT '每天收费基数（元）',
  `is_active` tinyint(1) DEFAULT '1' COMMENT '是否启用：1-启用，0-禁用',
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `code` (`code`),
  KEY `idx_code` (`code`),
  KEY `idx_is_active` (`is_active`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='软件信息表';

-- ----------------------------
-- Records of software
-- ----------------------------
BEGIN;
INSERT INTO `software` (`id`, `code`, `name`, `description`, `daily_price`, `is_active`, `created_at`, `updated_at`) VALUES (1, 'buff-xp-steam-sh', '游铛铛-Buff选品Steam扫货', 'Buff平台选品和Steam平台扫货软件', 10.00, 1, '2025-11-10 11:40:12', '2025-11-10 11:40:12');
COMMIT;

-- ----------------------------
-- Table structure for steam_accounts
-- ----------------------------
DROP TABLE IF EXISTS `steam_accounts`;
CREATE TABLE `steam_accounts` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `user_id` int(11) NOT NULL COMMENT '用户ID',
  `steam_username` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Steam用户名',
  `steam_id` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Steam ID',
  `shared_secret` text COLLATE utf8mb4_unicode_ci COMMENT 'Steam Guard共享密钥（加密存储）',
  `identity_secret` text COLLATE utf8mb4_unicode_ci COMMENT 'Steam Guard身份密钥（加密存储）',
  `is_active` tinyint(1) DEFAULT '1' COMMENT '是否启用：1-启用，0-禁用',
  `last_used_time` datetime DEFAULT NULL COMMENT '最后使用时间',
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '绑定时间',
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`),
  KEY `idx_user_id` (`user_id`),
  KEY `idx_steam_username` (`steam_username`),
  KEY `idx_is_active` (`is_active`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Steam账号绑定表';

-- ----------------------------
-- Records of steam_accounts
-- ----------------------------
BEGIN;
COMMIT;

-- ----------------------------
-- Table structure for users
-- ----------------------------
DROP TABLE IF EXISTS `users`;
CREATE TABLE `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `username` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '用户名（唯一）',
  `password` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT '密码（加密存储）',
  `email` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '邮箱',
  `machine_code` varchar(64) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '绑定的机器码（MD5）',
  `card_id` int(11) DEFAULT NULL COMMENT '当前激活的卡密ID',
  `expire_time` datetime DEFAULT NULL COMMENT '到期时间',
  `last_login_time` datetime DEFAULT NULL COMMENT '最后登录时间',
  `last_login_ip` varchar(50) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '最后登录IP',
  `status` tinyint(1) DEFAULT '1' COMMENT '状态：1-正常，0-禁用',
  `created_at` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '注册时间',
  `updated_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`),
  KEY `idx_username` (`username`),
  KEY `idx_machine_code` (`machine_code`),
  KEY `idx_card_id` (`card_id`),
  KEY `idx_expire_time` (`expire_time`),
  KEY `idx_status` (`status`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='用户表';

-- ----------------------------
-- Records of users
-- ----------------------------
BEGIN;
INSERT INTO `users` (`id`, `username`, `password`, `email`, `machine_code`, `card_id`, `expire_time`, `last_login_time`, `last_login_ip`, `status`, `created_at`, `updated_at`) VALUES (1, 'testuser01', '$2b$12$WULjuiWarOfwP8xWSSU9Fe1H7jlgSOD2svdjG8u4PDI97QwGuTORu', 'test1@example.com', 'MACHINEYQTRKDIF', NULL, '2025-12-10 12:10:36', NULL, NULL, 1, '2025-09-19 12:10:32', '2025-11-10 12:10:35');
INSERT INTO `users` (`id`, `username`, `password`, `email`, `machine_code`, `card_id`, `expire_time`, `last_login_time`, `last_login_ip`, `status`, `created_at`, `updated_at`) VALUES (2, 'testuser02', '$2b$12$JuJ.zuwbCyFJDoJDRZT1v.wjouUxkuaAp7wawL3cKqDL/Prx8NLTi', 'test2@example.com', 'MACHINE8S3EUXFD', NULL, '2026-02-08 12:10:36', NULL, NULL, 1, '2025-10-21 12:10:32', '2025-11-10 12:10:35');
INSERT INTO `users` (`id`, `username`, `password`, `email`, `machine_code`, `card_id`, `expire_time`, `last_login_time`, `last_login_ip`, `status`, `created_at`, `updated_at`) VALUES (3, 'testuser03', '$2b$12$hm4DRRKGbFqYhw44tSCRxumH6U.dpNDmu7mFtQKQOvq8ryDXmp6ii', 'test3@example.com', 'MACHINEEPSTRIYS', NULL, '2026-11-10 12:10:36', NULL, NULL, 1, '2025-10-16 12:10:32', '2025-11-10 12:10:35');
INSERT INTO `users` (`id`, `username`, `password`, `email`, `machine_code`, `card_id`, `expire_time`, `last_login_time`, `last_login_ip`, `status`, `created_at`, `updated_at`) VALUES (4, 'testuser04', '$2b$12$2uCyLQRg9GillVEPSONC0uFpyzq3H2ESv.E/o4df.LhaL5IVvBDLu', 'test4@example.com', 'MACHINEXUI6XMZ6', NULL, '2025-12-10 12:10:32', NULL, NULL, 1, '2025-08-30 12:10:32', '2025-11-10 12:10:32');
INSERT INTO `users` (`id`, `username`, `password`, `email`, `machine_code`, `card_id`, `expire_time`, `last_login_time`, `last_login_ip`, `status`, `created_at`, `updated_at`) VALUES (5, 'testuser05', '$2b$12$i88/2T9VTAH.9LebcXmcf.8pGNppn8WlsQQHQWGOMHSUbwRGsROmi', 'test5@example.com', 'MACHINEOIQLMOG3', NULL, '2026-02-08 12:10:36', NULL, NULL, 0, '2025-08-16 12:10:33', '2025-11-10 12:10:35');
INSERT INTO `users` (`id`, `username`, `password`, `email`, `machine_code`, `card_id`, `expire_time`, `last_login_time`, `last_login_ip`, `status`, `created_at`, `updated_at`) VALUES (6, 'testuser06', '$2b$12$VzV7udqP6TQPz0RuUjLmRedjRzx8jezhlMpkVtVz4889ltHicKGHO', 'test6@example.com', 'MACHINEJCXJYM2A', NULL, NULL, NULL, NULL, 1, '2025-11-01 12:10:33', '2025-11-10 12:10:33');
INSERT INTO `users` (`id`, `username`, `password`, `email`, `machine_code`, `card_id`, `expire_time`, `last_login_time`, `last_login_ip`, `status`, `created_at`, `updated_at`) VALUES (7, 'testuser07', '$2b$12$9lsvoi.Jj86HcqvuFOvWRO3L3uXoZ86fKjWUG1RBPXBBca3igdelO', 'test7@example.com', 'MACHINEGIHIRNQT', NULL, '2025-12-10 12:10:33', NULL, NULL, 1, '2025-08-15 12:10:33', '2025-11-10 12:10:33');
INSERT INTO `users` (`id`, `username`, `password`, `email`, `machine_code`, `card_id`, `expire_time`, `last_login_time`, `last_login_ip`, `status`, `created_at`, `updated_at`) VALUES (8, 'testuser08', '$2b$12$tZ5lDx61MI2WbSXE7vMGze.xgKfiHG3eg3ShYXp0yYP.6bYZcXxAu', 'test8@example.com', 'MACHINEOYLMTQCI', NULL, '2025-11-09 12:10:33', NULL, NULL, 1, '2025-09-07 12:10:33', '2025-11-10 12:10:33');
INSERT INTO `users` (`id`, `username`, `password`, `email`, `machine_code`, `card_id`, `expire_time`, `last_login_time`, `last_login_ip`, `status`, `created_at`, `updated_at`) VALUES (9, 'testuser09', '$2b$12$aMkUN3nL1cHIjpcnh4Y1O.chKJrIZ4/Psr6.FB8GrGV/s1dNpdMvq', 'test9@example.com', 'MACHINE7MDNWY13', NULL, NULL, NULL, NULL, 1, '2025-08-12 12:10:33', '2025-11-10 12:10:33');
INSERT INTO `users` (`id`, `username`, `password`, `email`, `machine_code`, `card_id`, `expire_time`, `last_login_time`, `last_login_ip`, `status`, `created_at`, `updated_at`) VALUES (10, 'testuser10', '$2b$12$5EQhWXnq3Zpv7Y2ZlCj.GejWI6GMMjx4tuChTLenMpEk2xN5H89h6', 'test10@example.com', 'MACHINEFLMQWRXS', NULL, '2025-11-17 12:10:36', NULL, NULL, 0, '2025-10-31 12:10:34', '2025-11-10 12:10:35');
INSERT INTO `users` (`id`, `username`, `password`, `email`, `machine_code`, `card_id`, `expire_time`, `last_login_time`, `last_login_ip`, `status`, `created_at`, `updated_at`) VALUES (11, 'testuser11', '$2b$12$1X5QSxkh8h/q5n0isfTUX.4M7hr9HKeA1gtFEEYcjhuxeqzGiItrO', 'test11@example.com', 'MACHINEF1RMA8HJ', NULL, '2026-02-08 12:10:36', NULL, NULL, 1, '2025-08-17 12:10:34', '2025-11-10 12:10:35');
INSERT INTO `users` (`id`, `username`, `password`, `email`, `machine_code`, `card_id`, `expire_time`, `last_login_time`, `last_login_ip`, `status`, `created_at`, `updated_at`) VALUES (12, 'testuser12', '$2b$12$Y66RqdXg6x00Bb2WHISj9eLxAOpejCVT4rfDfN2aKSlI8bXeBLibi', 'test12@example.com', 'MACHINEL5MQQCFL', NULL, NULL, NULL, NULL, 1, '2025-09-28 12:10:34', '2025-11-10 12:10:34');
INSERT INTO `users` (`id`, `username`, `password`, `email`, `machine_code`, `card_id`, `expire_time`, `last_login_time`, `last_login_ip`, `status`, `created_at`, `updated_at`) VALUES (13, 'testuser13', '$2b$12$BSJSLfMwaUF/gh5VXoT43u4FcsxxxLtIeS7Gs9FNWF/GQtUdUOi5O', 'test13@example.com', 'MACHINEPZVWBKRC', NULL, '2025-12-10 12:10:34', NULL, NULL, 1, '2025-09-12 12:10:34', '2025-11-10 12:10:34');
INSERT INTO `users` (`id`, `username`, `password`, `email`, `machine_code`, `card_id`, `expire_time`, `last_login_time`, `last_login_ip`, `status`, `created_at`, `updated_at`) VALUES (14, 'testuser14', '$2b$12$b2D2VJqib3Vs5J1XdaqMm.BbTDl8tN9Bcfp3doOVJoBJWFOyKrKqu', 'test14@example.com', 'MACHINEYQUB2Y4I', NULL, '2025-11-17 12:10:36', NULL, NULL, 1, '2025-10-24 12:10:34', '2025-11-10 12:10:35');
INSERT INTO `users` (`id`, `username`, `password`, `email`, `machine_code`, `card_id`, `expire_time`, `last_login_time`, `last_login_ip`, `status`, `created_at`, `updated_at`) VALUES (15, 'testuser15', '$2b$12$Xr2Gkmnlpndhc9G2gTD6buByXnBMduo/kfFUxqVbfPGMPVuF0gvk2', 'test15@example.com', 'MACHINETUWUHYR2', NULL, NULL, NULL, NULL, 0, '2025-09-14 12:10:34', '2025-11-10 12:10:34');
INSERT INTO `users` (`id`, `username`, `password`, `email`, `machine_code`, `card_id`, `expire_time`, `last_login_time`, `last_login_ip`, `status`, `created_at`, `updated_at`) VALUES (16, 'testuser16', '$2b$12$rJppXoNiNspi5/CPxIxqXez3iE5BUIwkojEhwiNEVsu.Jh591HcSG', 'test16@example.com', 'MACHINEPJBXVKXQ', NULL, '2025-12-10 12:10:34', NULL, NULL, 1, '2025-10-30 12:10:35', '2025-11-10 12:10:35');
INSERT INTO `users` (`id`, `username`, `password`, `email`, `machine_code`, `card_id`, `expire_time`, `last_login_time`, `last_login_ip`, `status`, `created_at`, `updated_at`) VALUES (17, 'testuser17', '$2b$12$LrrQtJW0pZUauOrSeeqJoehBfDT8BdRQNjwQD2hVHeRlktmqFc5gy', 'test17@example.com', 'MACHINEZCIZTD49', NULL, '2025-11-09 12:10:35', NULL, NULL, 1, '2025-11-01 12:10:35', '2025-11-10 12:10:35');
INSERT INTO `users` (`id`, `username`, `password`, `email`, `machine_code`, `card_id`, `expire_time`, `last_login_time`, `last_login_ip`, `status`, `created_at`, `updated_at`) VALUES (18, 'testuser18', '$2b$12$/nm8fUSprT8XHuDLT.pUQ.cCKunz7v/KowPFIUy7BRyG94HjwxtWO', 'test18@example.com', 'MACHINEGNEY1WXN', NULL, NULL, NULL, NULL, 1, '2025-09-24 12:10:35', '2025-11-10 12:10:35');
INSERT INTO `users` (`id`, `username`, `password`, `email`, `machine_code`, `card_id`, `expire_time`, `last_login_time`, `last_login_ip`, `status`, `created_at`, `updated_at`) VALUES (19, 'testuser19', '$2b$12$.854wZXGL9/0K5gtKz.uZurZHaOZZQlqTKS51z.wnkksLcz3Ps5EW', 'test19@example.com', 'MACHINEIMAMATL3', NULL, '2025-12-10 12:10:35', NULL, NULL, 1, '2025-10-14 12:10:35', '2025-11-10 12:10:35');
INSERT INTO `users` (`id`, `username`, `password`, `email`, `machine_code`, `card_id`, `expire_time`, `last_login_time`, `last_login_ip`, `status`, `created_at`, `updated_at`) VALUES (20, 'testuser20', '$2b$12$yPBLEmQ6PDyBRAYifBsG7uzo0SY1lktseM/dFucGTEuMel5LUy1G6', 'test20@example.com', 'MACHINEB9AFFRMY', NULL, '2025-12-10 12:10:36', NULL, NULL, 0, '2025-09-24 12:10:35', '2025-11-10 12:10:35');
INSERT INTO `users` (`id`, `username`, `password`, `email`, `machine_code`, `card_id`, `expire_time`, `last_login_time`, `last_login_ip`, `status`, `created_at`, `updated_at`) VALUES (22, 'zlwu1', '$2b$12$R4MmnBFnwzLSS0CW1NT3ourbkDBhIhqHd2s0vr8QxG6lPT/MsIVHi', '704541015@qq.com', 'd62332a485430c275f83ac19912ce2f9', 11, '2025-12-10 12:43:02', '2025-11-21 10:57:26', '127.0.0.1', 1, '2025-11-10 12:43:02', '2025-11-21 10:57:26');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;