DROP TABLE IF EXISTS gamelog
;
CREATE TABLE gamelog 
(
	date INTEGER,
	game_num_ct INTEGER,
	dow VARCHAR(3),
	v_team_id VARCHAR(3),
	v_team_lg_id VARCHAR(2),
	v_team_game_number_ct INTEGER,
	h_team_id VARCHAR(3),
	h_team_lg_id VARCHAR(2),
	h_team_game_number_ct INTEGER,
	v_score_ct INTEGER,
	h_score_ct INTEGER,
	outs_ct INTEGER,
	day_night_fl VARCHAR(1),
	comp_info_tx varchar(100),
	forfiet_fl VARCHAR(5),
	protest_fl VARCHAR(2),
	park_id_fl VARCHAR(5),
	attendance_ct VARCHAR(6),
	game_minutes_ct INTEGER,
	v_linescore_tx VARCHAR(25),
	h_linescore_xt VARCHAR(25),
	v_ab_ct INTEGER,
	v_h_ct INTEGER,
	v_d_ct INTEGER,
	v_t_ct integer,
	v_hr_ct INTEGER,
	v_rbi_ct integer,
	v_sh_ct INTEGER,
	v_sf_ct integer,
	v_hbp_ct INTEGER,
	v_bb_ct INTEGER,
	v_ibb_ct integer,
	v_so_ct INTEGER,
	v_sb_ct INTEGER,
	v_cs_ct integer,
	v_gidp_ct integer,
	v_catcher_inter_ct integer,
	v_lob_ct INTEGER,
	v_pitchers_used_ct INTEGER,
	v_ind_err_ct integer,
	v_team_err_ct integer,
	v_wp_ct INTEGER,
	v_balks_ct INTEGER,
	v_po_ct INTEGER,
	v_a_ct INTEGER,
	v_e_ct INTEGER,
	v_pb_ct INTEGER,
	v_dp_ct INTEGER,
	v_tp_ct INTEGER,
	h_ab_ct INTEGER,
	h_h_ct INTEGER,
	h_d_ct INTEGER,
	h_t_ct INTEGER,
	h_hr_ct INTEGER,
	h_rbi_ct integer,
	h_sh_ct INTEGER,
	h_sf_ct integer,
	h_hbp_ct INTEGER,
	h_bb_ct INTEGER,
	h_ibb_ct integer,
	h_so_ct INTEGER,
	h_sb_ct INTEGER,
	h_cs_ct integer,
	h_gidp_ct integer,
	h_cacther_inter_ct integer,
	h_lob_ct INTEGER,
	h_pitchers_used_ct INTEGER,
	h_ind_err_ct integer,
	h_team_err_ct integer,
	h_wp_ct INTEGER,
	h_balks_ct INTEGER,
	h_po_ct INTEGER,
	h_a_ct INTEGER,
	h_e_ct INTEGER,
	h_pb_ct INTEGER,
	h_dp_ct INTEGER,
	h_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),
	v_team_manager_id VARCHAR(8),
	v_team_manager_name_tx VARCHAR(50),
	h_team_manager_id VARCHAR(8),
	h_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),
	v_starting_pitcher_id VARCHAR(8),
	v_starting_pitcher_name_tx VARCHAR(50),
	h_starting_pitcher_id_tx VARCHAR(8),
	h_starting_pitcher_name_tx VARCHAR(50),
	v_bat1_player_id varchar(8),
	v_bat1_player_name_tx varchar(50),
	v_bat1_fld_id integer,
	v_bat2_player_id varchar(8),
	v_bat2_player_name_tx varchar(50),
	v_bat2_fld_id integer,
	v_bat3_player_id varchar(8),
	v_bat3_player_name_tx varchar(50),
	v_bat3_fld_id integer,
	v_bat4_player_id varchar(8),
	v_bat4_player_name_tx varchar(50),
	v_bat4_fld_id integer,
	v_bat5_player_id varchar(8),
	v_bat5_player_name_tx varchar(50),
	v_bat5_fld_id integer,
	v_bat6_player_id varchar(8),
	v_bat6_player_name_tx varchar(50),
	v_bat6_fld_id integer,
	v_bat7_player_id varchar(8),
	v_bat7_player_name_tx varchar(50),
	v_bat7_fld_id integer,
	v_bat8_player_id varchar(8),
	v_bat8_player_name_tx varchar(50),
	v_bat8_fld_id integer,
	v_bat9_player_id varchar(8),
	v_bat9_player_name_tx varchar(50),
	v_bat9_fld_id integer,
	h_bat1_player_id varchar(8),
	h_bat1_player_name_tx varchar(50),
	h_bat1_fld_id integer,
	h_bat2_player_id varchar(8),
	h_bat2_player_name_tx varchar(50),
	h_bat2_fld_id integer,
	h_bat3_player_id varchar(8),
	h_bat3_player_name_tx varchar(50),
	h_bat3_fld_id integer,
	h_bat4_player_id varchar(8),
	h_bat4_player_name_tx varchar(50),
	h_bat4_fld_id integer,
	h_bat5_player_id varchar(8),
	h_bat5_player_name_tx varchar(50),
	h_bat5_fld_id integer,
	h_bat6_player_id varchar(8),
	h_bat6_player_name_tx varchar(50),
	h_bat6_fld_id integer,
	h_bat7_player_id varchar(8),
	h_bat7_player_name_tx varchar(50),
	h_bat7_fld_id integer,
	h_bat8_player_id varchar(8),
	h_bat8_player_name_tx varchar(50),
	h_bat8_fld_id integer,
	h_bat9_player_id varchar(8),
	h_bat9_player_name_tx varchar(50),
	h_bat9_fld_id integer,
        add_info_tx varchar(255),
        acq_info_tx varchar(10)
)
;