Context Navigation

world.sql @ 85

Revision 85, 109.3 kB (checked in by yumileroy, 17 years ago)

[svn] Implement a new table (spell_disabled) to allow disabling some spells for players and / or creatures. To disable a spell for a players and pets, set 2^{0 in the disable_mask, to disable for creatures, set 2}1. The comment field is optional. Original patch provided by Craker.

Original author: w12x
Date: 2008-10-21 03:58:38-05:00

Rev	Line
[45]	1	-- MySQL dump 10.11
	2	--
	3	-- Host: localhost Database: world
	4	-- ------------------------------------------------------
	5	-- Server version 5.0.34-log
[37]	6
[45]	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 /;
[37]	10	/!40101 SET NAMES utf8 /;
[45]	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 /;
[37]	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' /;
[45]	16	/!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 /;
[37]	17
[45]	18	--
	19	-- Table structure for table `areatrigger_involvedrelation`
	20	--
[37]	21
	22	DROP TABLE IF EXISTS `areatrigger_involvedrelation`;
	23	CREATE TABLE `areatrigger_involvedrelation` (
	24	`id` mediumint(8) unsigned NOT NULL default '0' COMMENT 'Identifier',
	25	`quest` mediumint(8) unsigned NOT NULL default '0' COMMENT 'Quest Identifier',
	26	PRIMARY KEY (`id`)
	27	) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Trigger System';
	28
[45]	29	--
	30	-- Dumping data for table `areatrigger_involvedrelation`
	31	--
[37]	32
[45]	33	LOCK TABLES `areatrigger_involvedrelation` WRITE;
	34	/!40000 ALTER TABLE `areatrigger_involvedrelation` DISABLE KEYS /;
	35	/!40000 ALTER TABLE `areatrigger_involvedrelation` ENABLE KEYS /;
	36	UNLOCK TABLES;
[37]	37
[45]	38	--
	39	-- Table structure for table `areatrigger_scripts`
	40	--
	41
[39]	42	DROP TABLE IF EXISTS `areatrigger_scripts`;
[37]	43	CREATE TABLE `areatrigger_scripts` (
[39]	44	`entry` mediumint(8) NOT NULL,
	45	`ScriptName` char(64) NOT NULL,
	46	PRIMARY KEY (`entry`)
	47	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
[37]	48
[45]	49	--
	50	-- Dumping data for table `areatrigger_scripts`
	51	--
[37]	52
[45]	53	LOCK TABLES `areatrigger_scripts` WRITE;
	54	/!40000 ALTER TABLE `areatrigger_scripts` DISABLE KEYS /;
	55	/!40000 ALTER TABLE `areatrigger_scripts` ENABLE KEYS /;
	56	UNLOCK TABLES;
[39]	57
[45]	58	--
	59	-- Table structure for table `areatrigger_tavern`
	60	--
	61
[37]	62	DROP TABLE IF EXISTS `areatrigger_tavern`;
	63	CREATE TABLE `areatrigger_tavern` (
	64	`id` mediumint(8) unsigned NOT NULL default '0' COMMENT 'Identifier',
	65	`name` text,
	66	PRIMARY KEY (`id`)
	67	) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Trigger System';
	68
[45]	69	--
	70	-- Dumping data for table `areatrigger_tavern`
	71	--
[37]	72
[45]	73	LOCK TABLES `areatrigger_tavern` WRITE;
	74	/!40000 ALTER TABLE `areatrigger_tavern` DISABLE KEYS /;
	75	/!40000 ALTER TABLE `areatrigger_tavern` ENABLE KEYS /;
	76	UNLOCK TABLES;
[37]	77
[45]	78	--
	79	-- Table structure for table `areatrigger_teleport`
	80	--
	81
[37]	82	DROP TABLE IF EXISTS `areatrigger_teleport`;
	83	CREATE TABLE `areatrigger_teleport` (
	84	`id` mediumint(8) unsigned NOT NULL default '0' COMMENT 'Identifier',
	85	`name` text,
	86	`required_level` tinyint(3) unsigned NOT NULL default '0',
	87	`required_item` mediumint(8) unsigned NOT NULL default '0',
	88	`required_item2` mediumint(8) unsigned NOT NULL default '0',
	89	`heroic_key` mediumint(8) unsigned NOT NULL default '0',
	90	`heroic_key2` mediumint(8) unsigned NOT NULL default '0',
	91	`required_quest_done` int(11) unsigned NOT NULL default '0',
	92	`required_failed_text` text,
	93	`target_map` smallint(5) unsigned NOT NULL default '0',
	94	`target_position_x` float NOT NULL default '0',
	95	`target_position_y` float NOT NULL default '0',
	96	`target_position_z` float NOT NULL default '0',
	97	`target_orientation` float NOT NULL default '0',
[45]	98	PRIMARY KEY (`id`),
	99	FULLTEXT KEY `name` (`name`)
[37]	100	) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Trigger System';
	101
[45]	102	--
	103	-- Dumping data for table `areatrigger_teleport`
	104	--
[37]	105
[45]	106	LOCK TABLES `areatrigger_teleport` WRITE;
	107	/!40000 ALTER TABLE `areatrigger_teleport` DISABLE KEYS /;
	108	/!40000 ALTER TABLE `areatrigger_teleport` ENABLE KEYS /;
	109	UNLOCK TABLES;
[37]	110
[45]	111	--
	112	-- Table structure for table `battleground_template`
	113	--
	114
[37]	115	DROP TABLE IF EXISTS `battleground_template`;
	116	CREATE TABLE `battleground_template` (
	117	`id` mediumint(8) unsigned NOT NULL,
	118	`MinPlayersPerTeam` smallint(5) unsigned NOT NULL default '0',
	119	`MaxPlayersPerTeam` smallint(5) unsigned NOT NULL default '0',
	120	`MinLvl` tinyint(3) unsigned NOT NULL default '0',
	121	`MaxLvl` tinyint(3) unsigned NOT NULL default '0',
	122	`AllianceStartLoc` mediumint(8) unsigned NOT NULL,
	123	`AllianceStartO` float NOT NULL,
	124	`HordeStartLoc` mediumint(8) unsigned NOT NULL,
	125	`HordeStartO` float NOT NULL,
	126	PRIMARY KEY (`id`)
	127	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	128
[45]	129	--
	130	-- Dumping data for table `battleground_template`
	131	--
[37]	132
[45]	133	LOCK TABLES `battleground_template` WRITE;
	134	/!40000 ALTER TABLE `battleground_template` DISABLE KEYS /;
	135	/!40000 ALTER TABLE `battleground_template` ENABLE KEYS /;
	136	UNLOCK TABLES;
[37]	137
[45]	138	--
	139	-- Table structure for table `battlemaster_entry`
	140	--
[37]	141
	142	DROP TABLE IF EXISTS `battlemaster_entry`;
	143	CREATE TABLE `battlemaster_entry` (
	144	`entry` mediumint(8) unsigned NOT NULL default '0' COMMENT 'Entry of a creature',
	145	`bg_template` mediumint(8) unsigned NOT NULL default '0' COMMENT 'Battleground template id',
	146	PRIMARY KEY (`entry`)
	147	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	148
[45]	149	--
	150	-- Dumping data for table `battlemaster_entry`
	151	--
[37]	152
[45]	153	LOCK TABLES `battlemaster_entry` WRITE;
	154	/!40000 ALTER TABLE `battlemaster_entry` DISABLE KEYS /;
	155	/!40000 ALTER TABLE `battlemaster_entry` ENABLE KEYS /;
	156	UNLOCK TABLES;
[37]	157
[45]	158	--
	159	-- Table structure for table `command`
	160	--
	161
[37]	162	DROP TABLE IF EXISTS `command`;
	163	CREATE TABLE `command` (
	164	`name` varchar(50) NOT NULL default '',
	165	`security` tinyint(3) unsigned NOT NULL default '0',
	166	`help` longtext,
	167	PRIMARY KEY (`name`)
	168	) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Chat System';
	169
[45]	170	--
	171	-- Dumping data for table `command`
	172	--
[37]	173
[45]	174	LOCK TABLES `command` WRITE;
	175	/!40000 ALTER TABLE `command` DISABLE KEYS /;
	176	/!40000 ALTER TABLE `command` ENABLE KEYS /;
	177	UNLOCK TABLES;
[37]	178
[45]	179	--
	180	-- Table structure for table `creature`
	181	--
[37]	182
	183	DROP TABLE IF EXISTS `creature`;
	184	CREATE TABLE `creature` (
	185	`guid` int(10) unsigned NOT NULL auto_increment COMMENT 'Global Unique Identifier',
	186	`id` mediumint(8) unsigned NOT NULL default '0' COMMENT 'Creature Identifier',
	187	`map` smallint(5) unsigned NOT NULL default '0' COMMENT 'Map Identifier',
	188	`spawnMask` tinyint(3) unsigned NOT NULL default '1',
	189	`modelid` mediumint(8) unsigned NOT NULL default '0',
	190	`equipment_id` mediumint(9) NOT NULL default '0',
	191	`position_x` float NOT NULL default '0',
	192	`position_y` float NOT NULL default '0',
	193	`position_z` float NOT NULL default '0',
	194	`orientation` float NOT NULL default '0',
	195	`spawntimesecs` int(10) unsigned NOT NULL default '120',
	196	`spawndist` float NOT NULL default '5',
	197	`currentwaypoint` mediumint(8) unsigned NOT NULL default '0',
	198	`curhealth` int(10) unsigned NOT NULL default '1',
	199	`curmana` int(10) unsigned NOT NULL default '0',
	200	`DeathState` tinyint(3) unsigned NOT NULL default '0',
	201	`MovementType` tinyint(3) unsigned NOT NULL default '0',
	202	PRIMARY KEY (`guid`),
	203	KEY `idx_map` (`map`),
[45]	204	KEY `idx_id` (`id`)
[37]	205	) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Creature System';
	206
[45]	207	--
	208	-- Dumping data for table `creature`
	209	--
[37]	210
[45]	211	LOCK TABLES `creature` WRITE;
	212	/!40000 ALTER TABLE `creature` DISABLE KEYS /;
	213	/!40000 ALTER TABLE `creature` ENABLE KEYS /;
	214	UNLOCK TABLES;
[37]	215
[45]	216	--
	217	-- Table structure for table `creature_addon`
	218	--
	219
[37]	220	DROP TABLE IF EXISTS `creature_addon`;
	221	CREATE TABLE `creature_addon` (
[45]	222	`guid` int(10) unsigned NOT NULL default '0',
[37]	223	`mount` mediumint(8) unsigned NOT NULL default '0',
	224	`bytes0` int(10) unsigned NOT NULL default '0',
	225	`bytes1` int(10) unsigned NOT NULL default '0',
	226	`bytes2` int(10) unsigned NOT NULL default '0',
	227	`emote` int(10) unsigned NOT NULL default '0',
	228	`moveflags` int(10) unsigned NOT NULL default '0',
	229	`auras` text,
	230	PRIMARY KEY (`guid`)
[45]	231	) ENGINE=MyISAM DEFAULT CHARSET=latin1;
[37]	232
[45]	233	--
	234	-- Dumping data for table `creature_addon`
	235	--
[37]	236
[45]	237	LOCK TABLES `creature_addon` WRITE;
	238	/!40000 ALTER TABLE `creature_addon` DISABLE KEYS /;
	239	/!40000 ALTER TABLE `creature_addon` ENABLE KEYS /;
	240	UNLOCK TABLES;
[37]	241
[45]	242	--
	243	-- Table structure for table `creature_equip_template`
	244	--
	245
[37]	246	DROP TABLE IF EXISTS `creature_equip_template`;
	247	CREATE TABLE `creature_equip_template` (
	248	`entry` mediumint(8) unsigned NOT NULL default '0' COMMENT 'Unique entry',
	249	`equipmodel1` mediumint(8) unsigned NOT NULL default '0',
	250	`equipmodel2` mediumint(8) unsigned NOT NULL default '0',
	251	`equipmodel3` mediumint(8) unsigned NOT NULL default '0',
	252	`equipinfo1` int(10) unsigned NOT NULL default '0',
	253	`equipinfo2` int(10) unsigned NOT NULL default '0',
	254	`equipinfo3` int(10) unsigned NOT NULL default '0',
	255	`equipslot1` int(11) NOT NULL default '0',
	256	`equipslot2` int(11) NOT NULL default '0',
	257	`equipslot3` int(11) NOT NULL default '0',
	258	PRIMARY KEY (`entry`)
	259	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Creature System (Equipment)';
	260
[45]	261	--
	262	-- Dumping data for table `creature_equip_template`
	263	--
[37]	264
[45]	265	LOCK TABLES `creature_equip_template` WRITE;
	266	/!40000 ALTER TABLE `creature_equip_template` DISABLE KEYS /;
	267	/!40000 ALTER TABLE `creature_equip_template` ENABLE KEYS /;
	268	UNLOCK TABLES;
[37]	269
[45]	270	--
	271	-- Table structure for table `creature_involvedrelation`
	272	--
	273
[37]	274	DROP TABLE IF EXISTS `creature_involvedrelation`;
	275	CREATE TABLE `creature_involvedrelation` (
	276	`id` mediumint(8) unsigned NOT NULL default '0' COMMENT 'Identifier',
	277	`quest` mediumint(8) unsigned NOT NULL default '0' COMMENT 'Quest Identifier',
	278	PRIMARY KEY (`id`,`quest`)
	279	) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Creature System';
	280
[45]	281	--
	282	-- Dumping data for table `creature_involvedrelation`
	283	--
[37]	284
[45]	285	LOCK TABLES `creature_involvedrelation` WRITE;
	286	/!40000 ALTER TABLE `creature_involvedrelation` DISABLE KEYS /;
	287	/!40000 ALTER TABLE `creature_involvedrelation` ENABLE KEYS /;
	288	UNLOCK TABLES;
[37]	289
[45]	290	--
	291	-- Table structure for table `creature_loot_template`
	292	--
	293
[37]	294	DROP TABLE IF EXISTS `creature_loot_template`;
	295	CREATE TABLE `creature_loot_template` (
	296	`entry` mediumint(8) unsigned NOT NULL default '0',
	297	`item` mediumint(8) unsigned NOT NULL default '0',
	298	`ChanceOrQuestChance` float NOT NULL default '100',
	299	`groupid` tinyint(3) unsigned NOT NULL default '0',
	300	`mincountOrRef` mediumint(9) NOT NULL default '1',
	301	`maxcount` tinyint(3) unsigned NOT NULL default '1',
	302	`lootcondition` tinyint(3) unsigned NOT NULL default '0',
	303	`condition_value1` mediumint(8) unsigned NOT NULL default '0',
	304	`condition_value2` mediumint(8) unsigned NOT NULL default '0',
	305	PRIMARY KEY (`entry`,`item`)
[45]	306	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Loot System';
[37]	307
[45]	308	--
	309	-- Dumping data for table `creature_loot_template`
	310	--
[37]	311
[45]	312	LOCK TABLES `creature_loot_template` WRITE;
	313	/!40000 ALTER TABLE `creature_loot_template` DISABLE KEYS /;
	314	/!40000 ALTER TABLE `creature_loot_template` ENABLE KEYS /;
	315	UNLOCK TABLES;
[37]	316
[45]	317	--
	318	-- Table structure for table `creature_model_info`
	319	--
	320
[37]	321	DROP TABLE IF EXISTS `creature_model_info`;
	322	CREATE TABLE `creature_model_info` (
	323	`modelid` mediumint(8) unsigned NOT NULL default '0',
	324	`bounding_radius` float NOT NULL default '0',
	325	`combat_reach` float NOT NULL default '0',
	326	`gender` tinyint(3) unsigned NOT NULL default '2',
	327	`modelid_other_gender` mediumint(8) unsigned NOT NULL default '0',
	328	PRIMARY KEY (`modelid`)
	329	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Creature System (Model related info)';
	330
[45]	331	--
	332	-- Dumping data for table `creature_model_info`
	333	--
[37]	334
[45]	335	LOCK TABLES `creature_model_info` WRITE;
	336	/!40000 ALTER TABLE `creature_model_info` DISABLE KEYS /;
	337	/!40000 ALTER TABLE `creature_model_info` ENABLE KEYS /;
	338	UNLOCK TABLES;
[37]	339
[45]	340	--
	341	-- Table structure for table `creature_movement`
	342	--
	343
[37]	344	DROP TABLE IF EXISTS `creature_movement`;
	345	CREATE TABLE `creature_movement` (
	346	`id` int(10) unsigned NOT NULL COMMENT 'Creature GUID',
	347	`point` mediumint(8) unsigned NOT NULL default '0',
	348	`position_x` float NOT NULL default '0',
	349	`position_y` float NOT NULL default '0',
	350	`position_z` float NOT NULL default '0',
	351	`waittime` int(10) unsigned NOT NULL default '0',
	352	`text1` text,
	353	`text2` text,
	354	`text3` text,
	355	`text4` text,
	356	`text5` text,
	357	`emote` mediumint(8) unsigned NOT NULL default '0',
	358	`spell` mediumint(8) unsigned NOT NULL default '0',
	359	`wpguid` int(11) NOT NULL default '0',
	360	`orientation` float NOT NULL default '0',
	361	`model1` mediumint(9) NOT NULL default '0',
	362	`model2` mediumint(9) NOT NULL default '0',
	363	PRIMARY KEY (`id`,`point`)
	364	) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Creature System';
	365
[45]	366	--
	367	-- Dumping data for table `creature_movement`
	368	--
[37]	369
[45]	370	LOCK TABLES `creature_movement` WRITE;
	371	/!40000 ALTER TABLE `creature_movement` DISABLE KEYS /;
	372	/!40000 ALTER TABLE `creature_movement` ENABLE KEYS /;
	373	UNLOCK TABLES;
[37]	374
[45]	375	--
	376	-- Table structure for table `creature_onkill_reputation`
	377	--
	378
[37]	379	DROP TABLE IF EXISTS `creature_onkill_reputation`;
	380	CREATE TABLE `creature_onkill_reputation` (
	381	`creature_id` mediumint(8) unsigned NOT NULL default '0' COMMENT 'Creature Identifier',
	382	`RewOnKillRepFaction1` smallint(6) NOT NULL default '0',
	383	`RewOnKillRepFaction2` smallint(6) NOT NULL default '0',
	384	`MaxStanding1` tinyint(4) NOT NULL default '0',
	385	`IsTeamAward1` tinyint(4) NOT NULL default '0',
	386	`RewOnKillRepValue1` mediumint(9) NOT NULL default '0',
	387	`MaxStanding2` tinyint(4) NOT NULL default '0',
	388	`IsTeamAward2` tinyint(4) NOT NULL default '0',
	389	`RewOnKillRepValue2` mediumint(9) NOT NULL default '0',
	390	`TeamDependent` tinyint(3) unsigned NOT NULL default '0',
	391	PRIMARY KEY (`creature_id`)
	392	) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Creature OnKill Reputation gain';
	393
[45]	394	--
	395	-- Dumping data for table `creature_onkill_reputation`
	396	--
[37]	397
[45]	398	LOCK TABLES `creature_onkill_reputation` WRITE;
	399	/!40000 ALTER TABLE `creature_onkill_reputation` DISABLE KEYS /;
	400	/!40000 ALTER TABLE `creature_onkill_reputation` ENABLE KEYS /;
	401	UNLOCK TABLES;
[37]	402
[45]	403	--
	404	-- Table structure for table `creature_questrelation`
	405	--
	406
[37]	407	DROP TABLE IF EXISTS `creature_questrelation`;
	408	CREATE TABLE `creature_questrelation` (
	409	`id` mediumint(8) unsigned NOT NULL default '0' COMMENT 'Identifier',
	410	`quest` mediumint(8) unsigned NOT NULL default '0' COMMENT 'Quest Identifier',
	411	PRIMARY KEY (`id`,`quest`)
	412	) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Creature System';
	413
[45]	414	--
	415	-- Dumping data for table `creature_questrelation`
	416	--
[37]	417
[45]	418	LOCK TABLES `creature_questrelation` WRITE;
	419	/!40000 ALTER TABLE `creature_questrelation` DISABLE KEYS /;
	420	/!40000 ALTER TABLE `creature_questrelation` ENABLE KEYS /;
	421	UNLOCK TABLES;
[37]	422
[45]	423	--
	424	-- Table structure for table `creature_respawn`
	425	--
	426
[37]	427	DROP TABLE IF EXISTS `creature_respawn`;
	428	CREATE TABLE `creature_respawn` (
	429	`guid` int(10) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
	430	`respawntime` bigint(20) NOT NULL default '0',
	431	`instance` mediumint(8) unsigned NOT NULL default '0',
	432	PRIMARY KEY (`guid`,`instance`),
	433	KEY `instance` (`instance`)
	434	) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Grid Loading System';
	435
[45]	436	--
	437	-- Dumping data for table `creature_respawn`
	438	--
[37]	439
[45]	440	LOCK TABLES `creature_respawn` WRITE;
	441	/!40000 ALTER TABLE `creature_respawn` DISABLE KEYS /;
	442	/!40000 ALTER TABLE `creature_respawn` ENABLE KEYS /;
	443	UNLOCK TABLES;
[37]	444
[45]	445	--
	446	-- Table structure for table `creature_template`
	447	--
	448
[37]	449	DROP TABLE IF EXISTS `creature_template`;
	450	CREATE TABLE `creature_template` (
	451	`entry` mediumint(8) unsigned NOT NULL default '0',
	452	`heroic_entry` mediumint(8) unsigned NOT NULL default '0',
	453	`modelid_A` mediumint(8) unsigned NOT NULL default '0',
	454	`modelid_A2` mediumint(8) unsigned NOT NULL default '0',
	455	`modelid_H` mediumint(8) unsigned NOT NULL default '0',
	456	`modelid_H2` mediumint(8) unsigned NOT NULL default '0',
	457	`name` char(100) NOT NULL default '0',
	458	`subname` char(100) default NULL,
	459	`IconName` char(100) default NULL,
	460	`minlevel` tinyint(3) unsigned NOT NULL default '1',
	461	`maxlevel` tinyint(3) unsigned NOT NULL default '1',
	462	`minhealth` int(10) unsigned NOT NULL default '0',
	463	`maxhealth` int(10) unsigned NOT NULL default '0',
	464	`minmana` int(10) unsigned NOT NULL default '0',
	465	`maxmana` int(10) unsigned NOT NULL default '0',
	466	`armor` mediumint(8) unsigned NOT NULL default '0',
	467	`faction_A` smallint(5) unsigned NOT NULL default '0',
	468	`faction_H` smallint(5) unsigned NOT NULL default '0',
	469	`npcflag` int(10) unsigned NOT NULL default '0',
[45]	470	`speed` float default '1',
[37]	471	`scale` float NOT NULL default '1',
	472	`rank` tinyint(3) unsigned NOT NULL default '0',
	473	`mindmg` float NOT NULL default '0',
	474	`maxdmg` float NOT NULL default '0',
	475	`dmgschool` tinyint(4) NOT NULL default '0',
	476	`attackpower` int(10) unsigned NOT NULL default '0',
	477	`baseattacktime` int(10) unsigned NOT NULL default '0',
	478	`rangeattacktime` int(10) unsigned NOT NULL default '0',
	479	`flags` int(10) unsigned NOT NULL default '0',
	480	`dynamicflags` int(10) unsigned NOT NULL default '0',
	481	`family` tinyint(4) NOT NULL default '0',
	482	`trainer_type` tinyint(4) NOT NULL default '0',
	483	`trainer_spell` mediumint(8) unsigned NOT NULL default '0',
	484	`class` tinyint(3) unsigned NOT NULL default '0',
	485	`race` tinyint(3) unsigned NOT NULL default '0',
	486	`minrangedmg` float NOT NULL default '0',
	487	`maxrangedmg` float NOT NULL default '0',
	488	`rangedattackpower` smallint(5) unsigned NOT NULL default '0',
	489	`type` tinyint(3) unsigned NOT NULL default '0',
	490	`flag1` int(10) unsigned NOT NULL default '0',
	491	`lootid` mediumint(8) unsigned NOT NULL default '0',
	492	`pickpocketloot` mediumint(8) unsigned NOT NULL default '0',
	493	`skinloot` mediumint(8) unsigned NOT NULL default '0',
	494	`resistance1` smallint(5) NOT NULL default '0',
	495	`resistance2` smallint(5) NOT NULL default '0',
	496	`resistance3` smallint(5) NOT NULL default '0',
	497	`resistance4` smallint(5) NOT NULL default '0',
	498	`resistance5` smallint(5) NOT NULL default '0',
	499	`resistance6` smallint(5) NOT NULL default '0',
	500	`spell1` mediumint(8) unsigned NOT NULL default '0',
	501	`spell2` mediumint(8) unsigned NOT NULL default '0',
	502	`spell3` mediumint(8) unsigned NOT NULL default '0',
	503	`spell4` mediumint(8) unsigned NOT NULL default '0',
	504	`PetSpellDataId` mediumint(8) unsigned NOT NULL default '0',
	505	`mingold` mediumint(8) unsigned NOT NULL default '0',
	506	`maxgold` mediumint(8) unsigned NOT NULL default '0',
	507	`AIName` char(64) NOT NULL default '',
	508	`MovementType` tinyint(3) unsigned NOT NULL default '0',
	509	`InhabitType` tinyint(3) unsigned NOT NULL default '3',
	510	`RacialLeader` tinyint(3) unsigned NOT NULL default '0',
	511	`RegenHealth` tinyint(3) unsigned NOT NULL default '1',
	512	`equipment_id` mediumint(8) unsigned NOT NULL default '0',
	513	`mechanic_immune_mask` int(10) unsigned NOT NULL default '0',
	514	`flags_extra` int(10) unsigned NOT NULL default '0',
	515	`ScriptName` char(64) NOT NULL default '',
[45]	516	PRIMARY KEY (`entry`),
	517	KEY `idx_name` (`name`)
[37]	518	) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Creature System';
	519
[45]	520	--
	521	-- Dumping data for table `creature_template`
	522	--
[37]	523
[45]	524	LOCK TABLES `creature_template` WRITE;
	525	/!40000 ALTER TABLE `creature_template` DISABLE KEYS /;
	526	/!40000 ALTER TABLE `creature_template` ENABLE KEYS /;
	527	UNLOCK TABLES;
[37]	528
[45]	529	--
	530	-- Table structure for table `creature_template_addon`
	531	--
[37]	532
	533	DROP TABLE IF EXISTS `creature_template_addon`;
	534	CREATE TABLE `creature_template_addon` (
	535	`entry` mediumint(8) unsigned NOT NULL default '0',
	536	`mount` mediumint(8) unsigned NOT NULL default '0',
	537	`bytes0` int(10) unsigned NOT NULL default '0',
	538	`bytes1` int(10) unsigned NOT NULL default '0',
	539	`bytes2` int(10) unsigned NOT NULL default '0',
	540	`emote` mediumint(8) unsigned NOT NULL default '0',
	541	`moveflags` int(10) unsigned NOT NULL default '0',
	542	`auras` text,
	543	PRIMARY KEY (`entry`)
	544	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	545
[45]	546	--
	547	-- Dumping data for table `creature_template_addon`
	548	--
[37]	549
[45]	550	LOCK TABLES `creature_template_addon` WRITE;
	551	/!40000 ALTER TABLE `creature_template_addon` DISABLE KEYS /;
	552	/!40000 ALTER TABLE `creature_template_addon` ENABLE KEYS /;
	553	UNLOCK TABLES;
[37]	554
[45]	555	--
	556	-- Table structure for table `custom_texts`
	557	--
	558
	559	DROP TABLE IF EXISTS `custom_texts`;
	560	CREATE TABLE `custom_texts` (
	561	`entry` mediumint(8) NOT NULL,
	562	`content_default` text NOT NULL,
	563	`content_loc1` text,
	564	`content_loc2` text,
	565	`content_loc3` text,
	566	`content_loc4` text,
	567	`content_loc5` text,
	568	`content_loc6` text,
	569	`content_loc7` text,
	570	`content_loc8` text,
	571	`sound` mediumint(8) unsigned NOT NULL default '0',
	572	`type` tinyint(3) unsigned NOT NULL default '0',
	573	`language` tinyint(3) unsigned NOT NULL default '0',
	574	`comment` text,
	575	PRIMARY KEY (`entry`)
	576	) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Custom Texts';
	577
	578	--
	579	-- Dumping data for table `custom_texts`
	580	--
	581
	582	LOCK TABLES `custom_texts` WRITE;
	583	/!40000 ALTER TABLE `custom_texts` DISABLE KEYS /;
	584	/!40000 ALTER TABLE `custom_texts` ENABLE KEYS /;
	585	UNLOCK TABLES;
	586
	587	--
	588	-- Table structure for table `db_version`
	589	--
	590
[37]	591	DROP TABLE IF EXISTS `db_version`;
	592	CREATE TABLE `db_version` (
	593	`version` varchar(120) default NULL
	594	) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Used DB version notes';
	595
[45]	596	--
	597	-- Dumping data for table `db_version`
	598	--
[37]	599
[45]	600	LOCK TABLES `db_version` WRITE;
	601	/!40000 ALTER TABLE `db_version` DISABLE KEYS /;
	602	/!40000 ALTER TABLE `db_version` ENABLE KEYS /;
	603	UNLOCK TABLES;
[37]	604
[45]	605	--
	606	-- Table structure for table `disenchant_loot_template`
	607	--
[37]	608
	609	DROP TABLE IF EXISTS `disenchant_loot_template`;
	610	CREATE TABLE `disenchant_loot_template` (
	611	`entry` mediumint(8) unsigned NOT NULL default '0' COMMENT 'Recommended id selection: item_level*100 + item_quality',
	612	`item` mediumint(8) unsigned NOT NULL default '0',
	613	`ChanceOrQuestChance` float NOT NULL default '100',
	614	`groupid` tinyint(3) unsigned NOT NULL default '0',
	615	`mincountOrRef` mediumint(9) NOT NULL default '1',
	616	`maxcount` tinyint(3) unsigned NOT NULL default '1',
	617	`lootcondition` tinyint(3) unsigned NOT NULL default '0',
	618	`condition_value1` mediumint(8) unsigned NOT NULL default '0',
	619	`condition_value2` mediumint(8) unsigned NOT NULL default '0',
	620	PRIMARY KEY (`entry`,`item`)
	621	) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Loot System';
	622
[45]	623	--
	624	-- Dumping data for table `disenchant_loot_template`
	625	--
[37]	626
[45]	627	LOCK TABLES `disenchant_loot_template` WRITE;
	628	/!40000 ALTER TABLE `disenchant_loot_template` DISABLE KEYS /;
	629	/!40000 ALTER TABLE `disenchant_loot_template` ENABLE KEYS /;
	630	UNLOCK TABLES;
[37]	631
[45]	632	--
	633	-- Table structure for table `event_scripts`
	634	--
	635
[37]	636	DROP TABLE IF EXISTS `event_scripts`;
	637	CREATE TABLE `event_scripts` (
	638	`id` mediumint(8) unsigned NOT NULL default '0',
	639	`delay` int(10) unsigned NOT NULL default '0',
	640	`command` mediumint(8) unsigned NOT NULL default '0',
	641	`datalong` mediumint(8) unsigned NOT NULL default '0',
	642	`datalong2` int(10) unsigned NOT NULL default '0',
	643	`datatext` text NOT NULL,
	644	`x` float NOT NULL default '0',
	645	`y` float NOT NULL default '0',
	646	`z` float NOT NULL default '0',
	647	`o` float NOT NULL default '0'
	648	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	649
[45]	650	--
	651	-- Dumping data for table `event_scripts`
	652	--
[37]	653
[45]	654	LOCK TABLES `event_scripts` WRITE;
	655	/!40000 ALTER TABLE `event_scripts` DISABLE KEYS /;
	656	/!40000 ALTER TABLE `event_scripts` ENABLE KEYS /;
	657	UNLOCK TABLES;
[37]	658
[45]	659	--
	660	-- Table structure for table `eventai_localized_texts`
	661	--
	662
	663	DROP TABLE IF EXISTS `eventai_localized_texts`;
	664	CREATE TABLE `eventai_localized_texts` (
	665	`id` int(11) unsigned NOT NULL auto_increment COMMENT 'Identifier',
	666	`locale_1` varchar(255) NOT NULL default '',
	667	`locale_2` varchar(255) NOT NULL default '',
	668	`locale_3` varchar(255) NOT NULL default '',
	669	`locale_4` varchar(255) NOT NULL default '',
	670	`locale_5` varchar(255) NOT NULL default '',
	671	`locale_6` varchar(255) NOT NULL default '',
	672	`locale_7` varchar(255) NOT NULL default '',
	673	`locale_8` varchar(255) NOT NULL default '',
	674	`comment` varchar(255) NOT NULL default '' COMMENT 'Text Comment',
	675	PRIMARY KEY (`id`)
	676	) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='EventAI Localized Text';
	677
	678	--
	679	-- Dumping data for table `eventai_localized_texts`
	680	--
	681
	682	LOCK TABLES `eventai_localized_texts` WRITE;
	683	/!40000 ALTER TABLE `eventai_localized_texts` DISABLE KEYS /;
	684	/!40000 ALTER TABLE `eventai_localized_texts` ENABLE KEYS /;
	685	UNLOCK TABLES;
	686
	687	--
	688	-- Table structure for table `eventai_scripts`
	689	--
	690
	691	DROP TABLE IF EXISTS `eventai_scripts`;
	692	CREATE TABLE `eventai_scripts` (
	693	`id` int(11) unsigned NOT NULL auto_increment COMMENT 'Identifier',
	694	`creature_id` int(11) unsigned NOT NULL default '0' COMMENT 'Creature Template Identifier',
	695	`event_type` tinyint(5) unsigned NOT NULL default '0' COMMENT 'Event Type',
	696	`event_inverse_phase_mask` int(11) NOT NULL default '0' COMMENT 'Mask which phases this event will not trigger in',
	697	`event_chance` int(3) unsigned NOT NULL default '100',
	698	`event_flags` int(3) unsigned NOT NULL default '0',
	699	`event_param1` int(11) NOT NULL default '0',
	700	`event_param2` int(11) NOT NULL default '0',
	701	`event_param3` int(11) NOT NULL default '0',
	702	`event_param4` int(11) NOT NULL default '0',
	703	`action1_type` tinyint(5) unsigned NOT NULL default '0' COMMENT 'Action Type',
	704	`action1_param1` int(11) NOT NULL default '0',
	705	`action1_param2` int(11) NOT NULL default '0',
	706	`action1_param3` int(11) NOT NULL default '0',
	707	`action2_type` tinyint(5) unsigned NOT NULL default '0' COMMENT 'Action Type',
	708	`action2_param1` int(11) NOT NULL default '0',
	709	`action2_param2` int(11) NOT NULL default '0',
	710	`action2_param3` int(11) NOT NULL default '0',
	711	`action3_type` tinyint(5) unsigned NOT NULL default '0' COMMENT 'Action Type',
	712	`action3_param1` int(11) NOT NULL default '0',
	713	`action3_param2` int(11) NOT NULL default '0',
	714	`action3_param3` int(11) NOT NULL default '0',
	715	`comment` varchar(255) NOT NULL default '' COMMENT 'Event Comment',
	716	PRIMARY KEY (`id`)
	717	) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='EventAI Scripts';
	718
	719	--
	720	-- Dumping data for table `eventai_scripts`
	721	--
	722
	723	LOCK TABLES `eventai_scripts` WRITE;
	724	/!40000 ALTER TABLE `eventai_scripts` DISABLE KEYS /;
	725	/!40000 ALTER TABLE `eventai_scripts` ENABLE KEYS /;
	726	UNLOCK TABLES;
	727
	728	--
	729	-- Table structure for table `eventai_summons`
	730	--
	731
	732	DROP TABLE IF EXISTS `eventai_summons`;
	733	CREATE TABLE `eventai_summons` (
	734	`id` int(11) unsigned NOT NULL auto_increment COMMENT 'Location Identifier',
	735	`position_x` float NOT NULL default '0',
	736	`position_y` float NOT NULL default '0',
	737	`position_z` float NOT NULL default '0',
	738	`orientation` float NOT NULL default '0',
	739	`spawntimesecs` int(11) unsigned NOT NULL default '120',
	740	`comment` varchar(255) NOT NULL default '' COMMENT 'Summon Comment',
	741	PRIMARY KEY (`id`)
	742	) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='EventAI Summoning Locations';
	743
	744	--
	745	-- Dumping data for table `eventai_summons`
	746	--
	747
	748	LOCK TABLES `eventai_summons` WRITE;
	749	/!40000 ALTER TABLE `eventai_summons` DISABLE KEYS /;
	750	/!40000 ALTER TABLE `eventai_summons` ENABLE KEYS /;
	751	UNLOCK TABLES;
	752
	753	--
	754	-- Table structure for table `eventai_texts`
	755	--
	756
	757	DROP TABLE IF EXISTS `eventai_texts`;
	758	CREATE TABLE `eventai_texts` (
	759	`id` int(11) unsigned NOT NULL default '0' COMMENT 'Identifier',
	760	`text` varchar(255) NOT NULL default '',
	761	`comment` varchar(255) NOT NULL default '' COMMENT 'Text Comment',
	762	PRIMARY KEY (`id`)
	763	) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Texts used in EventAI';
	764
	765	--
	766	-- Dumping data for table `eventai_texts`
	767	--
	768
	769	LOCK TABLES `eventai_texts` WRITE;
	770	/!40000 ALTER TABLE `eventai_texts` DISABLE KEYS /;
	771	/!40000 ALTER TABLE `eventai_texts` ENABLE KEYS /;
	772	UNLOCK TABLES;
	773
	774	--
	775	-- Table structure for table `exploration_basexp`
	776	--
	777
[37]	778	DROP TABLE IF EXISTS `exploration_basexp`;
	779	CREATE TABLE `exploration_basexp` (
	780	`level` tinyint(4) NOT NULL default '0',
	781	`basexp` mediumint(9) NOT NULL default '0',
	782	PRIMARY KEY (`level`)
	783	) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Exploration System';
	784
[45]	785	--
	786	-- Dumping data for table `exploration_basexp`
	787	--
[37]	788
[45]	789	LOCK TABLES `exploration_basexp` WRITE;
	790	/!40000 ALTER TABLE `exploration_basexp` DISABLE KEYS /;
	791	/!40000 ALTER TABLE `exploration_basexp` ENABLE KEYS /;
	792	UNLOCK TABLES;
[37]	793
[45]	794	--
	795	-- Table structure for table `fishing_loot_template`
	796	--
[37]	797
	798	DROP TABLE IF EXISTS `fishing_loot_template`;
	799	CREATE TABLE `fishing_loot_template` (
	800	`entry` mediumint(8) unsigned NOT NULL default '0',
	801	`item` mediumint(8) unsigned NOT NULL default '0',
	802	`ChanceOrQuestChance` float NOT NULL default '100',
	803	`groupid` tinyint(3) unsigned NOT NULL default '0',
	804	`mincountOrRef` mediumint(9) NOT NULL default '1',
	805	`maxcount` tinyint(3) unsigned NOT NULL default '1',
	806	`lootcondition` tinyint(3) unsigned NOT NULL default '0',
	807	`condition_value1` mediumint(8) unsigned NOT NULL default '0',
	808	`condition_value2` mediumint(8) unsigned NOT NULL default '0',
	809	PRIMARY KEY (`entry`,`item`)
[45]	810	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Loot System';
[37]	811
[45]	812	--
	813	-- Dumping data for table `fishing_loot_template`
	814	--
[37]	815
[45]	816	LOCK TABLES `fishing_loot_template` WRITE;
	817	/!40000 ALTER TABLE `fishing_loot_template` DISABLE KEYS /;
	818	/!40000 ALTER TABLE `fishing_loot_template` ENABLE KEYS /;
	819	UNLOCK TABLES;
[37]	820
[45]	821	--
	822	-- Table structure for table `game_event`
	823	--
	824
[37]	825	DROP TABLE IF EXISTS `game_event`;
	826	CREATE TABLE `game_event` (
	827	`entry` mediumint(8) unsigned NOT NULL COMMENT 'Entry of the game event',
	828	`start_time` timestamp NOT NULL default '0000-00-00 00:00:00' COMMENT 'Absolute start date, the event will never start before',
	829	`end_time` timestamp NOT NULL default '0000-00-00 00:00:00' COMMENT 'Absolute end date, the event will never start afler',
[45]	830	`occurence` bigint(20) unsigned NOT NULL default '5184000' COMMENT 'Delay in minutes between occurences of the event',
	831	`length` bigint(20) unsigned NOT NULL default '2592000' COMMENT 'Length in minutes of the event',
[37]	832	`description` varchar(255) default NULL COMMENT 'Description of the event displayed in console',
[45]	833	`world_event` tinyint(3) unsigned NOT NULL default '0' COMMENT '0 if normal event, 1 if world event',
[37]	834	PRIMARY KEY (`entry`)
	835	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	836
[45]	837	--
	838	-- Dumping data for table `game_event`
	839	--
[37]	840
[45]	841	LOCK TABLES `game_event` WRITE;
	842	/!40000 ALTER TABLE `game_event` DISABLE KEYS /;
	843	/!40000 ALTER TABLE `game_event` ENABLE KEYS /;
	844	UNLOCK TABLES;
[37]	845
[45]	846	--
	847	-- Table structure for table `game_event_condition`
	848	--
	849
	850	DROP TABLE IF EXISTS `game_event_condition`;
	851	CREATE TABLE `game_event_condition` (
	852	`event_id` mediumint(8) unsigned NOT NULL default '0',
	853	`condition_id` mediumint(8) unsigned NOT NULL default '0',
	854	`req_num` float default '0',
	855	`max_world_state_field` smallint(5) unsigned NOT NULL default '0',
	856	`done_world_state_field` smallint(5) unsigned NOT NULL default '0',
	857	`description` varchar(25) NOT NULL default '',
	858	PRIMARY KEY (`event_id`,`condition_id`)
	859	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	860
	861	--
	862	-- Dumping data for table `game_event_condition`
	863	--
	864
	865	LOCK TABLES `game_event_condition` WRITE;
	866	/!40000 ALTER TABLE `game_event_condition` DISABLE KEYS /;
	867	/!40000 ALTER TABLE `game_event_condition` ENABLE KEYS /;
	868	UNLOCK TABLES;
	869
	870	--
	871	-- Table structure for table `game_event_creature`
	872	--
	873
[37]	874	DROP TABLE IF EXISTS `game_event_creature`;
	875	CREATE TABLE `game_event_creature` (
	876	`guid` int(10) unsigned NOT NULL,
	877	`event` smallint(6) NOT NULL default '0' COMMENT 'Put negatives values to remove during event',
[44]	878	PRIMARY KEY (`guid`,`event`)
[37]	879	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	880
[45]	881	--
	882	-- Dumping data for table `game_event_creature`
	883	--
[37]	884
[45]	885	LOCK TABLES `game_event_creature` WRITE;
	886	/!40000 ALTER TABLE `game_event_creature` DISABLE KEYS /;
	887	/!40000 ALTER TABLE `game_event_creature` ENABLE KEYS /;
	888	UNLOCK TABLES;
[37]	889
[45]	890	--
	891	-- Table structure for table `game_event_creature_quest`
	892	--
	893
[37]	894	DROP TABLE IF EXISTS `game_event_creature_quest`;
	895	CREATE TABLE `game_event_creature_quest` (
	896	`id` mediumint(8) unsigned NOT NULL default '0',
	897	`quest` mediumint(8) unsigned NOT NULL default '0',
	898	`event` smallint(5) unsigned NOT NULL default '0',
[44]	899	PRIMARY KEY (`quest`,`event`,`id`)
[37]	900	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	901
[45]	902	--
	903	-- Dumping data for table `game_event_creature_quest`
	904	--
[37]	905
[45]	906	LOCK TABLES `game_event_creature_quest` WRITE;
	907	/!40000 ALTER TABLE `game_event_creature_quest` DISABLE KEYS /;
	908	/!40000 ALTER TABLE `game_event_creature_quest` ENABLE KEYS /;
	909	UNLOCK TABLES;
[44]	910
[45]	911	--
	912	-- Table structure for table `game_event_gameobject`
	913	--
[44]	914
[37]	915	DROP TABLE IF EXISTS `game_event_gameobject`;
	916	CREATE TABLE `game_event_gameobject` (
	917	`guid` int(10) unsigned NOT NULL,
	918	`event` smallint(6) NOT NULL default '0' COMMENT 'Put negatives values to remove during event',
[44]	919	PRIMARY KEY (`guid`,`event`)
[37]	920	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	921
[45]	922	--
	923	-- Dumping data for table `game_event_gameobject`
	924	--
[37]	925
[45]	926	LOCK TABLES `game_event_gameobject` WRITE;
	927	/!40000 ALTER TABLE `game_event_gameobject` DISABLE KEYS /;
	928	/!40000 ALTER TABLE `game_event_gameobject` ENABLE KEYS /;
	929	UNLOCK TABLES;
[37]	930
[45]	931	--
	932	-- Table structure for table `game_event_gameobject_quest`
	933	--
	934
	935	DROP TABLE IF EXISTS `game_event_gameobject_quest`;
	936	CREATE TABLE `game_event_gameobject_quest` (
	937	`id` mediumint(8) unsigned NOT NULL default '0',
	938	`quest` mediumint(8) unsigned NOT NULL default '0',
	939	`event` smallint(5) unsigned NOT NULL default '0',
	940	PRIMARY KEY (`quest`,`event`,`id`)
	941	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	942
	943	--
	944	-- Dumping data for table `game_event_gameobject_quest`
	945	--
	946
	947	LOCK TABLES `game_event_gameobject_quest` WRITE;
	948	/!40000 ALTER TABLE `game_event_gameobject_quest` DISABLE KEYS /;
	949	/!40000 ALTER TABLE `game_event_gameobject_quest` ENABLE KEYS /;
	950	UNLOCK TABLES;
	951
	952	--
	953	-- Table structure for table `game_event_model_equip`
	954	--
	955
[37]	956	DROP TABLE IF EXISTS `game_event_model_equip`;
	957	CREATE TABLE `game_event_model_equip` (
	958	`guid` int(10) unsigned NOT NULL default '0',
	959	`modelid` mediumint(8) unsigned NOT NULL default '0',
	960	`equipment_id` mediumint(8) unsigned NOT NULL default '0',
	961	`event` smallint(5) unsigned NOT NULL default '0',
	962	PRIMARY KEY (`guid`)
	963	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	964
[45]	965	--
	966	-- Dumping data for table `game_event_model_equip`
	967	--
[37]	968
[45]	969	LOCK TABLES `game_event_model_equip` WRITE;
	970	/!40000 ALTER TABLE `game_event_model_equip` DISABLE KEYS /;
	971	/!40000 ALTER TABLE `game_event_model_equip` ENABLE KEYS /;
	972	UNLOCK TABLES;
[37]	973
[45]	974	--
	975	-- Table structure for table `game_event_npc_gossip`
	976	--
	977
	978	DROP TABLE IF EXISTS `game_event_npc_gossip`;
	979	CREATE TABLE `game_event_npc_gossip` (
	980	`guid` int(10) unsigned NOT NULL,
	981	`event_id` mediumint(8) unsigned NOT NULL default '0',
	982	`textid` mediumint(8) unsigned NOT NULL default '0',
	983	PRIMARY KEY (`guid`)
	984	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	985
	986	--
	987	-- Dumping data for table `game_event_npc_gossip`
	988	--
	989
	990	LOCK TABLES `game_event_npc_gossip` WRITE;
	991	/!40000 ALTER TABLE `game_event_npc_gossip` DISABLE KEYS /;
	992	/!40000 ALTER TABLE `game_event_npc_gossip` ENABLE KEYS /;
	993	UNLOCK TABLES;
	994
	995	--
	996	-- Table structure for table `game_event_npc_vendor`
	997	--
	998
	999	DROP TABLE IF EXISTS `game_event_npc_vendor`;
	1000	CREATE TABLE `game_event_npc_vendor` (
	1001	`event` mediumint(8) unsigned NOT NULL default '0',
	1002	`guid` mediumint(8) unsigned NOT NULL default '0',
	1003	`item` mediumint(8) unsigned NOT NULL default '0',
	1004	`maxcount` mediumint(8) unsigned NOT NULL default '0',
	1005	`incrtime` mediumint(8) unsigned NOT NULL default '0',
	1006	`ExtendedCost` mediumint(8) unsigned NOT NULL default '0',
	1007	PRIMARY KEY (`guid`,`item`)
	1008	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	1009
	1010	--
	1011	-- Dumping data for table `game_event_npc_vendor`
	1012	--
	1013
	1014	LOCK TABLES `game_event_npc_vendor` WRITE;
	1015	/!40000 ALTER TABLE `game_event_npc_vendor` DISABLE KEYS /;
	1016	/!40000 ALTER TABLE `game_event_npc_vendor` ENABLE KEYS /;
	1017	UNLOCK TABLES;
	1018
	1019	--
	1020	-- Table structure for table `game_event_npcflag`
	1021	--
	1022
	1023	DROP TABLE IF EXISTS `game_event_npcflag`;
	1024	CREATE TABLE `game_event_npcflag` (
	1025	`guid` mediumint(8) unsigned NOT NULL default '0',
	1026	`event_id` mediumint(8) unsigned NOT NULL default '0',
	1027	`npcflag` int(10) unsigned NOT NULL default '0',
	1028	PRIMARY KEY (`guid`,`event_id`)
	1029	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	1030
	1031	--
	1032	-- Dumping data for table `game_event_npcflag`
	1033	--
	1034
	1035	LOCK TABLES `game_event_npcflag` WRITE;
	1036	/!40000 ALTER TABLE `game_event_npcflag` DISABLE KEYS /;
	1037	/!40000 ALTER TABLE `game_event_npcflag` ENABLE KEYS /;
	1038	UNLOCK TABLES;
	1039
	1040	--
	1041	-- Table structure for table `game_event_prerequisite`
	1042	--
	1043
	1044	DROP TABLE IF EXISTS `game_event_prerequisite`;
	1045	CREATE TABLE `game_event_prerequisite` (
	1046	`event_id` mediumint(8) unsigned NOT NULL,
	1047	`prerequisite_event` mediumint(8) unsigned NOT NULL,
	1048	PRIMARY KEY (`event_id`,`prerequisite_event`)
	1049	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	1050
	1051	--
	1052	-- Dumping data for table `game_event_prerequisite`
	1053	--
	1054
	1055	LOCK TABLES `game_event_prerequisite` WRITE;
	1056	/!40000 ALTER TABLE `game_event_prerequisite` DISABLE KEYS /;
	1057	/!40000 ALTER TABLE `game_event_prerequisite` ENABLE KEYS /;
	1058	UNLOCK TABLES;
	1059
	1060	--
	1061	-- Table structure for table `game_event_quest_condition`
	1062	--
	1063
	1064	DROP TABLE IF EXISTS `game_event_quest_condition`;
	1065	CREATE TABLE `game_event_quest_condition` (
	1066	`quest` mediumint(8) unsigned NOT NULL default '0',
	1067	`event_id` mediumint(8) unsigned NOT NULL default '0',
	1068	`condition_id` mediumint(8) unsigned NOT NULL default '0',
	1069	`num` float default '0',
	1070	PRIMARY KEY (`quest`)
	1071	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	1072
	1073	--
	1074	-- Dumping data for table `game_event_quest_condition`
	1075	--
	1076
	1077	LOCK TABLES `game_event_quest_condition` WRITE;
	1078	/!40000 ALTER TABLE `game_event_quest_condition` DISABLE KEYS /;
	1079	/!40000 ALTER TABLE `game_event_quest_condition` ENABLE KEYS /;
	1080	UNLOCK TABLES;
	1081
	1082	--
	1083	-- Table structure for table `game_graveyard_zone`
	1084	--
	1085
[37]	1086	DROP TABLE IF EXISTS `game_graveyard_zone`;
	1087	CREATE TABLE `game_graveyard_zone` (
	1088	`id` mediumint(8) unsigned NOT NULL default '0',
	1089	`ghost_zone` mediumint(8) unsigned NOT NULL default '0',
	1090	`faction` smallint(5) unsigned NOT NULL default '0',
	1091	PRIMARY KEY (`id`,`ghost_zone`)
	1092	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Trigger System';
	1093
[45]	1094	--
	1095	-- Dumping data for table `game_graveyard_zone`
	1096	--
[37]	1097
[45]	1098	LOCK TABLES `game_graveyard_zone` WRITE;
	1099	/!40000 ALTER TABLE `game_graveyard_zone` DISABLE KEYS /;
	1100	/!40000 ALTER TABLE `game_graveyard_zone` ENABLE KEYS /;
	1101	UNLOCK TABLES;
[37]	1102
[45]	1103	--
	1104	-- Table structure for table `game_tele`
	1105	--
	1106
[37]	1107	DROP TABLE IF EXISTS `game_tele`;
	1108	CREATE TABLE `game_tele` (
	1109	`id` mediumint(8) unsigned NOT NULL auto_increment,
	1110	`position_x` float NOT NULL default '0',
	1111	`position_y` float NOT NULL default '0',
	1112	`position_z` float NOT NULL default '0',
	1113	`orientation` float NOT NULL default '0',
	1114	`map` smallint(5) unsigned NOT NULL default '0',
	1115	`name` varchar(100) NOT NULL default '',
	1116	PRIMARY KEY (`id`)
	1117	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Tele Command';
	1118
[45]	1119	--
	1120	-- Dumping data for table `game_tele`
	1121	--
[37]	1122
[45]	1123	LOCK TABLES `game_tele` WRITE;
	1124	/!40000 ALTER TABLE `game_tele` DISABLE KEYS /;
	1125	/!40000 ALTER TABLE `game_tele` ENABLE KEYS /;
	1126	UNLOCK TABLES;
[37]	1127
[45]	1128	--
	1129	-- Table structure for table `game_weather`
	1130	--
	1131
[37]	1132	DROP TABLE IF EXISTS `game_weather`;
	1133	CREATE TABLE `game_weather` (
	1134	`zone` mediumint(8) unsigned NOT NULL default '0',
	1135	`spring_rain_chance` tinyint(3) unsigned NOT NULL default '25',
	1136	`spring_snow_chance` tinyint(3) unsigned NOT NULL default '25',
	1137	`spring_storm_chance` tinyint(3) unsigned NOT NULL default '25',
	1138	`summer_rain_chance` tinyint(3) unsigned NOT NULL default '25',
	1139	`summer_snow_chance` tinyint(3) unsigned NOT NULL default '25',
	1140	`summer_storm_chance` tinyint(3) unsigned NOT NULL default '25',
	1141	`fall_rain_chance` tinyint(3) unsigned NOT NULL default '25',
	1142	`fall_snow_chance` tinyint(3) unsigned NOT NULL default '25',
	1143	`fall_storm_chance` tinyint(3) unsigned NOT NULL default '25',
	1144	`winter_rain_chance` tinyint(3) unsigned NOT NULL default '25',
	1145	`winter_snow_chance` tinyint(3) unsigned NOT NULL default '25',
	1146	`winter_storm_chance` tinyint(3) unsigned NOT NULL default '25',
	1147	PRIMARY KEY (`zone`)
	1148	) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Weather System';
	1149
[45]	1150	--
	1151	-- Dumping data for table `game_weather`
	1152	--
[37]	1153
[45]	1154	LOCK TABLES `game_weather` WRITE;
	1155	/!40000 ALTER TABLE `game_weather` DISABLE KEYS /;
	1156	/!40000 ALTER TABLE `game_weather` ENABLE KEYS /;
	1157	UNLOCK TABLES;
[37]	1158
[45]	1159	--
	1160	-- Table structure for table `gameobject`
	1161	--
	1162
[37]	1163	DROP TABLE IF EXISTS `gameobject`;
	1164	CREATE TABLE `gameobject` (
	1165	`guid` int(10) unsigned NOT NULL auto_increment COMMENT 'Global Unique Identifier',
	1166	`id` mediumint(8) unsigned NOT NULL default '0' COMMENT 'Gameobject Identifier',
	1167	`map` smallint(5) unsigned NOT NULL default '0' COMMENT 'Map Identifier',
	1168	`spawnMask` tinyint(3) unsigned NOT NULL default '1',
	1169	`position_x` float NOT NULL default '0',
	1170	`position_y` float NOT NULL default '0',
	1171	`position_z` float NOT NULL default '0',
	1172	`orientation` float NOT NULL default '0',
	1173	`rotation0` float NOT NULL default '0',
	1174	`rotation1` float NOT NULL default '0',
	1175	`rotation2` float NOT NULL default '0',
	1176	`rotation3` float NOT NULL default '0',
	1177	`spawntimesecs` int(11) NOT NULL default '0',
	1178	`animprogress` tinyint(3) unsigned NOT NULL default '0',
	1179	`state` tinyint(3) unsigned NOT NULL default '0',
	1180	PRIMARY KEY (`guid`)
	1181	) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Gameobject System';
	1182
[45]	1183	--
	1184	-- Dumping data for table `gameobject`
	1185	--
[37]	1186
[45]	1187	LOCK TABLES `gameobject` WRITE;
	1188	/!40000 ALTER TABLE `gameobject` DISABLE KEYS /;
	1189	/!40000 ALTER TABLE `gameobject` ENABLE KEYS /;
	1190	UNLOCK TABLES;
[37]	1191
[45]	1192	--
	1193	-- Table structure for table `gameobject_involvedrelation`
	1194	--
	1195
[37]	1196	DROP TABLE IF EXISTS `gameobject_involvedrelation`;
	1197	CREATE TABLE `gameobject_involvedrelation` (
	1198	`id` mediumint(8) unsigned NOT NULL default '0',
	1199	`quest` mediumint(8) unsigned NOT NULL default '0' COMMENT 'Quest Identifier',
	1200	PRIMARY KEY (`id`,`quest`)
	1201	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	1202
[45]	1203	--
	1204	-- Dumping data for table `gameobject_involvedrelation`
	1205	--
[37]	1206
[45]	1207	LOCK TABLES `gameobject_involvedrelation` WRITE;
	1208	/!40000 ALTER TABLE `gameobject_involvedrelation` DISABLE KEYS /;
	1209	/!40000 ALTER TABLE `gameobject_involvedrelation` ENABLE KEYS /;
	1210	UNLOCK TABLES;
[37]	1211
[45]	1212	--
	1213	-- Table structure for table `gameobject_loot_template`
	1214	--
	1215
[37]	1216	DROP TABLE IF EXISTS `gameobject_loot_template`;
	1217	CREATE TABLE `gameobject_loot_template` (
	1218	`entry` mediumint(8) unsigned NOT NULL default '0',
	1219	`item` mediumint(8) unsigned NOT NULL default '0',
	1220	`ChanceOrQuestChance` float NOT NULL default '100',
	1221	`groupid` tinyint(3) unsigned NOT NULL default '0',
	1222	`mincountOrRef` mediumint(9) NOT NULL default '1',
	1223	`maxcount` tinyint(3) unsigned NOT NULL default '1',
	1224	`lootcondition` tinyint(3) unsigned NOT NULL default '0',
	1225	`condition_value1` mediumint(8) unsigned NOT NULL default '0',
	1226	`condition_value2` mediumint(8) unsigned NOT NULL default '0',
	1227	PRIMARY KEY (`entry`,`item`)
[45]	1228	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Loot System';
[37]	1229
[45]	1230	--
	1231	-- Dumping data for table `gameobject_loot_template`
	1232	--
[37]	1233
[45]	1234	LOCK TABLES `gameobject_loot_template` WRITE;
	1235	/!40000 ALTER TABLE `gameobject_loot_template` DISABLE KEYS /;
	1236	/!40000 ALTER TABLE `gameobject_loot_template` ENABLE KEYS /;
	1237	UNLOCK TABLES;
[37]	1238
[45]	1239	--
	1240	-- Table structure for table `gameobject_questrelation`
	1241	--
	1242
[37]	1243	DROP TABLE IF EXISTS `gameobject_questrelation`;
	1244	CREATE TABLE `gameobject_questrelation` (
	1245	`id` mediumint(8) unsigned NOT NULL default '0',
	1246	`quest` mediumint(8) unsigned NOT NULL default '0' COMMENT 'Quest Identifier',
	1247	PRIMARY KEY (`id`,`quest`)
	1248	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	1249
[45]	1250	--
	1251	-- Dumping data for table `gameobject_questrelation`
	1252	--
[37]	1253
[45]	1254	LOCK TABLES `gameobject_questrelation` WRITE;
	1255	/!40000 ALTER TABLE `gameobject_questrelation` DISABLE KEYS /;
	1256	/!40000 ALTER TABLE `gameobject_questrelation` ENABLE KEYS /;
	1257	UNLOCK TABLES;
[37]	1258
[45]	1259	--
	1260	-- Table structure for table `gameobject_respawn`
	1261	--
	1262
[37]	1263	DROP TABLE IF EXISTS `gameobject_respawn`;
	1264	CREATE TABLE `gameobject_respawn` (
	1265	`guid` int(10) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
	1266	`respawntime` bigint(20) NOT NULL default '0',
	1267	`instance` mediumint(8) unsigned NOT NULL default '0',
	1268	PRIMARY KEY (`guid`,`instance`),
	1269	KEY `instance` (`instance`)
	1270	) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Grid Loading System';
	1271
[45]	1272	--
	1273	-- Dumping data for table `gameobject_respawn`
	1274	--
[37]	1275
[45]	1276	LOCK TABLES `gameobject_respawn` WRITE;
	1277	/!40000 ALTER TABLE `gameobject_respawn` DISABLE KEYS /;
	1278	/!40000 ALTER TABLE `gameobject_respawn` ENABLE KEYS /;
	1279	UNLOCK TABLES;
[37]	1280
[45]	1281	--
	1282	-- Table structure for table `gameobject_scripts`
	1283	--
	1284
[37]	1285	DROP TABLE IF EXISTS `gameobject_scripts`;
	1286	CREATE TABLE `gameobject_scripts` (
	1287	`id` mediumint(8) unsigned NOT NULL default '0',
	1288	`delay` int(10) unsigned NOT NULL default '0',
	1289	`command` mediumint(8) unsigned NOT NULL default '0',
	1290	`datalong` mediumint(8) unsigned NOT NULL default '0',
	1291	`datalong2` int(10) unsigned NOT NULL default '0',
	1292	`datatext` text NOT NULL,
	1293	`x` float NOT NULL default '0',
	1294	`y` float NOT NULL default '0',
	1295	`z` float NOT NULL default '0',
	1296	`o` float NOT NULL default '0'
	1297	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	1298
[45]	1299	--
	1300	-- Dumping data for table `gameobject_scripts`
	1301	--
[37]	1302
[45]	1303	LOCK TABLES `gameobject_scripts` WRITE;
	1304	/!40000 ALTER TABLE `gameobject_scripts` DISABLE KEYS /;
	1305	/!40000 ALTER TABLE `gameobject_scripts` ENABLE KEYS /;
	1306	UNLOCK TABLES;
[37]	1307
[45]	1308	--
	1309	-- Table structure for table `gameobject_template`
	1310	--
	1311
[37]	1312	DROP TABLE IF EXISTS `gameobject_template`;
	1313	CREATE TABLE `gameobject_template` (
	1314	`entry` mediumint(8) unsigned NOT NULL default '0',
	1315	`type` tinyint(3) unsigned NOT NULL default '0',
	1316	`displayId` mediumint(8) unsigned NOT NULL default '0',
	1317	`name` varchar(100) NOT NULL default '',
	1318	`castBarCaption` varchar(100) NOT NULL default '',
	1319	`faction` smallint(5) unsigned NOT NULL default '0',
	1320	`flags` int(10) unsigned NOT NULL default '0',
	1321	`size` float NOT NULL default '1',
	1322	`data0` int(10) unsigned NOT NULL default '0',
	1323	`data1` int(10) unsigned NOT NULL default '0',
	1324	`data2` int(10) unsigned NOT NULL default '0',
	1325	`data3` int(10) unsigned NOT NULL default '0',
	1326	`data4` int(10) unsigned NOT NULL default '0',
	1327	`data5` int(10) unsigned NOT NULL default '0',
	1328	`data6` int(10) unsigned NOT NULL default '0',
	1329	`data7` int(10) unsigned NOT NULL default '0',
	1330	`data8` int(10) unsigned NOT NULL default '0',
	1331	`data9` int(10) unsigned NOT NULL default '0',
	1332	`data10` int(10) unsigned NOT NULL default '0',
	1333	`data11` int(10) unsigned NOT NULL default '0',
	1334	`data12` int(10) unsigned NOT NULL default '0',
	1335	`data13` int(10) unsigned NOT NULL default '0',
	1336	`data14` int(10) unsigned NOT NULL default '0',
	1337	`data15` int(10) unsigned NOT NULL default '0',
	1338	`data16` int(10) unsigned NOT NULL default '0',
	1339	`data17` int(10) unsigned NOT NULL default '0',
	1340	`data18` int(10) unsigned NOT NULL default '0',
	1341	`data19` int(10) unsigned NOT NULL default '0',
	1342	`data20` int(10) unsigned NOT NULL default '0',
	1343	`data21` int(10) unsigned NOT NULL default '0',
	1344	`data22` int(10) unsigned NOT NULL default '0',
	1345	`data23` int(10) unsigned NOT NULL default '0',
	1346	`ScriptName` varchar(64) NOT NULL default '',
[45]	1347	PRIMARY KEY (`entry`),
	1348	KEY `idx_name` (`name`)
[37]	1349	) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Gameobject System';
	1350
[45]	1351	--
	1352	-- Dumping data for table `gameobject_template`
	1353	--
[37]	1354
[45]	1355	LOCK TABLES `gameobject_template` WRITE;
	1356	/!40000 ALTER TABLE `gameobject_template` DISABLE KEYS /;
	1357	/!40000 ALTER TABLE `gameobject_template` ENABLE KEYS /;
	1358	UNLOCK TABLES;
[37]	1359
[45]	1360	--
	1361	-- Table structure for table `instance_template`
	1362	--
	1363
[37]	1364	DROP TABLE IF EXISTS `instance_template`;
	1365	CREATE TABLE `instance_template` (
	1366	`map` smallint(5) unsigned NOT NULL,
	1367	`parent` int(10) unsigned NOT NULL,
	1368	`levelMin` tinyint(3) unsigned NOT NULL default '0',
	1369	`levelMax` tinyint(3) unsigned NOT NULL default '0',
	1370	`maxPlayers` tinyint(3) unsigned NOT NULL default '0',
	1371	`reset_delay` int(10) unsigned NOT NULL default '0',
	1372	`startLocX` float default NULL,
	1373	`startLocY` float default NULL,
	1374	`startLocZ` float default NULL,
	1375	`startLocO` float default NULL,
	1376	`script` varchar(128) NOT NULL default '',
	1377	PRIMARY KEY (`map`)
	1378	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	1379
[45]	1380	--
	1381	-- Dumping data for table `instance_template`
	1382	--
[37]	1383
[45]	1384	LOCK TABLES `instance_template` WRITE;
	1385	/!40000 ALTER TABLE `instance_template` DISABLE KEYS /;
	1386	/!40000 ALTER TABLE `instance_template` ENABLE KEYS /;
	1387	UNLOCK TABLES;
[37]	1388
[45]	1389	--
	1390	-- Table structure for table `item_enchantment_template`
	1391	--
[37]	1392
	1393	DROP TABLE IF EXISTS `item_enchantment_template`;
	1394	CREATE TABLE `item_enchantment_template` (
	1395	`entry` mediumint(8) unsigned NOT NULL default '0',
	1396	`ench` mediumint(8) unsigned NOT NULL default '0',
	1397	`chance` float unsigned NOT NULL default '0',
	1398	PRIMARY KEY (`entry`,`ench`)
	1399	) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Item Random Enchantment System';
	1400
[45]	1401	--
	1402	-- Dumping data for table `item_enchantment_template`
	1403	--
[37]	1404
[45]	1405	LOCK TABLES `item_enchantment_template` WRITE;
	1406	/!40000 ALTER TABLE `item_enchantment_template` DISABLE KEYS /;
	1407	/!40000 ALTER TABLE `item_enchantment_template` ENABLE KEYS /;
	1408	UNLOCK TABLES;
[37]	1409
[45]	1410	--
	1411	-- Table structure for table `item_loot_template`
	1412	--
	1413
[37]	1414	DROP TABLE IF EXISTS `item_loot_template`;
	1415	CREATE TABLE `item_loot_template` (
	1416	`entry` mediumint(8) unsigned NOT NULL default '0',
	1417	`item` mediumint(8) unsigned NOT NULL default '0',
	1418	`ChanceOrQuestChance` float NOT NULL default '100',
	1419	`groupid` tinyint(3) unsigned NOT NULL default '0',
	1420	`mincountOrRef` mediumint(9) NOT NULL default '1',
[45]	1421	`maxcount` smallint(5) unsigned NOT NULL default '1',
[37]	1422	`lootcondition` tinyint(3) unsigned NOT NULL default '0',
	1423	`condition_value1` mediumint(8) unsigned NOT NULL default '0',
	1424	`condition_value2` mediumint(8) unsigned NOT NULL default '0',
	1425	PRIMARY KEY (`entry`,`item`)
	1426	) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Loot System';
	1427
[45]	1428	--
	1429	-- Dumping data for table `item_loot_template`
	1430	--
[37]	1431
[45]	1432	LOCK TABLES `item_loot_template` WRITE;
	1433	/!40000 ALTER TABLE `item_loot_template` DISABLE KEYS /;
	1434	/!40000 ALTER TABLE `item_loot_template` ENABLE KEYS /;
	1435	UNLOCK TABLES;
[37]	1436
[45]	1437	--
	1438	-- Table structure for table `item_template`
	1439	--
	1440
[37]	1441	DROP TABLE IF EXISTS `item_template`;
	1442	CREATE TABLE `item_template` (
	1443	`entry` mediumint(8) unsigned NOT NULL default '0',
	1444	`class` tinyint(3) unsigned NOT NULL default '0',
	1445	`subclass` tinyint(3) unsigned NOT NULL default '0',
	1446	`unk0` int(11) NOT NULL default '-1',
	1447	`name` varchar(255) NOT NULL default '',
	1448	`displayid` mediumint(8) unsigned NOT NULL default '0',
	1449	`Quality` tinyint(3) unsigned NOT NULL default '0',
	1450	`Flags` int(10) unsigned NOT NULL default '0',
	1451	`BuyCount` tinyint(3) unsigned NOT NULL default '1',
	1452	`BuyPrice` int(10) unsigned NOT NULL default '0',
	1453	`SellPrice` int(10) unsigned NOT NULL default '0',
	1454	`InventoryType` tinyint(3) unsigned NOT NULL default '0',
	1455	`AllowableClass` mediumint(9) NOT NULL default '-1',
	1456	`AllowableRace` mediumint(9) NOT NULL default '-1',
	1457	`ItemLevel` tinyint(3) unsigned NOT NULL default '0',
	1458	`RequiredLevel` tinyint(3) unsigned NOT NULL default '0',
	1459	`RequiredSkill` smallint(5) unsigned NOT NULL default '0',
	1460	`RequiredSkillRank` smallint(5) unsigned NOT NULL default '0',
	1461	`requiredspell` mediumint(8) unsigned NOT NULL default '0',
	1462	`requiredhonorrank` mediumint(8) unsigned NOT NULL default '0',
	1463	`RequiredCityRank` mediumint(8) unsigned NOT NULL default '0',
	1464	`RequiredReputationFaction` smallint(5) unsigned NOT NULL default '0',
	1465	`RequiredReputationRank` smallint(5) unsigned NOT NULL default '0',
	1466	`maxcount` smallint(5) unsigned NOT NULL default '0',
	1467	`stackable` smallint(5) unsigned NOT NULL default '1',
	1468	`ContainerSlots` tinyint(3) unsigned NOT NULL default '0',
	1469	`stat_type1` tinyint(3) unsigned NOT NULL default '0',
	1470	`stat_value1` smallint(6) NOT NULL default '0',
	1471	`stat_type2` tinyint(3) unsigned NOT NULL default '0',
	1472	`stat_value2` smallint(6) NOT NULL default '0',
	1473	`stat_type3` tinyint(3) unsigned NOT NULL default '0',
	1474	`stat_value3` smallint(6) NOT NULL default '0',
	1475	`stat_type4` tinyint(3) unsigned NOT NULL default '0',
	1476	`stat_value4` smallint(6) NOT NULL default '0',
	1477	`stat_type5` tinyint(3) unsigned NOT NULL default '0',
	1478	`stat_value5` smallint(6) NOT NULL default '0',
	1479	`stat_type6` tinyint(3) unsigned NOT NULL default '0',
	1480	`stat_value6` smallint(6) NOT NULL default '0',
	1481	`stat_type7` tinyint(3) unsigned NOT NULL default '0',
	1482	`stat_value7` smallint(6) NOT NULL default '0',
	1483	`stat_type8` tinyint(3) unsigned NOT NULL default '0',
	1484	`stat_value8` smallint(6) NOT NULL default '0',
	1485	`stat_type9` tinyint(3) unsigned NOT NULL default '0',
	1486	`stat_value9` smallint(6) NOT NULL default '0',
	1487	`stat_type10` tinyint(3) unsigned NOT NULL default '0',
	1488	`stat_value10` smallint(6) NOT NULL default '0',
	1489	`dmg_min1` float NOT NULL default '0',
	1490	`dmg_max1` float NOT NULL default '0',
	1491	`dmg_type1` tinyint(3) unsigned NOT NULL default '0',
	1492	`dmg_min2` float NOT NULL default '0',
	1493	`dmg_max2` float NOT NULL default '0',
	1494	`dmg_type2` tinyint(3) unsigned NOT NULL default '0',
	1495	`dmg_min3` float NOT NULL default '0',
	1496	`dmg_max3` float NOT NULL default '0',
	1497	`dmg_type3` tinyint(3) unsigned NOT NULL default '0',
	1498	`dmg_min4` float NOT NULL default '0',
	1499	`dmg_max4` float NOT NULL default '0',
	1500	`dmg_type4` tinyint(3) unsigned NOT NULL default '0',
	1501	`dmg_min5` float NOT NULL default '0',
	1502	`dmg_max5` float NOT NULL default '0',
	1503	`dmg_type5` tinyint(3) unsigned NOT NULL default '0',
	1504	`armor` smallint(5) unsigned NOT NULL default '0',
	1505	`holy_res` tinyint(3) unsigned NOT NULL default '0',
	1506	`fire_res` tinyint(3) unsigned NOT NULL default '0',
	1507	`nature_res` tinyint(3) unsigned NOT NULL default '0',
	1508	`frost_res` tinyint(3) unsigned NOT NULL default '0',
	1509	`shadow_res` tinyint(3) unsigned NOT NULL default '0',
	1510	`arcane_res` tinyint(3) unsigned NOT NULL default '0',
	1511	`delay` smallint(5) unsigned NOT NULL default '1000',
	1512	`ammo_type` tinyint(3) unsigned NOT NULL default '0',
	1513	`RangedModRange` float NOT NULL default '0',
	1514	`spellid_1` mediumint(8) unsigned NOT NULL default '0',
	1515	`spelltrigger_1` tinyint(3) unsigned NOT NULL default '0',
	1516	`spellcharges_1` tinyint(4) NOT NULL default '0',
	1517	`spellppmRate_1` float NOT NULL default '0',
	1518	`spellcooldown_1` int(11) NOT NULL default '-1',
	1519	`spellcategory_1` smallint(5) unsigned NOT NULL default '0',
	1520	`spellcategorycooldown_1` int(11) NOT NULL default '-1',
	1521	`spellid_2` mediumint(8) unsigned NOT NULL default '0',
	1522	`spelltrigger_2` tinyint(3) unsigned NOT NULL default '0',
	1523	`spellcharges_2` tinyint(4) NOT NULL default '0',
	1524	`spellppmRate_2` float NOT NULL default '0',
	1525	`spellcooldown_2` int(11) NOT NULL default '-1',
	1526	`spellcategory_2` smallint(5) unsigned NOT NULL default '0',
	1527	`spellcategorycooldown_2` int(11) NOT NULL default '-1',
	1528	`spellid_3` mediumint(8) unsigned NOT NULL default '0',
	1529	`spelltrigger_3` tinyint(3) unsigned NOT NULL default '0',
	1530	`spellcharges_3` tinyint(4) NOT NULL default '0',
	1531	`spellppmRate_3` float NOT NULL default '0',
	1532	`spellcooldown_3` int(11) NOT NULL default '-1',
	1533	`spellcategory_3` smallint(5) unsigned NOT NULL default '0',
	1534	`spellcategorycooldown_3` int(11) NOT NULL default '-1',
	1535	`spellid_4` mediumint(8) unsigned NOT NULL default '0',
	1536	`spelltrigger_4` tinyint(3) unsigned NOT NULL default '0',
	1537	`spellcharges_4` tinyint(4) NOT NULL default '0',
	1538	`spellppmRate_4` float NOT NULL default '0',
	1539	`spellcooldown_4` int(11) NOT NULL default '-1',
	1540	`spellcategory_4` smallint(5) unsigned NOT NULL default '0',
	1541	`spellcategorycooldown_4` int(11) NOT NULL default '-1',
	1542	`spellid_5` mediumint(8) unsigned NOT NULL default '0',
	1543	`spelltrigger_5` tinyint(3) unsigned NOT NULL default '0',
	1544	`spellcharges_5` tinyint(4) NOT NULL default '0',
	1545	`spellppmRate_5` float NOT NULL default '0',
	1546	`spellcooldown_5` int(11) NOT NULL default '-1',
	1547	`spellcategory_5` smallint(5) unsigned NOT NULL default '0',
	1548	`spellcategorycooldown_5` int(11) NOT NULL default '-1',
	1549	`bonding` tinyint(3) unsigned NOT NULL default '0',
	1550	`description` varchar(255) NOT NULL default '',
	1551	`PageText` mediumint(8) unsigned NOT NULL default '0',
	1552	`LanguageID` tinyint(3) unsigned NOT NULL default '0',
	1553	`PageMaterial` tinyint(3) unsigned NOT NULL default '0',
	1554	`startquest` mediumint(8) unsigned NOT NULL default '0',
	1555	`lockid` mediumint(8) unsigned NOT NULL default '0',
	1556	`Material` tinyint(4) NOT NULL default '0',
	1557	`sheath` tinyint(3) unsigned NOT NULL default '0',
	1558	`RandomProperty` mediumint(8) unsigned NOT NULL default '0',
	1559	`RandomSuffix` mediumint(8) unsigned NOT NULL default '0',
	1560	`block` mediumint(8) unsigned NOT NULL default '0',
	1561	`itemset` mediumint(8) unsigned NOT NULL default '0',
	1562	`MaxDurability` smallint(5) unsigned NOT NULL default '0',
	1563	`area` mediumint(8) unsigned NOT NULL default '0',
	1564	`Map` smallint(6) NOT NULL default '0',
	1565	`BagFamily` mediumint(9) NOT NULL default '0',
	1566	`TotemCategory` tinyint(4) NOT NULL default '0',
	1567	`socketColor_1` tinyint(4) NOT NULL default '0',
	1568	`socketContent_1` mediumint(9) NOT NULL default '0',
	1569	`socketColor_2` tinyint(4) NOT NULL default '0',
	1570	`socketContent_2` mediumint(9) NOT NULL default '0',
	1571	`socketColor_3` tinyint(4) NOT NULL default '0',
	1572	`socketContent_3` mediumint(9) NOT NULL default '0',
	1573	`socketBonus` mediumint(9) NOT NULL default '0',
	1574	`GemProperties` mediumint(9) NOT NULL default '0',
	1575	`RequiredDisenchantSkill` smallint(6) NOT NULL default '-1',
	1576	`ArmorDamageModifier` float NOT NULL default '0',
	1577	`ScriptName` varchar(64) NOT NULL default '',
	1578	`DisenchantID` mediumint(8) unsigned NOT NULL default '0',
	1579	`FoodType` tinyint(3) unsigned NOT NULL default '0',
	1580	`minMoneyLoot` int(10) unsigned NOT NULL default '0',
	1581	`maxMoneyLoot` int(10) unsigned NOT NULL default '0',
	1582	`Duration` int(11) NOT NULL default '0' COMMENT 'Duration in seconds. Negative value means realtime, postive value ingame time',
	1583	PRIMARY KEY (`entry`),
[45]	1584	KEY `idx_name` (`name`),
[37]	1585	KEY `items_index` (`class`)
	1586	) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Item System';
	1587
[45]	1588	--
	1589	-- Dumping data for table `item_template`
	1590	--
[37]	1591
[45]	1592	LOCK TABLES `item_template` WRITE;
	1593	/!40000 ALTER TABLE `item_template` DISABLE KEYS /;
	1594	/!40000 ALTER TABLE `item_template` ENABLE KEYS /;
	1595	UNLOCK TABLES;
[37]	1596
[45]	1597	--
	1598	-- Table structure for table `locales_creature`
	1599	--
[37]	1600
	1601	DROP TABLE IF EXISTS `locales_creature`;
	1602	CREATE TABLE `locales_creature` (
	1603	`entry` mediumint(8) unsigned NOT NULL default '0',
	1604	`name_loc1` varchar(100) NOT NULL default '',
	1605	`name_loc2` varchar(100) NOT NULL default '',
	1606	`name_loc3` varchar(100) NOT NULL default '',
	1607	`name_loc4` varchar(100) NOT NULL default '',
	1608	`name_loc5` varchar(100) NOT NULL default '',
	1609	`name_loc6` varchar(100) NOT NULL default '',
	1610	`name_loc7` varchar(100) NOT NULL default '',
	1611	`name_loc8` varchar(100) NOT NULL default '',
	1612	`subname_loc1` varchar(100) default NULL,
	1613	`subname_loc2` varchar(100) default NULL,
	1614	`subname_loc3` varchar(100) default NULL,
	1615	`subname_loc4` varchar(100) default NULL,
	1616	`subname_loc5` varchar(100) default NULL,
	1617	`subname_loc6` varchar(100) default NULL,
	1618	`subname_loc7` varchar(100) default NULL,
	1619	`subname_loc8` varchar(100) default NULL,
	1620	PRIMARY KEY (`entry`)
	1621	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	1622
[45]	1623	--
	1624	-- Dumping data for table `locales_creature`
	1625	--
[37]	1626
[45]	1627	LOCK TABLES `locales_creature` WRITE;
	1628	/!40000 ALTER TABLE `locales_creature` DISABLE KEYS /;
	1629	/!40000 ALTER TABLE `locales_creature` ENABLE KEYS /;
	1630	UNLOCK TABLES;
[37]	1631
[45]	1632	--
	1633	-- Table structure for table `locales_gameobject`
	1634	--
	1635
[37]	1636	DROP TABLE IF EXISTS `locales_gameobject`;
	1637	CREATE TABLE `locales_gameobject` (
	1638	`entry` mediumint(8) unsigned NOT NULL default '0',
	1639	`name_loc1` varchar(100) NOT NULL default '',
	1640	`name_loc2` varchar(100) NOT NULL default '',
	1641	`name_loc3` varchar(100) NOT NULL default '',
	1642	`name_loc4` varchar(100) NOT NULL default '',
	1643	`name_loc5` varchar(100) NOT NULL default '',
	1644	`name_loc6` varchar(100) NOT NULL default '',
	1645	`name_loc7` varchar(100) NOT NULL default '',
	1646	`name_loc8` varchar(100) NOT NULL default '',
	1647	`castbarcaption_loc1` varchar(100) NOT NULL default '',
	1648	`castbarcaption_loc2` varchar(100) NOT NULL default '',
	1649	`castbarcaption_loc3` varchar(100) NOT NULL default '',
	1650	`castbarcaption_loc4` varchar(100) NOT NULL default '',
	1651	`castbarcaption_loc5` varchar(100) NOT NULL default '',
	1652	`castbarcaption_loc6` varchar(100) NOT NULL default '',
	1653	`castbarcaption_loc7` varchar(100) NOT NULL default '',
	1654	`castbarcaption_loc8` varchar(100) NOT NULL default '',
	1655	PRIMARY KEY (`entry`)
	1656	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	1657
[45]	1658	--
	1659	-- Dumping data for table `locales_gameobject`
	1660	--
[37]	1661
[45]	1662	LOCK TABLES `locales_gameobject` WRITE;
	1663	/!40000 ALTER TABLE `locales_gameobject` DISABLE KEYS /;
	1664	/!40000 ALTER TABLE `locales_gameobject` ENABLE KEYS /;
	1665	UNLOCK TABLES;
[37]	1666
[45]	1667	--
	1668	-- Table structure for table `locales_item`
	1669	--
	1670
[37]	1671	DROP TABLE IF EXISTS `locales_item`;
	1672	CREATE TABLE `locales_item` (
	1673	`entry` mediumint(8) unsigned NOT NULL default '0',
	1674	`name_loc1` varchar(100) NOT NULL default '',
	1675	`name_loc2` varchar(100) NOT NULL default '',
	1676	`name_loc3` varchar(100) NOT NULL default '',
	1677	`name_loc4` varchar(100) NOT NULL default '',
	1678	`name_loc5` varchar(100) NOT NULL default '',
	1679	`name_loc6` varchar(100) NOT NULL default '',
	1680	`name_loc7` varchar(100) NOT NULL default '',
	1681	`name_loc8` varchar(100) NOT NULL default '',
	1682	`description_loc1` varchar(255) default NULL,
	1683	`description_loc2` varchar(255) default NULL,
	1684	`description_loc3` varchar(255) default NULL,
	1685	`description_loc4` varchar(255) default NULL,
	1686	`description_loc5` varchar(255) default NULL,
	1687	`description_loc6` varchar(255) default NULL,
	1688	`description_loc7` varchar(255) default NULL,
	1689	`description_loc8` varchar(255) default NULL,
	1690	PRIMARY KEY (`entry`)
	1691	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	1692
[45]	1693	--
	1694	-- Dumping data for table `locales_item`
	1695	--
[37]	1696
[45]	1697	LOCK TABLES `locales_item` WRITE;
	1698	/!40000 ALTER TABLE `locales_item` DISABLE KEYS /;
	1699	/!40000 ALTER TABLE `locales_item` ENABLE KEYS /;
	1700	UNLOCK TABLES;
[37]	1701
[45]	1702	--
	1703	-- Table structure for table `locales_npc_text`
	1704	--
	1705
[37]	1706	DROP TABLE IF EXISTS `locales_npc_text`;
	1707	CREATE TABLE `locales_npc_text` (
	1708	`entry` mediumint(8) unsigned NOT NULL default '0',
	1709	`Text0_0_loc1` longtext,
	1710	`Text0_0_loc2` longtext,
	1711	`Text0_0_loc3` longtext,
	1712	`Text0_0_loc4` longtext,
	1713	`Text0_0_loc5` longtext,
	1714	`Text0_0_loc6` longtext,
	1715	`Text0_0_loc7` longtext,
	1716	`Text0_0_loc8` longtext,
	1717	`Text0_1_loc1` longtext,
	1718	`Text0_1_loc2` longtext,
	1719	`Text0_1_loc3` longtext,
	1720	`Text0_1_loc4` longtext,
	1721	`Text0_1_loc5` longtext,
	1722	`Text0_1_loc6` longtext,
	1723	`Text0_1_loc7` longtext,
	1724	`Text0_1_loc8` longtext,
	1725	`Text1_0_loc1` longtext,
	1726	`Text1_0_loc2` longtext,
	1727	`Text1_0_loc3` longtext,
	1728	`Text1_0_loc4` longtext,
	1729	`Text1_0_loc5` longtext,
	1730	`Text1_0_loc6` longtext,
	1731	`Text1_0_loc7` longtext,
	1732	`Text1_0_loc8` longtext,
	1733	`Text1_1_loc1` longtext,
	1734	`Text1_1_loc2` longtext,
	1735	`Text1_1_loc3` longtext,
	1736	`Text1_1_loc4` longtext,
	1737	`Text1_1_loc5` longtext,
	1738	`Text1_1_loc6` longtext,
	1739	`Text1_1_loc7` longtext,
	1740	`Text1_1_loc8` longtext,
	1741	`Text2_0_loc1` longtext,
	1742	`Text2_0_loc2` longtext,
	1743	`Text2_0_loc3` longtext,
	1744	`Text2_0_loc4` longtext,
	1745	`Text2_0_loc5` longtext,
	1746	`Text2_0_loc6` longtext,
	1747	`Text2_0_loc7` longtext,
	1748	`Text2_0_loc8` longtext,
	1749	`Text2_1_loc1` longtext,
	1750	`Text2_1_loc2` longtext,
	1751	`Text2_1_loc3` longtext,
	1752	`Text2_1_loc4` longtext,
	1753	`Text2_1_loc5` longtext,
	1754	`Text2_1_loc6` longtext,
	1755	`Text2_1_loc7` longtext,
	1756	`Text2_1_loc8` longtext,
	1757	`Text3_0_loc1` longtext,
	1758	`Text3_0_loc2` longtext,
	1759	`Text3_0_loc3` longtext,
	1760	`Text3_0_loc4` longtext,
	1761	`Text3_0_loc5` longtext,
	1762	`Text3_0_loc6` longtext,
	1763	`Text3_0_loc7` longtext,
	1764	`Text3_0_loc8` longtext,
	1765	`Text3_1_loc1` longtext,
	1766	`Text3_1_loc2` longtext,
	1767	`Text3_1_loc3` longtext,
	1768	`Text3_1_loc4` longtext,
	1769	`Text3_1_loc5` longtext,
	1770	`Text3_1_loc6` longtext,
	1771	`Text3_1_loc7` longtext,
	1772	`Text3_1_loc8` longtext,
	1773	`Text4_0_loc1` longtext,
	1774	`Text4_0_loc2` longtext,
	1775	`Text4_0_loc3` longtext,
	1776	`Text4_0_loc4` longtext,
	1777	`Text4_0_loc5` longtext,
	1778	`Text4_0_loc6` longtext,
	1779	`Text4_0_loc7` longtext,
	1780	`Text4_0_loc8` longtext,
	1781	`Text4_1_loc1` longtext,
	1782	`Text4_1_loc2` longtext,
	1783	`Text4_1_loc3` longtext,
	1784	`Text4_1_loc4` longtext,
	1785	`Text4_1_loc5` longtext,
	1786	`Text4_1_loc6` longtext,
	1787	`Text4_1_loc7` longtext,
	1788	`Text4_1_loc8` longtext,
	1789	`Text5_0_loc1` longtext,
	1790	`Text5_0_loc2` longtext,
	1791	`Text5_0_loc3` longtext,
	1792	`Text5_0_loc4` longtext,
	1793	`Text5_0_loc5` longtext,
	1794	`Text5_0_loc6` longtext,
	1795	`Text5_0_loc7` longtext,
	1796	`Text5_0_loc8` longtext,
	1797	`Text5_1_loc1` longtext,
	1798	`Text5_1_loc2` longtext,
	1799	`Text5_1_loc3` longtext,
	1800	`Text5_1_loc4` longtext,
	1801	`Text5_1_loc5` longtext,
	1802	`Text5_1_loc6` longtext,
	1803	`Text5_1_loc7` longtext,
	1804	`Text5_1_loc8` longtext,
	1805	`Text6_0_loc1` longtext,
	1806	`Text6_0_loc2` longtext,
	1807	`Text6_0_loc3` longtext,
	1808	`Text6_0_loc4` longtext,
	1809	`Text6_0_loc5` longtext,
	1810	`Text6_0_loc6` longtext,
	1811	`Text6_0_loc7` longtext,
	1812	`Text6_0_loc8` longtext,
	1813	`Text6_1_loc1` longtext,
	1814	`Text6_1_loc2` longtext,
	1815	`Text6_1_loc3` longtext,
	1816	`Text6_1_loc4` longtext,
	1817	`Text6_1_loc5` longtext,
	1818	`Text6_1_loc6` longtext,
	1819	`Text6_1_loc7` longtext,
	1820	`Text6_1_loc8` longtext,
	1821	`Text7_0_loc1` longtext,
	1822	`Text7_0_loc2` longtext,
	1823	`Text7_0_loc3` longtext,
	1824	`Text7_0_loc4` longtext,
	1825	`Text7_0_loc5` longtext,
	1826	`Text7_0_loc6` longtext,
	1827	`Text7_0_loc7` longtext,
	1828	`Text7_0_loc8` longtext,
	1829	`Text7_1_loc1` longtext,
	1830	`Text7_1_loc2` longtext,
	1831	`Text7_1_loc3` longtext,
	1832	`Text7_1_loc4` longtext,
	1833	`Text7_1_loc5` longtext,
	1834	`Text7_1_loc6` longtext,
	1835	`Text7_1_loc7` longtext,
	1836	`Text7_1_loc8` longtext,
	1837	PRIMARY KEY (`entry`)
	1838	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	1839
[45]	1840	--
	1841	-- Dumping data for table `locales_npc_text`
	1842	--
[37]	1843
[45]	1844	LOCK TABLES `locales_npc_text` WRITE;
	1845	/!40000 ALTER TABLE `locales_npc_text` DISABLE KEYS /;
	1846	/!40000 ALTER TABLE `locales_npc_text` ENABLE KEYS /;
	1847	UNLOCK TABLES;
[37]	1848
[45]	1849	--
	1850	-- Table structure for table `locales_page_text`
	1851	--
	1852
[37]	1853	DROP TABLE IF EXISTS `locales_page_text`;
	1854	CREATE TABLE `locales_page_text` (
	1855	`entry` mediumint(8) unsigned NOT NULL default '0',
	1856	`Text_loc1` longtext,
	1857	`Text_loc2` longtext,
	1858	`Text_loc3` longtext,
	1859	`Text_loc4` longtext,
	1860	`Text_loc5` longtext,
	1861	`Text_loc6` longtext,
	1862	`Text_loc7` longtext,
	1863	`Text_loc8` longtext,
	1864	PRIMARY KEY (`entry`)
	1865	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	1866
[45]	1867	--
	1868	-- Dumping data for table `locales_page_text`
	1869	--
[37]	1870
[45]	1871	LOCK TABLES `locales_page_text` WRITE;
	1872	/!40000 ALTER TABLE `locales_page_text` DISABLE KEYS /;
	1873	/!40000 ALTER TABLE `locales_page_text` ENABLE KEYS /;
	1874	UNLOCK TABLES;
[37]	1875
[45]	1876	--
	1877	-- Table structure for table `locales_quest`
	1878	--
	1879
[37]	1880	DROP TABLE IF EXISTS `locales_quest`;
	1881	CREATE TABLE `locales_quest` (
	1882	`entry` mediumint(8) unsigned NOT NULL default '0',
	1883	`Title_loc1` text,
	1884	`Title_loc2` text,
	1885	`Title_loc3` text,
	1886	`Title_loc4` text,
	1887	`Title_loc5` text,
	1888	`Title_loc6` text,
	1889	`Title_loc7` text,
	1890	`Title_loc8` text,
	1891	`Details_loc1` text,
	1892	`Details_loc2` text,
	1893	`Details_loc3` text,
	1894	`Details_loc4` text,
	1895	`Details_loc5` text,
	1896	`Details_loc6` text,
	1897	`Details_loc7` text,
	1898	`Details_loc8` text,
	1899	`Objectives_loc1` text,
	1900	`Objectives_loc2` text,
	1901	`Objectives_loc3` text,
	1902	`Objectives_loc4` text,
	1903	`Objectives_loc5` text,
	1904	`Objectives_loc6` text,
	1905	`Objectives_loc7` text,
	1906	`Objectives_loc8` text,
	1907	`OfferRewardText_loc1` text,
	1908	`OfferRewardText_loc2` text,
	1909	`OfferRewardText_loc3` text,
	1910	`OfferRewardText_loc4` text,
	1911	`OfferRewardText_loc5` text,
	1912	`OfferRewardText_loc6` text,
	1913	`OfferRewardText_loc7` text,
	1914	`OfferRewardText_loc8` text,
	1915	`RequestItemsText_loc1` text,
	1916	`RequestItemsText_loc2` text,
	1917	`RequestItemsText_loc3` text,
	1918	`RequestItemsText_loc4` text,
	1919	`RequestItemsText_loc5` text,
	1920	`RequestItemsText_loc6` text,
	1921	`RequestItemsText_loc7` text,
	1922	`RequestItemsText_loc8` text,
	1923	`EndText_loc1` text,
	1924	`EndText_loc2` text,
	1925	`EndText_loc3` text,
	1926	`EndText_loc4` text,
	1927	`EndText_loc5` text,
	1928	`EndText_loc6` text,
	1929	`EndText_loc7` text,
	1930	`EndText_loc8` text,
	1931	`ObjectiveText1_loc1` text,
	1932	`ObjectiveText1_loc2` text,
	1933	`ObjectiveText1_loc3` text,
	1934	`ObjectiveText1_loc4` text,
	1935	`ObjectiveText1_loc5` text,
	1936	`ObjectiveText1_loc6` text,
	1937	`ObjectiveText1_loc7` text,
	1938	`ObjectiveText1_loc8` text,
	1939	`ObjectiveText2_loc1` text,
	1940	`ObjectiveText2_loc2` text,
	1941	`ObjectiveText2_loc3` text,
	1942	`ObjectiveText2_loc4` text,
	1943	`ObjectiveText2_loc5` text,
	1944	`ObjectiveText2_loc6` text,
	1945	`ObjectiveText2_loc7` text,
	1946	`ObjectiveText2_loc8` text,
	1947	`ObjectiveText3_loc1` text,
	1948	`ObjectiveText3_loc2` text,
	1949	`ObjectiveText3_loc3` text,
	1950	`ObjectiveText3_loc4` text,
	1951	`ObjectiveText3_loc5` text,
	1952	`ObjectiveText3_loc6` text,
	1953	`ObjectiveText3_loc7` text,
	1954	`ObjectiveText3_loc8` text,
	1955	`ObjectiveText4_loc1` text,
	1956	`ObjectiveText4_loc2` text,
	1957	`ObjectiveText4_loc3` text,
	1958	`ObjectiveText4_loc4` text,
	1959	`ObjectiveText4_loc5` text,
	1960	`ObjectiveText4_loc6` text,
	1961	`ObjectiveText4_loc7` text,
	1962	`ObjectiveText4_loc8` text,
	1963	PRIMARY KEY (`entry`)
	1964	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	1965
[45]	1966	--
	1967	-- Dumping data for table `locales_quest`
	1968	--
[37]	1969
[45]	1970	LOCK TABLES `locales_quest` WRITE;
	1971	/!40000 ALTER TABLE `locales_quest` DISABLE KEYS /;
	1972	/!40000 ALTER TABLE `locales_quest` ENABLE KEYS /;
	1973	UNLOCK TABLES;
[37]	1974
[45]	1975	--
	1976	-- Table structure for table `npc_gossip`
	1977	--
[39]	1978
[37]	1979	DROP TABLE IF EXISTS `npc_gossip`;
	1980	CREATE TABLE `npc_gossip` (
	1981	`npc_guid` int(10) unsigned NOT NULL default '0',
	1982	`textid` mediumint(8) unsigned NOT NULL default '0',
	1983	PRIMARY KEY (`npc_guid`)
	1984	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	1985
[45]	1986	--
	1987	-- Dumping data for table `npc_gossip`
	1988	--
[37]	1989
[45]	1990	LOCK TABLES `npc_gossip` WRITE;
	1991	/!40000 ALTER TABLE `npc_gossip` DISABLE KEYS /;
	1992	/!40000 ALTER TABLE `npc_gossip` ENABLE KEYS /;
	1993	UNLOCK TABLES;
[37]	1994
[45]	1995	--
	1996	-- Table structure for table `npc_gossip_textid`
	1997	--
	1998
[37]	1999	DROP TABLE IF EXISTS `npc_gossip_textid`;
	2000	CREATE TABLE `npc_gossip_textid` (
	2001	`zoneid` smallint(5) unsigned NOT NULL default '0',
	2002	`action` smallint(5) unsigned NOT NULL default '0',
	2003	`textid` mediumint(8) unsigned NOT NULL default '0',
	2004	KEY `zoneid` (`zoneid`)
	2005	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	2006
[45]	2007	--
	2008	-- Dumping data for table `npc_gossip_textid`
	2009	--
[37]	2010
[45]	2011	LOCK TABLES `npc_gossip_textid` WRITE;
	2012	/!40000 ALTER TABLE `npc_gossip_textid` DISABLE KEYS /;
	2013	/!40000 ALTER TABLE `npc_gossip_textid` ENABLE KEYS /;
	2014	UNLOCK TABLES;
[37]	2015
[45]	2016	--
	2017	-- Table structure for table `npc_option`
	2018	--
	2019
[37]	2020	DROP TABLE IF EXISTS `npc_option`;
	2021	CREATE TABLE `npc_option` (
	2022	`id` tinyint(3) unsigned NOT NULL default '0',
	2023	`gossip_id` tinyint(3) unsigned NOT NULL default '0',
	2024	`npcflag` int(10) unsigned NOT NULL default '0',
	2025	`icon` tinyint(3) unsigned NOT NULL default '0',
	2026	`action` tinyint(3) unsigned NOT NULL default '0',
	2027	`option_text` text,
	2028	PRIMARY KEY (`id`)
	2029	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	2030
[45]	2031	--
	2032	-- Dumping data for table `npc_option`
	2033	--
[37]	2034
[45]	2035	LOCK TABLES `npc_option` WRITE;
	2036	/!40000 ALTER TABLE `npc_option` DISABLE KEYS /;
	2037	/!40000 ALTER TABLE `npc_option` ENABLE KEYS /;
	2038	UNLOCK TABLES;
[37]	2039
[45]	2040	--
	2041	-- Table structure for table `npc_text`
	2042	--
	2043
[37]	2044	DROP TABLE IF EXISTS `npc_text`;
	2045	CREATE TABLE `npc_text` (
	2046	`ID` mediumint(8) unsigned NOT NULL default '0',
	2047	`text0_0` longtext,
	2048	`text0_1` longtext,
	2049	`lang0` tinyint(3) unsigned NOT NULL default '0',
	2050	`prob0` float NOT NULL default '0',
	2051	`em0_0` smallint(5) unsigned NOT NULL default '0',
	2052	`em0_1` smallint(5) unsigned NOT NULL default '0',
	2053	`em0_2` smallint(5) unsigned NOT NULL default '0',
	2054	`em0_3` smallint(5) unsigned NOT NULL default '0',
	2055	`em0_4` smallint(5) unsigned NOT NULL default '0',
	2056	`em0_5` smallint(5) unsigned NOT NULL default '0',
	2057	`text1_0` longtext,
	2058	`text1_1` longtext,
	2059	`lang1` tinyint(3) unsigned NOT NULL default '0',
	2060	`prob1` float NOT NULL default '0',
	2061	`em1_0` smallint(5) unsigned NOT NULL default '0',
	2062	`em1_1` smallint(5) unsigned NOT NULL default '0',
	2063	`em1_2` smallint(5) unsigned NOT NULL default '0',
	2064	`em1_3` smallint(5) unsigned NOT NULL default '0',
	2065	`em1_4` smallint(5) unsigned NOT NULL default '0',
	2066	`em1_5` smallint(5) unsigned NOT NULL default '0',
	2067	`text2_0` longtext,
	2068	`text2_1` longtext,
	2069	`lang2` tinyint(3) unsigned NOT NULL default '0',
	2070	`prob2` float NOT NULL default '0',
	2071	`em2_0` smallint(5) unsigned NOT NULL default '0',
	2072	`em2_1` smallint(5) unsigned NOT NULL default '0',
	2073	`em2_2` smallint(5) unsigned NOT NULL default '0',
	2074	`em2_3` smallint(5) unsigned NOT NULL default '0',
	2075	`em2_4` smallint(5) unsigned NOT NULL default '0',
	2076	`em2_5` smallint(5) unsigned NOT NULL default '0',
	2077	`text3_0` longtext,
	2078	`text3_1` longtext,
	2079	`lang3` tinyint(3) unsigned NOT NULL default '0',
	2080	`prob3` float NOT NULL default '0',
	2081	`em3_0` smallint(5) unsigned NOT NULL default '0',
	2082	`em3_1` smallint(5) unsigned NOT NULL default '0',
	2083	`em3_2` smallint(5) unsigned NOT NULL default '0',
	2084	`em3_3` smallint(5) unsigned NOT NULL default '0',
	2085	`em3_4` smallint(5) unsigned NOT NULL default '0',
	2086	`em3_5` smallint(5) unsigned NOT NULL default '0',
	2087	`text4_0` longtext,
	2088	`text4_1` longtext,
	2089	`lang4` tinyint(3) unsigned NOT NULL default '0',
	2090	`prob4` float NOT NULL default '0',
	2091	`em4_0` smallint(5) unsigned NOT NULL default '0',
	2092	`em4_1` smallint(5) unsigned NOT NULL default '0',
	2093	`em4_2` smallint(5) unsigned NOT NULL default '0',
	2094	`em4_3` smallint(5) unsigned NOT NULL default '0',
	2095	`em4_4` smallint(5) unsigned NOT NULL default '0',
	2096	`em4_5` smallint(5) unsigned NOT NULL default '0',
	2097	`text5_0` longtext,
	2098	`text5_1` longtext,
	2099	`lang5` tinyint(3) unsigned NOT NULL default '0',
	2100	`prob5` float NOT NULL default '0',
	2101	`em5_0` smallint(5) unsigned NOT NULL default '0',
	2102	`em5_1` smallint(5) unsigned NOT NULL default '0',
	2103	`em5_2` smallint(5) unsigned NOT NULL default '0',
	2104	`em5_3` smallint(5) unsigned NOT NULL default '0',
	2105	`em5_4` smallint(5) unsigned NOT NULL default '0',
	2106	`em5_5` smallint(5) unsigned NOT NULL default '0',
	2107	`text6_0` longtext,
	2108	`text6_1` longtext,
	2109	`lang6` tinyint(3) unsigned NOT NULL default '0',
	2110	`prob6` float NOT NULL default '0',
	2111	`em6_0` smallint(5) unsigned NOT NULL default '0',
	2112	`em6_1` smallint(5) unsigned NOT NULL default '0',
	2113	`em6_2` smallint(5) unsigned NOT NULL default '0',
	2114	`em6_3` smallint(5) unsigned NOT NULL default '0',
	2115	`em6_4` smallint(5) unsigned NOT NULL default '0',
	2116	`em6_5` smallint(5) unsigned NOT NULL default '0',
	2117	`text7_0` longtext,
	2118	`text7_1` longtext,
	2119	`lang7` tinyint(3) unsigned NOT NULL default '0',
	2120	`prob7` float NOT NULL default '0',
	2121	`em7_0` smallint(5) unsigned NOT NULL default '0',
	2122	`em7_1` smallint(5) unsigned NOT NULL default '0',
	2123	`em7_2` smallint(5) unsigned NOT NULL default '0',
	2124	`em7_3` smallint(5) unsigned NOT NULL default '0',
	2125	`em7_4` smallint(5) unsigned NOT NULL default '0',
	2126	`em7_5` smallint(5) unsigned NOT NULL default '0',
	2127	PRIMARY KEY (`ID`)
	2128	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	2129
[45]	2130	--
	2131	-- Dumping data for table `npc_text`
	2132	--
[37]	2133
[45]	2134	LOCK TABLES `npc_text` WRITE;
	2135	/!40000 ALTER TABLE `npc_text` DISABLE KEYS /;
	2136	/!40000 ALTER TABLE `npc_text` ENABLE KEYS /;
	2137	UNLOCK TABLES;
[37]	2138
[45]	2139	--
	2140	-- Table structure for table `npc_trainer`
	2141	--
	2142
[37]	2143	DROP TABLE IF EXISTS `npc_trainer`;
	2144	CREATE TABLE `npc_trainer` (
	2145	`entry` mediumint(8) unsigned NOT NULL default '0',
	2146	`spell` mediumint(8) unsigned NOT NULL default '0',
	2147	`spellcost` int(10) unsigned NOT NULL default '0',
	2148	`reqskill` smallint(5) unsigned NOT NULL default '0',
	2149	`reqskillvalue` smallint(5) unsigned NOT NULL default '0',
	2150	`reqlevel` tinyint(3) unsigned NOT NULL default '0',
[45]	2151	PRIMARY KEY (`entry`,`spell`)
[37]	2152	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	2153
[45]	2154	--
	2155	-- Dumping data for table `npc_trainer`
	2156	--
[37]	2157
[45]	2158	LOCK TABLES `npc_trainer` WRITE;
	2159	/!40000 ALTER TABLE `npc_trainer` DISABLE KEYS /;
	2160	/!40000 ALTER TABLE `npc_trainer` ENABLE KEYS /;
	2161	UNLOCK TABLES;
[37]	2162
[45]	2163	--
	2164	-- Table structure for table `npc_vendor`
	2165	--
	2166
[37]	2167	DROP TABLE IF EXISTS `npc_vendor`;
	2168	CREATE TABLE `npc_vendor` (
	2169	`entry` mediumint(8) unsigned NOT NULL default '0',
	2170	`item` mediumint(8) unsigned NOT NULL default '0',
	2171	`maxcount` tinyint(3) unsigned NOT NULL default '0',
	2172	`incrtime` int(10) unsigned NOT NULL default '0',
	2173	`ExtendedCost` mediumint(8) unsigned NOT NULL default '0',
	2174	PRIMARY KEY (`entry`,`item`)
	2175	) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Npc System';
	2176
[45]	2177	--
	2178	-- Dumping data for table `npc_vendor`
	2179	--
[37]	2180
[45]	2181	LOCK TABLES `npc_vendor` WRITE;
	2182	/!40000 ALTER TABLE `npc_vendor` DISABLE KEYS /;
	2183	/!40000 ALTER TABLE `npc_vendor` ENABLE KEYS /;
	2184	UNLOCK TABLES;
[37]	2185
[45]	2186	--
	2187	-- Table structure for table `page_text`
	2188	--
	2189
[37]	2190	DROP TABLE IF EXISTS `page_text`;
	2191	CREATE TABLE `page_text` (
	2192	`entry` mediumint(8) unsigned NOT NULL default '0',
	2193	`text` longtext NOT NULL,
	2194	`next_page` mediumint(8) unsigned NOT NULL default '0',
	2195	PRIMARY KEY (`entry`)
[45]	2196	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Item System';
[37]	2197
[45]	2198	--
	2199	-- Dumping data for table `page_text`
	2200	--
[37]	2201
[45]	2202	LOCK TABLES `page_text` WRITE;
	2203	/!40000 ALTER TABLE `page_text` DISABLE KEYS /;
	2204	/!40000 ALTER TABLE `page_text` ENABLE KEYS /;
	2205	UNLOCK TABLES;
[37]	2206
[45]	2207	--
	2208	-- Table structure for table `pet_levelstats`
	2209	--
	2210
[37]	2211	DROP TABLE IF EXISTS `pet_levelstats`;
	2212	CREATE TABLE `pet_levelstats` (
	2213	`creature_entry` mediumint(8) unsigned NOT NULL,
	2214	`level` tinyint(3) unsigned NOT NULL,
	2215	`hp` smallint(5) unsigned NOT NULL,
	2216	`mana` smallint(5) unsigned NOT NULL,
	2217	`armor` int(10) unsigned NOT NULL default '0',
	2218	`str` smallint(5) unsigned NOT NULL,
	2219	`agi` smallint(5) unsigned NOT NULL,
	2220	`sta` smallint(5) unsigned NOT NULL,
	2221	`inte` smallint(5) unsigned NOT NULL,
	2222	`spi` smallint(5) unsigned NOT NULL,
	2223	PRIMARY KEY (`creature_entry`,`level`)
	2224	) ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0 COMMENT='Stores pet levels stats.';
	2225
[45]	2226	--
	2227	-- Dumping data for table `pet_levelstats`
	2228	--
[37]	2229
[45]	2230	LOCK TABLES `pet_levelstats` WRITE;
	2231	/!40000 ALTER TABLE `pet_levelstats` DISABLE KEYS /;
	2232	/!40000 ALTER TABLE `pet_levelstats` ENABLE KEYS /;
	2233	UNLOCK TABLES;
[37]	2234
[45]	2235	--
	2236	-- Table structure for table `pet_name_generation`
	2237	--
	2238
[37]	2239	DROP TABLE IF EXISTS `pet_name_generation`;
	2240	CREATE TABLE `pet_name_generation` (
	2241	`id` mediumint(8) unsigned NOT NULL auto_increment,
	2242	`word` tinytext NOT NULL,
	2243	`entry` mediumint(8) unsigned NOT NULL default '0',
	2244	`half` tinyint(4) NOT NULL default '0',
	2245	PRIMARY KEY (`id`)
[45]	2246	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
[37]	2247
[45]	2248	--
	2249	-- Dumping data for table `pet_name_generation`
	2250	--
[37]	2251
[45]	2252	LOCK TABLES `pet_name_generation` WRITE;
	2253	/!40000 ALTER TABLE `pet_name_generation` DISABLE KEYS /;
	2254	/!40000 ALTER TABLE `pet_name_generation` ENABLE KEYS /;
	2255	UNLOCK TABLES;
[37]	2256
[45]	2257	--
	2258	-- Table structure for table `petcreateinfo_spell`
	2259	--
[37]	2260
	2261	DROP TABLE IF EXISTS `petcreateinfo_spell`;
	2262	CREATE TABLE `petcreateinfo_spell` (
	2263	`entry` mediumint(8) unsigned NOT NULL default '0',
	2264	`Spell1` mediumint(8) unsigned NOT NULL default '0',
	2265	`Spell2` mediumint(8) unsigned NOT NULL default '0',
	2266	`Spell3` mediumint(8) unsigned NOT NULL default '0',
	2267	`Spell4` mediumint(8) unsigned NOT NULL default '0',
	2268	PRIMARY KEY (`entry`)
	2269	) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Pet Create Spells';
	2270
[45]	2271	--
	2272	-- Dumping data for table `petcreateinfo_spell`
	2273	--
[37]	2274
[45]	2275	LOCK TABLES `petcreateinfo_spell` WRITE;
	2276	/!40000 ALTER TABLE `petcreateinfo_spell` DISABLE KEYS /;
	2277	/!40000 ALTER TABLE `petcreateinfo_spell` ENABLE KEYS /;
	2278	UNLOCK TABLES;
[37]	2279
[45]	2280	--
	2281	-- Table structure for table `pickpocketing_loot_template`
	2282	--
	2283
[37]	2284	DROP TABLE IF EXISTS `pickpocketing_loot_template`;
	2285	CREATE TABLE `pickpocketing_loot_template` (
	2286	`entry` mediumint(8) unsigned NOT NULL default '0',
	2287	`item` mediumint(8) unsigned NOT NULL default '0',
	2288	`ChanceOrQuestChance` float NOT NULL default '100',
	2289	`groupid` tinyint(3) unsigned NOT NULL default '0',
	2290	`mincountOrRef` mediumint(9) NOT NULL default '1',
	2291	`maxcount` tinyint(3) unsigned NOT NULL default '1',
	2292	`lootcondition` tinyint(3) unsigned NOT NULL default '0',
	2293	`condition_value1` mediumint(8) unsigned NOT NULL default '0',
	2294	`condition_value2` mediumint(8) unsigned NOT NULL default '0',
	2295	PRIMARY KEY (`entry`,`item`)
	2296	) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Loot System';
	2297
[45]	2298	--
	2299	-- Dumping data for table `pickpocketing_loot_template`
	2300	--
[37]	2301
[45]	2302	LOCK TABLES `pickpocketing_loot_template` WRITE;
	2303	/!40000 ALTER TABLE `pickpocketing_loot_template` DISABLE KEYS /;
	2304	/!40000 ALTER TABLE `pickpocketing_loot_template` ENABLE KEYS /;
	2305	UNLOCK TABLES;
[37]	2306
[45]	2307	--
	2308	-- Table structure for table `player_classlevelstats`
	2309	--
	2310
[37]	2311	DROP TABLE IF EXISTS `player_classlevelstats`;
	2312	CREATE TABLE `player_classlevelstats` (
	2313	`class` tinyint(3) unsigned NOT NULL,
	2314	`level` tinyint(3) unsigned NOT NULL,
	2315	`basehp` smallint(5) unsigned NOT NULL,
	2316	`basemana` smallint(5) unsigned NOT NULL,
	2317	PRIMARY KEY (`class`,`level`)
	2318	) ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0 COMMENT='Stores levels stats.';
	2319
[45]	2320	--
	2321	-- Dumping data for table `player_classlevelstats`
	2322	--
[37]	2323
[45]	2324	LOCK TABLES `player_classlevelstats` WRITE;
	2325	/!40000 ALTER TABLE `player_classlevelstats` DISABLE KEYS /;
	2326	/!40000 ALTER TABLE `player_classlevelstats` ENABLE KEYS /;
	2327	UNLOCK TABLES;
[37]	2328
[45]	2329	--
	2330	-- Table structure for table `player_levelstats`
	2331	--
[37]	2332
	2333	DROP TABLE IF EXISTS `player_levelstats`;
	2334	CREATE TABLE `player_levelstats` (
	2335	`race` tinyint(3) unsigned NOT NULL,
	2336	`class` tinyint(3) unsigned NOT NULL,
	2337	`level` tinyint(3) unsigned NOT NULL,
	2338	`str` tinyint(3) unsigned NOT NULL,
	2339	`agi` tinyint(3) unsigned NOT NULL,
	2340	`sta` tinyint(3) unsigned NOT NULL,
	2341	`inte` tinyint(3) unsigned NOT NULL,
	2342	`spi` tinyint(3) unsigned NOT NULL,
	2343	PRIMARY KEY (`race`,`class`,`level`)
	2344	) ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0 COMMENT='Stores levels stats.';
	2345
[45]	2346	--
	2347	-- Dumping data for table `player_levelstats`
	2348	--
[37]	2349
[45]	2350	LOCK TABLES `player_levelstats` WRITE;
	2351	/!40000 ALTER TABLE `player_levelstats` DISABLE KEYS /;
	2352	/!40000 ALTER TABLE `player_levelstats` ENABLE KEYS /;
	2353	UNLOCK TABLES;
[37]	2354
[45]	2355	--
	2356	-- Table structure for table `playercreateinfo`
	2357	--
[37]	2358
	2359	DROP TABLE IF EXISTS `playercreateinfo`;
	2360	CREATE TABLE `playercreateinfo` (
	2361	`race` tinyint(3) unsigned NOT NULL default '0',
	2362	`class` tinyint(3) unsigned NOT NULL default '0',
	2363	`map` smallint(5) unsigned NOT NULL default '0',
	2364	`zone` mediumint(8) unsigned NOT NULL default '0',
	2365	`position_x` float NOT NULL default '0',
	2366	`position_y` float NOT NULL default '0',
	2367	`position_z` float NOT NULL default '0',
	2368	PRIMARY KEY (`race`,`class`)
	2369	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	2370
[45]	2371	--
	2372	-- Dumping data for table `playercreateinfo`
	2373	--
[37]	2374
[45]	2375	LOCK TABLES `playercreateinfo` WRITE;
	2376	/!40000 ALTER TABLE `playercreateinfo` DISABLE KEYS /;
	2377	/!40000 ALTER TABLE `playercreateinfo` ENABLE KEYS /;
	2378	UNLOCK TABLES;
[37]	2379
[45]	2380	--
	2381	-- Table structure for table `playercreateinfo_action`
	2382	--
[37]	2383
	2384	DROP TABLE IF EXISTS `playercreateinfo_action`;
	2385	CREATE TABLE `playercreateinfo_action` (
	2386	`race` tinyint(3) unsigned NOT NULL default '0',
	2387	`class` tinyint(3) unsigned NOT NULL default '0',
	2388	`button` smallint(5) unsigned NOT NULL default '0',
	2389	`action` smallint(5) unsigned NOT NULL default '0',
	2390	`type` smallint(5) unsigned NOT NULL default '0',
	2391	`misc` smallint(5) unsigned NOT NULL default '0',
	2392	KEY `playercreateinfo_race_class_index` (`race`,`class`)
	2393	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	2394
[45]	2395	--
	2396	-- Dumping data for table `playercreateinfo_action`
	2397	--
[37]	2398
[45]	2399	LOCK TABLES `playercreateinfo_action` WRITE;
	2400	/!40000 ALTER TABLE `playercreateinfo_action` DISABLE KEYS /;
	2401	/!40000 ALTER TABLE `playercreateinfo_action` ENABLE KEYS /;
	2402	UNLOCK TABLES;
[37]	2403
[45]	2404	--
	2405	-- Table structure for table `playercreateinfo_item`
	2406	--
[37]	2407
	2408	DROP TABLE IF EXISTS `playercreateinfo_item`;
	2409	CREATE TABLE `playercreateinfo_item` (
	2410	`race` tinyint(3) unsigned NOT NULL default '0',
	2411	`class` tinyint(3) unsigned NOT NULL default '0',
	2412	`itemid` mediumint(8) unsigned NOT NULL default '0',
	2413	`amount` tinyint(3) unsigned NOT NULL default '1',
	2414	KEY `playercreateinfo_race_class_index` (`race`,`class`)
	2415	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	2416
[45]	2417	--
	2418	-- Dumping data for table `playercreateinfo_item`
	2419	--
[37]	2420
[45]	2421	LOCK TABLES `playercreateinfo_item` WRITE;
	2422	/!40000 ALTER TABLE `playercreateinfo_item` DISABLE KEYS /;
	2423	/!40000 ALTER TABLE `playercreateinfo_item` ENABLE KEYS /;
	2424	UNLOCK TABLES;
[37]	2425
[45]	2426	--
	2427	-- Table structure for table `playercreateinfo_spell`
	2428	--
[37]	2429
	2430	DROP TABLE IF EXISTS `playercreateinfo_spell`;
	2431	CREATE TABLE `playercreateinfo_spell` (
	2432	`race` tinyint(3) unsigned NOT NULL default '0',
	2433	`class` tinyint(3) unsigned NOT NULL default '0',
	2434	`Spell` mediumint(8) unsigned NOT NULL default '0',
	2435	`Note` varchar(255) default NULL,
	2436	`Active` tinyint(3) unsigned NOT NULL default '1',
	2437	PRIMARY KEY (`race`,`class`,`Spell`)
	2438	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	2439
[45]	2440	--
	2441	-- Dumping data for table `playercreateinfo_spell`
	2442	--
[37]	2443
[45]	2444	LOCK TABLES `playercreateinfo_spell` WRITE;
	2445	/!40000 ALTER TABLE `playercreateinfo_spell` DISABLE KEYS /;
	2446	/!40000 ALTER TABLE `playercreateinfo_spell` ENABLE KEYS /;
	2447	UNLOCK TABLES;
[37]	2448
[45]	2449	--
	2450	-- Table structure for table `playercreateinfo_spell_custom`
	2451	--
[37]	2452
[39]	2453	DROP TABLE IF EXISTS `playercreateinfo_spell_custom`;
	2454	CREATE TABLE `playercreateinfo_spell_custom` (
	2455	`race` tinyint(3) unsigned NOT NULL default '0',
	2456	`class` tinyint(3) unsigned NOT NULL default '0',
	2457	`Spell` mediumint(8) unsigned NOT NULL default '0',
	2458	`Note` varchar(255) default NULL,
	2459	`Active` tinyint(3) unsigned NOT NULL default '1',
	2460	PRIMARY KEY (`race`,`class`,`Spell`)
	2461	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	2462
[45]	2463	--
	2464	-- Dumping data for table `playercreateinfo_spell_custom`
	2465	--
[39]	2466
[45]	2467	LOCK TABLES `playercreateinfo_spell_custom` WRITE;
	2468	/!40000 ALTER TABLE `playercreateinfo_spell_custom` DISABLE KEYS /;
	2469	/!40000 ALTER TABLE `playercreateinfo_spell_custom` ENABLE KEYS /;
	2470	UNLOCK TABLES;
[39]	2471
[45]	2472	--
	2473	-- Table structure for table `prospecting_loot_template`
	2474	--
[39]	2475
[37]	2476	DROP TABLE IF EXISTS `prospecting_loot_template`;
	2477	CREATE TABLE `prospecting_loot_template` (
	2478	`entry` mediumint(8) unsigned NOT NULL default '0',
	2479	`item` mediumint(8) unsigned NOT NULL default '0',
	2480	`ChanceOrQuestChance` float NOT NULL default '100',
	2481	`groupid` tinyint(3) unsigned NOT NULL default '0',
	2482	`mincountOrRef` mediumint(9) NOT NULL default '1',
	2483	`maxcount` tinyint(3) unsigned NOT NULL default '1',
	2484	`lootcondition` tinyint(3) unsigned NOT NULL default '0',
	2485	`condition_value1` mediumint(8) unsigned NOT NULL default '0',
	2486	`condition_value2` mediumint(8) unsigned NOT NULL default '0',
	2487	PRIMARY KEY (`entry`,`item`)
	2488	) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Loot System';
	2489
[45]	2490	--
	2491	-- Dumping data for table `prospecting_loot_template`
	2492	--
[37]	2493
[45]	2494	LOCK TABLES `prospecting_loot_template` WRITE;
	2495	/!40000 ALTER TABLE `prospecting_loot_template` DISABLE KEYS /;
	2496	/!40000 ALTER TABLE `prospecting_loot_template` ENABLE KEYS /;
	2497	UNLOCK TABLES;
[37]	2498
[45]	2499	--
	2500	-- Table structure for table `quest_end_scripts`
	2501	--
	2502
[37]	2503	DROP TABLE IF EXISTS `quest_end_scripts`;
	2504	CREATE TABLE `quest_end_scripts` (
	2505	`id` mediumint(8) unsigned NOT NULL default '0',
	2506	`delay` int(10) unsigned NOT NULL default '0',
	2507	`command` mediumint(8) unsigned NOT NULL default '0',
	2508	`datalong` mediumint(8) unsigned NOT NULL default '0',
	2509	`datalong2` int(10) unsigned NOT NULL default '0',
	2510	`datatext` text NOT NULL,
	2511	`x` float NOT NULL default '0',
	2512	`y` float NOT NULL default '0',
	2513	`z` float NOT NULL default '0',
	2514	`o` float NOT NULL default '0'
	2515	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	2516
[45]	2517	--
	2518	-- Dumping data for table `quest_end_scripts`
	2519	--
[37]	2520
[45]	2521	LOCK TABLES `quest_end_scripts` WRITE;
	2522	/!40000 ALTER TABLE `quest_end_scripts` DISABLE KEYS /;
	2523	/!40000 ALTER TABLE `quest_end_scripts` ENABLE KEYS /;
	2524	UNLOCK TABLES;
[37]	2525
[45]	2526	--
	2527	-- Table structure for table `quest_mail_loot_template`
	2528	--
	2529
[37]	2530	DROP TABLE IF EXISTS `quest_mail_loot_template`;
	2531	CREATE TABLE `quest_mail_loot_template` (
	2532	`entry` mediumint(8) unsigned NOT NULL default '0',
	2533	`item` mediumint(8) unsigned NOT NULL default '0',
	2534	`ChanceOrQuestChance` float NOT NULL default '100',
	2535	`groupid` tinyint(3) unsigned NOT NULL default '0',
	2536	`mincountOrRef` mediumint(9) NOT NULL default '1',
	2537	`maxcount` tinyint(3) unsigned NOT NULL default '1',
	2538	`lootcondition` tinyint(3) unsigned NOT NULL default '0',
	2539	`condition_value1` mediumint(8) unsigned NOT NULL default '0',
	2540	`condition_value2` mediumint(8) unsigned NOT NULL default '0',
	2541	PRIMARY KEY (`entry`,`item`)
	2542	) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Loot System';
	2543
[45]	2544	--
	2545	-- Dumping data for table `quest_mail_loot_template`
	2546	--
[37]	2547
[45]	2548	LOCK TABLES `quest_mail_loot_template` WRITE;
	2549	/!40000 ALTER TABLE `quest_mail_loot_template` DISABLE KEYS /;
	2550	/!40000 ALTER TABLE `quest_mail_loot_template` ENABLE KEYS /;
	2551	UNLOCK TABLES;
[37]	2552
[45]	2553	--
	2554	-- Table structure for table `quest_start_scripts`
	2555	--
	2556
[39]	2557	DROP TABLE IF EXISTS `quest_start_scripts`;
	2558	CREATE TABLE `quest_start_scripts` (
	2559	`id` mediumint(8) unsigned NOT NULL default '0',
	2560	`delay` int(10) unsigned NOT NULL default '0',
	2561	`command` mediumint(8) unsigned NOT NULL default '0',
	2562	`datalong` mediumint(8) unsigned NOT NULL default '0',
	2563	`datalong2` int(10) unsigned NOT NULL default '0',
	2564	`datatext` text NOT NULL,
	2565	`x` float NOT NULL default '0',
	2566	`y` float NOT NULL default '0',
	2567	`z` float NOT NULL default '0',
	2568	`o` float NOT NULL default '0'
	2569	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	2570
[45]	2571	--
	2572	-- Dumping data for table `quest_start_scripts`
	2573	--
[39]	2574
[45]	2575	LOCK TABLES `quest_start_scripts` WRITE;
	2576	/!40000 ALTER TABLE `quest_start_scripts` DISABLE KEYS /;
	2577	/!40000 ALTER TABLE `quest_start_scripts` ENABLE KEYS /;
	2578	UNLOCK TABLES;
[39]	2579
[45]	2580	--
	2581	-- Table structure for table `quest_template`
	2582	--
	2583
[37]	2584	DROP TABLE IF EXISTS `quest_template`;
	2585	CREATE TABLE `quest_template` (
	2586	`entry` mediumint(8) unsigned NOT NULL default '0',
	2587	`Method` tinyint(3) unsigned NOT NULL default '2',
	2588	`ZoneOrSort` smallint(6) NOT NULL default '0',
	2589	`SkillOrClass` smallint(6) NOT NULL default '0',
	2590	`MinLevel` tinyint(3) unsigned NOT NULL default '0',
	2591	`QuestLevel` tinyint(3) unsigned NOT NULL default '0',
	2592	`Type` smallint(5) unsigned NOT NULL default '0',
	2593	`RequiredRaces` smallint(5) unsigned NOT NULL default '0',
	2594	`RequiredSkillValue` smallint(5) unsigned NOT NULL default '0',
	2595	`RepObjectiveFaction` smallint(5) unsigned NOT NULL default '0',
	2596	`RepObjectiveValue` mediumint(9) NOT NULL default '0',
	2597	`RequiredMinRepFaction` smallint(5) unsigned NOT NULL default '0',
	2598	`RequiredMinRepValue` mediumint(9) NOT NULL default '0',
	2599	`RequiredMaxRepFaction` smallint(5) unsigned NOT NULL default '0',
	2600	`RequiredMaxRepValue` mediumint(9) NOT NULL default '0',
	2601	`SuggestedPlayers` tinyint(3) unsigned NOT NULL default '0',
	2602	`LimitTime` int(10) unsigned NOT NULL default '0',
	2603	`QuestFlags` smallint(5) unsigned NOT NULL default '0',
	2604	`SpecialFlags` tinyint(3) unsigned NOT NULL default '0',
	2605	`CharTitleId` tinyint(3) unsigned NOT NULL default '0',
	2606	`PrevQuestId` mediumint(9) NOT NULL default '0',
	2607	`NextQuestId` mediumint(9) NOT NULL default '0',
	2608	`ExclusiveGroup` mediumint(9) NOT NULL default '0',
	2609	`NextQuestInChain` mediumint(8) unsigned NOT NULL default '0',
	2610	`SrcItemId` mediumint(8) unsigned NOT NULL default '0',
	2611	`SrcItemCount` tinyint(3) unsigned NOT NULL default '0',
	2612	`SrcSpell` mediumint(8) unsigned NOT NULL default '0',
	2613	`Title` text,
	2614	`Details` text,
	2615	`Objectives` text,
	2616	`OfferRewardText` text,
	2617	`RequestItemsText` text,
	2618	`EndText` text,
	2619	`ObjectiveText1` text,
	2620	`ObjectiveText2` text,
	2621	`ObjectiveText3` text,
	2622	`ObjectiveText4` text,
	2623	`ReqItemId1` mediumint(8) unsigned NOT NULL default '0',
	2624	`ReqItemId2` mediumint(8) unsigned NOT NULL default '0',
	2625	`ReqItemId3` mediumint(8) unsigned NOT NULL default '0',
	2626	`ReqItemId4` mediumint(8) unsigned NOT NULL default '0',
	2627	`ReqItemCount1` smallint(5) unsigned NOT NULL default '0',
	2628	`ReqItemCount2` smallint(5) unsigned NOT NULL default '0',
	2629	`ReqItemCount3` smallint(5) unsigned NOT NULL default '0',
	2630	`ReqItemCount4` smallint(5) unsigned NOT NULL default '0',
	2631	`ReqSourceId1` mediumint(8) unsigned NOT NULL default '0',
	2632	`ReqSourceId2` mediumint(8) unsigned NOT NULL default '0',
	2633	`ReqSourceId3` mediumint(8) unsigned NOT NULL default '0',
	2634	`ReqSourceId4` mediumint(8) unsigned NOT NULL default '0',
	2635	`ReqSourceCount1` smallint(5) unsigned NOT NULL default '0',
	2636	`ReqSourceCount2` smallint(5) unsigned NOT NULL default '0',
	2637	`ReqSourceCount3` smallint(5) unsigned NOT NULL default '0',
	2638	`ReqSourceCount4` smallint(5) unsigned NOT NULL default '0',
	2639	`ReqSourceRef1` tinyint(3) unsigned NOT NULL default '0',
	2640	`ReqSourceRef2` tinyint(3) unsigned NOT NULL default '0',
	2641	`ReqSourceRef3` tinyint(3) unsigned NOT NULL default '0',
	2642	`ReqSourceRef4` tinyint(3) unsigned NOT NULL default '0',
	2643	`ReqCreatureOrGOId1` mediumint(9) NOT NULL default '0',
	2644	`ReqCreatureOrGOId2` mediumint(9) NOT NULL default '0',
	2645	`ReqCreatureOrGOId3` mediumint(9) NOT NULL default '0',
	2646	`ReqCreatureOrGOId4` mediumint(9) NOT NULL default '0',
	2647	`ReqCreatureOrGOCount1` smallint(5) unsigned NOT NULL default '0',
	2648	`ReqCreatureOrGOCount2` smallint(5) unsigned NOT NULL default '0',
	2649	`ReqCreatureOrGOCount3` smallint(5) unsigned NOT NULL default '0',
	2650	`ReqCreatureOrGOCount4` smallint(5) unsigned NOT NULL default '0',
	2651	`ReqSpellCast1` mediumint(8) unsigned NOT NULL default '0',
	2652	`ReqSpellCast2` mediumint(8) unsigned NOT NULL default '0',
	2653	`ReqSpellCast3` mediumint(8) unsigned NOT NULL default '0',
	2654	`ReqSpellCast4` mediumint(8) unsigned NOT NULL default '0',
	2655	`RewChoiceItemId1` mediumint(8) unsigned NOT NULL default '0',
	2656	`RewChoiceItemId2` mediumint(8) unsigned NOT NULL default '0',
	2657	`RewChoiceItemId3` mediumint(8) unsigned NOT NULL default '0',
	2658	`RewChoiceItemId4` mediumint(8) unsigned NOT NULL default '0',
	2659	`RewChoiceItemId5` mediumint(8) unsigned NOT NULL default '0',
	2660	`RewChoiceItemId6` mediumint(8) unsigned NOT NULL default '0',
	2661	`RewChoiceItemCount1` smallint(5) unsigned NOT NULL default '0',
	2662	`RewChoiceItemCount2` smallint(5) unsigned NOT NULL default '0',
	2663	`RewChoiceItemCount3` smallint(5) unsigned NOT NULL default '0',
	2664	`RewChoiceItemCount4` smallint(5) unsigned NOT NULL default '0',
	2665	`RewChoiceItemCount5` smallint(5) unsigned NOT NULL default '0',
	2666	`RewChoiceItemCount6` smallint(5) unsigned NOT NULL default '0',
	2667	`RewItemId1` mediumint(8) unsigned NOT NULL default '0',
	2668	`RewItemId2` mediumint(8) unsigned NOT NULL default '0',
	2669	`RewItemId3` mediumint(8) unsigned NOT NULL default '0',
	2670	`RewItemId4` mediumint(8) unsigned NOT NULL default '0',
	2671	`RewItemCount1` smallint(5) unsigned NOT NULL default '0',
	2672	`RewItemCount2` smallint(5) unsigned NOT NULL default '0',
	2673	`RewItemCount3` smallint(5) unsigned NOT NULL default '0',
	2674	`RewItemCount4` smallint(5) unsigned NOT NULL default '0',
	2675	`RewRepFaction1` smallint(5) unsigned NOT NULL default '0' COMMENT 'faction id from Faction.dbc in this case',
	2676	`RewRepFaction2` smallint(5) unsigned NOT NULL default '0' COMMENT 'faction id from Faction.dbc in this case',
	2677	`RewRepFaction3` smallint(5) unsigned NOT NULL default '0' COMMENT 'faction id from Faction.dbc in this case',
	2678	`RewRepFaction4` smallint(5) unsigned NOT NULL default '0' COMMENT 'faction id from Faction.dbc in this case',
	2679	`RewRepFaction5` smallint(5) unsigned NOT NULL default '0' COMMENT 'faction id from Faction.dbc in this case',
	2680	`RewRepValue1` mediumint(9) NOT NULL default '0',
	2681	`RewRepValue2` mediumint(9) NOT NULL default '0',
	2682	`RewRepValue3` mediumint(9) NOT NULL default '0',
	2683	`RewRepValue4` mediumint(9) NOT NULL default '0',
	2684	`RewRepValue5` mediumint(9) NOT NULL default '0',
	2685	`RewOrReqMoney` int(11) NOT NULL default '0',
	2686	`RewMoneyMaxLevel` int(10) unsigned NOT NULL default '0',
	2687	`RewSpell` mediumint(8) unsigned NOT NULL default '0',
	2688	`RewSpellCast` mediumint(8) unsigned NOT NULL default '0',
	2689	`RewMailTemplateId` mediumint(8) unsigned NOT NULL default '0',
	2690	`RewMailDelaySecs` int(11) unsigned NOT NULL default '0',
	2691	`PointMapId` smallint(5) unsigned NOT NULL default '0',
	2692	`PointX` float NOT NULL default '0',
	2693	`PointY` float NOT NULL default '0',
	2694	`PointOpt` mediumint(8) unsigned NOT NULL default '0',
	2695	`DetailsEmote1` smallint(5) unsigned NOT NULL default '0',
	2696	`DetailsEmote2` smallint(5) unsigned NOT NULL default '0',
	2697	`DetailsEmote3` smallint(5) unsigned NOT NULL default '0',
	2698	`DetailsEmote4` smallint(5) unsigned NOT NULL default '0',
	2699	`IncompleteEmote` smallint(5) unsigned NOT NULL default '0',
	2700	`CompleteEmote` smallint(5) unsigned NOT NULL default '0',
	2701	`OfferRewardEmote1` smallint(5) unsigned NOT NULL default '0',
	2702	`OfferRewardEmote2` smallint(5) unsigned NOT NULL default '0',
	2703	`OfferRewardEmote3` smallint(5) unsigned NOT NULL default '0',
	2704	`OfferRewardEmote4` smallint(5) unsigned NOT NULL default '0',
	2705	`StartScript` mediumint(8) unsigned NOT NULL default '0',
	2706	`CompleteScript` mediumint(8) unsigned NOT NULL default '0',
	2707	PRIMARY KEY (`entry`)
	2708	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Quest System';
	2709
[45]	2710	--
	2711	-- Dumping data for table `quest_template`
	2712	--
[37]	2713
[45]	2714	LOCK TABLES `quest_template` WRITE;
	2715	/!40000 ALTER TABLE `quest_template` DISABLE KEYS /;
	2716	/!40000 ALTER TABLE `quest_template` ENABLE KEYS /;
	2717	UNLOCK TABLES;
[37]	2718
[45]	2719	--
	2720	-- Table structure for table `reference_loot_template`
	2721	--
	2722
[37]	2723	DROP TABLE IF EXISTS `reference_loot_template`;
	2724	CREATE TABLE `reference_loot_template` (
	2725	`entry` mediumint(8) unsigned NOT NULL default '0',
	2726	`item` mediumint(8) unsigned NOT NULL default '0',
	2727	`ChanceOrQuestChance` float NOT NULL default '100',
	2728	`groupid` tinyint(3) unsigned NOT NULL default '0',
	2729	`mincountOrRef` mediumint(9) NOT NULL default '1',
	2730	`maxcount` tinyint(3) unsigned NOT NULL default '1',
	2731	`lootcondition` tinyint(3) unsigned NOT NULL default '0',
	2732	`condition_value1` mediumint(8) unsigned NOT NULL default '0',
	2733	`condition_value2` mediumint(8) unsigned NOT NULL default '0',
	2734	PRIMARY KEY (`entry`,`item`)
	2735	) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Loot System';
	2736
[45]	2737	--
	2738	-- Dumping data for table `reference_loot_template`
	2739	--
[37]	2740
[45]	2741	LOCK TABLES `reference_loot_template` WRITE;
	2742	/!40000 ALTER TABLE `reference_loot_template` DISABLE KEYS /;
	2743	/!40000 ALTER TABLE `reference_loot_template` ENABLE KEYS /;
	2744	UNLOCK TABLES;
[37]	2745
[45]	2746	--
	2747	-- Table structure for table `reserved_name`
	2748	--
	2749
[37]	2750	DROP TABLE IF EXISTS `reserved_name`;
	2751	CREATE TABLE `reserved_name` (
	2752	`name` varchar(12) NOT NULL default '',
	2753	PRIMARY KEY (`name`)
	2754	) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player Reserved Names';
	2755
[45]	2756	--
	2757	-- Dumping data for table `reserved_name`
	2758	--
[37]	2759
[45]	2760	LOCK TABLES `reserved_name` WRITE;
	2761	/!40000 ALTER TABLE `reserved_name` DISABLE KEYS /;
	2762	/!40000 ALTER TABLE `reserved_name` ENABLE KEYS /;
	2763	UNLOCK TABLES;
[37]	2764
[45]	2765	--
	2766	-- Table structure for table `script_db_version`
	2767	--
	2768
	2769	DROP TABLE IF EXISTS `script_db_version`;
	2770	CREATE TABLE `script_db_version` (
	2771	`version` varchar(255) NOT NULL default '' COMMENT 'Database version string'
	2772	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	2773
	2774	--
	2775	-- Dumping data for table `script_db_version`
	2776	--
	2777
	2778	LOCK TABLES `script_db_version` WRITE;
	2779	/!40000 ALTER TABLE `script_db_version` DISABLE KEYS /;
	2780	/!40000 ALTER TABLE `script_db_version` ENABLE KEYS /;
	2781	UNLOCK TABLES;
	2782
	2783	--
	2784	-- Table structure for table `script_texts`
	2785	--
	2786
	2787	DROP TABLE IF EXISTS `script_texts`;
	2788	CREATE TABLE `script_texts` (
	2789	`entry` mediumint(8) NOT NULL,
	2790	`content_default` text NOT NULL,
	2791	`content_loc1` text,
	2792	`content_loc2` text,
	2793	`content_loc3` text,
	2794	`content_loc4` text,
	2795	`content_loc5` text,
	2796	`content_loc6` text,
	2797	`content_loc7` text,
	2798	`content_loc8` text,
	2799	`sound` tinyint(3) unsigned NOT NULL default '0',
	2800	`type` tinyint(3) unsigned NOT NULL default '0',
	2801	`language` tinyint(3) unsigned NOT NULL default '0',
	2802	`comment` text,
	2803	PRIMARY KEY (`entry`)
	2804	) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Script Texts';
	2805
	2806	--
	2807	-- Dumping data for table `script_texts`
	2808	--
	2809
	2810	LOCK TABLES `script_texts` WRITE;
	2811	/!40000 ALTER TABLE `script_texts` DISABLE KEYS /;
	2812	/!40000 ALTER TABLE `script_texts` ENABLE KEYS /;
	2813	UNLOCK TABLES;
	2814
	2815	--
	2816	-- Table structure for table `skill_discovery_template`
	2817	--
	2818
[37]	2819	DROP TABLE IF EXISTS `skill_discovery_template`;
	2820	CREATE TABLE `skill_discovery_template` (
	2821	`spellId` mediumint(8) unsigned NOT NULL default '0' COMMENT 'SpellId of the discoverable spell',
	2822	`reqSpell` mediumint(8) unsigned NOT NULL default '0' COMMENT 'spell requirement',
	2823	`chance` float NOT NULL default '0' COMMENT 'chance to discover',
	2824	PRIMARY KEY (`spellId`)
	2825	) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Skill Discovery System';
	2826
[45]	2827	--
	2828	-- Dumping data for table `skill_discovery_template`
	2829	--
[37]	2830
[45]	2831	LOCK TABLES `skill_discovery_template` WRITE;
	2832	/!40000 ALTER TABLE `skill_discovery_template` DISABLE KEYS /;
	2833	/!40000 ALTER TABLE `skill_discovery_template` ENABLE KEYS /;
	2834	UNLOCK TABLES;
[37]	2835
[45]	2836	--
	2837	-- Table structure for table `skill_extra_item_template`
	2838	--
	2839
[37]	2840	DROP TABLE IF EXISTS `skill_extra_item_template`;
	2841	CREATE TABLE `skill_extra_item_template` (
	2842	`spellId` mediumint(8) unsigned NOT NULL default '0' COMMENT 'SpellId of the item creation spell',
	2843	`requiredSpecialization` mediumint(8) unsigned NOT NULL default '0' COMMENT 'Specialization spell id',
	2844	`additionalCreateChance` float NOT NULL default '0' COMMENT 'chance to create add',
	2845	`additionalMaxNum` tinyint(3) unsigned NOT NULL default '0' COMMENT 'max num of adds',
	2846	PRIMARY KEY (`spellId`)
	2847	) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Skill Specialization System';
	2848
[45]	2849	--
	2850	-- Dumping data for table `skill_extra_item_template`
	2851	--
[37]	2852
[45]	2853	LOCK TABLES `skill_extra_item_template` WRITE;
	2854	/!40000 ALTER TABLE `skill_extra_item_template` DISABLE KEYS /;
	2855	/!40000 ALTER TABLE `skill_extra_item_template` ENABLE KEYS /;
	2856	UNLOCK TABLES;
[37]	2857
[45]	2858	--
	2859	-- Table structure for table `skill_fishing_base_level`
	2860	--
	2861
[37]	2862	DROP TABLE IF EXISTS `skill_fishing_base_level`;
	2863	CREATE TABLE `skill_fishing_base_level` (
	2864	`entry` mediumint(8) unsigned NOT NULL default '0' COMMENT 'Area identifier',
	2865	`skill` smallint(6) NOT NULL default '0' COMMENT 'Base skill level requirement',
	2866	PRIMARY KEY (`entry`)
	2867	) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Fishing system';
	2868
[45]	2869	--
	2870	-- Dumping data for table `skill_fishing_base_level`
	2871	--
[37]	2872
[45]	2873	LOCK TABLES `skill_fishing_base_level` WRITE;
	2874	/!40000 ALTER TABLE `skill_fishing_base_level` DISABLE KEYS /;
	2875	/!40000 ALTER TABLE `skill_fishing_base_level` ENABLE KEYS /;
	2876	UNLOCK TABLES;
[37]	2877
[45]	2878	--
	2879	-- Table structure for table `skinning_loot_template`
	2880	--
	2881
[37]	2882	DROP TABLE IF EXISTS `skinning_loot_template`;
	2883	CREATE TABLE `skinning_loot_template` (
	2884	`entry` mediumint(8) unsigned NOT NULL default '0',
	2885	`item` mediumint(8) unsigned NOT NULL default '0',
	2886	`ChanceOrQuestChance` float NOT NULL default '100',
	2887	`groupid` tinyint(3) unsigned NOT NULL default '0',
	2888	`mincountOrRef` mediumint(9) NOT NULL default '1',
	2889	`maxcount` tinyint(3) unsigned NOT NULL default '1',
	2890	`lootcondition` tinyint(3) unsigned NOT NULL default '0',
	2891	`condition_value1` mediumint(8) unsigned NOT NULL default '0',
	2892	`condition_value2` mediumint(8) unsigned NOT NULL default '0',
	2893	PRIMARY KEY (`entry`,`item`)
	2894	) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Loot System';
	2895
[45]	2896	--
	2897	-- Dumping data for table `skinning_loot_template`
	2898	--
[37]	2899
[45]	2900	LOCK TABLES `skinning_loot_template` WRITE;
	2901	/!40000 ALTER TABLE `skinning_loot_template` DISABLE KEYS /;
	2902	/!40000 ALTER TABLE `skinning_loot_template` ENABLE KEYS /;
	2903	UNLOCK TABLES;
[37]	2904
[45]	2905	--
	2906	-- Table structure for table `spell_affect`
	2907	--
	2908
[37]	2909	DROP TABLE IF EXISTS `spell_affect`;
	2910	CREATE TABLE `spell_affect` (
	2911	`entry` smallint(5) unsigned NOT NULL default '0',
	2912	`effectId` tinyint(3) unsigned NOT NULL default '0',
	2913	`SpellFamilyMask` bigint(20) unsigned NOT NULL default '0',
	2914	PRIMARY KEY (`entry`,`effectId`)
	2915	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	2916
[45]	2917	--
	2918	-- Dumping data for table `spell_affect`
	2919	--
[37]	2920
[45]	2921	LOCK TABLES `spell_affect` WRITE;
	2922	/!40000 ALTER TABLE `spell_affect` DISABLE KEYS /;
	2923	/!40000 ALTER TABLE `spell_affect` ENABLE KEYS /;
	2924	UNLOCK TABLES;
[37]	2925
[45]	2926	--
	2927	-- Table structure for table `spell_chain`
	2928	--
[37]	2929
	2930	DROP TABLE IF EXISTS `spell_chain`;
	2931	CREATE TABLE `spell_chain` (
	2932	`spell_id` mediumint(9) NOT NULL default '0',
	2933	`prev_spell` mediumint(9) NOT NULL default '0',
	2934	`first_spell` mediumint(9) NOT NULL default '0',
	2935	`rank` tinyint(4) NOT NULL default '0',
	2936	`req_spell` mediumint(9) NOT NULL default '0',
	2937	PRIMARY KEY (`spell_id`)
	2938	) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Spell Additinal Data';
	2939
[45]	2940	--
	2941	-- Dumping data for table `spell_chain`
	2942	--
[37]	2943
[45]	2944	LOCK TABLES `spell_chain` WRITE;
	2945	/!40000 ALTER TABLE `spell_chain` DISABLE KEYS /;
	2946	/!40000 ALTER TABLE `spell_chain` ENABLE KEYS /;
	2947	UNLOCK TABLES;
[37]	2948
[45]	2949	--
[85]	2950	-- Table structure for table `spell_disabled`
	2951	--
	2952
	2953	DROP TABLE IF EXISTS `spell_disabled`;
	2954	CREATE TABLE `spell_disabled` (
	2955	`entry` int(11) unsigned NOT NULL default '0' COMMENT 'Spell entry',
	2956	`disable_mask` int(8) unsigned NOT NULL default '0',
	2957	`comment` varchar(64) NOT NULL default '',
	2958	PRIMARY KEY (`entry`)
	2959	) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Disabled Spell System';
	2960
	2961	--
	2962	-- Dumping data for table `spell_disabled`
	2963	--
	2964
	2965	LOCK TABLES `spell_disabled` WRITE;
	2966	/!40000 ALTER TABLE `spell_disabled` DISABLE KEYS /;
	2967	/!40000 ALTER TABLE `spell_disabled` ENABLE KEYS /;
	2968	UNLOCK TABLES;
	2969
	2970	--
[45]	2971	-- Table structure for table `spell_elixir`
	2972	--
[37]	2973
	2974	DROP TABLE IF EXISTS `spell_elixir`;
	2975	CREATE TABLE `spell_elixir` (
	2976	`entry` int(11) unsigned NOT NULL default '0' COMMENT 'SpellId of potion',
	2977	`mask` tinyint(1) unsigned NOT NULL default '0' COMMENT 'Mask 0x1 battle 0x2 guardian 0x3 flask 0x7 unstable flasks 0xB shattrath flasks',
	2978	PRIMARY KEY (`entry`)
	2979	) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Spell System';
	2980
[45]	2981	--
	2982	-- Dumping data for table `spell_elixir`
	2983	--
[37]	2984
[45]	2985	LOCK TABLES `spell_elixir` WRITE;
	2986	/!40000 ALTER TABLE `spell_elixir` DISABLE KEYS /;
	2987	/!40000 ALTER TABLE `spell_elixir` ENABLE KEYS /;
	2988	UNLOCK TABLES;
[37]	2989
[45]	2990	--
	2991	-- Table structure for table `spell_learn_spell`
	2992	--
[37]	2993
	2994	DROP TABLE IF EXISTS `spell_learn_spell`;
	2995	CREATE TABLE `spell_learn_spell` (
	2996	`entry` smallint(5) unsigned NOT NULL default '0',
	2997	`SpellID` smallint(5) unsigned NOT NULL default '0',
	2998	PRIMARY KEY (`entry`,`SpellID`)
	2999	) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Item System';
	3000
[45]	3001	--
	3002	-- Dumping data for table `spell_learn_spell`
	3003	--
[37]	3004
[45]	3005	LOCK TABLES `spell_learn_spell` WRITE;
	3006	/!40000 ALTER TABLE `spell_learn_spell` DISABLE KEYS /;
	3007	/!40000 ALTER TABLE `spell_learn_spell` ENABLE KEYS /;
	3008	UNLOCK TABLES;
[37]	3009
[45]	3010	--
	3011	-- Table structure for table `spell_pet_auras`
	3012	--
[37]	3013
	3014	DROP TABLE IF EXISTS `spell_pet_auras`;
	3015	CREATE TABLE `spell_pet_auras` (
	3016	`spell` mediumint(8) unsigned NOT NULL COMMENT 'dummy spell id',
	3017	`pet` mediumint(8) unsigned NOT NULL default '0' COMMENT 'pet id; 0 = all',
	3018	`aura` mediumint(8) unsigned NOT NULL COMMENT 'pet aura id',
	3019	PRIMARY KEY (`spell`,`pet`)
	3020	) ENGINE=MyISAM DEFAULT CHARSET=latin1;
	3021
[45]	3022	--
	3023	-- Dumping data for table `spell_pet_auras`
	3024	--
[37]	3025
[45]	3026	LOCK TABLES `spell_pet_auras` WRITE;
	3027	/!40000 ALTER TABLE `spell_pet_auras` DISABLE KEYS /;
	3028	/!40000 ALTER TABLE `spell_pet_auras` ENABLE KEYS /;
	3029	UNLOCK TABLES;
[37]	3030
[45]	3031	--
	3032	-- Table structure for table `spell_proc_event`
	3033	--
[37]	3034
	3035	DROP TABLE IF EXISTS `spell_proc_event`;
	3036	CREATE TABLE `spell_proc_event` (
	3037	`entry` smallint(5) unsigned NOT NULL default '0',
	3038	`SchoolMask` tinyint(4) NOT NULL default '0',
	3039	`Category` smallint(6) NOT NULL default '0',
	3040	`SkillID` smallint(6) NOT NULL default '0',
	3041	`SpellFamilyName` smallint(5) unsigned NOT NULL default '0',
	3042	`SpellFamilyMask` bigint(20) unsigned NOT NULL default '0',
	3043	`procFlags` int(10) unsigned NOT NULL default '0',
	3044	`ppmRate` float NOT NULL default '0',
	3045	`cooldown` int(10) unsigned NOT NULL default '0',
	3046	PRIMARY KEY (`entry`)
	3047	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	3048
[45]	3049	--
	3050	-- Dumping data for table `spell_proc_event`
	3051	--
[37]	3052
[45]	3053	LOCK TABLES `spell_proc_event` WRITE;
	3054	/!40000 ALTER TABLE `spell_proc_event` DISABLE KEYS /;
	3055	/!40000 ALTER TABLE `spell_proc_event` ENABLE KEYS /;
	3056	UNLOCK TABLES;
[37]	3057
[45]	3058	--
	3059	-- Table structure for table `spell_script_target`
	3060	--
[37]	3061
	3062	DROP TABLE IF EXISTS `spell_script_target`;
	3063	CREATE TABLE `spell_script_target` (
	3064	`entry` mediumint(8) unsigned NOT NULL,
	3065	`type` tinyint(3) unsigned NOT NULL default '0',
	3066	`targetEntry` mediumint(8) unsigned NOT NULL default '0',
	3067	UNIQUE KEY `entry_type_target` (`entry`,`type`,`targetEntry`)
[45]	3068	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Spell System';
[37]	3069
[45]	3070	--
	3071	-- Dumping data for table `spell_script_target`
	3072	--
[37]	3073
[45]	3074	LOCK TABLES `spell_script_target` WRITE;
	3075	/!40000 ALTER TABLE `spell_script_target` DISABLE KEYS /;
	3076	/!40000 ALTER TABLE `spell_script_target` ENABLE KEYS /;
	3077	UNLOCK TABLES;
[37]	3078
[45]	3079	--
	3080	-- Table structure for table `spell_scripts`
	3081	--
	3082
[37]	3083	DROP TABLE IF EXISTS `spell_scripts`;
	3084	CREATE TABLE `spell_scripts` (
	3085	`id` mediumint(8) unsigned NOT NULL default '0',
	3086	`delay` int(10) unsigned NOT NULL default '0',
	3087	`command` mediumint(8) unsigned NOT NULL default '0',
	3088	`datalong` mediumint(8) unsigned NOT NULL default '0',
	3089	`datalong2` int(10) unsigned NOT NULL default '0',
[45]	3090	`datatext` text character set latin1 NOT NULL,
[37]	3091	`x` float NOT NULL default '0',
	3092	`y` float NOT NULL default '0',
	3093	`z` float NOT NULL default '0',
	3094	`o` float NOT NULL default '0'
	3095	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	3096
[45]	3097	--
	3098	-- Dumping data for table `spell_scripts`
	3099	--
[37]	3100
[45]	3101	LOCK TABLES `spell_scripts` WRITE;
	3102	/!40000 ALTER TABLE `spell_scripts` DISABLE KEYS /;
	3103	/!40000 ALTER TABLE `spell_scripts` ENABLE KEYS /;
	3104	UNLOCK TABLES;
[37]	3105
[45]	3106	--
	3107	-- Table structure for table `spell_target_position`
	3108	--
	3109
[37]	3110	DROP TABLE IF EXISTS `spell_target_position`;
	3111	CREATE TABLE `spell_target_position` (
	3112	`id` mediumint(8) unsigned NOT NULL default '0' COMMENT 'Identifier',
	3113	`target_map` smallint(5) unsigned NOT NULL default '0',
	3114	`target_position_x` float NOT NULL default '0',
	3115	`target_position_y` float NOT NULL default '0',
	3116	`target_position_z` float NOT NULL default '0',
	3117	`target_orientation` float NOT NULL default '0',
	3118	PRIMARY KEY (`id`)
	3119	) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Spell System';
	3120
[45]	3121	--
	3122	-- Dumping data for table `spell_target_position`
	3123	--
[37]	3124
[45]	3125	LOCK TABLES `spell_target_position` WRITE;
	3126	/!40000 ALTER TABLE `spell_target_position` DISABLE KEYS /;
	3127	/!40000 ALTER TABLE `spell_target_position` ENABLE KEYS /;
	3128	UNLOCK TABLES;
[37]	3129
[45]	3130	--
	3131	-- Table structure for table `spell_threat`
	3132	--
	3133
[37]	3134	DROP TABLE IF EXISTS `spell_threat`;
	3135	CREATE TABLE `spell_threat` (
	3136	`entry` mediumint(8) unsigned NOT NULL,
	3137	`Threat` smallint(6) NOT NULL,
	3138	PRIMARY KEY (`entry`)
	3139	) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED;
	3140
[45]	3141	--
	3142	-- Dumping data for table `spell_threat`
	3143	--
[37]	3144
[45]	3145	LOCK TABLES `spell_threat` WRITE;
	3146	/!40000 ALTER TABLE `spell_threat` DISABLE KEYS /;
	3147	/!40000 ALTER TABLE `spell_threat` ENABLE KEYS /;
	3148	UNLOCK TABLES;
[37]	3149
[45]	3150	--
	3151	-- Table structure for table `transports`
	3152	--
[37]	3153
	3154	DROP TABLE IF EXISTS `transports`;
	3155	CREATE TABLE `transports` (
	3156	`entry` mediumint(8) unsigned NOT NULL default '0',
	3157	`name` text,
	3158	`period` mediumint(8) unsigned NOT NULL default '0',
	3159	PRIMARY KEY (`entry`)
	3160	) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Transports';
	3161
[45]	3162	--
	3163	-- Dumping data for table `transports`
	3164	--
[37]	3165
[45]	3166	LOCK TABLES `transports` WRITE;
	3167	/!40000 ALTER TABLE `transports` DISABLE KEYS /;
	3168	/!40000 ALTER TABLE `transports` ENABLE KEYS /;
	3169	UNLOCK TABLES;
[37]	3170
[45]	3171	--
	3172	-- Table structure for table `trinity_string`
	3173	--
	3174
	3175	DROP TABLE IF EXISTS `trinity_string`;
	3176	CREATE TABLE `trinity_string` (
	3177	`entry` mediumint(8) unsigned NOT NULL default '0',
	3178	`content_default` text NOT NULL,
	3179	`content_loc1` text,
	3180	`content_loc2` text,
	3181	`content_loc3` text,
	3182	`content_loc4` text,
	3183	`content_loc5` text,
	3184	`content_loc6` text,
	3185	`content_loc7` text,
	3186	`content_loc8` text,
	3187	PRIMARY KEY (`entry`)
	3188	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	3189
	3190	--
	3191	-- Dumping data for table `trinity_string`
	3192	--
	3193
	3194	LOCK TABLES `trinity_string` WRITE;
	3195	/!40000 ALTER TABLE `trinity_string` DISABLE KEYS /;
	3196	/!40000 ALTER TABLE `trinity_string` ENABLE KEYS /;
	3197	UNLOCK TABLES;
	3198
	3199	--
	3200	-- Table structure for table `uptime`
	3201	--
	3202
[37]	3203	DROP TABLE IF EXISTS `uptime`;
	3204	CREATE TABLE `uptime` (
	3205	`starttime` bigint(20) unsigned NOT NULL default '0',
	3206	`startstring` varchar(64) NOT NULL default '',
	3207	`uptime` bigint(20) unsigned NOT NULL default '0',
	3208	`maxplayers` smallint(5) unsigned NOT NULL default '0',
	3209	PRIMARY KEY (`starttime`)
	3210	) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Uptime system';
	3211
[45]	3212	--
	3213	-- Dumping data for table `uptime`
	3214	--
[37]	3215
[45]	3216	LOCK TABLES `uptime` WRITE;
	3217	/!40000 ALTER TABLE `uptime` DISABLE KEYS /;
	3218	/!40000 ALTER TABLE `uptime` ENABLE KEYS /;
	3219	UNLOCK TABLES;
	3220	/!40103 SET TIME_ZONE=@OLD_TIME_ZONE /;
	3221
[37]	3222	/!40101 SET SQL_MODE=@OLD_SQL_MODE /;
	3223	/!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS /;
[45]	3224	/!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS /;
	3225	/!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT /;
	3226	/!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS /;
	3227	/!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION /;
	3228	/!40111 SET SQL_NOTES=@OLD_SQL_NOTES /;
	3229
	3230	-- Dump completed on 2008-10-14 13:23:35

Note: See TracBrowser for help on using the browser.

Context Navigation

root/trunk/sql/world.sql @ 85

Download in other formats: