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 -r1.1 -r1.2 --- openacs-4/packages/ref-countries/sql/oracle/ref-countries-create.sql 27 Aug 2001 22:28:07 -0000 1.1 +++ openacs-4/packages/ref-countries/sql/oracle/ref-countries-create.sql 2 Sep 2001 17:06:29 -0000 1.2 @@ -16,7 +16,7 @@ a3 char(3), -- this is the numeric code - hardly used -- it is a char because of leading zeros so it isn't really a number - numeric char(3), + n3 char(3), -- this violates 3nf but is used for 2 reasons -- 1. to help efficiency -- 2. to make querys not fail if no translation exists yet @@ -40,7 +40,7 @@ This is the three letter abbreviation - hardly used. '; -comment on column countries.numeric is ' +comment on column countries.n3 is ' This is the numeric code - hardly used. ';