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 -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
 ); 
 
