Index: openacs-4/packages/dotlrn/sql/oracle/upgrade/upgrade-2.2.0d1-2.2.0d2.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/sql/oracle/upgrade/upgrade-2.2.0d1-2.2.0d2.sql,v
diff -u -r1.1.2.2 -r1.1.2.3
--- openacs-4/packages/dotlrn/sql/oracle/upgrade/upgrade-2.2.0d1-2.2.0d2.sql	15 Mar 2006 20:21:28 -0000	1.1.2.2
+++ openacs-4/packages/dotlrn/sql/oracle/upgrade/upgrade-2.2.0d1-2.2.0d2.sql	16 Mar 2006 08:46:23 -0000	1.1.2.3
@@ -110,16 +110,16 @@
 -- Store emails to be sent when user joins a community
 create table dotlrn_member_emails (
         email_id	integer primary key,
-        community_id    integer references dotlrn_communities_all
+        community_id    integer references dotlrn_communities_all (community_id)
                         on delete cascade,
 -- Might be useful
-        type            varchar2(200) default 'on join',
-        from_addr       varchar2(200),
-        subject         varchar2(200),
-        email           clob,
-        enabled_p       char(1) default 'f',
-			constraint dotlrn_member_emails_ck check(enabled_p in ('t','f')),
-	                constraint dotlrn_member_emails_un unique(community_id, type)
+        type            varchar2(30) default 'on join',
+        from_addr       varchar2(256),
+        subject         varchar2(4000),
+        email           long,
+        enabled_p       char(1) default 'f'
+	                check (enabled_p in ('t', 'f')),
+			constraint dotlrn_member_emails_un unique(community_id, type)
 );
 
 create sequence dotlrn_member_emails_seq