diff --git a/egd.py b/egd.py --- a/egd.py +++ b/egd.py @@ -67,6 +67,9 @@ def setupDB(): from players_performance as pp join tournaments as ts on pp.tournament_code=ts.code """) + cursor.execute("""create index pp_country_ind on players_performance (country_code)""") + cursor.execute("""create index t_datum_ind on tournaments (datum)""") + connection.commit()