kknongchang_2506/app/Module/Ulogic/Databases/GenerateSql/user_daytimes.sql

-- ******************************************************************
-- 表 kku_user_daytimes 的创建SQL
-- 对应的Model: App\Module\Ulogic\Models\UserDaytime
-- 警告: 此文件由系统自动生成，禁止手动修改！
-- ******************************************************************

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='用户 每日计数';