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.7 -r1.8
--- openacs-4/packages/acs-mail-lite/sql/postgresql/acs-mail-lite-create.sql	17 Dec 2006 20:11:55 -0000	1.7
+++ openacs-4/packages/acs-mail-lite/sql/postgresql/acs-mail-lite-create.sql	22 Dec 2006 07:57:42 -0000	1.8
@@ -50,46 +50,41 @@
 				constraint acs_mail_li_bou_notif_us_id_fk
                                 references parties (party_id)
                                 on delete cascade
-				constraint acs_mail_lite_notif_pk
+				constraint acs_mail_lite_bounce_notif_pk
 				primary key,
     notification_time		timestamptz default current_timestamp,
     notification_count		integer default 0
 );
 
-CREATE TABLE acs_mail_lite_reply_prefixes
-(
-  prefix varchar(100) NOT NULL,
-  package_id int4 NOT NULL,
-  impl_name varchar(100) NOT NULL
-) ;
 
-
 CREATE TABLE acs_mail_lite_complex_queue (
-    id serial PRIMARY KEY,
-    creation_date text,
-    locking_server text,
-    to_party_ids text,
-    cc_party_ids text,
-    bcc_party_ids text,
-    to_group_ids text,
-    cc_group_ids text,
-    bcc_group_ids text,
-    to_addr text,
-    cc_addr text,
-    bcc_addr text,
-    from_addr text,
-    reply_to text,
-    subject text,
-    body text,
-    package_id integer,
-    files text,
-    file_ids text,
-    folder_ids text,
-    mime_type text,
-    object_id integer,
-    single_email_p boolean,
-    no_callback_p boolean,
-    extraheaders text,
-    alternative_part_p boolean,
-    use_sender_p boolean
+    id                  	integer
+                                constraint acs_mail_lite_complex_queue_pk
+                                primary key,
+    creation_date 		text,
+    locking_server 		text,
+    to_party_ids		text,
+    cc_party_ids 		text,
+    bcc_party_ids 		text,
+    to_group_ids 		text,
+    cc_group_ids 		text,
+    bcc_group_ids 		text,
+    to_addr 			text,
+    cc_addr 			text,
+    bcc_addr 			text,
+    from_addr 			text,
+    reply_to 			text,
+    subject 			text,
+    body 			text,
+    package_id 			integer,
+    files			text,
+    file_ids 			text,
+    folder_ids 			text,
+    mime_type 			text,
+    object_id 			integer,
+    single_email_p 		boolean,
+    no_callback_p		boolean,
+    extraheaders 		text,
+    alternative_part_p 		boolean,
+    use_sender_p 		boolean
 );