Index: openacs-4/packages/dotlrn/sql/postgresql/community-memberships-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/dotlrn/sql/postgresql/community-memberships-create.sql,v
diff -u -r1.2.12.1 -r1.2.12.2
--- openacs-4/packages/dotlrn/sql/postgresql/community-memberships-create.sql	31 May 2005 23:13:04 -0000	1.2.12.1
+++ openacs-4/packages/dotlrn/sql/postgresql/community-memberships-create.sql	21 Jul 2005 22:48:54 -0000	1.2.12.2
@@ -75,3 +75,17 @@
     where dotlrn_member_rels_full.rel_id = dotlrn_admin_rels.rel_id;
 
 --
+
+-- 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)
+);