Index: openacs-4/packages/organizations/sql/postgresql/organizations-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/organizations/sql/postgresql/organizations-create.sql,v diff -u -N -r1.5 -r1.6 --- openacs-4/packages/organizations/sql/postgresql/organizations-create.sql 22 Nov 2006 11:24:50 -0000 1.5 +++ openacs-4/packages/organizations/sql/postgresql/organizations-create.sql 23 Nov 2006 15:45:57 -0000 1.6 @@ -47,7 +47,7 @@ -- this can be ein/ssn/vat reg_number varchar(100), -- The internal client_id. You should have your own sequence for that. - client_id varchar(100), + client_id varchar(100) constraint orga_client_id_un unique, notes text );