· 6 years ago · Aug 20, 2019, 05:46 PM
1-- phpMyAdmin SQL Dump
2-- version 4.9.0.1
3-- https://www.phpmyadmin.net/
4--
5-- Host: 127.0.0.1
6-- Tempo de geração: 20-Ago-2019 às 05:32
7-- Versão do servidor: 10.3.16-MariaDB
8-- versão do PHP: 7.3.8
9
10SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
11SET AUTOCOMMIT = 0;
12START TRANSACTION;
13SET time_zone = "+00:00";
14
15
16/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
17/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
18/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
19/*!40101 SET NAMES utf8mb4 */;
20
21--
22-- Banco de dados: `otxservernew`
23--
24
25-- --------------------------------------------------------
26
27--
28-- Estrutura da tabela `accounts`
29--
30
31CREATE TABLE `accounts` (
32 `id` int(11) NOT NULL,
33 `name` varchar(32) NOT NULL,
34 `password` char(40) NOT NULL,
35 `secret` char(32) DEFAULT NULL,
36 `secret_status` tinyint(1) NOT NULL DEFAULT 0,
37 `type` int(11) NOT NULL DEFAULT 1,
38 `premdays` int(11) NOT NULL DEFAULT 0,
39 `coins` int(12) NOT NULL DEFAULT 0,
40 `lastday` int(10) UNSIGNED NOT NULL DEFAULT 0,
41 `email` varchar(255) NOT NULL DEFAULT '',
42 `creation` int(11) NOT NULL DEFAULT 0,
43 `vote` int(11) NOT NULL,
44 `key` varchar(20) NOT NULL DEFAULT '0',
45 `email_new` varchar(255) NOT NULL DEFAULT '',
46 `email_new_time` int(11) NOT NULL DEFAULT 0,
47 `rlname` varchar(255) NOT NULL DEFAULT '',
48 `location` varchar(255) NOT NULL DEFAULT '',
49 `page_access` int(11) NOT NULL DEFAULT 0,
50 `email_code` varchar(255) NOT NULL DEFAULT '',
51 `next_email` int(11) NOT NULL DEFAULT 0,
52 `create_date` int(11) NOT NULL DEFAULT 0,
53 `create_ip` int(10) UNSIGNED DEFAULT NULL,
54 `last_post` int(11) NOT NULL DEFAULT 0,
55 `flag` varchar(80) NOT NULL DEFAULT '',
56 `vip_time` int(11) NOT NULL DEFAULT 0,
57 `guild_points` int(11) NOT NULL DEFAULT 0,
58 `guild_points_stats` int(11) NOT NULL DEFAULT 0,
59 `passed` int(11) NOT NULL DEFAULT 0,
60 `block` int(11) NOT NULL DEFAULT 0,
61 `refresh` int(11) NOT NULL DEFAULT 0,
62 `birth_date` varchar(50) DEFAULT NULL,
63 `gender` varchar(20) DEFAULT NULL,
64 `loyalty_points` bigint(20) NOT NULL DEFAULT 0,
65 `authToken` varchar(100) DEFAULT NULL,
66 `player_sell_bank` int(11) DEFAULT NULL
67) ENGINE=InnoDB DEFAULT CHARSET=latin1;
68
69--
70-- Extraindo dados da tabela `accounts`
71--
72
73INSERT INTO `accounts` (`id`, `name`, `password`, `secret`, `secret_status`, `type`, `premdays`, `coins`, `lastday`, `email`, `creation`, `vote`, `key`, `email_new`, `email_new_time`, `rlname`, `location`, `page_access`, `email_code`, `next_email`, `create_date`, `create_ip`, `last_post`, `flag`, `vip_time`, `guild_points`, `guild_points_stats`, `passed`, `block`, `refresh`, `birth_date`, `gender`, `loyalty_points`, `authToken`, `player_sell_bank`) VALUES
74(1, '1', '21949114ddb23dd9b52fdd080052b465833beecb', NULL, 0, 1, 0, 0, 0, '', 0, 0, '0', '', 0, '', '', 0, '', 0, 0, 0, 0, 'br', 0, 0, 0, 0, 0, 0, '', '', 0, '', NULL),
75(2, 'sellcharacters', 'ee0fe8115075f9f1785710a126a89cca6e9bac52', '6LFXDGCJ4ONRKUGQHXXXC2CUVAAB3FU4', 0, 1, 0, 0, 0, 'sell@email.com', 0, 0, '0', '0', 0, '0', '', 0, '0', 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 0, '', 'm', 0, '', NULL);
76
77-- --------------------------------------------------------
78
79--
80-- Estrutura da tabela `account_bans`
81--
82
83CREATE TABLE `account_bans` (
84 `account_id` int(11) NOT NULL,
85 `reason` varchar(255) NOT NULL,
86 `banned_at` datetime NOT NULL,
87 `expires_at` datetime NOT NULL,
88 `banned_by` int(11) NOT NULL
89) ENGINE=InnoDB DEFAULT CHARSET=latin1;
90
91-- --------------------------------------------------------
92
93--
94-- Estrutura da tabela `account_ban_history`
95--
96
97CREATE TABLE `account_ban_history` (
98 `id` int(10) UNSIGNED NOT NULL,
99 `account_id` int(11) NOT NULL,
100 `reason` varchar(255) NOT NULL,
101 `banned_at` bigint(20) NOT NULL,
102 `expired_at` bigint(20) NOT NULL,
103 `banned_by` int(11) NOT NULL
104) ENGINE=InnoDB DEFAULT CHARSET=latin1;
105
106-- --------------------------------------------------------
107
108--
109-- Estrutura da tabela `account_character_sale`
110--
111
112CREATE TABLE `account_character_sale` (
113 `id` int(11) NOT NULL,
114 `id_account` int(11) NOT NULL,
115 `id_player` int(11) NOT NULL,
116 `status` tinyint(1) NOT NULL DEFAULT 0,
117 `price_type` tinyint(4) NOT NULL,
118 `price_coins` int(11) DEFAULT NULL,
119 `price_gold` int(11) DEFAULT NULL,
120 `dta_insert` datetime NOT NULL,
121 `dta_valid` datetime NOT NULL,
122 `dta_sale` datetime DEFAULT NULL
123) ENGINE=InnoDB DEFAULT CHARSET=utf8;
124
125-- --------------------------------------------------------
126
127--
128-- Estrutura da tabela `account_character_sale_history`
129--
130
131CREATE TABLE `account_character_sale_history` (
132 `id` int(11) NOT NULL,
133 `id_old_account` int(11) DEFAULT NULL,
134 `id_player` int(11) DEFAULT NULL,
135 `id_new_account` int(11) DEFAULT NULL,
136 `price_type` tinyint(1) DEFAULT NULL,
137 `price` int(11) DEFAULT NULL,
138 `char_id` int(11) DEFAULT NULL,
139 `dta_insert` datetime NOT NULL DEFAULT current_timestamp(),
140 `dta_sale` datetime DEFAULT NULL,
141 `extornada` tinyint(1) DEFAULT NULL
142) ENGINE=InnoDB DEFAULT CHARSET=utf8;
143
144-- --------------------------------------------------------
145
146--
147-- Estrutura da tabela `account_viplist`
148--
149
150CREATE TABLE `account_viplist` (
151 `account_id` int(11) NOT NULL COMMENT 'id of account whose viplist entry it is',
152 `player_id` int(11) NOT NULL COMMENT 'id of target player of viplist entry',
153 `description` varchar(128) NOT NULL DEFAULT '',
154 `icon` tinyint(2) UNSIGNED NOT NULL DEFAULT 0,
155 `notify` tinyint(1) NOT NULL DEFAULT 0
156) ENGINE=InnoDB DEFAULT CHARSET=latin1;
157
158-- --------------------------------------------------------
159
160--
161-- Estrutura da tabela `announcements`
162--
163
164CREATE TABLE `announcements` (
165 `id` int(10) NOT NULL,
166 `title` varchar(50) NOT NULL,
167 `text` varchar(255) NOT NULL,
168 `date` varchar(20) NOT NULL,
169 `author` varchar(50) NOT NULL
170) ENGINE=MyISAM DEFAULT CHARSET=latin1;
171
172-- --------------------------------------------------------
173
174--
175-- Estrutura da tabela `blessings_history`
176--
177
178CREATE TABLE `blessings_history` (
179 `id` int(11) NOT NULL,
180 `player_id` int(11) NOT NULL,
181 `blessing` tinyint(4) NOT NULL,
182 `loss` tinyint(1) NOT NULL,
183 `timestamp` int(11) NOT NULL
184) ENGINE=InnoDB DEFAULT CHARSET=latin1;
185
186-- --------------------------------------------------------
187
188--
189-- Estrutura da tabela `daily_reward_history`
190--
191
192CREATE TABLE `daily_reward_history` (
193 `id` int(11) NOT NULL,
194 `streak` smallint(2) NOT NULL DEFAULT 0,
195 `event` varchar(255) DEFAULT NULL,
196 `time` timestamp NOT NULL DEFAULT current_timestamp(),
197 `instant` tinyint(3) UNSIGNED NOT NULL DEFAULT 0,
198 `player_id` int(11) NOT NULL
199) ENGINE=InnoDB DEFAULT CHARSET=latin1;
200
201-- --------------------------------------------------------
202
203--
204-- Estrutura da tabela `global_storage`
205--
206
207CREATE TABLE `global_storage` (
208 `key` varchar(32) NOT NULL,
209 `value` text NOT NULL
210) ENGINE=InnoDB DEFAULT CHARSET=latin1;
211
212-- --------------------------------------------------------
213
214--
215-- Estrutura da tabela `guilds`
216--
217
218CREATE TABLE `guilds` (
219 `id` int(11) NOT NULL,
220 `name` varchar(255) NOT NULL,
221 `ownerid` int(11) NOT NULL,
222 `creationdata` int(11) NOT NULL,
223 `motd` varchar(255) NOT NULL DEFAULT '',
224 `description` text NOT NULL,
225 `guild_logo` mediumblob DEFAULT NULL,
226 `create_ip` int(11) NOT NULL DEFAULT 0,
227 `balance` bigint(20) UNSIGNED NOT NULL DEFAULT 0,
228 `last_execute_points` int(11) NOT NULL DEFAULT 0,
229 `logo_gfx_name` varchar(255) NOT NULL DEFAULT ''
230) ENGINE=InnoDB DEFAULT CHARSET=latin1;
231
232-- --------------------------------------------------------
233
234--
235-- Estrutura da tabela `guildwar_kills`
236--
237
238CREATE TABLE `guildwar_kills` (
239 `id` int(11) NOT NULL,
240 `killer` varchar(50) NOT NULL,
241 `target` varchar(50) NOT NULL,
242 `killerguild` int(11) NOT NULL DEFAULT 0,
243 `targetguild` int(11) NOT NULL DEFAULT 0,
244 `warid` int(11) NOT NULL DEFAULT 0,
245 `time` bigint(15) NOT NULL
246) ENGINE=InnoDB DEFAULT CHARSET=latin1;
247
248-- --------------------------------------------------------
249
250--
251-- Estrutura da tabela `guild_invites`
252--
253
254CREATE TABLE `guild_invites` (
255 `player_id` int(11) NOT NULL DEFAULT 0,
256 `guild_id` int(11) NOT NULL DEFAULT 0,
257 `date` int(11) NOT NULL
258) ENGINE=InnoDB DEFAULT CHARSET=latin1;
259
260-- --------------------------------------------------------
261
262--
263-- Estrutura da tabela `guild_membership`
264--
265
266CREATE TABLE `guild_membership` (
267 `player_id` int(11) NOT NULL,
268 `guild_id` int(11) NOT NULL,
269 `rank_id` int(11) NOT NULL,
270 `nick` varchar(15) NOT NULL DEFAULT ''
271) ENGINE=InnoDB DEFAULT CHARSET=latin1;
272
273-- --------------------------------------------------------
274
275--
276-- Estrutura da tabela `guild_ranks`
277--
278
279CREATE TABLE `guild_ranks` (
280 `id` int(11) NOT NULL,
281 `guild_id` int(11) NOT NULL COMMENT 'guild',
282 `name` varchar(255) NOT NULL COMMENT 'rank name',
283 `level` int(11) NOT NULL COMMENT 'rank level - leader, vice, member, maybe something else'
284) ENGINE=InnoDB DEFAULT CHARSET=latin1;
285
286-- --------------------------------------------------------
287
288--
289-- Estrutura da tabela `guild_wars`
290--
291
292CREATE TABLE `guild_wars` (
293 `id` int(11) NOT NULL,
294 `guild1` int(11) NOT NULL DEFAULT 0,
295 `guild2` int(11) NOT NULL DEFAULT 0,
296 `name1` varchar(255) NOT NULL,
297 `name2` varchar(255) NOT NULL,
298 `status` tinyint(2) NOT NULL DEFAULT 0,
299 `started` bigint(15) NOT NULL DEFAULT 0,
300 `ended` bigint(15) NOT NULL DEFAULT 0
301) ENGINE=InnoDB DEFAULT CHARSET=latin1;
302
303-- --------------------------------------------------------
304
305--
306-- Estrutura stand-in para vista `highscores`
307-- (Veja abaixo para a view atual)
308--
309CREATE TABLE `highscores` (
310`id` int(11)
311,`name` varchar(255)
312,`account_id` int(11)
313,`group_id` int(11) unsigned
314,`level` int(11)
315,`experience` bigint(20) unsigned
316,`vocation` varchar(15)
317,`rank` bigint(22)
318);
319
320-- --------------------------------------------------------
321
322--
323-- Estrutura da tabela `houses`
324--
325
326CREATE TABLE `houses` (
327 `id` int(11) NOT NULL,
328 `owner` int(11) NOT NULL,
329 `paid` int(10) UNSIGNED NOT NULL DEFAULT 0,
330 `warnings` int(11) NOT NULL DEFAULT 0,
331 `name` varchar(255) NOT NULL,
332 `rent` int(11) NOT NULL DEFAULT 0,
333 `town_id` int(11) NOT NULL DEFAULT 0,
334 `bid` int(11) NOT NULL DEFAULT 0,
335 `bid_end` int(11) NOT NULL DEFAULT 0,
336 `last_bid` int(11) NOT NULL DEFAULT 0,
337 `highest_bidder` int(11) NOT NULL DEFAULT 0,
338 `size` int(11) NOT NULL DEFAULT 0,
339 `beds` int(11) NOT NULL DEFAULT 0
340) ENGINE=InnoDB DEFAULT CHARSET=latin1;
341
342-- --------------------------------------------------------
343
344--
345-- Estrutura da tabela `house_lists`
346--
347
348CREATE TABLE `house_lists` (
349 `house_id` int(11) NOT NULL,
350 `listid` int(11) NOT NULL,
351 `list` text NOT NULL
352) ENGINE=InnoDB DEFAULT CHARSET=latin1;
353
354-- --------------------------------------------------------
355
356--
357-- Estrutura da tabela `ip_bans`
358--
359
360CREATE TABLE `ip_bans` (
361 `ip` int(10) UNSIGNED NOT NULL,
362 `reason` varchar(255) NOT NULL,
363 `banned_at` bigint(20) NOT NULL,
364 `expires_at` bigint(20) NOT NULL,
365 `banned_by` int(11) NOT NULL
366) ENGINE=InnoDB DEFAULT CHARSET=latin1;
367
368-- --------------------------------------------------------
369
370--
371-- Estrutura da tabela `live_casts`
372--
373
374CREATE TABLE `live_casts` (
375 `player_id` int(11) NOT NULL,
376 `cast_name` varchar(255) NOT NULL,
377 `password` tinyint(1) NOT NULL DEFAULT 0,
378 `description` varchar(255) DEFAULT NULL,
379 `spectators` smallint(5) DEFAULT 0
380) ENGINE=InnoDB DEFAULT CHARSET=latin1;
381
382-- --------------------------------------------------------
383
384--
385-- Estrutura da tabela `market_history`
386--
387
388CREATE TABLE `market_history` (
389 `id` int(10) UNSIGNED NOT NULL,
390 `player_id` int(11) NOT NULL,
391 `sale` tinyint(1) NOT NULL DEFAULT 0,
392 `itemtype` int(10) UNSIGNED NOT NULL,
393 `amount` smallint(5) UNSIGNED NOT NULL,
394 `price` int(10) UNSIGNED NOT NULL DEFAULT 0,
395 `expires_at` bigint(20) UNSIGNED NOT NULL,
396 `inserted` bigint(20) UNSIGNED NOT NULL,
397 `state` tinyint(1) UNSIGNED NOT NULL
398) ENGINE=InnoDB DEFAULT CHARSET=latin1;
399
400-- --------------------------------------------------------
401
402--
403-- Estrutura da tabela `market_offers`
404--
405
406CREATE TABLE `market_offers` (
407 `id` int(10) UNSIGNED NOT NULL,
408 `player_id` int(11) NOT NULL,
409 `sale` tinyint(1) NOT NULL DEFAULT 0,
410 `itemtype` int(10) UNSIGNED NOT NULL,
411 `amount` smallint(5) UNSIGNED NOT NULL,
412 `created` bigint(20) UNSIGNED NOT NULL,
413 `anonymous` tinyint(1) NOT NULL DEFAULT 0,
414 `price` int(10) UNSIGNED NOT NULL DEFAULT 0
415) ENGINE=InnoDB DEFAULT CHARSET=latin1;
416
417-- --------------------------------------------------------
418
419--
420-- Estrutura da tabela `newsticker`
421--
422
423CREATE TABLE `newsticker` (
424 `id` int(10) UNSIGNED NOT NULL,
425 `date` int(11) NOT NULL,
426 `text` varchar(255) NOT NULL,
427 `icon` varchar(50) NOT NULL
428) ENGINE=MyISAM DEFAULT CHARSET=latin1;
429
430-- --------------------------------------------------------
431
432--
433-- Estrutura da tabela `pagseguro`
434--
435
436CREATE TABLE `pagseguro` (
437 `date` datetime NOT NULL,
438 `code` varchar(50) NOT NULL,
439 `reference` varchar(200) NOT NULL,
440 `type` int(11) NOT NULL,
441 `status` int(11) NOT NULL,
442 `lastEventDate` datetime NOT NULL
443) ENGINE=MyISAM DEFAULT CHARSET=latin1;
444
445-- --------------------------------------------------------
446
447--
448-- Estrutura da tabela `pagseguro_transactions`
449--
450
451CREATE TABLE `pagseguro_transactions` (
452 `transaction_code` varchar(36) CHARACTER SET latin1 NOT NULL,
453 `name` varchar(200) CHARACTER SET latin1 DEFAULT NULL,
454 `payment_method` varchar(50) CHARACTER SET latin1 NOT NULL,
455 `status` varchar(50) CHARACTER SET latin1 NOT NULL,
456 `item_count` int(11) NOT NULL,
457 `data` datetime NOT NULL,
458 `payment_amount` float DEFAULT 0
459) ENGINE=MyISAM DEFAULT CHARSET=utf8;
460
461-- --------------------------------------------------------
462
463--
464-- Estrutura da tabela `paypal_transactions`
465--
466
467CREATE TABLE `paypal_transactions` (
468 `id` int(11) NOT NULL,
469 `payment_status` varchar(70) NOT NULL,
470 `payer_email` varchar(255) NOT NULL,
471 `payer_id` varchar(255) NOT NULL,
472 `item_number1` varchar(255) NOT NULL,
473 `mc_gross` float NOT NULL,
474 `mc_currency` varchar(5) NOT NULL,
475 `txn_id` varchar(255) NOT NULL
476) ENGINE=InnoDB DEFAULT CHARSET=utf8;
477
478-- --------------------------------------------------------
479
480--
481-- Estrutura da tabela `players`
482--
483
484CREATE TABLE `players` (
485 `id` int(11) NOT NULL,
486 `name` varchar(255) NOT NULL,
487 `group_id` int(11) UNSIGNED NOT NULL DEFAULT 1,
488 `account_id` int(11) NOT NULL DEFAULT 0,
489 `level` int(11) NOT NULL DEFAULT 1,
490 `vocation` int(11) NOT NULL DEFAULT 0,
491 `health` int(11) NOT NULL DEFAULT 150,
492 `healthmax` int(11) NOT NULL DEFAULT 150,
493 `experience` bigint(20) UNSIGNED NOT NULL DEFAULT 0,
494 `lookbody` int(11) NOT NULL DEFAULT 0,
495 `lookmount` int(11) NOT NULL DEFAULT 0,
496 `lookfeet` int(11) NOT NULL DEFAULT 0,
497 `lookhead` int(11) NOT NULL DEFAULT 0,
498 `looklegs` int(11) NOT NULL DEFAULT 0,
499 `looktype` int(11) UNSIGNED NOT NULL DEFAULT 136,
500 `lookaddons` int(11) NOT NULL DEFAULT 0,
501 `maglevel` int(11) NOT NULL DEFAULT 0,
502 `mana` int(11) NOT NULL DEFAULT 0,
503 `manamax` int(11) NOT NULL DEFAULT 0,
504 `manaspent` int(11) UNSIGNED NOT NULL DEFAULT 0,
505 `soul` int(10) UNSIGNED NOT NULL DEFAULT 0,
506 `town_id` int(11) UNSIGNED NOT NULL DEFAULT 0,
507 `posx` int(11) NOT NULL DEFAULT 0,
508 `posy` int(11) NOT NULL DEFAULT 0,
509 `posz` int(11) NOT NULL DEFAULT 0,
510 `conditions` blob NOT NULL,
511 `cap` int(11) NOT NULL DEFAULT 0,
512 `sex` int(11) NOT NULL DEFAULT 0,
513 `lastlogin` bigint(20) UNSIGNED NOT NULL DEFAULT 0,
514 `lastip` int(10) UNSIGNED NOT NULL DEFAULT 0,
515 `save` tinyint(1) NOT NULL DEFAULT 1,
516 `skull` tinyint(1) NOT NULL DEFAULT 0,
517 `skulltime` int(11) NOT NULL DEFAULT 0,
518 `lastlogout` bigint(20) UNSIGNED NOT NULL DEFAULT 0,
519 `blessings` tinyint(2) NOT NULL DEFAULT 0,
520 `blessings1` tinyint(4) NOT NULL DEFAULT 0,
521 `blessings2` tinyint(4) NOT NULL DEFAULT 0,
522 `blessings3` tinyint(4) NOT NULL DEFAULT 0,
523 `blessings4` tinyint(4) NOT NULL DEFAULT 0,
524 `blessings5` tinyint(4) NOT NULL DEFAULT 0,
525 `blessings6` tinyint(4) NOT NULL DEFAULT 0,
526 `blessings7` tinyint(4) NOT NULL DEFAULT 0,
527 `blessings8` tinyint(4) NOT NULL DEFAULT 0,
528 `onlinetime` int(11) NOT NULL DEFAULT 0,
529 `deletion` bigint(15) NOT NULL DEFAULT 0,
530 `balance` bigint(20) UNSIGNED NOT NULL DEFAULT 0,
531 `offlinetraining_time` smallint(5) UNSIGNED NOT NULL DEFAULT 43200,
532 `offlinetraining_skill` int(11) NOT NULL DEFAULT -1,
533 `stamina` smallint(5) UNSIGNED NOT NULL DEFAULT 2520,
534 `skill_fist` int(10) UNSIGNED NOT NULL DEFAULT 10,
535 `skill_fist_tries` bigint(20) UNSIGNED NOT NULL DEFAULT 0,
536 `skill_club` int(10) UNSIGNED NOT NULL DEFAULT 10,
537 `skill_club_tries` bigint(20) UNSIGNED NOT NULL DEFAULT 0,
538 `skill_sword` int(10) UNSIGNED NOT NULL DEFAULT 10,
539 `skill_sword_tries` bigint(20) UNSIGNED NOT NULL DEFAULT 0,
540 `skill_axe` int(10) UNSIGNED NOT NULL DEFAULT 10,
541 `skill_axe_tries` bigint(20) UNSIGNED NOT NULL DEFAULT 0,
542 `skill_dist` int(10) UNSIGNED NOT NULL DEFAULT 10,
543 `skill_dist_tries` bigint(20) UNSIGNED NOT NULL DEFAULT 0,
544 `skill_shielding` int(10) UNSIGNED NOT NULL DEFAULT 10,
545 `skill_shielding_tries` bigint(20) UNSIGNED NOT NULL DEFAULT 0,
546 `skill_fishing` int(10) UNSIGNED NOT NULL DEFAULT 10,
547 `skill_fishing_tries` bigint(20) UNSIGNED NOT NULL DEFAULT 0,
548 `deleted` tinyint(1) NOT NULL DEFAULT 0,
549 `description` varchar(255) NOT NULL DEFAULT '',
550 `comment` text NOT NULL,
551 `create_ip` int(11) UNSIGNED NOT NULL DEFAULT 0,
552 `create_date` int(11) UNSIGNED NOT NULL DEFAULT 0,
553 `hide_char` int(11) NOT NULL DEFAULT 0,
554 `cast` tinyint(1) NOT NULL DEFAULT 0,
555 `skill_critical_hit_chance` int(10) UNSIGNED NOT NULL DEFAULT 0,
556 `skill_critical_hit_chance_tries` bigint(20) UNSIGNED NOT NULL DEFAULT 0,
557 `skill_critical_hit_damage` int(10) UNSIGNED NOT NULL DEFAULT 0,
558 `skill_critical_hit_damage_tries` bigint(20) UNSIGNED NOT NULL DEFAULT 0,
559 `skill_life_leech_chance` int(10) UNSIGNED NOT NULL DEFAULT 0,
560 `skill_life_leech_chance_tries` bigint(20) UNSIGNED NOT NULL DEFAULT 0,
561 `skill_life_leech_amount` int(10) UNSIGNED NOT NULL DEFAULT 0,
562 `skill_life_leech_amount_tries` bigint(20) UNSIGNED NOT NULL DEFAULT 0,
563 `skill_mana_leech_chance` int(10) UNSIGNED NOT NULL DEFAULT 0,
564 `skill_mana_leech_chance_tries` bigint(20) UNSIGNED NOT NULL DEFAULT 0,
565 `skill_mana_leech_amount` int(10) UNSIGNED NOT NULL DEFAULT 0,
566 `skill_mana_leech_amount_tries` bigint(20) UNSIGNED NOT NULL DEFAULT 0,
567 `skill_criticalhit_chance` bigint(20) UNSIGNED NOT NULL DEFAULT 0,
568 `skill_criticalhit_damage` bigint(20) UNSIGNED NOT NULL DEFAULT 0,
569 `skill_lifeleech_chance` bigint(20) UNSIGNED NOT NULL DEFAULT 0,
570 `skill_lifeleech_amount` bigint(20) UNSIGNED NOT NULL DEFAULT 0,
571 `skill_manaleech_chance` bigint(20) UNSIGNED NOT NULL DEFAULT 0,
572 `skill_manaleech_amount` bigint(20) UNSIGNED NOT NULL DEFAULT 0,
573 `prey_stamina_1` int(11) DEFAULT NULL,
574 `prey_stamina_2` int(11) DEFAULT NULL,
575 `prey_stamina_3` int(11) DEFAULT NULL,
576 `prey_column` smallint(6) NOT NULL DEFAULT 1,
577 `xpboost_stamina` smallint(5) DEFAULT NULL,
578 `xpboost_value` tinyint(4) DEFAULT NULL,
579 `marriage_status` bigint(20) UNSIGNED NOT NULL DEFAULT 0,
580 `hide_skills` int(11) DEFAULT NULL,
581 `hide_set` int(11) DEFAULT NULL,
582 `former` varchar(255) NOT NULL DEFAULT '-',
583 `signature` varchar(255) NOT NULL,
584 `marriage_spouse` int(11) NOT NULL DEFAULT -1,
585 `loyalty_ranking` tinyint(1) NOT NULL DEFAULT 0,
586 `bonus_rerolls` bigint(20) NOT NULL DEFAULT 0,
587 `sbw_points` int(11) NOT NULL DEFAULT 0
588) ENGINE=InnoDB DEFAULT CHARSET=latin1;
589
590--
591-- Extraindo dados da tabela `players`
592--
593
594INSERT INTO `players` (`id`, `name`, `group_id`, `account_id`, `level`, `vocation`, `health`, `healthmax`, `experience`, `lookbody`, `lookmount`, `lookfeet`, `lookhead`, `looklegs`, `looktype`, `lookaddons`, `maglevel`, `mana`, `manamax`, `manaspent`, `soul`, `town_id`, `posx`, `posy`, `posz`, `conditions`, `cap`, `sex`, `lastlogin`, `lastip`, `save`, `skull`, `skulltime`, `lastlogout`, `blessings`, `blessings1`, `blessings2`, `blessings3`, `blessings4`, `blessings5`, `blessings6`, `blessings7`, `blessings8`, `onlinetime`, `deletion`, `balance`, `offlinetraining_time`, `offlinetraining_skill`, `stamina`, `skill_fist`, `skill_fist_tries`, `skill_club`, `skill_club_tries`, `skill_sword`, `skill_sword_tries`, `skill_axe`, `skill_axe_tries`, `skill_dist`, `skill_dist_tries`, `skill_shielding`, `skill_shielding_tries`, `skill_fishing`, `skill_fishing_tries`, `deleted`, `description`, `comment`, `create_ip`, `create_date`, `hide_char`, `cast`, `skill_critical_hit_chance`, `skill_critical_hit_chance_tries`, `skill_critical_hit_damage`, `skill_critical_hit_damage_tries`, `skill_life_leech_chance`, `skill_life_leech_chance_tries`, `skill_life_leech_amount`, `skill_life_leech_amount_tries`, `skill_mana_leech_chance`, `skill_mana_leech_chance_tries`, `skill_mana_leech_amount`, `skill_mana_leech_amount_tries`, `skill_criticalhit_chance`, `skill_criticalhit_damage`, `skill_lifeleech_chance`, `skill_lifeleech_amount`, `skill_manaleech_chance`, `skill_manaleech_amount`, `prey_stamina_1`, `prey_stamina_2`, `prey_stamina_3`, `prey_column`, `xpboost_stamina`, `xpboost_value`, `marriage_status`, `hide_skills`, `hide_set`, `former`, `signature`, `marriage_spouse`, `loyalty_ranking`, `bonus_rerolls`, `sbw_points`) VALUES
595(1, 'Rook Sample', 1, 1, 1, 0, 150, 150, 0, 106, 0, 95, 78, 116, 128, 0, 0, 5, 5, 0, 0, 6, 0, 0, 0, '', 400, 0, 1407021967, 1793873073, 1, 0, 0, 1407021968, 0, 0, 0, 0, 0, 0, 0, 0, 0, 203, 0, 0, 43200, -1, 2520, 10, 0, 10, 0, 10, 0, 10, 0, 10, 0, 10, 0, 10, 0, 0, '', '', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, NULL, NULL, NULL, 1, NULL, NULL, 0, NULL, NULL, '-', '', -1, 0, 0, 0);
596
597-- --------------------------------------------------------
598
599--
600-- Estrutura da tabela `players_online`
601--
602
603CREATE TABLE `players_online` (
604 `player_id` int(11) NOT NULL
605) ENGINE=MEMORY DEFAULT CHARSET=latin1;
606
607-- --------------------------------------------------------
608
609--
610-- Estrutura da tabela `player_autoloot`
611--
612
613CREATE TABLE `player_autoloot` (
614 `id` int(11) NOT NULL,
615 `player_id` int(11) NOT NULL,
616 `autoloot_list` blob DEFAULT NULL
617) ENGINE=InnoDB DEFAULT CHARSET=utf8;
618
619-- --------------------------------------------------------
620
621--
622-- Estrutura da tabela `player_autoloot_persist`
623--
624
625CREATE TABLE `player_autoloot_persist` (
626 `player_guid` mediumint(9) DEFAULT NULL,
627 `cont_id` mediumint(9) DEFAULT NULL,
628 `item_id` mediumint(9) DEFAULT NULL
629) ENGINE=InnoDB DEFAULT CHARSET=utf8;
630
631-- --------------------------------------------------------
632
633--
634-- Estrutura da tabela `player_charms`
635--
636
637CREATE TABLE `player_charms` (
638 `id` int(11) NOT NULL,
639 `player_id` int(11) NOT NULL,
640 `charm` varchar(20) DEFAULT NULL,
641 `monster` varchar(20) DEFAULT NULL
642) ENGINE=InnoDB DEFAULT CHARSET=latin1;
643
644-- --------------------------------------------------------
645
646--
647-- Estrutura da tabela `player_deaths`
648--
649
650CREATE TABLE `player_deaths` (
651 `player_id` int(11) NOT NULL,
652 `time` bigint(20) UNSIGNED NOT NULL DEFAULT 0,
653 `level` int(11) NOT NULL DEFAULT 1,
654 `killed_by` varchar(255) NOT NULL,
655 `is_player` tinyint(1) NOT NULL DEFAULT 1,
656 `mostdamage_by` varchar(100) NOT NULL,
657 `mostdamage_is_player` tinyint(1) NOT NULL DEFAULT 0,
658 `unjustified` tinyint(1) NOT NULL DEFAULT 0,
659 `mostdamage_unjustified` tinyint(1) NOT NULL DEFAULT 0
660) ENGINE=InnoDB DEFAULT CHARSET=latin1;
661
662-- --------------------------------------------------------
663
664--
665-- Estrutura da tabela `player_depotitems`
666--
667
668CREATE TABLE `player_depotitems` (
669 `player_id` int(11) NOT NULL,
670 `sid` int(11) NOT NULL COMMENT 'any given range eg 0-100 will be reserved for depot lockers and all > 100 will be then normal items inside depots',
671 `pid` int(11) NOT NULL DEFAULT 0,
672 `itemtype` smallint(6) NOT NULL,
673 `count` smallint(5) NOT NULL DEFAULT 0,
674 `attributes` blob NOT NULL
675) ENGINE=InnoDB DEFAULT CHARSET=latin1;
676
677-- --------------------------------------------------------
678
679--
680-- Estrutura da tabela `player_former_names`
681--
682
683CREATE TABLE `player_former_names` (
684 `id` int(11) NOT NULL,
685 `player_id` int(11) NOT NULL,
686 `former_name` varchar(35) NOT NULL,
687 `date` int(11) NOT NULL
688) ENGINE=InnoDB DEFAULT CHARSET=latin1;
689
690-- --------------------------------------------------------
691
692--
693-- Estrutura da tabela `player_inboxitems`
694--
695
696CREATE TABLE `player_inboxitems` (
697 `player_id` int(11) NOT NULL,
698 `sid` int(11) NOT NULL,
699 `pid` int(11) NOT NULL DEFAULT 0,
700 `itemtype` smallint(6) NOT NULL,
701 `count` smallint(5) NOT NULL DEFAULT 0,
702 `attributes` blob NOT NULL
703) ENGINE=InnoDB DEFAULT CHARSET=latin1;
704
705-- --------------------------------------------------------
706
707--
708-- Estrutura da tabela `player_items`
709--
710
711CREATE TABLE `player_items` (
712 `player_id` int(11) NOT NULL DEFAULT 0,
713 `pid` int(11) NOT NULL DEFAULT 0,
714 `sid` int(11) NOT NULL DEFAULT 0,
715 `itemtype` smallint(6) NOT NULL DEFAULT 0,
716 `count` smallint(5) NOT NULL DEFAULT 0,
717 `attributes` blob NOT NULL
718) ENGINE=InnoDB DEFAULT CHARSET=latin1;
719
720-- --------------------------------------------------------
721
722--
723-- Estrutura da tabela `player_kills`
724--
725
726CREATE TABLE `player_kills` (
727 `player_id` int(11) NOT NULL,
728 `time` bigint(20) UNSIGNED NOT NULL DEFAULT 0,
729 `target` int(11) NOT NULL,
730 `unavenged` tinyint(1) NOT NULL DEFAULT 0
731) ENGINE=InnoDB DEFAULT CHARSET=latin1;
732
733-- --------------------------------------------------------
734
735--
736-- Estrutura da tabela `player_misc`
737--
738
739CREATE TABLE `player_misc` (
740 `player_id` int(11) NOT NULL,
741 `info` blob NOT NULL
742) ENGINE=InnoDB DEFAULT CHARSET=latin1;
743
744-- --------------------------------------------------------
745
746--
747-- Estrutura da tabela `player_namelocks`
748--
749
750CREATE TABLE `player_namelocks` (
751 `player_id` int(11) NOT NULL,
752 `reason` varchar(255) NOT NULL,
753 `namelocked_at` bigint(20) NOT NULL,
754 `namelocked_by` int(11) NOT NULL
755) ENGINE=InnoDB DEFAULT CHARSET=latin1;
756
757-- --------------------------------------------------------
758
759--
760-- Estrutura da tabela `player_prey`
761--
762
763CREATE TABLE `player_prey` (
764 `player_id` int(11) NOT NULL,
765 `name` varchar(50) NOT NULL,
766 `mindex` smallint(6) NOT NULL,
767 `mcolumn` int(11) NOT NULL
768) ENGINE=InnoDB DEFAULT CHARSET=latin1;
769
770-- --------------------------------------------------------
771
772--
773-- Estrutura da tabela `player_preytimes`
774--
775
776CREATE TABLE `player_preytimes` (
777 `player_id` int(11) NOT NULL,
778 `bonus_type1` int(11) NOT NULL,
779 `bonus_value1` int(11) NOT NULL,
780 `bonus_name1` varchar(50) NOT NULL,
781 `bonus_type2` int(11) NOT NULL,
782 `bonus_value2` int(11) NOT NULL,
783 `bonus_name2` varchar(50) NOT NULL,
784 `bonus_type3` int(11) NOT NULL,
785 `bonus_value3` int(11) NOT NULL,
786 `bonus_name3` varchar(50) NOT NULL
787) ENGINE=InnoDB DEFAULT CHARSET=latin1;
788
789-- --------------------------------------------------------
790
791--
792-- Estrutura da tabela `player_rewards`
793--
794
795CREATE TABLE `player_rewards` (
796 `player_id` int(11) NOT NULL,
797 `sid` int(11) NOT NULL,
798 `pid` int(11) NOT NULL DEFAULT 0,
799 `itemtype` smallint(6) NOT NULL,
800 `count` smallint(5) NOT NULL DEFAULT 0,
801 `attributes` blob NOT NULL
802) ENGINE=InnoDB DEFAULT CHARSET=latin1;
803
804-- --------------------------------------------------------
805
806--
807-- Estrutura da tabela `player_spells`
808--
809
810CREATE TABLE `player_spells` (
811 `player_id` int(11) NOT NULL,
812 `name` varchar(255) NOT NULL
813) ENGINE=InnoDB DEFAULT CHARSET=latin1;
814
815-- --------------------------------------------------------
816
817--
818-- Estrutura da tabela `player_storage`
819--
820
821CREATE TABLE `player_storage` (
822 `player_id` int(11) NOT NULL DEFAULT 0,
823 `key` int(10) UNSIGNED NOT NULL DEFAULT 0,
824 `value` int(11) NOT NULL DEFAULT 0
825) ENGINE=InnoDB DEFAULT CHARSET=latin1;
826
827-- --------------------------------------------------------
828
829--
830-- Estrutura da tabela `prey_slots`
831--
832
833CREATE TABLE `prey_slots` (
834 `player_id` int(11) NOT NULL,
835 `num` smallint(2) NOT NULL,
836 `state` smallint(2) NOT NULL DEFAULT 1,
837 `unlocked` tinyint(1) NOT NULL DEFAULT 0,
838 `current` varchar(40) NOT NULL DEFAULT '',
839 `monster_list` varchar(360) NOT NULL,
840 `free_reroll_in` int(11) NOT NULL DEFAULT 0,
841 `time_left` smallint(5) NOT NULL DEFAULT 0,
842 `next_use` int(11) NOT NULL DEFAULT 0,
843 `bonus_type` smallint(3) NOT NULL,
844 `bonus_value` smallint(3) NOT NULL DEFAULT 0,
845 `bonus_grade` smallint(3) NOT NULL DEFAULT 0
846) ENGINE=InnoDB DEFAULT CHARSET=utf8;
847
848-- --------------------------------------------------------
849
850--
851-- Estrutura da tabela `server_config`
852--
853
854CREATE TABLE `server_config` (
855 `config` varchar(50) NOT NULL,
856 `value` varchar(256) NOT NULL DEFAULT ''
857) ENGINE=InnoDB DEFAULT CHARSET=latin1;
858
859--
860-- Extraindo dados da tabela `server_config`
861--
862
863INSERT INTO `server_config` (`config`, `value`) VALUES
864('db_version', '0'),
865('double', 'desactived'),
866('motd_hash', '78fd246b3e4ccbc75deaf0e956ae3ff2f835a7e8'),
867('motd_num', '0'),
868('players_record', '0');
869
870-- --------------------------------------------------------
871
872--
873-- Estrutura da tabela `snowballwar`
874--
875
876CREATE TABLE `snowballwar` (
877 `id` int(11) NOT NULL,
878 `name` varchar(255) NOT NULL,
879 `score` int(11) NOT NULL,
880 `data` varchar(255) NOT NULL,
881 `hora` varchar(255) NOT NULL
882) ENGINE=MyISAM DEFAULT CHARSET=latin1;
883
884-- --------------------------------------------------------
885
886--
887-- Estrutura da tabela `store_history`
888--
889
890CREATE TABLE `store_history` (
891 `account_id` int(11) NOT NULL,
892 `mode` smallint(2) NOT NULL DEFAULT 0,
893 `description` varchar(3500) NOT NULL,
894 `coin_amount` int(12) NOT NULL,
895 `time` bigint(20) UNSIGNED NOT NULL,
896 `timestamp` int(11) NOT NULL DEFAULT 0,
897 `id` int(11) NOT NULL,
898 `coins` int(11) NOT NULL DEFAULT 0
899) ENGINE=InnoDB DEFAULT CHARSET=latin1;
900
901-- --------------------------------------------------------
902
903--
904-- Estrutura da tabela `tickets`
905--
906
907CREATE TABLE `tickets` (
908 `ticket_id` int(11) NOT NULL,
909 `ticket_subject` varchar(45) NOT NULL,
910 `ticket_author` varchar(255) NOT NULL,
911 `ticket_author_acc_id` int(11) NOT NULL,
912 `ticket_last_reply` varchar(45) NOT NULL,
913 `ticket_admin_reply` int(11) NOT NULL,
914 `ticket_date` datetime NOT NULL,
915 `ticket_ended` varchar(45) NOT NULL,
916 `ticket_status` varchar(45) NOT NULL,
917 `ticket_category` varchar(45) NOT NULL,
918 `ticket_description` text NOT NULL
919) ENGINE=InnoDB DEFAULT CHARSET=utf8;
920
921-- --------------------------------------------------------
922
923--
924-- Estrutura da tabela `tickets_reply`
925--
926
927CREATE TABLE `tickets_reply` (
928 `ticket_replyid` int(11) NOT NULL,
929 `ticket_id` int(11) NOT NULL,
930 `reply_author` varchar(255) DEFAULT NULL,
931 `reply_message` text DEFAULT NULL,
932 `reply_date` datetime DEFAULT NULL
933) ENGINE=InnoDB DEFAULT CHARSET=utf8;
934
935-- --------------------------------------------------------
936
937--
938-- Estrutura da tabela `tile_store`
939--
940
941CREATE TABLE `tile_store` (
942 `house_id` int(11) NOT NULL,
943 `data` longblob NOT NULL
944) ENGINE=InnoDB DEFAULT CHARSET=latin1;
945
946-- --------------------------------------------------------
947
948--
949-- Estrutura da tabela `z_changelogs`
950--
951
952CREATE TABLE `z_changelogs` (
953 `id_changelog` int(11) UNSIGNED NOT NULL,
954 `date` date NOT NULL,
955 `description` text NOT NULL,
956 `is_active` tinyint(1) NOT NULL DEFAULT 1
957) ENGINE=InnoDB DEFAULT CHARSET=utf8;
958
959-- --------------------------------------------------------
960
961--
962-- Estrutura da tabela `z_forum`
963--
964
965CREATE TABLE `z_forum` (
966 `id` int(11) NOT NULL,
967 `first_post` int(11) NOT NULL DEFAULT 0,
968 `last_post` int(11) NOT NULL DEFAULT 0,
969 `section` int(3) NOT NULL DEFAULT 0,
970 `replies` int(20) NOT NULL DEFAULT 0,
971 `views` int(20) NOT NULL DEFAULT 0,
972 `author_aid` int(20) NOT NULL DEFAULT 0,
973 `author_guid` int(20) NOT NULL DEFAULT 0,
974 `post_text` text NOT NULL,
975 `post_topic` varchar(255) NOT NULL,
976 `post_smile` tinyint(1) NOT NULL DEFAULT 0,
977 `post_date` int(20) NOT NULL DEFAULT 0,
978 `last_edit_aid` int(20) NOT NULL DEFAULT 0,
979 `edit_date` int(20) NOT NULL DEFAULT 0,
980 `post_ip` varchar(15) NOT NULL DEFAULT '0.0.0.0',
981 `icon_id` int(11) NOT NULL,
982 `news_icon` varchar(50) NOT NULL
983) ENGINE=InnoDB DEFAULT CHARSET=latin1;
984
985-- --------------------------------------------------------
986
987--
988-- Estrutura da tabela `z_network_box`
989--
990
991CREATE TABLE `z_network_box` (
992 `id` int(11) NOT NULL,
993 `network_name` varchar(10) NOT NULL,
994 `network_link` varchar(50) NOT NULL
995) ENGINE=MyISAM DEFAULT CHARSET=latin1;
996
997-- --------------------------------------------------------
998
999--
1000-- Estrutura da tabela `z_news_tickers`
1001--
1002
1003CREATE TABLE `z_news_tickers` (
1004 `date` int(11) NOT NULL DEFAULT 1,
1005 `author` int(11) NOT NULL,
1006 `image_id` int(3) NOT NULL DEFAULT 0,
1007 `text` text NOT NULL,
1008 `hide_ticker` tinyint(1) NOT NULL
1009) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1010
1011-- --------------------------------------------------------
1012
1013--
1014-- Estrutura da tabela `z_ots_comunication`
1015--
1016
1017CREATE TABLE `z_ots_comunication` (
1018 `id` int(11) NOT NULL,
1019 `name` varchar(255) NOT NULL,
1020 `type` varchar(255) NOT NULL,
1021 `action` varchar(255) NOT NULL,
1022 `param1` varchar(255) NOT NULL,
1023 `param2` varchar(255) NOT NULL,
1024 `param3` varchar(255) NOT NULL,
1025 `param4` varchar(255) NOT NULL,
1026 `param5` varchar(255) NOT NULL,
1027 `param6` varchar(255) NOT NULL,
1028 `param7` varchar(255) NOT NULL,
1029 `delete_it` int(2) NOT NULL DEFAULT 1
1030) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1031
1032-- --------------------------------------------------------
1033
1034--
1035-- Estrutura da tabela `z_ots_guildcomunication`
1036--
1037
1038CREATE TABLE `z_ots_guildcomunication` (
1039 `id` int(11) NOT NULL,
1040 `name` varchar(255) NOT NULL,
1041 `type` varchar(255) NOT NULL,
1042 `action` varchar(255) NOT NULL,
1043 `param1` varchar(255) NOT NULL,
1044 `param2` varchar(255) NOT NULL,
1045 `param3` varchar(255) NOT NULL,
1046 `param4` varchar(255) NOT NULL,
1047 `param5` varchar(255) NOT NULL,
1048 `param6` varchar(255) NOT NULL,
1049 `param7` varchar(255) NOT NULL,
1050 `delete_it` int(2) NOT NULL DEFAULT 1
1051) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1052
1053-- --------------------------------------------------------
1054
1055--
1056-- Estrutura da tabela `z_polls`
1057--
1058
1059CREATE TABLE `z_polls` (
1060 `id` int(11) NOT NULL,
1061 `question` varchar(255) NOT NULL,
1062 `end` int(11) NOT NULL,
1063 `start` int(11) NOT NULL,
1064 `answers` int(11) NOT NULL,
1065 `votes_all` int(11) NOT NULL
1066) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1067
1068-- --------------------------------------------------------
1069
1070--
1071-- Estrutura da tabela `z_polls_answers`
1072--
1073
1074CREATE TABLE `z_polls_answers` (
1075 `poll_id` int(11) NOT NULL,
1076 `answer_id` int(11) NOT NULL,
1077 `answer` varchar(255) NOT NULL,
1078 `votes` int(11) NOT NULL
1079) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1080
1081-- --------------------------------------------------------
1082
1083--
1084-- Estrutura da tabela `z_shop_category`
1085--
1086
1087CREATE TABLE `z_shop_category` (
1088 `id` int(11) NOT NULL,
1089 `name` varchar(50) NOT NULL,
1090 `desc` varchar(255) NOT NULL,
1091 `button` varchar(50) NOT NULL,
1092 `hide` int(11) NOT NULL DEFAULT 0
1093) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1094
1095--
1096-- Extraindo dados da tabela `z_shop_category`
1097--
1098
1099INSERT INTO `z_shop_category` (`id`, `name`, `desc`, `button`, `hide`) VALUES
1100(2, 'Extra Services', 'Buy an extra service to transfer a character to another game world, to change your character name or sex, to change your account name, or to get a new recovery key.', '_sbutton_getextraservice.gif', 1),
1101(3, 'Mounts', 'Buy your characters one or more of the fabulous mounts offered here.', '_sbutton_getmount.gif', 1),
1102(4, 'Outfits', 'Buy your characters one or more of the fancy outfits offered here.', '_sbutton_getoutfit.gif', 1),
1103(5, 'Items', 'Buy items for your character be more stronger in the game.', '_sbutton_getextraservice.gif', 1);
1104
1105-- --------------------------------------------------------
1106
1107--
1108-- Estrutura da tabela `z_shop_donates`
1109--
1110
1111CREATE TABLE `z_shop_donates` (
1112 `id` int(11) UNSIGNED NOT NULL,
1113 `date` int(11) NOT NULL,
1114 `reference` varchar(50) NOT NULL,
1115 `account_name` varchar(50) NOT NULL,
1116 `method` varchar(50) NOT NULL,
1117 `price` varchar(20) NOT NULL,
1118 `coins` int(11) NOT NULL,
1119 `status` varchar(20) NOT NULL
1120) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1121
1122-- --------------------------------------------------------
1123
1124--
1125-- Estrutura da tabela `z_shop_donate_confirm`
1126--
1127
1128CREATE TABLE `z_shop_donate_confirm` (
1129 `id` int(11) NOT NULL,
1130 `date` int(11) NOT NULL,
1131 `account_name` varchar(50) NOT NULL,
1132 `donate_id` int(11) NOT NULL,
1133 `msg` text NOT NULL
1134) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1135
1136-- --------------------------------------------------------
1137
1138--
1139-- Estrutura da tabela `z_shop_history_item`
1140--
1141
1142CREATE TABLE `z_shop_history_item` (
1143 `id` int(11) NOT NULL,
1144 `to_name` varchar(255) NOT NULL DEFAULT '0',
1145 `to_account` int(11) NOT NULL DEFAULT 0,
1146 `from_nick` varchar(255) NOT NULL,
1147 `from_account` int(11) NOT NULL DEFAULT 0,
1148 `price` int(11) NOT NULL DEFAULT 0,
1149 `offer_id` varchar(255) NOT NULL DEFAULT '',
1150 `trans_state` varchar(255) NOT NULL,
1151 `trans_start` int(11) NOT NULL DEFAULT 0,
1152 `trans_real` int(11) NOT NULL DEFAULT 0
1153) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1154
1155-- --------------------------------------------------------
1156
1157--
1158-- Estrutura da tabela `z_shop_offer`
1159--
1160
1161CREATE TABLE `z_shop_offer` (
1162 `id` int(11) NOT NULL,
1163 `category` int(11) NOT NULL,
1164 `coins` int(11) NOT NULL DEFAULT 0,
1165 `price` varchar(50) NOT NULL,
1166 `itemid` int(11) NOT NULL DEFAULT 0,
1167 `mount_id` varchar(100) NOT NULL,
1168 `addon_name` varchar(100) NOT NULL,
1169 `count` int(11) NOT NULL DEFAULT 0,
1170 `offer_type` varchar(255) DEFAULT NULL,
1171 `offer_description` text NOT NULL,
1172 `offer_name` varchar(255) NOT NULL,
1173 `offer_date` int(11) NOT NULL,
1174 `default_image` varchar(50) NOT NULL,
1175 `hide` int(11) NOT NULL DEFAULT 0
1176) ENGINE=InnoDB DEFAULT CHARSET=latin1;
1177
1178--
1179-- Extraindo dados da tabela `z_shop_offer`
1180--
1181
1182INSERT INTO `z_shop_offer` (`id`, `category`, `coins`, `price`, `itemid`, `mount_id`, `addon_name`, `count`, `offer_type`, `offer_description`, `offer_name`, `offer_date`, `default_image`, `hide`) VALUES
1183(5, 2, 250, '', 0, '', '', 1, 'changename', 'Buy a character name change to rename one of your characters.', 'Character Change Name', 1416865577, 'changename.png', 0),
1184(6, 2, 10, '', 0, '', '', 1, 'changesex', 'Buy a character sex change to turn your male character into a female one, or your female character into a male one.', 'Character Change Sex', 1416874417, 'changesex.png', 1),
1185(7, 2, 250, '', 0, '', '', 1, 'changeaccountname', 'Buy an account name change to select a different name for your account.', 'Account Name Change', 1416874601, 'changeaccountname.png', 0),
1186(8, 2, 300, '', 0, '', '', 1, 'newrk', 'If you need a new recovery key, you can order it here. Note that the letter for the new recovery key can only be sent to the address in the account registration.', 'Recovery Key', 1416874816, 'newrk.png', 0);
1187
1188-- --------------------------------------------------------
1189
1190--
1191-- Estrutura da tabela `z_shop_payment`
1192--
1193
1194CREATE TABLE `z_shop_payment` (
1195 `id` int(11) NOT NULL,
1196 `ref` varchar(10) NOT NULL,
1197 `account_name` varchar(50) NOT NULL,
1198 `service_id` int(11) NOT NULL,
1199 `service_category_id` int(11) NOT NULL,
1200 `payment_method_id` int(11) NOT NULL,
1201 `price` varchar(50) NOT NULL,
1202 `coins` int(11) UNSIGNED NOT NULL,
1203 `status` varchar(50) NOT NULL DEFAULT 'waiting',
1204 `date` int(11) NOT NULL,
1205 `gift` int(11) NOT NULL DEFAULT 0
1206) ENGINE=MyISAM DEFAULT CHARSET=latin1;
1207
1208-- --------------------------------------------------------
1209
1210--
1211-- Estrutura para vista `highscores`
1212--
1213DROP TABLE IF EXISTS `highscores`;
1214
1215CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `highscores` AS select `p`.`id` AS `id`,`p`.`name` AS `name`,`p`.`account_id` AS `account_id`,`p`.`group_id` AS `group_id`,`p`.`level` AS `level`,`p`.`experience` AS `experience`,if(`p`.`vocation` = '0','No Vocation',if(`p`.`vocation` = '1','Sorcerer',if(`p`.`vocation` = '2','Druid',if(`p`.`vocation` = '3','Paladin',if(`p`.`vocation` = '4','Knight',if(`p`.`vocation` = '5','Master Sorcerer',if(`p`.`vocation` = '6','Elder Druid',if(`p`.`vocation` = '7','Royal Paladin',if(`p`.`vocation` = '8','Elite Knight','No Vocation'))))))))) AS `vocation`,(select count(0) from `players` where `p`.`experience` < `players`.`experience`) + 1 AS `rank` from `players` `p` where `p`.`account_id` <> 1 and `p`.`group_id` <> 5 order by `p`.`level` desc ;
1216
1217--
1218-- Índices para tabelas despejadas
1219--
1220
1221--
1222-- Índices para tabela `accounts`
1223--
1224ALTER TABLE `accounts`
1225 ADD PRIMARY KEY (`id`),
1226 ADD UNIQUE KEY `name` (`name`),
1227 ADD UNIQUE KEY `name_2` (`name`),
1228 ADD UNIQUE KEY `name_3` (`name`);
1229
1230--
1231-- Índices para tabela `account_bans`
1232--
1233ALTER TABLE `account_bans`
1234 ADD PRIMARY KEY (`account_id`),
1235 ADD KEY `banned_by` (`banned_by`);
1236
1237--
1238-- Índices para tabela `account_ban_history`
1239--
1240ALTER TABLE `account_ban_history`
1241 ADD PRIMARY KEY (`id`),
1242 ADD KEY `account_id` (`account_id`),
1243 ADD KEY `banned_by` (`banned_by`),
1244 ADD KEY `account_id_2` (`account_id`),
1245 ADD KEY `account_id_3` (`account_id`),
1246 ADD KEY `account_id_4` (`account_id`),
1247 ADD KEY `account_id_5` (`account_id`);
1248
1249--
1250-- Índices para tabela `account_character_sale`
1251--
1252ALTER TABLE `account_character_sale`
1253 ADD PRIMARY KEY (`id`),
1254 ADD UNIQUE KEY `id_player_UNIQUE` (`id_player`);
1255
1256--
1257-- Índices para tabela `account_character_sale_history`
1258--
1259ALTER TABLE `account_character_sale_history`
1260 ADD PRIMARY KEY (`id`),
1261 ADD KEY `id_old_acc_idx` (`id_old_account`),
1262 ADD KEY `id_new_acc_idx` (`id_new_account`),
1263 ADD KEY `id_player_idx` (`id_player`);
1264
1265--
1266-- Índices para tabela `account_viplist`
1267--
1268ALTER TABLE `account_viplist`
1269 ADD UNIQUE KEY `account_player_index` (`account_id`,`player_id`),
1270 ADD KEY `account_id` (`account_id`),
1271 ADD KEY `player_id` (`player_id`);
1272
1273--
1274-- Índices para tabela `daily_reward_history`
1275--
1276ALTER TABLE `daily_reward_history`
1277 ADD PRIMARY KEY (`id`),
1278 ADD KEY `player_id` (`player_id`);
1279
1280--
1281-- Índices para tabela `global_storage`
1282--
1283ALTER TABLE `global_storage`
1284 ADD UNIQUE KEY `key` (`key`);
1285
1286--
1287-- Índices para tabela `guilds`
1288--
1289ALTER TABLE `guilds`
1290 ADD PRIMARY KEY (`id`),
1291 ADD UNIQUE KEY `name` (`name`),
1292 ADD UNIQUE KEY `ownerid` (`ownerid`);
1293
1294--
1295-- Índices para tabela `guildwar_kills`
1296--
1297ALTER TABLE `guildwar_kills`
1298 ADD PRIMARY KEY (`id`),
1299 ADD KEY `warid` (`warid`);
1300
1301--
1302-- Índices para tabela `guild_invites`
1303--
1304ALTER TABLE `guild_invites`
1305 ADD PRIMARY KEY (`player_id`,`guild_id`),
1306 ADD KEY `guild_id` (`guild_id`);
1307
1308--
1309-- Índices para tabela `guild_membership`
1310--
1311ALTER TABLE `guild_membership`
1312 ADD PRIMARY KEY (`player_id`),
1313 ADD KEY `guild_id` (`guild_id`),
1314 ADD KEY `rank_id` (`rank_id`);
1315
1316--
1317-- Índices para tabela `guild_ranks`
1318--
1319ALTER TABLE `guild_ranks`
1320 ADD PRIMARY KEY (`id`),
1321 ADD KEY `guild_id` (`guild_id`);
1322
1323--
1324-- Índices para tabela `guild_wars`
1325--
1326ALTER TABLE `guild_wars`
1327 ADD PRIMARY KEY (`id`),
1328 ADD KEY `guild1` (`guild1`),
1329 ADD KEY `guild2` (`guild2`);
1330
1331--
1332-- Índices para tabela `houses`
1333--
1334ALTER TABLE `houses`
1335 ADD PRIMARY KEY (`id`),
1336 ADD KEY `owner` (`owner`),
1337 ADD KEY `town_id` (`town_id`);
1338
1339--
1340-- Índices para tabela `house_lists`
1341--
1342ALTER TABLE `house_lists`
1343 ADD KEY `house_id` (`house_id`);
1344
1345--
1346-- Índices para tabela `ip_bans`
1347--
1348ALTER TABLE `ip_bans`
1349 ADD PRIMARY KEY (`ip`),
1350 ADD KEY `banned_by` (`banned_by`);
1351
1352--
1353-- Índices para tabela `live_casts`
1354--
1355ALTER TABLE `live_casts`
1356 ADD UNIQUE KEY `player_id_2` (`player_id`);
1357
1358--
1359-- Índices para tabela `market_history`
1360--
1361ALTER TABLE `market_history`
1362 ADD PRIMARY KEY (`id`),
1363 ADD KEY `player_id` (`player_id`,`sale`);
1364
1365--
1366-- Índices para tabela `market_offers`
1367--
1368ALTER TABLE `market_offers`
1369 ADD PRIMARY KEY (`id`),
1370 ADD KEY `sale` (`sale`,`itemtype`),
1371 ADD KEY `created` (`created`),
1372 ADD KEY `player_id` (`player_id`);
1373
1374--
1375-- Índices para tabela `newsticker`
1376--
1377ALTER TABLE `newsticker`
1378 ADD PRIMARY KEY (`id`);
1379
1380--
1381-- Índices para tabela `pagseguro_transactions`
1382--
1383ALTER TABLE `pagseguro_transactions`
1384 ADD UNIQUE KEY `transaction_code` (`transaction_code`,`status`),
1385 ADD KEY `name` (`name`),
1386 ADD KEY `status` (`status`);
1387
1388--
1389-- Índices para tabela `paypal_transactions`
1390--
1391ALTER TABLE `paypal_transactions`
1392 ADD PRIMARY KEY (`id`);
1393
1394--
1395-- Índices para tabela `players`
1396--
1397ALTER TABLE `players`
1398 ADD PRIMARY KEY (`id`),
1399 ADD UNIQUE KEY `name` (`name`),
1400 ADD KEY `account_id` (`account_id`),
1401 ADD KEY `vocation` (`vocation`);
1402
1403--
1404-- Índices para tabela `players_online`
1405--
1406ALTER TABLE `players_online`
1407 ADD PRIMARY KEY (`player_id`);
1408
1409--
1410-- Índices para tabela `player_autoloot`
1411--
1412ALTER TABLE `player_autoloot`
1413 ADD PRIMARY KEY (`id`);
1414
1415--
1416-- Índices para tabela `player_deaths`
1417--
1418ALTER TABLE `player_deaths`
1419 ADD KEY `player_id` (`player_id`),
1420 ADD KEY `killed_by` (`killed_by`),
1421 ADD KEY `mostdamage_by` (`mostdamage_by`);
1422
1423--
1424-- Índices para tabela `player_depotitems`
1425--
1426ALTER TABLE `player_depotitems`
1427 ADD UNIQUE KEY `player_id_2` (`player_id`,`sid`);
1428
1429--
1430-- Índices para tabela `player_former_names`
1431--
1432ALTER TABLE `player_former_names`
1433 ADD PRIMARY KEY (`id`),
1434 ADD KEY `player_id` (`player_id`);
1435
1436--
1437-- Índices para tabela `player_inboxitems`
1438--
1439ALTER TABLE `player_inboxitems`
1440 ADD UNIQUE KEY `player_id_2` (`player_id`,`sid`);
1441
1442--
1443-- Índices para tabela `player_items`
1444--
1445ALTER TABLE `player_items`
1446 ADD KEY `player_id` (`player_id`),
1447 ADD KEY `sid` (`sid`);
1448
1449--
1450-- Índices para tabela `player_namelocks`
1451--
1452ALTER TABLE `player_namelocks`
1453 ADD PRIMARY KEY (`player_id`),
1454 ADD KEY `namelocked_by` (`namelocked_by`);
1455
1456--
1457-- Índices para tabela `player_rewards`
1458--
1459ALTER TABLE `player_rewards`
1460 ADD UNIQUE KEY `player_id_2` (`player_id`,`sid`);
1461
1462--
1463-- Índices para tabela `player_spells`
1464--
1465ALTER TABLE `player_spells`
1466 ADD KEY `player_id` (`player_id`);
1467
1468--
1469-- Índices para tabela `player_storage`
1470--
1471ALTER TABLE `player_storage`
1472 ADD PRIMARY KEY (`player_id`,`key`);
1473
1474--
1475-- Índices para tabela `prey_slots`
1476--
1477ALTER TABLE `prey_slots`
1478 ADD KEY `player_id` (`player_id`);
1479
1480--
1481-- Índices para tabela `server_config`
1482--
1483ALTER TABLE `server_config`
1484 ADD PRIMARY KEY (`config`);
1485
1486--
1487-- Índices para tabela `snowballwar`
1488--
1489ALTER TABLE `snowballwar`
1490 ADD PRIMARY KEY (`id`),
1491 ADD KEY `id` (`id`);
1492
1493--
1494-- Índices para tabela `store_history`
1495--
1496ALTER TABLE `store_history`
1497 ADD KEY `account_id` (`account_id`);
1498
1499--
1500-- Índices para tabela `tickets`
1501--
1502ALTER TABLE `tickets`
1503 ADD PRIMARY KEY (`ticket_id`),
1504 ADD KEY `tickets_ibfk_1_idx` (`ticket_author_acc_id`);
1505
1506--
1507-- Índices para tabela `tickets_reply`
1508--
1509ALTER TABLE `tickets_reply`
1510 ADD PRIMARY KEY (`ticket_replyid`),
1511 ADD KEY `ticket_id_idx` (`ticket_id`);
1512
1513--
1514-- Índices para tabela `tile_store`
1515--
1516ALTER TABLE `tile_store`
1517 ADD KEY `house_id` (`house_id`);
1518
1519--
1520-- Índices para tabela `z_changelogs`
1521--
1522ALTER TABLE `z_changelogs`
1523 ADD PRIMARY KEY (`id_changelog`);
1524
1525--
1526-- Índices para tabela `z_forum`
1527--
1528ALTER TABLE `z_forum`
1529 ADD PRIMARY KEY (`id`),
1530 ADD KEY `section` (`section`);
1531
1532--
1533-- Índices para tabela `z_ots_comunication`
1534--
1535ALTER TABLE `z_ots_comunication`
1536 ADD PRIMARY KEY (`id`);
1537
1538--
1539-- Índices para tabela `z_ots_guildcomunication`
1540--
1541ALTER TABLE `z_ots_guildcomunication`
1542 ADD PRIMARY KEY (`id`);
1543
1544--
1545-- AUTO_INCREMENT de tabelas despejadas
1546--
1547
1548--
1549-- AUTO_INCREMENT de tabela `accounts`
1550--
1551ALTER TABLE `accounts`
1552 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;
1553
1554--
1555-- AUTO_INCREMENT de tabela `account_ban_history`
1556--
1557ALTER TABLE `account_ban_history`
1558 MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
1559
1560--
1561-- AUTO_INCREMENT de tabela `account_character_sale`
1562--
1563ALTER TABLE `account_character_sale`
1564 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
1565
1566--
1567-- AUTO_INCREMENT de tabela `account_character_sale_history`
1568--
1569ALTER TABLE `account_character_sale_history`
1570 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
1571
1572--
1573-- AUTO_INCREMENT de tabela `daily_reward_history`
1574--
1575ALTER TABLE `daily_reward_history`
1576 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
1577
1578--
1579-- AUTO_INCREMENT de tabela `guilds`
1580--
1581ALTER TABLE `guilds`
1582 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
1583
1584--
1585-- AUTO_INCREMENT de tabela `guildwar_kills`
1586--
1587ALTER TABLE `guildwar_kills`
1588 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
1589
1590--
1591-- AUTO_INCREMENT de tabela `guild_ranks`
1592--
1593ALTER TABLE `guild_ranks`
1594 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
1595
1596--
1597-- AUTO_INCREMENT de tabela `guild_wars`
1598--
1599ALTER TABLE `guild_wars`
1600 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
1601
1602--
1603-- AUTO_INCREMENT de tabela `houses`
1604--
1605ALTER TABLE `houses`
1606 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2492;
1607
1608--
1609-- AUTO_INCREMENT de tabela `market_history`
1610--
1611ALTER TABLE `market_history`
1612 MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
1613
1614--
1615-- AUTO_INCREMENT de tabela `market_offers`
1616--
1617ALTER TABLE `market_offers`
1618 MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
1619
1620--
1621-- AUTO_INCREMENT de tabela `newsticker`
1622--
1623ALTER TABLE `newsticker`
1624 MODIFY `id` int(10) UNSIGNED NOT NULL AUTO_INCREMENT;
1625
1626--
1627-- AUTO_INCREMENT de tabela `paypal_transactions`
1628--
1629ALTER TABLE `paypal_transactions`
1630 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
1631
1632--
1633-- AUTO_INCREMENT de tabela `players`
1634--
1635ALTER TABLE `players`
1636 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;
1637
1638--
1639-- AUTO_INCREMENT de tabela `player_autoloot`
1640--
1641ALTER TABLE `player_autoloot`
1642 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
1643
1644--
1645-- AUTO_INCREMENT de tabela `player_former_names`
1646--
1647ALTER TABLE `player_former_names`
1648 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
1649
1650--
1651-- AUTO_INCREMENT de tabela `snowballwar`
1652--
1653ALTER TABLE `snowballwar`
1654 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
1655
1656--
1657-- AUTO_INCREMENT de tabela `tickets`
1658--
1659ALTER TABLE `tickets`
1660 MODIFY `ticket_id` int(11) NOT NULL AUTO_INCREMENT;
1661
1662--
1663-- AUTO_INCREMENT de tabela `tickets_reply`
1664--
1665ALTER TABLE `tickets_reply`
1666 MODIFY `ticket_replyid` int(11) NOT NULL AUTO_INCREMENT;
1667
1668--
1669-- AUTO_INCREMENT de tabela `z_changelogs`
1670--
1671ALTER TABLE `z_changelogs`
1672 MODIFY `id_changelog` int(11) UNSIGNED NOT NULL AUTO_INCREMENT;
1673
1674--
1675-- AUTO_INCREMENT de tabela `z_forum`
1676--
1677ALTER TABLE `z_forum`
1678 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
1679
1680--
1681-- AUTO_INCREMENT de tabela `z_ots_comunication`
1682--
1683ALTER TABLE `z_ots_comunication`
1684 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT;
1685
1686--
1687-- AUTO_INCREMENT de tabela `z_ots_guildcomunication`
1688--
1689ALTER TABLE `z_ots_guildcomunication`
1690 MODIFY `id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13382;
1691
1692--
1693-- Restrições para despejos de tabelas
1694--
1695
1696--
1697-- Limitadores para a tabela `account_bans`
1698--
1699ALTER TABLE `account_bans`
1700 ADD CONSTRAINT `account_bans_ibfk_1` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
1701 ADD CONSTRAINT `account_bans_ibfk_2` FOREIGN KEY (`banned_by`) REFERENCES `players` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
1702
1703--
1704-- Limitadores para a tabela `account_ban_history`
1705--
1706ALTER TABLE `account_ban_history`
1707 ADD CONSTRAINT `account_ban_history_ibfk_2` FOREIGN KEY (`banned_by`) REFERENCES `players` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
1708 ADD CONSTRAINT `account_ban_history_ibfk_3` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
1709 ADD CONSTRAINT `account_ban_history_ibfk_4` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
1710 ADD CONSTRAINT `account_ban_history_ibfk_5` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
1711 ADD CONSTRAINT `account_ban_history_ibfk_6` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
1712
1713--
1714-- Limitadores para a tabela `account_character_sale_history`
1715--
1716ALTER TABLE `account_character_sale_history`
1717 ADD CONSTRAINT `id_new_acc` FOREIGN KEY (`id_new_account`) REFERENCES `accounts` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION,
1718 ADD CONSTRAINT `id_old_acc` FOREIGN KEY (`id_old_account`) REFERENCES `accounts` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION,
1719 ADD CONSTRAINT `id_player` FOREIGN KEY (`id_player`) REFERENCES `players` (`id`) ON DELETE NO ACTION ON UPDATE NO ACTION;
1720
1721--
1722-- Limitadores para a tabela `account_viplist`
1723--
1724ALTER TABLE `account_viplist`
1725 ADD CONSTRAINT `account_viplist_ibfk_1` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE,
1726 ADD CONSTRAINT `account_viplist_ibfk_2` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE;
1727
1728--
1729-- Limitadores para a tabela `daily_reward_history`
1730--
1731ALTER TABLE `daily_reward_history`
1732 ADD CONSTRAINT `daily_reward_history_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE;
1733
1734--
1735-- Limitadores para a tabela `guilds`
1736--
1737ALTER TABLE `guilds`
1738 ADD CONSTRAINT `guilds_ibfk_1` FOREIGN KEY (`ownerid`) REFERENCES `players` (`id`) ON DELETE CASCADE;
1739
1740--
1741-- Limitadores para a tabela `guildwar_kills`
1742--
1743ALTER TABLE `guildwar_kills`
1744 ADD CONSTRAINT `guildwar_kills_ibfk_1` FOREIGN KEY (`warid`) REFERENCES `guild_wars` (`id`) ON DELETE CASCADE;
1745
1746--
1747-- Limitadores para a tabela `guild_invites`
1748--
1749ALTER TABLE `guild_invites`
1750 ADD CONSTRAINT `guild_invites_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE,
1751 ADD CONSTRAINT `guild_invites_ibfk_2` FOREIGN KEY (`guild_id`) REFERENCES `guilds` (`id`) ON DELETE CASCADE;
1752
1753--
1754-- Limitadores para a tabela `guild_membership`
1755--
1756ALTER TABLE `guild_membership`
1757 ADD CONSTRAINT `guild_membership_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
1758 ADD CONSTRAINT `guild_membership_ibfk_2` FOREIGN KEY (`guild_id`) REFERENCES `guilds` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
1759 ADD CONSTRAINT `guild_membership_ibfk_3` FOREIGN KEY (`rank_id`) REFERENCES `guild_ranks` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
1760
1761--
1762-- Limitadores para a tabela `guild_ranks`
1763--
1764ALTER TABLE `guild_ranks`
1765 ADD CONSTRAINT `guild_ranks_ibfk_1` FOREIGN KEY (`guild_id`) REFERENCES `guilds` (`id`) ON DELETE CASCADE;
1766
1767--
1768-- Limitadores para a tabela `house_lists`
1769--
1770ALTER TABLE `house_lists`
1771 ADD CONSTRAINT `house_lists_ibfk_1` FOREIGN KEY (`house_id`) REFERENCES `houses` (`id`) ON DELETE CASCADE;
1772
1773--
1774-- Limitadores para a tabela `ip_bans`
1775--
1776ALTER TABLE `ip_bans`
1777 ADD CONSTRAINT `ip_bans_ibfk_1` FOREIGN KEY (`banned_by`) REFERENCES `players` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
1778
1779--
1780-- Limitadores para a tabela `live_casts`
1781--
1782ALTER TABLE `live_casts`
1783 ADD CONSTRAINT `live_casts_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE;
1784
1785--
1786-- Limitadores para a tabela `market_history`
1787--
1788ALTER TABLE `market_history`
1789 ADD CONSTRAINT `market_history_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE;
1790
1791--
1792-- Limitadores para a tabela `market_offers`
1793--
1794ALTER TABLE `market_offers`
1795 ADD CONSTRAINT `market_offers_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE;
1796
1797--
1798-- Limitadores para a tabela `players`
1799--
1800ALTER TABLE `players`
1801 ADD CONSTRAINT `players_ibfk_1` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE;
1802
1803--
1804-- Limitadores para a tabela `player_deaths`
1805--
1806ALTER TABLE `player_deaths`
1807 ADD CONSTRAINT `player_deaths_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE;
1808
1809--
1810-- Limitadores para a tabela `player_depotitems`
1811--
1812ALTER TABLE `player_depotitems`
1813 ADD CONSTRAINT `player_depotitems_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE;
1814
1815--
1816-- Limitadores para a tabela `player_inboxitems`
1817--
1818ALTER TABLE `player_inboxitems`
1819 ADD CONSTRAINT `player_inboxitems_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE;
1820
1821--
1822-- Limitadores para a tabela `player_items`
1823--
1824ALTER TABLE `player_items`
1825 ADD CONSTRAINT `player_items_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE;
1826
1827--
1828-- Limitadores para a tabela `player_namelocks`
1829--
1830ALTER TABLE `player_namelocks`
1831 ADD CONSTRAINT `player_namelocks_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
1832 ADD CONSTRAINT `player_namelocks_ibfk_2` FOREIGN KEY (`namelocked_by`) REFERENCES `players` (`id`) ON DELETE CASCADE ON UPDATE CASCADE;
1833
1834--
1835-- Limitadores para a tabela `player_rewards`
1836--
1837ALTER TABLE `player_rewards`
1838 ADD CONSTRAINT `player_rewards_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE;
1839
1840--
1841-- Limitadores para a tabela `player_spells`
1842--
1843ALTER TABLE `player_spells`
1844 ADD CONSTRAINT `player_spells_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE;
1845
1846--
1847-- Limitadores para a tabela `player_storage`
1848--
1849ALTER TABLE `player_storage`
1850 ADD CONSTRAINT `player_storage_ibfk_1` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE;
1851
1852--
1853-- Limitadores para a tabela `prey_slots`
1854--
1855ALTER TABLE `prey_slots`
1856 ADD CONSTRAINT `prey_slots_players_fk` FOREIGN KEY (`player_id`) REFERENCES `players` (`id`) ON DELETE CASCADE;
1857
1858--
1859-- Limitadores para a tabela `store_history`
1860--
1861ALTER TABLE `store_history`
1862 ADD CONSTRAINT `store_history_ibfk_1` FOREIGN KEY (`account_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE;
1863
1864--
1865-- Limitadores para a tabela `tickets`
1866--
1867ALTER TABLE `tickets`
1868 ADD CONSTRAINT `tickets_ibfk_1` FOREIGN KEY (`ticket_author_acc_id`) REFERENCES `accounts` (`id`) ON DELETE CASCADE ON UPDATE NO ACTION;
1869
1870--
1871-- Limitadores para a tabela `tickets_reply`
1872--
1873ALTER TABLE `tickets_reply`
1874 ADD CONSTRAINT `ticket_id` FOREIGN KEY (`ticket_id`) REFERENCES `tickets` (`ticket_id`) ON DELETE CASCADE ON UPDATE NO ACTION;
1875
1876--
1877-- Limitadores para a tabela `tile_store`
1878--
1879ALTER TABLE `tile_store`
1880 ADD CONSTRAINT `tile_store_ibfk_1` FOREIGN KEY (`house_id`) REFERENCES `houses` (`id`) ON DELETE CASCADE;
1881COMMIT;
1882
1883/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
1884/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
1885/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;