· 6 years ago · May 29, 2019, 04:12 PM
1-- phpMyAdmin SQL Dump
2-- version 4.0.10deb1
3-- http://www.phpmyadmin.net
4--
5-- Host: 127.0.0.1
6-- Czas wygenerowania: 12 Paź 2018, 15:13
7-- Wersja serwera: 10.1.29-MariaDB-1~wheezy
8
9SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
10SET time_zone = "+00:00";
11
12
13/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
14/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
15/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
16/*!40101 SET NAMES utf8 */;
17
18--
19-- Baza danych: `hzpriv`
20--
21
22-- --------------------------------------------------------
23
24--
25-- Struktura tabeli dla tabeli `bank_inventory`
26--
27
28CREATE TABLE IF NOT EXISTS `bank_inventory` (
29 `id` int(11) NOT NULL AUTO_INCREMENT,
30 `character_id` int(11) NOT NULL,
31 `max_bank_index` int(11) NOT NULL,
32 `bank_item1_id` int(11) NOT NULL,
33 `bank_item2_id` int(11) NOT NULL,
34 `bank_item3_id` int(11) NOT NULL,
35 `bank_item4_id` int(11) NOT NULL,
36 `bank_item5_id` int(11) NOT NULL,
37 `bank_item6_id` int(11) NOT NULL,
38 `bank_item7_id` int(11) NOT NULL,
39 `bank_item8_id` int(11) NOT NULL,
40 `bank_item9_id` int(11) NOT NULL,
41 `bank_item10_id` int(11) NOT NULL,
42 `bank_item11_id` int(11) NOT NULL,
43 `bank_item12_id` int(11) NOT NULL,
44 `bank_item13_id` int(11) NOT NULL,
45 `bank_item14_id` int(11) NOT NULL,
46 `bank_item15_id` int(11) NOT NULL,
47 `bank_item16_id` int(11) NOT NULL,
48 `bank_item17_id` int(11) NOT NULL,
49 `bank_item18_id` int(11) NOT NULL,
50 `bank_item19_id` int(11) NOT NULL,
51 `bank_item20_id` int(11) NOT NULL,
52 `bank_item21_id` int(11) NOT NULL,
53 `bank_item22_id` int(11) NOT NULL,
54 `bank_item23_id` int(11) NOT NULL,
55 `bank_item24_id` int(11) NOT NULL,
56 `bank_item25_id` int(11) NOT NULL,
57 `bank_item26_id` int(11) NOT NULL,
58 `bank_item27_id` int(11) NOT NULL,
59 `bank_item28_id` int(11) NOT NULL,
60 `bank_item29_id` int(11) NOT NULL,
61 `bank_item30_id` int(11) NOT NULL,
62 `bank_item31_id` int(11) NOT NULL,
63 `bank_item32_id` int(11) NOT NULL,
64 `bank_item33_id` int(11) NOT NULL,
65 `bank_item34_id` int(11) NOT NULL,
66 `bank_item35_id` int(11) NOT NULL,
67 `bank_item36_id` int(11) NOT NULL,
68 `bank_item37_id` int(11) NOT NULL,
69 `bank_item38_id` int(11) NOT NULL,
70 `bank_item39_id` int(11) NOT NULL,
71 `bank_item40_id` int(11) NOT NULL,
72 `bank_item41_id` int(11) NOT NULL,
73 `bank_item42_id` int(11) NOT NULL,
74 `bank_item43_id` int(11) NOT NULL,
75 `bank_item44_id` int(11) NOT NULL,
76 `bank_item45_id` int(11) NOT NULL,
77 `bank_item46_id` int(11) NOT NULL,
78 `bank_item47_id` int(11) NOT NULL,
79 `bank_item48_id` int(11) NOT NULL,
80 `bank_item49_id` int(11) NOT NULL,
81 `bank_item50_id` int(11) NOT NULL,
82 `bank_item51_id` int(11) NOT NULL,
83 `bank_item52_id` int(11) NOT NULL,
84 `bank_item53_id` int(11) NOT NULL,
85 `bank_item54_id` int(11) NOT NULL,
86 `bank_item55_id` int(11) NOT NULL,
87 `bank_item56_id` int(11) NOT NULL,
88 `bank_item57_id` int(11) NOT NULL,
89 `bank_item58_id` int(11) NOT NULL,
90 `bank_item59_id` int(11) NOT NULL,
91 `bank_item60_id` int(11) NOT NULL,
92 `bank_item61_id` int(11) NOT NULL,
93 `bank_item62_id` int(11) NOT NULL,
94 `bank_item63_id` int(11) NOT NULL,
95 `bank_item64_id` int(11) NOT NULL,
96 `bank_item65_id` int(11) NOT NULL,
97 `bank_item66_id` int(11) NOT NULL,
98 `bank_item67_id` int(11) NOT NULL,
99 `bank_item68_id` int(11) NOT NULL,
100 `bank_item69_id` int(11) NOT NULL,
101 `bank_item70_id` int(11) NOT NULL,
102 `bank_item71_id` int(11) NOT NULL,
103 `bank_item72_id` int(11) NOT NULL,
104 `bank_item73_id` int(11) NOT NULL,
105 `bank_item74_id` int(11) NOT NULL,
106 `bank_item75_id` int(11) NOT NULL,
107 `bank_item76_id` int(11) NOT NULL,
108 `bank_item77_id` int(11) NOT NULL,
109 `bank_item78_id` int(11) NOT NULL,
110 `bank_item79_id` int(11) NOT NULL,
111 `bank_item80_id` int(11) NOT NULL,
112 `bank_item81_id` int(11) NOT NULL,
113 `bank_item82_id` int(11) NOT NULL,
114 `bank_item83_id` int(11) NOT NULL,
115 `bank_item84_id` int(11) NOT NULL,
116 `bank_item85_id` int(11) NOT NULL,
117 `bank_item86_id` int(11) NOT NULL,
118 `bank_item87_id` int(11) NOT NULL,
119 `bank_item88_id` int(11) NOT NULL,
120 `bank_item89_id` int(11) NOT NULL,
121 `bank_item90_id` int(11) NOT NULL,
122 PRIMARY KEY (`id`),
123 KEY `character_id` (`character_id`)
124) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
125
126-- --------------------------------------------------------
127
128--
129-- Struktura tabeli dla tabeli `battle`
130--
131
132CREATE TABLE IF NOT EXISTS `battle` (
133 `id` int(11) NOT NULL AUTO_INCREMENT,
134 `ts_creation` int(11) NOT NULL,
135 `profile_a_stats` text NOT NULL,
136 `profile_b_stats` text NOT NULL,
137 `winner` varchar(1) NOT NULL,
138 `rounds` text NOT NULL,
139 PRIMARY KEY (`id`)
140) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
141
142-- --------------------------------------------------------
143
144--
145-- Struktura tabeli dla tabeli `character`
146--
147
148CREATE TABLE IF NOT EXISTS `character` (
149 `id` int(11) NOT NULL AUTO_INCREMENT,
150 `user_id` int(11) NOT NULL,
151 `name` varchar(32) NOT NULL,
152 `gender` enum('m','f') NOT NULL,
153 `game_currency` int(11) unsigned NOT NULL DEFAULT '0',
154 `xp` int(11) unsigned NOT NULL DEFAULT '0',
155 `level` int(11) unsigned NOT NULL DEFAULT '1',
156 `description` varchar(255) NOT NULL,
157 `note` varchar(512) NOT NULL,
158 `ts_last_action` int(11) NOT NULL,
159 `score_honor` int(11) NOT NULL DEFAULT '10',
160 `score_level` int(11) NOT NULL DEFAULT '10',
161 `stat_points_available` mediumint(9) NOT NULL,
162 `stat_base_stamina` smallint(6) NOT NULL DEFAULT '10',
163 `stat_base_strength` smallint(6) NOT NULL DEFAULT '10',
164 `stat_base_critical_rating` smallint(6) NOT NULL DEFAULT '10',
165 `stat_base_dodge_rating` smallint(6) NOT NULL DEFAULT '10',
166 `stat_bought_stamina` mediumint(8) NOT NULL,
167 `stat_bought_strength` mediumint(8) NOT NULL,
168 `stat_bought_critical_rating` mediumint(8) NOT NULL,
169 `stat_bought_dodge_rating` mediumint(8) NOT NULL,
170 `active_quest_booster_id` varchar(25) NOT NULL,
171 `ts_active_quest_boost_expires` int(11) NOT NULL,
172 `active_stats_booster_id` varchar(25) NOT NULL,
173 `ts_active_stats_boost_expires` int(11) NOT NULL,
174 `active_work_booster_id` varchar(25) NOT NULL,
175 `ts_active_work_boost_expires` int(11) NOT NULL,
176 `ts_active_sense_boost_expires` int(11) NOT NULL,
177 `active_league_booster_id` tinyint(3) NOT NULL,
178 `ts_active_league_boost_expires` int(11) NOT NULL,
179 `ts_active_multitasking_boost_expires` int(11) NOT NULL,
180 `max_quest_stage` smallint(6) NOT NULL DEFAULT '1',
181 `current_quest_stage` smallint(6) NOT NULL DEFAULT '1',
182 `quest_energy` smallint(6) NOT NULL DEFAULT '100',
183 `max_quest_energy` smallint(6) NOT NULL DEFAULT '100',
184 `ts_last_quest_energy_refill` int(11) NOT NULL,
185 `quest_energy_refill_amount_today` smallint(6) NOT NULL,
186 `quest_reward_training_sessions_rewarded_today` smallint(6) NOT NULL,
187 `honor` mediumint(8) unsigned NOT NULL DEFAULT '100',
188 `ts_last_duel` int(11) NOT NULL,
189 `duel_stamina` smallint(6) NOT NULL DEFAULT '100',
190 `max_duel_stamina` smallint(6) NOT NULL DEFAULT '100',
191 `ts_last_duel_stamina_change` int(11) NOT NULL,
192 `ts_last_duel_enemies_refresh` int(11) NOT NULL,
193 `current_work_offer_id` varchar(32) NOT NULL DEFAULT 'work1',
194 `stat_trained_stamina` mediumint(8) NOT NULL,
195 `stat_trained_strength` mediumint(8) NOT NULL,
196 `stat_trained_critical_rating` mediumint(8) NOT NULL,
197 `stat_trained_dodge_rating` mediumint(8) NOT NULL,
198 `training_progress_value_stamina` smallint(8) NOT NULL,
199 `training_progress_value_strength` mediumint(8) NOT NULL,
200 `training_progress_value_critical_rating` mediumint(8) NOT NULL,
201 `training_progress_value_dodge_rating` mediumint(8) NOT NULL,
202 `training_progress_end_stamina` smallint(6) NOT NULL DEFAULT '3',
203 `training_progress_end_strength` smallint(6) NOT NULL DEFAULT '3',
204 `training_progress_end_critical_rating` smallint(6) NOT NULL DEFAULT '3',
205 `training_progress_end_dodge_rating` smallint(6) NOT NULL DEFAULT '3',
206 `ts_last_training` int(11) NOT NULL,
207 `training_count` smallint(6) NOT NULL DEFAULT '10',
208 `max_training_count` smallint(6) NOT NULL DEFAULT '10',
209 `active_worldboss_attack_id` int(11) NOT NULL,
210 `active_dungeon_quest_id` int(11) NOT NULL,
211 `ts_last_dungeon_quest_fail` int(11) NOT NULL,
212 `max_dungeon_index` int(11) NOT NULL,
213 `appearance_skin_color` tinyint(3) NOT NULL,
214 `appearance_hair_color` tinyint(3) NOT NULL,
215 `appearance_hair_type` tinyint(3) NOT NULL,
216 `appearance_head_type` tinyint(3) NOT NULL,
217 `appearance_eyes_type` tinyint(3) NOT NULL,
218 `appearance_eyebrows_type` tinyint(3) NOT NULL,
219 `appearance_nose_type` tinyint(3) NOT NULL,
220 `appearance_mouth_type` tinyint(3) NOT NULL,
221 `appearance_facial_hair_type` tinyint(3) NOT NULL,
222 `appearance_decoration_type` tinyint(3) NOT NULL DEFAULT '1',
223 `show_mask` tinyint(1) NOT NULL DEFAULT '1',
224 `tutorial_flags` text NOT NULL,
225 `guild_id` int(11) NOT NULL,
226 `guild_rank` tinyint(2) NOT NULL,
227 `ts_guild_joined` int(11) NOT NULL,
228 `finished_guild_battle_attack_id` int(11) NOT NULL,
229 `finished_guild_battle_defense_id` int(11) NOT NULL,
230 `finished_guild_dungeon_battle_id` int(11) NOT NULL,
231 `guild_donated_game_currency` int(11) NOT NULL,
232 `guild_donated_premium_currency` int(11) NOT NULL,
233 `worldboss_event_id` int(11) NOT NULL,
234 `worldboss_event_attack_count` smallint(6) NOT NULL,
235 `ts_last_wash_item` int(11) NOT NULL,
236 `ts_last_daily_login_bonus` int(11) NOT NULL,
237 `daily_login_bonus_day` tinyint(3) NOT NULL DEFAULT '1',
238 `pending_tournament_rewards` int(11) NOT NULL,
239 `ts_last_shop_refresh` int(11) NOT NULL,
240 `shop_refreshes` smallint(6) NOT NULL,
241 `event_quest_id` int(11) NOT NULL,
242 `friend_data` varchar(32) NOT NULL,
243 `pending_resource_requests` smallint(6) NOT NULL,
244 `unused_resources` varchar(32) NOT NULL DEFAULT '{"1":4,"2":1}',
245 `used_resources` int(11) NOT NULL,
246 `league_points` int(11) NOT NULL,
247 `league_group_id` int(11) NOT NULL,
248 `active_league_fight_id` int(11) NOT NULL,
249 `ts_last_league_fight` int(11) NOT NULL,
250 `league_fight_count` int(11) NOT NULL,
251 `league_opponents` varchar(32) NOT NULL,
252 `ts_last_league_opponents_refresh` int(11) NOT NULL,
253 `league_stamina` smallint(6) NOT NULL DEFAULT '20',
254 `max_league_stamina` smallint(6) NOT NULL DEFAULT '20',
255 `ts_last_league_stamina_change` int(11) NOT NULL,
256 `league_stamina_cost` int(11) NOT NULL DEFAULT '20',
257 `herobook_objectives_renewed_today` int(11) NOT NULL,
258 `slotmachine_spin_count` int(11) NOT NULL,
259 `ts_last_slotmachine_refill` int(11) NOT NULL,
260 `new_user_voucher_ids` varchar(32) NOT NULL,
261 `current_energy_storage` int(11) NOT NULL,
262 `current_training_storage` int(11) NOT NULL,
263 PRIMARY KEY (`id`),
264 KEY `guild_id` (`guild_id`),
265 KEY `user_id` (`user_id`),
266 KEY `honor` (`honor`),
267 KEY `level` (`level`)
268) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
269
270-- --------------------------------------------------------
271
272--
273-- Struktura tabeli dla tabeli `duel`
274--
275
276CREATE TABLE IF NOT EXISTS `duel` (
277 `id` int(11) NOT NULL AUTO_INCREMENT,
278 `ts_creation` int(11) NOT NULL,
279 `battle_id` int(11) NOT NULL,
280 `character_a_id` int(11) NOT NULL,
281 `character_b_id` int(11) NOT NULL,
282 `character_a_status` tinyint(1) NOT NULL DEFAULT '1',
283 `character_b_status` tinyint(1) NOT NULL DEFAULT '1',
284 `character_a_rewards` text NOT NULL,
285 `character_b_rewards` text NOT NULL,
286 PRIMARY KEY (`id`),
287 KEY `attackerduel` (`character_a_id`,`character_a_status`),
288 KEY `defenderduel` (`character_b_id`,`character_b_status`)
289) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
290
291-- --------------------------------------------------------
292
293--
294-- Struktura tabeli dla tabeli `guild`
295--
296
297CREATE TABLE IF NOT EXISTS `guild` (
298 `id` int(11) NOT NULL AUTO_INCREMENT,
299 `ts_creation` int(11) NOT NULL,
300 `initiator_character_id` int(11) NOT NULL,
301 `leader_character_id` int(11) NOT NULL,
302 `name` varchar(64) NOT NULL,
303 `description` text NOT NULL,
304 `note` text NOT NULL,
305 `forum_page` varchar(128) NOT NULL,
306 `premium_currency` int(11) NOT NULL,
307 `game_currency` int(11) NOT NULL DEFAULT '500',
308 `status` tinyint(1) NOT NULL DEFAULT '1',
309 `accept_members` tinyint(1) NOT NULL,
310 `honor` int(11) NOT NULL DEFAULT '1000',
311 `artifact_ids` text NOT NULL,
312 `missiles` int(11) NOT NULL DEFAULT '15',
313 `auto_joins` tinyint(1) NOT NULL,
314 `battles_attacked` int(11) NOT NULL,
315 `battles_defended` int(11) NOT NULL,
316 `battles_won` int(11) NOT NULL,
317 `battles_lost` int(11) NOT NULL,
318 `artifacts_won` int(11) NOT NULL,
319 `artifacts_lost` int(11) NOT NULL,
320 `artifacts_owned_max` int(11) NOT NULL DEFAULT '2',
321 `artifacts_owned_current` int(11) NOT NULL,
322 `ts_last_artifact_released` int(11) NOT NULL,
323 `missiles_fired` int(11) NOT NULL,
324 `auto_joins_used` tinyint(1) NOT NULL,
325 `dungeon_battles_fought` int(11) NOT NULL,
326 `dungeon_battles_won` int(11) NOT NULL,
327 `stat_points_available` int(11) NOT NULL,
328 `stat_guild_capacity` int(11) NOT NULL DEFAULT '10',
329 `stat_character_base_stats_boost` int(11) NOT NULL DEFAULT '1',
330 `stat_quest_xp_reward_boost` int(11) NOT NULL DEFAULT '1',
331 `stat_quest_game_currency_reward_boost` int(11) NOT NULL DEFAULT '1',
332 `arena_background` smallint(3) NOT NULL DEFAULT '1',
333 `emblem_background_shape` tinyint(3) NOT NULL DEFAULT '1',
334 `emblem_background_color` tinyint(3) NOT NULL DEFAULT '2',
335 `emblem_background_border_color` tinyint(3) NOT NULL,
336 `emblem_icon_shape` tinyint(3) NOT NULL DEFAULT '1',
337 `emblem_icon_color` tinyint(3) NOT NULL DEFAULT '4',
338 `emblem_icon_size` smallint(3) NOT NULL DEFAULT '100',
339 `use_missiles_attack` tinyint(1) NOT NULL DEFAULT '1',
340 `use_missiles_defense` tinyint(1) NOT NULL DEFAULT '1',
341 `use_missiles_dungeon` tinyint(1) NOT NULL DEFAULT '1',
342 `use_auto_joins_attack` tinyint(1) NOT NULL DEFAULT '1',
343 `use_auto_joins_defense` tinyint(1) NOT NULL DEFAULT '1',
344 `use_auto_joins_dungeon` tinyint(1) NOT NULL DEFAULT '1',
345 `pending_leader_vote_id` int(11) NOT NULL,
346 `min_apply_level` int(11) NOT NULL,
347 `min_apply_honor` int(11) NOT NULL,
348 `guild_battle_tactics_attack_order` int(11) NOT NULL DEFAULT '1',
349 `guild_battle_tactics_attack_tactic` int(11) NOT NULL DEFAULT '10',
350 `guild_battle_tactics_defense_order` int(11) NOT NULL DEFAULT '1',
351 `guild_battle_tactics_defense_tactic` int(11) NOT NULL DEFAULT '10',
352 `active_training_booster_id` varchar(40) NOT NULL,
353 `ts_active_training_boost_expires` int(11) NOT NULL,
354 `active_quest_booster_id` varchar(40) NOT NULL,
355 `ts_active_quest_boost_expires` int(11) NOT NULL,
356 `active_duel_booster_id` varchar(40) NOT NULL,
357 `ts_active_duel_boost_expires` int(11) NOT NULL,
358 PRIMARY KEY (`id`),
359 KEY `name` (`name`),
360 KEY `honor` (`honor`)
361) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
362
363-- --------------------------------------------------------
364
365--
366-- Struktura tabeli dla tabeli `guild_battle`
367--
368
369CREATE TABLE IF NOT EXISTS `guild_battle` (
370 `id` int(11) NOT NULL AUTO_INCREMENT,
371 `status` int(11) NOT NULL,
372 `battle_time` tinyint(1) NOT NULL,
373 `ts_attack` int(11) NOT NULL,
374 `guild_attacker_id` int(11) NOT NULL,
375 `guild_defender_id` int(11) NOT NULL,
376 `attacker_character_ids` text NOT NULL,
377 `defender_character_ids` text NOT NULL,
378 `guild_winner_id` int(11) NOT NULL,
379 `attacker_character_profiles` text NOT NULL,
380 `defender_character_profiles` text NOT NULL,
381 `rounds` text NOT NULL,
382 `attacker_rewards` text NOT NULL,
383 `defender_rewards` text NOT NULL,
384 `initiator_character_id` int(11) NOT NULL,
385 PRIMARY KEY (`id`),
386 KEY `attackerbattle` (`guild_attacker_id`,`status`),
387 KEY `defenderbattle` (`guild_defender_id`,`status`)
388) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
389
390-- --------------------------------------------------------
391
392--
393-- Struktura tabeli dla tabeli `guild_battle_rewards`
394--
395
396CREATE TABLE IF NOT EXISTS `guild_battle_rewards` (
397 `id` int(11) NOT NULL AUTO_INCREMENT,
398 `guild_battle_id` int(11) NOT NULL,
399 `character_id` int(111) NOT NULL,
400 `game_currency` int(11) NOT NULL,
401 `item_id` int(11) NOT NULL DEFAULT '0',
402 `status` tinyint(1) NOT NULL DEFAULT '1',
403 `type` tinyint(1) NOT NULL,
404 PRIMARY KEY (`id`),
405 KEY `attackerreward` (`character_id`,`type`),
406 KEY `battlereward` (`guild_battle_id`,`character_id`)
407) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
408
409-- --------------------------------------------------------
410
411--
412-- Struktura tabeli dla tabeli `guild_dungeon`
413--
414
415CREATE TABLE IF NOT EXISTS `guild_dungeon` (
416 `id` int(11) NOT NULL AUTO_INCREMENT,
417 `guild_id` int(11) NOT NULL,
418 `npc_team_identifier` varchar(10) NOT NULL,
419 `npc_team_character_profiles` text NOT NULL,
420 `settings` text NOT NULL,
421 `ts_unlock` int(11) NOT NULL,
422 `locking_character_name` varchar(30) NOT NULL,
423 PRIMARY KEY (`id`),
424 KEY `guild_id` (`guild_id`)
425) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
426
427-- --------------------------------------------------------
428
429--
430-- Struktura tabeli dla tabeli `guild_dungeon_battle`
431--
432
433CREATE TABLE IF NOT EXISTS `guild_dungeon_battle` (
434 `id` int(11) NOT NULL AUTO_INCREMENT,
435 `status` int(11) NOT NULL,
436 `battle_time` tinyint(1) NOT NULL,
437 `ts_attack` int(11) NOT NULL,
438 `guild_id` int(11) NOT NULL,
439 `npc_team_identifier` varchar(10) NOT NULL,
440 `settings` text NOT NULL,
441 `character_ids` text NOT NULL,
442 `joined_character_profiles` text NOT NULL,
443 `npc_team_character_profiles` text NOT NULL,
444 `rounds` text NOT NULL,
445 `rewards` text NOT NULL,
446 `initiator_character_id` int(11) NOT NULL,
447 PRIMARY KEY (`id`),
448 KEY `status` (`status`)
449) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
450
451-- --------------------------------------------------------
452
453--
454-- Struktura tabeli dla tabeli `guild_invites`
455--
456
457CREATE TABLE IF NOT EXISTS `guild_invites` (
458 `id` int(11) NOT NULL AUTO_INCREMENT,
459 `character_id` int(11) NOT NULL,
460 `guild_id` int(11) NOT NULL,
461 `ts_creation` int(11) NOT NULL,
462 PRIMARY KEY (`id`),
463 KEY `character_id` (`character_id`),
464 KEY `guild_id` (`guild_id`)
465) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
466
467-- --------------------------------------------------------
468
469--
470-- Struktura tabeli dla tabeli `guild_logs`
471--
472
473CREATE TABLE IF NOT EXISTS `guild_logs` (
474 `id` int(11) NOT NULL AUTO_INCREMENT,
475 `guild_id` int(11) NOT NULL,
476 `character_id` int(11) NOT NULL,
477 `character_name` varchar(32) NOT NULL,
478 `type` int(11) NOT NULL,
479 `value1` varchar(64) NOT NULL,
480 `value2` varchar(64) NOT NULL,
481 `value3` varchar(64) NOT NULL,
482 `timestamp` int(11) NOT NULL,
483 PRIMARY KEY (`id`),
484 KEY `log` (`guild_id`,`timestamp`,`character_id`)
485) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
486
487-- --------------------------------------------------------
488
489--
490-- Struktura tabeli dla tabeli `guild_messages`
491--
492
493CREATE TABLE IF NOT EXISTS `guild_messages` (
494 `id` int(11) NOT NULL AUTO_INCREMENT,
495 `guild_id` int(11) NOT NULL,
496 `character_from_id` int(11) NOT NULL,
497 `character_from_name` varchar(32) NOT NULL,
498 `character_to_id` int(11) NOT NULL,
499 `is_officer` tinyint(1) NOT NULL,
500 `is_private` tinyint(1) NOT NULL,
501 `message` text NOT NULL,
502 `timestamp` int(11) NOT NULL,
503 PRIMARY KEY (`id`),
504 UNIQUE KEY `message` (`guild_id`,`character_to_id`,`is_private`,`is_officer`),
505 KEY `tsmessage` (`guild_id`,`timestamp`,`character_from_id`,`character_to_id`,`is_officer`,`is_private`)
506) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
507
508-- --------------------------------------------------------
509
510--
511-- Struktura tabeli dla tabeli `inventory`
512--
513
514CREATE TABLE IF NOT EXISTS `inventory` (
515 `id` int(11) NOT NULL AUTO_INCREMENT,
516 `character_id` int(11) NOT NULL,
517 `mask_item_id` int(11) NOT NULL,
518 `cape_item_id` int(11) NOT NULL,
519 `suit_item_id` int(11) NOT NULL,
520 `belt_item_id` int(11) NOT NULL,
521 `boots_item_id` int(11) NOT NULL,
522 `weapon_item_id` int(11) NOT NULL,
523 `gadget_item_id` int(11) NOT NULL,
524 `missiles_item_id` int(11) NOT NULL,
525 `missiles1_item_id` int(11) NOT NULL DEFAULT '-1',
526 `missiles2_item_id` int(11) NOT NULL DEFAULT '-1',
527 `missiles3_item_id` int(11) NOT NULL DEFAULT '-1',
528 `missiles4_item_id` int(11) NOT NULL DEFAULT '-1',
529 `sidekick_id` int(11) NOT NULL,
530 `bag_item1_id` int(11) NOT NULL,
531 `bag_item2_id` int(11) NOT NULL,
532 `bag_item3_id` int(11) NOT NULL,
533 `bag_item4_id` int(11) NOT NULL,
534 `bag_item5_id` int(11) NOT NULL,
535 `bag_item6_id` int(11) NOT NULL,
536 `bag_item7_id` int(11) NOT NULL,
537 `bag_item8_id` int(11) NOT NULL,
538 `bag_item9_id` int(11) NOT NULL,
539 `bag_item10_id` int(11) NOT NULL,
540 `bag_item11_id` int(11) NOT NULL,
541 `bag_item12_id` int(11) NOT NULL,
542 `bag_item13_id` int(11) NOT NULL,
543 `bag_item14_id` int(11) NOT NULL,
544 `bag_item15_id` int(11) NOT NULL,
545 `bag_item16_id` int(11) NOT NULL,
546 `bag_item17_id` int(11) NOT NULL,
547 `bag_item18_id` int(11) NOT NULL,
548 `shop_item1_id` int(11) NOT NULL,
549 `shop_item2_id` int(11) NOT NULL,
550 `shop_item3_id` int(11) NOT NULL,
551 `shop_item4_id` int(11) NOT NULL,
552 `shop_item5_id` int(11) NOT NULL,
553 `shop_item6_id` int(11) NOT NULL,
554 `shop_item7_id` int(11) NOT NULL,
555 `shop_item8_id` int(11) NOT NULL,
556 `shop_item9_id` int(11) NOT NULL,
557 `shop2_item1_id` int(11) NOT NULL,
558 `shop2_item2_id` int(11) NOT NULL,
559 `shop2_item3_id` int(11) NOT NULL,
560 `shop2_item4_id` int(11) NOT NULL,
561 `shop2_item5_id` int(11) NOT NULL,
562 `shop2_item6_id` int(11) NOT NULL,
563 `shop2_item7_id` int(11) NOT NULL,
564 `shop2_item8_id` int(11) NOT NULL,
565 `shop2_item9_id` int(11) NOT NULL,
566 `item_set_data` varchar(64) NOT NULL,
567 `sidekick_data` varchar(64) NOT NULL,
568 PRIMARY KEY (`id`),
569 KEY `character_id` (`character_id`)
570) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
571
572-- --------------------------------------------------------
573
574--
575-- Struktura tabeli dla tabeli `items`
576--
577
578CREATE TABLE IF NOT EXISTS `items` (
579 `id` int(11) NOT NULL AUTO_INCREMENT,
580 `character_id` int(11) NOT NULL,
581 `identifier` varchar(100) NOT NULL,
582 `type` tinyint(3) NOT NULL,
583 `quality` tinyint(3) NOT NULL,
584 `required_level` smallint(6) NOT NULL,
585 `charges` tinyint(4) NOT NULL,
586 `item_level` smallint(6) NOT NULL,
587 `ts_availability_start` int(11) NOT NULL,
588 `ts_availability_end` int(11) NOT NULL,
589 `premium_item` tinyint(1) NOT NULL DEFAULT '0',
590 `buy_price` mediumint(8) NOT NULL,
591 `sell_price` mediumint(8) NOT NULL,
592 `stat_stamina` mediumint(8) NOT NULL,
593 `stat_strength` mediumint(8) NOT NULL,
594 `stat_critical_rating` mediumint(8) NOT NULL,
595 `stat_dodge_rating` mediumint(8) NOT NULL,
596 `stat_weapon_damage` mediumint(8) NOT NULL,
597 PRIMARY KEY (`id`),
598 KEY `character_id` (`character_id`)
599) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
600
601
602-- --------------------------------------------------------
603
604--
605-- Struktura tabeli dla tabeli `quests`
606--
607
608CREATE TABLE IF NOT EXISTS `quests` (
609 `id` int(11) NOT NULL AUTO_INCREMENT,
610 `character_id` int(11) NOT NULL,
611 `identifier` varchar(32) NOT NULL,
612 `type` tinyint(3) NOT NULL,
613 `stage` tinyint(3) NOT NULL,
614 `level` mediumint(8) NOT NULL,
615 `status` tinyint(3) NOT NULL DEFAULT '1',
616 `duration_type` tinyint(3) NOT NULL DEFAULT '1',
617 `duration_raw` smallint(6) NOT NULL,
618 `duration` smallint(6) NOT NULL,
619 `ts_complete` int(11) NOT NULL DEFAULT '0',
620 `energy_cost` smallint(6) NOT NULL,
621 `fight_difficulty` tinyint(3) NOT NULL DEFAULT '0',
622 `fight_npc_identifier` varchar(60) NOT NULL,
623 `fight_battle_id` int(11) NOT NULL DEFAULT '0',
624 `used_resources` tinyint(3) NOT NULL DEFAULT '0',
625 `rewards` varchar(200) NOT NULL,
626 PRIMARY KEY (`id`),
627 KEY `quests` (`character_id`,`status`)
628) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
629
630-- --------------------------------------------------------
631
632--
633-- Struktura tabeli dla tabeli `slotmachines`
634--
635
636CREATE TABLE IF NOT EXISTS `slotmachines` (
637 `id` int(11) NOT NULL AUTO_INCREMENT,
638 `character_id` int(10) unsigned NOT NULL,
639 `slotmachine_reward_quality` tinyint(3) unsigned NOT NULL,
640 `slotmachine_slot1` tinyint(3) unsigned NOT NULL,
641 `slotmachine_slot2` tinyint(3) unsigned NOT NULL,
642 `slotmachine_slot3` tinyint(3) unsigned NOT NULL,
643 `reward` text NOT NULL,
644 `timestamp` int(10) unsigned NOT NULL,
645 PRIMARY KEY (`id`),
646 KEY `character_id` (`character_id`)
647) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
648
649-- --------------------------------------------------------
650
651--
652-- Struktura tabeli dla tabeli `training`
653--
654
655CREATE TABLE IF NOT EXISTS `training` (
656 `id` int(11) NOT NULL AUTO_INCREMENT,
657 `character_id` int(11) NOT NULL,
658 `status` tinyint(1) NOT NULL,
659 `stat_type` tinyint(1) NOT NULL,
660 `ts_creation` int(11) NOT NULL,
661 `ts_complete` int(11) NOT NULL,
662 `iterations` tinyint(1) NOT NULL,
663 `used_resources` int(11) NOT NULL,
664 PRIMARY KEY (`id`),
665 KEY `training` (`character_id`,`status`)
666) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
667
668-- --------------------------------------------------------
669
670--
671-- Struktura tabeli dla tabeli `user`
672--
673
674CREATE TABLE IF NOT EXISTS `user` (
675 `id` int(11) NOT NULL AUTO_INCREMENT,
676 `registration_source` varchar(64) NOT NULL DEFAULT 'ref=;subid=;lp=default_newCharacter_25M;',
677 `registration_ip` varchar(45) DEFAULT NULL,
678 `ts_creation` int(11) NOT NULL,
679 `email` varchar(100) NOT NULL,
680 `email_new` varchar(100) NOT NULL,
681 `password_hash` varchar(40) NOT NULL,
682 `last_login_ip` varchar(45) NOT NULL,
683 `login_count` int(11) NOT NULL,
684 `ts_last_login` int(11) NOT NULL,
685 `session_id` varchar(32) NOT NULL,
686 `session_id_cache1` varchar(32) NOT NULL,
687 `session_id_cache2` varchar(32) NOT NULL,
688 `session_id_cache3` varchar(32) NOT NULL,
689 `session_id_cache4` varchar(32) NOT NULL,
690 `session_id_cache5` varchar(32) NOT NULL,
691 `premium_currency` int(11) NOT NULL DEFAULT '0',
692 `locale` varchar(6) NOT NULL DEFAULT 'pl_PL',
693 `network` varchar(10) NOT NULL,
694 `geo_country_code` varchar(3) NOT NULL DEFAULT 'PL',
695 `geo_country_code3` varchar(3) NOT NULL,
696 `geo_country_name` varchar(16) NOT NULL DEFAULT 'Poland',
697 `geo_continent_code` varchar(3) NOT NULL DEFAULT 'EU',
698 `settings` varchar(250) NOT NULL DEFAULT '{"tos_sep2015":true}',
699 `ts_banned` int(11) NOT NULL,
700 `trusted` tinyint(1) NOT NULL DEFAULT '0',
701 `confirmed` bit(1) NOT NULL DEFAULT b'0',
702 PRIMARY KEY (`id`),
703 KEY `login` (`email`,`password_hash`),
704 KEY `autologin` (`id`,`session_id`)
705) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
706
707-- --------------------------------------------------------
708
709--
710-- Struktura tabeli dla tabeli `work`
711--
712
713CREATE TABLE IF NOT EXISTS `work` (
714 `id` int(11) NOT NULL AUTO_INCREMENT,
715 `character_id` int(11) NOT NULL,
716 `work_offer_id` varchar(64) NOT NULL,
717 `status` smallint(3) NOT NULL,
718 `duration` int(11) NOT NULL,
719 `ts_complete` int(11) NOT NULL,
720 `rewards` mediumtext NOT NULL,
721 PRIMARY KEY (`id`),
722 KEY `work` (`character_id`,`status`)
723) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
724
725/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
726/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
727
728GAJUS GEJUS, HE IS CUMMING ON HENTAI