From 0e332be8176a8adda8554ae24c3094c35d3bdd07 Mon Sep 17 00:00:00 2001 From: Edward Date: Thu, 8 Nov 2018 14:01:46 +0800 Subject: [PATCH] sql/projectdirectory.sql --- sql/projectdirectory.sql | 1 + 1 file changed, 1 insertion(+) diff --git a/sql/projectdirectory.sql b/sql/projectdirectory.sql index 01162067..57697a76 100644 --- a/sql/projectdirectory.sql +++ b/sql/projectdirectory.sql @@ -21,6 +21,7 @@ ALTER TABLE ProjectDirectory ADD COLUMN office_id int(11) NOT NULL DEFAULT 0; ALTER TABLE ProjectDirectory ADD INDEX plookup (project_id,person_id, ispm, role); ALTER TABLE ProjectDirectory ADD INDEX lookup_company_id (company_id); +ALTER TABLE ProjectDirectory ADD INDEX lookup_person_id (person_id); \ No newline at end of file -- 2.39.2