Index: openacs-4/packages/acs-service-contract/sql/postgresql/acs-sc-tables-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-service-contract/sql/postgresql/acs-sc-tables-create.sql,v
diff -u -r1.5 -r1.6
--- openacs-4/packages/acs-service-contract/sql/postgresql/acs-sc-tables-create.sql	10 Sep 2003 14:52:01 -0000	1.5
+++ openacs-4/packages/acs-service-contract/sql/postgresql/acs-sc-tables-create.sql	25 Sep 2006 21:09:43 -0000	1.6
@@ -52,7 +52,7 @@
 			      constraint acs_sc_impls_impl_id_fk
 			      references acs_objects(object_id)
 			      on delete cascade
-			      constraint acs_sc_impls_pk
+			      constraint acs_sc_impls_impl_id_pk
 			      primary key,
     impl_name		      varchar(100),
     impl_pretty_name          varchar(200),
@@ -64,7 +64,7 @@
 
 create table acs_sc_impl_aliases (
     impl_id		      integer
-			      constraint acs_sc_impl_proc_impl_id_fk
+			      constraint acs_sc_impl_aliases_impl_id_fk
 			      references acs_sc_impls(impl_id)
 			      on delete cascade,
     impl_name		      varchar(100),
@@ -79,7 +79,7 @@
 
 create table acs_sc_bindings (
     contract_id		      integer
-			      constraint acs_sc_bindings_cid_fk
+			      constraint acs_sc_bindings_contract_id_fk
 			      references acs_sc_contracts(contract_id)
 			      on delete cascade,
     impl_id		      integer
Index: openacs-4/packages/acs-subsite/sql/postgresql/application-groups-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/sql/postgresql/application-groups-create.sql,v
diff -u -r1.9 -r1.10
--- openacs-4/packages/acs-subsite/sql/postgresql/application-groups-create.sql	11 Dec 2003 21:39:55 -0000	1.9
+++ openacs-4/packages/acs-subsite/sql/postgresql/application-groups-create.sql	25 Sep 2006 21:16:34 -0000	1.10
@@ -26,13 +26,13 @@
 
 
 create table application_groups (
-	group_id		integer constraint app_groups_group_id_fk
+	group_id		integer constraint application_groups_group_id_fk
 				references groups (group_id)
-				constraint app_groups_group_id_pk
+				constraint application_groups_group_id_pk
 				primary key,
-        package_id              integer constraint app_groups_package_id_fk
+        package_id              integer constraint application_groups_package_id_fk
                                 references apm_packages,
-                                constraint app_groups_package_id_un
+                                constraint application_groups_package_id_un
                                 unique (package_id)
 );
 
Index: openacs-4/packages/acs-subsite/sql/postgresql/email-image.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/sql/postgresql/email-image.sql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/acs-subsite/sql/postgresql/email-image.sql	22 Jan 2005 18:02:00 -0000	1.1
+++ openacs-4/packages/acs-subsite/sql/postgresql/email-image.sql	25 Sep 2006 21:16:34 -0000	1.2
@@ -4,9 +4,9 @@
 
 
 create table email_images (
-	user_id		integer constraint email_images_fk
+	user_id		integer constraint email_images_user_id_fk
 			references users
-			constraint email_images_pk
+			constraint email_images_user_id_pk
 			primary key
 );
 
Index: openacs-4/packages/acs-subsite/sql/postgresql/portraits.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/sql/postgresql/portraits.sql,v
diff -u -r1.3 -r1.4
--- openacs-4/packages/acs-subsite/sql/postgresql/portraits.sql	10 Jun 2005 09:47:23 -0000	1.3
+++ openacs-4/packages/acs-subsite/sql/postgresql/portraits.sql	25 Sep 2006 21:16:34 -0000	1.4
@@ -8,7 +8,7 @@
 create table user_portraits (
 	user_id		integer constraint user_portraits_user_id_fk
 			references users
-			constraint user_portraits_pk
+			constraint user_portraits_user_id_pk
 			primary key
 );
 
Index: openacs-4/packages/acs-subsite/sql/postgresql/upgrade/upgrade-4.1.1-4.2.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-subsite/sql/postgresql/upgrade/upgrade-4.1.1-4.2.sql,v
diff -u -r1.1 -r1.2
--- openacs-4/packages/acs-subsite/sql/postgresql/upgrade/upgrade-4.1.1-4.2.sql	12 Apr 2001 04:00:44 -0000	1.1
+++ openacs-4/packages/acs-subsite/sql/postgresql/upgrade/upgrade-4.1.1-4.2.sql	25 Sep 2006 21:16:34 -0000	1.2
@@ -32,13 +32,13 @@
 show errors
 
 create table application_groups (
-	group_id		constraint app_groups_group_id_fk
+	group_id		constraint application_groups_group_id_fk
 				references groups (group_id)
-				constraint app_groups_group_id_pk
+				constraint application_groups_group_id_pk
 				primary key,
-        package_id              constraint app_groups_package_id_fk
+        package_id              constraint application_groups_package_id_fk
                                 references apm_packages,
-                                constraint app_groups_package_id_un
+                                constraint application_groups_package_id_un
                                 unique (package_id)
 );