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.1 -r1.2
--- openacs-4/packages/organizations/sql/postgresql/organizations-create.sql	14 Mar 2003 15:55:17 -0000	1.1
+++ openacs-4/packages/organizations/sql/postgresql/organizations-create.sql	11 Dec 2003 21:40:10 -0000	1.2
@@ -27,7 +27,7 @@
 insert into organization_types values (acs_object_id_seq.nextval,'Vendor');
 insert into organization_types values (acs_object_id_seq.nextval,'Customer');
 insert into organization_types values (acs_object_id_seq.nextval,'Prospect');
-insert into organization_types values (acs_object_id_seq.nextval,'Misc.');
+insert into organization_types values (acs_object_id_seq.nextval,'Other');
 
 -- organization
 -- this will be a party
@@ -52,4 +52,14 @@
 ); 
 
 create index organization_name_ix on organizations(name);
+
+create table organization_type_map (
+    organization_id             integer
+                                constraint org_type_map_org_id_fk
+                                references organizations(organization_id),
+    organization_type_id        integer
+                                constraint org_type_map_type_fk
+                                references organization_types(organization_type_id)
+);
+
 \i organizations-plsql-create.sql