DROP TABLE IF EXISTS GAMELOG
;
CREATE TABLE GAMELOG 
(
	DATE INTEGER,
	GAME_NUM_CT INTEGER,
	DOW VARCHAR(3),
	AWAY_TEAM_ID VARCHAR(3),
	AWAY_TEAM_LG_ID VARCHAR(2),
	AWAY_TEAM_GAME_NUMBER_CT INTEGER,
	HOME_TEAM_ID VARCHAR(3),
	HOME_TEAM_LG_ID VARCHAR(2),
	HOME_TEAM_GAME_NUMBER_CT INTEGER,
	AWAY_SCORE_CT INTEGER,
	HOME_SCORE_CT INTEGER,
	OUTS_CT INTEGER,
	DAY_NIGHT_FL VARCHAR(1),
	COMP_INFO_TX VARCHAR(100),
	FORFIET_CD VARCHAR(5),
	PROTEST_CD VARCHAR(2),
	PARK_ID VARCHAR(5),
	ATTENDANCE_CT VARCHAR(6),
	GAME_MINUTES_CT INTEGER,
	AWAY_LINESCORE_TX VARCHAR(25),
	HOME_LINESCORE_TX VARCHAR(25),
	AWAY_AB_CT INTEGER,
	AWAY_H_CT INTEGER,
	AWAY_D_CT INTEGER,
	AWAY_T_CT INTEGER,
	AWAY_HR_CT INTEGER,
	AWAY_RBI_CT INTEGER,
	AWAY_SH_CT INTEGER,
	AWAY_SF_CT INTEGER,
	AWAY_HBP_CT INTEGER,
	AWAY_BB_CT INTEGER,
	AWAY_IBB_CT INTEGER,
	AWAY_SO_CT INTEGER,
	AWAY_SB_CT INTEGER,
	AWAY_CS_CT INTEGER,
	AWAY_GIDP_CT INTEGER,
	AWAY_CATCHER_INTER_CT INTEGER,
	AWAY_LOB_CT INTEGER,
	AWAY_PITCHERS_USED_CT INTEGER,
	AWAY_IND_ERR_CT INTEGER,
	AWAY_TEAM_ERR_CT INTEGER,
	AWAY_WP_CT INTEGER,
	AWAY_BALKS_CT INTEGER,
	AWAY_PO_CT INTEGER,
	AWAY_A_CT INTEGER,
	AWAY_E_CT INTEGER,
	AWAY_PB_CT INTEGER,
	AWAY_DP_CT INTEGER,
	AWAY_TP_CT INTEGER,
	HOME_AB_CT INTEGER,
	HOME_H_CT INTEGER,
	HOME_D_CT INTEGER,
	HOME_T_CT INTEGER,
	HOME_HR_CT INTEGER,
	HOME_RBI_CT INTEGER,
	HOME_SH_CT INTEGER,
	HOME_SF_CT INTEGER,
	HOME_HBP_CT INTEGER,
	HOME_BB_CT INTEGER,
	HOME_IBB_CT INTEGER,
	HOME_SO_CT INTEGER,
	HOME_SB_CT INTEGER,
	HOME_CS_CT INTEGER,
	HOME_GIDP_CT INTEGER,
	HOME_CACTHER_INTER_CT INTEGER,
	HOME_LOB_CT INTEGER,
	HOME_PITCHERS_USED_CT INTEGER,
	HOME_IND_ERR_CT INTEGER,
	HOME_TEAM_ERR_CT INTEGER,
	HOME_WP_CT INTEGER,
	HOME_BALKS_CT INTEGER,
	HOME_PO_CT INTEGER,
	HOME_A_CT INTEGER,
	HOME_E_CT INTEGER,
	HOME_PB_CT INTEGER,
	HOME_DP_CT INTEGER,
	HOME_TP_CT INTEGER,
	HOMEPLATE_UMP_ID VARCHAR(8),
	HOMEPLATE_UMP_NAME_TX VARCHAR(50),
	FIRSTBASE_UMP_ID VARCHAR(8),
	FIRSTBASE_UMP_NAME_TX VARCHAR(50),
	SECONDBASE_UMP_ID VARCHAR(8),
	SECONDBAES_UMP_NAME_TX VARCHAR(50),
	THIRDBASE_UMP_ID VARCHAR(8),
	THIRDBASE_UMP_NAME_TX VARCHAR(50),
	LF_UMP_ID VARCHAR(8),
	LF_UMP_NAME_TX VARCHAR(50),
	RF_UMP_ID VARCHAR(8),
	RF_UMP_NAME_TX VARCHAR(50),
	AWAY_TEAM_MANAGER_ID VARCHAR(8),
	AWAY_TEAM_MANAGER_NAME_TX VARCHAR(50),
	HOME_TEAM_MANAGER_ID VARCHAR(8),
	HOME_TEAM_MANAGER_NAME_TX VARCHAR(50),
	WINNING_PITCHER_ID VARCHAR(8),
	WINNING_PITCHER_NAME_TX VARCHAR(50),
	LOSING_PITCHER_ID VARCHAR(8),
	LOSING_PITCHER_NAME_TX VARCHAR(50),
	SAVING_PITCHER_ID VARCHAR(8),
	SAVING_PITCHER_NAME_TX VARCHAR(50),
	GWRBI_BATTER_ID VARCHAR(8),
	GWRBI_BATTER_NAME_TX VARCHAR(50),
	AWAY_STARTING_PITCHER_ID VARCHAR(8),
	AWAY_STARTING_PITCHER_NAME_TX VARCHAR(50),
	HOME_STARTING_PITCHER_ID_TX VARCHAR(8),
	HOME_STARTING_PITCHER_NAME_TX VARCHAR(50),
	AWAY_BAT1_PLAYER_ID VARCHAR(8),
	AWAY_BAT1_PLAYER_NAME_TX VARCHAR(50),
	AWAY_BAT1_FLD_ID INTEGER,
	AWAY_BAT2_PLAYER_ID VARCHAR(8),
	AWAY_BAT2_PLAYER_NAME_TX VARCHAR(50),
	AWAY_BAT2_FLD_ID INTEGER,
	AWAY_BAT3_PLAYER_ID VARCHAR(8),
	AWAY_BAT3_PLAYER_NAME_TX VARCHAR(50),
	AWAY_BAT3_FLD_ID INTEGER,
	AWAY_BAT4_PLAYER_ID VARCHAR(8),
	AWAY_BAT4_PLAYER_NAME_TX VARCHAR(50),
	AWAY_BAT4_FLD_ID INTEGER,
	AWAY_BAT5_PLAYER_ID VARCHAR(8),
	AWAY_BAT5_PLAYER_NAME_TX VARCHAR(50),
	AWAY_BAT5_FLD_ID INTEGER,
	AWAY_BAT6_PLAYER_ID VARCHAR(8),
	AWAY_BAT6_PLAYER_NAME_TX VARCHAR(50),
	AWAY_BAT6_FLD_ID INTEGER,
	AWAY_BAT7_PLAYER_ID VARCHAR(8),
	AWAY_BAT7_PLAYER_NAME_TX VARCHAR(50),
	AWAY_BAT7_FLD_ID INTEGER,
	AWAY_BAT8_PLAYER_ID VARCHAR(8),
	AWAY_BAT8_PLAYER_NAME_TX VARCHAR(50),
	AWAY_BAT8_FLD_ID INTEGER,
	AWAY_BAT9_PLAYER_ID VARCHAR(8),
	AWAY_BAT9_PLAYER_NAME_TX VARCHAR(50),
	AWAY_BAT9_FLD_ID INTEGER,
	HOME_BAT1_PLAYER_ID VARCHAR(8),
	HOME_BAT1_PLAYER_NAME_TX VARCHAR(50),
	HOME_BAT1_FLD_ID INTEGER,
	HOME_BAT2_PLAYER_ID VARCHAR(8),
	HOME_BAT2_PLAYER_NAME_TX VARCHAR(50),
	HOME_BAT2_FLD_ID INTEGER,
	HOME_BAT3_PLAYER_ID VARCHAR(8),
	HOME_BAT3_PLAYER_NAME_TX VARCHAR(50),
	HOME_BAT3_FLD_ID INTEGER,
	HOME_BAT4_PLAYER_ID VARCHAR(8),
	HOME_BAT4_PLAYER_NAME_TX VARCHAR(50),
	HOME_BAT4_FLD_ID INTEGER,
	HOME_BAT5_PLAYER_ID VARCHAR(8),
	HOME_BAT5_PLAYER_NAME_TX VARCHAR(50),
	HOME_BAT5_FLD_ID INTEGER,
	HOME_BAT6_PLAYER_ID VARCHAR(8),
	HOME_BAT6_PLAYER_NAME_TX VARCHAR(50),
	HOME_BAT6_FLD_ID INTEGER,
	HOME_BAT7_PLAYER_ID VARCHAR(8),
	HOME_BAT7_PLAYER_NAME_TX VARCHAR(50),
	HOME_BAT7_FLD_ID INTEGER,
	HOME_BAT8_PLAYER_ID VARCHAR(8),
	HOME_BAT8_PLAYER_NAME_TX VARCHAR(50),
	HOME_BAT8_FLD_ID INTEGER,
	HOME_BAT9_PLAYER_ID VARCHAR(8),
	HOME_BAT9_PLAYER_NAME_TX VARCHAR(50),
	HOME_BAT9_FLD_ID INTEGER,
        ADD_INFO_TX VARCHAR(255),
        ACQ_INFO_TX VARCHAR(10)
)
;