20260222_create_user_steam_account_limit.sql 676 B

1234567891011
  1. -- 每用户 Steam 账号绑定数量上限表(默认 3,管理员可 per-user 修改)
  2. SET NAMES utf8mb4;
  3. DROP TABLE IF EXISTS `user_steam_account_limit`;
  4. CREATE TABLE `user_steam_account_limit` (
  5. `user_id` int(11) NOT NULL COMMENT '用户ID',
  6. `max_steam_accounts` int(11) NOT NULL DEFAULT 3 COMMENT '该用户最多可绑定的 Steam 账号数',
  7. `created_at` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  8. `updated_at` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  9. PRIMARY KEY (`user_id`)
  10. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='每用户Steam账号绑定数量上限';