[Obm] new country features

JP Donnio tag-ml-obm@tbs-internet.com
Wed, 20 Oct 2004 16:24:38 +0200


This is a cryptographically signed message in MIME format.

--------------ms010204010602070602050206
Content-Type: multipart/mixed;
 boundary="------------020300040105070108060200"

This is a multi-part message in MIME format.
--------------020300040105070108060200
Content-Type: text/plain; charset=ISO-8859-15; format=flowed
Content-Transfer-Encoding: 8bit

Hi,

I have upgraded from OBM 0.8.5 to 0.8.7 (a bit late, but that system is in
production)

There is a major change though: now a given user can only work with
countries that have the same language as he has! If your language preference
is french, you will only see french speaking countries in the various
drop-down lists (creation, modification).

Worse! Say I have a US company and my user setting is french. Well if I
display the company details, the country name is not displayed! Change your
setting to english, and it is now displayed.

Of course, all this is a bug. Please revert to the previous behaviour: a
user should be able to view all countries.

BTW: I have attached my country table (198 countries).


I would appreciate a quick fix.


-- 
Jean-Philippe Donnio
tag@TBS-internet.com           Services aux ISP
TBS-internet                   http://www.TBS-internet.com

Besoin d'étendre votre offre d'infogérance?
Pitux est une solution prête à l'emploi pour le marché des PME.
Accès internet, firewall, VPN, serveur de mail, gestion centralisée...
=> http://www.pitux.com/


--------------020300040105070108060200
Content-Type: text/plain;
 name="Country.sql"
Content-Transfer-Encoding: 8bit
Content-Disposition: inline;
 filename="Country.sql"

# phpMyAdmin SQL Dump
# version 2.5.7-pl1
# http://www.phpmyadmin.net
#
# Serveur: localhost
# Généré le : Lundi 18 Octobre 2004 à 17:19
# Version du serveur: 4.0.20
# Version de PHP: 4.3.8
# 
# Base de données: `obm`
# 

# --------------------------------------------------------

#
# Structure de la table `Country`
#

CREATE TABLE `Country` (
  `country_timeupdate` timestamp(14) NOT NULL,
  `country_timecreate` timestamp(14) NOT NULL default '00000000000000',
  `country_userupdate` int(8) default NULL,
  `country_usercreate` int(8) default NULL,
  `country_iso3166` char(2) NOT NULL default '',
  `country_name` varchar(64) default NULL,
  `country_lang` char(2) NOT NULL default '',
  `country_phone` varchar(5) default NULL,
  PRIMARY KEY  (`country_iso3166`,`country_lang`)
) TYPE=MyISAM;

#
# Contenu de la table `Country`
#

INSERT INTO `Country` VALUES (20040514203717, 20040514203717, NULL, 1, 'FR', 'France', 'fr', '33');
INSERT INTO `Country` VALUES (20040521154952, 20040514203753, 1, 1, 'US', 'United States of America', 'en', '1');
INSERT INTO `Country` VALUES (20040521154930, 20040514203850, 1, 1, 'BE', 'Belgium', 'fr', '32');
INSERT INTO `Country` VALUES (20040521160344, 20040521160344, NULL, 1, 'ZA', 'South Africa', 'af', '27');
INSERT INTO `Country` VALUES (20040524085645, 20040524085645, NULL, 4, 'AF', 'Afghanistan', 'ps', '93');
INSERT INTO `Country` VALUES (20040524090913, 20040524090913, NULL, 4, 'AL', 'Albania', 'sq', '355');
INSERT INTO `Country` VALUES (20040524091509, 20040524091509, NULL, 4, 'DZ', 'Algeria', 'ar', '213');
INSERT INTO `Country` VALUES (20040524115154, 20040524115154, NULL, 4, 'BO', 'Bolivia', 'es', '591');
INSERT INTO `Country` VALUES (20040524092442, 20040524092442, NULL, 4, 'AD', 'Andorra', 'ca', '376');
INSERT INTO `Country` VALUES (20040524092648, 20040524092648, NULL, 4, 'AO', 'Angola', 'pt', '244');
INSERT INTO `Country` VALUES (20040524093118, 20040524093118, NULL, 4, 'AI', 'Anguilla', 'en', '1');
INSERT INTO `Country` VALUES (20040524093314, 20040524093314, NULL, 4, 'AQ', 'Antartica', '', '672');
INSERT INTO `Country` VALUES (20040524093653, 20040524093653, NULL, 4, 'AG', 'Antigua and Barbuda', 'en', '1268');
INSERT INTO `Country` VALUES (20040524093825, 20040524093825, NULL, 4, 'AR', 'Argentina', 'es', '54');
INSERT INTO `Country` VALUES (20040524094149, 20040524094149, NULL, 4, 'AM', 'Armenia', 'hy', '374');
INSERT INTO `Country` VALUES (20040524094320, 20040524094320, NULL, 4, 'AU', 'Australia', 'en', '61');
INSERT INTO `Country` VALUES (20040524094447, 20040524094447, NULL, 4, 'AT', 'Austria', 'de', '43');
INSERT INTO `Country` VALUES (20040524094753, 20040524094753, NULL, 4, 'AZ', 'Azerbaijan', 'az', '994');
INSERT INTO `Country` VALUES (20040524173421, 20040524094938, 4, 4, 'BS', 'Bahamas', 'en', '1242');
INSERT INTO `Country` VALUES (20040524095051, 20040524095051, NULL, 4, 'BH', 'Bahrain', 'ar', '973');
INSERT INTO `Country` VALUES (20040524095330, 20040524095330, NULL, 4, 'BD', 'Bangladesh', 'bn', '880');
INSERT INTO `Country` VALUES (20040524095427, 20040524095427, NULL, 4, 'BB', 'Barbados', 'en', '246');
INSERT INTO `Country` VALUES (20040524095848, 20040524095848, NULL, 4, 'BY', 'Belarus', 'be', '375');
INSERT INTO `Country` VALUES (20040524105120, 20040524105120, NULL, 4, 'BZ', 'Belize', 'en', '501');
INSERT INTO `Country` VALUES (20040524105921, 20040524105921, NULL, 4, 'BJ', 'Benin', 'fr', '229');
INSERT INTO `Country` VALUES (20040524110041, 20040524110041, NULL, 4, 'BM', 'Bermuda', 'en', '1441');
INSERT INTO `Country` VALUES (20040524110316, 20040524110315, NULL, 4, 'BT', 'Bhutan', '', '975');
INSERT INTO `Country` VALUES (20040524115333, 20040524115333, NULL, 4, 'BA', 'Bosnia and Herzegovina', 'sh', '387');
INSERT INTO `Country` VALUES (20040524115610, 20040524115610, NULL, 4, 'BW', 'Botswana', 'en', '267');
INSERT INTO `Country` VALUES (20040524115701, 20040524115701, NULL, 4, 'BR', 'Brazil', 'pt', '55');
INSERT INTO `Country` VALUES (20040524115817, 20040524115817, NULL, 4, 'BN', 'Brunei', 'ms', '673');
INSERT INTO `Country` VALUES (20040524115949, 20040524115949, NULL, 4, 'BG', 'Bulgaria', 'bg', '359');
INSERT INTO `Country` VALUES (20040524120044, 20040524120044, NULL, 4, 'BF', 'Burkina Faso', 'fr', 'bf');
INSERT INTO `Country` VALUES (20040524120121, 20040524120121, NULL, 4, 'BI', 'Burundi', 'fr', '257');
INSERT INTO `Country` VALUES (20040524120322, 20040524120322, NULL, 4, 'KH', 'Cambodia', 'km', '855');
INSERT INTO `Country` VALUES (20040524120408, 20040524120408, NULL, 4, 'CM', 'Cameroon', 'fr', '237');
INSERT INTO `Country` VALUES (20040524120452, 20040524120452, NULL, 4, 'CA', 'Canada', 'en', '1');
INSERT INTO `Country` VALUES (20040524120534, 20040524120534, NULL, 4, 'CV', 'Cape Verde', 'pt', '238');
INSERT INTO `Country` VALUES (20040524120654, 20040524120654, NULL, 4, 'CF', 'Central African Republic', 'fr', '236');
INSERT INTO `Country` VALUES (20040524120919, 20040524120919, NULL, 4, 'TD', 'Chad', 'ar', '235');
INSERT INTO `Country` VALUES (20040524121237, 20040524121237, NULL, 4, 'CL', 'Chile', 'es', '56');
INSERT INTO `Country` VALUES (20040524121342, 20040524121342, NULL, 4, 'CN', 'China', 'zh', '86');
INSERT INTO `Country` VALUES (20040524131527, 20040524131527, NULL, 4, 'CO', 'Colombia', 'es', '57');
INSERT INTO `Country` VALUES (20040524152132, 20040524152132, NULL, 4, 'KM', 'Comoros', 'ar', '3');
INSERT INTO `Country` VALUES (20040524152207, 20040524152207, NULL, 4, 'CG', 'Congo', 'fr', '242');
INSERT INTO `Country` VALUES (20040525105942, 20040524152306, 4, 4, 'CD', 'Congo, Republic of', 'fr', '242');
INSERT INTO `Country` VALUES (20040524152647, 20040524152647, NULL, 4, 'CR', 'Costa Rica', 'es', '506');
INSERT INTO `Country` VALUES (20040524152730, 20040524152730, NULL, 4, 'CI', 'Ivory coast', 'fr', '225');
INSERT INTO `Country` VALUES (20040524152829, 20040524152829, NULL, 4, 'HR', 'Croatia', 'hr', '385');
INSERT INTO `Country` VALUES (20040524152848, 20040524152848, NULL, 4, 'CU', 'Cuba', 'es', '53');
INSERT INTO `Country` VALUES (20040524152951, 20040524152951, NULL, 4, 'CY', 'Chypre', 'el', '357');
INSERT INTO `Country` VALUES (20040524153303, 20040524153303, NULL, 4, 'CZ', 'Czech Republic', 'cz', '1');
INSERT INTO `Country` VALUES (20040524153355, 20040524153355, NULL, 4, 'DK', 'Denmark', 'da', '45');
INSERT INTO `Country` VALUES (20040524153625, 20040524153625, NULL, 4, 'DJ', 'Djibouti', 'ar', '253');
INSERT INTO `Country` VALUES (20040524153939, 20040524153939, NULL, 4, 'DM', 'Dominica', 'en', '1767');
INSERT INTO `Country` VALUES (20040524153819, 20040524153819, NULL, 4, 'DO', 'Dominican Republic', 'es', '1809');
INSERT INTO `Country` VALUES (20040524154023, 20040524154023, NULL, 4, 'EC', 'Ecuador', 'es', '593');
INSERT INTO `Country` VALUES (20040524154046, 20040524154046, NULL, 4, 'EG', 'Egypt', 'ar', '20');
INSERT INTO `Country` VALUES (20040524154218, 20040524154218, NULL, 4, 'SV', 'El Salvador', 'es', '503');
INSERT INTO `Country` VALUES (20040524154303, 20040524154303, NULL, 4, 'GQ', 'Equatorial Guinea', 'es', '240');
INSERT INTO `Country` VALUES (20040524154351, 20040524154351, NULL, 4, 'ER', 'Eritrea', 'ar', '291');
INSERT INTO `Country` VALUES (20040524154452, 20040524154452, NULL, 4, 'EE', 'Estonia', 'et', '2');
INSERT INTO `Country` VALUES (20040524154639, 20040524154639, NULL, 4, 'ET', 'Ethiopia', 'am', '251');
INSERT INTO `Country` VALUES (20040524154718, 20040524154718, NULL, 4, 'FJ', 'Fiji', 'en', '679');
INSERT INTO `Country` VALUES (20040524154815, 20040524154815, NULL, 4, 'FI', 'Finland', 'fi', '358');
INSERT INTO `Country` VALUES (20040720153144, 20040524155040, 0, 4, 'GF', 'French Guiana', 'fr', '');
INSERT INTO `Country` VALUES (20040524155117, 20040524155117, NULL, 4, 'PF', 'French Polynesia', 'fr', '');
INSERT INTO `Country` VALUES (20040524155153, 20040524155153, NULL, 4, 'GA', 'Gabon', 'fr', '241');
INSERT INTO `Country` VALUES (20040524155226, 20040524155226, NULL, 4, 'GM', 'Gambia', 'en', '220');
INSERT INTO `Country` VALUES (20040524155712, 20040524155712, NULL, 4, 'GE', 'Georgia', 'ka', '995');
INSERT INTO `Country` VALUES (20040524155820, 20040524155820, NULL, 4, 'DE', 'Germany', 'de', '49');
INSERT INTO `Country` VALUES (20040524155905, 20040524155845, 4, 4, 'GH', 'Ghana', 'en', '233');
INSERT INTO `Country` VALUES (20040524160023, 20040524160023, NULL, 4, 'GR', 'Greece', 'el', '30');
INSERT INTO `Country` VALUES (20040524160117, 20040524160117, NULL, 4, 'GD', 'Grenada', 'en', '1473');
INSERT INTO `Country` VALUES (20040524160146, 20040524160146, NULL, 4, 'GT', 'Guatemala', 'es', '502');
INSERT INTO `Country` VALUES (20040524160227, 20040524160227, NULL, 4, 'GN', 'Guinea', 'fr', '224');
INSERT INTO `Country` VALUES (20040524160311, 20040524160311, NULL, 4, 'GW', 'Guinea-Bissau', 'pt', '245');
INSERT INTO `Country` VALUES (20040524160428, 20040524160428, NULL, 4, 'GY', 'Guyana', 'en', '592');
INSERT INTO `Country` VALUES (20040524160518, 20040524160518, NULL, 4, 'HN', 'Honduras', 'es', '504');
INSERT INTO `Country` VALUES (20040524164903, 20040524164903, NULL, 4, 'HK', 'Hong Kong', '', '');
INSERT INTO `Country` VALUES (20040524164943, 20040524164943, NULL, 4, 'HU', 'Hungary', 'hu', '36');
INSERT INTO `Country` VALUES (20040524165116, 20040524165116, NULL, 4, 'IS', 'Iceland', '', '354');
INSERT INTO `Country` VALUES (20040524165147, 20040524165147, NULL, 4, 'IN', 'India', 'en', '91');
INSERT INTO `Country` VALUES (20040524165312, 20040524165312, NULL, 4, 'ID', 'Indonesia', 'id', '62');
INSERT INTO `Country` VALUES (20040524165419, 20040524165419, NULL, 4, 'IR', 'Iran', 'fa', '98');
INSERT INTO `Country` VALUES (20040524165445, 20040524165445, NULL, 4, 'IQ', 'Iraq', 'ar', '964');
INSERT INTO `Country` VALUES (20040524165707, 20040524165707, NULL, 4, 'EI', 'Ireland', 'ga', '353');
INSERT INTO `Country` VALUES (20040524165745, 20040524165745, NULL, 4, 'IL', 'Israel', 'he', '972');
INSERT INTO `Country` VALUES (20040524165819, 20040524165819, NULL, 4, 'IT', 'Italy', 'it', '39');
INSERT INTO `Country` VALUES (20040524165902, 20040524165902, NULL, 4, 'JM', 'Jamaica', 'en', '1876');
INSERT INTO `Country` VALUES (20040524165940, 20040524165940, NULL, 4, 'JP', 'Japan', 'ja', '81');
INSERT INTO `Country` VALUES (20040524170007, 20040524170007, NULL, 4, 'JO', 'Jordan', 'ar', '962');
INSERT INTO `Country` VALUES (20040524170137, 20040524170137, NULL, 4, 'KZ', 'Kazakhstan', 'kk', '7');
INSERT INTO `Country` VALUES (20040524170210, 20040524170210, NULL, 4, 'KE', 'Kenya', 'en', '254');
INSERT INTO `Country` VALUES (20040524170253, 20040524170253, NULL, 4, 'KG', 'Kyrgystan', 'ru', '996');
INSERT INTO `Country` VALUES (20040524170325, 20040524170325, NULL, 4, 'KI', 'Kiribati', 'en', '686');
INSERT INTO `Country` VALUES (20040524170721, 20040524170721, NULL, 4, 'KP', 'Korea, Democratic People Republic of', 'ko', '850');
INSERT INTO `Country` VALUES (20040524170918, 20040524170918, NULL, 4, 'KR', 'Korean, Republic of', 'ko', '82');
INSERT INTO `Country` VALUES (20040524171024, 20040524171024, NULL, 4, 'KW', 'Kuwait', 'ar', '965');
INSERT INTO `Country` VALUES (20040524171129, 20040524171129, NULL, 4, 'LA', 'LAO people\'s democratic rep', 'lo', '856');
INSERT INTO `Country` VALUES (20040524171251, 20040524171251, NULL, 4, 'LV', 'Latvia', 'lv', '371');
INSERT INTO `Country` VALUES (20040524171403, 20040524171403, NULL, 4, 'LB', 'Lebanon', 'ar', '961');
INSERT INTO `Country` VALUES (20040524171647, 20040524171647, NULL, 4, 'LR', 'Liberia', 'en', '231');
INSERT INTO `Country` VALUES (20040524171731, 20040524171731, NULL, 4, 'LY', 'Libyan Arab Jamahiriya', 'ar', '218');
INSERT INTO `Country` VALUES (20040524171807, 20040524171807, NULL, 4, 'LI', 'Liechtenstein', 'de', '423');
INSERT INTO `Country` VALUES (20040524171853, 20040524171853, NULL, 4, 'LT', 'Lithuania', 'lt', '370');
INSERT INTO `Country` VALUES (20040524172005, 20040524172005, NULL, 4, 'LU', 'Luxembourg', 'nl', '352');
INSERT INTO `Country` VALUES (20040524172054, 20040524172054, NULL, 4, 'MK', 'Macedonia', 'mk', '389');
INSERT INTO `Country` VALUES (20040524172137, 20040524172137, NULL, 4, 'MG', 'Madagascar', 'fr', '261');
INSERT INTO `Country` VALUES (20040524172301, 20040524172301, NULL, 4, 'MY', 'Malaysia', 'ms', '60');
INSERT INTO `Country` VALUES (20040524172329, 20040524172329, NULL, 4, 'MW', 'Malawi', 'en', '265');
INSERT INTO `Country` VALUES (20040524172425, 20040524172425, NULL, 4, 'MV', 'Maldives', 'di', '960');
INSERT INTO `Country` VALUES (20040524172452, 20040524172452, NULL, 4, 'ML', 'Mali', 'fr', '223');
INSERT INTO `Country` VALUES (20040524172517, 20040524172517, NULL, 4, 'MT', 'Malte', 'en', '356');
INSERT INTO `Country` VALUES (20040524172601, 20040524172601, NULL, 4, 'MA', 'Morocco', 'ar', '212');
INSERT INTO `Country` VALUES (20040524172643, 20040524172643, NULL, 4, 'MH', 'Marshall Islands', 'en', '692');
INSERT INTO `Country` VALUES (20040524172732, 20040524172732, NULL, 4, 'MU', 'Mauritius', 'en', '230');
INSERT INTO `Country` VALUES (20040524172803, 20040524172803, NULL, 4, 'MR', 'Mauritania', 'ar', '222');
INSERT INTO `Country` VALUES (20040524172838, 20040524172838, NULL, 4, 'MX', 'Mexico', 'es', '52');
INSERT INTO `Country` VALUES (20040524172919, 20040524172919, NULL, 4, 'FM', 'Micronesia', 'en', '691');
INSERT INTO `Country` VALUES (20040524173021, 20040524173021, NULL, 4, 'MD', 'Moldova', 'mo', '373');
INSERT INTO `Country` VALUES (20040524173049, 20040524173049, NULL, 4, 'MC', 'Monaco', 'fr', '377');
INSERT INTO `Country` VALUES (20040524173146, 20040524173146, NULL, 4, 'MN', 'Mongolia', '', '976');
INSERT INTO `Country` VALUES (20040524173239, 20040524173239, NULL, 4, 'MZ', 'Mozambique', 'pt', '258');
INSERT INTO `Country` VALUES (20040525082055, 20040525082055, NULL, 4, 'NA', 'Namibia', 'en', '264');
INSERT INTO `Country` VALUES (20040525082457, 20040525082457, NULL, 4, 'NR', 'Nauru', 'na', '674');
INSERT INTO `Country` VALUES (20040525082730, 20040525082730, NULL, 4, 'MM', 'Myanmar', 'my', '95');
INSERT INTO `Country` VALUES (20040525090111, 20040525090111, NULL, 4, 'NP', 'Nepal', 'ne', '977');
INSERT INTO `Country` VALUES (20040525090316, 20040525090316, NULL, 4, 'NL', 'Netherlands', 'nl', '31');
INSERT INTO `Country` VALUES (20040525090825, 20040525090825, NULL, 4, 'NC', 'New Caledonia', 'fr', '687');
INSERT INTO `Country` VALUES (20040525090913, 20040525090913, NULL, 4, 'NZ', 'New Zealand', 'fr', '64');
INSERT INTO `Country` VALUES (20040525090946, 20040525090946, NULL, 4, 'NI', 'Nicaragua', 'es', '505');
INSERT INTO `Country` VALUES (20040525091039, 20040525091039, NULL, 4, 'NE', 'Niger', 'fr', '227');
INSERT INTO `Country` VALUES (20040525091059, 20040525091059, NULL, 4, 'NG', 'Nigeria', 'en', '234');
INSERT INTO `Country` VALUES (20040525091155, 20040525091155, NULL, 4, 'NO', 'Norway', 'no', '47');
INSERT INTO `Country` VALUES (20040525091636, 20040525091636, NULL, 4, 'OM', 'Oman', 'ar', '968');
INSERT INTO `Country` VALUES (20040525091744, 20040525091744, NULL, 4, 'UG', 'Uganda', 'en', '256');
INSERT INTO `Country` VALUES (20040525091913, 20040525091913, NULL, 4, 'UZ', 'Uzbekistan', 'uz', '998');
INSERT INTO `Country` VALUES (20040525092058, 20040525092058, NULL, 4, 'PK', 'Pakistan', 'pk', '92');
INSERT INTO `Country` VALUES (20040525092125, 20040525092125, NULL, 4, 'PW', 'Palau', 'en', '680');
INSERT INTO `Country` VALUES (20040525092158, 20040525092158, NULL, 4, 'PA', 'Panama', 'es', '507');
INSERT INTO `Country` VALUES (20040525092236, 20040525092236, NULL, 4, 'PG', 'Papua New Guinea', 'en', '675');
INSERT INTO `Country` VALUES (20040525092422, 20040525092422, NULL, 4, 'PY', 'Paraguay', 'es', '595');
INSERT INTO `Country` VALUES (20040525092456, 20040525092456, NULL, 4, 'PE', 'Peru', 'es', '51');
INSERT INTO `Country` VALUES (20040525093103, 20040525093103, NULL, 4, 'PH', 'Philippines', 'en', '63');
INSERT INTO `Country` VALUES (20040525094458, 20040525094458, NULL, 4, 'PL', 'Poland', 'pl', '48');
INSERT INTO `Country` VALUES (20040525094527, 20040525094527, NULL, 4, 'PT', 'Portugal', 'pt', '351');
INSERT INTO `Country` VALUES (20040525094731, 20040525094731, NULL, 4, 'QA', 'Qatar', 'ar', '974');
INSERT INTO `Country` VALUES (20040525095156, 20040525095156, NULL, 4, 'RO', 'Romania', 'ro', '40');
INSERT INTO `Country` VALUES (20040525095345, 20040525095345, NULL, 4, 'RU', 'Russian Federation', 'ru', '7');
INSERT INTO `Country` VALUES (20040525095502, 20040525095502, NULL, 4, 'RW', 'Rwanda', 'fr', '250');
INSERT INTO `Country` VALUES (20040525095617, 20040525095617, NULL, 4, 'KN', 'Saint Kitts et Nevis', 'en', '1869');
INSERT INTO `Country` VALUES (20040525095717, 20040525095717, NULL, 4, 'VC', 'Saint Vincent and the Grenadines', 'en', '1784');
INSERT INTO `Country` VALUES (20040525095742, 20040525095742, NULL, 4, 'LC', 'Saint Lucia', 'en', '1758');
INSERT INTO `Country` VALUES (20040525095910, 20040525095910, NULL, 4, 'PM', 'Saint Piere and Miquelon', 'fr', '508');
INSERT INTO `Country` VALUES (20040525100038, 20040525100038, NULL, 4, 'WS', 'Samoa', 'en', '684');
INSERT INTO `Country` VALUES (20040525100105, 20040525100105, NULL, 4, 'SM', 'San Marino', 'it', '378');
INSERT INTO `Country` VALUES (20040525100207, 20040525100207, NULL, 4, 'ST', 'Sao Tome and Principe', 'pt', '239');
INSERT INTO `Country` VALUES (20040525100403, 20040525100403, NULL, 4, 'SA', 'Saudi Arabia', 'ar', '966');
INSERT INTO `Country` VALUES (20040525100537, 20040525100537, NULL, 4, 'SN', 'Senegal', 'fr', '221');
INSERT INTO `Country` VALUES (20040525100754, 20040525100754, NULL, 4, 'SC', 'Seychelles', '', '248');
INSERT INTO `Country` VALUES (20040525100933, 20040525100933, NULL, 4, 'YU', 'Serbia and Mntenegro', 'sb', '381');
INSERT INTO `Country` VALUES (20040525101135, 20040525101135, NULL, 4, 'SL', 'Sierra Leone', 'en', '232');
INSERT INTO `Country` VALUES (20040525101159, 20040525101159, NULL, 4, 'SG', 'Singapore', 'en', '65');
INSERT INTO `Country` VALUES (20040525101307, 20040525101307, NULL, 4, 'SK', 'Slovakia', 'sk', '421');
INSERT INTO `Country` VALUES (20040525101335, 20040525101335, NULL, 4, 'SI', 'Slovenia', 'sl', '386');
INSERT INTO `Country` VALUES (20040525101534, 20040525101534, NULL, 4, 'SB', 'Solomon Islands', 'en', '677');
INSERT INTO `Country` VALUES (20040525101658, 20040525101658, NULL, 4, 'SO', 'Somalia', 'ar', '252');
INSERT INTO `Country` VALUES (20040525101850, 20040525101850, NULL, 4, 'ES', 'Spain', 'es', '34');
INSERT INTO `Country` VALUES (20040525102155, 20040525102155, NULL, 4, 'LK', 'Sri Lanka', '', '94');
INSERT INTO `Country` VALUES (20040525102227, 20040525102227, NULL, 4, 'SD', 'Soudan', 'ar', '249');
INSERT INTO `Country` VALUES (20040525102325, 20040525102325, NULL, 4, 'SR', 'Suriname', 'nl', '597');
INSERT INTO `Country` VALUES (20040525102451, 20040525102451, NULL, 4, 'SZ', 'Swaziland', 'en', '268');
INSERT INTO `Country` VALUES (20040525102554, 20040525102554, NULL, 4, 'SE', 'Sweden', 'sv', '46');
INSERT INTO `Country` VALUES (20040525102703, 20040525102703, NULL, 4, 'CH', 'Switzerland', 'de', '41');
INSERT INTO `Country` VALUES (20040525102752, 20040525102752, NULL, 4, 'SY', 'Syrian Arab republic', 'ar', '963');
INSERT INTO `Country` VALUES (20040525102914, 20040525102914, NULL, 4, 'TW', 'Taiwan, Province of China', 'zh', '886');
INSERT INTO `Country` VALUES (20040525103004, 20040525103004, NULL, 4, 'TJ', 'Tajikistan', '', '992');
INSERT INTO `Country` VALUES (20040525103047, 20040525103047, NULL, 4, 'TZ', 'Tanzania', 'en', '255');
INSERT INTO `Country` VALUES (20040525103210, 20040525103210, NULL, 4, 'TH', 'Thailand', 'th', '66');
INSERT INTO `Country` VALUES (20040525103307, 20040525103307, NULL, 4, 'TG', 'Togo', 'fr', '228');
INSERT INTO `Country` VALUES (20040525103329, 20040525103329, NULL, 4, 'TO', 'Tonga', 'en', '676');
INSERT INTO `Country` VALUES (20040525103354, 20040525103354, NULL, 4, 'TT', 'Trinidad ans Tabago', 'en', '1868');
INSERT INTO `Country` VALUES (20040525103430, 20040525103430, NULL, 4, 'TN', 'Tunisia', 'ar', '216');
INSERT INTO `Country` VALUES (20040525103521, 20040525103521, NULL, 4, 'TR', 'Turkey', 'tr', '90');
INSERT INTO `Country` VALUES (20040525103552, 20040525103552, NULL, 4, 'TM', 'Turkmenistan', '', '993');
INSERT INTO `Country` VALUES (20040525103628, 20040525103628, NULL, 4, 'TV', 'Tuvalu', 'en', '688');
INSERT INTO `Country` VALUES (20040525103800, 20040525103800, NULL, 4, 'UA', 'Ukraine', 'uk', '380');
INSERT INTO `Country` VALUES (20040525104051, 20040525104051, NULL, 4, 'AE', 'United Arab Emirates', 'ar', '971');
INSERT INTO `Country` VALUES (20040525104129, 20040525104129, NULL, 4, 'UK', 'United Kingdom', 'en', '44');
INSERT INTO `Country` VALUES (20040525104321, 20040525104321, NULL, 4, 'UY', 'Uruguay', 'es', '598');
INSERT INTO `Country` VALUES (20040525104444, 20040525104444, NULL, 4, 'VU', 'Vanuatu', 'en', '678');
INSERT INTO `Country` VALUES (20040525104522, 20040525104522, NULL, 4, 'VA', 'Vatican City State', 'it', '39');
INSERT INTO `Country` VALUES (20040525104554, 20040525104554, NULL, 4, 'VE', 'Venezuela', 'es', '58');
INSERT INTO `Country` VALUES (20040525105013, 20040525105013, NULL, 4, 'VN', 'Viet Nam', 'vi', '84');
INSERT INTO `Country` VALUES (20040525105220, 20040525105220, NULL, 4, 'YE', 'Yemen', 'ar', '967');
INSERT INTO `Country` VALUES (20040525105240, 20040525105240, NULL, 4, 'ZM', 'Zambia', 'en', '260');
INSERT INTO `Country` VALUES (20040525105313, 20040525105313, NULL, 4, 'ZW', 'Zimbabwe', 'en', '263');


--------------020300040105070108060200--

--------------ms010204010602070602050206
Content-Type: application/x-pkcs7-signature; name="smime.p7s"
Content-Transfer-Encoding: base64
Content-Disposition: attachment; filename="smime.p7s"
Content-Description: S/MIME Cryptographic Signature

MIAGCSqGSIb3DQEHAqCAMIACAQExCzAJBgUrDgMCGgUAMIAGCSqGSIb3DQEHAQAAoIIIOzCC
AngwggHhoAMCAQICAwzUSTANBgkqhkiG9w0BAQQFADBiMQswCQYDVQQGEwJaQTElMCMGA1UE
ChMcVGhhd3RlIENvbnN1bHRpbmcgKFB0eSkgTHRkLjEsMCoGA1UEAxMjVGhhd3RlIFBlcnNv
bmFsIEZyZWVtYWlsIElzc3VpbmcgQ0EwHhcNMDQwODA5MTA1NzQ2WhcNMDUwODA5MTA1NzQ2
WjBtMQ8wDQYDVQQEEwZEb25uaW8xFjAUBgNVBCoTDUplYW4tUGhpbGlwcGUxHTAbBgNVBAMT
FEplYW4tUGhpbGlwcGUgRG9ubmlvMSMwIQYJKoZIhvcNAQkBFhR0YWdAdGJzLWludGVybmV0
LmNvbTCBnzANBgkqhkiG9w0BAQEFAAOBjQAwgYkCgYEAvwHnEOjo0VbbaymjgGdlkEgkqSpA
lFDBB9xKADtyGS9l2T83e3Wkc1ZBXCfq8cVB5PLB6+tv0YOtrERD3Sk6POTLeVDs7H6CTpji
gHF85mEIEZ2PSCjuhvwS5hL5gLL9+dQ8PKOT5ozpOlYUEo8Y1cbFgyoNXz/nhD6hPH0av+8C
AwEAAaMxMC8wHwYDVR0RBBgwFoEUdGFnQHRicy1pbnRlcm5ldC5jb20wDAYDVR0TAQH/BAIw
ADANBgkqhkiG9w0BAQQFAAOBgQBmgJYI/iB7jfv2u6BqmFytSsnbdl+H9FcPtYURuWt1FUbO
UNbk6dM1EZGh+ncx2UWEuqDZvgUxf1Me94vylmtnqk8kZGALjmb0LYoFYH1DsDFX+dLSxTQk
p3ML9R2vPLThss9V/YV4nmzGuqPrQkOYs+zBr+YYrR7hQGPUb7e2rTCCAngwggHhoAMCAQIC
AwzUSTANBgkqhkiG9w0BAQQFADBiMQswCQYDVQQGEwJaQTElMCMGA1UEChMcVGhhd3RlIENv
bnN1bHRpbmcgKFB0eSkgTHRkLjEsMCoGA1UEAxMjVGhhd3RlIFBlcnNvbmFsIEZyZWVtYWls
IElzc3VpbmcgQ0EwHhcNMDQwODA5MTA1NzQ2WhcNMDUwODA5MTA1NzQ2WjBtMQ8wDQYDVQQE
EwZEb25uaW8xFjAUBgNVBCoTDUplYW4tUGhpbGlwcGUxHTAbBgNVBAMTFEplYW4tUGhpbGlw
cGUgRG9ubmlvMSMwIQYJKoZIhvcNAQkBFhR0YWdAdGJzLWludGVybmV0LmNvbTCBnzANBgkq
hkiG9w0BAQEFAAOBjQAwgYkCgYEAvwHnEOjo0VbbaymjgGdlkEgkqSpAlFDBB9xKADtyGS9l
2T83e3Wkc1ZBXCfq8cVB5PLB6+tv0YOtrERD3Sk6POTLeVDs7H6CTpjigHF85mEIEZ2PSCju
hvwS5hL5gLL9+dQ8PKOT5ozpOlYUEo8Y1cbFgyoNXz/nhD6hPH0av+8CAwEAAaMxMC8wHwYD
VR0RBBgwFoEUdGFnQHRicy1pbnRlcm5ldC5jb20wDAYDVR0TAQH/BAIwADANBgkqhkiG9w0B
AQQFAAOBgQBmgJYI/iB7jfv2u6BqmFytSsnbdl+H9FcPtYURuWt1FUbOUNbk6dM1EZGh+ncx
2UWEuqDZvgUxf1Me94vylmtnqk8kZGALjmb0LYoFYH1DsDFX+dLSxTQkp3ML9R2vPLThss9V
/YV4nmzGuqPrQkOYs+zBr+YYrR7hQGPUb7e2rTCCAz8wggKooAMCAQICAQ0wDQYJKoZIhvcN
AQEFBQAwgdExCzAJBgNVBAYTAlpBMRUwEwYDVQQIEwxXZXN0ZXJuIENhcGUxEjAQBgNVBAcT
CUNhcGUgVG93bjEaMBgGA1UEChMRVGhhd3RlIENvbnN1bHRpbmcxKDAmBgNVBAsTH0NlcnRp
ZmljYXRpb24gU2VydmljZXMgRGl2aXNpb24xJDAiBgNVBAMTG1RoYXd0ZSBQZXJzb25hbCBG
cmVlbWFpbCBDQTErMCkGCSqGSIb3DQEJARYccGVyc29uYWwtZnJlZW1haWxAdGhhd3RlLmNv
bTAeFw0wMzA3MTcwMDAwMDBaFw0xMzA3MTYyMzU5NTlaMGIxCzAJBgNVBAYTAlpBMSUwIwYD
VQQKExxUaGF3dGUgQ29uc3VsdGluZyAoUHR5KSBMdGQuMSwwKgYDVQQDEyNUaGF3dGUgUGVy
c29uYWwgRnJlZW1haWwgSXNzdWluZyBDQTCBnzANBgkqhkiG9w0BAQEFAAOBjQAwgYkCgYEA
xKY8VXNV+065yplaHmjAdQRwnd/p/6Me7L3N9VvyGna9fww6YfK/Uc4B1OVQCjDXAmNaLIkV
cI7dyfArhVqqP3FWy688Cwfn8R+RNiQqE88r1fOCdz0Dviv+uxg+B79AgAJk16emu59l0cUq
VIUPSAR/p7bRPGEEQB5kGXJgt/sCAwEAAaOBlDCBkTASBgNVHRMBAf8ECDAGAQH/AgEAMEMG
A1UdHwQ8MDowOKA2oDSGMmh0dHA6Ly9jcmwudGhhd3RlLmNvbS9UaGF3dGVQZXJzb25hbEZy
ZWVtYWlsQ0EuY3JsMAsGA1UdDwQEAwIBBjApBgNVHREEIjAgpB4wHDEaMBgGA1UEAxMRUHJp
dmF0ZUxhYmVsMi0xMzgwDQYJKoZIhvcNAQEFBQADgYEASIzRUIPqCy7MDaNmrGcPf6+svsIX
oUOWlJ1/TCG4+DYfqi2fNi/A9BxQIJNwPP2t4WFiw9k6GX6EsZkbAMUaC4J0niVQlGLH2ydx
VyWN3amcOY6MIE9lX5Xa9/eH1sYITq726jTlEBpbNU1341YheILcIRk13iSx0x1G/11fZU8x
ggK6MIICtgIBATBpMGIxCzAJBgNVBAYTAlpBMSUwIwYDVQQKExxUaGF3dGUgQ29uc3VsdGlu
ZyAoUHR5KSBMdGQuMSwwKgYDVQQDEyNUaGF3dGUgUGVyc29uYWwgRnJlZW1haWwgSXNzdWlu
ZyBDQQIDDNRJMAkGBSsOAwIaBQCgggGnMBgGCSqGSIb3DQEJAzELBgkqhkiG9w0BBwEwHAYJ
KoZIhvcNAQkFMQ8XDTA0MTAyMDE0MjQzOFowIwYJKoZIhvcNAQkEMRYEFLyd3I0cu7k3S0Q7
bRW8/q1MsDtBMFIGCSqGSIb3DQEJDzFFMEMwCgYIKoZIhvcNAwcwDgYIKoZIhvcNAwICAgCA
MA0GCCqGSIb3DQMCAgFAMAcGBSsOAwIHMA0GCCqGSIb3DQMCAgEoMHgGCSsGAQQBgjcQBDFr
MGkwYjELMAkGA1UEBhMCWkExJTAjBgNVBAoTHFRoYXd0ZSBDb25zdWx0aW5nIChQdHkpIEx0
ZC4xLDAqBgNVBAMTI1RoYXd0ZSBQZXJzb25hbCBGcmVlbWFpbCBJc3N1aW5nIENBAgMM1Ekw
egYLKoZIhvcNAQkQAgsxa6BpMGIxCzAJBgNVBAYTAlpBMSUwIwYDVQQKExxUaGF3dGUgQ29u
c3VsdGluZyAoUHR5KSBMdGQuMSwwKgYDVQQDEyNUaGF3dGUgUGVyc29uYWwgRnJlZW1haWwg
SXNzdWluZyBDQQIDDNRJMA0GCSqGSIb3DQEBAQUABIGAu0FybcuhA+1YjCWi/6FEU+UaXRLi
smVmAEFvQGVKNA8jO0MJfCTXvvwtSCz+hSl7KQofxdujHX6fMzOprpVKY2Zj1sQit9NHjZjc
NxDUl7hgwaO3g9B0l37zq/OEhUzPNEbXWG+l4hGxsEyudYONPaSkBNTwrMsgDn0aWymHuDMA
AAAAAAA=
--------------ms010204010602070602050206--