
-- 
-- Table structure for table `Addons`
-- 

CREATE TABLE `Addons` (
  `ID` int(11) NOT NULL auto_increment,
  `Title` text NOT NULL,
  `Message` text NOT NULL,
  `Link` text NOT NULL,
  `Patch_no` text NOT NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM;

-- 
-- Dumping data for table `Addons`
-- 

INSERT INTO `Addons` VALUES (10, 'KLHThreatMeter', 'KLHThreatMeter monitors and records your threat, and will list your threat in a table with other members of your party or raid group who are using the mod. Most class talents, abilities, and items that cause or modify threat are taken into account. There is a table for your personal threat contribution, broken into specific categories such as white damage, healing, mana gain, etc, and specific abilities such as Sunder Armor and Taunt.', 'http://www.curse-gaming.com/en/wow/addons-3488-1-klhthreatmeter.html', 'v2');
INSERT INTO `Addons` VALUES (11, 'Texas Holdem', 'In game poker for any boring raids :D<br><br>Texas Holdem UI Mod for World Of Warcraft\r\n<br>To Host a game Use: /poker\r\n<br>To Join a game Use: /poker Playername\r\n<br>Feedback to Thornwind at AnzacHoldem@Gmail.com\r\n<br>Dealer can rightclick player boxes to get some options up.\r\n<br>Dealer can set his Chips to 0, to enable "auto dealing".\r\n', 'http://www.curse-gaming.com/en/wow/addons-4587-1-anzac-holdem.html', 'v2');

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

-- 
-- Table structure for table `Boss`
-- 

CREATE TABLE `Boss` (
  `boss_id` int(11) NOT NULL auto_increment,
  `boss` text NOT NULL,
  `status` text NOT NULL,
  `backup_id` int(11) NOT NULL default '0',
  `boss_order` int(11) NOT NULL default '0',
  PRIMARY KEY  (`boss_id`)
) ENGINE=MyISAM;

-- 
-- Dumping data for table `Boss`
-- 


INSERT INTO `Boss` VALUES (1, 'Shadikith the Glider', 'alive', 6, 28);
INSERT INTO `Boss` VALUES (2, 'Rokad the Ravager', 'alive', 6, 27);
INSERT INTO `Boss` VALUES (3, 'Hyakiss the Lurker', 'dead', 6, 26);
INSERT INTO `Boss` VALUES (4, 'Romulo and Julianne', 'dead', 6, 25);
INSERT INTO `Boss` VALUES (5, 'karazhan - extras', 'dungoen', 6, 22);
INSERT INTO `Boss` VALUES (6, 'The Wizard of Oz', 'alive', 6, 23);
INSERT INTO `Boss` VALUES (7, 'The Big Bad Wolf ', 'alive', 6, 24);
INSERT INTO `Boss` VALUES (8, 'Moroes ', 'dead', 6, 20);
INSERT INTO `Boss` VALUES (9, 'Attumen the Huntsman and Midnight ', 'dead', 6, 21);
INSERT INTO `Boss` VALUES (10, 'Maiden of Virtue', 'dead', 6, 19);
INSERT INTO `Boss` VALUES (11, 'The Curator', 'dead', 6, 18);
INSERT INTO `Boss` VALUES (12, 'Terestian Illhoof', 'alive', 6, 17);
INSERT INTO `Boss` VALUES (13, 'Shade of Aran', 'alive', 6, 16);
INSERT INTO `Boss` VALUES (14, 'Chess event', 'dead', 6, 15);
INSERT INTO `Boss` VALUES (15, 'Nethersprite', 'alive', 6, 14);
INSERT INTO `Boss` VALUES (16, 'Prince Malchezaar', 'alive', 6, 13);
INSERT INTO `Boss` VALUES (17, 'Nightbane ', 'alive', 6, 12);
INSERT INTO `Boss` VALUES (18, 'karazhan', 'dungoen', 6, 11);
INSERT INTO `Boss` VALUES (19, 'High King Maulgar', 'alive', 6, 10);
INSERT INTO `Boss` VALUES (20, 'Gruul', 'alive', 6, 9);
INSERT INTO `Boss` VALUES (21, 'Magtheridon', 'alive', 6, 7);
INSERT INTO `Boss` VALUES (22, 'Gruul''s Lair', 'dungoen', 6, 8);
INSERT INTO `Boss` VALUES (23, 'Hydross The Unstable', 'alive', 6, 5);
INSERT INTO `Boss` VALUES (24, 'Magtheridon''s Lair', 'dungoen', 6, 6);
INSERT INTO `Boss` VALUES (25, 'Fathom-Lord Karathress', 'alive', 6, 4);
INSERT INTO `Boss` VALUES (26, 'Morogrim Tidewalker', 'alive', 6, 3);
INSERT INTO `Boss` VALUES (27, 'Leotheras The Blind', 'alive', 6, 2);
INSERT INTO `Boss` VALUES (28, 'Lady Vashj ', 'alive', 6, 1);
INSERT INTO `Boss` VALUES (29, 'Serpentshrine Cavern', 'dungoen', 6, 0);

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

-- 
-- Table structure for table `News`
-- 

CREATE TABLE `News` (
  `ID` int(11) NOT NULL auto_increment,
  `Date` text NOT NULL,
  `User` text NOT NULL,
  `Title` text NOT NULL,
  `Message` longtext NOT NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM;


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

-- 
-- Table structure for table `Settings`
-- 

CREATE TABLE `Settings` (
  `ID` int(11) NOT NULL auto_increment,
  `setID` text NOT NULL,
  `Active` text NOT NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM;

-- 
-- Dumping data for table `Settings`
-- 

INSERT INTO `Settings` VALUES (8, 'appsys', 'off');
INSERT INTO `Settings` VALUES (9, 'root', 'http://www.sourced.me.uk');
INSERT INTO `Settings` VALUES (10, 'applink', 'http://www.forpersonaluse.co.uk/merry/viewforum.php?f=6');
INSERT INTO `Settings` VALUES (11, 'forum', 'http://www.forpersonaluse.co.uk/merry');
INSERT INTO `Settings` VALUES (12, 'header', 'http://www.forpersonaluse.co.uk/merry/templates/xand/images/top.gif');
INSERT INTO `Settings` VALUES (13, 'dkplink1', 'http://finalx.eu/dkp');
INSERT INTO `Settings` VALUES (14, 'dkp1', 'no');
INSERT INTO `Settings` VALUES (15, 'guild', 'Going Merry');
INSERT INTO `Settings` VALUES (16, 'dkp2', 'no');
INSERT INTO `Settings` VALUES (17, 'dkplink2', '#');
INSERT INTO `Settings` VALUES (18, 'metakey', 'Going Merry');
INSERT INTO `Settings` VALUES (19, 'metadesc', 'Going Merry');
INSERT INTO `Settings` VALUES (20, 'server', 'http://forums.wow-europe.com/board.html?forumId=1119&sid=1');
INSERT INTO `Settings` VALUES (21, 'dkplinktext1', 'Legacy DKP');
INSERT INTO `Settings` VALUES (22, 'dkplinktext2', 'DKP link 2 [test]');
INSERT INTO `Settings` VALUES (23, 'cookie', '.sourced.me.uk');
INSERT INTO `Settings` VALUES (30, 'dkplink4', '#');
INSERT INTO `Settings` VALUES (29, 'dkplinktext3', 'DKP link 3 [test]');
INSERT INTO `Settings` VALUES (27, 'dkplink3', '#');
INSERT INTO `Settings` VALUES (28, 'dkp3', 'no');
INSERT INTO `Settings` VALUES (31, 'dkp4', 'no');
INSERT INTO `Settings` VALUES (32, 'dkplinktext4', 'DKP link 4 [test]');
INSERT INTO `Settings` VALUES (33, 'header_width', '100');

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

-- 
-- Table structure for table `Webaccounts`
-- 

CREATE TABLE `Webaccounts` (
  `Charname` text NOT NULL,
  `Pass` text NOT NULL,
  `Sesid` text NOT NULL,
  `Level` text NOT NULL,
  `ID` int(11) NOT NULL auto_increment,
  `Email` text NOT NULL,
  `Class` text NOT NULL,
  `Race` text NOT NULL,
  `Alla` text NOT NULL,
  `Country` text NOT NULL,
  `Age` text NOT NULL,
  `guild` text NOT NULL,
  `Pic` text NOT NULL,
  `Note` text NOT NULL,
  `onlineid` int(5) NOT NULL default '0',
  `ipaddress` varchar(255) NOT NULL default '',
  `lastactive` int(11) NOT NULL default '0',
  `applied` int(1) NOT NULL default '0',
  `website` text NOT NULL,
  `dkp` text NOT NULL,
  `postcount` int(11) NOT NULL default '0',
  `Gender` text NOT NULL,
  `Talents` text NOT NULL,
  `Roleplay` text NOT NULL,
  `MC` text NOT NULL,
  `ONY` text NOT NULL,
  `BWL` text NOT NULL,
  `NAX` text NOT NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM;

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

-- 
-- Table structure for table `_countries`
-- 

CREATE TABLE `_countries` (
  `ISO_Code` char(2) NOT NULL default '',
  `Country` varchar(255) NOT NULL default '',
  `Region` varchar(255) NOT NULL default '',
  `Capital` varchar(255) NOT NULL default '',
  `Currency` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`ISO_Code`)
) ENGINE=MyISAM;

-- 
-- Dumping data for table `_countries`
-- 

INSERT INTO `_countries` VALUES ('AD', 'Andorra', 'Europe', 'Andorra la Vella', 'Euro');
INSERT INTO `_countries` VALUES ('AE', 'United Arab Emirates', 'Middle East', 'Abu Dhabi', 'UAE Dirham');
INSERT INTO `_countries` VALUES ('AF', 'Afghanistan', 'Asia', 'Kabul', 'Afghani');
INSERT INTO `_countries` VALUES ('AG', 'Antigua and Barbuda', 'Central America and the Caribbean', 'Saint John''s', 'East Caribbean Dollar');
INSERT INTO `_countries` VALUES ('AI', 'Anguilla', 'Central America and the Caribbean', 'The Valley', 'East Caribbean Dollar');
INSERT INTO `_countries` VALUES ('AL', 'Albania', 'Europe', 'Tirana', 'Lek');
INSERT INTO `_countries` VALUES ('AM', 'Armenia', 'Commonwealth of Independent States', 'Yerevan', 'Armenian Dram');
INSERT INTO `_countries` VALUES ('AN', 'Netherlands Antilles', 'Central America and the Caribbean', 'Willemstad', 'Netherlands Antillean guilder');
INSERT INTO `_countries` VALUES ('AO', 'Angola', 'Africa', 'Luanda', 'Kwanza');
INSERT INTO `_countries` VALUES ('AQ', 'Antarctica', 'Antarctic Region', '--', '');
INSERT INTO `_countries` VALUES ('AR', 'Argentina', 'South America', 'Buenos Aires', 'Argentine Peso');
INSERT INTO `_countries` VALUES ('AS', 'American Samoa', 'Oceania', 'Pago Pago', 'US Dollar');
INSERT INTO `_countries` VALUES ('AT', 'Austria', 'Europe', 'Vienna', 'Euro');
INSERT INTO `_countries` VALUES ('AU', 'Australia', 'Oceania', 'Canberra', 'Australian dollar');
INSERT INTO `_countries` VALUES ('AW', 'Aruba', 'Central America and the Caribbean', 'Oranjestad', 'Aruban Guilder');
INSERT INTO `_countries` VALUES ('AZ', 'Azerbaijan', 'Commonwealth of Independent States', 'Baku (Baki)', 'Azerbaijani Manat');
INSERT INTO `_countries` VALUES ('BA', 'Bosnia and Herzegovina', 'Bosnia and Herzegovina, Europe', 'Sarajevo', 'Convertible Marka');
INSERT INTO `_countries` VALUES ('BB', 'Barbados', 'Central America and the Caribbean', 'Bridgetown', 'Barbados Dollar');
INSERT INTO `_countries` VALUES ('BD', 'Bangladesh', 'Asia', 'Dhaka', 'Taka');
INSERT INTO `_countries` VALUES ('BE', 'Belgium', 'Europe', 'Brussels', 'Euro');
INSERT INTO `_countries` VALUES ('BF', 'Burkina Faso', 'Africa', 'Ouagadougou', 'CFA Franc BCEAO');
INSERT INTO `_countries` VALUES ('BG', 'Bulgaria', 'Europe', 'Sofia', 'Lev');
INSERT INTO `_countries` VALUES ('BH', 'Bahrain', 'Middle East', 'Manama', 'Bahraini Dinar');
INSERT INTO `_countries` VALUES ('BI', 'Burundi', 'Africa', 'Bujumbura', 'Burundi Franc');
INSERT INTO `_countries` VALUES ('BJ', 'Benin', 'Africa', 'Porto-Novo', 'CFA Franc BCEAO');
INSERT INTO `_countries` VALUES ('BM', 'Bermuda', 'North America', 'Hamilton', 'Bermudian Dollar');
INSERT INTO `_countries` VALUES ('BN', 'Brunei Darussalam', 'Southeast Asia', 'Bandar Seri Begawan', 'Brunei Dollar');
INSERT INTO `_countries` VALUES ('BO', 'Bolivia', 'South America', 'La Paz /Sucre', 'Boliviano');
INSERT INTO `_countries` VALUES ('BR', 'Brazil', 'South America', 'Brasilia', 'Brazilian Real');
INSERT INTO `_countries` VALUES ('BS', 'The Bahamas', 'Central America and the Caribbean', 'Nassau', 'Bahamian Dollar');
INSERT INTO `_countries` VALUES ('BT', 'Bhutan', 'Asia', 'Thimphu', 'Ngultrum');
INSERT INTO `_countries` VALUES ('BV', 'Bouvet Island', 'Antarctic Region', '--', 'Norwegian Krone');
INSERT INTO `_countries` VALUES ('BW', 'Botswana', 'Africa', 'Gaborone', 'Pula');
INSERT INTO `_countries` VALUES ('BY', 'Belarus', 'Commonwealth of Independent States', 'Minsk', 'Belarussian Ruble');
INSERT INTO `_countries` VALUES ('BZ', 'Belize', 'Central America and the Caribbean', 'Belmopan', 'Belize Dollar');
INSERT INTO `_countries` VALUES ('CA', 'Canada', 'North America', 'Ottawa', 'Canadian Dollar');
INSERT INTO `_countries` VALUES ('CC', 'Cocos (Keeling) Islands', 'Southeast Asia', 'West Island', 'Australian Dollar');
INSERT INTO `_countries` VALUES ('CD', 'Congo, Democratic Republic of the', 'Africa', 'Kinshasa', 'Franc Congolais');
INSERT INTO `_countries` VALUES ('CF', 'Central African Republic', 'Africa', 'Bangui', 'CFA Franc BEAC');
INSERT INTO `_countries` VALUES ('CG', 'Congo, Republic of the', 'Africa', 'Brazzaville', 'CFA Franc BEAC');
INSERT INTO `_countries` VALUES ('CH', 'Switzerland', 'Europe', 'Bern', 'Swiss Franc');
INSERT INTO `_countries` VALUES ('CI', 'Cote d''Ivoire', 'Africa', 'Yamoussoukro', 'CFA Franc BCEAO');
INSERT INTO `_countries` VALUES ('CK', 'Cook Islands', 'Oceania', 'Avarua', 'New Zealand Dollar');
INSERT INTO `_countries` VALUES ('CL', 'Chile', 'South America', 'Santiago', 'Chilean Peso');
INSERT INTO `_countries` VALUES ('CM', 'Cameroon', 'Africa', 'Yaounde', 'CFA Franc BEAC');
INSERT INTO `_countries` VALUES ('CN', 'China', 'Asia', 'Beijing', 'Yuan Renminbi');
INSERT INTO `_countries` VALUES ('CO', 'Colombia', 'South America, Central America and the Caribbean', 'Bogota', 'Colombian Peso');
INSERT INTO `_countries` VALUES ('CR', 'Costa Rica', 'Central America and the Caribbean', 'San Jose', 'Costa Rican Colon');
INSERT INTO `_countries` VALUES ('CU', 'Cuba', 'Central America and the Caribbean', 'Havana', 'Cuban Peso');
INSERT INTO `_countries` VALUES ('CV', 'Cape Verde', 'World', 'Praia', 'Cape Verdean Escudo');
INSERT INTO `_countries` VALUES ('CX', 'Christmas Island', 'Southeast Asia', 'The Settlement', 'Australian Dollar');
INSERT INTO `_countries` VALUES ('CY', 'Cyprus', 'Middle East', 'Nicosia', 'Cyprus Pound');
INSERT INTO `_countries` VALUES ('CZ', 'Czech Republic', 'Europe', 'Prague', 'Czech Koruna');
INSERT INTO `_countries` VALUES ('DE', 'Germany', 'Europe', 'Berlin', 'Euro');
INSERT INTO `_countries` VALUES ('DJ', 'Djibouti', 'Africa', 'Djibouti', 'Djibouti Franc');
INSERT INTO `_countries` VALUES ('DK', 'Denmark', 'Europe', 'Copenhagen', 'Danish Krone');
INSERT INTO `_countries` VALUES ('DM', 'Dominica', 'Central America and the Caribbean', 'Roseau', 'East Caribbean Dollar');
INSERT INTO `_countries` VALUES ('DO', 'Dominican Republic', 'Central America and the Caribbean', 'Santo Domingo', 'Dominican Peso');
INSERT INTO `_countries` VALUES ('DZ', 'Algeria', 'Africa', 'Algiers', 'Algerian Dinar');
INSERT INTO `_countries` VALUES ('EC', 'Ecuador', 'South America', 'Quito', 'US dollar');
INSERT INTO `_countries` VALUES ('EE', 'Estonia', 'Europe', 'Tallinn', 'Kroon');
INSERT INTO `_countries` VALUES ('EG', 'Egypt', 'Africa', 'Cairo', 'Egyptian Pound');
INSERT INTO `_countries` VALUES ('EH', 'Western Sahara', 'Africa', '--', 'Moroccan Dirham');
INSERT INTO `_countries` VALUES ('ER', 'Eritrea', 'Africa', 'Asmara', 'Nakfa');
INSERT INTO `_countries` VALUES ('ES', 'Spain', 'Europe', 'Madrid', 'Euro');
INSERT INTO `_countries` VALUES ('ET', 'Ethiopia', 'Africa', 'Addis Ababa', 'Ethiopian Birr');
INSERT INTO `_countries` VALUES ('FI', 'Finland', 'Europe', 'Helsinki', 'Euro');
INSERT INTO `_countries` VALUES ('FJ', 'Fiji', 'Oceania', 'Suva', 'Fijian Dollar');
INSERT INTO `_countries` VALUES ('FK', 'Falkland Islands (Islas Malvinas)', 'South America', 'Stanley', 'Falkland Islands Pound');
INSERT INTO `_countries` VALUES ('FM', 'Micronesia, Federated States of', 'Oceania', 'Palikir', 'US dollar');
INSERT INTO `_countries` VALUES ('FO', 'Faroe Islands', 'Europe', 'Torshavn', 'Danish Krone');
INSERT INTO `_countries` VALUES ('FR', 'France', 'Europe', 'Paris', 'Euro');
INSERT INTO `_countries` VALUES ('FX', 'France, Metropolitan', '', '--', 'Euro');
INSERT INTO `_countries` VALUES ('GA', 'Gabon', 'Africa', 'Libreville', 'CFA Franc BEAC');
INSERT INTO `_countries` VALUES ('GD', 'Grenada', 'Central America and the Caribbean', 'Saint George''s', 'East Caribbean Dollar');
INSERT INTO `_countries` VALUES ('GE', 'Georgia', 'Commonwealth of Independent States', 'T''bilisi', 'Lari');
INSERT INTO `_countries` VALUES ('GF', 'French Guiana', 'South America', 'Cayenne', 'Euro');
INSERT INTO `_countries` VALUES ('GG', 'Guernsey', 'Europe', 'Saint Peter Port', 'Pound Sterling');
INSERT INTO `_countries` VALUES ('GH', 'Ghana', 'Africa', 'Accra', 'Cedi');
INSERT INTO `_countries` VALUES ('GI', 'Gibraltar', 'Europe', 'Gibraltar', 'Gibraltar Pound');
INSERT INTO `_countries` VALUES ('GL', 'Greenland', 'Arctic Region', 'Nuuk', 'Danish Krone');
INSERT INTO `_countries` VALUES ('GM', 'The Gambia', 'Africa', 'Banjul', 'Dalasi');
INSERT INTO `_countries` VALUES ('GN', 'Guinea', 'Africa', 'Conakry', 'Guinean Franc');
INSERT INTO `_countries` VALUES ('GP', 'Guadeloupe', 'Central America and the Caribbean', 'Basse-Terre', 'Euro');
INSERT INTO `_countries` VALUES ('GQ', 'Equatorial Guinea', 'Africa', 'Malabo', 'CFA Franc BEAC');
INSERT INTO `_countries` VALUES ('GR', 'Greece', 'Europe', 'Athens', 'Euro');
INSERT INTO `_countries` VALUES ('GS', 'South Georgia and the South Sandwich Islands', 'Antarctic Region', '--', 'Pound Sterling');
INSERT INTO `_countries` VALUES ('GT', 'Guatemala', 'Central America and the Caribbean', 'Guatemala', 'Quetzal');
INSERT INTO `_countries` VALUES ('GU', 'Guam', 'Oceania', 'Hagatna', 'US Dollar');
INSERT INTO `_countries` VALUES ('GW', 'Guinea-Bissau', 'Africa', 'Bissau', 'CFA Franc BCEAO');
INSERT INTO `_countries` VALUES ('GY', 'Guyana', 'South America', 'Georgetown', 'Guyana Dollar');
INSERT INTO `_countries` VALUES ('HK', 'Hong Kong (SAR)', 'Southeast Asia', 'Hong Kong', 'Hong Kong Dollar');
INSERT INTO `_countries` VALUES ('HM', 'Heard Island and McDonald Islands', 'Antarctic Region', '--', 'Australian Dollar');
INSERT INTO `_countries` VALUES ('HN', 'Honduras', 'Central America and the Caribbean', 'Tegucigalpa', 'Lempira');
INSERT INTO `_countries` VALUES ('HR', 'Croatia', 'Europe', 'Zagreb', 'Kuna');
INSERT INTO `_countries` VALUES ('HT', 'Haiti', 'Central America and the Caribbean', 'Port-au-Prince', 'Gourde');
INSERT INTO `_countries` VALUES ('HU', 'Hungary', 'Europe', 'Budapest', 'Forint');
INSERT INTO `_countries` VALUES ('ID', 'Indonesia', 'Southeast Asia', 'Jakarta', 'Rupiah');
INSERT INTO `_countries` VALUES ('IE', 'Ireland', 'Europe', 'Dublin', 'Euro');
INSERT INTO `_countries` VALUES ('IL', 'Israel', 'Middle East', 'Jerusalem', 'New Israeli Sheqel');
INSERT INTO `_countries` VALUES ('IM', 'Man, Isle of', 'Europe', 'Douglas', 'Pound Sterling');
INSERT INTO `_countries` VALUES ('IN', 'India', 'Asia', 'New Delhi', 'Indian Rupee');
INSERT INTO `_countries` VALUES ('IO', 'British Indian Ocean Territory', 'World', '--', 'US Dollar');
INSERT INTO `_countries` VALUES ('IQ', 'Iraq', 'Middle East', 'Baghdad', 'Iraqi Dinar');
INSERT INTO `_countries` VALUES ('IR', 'Iran', 'Middle East', 'Tehran', 'Iranian Rial');
INSERT INTO `_countries` VALUES ('IS', 'Iceland', 'Arctic Region', 'Reykjavik', 'Iceland Krona');
INSERT INTO `_countries` VALUES ('IT', 'Italy', 'Europe', 'Rome', 'Euro');
INSERT INTO `_countries` VALUES ('JE', 'Jersey', 'Europe', 'Saint Helier', 'Pound Sterling');
INSERT INTO `_countries` VALUES ('JM', 'Jamaica', 'Central America and the Caribbean', 'Kingston', 'Jamaican dollar');
INSERT INTO `_countries` VALUES ('JO', 'Jordan', 'Middle East', 'Amman', 'Jordanian Dinar');
INSERT INTO `_countries` VALUES ('JP', 'Japan', 'Asia', 'Tokyo', 'Yen');
INSERT INTO `_countries` VALUES ('KE', 'Kenya', 'Africa', 'Nairobi', 'Kenyan shilling');
INSERT INTO `_countries` VALUES ('KG', 'Kyrgyzstan', 'Commonwealth of Independent States', 'Bishkek', 'Som');
INSERT INTO `_countries` VALUES ('KH', 'Cambodia', 'Southeast Asia', 'Phnom Penh', 'Riel');
INSERT INTO `_countries` VALUES ('KI', 'Kiribati', 'Oceania', 'Tarawa', 'Australian dollar');
INSERT INTO `_countries` VALUES ('KM', 'Comoros', 'Africa', 'Moroni', 'Comoro Franc');
INSERT INTO `_countries` VALUES ('KN', 'Saint Kitts and Nevis', 'Central America and the Caribbean', 'Basseterre', 'East Caribbean Dollar');
INSERT INTO `_countries` VALUES ('KP', 'Korea, North', 'Asia', 'P''yongyang', 'North Korean Won');
INSERT INTO `_countries` VALUES ('KR', 'Korea, South', 'Asia', 'Seoul', 'Won');
INSERT INTO `_countries` VALUES ('KW', 'Kuwait', 'Middle East', 'Kuwait', 'Kuwaiti Dinar');
INSERT INTO `_countries` VALUES ('KY', 'Cayman Islands', 'Central America and the Caribbean', 'George Town', 'Cayman Islands Dollar');
INSERT INTO `_countries` VALUES ('KZ', 'Kazakhstan', 'Commonwealth of Independent States', 'Astana', 'Tenge');
INSERT INTO `_countries` VALUES ('LA', 'Laos', 'Southeast Asia', 'Vientiane', 'Kip');
INSERT INTO `_countries` VALUES ('LB', 'Lebanon', 'Middle East', 'Beirut', 'Lebanese Pound');
INSERT INTO `_countries` VALUES ('LC', 'Saint Lucia', 'Central America and the Caribbean', 'Castries', 'East Caribbean Dollar');
INSERT INTO `_countries` VALUES ('LI', 'Liechtenstein', 'Europe', 'Vaduz', 'Swiss Franc');
INSERT INTO `_countries` VALUES ('LK', 'Sri Lanka', 'Asia', 'Colombo', 'Sri Lanka Rupee');
INSERT INTO `_countries` VALUES ('LR', 'Liberia', 'Africa', 'Monrovia', 'Liberian Dollar');
INSERT INTO `_countries` VALUES ('LS', 'Lesotho', 'Africa', 'Maseru', 'Loti');
INSERT INTO `_countries` VALUES ('LT', 'Lithuania', 'Europe', 'Vilnius', 'Lithuanian Litas');
INSERT INTO `_countries` VALUES ('LU', 'Luxembourg', 'Europe', 'Luxembourg', 'Euro');
INSERT INTO `_countries` VALUES ('LV', 'Latvia', 'Europe', 'Riga', 'Latvian Lats');
INSERT INTO `_countries` VALUES ('LY', 'Libya', 'Africa', 'Tripoli', 'Libyan Dinar');
INSERT INTO `_countries` VALUES ('MA', 'Morocco', 'Africa', 'Rabat', 'Moroccan Dirham');
INSERT INTO `_countries` VALUES ('MC', 'Monaco', 'Europe', 'Monaco', 'Euro');
INSERT INTO `_countries` VALUES ('MD', 'Moldova', 'Commonwealth of Independent States', 'Chisinau', 'Moldovan Leu');
INSERT INTO `_countries` VALUES ('MG', 'Madagascar', 'Africa', 'Antananarivo', 'Malagasy Franc');
INSERT INTO `_countries` VALUES ('MH', 'Marshall Islands', 'Oceania', 'Majuro', 'US dollar');
INSERT INTO `_countries` VALUES ('MK', 'Macedonia, The Former Yugoslav Republic of', 'Europe', 'Skopje', 'Denar');
INSERT INTO `_countries` VALUES ('ML', 'Mali', 'Africa', 'Bamako', 'CFA Franc BCEAO');
INSERT INTO `_countries` VALUES ('MM', 'Burma', 'Southeast Asia', 'Rangoon', 'kyat');
INSERT INTO `_countries` VALUES ('MN', 'Mongolia', 'Asia', 'Ulaanbaatar', 'Tugrik');
INSERT INTO `_countries` VALUES ('MO', 'Macao', 'Southeast Asia', 'Macao', 'Pataca');
INSERT INTO `_countries` VALUES ('MP', 'Northern Mariana Islands', 'Oceania', 'Saipan', 'US Dollar');
INSERT INTO `_countries` VALUES ('MQ', 'Martinique', 'Central America and the Caribbean', 'Fort-de-France', 'Euro');
INSERT INTO `_countries` VALUES ('MR', 'Mauritania', 'Africa', 'Nouakchott', 'Ouguiya');
INSERT INTO `_countries` VALUES ('MS', 'Montserrat', 'Central America and the Caribbean', 'Plymouth', 'East Caribbean Dollar');
INSERT INTO `_countries` VALUES ('MT', 'Malta', 'Europe', 'Valletta', 'Maltese Lira');
INSERT INTO `_countries` VALUES ('MU', 'Mauritius', 'World', 'Port Louis', 'Mauritius Rupee');
INSERT INTO `_countries` VALUES ('MV', 'Maldives', 'Asia', 'Male', 'Rufiyaa');
INSERT INTO `_countries` VALUES ('MW', 'Malawi', 'Africa', 'Lilongwe', 'Kwacha');
INSERT INTO `_countries` VALUES ('MX', 'Mexico', 'North America', 'Mexico', 'Mexican Peso');
INSERT INTO `_countries` VALUES ('MY', 'Malaysia', 'Southeast Asia', 'Kuala Lumpur', 'Malaysian Ringgit');
INSERT INTO `_countries` VALUES ('MZ', 'Mozambique', 'Africa', 'Maputo', 'Metical');
INSERT INTO `_countries` VALUES ('NA', 'Namibia', 'Africa', 'Windhoek', 'Namibian Dollar');
INSERT INTO `_countries` VALUES ('NC', 'New Caledonia', 'Oceania', 'Noumea', 'CFP Franc');
INSERT INTO `_countries` VALUES ('NE', 'Niger', 'Africa', 'Niamey', 'CFA Franc BCEAO');
INSERT INTO `_countries` VALUES ('NF', 'Norfolk Island', 'Oceania', 'Kingston', 'Australian Dollar');
INSERT INTO `_countries` VALUES ('NG', 'Nigeria', 'Africa', 'Abuja', 'Naira');
INSERT INTO `_countries` VALUES ('NI', 'Nicaragua', 'Central America and the Caribbean', 'Managua', 'Cordoba Oro');
INSERT INTO `_countries` VALUES ('NL', 'Netherlands', 'Europe', 'Amsterdam', 'Euro');
INSERT INTO `_countries` VALUES ('NO', 'Norway', 'Europe', 'Oslo', 'Norwegian Krone');
INSERT INTO `_countries` VALUES ('NP', 'Nepal', 'Asia', 'Kathmandu', 'Nepalese Rupee');
INSERT INTO `_countries` VALUES ('NR', 'Nauru', 'Oceania', '--', 'Australian Dollar');
INSERT INTO `_countries` VALUES ('NU', 'Niue', 'Oceania', 'Alofi', 'New Zealand Dollar');
INSERT INTO `_countries` VALUES ('NZ', 'New Zealand', 'Oceania', 'Wellington', 'New Zealand Dollar');
INSERT INTO `_countries` VALUES ('OM', 'Oman', 'Middle East', 'Muscat', 'Rial Omani');
INSERT INTO `_countries` VALUES ('PA', 'Panama', 'Central America and the Caribbean', 'Panama', 'balboa');
INSERT INTO `_countries` VALUES ('PE', 'Peru', 'South America', 'Lima', 'Nuevo Sol');
INSERT INTO `_countries` VALUES ('PF', 'French Polynesia', 'Oceania', 'Papeete', 'CFP Franc');
INSERT INTO `_countries` VALUES ('PG', 'Papua New Guinea', 'Oceania', 'Port Moresby', 'Kina');
INSERT INTO `_countries` VALUES ('PH', 'Philippines', 'Southeast Asia', 'Manila', 'Philippine Peso');
INSERT INTO `_countries` VALUES ('PK', 'Pakistan', 'Asia', 'Islamabad', 'Pakistan Rupee');
INSERT INTO `_countries` VALUES ('PL', 'Poland', 'Europe', 'Warsaw', 'Zloty');
INSERT INTO `_countries` VALUES ('PM', 'Saint Pierre and Miquelon', 'North America', 'Saint-Pierre', 'Euro');
INSERT INTO `_countries` VALUES ('PN', 'Pitcairn Islands', 'Oceania', 'Adamstown', 'New Zealand Dollar');
INSERT INTO `_countries` VALUES ('PR', 'Puerto Rico', 'Central America and the Caribbean', 'San Juan', 'US dollar');
INSERT INTO `_countries` VALUES ('PS', 'Palestinian Territory, Occupied', '', '--', '');
INSERT INTO `_countries` VALUES ('PT', 'Portugal', 'Europe', 'Lisbon', 'Euro');
INSERT INTO `_countries` VALUES ('PW', 'Palau', 'Oceania', 'Koror', 'US dollar');
INSERT INTO `_countries` VALUES ('PY', 'Paraguay', 'South America', 'Asuncion', 'Guarani');
INSERT INTO `_countries` VALUES ('QA', 'Qatar', 'Middle East', 'Doha', 'Qatari Rial');
INSERT INTO `_countries` VALUES ('RE', 'R?union', 'World', 'Saint-Denis', 'Euro');
INSERT INTO `_countries` VALUES ('RO', 'Romania', 'Europe', 'Bucharest', 'Leu');
INSERT INTO `_countries` VALUES ('RU', 'Russia', 'Asia', 'Moscow', 'Russian Ruble');
INSERT INTO `_countries` VALUES ('RW', 'Rwanda', 'Africa', 'Kigali', 'Rwanda Franc');
INSERT INTO `_countries` VALUES ('SA', 'Saudi Arabia', 'Middle East', 'Riyadh', 'Saudi Riyal');
INSERT INTO `_countries` VALUES ('SB', 'Solomon Islands', 'Oceania', 'Honiara', 'Solomon Islands Dollar');
INSERT INTO `_countries` VALUES ('SC', 'Seychelles', 'Africa', 'Victoria', 'Seychelles Rupee');
INSERT INTO `_countries` VALUES ('SD', 'Sudan', 'Africa', 'Khartoum', 'Sudanese Dinar');
INSERT INTO `_countries` VALUES ('SE', 'Sweden', 'Europe', 'Stockholm', 'Swedish Krona');
INSERT INTO `_countries` VALUES ('SG', 'Singapore', 'Southeast Asia', 'Singapore', 'Singapore Dollar');
INSERT INTO `_countries` VALUES ('SH', 'Saint Helena', 'Africa', 'Jamestown', 'Saint Helenian Pound');
INSERT INTO `_countries` VALUES ('SI', 'Slovenia', 'Europe', 'Ljubljana', 'Tolar');
INSERT INTO `_countries` VALUES ('SJ', 'Svalbard', 'Arctic Region', 'Longyearbyen', 'Norwegian Krone');
INSERT INTO `_countries` VALUES ('SK', 'Slovakia', 'Europe', 'Bratislava', 'Slovak Koruna');
INSERT INTO `_countries` VALUES ('SL', 'Sierra Leone', 'Africa', 'Freetown', 'Leone');
INSERT INTO `_countries` VALUES ('SM', 'San Marino', 'Europe', 'San Marino', 'Euro');
INSERT INTO `_countries` VALUES ('SN', 'Senegal', 'Africa', 'Dakar', 'CFA Franc BCEAO');
INSERT INTO `_countries` VALUES ('SO', 'Somalia', 'Africa', 'Mogadishu', 'Somali Shilling');
INSERT INTO `_countries` VALUES ('SR', 'Suriname', 'South America', 'Paramaribo', 'Suriname Guilder');
INSERT INTO `_countries` VALUES ('ST', 'S?o Tom?and Pr?ncipe', 'Africa', 'Sao Tome', 'Dobra');
INSERT INTO `_countries` VALUES ('SV', 'El Salvador', 'Central America and the Caribbean', 'San Salvador', 'El Salvador Colon');
INSERT INTO `_countries` VALUES ('SY', 'Syria', 'Middle East', 'Damascus', 'Syrian Pound');
INSERT INTO `_countries` VALUES ('SZ', 'Swaziland', 'Africa', 'Mbabane', 'Lilangeni');
INSERT INTO `_countries` VALUES ('TC', 'Turks and Caicos Islands', 'Central America and the Caribbean', 'Cockburn Town', 'US Dollar');
INSERT INTO `_countries` VALUES ('TD', 'Chad', 'Africa', 'N''Djamena', 'CFA Franc BEAC');
INSERT INTO `_countries` VALUES ('TF', 'French Southern and Antarctic Lands', 'Antarctic Region', '--', 'Euro');
INSERT INTO `_countries` VALUES ('TG', 'Togo', 'Africa', 'Lome', 'CFA Franc BCEAO');
INSERT INTO `_countries` VALUES ('TH', 'Thailand', 'Southeast Asia', 'Bangkok', 'Baht');
INSERT INTO `_countries` VALUES ('TJ', 'Tajikistan', 'Commonwealth of Independent States', 'Dushanbe', 'Somoni');
INSERT INTO `_countries` VALUES ('TK', 'Tokelau', 'Oceania', '--', 'New Zealand Dollar');
INSERT INTO `_countries` VALUES ('TM', 'Turkmenistan', 'Commonwealth of Independent States', 'Ashgabat', 'Manat');
INSERT INTO `_countries` VALUES ('TN', 'Tunisia', 'Africa', 'Tunis', 'Tunisian Dinar');
INSERT INTO `_countries` VALUES ('TO', 'Tonga', 'Oceania', 'Nuku''alofa', 'Pa''anga');
INSERT INTO `_countries` VALUES ('TP', 'East Timor', '', '--', 'Timor Escudo');
INSERT INTO `_countries` VALUES ('TR', 'Turkey', 'Middle East', 'Ankara', 'Turkish Lira');
INSERT INTO `_countries` VALUES ('TT', 'Trinidad and Tobago', 'Central America and the Caribbean', 'Port-of-Spain', 'Trinidad and Tobago Dollar');
INSERT INTO `_countries` VALUES ('TV', 'Tuvalu', 'Oceania', 'Funafuti', 'Australian Dollar');
INSERT INTO `_countries` VALUES ('TW', 'Taiwan', 'Southeast Asia', 'Taipei', 'New Taiwan Dollar');
INSERT INTO `_countries` VALUES ('TZ', 'Tanzania', 'Africa', 'Dar es Salaam', 'Tanzanian Shilling');
INSERT INTO `_countries` VALUES ('UA', 'Ukraine', 'Commonwealth of Independent States', 'Kiev', 'Hryvnia');
INSERT INTO `_countries` VALUES ('UG', 'Uganda', 'Africa', 'Kampala', 'Uganda Shilling');
INSERT INTO `_countries` VALUES ('UK', 'United Kingdom', 'Europe', 'London', 'Pound Sterling');
INSERT INTO `_countries` VALUES ('UM', 'United States Minor Outlying Islands', '', '--', 'US Dollar');
INSERT INTO `_countries` VALUES ('US', 'United States', 'North America', 'Washington, DC', 'US Dollar');
INSERT INTO `_countries` VALUES ('UY', 'Uruguay', 'South America', 'Montevideo', 'Peso Uruguayo');
INSERT INTO `_countries` VALUES ('UZ', 'Uzbekistan', 'Commonwealth of Independent States', 'Tashkent', 'Uzbekistan Sum');
INSERT INTO `_countries` VALUES ('VA', 'Holy See (Vatican City)', 'Europe', 'Vatican City', 'Euro');
INSERT INTO `_countries` VALUES ('VC', 'Saint Vincent and the Grenadines', 'Central America and the Caribbean', 'Kingstown', 'East Caribbean Dollar');
INSERT INTO `_countries` VALUES ('VE', 'Venezuela', 'South America, Central America and the Caribbean', 'Caracas', 'Bolivar');
INSERT INTO `_countries` VALUES ('VG', 'British Virgin Islands', 'Central America and the Caribbean', 'Road Town', 'US dollar');
INSERT INTO `_countries` VALUES ('VI', 'Virgin Islands', 'Central America and the Caribbean', 'Charlotte Amalie', 'US Dollar');
INSERT INTO `_countries` VALUES ('VN', 'Vietnam', 'Southeast Asia', 'Hanoi', 'Dong');
INSERT INTO `_countries` VALUES ('VU', 'Vanuatu', 'Oceania', 'Port-Vila', 'Vatu');
INSERT INTO `_countries` VALUES ('WF', 'Wallis and Futuna', 'Oceania', 'Mata-Utu', 'CFP Franc');
INSERT INTO `_countries` VALUES ('WS', 'Samoa', 'Oceania', 'Apia', 'Tala');
INSERT INTO `_countries` VALUES ('YE', 'Yemen', 'Middle East', 'Sanaa', 'Yemeni Rial');
INSERT INTO `_countries` VALUES ('YT', 'Mayotte', 'Africa', 'Mamoutzou', 'Euro');
INSERT INTO `_countries` VALUES ('YU', 'Yugoslavia', 'Europe', 'Belgrade', 'Yugoslavian Dinar');
INSERT INTO `_countries` VALUES ('ZA', 'South Africa', 'Africa', 'Pretoria', 'Rand');
INSERT INTO `_countries` VALUES ('ZM', 'Zambia', 'Africa', 'Lusaka', 'Kwacha');
INSERT INTO `_countries` VALUES ('ZW', 'Zimbabwe', 'Africa', 'Harare', 'Zimbabwe Dollar');
INSERT INTO `_countries` VALUES ('PX', 'Proxy Server', 'Internet', '', '');
INSERT INTO `_countries` VALUES ('EU', 'European Union', 'Europe', 'none', 'Euro');

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

-- 
-- Table structure for table `application`
-- 

CREATE TABLE `application` (
  `applyid` int(11) NOT NULL auto_increment,
  `views` int(11) NOT NULL default '0',
  `lastpost` text NOT NULL,
  `lastpostno` int(11) NOT NULL default '0',
  `IGN` text NOT NULL,
  `Level` text NOT NULL,
  `Race` text NOT NULL,
  `Class` text NOT NULL,
  `Build` text NOT NULL,
  `Alla` text NOT NULL,
  `Guilds` text NOT NULL,
  `Reasons` text NOT NULL,
  `Rname` text NOT NULL,
  `Age` text NOT NULL,
  `Country` text NOT NULL,
  `Email` text NOT NULL,
  `Misc` text NOT NULL,
  `Reject` text NOT NULL,
  `Seen` text NOT NULL,
  `resarc` text NOT NULL,
  `resfir` text NOT NULL,
  `resfro` text NOT NULL,
  `resnat` text NOT NULL,
  `ressha` text NOT NULL,
  `attony` text NOT NULL,
  `attmc` text NOT NULL,
  `attbwl` text NOT NULL,
  `attnax` text NOT NULL,
  `pastxp` text NOT NULL,
  `raidtimes` text NOT NULL,
  `voicecomms` text NOT NULL,
  `voicemic` text NOT NULL,
  `mods` text NOT NULL,
  `leaving` text NOT NULL,
  PRIMARY KEY  (`applyid`)
) ENGINE=MyISAM;


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

-- 
-- Table structure for table `backup_boss`
-- 

CREATE TABLE `backup_boss` (
  `boss` text NOT NULL,
  `status` text NOT NULL,
  `id` int(11) NOT NULL default '0',
  `boss_order` int(11) NOT NULL default '0'
) ENGINE=MyISAM;


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

-- 
-- Table structure for table `ip`
-- 

CREATE TABLE `ip` (
  `id` text NOT NULL
) ENGINE=MyISAM;



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

-- 
-- Table structure for table `online`
-- 

CREATE TABLE `online` (
  `onlineid` int(11) NOT NULL auto_increment,
  `ipaddress` text NOT NULL,
  `lastactive` int(11) NOT NULL default '0',
  `id` varchar(13) NOT NULL default '',
  `charactername` text NOT NULL,
  `country` text NOT NULL,
  PRIMARY KEY  (`onlineid`)
) ENGINE=MyISAM;


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

-- 
-- Table structure for table `raid`
-- 

CREATE TABLE `raid` (
  `raid_id` int(11) NOT NULL auto_increment,
  `date` text NOT NULL,
  `instance` text NOT NULL,
  `druid` text NOT NULL,
  `hunter` text NOT NULL,
  `mage` text NOT NULL,
  `paladin` text NOT NULL,
  `priest` text NOT NULL,
  `rogue` text NOT NULL,
  `warlock` text NOT NULL,
  `warrior` text NOT NULL,
  `max` text NOT NULL,
  `time` text NOT NULL,
  `status` text NOT NULL,
  `inv_time` text NOT NULL,
  `leader` text NOT NULL,
  `old` text NOT NULL,
  `raidday` text NOT NULL,
  `raidmonth` text NOT NULL,
  PRIMARY KEY  (`raid_id`)
) ENGINE=MyISAM;



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

-- 
-- Table structure for table `signup`
-- 

CREATE TABLE `signup` (
  `signup_id` int(11) NOT NULL auto_increment,
  `raid_id` text NOT NULL,
  `user_id` text NOT NULL,
  `comment` text NOT NULL,
  `going` text NOT NULL,
  `charname` text NOT NULL,
  `class` text NOT NULL,
  `race` text NOT NULL,
  `alla` text NOT NULL,
  `time` text NOT NULL,
  PRIMARY KEY  (`signup_id`)
) ENGINE=MyISAM;



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

-- 
-- Table structure for table `upload`
-- 

CREATE TABLE `upload` (
  `ID` int(11) NOT NULL auto_increment,
  `Title` text NOT NULL,
  `Link` text NOT NULL,
  `User` text NOT NULL,
  `Date` text NOT NULL,
  `Display` text NOT NULL,
  PRIMARY KEY  (`ID`)
) ENGINE=MyISAM;

