2 -- we duplicate office_id and company_id here...
3 -- not sure if we should keep doing that in the new design...
4 -- we should improve our links code to handle this..
7 CREATE TABLE ProjectDirectory (
8 id int(11) NOT NULL auto_increment,
12 ALTER TABLE ProjectDirectory ADD COLUMN project_id int(11) NOT NULL DEFAULT 0;
13 ALTER TABLE ProjectDirectory ADD COLUMN person_id int(11) NOT NULL DEFAULT 0;
14 ALTER TABLE ProjectDirectory ADD COLUMN ispm int(11) NOT NULL DEFAULT 0;
15 ALTER TABLE ProjectDirectory ADD COLUMN role varchar(32) NOT NULL DEFAULT '';
17 ALTER TABLE ProjectDirectory ADD COLUMN company_id int(11) NOT NULL DEFAULT 0;
18 ALTER TABLE ProjectDirectory ADD COLUMN office_id int(11) NOT NULL DEFAULT 0;
21 ALTER TABLE ProjectDirectory ADD INDEX plookup (project_id,person_id, ispm, role);