| 1234567891011121314151617 |
- -- 表 kku_item_user_output_counters 的创建SQL
- DROP TABLE IF EXISTS `kku_item_user_output_counters`;
- CREATE TABLE `kku_item_user_output_counters` (
- `id` int NOT NULL AUTO_INCREMENT COMMENT '记录ID，主键',
- `user_id` int NOT NULL COMMENT '用户ID',
- `limit_id` int NOT NULL COMMENT '产出限制ID，外键关联kku_item_output_limits表',
- `current_count` int NOT NULL DEFAULT '0' COMMENT '当前产出计数',
- `record_date` date DEFAULT NULL COMMENT '记录日期（用于日期统计和重置）',
- `created_at` timestamp NULL DEFAULT NULL COMMENT '创建时间',
- `updated_at` timestamp NULL DEFAULT NULL COMMENT '更新时间',
- PRIMARY KEY (`id`),
- KEY `idx_user_limit` (`user_id`,`limit_id`),
- KEY `idx_record_date` (`record_date`),
- KEY `fk_user_limit` (`limit_id`),
- CONSTRAINT `fk_user_limit` FOREIGN KEY (`limit_id`) REFERENCES `kku_item_output_limits` (`id`) ON DELETE CASCADE
- ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='用户物品产出限制计数表';
|
