-- 表 kku_user_daytimes 的创建SQL DROP TABLE IF EXISTS `kku_user_daytimes`; CREATE TABLE `kku_user_daytimes` ( `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 '计数', `day` bigint DEFAULT NULL COMMENT '日期', `created_at` timestamp NULL DEFAULT NULL, `updated_at` timestamp NULL DEFAULT NULL, `deleted_at` timestamp NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci ROW_FORMAT=DYNAMIC COMMENT='用户 每日计数';