Index: win_installer/src/insertlocale.sql
===================================================================
diff -u -r8063641d2e87443222576129ec6712794375f03b -r320ce4ec4b1c392118bd261d2812f5da1852c8f7
--- win_installer/src/insertlocale.sql	(.../insertlocale.sql)	(revision 8063641d2e87443222576129ec6712794375f03b)
+++ win_installer/src/insertlocale.sql	(.../insertlocale.sql)	(revision 320ce4ec4b1c392118bd261d2812f5da1852c8f7)
@@ -4,13 +4,50 @@
 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 
+	if (select count(*) from lams_supported_locale where language_iso_code = _language and country_iso_code = _locale) = 0 then
+		insert lams_supported_locale
 		(language_iso_code, country_iso_code, description, direction)
-		values (_language,'_locale','_description','_rtl');
+		values (_language,_locale,_description,_rtl);
 	end if;
 END $$
 
 DELIMITER ;
 
 
+DELIMITER $$
+
+DROP PROCEDURE IF EXISTS updateLocales $$
+CREATE PROCEDURE updateLocales ()
+BEGIN
+  	/*Currently supported languages
+	 * To enter a new one, simply enter:
+	 * insertLocale(language_iso_code, country_iso_code, description, direction)
+	 * at the bottom of the code
+	 */
+	call insertLocale('en','AU','English (Australia)','LTR');
+	call insertLocale('es','ES','Español','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('it', 'IT', 'Italiano', 'LTR');
+	call insertLocale('no', 'NO', 'Norsk', 'LTR');
+	call insertLocale('sv', 'SE', 'Svenska', 'LTR');
+	call insertLocale('ko', 'KR', '한국어', 'LTR');
+	call insertLocale('pl', 'PL', 'Polski', 'LTR');
+	call insertLocale('pt', 'BR', 'Português (Brasil)', 'LTR');
+	call insertLocale('hu', 'HU', 'Magyar', '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('da', 'DK', 'Dansk', 'LTR');
+	call insertLocale('ru', 'RU', 'РуÑ?Ñ?кий', 'LTR');
+	call insertLocale('vi', 'VN', 'Tiếng Việt', 'LTR');
+	call insertLocale('zh', 'TW', 'Chinese (Taiwan)', 'LTR');
+	commit;
+
+END $$
+
+DELIMITER ;
\ No newline at end of file