Index: openacs-4/packages/dotlrn/sql/oracle/communities-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/sql/oracle/communities-create.sql,v
diff -u -r1.13.8.1 -r1.13.8.2
--- openacs-4/packages/dotlrn/sql/oracle/communities-create.sql	31 May 2005 23:13:03 -0000	1.13.8.1
+++ openacs-4/packages/dotlrn/sql/oracle/communities-create.sql	1 Feb 2006 10:15:44 -0000	1.13.8.2
@@ -79,9 +79,13 @@
     package_id                  constraint dotlrn_c_package_id_fk
                                 references apm_packages (package_id),
     tree_sortkey                raw(240),
-    max_child_sortkey           raw(3)
+    max_child_sortkey           raw(3),
+	site_template_id			integer
+				constraint dotlrn_c_site_template_id_fk
+                                references dotlrn_site_templates(site_template_id)
 );
 
+
 create index dtlrn_com_all_com_par_id_idx on dotlrn_communities_all (community_id, parent_community_id);
 create index dtlrn_com_all_archived_p_idx on dotlrn_communities_all (archived_p);