Index: openacs-4/packages/dotlrn/sql/oracle/users-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/sql/oracle/users-create.sql,v
diff -u -r1.5 -r1.6
--- openacs-4/packages/dotlrn/sql/oracle/users-create.sql	9 Aug 2002 18:39:24 -0000	1.5
+++ openacs-4/packages/dotlrn/sql/oracle/users-create.sql	8 Aug 2006 21:26:21 -0000	1.6
@@ -32,7 +32,10 @@
                                 not null,
     theme_id                    constraint dotlrn_user_p_rels_theme_id_fk
                                 references portal_element_themes (theme_id),
-    id                          varchar(200)
+    id                          varchar(200),
+    site_template_id		integer
+			        constraint dotlrn_upr_site_template_id_fk
+				references dotlrn_site_templates(site_template_id)
 );
 
 create table dotlrn_user_types (
@@ -60,6 +63,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,