pj2hXc6S

1-- phpMyAdmin SQL Dump
2-- version 4.0.2
3-- https://www.phpmyadmin.net
4--
5-- Host: localhost
6-- Erstellungszeit: 10. Mai 2015 um 10:43
7-- Server Version: 5.5.16
8-- PHP-Version: 5.3.8
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET time_zone = "+00:00";
12
13
14/*!40101 SET    @old_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15/*!40101 SET    @old_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16/*!40101 SET    @old_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17/*!40101 SET NAMES utf8 */;
18
19CREATE DATABASE IF NOT EXISTS `rotmgprod` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
20USE `rotmgprod`;
21
22--
23-- Datenbank: `rotmgprod`
24--
25CREATE DATABASE IF NOT EXISTS `rotmgprod` DEFAULT CHARACTER SET latin1 COLLATE latin1_swedish_ci;
26USE `rotmgprod`;
27
28-- --------------------------------------------------------
29
30--
31-- Tabellenstruktur für Tabelle `accounts`
32--
33
34CREATE TABLE IF NOT EXISTS `accounts` (
35  `id` bigint(255) NOT NULL AUTO_INCREMENT,
36  `uuid` varchar(128) NOT NULL,
37  `password` varchar(256) NOT NULL,
38  `name` varchar(64) NOT NULL DEFAULT 'DEFAULT',
39  `rank` int(1) NOT NULL DEFAULT '0',
40  `namechosen` tinyint(1) NOT NULL DEFAULT '0',
41  `verified` tinyint(1) NOT NULL DEFAULT '1',
42  `guild` int(11) NOT NULL,
43  `guildRank` int(11) NOT NULL,
44  `guildFame` int(11) NOT NULL DEFAULT '0',
45  `lastip` varchar(128) NOT NULL DEFAULT '',
46  `vaultCount` int(11) NOT NULL DEFAULT '1',
47  `maxCharSlot` int(11) NOT NULL DEFAULT '2',
48  `regTime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
49  `guest` tinyint(1) NOT NULL DEFAULT '0',
50  `banned` tinyint(1) NOT NULL DEFAULT '0',
51  `publicMuledump` int(1) NOT NULL DEFAULT '1',
52  `muted` tinyint(1) NOT NULL,
53  `prodAcc` tinyint(1) NOT NULL DEFAULT '0',
54  `locked` varchar(512) NOT NULL,
55  `ignored` varchar(512) NOT NULL,
56  `gifts` varchar(10000) NOT NULL DEFAULT '',
57  `isAgeVerified` tinyint(1) NOT NULL DEFAULT '0',
58  `petYardType` int(11) NOT NULL DEFAULT '1',
59  `ownedSkins` varchar(2048) NOT NULL,
60  `authToken` varchar(128) NOT NULL DEFAULT '',
61  `acceptedNewTos` tinyint(1) NOT NULL DEFAULT '1',
62  `lastSeen` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
63  `accountInUse` tinyint(1) NOT NULL,
64  `enchantmentLevel` int(1) NOT NULL DEFAULT '1',
65  PRIMARY KEY (`id`,`uuid`,`guild`,`lastip`,`banned`)
66) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
67
68-- --------------------------------------------------------
69
70--
71-- Tabellenstruktur für Tabelle `arenalb`
72--
73
74CREATE TABLE IF NOT EXISTS `arenalb` (
75  `id` int(11) NOT NULL AUTO_INCREMENT,
76  `wave` int(11) NOT NULL,
77  `accid` int(11) NOT NULL,
78  `charid` int(11) NOT NULL,
79  `petid` int(11) DEFAULT NULL,
80  `time` varchar(256) NOT NULL,
81  `date` datetime NOT NULL,
82  PRIMARY KEY (`id`,`wave`)
83) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
84
85-- --------------------------------------------------------
86
87--
88-- Tabellenstruktur für Tabelle `backpacks`
89--
90
91CREATE TABLE IF NOT EXISTS `backpacks` (
92  `accId` int(11) NOT NULL,
93  `charId` int(11) NOT NULL,
94  `items` varchar(128) NOT NULL DEFAULT '-1, -1, -1, -1, -1, -1, -1, -1',
95  PRIMARY KEY (`accId`,`charId`)
96) ENGINE=MyISAM DEFAULT CHARSET=utf8;
97
98-- --------------------------------------------------------
99
100--
101-- Tabellenstruktur für Tabelle `boards`
102--
103
104CREATE TABLE IF NOT EXISTS `boards` (
105  `guildId` int(11) NOT NULL,
106  `text` varchar(1024) NOT NULL,
107  PRIMARY KEY (`guildId`)
108) ENGINE=MyISAM DEFAULT CHARSET=utf8;
109
110-- --------------------------------------------------------
111
112--
113-- Tabellenstruktur für Tabelle `characters`
114--
115
116CREATE TABLE IF NOT EXISTS `characters` (
117  `id` int(11) NOT NULL AUTO_INCREMENT,
118  `accId` int(11) NOT NULL,
119  `charId` int(11) NOT NULL,
120  `charType` int(11) NOT NULL DEFAULT '782',
121  `level` int(11) NOT NULL DEFAULT '1',
122  `exp` int(11) NOT NULL DEFAULT '0',
123  `fame` int(11) NOT NULL DEFAULT '0',
124  `items` varchar(128) NOT NULL DEFAULT '-1, -1, -1, -1',
125  `hpPotions` int(11) NOT NULL DEFAULT '0',
126  `mpPotions` int(11) NOT NULL DEFAULT '0',
127  `hp` int(11) NOT NULL DEFAULT '1',
128  `mp` int(11) NOT NULL DEFAULT '1',
129  `stats` varchar(128) NOT NULL DEFAULT '1, 1, 1, 1, 1, 1, 1, 1',
130  `dead` tinyint(1) NOT NULL DEFAULT '0',
131  `tex1` int(11) NOT NULL DEFAULT '0',
132  `tex2` int(11) NOT NULL DEFAULT '0',
133  `pet` int(11) NOT NULL DEFAULT '-1',
134  `petId` int(11) NOT NULL DEFAULT '-1',
135  `hasBackpack` int(11) NOT NULL DEFAULT '0',
136  `skin` int(11) NOT NULL DEFAULT '0',
137  `xpBoosterTime` int(11) NOT NULL DEFAULT '0',
138  `ldTimer` int(11) NOT NULL DEFAULT '0',
139  `ltTimer` int(11) NOT NULL DEFAULT '0',
140  `fameStats` varchar(512) NOT NULL,
141  `createTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
142  `deathTime` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
143  `totalFame` int(11) NOT NULL DEFAULT '0',
144  `lastSeen` datetime NOT NULL,
145  `lastLocation` varchar(128) NOT NULL,
146  PRIMARY KEY (`id`,`accId`,`dead`)
147) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
148
149-- --------------------------------------------------------
150
151--
152-- Tabellenstruktur für Tabelle `classstats`
153--
154
155CREATE TABLE IF NOT EXISTS `classstats` (
156  `accId` int(11) NOT NULL,
157  `objType` int(11) NOT NULL,
158  `bestLv` int(11) NOT NULL DEFAULT '1',
159  `bestFame` int(11) NOT NULL DEFAULT '0',
160  PRIMARY KEY (`accId`,`objType`)
161) ENGINE=MyISAM DEFAULT CHARSET=utf8;
162
163-- --------------------------------------------------------
164
165--
166-- Tabellenstruktur für Tabelle `dailyquests`
167--
168
169CREATE TABLE IF NOT EXISTS `dailyquests` (
170  `accId` int(11) NOT NULL,
171  `goals` varchar(512) NOT NULL,
172  `tier` int(11) NOT NULL DEFAULT '1',
173  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
174  PRIMARY KEY (`accId`)
175) ENGINE=InnoDB DEFAULT CHARSET=latin1;
176
177-- --------------------------------------------------------
178
179--
180-- Tabellenstruktur für Tabelle `death`
181--
182
183CREATE TABLE IF NOT EXISTS `death` (
184  `accId` int(11) NOT NULL,
185  `chrId` int(11) NOT NULL,
186  `name` varchar(64) NOT NULL DEFAULT 'DEFAULT',
187  `charType` int(11) NOT NULL DEFAULT '782',
188  `tex1` int(11) NOT NULL DEFAULT '0',
189  `tex2` int(11) NOT NULL DEFAULT '0',
190  `skin` int(11) NOT NULL DEFAULT '0',
191  `items` varchar(128) NOT NULL DEFAULT '-1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1, -1',
192  `fame` int(11) NOT NULL DEFAULT '0',
193  `exp` int(11) NOT NULL,
194  `fameStats` varchar(256) NOT NULL,
195  `totalFame` int(11) NOT NULL DEFAULT '0',
196  `firstBorn` tinyint(1) NOT NULL,
197  `killer` varchar(128) NOT NULL,
198  `time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
199  PRIMARY KEY (`accId`,`chrId`,`time`)
200) ENGINE=MyISAM DEFAULT CHARSET=utf8;
201
202-- --------------------------------------------------------
203
204--
205-- Tabellenstruktur für Tabelle `giftcodes`
206--
207
208CREATE TABLE IF NOT EXISTS `giftcodes` (
209  `code` varchar(128) NOT NULL,
210  `content` varchar(512) NOT NULL
211) ENGINE=InnoDB DEFAULT CHARSET=latin1;
212
213-- --------------------------------------------------------
214
215--
216-- Tabellenstruktur für Tabelle `globalnews`
217--
218
219CREATE TABLE IF NOT EXISTS `globalnews` (
220  `slot` int(11) NOT NULL,
221  `linkType` int(11) NOT NULL,
222  `title` varchar(65) NOT NULL,
223  `image` text NOT NULL,
224  `priority` int(11) NOT NULL,
225  `linkDetail` text NOT NULL,
226  `platform` varchar(128) NOT NULL DEFAULT 'kabam.com,kongregate,steam,rotmg',
227  `startTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
228  `endTime` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
229  PRIMARY KEY (`slot`)
230) ENGINE=InnoDB DEFAULT CHARSET=latin1;
231
232-- --------------------------------------------------------
233
234--
235-- Tabellenstruktur für Tabelle `guilds`
236--
237
238CREATE TABLE IF NOT EXISTS `guilds` (
239  `id` int(11) NOT NULL AUTO_INCREMENT,
240  `name` varchar(128) NOT NULL DEFAULT 'DEFAULT_GUILD',
241  `members` varchar(128) NOT NULL,
242  `guildFame` int(11) NOT NULL,
243  `totalGuildFame` int(11) NOT NULL,
244  `level` int(11) NOT NULL DEFAULT '1',
245  PRIMARY KEY (`id`,`members`)
246) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
247
248-- --------------------------------------------------------
249
250--
251-- Tabellenstruktur für Tabelle `mysteryboxes`
252--
253
254CREATE TABLE IF NOT EXISTS `mysteryboxes` (
255  `id` int(11) NOT NULL,
256  `title` varchar(128) NOT NULL,
257  `weight` int(11) NOT NULL,
258  `description` varchar(128) NOT NULL,
259  `contents` text NOT NULL,
260  `priceAmount` int(11) NOT NULL,
261  `priceCurrency` int(11) NOT NULL,
262  `image` text NOT NULL,
263  `icon` text NOT NULL,
264  `salePrice` int(11) NOT NULL,
265  `saleCurrency` int(11) NOT NULL,
266  `saleEnd` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
267  `startTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
268  `boxEnd` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
269  PRIMARY KEY (`id`)
270) ENGINE=InnoDB DEFAULT CHARSET=latin1;
271
272-- --------------------------------------------------------
273
274--
275-- Tabellenstruktur für Tabelle `news`
276--
277
278CREATE TABLE IF NOT EXISTS `news` (
279  `id` int(11) NOT NULL AUTO_INCREMENT,
280  `icon` varchar(16) NOT NULL DEFAULT 'info',
281  `title` varchar(128) NOT NULL DEFAULT 'Default news title',
282  `text` varchar(128) NOT NULL DEFAULT 'Default news text',
283  `link` varchar(256) NOT NULL DEFAULT 'https://mmoe.net/',
284  `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
285  PRIMARY KEY (`id`,`text`)
286) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
287
288-- --------------------------------------------------------
289
290--
291-- Tabellenstruktur für Tabelle `packages`
292--
293
294CREATE TABLE IF NOT EXISTS `packages` (
295  `id` int(11) NOT NULL AUTO_INCREMENT,
296  `name` varchar(128) NOT NULL,
297  `maxPurchase` int(11) NOT NULL DEFAULT '-1',
298  `weight` int(11) NOT NULL DEFAULT '0',
299  `contents` text NOT NULL,
300  `bgUrl` varchar(512) NOT NULL,
301  `price` int(11) NOT NULL,
302  `quantity` int(11) NOT NULL DEFAULT '-1',
303  `endDate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
304  PRIMARY KEY (`id`)
305) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
306
307-- --------------------------------------------------------
308
309--
310-- Tabellenstruktur für Tabelle `pets`
311--
312
313CREATE TABLE IF NOT EXISTS `pets` (
314  `accId` int(11) NOT NULL,
315  `petId` int(11) NOT NULL AUTO_INCREMENT,
316  `objType` smallint(5) NOT NULL,
317  `skinName` varchar(128) NOT NULL,
318  `skin` int(11) NOT NULL,
319  `family` int(11) NOT NULL,
320  `rarity` int(11) NOT NULL,
321  `maxLevel` int(11) NOT NULL DEFAULT '30',
322  `abilities` varchar(128) NOT NULL,
323  `levels` varchar(128) NOT NULL,
324  `xp` varchar(128) NOT NULL DEFAULT '0, 0, 0',
325  PRIMARY KEY (`accId`,`petId`)
326) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
327
328-- --------------------------------------------------------
329
330--
331-- Tabellenstruktur für Tabelle `stats`
332--
333
334CREATE TABLE IF NOT EXISTS `stats` (
335  `accId` int(11) NOT NULL,
336  `fame` int(11) NOT NULL,
337  `totalFame` int(11) NOT NULL,
338  `credits` int(11) NOT NULL,
339  `totalCredits` int(11) NOT NULL,
340  `fortuneTokens` int(11) NOT NULL,
341  `totalFortuneTokens` int(11) NOT NULL,
342  `onraneCurrency` int(11) NOT NULL,
343  `totalOnrane` int(11) NOT NULL,
344  PRIMARY KEY (`accId`,`fame`,`totalFame`)
345) ENGINE=MyISAM DEFAULT CHARSET=utf8;
346
347-- --------------------------------------------------------
348
349--
350-- Tabellenstruktur für Tabelle `thealchemist`
351--
352
353CREATE TABLE IF NOT EXISTS `thealchemist` (
354  `id` int(11) NOT NULL,
355  `title` varchar(512) NOT NULL,
356  `description` varchar(512) DEFAULT NULL,
357  `image` varchar(512) NOT NULL,
358  `icon` varchar(512) NOT NULL,
359  `contents` text NOT NULL,
360  `priceFirstInGold` int(11) NOT NULL DEFAULT '51',
361  `priceFirstInToken` int(11) NOT NULL DEFAULT '1',
362  `priceSecondInGold` int(11) NOT NULL DEFAULT '75',
363  `startTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
364  `endTime` datetime NOT NULL,
365  PRIMARY KEY (`id`)
366) ENGINE=InnoDB DEFAULT CHARSET=latin1;
367
368-- --------------------------------------------------------
369
370--
371-- Tabellenstruktur für Tabelle `unlockedclasses`
372--
373
374CREATE TABLE IF NOT EXISTS `unlockedclasses` (
375  `id` int(11) NOT NULL AUTO_INCREMENT,
376  `accId` int(11) NOT NULL,
377  `class` varchar(128) NOT NULL,
378  `available` varchar(128) NOT NULL,
379  PRIMARY KEY (`id`)
380) ENGINE=InnoDB  DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;
381
382-- --------------------------------------------------------
383
384--
385-- Tabellenstruktur für Tabelle `vaults`
386--
387
388CREATE TABLE IF NOT EXISTS `vaults` (
389  `accId` int(11) NOT NULL,
390  `chestId` int(11) NOT NULL AUTO_INCREMENT,
391  `items` varchar(128) NOT NULL,
392  PRIMARY KEY (`accId`,`chestId`)
393) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
394
395/*!40101 SET CHARACTER_SET_CLIENT    @old_CHARACTER_SET_CLIENT */;
396/*!40101 SET CHARACTER_SET_RESULTS    @old_CHARACTER_SET_RESULTS */;
397/*!40101 SET COLLATION_CONNECTION    @old_COLLATION_CONNECTION */;