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.8.1 -r1.13.8.2
--- openacs-4/packages/dotlrn/sql/oracle/communities-create.sql	31 May 2005 23:13:03 -0000	1.13.8.1
+++ openacs-4/packages/dotlrn/sql/oracle/communities-create.sql	1 Feb 2006 10:15:44 -0000	1.13.8.2
@@ -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);
 
Index: openacs-4/packages/dotlrn/sql/oracle/community-memberships-drop.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/sql/oracle/community-memberships-drop.sql,v
diff -u -r1.2.12.1 -r1.2.12.2
--- openacs-4/packages/dotlrn/sql/oracle/community-memberships-drop.sql	31 May 2005 23:13:03 -0000	1.2.12.1
+++ openacs-4/packages/dotlrn/sql/oracle/community-memberships-drop.sql	1 Feb 2006 10:15:44 -0000	1.2.12.2
@@ -23,6 +23,10 @@
 -- @version $Id$
 --
 
+
+drop trigger dotlrn_member_emails_trigger;
+drop sequence dotlrn_member_emails_seq;
+drop table dotlrn_member_emails;
 drop view dotlrn_admin_rels_full;
 drop table dotlrn_admin_rels;
 drop view dotlrn_member_rels_approved;
Index: openacs-4/packages/dotlrn/sql/oracle/dotlrn-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/sql/oracle/dotlrn-create.sql,v
diff -u -r1.20.2.1 -r1.20.2.2
--- openacs-4/packages/dotlrn/sql/oracle/dotlrn-create.sql	31 May 2005 23:13:03 -0000	1.20.2.1
+++ openacs-4/packages/dotlrn/sql/oracle/dotlrn-create.sql	1 Feb 2006 10:15:44 -0000	1.20.2.2
@@ -22,6 +22,7 @@
 -- @version $Id$
 --
 
+@@ site-templates-create.sql
 @@ users-create.sql
 @@ portal-types-create.sql
 @@ communities-create.sql
Index: openacs-4/packages/dotlrn/sql/oracle/dotlrn-drop.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/sql/oracle/dotlrn-drop.sql,v
diff -u -r1.3.12.1 -r1.3.12.2
--- openacs-4/packages/dotlrn/sql/oracle/dotlrn-drop.sql	31 May 2005 23:13:03 -0000	1.3.12.1
+++ openacs-4/packages/dotlrn/sql/oracle/dotlrn-drop.sql	1 Feb 2006 10:15:44 -0000	1.3.12.2
@@ -37,3 +37,4 @@
 @@ communities-drop.sql
 @@ portal-types-drop.sql
 @@ users-drop.sql
+@@ site-templates-drop.sql
Fisheye: Tag 1.1 refers to a dead (removed) revision in file `openacs-4/packages/dotlrn/sql/oracle/site-templates-create.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
Fisheye: Tag 1.1 refers to a dead (removed) revision in file `openacs-4/packages/dotlrn/sql/oracle/site-templates-drop.sql'.
Fisheye: No comparison available.  Pass `N' to diff?
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.12.1 -r1.5.12.2
--- openacs-4/packages/dotlrn/sql/oracle/users-create.sql	31 May 2005 23:13:04 -0000	1.5.12.1
+++ openacs-4/packages/dotlrn/sql/oracle/users-create.sql	1 Feb 2006 10:15:44 -0000	1.5.12.2
@@ -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,
Fisheye: Tag 1.1 refers to a dead (removed) revision in file `openacs-4/packages/dotlrn/sql/oracle/upgrade/upgrade-2.2.0d1-2.2.0d2.sql'.
Fisheye: No comparison available.  Pass `N' to diff?