CREATE TABLE us_zipcode_cities
(
id INT PRIMARY KEY,
zip_code CHAR(5),
sid INT,
state_abbr CHAR(2),
city VARCHAR(30),
list_type_id INT,
list_type VARCHAR(10),
default_state CHAR(2),
default_city VARCHAR(30),
default_type VARCHAR(10)
);

--

INSERT INTO us_zipcode_cities (id, zip_code, sid, state_abbr, city, list_type_id, list_type, default_state, default_city, default_type) VALUES
(57080, '66206', 20, 'KS', 'LEAWOOD', 1, 'default', 'KS', 'LEAWOOD', 'STANDARD'),
(57081, '66206', 20, 'KS', 'OVERLAND PARK', 2, 'recognized', 'KS', 'LEAWOOD', 'STANDARD'),
(57082, '66206', 20, 'KS', 'PRAIRIE VILLAGE', 2, 'recognized', 'KS', 'LEAWOOD', 'STANDARD'),
(57083, '66206', 20, 'KS', 'PRAIRIE VLG', 2, 'recognized', 'KS', 'LEAWOOD', 'STANDARD'),
(57084, '66206', 20, 'KS', 'SHAWNEE MISSION', 2, 'recognized', 'KS', 'LEAWOOD', 'STANDARD'),
(57085, '66206', 20, 'KS', 'SHAWNEE MSN', 2, 'recognized', 'KS', 'LEAWOOD', 'STANDARD'),
(57086, '66206', 20, 'KS', 'OVERLAND', 3, 'unaccepted', 'KS', 'LEAWOOD', 'STANDARD'),
(57087, '66206', 20, 'KS', 'SM', 3, 'unaccepted', 'KS', 'LEAWOOD', 'STANDARD'),
(57102, '66209', 20, 'KS', 'LEAWOOD', 1, 'default', 'KS', 'LEAWOOD', 'STANDARD'),
(57103, '66209', 20, 'KS', 'OVERLAND PARK', 2, 'recognized', 'KS', 'LEAWOOD', 'STANDARD'),
(57104, '66209', 20, 'KS', 'SHAWNEE MISSION', 2, 'recognized', 'KS', 'LEAWOOD', 'STANDARD'),
(57105, '66209', 20, 'KS', 'SHAWNEE MSN', 2, 'recognized', 'KS', 'LEAWOOD', 'STANDARD'),
(57106, '66209', 20, 'KS', 'OVERLAND', 3, 'unaccepted', 'KS', 'LEAWOOD', 'STANDARD'),
(57107, '66209', 20, 'KS', 'SM', 3, 'unaccepted', 'KS', 'LEAWOOD', 'STANDARD'),
(57114, '66211', 20, 'KS', 'LEAWOOD', 1, 'default', 'KS', 'LEAWOOD', 'STANDARD'),
(57115, '66211', 20, 'KS', 'OVERLAND PARK', 2, 'recognized', 'KS', 'LEAWOOD', 'STANDARD'),
(57116, '66211', 20, 'KS', 'SHAWNEE MISSION', 2, 'recognized', 'KS', 'LEAWOOD', 'STANDARD'),
(57117, '66211', 20, 'KS', 'SHAWNEE MSN', 2, 'recognized', 'KS', 'LEAWOOD', 'STANDARD'),
(57118, '66211', 20, 'KS', 'OVERLAND', 3, 'unaccepted', 'KS', 'LEAWOOD', 'STANDARD'),
(57119, '66211', 20, 'KS', 'SM', 3, 'unaccepted', 'KS', 'LEAWOOD', 'STANDARD'),
(69476, '83642', 16, 'ID', 'MERIDIAN', 1, 'default', 'ID', 'MERIDIAN', 'STANDARD'),
(69477, '83642', 16, 'ID', 'KUNA', 2, 'recognized', 'ID', 'MERIDIAN', 'STANDARD'),
(69481, '83646', 16, 'ID', 'MERIDIAN', 1, 'default', 'ID', 'MERIDIAN', 'STANDARD'),
(69482, '83646', 16, 'ID', 'EAGLE', 2, 'recognized', 'ID', 'MERIDIAN', 'STANDARD'),
(69483, '83646', 16, 'ID', 'NAMPA', 2, 'recognized', 'ID', 'MERIDIAN', 'STANDARD'),
(69528, '83680', 16, 'ID', 'MERIDIAN', 1, 'default', 'ID', 'MERIDIAN', 'PO BOX'),
(73591, '91354', 6, 'CA', 'VALENCIA', 1, 'default', 'CA', 'VALENCIA', 'STANDARD'),
(73592, '91354', 6, 'CA', 'SANTA CLARITA', 2, 'recognized', 'CA', 'VALENCIA', 'STANDARD'),
(73593, '91355', 6, 'CA', 'VALENCIA', 1, 'default', 'CA', 'VALENCIA', 'STANDARD'),
(73594, '91355', 6, 'CA', 'SANTA CLARITA', 2, 'recognized', 'CA', 'VALENCIA', 'STANDARD'),
(73639, '91385', 6, 'CA', 'VALENCIA', 1, 'default', 'CA', 'VALENCIA', 'PO BOX'),
(73640, '91385', 6, 'CA', 'SANTA CLARITA', 2, 'recognized', 'CA', 'VALENCIA', 'PO BOX');