CREATE TABLE us_zipcode_default_cities
(
id INT PRIMARY KEY,
sid INT,
default_state CHAR(2),
default_city VARCHAR(30),
default_type VARCHAR(10),
zip_code CHAR(5)
);

--

INSERT INTO us_zipcode_default_cities (id, sid, default_state, default_city, default_type, zip_code) VALUES
(4735, 6, 'CA', 'VALENCIA', 'STANDARD', '91354'),
(4736, 6, 'CA', 'VALENCIA', 'STANDARD', '91355'),
(4737, 6, 'CA', 'VALENCIA', 'PO BOX', '91385'),
(9114, 16, 'ID', 'MERIDIAN', 'STANDARD', '83642'),
(9115, 16, 'ID', 'MERIDIAN', 'STANDARD', '83646'),
(9116, 16, 'ID', 'MERIDIAN', 'PO BOX', '83680'),
(13162, 20, 'KS', 'LEAWOOD', 'STANDARD', '66206'),
(13163, 20, 'KS', 'LEAWOOD', 'STANDARD', '66209'),
(13164, 20, 'KS', 'LEAWOOD', 'STANDARD', '66211');