ejxyBVpk

1-- MySQL dump 10.13  Distrib 5.7.14, for Win64 (x86_64)
2--
3-- Host: localhost    Database: node_mathscards
4-- ------------------------------------------------------
5-- Server version	5.7.14-log
6
7/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10/*!40101 SET NAMES utf8 */;
11/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12/*!40103 SET TIME_ZONE='+00:00' */;
13/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17
18--
19-- Table structure for table `activeplayer`
20--
21
22DROP DATABASE IF EXISTS `node_mathscards`;
23CREATE DATABASE `node_mathscards`;
24USE `node_mathscards`;
25
26DROP TABLE IF EXISTS `activeplayer`;
27/*!40101 SET @saved_cs_client     = @@character_set_client */;
28/*!40101 SET character_set_client = utf8 */;
29CREATE TABLE `activeplayer` (
30  `UserId` int(10) unsigned NOT NULL,
31  `RoomId` int(11) NOT NULL,
32  `LastRequest` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
33  PRIMARY KEY (`UserId`)
34) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
35/*!40101 SET character_set_client = @saved_cs_client */;
36
37--
38-- Dumping data for table `activeplayer`
39--
40
41LOCK TABLES `activeplayer` WRITE;
42/*!40000 ALTER TABLE `activeplayer` DISABLE KEYS */;
43/*!40000 ALTER TABLE `activeplayer` ENABLE KEYS */;
44UNLOCK TABLES;
45
46--
47-- Table structure for table `room`
48--
49
50DROP TABLE IF EXISTS `room`;
51/*!40101 SET @saved_cs_client     = @@character_set_client */;
52/*!40101 SET character_set_client = utf8 */;
53CREATE TABLE `room` (
54  `Id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
55  `Owner` int(11) NOT NULL,
56  `Difficulty` tinyint(4) NOT NULL,
57  `Operations` tinyint(3) unsigned NOT NULL,
58  `Handicap` tinyint(1) NOT NULL,
59  `Chat` tinyint(1) NOT NULL,
60  `MinRating` int(11) NOT NULL,
61  `ExpiresAt` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
62  PRIMARY KEY (`Id`)
63) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
64/*!40101 SET character_set_client = @saved_cs_client */;
65
66--
67-- Dumping data for table `room`
68--
69
70LOCK TABLES `room` WRITE;
71/*!40000 ALTER TABLE `room` DISABLE KEYS */;
72/*!40000 ALTER TABLE `room` ENABLE KEYS */;
73UNLOCK TABLES;
74
75--
76-- Table structure for table `user`
77--
78
79DROP TABLE IF EXISTS `user`;
80/*!40101 SET @saved_cs_client     = @@character_set_client */;
81/*!40101 SET character_set_client = utf8 */;
82CREATE TABLE `user` (
83  `UserId` int(10) unsigned NOT NULL AUTO_INCREMENT,
84  `UserEmail` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
85  `UserPassword` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
86  `UserFirstName` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
87  `UserLastName` varchar(64) COLLATE utf8_unicode_ci NOT NULL,
88  `UserTokens` int(11) NOT NULL DEFAULT '0',
89  `UserRating` int(11) DEFAULT NULL,
90  `UserHelps` int(11) NOT NULL DEFAULT '0',
91  `UserPoints` int(11) NOT NULL DEFAULT '0',
92  PRIMARY KEY (`UserId`),
93  UNIQUE KEY `UserEmail` (`UserEmail`)
94) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
95/*!40101 SET character_set_client = @saved_cs_client */;
96
97--
98-- Dumping data for table `user`
99--
100
101LOCK TABLES `user` WRITE;
102/*!40000 ALTER TABLE `user` DISABLE KEYS */;
103INSERT INTO `user` VALUES (2,'dejan@lk-net.com','$2a$10$ZGBeyl8zCmZ.DyGRSWaV/e2ryaouboFB68Wf4U5vGpClm6d9y8BFW','Dejan','Klipa',0,0,0,0),(3,'ban@lk-net.com','$2a$10$UXGQvp1f70KWmH8vp4Xazuo2ZzHVVv2xcKNIGAehSovKJTL4KV9dG','Ban','Klipa',0,0,0,0);
104/*!40000 ALTER TABLE `user` ENABLE KEYS */;
105UNLOCK TABLES;
106/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
107
108/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
109/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
110/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
111/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
112/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
113/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
114/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
115
116-- Dump completed on 2016-08-26 14:13:33