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

--

INSERT INTO us_zipcodes (id, zip_code, sid, default_state, default_city, default_type) VALUES
(28535, '66206', 20, 'KS', 'LEAWOOD', 'STANDARD'),
(28538, '66209', 20, 'KS', 'LEAWOOD', 'STANDARD'),
(28540, '66211', 20, 'KS', 'LEAWOOD', 'STANDARD'),
(35551, '83642', 16, 'ID', 'MERIDIAN', 'STANDARD'),
(35555, '83646', 16, 'ID', 'MERIDIAN', 'STANDARD'),
(35575, '83680', 16, 'ID', 'MERIDIAN', 'PO BOX'),
(37672, '91354', 6, 'CA', 'VALENCIA', 'STANDARD'),
(37673, '91355', 6, 'CA', 'VALENCIA', 'STANDARD'),
(37693, '91385', 6, 'CA', 'VALENCIA', 'PO BOX');