Index: openacs-4/packages/acs-mail-lite/sql/postgresql/acs-mail-lite-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-mail-lite/sql/postgresql/acs-mail-lite-create.sql,v
diff -u -N -r1.1 -r1.2
--- openacs-4/packages/acs-mail-lite/sql/postgresql/acs-mail-lite-create.sql	4 May 2002 18:27:52 -0000	1.1
+++ openacs-4/packages/acs-mail-lite/sql/postgresql/acs-mail-lite-create.sql	14 Jan 2004 15:31:40 -0000	1.2
@@ -11,10 +11,47 @@
     message_id                  integer
                                 constraint acs_mail_lite_queue_pk
                                 primary key,
-    to_addr                     varchar(200),
+    to_addr                     text,
     from_addr                   varchar(200),
     subject                     varchar(200),
     body                        text,
     extra_headers               text,
-    bcc                         text
+    bcc                         text,
+    package_id			integer
+    				constraint acs_mail_lite_queue_pck_fk
+				references apm_packages,
+    valid_email_p		boolean
 );
+
+create table acs_mail_lite_mail_log (
+    user_id                     integer
+                                constraint acs_mail_lite_log_user_id_fk
+                                references users (user_id)
+                                on delete cascade
+				constraint acs_mail_lite_log_pk
+				primary key,
+    last_mail_date		timestamptz default current_timestamp
+);
+
+
+create table acs_mail_lite_bounce (
+    user_id                     integer
+                                constraint acs_mail_lite_bou_user_id_fk
+                                references users (user_id)
+                                on delete cascade
+				constraint acs_mail_lite_bou_pk
+				primary key,
+    bounce_count		integer default 1
+);
+
+
+create table acs_mail_lite_bounce_notif (
+    user_id                     integer
+				constraint acs_mail_li_bou_notif_us_id_fk
+                                references users (user_id)
+                                on delete cascade
+				constraint acs_mail_lite_notif_pk
+				primary key,
+    notification_time		timestamptz default current_timestamp,
+    notification_count		integer default 0
+);