历年足球数据下载

最新推荐文章于 2022-11-27 12:04:11 发布

加钱居士.

最新推荐文章于 2022-11-27 12:04:11 发布

阅读量8k

点赞数 4

分类专栏： AI足球文章标签： mysql 数据挖掘机器学习

本文链接：https://blog.csdn.net/ve__locity/article/details/105450016

版权

AI足球专栏收录该内容

7 篇文章

订阅专栏

🚀 历年足球数据下载

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

🌰 参考项目地址

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中是否带索引生成	无

链接：https://pan.baidu.com/s/1Y2GVs-P5sTS2SVDBWKZBxg
提取码：ty8v

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`);