Index: openacs-4/packages/dotlrn/sql/postgresql/users-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/sql/postgresql/users-create.sql,v
diff -u -N -r1.4 -r1.5
--- openacs-4/packages/dotlrn/sql/postgresql/users-create.sql	9 Aug 2002 18:39:25 -0000	1.4
+++ openacs-4/packages/dotlrn/sql/postgresql/users-create.sql	8 Aug 2006 21:26:22 -0000	1.5
@@ -35,7 +35,10 @@
     theme_id                    integer
 				constraint dotlrn_user_p_rels_theme_id_fk
                                 references portal_element_themes (theme_id),
-    id                          varchar(100)
+    id                          varchar(100),
+    site_template_id		integer
+			        constraint dotlrn_user_p_rels_site_template_id_fk
+				references dotlrn_site_templates(site_template_id)
 );
 
 create table dotlrn_user_types (
@@ -66,6 +69,7 @@
            dotlrn_user_profile_rels.portal_id,
            dotlrn_user_profile_rels.theme_id,
            dotlrn_user_profile_rels.id,
+           dotlrn_user_profile_rels.site_template_id,
            users.user_id,
            persons.first_names,
            persons.last_name,
@@ -102,3 +106,4 @@
 
 -- create external users
 \i externals-create.sql
+