Index: openacs-4/packages/dotlrn/sql/postgresql/communities-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/sql/postgresql/communities-create.sql,v
diff -u -r1.4 -r1.5
--- openacs-4/packages/dotlrn/sql/postgresql/communities-create.sql	4 Dec 2002 09:51:03 -0000	1.4
+++ openacs-4/packages/dotlrn/sql/postgresql/communities-create.sql	8 Aug 2006 21:26:22 -0000	1.5
@@ -91,7 +91,10 @@
     header_img			varchar(100)
 				default '',
     tree_sortkey		varbit,
-    max_child_sortkey		varbit
+    max_child_sortkey		varbit,
+    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);