CREATE TABLE events (
    gameid character varying(12),
    visitingteam character varying(3),
    inning integer,
    battingteam integer,
    outs integer,
    balls integer,
    strikes integer,
    pitchsequence character varying(40),
    visscore integer,
    homescore integer,
    batter character varying(8),
    batterhand character varying(1),
    resbatter character varying(8),
    resbatterhand character varying(1),
    pitcher character varying(8),
    pitcherhand character varying(1),
    respitcher character varying(8),
    respitcherhand character varying(1),
    catcher character varying(8),
    firstbase character varying(8),
    secondbase character varying(8),
    thirdbase character varying(8),
    shortstop character varying(8),
    leftfield character varying(8),
    centerfield character varying(8),
    rightfield character varying(8),
    firstrunner character varying(8),
    secondrunner character varying(8),
    thirdrunner character varying(8),
    eventtext character varying(100),
    leadoffflag character varying(1),
    pinchhitflag character varying(1),
    defensiveposition character varying(2),
    lineupposition integer,
    eventtype integer,
    battereventflag character varying(1),
    abflag character varying(1),
    hitvalue integer,
    shflag character varying(1),
    sfflag character varying(1),
    outsonplay integer,
    doubleplayflag character varying(1),
    tripleplayflag character varying(1),
    rbionplay integer,
    wildpitchflag character varying(1),
    passedballflag character varying(1),
    fieldedby integer,
    battedballtype character varying(1),
    buntflag character varying(1),
    foulflag character varying(1),
    hitlocation character varying(5),
    numerrors integer,
    firsterrorplayer character varying(8),
    firsterrortype character varying(1),
    seconderrorplayer character varying(8),
    seconderrortype character varying(1),
    thirderrorplayer character varying(8),
    thirderrortype character varying(1),
    batterdest integer,
    runneronfirstdest integer,
    runneronseconddest integer,
    runneronthirddest integer,
    playonbatter character varying(8),
    playonrunneronfirst character varying(15),
    playonrunneronsecond character varying(15),
    playonrunneronthird character varying(15),
    sbforrunneronfirstflag character varying(1),
    sbforrunneronsecondflag character varying(1),
    sbforrunneronthirdflag character varying(1),
    csforrunneronfirstflag character varying(1),
    csforrunneronsecondflag character varying(1),
    csforrunneronthirdflag character varying(1),
    poforrunneronfirstflag character varying(1),
    poforrunneronsecondflag character varying(1),
    poforrunneronthirdflag character varying(1),
    responsiblepitcherforrunneratfirst character varying(8),
    responsiblepitcherforrunneratsecond character varying(8),
    responsiblepitcherforrunneratthird character varying(8),
    newgameflag character varying(1),
    endgameflag character varying(1),
    pinchrunneronfirst character varying(1),
    pinchrunneronsecond character varying(1),
    pinchrunneronthird character varying(1),
    runnerremovedforpinchrunnerfirst character varying(8),
    runnerremovedforpinchrunneronsecond character varying(8),
    runnerremovedforpinchrunneronthird character varying(8),
    batterremovedforpinchhitter character varying(8),
    positionofbatterremovedforpinchhitter integer,
    fielderwithfirstputout integer,
    fielderwithsecondputout integer,
    fielderwiththirdputout integer,
    fielderwithfirstassist integer,
    fielderwithsecondassist integer,
    fielderwiththirdassist integer,
    fielderwithfourthassist integer,
    fielderwithfifthassist integer,
    eventnum integer
);
CREATE INDEX events_batter_idx ON events (batter);
CREATE INDEX events_gameid_idx ON events (gameid);
CREATE INDEX events_pitcher_idx ON events (pitcher);