Index: openacs-4/packages/ref-countries/sql/oracle/ref-countries-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/ref-countries/sql/oracle/ref-countries-create.sql,v diff -u -N -r1.4 -r1.4.2.1 --- openacs-4/packages/ref-countries/sql/oracle/ref-countries-create.sql 19 May 2007 06:55:54 -0000 1.4 +++ openacs-4/packages/ref-countries/sql/oracle/ref-countries-create.sql 15 May 2010 16:38:20 -0000 1.4.2.1 @@ -15,7 +15,7 @@ default_name varchar(100) constraint countries_default_name_nn not null - constraint countries_default_name_uq + constraint countries_default_name_un unique, iso char(2) constraint countries_iso_pk Index: openacs-4/packages/ref-countries/sql/postgresql/ref-countries-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/ref-countries/sql/postgresql/ref-countries-create.sql,v diff -u -N -r1.3 -r1.3.2.1 --- openacs-4/packages/ref-countries/sql/postgresql/ref-countries-create.sql 19 May 2007 06:55:10 -0000 1.3 +++ openacs-4/packages/ref-countries/sql/postgresql/ref-countries-create.sql 15 May 2010 16:38:20 -0000 1.3.2.1 @@ -15,7 +15,7 @@ default_name varchar(100) constraint countries_default_name_nn not null - constraint countries_default_name_uq + constraint countries_default_name_un unique, iso char(2) constraint countries_iso_pk Index: openacs-4/packages/ref-language/sql/oracle/ref-language-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/ref-language/sql/oracle/ref-language-create.sql,v diff -u -N -r1.7 -r1.7.2.1 --- openacs-4/packages/ref-language/sql/oracle/ref-language-create.sql 14 May 2010 12:22:49 -0000 1.7 +++ openacs-4/packages/ref-language/sql/oracle/ref-language-create.sql 15 May 2010 16:38:20 -0000 1.7.2.1 @@ -12,7 +12,7 @@ constraint language_codes_language_id_pk primary key, name varchar(100) - constraint language_codes_name_uq + constraint language_codes_name_un unique constraint language_codes_name_nn not null Index: openacs-4/packages/ref-language/sql/postgresql/ref-language-create.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/ref-language/sql/postgresql/ref-language-create.sql,v diff -u -N -r1.4 -r1.4.2.1 --- openacs-4/packages/ref-language/sql/postgresql/ref-language-create.sql 14 May 2010 12:22:49 -0000 1.4 +++ openacs-4/packages/ref-language/sql/postgresql/ref-language-create.sql 15 May 2010 16:38:20 -0000 1.4.2.1 @@ -12,7 +12,7 @@ constraint language_codes_language_id_pk primary key, name varchar(100) - constraint language_codes_name_uq + constraint language_codes_name_un unique constraint language_codes_name_nn not null