From 2cffd3f6b5e8bc05bcbf30a39179a4848aea34ee Mon Sep 17 00:00:00 2001 From: Edward Date: Thu, 8 Nov 2018 13:20:12 +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 c245e678..01162067 100644 --- a/sql/projectdirectory.sql +++ b/sql/projectdirectory.sql @@ -20,6 +20,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); \ No newline at end of file -- 2.39.2