sina-video/initGameCount.sql

UPDATE `awards_user_info` SET `count` = `count` + 2;

CREATE TABLE `awards_user_game` (
                                    `id` int unsigned NOT NULL AUTO_INCREMENT,
                                    `game_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT '游戏ID',
                                    `uid` bigint DEFAULT '0' COMMENT '用户ID',
                                    `begin_at` int DEFAULT '0' COMMENT '开始时间',
                                    `end_at` int DEFAULT '0' COMMENT '结束时间',
                                    `state` int DEFAULT '0' COMMENT '状态：1 有效  2无效',
                                    `number` int DEFAULT '0' COMMENT '彩蛋数量',
                                    `duration` int DEFAULT '0' COMMENT '时长',
                                    `create_at` int DEFAULT '0' COMMENT '创建时间',
                                    `update_at` int DEFAULT '0' COMMENT '修改时间',
                                    PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;


CREATE TABLE `awards_user_game_log` (
                                        `id` int unsigned NOT NULL AUTO_INCREMENT,
                                        `game_id` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT '0' COMMENT '游戏ID',
                                        `uid` bigint DEFAULT NULL COMMENT '用户ID',
                                        `draw` int DEFAULT '0' COMMENT '彩蛋',
                                        `duration` int DEFAULT '0' COMMENT '时长',
                                        `create_at` int DEFAULT '0' COMMENT '创建时间',
                                        PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;