# phpMyAdmin MySQL-Dump
# version 2.3.0-rc1
# http://phpwizard.net/phpMyAdmin/
# http://www.phpmyadmin.net/ (download page)
#
# Host: localhost
# Generation Time: Jul 03, 2002 at 05:22 PM
# Server version: 3.23.49
# PHP Version: 4.2.1
# Database : `xoopsdb`
# --------------------------------------------------------

#
# Table structure for table `city`
#

CREATE TABLE city (
  accid varchar(5) NOT NULL default '',
  city_title varchar(50) NOT NULL default '',
  subdiv_id int(4) NOT NULL default '0',
  PRIMARY KEY  (accid),
  KEY city_title (city_title)
) TYPE=MyISAM;

#
# Contenu de la table `city`
#
INSERT INTO city VALUES ('IL27','Monticello',55);
INSERT INTO city VALUES ('IL52','Taylorville',55);
INSERT INTO city VALUES ('ILG','Wilmington',31);
INSERT INTO city VALUES ('ILM','Wilmington',90);
INSERT INTO city VALUES ('IMT','Iron Mountain',84);
INSERT INTO city VALUES ('IN03','Bluffton',56);
INSERT INTO city VALUES ('IN04','Boonville',56);
INSERT INTO city VALUES ('IN05','Brazil',56);
INSERT INTO city VALUES ('IN31','Lebanon',56);
INSERT INTO city VALUES ('IND','Indianapolis',56);
INSERT INTO city VALUES ('INK','Wink',151);
INSERT INTO city VALUES ('INL','International Falls',85);
INSERT INTO city VALUES ('INT','Winston-Salem',90);
INSERT INTO city VALUES ('INW','Winslow',10);
INSERT INTO city VALUES ('IOW','Iowa City',52);
INSERT INTO city VALUES ('IPL','Imperial',20);
INSERT INTO city VALUES ('IPT','Williamsport',113);
INSERT INTO city VALUES ('IRK','Kirkville',52);
INSERT INTO city VALUES ('ISN','Williston',91);
INSERT INTO city VALUES ('ISO','Kinston',90);
INSERT INTO city VALUES ('ISP','Islip',108);
INSERT INTO city VALUES ('IST','Istanbul',150);
INSERT INTO city VALUES ('ISW','Island Park',54);
INSERT INTO city VALUES ('ITH','Ithaca',108);
INSERT INTO city VALUES ('ITO','Hilo',49);
INSERT INTO city VALUES ('IWD','Ironwood',84);
INSERT INTO city VALUES ('JAC','Jackson',166);
INSERT INTO city VALUES ('JAN','Jackson',88);
INSERT INTO city VALUES ('JAX','Jacksonville',39);
INSERT INTO city VALUES ('JBK','Berkeley',20);
INSERT INTO city VALUES ('JBR','Jonesboro',6);
INSERT INTO city VALUES ('JCT','Junction',151);
INSERT INTO city VALUES ('JDN','Jordan',89);
INSERT INTO city VALUES ('JDY','Downey',20);
INSERT INTO city VALUES ('JEF','Jefferson City',86);
INSERT INTO city VALUES ('JFK','New York/JFK',108);
INSERT INTO city VALUES ('JHW','Jamestown',108);
INSERT INTO city VALUES ('JKL','Jackson',71);
INSERT INTO city VALUES ('JLN','Joplin',86);
INSERT INTO city VALUES ('JMS','Jamestown',91);
INSERT INTO city VALUES ('JNB','Johannesburg',136);
INSERT INTO city VALUES ('JNU','Juneau',1);
INSERT INTO city VALUES ('JRS','Jerusalem',62);
INSERT INTO city VALUES ('JSD','Stratford',25);
INSERT INTO city VALUES ('JST','Johnstown',113);
INSERT INTO city VALUES ('JVL','Janesville',164);
INSERT INTO city VALUES ('JXN','Jackson',84);
INSERT INTO city VALUES ('KCK','Kansas City',69);
INSERT INTO city VALUES ('KCO','Keystone',23);
INSERT INTO city VALUES ('KHI','Karachi',114);
INSERT INTO city VALUES ('KIL','Killington',161);
INSERT INTO city VALUES ('KIN','Kingston',65);
INSERT INTO city VALUES ('KKW','Kirkwood',86);
INSERT INTO city VALUES ('KLV','Killington',161);
INSERT INTO city VALUES ('KOA','Kailua',49);
INSERT INTO city VALUES ('KTN','Ketchikan',1);
INSERT INTO city VALUES ('KUL','Kuala Lumpur',77);
INSERT INTO city VALUES ('KWI','Kuwait',70);
INSERT INTO city VALUES ('L09','Death Valley',20);
INSERT INTO city VALUES ('L12','Redlands',20);
INSERT INTO city VALUES ('L35','Big Bear',20);
INSERT INTO city VALUES ('L66','Corona',20);
INSERT INTO city VALUES ('L67','Rialto',20);
INSERT INTO city VALUES ('L85','Lucerne Valley',20);
INSERT INTO city VALUES ('LA05','Chalmette',72);
INSERT INTO city VALUES ('LA08','Coushatta',72);
INSERT INTO city VALUES ('LA16','Homer',72);
INSERT INTO city VALUES ('LA18','Jonesboro',72);
INSERT INTO city VALUES ('LA19','Lake Providence',72);
INSERT INTO city VALUES ('LA24','New Roads',72);
INSERT INTO city VALUES ('LA26','Opelousas',72);
INSERT INTO city VALUES ('LA30','Rayville',72);
INSERT INTO city VALUES ('LA31','Reserve',72);
INSERT INTO city VALUES ('LA32','Simsboro',72);
INSERT INTO city VALUES ('LA34','St. Francisville',72);
INSERT INTO city VALUES ('LA35','St. Joseph',72);
INSERT INTO city VALUES ('LA37','Tallulah',72);
INSERT INTO city VALUES ('LAF','Lafayette',56);
INSERT INTO city VALUES ('LAH','Hanover',98);
INSERT INTO city VALUES ('LAL','Lakeland',39);
INSERT INTO city VALUES ('LAM','Los Alamos',102);
INSERT INTO city VALUES ('LAN','Lansing',84);
INSERT INTO city VALUES ('LAP','La Paz',83);
INSERT INTO city VALUES ('LAR','Laramie',166);
INSERT INTO city VALUES ('LAS','Las Vegas',107);
INSERT INTO city VALUES ('LAX','Los Angeles Coast',20);
INSERT INTO city VALUES ('LBB','Lubbock',151);
INSERT INTO city VALUES ('LBE','Latrobe',113);
INSERT INTO city VALUES ('LBF','North Platte',92);
INSERT INTO city VALUES ('LBL','Liberal',69);
INSERT INTO city VALUES ('LCH','Lake Charles',72);
INSERT INTO city VALUES ('LCI','Laconia',98);
INSERT INTO city VALUES ('LCK','Rickenbacker AFB',109);
INSERT INTO city VALUES ('LEB','Lebanon',98);
INSERT INTO city VALUES ('LED','St. Petersburg',126);
INSERT INTO city VALUES ('LEE','Leesville',72);
INSERT INTO city VALUES ('LEW','Lewiston',82);
INSERT INTO city VALUES ('LEX','Lexington',71);
INSERT INTO city VALUES ('LFI','Langley AFB',157);
INSERT INTO city VALUES ('LFK','Lufkin',151);
INSERT INTO city VALUES ('LFT','Lafayette',72);
INSERT INTO city VALUES ('LGA','New York City',108);
INSERT INTO city VALUES ('LGB','Long Beach',20);
INSERT INTO city VALUES ('LGU','Logan',156);
INSERT INTO city VALUES ('LHQ','Lancaster',109);
INSERT INTO city VALUES ('LHR','London',154);
INSERT INTO city VALUES ('LHV','Lock Haven',113);
INSERT INTO city VALUES ('LHX','La Junta',23);
INSERT INTO city VALUES ('LIC','Limon',23);
INSERT INTO city VALUES ('LIH','Lihue',49);
INSERT INTO city VALUES ('LIM','Lima',117);
INSERT INTO city VALUES ('LIS','Lisbon',120);
INSERT INTO city VALUES ('LIT','Little Rock',6);
INSERT INTO city VALUES ('LIZ','Limestone/Loring AFB',82);
INSERT INTO city VALUES ('LMT','Klamath Falls',112);
INSERT INTO city VALUES ('LND','Lander',166);
INSERT INTO city VALUES ('LNK','Lincoln',92);
INSERT INTO city VALUES ('LNN','Willoughby',109);
INSERT INTO city VALUES ('LNR','Lone Rock',164);
INSERT INTO city VALUES ('LNS','Lancaster',113);
INSERT INTO city VALUES ('LOL','Lovelock',107);
INSERT INTO city VALUES ('LOS','Lagos',100);
INSERT INTO city VALUES ('LOZ','London',71);
INSERT INTO city VALUES ('LPB','La Paz',17);
INSERT INTO city VALUES ('LPL','Liverpool',154);
INSERT INTO city VALUES ('LRD','Laredo',151);
INSERT INTO city VALUES ('LRF','Little Rock',6);
INSERT INTO city VALUES ('LRU','Las Cruces',102);
INSERT INTO city VALUES ('LSE','La Crosse',164);
INSERT INTO city VALUES ('LSV','Nellis AFB',107);
INSERT INTO city VALUES ('LTA','South Lake Tahoe',20);
INSERT INTO city VALUES ('LTC','South Lake Tahoe',20);
INSERT INTO city VALUES ('LTS','Altus',110);
INSERT INTO city VALUES ('LUN','Lusaka',169);
INSERT INTO city VALUES ('LVK','Livermore',20);
INSERT INTO city VALUES ('LVM','Livingston',89);
INSERT INTO city VALUES ('LVS','Las Vegas',102);
INSERT INTO city VALUES ('LWM','Lawrence',76);
INSERT INTO city VALUES ('LWS','Lewiston',54);
INSERT INTO city VALUES ('LWT','Lewistown',89);
INSERT INTO city VALUES ('LXV','Leadville',23);
INSERT INTO city VALUES ('LYH','Lynchburg',157);
INSERT INTO city VALUES ('MA01','Dedham',76);
INSERT INTO city VALUES ('MA11','Belmont',76);
INSERT INTO city VALUES ('MA14','Danvers',76);
INSERT INTO city VALUES ('MA18','Reading',76);
INSERT INTO city VALUES ('MAD','Madrid',137);
INSERT INTO city VALUES ('MAF','Midland',151);
INSERT INTO city VALUES ('MAN','Manchester',154);
INSERT INTO city VALUES ('MBL','Manistee',84);
INSERT INTO city VALUES ('MBS','Saginaw',84);
INSERT INTO city VALUES ('MCA','Mammoth Mountain',20);
INSERT INTO city VALUES ('MCB','McComb',88);
INSERT INTO city VALUES ('MCG','McGrath',1);
INSERT INTO city VALUES ('MCI','Kansas City',86);
INSERT INTO city VALUES ('MCK','McCook',92);
INSERT INTO city VALUES ('MCN','Macon',41);
INSERT INTO city VALUES ('MCO','Orlando',39);
INSERT INTO city VALUES ('MCW','Mason City',52);
INSERT INTO city VALUES ('MDH','Carbondale',55);
INSERT INTO city VALUES ('MDT','Middletown',113);
INSERT INTO city VALUES ('MDW','Chicago/Midway',55);
INSERT INTO city VALUES ('MEC','Mecca',128);
INSERT INTO city VALUES ('MEI','Meridian',88);
INSERT INTO city VALUES ('MEL','Melbourne',158);
INSERT INTO city VALUES ('MEM','Memphis',147);
INSERT INTO city VALUES ('MER','Merced',20);
INSERT INTO city VALUES ('MEX','Mexico City',83);
INSERT INTO city VALUES ('MFD','Mansfield',109);
INSERT INTO city VALUES ('MFE','McAllen',151);
INSERT INTO city VALUES ('MFR','Medford',112);
INSERT INTO city VALUES ('MGA','Managua',99);
INSERT INTO city VALUES ('MGE','Marietta',41);
INSERT INTO city VALUES ('MGL','Monteagle',147);
INSERT INTO city VALUES ('MGM','Montgomery',2);
INSERT INTO city VALUES ('MGQ','Mogadishu',135);
INSERT INTO city VALUES ('MGW','Morgantown',165);
INSERT INTO city VALUES ('MHE','Mitchell',130);
INSERT INTO city VALUES ('MHK','Manhattan',69);
INSERT INTO city VALUES ('MHR','Mather Afb',20);
INSERT INTO city VALUES ('MHS','Mount Shasta',20);
INSERT INTO city VALUES ('MHT','Manchester',98);
INSERT INTO city VALUES ('MI06','Brevort',84);
INSERT INTO city VALUES ('MIA','Miami',39);
INSERT INTO city VALUES ('MIC','Crystal',85);
INSERT INTO city VALUES ('MID','Merida',83);
INSERT INTO city VALUES ('MIE','Muncie',56);
INSERT INTO city VALUES ('MIL','Milano',63);
INSERT INTO city VALUES ('MIV','Millville',101);
INSERT INTO city VALUES ('MKE','Milwaukee',164);
INSERT INTO city VALUES ('MKG','Muskegon',84);
INSERT INTO city VALUES ('MKK','Kaunakakai',49);
INSERT INTO city VALUES ('MKL','Jackson',147);
INSERT INTO city VALUES ('MKP','McKeesport',113);
INSERT INTO city VALUES ('MKT','Mankato',85);
INSERT INTO city VALUES ('MKV','Marksville',72);
INSERT INTO city VALUES ('MLB','Melbourne',39);
INSERT INTO city VALUES ('MLC','McAlester',110);
INSERT INTO city VALUES ('MLD','Malad City',54);
INSERT INTO city VALUES ('MLF','Milford',156);
INSERT INTO city VALUES ('MLI','Moline',55);
INSERT INTO city VALUES ('MLM','Morelia',83);
INSERT INTO city VALUES ('MLS','Miles City',89);
INSERT INTO city VALUES ('MLU','Monroe',72);
INSERT INTO city VALUES ('MMH','Mammoth Mountain',20);
INSERT INTO city VALUES ('MMI','Athens',147);
INSERT INTO city VALUES ('MML','Marshall',85);
INSERT INTO city VALUES ('MMO','Marseilles',55);
INSERT INTO city VALUES ('MMU','Morristown',101);
INSERT INTO city VALUES ('MN36','Luverne',85);
INSERT INTO city VALUES ('MN47','Pine City',85);
INSERT INTO city VALUES ('MNL','Manila',118);
INSERT INTO city VALUES ('MNY','McNary',10);
INSERT INTO city VALUES ('MO07','Bethany',86);
INSERT INTO city VALUES ('MO10','Bowling Green',86);
INSERT INTO city VALUES ('MO13','California',86);
INSERT INTO city VALUES ('MO23','Doniphan',86);
INSERT INTO city VALUES ('MO27','Fayette',86);
INSERT INTO city VALUES ('MO35','Greenville',86);
INSERT INTO city VALUES ('MO45','Keytesville',86);
INSERT INTO city VALUES ('MO46','Kingston',86);
INSERT INTO city VALUES ('MO84','Savannah',86);
INSERT INTO city VALUES ('MOB','Mobile',2);
INSERT INTO city VALUES ('MOD','Modesto',20);
INSERT INTO city VALUES ('MOP','Mount Pleasant',84);
INSERT INTO city VALUES ('MOT','Minot',91);
INSERT INTO city VALUES ('MOV','Monclova',83);
INSERT INTO city VALUES ('MPV','Barre-Montpelier',161);
INSERT INTO city VALUES ('MQT','Marquette',84);
INSERT INTO city VALUES ('MRB','Martinsburg',165);
INSERT INTO city VALUES ('MRF','Marfa',151);
INSERT INTO city VALUES ('MRY','Monterey',20);
INSERT INTO city VALUES ('MS31','Picayune',88);
INSERT INTO city VALUES ('MS36','Raleigh',88);
INSERT INTO city VALUES ('MSL','Muscle Shoals',2);
INSERT INTO city VALUES ('MSN','Madison',164);
INSERT INTO city VALUES ('MSO','Missoula',89);
INSERT INTO city VALUES ('MSP','Minneapolis',85);
INSERT INTO city VALUES ('MSS','Massena',108);
INSERT INTO city VALUES ('MSV','Monticello',108);
INSERT INTO city VALUES ('MSY','New Orleans',72);
INSERT INTO city VALUES ('MT02','Wolf Point',89);
INSERT INTO city VALUES ('MTC','Mount Clemens',84);
INSERT INTO city VALUES ('MTJ','Montrose',23);
INSERT INTO city VALUES ('MTP','Montauk',108);
INSERT INTO city VALUES ('MTQ','Ottawa',111);
INSERT INTO city VALUES ('MUC','Munich',43);
INSERT INTO city VALUES ('MUO','Mountain Home',54);
INSERT INTO city VALUES ('MVD','Montevideo',155);
INSERT INTO city VALUES ('MVN','Mount Vernon',55);
INSERT INTO city VALUES ('MVT','Mount Snow',161);
INSERT INTO city VALUES ('MVY','Martha\'s Vineyard',76);
INSERT INTO city VALUES ('MWA','Marion',55);
INSERT INTO city VALUES ('MWI','Winona',88);
INSERT INTO city VALUES ('MWL','Mineral Wells',151);
INSERT INTO city VALUES ('MWN','Mount Washington',98);
INSERT INTO city VALUES ('MWO','Middletown',109);
INSERT INTO city VALUES ('MWS','Mount Wilson',20);
INSERT INTO city VALUES ('MXF','Maxwell AFB',2);
INSERT INTO city VALUES ('MYF','Montgomery Field',20);
INSERT INTO city VALUES ('MYL','McCall',54);
INSERT INTO city VALUES ('MYR','North Myrtle Beach',129);
INSERT INTO city VALUES ('MZT','Mazatlan',83);
INSERT INTO city VALUES ('N05','Hackensack',101);
INSERT INTO city VALUES ('N13','Bloomsburg',113);
INSERT INTO city VALUES ('N21','Princeton',101);
INSERT INTO city VALUES ('N35','Punxsutawney',113);
INSERT INTO city VALUES ('N42','Shippensburg',113);
INSERT INTO city VALUES ('N66','Oneonta',108);
INSERT INTO city VALUES ('N80','Ocean City',81);
INSERT INTO city VALUES ('N97','Clearfield',113);
INSERT INTO city VALUES ('NAP','Naples',63);
INSERT INTO city VALUES ('NAS','Nassau',11);
INSERT INTO city VALUES ('NBC','Beaufort',129);
INSERT INTO city VALUES ('NBO','Nairobi',68);
INSERT INTO city VALUES ('NBU','Glenview',55);
INSERT INTO city VALUES ('NC10','Concord',90);
INSERT INTO city VALUES ('NC22','Hertford',90);
INSERT INTO city VALUES ('NC29','Louisburg',90);
INSERT INTO city VALUES ('NCA','Jacksonville',90);
INSERT INTO city VALUES ('NE02','Alma',92);
INSERT INTO city VALUES ('NEL','Lakehurst',101);
INSERT INTO city VALUES ('NFG','Camp Pendleton',20);
INSERT INTO city VALUES ('NFL','Fallon',107);
INSERT INTO city VALUES ('NGF','Kaneohe',49);
INSERT INTO city VALUES ('NGZ','Alameda',20);
INSERT INTO city VALUES ('NHK','Patuxent River',81);
INSERT INTO city VALUES ('NHZ','Brunswick',82);
INSERT INTO city VALUES ('NIC','Nicosia',28);
INSERT INTO city VALUES ('NIR','Chase Field',151);
INSERT INTO city VALUES ('NJK','El Centro',20);
INSERT INTO city VALUES ('NKT','Cherry Point',90);
INSERT INTO city VALUES ('NKX','Miramar',20);
INSERT INTO city VALUES ('NLC','Lemoore',20);
INSERT INTO city VALUES ('NM01','Ancho',102);
INSERT INTO city VALUES ('NM10','Sunspot',102);
INSERT INTO city VALUES ('NQI','Kingsville',151);
INSERT INTO city VALUES ('NRB','Mayport',39);
INSERT INTO city VALUES ('NRI','North Richland Hills',151);
INSERT INTO city VALUES ('NRS','Imperial Beach',20);
INSERT INTO city VALUES ('NSE','Whiting Field',39);
INSERT INTO city VALUES ('NTC','Tahoe City',20);
INSERT INTO city VALUES ('NTD','Point Mugu',20);
INSERT INTO city VALUES ('NTK','Tustin',20);
INSERT INTO city VALUES ('NTU','Oceana',157);
INSERT INTO city VALUES ('NUQ','Mountain View',20);
INSERT INTO city VALUES ('NUW','Whidbey Island',162);
INSERT INTO city VALUES ('NXX','Willow Grove',113);
INSERT INTO city VALUES ('NY34','Bay Shore',108);
INSERT INTO city VALUES ('NYC','New York - Central Park',108);
INSERT INTO city VALUES ('NYG','Quantico',157);
INSERT INTO city VALUES ('NZA','Auckland',96);
INSERT INTO city VALUES ('NZC','Cecil Field',39);
INSERT INTO city VALUES ('NZJ','El Toro',20);
INSERT INTO city VALUES ('NZW','South Weymouth',76);
INSERT INTO city VALUES ('O43','Yerington',107);
INSERT INTO city VALUES ('O57','Bridgeport',20);
INSERT INTO city VALUES ('O62','Carmel',20);
INSERT INTO city VALUES ('OAK','Oakland',20);
INSERT INTO city VALUES ('OAX','Oaxaca',83);
INSERT INTO city VALUES ('OCF','Ocala',39);
INSERT INTO city VALUES ('ODS','Odessa',152);
INSERT INTO city VALUES ('OFF','Omaha (Offutt)',92);
INSERT INTO city VALUES ('OFK','Norfolk',92);
INSERT INTO city VALUES ('OGA','Ogallala',92);
INSERT INTO city VALUES ('OGD','Ogden',156);
INSERT INTO city VALUES ('OGG','Kahului',49);
INSERT INTO city VALUES ('OH08','Gallipolis',109);
INSERT INTO city VALUES ('OJC','Olathe',69);
INSERT INTO city VALUES ('OK01','Ada',110);
INSERT INTO city VALUES ('OK02','Alva',110);
INSERT INTO city VALUES ('OK03','Anadarko',110);
INSERT INTO city VALUES ('OK04','Antlers',110);
INSERT INTO city VALUES ('OK06','Beaver',110);
INSERT INTO city VALUES ('OK07','Buffalo',110);
INSERT INTO city VALUES ('OK09','Cherokee',110);
INSERT INTO city VALUES ('OK11','Chickasha',110);
INSERT INTO city VALUES ('OK12','Claremore',110);
INSERT INTO city VALUES ('OK14','Cordell',110);
INSERT INTO city VALUES ('OK18','El Reno',110);
INSERT INTO city VALUES ('OK19','Eufaula',110);
INSERT INTO city VALUES ('OK22','Holdenville',110);
INSERT INTO city VALUES ('OK23','Hollis',110);
INSERT INTO city VALUES ('OK24','Hugo',110);
INSERT INTO city VALUES ('OK25','Idabel',110);
INSERT INTO city VALUES ('OK26','Kingfisher',110);
INSERT INTO city VALUES ('OK28','Madill',110);
INSERT INTO city VALUES ('OK31','Medford',110);
INSERT INTO city VALUES ('OK32','Miami',110);
INSERT INTO city VALUES ('OK56','Waurika',110);
INSERT INTO city VALUES ('OK57','Wheeless',110);
INSERT INTO city VALUES ('OK60','Yukon',110);
INSERT INTO city VALUES ('OKC','Oklahoma City',110);
INSERT INTO city VALUES ('OKD','Oakdale',72);
INSERT INTO city VALUES ('OLE','Olean',108);
INSERT INTO city VALUES ('OLM','Olympia',162);
INSERT INTO city VALUES ('OLS','Nogales',10);
INSERT INTO city VALUES ('OMA','Omaha',92);
INSERT INTO city VALUES ('OME','Nome',1);
INSERT INTO city VALUES ('OMK','Omak',162);
INSERT INTO city VALUES ('ONA','Winona',85);
INSERT INTO city VALUES ('ONM','Socorro',102);
INSERT INTO city VALUES ('ONO','Ontario',112);
INSERT INTO city VALUES ('ONP','Newport',112);
INSERT INTO city VALUES ('ONT','Ontario',20);
INSERT INTO city VALUES ('OQU','Kingston',125);
INSERT INTO city VALUES ('OR03','Salahaddin',60);
INSERT INTO city VALUES ('OR04','Chamchamal',60);
INSERT INTO city VALUES ('OR10','Rutbah',60);
INSERT INTO city VALUES ('ORD','Chicago',55);
INSERT INTO city VALUES ('ORF','Norfolk',157);
INSERT INTO city VALUES ('ORH','Worcester',76);
INSERT INTO city VALUES ('ORT','Northway',1);
INSERT INTO city VALUES ('OSA','Osaka',66);
INSERT INTO city VALUES ('OSC','Oscoda',84);
INSERT INTO city VALUES ('OSH','Oshkosh',164);
INSERT INTO city VALUES ('OSL','Oslo',105);
INSERT INTO city VALUES ('OTG','Worthington',85);
INSERT INTO city VALUES ('OTH','North Bend',112);
INSERT INTO city VALUES ('OTM','Ottumwa',52);
INSERT INTO city VALUES ('OTZ','Kotzebue',1);
INSERT INTO city VALUES ('OUN','Norman',110);
INSERT INTO city VALUES ('OVN','Omaha (North)',92);
INSERT INTO city VALUES ('OXR','Oxnard',20);
INSERT INTO city VALUES ('OYM','St. Mary\'s',113);
INSERT INTO city VALUES ('OZR','Ozark',2);
INSERT INTO city VALUES ('P04','Bisbee',10);
INSERT INTO city VALUES ('P08','Coolidge',10);
INSERT INTO city VALUES ('P13','Globe',10);
INSERT INTO city VALUES ('P20','Parker',10);
INSERT INTO city VALUES ('P32','Williams',10);
INSERT INTO city VALUES ('P34','Window Rock',10);
INSERT INTO city VALUES ('P52','Cottonwood',10);
INSERT INTO city VALUES ('PAE','Everett',162);
INSERT INTO city VALUES ('PAH','Paducah',71);
INSERT INTO city VALUES ('PAM','Panama City',39);
INSERT INTO city VALUES ('PAO','Palo Alto',20);
INSERT INTO city VALUES ('PAP','Port au Prince',48);
INSERT INTO city VALUES ('PAQ','Palmer',1);
INSERT INTO city VALUES ('PBF','Pine Bluff',6);
INSERT INTO city VALUES ('PBG','Plattsburgh',108);
INSERT INTO city VALUES ('PBI','W Palm Beach',39);
INSERT INTO city VALUES ('PBM','Paramaribo',140);
INSERT INTO city VALUES ('PBY','Peabody',76);
INSERT INTO city VALUES ('PDT','Pendleton',112);
INSERT INTO city VALUES ('PDX','Portland',112);
INSERT INTO city VALUES ('PEK','Beijing',22);
INSERT INTO city VALUES ('PER','Perth',163);
INSERT INTO city VALUES ('PGA','Page',10);
INSERT INTO city VALUES ('PGD','Punta Gorda',39);
INSERT INTO city VALUES ('PHL','Philadelphia',113);
INSERT INTO city VALUES ('PHN','Port Huron',84);
INSERT INTO city VALUES ('PHP','Philip',130);
INSERT INTO city VALUES ('PHR','Phantom Ranch',10);
INSERT INTO city VALUES ('PHX','Phoenix',10);
INSERT INTO city VALUES ('PIA','Peoria',55);
INSERT INTO city VALUES ('PIE','St. Petersburg',39);
INSERT INTO city VALUES ('PIH','Pocatello',54);
INSERT INTO city VALUES ('PIR','Pierre',130);
INSERT INTO city VALUES ('PIT','Pittsburgh',113);
INSERT INTO city VALUES ('PKB','Parkersburg',165);
INSERT INTO city VALUES ('PKF','Park Falls',164);
INSERT INTO city VALUES ('PLN','Pellston',84);
INSERT INTO city VALUES ('PLP','Phillipsburg',101);
INSERT INTO city VALUES ('PMD','Palmdale',20);
INSERT INTO city VALUES ('PMH','Portsmouth',109);
INSERT INTO city VALUES ('PMI','Palma De Mallorca',137);
INSERT INTO city VALUES ('PMO','Palermo',63);
INSERT INTO city VALUES ('PMP','Pompano Beach',39);
INSERT INTO city VALUES ('PNC','Ponca City',110);
INSERT INTO city VALUES ('PNS','Pensacola',39);
INSERT INTO city VALUES ('POE','Fort Polk AAF',72);
INSERT INTO city VALUES ('POM','Pomona',20);
INSERT INTO city VALUES ('POS','Port Of Spain',148);
INSERT INTO city VALUES ('POU','Poughkeepsie',108);
INSERT INTO city VALUES ('PPF','Parsons',69);
INSERT INTO city VALUES ('PQI','Presque Isle',82);
INSERT INTO city VALUES ('PRB','Paso Robles',20);
INSERT INTO city VALUES ('PRC','Prescott',10);
INSERT INTO city VALUES ('PRG','Prague',29);
INSERT INTO city VALUES ('PSB','Philipsburg',113);
INSERT INTO city VALUES ('PSC','Pasco',162);
INSERT INTO city VALUES ('PSF','Pittsfield',76);
INSERT INTO city VALUES ('PSM','Portsmouth',98);
INSERT INTO city VALUES ('PSP','Palm Springs',20);
INSERT INTO city VALUES ('PSX','Palacios',151);
INSERT INTO city VALUES ('PTK','Pontiac',84);
INSERT INTO city VALUES ('PTS','Pittsburg',69);
INSERT INTO city VALUES ('PTY','Panama',115);
INSERT INTO city VALUES ('PUB','Pueblo',23);
INSERT INTO city VALUES ('PUC','Price',156);
INSERT INTO city VALUES ('PUT','Park City',156);
INSERT INTO city VALUES ('PUW','Pullman',162);
INSERT INTO city VALUES ('PVD','Providence',125);
INSERT INTO city VALUES ('PVR','Puerto Vallar',83);
INSERT INTO city VALUES ('PVU','Provo',156);
INSERT INTO city VALUES ('PWA','Wily Post',110);
INSERT INTO city VALUES ('PWM','Portland',82);
INSERT INTO city VALUES ('PWT','Bremerton',162);
INSERT INTO city VALUES ('PYM','Plymouth',76);
INSERT INTO city VALUES ('Q35','Springerville',10);
INSERT INTO city VALUES ('QUE','Queens',108);
INSERT INTO city VALUES ('RAP','Rapid City',130);
INSERT INTO city VALUES ('RBG','Roseburg',112);
INSERT INTO city VALUES ('RBL','Red Bluff',20);
INSERT INTO city VALUES ('RDD','Redding',20);
INSERT INTO city VALUES ('RDG','Reading',113);
INSERT INTO city VALUES ('RDM','Redmond',112);
INSERT INTO city VALUES ('RDU','Raleigh',90);
INSERT INTO city VALUES ('REE','Reese/Lubbock',151);
INSERT INTO city VALUES ('REH','Rehoboth Beach',31);
INSERT INTO city VALUES ('REK','Reykjavik',53);
INSERT INTO city VALUES ('RFD','Rockford',55);
INSERT INTO city VALUES ('RHI','Rhinelander',164);
INSERT INTO city VALUES ('RIC','Richmond',157);
INSERT INTO city VALUES ('RID','Richmond',56);
INSERT INTO city VALUES ('RIE','Rice Lake',164);
INSERT INTO city VALUES ('RIG','Riggins',54);
INSERT INTO city VALUES ('RIV','Riverside',20);
INSERT INTO city VALUES ('RIW','Riverton',166);
INSERT INTO city VALUES ('RIX','Riga',73);
INSERT INTO city VALUES ('RKS','Rock Springs',166);
INSERT INTO city VALUES ('RME','Rome',108);
INSERT INTO city VALUES ('RMG','Rome',41);
INSERT INTO city VALUES ('RND','Randolph AFB',151);
INSERT INTO city VALUES ('RNO','Reno',107);
INSERT INTO city VALUES ('ROA','Roanoke',157);
INSERT INTO city VALUES ('ROC','Rochester',108);
INSERT INTO city VALUES ('ROW','Roswell',102);
INSERT INTO city VALUES ('RSL','Russell',69);
INSERT INTO city VALUES ('RST','Rochester',85);
INSERT INTO city VALUES ('RTN','Raton',102);
INSERT INTO city VALUES ('RUI','Ruidoso',102);
INSERT INTO city VALUES ('RUT','Rutland',161);
INSERT INTO city VALUES ('RWF','Redwood Falls',85);
INSERT INTO city VALUES ('RWI','Rocky Mount',90);
INSERT INTO city VALUES ('RWL','Rawlins',166);
INSERT INTO city VALUES ('S07','Bend',112);
INSERT INTO city VALUES ('S18','Forks',162);
INSERT INTO city VALUES ('S19','Friday Harbor',162);
INSERT INTO city VALUES ('S80','Grangeville',54);
INSERT INTO city VALUES ('SAA','Saratoga',166);
INSERT INTO city VALUES ('SAC','Sacramento',20);
INSERT INTO city VALUES ('SAF','Santa Fe',102);
INSERT INTO city VALUES ('SAL','San Salvador',36);
INSERT INTO city VALUES ('SAN','San Diego',20);
INSERT INTO city VALUES ('SAO','Sao paulo',18);
INSERT INTO city VALUES ('SAT','San Antonio',151);
INSERT INTO city VALUES ('SAV','Savannah',41);
INSERT INTO city VALUES ('SAW','Sawyer AFB',84);
INSERT INTO city VALUES ('SBA','Santa Barbara',20);
INSERT INTO city VALUES ('SBD','San Bernardino',20);
INSERT INTO city VALUES ('SBN','South Bend',56);
INSERT INTO city VALUES ('SBP','San Luis Obispo',20);
INSERT INTO city VALUES ('SBS','Steamboat Springs',23);
INSERT INTO city VALUES ('SBV','Barre-Montpelier',161);
INSERT INTO city VALUES ('SBY','Salisbury',81);
INSERT INTO city VALUES ('SCA','Tahoe Valley',20);
INSERT INTO city VALUES ('SCC','Prudhoe Bay',1);
INSERT INTO city VALUES ('SCK','Stockton',20);
INSERT INTO city VALUES ('SCL','Santiago',21);
INSERT INTO city VALUES ('SCO','Steamboat Springs',23);
INSERT INTO city VALUES ('SD01','Alexandria',130);
INSERT INTO city VALUES ('SDF','Louisville',71);
INSERT INTO city VALUES ('SDL','Scottsdale',10);
INSERT INTO city VALUES ('SDM','Brownfield',20);
INSERT INTO city VALUES ('SDQ','Santo Domingo',33);
INSERT INTO city VALUES ('SDY','Sidney',89);
INSERT INTO city VALUES ('SEA','Seattle',162);
INSERT INTO city VALUES ('SEM','Selma',2);
INSERT INTO city VALUES ('SEP','Stephenville',151);
INSERT INTO city VALUES ('SEZ','Sedona',10);
INSERT INTO city VALUES ('SFO','San Francisco',20);
INSERT INTO city VALUES ('SFS','South San Francisco',20);
INSERT INTO city VALUES ('SFZ','Pawtucket',125);
INSERT INTO city VALUES ('SGF','Springfield',86);
INSERT INTO city VALUES ('SGH','Springfield',109);
INSERT INTO city VALUES ('SGJ','St. Augustine',39);
INSERT INTO city VALUES ('SGU','St. George',156);
INSERT INTO city VALUES ('SGY','Skagway',1);
INSERT INTO city VALUES ('SHA','Shanghai',22);
INSERT INTO city VALUES ('SHD','Staunton',157);
INSERT INTO city VALUES ('SHR','Sheridan',166);
INSERT INTO city VALUES ('SHV','Shreveport',72);
INSERT INTO city VALUES ('SII','Alturas',20);
INSERT INTO city VALUES ('SIL','Slidell',72);
INSERT INTO city VALUES ('SIN','Singapore',133);
INSERT INTO city VALUES ('SIT','Sitka',1);
INSERT INTO city VALUES ('SJC','San Jose',20);
INSERT INTO city VALUES ('SJT','San Angelo',151);
INSERT INTO city VALUES ('SJU','San Juan',122);
INSERT INTO city VALUES ('SKA','Fairchild',162);
INSERT INTO city VALUES ('SKF','Kelly AFB',151);
INSERT INTO city VALUES ('SKX','Taos',102);
INSERT INTO city VALUES ('SLC','Salt Lake City',156);
INSERT INTO city VALUES ('SLE','Salem',112);
INSERT INTO city VALUES ('SLI','Seal Beach',20);
INSERT INTO city VALUES ('SLK','Saranac Lake',108);
INSERT INTO city VALUES ('SLN','Salina',69);
INSERT INTO city VALUES ('SLP','San Luis Potosi',83);
INSERT INTO city VALUES ('SLU','Castries',139);
INSERT INTO city VALUES ('SMC','Aspen(base)',23);
INSERT INTO city VALUES ('SMF','Smithfield',125);
INSERT INTO city VALUES ('SMN','Salmon',54);
INSERT INTO city VALUES ('SMO','Santa Monica',20);
INSERT INTO city VALUES ('SMP','Stampede Pass',162);
INSERT INTO city VALUES ('SMX','Santa Maria',20);
INSERT INTO city VALUES ('SNA','Santa Ana',20);
INSERT INTO city VALUES ('SNP','St. Paul Island',1);
INSERT INTO city VALUES ('SNS','Salinas',20);
INSERT INTO city VALUES ('SNY','Sidney',92);
INSERT INTO city VALUES ('SOP','Southern Pines',90);
INSERT INTO city VALUES ('SOW','Show Low',10);
INSERT INTO city VALUES ('SPI','Springfield',55);
INSERT INTO city VALUES ('SPS','Wichita Falls',151);
INSERT INTO city VALUES ('SRI','Lewiston',82);
INSERT INTO city VALUES ('SRQ','Sarasota',39);
INSERT INTO city VALUES ('SRU','Santa Cruz',20);
INSERT INTO city VALUES ('SSC','Sumter',129);
INSERT INTO city VALUES ('SSI','Brunswick',41);
INSERT INTO city VALUES ('SSM','Sault Ste. Marie',84);
INSERT INTO city VALUES ('STC','St. Cloud',85);
INSERT INTO city VALUES ('STJ','St. Joseph',86);
INSERT INTO city VALUES ('STL','St. Louis',86);
INSERT INTO city VALUES ('STP','St. Paul',85);
INSERT INTO city VALUES ('STR','Stuttgart',43);
INSERT INTO city VALUES ('STS','Santa Rosa',20);
INSERT INTO city VALUES ('STT','St. Thomas',160);
INSERT INTO city VALUES ('STX','Stamford',25);
INSERT INTO city VALUES ('SUN','Sun Valley',54);
INSERT INTO city VALUES ('SUU','Travis AFB',20);
INSERT INTO city VALUES ('SUX','Sioux City',52);
INSERT INTO city VALUES ('SVC','Silver City',102);
INSERT INTO city VALUES ('SVE','Susanville',20);
INSERT INTO city VALUES ('SVI','Sun Valley',54);
INSERT INTO city VALUES ('SVN','Hailey',54);
INSERT INTO city VALUES ('SVT','Stowe Mountain',161);
INSERT INTO city VALUES ('SWD','Seward',1);
INSERT INTO city VALUES ('SWF','Stewart Field',108);
INSERT INTO city VALUES ('SWO','Stillwater',110);
INSERT INTO city VALUES ('SXT','Sexton Summit',112);
INSERT INTO city VALUES ('SYD','Sydney',95);
INSERT INTO city VALUES ('SYR','Syracuse',108);
INSERT INTO city VALUES ('SZL','Knob Noster',86);
INSERT INTO city VALUES ('TAD','Trinidad',23);
INSERT INTO city VALUES ('TAL','Tanana',1);
INSERT INTO city VALUES ('TBN','Fort Leonard',86);
INSERT INTO city VALUES ('TBW','Ruskin',39);
INSERT INTO city VALUES ('TCC','Tucumcari',102);
INSERT INTO city VALUES ('TCL','Tuscaloosa',2);
INSERT INTO city VALUES ('TCM','Tacoma',162);
INSERT INTO city VALUES ('TCO','Telluride',23);
INSERT INTO city VALUES ('TCS','Truth or Consequence',102);
INSERT INTO city VALUES ('TEB','Teterboro',101);
INSERT INTO city VALUES ('TGE','Tuskegee',2);
INSERT INTO city VALUES ('TGU','Tegucigalpa',50);
INSERT INTO city VALUES ('TGZ','Tuxtla Guterrez',83);
INSERT INTO city VALUES ('THP','Thermopolis',166);
INSERT INTO city VALUES ('THR','Tehran',59);
INSERT INTO city VALUES ('TIJ','Tijuana',83);
INSERT INTO city VALUES ('TIM','Tombouctou/Timbuktu',78);
INSERT INTO city VALUES ('TIP','Tripoli',75);
INSERT INTO city VALUES ('TKA','Talkeetna',1);
INSERT INTO city VALUES ('TKJ','Tok',1);
INSERT INTO city VALUES ('TLH','Tallahassee',39);
INSERT INTO city VALUES ('TLO','Government Camp',112);
INSERT INTO city VALUES ('TLV','Tel Aviv',62);
INSERT INTO city VALUES ('TN14','Dover',147);
INSERT INTO city VALUES ('TN16','Elizabethton',147);
INSERT INTO city VALUES ('TN65','Tazewell',147);
INSERT INTO city VALUES ('TN69','Waverly',147);
INSERT INTO city VALUES ('TN77','Germantown',147);
INSERT INTO city VALUES ('TNK','Teaneck',101);
INSERT INTO city VALUES ('TNP','Twentynine Palms',20);
INSERT INTO city VALUES ('TOA','Torrance',20);
INSERT INTO city VALUES ('TOL','Toledo',109);
INSERT INTO city VALUES ('TOP','Topeka',69);
INSERT INTO city VALUES ('TOR','Torrington',166);
INSERT INTO city VALUES ('TPA','Tampa',39);
INSERT INTO city VALUES ('TPE','Taipei',144);
INSERT INTO city VALUES ('TPH','Tonopah',107);
INSERT INTO city VALUES ('TPL','Temple',151);
INSERT INTO city VALUES ('TRI','Bristol',147);
INSERT INTO city VALUES ('TRK','Truckee',20);
INSERT INTO city VALUES ('TRM','Thermal',20);
INSERT INTO city VALUES ('TRU','Trujillo',117);
INSERT INTO city VALUES ('TTD','Troutdale',112);
INSERT INTO city VALUES ('TTN','Trenton',101);
INSERT INTO city VALUES ('TTQ','Murphy',90);
INSERT INTO city VALUES ('TTS','Titusville',39);
INSERT INTO city VALUES ('TUL','Tulsa',110);
INSERT INTO city VALUES ('TUN','Tunis',149);
INSERT INTO city VALUES ('TUP','Tupelo',88);
INSERT INTO city VALUES ('TUS','Tucson',10);
INSERT INTO city VALUES ('TVC','Traverse City',84);
INSERT INTO city VALUES ('TVL','Tahoe Valley',20);
INSERT INTO city VALUES ('TWF','Twin Falls',54);
INSERT INTO city VALUES ('TX04','Andrews',151);
INSERT INTO city VALUES ('TX05','Anson',151);
INSERT INTO city VALUES ('TX06','Archer City',151);
INSERT INTO city VALUES ('TX07','Aspermont',151);
INSERT INTO city VALUES ('TX09','Atlanta',151);
INSERT INTO city VALUES ('TX10','Ballinger',151);
INSERT INTO city VALUES ('TX11','Bandera',151);
INSERT INTO city VALUES ('TX50','Cooper',151);
INSERT INTO city VALUES ('TX56','Cuero',151);
INSERT INTO city VALUES ('TX80','Gonzales',151);
INSERT INTO city VALUES ('TX81','Graham',151);
INSERT INTO city VALUES ('TXK','Texarkana',6);
INSERT INTO city VALUES ('TYR','Tyler',151);
INSERT INTO city VALUES ('TYS','Knoxville',147);
INSERT INTO city VALUES ('UCA','Utica',108);
INSERT INTO city VALUES ('UGN','Waukegan',55);
INSERT INTO city VALUES ('UIL','Quillayute',162);
INSERT INTO city VALUES ('UIN','Quincy',55);
INSERT INTO city VALUES ('UIO','Quito',34);
INSERT INTO city VALUES ('UKI','Ukiah',20);
INSERT INTO city VALUES ('UNV','State College',113);
INSERT INTO city VALUES ('UOX','Oxford',88);
INSERT INTO city VALUES ('UPC','Upper Montclair',101);
INSERT INTO city VALUES ('VBG','Lompoc/Vandenberg AFB',20);
INSERT INTO city VALUES ('VCE','Venice',63);
INSERT INTO city VALUES ('VCT','Victoria',151);
INSERT INTO city VALUES ('VCV','Victorville',20);
INSERT INTO city VALUES ('VDZ','Valdez',1);
INSERT INTO city VALUES ('VER','Veracruz',83);
INSERT INTO city VALUES ('VES','Waukesha',164);
INSERT INTO city VALUES ('VIE','Vienna',9);
INSERT INTO city VALUES ('VIH','Vichy',86);
INSERT INTO city VALUES ('VIS','Visalia',20);
INSERT INTO city VALUES ('VLD','Valdosta',41);
INSERT INTO city VALUES ('VNC','Venice',39);
INSERT INTO city VALUES ('VNY','Van Nuys',20);
INSERT INTO city VALUES ('VOK','Volk Field',164);
INSERT INTO city VALUES ('VPS','Valparaiso',39);
INSERT INTO city VALUES ('VPZ','Valparaiso',56);
INSERT INTO city VALUES ('VRB','Vero beach',39);
INSERT INTO city VALUES ('VSA','Villa Hermosa',83);
INSERT INTO city VALUES ('VT05','Newport',161);
INSERT INTO city VALUES ('VTN','Valentine',92);
INSERT INTO city VALUES ('VTU','Ventura',20);
INSERT INTO city VALUES ('VVV','Ha Noi',159);
INSERT INTO city VALUES ('W03','Wilson',90);
INSERT INTO city VALUES ('WA03','Lakewood',162);
INSERT INTO city VALUES ('WA05','Burien',162);
INSERT INTO city VALUES ('WA07','Mercer Island',162);
INSERT INTO city VALUES ('WA09','Opportunity',162);
INSERT INTO city VALUES ('WA10','Parkland',162);
INSERT INTO city VALUES ('WA12','Richmond Highlands',162);
INSERT INTO city VALUES ('WA13','SeaTac',162);
INSERT INTO city VALUES ('WAB','Trowbridge',111);
INSERT INTO city VALUES ('WAC','Nitinat Lake',19);
INSERT INTO city VALUES ('WAE','Whistler/Alta Lake',19);
INSERT INTO city VALUES ('WAH','Amherst',106);
INSERT INTO city VALUES ('WAJ','Rondeau Harbor',111);
INSERT INTO city VALUES ('WAL','Wallops Island',157);
INSERT INTO city VALUES ('WAN','Amphititrite Point',19);
INSERT INTO city VALUES ('WAR','Warwick',125);
INSERT INTO city VALUES ('WAW','Warsaw',119);
INSERT INTO city VALUES ('WBA','Banff',3);
INSERT INTO city VALUES ('WBE','Killarney',111);
INSERT INTO city VALUES ('WCA','Cartwright',97);
INSERT INTO city VALUES ('WCH','Atikokan',111);
INSERT INTO city VALUES ('WDH','Daniels Harbor',97);
INSERT INTO city VALUES ('WDI','Badger',97);
INSERT INTO city VALUES ('WDO','Twillingate',97);
INSERT INTO city VALUES ('WDQ','La Tuque',123);
INSERT INTO city VALUES ('WEH','Eastend Cypress',127);
INSERT INTO city VALUES ('WEP','East Point',121);
INSERT INTO city VALUES ('WHO','Hopedale',97);
INSERT INTO city VALUES ('WHP','Heath Point',123);
INSERT INTO city VALUES ('WI01','Alma',164);
INSERT INTO city VALUES ('WI05','Beaver Dam',164);
INSERT INTO city VALUES ('WI06','Berlin',164);
INSERT INTO city VALUES ('WI08','Chilton',164);
INSERT INTO city VALUES ('WI15','Elkhorn',164);
INSERT INTO city VALUES ('WI22','Kewaunee',164);
INSERT INTO city VALUES ('WI28','Medford',164);
INSERT INTO city VALUES ('WIK','Broadview',127);
INSERT INTO city VALUES ('WJA','Jasper',3);
INSERT INTO city VALUES ('WJF','Lancaster',20);
INSERT INTO city VALUES ('WKM','Komakuk Beach',167);
INSERT INTO city VALUES ('WLB','Lac la Biche',3);
INSERT INTO city VALUES ('WLG','Wellington',96);
INSERT INTO city VALUES ('WMC','Winnemucca',107);
INSERT INTO city VALUES ('WMD','Mould Bay',79);
INSERT INTO city VALUES ('WME','Cathedral Point',19);
INSERT INTO city VALUES ('WMH','Mary\'s Harbour',97);
INSERT INTO city VALUES ('WMN','Mount Forest',111);
INSERT INTO city VALUES ('WNC','Coburg',111);
INSERT INTO city VALUES ('WNN','Winnfield',72);
INSERT INTO city VALUES ('WNZ','Nagagami',111);
INSERT INTO city VALUES ('WOB','Brevoort Island',104);
INSERT INTO city VALUES ('WOE','Onefour',3);
INSERT INTO city VALUES ('WOO','Woonsocket',125);
INSERT INTO city VALUES ('WPC','Port Colborne',111);
INSERT INTO city VALUES ('WPK','Parent',123);
INSERT INTO city VALUES ('WPO','Pilot Mound',79);
INSERT INTO city VALUES ('WPS','Long Point',111);
INSERT INTO city VALUES ('WPU','Puntzi Mountain',19);
INSERT INTO city VALUES ('WRA','Cape Race',97);
INSERT INTO city VALUES ('WRG','Wrangell',1);
INSERT INTO city VALUES ('WRI','Wrightstown',101);
INSERT INTO city VALUES ('WRL','Worland',166);
INSERT INTO city VALUES ('WRO','Rosa Spit',19);
INSERT INTO city VALUES ('WRY','Milk River',3);
INSERT INTO city VALUES ('WSA','Sable Island',106);
INSERT INTO city VALUES ('WSS','St. Stephen',94);
INSERT INTO city VALUES ('WWD','Wildwood',101);
INSERT INTO city VALUES ('X06','Arcadia',39);
INSERT INTO city VALUES ('X36','Englewood',39);
INSERT INTO city VALUES ('XLE','Fort Benning',41);
INSERT INTO city VALUES ('YAK','Yakutat',1);
INSERT INTO city VALUES ('YAM','Sault Ste. Marie',111);
INSERT INTO city VALUES ('YBC','Baie Comeau',123);
INSERT INTO city VALUES ('YBG','Bagotville',123);
INSERT INTO city VALUES ('YBK','Baker Lake',104);
INSERT INTO city VALUES ('YBL','Campbell River',19);
INSERT INTO city VALUES ('YBR','Brandon',79);
INSERT INTO city VALUES ('YBU','Nipawin',127);
INSERT INTO city VALUES ('YBW','Springbank',3);
INSERT INTO city VALUES ('YCB','Cambridge Bay Arpt',104);
INSERT INTO city VALUES ('YCD','Nanaimo',19);
INSERT INTO city VALUES ('YCG','Castlegar',19);
INSERT INTO city VALUES ('YCH','Chatham',94);
INSERT INTO city VALUES ('YCL','Charlo',94);
INSERT INTO city VALUES ('YCO','Coppermine Airport',104);
INSERT INTO city VALUES ('YCP','Blue River',19);
INSERT INTO city VALUES ('YCT','Coronation',3);
INSERT INTO city VALUES ('YCU','Chibougamau',123);
INSERT INTO city VALUES ('YCY','Clyder River',106);
INSERT INTO city VALUES ('YDA','Dawson City',167);
INSERT INTO city VALUES ('YDB','Burwash',167);
INSERT INTO city VALUES ('YDF','Deer Lake',97);
INSERT INTO city VALUES ('YDN','Dauphin',79);
INSERT INTO city VALUES ('YDP','Nain Airport',97);
INSERT INTO city VALUES ('YDQ','Dawson Creek',19);
INSERT INTO city VALUES ('YEG','Edmonton',3);
INSERT INTO city VALUES ('YEN','Estevan',127);
INSERT INTO city VALUES ('YET','Edson',3);
INSERT INTO city VALUES ('YEV','Inuvik',104);
INSERT INTO city VALUES ('YFB','Frobisher',104);
INSERT INTO city VALUES ('YFC','Fredericton',94);
INSERT INTO city VALUES ('YFD','Brantford',111);
INSERT INTO city VALUES ('YFO','Flin Flon',79);
INSERT INTO city VALUES ('YFS','Fort Simpson Arpt',104);
INSERT INTO city VALUES ('YGD','Goderich',111);
INSERT INTO city VALUES ('YGK','Kingston',3);
INSERT INTO city VALUES ('YGL','La Grande Riviere',111);
INSERT INTO city VALUES ('YGM','Gimli',79);
INSERT INTO city VALUES ('YGP','Gaspe',123);
INSERT INTO city VALUES ('YGQ','Geraldton',111);
INSERT INTO city VALUES ('YGR','Iles-de-la-Madeleine',123);
INSERT INTO city VALUES ('YGV','Havre St.Pierre',123);
INSERT INTO city VALUES ('YGX','Gillam',79);
INSERT INTO city VALUES ('YHB','Hudson Bay',127);
INSERT INTO city VALUES ('YHD','Dryden',111);
INSERT INTO city VALUES ('YHE','Hope Airport',19);
INSERT INTO city VALUES ('YHM','Hamilton',111);
INSERT INTO city VALUES ('YHY','Hay River',104);
INSERT INTO city VALUES ('YHZ','Halifax',106);
INSERT INTO city VALUES ('YIV','Island Lake',79);
INSERT INTO city VALUES ('YJT','Stephenville Arpt',97);
INSERT INTO city VALUES ('YKA','Kamloops',19);
INSERT INTO city VALUES ('YKF','Kitchener',111);
INSERT INTO city VALUES ('YKJ','Key Lake',127);
INSERT INTO city VALUES ('YKL','Schefferville Lake',123);
INSERT INTO city VALUES ('YKM','Yakima',162);
INSERT INTO city VALUES ('YKN','Yankton',130);
INSERT INTO city VALUES ('YKY','Kindersley',127);
INSERT INTO city VALUES ('YLI','Lindsay',111);
INSERT INTO city VALUES ('YLJ','Meadow Lake',127);
INSERT INTO city VALUES ('YLL','Lloyd Minster',127);
INSERT INTO city VALUES ('YLT','Alert',104);
INSERT INTO city VALUES ('YLW','Kelowna',19);
INSERT INTO city VALUES ('YMA','Mayo',167);
INSERT INTO city VALUES ('YMD','Edmundston',94);
INSERT INTO city VALUES ('YMJ','Moose Jaw',127);
INSERT INTO city VALUES ('YMM','Fort Mcmurray',3);
INSERT INTO city VALUES ('YMN','Manning',3);
INSERT INTO city VALUES ('YMO','Moosonee',111);
INSERT INTO city VALUES ('YMT','Chibougamou',123);
INSERT INTO city VALUES ('YNA','Natashquan Airport',123);
INSERT INTO city VALUES ('YNE','Norway House Arpt',79);
INSERT INTO city VALUES ('YNG','Youngstown',109);
INSERT INTO city VALUES ('YNM','Matagami',123);
INSERT INTO city VALUES ('YOD','Cold Lake',3);
INSERT INTO city VALUES ('YOJ','High Level',3);
INSERT INTO city VALUES ('YOW','Ottawa',111);
INSERT INTO city VALUES ('YPA','Prince Albert Arpt',127);
INSERT INTO city VALUES ('YPE','Peace River',3);
INSERT INTO city VALUES ('YPG','Portage',79);
INSERT INTO city VALUES ('YPL','Pickle Lake',111);
INSERT INTO city VALUES ('YPQ','Peterborough',111);
INSERT INTO city VALUES ('YPR','Prince Rupert',19);
INSERT INTO city VALUES ('YPY','Fort Chipeyan',3);
INSERT INTO city VALUES ('YQA','Muskoka',111);
INSERT INTO city VALUES ('YQB','Quebec',123);
INSERT INTO city VALUES ('YQD','The Pas',79);
INSERT INTO city VALUES ('YQF','Red Deer',3);
INSERT INTO city VALUES ('YQG','Windsor',111);
INSERT INTO city VALUES ('YQH','Watson Lake',167);
INSERT INTO city VALUES ('YQI','Yarmouth',106);
INSERT INTO city VALUES ('YQK','Kenora',111);
INSERT INTO city VALUES ('YQL','Lethbridge',3);
INSERT INTO city VALUES ('YQM','Moncton',94);
INSERT INTO city VALUES ('YQQ','Comox',19);
INSERT INTO city VALUES ('YQR','Regina',127);
INSERT INTO city VALUES ('YQT','Thunder Bay',111);
INSERT INTO city VALUES ('YQU','Grande Prairie',3);
INSERT INTO city VALUES ('YQV','Yorkton',127);
INSERT INTO city VALUES ('YQW','North Battleford',127);
INSERT INTO city VALUES ('YQX','Gander',97);
INSERT INTO city VALUES ('YQY','Sydney',106);
INSERT INTO city VALUES ('YQZ','Quesnel Airport',19);
INSERT INTO city VALUES ('YRB','Mag North Pole',104);
INSERT INTO city VALUES ('YRJ','Roberval Airport',123);
INSERT INTO city VALUES ('YRL','Red Lake',111);
INSERT INTO city VALUES ('YRM','Rocky Mt House',3);
INSERT INTO city VALUES ('YRQ','Trois-Rivieres',123);
INSERT INTO city VALUES ('YRT','Rankin Inlet',104);
INSERT INTO city VALUES ('YRV','Revelstoke Airport',19);
INSERT INTO city VALUES ('YSB','Sudbury',111);
INSERT INTO city VALUES ('YSC','Sherbrooke',123);
INSERT INTO city VALUES ('YSD','Suffield',3);
INSERT INTO city VALUES ('YSF','Stony Plain',127);
INSERT INTO city VALUES ('YSJ','St. John',94);
INSERT INTO city VALUES ('YSM','Fort Smith Airport',104);
INSERT INTO city VALUES ('YSN','St. Catherines',111);
INSERT INTO city VALUES ('YSY','Sachs Harbour',104);
INSERT INTO city VALUES ('YTH','Thompson',79);
INSERT INTO city VALUES ('YTJ','Terrace Bay',111);
INSERT INTO city VALUES ('YTL','Big Trout Lake',111);
INSERT INTO city VALUES ('YTR','Trenton',111);
INSERT INTO city VALUES ('YTS','Timmins',111);
INSERT INTO city VALUES ('YTZ','Toronto Island',111);
INSERT INTO city VALUES ('YUB','Tuktoyaktuk',104);
INSERT INTO city VALUES ('YUJ','Lady Franklin Point',104);
INSERT INTO city VALUES ('YUL','Montreal',123);
INSERT INTO city VALUES ('YUM','Yuma',10);
INSERT INTO city VALUES ('YUS','Shepherd Bay',104);
INSERT INTO city VALUES ('YUT','Repulse Bay',104);
INSERT INTO city VALUES ('YUX','Hall Beach',104);
INSERT INTO city VALUES ('YVC','La Ronge',127);
INSERT INTO city VALUES ('YVG','Vermilion',3);
INSERT INTO city VALUES ('YVO','Val d\' Or',123);
INSERT INTO city VALUES ('YVP','Kuujjuaq',123);
INSERT INTO city VALUES ('YVQ','Norman Wells Arpt',104);
INSERT INTO city VALUES ('YVR','Vancouver',19);
INSERT INTO city VALUES ('YVT','Buffalo Narrows',127);
INSERT INTO city VALUES ('YVV','Owen Sound',111);
INSERT INTO city VALUES ('YWG','Winnipeg',79);
INSERT INTO city VALUES ('YWK','Wabash Lake',97);
INSERT INTO city VALUES ('YWL','Williams Lake',19);
INSERT INTO city VALUES ('YWM','Athabasca',3);
INSERT INTO city VALUES ('YWV','Wainwright',3);
INSERT INTO city VALUES ('YXC','Cranbrook',19);
INSERT INTO city VALUES ('YXD','Edmonton',3);
INSERT INTO city VALUES ('YXE','Saskatoon',127);
INSERT INTO city VALUES ('YXH','Medicine Hat',3);
INSERT INTO city VALUES ('YXJ','Fort St. John',19);
INSERT INTO city VALUES ('YXK','Rimouski',123);
INSERT INTO city VALUES ('YXL','Sioux Lookout Arpt',111);
INSERT INTO city VALUES ('YXQ','Beaver Creek',167);
INSERT INTO city VALUES ('YXR','Earlton',111);
INSERT INTO city VALUES ('YXS','Prince George',19);
INSERT INTO city VALUES ('YXT','Terrace',19);
INSERT INTO city VALUES ('YXU','London',111);
INSERT INTO city VALUES ('YXX','Abbotsford',19);
INSERT INTO city VALUES ('YXY','Whitehorse',167);
INSERT INTO city VALUES ('YYB','North Bay',111);
INSERT INTO city VALUES ('YYC','Calgary',3);
INSERT INTO city VALUES ('YYD','Smithers',19);
INSERT INTO city VALUES ('YYE','Fort Nelson Airport',19);
INSERT INTO city VALUES ('YYF','Penticton',19);
INSERT INTO city VALUES ('YYG','Charlottetown',121);
INSERT INTO city VALUES ('YYJ','Victoria',19);
INSERT INTO city VALUES ('YYL','Lynn Lake Airport',79);
INSERT INTO city VALUES ('YYN','Swift Current',127);
INSERT INTO city VALUES ('YYQ','Churchill',79);
INSERT INTO city VALUES ('YYR','Goose Bay',97);
INSERT INTO city VALUES ('YYT','St. Johns',97);
INSERT INTO city VALUES ('YYU','Kapuskasing',111);
INSERT INTO city VALUES ('YYY','Mount Joli',123);
INSERT INTO city VALUES ('YYZ','Toronto',111);
INSERT INTO city VALUES ('YZE','Gore Bay Airport',111);
INSERT INTO city VALUES ('YZF','Yellowknife',104);
INSERT INTO city VALUES ('YZH','Slave Lake',3);
INSERT INTO city VALUES ('YZP','Sandspit',19);
INSERT INTO city VALUES ('YZR','Sarnia',111);
INSERT INTO city VALUES ('YZS','Coral Harbour Arpt',104);
INSERT INTO city VALUES ('YZT','Port Hardy',19);
INSERT INTO city VALUES ('YZU','Whitecourt',3);
INSERT INTO city VALUES ('YZV','Sept Isles',123);
INSERT INTO city VALUES ('YZW','Teslin',167);
INSERT INTO city VALUES ('YZX','Greenwood',106);
INSERT INTO city VALUES ('YZY','Mackenzie Airport',19);
INSERT INTO city VALUES ('ZDI','Churchill Falls',97);
INSERT INTO city VALUES ('ZFA','Faro',167);
INSERT INTO city VALUES ('ZHP','High Prairie',3);
INSERT INTO city VALUES ('ZJN','Swan Hills',3);
INSERT INTO city VALUES ('ZLO','Manzanillo',83);
INSERT INTO city VALUES ('ZUN','Zuni',102);
INSERT INTO city VALUES ('ZZV','Zanesville',109);
INSERT INTO city VALUES ('LFOI','Abbeville',40);
INSERT INTO city VALUES ('LFBA','Agen',40);
INSERT INTO city VALUES ('LFMA','Aix Les Milles Fafb',40);
INSERT INTO city VALUES ('LFJK','Ajaccio',40);
INSERT INTO city VALUES ('LFCI','Albi',40);
INSERT INTO city VALUES ('LFOF','Alencon',40);
INSERT INTO city VALUES ('LFXA','Amberieu',40);
INSERT INTO city VALUES ('LFRA','Angers',40);
INSERT INTO city VALUES ('LFXI','Apt',40);
INSERT INTO city VALUES ('LFDH','Auch',40);
INSERT INTO city VALUES ('LFLW','Aurillac',40);
INSERT INTO city VALUES ('LFLA','Auxerre',40);
INSERT INTO city VALUES ('LFOA','Avord',40);
INSERT INTO city VALUES ('LFF3','Barfleur',40);
INSERT INTO city VALUES ('LFSB','Basel',40);
INSERT INTO city VALUES ('LFKB','Bastia',40);
INSERT INTO city VALUES ('LFOB','Beauvais',40);
INSERT INTO city VALUES ('LFA1','Beg Melen',40);
INSERT INTO city VALUES ('LFSQ','Belfort',40);
INSERT INTO city VALUES ('LFBE','Bergerac',40);
INSERT INTO city VALUES ('LFSA','Besancon',40);
INSERT INTO city VALUES ('LFMU','Beziers',40);
INSERT INTO city VALUES ('LFBZ','Biarritz',40);
INSERT INTO city VALUES ('LFBS','Biscarosse',40);
INSERT INTO city VALUES ('LFBD','Bordeaux',40);
INSERT INTO city VALUES ('LFGX','Boulogne',40);
INSERT INTO city VALUES ('LFN5','Bourg-St. Maurice',40);
INSERT INTO city VALUES ('LFLD','Bourges',40);
INSERT INTO city VALUES ('LFR3','Brehat Island',40);
INSERT INTO city VALUES ('LFRB','Brest',40);
INSERT INTO city VALUES ('LFC4','Briancon',40);
INSERT INTO city VALUES ('LFR2','Brignogan',40);
INSERT INTO city VALUES ('LFBV','Brive',40);
INSERT INTO city VALUES ('LFRK','Caen',40);
INSERT INTO city VALUES ('LFCL','Calais',40);
INSERT INTO city VALUES ('LFKC','Calvi',40);
INSERT INTO city VALUES ('LFQI','Cambrai',40);
INSERT INTO city VALUES ('LFCA','Cannes',40);
INSERT INTO city VALUES ('LFE6','Cape Bear',40);
INSERT INTO city VALUES ('LFE2','Cape Camarat',40);
INSERT INTO city VALUES ('LFC0','Cape Cepet',40);
INSERT INTO city VALUES ('LF01','Cape Corse',40);
INSERT INTO city VALUES ('LFC8','Cape Couronne',40);
INSERT INTO city VALUES ('LFC7','Cape Pomegues',40);
INSERT INTO city VALUES ('LF02','Cape Sagro',40);
INSERT INTO city VALUES ('LFMK','Carcassonne',40);
INSERT INTO city VALUES ('LFC1','Carpentras',40);
INSERT INTO city VALUES ('LFF7','Carteret',40);
INSERT INTO city VALUES ('LFIG','Cassagnes-Begonhes',40);
INSERT INTO city VALUES ('LFBC','Cazaux Pond',40);
INSERT INTO city VALUES ('LFOK','Chalons',40);
INSERT INTO city VALUES ('LFLB','Chambery',40);
INSERT INTO city VALUES ('LFCX','Chamoix',40);
INSERT INTO city VALUES ('LFPG','Charles De Gaulle',40);
INSERT INTO city VALUES ('LFQV','Charleville',40);
INSERT INTO city VALUES ('LFOR','Chartres',40);
INSERT INTO city VALUES ('LFA8','Chassiron',40);
INSERT INTO city VALUES ('LFA4','Chateau-Chinon',40);
INSERT INTO city VALUES ('LFOC','Chateaudun',40);
INSERT INTO city VALUES ('LFCH','Chateauroux',40);
INSERT INTO city VALUES ('LFQH','Chatillon-Sur-Seine',40);
INSERT INTO city VALUES ('LFRC','Cherbourg',40);
INSERT INTO city VALUES ('LFLC','Clermont',40);
INSERT INTO city VALUES ('LFBG','Cognac',40);
INSERT INTO city VALUES ('LFSC','Colmar',40);
INSERT INTO city VALUES ('LFPC','Creil',40);
INSERT INTO city VALUES ('LFBY','Dax',40);
INSERT INTO city VALUES ('LFF9','Dieppe',40);
INSERT INTO city VALUES ('LFSD','Dijon',40);
INSERT INTO city VALUES ('LFRD','Dinard',40);
INSERT INTO city VALUES ('LFF2','Dunkerque',40);
INSERT INTO city VALUES ('LFC3','Embrun',40);
INSERT INTO city VALUES ('LFR9','Epinal',40);
INSERT INTO city VALUES ('LFOE','Evreux',40);
INSERT INTO city VALUES ('LFTU','Frejus',40);
INSERT INTO city VALUES ('LFN7','Gourdon',40);
INSERT INTO city VALUES ('LFGR','Grenoble',40);
INSERT INTO city VALUES ('LFR4','Grouin De Cancale',40);
INSERT INTO city VALUES ('LFTH','Hyeres',40);
INSERT INTO city VALUES ('LFE8','Ile Rousse',40);
INSERT INTO city VALUES ('LFMI','Istres',40);
INSERT INTO city VALUES ('LFE9','La Chiappa',40);
INSERT INTO city VALUES ('LFN2','La Coubre',40);
INSERT INTO city VALUES ('LFE3','La Garoupe',40);
INSERT INTO city VALUES ('LFF4','La Hague',40);
INSERT INTO city VALUES ('LFE7','La Parata',40);
INSERT INTO city VALUES ('LFRI','La Roche',40);
INSERT INTO city VALUES ('LFBH','La Rochelle',40);
INSERT INTO city VALUES ('LFRJ','Landivisiau',40);
INSERT INTO city VALUES ('LFA5','Langres',40);
INSERT INTO city VALUES ('LFRO','Lannion',40);
INSERT INTO city VALUES ('LFRL','Lanveoc',40);
INSERT INTO city VALUES ('LFR6','Laval',40);
INSERT INTO city VALUES (' LFLH','Le Havre',40);
INSERT INTO city VALUES ('LFMC','Le Luc',40);
INSERT INTO city VALUES ('LFRM','Le Mans',40);
INSERT INTO city VALUES ('LFHP','Le Puy',40);
INSERT INTO city VALUES ('LFA2','Le Talut',40);
INSERT INTO city VALUES ('LFAT','Le Touquet',40);
INSERT INTO city VALUES ('LFE4','Les Escaldes',40);
INSERT INTO city VALUES ('LFN3','Les Sauvages',40);
INSERT INTO city VALUES ('LFQQ','Lille',40);
INSERT INTO city VALUES ('LFBL','Limoges',40);
INSERT INTO city VALUES ('LFA0','Lons-Le-Saunier Aut',40);
INSERT INTO city VALUES ('LFRH','Lorient',40);
INSERT INTO city VALUES ('LFLX','Lourdes',40);
INSERT INTO city VALUES ('LFC2','Lus-La-Croix-Haute',40);
INSERT INTO city VALUES ('LFSX','Luxeuil',40);
INSERT INTO city VALUES ('LFLY','Lyon',40);
INSERT INTO city VALUES ('LFLM','Macon',40);
INSERT INTO city VALUES ('LFML','Marseille',40);
INSERT INTO city VALUES ('LFPM','Melun',40);
INSERT INTO city VALUES ('LFNB','Mende',40);
INSERT INTO city VALUES ('LFSF','Metz',40);
INSERT INTO city VALUES ('LFJL','Metz-Nancy-Lorraine',40);
INSERT INTO city VALUES ('LFN9','Millau',40);
INSERT INTO city VALUES ('LFN4','Modane Avrieux',40);
INSERT INTO city VALUES ('LFA9','Mont St. Vincent',40);
INSERT INTO city VALUES ('LFBM','Mont-De-Marsan Fafb',40);
INSERT INTO city VALUES ('LFMM','Monte Carlo',40);
INSERT INTO city VALUES ('LFLQ','Montelimar',40);
INSERT INTO city VALUES ('LFBK','Montlucon',40);
INSERT INTO city VALUES ('LFMT','Montpellier',40);
INSERT INTO city VALUES ('LFN1','Morbier',40);
INSERT INTO city VALUES ('LFRU','Morlaix',40);
INSERT INTO city VALUES ('LFN0','Mount Aigoual',40);
INSERT INTO city VALUES ('LFSO','Nancy',40);
INSERT INTO city VALUES ('LFRS','Nantes',40);
INSERT INTO city VALUES ('LFQG','Nevers',40);
INSERT INTO city VALUES ('LFMN','Nice',40);
INSERT INTO city VALUES ('LFME','Nimes',40);
INSERT INTO city VALUES ('LFBN','Niort',40);
INSERT INTO city VALUES ('LFMO','Orange',40);
INSERT INTO city VALUES ('LFOJ','Orleans',40);
INSERT INTO city VALUES ('LFF0','Ouessant Island',40);
INSERT INTO city VALUES ('LFPO','Paris',40);
INSERT INTO city VALUES ('LFPW','Paris Met Center',40);
INSERT INTO city VALUES ('LFR0','Penmarch',40);
INSERT INTO city VALUES ('LFBX','Perigueux',40);
INSERT INTO city VALUES ('LFMP','Perpignan',40);
INSERT INTO city VALUES ('LFE0','Pertusato',40);
INSERT INTO city VALUES ('LFA7','Pointe Des Baleines',40);
INSERT INTO city VALUES ('LFR1','Pointe du Raz',40);
INSERT INTO city VALUES ('LFR5','Pointe du Roc',40);
INSERT INTO city VALUES ('LFBI','Poitiers',40);
INSERT INTO city VALUES ('LFBP','Pont-Long-Uzein',40);
INSERT INTO city VALUES ('LFE1','Porquerolles',40);
INSERT INTO city VALUES ('LFF6','Port En Bessin',40);
INSERT INTO city VALUES ('LFRQ','Quimper',40);
INSERT INTO city VALUES ('LFSR','Reims',40);
INSERT INTO city VALUES ('LFRN','Rennes',40);
INSERT INTO city VALUES ('LFCR','Rodez',40);
INSERT INTO city VALUES ('LFYR','Romorantin',40);
INSERT INTO city VALUES ('LFOP','Rouen',40);
INSERT INTO city VALUES ('LFRT','Saint-Brieuc Armor',40);
INSERT INTO city VALUES ('LFMY','Salon',40);
INSERT INTO city VALUES ('LFC6','Sete',40);
INSERT INTO city VALUES ('LFC5','Socoa',40);
INSERT INTO city VALUES ('LFKS','Solenzara',40);
INSERT INTO city VALUES ('LFSI','St. Dizier',40);
INSERT INTO city VALUES ('LFMH','St. Etienne',40);
INSERT INTO city VALUES ('LFCG','St. Girons',40);
INSERT INTO city VALUES ('LFE5','St. Leocadie',40);
INSERT INTO city VALUES ('LFRZ','St. Nazaire',40);
INSERT INTO city VALUES ('LFOW','St. Quentin',40);
INSERT INTO city VALUES ('LFA6','St. Sauveur',40);
INSERT INTO city VALUES ('LFLN','St. Yan',40);
INSERT INTO city VALUES ('LFST','Strasbourg',40);
INSERT INTO city VALUES ('LFFS','Suippes Range',40);
INSERT INTO city VALUES ('LFBT','Tarbes',40);
INSERT INTO city VALUES ('LFSL','Toul',40);
INSERT INTO city VALUES ('LFC9','Toulon',40);
INSERT INTO city VALUES ('LFBO','Toulouse',40);
INSERT INTO city VALUES ('LFOT','Tours',40);
INSERT INTO city VALUES ('LFPN','Toussus Le Noble',40);
INSERT INTO city VALUES ('LFR7','Trappes',40);
INSERT INTO city VALUES ('LFQB','Troyes',40);
INSERT INTO city VALUES ('LFVD','Val D-Isere',40);
INSERT INTO city VALUES ('LFVX','Val d-Isere',40);
INSERT INTO city VALUES ('LFF8','Valognes',40);
INSERT INTO city VALUES ('LFA3','Vannes',40);
INSERT INTO city VALUES ('LFLV','Vichy',40);
INSERT INTO city VALUES ('LFF5','Vigite du Haumet',40);
INSERT INTO city VALUES ('LFPV','Villacoublay',40);
INSERT INTO city VALUES ('LFOS','Vittefleur',40);

#
# Structure de la table `country`
#

CREATE TABLE country (
  country_title varchar(50) default NULL,
  country_id int(4) NOT NULL auto_increment,
  region_id int(4) NOT NULL default '0',
  PRIMARY KEY  (country_id),
  KEY country_title (country_title)
) TYPE=MyISAM;

#
# Contenu de la table `country`
#

INSERT INTO country VALUES ('Algérie',1,1);
INSERT INTO country VALUES ('Antille',2,5);
INSERT INTO country VALUES ('Argentine',3,9);
INSERT INTO country VALUES ('Aruba',4,5);
INSERT INTO country VALUES ('Australie',5,3);
INSERT INTO country VALUES ('Autriche',6,11);
INSERT INTO country VALUES ('Bahamas',7,5);
INSERT INTO country VALUES ('Baharain',8,2);
INSERT INTO country VALUES ('Barbades',9,5);
INSERT INTO country VALUES ('Belgique',10,11);
INSERT INTO country VALUES ('Belize',11,6);
INSERT INTO country VALUES ('Bermudes',12,6);
INSERT INTO country VALUES ('Bolivie',13,9);
INSERT INTO country VALUES ('Brézil',14,9);
INSERT INTO country VALUES ('Canada',15,4);
INSERT INTO country VALUES ('Chili',16,9);
INSERT INTO country VALUES ('Chine',17,2);
INSERT INTO country VALUES ('Colombie',18,9);
INSERT INTO country VALUES ('Cuba',19,5);
INSERT INTO country VALUES ('Curacao',20,5);
INSERT INTO country VALUES ('Chypre',21,8);
INSERT INTO country VALUES ('Rép Tchèque',22,7);
INSERT INTO country VALUES ('Danemarque',23,11);
INSERT INTO country VALUES ('Rép Dominicaine',24,5);
INSERT INTO country VALUES ('Équateur',25,9);
INSERT INTO country VALUES ('Égypte',26,1);
INSERT INTO country VALUES ('El Salvador',27,6);
INSERT INTO country VALUES ('Éthiopie',28,1);
INSERT INTO country VALUES ('Finlande',29,7);
INSERT INTO country VALUES ('France',30,11);
INSERT INTO country VALUES ('Georgie',31,2);
INSERT INTO country VALUES ('Allemagne',32,11);
INSERT INTO country VALUES ('Grèce',33,7);
INSERT INTO country VALUES ('Guadeloupe',34,5);
INSERT INTO country VALUES ('Guatemala',35,6);
INSERT INTO country VALUES ('Guyane',36,9);
INSERT INTO country VALUES ('Haïti',37,5);
INSERT INTO country VALUES ('Honduras',38,6);
INSERT INTO country VALUES ('Hongrie',39,7);
INSERT INTO country VALUES ('Islande',40,11);
INSERT INTO country VALUES ('Inde',41,2);
INSERT INTO country VALUES ('Indonésie',42,2);
INSERT INTO country VALUES ('Iran',43,8);
INSERT INTO country VALUES ('Irak',44,8);
INSERT INTO country VALUES ('Irlande',45,11);
INSERT INTO country VALUES ('Israël',46,8);
INSERT INTO country VALUES ('Italie',47,11);
INSERT INTO country VALUES ('Cote d ivoire',48,1);
INSERT INTO country VALUES ('Jamaïque',49,5);
INSERT INTO country VALUES ('Japon',50,2);
INSERT INTO country VALUES ('Jordanie',51,8);
INSERT INTO country VALUES ('Kenya',52,1);
INSERT INTO country VALUES ('Koweit',53,8);
INSERT INTO country VALUES ('Lituanie',54,7);
INSERT INTO country VALUES ('Liban',55,8);
INSERT INTO country VALUES ('Libie',56,1);
INSERT INTO country VALUES ('Malaisie',57,2);
INSERT INTO country VALUES ('Mali',58,1);
INSERT INTO country VALUES ('Martinique',59,5);
INSERT INTO country VALUES ('Mexique',60,6);
INSERT INTO country VALUES ('Maroc',61,1);
INSERT INTO country VALUES ('Pays-Bas',62,11);
INSERT INTO country VALUES ('Nouvelle Zélande',63,3);
INSERT INTO country VALUES ('Nicaragua',64,6);
INSERT INTO country VALUES ('Nigéria',65,1);
INSERT INTO country VALUES ('Norvège',66,11);
INSERT INTO country VALUES ('Pakistan',67,2);
INSERT INTO country VALUES ('Panama',68,6);
INSERT INTO country VALUES ('Paraguay',69,9);
INSERT INTO country VALUES ('Pérou',70,9);
INSERT INTO country VALUES ('Philippines',71,2);
INSERT INTO country VALUES ('Polande',72,7);
INSERT INTO country VALUES ('Portugal',73,11);
INSERT INTO country VALUES ('Puerto Rico',74,5);
INSERT INTO country VALUES ('Russie',75,2);
INSERT INTO country VALUES ('Arabie Saoudite',76,8);
INSERT INTO country VALUES ('Sénégal',77,1);
INSERT INTO country VALUES ('Serbie',78,7);
INSERT INTO country VALUES ('Singapour',79,2);
INSERT INTO country VALUES ('Slovaquie',80,7);
INSERT INTO country VALUES ('Somalie',81,1);
INSERT INTO country VALUES ('Afrique du Sud',82,1);
INSERT INTO country VALUES ('Espagne',83,11);
INSERT INTO country VALUES ('Sri Lanka',84,2);
INSERT INTO country VALUES ('St. Lucie',85,5);
INSERT INTO country VALUES ('Surinam',86,9);
INSERT INTO country VALUES ('Suède',87,11);
INSERT INTO country VALUES ('Suisse',88,11);
INSERT INTO country VALUES ('Syrie',89,8);
INSERT INTO country VALUES ('Taïwan',90,2);
INSERT INTO country VALUES ('Tanzanie',91,1);
INSERT INTO country VALUES ('Trinidad et Tobago',92,5);
INSERT INTO country VALUES ('Tunisie',93,1);
INSERT INTO country VALUES ('Turquie',94,8);
INSERT INTO country VALUES ('Ukraine',95,7);
INSERT INTO country VALUES ('Émirats Arabes Unis',96,8);
INSERT INTO country VALUES ('Royaume Unis',97,11);
INSERT INTO country VALUES ('Uruguay',98,9);
INSERT INTO country VALUES ('USA',99,10);
INSERT INTO country VALUES ('Vietnam',100,2);
INSERT INTO country VALUES ('Virgin Islands (U.S.)',101,5);
INSERT INTO country VALUES ('Zaïre',102,1);
INSERT INTO country VALUES ('Zambie',103,1);
INSERT INTO country VALUES ('Zimbabwé',104,1);

#
# Structure de la table `region`
#

CREATE TABLE region (
  region_title varchar(50) default NULL,
  region_id int(4) NOT NULL auto_increment,
  PRIMARY KEY  (region_id)
) TYPE=MyISAM;

#
# Contenu de la table `region`
#

INSERT INTO region VALUES ('Afrique',1);
INSERT INTO region VALUES ('Asie',2);
INSERT INTO region VALUES ('Australie/Nouvelle Zélande',3);
INSERT INTO region VALUES ('Canada',4);
INSERT INTO region VALUES ('Caraïbe',5);
INSERT INTO region VALUES ('Amérique Centrale',6);
INSERT INTO region VALUES ('Europe Est',7);
INSERT INTO region VALUES ('Moyen-Orient',8);
INSERT INTO region VALUES ('Amérique du Sud',9);
INSERT INTO region VALUES ('États-unis',10);
INSERT INTO region VALUES ('Europe ouest',11);

#
# Structure de la table `subdiv`
#

CREATE TABLE subdiv (
  subdiv_title varchar(50) default NULL,
  subdiv_id int(4) NOT NULL auto_increment,
  country_id int(4) NOT NULL default '0',
  PRIMARY KEY  (subdiv_id)
) TYPE=MyISAM;

#
# Contenu de la table `subdiv`
#

INSERT INTO subdiv VALUES ('AK',1,99);
INSERT INTO subdiv VALUES ('AZ',10,99);
INSERT INTO subdiv VALUES ('Nigeria',100,65);
INSERT INTO subdiv VALUES ('NJ',101,99);
INSERT INTO subdiv VALUES ('NM',102,99);
INSERT INTO subdiv VALUES ('Northern Territory',103,5);
INSERT INTO subdiv VALUES ('Northwest Territories',104,15);
INSERT INTO subdiv VALUES ('Norway',105,66);
INSERT INTO subdiv VALUES ('Nova Scotia',106,15);
INSERT INTO subdiv VALUES ('NV',107,99);
INSERT INTO subdiv VALUES ('NY',108,99);
INSERT INTO subdiv VALUES ('OH',109,99);
INSERT INTO subdiv VALUES ('Bahamas',11,7);
INSERT INTO subdiv VALUES ('OK',110,99);
INSERT INTO subdiv VALUES ('Ontario',111,15);
INSERT INTO subdiv VALUES ('OR',112,99);
INSERT INTO subdiv VALUES ('PA',113,99);
INSERT INTO subdiv VALUES ('Pakistan',114,67);
INSERT INTO subdiv VALUES ('Panama',115,68);
INSERT INTO subdiv VALUES ('Paraguay',116,69);
INSERT INTO subdiv VALUES ('Peru',117,70);
INSERT INTO subdiv VALUES ('Philippines',118,71);
INSERT INTO subdiv VALUES ('Poland',119,72);
INSERT INTO subdiv VALUES ('Baharain',12,8);
INSERT INTO subdiv VALUES ('Portugal',120,73);
INSERT INTO subdiv VALUES ('Prince Edward Island',121,15);
INSERT INTO subdiv VALUES ('Puerto Rico',122,74);
INSERT INTO subdiv VALUES ('Quebec',123,15);
INSERT INTO subdiv VALUES ('Queensland',124,5);
INSERT INTO subdiv VALUES ('RI',125,99);
INSERT INTO subdiv VALUES ('Russia',126,75);
INSERT INTO subdiv VALUES ('Saskatchewan',127,15);
INSERT INTO subdiv VALUES ('Saudi Arabia',128,76);
INSERT INTO subdiv VALUES ('SC',129,99);
INSERT INTO subdiv VALUES ('Barbados',13,9);
INSERT INTO subdiv VALUES ('SD',130,99);
INSERT INTO subdiv VALUES ('Senegal',131,77);
INSERT INTO subdiv VALUES ('Serbia',132,78);
INSERT INTO subdiv VALUES ('Singapore',133,79);
INSERT INTO subdiv VALUES ('Slovakia',134,80);
INSERT INTO subdiv VALUES ('Somalia',135,81);
INSERT INTO subdiv VALUES ('South Africa',136,82);
INSERT INTO subdiv VALUES ('Spain',137,83);
INSERT INTO subdiv VALUES ('Sri Lanka',138,84);
INSERT INTO subdiv VALUES ('St. Lucia',139,85);
INSERT INTO subdiv VALUES ('Belgium',14,10);
INSERT INTO subdiv VALUES ('Suriname',140,86);
INSERT INTO subdiv VALUES ('Sweden',141,87);
INSERT INTO subdiv VALUES ('Switzerland',142,88);
INSERT INTO subdiv VALUES ('Syria',143,89);
INSERT INTO subdiv VALUES ('Taiwan',144,90);
INSERT INTO subdiv VALUES ('Tanzania',145,91);
INSERT INTO subdiv VALUES ('Tasmania',146,5);
INSERT INTO subdiv VALUES ('TN',147,99);
INSERT INTO subdiv VALUES ('Trinidad and Tobago',148,92);
INSERT INTO subdiv VALUES ('Tunisia',149,93);
INSERT INTO subdiv VALUES ('Belize',15,11);
INSERT INTO subdiv VALUES ('Turkey',150,94);
INSERT INTO subdiv VALUES ('TX',151,99);
INSERT INTO subdiv VALUES ('Ukraine',152,95);
INSERT INTO subdiv VALUES ('United Arab Emirates',153,96);
INSERT INTO subdiv VALUES ('United Kingdom',154,97);
INSERT INTO subdiv VALUES ('Uruguay',155,98);
INSERT INTO subdiv VALUES ('UT',156,99);
INSERT INTO subdiv VALUES ('VA',157,99);
INSERT INTO subdiv VALUES ('Victoria',158,5);
INSERT INTO subdiv VALUES ('Vietnam',159,100);
INSERT INTO subdiv VALUES ('Bermuda',16,12);
INSERT INTO subdiv VALUES ('Virgin Islands (U.S.)',160,101);
INSERT INTO subdiv VALUES ('VT',161,99);
INSERT INTO subdiv VALUES ('WA',162,99);
INSERT INTO subdiv VALUES ('Western Australia',163,5);
INSERT INTO subdiv VALUES ('WI',164,99);
INSERT INTO subdiv VALUES ('WV',165,99);
INSERT INTO subdiv VALUES ('WY',166,99);
INSERT INTO subdiv VALUES ('Yukon Territories',167,15);
INSERT INTO subdiv VALUES ('Zaire',168,102);
INSERT INTO subdiv VALUES ('Zambia',169,103);
INSERT INTO subdiv VALUES ('Bolivia',17,13);
INSERT INTO subdiv VALUES ('Zimbabwe',170,104);
INSERT INTO subdiv VALUES ('Brazil',18,14);
INSERT INTO subdiv VALUES ('British Columbia',19,15);
INSERT INTO subdiv VALUES ('AL',2,99);
INSERT INTO subdiv VALUES ('CA',20,99);
INSERT INTO subdiv VALUES ('Chile',21,16);
INSERT INTO subdiv VALUES ('China',22,17);
INSERT INTO subdiv VALUES ('CO',23,99);
INSERT INTO subdiv VALUES ('Colombia',24,18);
INSERT INTO subdiv VALUES ('CT',25,99);
INSERT INTO subdiv VALUES ('Cuba',26,19);
INSERT INTO subdiv VALUES ('Curacao',27,20);
INSERT INTO subdiv VALUES ('Cyprus',28,21);
INSERT INTO subdiv VALUES ('Czech Republic',29,22);
INSERT INTO subdiv VALUES ('Alberta',3,15);
INSERT INTO subdiv VALUES ('DC',30,99);
INSERT INTO subdiv VALUES ('DE',31,99);
INSERT INTO subdiv VALUES ('Denmark',32,23);
INSERT INTO subdiv VALUES ('Dominican Republic',33,24);
INSERT INTO subdiv VALUES ('Ecuador',34,25);
INSERT INTO subdiv VALUES ('Egypt',35,26);
INSERT INTO subdiv VALUES ('El Salvador',36,27);
INSERT INTO subdiv VALUES ('Ethiopia',37,28);
INSERT INTO subdiv VALUES ('Finland',38,29);
INSERT INTO subdiv VALUES ('FL',39,99);
INSERT INTO subdiv VALUES ('Algeria',4,1);
INSERT INTO subdiv VALUES ('France',40,30);
INSERT INTO subdiv VALUES ('GA',41,99);
INSERT INTO subdiv VALUES ('Georgia',42,31);
INSERT INTO subdiv VALUES ('Germany',43,32);
INSERT INTO subdiv VALUES ('Greece',44,33);
INSERT INTO subdiv VALUES ('Guadaloupe',45,34);
INSERT INTO subdiv VALUES ('Guatemala',46,35);
INSERT INTO subdiv VALUES ('Guyana',47,36);
INSERT INTO subdiv VALUES ('Haiti',48,37);
INSERT INTO subdiv VALUES ('HI',49,99);
INSERT INTO subdiv VALUES ('Antigua',5,2);
INSERT INTO subdiv VALUES ('Honduras',50,38);
INSERT INTO subdiv VALUES ('Hungary',51,39);
INSERT INTO subdiv VALUES ('IA',52,99);
INSERT INTO subdiv VALUES ('Iceland',53,40);
INSERT INTO subdiv VALUES ('ID',54,99);
INSERT INTO subdiv VALUES ('IL',55,99);
INSERT INTO subdiv VALUES ('IN',56,99);
INSERT INTO subdiv VALUES ('India',57,41);
INSERT INTO subdiv VALUES ('Indonesia',58,42);
INSERT INTO subdiv VALUES ('Iran',59,43);
INSERT INTO subdiv VALUES ('AR',6,99);
INSERT INTO subdiv VALUES ('Iraq',60,44);
INSERT INTO subdiv VALUES ('Ireland',61,45);
INSERT INTO subdiv VALUES ('Israel',62,46);
INSERT INTO subdiv VALUES ('Italy',63,47);
INSERT INTO subdiv VALUES ('Ivory Coast',64,48);
INSERT INTO subdiv VALUES ('Jamaica',65,49);
INSERT INTO subdiv VALUES ('Japan',66,50);
INSERT INTO subdiv VALUES ('Jordan',67,51);
INSERT INTO subdiv VALUES ('Kenya',68,52);
INSERT INTO subdiv VALUES ('KS',69,99);
INSERT INTO subdiv VALUES ('Argentina',7,3);
INSERT INTO subdiv VALUES ('Kuwait',70,53);
INSERT INTO subdiv VALUES ('KY',71,99);
INSERT INTO subdiv VALUES ('LA',72,99);
INSERT INTO subdiv VALUES ('Latvia',73,54);
INSERT INTO subdiv VALUES ('Lebanon',74,55);
INSERT INTO subdiv VALUES ('Libya',75,56);
INSERT INTO subdiv VALUES ('MA',76,99);
INSERT INTO subdiv VALUES ('Malaisie',77,57);
INSERT INTO subdiv VALUES ('Mali',78,58);
INSERT INTO subdiv VALUES ('Manitoba',79,15);
INSERT INTO subdiv VALUES ('Aruba',8,4);
INSERT INTO subdiv VALUES ('Martinique',80,59);
INSERT INTO subdiv VALUES ('MD',81,99);
INSERT INTO subdiv VALUES ('ME',82,99);
INSERT INTO subdiv VALUES ('Mexico',83,60);
INSERT INTO subdiv VALUES ('MI',84,99);
INSERT INTO subdiv VALUES ('MN',85,99);
INSERT INTO subdiv VALUES ('MO',86,99);
INSERT INTO subdiv VALUES ('Morocco',87,61);
INSERT INTO subdiv VALUES ('MS',88,99);
INSERT INTO subdiv VALUES ('MT',89,99);
INSERT INTO subdiv VALUES ('Austria',9,6);
INSERT INTO subdiv VALUES ('NC',90,99);
INSERT INTO subdiv VALUES ('ND',91,99);
INSERT INTO subdiv VALUES ('NE',92,99);
INSERT INTO subdiv VALUES ('Netherlands',93,62);
INSERT INTO subdiv VALUES ('New Brunswick',94,15);
INSERT INTO subdiv VALUES ('New South Wales',95,5);
INSERT INTO subdiv VALUES ('New Zealand',96,63);
INSERT INTO subdiv VALUES ('Newfoundland',97,15);
INSERT INTO subdiv VALUES ('NH',98,99);
INSERT INTO subdiv VALUES ('Nicaragua',99,64);

#
# Structure de la table `userweather`
#

CREATE TABLE userweather (
  userid int(11) NOT NULL default '0',
  accid varchar(5) NOT NULL default '',
  tpc tinyint(1) NOT NULL default '1',
  tps tinyint(1) NOT NULL default '1',
  PRIMARY KEY  (userid)
) TYPE=MyISAM;

#
# Contenu de la table `userweather`
#

INSERT INTO userweather (userid, accid, tpc, tps) VALUES (0, 'LFSD', 0, 0);
