CREATE TABLE us_states
(
id INT PRIMARY KEY,
state_abbr CHAR(2),
state_name VARCHAR(30)
);

--

INSERT INTO us_states (id, state_abbr, state_name) VALUES
(1, 'AL', 'Alabama'),
(2, 'AK', 'Alaska'),
(3, 'AS', 'American Samoa'),
(4, 'AZ', 'Arizona');