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 -r1.14
--- openacs-4/packages/dotlrn/sql/oracle/communities-create.sql	4 Dec 2002 09:51:03 -0000	1.13
+++ openacs-4/packages/dotlrn/sql/oracle/communities-create.sql	8 Aug 2006 21:26:21 -0000	1.14
@@ -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);
 
