root/trunk/sql/characters.sql @ 44

Revision 44, 40.7 kB (checked in by yumileroy, 17 years ago)

[svn] * Merge Temp dev SVN with Assembla.
* Changes include:

  • Implementation of w12x's Outdoor PvP and Game Event Systems.
  • Temporary removal of IRC Chat Bot (until infinite loop when disabled is fixed).
  • All mangos -> trinity (to convert your mangos_string table, please run mangos_string_to_trinity_string.sql).
  • Improved Config cleanup.
  • And many more changes.

Original author: Seline
Date: 2008-10-14 11:57:03-05:00
Line 
1-- MySQL dump 10.11
2--
3-- Host: localhost    Database: characters
4-- ------------------------------------------------------
5-- Server version       5.0.45-Debian_1ubuntu3.1-log
6
7/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10/*!40101 SET NAMES utf8 */;
11/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12/*!40103 SET TIME_ZONE='+00:00' */;
13/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17
18--
19-- Table structure for table `arena_team`
20--
21
22DROP TABLE IF EXISTS `arena_team`;
23CREATE TABLE `arena_team` (
24  `arenateamid` int(10) unsigned NOT NULL default '0',
25  `name` char(255) NOT NULL,
26  `captainguid` int(10) unsigned NOT NULL default '0',
27  `type` tinyint(3) unsigned NOT NULL default '0',
28  `BackgroundColor` int(10) unsigned NOT NULL default '0',
29  `EmblemStyle` int(10) unsigned NOT NULL default '0',
30  `EmblemColor` int(10) unsigned NOT NULL default '0',
31  `BorderStyle` int(10) unsigned NOT NULL default '0',
32  `BorderColor` int(10) unsigned NOT NULL default '0',
33  PRIMARY KEY  (`arenateamid`)
34) ENGINE=InnoDB DEFAULT CHARSET=utf8;
35
36--
37-- Dumping data for table `arena_team`
38--
39
40LOCK TABLES `arena_team` WRITE;
41/*!40000 ALTER TABLE `arena_team` DISABLE KEYS */;
42/*!40000 ALTER TABLE `arena_team` ENABLE KEYS */;
43UNLOCK TABLES;
44
45--
46-- Table structure for table `arena_team_member`
47--
48
49DROP TABLE IF EXISTS `arena_team_member`;
50CREATE TABLE `arena_team_member` (
51  `arenateamid` int(10) unsigned NOT NULL default '0',
52  `guid` int(10) unsigned NOT NULL default '0',
53  `played_week` int(10) unsigned NOT NULL default '0',
54  `wons_week` int(10) unsigned NOT NULL default '0',
55  `played_season` int(10) unsigned NOT NULL default '0',
56  `wons_season` int(10) unsigned NOT NULL default '0',
57  `points_to_add` int(10) unsigned NOT NULL default '0'
58) ENGINE=InnoDB DEFAULT CHARSET=utf8;
59
60--
61-- Dumping data for table `arena_team_member`
62--
63
64LOCK TABLES `arena_team_member` WRITE;
65/*!40000 ALTER TABLE `arena_team_member` DISABLE KEYS */;
66/*!40000 ALTER TABLE `arena_team_member` ENABLE KEYS */;
67UNLOCK TABLES;
68
69--
70-- Table structure for table `arena_team_stats`
71--
72
73DROP TABLE IF EXISTS `arena_team_stats`;
74CREATE TABLE `arena_team_stats` (
75  `arenateamid` int(10) unsigned NOT NULL default '0',
76  `rating` int(10) unsigned NOT NULL default '0',
77  `games` int(10) unsigned NOT NULL default '0',
78  `wins` int(10) unsigned NOT NULL default '0',
79  `played` int(10) unsigned NOT NULL default '0',
80  `wins2` int(10) unsigned NOT NULL default '0',
81  `rank` int(10) unsigned NOT NULL default '0',
82  PRIMARY KEY  (`arenateamid`)
83) ENGINE=InnoDB DEFAULT CHARSET=utf8;
84
85--
86-- Dumping data for table `arena_team_stats`
87--
88
89LOCK TABLES `arena_team_stats` WRITE;
90/*!40000 ALTER TABLE `arena_team_stats` DISABLE KEYS */;
91/*!40000 ALTER TABLE `arena_team_stats` ENABLE KEYS */;
92UNLOCK TABLES;
93
94--
95-- Table structure for table `auctionhouse`
96--
97
98DROP TABLE IF EXISTS `auctionhouse`;
99CREATE TABLE `auctionhouse` (
100  `id` int(11) unsigned NOT NULL default '0',
101  `auctioneerguid` int(11) unsigned NOT NULL default '0',
102  `itemguid` int(11) unsigned NOT NULL default '0',
103  `item_template` int(11) unsigned NOT NULL default '0' COMMENT 'Item Identifier',
104  `itemowner` int(11) unsigned NOT NULL default '0',
105  `buyoutprice` int(11) NOT NULL default '0',
106  `time` bigint(40) NOT NULL default '0',
107  `buyguid` int(11) unsigned NOT NULL default '0',
108  `lastbid` int(11) NOT NULL default '0',
109  `startbid` int(11) NOT NULL default '0',
110  `deposit` int(11) NOT NULL default '0',
111  `location` tinyint(3) unsigned NOT NULL default '3',
112  PRIMARY KEY  (`id`),
113  UNIQUE KEY `item_guid` (`itemguid`)
114) ENGINE=InnoDB DEFAULT CHARSET=utf8;
115
116--
117-- Dumping data for table `auctionhouse`
118--
119
120LOCK TABLES `auctionhouse` WRITE;
121/*!40000 ALTER TABLE `auctionhouse` DISABLE KEYS */;
122/*!40000 ALTER TABLE `auctionhouse` ENABLE KEYS */;
123UNLOCK TABLES;
124
125--
126-- Table structure for table `bugreport`
127--
128
129DROP TABLE IF EXISTS `bugreport`;
130CREATE TABLE `bugreport` (
131  `id` int(11) NOT NULL auto_increment COMMENT 'Identifier',
132  `type` varchar(255) NOT NULL default '',
133  `content` varchar(255) NOT NULL default '',
134  PRIMARY KEY  (`id`)
135) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Debug System';
136
137--
138-- Dumping data for table `bugreport`
139--
140
141LOCK TABLES `bugreport` WRITE;
142/*!40000 ALTER TABLE `bugreport` DISABLE KEYS */;
143/*!40000 ALTER TABLE `bugreport` ENABLE KEYS */;
144UNLOCK TABLES;
145
146--
147-- Table structure for table `characters`
148--
149
150DROP TABLE IF EXISTS `characters`;
151CREATE TABLE `characters` (
152  `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
153  `account` int(11) unsigned NOT NULL default '0' COMMENT 'Account Identifier',
154  `data` longtext,
155  `name` varchar(12) NOT NULL default '',
156  `race` tinyint(3) unsigned NOT NULL default '0',
157  `class` tinyint(3) unsigned NOT NULL default '0',
158  `position_x` float NOT NULL default '0',
159  `position_y` float NOT NULL default '0',
160  `position_z` float NOT NULL default '0',
161  `map` int(11) unsigned NOT NULL default '0' COMMENT 'Map Identifier',
162  `dungeon_difficulty` tinyint(1) unsigned NOT NULL DEFAULT '0',
163  `orientation` float NOT NULL default '0',
164  `taximask` longtext,
165  `online` tinyint(3) unsigned NOT NULL default '0',
166  `cinematic` tinyint(3) unsigned NOT NULL default '0',
167  `totaltime` int(11) unsigned NOT NULL default '0',
168  `leveltime` int(11) unsigned NOT NULL default '0',
169  `logout_time` bigint(20) unsigned NOT NULL default '0',
170  `is_logout_resting` tinyint(3) unsigned NOT NULL default '0',
171  `rest_bonus` float NOT NULL default '0',
172  `resettalents_cost` int(11) unsigned NOT NULL default '0',
173  `resettalents_time` bigint(20) unsigned NOT NULL default '0',
174  `trans_x` float NOT NULL default '0',
175  `trans_y` float NOT NULL default '0',
176  `trans_z` float NOT NULL default '0',
177  `trans_o` float NOT NULL default '0',
178  `transguid` bigint(20) unsigned NOT NULL default '0',
179  `gmstate` int(11) unsigned NOT NULL default '0',
180  `stable_slots` tinyint(1) unsigned NOT NULL default '0',
181  `at_login` int(11) unsigned NOT NULL default '0',
182  `zone` int(11) unsigned NOT NULL default '0',
183  `death_expire_time` bigint(20) unsigned NOT NULL default '0',
184  `taxi_path` text,
185  PRIMARY KEY  (`guid`),
186  KEY `idx_account` (`account`),
187  KEY `idx_online` (`online`),
188  KEY `idx_name` (`name`)
189) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
190
191--
192-- Dumping data for table `characters`
193--
194
195LOCK TABLES `characters` WRITE;
196/*!40000 ALTER TABLE `characters` DISABLE KEYS */;
197/*!40000 ALTER TABLE `characters` ENABLE KEYS */;
198UNLOCK TABLES;
199
200--
201-- Table structure for table `character_action`
202--
203
204DROP TABLE IF EXISTS `character_action`;
205CREATE TABLE `character_action` (
206  `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
207  `button` tinyint(3) unsigned NOT NULL default '0',
208  `action` smallint(5) unsigned NOT NULL default '0',
209  `type` tinyint(3) unsigned NOT NULL default '0',
210  `misc` tinyint(3) unsigned NOT NULL default '0',
211  PRIMARY KEY  (`guid`,`button`)
212) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
213
214--
215-- Dumping data for table `character_action`
216--
217
218LOCK TABLES `character_action` WRITE;
219/*!40000 ALTER TABLE `character_action` DISABLE KEYS */;
220/*!40000 ALTER TABLE `character_action` ENABLE KEYS */;
221UNLOCK TABLES;
222
223--
224-- Table structure for table `character_aura`
225--
226
227DROP TABLE IF EXISTS `character_aura`;
228CREATE TABLE `character_aura` (
229  `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
230  `caster_guid` bigint(20) unsigned NOT NULL default '0' COMMENT 'Full Global Unique Identifier',
231  `spell` int(11) unsigned NOT NULL default '0',
232  `effect_index` int(11) unsigned NOT NULL default '0',
233  `amount` int(11) NOT NULL default '0',
234  `maxduration` int(11) NOT NULL default '0',
235  `remaintime` int(11) NOT NULL default '0',
236  `remaincharges` int(11) NOT NULL default '0',
237  PRIMARY KEY  (`guid`,`spell`,`effect_index`)
238) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
239
240--
241-- Dumping data for table `character_aura`
242--
243
244LOCK TABLES `character_aura` WRITE;
245/*!40000 ALTER TABLE `character_aura` DISABLE KEYS */;
246/*!40000 ALTER TABLE `character_aura` ENABLE KEYS */;
247UNLOCK TABLES;
248
249--
250-- Table structure for table `character_declinedname`
251--
252
253DROP TABLE IF EXISTS `character_declinedname`;
254CREATE TABLE `character_declinedname` (
255  `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
256  `genitive` varchar(15) NOT NULL default '',
257  `dative` varchar(15) NOT NULL default '',
258  `accusative` varchar(15) NOT NULL default '',
259  `instrumental` varchar(15) NOT NULL default '',
260  `prepositional` varchar(15) NOT NULL default '',
261  PRIMARY KEY  (`guid`)
262) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
263
264--
265-- Dumping data for table `character_declinedname`
266--
267
268LOCK TABLES `character_declinedname` WRITE;
269/*!40000 ALTER TABLE `character_declinedname` DISABLE KEYS */;
270/*!40000 ALTER TABLE `character_declinedname` ENABLE KEYS */;
271UNLOCK TABLES;
272
273--
274-- Table structure for table `character_gifts`
275--
276
277DROP TABLE IF EXISTS `character_gifts`;
278CREATE TABLE `character_gifts` (
279  `guid` int(20) unsigned NOT NULL default '0',
280  `item_guid` int(11) unsigned NOT NULL default '0',
281  `entry` int(20) unsigned NOT NULL default '0',
282  `flags` int(20) unsigned NOT NULL default '0',
283  PRIMARY KEY  (`item_guid`),
284  KEY `idx_guid` (`guid`)
285) ENGINE=InnoDB DEFAULT CHARSET=utf8;
286
287--
288-- Dumping data for table `character_gifts`
289--
290
291LOCK TABLES `character_gifts` WRITE;
292/*!40000 ALTER TABLE `character_gifts` DISABLE KEYS */;
293/*!40000 ALTER TABLE `character_gifts` ENABLE KEYS */;
294UNLOCK TABLES;
295
296--
297-- Table structure for table `character_homebind`
298--
299
300DROP TABLE IF EXISTS `character_homebind`;
301CREATE TABLE `character_homebind` (
302  `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
303  `map` int(11) unsigned NOT NULL default '0' COMMENT 'Map Identifier',
304  `zone` int(11) unsigned NOT NULL default '0' COMMENT 'Zone Identifier',
305  `position_x` float NOT NULL default '0',
306  `position_y` float NOT NULL default '0',
307  `position_z` float NOT NULL default '0',
308  PRIMARY KEY  (`guid`)
309) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
310
311--
312-- Dumping data for table `character_homebind`
313--
314
315LOCK TABLES `character_homebind` WRITE;
316/*!40000 ALTER TABLE `character_homebind` DISABLE KEYS */;
317/*!40000 ALTER TABLE `character_homebind` ENABLE KEYS */;
318UNLOCK TABLES;
319
320--
321-- Table structure for table `character_instance`
322--
323
324DROP TABLE IF EXISTS `character_instance`;
325CREATE TABLE `character_instance` (
326  `guid` int(11) unsigned NOT NULL default '0',
327  `instance` int(11) unsigned NOT NULL default '0',
328  `permanent` tinyint(1) unsigned NOT NULL default '0',
329  PRIMARY KEY  (`guid`,`instance`),
330  KEY `instance` (`instance`)
331) ENGINE=InnoDB DEFAULT CHARSET=utf8;
332
333--
334-- Dumping data for table `character_instance`
335--
336
337LOCK TABLES `character_instance` WRITE;
338/*!40000 ALTER TABLE `character_instance` DISABLE KEYS */;
339/*!40000 ALTER TABLE `character_instance` ENABLE KEYS */;
340UNLOCK TABLES;
341
342--
343-- Table structure for table `character_inventory`
344--
345
346DROP TABLE IF EXISTS `character_inventory`;
347CREATE TABLE `character_inventory` (
348  `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
349  `bag` int(11) unsigned NOT NULL default '0',
350  `slot` tinyint(3) unsigned NOT NULL default '0',
351  `item` int(11) unsigned NOT NULL default '0' COMMENT 'Item Global Unique Identifier',
352  `item_template` int(11) unsigned NOT NULL default '0' COMMENT 'Item Identifier',
353  PRIMARY KEY  (`item`),
354  KEY `idx_guid` (`guid`)
355) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
356
357--
358-- Dumping data for table `character_inventory`
359--
360
361LOCK TABLES `character_inventory` WRITE;
362/*!40000 ALTER TABLE `character_inventory` DISABLE KEYS */;
363/*!40000 ALTER TABLE `character_inventory` ENABLE KEYS */;
364UNLOCK TABLES;
365
366--
367-- Table structure for table `character_pet`
368--
369
370DROP TABLE IF EXISTS `character_pet`;
371CREATE TABLE `character_pet` (
372  `id` int(11) unsigned NOT NULL default '0',
373  `entry` int(11) unsigned NOT NULL default '0',
374  `owner` int(11) unsigned NOT NULL default '0',
375  `modelid` int(11) unsigned default '0',
376  `CreatedBySpell` int(11) unsigned NOT NULL default '0',
377  `PetType` tinyint(3) unsigned NOT NULL default '0',
378  `level` int(11) unsigned NOT NULL default '1',
379  `exp` int(11) unsigned NOT NULL default '0',
380  `Reactstate` tinyint(1) unsigned NOT NULL default '0',
381  `loyaltypoints` int(11) NOT NULL default '0',
382  `loyalty` int(11) unsigned NOT NULL default '0',
383  `trainpoint` int(11) NOT NULL default '0',
384  `name` varchar(100) default 'Pet',
385  `renamed` tinyint(1) unsigned NOT NULL default '0',
386  `slot` int(11) unsigned NOT NULL default '0',
387  `curhealth` int(11) unsigned NOT NULL default '1',
388  `curmana` int(11) unsigned NOT NULL default '0',
389  `curhappiness` int(11) unsigned NOT NULL default '0',
390  `savetime` bigint(20) unsigned NOT NULL default '0',
391  `resettalents_cost` int(11) unsigned NOT NULL default '0',
392  `resettalents_time` bigint(20) unsigned NOT NULL default '0',
393  `abdata` longtext,
394  `teachspelldata` longtext,
395  PRIMARY KEY  (`id`),
396  KEY `owner` (`owner`)
397) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Pet System';
398
399--
400-- Dumping data for table `character_pet`
401--
402
403LOCK TABLES `character_pet` WRITE;
404/*!40000 ALTER TABLE `character_pet` DISABLE KEYS */;
405/*!40000 ALTER TABLE `character_pet` ENABLE KEYS */;
406UNLOCK TABLES;
407
408--
409-- Table structure for table `character_pet_declinedname`
410--
411
412DROP TABLE IF EXISTS `character_pet_declinedname`;
413CREATE TABLE `character_pet_declinedname` (
414  `id` int(11) unsigned NOT NULL default '0',
415  `owner` int(11) unsigned NOT NULL default '0',
416  `genitive` varchar(12) NOT NULL default '',
417  `dative` varchar(12) NOT NULL default '',
418  `accusative` varchar(12) NOT NULL default '',
419  `instrumental` varchar(12) NOT NULL default '',
420  `prepositional` varchar(12) NOT NULL default '',
421  PRIMARY KEY  (`id`),
422  KEY owner_key (`owner`)
423) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
424
425--
426-- Dumping data for table `character_pet_declinedname`
427--
428
429LOCK TABLES `character_pet_declinedname` WRITE;
430/*!40000 ALTER TABLE `character_pet_declinedname` DISABLE KEYS */;
431/*!40000 ALTER TABLE `character_pet_declinedname` ENABLE KEYS */;
432UNLOCK TABLES;
433
434--
435-- Table structure for table `character_queststatus`
436--
437
438DROP TABLE IF EXISTS `character_queststatus`;
439CREATE TABLE `character_queststatus` (
440  `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
441  `quest` int(11) unsigned NOT NULL default '0' COMMENT 'Quest Identifier',
442  `status` int(11) unsigned NOT NULL default '0',
443  `rewarded` tinyint(1) unsigned NOT NULL default '0',
444  `explored` tinyint(1) unsigned NOT NULL default '0',
445  `timer` bigint(20) unsigned NOT NULL default '0',
446  `mobcount1` int(11) unsigned NOT NULL default '0',
447  `mobcount2` int(11) unsigned NOT NULL default '0',
448  `mobcount3` int(11) unsigned NOT NULL default '0',
449  `mobcount4` int(11) unsigned NOT NULL default '0',
450  `itemcount1` int(11) unsigned NOT NULL default '0',
451  `itemcount2` int(11) unsigned NOT NULL default '0',
452  `itemcount3` int(11) unsigned NOT NULL default '0',
453  `itemcount4` int(11) unsigned NOT NULL default '0',
454  PRIMARY KEY  (`guid`,`quest`)
455) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
456
457--
458-- Dumping data for table `character_queststatus`
459--
460
461LOCK TABLES `character_queststatus` WRITE;
462/*!40000 ALTER TABLE `character_queststatus` DISABLE KEYS */;
463/*!40000 ALTER TABLE `character_queststatus` ENABLE KEYS */;
464UNLOCK TABLES;
465
466--
467-- Table structure for table `character_queststatus_daily`
468--
469
470DROP TABLE IF EXISTS `character_queststatus_daily`;
471CREATE TABLE `character_queststatus_daily` (
472  `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
473  `quest` int(11) unsigned NOT NULL default '0' COMMENT 'Quest Identifier',
474  `time` bigint(20) unsigned NOT NULL default '0',
475  PRIMARY KEY  (`guid`,`quest`),
476  KEY `idx_guid` (`guid`)
477) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
478
479--
480-- Dumping data for table `character_queststatus_daily`
481--
482
483LOCK TABLES `character_queststatus_daily` WRITE;
484/*!40000 ALTER TABLE `character_queststatus_daily` DISABLE KEYS */;
485/*!40000 ALTER TABLE `character_queststatus_daily` ENABLE KEYS */;
486UNLOCK TABLES;
487
488--
489-- Table structure for table `character_reputation`
490--
491
492DROP TABLE IF EXISTS `character_reputation`;
493CREATE TABLE `character_reputation` (
494  `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
495  `faction` int(11) unsigned NOT NULL default '0',
496  `standing` int(11) NOT NULL default '0',
497  `flags` int(11) NOT NULL default '0',
498  PRIMARY KEY  (`guid`,`faction`)
499) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
500
501--
502-- Dumping data for table `character_reputation`
503--
504
505LOCK TABLES `character_reputation` WRITE;
506/*!40000 ALTER TABLE `character_reputation` DISABLE KEYS */;
507/*!40000 ALTER TABLE `character_reputation` ENABLE KEYS */;
508UNLOCK TABLES;
509
510--
511-- Table structure for table `character_social`
512--
513
514DROP TABLE IF EXISTS `character_social`;
515CREATE TABLE `character_social` (
516  `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Character Global Unique Identifier',
517  `friend` int(11) unsigned NOT NULL default '0' COMMENT 'Friend Global Unique Identifier',
518  `flags` tinyint(1) unsigned NOT NULL default '0' COMMENT 'Friend Flags',
519  `note` varchar(48) NOT NULL DEFAULT '' COMMENT 'Friend Note',
520  PRIMARY KEY  (`guid`,`friend`,`flags`),
521  KEY `guid` (`guid`),
522  KEY `friend` (`friend`),
523  KEY `guid_flags` (`guid`,`flags`),
524  KEY `friend_flags` (`friend`,`flags`)
525) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
526
527--
528-- Dumping data for table `character_social`
529--
530
531LOCK TABLES `character_social` WRITE;
532/*!40000 ALTER TABLE `character_social` DISABLE KEYS */;
533/*!40000 ALTER TABLE `character_social` ENABLE KEYS */;
534UNLOCK TABLES;
535
536--
537-- Table structure for table `character_spell`
538--
539
540DROP TABLE IF EXISTS `character_spell`;
541CREATE TABLE `character_spell` (
542  `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
543  `spell` int(11) unsigned NOT NULL default '0' COMMENT 'Spell Identifier',
544  `slot` int(11) unsigned NOT NULL default '0',
545  `active` tinyint(3) unsigned NOT NULL default '1',
546  `disabled` tinyint(3) unsigned NOT NULL default '0',
547  PRIMARY KEY  (`guid`,`spell`)
548) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
549
550--
551-- Dumping data for table `character_spell`
552--
553
554LOCK TABLES `character_spell` WRITE;
555/*!40000 ALTER TABLE `character_spell` DISABLE KEYS */;
556/*!40000 ALTER TABLE `character_spell` ENABLE KEYS */;
557UNLOCK TABLES;
558
559--
560-- Table structure for table `character_spell_cooldown`
561--
562
563DROP TABLE IF EXISTS `character_spell_cooldown`;
564CREATE TABLE `character_spell_cooldown` (
565  `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier, Low part',
566  `spell` int(11) unsigned NOT NULL default '0' COMMENT 'Spell Identifier',
567  `item` int(11) unsigned NOT NULL default '0' COMMENT 'Item Identifier',
568  `time` bigint(20) unsigned NOT NULL default '0',
569  PRIMARY KEY  (`guid`,`spell`)
570) ENGINE=InnoDB DEFAULT CHARSET=utf8;
571
572--
573-- Dumping data for table `character_spell_cooldown`
574--
575
576LOCK TABLES `character_spell_cooldown` WRITE;
577/*!40000 ALTER TABLE `character_spell_cooldown` DISABLE KEYS */;
578/*!40000 ALTER TABLE `character_spell_cooldown` ENABLE KEYS */;
579UNLOCK TABLES;
580
581--
582-- Table structure for table `character_ticket`
583--
584
585DROP TABLE IF EXISTS `character_ticket`;
586CREATE TABLE `character_ticket` (
587  `ticket_id` int(11) unsigned NOT NULL auto_increment,
588  `guid` int(11) unsigned NOT NULL default '0',
589  `ticket_text` text,
590  `ticket_lastchange` TIMESTAMP ON  UPDATE  CURRENT_TIMESTAMP  NOT  NULL  DEFAULT CURRENT_TIMESTAMP,
591  PRIMARY KEY  (`ticket_id`)
592) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
593
594--
595-- Dumping data for table `character_ticket`
596--
597
598LOCK TABLES `character_ticket` WRITE;
599/*!40000 ALTER TABLE `character_ticket` DISABLE KEYS */;
600/*!40000 ALTER TABLE `character_ticket` ENABLE KEYS */;
601UNLOCK TABLES;
602
603--
604-- Table structure for table `character_tutorial`
605--
606
607DROP TABLE IF EXISTS `character_tutorial`;
608CREATE TABLE `character_tutorial` (
609  `account` bigint(20) unsigned NOT NULL auto_increment COMMENT 'Account Identifier',
610  `realmid` int(11) unsigned NOT NULL default '0' COMMENT 'Realm Identifier',
611  `tut0` int(11) unsigned NOT NULL default '0',
612  `tut1` int(11) unsigned NOT NULL default '0',
613  `tut2` int(11) unsigned NOT NULL default '0',
614  `tut3` int(11) unsigned NOT NULL default '0',
615  `tut4` int(11) unsigned NOT NULL default '0',
616  `tut5` int(11) unsigned NOT NULL default '0',
617  `tut6` int(11) unsigned NOT NULL default '0',
618  `tut7` int(11) unsigned NOT NULL default '0',
619  PRIMARY KEY  (`account`,`realmid`),
620  KEY acc_key (`account`)
621) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player System';
622
623--
624-- Dumping data for table `character_tutorial`
625--
626
627LOCK TABLES `character_tutorial` WRITE;
628/*!40000 ALTER TABLE `character_tutorial` DISABLE KEYS */;
629/*!40000 ALTER TABLE `character_tutorial` ENABLE KEYS */;
630UNLOCK TABLES;
631
632--
633-- Table structure for table `corpse`
634--
635
636DROP TABLE IF EXISTS `corpse`;
637CREATE TABLE `corpse` (
638  `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
639  `player` int(11) unsigned NOT NULL default '0' COMMENT 'Character Global Unique Identifier',
640  `position_x` float NOT NULL default '0',
641  `position_y` float NOT NULL default '0',
642  `position_z` float NOT NULL default '0',
643  `orientation` float NOT NULL default '0',
644  `zone` int(11) unsigned NOT NULL default '38' COMMENT 'Zone Identifier',
645  `map` int(11) unsigned NOT NULL default '0' COMMENT 'Map Identifier',
646  `data` longtext,
647  `time` bigint(20) unsigned NOT NULL default '0',
648  `corpse_type` tinyint(3) unsigned NOT NULL default '0',
649  `instance` int(11) unsigned NOT NULL default '0',
650  PRIMARY KEY  (`guid`),
651  KEY `idx_type` (`corpse_type`),
652  KEY `instance` (`instance`)
653) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Death System';
654
655--
656-- Dumping data for table `corpse`
657--
658
659LOCK TABLES `corpse` WRITE;
660/*!40000 ALTER TABLE `corpse` DISABLE KEYS */;
661/*!40000 ALTER TABLE `corpse` ENABLE KEYS */;
662UNLOCK TABLES;
663
664--
665-- Table structure for table `game_event_condition_save`
666--
667
668CREATE TABLE `game_event_condition_save` (                   
669 `event_id` mediumint(8) unsigned NOT NULL,
670 `condition_id` mediumint(8) unsigned NOT NULL default '0',
671 `done` float default '0',
672 PRIMARY KEY  (`event_id`,`condition_id`)
673) ENGINE=InnoDB DEFAULT CHARSET=utf8;
674
675--
676-- Table structure for table `game_event_save`
677--
678
679CREATE TABLE `game_event_save` (
680 `event_id` mediumint(8) unsigned NOT NULL,
681 `state` tinyint(3) unsigned NOT NULL default '1',
682 `next_start` timestamp NOT NULL default '0000-00-00 00:00:00',
683 PRIMARY KEY  (`event_id`)
684) ENGINE=InnoDB DEFAULT CHARSET=utf8;
685
686--
687-- Table structure for table `groups`
688--
689
690DROP TABLE IF EXISTS `groups`;
691CREATE TABLE `groups` (
692  `leaderGuid` int(11) unsigned NOT NULL,
693  `mainTank` int(11) unsigned NOT NULL,
694  `mainAssistant` int(11) unsigned NOT NULL,
695  `lootMethod` tinyint(4) unsigned NOT NULL,
696  `looterGuid` int(11) unsigned NOT NULL,
697  `lootThreshold` tinyint(4) unsigned NOT NULL,
698  `icon1` int(11) unsigned NOT NULL,
699  `icon2` int(11) unsigned NOT NULL,
700  `icon3` int(11) unsigned NOT NULL,
701  `icon4` int(11) unsigned NOT NULL,
702  `icon5` int(11) unsigned NOT NULL,
703  `icon6` int(11) unsigned NOT NULL,
704  `icon7` int(11) unsigned NOT NULL,
705  `icon8` int(11) unsigned NOT NULL,
706  `isRaid` tinyint(1) unsigned NOT NULL,
707  `difficulty` tinyint(3) unsigned NOT NULL default '0',
708  PRIMARY KEY  (`leaderGuid`)
709) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Groups';
710
711--
712-- Dumping data for table `groups`
713--
714
715LOCK TABLES `groups` WRITE;
716/*!40000 ALTER TABLE `groups` DISABLE KEYS */;
717/*!40000 ALTER TABLE `groups` ENABLE KEYS */;
718UNLOCK TABLES;
719
720-- ----------------------------
721-- Table structure for group_instance
722-- ----------------------------
723DROP TABLE IF EXISTS `group_instance`;
724CREATE TABLE `group_instance` (
725  `leaderGuid` int(11) unsigned NOT NULL default '0',
726  `instance` int(11) unsigned NOT NULL default '0',
727  `permanent` tinyint(1) unsigned NOT NULL default '0',
728  PRIMARY KEY  (`leaderGuid`,`instance`),
729  KEY `instance` (`instance`)
730) ENGINE=InnoDB DEFAULT CHARSET=utf8;
731
732--
733-- Dumping data for table `group_instance`
734--
735
736LOCK TABLES `group_instance` WRITE;
737/*!40000 ALTER TABLE `group_instance` DISABLE KEYS */;
738/*!40000 ALTER TABLE `group_instance` ENABLE KEYS */;
739UNLOCK TABLES;
740
741--
742-- Table structure for table `group_member`
743--
744
745DROP TABLE IF EXISTS `group_member`;
746CREATE TABLE `group_member` (
747  `leaderGuid` int(11) unsigned NOT NULL,
748  `memberGuid` int(11) unsigned NOT NULL,
749  `assistant` tinyint(1) unsigned NOT NULL,
750  `subgroup` smallint(6) unsigned NOT NULL,
751  PRIMARY KEY  (`leaderGuid`,`memberGuid`)
752) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Groups';
753
754--
755-- Dumping data for table `group_member`
756--
757
758LOCK TABLES `group_member` WRITE;
759/*!40000 ALTER TABLE `group_member` DISABLE KEYS */;
760/*!40000 ALTER TABLE `group_member` ENABLE KEYS */;
761UNLOCK TABLES;
762
763--
764-- Table structure for table `guild`
765--
766
767DROP TABLE IF EXISTS `guild`;
768CREATE TABLE `guild` (
769  `guildid` int(6) unsigned NOT NULL default '0',
770  `name` varchar(255) NOT NULL default '',
771  `leaderguid` int(6) unsigned NOT NULL default '0',
772  `EmblemStyle` int(5) NOT NULL default '0',
773  `EmblemColor` int(5) NOT NULL default '0',
774  `BorderStyle` int(5) NOT NULL default '0',
775  `BorderColor` int(5) NOT NULL default '0',
776  `BackgroundColor` int(5) NOT NULL default '0',
777  `info` text NOT NULL,
778  `motd` varchar(255) NOT NULL default '',
779  `createdate` datetime default NULL,
780  `BankMoney` bigint(20) NOT NULL default '0',
781  PRIMARY KEY  (`guildid`)
782) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Guild System';
783
784--
785-- Dumping data for table `guild`
786--
787
788LOCK TABLES `guild` WRITE;
789/*!40000 ALTER TABLE `guild` DISABLE KEYS */;
790/*!40000 ALTER TABLE `guild` ENABLE KEYS */;
791UNLOCK TABLES;
792
793--
794-- Table structure for table `guild_bank_eventlog`
795--
796
797DROP TABLE IF EXISTS `guild_bank_eventlog`;
798CREATE TABLE `guild_bank_eventlog` (
799  `guildid` int(11) unsigned NOT NULL default '0',
800  `LogGuid` int(11) unsigned NOT NULL default '0',
801  `LogEntry` tinyint(1) unsigned NOT NULL default '0',
802  `TabId` tinyint(1) unsigned NOT NULL default '0',
803  `PlayerGuid` int(11) unsigned NOT NULL default '0',
804  `ItemOrMoney` int(11) unsigned NOT NULL default '0',
805  `ItemStackCount` tinyint(3) unsigned NOT NULL default '0',
806  `DestTabId` tinyint(1) unsigned NOT NULL default '0',
807  `TimeStamp` bigint(20) unsigned NOT NULL default '0',
808  PRIMARY KEY  (`guildid`,`LogGuid`),
809  KEY `guildid_key` (`guildid`)
810) ENGINE=InnoDB DEFAULT CHARSET=utf8;
811
812--
813-- Dumping data for table `guild_bank_eventlog`
814--
815
816LOCK TABLES `guild_bank_eventlog` WRITE;
817/*!40000 ALTER TABLE `guild_bank_eventlog` DISABLE KEYS */;
818/*!40000 ALTER TABLE `guild_bank_eventlog` ENABLE KEYS */;
819UNLOCK TABLES;
820
821--
822-- Table structure for table `guild_bank_item`
823--
824
825DROP TABLE IF EXISTS `guild_bank_item`;
826CREATE TABLE `guild_bank_item` (
827  `guildid` int(11) unsigned NOT NULL default '0',
828  `TabId` tinyint(1) unsigned NOT NULL default '0',
829  `SlotId` tinyint(3) unsigned NOT NULL default '0',
830  `item_guid` int(11) unsigned NOT NULL default '0',
831  `item_entry` int(11) unsigned NOT NULL default '0',
832  PRIMARY KEY  (`guildid`,`tabid`,`slotid`),
833  KEY `guildid_key` (`guildid`)
834) ENGINE=InnoDB DEFAULT CHARSET=utf8;
835
836--
837-- Dumping data for table `guild_bank_item`
838--
839
840LOCK TABLES `guild_bank_item` WRITE;
841/*!40000 ALTER TABLE `guild_bank_item` DISABLE KEYS */;
842/*!40000 ALTER TABLE `guild_bank_item` ENABLE KEYS */;
843UNLOCK TABLES;
844
845--
846-- Table structure for table `guild_bank_right`
847--
848
849DROP TABLE IF EXISTS `guild_bank_right`;
850CREATE TABLE `guild_bank_right` (
851  `guildid` int(11) unsigned NOT NULL default '0',
852  `TabId` tinyint(1) unsigned NOT NULL default '0',
853  `rid` int(11) unsigned NOT NULL default '0',
854  `gbright` tinyint(3) unsigned NOT NULL default '0',
855  `SlotPerDay` int(11) unsigned NOT NULL default '0',
856  PRIMARY KEY  (`guildid`,`TabId`,`rid`),
857  KEY `guildid_key` (`guildid`)
858) ENGINE=InnoDB DEFAULT CHARSET=utf8;
859
860--
861-- Dumping data for table `guild_bank_right`
862--
863
864LOCK TABLES `guild_bank_right` WRITE;
865/*!40000 ALTER TABLE `guild_bank_right` DISABLE KEYS */;
866/*!40000 ALTER TABLE `guild_bank_right` ENABLE KEYS */;
867UNLOCK TABLES;
868
869--
870-- Table structure for table `guild_bank_tab`
871--
872
873DROP TABLE IF EXISTS `guild_bank_tab`;
874CREATE TABLE `guild_bank_tab` (
875  `guildid` int(11) unsigned NOT NULL default '0',
876  `TabId` tinyint(1) unsigned NOT NULL default '0',
877  `TabName` varchar(100) NOT NULL default '',
878  `TabIcon` varchar(100) NOT NULL default '',
879  `TabText` varchar(500) NOT NULL default '',
880  PRIMARY KEY  (`guildid`,`TabId`),
881  KEY `guildid_key` (`guildid`)
882) ENGINE=InnoDB DEFAULT CHARSET=utf8;
883
884--
885-- Dumping data for table `guild_bank_tab`
886--
887
888LOCK TABLES `guild_bank_tab` WRITE;
889/*!40000 ALTER TABLE `guild_bank_tab` DISABLE KEYS */;
890/*!40000 ALTER TABLE `guild_bank_tab` ENABLE KEYS */;
891UNLOCK TABLES;
892
893--
894-- Table structure for table `guild_eventlog`
895--
896
897DROP TABLE IF EXISTS `guild_eventlog`;
898CREATE TABLE `guild_eventlog` (
899  `guildid` int(11) NOT NULL COMMENT 'Guild Identificator',
900  `LogGuid` int(11) NOT NULL COMMENT 'Log entry identificator',
901  `EventType` tinyint(1) NOT NULL COMMENT 'Event type',
902  `PlayerGuid1` int(11) NOT NULL COMMENT 'Player 1',
903  `PlayerGuid2` int(11) NOT NULL COMMENT 'Player 2',
904  `NewRank` tinyint(2) NOT NULL COMMENT 'New rank(in case promotion/demotion)',
905  `TimeStamp` bigint(20) NOT NULL COMMENT 'Event UNIX time'
906) ENGINE = InnoDB DEFAULT CHARSET = latin1 COMMENT 'Guild Eventlog';
907
908--
909-- Dumping data for table `guild_eventlog`
910--
911
912LOCK TABLES `guild_eventlog` WRITE;
913/*!40000 ALTER TABLE `guild_eventlog` DISABLE KEYS */;
914/*!40000 ALTER TABLE `guild_eventlog` ENABLE KEYS */;
915UNLOCK TABLES;
916
917--
918-- Table structure for table `guild_member`
919--
920
921DROP TABLE IF EXISTS `guild_member`;
922CREATE TABLE `guild_member` (
923  `guildid` int(6) unsigned NOT NULL default '0',
924  `guid` int(11) unsigned NOT NULL default '0',
925  `rank` tinyint(2) unsigned NOT NULL default '0',
926  `pnote` varchar(255) NOT NULL default '',
927  `offnote` varchar(255) NOT NULL default '',
928  `BankResetTimeMoney` int(11) unsigned NOT NULL default '0',
929  `BankRemMoney` int(11) unsigned NOT NULL default '0',
930  `BankResetTimeTab0` int(11) unsigned NOT NULL default '0',
931  `BankRemSlotsTab0` int(11) unsigned NOT NULL default '0',
932  `BankResetTimeTab1` int(11) unsigned NOT NULL default '0',
933  `BankRemSlotsTab1` int(11) unsigned NOT NULL default '0',
934  `BankResetTimeTab2` int(11) unsigned NOT NULL default '0',
935  `BankRemSlotsTab2` int(11) unsigned NOT NULL default '0',
936  `BankResetTimeTab3` int(11) unsigned NOT NULL default '0',
937  `BankRemSlotsTab3` int(11) unsigned NOT NULL default '0',
938  `BankResetTimeTab4` int(11) unsigned NOT NULL default '0',
939  `BankRemSlotsTab4` int(11) unsigned NOT NULL default '0',
940  `BankResetTimeTab5` int(11) unsigned NOT NULL default '0',
941  `BankRemSlotsTab5` int(11) unsigned NOT NULL default '0',
942  KEY `guildid_key` (`guildid`),
943  KEY `guildid_rank_key` (`guildid`,`rank`),
944  KEY `guid_key` (`guid`)
945) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Guild System';
946
947--
948-- Dumping data for table `guild_member`
949--
950
951LOCK TABLES `guild_member` WRITE;
952/*!40000 ALTER TABLE `guild_member` DISABLE KEYS */;
953/*!40000 ALTER TABLE `guild_member` ENABLE KEYS */;
954UNLOCK TABLES;
955
956--
957-- Table structure for table `guild_rank`
958--
959
960DROP TABLE IF EXISTS `guild_rank`;
961CREATE TABLE `guild_rank` (
962  `guildid` int(6) unsigned NOT NULL default '0',
963  `rid` int(11) unsigned NOT NULL,
964  `rname` varchar(255) NOT NULL default '',
965  `rights` int(3) unsigned NOT NULL default '0',
966  `BankMoneyPerDay` int(11) unsigned NOT NULL default '0',
967  PRIMARY KEY  (`guildid`,`rid`)
968) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Guild System';
969
970--
971-- Dumping data for table `guild_rank`
972--
973
974LOCK TABLES `guild_rank` WRITE;
975/*!40000 ALTER TABLE `guild_rank` DISABLE KEYS */;
976/*!40000 ALTER TABLE `guild_rank` ENABLE KEYS */;
977UNLOCK TABLES;
978
979--
980-- Table structure for table `instance`
981--
982
983DROP TABLE IF EXISTS `instance`;
984CREATE TABLE `instance` (
985  `id` int(11) unsigned NOT NULL default '0',
986  `map` int(11) unsigned NOT NULL default '0',
987  `resettime` bigint(40) NOT NULL default '0',
988  `difficulty` tinyint(1) unsigned NOT NULL default '0',
989  `data` longtext,
990  PRIMARY KEY  (`id`),
991  KEY `map` (`map`),
992  KEY `resettime` (`resettime`)
993) ENGINE=InnoDB DEFAULT CHARSET=utf8;
994
995--
996-- Dumping data for table `instance`
997--
998
999LOCK TABLES `instance` WRITE;
1000/*!40000 ALTER TABLE `instance` DISABLE KEYS */;
1001/*!40000 ALTER TABLE `instance` ENABLE KEYS */;
1002UNLOCK TABLES;
1003
1004-- ----------------------------
1005-- Table structure for instance_reset
1006-- ----------------------------
1007DROP TABLE IF EXISTS `instance_reset`;
1008CREATE TABLE `instance_reset` (
1009  `mapid` int(11) unsigned NOT NULL default '0',
1010  `resettime` bigint(40) NOT NULL default '0',
1011  PRIMARY KEY  (`mapid`)
1012) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1013
1014--
1015-- Dumping data for table `instance_reset`
1016--
1017
1018LOCK TABLES `instance_reset` WRITE;
1019/*!40000 ALTER TABLE `instance_reset` DISABLE KEYS */;
1020/*!40000 ALTER TABLE `instance_reset` ENABLE KEYS */;
1021UNLOCK TABLES;
1022
1023--
1024-- Table structure for table `item_instance`
1025--
1026
1027DROP TABLE IF EXISTS `item_instance`;
1028CREATE TABLE `item_instance` (
1029  `guid` int(11) unsigned NOT NULL default '0',
1030  `owner_guid` int(11) unsigned NOT NULL default '0',
1031  `data` longtext,
1032  PRIMARY KEY  (`guid`),
1033  KEY `idx_owner_guid` (`owner_guid`)
1034) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Item System';
1035
1036--
1037-- Dumping data for table `item_instance`
1038--
1039
1040LOCK TABLES `item_instance` WRITE;
1041/*!40000 ALTER TABLE `item_instance` DISABLE KEYS */;
1042/*!40000 ALTER TABLE `item_instance` ENABLE KEYS */;
1043UNLOCK TABLES;
1044
1045--
1046-- Table structure for table `item_text`
1047--
1048
1049DROP TABLE IF EXISTS `item_text`;
1050CREATE TABLE `item_text` (
1051  `id` int(11) unsigned NOT NULL default '0',
1052  `text` longtext,
1053  PRIMARY KEY  (`id`)
1054) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Item System';
1055
1056--
1057-- Dumping data for table `item_text`
1058--
1059
1060LOCK TABLES `item_text` WRITE;
1061/*!40000 ALTER TABLE `item_text` DISABLE KEYS */;
1062/*!40000 ALTER TABLE `item_text` ENABLE KEYS */;
1063UNLOCK TABLES;
1064
1065--
1066-- Table structure for table `mail`
1067--
1068
1069DROP TABLE IF EXISTS `mail`;
1070CREATE TABLE `mail` (
1071  `id` int(11) unsigned NOT NULL default '0' COMMENT 'Identifier',
1072  `messageType` tinyint(3) unsigned NOT NULL default '0',
1073  `stationery` tinyint(3) NOT NULL default '41',
1074  `mailTemplateId` mediumint(8) unsigned NOT NULL default '0',
1075  `sender` int(11) unsigned NOT NULL default '0' COMMENT 'Character Global Unique Identifier',
1076  `receiver` int(11) unsigned NOT NULL default '0' COMMENT 'Character Global Unique Identifier',
1077  `subject` longtext,
1078  `itemTextId` int(11) unsigned NOT NULL default '0',
1079  `has_items` tinyint(3) unsigned NOT NULL default '0',
1080  `expire_time` bigint(40) NOT NULL default '0',
1081  `deliver_time` bigint(40) NOT NULL default '0',
1082  `money` int(11) unsigned NOT NULL default '0',
1083  `cod` int(11) unsigned NOT NULL default '0',
1084  `checked` tinyint(3) unsigned NOT NULL default '0',
1085  PRIMARY KEY  (`id`),
1086  KEY `idx_receiver` (`receiver`)
1087) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Mail System';
1088
1089--
1090-- Dumping data for table `mail`
1091--
1092
1093LOCK TABLES `mail` WRITE;
1094/*!40000 ALTER TABLE `mail` DISABLE KEYS */;
1095/*!40000 ALTER TABLE `mail` ENABLE KEYS */;
1096UNLOCK TABLES;
1097
1098--
1099-- Table structure for table `mail_items`
1100--
1101
1102DROP TABLE IF EXISTS `mail_items`;
1103CREATE TABLE `mail_items` (
1104  `mail_id` int(11) NOT NULL default '0',
1105  `item_guid` int(11) NOT NULL default '0',
1106  `item_template` int(11) NOT NULL default '0',
1107  `receiver` int(11) unsigned NOT NULL default '0' COMMENT 'Character Global Unique Identifier',
1108  PRIMARY KEY  (`mail_id`,`item_guid`),
1109  KEY `idx_receiver` (`receiver`)
1110) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
1111
1112--
1113-- Dumping data for table `mail_items`
1114--
1115
1116LOCK TABLES `mail_items` WRITE;
1117/*!40000 ALTER TABLE `mail_items` DISABLE KEYS */;
1118/*!40000 ALTER TABLE `mail_items` ENABLE KEYS */;
1119UNLOCK TABLES;
1120
1121--
1122-- Table structure for table `pet_aura`
1123--
1124
1125DROP TABLE IF EXISTS `pet_aura`;
1126CREATE TABLE `pet_aura` (
1127  `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
1128  `caster_guid` bigint(20) unsigned NOT NULL default '0' COMMENT 'Full Global Unique Identifier',
1129  `spell` int(11) unsigned NOT NULL default '0',
1130  `effect_index` int(11) unsigned NOT NULL default '0',
1131  `amount` int(11) NOT NULL default '0',
1132  `maxduration` int(11) NOT NULL default '0',
1133  `remaintime` int(11) NOT NULL default '0',
1134  `remaincharges` int(11) NOT NULL default '0',
1135  PRIMARY KEY  (`guid`,`spell`,`effect_index`)
1136) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Pet System';
1137
1138--
1139-- Dumping data for table `pet_aura`
1140--
1141
1142LOCK TABLES `pet_aura` WRITE;
1143/*!40000 ALTER TABLE `pet_aura` DISABLE KEYS */;
1144/*!40000 ALTER TABLE `pet_aura` ENABLE KEYS */;
1145UNLOCK TABLES;
1146
1147--
1148-- Table structure for table `pet_spell`
1149--
1150
1151DROP TABLE IF EXISTS `pet_spell`;
1152CREATE TABLE `pet_spell` (
1153  `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
1154  `spell` int(11) unsigned NOT NULL default '0' COMMENT 'Spell Identifier',
1155  `slot` int(11) unsigned NOT NULL default '0',
1156  `active` int(11) unsigned NOT NULL default '0',
1157  PRIMARY KEY  (`guid`,`spell`)
1158) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Pet System';
1159
1160--
1161-- Dumping data for table `pet_spell`
1162--
1163
1164LOCK TABLES `pet_spell` WRITE;
1165/*!40000 ALTER TABLE `pet_spell` DISABLE KEYS */;
1166/*!40000 ALTER TABLE `pet_spell` ENABLE KEYS */;
1167UNLOCK TABLES;
1168
1169--
1170-- Table structure for table `pet_spell_cooldown`
1171--
1172
1173DROP TABLE IF EXISTS `pet_spell_cooldown`;
1174CREATE TABLE `pet_spell_cooldown` (
1175  `guid` int(11) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier, Low part',
1176  `spell` int(11) unsigned NOT NULL default '0' COMMENT 'Spell Identifier',
1177  `time` bigint(20) unsigned NOT NULL default '0',
1178  PRIMARY KEY  (`guid`,`spell`)
1179) ENGINE=InnoDB DEFAULT CHARSET=utf8;
1180
1181--
1182-- Dumping data for table `pet_spell_cooldown`
1183--
1184
1185LOCK TABLES `pet_spell_cooldown` WRITE;
1186/*!40000 ALTER TABLE `pet_spell_cooldown` DISABLE KEYS */;
1187/*!40000 ALTER TABLE `pet_spell_cooldown` ENABLE KEYS */;
1188UNLOCK TABLES;
1189
1190--
1191-- Table structure for table `petition`
1192--
1193
1194DROP TABLE IF EXISTS `petition`;
1195CREATE TABLE `petition` (
1196  `ownerguid` int(10) unsigned NOT NULL,
1197  `petitionguid` int(10) unsigned default '0',
1198  `name` varchar(255) NOT NULL default '',
1199  `type` int(10) unsigned NOT NULL default '0',
1200  PRIMARY KEY  (`ownerguid`,`type`),
1201  UNIQUE KEY `index_ownerguid_petitionguid` (`ownerguid`,`petitionguid`)
1202) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Guild System';
1203
1204--
1205-- Dumping data for table `petition`
1206--
1207
1208LOCK TABLES `petition` WRITE;
1209/*!40000 ALTER TABLE `petition` DISABLE KEYS */;
1210/*!40000 ALTER TABLE `petition` ENABLE KEYS */;
1211UNLOCK TABLES;
1212
1213--
1214-- Table structure for table `petition_sign`
1215--
1216
1217DROP TABLE IF EXISTS `petition_sign`;
1218CREATE TABLE `petition_sign` (
1219  `ownerguid` int(10) unsigned NOT NULL,
1220  `petitionguid` int(11) unsigned NOT NULL default '0',
1221  `playerguid` int(11) unsigned NOT NULL default '0',
1222  `player_account` int(11) unsigned NOT NULL default '0',
1223  `type` int(10) unsigned NOT NULL default '0',
1224  PRIMARY KEY  (`petitionguid`,`playerguid`)
1225) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Guild System';
1226--
1227-- Dumping data for table `petition_sign`
1228--
1229
1230LOCK TABLES `petition_sign` WRITE;
1231/*!40000 ALTER TABLE `petition_sign` DISABLE KEYS */;
1232/*!40000 ALTER TABLE `petition_sign` ENABLE KEYS */;
1233UNLOCK TABLES;
1234
1235--
1236-- Table structure for table `saved_variables`
1237--
1238DROP TABLE IF EXISTS `saved_variables`;
1239CREATE TABLE `saved_variables` (                                                                             
1240    `NextArenaPointDistributionTime` timestamp NOT NULL
1241) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Variable Saves';
1242
1243--
1244-- Dumping data for table `saved_variables`
1245--
1246
1247LOCK TABLES `saved_variables` WRITE;
1248/*!40000 ALTER TABLE `saved_variables` DISABLE KEYS */;
1249/*!40000 ALTER TABLE `saved_variables` ENABLE KEYS */;
1250UNLOCK TABLES;
1251/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
1252
1253/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
1254/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
1255/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
1256/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
1257/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
1258/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
1259/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
1260
1261-- Dump completed on 2008-01-10 11:37:06
Note: See TracBrowser for help on using the browser.