From 6f07f3af4c0b1c1090839ff26227f3f910375c94 Mon Sep 17 00:00:00 2001 From: Edward Date: Thu, 8 Nov 2018 14:02:50 +0800 Subject: [PATCH] sql/core_project.sql --- sql/core_project.sql | 3 +++ 1 file changed, 3 insertions(+) diff --git a/sql/core_project.sql b/sql/core_project.sql index fac5f33f..b4a74177 100644 --- a/sql/core_project.sql +++ b/sql/core_project.sql @@ -29,4 +29,7 @@ ALTER TABLE core_project ADD INDEX plookup (code); ALTER TABLE core_project ADD INDEX lookup_client_id (client_id); ALTER TABLE core_project ADD INDEX lookup_agency_id (agency_id); + +ALTER TABLE core_project ADD INDEX lookup_open_by (open_by); +ALTER TABLE core_project ADD INDEX lookup_owner_id (owner_id); \ No newline at end of file -- 2.39.2