cCmchVMp

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