diff options
author | Stelios Fragkakis <52996999+stelfrag@users.noreply.github.com> | 2023-07-27 15:11:33 +0300 |
---|---|---|
committer | GitHub <noreply@github.com> | 2023-07-27 15:11:33 +0300 |
commit | 183309058ab1158d35392a84fc8270279bd3b28a (patch) | |
tree | 4cf3664609fe7fc36fac19ed300e7f0e58950ee2 /database | |
parent | e5931781cdca389dbb893a45f5a4145498729560 (diff) |
Drop duplicate / unused index (#15568)
Diffstat (limited to 'database')
-rw-r--r-- | database/sqlite/sqlite_functions.c | 3 |
1 files changed, 1 insertions, 2 deletions
diff --git a/database/sqlite/sqlite_functions.c b/database/sqlite/sqlite_functions.c index 23307d7bd2..70fb1b73fe 100644 --- a/database/sqlite/sqlite_functions.c +++ b/database/sqlite/sqlite_functions.c @@ -34,8 +34,6 @@ const char *database_config[] = { "repeat text, host_labels text, p_db_lookup_dimensions text, p_db_lookup_method text, p_db_lookup_options int, " "p_db_lookup_after int, p_db_lookup_before int, p_update_every int, source text, chart_labels text);", - "CREATE INDEX IF NOT EXISTS alert_hash_index ON alert_hash (hash_id);", - "CREATE TABLE IF NOT EXISTS host_info(host_id blob, system_key text NOT NULL, system_value text NOT NULL, " "date_created INT, PRIMARY KEY(host_id, system_key));", @@ -75,6 +73,7 @@ const char *database_cleanup[] = { "DROP INDEX IF EXISTS ind_d1;", "DROP INDEX IF EXISTS ind_c1;", "DROP INDEX IF EXISTS ind_c2;", + "DROP INDEX IF EXISTS alert_hash_index;", NULL }; |