CREATE DATABASE IF NOT EXISTS `test_project`;

USE `test_project`;

SET foreign_key_checks = 0;

DROP TABLE IF EXISTS `2_city`;

CREATE TABLE `2_city` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `city` varchar(255) NOT NULL DEFAULT 'none',
  `region` varchar(255) NOT NULL DEFAULT 'none',
  `country` varchar(255) NOT NULL DEFAULT 'none',
  `status` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=507 DEFAULT CHARSET=latin1;

INSERT INTO `2_city` VALUES (52,"Makati City","Luzon","Philippines","0"),
(53,"Caloocan City","Luzon","Philippines","0"),
(54,"Alaminos City","Luzon","Philippines","0"),
(55,"Angeles City","Luzon","Philippines","0"),
(56,"Antipolo City","Luzon","Philippines","0"),
(57,"Baguio City","Luzon","Philippines","0"),
(58,"Balanga City","Luzon","Philippines","0"),
(59,"Batangas City","Luzon","Philippines","0"),
(60,"BiÃ±an City","Luzon","Philippines","0"),
(61,"Cabanatuan City","Luzon","Philippines","0"),
(62,"Calamba City","Luzon","Philippines","0"),
(63,"Calapan City","Luzon","Philippines","0"),
(64,"Caloocan City","Luzon","Philippines","0"),
(65,"Candon City","Luzon","Philippines","0"),
(66,"Cauayan City","Luzon","Philippines","0"),
(67,"Cavite City","Luzon","Philippines","0"),
(68,"Dagupan City","Luzon","Philippines","0"),
(69,"DasmariÃ±as City","Luzon","Philippines","0"),
(70,"Gapan City","Luzon","Philippines","0"),
(71,"Iriga City","Luzon","Philippines","0"),
(72,"Laoag City","Luzon","Philippines","0"),
(73,"Las Pinas City","Luzon","Philippines","0"),
(74,"Legazpi City","Luzon","Philippines","0"),
(75,"Ligao City","Luzon","Philippines","0"),
(76,"Lipa City","Luzon","Philippines","0"),
(77,"Lucena City","Luzon","Philippines","0"),
(78,"Malabon City","Luzon","Philippines","0"),
(79,"Malolos City","Luzon","Philippines","0"),
(80,"Mandaluyong City","Luzon","Philippines","0"),
(81,"Manila City","Luzon","Philippines","0"),
(82,"Marikina City","Luzon","Philippines","0"),
(83,"Masbate City","Luzon","Philippines","0"),
(84,"Meycauayan City","Luzon","Philippines","0"),
(85,"MuÃ±oz City","Luzon","Philippines","0"),
(86,"Muntinlupa City","Luzon","Philippines","0"),
(87,"Naga City","Luzon","Philippines","0"),
(88,"Navotas City","Luzon","Philippines","0"),
(89,"Olongapo City","Luzon","Philippines","0"),
(90,"Palayan City","Luzon","Philippines","0"),
(91,"ParaÃ±aque City","Luzon","Philippines","0"),
(92,"Pasay City","Luzon","Philippines","0"),
(93,"Pasig City","Luzon","Philippines","0"),
(94,"Puerto Princesa City","Luzon","Philippines","0"),
(95,"Quezon City","Luzon","Philippines","0"),
(96,"San Carlos City","Luzon","Philippines","0"),
(97,"San Fernando City LA union","Luzon","Philippines","0"),
(98,"San Fernando City, Pampanga","Luzon","Philippines","0"),
(99,"San Jose City","Luzon","Philippines","0"),
(100,"San Jose Del Monte City","Luzon","Philippines","0"),
(101,"San Juan City","Luzon","Philippines","0"),
(102,"San Pablo City","Luzon","Philippines","0"),
(103,"Santiago City","Luzon","Philippines","0"),
(104,"Sorsogon City","Luzon","Philippines","0"),
(105,"Sta. Rosa City","Luzon","Philippines","0"),
(106,"Tabaco City","Luzon","Philippines","0"),
(107,"Tagaytay City","Luzon","Philippines","0"),
(108,"Taguig City","Luzon","Philippines","0"),
(109,"Tanauan City","Luzon","Philippines","0"),
(110,"Tarlac City","Luzon","Philippines","0"),
(111,"Trece Martirez City","Luzon","Philippines","0"),
(112,"Tuguegarao City","Luzon","Philippines","0"),
(113,"Urdaneta City","Luzon","Philippines","0"),
(114,"Valenzuela City","Luzon","Philippines","0"),
(115,"Vigan City","Luzon","Philippines","0"),
(116,"Bacolod City","Visayas/Naga/Legaspi","Philippines","0"),
(117,"Bago City","Visayas/Naga/Legaspi","Philippines","0"),
(118,"Bais City","Visayas/Naga/Legaspi","Philippines","0"),
(119,"Bayawan  City","Visayas/Naga/Legaspi","Philippines","0"),
(120,"Cadiz City","Visayas/Naga/Legaspi","Philippines","0"),
(121,"Calbayog City","Visayas/Naga/Legaspi","Philippines","0"),
(122,"Canlaon City","Visayas/Naga/Legaspi","Philippines","0"),
(123,"Cebu City","Visayas/Naga/Legaspi","Philippines","0"),
(124,"Danao City","Visayas/Naga/Legaspi","Philippines","0"),
(125,"Dumaguete City","Visayas/Naga/Legaspi","Philippines","0"),
(126,"Escalante City","Visayas/Naga/Legaspi","Philippines","0"),
(127,"Himamaylan City","Visayas/Naga/Legaspi","Philippines","0"),
(128,"Iloilo City","Visayas/Naga/Legaspi","Philippines","0"),
(129,"Kabankalan City","Visayas/Naga/Legaspi","Philippines","0"),
(130,"La Carlota City","Visayas/Naga/Legaspi","Philippines","0"),
(131,"Lapu-Lapu City","Visayas/Naga/Legaspi","Philippines","0"),
(132,"Maasin City","Visayas/Naga/Legaspi","Philippines","0"),
(133,"Mandaue City","Visayas/Naga/Legaspi","Philippines","0"),
(134,"Ormoc City","Visayas/Naga/Legaspi","Philippines","0"),
(135,"Passi City","Visayas/Naga/Legaspi","Philippines","0"),
(136,"Roxas City","Visayas/Naga/Legaspi","Philippines","0"),
(137,"Sagay City","Visayas/Naga/Legaspi","Philippines","0"),
(138,"Tacloban City","Visayas/Naga/Legaspi","Philippines","0"),
(139,"Tagbilaran City","Visayas/Naga/Legaspi","Philippines","0"),
(140,"Butuan City","Mindanao","Philippines","0"),
(141,"Cagayan De Oro City","Mindanao","Philippines","0"),
(142,"Davao City","Mindanao","Philippines","0"),
(143,"Cotabato City","Mindanao","Philippines","0"),
(144,"Dipolog City","Mindanao","Philippines","0"),
(145,"Gen. Santos City","Mindanao","Philippines","0"),
(146,"Iligan City","Mindanao","Philippines","0"),
(147,"Kidapawan City","Mindanao","Philippines","0"),
(148,"Ozamiz City","Mindanao","Philippines","0"),
(149,"Pagadian City","Mindanao","Philippines","0"),
(150,"Surigao City","Mindanao","Philippines","0"),
(151,"Zamboanga City","Mindanao","Philippines","0"),
(152,"Cauayan City","Luzon","Philippines",1),
(153,"Laoag City","Luzon","Philippines",1),
(154,"Legazpi City","Luzon","Philippines",1),
(155,"Naga City","Luzon","Philippines",1),
(156,"Puerto Princesa City","Luzon","Philippines",1),
(157,"Tuguegarao City","Luzon","Philippines",1),
(158,"Bacolod City","Visayas/Naga/Legaspi","Philippines",1),
(159,"Cebu City","Visayas/Naga/Legaspi","Philippines",1),
(160,"Dumaguete City","Visayas/Naga/Legaspi","Philippines",1),
(161,"Iloilo City","Visayas/Naga/Legaspi","Philippines",1),
(162,"Roxas City","Visayas/Naga/Legaspi","Philippines",1),
(163,"Tacloban City","Visayas/Naga/Legaspi","Philippines",1),
(164,"Butuan City","Mindanao","Philippines",1),
(165,"Cagayan De Oro City","Mindanao","Philippines",1),
(166,"Cotabato City","Mindanao","Philippines",1),
(167,"Davao City","Mindanao","Philippines",1),
(168,"Gen. Santos City","Mindanao","Philippines",1),
(169,"Pagadian City","Mindanao","Philippines",1),
(170,"Surigao City","Mindanao","Philippines",1),
(171,"Zamboanga City","Mindanao","Philippines",1),
(172,"Perth","Western Australia","Australia",1),
(173,"Sydney ","New South Wales","Australia",1),
(174,"Tokyo","Kanto","Japan",1),
(175,"Nagoya","Chubu","Japan",1),
(176,"Osaka (kansai)","Kinki","Japan",1),
(177,"Beijing","Northeast China","China",1),
(178,"Ningbo","Northeast China","China",1),
(179,"Xian","South Central China","China",1),
(180,"Guangzhou (Canton)","South Central China","China",1),
(181,"Dammam","","Saudi Arabia",1),
(182,"Hongkong","Hong Kong Island","Hong Kong",1),
(183,"Kota Kinabalu","East Coast Region Malaysia","Malaysia",1),
(184,"Langkawi","Northern Region Malaysia","Malaysia",1),
(185,"Penang","Northern Region Malaysia","Malaysia",1),
(186,"Kuwait","Muhafazat al Asimah","Kuwait",1),
(187,"Macau","Macau Peninsula","Macau",1),
(188,"Taipei","Northern Taiwan","Taiwan",1),
(189,"Dubai","Abu Dhabi","United Arab Emirates",1),
(190,"Busan","Gwandong","South Korea",1),
(191,"Incheon","Gyeonggi","South Korea",1),
(192,"Singapore","Central Singpore","Singapore",1),
(193,"Salta","Argentine Northwest","Argentina",1),
(194,"Mendoza","Cuyo","Argentina",1),
(195,"San Juan","Cuyo","Argentina",1),
(196,"Darwin","Northern Territory","Australia",1),
(197,"Palmerston","Northern Territory","Australia",1),
(198,"Brisbane","Queensland","Australia",1),
(199,"Bundaberg","Queensland","Australia",1),
(200,"Cairns","Queensland","Australia",1),
(201,"Caloundra","Queensland","Australia",1),
(202,"Gladstone","Queensland","Australia",1),
(203,"Gold Coast","Queensland","Australia",1),
(204,"Gympie","Queensland","Australia",1),
(205,"Hervey Bay","Queensland","Australia",1),
(206,"Ipswich","Queensland","Australia",1),
(207,"Logan City","Queensland","Australia",1),
(208,"Mackay","Queensland","Australia",1),
(209,"Maryborough","Queensland","Australia",1),
(210,"Mount Isa","Queensland","Australia",1),
(211,"Rockhampton","Queensland","Australia",1),
(212,"Sunshine Coast","Queensland","Australia",1),
(213,"Toowoomba","Queensland","Australia",1),
(214,"Townsville","Queensland","Australia",1),
(215,"Adelaide","South Australia","Australia",1),
(216,"Mount Barker","South Australia","Australia",1),
(217,"Mount Gambier","South Australia","Australia",1),
(218,"Murray Bridge","South Australia","Australia",1),
(219,"Port Adelaide","South Australia","Australia",1),
(220,"Port Agusta","South Australia","Australia",1),
(221,"Port Pirie","South Australia","Australia",1),
(222,"Port Lincoln","South Australia","Australia",1),
(223,"Victor Harbor","South Australia","Australia",1),
(224,"Whyalla","South Australia","Australia",1),
(225,"Hobart","Tasmania","Australia",1),
(226,"Burnie","Tasmania","Australia",1),
(227,"Devonport","Tasmania","Australia",1),
(228,"Launceston","South Australia","Australia",1),
(229,"Melbourne","Victoria","Australia",1),
(230,"Ararat","Victoria","Australia",1),
(231,"Bairnsdale","Victoria","Australia",1),
(232,"Benalla","Tasmania","Australia",1),
(233,"Dandenong","Victoria","Australia",1),
(234,"Frankston","Victoria","Australia",1),
(235,"Geelong","Victoria","Australia",1),
(236,"Hamilton","Victoria","Australia",1),
(237,"Melton","Victoria","Australia",1),
(238,"Mildura","Victoria","Australia",1),
(239,"Sale","Victoria","Australia",1),
(240,"Shepparton","Victoria","Australia",1),
(241,"Warrnambool","Victoria","Australia",1),
(242,"Wodonga","Victoria","Australia",1),
(243,"Ballarat","Victoria","Australia",1),
(244,"Bendigo","Victoria","Australia",1),
(245,"Horsham","Victoria","Australia",1),
(246,"Latrobe City","Victoria","Australia",1),
(247,"Swan Hill","Victoria","Australia",1),
(248,"Wangaratta","Victoria","Australia",1),
(249,"Las PiÃ±as City","Luzon","Philippines",1),
(250,"Makati City","Luzon","Philippines",1),
(251,"Malabon City","Luzon","Philippines",1),
(252,"Mandaluyong City","Luzon","Philippines",1),
(253,"Caloocan City","Luzon","Philippines",1),
(254,"Manila City","Luzon","Philippines",1),
(255,"Marikina City","Luzon","Philippines",1),
(256,"Muntinlupa City","Luzon","Philippines",1),
(257,"Navotas City","Luzon","Philippines",1),
(258,"ParaÃ±aque City","Luzon","Philippines",1),
(259,"Pasay City","Luzon","Philippines",1),
(260,"Pasig City","Luzon","Philippines",1),
(261,"Pateros City","Luzon","Philippines",1),
(262,"Quezon City","Luzon","Philippines",1),
(263,"San Juan City","Luzon","Philippines",1),
(264,"Taguig City","Luzon","Philippines",1),
(265,"Valenzuela City","Luzon","Philippines",1),
(266,"Abra City","Luzon","Philippines",1),
(267,"Apayao City","Luzon","Philippines",1),
(268,"Baguio City","Luzon","Philippines",1),
(269,"Benguet City","Luzon","Philippines",1),
(270,"Ifugao City","Luzon","Philippines",1),
(271,"Kalinga City","Luzon","Philippines",1),
(272,"Mountain Province City","Luzon","Philippines",1),
(273,"Dagupan City","Luzon","Philippines",1),
(274,"Ilocos Norte City","Luzon","Philippines",1),
(275,"Ilocos Sur City","Luzon","Philippines",1),
(276,"La Union City","Luzon","Philippines",1),
(277,"Pangasinan City","Luzon","Philippines",1),
(278,"Batanes City","Luzon","Philippines",1),
(279,"Cagayan City","Luzon","Philippines",1),
(280,"Isabela City","Luzon","Philippines",1),
(281,"Nueva Vizcaya City","Luzon","Philippines",1),
(282,"Quirino City","Luzon","Philippines",1),
(283,"Santiago City","Luzon","Philippines",1),
(284,"Angeles City","Luzon","Philippines",1),
(285,"Aurora City","Luzon","Philippines",1),
(286,"Bataan City","Luzon","Philippines",1),
(287,"Bulacan City","Luzon","Philippines",1),
(288,"Nueva Ecija City","Luzon","Philippines",1),
(289,"Olongapo City","Luzon","Philippines",1),
(290,"Pampanga City","Luzon","Philippines",1),
(291,"Tarlac City","Luzon","Philippines",1),
(292,"Zambales City","Luzon","Philippines",1),
(293,"Batangas City","Luzon","Philippines",1),
(294,"Cavite City","Luzon","Philippines",1),
(295,"Laguna City","Luzon","Philippines",1),
(296,"Lucena City","Luzon","Philippines",1),
(297,"Rizal City","Luzon","Philippines",1),
(298,"Marinduque City","Luzon","Philippines",1),
(299,"Occidental City","Luzon","Philippines",1),
(300,"Mindoro City","Luzon","Philippines",1),
(301,"Oriental Mindoro","Luzon","Philippines",1),
(302,"Palawan","Luzon","Philippines",1),
(303,"Romblon","Luzon","Philippines",1),
(304,"Albay City","Luzon","Philippines",1),
(305,"Camarines Norte City","Luzon","Philippines",1),
(306,"Camarines Sur City","Luzon","Philippines",1),
(307,"Catanduanes City","Luzon","Philippines",1),
(308,"Masbate City","Luzon","Philippines",1),
(309,"Sorsogon City","Luzon","Philippines",1),
(310,"Aklan City","Visayas/Naga/Legaspi","Philippines",1),
(311,"Antique City","Visayas/Naga/Legaspi","Philippines",1),
(312,"Capiz City","Visayas/Naga/Legaspi","Philippines",1),
(313,"Guimaras City","Visayas/Naga/Legaspi","Philippines",1),
(314,"Negros Occidental City","Visayas/Naga/Legaspi","Philippines",1),
(315,"Bohol City","Visayas/Naga/Legaspi","Philippines",1),
(316,"Lapu-Lapu City","Visayas/Naga/Legaspi","Philippines",1),
(317,"Mandaue City","Visayas/Naga/Legaspi","Philippines",1),
(318,"Negros Oriental City","Visayas/Naga/Legaspi","Philippines",1),
(319,"Siquijor City","Visayas/Naga/Legaspi","Philippines",1),
(320,"Biliran City","Visayas/Naga/Legaspi","Philippines",1),
(321,"Eastern Samar City","Visayas/Naga/Legaspi","Philippines",1),
(322,"Leyte City","Visayas/Naga/Legaspi","Philippines",1),
(323,"Northern Samar City","Visayas/Naga/Legaspi","Philippines",1),
(324,"Ormoc City","Visayas/Naga/Legaspi","Philippines",1),
(325,"Samar City","Visayas/Naga/Legaspi","Philippines",1),
(326,"Southern Leyte City","Visayas/Naga/Legaspi","Philippines",1),
(327,"Isabela City","Mindanao","Philippines",1),
(328,"Zamboanga Del Sur City","Mindanao","Philippines",1),
(329,"Zamboanga Sibugay City","Mindanao","Philippines",1),
(330,"Bukidnon City","Mindanao","Philippines",1),
(331,"Camiguin City","Mindanao","Philippines",1),
(332,"Camiguin","Mindanao","Philippines",1),
(333,"Iligan City","Mindanao","Philippines",1),
(334,"Lanao Del Norte City","Mindanao","Philippines",1),
(335,"Misamis Occidental City","Mindanao","Philippines",1),
(336,"Misamis Oriental City","Mindanao","Philippines",1),
(337,"Compostela Valley City","Mindanao","Philippines",1),
(338,"Davao Del Norte City","Mindanao","Philippines",1),
(339,"Davao Del Sur City","Mindanao","Philippines",1),
(340,"Davao Oriental City","Mindanao","Philippines",1),
(341,"Sarangani City","Mindanao","Philippines",1),
(342,"South Cotabato City","Mindanao","Philippines",1),
(343,"Sultan Kudarat City","Mindanao","Philippines",1),
(344,"Agusan Del Norte City","Mindanao","Philippines",1),
(345,"Agusan Del Sur City","Mindanao","Philippines",1),
(346,"Dinagat Islands City","Mindanao","Philippines",1),
(347,"Surigao Del Norte City","Mindanao","Philippines",1),
(348,"Surigao Del Sur City","Mindanao","Philippines",1),
(349,"Basilan City","Mindanao","Philippines",1),
(350,"Lanao Del Sur City","Mindanao","Philippines",1),
(351,"Maguindanao City","Mindanao","Philippines",1),
(352,"Sulu City","Mindanao","Philippines",1),
(353,"Tawi-Tawi City","Mindanao","Philippines",1),
(354,"Antipolo City","Luzon","Philippines",1),
(355,"Alaminos City","Luzon","Philippines",1),
(356,"Balanga City","Luzon","Philippines",1),
(357,"BiÃ±an City","Luzon","Philippines",1),
(358,"Cabanatuan City","Luzon","Philippines",1),
(359,"Calamba City","Luzon","Philippines",1),
(360,"Calapan City","Luzon","Philippines",1),
(361,"Candon City","Luzon","Philippines",1),
(362,"Gapan City","Luzon","Philippines",1),
(363,"Iriga City","Luzon","Philippines",1),
(364,"Ligao City","Luzon","Philippines",1),
(365,"Lipa City","Luzon","Philippines",1),
(366,"Malolos City","Luzon","Philippines",1),
(367,"San fernando City LA Union","Luzon","Philippines",1),
(368,"San Fernando City Pampanga","Luzon","Philippines",1),
(369,"San Jose City","Luzon","Philippines",1),
(370,"San Jose Del monte City","Luzon","Philippines",1),
(371,"San Pablo City","Luzon","Philippines",1),
(372,"Sta Rosa Laguna City","Luzon","Philippines",1),
(373,"Tabaco City","Luzon","Philippines",1),
(374,"Tagaytay City","Luzon","Philippines",1),
(375,"Vigan City","Luzon","Philippines",1),
(376,"Urdaneta City","Luzon","Philippines",1),
(377,"Coopers Town","Abaco Islands","Bahamas",1),
(378,"Marsh Harbour","Abaco Islands","Bahamas",1),
(379,"Andros Town","Andros Islands","Bahamas",1),
(380,"Nicholls Town","Andros Islands","Bahamas",1),
(381,"Montreal"," Quebec","Canada",1),
(382,"Calgary","Alberta","Canada",1),
(383,"Ottawa","Ontario","Canada",1),
(384,"Edmonton","Alberta","Canada",1),
(385,"Mississauga","Ontario","Canada",1),
(386,"Winnipeg","Manitoba","Canada",1),
(387,"Vancouver","British Columbia","Canada",1),
(388,"Brampton","Ontario","Canada",1),
(389,"Quebec City"," Quebec","Canada",1),
(390,"Surrey","British Columbia","Canada",1),
(391,"Laval"," Quebec","Canada",1),
(392,"Halifax","Nova Scotia","Canada",1),
(393,"London","Ontario","Canada",1),
(394,"Markham","Ontario","Canada",1),
(395,"Vaughan","Ontario","Canada",1),
(396,"Gatineau"," Quebec","Canada",1),
(397,"Longueuil"," Quebec","Canada",1),
(398,"Burnaby","British Columbia","Canada",1),
(399,"Saskatoon","Saskatchewan","Canada",1),
(400,"Kitchener","Ontario","Canada",1),
(401,"Windsor","Ontario","Canada",1),
(402,"Regina","Saskatchewan","Canada",1),
(403,"Richmond","British Columbia","Canada",1),
(404,"Richmond Hill","Ontario","Canada",1),
(405,"oakville","Ontario","Canada",1),
(406,"Burlington","Ontario","Canada",1),
(407,"Greater Sudbury","Ontario","Canada",1),
(408,"Sherbrooke"," Quebec","Canada",1),
(409,"oshawa","Ontario","Canada",1),
(410,"Saguenay"," Quebec","Canada",1),
(411,"Levis"," Quebec","Canada",1),
(412,"Barrie","Ontario","Canada",1),
(413,"Abbotsford","British Columbia","Canada",1),
(414,"St. Catharines","Ontario","Canada",1),
(415,"Trios-rivieres"," Quebec","Canada",1),
(416,"Cambridge","Ontario","Canada",1),
(417,"Coquitlam","British Columbia","Canada",1),
(418,"Kingston","Ontario","Canada",1),
(419,"Whitby","Ontario","Canada",1),
(420,"Guelph","Ontario","Canada",1),
(421,"Kelowna","British Columbia","Canada",1),
(422,"Saanich","British Columbia","Canada",1),
(423,"Ajax","Ontario","Canada",1),
(424,"Thunder Bay","Ontario","Canada",1),
(425,"Terrebonne"," Quebec","Canada",1),
(426,"St John","Newfoundland and Labrador","Canada",1),
(427,"Langley","British Columbia","Canada",1),
(428,"Chatham-kent","Ontario","Canada",1),
(429,"Delta","British Columbia","Canada",1),
(430,"Waterloo","Ontario","Canada",1),
(431,"Cape Breton","Nova Scotia","Canada",1),
(432,"Brantford","Ontario","Canada",1),
(433,"Strathcona County","Alberta","Canada",1),
(434,"Red Deer","Alberta","Canada",1),
(435,"Pickering","Ontario","Canada",1),
(436,"Kamloops","British Columbia","Canada",1),
(437,"Clarington","Ontario","Canada",1),
(438,"Milton","Ontario","Canada",1),
(439,"Nanaimo","British Columbia","Canada",1),
(440,"Lethbridge","Alberta","Canada",1),
(441,"Niagara Falls","Ontario","Canada",1),
(442,"Repentigny"," Quebec","Canada",1),
(443,"Victoria","British Columbia","Canada",1),
(444,"Newmarket","Ontario","Canada",1),
(445,"Brossard"," Quebec","Canada",1),
(446,"PeterBorough","Ontario","Canada",1),
(447,"Chilliwack","British Columbia","Canada",1),
(448,"Maple Ridge","British Columbia","Canada",1),
(449,"Sault Ste. Marie","Ontario","Canada",1),
(450,"Kawartha Lakes","Ontario","Canada",1),
(451,"Sarnia","Ontario","Canada",1),
(452,"Prince George","British Columbia","Canada",1),
(453,"Moncton","New Brunswick","Canada",1),
(454,"New Westminster","British Columbia","Canada",1),
(455,"Wood buffalo","Alberta","Canada",1),
(456,"Grandby"," Quebec","Canada",1),
(457,"Norfolk County","Ontario","Canada",1),
(458,"St Albert","Alberta","Canada",1),
(459,"Medicine Hat","Alberta","Canada",1),
(460,"Port Coquitlam","British Columbia","Canada",1),
(461,"Fredericton","New Brunswick","Canada",1),
(462,"Grande Prairie","Alberta","Canada",1),
(463,"North Bay","Ontario","Canada",1),
(464,"Blainville"," Quebec","Canada",1),
(465,"Welland","Ontario","Canada",1),
(466,"Belleville","Ontario","Canada",1),
(467,"North Vancouver","British Columbia","Canada",1),
(468,"Chongqing","Southwest China","China",1),
(469,"Shanghai","East China","China",1),
(470,"Tianjin","North China","China",1),
(471,"Paris","ÃŽle de France","France",1),
(472,"Lyon","RhÃ´ne Alpes","France",1),
(473,"Marseille","Provence Alpes CÃ´te d\'Azur","France",1),
(474,"Toulouse","Midi PyrÃ©nÃ©es","France",1),
(475,"Lille","Nord Pas de Calais","France",1),
(476,"Bordeaux","Aquitaine","France",1),
(477,"Nice","Provence Alpes CÃ´te d\'Azur","France",1),
(478,"Nantes","Pays de la Loire\t","France",1),
(479,"Strasbourg","Alsace","France",1),
(480,"Grenoble","RhÃ´ne Alpes","France",1),
(481,"Rennes","Brittany","France",1),
(482,"Rouen","Lower Normandy","France",1),
(483,"Toulon","Provence Alpes CÃ´te d\'Azur","France",1),
(484,"Douai-lens","Nord Pas de Calais","France",1),
(485,"Montpellier","Languedoc Roussillon","France",1),
(486,"Avignon","Provence Alpes CÃ´te d\'Azur","France",1),
(487,"Saint Etienne","RhÃ´ne Alpes","France",1),
(488,"Tours","Centre","France",1),
(489,"Clermont-ferrand","Auvergne","France",1),
(490,"Nancy","Lorraine","France",1),
(491,"Orleans","Centre","France",1),
(492,"Caen","Lower Normandy","France",1),
(493,"Angers","Pays de la Loire\t","France",1),
(494,"Metz","Lorraine","France",1),
(495,"Dijon","Burgundy","France",1),
(496,"Valenciennes","Upper Normandy","France",1),
(497,"Bethune","Nord Pas de Calais","France",1),
(498,"Le Mans","Pays de la Loire\t","France",1),
(499,"Reims","Champagne Ardenne","France",1),
(500,"Brest","Brittany","France",1),
(501,"Perpignan","Languedoc Roussillon","France",1),
(502,"Le Havre","Lower Normandy","France",1),
(503,"Amiens","Picardy","France",1),
(504,"Mulhouse","Alsace","France",1),
(505,"Limoges","Limousin","France",1),
(506,"DIPOLOG City","Mindanao","Philippines",1);


DROP TABLE IF EXISTS `8_country`;

CREATE TABLE `8_country` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `countryname` varchar(255) NOT NULL DEFAULT 'none',
  `currency` varchar(255) NOT NULL DEFAULT 'none',
  `status` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=56 DEFAULT CHARSET=latin1;

INSERT INTO `8_country` VALUES (1,"Philippines","PHP",1),
(2,"Italy","EUR",1),
(3,"United States","USD",1),
(4,"Canada","CAD",1),
(5,"Australia","AUD",1),
(6,"Hong Kong","HKD",1),
(7,"Japan","JPY",1),
(8,"Saudi Arabia","SAR",1),
(9,"Singapore","SGD",1),
(10,"United Arab Emirates","AED",1),
(11,"United Kingdom","GBP",1),
(12,"Greece","EUR",1),
(13,"New Zealand","NZD",1),
(14,"South Korea","KRW",1),
(15,"Taiwan","TWD",1),
(16,"Malaysia","MYR",1),
(17,"Vietnam","VND",1),
(18,"Thailand","THB",1),
(19,"Bahrain","BHD",1),
(20,"France","EUR",1),
(21,"Belgium","EUR",1),
(22,"Brazil","BRL",1),
(23,"Brunei","BND",1),
(24,"China","CNY",1),
(25,"Denmark","DKK",1),
(26,"Finland","EUR",1),
(27,"Germany","EUR",1),
(28,"Argentina","ARS",1),
(29,"Austria","EUR",1),
(30,"Bahamas","BSD",1),
(31,"Bangladesh","BDT",1),
(32,"Cambodia","KHR",1),
(33,"Central Africa","XAF",1),
(34,"Chile","CLP",1),
(35,"Egypt","EGP",1),
(36,"Guam","USD",1),
(37,"India","INR",1),
(38,"Indonesia","IDR",1),
(39,"Macau","MOP",1),
(40,"Cuban","CUP","0"),
(41,"Cyprus","EUR",1),
(42,"Czech Republic","CZK",1),
(43,"Mexico","MXN",1),
(44,"Nigeria","NGN",1),
(45,"Oman","OMR",1),
(46,"Pakistan","PKR",1),
(47,"Portugal","EUR",1),
(48,"Puerto Rico","USD",1),
(49,"South Africa","ZAR",1),
(50,"Spain","EUR",1),
(51,"Switzerland","CHF",1),
(52,"Turkey","TRY",1),
(53,"Ukraine","UAH",1),
(54,"Kuwait","KWD",1),
(55,"Cuba","CUP",1);


DROP TABLE IF EXISTS `8_countryregion`;

CREATE TABLE `8_countryregion` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `countryname` varchar(255) NOT NULL DEFAULT 'none',
  `countryregion` varchar(255) NOT NULL DEFAULT 'none',
  `basic` double NOT NULL DEFAULT '0',
  `increment` int(11) NOT NULL DEFAULT '0',
  `status` int(11) NOT NULL DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=505 DEFAULT CHARSET=latin1;

INSERT INTO `8_countryregion` VALUES (1,"Philippines","Luzon",280,28,1),
(2,"Philippines","Visayas/Naga/Legaspi",280,34,1),
(3,"Philippines","Mindanao",280,40,1),
(4,"Italy","Abruzo",2090,458,1),
(5,"Italy","Apulia",2090,458,1),
(6,"United States","Connecticut",1760,565,1),
(7,"United States","Maine",1760,565,1),
(8,"United States","Massachusetts",1760,565,1),
(9,"United States","New Hampshire",1760,565,1),
(10,"United States","Rhode Island",1760,565,1),
(11,"United States","Vermont",1760,565,1),
(12,"United States","New Jersey",1760,565,1),
(13,"United States","New York",1760,565,1),
(14,"United States","Puerto Rico",1760,565,1),
(15,"United States","Virgin Islands",1760,565,1),
(16,"United States","Delaware",1760,565,1),
(17,"Italy","Basilicata",2090,458,1),
(18,"Italy","Calabria",2090,458,1),
(19,"Italy","Campana",2090,458,1),
(20,"Italy","Emilia Romagna",2090,458,1),
(21,"Italy","Friuli Venezia Giulia",2090,458,1),
(22,"Italy","Lazio",2090,458,1),
(23,"Italy","Liguria",2090,458,1),
(24,"Italy","Lombardy",2090,458,1),
(25,"Italy","Marche\t",2090,458,1),
(26,"Italy","Piedmont",2090,458,1),
(27,"Italy","Sardinia",2090,458,1),
(28,"Italy","Sicily",2090,458,1),
(29,"Italy","Trentino Alto Adige",2090,458,1),
(30,"Italy","Tuscany",2090,458,1),
(31,"Italy","Umbria",2090,458,1),
(32,"Italy","Veneto",2090,458,1),
(33,"United States","District of Columbia",1760,565,1),
(34,"United States","Maryland",1760,565,1),
(35,"United States","Pennsylvania",1760,565,1),
(36,"United States","Virginia",1760,565,1),
(37,"United States","West Virginia",1760,565,1),
(38,"United States","Alabama",1760,565,1),
(39,"United States","Florida",1760,565,1),
(40,"United States","Georgia",1760,565,1),
(41,"United States","Kentucky",1760,565,1),
(42,"United States","Mississippi",1760,550,1),
(43,"Singapore","Central Singpore",985,270,1),
(44,"Singapore","East Singapore",985,270,1),
(45,"Singapore","North Singapore",985,270,1),
(46,"Singapore","North East Singapore",985,270,1),
(47,"Singapore","West Singapore",985,270,1),
(48,"United States","North Carolina",1760,565,1),
(49,"United States","South Carolina",1760,565,1),
(50,"United States","Tennessee",1760,565,1),
(51,"United States","Illinois",1760,565,1),
(52,"United States","Indiana",1760,565,1),
(53,"United States","Michigan",1760,565,1),
(54,"United States","Minnesota",1760,565,1),
(55,"United States","Ohio",1760,565,1),
(56,"United States","Wisconsin",1760,565,1),
(57,"United States","Arkansas",1760,565,1),
(58,"United States","Louisiana",1760,565,1),
(59,"United States","New Mexico",1760,565,1),
(60,"Hong Kong","Kowloon",930,212,1),
(61,"Hong Kong","Hong Kong Island",930,212,1),
(62,"Hong Kong","New Territories",930,212,1),
(63,"United Kingdom","England",2090,455,1),
(64,"United Kingdom","Scotland",2090,455,1),
(65,"United Kingdom","Wales",2090,455,1),
(66,"United Kingdom","Northern Ireland",2090,455,1),
(67,"Japan","Hokkaido",1170,240,1),
(68,"Japan","Chubu",1170,240,1),
(69,"Japan","Kinki",1170,240,1),
(70,"Japan","Shikoku",1170,240,1),
(71,"Japan","Tohoku",1170,240,1),
(72,"Japan","Kanto",1170,240,1),
(73,"Japan","Chugoku",1170,240,1),
(74,"Japan","Kyushu Okinawa",1170,240,1),
(75,"United States","Oklahoma",1760,565,1),
(76,"United States","Texas",1760,565,1),
(77,"United States","Iowa",1760,565,1),
(78,"United States","Kansas",1760,565,1),
(79,"United States","Missouri",1760,565,1),
(80,"United States","Nebraska",1760,565,1),
(81,"United States","Colorado",1760,565,1),
(82,"United States","Montana",1760,565,1),
(83,"United States","North Dakota",1760,565,1),
(84,"United States","South Dakota",1760,565,1),
(85,"United States","Utah",1760,565,1),
(86,"United States","Wyoming",1760,565,1),
(87,"United States","Arizona",1760,565,1),
(88,"United States","California",1760,565,1),
(89,"United States","Hawaii",1760,565,1),
(90,"United States","Nevada",1760,565,1),
(91,"United States","American Samoa",1760,565,1),
(92,"United States","Guam",1760,565,1),
(93,"United States","Northern Mariana Islands",1760,565,1),
(94,"United States","Alaska",1760,565,1),
(95,"United States","Idaho",1760,565,1),
(96,"United States","Oregon",1760,565,1),
(97,"United States","Washington",1760,565,1),
(98,"United States","Federal Reserve banks",1760,565,1),
(99,"Saudi Arabia","Al Jawf",1885,365,1),
(100,"Saudi Arabia","Northern Borders",1885,365,1),
(101,"Saudi Arabia","Tabuk",1885,365,1),
(102,"Saudi Arabia","Ha il",1885,365,1),
(103,"Saudi Arabia","Al Madinah",1885,365,1),
(104,"Saudi Arabia","Al Qasim",1885,365,1),
(105,"Saudi Arabia","Makkah",1885,365,1),
(106,"Saudi Arabia","Al Riyadh",1885,365,1),
(107,"Saudi Arabia","Eastern Province",1885,365,1),
(108,"Saudi Arabia","Al Bahah",1885,365,1),
(109,"Saudi Arabia","Asir",1885,365,1),
(110,"Saudi Arabia","Jizan",1885,365,1),
(111,"Saudi Arabia","Najran",1885,365,1),
(112,"Canada","Alberta",1730,500,1),
(113,"Canada","British Columbia",1730,500,1),
(114,"Canada","Manitoba",1730,500,1),
(115,"Canada","New Brunswick",1730,500,1),
(116,"Canada","Newfoundland and Labrador",1730,500,1),
(117,"Canada"," Northwest Territories",1730,500,1),
(118,"Canada","Nova Scotia",1730,500,1),
(119,"Canada","Nunavut",1730,500,1),
(120,"Canada","Ontario",1730,500,1),
(121,"Canada"," Prince Edward Island",1730,500,1),
(122,"Canada"," Quebec",1730,500,1),
(123,"Canada","Saskatchewan",1730,500,1),
(124,"Canada","Yukon",1730,500,1),
(125,"Australia","New South Wales",1410,355,1),
(126,"Australia","Northern Territory",1410,355,1),
(127,"Australia","Queensland",1410,355,1),
(128,"Australia","South Australia",1410,355,1),
(129,"Australia","Tasmania",1410,355,1),
(130,"Australia","Victoria",1410,355,1),
(131,"Australia","Western Australia",1410,355,1),
(132,"United Arab Emirates","Abu Dhabi",1985,358,1),
(133,"United Arab Emirates","Ajman",1985,358,1),
(134,"United Arab Emirates","Dubai",1985,358,1),
(135,"United Arab Emirates","Fujairah",1985,358,1),
(136,"United Arab Emirates","Ras Al Khaimah",1985,358,1),
(137,"United Arab Emirates","Sharjah",1985,358,1),
(138,"United Arab Emirates","Sir Bani Yas Island",1985,358,1),
(139,"United Arab Emirates","Umm al Quwain",1985,358,1),
(140,"United Arab Emirates","Yas Island",1985,358,1),
(141,"Greece","Thrace",2090,370,1),
(142,"Greece","Macedonia",2090,370,1),
(143,"Greece","Thessaly",2090,370,1),
(144,"Greece","Epirus",2090,370,1),
(145,"Greece","Central Greece",2090,370,1),
(146,"Greece","Peloponnese",2090,370,1),
(147,"Greece","Aegean Islands",2090,370,1),
(148,"Greece","Ionian Islands",2090,370,1),
(149,"Greece","Crete",2090,370,1),
(150,"New Zealand","Northland",1650,430,1),
(151,"New Zealand","Auckland",1650,430,1),
(152,"New Zealand","Waikato",1650,430,1),
(153,"New Zealand","Bay of Plenty",1650,430,1),
(154,"New Zealand","Gisborne",1650,430,1),
(155,"New Zealand","Hawkes Bay",1650,430,1),
(156,"New Zealand","Taranaki",1650,430,1),
(157,"New Zealand","Manawatu Whanganui",1650,430,1),
(158,"New Zealand","Wellington",1650,430,1),
(159,"New Zealand","Tasman",1650,430,1),
(160,"New Zealand","Nelson",1650,430,1),
(161,"New Zealand","Marlborough",1650,430,1),
(162,"New Zealand","West Coast",1650,430,1),
(163,"New Zealand","Canterbury",1650,430,1),
(164,"New Zealand","Otago",1650,430,1),
(165,"New Zealand","Southland",1650,430,1),
(166,"South Korea","Gwandong",1650,330,1),
(167,"South Korea","Gyeonggi",1650,330,1),
(168,"South Korea","Hoseo",1650,330,1),
(169,"South Korea","Honam",1650,330,1),
(170,"South Korea","Yeongseo",1650,330,1),
(171,"South Korea","Yeongdong",1650,330,1),
(172,"South Korea","Yeongnam",1650,330,1),
(173,"Taiwan","Northern Taiwan",900,185,1),
(174,"Taiwan","Central Taiwan",900,185,1),
(175,"Taiwan","Eastern Taiwan",900,185,1),
(176,"Taiwan","Southern Taiwan",900,185,1),
(177,"Taiwan","Outlying Islands",900,185,1),
(178,"Malaysia","Northern Region Malaysia",1000,270,1),
(179,"Malaysia","Central Region Malaysia",1000,270,1),
(180,"Malaysia","Southern Region Malaysia",1000,270,1),
(181,"Malaysia","East Coast Region Malaysia",1000,270,1),
(182,"Malaysia","Sabah Sarawak and Labuan",1000,270,1),
(183,"Vietnam","Central Highlands",1300,200,1),
(184,"Vietnam","Mekong Delta",1300,200,1),
(185,"Vietnam","North Central Coast",1300,200,1),
(186,"Vietnam","Northeast Vietnam",1300,200,1),
(187,"Vietnam","Red River Delta",1300,200,1),
(188,"Vietnam","South Central Coast",1300,200,1),
(189,"Vietnam","Southeast Vietnam",1300,200,1),
(190,"Thailand","Northern Thailand",1050,260,1),
(191,"Thailand","Northeastern Thailand",1050,260,1),
(192,"Thailand","Western Thailand",1050,260,1),
(193,"Thailand","Central Thailand",1050,260,1),
(194,"Thailand","Eastern Thailand",1050,260,1),
(195,"Thailand","Southern Thailand",1050,260,1),
(196,"Bahrain","Gharbiyah",1700,400,1),
(197,"Bahrain","Hadd",1700,400,1),
(198,"Bahrain","Janubiyah",1700,400,1),
(199,"Bahrain","Jidd Hafs",1700,400,1),
(200,"Bahrain","Juzur Hawar",1700,400,1),
(201,"France","Alsace",2250,450,1),
(202,"France","Aquitaine",2250,450,1),
(203,"France","Auvergne",2250,450,1),
(204,"France","Brittany",2250,450,1),
(205,"France","Burgundy",2250,450,1),
(206,"France","Centre",2250,450,1),
(207,"France","Champagne Ardenne",2250,450,1),
(208,"France","Franche ComtÃ©",2250,450,1),
(209,"France","ÃŽle de France",2250,450,1),
(210,"France","Languedoc Roussillon",2250,450,1),
(211,"France","Limousin",2250,450,1),
(212,"France","Lorraine",2250,450,1),
(213,"France","Lower Normandy",2250,450,1),
(214,"France","Midi PyrÃ©nÃ©es",2250,450,1),
(215,"France","Nord Pas de Calais",2250,450,1),
(216,"France","Pays de la Loire\t",2250,450,1),
(217,"France","Picardy",2250,450,1),
(218,"France","Poitou Charentes",2250,450,1),
(219,"France","Provence Alpes CÃ´te d\'Azur",2250,450,1),
(220,"France","RhÃ´ne Alpes",2250,450,1),
(221,"France","Upper Normandy",2250,450,1),
(222,"Bahrain","Madinat Hamad",1700,400,1),
(223,"Bahrain","Madinat Isa",1700,400,1),
(224,"Bahrain","Manamah",1700,400,1),
(225,"Bahrain","Muharraq",1700,400,1),
(226,"Bahrain","Shamaliyah",1700,400,1),
(227,"Bahrain","Sitrah",1700,400,1),
(228,"Bahrain","Wusta",1700,400,1),
(229,"Belgium","West Flanders",1700,420,1),
(230,"Belgium","East Flanders",1700,420,1),
(231,"Belgium","Antwerp",1700,420,1),
(232,"Belgium","Limburg",1700,420,1),
(233,"Belgium","Flemish Brabant",1700,420,1),
(234,"Belgium","Wallon Brabant",1700,420,1),
(235,"Belgium","Hainahut",1700,420,1),
(236,"Belgium","Namur",1700,420,1),
(237,"Belgium","Liege",1700,420,1),
(238,"Belgium","Luxembuor",1700,420,1),
(239,"Brazil","North Brazil",1900,1000,1),
(240,"Brazil","Northeast Brazil",1900,1000,1),
(241,"Brazil","Central West Brazil",1900,1000,1),
(242,"Brazil","Southeast",1900,1000,1),
(243,"Brazil","South Brazil",1900,1000,1),
(244,"Brunei","Brunei and Muara",900,240,1),
(245,"Brunei","Tutong",900,240,1),
(246,"Brunei","Belait",900,240,1),
(247,"Brunei","Temburong",900,240,1),
(248,"China","East China",1250,220,1),
(249,"China","North China",1250,220,1),
(250,"China","Northeast China",1250,220,1),
(251,"China","Northwest China",1250,220,1),
(252,"China","South Central China",1250,220,1),
(253,"China","Southwest China",1250,220,1),
(254,"Denmark","Capital Region of Denmark",1500,530,1),
(255,"Denmark","Central Denmark Region",1500,530,1),
(256,"Denmark","North Denmark Region",1500,530,1),
(257,"Denmark","Region Zealand",1500,530,1),
(258,"Denmark","Region of Southern Denmark",1500,530,1),
(259,"Finland","Lapland",1550,420,1),
(260,"Finland","Northern Ostrobothnia",1550,420,1),
(261,"Finland","Kainuu",1550,420,1),
(262,"Finland","North Karelia",1550,420,1),
(263,"Finland","Northern Savonia",1550,420,1),
(264,"Finland","Southern Savonia",1550,420,1),
(265,"Finland","Southern Ostrobothnia",1550,420,1),
(266,"Finland","Central Ostrobothnia",1550,420,1),
(267,"Finland","Ostrobothnia",1550,420,1),
(268,"Finland","Pirkanmaa",1550,420,1),
(269,"Finland","Central Finland",1550,420,1),
(270,"Finland","Satakunta",1550,420,1),
(271,"Finland","Finland Proper",1550,420,1),
(272,"Finland","South Karelia",1550,420,1),
(273,"Finland","PÃ¤ijÃ¤t HÃ¤me",1550,420,1),
(274,"Finland","Tavastia Proper",1550,420,1),
(275,"Finland","Uusimaa",1550,420,1),
(276,"Finland","Kymenlaakso",1550,420,1),
(277,"Finland","Ã…land",1550,420,1),
(278,"Germany","Berlin Metropolitan",1600,600,1),
(279,"Germany","Bremen Oldenburg Metropolitan ",1600,600,1),
(280,"Germany","Frankfurt Rhine Main Metropolitan ",1600,600,1),
(281,"Germany","Hamburg Metropolitan ",1600,600,1),
(282,"Germany","Hannover-Braunschweig-GÃ¶ttingen Wolfsburg Metropolitan",1600,600,1),
(283,"Germany","Munich Metropolitan",1600,600,1),
(284,"Germany","Nuremberg Metropolitan ",1600,600,1),
(285,"Germany","Rhine Neckar Metropolitan ",1600,600,1),
(286,"Germany","Rhine Ruhr Metropolitan ",1600,600,1),
(287,"Germany","Central German Metropolitan ",1600,600,1),
(288,"Argentina","Argentine Northwest",1848,408,1),
(289,"Argentina","Gran Chaco",1848,408,1),
(290,"Argentina","Mesopotamia",1848,408,1),
(291,"Argentina","Cuyo",1848,408,1),
(292,"Argentina","Pampas",1848,408,1),
(293,"Argentina","Patagonia",1848,408,1),
(294,"Bangladesh","Bandarban",1713,326,1),
(295,"Bangladesh","Barisal",1713,326,1),
(296,"Bangladesh","Bogra",1713,326,1),
(297,"Bangladesh","Chittagong",1713,326,1),
(298,"Bangladesh","Chittagong Hill",1713,326,1),
(299,"Bangladesh","Comilla",1713,326,1),
(300,"Bangladesh","Dhaka",1713,326,1),
(301,"Bangladesh","Dinajpur",1713,326,1),
(302,"Bangladesh","Faridpur",1713,326,1),
(303,"Bangladesh","Jamalpur",1713,326,1),
(304,"Bangladesh","Jessore",1713,326,1),
(305,"Bangladesh","Khulna",1713,326,1),
(306,"Bangladesh","Kushtia",1713,326,1),
(307,"Bangladesh","Mymensingh",1713,326,1),
(308,"Bangladesh","Noakhali",1713,326,1),
(309,"Bangladesh","Pabna",1713,326,1),
(310,"Bangladesh","Patuakhali",1713,326,1),
(311,"Bangladesh","Rajshahi",1713,326,1),
(312,"Bangladesh","Rangpur",1713,326,1),
(313,"Bangladesh","Sylhet",1713,326,1),
(314,"Bangladesh","Tangail",1713,326,1),
(315,"Czech Republic","Central Bohemia",1713,326,1),
(316,"Czech Republic","Hradec Kralove ",1713,326,1),
(317,"Czech Republic","Karlovy Vary",1713,326,1),
(318,"Czech Republic","Liberec",1713,326,1),
(319,"Czech Republic","Moravia Silecia",1713,326,1),
(320,"Czech Republic","Olomouc",1713,326,1),
(321,"Czech Republic","Pardubice",1713,326,1),
(322,"Czech Republic","Plzen",1713,326,1),
(323,"Czech Republic","Prague",1713,326,1),
(324,"Czech Republic","South Bohemia",1713,326,1),
(325,"Czech Republic","South Moravia",1713,326,1),
(326,"Czech Republic","Vvsocina",1713,326,1),
(327,"Czech Republic","Zlin",1713,326,1),
(328,"Czech Republic","Usti Nad Labem",1713,326,1),
(329,"India","East India",1713,326,1),
(330,"India","North India",1713,326,1),
(331,"India","Northeast India",1713,326,1),
(332,"India","South India",1713,326,1),
(333,"India","West India",1713,326,1),
(334,"Chile","Arica y Parinacota",1848,408,1),
(335,"Chile","Tarapaca",1848,408,1),
(336,"Chile","Antofagasta",1848,408,1),
(337,"Chile","Atacama",1848,408,1),
(338,"Chile","Coquimbo",1848,408,1),
(339,"Chile","Valparaiso",1848,408,1),
(340,"Chile","Metropolitana de Santiago",1848,408,1),
(341,"Chile","Libertador General Bernardo O higgins",1848,408,1),
(342,"Chile","Maule",1848,408,1),
(343,"Chile","Bio bio",1848,408,1),
(344,"Chile","La Araucania",1848,408,1),
(345,"Chile","Los Rios",1848,408,1),
(346,"Chile","Los lagos",1848,408,1),
(347,"Chile","Aysen del general Carlos ibanez del campo",1848,408,1),
(348,"Chile","Magallanes y la antartica chilena",1848,408,1),
(349,"Egypt","Nile",1848,408,1),
(350,"Egypt","Western desert",1848,408,1),
(351,"Egypt","Eastern desert",1848,408,1),
(352,"Egypt","Senai Peninsula",1848,408,1),
(353,"Mexico","Northwest",1848,408,1),
(354,"Mexico","Northeast",1848,408,1),
(355,"Mexico","West",1848,408,1),
(356,"Mexico","East",1848,408,1),
(357,"Mexico","North central",1848,408,1),
(358,"Mexico","South central",1848,408,1),
(359,"Mexico","Southeast",1848,408,1),
(360,"Mexico","Southwest",1848,408,1),
(361,"Nigeria","Eastern",1848,408,1),
(362,"Nigeria","Midwest",1848,408,1),
(363,"Nigeria","Western",1848,408,1),
(364,"Nigeria","Northern",1848,408,1),
(365,"Oman","Ruus al Jibal",1713,326,1),
(366,"Oman","Al batinah",1713,326,1),
(367,"Oman","Muscat Matra",1713,326,1),
(368,"Oman","Coastal Tract",1713,326,1),
(369,"Oman","Oman Interior",1713,326,1),
(370,"Oman","Dhofar region",1713,326,1),
(371,"Turkey","Marmara",1713,326,1),
(372,"Turkey","Aegean",1713,326,1),
(373,"Turkey","Black sea",1713,326,1),
(374,"Turkey","Central Anatolia",1713,326,1),
(375,"Turkey","Eastern Anatolia",1713,326,1),
(376,"Turkey","Southeast Anatolia",1713,326,1),
(377,"Turkey","Mediterranean",1713,326,1),
(378,"Switzerland","Northwestern",1713,326,1),
(379,"Switzerland","Espace Mittleland",1713,326,1),
(380,"Switzerland","Lake Geneva",1713,326,1),
(381,"Switzerland","Zurich",1713,326,1),
(382,"Switzerland","Ticino",1713,326,1),
(383,"Switzerland","Central",1713,326,1),
(384,"Switzerland","Easter",1713,326,1),
(385,"Ukraine","Cherkasy",1713,326,1),
(386,"Ukraine","Chernihiv",1713,326,1),
(387,"Ukraine","Chernivtski",1713,326,1),
(388,"Ukraine","Dnipropetrovs\'k",1713,326,1),
(389,"Ukraine","Donets\'k",1713,326,1),
(390,"Ukraine","Ivano-Frankivs\'k",1713,326,1),
(391,"Ukraine","Kharkiv",1713,326,1),
(392,"Ukraine","Kherson",1713,326,1),
(393,"Ukraine","Khmelnytsky",1713,326,1),
(394,"Ukraine","Kirovograd",1713,326,1),
(395,"Ukraine","Kyiv",1713,326,1),
(396,"Ukraine","Luhans\'k",1713,326,1),
(397,"Ukraine","Lviv",1713,326,1),
(398,"Ukraine","Mykolayiv",1713,326,1),
(399,"Ukraine","Odesa",1713,326,1),
(400,"Ukraine","Poltava",1713,326,1),
(401,"Ukraine","Rivne",1713,326,1),
(402,"Ukraine","Sumy",1713,326,1),
(403,"Ukraine","Ternopil",1713,326,1),
(404,"Ukraine","Vinnytsya",1713,326,1),
(405,"Ukraine","Volyn",1713,326,1),
(406,"Ukraine","Zakarpattya",1713,326,1),
(407,"Ukraine","Zaporizhzhya",1713,326,1),
(408,"Ukraine","Zhytomyr",1713,326,1),
(409,"Kuwait","Muhafazat al Wafrah",1713,326,1),
(410,"Kuwait","Muhafazat al Asimah",1713,326,1),
(411,"Kuwait","Muhafazat al Farwaniyah",1713,326,1),
(412,"Kuwait","Muhafazat Jahra",1713,326,1),
(413,"Puerto Rico","North",1848,408,1),
(414,"Puerto Rico","Central",1848,408,1),
(415,"Puerto Rico","South",1848,408,1),
(416,"Puerto Rico","East",1848,408,1),
(417,"Puerto Rico","West",1848,408,1),
(418,"Spain","Andalusia",1713,326,1),
(419,"Spain","Aragon",1713,326,1),
(420,"Spain","Asturias",1713,326,1),
(421,"Spain","Balearic Islands",1713,326,1),
(422,"Spain","Basque country",1713,326,1),
(423,"Spain","Canary Islands",1713,326,1),
(424,"Spain","Cantabria",1713,326,1),
(425,"Spain","Castilla La Mancha",1713,326,1),
(426,"Spain","Castella y Leon",1713,326,1),
(427,"Spain","Catalonia",1713,326,1),
(428,"Spain","Extremadura",1713,326,1),
(429,"Spain","Galicia",1713,326,1),
(430,"Spain","Madrid",1713,326,1),
(431,"Spain","Murcia",1713,326,1),
(432,"Spain","Navarra",1713,326,1),
(433,"Spain","La Rioja",1713,326,1),
(434,"Spain","Valencian Community",1713,326,1),
(435,"Austria","Carinthia",1713,326,1),
(436,"Austria","Upper Austria",1713,326,1),
(437,"Austria","Salzburger LAnd",1713,326,1),
(438,"Austria","Tyrol",1713,326,1),
(439,"Austria","Vorarlberg",1713,326,1),
(440,"Austria","Styria",1713,326,1),
(441,"Austria","Vienna",1713,326,1),
(442,"Austria","Lower Austria",1713,326,1),
(443,"Austria","Tirol",1713,326,1),
(444,"Bahamas","Berry Islands",1848,408,1),
(445,"Bahamas","Abaco Islands",1848,408,1),
(446,"Bahamas","southern Bahamas",1848,408,1),
(447,"Bahamas","Andros Islands",1848,408,1),
(448,"Bahamas","Exuma",1848,408,1),
(449,"Portugal","North",1713,326,1),
(450,"Portugal","Centre",1713,326,1),
(451,"Portugal","Lisbon",1713,326,1),
(452,"Portugal","Alentejo",1713,326,1),
(453,"Portugal","Algarve",1713,326,1),
(454,"Portugal","MAdeira",1713,326,1),
(455,"Portugal","Azores",1713,326,1),
(456,"Pakistan","Azad Kashmir",1713,326,1),
(457,"Pakistan","Baloschistan",1713,326,1),
(458,"Pakistan","Fa Tribal Areas",1713,326,1),
(459,"Pakistan","Gligit-Baltistan",1713,326,1),
(460,"Pakistan","Islamabad",1713,326,1),
(461,"Pakistan","Capitol Territory",1713,326,1),
(462,"Pakistan","Northwest",1713,326,1),
(463,"Pakistan","Frontier Province",1713,326,1),
(464,"Pakistan","Punjab",1713,326,1),
(465,"Pakistan","Sindh",1713,326,1),
(466,"Cyprus","Limassol",1713,326,1),
(467,"Cyprus","Larnaea",1713,326,1),
(468,"Cyprus","Nicosia",1713,326,1),
(469,"Cyprus","Famagusta",1713,326,1),
(470,"Cyprus","Paphos",1713,326,1),
(471,"Cyprus","Kyrenia",1713,326,1),
(472,"Cambodia","Southeast Asia",929,116,1),
(473,"Cambodia","Northwest",929,116,1),
(474,"Cambodia","Northeast",929,116,1),
(475,"Cambodia","Southwest",929,116,1),
(476,"Cambodia","east",929,116,1),
(477,"Guam","Northern ",1190,164,1),
(478,"Guam","Central/Metropolitan",1190,164,1),
(479,"Guam","Southern",1190,164,1),
(480,"Indonesia","8th Parallel region",885,93,1),
(481,"Indonesia","Equatorial Region",885,93,1),
(482,"Indonesia","Central Region",885,93,1),
(483,"Indonesia","Sumatra Region",885,93,1),
(484,"Indonesia","Raja Ampat ",885,93,1),
(485,"South Africa","Limpopo",1848,408,1),
(486,"South Africa","Gauteng",1848,408,1),
(487,"South Africa","Mpumalanga",1848,408,1),
(488,"South Africa","North West",1848,408,1),
(489,"South Africa","Free Estate",1848,408,1),
(490,"South Africa","Kwazulu-Natal",1848,408,1),
(491,"South Africa","Northern Cape",1848,408,1),
(492,"South Africa","Lesotho",1848,408,1),
(493,"South Africa","Eastern Cape",1848,408,1),
(494,"South Africa","Western Cafe",1848,408,1),
(495,"Central Africa","Angola",1848,408,1),
(496,"Central Africa","Cameroon",1848,408,1),
(497,"Central Africa","Zambia",1848,408,1),
(498,"Cuba","Western Cuba",1848,408,1),
(499,"Cuba","Central Cuba",1848,408,1),
(500,"Cuba","Eastern Cuba",1848,408,1),
(501,"Macau","Macau Peninsula",666,83,1),
(502,"Macau","Taipa",666,83,1),
(503,"Macau","Cotai",666,83,1),
(504,"Macau","Coloane",666,83,1);


DROP TABLE IF EXISTS `agent`;

CREATE TABLE `agent` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `firstname` varchar(255) NOT NULL,
  `middlename` varchar(255) NOT NULL,
  `lastname` varchar(255) NOT NULL,
  `gender` varchar(255) NOT NULL,
  `birthday` varchar(255) NOT NULL,
  `address` varchar(255) NOT NULL,
  `country` varchar(255) NOT NULL,
  `region` varchar(255) NOT NULL,
  `city` varchar(255) NOT NULL,
  `mobile` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `refID` varchar(255) NOT NULL,
  `remarks` varchar(255) NOT NULL,
  `datecreated` varchar(255) NOT NULL,
  `status` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=latin1;

INSERT INTO `agent` VALUES (11,"Glenn","D","Penaverde","Male","2022-02-17","Shaw Blvd corner Samat St Brgy Highway Hills, Unit 2435 Amaia Skies Shaw","Philippines","Luzon","none","09171187381","penaverdeglenn@gmail.com",1,"","2022-02-20","Added"),
(12,"Glenn","D","Solon","Female","2022-02-09","Barangay Hall Can asujan proper","Philippines","Visayas/Naga/Legaspi","Bacolod City","09982012872","penaverdeglenn@gmail.com",1,"","2022-02-20","Added"),
(13,"Glenn","D","Solon","Female","2022-02-09","Barangay Hall Can asujan proper","Philippines","Visayas/Naga/Legaspi","Bacolod City","09982012872","penaverdeglenn@gmail.com",1,"","2022-02-20","Added"),
(14,"Marulida","Del Rosario","Solon","Male","2022-02-23","Barangay Hall Can asujan proper","Philippines","Mindanao","Butuan City","09982012872","penaverdeglenn@gmail.com",18,"","2022-02-20","Added"),
(15,"F","D","A","Male","2022-02-02","Unit 2435 Amaia Skies Shaw","Philippines","Visayas/Naga/Legaspi","Bacolod City","09171187381","penaverdeglenn@gmail.com",19,"","2022-02-20","Added"),
(16,"s","f","x","Male","2022-03-03","26517 Danti Court Account No. 78-676468, ","Philippines","Mindanao","Butuan City",1650873075,"penaverdeglenn@gmail.com",1,"","2022-02-26","Added"),
(17,"x","z","z","Male","2022-02-09","Unit 2435 Amaia Skies Shaw","Philippines","Visayas/Naga/Legaspi","Bacolod City","09171187381","penaverdeglenn@gmail.com",21,"","2022-02-26","Added"),
(18,"John","Robert","Penaverde","Male","2022-03-18","Unit 2435 Amaia Skies Shaw","Philippines","Visayas/Naga/Legaspi","Bacolod City","09171187381","penaverdeglenn@gmail.com",1,"","2022-03-11","Added"),
(19,"Angelo","test","test","Male","2022-03-17","test","Philippines","Mindanao","Butuan City",91234566,"penaverdeglenn@gmail.com",23,"","2022-03-11","Added"),
(20,"Glenn","S","Solon","Male","2022-03-04","Barangay Hall Can asujan proper","Philippines","Visayas/Naga/Legaspi","Bacolod City","09982012872","penaverdeglenn@gmail.com",18,"","2022-03-12","Added"),
(21,"Josha","Bagay","Sumali","Male","1989-03-08","Barangay Hall Can asujan proper","Philippines","Mindanao","Butuan City","09982012872","penaverdeglenn@gmail.com",19,"","2022-03-12","Added");


DROP TABLE IF EXISTS `commission`;

CREATE TABLE `commission` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `datecreated` varchar(255) NOT NULL,
  `agentID` varchar(255) NOT NULL,
  `agentname` varchar(255) NOT NULL,
  `commissiontotal` varchar(255) NOT NULL,
  `level1` varchar(255) NOT NULL,
  `level2` varchar(255) NOT NULL,
  `level3` varchar(255) NOT NULL,
  `level4` varchar(255) NOT NULL,
  `level5` varchar(255) NOT NULL,
  `agentlevel` varchar(255) NOT NULL,
  `status` varchar(255) NOT NULL,
  `agentnamedown` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=58 DEFAULT CHARSET=latin1;

INSERT INTO `commission` VALUES (1,"2022-02-13",9,"asj2022",350,20,50,"0","0","0","Level 2",1,"jrb2022"),
(2,"2022-02-13",8,"gdp2022",350,50,"0","0","0","0","Level 1",1,"asj2022"),
(3,"2022-02-13",10,"jrb2022",350,15,20,50,"0","0","Level 3",1,"mdf2022"),
(4,"2022-02-13",11,"mdf2022",350,10,15,20,50,"0","Level 4",1,"bgh2022"),
(5,"2022-02-13",8,"gdp2022",350,50,"0","0","0","0","Level 1",1,"asj2022"),
(6,"2022-02-13",9,"asj2022",350,20,50,"0","0","0","Level 2",1,"jrb2022"),
(7,"2022-02-13",10,"jrb2022",350,15,20,50,"0","0","Level 3",1,"mdf2022"),
(8,"2022-02-13",10,"jrb2022",350,15,20,50,"0","0","Level 3",1,"mdf2022"),
(9,"2022-02-13",11,"mdf2022",350,10,15,20,50,"0","Level 4",1,"bgh2022"),
(10,"2022-02-13",12,"bgh2022",350,5,10,15,20,50,"Level 5",1,"nxz2022"),
(11,"2022-02-13",15,"asf2022",350,50,"0","0","0","0","Level 1",1,"ggg2022"),
(12,"2022-02-13",8,"gdp2022",350,50,"0","0","0","0","Level 1",1,"asj2022"),
(13,"2022-02-13",9,"asj2022",350,20,50,"0","0","0","Level 2",1,"jrb2022"),
(14,"2022-02-13",10,"jrb2022",350,15,20,50,"0","0","Level 3",1,"mdf2022"),
(15,"2022-02-13",10,"jrb2022",350,15,20,50,"0","0","Level 3",1,"mdf2022"),
(16,"2022-02-13",11,"mdf2022",350,10,15,20,50,"0","Level 4",1,"bgh2022"),
(17,"2022-02-13",12,"bgh2022",350,5,10,15,20,50,"Level 5",1,"nxz2022"),
(18,"2022-02-13",8,"gdp2022",350,50,"0","0","0","0","Level 1",1,"asj2022"),
(19,"2022-02-13",9,"asj2022",350,20,50,"0","0","0","Level 2",1,"jrb2022"),
(20,"2022-02-13",10,"jrb2022",350,15,20,50,"0","0","Level 3",1,"mdf2022"),
(21,"2022-02-13",11,"mdf2022",350,10,15,20,50,"0","Level 4",1,"bgh2022"),
(22,"2022-02-13",12,"bgh2022",350,5,10,15,20,50,"Level 5",1,"nxz2022"),
(23,"2022-02-13",14,"nxz2022",350,"","","","","","",1,"mds2022"),
(24,"2022-02-13",14,"nxz2022",350,"","","","","","",1,"mds2022"),
(25,"2022-02-13",14,"nxz2022",350,"","","","","","Level 6",1,"mds2022"),
(26,"2022-02-13",14,"nxz2022",350,1,1,1,1,1,"Level 6",1,"mds2022"),
(27,"2022-02-13",14,"nxz2022",350,"0","0","0","0","0","Level 6",1,"mds2022"),
(28,"2022-02-13",14,"nxz2022",350,"0","0","0","0","0","Level 6",1,"mds2022"),
(29,"2022-02-13",8,"gdp2022",350,50,"0","0","0","0","Level 1",1,"asj2022"),
(30,"2022-02-13",9,"asj2022",350,20,50,"0","0","0","Level 2",1,"jrb2022"),
(31,"2022-02-13",10,"jrb2022",350,15,20,50,"0","0","Level 3",1,"mdf2022"),
(32,"2022-02-13",11,"mdf2022",350,10,15,20,50,"0","Level 4",1,"bgh2022"),
(33,"2022-02-13",12,"bgh2022",350,5,10,15,20,50,"Level 5",1,"nxz2022"),
(34,"2022-02-13",12,"bgh2022",350,5,10,15,20,50,"Level 5",1,"nxz2022"),
(35,"2022-02-14",8,"gdp2022",350,50,"0","0","0","0","Level 1",1,"asj2022"),
(36,"2022-02-14",9,"asj2022",350,20,50,"0","0","0","Level 2",1,"jrb2022"),
(37,"2022-02-14",10,"jrb2022",350,15,20,50,"0","0","Level 3",1,"mdf2022"),
(38,"2022-02-14",11,"mdf2022",350,10,15,20,50,"0","Level 4",1,"bgh2022"),
(39,"2022-02-14",12,"bgh2022",350,5,10,15,20,50,"Level 5",1,"nxz2022"),
(40,"2022-02-14",8,"gdp2022",350,50,"0","0","0","0","Level 1",1,"psd2022"),
(41,"2022-02-14",8,"gdp2022",350,50,"0","0","0","0","Level 1",1,"psd2022"),
(42,"2022-02-14",16,"psd2022",350,20,50,"0","0","0","Level 2",1,"sqw2022"),
(43,"2022-02-20",18,"GDS1",350,50,"0","0","0","0","Level 1",1,"MDS18"),
(44,"2022-02-20",19,"MDS18",350,20,50,"0","0","0","Level 2",1,"FDA19"),
(45,"2022-02-26",19,"MDS18",350,20,50,"0","0","0","Level 2",1,"FDA19"),
(46,"2022-02-26",19,"MDS18",350,20,50,"0","0","0","Level 2",1,"FDA19"),
(47,"2022-02-26",18,"GDS1",350,50,"0","0","0","0","Level 1",1,"MDS18"),
(48,"2022-02-26",21,"SFX20",350,50,"0","0","0","0","Level 1",1,"XZZ21"),
(49,"2022-02-26",18,"GDS1",350,50,"0","0","0","0","Level 1",1,"MDS18"),
(50,"2022-02-26",19,"MDS18",350,20,50,"0","0","0","Level 2",1,"FDA19"),
(51,"2022-02-26",21,"SFX20",350,50,"0","0","0","0","Level 1",1,"XZZ21"),
(52,"2022-03-05",18,"GDS1",350,50,"0","0","0","0","Level 1",1,"MDS18"),
(53,"2022-03-11",1,"admin",350,"","","","","","Level 0",1,"SFX20"),
(54,"2022-03-11",21,"SFX20",350,50,"0","0","0","0","Level 1",1,"XZZ21"),
(55,"2022-03-11",21,"SFX20",350,50,"0","0","0","0","Level 1",1,"XZZ21"),
(56,"2022-03-11",23,"JRP22",350,50,"0","0","0","0","Level 1",1,"ATT23"),
(57,"2022-03-12",19,"MDS18",700,40,100,"0","0","0","Level 2",1,"FDA19");


DROP TABLE IF EXISTS `payments`;

CREATE TABLE `payments` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `paymentref` varchar(255) NOT NULL,
  `salesID` varchar(255) NOT NULL,
  `amountpaid` varchar(255) NOT NULL,
  `paymento` varchar(255) NOT NULL,
  `paymentstatus` varchar(255) NOT NULL,
  `paymentdate` varchar(255) NOT NULL,
  `approvedpaymentby` varchar(255) NOT NULL,
  `salesdate` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=latin1;

INSERT INTO `payments` VALUES (6,1,14,50,19,"Voided","2022-03-13 19:39:24",1,"2022-02-26");


DROP TABLE IF EXISTS `products`;

CREATE TABLE `products` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `price` varchar(255) NOT NULL,
  `category` varchar(255) NOT NULL,
  `status` varchar(255) NOT NULL,
  `datecreated` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

INSERT INTO `products` VALUES (1,"Beyoutea Gluta Slimming Coffee",350,"Drinks",1,"2021-12-04"),
(2,"Beyoutea Detox Red Juice",350,"Drinks",1,"2021-12-04"),
(3,"Beyoutea Keto Choco Drink Mix",350,"Drinks",1,"2021-12-04");


DROP TABLE IF EXISTS `sales`;

CREATE TABLE `sales` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `productID` varchar(255) NOT NULL,
  `amount` varchar(255) NOT NULL,
  `quantity` varchar(255) NOT NULL,
  `soldby` varchar(255) NOT NULL,
  `boughtby` varchar(255) NOT NULL,
  `datecreated` varchar(255) NOT NULL,
  `commisionsoldby` varchar(255) NOT NULL,
  `comissionboughtby` varchar(255) NOT NULL,
  `level1` varchar(255) DEFAULT NULL,
  `level2` varchar(255) DEFAULT NULL,
  `level3` varchar(255) DEFAULT NULL,
  `level4` varchar(255) DEFAULT NULL,
  `level5` varchar(255) DEFAULT NULL,
  `status` varchar(255) NOT NULL,
  `total_sales` varchar(255) NOT NULL,
  `paymentstatus` varchar(255) NOT NULL,
  `paymentdate` varchar(255) DEFAULT NULL,
  `approvedpaymentby` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=22 DEFAULT CHARSET=latin1;

INSERT INTO `sales` VALUES (13,1,350,1,18,19,"2022-02-26","Level 1",50,50,"0","0","0","0","0",350,"Pending","",1),
(14,1,350,1,19,20,"2022-02-26","Level 2",20,20,50,"0","0","0",1,350,"Paid","2022-03-13",1),
(16,1,350,1,18,19,"2022-03-05","Level 1",50,50,"0","0","0","0",1,350,"Pending","2022-03-09",1),
(19,1,350,1,21,22,"2022-03-11","Level 1",50,50,"0","0","0","0",1,350,"Pending",NULL,NULL),
(20,1,350,1,23,24,"2022-03-11","Level 1",50,50,"0","0","0","0",1,350,"Pending","2022-03-11",1),
(21,1,350,2,19,20,"2022-03-12","Level 2",20,40,100,"0","0","0",1,700,"Pending",NULL,NULL);


DROP TABLE IF EXISTS `test`;

CREATE TABLE `test` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL,
  `parent_id` varchar(255) NOT NULL,
  `amount` varchar(255) NOT NULL,
  `totalamount` varchar(255) NOT NULL,
  `level` varchar(255) NOT NULL,
  `status` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=latin1;

INSERT INTO `test` VALUES (1,"admin","0","0","0","0",1),
(18,"GDS1",1,50,50,1,1),
(19,"MDS18",18,50,50,2,1),
(20,"FDA19",19,50,50,3,1),
(21,"SFX20",1,50,50,1,1),
(22,"XZZ21",21,50,50,2,1),
(23,"JRP22",1,50,50,1,1),
(24,"ATT23",23,50,50,2,1),
(25,"GSS24",18,50,50,2,1),
(26,"JBS25",19,50,50,3,1);


DROP TABLE IF EXISTS `users`;

CREATE TABLE `users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `USERNAME` varchar(255) NOT NULL,
  `PASSWORD` varchar(255) NOT NULL,
  `FIRST_NAME` varchar(255) NOT NULL,
  `LAST_NAME` varchar(255) NOT NULL,
  `DEPARTMENT` varchar(255) NOT NULL,
  `USER_TYPE` varchar(255) NOT NULL,
  `GENDER` varchar(255) NOT NULL,
  `ACCESS_TYPE` varchar(255) NOT NULL,
  `STATUS` varchar(255) NOT NULL,
  `DATECREATED` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=latin1;

INSERT INTO `users` VALUES (1,"admin","admin","Admin_First","Admin_Last","Adminstrator","Admin","Male","Sales Inquiry,Quotation,Sales Order,Job Order","Active",""),
(18,"GDS1","SqFg1Xxw","Glenn","Solon","Agent","Agent","Female","Agent","Active","2022-02-20"),
(19,"MDS18","G6CSlJFs","Marulida","Solon","Agent","Agent","Male","Agent","Active","2022-02-20"),
(20,"FDA19","M6OmJpvF","F","A","Agent","Agent","Male","Agent","Active","2022-02-20"),
(21,"SFX20","TN5Eo3Pb","s","x","Agent","Agent","Male","Agent","Active","2022-02-26"),
(22,"XZZ21","oF8Z9yuP","x","z","Agent","Agent","Male","Agent","Active","2022-02-26"),
(23,"JRP22","9efa4DYp","John","Penaverde","Agent","Agent","Male","Agent","Active","2022-03-11"),
(24,"ATT23","j9bY5xqa","Angelo","test","Agent","Agent","Male","Agent","Active","2022-03-11"),
(25,"GSS24","NY7UG8K0","Glenn","Solon","Agent","Agent","Male","Agent","Active","2022-03-12"),
(26,"JBS25","j7mZ0b01","Josha","Sumali","Agent","Agent","Male","Agent","Active","2022-03-12");


DROP TABLE IF EXISTS `void`;

CREATE TABLE `void` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `voidtype` varchar(255) NOT NULL,
  `refno` varchar(255) NOT NULL,
  `notes` varchar(255) NOT NULL,
  `datecreated` varchar(255) NOT NULL,
  `approvedby` varchar(255) NOT NULL,
  `status` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=latin1;

INSERT INTO `void` VALUES (1,"salesorder",13,"test","2022-03-15 11:49:50",1,1),
(3,"payment",1,"test","2022-03-15 11:51:28",1,1);


SET foreign_key_checks = 1;
