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 -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
+);
Index: openacs-4/packages/acs-mail-lite/sql/postgresql/acs-mail-lite-drop.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-mail-lite/sql/postgresql/acs-mail-lite-drop.sql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/acs-mail-lite/sql/postgresql/acs-mail-lite-drop.sql	4 May 2002 18:27:52 -0000	1.1
+++ openacs-4/packages/acs-mail-lite/sql/postgresql/acs-mail-lite-drop.sql	14 Jan 2004 15:31:40 -0000	1.2
@@ -7,3 +7,6 @@
 
 drop table acs_mail_lite_queue;
 drop sequence acs_mail_lite_id_seq;
+drop table acs_mail_lite_mail_log; 
+drop table acs_mail_lite_bounce; 
+drop table acs_mail_lite_bounce_notif;
\ No newline at end of file
Index: openacs-4/packages/acs-mail-lite/sql/postgresql/upgrade/acs-mail-lite-upgrade-0.1d-0.2a.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-mail-lite/sql/postgresql/upgrade/acs-mail-lite-upgrade-0.1d-0.2a.sql,v
diff -u
--- /dev/null	1 Jan 1970 00:00:00 -0000
+++ openacs-4/packages/acs-mail-lite/sql/postgresql/upgrade/acs-mail-lite-upgrade-0.1d-0.2a.sql	14 Jan 2004 15:31:41 -0000	1.1
@@ -0,0 +1,36 @@
+alter table acs_mail_lite_queue add column package_id integer constraint acs_mail_lite_queue_pck_fk references apm_packages;
+alter table acs_mail_lite_queue add column 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
+);
+ 
\ No newline at end of file