Index: lams_common/db/sql/insert_types_data.sql =================================================================== diff -u -r871606a998d7eb07d714ac9592c178f9df6173af -r19a952c41eb3d7468438a021b7b0c806c3ee2564 --- lams_common/db/sql/insert_types_data.sql (.../insert_types_data.sql) (revision 871606a998d7eb07d714ac9592c178f9df6173af) +++ lams_common/db/sql/insert_types_data.sql (.../insert_types_data.sql) (revision 19a952c41eb3d7468438a021b7b0c806c3ee2564) @@ -215,56 +215,56 @@ 'monitoring/sequence.do?method=viewSequence', now()); -- Supported Locales -INSERT INTO lams_supported_locale (locale_id, language_iso_code, country_iso_code, description, direction) -VALUES (1, 'en', 'AU', 'English (Australia)', 'LTR'); -INSERT INTO lams_supported_locale (locale_id, language_iso_code, country_iso_code, description, direction) -VALUES (2, 'es', 'ES', 'Español', 'LTR'); -INSERT INTO lams_supported_locale (locale_id, language_iso_code, country_iso_code, description, direction) -VALUES (3, 'mi', 'NZ', 'Māori', 'LTR'); -INSERT INTO lams_supported_locale (locale_id, language_iso_code, country_iso_code, description, direction) -VALUES (4, 'de', 'DE', 'Deutsch', 'LTR'); -INSERT INTO lams_supported_locale (locale_id, language_iso_code, country_iso_code, description, direction) -VALUES (5, 'zh', 'CN', '简体中文', 'LTR'); -INSERT INTO lams_supported_locale (locale_id, language_iso_code, country_iso_code, description, direction) -VALUES (6, 'fr', 'FR', 'Français', 'LTR'); -INSERT INTO lams_supported_locale (locale_id, language_iso_code, country_iso_code, description, direction) -VALUES (7, 'it', 'IT', 'Italiano', 'LTR'); -INSERT INTO lams_supported_locale (locale_id, language_iso_code, country_iso_code, description, direction) -VALUES (8, 'no', 'NO', 'Norsk', 'LTR'); -INSERT INTO lams_supported_locale (locale_id, language_iso_code, country_iso_code, description, direction) -VALUES (9, 'sv', 'SE', 'Svenska', 'LTR'); -INSERT INTO lams_supported_locale (locale_id, language_iso_code, country_iso_code, description, direction) -VALUES (10, 'ko', 'KR', '한국어', 'LTR'); -INSERT INTO lams_supported_locale (locale_id, language_iso_code, country_iso_code, description, direction) -VALUES (11, 'pl', 'PL', 'Polski', 'LTR'); -INSERT INTO lams_supported_locale (locale_id, language_iso_code, country_iso_code, description, direction) -VALUES (12, 'pt', 'BR', 'Português (Brasil)', 'LTR'); -INSERT INTO lams_supported_locale (locale_id, language_iso_code, country_iso_code, description, direction) -VALUES (13, 'hu', 'HU', 'Magyar', 'LTR'); -INSERT INTO lams_supported_locale (locale_id, language_iso_code, country_iso_code, description, direction) -VALUES (14, 'bg', 'BG', 'Български', 'LTR'); -INSERT INTO lams_supported_locale (locale_id, language_iso_code, country_iso_code, description, direction) -VALUES (15, 'cy', 'GB', 'Cymraeg (Cymru)', 'LTR'); -INSERT INTO lams_supported_locale (locale_id, language_iso_code, country_iso_code, description, direction) -VALUES (16, 'th', 'TH', 'Thai', 'LTR'); -INSERT INTO lams_supported_locale (locale_id, language_iso_code, country_iso_code, description, direction) -VALUES (17, 'el', 'GR', 'Ελληνικά', 'LTR'); -INSERT INTO lams_supported_locale (locale_id, language_iso_code, country_iso_code, description, direction) -VALUES (18, 'nl', 'BE', 'Nederlands (België)', 'LTR'); -INSERT INTO lams_supported_locale (locale_id, language_iso_code, country_iso_code, description, direction) -VALUES (19, 'ar', 'JO', 'عربي', 'RTL'); -INSERT INTO lams_supported_locale (locale_id, language_iso_code, country_iso_code, description, direction) -VALUES (20, 'da', 'DK', 'Dansk', 'LTR'); -INSERT INTO lams_supported_locale (locale_id, language_iso_code, country_iso_code, description, direction) -VALUES (21, 'ru', 'RU', 'Русский', 'LTR'); -INSERT INTO lams_supported_locale (locale_id, language_iso_code, country_iso_code, description, direction) -VALUES (22, 'vi', 'VN', 'Tiếng Việt', 'LTR'); -INSERT INTO lams_supported_locale (locale_id, language_iso_code, country_iso_code, description, direction) -VALUES (23, 'zh', 'TW', 'Chinese (Taiwan)', 'LTR'); -INSERT INTO lams_supported_locale (locale_id, language_iso_code, country_iso_code, description, direction) -VALUES (24, 'ja', 'JP', 'Japanese (Japan)', 'LTR'); -INSERT INTO lams_supported_locale (locale_id, language_iso_code, country_iso_code, description, direction) -VALUES (25, 'ms', 'MY', 'Malay (Malaysia)', 'LTR'); +INSERT INTO lams_supported_locale (locale_id, language_iso_code, country_iso_code, description, direction, fckeditor_code) +VALUES (1, 'en', 'AU', 'English (Australia)', 'LTR', 'en-au'); +INSERT INTO lams_supported_locale (locale_id, language_iso_code, country_iso_code, description, direction, fckeditor_code) +VALUES (2, 'es', 'ES', 'Español', 'LTR', 'es'); +INSERT INTO lams_supported_locale (locale_id, language_iso_code, country_iso_code, description, direction, fckeditor_code) +VALUES (3, 'mi', 'NZ', 'Māori', 'LTR', 'en-au'); +INSERT INTO lams_supported_locale (locale_id, language_iso_code, country_iso_code, description, direction, fckeditor_code) +VALUES (4, 'de', 'DE', 'Deutsch', 'LTR', 'de'); +INSERT INTO lams_supported_locale (locale_id, language_iso_code, country_iso_code, description, direction, fckeditor_code) +VALUES (5, 'zh', 'CN', '简体中文', 'LTR', 'zh-cn'); +INSERT INTO lams_supported_locale (locale_id, language_iso_code, country_iso_code, description, direction, fckeditor_code) +VALUES (6, 'fr', 'FR', 'Français', 'LTR', 'fr'); +INSERT INTO lams_supported_locale (locale_id, language_iso_code, country_iso_code, description, direction, fckeditor_code) +VALUES (7, 'it', 'IT', 'Italiano', 'LTR', 'it'); +INSERT INTO lams_supported_locale (locale_id, language_iso_code, country_iso_code, description, direction, fckeditor_code) +VALUES (8, 'no', 'NO', 'Norsk', 'LTR', 'no'); +INSERT INTO lams_supported_locale (locale_id, language_iso_code, country_iso_code, description, direction, fckeditor_code) +VALUES (9, 'sv', 'SE', 'Svenska', 'LTR', 'sv'); +INSERT INTO lams_supported_locale (locale_id, language_iso_code, country_iso_code, description, direction, fckeditor_code) +VALUES (10, 'ko', 'KR', '한국어', 'LTR', 'ko'); +INSERT INTO lams_supported_locale (locale_id, language_iso_code, country_iso_code, description, direction, fckeditor_code) +VALUES (11, 'pl', 'PL', 'Polski', 'LTR', 'pl'); +INSERT INTO lams_supported_locale (locale_id, language_iso_code, country_iso_code, description, direction, fckeditor_code) +VALUES (12, 'pt', 'BR', 'Português (Brasil)', 'LTR', 'pt-br'); +INSERT INTO lams_supported_locale (locale_id, language_iso_code, country_iso_code, description, direction, fckeditor_code) +VALUES (13, 'hu', 'HU', 'Magyar', 'LTR', 'hu'); +INSERT INTO lams_supported_locale (locale_id, language_iso_code, country_iso_code, description, direction, fckeditor_code) +VALUES (14, 'bg', 'BG', 'Български', 'LTR', 'bg'); +INSERT INTO lams_supported_locale (locale_id, language_iso_code, country_iso_code, description, direction, fckeditor_code) +VALUES (15, 'cy', 'GB', 'Cymraeg (Cymru)', 'LTR', 'en-au'); +INSERT INTO lams_supported_locale (locale_id, language_iso_code, country_iso_code, description, direction, fckeditor_code) +VALUES (16, 'th', 'TH', 'Thai', 'LTR', 'th'); +INSERT INTO lams_supported_locale (locale_id, language_iso_code, country_iso_code, description, direction, fckeditor_code) +VALUES (17, 'el', 'GR', 'Ελληνικά', 'LTR', 'el'); +INSERT INTO lams_supported_locale (locale_id, language_iso_code, country_iso_code, description, direction, fckeditor_code) +VALUES (18, 'nl', 'BE', 'Nederlands (België)', 'LTR', 'nl'); +INSERT INTO lams_supported_locale (locale_id, language_iso_code, country_iso_code, description, direction, fckeditor_code) +VALUES (19, 'ar', 'JO', 'عربي', 'RTL', 'ar'); +INSERT INTO lams_supported_locale (locale_id, language_iso_code, country_iso_code, description, direction, fckeditor_code) +VALUES (20, 'da', 'DK', 'Dansk', 'LTR', 'da'); +INSERT INTO lams_supported_locale (locale_id, language_iso_code, country_iso_code, description, direction, fckeditor_code) +VALUES (21, 'ru', 'RU', 'Русский', 'LTR', 'ru'); +INSERT INTO lams_supported_locale (locale_id, language_iso_code, country_iso_code, description, direction, fckeditor_code) +VALUES (22, 'vi', 'VN', 'Tiếng Việt', 'LTR', 'vi'); +INSERT INTO lams_supported_locale (locale_id, language_iso_code, country_iso_code, description, direction, fckeditor_code) +VALUES (23, 'zh', 'TW', 'Chinese (Taiwan)', 'LTR', 'zh'); +INSERT INTO lams_supported_locale (locale_id, language_iso_code, country_iso_code, description, direction, fckeditor_code) +VALUES (24, 'ja', 'JP', 'Japanese (Japan)', 'LTR', 'ja'); +INSERT INTO lams_supported_locale (locale_id, language_iso_code, country_iso_code, description, direction, fckeditor_code) +VALUES (25, 'ms', 'MY', 'Malay (Malaysia)', 'LTR', 'ms'); -- which current tool supports the old 1.0.x tools? INSERT INTO lams_tool_import_support VALUES (1, 'lafrum11', 'messageboard'); Index: lams_common/db/sql/updatescripts/alter_21_groupings_fckeditor.sql =================================================================== diff -u -r7bbde598d2ac8811abb59813b3da4ac67349fe66 -r19a952c41eb3d7468438a021b7b0c806c3ee2564 --- lams_common/db/sql/updatescripts/alter_21_groupings_fckeditor.sql (.../alter_21_groupings_fckeditor.sql) (revision 7bbde598d2ac8811abb59813b3da4ac67349fe66) +++ lams_common/db/sql/updatescripts/alter_21_groupings_fckeditor.sql (.../alter_21_groupings_fckeditor.sql) (revision 19a952c41eb3d7468438a021b7b0c806c3ee2564) @@ -6,4 +6,32 @@ -- See LDEV-1349 alter table lams_supported_locale -ADD COLUMN fckeditor_code VARCHAR(10); \ No newline at end of file +ADD COLUMN fckeditor_code VARCHAR(10); + + +UPDATE lams_supported_locale SET fckeditor_code='en-au' WHERE language_iso_code='en' AND country_iso_code='AU'; +UPDATE lams_supported_locale SET fckeditor_code='es' WHERE language_iso_code='es' AND country_iso_code='ES'; +UPDATE lams_supported_locale SET fckeditor_code='en-au' WHERE language_iso_code='mi' AND country_iso_code='NZ'; +UPDATE lams_supported_locale SET fckeditor_code='de' WHERE language_iso_code='de' AND country_iso_code='DE'; +UPDATE lams_supported_locale SET fckeditor_code='zh-cn' WHERE language_iso_code='zh' AND country_iso_code='CN'; +UPDATE lams_supported_locale SET fckeditor_code='fr' WHERE language_iso_code='fr' AND country_iso_code='FR'; +UPDATE lams_supported_locale SET fckeditor_code='it' WHERE language_iso_code='it' AND country_iso_code='IT'; +UPDATE lams_supported_locale SET fckeditor_code='no' WHERE language_iso_code='no' AND country_iso_code='NO'; +UPDATE lams_supported_locale SET fckeditor_code='sv' WHERE language_iso_code='sv' AND country_iso_code='SE'; +UPDATE lams_supported_locale SET fckeditor_code='ko' WHERE language_iso_code='ko' AND country_iso_code='KR'; +UPDATE lams_supported_locale SET fckeditor_code='pl' WHERE language_iso_code='pl' AND country_iso_code='PL'; +UPDATE lams_supported_locale SET fckeditor_code='pt-br' WHERE language_iso_code='pt' AND country_iso_code='BR'; +UPDATE lams_supported_locale SET fckeditor_code='hu' WHERE language_iso_code='hu' AND country_iso_code='HU'; +UPDATE lams_supported_locale SET fckeditor_code='bg' WHERE language_iso_code='bg' AND country_iso_code='BG'; +UPDATE lams_supported_locale SET fckeditor_code='en-au' WHERE language_iso_code='cy' AND country_iso_code='GB'; +UPDATE lams_supported_locale SET fckeditor_code='th' WHERE language_iso_code='th' AND country_iso_code='TH'; +UPDATE lams_supported_locale SET fckeditor_code='el' WHERE language_iso_code='el' AND country_iso_code='GR'; +UPDATE lams_supported_locale SET fckeditor_code='nl' WHERE language_iso_code='nl' AND country_iso_code='BE'; +UPDATE lams_supported_locale SET fckeditor_code='ar' WHERE language_iso_code='ar' AND country_iso_code='JO'; +UPDATE lams_supported_locale SET fckeditor_code='da' WHERE language_iso_code='da' AND country_iso_code='DK'; +UPDATE lams_supported_locale SET fckeditor_code='ru' WHERE language_iso_code='ru' AND country_iso_code='RU'; +UPDATE lams_supported_locale SET fckeditor_code='vi' WHERE language_iso_code='vi' AND country_iso_code='VN'; +UPDATE lams_supported_locale SET fckeditor_code='zh' WHERE language_iso_code='zh' AND country_iso_code='TW'; +UPDATE lams_supported_locale SET fckeditor_code='ja' WHERE language_iso_code='ja' AND country_iso_code='JP'; +UPDATE lams_supported_locale SET fckeditor_code='ms' WHERE language_iso_code='ms' AND country_iso_code='MY'; +