-- phpMyAdmin SQL Dump
-- version 2.6.1-pl3
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Apr 23, 2005 at 11:39 PM
-- Server version: 3.23.58
-- PHP Version: 4.3.4
-- 
-- Database: `guildmaster`
-- 

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

-- 
-- Table structure for table `class`
-- 

CREATE TABLE `Class` (
  `i_classID` int(10) NOT NULL auto_increment,
  `vch_className` varchar(150) NOT NULL default '',
  PRIMARY KEY  (`i_classID`)
) TYPE=MyISAM AUTO_INCREMENT=10 ;

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

-- 
-- Table structure for table `completedresponsibility`
-- 

CREATE TABLE `CompletedResponsibility` (
  `i_completedResponID` int(10) NOT NULL auto_increment,
  `i_memberID` int(10) NOT NULL default '0',
  `i_responID` int(10) NOT NULL default '0',
  `date_completed` date NOT NULL default '0000-00-00',
  `i_onTime` int(1) NOT NULL default '0',
  PRIMARY KEY  (`i_completedResponID`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

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

-- 
-- Table structure for table `deed`
-- 

CREATE TABLE `Deed` (
  `i_deedID` int(10) NOT NULL auto_increment,
  `vch_deedName` varchar(255) NOT NULL default '',
  `text_deedDesc` text NOT NULL,
  `i_guildDeedPoints` int(3) NOT NULL default '0',
  `i_questDeedPoints` int(3) NOT NULL default '0',
  `i_pvpDeedPoints` int(3) NOT NULL default '0',
  `vch_difficulty` varchar(40) NOT NULL default '',
  `i_multiCompletion` int(1) NOT NULL default '0',
  `i_deleted` int(1) NOT NULL default '0',
  `date_created` date NOT NULL default '0000-00-00',
  `date_modified` date NOT NULL default '0000-00-00',
  PRIMARY KEY  (`i_deedID`)
) TYPE=MyISAM AUTO_INCREMENT=36 ;

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

-- 
-- Table structure for table `deedlogentry`
-- 

CREATE TABLE `DeedLogEntry` (
  `i_deedLogEntryID` int(10) NOT NULL auto_increment,
  `i_memberID` int(10) NOT NULL default '0',
  `i_deedID` int(10) NOT NULL default '0',
  `i_numTimes` int(1) NOT NULL default '0',
  `date_added` date NOT NULL default '0000-00-00',
  `i_deleted` int(1) NOT NULL default '0',
  PRIMARY KEY  (`i_deedLogEntryID`)
) TYPE=MyISAM AUTO_INCREMENT=50 ;

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

-- 
-- Table structure for table `gamecharacter`
-- 

CREATE TABLE `GameCharacter` (
  `i_characterID` int(10) NOT NULL auto_increment,
  `vch_characterName` varchar(150) NOT NULL default '',
  `ch_characterSex` char(1) NOT NULL default '',
  `i_raceID` int(10) NOT NULL default '0',
  `i_classID` int(10) NOT NULL default '0',
  `i_serverID` int(10) NOT NULL default '0',
  `i_level` int(4) NOT NULL default '0',
  `i_enableThottbot` int(1) NOT NULL default '0',
  `i_deleted` int(1) NOT NULL default '0',
  `date_created` date NOT NULL default '0000-00-00',
  `date_modified` date NOT NULL default '0000-00-00',
  PRIMARY KEY  (`i_characterID`)
) TYPE=MyISAM AUTO_INCREMENT=140 ;

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

-- 
-- Table structure for table `image`
-- 

CREATE TABLE `Image` (
  `i_imageID` int(10) NOT NULL auto_increment,
  `vch_imageName` varchar(100) NOT NULL default '',
  `vch_imagePath` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`i_imageID`)
) TYPE=MyISAM AUTO_INCREMENT=17 ;

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

-- 
-- Table structure for table `member`
-- 

CREATE TABLE `Member` (
  `i_memberID` int(10) NOT NULL auto_increment,
  `i_rankID` int(10) NOT NULL default '0',
  `i_mainCharacterID` int(10) NOT NULL default '0',
  `vch_login` varchar(50) NOT NULL default '',
  `vch_password` varchar(50) NOT NULL default '',
  `vch_email` varchar(255) NOT NULL default '',
  `i_deleted` int(1) NOT NULL default '0',
  `date_created` date NOT NULL default '0000-00-00',
  `date_modified` date NOT NULL default '0000-00-00',
  PRIMARY KEY  (`i_memberID`)
) TYPE=MyISAM AUTO_INCREMENT=35 ;

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

-- 
-- Table structure for table `member_gamecharacter`
-- 

CREATE TABLE `Member_GameCharacter` (
  `i_memberID` int(10) NOT NULL default '0',
  `i_characterID` int(10) NOT NULL default '0',
  PRIMARY KEY  (`i_memberID`,`i_characterID`)
) TYPE=MyISAM;

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

-- 
-- Table structure for table `member_note`
-- 

CREATE TABLE `Member_Note` (
  `i_memberID` int(10) NOT NULL default '0',
  `i_noteID` int(10) NOT NULL default '0',
  PRIMARY KEY  (`i_memberID`,`i_noteID`)
) TYPE=MyISAM;

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

-- 
-- Table structure for table `memberresponsibilitylistentry`
-- 

CREATE TABLE `MemberResponsibilityListEntry` (
  `i_responListEntryID` int(10) NOT NULL auto_increment,
  `vch_responType` varchar(10) NOT NULL default '',
  `i_memberID` int(10) NOT NULL default '0',
  `i_responID` int(10) NOT NULL default '0',
  `i_finishInCount` int(4) NOT NULL default '0',
  `vch_finishInType` varchar(10) NOT NULL default '',
  `date_lastCompleted` date NOT NULL default '0000-00-00',
  `date_added` date NOT NULL default '0000-00-00',
  PRIMARY KEY  (`i_responListEntryID`)
) TYPE=MyISAM AUTO_INCREMENT=78 ;

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

-- 
-- Table structure for table `note`
-- 

CREATE TABLE `Note` (
  `i_noteID` int(10) NOT NULL auto_increment,
  `vch_title` varchar(200) NOT NULL default '',
  `text_note` text NOT NULL,
  `i_deleted` int(1) NOT NULL default '0',
  `date_created` date NOT NULL default '0000-00-00',
  `date_modified` date NOT NULL default '0000-00-00',
  PRIMARY KEY  (`i_noteID`)
) TYPE=MyISAM AUTO_INCREMENT=3 ;

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

-- 
-- Table structure for table `promotionrequirements`
-- 

CREATE TABLE `PromotionRequirements` (
  `i_promoRequirementsID` int(10) NOT NULL auto_increment,
  `i_guildDeedPoints` int(3) NOT NULL default '0',
  `i_questDeedPoints` int(3) NOT NULL default '0',
  `i_pvpDeedPoints` int(3) NOT NULL default '0',
  PRIMARY KEY  (`i_promoRequirementsID`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

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

-- 
-- Table structure for table `promotionrequirements_deed`
-- 

CREATE TABLE `PromotionRequirements_Deed` (
  `i_promoRequirementsID` int(10) NOT NULL default '0',
  `i_deedID` int(10) NOT NULL default '0',
  PRIMARY KEY  (`i_promoRequirementsID`,`i_deedID`)
) TYPE=MyISAM;

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

-- 
-- Table structure for table `race`
-- 

CREATE TABLE `Race` (
  `i_raceID` int(10) NOT NULL auto_increment,
  `vch_raceName` varchar(100) NOT NULL default '',
  `i_femalePicID` int(10) NOT NULL default '0',
  `i_malePicID` int(10) NOT NULL default '0',
  PRIMARY KEY  (`i_raceID`)
) TYPE=MyISAM AUTO_INCREMENT=9 ;

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

-- 
-- Table structure for table `rank`
-- 

CREATE TABLE `Rank` (
  `i_rankID` int(10) NOT NULL auto_increment,
  `i_subordinateID` int(10) default '0',
  `i_superiorID` int(10) default '0',
  `i_promoRequirementsID` int(10) NOT NULL default '0',
  `vch_rankName` varchar(100) NOT NULL default '',
  PRIMARY KEY  (`i_rankID`)
) TYPE=MyISAM AUTO_INCREMENT=5 ;

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

-- 
-- Table structure for table `rankresponsibilitylistentry`
-- 

CREATE TABLE `RankResponsibilityListEntry` (
  `i_responListEntryID` int(10) NOT NULL auto_increment,
  `i_rankID` int(10) NOT NULL default '0',
  `i_responID` varchar(10) NOT NULL default '',
  `i_finishInCount` int(4) NOT NULL default '0',
  `vch_finishInType` varchar(10) NOT NULL default '',
  `date_added` date NOT NULL default '0000-00-00',
  PRIMARY KEY  (`i_responListEntryID`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;

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

-- 
-- Table structure for table `responsibility`
-- 

CREATE TABLE `Responsibility` (
  `i_responID` int(10) NOT NULL auto_increment,
  `vch_responName` varchar(255) NOT NULL default '',
  `text_responDesc` text NOT NULL,
  `i_deleted` int(1) NOT NULL default '0',
  `date_created` date NOT NULL default '0000-00-00',
  `date_modified` date NOT NULL default '0000-00-00',
  PRIMARY KEY  (`i_responID`)
) TYPE=MyISAM AUTO_INCREMENT=28 ;

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

-- 
-- Table structure for table `server`
-- 

CREATE TABLE `Server` (
  `i_serverID` int(10) NOT NULL auto_increment,
  `vch_serverName` varchar(150) NOT NULL default '',
  PRIMARY KEY  (`i_serverID`)
) TYPE=MyISAM AUTO_INCREMENT=95 ;

INSERT INTO `Class` VALUES (1, 'Warrior');
INSERT INTO `Class` VALUES (2, 'Rogue');
INSERT INTO `Class` VALUES (3, 'Priest');
INSERT INTO `Class` VALUES (4, 'Shaman');
INSERT INTO `Class` VALUES (5, 'Warlock');
INSERT INTO `Class` VALUES (6, 'Mage');
INSERT INTO `Class` VALUES (7, 'Druid');
INSERT INTO `Class` VALUES (8, 'Hunter');
INSERT INTO `Class` VALUES (9, 'Paladin');

INSERT INTO `Race` VALUES (1, 'Dwarf', 1, 2);
INSERT INTO `Race` VALUES (2, 'Gnome', 3, 4);
INSERT INTO `Race` VALUES (3, 'Human', 5, 6);
INSERT INTO `Race` VALUES (4, 'Nightelf', 7, 8);
INSERT INTO `Race` VALUES (5, 'Orc', 9, 10);
INSERT INTO `Race` VALUES (6, 'Tauren', 11, 12);
INSERT INTO `Race` VALUES (7, 'Troll', 13, 14);
INSERT INTO `Race` VALUES (8, 'Undead', 15, 16);

INSERT INTO `Image` VALUES (1, 'dwarf_female.gif', './img/avatars/');
INSERT INTO `Image` VALUES (2, 'dwarf_male.gif', './img/avatars/');
INSERT INTO `Image` VALUES (3, 'gnome_female.gif', './img/avatars/');
INSERT INTO `Image` VALUES (4, 'gnome_male.gif', './img/avatars/');
INSERT INTO `Image` VALUES (5, 'human_female.gif', './img/avatars/');
INSERT INTO `Image` VALUES (6, 'human_male.gif', './img/avatars/');
INSERT INTO `Image` VALUES (7, 'nightelf_female.gif', './img/avatars/');
INSERT INTO `Image` VALUES (8, 'nightelf_male.gif', './img/avatars/');
INSERT INTO `Image` VALUES (9, 'orc_female.gif', './img/avatars/');
INSERT INTO `Image` VALUES (10, 'orc_male.gif', './img/avatars/');
INSERT INTO `Image` VALUES (11, 'tauren_female.gif', './img/avatars/');
INSERT INTO `Image` VALUES (12, 'tauren_male.gif', './img/avatars/');
INSERT INTO `Image` VALUES (13, 'troll_female.gif', './img/avatars/');
INSERT INTO `Image` VALUES (14, 'troll_male.gif', './img/avatars/');
INSERT INTO `Image` VALUES (15, 'undead_female.gif', './img/avatars/');
INSERT INTO `Image` VALUES (16, 'undead_male.gif', './img/avatars/');

INSERT INTO `Server` VALUES (1, 'Aggramar');
INSERT INTO `Server` VALUES (2, 'Alleria');
INSERT INTO `Server` VALUES (3, 'Archimonde');
INSERT INTO `Server` VALUES (4, 'Argent Dawn');
INSERT INTO `Server` VALUES (5, 'Arthas');
INSERT INTO `Server` VALUES (6, 'Azgalor');
INSERT INTO `Server` VALUES (7, 'Azjol-Nerub');
INSERT INTO `Server` VALUES (8, 'Blackhand');
INSERT INTO `Server` VALUES (9, 'Blackrock');
INSERT INTO `Server` VALUES (10, 'Bleeding Hollow');
INSERT INTO `Server` VALUES (11, 'Bloodhoof');
INSERT INTO `Server` VALUES (12, 'Bloodscalp');
INSERT INTO `Server` VALUES (13, 'Bonechewer');
INSERT INTO `Server` VALUES (14, 'Boulderfist');
INSERT INTO `Server` VALUES (15, 'Bronzebeard');
INSERT INTO `Server` VALUES (16, 'Burning Blade');
INSERT INTO `Server` VALUES (17, 'Burning Legion');
INSERT INTO `Server` VALUES (18, 'Cenarion Circle');
INSERT INTO `Server` VALUES (19, 'Cenarius');
INSERT INTO `Server` VALUES (20, 'Crushridge');
INSERT INTO `Server` VALUES (21, 'Daggerspine');
INSERT INTO `Server` VALUES (22, 'Dalaran');
INSERT INTO `Server` VALUES (23, 'Darkspear');
INSERT INTO `Server` VALUES (24, 'Deathwing');
INSERT INTO `Server` VALUES (25, 'Destromath');
INSERT INTO `Server` VALUES (26, 'Dethecus');
INSERT INTO `Server` VALUES (27, 'Doomhammer');
INSERT INTO `Server` VALUES (28, 'Draenor');
INSERT INTO `Server` VALUES (29, 'Dragonblight');
INSERT INTO `Server` VALUES (30, 'Dragonmaw');
INSERT INTO `Server` VALUES (31, 'Dunemaul');
INSERT INTO `Server` VALUES (32, 'Durotan');
INSERT INTO `Server` VALUES (33, 'Earthen Ring');
INSERT INTO `Server` VALUES (34, 'Eldre''Thalas');
INSERT INTO `Server` VALUES (35, 'Elune');
INSERT INTO `Server` VALUES (36, 'Eonar');
INSERT INTO `Server` VALUES (37, 'Eredar');
INSERT INTO `Server` VALUES (38, 'Feathermoon');
INSERT INTO `Server` VALUES (39, 'Firetree');
INSERT INTO `Server` VALUES (40, 'Frostmane');
INSERT INTO `Server` VALUES (41, 'Frostwolf');
INSERT INTO `Server` VALUES (42, 'Garona');
INSERT INTO `Server` VALUES (43, 'Gilneas');
INSERT INTO `Server` VALUES (44, 'Gorefiend');
INSERT INTO `Server` VALUES (45, 'Gorgonnash');
INSERT INTO `Server` VALUES (46, 'Hellscream');
INSERT INTO `Server` VALUES (47, 'Hyjal');
INSERT INTO `Server` VALUES (48, 'Icecrown');
INSERT INTO `Server` VALUES (49, 'Illidan');
INSERT INTO `Server` VALUES (50, 'Kargath');
INSERT INTO `Server` VALUES (51, 'Kel''Thuzad');
INSERT INTO `Server` VALUES (52, 'Khadgar');
INSERT INTO `Server` VALUES (53, 'Kil''Jaeden');
INSERT INTO `Server` VALUES (54, 'Kilrogg');
INSERT INTO `Server` VALUES (55, 'Laughing Skull');
INSERT INTO `Server` VALUES (56, 'Lightbringer');
INSERT INTO `Server` VALUES (57, 'Lightning''s Blade');
INSERT INTO `Server` VALUES (58, 'Llane');
INSERT INTO `Server` VALUES (59, 'Lothar');
INSERT INTO `Server` VALUES (60, 'Magtheridon');
INSERT INTO `Server` VALUES (61, 'Mal''Ganis');
INSERT INTO `Server` VALUES (62, 'Malygos');
INSERT INTO `Server` VALUES (63, 'Mannoroth');
INSERT INTO `Server` VALUES (64, 'Medivh');
INSERT INTO `Server` VALUES (65, 'Nathrezim');
INSERT INTO `Server` VALUES (66, 'Ner''zhul');
INSERT INTO `Server` VALUES (67, 'Perenolde');
INSERT INTO `Server` VALUES (68, 'Proudmoore');
INSERT INTO `Server` VALUES (69, 'Sargeras');
INSERT INTO `Server` VALUES (70, 'Scarlet Crusade');
INSERT INTO `Server` VALUES (71, 'Shadow Council');
INSERT INTO `Server` VALUES (72, 'Shadow Moon');
INSERT INTO `Server` VALUES (73, 'Shadowsong');
INSERT INTO `Server` VALUES (74, 'Shattered Hand');
INSERT INTO `Server` VALUES (75, 'Silver Hand');
INSERT INTO `Server` VALUES (76, 'Silvermoon');
INSERT INTO `Server` VALUES (77, 'Skullcrusher');
INSERT INTO `Server` VALUES (78, 'Spinebreaker');
INSERT INTO `Server` VALUES (79, 'Spirestone');
INSERT INTO `Server` VALUES (80, 'Stonemaul');
INSERT INTO `Server` VALUES (81, 'Stormrage');
INSERT INTO `Server` VALUES (82, 'Stormreaver');
INSERT INTO `Server` VALUES (83, 'Stormscale');
INSERT INTO `Server` VALUES (84, 'Suramar');
INSERT INTO `Server` VALUES (85, 'Terenas');
INSERT INTO `Server` VALUES (86, 'Thunderhorn');
INSERT INTO `Server` VALUES (87, 'Thunderlord');
INSERT INTO `Server` VALUES (88, 'Tichondrius');
INSERT INTO `Server` VALUES (89, 'Uldum');
INSERT INTO `Server` VALUES (90, 'Uther');
INSERT INTO `Server` VALUES (91, 'Warsong');
INSERT INTO `Server` VALUES (92, 'Whisperwind');
INSERT INTO `Server` VALUES (93, 'Windrunner');
INSERT INTO `Server` VALUES (94, 'Zul''jin');
        