Index: openacs-4/contrib/packages/project-manager/sql/postgresql/project-manager-table-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/project-manager/sql/postgresql/Attic/project-manager-table-create.sql,v diff -u -r1.19.2.4 -r1.19.2.5 --- openacs-4/contrib/packages/project-manager/sql/postgresql/project-manager-table-create.sql 15 Sep 2004 23:05:51 -0000 1.19.2.4 +++ openacs-4/contrib/packages/project-manager/sql/postgresql/project-manager-table-create.sql 8 Oct 2004 21:25:00 -0000 1.19.2.5 @@ -96,7 +96,10 @@ sort_order integer, is_observer_p char(1) default 'f' constraint pm_role_is_observer_ck - check (is_observer_p in ('t','f')) + check (is_observer_p in ('t','f')), + is_lead_p char(1) default 'f' + constraint pm_role_is_lead_ck + check (is_lead_p in ('t','f')) ); @@ -108,7 +111,7 @@ responsible for the task, or are just observers on it. '; -insert into pm_roles (role_id, one_line, description, sort_order) values ('1','Lead','Team members who are responsible for the completion of the project','10'); +insert into pm_roles (role_id, one_line, description, sort_order, is_lead_p) values ('1','Lead','Team members who are responsible for the completion of the project','10','t'); insert into pm_roles (role_id, one_line, description, sort_order) values ('2','Player','A person on the team responsible for completion of the project','20'); insert into pm_roles (role_id, one_line, description, sort_order, is_observer_p) values ('3','Watcher','A person interested in developments, possibly helping out on it.','30','t');