CREATE TABLE state (
    state_id serial NOT NULL,
    abbr character varying(2) DEFAULT ''::character varying NOT NULL,
    name character varying(40) DEFAULT ''::character varying NOT NULL
);