m160705_110432_init_tale_country.php
17.6 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
<?php
use yii\db\Migration;
use thread\modules\location\Location as ParentModule;
/**
* Class m160705_110432_init_tale_country
*
* @author FilamentV <vortex.filament@gmail.com>
* @copyright (c), Thread
*/
class m160705_110432_init_tale_country extends Migration
{
/**
* @var string
*/
public $table = '{{%location_country}}';
/**
*
*/
public function init()
{
$this->db = ParentModule::getDb();
parent::init();
}
public function up()
{
$this->execute("
INSERT INTO `fv_location_country` (`id`, `alias`, `alpha2`, `alpha3`, `iso`, `created_at`, `updated_at`, `published`, `deleted`)
VALUES
(4,'australia','AU','AUS',36,0,1464278369,'1','0'),
(63,'austria','AT','AUT',40,0,1464273929,'1','0'),
(81,'azerbaijan','AZ','AZE',31,0,1464273948,'1','0'),
(173,'anguilla','AI','AIA',660,0,1464278369,'1','0'),
(177,'argentina','AR','ARG',32,0,1464278369,'1','0'),
(245,'armenia','AM','ARM',51,0,1464274009,'1','0'),
(248,'belarus','BY','BLR',112,0,1464274030,'1','0'),
(401,'belize','BZ','BLZ',84,0,1464274057,'1','0'),
(404,'belgium','BE','BEL',56,0,1464274081,'1','0'),
(425,'bermuda','BM','BMU',60,0,1464274105,'1','0'),
(428,'bulgaria','BG','BGR',100,0,1464278369,'1','0'),
(467,'brazil','BR','BRA',76,0,1464274219,'1','0'),
(616,'united','GB','GBR',826,0,1464278369,'1','0'),
(924,'hungary','HU','HUN',348,0,1464274408,'1','0'),
(971,'viet','VN','VNM',704,0,1464278369,'1','0'),
(994,'haiti','HT','HTI',332,0,1464278369,'1','0'),
(1007,'guadeloupe','GP','GLP',312,0,1464278369,'1','0'),
(1012,'germany','DE','DEU',276,0,1464274524,'1','0'),
(1206,'netherlands','NL','NLD',528,0,1464274603,'1','0'),
(1258,'greece','GR','GRC',300,0,1464274637,'1','0'),
(1280,'georgia','GE','GEO',268,0,1464274718,'1','0'),
(1366,'denmark','DK','DNK',208,0,1464274754,'1','0'),
(1380,'egypt','EG','EGY',818,0,1464274981,'1','0'),
(1393,'israel','IL','ISR',376,0,1464278370,'1','0'),
(1451,'india','IN','IND',356,0,1464278370,'1','0'),
(1663,'iran','IR','IRs',364,0,1463059178,'1','0'),
(1696,'ireland','IE','IRL',372,0,1464278370,'1','0'),
(1707,'spain','ES','ESP',724,0,1464274475,'1','0'),
(1786,'italy','IT','ITA',380,0,1464278370,'1','0'),
(1894,'kazakhstan','KZ','KAZ',398,0,1464274890,'1','0'),
(2163,'cameroon','CM','CMR',120,0,1464276202,'1','0'),
(2172,'canada','CA','CAN',124,0,1464274916,'1','0'),
(2297,'cyprus','CY','CYP',196,0,1464275211,'1','0'),
(2303,'kyrgyzstan','KG','KGZ',417,0,1464276276,'1','0'),
(2374,'china','CN','CHN',156,0,1464275276,'1','0'),
(2430,'kosta-rika','CR','CRI',188,0,1463062147,'1','0'),
(2443,'kuwait','KW','KWT',414,0,1464278369,'1','0'),
(2448,'latvia','LV','LVA',428,0,1464275977,'1','0'),
(2509,'libya','LY','LBY',434,0,1464276004,'1','0'),
(2514,'lithuania','LT','LTU',440,0,1464276034,'1','0'),
(2614,'luxembourg','LU','LUX',442,0,1464276154,'1','0'),
(2617,'mexico','MX','MEX',484,0,1464276173,'1','0'),
(2788,'moldova','MD','MDA',498,0,1463059453,'1','0'),
(2833,'monaco','MC','MCO',492,0,1464276122,'1','0'),
(2837,'novaya-zelandiya','NZ','NZL',554,0,1463059503,'1','0'),
(2880,'norway','NO','NOR',578,0,1464276095,'1','0'),
(2897,'poland','PL','POL',616,0,1464275182,'1','0'),
(3141,'portugal','PT','PRT',620,0,1464276067,'1','0'),
(3156,'reunion','RE','REU',638,0,1464276303,'1','0'),
(3159,'russia','RU','RUS',643,0,1464275140,'1','0'),
(5647,'saljvador','SV','SLV',222,0,1461754959,'1','0'),
(5666,'slovakia','SK','SVK',703,0,1464278370,'1','0'),
(5673,'slovenia','SI','SVN',705,0,1464278370,'1','0'),
(5678,'surinam','SR','SUR',740,0,1461756646,'1','0'),
(5681,'usa','US','USA',0,0,1464278370,'1','0'),
(9575,'tadjikistan','TJ','TJK',762,0,1461756702,'1','0'),
(9638,'turkmenistan','TM','TKM',795,0,1464278370,'1','0'),
(9701,'turks-i-keykos','','',0,0,1461758093,'1','0'),
(9705,'turkey','TR','TUR',792,0,1464278370,'1','0'),
(9782,'uganda','UG','UGA',800,0,1464278370,'1','0'),
(9787,'uzbekistan','UZ','UZB',860,0,1464278370,'1','0'),
(9908,'ukraine','UA','UKR',804,0,1464278370,'1','0'),
(10648,'finland','FI','FIN',246,0,1464278370,'1','0'),
(10668,'france','FR','FRA',250,0,1464278370,'1','0'),
(10874,'czech','CZ','CZE',203,0,1464338779,'1','0'),
(10904,'switzerland','CH','CHE',756,0,1464278370,'1','0'),
(10933,'sweden','SE','SWE',752,0,1464278370,'1','0'),
(10968,'estonia','EE','EST',233,0,1464278370,'1','0'),
(11002,'yugoslaviya','','',0,0,1461759244,'1','0'),
(11014,'yujnaya-koreya','KR','KOR',410,0,1461759515,'1','0'),
(11060,'yaponiya','JP','JPN',392,0,1461759560,'1','0'),
(277551,'niderlandi','NL','NLD',528,0,1461753747,'1','0'),
(277553,'croatia','HR','HRV',191,0,1464278370,'1','0'),
(277555,'ruminiya','RO','ROU',642,0,1461754928,'1','0'),
(277557,'hong','HK','HKG',344,0,1464278369,'1','0'),
(277559,'indonesia','ID','IDN',360,0,1464278370,'1','0'),
(277561,'jordan','JO','JOR',400,0,1464278370,'1','0'),
(277563,'malaysia','MY','MYS',458,0,1464278369,'1','0'),
(277565,'singapore','SG','SGP',702,0,1464278370,'1','0'),
(277567,'tayvanj','TW','TWN',158,0,1461757714,'1','0'),
(277569,'turkmeniya','TM','TKM',795,0,1461758059,'1','0'),
(582029,'karibi','','',0,0,1463061440,'1','0'),
(582031,'chile','CL','CHL',152,0,1464278370,'1','0'),
(582040,'koreya','KR','KOR',410,0,1463062125,'1','0'),
(582041,'makedoniya','MK','MKD',807,0,1463062328,'1','0'),
(582043,'malta','MT','MLT',470,0,1464278369,'1','0'),
(582044,'pakistan','PK','PAK',586,0,1464278369,'1','0'),
(582046,'peru','PE','PER',604,0,1464278369,'1','0'),
(582050,'tayland','TH','THA',764,0,1461757775,'1','0'),
(582051,'oae','AE','ARE',784,0,1461754210,'1','0'),
(582060,'lebanon','LB','LBN',422,0,1464278369,'1','0'),
(582064,'ecuador','EC','ECU',218,0,1464278370,'1','0'),
(582065,'morocco','MA','MAR',504,0,1464278369,'1','0'),
(582067,'siriya','SY','SYR',760,0,1461756204,'1','0'),
(582077,'cuba','CU','CUB',192,0,1464278369,'1','0'),
(582082,'mozambique','MZ','MOZ',508,0,1464278369,'1','0'),
(582090,'tunisia','TN','TUN',788,0,1464278370,'1','0'),
(582105,'ostrov-men','','',0,0,1461754353,'1','0'),
(582106,'yamayka','JM','JAM',388,0,1461759537,'1','0'),
(2567393,'honduras','HN','HND',340,0,1464278369,'1','0'),
(2577958,'dominikanskaya-respublika','DO','DOM',214,0,1463061209,'1','0'),
(2687701,'mongolia','MN','MNG',496,0,1464278369,'1','0'),
(3410238,'iraq','IQ','IRQ',368,0,1464278370,'1','0'),
(3661568,'yuar','ZA','ZAF',710,0,1461759202,'1','0'),
(7716093,'aruljko','','',0,0,1461744452,'1','0'),
(7716094,'afghanistan','','',0,0,1464278369,'1','0'),
(7716095,'albania','','',0,0,1464278369,'1','0'),
(7716096,'algeria','','',0,0,1464278369,'1','0'),
(7716097,'andorra','','',0,0,1464278369,'1','0'),
(7716098,'kiribati','','',0,0,1463062008,'1','0'),
(7716099,'kokosovie-kiling-ostrova','','',0,0,1463062037,'1','0'),
(7716100,'nauru','','',0,0,1461753583,'1','0'),
(7716101,'norfolk-ostrov','','',0,0,1461754127,'1','0'),
(7716102,'ostrov-rojdestva','','',0,0,1461754564,'1','0'),
(7716103,'tuvalu','','',0,0,1461758004,'1','0'),
(7716104,'herd-i-makdonaljd-ostrova','','',0,0,1461758418,'1','0'),
(7716105,'bagamskie-ostrova','','',0,0,1461744514,'1','0'),
(7716106,'bahrain','','',0,0,1464278369,'1','0'),
(7716107,'bangladesh','','',0,0,1464278369,'1','0'),
(7716108,'barbados','','',0,0,1464278369,'1','0'),
(7716109,'bermudskie-ostrova','','',0,0,1461744867,'1','0'),
(7716110,'bhutan','','',0,0,1464278369,'1','0'),
(7716111,'bolivia','','',0,0,1464278369,'1','0'),
(7716112,'botswana','','',0,0,1464278369,'1','0'),
(7716113,'solomonovi-ostrova','','',0,0,1461756487,'1','0'),
(7716114,'bruney-darussalam','','',0,0,1461745144,'1','0'),
(7716115,'mjyanma','','',0,0,1461753162,'1','0'),
(7716116,'burundi','','',0,0,1464278369,'1','0'),
(7716117,'cambodia','','',0,0,1464278370,'1','0'),
(7716118,'kabo-verde','','',0,0,1463061388,'1','0'),
(7716119,'kaymanovi-ostrova','','',0,0,1463061408,'1','0'),
(7716120,'shri-lanka','','',0,0,1461759002,'1','0'),
(7716121,'colombia','','',0,0,1464278370,'1','0'),
(7716122,'komorskie-ostrova','','',0,0,1463062074,'1','0'),
(7716124,'greenland','','',0,0,1464278370,'1','0'),
(7716125,'farerskie-ostrova','','',0,0,1461758235,'1','0'),
(7716126,'efiopiya','','',0,0,1461759174,'1','0'),
(7716127,'eritrea','','',0,0,1464278370,'1','0'),
(7716128,'folklendskie-maljvinskie-ostrova','','',0,0,1461758321,'1','0'),
(7716129,'fiji','','',0,0,1464278370,'1','0'),
(7716130,'djibuti','','',0,0,1463061188,'1','0'),
(7716131,'gambia','','',0,0,1464278369,'1','0'),
(7716132,'ghana','','',0,0,1464278369,'1','0'),
(7716133,'gibraltar','','',0,0,1463059935,'1','0'),
(7716134,'guatemala','','',0,0,1464278369,'1','0'),
(7716135,'guinea','','',0,0,1464278369,'1','0'),
(7716136,'gayana','','',0,0,1461747043,'1','0'),
(7716137,'iceland','','',0,0,1464278370,'1','0'),
(7716139,'vostochniy-timor','','',0,0,1461745590,'1','0'),
(7716140,'iran-islamskaya-respublika','','',0,0,1463061326,'1','0'),
(7716141,'kenya','','',0,0,1464278370,'1','0'),
(7716142,'koreya-demokraticheskaya-narodnaya-respublika','','',0,0,1463062137,'1','0'),
(7716143,'koreya-respublika','','',0,0,1461749515,'1','0'),
(7716144,'kirgiziya','','',0,0,1463061996,'1','0'),
(7716145,'laos-narodnaya-demokraticheskaya-respublika','','',0,0,1463062179,'1','0'),
(7716146,'lesoto','','',0,0,1463062198,'1','0'),
(7716147,'liberia','','',0,0,1464278369,'1','0'),
(7716148,'liviyskaya-arabskaya-djamahiriya','','',0,0,1463062228,'1','0'),
(7716149,'makao','','',0,0,1463062311,'1','0'),
(7716150,'madagascar','','',0,0,1464278369,'1','0'),
(7716151,'malawi','','',0,0,1464278369,'1','0'),
(7716152,'maldives','','',0,0,1464278369,'1','0'),
(7716153,'mauritania','','',0,0,1464278369,'1','0'),
(7716154,'mauritius','','',0,0,1464278369,'1','0'),
(7716155,'zapadnaya-sahara','','',0,0,1463061238,'1','0'),
(7716156,'oman','','',0,0,1461754273,'1','0'),
(7716157,'namibia','','',0,0,1464278369,'1','0'),
(7716158,'nepal','','',0,0,1461753614,'1','0'),
(7716159,'niderlandskie-antiljskie-ostrova','','',0,0,1461753728,'1','0'),
(7716160,'aruba','','',0,0,1464278369,'1','0'),
(7716161,'vanuatu','','',0,0,1461745296,'1','0'),
(7716162,'niue','','',0,0,1461754019,'1','0'),
(7716163,'ostrova-kuka','','',0,0,1461754629,'1','0'),
(7716164,'pitkern','','',0,0,1461754814,'1','0'),
(7716165,'tokelau','','',0,0,1461757941,'1','0'),
(7716166,'nikaragua','','',0,0,1461753765,'1','0'),
(7716167,'nigeria','','',0,0,1464278369,'1','0'),
(7716168,'buve-ostrov','','',0,0,1461745181,'1','0'),
(7716169,'svaljbard-i-yan-mayen-ostrova','','',0,0,1461755171,'1','0'),
(7716170,'panama','','',0,0,1464278369,'1','0'),
(7716171,'papua-novaya-gvineya','','',0,0,1461754751,'1','0'),
(7716172,'paraguay','','',0,0,1464278369,'1','0'),
(7716173,'philippines','','',0,0,1464278370,'1','0'),
(7716174,'gvineya-bisau','','',0,0,1463059614,'1','0'),
(7716176,'qatar','','',0,0,1464278370,'1','0'),
(7716177,'ruanda','','',0,0,1461754902,'1','0'),
(7716178,'ostrov-svyatoy-eleni','','',0,0,1461754606,'1','0'),
(7716179,'san-tome-i-prinsipi','','',0,0,1461755071,'1','0'),
(7716180,'saudovskaya-araviya','','',0,0,1461755089,'1','0'),
(7716181,'seysheljskie-ostrova','','',0,0,1461755498,'1','0'),
(7716182,'sjerra-leone','','',0,0,1461756685,'1','0'),
(7716183,'somalia','','',0,0,1464278370,'1','0'),
(7716186,'yujnaya-afrika','','',0,0,1461759308,'1','0'),
(7716187,'zimbabwe','','',0,0,1464278370,'1','0'),
(7716188,'sudan','','',0,0,1464278370,'1','0'),
(7716189,'svazilend','','',0,0,1461755126,'1','0'),
(7716190,'liechtenstein','','',0,0,1464278369,'1','0'),
(7716191,'siriyskaya-arabskaya-respublika','','',0,0,1461756179,'1','0'),
(7716192,'thailand','','',0,0,1464278370,'1','0'),
(7716193,'tonga','','',0,0,1461757965,'1','0'),
(7716194,'trinidad-i-tobago','','',0,0,1461757987,'1','0'),
(7716195,'obyedinennie-arabskie-emirati-oae','','',0,0,1461754228,'1','0'),
(7716196,'soedinennoe-korolevstvo-velikobritaniya','','',0,0,1461756452,'1','0'),
(7716197,'tanzaniya-edinaya-respublika','','',0,0,1461757810,'1','0'),
(7716198,'amerikanskoe-samoa','','',0,0,1461743841,'1','0'),
(7716199,'britanskaya-territoriya-v-indiyskom-okeane','','',0,0,1461745118,'1','0'),
(7716200,'virginskie-ostrova-britanskie','','',0,0,1461745518,'1','0'),
(7716201,'virginskie-ostrova-ssha','','',0,0,1461745571,'1','0'),
(7716202,'guam','','',0,0,1463061172,'1','0'),
(7716203,'malie-tihookeanskie-otdalennie-ostrova-ssha','','',0,0,1461750080,'1','0'),
(7716204,'marshallovi-ostrova','','',0,0,1463062437,'1','0'),
(7716205,'mikroneziya','','',0,0,1463062667,'1','0'),
(7716206,'palau','','',0,0,1461754680,'1','0'),
(7716208,'puerto-riko','','',0,0,1461754879,'1','0'),
(7716209,'severnie-marianskie-ostrova','','',0,0,1461755403,'1','0'),
(7716210,'soedinennie-shtati-ameriki-ssha','','',0,0,1461756469,'1','0'),
(7716211,'terks-i-kaykos-ostrova','','',0,0,1461757841,'1','0'),
(7716212,'uruguay','','',0,0,1464278370,'1','0'),
(7716213,'venezuela','','',0,0,1464278369,'1','0'),
(7716214,'samoa','','',0,0,1461754973,'1','0'),
(7716215,'yemen','','',0,0,1463061374,'1','0'),
(7716216,'zambia','','',0,0,1464278370,'1','0'),
(7716217,'tayvanj-provintsiya-kitaya','','',0,0,1461757744,'1','0'),
(7716218,'gabon','','',0,0,1464278369,'1','0'),
(7716219,'kongo','','',0,0,1463062087,'1','0'),
(7716220,'tsentraljno-afrikanskaya-respublika','','',0,0,1461758503,'1','0'),
(7716221,'chad','','',0,0,1464278370,'1','0'),
(7716222,'ekvatorialjnaya-gvineya','','',0,0,1461759125,'1','0'),
(7716223,'antigua-i-barbuda','','',0,0,1461744037,'1','0'),
(7716224,'grenada','','',0,0,1463061101,'1','0'),
(7716225,'dominica','','',0,0,1464278370,'1','0'),
(7716226,'monserrat','','',0,0,1461753144,'1','0'),
(7716227,'sent-vinsent-i-grenadini','','',0,0,1461755915,'1','0'),
(7716228,'sent-kits-i-nevis','','',0,0,1461755943,'1','0'),
(7716229,'sent-lyusiya','','',0,0,1461756039,'1','0'),
(7716230,'benin','','',0,0,1464278369,'1','0'),
(7716231,'burkina-faso','','',0,0,1461745200,'1','0'),
(7716233,'mali','','',0,0,1464278369,'1','0'),
(7716234,'niger','','',0,0,1464278369,'1','0'),
(7716235,'senegal','','',0,0,1461755664,'1','0'),
(7716236,'togo','','',0,0,1461757915,'1','0'),
(7716237,'frantsuzskaya-polineziya','','',0,0,1461758378,'1','0'),
(7716238,'novaya-kaledoniya','','',0,0,1461754071,'1','0'),
(7716239,'uollis-i-futuna-ostrova','','',0,0,1461758201,'1','0'),
(7716240,'mejdunarodniy-valyutniy-fond','','',0,0,1463062649,'1','0'),
(7716241,'angola','','',0,0,1464278369,'1','0'),
(7716242,'kongo-demokraticheskaya-respublika','','',0,0,1463062116,'1','0'),
(7716243,'bosniya-i-gertsegovina','','',0,0,1461744942,'1','0'),
(7716245,'vatikan-gorod-gosudarstvo','','',0,0,1461745441,'1','0'),
(7716246,'martinika','','',0,0,1463062419,'1','0'),
(7716247,'san-marino','','',0,0,1461755052,'1','0'),
(7716248,'sen-pjer-i-mikelon','','',0,0,1461755588,'1','0'),
(7716249,'frantsuzskaya-gviana','','',0,0,1461758358,'1','0'),
(7716250,'frantsuzskie-yujnie-territorii','','',0,0,1461758394,'1','0');
");
}
public function down()
{
//TODO:: m160705_110432_init_tale_country
}
}