Index: openacs-4/packages/acs-mail/sql/postgresql/acs-mail-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-mail/sql/postgresql/acs-mail-create.sql,v
diff -u -N -r1.4 -r1.5
--- openacs-4/packages/acs-mail/sql/postgresql/acs-mail-create.sql	17 May 2003 09:52:12 -0000	1.4
+++ openacs-4/packages/acs-mail/sql/postgresql/acs-mail-create.sql	25 Sep 2006 20:47:36 -0000	1.5
@@ -249,9 +249,9 @@
 
 create table acs_mail_links (
     mail_link_id integer
-				 constraint acs_mail_links_ml_id_pk 
+				 constraint acs_mail_links_mail_link_id_pk 
 				 primary key
-				 constraint acs_mail_links_ml_id_fk 
+				 constraint acs_mail_links_mail_link_id_fk 
 				 references acs_objects on delete cascade,
     body_id		 integer
 				 constraint acs_mail_links_body_id_nn 
Index: openacs-4/packages/acs-messaging/sql/postgresql/acs-messaging-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-messaging/sql/postgresql/acs-messaging-create.sql,v
diff -u -N -r1.13 -r1.14
--- openacs-4/packages/acs-messaging/sql/postgresql/acs-messaging-create.sql	30 Aug 2006 14:42:44 -0000	1.13
+++ openacs-4/packages/acs-messaging/sql/postgresql/acs-messaging-create.sql	25 Sep 2006 20:54:17 -0000	1.14
@@ -43,7 +43,7 @@
     message_id integer
         constraint acs_messages_message_id_fk
             references cr_items (item_id) on delete cascade
-        constraint acs_messages_pk
+        constraint acs_messages_message_id_pk
             primary key,
     -- we will need to find a way to make reply_to go to 0 instead of null
     -- to improve scalability
Index: openacs-4/packages/acs-reference/sql/postgresql/acs-reference-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-reference/sql/postgresql/acs-reference-create.sql,v
diff -u -N -r1.11 -r1.12
--- openacs-4/packages/acs-reference/sql/postgresql/acs-reference-create.sql	12 Mar 2004 18:48:53 -0000	1.11
+++ openacs-4/packages/acs-reference/sql/postgresql/acs-reference-create.sql	25 Sep 2006 20:57:34 -0000	1.12
@@ -41,12 +41,12 @@
     -- what is the table name we are monitoring
     table_name		varchar(100)  
 			constraint arr_table_name_nn not null
-			constraint arr_table_name_uq unique,
+			constraint arr_table_name_un unique,
     -- is this external or internal data
     internal_data_p     boolean,
     -- Does this source include pl/sql package?
     package_name	varchar(100)
-			constraint arr_package_name_uq unique,
+			constraint arr_package_name_un unique,
     -- last updated
     last_update		timestamptz,
     -- where is this data from