# HG changeset patch
# User Laman
# Date 2018-05-14 15:06:58
# Node ID de0a4653463b4ffec208843d0d984514578388d3
# Parent  606acf3a4446305254764a122dcb04c8d93ea36b

optimalizace: index na jménech hráčů

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()