whoareyou.sql
5.48 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
-- MySQL dump 10.13 Distrib 8.0.13, for Win64 (x86_64)
--
-- Host: localhost Database: whoareyou
-- ------------------------------------------------------
-- Server version 8.0.13
/*!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 */;
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 `card`
--
DROP TABLE IF EXISTS `card`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
SET character_set_client = utf8mb4 ;
CREATE TABLE `card` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`deckId` int(11) DEFAULT NULL,
`cardId` int(64) DEFAULT NULL,
`cardCost` int(11) DEFAULT NULL,
`cardName` varchar(45) DEFAULT NULL,
`cardNum` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=677 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `card`
--
LOCK TABLES `card` WRITE;
/*!40000 ALTER TABLE `card` DISABLE KEYS */;
INSERT INTO `card` VALUES (626,124,70,1,'Blessing of Might',2),(627,124,41323,1,'Fire Fly',2),(628,124,48982,1,'Glow-Tron',2),(629,124,41912,1,'Lost in the Jungle',2),(630,124,48886,1,'Mecharoo',2),(631,124,42467,1,'Righteous Protector',2),(632,124,679,3,'Divine Favor',2),(633,124,1401,3,'Raid Leader',2),(634,124,45782,3,'Unidentified Maul',2),(635,124,46461,3,'Void Ripper',2),(636,124,45265,5,'Fungalmancer',2),(637,124,559,5,'Leeroy Jenkins',1),(638,124,45877,5,'Level Up!',2),(639,124,43515,7,'Corridor Creeper',2),(640,124,41859,7,'Vinecleaver',2),(641,124,48158,9,'Baku the Mooneater',1),(642,125,70,1,'Blessing of Might',2),(643,125,41323,1,'Fire Fly',2),(644,125,48982,1,'Glow-Tron',2),(645,125,41912,1,'Lost in the Jungle',2),(646,125,48886,1,'Mecharoo',2),(647,125,42467,1,'Righteous Protector',2),(648,125,679,3,'Divine Favor',2),(649,125,1401,3,'Raid Leader',2),(650,125,45782,3,'Unidentified Maul',2),(651,125,46461,3,'Void Ripper',2),(652,125,45265,5,'Fungalmancer',2),(653,125,559,5,'Leeroy Jenkins',1),(654,125,45877,5,'Level Up!',2),(655,125,43515,7,'Corridor Creeper',2),(656,125,41859,7,'Vinecleaver',2),(657,125,48158,9,'Baku the Mooneater',1),(658,126,180,0,'Backstab',2),(659,126,365,0,'Shadowstep',2),(660,126,268,1,'Cold Blood',2),(661,126,41323,1,'Fire Fly',2),(662,126,45340,2,'Prince Keleseth',1),(663,126,306,3,'Edwin VanCleef',1),(664,126,41683,3,'Gluttonous Ooze',1),(665,126,47014,3,'Hench-Clan Thug',2),(666,126,1117,3,'SI:7 Agent',2),(667,126,41418,3,'Tar Creeper',1),(668,126,45531,4,'Elven Minstrel',2),(669,126,43228,4,'Fal\'dorei Strider',2),(670,126,42395,4,'Saronite Chain Gang',2),(671,126,49972,4,'Spirit of the Shark',1),(672,126,45265,5,'Fungalmancer',2),(673,126,559,5,'Leeroy Jenkins',1),(674,126,48487,5,'Myra\'s Unstable Element',1),(675,126,41217,5,'Vilespine Slayer',2),(676,126,49184,5,'Zilliax',1);
/*!40000 ALTER TABLE `card` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `deck`
--
DROP TABLE IF EXISTS `deck`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
SET character_set_client = utf8mb4 ;
CREATE TABLE `deck` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`deckOwner` varchar(45) DEFAULT NULL,
`deckTitle` varchar(45) DEFAULT NULL,
`deckCode` varchar(500) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=127 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `deck`
--
LOCK TABLES `deck` WRITE;
/*!40000 ALTER TABLE `deck` DISABLE KEYS */;
INSERT INTO `deck` VALUES (124,'test','홀수 성기사','AAECAZ8FAq8EnvgCDkbrwgLW/gK4xwL2/QLjywKnBfkK1uUC/eoC0eECteYC+9MCg8cCAA=='),(125,'oss','홀수 성기사','AAECAZ8FAq8EnvgCDkbrwgLW/gK4xwL2/QLjywKnBfkK1uUC/eoC0eECteYC+9MCg8cCAA=='),(126,'oss','켈레서스 템포 토적','AAECAaIHCJziArIC08UCysMCtIYDrwTn+gKggAMLtAHtAowC68ICpu8C3Qjb4wLc0QKbywLR4QKBwgIA');
/*!40000 ALTER TABLE `deck` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `user`
--
DROP TABLE IF EXISTS `user`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
SET character_set_client = utf8mb4 ;
CREATE TABLE `user` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`userId` varchar(45) DEFAULT NULL,
`password` longtext,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=28 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `user`
--
LOCK TABLES `user` WRITE;
/*!40000 ALTER TABLE `user` DISABLE KEYS */;
INSERT INTO `user` VALUES (26,'test','$2a$10$l6IgaLy13XZ7gu3prxvwF.zFH5kfkZVw2AQ6eSZgIeyPjVL3w1fr.'),(27,'oss','$2a$10$79hOQPJMKrTaLo.wk72uReH3SdR2wj4NV2DmWROHZ05uUxgmsP28K');
/*!40000 ALTER TABLE `user` 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 2019-05-24 18:28:39