summaryrefslogtreecommitdiffstats
path: root/database/sqlite/sqlite_functions.c
diff options
context:
space:
mode:
authorStelios Fragkakis <52996999+stelfrag@users.noreply.github.com>2023-06-22 00:14:01 +0300
committerGitHub <noreply@github.com>2023-06-22 00:14:01 +0300
commit8e8531d402b4038c12dfb73431559082787ebaa8 (patch)
treec57b4ab494ea731407fc3d8ef4bf7dea094d2850 /database/sqlite/sqlite_functions.c
parentc980f48ddad30002170c06d1ae106bf73b40e9bd (diff)
Create index for health log migration (#15233)
Create health_log_id index
Diffstat (limited to 'database/sqlite/sqlite_functions.c')
-rw-r--r--database/sqlite/sqlite_functions.c1
1 files changed, 1 insertions, 0 deletions
diff --git a/database/sqlite/sqlite_functions.c b/database/sqlite/sqlite_functions.c
index 3f6b5bb6f5..88fd6cf3c5 100644
--- a/database/sqlite/sqlite_functions.c
+++ b/database/sqlite/sqlite_functions.c
@@ -61,6 +61,7 @@ const char *database_config[] = {
"CREATE INDEX IF NOT EXISTS health_log_d_ind_1 ON health_log_detail (unique_id);",
"CREATE INDEX IF NOT EXISTS health_log_d_ind_2 ON health_log_detail (global_id);",
"CREATE INDEX IF NOT EXISTS health_log_d_ind_3 ON health_log_detail (transition_id);",
+ "CREATE INDEX IF NOT EXISTS health_log_d_ind_4 ON health_log_detail (health_log_id);",
//TODO more indexes
NULL