Index: openacs-4/contrib/packages/project-manager/sql/postgresql/project-manager-custom-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/contrib/packages/project-manager/sql/postgresql/Attic/project-manager-custom-create.sql,v diff -u -r1.2 -r1.3 --- openacs-4/contrib/packages/project-manager/sql/postgresql/project-manager-custom-create.sql 26 Jan 2004 15:39:40 -0000 1.2 +++ openacs-4/contrib/packages/project-manager/sql/postgresql/project-manager-custom-create.sql 26 Feb 2004 15:15:40 -0000 1.3 @@ -15,17 +15,23 @@ -- you should use the content_type__create_attribute procedure to add -- in columns so that the views are correctly recreated. +-- PROJECTS --- add in extra columns +-- example, using customer +-- this is actually done in the table-create script ---select content_type__create_attribute( --- 'pm_project', --- 'customer_id', --- 'integer', --- 'Customer', --- 'Customers', --- null, --- null, --- 'integer constraint pm_project_customer_fk references organizations' ---); +-- this adds in the customer column. This is an example of how +-- the custom columns are added in. I put this here as a reminder +-- that other columns can be added in as well. These custom items +-- are in the custom-create.sql script +select content_type__create_attribute( + 'pm_project', + 'customer_id', + 'integer', + 'Customer', + 'Customers', + null, + null, + 'integer constraint pm_project_customer_fk references organizations' +);