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.4 -r1.5
--- openacs-4/packages/organizations/sql/postgresql/organizations-create.sql	15 Dec 2005 15:15:09 -0000	1.4
+++ openacs-4/packages/organizations/sql/postgresql/organizations-create.sql	22 Nov 2006 11:24:50 -0000	1.5
@@ -46,10 +46,13 @@
     legal_name        varchar(200),
     -- 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),
     notes             text
 ); 
 
 create index organization_name_ix on organizations(name);
+create index organization_cliend_idx on organizations(client_id);
 
 create table organization_type_map (
     organization_id             integer
Index: openacs-4/packages/organizations/sql/postgresql/organizations-plsql-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/organizations/sql/postgresql/organizations-plsql-create.sql,v
diff -u -r1.6 -r1.7
--- openacs-4/packages/organizations/sql/postgresql/organizations-plsql-create.sql	10 Sep 2005 13:42:12 -0000	1.6
+++ openacs-4/packages/organizations/sql/postgresql/organizations-plsql-create.sql	22 Nov 2006 11:24:50 -0000	1.7
@@ -74,6 +74,9 @@
     p_context_id 
   );   
    
+  update acs_objects
+  set title = p_name
+  where object_id = v_organization_id;
 
   insert into organizations (
     legal_name,
Index: openacs-4/packages/organizations/sql/postgresql/upgrade/upgrade-0.5d4-0.5d5.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/organizations/sql/postgresql/upgrade/upgrade-0.5d4-0.5d5.sql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/organizations/sql/postgresql/upgrade/upgrade-0.5d4-0.5d5.sql	22 Nov 2006 11:26:10 -0000	1.1
@@ -0,0 +1 @@
+alter table organizations add index organizations_client_id_idx on organizations(client_id);
\ No newline at end of file
Index: openacs-4/packages/organizations/sql/postgresql/upgrade/upgrade-0.5d5-0.5d6.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/organizations/sql/postgresql/upgrade/upgrade-0.5d5-0.5d6.sql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/organizations/sql/postgresql/upgrade/upgrade-0.5d5-0.5d6.sql	22 Nov 2006 11:26:10 -0000	1.1
@@ -0,0 +1,2 @@
+alter table organizations add column client_id varchar(100);
+create index organization_cliend_idx on organizations(client_id);