From 88780af24b48b38aecb68e928cd9147af7b06898 Mon Sep 17 00:00:00 2001 From: Edward Date: Thu, 8 Nov 2018 13:21:17 +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 01ddcde3..fac5f33f 100644 --- a/sql/core_project.sql +++ b/sql/core_project.sql @@ -26,4 +26,7 @@ ALTER TABLE core_project ADD COLUMN languages varchar(128) NOT NULL DEFAULT '' ALTER TABLE core_project ADD COLUMN agency_id int(11) NOT NULL DEFAULT 0 ; 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); \ No newline at end of file -- 2.39.2