· 9 years ago · Nov 15, 2016, 07:32 PM
1CREATE DATABASE IF NOT EXISTS `sql4101807` /*!40100 DEFAULT CHARACTER SET latin1 */;
2USE `sql4101807`;
3-- MySQL dump 10.13 Distrib 5.7.9, for linux-glibc2.5 (x86_64)
4--
5-- Host: localhost Database: sql4101807
6-- ------------------------------------------------------
7-- Server version 5.6.33-0ubuntu0.14.04.1
8
9/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
10/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
11/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
12/*!40101 SET NAMES utf8 */;
13/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
14/*!40103 SET TIME_ZONE='+00:00' */;
15/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
16/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
17/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
18/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
19
20--
21-- Table structure for table `career`
22--
23
24DROP TABLE IF EXISTS `career`;
25/*!40101 SET @saved_cs_client = @@character_set_client */;
26/*!40101 SET character_set_client = utf8 */;
27CREATE TABLE `career` (
28 `idx` int(11) NOT NULL,
29 `description` varchar(45) DEFAULT NULL,
30 `tier` int(11) unsigned DEFAULT NULL,
31 `hero` int(11) unsigned DEFAULT NULL,
32 `unlocked` int(11) unsigned DEFAULT NULL,
33 `codedef` int(11) unsigned DEFAULT NULL,
34 PRIMARY KEY (`idx`)
35) ENGINE=InnoDB DEFAULT CHARSET=latin1;
36/*!40101 SET character_set_client = @saved_cs_client */;
37
38--
39-- Dumping data for table `career`
40--
41
42LOCK TABLES `career` WRITE;
43/*!40000 ALTER TABLE `career` DISABLE KEYS */;
44INSERT INTO `career` VALUES (1,'engineering',3,4,0,582447853);
45/*!40000 ALTER TABLE `career` ENABLE KEYS */;
46UNLOCK TABLES;
47
48--
49-- Table structure for table `quest`
50--
51
52DROP TABLE IF EXISTS `quest`;
53/*!40101 SET @saved_cs_client = @@character_set_client */;
54/*!40101 SET character_set_client = utf8 */;
55CREATE TABLE `quest` (
56 `Idx` int(11) NOT NULL AUTO_INCREMENT,
57 `hero` int(11) unsigned DEFAULT NULL,
58 `uniqueid` int(11) unsigned DEFAULT NULL,
59 `codedef` int(11) unsigned DEFAULT NULL,
60 `iscompleted` int(11) DEFAULT NULL,
61 PRIMARY KEY (`Idx`)
62) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=latin1;
63/*!40101 SET character_set_client = @saved_cs_client */;
64
65--
66-- Dumping data for table `quest`
67--
68
69LOCK TABLES `quest` WRITE;
70/*!40000 ALTER TABLE `quest` DISABLE KEYS */;
71INSERT INTO `quest` VALUES (9,3,2482084270,2482084270,0),(10,3,2681115074,2681115074,0);
72/*!40000 ALTER TABLE `quest` ENABLE KEYS */;
73UNLOCK TABLES;
74
75--
76-- Table structure for table `questtask`
77--
78
79DROP TABLE IF EXISTS `questtask`;
80/*!40101 SET @saved_cs_client = @@character_set_client */;
81/*!40101 SET character_set_client = utf8 */;
82CREATE TABLE `questtask` (
83 `idx` int(11) NOT NULL AUTO_INCREMENT,
84 `hero` int(11) unsigned DEFAULT NULL,
85 `questcodedef` int(11) unsigned DEFAULT NULL,
86 `task` int(11) unsigned DEFAULT NULL,
87 `codedef` int(11) unsigned DEFAULT NULL,
88 `progress` float DEFAULT NULL,
89 `goal` int(11) DEFAULT NULL,
90 `iscompleted` int(11) unsigned DEFAULT NULL,
91 PRIMARY KEY (`idx`)
92) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=latin1;
93/*!40101 SET character_set_client = @saved_cs_client */;
94
95--
96-- Dumping data for table `questtask`
97--
98
99LOCK TABLES `questtask` WRITE;
100/*!40000 ALTER TABLE `questtask` DISABLE KEYS */;
101INSERT INTO `questtask` VALUES (15,3,2482084270,0,0,0,0,0),(16,3,2482084270,1,0,0,0,0),(17,3,2681115074,0,0,0,0,0);
102/*!40000 ALTER TABLE `questtask` ENABLE KEYS */;
103UNLOCK TABLES;
104
105--
106-- Table structure for table `skills`
107--
108
109DROP TABLE IF EXISTS `skills`;
110/*!40101 SET @saved_cs_client = @@character_set_client */;
111/*!40101 SET character_set_client = utf8 */;
112CREATE TABLE `skills` (
113 `idx` int(11) NOT NULL AUTO_INCREMENT,
114 `hero` int(11) unsigned DEFAULT NULL,
115 `skill` int(11) unsigned DEFAULT NULL,
116 `progress` bigint(20) DEFAULT NULL,
117 `id` varchar(16) DEFAULT NULL,
118 PRIMARY KEY (`idx`)
119) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
120/*!40101 SET character_set_client = @saved_cs_client */;
121
122--
123-- Dumping data for table `skills`
124--
125
126LOCK TABLES `skills` WRITE;
127/*!40000 ALTER TABLE `skills` DISABLE KEYS */;
128INSERT INTO `skills` VALUES (3,4,790797660,1479144587,NULL);
129/*!40000 ALTER TABLE `skills` ENABLE KEYS */;
130UNLOCK TABLES;
131
132--
133-- Table structure for table `traits`
134--
135
136DROP TABLE IF EXISTS `traits`;
137/*!40101 SET @saved_cs_client = @@character_set_client */;
138/*!40101 SET character_set_client = utf8 */;
139CREATE TABLE `traits` (
140 `idx` int(11) NOT NULL,
141 `hero` int(11) DEFAULT NULL,
142 `active_traits` longtext,
143 `available_traits` longtext,
144 `codedef` int(11) unsigned DEFAULT NULL,
145 PRIMARY KEY (`idx`)
146) ENGINE=InnoDB DEFAULT CHARSET=latin1;
147/*!40101 SET character_set_client = @saved_cs_client */;
148
149--
150-- Dumping data for table `traits`
151--
152
153LOCK TABLES `traits` WRITE;
154/*!40000 ALTER TABLE `traits` DISABLE KEYS */;
155INSERT INTO `traits` VALUES (1,4,'','2376863367.4237125204.2916600204.1155821823.3574925702.1477110984',0);
156/*!40000 ALTER TABLE `traits` ENABLE KEYS */;
157UNLOCK TABLES;
158/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
159
160/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
161/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
162/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
163/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
164/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
165/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
166/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
167
168-- Dump completed on 2016-11-15 14:29:30