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.8.1 -r1.4.8.2
--- openacs-4/packages/dotlrn/sql/postgresql/communities-create.sql	31 May 2005 23:13:04 -0000	1.4.8.1
+++ openacs-4/packages/dotlrn/sql/postgresql/communities-create.sql	13 Dec 2005 15:32:35 -0000	1.4.8.2
@@ -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);