CREATE TABLE eventtypes (
        eventtype INTEGER,
        eventname CHARACTER VARYING(30)
);

INSERT INTO eventtypes VALUES (0, 'Unknown event');
INSERT INTO eventtypes VALUES (1, 'No event');
INSERT INTO eventtypes VALUES (2, 'Generic out');
INSERT INTO eventtypes VALUES (3, 'Strikeout');
INSERT INTO eventtypes VALUES (4, 'Stolen base');
INSERT INTO eventtypes VALUES (5, 'Defensive indifference');
INSERT INTO eventtypes VALUES (6, 'Caught stealing');
INSERT INTO eventtypes VALUES (7, 'Pickoff error');
INSERT INTO eventtypes VALUES (8, 'Pickoff ');
INSERT INTO eventtypes VALUES (9, 'Wild pitch');
INSERT INTO eventtypes VALUES (10, 'Passed ball');
INSERT INTO eventtypes VALUES (11, 'Balk');
INSERT INTO eventtypes VALUES (12, 'Other advance');
INSERT INTO eventtypes VALUES (13, 'Foul error');
INSERT INTO eventtypes VALUES (14, 'Walk');
INSERT INTO eventtypes VALUES (15, 'Intentional walk');
INSERT INTO eventtypes VALUES (16, 'Hit by Pitch');
INSERT INTO eventtypes VALUES (17, 'Interference ');
INSERT INTO eventtypes VALUES (18, 'Error');
INSERT INTO eventtypes VALUES (19, 'Fielder''s choice');
INSERT INTO eventtypes VALUES (20, 'Single');
INSERT INTO eventtypes VALUES (21, 'Double');
INSERT INTO eventtypes VALUES (22, 'Triple');
INSERT INTO eventtypes VALUES (23, 'Home run');
INSERT INTO eventtypes VALUES (24, 'Missing play');

CREATE INDEX eventtypes_eventtype_idx ON eventtypes(eventtype);