Index: unix_installer/upgrader-package/sql-scripts/updateLocales.sql =================================================================== diff -u -r8b9c3cf3a0178b6671e7b28e62b015d96ecb1308 -rbbaaa2530b1f8cb9163bb8baca9cfb226388be1d --- unix_installer/upgrader-package/sql-scripts/updateLocales.sql (.../updateLocales.sql) (revision 8b9c3cf3a0178b6671e7b28e62b015d96ecb1308) +++ unix_installer/upgrader-package/sql-scripts/updateLocales.sql (.../updateLocales.sql) (revision bbaaa2530b1f8cb9163bb8baca9cfb226388be1d) @@ -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