-
Notifications
You must be signed in to change notification settings - Fork 0
/
create_indexes.py
35 lines (31 loc) · 1009 Bytes
/
create_indexes.py
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
import sqlite3
conn=sqlite3.connect("r20_index.db")
cursor=conn.cursor()
cursor.execute('''CREATE INDEX ind1 on
XRHSTHS(Username);''')
cursor.execute('''CREATE INDEX ind4 on
KANEI(ID_Xrhsth);''')
cursor.execute('''CREATE INDEX ind5 on
KRATHSH(Arrival);''')
conn.commit()
conn.close()
conn=sqlite3.connect("r1000_index.db")
cursor=conn.cursor()
cursor.execute('''CREATE INDEX ind1 on
XRHSTHS(Username);''')
cursor.execute('''CREATE INDEX ind4 on
KANEI(ID_Xrhsth);''')
cursor.execute('''CREATE INDEX ind5 on
KRATHSH(Arrival);''')
conn.commit()
conn.close()
conn=sqlite3.connect("r5000_index.db")
cursor=conn.cursor()
cursor.execute('''CREATE INDEX ind1 on
XRHSTHS(Username);''')
cursor.execute('''CREATE INDEX ind4 on
KANEI(ID_Xrhsth);''')
cursor.execute('''CREATE INDEX ind5 on
KRATHSH(Arrival);''')
conn.commit()
conn.close()