Index: unix_installer/upgrader-package/sql-scripts/updateLocales.sql =================================================================== RCS file: /usr/local/cvsroot/unix_installer/upgrader-package/sql-scripts/updateLocales.sql,v diff -u -r1.5 -r1.6 --- unix_installer/upgrader-package/sql-scripts/updateLocales.sql 26 May 2009 01:53:15 -0000 1.5 +++ unix_installer/upgrader-package/sql-scripts/updateLocales.sql 4 Jan 2011 18:57:40 -0000 1.6 @@ -1,23 +1 @@ --- Fixing Japanese language string. See LDEV-1702 --- checks if the languages in the language pack exist --- inserts rows into lams_supported_locale iff the languages dont exist -drop table if exists locale_temp; - -create table locale_temp ( - language_iso_code VARCHAR(2) NOT NULL - , country_iso_code VARCHAR(2) - , description VARCHAR(255) NOT NULL - , direction VARCHAR(3) NOT NULL - , combined VARCHAR(5) NOT NULL - , fckeditor_code VARCHAR(10) -)TYPE=InnoDB; - --- the combined column must be 'language_iso_code,country_iso_code' or 'language_iso_code'. It must match the value --- given by SELECT CONCAT_WS(',',l.language_iso_code,l.country_iso_code) FROM lams_supported_locale l - -INSERT INTO lams_supported_locale (language_iso_code, country_iso_code, description, direction, fckeditor_code) -(SELECT t.language_iso_code, t.country_iso_code, t.description, t.direction, t.fckeditor_code -FROM locale_temp t WHERE t.combined NOT IN -(SELECT CONCAT_WS(',',l.language_iso_code,l.country_iso_code) FROM lams_supported_locale l)); -drop table if exists locale_temp; - +-- No updates for locales in LAMS 2.3.5 (check previous version if needed) \ No newline at end of file