Index: openacs-4/packages/dotlrn/sql/postgresql/upgrade/upgrade-2.1-2.2.0d1.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/sql/postgresql/upgrade/Attic/upgrade-2.1-2.2.0d1.sql,v
diff -u -N
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/dotlrn/sql/postgresql/upgrade/upgrade-2.1-2.2.0d1.sql	27 Nov 2005 06:57:43 -0000	1.1.2.1
@@ -0,0 +1,14 @@
+
+-- Store emails to be sent when user joins a community
+create table dotlrn_member_emails (
+        email_id	serial primary key,
+        community_id    integer references dotlrn_communities_all
+                        on delete cascade,
+-- Might be useful
+        type            text default 'on join',
+        from_addr       text,
+        subject         text,
+        email           text,
+        enabled_p       boolean default 'f',
+	                constraint dotlrn_member_emails_un unique(community_id, type)
+);
