text: -- phpMyAdmin SQL Dump
  -- version 4.8.4
  -- https://www.phpmyadmin.net/
  --
  -- Host: db:3306
  -- Generation Time: Nov 19, 2019 at 02:47 AM
  -- Server version: 5.7.24
  -- PHP Version: 7.1.25
  
  SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
  SET AUTOCOMMIT = 0;
  START TRANSACTION;
  SET time_zone = "+00:00";
  
  
  /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  /*!40101 SET NAMES utf8mb4 */;
  
  --
  -- Database: `pwebhotel`
  --
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `country`
  --
  
  CREATE TABLE `country` (
    `CC` char(2) NOT NULL DEFAULT '',
    `Country` varchar(80) DEFAULT NULL,
    `ccode` varchar(5) DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `country`
  --
  
  INSERT INTO `country` (`CC`, `Country`, `ccode`) VALUES
  ('AD', 'ANDORRA', '376'),
  ('AE', 'UNITED ARAB EMIRATES', '971'),
  ('AF', 'AFGHANISTAN', '93'),
  ('AG', 'ANTIGUA AND BARBUDA', '1'),
  ('AI', 'ANGUILLA', '1'),
  ('AL', 'ALBANIA', '355'),
  ('AM', 'ARMENIA', '374'),
  ('AN', 'NETHERLANDS ANTILLES', '599'),
  ('AO', 'ANGOLA', '244'),
  ('AQ', 'ANTARCTICA', '672'),
  ('AR', 'ARGENTINA', '54'),
  ('AS', 'AMERICAN SAMOA', '1'),
  ('AT', 'AUSTRIA', '43'),
  ('AU', 'AUSTRALIA', '61'),
  ('AW', 'ARUBA', '297'),
  ('AZ', 'AZERBAIJAN', '994'),
  ('BA', 'BOSNIA AND HERZEGOVINA', '387'),
  ('BB', 'BARBADOS', '1'),
  ('BD', 'BANGLADESH', '880'),
  ('BE', 'BELGIUM', '32'),
  ('BF', 'BURKINA FASO', '226'),
  ('BG', 'BULGARIA', '359'),
  ('BH', 'BAHRAIN', '973'),
  ('BI', 'BURUNDI', '257'),
  ('BJ', 'BENIN', '229'),
  ('BM', 'BERMUDA', '1'),
  ('BN', 'BRUNEI DARUSSALAM', '673'),
  ('BO', 'BOLIVIA', '591'),
  ('BR', 'BRAZIL', '55'),
  ('BS', 'BAHAMAS', '1'),
  ('BT', 'BHUTAN', '975'),
  ('BW', 'BOTSWANA', '267'),
  ('BY', 'BELARUS', '375'),
  ('BZ', 'BELIZE', '501'),
  ('CA', 'CANADA', '1'),
  ('CC', 'COCOS (KEELING) ISLANDS', '61'),
  ('CD', 'CONGO, THE DEMOCRATIC REPUBLIC OF THE', '243'),
  ('CF', 'CENTRAL AFRICAN REPUBLIC', '236'),
  ('CG', 'CONGO', '242'),
  ('CH', 'SWITZERLAND', '41'),
  ('CI', 'COTE D IVOIRE', '225'),
  ('CK', 'COOK ISLANDS', '682'),
  ('CL', 'CHILE', '56'),
  ('CM', 'CAMEROON', '237'),
  ('CN', 'CHINA', '86'),
  ('CO', 'COLOMBIA', '57'),
  ('CR', 'COSTA RICA', '506'),
  ('CU', 'CUBA', '53'),
  ('CV', 'CAPE VERDE', '238'),
  ('CX', 'CHRISTMAS ISLAND', '61'),
  ('CY', 'CYPRUS', '357'),
  ('CZ', 'CZECH REPUBLIC', '420'),
  ('DE', 'GERMANY', '49'),
  ('DJ', 'DJIBOUTI', '253'),
  ('DK', 'DENMARK', '45'),
  ('DM', 'DOMINICA', '1'),
  ('DO', 'DOMINICAN REPUBLIC', '1'),
  ('DZ', 'ALGERIA', '213'),
  ('EC', 'ECUADOR', '593'),
  ('EE', 'ESTONIA', '372'),
  ('EG', 'EGYPT', '20'),
  ('EH', 'WESTERN SAHARA', '212'),
  ('ER', 'ERITREA', '291'),
  ('ES', 'SPAIN', '34'),
  ('ET', 'ETHIOPIA', '251'),
  ('FI', 'FINLAND', '358'),
  ('FJ', 'FIJI', '679'),
  ('FK', 'FALKLAND ISLANDS (MALVINAS)', '500'),
  ('FM', 'MICRONESIA, FEDERATED STATES OF', '691'),
  ('FO', 'FAROE ISLANDS', '298'),
  ('FR', 'FRANCE', '33'),
  ('GA', 'GABON', '241'),
  ('GB', 'UNITED KINGDOM', '44'),
  ('GD', 'GRENADA', '1'),
  ('GE', 'GEORGIA', '995'),
  ('GF', 'FRENCH GUIANA', '594'),
  ('GH', 'GHANA', '233'),
  ('GI', 'GIBRALTAR', '350'),
  ('GL', 'GREENLAND', '299'),
  ('GM', 'GAMBIA', '220'),
  ('GN', 'GUINEA', '224'),
  ('GP', 'GUADELOUPE', '590'),
  ('GQ', 'EQUATORIAL GUINEA', '240'),
  ('GR', 'GREECE', '30'),
  ('GT', 'GUATEMALA', '502'),
  ('GU', 'GUAM', '1'),
  ('GW', 'GUINEA-BISSAU', '245'),
  ('GY', 'GUYANA', '592'),
  ('HK', 'HONG KONG', '852'),
  ('HN', 'HONDURAS', '504'),
  ('HR', 'CROATIA', '385'),
  ('HT', 'HAITI', '509'),
  ('HU', 'HUNGARY', '36'),
  ('ID', 'INDONESIA', '62'),
  ('IE', 'IRELAND', '353'),
  ('IL', 'ISRAEL', '972'),
  ('IN', 'INDIA', '91'),
  ('IO', 'BRITISH INDIAN OCEAN TERRITORY', '246'),
  ('IQ', 'IRAQ', '964'),
  ('IR', 'IRAN, ISLAMIC REPUBLIC OF', '98'),
  ('IS', 'ICELAND', '354'),
  ('IT', 'ITALY', '39'),
  ('JM', 'JAMAICA', '1'),
  ('JO', 'JORDAN', '962'),
  ('JP', 'JAPAN', '81'),
  ('KE', 'KENYA', '254'),
  ('KG', 'KYRGYZSTAN', '996'),
  ('KH', 'CAMBODIA', '855'),
  ('KI', 'KIRIBATI', '686'),
  ('KM', 'COMOROS', '269'),
  ('KN', 'SAINT KITTS AND NEVIS', '1'),
  ('KP', 'KOREA, DEMOCRATIC PEOPLES REPUBLIC OF', '850'),
  ('KR', 'KOREA, REPUBLIC OF', '82'),
  ('KW', 'KUWAIT', '965'),
  ('KY', 'CAYMAN ISLANDS', '1'),
  ('KZ', 'KAZAKHSTAN', '7'),
  ('LA', 'LAO PEOPLES DEMOCRATIC REPUBLIC', '856'),
  ('LB', 'LEBANON', '961'),
  ('LC', 'SAINT LUCIA', '1'),
  ('LI', 'LIECHTENSTEIN', '423'),
  ('LK', 'SRI LANKA', '94'),
  ('LR', 'LIBERIA', '231'),
  ('LS', 'LESOTHO', '266'),
  ('LT', 'LITHUANIA', '370'),
  ('LU', 'LUXEMBOURG', '352'),
  ('LV', 'LATVIA', '371'),
  ('LY', 'LIBYAN ARAB JAMAHIRIYA', '218'),
  ('MA', 'MOROCCO', '212'),
  ('MC', 'MONACO', '377'),
  ('MD', 'MOLDOVA, REPUBLIC OF', '373'),
  ('ME', 'MONTENEGRO', '382'),
  ('MG', 'MADAGASCAR', '261'),
  ('MH', 'MARSHALL ISLANDS', '692'),
  ('MK', 'MACEDONIA, THE FORMER YUGOSLAV REPUBLIC OF', '389'),
  ('ML', 'MALI', '223'),
  ('MM', 'MYANMAR', '95'),
  ('MN', 'MONGOLIA', '976'),
  ('MO', 'MACAO', '853'),
  ('MP', 'NORTHERN MARIANA ISLANDS', '1'),
  ('MQ', 'MARTINIQUE', '596'),
  ('MR', 'MAURITANIA', '222'),
  ('MS', 'MONTSERRAT', '1'),
  ('MT', 'MALTA', '356'),
  ('MU', 'MAURITIUS', '230'),
  ('MV', 'MALDIVES', '960'),
  ('MW', 'MALAWI', '265'),
  ('MX', 'MEXICO', '52'),
  ('MY', 'MALAYSIA', '60'),
  ('MZ', 'MOZAMBIQUE', '258'),
  ('NA', 'NAMIBIA', '264'),
  ('NC', 'NEW CALEDONIA', '687'),
  ('NE', 'NIGER', '227'),
  ('NF', 'NORFOLK ISLAND', '672'),
  ('NG', 'NIGERIA', '234'),
  ('NI', 'NICARAGUA', '505'),
  ('NL', 'NETHERLANDS', '31'),
  ('NO', 'NORWAY', '28'),
  ('NP', 'NEPAL', '977'),
  ('NR', 'NAURU', '674'),
  ('NU', 'NIUE', '683'),
  ('NZ', 'NEW ZEALAND', '64'),
  ('OM', 'OMAN', '968'),
  ('PA', 'PANAMA', '507'),
  ('PE', 'PERU', '51'),
  ('PF', 'FRENCH POLYNESIA', '689'),
  ('PG', 'PAPUA NEW GUINEA', '675'),
  ('PH', 'PHILIPPINES', '63'),
  ('PK', 'PAKISTAN', '92'),
  ('PL', 'POLAND', '48'),
  ('PM', 'SAINT PIERRE AND MIQUELON', '508'),
  ('PR', 'PUERTO RICO', '1'),
  ('PS', 'PALESTINIAN TERRITORY, OCCUPIED', '970'),
  ('PT', 'PORTUGAL', '351'),
  ('PW', 'PALAU', '680'),
  ('PY', 'PARAGUAY', '595'),
  ('QA', 'QATAR', '974'),
  ('RE', 'REUNION', '262'),
  ('RO', 'ROMANIA', '40'),
  ('RS', 'SERBIA', '381'),
  ('RU', 'RUSSIAN FEDERATION', '7'),
  ('RW', 'RWANDA', '250'),
  ('SA', 'SAUDI ARABIA', '966'),
  ('SB', 'SOLOMON ISLANDS', '677'),
  ('SC', 'SEYCHELLES', '248'),
  ('SD', 'SUDAN', '249'),
  ('SE', 'SWEDEN', '46'),
  ('SG', 'SINGAPORE', '65'),
  ('SH', 'SAINT HELENA', '290'),
  ('SI', 'SLOVENIA', '386'),
  ('SK', 'SLOVAKIA', '421'),
  ('SL', 'SIERRA LEONE', '232'),
  ('SM', 'SAN MARINO', '378'),
  ('SN', 'SENEGAL', '221'),
  ('SO', 'SOMALIA', '252'),
  ('SR', 'SURINAME', '597'),
  ('ST', 'SAO TOME AND PRINCIPE', '239'),
  ('SV', 'EL SALVADOR', '503'),
  ('SY', 'SYRIAN ARAB REPUBLIC', '963'),
  ('SZ', 'SWAZILAND', '268'),
  ('TC', 'TURKS AND CAICOS ISLANDS', '1'),
  ('TD', 'CHAD', '235'),
  ('TG', 'TOGO', '228'),
  ('TH', 'THAILAND', '66'),
  ('TJ', 'TAJIKISTAN', '992'),
  ('TK', 'TOKELAU', '690'),
  ('TL', 'TIMOR-LESTE', '670'),
  ('TM', 'TURKMENISTAN', '993'),
  ('TN', 'TUNISIA', '216'),
  ('TO', 'TONGA', '676'),
  ('TR', 'TURKEY', '90'),
  ('TT', 'TRINIDAD AND TOBAGO', '1'),
  ('TV', 'TUVALU', '688'),
  ('TW', 'TAIWAN, PROVINCE OF CHINA', '886'),
  ('TZ', 'TANZANIA, UNITED REPUBLIC OF', '255'),
  ('UA', 'UKRAINE', '380'),
  ('UG', 'UGANDA', '256'),
  ('US', 'UNITED STATES', '1'),
  ('UY', 'URUGUAY', '598'),
  ('UZ', 'UZBEKISTAN', '998'),
  ('VA', 'VATICAN', '379'),
  ('VC', 'SAINT VINCENT AND THE GRENADINES', '1'),
  ('VE', 'VENEZUELA', '58'),
  ('VG', 'VIRGIN ISLANDS, BRITISH', '1'),
  ('VI', 'VIRGIN ISLANDS, U.S.', '1'),
  ('VN', 'VIET NAM', '84'),
  ('VU', 'VANUATU', '678'),
  ('WF', 'WALLIS AND FUTUNA', '681'),
  ('WS', 'SAMOA', '685'),
  ('YE', 'YEMEN', '967'),
  ('YT', 'MAYOTTE', '269'),
  ('ZA', 'SOUTH AFRICA', '27'),
  ('ZM', 'ZAMBIA', '260'),
  ('ZW', 'ZIMBABWE', '263');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `guests`
  --
  
  CREATE TABLE `guests` (
    `date_in` date DEFAULT NULL,
    `date_out` date DEFAULT NULL,
    `member_ID` char(8) DEFAULT NULL,
    `room` char(4) DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `guests`
  --
  
  INSERT INTO `guests` (`date_in`, `date_out`, `member_ID`, `room`) VALUES
  ('2019-04-11', '2019-04-13', '05000344', '1303'),
  ('2019-04-11', '2019-04-13', '05000344', '1303'),
  ('2019-04-11', '2019-04-13', '05001444', '1316'),
  ('2019-04-11', '2019-04-15', '06006898', '1310'),
  ('2019-04-12', '2019-04-16', '05000765', '1309'),
  ('2019-04-12', '2019-04-16', '05000964', '806'),
  ('2019-04-12', '2019-04-17', '06002326', '506'),
  ('2019-04-13', '2019-04-16', '06002336', '719'),
  ('2019-04-13', '2019-04-16', '06007140', '711'),
  ('2019-04-13', '2019-04-15', '06007757', '1404'),
  ('2019-04-14', '2019-04-16', '06007599', '1114'),
  ('2019-04-15', '2019-04-18', '05000168', '1408'),
  ('2019-04-15', '2019-04-19', '06006203', '1305'),
  ('2019-04-16', '2019-04-19', '05001237', '502'),
  ('2019-04-16', '2019-04-22', '05001637', '710'),
  ('2019-04-16', '2019-04-23', '06004298', '412'),
  ('2019-04-16', '2019-04-23', '06005060', '1012'),
  ('2019-04-16', '2019-04-22', '06009653', '816'),
  ('2019-04-16', '2019-04-23', '06009741', '810'),
  ('2019-04-17', '2019-04-24', '06003342', '606'),
  ('2019-04-17', '2019-04-18', '06003740', '1019'),
  ('2019-04-17', '2019-04-19', '06004023', '1216'),
  ('2019-04-17', '2019-04-23', '06006082', '507'),
  ('2019-04-18', '2019-04-24', '05000037', '1403'),
  ('2019-04-18', '2019-04-19', '05000039', '1205'),
  ('2019-04-18', '2019-04-19', '06007808', '1508'),
  ('2019-04-19', '2019-04-20', '05000254', '215'),
  ('2019-04-19', '2019-04-20', '06006300', '617'),
  ('2019-04-19', '2019-04-20', '06008641', '409'),
  ('2019-04-20', '2019-04-25', '05001107', '1112'),
  ('2019-04-20', '2019-04-25', '06004637', '409'),
  ('2019-04-20', '2019-04-22', '06008769', '1507'),
  ('2019-04-21', '2019-04-22', '06006449', '311'),
  ('2019-04-22', '2019-04-23', '06008745', '1308'),
  ('2019-04-24', '2019-04-26', '06002509', '1015'),
  ('2019-04-25', '2019-04-27', '06002572', '317'),
  ('2019-04-25', '2019-04-27', '06003321', '1413'),
  ('2019-04-25', '2019-04-30', '06007243', '816'),
  ('2019-04-26', '2019-04-27', '06002337', '318'),
  ('2019-04-27', '2019-05-01', '05000971', '716'),
  ('2019-04-29', '2019-05-06', '06002455', '812'),
  ('2019-04-30', '2019-05-06', '06007969', '301'),
  ('2019-05-01', '2019-05-02', '06007410', '418'),
  ('2019-05-02', '2019-05-04', '05000056', '1305'),
  ('2019-05-02', '2019-05-09', '06005174', '1507'),
  ('2019-05-03', '2019-05-08', '06004735', '1109'),
  ('2019-05-04', '2019-05-08', '05000376', '820'),
  ('2019-05-04', '2019-05-08', '06003583', '209'),
  ('2019-05-04', '2019-05-05', '06004453', '208'),
  ('2019-05-04', '2019-05-08', '06008708', '215'),
  ('2019-05-05', '2019-05-10', '05001029', '1505'),
  ('2019-05-05', '2019-05-07', '06008352', '816'),
  ('2019-05-05', '2019-05-06', '06008816', '410'),
  ('2019-05-05', '2019-05-08', '06009008', '704'),
  ('2019-05-06', '2019-05-10', '06004983', '1205'),
  ('2019-05-07', '2019-05-09', '06002481', '918'),
  ('2019-05-07', '2019-05-12', '06007066', '808'),
  ('2019-05-08', '2019-05-10', '06006949', '1402'),
  ('2019-05-09', '2019-05-15', '05001676', '419'),
  ('2019-05-09', '2019-05-10', '06007209', '206'),
  ('2019-05-10', '2019-05-15', '06006376', '1212'),
  ('2019-05-11', '2019-05-15', '05000518', '816'),
  ('2019-05-11', '2019-05-13', '06003760', '907'),
  ('2019-05-12', '2019-05-18', '06009259', '1104'),
  ('2019-05-13', '2019-05-20', '06003569', '415'),
  ('2019-05-14', '2019-05-17', '06003926', '305'),
  ('2019-05-14', '2019-05-16', '06004827', '1309'),
  ('2019-05-14', '2019-05-16', '06007875', '319'),
  ('2019-05-15', '2019-05-22', '06009716', '412'),
  ('2019-05-16', '2019-05-21', '06007072', '518'),
  ('2019-05-16', '2019-05-18', '06008383', '1110'),
  ('2019-05-17', '2019-05-19', '06002141', '1312'),
  ('2019-05-17', '2019-05-24', '06005892', '216'),
  ('2019-05-18', '2019-05-20', '06002636', '919'),
  ('2019-05-18', '2019-05-25', '06004519', '812'),
  ('2019-05-19', '2019-05-25', '06004604', '1108'),
  ('2019-05-19', '2019-05-25', '06008413', '507'),
  ('2019-05-20', '2019-05-25', '06004269', '615'),
  ('2019-05-20', '2019-05-24', '06005129', '504'),
  ('2019-05-23', '2019-05-28', '06008178', '605'),
  ('2019-05-24', '2019-05-25', '05000964', '1307'),
  ('2019-05-24', '2019-05-28', '05001854', '1205'),
  ('2019-05-24', '2019-05-26', '06003583', '1408'),
  ('2019-05-24', '2019-05-29', '06005100', '1214'),
  ('2019-05-24', '2019-05-30', '06007337', '607'),
  ('2019-05-24', '2019-05-26', '06008481', '508'),
  ('2019-05-24', '2019-05-26', '06008481', '511'),
  ('2019-05-25', '2019-05-27', '06003517', '513'),
  ('2019-05-26', '2019-05-29', '05000344', '409'),
  ('2019-05-26', '2019-05-30', '06003305', '605'),
  ('2019-05-26', '2019-05-27', '06005677', '507'),
  ('2019-05-26', '2019-05-28', '06005890', '1010'),
  ('2019-05-27', '2019-05-29', '05001635', '1102'),
  ('2019-05-28', '2019-05-29', '06009303', '915'),
  ('2019-05-29', '2019-06-03', '05000475', '316'),
  ('2019-05-29', '2019-06-04', '06003976', '510'),
  ('2019-05-29', '2019-06-05', '06009935', '910'),
  ('2019-05-30', '2019-06-02', '06002824', '618'),
  ('2019-05-30', '2019-06-04', '06007477', '613'),
  ('2019-05-30', '2019-06-03', '06008868', '1002'),
  ('2019-05-31', '2019-06-07', '06002096', '411'),
  ('2019-05-31', '2019-06-05', '06002572', '504'),
  ('2019-05-31', '2019-06-07', '06009361', '512'),
  ('2019-06-01', '2019-06-07', '06004197', '1112'),
  ('2019-06-02', '2019-06-04', '06003361', '419'),
  ('2019-06-03', '2019-06-05', '06004605', '1205'),
  ('2019-06-03', '2019-06-11', '06005449', '1013'),
  ('2019-06-03', '2019-06-08', '06006276', '1305'),
  ('2019-06-03', '2019-06-09', '06007168', '1212'),
  ('2019-06-05', '2019-06-07', '05000469', '1313'),
  ('2019-06-05', '2019-06-11', '06009804', '216'),
  ('2019-06-06', '2019-06-07', '06005174', '1407'),
  ('2019-06-07', '2019-06-09', '06003028', '605'),
  ('2019-06-08', '2019-06-12', '05000615', '1405'),
  ('2019-06-08', '2019-06-11', '06006964', '220'),
  ('2019-06-09', '2019-06-15', '05001107', '801'),
  ('2019-06-11', '2019-06-17', '06007535', '1112'),
  ('2019-06-13', '2019-06-16', '06006112', '1310'),
  ('2019-06-16', '2019-06-20', '06002669', '1506'),
  ('2019-06-16', '2019-06-17', '06005488', '1105'),
  ('2019-06-17', '2019-06-20', '06004637', '418'),
  ('2019-06-18', '2019-06-19', '05001839', '1506'),
  ('2019-06-18', '2019-06-22', '06002455', '203'),
  ('2019-06-18', '2019-06-23', '06008341', '616'),
  ('2019-06-18', '2019-06-23', '06009741', '406'),
  ('2019-06-19', '2019-06-26', '05001854', '1312'),
  ('2019-06-19', '2019-06-23', '06004900', '1012'),
  ('2019-06-19', '2019-06-22', '06007090', '1305'),
  ('2019-06-19', '2019-06-22', '06007140', '413'),
  ('2019-06-20', '2019-06-21', '05001657', '513'),
  ('2019-06-21', '2019-06-24', '05001635', '714'),
  ('2019-06-21', '2019-06-27', '06003370', '914'),
  ('2019-06-21', '2019-06-26', '06009557', '210'),
  ('2019-06-23', '2019-06-28', '06009080', '216'),
  ('2019-06-24', '2019-06-30', '05001808', '1014'),
  ('2019-06-25', '2019-06-26', '06005587', '1012'),
  ('2019-06-25', '2019-06-29', '06008843', '620'),
  ('2019-06-26', '2019-06-30', '06004926', '1210'),
  ('2019-06-26', '2019-07-01', '06007209', '411'),
  ('2019-06-26', '2019-06-29', '06008816', '312'),
  ('2019-06-28', '2019-06-29', '06006682', '1116'),
  ('2019-06-29', '2019-06-30', '05001637', '810'),
  ('2019-06-29', '2019-07-04', '06002337', '904'),
  ('2019-06-29', '2019-07-02', '06002742', '313'),
  ('2019-06-29', '2019-07-05', '06005820', '907'),
  ('2019-06-29', '2019-06-30', '06009482', '908'),
  ('2019-06-29', '2019-07-01', '06009653', '1204'),
  ('2019-06-30', '2019-06-30', '06002777', '210'),
  ('2019-06-30', '2019-07-03', '06004269', '509'),
  ('2019-07-01', '2019-07-04', '05001861', '720'),
  ('2019-07-01', '2019-07-04', '06004467', '1212'),
  ('2019-07-01', '2019-07-06', '06006082', '902'),
  ('2019-07-01', '2019-07-02', '06007477', '911'),
  ('2019-07-01', '2019-07-04', '06008680', '306'),
  ('2019-07-02', '2019-07-07', '05001077', '805'),
  ('2019-07-02', '2019-07-05', '06003926', '1409'),
  ('2019-07-02', '2019-07-06', '06004881', '819'),
  ('2019-07-04', '2019-07-07', '05000164', '1408'),
  ('2019-07-04', '2019-07-08', '05000414', '707'),
  ('2019-07-05', '2019-07-07', '06004766', '203'),
  ('2019-07-06', '2019-07-13', '06007419', '910'),
  ('2019-07-07', '2019-07-13', '05000254', '418'),
  ('2019-07-07', '2019-07-11', '05000975', '807'),
  ('2019-07-07', '2019-07-14', '05001839', '602'),
  ('2019-07-07', '2019-07-08', '06004869', '805'),
  ('2019-07-07', '2019-07-13', '06005129', '1408'),
  ('2019-07-08', '2019-07-15', '06004453', '319'),
  ('2019-07-08', '2019-07-15', '06006297', '1315'),
  ('2019-07-08', '2019-07-11', '06006488', '318'),
  ('2019-07-08', '2019-07-09', '06008641', '406'),
  ('2019-07-09', '2019-07-10', '06008708', '507'),
  ('2019-07-12', '2019-07-14', '06003852', '1011'),
  ('2019-07-12', '2019-07-15', '06004907', '719'),
  ('2019-07-13', '2019-07-15', '06009126', '712'),
  ('2019-07-13', '2019-07-19', '06009557', '910'),
  ('2019-07-15', '2019-07-16', '05001762', '1511'),
  ('2019-07-15', '2019-07-17', '06002536', '716'),
  ('2019-07-15', '2019-07-17', '06008738', '1304'),
  ('2019-07-16', '2019-07-22', '05000475', '613'),
  ('2019-07-16', '2019-07-17', '06003052', '1215'),
  ('2019-07-16', '2019-07-23', '06004512', '613'),
  ('2019-07-16', '2019-07-19', '06009861', '715'),
  ('2019-07-17', '2019-07-22', '05001657', '702'),
  ('2019-07-17', '2019-07-23', '05001676', '205'),
  ('2019-07-17', '2019-07-20', '06009008', '401'),
  ('2019-07-18', '2019-07-22', '06003305', '314'),
  ('2019-07-18', '2019-07-25', '06004197', '705'),
  ('2019-07-18', '2019-07-19', '06006830', '820'),
  ('2019-07-19', '2019-07-22', '05000697', '910'),
  ('2019-07-21', '2019-07-27', '06002141', '1206'),
  ('2019-07-21', '2019-07-27', '06005892', '817'),
  ('2019-07-21', '2019-07-23', '06008769', '1412'),
  ('2019-07-22', '2019-07-27', '06005174', '403'),
  ('2019-07-22', '2019-07-24', '06007410', '1001'),
  ('2019-07-22', '2019-07-29', '06009936', '316'),
  ('2019-07-23', '2019-07-24', '06007687', '514'),
  ('2019-07-25', '2019-07-27', '06002337', '719'),
  ('2019-07-25', '2019-08-01', '06009716', '519'),
  ('2019-07-26', '2019-08-01', '06008481', '1014'),
  ('2019-07-28', '2019-08-03', '05000518', '505'),
  ('2019-07-28', '2019-08-03', '06006449', '802'),
  ('2019-07-28', '2019-08-05', '06006619', '812'),
  ('2019-07-28', '2019-08-05', '06007090', '1316'),
  ('2019-07-28', '2019-07-30', '06009456', '401'),
  ('2019-07-29', '2019-08-03', '05001024', '520'),
  ('2019-07-29', '2019-08-02', '06003517', '411'),
  ('2019-07-29', '2019-08-03', '06007526', '715'),
  ('2019-07-30', '2019-08-04', '06004827', '607'),
  ('2019-07-30', '2019-08-03', '06006863', '1213'),
  ('2019-08-01', '2019-08-06', '05000971', '1215'),
  ('2019-08-01', '2019-08-06', '06009009', '1212'),
  ('2019-08-02', '2019-08-08', '06004604', '1303'),
  ('2019-08-04', '2019-08-08', '06006538', '301'),
  ('2019-08-04', '2019-08-05', '06009649', '1008'),
  ('2019-08-05', '2019-08-09', '06003072', '1406'),
  ('2019-08-05', '2019-08-10', '06007168', '1110'),
  ('2019-08-05', '2019-08-07', '06008341', '1205'),
  ('2019-08-06', '2019-08-10', '06008330', '904'),
  ('2019-08-07', '2019-08-09', '06007824', '1416'),
  ('2019-08-07', '2019-08-13', '06008699', '318'),
  ('2019-08-09', '2019-08-11', '06004512', '207'),
  ('2019-08-10', '2019-08-11', '06008384', '313'),
  ('2019-08-10', '2019-08-13', '06009173', '219'),
  ('2019-08-11', '2019-08-18', '05001070', '304'),
  ('2019-08-11', '2019-08-13', '06004900', '603'),
  ('2019-08-11', '2019-08-12', '06006058', '1507'),
  ('2019-08-12', '2019-08-15', '06007158', '1110'),
  ('2019-08-12', '2019-08-13', '06007419', '410'),
  ('2019-08-13', '2019-08-16', '06004907', '613'),
  ('2019-08-13', '2019-08-15', '06007866', '509'),
  ('2019-08-14', '2019-08-16', '05000646', '1018'),
  ('2019-08-14', '2019-08-21', '06003544', '1311'),
  ('2019-08-14', '2019-08-21', '06005054', '704'),
  ('2019-08-14', '2019-08-16', '06007209', '904'),
  ('2019-08-14', '2019-08-20', '06007757', '319'),
  ('2019-08-14', '2019-08-19', '06009719', '311'),
  ('2019-08-15', '2019-08-17', '06009804', '1105'),
  ('2019-08-16', '2019-08-22', '05001448', '1302'),
  ('2019-08-16', '2019-08-17', '06006459', '206'),
  ('2019-08-17', '2019-08-20', '06008816', '1106'),
  ('2019-08-18', '2019-08-21', '06003398', '1406'),
  ('2019-08-18', '2019-08-25', '06007535', '819'),
  ('2019-08-19', '2019-08-21', '06004519', '1503'),
  ('2019-08-19', '2019-08-26', '06004869', '602'),
  ('2019-08-19', '2019-08-24', '06006130', '318'),
  ('2019-08-20', '2019-08-24', '06008843', '1108'),
  ('2019-08-21', '2019-08-24', '06004637', '1017'),
  ('2019-08-21', '2019-08-27', '06007066', '212'),
  ('2019-08-21', '2019-08-22', '06009660', '805'),
  ('2019-08-22', '2019-08-23', '06002481', '1301'),
  ('2019-08-22', '2019-08-27', '06004052', '411'),
  ('2019-08-23', '2019-08-25', '05001029', '1104'),
  ('2019-08-23', '2019-08-29', '05001107', '1406'),
  ('2019-08-23', '2019-08-26', '06002326', '502'),
  ('2019-08-24', '2019-08-31', '06008868', '1101'),
  ('2019-08-24', '2019-08-31', '06009390', '814'),
  ('2019-08-25', '2019-09-01', '06002636', '607'),
  ('2019-08-25', '2019-08-27', '06006964', '317'),
  ('2019-08-26', '2019-08-29', '05000508', '608'),
  ('2019-08-26', '2019-08-29', '06002785', '307'),
  ('2019-08-27', '2019-08-28', '06008330', '807'),
  ('2019-08-27', '2019-08-29', '06009996', '313'),
  ('2019-08-28', '2019-09-01', '05001419', '920'),
  ('2019-08-28', '2019-08-31', '06008383', '1403'),
  ('2019-08-28', '2019-08-29', '06008641', '501'),
  ('2019-08-28', '2019-09-03', '06009602', '1301'),
  ('2019-08-29', '2019-08-31', '05000518', '309'),
  ('2019-08-29', '2019-08-30', '06004690', '1501'),
  ('2019-08-29', '2019-09-03', '06005890', '609'),
  ('2019-08-30', '2019-08-31', '05000964', '615'),
  ('2019-08-30', '2019-09-03', '06007037', '1313'),
  ('2019-08-31', '2019-09-03', '05000344', '1011'),
  ('2019-08-31', '2019-09-03', '05001676', '309'),
  ('2019-08-31', '2019-09-06', '06005162', '1502'),
  ('2019-09-01', '2019-09-07', '06002628', '1115'),
  ('2019-09-01', '2019-09-07', '06007168', '1312'),
  ('2019-09-02', '2019-09-03', '06004574', '406'),
  ('2019-09-02', '2019-09-04', '06004910', '1008'),
  ('2019-09-06', '2019-09-11', '06002509', '904'),
  ('2019-09-06', '2019-09-14', '06006072', '410'),
  ('2019-09-06', '2019-09-12', '06007243', '313'),
  ('2019-09-07', '2019-09-12', '05000858', '1504'),
  ('2019-09-07', '2019-09-15', '06007526', '1201'),
  ('2019-09-08', '2019-09-12', '05001292', '406'),
  ('2019-09-08', '2019-09-09', '05001839', '1018'),
  ('2019-09-08', '2019-09-09', '06004926', '1101'),
  ('2019-09-08', '2019-09-09', '06005129', '203'),
  ('2019-09-08', '2019-09-12', '06006949', '602'),
  ('2019-09-08', '2019-09-15', '06009719', '509'),
  ('2019-09-09', '2019-09-11', '05001720', '914'),
  ('2019-09-11', '2019-09-12', '06004872', '515'),
  ('2019-09-11', '2019-09-17', '06007400', '1310'),
  ('2019-09-11', '2019-09-14', '06009009', '714'),
  ('2019-09-12', '2019-09-15', '06008699', '1504'),
  ('2019-09-13', '2019-09-15', '06003517', '314'),
  ('2019-09-14', '2019-09-15', '06005157', '1308'),
  ('2019-09-15', '2019-09-18', '06006624', '219'),
  ('2019-09-16', '2019-09-22', '06007337', '805'),
  ('2019-09-17', '2019-09-22', '06005687', '1011'),
  ('2019-09-18', '2019-09-19', '05000469', '609'),
  ('2019-09-19', '2019-09-26', '05001637', '1203'),
  ('2019-09-20', '2019-09-27', '06006082', '1107'),
  ('2019-09-22', '2019-09-25', '06002481', '1012'),
  ('2019-09-22', '2019-09-26', '06004827', '601'),
  ('2019-09-22', '2019-09-29', '06007158', '1416'),
  ('2019-09-23', '2019-09-26', '05001281', '1205'),
  ('2019-09-23', '2019-09-26', '06006700', '819'),
  ('2019-09-24', '2019-09-28', '05000615', '808'),
  ('2019-09-24', '2019-09-27', '06002873', '1005'),
  ('2019-09-26', '2019-09-27', '05000002', '909'),
  ('2019-09-26', '2019-10-03', '05001107', '1103'),
  ('2019-09-26', '2019-09-29', '06009008', '1511'),
  ('2019-09-27', '2019-10-02', '05000975', '310'),
  ('2019-09-27', '2019-10-04', '06004512', '1213'),
  ('2019-09-27', '2019-10-03', '06007410', '402'),
  ('2019-09-28', '2019-09-29', '06004574', '1020'),
  ('2019-09-28', '2019-09-29', '06007701', '1505'),
  ('2019-09-29', '2019-10-05', '06004467', '303'),
  ('2019-09-29', '2019-10-01', '06007524', '1108'),
  ('2019-09-30', '2019-10-02', '06002141', '404'),
  ('2019-09-30', '2019-10-04', '06009771', '1207'),
  ('2019-10-01', '2019-10-03', '06002160', '910'),
  ('2019-10-01', '2019-10-04', '06009009', '408'),
  ('2019-10-02', '2019-10-04', '05001448', '203'),
  ('2019-10-02', '2019-10-05', '06002636', '509'),
  ('2019-10-02', '2019-10-08', '06004197', '318'),
  ('2019-10-02', '2019-10-09', '06004519', '707'),
  ('2019-10-02', '2019-10-09', '06006112', '1116'),
  ('2019-10-02', '2019-10-08', '06008738', '1104'),
  ('2019-10-03', '2019-10-06', '05000610', '814'),
  ('2019-10-03', '2019-10-08', '06009741', '1510'),
  ('2019-10-03', '2019-10-07', '06009936', '1205'),
  ('2019-10-04', '2019-10-10', '06009861', '513'),
  ('2019-10-05', '2019-10-08', '06003926', '1113'),
  ('2019-10-06', '2019-10-10', '06004605', '609'),
  ('2019-10-06', '2019-10-10', '06006532', '416'),
  ('2019-10-07', '2019-10-09', '06002509', '410'),
  ('2019-10-07', '2019-10-10', '06005449', '602'),
  ('2019-10-07', '2019-10-12', '06005462', '204'),
  ('2019-10-08', '2019-10-10', '06002777', '210'),
  ('2019-10-08', '2019-10-14', '06008178', '612'),
  ('2019-10-09', '2019-10-11', '06004604', '306'),
  ('2019-10-09', '2019-10-15', '06008708', '411'),
  ('2019-10-09', '2019-10-15', '06008843', '508'),
  ('2019-10-09', '2019-10-10', '06009259', '1206'),
  ('2019-10-10', '2019-10-10', '05001635', '1108'),
  ('2019-10-10', '2019-10-11', '06007037', '404'),
  ('2019-10-13', '2019-10-20', '05000518', '1412'),
  ('2019-10-17', '2019-10-19', '06006964', '211'),
  ('2019-10-17', '2019-10-24', '06007757', '1113'),
  ('2019-10-18', '2019-10-24', '06008769', '1307'),
  ('2019-10-25', '2019-10-29', '06008868', '203'),
  ('2019-10-27', '2019-10-28', '06005054', '1309'),
  ('2019-10-29', '2019-11-04', '05000469', '1012'),
  ('2019-10-30', '2019-11-03', '06002326', '416'),
  ('2019-10-31', '2019-11-06', '05001762', '309'),
  ('2019-10-31', '2019-11-06', '06007158', '508'),
  ('2019-11-03', '2019-11-05', '06005892', '719'),
  ('2019-11-04', '2019-11-08', '06008383', '604'),
  ('2019-11-09', '2019-11-12', '06004574', '1213'),
  ('2019-11-11', '2019-11-13', '06009557', '510'),
  ('2019-11-11', '2019-11-12', '06004467', '904'),
  ('2019-11-11', '2019-11-12', '05001762', '1511'),
  ('2019-11-11', '2019-11-12', '06006863', '520'),
  ('2019-11-11', '2019-11-13', '05000056', '1501'),
  ('2019-11-11', NULL, '06007526', '1201'),
  ('2019-11-11', '2019-11-14', '06008178', '1116'),
  ('2019-11-11', '2019-11-12', '05001029', '1107'),
  ('2019-11-11', '2019-11-12', '06007066', '504'),
  ('2019-11-11', NULL, '06004907', '920'),
  ('2019-11-11', NULL, '06006532', '417'),
  ('2019-11-11', NULL, '05001839', '204'),
  ('2019-11-11', '2019-11-12', '06003583', '1414'),
  ('2019-11-11', '2019-11-14', '05000344', '912'),
  ('2019-11-12', '2019-11-13', '06006276', '711'),
  ('2019-11-12', NULL, '06002628', '701'),
  ('2019-11-12', '2019-11-14', '06006624', '217'),
  ('2019-11-12', NULL, '06008816', '216'),
  ('2019-11-12', NULL, '06004197', '1403'),
  ('2019-11-12', NULL, '06007824', '816'),
  ('2019-11-12', NULL, '06002636', '511'),
  ('2019-11-12', '2019-11-13', '05001077', '1214'),
  ('2019-11-12', NULL, '06009259', '1205'),
  ('2019-11-12', '2019-11-14', '05001808', '1506'),
  ('2019-11-12', '2019-11-13', '06007875', '604'),
  ('2019-11-12', '2019-11-13', '06005449', '1007'),
  ('2019-11-12', NULL, '06005587', '717'),
  ('2019-11-13', '2019-11-14', '06006488', '905'),
  ('2019-11-13', NULL, '05000615', '1212'),
  ('2019-11-13', NULL, '06002160', '513'),
  ('2019-11-13', '2019-11-14', '06005162', '402'),
  ('2019-11-13', '2019-11-14', '06009861', '1314'),
  ('2019-11-13', NULL, '06002669', '1308'),
  ('2019-11-13', NULL, '06002873', '401'),
  ('2019-11-13', '2019-11-14', '06003052', '1014'),
  ('2019-11-13', NULL, '05001854', '1512'),
  ('2019-11-14', NULL, '05001635', '1510'),
  ('2019-11-14', NULL, '06009771', '1006'),
  ('2019-11-14', NULL, '05000469', '1016'),
  ('2019-11-14', NULL, '06002509', '712'),
  ('2019-11-14', NULL, '06003342', '306'),
  ('2019-11-14', NULL, '06004983', '1019');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `members`
  --
  
  CREATE TABLE `members` (
    `member_ID` char(8) NOT NULL DEFAULT '',
    `nama` varchar(50) DEFAULT NULL,
    `alamat` varchar(100) DEFAULT NULL,
    `kota` varchar(30) DEFAULT NULL,
    `kodepos` varchar(15) DEFAULT NULL,
    `negara` char(2) DEFAULT NULL,
    `telepon` varchar(25) DEFAULT NULL,
    `hp` varchar(20) DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `members`
  --
  
  INSERT INTO `members` (`member_ID`, `nama`, `alamat`, `kota`, `kodepos`, `negara`, `telepon`, `hp`) VALUES
  ('05000002', 'Solikin W.S., M.T', 'Jl.Jakarta No.28', 'Bandung', '40272', 'ID', '022-7271136', '0817431444'),
  ('05000037', 'Zulfikri, S.Kom.', 'Jl. Rumbia No. 15', 'Selapanjang', '28753', 'ID', '0763-434684', '085667608666'),
  ('05000039', 'Saepudin Nirwan, S.Kom.', 'Jl. Sari Asih no. 54', 'Bandung', '40151', 'ID', '022-2009570', '081321977217'),
  ('05000056', 'Ir. Yan Everhard R., M.T.', 'Jl. Ciledug Raya Petukangan Utara, Kebayoran Lama', 'Jakarta Selatan', '12260', 'ID', '021-5853753 ext. 302', '08121825976'),
  ('05000164', 'Georg Pipps', 'Geislweg 14', 'Salzburg', '5020', 'AT', '6562-9722', ''),
  ('05000168', 'Beatrix, S.Kom.', 'Jl. Ciumbuleuit 94', 'Bandung', '40141', 'ID', '022-2041964 ext. 721', '08122109786'),
  ('05000254', 'Maulana Mujahidin, S.Kom.', 'Jl. Tajur Gg. Baru No. 3', 'Bogor', '16721', 'ID', '0251-393378', '08159156083'),
  ('05000344', 'Lidya C. Hatibi', 'Jl. Manuruki BTN Tabaria Blok B 2 / 5', 'Makassar', '90224', 'ID', '0411-888853', '081342977867'),
  ('05000376', 'Johan, S.Kom., M.M.', 'Jl. KH Syahdan No 9 Kemanggisan, Palmerah', 'Jakarta', '11480', 'ID', '021-5345830 ext 2227', '021-30112380'),
  ('05000408', 'Ann Devon', '35 King George', 'London', 'WX3 6FW', 'GB', '(171) 555-0297', ''),
  ('05000414', 'Jozua F. Palandi', 'Jl. Tidar 100', 'Malang', '65146', 'ID', '0341-560823', '08175403040'),
  ('05000469', 'Agnes Novita Ida S., M.Kom.', 'Jl. Perbanas Karet Kuningan, SetiaBudi', 'Jakarta Selatan', '12940', 'ID', '021-5278788', '085692141325'),
  ('05000475', 'Liz Nixon', '89 Jefferson Way Suite 2', 'Portland', '97201', 'US', '(503) 555-3612', ''),
  ('05000508', 'Yvonne Moncada', 'Ing. Gustavo Moncada 8585 Piso 20-A', 'Buenos Aires', '1010', 'AR', '(1) 135-5333', ''),
  ('05000518', 'Jaime Yorres', '87 Polk St. Suite 5', 'San Francisco', '94117', 'US', '(415) 555-5938', ''),
  ('05000610', 'Maria Larsson', 'Åkergatan 24', 'Bräcke', 'S-844 67', 'SE', '0695-34 67 21', ''),
  ('05000615', 'Yoshi Tannamuri', '1900 Oak St.', 'Vancouver', 'V3F 2K1', 'CA', '(604) 555-3392', ''),
  ('05000646', 'Ady Mulia, S.Kom.', 'Jl. S. Kelara No. 17', 'Makassar', '90121', 'ID', '0411-330393', '081342652649'),
  ('05000697', 'Ana Trujillo', 'Avda. de la Constitución 2222', 'México D.F.', '05021', 'MX', '(5) 555-4729', ''),
  ('05000765', 'Zbyszek Piestrzeniewicz', 'ul. Filtrowa 68', 'Warszawa', '01-012', 'PL', '(26) 642-7012', ''),
  ('05000858', 'Esa Firmansyah, S.T.', 'Komplek Panghegar Permai 8B, Jl. Pasanggrahan VII No 17', 'Sumedang', '40614', 'ID', '0261-207395', '08156176854'),
  ('05000964', 'Malikus Sumadyo', 'Jl.Cut Meutia No.83', 'Bekasi', '17113', 'ID', '021-88344436', '08158256716'),
  ('05000971', 'Dedi Koswara', 'Jl. Ir. H. Juanda No. 96', 'Bandung', '40132', 'ID', '022-2502121', '022-70726710'),
  ('05000975', 'Agung Wahana, S.E., M.T.', 'Jl. Soekarno Hatta 211', 'Bandung', '40235', 'ID', '022-5230382', '085624420357'),
  ('05001024', 'Drs. M. Rifai Katili, M.Kom.', 'Jl. Jenderal Sudirman No. 6', 'Gorontalo', '96128', 'ID', '0435-821125', '085240051818'),
  ('05001029', 'Rosmala', 'Komp. Permata Hijau Blok D / 8', 'Makassar', '90122', 'ID', '434 265', '081524029331'),
  ('05001070', 'Roland Mendel', 'Kirchgasse 6', 'Graz', '8010', 'AT', '7675-3425', ''),
  ('05001077', 'Atiqah Meutia Hilda, S.Kom, M.Kom', 'Jl.Limau II Blok B Kebayoran Baru', 'Jakarta Selatan', '12130', 'ID', '021-7256659', '081578852132'),
  ('05001107', 'Henriette Pfalzheim', 'Mehrheimerstr. 369', 'Köln', '50739', 'DE', '0221-0644327', ''),
  ('05001207', 'Kristina, S.T., M.Kom.', 'Jl. HOS Cokroaminoto 445', 'Pontianak', '78117', 'ID', '0561-731966', '0811565214'),
  ('05001237', 'Erlin, M.Kom.', 'Jl. Purwodadi Indah KM. 10, Panam', 'Pekanbaru', '', 'ID', '0761-7047091', '08127600897'),
  ('05001281', 'Dr. Jarot Prianggono, S.T., M.Kom.', 'Jl. Tarumanegara 78 Puri Laras I Kav 21 A, Pisangan, Ciputat', 'Ciputat', '', 'ID', '021-93282603', '0817174301'),
  ('05001292', 'Siswono, S.Kom, M.M.', 'Jl. KH Syahdan No 9 Kemanggisan, Palmerah', 'Jakarta Barat', '11480', 'ID', '021-5345830 ext 2229', '08159123723'),
  ('05001419', 'Junaidi', 'Jl. Kakatua II Lr. 6 No. 44', 'Makassar', '', 'ID', '', '081342990186'),
  ('05001444', 'Palle Ibsen', 'Smagsløget 45', 'Århus', '8200', 'DK', '86 21 32 43', ''),
  ('05001448', 'Catherine Dewey', 'Rue Joseph-Bens 532', 'Bruxelles', 'B-1180', 'BE', '(02) 201 24 67', ''),
  ('05001635', 'Isabel de Castro', 'Estrada da saúde n. 58', 'Lisboa', '1756', 'PT', '(1) 356-5634', ''),
  ('05001637', 'Yang Wang', 'Hauptstr. 29', 'Bern', '3012', 'CH', '0452-076545', ''),
  ('05001657', 'Janete Limeira', 'Av. Copacabana, 267', 'Rio de Janeiro', '02389-890', 'BR', '(21) 555-3412', ''),
  ('05001676', 'Michael Holz', 'Grenzacherweg 237', 'Genève', '1203', 'CH', '0897-034214', ''),
  ('05001720', 'Daniel Tonini', '67, avenue de lEurope', 'Versailles', '78000', 'FR', '30.59.84.10', ''),
  ('05001762', 'Eduardus Suharto, S.Pd., M.M.', 'Jl. Perbanas Karet Kuningan, SetiaBudi', 'Jakarta Selatan', '12940', 'ID', '021-5278788', '0811975063'),
  ('05001808', 'Nurul Hidayat, M.Kom.', 'Jl. Prof HR Bunyamin 708', 'Purwokerto', '53151', 'ID', '', '08122718132'),
  ('05001839', 'Thomas Hardy', '120 Hanover Sq.', 'London', 'WA1 1DP', 'GB', '(171) 555-7788', ''),
  ('05001854', 'Mira Kania Sabariah, M.T.', 'Jl. Pelanduk No. 5', 'Bandung', '40262', 'ID', '022-7304568', '0818619507'),
  ('05001861', 'Horst Kloss', 'Taucherstraße 10', 'Cunewalde', '01307', 'DE', '0372-035188', ''),
  ('06002096', 'Jean Fresnière', '43 rue St. Laurent', 'Montréal', 'H1J 1C3', 'CA', '(514) 555-8054', ''),
  ('06002141', 'Aang Subiyakto, S.Kom.', 'Jl. Juanda 95 Ciputat', 'Jakarta', '15412', 'ID', '021-7493606', '08121990989'),
  ('06002160', 'Paul Henriot', '59 rue de lAbbaye', 'Reims', '51100', 'FR', '26.47.15.10', ''),
  ('06002326', 'Tommy Bustomi, S.Kom., M.Kom.', 'Jl. Prof. M. Yamin No. 25', 'Samarinda', '75123', 'ID', '0541-736071 ext. 102', '0811589559'),
  ('06002336', 'Syamsul Bahri', 'Jl. Baji Ateka Timur No. 10 B', 'Makassar', '90223', 'ID', '0411-859847', '081524909824'),
  ('06002337', 'Yanti, S.Kom., M.M.', 'Jl. KH Syahdan No 9 Kemanggisan, Palmerah', 'Jakarta', '11480', 'ID', '021-5345830 ext 2207', '0817171853'),
  ('06002455', 'Djasli Djamarus', 'Jl. Asem Baris Raya No. 8 RT 002/04 Kebon Baru ', 'Jakarta Selatan', '12830', 'ID', '021-5605834', '08159257379'),
  ('06002481', 'Rina Kurniawati, M.T.', 'Jl. Binong Kulon VI No 82/126 G', 'Bandung', '40275', 'ID', '022-7313658', '08122165500'),
  ('06002509', 'Budi Susanto', 'Jl. Dr. Wahidin 5-25', 'Yogyakarta', '55224', 'ID', '0274-563929', '08562249205'),
  ('06002536', 'Tedjo Darmanto, M.T.', 'Jl.Paseban Kencana Barat B5 No.68', 'Bandung', '40233', 'ID', '022-6003464', '022-91121844'),
  ('06002572', 'Alejandra Camino', 'Gran Vía, 1', 'Madrid', '28001', 'ES', '(91) 745 6200', ''),
  ('06002628', 'Maria Anders', 'Obere Str. 57', 'Berlin', '12209', 'DE', '030-0074321', ''),
  ('06002636', 'Jose Pavarotti', '187 Suffolk Ln.', 'Boise', '83720', 'US', '(208) 555-8097', ''),
  ('06002669', 'R. Ade Supriyadi', 'Jl. Dukuh Kupang Gg. 29/26A', 'Surabaya', '60000', 'ID', '031-5633220', '081331788148'),
  ('06002742', 'Ir. A. Edi Sudiarto, M.Sc.', 'Jl. Cikutra 204-A', 'Bandung', '40125', 'ID', '022-7278860', '08164200829'),
  ('06002777', 'Carlos Hernández', 'Carrera 22 con Ave. Carlos Soublette #8-35', 'San Cristóbal', '5022', 'VE', '(5) 555-1340', ''),
  ('06002785', 'Lely Priska D.T., S.Kom., MMSI', 'Jl. Perbanas Karet Kuningan, SetiaBudi', 'Jakarta Selatan', '12940', 'ID', '021-5278788', '08176522258'),
  ('06002824', 'Ir. Moh. Sofyan S Thayf', 'Jl. Baji Ateka No. 20', 'Makassar', '90223', 'ID', '0411-871555', '08152507600'),
  ('06002873', 'Maurizio Moroni', 'Strada Provinciale 124', 'Reggio Emilia', '42100', 'IT', '0522-556721', ''),
  ('06003028', 'Paula Parente', 'Rua do Mercado, 12', 'Resende', '08737-363', 'BR', '(14) 555-8122', ''),
  ('06003052', 'Eduardo Saavedra', 'Rambla de Cataluña, 23', 'Barcelona', '08022', 'ES', '(93) 203 4560', ''),
  ('06003072', 'Akmal', 'Jl. Ir. H. Juanda 4', 'Bandung', '40132', 'ID', '022-4218676', '08122461048'),
  ('06003305', 'Frédérique Citeaux', '24, place Kléber', 'Strasbourg', '67000', 'FR', '88.60.15.31', ''),
  ('06003321', 'John Steel', '12 Orchestra Terrace', 'Walla Walla', '99362', 'US', '(509) 555-7969', ''),
  ('06003342', 'Aidil Sanjaya', 'Jl. Kramat Sentiong Ujung No. I/42', 'Jakarta', '10450', 'ID', '021-98766742', '08568588884'),
  ('06003361', 'Jytte Petersen', 'Vinbæltet 34', 'København', '1734', 'DK', '31 12 34 56', ''),
  ('06003370', 'Rita Müller', 'Adenauerallee 900', 'Stuttgart', '70563', 'DE', '0711-020361', ''),
  ('06003398', 'Dra. Rosa De Lima, M.Kom.', 'Jl. Ciumbuleuit 94', 'Bandung', '40141', 'ID', '022-2041964 ext. 701', '08122108691'),
  ('06003517', 'Ir. Bullion Dragon, M.Sc.', 'Jl. Ciledug Raya Petukangan Utara, Kebayoran Lama', 'Jakarta Selatan', '12260', 'ID', '021-5853753', '08129385800'),
  ('06003544', 'Karl Jablonski', '305 - 14th Ave. S. Suite 3B', 'Seattle', '98128', 'US', '(206) 555-4112', ''),
  ('06003569', 'Budi Nurani R.', 'Jl. Ir. H. Juanda 4', 'Bandung', '40132', 'ID', '022-4218676', '08562206520'),
  ('06003583', 'Hari Soetanto', 'Ciledug Raya, Petukangan Utara, Kebayoran Lama', 'Jakarta', '12260', 'ID', '021-5853753', '081318623723'),
  ('06003740', 'Nur Rokhman, S.Si., M.Kom.', 'Sekip Unit III, Bulak Sumur', 'DI Yogyakarta', '55281', 'ID', '021-546194', '08121570063'),
  ('06003760', 'Anne Dodsworth', '7 Houndstooth Rd.', 'London', 'WG2 7LT', 'GB', '(71) 555-4444', ''),
  ('06003852', 'Anabela Domingues', 'Av. Inês de Castro, 414', 'São Paulo', '05634-030', 'BR', '(11) 555-2167', ''),
  ('06003926', 'Francisco Chang', 'Sierras de Granada 9993', 'México D.F.', '05022', 'MX', '(5) 555-3392', ''),
  ('06003976', 'Pirkko Koskitalo', 'Torikatu 38', 'Oulu', '90110', 'FI', '981-443655', ''),
  ('06004023', 'Hindriyanto Dwi Purnomo, S.T.', 'Jl. Diponegoro 52 - 60', 'Salatiga', '50711', 'ID', '0298-321212', '081328019323'),
  ('06004052', 'Utomo Budiyanto, M. Kom, M.Sc.', 'Jl. Ciledug Raya Petukangan Utara', 'Jakarta Selatan', '12260', 'ID', '021-5853753 ext. 304', '08129495308'),
  ('06004197', 'Felipe Izquierdo', 'Ave. 5 de Mayo Porlamar', 'I. de Margarita', '4980', 'VE', '(8) 34-56-12', ''),
  ('06004269', 'Atje Setiawan', 'Jl. Ir. H. Juanda 4', 'Bandung', '40132', 'ID', '022-4218676', '0852229490'),
  ('06004298', 'Patricia McKenna', '8 Johnstown Road', 'Cork', '', 'IE', '2967 542', ''),
  ('06004453', 'Goenawan Brotosaputro, S. Kom, M.Sc.', 'Jl. Ciledug Raya Petukangan Utara, Kebayoran Lama', 'Jakarta', '12260', 'ID', '021-5853753', '081315134242'),
  ('06004467', 'Sergio Gutiérrez', 'Av. del Libertador 900', 'Buenos Aires', '1010', 'AR', '(1) 123-5555', ''),
  ('06004512', 'Fran Wilson', '89 Chiaroscuro Rd.', 'Portland', '97219', 'US', '(503) 555-9573', ''),
  ('06004519', 'Bernardo Batista', 'Rua da Panificadora, 12', 'Rio de Janeiro', '02389-673', 'BR', '(21) 555-4252', ''),
  ('06004574', 'Hanna Moos', 'Forsterstr. 57', 'Mannheim', '68306', 'DE', '0621-08460', ''),
  ('06004604', 'Aria Cruz', 'Rua Orós, 92', 'São Paulo', '05442-030', 'BR', '(11) 555-9857', ''),
  ('06004605', 'Sukenda, M.T.', 'Jl. Cikutra No. 204A', 'Bandung', '40125', 'ID', '022-7206713 ext. 141', '081321278695'),
  ('06004637', 'Steven Buchanan', '14 Garrett Hill', 'London', 'SW1 8JR', 'GB', '(71) 555-4848', ''),
  ('06004690', 'Nurhayati, M.Kom.', 'Jl.Peninggaran Timur II RT 05/RW 09 No.36, Kebayoran Lama Utara', 'Jakarta Selatan', '12240', 'ID', '021-7239003', '0818270552'),
  ('06004735', 'Ir. Wendi Usino, MSc, M.M.', 'Jl. Ciledug Raya Petukangan Utara, Kebayoran Lama', 'Jakarta Selatan', '12260', 'ID', '021-5853753 ext. 212', '0811187919'),
  ('06004766', 'Mary Saveley', '2, rue du Commerce', 'Lyon', '69004', 'FR', '78.32.54.86', ''),
  ('06004827', 'Asep Sholahuddin', 'Jl. Raya Bandung Sumedang KM 21 Jatinangor', 'Bandung', '', 'ID', '022-7794696', '08122336844'),
  ('06004869', 'Drs. Retantyo Wardoyo, M.Sc., Ph.D.', 'Perum Lempongsari B/29, Sariharjo, Ngaglik', 'Yogyakarta', '55581', 'ID', '0274-522443', '085228000363'),
  ('06004872', 'Manuel Pereira', '5ª Ave. Los Palos Grandes', 'Caracas', '1081', 'VE', '(2) 283-2951', ''),
  ('06004881', 'Widi Hapsari', 'Jl. Dr. Wahidin 5-19', 'Yogyakarta', '55224', 'ID', '0274-563929', '08122943935'),
  ('06004900', 'Howard Snyder', '2732 Baker Blvd.', 'Eugene', '97403', 'US', '(503) 555-7555', ''),
  ('06004907', 'Lino Rodriguez ', 'Jardim das rosas n. 32', 'Lisboa', '1675', 'PT', '(1) 354-2534', ''),
  ('06004910', 'Dodo Arsyad, M.T.', 'Jl. Banjarsari No. 8 Tanjungsari', 'Sumedang', '45362', 'ID', '022-7911416', '081321121346'),
  ('06004926', 'H. Mohammad Subekti, B.E.,M.Sc.', 'Komplek Pusdatin No G.7 Pondok Labu', 'Jakarta', '12450', 'ID', '021-70369038', '0818155066'),
  ('06004983', 'Dr. Ing. M. Hendayun', 'Jl. Karapitan 116', 'Bandung', '', 'ID', '022-4213036', '08156002171'),
  ('06005054', 'Hari Kumar', '90 Wadhurst Rd.', 'London', 'OX15 4NB', 'GB', '(171) 555-1717', ''),
  ('06005060', 'Jazi Eko Istyanto', 'Jl. Sains, Bulaksumur', 'Yogyakarta', '55281', 'ID', '', '08122603521'),
  ('06005100', 'André Fonseca', 'Av. Brasil, 442', 'Campinas', '04876-786', 'BR', '(11) 555-9482', ''),
  ('06005129', 'Cecep Nurul Alam, M.T.', 'Komplek Cipadung Permai Jl. Permai IV no. A-73, Cibiru', 'Bandung', '40614', 'ID', '022-7803083', '08122387174'),
  ('06005157', 'I Putu Agus Swastika, M.Kom.', 'Jl. Raya Kedung Baruk No. 98', 'Surabaya', '60298', 'ID', '031-8721731', ''),
  ('06005162', 'Muhammad Nasrun, S.Si., M.T.', 'Jl. Sadangsari No. 41 RT.01/RW14 Sadang Serang', 'Bandung', '40134', 'ID', '022-2533825', '081321120802'),
  ('06005174', 'Wiedjaja, S.Kom.', 'Jl. KH Syahdan No 9 Kemanggisan, Palmerah', 'Jakarta', '11480', 'ID', '021-5345830 ext 2205', '0818950699'),
  ('06005449', 'Drs. Suprapto, M.Kom.', 'Sekip Selatan Unit 3', 'Yogyakarta', '', 'ID', '', '081328787354'),
  ('06005462', 'Karin Josephs', 'Luisenstr. 48', 'Münster', '44087', 'DE', '0251-031259', ''),
  ('06005488', 'Yetli Oslan', 'Jl. Dr. Wahidin 5-25', 'Yogyakarta', '55224', 'ID', '0274-563929', '0811252431'),
  ('06005587', 'Sudirman, S.Kom.', 'Jl. P. Diponegoro Lr. 137 A No. 26 A', 'Makassar', '90000', 'ID', '0411-327228', ''),
  ('06005677', 'Juli Rejito', 'Jl. Ir. H. Juanda 4', 'Bandung', '40132', 'ID', '022-4218676', '08882015905'),
  ('06005687', 'Ayu Pertiwi, S.Kom, M.T.', 'Jl. Nakula I No 5-11', 'Semarang', '50313', 'ID', '024-3517216', '08128295423'),
  ('06005820', 'Fecky L. Mandey', 'Jl. Tanjung Loreh No. 11', 'Makassar', '90221', 'ID', '859 548', '081524354576'),
  ('06005890', 'Ony Widilestariningtyas, S.E., M.Si.', 'Jl. Dipatiukur 112 - 114', 'Bandung', '40132', 'ID', '022-25033825', '08122333187'),
  ('06005892', 'Drs. Sri Mulyana, M.Kom.', 'Sekip Unit III, Bulak Sumur', 'Yogyakarta', '55285', 'ID', '0274-546194', '08122720375'),
  ('06006058', 'Mario Pontes', 'Rua do Paço, 67', 'Rio de Janeiro', '05454-876', 'BR', '(21) 555-0091', ''),
  ('06006072', 'Pascale Cartrain', 'Boulevard Tirou, 255', 'Charleroi', 'B-6000', 'BE', '(071) 23 67 22 20', ''),
  ('06006082', 'Matti Karttunen', 'Keskuskatu 45', 'Helsinki', '21240', 'FI', '90-224 8858', ''),
  ('06006112', 'Basuki Setio', 'German Centre Serpong BSD', 'Serpong BSD', '', 'ID', '', '08159706748'),
  ('06006130', 'Rene Phillips', '2743 Bering St.', 'Anchorage', '99508', 'US', '(907) 555-7584', ''),
  ('06006203', 'Ari Yanuar Ridwan, S.T., M.T.', 'Jl. Sari Asih 54', 'Bandung', '40151', 'ID', '022-2009564', '08157119611'),
  ('06006276', 'Diego Roel', 'C/ Moralzarzal, 86', 'Madrid', '28034', 'ES', '(91) 555 94 44', ''),
  ('06006297', 'Giovanni Rovelli', 'Via Ludovico il Moro 22', 'Bergamo', '24100', 'IT', '035-640230', ''),
  ('06006300', 'Syaiful Rahman, M.Kom', 'Dg. Tata I Blok V BTN Tirta Mas F/2', 'Makassar', '90255', 'ID', '0411-881009', '08152548513'),
  ('06006376', 'Helen Bennett', 'Garden House Crowther Way', 'Cowes', 'PO31 7PJ', 'GB', '(198) 555-8888', ''),
  ('06006449', 'Liu Wong', '55 Grizzly Peak Rd.', 'Butte', '59801', 'US', '(406) 555-5834', ''),
  ('06006459', 'Elizabeth Lincoln', '23 Tsawassen Blvd.', 'Tsawassen', 'T2F 8M4', 'CA', '(604) 555-4729', ''),
  ('06006488', 'Ir. Witarto Adi, M.T.', 'Kebon Bibit Tengah I No. 11-B', 'Bandung', '40116', 'ID', '022-2507109', ''),
  ('06006532', 'Laura Callahan', '4726 - 11th Ave. N.E.', 'Seattle', '98105', 'US', '(206) 555-1189', ''),
  ('06006538', 'Dominique Perrier', '25, rue Lauriston', 'Paris', '75016', 'FR', '(1) 47.55.60.10', ''),
  ('06006619', 'Abdullah', 'Hartaco Blok IV AF 5', 'Makassar', '90224', 'ID', '0411-888616', '081342465515'),
  ('06006624', 'Yeffry Handoko Putra, M.T.', 'Jl. Dipatiukur 112', 'Bandung', '40132', 'ID', '022-25033825', '081320718547'),
  ('06006682', 'Brury Trya Sartana, M.M., M.Kom.', 'Komplek PPI II Blok A5/7, Pondok Aren', 'Tangerang', '', 'ID', '021-68080095', '08129731933'),
  ('06006700', 'Victoria Ashworth', 'Fauntleroy Circus', 'London', 'EC2 5NT', 'GB', '(171) 555-1212', ''),
  ('06006830', 'Gunawan Putrodjojo', 'UPH Tower, Gedung B Lt. 3, Ruang 347, Lippo Karawaci', 'Tangerang', '15811', 'ID', '021-5460901 ext. 353', '08158984972'),
  ('06006863', 'José Pedro Freyre', 'C/ Romero, 33', 'Sevilla', '41101', 'ES', '(95) 555 82 82', ''),
  ('06006898', 'Lusiana, M.Kom.', 'Jl. Purwodadi Indah KM. 10, Panam', 'Pekanbaru', '', 'ID', '0761-7047091', '08127516817'),
  ('06006949', 'Guillermo Fernández', 'Calle Dr. Jorge Cash 321', 'México D.F.', '05033', 'MX', '(5) 552-3745', ''),
  ('06006964', 'Sven Ottlieb', 'Walserweg 21', 'Aachen', '52066', 'DE', '0241-039123', ''),
  ('06007037', 'Hery Dwi Yulianto, S.T.', 'Jl. Kubang Sari No. 38A', 'Bandung', '40134', 'ID', '022-25033825', '081322416022'),
  ('06007066', 'Elizabeth Brown', 'Berkeley Gardens 12  Brewery ', 'London', 'WX1 6LT', 'GB', '(171) 555-2282', ''),
  ('06007072', 'Paolo Accorti', 'Via Monte Bianco 34', 'Torino', '10100', 'IT', '011-4988260', ''),
  ('06007090', 'Janoe Hendarto, Drs., M.Kom.', 'Perum.Kartindah I No C4-56, Kasihan, Bantul - DIY ', 'Yogyakarta', '55184', 'ID', '0274-413254', '08122769312'),
  ('06007140', 'Annette Roulet', '1 rue Alsace-Lorraine', 'Toulouse', '31000', 'FR', '61.77.61.10', ''),
  ('06007158', 'Benny Yustim', 'Jl. Cikutra No. 204A', 'Bandung', '40125', 'ID', '022-7206713 ext. 140', '08161809891'),
  ('06007168', 'Dr. Muhammad Zarlis', 'Jl. Universitas 24A Kampus USU', 'Medan', '20155', 'ID', '061-8221379', '081361724905'),
  ('06007209', 'Donny B. U.', 'Jl. Damai Poncol II/26, Pondok Gede', 'Bekasi', '17411', 'ID', '', '0818930932'),
  ('06007243', 'Pujiono, S.Si, M.Kom.', 'Jl. Nakula I No 5-11', 'Semarang', '50313', 'ID', '024-3517216', '08122579804'),
  ('06007337', 'Laurence Lebihan', '12, rue des Bouchers', 'Marseille', '13008', 'FR', '91.24.45.40', ''),
  ('06007400', 'Ir. Sablin Yusuf, M.Sc., M.CompSc.', 'Jl. KH Syahdan No 9 Kemanggisan, Palmerah', 'Jakarta', '11480', 'ID', '021-5345830 ext 2206', '081877158'),
  ('06007410', 'Pedro Afonso', 'Av. dos Lusíadas, 23', 'São Paulo', '05432-043', 'BR', '(11) 555-7647', ''),
  ('06007419', 'Tachbir Hendro, M.T.', 'Jl.Soekarno Hatta No.211', 'Bandung', '40235', 'ID', '022-5230382', '081320689169'),
  ('06007477', 'Iwan Syarif', 'PENS ITS, Kampus ITS Sukolilo', 'Surabaya', '60111', 'ID', '031-5947280 ext. 1113', '0811324924'),
  ('06007524', 'Wahyuni', 'Gg. Sumberan 2 no . 17 Jl. Damai Ngaglik Sleman', 'Yogyakarta', '55121', 'ID', '', '0811268996'),
  ('06007526', 'Janet Leverling', '722 Moss Bay Blvd.', 'Kirkland', '98033', 'US', '(206) 555-3412', ''),
  ('06007535', 'Drs. Sujalwo, M.Kom.', 'Jl. A.Yani Tromo Pos I, Pabelan', 'Surakarta', '57102', 'ID', '0271-719483 ext. 230', '08122620604'),
  ('06007599', 'Martín Sommer', 'C/ Araquil, 67', 'Madrid', '28023', 'ES', '(91) 555 22 82', ''),
  ('06007687', 'Sujarno, S.Kom.', 'Jl. Rumbia No. 15', 'Selapanjang', '28753', 'ID', '0763-434684', '085271499873'),
  ('06007701', 'Helvetius Nagy', '722 DaVinci Blvd.', 'Kirkland', '98034', 'US', '(206) 555-8257', ''),
  ('06007757', 'Peter Franken', 'Berliner Platz 43', 'München', '80805', 'DE', '089-0877310', ''),
  ('06007808', 'Janine Labrune', '67, rue des Cinquante Otages', 'Nantes', '44000', 'FR', '40.67.88.88', ''),
  ('06007824', 'Carlos González', 'Carrera 52 con Ave. Bolívar #65-98 Llano Largo', 'Barquisimeto', '3508', 'VE', '(9) 331-6954', ''),
  ('06007866', 'Paula Wilson', '2817 Milton Dr.', 'Albuquerque', '87110', 'US', '(505) 555-5939', ''),
  ('06007875', 'Robert King', 'Edgeham Hollow Winchester Way', 'London', 'RG1 9SP', 'GB', '(71) 555-5598', ''),
  ('06007969', 'G. P. Daliyo', 'Sekip Flat C-3', 'Yogyakarta', '55281', 'ID', '0274-586583', '0811269359'),
  ('06008178', 'Hendrik', 'Jl. Kaliurang KM 14.5', 'Yogyakarta', '', 'ID', '0274-895287 ext. 122', '08122742953'),
  ('06008330', 'Fredy Purnomo, S.Kom., M.M.', 'Jl. KH Syahdan No 9 Kemanggisan, Palmerah', 'Jakarta', '11480', 'ID', '021-5345830 ext. 2230', '08159152650'),
  ('06008341', 'Dr. Cecilia Esti Nugraheni', 'Jl. Ciumbuleuit 94', 'Bandung', '40141', 'ID', '022-2041964 ext. 714', '081573056577'),
  ('06008352', 'Philip Cramer', 'Maubelstr. 90', 'Brandenburg', '14776', 'DE', '0555-09876', ''),
  ('06008383', 'Marie Bertrand', '265, boulevard Charonne', 'Paris', '75012', 'FR', '(1) 42.34.22.66', ''),
  ('06008384', 'Sigit Priyanta, S.Si., M.Kom.', 'Sekip Unit III, Bulak Sumur', 'Yogyakarta', '55281', 'ID', '0274-546194', '08156854663'),
  ('06008413', 'Carine Schmitt', '54, rue Royale', 'Nantes', '44000', 'FR', '40.32.21.21', ''),
  ('06008481', 'Alexander Feuer', 'Heerstr. 22', 'Leipzig', '04179', 'DE', '0342-023176', ''),
  ('06008641', 'Arief Fadillah, S.E.', 'Jl. Raya Serang KM. 10 Bitung', 'Tangerang', '15000', 'ID', '021-59492836', '081511938438'),
  ('06008680', 'Iyan Mulyana, S.Kom.', 'Jl. Pakuan PO BOX 452', 'Bogor', '16144', 'ID', '0251-363419', '081318103370'),
  ('06008699', 'Once Kurniawan', 'Jl. Lodan Raya No. 2', 'Jakarta Utara', '', 'ID', '', '0812867984'),
  ('06008708', 'Michael Suyama', 'Coventry House Miner Rd.', 'London', 'EC2 7JR', 'GB', '(71) 555-7773', ''),
  ('06008738', 'Ericks Rachmat Swedia, S.T.', 'Jl. Pondok Bambu Kuning 31/7, Bojonggede', 'Bogor', '16343', 'ID', '021-78881112 ext. 501', ''),
  ('06008745', 'Irwan Sembiring , S.T., M.Kom.', 'Jl. Diponegoro 52 - 60', 'Salatiga', '50711', 'ID', '0298-7102212', '08562867047'),
  ('06008769', 'Jusak Irawan, Ph.D.', 'Jl. Raya Kedung Baruk No. 98', 'Surabaya', '60298', 'ID', '031-8721731', '031-70081591'),
  ('06008816', 'Arfan Yunus, SE.', 'BTN Kumala Sari Blok AD 6 / 16', 'Makassar', '', 'ID', '0411-513723', '08164384858'),
  ('06008843', 'Martine Rancé', '184, chaussée de Tournai', 'Lille', '59000', 'FR', '20.16.10.16', ''),
  ('06008868', 'Nancy Davolio', '507 - 20th Ave. E. Apt. 2A', 'Seattle', '98122', 'US', '(206) 555-9857', ''),
  ('06009008', 'Edy Mulyanto, M.Kom.', 'Jl. Sendangsari Utara Raya No. 28', 'Semarang', '50198', 'ID', '024-6732878', '0811275664'),
  ('06009009', 'Rusydi Umar, S.T., M.T.', 'Perumahan Semarangan No. 9 Jl Godean KM 8', 'Yogyakarta', '', 'ID', '0274-379418 ext. 329', '08882770708'),
  ('06009080', 'Budi Indiarto, M.Kom.', 'Jl. Perbanas Karet Kuningan, SetiaBudi', 'Jakarta Selatan', '12940', 'ID', '021-70760454', '08128305600'),
  ('06009126', 'Antonio Moreno', 'Mataderos  2312', 'México D.F.', '05023', 'MX', '(5) 555-3932', ''),
  ('06009173', 'Andrew Fuller', '908 W. Capital Way', 'Tacoma', '98401', 'US', '(206) 555-9482', ''),
  ('06009259', 'Jumadi', 'Kp. Baru 19B RT.2/5 Kel Cigending Kec. Ujungberung', 'Bandung', '40611', 'ID', '022-85871555', '022-70253382'),
  ('06009303', 'H. Moch. Wahyudi', 'Jl. Salemba Raya no. 5', 'Jakarta Pusat', '10440', 'ID', '021-39843007', '0811959851'),
  ('06009361', 'Andrian Rakhmatsyah', 'Jl. Telekomunikasi No. 1 Dayeuhkolot', 'Bandung', '40375', 'ID', '022-7564108 ext. 2221', '081320603778'),
  ('06009390', 'Jonas Bergulfsen', 'Erling Skakkes gate 78', 'Stavern', '4110', 'NO', '07-98 92 35', ''),
  ('06009456', 'Miguel Angel Paolino', 'Avda. Azteca 123', 'México D.F.', '05033', 'MX', '(5) 555-2933', ''),
  ('06009482', 'Deni Mahdiana, S.Kom., M.M.', 'Jl. Ciledug Raya, Petukangan Utara, Kebayoran Lama', 'Jakarta Selatan', '12260', 'ID', '021-5853753', '08159138879'),
  ('06009557', 'Patricio Simpson', 'Cerrito 333', 'Buenos Aires', '1010', 'AR', '(1) 135-5555', ''),
  ('06009602', 'Dody Herdiana, S.T.', 'Jl. Angkrek Situ No. 19', 'Sumedang', '45323', 'ID', '0261-207395', '081573207285'),
  ('06009649', 'Yulison Chrisnanto, M.T.', 'Jl. Cikutra Dalam 34', 'Bandung', '40124', 'ID', '022-7278075', '081321350393'),
  ('06009653', 'Prof. Suryo Guritno, Ph. D. ', 'Sekip Blok N-40', 'Yogyakarta', '55281', 'ID', '0274-587427', '0811253332'),
  ('06009660', 'Drs. Ino Suryana, M.Kom.', 'Jl. Marga Asri IIIE, Blok C No 58 Bumi Asri, Gempolsari', 'Bandung', '40215', 'ID', '022-6041647', '0818225342'),
  ('06009716', 'Lúcia Carvalho', 'Alameda dos Canàrios, 891', 'São Paulo', '05487-020', 'BR', '(11) 555-1189', ''),
  ('06009719', 'Renate Messner', 'Magazinweg 7', 'Frankfurt a.M. ', '60528', 'DE', '069-0245984', ''),
  ('06009741', 'Simon Crowther', 'South House 300 Queensbridge', 'London', 'SW7 1RZ', 'GB', '(171) 555-7733', ''),
  ('06009771', 'Khodijah Hulliyah, S.Kom.', 'Perum. Bukit Parung Asri Blok D/5, WR.Gedik, BJ.Sempu, Parung', 'Bogor', '16330', 'ID', '021-7493606', '08128947537'),
  ('06009804', 'Christina Berglund', 'Berguvsvägen  8', 'Luleå', 'S-958 22', 'SE', '0921-12 34 65', ''),
  ('06009861', 'Margaret Peacock', '4110 Old Redmond Rd.', 'Redmond', '98052', 'US', '(206) 555-8122', ''),
  ('06009935', 'Katon Wijana', 'Jl. Dr. Wahidin Sudirohusodo 5-21', 'Yogyakarta', '55224', 'ID', '0274-563929', '0811255488'),
  ('06009936', 'Yoshi Latimer', 'City Center Plaza 516 Main St.', 'Elgin', '97827', 'US', '(503) 555-6874', ''),
  ('06009996', 'Nursinah', 'Jl. S. Kelara No. 2', 'Makassar', '90121', 'ID', '0411-321752', '081524164956');
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `rooms`
  --
  
  CREATE TABLE `rooms` (
    `room` varchar(4) NOT NULL,
    `rtype` char(1) NOT NULL,
    `dview` char(1) NOT NULL,
    `smoke` tinyint(1) DEFAULT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `rooms`
  --
  
  INSERT INTO `rooms` (`room`, `rtype`, `dview`, `smoke`) VALUES
  ('1001', 'A', 'O', 0),
  ('1002', 'A', 'C', 0),
  ('1003', 'A', 'O', 0),
  ('1004', 'A', 'C', 0),
  ('1005', 'A', 'O', 0),
  ('1006', 'A', 'C', 0),
  ('1007', 'A', 'O', 0),
  ('1008', 'A', 'C', 0),
  ('1009', 'B', 'O', 0),
  ('1010', 'B', 'C', 0),
  ('1011', 'B', 'O', 0),
  ('1012', 'B', 'C', 0),
  ('1013', 'B', 'O', 0),
  ('1014', 'B', 'C', 0),
  ('1015', 'C', 'O', 0),
  ('1016', 'C', 'C', 0),
  ('1017', 'C', 'O', 0),
  ('1018', 'C', 'C', 0),
  ('1019', 'C', 'O', 0),
  ('1020', 'C', 'C', 0),
  ('1101', 'B', 'O', 0),
  ('1102', 'B', 'C', 0),
  ('1103', 'B', 'O', 0),
  ('1104', 'B', 'C', 0),
  ('1105', 'B', 'O', 0),
  ('1106', 'B', 'C', 0),
  ('1107', 'C', 'O', 0),
  ('1108', 'C', 'C', 0),
  ('1109', 'C', 'O', 0),
  ('1110', 'C', 'C', 0),
  ('1111', 'C', 'O', 0),
  ('1112', 'C', 'C', 0),
  ('1113', 'D', 'O', 0),
  ('1114', 'D', 'C', 0),
  ('1115', 'D', 'O', 0),
  ('1116', 'D', 'C', 0),
  ('1201', 'B', 'O', 0),
  ('1202', 'B', 'C', 0),
  ('1203', 'B', 'O', 0),
  ('1204', 'B', 'C', 0),
  ('1205', 'B', 'O', 0),
  ('1206', 'B', 'C', 0),
  ('1207', 'C', 'O', 0),
  ('1208', 'C', 'C', 0),
  ('1209', 'C', 'O', 0),
  ('1210', 'C', 'C', 0),
  ('1211', 'C', 'O', 0),
  ('1212', 'C', 'C', 0),
  ('1213', 'D', 'O', 0),
  ('1214', 'D', 'C', 0),
  ('1215', 'D', 'O', 0),
  ('1216', 'D', 'C', 0),
  ('1301', 'B', 'O', 0),
  ('1302', 'B', 'C', 0),
  ('1303', 'B', 'O', 0),
  ('1304', 'B', 'C', 0),
  ('1305', 'B', 'O', 0),
  ('1306', 'B', 'C', 0),
  ('1307', 'C', 'O', 0),
  ('1308', 'C', 'C', 0),
  ('1309', 'C', 'O', 0),
  ('1310', 'C', 'C', 0),
  ('1311', 'C', 'O', 0),
  ('1312', 'C', 'C', 0),
  ('1313', 'D', 'O', 0),
  ('1314', 'D', 'C', 0),
  ('1315', 'D', 'O', 0),
  ('1316', 'D', 'C', 0),
  ('1401', 'B', 'O', 0),
  ('1402', 'B', 'C', 0),
  ('1403', 'B', 'O', 0),
  ('1404', 'B', 'C', 0),
  ('1405', 'B', 'O', 0),
  ('1406', 'B', 'C', 0),
  ('1407', 'C', 'O', 0),
  ('1408', 'C', 'C', 0),
  ('1409', 'C', 'O', 0),
  ('1410', 'C', 'C', 0),
  ('1411', 'C', 'O', 0),
  ('1412', 'C', 'C', 0),
  ('1413', 'D', 'O', 0),
  ('1414', 'D', 'C', 0),
  ('1415', 'D', 'O', 0),
  ('1416', 'D', 'C', 0),
  ('1501', 'C', 'O', 0),
  ('1502', 'C', 'C', 0),
  ('1503', 'C', 'O', 0),
  ('1504', 'C', 'C', 0),
  ('1505', 'C', 'O', 0),
  ('1506', 'C', 'C', 0),
  ('1507', 'C', 'O', 0),
  ('1508', 'C', 'C', 0),
  ('1509', 'D', 'O', 0),
  ('1510', 'D', 'C', 0),
  ('1511', 'E', 'O', 0),
  ('1512', 'E', 'C', 0),
  ('201', 'A', 'O', 1),
  ('202', 'A', 'C', 1),
  ('203', 'A', 'O', 1),
  ('204', 'A', 'C', 1),
  ('205', 'A', 'O', 1),
  ('206', 'A', 'C', 1),
  ('207', 'A', 'O', 1),
  ('208', 'A', 'C', 1),
  ('209', 'A', 'O', 1),
  ('210', 'A', 'C', 1),
  ('211', 'A', 'O', 1),
  ('212', 'A', 'C', 1),
  ('213', 'B', 'O', 1),
  ('214', 'B', 'C', 1),
  ('215', 'B', 'O', 1),
  ('216', 'B', 'C', 1),
  ('217', 'C', 'O', 1),
  ('218', 'C', 'C', 1),
  ('219', 'C', 'O', 1),
  ('220', 'C', 'C', 1),
  ('301', 'A', 'O', 1),
  ('302', 'A', 'C', 1),
  ('303', 'A', 'O', 1),
  ('304', 'A', 'C', 1),
  ('305', 'A', 'O', 1),
  ('306', 'A', 'C', 1),
  ('307', 'A', 'O', 1),
  ('308', 'A', 'C', 1),
  ('309', 'A', 'O', 1),
  ('310', 'A', 'C', 1),
  ('311', 'A', 'O', 1),
  ('312', 'A', 'C', 1),
  ('313', 'B', 'O', 1),
  ('314', 'B', 'C', 1),
  ('315', 'B', 'O', 1),
  ('316', 'B', 'C', 1),
  ('317', 'C', 'O', 1),
  ('318', 'C', 'C', 1),
  ('319', 'C', 'O', 1),
  ('320', 'C', 'C', 1),
  ('401', 'A', 'O', 0),
  ('402', 'A', 'C', 0),
  ('403', 'A', 'O', 0),
  ('404', 'A', 'C', 0),
  ('405', 'A', 'O', 0),
  ('406', 'A', 'C', 0),
  ('407', 'A', 'O', 0),
  ('408', 'A', 'C', 0),
  ('409', 'A', 'O', 0),
  ('410', 'A', 'C', 0),
  ('411', 'A', 'O', 0),
  ('412', 'A', 'C', 0),
  ('413', 'B', 'O', 0),
  ('414', 'B', 'C', 0),
  ('415', 'B', 'O', 0),
  ('416', 'B', 'C', 0),
  ('417', 'C', 'O', 0),
  ('418', 'C', 'C', 0),
  ('419', 'C', 'O', 0),
  ('420', 'C', 'C', 0),
  ('501', 'A', 'O', 0),
  ('502', 'A', 'C', 0),
  ('503', 'A', 'O', 0),
  ('504', 'A', 'C', 0),
  ('505', 'A', 'O', 0),
  ('506', 'A', 'C', 0),
  ('507', 'A', 'O', 0),
  ('508', 'A', 'C', 0),
  ('509', 'B', 'O', 0),
  ('510', 'B', 'C', 0),
  ('511', 'B', 'O', 0),
  ('512', 'B', 'C', 0),
  ('513', 'B', 'O', 0),
  ('514', 'B', 'C', 0),
  ('515', 'C', 'O', 0),
  ('516', 'C', 'C', 0),
  ('517', 'C', 'O', 0),
  ('518', 'C', 'C', 0),
  ('519', 'C', 'O', 0),
  ('520', 'C', 'C', 0),
  ('601', 'A', 'O', 0),
  ('602', 'A', 'C', 0),
  ('603', 'A', 'O', 0),
  ('604', 'A', 'C', 0),
  ('605', 'A', 'O', 0),
  ('606', 'A', 'C', 0),
  ('607', 'A', 'O', 0),
  ('608', 'A', 'C', 0),
  ('609', 'B', 'O', 0),
  ('610', 'B', 'C', 0),
  ('611', 'B', 'O', 0),
  ('612', 'B', 'C', 0),
  ('613', 'B', 'O', 0),
  ('614', 'B', 'C', 0),
  ('615', 'C', 'O', 0),
  ('616', 'C', 'C', 0),
  ('617', 'C', 'O', 0),
  ('618', 'C', 'C', 0),
  ('619', 'C', 'O', 0),
  ('620', 'C', 'C', 0),
  ('701', 'A', 'O', 0),
  ('702', 'A', 'C', 0),
  ('703', 'A', 'O', 0),
  ('704', 'A', 'C', 0),
  ('705', 'A', 'O', 0),
  ('706', 'A', 'C', 0),
  ('707', 'A', 'O', 0),
  ('708', 'A', 'C', 0),
  ('709', 'B', 'O', 0),
  ('710', 'B', 'C', 0),
  ('711', 'B', 'O', 0),
  ('712', 'B', 'C', 0),
  ('713', 'B', 'O', 0),
  ('714', 'B', 'C', 0),
  ('715', 'C', 'O', 0),
  ('716', 'C', 'C', 0),
  ('717', 'C', 'O', 0),
  ('718', 'C', 'C', 0),
  ('719', 'C', 'O', 0),
  ('720', 'C', 'C', 0),
  ('801', 'A', 'O', 0),
  ('802', 'A', 'C', 0),
  ('803', 'A', 'O', 0),
  ('804', 'A', 'C', 0),
  ('805', 'A', 'O', 0),
  ('806', 'A', 'C', 0),
  ('807', 'A', 'O', 0),
  ('808', 'A', 'C', 0),
  ('809', 'B', 'O', 0),
  ('810', 'B', 'C', 0),
  ('811', 'B', 'O', 0),
  ('812', 'B', 'C', 0),
  ('813', 'B', 'O', 0),
  ('814', 'B', 'C', 0),
  ('815', 'C', 'O', 0),
  ('816', 'C', 'C', 0),
  ('817', 'C', 'O', 0),
  ('818', 'C', 'C', 0),
  ('819', 'C', 'O', 0),
  ('820', 'C', 'C', 0),
  ('901', 'A', 'O', 0),
  ('902', 'A', 'C', 0),
  ('903', 'A', 'O', 0),
  ('904', 'A', 'C', 0),
  ('905', 'A', 'O', 0),
  ('906', 'A', 'C', 0),
  ('907', 'A', 'O', 0),
  ('908', 'A', 'C', 0),
  ('909', 'B', 'O', 0),
  ('910', 'B', 'C', 0),
  ('911', 'B', 'O', 0),
  ('912', 'B', 'C', 0),
  ('913', 'B', 'O', 0),
  ('914', 'B', 'C', 0),
  ('915', 'C', 'O', 0),
  ('916', 'C', 'C', 0),
  ('917', 'C', 'O', 0),
  ('918', 'C', 'C', 0),
  ('919', 'C', 'O', 0),
  ('920', 'C', 'C', 0);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `roomtype`
  --
  
  CREATE TABLE `roomtype` (
    `kode` char(1) NOT NULL,
    `rtype` varchar(25) NOT NULL,
    `rate` int(11) NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `roomtype`
  --
  
  INSERT INTO `roomtype` (`kode`, `rtype`, `rate`) VALUES
  ('A', 'Standard', 460000),
  ('B', 'Deluxe Twin', 600000),
  ('C', 'Deluxe Double', 630000),
  ('D', 'Suite', 1100000),
  ('E', 'Presidential Suite', 5200000);
  
  -- --------------------------------------------------------
  
  --
  -- Table structure for table `views`
  --
  
  CREATE TABLE `views` (
    `vcode` char(1) NOT NULL,
    `dview` varchar(20) NOT NULL,
    `addv` double NOT NULL
  ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  
  --
  -- Dumping data for table `views`
  --
  
  INSERT INTO `views` (`vcode`, `dview`, `addv`) VALUES
  ('C', 'City View', 0),
  ('O', 'Ocean View', 0.25);
  
  --
  -- Indexes for dumped tables
  --
  
  --
  -- Indexes for table `country`
  --
  ALTER TABLE `country`
    ADD PRIMARY KEY (`CC`);
  
  --
  -- Indexes for table `members`
  --
  ALTER TABLE `members`
    ADD PRIMARY KEY (`member_ID`);
  
  --
  -- Indexes for table `rooms`
  --
  ALTER TABLE `rooms`
    ADD PRIMARY KEY (`room`);
  
  --
  -- Indexes for table `roomtype`
  --
  ALTER TABLE `roomtype`
    ADD PRIMARY KEY (`kode`);
  
  --
  -- Indexes for table `views`
  --
  ALTER TABLE `views`
    ADD PRIMARY KEY (`vcode`);
  COMMIT;
  
  /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
  