kknongchang_2506/app/Module/System/Databases/GenerateSql/continuous_times.sql

-- 表 kku_continuous_times 的创建SQL

DROP TABLE IF EXISTS `kku_continuous_times`;
CREATE TABLE `kku_continuous_times` (
  `id` int NOT NULL AUTO_INCREMENT COMMENT '主键id',
  `user_id` bigint unsigned DEFAULT NULL COMMENT '用户id',
  `stype` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT '产品类型',
  `sid` bigint DEFAULT NULL COMMENT '产品id',
  `number` bigint DEFAULT NULL COMMENT '计数',
  `last_time` bigint DEFAULT NULL COMMENT '最后的时间',
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `diff` int DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci COMMENT='连续次数判定';