# HeidiSQL Dump 
#
# --------------------------------------------------------
# Host:                 127.0.0.1
# Database:             wcell
# Server version:       5.0.45-community-nt-log
# Server OS:            Win32
# Target-Compatibility: Same as source server (MySQL 5.0.45-community-nt-log)
# max_allowed_packet:   1048576
# HeidiSQL version:     3.2 Revision: 1129
# --------------------------------------------------------

/*!40100 SET CHARACTER SET utf8*/;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0*/;


DROP TABLE IF EXISTS `root_creature`;

#
# Table structure for table 'root_creature'
#

CREATE TABLE `root_creature` (
  `Entry` int(10) unsigned NOT NULL default '0',
  `Name` varchar(100) NOT NULL,
  `Name2` varchar(100) NOT NULL,
  `Name3` varchar(100) NOT NULL,
  `Name4` varchar(100) NOT NULL,
  `SubName` varchar(100) NOT NULL,
  `InfoSTR` varchar(500) NOT NULL,
  `Flags1` int(10) unsigned default '0',
  `Type` int(10) unsigned default '0',
  `Family` int(10) unsigned default '0',
  `Rank` int(10) unsigned default '0',
  `Unknown4` int(10) unsigned default '0',
  `SpellDataID` int(10) unsigned default NULL,
  `Displayid` int(30) NOT NULL,
  `Displayid2` int(30) NOT NULL,
  `Displayid3` int(30) NOT NULL default '0',
  `Displayid4` int(30) NOT NULL default '0',
  `UnknownFloat1` float NOT NULL default '1',
  `UnknownFloat2` float NOT NULL default '1',
  `Civilian` tinyint(3) unsigned default NULL,
  PRIMARY KEY  (`Entry`),
  UNIQUE KEY `a` (`Entry`)
) ENGINE=MyISAM /*!40100 DEFAULT CHARSET=latin1 COMMENT='Creature System'*/;



#
# Dumping data for table 'root_creature'
#

# (No data found.)



DROP TABLE IF EXISTS `root_gameobject`;

#
# Table structure for table 'root_gameobject'
#

CREATE TABLE `root_gameobject` (
  `Entry` int(10) unsigned NOT NULL default '0',
  `Type` int(10) unsigned NOT NULL default '0',
  `DisplayID` int(10) unsigned NOT NULL default '0',
  `Name` varchar(100) NOT NULL,
  `Name2` varchar(100) NOT NULL,
  `Name3` varchar(100) NOT NULL,
  `Name4` varchar(100) NOT NULL,
  `Spellfocus` int(10) unsigned NOT NULL default '0',
  `Sound1` int(10) unsigned NOT NULL default '0',
  `Sound2` int(10) unsigned NOT NULL default '0',
  `Sound3` int(10) unsigned NOT NULL default '0',
  `Sound4` int(10) unsigned NOT NULL default '0',
  `Sound5` int(10) unsigned NOT NULL default '0',
  `Sound6` int(10) unsigned NOT NULL default '0',
  `Sound7` int(10) unsigned NOT NULL default '0',
  `Sound8` int(10) unsigned NOT NULL default '0',
  `Sound9` int(10) unsigned NOT NULL default '0',
  UNIQUE KEY `entry` (`Entry`)
) ENGINE=MyISAM /*!40100 DEFAULT CHARSET=latin1 COMMENT='Gameobject System'*/;



#
# Dumping data for table 'root_gameobject'
#

# (No data found.)



DROP TABLE IF EXISTS `root_itemname`;

#
# Table structure for table 'root_itemname'
#

CREATE TABLE `root_itemname` (
  `itemID` int(10) unsigned default NULL,
  `entryLength` int(10) unsigned default NULL,
  `name` char(50) default NULL,
  `Unknown` int(10) unsigned default NULL
) ENGINE=MyISAM /*!40100 DEFAULT CHARSET=utf8*/;



#
# Dumping data for table 'root_itemname'
#

# (No data found.)



DROP TABLE IF EXISTS `root_items`;

#
# Table structure for table 'root_items'
#

CREATE TABLE `root_items` (
  `itemID` int(11) NOT NULL default '0',
  `entryLength` int(11) NOT NULL default '0',
  `itemClassID` int(11) NOT NULL default '0',
  `itemSubClassID` int(11) NOT NULL default '0',
  `Unknown1` float NOT NULL default '0',
  `name1` varchar(255) collate latin1_general_ci NOT NULL default '0',
  `name2` varchar(255) collate latin1_general_ci NOT NULL default '0',
  `name3` varchar(255) collate latin1_general_ci NOT NULL default '0',
  `name4` varchar(255) collate latin1_general_ci NOT NULL default '0',
  `itemdisplayID` int(11) NOT NULL default '0',
  `qualityID` float NOT NULL default '0',
  `typeBinFlag` float NOT NULL default '0',
  `buyPrice` float NOT NULL default '0',
  `sellPrice` float NOT NULL default '0',
  `inventorySlotID` float NOT NULL default '0',
  `classBinFlag` float NOT NULL default '0',
  `raceBinFlag` float NOT NULL default '0',
  `itemLevel` float NOT NULL default '0',
  `requiredLevel` float NOT NULL default '0',
  `requiredSkillID` float NOT NULL default '0',
  `requiredSkillLevel` float NOT NULL default '0',
  `requiredSpellID` float NOT NULL default '0',
  `requiredRankID` float NOT NULL default '0',
  `requiredUnknownRank` float NOT NULL default '0',
  `requiredFactionID` float NOT NULL default '0',
  `requiredFactionLevel` float NOT NULL default '0',
  `stackUnique` float NOT NULL default '0',
  `stackAmount` float NOT NULL default '0',
  `containerSlots` float NOT NULL default '0',
  `stat1ID` float NOT NULL default '0',
  `stat1Value` float NOT NULL default '0',
  `stat2ID` float NOT NULL default '0',
  `stat2Value` float NOT NULL default '0',
  `stat3ID` float NOT NULL default '0',
  `stat3Value` float NOT NULL default '0',
  `stat4ID` float NOT NULL default '0',
  `stat4Value` float NOT NULL default '0',
  `stat5ID` float NOT NULL default '0',
  `stat5Value` float NOT NULL default '0',
  `stat6ID` float NOT NULL default '0',
  `stat6Value` float NOT NULL default '0',
  `stat7ID` float NOT NULL default '0',
  `stat7Value` float NOT NULL default '0',
  `stat8ID` float NOT NULL default '0',
  `stat8Value` float NOT NULL default '0',
  `stat9ID` float NOT NULL default '0',
  `stat9Value` float NOT NULL default '0',
  `stat10ID` float NOT NULL default '0',
  `stat10Value` float NOT NULL default '0',
  `damage1Min` float NOT NULL default '0',
  `damage1Max` float NOT NULL default '0',
  `damage1TypeID` float NOT NULL default '0',
  `damage2Min` float NOT NULL default '0',
  `damage2Max` float NOT NULL default '0',
  `damage2TypeID` float NOT NULL default '0',
  `damage3Min` float NOT NULL default '0',
  `damage3Max` float NOT NULL default '0',
  `damage3TypeID` float NOT NULL default '0',
  `damage4Min` float NOT NULL default '0',
  `damage4Max` float NOT NULL default '0',
  `damage4TypeID` float NOT NULL default '0',
  `damage5Min` float NOT NULL default '0',
  `damage5Max` float NOT NULL default '0',
  `damage5TypeID` float NOT NULL default '0',
  `resistPhysical` float NOT NULL default '0',
  `resistHoly` float NOT NULL default '0',
  `resistFire` float NOT NULL default '0',
  `resistNature` float NOT NULL default '0',
  `resistFrost` float NOT NULL default '0',
  `resistShadow` float NOT NULL default '0',
  `resistArcane` float NOT NULL default '0',
  `weaponDelay` float NOT NULL default '0',
  `ammoType` float NOT NULL default '0',
  `rangeModifier` float NOT NULL default '0',
  `spell1ID` float NOT NULL default '0',
  `spell1TriggerID` float NOT NULL default '0',
  `spell1Charges` float NOT NULL default '0',
  `spell1Cooldown` float NOT NULL default '0',
  `spell1CategoryID` float NOT NULL default '0',
  `spell1CategoryCooldown` float NOT NULL default '0',
  `spell2ID` float NOT NULL default '0',
  `spell2TriggerID` float NOT NULL default '0',
  `spell2Charges` float NOT NULL default '0',
  `spell2Cooldown` float NOT NULL default '0',
  `spell2CategoryID` float NOT NULL default '0',
  `spell2CategoryCooldown` float NOT NULL default '0',
  `spell3ID` float NOT NULL default '0',
  `spell3TriggerID` float NOT NULL default '0',
  `spell3Charges` float NOT NULL default '0',
  `spell3Cooldown` float NOT NULL default '0',
  `spell3CategoryID` float NOT NULL default '0',
  `spell3CategoryCooldown` float NOT NULL default '0',
  `spell4ID` float NOT NULL default '0',
  `spell4TriggerID` float NOT NULL default '0',
  `spell4Charges` float NOT NULL default '0',
  `spell4Cooldown` float NOT NULL default '0',
  `spell4CategoryID` float NOT NULL default '0',
  `spell4CategoryCooldown` float NOT NULL default '0',
  `spell5ID` float NOT NULL default '0',
  `spell5TriggerID` float NOT NULL default '0',
  `spell5Charges` float NOT NULL default '0',
  `spell5Cooldown` float NOT NULL default '0',
  `spell5CategoryID` float NOT NULL default '0',
  `spell5CategoryCooldown` float NOT NULL default '0',
  `bondID` float NOT NULL default '0',
  `description` float NOT NULL default '0',
  `bookTextID` float NOT NULL default '0',
  `bookPages` float NOT NULL default '0',
  `bookStationaryID` float NOT NULL default '0',
  `beginQuestID` float NOT NULL default '0',
  `lockPickTalent` float NOT NULL default '0',
  `materialID` float NOT NULL default '0',
  `sheathID` float NOT NULL default '0',
  `randompropertyID` float NOT NULL default '0',
  `randompropertyID2?` float NOT NULL default '0',
  `blockValue` float NOT NULL default '0',
  `itemSetID` float NOT NULL default '0',
  `durabilityValue` float NOT NULL default '0',
  `itemAreaID` float NOT NULL default '0',
  `itemMapID` float NOT NULL default '0',
  `bagFamily` float NOT NULL default '0',
  `iRefID_TotemCategory` float NOT NULL default '0',
  `socketColor_1` float NOT NULL default '0',
  `Unknown2` float NOT NULL default '0',
  `socketColor_2` float NOT NULL default '0',
  `Unknown3` float NOT NULL default '0',
  `socketColor_3` float NOT NULL default '0',
  `Unknown4` float NOT NULL default '0',
  `iRefID_SpellItemEnchantment` float NOT NULL default '0',
  `iRefID_GemProperties` float NOT NULL default '0',
  `iRefID_ItemExtendedCost` float NOT NULL default '0',
  `iRefID_ItemCondExtCosts` float NOT NULL default '0',
  `disenchantSkillLevel` float NOT NULL default '0',
  `armorDamageModifier` float NOT NULL default '0'
) ENGINE=MyISAM /*!40100 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci*/;



#
# Dumping data for table 'root_items'
#

# (No data found.)



DROP TABLE IF EXISTS `root_itemtext`;

#
# Table structure for table 'root_itemtext'
#

CREATE TABLE `root_itemtext` (
  `id` tinyint(3) unsigned default NULL,
  `entryLength` tinyint(3) unsigned default NULL,
  `Text` tinyint(3) unsigned default NULL
) ENGINE=MyISAM /*!40100 DEFAULT CHARSET=utf8*/;



#
# Dumping data for table 'root_itemtext'
#

# (No data found.)



DROP TABLE IF EXISTS `root_npctext`;

#
# Table structure for table 'root_npctext'
#

CREATE TABLE `root_npctext` (
  `ID` int(10) unsigned NOT NULL default '0',
  `entryLength` int(10) unsigned NOT NULL default '0',
  `prob0` float NOT NULL default '0',
  `text0_0` longtext character set utf8 collate utf8_unicode_ci NOT NULL,
  `text0_1` longtext character set utf8 collate utf8_unicode_ci NOT NULL,
  `lang0` int(10) unsigned NOT NULL default '0',
  `em0_0` int(10) unsigned NOT NULL default '0',
  `em0_1` int(10) unsigned NOT NULL default '0',
  `em0_2` int(10) unsigned NOT NULL default '0',
  `em0_3` int(10) unsigned NOT NULL default '0',
  `em0_4` int(10) unsigned NOT NULL default '0',
  `em0_5` int(10) unsigned NOT NULL default '0',
  `prob1` float NOT NULL default '0',
  `text1_0` longtext character set utf8 collate utf8_unicode_ci NOT NULL,
  `text1_1` longtext character set utf8 collate utf8_unicode_ci NOT NULL,
  `lang1` int(10) unsigned NOT NULL default '0',
  `em1_0` int(10) unsigned NOT NULL default '0',
  `em1_1` int(10) unsigned NOT NULL default '0',
  `em1_2` int(10) unsigned NOT NULL default '0',
  `em1_3` int(10) unsigned NOT NULL default '0',
  `em1_4` int(10) unsigned NOT NULL default '0',
  `em1_5` int(10) unsigned NOT NULL default '0',
  `prob2` float NOT NULL default '0',
  `text2_0` longtext character set utf8 collate utf8_unicode_ci NOT NULL,
  `text2_1` longtext character set utf8 collate utf8_unicode_ci NOT NULL,
  `lang2` int(10) unsigned NOT NULL default '0',
  `em2_0` int(10) unsigned NOT NULL default '0',
  `em2_1` int(10) unsigned NOT NULL default '0',
  `em2_2` int(10) unsigned NOT NULL default '0',
  `em2_3` int(10) unsigned NOT NULL default '0',
  `em2_4` int(10) unsigned NOT NULL default '0',
  `em2_5` int(10) unsigned NOT NULL default '0',
  `prob3` float NOT NULL default '0',
  `text3_0` longtext character set utf8 collate utf8_unicode_ci NOT NULL,
  `text3_1` longtext character set utf8 collate utf8_unicode_ci NOT NULL,
  `lang3` int(10) unsigned NOT NULL default '0',
  `em3_0` int(10) unsigned NOT NULL default '0',
  `em3_1` int(10) unsigned NOT NULL default '0',
  `em3_2` int(10) unsigned NOT NULL default '0',
  `em3_3` int(10) unsigned NOT NULL default '0',
  `em3_4` int(10) unsigned NOT NULL default '0',
  `em3_5` int(10) unsigned NOT NULL default '0',
  `prob4` float NOT NULL default '0',
  `text4_0` longtext character set utf8 collate utf8_unicode_ci NOT NULL,
  `text4_1` longtext character set utf8 collate utf8_unicode_ci NOT NULL,
  `lang4` int(10) unsigned NOT NULL default '0',
  `em4_0` int(10) unsigned NOT NULL default '0',
  `em4_1` int(10) unsigned NOT NULL default '0',
  `em4_2` int(10) unsigned NOT NULL default '0',
  `em4_3` int(10) unsigned NOT NULL default '0',
  `em4_4` int(10) unsigned NOT NULL default '0',
  `em4_5` int(10) unsigned NOT NULL default '0',
  `prob5` float NOT NULL default '0',
  `text5_0` longtext character set utf8 collate utf8_unicode_ci NOT NULL,
  `text5_1` longtext character set utf8 collate utf8_unicode_ci NOT NULL,
  `lang5` int(10) unsigned NOT NULL default '0',
  `em5_0` int(10) unsigned NOT NULL default '0',
  `em5_1` int(10) unsigned NOT NULL default '0',
  `em5_2` int(10) unsigned NOT NULL default '0',
  `em5_3` int(10) unsigned NOT NULL default '0',
  `em5_4` int(10) unsigned NOT NULL default '0',
  `em5_5` int(10) unsigned NOT NULL default '0',
  `prob6` float NOT NULL default '0',
  `text6_0` longtext character set utf8 collate utf8_unicode_ci NOT NULL,
  `text6_1` longtext character set utf8 collate utf8_unicode_ci NOT NULL,
  `lang6` int(10) unsigned NOT NULL default '0',
  `em6_0` int(10) unsigned NOT NULL default '0',
  `em6_1` int(10) unsigned NOT NULL default '0',
  `em6_2` int(10) unsigned NOT NULL default '0',
  `em6_3` int(10) unsigned NOT NULL default '0',
  `em6_4` int(10) unsigned NOT NULL default '0',
  `em6_5` int(10) unsigned NOT NULL default '0',
  `prob7` float NOT NULL default '0',
  `text7_0` longtext character set utf8 collate utf8_unicode_ci NOT NULL,
  `text7_1` longtext character set utf8 collate utf8_unicode_ci NOT NULL,
  `lang7` int(10) unsigned NOT NULL default '0',
  `em7_0` int(10) unsigned NOT NULL default '0',
  `em7_1` int(10) unsigned NOT NULL default '0',
  `em7_2` int(10) unsigned NOT NULL default '0',
  `em7_3` int(10) unsigned NOT NULL default '0',
  `em7_4` int(10) unsigned NOT NULL default '0',
  `em7_5` int(10) unsigned NOT NULL default '0'
) ENGINE=MyISAM /*!40100 DEFAULT CHARSET=latin1 COMMENT='NPC System'*/;



#
# Dumping data for table 'root_npctext'
#

# (No data found.)



DROP TABLE IF EXISTS `root_pagetext`;

#
# Table structure for table 'root_pagetext'
#

CREATE TABLE `root_pagetext` (
  `Entry` int(10) unsigned NOT NULL default '0',
  `entryLength` int(10) unsigned NOT NULL,
  `PageText` longtext NOT NULL,
  `NextPageID` int(10) unsigned NOT NULL default '0',
  UNIQUE KEY `entry` (`Entry`)
) ENGINE=MyISAM /*!40100 DEFAULT CHARSET=latin1 COMMENT='Item System'*/;



#
# Dumping data for table 'root_pagetext'
#

# (No data found.)



DROP TABLE IF EXISTS `root_quest`;

#
# Table structure for table 'root_quest'
#

CREATE TABLE `root_quest` (
  `questID` float NOT NULL default '0',
  `entryLength` float NOT NULL default '0',
  `DuplicatedQuestID` float NOT NULL default '0',
  `QuestType` float NOT NULL default '0',
  `QuestLevel` float NOT NULL default '0',
  `areaID/sortID` float NOT NULL default '0',
  `infoID Integer` float NOT NULL default '0',
  `SuggestedPlayers` float NOT NULL default '0',
  `FactionID` float NOT NULL default '0',
  `FactionAmount` float NOT NULL default '0',
  `Unknown1` float NOT NULL default '0',
  `Unknown2` float NOT NULL default '0',
  `nextQuestID` float NOT NULL default '0',
  `coins` float NOT NULL default '0',
  `SubExp70` float NOT NULL default '0',
  `RewardSpellID` float NOT NULL default '0',
  `EffectOnPlayer` float NOT NULL default '0',
  `Unknown3` float NOT NULL default '0',
  `startingItemID` float NOT NULL default '0',
  `QuestFlags` float NOT NULL default '0',
  `givenItem1` float NOT NULL default '0',
  `givenItem1Amount` float NOT NULL default '0',
  `givenItem2` float NOT NULL default '0',
  `givenItem2Amount` float NOT NULL default '0',
  `givenItem3` float NOT NULL default '0',
  `givenItem3Amount` float NOT NULL default '0',
  `givenItem4` float NOT NULL default '0',
  `givenItem4Amount` float NOT NULL default '0',
  `choiceItem1` float NOT NULL default '0',
  `choiceItem1Amount` float NOT NULL default '0',
  `choiceItem2` float NOT NULL default '0',
  `choiceItem2Amount` float NOT NULL default '0',
  `choiceItem3` float NOT NULL default '0',
  `choiceItem3Amount` float NOT NULL default '0',
  `choiceItem4` float NOT NULL default '0',
  `choiceItem4Amount` float NOT NULL default '0',
  `choiceItem5` float NOT NULL default '0',
  `choiceItem5Amount` float NOT NULL default '0',
  `choiceItem6` float NOT NULL default '0',
  `choiceItem6Amount` float NOT NULL default '0',
  `Unknown4` float NOT NULL default '0',
  `Unknown5` float NOT NULL default '0',
  `Unknown6` float NOT NULL default '0',
  `Unknown7` float NOT NULL default '0',
  `name` float NOT NULL default '0',
  `description` float NOT NULL default '0',
  `details` float NOT NULL default '0',
  `subdescription` float NOT NULL default '0',
  `killCreature1` float NOT NULL default '0',
  `killCreature1Amount` float NOT NULL default '0',
  `collectItem1` float NOT NULL default '0',
  `collectItem1Amount` float NOT NULL default '0',
  `killCreature2` float NOT NULL default '0',
  `killCreature2Amount` float NOT NULL default '0',
  `collectItem2` float NOT NULL default '0',
  `collectItem2Amount` float NOT NULL default '0',
  `killCreature3` float NOT NULL default '0',
  `killCreature3Amount` float NOT NULL default '0',
  `collectItem3` float NOT NULL default '0',
  `collectItem3Amount` float NOT NULL default '0',
  `killCreature4` float NOT NULL default '0',
  `killCreature4Amount` float NOT NULL default '0',
  `collectItem4` float NOT NULL default '0',
  `collectItem4Amount` float NOT NULL default '0',
  `Objective1` float NOT NULL default '0',
  `Objective2` float NOT NULL default '0',
  `Objective3` float NOT NULL default '0',
  `Objective4` float NOT NULL default '0',
  PRIMARY KEY  (`questID`),
  UNIQUE KEY `questID` (`questID`)
) ENGINE=MyISAM /*!40100 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci*/;



#
# Dumping data for table 'root_quest'
#

# (No data found.)

/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS*/;