import sqlite3

con2 = sqlite3.connect("py-new.db")
con2.execute ("PRAGMA synchronous = NORMAL;")
con2.execute ("PRAGMA temp_store = MEMORY;")


con2.execute("CREATE INDEX index_0_0 ON py_phrase_0(s0, y0)")
print "py_phrase_%d done" % 0

con2.execute("CREATE INDEX index_1_0 ON py_phrase_1(s0, y0, s1, y1)")
con2.execute("CREATE INDEX index_1_1 ON py_phrase_1(s0, s1, y1)")
print "py_phrase_%d done" % 1

for i in xrange(2, 16):
	con2.execute("CREATE INDEX index_%d_0 ON py_phrase_%d(s0, y0, s1, y1, s2, y2)" % (i, i))
	con2.execute("CREATE INDEX index_%d_1 ON py_phrase_%d(s0, s1, s2, y2)" % (i, i))
	print "py_phrase_%d done" % i

# con2.execute("vacuum")
con2.commit()