Index: openacs-4/packages/acs-kernel/sql/postgresql/acs-metadata-create.sql
===================================================================
RCS file: /usr/local/cvsroot/openacs-4/packages/acs-kernel/sql/postgresql/acs-metadata-create.sql,v
diff -u -N -r1.24 -r1.25
--- openacs-4/packages/acs-kernel/sql/postgresql/acs-metadata-create.sql	24 Sep 2006 11:45:08 -0000	1.24
+++ openacs-4/packages/acs-kernel/sql/postgresql/acs-metadata-create.sql	25 Sep 2006 17:59:16 -0000	1.25
@@ -263,9 +263,9 @@
 
 create table acs_datatypes (
 	datatype	varchar(50) not null
-			constraint acs_datatypes_pk primary key,
+			constraint acs_datatypes_datatype_pk primary key,
 	max_n_values	integer default 1
-			constraint acs_datatypes_max_n_ck
+			constraint acs_datatypes_max_n_values_ck
 			check (max_n_values > 0)
 );
 
@@ -364,7 +364,7 @@
 
 create table acs_attributes (
 	attribute_id	integer not null
-			constraint acs_attributes_pk
+			constraint acs_attributes_attribute_id_pk
 			primary key,
 	object_type	varchar(100) not null
 			constraint acs_attributes_object_type_fk
@@ -382,10 +382,10 @@
 			references acs_datatypes (datatype),
 	default_value	text,
 	min_n_values	integer default 1 not null
-			constraint acs_attributes_min_n_ck
+			constraint acs_attributes_min_n_values_ck
 			check (min_n_values >= 0),
 	max_n_values	integer default 1 not null
-			constraint acs_attributes_max_n_ck
+			constraint acs_attributes_max_n_values_ck
 			check (max_n_values >= 0),
 	storage 	varchar(13) default 'type_specific'
 			constraint acs_attributes_storage_ck