database.sql 24 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383
  1. -- MariaDB dump 10.17 Distrib 10.4.12-MariaDB, for Linux (x86_64)
  2. --
  3. -- Host: 127.0.0.1 Database: three_games
  4. -- ------------------------------------------------------
  5. -- Server version 10.4.12-MariaDB
  6. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  7. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  8. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  9. /*!40101 SET NAMES utf8mb4 */;
  10. /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
  11. /*!40103 SET TIME_ZONE='+00:00' */;
  12. /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
  13. /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
  14. /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
  15. /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
  16. --
  17. -- Table structure for table `game_answer`
  18. --
  19. DROP TABLE IF EXISTS `game_answer`;
  20. /*!40101 SET @saved_cs_client = @@character_set_client */;
  21. /*!40101 SET character_set_client = utf8 */;
  22. CREATE TABLE `game_answer` (
  23. `id` bigint(20) NOT NULL AUTO_INCREMENT,
  24. `game_log_id` bigint(20) NOT NULL,
  25. `answer` int(11) DEFAULT NULL,
  26. `correct` int(11) DEFAULT NULL,
  27. `reaction` decimal(10,2) DEFAULT NULL,
  28. `show_num` int(11) DEFAULT NULL,
  29. PRIMARY KEY (`id`)
  30. ) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COMMENT='用户回答的答案';
  31. /*!40101 SET character_set_client = @saved_cs_client */;
  32. --
  33. -- Dumping data for table `game_answer`
  34. --
  35. LOCK TABLES `game_answer` WRITE;
  36. /*!40000 ALTER TABLE `game_answer` DISABLE KEYS */;
  37. 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);
  38. /*!40000 ALTER TABLE `game_answer` ENABLE KEYS */;
  39. UNLOCK TABLES;
  40. --
  41. -- Table structure for table `game_config`
  42. --
  43. DROP TABLE IF EXISTS `game_config`;
  44. /*!40101 SET @saved_cs_client = @@character_set_client */;
  45. /*!40101 SET character_set_client = utf8 */;
  46. CREATE TABLE `game_config` (
  47. `id` bigint(20) NOT NULL AUTO_INCREMENT,
  48. `start_time` varchar(10) DEFAULT NULL,
  49. `end_time` varchar(10) DEFAULT NULL,
  50. `uid` bigint(20) DEFAULT NULL,
  51. `message_id` varchar(100) DEFAULT NULL,
  52. PRIMARY KEY (`id`)
  53. ) ENGINE=InnoDB AUTO_INCREMENT=66 DEFAULT CHARSET=utf8mb4;
  54. /*!40101 SET character_set_client = @saved_cs_client */;
  55. --
  56. -- Dumping data for table `game_config`
  57. --
  58. LOCK TABLES `game_config` WRITE;
  59. /*!40000 ALTER TABLE `game_config` DISABLE KEYS */;
  60. 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);
  61. /*!40000 ALTER TABLE `game_config` ENABLE KEYS */;
  62. UNLOCK TABLES;
  63. --
  64. -- Table structure for table `game_log`
  65. --
  66. DROP TABLE IF EXISTS `game_log`;
  67. /*!40101 SET @saved_cs_client = @@character_set_client */;
  68. /*!40101 SET character_set_client = utf8 */;
  69. CREATE TABLE `game_log` (
  70. `id` bigint(20) NOT NULL AUTO_INCREMENT,
  71. `user_id` bigint(20) NOT NULL,
  72. `real_correct_rate` decimal(5,2) DEFAULT NULL,
  73. `correct_rate` decimal(5,2) DEFAULT NULL,
  74. `confidence` decimal(5,2) DEFAULT NULL,
  75. `start_time` datetime DEFAULT NULL,
  76. `end_time` datetime DEFAULT NULL,
  77. `version` varchar(20) DEFAULT NULL,
  78. `sign` varchar(20) DEFAULT NULL,
  79. `schedule` decimal(5,2) DEFAULT NULL,
  80. `selected` varchar(20) DEFAULT NULL,
  81. `exercise` int(11) DEFAULT NULL,
  82. PRIMARY KEY (`id`)
  83. ) ENGINE=InnoDB AUTO_INCREMENT=21 DEFAULT CHARSET=utf8mb4 COMMENT='游戏记录';
  84. /*!40101 SET character_set_client = @saved_cs_client */;
  85. --
  86. -- Dumping data for table `game_log`
  87. --
  88. LOCK TABLES `game_log` WRITE;
  89. /*!40000 ALTER TABLE `game_log` DISABLE KEYS */;
  90. 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);
  91. /*!40000 ALTER TABLE `game_log` ENABLE KEYS */;
  92. UNLOCK TABLES;
  93. --
  94. -- Table structure for table `push_log`
  95. --
  96. DROP TABLE IF EXISTS `push_log`;
  97. /*!40101 SET @saved_cs_client = @@character_set_client */;
  98. /*!40101 SET character_set_client = utf8 */;
  99. CREATE TABLE `push_log` (
  100. `id` bigint(20) NOT NULL AUTO_INCREMENT,
  101. `msg_id` varchar(100) DEFAULT NULL,
  102. `push_time` datetime DEFAULT NULL,
  103. `uid` bigint(20) DEFAULT NULL,
  104. `alias` varchar(1000) DEFAULT NULL,
  105. `type` int(11) DEFAULT NULL,
  106. `status` int(11) DEFAULT NULL,
  107. `device_id` varchar(200) DEFAULT NULL,
  108. PRIMARY KEY (`id`)
  109. ) ENGINE=InnoDB AUTO_INCREMENT=56 DEFAULT CHARSET=utf8mb4 COMMENT='推送日志';
  110. /*!40101 SET character_set_client = @saved_cs_client */;
  111. --
  112. -- Dumping data for table `push_log`
  113. --
  114. LOCK TABLES `push_log` WRITE;
  115. /*!40000 ALTER TABLE `push_log` DISABLE KEYS */;
  116. 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);
  117. /*!40000 ALTER TABLE `push_log` ENABLE KEYS */;
  118. UNLOCK TABLES;
  119. --
  120. -- Table structure for table `scale_log`
  121. --
  122. DROP TABLE IF EXISTS `scale_log`;
  123. /*!40101 SET @saved_cs_client = @@character_set_client */;
  124. /*!40101 SET character_set_client = utf8 */;
  125. CREATE TABLE `scale_log` (
  126. `id` bigint(20) NOT NULL AUTO_INCREMENT,
  127. `user_id` bigint(20) NOT NULL,
  128. `get_up` varchar(20) DEFAULT NULL,
  129. `contact` varchar(20) DEFAULT NULL,
  130. `work` varchar(20) DEFAULT NULL,
  131. `dinner` varchar(20) DEFAULT NULL,
  132. `sleep` varchar(20) DEFAULT NULL,
  133. `create_date` datetime DEFAULT NULL,
  134. `event_date` datetime DEFAULT NULL,
  135. `sign` varchar(20) DEFAULT NULL,
  136. `schedule` decimal(5,2) DEFAULT NULL,
  137. `start_date` datetime DEFAULT NULL,
  138. `device_id` varchar(200) DEFAULT NULL,
  139. PRIMARY KEY (`id`)
  140. ) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8mb4 COMMENT='量表记录';
  141. /*!40101 SET character_set_client = @saved_cs_client */;
  142. --
  143. -- Dumping data for table `scale_log`
  144. --
  145. LOCK TABLES `scale_log` WRITE;
  146. /*!40000 ALTER TABLE `scale_log` DISABLE KEYS */;
  147. 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);
  148. /*!40000 ALTER TABLE `scale_log` ENABLE KEYS */;
  149. UNLOCK TABLES;
  150. --
  151. -- Table structure for table `sys_power`
  152. --
  153. DROP TABLE IF EXISTS `sys_power`;
  154. /*!40101 SET @saved_cs_client = @@character_set_client */;
  155. /*!40101 SET character_set_client = utf8 */;
  156. CREATE TABLE `sys_power` (
  157. `id` mediumint(8) NOT NULL AUTO_INCREMENT,
  158. `name` varchar(255) NOT NULL,
  159. `url` varchar(255) NOT NULL,
  160. `pid` mediumint(8) DEFAULT NULL,
  161. PRIMARY KEY (`id`),
  162. UNIQUE KEY `power_name_url_pk` (`name`,`url`)
  163. ) ENGINE=InnoDB AUTO_INCREMENT=99 DEFAULT CHARSET=utf8mb4;
  164. /*!40101 SET character_set_client = @saved_cs_client */;
  165. --
  166. -- Dumping data for table `sys_power`
  167. --
  168. LOCK TABLES `sys_power` WRITE;
  169. /*!40000 ALTER TABLE `sys_power` DISABLE KEYS */;
  170. 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);
  171. /*!40000 ALTER TABLE `sys_power` ENABLE KEYS */;
  172. UNLOCK TABLES;
  173. --
  174. -- Table structure for table `sys_role`
  175. --
  176. DROP TABLE IF EXISTS `sys_role`;
  177. /*!40101 SET @saved_cs_client = @@character_set_client */;
  178. /*!40101 SET character_set_client = utf8 */;
  179. CREATE TABLE `sys_role` (
  180. `id` mediumint(8) NOT NULL AUTO_INCREMENT,
  181. `name` varchar(255) NOT NULL,
  182. `description` varchar(100) DEFAULT NULL,
  183. PRIMARY KEY (`id`),
  184. UNIQUE KEY `role_name_uindex` (`name`)
  185. ) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COMMENT='角色表';
  186. /*!40101 SET character_set_client = @saved_cs_client */;
  187. --
  188. -- Dumping data for table `sys_role`
  189. --
  190. LOCK TABLES `sys_role` WRITE;
  191. /*!40000 ALTER TABLE `sys_role` DISABLE KEYS */;
  192. INSERT INTO `sys_role` VALUES (1,'管理员','admin'),(2,'普通用户','user');
  193. /*!40000 ALTER TABLE `sys_role` ENABLE KEYS */;
  194. UNLOCK TABLES;
  195. --
  196. -- Table structure for table `sys_role_power`
  197. --
  198. DROP TABLE IF EXISTS `sys_role_power`;
  199. /*!40101 SET @saved_cs_client = @@character_set_client */;
  200. /*!40101 SET character_set_client = utf8 */;
  201. CREATE TABLE `sys_role_power` (
  202. `role_id` mediumint(8) NOT NULL,
  203. `power_id` mediumint(8) NOT NULL,
  204. PRIMARY KEY (`role_id`,`power_id`),
  205. KEY `role_power_power_id_fk` (`power_id`),
  206. CONSTRAINT `role_power_power_id_fk` FOREIGN KEY (`power_id`) REFERENCES `sys_power` (`id`),
  207. CONSTRAINT `role_power_role_id_fk` FOREIGN KEY (`role_id`) REFERENCES `sys_role` (`id`)
  208. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  209. /*!40101 SET character_set_client = @saved_cs_client */;
  210. --
  211. -- Dumping data for table `sys_role_power`
  212. --
  213. LOCK TABLES `sys_role_power` WRITE;
  214. /*!40000 ALTER TABLE `sys_role_power` DISABLE KEYS */;
  215. 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);
  216. /*!40000 ALTER TABLE `sys_role_power` ENABLE KEYS */;
  217. UNLOCK TABLES;
  218. --
  219. -- Table structure for table `sys_user`
  220. --
  221. DROP TABLE IF EXISTS `sys_user`;
  222. /*!40101 SET @saved_cs_client = @@character_set_client */;
  223. /*!40101 SET character_set_client = utf8 */;
  224. CREATE TABLE `sys_user` (
  225. `id` bigint(20) NOT NULL AUTO_INCREMENT,
  226. `username` varchar(255) DEFAULT NULL,
  227. `password` varchar(255) NOT NULL,
  228. `mobile_number` varchar(15) DEFAULT NULL COMMENT '手机',
  229. `gender` tinyint(4) NOT NULL DEFAULT 0 COMMENT '性别',
  230. `alias` varchar(50) DEFAULT NULL COMMENT '邮箱',
  231. `latest_login_time` timestamp NULL DEFAULT NULL COMMENT '最后登录的时间',
  232. `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  233. `nickname` varchar(100) DEFAULT NULL COMMENT '创建时间',
  234. `avatar` varchar(300) DEFAULT NULL COMMENT '创建时间',
  235. `enable` tinyint(4) NOT NULL DEFAULT 0,
  236. `type` tinyint(2) DEFAULT 2,
  237. `openid` varchar(200) DEFAULT NULL,
  238. `status` tinyint(4) DEFAULT 0,
  239. PRIMARY KEY (`id`),
  240. UNIQUE KEY `user_openId_uindex` (`openid`),
  241. UNIQUE KEY `sys_user_username_uindex` (`username`)
  242. ) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8mb4 COMMENT='用户表';
  243. /*!40101 SET character_set_client = @saved_cs_client */;
  244. --
  245. -- Dumping data for table `sys_user`
  246. --
  247. LOCK TABLES `sys_user` WRITE;
  248. /*!40000 ALTER TABLE `sys_user` DISABLE KEYS */;
  249. 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);
  250. /*!40000 ALTER TABLE `sys_user` ENABLE KEYS */;
  251. UNLOCK TABLES;
  252. --
  253. -- Table structure for table `sys_user_role`
  254. --
  255. DROP TABLE IF EXISTS `sys_user_role`;
  256. /*!40101 SET @saved_cs_client = @@character_set_client */;
  257. /*!40101 SET character_set_client = utf8 */;
  258. CREATE TABLE `sys_user_role` (
  259. `role_id` bigint(20) NOT NULL,
  260. `user_id` bigint(20) NOT NULL,
  261. PRIMARY KEY (`role_id`,`user_id`),
  262. KEY `user_role_user_id_fk` (`user_id`)
  263. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  264. /*!40101 SET character_set_client = @saved_cs_client */;
  265. --
  266. -- Dumping data for table `sys_user_role`
  267. --
  268. LOCK TABLES `sys_user_role` WRITE;
  269. /*!40000 ALTER TABLE `sys_user_role` DISABLE KEYS */;
  270. INSERT INTO `sys_user_role` VALUES (1,1),(2,23),(2,24),(2,25),(2,26);
  271. /*!40000 ALTER TABLE `sys_user_role` ENABLE KEYS */;
  272. UNLOCK TABLES;
  273. --
  274. -- Table structure for table `sys_whitelist`
  275. --
  276. DROP TABLE IF EXISTS `sys_whitelist`;
  277. /*!40101 SET @saved_cs_client = @@character_set_client */;
  278. /*!40101 SET character_set_client = utf8 */;
  279. CREATE TABLE `sys_whitelist` (
  280. `url` varchar(100) NOT NULL,
  281. PRIMARY KEY (`url`)
  282. ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
  283. /*!40101 SET character_set_client = @saved_cs_client */;
  284. --
  285. -- Dumping data for table `sys_whitelist`
  286. --
  287. LOCK TABLES `sys_whitelist` WRITE;
  288. /*!40000 ALTER TABLE `sys_whitelist` DISABLE KEYS */;
  289. INSERT INTO `sys_whitelist` VALUES ('/favicon.ico'),('/game/log/download'),('/generator/code'),('/generator/code/submit');
  290. /*!40000 ALTER TABLE `sys_whitelist` ENABLE KEYS */;
  291. UNLOCK TABLES;
  292. --
  293. -- Table structure for table `user_config`
  294. --
  295. DROP TABLE IF EXISTS `user_config`;
  296. /*!40101 SET @saved_cs_client = @@character_set_client */;
  297. /*!40101 SET character_set_client = utf8 */;
  298. CREATE TABLE `user_config` (
  299. `id` bigint(20) NOT NULL AUTO_INCREMENT,
  300. `user_id` bigint(20) NOT NULL,
  301. `scale_end` varchar(20) DEFAULT NULL,
  302. `scale_start` varchar(20) DEFAULT NULL,
  303. `scale_time` varchar(15) DEFAULT NULL,
  304. `show_time` int(11) DEFAULT NULL,
  305. `hide_time` int(11) DEFAULT NULL,
  306. `correct` int(11) DEFAULT NULL,
  307. `supporting` int(11) DEFAULT NULL,
  308. `practice` int(11) DEFAULT NULL,
  309. `game_count` int(11) DEFAULT NULL,
  310. `version` varchar(10) DEFAULT NULL,
  311. `exercise` int(11) DEFAULT NULL,
  312. `login_out` int(11) DEFAULT 0,
  313. PRIMARY KEY (`id`)
  314. ) ENGINE=InnoDB AUTO_INCREMENT=23 DEFAULT CHARSET=utf8mb4 COMMENT='用户配置';
  315. /*!40101 SET character_set_client = @saved_cs_client */;
  316. --
  317. -- Dumping data for table `user_config`
  318. --
  319. LOCK TABLES `user_config` WRITE;
  320. /*!40000 ALTER TABLE `user_config` DISABLE KEYS */;
  321. 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);
  322. /*!40000 ALTER TABLE `user_config` ENABLE KEYS */;
  323. UNLOCK TABLES;
  324. /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
  325. /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
  326. /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
  327. /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
  328. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  329. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  330. /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
  331. /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
  332. -- Dump completed on 2020-03-28 12:00:02