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.3 -r1.4 --- openacs-4/packages/ref-language/sql/postgresql/ref-language-create.sql 13 May 2010 16:57:20 -0000 1.3 +++ openacs-4/packages/ref-language/sql/postgresql/ref-language-create.sql 14 May 2010 12:22:49 -0000 1.4 @@ -38,3 +38,13 @@ 'http://www.iso.ch', now() ); + +-- 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.';