sql/core_project.sql

diff --git a/sql/core_project.sql b/sql/core_project.sql
index 01ddcde..fac5f33 100644 (file)
--- 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