Index: openacs-4/packages/cms/sql/oracle/cms-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/cms/sql/oracle/cms-create.sql,v
diff -u -N -r1.4 -r1.4.2.1
--- openacs-4/packages/cms/sql/oracle/cms-create.sql	9 May 2005 22:44:48 -0000	1.4
+++ openacs-4/packages/cms/sql/oracle/cms-create.sql	6 Jun 2005 17:07:23 -0000	1.4.2.1
@@ -79,7 +79,10 @@
 			     constraint cm_modules_name_nil
 			     not null,
   root_key                   varchar2(100),
-  sort_key		     integer
+  sort_key		     integer,
+  package_id		     integer 
+			     constraint cm_modules_pkg_id_fk
+                             references apm_packages
 );
 
 comment on column cm_modules.root_key is '
@@ -224,7 +227,15 @@
 -- end;
 -- /
 -- show errors
+-- map subsites to cms package
 
+create table subsite_package_map (
+ subsite_id	integer,
+ package_id	integer
+                constraint subsite_package_map_pkg_id_fk references
+                apm_packages on delete cascade
+)
+
 prompt *** Defining utility functions 
 
 -- Get the alphabetical ordering of a string, based on the first
