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 -r1.6 -r1.7 --- openacs-4/packages/ref-language/sql/oracle/ref-language-create.sql 13 May 2010 16:57:20 -0000 1.6 +++ openacs-4/packages/ref-language/sql/oracle/ref-language-create.sql 14 May 2010 12:22:49 -0000 1.7 @@ -6,7 +6,7 @@ -- --- ISO 639 +-- ISO 639-1 create table language_codes ( language_id char(2) constraint language_codes_language_id_pk @@ -43,3 +43,13 @@ commit; end; / + +-- Languages ISO-639-2 codes + +create table language_639_2_codes ( + iso_639_2 char(3) constraint language_codes_iso_639_2_pk primary key, + iso_639_1 char(2), + label varchar(200) +); + +comment on table language_639_2_codes is 'Contains ISO-639-2 language codes and their corresponding ISO-639-1 when it exists.';