|
1
|
|
|
<?php |
|
2
|
|
|
|
|
3
|
|
|
/** |
|
4
|
|
|
* PWWEB\Localisation\Database\Seeders\Country Seeder. |
|
5
|
|
|
* |
|
6
|
|
|
* Standard seeder for the Country Model. |
|
7
|
|
|
* |
|
8
|
|
|
* @author Frank Pillukeit <[email protected]> |
|
9
|
|
|
* @copyright 2020 pw-websolutions.com |
|
10
|
|
|
* @license http://www.opensource.org/licenses/mit-license.html MIT License |
|
11
|
|
|
*/ |
|
12
|
|
|
|
|
13
|
|
|
namespace PWWEB\Localisation\Database\Seeders; |
|
14
|
|
|
|
|
15
|
|
|
use Illuminate\Database\Seeder; |
|
16
|
|
|
use Illuminate\Support\Facades\DB; |
|
17
|
|
|
|
|
18
|
|
|
class CountrySeeder extends Seeder |
|
19
|
|
|
{ |
|
20
|
|
|
/** |
|
21
|
|
|
* Run the database seeds. |
|
22
|
|
|
* |
|
23
|
|
|
* @return void |
|
24
|
|
|
*/ |
|
25
|
|
|
public function run() |
|
26
|
|
|
{ |
|
27
|
|
|
// Initializing variables. |
|
28
|
|
|
$createdAt = date('Y-m-d H:i:s'); |
|
29
|
|
|
$countries = []; |
|
30
|
|
|
|
|
31
|
|
|
// Definition of default countries. |
|
32
|
|
|
$countries[] = ['iso' => 'AF', 'ioc' => 'AFG', 'name' => 'Afghanistan', 'active' => 0]; |
|
33
|
|
|
$countries[] = ['iso' => 'AL', 'ioc' => 'ALB', 'name' => 'Albania', 'active' => 0]; |
|
34
|
|
|
$countries[] = ['iso' => 'DZ', 'ioc' => 'ALG', 'name' => 'Algeria', 'active' => 0]; |
|
35
|
|
|
$countries[] = ['iso' => 'AS', 'ioc' => 'ASA', 'name' => 'American Samoa', 'active' => 0]; |
|
36
|
|
|
$countries[] = ['iso' => 'AD', 'ioc' => 'AND', 'name' => 'Andorra', 'active' => 0]; |
|
37
|
|
|
$countries[] = ['iso' => 'AO', 'ioc' => 'ANG', 'name' => 'Angola', 'active' => 0]; |
|
38
|
|
|
$countries[] = ['iso' => 'AI', 'ioc' => null, 'name' => 'Anguilla', 'active' => 0]; |
|
39
|
|
|
$countries[] = ['iso' => 'AQ', 'ioc' => null, 'name' => 'Antarctica', 'active' => 0]; |
|
40
|
|
|
$countries[] = ['iso' => 'AG', 'ioc' => 'ANT', 'name' => 'Antigua and Barbuda', 'active' => 0]; |
|
41
|
|
|
$countries[] = ['iso' => 'AR', 'ioc' => 'ARG', 'name' => 'Argentina', 'active' => 0]; |
|
42
|
|
|
$countries[] = ['iso' => 'AM', 'ioc' => 'ARM', 'name' => 'Armenia', 'active' => 0]; |
|
43
|
|
|
$countries[] = ['iso' => 'AW', 'ioc' => 'ARU', 'name' => 'Aruba', 'active' => 0]; |
|
44
|
|
|
$countries[] = ['iso' => 'AU', 'ioc' => 'AUS', 'name' => 'Australia', 'active' => 0]; |
|
45
|
|
|
$countries[] = ['iso' => 'AT', 'ioc' => 'AUT', 'name' => 'Austria', 'active' => 1]; |
|
46
|
|
|
$countries[] = ['iso' => 'AZ', 'ioc' => 'AZE', 'name' => 'Azerbaijan', 'active' => 0]; |
|
47
|
|
|
$countries[] = ['iso' => 'BS', 'ioc' => 'BAH', 'name' => 'Bahamas', 'active' => 0]; |
|
48
|
|
|
$countries[] = ['iso' => 'BH', 'ioc' => 'BRN', 'name' => 'Bahrain', 'active' => 0]; |
|
49
|
|
|
$countries[] = ['iso' => 'BD', 'ioc' => 'BAN', 'name' => 'Bangladesh', 'active' => 0]; |
|
50
|
|
|
$countries[] = ['iso' => 'BB', 'ioc' => 'BAR', 'name' => 'Barbados', 'active' => 0]; |
|
51
|
|
|
$countries[] = ['iso' => 'BY', 'ioc' => 'BLR', 'name' => 'Belarus', 'active' => 0]; |
|
52
|
|
|
$countries[] = ['iso' => 'BE', 'ioc' => 'BEL', 'name' => 'Belgium', 'active' => 0]; |
|
53
|
|
|
$countries[] = ['iso' => 'BZ', 'ioc' => 'BIZ', 'name' => 'Belize', 'active' => 0]; |
|
54
|
|
|
$countries[] = ['iso' => 'BJ', 'ioc' => 'BEN', 'name' => 'Benin', 'active' => 0]; |
|
55
|
|
|
$countries[] = ['iso' => 'BM', 'ioc' => 'BER', 'name' => 'Bermuda', 'active' => 0]; |
|
56
|
|
|
$countries[] = ['iso' => 'BT', 'ioc' => 'BHU', 'name' => 'Bhutan', 'active' => 0]; |
|
57
|
|
|
$countries[] = ['iso' => 'BO', 'ioc' => 'BOL', 'name' => 'Bolivia', 'active' => 0]; |
|
58
|
|
|
$countries[] = ['iso' => 'BA', 'ioc' => 'BIH', 'name' => 'Bosnia and Herzegowina', 'active' => 0]; |
|
59
|
|
|
$countries[] = ['iso' => 'BW', 'ioc' => 'BOT', 'name' => 'Botswana', 'active' => 0]; |
|
60
|
|
|
$countries[] = ['iso' => 'BV', 'ioc' => null, 'name' => 'Bouvet Island', 'active' => 0]; |
|
61
|
|
|
$countries[] = ['iso' => 'BR', 'ioc' => 'BRA', 'name' => 'Brazil', 'active' => 0]; |
|
62
|
|
|
$countries[] = ['iso' => 'IO', 'ioc' => null, 'name' => 'British Indian Ocean Territory', 'active' => 0]; |
|
63
|
|
|
$countries[] = ['iso' => 'BN', 'ioc' => 'BRU', 'name' => 'Brunei Darussalam', 'active' => 0]; |
|
64
|
|
|
$countries[] = ['iso' => 'BG', 'ioc' => 'BUL', 'name' => 'Bulgaria', 'active' => 0]; |
|
65
|
|
|
$countries[] = ['iso' => 'BF', 'ioc' => 'BUR', 'name' => 'Burkina Faso', 'active' => 0]; |
|
66
|
|
|
$countries[] = ['iso' => 'BI', 'ioc' => 'BDI', 'name' => 'Burundi', 'active' => 0]; |
|
67
|
|
|
$countries[] = ['iso' => 'KH', 'ioc' => 'CAM', 'name' => 'Cambodia', 'active' => 0]; |
|
68
|
|
|
$countries[] = ['iso' => 'CM', 'ioc' => 'CMR', 'name' => 'Cameroon', 'active' => 0]; |
|
69
|
|
|
$countries[] = ['iso' => 'CA', 'ioc' => 'CAN', 'name' => 'Canada', 'active' => 0]; |
|
70
|
|
|
$countries[] = ['iso' => 'CV', 'ioc' => 'CPV', 'name' => 'Cape Verde', 'active' => 0]; |
|
71
|
|
|
$countries[] = ['iso' => 'KY', 'ioc' => 'CAY', 'name' => 'Cayman Islands', 'active' => 0]; |
|
72
|
|
|
$countries[] = ['iso' => 'CF', 'ioc' => 'CAF', 'name' => 'Central African Republic', 'active' => 0]; |
|
73
|
|
|
$countries[] = ['iso' => 'TD', 'ioc' => 'CHA', 'name' => 'Chad', 'active' => 0]; |
|
74
|
|
|
$countries[] = ['iso' => 'CL', 'ioc' => 'CHI', 'name' => 'Chile', 'active' => 0]; |
|
75
|
|
|
$countries[] = ['iso' => 'CN', 'ioc' => 'CNI', 'name' => 'China', 'active' => 0]; |
|
76
|
|
|
$countries[] = ['iso' => 'CX', 'ioc' => null, 'name' => 'Christmas Island', 'active' => 0]; |
|
77
|
|
|
$countries[] = ['iso' => 'CC', 'ioc' => null, 'name' => 'Cocos (Keeling) Islands', 'active' => 0]; |
|
78
|
|
|
$countries[] = ['iso' => 'CO', 'ioc' => 'COL', 'name' => 'Colombia', 'active' => 0]; |
|
79
|
|
|
$countries[] = ['iso' => 'KM', 'ioc' => 'COM', 'name' => 'Comoros', 'active' => 0]; |
|
80
|
|
|
$countries[] = ['iso' => 'CG', 'ioc' => null, 'name' => 'Congo', 'active' => 0]; |
|
81
|
|
|
$countries[] = ['iso' => 'CD', 'ioc' => 'COD', 'name' => 'Congo, The Democratic Republic of the', 'active' => 0]; |
|
82
|
|
|
$countries[] = ['iso' => 'CK', 'ioc' => 'COK', 'name' => 'Cook Islands', 'active' => 0]; |
|
83
|
|
|
$countries[] = ['iso' => 'CR', 'ioc' => 'CRC', 'name' => 'Costa Rica', 'active' => 0]; |
|
84
|
|
|
$countries[] = ['iso' => 'CI', 'ioc' => 'CIV', 'name' => 'Ivory Coast', 'active' => 0]; |
|
85
|
|
|
$countries[] = ['iso' => 'HR', 'ioc' => 'CRO', 'name' => 'Croatia', 'active' => 0]; |
|
86
|
|
|
$countries[] = ['iso' => 'CU', 'ioc' => 'CUB', 'name' => 'Cuba', 'active' => 0]; |
|
87
|
|
|
$countries[] = ['iso' => 'CY', 'ioc' => 'CYP', 'name' => 'Cyprus', 'active' => 0]; |
|
88
|
|
|
$countries[] = ['iso' => 'CZ', 'ioc' => 'CZE', 'name' => 'Czech Republic', 'active' => 0]; |
|
89
|
|
|
$countries[] = ['iso' => 'DK', 'ioc' => 'DEN', 'name' => 'Denmark', 'active' => 0]; |
|
90
|
|
|
$countries[] = ['iso' => 'DJ', 'ioc' => 'DJI', 'name' => 'Djibouti', 'active' => 0]; |
|
91
|
|
|
$countries[] = ['iso' => 'DM', 'ioc' => 'DMA', 'name' => 'Dominica', 'active' => 0]; |
|
92
|
|
|
$countries[] = ['iso' => 'DO', 'ioc' => 'DOM', 'name' => 'Dominican Republic', 'active' => 0]; |
|
93
|
|
|
$countries[] = ['iso' => 'EC', 'ioc' => 'ECU', 'name' => 'Ecuador', 'active' => 0]; |
|
94
|
|
|
$countries[] = ['iso' => 'EG', 'ioc' => 'EGY', 'name' => 'Egypt', 'active' => 0]; |
|
95
|
|
|
$countries[] = ['iso' => 'SV', 'ioc' => 'ESA', 'name' => 'El Salvador', 'active' => 0]; |
|
96
|
|
|
$countries[] = ['iso' => 'GQ', 'ioc' => 'GEQ', 'name' => 'Equatorial Guinea', 'active' => 0]; |
|
97
|
|
|
$countries[] = ['iso' => 'ER', 'ioc' => 'ERI', 'name' => 'Eritrea', 'active' => 0]; |
|
98
|
|
|
$countries[] = ['iso' => 'EE', 'ioc' => 'EST', 'name' => 'Estonia', 'active' => 0]; |
|
99
|
|
|
$countries[] = ['iso' => 'ET', 'ioc' => 'ETH', 'name' => 'Ethiopia', 'active' => 0]; |
|
100
|
|
|
$countries[] = ['iso' => 'FK', 'ioc' => null, 'name' => 'Falkland Islands (Malvinas)', 'active' => 0]; |
|
101
|
|
|
$countries[] = ['iso' => 'FO', 'ioc' => 'FRO', 'name' => 'Faroe Islands', 'active' => 0]; |
|
102
|
|
|
$countries[] = ['iso' => 'FJ', 'ioc' => 'FIJ', 'name' => 'Fiji', 'active' => 0]; |
|
103
|
|
|
$countries[] = ['iso' => 'FI', 'ioc' => 'FIN', 'name' => 'Finland', 'active' => 0]; |
|
104
|
|
|
$countries[] = ['iso' => 'FR', 'ioc' => 'FRA', 'name' => 'France', 'active' => 0]; |
|
105
|
|
|
$countries[] = ['iso' => 'GF', 'ioc' => null, 'name' => 'French Guiana', 'active' => 0]; |
|
106
|
|
|
$countries[] = ['iso' => 'PF', 'ioc' => null, 'name' => 'French Polynesia', 'active' => 0]; |
|
107
|
|
|
$countries[] = ['iso' => 'TF', 'ioc' => null, 'name' => 'French Southern Territories', 'active' => 0]; |
|
108
|
|
|
$countries[] = ['iso' => 'GA', 'ioc' => 'GAB', 'name' => 'Gabon', 'active' => 0]; |
|
109
|
|
|
$countries[] = ['iso' => 'GM', 'ioc' => 'GAM', 'name' => 'Gambia', 'active' => 0]; |
|
110
|
|
|
$countries[] = ['iso' => 'GE', 'ioc' => 'GEO', 'name' => 'Georgia', 'active' => 0]; |
|
111
|
|
|
$countries[] = ['iso' => 'DE', 'ioc' => 'GER', 'name' => 'Germany', 'active' => 1]; |
|
112
|
|
|
$countries[] = ['iso' => 'GH', 'ioc' => 'GHA', 'name' => 'Ghana', 'active' => 0]; |
|
113
|
|
|
$countries[] = ['iso' => 'GI', 'ioc' => null, 'name' => 'Gibraltar', 'active' => 0]; |
|
114
|
|
|
$countries[] = ['iso' => 'GR', 'ioc' => 'GRE', 'name' => 'Greece', 'active' => 0]; |
|
115
|
|
|
$countries[] = ['iso' => 'GL', 'ioc' => null, 'name' => 'Greenland', 'active' => 0]; |
|
116
|
|
|
$countries[] = ['iso' => 'GD', 'ioc' => 'GRN', 'name' => 'Grenada', 'active' => 0]; |
|
117
|
|
|
$countries[] = ['iso' => 'GP', 'ioc' => null, 'name' => 'Guadeloupe', 'active' => 0]; |
|
118
|
|
|
$countries[] = ['iso' => 'GU', 'ioc' => 'GUM', 'name' => 'Guam', 'active' => 0]; |
|
119
|
|
|
$countries[] = ['iso' => 'GT', 'ioc' => 'GUA', 'name' => 'Guatemala', 'active' => 0]; |
|
120
|
|
|
$countries[] = ['iso' => 'GN', 'ioc' => 'GUI', 'name' => 'Guinea', 'active' => 0]; |
|
121
|
|
|
$countries[] = ['iso' => 'GW', 'ioc' => 'GBS', 'name' => 'Guinea-Bissau', 'active' => 0]; |
|
122
|
|
|
$countries[] = ['iso' => 'GY', 'ioc' => 'GUY', 'name' => 'Guyana', 'active' => 0]; |
|
123
|
|
|
$countries[] = ['iso' => 'HT', 'ioc' => 'HAI', 'name' => 'Haiti', 'active' => 0]; |
|
124
|
|
|
$countries[] = ['iso' => 'HM', 'ioc' => null, 'name' => 'Heard Island and McDonald Islands', 'active' => 0]; |
|
125
|
|
|
$countries[] = ['iso' => 'VA', 'ioc' => null, 'name' => 'Holy See (Vatican City State)', 'active' => 0]; |
|
126
|
|
|
$countries[] = ['iso' => 'HN', 'ioc' => 'HON', 'name' => 'Honduras', 'active' => 0]; |
|
127
|
|
|
$countries[] = ['iso' => 'HK', 'ioc' => 'HKG', 'name' => 'Hong Kong', 'active' => 0]; |
|
128
|
|
|
$countries[] = ['iso' => 'HU', 'ioc' => 'HUN', 'name' => 'Hungary', 'active' => 0]; |
|
129
|
|
|
$countries[] = ['iso' => 'IS', 'ioc' => 'ISL', 'name' => 'Iceland', 'active' => 0]; |
|
130
|
|
|
$countries[] = ['iso' => 'IN', 'ioc' => 'IND', 'name' => 'India', 'active' => 0]; |
|
131
|
|
|
$countries[] = ['iso' => 'ID', 'ioc' => 'INA', 'name' => 'Indonesia', 'active' => 0]; |
|
132
|
|
|
$countries[] = ['iso' => 'IR', 'ioc' => 'IRI', 'name' => 'Iran, Islamic Republic of', 'active' => 0]; |
|
133
|
|
|
$countries[] = ['iso' => 'IQ', 'ioc' => 'IRQ', 'name' => 'Iraq', 'active' => 0]; |
|
134
|
|
|
$countries[] = ['iso' => 'IE', 'ioc' => 'IRL', 'name' => 'Ireland', 'active' => 0]; |
|
135
|
|
|
$countries[] = ['iso' => 'IL', 'ioc' => 'ISR', 'name' => 'Isreal', 'active' => 0]; |
|
136
|
|
|
$countries[] = ['iso' => 'IT', 'ioc' => 'ITA', 'name' => 'Italy', 'active' => 0]; |
|
137
|
|
|
$countries[] = ['iso' => 'JM', 'ioc' => 'JAM', 'name' => 'Jamaica', 'active' => 0]; |
|
138
|
|
|
$countries[] = ['iso' => 'JP', 'ioc' => 'JAP', 'name' => 'Japan', 'active' => 0]; |
|
139
|
|
|
$countries[] = ['iso' => 'JO', 'ioc' => 'JOR', 'name' => 'Jordan', 'active' => 0]; |
|
140
|
|
|
$countries[] = ['iso' => 'KZ', 'ioc' => 'KAZ', 'name' => 'Kazakhstan', 'active' => 0]; |
|
141
|
|
|
$countries[] = ['iso' => 'KE', 'ioc' => 'KEN', 'name' => 'Kenya', 'active' => 0]; |
|
142
|
|
|
$countries[] = ['iso' => 'KI', 'ioc' => 'KIR', 'name' => 'Kiribati', 'active' => 0]; |
|
143
|
|
|
$countries[] = ['iso' => 'KP', 'ioc' => 'PRK', 'name' => 'Korea, Democratic People\'s Republic of', 'active' => 0]; |
|
144
|
|
|
$countries[] = ['iso' => 'KR', 'ioc' => 'KOR', 'name' => 'Korea, Republic of', 'active' => 0]; |
|
145
|
|
|
$countries[] = ['iso' => 'KW', 'ioc' => 'KUW', 'name' => 'Kuwait', 'active' => 0]; |
|
146
|
|
|
$countries[] = ['iso' => 'KG', 'ioc' => 'KGZ', 'name' => 'Kyrgyzstan', 'active' => 0]; |
|
147
|
|
|
$countries[] = ['iso' => 'LA', 'ioc' => null, 'name' => 'Lao People\'s Democratic Republic', 'active' => 0]; |
|
148
|
|
|
$countries[] = ['iso' => 'LV', 'ioc' => 'LAT', 'name' => 'Latvia', 'active' => 0]; |
|
149
|
|
|
$countries[] = ['iso' => 'LB', 'ioc' => 'LBN', 'name' => 'Lebanon', 'active' => 0]; |
|
150
|
|
|
$countries[] = ['iso' => 'LS', 'ioc' => 'LES', 'name' => 'Lesotho', 'active' => 0]; |
|
151
|
|
|
$countries[] = ['iso' => 'LR', 'ioc' => 'LBR', 'name' => 'Liberia', 'active' => 0]; |
|
152
|
|
|
$countries[] = ['iso' => 'LY', 'ioc' => 'LBA', 'name' => 'Libya', 'active' => 0]; |
|
153
|
|
|
$countries[] = ['iso' => 'LI', 'ioc' => 'LIE', 'name' => 'Liechtenstein', 'active' => 0]; |
|
154
|
|
|
$countries[] = ['iso' => 'LT', 'ioc' => 'LTU', 'name' => 'Lithuania', 'active' => 0]; |
|
155
|
|
|
$countries[] = ['iso' => 'LU', 'ioc' => 'LUX', 'name' => 'Luxembourg', 'active' => 0]; |
|
156
|
|
|
$countries[] = ['iso' => 'MO', 'ioc' => 'MAC', 'name' => 'Macao', 'active' => 0]; |
|
157
|
|
|
$countries[] = ['iso' => 'MG', 'ioc' => 'MAD', 'name' => 'Madagascar', 'active' => 0]; |
|
158
|
|
|
$countries[] = ['iso' => 'MW', 'ioc' => 'MAW', 'name' => 'Malawi', 'active' => 0]; |
|
159
|
|
|
$countries[] = ['iso' => 'MY', 'ioc' => 'MAL', 'name' => 'Malaysia', 'active' => 0]; |
|
160
|
|
|
$countries[] = ['iso' => 'MV', 'ioc' => 'MDV', 'name' => 'Maldives', 'active' => 0]; |
|
161
|
|
|
$countries[] = ['iso' => 'ML', 'ioc' => 'MLI', 'name' => 'Mali', 'active' => 0]; |
|
162
|
|
|
$countries[] = ['iso' => 'MT', 'ioc' => 'MLT', 'name' => 'Malta', 'active' => 0]; |
|
163
|
|
|
$countries[] = ['iso' => 'MH', 'ioc' => 'MHL', 'name' => 'Marshall Islands', 'active' => 0]; |
|
164
|
|
|
$countries[] = ['iso' => 'MQ', 'ioc' => null, 'name' => 'Martinique', 'active' => 0]; |
|
165
|
|
|
$countries[] = ['iso' => 'MR', 'ioc' => 'MTN', 'name' => 'Mauritania', 'active' => 0]; |
|
166
|
|
|
$countries[] = ['iso' => 'MU', 'ioc' => 'MRI', 'name' => 'Mauritius', 'active' => 0]; |
|
167
|
|
|
$countries[] = ['iso' => 'YT', 'ioc' => null, 'name' => 'Mayotte', 'active' => 0]; |
|
168
|
|
|
$countries[] = ['iso' => 'MX', 'ioc' => 'MEX', 'name' => 'Mexico', 'active' => 0]; |
|
169
|
|
|
$countries[] = ['iso' => 'FM', 'ioc' => null, 'name' => 'Micronesia, Federated States of', 'active' => 0]; |
|
170
|
|
|
$countries[] = ['iso' => 'MD', 'ioc' => 'MDA', 'name' => 'Moldova, Republic of', 'active' => 0]; |
|
171
|
|
|
$countries[] = ['iso' => 'MC', 'ioc' => 'MON', 'name' => 'Monaco', 'active' => 0]; |
|
172
|
|
|
$countries[] = ['iso' => 'MN', 'ioc' => 'MGL', 'name' => 'Mongolia', 'active' => 0]; |
|
173
|
|
|
$countries[] = ['iso' => 'MS', 'ioc' => null, 'name' => 'Montserrat', 'active' => 0]; |
|
174
|
|
|
$countries[] = ['iso' => 'MA', 'ioc' => 'MAR', 'name' => 'Morocco', 'active' => 0]; |
|
175
|
|
|
$countries[] = ['iso' => 'MZ', 'ioc' => 'MOZ', 'name' => 'Mozambique', 'active' => 0]; |
|
176
|
|
|
$countries[] = ['iso' => 'MM', 'ioc' => 'MYA', 'name' => 'Myanmar', 'active' => 0]; |
|
177
|
|
|
$countries[] = ['iso' => 'NA', 'ioc' => 'NAM', 'name' => 'Namibia', 'active' => 0]; |
|
178
|
|
|
$countries[] = ['iso' => 'NR', 'ioc' => 'NRU', 'name' => 'Nauru', 'active' => 0]; |
|
179
|
|
|
$countries[] = ['iso' => 'NP', 'ioc' => 'NEP', 'name' => 'Nepal', 'active' => 0]; |
|
180
|
|
|
$countries[] = ['iso' => 'NL', 'ioc' => 'NED', 'name' => 'Netherlands', 'active' => 0]; |
|
181
|
|
|
$countries[] = ['iso' => 'AN', 'ioc' => 'AHO', 'name' => 'Netherlands Antilles', 'active' => 0]; |
|
182
|
|
|
$countries[] = ['iso' => 'NC', 'ioc' => null, 'name' => 'New Caledonia', 'active' => 0]; |
|
183
|
|
|
$countries[] = ['iso' => 'NZ', 'ioc' => 'NZL', 'name' => 'New Zealand', 'active' => 0]; |
|
184
|
|
|
$countries[] = ['iso' => 'NI', 'ioc' => 'NCA', 'name' => 'Nicaragua', 'active' => 0]; |
|
185
|
|
|
$countries[] = ['iso' => 'NE', 'ioc' => 'NIG', 'name' => 'Niger', 'active' => 0]; |
|
186
|
|
|
$countries[] = ['iso' => 'NG', 'ioc' => 'NGR', 'name' => 'Nigeria', 'active' => 0]; |
|
187
|
|
|
$countries[] = ['iso' => 'NU', 'ioc' => null, 'name' => 'Niue', 'active' => 0]; |
|
188
|
|
|
$countries[] = ['iso' => 'NF', 'ioc' => null, 'name' => 'Norfolk Island', 'active' => 0]; |
|
189
|
|
|
$countries[] = ['iso' => 'MK', 'ioc' => 'MKD', 'name' => 'North Macedonia', 'active' => 0]; |
|
190
|
|
|
$countries[] = ['iso' => 'MP', 'ioc' => null, 'name' => 'Northern Mariana Islands', 'active' => 0]; |
|
191
|
|
|
$countries[] = ['iso' => 'NO', 'ioc' => 'NOR', 'name' => 'Norway', 'active' => 0]; |
|
192
|
|
|
$countries[] = ['iso' => 'OM', 'ioc' => 'OMA', 'name' => 'Oman', 'active' => 0]; |
|
193
|
|
|
$countries[] = ['iso' => 'PK', 'ioc' => 'PAK', 'name' => 'Pakistan', 'active' => 0]; |
|
194
|
|
|
$countries[] = ['iso' => 'PW', 'ioc' => 'PLW', 'name' => 'Palau', 'active' => 0]; |
|
195
|
|
|
$countries[] = ['iso' => 'PS', 'ioc' => null, 'name' => 'Palestinian Territory, Occupied', 'active' => 0]; |
|
196
|
|
|
$countries[] = ['iso' => 'PA', 'ioc' => 'PAN', 'name' => 'Panama', 'active' => 0]; |
|
197
|
|
|
$countries[] = ['iso' => 'PG', 'ioc' => 'PNG', 'name' => 'Papua New Guinea', 'active' => 0]; |
|
198
|
|
|
$countries[] = ['iso' => 'PY', 'ioc' => 'PAR', 'name' => 'Paraguay', 'active' => 0]; |
|
199
|
|
|
$countries[] = ['iso' => 'PE', 'ioc' => 'PER', 'name' => 'Peru', 'active' => 0]; |
|
200
|
|
|
$countries[] = ['iso' => 'PH', 'ioc' => 'PHI', 'name' => 'Philippines', 'active' => 0]; |
|
201
|
|
|
$countries[] = ['iso' => 'PN', 'ioc' => null, 'name' => 'Pitcairn Islands', 'active' => 0]; |
|
202
|
|
|
$countries[] = ['iso' => 'PL', 'ioc' => 'POL', 'name' => 'Poland', 'active' => 0]; |
|
203
|
|
|
$countries[] = ['iso' => 'PT', 'ioc' => 'POR', 'name' => 'Portugal', 'active' => 0]; |
|
204
|
|
|
$countries[] = ['iso' => 'PR', 'ioc' => 'PUR', 'name' => 'Puerto Rico', 'active' => 0]; |
|
205
|
|
|
$countries[] = ['iso' => 'QA', 'ioc' => 'QAT', 'name' => 'Qatar', 'active' => 0]; |
|
206
|
|
|
$countries[] = ['iso' => 'RE', 'ioc' => null, 'name' => 'Reunion', 'active' => 0]; |
|
207
|
|
|
$countries[] = ['iso' => 'RO', 'ioc' => 'ROU', 'name' => 'Romania', 'active' => 0]; |
|
208
|
|
|
$countries[] = ['iso' => 'RU', 'ioc' => 'RUS', 'name' => 'Russia', 'active' => 0]; |
|
209
|
|
|
$countries[] = ['iso' => 'RW', 'ioc' => 'RWA', 'name' => 'Rwanda', 'active' => 0]; |
|
210
|
|
|
$countries[] = ['iso' => 'SH', 'ioc' => null, 'name' => 'Saint Helena', 'active' => 0]; |
|
211
|
|
|
$countries[] = ['iso' => 'KN', 'ioc' => 'SKN', 'name' => 'Saint Kitts and Nevis', 'active' => 0]; |
|
212
|
|
|
$countries[] = ['iso' => 'LC', 'ioc' => 'LCA', 'name' => 'Saint Lucia', 'active' => 0]; |
|
213
|
|
|
$countries[] = ['iso' => 'PM', 'ioc' => null, 'name' => 'Saint Pierre and Miquelon', 'active' => 0]; |
|
214
|
|
|
$countries[] = ['iso' => 'VC', 'ioc' => 'VIN', 'name' => 'Saint Vincent and the Grenadines', 'active' => 0]; |
|
215
|
|
|
$countries[] = ['iso' => 'WS', 'ioc' => 'SAM', 'name' => 'Samoa', 'active' => 0]; |
|
216
|
|
|
$countries[] = ['iso' => 'SM', 'ioc' => 'SMR', 'name' => 'San Marino', 'active' => 0]; |
|
217
|
|
|
$countries[] = ['iso' => 'ST', 'ioc' => null, 'name' => 'Sao Tome and Principe', 'active' => 0]; |
|
218
|
|
|
$countries[] = ['iso' => 'SA', 'ioc' => 'KSA', 'name' => 'Saudia Arabia', 'active' => 0]; |
|
219
|
|
|
$countries[] = ['iso' => 'SN', 'ioc' => 'SEN', 'name' => 'Senegal', 'active' => 0]; |
|
220
|
|
|
$countries[] = ['iso' => 'RS', 'ioc' => 'SRB', 'name' => 'Serbia', 'active' => 0]; |
|
221
|
|
|
$countries[] = ['iso' => 'SC', 'ioc' => 'SEY', 'name' => 'Seychelles', 'active' => 0]; |
|
222
|
|
|
$countries[] = ['iso' => 'SL', 'ioc' => 'SLE', 'name' => 'Sierra Leone', 'active' => 0]; |
|
223
|
|
|
$countries[] = ['iso' => 'SG', 'ioc' => 'SGP', 'name' => 'Singapore', 'active' => 0]; |
|
224
|
|
|
$countries[] = ['iso' => 'SK', 'ioc' => 'SVK', 'name' => 'Slovakia', 'active' => 0]; |
|
225
|
|
|
$countries[] = ['iso' => 'SI', 'ioc' => 'SLO', 'name' => 'Slovenia', 'active' => 0]; |
|
226
|
|
|
$countries[] = ['iso' => 'SB', 'ioc' => 'SOL', 'name' => 'Solomon Islands', 'active' => 0]; |
|
227
|
|
|
$countries[] = ['iso' => 'SO', 'ioc' => 'SOM', 'name' => 'Somalia', 'active' => 0]; |
|
228
|
|
|
$countries[] = ['iso' => 'ZA', 'ioc' => 'RSA', 'name' => 'South Africa', 'active' => 0]; |
|
229
|
|
|
$countries[] = ['iso' => 'GS', 'ioc' => null, 'name' => 'South Georgia and the South Sandwich Islands', 'active' => 0]; |
|
230
|
|
|
$countries[] = ['iso' => 'ES', 'ioc' => 'ESP', 'name' => 'Spain', 'active' => 0]; |
|
231
|
|
|
$countries[] = ['iso' => 'LK', 'ioc' => 'SRI', 'name' => 'Sri Lanka', 'active' => 0]; |
|
232
|
|
|
$countries[] = ['iso' => 'SD', 'ioc' => 'SUD', 'name' => 'Sudan', 'active' => 0]; |
|
233
|
|
|
$countries[] = ['iso' => 'SR', 'ioc' => 'SUR', 'name' => 'Surinam', 'active' => 0]; |
|
234
|
|
|
$countries[] = ['iso' => 'SJ', 'ioc' => null, 'name' => 'Svalbard and Jan Mayen', 'active' => 0]; |
|
235
|
|
|
$countries[] = ['iso' => 'SZ', 'ioc' => 'SWZ', 'name' => 'Swaziland', 'active' => 0]; |
|
236
|
|
|
$countries[] = ['iso' => 'SE', 'ioc' => 'SWE', 'name' => 'Sweden', 'active' => 0]; |
|
237
|
|
|
$countries[] = ['iso' => 'CH', 'ioc' => 'SUI', 'name' => 'Switzerland', 'active' => 0]; |
|
238
|
|
|
$countries[] = ['iso' => 'SY', 'ioc' => 'SYR', 'name' => 'Syria', 'active' => 0]; |
|
239
|
|
|
$countries[] = ['iso' => 'TW', 'ioc' => 'TPE', 'name' => 'Taiwan, Province of China', 'active' => 0]; |
|
240
|
|
|
$countries[] = ['iso' => 'TJ', 'ioc' => 'TJK', 'name' => 'Tajikistan', 'active' => 0]; |
|
241
|
|
|
$countries[] = ['iso' => 'TZ', 'ioc' => 'TAN', 'name' => 'Tanzania, United Republic of', 'active' => 0]; |
|
242
|
|
|
$countries[] = ['iso' => 'TH', 'ioc' => 'THA', 'name' => 'Thailand', 'active' => 0]; |
|
243
|
|
|
$countries[] = ['iso' => 'TL', 'ioc' => 'TLS', 'name' => 'East Timor', 'active' => 0]; |
|
244
|
|
|
$countries[] = ['iso' => 'TG', 'ioc' => 'TOG', 'name' => 'Togo', 'active' => 0]; |
|
245
|
|
|
$countries[] = ['iso' => 'TK', 'ioc' => null, 'name' => 'Tokelau', 'active' => 0]; |
|
246
|
|
|
$countries[] = ['iso' => 'TO', 'ioc' => 'TGA', 'name' => 'Tonga', 'active' => 0]; |
|
247
|
|
|
$countries[] = ['iso' => 'TT', 'ioc' => 'TTO', 'name' => 'Trinidad and Tobago', 'active' => 0]; |
|
248
|
|
|
$countries[] = ['iso' => 'TN', 'ioc' => 'TUN', 'name' => 'Tunesia', 'active' => 0]; |
|
249
|
|
|
$countries[] = ['iso' => 'TR', 'ioc' => 'TUR', 'name' => 'Turkey', 'active' => 0]; |
|
250
|
|
|
$countries[] = ['iso' => 'TM', 'ioc' => 'TKM', 'name' => 'Turkmenistan', 'active' => 0]; |
|
251
|
|
|
$countries[] = ['iso' => 'TC', 'ioc' => null, 'name' => 'Turks and Caicos Islands', 'active' => 0]; |
|
252
|
|
|
$countries[] = ['iso' => 'TV', 'ioc' => 'TUV', 'name' => 'Tuvalu', 'active' => 0]; |
|
253
|
|
|
$countries[] = ['iso' => 'UG', 'ioc' => 'UGA', 'name' => 'Uganda', 'active' => 0]; |
|
254
|
|
|
$countries[] = ['iso' => 'UA', 'ioc' => 'UKR', 'name' => 'Ukraine', 'active' => 0]; |
|
255
|
|
|
$countries[] = ['iso' => 'AE', 'ioc' => 'UAE', 'name' => 'United Arab Emirates', 'active' => 0]; |
|
256
|
|
|
$countries[] = ['iso' => 'GB', 'ioc' => 'GBR', 'name' => 'United Kingdom', 'active' => 0]; |
|
257
|
|
|
$countries[] = ['iso' => 'US', 'ioc' => 'USA', 'name' => 'United States', 'active' => 0]; |
|
258
|
|
|
$countries[] = ['iso' => 'UM', 'ioc' => null, 'name' => 'United States Minor Outlying Islands', 'active' => 0]; |
|
259
|
|
|
$countries[] = ['iso' => 'UY', 'ioc' => 'URU', 'name' => 'Uruguay', 'active' => 0]; |
|
260
|
|
|
$countries[] = ['iso' => 'UZ', 'ioc' => 'UZB', 'name' => 'Uzbekistan', 'active' => 0]; |
|
261
|
|
|
$countries[] = ['iso' => 'VU', 'ioc' => 'VAN', 'name' => 'Vanuatu', 'active' => 0]; |
|
262
|
|
|
$countries[] = ['iso' => 'VE', 'ioc' => 'VEN', 'name' => 'Venezuela', 'active' => 0]; |
|
263
|
|
|
$countries[] = ['iso' => 'VN', 'ioc' => 'VIE', 'name' => 'Vietnam', 'active' => 0]; |
|
264
|
|
|
$countries[] = ['iso' => 'VG', 'ioc' => 'IVB', 'name' => 'Virgin Islands, British', 'active' => 0]; |
|
265
|
|
|
$countries[] = ['iso' => 'VI', 'ioc' => 'ISV', 'name' => 'Virgin Islands, U.S.', 'active' => 0]; |
|
266
|
|
|
$countries[] = ['iso' => 'WF', 'ioc' => null, 'name' => 'Wallis and Futuna', 'active' => 0]; |
|
267
|
|
|
$countries[] = ['iso' => 'EH', 'ioc' => null, 'name' => 'Western Sahara', 'active' => 0]; |
|
268
|
|
|
$countries[] = ['iso' => 'YE', 'ioc' => 'YEM', 'name' => 'Yemen', 'active' => 0]; |
|
269
|
|
|
$countries[] = ['iso' => 'ZM', 'ioc' => 'ZAM', 'name' => 'Zambia', 'active' => 0]; |
|
270
|
|
|
$countries[] = ['iso' => 'ZW', 'ioc' => 'ZIM', 'name' => 'Zimbabwe', 'active' => 0]; |
|
271
|
|
|
|
|
272
|
|
|
foreach ($countries as $id => $country) { |
|
273
|
|
|
$countries[$id] = array_merge($country, ['created_at' => $createdAt, 'updated_at' => $createdAt]); |
|
274
|
|
|
} |
|
275
|
|
|
|
|
276
|
|
|
$tableNames = config('pwweb.localisation.table_names'); |
|
277
|
|
|
|
|
278
|
|
|
$chunks = array_chunk($countries, 20); |
|
279
|
|
|
|
|
280
|
|
|
foreach ($chunks as $chunk) { |
|
281
|
|
|
DB::table($tableNames['countries'])->insert($chunk); |
|
282
|
|
|
} |
|
283
|
|
|
} |
|
284
|
|
|
} |
|
285
|
|
|
|
pwweb /
localisation
