Index: openacs-4/packages/acs-lang/sql/postgresql/upgrade/upgrade-5.1.1d1-5.1.1d2.sql =================================================================== RCS file: /usr/local/cvsroot/openacs-4/packages/acs-lang/sql/postgresql/upgrade/upgrade-5.1.1d1-5.1.1d2.sql,v diff -u -N --- /dev/null 1 Jan 1970 00:00:00 -0000 +++ openacs-4/packages/acs-lang/sql/postgresql/upgrade/upgrade-5.1.1d1-5.1.1d2.sql 29 Jun 2004 10:17:40 -0000 1.2 @@ -0,0 +1,157 @@ +-- @author Rocael Hernandez roc@viaro.net +-- Add some new locales + +insert into ad_locales + (locale, label, language, country, nls_language, nls_territory, + nls_charset, mime_charset, default_p, enabled_p) +values ('es_GT', 'Spanish (GT)', 'es', 'GT', 'SPANISH', + 'GUATEMALA', 'WE8DEC', 'ISO-8859-1', 't', 'f'); + +-- resolves bug 1519 + +---------------------------------------------------------------------- +-- ch_ZH -> zh_CN + +insert into ad_locales + (locale, label, language, country, nls_language, nls_territory, + nls_charset, mime_charset, default_p, enabled_p) + values ('zh_CN', 'Chinese (CN)', 'CH', 'ZH', 'SIMPLIFIED CHINESE', 'CHINA', 'ZHT32EUC', 'ISO-2022-CN', 't', 'f'); + +update ad_locale_user_prefs set locale='zh_CN' where locale='ch_zh'; +update lang_messages set locale='zh_CN' where locale='ch_zh'; +update lang_messages_audit set locale='zh_CN' where locale='ch_zh'; +update lang_translation_registry set locale='zh_CN' where locale='ch_zh'; + +delete from ad_locales where locale = 'ch_zh'; + + +---------------------------------------------------------------------- +-- TH_TH -> th_TH + +insert into ad_locales + (locale, label, language, country, nls_language, nls_territory, + nls_charset, mime_charset, default_p, enabled_p) + values ('th_TH', 'Thai (TH)temp', 'th', 'TH', 'THAI', 'THAILAND', 'TH8TISASCII', 'TIS-620', 't', 'f'); + +update ad_locale_user_prefs set locale='th_TH' where locale='TH_TH'; +update lang_messages set locale='th_TH' where locale='TH_TH'; +update lang_messages_audit set locale='th_TH' where locale='TH_TH'; +update lang_translation_registry set locale='th_TH' where locale='TH_TH'; + +delete from ad_locales where locale = 'TH_TH'; +-- reset the label to remove the unique constraint workaround +update ad_locales set label = 'Thai (TH)' where locale = 'th_TH'; + +---------------------------------------------------------------------- +-- AR_EG -> ar_EG + +insert into ad_locales + (locale, label, language, country, nls_language, nls_territory, + nls_charset, mime_charset, default_p, enabled_p) + values ('ar_EG', 'Arabic (EG)temp', 'ar', 'EG', 'ARABIC', 'EGYPT', 'AR8ISO8859P6', 'ISO-8859-6', 'f', 'f'); + +update ad_locale_user_prefs set locale='ar_EG' where locale='AR_EG'; +update lang_messages set locale='ar_EG' where locale='AR_EG'; +update lang_messages_audit set locale='ar_EG' where locale='AR_EG'; +update lang_translation_registry set locale='ar_EG' where locale='AR_EG'; + +delete from ad_locales where locale = 'AR_EG'; +-- reset the label to remove the unique constraint workaround +update ad_locales set label = 'Arabic (EG)' where locale = 'ar_EG'; + +---------------------------------------------------------------------- +-- AR_LB -> ar_LB + +insert into ad_locales + (locale, label, language, country, nls_language, nls_territory, + nls_charset, mime_charset, default_p, enabled_p) + values ('ar_LB', 'Arabic (LB)temp', 'ar', 'LB', 'ARABIC', 'LEBANON', 'AR8ISO8859P6', 'ISO-8859-6', 't', 'f'); + +update ad_locale_user_prefs set locale='ar_LB' where locale='AR_LB'; +update lang_messages set locale='ar_LB' where locale='AR_LB'; +update lang_messages_audit set locale='ar_LB' where locale='AR_LB'; +update lang_translation_registry set locale='ar_LB' where locale='AR_LB'; + +delete from ad_locales where locale = 'AR_LB'; +-- reset the label to remove the unique constraint workaround +update ad_locales set label = 'Arabic (LB)' where locale = 'ar_LB'; + +---------------------------------------------------------------------- +-- ms_my -> ms_MY + +insert into ad_locales + (locale, label, language, country, nls_language, nls_territory, + nls_charset, mime_charset, default_p, enabled_p) + values ('ms_MY', 'Malaysia (MY)temp', 'ms', 'MY', 'MALAY', 'MALAYSIA', 'US7ASCII', 'US-ASCII', 't', 'f'); + + +update ad_locale_user_prefs set locale='ms_MY' where locale='ms_my'; +update lang_messages set locale='ms_MY' where locale='ms_my'; +update lang_messages_audit set locale='ms_MY' where locale='ms_my'; +update lang_translation_registry set locale='ms_MY' where locale='ms_my'; + +delete from ad_locales where locale = 'ms_my'; +-- reset the label to remove the unique constraint workaround +update ad_locales set label = 'Malaysia (MY)' where locale = 'ms_MY'; + +---------------------------------------------------------------------- +-- RO_RO -> ro_RO + +insert into ad_locales + (locale, label, language, country, nls_language, nls_territory, + nls_charset, mime_charset, default_p, enabled_p) + values ('ro_RO', 'Romainian (RO)temp', 'ro', 'RO', 'ROMAINIAN', 'ROMAINIA', 'EE8ISO8859P2', 'UTF-8', 't', 'f'); + +update ad_locale_user_prefs set locale='ro_RO' where locale='RO_RO'; +update lang_messages set locale='ro_RO' where locale='RO_RO'; +update lang_messages_audit set locale='ro_RO' where locale='RO_RO'; +update lang_translation_registry set locale='ro_RO' where locale='RO_RO'; + +delete from ad_locales where locale = 'RO_RO'; +-- reset the label to remove the unique constraint workaround +update ad_locales set label = 'Romainian (RO)' where locale = 'ro_RO'; + +---------------------------------------------------------------------- +-- FA_IR -> fa_IR + +insert into ad_locales + (locale, label, language, country, nls_language, nls_territory, + nls_charset, mime_charset, default_p, enabled_p) + values ('fa_IR', 'Farsi (IR)temp', 'fa', 'IR', 'FARSI', 'IRAN', 'AL24UTFFSS', 'windows-1256', 't', 'f'); + +update ad_locale_user_prefs set locale='fa_IR' where locale='FA_IR'; +update lang_messages set locale='fa_IR' where locale='FA_IR'; +update lang_messages_audit set locale='fa_IR' where locale='FA_IR'; +update lang_translation_registry set locale='fa_IR' where locale='FA_IR'; + +delete from ad_locales where locale = 'FA_IR'; +-- reset the label to remove the unique constraint workaround +update ad_locales set label = 'Farsi (IR)' where locale = 'fa_IR'; + + +---------------------------------------------------------------------- +-- HR_HR -> hr_HR + +insert into ad_locales + (locale, label, language, country, nls_language, nls_territory, + nls_charset, mime_charset, default_p, enabled_p) + values ('hr_HR', 'Croatian (HR)temp', 'hr', 'HR', 'CROATIAN', 'CROATIA','UTF8','UTF-8','t','f'); + +update ad_locale_user_prefs set locale='hr_HR' where locale='HR_HR'; +update lang_messages set locale='hr_HR' where locale='HR_HR'; +update lang_messages_audit set locale='hr_HR' where locale='HR_HR'; +update lang_translation_registry set locale='hr_' where locale='HR_HR'; + +delete from ad_locales where locale = 'HR_HR'; +-- reset the label to remove the unique constraint workaround +update ad_locales set label = 'Croatian (HR)' where locale = 'hr_HR'; + + +---------------------------------------------------------------------- +-- trim some trailing spaces + +update ad_locales set language='tr' where language='tr '; +update ad_locales set language='hi' where language='hi '; +update ad_locales set language='ko' where language='ko '; +update ad_locales set language='zh' where language='zh '; +update ad_locales set language='hu' where language='hu ';