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

--

INSERT INTO us_zipcodes_by_city (id, sid, state_abbr, city, list_type_id, list_type, zip_code, default_state, default_city, default_type) VALUES
(7974, 6, 'CA', 'VALENCIA', 1, 'default', '91354', 'CA', 'VALENCIA', 'STANDARD'),
(7975, 6, 'CA', 'VALENCIA', 1, 'default', '91355', 'CA', 'VALENCIA', 'STANDARD'),
(7976, 6, 'CA', 'VALENCIA', 1, 'default', '91385', 'CA', 'VALENCIA', 'PO BOX'),
(7977, 6, 'CA', 'VALENCIA', 2, 'recognized', '91380', 'CA', 'SANTA CLARITA', 'PO BOX'),
(7978, 6, 'CA', 'VALENCIA', 2, 'recognized', '91381', 'CA', 'STEVENSON RANCH', 'STANDARD'),
(7979, 6, 'CA', 'VALENCIA', 3, 'unaccepted', '91359', 'CA', 'WESTLAKE VILLAGE', 'PO BOX'),
(16421, 16, 'ID', 'MERIDIAN', 1, 'default', '83642', 'ID', 'MERIDIAN', 'STANDARD'),
(16422, 16, 'ID', 'MERIDIAN', 1, 'default', '83646', 'ID', 'MERIDIAN', 'STANDARD'),
(16423, 16, 'ID', 'MERIDIAN', 1, 'default', '83680', 'ID', 'MERIDIAN', 'PO BOX'),
(16424, 16, 'ID', 'MERIDIAN', 2, 'recognized', '83687', 'ID', 'NAMPA', 'STANDARD'),
(16425, 16, 'ID', 'MERIDIAN', 2, 'recognized', '83713', 'ID', 'BOISE', 'STANDARD'),
(16426, 16, 'ID', 'MERIDIAN', 3, 'unaccepted', '83634', 'ID', 'KUNA', 'STANDARD'),
(24013, 20, 'KS', 'LEAWOOD', 1, 'default', '66206', 'KS', 'LEAWOOD', 'STANDARD'),
(24014, 20, 'KS', 'LEAWOOD', 1, 'default', '66209', 'KS', 'LEAWOOD', 'STANDARD'),
(24015, 20, 'KS', 'LEAWOOD', 1, 'default', '66211', 'KS', 'LEAWOOD', 'STANDARD'),
(24016, 20, 'KS', 'LEAWOOD', 2, 'recognized', '66224', 'KS', 'OVERLAND PARK', 'STANDARD'),
(24017, 20, 'KS', 'LEAWOOD', 3, 'unaccepted', '66207', 'KS', 'OVERLAND PARK', 'STANDARD');