# --------------------------------------------------------
# Generation Time: Nov 16, 2006 at 03:12 AM
# --------------------------------------------------------
# Create a database : `EQRoster`
# Go into the database and run this MySQL script
# It will create all the necessary tables and indexes
# --------------------------------------------------------

-- 
-- Table structure for table `Characters`
-- 

DROP TABLE IF EXISTS `Characters`;
CREATE TABLE `Characters` (
  `CharID` smallint(3) NOT NULL auto_increment,
  `UserID` smallint(3) NOT NULL default '0',
  `CharName` varchar(30) NOT NULL default '',
  `LastName` varchar(30) default NULL,
  `NameMain` varchar(30) NOT NULL default '',
  `Class` enum('','Bard','Beastlord','Berserker','Cleric','Druid','Enchanter','Magician','Monk','Necromancer','Paladin','Ranger','Rogue','Shadow Knight','Shaman','Warrior','Wizard') NOT NULL default '',
  `Race` enum('','Barbarian','Dark Elf','Drakkin','Dwarf','Erudite','Froglok','Gnome','Half Elf','Halfling','High Elf','Human','Iksar','Ogre','Troll','Vah Shir','Wood Elf') NOT NULL default '',
  `Gender` enum('','Female','Male') NOT NULL default '',
  `EQPlayersCharID` bigint(20) NOT NULL default '0',
  `Religion` enum('','Agnostic','Bertoxxulous','Brell Serilis','Bristle Bane','Cazic Thule','Erollisi Marr','Innoruuk','Karana','Mithaniel Marr','Prexus','Quellious','Rallos Zek','Rodcet Nife','Solusek Ro','The Tribunal','Tunare','Veeshan') NOT NULL default '',
  `Level` smallint(2) NOT NULL default '0',
  `AA` smallint(4) NOT NULL default '0',
  `GLP` smallint(3) NOT NULL default '0',
  `HP` smallint(5) NOT NULL default '0',
  `Mana` smallint(5) NOT NULL default '0',
  `Endurance` smallint(5) NOT NULL default '0',
  `AC` smallint(4) NOT NULL default '0',
  `FlowingThought` smallint(2) NOT NULL default '0',
  `Regen` smallint(2) NOT NULL default '0',
  `Atk` smallint(3) NOT NULL default '0',
  `Str` smallint(3) NOT NULL default '0',
  `Sta` smallint(3) NOT NULL default '0',
  `Agi` smallint(3) NOT NULL default '0',
  `Dex` smallint(3) NOT NULL default '0',
  `Wis` smallint(3) NOT NULL default '0',
  `Int` smallint(3) NOT NULL default '0',
  `Cha` smallint(3) NOT NULL default '0',
  `PR` smallint(3) NOT NULL default '0',
  `MR` smallint(3) NOT NULL default '0',
  `DR` smallint(3) NOT NULL default '0',
  `FR` smallint(3) NOT NULL default '0',
  `CR` smallint(3) NOT NULL default '0',
  `Epic` tinyint(1) NOT NULL default '0',
  `MageloNr` int(10) default NULL,
  `GuildStatus` enum('Alt','Applicant','Inactive','Leader','Member','Officer','Probation') NOT NULL default 'Member',
  `OldMember` tinyint(1) NOT NULL default '0',
  `LastOn` date NOT NULL default '0000-00-00',
  `LastUpdate` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
  PRIMARY KEY  (`CharID`),
  UNIQUE KEY `CharName` (`CharName`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='EQRoster Characters' AUTO_INCREMENT=841 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `DoD_Flags`
-- 

DROP TABLE IF EXISTS `DoD_Flags`;
CREATE TABLE `DoD_Flags` (
  `CharID` smallint(3) NOT NULL default '0',
  `A_Rogues_Trust` tinyint(1) NOT NULL default '0',
  `Scouting_the_City` tinyint(1) NOT NULL default '0',
  `Building_the_Disguise` tinyint(1) NOT NULL default '0',
  `The_Search_for_Illsuras` tinyint(1) NOT NULL default '0',
  `The_Rage_of_Kelliad` tinyint(1) NOT NULL default '0',
  `The_Lost_Notebook` tinyint(1) NOT NULL default '0',
  `Cavern_Botany` tinyint(1) NOT NULL default '0',
  `The_Search_for_Clues` tinyint(1) NOT NULL default '0',
  `Rescue_Cicero` tinyint(1) NOT NULL default '0',
  `Preemptive_Strike` tinyint(1) NOT NULL default '0',
  `Praetorian_Guard` tinyint(1) NOT NULL default '0',
  `The_Fall_of_Illsalin` tinyint(1) NOT NULL default '0',
  `Flights_of_the_Seeker` tinyint(1) NOT NULL default '0',
  `Into_the_Shadows` tinyint(1) NOT NULL default '0',
  `Freeing_an_Elder` tinyint(1) NOT NULL default '0',
  `Orb_of_Subversion` tinyint(1) NOT NULL default '0',
  `A_Plea_for_Help` tinyint(1) NOT NULL default '0',
  `Trailing_Longshadow` tinyint(1) NOT NULL default '0',
  `Confronting_a_Traitor` tinyint(1) NOT NULL default '0',
  `The_Search_for_Coral` tinyint(1) NOT NULL default '0',
  `Learning_the_Power` tinyint(1) NOT NULL default '0',
  `Discover_the_Secret` tinyint(1) NOT NULL default '0',
  `Taking_Control` tinyint(1) NOT NULL default '0',
  `The_Mines` tinyint(1) NOT NULL default '0',
  `Lost_Caverns` tinyint(1) NOT NULL default '0',
  `The_Hive` tinyint(1) NOT NULL default '0',
  `The_Korlach` tinyint(1) NOT NULL default '0',
  `The_Rescue` tinyint(1) NOT NULL default '0',
  `Scavenger_Hunting` tinyint(1) NOT NULL default '0',
  `Lost_Gnomes` tinyint(1) NOT NULL default '0',
  `Deserting_the_Ranks` tinyint(1) NOT NULL default '0',
  `Frustrated_Functionary` tinyint(1) NOT NULL default '0',
  `Check_Out_a_Library_Book` tinyint(1) NOT NULL default '0',
  `Eyes_Wide_Open` tinyint(1) NOT NULL default '0',
  `Memories_Lost` tinyint(1) NOT NULL default '0',
  `Misty_for_You` tinyint(1) NOT NULL default '0',
  `Eye_Bound` tinyint(1) NOT NULL default '0',
  `DemiPlane_of_Blood_Access` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`CharID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='DoD Spells';

-- --------------------------------------------------------

-- 
-- Table structure for table `DoN_Flags`
-- 

DROP TABLE IF EXISTS `DoN_Flags`;
CREATE TABLE `DoN_Flags` (
  `CharID` smallint(3) NOT NULL default '0',
  `T1_Create_an_Antidote` tinyint(1) NOT NULL default '0',
  `T1_Greed_of_the_Goblins` tinyint(1) NOT NULL default '0',
  `T1_Burning_Arrows` tinyint(1) NOT NULL default '0',
  `T1_Children_of_Gimblax` tinyint(1) NOT NULL default '0',
  `T2_Defend_the_Kirin_Contact` tinyint(1) NOT NULL default '0',
  `T2_Recover_the_Lost_Map` tinyint(1) NOT NULL default '0',
  `T2_Turn_the_Tides_of_the_Sand` tinyint(1) NOT NULL default '0',
  `T2_Sickness_of_the_Spirit` tinyint(1) NOT NULL default '0',
  `T2_Calling_Emoush` tinyint(1) NOT NULL default '0',
  `T3_Protect_the_Waters` tinyint(1) NOT NULL default '0',
  `T3_Snowfoots_Revenge` tinyint(1) NOT NULL default '0',
  `T3_The_Sacred_Scrolls` tinyint(1) NOT NULL default '0',
  `T3_History_of_the_Isle` tinyint(1) NOT NULL default '0',
  `T3_Trial_of_Perserverance` tinyint(1) NOT NULL default '0',
  `T3_Volkaras_Bite` tinyint(1) NOT NULL default '0',
  `T4_Goblin_Dojo` tinyint(1) NOT NULL default '0',
  `T4_Guardian_of_the_Sands` tinyint(1) NOT NULL default '0',
  `T4_An_End_to_the_Storms` tinyint(1) NOT NULL default '0',
  `T5_Origins_of_the_Curse` tinyint(1) NOT NULL default '0',
  `T5_The_Curse_of_JuRek` tinyint(1) NOT NULL default '0',
  `T5_In_the_Shadows` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`CharID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='DoN Flags';

-- --------------------------------------------------------

-- 
-- Table structure for table `GoD_BiC_Quest`
-- 

DROP TABLE IF EXISTS `GoD_BiC_Quest`;
CREATE TABLE `GoD_BiC_Quest` (
  `CharID` smallint(3) NOT NULL default '0',
  `Part1` tinyint(1) NOT NULL default '0',
  `Part2` tinyint(1) NOT NULL default '0',
  `Part3` tinyint(1) NOT NULL default '0',
  `Part4` tinyint(1) NOT NULL default '0',
  `Part5` tinyint(1) NOT NULL default '0',
  `Part6` tinyint(1) NOT NULL default '0',
  `Part7` tinyint(1) NOT NULL default '0',
  `Part8` tinyint(1) NOT NULL default '0',
  `Part9` tinyint(1) NOT NULL default '0',
  `Part10` tinyint(1) NOT NULL default '0',
  `Part11` tinyint(1) NOT NULL default '0',
  `Part12` tinyint(1) NOT NULL default '0',
  `Part13` tinyint(1) NOT NULL default '0',
  `Part14` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`CharID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='GoD BiC Quest';

-- --------------------------------------------------------

-- 
-- Table structure for table `GoD_DSS_Quest`
-- 

DROP TABLE IF EXISTS `GoD_DSS_Quest`;
CREATE TABLE `GoD_DSS_Quest` (
  `CharID` smallint(3) NOT NULL default '0',
  `A_Kyv_Sample` tinyint(1) NOT NULL default '0',
  `A_Mastruq_Sample` tinyint(1) NOT NULL default '0',
  `A_Noc_Sample` tinyint(1) NOT NULL default '0',
  `A_Ratuk_Sample` tinyint(1) NOT NULL default '0',
  `An_Aneuk_Sample` tinyint(1) NOT NULL default '0',
  `An_Ikaav_Sample` tinyint(1) NOT NULL default '0',
  `An_Ixt_Sample` tinyint(1) NOT NULL default '0',
  `An_Ukun_Sample` tinyint(1) NOT NULL default '0',
  `ZunMuram_Sample` tinyint(1) NOT NULL default '0',
  `TunatMuram_Sample` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`CharID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='GoD DSS Quest';

-- --------------------------------------------------------

-- 
-- Table structure for table `GoD_Flags`
-- 

DROP TABLE IF EXISTS `GoD_Flags`;
CREATE TABLE `GoD_Flags` (
  `CharID` smallint(3) NOT NULL default '0',
  `Purifying_Plant` tinyint(1) NOT NULL default '0',
  `Emanating_Furnace` tinyint(1) NOT NULL default '0',
  `Lair_of_Trapped_Ones` tinyint(1) NOT NULL default '0',
  `Pool_of_Sludge` tinyint(1) NOT NULL default '0',
  `Smith_Rondo` tinyint(1) NOT NULL default '0',
  `Vxed` tinyint(1) NOT NULL default '0',
  `Tipt` tinyint(1) NOT NULL default '0',
  `Vrex_Barxt_Qurat` tinyint(1) NOT NULL default '0',
  `Keeper_of_the_Altar` tinyint(1) NOT NULL default '0',
  `Cynosure_Kvanjji` tinyint(1) NOT NULL default '0',
  `Noqufiel_in_Inktuta` tinyint(1) NOT NULL default '0',
  `Ixt_Hsek_Syat` tinyint(1) NOT NULL default '0',
  `High_Priest_Nkosi_Bakari` tinyint(1) NOT NULL default '0',
  `ZunMuram_Tkarish_Zyk` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`CharID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='GoD Flags';

-- --------------------------------------------------------

-- 
-- Table structure for table `Keys`
-- 

DROP TABLE IF EXISTS `Keys`;
CREATE TABLE `Keys` (
  `CharID` smallint(3) NOT NULL default '0',
  `BoT_Tower_Key` tinyint(1) NOT NULL default '0',
  `Howling_Stones_Key` tinyint(1) NOT NULL default '0',
  `Sebilis_Key` tinyint(1) NOT NULL default '0',
  `Sleepers_Tomb_Key` tinyint(1) NOT NULL default '0',
  `SSRA_Emperor_Key` tinyint(1) NOT NULL default '0',
  `Veeshans_Peak_Key` tinyint(1) NOT NULL default '0',
  `Vex_Thal_Key` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`CharID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Keys and Flags';

-- --------------------------------------------------------

-- 
-- Table structure for table `OoW_CoA`
-- 

DROP TABLE IF EXISTS `OoW_CoA`;
CREATE TABLE `OoW_CoA` (
  `CharID` smallint(3) NOT NULL default '0',
  `Mastery_of_Adaptation` tinyint(1) NOT NULL default '0',
  `Mastery_of_Corruption` tinyint(1) NOT NULL default '0',
  `Mastery_of_Endurance` tinyint(1) NOT NULL default '0',
  `Mastery_of_Foresight` tinyint(1) NOT NULL default '0',
  `Mastery_of_Hate` tinyint(1) NOT NULL default '0',
  `Mastery_of_Specialization` tinyint(1) NOT NULL default '0',
  `Seal_Mastery_of_All` tinyint(1) NOT NULL default '0',
  `Signet_Crystal_Gemmed` tinyint(1) NOT NULL default '0',
  `Signet_Discolored` tinyint(1) NOT NULL default '0',
  `Signet_Dust_Marred` tinyint(1) NOT NULL default '0',
  `Signet_Glimmering` tinyint(1) NOT NULL default '0',
  `Signet_Tarnished` tinyint(1) NOT NULL default '0',
  `Signet_Two_Toned` tinyint(1) NOT NULL default '0',
  `Signet_Weather_Worn` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`CharID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='OoW CoA';

-- --------------------------------------------------------

-- 
-- Table structure for table `PoP_Tier_1_Flags`
-- 

DROP TABLE IF EXISTS `PoP_Tier_1_Flags`;
CREATE TABLE `PoP_Tier_1_Flags` (
  `CharID` smallint(3) NOT NULL default '0',
  `Any_PoJ_Trial` tinyint(1) NOT NULL default '0',
  `All_PoJ_Trials` tinyint(1) NOT NULL default '0',
  `PoI_Xanamech` tinyint(1) NOT NULL default '0',
  `PoI_Behemoth` tinyint(1) NOT NULL default '0',
  `PoD_Grimror_Quest` tinyint(1) NOT NULL default '0',
  `PoD_Grummus` tinyint(1) NOT NULL default '0',
  `PoN_Hedge_Quest` tinyint(1) NOT NULL default '0',
  `PoNb_Terris_Thule` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`CharID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='PoP Tier 1 Flags';

-- --------------------------------------------------------

-- 
-- Table structure for table `PoP_Tier_2_Flags`
-- 

DROP TABLE IF EXISTS `PoP_Tier_2_Flags`;
CREATE TABLE `PoP_Tier_2_Flags` (
  `CharID` smallint(3) NOT NULL default '0',
  `PoS_Askr_Quest` tinyint(1) NOT NULL default '0',
  `PoV_Grenic_Quest` tinyint(1) NOT NULL default '0',
  `PoV_AerinDar` tinyint(1) NOT NULL default '0',
  `CoD_Carprin_Event` tinyint(1) NOT NULL default '0',
  `CoD_Bertoxxulous` tinyint(1) NOT NULL default '0',
  `PoTorment_Saryrn` tinyint(1) NOT NULL default '0',
  `PoS_Wembly_Quest` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`CharID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='PoP Tier 2 Flags';

-- --------------------------------------------------------

-- 
-- Table structure for table `PoP_Tier_3_Flags`
-- 

DROP TABLE IF EXISTS `PoP_Tier_3_Flags`;
CREATE TABLE `PoP_Tier_3_Flags` (
  `CharID` smallint(3) NOT NULL default '0',
  `HoH_Trials` tinyint(1) NOT NULL default '0',
  `HoH_Trial1_RyddaDar` tinyint(1) NOT NULL default '0',
  `HoH_Trial2_Ogre` tinyint(1) NOT NULL default '0',
  `HoH_Trial3_Madmen` tinyint(1) NOT NULL default '0',
  `HoHb_Mithanial_Marr` tinyint(1) NOT NULL default '0',
  `PoTactics_Tallon_Zek` tinyint(1) NOT NULL default '0',
  `PoTactics_Vallon_Zek` tinyint(1) NOT NULL default '0',
  `PoTactics_Rallos_Zek_Quest` tinyint(1) NOT NULL default '0',
  `BoT_Rescue_Karana_Quest` tinyint(1) NOT NULL default '0',
  `SolRoTower_Jiva` tinyint(1) NOT NULL default '0',
  `SolRoTower_Xuzl` tinyint(1) NOT NULL default '0',
  `SolRoTower_Arlyxir` tinyint(1) NOT NULL default '0',
  `SolRoTower_Rizlona` tinyint(1) NOT NULL default '0',
  `SolRoTower_Protector_of_Dresolik` tinyint(1) NOT NULL default '0',
  `SolRoTower_Solusek_Ro` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`CharID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='PoP Tier 3 Flags';

-- --------------------------------------------------------

-- 
-- Table structure for table `PoP_Tier_4_Flags`
-- 

DROP TABLE IF EXISTS `PoP_Tier_4_Flags`;
CREATE TABLE `PoP_Tier_4_Flags` (
  `CharID` smallint(3) NOT NULL default '0',
  `PoAir_Xegony` tinyint(1) NOT NULL default '0',
  `PoFire_Fennin_Ro` tinyint(1) NOT NULL default '0',
  `PoWater_Coirnav` tinyint(1) NOT NULL default '0',
  `PoEarthb_The_Rathe` tinyint(1) NOT NULL default '0',
  `PoTime_Time_Phased_Quintessence` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`CharID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='PoP Tier 4 Falgs';

-- --------------------------------------------------------

-- 
-- Table structure for table `PoR_Flags`
-- 

DROP TABLE IF EXISTS `PoR_Flags`;
CREATE TABLE `PoR_Flags` (
  `CharID` smallint(3) NOT NULL default '0',
  `The_Library` tinyint(1) NOT NULL default '0',
  `The_Oubliette` tinyint(1) NOT NULL default '0',
  `The_Laboratory` tinyint(1) NOT NULL default '0',
  `The_Key_to_the_Past` tinyint(1) NOT NULL default '0',
  `The_Burning_Prince` tinyint(1) NOT NULL default '0',
  `Message_to_the_Past` tinyint(1) NOT NULL default '0',
  `Samples_of_Corruption` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`CharID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='PoR Flags';

-- --------------------------------------------------------

-- 
-- Table structure for table `PoS_Askr_Quest`
-- 

DROP TABLE IF EXISTS `PoS_Askr_Quest`;
CREATE TABLE `PoS_Askr_Quest` (
  `CharID` smallint(3) NOT NULL default '0',
  `Head` tinyint(1) NOT NULL default '0',
  `Beard` tinyint(1) NOT NULL default '0',
  `Bone` tinyint(1) NOT NULL default '0',
  `Sash` tinyint(1) NOT NULL default '0',
  `OceanMedal` tinyint(1) NOT NULL default '0',
  `DesertMedal` tinyint(1) NOT NULL default '0',
  `ForestMedal` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`CharID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='BoT Flag';

-- --------------------------------------------------------

-- 
-- Table structure for table `SSRA_Emperor_Key`
-- 

DROP TABLE IF EXISTS `SSRA_Emperor_Key`;
CREATE TABLE `SSRA_Emperor_Key` (
  `CharID` smallint(3) NOT NULL default '0',
  `Taskmasters_Pouch` tinyint(1) NOT NULL default '0',
  `Zazuzhs_Idol` tinyint(1) NOT NULL default '0',
  `Ring` tinyint(1) NOT NULL default '0',
  `Insignia` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`CharID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='SSRA Emperor key';

-- --------------------------------------------------------

-- 
-- Table structure for table `TradeSkills`
-- 

DROP TABLE IF EXISTS `TradeSkills`;
CREATE TABLE `TradeSkills` (
  `CharID` smallint(3) NOT NULL default '0',
  `Alchemy` smallint(3) NOT NULL default '0',
  `Baking` smallint(3) NOT NULL default '0',
  `Brewing` smallint(3) NOT NULL default '0',
  `Fishing` smallint(3) NOT NULL default '0',
  `Fletching` smallint(3) NOT NULL default '0',
  `Foraging` smallint(3) NOT NULL default '0',
  `Jewelcraft` smallint(3) NOT NULL default '0',
  `Poison` smallint(3) NOT NULL default '0',
  `Pottery` smallint(3) NOT NULL default '0',
  `Research` smallint(3) NOT NULL default '0',
  `Smithing` smallint(3) NOT NULL default '0',
  `Tailoring` smallint(3) NOT NULL default '0',
  `Tinkering` smallint(3) NOT NULL default '0',
  PRIMARY KEY  (`CharID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='EQRoster TradeSkills';

-- --------------------------------------------------------

-- 
-- Table structure for table `Users`
-- 

DROP TABLE IF EXISTS `Users`;
CREATE TABLE `Users` (
  `UserID` smallint(3) NOT NULL auto_increment,
  `UserName` varchar(30) NOT NULL default '',
  `Password` varchar(20) NOT NULL default '',
  `EMailAddress` varchar(100) NOT NULL default '',
  `ShowEMail` enum('Always','Members Only','Never') NOT NULL default 'Members Only',
  `TimeZone` enum('Asia','Australia','Canada','Europe','US West','US Central','US East') NOT NULL default 'US West',
  `Verified` enum('Yes','No') NOT NULL default 'No',
  PRIMARY KEY  (`UserID`),
  UNIQUE KEY `UserName` (`UserName`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='EQRoster Users' AUTO_INCREMENT=64 ;

-- --------------------------------------------------------

-- 
-- Table structure for table `Veeshans_Peak_Key`
-- 

DROP TABLE IF EXISTS `Veeshans_Peak_Key`;
CREATE TABLE `Veeshans_Peak_Key` (
  `CharID` smallint(3) NOT NULL default '0',
  `KylongMedal_Top` tinyint(1) NOT NULL default '0',
  `KylongMedal_Middle` tinyint(1) NOT NULL default '0',
  `KylongMedal_Bottom` tinyint(1) NOT NULL default '0',
  `JarsathMedal_Top` tinyint(1) NOT NULL default '0',
  `JarsathMedal_Middle` tinyint(1) NOT NULL default '0',
  `JarsathMedal_Bottom` tinyint(1) NOT NULL default '0',
  `ObulusMedal_Top` tinyint(1) NOT NULL default '0',
  `ObulusMedal_Middle` tinyint(1) NOT NULL default '0',
  `ObulusMedal_Bottom` tinyint(1) NOT NULL default '0',
  `Trak_Tooth` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`CharID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Veeshans Peak key';

-- --------------------------------------------------------

-- 
-- Table structure for table `Vex_Thal_Key`
-- 

DROP TABLE IF EXISTS `Vex_Thal_Key`;
CREATE TABLE `Vex_Thal_Key` (
  `CharID` smallint(3) NOT NULL default '0',
  `Glowing_Orb` tinyint(1) NOT NULL default '0',
  `Celestial_Rift` tinyint(1) NOT NULL default '0',
  `Shard_Dat` tinyint(1) NOT NULL default '0',
  `Shard_Dax` tinyint(1) NOT NULL default '0',
  `Shard_Kel` tinyint(1) NOT NULL default '0',
  `Shard_Kelara` tinyint(1) NOT NULL default '0',
  `Shard_Lor` tinyint(1) NOT NULL default '0',
  `Shard_Set` tinyint(1) NOT NULL default '0',
  `Shard_Raf` tinyint(1) NOT NULL default '0',
  `Shard_Tak` tinyint(1) NOT NULL default '0',
  `Shard_Ved` tinyint(1) NOT NULL default '0',
  `Shard_Vin` tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (`CharID`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='Vex Thal key';