Index: branches/RC/core/install/upgrades.sql
===================================================================
diff -u -N -r10974 -r10975
--- branches/RC/core/install/upgrades.sql	(.../upgrades.sql)	(revision 10974)
+++ branches/RC/core/install/upgrades.sql	(.../upgrades.sql)	(revision 10975)
@@ -375,4 +375,224 @@
 INSERT INTO Permissions VALUES (DEFAULT, 'in-portal:ban_rulelist.edit', 11, 1, 1, 0);
 INSERT INTO Permissions VALUES (DEFAULT, 'in-portal:ban_rulelist.add', 11, 1, 1, 0);
 
-ALTER TABLE Language ADD `Locale` varchar(10) NOT NULL default 'en-US';
\ No newline at end of file
+ALTER TABLE Language ADD `Locale` varchar(10) NOT NULL default 'en-US';
+
+CREATE TABLE LocalesList (
+  `id` int(11) NOT NULL auto_increment,
+  `LocaleIdentifier` varchar(6) character set latin1 NOT NULL default '',
+  `LocaleName` varchar(255) character set latin1 NOT NULL default '',
+  `Locale` varchar(20) character set latin1 NOT NULL default '',
+  `ScriptTag` varchar(255) character set latin1 NOT NULL default '',
+  `ANSICodePage` varchar(10) character set latin1 NOT NULL default '',
+  PRIMARY KEY  (`id`)
+);
+
+INSERT INTO LocalesList VALUES
+(1, '0x0436', 'Afrikaans (South Africa)', 'af-ZA', 'Latn', '1252'),
+(2, '0x041c', 'Albanian (Albania)', 'sq-AL', 'Latn', '1252'),
+(3, '0x0484', 'Alsatian (France)', 'gsw-FR', '', ''),
+(4, '0x045e', 'Amharic (Ethiopia)', 'am-ET', '', 'UTF-8'),
+(5, '0x1401', 'Arabic (Algeria)', 'ar-DZ', 'Arab', '1256'),
+(6, '0x3c01', 'Arabic (Bahrain)', 'ar-BH', 'Arab', '1256'),
+(7, '0x0c01', 'Arabic (Egypt)', 'ar-EG', 'Arab', '1256'),
+(8, '0x0801', 'Arabic (Iraq)', 'ar-IQ', 'Arab', '1256'),
+(9, '0x2c01', 'Arabic (Jordan)', 'ar-JO', 'Arab', '1256'),
+(10, '0x3401', 'Arabic (Kuwait)', 'ar-KW', 'Arab', '1256'),
+(11, '0x3001', 'Arabic (Lebanon)', 'ar-LB', 'Arab', '1256'),
+(12, '0x1001', 'Arabic (Libya)', 'ar-LY', 'Arab', '1256'),
+(13, '0x1801', 'Arabic (Morocco)', 'ar-MA', 'Arab', '1256'),
+(14, '0x2001', 'Arabic (Oman)', 'ar-OM', 'Arab', '1256'),
+(15, '0x4001', 'Arabic (Qatar)', 'ar-QA', 'Arab', '1256'),
+(16, '0x0401', 'Arabic (Saudi Arabia)', 'ar-SA', 'Arab', '1256'),
+(17, '0x2801', 'Arabic (Syria)', 'ar-SY', 'Arab', '1256'),
+(18, '0x1c01', 'Arabic (Tunisia)', 'ar-TN', 'Arab', '1256'),
+(19, '0x3801', 'Arabic (U.A.E.)', 'ar-AE', 'Arab', '1256'),
+(20, '0x2401', 'Arabic (Yemen)', 'ar-YE', 'Arab', '1256'),
+(21, '0x042b', 'Armenian (Armenia)', 'hy-AM', 'Armn', 'UTF-8'),
+(22, '0x044d', 'Assamese (India)', 'as-IN', '', 'UTF-8'),
+(23, '0x082c', 'Azeri (Azerbaijan, Cyrillic)', 'az-Cyrl-AZ', 'Cyrl', '1251'),
+(24, '0x042c', 'Azeri (Azerbaijan, Latin)', 'az-Latn-AZ', 'Latn', '1254'),
+(25, '0x046d', 'Bashkir (Russia)', 'ba-RU', '', ''),
+(26, '0x042d', 'Basque (Basque)', 'eu-ES', 'Latn', '1252'),
+(27, '0x0423', 'Belarusian (Belarus)', 'be-BY', 'Cyrl', '1251'),
+(28, '0x0445', 'Bengali (India)', 'bn-IN', 'Beng', 'UTF-8'),
+(29, '0x201a', 'Bosnian (Bosnia and Herzegovina, Cyrillic)', 'bs-Cyrl-BA', 'Cyrl', '1251'),
+(30, '0x141a', 'Bosnian (Bosnia and Herzegovina, Latin)', 'bs-Latn-BA', 'Latn', '1250'),
+(31, '0x047e', 'Breton (France)', 'br-FR', 'Latn', '1252'),
+(32, '0x0402', 'Bulgarian (Bulgaria)', 'bg-BG', 'Cyrl', '1251'),
+(33, '0x0403', 'Catalan (Catalan)', 'ca-ES', 'Latn', '1252'),
+(34, '0x0c04', 'Chinese (Hong Kong SAR, PRC)', 'zh-HK', 'Hant', '950'),
+(35, '0x1404', 'Chinese (Macao SAR)', 'zh-MO', 'Hant', '950'),
+(36, '0x0804', 'Chinese (PRC)', 'zh-CN', 'Hans', '936'),
+(37, '0x1004', 'Chinese (Singapore)', 'zh-SG', 'Hans', '936'),
+(38, '0x0404', 'Chinese (Taiwan)', 'zh-TW', 'Hant', '950'),
+(39, '0x101a', 'Croatian (Bosnia and Herzegovina, Latin)', 'hr-BA', 'Latn', '1250'),
+(40, '0x041a', 'Croatian (Croatia)', 'hr-HR', 'Latn', '1250'),
+(41, '0x0405', 'Czech (Czech Republic)', 'cs-CZ', 'Latn', '1250'),
+(42, '0x0406', 'Danish (Denmark)', 'da-DK', 'Latn', '1252'),
+(43, '0x048c', 'Dari (Afghanistan)', 'prs-AF', 'Arab', '1256'),
+(44, '0x0465', 'Divehi (Maldives)', 'dv-MV', 'Thaa', 'UTF-8'),
+(45, '0x0813', 'Dutch (Belgium)', 'nl-BE', 'Latn', '1252'),
+(46, '0x0413', 'Dutch (Netherlands)', 'nl-NL', 'Latn', '1252'),
+(47, '0x0c09', 'English (Australia)', 'en-AU', 'Latn', '1252'),
+(48, '0x2809', 'English (Belize)', 'en-BZ', 'Latn', '1252'),
+(49, '0x1009', 'English (Canada)', 'en-CA', 'Latn', '1252'),
+(50, '0x2409', 'English (Caribbean)', 'en-029', 'Latn', '1252'),
+(51, '0x4009', 'English (India)', 'en-IN', 'Latn', '1252'),
+(52, '0x1809', 'English (Ireland)', 'en-IE', 'Latn', '1252'),
+(53, '0x2009', 'English (Jamaica)', 'en-JM', 'Latn', '1252'),
+(54, '0x4409', 'English (Malaysia)', 'en-MY', 'Latn', '1252'),
+(55, '0x1409', 'English (New Zealand)', 'en-NZ', 'Latn', '1252'),
+(56, '0x3409', 'English (Philippines)', 'en-PH', 'Latn', '1252'),
+(57, '0x4809', 'English (Singapore)', 'en-SG', 'Latn', '1252'),
+(58, '0x1c09', 'English (South Africa)', 'en-ZA', 'Latn', '1252'),
+(59, '0x2c09', 'English (Trinidad and Tobago)', 'en-TT', 'Latn', '1252'),
+(60, '0x0809', 'English (United Kingdom)', 'en-GB', 'Latn', '1252'),
+(61, '0x0409', 'English (United States)', 'en-US', 'Latn', '1252'),
+(62, '0x3009', 'English (Zimbabwe)', 'en-ZW', 'Latn', '1252'),
+(63, '0x0425', 'Estonian (Estonia)', 'et-EE', 'Latn', '1257'),
+(64, '0x0438', 'Faroese (Faroe Islands)', 'fo-FO', 'Latn', '1252'),
+(65, '0x0464', 'Filipino (Philippines)', 'fil-PH', 'Latn', '1252'),
+(66, '0x040b', 'Finnish (Finland)', 'fi-FI', 'Latn', '1252'),
+(67, '0x080c', 'French (Belgium)', 'fr-BE', 'Latn', '1252'),
+(68, '0x0c0c', 'French (Canada)', 'fr-CA', 'Latn', '1252'),
+(69, '0x040c', 'French (France)', 'fr-FR', 'Latn', '1252'),
+(70, '0x140c', 'French (Luxembourg)', 'fr-LU', 'Latn', '1252'),
+(71, '0x180c', 'French (Monaco)', 'fr-MC', 'Latn', '1252'),
+(72, '0x100c', 'French (Switzerland)', 'fr-CH', 'Latn', '1252'),
+(73, '0x0462', 'Frisian (Netherlands)', 'fy-NL', 'Latn', '1252'),
+(74, '0x0456', 'Galician (Spain)', 'gl-ES', 'Latn', '1252'),
+(75, '0x0437', 'Georgian (Georgia)', 'ka-GE', 'Geor', 'UTF-8'),
+(76, '0x0c07', 'German (Austria)', 'de-AT', 'Latn', '1252'),
+(77, '0x0407', 'German (Germany)', 'de-DE', 'Latn', '1252'),
+(78, '0x1407', 'German (Liechtenstein)', 'de-LI', 'Latn', '1252'),
+(79, '0x1007', 'German (Luxembourg)', 'de-LU', 'Latn', '1252'),
+(80, '0x0807', 'German (Switzerland)', 'de-CH', 'Latn', '1252'),
+(81, '0x0408', 'Greek (Greece)', 'el-GR', 'Grek', '1253'),
+(82, '0x046f', 'Greenlandic (Greenland)', 'kl-GL', 'Latn', '1252'),
+(83, '0x0447', 'Gujarati (India)', 'gu-IN', 'Gujr', 'UTF-8'),
+(84, '0x0468', 'Hausa (Nigeria, Latin)', 'ha-Latn-NG', 'Latn', '1252'),
+(85, '0x040d', 'Hebrew (Israel)', 'he-IL', 'Hebr', '1255'),
+(86, '0x0439', 'Hindi (India)', 'hi-IN', 'Deva', 'UTF-8'),
+(87, '0x040e', 'Hungarian (Hungary)', 'hu-HU', 'Latn', '1250'),
+(88, '0x040f', 'Icelandic (Iceland)', 'is-IS', 'Latn', '1252'),
+(89, '0x0470', 'Igbo (Nigeria)', 'ig-NG', '', ''),
+(90, '0x0421', 'Indonesian (Indonesia)', 'id-ID', 'Latn', '1252'),
+(91, '0x085d', 'Inuktitut (Canada, Latin)', 'iu-Latn-CA', 'Latn', '1252'),
+(92, '0x045d', 'Inuktitut (Canada, Syllabics)', 'iu-Cans-CA', 'Cans', 'UTF-8'),
+(93, '0x083c', 'Irish (Ireland)', 'ga-IE', 'Latn', '1252'),
+(94, '0x0410', 'Italian (Italy)', 'it-IT', 'Latn', '1252'),
+(95, '0x0810', 'Italian (Switzerland)', 'it-CH', 'Latn', '1252'),
+(96, '0x0411', 'Japanese (Japan)', 'ja-JP', 'Hani;Hira;Kana', '932'),
+(97, '0x044b', 'Kannada (India)', 'kn-IN', 'Knda', 'UTF-8'),
+(98, '0x043f', 'Kazakh (Kazakhstan)', 'kk-KZ', 'Cyrl', '1251'),
+(99, '0x0453', 'Khmer (Cambodia)', 'kh-KH', 'Khmr', 'UTF-8'),
+(100, '0x0486', 'K''iche (Guatemala)', 'qut-GT', 'Latn', '1252'),
+(101, '0x0487', 'Kinyarwanda (Rwanda)', 'rw-RW', 'Latn', '1252'),
+(102, '0x0457', 'Konkani (India)', 'kok-IN', 'Deva', 'UTF-8'),
+(103, '0x0812', 'Windows 95, Windows NT 4.0 only: Korean (Johab)', '', '', ''),
+(104, '0x0412', 'Korean (Korea)', 'ko-KR', 'Hang;Hani', '949'),
+(105, '0x0440', 'Kyrgyz (Kyrgyzstan)', 'ky-KG', 'Cyrl', '1251'),
+(106, '0x0454', 'Lao (Lao PDR)', 'lo-LA', 'Laoo', 'UTF-8'),
+(107, '0x0426', 'Latvian (Latvia)', 'lv-LV', 'Latn', '1257'),
+(108, '0x0427', 'Lithuanian (Lithuania)', 'lt-LT', 'Latn', '1257'),
+(109, '0x082e', 'Lower Sorbian (Germany)', 'dsb-DE', 'Latn', '1252'),
+(110, '0x046e', 'Luxembourgish (Luxembourg)', 'lb-LU', 'Latn', '1252'),
+(111, '0x042f', 'Macedonian (Macedonia, FYROM)', 'mk-MK', 'Cyrl', '1251'),
+(112, '0x083e', 'Malay (Brunei Darussalam)', 'ms-BN', 'Latn', '1252'),
+(113, '0x043e', 'Malay (Malaysia)', 'ms-MY', 'Latn', '1252'),
+(114, '0x044c', 'Malayalam (India)', 'ml-IN', 'Mlym', 'UTF-8'),
+(115, '0x043a', 'Maltese (Malta)', 'mt-MT', 'Latn', '1252'),
+(116, '0x0481', 'Maori (New Zealand)', 'mi-NZ', 'Latn', '1252'),
+(117, '0x047a', 'Mapudungun (Chile)', 'arn-CL', 'Latn', '1252'),
+(118, '0x044e', 'Marathi (India)', 'mr-IN', 'Deva', 'UTF-8'),
+(119, '0x047c', 'Mohawk (Canada)', 'moh-CA', 'Latn', '1252'),
+(120, '0x0450', 'Mongolian (Mongolia)', 'mn-Cyrl-MN', 'Cyrl', '1251'),
+(121, '0x0850', 'Mongolian (PRC)', 'mn-Mong-CN', 'Mong', 'UTF-8'),
+(122, '0x0850', 'Nepali (India)', 'ne-IN', '__', 'UTF-8'),
+(123, '0x0461', 'Nepali (Nepal)', 'ne-NP', 'Deva', 'UTF-8'),
+(124, '0x0414', 'Norwegian (Bokmål, Norway)', 'nb-NO', 'Latn', '1252'),
+(125, '0x0814', 'Norwegian (Nynorsk, Norway)', 'nn-NO', 'Latn', '1252'),
+(126, '0x0482', 'Occitan (France)', 'oc-FR', 'Latn', '1252'),
+(127, '0x0448', 'Oriya (India)', 'or-IN', 'Orya', 'UTF-8'),
+(128, '0x0463', 'Pashto (Afghanistan)', 'ps-AF', '', ''),
+(129, '0x0429', 'Persian (Iran)', 'fa-IR', 'Arab', '1256'),
+(130, '0x0415', 'Polish (Poland)', 'pl-PL', 'Latn', '1250'),
+(131, '0x0416', 'Portuguese (Brazil)', 'pt-BR', 'Latn', '1252'),
+(132, '0x0816', 'Portuguese (Portugal)', 'pt-PT', 'Latn', '1252'),
+(133, '0x0446', 'Punjabi (India)', 'pa-IN', 'Guru', 'UTF-8'),
+(134, '0x046b', 'Quechua (Bolivia)', 'quz-BO', 'Latn', '1252'),
+(135, '0x086b', 'Quechua (Ecuador)', 'quz-EC', 'Latn', '1252'),
+(136, '0x0c6b', 'Quechua (Peru)', 'quz-PE', 'Latn', '1252'),
+(137, '0x0418', 'Romanian (Romania)', 'ro-RO', 'Latn', '1250'),
+(138, '0x0417', 'Romansh (Switzerland)', 'rm-CH', 'Latn', '1252'),
+(139, '0x0419', 'Russian (Russia)', 'ru-RU', 'Cyrl', '1251'),
+(140, '0x243b', 'Sami (Inari, Finland)', 'smn-FI', 'Latn', '1252'),
+(141, '0x103b', 'Sami (Lule, Norway)', 'smj-NO', 'Latn', '1252'),
+(142, '0x143b', 'Sami (Lule, Sweden)', 'smj-SE', 'Latn', '1252'),
+(143, '0x0c3b', 'Sami (Northern, Finland)', 'se-FI', 'Latn', '1252'),
+(144, '0x043b', 'Sami (Northern, Norway)', 'se-NO', 'Latn', '1252'),
+(145, '0x083b', 'Sami (Northern, Sweden)', 'se-SE', 'Latn', '1252'),
+(146, '0x203b', 'Sami (Skolt, Finland)', 'sms-FI', 'Latn', '1252'),
+(147, '0x183b', 'Sami (Southern, Norway)', 'sma-NO', 'Latn', '1252'),
+(148, '0x1c3b', 'Sami (Southern, Sweden)', 'sma-SE', 'Latn', '1252'),
+(149, '0x044f', 'Sanskrit (India)', 'sa-IN', 'Deva', 'UTF-8'),
+(150, '0x1c1a', 'Serbian (Bosnia and Herzegovina, Cyrillic)', 'sr-Cyrl-BA', 'Cyrl', '1251'),
+(151, '0x181a', 'Serbian (Bosnia and Herzegovina, Latin)', 'sr-Latn-BA', 'Latn', '1250'),
+(152, '0x0c1a', 'Serbian (Serbia, Cyrillic)', 'sr-Cyrl-CS', 'Cyrl', '1251'),
+(153, '0x081a', 'Serbian (Serbia, Latin)', 'sr-Latn-CS', 'Latn', '1250'),
+(154, '0x046c', 'Sesotho sa Leboa/Northern Sotho (South Africa)', 'ns-ZA', 'Latn', '1252'),
+(155, '0x0432', 'Setswana/Tswana (South Africa)', 'tn-ZA', 'Latn', '1252'),
+(156, '0x045b', 'Sinhala (Sri Lanka)', 'si-LK', 'Sinh', 'UTF-8'),
+(157, '0x041b', 'Slovak (Slovakia)', 'sk-SK', 'Latn', '1250'),
+(158, '0x0424', 'Slovenian (Slovenia)', 'sl-SI', 'Latn', '1250'),
+(159, '0x2c0a', 'Spanish (Argentina)', 'es-AR', 'Latn', '1252'),
+(160, '0x400a', 'Spanish (Bolivia)', 'es-BO', 'Latn', '1252'),
+(161, '0x340a', 'Spanish (Chile)', 'es-CL', 'Latn', '1252'),
+(162, '0x240a', 'Spanish (Colombia)', 'es-CO', 'Latn', '1252'),
+(163, '0x140a', 'Spanish (Costa Rica)', 'es-CR', 'Latn', '1252'),
+(164, '0x1c0a', 'Spanish (Dominican Republic)', 'es-DO', 'Latn', '1252'),
+(165, '0x300a', 'Spanish (Ecuador)', 'es-EC', 'Latn', '1252'),
+(166, '0x440a', 'Spanish (El Salvador)', 'es-SV', 'Latn', '1252'),
+(167, '0x100a', 'Spanish (Guatemala)', 'es-GT', 'Latn', '1252'),
+(168, '0x480a', 'Spanish (Honduras)', 'es-HN', 'Latn', '1252'),
+(169, '0x080a', 'Spanish (Mexico)', 'es-MX', 'Latn', '1252'),
+(170, '0x4c0a', 'Spanish (Nicaragua)', 'es-NI', 'Latn', '1252'),
+(171, '0x180a', 'Spanish (Panama)', 'es-PA', 'Latn', '1252'),
+(172, '0x3c0a', 'Spanish (Paraguay)', 'es-PY', 'Latn', '1252'),
+(173, '0x280a', 'Spanish (Peru)', 'es-PE', 'Latn', '1252'),
+(174, '0x500a', 'Spanish (Puerto Rico)', 'es-PR', 'Latn', '1252'),
+(175, '0x0c0a', 'Spanish (Spain)', 'es-ES', 'Latn', '1252'),
+(176, '0x040a', 'Spanish (Spain, Traditional Sort)', 'es-ES_tradnl', 'Latn', '1252'),
+(177, '0x540a', 'Spanish (United States)', 'es-US', '', ''),
+(178, '0x380a', 'Spanish (Uruguay)', 'es-UY', 'Latn', '1252'),
+(179, '0x200a', 'Spanish (Venezuela)', 'es-VE', 'Latn', '1252'),
+(180, '0x0441', 'Swahili (Kenya)', 'sw-KE', 'Latn', '1252'),
+(181, '0x081d', 'Swedish (Finland)', 'sv-FI', 'Latn', '1252'),
+(182, '0x041d', 'Swedish (Sweden)', 'sv-SE', 'Latn', '1252'),
+(183, '0x045a', 'Syriac (Syria)', 'syr-SY', 'Syrc', 'UTF-8'),
+(184, '0x0428', 'Tajik (Tajikistan)', 'tg-Cyrl-TJ', 'Cyrl', '1251'),
+(185, '0x085f', 'Tamazight (Algeria, Latin)', 'tzm-Latn-DZ', 'Latn', '1252'),
+(186, '0x0449', 'Tamil (India)', 'ta-IN', 'Taml', 'UTF-8'),
+(187, '0x0444', 'Tatar (Russia)', 'tt-RU', 'Cyrl', '1251'),
+(188, '0x044a', 'Telugu (India)', 'te-IN', 'Telu', 'UTF-8'),
+(189, '0x041e', 'Thai (Thailand)', 'th-TH', 'Thai', '874'),
+(190, '0x0851', 'Tibetan (Bhutan)', 'bo-BT', 'Tibt', 'UTF-8'),
+(191, '0x0451', 'Tibetan (PRC)', 'bo-CN', 'Tibt', 'UTF-8'),
+(192, '0x041f', 'Turkish (Turkey)', 'tr-TR', 'Latn', '1254'),
+(193, '0x0442', 'Turkmen (Turkmenistan)', 'tk-TM', 'Cyrl', '1251'),
+(194, '0x0480', 'Uighur (PRC)', 'ug-CN', 'Arab', '1256'),
+(195, '0x0422', 'Ukrainian (Ukraine)', 'uk-UA', 'Cyrl', '1251'),
+(196, '0x042e', 'Upper Sorbian (Germany)', 'wen-DE', 'Latn', '1252'),
+(197, '0x0820', 'Urdu (India)', 'tr-IN', '', ''),
+(198, '0x0420', 'Urdu (Pakistan)', 'ur-PK', 'Arab', '1256'),
+(199, '0x0843', 'Uzbek (Uzbekistan, Cyrillic)', 'uz-Cyrl-UZ', 'Cyrl', '1251'),
+(200, '0x0443', 'Uzbek (Uzbekistan, Latin)', 'uz-Latn-UZ', 'Latn', '1254'),
+(201, '0x042a', 'Vietnamese (Vietnam)', 'vi-VN', 'Latn', '1258'),
+(202, '0x0452', 'Welsh (United Kingdom)', 'cy-GB', 'Latn', '1252'),
+(203, '0x0488', 'Wolof (Senegal)', 'wo-SN', 'Latn', '1252'),
+(204, '0x0434', 'Xhosa/isiXhosa (South Africa)', 'xh-ZA', 'Latn', '1252'),
+(205, '0x0485', 'Yakut (Russia)', 'sah-RU', 'Cyrl', '1251'),
+(206, '0x0478', 'Yi (PRC)', 'ii-CN', 'Yiii', 'UTF-8'),
+(207, '0x046a', 'Yoruba (Nigeria)', 'yo-NG', '', ''),
+(208, '0x0435', 'Zulu/isiZulu (South Africa)', 'zu-ZA', 'Latn', '1252');
\ No newline at end of file
