diff options
| author | Terry Truong <terry06890@gmail.com> | 2022-06-15 15:05:46 +1000 |
|---|---|---|
| committer | Terry Truong <terry06890@gmail.com> | 2022-06-15 15:05:46 +1000 |
| commit | fd0cb82ddd065a0a8966b67f98a151adfbab4bc3 (patch) | |
| tree | d5c9664a2136a5eb231d8c4427d01b953398ec62 /backend/data/genEolNameData.py | |
| parent | 025f5b6cb96dba346b2c4d4ca159a5a6a7eb04c4 (diff) | |
Move tree-trimming code into separate script/stage
Diffstat (limited to 'backend/data/genEolNameData.py')
| -rwxr-xr-x | backend/data/genEolNameData.py | 1 |
1 files changed, 1 insertions, 0 deletions
diff --git a/backend/data/genEolNameData.py b/backend/data/genEolNameData.py index 74b0e3d..79e6f4f 100755 --- a/backend/data/genEolNameData.py +++ b/backend/data/genEolNameData.py @@ -77,6 +77,7 @@ dbCon = sqlite3.connect(dbFile) dbCur = dbCon.cursor() # Create tables dbCur.execute("CREATE TABLE names(name TEXT, alt_name TEXT, pref_alt INT, src TEXT, PRIMARY KEY(name, alt_name))") +dbCur.execute("CREATE INDEX names_idx ON names(name)") dbCur.execute("CREATE INDEX names_alt_idx ON names(alt_name)") dbCur.execute("CREATE INDEX names_alt_idx_nc ON names(alt_name COLLATE NOCASE)") dbCur.execute("CREATE TABLE eol_ids(id INT PRIMARY KEY, name TEXT)") |