历年足球数据下载

🚀 历年足球数据下载

之前自己也是苦苦寻找数据无路,对其间的痛处很是了解..
所以现在把数据提供出来,提供给需要的小伙伴.

🌰 参考项目地址

https://blog.csdn.net/ve__locity/article/details/105450124

##$ 😎 Mysql 表说明

表名表说明
t_asia_track亚赔变化表
t_asia_his亚赔历史表(只有各家初即数据)
t_asia_last亚赔临时表
t_euro_track欧赔变化表
t_euro_his欧赔历史表(只有各家初即数据)
t_euro_last欧赔临时表
t_over_under_track大小赔变化表
t_over_under_his大小赔历史表(只有各家初即数据)
t_over_under_last大小赔临时表
t_league联赛表
t_league_season联赛赛季表
t_league_sub联赛次级表
t_match_his比赛数据表
t_match_last比赛临时表
t_b_f_score积分榜数据表
t_b_f_jin近期战绩表
t_b_f_battle主客队对战历史表
t_b_f_future_event未来赛事表
t_comp波菜公司表

😎 新版本

属性项说明
数据年份2019-2020.:
数据库类型mysql
数据格式sql文件
数据量级百万级
数据完善程度接近完整
sql中是否带索引生成
1.这里sql文件中未提供生成索引的部分.
2.是为了大家能快速的将数据导进Mysql数据库中.
(旧版本中sql文件,带生成索引,整个导入过程是很漫长的)
3.导入完sql文件后,再手动执行以下的 "附 索引生成sql"
  • 附 索引生成sql
ALTER TABLE `t_analy_result` ADD INDEX `IDX_t_analy_result_AlFlag` USING BTREE(`AlFlag`);
ALTER TABLE `t_analy_result` ADD INDEX `IDX_t_analy_result_AlSeq` USING BTREE(`AlSeq`);
ALTER TABLE `t_analy_result` ADD INDEX `IDX_t_analy_result_CreateTime` USING BTREE(`CreateTime`);
ALTER TABLE `t_analy_result` ADD INDEX `IDX_t_analy_result_CreateUser` USING BTREE(`CreateUser`);
ALTER TABLE `t_analy_result` ADD INDEX `IDX_t_analy_result_Desc` USING BTREE(`Desc`);
ALTER TABLE `t_analy_result` ADD INDEX `IDX_t_analy_result_HitCount` USING BTREE(`HitCount`);
ALTER TABLE `t_analy_result` ADD INDEX `IDX_t_analy_result_LetBall` USING BTREE(`LetBall`);
ALTER TABLE `t_analy_result` ADD INDEX `IDX_t_analy_result_MatchDate` USING BTREE(`MatchDate`);
ALTER TABLE `t_analy_result` ADD INDEX `IDX_t_analy_result_MatchId` USING BTREE(`MatchId`);
ALTER TABLE `t_analy_result` ADD INDEX `IDX_t_analy_result_ModifyTime` USING BTREE(`ModifyTime`);
ALTER TABLE `t_analy_result` ADD INDEX `IDX_t_analy_result_ModifyUser` USING BTREE(`ModifyUser`);
ALTER TABLE `t_analy_result` ADD INDEX `IDX_t_analy_result_MyLetBall` USING BTREE(`MyLetBall`);
ALTER TABLE `t_analy_result` ADD INDEX `IDX_t_analy_result_PreResult` USING BTREE(`PreResult`);
ALTER TABLE `t_analy_result` ADD INDEX `IDX_t_analy_result_Result` USING BTREE(`Result`);
ALTER TABLE `t_analy_result` ADD INDEX `IDX_t_analy_result_SLetBall` USING BTREE(`SLetBall`);
ALTER TABLE `t_analy_result` ADD INDEX `IDX_t_analy_result_THitCount` USING BTREE(`THitCount`);
ALTER TABLE `t_analy_result` ADD INDEX `IDX_t_analy_result_TOVoid` USING BTREE(`TOVoid`);
ALTER TABLE `t_analy_result` ADD INDEX `IDX_t_analy_result_TOVoidDesc` USING BTREE(`TOVoidDesc`);
ALTER TABLE `t_analy_result` ADD PRIMARY KEY USING BTREE(`Id`);
ALTER TABLE `t_asia_his` ADD INDEX `IDX_t_asia_his_CompName` USING BTREE(`CompName`);
ALTER TABLE `t_asia_his` ADD INDEX `IDX_t_asia_his_CreateTime` USING BTREE(`CreateTime`);
ALTER TABLE `t_asia_his` ADD INDEX `IDX_t_asia_his_CreateUser` USING BTREE(`CreateUser`);
ALTER TABLE `t_asia_his` ADD INDEX `IDX_t_asia_his_Ep0` USING BTREE(`Ep0`);
ALTER TABLE `t_asia_his` ADD INDEX `IDX_t_asia_his_Ep3` USING BTREE(`Ep3`);
ALTER TABLE `t_asia_his` ADD INDEX `IDX_t_asia_his_EPanKou` USING BTREE(`EPanKou`);
ALTER TABLE `t_asia_his` ADD INDEX `IDX_t_asia_his_ModifyTime` USING BTREE(`ModifyTime`);
ALTER TABLE `t_asia_his` ADD INDEX `IDX_t_asia_his_ModifyUser` USING BTREE(`ModifyUser`);
ALTER TABLE `t_asia_his` ADD INDEX `IDX_t_asia_his_OddDate` USING BTREE(`OddDate`);
ALTER TABLE `t_asia_his` ADD INDEX `IDX_t_asia_his_Sp0` USING BTREE(`Sp0`);
ALTER TABLE `t_asia_his` ADD INDEX `IDX_t_asia_his_Sp3` USING BTREE(`Sp3`);
ALTER TABLE `t_asia_his` ADD INDEX `IDX_t_asia_his_SPanKou` USING BTREE(`SPanKou`);
ALTER TABLE `t_asia_his` ADD PRIMARY KEY USING BTREE(`Id`);
ALTER TABLE `t_asia_his` ADD UNIQUE INDEX `UQE_t_asia_his_CompId_MatchId` USING BTREE(`CompId`, `MatchId`);
ALTER TABLE `t_asia_last` ADD INDEX `IDX_t_asia_last_CompName` USING BTREE(`CompName`);
ALTER TABLE `t_asia_last` ADD INDEX `IDX_t_asia_last_CreateTime` USING BTREE(`CreateTime`);
ALTER TABLE `t_asia_last` ADD INDEX `IDX_t_asia_last_CreateUser` USING BTREE(`CreateUser`);
ALTER TABLE `t_asia_last` ADD INDEX `IDX_t_asia_last_Ep0` USING BTREE(`Ep0`);
ALTER TABLE `t_asia_last` ADD INDEX `IDX_t_asia_last_Ep3` USING BTREE(`Ep3`);
ALTER TABLE `t_asia_last` ADD INDEX `IDX_t_asia_last_EPanKou` USING BTREE(`EPanKou`);
ALTER TABLE `t_asia_last` ADD INDEX `IDX_t_asia_last_ModifyTime` USING BTREE(`ModifyTime`);
ALTER TABLE `t_asia_last` ADD INDEX `IDX_t_asia_last_ModifyUser` USING BTREE(`ModifyUser`);
ALTER TABLE `t_asia_last` ADD INDEX `IDX_t_asia_last_OddDate` USING BTREE(`OddDate`);
ALTER TABLE `t_asia_last` ADD INDEX `IDX_t_asia_last_Sp0` USING BTREE(`Sp0`);
ALTER TABLE `t_asia_last` ADD INDEX `IDX_t_asia_last_Sp3` USING BTREE(`Sp3`);
ALTER TABLE `t_asia_last` ADD INDEX `IDX_t_asia_last_SPanKou` USING BTREE(`SPanKou`);
ALTER TABLE `t_asia_last` ADD PRIMARY KEY USING BTREE(`Id`);
ALTER TABLE `t_asia_last` ADD UNIQUE INDEX `UQE_t_asia_last_CompId_MatchId` USING BTREE(`CompId`, `MatchId`);
ALTER TABLE `t_asia_track` ADD INDEX `IDX_t_asia_track_CreateTime` USING BTREE(`CreateTime`);
ALTER TABLE `t_asia_track` ADD INDEX `IDX_t_asia_track_CreateUser` USING BTREE(`CreateUser`);
ALTER TABLE `t_asia_track` ADD INDEX `IDX_t_asia_track_ModifyTime` USING BTREE(`ModifyTime`);
ALTER TABLE `t_asia_track` ADD INDEX `IDX_t_asia_track_ModifyUser` USING BTREE(`ModifyUser`);
ALTER TABLE `t_asia_track` ADD INDEX `IDX_t_asia_track_SPanKou` USING BTREE(`SPanKou`);
ALTER TABLE `t_asia_track` ADD PRIMARY KEY USING BTREE(`Id`);
ALTER TABLE `t_asia_track` ADD UNIQUE INDEX `UQE_t_asia_track_CompId_MatchId_OddDate_Num` USING BTREE(`CompId`, `MatchId`, `OddDate`, `Num`);
ALTER TABLE `t_b_f_battle` ADD INDEX `IDX_t_b_f_battle_CreateTime` USING BTREE(`CreateTime`);
ALTER TABLE `t_b_f_battle` ADD INDEX `IDX_t_b_f_battle_CreateUser` USING BTREE(`CreateUser`);
ALTER TABLE `t_b_f_battle` ADD INDEX `IDX_t_b_f_battle_GuestTeamGoal` USING BTREE(`GuestTeamGoal`);
ALTER TABLE `t_b_f_battle` ADD INDEX `IDX_t_b_f_battle_GuestTeamHalfGoal` USING BTREE(`GuestTeamHalfGoal`);
ALTER TABLE `t_b_f_battle` ADD INDEX `IDX_t_b_f_battle_GuestTeamId` USING BTREE(`GuestTeamId`);
ALTER TABLE `t_b_f_battle` ADD INDEX `IDX_t_b_f_battle_LeagueId` USING BTREE(`LeagueId`);
ALTER TABLE `t_b_f_battle` ADD INDEX `IDX_t_b_f_battle_MainTeamGoal` USING BTREE(`MainTeamGoal`);
ALTER TABLE `t_b_f_battle` ADD INDEX `IDX_t_b_f_battle_MainTeamHalfGoal` USING BTREE(`MainTeamHalfGoal`);
ALTER TABLE `t_b_f_battle` ADD INDEX `IDX_t_b_f_battle_MainTeamId` USING BTREE(`MainTeamId`);
ALTER TABLE `t_b_f_battle` ADD INDEX `IDX_t_b_f_battle_ModifyTime` USING BTREE(`ModifyTime`);
ALTER TABLE `t_b_f_battle` ADD INDEX `IDX_t_b_f_battle_ModifyUser` USING BTREE(`ModifyUser`);
ALTER TABLE `t_b_f_battle` ADD PRIMARY KEY USING BTREE(`Id`);
ALTER TABLE `t_b_f_battle` ADD UNIQUE INDEX `UQE_t_b_f_battle_CurMatchId_MatchId` USING BTREE(`CurMatchId`, `MatchId`);
ALTER TABLE `t_b_f_battle` ADD UNIQUE INDEX `UQE_t_b_f_battle_CurMatchId_MMG` USING BTREE(`CurMatchId`, `MatchDate`, `MainTeam`, `GuestTeam`);
ALTER TABLE `t_b_f_future_event` ADD INDEX `IDX_t_b_f_future_event_CreateTime` USING BTREE(`CreateTime`);
ALTER TABLE `t_b_f_future_event` ADD INDEX `IDX_t_b_f_future_event_CreateUser` USING BTREE(`CreateUser`);
ALTER TABLE `t_b_f_future_event` ADD INDEX `IDX_t_b_f_future_event_GuestTeamId` USING BTREE(`GuestTeamId`);
ALTER TABLE `t_b_f_future_event` ADD INDEX `IDX_t_b_f_future_event_IntervalDay` USING BTREE(`IntervalDay`);
ALTER TABLE `t_b_f_future_event` ADD INDEX `IDX_t_b_f_future_event_LeagueId` USING BTREE(`LeagueId`);
ALTER TABLE `t_b_f_future_event` ADD INDEX `IDX_t_b_f_future_event_LeagueName` USING BTREE(`LeagueName`);
ALTER TABLE `t_b_f_future_event` ADD INDEX `IDX_t_b_f_future_event_MainTeamId` USING BTREE(`MainTeamId`);
ALTER TABLE `t_b_f_future_event` ADD INDEX `IDX_t_b_f_future_event_ModifyTime` USING BTREE(`ModifyTime`);
ALTER TABLE `t_b_f_future_event` ADD INDEX `IDX_t_b_f_future_event_ModifyUser` USING BTREE(`ModifyUser`);
ALTER TABLE `t_b_f_future_event` ADD INDEX `IDX_t_b_f_future_event_OwnerTeamId` USING BTREE(`OwnerTeamId`);
ALTER TABLE `t_b_f_future_event` ADD PRIMARY KEY USING BTREE(`Id`);
ALTER TABLE `t_b_f_future_event` ADD UNIQUE INDEX `UQE_t_b_f_future_event_CurMatchId_MatchId_OwnerTeam` USING BTREE(`CurMatchId`, `OwnerTeam`, `MatchId`);
ALTER TABLE `t_b_f_future_event` ADD UNIQUE INDEX `UQE_t_b_f_future_event_CurMatchId_OMMG` USING BTREE(`CurMatchId`, `OwnerTeam`, `MatchDate`, `MainTeam`, `GuestTeam`);
ALTER TABLE `t_b_f_jin` ADD INDEX `IDX_t_b_f_jin_CreateTime` USING BTREE(`CreateTime`);
ALTER TABLE `t_b_f_jin` ADD INDEX `IDX_t_b_f_jin_CreateUser` USING BTREE(`CreateUser`);
ALTER TABLE `t_b_f_jin` ADD INDEX `IDX_t_b_f_jin_FirstLetgoalHalf` USING BTREE(`FirstLetgoalHalf`);
ALTER TABLE `t_b_f_jin` ADD INDEX `IDX_t_b_f_jin_FirstOU` USING BTREE(`FirstOU`);
ALTER TABLE `t_b_f_jin` ADD INDEX `IDX_t_b_f_jin_FirstOUHalf` USING BTREE(`FirstOUHalf`);
ALTER TABLE `t_b_f_jin` ADD INDEX `IDX_t_b_f_jin_GuestHalfScore` USING BTREE(`GuestHalfScore`);
ALTER TABLE `t_b_f_jin` ADD INDEX `IDX_t_b_f_jin_GuestScore` USING BTREE(`GuestScore`);
ALTER TABLE `t_b_f_jin` ADD INDEX `IDX_t_b_f_jin_GuestTeamID` USING BTREE(`GuestTeamID`);
ALTER TABLE `t_b_f_jin` ADD INDEX `IDX_t_b_f_jin_HomeHalfScore` USING BTREE(`HomeHalfScore`);
ALTER TABLE `t_b_f_jin` ADD INDEX `IDX_t_b_f_jin_HomeScore` USING BTREE(`HomeScore`);
ALTER TABLE `t_b_f_jin` ADD INDEX `IDX_t_b_f_jin_HomeTeamID` USING BTREE(`HomeTeamID`);
ALTER TABLE `t_b_f_jin` ADD INDEX `IDX_t_b_f_jin_IsN` USING BTREE(`IsN`);
ALTER TABLE `t_b_f_jin` ADD INDEX `IDX_t_b_f_jin_LeagueId` USING BTREE(`LeagueId`);
ALTER TABLE `t_b_f_jin` ADD INDEX `IDX_t_b_f_jin_LeagueName` USING BTREE(`LeagueName`);
ALTER TABLE `t_b_f_jin` ADD INDEX `IDX_t_b_f_jin_Letgoal` USING BTREE(`Letgoal`);
ALTER TABLE `t_b_f_jin` ADD INDEX `IDX_t_b_f_jin_MatchState` USING BTREE(`MatchState`);
ALTER TABLE `t_b_f_jin` ADD INDEX `IDX_t_b_f_jin_ModifyTime` USING BTREE(`ModifyTime`);
ALTER TABLE `t_b_f_jin` ADD INDEX `IDX_t_b_f_jin_ModifyUser` USING BTREE(`ModifyUser`);
ALTER TABLE `t_b_f_jin` ADD INDEX `IDX_t_b_f_jin_OwnerTeamId` USING BTREE(`OwnerTeamId`);
ALTER TABLE `t_b_f_jin` ADD INDEX `IDX_t_b_f_jin_Result` USING BTREE(`Result`);
ALTER TABLE `t_b_f_jin` ADD INDEX `IDX_t_b_f_jin_ResultHalf` USING BTREE(`ResultHalf`);
ALTER TABLE `t_b_f_jin` ADD INDEX `IDX_t_b_f_jin_ResultOU` USING BTREE(`ResultOU`);
ALTER TABLE `t_b_f_jin` ADD INDEX `IDX_t_b_f_jin_ResultOUHalf` USING BTREE(`ResultOUHalf`);
ALTER TABLE `t_b_f_jin` ADD PRIMARY KEY USING BTREE(`Id`);
ALTER TABLE `t_b_f_jin` ADD UNIQUE INDEX `UQE_t_b_f_jin_CurMatchId_MatchId_OwnerTeam` USING BTREE(`CurMatchId`, `OwnerTeam`, `MatchId`);
ALTER TABLE `t_b_f_jin` ADD UNIQUE INDEX `UQE_t_b_f_jin_CurMatchId_OMMG` USING BTREE(`CurMatchId`, `OwnerTeam`, `MatchDate`, `HomeTeam`, `GuestTeam`);
ALTER TABLE `t_b_f_score` ADD INDEX `IDX_t_b_f_score_CreateTime` USING BTREE(`CreateTime`);
ALTER TABLE `t_b_f_score` ADD INDEX `IDX_t_b_f_score_CreateUser` USING BTREE(`CreateUser`);
ALTER TABLE `t_b_f_score` ADD INDEX `IDX_t_b_f_score_DiffGoal` USING BTREE(`DiffGoal`);
ALTER TABLE `t_b_f_score` ADD INDEX `IDX_t_b_f_score_DrawCount` USING BTREE(`DrawCount`);
ALTER TABLE `t_b_f_score` ADD INDEX `IDX_t_b_f_score_FailCount` USING BTREE(`FailCount`);
ALTER TABLE `t_b_f_score` ADD INDEX `IDX_t_b_f_score_GetGoal` USING BTREE(`GetGoal`);
ALTER TABLE `t_b_f_score` ADD INDEX `IDX_t_b_f_score_LossGoal` USING BTREE(`LossGoal`);
ALTER TABLE `t_b_f_score` ADD INDEX `IDX_t_b_f_score_MatchCount` USING BTREE(`MatchCount`);
ALTER TABLE `t_b_f_score` ADD INDEX `IDX_t_b_f_score_ModifyTime` USING BTREE(`ModifyTime`);
ALTER TABLE `t_b_f_score` ADD INDEX `IDX_t_b_f_score_ModifyUser` USING BTREE(`ModifyUser`);
ALTER TABLE `t_b_f_score` ADD INDEX `IDX_t_b_f_score_OwnerTeamId` USING BTREE(`OwnerTeamId`);
ALTER TABLE `t_b_f_score` ADD INDEX `IDX_t_b_f_score_Ranking` USING BTREE(`Ranking`);
ALTER TABLE `t_b_f_score` ADD INDEX `IDX_t_b_f_score_Score` USING BTREE(`Score`);
ALTER TABLE `t_b_f_score` ADD INDEX `IDX_t_b_f_score_WinCount` USING BTREE(`WinCount`);
ALTER TABLE `t_b_f_score` ADD INDEX `IDX_t_b_f_score_WinRate` USING BTREE(`WinRate`);
ALTER TABLE `t_b_f_score` ADD PRIMARY KEY USING BTREE(`Id`);
ALTER TABLE `t_b_f_score` ADD UNIQUE INDEX `UQE_t_b_f_score_CurMatchId_OwnerTeamId_Type` USING BTREE(`CurMatchId`, `OwnerTeam`, `Type`);
ALTER TABLE `t_betfair` ADD INDEX `IDX_t_betfair_CreateTime` USING BTREE(`CreateTime`);
ALTER TABLE `t_betfair` ADD INDEX `IDX_t_betfair_CreateUser` USING BTREE(`CreateUser`);
ALTER TABLE `t_betfair` ADD INDEX `IDX_t_betfair_MatchId` USING BTREE(`MatchId`);
ALTER TABLE `t_betfair` ADD INDEX `IDX_t_betfair_ModifyTime` USING BTREE(`ModifyTime`);
ALTER TABLE `t_betfair` ADD INDEX `IDX_t_betfair_ModifyUser` USING BTREE(`ModifyUser`);
ALTER TABLE `t_betfair` ADD PRIMARY KEY USING BTREE(`Id`);
ALTER TABLE `t_betfair` ADD UNIQUE INDEX `UQE_t_betfair_MatchId_Kind` USING BTREE(`MatchId`, `Kind`);
ALTER TABLE `t_comp` ADD INDEX `IDX_t_comp_CreateTime` USING BTREE(`CreateTime`);
ALTER TABLE `t_comp` ADD INDEX `IDX_t_comp_CreateUser` USING BTREE(`CreateUser`);
ALTER TABLE `t_comp` ADD INDEX `IDX_t_comp_ModifyTime` USING BTREE(`ModifyTime`);
ALTER TABLE `t_comp` ADD INDEX `IDX_t_comp_ModifyUser` USING BTREE(`ModifyUser`);
ALTER TABLE `t_comp` ADD INDEX `IDX_t_comp_Name` USING BTREE(`Name`);
ALTER TABLE `t_comp` ADD INDEX `IDX_t_comp_NameEn` USING BTREE(`NameEn`);
ALTER TABLE `t_comp` ADD INDEX `IDX_t_comp_Type` USING BTREE(`Type`);
ALTER TABLE `t_comp` ADD PRIMARY KEY USING BTREE(`Id`);
ALTER TABLE `t_comp_asia` ADD INDEX `IDX_t_comp_asia_CreateTime` USING BTREE(`CreateTime`);
ALTER TABLE `t_comp_asia` ADD INDEX `IDX_t_comp_asia_CreateUser` USING BTREE(`CreateUser`);
ALTER TABLE `t_comp_asia` ADD INDEX `IDX_t_comp_asia_ModifyTime` USING BTREE(`ModifyTime`);
ALTER TABLE `t_comp_asia` ADD INDEX `IDX_t_comp_asia_ModifyUser` USING BTREE(`ModifyUser`);
ALTER TABLE `t_comp_asia` ADD INDEX `IDX_t_comp_asia_Name` USING BTREE(`Name`);
ALTER TABLE `t_comp_asia` ADD INDEX `IDX_t_comp_asia_NameEn` USING BTREE(`NameEn`);
ALTER TABLE `t_comp_asia` ADD INDEX `IDX_t_comp_asia_Type` USING BTREE(`Type`);
ALTER TABLE `t_comp_asia` ADD PRIMARY KEY USING BTREE(`Id`);
ALTER TABLE `t_euro_his` ADD INDEX `IDX_t_euro_his_CreateTime` USING BTREE(`CreateTime`);
ALTER TABLE `t_euro_his` ADD INDEX `IDX_t_euro_his_CreateUser` USING BTREE(`CreateUser`);
ALTER TABLE `t_euro_his` ADD INDEX `IDX_t_euro_his_Ep0` USING BTREE(`Ep0`);
ALTER TABLE `t_euro_his` ADD INDEX `IDX_t_euro_his_Ep1` USING BTREE(`Ep1`);
ALTER TABLE `t_euro_his` ADD INDEX `IDX_t_euro_his_Ep3` USING BTREE(`Ep3`);
ALTER TABLE `t_euro_his` ADD INDEX `IDX_t_euro_his_ModifyTime` USING BTREE(`ModifyTime`);
ALTER TABLE `t_euro_his` ADD INDEX `IDX_t_euro_his_ModifyUser` USING BTREE(`ModifyUser`);
ALTER TABLE `t_euro_his` ADD INDEX `IDX_t_euro_his_OddDate` USING BTREE(`OddDate`);
ALTER TABLE `t_euro_his` ADD INDEX `IDX_t_euro_his_Payout` USING BTREE(`Payout`);
ALTER TABLE `t_euro_his` ADD INDEX `IDX_t_euro_his_Sp0` USING BTREE(`Sp0`);
ALTER TABLE `t_euro_his` ADD INDEX `IDX_t_euro_his_Sp1` USING BTREE(`Sp1`);
ALTER TABLE `t_euro_his` ADD INDEX `IDX_t_euro_his_Sp3` USING BTREE(`Sp3`);
ALTER TABLE `t_euro_his` ADD PRIMARY KEY USING BTREE(`Id`);
ALTER TABLE `t_euro_his` ADD UNIQUE INDEX `UQE_t_euro_his_CompId_MatchId` USING BTREE(`CompId`, `MatchId`);
ALTER TABLE `t_euro_last` ADD INDEX `IDX_t_euro_last_CreateTime` USING BTREE(`CreateTime`);
ALTER TABLE `t_euro_last` ADD INDEX `IDX_t_euro_last_CreateUser` USING BTREE(`CreateUser`);
ALTER TABLE `t_euro_last` ADD INDEX `IDX_t_euro_last_Ep0` USING BTREE(`Ep0`);
ALTER TABLE `t_euro_last` ADD INDEX `IDX_t_euro_last_Ep1` USING BTREE(`Ep1`);
ALTER TABLE `t_euro_last` ADD INDEX `IDX_t_euro_last_Ep3` USING BTREE(`Ep3`);
ALTER TABLE `t_euro_last` ADD INDEX `IDX_t_euro_last_ModifyTime` USING BTREE(`ModifyTime`);
ALTER TABLE `t_euro_last` ADD INDEX `IDX_t_euro_last_ModifyUser` USING BTREE(`ModifyUser`);
ALTER TABLE `t_euro_last` ADD INDEX `IDX_t_euro_last_OddDate` USING BTREE(`OddDate`);
ALTER TABLE `t_euro_last` ADD INDEX `IDX_t_euro_last_Payout` USING BTREE(`Payout`);
ALTER TABLE `t_euro_last` ADD INDEX `IDX_t_euro_last_Sp0` USING BTREE(`Sp0`);
ALTER TABLE `t_euro_last` ADD INDEX `IDX_t_euro_last_Sp1` USING BTREE(`Sp1`);
ALTER TABLE `t_euro_last` ADD INDEX `IDX_t_euro_last_Sp3` USING BTREE(`Sp3`);
ALTER TABLE `t_euro_last` ADD PRIMARY KEY USING BTREE(`Id`);
ALTER TABLE `t_euro_last` ADD UNIQUE INDEX `UQE_t_euro_last_CompId_MatchId` USING BTREE(`CompId`, `MatchId`);
ALTER TABLE `t_euro_track` ADD INDEX `IDX_t_euro_track_CreateTime` USING BTREE(`CreateTime`);
ALTER TABLE `t_euro_track` ADD INDEX `IDX_t_euro_track_CreateUser` USING BTREE(`CreateUser`);
ALTER TABLE `t_euro_track` ADD INDEX `IDX_t_euro_track_ModifyTime` USING BTREE(`ModifyTime`);
ALTER TABLE `t_euro_track` ADD INDEX `IDX_t_euro_track_ModifyUser` USING BTREE(`ModifyUser`);
ALTER TABLE `t_euro_track` ADD PRIMARY KEY USING BTREE(`Id`);
ALTER TABLE `t_euro_track` ADD UNIQUE INDEX `UQE_t_euro_track_CompId_MatchId_OddDate_Num` USING BTREE(`CompId`, `MatchId`, `OddDate`, `Num`);
ALTER TABLE `t_league` ADD INDEX `IDX_t_league_CreateTime` USING BTREE(`CreateTime`);
ALTER TABLE `t_league` ADD INDEX `IDX_t_league_CreateUser` USING BTREE(`CreateUser`);
ALTER TABLE `t_league` ADD INDEX `IDX_t_league_Cup` USING BTREE(`Cup`);
ALTER TABLE `t_league` ADD INDEX `IDX_t_league_Level` USING BTREE(`Level`);
ALTER TABLE `t_league` ADD INDEX `IDX_t_league_LevelAssist` USING BTREE(`LevelAssist`);
ALTER TABLE `t_league` ADD INDEX `IDX_t_league_ModifyTime` USING BTREE(`ModifyTime`);
ALTER TABLE `t_league` ADD INDEX `IDX_t_league_ModifyUser` USING BTREE(`ModifyUser`);
ALTER TABLE `t_league` ADD INDEX `IDX_t_league_Name` USING BTREE(`Name`);
ALTER TABLE `t_league` ADD INDEX `IDX_t_league_SeasonCross` USING BTREE(`SeasonCross`);
ALTER TABLE `t_league` ADD INDEX `IDX_t_league_ShortName` USING BTREE(`ShortName`);
ALTER TABLE `t_league` ADD INDEX `IDX_t_league_ShortUrl` USING BTREE(`ShortUrl`);
ALTER TABLE `t_league` ADD INDEX `IDX_t_league_Sid` USING BTREE(`Sid`);
ALTER TABLE `t_league` ADD INDEX `IDX_t_league_SName` USING BTREE(`SName`);
ALTER TABLE `t_league` ADD PRIMARY KEY USING BTREE(`Id`);
ALTER TABLE `t_league_season` ADD INDEX `IDX_t_league_season_BeginMonth` USING BTREE(`BeginMonth`);
ALTER TABLE `t_league_season` ADD INDEX `IDX_t_league_season_CreateTime` USING BTREE(`CreateTime`);
ALTER TABLE `t_league_season` ADD INDEX `IDX_t_league_season_CreateUser` USING BTREE(`CreateUser`);
ALTER TABLE `t_league_season` ADD INDEX `IDX_t_league_season_LeagueId` USING BTREE(`LeagueId`);
ALTER TABLE `t_league_season` ADD INDEX `IDX_t_league_season_LeagueName` USING BTREE(`LeagueName`);
ALTER TABLE `t_league_season` ADD INDEX `IDX_t_league_season_ModifyTime` USING BTREE(`ModifyTime`);
ALTER TABLE `t_league_season` ADD INDEX `IDX_t_league_season_ModifyUser` USING BTREE(`ModifyUser`);
ALTER TABLE `t_league_season` ADD INDEX `IDX_t_league_season_Season` USING BTREE(`Season`);
ALTER TABLE `t_league_season` ADD PRIMARY KEY USING BTREE(`Id`);
ALTER TABLE `t_league_sub` ADD INDEX `IDX_t_league_sub_BeginMonth` USING BTREE(`BeginMonth`);
ALTER TABLE `t_league_sub` ADD INDEX `IDX_t_league_sub_CreateTime` USING BTREE(`CreateTime`);
ALTER TABLE `t_league_sub` ADD INDEX `IDX_t_league_sub_CreateUser` USING BTREE(`CreateUser`);
ALTER TABLE `t_league_sub` ADD INDEX `IDX_t_league_sub_LeagueId` USING BTREE(`LeagueId`);
ALTER TABLE `t_league_sub` ADD INDEX `IDX_t_league_sub_LeagueName` USING BTREE(`LeagueName`);
ALTER TABLE `t_league_sub` ADD INDEX `IDX_t_league_sub_ModifyTime` USING BTREE(`ModifyTime`);
ALTER TABLE `t_league_sub` ADD INDEX `IDX_t_league_sub_ModifyUser` USING BTREE(`ModifyUser`);
ALTER TABLE `t_league_sub` ADD INDEX `IDX_t_league_sub_Season` USING BTREE(`Season`);
ALTER TABLE `t_league_sub` ADD INDEX `IDX_t_league_sub_SubId` USING BTREE(`SubId`);
ALTER TABLE `t_league_sub` ADD INDEX `IDX_t_league_sub_SubName` USING BTREE(`SubName`);
ALTER TABLE `t_league_sub` ADD PRIMARY KEY USING BTREE(`Id`);
ALTER TABLE `t_match_his` ADD INDEX `IDX_t_match_his_CreateTime` USING BTREE(`CreateTime`);
ALTER TABLE `t_match_his` ADD INDEX `IDX_t_match_his_CreateUser` USING BTREE(`CreateUser`);
ALTER TABLE `t_match_his` ADD INDEX `IDX_t_match_his_DataDate` USING BTREE(`DataDate`);
ALTER TABLE `t_match_his` ADD INDEX `IDX_t_match_his_GuestTeamGoal` USING BTREE(`GuestTeamGoal`);
ALTER TABLE `t_match_his` ADD INDEX `IDX_t_match_his_GuestTeamHalfGoal` USING BTREE(`GuestTeamHalfGoal`);
ALTER TABLE `t_match_his` ADD INDEX `IDX_t_match_his_LeagueId` USING BTREE(`LeagueId`);
ALTER TABLE `t_match_his` ADD INDEX `IDX_t_match_his_LeagueRound` USING BTREE(`LeagueRound`);
ALTER TABLE `t_match_his` ADD INDEX `IDX_t_match_his_MainTeamGoal` USING BTREE(`MainTeamGoal`);
ALTER TABLE `t_match_his` ADD INDEX `IDX_t_match_his_MainTeamHalfGoal` USING BTREE(`MainTeamHalfGoal`);
ALTER TABLE `t_match_his` ADD INDEX `IDX_t_match_his_ModifyTime` USING BTREE(`ModifyTime`);
ALTER TABLE `t_match_his` ADD INDEX `IDX_t_match_his_ModifyUser` USING BTREE(`ModifyUser`);
ALTER TABLE `t_match_his` ADD INDEX `IDX_t_match_his_Neutral` USING BTREE(`Neutral`);
ALTER TABLE `t_match_his` ADD PRIMARY KEY USING BTREE(`Id`);
ALTER TABLE `t_match_his` ADD UNIQUE INDEX `UQE_t_match_his_MatchDate_MainTeam_GuestTeam` USING BTREE(`MatchDate`, `MainTeam`, `GuestTeam`);
ALTER TABLE `t_match_last` ADD INDEX `IDX_t_match_last_CreateTime` USING BTREE(`CreateTime`);
ALTER TABLE `t_match_last` ADD INDEX `IDX_t_match_last_CreateUser` USING BTREE(`CreateUser`);
ALTER TABLE `t_match_last` ADD INDEX `IDX_t_match_last_DataDate` USING BTREE(`DataDate`);
ALTER TABLE `t_match_last` ADD INDEX `IDX_t_match_last_GuestTeamGoal` USING BTREE(`GuestTeamGoal`);
ALTER TABLE `t_match_last` ADD INDEX `IDX_t_match_last_GuestTeamHalfGoal` USING BTREE(`GuestTeamHalfGoal`);
ALTER TABLE `t_match_last` ADD INDEX `IDX_t_match_last_LeagueId` USING BTREE(`LeagueId`);
ALTER TABLE `t_match_last` ADD INDEX `IDX_t_match_last_LeagueRound` USING BTREE(`LeagueRound`);
ALTER TABLE `t_match_last` ADD INDEX `IDX_t_match_last_MainTeamGoal` USING BTREE(`MainTeamGoal`);
ALTER TABLE `t_match_last` ADD INDEX `IDX_t_match_last_MainTeamHalfGoal` USING BTREE(`MainTeamHalfGoal`);
ALTER TABLE `t_match_last` ADD INDEX `IDX_t_match_last_ModifyTime` USING BTREE(`ModifyTime`);
ALTER TABLE `t_match_last` ADD INDEX `IDX_t_match_last_ModifyUser` USING BTREE(`ModifyUser`);
ALTER TABLE `t_match_last` ADD INDEX `IDX_t_match_last_Neutral` USING BTREE(`Neutral`);
ALTER TABLE `t_match_last` ADD PRIMARY KEY USING BTREE(`Id`);
ALTER TABLE `t_match_last` ADD UNIQUE INDEX `UQE_t_match_last_MatchDate_MainTeam_GuestTeam` USING BTREE(`MatchDate`, `MainTeam`, `GuestTeam`);
ALTER TABLE `t_over_under_his` ADD INDEX `IDX_t_over_under_his_CompName` USING BTREE(`CompName`);
ALTER TABLE `t_over_under_his` ADD INDEX `IDX_t_over_under_his_CreateTime` USING BTREE(`CreateTime`);
ALTER TABLE `t_over_under_his` ADD INDEX `IDX_t_over_under_his_CreateUser` USING BTREE(`CreateUser`);
ALTER TABLE `t_over_under_his` ADD INDEX `IDX_t_over_under_his_Ep0` USING BTREE(`Ep0`);
ALTER TABLE `t_over_under_his` ADD INDEX `IDX_t_over_under_his_Ep3` USING BTREE(`Ep3`);
ALTER TABLE `t_over_under_his` ADD INDEX `IDX_t_over_under_his_EPanKou` USING BTREE(`EPanKou`);
ALTER TABLE `t_over_under_his` ADD INDEX `IDX_t_over_under_his_ModifyTime` USING BTREE(`ModifyTime`);
ALTER TABLE `t_over_under_his` ADD INDEX `IDX_t_over_under_his_ModifyUser` USING BTREE(`ModifyUser`);
ALTER TABLE `t_over_under_his` ADD INDEX `IDX_t_over_under_his_OddDate` USING BTREE(`OddDate`);
ALTER TABLE `t_over_under_his` ADD INDEX `IDX_t_over_under_his_Sp0` USING BTREE(`Sp0`);
ALTER TABLE `t_over_under_his` ADD INDEX `IDX_t_over_under_his_Sp3` USING BTREE(`Sp3`);
ALTER TABLE `t_over_under_his` ADD INDEX `IDX_t_over_under_his_SPanKou` USING BTREE(`SPanKou`);
ALTER TABLE `t_over_under_his` ADD PRIMARY KEY USING BTREE(`Id`);
ALTER TABLE `t_over_under_his` ADD UNIQUE INDEX `UQE_t_over_under_his_CompId_MatchId` USING BTREE(`CompId`, `MatchId`);
ALTER TABLE `t_over_under_last` ADD INDEX `IDX_t_over_under_last_CompName` USING BTREE(`CompName`);
ALTER TABLE `t_over_under_last` ADD INDEX `IDX_t_over_under_last_CreateTime` USING BTREE(`CreateTime`);
ALTER TABLE `t_over_under_last` ADD INDEX `IDX_t_over_under_last_CreateUser` USING BTREE(`CreateUser`);
ALTER TABLE `t_over_under_last` ADD INDEX `IDX_t_over_under_last_Ep0` USING BTREE(`Ep0`);
ALTER TABLE `t_over_under_last` ADD INDEX `IDX_t_over_under_last_Ep3` USING BTREE(`Ep3`);
ALTER TABLE `t_over_under_last` ADD INDEX `IDX_t_over_under_last_EPanKou` USING BTREE(`EPanKou`);
ALTER TABLE `t_over_under_last` ADD INDEX `IDX_t_over_under_last_ModifyTime` USING BTREE(`ModifyTime`);
ALTER TABLE `t_over_under_last` ADD INDEX `IDX_t_over_under_last_ModifyUser` USING BTREE(`ModifyUser`);
ALTER TABLE `t_over_under_last` ADD INDEX `IDX_t_over_under_last_OddDate` USING BTREE(`OddDate`);
ALTER TABLE `t_over_under_last` ADD INDEX `IDX_t_over_under_last_Sp0` USING BTREE(`Sp0`);
ALTER TABLE `t_over_under_last` ADD INDEX `IDX_t_over_under_last_Sp3` USING BTREE(`Sp3`);
ALTER TABLE `t_over_under_last` ADD INDEX `IDX_t_over_under_last_SPanKou` USING BTREE(`SPanKou`);
ALTER TABLE `t_over_under_last` ADD PRIMARY KEY USING BTREE(`Id`);
ALTER TABLE `t_over_under_last` ADD UNIQUE INDEX `UQE_t_over_under_last_CompId_MatchId` USING BTREE(`CompId`, `MatchId`);
ALTER TABLE `t_over_under_track` ADD INDEX `IDX_t_over_under_track_CreateTime` USING BTREE(`CreateTime`);
ALTER TABLE `t_over_under_track` ADD INDEX `IDX_t_over_under_track_CreateUser` USING BTREE(`CreateUser`);
ALTER TABLE `t_over_under_track` ADD INDEX `IDX_t_over_under_track_ModifyTime` USING BTREE(`ModifyTime`);
ALTER TABLE `t_over_under_track` ADD INDEX `IDX_t_over_under_track_ModifyUser` USING BTREE(`ModifyUser`);
ALTER TABLE `t_over_under_track` ADD INDEX `IDX_t_over_under_track_PanKou` USING BTREE(`PanKou`);
ALTER TABLE `t_over_under_track` ADD PRIMARY KEY USING BTREE(`Id`);
ALTER TABLE `t_over_under_track` ADD UNIQUE INDEX `UQE_t_over_under_track_CompId_MatchId_OddDate_Num` USING BTREE(`CompId`, `MatchId`, `OddDate`, `Num`);
ALTER TABLE `t_pub` ADD INDEX `IDX_t_pub_Account` USING BTREE(`Account`);
ALTER TABLE `t_pub` ADD INDEX `IDX_t_pub_AnalyId` USING BTREE(`AnalyId`);
ALTER TABLE `t_pub` ADD INDEX `IDX_t_pub_CreateTime` USING BTREE(`CreateTime`);
ALTER TABLE `t_pub` ADD INDEX `IDX_t_pub_CreateUser` USING BTREE(`CreateUser`);
ALTER TABLE `t_pub` ADD INDEX `IDX_t_pub_MatchId` USING BTREE(`MatchId`);
ALTER TABLE `t_pub` ADD INDEX `IDX_t_pub_ModifyTime` USING BTREE(`ModifyTime`);
ALTER TABLE `t_pub` ADD INDEX `IDX_t_pub_ModifyUser` USING BTREE(`ModifyUser`);
ALTER TABLE `t_pub` ADD PRIMARY KEY USING BTREE(`Id`);
ALTER TABLE `t_team` ADD INDEX `IDX_t_team_CreateTime` USING BTREE(`CreateTime`);
ALTER TABLE `t_team` ADD INDEX `IDX_t_team_CreateUser` USING BTREE(`CreateUser`);
ALTER TABLE `t_team` ADD INDEX `IDX_t_team_ModifyTime` USING BTREE(`ModifyTime`);
ALTER TABLE `t_team` ADD INDEX `IDX_t_team_ModifyUser` USING BTREE(`ModifyUser`);
ALTER TABLE `t_team` ADD INDEX `IDX_t_team_Name` USING BTREE(`Name`);
ALTER TABLE `t_team` ADD INDEX `IDX_t_team_NameEn` USING BTREE(`NameEn`);
ALTER TABLE `t_team` ADD PRIMARY KEY USING BTREE(`Id`);

😎 旧版本

属性项说明
数据年份2010-2020.:
数据库类型mysql
数据格式sql文件
数据量级千万级
数据完善程度缺失严重
sql中是否带索引生成

👏 创作不易,还请大家多多支持,帮忙分享一下.

  • 4
    点赞
  • 13
    收藏
    觉得还不错? 一键收藏
  • 2
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论 2
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值