Context Navigation

world.sql @ 127

Revision 127, 110.5 kB (checked in by yumileroy, 17 years ago)

[svn] * fixed world.sql LOCK/UNLOCK for script_texts table

Original author: slg
Date: 2008-10-27 16:12:31-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',
[109]	572	`type` tinyint unsigned NOT NULL default '0',
	573	`language` tinyint unsigned NOT NULL default '0',
[45]	574	`comment` text,
[109]	575	PRIMARY KEY (`entry`)
[45]	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` (
[109]	693	`id` int(11) unsigned NOT NULL COMMENT 'Identifier' AUTO_INCREMENT,
[45]	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',
[109]	696	`event_inverse_phase_mask` int(11) signed NOT NULL default '0' COMMENT 'Mask which phases this event will not trigger in',
[45]	697	`event_chance` int(3) unsigned NOT NULL default '100',
	698	`event_flags` int(3) unsigned NOT NULL default '0',
[109]	699	`event_param1` int(11) signed NOT NULL default '0',
	700	`event_param2` int(11) signed NOT NULL default '0',
	701	`event_param3` int(11) signed NOT NULL default '0',
	702	`event_param4` int(11) signed NOT NULL default '0',
[45]	703	`action1_type` tinyint(5) unsigned NOT NULL default '0' COMMENT 'Action Type',
[109]	704	`action1_param1` int(11) signed NOT NULL default '0',
	705	`action1_param2` int(11) signed NOT NULL default '0',
	706	`action1_param3` int(11) signed NOT NULL default '0',
[45]	707	`action2_type` tinyint(5) unsigned NOT NULL default '0' COMMENT 'Action Type',
[109]	708	`action2_param1` int(11) signed NOT NULL default '0',
	709	`action2_param2` int(11) signed NOT NULL default '0',
	710	`action2_param3` int(11) signed NOT NULL default '0',
[45]	711	`action3_type` tinyint(5) unsigned NOT NULL default '0' COMMENT 'Action Type',
[109]	712	`action3_param1` int(11) signed NOT NULL default '0',
	713	`action3_param2` int(11) signed NOT NULL default '0',
	714	`action3_param3` int(11) signed NOT NULL default '0',
[45]	715	`comment` varchar(255) NOT NULL default '' COMMENT 'Event Comment',
[109]	716	PRIMARY KEY (`id`)
[45]	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` (
[109]	734	`id` int(11) unsigned NOT NULL COMMENT 'Location Identifier' AUTO_INCREMENT,
[45]	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',
[109]	741	PRIMARY KEY (`id`)
[45]	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` (
[109]	759	`entry` mediumint(8) NOT NULL,
	760	`content_default` text NOT NULL,
	761	`content_loc1` text,
	762	`content_loc2` text,
	763	`content_loc3` text,
	764	`content_loc4` text,
	765	`content_loc5` text,
	766	`content_loc6` text,
	767	`content_loc7` text,
	768	`content_loc8` text,
	769	`sound` mediumint(8) unsigned NOT NULL default '0',
	770	`type` tinyint unsigned NOT NULL default '0',
	771	`language` tinyint unsigned NOT NULL default '0',
	772	`comment` text,
	773	PRIMARY KEY (`entry`)
	774	) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Script Texts';
[45]	775
	776	--
	777	-- Dumping data for table `eventai_texts`
	778	--
	779
	780	LOCK TABLES `eventai_texts` WRITE;
	781	/!40000 ALTER TABLE `eventai_texts` DISABLE KEYS /;
	782	/!40000 ALTER TABLE `eventai_texts` ENABLE KEYS /;
	783	UNLOCK TABLES;
	784
	785	--
[109]	786	-- Table structure for table `script_texts`
	787	--
	788
	789	DROP TABLE IF EXISTS `script_texts`;
	790	CREATE TABLE `script_texts` (
	791	`entry` mediumint(8) NOT NULL,
	792	`content_default` text NOT NULL,
	793	`content_loc1` text,
	794	`content_loc2` text,
	795	`content_loc3` text,
	796	`content_loc4` text,
	797	`content_loc5` text,
	798	`content_loc6` text,
	799	`content_loc7` text,
	800	`content_loc8` text,
	801	`sound` mediumint(8) unsigned NOT NULL default '0',
	802	`type` tinyint unsigned NOT NULL default '0',
	803	`language` tinyint unsigned NOT NULL default '0',
	804	`comment` text,
	805	PRIMARY KEY (`entry`)
	806	) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Script Texts';
	807
	808	--
	809	-- Dumping data for table `script_texts`
	810	--
	811
[127]	812	LOCK TABLES `script_texts` WRITE;
[109]	813	/!40000 ALTER TABLE `script_texts` DISABLE KEYS /;
	814	/!40000 ALTER TABLE `script_texts` ENABLE KEYS /;
	815	UNLOCK TABLES;
	816
	817	--
[45]	818	-- Table structure for table `exploration_basexp`
	819	--
	820
[37]	821	DROP TABLE IF EXISTS `exploration_basexp`;
	822	CREATE TABLE `exploration_basexp` (
	823	`level` tinyint(4) NOT NULL default '0',
	824	`basexp` mediumint(9) NOT NULL default '0',
	825	PRIMARY KEY (`level`)
	826	) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Exploration System';
	827
[45]	828	--
	829	-- Dumping data for table `exploration_basexp`
	830	--
[37]	831
[45]	832	LOCK TABLES `exploration_basexp` WRITE;
	833	/!40000 ALTER TABLE `exploration_basexp` DISABLE KEYS /;
	834	/!40000 ALTER TABLE `exploration_basexp` ENABLE KEYS /;
	835	UNLOCK TABLES;
[37]	836
[45]	837	--
	838	-- Table structure for table `fishing_loot_template`
	839	--
[37]	840
	841	DROP TABLE IF EXISTS `fishing_loot_template`;
	842	CREATE TABLE `fishing_loot_template` (
	843	`entry` mediumint(8) unsigned NOT NULL default '0',
	844	`item` mediumint(8) unsigned NOT NULL default '0',
	845	`ChanceOrQuestChance` float NOT NULL default '100',
	846	`groupid` tinyint(3) unsigned NOT NULL default '0',
	847	`mincountOrRef` mediumint(9) NOT NULL default '1',
	848	`maxcount` tinyint(3) unsigned NOT NULL default '1',
	849	`lootcondition` tinyint(3) unsigned NOT NULL default '0',
	850	`condition_value1` mediumint(8) unsigned NOT NULL default '0',
	851	`condition_value2` mediumint(8) unsigned NOT NULL default '0',
	852	PRIMARY KEY (`entry`,`item`)
[45]	853	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Loot System';
[37]	854
[45]	855	--
	856	-- Dumping data for table `fishing_loot_template`
	857	--
[37]	858
[45]	859	LOCK TABLES `fishing_loot_template` WRITE;
	860	/!40000 ALTER TABLE `fishing_loot_template` DISABLE KEYS /;
	861	/!40000 ALTER TABLE `fishing_loot_template` ENABLE KEYS /;
	862	UNLOCK TABLES;
[37]	863
[45]	864	--
	865	-- Table structure for table `game_event`
	866	--
	867
[37]	868	DROP TABLE IF EXISTS `game_event`;
	869	CREATE TABLE `game_event` (
	870	`entry` mediumint(8) unsigned NOT NULL COMMENT 'Entry of the game event',
	871	`start_time` timestamp NOT NULL default '0000-00-00 00:00:00' COMMENT 'Absolute start date, the event will never start before',
	872	`end_time` timestamp NOT NULL default '0000-00-00 00:00:00' COMMENT 'Absolute end date, the event will never start afler',
[45]	873	`occurence` bigint(20) unsigned NOT NULL default '5184000' COMMENT 'Delay in minutes between occurences of the event',
	874	`length` bigint(20) unsigned NOT NULL default '2592000' COMMENT 'Length in minutes of the event',
[37]	875	`description` varchar(255) default NULL COMMENT 'Description of the event displayed in console',
[45]	876	`world_event` tinyint(3) unsigned NOT NULL default '0' COMMENT '0 if normal event, 1 if world event',
[37]	877	PRIMARY KEY (`entry`)
	878	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	879
[45]	880	--
	881	-- Dumping data for table `game_event`
	882	--
[37]	883
[45]	884	LOCK TABLES `game_event` WRITE;
	885	/!40000 ALTER TABLE `game_event` DISABLE KEYS /;
	886	/!40000 ALTER TABLE `game_event` ENABLE KEYS /;
	887	UNLOCK TABLES;
[37]	888
[45]	889	--
	890	-- Table structure for table `game_event_condition`
	891	--
	892
	893	DROP TABLE IF EXISTS `game_event_condition`;
	894	CREATE TABLE `game_event_condition` (
	895	`event_id` mediumint(8) unsigned NOT NULL default '0',
	896	`condition_id` mediumint(8) unsigned NOT NULL default '0',
	897	`req_num` float default '0',
	898	`max_world_state_field` smallint(5) unsigned NOT NULL default '0',
	899	`done_world_state_field` smallint(5) unsigned NOT NULL default '0',
	900	`description` varchar(25) NOT NULL default '',
	901	PRIMARY KEY (`event_id`,`condition_id`)
	902	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	903
	904	--
	905	-- Dumping data for table `game_event_condition`
	906	--
	907
	908	LOCK TABLES `game_event_condition` WRITE;
	909	/!40000 ALTER TABLE `game_event_condition` DISABLE KEYS /;
	910	/!40000 ALTER TABLE `game_event_condition` ENABLE KEYS /;
	911	UNLOCK TABLES;
	912
	913	--
	914	-- Table structure for table `game_event_creature`
	915	--
	916
[37]	917	DROP TABLE IF EXISTS `game_event_creature`;
	918	CREATE TABLE `game_event_creature` (
	919	`guid` int(10) unsigned NOT NULL,
	920	`event` smallint(6) NOT NULL default '0' COMMENT 'Put negatives values to remove during event',
[44]	921	PRIMARY KEY (`guid`,`event`)
[37]	922	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	923
[45]	924	--
	925	-- Dumping data for table `game_event_creature`
	926	--
[37]	927
[45]	928	LOCK TABLES `game_event_creature` WRITE;
	929	/!40000 ALTER TABLE `game_event_creature` DISABLE KEYS /;
	930	/!40000 ALTER TABLE `game_event_creature` ENABLE KEYS /;
	931	UNLOCK TABLES;
[37]	932
[45]	933	--
	934	-- Table structure for table `game_event_creature_quest`
	935	--
	936
[37]	937	DROP TABLE IF EXISTS `game_event_creature_quest`;
	938	CREATE TABLE `game_event_creature_quest` (
	939	`id` mediumint(8) unsigned NOT NULL default '0',
	940	`quest` mediumint(8) unsigned NOT NULL default '0',
	941	`event` smallint(5) unsigned NOT NULL default '0',
[44]	942	PRIMARY KEY (`quest`,`event`,`id`)
[37]	943	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	944
[45]	945	--
	946	-- Dumping data for table `game_event_creature_quest`
	947	--
[37]	948
[45]	949	LOCK TABLES `game_event_creature_quest` WRITE;
	950	/!40000 ALTER TABLE `game_event_creature_quest` DISABLE KEYS /;
	951	/!40000 ALTER TABLE `game_event_creature_quest` ENABLE KEYS /;
	952	UNLOCK TABLES;
[44]	953
[45]	954	--
	955	-- Table structure for table `game_event_gameobject`
	956	--
[44]	957
[37]	958	DROP TABLE IF EXISTS `game_event_gameobject`;
	959	CREATE TABLE `game_event_gameobject` (
	960	`guid` int(10) unsigned NOT NULL,
	961	`event` smallint(6) NOT NULL default '0' COMMENT 'Put negatives values to remove during event',
[44]	962	PRIMARY KEY (`guid`,`event`)
[37]	963	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	964
[45]	965	--
	966	-- Dumping data for table `game_event_gameobject`
	967	--
[37]	968
[45]	969	LOCK TABLES `game_event_gameobject` WRITE;
	970	/!40000 ALTER TABLE `game_event_gameobject` DISABLE KEYS /;
	971	/!40000 ALTER TABLE `game_event_gameobject` ENABLE KEYS /;
	972	UNLOCK TABLES;
[37]	973
[45]	974	--
	975	-- Table structure for table `game_event_gameobject_quest`
	976	--
	977
	978	DROP TABLE IF EXISTS `game_event_gameobject_quest`;
	979	CREATE TABLE `game_event_gameobject_quest` (
	980	`id` mediumint(8) unsigned NOT NULL default '0',
	981	`quest` mediumint(8) unsigned NOT NULL default '0',
	982	`event` smallint(5) unsigned NOT NULL default '0',
	983	PRIMARY KEY (`quest`,`event`,`id`)
	984	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	985
	986	--
	987	-- Dumping data for table `game_event_gameobject_quest`
	988	--
	989
	990	LOCK TABLES `game_event_gameobject_quest` WRITE;
	991	/!40000 ALTER TABLE `game_event_gameobject_quest` DISABLE KEYS /;
	992	/!40000 ALTER TABLE `game_event_gameobject_quest` ENABLE KEYS /;
	993	UNLOCK TABLES;
	994
	995	--
	996	-- Table structure for table `game_event_model_equip`
	997	--
	998
[37]	999	DROP TABLE IF EXISTS `game_event_model_equip`;
	1000	CREATE TABLE `game_event_model_equip` (
	1001	`guid` int(10) unsigned NOT NULL default '0',
	1002	`modelid` mediumint(8) unsigned NOT NULL default '0',
	1003	`equipment_id` mediumint(8) unsigned NOT NULL default '0',
	1004	`event` smallint(5) unsigned NOT NULL default '0',
	1005	PRIMARY KEY (`guid`)
	1006	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	1007
[45]	1008	--
	1009	-- Dumping data for table `game_event_model_equip`
	1010	--
[37]	1011
[45]	1012	LOCK TABLES `game_event_model_equip` WRITE;
	1013	/!40000 ALTER TABLE `game_event_model_equip` DISABLE KEYS /;
	1014	/!40000 ALTER TABLE `game_event_model_equip` ENABLE KEYS /;
	1015	UNLOCK TABLES;
[37]	1016
[45]	1017	--
	1018	-- Table structure for table `game_event_npc_gossip`
	1019	--
	1020
	1021	DROP TABLE IF EXISTS `game_event_npc_gossip`;
	1022	CREATE TABLE `game_event_npc_gossip` (
	1023	`guid` int(10) unsigned NOT NULL,
	1024	`event_id` mediumint(8) unsigned NOT NULL default '0',
	1025	`textid` mediumint(8) unsigned NOT NULL default '0',
	1026	PRIMARY KEY (`guid`)
	1027	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	1028
	1029	--
	1030	-- Dumping data for table `game_event_npc_gossip`
	1031	--
	1032
	1033	LOCK TABLES `game_event_npc_gossip` WRITE;
	1034	/!40000 ALTER TABLE `game_event_npc_gossip` DISABLE KEYS /;
	1035	/!40000 ALTER TABLE `game_event_npc_gossip` ENABLE KEYS /;
	1036	UNLOCK TABLES;
	1037
	1038	--
	1039	-- Table structure for table `game_event_npc_vendor`
	1040	--
	1041
	1042	DROP TABLE IF EXISTS `game_event_npc_vendor`;
	1043	CREATE TABLE `game_event_npc_vendor` (
	1044	`event` mediumint(8) unsigned NOT NULL default '0',
	1045	`guid` mediumint(8) unsigned NOT NULL default '0',
	1046	`item` mediumint(8) unsigned NOT NULL default '0',
	1047	`maxcount` mediumint(8) unsigned NOT NULL default '0',
	1048	`incrtime` mediumint(8) unsigned NOT NULL default '0',
	1049	`ExtendedCost` mediumint(8) unsigned NOT NULL default '0',
	1050	PRIMARY KEY (`guid`,`item`)
	1051	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	1052
	1053	--
	1054	-- Dumping data for table `game_event_npc_vendor`
	1055	--
	1056
	1057	LOCK TABLES `game_event_npc_vendor` WRITE;
	1058	/!40000 ALTER TABLE `game_event_npc_vendor` DISABLE KEYS /;
	1059	/!40000 ALTER TABLE `game_event_npc_vendor` ENABLE KEYS /;
	1060	UNLOCK TABLES;
	1061
	1062	--
	1063	-- Table structure for table `game_event_npcflag`
	1064	--
	1065
	1066	DROP TABLE IF EXISTS `game_event_npcflag`;
	1067	CREATE TABLE `game_event_npcflag` (
	1068	`guid` mediumint(8) unsigned NOT NULL default '0',
	1069	`event_id` mediumint(8) unsigned NOT NULL default '0',
	1070	`npcflag` int(10) unsigned NOT NULL default '0',
	1071	PRIMARY KEY (`guid`,`event_id`)
	1072	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	1073
	1074	--
	1075	-- Dumping data for table `game_event_npcflag`
	1076	--
	1077
	1078	LOCK TABLES `game_event_npcflag` WRITE;
	1079	/!40000 ALTER TABLE `game_event_npcflag` DISABLE KEYS /;
	1080	/!40000 ALTER TABLE `game_event_npcflag` ENABLE KEYS /;
	1081	UNLOCK TABLES;
	1082
	1083	--
	1084	-- Table structure for table `game_event_prerequisite`
	1085	--
	1086
	1087	DROP TABLE IF EXISTS `game_event_prerequisite`;
	1088	CREATE TABLE `game_event_prerequisite` (
	1089	`event_id` mediumint(8) unsigned NOT NULL,
	1090	`prerequisite_event` mediumint(8) unsigned NOT NULL,
	1091	PRIMARY KEY (`event_id`,`prerequisite_event`)
	1092	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	1093
	1094	--
	1095	-- Dumping data for table `game_event_prerequisite`
	1096	--
	1097
	1098	LOCK TABLES `game_event_prerequisite` WRITE;
	1099	/!40000 ALTER TABLE `game_event_prerequisite` DISABLE KEYS /;
	1100	/!40000 ALTER TABLE `game_event_prerequisite` ENABLE KEYS /;
	1101	UNLOCK TABLES;
	1102
	1103	--
	1104	-- Table structure for table `game_event_quest_condition`
	1105	--
	1106
	1107	DROP TABLE IF EXISTS `game_event_quest_condition`;
	1108	CREATE TABLE `game_event_quest_condition` (
	1109	`quest` mediumint(8) unsigned NOT NULL default '0',
	1110	`event_id` mediumint(8) unsigned NOT NULL default '0',
	1111	`condition_id` mediumint(8) unsigned NOT NULL default '0',
	1112	`num` float default '0',
	1113	PRIMARY KEY (`quest`)
	1114	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	1115
	1116	--
	1117	-- Dumping data for table `game_event_quest_condition`
	1118	--
	1119
	1120	LOCK TABLES `game_event_quest_condition` WRITE;
	1121	/!40000 ALTER TABLE `game_event_quest_condition` DISABLE KEYS /;
	1122	/!40000 ALTER TABLE `game_event_quest_condition` ENABLE KEYS /;
	1123	UNLOCK TABLES;
	1124
	1125	--
	1126	-- Table structure for table `game_graveyard_zone`
	1127	--
	1128
[37]	1129	DROP TABLE IF EXISTS `game_graveyard_zone`;
	1130	CREATE TABLE `game_graveyard_zone` (
	1131	`id` mediumint(8) unsigned NOT NULL default '0',
	1132	`ghost_zone` mediumint(8) unsigned NOT NULL default '0',
	1133	`faction` smallint(5) unsigned NOT NULL default '0',
	1134	PRIMARY KEY (`id`,`ghost_zone`)
	1135	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Trigger System';
	1136
[45]	1137	--
	1138	-- Dumping data for table `game_graveyard_zone`
	1139	--
[37]	1140
[45]	1141	LOCK TABLES `game_graveyard_zone` WRITE;
	1142	/!40000 ALTER TABLE `game_graveyard_zone` DISABLE KEYS /;
	1143	/!40000 ALTER TABLE `game_graveyard_zone` ENABLE KEYS /;
	1144	UNLOCK TABLES;
[37]	1145
[45]	1146	--
	1147	-- Table structure for table `game_tele`
	1148	--
	1149
[37]	1150	DROP TABLE IF EXISTS `game_tele`;
	1151	CREATE TABLE `game_tele` (
	1152	`id` mediumint(8) unsigned NOT NULL auto_increment,
	1153	`position_x` float NOT NULL default '0',
	1154	`position_y` float NOT NULL default '0',
	1155	`position_z` float NOT NULL default '0',
	1156	`orientation` float NOT NULL default '0',
	1157	`map` smallint(5) unsigned NOT NULL default '0',
	1158	`name` varchar(100) NOT NULL default '',
	1159	PRIMARY KEY (`id`)
	1160	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Tele Command';
	1161
[45]	1162	--
	1163	-- Dumping data for table `game_tele`
	1164	--
[37]	1165
[45]	1166	LOCK TABLES `game_tele` WRITE;
	1167	/!40000 ALTER TABLE `game_tele` DISABLE KEYS /;
	1168	/!40000 ALTER TABLE `game_tele` ENABLE KEYS /;
	1169	UNLOCK TABLES;
[37]	1170
[45]	1171	--
	1172	-- Table structure for table `game_weather`
	1173	--
	1174
[37]	1175	DROP TABLE IF EXISTS `game_weather`;
	1176	CREATE TABLE `game_weather` (
	1177	`zone` mediumint(8) unsigned NOT NULL default '0',
	1178	`spring_rain_chance` tinyint(3) unsigned NOT NULL default '25',
	1179	`spring_snow_chance` tinyint(3) unsigned NOT NULL default '25',
	1180	`spring_storm_chance` tinyint(3) unsigned NOT NULL default '25',
	1181	`summer_rain_chance` tinyint(3) unsigned NOT NULL default '25',
	1182	`summer_snow_chance` tinyint(3) unsigned NOT NULL default '25',
	1183	`summer_storm_chance` tinyint(3) unsigned NOT NULL default '25',
	1184	`fall_rain_chance` tinyint(3) unsigned NOT NULL default '25',
	1185	`fall_snow_chance` tinyint(3) unsigned NOT NULL default '25',
	1186	`fall_storm_chance` tinyint(3) unsigned NOT NULL default '25',
	1187	`winter_rain_chance` tinyint(3) unsigned NOT NULL default '25',
	1188	`winter_snow_chance` tinyint(3) unsigned NOT NULL default '25',
	1189	`winter_storm_chance` tinyint(3) unsigned NOT NULL default '25',
	1190	PRIMARY KEY (`zone`)
	1191	) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Weather System';
	1192
[45]	1193	--
	1194	-- Dumping data for table `game_weather`
	1195	--
[37]	1196
[45]	1197	LOCK TABLES `game_weather` WRITE;
	1198	/!40000 ALTER TABLE `game_weather` DISABLE KEYS /;
	1199	/!40000 ALTER TABLE `game_weather` ENABLE KEYS /;
	1200	UNLOCK TABLES;
[37]	1201
[45]	1202	--
	1203	-- Table structure for table `gameobject`
	1204	--
	1205
[37]	1206	DROP TABLE IF EXISTS `gameobject`;
	1207	CREATE TABLE `gameobject` (
	1208	`guid` int(10) unsigned NOT NULL auto_increment COMMENT 'Global Unique Identifier',
	1209	`id` mediumint(8) unsigned NOT NULL default '0' COMMENT 'Gameobject Identifier',
	1210	`map` smallint(5) unsigned NOT NULL default '0' COMMENT 'Map Identifier',
	1211	`spawnMask` tinyint(3) unsigned NOT NULL default '1',
	1212	`position_x` float NOT NULL default '0',
	1213	`position_y` float NOT NULL default '0',
	1214	`position_z` float NOT NULL default '0',
	1215	`orientation` float NOT NULL default '0',
	1216	`rotation0` float NOT NULL default '0',
	1217	`rotation1` float NOT NULL default '0',
	1218	`rotation2` float NOT NULL default '0',
	1219	`rotation3` float NOT NULL default '0',
	1220	`spawntimesecs` int(11) NOT NULL default '0',
	1221	`animprogress` tinyint(3) unsigned NOT NULL default '0',
	1222	`state` tinyint(3) unsigned NOT NULL default '0',
	1223	PRIMARY KEY (`guid`)
	1224	) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Gameobject System';
	1225
[45]	1226	--
	1227	-- Dumping data for table `gameobject`
	1228	--
[37]	1229
[45]	1230	LOCK TABLES `gameobject` WRITE;
	1231	/!40000 ALTER TABLE `gameobject` DISABLE KEYS /;
	1232	/!40000 ALTER TABLE `gameobject` ENABLE KEYS /;
	1233	UNLOCK TABLES;
[37]	1234
[45]	1235	--
	1236	-- Table structure for table `gameobject_involvedrelation`
	1237	--
	1238
[37]	1239	DROP TABLE IF EXISTS `gameobject_involvedrelation`;
	1240	CREATE TABLE `gameobject_involvedrelation` (
	1241	`id` mediumint(8) unsigned NOT NULL default '0',
	1242	`quest` mediumint(8) unsigned NOT NULL default '0' COMMENT 'Quest Identifier',
	1243	PRIMARY KEY (`id`,`quest`)
	1244	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	1245
[45]	1246	--
	1247	-- Dumping data for table `gameobject_involvedrelation`
	1248	--
[37]	1249
[45]	1250	LOCK TABLES `gameobject_involvedrelation` WRITE;
	1251	/!40000 ALTER TABLE `gameobject_involvedrelation` DISABLE KEYS /;
	1252	/!40000 ALTER TABLE `gameobject_involvedrelation` ENABLE KEYS /;
	1253	UNLOCK TABLES;
[37]	1254
[45]	1255	--
	1256	-- Table structure for table `gameobject_loot_template`
	1257	--
	1258
[37]	1259	DROP TABLE IF EXISTS `gameobject_loot_template`;
	1260	CREATE TABLE `gameobject_loot_template` (
	1261	`entry` mediumint(8) unsigned NOT NULL default '0',
	1262	`item` mediumint(8) unsigned NOT NULL default '0',
	1263	`ChanceOrQuestChance` float NOT NULL default '100',
	1264	`groupid` tinyint(3) unsigned NOT NULL default '0',
	1265	`mincountOrRef` mediumint(9) NOT NULL default '1',
	1266	`maxcount` tinyint(3) unsigned NOT NULL default '1',
	1267	`lootcondition` tinyint(3) unsigned NOT NULL default '0',
	1268	`condition_value1` mediumint(8) unsigned NOT NULL default '0',
	1269	`condition_value2` mediumint(8) unsigned NOT NULL default '0',
	1270	PRIMARY KEY (`entry`,`item`)
[45]	1271	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Loot System';
[37]	1272
[45]	1273	--
	1274	-- Dumping data for table `gameobject_loot_template`
	1275	--
[37]	1276
[45]	1277	LOCK TABLES `gameobject_loot_template` WRITE;
	1278	/!40000 ALTER TABLE `gameobject_loot_template` DISABLE KEYS /;
	1279	/!40000 ALTER TABLE `gameobject_loot_template` ENABLE KEYS /;
	1280	UNLOCK TABLES;
[37]	1281
[45]	1282	--
	1283	-- Table structure for table `gameobject_questrelation`
	1284	--
	1285
[37]	1286	DROP TABLE IF EXISTS `gameobject_questrelation`;
	1287	CREATE TABLE `gameobject_questrelation` (
	1288	`id` mediumint(8) unsigned NOT NULL default '0',
	1289	`quest` mediumint(8) unsigned NOT NULL default '0' COMMENT 'Quest Identifier',
	1290	PRIMARY KEY (`id`,`quest`)
	1291	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	1292
[45]	1293	--
	1294	-- Dumping data for table `gameobject_questrelation`
	1295	--
[37]	1296
[45]	1297	LOCK TABLES `gameobject_questrelation` WRITE;
	1298	/!40000 ALTER TABLE `gameobject_questrelation` DISABLE KEYS /;
	1299	/!40000 ALTER TABLE `gameobject_questrelation` ENABLE KEYS /;
	1300	UNLOCK TABLES;
[37]	1301
[45]	1302	--
	1303	-- Table structure for table `gameobject_respawn`
	1304	--
	1305
[37]	1306	DROP TABLE IF EXISTS `gameobject_respawn`;
	1307	CREATE TABLE `gameobject_respawn` (
	1308	`guid` int(10) unsigned NOT NULL default '0' COMMENT 'Global Unique Identifier',
	1309	`respawntime` bigint(20) NOT NULL default '0',
	1310	`instance` mediumint(8) unsigned NOT NULL default '0',
	1311	PRIMARY KEY (`guid`,`instance`),
	1312	KEY `instance` (`instance`)
	1313	) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Grid Loading System';
	1314
[45]	1315	--
	1316	-- Dumping data for table `gameobject_respawn`
	1317	--
[37]	1318
[45]	1319	LOCK TABLES `gameobject_respawn` WRITE;
	1320	/!40000 ALTER TABLE `gameobject_respawn` DISABLE KEYS /;
	1321	/!40000 ALTER TABLE `gameobject_respawn` ENABLE KEYS /;
	1322	UNLOCK TABLES;
[37]	1323
[45]	1324	--
	1325	-- Table structure for table `gameobject_scripts`
	1326	--
	1327
[37]	1328	DROP TABLE IF EXISTS `gameobject_scripts`;
	1329	CREATE TABLE `gameobject_scripts` (
	1330	`id` mediumint(8) unsigned NOT NULL default '0',
	1331	`delay` int(10) unsigned NOT NULL default '0',
	1332	`command` mediumint(8) unsigned NOT NULL default '0',
	1333	`datalong` mediumint(8) unsigned NOT NULL default '0',
	1334	`datalong2` int(10) unsigned NOT NULL default '0',
	1335	`datatext` text NOT NULL,
	1336	`x` float NOT NULL default '0',
	1337	`y` float NOT NULL default '0',
	1338	`z` float NOT NULL default '0',
	1339	`o` float NOT NULL default '0'
	1340	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	1341
[45]	1342	--
	1343	-- Dumping data for table `gameobject_scripts`
	1344	--
[37]	1345
[45]	1346	LOCK TABLES `gameobject_scripts` WRITE;
	1347	/!40000 ALTER TABLE `gameobject_scripts` DISABLE KEYS /;
	1348	/!40000 ALTER TABLE `gameobject_scripts` ENABLE KEYS /;
	1349	UNLOCK TABLES;
[37]	1350
[45]	1351	--
	1352	-- Table structure for table `gameobject_template`
	1353	--
	1354
[37]	1355	DROP TABLE IF EXISTS `gameobject_template`;
	1356	CREATE TABLE `gameobject_template` (
	1357	`entry` mediumint(8) unsigned NOT NULL default '0',
	1358	`type` tinyint(3) unsigned NOT NULL default '0',
	1359	`displayId` mediumint(8) unsigned NOT NULL default '0',
	1360	`name` varchar(100) NOT NULL default '',
	1361	`castBarCaption` varchar(100) NOT NULL default '',
	1362	`faction` smallint(5) unsigned NOT NULL default '0',
	1363	`flags` int(10) unsigned NOT NULL default '0',
	1364	`size` float NOT NULL default '1',
	1365	`data0` int(10) unsigned NOT NULL default '0',
	1366	`data1` int(10) unsigned NOT NULL default '0',
	1367	`data2` int(10) unsigned NOT NULL default '0',
	1368	`data3` int(10) unsigned NOT NULL default '0',
	1369	`data4` int(10) unsigned NOT NULL default '0',
	1370	`data5` int(10) unsigned NOT NULL default '0',
	1371	`data6` int(10) unsigned NOT NULL default '0',
	1372	`data7` int(10) unsigned NOT NULL default '0',
	1373	`data8` int(10) unsigned NOT NULL default '0',
	1374	`data9` int(10) unsigned NOT NULL default '0',
	1375	`data10` int(10) unsigned NOT NULL default '0',
	1376	`data11` int(10) unsigned NOT NULL default '0',
	1377	`data12` int(10) unsigned NOT NULL default '0',
	1378	`data13` int(10) unsigned NOT NULL default '0',
	1379	`data14` int(10) unsigned NOT NULL default '0',
	1380	`data15` int(10) unsigned NOT NULL default '0',
	1381	`data16` int(10) unsigned NOT NULL default '0',
	1382	`data17` int(10) unsigned NOT NULL default '0',
	1383	`data18` int(10) unsigned NOT NULL default '0',
	1384	`data19` int(10) unsigned NOT NULL default '0',
	1385	`data20` int(10) unsigned NOT NULL default '0',
	1386	`data21` int(10) unsigned NOT NULL default '0',
	1387	`data22` int(10) unsigned NOT NULL default '0',
	1388	`data23` int(10) unsigned NOT NULL default '0',
	1389	`ScriptName` varchar(64) NOT NULL default '',
[45]	1390	PRIMARY KEY (`entry`),
	1391	KEY `idx_name` (`name`)
[37]	1392	) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Gameobject System';
	1393
[45]	1394	--
	1395	-- Dumping data for table `gameobject_template`
	1396	--
[37]	1397
[45]	1398	LOCK TABLES `gameobject_template` WRITE;
	1399	/!40000 ALTER TABLE `gameobject_template` DISABLE KEYS /;
	1400	/!40000 ALTER TABLE `gameobject_template` ENABLE KEYS /;
	1401	UNLOCK TABLES;
[37]	1402
[45]	1403	--
	1404	-- Table structure for table `instance_template`
	1405	--
	1406
[37]	1407	DROP TABLE IF EXISTS `instance_template`;
	1408	CREATE TABLE `instance_template` (
	1409	`map` smallint(5) unsigned NOT NULL,
	1410	`parent` int(10) unsigned NOT NULL,
	1411	`levelMin` tinyint(3) unsigned NOT NULL default '0',
	1412	`levelMax` tinyint(3) unsigned NOT NULL default '0',
	1413	`maxPlayers` tinyint(3) unsigned NOT NULL default '0',
	1414	`reset_delay` int(10) unsigned NOT NULL default '0',
	1415	`startLocX` float default NULL,
	1416	`startLocY` float default NULL,
	1417	`startLocZ` float default NULL,
	1418	`startLocO` float default NULL,
	1419	`script` varchar(128) NOT NULL default '',
	1420	PRIMARY KEY (`map`)
	1421	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	1422
[45]	1423	--
	1424	-- Dumping data for table `instance_template`
	1425	--
[37]	1426
[45]	1427	LOCK TABLES `instance_template` WRITE;
	1428	/!40000 ALTER TABLE `instance_template` DISABLE KEYS /;
	1429	/!40000 ALTER TABLE `instance_template` ENABLE KEYS /;
	1430	UNLOCK TABLES;
[37]	1431
[45]	1432	--
	1433	-- Table structure for table `item_enchantment_template`
	1434	--
[37]	1435
	1436	DROP TABLE IF EXISTS `item_enchantment_template`;
	1437	CREATE TABLE `item_enchantment_template` (
	1438	`entry` mediumint(8) unsigned NOT NULL default '0',
	1439	`ench` mediumint(8) unsigned NOT NULL default '0',
	1440	`chance` float unsigned NOT NULL default '0',
	1441	PRIMARY KEY (`entry`,`ench`)
	1442	) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Item Random Enchantment System';
	1443
[45]	1444	--
	1445	-- Dumping data for table `item_enchantment_template`
	1446	--
[37]	1447
[45]	1448	LOCK TABLES `item_enchantment_template` WRITE;
	1449	/!40000 ALTER TABLE `item_enchantment_template` DISABLE KEYS /;
	1450	/!40000 ALTER TABLE `item_enchantment_template` ENABLE KEYS /;
	1451	UNLOCK TABLES;
[37]	1452
[45]	1453	--
	1454	-- Table structure for table `item_loot_template`
	1455	--
	1456
[37]	1457	DROP TABLE IF EXISTS `item_loot_template`;
	1458	CREATE TABLE `item_loot_template` (
	1459	`entry` mediumint(8) unsigned NOT NULL default '0',
	1460	`item` mediumint(8) unsigned NOT NULL default '0',
	1461	`ChanceOrQuestChance` float NOT NULL default '100',
	1462	`groupid` tinyint(3) unsigned NOT NULL default '0',
	1463	`mincountOrRef` mediumint(9) NOT NULL default '1',
[45]	1464	`maxcount` smallint(5) unsigned NOT NULL default '1',
[37]	1465	`lootcondition` tinyint(3) unsigned NOT NULL default '0',
	1466	`condition_value1` mediumint(8) unsigned NOT NULL default '0',
	1467	`condition_value2` mediumint(8) unsigned NOT NULL default '0',
	1468	PRIMARY KEY (`entry`,`item`)
	1469	) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Loot System';
	1470
[45]	1471	--
	1472	-- Dumping data for table `item_loot_template`
	1473	--
[37]	1474
[45]	1475	LOCK TABLES `item_loot_template` WRITE;
	1476	/!40000 ALTER TABLE `item_loot_template` DISABLE KEYS /;
	1477	/!40000 ALTER TABLE `item_loot_template` ENABLE KEYS /;
	1478	UNLOCK TABLES;
[37]	1479
[45]	1480	--
	1481	-- Table structure for table `item_template`
	1482	--
	1483
[37]	1484	DROP TABLE IF EXISTS `item_template`;
	1485	CREATE TABLE `item_template` (
	1486	`entry` mediumint(8) unsigned NOT NULL default '0',
	1487	`class` tinyint(3) unsigned NOT NULL default '0',
	1488	`subclass` tinyint(3) unsigned NOT NULL default '0',
	1489	`unk0` int(11) NOT NULL default '-1',
	1490	`name` varchar(255) NOT NULL default '',
	1491	`displayid` mediumint(8) unsigned NOT NULL default '0',
	1492	`Quality` tinyint(3) unsigned NOT NULL default '0',
	1493	`Flags` int(10) unsigned NOT NULL default '0',
	1494	`BuyCount` tinyint(3) unsigned NOT NULL default '1',
	1495	`BuyPrice` int(10) unsigned NOT NULL default '0',
	1496	`SellPrice` int(10) unsigned NOT NULL default '0',
	1497	`InventoryType` tinyint(3) unsigned NOT NULL default '0',
	1498	`AllowableClass` mediumint(9) NOT NULL default '-1',
	1499	`AllowableRace` mediumint(9) NOT NULL default '-1',
	1500	`ItemLevel` tinyint(3) unsigned NOT NULL default '0',
	1501	`RequiredLevel` tinyint(3) unsigned NOT NULL default '0',
	1502	`RequiredSkill` smallint(5) unsigned NOT NULL default '0',
	1503	`RequiredSkillRank` smallint(5) unsigned NOT NULL default '0',
	1504	`requiredspell` mediumint(8) unsigned NOT NULL default '0',
	1505	`requiredhonorrank` mediumint(8) unsigned NOT NULL default '0',
	1506	`RequiredCityRank` mediumint(8) unsigned NOT NULL default '0',
	1507	`RequiredReputationFaction` smallint(5) unsigned NOT NULL default '0',
	1508	`RequiredReputationRank` smallint(5) unsigned NOT NULL default '0',
	1509	`maxcount` smallint(5) unsigned NOT NULL default '0',
	1510	`stackable` smallint(5) unsigned NOT NULL default '1',
	1511	`ContainerSlots` tinyint(3) unsigned NOT NULL default '0',
	1512	`stat_type1` tinyint(3) unsigned NOT NULL default '0',
	1513	`stat_value1` smallint(6) NOT NULL default '0',
	1514	`stat_type2` tinyint(3) unsigned NOT NULL default '0',
	1515	`stat_value2` smallint(6) NOT NULL default '0',
	1516	`stat_type3` tinyint(3) unsigned NOT NULL default '0',
	1517	`stat_value3` smallint(6) NOT NULL default '0',
	1518	`stat_type4` tinyint(3) unsigned NOT NULL default '0',
	1519	`stat_value4` smallint(6) NOT NULL default '0',
	1520	`stat_type5` tinyint(3) unsigned NOT NULL default '0',
	1521	`stat_value5` smallint(6) NOT NULL default '0',
	1522	`stat_type6` tinyint(3) unsigned NOT NULL default '0',
	1523	`stat_value6` smallint(6) NOT NULL default '0',
	1524	`stat_type7` tinyint(3) unsigned NOT NULL default '0',
	1525	`stat_value7` smallint(6) NOT NULL default '0',
	1526	`stat_type8` tinyint(3) unsigned NOT NULL default '0',
	1527	`stat_value8` smallint(6) NOT NULL default '0',
	1528	`stat_type9` tinyint(3) unsigned NOT NULL default '0',
	1529	`stat_value9` smallint(6) NOT NULL default '0',
	1530	`stat_type10` tinyint(3) unsigned NOT NULL default '0',
	1531	`stat_value10` smallint(6) NOT NULL default '0',
	1532	`dmg_min1` float NOT NULL default '0',
	1533	`dmg_max1` float NOT NULL default '0',
	1534	`dmg_type1` tinyint(3) unsigned NOT NULL default '0',
	1535	`dmg_min2` float NOT NULL default '0',
	1536	`dmg_max2` float NOT NULL default '0',
	1537	`dmg_type2` tinyint(3) unsigned NOT NULL default '0',
	1538	`dmg_min3` float NOT NULL default '0',
	1539	`dmg_max3` float NOT NULL default '0',
	1540	`dmg_type3` tinyint(3) unsigned NOT NULL default '0',
	1541	`dmg_min4` float NOT NULL default '0',
	1542	`dmg_max4` float NOT NULL default '0',
	1543	`dmg_type4` tinyint(3) unsigned NOT NULL default '0',
	1544	`dmg_min5` float NOT NULL default '0',
	1545	`dmg_max5` float NOT NULL default '0',
	1546	`dmg_type5` tinyint(3) unsigned NOT NULL default '0',
	1547	`armor` smallint(5) unsigned NOT NULL default '0',
	1548	`holy_res` tinyint(3) unsigned NOT NULL default '0',
	1549	`fire_res` tinyint(3) unsigned NOT NULL default '0',
	1550	`nature_res` tinyint(3) unsigned NOT NULL default '0',
	1551	`frost_res` tinyint(3) unsigned NOT NULL default '0',
	1552	`shadow_res` tinyint(3) unsigned NOT NULL default '0',
	1553	`arcane_res` tinyint(3) unsigned NOT NULL default '0',
	1554	`delay` smallint(5) unsigned NOT NULL default '1000',
	1555	`ammo_type` tinyint(3) unsigned NOT NULL default '0',
	1556	`RangedModRange` float NOT NULL default '0',
	1557	`spellid_1` mediumint(8) unsigned NOT NULL default '0',
	1558	`spelltrigger_1` tinyint(3) unsigned NOT NULL default '0',
	1559	`spellcharges_1` tinyint(4) NOT NULL default '0',
	1560	`spellppmRate_1` float NOT NULL default '0',
	1561	`spellcooldown_1` int(11) NOT NULL default '-1',
	1562	`spellcategory_1` smallint(5) unsigned NOT NULL default '0',
	1563	`spellcategorycooldown_1` int(11) NOT NULL default '-1',
	1564	`spellid_2` mediumint(8) unsigned NOT NULL default '0',
	1565	`spelltrigger_2` tinyint(3) unsigned NOT NULL default '0',
	1566	`spellcharges_2` tinyint(4) NOT NULL default '0',
	1567	`spellppmRate_2` float NOT NULL default '0',
	1568	`spellcooldown_2` int(11) NOT NULL default '-1',
	1569	`spellcategory_2` smallint(5) unsigned NOT NULL default '0',
	1570	`spellcategorycooldown_2` int(11) NOT NULL default '-1',
	1571	`spellid_3` mediumint(8) unsigned NOT NULL default '0',
	1572	`spelltrigger_3` tinyint(3) unsigned NOT NULL default '0',
	1573	`spellcharges_3` tinyint(4) NOT NULL default '0',
	1574	`spellppmRate_3` float NOT NULL default '0',
	1575	`spellcooldown_3` int(11) NOT NULL default '-1',
	1576	`spellcategory_3` smallint(5) unsigned NOT NULL default '0',
	1577	`spellcategorycooldown_3` int(11) NOT NULL default '-1',
	1578	`spellid_4` mediumint(8) unsigned NOT NULL default '0',
	1579	`spelltrigger_4` tinyint(3) unsigned NOT NULL default '0',
	1580	`spellcharges_4` tinyint(4) NOT NULL default '0',
	1581	`spellppmRate_4` float NOT NULL default '0',
	1582	`spellcooldown_4` int(11) NOT NULL default '-1',
	1583	`spellcategory_4` smallint(5) unsigned NOT NULL default '0',
	1584	`spellcategorycooldown_4` int(11) NOT NULL default '-1',
	1585	`spellid_5` mediumint(8) unsigned NOT NULL default '0',
	1586	`spelltrigger_5` tinyint(3) unsigned NOT NULL default '0',
	1587	`spellcharges_5` tinyint(4) NOT NULL default '0',
	1588	`spellppmRate_5` float NOT NULL default '0',
	1589	`spellcooldown_5` int(11) NOT NULL default '-1',
	1590	`spellcategory_5` smallint(5) unsigned NOT NULL default '0',
	1591	`spellcategorycooldown_5` int(11) NOT NULL default '-1',
	1592	`bonding` tinyint(3) unsigned NOT NULL default '0',
	1593	`description` varchar(255) NOT NULL default '',
	1594	`PageText` mediumint(8) unsigned NOT NULL default '0',
	1595	`LanguageID` tinyint(3) unsigned NOT NULL default '0',
	1596	`PageMaterial` tinyint(3) unsigned NOT NULL default '0',
	1597	`startquest` mediumint(8) unsigned NOT NULL default '0',
	1598	`lockid` mediumint(8) unsigned NOT NULL default '0',
	1599	`Material` tinyint(4) NOT NULL default '0',
	1600	`sheath` tinyint(3) unsigned NOT NULL default '0',
	1601	`RandomProperty` mediumint(8) unsigned NOT NULL default '0',
	1602	`RandomSuffix` mediumint(8) unsigned NOT NULL default '0',
	1603	`block` mediumint(8) unsigned NOT NULL default '0',
	1604	`itemset` mediumint(8) unsigned NOT NULL default '0',
	1605	`MaxDurability` smallint(5) unsigned NOT NULL default '0',
	1606	`area` mediumint(8) unsigned NOT NULL default '0',
	1607	`Map` smallint(6) NOT NULL default '0',
	1608	`BagFamily` mediumint(9) NOT NULL default '0',
	1609	`TotemCategory` tinyint(4) NOT NULL default '0',
	1610	`socketColor_1` tinyint(4) NOT NULL default '0',
	1611	`socketContent_1` mediumint(9) NOT NULL default '0',
	1612	`socketColor_2` tinyint(4) NOT NULL default '0',
	1613	`socketContent_2` mediumint(9) NOT NULL default '0',
	1614	`socketColor_3` tinyint(4) NOT NULL default '0',
	1615	`socketContent_3` mediumint(9) NOT NULL default '0',
	1616	`socketBonus` mediumint(9) NOT NULL default '0',
	1617	`GemProperties` mediumint(9) NOT NULL default '0',
	1618	`RequiredDisenchantSkill` smallint(6) NOT NULL default '-1',
	1619	`ArmorDamageModifier` float NOT NULL default '0',
	1620	`ScriptName` varchar(64) NOT NULL default '',
	1621	`DisenchantID` mediumint(8) unsigned NOT NULL default '0',
	1622	`FoodType` tinyint(3) unsigned NOT NULL default '0',
	1623	`minMoneyLoot` int(10) unsigned NOT NULL default '0',
	1624	`maxMoneyLoot` int(10) unsigned NOT NULL default '0',
	1625	`Duration` int(11) NOT NULL default '0' COMMENT 'Duration in seconds. Negative value means realtime, postive value ingame time',
	1626	PRIMARY KEY (`entry`),
[45]	1627	KEY `idx_name` (`name`),
[37]	1628	KEY `items_index` (`class`)
	1629	) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Item System';
	1630
[45]	1631	--
	1632	-- Dumping data for table `item_template`
	1633	--
[37]	1634
[45]	1635	LOCK TABLES `item_template` WRITE;
	1636	/!40000 ALTER TABLE `item_template` DISABLE KEYS /;
	1637	/!40000 ALTER TABLE `item_template` ENABLE KEYS /;
	1638	UNLOCK TABLES;
[37]	1639
[45]	1640	--
	1641	-- Table structure for table `locales_creature`
	1642	--
[37]	1643
	1644	DROP TABLE IF EXISTS `locales_creature`;
	1645	CREATE TABLE `locales_creature` (
	1646	`entry` mediumint(8) unsigned NOT NULL default '0',
	1647	`name_loc1` varchar(100) NOT NULL default '',
	1648	`name_loc2` varchar(100) NOT NULL default '',
	1649	`name_loc3` varchar(100) NOT NULL default '',
	1650	`name_loc4` varchar(100) NOT NULL default '',
	1651	`name_loc5` varchar(100) NOT NULL default '',
	1652	`name_loc6` varchar(100) NOT NULL default '',
	1653	`name_loc7` varchar(100) NOT NULL default '',
	1654	`name_loc8` varchar(100) NOT NULL default '',
	1655	`subname_loc1` varchar(100) default NULL,
	1656	`subname_loc2` varchar(100) default NULL,
	1657	`subname_loc3` varchar(100) default NULL,
	1658	`subname_loc4` varchar(100) default NULL,
	1659	`subname_loc5` varchar(100) default NULL,
	1660	`subname_loc6` varchar(100) default NULL,
	1661	`subname_loc7` varchar(100) default NULL,
	1662	`subname_loc8` varchar(100) default NULL,
	1663	PRIMARY KEY (`entry`)
	1664	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	1665
[45]	1666	--
	1667	-- Dumping data for table `locales_creature`
	1668	--
[37]	1669
[45]	1670	LOCK TABLES `locales_creature` WRITE;
	1671	/!40000 ALTER TABLE `locales_creature` DISABLE KEYS /;
	1672	/!40000 ALTER TABLE `locales_creature` ENABLE KEYS /;
	1673	UNLOCK TABLES;
[37]	1674
[45]	1675	--
	1676	-- Table structure for table `locales_gameobject`
	1677	--
	1678
[37]	1679	DROP TABLE IF EXISTS `locales_gameobject`;
	1680	CREATE TABLE `locales_gameobject` (
	1681	`entry` mediumint(8) unsigned NOT NULL default '0',
	1682	`name_loc1` varchar(100) NOT NULL default '',
	1683	`name_loc2` varchar(100) NOT NULL default '',
	1684	`name_loc3` varchar(100) NOT NULL default '',
	1685	`name_loc4` varchar(100) NOT NULL default '',
	1686	`name_loc5` varchar(100) NOT NULL default '',
	1687	`name_loc6` varchar(100) NOT NULL default '',
	1688	`name_loc7` varchar(100) NOT NULL default '',
	1689	`name_loc8` varchar(100) NOT NULL default '',
	1690	`castbarcaption_loc1` varchar(100) NOT NULL default '',
	1691	`castbarcaption_loc2` varchar(100) NOT NULL default '',
	1692	`castbarcaption_loc3` varchar(100) NOT NULL default '',
	1693	`castbarcaption_loc4` varchar(100) NOT NULL default '',
	1694	`castbarcaption_loc5` varchar(100) NOT NULL default '',
	1695	`castbarcaption_loc6` varchar(100) NOT NULL default '',
	1696	`castbarcaption_loc7` varchar(100) NOT NULL default '',
	1697	`castbarcaption_loc8` varchar(100) NOT NULL default '',
	1698	PRIMARY KEY (`entry`)
	1699	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	1700
[45]	1701	--
	1702	-- Dumping data for table `locales_gameobject`
	1703	--
[37]	1704
[45]	1705	LOCK TABLES `locales_gameobject` WRITE;
	1706	/!40000 ALTER TABLE `locales_gameobject` DISABLE KEYS /;
	1707	/!40000 ALTER TABLE `locales_gameobject` ENABLE KEYS /;
	1708	UNLOCK TABLES;
[37]	1709
[45]	1710	--
	1711	-- Table structure for table `locales_item`
	1712	--
	1713
[37]	1714	DROP TABLE IF EXISTS `locales_item`;
	1715	CREATE TABLE `locales_item` (
	1716	`entry` mediumint(8) unsigned NOT NULL default '0',
	1717	`name_loc1` varchar(100) NOT NULL default '',
	1718	`name_loc2` varchar(100) NOT NULL default '',
	1719	`name_loc3` varchar(100) NOT NULL default '',
	1720	`name_loc4` varchar(100) NOT NULL default '',
	1721	`name_loc5` varchar(100) NOT NULL default '',
	1722	`name_loc6` varchar(100) NOT NULL default '',
	1723	`name_loc7` varchar(100) NOT NULL default '',
	1724	`name_loc8` varchar(100) NOT NULL default '',
	1725	`description_loc1` varchar(255) default NULL,
	1726	`description_loc2` varchar(255) default NULL,
	1727	`description_loc3` varchar(255) default NULL,
	1728	`description_loc4` varchar(255) default NULL,
	1729	`description_loc5` varchar(255) default NULL,
	1730	`description_loc6` varchar(255) default NULL,
	1731	`description_loc7` varchar(255) default NULL,
	1732	`description_loc8` varchar(255) default NULL,
	1733	PRIMARY KEY (`entry`)
	1734	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	1735
[45]	1736	--
	1737	-- Dumping data for table `locales_item`
	1738	--
[37]	1739
[45]	1740	LOCK TABLES `locales_item` WRITE;
	1741	/!40000 ALTER TABLE `locales_item` DISABLE KEYS /;
	1742	/!40000 ALTER TABLE `locales_item` ENABLE KEYS /;
	1743	UNLOCK TABLES;
[37]	1744
[45]	1745	--
	1746	-- Table structure for table `locales_npc_text`
	1747	--
	1748
[37]	1749	DROP TABLE IF EXISTS `locales_npc_text`;
	1750	CREATE TABLE `locales_npc_text` (
	1751	`entry` mediumint(8) unsigned NOT NULL default '0',
	1752	`Text0_0_loc1` longtext,
	1753	`Text0_0_loc2` longtext,
	1754	`Text0_0_loc3` longtext,
	1755	`Text0_0_loc4` longtext,
	1756	`Text0_0_loc5` longtext,
	1757	`Text0_0_loc6` longtext,
	1758	`Text0_0_loc7` longtext,
	1759	`Text0_0_loc8` longtext,
	1760	`Text0_1_loc1` longtext,
	1761	`Text0_1_loc2` longtext,
	1762	`Text0_1_loc3` longtext,
	1763	`Text0_1_loc4` longtext,
	1764	`Text0_1_loc5` longtext,
	1765	`Text0_1_loc6` longtext,
	1766	`Text0_1_loc7` longtext,
	1767	`Text0_1_loc8` longtext,
	1768	`Text1_0_loc1` longtext,
	1769	`Text1_0_loc2` longtext,
	1770	`Text1_0_loc3` longtext,
	1771	`Text1_0_loc4` longtext,
	1772	`Text1_0_loc5` longtext,
	1773	`Text1_0_loc6` longtext,
	1774	`Text1_0_loc7` longtext,
	1775	`Text1_0_loc8` longtext,
	1776	`Text1_1_loc1` longtext,
	1777	`Text1_1_loc2` longtext,
	1778	`Text1_1_loc3` longtext,
	1779	`Text1_1_loc4` longtext,
	1780	`Text1_1_loc5` longtext,
	1781	`Text1_1_loc6` longtext,
	1782	`Text1_1_loc7` longtext,
	1783	`Text1_1_loc8` longtext,
	1784	`Text2_0_loc1` longtext,
	1785	`Text2_0_loc2` longtext,
	1786	`Text2_0_loc3` longtext,
	1787	`Text2_0_loc4` longtext,
	1788	`Text2_0_loc5` longtext,
	1789	`Text2_0_loc6` longtext,
	1790	`Text2_0_loc7` longtext,
	1791	`Text2_0_loc8` longtext,
	1792	`Text2_1_loc1` longtext,
	1793	`Text2_1_loc2` longtext,
	1794	`Text2_1_loc3` longtext,
	1795	`Text2_1_loc4` longtext,
	1796	`Text2_1_loc5` longtext,
	1797	`Text2_1_loc6` longtext,
	1798	`Text2_1_loc7` longtext,
	1799	`Text2_1_loc8` longtext,
	1800	`Text3_0_loc1` longtext,
	1801	`Text3_0_loc2` longtext,
	1802	`Text3_0_loc3` longtext,
	1803	`Text3_0_loc4` longtext,
	1804	`Text3_0_loc5` longtext,
	1805	`Text3_0_loc6` longtext,
	1806	`Text3_0_loc7` longtext,
	1807	`Text3_0_loc8` longtext,
	1808	`Text3_1_loc1` longtext,
	1809	`Text3_1_loc2` longtext,
	1810	`Text3_1_loc3` longtext,
	1811	`Text3_1_loc4` longtext,
	1812	`Text3_1_loc5` longtext,
	1813	`Text3_1_loc6` longtext,
	1814	`Text3_1_loc7` longtext,
	1815	`Text3_1_loc8` longtext,
	1816	`Text4_0_loc1` longtext,
	1817	`Text4_0_loc2` longtext,
	1818	`Text4_0_loc3` longtext,
	1819	`Text4_0_loc4` longtext,
	1820	`Text4_0_loc5` longtext,
	1821	`Text4_0_loc6` longtext,
	1822	`Text4_0_loc7` longtext,
	1823	`Text4_0_loc8` longtext,
	1824	`Text4_1_loc1` longtext,
	1825	`Text4_1_loc2` longtext,
	1826	`Text4_1_loc3` longtext,
	1827	`Text4_1_loc4` longtext,
	1828	`Text4_1_loc5` longtext,
	1829	`Text4_1_loc6` longtext,
	1830	`Text4_1_loc7` longtext,
	1831	`Text4_1_loc8` longtext,
	1832	`Text5_0_loc1` longtext,
	1833	`Text5_0_loc2` longtext,
	1834	`Text5_0_loc3` longtext,
	1835	`Text5_0_loc4` longtext,
	1836	`Text5_0_loc5` longtext,
	1837	`Text5_0_loc6` longtext,
	1838	`Text5_0_loc7` longtext,
	1839	`Text5_0_loc8` longtext,
	1840	`Text5_1_loc1` longtext,
	1841	`Text5_1_loc2` longtext,
	1842	`Text5_1_loc3` longtext,
	1843	`Text5_1_loc4` longtext,
	1844	`Text5_1_loc5` longtext,
	1845	`Text5_1_loc6` longtext,
	1846	`Text5_1_loc7` longtext,
	1847	`Text5_1_loc8` longtext,
	1848	`Text6_0_loc1` longtext,
	1849	`Text6_0_loc2` longtext,
	1850	`Text6_0_loc3` longtext,
	1851	`Text6_0_loc4` longtext,
	1852	`Text6_0_loc5` longtext,
	1853	`Text6_0_loc6` longtext,
	1854	`Text6_0_loc7` longtext,
	1855	`Text6_0_loc8` longtext,
	1856	`Text6_1_loc1` longtext,
	1857	`Text6_1_loc2` longtext,
	1858	`Text6_1_loc3` longtext,
	1859	`Text6_1_loc4` longtext,
	1860	`Text6_1_loc5` longtext,
	1861	`Text6_1_loc6` longtext,
	1862	`Text6_1_loc7` longtext,
	1863	`Text6_1_loc8` longtext,
	1864	`Text7_0_loc1` longtext,
	1865	`Text7_0_loc2` longtext,
	1866	`Text7_0_loc3` longtext,
	1867	`Text7_0_loc4` longtext,
	1868	`Text7_0_loc5` longtext,
	1869	`Text7_0_loc6` longtext,
	1870	`Text7_0_loc7` longtext,
	1871	`Text7_0_loc8` longtext,
	1872	`Text7_1_loc1` longtext,
	1873	`Text7_1_loc2` longtext,
	1874	`Text7_1_loc3` longtext,
	1875	`Text7_1_loc4` longtext,
	1876	`Text7_1_loc5` longtext,
	1877	`Text7_1_loc6` longtext,
	1878	`Text7_1_loc7` longtext,
	1879	`Text7_1_loc8` longtext,
	1880	PRIMARY KEY (`entry`)
	1881	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	1882
[45]	1883	--
	1884	-- Dumping data for table `locales_npc_text`
	1885	--
[37]	1886
[45]	1887	LOCK TABLES `locales_npc_text` WRITE;
	1888	/!40000 ALTER TABLE `locales_npc_text` DISABLE KEYS /;
	1889	/!40000 ALTER TABLE `locales_npc_text` ENABLE KEYS /;
	1890	UNLOCK TABLES;
[37]	1891
[45]	1892	--
	1893	-- Table structure for table `locales_page_text`
	1894	--
	1895
[37]	1896	DROP TABLE IF EXISTS `locales_page_text`;
	1897	CREATE TABLE `locales_page_text` (
	1898	`entry` mediumint(8) unsigned NOT NULL default '0',
	1899	`Text_loc1` longtext,
	1900	`Text_loc2` longtext,
	1901	`Text_loc3` longtext,
	1902	`Text_loc4` longtext,
	1903	`Text_loc5` longtext,
	1904	`Text_loc6` longtext,
	1905	`Text_loc7` longtext,
	1906	`Text_loc8` longtext,
	1907	PRIMARY KEY (`entry`)
	1908	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	1909
[45]	1910	--
	1911	-- Dumping data for table `locales_page_text`
	1912	--
[37]	1913
[45]	1914	LOCK TABLES `locales_page_text` WRITE;
	1915	/!40000 ALTER TABLE `locales_page_text` DISABLE KEYS /;
	1916	/!40000 ALTER TABLE `locales_page_text` ENABLE KEYS /;
	1917	UNLOCK TABLES;
[37]	1918
[45]	1919	--
	1920	-- Table structure for table `locales_quest`
	1921	--
	1922
[37]	1923	DROP TABLE IF EXISTS `locales_quest`;
	1924	CREATE TABLE `locales_quest` (
	1925	`entry` mediumint(8) unsigned NOT NULL default '0',
	1926	`Title_loc1` text,
	1927	`Title_loc2` text,
	1928	`Title_loc3` text,
	1929	`Title_loc4` text,
	1930	`Title_loc5` text,
	1931	`Title_loc6` text,
	1932	`Title_loc7` text,
	1933	`Title_loc8` text,
	1934	`Details_loc1` text,
	1935	`Details_loc2` text,
	1936	`Details_loc3` text,
	1937	`Details_loc4` text,
	1938	`Details_loc5` text,
	1939	`Details_loc6` text,
	1940	`Details_loc7` text,
	1941	`Details_loc8` text,
	1942	`Objectives_loc1` text,
	1943	`Objectives_loc2` text,
	1944	`Objectives_loc3` text,
	1945	`Objectives_loc4` text,
	1946	`Objectives_loc5` text,
	1947	`Objectives_loc6` text,
	1948	`Objectives_loc7` text,
	1949	`Objectives_loc8` text,
	1950	`OfferRewardText_loc1` text,
	1951	`OfferRewardText_loc2` text,
	1952	`OfferRewardText_loc3` text,
	1953	`OfferRewardText_loc4` text,
	1954	`OfferRewardText_loc5` text,
	1955	`OfferRewardText_loc6` text,
	1956	`OfferRewardText_loc7` text,
	1957	`OfferRewardText_loc8` text,
	1958	`RequestItemsText_loc1` text,
	1959	`RequestItemsText_loc2` text,
	1960	`RequestItemsText_loc3` text,
	1961	`RequestItemsText_loc4` text,
	1962	`RequestItemsText_loc5` text,
	1963	`RequestItemsText_loc6` text,
	1964	`RequestItemsText_loc7` text,
	1965	`RequestItemsText_loc8` text,
	1966	`EndText_loc1` text,
	1967	`EndText_loc2` text,
	1968	`EndText_loc3` text,
	1969	`EndText_loc4` text,
	1970	`EndText_loc5` text,
	1971	`EndText_loc6` text,
	1972	`EndText_loc7` text,
	1973	`EndText_loc8` text,
	1974	`ObjectiveText1_loc1` text,
	1975	`ObjectiveText1_loc2` text,
	1976	`ObjectiveText1_loc3` text,
	1977	`ObjectiveText1_loc4` text,
	1978	`ObjectiveText1_loc5` text,
	1979	`ObjectiveText1_loc6` text,
	1980	`ObjectiveText1_loc7` text,
	1981	`ObjectiveText1_loc8` text,
	1982	`ObjectiveText2_loc1` text,
	1983	`ObjectiveText2_loc2` text,
	1984	`ObjectiveText2_loc3` text,
	1985	`ObjectiveText2_loc4` text,
	1986	`ObjectiveText2_loc5` text,
	1987	`ObjectiveText2_loc6` text,
	1988	`ObjectiveText2_loc7` text,
	1989	`ObjectiveText2_loc8` text,
	1990	`ObjectiveText3_loc1` text,
	1991	`ObjectiveText3_loc2` text,
	1992	`ObjectiveText3_loc3` text,
	1993	`ObjectiveText3_loc4` text,
	1994	`ObjectiveText3_loc5` text,
	1995	`ObjectiveText3_loc6` text,
	1996	`ObjectiveText3_loc7` text,
	1997	`ObjectiveText3_loc8` text,
	1998	`ObjectiveText4_loc1` text,
	1999	`ObjectiveText4_loc2` text,
	2000	`ObjectiveText4_loc3` text,
	2001	`ObjectiveText4_loc4` text,
	2002	`ObjectiveText4_loc5` text,
	2003	`ObjectiveText4_loc6` text,
	2004	`ObjectiveText4_loc7` text,
	2005	`ObjectiveText4_loc8` text,
	2006	PRIMARY KEY (`entry`)
	2007	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	2008
[45]	2009	--
	2010	-- Dumping data for table `locales_quest`
	2011	--
[37]	2012
[45]	2013	LOCK TABLES `locales_quest` WRITE;
	2014	/!40000 ALTER TABLE `locales_quest` DISABLE KEYS /;
	2015	/!40000 ALTER TABLE `locales_quest` ENABLE KEYS /;
	2016	UNLOCK TABLES;
[37]	2017
[45]	2018	--
	2019	-- Table structure for table `npc_gossip`
	2020	--
[39]	2021
[37]	2022	DROP TABLE IF EXISTS `npc_gossip`;
	2023	CREATE TABLE `npc_gossip` (
	2024	`npc_guid` int(10) unsigned NOT NULL default '0',
	2025	`textid` mediumint(8) unsigned NOT NULL default '0',
	2026	PRIMARY KEY (`npc_guid`)
	2027	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	2028
[45]	2029	--
	2030	-- Dumping data for table `npc_gossip`
	2031	--
[37]	2032
[45]	2033	LOCK TABLES `npc_gossip` WRITE;
	2034	/!40000 ALTER TABLE `npc_gossip` DISABLE KEYS /;
	2035	/!40000 ALTER TABLE `npc_gossip` ENABLE KEYS /;
	2036	UNLOCK TABLES;
[37]	2037
[45]	2038	--
	2039	-- Table structure for table `npc_gossip_textid`
	2040	--
	2041
[37]	2042	DROP TABLE IF EXISTS `npc_gossip_textid`;
	2043	CREATE TABLE `npc_gossip_textid` (
	2044	`zoneid` smallint(5) unsigned NOT NULL default '0',
	2045	`action` smallint(5) unsigned NOT NULL default '0',
	2046	`textid` mediumint(8) unsigned NOT NULL default '0',
	2047	KEY `zoneid` (`zoneid`)
	2048	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	2049
[45]	2050	--
	2051	-- Dumping data for table `npc_gossip_textid`
	2052	--
[37]	2053
[45]	2054	LOCK TABLES `npc_gossip_textid` WRITE;
	2055	/!40000 ALTER TABLE `npc_gossip_textid` DISABLE KEYS /;
	2056	/!40000 ALTER TABLE `npc_gossip_textid` ENABLE KEYS /;
	2057	UNLOCK TABLES;
[37]	2058
[45]	2059	--
	2060	-- Table structure for table `npc_option`
	2061	--
	2062
[37]	2063	DROP TABLE IF EXISTS `npc_option`;
	2064	CREATE TABLE `npc_option` (
	2065	`id` tinyint(3) unsigned NOT NULL default '0',
	2066	`gossip_id` tinyint(3) unsigned NOT NULL default '0',
	2067	`npcflag` int(10) unsigned NOT NULL default '0',
	2068	`icon` tinyint(3) unsigned NOT NULL default '0',
	2069	`action` tinyint(3) unsigned NOT NULL default '0',
	2070	`option_text` text,
	2071	PRIMARY KEY (`id`)
	2072	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	2073
[45]	2074	--
	2075	-- Dumping data for table `npc_option`
	2076	--
[37]	2077
[45]	2078	LOCK TABLES `npc_option` WRITE;
	2079	/!40000 ALTER TABLE `npc_option` DISABLE KEYS /;
	2080	/!40000 ALTER TABLE `npc_option` ENABLE KEYS /;
	2081	UNLOCK TABLES;
[37]	2082
[45]	2083	--
	2084	-- Table structure for table `npc_text`
	2085	--
	2086
[37]	2087	DROP TABLE IF EXISTS `npc_text`;
	2088	CREATE TABLE `npc_text` (
	2089	`ID` mediumint(8) unsigned NOT NULL default '0',
	2090	`text0_0` longtext,
	2091	`text0_1` longtext,
	2092	`lang0` tinyint(3) unsigned NOT NULL default '0',
	2093	`prob0` float NOT NULL default '0',
	2094	`em0_0` smallint(5) unsigned NOT NULL default '0',
	2095	`em0_1` smallint(5) unsigned NOT NULL default '0',
	2096	`em0_2` smallint(5) unsigned NOT NULL default '0',
	2097	`em0_3` smallint(5) unsigned NOT NULL default '0',
	2098	`em0_4` smallint(5) unsigned NOT NULL default '0',
	2099	`em0_5` smallint(5) unsigned NOT NULL default '0',
	2100	`text1_0` longtext,
	2101	`text1_1` longtext,
	2102	`lang1` tinyint(3) unsigned NOT NULL default '0',
	2103	`prob1` float NOT NULL default '0',
	2104	`em1_0` smallint(5) unsigned NOT NULL default '0',
	2105	`em1_1` smallint(5) unsigned NOT NULL default '0',
	2106	`em1_2` smallint(5) unsigned NOT NULL default '0',
	2107	`em1_3` smallint(5) unsigned NOT NULL default '0',
	2108	`em1_4` smallint(5) unsigned NOT NULL default '0',
	2109	`em1_5` smallint(5) unsigned NOT NULL default '0',
	2110	`text2_0` longtext,
	2111	`text2_1` longtext,
	2112	`lang2` tinyint(3) unsigned NOT NULL default '0',
	2113	`prob2` float NOT NULL default '0',
	2114	`em2_0` smallint(5) unsigned NOT NULL default '0',
	2115	`em2_1` smallint(5) unsigned NOT NULL default '0',
	2116	`em2_2` smallint(5) unsigned NOT NULL default '0',
	2117	`em2_3` smallint(5) unsigned NOT NULL default '0',
	2118	`em2_4` smallint(5) unsigned NOT NULL default '0',
	2119	`em2_5` smallint(5) unsigned NOT NULL default '0',
	2120	`text3_0` longtext,
	2121	`text3_1` longtext,
	2122	`lang3` tinyint(3) unsigned NOT NULL default '0',
	2123	`prob3` float NOT NULL default '0',
	2124	`em3_0` smallint(5) unsigned NOT NULL default '0',
	2125	`em3_1` smallint(5) unsigned NOT NULL default '0',
	2126	`em3_2` smallint(5) unsigned NOT NULL default '0',
	2127	`em3_3` smallint(5) unsigned NOT NULL default '0',
	2128	`em3_4` smallint(5) unsigned NOT NULL default '0',
	2129	`em3_5` smallint(5) unsigned NOT NULL default '0',
	2130	`text4_0` longtext,
	2131	`text4_1` longtext,
	2132	`lang4` tinyint(3) unsigned NOT NULL default '0',
	2133	`prob4` float NOT NULL default '0',
	2134	`em4_0` smallint(5) unsigned NOT NULL default '0',
	2135	`em4_1` smallint(5) unsigned NOT NULL default '0',
	2136	`em4_2` smallint(5) unsigned NOT NULL default '0',
	2137	`em4_3` smallint(5) unsigned NOT NULL default '0',
	2138	`em4_4` smallint(5) unsigned NOT NULL default '0',
	2139	`em4_5` smallint(5) unsigned NOT NULL default '0',
	2140	`text5_0` longtext,
	2141	`text5_1` longtext,
	2142	`lang5` tinyint(3) unsigned NOT NULL default '0',
	2143	`prob5` float NOT NULL default '0',
	2144	`em5_0` smallint(5) unsigned NOT NULL default '0',
	2145	`em5_1` smallint(5) unsigned NOT NULL default '0',
	2146	`em5_2` smallint(5) unsigned NOT NULL default '0',
	2147	`em5_3` smallint(5) unsigned NOT NULL default '0',
	2148	`em5_4` smallint(5) unsigned NOT NULL default '0',
	2149	`em5_5` smallint(5) unsigned NOT NULL default '0',
	2150	`text6_0` longtext,
	2151	`text6_1` longtext,
	2152	`lang6` tinyint(3) unsigned NOT NULL default '0',
	2153	`prob6` float NOT NULL default '0',
	2154	`em6_0` smallint(5) unsigned NOT NULL default '0',
	2155	`em6_1` smallint(5) unsigned NOT NULL default '0',
	2156	`em6_2` smallint(5) unsigned NOT NULL default '0',
	2157	`em6_3` smallint(5) unsigned NOT NULL default '0',
	2158	`em6_4` smallint(5) unsigned NOT NULL default '0',
	2159	`em6_5` smallint(5) unsigned NOT NULL default '0',
	2160	`text7_0` longtext,
	2161	`text7_1` longtext,
	2162	`lang7` tinyint(3) unsigned NOT NULL default '0',
	2163	`prob7` float NOT NULL default '0',
	2164	`em7_0` smallint(5) unsigned NOT NULL default '0',
	2165	`em7_1` smallint(5) unsigned NOT NULL default '0',
	2166	`em7_2` smallint(5) unsigned NOT NULL default '0',
	2167	`em7_3` smallint(5) unsigned NOT NULL default '0',
	2168	`em7_4` smallint(5) unsigned NOT NULL default '0',
	2169	`em7_5` smallint(5) unsigned NOT NULL default '0',
	2170	PRIMARY KEY (`ID`)
	2171	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	2172
[45]	2173	--
	2174	-- Dumping data for table `npc_text`
	2175	--
[37]	2176
[45]	2177	LOCK TABLES `npc_text` WRITE;
	2178	/!40000 ALTER TABLE `npc_text` DISABLE KEYS /;
	2179	/!40000 ALTER TABLE `npc_text` ENABLE KEYS /;
	2180	UNLOCK TABLES;
[37]	2181
[45]	2182	--
	2183	-- Table structure for table `npc_trainer`
	2184	--
	2185
[37]	2186	DROP TABLE IF EXISTS `npc_trainer`;
	2187	CREATE TABLE `npc_trainer` (
	2188	`entry` mediumint(8) unsigned NOT NULL default '0',
	2189	`spell` mediumint(8) unsigned NOT NULL default '0',
	2190	`spellcost` int(10) unsigned NOT NULL default '0',
	2191	`reqskill` smallint(5) unsigned NOT NULL default '0',
	2192	`reqskillvalue` smallint(5) unsigned NOT NULL default '0',
	2193	`reqlevel` tinyint(3) unsigned NOT NULL default '0',
[45]	2194	PRIMARY KEY (`entry`,`spell`)
[37]	2195	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	2196
[45]	2197	--
	2198	-- Dumping data for table `npc_trainer`
	2199	--
[37]	2200
[45]	2201	LOCK TABLES `npc_trainer` WRITE;
	2202	/!40000 ALTER TABLE `npc_trainer` DISABLE KEYS /;
	2203	/!40000 ALTER TABLE `npc_trainer` ENABLE KEYS /;
	2204	UNLOCK TABLES;
[37]	2205
[45]	2206	--
	2207	-- Table structure for table `npc_vendor`
	2208	--
	2209
[37]	2210	DROP TABLE IF EXISTS `npc_vendor`;
	2211	CREATE TABLE `npc_vendor` (
	2212	`entry` mediumint(8) unsigned NOT NULL default '0',
	2213	`item` mediumint(8) unsigned NOT NULL default '0',
	2214	`maxcount` tinyint(3) unsigned NOT NULL default '0',
	2215	`incrtime` int(10) unsigned NOT NULL default '0',
	2216	`ExtendedCost` mediumint(8) unsigned NOT NULL default '0',
	2217	PRIMARY KEY (`entry`,`item`)
	2218	) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Npc System';
	2219
[45]	2220	--
	2221	-- Dumping data for table `npc_vendor`
	2222	--
[37]	2223
[45]	2224	LOCK TABLES `npc_vendor` WRITE;
	2225	/!40000 ALTER TABLE `npc_vendor` DISABLE KEYS /;
	2226	/!40000 ALTER TABLE `npc_vendor` ENABLE KEYS /;
	2227	UNLOCK TABLES;
[37]	2228
[45]	2229	--
	2230	-- Table structure for table `page_text`
	2231	--
	2232
[37]	2233	DROP TABLE IF EXISTS `page_text`;
	2234	CREATE TABLE `page_text` (
	2235	`entry` mediumint(8) unsigned NOT NULL default '0',
	2236	`text` longtext NOT NULL,
	2237	`next_page` mediumint(8) unsigned NOT NULL default '0',
	2238	PRIMARY KEY (`entry`)
[45]	2239	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Item System';
[37]	2240
[45]	2241	--
	2242	-- Dumping data for table `page_text`
	2243	--
[37]	2244
[45]	2245	LOCK TABLES `page_text` WRITE;
	2246	/!40000 ALTER TABLE `page_text` DISABLE KEYS /;
	2247	/!40000 ALTER TABLE `page_text` ENABLE KEYS /;
	2248	UNLOCK TABLES;
[37]	2249
[45]	2250	--
	2251	-- Table structure for table `pet_levelstats`
	2252	--
	2253
[37]	2254	DROP TABLE IF EXISTS `pet_levelstats`;
	2255	CREATE TABLE `pet_levelstats` (
	2256	`creature_entry` mediumint(8) unsigned NOT NULL,
	2257	`level` tinyint(3) unsigned NOT NULL,
	2258	`hp` smallint(5) unsigned NOT NULL,
	2259	`mana` smallint(5) unsigned NOT NULL,
	2260	`armor` int(10) unsigned NOT NULL default '0',
	2261	`str` smallint(5) unsigned NOT NULL,
	2262	`agi` smallint(5) unsigned NOT NULL,
	2263	`sta` smallint(5) unsigned NOT NULL,
	2264	`inte` smallint(5) unsigned NOT NULL,
	2265	`spi` smallint(5) unsigned NOT NULL,
	2266	PRIMARY KEY (`creature_entry`,`level`)
	2267	) ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0 COMMENT='Stores pet levels stats.';
	2268
[45]	2269	--
	2270	-- Dumping data for table `pet_levelstats`
	2271	--
[37]	2272
[45]	2273	LOCK TABLES `pet_levelstats` WRITE;
	2274	/!40000 ALTER TABLE `pet_levelstats` DISABLE KEYS /;
	2275	/!40000 ALTER TABLE `pet_levelstats` ENABLE KEYS /;
	2276	UNLOCK TABLES;
[37]	2277
[45]	2278	--
	2279	-- Table structure for table `pet_name_generation`
	2280	--
	2281
[37]	2282	DROP TABLE IF EXISTS `pet_name_generation`;
	2283	CREATE TABLE `pet_name_generation` (
	2284	`id` mediumint(8) unsigned NOT NULL auto_increment,
	2285	`word` tinytext NOT NULL,
	2286	`entry` mediumint(8) unsigned NOT NULL default '0',
	2287	`half` tinyint(4) NOT NULL default '0',
	2288	PRIMARY KEY (`id`)
[45]	2289	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
[37]	2290
[45]	2291	--
	2292	-- Dumping data for table `pet_name_generation`
	2293	--
[37]	2294
[45]	2295	LOCK TABLES `pet_name_generation` WRITE;
	2296	/!40000 ALTER TABLE `pet_name_generation` DISABLE KEYS /;
	2297	/!40000 ALTER TABLE `pet_name_generation` ENABLE KEYS /;
	2298	UNLOCK TABLES;
[37]	2299
[45]	2300	--
	2301	-- Table structure for table `petcreateinfo_spell`
	2302	--
[37]	2303
	2304	DROP TABLE IF EXISTS `petcreateinfo_spell`;
	2305	CREATE TABLE `petcreateinfo_spell` (
	2306	`entry` mediumint(8) unsigned NOT NULL default '0',
	2307	`Spell1` mediumint(8) unsigned NOT NULL default '0',
	2308	`Spell2` mediumint(8) unsigned NOT NULL default '0',
	2309	`Spell3` mediumint(8) unsigned NOT NULL default '0',
	2310	`Spell4` mediumint(8) unsigned NOT NULL default '0',
	2311	PRIMARY KEY (`entry`)
	2312	) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Pet Create Spells';
	2313
[45]	2314	--
	2315	-- Dumping data for table `petcreateinfo_spell`
	2316	--
[37]	2317
[45]	2318	LOCK TABLES `petcreateinfo_spell` WRITE;
	2319	/!40000 ALTER TABLE `petcreateinfo_spell` DISABLE KEYS /;
	2320	/!40000 ALTER TABLE `petcreateinfo_spell` ENABLE KEYS /;
	2321	UNLOCK TABLES;
[37]	2322
[45]	2323	--
	2324	-- Table structure for table `pickpocketing_loot_template`
	2325	--
	2326
[37]	2327	DROP TABLE IF EXISTS `pickpocketing_loot_template`;
	2328	CREATE TABLE `pickpocketing_loot_template` (
	2329	`entry` mediumint(8) unsigned NOT NULL default '0',
	2330	`item` mediumint(8) unsigned NOT NULL default '0',
	2331	`ChanceOrQuestChance` float NOT NULL default '100',
	2332	`groupid` tinyint(3) unsigned NOT NULL default '0',
	2333	`mincountOrRef` mediumint(9) NOT NULL default '1',
	2334	`maxcount` tinyint(3) unsigned NOT NULL default '1',
	2335	`lootcondition` tinyint(3) unsigned NOT NULL default '0',
	2336	`condition_value1` mediumint(8) unsigned NOT NULL default '0',
	2337	`condition_value2` mediumint(8) unsigned NOT NULL default '0',
	2338	PRIMARY KEY (`entry`,`item`)
	2339	) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Loot System';
	2340
[45]	2341	--
	2342	-- Dumping data for table `pickpocketing_loot_template`
	2343	--
[37]	2344
[45]	2345	LOCK TABLES `pickpocketing_loot_template` WRITE;
	2346	/!40000 ALTER TABLE `pickpocketing_loot_template` DISABLE KEYS /;
	2347	/!40000 ALTER TABLE `pickpocketing_loot_template` ENABLE KEYS /;
	2348	UNLOCK TABLES;
[37]	2349
[45]	2350	--
	2351	-- Table structure for table `player_classlevelstats`
	2352	--
	2353
[37]	2354	DROP TABLE IF EXISTS `player_classlevelstats`;
	2355	CREATE TABLE `player_classlevelstats` (
	2356	`class` tinyint(3) unsigned NOT NULL,
	2357	`level` tinyint(3) unsigned NOT NULL,
	2358	`basehp` smallint(5) unsigned NOT NULL,
	2359	`basemana` smallint(5) unsigned NOT NULL,
	2360	PRIMARY KEY (`class`,`level`)
	2361	) ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0 COMMENT='Stores levels stats.';
	2362
[45]	2363	--
	2364	-- Dumping data for table `player_classlevelstats`
	2365	--
[37]	2366
[45]	2367	LOCK TABLES `player_classlevelstats` WRITE;
	2368	/!40000 ALTER TABLE `player_classlevelstats` DISABLE KEYS /;
	2369	/!40000 ALTER TABLE `player_classlevelstats` ENABLE KEYS /;
	2370	UNLOCK TABLES;
[37]	2371
[45]	2372	--
	2373	-- Table structure for table `player_levelstats`
	2374	--
[37]	2375
	2376	DROP TABLE IF EXISTS `player_levelstats`;
	2377	CREATE TABLE `player_levelstats` (
	2378	`race` tinyint(3) unsigned NOT NULL,
	2379	`class` tinyint(3) unsigned NOT NULL,
	2380	`level` tinyint(3) unsigned NOT NULL,
	2381	`str` tinyint(3) unsigned NOT NULL,
	2382	`agi` tinyint(3) unsigned NOT NULL,
	2383	`sta` tinyint(3) unsigned NOT NULL,
	2384	`inte` tinyint(3) unsigned NOT NULL,
	2385	`spi` tinyint(3) unsigned NOT NULL,
	2386	PRIMARY KEY (`race`,`class`,`level`)
	2387	) ENGINE=MyISAM DEFAULT CHARSET=utf8 PACK_KEYS=0 COMMENT='Stores levels stats.';
	2388
[45]	2389	--
	2390	-- Dumping data for table `player_levelstats`
	2391	--
[37]	2392
[45]	2393	LOCK TABLES `player_levelstats` WRITE;
	2394	/!40000 ALTER TABLE `player_levelstats` DISABLE KEYS /;
	2395	/!40000 ALTER TABLE `player_levelstats` ENABLE KEYS /;
	2396	UNLOCK TABLES;
[37]	2397
[45]	2398	--
	2399	-- Table structure for table `playercreateinfo`
	2400	--
[37]	2401
	2402	DROP TABLE IF EXISTS `playercreateinfo`;
	2403	CREATE TABLE `playercreateinfo` (
	2404	`race` tinyint(3) unsigned NOT NULL default '0',
	2405	`class` tinyint(3) unsigned NOT NULL default '0',
	2406	`map` smallint(5) unsigned NOT NULL default '0',
	2407	`zone` mediumint(8) unsigned NOT NULL default '0',
	2408	`position_x` float NOT NULL default '0',
	2409	`position_y` float NOT NULL default '0',
	2410	`position_z` float NOT NULL default '0',
	2411	PRIMARY KEY (`race`,`class`)
	2412	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	2413
[45]	2414	--
	2415	-- Dumping data for table `playercreateinfo`
	2416	--
[37]	2417
[45]	2418	LOCK TABLES `playercreateinfo` WRITE;
	2419	/!40000 ALTER TABLE `playercreateinfo` DISABLE KEYS /;
	2420	/!40000 ALTER TABLE `playercreateinfo` ENABLE KEYS /;
	2421	UNLOCK TABLES;
[37]	2422
[45]	2423	--
	2424	-- Table structure for table `playercreateinfo_action`
	2425	--
[37]	2426
	2427	DROP TABLE IF EXISTS `playercreateinfo_action`;
	2428	CREATE TABLE `playercreateinfo_action` (
	2429	`race` tinyint(3) unsigned NOT NULL default '0',
	2430	`class` tinyint(3) unsigned NOT NULL default '0',
	2431	`button` smallint(5) unsigned NOT NULL default '0',
	2432	`action` smallint(5) unsigned NOT NULL default '0',
	2433	`type` smallint(5) unsigned NOT NULL default '0',
	2434	`misc` smallint(5) unsigned NOT NULL default '0',
	2435	KEY `playercreateinfo_race_class_index` (`race`,`class`)
	2436	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	2437
[45]	2438	--
	2439	-- Dumping data for table `playercreateinfo_action`
	2440	--
[37]	2441
[45]	2442	LOCK TABLES `playercreateinfo_action` WRITE;
	2443	/!40000 ALTER TABLE `playercreateinfo_action` DISABLE KEYS /;
	2444	/!40000 ALTER TABLE `playercreateinfo_action` ENABLE KEYS /;
	2445	UNLOCK TABLES;
[37]	2446
[45]	2447	--
	2448	-- Table structure for table `playercreateinfo_item`
	2449	--
[37]	2450
	2451	DROP TABLE IF EXISTS `playercreateinfo_item`;
	2452	CREATE TABLE `playercreateinfo_item` (
	2453	`race` tinyint(3) unsigned NOT NULL default '0',
	2454	`class` tinyint(3) unsigned NOT NULL default '0',
	2455	`itemid` mediumint(8) unsigned NOT NULL default '0',
	2456	`amount` tinyint(3) unsigned NOT NULL default '1',
	2457	KEY `playercreateinfo_race_class_index` (`race`,`class`)
	2458	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	2459
[45]	2460	--
	2461	-- Dumping data for table `playercreateinfo_item`
	2462	--
[37]	2463
[45]	2464	LOCK TABLES `playercreateinfo_item` WRITE;
	2465	/!40000 ALTER TABLE `playercreateinfo_item` DISABLE KEYS /;
	2466	/!40000 ALTER TABLE `playercreateinfo_item` ENABLE KEYS /;
	2467	UNLOCK TABLES;
[37]	2468
[45]	2469	--
	2470	-- Table structure for table `playercreateinfo_spell`
	2471	--
[37]	2472
	2473	DROP TABLE IF EXISTS `playercreateinfo_spell`;
	2474	CREATE TABLE `playercreateinfo_spell` (
	2475	`race` tinyint(3) unsigned NOT NULL default '0',
	2476	`class` tinyint(3) unsigned NOT NULL default '0',
	2477	`Spell` mediumint(8) unsigned NOT NULL default '0',
	2478	`Note` varchar(255) default NULL,
	2479	`Active` tinyint(3) unsigned NOT NULL default '1',
	2480	PRIMARY KEY (`race`,`class`,`Spell`)
	2481	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	2482
[45]	2483	--
	2484	-- Dumping data for table `playercreateinfo_spell`
	2485	--
[37]	2486
[45]	2487	LOCK TABLES `playercreateinfo_spell` WRITE;
	2488	/!40000 ALTER TABLE `playercreateinfo_spell` DISABLE KEYS /;
	2489	/!40000 ALTER TABLE `playercreateinfo_spell` ENABLE KEYS /;
	2490	UNLOCK TABLES;
[37]	2491
[45]	2492	--
	2493	-- Table structure for table `playercreateinfo_spell_custom`
	2494	--
[37]	2495
[39]	2496	DROP TABLE IF EXISTS `playercreateinfo_spell_custom`;
	2497	CREATE TABLE `playercreateinfo_spell_custom` (
	2498	`race` tinyint(3) unsigned NOT NULL default '0',
	2499	`class` tinyint(3) unsigned NOT NULL default '0',
	2500	`Spell` mediumint(8) unsigned NOT NULL default '0',
	2501	`Note` varchar(255) default NULL,
	2502	`Active` tinyint(3) unsigned NOT NULL default '1',
	2503	PRIMARY KEY (`race`,`class`,`Spell`)
	2504	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	2505
[45]	2506	--
	2507	-- Dumping data for table `playercreateinfo_spell_custom`
	2508	--
[39]	2509
[45]	2510	LOCK TABLES `playercreateinfo_spell_custom` WRITE;
	2511	/!40000 ALTER TABLE `playercreateinfo_spell_custom` DISABLE KEYS /;
	2512	/!40000 ALTER TABLE `playercreateinfo_spell_custom` ENABLE KEYS /;
	2513	UNLOCK TABLES;
[39]	2514
[45]	2515	--
	2516	-- Table structure for table `prospecting_loot_template`
	2517	--
[39]	2518
[37]	2519	DROP TABLE IF EXISTS `prospecting_loot_template`;
	2520	CREATE TABLE `prospecting_loot_template` (
	2521	`entry` mediumint(8) unsigned NOT NULL default '0',
	2522	`item` mediumint(8) unsigned NOT NULL default '0',
	2523	`ChanceOrQuestChance` float NOT NULL default '100',
	2524	`groupid` tinyint(3) unsigned NOT NULL default '0',
	2525	`mincountOrRef` mediumint(9) NOT NULL default '1',
	2526	`maxcount` tinyint(3) unsigned NOT NULL default '1',
	2527	`lootcondition` tinyint(3) unsigned NOT NULL default '0',
	2528	`condition_value1` mediumint(8) unsigned NOT NULL default '0',
	2529	`condition_value2` mediumint(8) unsigned NOT NULL default '0',
	2530	PRIMARY KEY (`entry`,`item`)
	2531	) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Loot System';
	2532
[45]	2533	--
	2534	-- Dumping data for table `prospecting_loot_template`
	2535	--
[37]	2536
[45]	2537	LOCK TABLES `prospecting_loot_template` WRITE;
	2538	/!40000 ALTER TABLE `prospecting_loot_template` DISABLE KEYS /;
	2539	/!40000 ALTER TABLE `prospecting_loot_template` ENABLE KEYS /;
	2540	UNLOCK TABLES;
[37]	2541
[45]	2542	--
	2543	-- Table structure for table `quest_end_scripts`
	2544	--
	2545
[37]	2546	DROP TABLE IF EXISTS `quest_end_scripts`;
	2547	CREATE TABLE `quest_end_scripts` (
	2548	`id` mediumint(8) unsigned NOT NULL default '0',
	2549	`delay` int(10) unsigned NOT NULL default '0',
	2550	`command` mediumint(8) unsigned NOT NULL default '0',
	2551	`datalong` mediumint(8) unsigned NOT NULL default '0',
	2552	`datalong2` int(10) unsigned NOT NULL default '0',
	2553	`datatext` text NOT NULL,
	2554	`x` float NOT NULL default '0',
	2555	`y` float NOT NULL default '0',
	2556	`z` float NOT NULL default '0',
	2557	`o` float NOT NULL default '0'
	2558	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	2559
[45]	2560	--
	2561	-- Dumping data for table `quest_end_scripts`
	2562	--
[37]	2563
[45]	2564	LOCK TABLES `quest_end_scripts` WRITE;
	2565	/!40000 ALTER TABLE `quest_end_scripts` DISABLE KEYS /;
	2566	/!40000 ALTER TABLE `quest_end_scripts` ENABLE KEYS /;
	2567	UNLOCK TABLES;
[37]	2568
[45]	2569	--
	2570	-- Table structure for table `quest_mail_loot_template`
	2571	--
	2572
[37]	2573	DROP TABLE IF EXISTS `quest_mail_loot_template`;
	2574	CREATE TABLE `quest_mail_loot_template` (
	2575	`entry` mediumint(8) unsigned NOT NULL default '0',
	2576	`item` mediumint(8) unsigned NOT NULL default '0',
	2577	`ChanceOrQuestChance` float NOT NULL default '100',
	2578	`groupid` tinyint(3) unsigned NOT NULL default '0',
	2579	`mincountOrRef` mediumint(9) NOT NULL default '1',
	2580	`maxcount` tinyint(3) unsigned NOT NULL default '1',
	2581	`lootcondition` tinyint(3) unsigned NOT NULL default '0',
	2582	`condition_value1` mediumint(8) unsigned NOT NULL default '0',
	2583	`condition_value2` mediumint(8) unsigned NOT NULL default '0',
	2584	PRIMARY KEY (`entry`,`item`)
	2585	) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Loot System';
	2586
[45]	2587	--
	2588	-- Dumping data for table `quest_mail_loot_template`
	2589	--
[37]	2590
[45]	2591	LOCK TABLES `quest_mail_loot_template` WRITE;
	2592	/!40000 ALTER TABLE `quest_mail_loot_template` DISABLE KEYS /;
	2593	/!40000 ALTER TABLE `quest_mail_loot_template` ENABLE KEYS /;
	2594	UNLOCK TABLES;
[37]	2595
[45]	2596	--
	2597	-- Table structure for table `quest_start_scripts`
	2598	--
	2599
[39]	2600	DROP TABLE IF EXISTS `quest_start_scripts`;
	2601	CREATE TABLE `quest_start_scripts` (
	2602	`id` mediumint(8) unsigned NOT NULL default '0',
	2603	`delay` int(10) unsigned NOT NULL default '0',
	2604	`command` mediumint(8) unsigned NOT NULL default '0',
	2605	`datalong` mediumint(8) unsigned NOT NULL default '0',
	2606	`datalong2` int(10) unsigned NOT NULL default '0',
	2607	`datatext` text NOT NULL,
	2608	`x` float NOT NULL default '0',
	2609	`y` float NOT NULL default '0',
	2610	`z` float NOT NULL default '0',
	2611	`o` float NOT NULL default '0'
	2612	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	2613
[45]	2614	--
	2615	-- Dumping data for table `quest_start_scripts`
	2616	--
[39]	2617
[45]	2618	LOCK TABLES `quest_start_scripts` WRITE;
	2619	/!40000 ALTER TABLE `quest_start_scripts` DISABLE KEYS /;
	2620	/!40000 ALTER TABLE `quest_start_scripts` ENABLE KEYS /;
	2621	UNLOCK TABLES;
[39]	2622
[45]	2623	--
	2624	-- Table structure for table `quest_template`
	2625	--
	2626
[37]	2627	DROP TABLE IF EXISTS `quest_template`;
	2628	CREATE TABLE `quest_template` (
	2629	`entry` mediumint(8) unsigned NOT NULL default '0',
	2630	`Method` tinyint(3) unsigned NOT NULL default '2',
	2631	`ZoneOrSort` smallint(6) NOT NULL default '0',
	2632	`SkillOrClass` smallint(6) NOT NULL default '0',
	2633	`MinLevel` tinyint(3) unsigned NOT NULL default '0',
	2634	`QuestLevel` tinyint(3) unsigned NOT NULL default '0',
	2635	`Type` smallint(5) unsigned NOT NULL default '0',
	2636	`RequiredRaces` smallint(5) unsigned NOT NULL default '0',
	2637	`RequiredSkillValue` smallint(5) unsigned NOT NULL default '0',
	2638	`RepObjectiveFaction` smallint(5) unsigned NOT NULL default '0',
	2639	`RepObjectiveValue` mediumint(9) NOT NULL default '0',
	2640	`RequiredMinRepFaction` smallint(5) unsigned NOT NULL default '0',
	2641	`RequiredMinRepValue` mediumint(9) NOT NULL default '0',
	2642	`RequiredMaxRepFaction` smallint(5) unsigned NOT NULL default '0',
	2643	`RequiredMaxRepValue` mediumint(9) NOT NULL default '0',
	2644	`SuggestedPlayers` tinyint(3) unsigned NOT NULL default '0',
	2645	`LimitTime` int(10) unsigned NOT NULL default '0',
	2646	`QuestFlags` smallint(5) unsigned NOT NULL default '0',
	2647	`SpecialFlags` tinyint(3) unsigned NOT NULL default '0',
	2648	`CharTitleId` tinyint(3) unsigned NOT NULL default '0',
	2649	`PrevQuestId` mediumint(9) NOT NULL default '0',
	2650	`NextQuestId` mediumint(9) NOT NULL default '0',
	2651	`ExclusiveGroup` mediumint(9) NOT NULL default '0',
	2652	`NextQuestInChain` mediumint(8) unsigned NOT NULL default '0',
	2653	`SrcItemId` mediumint(8) unsigned NOT NULL default '0',
	2654	`SrcItemCount` tinyint(3) unsigned NOT NULL default '0',
	2655	`SrcSpell` mediumint(8) unsigned NOT NULL default '0',
	2656	`Title` text,
	2657	`Details` text,
	2658	`Objectives` text,
	2659	`OfferRewardText` text,
	2660	`RequestItemsText` text,
	2661	`EndText` text,
	2662	`ObjectiveText1` text,
	2663	`ObjectiveText2` text,
	2664	`ObjectiveText3` text,
	2665	`ObjectiveText4` text,
	2666	`ReqItemId1` mediumint(8) unsigned NOT NULL default '0',
	2667	`ReqItemId2` mediumint(8) unsigned NOT NULL default '0',
	2668	`ReqItemId3` mediumint(8) unsigned NOT NULL default '0',
	2669	`ReqItemId4` mediumint(8) unsigned NOT NULL default '0',
	2670	`ReqItemCount1` smallint(5) unsigned NOT NULL default '0',
	2671	`ReqItemCount2` smallint(5) unsigned NOT NULL default '0',
	2672	`ReqItemCount3` smallint(5) unsigned NOT NULL default '0',
	2673	`ReqItemCount4` smallint(5) unsigned NOT NULL default '0',
	2674	`ReqSourceId1` mediumint(8) unsigned NOT NULL default '0',
	2675	`ReqSourceId2` mediumint(8) unsigned NOT NULL default '0',
	2676	`ReqSourceId3` mediumint(8) unsigned NOT NULL default '0',
	2677	`ReqSourceId4` mediumint(8) unsigned NOT NULL default '0',
	2678	`ReqSourceCount1` smallint(5) unsigned NOT NULL default '0',
	2679	`ReqSourceCount2` smallint(5) unsigned NOT NULL default '0',
	2680	`ReqSourceCount3` smallint(5) unsigned NOT NULL default '0',
	2681	`ReqSourceCount4` smallint(5) unsigned NOT NULL default '0',
	2682	`ReqSourceRef1` tinyint(3) unsigned NOT NULL default '0',
	2683	`ReqSourceRef2` tinyint(3) unsigned NOT NULL default '0',
	2684	`ReqSourceRef3` tinyint(3) unsigned NOT NULL default '0',
	2685	`ReqSourceRef4` tinyint(3) unsigned NOT NULL default '0',
	2686	`ReqCreatureOrGOId1` mediumint(9) NOT NULL default '0',
	2687	`ReqCreatureOrGOId2` mediumint(9) NOT NULL default '0',
	2688	`ReqCreatureOrGOId3` mediumint(9) NOT NULL default '0',
	2689	`ReqCreatureOrGOId4` mediumint(9) NOT NULL default '0',
	2690	`ReqCreatureOrGOCount1` smallint(5) unsigned NOT NULL default '0',
	2691	`ReqCreatureOrGOCount2` smallint(5) unsigned NOT NULL default '0',
	2692	`ReqCreatureOrGOCount3` smallint(5) unsigned NOT NULL default '0',
	2693	`ReqCreatureOrGOCount4` smallint(5) unsigned NOT NULL default '0',
	2694	`ReqSpellCast1` mediumint(8) unsigned NOT NULL default '0',
	2695	`ReqSpellCast2` mediumint(8) unsigned NOT NULL default '0',
	2696	`ReqSpellCast3` mediumint(8) unsigned NOT NULL default '0',
	2697	`ReqSpellCast4` mediumint(8) unsigned NOT NULL default '0',
	2698	`RewChoiceItemId1` mediumint(8) unsigned NOT NULL default '0',
	2699	`RewChoiceItemId2` mediumint(8) unsigned NOT NULL default '0',
	2700	`RewChoiceItemId3` mediumint(8) unsigned NOT NULL default '0',
	2701	`RewChoiceItemId4` mediumint(8) unsigned NOT NULL default '0',
	2702	`RewChoiceItemId5` mediumint(8) unsigned NOT NULL default '0',
	2703	`RewChoiceItemId6` mediumint(8) unsigned NOT NULL default '0',
	2704	`RewChoiceItemCount1` smallint(5) unsigned NOT NULL default '0',
	2705	`RewChoiceItemCount2` smallint(5) unsigned NOT NULL default '0',
	2706	`RewChoiceItemCount3` smallint(5) unsigned NOT NULL default '0',
	2707	`RewChoiceItemCount4` smallint(5) unsigned NOT NULL default '0',
	2708	`RewChoiceItemCount5` smallint(5) unsigned NOT NULL default '0',
	2709	`RewChoiceItemCount6` smallint(5) unsigned NOT NULL default '0',
	2710	`RewItemId1` mediumint(8) unsigned NOT NULL default '0',
	2711	`RewItemId2` mediumint(8) unsigned NOT NULL default '0',
	2712	`RewItemId3` mediumint(8) unsigned NOT NULL default '0',
	2713	`RewItemId4` mediumint(8) unsigned NOT NULL default '0',
	2714	`RewItemCount1` smallint(5) unsigned NOT NULL default '0',
	2715	`RewItemCount2` smallint(5) unsigned NOT NULL default '0',
	2716	`RewItemCount3` smallint(5) unsigned NOT NULL default '0',
	2717	`RewItemCount4` smallint(5) unsigned NOT NULL default '0',
	2718	`RewRepFaction1` smallint(5) unsigned NOT NULL default '0' COMMENT 'faction id from Faction.dbc in this case',
	2719	`RewRepFaction2` smallint(5) unsigned NOT NULL default '0' COMMENT 'faction id from Faction.dbc in this case',
	2720	`RewRepFaction3` smallint(5) unsigned NOT NULL default '0' COMMENT 'faction id from Faction.dbc in this case',
	2721	`RewRepFaction4` smallint(5) unsigned NOT NULL default '0' COMMENT 'faction id from Faction.dbc in this case',
	2722	`RewRepFaction5` smallint(5) unsigned NOT NULL default '0' COMMENT 'faction id from Faction.dbc in this case',
	2723	`RewRepValue1` mediumint(9) NOT NULL default '0',
	2724	`RewRepValue2` mediumint(9) NOT NULL default '0',
	2725	`RewRepValue3` mediumint(9) NOT NULL default '0',
	2726	`RewRepValue4` mediumint(9) NOT NULL default '0',
	2727	`RewRepValue5` mediumint(9) NOT NULL default '0',
[97]	2728	`RewHonorableKills` mediumint(9) unsigned NOT NULL default '0',
[37]	2729	`RewOrReqMoney` int(11) NOT NULL default '0',
	2730	`RewMoneyMaxLevel` int(10) unsigned NOT NULL default '0',
	2731	`RewSpell` mediumint(8) unsigned NOT NULL default '0',
	2732	`RewSpellCast` mediumint(8) unsigned NOT NULL default '0',
	2733	`RewMailTemplateId` mediumint(8) unsigned NOT NULL default '0',
	2734	`RewMailDelaySecs` int(11) unsigned NOT NULL default '0',
	2735	`PointMapId` smallint(5) unsigned NOT NULL default '0',
	2736	`PointX` float NOT NULL default '0',
	2737	`PointY` float NOT NULL default '0',
	2738	`PointOpt` mediumint(8) unsigned NOT NULL default '0',
	2739	`DetailsEmote1` smallint(5) unsigned NOT NULL default '0',
	2740	`DetailsEmote2` smallint(5) unsigned NOT NULL default '0',
	2741	`DetailsEmote3` smallint(5) unsigned NOT NULL default '0',
	2742	`DetailsEmote4` smallint(5) unsigned NOT NULL default '0',
	2743	`IncompleteEmote` smallint(5) unsigned NOT NULL default '0',
	2744	`CompleteEmote` smallint(5) unsigned NOT NULL default '0',
	2745	`OfferRewardEmote1` smallint(5) unsigned NOT NULL default '0',
	2746	`OfferRewardEmote2` smallint(5) unsigned NOT NULL default '0',
	2747	`OfferRewardEmote3` smallint(5) unsigned NOT NULL default '0',
	2748	`OfferRewardEmote4` smallint(5) unsigned NOT NULL default '0',
	2749	`StartScript` mediumint(8) unsigned NOT NULL default '0',
	2750	`CompleteScript` mediumint(8) unsigned NOT NULL default '0',
	2751	PRIMARY KEY (`entry`)
	2752	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Quest System';
	2753
[45]	2754	--
	2755	-- Dumping data for table `quest_template`
	2756	--
[37]	2757
[45]	2758	LOCK TABLES `quest_template` WRITE;
	2759	/!40000 ALTER TABLE `quest_template` DISABLE KEYS /;
	2760	/!40000 ALTER TABLE `quest_template` ENABLE KEYS /;
	2761	UNLOCK TABLES;
[37]	2762
[45]	2763	--
	2764	-- Table structure for table `reference_loot_template`
	2765	--
	2766
[37]	2767	DROP TABLE IF EXISTS `reference_loot_template`;
	2768	CREATE TABLE `reference_loot_template` (
	2769	`entry` mediumint(8) unsigned NOT NULL default '0',
	2770	`item` mediumint(8) unsigned NOT NULL default '0',
	2771	`ChanceOrQuestChance` float NOT NULL default '100',
	2772	`groupid` tinyint(3) unsigned NOT NULL default '0',
	2773	`mincountOrRef` mediumint(9) NOT NULL default '1',
	2774	`maxcount` tinyint(3) unsigned NOT NULL default '1',
	2775	`lootcondition` tinyint(3) unsigned NOT NULL default '0',
	2776	`condition_value1` mediumint(8) unsigned NOT NULL default '0',
	2777	`condition_value2` mediumint(8) unsigned NOT NULL default '0',
	2778	PRIMARY KEY (`entry`,`item`)
	2779	) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Loot System';
	2780
[45]	2781	--
	2782	-- Dumping data for table `reference_loot_template`
	2783	--
[37]	2784
[45]	2785	LOCK TABLES `reference_loot_template` WRITE;
	2786	/!40000 ALTER TABLE `reference_loot_template` DISABLE KEYS /;
	2787	/!40000 ALTER TABLE `reference_loot_template` ENABLE KEYS /;
	2788	UNLOCK TABLES;
[37]	2789
[45]	2790	--
	2791	-- Table structure for table `reserved_name`
	2792	--
	2793
[37]	2794	DROP TABLE IF EXISTS `reserved_name`;
	2795	CREATE TABLE `reserved_name` (
	2796	`name` varchar(12) NOT NULL default '',
	2797	PRIMARY KEY (`name`)
	2798	) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Player Reserved Names';
	2799
[45]	2800	--
	2801	-- Dumping data for table `reserved_name`
	2802	--
[37]	2803
[45]	2804	LOCK TABLES `reserved_name` WRITE;
	2805	/!40000 ALTER TABLE `reserved_name` DISABLE KEYS /;
	2806	/!40000 ALTER TABLE `reserved_name` ENABLE KEYS /;
	2807	UNLOCK TABLES;
[37]	2808
[45]	2809	--
	2810	-- Table structure for table `script_db_version`
	2811	--
	2812
	2813	DROP TABLE IF EXISTS `script_db_version`;
	2814	CREATE TABLE `script_db_version` (
	2815	`version` varchar(255) NOT NULL default '' COMMENT 'Database version string'
	2816	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	2817
	2818	--
	2819	-- Dumping data for table `script_db_version`
	2820	--
	2821
	2822	LOCK TABLES `script_db_version` WRITE;
	2823	/!40000 ALTER TABLE `script_db_version` DISABLE KEYS /;
	2824	/!40000 ALTER TABLE `script_db_version` ENABLE KEYS /;
	2825	UNLOCK TABLES;
	2826
	2827	--
	2828	-- Table structure for table `script_texts`
	2829	--
	2830
	2831	DROP TABLE IF EXISTS `script_texts`;
	2832	CREATE TABLE `script_texts` (
	2833	`entry` mediumint(8) NOT NULL,
	2834	`content_default` text NOT NULL,
	2835	`content_loc1` text,
	2836	`content_loc2` text,
	2837	`content_loc3` text,
	2838	`content_loc4` text,
	2839	`content_loc5` text,
	2840	`content_loc6` text,
	2841	`content_loc7` text,
	2842	`content_loc8` text,
	2843	`sound` tinyint(3) unsigned NOT NULL default '0',
	2844	`type` tinyint(3) unsigned NOT NULL default '0',
	2845	`language` tinyint(3) unsigned NOT NULL default '0',
	2846	`comment` text,
	2847	PRIMARY KEY (`entry`)
	2848	) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Script Texts';
	2849
	2850	--
	2851	-- Dumping data for table `script_texts`
	2852	--
	2853
	2854	LOCK TABLES `script_texts` WRITE;
	2855	/!40000 ALTER TABLE `script_texts` DISABLE KEYS /;
	2856	/!40000 ALTER TABLE `script_texts` ENABLE KEYS /;
	2857	UNLOCK TABLES;
	2858
	2859	--
	2860	-- Table structure for table `skill_discovery_template`
	2861	--
	2862
[37]	2863	DROP TABLE IF EXISTS `skill_discovery_template`;
	2864	CREATE TABLE `skill_discovery_template` (
	2865	`spellId` mediumint(8) unsigned NOT NULL default '0' COMMENT 'SpellId of the discoverable spell',
	2866	`reqSpell` mediumint(8) unsigned NOT NULL default '0' COMMENT 'spell requirement',
	2867	`chance` float NOT NULL default '0' COMMENT 'chance to discover',
	2868	PRIMARY KEY (`spellId`)
	2869	) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Skill Discovery System';
	2870
[45]	2871	--
	2872	-- Dumping data for table `skill_discovery_template`
	2873	--
[37]	2874
[45]	2875	LOCK TABLES `skill_discovery_template` WRITE;
	2876	/!40000 ALTER TABLE `skill_discovery_template` DISABLE KEYS /;
	2877	/!40000 ALTER TABLE `skill_discovery_template` ENABLE KEYS /;
	2878	UNLOCK TABLES;
[37]	2879
[45]	2880	--
	2881	-- Table structure for table `skill_extra_item_template`
	2882	--
	2883
[37]	2884	DROP TABLE IF EXISTS `skill_extra_item_template`;
	2885	CREATE TABLE `skill_extra_item_template` (
	2886	`spellId` mediumint(8) unsigned NOT NULL default '0' COMMENT 'SpellId of the item creation spell',
	2887	`requiredSpecialization` mediumint(8) unsigned NOT NULL default '0' COMMENT 'Specialization spell id',
	2888	`additionalCreateChance` float NOT NULL default '0' COMMENT 'chance to create add',
	2889	`additionalMaxNum` tinyint(3) unsigned NOT NULL default '0' COMMENT 'max num of adds',
	2890	PRIMARY KEY (`spellId`)
	2891	) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Skill Specialization System';
	2892
[45]	2893	--
	2894	-- Dumping data for table `skill_extra_item_template`
	2895	--
[37]	2896
[45]	2897	LOCK TABLES `skill_extra_item_template` WRITE;
	2898	/!40000 ALTER TABLE `skill_extra_item_template` DISABLE KEYS /;
	2899	/!40000 ALTER TABLE `skill_extra_item_template` ENABLE KEYS /;
	2900	UNLOCK TABLES;
[37]	2901
[45]	2902	--
	2903	-- Table structure for table `skill_fishing_base_level`
	2904	--
	2905
[37]	2906	DROP TABLE IF EXISTS `skill_fishing_base_level`;
	2907	CREATE TABLE `skill_fishing_base_level` (
	2908	`entry` mediumint(8) unsigned NOT NULL default '0' COMMENT 'Area identifier',
	2909	`skill` smallint(6) NOT NULL default '0' COMMENT 'Base skill level requirement',
	2910	PRIMARY KEY (`entry`)
	2911	) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Fishing system';
	2912
[45]	2913	--
	2914	-- Dumping data for table `skill_fishing_base_level`
	2915	--
[37]	2916
[45]	2917	LOCK TABLES `skill_fishing_base_level` WRITE;
	2918	/!40000 ALTER TABLE `skill_fishing_base_level` DISABLE KEYS /;
	2919	/!40000 ALTER TABLE `skill_fishing_base_level` ENABLE KEYS /;
	2920	UNLOCK TABLES;
[37]	2921
[45]	2922	--
	2923	-- Table structure for table `skinning_loot_template`
	2924	--
	2925
[37]	2926	DROP TABLE IF EXISTS `skinning_loot_template`;
	2927	CREATE TABLE `skinning_loot_template` (
	2928	`entry` mediumint(8) unsigned NOT NULL default '0',
	2929	`item` mediumint(8) unsigned NOT NULL default '0',
	2930	`ChanceOrQuestChance` float NOT NULL default '100',
	2931	`groupid` tinyint(3) unsigned NOT NULL default '0',
	2932	`mincountOrRef` mediumint(9) NOT NULL default '1',
	2933	`maxcount` tinyint(3) unsigned NOT NULL default '1',
	2934	`lootcondition` tinyint(3) unsigned NOT NULL default '0',
	2935	`condition_value1` mediumint(8) unsigned NOT NULL default '0',
	2936	`condition_value2` mediumint(8) unsigned NOT NULL default '0',
	2937	PRIMARY KEY (`entry`,`item`)
	2938	) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Loot System';
	2939
[45]	2940	--
	2941	-- Dumping data for table `skinning_loot_template`
	2942	--
[37]	2943
[45]	2944	LOCK TABLES `skinning_loot_template` WRITE;
	2945	/!40000 ALTER TABLE `skinning_loot_template` DISABLE KEYS /;
	2946	/!40000 ALTER TABLE `skinning_loot_template` ENABLE KEYS /;
	2947	UNLOCK TABLES;
[37]	2948
[45]	2949	--
	2950	-- Table structure for table `spell_affect`
	2951	--
	2952
[37]	2953	DROP TABLE IF EXISTS `spell_affect`;
	2954	CREATE TABLE `spell_affect` (
	2955	`entry` smallint(5) unsigned NOT NULL default '0',
	2956	`effectId` tinyint(3) unsigned NOT NULL default '0',
	2957	`SpellFamilyMask` bigint(20) unsigned NOT NULL default '0',
	2958	PRIMARY KEY (`entry`,`effectId`)
	2959	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	2960
[45]	2961	--
	2962	-- Dumping data for table `spell_affect`
	2963	--
[37]	2964
[45]	2965	LOCK TABLES `spell_affect` WRITE;
	2966	/!40000 ALTER TABLE `spell_affect` DISABLE KEYS /;
	2967	/!40000 ALTER TABLE `spell_affect` ENABLE KEYS /;
	2968	UNLOCK TABLES;
[37]	2969
[45]	2970	--
	2971	-- Table structure for table `spell_chain`
	2972	--
[37]	2973
	2974	DROP TABLE IF EXISTS `spell_chain`;
	2975	CREATE TABLE `spell_chain` (
	2976	`spell_id` mediumint(9) NOT NULL default '0',
	2977	`prev_spell` mediumint(9) NOT NULL default '0',
	2978	`first_spell` mediumint(9) NOT NULL default '0',
	2979	`rank` tinyint(4) NOT NULL default '0',
	2980	`req_spell` mediumint(9) NOT NULL default '0',
	2981	PRIMARY KEY (`spell_id`)
	2982	) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Spell Additinal Data';
	2983
[45]	2984	--
	2985	-- Dumping data for table `spell_chain`
	2986	--
[37]	2987
[45]	2988	LOCK TABLES `spell_chain` WRITE;
	2989	/!40000 ALTER TABLE `spell_chain` DISABLE KEYS /;
	2990	/!40000 ALTER TABLE `spell_chain` ENABLE KEYS /;
	2991	UNLOCK TABLES;
[37]	2992
[45]	2993	--
[85]	2994	-- Table structure for table `spell_disabled`
	2995	--
	2996
	2997	DROP TABLE IF EXISTS `spell_disabled`;
	2998	CREATE TABLE `spell_disabled` (
	2999	`entry` int(11) unsigned NOT NULL default '0' COMMENT 'Spell entry',
	3000	`disable_mask` int(8) unsigned NOT NULL default '0',
	3001	`comment` varchar(64) NOT NULL default '',
	3002	PRIMARY KEY (`entry`)
	3003	) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Disabled Spell System';
	3004
	3005	--
	3006	-- Dumping data for table `spell_disabled`
	3007	--
	3008
	3009	LOCK TABLES `spell_disabled` WRITE;
	3010	/!40000 ALTER TABLE `spell_disabled` DISABLE KEYS /;
	3011	/!40000 ALTER TABLE `spell_disabled` ENABLE KEYS /;
	3012	UNLOCK TABLES;
	3013
	3014	--
[45]	3015	-- Table structure for table `spell_elixir`
	3016	--
[37]	3017
	3018	DROP TABLE IF EXISTS `spell_elixir`;
	3019	CREATE TABLE `spell_elixir` (
	3020	`entry` int(11) unsigned NOT NULL default '0' COMMENT 'SpellId of potion',
	3021	`mask` tinyint(1) unsigned NOT NULL default '0' COMMENT 'Mask 0x1 battle 0x2 guardian 0x3 flask 0x7 unstable flasks 0xB shattrath flasks',
	3022	PRIMARY KEY (`entry`)
	3023	) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Spell System';
	3024
[45]	3025	--
	3026	-- Dumping data for table `spell_elixir`
	3027	--
[37]	3028
[45]	3029	LOCK TABLES `spell_elixir` WRITE;
	3030	/!40000 ALTER TABLE `spell_elixir` DISABLE KEYS /;
	3031	/!40000 ALTER TABLE `spell_elixir` ENABLE KEYS /;
	3032	UNLOCK TABLES;
[37]	3033
[45]	3034	--
	3035	-- Table structure for table `spell_learn_spell`
	3036	--
[37]	3037
	3038	DROP TABLE IF EXISTS `spell_learn_spell`;
	3039	CREATE TABLE `spell_learn_spell` (
	3040	`entry` smallint(5) unsigned NOT NULL default '0',
	3041	`SpellID` smallint(5) unsigned NOT NULL default '0',
	3042	PRIMARY KEY (`entry`,`SpellID`)
	3043	) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Item System';
	3044
[45]	3045	--
	3046	-- Dumping data for table `spell_learn_spell`
	3047	--
[37]	3048
[45]	3049	LOCK TABLES `spell_learn_spell` WRITE;
	3050	/!40000 ALTER TABLE `spell_learn_spell` DISABLE KEYS /;
	3051	/!40000 ALTER TABLE `spell_learn_spell` ENABLE KEYS /;
	3052	UNLOCK TABLES;
[37]	3053
[45]	3054	--
	3055	-- Table structure for table `spell_pet_auras`
	3056	--
[37]	3057
	3058	DROP TABLE IF EXISTS `spell_pet_auras`;
	3059	CREATE TABLE `spell_pet_auras` (
	3060	`spell` mediumint(8) unsigned NOT NULL COMMENT 'dummy spell id',
	3061	`pet` mediumint(8) unsigned NOT NULL default '0' COMMENT 'pet id; 0 = all',
	3062	`aura` mediumint(8) unsigned NOT NULL COMMENT 'pet aura id',
	3063	PRIMARY KEY (`spell`,`pet`)
	3064	) ENGINE=MyISAM DEFAULT CHARSET=latin1;
	3065
[45]	3066	--
	3067	-- Dumping data for table `spell_pet_auras`
	3068	--
[37]	3069
[45]	3070	LOCK TABLES `spell_pet_auras` WRITE;
	3071	/!40000 ALTER TABLE `spell_pet_auras` DISABLE KEYS /;
	3072	/!40000 ALTER TABLE `spell_pet_auras` ENABLE KEYS /;
	3073	UNLOCK TABLES;
[37]	3074
[45]	3075	--
	3076	-- Table structure for table `spell_proc_event`
	3077	--
[37]	3078
	3079	DROP TABLE IF EXISTS `spell_proc_event`;
	3080	CREATE TABLE `spell_proc_event` (
	3081	`entry` smallint(5) unsigned NOT NULL default '0',
	3082	`SchoolMask` tinyint(4) NOT NULL default '0',
	3083	`Category` smallint(6) NOT NULL default '0',
	3084	`SkillID` smallint(6) NOT NULL default '0',
	3085	`SpellFamilyName` smallint(5) unsigned NOT NULL default '0',
	3086	`SpellFamilyMask` bigint(20) unsigned NOT NULL default '0',
	3087	`procFlags` int(10) unsigned NOT NULL default '0',
	3088	`ppmRate` float NOT NULL default '0',
	3089	`cooldown` int(10) unsigned NOT NULL default '0',
	3090	PRIMARY KEY (`entry`)
	3091	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	3092
[45]	3093	--
	3094	-- Dumping data for table `spell_proc_event`
	3095	--
[37]	3096
[45]	3097	LOCK TABLES `spell_proc_event` WRITE;
	3098	/!40000 ALTER TABLE `spell_proc_event` DISABLE KEYS /;
	3099	/!40000 ALTER TABLE `spell_proc_event` ENABLE KEYS /;
	3100	UNLOCK TABLES;
[37]	3101
[45]	3102	--
	3103	-- Table structure for table `spell_script_target`
	3104	--
[37]	3105
	3106	DROP TABLE IF EXISTS `spell_script_target`;
	3107	CREATE TABLE `spell_script_target` (
	3108	`entry` mediumint(8) unsigned NOT NULL,
	3109	`type` tinyint(3) unsigned NOT NULL default '0',
	3110	`targetEntry` mediumint(8) unsigned NOT NULL default '0',
	3111	UNIQUE KEY `entry_type_target` (`entry`,`type`,`targetEntry`)
[45]	3112	) ENGINE=MyISAM DEFAULT CHARSET=utf8 COMMENT='Spell System';
[37]	3113
[45]	3114	--
	3115	-- Dumping data for table `spell_script_target`
	3116	--
[37]	3117
[45]	3118	LOCK TABLES `spell_script_target` WRITE;
	3119	/!40000 ALTER TABLE `spell_script_target` DISABLE KEYS /;
	3120	/!40000 ALTER TABLE `spell_script_target` ENABLE KEYS /;
	3121	UNLOCK TABLES;
[37]	3122
[45]	3123	--
	3124	-- Table structure for table `spell_scripts`
	3125	--
	3126
[37]	3127	DROP TABLE IF EXISTS `spell_scripts`;
	3128	CREATE TABLE `spell_scripts` (
	3129	`id` mediumint(8) unsigned NOT NULL default '0',
	3130	`delay` int(10) unsigned NOT NULL default '0',
	3131	`command` mediumint(8) unsigned NOT NULL default '0',
	3132	`datalong` mediumint(8) unsigned NOT NULL default '0',
	3133	`datalong2` int(10) unsigned NOT NULL default '0',
[45]	3134	`datatext` text character set latin1 NOT NULL,
[37]	3135	`x` float NOT NULL default '0',
	3136	`y` float NOT NULL default '0',
	3137	`z` float NOT NULL default '0',
	3138	`o` float NOT NULL default '0'
	3139	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	3140
[45]	3141	--
	3142	-- Dumping data for table `spell_scripts`
	3143	--
[37]	3144
[45]	3145	LOCK TABLES `spell_scripts` WRITE;
	3146	/!40000 ALTER TABLE `spell_scripts` DISABLE KEYS /;
	3147	/!40000 ALTER TABLE `spell_scripts` ENABLE KEYS /;
	3148	UNLOCK TABLES;
[37]	3149
[45]	3150	--
	3151	-- Table structure for table `spell_target_position`
	3152	--
	3153
[37]	3154	DROP TABLE IF EXISTS `spell_target_position`;
	3155	CREATE TABLE `spell_target_position` (
	3156	`id` mediumint(8) unsigned NOT NULL default '0' COMMENT 'Identifier',
	3157	`target_map` smallint(5) unsigned NOT NULL default '0',
	3158	`target_position_x` float NOT NULL default '0',
	3159	`target_position_y` float NOT NULL default '0',
	3160	`target_position_z` float NOT NULL default '0',
	3161	`target_orientation` float NOT NULL default '0',
	3162	PRIMARY KEY (`id`)
	3163	) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Spell System';
	3164
[45]	3165	--
	3166	-- Dumping data for table `spell_target_position`
	3167	--
[37]	3168
[45]	3169	LOCK TABLES `spell_target_position` WRITE;
	3170	/!40000 ALTER TABLE `spell_target_position` DISABLE KEYS /;
	3171	/!40000 ALTER TABLE `spell_target_position` ENABLE KEYS /;
	3172	UNLOCK TABLES;
[37]	3173
[45]	3174	--
	3175	-- Table structure for table `spell_threat`
	3176	--
	3177
[37]	3178	DROP TABLE IF EXISTS `spell_threat`;
	3179	CREATE TABLE `spell_threat` (
	3180	`entry` mediumint(8) unsigned NOT NULL,
	3181	`Threat` smallint(6) NOT NULL,
	3182	PRIMARY KEY (`entry`)
	3183	) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED;
	3184
[45]	3185	--
	3186	-- Dumping data for table `spell_threat`
	3187	--
[37]	3188
[45]	3189	LOCK TABLES `spell_threat` WRITE;
	3190	/!40000 ALTER TABLE `spell_threat` DISABLE KEYS /;
	3191	/!40000 ALTER TABLE `spell_threat` ENABLE KEYS /;
	3192	UNLOCK TABLES;
[37]	3193
[45]	3194	--
	3195	-- Table structure for table `transports`
	3196	--
[37]	3197
	3198	DROP TABLE IF EXISTS `transports`;
	3199	CREATE TABLE `transports` (
	3200	`entry` mediumint(8) unsigned NOT NULL default '0',
	3201	`name` text,
	3202	`period` mediumint(8) unsigned NOT NULL default '0',
	3203	PRIMARY KEY (`entry`)
	3204	) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=FIXED COMMENT='Transports';
	3205
[45]	3206	--
	3207	-- Dumping data for table `transports`
	3208	--
[37]	3209
[45]	3210	LOCK TABLES `transports` WRITE;
	3211	/!40000 ALTER TABLE `transports` DISABLE KEYS /;
	3212	/!40000 ALTER TABLE `transports` ENABLE KEYS /;
	3213	UNLOCK TABLES;
[37]	3214
[45]	3215	--
	3216	-- Table structure for table `trinity_string`
	3217	--
	3218
	3219	DROP TABLE IF EXISTS `trinity_string`;
	3220	CREATE TABLE `trinity_string` (
	3221	`entry` mediumint(8) unsigned NOT NULL default '0',
	3222	`content_default` text NOT NULL,
	3223	`content_loc1` text,
	3224	`content_loc2` text,
	3225	`content_loc3` text,
	3226	`content_loc4` text,
	3227	`content_loc5` text,
	3228	`content_loc6` text,
	3229	`content_loc7` text,
	3230	`content_loc8` text,
	3231	PRIMARY KEY (`entry`)
	3232	) ENGINE=MyISAM DEFAULT CHARSET=utf8;
	3233
	3234	--
	3235	-- Dumping data for table `trinity_string`
	3236	--
	3237
	3238	LOCK TABLES `trinity_string` WRITE;
	3239	/!40000 ALTER TABLE `trinity_string` DISABLE KEYS /;
	3240	/!40000 ALTER TABLE `trinity_string` ENABLE KEYS /;
	3241	UNLOCK TABLES;
	3242
	3243	--
	3244	-- Table structure for table `uptime`
	3245	--
	3246
[37]	3247	DROP TABLE IF EXISTS `uptime`;
	3248	CREATE TABLE `uptime` (
	3249	`starttime` bigint(20) unsigned NOT NULL default '0',
	3250	`startstring` varchar(64) NOT NULL default '',
	3251	`uptime` bigint(20) unsigned NOT NULL default '0',
	3252	`maxplayers` smallint(5) unsigned NOT NULL default '0',
	3253	PRIMARY KEY (`starttime`)
	3254	) ENGINE=MyISAM DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Uptime system';
	3255
[45]	3256	--
	3257	-- Dumping data for table `uptime`
	3258	--
[37]	3259
[45]	3260	LOCK TABLES `uptime` WRITE;
	3261	/!40000 ALTER TABLE `uptime` DISABLE KEYS /;
	3262	/!40000 ALTER TABLE `uptime` ENABLE KEYS /;
	3263	UNLOCK TABLES;
	3264	/!40103 SET TIME_ZONE=@OLD_TIME_ZONE /;
	3265
[37]	3266	/!40101 SET SQL_MODE=@OLD_SQL_MODE /;
	3267	/!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS /;
[45]	3268	/!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS /;
	3269	/!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT /;
	3270	/!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS /;
	3271	/!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION /;
	3272	/!40111 SET SQL_NOTES=@OLD_SQL_NOTES /;
	3273
	3274	-- 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 @ 127

Download in other formats: