OpenACS

lars
committed
MAIN:lars:20030922184725
on 22 Sep 03
Applied patch #210: noquote
/upgrade/upgrade-5.6.0d2-5.6.0d3.sql (+2 -2)
1 1 -- Create tables for languages and countries
2 2 --
3 3 -- The tables are filled by after_install and after_upgrade apm callbacks
4 4 -- using the iso-3166-1-countries.txt and iso-639-2_utf-8.txt files
5 5
6 6
7 7 create table language_codes (
8          iso_639_2            char(3) constraint language_codes_pk primary key,
  8        iso_639_2            char(3) constraint language_codes_iso_639_2_pk primary key,
9 9        iso_639_1            char(2),
10 10        label                varchar(200)
11 11 );
12 12
13 13 comment on table language_codes is 'Contains ISO-639-2 language codes and their corresponding ISO-639-1 when it exists.';
14 14
15 15 create table country_codes (
16 16        label               varchar(200),
17          country             char(2) constraint country_codes_pk primary key
  17        country             char(2) constraint country_codes_country_pk primary key
18 18 );
19 19
20 20 comment on table country_codes is 'Contains ISO-3166 country codes';
21 21
22 22 -- update comment on ad_locales to be more accurate about how to
23 23 -- create new locales.
24 24 comment on table ad_locales is '
25 25   An OpenACS locale is identified by a language and country.
26 26   Locale definitions in Oracle consist of a language, and optionally
27 27   territory and character set.  (Languages are associated with default
28 28   territories and character sets when not defined).  The formats
29 29   for numbers, currency, dates, etc. are determined by the territory.
30 30   language is the shortest ISO 639 code (lowercase).
31 31   country is two letter (uppercase) abbrev is ISO 3166 country code
32 32   mime_charset is IANA charset name
33 33   nls_charset is  Oracle charset name
34 34 ';