CREATE TABLE us_states_50
(
id INT PRIMARY KEY,
state_abbr CHAR(2) UNIQUE,
state_name VARCHAR(15)
);

--

INSERT INTO us_states_50 (id, state_abbr, state_name) VALUES
(1, 'AL', 'Alabama'),
(2, 'AK', 'Alaska'),
(3, 'AZ', 'Arizona');