Index: openacs-4/packages/acs-lang/sql/oracle/upgrade/upgrade-5.6.0d2-5.6.0d3.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-lang/sql/oracle/upgrade/upgrade-5.6.0d2-5.6.0d3.sql,v diff -u -N -r1.2 -r1.2.2.1 --- openacs-4/packages/acs-lang/sql/oracle/upgrade/upgrade-5.6.0d2-5.6.0d3.sql 22 Mar 2010 01:24:07 -0000 1.2 +++ openacs-4/packages/acs-lang/sql/oracle/upgrade/upgrade-5.6.0d2-5.6.0d3.sql 14 May 2010 13:15:45 -0000 1.2.2.1 @@ -1,26 +1,6 @@ --- Create tables for languages and countries --- --- The tables are filled by after_install and after_upgrade apm callbacks --- using the iso-3166-1-countries.txt and iso-639-2_utf-8.txt files - - -create table language_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_codes is 'Contains ISO-639-2 language codes and their corresponding ISO-639-1 when it exists.'; - -create table country_codes ( - label varchar(200), - country char(2) constraint country_codes_country_pk primary key -); - -comment on table country_codes is 'Contains ISO-3166 country codes'; - -- update comment on ad_locales to be more accurate about how to -- create new locales. + comment on table ad_locales is ' An OpenACS locale is identified by a language and country. Locale definitions in Oracle consist of a language, and optionally