· 9 years ago · Jan 04, 2017, 02:34 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 `account`
22--
23
24DROP TABLE IF EXISTS `account`;
25/*!40101 SET @saved_cs_client = @@character_set_client */;
26/*!40101 SET character_set_client = utf8 */;
27CREATE TABLE `account` (
28 `Id` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
29 `Username` varchar(45) DEFAULT NULL,
30 `Firstname` varchar(45) DEFAULT NULL,
31 `Lastname` varchar(45) DEFAULT NULL,
32 `Email` varchar(45) DEFAULT NULL,
33 `Password` varchar(45) DEFAULT NULL,
34 `Admin` tinyint(1) DEFAULT NULL,
35 PRIMARY KEY (`Id`)
36) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
37/*!40101 SET character_set_client = @saved_cs_client */;
38
39--
40-- Dumping data for table `account`
41--
42
43LOCK TABLES `account` WRITE;
44/*!40000 ALTER TABLE `account` DISABLE KEYS */;
45INSERT INTO `account` VALUES (1,'Admin','Andrej','Skorinko','itisscan@gmail.com','Admin',1),(2,'itisscan','Andrej','Skorinko','andrejssk1002@gmail.com','resource',1),(3,'player','test','vivienne','mistsinglewhisp@yahoo.com','test',1);
46/*!40000 ALTER TABLE `account` ENABLE KEYS */;
47UNLOCK TABLES;
48
49--
50-- Table structure for table `career`
51--
52
53DROP TABLE IF EXISTS `career`;
54/*!40101 SET @saved_cs_client = @@character_set_client */;
55/*!40101 SET character_set_client = utf8 */;
56CREATE TABLE `career` (
57 `idx` int(11) unsigned NOT NULL AUTO_INCREMENT,
58 `description` varchar(45) DEFAULT NULL,
59 `tier` int(11) unsigned DEFAULT NULL,
60 `hero` int(11) unsigned DEFAULT NULL,
61 `unlocked` int(11) unsigned DEFAULT NULL,
62 `codedef` int(11) unsigned DEFAULT NULL,
63 PRIMARY KEY (`idx`)
64) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=latin1;
65/*!40101 SET character_set_client = @saved_cs_client */;
66
67--
68-- Dumping data for table `career`
69--
70
71LOCK TABLES `career` WRITE;
72/*!40000 ALTER TABLE `career` DISABLE KEYS */;
73INSERT 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),(6,NULL,1,6,0,582447853),(7,NULL,1,6,0,1005623816),(8,NULL,1,6,0,2126970373),(9,NULL,1,6,0,1303917155),(10,NULL,1,6,0,1534103216),(11,NULL,1,7,0,582447853),(12,NULL,1,7,0,1005623816),(13,NULL,1,7,0,2126970373),(14,NULL,1,7,0,1303917155),(15,NULL,1,7,0,1534103216);
74/*!40000 ALTER TABLE `career` ENABLE KEYS */;
75UNLOCK TABLES;
76
77--
78-- Table structure for table `hero`
79--
80
81DROP TABLE IF EXISTS `hero`;
82/*!40101 SET @saved_cs_client = @@character_set_client */;
83/*!40101 SET character_set_client = utf8 */;
84CREATE TABLE `hero` (
85 `Id` int(11) NOT NULL AUTO_INCREMENT,
86 `Name` varchar(45) NOT NULL,
87 `Gender` int(11) DEFAULT NULL,
88 `Race` varchar(45) NOT NULL,
89 `World` varchar(45) DEFAULT NULL,
90 `Location` varchar(45) DEFAULT NULL,
91 `Level` int(11) DEFAULT '1',
92 `Position_X` int(10) unsigned DEFAULT NULL,
93 `Position_Y` int(10) unsigned DEFAULT NULL,
94 `Position_Z` int(10) unsigned DEFAULT NULL,
95 `Orientation_W` int(10) unsigned DEFAULT NULL,
96 `Orientation_X` int(10) unsigned DEFAULT NULL,
97 `Orientation_Y` int(10) unsigned DEFAULT NULL,
98 `Orientation_Z` int(10) unsigned DEFAULT NULL,
99 `Account_Id` smallint(5) unsigned NOT NULL,
100 PRIMARY KEY (`Id`),
101 KEY `Hero_Owner` (`Account_Id`),
102 CONSTRAINT `Hero_Owner` FOREIGN KEY (`Account_Id`) REFERENCES `account` (`Id`) ON DELETE CASCADE
103) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;
104/*!40101 SET character_set_client = @saved_cs_client */;
105
106--
107-- Dumping data for table `hero`
108--
109
110LOCK TABLES `hero` WRITE;
111/*!40000 ALTER TABLE `hero` DISABLE KEYS */;
112INSERT INTO `hero` VALUES (1,'itisscan',NULL,'Terrans','Earth','EarthBaseStation',1,0,0,0,0,0,0,0,1),(2,'gradomir',NULL,'Terrans','Earth','EarthBaseStation',1,0,0,0,0,0,0,0,1),(3,'Joe',NULL,'Terrans','Earth','EarthBaseStation',1,0,0,0,1,0,0,0,1),(4,'alex',NULL,'Terrans','Earth','EarthBaseStation',1,0,0,0,1,0,0,0,3),(5,'cage',0,'DeuseExMachina','Saturne','SaturneBaseStation',1,0,0,0,1,0,0,0,3),(6,'jessica',0,'Terrans','Earth','EarthBaseStation',1,0,0,0,1,0,0,0,3),(7,'beatrice',0,'Terrans','Earth','EarthBaseStation',1,0,0,0,1,0,0,0,3);
113/*!40000 ALTER TABLE `hero` ENABLE KEYS */;
114UNLOCK TABLES;
115
116--
117-- Table structure for table `inventory`
118--
119
120DROP TABLE IF EXISTS `inventory`;
121/*!40101 SET @saved_cs_client = @@character_set_client */;
122/*!40101 SET character_set_client = utf8 */;
123CREATE TABLE `inventory` (
124 `idx` int(11) unsigned NOT NULL AUTO_INCREMENT,
125 `hero` int(11) unsigned DEFAULT NULL,
126 `location` int(11) unsigned DEFAULT NULL,
127 `position` int(11) unsigned DEFAULT NULL,
128 `resource` mediumtext,
129 `source` longtext,
130 `progress` bigint(20) unsigned DEFAULT NULL,
131 PRIMARY KEY (`idx`)
132) ENGINE=InnoDB DEFAULT CHARSET=latin1;
133/*!40101 SET character_set_client = @saved_cs_client */;
134
135--
136-- Dumping data for table `inventory`
137--
138
139LOCK TABLES `inventory` WRITE;
140/*!40000 ALTER TABLE `inventory` DISABLE KEYS */;
141/*!40000 ALTER TABLE `inventory` ENABLE KEYS */;
142UNLOCK TABLES;
143
144--
145-- Table structure for table `location`
146--
147
148DROP TABLE IF EXISTS `location`;
149/*!40101 SET @saved_cs_client = @@character_set_client */;
150/*!40101 SET character_set_client = utf8 */;
151CREATE TABLE `location` (
152 `Id` int(11) NOT NULL AUTO_INCREMENT,
153 `Name` char(50) NOT NULL,
154 `Scene` char(50) NOT NULL COMMENT 'Path to scene XML file',
155 PRIMARY KEY (`Id`)
156) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=latin1 COMMENT='Location can be station, dungeon, planet etc.\r\n';
157/*!40101 SET character_set_client = @saved_cs_client */;
158
159--
160-- Dumping data for table `location`
161--
162
163LOCK TABLES `location` WRITE;
164/*!40000 ALTER TABLE `location` DISABLE KEYS */;
165INSERT INTO `location` VALUES (1,'EarthBaseStation','Levels\\EarthBaseStationTest.xml');
166/*!40000 ALTER TABLE `location` ENABLE KEYS */;
167UNLOCK TABLES;
168
169--
170-- Table structure for table `quest`
171--
172
173DROP TABLE IF EXISTS `quest`;
174/*!40101 SET @saved_cs_client = @@character_set_client */;
175/*!40101 SET character_set_client = utf8 */;
176CREATE TABLE `quest` (
177 `Idx` int(11) NOT NULL AUTO_INCREMENT,
178 `hero` int(11) unsigned DEFAULT NULL,
179 `uniqueid` int(11) unsigned DEFAULT NULL,
180 `codedef` int(11) unsigned DEFAULT NULL,
181 `iscompleted` int(11) DEFAULT NULL,
182 PRIMARY KEY (`Idx`)
183) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=latin1;
184/*!40101 SET character_set_client = @saved_cs_client */;
185
186--
187-- Dumping data for table `quest`
188--
189
190LOCK TABLES `quest` WRITE;
191/*!40000 ALTER TABLE `quest` DISABLE KEYS */;
192/*!40000 ALTER TABLE `quest` ENABLE KEYS */;
193UNLOCK TABLES;
194
195--
196-- Table structure for table `questtask`
197--
198
199DROP TABLE IF EXISTS `questtask`;
200/*!40101 SET @saved_cs_client = @@character_set_client */;
201/*!40101 SET character_set_client = utf8 */;
202CREATE TABLE `questtask` (
203 `idx` int(11) NOT NULL AUTO_INCREMENT,
204 `hero` int(11) unsigned DEFAULT NULL,
205 `questcodedef` int(11) unsigned DEFAULT NULL,
206 `task` int(11) unsigned DEFAULT NULL,
207 `codedef` int(11) unsigned NOT NULL,
208 `progress` float DEFAULT NULL,
209 `goal` tinytext,
210 `iscompleted` int(11) unsigned DEFAULT NULL,
211 PRIMARY KEY (`idx`)
212) ENGINE=InnoDB AUTO_INCREMENT=33 DEFAULT CHARSET=latin1;
213/*!40101 SET character_set_client = @saved_cs_client */;
214
215--
216-- Dumping data for table `questtask`
217--
218
219LOCK TABLES `questtask` WRITE;
220/*!40000 ALTER TABLE `questtask` DISABLE KEYS */;
221/*!40000 ALTER TABLE `questtask` ENABLE KEYS */;
222UNLOCK TABLES;
223
224--
225-- Table structure for table `skills`
226--
227
228DROP TABLE IF EXISTS `skills`;
229/*!40101 SET @saved_cs_client = @@character_set_client */;
230/*!40101 SET character_set_client = utf8 */;
231CREATE TABLE `skills` (
232 `idx` int(11) NOT NULL AUTO_INCREMENT,
233 `hero` int(11) unsigned DEFAULT NULL,
234 `codedef` int(11) unsigned DEFAULT NULL,
235 `progress` bigint(20) DEFAULT NULL,
236 `id` varchar(16) DEFAULT NULL,
237 PRIMARY KEY (`idx`)
238) ENGINE=InnoDB AUTO_INCREMENT=25 DEFAULT CHARSET=latin1;
239/*!40101 SET character_set_client = @saved_cs_client */;
240
241--
242-- Dumping data for table `skills`
243--
244
245LOCK TABLES `skills` WRITE;
246/*!40000 ALTER TABLE `skills` DISABLE KEYS */;
247INSERT INTO `skills` VALUES (3,4,790797660,1479144587,NULL),(23,4,2640379709,1483244358,NULL),(24,4,553200446,1483244358,NULL);
248/*!40000 ALTER TABLE `skills` ENABLE KEYS */;
249UNLOCK TABLES;
250
251--
252-- Table structure for table `stories`
253--
254
255DROP TABLE IF EXISTS `stories`;
256/*!40101 SET @saved_cs_client = @@character_set_client */;
257/*!40101 SET character_set_client = utf8 */;
258CREATE TABLE `stories` (
259 `idx` int(11) unsigned NOT NULL AUTO_INCREMENT,
260 `hero` int(11) unsigned DEFAULT NULL,
261 `storycodedef` int(11) unsigned DEFAULT NULL,
262 `storypointcodedef` int(11) unsigned DEFAULT NULL,
263 `completed` int(10) unsigned DEFAULT NULL,
264 PRIMARY KEY (`idx`)
265) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;
266/*!40101 SET character_set_client = @saved_cs_client */;
267
268--
269-- Dumping data for table `stories`
270--
271
272LOCK TABLES `stories` WRITE;
273/*!40000 ALTER TABLE `stories` DISABLE KEYS */;
274INSERT INTO `stories` VALUES (3,4,1763715536,2493875383,0);
275/*!40000 ALTER TABLE `stories` ENABLE KEYS */;
276UNLOCK TABLES;
277
278--
279-- Table structure for table `traits`
280--
281
282DROP TABLE IF EXISTS `traits`;
283/*!40101 SET @saved_cs_client = @@character_set_client */;
284/*!40101 SET character_set_client = utf8 */;
285CREATE TABLE `traits` (
286 `idx` int(11) NOT NULL AUTO_INCREMENT,
287 `hero` int(11) DEFAULT NULL,
288 `active_traits` longtext,
289 `available_traits` longtext,
290 `codedef` int(11) unsigned DEFAULT NULL,
291 PRIMARY KEY (`idx`)
292) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=latin1;
293/*!40101 SET character_set_client = @saved_cs_client */;
294
295--
296-- Dumping data for table `traits`
297--
298
299LOCK TABLES `traits` WRITE;
300/*!40000 ALTER TABLE `traits` DISABLE KEYS */;
301INSERT INTO `traits` VALUES (1,4,'1243138031','1243138031.3574925702.1155821823.2916600204.1477110984.4237125204.2376863367',NULL),(2,5,'','',NULL),(3,6,'1243138031','1243138031.3574925702.1155821823.2916600204.1477110984.4237125204.2376863367',NULL),(4,7,'1243138031','1243138031.3574925702.1155821823.2916600204.1477110984.4237125204.2376863367',NULL);
302/*!40000 ALTER TABLE `traits` ENABLE KEYS */;
303UNLOCK TABLES;
304
305--
306-- Dumping events for database 'sql4101807'
307--
308
309--
310-- Dumping routines for database 'sql4101807'
311--
312/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
313
314/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
315/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
316/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
317/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
318/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
319/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
320/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
321
322-- Dump completed on 2017-01-04 9:32:39