slambb_smartbowgame/SmartBowDatabase/smart_bow_withdata.sql

/*
Navicat MySQL Data Transfer

Source Server         : localhost_3306
Source Server Version : 80020
Source Host           : localhost:3306
Source Database       : smart_bow

Target Server Type    : MYSQL
Target Server Version : 80020
File Encoding         : 65001

Date: 2022-08-25 11:40:03
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for admin_user
-- ----------------------------
DROP TABLE IF EXISTS `admin_user`;
CREATE TABLE `admin_user` (
  `username` varchar(32) NOT NULL,
  `password` varchar(32) NOT NULL,
  `token` varchar(32) NOT NULL,
  PRIMARY KEY (`username`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of admin_user
-- ----------------------------
INSERT INTO `admin_user` VALUES ('admin', '123456', '86df6484ee6c425998b289faab27eee6');

-- ----------------------------
-- Table structure for game10_score
-- ----------------------------
DROP TABLE IF EXISTS `game10_score`;
CREATE TABLE `game10_score` (
  `userID` int NOT NULL,
  `score` int NOT NULL,
  `update_time` timestamp NOT NULL ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`userID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of game10_score
-- ----------------------------
INSERT INTO `game10_score` VALUES ('12', '80', '2022-04-05 22:28:49');
INSERT INTO `game10_score` VALUES ('21', '70', '2022-04-05 22:28:49');

-- ----------------------------
-- Table structure for game11_score
-- ----------------------------
DROP TABLE IF EXISTS `game11_score`;
CREATE TABLE `game11_score` (
  `userID` int NOT NULL,
  `score` int NOT NULL,
  `update_time` timestamp NOT NULL ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`userID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of game11_score
-- ----------------------------

-- ----------------------------
-- Table structure for game12_score
-- ----------------------------
DROP TABLE IF EXISTS `game12_score`;
CREATE TABLE `game12_score` (
  `userID` int NOT NULL,
  `score` int NOT NULL,
  `update_time` timestamp NOT NULL ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`userID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of game12_score
-- ----------------------------
INSERT INTO `game12_score` VALUES ('12', '155', '2022-04-13 05:18:34');
INSERT INTO `game12_score` VALUES ('21', '145', '2022-04-13 05:18:34');

-- ----------------------------
-- Table structure for game9_score
-- ----------------------------
DROP TABLE IF EXISTS `game9_score`;
CREATE TABLE `game9_score` (
  `userID` int NOT NULL,
  `score` int NOT NULL,
  `update_time` timestamp NOT NULL ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`userID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of game9_score
-- ----------------------------
INSERT INTO `game9_score` VALUES ('10', '13', '2022-04-21 16:41:23');
INSERT INTO `game9_score` VALUES ('12', '90', '2022-04-09 13:27:59');
INSERT INTO `game9_score` VALUES ('15', '99', '2022-03-28 00:00:00');
INSERT INTO `game9_score` VALUES ('16', '102', '2022-03-28 23:50:57');
INSERT INTO `game9_score` VALUES ('17', '102', '2022-03-28 23:49:03');
INSERT INTO `game9_score` VALUES ('18', '102', '2022-03-28 23:49:07');
INSERT INTO `game9_score` VALUES ('19', '98', '2022-03-28 00:00:00');
INSERT INTO `game9_score` VALUES ('20', '11', '2022-04-21 16:41:05');
INSERT INTO `game9_score` VALUES ('21', '10', '2022-04-09 13:28:00');
INSERT INTO `game9_score` VALUES ('22', '12', '2022-04-21 16:41:15');
INSERT INTO `game9_score` VALUES ('23', '14', '2022-04-21 16:41:36');
INSERT INTO `game9_score` VALUES ('24', '15', '2022-04-21 16:41:42');
INSERT INTO `game9_score` VALUES ('26', '16', '2022-04-21 16:41:56');

-- ----------------------------
-- Table structure for room_game_record
-- ----------------------------
DROP TABLE IF EXISTS `room_game_record`;
CREATE TABLE `room_game_record` (
  `roomKey` varchar(32) NOT NULL,
  `gameType` int NOT NULL,
  `p1ID` int NOT NULL,
  `p2ID` int NOT NULL,
  `gameRes` int NOT NULL,
  `settleTime` bigint NOT NULL,
  `playerIDSeq` varchar(32) NOT NULL,
  PRIMARY KEY (`roomKey`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of room_game_record
-- ----------------------------
INSERT INTO `room_game_record` VALUES ('42b12a8bef8d439e83840670249ee2d4', '12', '21', '12', '1', '1649793219803', '12&21');
INSERT INTO `room_game_record` VALUES ('58d6cdc9de83455ba7a742ba84e64fce', '12', '21', '12', '2', '1649793633119', '12&21');
INSERT INTO `room_game_record` VALUES ('598abdc1a6834f16bb55493a2b674420', '12', '21', '12', '2', '1649793889719', '12&21');
INSERT INTO `room_game_record` VALUES ('65b63077b67144eea67d583e129720cc', '12', '21', '12', '2', '1649793658706', '12&21');
INSERT INTO `room_game_record` VALUES ('6f62c7e55ec041f9b262843580d5ab91', '12', '12', '22', '1', '1649803987279', '12&22');
INSERT INTO `room_game_record` VALUES ('6f62c7e55ec041f9b262843580d5ab92', '12', '12', '21', '2', '1649803987276', '12&21');
INSERT INTO `room_game_record` VALUES ('a1497ae395524a26afaf38a43c678b76', '12', '21', '12', '2', '1649793810523', '12&21');
INSERT INTO `room_game_record` VALUES ('ab04e6a05ae34333b5079b32a1e447a3', '12', '21', '12', '2', '1649796821543', '12&21');
INSERT INTO `room_game_record` VALUES ('adb39f1b1ea045caa9ede20032de6c27', '12', '21', '12', '2', '1649796913195', '12&21');
INSERT INTO `room_game_record` VALUES ('db933129c526417297295cc2e930e3a4', '12', '21', '12', '0', '1649793107642', '12&21');
INSERT INTO `room_game_record` VALUES ('fdec19f01e924ff3a0cbf33e32337a97', '12', '12', '21', '0', '1649798314554', '12&21');

-- ----------------------------
-- Table structure for user_day_active
-- ----------------------------
DROP TABLE IF EXISTS `user_day_active`;
CREATE TABLE `user_day_active` (
  `id` int NOT NULL,
  `date` date NOT NULL,
  PRIMARY KEY (`id`,`date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of user_day_active
-- ----------------------------
INSERT INTO `user_day_active` VALUES ('12', '2022-04-21');
INSERT INTO `user_day_active` VALUES ('12', '2022-05-09');
INSERT INTO `user_day_active` VALUES ('12', '2022-08-06');
INSERT INTO `user_day_active` VALUES ('21', '2022-04-21');
INSERT INTO `user_day_active` VALUES ('27', '2022-08-09');

-- ----------------------------
-- Table structure for user_friend
-- ----------------------------
DROP TABLE IF EXISTS `user_friend`;
CREATE TABLE `user_friend` (
  `myID` int NOT NULL,
  `friendID` int NOT NULL,
  PRIMARY KEY (`myID`,`friendID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of user_friend
-- ----------------------------
INSERT INTO `user_friend` VALUES ('12', '21');
INSERT INTO `user_friend` VALUES ('21', '12');
INSERT INTO `user_friend` VALUES ('22', '21');
INSERT INTO `user_friend` VALUES ('23', '21');

-- ----------------------------
-- Table structure for user_friend_request
-- ----------------------------
DROP TABLE IF EXISTS `user_friend_request`;
CREATE TABLE `user_friend_request` (
  `myID` int NOT NULL,
  `otherID` int NOT NULL,
  PRIMARY KEY (`myID`,`otherID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of user_friend_request
-- ----------------------------
INSERT INTO `user_friend_request` VALUES ('22', '12');

-- ----------------------------
-- Table structure for user_game_record
-- ----------------------------
DROP TABLE IF EXISTS `user_game_record`;
CREATE TABLE `user_game_record` (
  `userID` int NOT NULL,
  `dateTime` datetime NOT NULL,
  `gameType` int NOT NULL,
  `duration` int NOT NULL,
  PRIMARY KEY (`userID`,`dateTime`),
  KEY `userID` (`userID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of user_game_record
-- ----------------------------
INSERT INTO `user_game_record` VALUES ('12', '2022-08-16 00:00:00', '1', '60');
INSERT INTO `user_game_record` VALUES ('12', '2022-08-16 01:01:01', '2', '60');
INSERT INTO `user_game_record` VALUES ('12', '2022-08-16 02:02:02', '3', '60');
INSERT INTO `user_game_record` VALUES ('12', '2022-08-16 03:03:03', '4', '60');
INSERT INTO `user_game_record` VALUES ('12', '2022-08-16 04:04:04', '5', '60');
INSERT INTO `user_game_record` VALUES ('12', '2022-08-16 05:05:05', '6', '60');
INSERT INTO `user_game_record` VALUES ('12', '2022-08-16 06:06:06', '7', '60');
INSERT INTO `user_game_record` VALUES ('12', '2022-08-16 07:07:07', '8', '60');
INSERT INTO `user_game_record` VALUES ('12', '2022-08-16 08:08:08', '9', '60');
INSERT INTO `user_game_record` VALUES ('12', '2022-08-16 09:09:09', '10', '60');
INSERT INTO `user_game_record` VALUES ('12', '2022-08-16 10:10:10', '11', '60');
INSERT INTO `user_game_record` VALUES ('12', '2022-08-16 11:11:11', '12', '60');
INSERT INTO `user_game_record` VALUES ('12', '2022-08-16 12:12:12', '1', '60');
INSERT INTO `user_game_record` VALUES ('12', '2022-08-16 13:13:13', '2', '60');
INSERT INTO `user_game_record` VALUES ('12', '2022-08-16 14:14:14', '3', '60');
INSERT INTO `user_game_record` VALUES ('12', '2022-08-16 15:15:15', '4', '60');
INSERT INTO `user_game_record` VALUES ('12', '2022-08-16 16:16:16', '5', '60');
INSERT INTO `user_game_record` VALUES ('12', '2022-08-16 17:17:17', '6', '60');
INSERT INTO `user_game_record` VALUES ('12', '2022-08-16 18:18:18', '7', '60');
INSERT INTO `user_game_record` VALUES ('12', '2022-08-16 19:19:19', '8', '60');
INSERT INTO `user_game_record` VALUES ('12', '2022-08-16 20:20:20', '9', '60');
INSERT INTO `user_game_record` VALUES ('12', '2022-08-16 21:21:21', '10', '60');
INSERT INTO `user_game_record` VALUES ('12', '2022-08-16 22:22:22', '11', '60');
INSERT INTO `user_game_record` VALUES ('12', '2022-08-16 23:23:23', '12', '60');
INSERT INTO `user_game_record` VALUES ('12', '2022-08-17 00:00:00', '1', '60');
INSERT INTO `user_game_record` VALUES ('12', '2022-08-17 01:01:01', '2', '60');
INSERT INTO `user_game_record` VALUES ('12', '2022-08-17 02:02:02', '3', '60');
INSERT INTO `user_game_record` VALUES ('12', '2022-08-17 03:03:03', '4', '60');
INSERT INTO `user_game_record` VALUES ('12', '2022-08-17 04:04:04', '5', '60');
INSERT INTO `user_game_record` VALUES ('12', '2022-08-17 05:05:05', '6', '60');
INSERT INTO `user_game_record` VALUES ('12', '2022-08-17 06:06:06', '7', '60');
INSERT INTO `user_game_record` VALUES ('12', '2022-08-17 07:07:07', '8', '60');
INSERT INTO `user_game_record` VALUES ('12', '2022-08-17 08:08:08', '9', '60');
INSERT INTO `user_game_record` VALUES ('12', '2022-08-17 09:09:09', '10', '60');
INSERT INTO `user_game_record` VALUES ('12', '2022-08-17 10:10:10', '11', '60');
INSERT INTO `user_game_record` VALUES ('12', '2022-08-17 11:11:11', '12', '60');
INSERT INTO `user_game_record` VALUES ('12', '2022-08-17 12:12:12', '1', '60');
INSERT INTO `user_game_record` VALUES ('12', '2022-08-17 13:13:13', '2', '60');
INSERT INTO `user_game_record` VALUES ('12', '2022-08-17 14:14:14', '3', '60');
INSERT INTO `user_game_record` VALUES ('12', '2022-08-17 15:15:15', '4', '60');
INSERT INTO `user_game_record` VALUES ('12', '2022-08-17 16:16:16', '5', '60');
INSERT INTO `user_game_record` VALUES ('12', '2022-08-17 17:17:17', '6', '60');
INSERT INTO `user_game_record` VALUES ('12', '2022-08-17 18:18:18', '7', '60');
INSERT INTO `user_game_record` VALUES ('12', '2022-08-17 19:19:19', '8', '60');
INSERT INTO `user_game_record` VALUES ('12', '2022-08-17 20:20:20', '9', '60');
INSERT INTO `user_game_record` VALUES ('12', '2022-08-17 21:21:21', '10', '60');
INSERT INTO `user_game_record` VALUES ('12', '2022-08-17 22:22:22', '11', '60');
INSERT INTO `user_game_record` VALUES ('12', '2022-08-17 23:23:23', '12', '60');
INSERT INTO `user_game_record` VALUES ('12', '2022-08-18 00:00:00', '1', '60');
INSERT INTO `user_game_record` VALUES ('12', '2022-08-18 01:01:01', '2', '60');
INSERT INTO `user_game_record` VALUES ('12', '2022-08-18 02:02:02', '3', '60');
INSERT INTO `user_game_record` VALUES ('12', '2022-08-18 03:03:03', '4', '60');
INSERT INTO `user_game_record` VALUES ('12', '2022-08-18 04:04:04', '5', '60');
INSERT INTO `user_game_record` VALUES ('12', '2022-08-18 05:05:05', '6', '60');
INSERT INTO `user_game_record` VALUES ('12', '2022-08-18 06:06:06', '7', '60');
INSERT INTO `user_game_record` VALUES ('12', '2022-08-18 07:07:07', '8', '60');
INSERT INTO `user_game_record` VALUES ('12', '2022-08-18 08:08:08', '9', '60');
INSERT INTO `user_game_record` VALUES ('12', '2022-08-18 09:09:09', '10', '60');
INSERT INTO `user_game_record` VALUES ('12', '2022-08-18 10:10:10', '11', '60');
INSERT INTO `user_game_record` VALUES ('12', '2022-08-18 11:11:11', '12', '60');
INSERT INTO `user_game_record` VALUES ('12', '2022-08-18 12:12:12', '1', '60');
INSERT INTO `user_game_record` VALUES ('12', '2022-08-18 13:13:13', '2', '60');
INSERT INTO `user_game_record` VALUES ('12', '2022-08-18 14:14:14', '3', '60');
INSERT INTO `user_game_record` VALUES ('12', '2022-08-18 15:15:15', '4', '60');
INSERT INTO `user_game_record` VALUES ('12', '2022-08-18 16:16:16', '5', '60');
INSERT INTO `user_game_record` VALUES ('12', '2022-08-18 17:17:17', '6', '60');
INSERT INTO `user_game_record` VALUES ('12', '2022-08-18 18:18:18', '7', '60');
INSERT INTO `user_game_record` VALUES ('12', '2022-08-18 19:19:19', '8', '60');
INSERT INTO `user_game_record` VALUES ('12', '2022-08-18 20:20:20', '9', '60');
INSERT INTO `user_game_record` VALUES ('12', '2022-08-18 21:21:21', '10', '60');
INSERT INTO `user_game_record` VALUES ('12', '2022-08-18 22:22:22', '11', '60');
INSERT INTO `user_game_record` VALUES ('12', '2022-08-18 23:23:23', '12', '60');
INSERT INTO `user_game_record` VALUES ('21', '2022-08-16 00:00:00', '1', '60');
INSERT INTO `user_game_record` VALUES ('21', '2022-08-16 01:01:01', '2', '60');
INSERT INTO `user_game_record` VALUES ('21', '2022-08-16 02:02:02', '3', '60');
INSERT INTO `user_game_record` VALUES ('21', '2022-08-16 03:03:03', '4', '60');
INSERT INTO `user_game_record` VALUES ('21', '2022-08-16 04:04:04', '5', '60');
INSERT INTO `user_game_record` VALUES ('21', '2022-08-16 05:05:05', '6', '60');
INSERT INTO `user_game_record` VALUES ('21', '2022-08-16 06:06:06', '7', '60');
INSERT INTO `user_game_record` VALUES ('21', '2022-08-16 07:07:07', '8', '60');
INSERT INTO `user_game_record` VALUES ('21', '2022-08-16 08:08:08', '9', '60');
INSERT INTO `user_game_record` VALUES ('21', '2022-08-16 09:09:09', '10', '60');
INSERT INTO `user_game_record` VALUES ('21', '2022-08-16 10:10:10', '11', '60');
INSERT INTO `user_game_record` VALUES ('21', '2022-08-16 11:11:11', '12', '60');
INSERT INTO `user_game_record` VALUES ('21', '2022-08-16 12:12:12', '1', '60');
INSERT INTO `user_game_record` VALUES ('21', '2022-08-16 13:13:13', '2', '60');
INSERT INTO `user_game_record` VALUES ('21', '2022-08-16 14:14:14', '3', '60');
INSERT INTO `user_game_record` VALUES ('21', '2022-08-16 15:15:15', '4', '60');
INSERT INTO `user_game_record` VALUES ('21', '2022-08-16 16:16:16', '5', '60');
INSERT INTO `user_game_record` VALUES ('21', '2022-08-16 17:17:17', '6', '60');
INSERT INTO `user_game_record` VALUES ('21', '2022-08-16 18:18:18', '7', '60');
INSERT INTO `user_game_record` VALUES ('21', '2022-08-16 19:19:19', '8', '60');
INSERT INTO `user_game_record` VALUES ('21', '2022-08-16 20:20:20', '9', '60');
INSERT INTO `user_game_record` VALUES ('21', '2022-08-16 21:21:21', '10', '60');
INSERT INTO `user_game_record` VALUES ('21', '2022-08-16 22:22:22', '11', '60');
INSERT INTO `user_game_record` VALUES ('21', '2022-08-16 23:23:23', '12', '60');
INSERT INTO `user_game_record` VALUES ('21', '2022-08-17 00:00:00', '1', '60');
INSERT INTO `user_game_record` VALUES ('21', '2022-08-17 01:01:01', '2', '60');
INSERT INTO `user_game_record` VALUES ('21', '2022-08-17 02:02:02', '3', '60');
INSERT INTO `user_game_record` VALUES ('21', '2022-08-17 03:03:03', '4', '60');
INSERT INTO `user_game_record` VALUES ('21', '2022-08-17 04:04:04', '5', '60');
INSERT INTO `user_game_record` VALUES ('21', '2022-08-17 05:05:05', '6', '60');
INSERT INTO `user_game_record` VALUES ('21', '2022-08-17 06:06:06', '7', '60');
INSERT INTO `user_game_record` VALUES ('21', '2022-08-17 07:07:07', '8', '60');
INSERT INTO `user_game_record` VALUES ('21', '2022-08-17 08:08:08', '9', '60');
INSERT INTO `user_game_record` VALUES ('21', '2022-08-17 09:09:09', '10', '60');
INSERT INTO `user_game_record` VALUES ('21', '2022-08-17 10:10:10', '11', '60');
INSERT INTO `user_game_record` VALUES ('21', '2022-08-17 11:11:11', '12', '60');
INSERT INTO `user_game_record` VALUES ('21', '2022-08-17 12:12:12', '1', '60');
INSERT INTO `user_game_record` VALUES ('21', '2022-08-17 13:13:13', '2', '60');
INSERT INTO `user_game_record` VALUES ('21', '2022-08-17 14:14:14', '3', '60');
INSERT INTO `user_game_record` VALUES ('21', '2022-08-17 15:15:15', '4', '60');
INSERT INTO `user_game_record` VALUES ('21', '2022-08-17 16:16:16', '5', '60');
INSERT INTO `user_game_record` VALUES ('21', '2022-08-17 17:17:17', '6', '60');
INSERT INTO `user_game_record` VALUES ('21', '2022-08-17 18:18:18', '7', '60');
INSERT INTO `user_game_record` VALUES ('21', '2022-08-17 19:19:19', '8', '60');
INSERT INTO `user_game_record` VALUES ('21', '2022-08-17 20:20:20', '9', '60');
INSERT INTO `user_game_record` VALUES ('21', '2022-08-17 21:21:21', '10', '60');
INSERT INTO `user_game_record` VALUES ('21', '2022-08-17 22:22:22', '11', '60');
INSERT INTO `user_game_record` VALUES ('21', '2022-08-17 23:23:23', '12', '60');
INSERT INTO `user_game_record` VALUES ('21', '2022-08-18 00:00:00', '1', '60');
INSERT INTO `user_game_record` VALUES ('21', '2022-08-18 01:01:01', '2', '60');
INSERT INTO `user_game_record` VALUES ('21', '2022-08-18 02:02:02', '3', '60');
INSERT INTO `user_game_record` VALUES ('21', '2022-08-18 03:03:03', '4', '60');
INSERT INTO `user_game_record` VALUES ('21', '2022-08-18 04:04:04', '5', '60');
INSERT INTO `user_game_record` VALUES ('21', '2022-08-18 05:05:05', '6', '60');
INSERT INTO `user_game_record` VALUES ('21', '2022-08-18 06:06:06', '7', '60');
INSERT INTO `user_game_record` VALUES ('21', '2022-08-18 07:07:07', '8', '60');
INSERT INTO `user_game_record` VALUES ('21', '2022-08-18 08:08:08', '9', '60');
INSERT INTO `user_game_record` VALUES ('21', '2022-08-18 09:09:09', '10', '60');
INSERT INTO `user_game_record` VALUES ('21', '2022-08-18 10:10:10', '11', '60');
INSERT INTO `user_game_record` VALUES ('21', '2022-08-18 11:11:11', '12', '60');
INSERT INTO `user_game_record` VALUES ('21', '2022-08-18 12:12:12', '1', '60');
INSERT INTO `user_game_record` VALUES ('21', '2022-08-18 13:13:13', '2', '60');
INSERT INTO `user_game_record` VALUES ('21', '2022-08-18 14:14:14', '3', '60');
INSERT INTO `user_game_record` VALUES ('21', '2022-08-18 15:15:15', '4', '60');
INSERT INTO `user_game_record` VALUES ('21', '2022-08-18 16:16:16', '5', '60');
INSERT INTO `user_game_record` VALUES ('21', '2022-08-18 17:17:17', '6', '60');
INSERT INTO `user_game_record` VALUES ('21', '2022-08-18 18:18:18', '7', '60');
INSERT INTO `user_game_record` VALUES ('21', '2022-08-18 19:19:19', '8', '60');
INSERT INTO `user_game_record` VALUES ('21', '2022-08-18 20:20:20', '9', '60');
INSERT INTO `user_game_record` VALUES ('21', '2022-08-18 21:21:21', '10', '60');
INSERT INTO `user_game_record` VALUES ('21', '2022-08-18 22:22:22', '11', '60');
INSERT INTO `user_game_record` VALUES ('21', '2022-08-18 23:23:23', '12', '60');
INSERT INTO `user_game_record` VALUES ('22', '2022-08-16 00:00:00', '1', '60');
INSERT INTO `user_game_record` VALUES ('22', '2022-08-16 01:01:01', '2', '60');
INSERT INTO `user_game_record` VALUES ('22', '2022-08-16 02:02:02', '3', '60');
INSERT INTO `user_game_record` VALUES ('22', '2022-08-16 03:03:03', '4', '60');
INSERT INTO `user_game_record` VALUES ('22', '2022-08-16 04:04:04', '5', '60');
INSERT INTO `user_game_record` VALUES ('22', '2022-08-16 05:05:05', '6', '60');
INSERT INTO `user_game_record` VALUES ('22', '2022-08-16 06:06:06', '7', '60');
INSERT INTO `user_game_record` VALUES ('22', '2022-08-16 07:07:07', '8', '60');
INSERT INTO `user_game_record` VALUES ('22', '2022-08-16 08:08:08', '9', '60');
INSERT INTO `user_game_record` VALUES ('22', '2022-08-16 09:09:09', '10', '60');
INSERT INTO `user_game_record` VALUES ('22', '2022-08-16 10:10:10', '11', '60');
INSERT INTO `user_game_record` VALUES ('22', '2022-08-16 11:11:11', '12', '60');
INSERT INTO `user_game_record` VALUES ('22', '2022-08-16 12:12:12', '1', '60');
INSERT INTO `user_game_record` VALUES ('22', '2022-08-16 13:13:13', '2', '60');
INSERT INTO `user_game_record` VALUES ('22', '2022-08-16 14:14:14', '3', '60');
INSERT INTO `user_game_record` VALUES ('22', '2022-08-16 15:15:15', '4', '60');
INSERT INTO `user_game_record` VALUES ('22', '2022-08-16 16:16:16', '5', '60');
INSERT INTO `user_game_record` VALUES ('22', '2022-08-16 17:17:17', '6', '60');
INSERT INTO `user_game_record` VALUES ('22', '2022-08-16 18:18:18', '7', '60');
INSERT INTO `user_game_record` VALUES ('22', '2022-08-16 19:19:19', '8', '60');
INSERT INTO `user_game_record` VALUES ('22', '2022-08-16 20:20:20', '9', '60');
INSERT INTO `user_game_record` VALUES ('22', '2022-08-16 21:21:21', '10', '60');
INSERT INTO `user_game_record` VALUES ('22', '2022-08-16 22:22:22', '11', '60');
INSERT INTO `user_game_record` VALUES ('22', '2022-08-16 23:23:23', '12', '60');
INSERT INTO `user_game_record` VALUES ('22', '2022-08-17 00:00:00', '1', '60');
INSERT INTO `user_game_record` VALUES ('22', '2022-08-17 01:01:01', '2', '60');
INSERT INTO `user_game_record` VALUES ('22', '2022-08-17 02:02:02', '3', '60');
INSERT INTO `user_game_record` VALUES ('22', '2022-08-17 03:03:03', '4', '60');
INSERT INTO `user_game_record` VALUES ('22', '2022-08-17 04:04:04', '5', '60');
INSERT INTO `user_game_record` VALUES ('22', '2022-08-17 05:05:05', '6', '60');
INSERT INTO `user_game_record` VALUES ('22', '2022-08-17 06:06:06', '7', '60');
INSERT INTO `user_game_record` VALUES ('22', '2022-08-17 07:07:07', '8', '60');
INSERT INTO `user_game_record` VALUES ('22', '2022-08-17 08:08:08', '9', '60');
INSERT INTO `user_game_record` VALUES ('22', '2022-08-17 09:09:09', '10', '60');
INSERT INTO `user_game_record` VALUES ('22', '2022-08-17 10:10:10', '11', '60');
INSERT INTO `user_game_record` VALUES ('22', '2022-08-17 11:11:11', '12', '60');
INSERT INTO `user_game_record` VALUES ('22', '2022-08-17 12:12:12', '1', '60');
INSERT INTO `user_game_record` VALUES ('22', '2022-08-17 13:13:13', '2', '60');
INSERT INTO `user_game_record` VALUES ('22', '2022-08-17 14:14:14', '3', '60');
INSERT INTO `user_game_record` VALUES ('22', '2022-08-17 15:15:15', '4', '60');
INSERT INTO `user_game_record` VALUES ('22', '2022-08-17 16:16:16', '5', '60');
INSERT INTO `user_game_record` VALUES ('22', '2022-08-17 17:17:17', '6', '60');
INSERT INTO `user_game_record` VALUES ('22', '2022-08-17 18:18:18', '7', '60');
INSERT INTO `user_game_record` VALUES ('22', '2022-08-17 19:19:19', '8', '60');
INSERT INTO `user_game_record` VALUES ('22', '2022-08-17 20:20:20', '9', '60');
INSERT INTO `user_game_record` VALUES ('22', '2022-08-17 21:21:21', '10', '60');
INSERT INTO `user_game_record` VALUES ('22', '2022-08-17 22:22:22', '11', '60');
INSERT INTO `user_game_record` VALUES ('22', '2022-08-17 23:23:23', '12', '60');
INSERT INTO `user_game_record` VALUES ('22', '2022-08-18 00:00:00', '1', '60');
INSERT INTO `user_game_record` VALUES ('22', '2022-08-18 01:01:01', '2', '60');
INSERT INTO `user_game_record` VALUES ('22', '2022-08-18 02:02:02', '3', '60');
INSERT INTO `user_game_record` VALUES ('22', '2022-08-18 03:03:03', '4', '60');
INSERT INTO `user_game_record` VALUES ('22', '2022-08-18 04:04:04', '5', '60');
INSERT INTO `user_game_record` VALUES ('22', '2022-08-18 05:05:05', '6', '60');
INSERT INTO `user_game_record` VALUES ('22', '2022-08-18 06:06:06', '7', '60');
INSERT INTO `user_game_record` VALUES ('22', '2022-08-18 07:07:07', '8', '60');
INSERT INTO `user_game_record` VALUES ('22', '2022-08-18 08:08:08', '9', '60');
INSERT INTO `user_game_record` VALUES ('22', '2022-08-18 09:09:09', '10', '60');
INSERT INTO `user_game_record` VALUES ('22', '2022-08-18 10:10:10', '11', '60');
INSERT INTO `user_game_record` VALUES ('22', '2022-08-18 11:11:11', '12', '60');
INSERT INTO `user_game_record` VALUES ('22', '2022-08-18 12:12:12', '1', '60');
INSERT INTO `user_game_record` VALUES ('22', '2022-08-18 13:13:13', '2', '60');
INSERT INTO `user_game_record` VALUES ('22', '2022-08-18 14:14:14', '3', '60');
INSERT INTO `user_game_record` VALUES ('22', '2022-08-18 15:15:15', '4', '60');
INSERT INTO `user_game_record` VALUES ('22', '2022-08-18 16:16:16', '5', '60');
INSERT INTO `user_game_record` VALUES ('22', '2022-08-18 17:17:17', '6', '60');
INSERT INTO `user_game_record` VALUES ('22', '2022-08-18 18:18:18', '7', '60');
INSERT INTO `user_game_record` VALUES ('22', '2022-08-18 19:19:19', '8', '60');
INSERT INTO `user_game_record` VALUES ('22', '2022-08-18 20:20:20', '9', '60');
INSERT INTO `user_game_record` VALUES ('22', '2022-08-18 21:21:21', '10', '60');
INSERT INTO `user_game_record` VALUES ('22', '2022-08-18 22:22:22', '11', '60');
INSERT INTO `user_game_record` VALUES ('22', '2022-08-18 23:23:23', '12', '60');

-- ----------------------------
-- Table structure for user_info
-- ----------------------------
DROP TABLE IF EXISTS `user_info`;
CREATE TABLE `user_info` (
  `id` int NOT NULL,
  `avatarID` int NOT NULL,
  `nickname` varchar(16) NOT NULL,
  `gender` int NOT NULL,
  `phone` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `birthday` varchar(10) NOT NULL,
  `country` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `state` varchar(10) NOT NULL,
  `city` varchar(10) NOT NULL,
  `integral` int NOT NULL,
  `coin` int NOT NULL,
  `diamond` int NOT NULL,
  `mac` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
  `bagList` varchar(2048) NOT NULL,
  `deviceList` varchar(2048) NOT NULL,
  `timeLimitGameScores` varchar(255) NOT NULL,
  `challengeLevels` varchar(255) NOT NULL,
  `offlineTime` bigint NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of user_info
-- ----------------------------
INSERT INTO `user_info` VALUES ('10', '2', '阿瑟东', '2', '13235656565', '2022-03-26', '1', '11', '1', '0', '0', '106', '', '[{\"count\":1,\"id\":25,\"inuse\":false},{\"count\":1,\"id\":12,\"inuse\":false},{\"count\":1,\"id\":13,\"inuse\":true},{\"count\":1,\"id\":14,\"inuse\":false},{\"count\":1,\"id\":15,\"inuse\":false},{\"count\":1,\"id\":22,\"inuse\":false},{\"count\":1,\"id\":23,\"inuse\":false},{\"count\":1,\"id\":24,\"inuse\":false}]', '[{\"id\":1000,\"inuse\":true},{\"id\":2000,\"inuse\":true}]', '{}', '{}', '0');
INSERT INTO `user_info` VALUES ('12', '8', '吕锦成', '1', '17875300045', '2022-03-26', '1', '11', '1', '0', '0', '506', '', '[{\"count\":1,\"id\":13,\"inuse\":true},{\"count\":1,\"id\":25,\"inuse\":true}]', '[{\"id\":1000,\"inuse\":true},{\"id\":2000,\"inuse\":true}]', '{}', '{3:4}', '1659757868298');
INSERT INTO `user_info` VALUES ('15', '3', '2222', '2', '', '2022-03-26', '1', '11', '2', '0', '0', '666', '', '[]', '[]', '{}', '{}', '0');
INSERT INTO `user_info` VALUES ('16', '26', 'Player16', '1', '', '', '', '', '', '0', '0', '666', '', '[]', '[{\"id\":1000,\"inuse\":true},{\"id\":2000,\"inuse\":true}]', '{}', '{}', '0');
INSERT INTO `user_info` VALUES ('17', '4', 'Player17', '2', '', '2022-03-26', '1', '14', '1', '0', '0', '666', '', '[]', '[]', '{}', '{}', '0');
INSERT INTO `user_info` VALUES ('18', '5', 'Player18', '1', '', '', '', '', '', '0', '0', '666', '', '[]', '[]', '{}', '{}', '0');
INSERT INTO `user_info` VALUES ('19', '7', 'Player', '2', '15565656665', '2022-03-26', '1', '11', '1', '0', '0', '666', '', '[]', '[{\"id\":1000,\"inuse\":true},{\"id\":2000,\"inuse\":true}]', '{}', '{}', '0');
INSERT INTO `user_info` VALUES ('20', '6', 'qweqwe', '1', '', '2022-03-26', '1', '11', '1', '0', '0', '666', '', '[]', '[]', '{}', '{}', '0');
INSERT INTO `user_info` VALUES ('21', '12', '大佬啊', '1', '', '2022-03-28', 'USA', 'ND', 'BIS', '0', '0', '666', '', '[]', '[{\"id\":1000,\"inuse\":true},{\"id\":2000,\"inuse\":true}]', '{}', '{}', '1649808728492');
INSERT INTO `user_info` VALUES ('22', '0', 'Player', '1', '', '', '', '', '', '0', '0', '666', '', '[]', '[]', '{}', '{}', '0');
INSERT INTO `user_info` VALUES ('23', '11', 'BB', '1', '', '2000-01-01', '1', '11', '1', '0', '0', '666', '', '[]', '[{\"id\":1000,\"inuse\":true},{\"id\":2000,\"inuse\":true}]', '{}', '{}', '0');
INSERT INTO `user_info` VALUES ('24', '0', '123qwe', '1', '', '2000-01-01', '1', '11', '1', '0', '0', '666', '', '[]', '[]', '{}', '{}', '0');
INSERT INTO `user_info` VALUES ('26', '0', '212', '1', '', '2000-01-01', '1', '11', '1', '0', '0', '666', '', '[]', '[]', '{}', '{}', '0');

-- ----------------------------
-- Table structure for user_login
-- ----------------------------
DROP TABLE IF EXISTS `user_login`;
CREATE TABLE `user_login` (
  `id` int NOT NULL AUTO_INCREMENT,
  `username` varchar(32) NOT NULL,
  `password` varchar(32) NOT NULL,
  `token` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
  `token_timeout` bigint NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `username` (`username`) USING BTREE,
  UNIQUE KEY `id` (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of user_login
-- ----------------------------
INSERT INTO `user_login` VALUES ('10', '222333', '123456', '185fa8f92dfe4a55bf35e7ff604c519b', '2048819988546');
INSERT INTO `user_login` VALUES ('12', 'lvjincheng', '19980301', 'd31906b82708436d98af4fdc4fb0517a', '1660359438306');
INSERT INTO `user_login` VALUES ('13', '111qqq', 'qqqqqq', '', '0');
INSERT INTO `user_login` VALUES ('14', '111qqq2', '123456', '81ffead7e8864a548ae7c56acc62f8da', '1548835426909');
INSERT INTO `user_login` VALUES ('15', '312312312', '123456', '', '0');
INSERT INTO `user_login` VALUES ('16', 'xxxqqq', '123123', '097773145d924792ae1248c7860b5098', '1648908071812');
INSERT INTO `user_login` VALUES ('17', 'qqqxxx2', '123123', '', '0');
INSERT INTO `user_login` VALUES ('18', 'qqqxxx', 'qqqxxx', '', '0');
INSERT INTO `user_login` VALUES ('19', 'xxxaaa', '123123', '309f2e10e3a74b2c80d4bea786d69b8c', '1648908357100');
INSERT INTO `user_login` VALUES ('20', 'lvjincheng123', 'aaaaaa', 'dd4416a2d48a4b93b34d241bebaf3a89', '1648912599116');
INSERT INTO `user_login` VALUES ('21', 'tester', '123456', 'e2fd578c6aaa427ca8f6be6d47b08521', '1651143320877');
INSERT INTO `user_login` VALUES ('22', 'woshishabi', '123456', 'd2311e42c34f41c7a63e419cd68d89a8', '1649089511694');
INSERT INTO `user_login` VALUES ('23', '17875300045', '123456', '92347719a77b4a109a8db1af27bef476', '1650113741900');
INSERT INTO `user_login` VALUES ('24', 'hahaha', '123456', 'dfe11ed191e24cc792f6772fd1757a15', '1650138237454');