rendered paste body---- Table structure for table `provinces_to_2lt`--CREATE TABLE IF NOT EXISTS `provinces_to_2lt` ( `prov_code` varchar(2) NOT NULL, `province_common` varchar(45) NOT NULL, PRIMARY KEY (`prov_code`), KEY `common` (`province_common`(2))) ENGINE=MyISAM DEFAULT CHARSET=latin1;---- Dumping data for table `provinces_to_2lt`--INSERT INTO `provinces_to_2lt` (`prov_code`, `province_common`) VALUES('VI', '(U.S.) Virgin Islands'),('AL', 'Alabama'),('AK', 'Alaska'),('AB', 'Alberta'),('AS', 'American Samoa'),('AZ', 'Arizona'),('AR', 'Arkansas'),('AE', 'Armed Forces, Europe'),('AP', 'Armed Forces, Pacific'),('AA', 'Armed Forces, the Americas'),('BC', 'British Columbia'),('CA', 'California'),('CO', 'Colorado'),('CT', 'Connecticut'),('DE', 'Delaware'),('DC', 'District of Columbia'),('FM', 'Fed. States of Micronesia'),('FL', 'Florida'),('GA', 'Georgia'),('GU', 'Guam'),('HI', 'Hawaii'),('ID', 'Idaho'),('IL', 'Illinois'),('IN', 'Indiana'),('IA', 'Iowa'),('KS', 'Kansas'),('KY', 'Kentucky'),('LA', 'Louisiana'),('ME', 'Maine'),('MB', 'Manitoba'),('MH', 'Marshall Islands'),('MD', 'Maryland'),('MA', 'Massachusetts'),('MI', 'Michigan'),('MN', 'Minnesota'),('MS', 'Mississippi'),('MO', 'Missouri'),('MT', 'Montana'),('NE', 'Nebraska'),('NV', 'Nevada'),('NB', 'New Brunswick'),('NH', 'New Hampshire'),('NJ', 'New Jersey'),('NM', 'New Mexico'),('NY', 'New York'),('NF', 'Newfoundland'),('NC', 'North Carolina'),('ND', 'North Dakota'),('MP', 'Northern Marianas'),('NT', 'Northwest Territories and Nunavut'),('NS', 'Nova Scotia'),('OH', 'Ohio'),('OK', 'Oklahoma'),('ON', 'Ontario'),('OR', 'Oregon'),('PA', 'Pennsylvania'),('PE', 'Prince Edward Island'),('PR', 'Puerto Rico'),('QC', 'Québec'),('RI', 'Rhode Island'),('SK', 'Sakatchewan'),('SC', 'South Carolina'),('SD', 'South Dakota'),('TN', 'Tennessee'),('TX', 'Texas'),('UT', 'Utah'),('VT', 'Vermont'),('VA', 'Virginia'),('WA', 'Washington'),('WV', 'West Virginia'),('WI', 'Wisconsin'),('WY', 'Wyoming'),('YT', 'Yukon Territory');