# HG changeset patch
# User Laman
# Date 2018-04-01 14:03:36
# Node ID a3bc9e0f40b2004266fe9535ada52353b1eac02c
# Parent  ed00726edba54092757d77ba640b63ede0c7812f

optimalizace: zapomenuté indexy na cizích klíčích v databázi

diff --git a/egd.py b/egd.py
--- a/egd.py
+++ b/egd.py
@@ -68,6 +68,8 @@ def setupDB():
 				from players_performance as pp join tournaments as ts on pp.tournament_code=ts.code
 	""")
 
+	cursor.execute("""create index pp_pin on players_performance (pin)""")
+	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)""")