diff --git a/egd.py b/egd.py --- a/egd.py +++ b/egd.py @@ -72,6 +72,7 @@ def setupDB(): cursor.execute("""create index pp_tournament_code on players_performance (tournament_code)""") cursor.execute("""create index pp_country_ind on players_performance (country_code)""") cursor.execute("""create index t_datum_ind on tournaments (datum)""") + cursor.execute("""create index p_name_ind on players (name)""") connection.commit()