|
1
|
|
|
<?php |
|
2
|
|
|
|
|
3
|
|
|
use Illuminate\Database\Seeder; |
|
4
|
|
|
use Illuminate\Support\Facades\DB; |
|
5
|
|
|
|
|
6
|
|
|
/* |
|
7
|
|
|
|-------------------------------------------------------------------------- |
|
8
|
|
|
| Seeders |
|
9
|
|
|
|-------------------------------------------------------------------------- |
|
10
|
|
|
| |
|
11
|
|
|
| Seders are used to generate datas to populate the database of the test environment. |
|
12
|
|
|
| |
|
13
|
|
|
*/ |
|
14
|
|
|
|
|
15
|
|
|
class CountriesTableSeeder extends Seeder |
|
16
|
|
|
{ |
|
17
|
|
|
/** |
|
18
|
|
|
* Run the database seeds. |
|
19
|
|
|
* |
|
20
|
|
|
* @return void |
|
21
|
|
|
*/ |
|
22
|
|
|
public function run() |
|
23
|
|
|
{ |
|
24
|
|
|
$countries = [ |
|
25
|
|
|
['id' => '1', 'name' => 'Italy', 'continent_id' => '6', 'code' => 'IT'], |
|
26
|
|
|
['id' => '2', 'name' => 'United States', 'continent_id' => '3', 'code' => 'US'], |
|
27
|
|
|
['id' => '3', 'name' => 'Algeria', 'continent_id' => '1', 'code' => 'DZ'], |
|
28
|
|
|
['id' => '4', 'name' => 'Wallis and Futuna', 'continent_id' => '4', 'code' => 'WF'], |
|
29
|
|
|
['id' => '5', 'name' => 'Angola', 'continent_id' => '1', 'code' => 'AO'], |
|
30
|
|
|
['id' => '6', 'name' => 'Benin', 'continent_id' => '1', 'code' => 'BJ'], |
|
31
|
|
|
['id' => '7', 'name' => 'Botswana', 'continent_id' => '1', 'code' => 'BW'], |
|
32
|
|
|
['id' => '8', 'name' => 'Burkina Faso', 'continent_id' => '1', 'code' => 'BF'], |
|
33
|
|
|
['id' => '9', 'name' => 'Burundi', 'continent_id' => '1', 'code' => 'BI'], |
|
34
|
|
|
['id' => '10', 'name' => 'Cameroon', 'continent_id' => '1', 'code' => 'CM'], |
|
35
|
|
|
['id' => '11', 'name' => 'Cape Verde', 'continent_id' => '1', 'code' => 'CV'], |
|
36
|
|
|
['id' => '12', 'name' => 'Central African Republic', 'continent_id' => '1', 'code' => 'CF'], |
|
37
|
|
|
['id' => '13', 'name' => 'Chad', 'continent_id' => '1', 'code' => 'TD'], |
|
38
|
|
|
['id' => '14', 'name' => 'Comoros', 'continent_id' => '1', 'code' => 'KM'], |
|
39
|
|
|
['id' => '15', 'name' => 'Congo - Brazzaville', 'continent_id' => '1', 'code' => 'CG'], |
|
40
|
|
|
['id' => '16', 'name' => 'Congo - Kinshasa', 'continent_id' => '1', 'code' => 'CD'], |
|
41
|
|
|
['id' => '17', 'name' => 'Cote d\'Ivoire', 'continent_id' => '1', 'code' => 'CI'], |
|
42
|
|
|
['id' => '18', 'name' => 'Djibouti', 'continent_id' => '1', 'code' => 'DJ'], |
|
43
|
|
|
['id' => '19', 'name' => 'Egypt', 'continent_id' => '1', 'code' => 'EG'], |
|
44
|
|
|
['id' => '20', 'name' => 'Equatorial Guinea', 'continent_id' => '1', 'code' => 'GQ'], |
|
45
|
|
|
['id' => '21', 'name' => 'Eritrea', 'continent_id' => '1', 'code' => 'ER'], |
|
46
|
|
|
['id' => '22', 'name' => 'Ethiopia', 'continent_id' => '1', 'code' => 'ET'], |
|
47
|
|
|
['id' => '23', 'name' => 'Gabon', 'continent_id' => '1', 'code' => 'GA'], |
|
48
|
|
|
['id' => '24', 'name' => 'Gambia', 'continent_id' => '1', 'code' => 'GM'], |
|
49
|
|
|
['id' => '25', 'name' => 'Ghana', 'continent_id' => '1', 'code' => 'GH'], |
|
50
|
|
|
['id' => '26', 'name' => 'Guinea', 'continent_id' => '1', 'code' => 'GN'], |
|
51
|
|
|
['id' => '27', 'name' => 'Guinea Bissau', 'continent_id' => '1', 'code' => 'GW'], |
|
52
|
|
|
['id' => '28', 'name' => 'Kenya', 'continent_id' => '1', 'code' => 'KE'], |
|
53
|
|
|
['id' => '29', 'name' => 'Lesotho', 'continent_id' => '1', 'code' => 'LS'], |
|
54
|
|
|
['id' => '30', 'name' => 'Liberia', 'continent_id' => '1', 'code' => 'LR'], |
|
55
|
|
|
['id' => '31', 'name' => 'Libya', 'continent_id' => '1', 'code' => 'LY'], |
|
56
|
|
|
['id' => '32', 'name' => 'Madagascar', 'continent_id' => '1', 'code' => 'MG'], |
|
57
|
|
|
['id' => '33', 'name' => 'Malawi', 'continent_id' => '1', 'code' => 'MW'], |
|
58
|
|
|
['id' => '34', 'name' => 'Mali', 'continent_id' => '1', 'code' => 'ML'], |
|
59
|
|
|
['id' => '35', 'name' => 'Mauritania', 'continent_id' => '1', 'code' => 'MR'], |
|
60
|
|
|
['id' => '36', 'name' => 'Mauritius', 'continent_id' => '1', 'code' => 'MU'], |
|
61
|
|
|
['id' => '37', 'name' => 'Mayotte', 'continent_id' => '1', 'code' => 'YT'], |
|
62
|
|
|
['id' => '38', 'name' => 'Morocco', 'continent_id' => '1', 'code' => 'MA'], |
|
63
|
|
|
['id' => '39', 'name' => 'Mozambique', 'continent_id' => '1', 'code' => 'MZ'], |
|
64
|
|
|
['id' => '40', 'name' => 'Namibia', 'continent_id' => '1', 'code' => 'NA'], |
|
65
|
|
|
['id' => '41', 'name' => 'Niger', 'continent_id' => '1', 'code' => 'NE'], |
|
66
|
|
|
['id' => '42', 'name' => 'Vanuatu', 'continent_id' => '4', 'code' => 'VU'], |
|
67
|
|
|
['id' => '43', 'name' => 'Rwanda', 'continent_id' => '1', 'code' => 'RW'], |
|
68
|
|
|
['id' => '44', 'name' => 'Reunion', 'continent_id' => '1', 'code' => 'RE'], |
|
69
|
|
|
['id' => '45', 'name' => 'Saint Helena', 'continent_id' => '1', 'code' => 'SH'], |
|
70
|
|
|
['id' => '46', 'name' => 'Senegal', 'continent_id' => '1', 'code' => 'SN'], |
|
71
|
|
|
['id' => '47', 'name' => 'Seychelles', 'continent_id' => '1', 'code' => 'SC'], |
|
72
|
|
|
['id' => '48', 'name' => 'Sierra Leone', 'continent_id' => '1', 'code' => 'SL'], |
|
73
|
|
|
['id' => '49', 'name' => 'Somalia', 'continent_id' => '1', 'code' => 'SO'], |
|
74
|
|
|
['id' => '50', 'name' => 'South Africa', 'continent_id' => '1', 'code' => 'ZA'], |
|
75
|
|
|
['id' => '51', 'name' => 'Sudan', 'continent_id' => '1', 'code' => 'SD'], |
|
76
|
|
|
['id' => '52', 'name' => 'Swaziland', 'continent_id' => '1', 'code' => 'SZ'], |
|
77
|
|
|
['id' => '53', 'name' => 'Sao Tome and Príncipe', 'continent_id' => '1', 'code' => 'ST'], |
|
78
|
|
|
['id' => '54', 'name' => 'Tanzania', 'continent_id' => '1', 'code' => 'TZ'], |
|
79
|
|
|
['id' => '55', 'name' => 'Togo', 'continent_id' => '1', 'code' => 'TG'], |
|
80
|
|
|
['id' => '56', 'name' => 'Tunisia', 'continent_id' => '1', 'code' => 'TN'], |
|
81
|
|
|
['id' => '57', 'name' => 'Uganda', 'continent_id' => '1', 'code' => 'UG'], |
|
82
|
|
|
['id' => '58', 'name' => 'U.S. Minor Outlying Islands', 'continent_id' => '4', 'code' => 'UM'], |
|
83
|
|
|
['id' => '59', 'name' => 'Tuvalu', 'continent_id' => '4', 'code' => 'TV'], |
|
84
|
|
|
['id' => '60', 'name' => 'Western Sahara', 'continent_id' => '1', 'code' => 'EH'], |
|
85
|
|
|
['id' => '61', 'name' => 'Zambia', 'continent_id' => '1', 'code' => 'ZM'], |
|
86
|
|
|
['id' => '62', 'name' => 'Zimbabwe', 'continent_id' => '1', 'code' => 'ZW'], |
|
87
|
|
|
['id' => '63', 'name' => 'Anguilla', 'continent_id' => '3', 'code' => 'AI'], |
|
88
|
|
|
['id' => '64', 'name' => 'Antigua and Barbuda', 'continent_id' => '3', 'code' => 'AG'], |
|
89
|
|
|
['id' => '65', 'name' => 'Argentina', 'continent_id' => '7', 'code' => 'AR'], |
|
90
|
|
|
['id' => '66', 'name' => 'Aruba', 'continent_id' => '7', 'code' => 'AW'], |
|
91
|
|
|
['id' => '67', 'name' => 'Bahamas', 'continent_id' => '3', 'code' => 'BS'], |
|
92
|
|
|
['id' => '68', 'name' => 'Barbados', 'continent_id' => '7', 'code' => 'BB'], |
|
93
|
|
|
['id' => '69', 'name' => 'Belize', 'continent_id' => '3', 'code' => 'BZ'], |
|
94
|
|
|
['id' => '70', 'name' => 'Bermuda', 'continent_id' => '3', 'code' => 'BM'], |
|
95
|
|
|
['id' => '71', 'name' => 'Bolivia', 'continent_id' => '7', 'code' => 'BO'], |
|
96
|
|
|
['id' => '72', 'name' => 'Brazil', 'continent_id' => '7', 'code' => 'BR'], |
|
97
|
|
|
['id' => '73', 'name' => 'British Virgin Islands', 'continent_id' => '3', 'code' => 'VG'], |
|
98
|
|
|
['id' => '74', 'name' => 'Canada', 'continent_id' => '3', 'code' => 'CA'], |
|
99
|
|
|
['id' => '75', 'name' => 'Cayman Islands', 'continent_id' => '3', 'code' => 'KY'], |
|
100
|
|
|
['id' => '76', 'name' => 'Chile', 'continent_id' => '7', 'code' => 'CL'], |
|
101
|
|
|
['id' => '77', 'name' => 'Colombia', 'continent_id' => '7', 'code' => 'CO'], |
|
102
|
|
|
['id' => '78', 'name' => 'Costa Rica', 'continent_id' => '3', 'code' => 'CR'], |
|
103
|
|
|
['id' => '79', 'name' => 'Cuba', 'continent_id' => '3', 'code' => 'CU'], |
|
104
|
|
|
['id' => '80', 'name' => 'Dominica', 'continent_id' => '3', 'code' => 'DM'], |
|
105
|
|
|
['id' => '81', 'name' => 'Dominican Republic', 'continent_id' => '3', 'code' => 'DO'], |
|
106
|
|
|
['id' => '82', 'name' => 'Ecuador', 'continent_id' => '7', 'code' => 'EC'], |
|
107
|
|
|
['id' => '83', 'name' => 'El Salvador', 'continent_id' => '3', 'code' => 'SV'], |
|
108
|
|
|
['id' => '84', 'name' => 'Falkland Islands', 'continent_id' => '7', 'code' => 'FK'], |
|
109
|
|
|
['id' => '85', 'name' => 'French Guiana', 'continent_id' => '7', 'code' => 'GF'], |
|
110
|
|
|
['id' => '86', 'name' => 'Greenland', 'continent_id' => '3', 'code' => 'GL'], |
|
111
|
|
|
['id' => '87', 'name' => 'Grenada', 'continent_id' => '3', 'code' => 'GD'], |
|
112
|
|
|
['id' => '88', 'name' => 'Guadeloupe', 'continent_id' => '3', 'code' => 'GP'], |
|
113
|
|
|
['id' => '89', 'name' => 'Guatemala', 'continent_id' => '3', 'code' => 'GT'], |
|
114
|
|
|
['id' => '90', 'name' => 'Guyana', 'continent_id' => '7', 'code' => 'GY'], |
|
115
|
|
|
['id' => '91', 'name' => 'Haiti', 'continent_id' => '3', 'code' => 'HT'], |
|
116
|
|
|
['id' => '92', 'name' => 'Honduras', 'continent_id' => '3', 'code' => 'HN'], |
|
117
|
|
|
['id' => '93', 'name' => 'Jamaica', 'continent_id' => '3', 'code' => 'JM'], |
|
118
|
|
|
['id' => '94', 'name' => 'Martinique', 'continent_id' => '3', 'code' => 'MQ'], |
|
119
|
|
|
['id' => '95', 'name' => 'Mexico', 'continent_id' => '7', 'code' => 'MX'], |
|
120
|
|
|
['id' => '96', 'name' => 'Montserrat', 'continent_id' => '3', 'code' => 'MS'], |
|
121
|
|
|
['id' => '97', 'name' => 'Netherlands Antilles', 'continent_id' => '7', 'code' => 'AN'], |
|
122
|
|
|
['id' => '98', 'name' => 'Nicaragua', 'continent_id' => '3', 'code' => 'NI'], |
|
123
|
|
|
['id' => '99', 'name' => 'Panama', 'continent_id' => '3', 'code' => 'PA'], |
|
124
|
|
|
['id' => '100', 'name' => 'Paraguay', 'continent_id' => '7', 'code' => 'PY'], |
|
125
|
|
|
['id' => '101', 'name' => 'Peru', 'continent_id' => '7', 'code' => 'PE'], |
|
126
|
|
|
['id' => '102', 'name' => 'Puerto Rico', 'continent_id' => '3', 'code' => 'PR'], |
|
127
|
|
|
['id' => '103', 'name' => 'Saint Barthelemy', 'continent_id' => '3', 'code' => 'BL'], |
|
128
|
|
|
['id' => '104', 'name' => 'Saint Kitts and Nevis', 'continent_id' => '3', 'code' => 'KL'], |
|
129
|
|
|
['id' => '105', 'name' => 'Saint Lucia', 'continent_id' => '3', 'code' => 'LC'], |
|
130
|
|
|
['id' => '106', 'name' => 'Saint Martin', 'continent_id' => '3', 'code' => 'MF'], |
|
131
|
|
|
['id' => '107', 'name' => 'Saint Pierre and Miquelon', 'continent_id' => '3', 'code' => 'PM'], |
|
132
|
|
|
['id' => '108', 'name' => 'Saint Vincent and the Grenadines', 'continent_id' => '3', 'code' => 'VC'], |
|
133
|
|
|
['id' => '109', 'name' => 'Suriname', 'continent_id' => '7', 'code' => 'SR'], |
|
134
|
|
|
['id' => '110', 'name' => 'Trinidad and Tobago', 'continent_id' => '7', 'code' => 'TT'], |
|
135
|
|
|
['id' => '111', 'name' => 'Turks and Caicos Islands', 'continent_id' => '3', 'code' => 'TC'], |
|
136
|
|
|
['id' => '112', 'name' => 'U.S. Virgin Islands', 'continent_id' => '3', 'code' => 'VI'], |
|
137
|
|
|
['id' => '113', 'name' => 'Tonga', 'continent_id' => '4', 'code' => 'TO'], |
|
138
|
|
|
['id' => '114', 'name' => 'Uruguay', 'continent_id' => '7', 'code' => 'UY'], |
|
139
|
|
|
['id' => '115', 'name' => 'Venezuela', 'continent_id' => '7', 'code' => 'VE'], |
|
140
|
|
|
['id' => '116', 'name' => 'Tokelau', 'continent_id' => '4', 'code' => 'TK'], |
|
141
|
|
|
['id' => '117', 'name' => 'Afghanistan', 'continent_id' => '5', 'code' => 'AF'], |
|
142
|
|
|
['id' => '118', 'name' => 'Armenia', 'continent_id' => '5', 'code' => 'AM'], |
|
143
|
|
|
['id' => '119', 'name' => 'Azerbaijan', 'continent_id' => '5', 'code' => 'AZ'], |
|
144
|
|
|
['id' => '120', 'name' => 'Bahrain', 'continent_id' => '5', 'code' => 'BH'], |
|
145
|
|
|
['id' => '121', 'name' => 'Bangladesh', 'continent_id' => '5', 'code' => 'BD'], |
|
146
|
|
|
['id' => '122', 'name' => 'Bhutan', 'continent_id' => '5', 'code' => 'BT'], |
|
147
|
|
|
['id' => '123', 'name' => 'Brunei', 'continent_id' => '5', 'code' => 'BN'], |
|
148
|
|
|
['id' => '124', 'name' => 'Cambodia', 'continent_id' => '5', 'code' => 'KH'], |
|
149
|
|
|
['id' => '125', 'name' => 'China', 'continent_id' => '5', 'code' => 'CN'], |
|
150
|
|
|
['id' => '126', 'name' => 'Cyprus', 'continent_id' => '5', 'code' => 'CY'], |
|
151
|
|
|
['id' => '127', 'name' => 'Georgia', 'continent_id' => '5', 'code' => 'GE'], |
|
152
|
|
|
['id' => '129', 'name' => 'Hong Kong SAR China', 'continent_id' => '5', 'code' => 'HK'], |
|
153
|
|
|
['id' => '130', 'name' => 'India', 'continent_id' => '5', 'code' => 'IN'], |
|
154
|
|
|
['id' => '131', 'name' => 'Indonesia', 'continent_id' => '5', 'code' => 'ID'], |
|
155
|
|
|
['id' => '132', 'name' => 'Iran', 'continent_id' => '5', 'code' => 'IR'], |
|
156
|
|
|
['id' => '133', 'name' => 'Iraq', 'continent_id' => '5', 'code' => 'IQ'], |
|
157
|
|
|
['id' => '134', 'name' => 'Israel', 'continent_id' => '5', 'code' => 'IL'], |
|
158
|
|
|
['id' => '135', 'name' => 'Japan', 'continent_id' => '5', 'code' => 'JP'], |
|
159
|
|
|
['id' => '136', 'name' => 'Jordan', 'continent_id' => '5', 'code' => 'JO'], |
|
160
|
|
|
['id' => '137', 'name' => 'Kazakhstan', 'continent_id' => '5', 'code' => 'KZ'], |
|
161
|
|
|
['id' => '138', 'name' => 'Kuwait', 'continent_id' => '5', 'code' => 'KW'], |
|
162
|
|
|
['id' => '139', 'name' => 'Kyrgyzstan', 'continent_id' => '5', 'code' => 'KG'], |
|
163
|
|
|
['id' => '140', 'name' => 'Laos', 'continent_id' => '5', 'code' => 'LA'], |
|
164
|
|
|
['id' => '141', 'name' => 'Lebanon', 'continent_id' => '5', 'code' => 'LB'], |
|
165
|
|
|
['id' => '142', 'name' => 'Macau SAR China', 'continent_id' => '5', 'code' => 'MO'], |
|
166
|
|
|
['id' => '143', 'name' => 'Malaysia', 'continent_id' => '5', 'code' => 'MY'], |
|
167
|
|
|
['id' => '144', 'name' => 'Maldives', 'continent_id' => '5', 'code' => 'MV'], |
|
168
|
|
|
['id' => '145', 'name' => 'Mongolia', 'continent_id' => '5', 'code' => 'MN'], |
|
169
|
|
|
['id' => '146', 'name' => 'Myanmar Burma', 'continent_id' => '5', 'code' => 'MM'], |
|
170
|
|
|
['id' => '147', 'name' => 'Nepal', 'continent_id' => '5', 'code' => 'NP'], |
|
171
|
|
|
['id' => '148', 'name' => 'Neutral Zone', 'continent_id' => '5', 'code' => 'NT'], |
|
172
|
|
|
['id' => '149', 'name' => 'North Korea', 'continent_id' => '5', 'code' => 'KP'], |
|
173
|
|
|
['id' => '150', 'name' => 'Oman', 'continent_id' => '5', 'code' => 'OM'], |
|
174
|
|
|
['id' => '151', 'name' => 'Pakistan', 'continent_id' => '5', 'code' => 'PK'], |
|
175
|
|
|
['id' => '152', 'name' => 'Palestinian Territories', 'continent_id' => '5', 'code' => 'PS'], |
|
176
|
|
|
['id' => '153', 'name' => 'People s Democratic Republic of Yemen', 'continent_id' => '5', 'code' => 'YD'], |
|
177
|
|
|
['id' => '154', 'name' => 'Philippines', 'continent_id' => '5', 'code' => 'PH'], |
|
178
|
|
|
['id' => '155', 'name' => 'Qatar', 'continent_id' => '5', 'code' => 'QA'], |
|
179
|
|
|
['id' => '156', 'name' => 'Saudi Arabia', 'continent_id' => '5', 'code' => 'SA'], |
|
180
|
|
|
['id' => '157', 'name' => 'Singapore', 'continent_id' => '5', 'code' => 'SG'], |
|
181
|
|
|
['id' => '158', 'name' => 'South Korea', 'continent_id' => '5', 'code' => 'KR'], |
|
182
|
|
|
['id' => '159', 'name' => 'Sri Lanka', 'continent_id' => '5', 'code' => 'LK'], |
|
183
|
|
|
['id' => '160', 'name' => 'Syria', 'continent_id' => '5', 'code' => 'SY'], |
|
184
|
|
|
['id' => '161', 'name' => 'Taiwan', 'continent_id' => '5', 'code' => 'TW'], |
|
185
|
|
|
['id' => '162', 'name' => 'Tajikistan', 'continent_id' => '5', 'code' => 'TJ'], |
|
186
|
|
|
['id' => '163', 'name' => 'Thailand', 'continent_id' => '5', 'code' => 'TH'], |
|
187
|
|
|
['id' => '164', 'name' => 'Timor Leste', 'continent_id' => '5', 'code' => 'TL'], |
|
188
|
|
|
['id' => '165', 'name' => 'Turkey', 'continent_id' => '5', 'code' => 'TR'], |
|
189
|
|
|
['id' => '166', 'name' => 'Turkmenistan', 'continent_id' => '5', 'code' => 'TM'], |
|
190
|
|
|
['id' => '167', 'name' => 'United Arab Emirates', 'continent_id' => '5', 'code' => 'AE'], |
|
191
|
|
|
['id' => '168', 'name' => 'Uzbekistan', 'continent_id' => '5', 'code' => 'UZ'], |
|
192
|
|
|
['id' => '169', 'name' => 'Vietnam', 'continent_id' => '5', 'code' => 'VN'], |
|
193
|
|
|
['id' => '170', 'name' => 'Yemen', 'continent_id' => '5', 'code' => 'YE'], |
|
194
|
|
|
['id' => '171', 'name' => 'Albania', 'continent_id' => '6', 'code' => 'AL'], |
|
195
|
|
|
['id' => '172', 'name' => 'Andorra', 'continent_id' => '6', 'code' => 'AD'], |
|
196
|
|
|
['id' => '173', 'name' => 'Austria', 'continent_id' => '6', 'code' => 'AT'], |
|
197
|
|
|
['id' => '174', 'name' => 'Belarus', 'continent_id' => '6', 'code' => 'BY'], |
|
198
|
|
|
['id' => '175', 'name' => 'Belgium', 'continent_id' => '6', 'code' => 'BE'], |
|
199
|
|
|
['id' => '176', 'name' => 'Bosnia and Herzegovina', 'continent_id' => '6', 'code' => 'BA'], |
|
200
|
|
|
['id' => '177', 'name' => 'Bulgaria', 'continent_id' => '6', 'code' => 'BG'], |
|
201
|
|
|
['id' => '178', 'name' => 'Croatia', 'continent_id' => '6', 'code' => 'HR'], |
|
202
|
|
|
['id' => '179', 'name' => 'South Georgia and the South Sandwich Isl', 'continent_id' => '4', 'code' => 'GS'], |
|
203
|
|
|
['id' => '180', 'name' => 'Czech Republic', 'continent_id' => '6', 'code' => 'CZ'], |
|
204
|
|
|
['id' => '181', 'name' => 'Denmark', 'continent_id' => '6', 'code' => 'DK'], |
|
205
|
|
|
['id' => '182', 'name' => 'Estonia', 'continent_id' => '6', 'code' => 'EE'], |
|
206
|
|
|
['id' => '183', 'name' => 'Faroe Islands', 'continent_id' => '6', 'code' => 'FO'], |
|
207
|
|
|
['id' => '184', 'name' => 'Finland', 'continent_id' => '6', 'code' => 'FI'], |
|
208
|
|
|
['id' => '185', 'name' => 'France', 'continent_id' => '6', 'code' => 'FR'], |
|
209
|
|
|
['id' => '186', 'name' => 'Germany', 'continent_id' => '6', 'code' => 'DE'], |
|
210
|
|
|
['id' => '187', 'name' => 'Gibraltar', 'continent_id' => '6', 'code' => 'GI'], |
|
211
|
|
|
['id' => '188', 'name' => 'Greece', 'continent_id' => '6', 'code' => 'GR'], |
|
212
|
|
|
['id' => '189', 'name' => 'Guernsey', 'continent_id' => '6', 'code' => 'GG'], |
|
213
|
|
|
['id' => '190', 'name' => 'Hungary', 'continent_id' => '6', 'code' => 'HU'], |
|
214
|
|
|
['id' => '191', 'name' => 'Iceland', 'continent_id' => '6', 'code' => 'IS'], |
|
215
|
|
|
['id' => '192', 'name' => 'Ireland', 'continent_id' => '6', 'code' => 'IE'], |
|
216
|
|
|
['id' => '193', 'name' => 'Isle of Man', 'continent_id' => '6', 'code' => 'IM'], |
|
217
|
|
|
['id' => '195', 'name' => 'Jersey', 'continent_id' => '6', 'code' => 'JE'], |
|
218
|
|
|
['id' => '196', 'name' => 'Latvia', 'continent_id' => '6', 'code' => 'LV'], |
|
219
|
|
|
['id' => '197', 'name' => 'Liechtenstein', 'continent_id' => '6', 'code' => 'LI'], |
|
220
|
|
|
['id' => '198', 'name' => 'Lithuania', 'continent_id' => '6', 'code' => 'LT'], |
|
221
|
|
|
['id' => '199', 'name' => 'Luxembourg', 'continent_id' => '6', 'code' => 'LU'], |
|
222
|
|
|
['id' => '200', 'name' => 'Macedonia', 'continent_id' => '6', 'code' => 'MK'], |
|
223
|
|
|
['id' => '201', 'name' => 'Malta', 'continent_id' => '6', 'code' => 'MT'], |
|
224
|
|
|
['id' => '202', 'name' => 'Metropolitan France', 'continent_id' => '6', 'code' => 'FX'], |
|
225
|
|
|
['id' => '203', 'name' => 'Moldova', 'continent_id' => '6', 'code' => 'MD'], |
|
226
|
|
|
['id' => '204', 'name' => 'Monaco', 'continent_id' => '6', 'code' => 'MC'], |
|
227
|
|
|
['id' => '205', 'name' => 'Montenegro', 'continent_id' => '6', 'code' => 'ME'], |
|
228
|
|
|
['id' => '206', 'name' => 'Netherlands', 'continent_id' => '6', 'code' => 'NL'], |
|
229
|
|
|
['id' => '207', 'name' => 'Norway', 'continent_id' => '6', 'code' => 'NO'], |
|
230
|
|
|
['id' => '208', 'name' => 'Poland', 'continent_id' => '6', 'code' => 'PL'], |
|
231
|
|
|
['id' => '209', 'name' => 'Portugal', 'continent_id' => '6', 'code' => 'PT'], |
|
232
|
|
|
['id' => '210', 'name' => 'Romania', 'continent_id' => '6', 'code' => 'RO'], |
|
233
|
|
|
['id' => '211', 'name' => 'Russia', 'continent_id' => '6', 'code' => 'RU'], |
|
234
|
|
|
['id' => '212', 'name' => 'San Marino', 'continent_id' => '6', 'code' => 'SM'], |
|
235
|
|
|
['id' => '213', 'name' => 'Serbia', 'continent_id' => '6', 'code' => 'RS'], |
|
236
|
|
|
['id' => '214', 'name' => 'Serbia and Montenegro', 'continent_id' => '6', 'code' => 'CS'], |
|
237
|
|
|
['id' => '215', 'name' => 'Slovakia', 'continent_id' => '6', 'code' => 'SK'], |
|
238
|
|
|
['id' => '216', 'name' => 'Slovenia', 'continent_id' => '6', 'code' => 'SI'], |
|
239
|
|
|
['id' => '217', 'name' => 'Spain', 'continent_id' => '6', 'code' => 'ES'], |
|
240
|
|
|
['id' => '218', 'name' => 'Svalbard and Jan Mayen', 'continent_id' => '6', 'code' => 'SJ'], |
|
241
|
|
|
['id' => '219', 'name' => 'Sweden', 'continent_id' => '6', 'code' => 'SE'], |
|
242
|
|
|
['id' => '220', 'name' => 'Switzerland', 'continent_id' => '6', 'code' => 'CH'], |
|
243
|
|
|
['id' => '221', 'name' => 'Ukraine', 'continent_id' => '6', 'code' => 'UA'], |
|
244
|
|
|
['id' => '222', 'name' => 'Union of Soviet Socialist Republics', 'continent_id' => '6', 'code' => 'SU'], |
|
245
|
|
|
['id' => '223', 'name' => 'United Kingdom', 'continent_id' => '6', 'code' => 'GB'], |
|
246
|
|
|
['id' => '224', 'name' => 'Vatican City', 'continent_id' => '6', 'code' => 'VA'], |
|
247
|
|
|
['id' => '225', 'name' => 'Aland Islands', 'continent_id' => '6', 'code' => 'AX'], |
|
248
|
|
|
['id' => '226', 'name' => 'American Samoa', 'continent_id' => '4', 'code' => 'AS'], |
|
249
|
|
|
['id' => '227', 'name' => 'Antarctica', 'continent_id' => '4', 'code' => 'AQ'], |
|
250
|
|
|
['id' => '228', 'name' => 'Australia', 'continent_id' => '4', 'code' => 'AU'], |
|
251
|
|
|
['id' => '229', 'name' => 'Bouvet Island', 'continent_id' => '4', 'code' => 'BV'], |
|
252
|
|
|
['id' => '230', 'name' => 'British Indian Ocean Territory', 'continent_id' => '4', 'code' => 'IO'], |
|
253
|
|
|
['id' => '231', 'name' => 'Christmas Island', 'continent_id' => '4', 'code' => 'CX'], |
|
254
|
|
|
['id' => '232', 'name' => 'Cocos Keeling Islands', 'continent_id' => '4', 'code' => 'CC'], |
|
255
|
|
|
['id' => '234', 'name' => 'Cook Islands', 'continent_id' => '4', 'code' => 'CK'], |
|
256
|
|
|
['id' => '235', 'name' => 'Fiji', 'continent_id' => '4', 'code' => 'FJ'], |
|
257
|
|
|
['id' => '236', 'name' => 'French Polynesia', 'continent_id' => '4', 'code' => 'PF'], |
|
258
|
|
|
['id' => '237', 'name' => 'French Southern Territories', 'continent_id' => '4', 'code' => 'TF'], |
|
259
|
|
|
['id' => '238', 'name' => 'Guam', 'continent_id' => '4', 'code' => 'GU'], |
|
260
|
|
|
['id' => '239', 'name' => 'Heard Island and McDonald Islands', 'continent_id' => '4', 'code' => 'HM'], |
|
261
|
|
|
['id' => '240', 'name' => 'Kiribati', 'continent_id' => '4', 'code' => 'KI'], |
|
262
|
|
|
['id' => '241', 'name' => 'Marshall Islands', 'continent_id' => '4', 'code' => 'MH'], |
|
263
|
|
|
['id' => '242', 'name' => 'Micronesia', 'continent_id' => '4', 'code' => 'FM'], |
|
264
|
|
|
['id' => '243', 'name' => 'Nauru', 'continent_id' => '4', 'code' => 'NR'], |
|
265
|
|
|
['id' => '244', 'name' => 'New Caledonia', 'continent_id' => '4', 'code' => 'NC'], |
|
266
|
|
|
['id' => '245', 'name' => 'New Zealand', 'continent_id' => '4', 'code' => 'NZ'], |
|
267
|
|
|
['id' => '246', 'name' => 'Niue', 'continent_id' => '4', 'code' => 'NU'], |
|
268
|
|
|
['id' => '247', 'name' => 'Norfolk Island', 'continent_id' => '4', 'code' => 'NF'], |
|
269
|
|
|
['id' => '248', 'name' => 'Northern Mariana Islands', 'continent_id' => '4', 'code' => 'MP'], |
|
270
|
|
|
['id' => '249', 'name' => 'Palau', 'continent_id' => '4', 'code' => 'PW'], |
|
271
|
|
|
['id' => '250', 'name' => 'Papua New Guinea', 'continent_id' => '4', 'code' => 'PG'], |
|
272
|
|
|
['id' => '251', 'name' => 'Pitcairn Islands', 'continent_id' => '4', 'code' => 'PN'], |
|
273
|
|
|
['id' => '252', 'name' => 'Samoa', 'continent_id' => '4', 'code' => 'WS'], |
|
274
|
|
|
['id' => '253', 'name' => 'Solomon Islands', 'continent_id' => '4', 'code' => 'SB'], |
|
275
|
|
|
]; |
|
276
|
|
|
|
|
277
|
|
|
//dump($countries); |
|
278
|
|
|
foreach ($countries as $key => $country) { |
|
279
|
|
|
DB::table('countries')->insert([ |
|
280
|
|
|
'id' => $country['id'], |
|
281
|
|
|
'name' => $country['name'], |
|
282
|
|
|
'continent_id' => $country['continent_id'], |
|
283
|
|
|
'code' => $country['code'], |
|
284
|
|
|
]); |
|
285
|
|
|
} |
|
286
|
|
|
} |
|
287
|
|
|
} |
|
288
|
|
|
|
davide-casiraghi /
laravel-events-calendar
