From 5c345058621b362478e0f71f6f238ebdf4496b81 Mon Sep 17 00:00:00 2001 From: Steve Sutton Date: Wed, 29 Nov 2017 13:50:07 -0500 Subject: [PATCH] Fixing index on field that were removed. Removing all indexes for reg_time that don't exists in the table setup. --- setup/databaseScripts/create_database_V0.0.19.sql | 5 +---- 1 file changed, 1 insertion(+), 4 deletions(-) diff --git a/setup/databaseScripts/create_database_V0.0.19.sql b/setup/databaseScripts/create_database_V0.0.19.sql index cbdcede..2cc4f23 100644 --- a/setup/databaseScripts/create_database_V0.0.19.sql +++ b/setup/databaseScripts/create_database_V0.0.19.sql @@ -449,8 +449,7 @@ CREATE TABLE {prefix}reg_request_event ( notes TEXT NULL, -- System operator's notes for this registration request PRIMARY KEY (id), INDEX (reg_request), - INDEX (reg_event), - INDEX (reg_time) + INDEX (reg_event) ); ---- @@ -467,7 +466,6 @@ CREATE TABLE {prefix}reg_request_class ( notes TEXT NULL, -- System operator's notes for this registration request PRIMARY KEY (id), INDEX (reg_event), - INDEX (reg_time), INDEX (reg_request_event) ); @@ -489,7 +487,6 @@ CREATE TABLE {prefix}reg_request_rate ( notes TEXT NULL, -- System operator's notes for this registration request PRIMARY KEY (id), INDEX (reg_event), - INDEX (reg_time), INDEX (reg_request_event), INDEX (reg_request_class) ); -- 2.17.1