Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
CREATE TABLE `s_retrosheet_games` (
`GAME_ID` TEXT,
`GAME_DT` BIGINT DEFAULT NULL,
`GAME_CT` BIGINT DEFAULT NULL,
`GAME_DY` TEXT,
`START_GAME_TM` BIGINT DEFAULT NULL,
`DH_FL` TEXT,
`DAYNIGHT_PARK_CD` TEXT,
`AWAY_TEAM_ID` TEXT,
`HOME_TEAM_ID` TEXT,
`PARK_ID` TEXT,
`AWAY_START_PIT_ID` TEXT,
`HOME_START_PIT_ID` TEXT,
`BASE4_UMP_ID` TEXT,
`BASE1_UMP_ID` TEXT,
`BASE2_UMP_ID` TEXT,
`BASE3_UMP_ID` TEXT,
`LF_UMP_ID` TEXT,
`RF_UMP_ID` TEXT,
`ATTEND_PARK_CT` BIGINT DEFAULT NULL,
`SCORER_RECORD_ID` TEXT,
`TRANSLATOR_RECORD_ID` TEXT,
`INPUTTER_RECORD_ID` TEXT,
`INPUT_RECORD_TS` TEXT,
`EDIT_RECORD_TS` DOUBLE DEFAULT NULL,
`METHOD_RECORD_CD` BIGINT DEFAULT NULL,
`PITCHES_RECORD_CD` BIGINT DEFAULT NULL,
`TEMP_PARK_CT` BIGINT DEFAULT NULL,
`WIND_DIRECTION_PARK_CD` BIGINT DEFAULT NULL,
`WIND_SPEED_PARK_CT` BIGINT DEFAULT NULL,
`FIELD_PARK_CD` BIGINT DEFAULT NULL,
`PRECIP_PARK_CD` BIGINT DEFAULT NULL,
`SKY_PARK_CD` BIGINT DEFAULT NULL,
`MINUTES_GAME_CT` BIGINT DEFAULT NULL,
`INN_CT` BIGINT DEFAULT NULL,
`AWAY_SCORE_CT` BIGINT DEFAULT NULL,
`HOME_SCORE_CT` BIGINT DEFAULT NULL,
`AWAY_HITS_CT` BIGINT DEFAULT NULL,
`HOME_HITS_CT` BIGINT DEFAULT NULL,
`AWAY_ERR_CT` BIGINT DEFAULT NULL,
`HOME_ERR_CT` BIGINT DEFAULT NULL,
`AWAY_LOB_CT` BIGINT DEFAULT NULL,
`HOME_LOB_CT` BIGINT DEFAULT NULL,
`WIN_PIT_ID` TEXT,
`LOSE_PIT_ID` TEXT,
`SAVE_PIT_ID` TEXT,
`GWRBI_BAT_ID` TEXT,
`AWAY_LINEUP1_BAT_ID` TEXT,
`AWAY_LINEUP1_FLD_CD` BIGINT DEFAULT NULL,
`AWAY_LINEUP2_BAT_ID` TEXT,
`AWAY_LINEUP2_FLD_CD` BIGINT DEFAULT NULL,
`AWAY_LINEUP3_BAT_ID` TEXT,
`AWAY_LINEUP3_FLD_CD` BIGINT DEFAULT NULL,
`AWAY_LINEUP4_BAT_ID` TEXT,
`AWAY_LINEUP4_FLD_CD` BIGINT DEFAULT NULL,
`AWAY_LINEUP5_BAT_ID` TEXT,
`AWAY_LINEUP5_FLD_CD` BIGINT DEFAULT NULL,
`AWAY_LINEUP6_BAT_ID` TEXT,
`AWAY_LINEUP6_FLD_CD` BIGINT DEFAULT NULL,
`AWAY_LINEUP7_BAT_ID` TEXT,
`AWAY_LINEUP7_FLD_CD` BIGINT DEFAULT NULL,
`AWAY_LINEUP8_BAT_ID` TEXT,
`AWAY_LINEUP8_FLD_CD` BIGINT DEFAULT NULL,
`AWAY_LINEUP9_BAT_ID` TEXT,
`AWAY_LINEUP9_FLD_CD` BIGINT DEFAULT NULL,
`HOME_LINEUP1_BAT_ID` TEXT,
`HOME_LINEUP1_FLD_CD` BIGINT DEFAULT NULL,
`HOME_LINEUP2_BAT_ID` TEXT,
`HOME_LINEUP2_FLD_CD` BIGINT DEFAULT NULL,
`HOME_LINEUP3_BAT_ID` TEXT,
`HOME_LINEUP3_FLD_CD` BIGINT DEFAULT NULL,
`HOME_LINEUP4_BAT_ID` TEXT,
`HOME_LINEUP4_FLD_CD` BIGINT DEFAULT NULL,
`HOME_LINEUP5_BAT_ID` TEXT,
`HOME_LINEUP5_FLD_CD` BIGINT DEFAULT NULL,
`HOME_LINEUP6_BAT_ID` TEXT,
`HOME_LINEUP6_FLD_CD` BIGINT DEFAULT NULL,
`HOME_LINEUP7_BAT_ID` TEXT,
`HOME_LINEUP7_FLD_CD` BIGINT DEFAULT NULL,
`HOME_LINEUP8_BAT_ID` TEXT,
`HOME_LINEUP8_FLD_CD` BIGINT DEFAULT NULL,
`HOME_LINEUP9_BAT_ID` TEXT,
`HOME_LINEUP9_FLD_CD` BIGINT DEFAULT NULL,
`AWAY_FINISH_PIT_ID` TEXT,
`HOME_FINISH_PIT_ID` TEXT,
`AWAY_TEAM_LEAGUE_ID` TEXT,
`HOME_TEAM_LEAGUE_ID` TEXT,
`AWAY_TEAM_GAME_CT` DOUBLE DEFAULT NULL,
`HOME_TEAM_GAME_CT` DOUBLE DEFAULT NULL,
`OUTS_CT` BIGINT DEFAULT NULL,
`COMPLETION_TX` DOUBLE DEFAULT NULL,
`FORFEIT_TX` DOUBLE DEFAULT NULL,
`PROTEST_TX` DOUBLE DEFAULT NULL,
`AWAY_LINE_TX` TEXT,
`HOME_LINE_TX` TEXT,
`AWAY_AB_CT` BIGINT DEFAULT NULL,
`AWAY_2B_CT` BIGINT DEFAULT NULL,
`AWAY_3B_CT` BIGINT DEFAULT NULL,
`AWAY_HR_CT` BIGINT DEFAULT NULL,
`AWAY_BI_CT` BIGINT DEFAULT NULL,
`AWAY_SH_CT` BIGINT DEFAULT NULL,
`AWAY_SF_CT` BIGINT DEFAULT NULL,
`AWAY_HP_CT` BIGINT DEFAULT NULL,
`AWAY_BB_CT` BIGINT DEFAULT NULL,
`AWAY_IBB_CT` BIGINT DEFAULT NULL,
`AWAY_SO_CT` BIGINT DEFAULT NULL,
`AWAY_SB_CT` BIGINT DEFAULT NULL,
`AWAY_CS_CT` BIGINT DEFAULT NULL,
`AWAY_GDP_CT` BIGINT DEFAULT NULL,
`AWAY_XI_CT` BIGINT DEFAULT NULL,
`AWAY_PITCHER_CT` BIGINT DEFAULT NULL,
`AWAY_ER_CT` BIGINT DEFAULT NULL,
`AWAY_TER_CT` BIGINT DEFAULT NULL,
`AWAY_WP_CT` BIGINT DEFAULT NULL,
`AWAY_BK_CT` BIGINT DEFAULT NULL,
`AWAY_PO_CT` BIGINT DEFAULT NULL,
`AWAY_A_CT` BIGINT DEFAULT NULL,
`AWAY_PB_CT` BIGINT DEFAULT NULL,
`AWAY_DP_CT` BIGINT DEFAULT NULL,
`AWAY_TP_CT` BIGINT DEFAULT NULL,
`HOME_AB_CT` BIGINT DEFAULT NULL,
`HOME_2B_CT` BIGINT DEFAULT NULL,
`HOME_3B_CT` BIGINT DEFAULT NULL,
`HOME_HR_CT` BIGINT DEFAULT NULL,
`HOME_BI_CT` BIGINT DEFAULT NULL,
`HOME_SH_CT` BIGINT DEFAULT NULL,
`HOME_SF_CT` BIGINT DEFAULT NULL,
`HOME_HP_CT` BIGINT DEFAULT NULL,
`HOME_BB_CT` BIGINT DEFAULT NULL,
`HOME_IBB_CT` BIGINT DEFAULT NULL,
`HOME_SO_CT` BIGINT DEFAULT NULL,
`HOME_SB_CT` BIGINT DEFAULT NULL,
`HOME_CS_CT` BIGINT DEFAULT NULL,
`HOME_GDP_CT` BIGINT DEFAULT NULL,
`HOME_XI_CT` BIGINT DEFAULT NULL,
`HOME_PITCHER_CT` BIGINT DEFAULT NULL,
`HOME_ER_CT` BIGINT DEFAULT NULL,
`HOME_TER_CT` BIGINT DEFAULT NULL,
`HOME_WP_CT` BIGINT DEFAULT NULL,
`HOME_BK_CT` BIGINT DEFAULT NULL,
`HOME_PO_CT` BIGINT DEFAULT NULL,
`HOME_A_CT` BIGINT DEFAULT NULL,
`HOME_PB_CT` BIGINT DEFAULT NULL,
`HOME_DP_CT` BIGINT DEFAULT NULL,
`HOME_TP_CT` BIGINT DEFAULT NULL,
`UMP_HOME_NAME_TX` DOUBLE DEFAULT NULL,
`UMP_1B_NAME_TX` DOUBLE DEFAULT NULL,
`UMP_2B_NAME_TX` DOUBLE DEFAULT NULL,
`UMP_3B_NAME_TX` DOUBLE DEFAULT NULL,
`UMP_LF_NAME_TX` DOUBLE DEFAULT NULL,
`UMP_RF_NAME_TX` DOUBLE DEFAULT NULL,
`AWAY_MANAGER_ID` DOUBLE DEFAULT NULL,
`AWAY_MANAGER_NAME_TX` DOUBLE DEFAULT NULL,
`HOME_MANAGER_ID` DOUBLE DEFAULT NULL,
`HOME_MANAGER_NAME_TX` DOUBLE DEFAULT NULL,
`WIN_PIT_NAME_TX` TEXT,
`LOSE_PIT_NAME_TX` TEXT,
`SAVE_PIT_NAME_TX` TEXT,
`GOAHEAD_RBI_ID` TEXT,
`GOAHEAD_RBI_NAME_TX` TEXT,
`AWAY_LINEUP1_BAT_NAME_TX` TEXT,
`AWAY_LINEUP2_BAT_NAME_TX` TEXT,
`AWAY_LINEUP3_BAT_NAME_TX` TEXT,
`AWAY_LINEUP4_BAT_NAME_TX` TEXT,
`AWAY_LINEUP5_BAT_NAME_TX` TEXT,
`AWAY_LINEUP6_BAT_NAME_TX` TEXT,
`AWAY_LINEUP7_BAT_NAME_TX` TEXT,
`AWAY_LINEUP8_BAT_NAME_TX` TEXT,
`AWAY_LINEUP9_BAT_NAME_TX` TEXT,
`HOME_LINEUP1_BAT_NAME_TX` TEXT,
`HOME_LINEUP2_BAT_NAME_TX` TEXT,
`HOME_LINEUP3_BAT_NAME_TX` TEXT,
`HOME_LINEUP4_BAT_NAME_TX` TEXT,
`HOME_LINEUP5_BAT_NAME_TX` TEXT,
`HOME_LINEUP6_BAT_NAME_TX` TEXT,
`HOME_LINEUP7_BAT_NAME_TX` TEXT,
`HOME_LINEUP8_BAT_NAME_TX` TEXT,
`HOME_LINEUP9_BAT_NAME_TX` TEXT,
`ADD_INFO_TX` TEXT,
`ACQ_INFO_TX` DOUBLE DEFAULT NULL
) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci;
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.