Re: table pays
Posté : 15 oct. 2010, 19:30
par Shim
1./*
1.Export créé par Alexandre VAL aka Joe Le Mort
2.Tuxboard.com
3.*/
3.
4.
5.DROP TABLE IF EXISTS `pays`;
6.
7.CREATE TABLE `pays` (
8. `rowid` int(11) NOT NULL auto_increment,
9. `code` varchar(2) NOT NULL,
10. `fr` varchar(255) NOT NULL,
11. `en` varchar(255) default NULL,
12. PRIMARY KEY (`rowid`)
13.) ENGINE=InnoDB DEFAULT CHARSET=latin1;
14.
15./*Data for the table `pays` */
16.
17.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (1,'AF','Afghanistan','Afghanistan');
18.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (2,'ZA','Afrique du Sud','South Africa');
19.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (3,'AL','Albanie','Albania');
20.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (4,'DZ','Algérie','Algeria');
21.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (5,'DE','Allemagne','Germany');
22.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (6,'AD','Andorre','Andorra');
23.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (7,'AO','Angola','Angola');
24.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (8,'AI','Anguilla','Anguilla');
25.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (9,'AQ','Antarctique','Antarctica');
26.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (10,'AG','Antigua-et-Barbuda','Antigua & Barbuda');
27.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (11,'AN','Antilles néerlandaises','Netherlands Antilles');
28.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (12,'SA','Arabie saoudite','Saudi Arabia');
29.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (13,'AR','Argentine','Argentina');
30.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (14,'AM','Arménie','Armenia');
31.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (15,'AW','Aruba','Aruba');
32.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (16,'AU','Australie','Australia');
33.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (17,'AT','Autriche','Austria');
34.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (18,'AZ','Azerbaïdjan','Azerbaijan');
35.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (19,'BJ','Bénin','Benin');
36.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (20,'BS','Bahamas','Bahamas, The');
37.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (21,'BH','Bahreïn','Bahrain');
38.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (22,'BD','Bangladesh','Bangladesh');
39.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (23,'BB','Barbade','Barbados');
40.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (24,'PW','Belau','Palau');
41.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (25,'BE','Belgique','Belgium');
42.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (26,'BZ','Belize','Belize');
43.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (27,'BM','Bermudes','Bermuda');
44.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (28,'BT','Bhoutan','Bhutan');
45.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (29,'BY','Biélorussie','Belarus');
46.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (30,'MM','Birmanie','Myanmar (ex-Burma)');
47.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (31,'BO','Bolivie','Bolivia');
48.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (32,'BA','Bosnie-Herzégovine','Bosnia and Herzegovina');
49.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (33,'BW','Botswana','Botswana');
50.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (34,'BR','Brésil','Brazil');
51.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (35,'BN','Brunei','Brunei Darussalam');
52.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (36,'BG','Bulgarie','Bulgaria');
53.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (37,'BF','Burkina Faso','Burkina Faso');
54.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (38,'BI','Burundi','Burundi');
55.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (39,'CI','Côte d\'Ivoire','Ivory Coast (see Cote d\'Ivoire)');
56.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (40,'KH','Cambodge','Cambodia');
57.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (41,'CM','Cameroun','Cameroon');
58.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (42,'CA','Canada','Canada');
59.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (43,'CV','Cap-Vert','Cape Verde');
60.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (44,'CL','Chili','Chile');
61.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (45,'CN','Chine','China');
62.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (46,'CY','Chypre','Cyprus');
63.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (47,'CO','Colombie','Colombia');
64.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (48,'KM','Comores','Comoros');
65.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (49,'CG','Congo','Congo');
66.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (50,'KP','Corée du Nord','Korea, Demo. People\'s Rep. of');
67.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (51,'KR','Corée du Sud','Korea, (South) Republic of');
68.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (52,'CR','Costa Rica','Costa Rica');
69.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (53,'HR','Croatie','Croatia');
70.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (54,'CU','Cuba','Cuba');
71.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (55,'DK','Danemark','Denmark');
72.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (56,'DJ','Djibouti','Djibouti');
73.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (57,'DM','Dominique','Dominica');
74.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (58,'EG','Ã?gypte','Egypt');
75.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (59,'AE','Ã?mirats arabes unis','United Arab Emirates');
76.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (60,'EC','Ã?quateur','Ecuador');
77.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (61,'ER','�rythrée','Eritrea');
78.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (62,'ES','Espagne','Spain');
79.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (63,'EE','Estonie','Estonia');
80.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (64,'US','Ã?tats-Unis','United States');
81.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (65,'ET','Ã?thiopie','Ethiopia');
82.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (66,'FI','Finlande','Finland');
83.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (67,'FR','France','France');
84.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (68,'GE','Géorgie','Georgia');
85.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (69,'GA','Gabon','Gabon');
86.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (70,'GM','Gambie','Gambia, the');
87.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (71,'GH','Ghana','Ghana');
88.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (72,'GI','Gibraltar','Gibraltar');
89.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (73,'GR','Grèce','Greece');
90.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (74,'GD','Grenade','Grenada');
91.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (75,'GL','Groenland','Greenland');
92.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (76,'GP','Guadeloupe','Guinea, Equatorial');
93.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (77,'GU','Guam','Guam');
94.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (78,'GT','Guatemala','Guatemala');
95.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (79,'GN','Guinée','Guinea');
96.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (80,'GQ','Guinée équatoriale','Equatorial Guinea');
97.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (81,'GW','Guinée-Bissao','Guinea-Bissau');
98.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (82,'GY','Guyana','Guyana');
99.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (83,'GF','Guyane française','Guiana, French');
100.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (84,'HT','Haïti','Haiti');
101.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (85,'HN','Honduras','Honduras');
102.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (86,'HK','Hong Kong','Hong Kong, (China)');
103.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (87,'HU','Hongrie','Hungary');
104.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (88,'BV','Ile Bouvet','Bouvet Island');
105.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (89,'CX','Ile Christmas','Christmas Island');
106.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (90,'NF','Ile Norfolk','Norfolk Island');
107.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (91,'KY','Iles Cayman','Cayman Islands');
108.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (92,'CK','Iles Cook','Cook Islands');
109.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (93,'FO','Iles Féroé','Faroe Islands');
110.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (94,'FK','Iles Falkland','Falkland Islands (Malvinas)');
111.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (95,'FJ','Iles Fidji','Fiji');
112.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (96,'GS','Iles Géorgie du Sud et Sandwich du Sud','S. Georgia and S. Sandwich Is.');
113.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (97,'HM','Iles Heard et McDonald','Heard and McDonald Islands');
114.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (98,'MH','Iles Marshall','Marshall Islands');
115.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (99,'PN','Iles Pitcairn','Pitcairn Island');
116.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (100,'SB','Iles Salomon','Solomon Islands');
117.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (101,'SJ','Iles Svalbard et Jan Mayen','Svalbard and Jan Mayen Islands');
118.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (102,'TC','Iles Turks-et-Caicos','Turks and Caicos Islands');
119.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (103,'VI','Iles Vierges américaines','Virgin Islands, U.S.');
120.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (104,'VG','Iles Vierges britanniques','Virgin Islands, British');
121.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (105,'CC','Iles des Cocos (Keeling)','Cocos (Keeling) Islands');
122.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (106,'UM','Iles mineures éloignées des �tats-Unis','US Minor Outlying Islands');
123.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (107,'IN','Inde','India');
124.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (108,'ID','Indonésie','Indonesia');
125.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (109,'IR','Iran','Iran, Islamic Republic of');
126.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (110,'IQ','Iraq','Iraq');
127.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (111,'IE','Irlande','Ireland');
128.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (112,'IS','Islande','Iceland');
129.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (113,'IL','Israël','Israel');
130.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (114,'IT','Italie','Italy');
131.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (115,'JM','Jamaïque','Jamaica');
132.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (116,'JP','Japon','Japan');
133.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (117,'JO','Jordanie','Jordan');
134.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (118,'KZ','Kazakhstan','Kazakhstan');
135.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (119,'KE','Kenya','Kenya');
136.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (120,'KG','Kirghizistan','Kyrgyzstan');
137.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (121,'KI','Kiribati','Kiribati');
138.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (122,'KW','Koweït','Kuwait');
139.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (123,'LA','Laos','Lao People\'s Democratic Republic');
140.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (124,'LS','Lesotho','Lesotho');
141.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (125,'LV','Lettonie','Latvia');
142.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (126,'LB','Liban','Lebanon');
143.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (127,'LR','Liberia','Liberia');
144.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (128,'LY','Libye','Libyan Arab Jamahiriya');
145.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (129,'LI','Liechtenstein','Liechtenstein');
146.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (130,'LT','Lituanie','Lithuania');
147.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (131,'LU','Luxembourg','Luxembourg');
148.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (132,'MO','Macao','Macao, (China)');
149.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (133,'MG','Madagascar','Madagascar');
150.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (134,'MY','Malaisie','Malaysia');
151.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (135,'MW','Malawi','Malawi');
152.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (136,'MV','Maldives','Maldives');
153.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (137,'ML','Mali','Mali');
154.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (138,'MT','Malte','Malta');
155.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (139,'MP','Mariannes du Nord','Northern Mariana Islands');
156.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (140,'MA','Maroc','Morocco');
157.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (141,'MQ','Martinique','Martinique');
158.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (142,'MU','Maurice','Mauritius');
159.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (143,'MR','Mauritanie','Mauritania');
160.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (144,'YT','Mayotte','Mayotte');
161.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (145,'MX','Mexique','Mexico');
162.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (146,'FM','Micronésie','Micronesia, Federated States of');
163.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (147,'MD','Moldavie','Moldova, Republic of');
164.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (148,'MC','Monaco','Monaco');
165.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (149,'MN','Mongolie','Mongolia');
166.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (150,'MS','Montserrat','Montserrat');
167.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (151,'MZ','Mozambique','Mozambique');
168.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (152,'NP','Népal','Nepal');
169.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (153,'NA','Namibie','Namibia');
170.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (154,'NR','Nauru','Nauru');
171.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (155,'NI','Nicaragua','Nicaragua');
172.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (156,'NE','Niger','Niger');
173.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (157,'NG','Nigeria','Nigeria');
174.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (158,'NU','Nioué','Niue');
175.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (159,'NO','Norvège','Norway');
176.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (160,'NC','Nouvelle-Calédonie','New Caledonia');
177.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (161,'NZ','Nouvelle-Zélande','New Zealand');
178.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (162,'OM','Oman','Oman');
179.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (163,'UG','Ouganda','Uganda');
180.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (164,'UZ','Ouzbékistan','Uzbekistan');
181.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (165,'PE','Pérou','Peru');
182.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (166,'PK','Pakistan','Pakistan');
183.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (167,'PA','Panama','Panama');
184.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (168,'PG','Papouasie-Nouvelle-Guinée','Papua New Guinea');
185.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (169,'PY','Paraguay','Paraguay');
186.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (170,'NL','Pays-Bas','Netherlands');
187.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (171,'PH','Philippines','Philippines');
188.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (172,'PL','Pologne','Poland');
189.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (173,'PF','Polynésie française','French Polynesia');
190.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (174,'PR','Porto Rico','Puerto Rico');
191.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (175,'PT','Portugal','Portugal');
192.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (176,'QA','Qatar','Qatar');
193.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (177,'CF','République centrafricaine','Central African Republic');
194.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (178,'CD','République démocratique du Congo','Congo, Democratic Rep. of the');
195.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (179,'DO','République dominicaine','Dominican Republic');
196.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (180,'CZ','République tchèque','Czech Republic');
197.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (181,'RE','Réunion','Reunion');
198.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (182,'RO','Roumanie','Romania');
199.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (183,'GB','Royaume-Uni','Saint Pierre and Miquelon');
200.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (184,'RU','Russie','Russia (Russian Federation)');
201.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (185,'RW','Rwanda','Rwanda');
202.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (186,'SN','Sénégal','Senegal');
203.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (187,'EH','Sahara occidental','Western Sahara');
204.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (188,'KN','Saint-Christophe-et-Niévès','Saint Kitts and Nevis');
205.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (189,'SM','Saint-Marin','San Marino');
206.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (190,'PM','Saint-Pierre-et-Miquelon','Saint Pierre and Miquelon');
207.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (191,'VA','Saint-Siège ','Vatican City State (Holy See)');
208.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (192,'VC','Saint-Vincent-et-les-Grenadines','Saint Vincent and the Grenadines');
209.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (193,'SH','Sainte-Hélène','Saint Helena');
210.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (194,'LC','Sainte-Lucie','Saint Lucia');
211.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (195,'SV','Salvador','El Salvador');
212.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (196,'WS','Samoa','Samoa');
213.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (197,'AS','Samoa américaines','American Samoa');
214.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (198,'ST','Sao Tomé-et-Principe','Sao Tome and Principe');
215.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (199,'SC','Seychelles','Seychelles');
216.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (200,'SL','Sierra Leone','Sierra Leone');
217.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (201,'SG','Singapour','Singapore');
218.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (202,'SI','Slovénie','Slovenia');
219.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (203,'SK','Slovaquie','Slovakia');
220.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (204,'SO','Somalie','Somalia');
221.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (205,'SD','Soudan','Sudan');
222.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (206,'LK','Sri Lanka','Sri Lanka (ex-Ceilan)');
223.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (207,'SE','Suède','Sweden');
224.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (208,'CH','Suisse','Switzerland');
225.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (209,'SR','Suriname','Suriname');
226.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (210,'SZ','Swaziland','Swaziland');
227.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (211,'SY','Syrie','Syrian Arab Republic');
228.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (212,'TW','Taïwan','Taiwan');
229.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (213,'TJ','Tadjikistan','Tajikistan');
230.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (214,'TZ','Tanzanie','Tanzania, United Republic of');
231.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (215,'TD','Tchad','Chad');
232.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (216,'TF','Terres australes françaises','French Southern Territories - TF');
233.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (217,'IO','Territoire britannique de l\'Océan Indien','British Indian Ocean Territory');
234.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (218,'TH','Thaïlande','Thailand');
235.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (219,'TL','Timor Oriental','Timor-Leste (East Timor)');
236.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (220,'TG','Togo','Togo');
237.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (221,'TK','Tokélaou','Tokelau');
238.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (222,'TO','Tonga','Tonga');
239.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (223,'TT','Trinité-et-Tobago','Trinidad & Tobago');
240.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (224,'TN','Tunisie','Tunisia');
241.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (225,'TM','Turkménistan','Turkmenistan');
242.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (226,'TR','Turquie','Turkey');
243.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (227,'TV','Tuvalu','Tuvalu');
244.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (228,'UA','Ukraine','Ukraine');
245.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (229,'UY','Uruguay','Uruguay');
246.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (230,'VU','Vanuatu','Vanuatu');
247.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (231,'VE','Venezuela','Venezuela');
248.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (232,'VN','Viêt Nam','Viet Nam');
249.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (233,'WF','Wallis-et-Futuna','Wallis and Futuna');
250.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (234,'YE','Yémen','Yemen');
251.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (235,'YU','Yougoslavie','Saint Pierre and Miquelon');
252.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (236,'ZM','Zambie','Zambia');
253.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (237,'ZW','Zimbabwe','Zimbabwe');
254.insert into `pays` (`rowid`,`code`,`fr`,`en`) values (238,'MK','ex-République yougoslave de Macédoine','Macedonia, TFYR');
255.
256.SET SQL_MODE=@OLD_SQL_MODE;
257.SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
Re: table pays
Posté : 15 oct. 2010, 19:50
par Shim
INSERT INTO tpays values('','France','fr');
INSERT INTO tpays values('','Afghanistan','af');
INSERT INTO tpays values('','Afrique du sud','za');
INSERT INTO tpays values('','Albanie','al');
INSERT INTO tpays values('','Algérie','dz');
INSERT INTO tpays values('','Allemagne','de');
INSERT INTO tpays values('','Arabie saoudite','sa');
INSERT INTO tpays values('','Argentine','ar');
INSERT INTO tpays values('','Australie','au');
INSERT INTO tpays values('','Autriche','at');
INSERT INTO tpays values('','Belgique','be');
INSERT INTO tpays values('','Brésil','br');
INSERT INTO tpays values('','Bulgarie','bg');
INSERT INTO tpays values('','Canada','ca');
INSERT INTO tpays values('','Chili','cl');
INSERT INTO tpays values('','Chine (Rép. pop.)','cn');
INSERT INTO tpays values('','Colombie','co');
INSERT INTO tpays values('','Corée, Sud','kr');
INSERT INTO tpays values('','Costa Rica','cr');
INSERT INTO tpays values('','Croatie','hr');
INSERT INTO tpays values('','Danemark','dk');
INSERT INTO tpays values('','Égypte','eg');
INSERT INTO tpays values('','Émirats arabes unis','ae');
INSERT INTO tpays values('','Équateur','ec');
INSERT INTO tpays values('','États-Unis','us');
INSERT INTO tpays values('','El Salvador','sv');
INSERT INTO tpays values('','Espagne','es');
INSERT INTO tpays values('','Finlande','fi');
INSERT INTO tpays values('','Grèce','gr');
INSERT INTO tpays values('','Hong Kong','hk');
INSERT INTO tpays values('','Hongrie','hu');
INSERT INTO tpays values('','Inde','in');
INSERT INTO tpays values('','Indonésie','id');
INSERT INTO tpays values('','Irlande','ie');
INSERT INTO tpays values('','Israël','il');
INSERT INTO tpays values('','Italie','it');
INSERT INTO tpays values('','Japon','jp');
INSERT INTO tpays values('','Jordanie','jo');
INSERT INTO tpays values('','Liban','lb');
INSERT INTO tpays values('','Malaisie','my');
INSERT INTO tpays values('','Maroc','ma');
INSERT INTO tpays values('','Mexique','mx');
INSERT INTO tpays values('','Norvège','no');
INSERT INTO tpays values('','Nouvelle-Zélande','nz');
INSERT INTO tpays values('','Pérou','pe');
INSERT INTO tpays values('','Pakistan','pk');
INSERT INTO tpays values('','Pays-Bas','nl');
INSERT INTO tpays values('','Philippines','ph');
INSERT INTO tpays values('','Pologne','pl');
INSERT INTO tpays values('','Porto Rico','pr');
INSERT INTO tpays values('','Portugal','pt');
INSERT INTO tpays values('','République tchèque','cz');
INSERT INTO tpays values('','Roumanie','ro');
INSERT INTO tpays values('','Royaume-Uni','uk');
INSERT INTO tpays values('','Russie','ru');
INSERT INTO tpays values('','Singapour','sg');
INSERT INTO tpays values('','Suède','se');
INSERT INTO tpays values('','Suisse','ch');
INSERT INTO tpays values('','Taiwan','tw');
INSERT INTO tpays values('','Thailande','th');
INSERT INTO tpays values('','Turquie','tr');
INSERT INTO tpays values('','Ukraine','ua');
INSERT INTO tpays values('','Venezuela','ve');
INSERT INTO tpays values('','Yougoslavie','yu');
INSERT INTO tpays values('','Samoa','as');
INSERT INTO tpays values('','Andorre','ad');
INSERT INTO tpays values('','Angola','ao');
INSERT INTO tpays values('','Anguilla','ai');
INSERT INTO tpays values('','Antarctique','aq');
INSERT INTO tpays values('','Antigua et Barbuda','ag');
INSERT INTO tpays values('','Arménie','am');
INSERT INTO tpays values('','Aruba','aw');
INSERT INTO tpays values('','Azerbaïdjan','az');
INSERT INTO tpays values('','Bahamas','bs');
INSERT INTO tpays values('','Bahrain','bh');
INSERT INTO tpays values('','Bangladesh','bd');
INSERT INTO tpays values('','Biélorussie','by');
INSERT INTO tpays values('','Belize','bz');
INSERT INTO tpays values('','Benin','bj');
INSERT INTO tpays values('','Bermudes (Les)','bm');
INSERT INTO tpays values('','Bhoutan','bt');
INSERT INTO tpays values('','Bolivie','bo');
INSERT INTO tpays values('','Bosnie-Herzégovine','ba');
INSERT INTO tpays values('','Botswana','bw');
INSERT INTO tpays values('','Bouvet (Îles)','bv');
INSERT INTO tpays values('','Territoire britannique de l\'océan Indien','io');
INSERT INTO tpays values('','Vierges britanniques (Îles)','vg');
INSERT INTO tpays values('','Brunei','bn');
INSERT INTO tpays values('','Burkina Faso','bf');
INSERT INTO tpays values('','Burundi','bi');
INSERT INTO tpays values('','Cambodge','kh');
INSERT INTO tpays values('','Cameroun','cm');
INSERT INTO tpays values('','Cap Vert','cv');
INSERT INTO tpays values('','Cayman (Îles)','ky');
INSERT INTO tpays values('','République centrafricaine','cf');
INSERT INTO tpays values('','Tchad','td');
INSERT INTO tpays values('','Christmas (Île)','cx');
INSERT INTO tpays values('','Cocos (Îles)','cc');
INSERT INTO tpays values('','Comores','km');
INSERT INTO tpays values('','Rép. Dém. du Congo','cg');
INSERT INTO tpays values('','Cook (Îles)','ck');
INSERT INTO tpays values('','Cuba','cu');
INSERT INTO tpays values('','Chypre','cy');
INSERT INTO tpays values('','Djibouti','dj');
INSERT INTO tpays values('','Dominique','dm');
INSERT INTO tpays values('','République Dominicaine','do');
INSERT INTO tpays values('','Timor','tp');
INSERT INTO tpays values('','Guinée Equatoriale','gq');
INSERT INTO tpays values('','Érythrée','er');
INSERT INTO tpays values('','Estonie','ee');
INSERT INTO tpays values('','Ethiopie','et');
INSERT INTO tpays values('','Falkland (Île)','fk');
INSERT INTO tpays values('','Féroé (Îles)','fo');
INSERT INTO tpays values('','Fidji (République des)','fj');
INSERT INTO tpays values('','Guyane française','gf');
INSERT INTO tpays values('','Polynésie française','pf');
INSERT INTO tpays values('','Territoires français du sud','tf');
INSERT INTO tpays values('','Gabon','ga');
INSERT INTO tpays values('','Gambie','gm');
INSERT INTO tpays values('','Géorgie','ge');
INSERT INTO tpays values('','Ghana','gh');
INSERT INTO tpays values('','Gibraltar','gi');
INSERT INTO tpays values('','Groenland','gl');
INSERT INTO tpays values('','Grenade','gd');
INSERT INTO tpays values('','Guadeloupe','gp');
INSERT INTO tpays values('','Guam','gu');
INSERT INTO tpays values('','Guatemala','gt');
INSERT INTO tpays values('','Guinée','gn');
INSERT INTO tpays values('','Guinée-Bissau','gw');
INSERT INTO tpays values('','Guyane','gy');
INSERT INTO tpays values('','Haïti','ht');
INSERT INTO tpays values('','Heard et McDonald (Îles)','hm');
INSERT INTO tpays values('','Honduras','hn');
INSERT INTO tpays values('','Islande','is');
INSERT INTO tpays values('','Iran','ir');
INSERT INTO tpays values('','Irak','iq');
INSERT INTO tpays values('','Côte d\'Ivoire','ci');
INSERT INTO tpays values('','Jamaïque','jm');
INSERT INTO tpays values('','Kazakhstan','kz');
INSERT INTO tpays values('','Kenya','ke');
INSERT INTO tpays values('','Kiribati','ki');
INSERT INTO tpays values('','Corée du Nord','kp');
INSERT INTO tpays values('','Koweit','kw');
INSERT INTO tpays values('','Kirghizistan','kg');
INSERT INTO tpays values('','Laos','la');
INSERT INTO tpays values('','Lettonie','lv');
INSERT INTO tpays values('','Lesotho','ls');
INSERT INTO tpays values('','Libéria','lr');
INSERT INTO tpays values('','Libye','ly');
INSERT INTO tpays values('','Liechtenstein','li');
INSERT INTO tpays values('','Lithuanie','lt');
INSERT INTO tpays values('','Luxembourg','lu');
INSERT INTO tpays values('','Macau','mo');
INSERT INTO tpays values('','Macédoine','mk');
INSERT INTO tpays values('','Madagascar','mg');
INSERT INTO tpays values('','Malawi','mw');
INSERT INTO tpays values('','Maldives (Îles)','mv');
INSERT INTO tpays values('','Mali','ml');
INSERT INTO tpays values('','Malte','mt');
INSERT INTO tpays values('','Marshall (Îles)','mh');
INSERT INTO tpays values('','Martinique','mq');
INSERT INTO tpays values('','Mauritanie','mr');
INSERT INTO tpays values('','Maurice','mu');
INSERT INTO tpays values('','Mayotte','yt');
INSERT INTO tpays values('','Micronésie (États fédérés de)','fm');
INSERT INTO tpays values('','Moldavie','md');
INSERT INTO tpays values('','Monaco','mc');
INSERT INTO tpays values('','Mongolie','mn');
INSERT INTO tpays values('','Montserrat','ms');
INSERT INTO tpays values('','Mozambique','mz');
INSERT INTO tpays values('','Myanmar','mm');
INSERT INTO tpays values('','Namibie','na');
INSERT INTO tpays values('','Nauru','nr');
INSERT INTO tpays values('','Nepal','np');
INSERT INTO tpays values('','Antilles néerlandaises','an');
INSERT INTO tpays values('','Nouvelle Calédonie','nc');
INSERT INTO tpays values('','Nicaragua','ni');
INSERT INTO tpays values('','Niger','ne');
INSERT INTO tpays values('','Nigeria','ng');
INSERT INTO tpays values('','Niue','nu');
INSERT INTO tpays values('','Norfolk (Îles)','nf');
INSERT INTO tpays values('','Mariannes du Nord (Îles)','mp');
INSERT INTO tpays values('','Oman','om');
INSERT INTO tpays values('','Palau','pw');
INSERT INTO tpays values('','Panama','pa');
INSERT INTO tpays values('','Papouasie-Nouvelle-Guinée','pg');
INSERT INTO tpays values('','Paraguay','py');
INSERT INTO tpays values('','Pitcairn (Îles)','pn');
INSERT INTO tpays values('','Qatar','qa');
INSERT INTO tpays values('','Réunion (La)','re');
INSERT INTO tpays values('','Rwanda','rw');
INSERT INTO tpays values('','Géorgie du Sud et Sandwich du Sud (Îles)','gs');
INSERT INTO tpays values('','Saint-Kitts et Nevis','kn');
INSERT INTO tpays values('','Sainte Lucie','lc');
INSERT INTO tpays values('','Saint Vincent et les Grenadines','vc');
INSERT INTO tpays values('','Samoa','ws');
INSERT INTO tpays values('','Saint-Marin (Rép. de)','sm');
INSERT INTO tpays values('','São Tomé et Príncipe (Rép.)','st');
INSERT INTO tpays values('','Sénégal','sn');
INSERT INTO tpays values('','Seychelles','sc');
INSERT INTO tpays values('','Sierra Leone','sl');
INSERT INTO tpays values('','Slovaquie','sk');
INSERT INTO tpays values('','Slovénie','si');
INSERT INTO tpays values('','Somalie','so');
INSERT INTO tpays values('','Sri Lanka','lk');
INSERT INTO tpays values('','Sainte Hélène','sh');
INSERT INTO tpays values('','Saint Pierre et Miquelon','pm');
INSERT INTO tpays values('','Soudan','sd');
INSERT INTO tpays values('','Suriname','sr');
INSERT INTO tpays values('','Svalbard et Jan Mayen (Îles)','sj');
INSERT INTO tpays values('','Swaziland','sz');
INSERT INTO tpays values('','Syrie','sy');
INSERT INTO tpays values('','Tadjikistan','tj');
INSERT INTO tpays values('','Tanzanie','tz');
INSERT INTO tpays values('','Togo','tg');
INSERT INTO tpays values('','Tokelau','tk');
INSERT INTO tpays values('','Tonga','to');
INSERT INTO tpays values('','Trinité et Tobago','tt');
INSERT INTO tpays values('','Tunisie','tn');
INSERT INTO tpays values('','Turkménistan','tm');
INSERT INTO tpays values('','Turks et Caïques (Îles)','tc');
INSERT INTO tpays values('','Tuvalu','tv');
INSERT INTO tpays values('','Îles Mineures Éloignées des États-Unis','um');
INSERT INTO tpays values('','Ouganda','ug');
INSERT INTO tpays values('','Uruguay','uy');
INSERT INTO tpays values('','Ouzbékistan','uz');
INSERT INTO tpays values('','Vanuatu','vu');
INSERT INTO tpays values('','Vatican (Etat du)','va');
INSERT INTO tpays values('','Vietnam','vn');
INSERT INTO tpays values('','Vierges (Îles)','vi');
INSERT INTO tpays values('','Wallis et Futuna (Îles)','wf');
INSERT INTO tpays values('','Sahara Occidental','eh');
INSERT INTO tpays values('','Yemen','ye');
INSERT INTO tpays values('','Zaïre','zr');
INSERT INTO tpays values('','Zambie','zm');
INSERT INTO tpays values('','Zimbabwe','zw');
INSERT INTO tpays values('','La Barbad','bb');