Index: win_installer/src/insertlocale.sql =================================================================== diff -u -r320ce4ec4b1c392118bd261d2812f5da1852c8f7 -r8f84fd5e6bf7b39ae7476080d592c363f89f1d55 --- win_installer/src/insertlocale.sql (.../insertlocale.sql) (revision 320ce4ec4b1c392118bd261d2812f5da1852c8f7) +++ win_installer/src/insertlocale.sql (.../insertlocale.sql) (revision 8f84fd5e6bf7b39ae7476080d592c363f89f1d55) @@ -1,22 +1,19 @@ -DELIMITER $$ +DELIMITER "//" -DROP PROCEDURE IF EXISTS insertlocale $$ +DROP PROCEDURE IF EXISTS insertlocale // CREATE PROCEDURE insertlocale (IN _language VARCHAR(2), IN _locale VARCHAR(2), IN _description VARCHAR(255), IN _rtl VARCHAR(3)) BEGIN if (select count(*) from lams_supported_locale where language_iso_code = _language and country_iso_code = _locale) = 0 then - insert lams_supported_locale + insert into lams_supported_locale (language_iso_code, country_iso_code, description, direction) values (_language,_locale,_description,_rtl); end if; -END $$ +END // -DELIMITER ; +DELIMITER // - -DELIMITER $$ - -DROP PROCEDURE IF EXISTS updateLocales $$ +DROP PROCEDURE IF EXISTS updateLocales // CREATE PROCEDURE updateLocales () BEGIN /*Currently supported languages @@ -26,28 +23,28 @@ */ call insertLocale('en','AU','English (Australia)','LTR'); call insertLocale('es','ES','Español','LTR'); - call insertLocale('mi', 'NZ', 'MÄ?ori', 'LTR'); + call insertLocale('mi', 'NZ', 'Māori', 'LTR'); call insertLocale('de','DE','Deutsch','LTR'); - call insertLocale('zh', 'CN', '简体中文', 'LTR'); - call insertLocale('fr', 'FR', 'Français', 'LTR'); + call insertLocale('zh', 'CN', '简体中文', 'LTR'); + call insertLocale('fr', 'FR', 'Français', 'LTR'); call insertLocale('it', 'IT', 'Italiano', 'LTR'); call insertLocale('no', 'NO', 'Norsk', 'LTR'); call insertLocale('sv', 'SE', 'Svenska', 'LTR'); - call insertLocale('ko', 'KR', '한국어', 'LTR'); + call insertLocale('ko', 'KR', '한국어', 'LTR'); call insertLocale('pl', 'PL', 'Polski', 'LTR'); - call insertLocale('pt', 'BR', 'Português (Brasil)', 'LTR'); + call insertLocale('pt', 'BR', 'Português (Brasil)', 'LTR'); call insertLocale('hu', 'HU', 'Magyar', 'LTR'); + call insertLocale('bg', 'BG', 'Български', 'LTR'); call insertLocale('cy', 'GB', 'Cymraeg (Cymru)', 'LTR'); call insertLocale('th', 'TH', 'Thai', 'LTR'); - call insertLocale('el', 'GR', 'Ελληνικά', 'LTR'); - call insertLocale('nl', 'BE', 'Nederlands (België)', 'LTR'); - call insertLocale('ar', 'JO', 'عربي', 'RTL'); + call insertLocale('el', 'GR', 'Ελληνικά', 'LTR'); + call insertLocale('nl', 'BE', 'Nederlands (België)', 'LTR'); + call insertLocale('ar', 'JO', 'عربي', 'RTL'); call insertLocale('da', 'DK', 'Dansk', 'LTR'); - call insertLocale('ru', 'RU', 'РуÑ?Ñ?кий', 'LTR'); - call insertLocale('vi', 'VN', 'Tiếng Việt', 'LTR'); + call insertLocale('ru', 'RU', 'Русский', 'LTR'); + call insertLocale('vi', 'VN', 'Tiếng Việt', 'LTR'); call insertLocale('zh', 'TW', 'Chinese (Taiwan)', 'LTR'); commit; +END // -END $$ - DELIMITER ; \ No newline at end of file