[Obm] new country features

JP Donnio tag-obm@tbs-internet.com
Mon, 18 Oct 2004 19:21:31 +0200
Previous message: [Obm] PhpMyAdmin info
Next message: [Obm] OBM wish
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
This is a cryptographically signed message in MIME format.

--------------ms050806090004040105040802
Content-Type: multipart/mixed;
 boundary="------------030701090904050308070508"

This is a multi-part message in MIME format.
--------------030701090904050308070508
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/

--------------030701090904050308070508
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');

--------------030701090904050308070508
Content-Type: text/x-vcard; charset=utf-8;
 name="tag-obm.vcf"
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment;
 filename="tag-obm.vcf"

begin:vcard
fn:Jean-Philippe DONNIO
n:DONNIO;Jean-Philippe
org:TBS INTERNET
adr:Suite 214;;142 rue Saint Jean;CAEN CEDEX 1;;14012;France
email;internet:tag@tbs-internet.com
title:President
tel;work:+33-2-3184-4577
tel;fax:+33-2-3178-3187
x-mozilla-html:FALSE
url:http://www.TBS-internet.com/
version:2.1
end:vcard


--------------030701090904050308070508--

--------------ms050806090004040105040802
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
KoZIhvcNAQkFMQ8XDTA0MTAxODE3MjEzMVowIwYJKoZIhvcNAQkEMRYEFFUYF30/XGsPOMPg
DaCeD1r8WwIIMFIGCSqGSIb3DQEJDzFFMEMwCgYIKoZIhvcNAwcwDgYIKoZIhvcNAwICAgCA
MA0GCCqGSIb3DQMCAgFAMAcGBSsOAwIHMA0GCCqGSIb3DQMCAgEoMHgGCSsGAQQBgjcQBDFr
MGkwYjELMAkGA1UEBhMCWkExJTAjBgNVBAoTHFRoYXd0ZSBDb25zdWx0aW5nIChQdHkpIEx0
ZC4xLDAqBgNVBAMTI1RoYXd0ZSBQZXJzb25hbCBGcmVlbWFpbCBJc3N1aW5nIENBAgMM1Ekw
egYLKoZIhvcNAQkQAgsxa6BpMGIxCzAJBgNVBAYTAlpBMSUwIwYDVQQKExxUaGF3dGUgQ29u
c3VsdGluZyAoUHR5KSBMdGQuMSwwKgYDVQQDEyNUaGF3dGUgUGVyc29uYWwgRnJlZW1haWwg
SXNzdWluZyBDQQIDDNRJMA0GCSqGSIb3DQEBAQUABIGAAqKnqkMyCCH4VVu/3Itz0PxDiA3M
9nRONqVC0l0vo6mUO6ibNIei3s/ScYdyp1wqQdShyEtbX/gwpj8H+o2D948UbwHYYzeGgT5V
pCTXrd81+eJcsjEYZaRPDUjrDf3CHWrRbsZpHBzGR+4SShui2viNYadEYaVRubANGlMMuSwA
AAAAAAA=
--------------ms050806090004040105040802--
Previous message: [Obm] PhpMyAdmin info
Next message: [Obm] OBM wish
Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]