kku_user_times.sql 743 B

123456789101112131415
  1. -- 表 kku_user_times 的创建SQL
  2. -- 自动生成于 2025-04-30 03:00:15
  3. DROP TABLE IF EXISTS `kku_user_times`;
  4. CREATE TABLE `kku_user_times` (
  5. `id` int NOT NULL AUTO_INCREMENT COMMENT '主键id',
  6. `user_id` bigint unsigned DEFAULT NULL COMMENT '用户id',
  7. `stype` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '产品类型',
  8. `sid` bigint DEFAULT NULL COMMENT '产品id',
  9. `number` bigint DEFAULT NULL COMMENT '计数',
  10. `created_at` timestamp NULL DEFAULT NULL,
  11. `updated_at` timestamp NULL DEFAULT NULL,
  12. `deleted_at` timestamp NULL DEFAULT NULL,
  13. PRIMARY KEY (`id`) USING BTREE
  14. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='用户计数';