ALTER TABLE ProjectDirectory ADD COLUMN ispm int(11) NOT NULL DEFAULT 0;
ALTER TABLE ProjectDirectory ADD COLUMN role varchar(32) NOT NULL DEFAULT '';
+ALTER TABLE ProjectDirectory ADD COLUMN company_id int(11) NOT NULL DEFAULT 0;
+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 ENGINE=InnoDB;
\ No newline at end of file
+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