· 8 years ago · Jul 03, 2018, 12:26 AM
1DROP TABLE IF EXISTS `accounts`;
2
3CREATE TABLE `accounts` (
4 `acct` int(10) unsigned NOT NULL auto_increment COMMENT 'Unique ID',
5 `login` varchar(32) collate utf8_unicode_ci NOT NULL COMMENT 'Login username',
6 `password` varchar(32) collate utf8_unicode_ci NOT NULL COMMENT 'Login password',
7 `encrypted_password` varchar(42) collate utf8_unicode_ci NOT NULL default '',
8 `gm` varchar(32) collate utf8_unicode_ci NOT NULL default '' COMMENT 'Game permissions',
9 `banned` int(10) unsigned NOT NULL,
10 `lastlogin` timestamp NOT NULL default '0000-00-00 00:00:00' COMMENT 'Last login timestamp',
11 `lastip` varchar(16) collate utf8_unicode_ci NOT NULL default '' COMMENT 'Last remote address',
12 `email` varchar(64) collate utf8_unicode_ci NOT NULL default '' COMMENT 'Contact e-mail address',
13 `flags` tinyint(3) unsigned NOT NULL default '0' COMMENT 'Client flags',
14 `forceLanguage` varchar(5) collate utf8_unicode_ci NOT NULL default 'enUS',
15 `muted` int(30) NOT NULL default '0',
16 `banreason` varchar(255) collate utf8_unicode_ci default NULL,
17 PRIMARY KEY (`acct`),
18 UNIQUE KEY `a` (`login`)
19) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Account Information';
20
21INSERT INTO accounts VALUES ('1','admin','admin','','az','0','','','','24','enUS','0','');
22
23DROP TABLE IF EXISTS `ipbans`;
24
25CREATE TABLE `ipbans` (
26 `ip` varchar(20) collate utf8_unicode_ci NOT NULL,
27 `expire` int(10) NOT NULL COMMENT 'Expiry time (s)',
28 `banreason` varchar(255) collate utf8_unicode_ci default NULL,
29 PRIMARY KEY (`ip`),
30 UNIQUE KEY `a` (`ip`)
31) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='IPBanner';
32
33DROP TABLE IF EXISTS `account_data`;
34
35CREATE TABLE `account_data` (
36 `acct` int(30) NOT NULL,
37 `uiconfig0` blob,
38 `uiconfig1` blob,
39 `uiconfig2` blob,
40 `uiconfig3` blob,
41 `uiconfig4` blob,
42 `uiconfig5` blob,
43 `uiconfig6` blob,
44 `uiconfig7` blob,
45 `uiconfig8` blob,
46 PRIMARY KEY (`acct`)
47) ENGINE=InnoDB DEFAULT CHARSET=latin1;
48
49DROP TABLE IF EXISTS `account_forced_permissions`;
50
51CREATE TABLE `account_forced_permissions` (
52 `login` varchar(50) NOT NULL,
53 `permissions` varchar(100) NOT NULL,
54 PRIMARY KEY (`login`)
55) ENGINE=InnoDB DEFAULT CHARSET=latin1;
56
57DROP TABLE IF EXISTS `arenateams`;
58
59CREATE TABLE `arenateams` (
60 `id` int(30) NOT NULL,
61 `type` int(30) NOT NULL,
62 `leader` int(30) NOT NULL,
63 `name` varchar(150) NOT NULL,
64 `emblemstyle` int(40) NOT NULL,
65 `emblemcolour` bigint(40) NOT NULL,
66 `borderstyle` int(40) NOT NULL,
67 `bordercolour` bigint(40) NOT NULL,
68 `backgroundcolour` bigint(40) NOT NULL,
69 `rating` int(30) NOT NULL,
70 `data` varchar(150) NOT NULL,
71 `ranking` int(30) NOT NULL,
72 `player_data1` varchar(60) NOT NULL,
73 `player_data2` varchar(60) NOT NULL,
74 `player_data3` varchar(60) NOT NULL,
75 `player_data4` varchar(60) NOT NULL,
76 `player_data5` varchar(60) NOT NULL,
77 `player_data6` varchar(60) NOT NULL,
78 `player_data7` varchar(60) NOT NULL,
79 `player_data8` varchar(60) NOT NULL,
80 `player_data9` varchar(60) NOT NULL,
81 `player_data10` varchar(60) NOT NULL,
82 PRIMARY KEY (`id`)
83) ENGINE=InnoDB DEFAULT CHARSET=latin1;
84
85DROP TABLE IF EXISTS `auctions`;
86
87CREATE TABLE `auctions` (
88 `auctionId` int(32) NOT NULL AUTO_INCREMENT,
89 `auctionhouse` int(32) DEFAULT NULL,
90 `item` bigint(10) DEFAULT NULL,
91 `owner` bigint(10) DEFAULT NULL,
92 `startbid` INT(32) DEFAULT NULL,
93 `buyout` int(32) DEFAULT NULL,
94 `time` int(32) DEFAULT NULL,
95 `bidder` bigint(10) DEFAULT NULL,
96 `bid` int(32) DEFAULT NULL,
97 `deposit` int(32) DEFAULT NULL,
98 PRIMARY KEY (`auctionId`),
99 KEY `b` (`auctionhouse`)
100) ENGINE=InnoDB DEFAULT CHARSET=latin1;
101
102DROP TABLE IF EXISTS `banned_names`;
103
104CREATE TABLE `banned_names` (
105 `name` varchar(30) COLLATE utf8_unicode_ci NOT NULL
106) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
107
108DROP TABLE IF EXISTS `character_achievement`;
109
110CREATE TABLE `character_achievement` (
111 `guid` int(10) unsigned NOT NULL DEFAULT '0',
112 `achievement` int(10) unsigned NOT NULL DEFAULT '0',
113 `date` int(10) unsigned DEFAULT NULL,
114 PRIMARY KEY (`guid`,`achievement`)
115) ENGINE=InnoDB DEFAULT CHARSET=latin1;
116
117DROP TABLE IF EXISTS `character_achievement_progress`;
118
119CREATE TABLE `character_achievement_progress` (
120 `guid` int(10) unsigned NOT NULL DEFAULT '0',
121 `criteria` int(10) unsigned NOT NULL DEFAULT '0',
122 `counter` int(10) DEFAULT NULL,
123 `date` int(10) unsigned DEFAULT NULL,
124 PRIMARY KEY (`guid`,`criteria`)
125) ENGINE=InnoDB DEFAULT CHARSET=latin1;
126
127DROP TABLE IF EXISTS `characters`;
128
129CREATE TABLE `characters` (
130 `guid` int(6) unsigned NOT NULL DEFAULT '0',
131 `acct` int(20) unsigned NOT NULL DEFAULT '0',
132 `name` varchar(21) NOT NULL DEFAULT '',
133 `race` smallint(3) NOT NULL,
134 `class` smallint(3) NOT NULL,
135 `gender` tinyint(1) NOT NULL,
136 `custom_faction` int(30) NOT NULL DEFAULT '0',
137 `level` int(3) NOT NULL,
138 `xp` int(30) NOT NULL,
139 `active_cheats` int(10) unsigned NOT NULL DEFAULT '0',
140 `exploration_data` longtext NOT NULL,
141 `skills` longtext NOT NULL,
142 `watched_faction_index` bigint(40) NOT NULL,
143 `selected_pvp_title` int(30) NOT NULL,
144 `available_pvp_titles` bigint(10) unsigned NOT NULL DEFAULT '0',
145 `available_pvp_titles1` bigint(10) NOT NULL,
146 `gold` int(30) NOT NULL,
147 `ammo_id` int(30) NOT NULL,
148 `available_prof_points` int(30) NOT NULL,
149 `current_hp` int(30) NOT NULL,
150 `current_power` int(30) NOT NULL,
151 `pvprank` int(30) NOT NULL,
152 `bytes` int(30) NOT NULL,
153 `bytes2` int(30) NOT NULL,
154 `player_flags` int(30) NOT NULL,
155 `player_bytes` int(30) NOT NULL,
156 `positionX` float NOT NULL DEFAULT '0',
157 `positionY` float NOT NULL DEFAULT '0',
158 `positionZ` float NOT NULL DEFAULT '0',
159 `orientation` float NOT NULL DEFAULT '0',
160 `mapId` int(8) unsigned NOT NULL DEFAULT '0',
161 `zoneId` int(8) unsigned NOT NULL DEFAULT '0',
162 `taximask` longtext NOT NULL,
163 `banned` int(40) unsigned NOT NULL DEFAULT '0',
164 `banReason` varchar(255) NOT NULL,
165 `timestamp` int(30) DEFAULT NULL,
166 `online` int(11) DEFAULT NULL,
167 `bindpositionX` float NOT NULL DEFAULT '0',
168 `bindpositionY` float NOT NULL DEFAULT '0',
169 `bindpositionZ` float NOT NULL DEFAULT '0',
170 `bindmapId` int(8) unsigned NOT NULL DEFAULT '0',
171 `bindzoneId` int(8) unsigned NOT NULL DEFAULT '0',
172 `isResting` int(3) NOT NULL DEFAULT '0',
173 `restState` int(5) NOT NULL DEFAULT '0',
174 `restTime` int(5) NOT NULL DEFAULT '0',
175 `playedtime` text NOT NULL,
176 `deathstate` int(5) NOT NULL DEFAULT '0',
177 `TalentResetTimes` int(5) NOT NULL DEFAULT '0',
178 `first_login` tinyint(1) NOT NULL DEFAULT '0',
179 `forced_rename_pending` tinyint(1) NOT NULL DEFAULT '0',
180 `arenaPoints` int(10) NOT NULL,
181 `totalstableslots` int(10) unsigned NOT NULL DEFAULT '0',
182 `instance_id` int(10) NOT NULL,
183 `entrypointmap` int(10) NOT NULL,
184 `entrypointx` float NOT NULL,
185 `entrypointy` float NOT NULL,
186 `entrypointz` float NOT NULL,
187 `entrypointo` float NOT NULL,
188 `entrypointinstance` int(10) NOT NULL,
189 `taxi_path` int(10) NOT NULL,
190 `taxi_lastnode` int(10) NOT NULL,
191 `taxi_mountid` int(10) NOT NULL,
192 `transporter` int(10) NOT NULL,
193 `transporter_xdiff` float NOT NULL,
194 `transporter_ydiff` float NOT NULL,
195 `transporter_zdiff` float NOT NULL,
196 `spells` longtext NOT NULL,
197 `deleted_spells` longtext NOT NULL,
198 `reputation` longtext NOT NULL,
199 `actions1` longtext NOT NULL,
200 `actions2` longtext NOT NULL,
201 `auras` longtext NOT NULL,
202 `finished_quests` longtext NOT NULL,
203 `finisheddailies` longtext NOT NULL,
204 `honorRolloverTime` int(30) NOT NULL DEFAULT '0',
205 `killsToday` int(10) NOT NULL DEFAULT '0',
206 `killsYesterday` int(10) NOT NULL DEFAULT '0',
207 `killsLifeTime` int(10) NOT NULL DEFAULT '0',
208 `honorToday` int(10) NOT NULL DEFAULT '0',
209 `honorYesterday` int(10) NOT NULL DEFAULT '0',
210 `honorPoints` int(10) NOT NULL DEFAULT '0',
211 `difficulty` int(4) NOT NULL DEFAULT '0',
212 `drunkValue` int(30) NOT NULL DEFAULT '0',
213 `glyphs1` longtext NOT NULL,
214 `talents1` longtext NOT NULL,
215 `glyphs2` longtext NOT NULL,
216 `talents2` longtext NOT NULL,
217 `numspecs` int(10) NOT NULL DEFAULT '1',
218 `currentspec` int(10) NOT NULL DEFAULT '0',
219 `talentpoint_override` longtext NOT NULL,
220 `phase` int(10) unsigned NOT NULL DEFAULT '1',
221 `CanGainXp` int(10) unsigned NOT NULL DEFAULT '1',
222 `data` longtext,
223 PRIMARY KEY (`guid`),
224 KEY `acct` (`acct`),
225 KEY `name` (`name`),
226 KEY `b` (`banned`),
227 KEY `c` (`online`),
228 KEY `d` (`forced_rename_pending`)
229) ENGINE=InnoDB DEFAULT CHARSET=latin1;
230
231DROP TABLE IF EXISTS `characters_insert_queue`;
232
233CREATE TABLE `characters_insert_queue` (
234 `insert_temp_guid` int(10) unsigned NOT NULL DEFAULT '0',
235 `acct` int(10) unsigned NOT NULL DEFAULT '0',
236 `name` varchar(21) COLLATE utf8_unicode_ci NOT NULL,
237 `race` tinyint(3) unsigned NOT NULL DEFAULT '0',
238 `class` tinyint(3) unsigned NOT NULL DEFAULT '0',
239 `gender` tinyint(3) unsigned NOT NULL DEFAULT '0',
240 `custom_faction` int(30) NOT NULL DEFAULT '0',
241 `level` int(10) unsigned NOT NULL DEFAULT '0',
242 `xp` int(10) unsigned NOT NULL DEFAULT '0',
243 `exploration_data` longtext COLLATE utf8_unicode_ci NOT NULL,
244 `skills` longtext COLLATE utf8_unicode_ci NOT NULL,
245 `watched_faction_index` int(10) unsigned NOT NULL DEFAULT '0',
246 `selected_pvp_title` int(10) unsigned NOT NULL DEFAULT '0',
247 `available_pvp_titles` int(10) unsigned NOT NULL DEFAULT '0',
248 `gold` int(10) unsigned NOT NULL DEFAULT '0',
249 `ammo_id` int(10) unsigned NOT NULL DEFAULT '0',
250 `available_prof_points` int(10) unsigned NOT NULL DEFAULT '0',
251 `available_talent_points` int(10) unsigned NOT NULL DEFAULT '0',
252 `current_hp` int(10) unsigned NOT NULL DEFAULT '0',
253 `current_power` int(10) unsigned NOT NULL DEFAULT '0',
254 `pvprank` tinyint(3) unsigned NOT NULL DEFAULT '0',
255 `bytes` int(10) unsigned NOT NULL DEFAULT '0',
256 `bytes2` int(10) unsigned NOT NULL DEFAULT '0',
257 `player_flags` int(10) unsigned NOT NULL DEFAULT '0',
258 `player_bytes` int(10) unsigned NOT NULL DEFAULT '0',
259 `positionX` float NOT NULL DEFAULT '0',
260 `positionY` float NOT NULL DEFAULT '0',
261 `positionZ` float NOT NULL DEFAULT '0',
262 `orientation` float NOT NULL DEFAULT '0',
263 `mapId` int(10) unsigned NOT NULL DEFAULT '0',
264 `zoneId` int(10) unsigned NOT NULL DEFAULT '0',
265 `taximask` longtext COLLATE utf8_unicode_ci NOT NULL,
266 `banned` int(40) NOT NULL,
267 `banReason` varchar(50) COLLATE utf8_unicode_ci NOT NULL,
268 `timestamp` int(11) NOT NULL,
269 `online` int(11) DEFAULT NULL,
270 `bindpositionX` float NOT NULL DEFAULT '0',
271 `bindpositionY` float NOT NULL DEFAULT '0',
272 `bindpositionZ` float NOT NULL DEFAULT '0',
273 `bindmapId` int(10) unsigned NOT NULL DEFAULT '0',
274 `bindzoneId` int(10) unsigned NOT NULL DEFAULT '0',
275 `isResting` tinyint(3) unsigned NOT NULL DEFAULT '0',
276 `restState` tinyint(3) unsigned NOT NULL DEFAULT '0',
277 `restTime` int(10) unsigned NOT NULL DEFAULT '0',
278 `playedtime` longtext COLLATE utf8_unicode_ci NOT NULL,
279 `deathstate` int(10) unsigned NOT NULL DEFAULT '0',
280 `TalentResetTimes` int(10) unsigned NOT NULL DEFAULT '0',
281 `first_login` tinyint(3) unsigned NOT NULL DEFAULT '0',
282 `forced_rename_pending` tinyint(3) unsigned NOT NULL DEFAULT '0',
283 `publicNote` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
284 `officerNote` varchar(32) COLLATE utf8_unicode_ci NOT NULL,
285 `guildid` int(10) unsigned NOT NULL DEFAULT '0',
286 `guildRank` int(10) unsigned NOT NULL DEFAULT '0',
287 `arenaPoints` int(10) NOT NULL,
288 `totalstableslots` int(10) unsigned NOT NULL DEFAULT '0',
289 `instance_id` int(10) unsigned NOT NULL DEFAULT '0',
290 `entrypointmap` int(10) unsigned NOT NULL DEFAULT '0',
291 `entrypointx` float NOT NULL DEFAULT '0',
292 `entrypointy` float NOT NULL DEFAULT '0',
293 `entrypointz` float NOT NULL DEFAULT '0',
294 `entrypointo` float NOT NULL DEFAULT '0',
295 `entrypointinstance` int(10) unsigned NOT NULL DEFAULT '0',
296 `taxi_path` int(10) unsigned NOT NULL DEFAULT '0',
297 `taxi_lastnode` int(10) unsigned NOT NULL DEFAULT '0',
298 `taxi_mountid` int(10) unsigned NOT NULL DEFAULT '0',
299 `transporter` int(10) unsigned NOT NULL DEFAULT '0',
300 `transporter_xdiff` float NOT NULL DEFAULT '0',
301 `transporter_ydiff` float NOT NULL DEFAULT '0',
302 `transporter_zdiff` float NOT NULL DEFAULT '0',
303 `spells` longtext COLLATE utf8_unicode_ci NOT NULL,
304 `deleted_spells` longtext COLLATE utf8_unicode_ci NOT NULL,
305 `reputation` longtext COLLATE utf8_unicode_ci NOT NULL,
306 `actions` longtext COLLATE utf8_unicode_ci NOT NULL,
307 `auras` longtext COLLATE utf8_unicode_ci NOT NULL,
308 `finished_quests` longtext COLLATE utf8_unicode_ci NOT NULL,
309 `honorPointsToAdd` int(10) NOT NULL,
310 `killsToday` int(10) unsigned NOT NULL DEFAULT '0',
311 `killsYesterday` int(10) unsigned NOT NULL DEFAULT '0',
312 `killsLifeTime` int(10) unsigned NOT NULL DEFAULT '0',
313 `honorToday` int(10) unsigned NOT NULL DEFAULT '0',
314 `honorYesterday` int(10) unsigned NOT NULL DEFAULT '0',
315 `honorPoints` int(10) unsigned NOT NULL DEFAULT '0',
316 `difficulty` int(10) unsigned NOT NULL DEFAULT '0',
317 UNIQUE KEY `guid` (`insert_temp_guid`),
318 KEY `acct` (`acct`),
319 KEY `guildid` (`guildid`)
320) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
321
322DROP TABLE IF EXISTS `charters`;
323
324CREATE TABLE `charters` (
325 `charterId` int(30) NOT NULL,
326 `charterType` int(30) NOT NULL DEFAULT '0',
327 `leaderGuid` int(20) unsigned NOT NULL DEFAULT '0',
328 `guildName` varchar(32) NOT NULL DEFAULT '',
329 `itemGuid` bigint(40) unsigned NOT NULL DEFAULT '0',
330 `signer1` int(10) unsigned NOT NULL DEFAULT '0',
331 `signer2` int(10) unsigned NOT NULL DEFAULT '0',
332 `signer3` int(10) unsigned NOT NULL DEFAULT '0',
333 `signer4` int(10) unsigned NOT NULL DEFAULT '0',
334 `signer5` int(10) unsigned NOT NULL DEFAULT '0',
335 `signer6` int(10) unsigned NOT NULL DEFAULT '0',
336 `signer7` int(10) unsigned NOT NULL DEFAULT '0',
337 `signer8` int(10) unsigned NOT NULL DEFAULT '0',
338 `signer9` int(10) unsigned NOT NULL DEFAULT '0',
339 PRIMARY KEY (`charterId`),
340 UNIQUE KEY `leaderGuid` (`charterType`,`leaderGuid`)
341) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='InnoDB free: 11264 kB; InnoDB free: 18432 kB';
342
343DROP TABLE IF EXISTS `clientaddons`;
344
345CREATE TABLE `clientaddons` (
346 `id` int(10) NOT NULL AUTO_INCREMENT,
347 `name` varchar(50) DEFAULT NULL,
348 `crc` bigint(50) DEFAULT NULL,
349 `banned` int(1) NOT NULL DEFAULT '0',
350 `showinlist` int(1) NOT NULL DEFAULT '0',
351 PRIMARY KEY (`id`),
352 KEY `index` (`name`)
353) ENGINE=InnoDB DEFAULT CHARSET=latin1;
354
355DROP TABLE IF EXISTS `command_overrides`;
356
357CREATE TABLE `command_overrides` (
358 `command_name` varchar(100) NOT NULL,
359 `access_level` varchar(10) NOT NULL,
360 PRIMARY KEY (`command_name`)
361) ENGINE=InnoDB DEFAULT CHARSET=latin1;
362
363DROP TABLE IF EXISTS `corpses`;
364
365CREATE TABLE `corpses` (
366 `guid` bigint(20) unsigned NOT NULL DEFAULT '0',
367 `positionX` float NOT NULL DEFAULT '0',
368 `positionY` float NOT NULL DEFAULT '0',
369 `positionZ` float NOT NULL DEFAULT '0',
370 `orientation` float NOT NULL DEFAULT '0',
371 `zoneId` int(11) NOT NULL DEFAULT '38',
372 `mapId` int(11) NOT NULL DEFAULT '0',
373 `instanceId` int(11) NOT NULL DEFAULT '0',
374 `data` longtext NOT NULL,
375 PRIMARY KEY (`guid`),
376 KEY `b` (`instanceId`)
377) ENGINE=InnoDB DEFAULT CHARSET=latin1;
378
379DROP TABLE IF EXISTS `equipmentsets`;
380
381CREATE TABLE `equipmentsets` (
382 `ownerguid` int(10) unsigned NOT NULL DEFAULT '1',
383 `setGUID` int(10) unsigned NOT NULL DEFAULT '1',
384 `setid` int(10) unsigned NOT NULL DEFAULT '1',
385 `setname` varchar(16) NOT NULL DEFAULT '',
386 `iconname` varchar(100) NOT NULL DEFAULT '',
387 `head` int(10) unsigned NOT NULL DEFAULT '0',
388 `neck` int(10) unsigned NOT NULL DEFAULT '0',
389 `shoulders` int(10) unsigned NOT NULL DEFAULT '0',
390 `body` int(10) unsigned NOT NULL DEFAULT '0',
391 `chest` int(10) unsigned NOT NULL DEFAULT '0',
392 `waist` int(10) unsigned NOT NULL DEFAULT '0',
393 `legs` int(10) unsigned NOT NULL DEFAULT '0',
394 `feet` int(10) unsigned NOT NULL DEFAULT '0',
395 `wrists` int(10) unsigned NOT NULL DEFAULT '0',
396 `hands` int(10) unsigned NOT NULL DEFAULT '0',
397 `finger1` int(10) unsigned NOT NULL DEFAULT '0',
398 `finger2` int(10) unsigned NOT NULL DEFAULT '0',
399 `trinket1` int(10) unsigned NOT NULL DEFAULT '0',
400 `trinket2` int(10) unsigned NOT NULL DEFAULT '0',
401 `back` int(10) unsigned NOT NULL DEFAULT '0',
402 `mainhand` int(10) unsigned NOT NULL DEFAULT '0',
403 `offhand` int(10) unsigned NOT NULL DEFAULT '0',
404 `ranged` int(10) unsigned NOT NULL DEFAULT '0',
405 `tabard` int(10) unsigned NOT NULL DEFAULT '0',
406 PRIMARY KEY (`ownerguid`,`setGUID`,`setid`)
407) ENGINE=InnoDB DEFAULT CHARSET=latin1;
408
409DROP TABLE IF EXISTS `gm_tickets`;
410
411CREATE TABLE `gm_tickets` (
412 `ticketid` int(11) NOT NULL,
413 `playerGuid` int(11) NOT NULL,
414 `name` varchar(200) NOT NULL DEFAULT '',
415 `level` int(6) NOT NULL DEFAULT '0',
416 `map` int(11) NOT NULL DEFAULT '0',
417 `posX` float NOT NULL DEFAULT '0',
418 `posY` float NOT NULL DEFAULT '0',
419 `posZ` float NOT NULL DEFAULT '0',
420 `message` text NOT NULL,
421 `timestamp` text,
422 `deleted` int UNSIGNED NOT NULL DEFAULT '0',
423 `assignedto` int(11) NOT NULL DEFAULT '0',
424 `comment` text NOT NULL,
425 UNIQUE KEY `guid` (`ticketid`),
426 UNIQUE KEY `guid_2` (`ticketid`)
427) ENGINE=InnoDB DEFAULT CHARSET=latin1;
428
429DROP TABLE IF EXISTS `groups`;
430
431CREATE TABLE `groups` (
432 `group_id` int(30) NOT NULL,
433 `group_type` tinyint(2) NOT NULL,
434 `subgroup_count` tinyint(2) NOT NULL,
435 `loot_method` tinyint(2) NOT NULL,
436 `loot_threshold` tinyint(2) NOT NULL,
437 `difficulty` int(30) NOT NULL DEFAULT '0',
438 `raiddifficulty` int(30) NOT NULL DEFAULT '0',
439 `assistant_leader` int(30) NOT NULL DEFAULT '0',
440 `main_tank` int(30) NOT NULL DEFAULT '0',
441 `main_assist` int(30) NOT NULL DEFAULT '0',
442 `group1member1` int(50) NOT NULL,
443 `group1member2` int(50) NOT NULL,
444 `group1member3` int(50) NOT NULL,
445 `group1member4` int(50) NOT NULL,
446 `group1member5` int(50) NOT NULL,
447 `group2member1` int(50) NOT NULL,
448 `group2member2` int(50) NOT NULL,
449 `group2member3` int(50) NOT NULL,
450 `group2member4` int(50) NOT NULL,
451 `group2member5` int(50) NOT NULL,
452 `group3member1` int(50) NOT NULL,
453 `group3member2` int(50) NOT NULL,
454 `group3member3` int(50) NOT NULL,
455 `group3member4` int(50) NOT NULL,
456 `group3member5` int(50) NOT NULL,
457 `group4member1` int(50) NOT NULL,
458 `group4member2` int(50) NOT NULL,
459 `group4member3` int(50) NOT NULL,
460 `group4member4` int(50) NOT NULL,
461 `group4member5` int(50) NOT NULL,
462 `group5member1` int(50) NOT NULL,
463 `group5member2` int(50) NOT NULL,
464 `group5member3` int(50) NOT NULL,
465 `group5member4` int(50) NOT NULL,
466 `group5member5` int(50) NOT NULL,
467 `group6member1` int(50) NOT NULL,
468 `group6member2` int(50) NOT NULL,
469 `group6member3` int(50) NOT NULL,
470 `group6member4` int(50) NOT NULL,
471 `group6member5` int(50) NOT NULL,
472 `group7member1` int(50) NOT NULL,
473 `group7member2` int(50) NOT NULL,
474 `group7member3` int(50) NOT NULL,
475 `group7member4` int(50) NOT NULL,
476 `group7member5` int(50) NOT NULL,
477 `group8member1` int(50) NOT NULL,
478 `group8member2` int(50) NOT NULL,
479 `group8member3` int(50) NOT NULL,
480 `group8member4` int(50) NOT NULL,
481 `group8member5` int(50) NOT NULL,
482 `timestamp` int(30) NOT NULL,
483 `instanceids` text NOT NULL,
484 PRIMARY KEY (`group_id`)
485) ENGINE=InnoDB DEFAULT CHARSET=latin1;
486
487DROP TABLE IF EXISTS `guild_bankitems`;
488
489CREATE TABLE `guild_bankitems` (
490 `guildId` int(30) NOT NULL,
491 `tabId` int(30) NOT NULL,
492 `slotId` int(30) NOT NULL,
493 `itemGuid` int(30) NOT NULL,
494 PRIMARY KEY (`guildId`,`tabId`,`slotId`),
495 KEY `a` (`guildId`),
496 KEY `b` (`tabId`),
497 KEY `c` (`slotId`)
498) ENGINE=InnoDB DEFAULT CHARSET=latin1;
499
500DROP TABLE IF EXISTS `guild_banklogs`;
501
502CREATE TABLE `guild_banklogs` (
503 `log_id` int(30) NOT NULL,
504 `guildid` int(30) NOT NULL,
505 `tabid` int(30) NOT NULL COMMENT 'tab 6 is money logs',
506 `action` int(5) NOT NULL,
507 `player_guid` int(30) NOT NULL,
508 `item_entry` int(30) NOT NULL,
509 `stack_count` int(30) NOT NULL,
510 `timestamp` int(30) NOT NULL,
511 PRIMARY KEY (`log_id`,`guildid`),
512 KEY `a` (`guildid`),
513 KEY `b` (`tabid`)
514) ENGINE=InnoDB DEFAULT CHARSET=latin1;
515
516DROP TABLE IF EXISTS `guild_banktabs`;
517
518CREATE TABLE `guild_banktabs` (
519 `guildId` int(30) NOT NULL,
520 `tabId` int(30) NOT NULL,
521 `tabName` varchar(200) NOT NULL,
522 `tabIcon` varchar(200) NOT NULL,
523 `tabInfo` varchar(200) NOT NULL,
524 PRIMARY KEY (`guildId`,`tabId`),
525 KEY `a` (`guildId`),
526 KEY `b` (`tabId`)
527) ENGINE=InnoDB DEFAULT CHARSET=latin1;
528
529DROP TABLE IF EXISTS `guild_data`;
530
531CREATE TABLE `guild_data` (
532 `guildid` int(30) NOT NULL,
533 `playerid` int(30) NOT NULL,
534 `guildRank` int(30) NOT NULL,
535 `publicNote` varchar(300) NOT NULL,
536 `officerNote` varchar(300) NOT NULL,
537 `lastWithdrawReset` int(30) NOT NULL DEFAULT '0',
538 `withdrawlsSinceLastReset` int(30) NOT NULL DEFAULT '0',
539 `lastItemWithdrawReset0` int(30) NOT NULL DEFAULT '0',
540 `itemWithdrawlsSinceLastReset0` int(30) NOT NULL DEFAULT '0',
541 `lastItemWithdrawReset1` int(30) NOT NULL,
542 `itemWithdrawlsSinceLastReset1` int(30) NOT NULL,
543 `lastItemWithdrawReset2` int(30) NOT NULL,
544 `itemWithdrawlsSinceLastReset2` int(30) NOT NULL,
545 `lastItemWithdrawReset3` int(30) NOT NULL,
546 `itemWithdrawlsSinceLastReset3` int(30) NOT NULL,
547 `lastItemWithdrawReset4` int(30) NOT NULL,
548 `itemWithdrawlsSinceLastReset4` int(30) NOT NULL,
549 `lastItemWithdrawReset5` int(30) NOT NULL,
550 `itemWithdrawlsSinceLastReset5` int(30) NOT NULL,
551 KEY `a` (`guildid`),
552 KEY `b` (`playerid`)
553) ENGINE=InnoDB DEFAULT CHARSET=latin1;
554
555DROP TABLE IF EXISTS `guild_logs`;
556
557CREATE TABLE `guild_logs` (
558 `log_id` int(30) NOT NULL,
559 `guildid` int(30) NOT NULL,
560 `timestamp` int(30) NOT NULL,
561 `event_type` int(30) NOT NULL,
562 `misc1` int(30) NOT NULL,
563 `misc2` int(30) NOT NULL,
564 `misc3` int(30) NOT NULL,
565 PRIMARY KEY (`log_id`,`guildid`)
566) ENGINE=InnoDB DEFAULT CHARSET=latin1;
567
568DROP TABLE IF EXISTS `guild_ranks`;
569
570CREATE TABLE `guild_ranks` (
571 `guildId` int(6) unsigned NOT NULL DEFAULT '0',
572 `rankId` int(1) NOT NULL DEFAULT '0',
573 `rankName` varchar(255) NOT NULL DEFAULT '',
574 `rankRights` int(3) unsigned NOT NULL DEFAULT '0',
575 `goldLimitPerDay` int(30) NOT NULL DEFAULT '0',
576 `bankTabFlags0` int(30) NOT NULL DEFAULT '0',
577 `itemStacksPerDay0` int(30) NOT NULL DEFAULT '0',
578 `bankTabFlags1` int(30) NOT NULL DEFAULT '0',
579 `itemStacksPerDay1` int(30) NOT NULL DEFAULT '0',
580 `bankTabFlags2` int(30) NOT NULL DEFAULT '0',
581 `itemStacksPerDay2` int(30) NOT NULL DEFAULT '0',
582 `bankTabFlags3` int(30) NOT NULL DEFAULT '0',
583 `itemStacksPerDay3` int(30) NOT NULL DEFAULT '0',
584 `bankTabFlags4` int(30) NOT NULL DEFAULT '0',
585 `itemStacksPerDay4` int(30) NOT NULL DEFAULT '0',
586 `bankTabFlags5` int(30) NOT NULL DEFAULT '0',
587 `itemStacksPerDay5` int(30) NOT NULL DEFAULT '0',
588 PRIMARY KEY (`guildId`,`rankId`)
589) ENGINE=InnoDB DEFAULT CHARSET=latin1;
590
591DROP TABLE IF EXISTS `guilds`;
592
593CREATE TABLE `guilds` (
594 `guildId` bigint(20) NOT NULL AUTO_INCREMENT,
595 `guildName` varchar(32) NOT NULL DEFAULT '',
596 `leaderGuid` bigint(20) NOT NULL DEFAULT '0',
597 `emblemStyle` int(10) NOT NULL DEFAULT '0',
598 `emblemColor` int(10) NOT NULL DEFAULT '0',
599 `borderStyle` int(10) NOT NULL DEFAULT '0',
600 `borderColor` int(10) NOT NULL DEFAULT '0',
601 `backgroundColor` int(10) NOT NULL DEFAULT '0',
602 `guildInfo` varchar(300) NOT NULL DEFAULT '',
603 `motd` varchar(300) NOT NULL DEFAULT '',
604 `createdate` int(30) NOT NULL,
605 `bankBalance` bigint(30) unsigned NOT NULL,
606 PRIMARY KEY (`guildId`),
607 UNIQUE KEY `guildId` (`guildId`)
608) ENGINE=InnoDB DEFAULT CHARSET=latin1;
609
610DROP TABLE IF EXISTS `instanceids`;
611
612CREATE TABLE `instanceids` (
613 `playerguid` int(11) unsigned NOT NULL DEFAULT '0',
614 `mapid` int(11) unsigned NOT NULL DEFAULT '0',
615 `mode` int(11) unsigned NOT NULL DEFAULT '0',
616 `instanceid` int(11) unsigned NOT NULL DEFAULT '0',
617 PRIMARY KEY (`playerguid`,`mapid`,`mode`),
618 KEY `ix_instanceid` (`playerguid`)
619) ENGINE=InnoDB DEFAULT CHARSET=latin1 COMMENT='Player / InstanceID - Reference Table';
620
621DROP TABLE IF EXISTS `instances`;
622
623CREATE TABLE `instances` (
624 `id` int(30) NOT NULL,
625 `mapid` int(30) NOT NULL,
626 `creation` int(30) NOT NULL,
627 `expiration` int(30) NOT NULL,
628 `killed_npc_guids` text NOT NULL,
629 `difficulty` int(30) NOT NULL,
630 `creator_group` int(30) NOT NULL,
631 `creator_guid` int(30) NOT NULL,
632 `persistent` tinyint(4) NOT NULL DEFAULT '0',
633 PRIMARY KEY (`id`),
634 KEY `a` (`mapid`)
635) ENGINE=InnoDB DEFAULT CHARSET=latin1;
636
637DROP TABLE IF EXISTS `mailbox`;
638
639CREATE TABLE `mailbox` (
640 `message_id` int(30) NOT NULL DEFAULT '0',
641 `message_type` int(30) NOT NULL DEFAULT '0',
642 `player_guid` int(30) NOT NULL DEFAULT '0',
643 `sender_guid` int(30) NOT NULL DEFAULT '0',
644 `subject` varchar(255) NOT NULL DEFAULT '',
645 `body` longtext NOT NULL,
646 `money` int(30) NOT NULL DEFAULT '0',
647 `attached_item_guids` varchar(200) NOT NULL DEFAULT '',
648 `cod` int(30) NOT NULL DEFAULT '0',
649 `stationary` int(30) NOT NULL DEFAULT '0',
650 `expiry_time` int(30) NOT NULL DEFAULT '0',
651 `delivery_time` int(30) NOT NULL DEFAULT '0',
652 `copy_made` int(30) NOT NULL DEFAULT '0',
653 `read_flag` int(30) NOT NULL DEFAULT '0',
654 `deleted_flag` int(30) NOT NULL DEFAULT '0',
655 PRIMARY KEY (`message_id`),
656 KEY `b` (`player_guid`)
657) ENGINE=InnoDB DEFAULT CHARSET=latin1;
658
659DROP TABLE IF EXISTS `mailbox_insert_queue`;
660
661CREATE TABLE `mailbox_insert_queue` (
662 `sender_guid` int(30) NOT NULL,
663 `receiver_guid` int(30) NOT NULL,
664 `subject` varchar(200) NOT NULL,
665 `body` varchar(500) NOT NULL,
666 `stationary` int(30) NOT NULL,
667 `money` int(30) NOT NULL,
668 `item_id` int(30) NOT NULL,
669 `item_stack` int(30) NOT NULL
670) ENGINE=InnoDB DEFAULT CHARSET=latin1;
671
672DROP TABLE IF EXISTS `playercooldowns`;
673
674CREATE TABLE `playercooldowns` (
675 `player_guid` int(30) NOT NULL,
676 `cooldown_type` int(30) NOT NULL COMMENT '0 is spell, 1 is item, 2 is spell category',
677 `cooldown_misc` int(30) NOT NULL COMMENT 'spellid/itemid/category',
678 `cooldown_expire_time` int(30) NOT NULL COMMENT 'expiring time in unix epoch format',
679 `cooldown_spellid` int(30) NOT NULL COMMENT 'spell that cast it',
680 `cooldown_itemid` int(30) NOT NULL COMMENT 'item that cast it'
681) ENGINE=InnoDB DEFAULT CHARSET=utf8;
682
683DROP TABLE IF EXISTS `playeritems`;
684
685CREATE TABLE `playeritems` (
686 `ownerguid` int(10) unsigned NOT NULL DEFAULT '0',
687 `guid` bigint(10) NOT NULL AUTO_INCREMENT,
688 `entry` int(10) unsigned NOT NULL DEFAULT '0',
689 `wrapped_item_id` int(30) NOT NULL DEFAULT '0',
690 `wrapped_creator` int(30) NOT NULL DEFAULT '0',
691 `creator` int(10) unsigned NOT NULL DEFAULT '0',
692 `count` int(10) unsigned NOT NULL DEFAULT '0',
693 `charges` int(10) NOT NULL DEFAULT '0',
694 `flags` int(10) unsigned NOT NULL DEFAULT '0',
695 `randomprop` int(10) unsigned NOT NULL DEFAULT '0',
696 `randomsuffix` int(10) NOT NULL,
697 `itemtext` int(10) unsigned NOT NULL DEFAULT '0',
698 `durability` int(10) unsigned NOT NULL DEFAULT '0',
699 `containerslot` int(11) DEFAULT '-1',
700 `slot` int(10) NOT NULL DEFAULT '0',
701 `enchantments` longtext NOT NULL,
702 `duration_expireson` int(10) unsigned NOT NULL DEFAULT '0',
703 `refund_purchasedon` int(10) unsigned NOT NULL DEFAULT '0',
704 `refund_costid` int(10) unsigned NOT NULL DEFAULT '0',
705 PRIMARY KEY (`guid`),
706 KEY `ownerguid` (`ownerguid`),
707 KEY `itemtext` (`itemtext`)
708) ENGINE=InnoDB AUTO_INCREMENT=135 DEFAULT CHARSET=latin1;
709
710DROP TABLE IF EXISTS `playeritems_insert_queue`;
711
712CREATE TABLE `playeritems_insert_queue` (
713 `ownerguid` int(10) unsigned NOT NULL DEFAULT '0',
714 `entry` int(10) unsigned NOT NULL DEFAULT '0',
715 `wrapped_item_id` int(30) NOT NULL DEFAULT '0',
716 `wrapped_creator` int(30) NOT NULL DEFAULT '0',
717 `creator` int(10) unsigned NOT NULL DEFAULT '0',
718 `count` int(10) unsigned NOT NULL DEFAULT '0',
719 `charges` int(10) unsigned NOT NULL DEFAULT '0',
720 `flags` int(10) unsigned NOT NULL DEFAULT '0',
721 `randomprop` int(10) unsigned NOT NULL DEFAULT '0',
722 `randomsuffix` int(30) NOT NULL,
723 `itemtext` int(10) unsigned NOT NULL DEFAULT '0',
724 `durability` int(10) unsigned NOT NULL DEFAULT '0',
725 `containerslot` int(11) NOT NULL DEFAULT '-1' COMMENT 'couldnt find this being used in source',
726 `slot` tinyint(4) NOT NULL DEFAULT '0',
727 `enchantments` longtext COLLATE utf8_unicode_ci NOT NULL,
728 KEY `ownerguid` (`ownerguid`)
729) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
730
731DROP TABLE IF EXISTS `playerpets`;
732
733CREATE TABLE `playerpets` (
734 `ownerguid` bigint(20) NOT NULL DEFAULT '0',
735 `petnumber` int(11) NOT NULL DEFAULT '0',
736 `name` varchar(21) NOT NULL DEFAULT '',
737 `entry` int(10) unsigned NOT NULL DEFAULT '0',
738 `xp` int(11) NOT NULL DEFAULT '0',
739 `active` tinyint(1) NOT NULL DEFAULT '0',
740 `level` int(11) NOT NULL DEFAULT '0',
741 `actionbar` varchar(200) NOT NULL DEFAULT '',
742 `happinessupdate` int(11) NOT NULL DEFAULT '0',
743 `reset_time` int(10) unsigned NOT NULL DEFAULT '0',
744 `reset_cost` int(10) NOT NULL DEFAULT '0',
745 `spellid` int(10) unsigned NOT NULL DEFAULT '0',
746 `petstate` int(10) unsigned NOT NULL DEFAULT '0',
747 `alive` tinyint(1) NOT NULL DEFAULT '1',
748 `talentpoints` int(10) unsigned NOT NULL DEFAULT '0',
749 `current_power` int(10) unsigned NOT NULL DEFAULT '1',
750 `current_hp` int(10) unsigned NOT NULL DEFAULT '1',
751 `current_happiness` int(10) unsigned NOT NULL DEFAULT '1000000',
752 `renamable` int(10) unsigned NOT NULL DEFAULT '1',
753 `type` int(10) unsigned DEFAULT '1' NOT NULL,
754 PRIMARY KEY (`ownerguid`,`petnumber`)
755) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
756
757DROP TABLE IF EXISTS `playerpetspells`;
758
759CREATE TABLE `playerpetspells` (
760 `ownerguid` bigint(20) NOT NULL DEFAULT '0',
761 `petnumber` int(4) NOT NULL DEFAULT '0',
762 `spellid` int(4) NOT NULL DEFAULT '0',
763 `flags` int(4) NOT NULL DEFAULT '0',
764 KEY `a` (`ownerguid`),
765 KEY `b` (`petnumber`)
766) ENGINE=InnoDB DEFAULT CHARSET=latin1;
767
768DROP TABLE IF EXISTS `playersummons`;
769
770CREATE TABLE `playersummons` (
771 `ownerguid` int(11) unsigned NOT NULL DEFAULT '0',
772 `entry` int(11) unsigned NOT NULL DEFAULT '0',
773 `name` varchar(64) NOT NULL,
774 KEY `a` (`ownerguid`)
775) ENGINE=InnoDB DEFAULT CHARSET=utf8;
776
777DROP TABLE IF EXISTS `playersummonspells`;
778
779CREATE TABLE `playersummonspells` (
780 `ownerguid` bigint(20) NOT NULL DEFAULT '0',
781 `entryid` int(4) NOT NULL DEFAULT '0',
782 `spellid` int(4) NOT NULL DEFAULT '0',
783 KEY `a` (`ownerguid`)
784) ENGINE=InnoDB DEFAULT CHARSET=latin1;
785
786DROP TABLE IF EXISTS `questlog`;
787
788CREATE TABLE `questlog` (
789 `player_guid` bigint(20) unsigned NOT NULL DEFAULT '0',
790 `quest_id` bigint(20) unsigned NOT NULL DEFAULT '0',
791 `slot` int(20) unsigned NOT NULL DEFAULT '0',
792 `time_left` bigint(20) NOT NULL DEFAULT '0',
793 `explored_area1` bigint(20) unsigned NOT NULL DEFAULT '0',
794 `explored_area2` bigint(20) unsigned NOT NULL DEFAULT '0',
795 `explored_area3` bigint(20) unsigned NOT NULL DEFAULT '0',
796 `explored_area4` bigint(20) unsigned NOT NULL DEFAULT '0',
797 `mob_kill1` bigint(20) NOT NULL DEFAULT '0',
798 `mob_kill2` bigint(20) NOT NULL DEFAULT '0',
799 `mob_kill3` bigint(20) NOT NULL DEFAULT '0',
800 `mob_kill4` bigint(20) NOT NULL DEFAULT '0',
801 `completed` int(10) unsigned NOT NULL DEFAULT '0',
802 PRIMARY KEY (`player_guid`,`quest_id`)
803) ENGINE=InnoDB DEFAULT CHARSET=latin1;
804
805DROP TABLE IF EXISTS `server_settings`;
806
807CREATE TABLE `server_settings` (
808 `setting_id` varchar(200) NOT NULL,
809 `setting_value` int(50) NOT NULL,
810 PRIMARY KEY (`setting_id`)
811) ENGINE=InnoDB DEFAULT CHARSET=latin1;
812
813DROP TABLE IF EXISTS `social_friends`;
814
815CREATE TABLE `social_friends` (
816 `character_guid` int(30) NOT NULL,
817 `friend_guid` int(30) NOT NULL,
818 `note` varchar(100) NOT NULL,
819 PRIMARY KEY (`character_guid`,`friend_guid`),
820 KEY `a` (`character_guid`),
821 KEY `b` (`friend_guid`)
822) ENGINE=InnoDB DEFAULT CHARSET=utf8;
823
824DROP TABLE IF EXISTS `social_ignores`;
825
826CREATE TABLE `social_ignores` (
827 `character_guid` int(30) NOT NULL,
828 `ignore_guid` int(30) NOT NULL,
829 PRIMARY KEY (`character_guid`,`ignore_guid`),
830 KEY `a` (`character_guid`)
831) ENGINE=InnoDB DEFAULT CHARSET=utf8;
832
833DROP TABLE IF EXISTS `tutorials`;
834
835CREATE TABLE `tutorials` (
836 `playerId` bigint(20) unsigned NOT NULL DEFAULT '0',
837 `tut0` bigint(20) unsigned NOT NULL DEFAULT '0',
838 `tut1` bigint(20) unsigned NOT NULL DEFAULT '0',
839 `tut2` bigint(20) unsigned NOT NULL DEFAULT '0',
840 `tut3` bigint(20) unsigned NOT NULL DEFAULT '0',
841 `tut4` bigint(20) unsigned NOT NULL DEFAULT '0',
842 `tut5` bigint(20) unsigned NOT NULL DEFAULT '0',
843 `tut6` bigint(20) unsigned NOT NULL DEFAULT '0',
844 `tut7` bigint(20) unsigned NOT NULL DEFAULT '0',
845 PRIMARY KEY (`playerId`)
846) ENGINE=InnoDB DEFAULT CHARSET=latin1;