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.15.2.1 -r1.15.2.2 --- openacs-4/contrib/packages/project-manager/sql/postgresql/project-manager-table-create.sql 4 Dec 2003 21:00:13 -0000 1.15.2.1 +++ openacs-4/contrib/packages/project-manager/sql/postgresql/project-manager-table-create.sql 5 Dec 2003 01:09:19 -0000 1.15.2.2 @@ -32,27 +32,7 @@ insert into pm_project_status (status_id, description, status_type) values (2, 'Closed', 'c'); --- categories -create sequence pm_project_category_seq start 5; - -create table pm_project_category ( - category_id integer - constraint pm_project_category_pk - primary key, - description varchar(100) -); - -insert into pm_project_category (category_id, description) values -(1, 'On the market'); -insert into pm_project_category (category_id, description) values -(2, 'Trials'); -insert into pm_project_category (category_id, description) values -(3, 'Upcoming'); -insert into pm_project_category (category_id, description) values -(4, 'R & D'); - - create table pm_projects ( project_id integer constraint project_manager_id_fk @@ -97,17 +77,6 @@ ); -create table pm_project_category_map ( - project_id integer - constraint pm_project_cm_fk - references pm_projects, - category_id integer - constraint pm_project_cm_fk - references pm_project_category -); - - - -- ROLES create sequence pm_role_seq start 4;