Subversion Repositories ALCASAR

Rev

Details | Last modification | View Log

Rev Author Line No. Line
1349 richard 1
-- phpMyAdmin SQL Dump
1416 richard 2
-- version 4.1.14.1
1349 richard 3
-- http://www.phpmyadmin.net
4
--
1416 richard 5
-- Client :  localhost
6
-- Généré le :  Mar 22 Juillet 2014 à 10:01
7
-- Version du serveur :  5.5.37-MariaDB
8
-- Version de PHP :  5.5.14
1349 richard 9
 
1416 richard 10
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
1349 richard 11
SET time_zone = "+00:00";
12
 
13
 
14
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
15
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
16
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
17
/*!40101 SET NAMES utf8 */;
18
 
19
--
1416 richard 20
-- Base de données :  `gammu`
1349 richard 21
--
22
 
23
-- --------------------------------------------------------
24
 
25
--
26
-- Structure de la table `daemons`
27
--
28
 
29
CREATE TABLE IF NOT EXISTS `daemons` (
30
  `Start` text NOT NULL,
31
  `Info` text NOT NULL
32
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
33
 
34
-- --------------------------------------------------------
35
 
36
--
37
-- Structure de la table `gammu`
38
--
39
 
40
CREATE TABLE IF NOT EXISTS `gammu` (
41
  `Version` int(11) NOT NULL DEFAULT '0'
42
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
43
 
44
--
45
-- Contenu de la table `gammu`
46
--
47
 
48
INSERT INTO `gammu` (`Version`) VALUES
49
(13);
50
 
51
-- --------------------------------------------------------
52
 
53
--
54
-- Structure de la table `inbox`
55
--
56
 
57
CREATE TABLE IF NOT EXISTS `inbox` (
58
  `UpdatedInDB` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
59
  `ReceivingDateTime` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
60
  `Text` text NOT NULL,
61
  `SenderNumber` varchar(20) NOT NULL DEFAULT '',
62
  `Coding` enum('Default_No_Compression','Unicode_No_Compression','8bit','Default_Compression','Unicode_Compression') NOT NULL DEFAULT 'Default_No_Compression',
63
  `UDH` text NOT NULL,
64
  `SMSCNumber` varchar(20) NOT NULL DEFAULT '',
65
  `Class` int(11) NOT NULL DEFAULT '-1',
66
  `TextDecoded` text NOT NULL,
67
  `ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
68
  `RecipientID` text NOT NULL,
69
  `Processed` enum('false','true') NOT NULL DEFAULT 'false',
70
  PRIMARY KEY (`ID`)
1416 richard 71
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1349 richard 72
 
73
--
74
-- Déclencheurs `inbox`
75
--
76
DROP TRIGGER IF EXISTS `inbox_timestamp`;
77
DELIMITER //
78
CREATE TRIGGER `inbox_timestamp` BEFORE INSERT ON `inbox`
79
 FOR EACH ROW BEGIN
80
    IF NEW.ReceivingDateTime = '0000-00-00 00:00:00' THEN
81
        SET NEW.ReceivingDateTime = CURRENT_TIMESTAMP();
82
    END IF;
83
END
84
//
85
DELIMITER ;
86
 
87
-- --------------------------------------------------------
88
 
89
--
90
-- Structure de la table `outbox`
91
--
92
 
93
CREATE TABLE IF NOT EXISTS `outbox` (
94
  `UpdatedInDB` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
95
  `InsertIntoDB` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
96
  `SendingDateTime` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
97
  `SendBefore` time NOT NULL DEFAULT '23:59:59',
98
  `SendAfter` time NOT NULL DEFAULT '00:00:00',
99
  `Text` text,
100
  `DestinationNumber` varchar(20) NOT NULL DEFAULT '',
101
  `Coding` enum('Default_No_Compression','Unicode_No_Compression','8bit','Default_Compression','Unicode_Compression') NOT NULL DEFAULT 'Default_No_Compression',
102
  `UDH` text,
103
  `Class` int(11) DEFAULT '-1',
104
  `TextDecoded` text NOT NULL,
105
  `ID` int(10) unsigned NOT NULL AUTO_INCREMENT,
106
  `MultiPart` enum('false','true') DEFAULT 'false',
107
  `RelativeValidity` int(11) DEFAULT '-1',
108
  `SenderID` varchar(255) DEFAULT NULL,
109
  `SendingTimeOut` timestamp NULL DEFAULT '0000-00-00 00:00:00',
110
  `DeliveryReport` enum('default','yes','no') DEFAULT 'default',
111
  `CreatorID` text NOT NULL,
112
  PRIMARY KEY (`ID`),
113
  KEY `outbox_date` (`SendingDateTime`,`SendingTimeOut`),
114
  KEY `outbox_sender` (`SenderID`)
115
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
116
 
117
--
118
-- Déclencheurs `outbox`
119
--
120
DROP TRIGGER IF EXISTS `outbox_timestamp`;
121
DELIMITER //
122
CREATE TRIGGER `outbox_timestamp` BEFORE INSERT ON `outbox`
123
 FOR EACH ROW BEGIN
124
    IF NEW.InsertIntoDB = '0000-00-00 00:00:00' THEN
125
        SET NEW.InsertIntoDB = CURRENT_TIMESTAMP();
126
    END IF;
127
    IF NEW.SendingDateTime = '0000-00-00 00:00:00' THEN
128
        SET NEW.SendingDateTime = CURRENT_TIMESTAMP();
129
    END IF;
130
    IF NEW.SendingTimeOut = '0000-00-00 00:00:00' THEN
131
        SET NEW.SendingTimeOut = CURRENT_TIMESTAMP();
132
    END IF;
133
END
134
//
135
DELIMITER ;
136
 
137
-- --------------------------------------------------------
138
 
139
--
140
-- Structure de la table `outbox_multipart`
141
--
142
 
143
CREATE TABLE IF NOT EXISTS `outbox_multipart` (
144
  `Text` text,
145
  `Coding` enum('Default_No_Compression','Unicode_No_Compression','8bit','Default_Compression','Unicode_Compression') NOT NULL DEFAULT 'Default_No_Compression',
146
  `UDH` text,
147
  `Class` int(11) DEFAULT '-1',
148
  `TextDecoded` text,
149
  `ID` int(10) unsigned NOT NULL DEFAULT '0',
150
  `SequencePosition` int(11) NOT NULL DEFAULT '1',
151
  PRIMARY KEY (`ID`,`SequencePosition`)
152
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
153
 
154
-- --------------------------------------------------------
155
 
156
--
157
-- Structure de la table `pbk`
158
--
159
 
160
CREATE TABLE IF NOT EXISTS `pbk` (
161
  `ID` int(11) NOT NULL AUTO_INCREMENT,
162
  `GroupID` int(11) NOT NULL DEFAULT '-1',
163
  `Name` text NOT NULL,
164
  `Number` text NOT NULL,
165
  PRIMARY KEY (`ID`)
166
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
167
 
168
-- --------------------------------------------------------
169
 
170
--
171
-- Structure de la table `pbk_groups`
172
--
173
 
174
CREATE TABLE IF NOT EXISTS `pbk_groups` (
175
  `Name` text NOT NULL,
176
  `ID` int(11) NOT NULL AUTO_INCREMENT,
177
  PRIMARY KEY (`ID`)
178
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
179
 
180
-- --------------------------------------------------------
181
 
182
--
183
-- Structure de la table `phones`
184
--
185
 
186
CREATE TABLE IF NOT EXISTS `phones` (
187
  `ID` text NOT NULL,
188
  `UpdatedInDB` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
189
  `InsertIntoDB` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
190
  `TimeOut` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
191
  `Send` enum('yes','no') NOT NULL DEFAULT 'no',
192
  `Receive` enum('yes','no') NOT NULL DEFAULT 'no',
193
  `IMEI` varchar(35) NOT NULL,
194
  `Client` text NOT NULL,
195
  `Battery` int(11) NOT NULL DEFAULT '-1',
196
  `Signal` int(11) NOT NULL DEFAULT '-1',
197
  `Sent` int(11) NOT NULL DEFAULT '0',
198
  `Received` int(11) NOT NULL DEFAULT '0',
199
  PRIMARY KEY (`IMEI`)
200
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
201
 
202
 
203
--
204
-- Déclencheurs `phones`
205
--
206
DROP TRIGGER IF EXISTS `phones_timestamp`;
207
DELIMITER //
208
CREATE TRIGGER `phones_timestamp` BEFORE INSERT ON `phones`
209
 FOR EACH ROW BEGIN
210
    IF NEW.InsertIntoDB = '0000-00-00 00:00:00' THEN
211
        SET NEW.InsertIntoDB = CURRENT_TIMESTAMP();
212
    END IF;
213
    IF NEW.TimeOut = '0000-00-00 00:00:00' THEN
214
        SET NEW.TimeOut = CURRENT_TIMESTAMP();
215
    END IF;
216
END
217
//
218
DELIMITER ;
219
 
220
-- --------------------------------------------------------
221
 
222
--
223
-- Structure de la table `sentitems`
224
--
225
 
226
CREATE TABLE IF NOT EXISTS `sentitems` (
227
  `UpdatedInDB` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
228
  `InsertIntoDB` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
229
  `SendingDateTime` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
230
  `DeliveryDateTime` timestamp NULL DEFAULT NULL,
231
  `Text` text NOT NULL,
232
  `DestinationNumber` varchar(20) NOT NULL DEFAULT '',
233
  `Coding` enum('Default_No_Compression','Unicode_No_Compression','8bit','Default_Compression','Unicode_Compression') NOT NULL DEFAULT 'Default_No_Compression',
234
  `UDH` text NOT NULL,
235
  `SMSCNumber` varchar(20) NOT NULL DEFAULT '',
236
  `Class` int(11) NOT NULL DEFAULT '-1',
237
  `TextDecoded` text NOT NULL,
238
  `ID` int(10) unsigned NOT NULL DEFAULT '0',
239
  `SenderID` varchar(255) NOT NULL,
240
  `SequencePosition` int(11) NOT NULL DEFAULT '1',
241
  `Status` enum('SendingOK','SendingOKNoReport','SendingError','DeliveryOK','DeliveryFailed','DeliveryPending','DeliveryUnknown','Error') NOT NULL DEFAULT 'SendingOK',
242
  `StatusError` int(11) NOT NULL DEFAULT '-1',
243
  `TPMR` int(11) NOT NULL DEFAULT '-1',
244
  `RelativeValidity` int(11) NOT NULL DEFAULT '-1',
245
  `CreatorID` text NOT NULL,
246
  PRIMARY KEY (`ID`,`SequencePosition`),
247
  KEY `sentitems_date` (`DeliveryDateTime`),
248
  KEY `sentitems_tpmr` (`TPMR`),
249
  KEY `sentitems_dest` (`DestinationNumber`),
250
  KEY `sentitems_sender` (`SenderID`)
251
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
252
 
253
--
254
-- Déclencheurs `sentitems`
255
--
256
DROP TRIGGER IF EXISTS `sentitems_timestamp`;
257
DELIMITER //
258
CREATE TRIGGER `sentitems_timestamp` BEFORE INSERT ON `sentitems`
259
 FOR EACH ROW BEGIN
260
    IF NEW.InsertIntoDB = '0000-00-00 00:00:00' THEN
261
        SET NEW.InsertIntoDB = CURRENT_TIMESTAMP();
262
    END IF;
263
    IF NEW.SendingDateTime = '0000-00-00 00:00:00' THEN
264
        SET NEW.SendingDateTime = CURRENT_TIMESTAMP();
265
    END IF;
266
END
267
//
268
DELIMITER ;
269
 
270
-- --------------------------------------------------------
271
 
272
--
273
-- Structure de la table `SMS_ban_perm`
274
--
275
 
276
CREATE TABLE IF NOT EXISTS `SMS_ban_perm` (
277
  `SenderNumber` varchar(20) CHARACTER SET utf8 NOT NULL,
278
  `Expiration` varchar(255) CHARACTER SET utf8 NOT NULL,
279
  `Perm` int(11) NOT NULL,
280
  `date_add` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
281
  PRIMARY KEY (`SenderNumber`)
282
) ENGINE=MyISAM DEFAULT CHARSET=utf32;
283
 
284
 
285
-- --------------------------------------------------------
286
 
287
--
288
-- Structure de la table `SMS_ban_temp`
289
--
290
 
291
CREATE TABLE IF NOT EXISTS `SMS_ban_temp` (
292
  `ID` int(11) NOT NULL AUTO_INCREMENT,
293
  `SenderNumber` varchar(20) NOT NULL,
294
  PRIMARY KEY (`ID`)
295
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;
1416 richard 296
 
297
 
298
-- --------------------------------------------------------
299
 
300
--
301
-- Structure de la table `SMS_country`
302
--
303
 
304
CREATE TABLE IF NOT EXISTS `SMS_country` (
305
  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_swedish_ci NOT NULL,
306
  `id` varchar(20) CHARACTER SET utf8 COLLATE utf8_swedish_ci NOT NULL,
307
  `status` int(1) NOT NULL DEFAULT '0',
308
  PRIMARY KEY (`name`)
309
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
310
 
311
--
312
-- Contenu de la table `SMS_country`
313
--
314
 
315
INSERT INTO `SMS_country` (`name`, `id`, `status`) VALUES
316
('Afghanistan', '+93', 0),
317
('Afrique du Sud', '+27', 0),
318
('Albanie', '+355', 0),
319
('Algerie', '+213', 0),
320
('Allemagne', '+49', 0),
321
('Andorre', '+376', 0),
322
('Angleterre', '+44', 0),
323
('Angola', '+244', 0),
324
('Anguilla', '+1264', 0),
325
('Antigua et Barbuda', '+1268', 0),
326
('Arabie Saoudite', '+966', 0),
327
('Argentine', '+54', 0),
328
('Armenie', '+374', 0),
329
('Aruba', '+297', 0),
330
('Australie', '+61', 0),
331
('Autriche', '+43', 0),
332
('Azerbaidjan', '+994', 0),
333
('Bahamas', '+1242', 0),
334
('Bahrein', '+973', 0),
335
('Bangladesh', '+880', 0),
336
('Barbade', '+1246', 0),
337
('Belgique', '+32', 0),
338
('Benin', '+229', 0),
339
('Bermudes', '+1441', 0),
340
('Bhoutan', '+975', 0),
341
('Bielorussie', '+375', 0),
342
('Birmanie', '+95', 0),
343
('Bolivie', '+591', 0),
344
('Bonaire', '+599', 0),
345
('Bosnie', '+387', 0),
346
('Botswana', '+267', 0),
347
('Bresil', '+55', 0),
348
('Brunei', '+673', 0),
349
('Bulgarie', '+359', 0),
350
('Burkina Faso', '+226', 0),
351
('Burundi', '+257', 0),
352
('Cambodge', '+855', 0),
353
('Cameroun', '+237', 0),
354
('Canada', '+1', 0),
355
('Cap Vert', '+238', 0),
356
('Chili', '+56', 0),
357
('Chine', '+86', 0),
358
('Chypre', '+357', 0),
359
('Colombie', '+57', 0),
360
('Comores', '+269', 0),
361
('Congo RDC', '+243', 0),
362
('Congo RPC', '+242', 0),
363
('Coree du Nord', '+850', 0),
364
('Coree du Sud', '+82', 0),
365
('Costa Rica 1', '+501', 0),
366
('Costa Rica 2', '+506', 0),
367
('Cote d Ivoire', '+225', 0),
368
('Croatie', '+385', 0),
369
('Cuba', '+53', 0),
370
('Curacao', '+599', 0),
371
('Danemark', '+45', 0),
372
('Djibouti', '+253', 0),
373
('Dominique', '+1767', 0),
374
('Egypte', '+20', 0),
375
('El Salvador', '+503', 0),
376
('Emirats Arabes Unis', '+971', 0),
377
('Equateur', '+593', 0),
378
('Erythree', '+291', 0),
379
('Espagne', '+34', 0),
380
('Estonie', '+372', 0),
381
('Etats-Unis', '+1', 0),
382
('Ethiopie', '+251', 0),
383
('Falklands Malouines', '+500', 0),
384
('Finlande', '+358', 0),
385
('France', '+33', 1),
386
('Gabon', '+241', 0),
387
('Gambie', '+220', 0),
388
('Georgie', '+995', 0),
389
('Ghana', '+233', 0),
390
('Gibraltar', '+350', 0),
391
('Grece', '+30', 0),
392
('Grenade', '+1473', 0),
393
('Groenland', '+299', 0),
394
('Guadeloupe', '+590', 0),
395
('Guatemala', '+502', 0),
396
('Guernesey', '+441481', 0),
397
('Guinee', '+224', 0),
398
('Guinee Bissau', '+245', 0),
399
('Guinee Equatoriale', '+240', 0),
400
('Guyana', '+5921', 0),
401
('Guyane France', '+594', 0),
402
('Haiti', '+509', 0),
403
('Herm', '+441481', 0),
404
('Honduras', '+504', 0),
405
('Hong Kong', '+852', 0),
406
('Hongrie', '+36', 0),
407
('Ile de Ascension', '+247', 0),
408
('Ile Maurice', '+230', 0),
409
('Iles Cayman', '+1345', 0),
410
('Iles Christmas', '+61', 0),
411
('Iles Coco', '+61', 0),
412
('Iles Cook', '+682', 0),
413
('Iles Fidji', '+679', 0),
414
('Iles Mariannes', '+1670', 0),
415
('Iles Marshall', '+692', 0),
416
('Iles Salomon', '+677', 0),
417
('Iles Vierges GB', '+1284', 0),
418
('Iles Vierges USA', '+1340', 0),
419
('Inde', '+91', 0),
420
('Indonesie', '+62', 0),
421
('Irak', '+964', 0),
422
('Iran', '+98', 0),
423
('Irlande', '+353', 0),
424
('Islande', '+354', 0),
425
('Israel', '+972', 0),
426
('Italie', '+39', 0),
427
('Jamaique', '+1876', 0),
428
('Japon', '+81', 0),
429
('Jersey', '+441534', 0),
430
('Jordanie', '+962', 0),
431
('Kazakhstan', '+7', 0),
432
('Kenya', '+254', 0),
433
('Kirghizistan', '+996', 0),
434
('Kiribati', '+686', 0),
435
('Koweit', '+965', 0),
436
('Laos', '+856', 0),
437
('Lesotho', '+266', 0),
438
('Lettonie', '+371', 0),
439
('Liban', '+961', 0),
440
('Libye', '+218', 0),
441
('Liechtenstein', '+423', 0),
442
('Lituanie', '+370', 0),
443
('Luxembourg', '+352', 0),
444
('Macao', '+853', 0),
445
('Macedoine', '+389', 0),
446
('Madagascar', '+261', 0),
447
('Malaisie', '+60', 0),
448
('Malawi', '+265', 0),
449
('Maldives', '+960', 0),
450
('Mali', '+223', 0),
451
('Malte', '+356', 0),
452
('Maroc', '+212', 0),
453
('Martinique', '+596', 0),
454
('Mauritanie', '+222', 0),
455
('Mayotte', '+269', 0),
456
('Mexique', '+52', 0),
457
('Micronesie', '+691', 0),
458
('Moldavie', '+373', 0),
459
('Monaco', '+377', 0),
460
('Mongolie', '+9761', 0),
461
('Montserrat', '+1664', 0),
462
('Mozambique', '+258', 0),
463
('Namibie', '+264', 0),
464
('Nauru', '+674', 0),
465
('Nepal', '+977', 0),
466
('Nicaragua', '+505', 0),
467
('Niger', '+227', 0),
468
('Nigeria', '+2349', 0),
469
('Norvege', '+47', 0),
470
('Nouvelle Caledonie', '+687', 0),
471
('Nouvelle Zelande', '+64', 0),
472
('Oman', '+968', 0),
473
('Ouganda', '+2560', 0),
474
('Ouzbekistan', '+998', 0),
475
('Pakistan', '+92', 0),
476
('Palau', '+680', 0),
477
('Palestine', '+970', 0),
478
('Panama', '+507', 0),
479
('Papouasie Nouvelle Guinee', '+675', 0),
480
('Paraguay', '+595', 0),
481
('Pays-Bas', '+31', 0),
482
('Perou', '+51', 0),
483
('Philippines', '+63', 0),
484
('Pologne', '+48', 0),
485
('Polynesie France', '+689', 0),
486
('Porto Rico', '+1787', 0),
487
('Portugal', '+351', 0),
488
('Qatar', '+974', 0),
489
('Republique Centrafricaine', '+236', 0),
490
('Republique Dominicaine', '+1809', 0),
491
('Republique Tcheque', '+420', 0),
492
('Reunion', '+262', 0),
493
('Roumanie', '+40', 0),
494
('Royaume Uni', '+44', 0),
495
('Russie', '+7', 0),
496
('Rwanda', '+250', 0),
497
('Saint Marin (Rep.)', '+378', 0),
498
('Sainte Lucie', '+1758', 0),
499
('Samoa occidental', '+685', 0),
500
('Sao Tome et Principe', '+239', 0),
501
('Senegal', '+221', 0),
502
('Serbie', '+381', 0),
503
('Sercq', '+441481', 0),
504
('Seychelles', '+248', 0),
505
('Sierra Leone', '+232', 0),
506
('Singapour', '+65', 0),
507
('Slovaquie', '+421', 0),
508
('Slovenie', '+386', 0),
509
('Somalie', '+252', 0),
510
('Soudan', '+249', 0),
511
('Sri Lanka', '+94', 0),
512
('St Kitts', '+1869', 0),
513
('St Pierre et Miquelon', '+508', 0),
514
('St Vincent et les Grenadines', '+1784', 0),
515
('Suede', '+46', 0),
516
('Suisse', '+41', 0),
517
('Surinam', '+597', 0),
518
('Swaziland', '+268', 0),
519
('Syrie', '+963', 0),
520
('Tadjikistan', '+992', 0),
521
('Taiwan', '+886', 0),
522
('Tanzanie', '+255', 0),
523
('Tchad', '+235', 0),
524
('Thailande', '+661', 0),
525
('Togo', '+228', 0),
526
('Tonga', '+676', 0),
527
('Trinidad et Tobago', '+1868', 0),
528
('Tunisie', '+216', 0),
529
('Turkmenistan', '+993', 0),
530
('Turks et Caicos', '+1649', 0),
531
('Turquie', '+90', 0),
532
('Tuvalu', '+688', 0),
533
('Ukraine', '+380', 0),
534
('Uruguay', '+598', 0),
535
('Vanuatu', '+678', 0),
536
('Vatican', '+379', 0),
537
('Venezuela', '+58', 0),
538
('Vietnam', '+84', 0),
539
('Wallis et Futuna', '+681', 0),
540
('Yemen', '+967', 0),
541
('Zambie', '+260', 0),
542
('Zimbabwe', '+263', 0),
543
('FILTRAGE', 'fr', 0);
544
 
545
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
546
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
547
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;