Version20130930180819_Init::createTableCountry()   A
last analyzed

Complexity

Conditions 1
Paths 1

Size

Total Lines 7
Code Lines 2

Duplication

Lines 0
Ratio 0 %

Importance

Changes 0
Metric Value
c 0
b 0
f 0
dl 0
loc 7
rs 9.4285
cc 1
eloc 2
nc 1
nop 0
1
<?php
2
/**
3
 * AnimeDb package.
4
 *
5
 * @author    Peter Gribanov <[email protected]>
6
 * @copyright Copyright (c) 2011, Peter Gribanov
7
 * @license   http://opensource.org/licenses/GPL-3.0 GPL v3
8
 */
9
10
namespace AnimeDb\Bundle\CatalogBundle\DoctrineMigrations;
11
12
use Doctrine\DBAL\Migrations\AbstractMigration;
13
use Doctrine\DBAL\Schema\Schema;
14
15
/**
16
 * Auto-generated Migration: Please modify to your needs!
17
 */
18
class Version20130930180819_Init extends AbstractMigration
19
{
20
    /**
21
     * @param Schema $schema
22
     */
23
    public function up(Schema $schema)
24
    {
25
        // create tables
26
        $this->createTableImage();
27
        $this->createTableType();
28
        $this->createTableName();
29
        $this->createTableItemsGenres();
30
        $this->createTableSource();
31
        $this->createTableCountry();
32
        $this->createTableGenre();
33
        $this->createTableExtTranslations();
34
        $this->createTableCountryTranslation();
35
        $this->createTableStorage();
36
        $this->createTableItem();
37
38
        // clear sqlite sequence
39
        $this->addSql('DELETE FROM sqlite_sequence WHERE name IN ("image", "name", "source", "genre", "storage", "item")');
40
        // add sequence for image
41
        $this->addSql('INSERT INTO "sqlite_sequence" VALUES("image",0)');
42
43
        // add data
44
        $this->addDataTypes();
45
        $this->addDataCountry();
46
        $this->addDataGenre();
47
        $this->addDataExtTranslations();
48
        $this->addDataCountryTranslation();
49
    }
50
51
    /**
52
     * @param Schema $schema
53
     */
54
    public function down(Schema $schema)
55
    {
56
        // drop tables
57
        $schema->dropTable('image');
58
        $schema->dropTable('type');
59
        $schema->dropTable('name');
60
        $schema->dropTable('items_genres');
61
        $schema->dropTable('source');
62
        $schema->dropTable('country');
63
        $schema->dropTable('genre');
64
        $schema->dropTable('ext_translations');
65
        $schema->dropTable('country_translation');
66
        $schema->dropTable('storage');
67
        $schema->dropTable('item');
68
69
        // clear sqlite sequence
70
        $this->addSql('DELETE FROM sqlite_sequence WHERE name IN ("image", "name", "source", "genre", "storage", "item")');
71
    }
72
73
    protected function createTableImage()
74
    {
75
        $this->addSql('CREATE TABLE image (
76
            id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
77
            item INTEGER DEFAULT NULL,
78
            source VARCHAR(256) NOT NULL
79
        )');
80
        // add index
81
        $this->addSql('CREATE INDEX image_item_idx ON image (item)');
82
    }
83
84
    protected function createTableType()
85
    {
86
        $this->addSql('CREATE TABLE type (
87
            id VARCHAR(16) PRIMARY KEY NOT NULL,
88
            name VARCHAR(32) NOT NULL
89
        )');
90
    }
91
92
    protected function createTableName()
93
    {
94
        $this->addSql('CREATE TABLE name (
95
            id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
96
            item INTEGER DEFAULT NULL,
97
            name VARCHAR(256) NOT NULL
98
        )');
99
        // add index
100
        $this->addSql('CREATE INDEX name_item_idx ON name (item)');
101
    }
102
103
    protected function createTableItemsGenres()
104
    {
105
        $this->addSql('CREATE TABLE items_genres (
106
            item_id INTEGER NOT NULL,
107
            genre_id INTEGER NOT NULL,
108
            PRIMARY KEY(item_id, genre_id)
109
        )');
110
        // add index
111
        $this->addSql('CREATE INDEX item_genres_item_id_idx ON items_genres (item_id)');
112
        $this->addSql('CREATE INDEX item_genres_genre_id_idx ON items_genres (genre_id)');
113
    }
114
115
    protected function createTableSource()
116
    {
117
        $this->addSql('CREATE TABLE source (
118
            id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
119
            item INTEGER DEFAULT NULL,
120
            url VARCHAR(256) NOT NULL
121
        )');
122
        // add index
123
        $this->addSql('CREATE INDEX source_item_idx ON source (item)');
124
    }
125
126
    protected function createTableCountry()
127
    {
128
        $this->addSql('CREATE TABLE country (
129
            id VARCHAR(2) PRIMARY KEY NOT NULL,
130
            name VARCHAR(16) NOT NULL
131
        )');
132
    }
133
134
    protected function createTableGenre()
135
    {
136
        $this->addSql('CREATE TABLE genre (
137
            id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
138
            name VARCHAR(16) NOT NULL
139
        )');
140
    }
141
142
    protected function createTableExtTranslations()
143
    {
144
        $this->addSql('CREATE TABLE ext_translations (
145
            id INTEGER NOT NULL,
146
            locale VARCHAR(8) NOT NULL,
147
            object_class VARCHAR(255) NOT NULL,
148
            field VARCHAR(32) NOT NULL,
149
            foreign_key VARCHAR(64) NOT NULL,
150
            content TEXT DEFAULT NULL,
151
            PRIMARY KEY(id)
152
        )');
153
        // add index
154
        $this->addSql('CREATE INDEX translations_lookup_idx ON ext_translations (locale, object_class, foreign_key)');
155
        $this->addSql('CREATE UNIQUE INDEX lookup_unique_idx ON ext_translations (locale, object_class, field, foreign_key)');
156
    }
157
158
    protected function createTableCountryTranslation()
159
    {
160
        $this->addSql('CREATE TABLE country_translation (
161
            id INTEGER NOT NULL,
162
            object_id VARCHAR(2) DEFAULT NULL,
163
            locale VARCHAR(8) NOT NULL,
164
            field VARCHAR(32) NOT NULL,
165
            content TEXT DEFAULT NULL,
166
            PRIMARY KEY(id)
167
        )');
168
        // add index
169
        $this->addSql('CREATE INDEX country_translation_object_id_idx ON country_translation (object_id)');
170
        $this->addSql('CREATE UNIQUE INDEX country_translation_idx ON country_translation (locale, object_id, field)');
171
    }
172
173
    protected function createTableStorage()
174
    {
175
        $this->addSql('CREATE TABLE "storage" (
176
            id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
177
            name VARCHAR(128) NOT NULL,
178
            description TEXT NOT NULL,
179
            type VARCHAR(16) NOT NULL,
180
            path TEXT DEFAULT NULL
181
        )');
182
    }
183
184
    protected function createTableItem()
185
    {
186
        $this->addSql('CREATE TABLE "item"  (
187
            id INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
188
            type VARCHAR(16) DEFAULT NULL,
189
            manufacturer VARCHAR(2) DEFAULT NULL,
190
            storage INTEGER DEFAULT NULL,
191
            name VARCHAR(256) NOT NULL,
192
            date_start DATE NOT NULL,
193
            date_end DATE DEFAULT NULL,
194
            duration INTEGER DEFAULT NULL,
195
            summary TEXT DEFAULT NULL,
196
            path VARCHAR(256) DEFAULT NULL,
197
            episodes TEXT DEFAULT NULL,
198
            episodes_number VARCHAR(5) DEFAULT NULL,
199
            translate VARCHAR(256) DEFAULT NULL,
200
            file_info TEXT DEFAULT NULL,
201
            cover VARCHAR(256) DEFAULT NULL,
202
            date_add DATETIME NOT NULL,
203
            date_update DATETIME NOT NULL
204
        )');
205
        // add index
206
        $this->addSql('CREATE INDEX item_manufacturer_idx ON item (manufacturer)');
207
        $this->addSql('CREATE INDEX item_storage_idx ON item (storage)');
208
        $this->addSql('CREATE INDEX item_type_idx ON item (type)');
209
    }
210
211
    protected function addDataTypes()
212
    {
213
        $this->addSql('INSERT INTO "type" VALUES("feature","Feature")');
214
        $this->addSql('INSERT INTO "type" VALUES("featurette","Featurette")');
215
        $this->addSql('INSERT INTO "type" VALUES("ona","ONA")');
216
        $this->addSql('INSERT INTO "type" VALUES("ova","OVA")');
217
        $this->addSql('INSERT INTO "type" VALUES("tv","TV")');
218
        $this->addSql('INSERT INTO "type" VALUES("special","TV-special")');
219
        $this->addSql('INSERT INTO "type" VALUES("music","Music video")');
220
        $this->addSql('INSERT INTO "type" VALUES("commercial","Commercial")');
221
    }
222
223
    protected function addDataCountry()
224
    {
225
        $this->addSql('INSERT INTO "country" VALUES("AF","Afghanistan")');
226
        $this->addSql('INSERT INTO "country" VALUES("AL","Albania")');
227
        $this->addSql('INSERT INTO "country" VALUES("DZ","Algeria")');
228
        $this->addSql('INSERT INTO "country" VALUES("AS","American Samoa")');
229
        $this->addSql('INSERT INTO "country" VALUES("AD","Andorra")');
230
        $this->addSql('INSERT INTO "country" VALUES("AO","Angola")');
231
        $this->addSql('INSERT INTO "country" VALUES("AI","Anguilla")');
232
        $this->addSql('INSERT INTO "country" VALUES("AQ","Antarctica")');
233
        $this->addSql('INSERT INTO "country" VALUES("AG","Antigua and Barbuda")');
234
        $this->addSql('INSERT INTO "country" VALUES("AR","Argentina")');
235
        $this->addSql('INSERT INTO "country" VALUES("AM","Armenia")');
236
        $this->addSql('INSERT INTO "country" VALUES("AW","Aruba")');
237
        $this->addSql('INSERT INTO "country" VALUES("AU","Australia")');
238
        $this->addSql('INSERT INTO "country" VALUES("AT","Austria")');
239
        $this->addSql('INSERT INTO "country" VALUES("AZ","Azerbaijan")');
240
        $this->addSql('INSERT INTO "country" VALUES("BS","Bahamas")');
241
        $this->addSql('INSERT INTO "country" VALUES("BH","Bahrain")');
242
        $this->addSql('INSERT INTO "country" VALUES("BD","Bangladesh")');
243
        $this->addSql('INSERT INTO "country" VALUES("BB","Barbados")');
244
        $this->addSql('INSERT INTO "country" VALUES("BY","Belarus")');
245
        $this->addSql('INSERT INTO "country" VALUES("BE","Belgium")');
246
        $this->addSql('INSERT INTO "country" VALUES("BZ","Belize")');
247
        $this->addSql('INSERT INTO "country" VALUES("BJ","Benin")');
248
        $this->addSql('INSERT INTO "country" VALUES("BM","Bermuda")');
249
        $this->addSql('INSERT INTO "country" VALUES("BT","Bhutan")');
250
        $this->addSql('INSERT INTO "country" VALUES("BO","Bolivia")');
251
        $this->addSql('INSERT INTO "country" VALUES("BA","Bosnia and Herzegovina")');
252
        $this->addSql('INSERT INTO "country" VALUES("BW","Botswana")');
253
        $this->addSql('INSERT INTO "country" VALUES("BV","Bouvet Island")');
254
        $this->addSql('INSERT INTO "country" VALUES("BR","Brazil")');
255
        $this->addSql('INSERT INTO "country" VALUES("BQ","British Antarctic Territory")');
256
        $this->addSql('INSERT INTO "country" VALUES("IO","British Indian Ocean Territory")');
257
        $this->addSql('INSERT INTO "country" VALUES("VG","British Virgin Islands")');
258
        $this->addSql('INSERT INTO "country" VALUES("BN","Brunei")');
259
        $this->addSql('INSERT INTO "country" VALUES("BG","Bulgaria")');
260
        $this->addSql('INSERT INTO "country" VALUES("BF","Burkina Faso")');
261
        $this->addSql('INSERT INTO "country" VALUES("BI","Burundi")');
262
        $this->addSql('INSERT INTO "country" VALUES("KH","Cambodia")');
263
        $this->addSql('INSERT INTO "country" VALUES("CM","Cameroon")');
264
        $this->addSql('INSERT INTO "country" VALUES("CA","Canada")');
265
        $this->addSql('INSERT INTO "country" VALUES("CT","Canton and Enderbury Islands")');
266
        $this->addSql('INSERT INTO "country" VALUES("CV","Cape Verde")');
267
        $this->addSql('INSERT INTO "country" VALUES("KY","Cayman Islands")');
268
        $this->addSql('INSERT INTO "country" VALUES("CF","Central African Republic")');
269
        $this->addSql('INSERT INTO "country" VALUES("TD","Chad")');
270
        $this->addSql('INSERT INTO "country" VALUES("CL","Chile")');
271
        $this->addSql('INSERT INTO "country" VALUES("CN","China")');
272
        $this->addSql('INSERT INTO "country" VALUES("CX","Christmas Island")');
273
        $this->addSql('INSERT INTO "country" VALUES("CC","Cocos (Keeling) Islands")');
274
        $this->addSql('INSERT INTO "country" VALUES("CO","Colombia")');
275
        $this->addSql('INSERT INTO "country" VALUES("KM","Comoros")');
276
        $this->addSql('INSERT INTO "country" VALUES("CG","Congo - Brazzaville")');
277
        $this->addSql('INSERT INTO "country" VALUES("CD","Congo - Kinshasa")');
278
        $this->addSql('INSERT INTO "country" VALUES("CK","Cook Islands")');
279
        $this->addSql('INSERT INTO "country" VALUES("CR","Costa Rica")');
280
        $this->addSql('INSERT INTO "country" VALUES("HR","Croatia")');
281
        $this->addSql('INSERT INTO "country" VALUES("CU","Cuba")');
282
        $this->addSql('INSERT INTO "country" VALUES("CY","Cyprus")');
283
        $this->addSql('INSERT INTO "country" VALUES("CZ","Czech Republic")');
284
        $this->addSql('INSERT INTO "country" VALUES("CI","Côte d’Ivoire")');
285
        $this->addSql('INSERT INTO "country" VALUES("DK","Denmark")');
286
        $this->addSql('INSERT INTO "country" VALUES("DJ","Djibouti")');
287
        $this->addSql('INSERT INTO "country" VALUES("DM","Dominica")');
288
        $this->addSql('INSERT INTO "country" VALUES("DO","Dominican Republic")');
289
        $this->addSql('INSERT INTO "country" VALUES("NQ","Dronning Maud Land")');
290
        $this->addSql('INSERT INTO "country" VALUES("DD","East Germany")');
291
        $this->addSql('INSERT INTO "country" VALUES("EC","Ecuador")');
292
        $this->addSql('INSERT INTO "country" VALUES("EG","Egypt")');
293
        $this->addSql('INSERT INTO "country" VALUES("SV","El Salvador")');
294
        $this->addSql('INSERT INTO "country" VALUES("GQ","Equatorial Guinea")');
295
        $this->addSql('INSERT INTO "country" VALUES("ER","Eritrea")');
296
        $this->addSql('INSERT INTO "country" VALUES("EE","Estonia")');
297
        $this->addSql('INSERT INTO "country" VALUES("ET","Ethiopia")');
298
        $this->addSql('INSERT INTO "country" VALUES("FK","Falkland Islands")');
299
        $this->addSql('INSERT INTO "country" VALUES("FO","Faroe Islands")');
300
        $this->addSql('INSERT INTO "country" VALUES("FJ","Fiji")');
301
        $this->addSql('INSERT INTO "country" VALUES("FI","Finland")');
302
        $this->addSql('INSERT INTO "country" VALUES("FR","France")');
303
        $this->addSql('INSERT INTO "country" VALUES("GF","French Guiana")');
304
        $this->addSql('INSERT INTO "country" VALUES("PF","French Polynesia")');
305
        $this->addSql('INSERT INTO "country" VALUES("TF","French Southern Territories")');
306
        $this->addSql('INSERT INTO "country" VALUES("FQ","French Southern and Antarctic Territories")');
307
        $this->addSql('INSERT INTO "country" VALUES("GA","Gabon")');
308
        $this->addSql('INSERT INTO "country" VALUES("GM","Gambia")');
309
        $this->addSql('INSERT INTO "country" VALUES("GE","Georgia")');
310
        $this->addSql('INSERT INTO "country" VALUES("DE","Germany")');
311
        $this->addSql('INSERT INTO "country" VALUES("GH","Ghana")');
312
        $this->addSql('INSERT INTO "country" VALUES("GI","Gibraltar")');
313
        $this->addSql('INSERT INTO "country" VALUES("GR","Greece")');
314
        $this->addSql('INSERT INTO "country" VALUES("GL","Greenland")');
315
        $this->addSql('INSERT INTO "country" VALUES("GD","Grenada")');
316
        $this->addSql('INSERT INTO "country" VALUES("GP","Guadeloupe")');
317
        $this->addSql('INSERT INTO "country" VALUES("GU","Guam")');
318
        $this->addSql('INSERT INTO "country" VALUES("GT","Guatemala")');
319
        $this->addSql('INSERT INTO "country" VALUES("GG","Guernsey")');
320
        $this->addSql('INSERT INTO "country" VALUES("GN","Guinea")');
321
        $this->addSql('INSERT INTO "country" VALUES("GW","Guinea-Bissau")');
322
        $this->addSql('INSERT INTO "country" VALUES("GY","Guyana")');
323
        $this->addSql('INSERT INTO "country" VALUES("HT","Haiti")');
324
        $this->addSql('INSERT INTO "country" VALUES("HM","Heard Island and McDonald Islands")');
325
        $this->addSql('INSERT INTO "country" VALUES("HN","Honduras")');
326
        $this->addSql('INSERT INTO "country" VALUES("HK","Hong Kong SAR China")');
327
        $this->addSql('INSERT INTO "country" VALUES("HU","Hungary")');
328
        $this->addSql('INSERT INTO "country" VALUES("IS","Iceland")');
329
        $this->addSql('INSERT INTO "country" VALUES("IN","India")');
330
        $this->addSql('INSERT INTO "country" VALUES("ID","Indonesia")');
331
        $this->addSql('INSERT INTO "country" VALUES("IR","Iran")');
332
        $this->addSql('INSERT INTO "country" VALUES("IQ","Iraq")');
333
        $this->addSql('INSERT INTO "country" VALUES("IE","Ireland")');
334
        $this->addSql('INSERT INTO "country" VALUES("IM","Isle of Man")');
335
        $this->addSql('INSERT INTO "country" VALUES("IL","Israel")');
336
        $this->addSql('INSERT INTO "country" VALUES("IT","Italy")');
337
        $this->addSql('INSERT INTO "country" VALUES("JM","Jamaica")');
338
        $this->addSql('INSERT INTO "country" VALUES("JP","Japan")');
339
        $this->addSql('INSERT INTO "country" VALUES("JE","Jersey")');
340
        $this->addSql('INSERT INTO "country" VALUES("JT","Johnston Island")');
341
        $this->addSql('INSERT INTO "country" VALUES("JO","Jordan")');
342
        $this->addSql('INSERT INTO "country" VALUES("KZ","Kazakhstan")');
343
        $this->addSql('INSERT INTO "country" VALUES("KE","Kenya")');
344
        $this->addSql('INSERT INTO "country" VALUES("KI","Kiribati")');
345
        $this->addSql('INSERT INTO "country" VALUES("KW","Kuwait")');
346
        $this->addSql('INSERT INTO "country" VALUES("KG","Kyrgyzstan")');
347
        $this->addSql('INSERT INTO "country" VALUES("LA","Laos")');
348
        $this->addSql('INSERT INTO "country" VALUES("LV","Latvia")');
349
        $this->addSql('INSERT INTO "country" VALUES("LB","Lebanon")');
350
        $this->addSql('INSERT INTO "country" VALUES("LS","Lesotho")');
351
        $this->addSql('INSERT INTO "country" VALUES("LR","Liberia")');
352
        $this->addSql('INSERT INTO "country" VALUES("LY","Libya")');
353
        $this->addSql('INSERT INTO "country" VALUES("LI","Liechtenstein")');
354
        $this->addSql('INSERT INTO "country" VALUES("LT","Lithuania")');
355
        $this->addSql('INSERT INTO "country" VALUES("LU","Luxembourg")');
356
        $this->addSql('INSERT INTO "country" VALUES("MO","Macau SAR China")');
357
        $this->addSql('INSERT INTO "country" VALUES("MK","Macedonia")');
358
        $this->addSql('INSERT INTO "country" VALUES("MG","Madagascar")');
359
        $this->addSql('INSERT INTO "country" VALUES("MW","Malawi")');
360
        $this->addSql('INSERT INTO "country" VALUES("MY","Malaysia")');
361
        $this->addSql('INSERT INTO "country" VALUES("MV","Maldives")');
362
        $this->addSql('INSERT INTO "country" VALUES("ML","Mali")');
363
        $this->addSql('INSERT INTO "country" VALUES("MT","Malta")');
364
        $this->addSql('INSERT INTO "country" VALUES("MH","Marshall Islands")');
365
        $this->addSql('INSERT INTO "country" VALUES("MQ","Martinique")');
366
        $this->addSql('INSERT INTO "country" VALUES("MR","Mauritania")');
367
        $this->addSql('INSERT INTO "country" VALUES("MU","Mauritius")');
368
        $this->addSql('INSERT INTO "country" VALUES("YT","Mayotte")');
369
        $this->addSql('INSERT INTO "country" VALUES("FX","Metropolitan France")');
370
        $this->addSql('INSERT INTO "country" VALUES("MX","Mexico")');
371
        $this->addSql('INSERT INTO "country" VALUES("FM","Micronesia")');
372
        $this->addSql('INSERT INTO "country" VALUES("MI","Midway Islands")');
373
        $this->addSql('INSERT INTO "country" VALUES("MD","Moldova")');
374
        $this->addSql('INSERT INTO "country" VALUES("MC","Monaco")');
375
        $this->addSql('INSERT INTO "country" VALUES("MN","Mongolia")');
376
        $this->addSql('INSERT INTO "country" VALUES("ME","Montenegro")');
377
        $this->addSql('INSERT INTO "country" VALUES("MS","Montserrat")');
378
        $this->addSql('INSERT INTO "country" VALUES("MA","Morocco")');
379
        $this->addSql('INSERT INTO "country" VALUES("MZ","Mozambique")');
380
        $this->addSql('INSERT INTO "country" VALUES("MM","Myanmar (Burma)")');
381
        $this->addSql('INSERT INTO "country" VALUES("NA","Namibia")');
382
        $this->addSql('INSERT INTO "country" VALUES("NR","Nauru")');
383
        $this->addSql('INSERT INTO "country" VALUES("NP","Nepal")');
384
        $this->addSql('INSERT INTO "country" VALUES("NL","Netherlands")');
385
        $this->addSql('INSERT INTO "country" VALUES("AN","Netherlands Antilles")');
386
        $this->addSql('INSERT INTO "country" VALUES("NT","Neutral Zone")');
387
        $this->addSql('INSERT INTO "country" VALUES("NC","New Caledonia")');
388
        $this->addSql('INSERT INTO "country" VALUES("NZ","New Zealand")');
389
        $this->addSql('INSERT INTO "country" VALUES("NI","Nicaragua")');
390
        $this->addSql('INSERT INTO "country" VALUES("NE","Niger")');
391
        $this->addSql('INSERT INTO "country" VALUES("NG","Nigeria")');
392
        $this->addSql('INSERT INTO "country" VALUES("NU","Niue")');
393
        $this->addSql('INSERT INTO "country" VALUES("NF","Norfolk Island")');
394
        $this->addSql('INSERT INTO "country" VALUES("KP","North Korea")');
395
        $this->addSql('INSERT INTO "country" VALUES("VD","North Vietnam")');
396
        $this->addSql('INSERT INTO "country" VALUES("MP","Northern Mariana Islands")');
397
        $this->addSql('INSERT INTO "country" VALUES("NO","Norway")');
398
        $this->addSql('INSERT INTO "country" VALUES("OM","Oman")');
399
        $this->addSql('INSERT INTO "country" VALUES("PC","Pacific Islands Trust Territory")');
400
        $this->addSql('INSERT INTO "country" VALUES("PK","Pakistan")');
401
        $this->addSql('INSERT INTO "country" VALUES("PW","Palau")');
402
        $this->addSql('INSERT INTO "country" VALUES("PS","Palestinian Territories")');
403
        $this->addSql('INSERT INTO "country" VALUES("PA","Panama")');
404
        $this->addSql('INSERT INTO "country" VALUES("PZ","Panama Canal Zone")');
405
        $this->addSql('INSERT INTO "country" VALUES("PG","Papua New Guinea")');
406
        $this->addSql('INSERT INTO "country" VALUES("PY","Paraguay")');
407
        $this->addSql('INSERT INTO "country" VALUES("YD","People`s Democratic Republic of Yemen")');
408
        $this->addSql('INSERT INTO "country" VALUES("PE","Peru")');
409
        $this->addSql('INSERT INTO "country" VALUES("PH","Philippines")');
410
        $this->addSql('INSERT INTO "country" VALUES("PN","Pitcairn Islands")');
411
        $this->addSql('INSERT INTO "country" VALUES("PL","Poland")');
412
        $this->addSql('INSERT INTO "country" VALUES("PT","Portugal")');
413
        $this->addSql('INSERT INTO "country" VALUES("PR","Puerto Rico")');
414
        $this->addSql('INSERT INTO "country" VALUES("QA","Qatar")');
415
        $this->addSql('INSERT INTO "country" VALUES("RO","Romania")');
416
        $this->addSql('INSERT INTO "country" VALUES("RU","Russia")');
417
        $this->addSql('INSERT INTO "country" VALUES("RW","Rwanda")');
418
        $this->addSql('INSERT INTO "country" VALUES("RE","Réunion")');
419
        $this->addSql('INSERT INTO "country" VALUES("BL","Saint Barthélemy")');
420
        $this->addSql('INSERT INTO "country" VALUES("SH","Saint Helena")');
421
        $this->addSql('INSERT INTO "country" VALUES("KN","Saint Kitts and Nevis")');
422
        $this->addSql('INSERT INTO "country" VALUES("LC","Saint Lucia")');
423
        $this->addSql('INSERT INTO "country" VALUES("MF","Saint Martin")');
424
        $this->addSql('INSERT INTO "country" VALUES("PM","Saint Pierre and Miquelon")');
425
        $this->addSql('INSERT INTO "country" VALUES("VC","Saint Vincent and the Grenadines")');
426
        $this->addSql('INSERT INTO "country" VALUES("WS","Samoa")');
427
        $this->addSql('INSERT INTO "country" VALUES("SM","San Marino")');
428
        $this->addSql('INSERT INTO "country" VALUES("SA","Saudi Arabia")');
429
        $this->addSql('INSERT INTO "country" VALUES("SN","Senegal")');
430
        $this->addSql('INSERT INTO "country" VALUES("RS","Serbia")');
431
        $this->addSql('INSERT INTO "country" VALUES("CS","Serbia and Montenegro")');
432
        $this->addSql('INSERT INTO "country" VALUES("SC","Seychelles")');
433
        $this->addSql('INSERT INTO "country" VALUES("SL","Sierra Leone")');
434
        $this->addSql('INSERT INTO "country" VALUES("SG","Singapore")');
435
        $this->addSql('INSERT INTO "country" VALUES("SK","Slovakia")');
436
        $this->addSql('INSERT INTO "country" VALUES("SI","Slovenia")');
437
        $this->addSql('INSERT INTO "country" VALUES("SB","Solomon Islands")');
438
        $this->addSql('INSERT INTO "country" VALUES("SO","Somalia")');
439
        $this->addSql('INSERT INTO "country" VALUES("ZA","South Africa")');
440
        $this->addSql('INSERT INTO "country" VALUES("GS","South Georgia and the South Sandwich Islands")');
441
        $this->addSql('INSERT INTO "country" VALUES("KR","South Korea")');
442
        $this->addSql('INSERT INTO "country" VALUES("ES","Spain")');
443
        $this->addSql('INSERT INTO "country" VALUES("LK","Sri Lanka")');
444
        $this->addSql('INSERT INTO "country" VALUES("SD","Sudan")');
445
        $this->addSql('INSERT INTO "country" VALUES("SR","Suriname")');
446
        $this->addSql('INSERT INTO "country" VALUES("SJ","Svalbard and Jan Mayen")');
447
        $this->addSql('INSERT INTO "country" VALUES("SZ","Swaziland")');
448
        $this->addSql('INSERT INTO "country" VALUES("SE","Sweden")');
449
        $this->addSql('INSERT INTO "country" VALUES("CH","Switzerland")');
450
        $this->addSql('INSERT INTO "country" VALUES("SY","Syria")');
451
        $this->addSql('INSERT INTO "country" VALUES("ST","São Tomé and Príncipe")');
452
        $this->addSql('INSERT INTO "country" VALUES("TW","Taiwan")');
453
        $this->addSql('INSERT INTO "country" VALUES("TJ","Tajikistan")');
454
        $this->addSql('INSERT INTO "country" VALUES("TZ","Tanzania")');
455
        $this->addSql('INSERT INTO "country" VALUES("TH","Thailand")');
456
        $this->addSql('INSERT INTO "country" VALUES("TL","Timor-Leste")');
457
        $this->addSql('INSERT INTO "country" VALUES("TG","Togo")');
458
        $this->addSql('INSERT INTO "country" VALUES("TK","Tokelau")');
459
        $this->addSql('INSERT INTO "country" VALUES("TO","Tonga")');
460
        $this->addSql('INSERT INTO "country" VALUES("TT","Trinidad and Tobago")');
461
        $this->addSql('INSERT INTO "country" VALUES("TN","Tunisia")');
462
        $this->addSql('INSERT INTO "country" VALUES("TR","Turkey")');
463
        $this->addSql('INSERT INTO "country" VALUES("TM","Turkmenistan")');
464
        $this->addSql('INSERT INTO "country" VALUES("TC","Turks and Caicos Islands")');
465
        $this->addSql('INSERT INTO "country" VALUES("TV","Tuvalu")');
466
        $this->addSql('INSERT INTO "country" VALUES("UM","U.S. Minor Outlying Islands")');
467
        $this->addSql('INSERT INTO "country" VALUES("PU","U.S. Miscellaneous Pacific Islands")');
468
        $this->addSql('INSERT INTO "country" VALUES("VI","U.S. Virgin Islands")');
469
        $this->addSql('INSERT INTO "country" VALUES("UG","Uganda")');
470
        $this->addSql('INSERT INTO "country" VALUES("UA","Ukraine")');
471
        $this->addSql('INSERT INTO "country" VALUES("SU","Union of Soviet Socialist Republics")');
472
        $this->addSql('INSERT INTO "country" VALUES("AE","United Arab Emirates")');
473
        $this->addSql('INSERT INTO "country" VALUES("GB","United Kingdom")');
474
        $this->addSql('INSERT INTO "country" VALUES("US","United States")');
475
        $this->addSql('INSERT INTO "country" VALUES("ZZ","Unknown or Invalid Region")');
476
        $this->addSql('INSERT INTO "country" VALUES("UY","Uruguay")');
477
        $this->addSql('INSERT INTO "country" VALUES("UZ","Uzbekistan")');
478
        $this->addSql('INSERT INTO "country" VALUES("VU","Vanuatu")');
479
        $this->addSql('INSERT INTO "country" VALUES("VA","Vatican City")');
480
        $this->addSql('INSERT INTO "country" VALUES("VE","Venezuela")');
481
        $this->addSql('INSERT INTO "country" VALUES("VN","Vietnam")');
482
        $this->addSql('INSERT INTO "country" VALUES("WK","Wake Island")');
483
        $this->addSql('INSERT INTO "country" VALUES("WF","Wallis and Futuna")');
484
        $this->addSql('INSERT INTO "country" VALUES("EH","Western Sahara")');
485
        $this->addSql('INSERT INTO "country" VALUES("YE","Yemen")');
486
        $this->addSql('INSERT INTO "country" VALUES("ZM","Zambia")');
487
        $this->addSql('INSERT INTO "country" VALUES("ZW","Zimbabwe")');
488
        $this->addSql('INSERT INTO "country" VALUES("AX","Åland Islands")');
489
    }
490
491
    protected function addDataGenre()
492
    {
493
        $this->addSql('INSERT INTO "genre" VALUES(1,"Adventure")');
494
        $this->addSql('INSERT INTO "genre" VALUES(2,"Comedy")');
495
        $this->addSql('INSERT INTO "genre" VALUES(3,"Fantastic")');
496
        $this->addSql('INSERT INTO "genre" VALUES(4,"Drama")');
497
        $this->addSql('INSERT INTO "genre" VALUES(5,"Action")');
498
        $this->addSql('INSERT INTO "genre" VALUES(6,"Martial arts")');
499
        $this->addSql('INSERT INTO "genre" VALUES(7,"War")');
500
        $this->addSql('INSERT INTO "genre" VALUES(8,"Detective")');
501
        $this->addSql('INSERT INTO "genre" VALUES(9,"For children")');
502
        $this->addSql('INSERT INTO "genre" VALUES(10,"History")');
503
        $this->addSql('INSERT INTO "genre" VALUES(11,"Mahoe shoujo")');
504
        $this->addSql('INSERT INTO "genre" VALUES(12,"Meho")');
505
        $this->addSql('INSERT INTO "genre" VALUES(13,"Mysticism")');
506
        $this->addSql('INSERT INTO "genre" VALUES(14,"Musical")');
507
        $this->addSql('INSERT INTO "genre" VALUES(15,"Educational")');
508
        $this->addSql('INSERT INTO "genre" VALUES(16,"Parody")');
509
        $this->addSql('INSERT INTO "genre" VALUES(17,"Everyday")');
510
        $this->addSql('INSERT INTO "genre" VALUES(18,"Police")');
511
        $this->addSql('INSERT INTO "genre" VALUES(19,"Romance")');
512
        $this->addSql('INSERT INTO "genre" VALUES(20,"Samurai action")');
513
        $this->addSql('INSERT INTO "genre" VALUES(21,"Shoujo")');
514
        $this->addSql('INSERT INTO "genre" VALUES(22,"Shoujo-ai")');
515
        $this->addSql('INSERT INTO "genre" VALUES(23,"Senen")');
516
        $this->addSql('INSERT INTO "genre" VALUES(24,"Senen-ai")');
517
        $this->addSql('INSERT INTO "genre" VALUES(47,"Fable")');
518
        $this->addSql('INSERT INTO "genre" VALUES(48,"Sport")');
519
        $this->addSql('INSERT INTO "genre" VALUES(49,"Thriller")');
520
        $this->addSql('INSERT INTO "genre" VALUES(50,"School")');
521
        $this->addSql('INSERT INTO "genre" VALUES(51,"Fantasy")');
522
        $this->addSql('INSERT INTO "genre" VALUES(52,"Erotica")');
523
        $this->addSql('INSERT INTO "genre" VALUES(53,"Ettie")');
524
        $this->addSql('INSERT INTO "genre" VALUES(54,"Horror")');
525
        $this->addSql('INSERT INTO "genre" VALUES(55,"Hentai")');
526
        $this->addSql('INSERT INTO "genre" VALUES(56,"Urey")');
527
        $this->addSql('INSERT INTO "genre" VALUES(57,"Yaoi")');
528
        $this->addSql('INSERT INTO "genre" VALUES(58,"Psychology")');
529
        $this->addSql('INSERT INTO "genre" VALUES(59,"Apocalyptic fiction")');
530
        $this->addSql('INSERT INTO "genre" VALUES(60,"Steampunk")');
531
        $this->addSql('INSERT INTO "genre" VALUES(61,"Mystery play")');
532
        $this->addSql('INSERT INTO "genre" VALUES(62,"Josei")');
533
        $this->addSql('INSERT INTO "genre" VALUES(63,"Vampires")');
534
        $this->addSql('INSERT INTO "genre" VALUES(64,"Cyberpunk")');
535
        // add sequence
536
        $this->addSql('INSERT INTO "sqlite_sequence" VALUES("genre",64)');
537
    }
538
539
    protected function addDataExtTranslations()
540
    {
541
        $this->addSql('INSERT INTO "ext_translations" VALUES(1,"ru","AnimeDb\Bundle\CatalogBundle\Entity\Type","name","feature","Полнометражный фильм")');
542
        $this->addSql('INSERT INTO "ext_translations" VALUES(2,"ru","AnimeDb\Bundle\CatalogBundle\Entity\Type","name","featurette","Короткометражный фильм")');
543
        $this->addSql('INSERT INTO "ext_translations" VALUES(3,"ru","AnimeDb\Bundle\CatalogBundle\Entity\Type","name","ona","ONA")');
544
        $this->addSql('INSERT INTO "ext_translations" VALUES(4,"ru","AnimeDb\Bundle\CatalogBundle\Entity\Type","name","ova","OVA")');
545
        $this->addSql('INSERT INTO "ext_translations" VALUES(5,"ru","AnimeDb\Bundle\CatalogBundle\Entity\Type","name","tv","ТВ")');
546
        $this->addSql('INSERT INTO "ext_translations" VALUES(6,"ru","AnimeDb\Bundle\CatalogBundle\Entity\Type","name","special","ТВ спецвыпуск")');
547
        $this->addSql('INSERT INTO "ext_translations" VALUES(7,"ru","AnimeDb\Bundle\CatalogBundle\Entity\Type","name","music","Музыкальное видео")');
548
        $this->addSql('INSERT INTO "ext_translations" VALUES(8,"ru","AnimeDb\Bundle\CatalogBundle\Entity\Type","name","commercial","Рекламный ролик")');
549
        $this->addSql('INSERT INTO "ext_translations" VALUES(9,"ru","AnimeDb\Bundle\CatalogBundle\Entity\Genre","name","1","Приключения")');
550
        $this->addSql('INSERT INTO "ext_translations" VALUES(10,"ru","AnimeDb\Bundle\CatalogBundle\Entity\Genre","name","2","Комедия")');
551
        $this->addSql('INSERT INTO "ext_translations" VALUES(11,"ru","AnimeDb\Bundle\CatalogBundle\Entity\Genre","name","3","Фантастика")');
552
        $this->addSql('INSERT INTO "ext_translations" VALUES(12,"ru","AnimeDb\Bundle\CatalogBundle\Entity\Genre","name","4","Драма")');
553
        $this->addSql('INSERT INTO "ext_translations" VALUES(13,"ru","AnimeDb\Bundle\CatalogBundle\Entity\Genre","name","5","Боевик")');
554
        $this->addSql('INSERT INTO "ext_translations" VALUES(14,"ru","AnimeDb\Bundle\CatalogBundle\Entity\Genre","name","6","Боевые искусства")');
555
        $this->addSql('INSERT INTO "ext_translations" VALUES(15,"ru","AnimeDb\Bundle\CatalogBundle\Entity\Genre","name","7","Война")');
556
        $this->addSql('INSERT INTO "ext_translations" VALUES(16,"ru","AnimeDb\Bundle\CatalogBundle\Entity\Genre","name","8","Детектив")');
557
        $this->addSql('INSERT INTO "ext_translations" VALUES(17,"ru","AnimeDb\Bundle\CatalogBundle\Entity\Genre","name","9","Для детей")');
558
        $this->addSql('INSERT INTO "ext_translations" VALUES(18,"ru","AnimeDb\Bundle\CatalogBundle\Entity\Genre","name","10","История")');
559
        $this->addSql('INSERT INTO "ext_translations" VALUES(19,"ru","AnimeDb\Bundle\CatalogBundle\Entity\Genre","name","11","Махо-сёдзё")');
560
        $this->addSql('INSERT INTO "ext_translations" VALUES(20,"ru","AnimeDb\Bundle\CatalogBundle\Entity\Genre","name","12","Меха")');
561
        $this->addSql('INSERT INTO "ext_translations" VALUES(21,"ru","AnimeDb\Bundle\CatalogBundle\Entity\Genre","name","13","Мистика")');
562
        $this->addSql('INSERT INTO "ext_translations" VALUES(22,"ru","AnimeDb\Bundle\CatalogBundle\Entity\Genre","name","14","Музыкальный")');
563
        $this->addSql('INSERT INTO "ext_translations" VALUES(23,"ru","AnimeDb\Bundle\CatalogBundle\Entity\Genre","name","15","Образовательный")');
564
        $this->addSql('INSERT INTO "ext_translations" VALUES(24,"ru","AnimeDb\Bundle\CatalogBundle\Entity\Genre","name","16","Пародия")');
565
        $this->addSql('INSERT INTO "ext_translations" VALUES(25,"ru","AnimeDb\Bundle\CatalogBundle\Entity\Genre","name","17","Повседневность")');
566
        $this->addSql('INSERT INTO "ext_translations" VALUES(26,"ru","AnimeDb\Bundle\CatalogBundle\Entity\Genre","name","18","Полиция")');
567
        $this->addSql('INSERT INTO "ext_translations" VALUES(27,"ru","AnimeDb\Bundle\CatalogBundle\Entity\Genre","name","19","Романтика")');
568
        $this->addSql('INSERT INTO "ext_translations" VALUES(28,"ru","AnimeDb\Bundle\CatalogBundle\Entity\Genre","name","20","Самурайский боевик")');
569
        $this->addSql('INSERT INTO "ext_translations" VALUES(29,"ru","AnimeDb\Bundle\CatalogBundle\Entity\Genre","name","21","Сёдзё")');
570
        $this->addSql('INSERT INTO "ext_translations" VALUES(30,"ru","AnimeDb\Bundle\CatalogBundle\Entity\Genre","name","22","Сёдзё-ай")');
571
        $this->addSql('INSERT INTO "ext_translations" VALUES(31,"ru","AnimeDb\Bundle\CatalogBundle\Entity\Genre","name","23","Сёнэн")');
572
        $this->addSql('INSERT INTO "ext_translations" VALUES(32,"ru","AnimeDb\Bundle\CatalogBundle\Entity\Genre","name","24","Сёнэн-ай")');
573
        $this->addSql('INSERT INTO "ext_translations" VALUES(33,"ru","AnimeDb\Bundle\CatalogBundle\Entity\Genre","name","47","Сказка")');
574
        $this->addSql('INSERT INTO "ext_translations" VALUES(34,"ru","AnimeDb\Bundle\CatalogBundle\Entity\Genre","name","48","Спорт")');
575
        $this->addSql('INSERT INTO "ext_translations" VALUES(35,"ru","AnimeDb\Bundle\CatalogBundle\Entity\Genre","name","49","Триллер")');
576
        $this->addSql('INSERT INTO "ext_translations" VALUES(36,"ru","AnimeDb\Bundle\CatalogBundle\Entity\Genre","name","50","Школа")');
577
        $this->addSql('INSERT INTO "ext_translations" VALUES(37,"ru","AnimeDb\Bundle\CatalogBundle\Entity\Genre","name","51","Фэнтези")');
578
        $this->addSql('INSERT INTO "ext_translations" VALUES(38,"ru","AnimeDb\Bundle\CatalogBundle\Entity\Genre","name","52","Эротика")');
579
        $this->addSql('INSERT INTO "ext_translations" VALUES(39,"ru","AnimeDb\Bundle\CatalogBundle\Entity\Genre","name","53","Этти")');
580
        $this->addSql('INSERT INTO "ext_translations" VALUES(40,"ru","AnimeDb\Bundle\CatalogBundle\Entity\Genre","name","54","Ужасы")');
581
        $this->addSql('INSERT INTO "ext_translations" VALUES(41,"ru","AnimeDb\Bundle\CatalogBundle\Entity\Genre","name","55","Хентай")');
582
        $this->addSql('INSERT INTO "ext_translations" VALUES(42,"ru","AnimeDb\Bundle\CatalogBundle\Entity\Genre","name","56","Юри")');
583
        $this->addSql('INSERT INTO "ext_translations" VALUES(43,"ru","AnimeDb\Bundle\CatalogBundle\Entity\Genre","name","57","Яой")');
584
        $this->addSql('INSERT INTO "ext_translations" VALUES(44,"ru","AnimeDb\Bundle\CatalogBundle\Entity\Genre","name","58","Психология")');
585
        $this->addSql('INSERT INTO "ext_translations" VALUES(45,"ru","AnimeDb\Bundle\CatalogBundle\Entity\Genre","name","59","Постапокалиптика")');
586
        $this->addSql('INSERT INTO "ext_translations" VALUES(46,"ru","AnimeDb\Bundle\CatalogBundle\Entity\Genre","name","60","Стимпанк")');
587
        $this->addSql('INSERT INTO "ext_translations" VALUES(47,"ru","AnimeDb\Bundle\CatalogBundle\Entity\Genre","name","61","Мистерия")');
588
        $this->addSql('INSERT INTO "ext_translations" VALUES(48,"ru","AnimeDb\Bundle\CatalogBundle\Entity\Genre","name","62","Дзёсэй")');
589
        $this->addSql('INSERT INTO "ext_translations" VALUES(49,"ru","AnimeDb\Bundle\CatalogBundle\Entity\Genre","name","63","Вампиры")');
590
        $this->addSql('INSERT INTO "ext_translations" VALUES(50,"ru","AnimeDb\Bundle\CatalogBundle\Entity\Genre","name","64","Киберпанк")');
591
    }
592
593
    protected function addDataCountryTranslation()
594
    {
595
        $this->addSql('INSERT INTO "country_translation" VALUES(1,"AF","en","name","Afghanistan")');
596
        $this->addSql('INSERT INTO "country_translation" VALUES(2,"AF","ru","name","Афганистан")');
597
        $this->addSql('INSERT INTO "country_translation" VALUES(3,"AL","en","name","Albania")');
598
        $this->addSql('INSERT INTO "country_translation" VALUES(4,"AL","ru","name","Албания")');
599
        $this->addSql('INSERT INTO "country_translation" VALUES(5,"DZ","en","name","Algeria")');
600
        $this->addSql('INSERT INTO "country_translation" VALUES(6,"DZ","ru","name","Алжир")');
601
        $this->addSql('INSERT INTO "country_translation" VALUES(7,"AS","en","name","American Samoa")');
602
        $this->addSql('INSERT INTO "country_translation" VALUES(8,"AS","ru","name","Американское Самоа")');
603
        $this->addSql('INSERT INTO "country_translation" VALUES(9,"AD","en","name","Andorra")');
604
        $this->addSql('INSERT INTO "country_translation" VALUES(10,"AD","ru","name","Андорра")');
605
        $this->addSql('INSERT INTO "country_translation" VALUES(11,"AO","en","name","Angola")');
606
        $this->addSql('INSERT INTO "country_translation" VALUES(12,"AO","ru","name","Ангола")');
607
        $this->addSql('INSERT INTO "country_translation" VALUES(13,"AI","en","name","Anguilla")');
608
        $this->addSql('INSERT INTO "country_translation" VALUES(14,"AI","ru","name","Ангуилла")');
609
        $this->addSql('INSERT INTO "country_translation" VALUES(15,"AQ","en","name","Antarctica")');
610
        $this->addSql('INSERT INTO "country_translation" VALUES(16,"AQ","ru","name","Антарктика")');
611
        $this->addSql('INSERT INTO "country_translation" VALUES(17,"AG","en","name","Antigua and Barbuda")');
612
        $this->addSql('INSERT INTO "country_translation" VALUES(18,"AG","ru","name","Антигуа и Барбуда")');
613
        $this->addSql('INSERT INTO "country_translation" VALUES(19,"AR","en","name","Argentina")');
614
        $this->addSql('INSERT INTO "country_translation" VALUES(20,"AR","ru","name","Аргентина")');
615
        $this->addSql('INSERT INTO "country_translation" VALUES(21,"AM","en","name","Armenia")');
616
        $this->addSql('INSERT INTO "country_translation" VALUES(22,"AM","ru","name","Армения")');
617
        $this->addSql('INSERT INTO "country_translation" VALUES(23,"AW","en","name","Aruba")');
618
        $this->addSql('INSERT INTO "country_translation" VALUES(24,"AW","ru","name","Аруба")');
619
        $this->addSql('INSERT INTO "country_translation" VALUES(25,"AU","en","name","Australia")');
620
        $this->addSql('INSERT INTO "country_translation" VALUES(26,"AU","ru","name","Австралия")');
621
        $this->addSql('INSERT INTO "country_translation" VALUES(27,"AT","en","name","Austria")');
622
        $this->addSql('INSERT INTO "country_translation" VALUES(28,"AT","ru","name","Австрия")');
623
        $this->addSql('INSERT INTO "country_translation" VALUES(29,"AZ","en","name","Azerbaijan")');
624
        $this->addSql('INSERT INTO "country_translation" VALUES(30,"AZ","ru","name","Азербайджан")');
625
        $this->addSql('INSERT INTO "country_translation" VALUES(31,"BS","en","name","Bahamas")');
626
        $this->addSql('INSERT INTO "country_translation" VALUES(32,"BS","ru","name","Багамские острова")');
627
        $this->addSql('INSERT INTO "country_translation" VALUES(33,"BH","en","name","Bahrain")');
628
        $this->addSql('INSERT INTO "country_translation" VALUES(34,"BH","ru","name","Бахрейн")');
629
        $this->addSql('INSERT INTO "country_translation" VALUES(35,"BD","en","name","Bangladesh")');
630
        $this->addSql('INSERT INTO "country_translation" VALUES(36,"BD","ru","name","Бангладеш")');
631
        $this->addSql('INSERT INTO "country_translation" VALUES(37,"BB","en","name","Barbados")');
632
        $this->addSql('INSERT INTO "country_translation" VALUES(38,"BB","ru","name","Барбадос")');
633
        $this->addSql('INSERT INTO "country_translation" VALUES(39,"BY","en","name","Belarus")');
634
        $this->addSql('INSERT INTO "country_translation" VALUES(40,"BY","ru","name","Беларусь")');
635
        $this->addSql('INSERT INTO "country_translation" VALUES(41,"BE","en","name","Belgium")');
636
        $this->addSql('INSERT INTO "country_translation" VALUES(42,"BE","ru","name","Бельгия")');
637
        $this->addSql('INSERT INTO "country_translation" VALUES(43,"BZ","en","name","Belize")');
638
        $this->addSql('INSERT INTO "country_translation" VALUES(44,"BZ","ru","name","Белиз")');
639
        $this->addSql('INSERT INTO "country_translation" VALUES(45,"BJ","en","name","Benin")');
640
        $this->addSql('INSERT INTO "country_translation" VALUES(46,"BJ","ru","name","Бенин")');
641
        $this->addSql('INSERT INTO "country_translation" VALUES(47,"BM","en","name","Bermuda")');
642
        $this->addSql('INSERT INTO "country_translation" VALUES(48,"BM","ru","name","Бермудские Острова")');
643
        $this->addSql('INSERT INTO "country_translation" VALUES(49,"BT","en","name","Bhutan")');
644
        $this->addSql('INSERT INTO "country_translation" VALUES(50,"BT","ru","name","Бутан")');
645
        $this->addSql('INSERT INTO "country_translation" VALUES(51,"BO","en","name","Bolivia")');
646
        $this->addSql('INSERT INTO "country_translation" VALUES(52,"BO","ru","name","Боливия")');
647
        $this->addSql('INSERT INTO "country_translation" VALUES(53,"BA","en","name","Bosnia and Herzegovina")');
648
        $this->addSql('INSERT INTO "country_translation" VALUES(54,"BA","ru","name","Босния и Герцеговина")');
649
        $this->addSql('INSERT INTO "country_translation" VALUES(55,"BW","en","name","Botswana")');
650
        $this->addSql('INSERT INTO "country_translation" VALUES(56,"BW","ru","name","Ботсвана")');
651
        $this->addSql('INSERT INTO "country_translation" VALUES(57,"BV","en","name","Bouvet Island")');
652
        $this->addSql('INSERT INTO "country_translation" VALUES(58,"BV","ru","name","Остров Буве")');
653
        $this->addSql('INSERT INTO "country_translation" VALUES(59,"BR","en","name","Brazil")');
654
        $this->addSql('INSERT INTO "country_translation" VALUES(60,"BR","ru","name","Бразилия")');
655
        $this->addSql('INSERT INTO "country_translation" VALUES(61,"BQ","en","name","British Antarctic Territory")');
656
        $this->addSql('INSERT INTO "country_translation" VALUES(62,"BQ","ru","name","Британская антарктическая территория")');
657
        $this->addSql('INSERT INTO "country_translation" VALUES(63,"IO","en","name","British Indian Ocean Territory")');
658
        $this->addSql('INSERT INTO "country_translation" VALUES(64,"IO","ru","name","Британская территория в Индийском океане")');
659
        $this->addSql('INSERT INTO "country_translation" VALUES(65,"VG","en","name","British Virgin Islands")');
660
        $this->addSql('INSERT INTO "country_translation" VALUES(66,"VG","ru","name","Британские Виргинские Острова")');
661
        $this->addSql('INSERT INTO "country_translation" VALUES(67,"BN","en","name","Brunei")');
662
        $this->addSql('INSERT INTO "country_translation" VALUES(68,"BN","ru","name","Бруней Даруссалам")');
663
        $this->addSql('INSERT INTO "country_translation" VALUES(69,"BG","en","name","Bulgaria")');
664
        $this->addSql('INSERT INTO "country_translation" VALUES(70,"BG","ru","name","Болгария")');
665
        $this->addSql('INSERT INTO "country_translation" VALUES(71,"BF","en","name","Burkina Faso")');
666
        $this->addSql('INSERT INTO "country_translation" VALUES(72,"BF","ru","name","Буркина Фасо")');
667
        $this->addSql('INSERT INTO "country_translation" VALUES(73,"BI","en","name","Burundi")');
668
        $this->addSql('INSERT INTO "country_translation" VALUES(74,"BI","ru","name","Бурунди")');
669
        $this->addSql('INSERT INTO "country_translation" VALUES(75,"KH","en","name","Cambodia")');
670
        $this->addSql('INSERT INTO "country_translation" VALUES(76,"KH","ru","name","Камбоджа")');
671
        $this->addSql('INSERT INTO "country_translation" VALUES(77,"CM","en","name","Cameroon")');
672
        $this->addSql('INSERT INTO "country_translation" VALUES(78,"CM","ru","name","Камерун")');
673
        $this->addSql('INSERT INTO "country_translation" VALUES(79,"CA","en","name","Canada")');
674
        $this->addSql('INSERT INTO "country_translation" VALUES(80,"CA","ru","name","Канада")');
675
        $this->addSql('INSERT INTO "country_translation" VALUES(81,"CT","en","name","Canton and Enderbury Islands")');
676
        $this->addSql('INSERT INTO "country_translation" VALUES(82,"CT","ru","name","Кантон и Эндербери")');
677
        $this->addSql('INSERT INTO "country_translation" VALUES(83,"CV","en","name","Cape Verde")');
678
        $this->addSql('INSERT INTO "country_translation" VALUES(84,"CV","ru","name","Острова Зеленого Мыса")');
679
        $this->addSql('INSERT INTO "country_translation" VALUES(85,"KY","en","name","Cayman Islands")');
680
        $this->addSql('INSERT INTO "country_translation" VALUES(86,"KY","ru","name","Каймановы острова")');
681
        $this->addSql('INSERT INTO "country_translation" VALUES(87,"CF","en","name","Central African Republic")');
682
        $this->addSql('INSERT INTO "country_translation" VALUES(88,"CF","ru","name","Центрально-Африканская Республика")');
683
        $this->addSql('INSERT INTO "country_translation" VALUES(89,"TD","en","name","Chad")');
684
        $this->addSql('INSERT INTO "country_translation" VALUES(90,"TD","ru","name","Чад")');
685
        $this->addSql('INSERT INTO "country_translation" VALUES(91,"CL","en","name","Chile")');
686
        $this->addSql('INSERT INTO "country_translation" VALUES(92,"CL","ru","name","Чили")');
687
        $this->addSql('INSERT INTO "country_translation" VALUES(93,"CN","en","name","China")');
688
        $this->addSql('INSERT INTO "country_translation" VALUES(94,"CN","ru","name","Китай")');
689
        $this->addSql('INSERT INTO "country_translation" VALUES(95,"CX","en","name","Christmas Island")');
690
        $this->addSql('INSERT INTO "country_translation" VALUES(96,"CX","ru","name","Остров Рождества")');
691
        $this->addSql('INSERT INTO "country_translation" VALUES(97,"CC","en","name","Cocos (Keeling) Islands")');
692
        $this->addSql('INSERT INTO "country_translation" VALUES(98,"CC","ru","name","Кокосовые острова")');
693
        $this->addSql('INSERT INTO "country_translation" VALUES(99,"CO","en","name","Colombia")');
694
        $this->addSql('INSERT INTO "country_translation" VALUES(100,"CO","ru","name","Колумбия")');
695
        $this->addSql('INSERT INTO "country_translation" VALUES(101,"KM","en","name","Comoros")');
696
        $this->addSql('INSERT INTO "country_translation" VALUES(102,"KM","ru","name","Коморские Острова")');
697
        $this->addSql('INSERT INTO "country_translation" VALUES(103,"CG","en","name","Congo - Brazzaville")');
698
        $this->addSql('INSERT INTO "country_translation" VALUES(104,"CG","ru","name","Конго")');
699
        $this->addSql('INSERT INTO "country_translation" VALUES(105,"CD","en","name","Congo - Kinshasa")');
700
        $this->addSql('INSERT INTO "country_translation" VALUES(106,"CD","ru","name","Демократическая Республика Конго")');
701
        $this->addSql('INSERT INTO "country_translation" VALUES(107,"CK","en","name","Cook Islands")');
702
        $this->addSql('INSERT INTO "country_translation" VALUES(108,"CK","ru","name","Острова Кука")');
703
        $this->addSql('INSERT INTO "country_translation" VALUES(109,"CR","en","name","Costa Rica")');
704
        $this->addSql('INSERT INTO "country_translation" VALUES(110,"CR","ru","name","Коста-Рика")');
705
        $this->addSql('INSERT INTO "country_translation" VALUES(111,"HR","en","name","Croatia")');
706
        $this->addSql('INSERT INTO "country_translation" VALUES(112,"HR","ru","name","Хорватия")');
707
        $this->addSql('INSERT INTO "country_translation" VALUES(113,"CU","en","name","Cuba")');
708
        $this->addSql('INSERT INTO "country_translation" VALUES(114,"CU","ru","name","Куба")');
709
        $this->addSql('INSERT INTO "country_translation" VALUES(115,"CY","en","name","Cyprus")');
710
        $this->addSql('INSERT INTO "country_translation" VALUES(116,"CY","ru","name","Кипр")');
711
        $this->addSql('INSERT INTO "country_translation" VALUES(117,"CZ","en","name","Czech Republic")');
712
        $this->addSql('INSERT INTO "country_translation" VALUES(118,"CZ","ru","name","Чешская республика")');
713
        $this->addSql('INSERT INTO "country_translation" VALUES(119,"CI","en","name","Côte d’Ivoire")');
714
        $this->addSql('INSERT INTO "country_translation" VALUES(120,"CI","ru","name","Кот д’Ивуар")');
715
        $this->addSql('INSERT INTO "country_translation" VALUES(121,"DK","en","name","Denmark")');
716
        $this->addSql('INSERT INTO "country_translation" VALUES(122,"DK","ru","name","Дания")');
717
        $this->addSql('INSERT INTO "country_translation" VALUES(123,"DJ","en","name","Djibouti")');
718
        $this->addSql('INSERT INTO "country_translation" VALUES(124,"DJ","ru","name","Джибути")');
719
        $this->addSql('INSERT INTO "country_translation" VALUES(125,"DM","en","name","Dominica")');
720
        $this->addSql('INSERT INTO "country_translation" VALUES(126,"DM","ru","name","Остров Доминика")');
721
        $this->addSql('INSERT INTO "country_translation" VALUES(127,"DO","en","name","Dominican Republic")');
722
        $this->addSql('INSERT INTO "country_translation" VALUES(128,"DO","ru","name","Доминиканская Республика")');
723
        $this->addSql('INSERT INTO "country_translation" VALUES(129,"NQ","en","name","Dronning Maud Land")');
724
        $this->addSql('INSERT INTO "country_translation" VALUES(130,"NQ","ru","name","Земля Королевы Мод")');
725
        $this->addSql('INSERT INTO "country_translation" VALUES(131,"DD","en","name","East Germany")');
726
        $this->addSql('INSERT INTO "country_translation" VALUES(132,"DD","ru","name","Германская Демократическая Республика")');
727
        $this->addSql('INSERT INTO "country_translation" VALUES(133,"EC","en","name","Ecuador")');
728
        $this->addSql('INSERT INTO "country_translation" VALUES(134,"EC","ru","name","Эквадор")');
729
        $this->addSql('INSERT INTO "country_translation" VALUES(135,"EG","en","name","Egypt")');
730
        $this->addSql('INSERT INTO "country_translation" VALUES(136,"EG","ru","name","Египет")');
731
        $this->addSql('INSERT INTO "country_translation" VALUES(137,"SV","en","name","El Salvador")');
732
        $this->addSql('INSERT INTO "country_translation" VALUES(138,"SV","ru","name","Сальвадор")');
733
        $this->addSql('INSERT INTO "country_translation" VALUES(139,"GQ","en","name","Equatorial Guinea")');
734
        $this->addSql('INSERT INTO "country_translation" VALUES(140,"GQ","ru","name","Экваториальная Гвинея")');
735
        $this->addSql('INSERT INTO "country_translation" VALUES(141,"ER","en","name","Eritrea")');
736
        $this->addSql('INSERT INTO "country_translation" VALUES(142,"ER","ru","name","Эритрея")');
737
        $this->addSql('INSERT INTO "country_translation" VALUES(143,"EE","en","name","Estonia")');
738
        $this->addSql('INSERT INTO "country_translation" VALUES(144,"EE","ru","name","Эстония")');
739
        $this->addSql('INSERT INTO "country_translation" VALUES(145,"ET","en","name","Ethiopia")');
740
        $this->addSql('INSERT INTO "country_translation" VALUES(146,"ET","ru","name","Эфиопия")');
741
        $this->addSql('INSERT INTO "country_translation" VALUES(147,"FK","en","name","Falkland Islands")');
742
        $this->addSql('INSERT INTO "country_translation" VALUES(148,"FK","ru","name","Фолклендские острова")');
743
        $this->addSql('INSERT INTO "country_translation" VALUES(149,"FO","en","name","Faroe Islands")');
744
        $this->addSql('INSERT INTO "country_translation" VALUES(150,"FO","ru","name","Фарерские острова")');
745
        $this->addSql('INSERT INTO "country_translation" VALUES(151,"FJ","en","name","Fiji")');
746
        $this->addSql('INSERT INTO "country_translation" VALUES(152,"FJ","ru","name","Фиджи")');
747
        $this->addSql('INSERT INTO "country_translation" VALUES(153,"FI","en","name","Finland")');
748
        $this->addSql('INSERT INTO "country_translation" VALUES(154,"FI","ru","name","Финляндия")');
749
        $this->addSql('INSERT INTO "country_translation" VALUES(155,"FR","en","name","France")');
750
        $this->addSql('INSERT INTO "country_translation" VALUES(156,"FR","ru","name","Франция")');
751
        $this->addSql('INSERT INTO "country_translation" VALUES(157,"GF","en","name","French Guiana")');
752
        $this->addSql('INSERT INTO "country_translation" VALUES(158,"GF","ru","name","Французская Гвиана")');
753
        $this->addSql('INSERT INTO "country_translation" VALUES(159,"PF","en","name","French Polynesia")');
754
        $this->addSql('INSERT INTO "country_translation" VALUES(160,"PF","ru","name","Французская Полинезия")');
755
        $this->addSql('INSERT INTO "country_translation" VALUES(161,"TF","en","name","French Southern Territories")');
756
        $this->addSql('INSERT INTO "country_translation" VALUES(162,"TF","ru","name","Французские Южные Территории")');
757
        $this->addSql('INSERT INTO "country_translation" VALUES(163,"FQ","en","name","French Southern and Antarctic Territories")');
758
        $this->addSql('INSERT INTO "country_translation" VALUES(164,"FQ","ru","name","Французские Южные и Антарктические территории")');
759
        $this->addSql('INSERT INTO "country_translation" VALUES(165,"GA","en","name","Gabon")');
760
        $this->addSql('INSERT INTO "country_translation" VALUES(166,"GA","ru","name","Габон")');
761
        $this->addSql('INSERT INTO "country_translation" VALUES(167,"GM","en","name","Gambia")');
762
        $this->addSql('INSERT INTO "country_translation" VALUES(168,"GM","ru","name","Гамбия")');
763
        $this->addSql('INSERT INTO "country_translation" VALUES(169,"GE","en","name","Georgia")');
764
        $this->addSql('INSERT INTO "country_translation" VALUES(170,"GE","ru","name","Грузия")');
765
        $this->addSql('INSERT INTO "country_translation" VALUES(171,"DE","en","name","Germany")');
766
        $this->addSql('INSERT INTO "country_translation" VALUES(172,"DE","ru","name","Германия")');
767
        $this->addSql('INSERT INTO "country_translation" VALUES(173,"GH","en","name","Ghana")');
768
        $this->addSql('INSERT INTO "country_translation" VALUES(174,"GH","ru","name","Гана")');
769
        $this->addSql('INSERT INTO "country_translation" VALUES(175,"GI","en","name","Gibraltar")');
770
        $this->addSql('INSERT INTO "country_translation" VALUES(176,"GI","ru","name","Гибралтар")');
771
        $this->addSql('INSERT INTO "country_translation" VALUES(177,"GR","en","name","Greece")');
772
        $this->addSql('INSERT INTO "country_translation" VALUES(178,"GR","ru","name","Греция")');
773
        $this->addSql('INSERT INTO "country_translation" VALUES(179,"GL","en","name","Greenland")');
774
        $this->addSql('INSERT INTO "country_translation" VALUES(180,"GL","ru","name","Гренландия")');
775
        $this->addSql('INSERT INTO "country_translation" VALUES(181,"GD","en","name","Grenada")');
776
        $this->addSql('INSERT INTO "country_translation" VALUES(182,"GD","ru","name","Гренада")');
777
        $this->addSql('INSERT INTO "country_translation" VALUES(183,"GP","en","name","Guadeloupe")');
778
        $this->addSql('INSERT INTO "country_translation" VALUES(184,"GP","ru","name","Гваделупа")');
779
        $this->addSql('INSERT INTO "country_translation" VALUES(185,"GU","en","name","Guam")');
780
        $this->addSql('INSERT INTO "country_translation" VALUES(186,"GU","ru","name","Гуам")');
781
        $this->addSql('INSERT INTO "country_translation" VALUES(187,"GT","en","name","Guatemala")');
782
        $this->addSql('INSERT INTO "country_translation" VALUES(188,"GT","ru","name","Гватемала")');
783
        $this->addSql('INSERT INTO "country_translation" VALUES(189,"GG","en","name","Guernsey")');
784
        $this->addSql('INSERT INTO "country_translation" VALUES(190,"GG","ru","name","Гернси")');
785
        $this->addSql('INSERT INTO "country_translation" VALUES(191,"GN","en","name","Guinea")');
786
        $this->addSql('INSERT INTO "country_translation" VALUES(192,"GN","ru","name","Гвинея")');
787
        $this->addSql('INSERT INTO "country_translation" VALUES(193,"GW","en","name","Guinea-Bissau")');
788
        $this->addSql('INSERT INTO "country_translation" VALUES(194,"GW","ru","name","Гвинея-Биссау")');
789
        $this->addSql('INSERT INTO "country_translation" VALUES(195,"GY","en","name","Guyana")');
790
        $this->addSql('INSERT INTO "country_translation" VALUES(196,"GY","ru","name","Гайана")');
791
        $this->addSql('INSERT INTO "country_translation" VALUES(197,"HT","en","name","Haiti")');
792
        $this->addSql('INSERT INTO "country_translation" VALUES(198,"HT","ru","name","Гаити")');
793
        $this->addSql('INSERT INTO "country_translation" VALUES(199,"HM","en","name","Heard Island and McDonald Islands")');
794
        $this->addSql('INSERT INTO "country_translation" VALUES(200,"HM","ru","name","Острова Херд и Макдональд")');
795
        $this->addSql('INSERT INTO "country_translation" VALUES(201,"HN","en","name","Honduras")');
796
        $this->addSql('INSERT INTO "country_translation" VALUES(202,"HN","ru","name","Гондурас")');
797
        $this->addSql('INSERT INTO "country_translation" VALUES(203,"HK","en","name","Hong Kong SAR China")');
798
        $this->addSql('INSERT INTO "country_translation" VALUES(204,"HK","ru","name","Гонконг, Особый Административный Район Китая")');
799
        $this->addSql('INSERT INTO "country_translation" VALUES(205,"HU","en","name","Hungary")');
800
        $this->addSql('INSERT INTO "country_translation" VALUES(206,"HU","ru","name","Венгрия")');
801
        $this->addSql('INSERT INTO "country_translation" VALUES(207,"IS","en","name","Iceland")');
802
        $this->addSql('INSERT INTO "country_translation" VALUES(208,"IS","ru","name","Исландия")');
803
        $this->addSql('INSERT INTO "country_translation" VALUES(209,"IN","en","name","India")');
804
        $this->addSql('INSERT INTO "country_translation" VALUES(210,"IN","ru","name","Индия")');
805
        $this->addSql('INSERT INTO "country_translation" VALUES(211,"ID","en","name","Indonesia")');
806
        $this->addSql('INSERT INTO "country_translation" VALUES(212,"ID","ru","name","Индонезия")');
807
        $this->addSql('INSERT INTO "country_translation" VALUES(213,"IR","en","name","Iran")');
808
        $this->addSql('INSERT INTO "country_translation" VALUES(214,"IR","ru","name","Иран")');
809
        $this->addSql('INSERT INTO "country_translation" VALUES(215,"IQ","en","name","Iraq")');
810
        $this->addSql('INSERT INTO "country_translation" VALUES(216,"IQ","ru","name","Ирак")');
811
        $this->addSql('INSERT INTO "country_translation" VALUES(217,"IE","en","name","Ireland")');
812
        $this->addSql('INSERT INTO "country_translation" VALUES(218,"IE","ru","name","Ирландия")');
813
        $this->addSql('INSERT INTO "country_translation" VALUES(219,"IM","en","name","Isle of Man")');
814
        $this->addSql('INSERT INTO "country_translation" VALUES(220,"IM","ru","name","Остров Мэн")');
815
        $this->addSql('INSERT INTO "country_translation" VALUES(221,"IL","en","name","Israel")');
816
        $this->addSql('INSERT INTO "country_translation" VALUES(222,"IL","ru","name","Израиль")');
817
        $this->addSql('INSERT INTO "country_translation" VALUES(223,"IT","en","name","Italy")');
818
        $this->addSql('INSERT INTO "country_translation" VALUES(224,"IT","ru","name","Италия")');
819
        $this->addSql('INSERT INTO "country_translation" VALUES(225,"JM","en","name","Jamaica")');
820
        $this->addSql('INSERT INTO "country_translation" VALUES(226,"JM","ru","name","Ямайка")');
821
        $this->addSql('INSERT INTO "country_translation" VALUES(227,"JP","en","name","Japan")');
822
        $this->addSql('INSERT INTO "country_translation" VALUES(228,"JP","ru","name","Япония")');
823
        $this->addSql('INSERT INTO "country_translation" VALUES(229,"JE","en","name","Jersey")');
824
        $this->addSql('INSERT INTO "country_translation" VALUES(230,"JE","ru","name","Джерси")');
825
        $this->addSql('INSERT INTO "country_translation" VALUES(231,"JT","en","name","Johnston Island")');
826
        $this->addSql('INSERT INTO "country_translation" VALUES(232,"JT","ru","name","Джонстон")');
827
        $this->addSql('INSERT INTO "country_translation" VALUES(233,"JO","en","name","Jordan")');
828
        $this->addSql('INSERT INTO "country_translation" VALUES(234,"JO","ru","name","Иордания")');
829
        $this->addSql('INSERT INTO "country_translation" VALUES(235,"KZ","en","name","Kazakhstan")');
830
        $this->addSql('INSERT INTO "country_translation" VALUES(236,"KZ","ru","name","Казахстан")');
831
        $this->addSql('INSERT INTO "country_translation" VALUES(237,"KE","en","name","Kenya")');
832
        $this->addSql('INSERT INTO "country_translation" VALUES(238,"KE","ru","name","Кения")');
833
        $this->addSql('INSERT INTO "country_translation" VALUES(239,"KI","en","name","Kiribati")');
834
        $this->addSql('INSERT INTO "country_translation" VALUES(240,"KI","ru","name","Кирибати")');
835
        $this->addSql('INSERT INTO "country_translation" VALUES(241,"KW","en","name","Kuwait")');
836
        $this->addSql('INSERT INTO "country_translation" VALUES(242,"KW","ru","name","Кувейт")');
837
        $this->addSql('INSERT INTO "country_translation" VALUES(243,"KG","en","name","Kyrgyzstan")');
838
        $this->addSql('INSERT INTO "country_translation" VALUES(244,"KG","ru","name","Кыргызстан")');
839
        $this->addSql('INSERT INTO "country_translation" VALUES(245,"LA","en","name","Laos")');
840
        $this->addSql('INSERT INTO "country_translation" VALUES(246,"LA","ru","name","Лаос")');
841
        $this->addSql('INSERT INTO "country_translation" VALUES(247,"LV","en","name","Latvia")');
842
        $this->addSql('INSERT INTO "country_translation" VALUES(248,"LV","ru","name","Латвия")');
843
        $this->addSql('INSERT INTO "country_translation" VALUES(249,"LB","en","name","Lebanon")');
844
        $this->addSql('INSERT INTO "country_translation" VALUES(250,"LB","ru","name","Ливан")');
845
        $this->addSql('INSERT INTO "country_translation" VALUES(251,"LS","en","name","Lesotho")');
846
        $this->addSql('INSERT INTO "country_translation" VALUES(252,"LS","ru","name","Лесото")');
847
        $this->addSql('INSERT INTO "country_translation" VALUES(253,"LR","en","name","Liberia")');
848
        $this->addSql('INSERT INTO "country_translation" VALUES(254,"LR","ru","name","Либерия")');
849
        $this->addSql('INSERT INTO "country_translation" VALUES(255,"LY","en","name","Libya")');
850
        $this->addSql('INSERT INTO "country_translation" VALUES(256,"LY","ru","name","Ливия")');
851
        $this->addSql('INSERT INTO "country_translation" VALUES(257,"LI","en","name","Liechtenstein")');
852
        $this->addSql('INSERT INTO "country_translation" VALUES(258,"LI","ru","name","Лихтенштейн")');
853
        $this->addSql('INSERT INTO "country_translation" VALUES(259,"LT","en","name","Lithuania")');
854
        $this->addSql('INSERT INTO "country_translation" VALUES(260,"LT","ru","name","Литва")');
855
        $this->addSql('INSERT INTO "country_translation" VALUES(261,"LU","en","name","Luxembourg")');
856
        $this->addSql('INSERT INTO "country_translation" VALUES(262,"LU","ru","name","Люксембург")');
857
        $this->addSql('INSERT INTO "country_translation" VALUES(263,"MO","en","name","Macau SAR China")');
858
        $this->addSql('INSERT INTO "country_translation" VALUES(264,"MO","ru","name","Макао (особый административный район КНР)")');
859
        $this->addSql('INSERT INTO "country_translation" VALUES(265,"MK","en","name","Macedonia")');
860
        $this->addSql('INSERT INTO "country_translation" VALUES(266,"MK","ru","name","Македония")');
861
        $this->addSql('INSERT INTO "country_translation" VALUES(267,"MG","en","name","Madagascar")');
862
        $this->addSql('INSERT INTO "country_translation" VALUES(268,"MG","ru","name","Мадагаскар")');
863
        $this->addSql('INSERT INTO "country_translation" VALUES(269,"MW","en","name","Malawi")');
864
        $this->addSql('INSERT INTO "country_translation" VALUES(270,"MW","ru","name","Малави")');
865
        $this->addSql('INSERT INTO "country_translation" VALUES(271,"MY","en","name","Malaysia")');
866
        $this->addSql('INSERT INTO "country_translation" VALUES(272,"MY","ru","name","Малайзия")');
867
        $this->addSql('INSERT INTO "country_translation" VALUES(273,"MV","en","name","Maldives")');
868
        $this->addSql('INSERT INTO "country_translation" VALUES(274,"MV","ru","name","Мальдивы")');
869
        $this->addSql('INSERT INTO "country_translation" VALUES(275,"ML","en","name","Mali")');
870
        $this->addSql('INSERT INTO "country_translation" VALUES(276,"ML","ru","name","Мали")');
871
        $this->addSql('INSERT INTO "country_translation" VALUES(277,"MT","en","name","Malta")');
872
        $this->addSql('INSERT INTO "country_translation" VALUES(278,"MT","ru","name","Мальта")');
873
        $this->addSql('INSERT INTO "country_translation" VALUES(279,"MH","en","name","Marshall Islands")');
874
        $this->addSql('INSERT INTO "country_translation" VALUES(280,"MH","ru","name","Маршалловы Острова")');
875
        $this->addSql('INSERT INTO "country_translation" VALUES(281,"MQ","en","name","Martinique")');
876
        $this->addSql('INSERT INTO "country_translation" VALUES(282,"MQ","ru","name","Мартиник")');
877
        $this->addSql('INSERT INTO "country_translation" VALUES(283,"MR","en","name","Mauritania")');
878
        $this->addSql('INSERT INTO "country_translation" VALUES(284,"MR","ru","name","Мавритания")');
879
        $this->addSql('INSERT INTO "country_translation" VALUES(285,"MU","en","name","Mauritius")');
880
        $this->addSql('INSERT INTO "country_translation" VALUES(286,"MU","ru","name","Маврикий")');
881
        $this->addSql('INSERT INTO "country_translation" VALUES(287,"YT","en","name","Mayotte")');
882
        $this->addSql('INSERT INTO "country_translation" VALUES(288,"YT","ru","name","Майотта")');
883
        $this->addSql('INSERT INTO "country_translation" VALUES(289,"FX","en","name","Metropolitan France")');
884
        $this->addSql('INSERT INTO "country_translation" VALUES(290,"FX","ru","name","Метрополия Франции")');
885
        $this->addSql('INSERT INTO "country_translation" VALUES(291,"MX","en","name","Mexico")');
886
        $this->addSql('INSERT INTO "country_translation" VALUES(292,"MX","ru","name","Мексика")');
887
        $this->addSql('INSERT INTO "country_translation" VALUES(293,"FM","en","name","Micronesia")');
888
        $this->addSql('INSERT INTO "country_translation" VALUES(294,"FM","ru","name","Федеративные Штаты Микронезии")');
889
        $this->addSql('INSERT INTO "country_translation" VALUES(295,"MI","en","name","Midway Islands")');
890
        $this->addSql('INSERT INTO "country_translation" VALUES(296,"MI","ru","name","Мидуэй")');
891
        $this->addSql('INSERT INTO "country_translation" VALUES(297,"MD","en","name","Moldova")');
892
        $this->addSql('INSERT INTO "country_translation" VALUES(298,"MD","ru","name","Молдова")');
893
        $this->addSql('INSERT INTO "country_translation" VALUES(299,"MC","en","name","Monaco")');
894
        $this->addSql('INSERT INTO "country_translation" VALUES(300,"MC","ru","name","Монако")');
895
        $this->addSql('INSERT INTO "country_translation" VALUES(301,"MN","en","name","Mongolia")');
896
        $this->addSql('INSERT INTO "country_translation" VALUES(302,"MN","ru","name","Монголия")');
897
        $this->addSql('INSERT INTO "country_translation" VALUES(303,"ME","en","name","Montenegro")');
898
        $this->addSql('INSERT INTO "country_translation" VALUES(304,"ME","ru","name","Черногория")');
899
        $this->addSql('INSERT INTO "country_translation" VALUES(305,"MS","en","name","Montserrat")');
900
        $this->addSql('INSERT INTO "country_translation" VALUES(306,"MS","ru","name","Монсеррат")');
901
        $this->addSql('INSERT INTO "country_translation" VALUES(307,"MA","en","name","Morocco")');
902
        $this->addSql('INSERT INTO "country_translation" VALUES(308,"MA","ru","name","Марокко")');
903
        $this->addSql('INSERT INTO "country_translation" VALUES(309,"MZ","en","name","Mozambique")');
904
        $this->addSql('INSERT INTO "country_translation" VALUES(310,"MZ","ru","name","Мозамбик")');
905
        $this->addSql('INSERT INTO "country_translation" VALUES(311,"MM","en","name","Myanmar (Burma)")');
906
        $this->addSql('INSERT INTO "country_translation" VALUES(312,"MM","ru","name","Мьянма")');
907
        $this->addSql('INSERT INTO "country_translation" VALUES(313,"NA","en","name","Namibia")');
908
        $this->addSql('INSERT INTO "country_translation" VALUES(314,"NA","ru","name","Намибия")');
909
        $this->addSql('INSERT INTO "country_translation" VALUES(315,"NR","en","name","Nauru")');
910
        $this->addSql('INSERT INTO "country_translation" VALUES(316,"NR","ru","name","Науру")');
911
        $this->addSql('INSERT INTO "country_translation" VALUES(317,"NP","en","name","Nepal")');
912
        $this->addSql('INSERT INTO "country_translation" VALUES(318,"NP","ru","name","Непал")');
913
        $this->addSql('INSERT INTO "country_translation" VALUES(319,"NL","en","name","Netherlands")');
914
        $this->addSql('INSERT INTO "country_translation" VALUES(320,"NL","ru","name","Нидерланды")');
915
        $this->addSql('INSERT INTO "country_translation" VALUES(321,"AN","en","name","Netherlands Antilles")');
916
        $this->addSql('INSERT INTO "country_translation" VALUES(322,"AN","ru","name","Нидерландские Антильские острова")');
917
        $this->addSql('INSERT INTO "country_translation" VALUES(323,"NT","en","name","Neutral Zone")');
918
        $this->addSql('INSERT INTO "country_translation" VALUES(324,"NT","ru","name","Нейтральная зона (саудовско-иракская)")');
919
        $this->addSql('INSERT INTO "country_translation" VALUES(325,"NC","en","name","New Caledonia")');
920
        $this->addSql('INSERT INTO "country_translation" VALUES(326,"NC","ru","name","Новая Каледония")');
921
        $this->addSql('INSERT INTO "country_translation" VALUES(327,"NZ","en","name","New Zealand")');
922
        $this->addSql('INSERT INTO "country_translation" VALUES(328,"NZ","ru","name","Новая Зеландия")');
923
        $this->addSql('INSERT INTO "country_translation" VALUES(329,"NI","en","name","Nicaragua")');
924
        $this->addSql('INSERT INTO "country_translation" VALUES(330,"NI","ru","name","Никарагуа")');
925
        $this->addSql('INSERT INTO "country_translation" VALUES(331,"NE","en","name","Niger")');
926
        $this->addSql('INSERT INTO "country_translation" VALUES(332,"NE","ru","name","Нигер")');
927
        $this->addSql('INSERT INTO "country_translation" VALUES(333,"NG","en","name","Nigeria")');
928
        $this->addSql('INSERT INTO "country_translation" VALUES(334,"NG","ru","name","Нигерия")');
929
        $this->addSql('INSERT INTO "country_translation" VALUES(335,"NU","en","name","Niue")');
930
        $this->addSql('INSERT INTO "country_translation" VALUES(336,"NU","ru","name","Ниуе")');
931
        $this->addSql('INSERT INTO "country_translation" VALUES(337,"NF","en","name","Norfolk Island")');
932
        $this->addSql('INSERT INTO "country_translation" VALUES(338,"NF","ru","name","Остров Норфолк")');
933
        $this->addSql('INSERT INTO "country_translation" VALUES(339,"KP","en","name","North Korea")');
934
        $this->addSql('INSERT INTO "country_translation" VALUES(340,"KP","ru","name","Корейская Народно-Демократическая Республика")');
935
        $this->addSql('INSERT INTO "country_translation" VALUES(341,"VD","en","name","North Vietnam")');
936
        $this->addSql('INSERT INTO "country_translation" VALUES(342,"VD","ru","name","Демократическая Республика Вьетнам")');
937
        $this->addSql('INSERT INTO "country_translation" VALUES(343,"MP","en","name","Northern Mariana Islands")');
938
        $this->addSql('INSERT INTO "country_translation" VALUES(344,"MP","ru","name","Северные Марианские Острова")');
939
        $this->addSql('INSERT INTO "country_translation" VALUES(345,"NO","en","name","Norway")');
940
        $this->addSql('INSERT INTO "country_translation" VALUES(346,"NO","ru","name","Норвегия")');
941
        $this->addSql('INSERT INTO "country_translation" VALUES(347,"OM","en","name","Oman")');
942
        $this->addSql('INSERT INTO "country_translation" VALUES(348,"OM","ru","name","Оман")');
943
        $this->addSql('INSERT INTO "country_translation" VALUES(349,"PC","en","name","Pacific Islands Trust Territory")');
944
        $this->addSql('INSERT INTO "country_translation" VALUES(350,"PC","ru","name","Подопечная территория Тихоокеанские острова")');
945
        $this->addSql('INSERT INTO "country_translation" VALUES(351,"PK","en","name","Pakistan")');
946
        $this->addSql('INSERT INTO "country_translation" VALUES(352,"PK","ru","name","Пакистан")');
947
        $this->addSql('INSERT INTO "country_translation" VALUES(353,"PW","en","name","Palau")');
948
        $this->addSql('INSERT INTO "country_translation" VALUES(354,"PW","ru","name","Палау")');
949
        $this->addSql('INSERT INTO "country_translation" VALUES(355,"PS","en","name","Palestinian Territories")');
950
        $this->addSql('INSERT INTO "country_translation" VALUES(356,"PS","ru","name","Палестинская автономия")');
951
        $this->addSql('INSERT INTO "country_translation" VALUES(357,"PA","en","name","Panama")');
952
        $this->addSql('INSERT INTO "country_translation" VALUES(358,"PA","ru","name","Панама")');
953
        $this->addSql('INSERT INTO "country_translation" VALUES(359,"PZ","en","name","Panama Canal Zone")');
954
        $this->addSql('INSERT INTO "country_translation" VALUES(360,"PZ","ru","name","Зона Панамского канала")');
955
        $this->addSql('INSERT INTO "country_translation" VALUES(361,"PG","en","name","Papua New Guinea")');
956
        $this->addSql('INSERT INTO "country_translation" VALUES(362,"PG","ru","name","Папуа-Новая Гвинея")');
957
        $this->addSql('INSERT INTO "country_translation" VALUES(363,"PY","en","name","Paraguay")');
958
        $this->addSql('INSERT INTO "country_translation" VALUES(364,"PY","ru","name","Парагвай")');
959
        $this->addSql('INSERT INTO "country_translation" VALUES(365,"YD","en","name","People`s Democratic Republic of Yemen")');
960
        $this->addSql('INSERT INTO "country_translation" VALUES(366,"YD","ru","name","Народная Демократическая Республика Йемен")');
961
        $this->addSql('INSERT INTO "country_translation" VALUES(367,"PE","en","name","Peru")');
962
        $this->addSql('INSERT INTO "country_translation" VALUES(368,"PE","ru","name","Перу")');
963
        $this->addSql('INSERT INTO "country_translation" VALUES(369,"PH","en","name","Philippines")');
964
        $this->addSql('INSERT INTO "country_translation" VALUES(370,"PH","ru","name","Филиппины")');
965
        $this->addSql('INSERT INTO "country_translation" VALUES(371,"PN","en","name","Pitcairn Islands")');
966
        $this->addSql('INSERT INTO "country_translation" VALUES(372,"PN","ru","name","Питкерн")');
967
        $this->addSql('INSERT INTO "country_translation" VALUES(373,"PL","en","name","Poland")');
968
        $this->addSql('INSERT INTO "country_translation" VALUES(374,"PL","ru","name","Польша")');
969
        $this->addSql('INSERT INTO "country_translation" VALUES(375,"PT","en","name","Portugal")');
970
        $this->addSql('INSERT INTO "country_translation" VALUES(376,"PT","ru","name","Португалия")');
971
        $this->addSql('INSERT INTO "country_translation" VALUES(377,"PR","en","name","Puerto Rico")');
972
        $this->addSql('INSERT INTO "country_translation" VALUES(378,"PR","ru","name","Пуэрто-Рико")');
973
        $this->addSql('INSERT INTO "country_translation" VALUES(379,"QA","en","name","Qatar")');
974
        $this->addSql('INSERT INTO "country_translation" VALUES(380,"QA","ru","name","Катар")');
975
        $this->addSql('INSERT INTO "country_translation" VALUES(381,"RO","en","name","Romania")');
976
        $this->addSql('INSERT INTO "country_translation" VALUES(382,"RO","ru","name","Румыния")');
977
        $this->addSql('INSERT INTO "country_translation" VALUES(383,"RU","en","name","Russia")');
978
        $this->addSql('INSERT INTO "country_translation" VALUES(384,"RU","ru","name","Россия")');
979
        $this->addSql('INSERT INTO "country_translation" VALUES(385,"RW","en","name","Rwanda")');
980
        $this->addSql('INSERT INTO "country_translation" VALUES(386,"RW","ru","name","Руанда")');
981
        $this->addSql('INSERT INTO "country_translation" VALUES(387,"RE","en","name","Réunion")');
982
        $this->addSql('INSERT INTO "country_translation" VALUES(388,"RE","ru","name","Реюньон")');
983
        $this->addSql('INSERT INTO "country_translation" VALUES(389,"BL","en","name","Saint Barthélemy")');
984
        $this->addSql('INSERT INTO "country_translation" VALUES(390,"BL","ru","name","Остров Святого Бартоломея")');
985
        $this->addSql('INSERT INTO "country_translation" VALUES(391,"SH","en","name","Saint Helena")');
986
        $this->addSql('INSERT INTO "country_translation" VALUES(392,"SH","ru","name","Остров Святой Елены")');
987
        $this->addSql('INSERT INTO "country_translation" VALUES(393,"KN","en","name","Saint Kitts and Nevis")');
988
        $this->addSql('INSERT INTO "country_translation" VALUES(394,"KN","ru","name","Сент-Киттс и Невис")');
989
        $this->addSql('INSERT INTO "country_translation" VALUES(395,"LC","en","name","Saint Lucia")');
990
        $this->addSql('INSERT INTO "country_translation" VALUES(396,"LC","ru","name","Сент-Люсия")');
991
        $this->addSql('INSERT INTO "country_translation" VALUES(397,"MF","en","name","Saint Martin")');
992
        $this->addSql('INSERT INTO "country_translation" VALUES(398,"MF","ru","name","Остров Святого Мартина")');
993
        $this->addSql('INSERT INTO "country_translation" VALUES(399,"PM","en","name","Saint Pierre and Miquelon")');
994
        $this->addSql('INSERT INTO "country_translation" VALUES(400,"PM","ru","name","Сен-Пьер и Микелон")');
995
        $this->addSql('INSERT INTO "country_translation" VALUES(401,"VC","en","name","Saint Vincent and the Grenadines")');
996
        $this->addSql('INSERT INTO "country_translation" VALUES(402,"VC","ru","name","Сент-Винсент и Гренадины")');
997
        $this->addSql('INSERT INTO "country_translation" VALUES(403,"WS","en","name","Samoa")');
998
        $this->addSql('INSERT INTO "country_translation" VALUES(404,"WS","ru","name","Самоа")');
999
        $this->addSql('INSERT INTO "country_translation" VALUES(405,"SM","en","name","San Marino")');
1000
        $this->addSql('INSERT INTO "country_translation" VALUES(406,"SM","ru","name","Сан-Марино")');
1001
        $this->addSql('INSERT INTO "country_translation" VALUES(407,"SA","en","name","Saudi Arabia")');
1002
        $this->addSql('INSERT INTO "country_translation" VALUES(408,"SA","ru","name","Саудовская Аравия")');
1003
        $this->addSql('INSERT INTO "country_translation" VALUES(409,"SN","en","name","Senegal")');
1004
        $this->addSql('INSERT INTO "country_translation" VALUES(410,"SN","ru","name","Сенегал")');
1005
        $this->addSql('INSERT INTO "country_translation" VALUES(411,"RS","en","name","Serbia")');
1006
        $this->addSql('INSERT INTO "country_translation" VALUES(412,"RS","ru","name","Сербия")');
1007
        $this->addSql('INSERT INTO "country_translation" VALUES(413,"CS","en","name","Serbia and Montenegro")');
1008
        $this->addSql('INSERT INTO "country_translation" VALUES(414,"CS","ru","name","Сербия и Черногория")');
1009
        $this->addSql('INSERT INTO "country_translation" VALUES(415,"SC","en","name","Seychelles")');
1010
        $this->addSql('INSERT INTO "country_translation" VALUES(416,"SC","ru","name","Сейшельские Острова")');
1011
        $this->addSql('INSERT INTO "country_translation" VALUES(417,"SL","en","name","Sierra Leone")');
1012
        $this->addSql('INSERT INTO "country_translation" VALUES(418,"SL","ru","name","Сьерра-Леоне")');
1013
        $this->addSql('INSERT INTO "country_translation" VALUES(419,"SG","en","name","Singapore")');
1014
        $this->addSql('INSERT INTO "country_translation" VALUES(420,"SG","ru","name","Сингапур")');
1015
        $this->addSql('INSERT INTO "country_translation" VALUES(421,"SK","en","name","Slovakia")');
1016
        $this->addSql('INSERT INTO "country_translation" VALUES(422,"SK","ru","name","Словакия")');
1017
        $this->addSql('INSERT INTO "country_translation" VALUES(423,"SI","en","name","Slovenia")');
1018
        $this->addSql('INSERT INTO "country_translation" VALUES(424,"SI","ru","name","Словения")');
1019
        $this->addSql('INSERT INTO "country_translation" VALUES(425,"SB","en","name","Solomon Islands")');
1020
        $this->addSql('INSERT INTO "country_translation" VALUES(426,"SB","ru","name","Соломоновы Острова")');
1021
        $this->addSql('INSERT INTO "country_translation" VALUES(427,"SO","en","name","Somalia")');
1022
        $this->addSql('INSERT INTO "country_translation" VALUES(428,"SO","ru","name","Сомали")');
1023
        $this->addSql('INSERT INTO "country_translation" VALUES(429,"ZA","en","name","South Africa")');
1024
        $this->addSql('INSERT INTO "country_translation" VALUES(430,"ZA","ru","name","Южная Африка")');
1025
        $this->addSql('INSERT INTO "country_translation" VALUES(431,"GS","en","name","South Georgia and the South Sandwich Islands")');
1026
        $this->addSql('INSERT INTO "country_translation" VALUES(432,"GS","ru","name","Южная Джорджия и Южные Сандвичевы Острова")');
1027
        $this->addSql('INSERT INTO "country_translation" VALUES(433,"KR","en","name","South Korea")');
1028
        $this->addSql('INSERT INTO "country_translation" VALUES(434,"KR","ru","name","Республика Корея")');
1029
        $this->addSql('INSERT INTO "country_translation" VALUES(435,"ES","en","name","Spain")');
1030
        $this->addSql('INSERT INTO "country_translation" VALUES(436,"ES","ru","name","Испания")');
1031
        $this->addSql('INSERT INTO "country_translation" VALUES(437,"LK","en","name","Sri Lanka")');
1032
        $this->addSql('INSERT INTO "country_translation" VALUES(438,"LK","ru","name","Шри-Ланка")');
1033
        $this->addSql('INSERT INTO "country_translation" VALUES(439,"SD","en","name","Sudan")');
1034
        $this->addSql('INSERT INTO "country_translation" VALUES(440,"SD","ru","name","Судан")');
1035
        $this->addSql('INSERT INTO "country_translation" VALUES(441,"SR","en","name","Suriname")');
1036
        $this->addSql('INSERT INTO "country_translation" VALUES(442,"SR","ru","name","Суринам")');
1037
        $this->addSql('INSERT INTO "country_translation" VALUES(443,"SJ","en","name","Svalbard and Jan Mayen")');
1038
        $this->addSql('INSERT INTO "country_translation" VALUES(444,"SJ","ru","name","Свальбард и Ян-Майен")');
1039
        $this->addSql('INSERT INTO "country_translation" VALUES(445,"SZ","en","name","Swaziland")');
1040
        $this->addSql('INSERT INTO "country_translation" VALUES(446,"SZ","ru","name","Свазиленд")');
1041
        $this->addSql('INSERT INTO "country_translation" VALUES(447,"SE","en","name","Sweden")');
1042
        $this->addSql('INSERT INTO "country_translation" VALUES(448,"SE","ru","name","Швеция")');
1043
        $this->addSql('INSERT INTO "country_translation" VALUES(449,"CH","en","name","Switzerland")');
1044
        $this->addSql('INSERT INTO "country_translation" VALUES(450,"CH","ru","name","Швейцария")');
1045
        $this->addSql('INSERT INTO "country_translation" VALUES(451,"SY","en","name","Syria")');
1046
        $this->addSql('INSERT INTO "country_translation" VALUES(452,"SY","ru","name","Сирийская Арабская Республика")');
1047
        $this->addSql('INSERT INTO "country_translation" VALUES(453,"ST","en","name","São Tomé and Príncipe")');
1048
        $this->addSql('INSERT INTO "country_translation" VALUES(454,"ST","ru","name","Сан-Томе и Принсипи")');
1049
        $this->addSql('INSERT INTO "country_translation" VALUES(455,"TW","en","name","Taiwan")');
1050
        $this->addSql('INSERT INTO "country_translation" VALUES(456,"TW","ru","name","Тайвань")');
1051
        $this->addSql('INSERT INTO "country_translation" VALUES(457,"TJ","en","name","Tajikistan")');
1052
        $this->addSql('INSERT INTO "country_translation" VALUES(458,"TJ","ru","name","Таджикистан")');
1053
        $this->addSql('INSERT INTO "country_translation" VALUES(459,"TZ","en","name","Tanzania")');
1054
        $this->addSql('INSERT INTO "country_translation" VALUES(460,"TZ","ru","name","Танзания")');
1055
        $this->addSql('INSERT INTO "country_translation" VALUES(461,"TH","en","name","Thailand")');
1056
        $this->addSql('INSERT INTO "country_translation" VALUES(462,"TH","ru","name","Таиланд")');
1057
        $this->addSql('INSERT INTO "country_translation" VALUES(463,"TL","en","name","Timor-Leste")');
1058
        $this->addSql('INSERT INTO "country_translation" VALUES(464,"TL","ru","name","Восточный Тимор")');
1059
        $this->addSql('INSERT INTO "country_translation" VALUES(465,"TG","en","name","Togo")');
1060
        $this->addSql('INSERT INTO "country_translation" VALUES(466,"TG","ru","name","Того")');
1061
        $this->addSql('INSERT INTO "country_translation" VALUES(467,"TK","en","name","Tokelau")');
1062
        $this->addSql('INSERT INTO "country_translation" VALUES(468,"TK","ru","name","Токелау")');
1063
        $this->addSql('INSERT INTO "country_translation" VALUES(469,"TO","en","name","Tonga")');
1064
        $this->addSql('INSERT INTO "country_translation" VALUES(470,"TO","ru","name","Тонга")');
1065
        $this->addSql('INSERT INTO "country_translation" VALUES(471,"TT","en","name","Trinidad and Tobago")');
1066
        $this->addSql('INSERT INTO "country_translation" VALUES(472,"TT","ru","name","Тринидад и Тобаго")');
1067
        $this->addSql('INSERT INTO "country_translation" VALUES(473,"TN","en","name","Tunisia")');
1068
        $this->addSql('INSERT INTO "country_translation" VALUES(474,"TN","ru","name","Тунис")');
1069
        $this->addSql('INSERT INTO "country_translation" VALUES(475,"TR","en","name","Turkey")');
1070
        $this->addSql('INSERT INTO "country_translation" VALUES(476,"TR","ru","name","Турция")');
1071
        $this->addSql('INSERT INTO "country_translation" VALUES(477,"TM","en","name","Turkmenistan")');
1072
        $this->addSql('INSERT INTO "country_translation" VALUES(478,"TM","ru","name","Туркменистан")');
1073
        $this->addSql('INSERT INTO "country_translation" VALUES(479,"TC","en","name","Turks and Caicos Islands")');
1074
        $this->addSql('INSERT INTO "country_translation" VALUES(480,"TC","ru","name","Острова Тёркс и Кайкос")');
1075
        $this->addSql('INSERT INTO "country_translation" VALUES(481,"TV","en","name","Tuvalu")');
1076
        $this->addSql('INSERT INTO "country_translation" VALUES(482,"TV","ru","name","Тувалу")');
1077
        $this->addSql('INSERT INTO "country_translation" VALUES(483,"UM","en","name","U.S. Minor Outlying Islands")');
1078
        $this->addSql('INSERT INTO "country_translation" VALUES(484,"UM","ru","name","Внешние малые острова (США)")');
1079
        $this->addSql('INSERT INTO "country_translation" VALUES(485,"PU","en","name","U.S. Miscellaneous Pacific Islands")');
1080
        $this->addSql('INSERT INTO "country_translation" VALUES(486,"PU","ru","name","Малые отдаленные острова Соединенных Штатов")');
1081
        $this->addSql('INSERT INTO "country_translation" VALUES(487,"VI","en","name","U.S. Virgin Islands")');
1082
        $this->addSql('INSERT INTO "country_translation" VALUES(488,"VI","ru","name","Американские Виргинские острова")');
1083
        $this->addSql('INSERT INTO "country_translation" VALUES(489,"UG","en","name","Uganda")');
1084
        $this->addSql('INSERT INTO "country_translation" VALUES(490,"UG","ru","name","Уганда")');
1085
        $this->addSql('INSERT INTO "country_translation" VALUES(491,"UA","en","name","Ukraine")');
1086
        $this->addSql('INSERT INTO "country_translation" VALUES(492,"UA","ru","name","Украина")');
1087
        $this->addSql('INSERT INTO "country_translation" VALUES(493,"SU","en","name","Union of Soviet Socialist Republics")');
1088
        $this->addSql('INSERT INTO "country_translation" VALUES(494,"SU","ru","name","СССР")');
1089
        $this->addSql('INSERT INTO "country_translation" VALUES(495,"AE","en","name","United Arab Emirates")');
1090
        $this->addSql('INSERT INTO "country_translation" VALUES(496,"AE","ru","name","Объединенные Арабские Эмираты")');
1091
        $this->addSql('INSERT INTO "country_translation" VALUES(497,"GB","en","name","United Kingdom")');
1092
        $this->addSql('INSERT INTO "country_translation" VALUES(498,"GB","ru","name","Великобритания")');
1093
        $this->addSql('INSERT INTO "country_translation" VALUES(499,"US","en","name","United States")');
1094
        $this->addSql('INSERT INTO "country_translation" VALUES(500,"US","ru","name","США")');
1095
        $this->addSql('INSERT INTO "country_translation" VALUES(501,"ZZ","en","name","Unknown or Invalid Region")');
1096
        $this->addSql('INSERT INTO "country_translation" VALUES(502,"ZZ","ru","name","Неизвестный или недействительный регион")');
1097
        $this->addSql('INSERT INTO "country_translation" VALUES(503,"UY","en","name","Uruguay")');
1098
        $this->addSql('INSERT INTO "country_translation" VALUES(504,"UY","ru","name","Уругвай")');
1099
        $this->addSql('INSERT INTO "country_translation" VALUES(505,"UZ","en","name","Uzbekistan")');
1100
        $this->addSql('INSERT INTO "country_translation" VALUES(506,"UZ","ru","name","Узбекистан")');
1101
        $this->addSql('INSERT INTO "country_translation" VALUES(507,"VU","en","name","Vanuatu")');
1102
        $this->addSql('INSERT INTO "country_translation" VALUES(508,"VU","ru","name","Вануату")');
1103
        $this->addSql('INSERT INTO "country_translation" VALUES(509,"VA","en","name","Vatican City")');
1104
        $this->addSql('INSERT INTO "country_translation" VALUES(510,"VA","ru","name","Ватикан")');
1105
        $this->addSql('INSERT INTO "country_translation" VALUES(511,"VE","en","name","Venezuela")');
1106
        $this->addSql('INSERT INTO "country_translation" VALUES(512,"VE","ru","name","Венесуэла")');
1107
        $this->addSql('INSERT INTO "country_translation" VALUES(513,"VN","en","name","Vietnam")');
1108
        $this->addSql('INSERT INTO "country_translation" VALUES(514,"VN","ru","name","Вьетнам")');
1109
        $this->addSql('INSERT INTO "country_translation" VALUES(515,"WK","en","name","Wake Island")');
1110
        $this->addSql('INSERT INTO "country_translation" VALUES(516,"WK","ru","name","Уэйк")');
1111
        $this->addSql('INSERT INTO "country_translation" VALUES(517,"WF","en","name","Wallis and Futuna")');
1112
        $this->addSql('INSERT INTO "country_translation" VALUES(518,"WF","ru","name","Уоллис и Футуна")');
1113
        $this->addSql('INSERT INTO "country_translation" VALUES(519,"EH","en","name","Western Sahara")');
1114
        $this->addSql('INSERT INTO "country_translation" VALUES(520,"EH","ru","name","Западная Сахара")');
1115
        $this->addSql('INSERT INTO "country_translation" VALUES(521,"YE","en","name","Yemen")');
1116
        $this->addSql('INSERT INTO "country_translation" VALUES(522,"YE","ru","name","Йемен")');
1117
        $this->addSql('INSERT INTO "country_translation" VALUES(523,"ZM","en","name","Zambia")');
1118
        $this->addSql('INSERT INTO "country_translation" VALUES(524,"ZM","ru","name","Замбия")');
1119
        $this->addSql('INSERT INTO "country_translation" VALUES(525,"ZW","en","name","Zimbabwe")');
1120
        $this->addSql('INSERT INTO "country_translation" VALUES(526,"ZW","ru","name","Зимбабве")');
1121
        $this->addSql('INSERT INTO "country_translation" VALUES(527,"AX","en","name","Åland Islands")');
1122
        $this->addSql('INSERT INTO "country_translation" VALUES(528,"AX","ru","name","Аландские острова")');
1123
    }
1124
}
1125