· 9 years ago · Dec 02, 2016, 01:56 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) unsigned NOT NULL AUTO_INCREMENT,
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 AUTO_INCREMENT=6 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,1,582447853),(2,'test',1,4,0,1005623816),(3,'test',1,4,0,2126970373),(4,'test',1,4,0,1303917155),(5,'test',1,4,0,1534103216);
45/*!40000 ALTER TABLE `career` ENABLE KEYS */;
46UNLOCK TABLES;
47
48--
49-- Table structure for table `inventory`
50--
51
52DROP TABLE IF EXISTS `inventory`;
53/*!40101 SET @saved_cs_client = @@character_set_client */;
54/*!40101 SET character_set_client = utf8 */;
55CREATE TABLE `inventory` (
56 `idx` int(11) unsigned NOT NULL AUTO_INCREMENT,
57 `hero` int(11) unsigned DEFAULT NULL,
58 `location` int(11) unsigned DEFAULT NULL,
59 `position` int(11) unsigned DEFAULT NULL,
60 `resource` mediumtext,
61 `source` longtext,
62 `progress` bigint(20) unsigned DEFAULT NULL,
63 PRIMARY KEY (`idx`)
64) ENGINE=InnoDB DEFAULT CHARSET=latin1;
65/*!40101 SET character_set_client = @saved_cs_client */;
66
67--
68-- Dumping data for table `inventory`
69--
70
71LOCK TABLES `inventory` WRITE;
72/*!40000 ALTER TABLE `inventory` DISABLE KEYS */;
73/*!40000 ALTER TABLE `inventory` ENABLE KEYS */;
74UNLOCK TABLES;
75
76--
77-- Table structure for table `quest`
78--
79
80DROP TABLE IF EXISTS `quest`;
81/*!40101 SET @saved_cs_client = @@character_set_client */;
82/*!40101 SET character_set_client = utf8 */;
83CREATE TABLE `quest` (
84 `Idx` int(11) NOT NULL AUTO_INCREMENT,
85 `hero` int(11) unsigned DEFAULT NULL,
86 `uniqueid` int(11) unsigned DEFAULT NULL,
87 `codedef` int(11) unsigned DEFAULT NULL,
88 `iscompleted` int(11) DEFAULT NULL,
89 PRIMARY KEY (`Idx`)
90) ENGINE=InnoDB AUTO_INCREMENT=44 DEFAULT CHARSET=latin1;
91/*!40101 SET character_set_client = @saved_cs_client */;
92
93--
94-- Dumping data for table `quest`
95--
96
97LOCK TABLES `quest` WRITE;
98/*!40000 ALTER TABLE `quest` DISABLE KEYS */;
99/*!40000 ALTER TABLE `quest` ENABLE KEYS */;
100UNLOCK TABLES;
101
102--
103-- Table structure for table `questtask`
104--
105
106DROP TABLE IF EXISTS `questtask`;
107/*!40101 SET @saved_cs_client = @@character_set_client */;
108/*!40101 SET character_set_client = utf8 */;
109CREATE TABLE `questtask` (
110 `idx` int(11) NOT NULL AUTO_INCREMENT,
111 `hero` int(11) unsigned DEFAULT NULL,
112 `questcodedef` int(11) unsigned DEFAULT NULL,
113 `task` int(11) unsigned DEFAULT NULL,
114 `codedef` int(11) unsigned NOT NULL,
115 `progress` float DEFAULT NULL,
116 `goal` tinytext,
117 `iscompleted` int(11) unsigned DEFAULT NULL,
118 PRIMARY KEY (`idx`)
119) ENGINE=InnoDB AUTO_INCREMENT=51 DEFAULT CHARSET=latin1;
120/*!40101 SET character_set_client = @saved_cs_client */;
121
122--
123-- Dumping data for table `questtask`
124--
125
126LOCK TABLES `questtask` WRITE;
127/*!40000 ALTER TABLE `questtask` DISABLE KEYS */;
128/*!40000 ALTER TABLE `questtask` ENABLE KEYS */;
129UNLOCK TABLES;
130
131--
132-- Table structure for table `skills`
133--
134
135DROP TABLE IF EXISTS `skills`;
136/*!40101 SET @saved_cs_client = @@character_set_client */;
137/*!40101 SET character_set_client = utf8 */;
138CREATE TABLE `skills` (
139 `idx` int(11) NOT NULL AUTO_INCREMENT,
140 `hero` int(11) unsigned DEFAULT NULL,
141 `codedef` int(11) unsigned DEFAULT NULL,
142 `progress` bigint(20) DEFAULT NULL,
143 `id` varchar(16) DEFAULT NULL,
144 PRIMARY KEY (`idx`)
145) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
146/*!40101 SET character_set_client = @saved_cs_client */;
147
148--
149-- Dumping data for table `skills`
150--
151
152LOCK TABLES `skills` WRITE;
153/*!40000 ALTER TABLE `skills` DISABLE KEYS */;
154INSERT INTO `skills` VALUES (3,4,790797660,1479144587,NULL);
155/*!40000 ALTER TABLE `skills` ENABLE KEYS */;
156UNLOCK TABLES;
157
158--
159-- Table structure for table `stories`
160--
161
162DROP TABLE IF EXISTS `stories`;
163/*!40101 SET @saved_cs_client = @@character_set_client */;
164/*!40101 SET character_set_client = utf8 */;
165CREATE TABLE `stories` (
166 `idx` int(11) unsigned NOT NULL AUTO_INCREMENT,
167 `hero` int(11) unsigned DEFAULT NULL,
168 `storycodedef` int(11) unsigned DEFAULT NULL,
169 `storypointcodedef` int(11) unsigned DEFAULT NULL,
170 `completed` int(10) unsigned DEFAULT NULL,
171 PRIMARY KEY (`idx`)
172) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=latin1;
173/*!40101 SET character_set_client = @saved_cs_client */;
174
175--
176-- Dumping data for table `stories`
177--
178
179LOCK TABLES `stories` WRITE;
180/*!40000 ALTER TABLE `stories` DISABLE KEYS */;
181INSERT INTO `stories` VALUES (2,4,1763715536,2493875383,0);
182/*!40000 ALTER TABLE `stories` ENABLE KEYS */;
183UNLOCK TABLES;
184
185--
186-- Table structure for table `traits`
187--
188
189DROP TABLE IF EXISTS `traits`;
190/*!40101 SET @saved_cs_client = @@character_set_client */;
191/*!40101 SET character_set_client = utf8 */;
192CREATE TABLE `traits` (
193 `idx` int(11) NOT NULL,
194 `hero` int(11) DEFAULT NULL,
195 `active_traits` longtext,
196 `available_traits` longtext,
197 `codedef` int(11) unsigned DEFAULT NULL,
198 PRIMARY KEY (`idx`)
199) ENGINE=InnoDB DEFAULT CHARSET=latin1;
200/*!40101 SET character_set_client = @saved_cs_client */;
201
202--
203-- Dumping data for table `traits`
204--
205
206LOCK TABLES `traits` WRITE;
207/*!40000 ALTER TABLE `traits` DISABLE KEYS */;
208INSERT INTO `traits` VALUES (1,4,'1243138031','1243138031.2376863367.4237125204.2916600204.1155821823.3574925702.1477110984',0);
209/*!40000 ALTER TABLE `traits` ENABLE KEYS */;
210UNLOCK TABLES;
211/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
212
213/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
214/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
215/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
216/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
217/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
218/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
219/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
220
221-- Dump completed on 2016-12-02 8:54:56