-- MariaDB dump 10.17  Distrib 10.4.12-MariaDB, for Linux (x86_64)
--
-- Host: 127.0.0.1    Database: three_games
-- ------------------------------------------------------
-- Server version	10.4.12-MariaDB

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `game_answer`
--

DROP TABLE IF EXISTS `game_answer`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `game_answer` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `game_log_id` bigint(20) NOT NULL,
  `answer` int(11) DEFAULT NULL,
  `correct` int(11) DEFAULT NULL,
  `reaction` decimal(10,2) DEFAULT NULL,
  `show_num` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COMMENT='用户回答的答案';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `game_answer`
--

LOCK TABLES `game_answer` WRITE;
/*!40000 ALTER TABLE `game_answer` DISABLE KEYS */;
INSERT INTO `game_answer` VALUES (9,16,1,1,1000.00,1),(10,16,2,1,1000.00,1),(11,16,2,1,1000.00,1),(12,16,2,1,1000.00,1),(13,16,3,1,1000.00,1),(14,17,3,1,1000.00,1),(15,17,3,1,1000.00,1),(16,17,3,1,1000.00,1),(17,17,3,1,1000.00,1);
/*!40000 ALTER TABLE `game_answer` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `game_config`
--

DROP TABLE IF EXISTS `game_config`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `game_config` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `start_time` varchar(10) DEFAULT NULL,
  `end_time` varchar(10) DEFAULT NULL,
  `uid` bigint(20) DEFAULT NULL,
  `message_id` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=66 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `game_config`
--

LOCK TABLES `game_config` WRITE;
/*!40000 ALTER TABLE `game_config` DISABLE KEYS */;
INSERT INTO `game_config` VALUES (57,'10:22:47','10:22:47',23,NULL),(58,'10:46:30','10:46:30',24,NULL),(60,'11:07:35','11:07:35',25,NULL),(63,'01:00','01:30',26,NULL),(64,'02:00','02:15',26,NULL),(65,'02:30','02:45',26,NULL);
/*!40000 ALTER TABLE `game_config` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `game_log`
--

DROP TABLE IF EXISTS `game_log`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `game_log` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) NOT NULL,
  `real_correct_rate` decimal(5,2) DEFAULT NULL,
  `correct_rate` decimal(5,2) DEFAULT NULL,
  `confidence` decimal(5,2) DEFAULT NULL,
  `start_time` datetime DEFAULT NULL,
  `end_time` datetime DEFAULT NULL,
  `version` varchar(20) DEFAULT NULL,
  `sign` varchar(20) DEFAULT NULL,
  `schedule` decimal(5,2) DEFAULT NULL,
  `selected` varchar(20) DEFAULT NULL,
  `exercise` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COMMENT='游戏记录';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `game_log`
--

LOCK TABLES `game_log` WRITE;
/*!40000 ALTER TABLE `game_log` DISABLE KEYS */;
INSERT INTO `game_log` VALUES (16,15,0.50,0.50,0.50,'2020-02-27 18:15:52','2020-02-27 18:15:54','A','1-1',1.00,NULL,NULL),(17,15,0.50,0.50,0.50,'2020-02-27 18:15:52','2020-02-27 18:15:54','B','1-2',1.00,NULL,NULL),(18,15,0.50,0.50,0.50,'2020-02-27 18:15:52','2020-02-27 18:15:54','C','1-3',1.00,NULL,NULL),(19,15,0.50,0.50,0.50,'2020-03-01 18:15:52','2020-03-01 18:15:54','A','1-4',1.00,NULL,NULL),(20,16,0.50,0.50,0.50,'2020-03-07 18:15:52','2020-03-07 18:15:54','A','1-1',1.00,NULL,NULL);
/*!40000 ALTER TABLE `game_log` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `push_log`
--

DROP TABLE IF EXISTS `push_log`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `push_log` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `msg_id` varchar(100) DEFAULT NULL,
  `push_time` datetime DEFAULT NULL,
  `uid` bigint(20) DEFAULT NULL,
  `alias` varchar(1000) DEFAULT NULL,
  `type` int(11) DEFAULT NULL,
  `status` int(11) DEFAULT NULL,
  `device_id` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=56 DEFAULT CHARSET=utf8mb4 COMMENT='推送日志';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `push_log`
--

LOCK TABLES `push_log` WRITE;
/*!40000 ALTER TABLE `push_log` DISABLE KEYS */;
INSERT INTO `push_log` VALUES (6,'2251853742437376','2020-03-07 21:59:06',16,'7921317744921468928',2,0,NULL),(7,'67554043244441160','2020-03-07 22:05:24',16,'7921317744921468928',2,0,NULL),(8,'9007246584495761','2020-03-07 22:07:27',16,'7921317744921468928',1,1,NULL),(9,'2251853743965461','2020-03-07 22:08:43',16,'7921317744921468928',2,0,NULL),(10,'2251853744338495','2020-03-07 22:11:03',16,'7921317744921468928',2,0,NULL),(11,'20266252326753120','2020-03-07 22:20:57',16,'7921317744921468928',1,0,NULL),(12,'38280645668744252','2020-03-07 23:04:52',16,'7921317744921468928',2,0,NULL),(13,'38280645672439386','2020-03-07 23:42:09',16,'7921317744921468928',2,0,NULL),(14,'47287843426110418','2020-03-07 23:42:58',16,'7921317744921468928',2,0,NULL),(15,'2251853756286056','2020-03-07 23:50:41',16,'7921317744921468928',2,0,NULL),(16,'2251853757562458','2020-03-08 00:05:32',16,'7921317744921468928',2,0,NULL),(17,'58546844012990255','2020-03-08 00:06:23',16,'7921317744921468928',2,0,NULL),(18,'20266252338894799','2020-03-08 00:09:59',16,'7921317744921468928',2,0,NULL),(19,'29273451521059668','2020-03-08 00:12:03',16,'7921317744921468928',2,0,NULL),(20,'38280645674989758','2020-03-08 00:13:02',16,'7921317744921468928',2,0,NULL),(21,'2251853758861657','2020-03-08 00:21:02',16,'7921317744921468928',2,0,NULL),(22,'38280645676843970','2020-03-08 00:37:32',16,'7921317744921468928',2,0,NULL),(23,'47287843430569229','2020-03-08 00:38:19',16,'7921317744921468928',2,0,NULL),(24,'47287843430786185','2020-03-08 00:41:29',16,'7921317744921468928',2,0,NULL),(25,'58546844015782459','2020-03-08 00:42:16',16,'7921317744921468928',2,0,NULL),(26,'38280645677584109','2020-03-08 00:47:54',16,'7921317744921468928',2,0,NULL),(27,'29273451524025937','2020-03-08 00:51:26',16,'7921317744921468928',2,0,NULL),(28,'54043244376419637','2020-03-08 01:03:42',16,'7921317744921468928',2,0,NULL),(29,'58546844017443678','2020-03-08 01:05:38',16,'7921317744921468928',2,0,NULL),(30,'38280645678909680','2020-03-08 01:06:27',16,'7921317744921468928',2,0,NULL),(31,'29273451525135634','2020-03-08 01:07:19',16,'7921317744921468928',2,0,NULL),(32,'67554043263227764','2020-03-08 01:08:09',16,'7921317744921468928',2,0,NULL),(33,'47287843432746301','2020-03-08 01:09:03',16,'7921317744921468928',2,0,NULL),(34,'20266252343362706','2020-03-08 01:10:45',16,'7921317744921468928',2,0,NULL),(35,'67554043263594522','2020-03-08 01:13:44',16,'7921317744921468928',2,0,NULL),(36,'38280645679448741','2020-03-08 01:14:56',16,'7921317744921468928',2,0,NULL),(37,'2251853763151471','2020-03-08 01:23:03',16,'7921317744921468928',2,0,NULL),(38,'9007246604344351','2020-03-08 01:29:45',16,'7921317744921468928',2,0,NULL),(39,'58546844019039655','2020-03-08 01:30:58',16,'7921317744921468928',2,0,NULL),(40,'54043244378501855','2020-03-08 01:37:10',16,'7921317744921468928',2,0,NULL),(41,'20266252387688317','2020-03-08 11:20:12',16,'7921317744921468928',1,0,NULL),(42,'9007246652222149','2020-03-08 11:51:05',16,'7921317744921468928',1,0,NULL),(43,'20266252395198011','2020-03-08 00:05:43',16,'7921317744921468928',1,0,NULL),(44,'20266252395788277','2020-03-08 00:08:18',16,'7921317744921468928',1,0,NULL),(45,'29273451577675517','2020-03-08 00:08:26',16,'7921317744921468928',1,1,NULL),(46,'54043244429343558','2020-03-08 00:08:53',16,'7921317744921468928',1,0,NULL),(47,'58546844070288453','2020-03-08 00:09:07',16,'7921317744921468928',2,0,NULL),(49,'29273451577675517','2020-03-08 13:45:35',16,'7921317744921468928',1,2,NULL),(50,'58546844070288453','2020-03-08 13:45:35',16,'7921317744921468928',2,2,NULL),(51,'54043244429343558','2020-03-08 13:45:35',16,'7921317744921468928',1,2,NULL),(52,'58546844070291531','2020-03-08 13:45:35',16,'7921317744921468928',2,0,NULL),(54,'2251853872958510','2020-03-08 18:35:46',16,'7921317744921468928',2,2,NULL),(55,'67554043377252468','2020-03-08 18:59:16',16,'7921317744921468928',2,2,NULL);
/*!40000 ALTER TABLE `push_log` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `scale_log`
--

DROP TABLE IF EXISTS `scale_log`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `scale_log` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) NOT NULL,
  `get_up` varchar(20) DEFAULT NULL,
  `contact` varchar(20) DEFAULT NULL,
  `work` varchar(20) DEFAULT NULL,
  `dinner` varchar(20) DEFAULT NULL,
  `sleep` varchar(20) DEFAULT NULL,
  `create_date` datetime DEFAULT NULL,
  `event_date` datetime DEFAULT NULL,
  `sign` varchar(20) DEFAULT NULL,
  `schedule` decimal(5,2) DEFAULT NULL,
  `start_date` datetime DEFAULT NULL,
  `device_id` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8mb4 COMMENT='量表记录';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `scale_log`
--

LOCK TABLES `scale_log` WRITE;
/*!40000 ALTER TABLE `scale_log` DISABLE KEYS */;
INSERT INTO `scale_log` VALUES (16,16,'无','无','无','无','无','2020-03-07 22:02:48','2020-03-07 22:02:48','9',0.00,NULL,NULL),(24,15,'01:43:00','03:43:00','03:43:00','06:43:00','10:43:00',NULL,NULL,NULL,0.00,NULL,NULL),(25,15,'无','无','无','无','无','2020-03-07 23:55:00','2020-03-07 23:55:00','6',0.00,NULL,NULL),(26,17,'无','无','无','无','无','2020-03-07 23:55:00','2020-03-07 23:55:00','-1',0.00,NULL,NULL),(27,18,'无','无','无','无','无','2020-03-07 23:55:00','2020-03-07 23:55:00','-36',0.00,NULL,NULL),(28,20,'无','无','无','无','无','2020-03-07 23:55:00','2020-03-07 23:55:00','-4',0.00,NULL,NULL),(29,21,'无','无','无','无','无','2020-03-07 23:55:00','2020-03-07 23:55:00','3',0.00,NULL,NULL),(30,16,'13:46:00','13:46:00','13:46:00','13:46:00','13:46:00','2020-03-08 13:46:43',NULL,'-8',NULL,NULL,NULL);
/*!40000 ALTER TABLE `scale_log` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_power`
--

DROP TABLE IF EXISTS `sys_power`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sys_power` (
  `id` mediumint(8) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `url` varchar(255) NOT NULL,
  `pid` mediumint(8) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `power_name_url_pk` (`name`,`url`)
) ENGINE=InnoDB AUTO_INCREMENT=99 DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_power`
--

LOCK TABLES `sys_power` WRITE;
/*!40000 ALTER TABLE `sys_power` DISABLE KEYS */;
INSERT INTO `sys_power` VALUES (1,'权限管理','/power',0),(2,'权限树列表','/power/list',1),(3,'角色管理','/role',0),(4,'添加角色','/role/add',3),(5,'角色列表','/role/list',3),(6,'角色添加权限','/role/add/power',3),(7,'获取角色权限','/role/get/power',3),(8,'白名单','/sys/whitelist',0),(9,'白名单添加','/sys/whitelist/add',8),(10,'白名单修改','/sys/whitelist/update',8),(11,'白名单删除','/sys/whitelist/delete',8),(12,'白名单列表信息','/sys/whitelist/list',8),(13,'文件上传','upload',0),(14,'图片上传','/img/upload',13),(15,'/apk/upload','/apk/upload',13),(16,'富文本上传','/upload',13),(17,'账号管理','/user',0),(18,'注册','/user/registered',17),(19,'获取登录用户信息','/user/get',17),(20,'用户列表','/user/list',17),(21,'获取用户角色','/user/get/role',17),(22,'修改密密','/user/update/password',17),(23,'用户添加角色','/user/add/role',17),(24,'绑定微信','/user/wx/bind',17),(25,'根据open刷新token','/user/refresh/token',17),(26,'获取openId','/user/get/openid',17),(27,'生成代码','/generator',0),(28,'/generator/code/submit','/generator/code/submit',27),(29,'/generator/code','/generator/code',27),(30,'app发布','/app',0),(31,'app发布详细信息','/app/detail',30),(32,'app发布详细信息','/app/index',30),(33,'app发布添加','/app/add',30),(34,'app发布修改','/app/update',30),(35,'app发布删除','/app/delete',30),(36,'app发布列表信息','/app/list',30),(37,'app发布历史','/app/history',0),(38,'app发布历史详细信息','/app/history/detail',37),(39,'app发布历史添加','/app/history/add',37),(40,'app发布历史修改','/app/history/update',37),(41,'app发布历史删除','/app/history/delete',37),(42,'app发布历史列表信息','/app/history/list',37),(43,'app发布历史列表信息','/app/history/last',37),(44,'/swagger-resources/configuration/ui','/swagger-resources/configuration/ui',-1),(45,'/swagger-resources','/swagger-resources',-1),(46,'/swagger-resources/configuration/security','/swagger-resources/configuration/security',-1),(47,'/error','/error',-1),(48,'/push/single','/push/single',-1),(49,'/push/daily','/push/daily',-1),(50,'/push/send','/push/send',-1),(51,'游戏答案','/game/answer',0),(52,'游戏答案详细信息','/game/answer/detail',51),(53,'游戏答案添加','/game/answer/add',51),(54,'游戏答案修改','/game/answer/update',51),(55,'游戏答案删除','/game/answer/delete',51),(56,'游戏答案列表信息','/game/answer/list',51),(57,'游戏测试记录','/game/log',0),(58,'游戏测试记录详细信息','/game/log/detail',57),(59,'游戏测试记录添加','/game/log/add',57),(60,'游戏测试记录修改','/game/log/update',57),(61,'游戏测试记录删除','/game/log/delete',57),(62,'用户配置列表信息','/game/log/list',57),(63,'量表','/scale/log',0),(64,'量表详细信息','/scale/log/detail',63),(65,'量表添加','/scale/log/add',63),(66,'量表修改','/scale/log/update',63),(67,'量表删除','/scale/log/delete',63),(68,'用户配置列表信息','/scale/log/list',63),(69,'用户配置','/user/config',0),(70,'用户配置详细信息','/user/config/detail',69),(71,'用户配置添加','/user/config/add',69),(72,'用户配置修改','/user/config/update',69),(73,'用户配置删除','/user/config/delete',69),(74,'用户配置列表信息','/user/config/list',69),(75,'添加用户','/user/config/save',69),(76,'綁定設備','/user/config/bind',69),(77,'用户配置列表信息','/scale/log/notperformed',63),(78,'用户配置列表信息','/game/log/notPerformed',57),(79,'/game/log/download','/game/log/download',57),(80,'/user/config/download','/user/config/download',69),(81,'/scale/log/download','/scale/log/download',63),(82,'游戏测试记录删除','/game/log/delete/ids',57),(83,'游戏测试记录删除','/scale/log/delete/ids',63),(84,'推送日志','/push/log',0),(85,'推送日志添加','/push/log/add',84),(86,'推送日志删除','/push/log/delete',84),(87,'推送日志列表信息','/push/log/list',84),(88,'推送日志批量删除','/push/log/delete/ids',84),(89,'/push/log/download','/push/log/download',84),(90,'遊戲時間段','/game/config',0),(91,'遊戲時間段列表','/game/config/list/uid',90),(92,'获取已经执行的游戏版本','/user/config/version',69),(93,'推送日志添加','/push/log/jg/list',84),(94,'延迟','/user/config/delay',69),(95,'推送游戏','/push/log/game',84),(96,'推送量表','/push/log/scale',84),(97,'量表未填日期','/scale/log/date',63),(98,'用户配置信息','/user/config/get',69);
/*!40000 ALTER TABLE `sys_power` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_role`
--

DROP TABLE IF EXISTS `sys_role`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sys_role` (
  `id` mediumint(8) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `description` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `role_name_uindex` (`name`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COMMENT='角色表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_role`
--

LOCK TABLES `sys_role` WRITE;
/*!40000 ALTER TABLE `sys_role` DISABLE KEYS */;
INSERT INTO `sys_role` VALUES (1,'管理员','admin'),(2,'普通用户','user');
/*!40000 ALTER TABLE `sys_role` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_role_power`
--

DROP TABLE IF EXISTS `sys_role_power`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sys_role_power` (
  `role_id` mediumint(8) NOT NULL,
  `power_id` mediumint(8) NOT NULL,
  PRIMARY KEY (`role_id`,`power_id`),
  KEY `role_power_power_id_fk` (`power_id`),
  CONSTRAINT `role_power_power_id_fk` FOREIGN KEY (`power_id`) REFERENCES `sys_power` (`id`),
  CONSTRAINT `role_power_role_id_fk` FOREIGN KEY (`role_id`) REFERENCES `sys_role` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_role_power`
--

LOCK TABLES `sys_role_power` WRITE;
/*!40000 ALTER TABLE `sys_role_power` DISABLE KEYS */;
INSERT INTO `sys_role_power` VALUES (2,1),(2,2),(2,3),(2,4),(2,5),(2,6),(2,7),(2,8),(2,9),(2,10),(2,11),(2,12),(2,13),(2,14),(2,15),(2,16),(2,17),(2,18),(2,19),(2,20),(2,21),(2,22),(2,23),(2,24),(2,25),(2,26),(2,27),(2,28),(2,29),(2,30),(2,31),(2,32),(2,33),(2,34),(2,35),(2,36),(2,37),(2,38),(2,39),(2,40),(2,41),(2,42),(2,43),(2,51),(2,52),(2,53),(2,54),(2,55),(2,56),(2,57),(2,58),(2,59),(2,60),(2,61),(2,62),(2,63),(2,64),(2,65),(2,66),(2,67),(2,68),(2,69),(2,70),(2,71),(2,72),(2,73),(2,74),(2,75),(2,76),(2,77),(2,78),(2,79),(2,80),(2,81),(2,82),(2,83),(2,84),(2,85),(2,86),(2,87),(2,88),(2,89),(2,90),(2,91),(2,92),(2,93),(2,94),(2,95),(2,96),(2,97);
/*!40000 ALTER TABLE `sys_role_power` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_user`
--

DROP TABLE IF EXISTS `sys_user`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sys_user` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `username` varchar(255) DEFAULT NULL,
  `password` varchar(255) NOT NULL,
  `mobile_number` varchar(15) DEFAULT NULL COMMENT '手机',
  `gender` tinyint(4) NOT NULL DEFAULT 0 COMMENT '性别',
  `alias` varchar(50) DEFAULT NULL COMMENT '邮箱',
  `latest_login_time` timestamp NULL DEFAULT NULL COMMENT '最后登录的时间',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `nickname` varchar(100) DEFAULT NULL COMMENT '创建时间',
  `avatar` varchar(300) DEFAULT NULL COMMENT '创建时间',
  `enable` tinyint(4) NOT NULL DEFAULT 0,
  `type` tinyint(2) DEFAULT 2,
  `openid` varchar(200) DEFAULT NULL,
  `status` tinyint(4) DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `user_openId_uindex` (`openid`),
  UNIQUE KEY `sys_user_username_uindex` (`username`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8mb4 COMMENT='用户表';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_user`
--

LOCK TABLES `sys_user` WRITE;
/*!40000 ALTER TABLE `sys_user` DISABLE KEYS */;
INSERT INTO `sys_user` VALUES (1,'admin','$2a$10$fu58s4EEEz7KmuRKv2RsBOtFCpfArFtgFy9VjpXrPLeDoAsbyeQHm','18235404640',1,'wanghuiwen312@sina.com',NULL,'2020-02-22 15:49:12','王会文',NULL,0,2,NULL,1),(23,'xx','$2a$10$XwMJfAeTQkoU.lB/GWvANeUzimFYvVHM3svkggrz6M76PLX27tU4.',NULL,1,'7932066276908130304',NULL,'2020-03-28 10:23:04','xx',NULL,1,1,NULL,0),(24,'xxx','$2a$10$2A0XKmttYMgpyzrmZLniGuU5in9Ii.bBm5XVTuxyHza6TyR6VG/ZW',NULL,1,'7932072181527011328',NULL,'2020-03-28 10:46:32','xxx',NULL,0,1,NULL,0),(25,'cc','$2a$10$ZHK5g9tm/54N.9crBBBS8uRSnkgKCVIvzgw1WDI6za/JA.bBeHtem',NULL,1,'7932077488130678784',NULL,'2020-03-28 11:07:37','cc',NULL,0,1,NULL,0),(26,'vv','$2a$10$YB0kKO6626zV.Gek9Ug1h.zXVR.W9dsB96n9.ox0r0YOXeffcgvo2',NULL,1,'7932084136899436544',NULL,'2020-03-28 11:34:02','vv',NULL,0,1,NULL,0);
/*!40000 ALTER TABLE `sys_user` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_user_role`
--

DROP TABLE IF EXISTS `sys_user_role`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sys_user_role` (
  `role_id` bigint(20) NOT NULL,
  `user_id` bigint(20) NOT NULL,
  PRIMARY KEY (`role_id`,`user_id`),
  KEY `user_role_user_id_fk` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_user_role`
--

LOCK TABLES `sys_user_role` WRITE;
/*!40000 ALTER TABLE `sys_user_role` DISABLE KEYS */;
INSERT INTO `sys_user_role` VALUES (1,1),(2,23),(2,24),(2,25),(2,26);
/*!40000 ALTER TABLE `sys_user_role` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `sys_whitelist`
--

DROP TABLE IF EXISTS `sys_whitelist`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `sys_whitelist` (
  `url` varchar(100) NOT NULL,
  PRIMARY KEY (`url`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `sys_whitelist`
--

LOCK TABLES `sys_whitelist` WRITE;
/*!40000 ALTER TABLE `sys_whitelist` DISABLE KEYS */;
INSERT INTO `sys_whitelist` VALUES ('/favicon.ico'),('/game/log/download'),('/generator/code'),('/generator/code/submit');
/*!40000 ALTER TABLE `sys_whitelist` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `user_config`
--

DROP TABLE IF EXISTS `user_config`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `user_config` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT,
  `user_id` bigint(20) NOT NULL,
  `scale_end` varchar(20) DEFAULT NULL,
  `scale_start` varchar(20) DEFAULT NULL,
  `scale_time` varchar(15) DEFAULT NULL,
  `show_time` int(11) DEFAULT NULL,
  `hide_time` int(11) DEFAULT NULL,
  `correct` int(11) DEFAULT NULL,
  `supporting` int(11) DEFAULT NULL,
  `practice` int(11) DEFAULT NULL,
  `game_count` int(11) DEFAULT NULL,
  `version` varchar(10) DEFAULT NULL,
  `exercise` int(11) DEFAULT NULL,
  `login_out` int(11) DEFAULT 0,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4 COMMENT='用户配置';
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `user_config`
--

LOCK TABLES `user_config` WRITE;
/*!40000 ALTER TABLE `user_config` DISABLE KEYS */;
INSERT INTO `user_config` VALUES (19,23,'2020-03-30 00:00:00','2020-03-28 00:00:00','10:22:39',1,1,1,1,1,1,'A',1,0),(20,24,'2020-04-10 00:00:00','2020-04-07 00:00:00','10:46:21',1,1,1,1,1,1,'A,B',1,1),(21,25,'2020-05-13 00:00:00','2020-05-10 00:00:00','11:07:27',1,1,1,1,1,1,'A,B,C',1,1),(22,26,'2020-04-14 00:00:00','2020-03-28 00:00:00','11:33:52',123,123,123,123,123,3,'A,B',123,1);
/*!40000 ALTER TABLE `user_config` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2020-03-28 12:00:02
