user_times.sql 704 B

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