-- This file will create and populate a table called us_postal_codes
-- with the postal codes of all 50 states, Washington DC, and 9
-- protectorates.

-- Create the table
CREATE TABLE us_postal_codes (
	abbr	char(2) primary key,
	name	varchar(32)
);

-- Insert the 50 states and Washington DC
INSERT INTO us_postal_codes (abbr, name) VALUES('AL', 'Alabama');
INSERT INTO us_postal_codes (abbr, name) VALUES('AK', 'Alaska');
INSERT INTO us_postal_codes (abbr, name) VALUES('AZ', 'Arizona');
INSERT INTO us_postal_codes (abbr, name) VALUES('AR', 'Arkansas');
INSERT INTO us_postal_codes (abbr, name) VALUES('CA', 'California');
INSERT INTO us_postal_codes (abbr, name) VALUES('CO', 'Colorado');
INSERT INTO us_postal_codes (abbr, name) VALUES('CT', 'Connecticut');
INSERT INTO us_postal_codes (abbr, name) VALUES('DE', 'Delaware');
INSERT INTO us_postal_codes (abbr, name) VALUES('DC', 'District of Columbia');
INSERT INTO us_postal_codes (abbr, name) VALUES('FL', 'Florida');
INSERT INTO us_postal_codes (abbr, name) VALUES('GA', 'Georgia');
INSERT INTO us_postal_codes (abbr, name) VALUES('HI', 'Hawaii');
INSERT INTO us_postal_codes (abbr, name) VALUES('ID', 'Idaho');
INSERT INTO us_postal_codes (abbr, name) VALUES('IL', 'Illinois');
INSERT INTO us_postal_codes (abbr, name) VALUES('IN', 'Indiana');
INSERT INTO us_postal_codes (abbr, name) VALUES('IA', 'Iowa');
INSERT INTO us_postal_codes (abbr, name) VALUES('KS', 'Kansas');
INSERT INTO us_postal_codes (abbr, name) VALUES('KY', 'Kentucky');
INSERT INTO us_postal_codes (abbr, name) VALUES('LA', 'Louisiana');
INSERT INTO us_postal_codes (abbr, name) VALUES('ME', 'Maine');
INSERT INTO us_postal_codes (abbr, name) VALUES('MD', 'Maryland');
INSERT INTO us_postal_codes (abbr, name) VALUES('MA', 'Massachusetts');
INSERT INTO us_postal_codes (abbr, name) VALUES('MI', 'Michigan');
INSERT INTO us_postal_codes (abbr, name) VALUES('MN', 'Minnesota');
INSERT INTO us_postal_codes (abbr, name) VALUES('MS', 'Mississippi');
INSERT INTO us_postal_codes (abbr, name) VALUES('MO', 'Missouri');
INSERT INTO us_postal_codes (abbr, name) VALUES('MT', 'Montana');
INSERT INTO us_postal_codes (abbr, name) VALUES('NE', 'Nebraska');
INSERT INTO us_postal_codes (abbr, name) VALUES('NV', 'Nevada');
INSERT INTO us_postal_codes (abbr, name) VALUES('NH', 'New Hampshire');
INSERT INTO us_postal_codes (abbr, name) VALUES('NJ', 'New Jersey');
INSERT INTO us_postal_codes (abbr, name) VALUES('NM', 'New Mexico');
INSERT INTO us_postal_codes (abbr, name) VALUES('NY', 'New York');
INSERT INTO us_postal_codes (abbr, name) VALUES('NC', 'North Carolina');
INSERT INTO us_postal_codes (abbr, name) VALUES('ND', 'North Dakota');
INSERT INTO us_postal_codes (abbr, name) VALUES('OH', 'Ohio');
INSERT INTO us_postal_codes (abbr, name) VALUES('OK', 'Oklahoma');
INSERT INTO us_postal_codes (abbr, name) VALUES('OR', 'Oregon');
INSERT INTO us_postal_codes (abbr, name) VALUES('PA', 'Pennsylvania');
INSERT INTO us_postal_codes (abbr, name) VALUES('RI', 'Rhode Island');
INSERT INTO us_postal_codes (abbr, name) VALUES('SC', 'South Carolina');
INSERT INTO us_postal_codes (abbr, name) VALUES('SD', 'South Dakota');
INSERT INTO us_postal_codes (abbr, name) VALUES('TN', 'Tennessee');
INSERT INTO us_postal_codes (abbr, name) VALUES('TX', 'Texas');
INSERT INTO us_postal_codes (abbr, name) VALUES('UT', 'Utah');
INSERT INTO us_postal_codes (abbr, name) VALUES('VT', 'Vermont');
INSERT INTO us_postal_codes (abbr, name) VALUES('VA', 'Virginia');
INSERT INTO us_postal_codes (abbr, name) VALUES('WA', 'Washington');
INSERT INTO us_postal_codes (abbr, name) VALUES('WV', 'West Virginia');
INSERT INTO us_postal_codes (abbr, name) VALUES('WI', 'Wisconsin');
INSERT INTO us_postal_codes (abbr, name) VALUES('WY', 'Wyoming');

-- US Protectorates
INSERT INTO us_postal_codes (abbr, name) VALUES('AS', 'American Samoa');
INSERT INTO us_postal_codes (abbr, name) VALUES('FM', 'Federated States of Micronesia');
INSERT INTO us_postal_codes (abbr, name) VALUES('GU', 'Guam');
INSERT INTO us_postal_codes (abbr, name) VALUES('MH', 'Marshall Islands');
INSERT INTO us_postal_codes (abbr, name) VALUES('MP', 'Northern Mariana Islands');
INSERT INTO us_postal_codes (abbr, name) VALUES('PW', 'Palau');
INSERT INTO us_postal_codes (abbr, name) VALUES('PR', 'Puerto Rico');
INSERT INTO us_postal_codes (abbr, name) VALUES('VI', 'Virgin Islands');