DatabaseSeeder::run()   B
last analyzed

Complexity

Conditions 6
Paths 32

Size

Total Lines 1985
Code Lines 1935

Duplication

Lines 0
Ratio 0 %

Importance

Changes 0
Metric Value
cc 6
eloc 1935
nc 32
nop 0
dl 0
loc 1985
rs 8.1463
c 0
b 0
f 0

How to fix   Long Method   

Long Method

Small methods make your code easier to understand, in particular if combined with a good name. Besides, if your method is small, finding a good name is usually much easier.

For example, if you find yourself adding comments to a method's body, this is usually a good sign to extract the commented part to a new method, and use the comment as a starting point when coming up with a good name for this new method.

Commonly applied refactorings include:

1
<?php
2
3
use App\Model\Common\Template;
4
use App\Model\Common\TemplateSet;
5
use App\Model\Common\TemplateType;
6
use App\Model\helpdesk\Agent\Department;
7
use App\Model\helpdesk\Agent\Groups;
8
use App\Model\helpdesk\Agent\Teams;
9
use App\Model\helpdesk\Manage\Help_topic;
10
use App\Model\helpdesk\Manage\Sla_plan;
11
use App\Model\helpdesk\Notification\NotificationType;
12
use App\Model\helpdesk\Ratings\Rating;
13
use App\Model\helpdesk\Settings\Alert;
14
use App\Model\helpdesk\Settings\CommonSettings;
15
use App\Model\helpdesk\Settings\Company;
16
use App\Model\helpdesk\Settings\Email;
17
use App\Model\helpdesk\Settings\Responder;
18
use App\Model\helpdesk\Settings\Security;
19
use App\Model\helpdesk\Settings\System;
20
use App\Model\helpdesk\Settings\Ticket;
21
use App\Model\helpdesk\Theme\Widgets;
22
use App\Model\helpdesk\Ticket\Ticket_Priority;
23
use App\Model\helpdesk\Ticket\Ticket_source;
24
use App\Model\helpdesk\Ticket\Ticket_Status;
25
use App\Model\helpdesk\Utility\CountryCode;
26
use App\Model\helpdesk\Utility\Date_format;
27
use App\Model\helpdesk\Utility\Date_time_format;
28
use App\Model\helpdesk\Utility\Languages;
29
use App\Model\helpdesk\Utility\Limit_Login;
30
use App\Model\helpdesk\Utility\Log_notification;
31
use App\Model\helpdesk\Utility\MailboxProtocol;
32
use App\Model\helpdesk\Utility\Time_format;
33
use App\Model\helpdesk\Utility\Timezones;
34
use App\Model\helpdesk\Utility\Version_Check;
35
use App\Model\helpdesk\Workflow\WorkflowClose;
36
use App\Model\kb\Settings;
37
// Knowledge base
38
use Illuminate\Database\Seeder;
39
40
class DatabaseSeeder extends Seeder
41
{
42
    /**
43
     * Run the database seeds.
44
     *
45
     * @return void
46
     */
47
    public function run()
48
    {
49
50
        /* Date time format */
51
        $date_time_formats = [
52
            'd/m/Y H:i:s',
53
            'd.m.Y H:i:s',
54
            'd-m-Y H:i:s',
55
            'm/d/Y H:i:s',
56
            'm.d.Y H:i:s',
57
            'm-d-Y H:i:s',
58
            'Y/m/d H:i:s',
59
            'Y.m.d H:i:s',
60
            'Y-m-d H:i:s', ];
61
62
        foreach ($date_time_formats as $date_time_format) {
63
            Date_time_format::create(['format' => $date_time_format]);
64
        }
65
        NotificationType::create(['id' => '1', 'message' => 'A new user is registered', 'type' => 'registration', 'icon_class' => 'fa fa-user']);
66
        NotificationType::create(['id' => '2', 'message' => 'You have a new reply on this ticket', 'type' => 'reply', 'icon_class' => 'fa fa-envelope']);
67
        NotificationType::create(['id' => '3', 'message' => 'A new ticket has been created', 'type' => 'new_ticket', 'icon_class' => 'fa fa-envelope']);
68
        WorkflowClose::create(['id' => '1', 'days' => '2', 'condition' => '1', 'send_email' => '1', 'status' => '3']);
69
70
        /* Date format */
71
        $date_formats = [
72
            'dd/mm/yyyy',
73
            'dd-mm-yyyy',
74
            'dd.mm.yyyy',
75
            'mm/dd/yyyy',
76
            'mm:dd:yyyy',
77
            'mm-dd-yyyy',
78
            'yyyy/mm/dd',
79
            'yyyy.mm.dd',
80
            'yyyy-mm-dd', ];
81
82
        foreach ($date_formats as $date_format) {
83
            Date_format::create(['format' => $date_format]);
84
        }
85
        /* Time format */
86
        Time_format::create(['format' => 'H:i:s']);
87
        Time_format::create(['format' => 'H.i.s']);
88
        /* Timezone */
89
        $timezone = ['Pacific/Midway' => '(GMT-11:00) Midway Island',
90
            'US/Samoa'                => '(GMT-11:00) Samoa',
91
            'US/Hawaii'               => '(GMT-10:00) Hawaii',
92
            'US/Alaska'               => '(GMT-09:00) Alaska',
93
            'US/Pacific'              => '(GMT-08:00) Pacific Time (US &amp; Canada)',
94
            'America/Tijuana'         => '(GMT-08:00) Tijuana',
95
            'US/Arizona'              => '(GMT-07:00) Arizona',
96
            'US/Mountain'             => '(GMT-07:00) Mountain Time (US &amp; Canada)',
97
            'America/Chihuahua'       => '(GMT-07:00) Chihuahua',
98
            'America/Mazatlan'        => '(GMT-07:00) Mazatlan',
99
            'America/Mexico_City'     => '(GMT-06:00) Mexico City',
100
            'America/Monterrey'       => '(GMT-06:00) Monterrey',
101
            'Canada/Saskatchewan'     => '(GMT-06:00) Saskatchewan',
102
            'US/Central'              => '(GMT-06:00) Central Time (US &amp; Canada)',
103
            'US/Eastern'              => '(GMT-05:00) Eastern Time (US &amp; Canada)',
104
            'US/East-Indiana'         => '(GMT-05:00) Indiana (East)',
105
            'America/Bogota'          => '(GMT-05:00) Bogota',
106
            'America/Lima'            => '(GMT-05:00) Lima',
107
            'America/Caracas'         => '(GMT-04:30) Caracas',
108
            'Canada/Atlantic'         => '(GMT-04:00) Atlantic Time (Canada)',
109
            'America/La_Paz'          => '(GMT-04:00) La Paz',
110
            'America/Santiago'        => '(GMT-04:00) Santiago',
111
            'Canada/Newfoundland'     => '(GMT-03:30) Newfoundland',
112
            'America/Buenos_Aires'    => '(GMT-03:00) Buenos Aires',
113
            'Greenland'               => '(GMT-03:00) Greenland',
114
            'Atlantic/Stanley'        => '(GMT-02:00) Stanley',
115
            'Atlantic/Azores'         => '(GMT-01:00) Azores',
116
            'Atlantic/Cape_Verde'     => '(GMT-01:00) Cape Verde Is.',
117
            'Africa/Casablanca'       => '(GMT) Casablanca',
118
            'Europe/Dublin'           => '(GMT) Dublin',
119
            'Europe/Lisbon'           => '(GMT) Lisbon',
120
            'Europe/London'           => '(GMT) London',
121
            'Africa/Monrovia'         => '(GMT) Monrovia',
122
            'Europe/Amsterdam'        => '(GMT+01:00) Amsterdam',
123
            'Europe/Belgrade'         => '(GMT+01:00) Belgrade',
124
            'Europe/Berlin'           => '(GMT+01:00) Berlin',
125
            'Europe/Bratislava'       => '(GMT+01:00) Bratislava',
126
            'Europe/Brussels'         => '(GMT+01:00) Brussels',
127
            'Europe/Budapest'         => '(GMT+01:00) Budapest',
128
            'Europe/Copenhagen'       => '(GMT+01:00) Copenhagen',
129
            'Europe/Ljubljana'        => '(GMT+01:00) Ljubljana',
130
            'Europe/Madrid'           => '(GMT+01:00) Madrid',
131
            'Europe/Paris'            => '(GMT+01:00) Paris',
132
            'Europe/Prague'           => '(GMT+01:00) Prague',
133
            'Europe/Rome'             => '(GMT+01:00) Rome',
134
            'Europe/Sarajevo'         => '(GMT+01:00) Sarajevo',
135
            'Europe/Skopje'           => '(GMT+01:00) Skopje',
136
            'Europe/Stockholm'        => '(GMT+01:00) Stockholm',
137
            'Europe/Vienna'           => '(GMT+01:00) Vienna',
138
            'Europe/Warsaw'           => '(GMT+01:00) Warsaw',
139
            'Europe/Zagreb'           => '(GMT+01:00) Zagreb',
140
            'Europe/Athens'           => '(GMT+02:00) Athens',
141
            'Europe/Bucharest'        => '(GMT+02:00) Bucharest',
142
            'Africa/Cairo'            => '(GMT+02:00) Cairo',
143
            'Africa/Harare'           => '(GMT+02:00) Harare',
144
            'Europe/Helsinki'         => '(GMT+02:00) Helsinki',
145
            'Europe/Istanbul'         => '(GMT+02:00) Istanbul',
146
            'Asia/Jerusalem'          => '(GMT+02:00) Jerusalem',
147
            'Europe/Kiev'             => '(GMT+02:00) Kyiv',
148
            'Europe/Minsk'            => '(GMT+02:00) Minsk',
149
            'Europe/Riga'             => '(GMT+02:00) Riga',
150
            'Europe/Sofia'            => '(GMT+02:00) Sofia',
151
            'Europe/Tallinn'          => '(GMT+02:00) Tallinn',
152
            'Europe/Vilnius'          => '(GMT+02:00) Vilnius',
153
            'Asia/Baghdad'            => '(GMT+03:00) Baghdad',
154
            'Asia/Kuwait'             => '(GMT+03:00) Kuwait',
155
            'Africa/Nairobi'          => '(GMT+03:00) Nairobi',
156
            'Asia/Riyadh'             => '(GMT+03:00) Riyadh',
157
            'Asia/Tehran'             => '(GMT+03:30) Tehran',
158
            'Europe/Moscow'           => '(GMT+04:00) Moscow',
159
            'Asia/Baku'               => '(GMT+04:00) Baku',
160
            'Europe/Volgograd'        => '(GMT+04:00) Volgograd',
161
            'Asia/Muscat'             => '(GMT+04:00) Muscat',
162
            'Asia/Tbilisi'            => '(GMT+04:00) Tbilisi',
163
            'Asia/Yerevan'            => '(GMT+04:00) Yerevan',
164
            'Asia/Kabul'              => '(GMT+04:30) Kabul',
165
            'Asia/Karachi'            => '(GMT+05:00) Karachi',
166
            'Asia/Tashkent'           => '(GMT+05:00) Tashkent',
167
            'Asia/Kolkata'            => '(GMT+05:30) Kolkata',
168
            'Asia/Kathmandu'          => '(GMT+05:45) Kathmandu',
169
            'Asia/Yekaterinburg'      => '(GMT+06:00) Ekaterinburg',
170
            'Asia/Almaty'             => '(GMT+06:00) Almaty',
171
            'Asia/Dhaka'              => '(GMT+06:00) Dhaka',
172
            'Asia/Novosibirsk'        => '(GMT+07:00) Novosibirsk',
173
            'Asia/Bangkok'            => '(GMT+07:00) Bangkok',
174
            'Asia/Ho_Chi_Minh'        => '(GMT+07.00) Ho Chi Minh',
175
            'Asia/Jakarta'            => '(GMT+07:00) Jakarta',
176
            'Asia/Krasnoyarsk'        => '(GMT+08:00) Krasnoyarsk',
177
            'Asia/Chongqing'          => '(GMT+08:00) Chongqing',
178
            'Asia/Hong_Kong'          => '(GMT+08:00) Hong Kong',
179
            'Asia/Kuala_Lumpur'       => '(GMT+08:00) Kuala Lumpur',
180
            'Australia/Perth'         => '(GMT+08:00) Perth',
181
            'Asia/Singapore'          => '(GMT+08:00) Singapore',
182
            'Asia/Taipei'             => '(GMT+08:00) Taipei',
183
            'Asia/Ulaanbaatar'        => '(GMT+08:00) Ulaan Bataar',
184
            'Asia/Urumqi'             => '(GMT+08:00) Urumqi',
185
            'Asia/Irkutsk'            => '(GMT+09:00) Irkutsk',
186
            'Asia/Seoul'              => '(GMT+09:00) Seoul',
187
            'Asia/Tokyo'              => '(GMT+09:00) Tokyo',
188
            'Australia/Adelaide'      => '(GMT+09:30) Adelaide',
189
            'Australia/Darwin'        => '(GMT+09:30) Darwin',
190
            'Asia/Yakutsk'            => '(GMT+10:00) Yakutsk',
191
            'Australia/Brisbane'      => '(GMT+10:00) Brisbane',
192
            'Australia/Canberra'      => '(GMT+10:00) Canberra',
193
            'Pacific/Guam'            => '(GMT+10:00) Guam',
194
            'Australia/Hobart'        => '(GMT+10:00) Hobart',
195
            'Australia/Melbourne'     => '(GMT+10:00) Melbourne',
196
            'Pacific/Port_Moresby'    => '(GMT+10:00) Port Moresby',
197
            'Australia/Sydney'        => '(GMT+10:00) Sydney',
198
            'Asia/Vladivostok'        => '(GMT+11:00) Vladivostok',
199
            'Asia/Magadan'            => '(GMT+12:00) Magadan',
200
            'Pacific/Auckland'        => '(GMT+12:00) Auckland',
201
            'Pacific/Fiji'            => '(GMT+12:00) Fiji', ];
202
203
        foreach ($timezone as $name => $location) {
204
            Timezones::create(['name' => $name, 'location' => $location]);
205
        }
206
        /* Ticket status */
207
        Ticket_status::create(['name' => 'Open', 'state' => 'open', 'mode' => '3', 'message' => 'Ticket have been Reopened by', 'flags' => '0', 'sort' => '1', 'properties' => 'Open tickets.']);
208
        Ticket_status::create(['name' => 'Resolved', 'state' => 'closed', 'mode' => '1', 'message' => 'Ticket have been Resolved by', 'flags' => '0', 'sort' => '2', 'properties' => 'Resolved tickets.']);
209
        Ticket_status::create(['name' => 'Closed', 'state' => 'closed', 'mode' => '3', 'message' => 'Ticket have been Closed by', 'flags' => '0', 'sort' => '3', 'properties' => 'Closed tickets. Tickets will still be accessible on client and staff panels.']);
210
        Ticket_status::create(['name' => 'Archived', 'state' => 'archived', 'mode' => '3', 'message' => 'Ticket have been Archived by', 'flags' => '0', 'sort' => '4', 'properties' => 'Tickets only adminstratively available but no longer accessible on ticket queues and client panel.']);
211
        Ticket_status::create(['name' => 'Deleted', 'state' => 'deleted', 'mode' => '3', 'message' => 'Ticket have been Deleted by', 'flags' => '0', 'sort' => '5', 'properties' => 'Tickets queued for deletion. Not accessible on ticket queues.']);
212
        Ticket_status::create(['name' => 'Unverified', 'state' => 'unverified', 'mode' => '3', 'message' => 'User account verification required.', 'flags' => '0', 'sort' => '6', 'properties' => 'Ticket will be open after user verifies his/her account.']);
213
        Ticket_status::create(['name' => 'Request Approval', 'state' => 'unverified', 'mode' => '3', 'message' => 'Approval requested by', 'flags' => '0', 'sort' => '7', 'properties' => 'Ticket will be approve  after Admin verifies  this ticket']);
214
215
        /* Ticket priority */
216
        Ticket_priority::create(['priority' => 'Low', 'status' => 1, 'priority_desc' => 'Low', 'priority_color' => '#00a65a', 'priority_urgency' => '4', 'ispublic' => '1']);
217
        Ticket_priority::create(['priority' => 'Normal', 'status' => 1, 'priority_desc' => 'Normal', 'priority_color' => '#00bfef', 'priority_urgency' => '3', 'ispublic' => '1', 'is_default' => '1']);
218
        Ticket_priority::create(['priority' => 'High', 'status' => 1, 'priority_desc' => 'High', 'priority_color' => '#f39c11', 'priority_urgency' => '2', 'ispublic' => '1']);
219
        Ticket_priority::create(['priority' => 'Emergency', 'status' => 1, 'priority_desc' => 'Emergency', 'priority_color' => '#dd4b38', 'priority_urgency' => '1', 'ispublic' => '1']);
220
221
        /* SLA Plans */
222
        Sla_plan::create(['name' => 'Sla 1', 'grace_period' => '6 Hours', 'status' => '1']);
223
        Sla_plan::create(['name' => 'Sla 2', 'grace_period' => '12 Hours', 'status' => '1']);
224
        Sla_plan::create(['name' => 'Sla 3', 'grace_period' => '24 Hours', 'status' => '1']);
225
        /* Mailbox protocol */
226
        $mailbox = [
227
            'IMAP'                 => '/imap',
228
            'IMAP+SSL'             => '/imap/ssl',
229
            'IMAP+TLS'             => '/imap/tls',
230
            'IMAP+SSL/No-validate' => '/imap/ssl/novalidate-cert', ];
231
232
        foreach ($mailbox as $name => $value) {
233
            MailboxProtocol::create(['name' => $name, 'value' => $value]);
234
        }
235
        /* Languages */
236
        $languages = [
237
            'English'              => 'en',
238
            'Italian'              => 'it',
239
            'German'               => 'de',
240
            'French'               => 'fr',
241
            'Brazilian Portuguese' => 'pt_BR',
242
            'Dutch'                => 'nl',
243
            'Spanish'              => 'es',
244
            'Norwegian'            => 'nb_NO',
245
            'Danish'               => 'da', ];
246
247
        foreach ($languages as $language => $locale) {
248
            Languages::create(['name' => $language, 'locale' => $locale]);
249
        }
250
        /* Teams */
251
        Teams::create(['name' => 'Level 1 Support', 'status' => '1']);
252
        Teams::create(['name' => 'Level 2 Support']);
253
        Teams::create(['name' => 'Developer']);
254
        /* Groups */
255
        Groups::create(['name' => 'Group A', 'group_status' => '1', 'can_create_ticket' => '1', 'can_edit_ticket' => '1', 'can_post_ticket' => '1', 'can_close_ticket' => '1', 'can_assign_ticket' => '1', 'can_transfer_ticket' => '1', 'can_delete_ticket' => '1', 'can_ban_email' => '1', 'can_manage_canned' => '1', 'can_view_agent_stats' => '1', 'department_access' => '1']);
256
        Groups::create(['name' => 'Group B', 'group_status' => '1', 'can_create_ticket' => '1', 'can_edit_ticket' => '0', 'can_post_ticket' => '0', 'can_close_ticket' => '1', 'can_assign_ticket' => '1', 'can_transfer_ticket' => '1', 'can_delete_ticket' => '1', 'can_ban_email' => '1', 'can_manage_canned' => '1', 'can_view_agent_stats' => '1', 'department_access' => '1']);
257
        Groups::create(['name' => 'Group C', 'group_status' => '1', 'can_create_ticket' => '0', 'can_edit_ticket' => '0', 'can_post_ticket' => '0', 'can_close_ticket' => '1', 'can_assign_ticket' => '0', 'can_transfer_ticket' => '0', 'can_delete_ticket' => '0', 'can_ban_email' => '0', 'can_manage_canned' => '0', 'can_view_agent_stats' => '0', 'department_access' => '0']);
258
        /* Department */
259
        Department::create(['name' => 'Support', 'type' => '1', 'sla' => '1']);
260
        Department::create(['name' => 'Sales', 'type' => '1', 'sla' => '1']);
261
        Department::create(['name' => 'Operation', 'type' => '1', 'sla' => '1']);
262
        /* Helptopic */
263
        help_topic::create(['topic' => 'Support query', 'department' => '1', 'ticket_status' => '1', 'priority' => '2', 'sla_plan' => '1', 'ticket_num_format' => '1', 'status' => '1', 'type' => '1', 'auto_response' => '0']);
264
        help_topic::create(['topic' => 'Sales query', 'department' => '2', 'ticket_status' => '1', 'priority' => '2', 'sla_plan' => '1', 'ticket_num_format' => '1', 'status' => '0', 'type' => '1', 'auto_response' => '0']);
265
        help_topic::create(['topic' => 'Operational query', 'department' => '3', 'ticket_status' => '1', 'priority' => '2', 'sla_plan' => '1', 'ticket_num_format' => '1', 'status' => '0', 'type' => '1', 'auto_response' => '0']);
266
        /* Daily notification log */
267
        Log_notification::create(['log' => 'NOT-1']);
268
        /* System complete settings */
269
        Alert::create(['id' => '1', 'ticket_status' => '1', 'ticket_admin_email' => '1', 'assignment_status' => '1', 'assignment_status' => '1', 'assignment_assigned_agent' => '1']);
270
        Company::create(['id' => '1']);
271
        Email::create(['id' => '1', 'template' => 'default', 'email_fetching' => '1', 'notification_cron' => '1', 'all_emails' => '1', 'email_collaborator' => '1', 'attachment' => '1']);
272
        Responder::create(['id' => '1', 'new_ticket' => '1', 'agent_new_ticket' => '1']);
273
        System::create(['id' => '1', 'status' => '1', 'department' => '1', 'date_time_format' => '1', 'time_zone' => '32']);
274
        Ticket::create(['num_format' => '$$$$-####-####', 'num_sequence' => 'sequence', 'collision_avoid' => '2', 'priority' => '1', 'sla' => '2', 'help_topic' => '1', 'status' => '1']);
275
        /* Ticket source */
276
        Ticket_source::create(['name' => 'web', 'value' => 'Web']);
277
        Ticket_source::create(['name' => 'email', 'value' => 'E-mail']);
278
        Ticket_source::create(['name' => 'agent', 'value' => 'Agent Panel']);
279
        /* Version check */
280
        Version_Check::create(['id' => '1']);
281
        /* System widgets */
282
        Widgets::create(['id' => '1', 'name' => 'footer1']);
283
        Widgets::create(['id' => '2', 'name' => 'footer2']);
284
        Widgets::create(['id' => '3', 'name' => 'footer3']);
285
        Widgets::create(['id' => '4', 'name' => 'footer4']);
286
        Widgets::create(['id' => '5', 'name' => 'side1']);
287
        Widgets::create(['id' => '6', 'name' => 'side2']);
288
        Widgets::create(['id' => '7', 'name' => 'linkedin']);
289
        Widgets::create(['id' => '8', 'name' => 'stumble']);
290
        Widgets::create(['id' => '9', 'name' => 'google']);
291
        Widgets::create(['id' => '10', 'name' => 'deviantart']);
292
        Widgets::create(['id' => '11', 'name' => 'flickr']);
293
        Widgets::create(['id' => '12', 'name' => 'skype']);
294
        Widgets::create(['id' => '13', 'name' => 'rss']);
295
        Widgets::create(['id' => '14', 'name' => 'twitter']);
296
        Widgets::create(['id' => '15', 'name' => 'facebook']);
297
        Widgets::create(['id' => '16', 'name' => 'youtube']);
298
        Widgets::create(['id' => '17', 'name' => 'vimeo']);
299
        Widgets::create(['id' => '18', 'name' => 'pinterest']);
300
        Widgets::create(['id' => '19', 'name' => 'dribbble']);
301
        Widgets::create(['id' => '20', 'name' => 'instagram']);
302
        /* Knowledge base setting */
303
        Settings::create(['id' => 'id', 'pagination' => '10']);
304
        /* Counrty phone code and iso code */
305
306
        CountryCode::create(['id' => '1',
307
            'iso'                 => 'AF',
308
            'name'                => 'AFGHANISTAN',
309
            'nicename'            => 'Afghanistan',
310
            'iso3'                => 'AFG',
311
            'numcode'             => '4',
312
            'phonecode'           => '93', ]);
313
        CountryCode::create(['id' => '2',
314
            'iso'                 => 'AL',
315
            'name'                => 'ALBANIA',
316
            'nicename'            => 'Albania',
317
            'iso3'                => 'ALB',
318
            'numcode'             => '8',
319
            'phonecode'           => '355', ]);
320
        CountryCode::create(['id' => '3',
321
            'iso'                 => 'DZ',
322
            'name'                => 'ALGERIA',
323
            'nicename'            => 'Algeria',
324
            'iso3'                => 'DZA',
325
            'numcode'             => '12',
326
            'phonecode'           => '213', ]);
327
        CountryCode::create(['id' => '4',
328
            'iso'                 => 'AS',
329
            'name'                => 'AMERICAN SAMOA',
330
            'nicename'            => 'American Samoa',
331
            'iso3'                => 'ASM',
332
            'numcode'             => '16',
333
            'phonecode'           => '1684', ]);
334
        CountryCode::create(['id' => '5',
335
            'iso'                 => 'AD',
336
            'name'                => 'ANDORRA',
337
            'nicename'            => 'Andorra',
338
            'iso3'                => 'AND',
339
            'numcode'             => '20',
340
            'phonecode'           => '376', ]);
341
        CountryCode::create(['id' => '6',
342
            'iso'                 => 'AO',
343
            'name'                => 'ANGOLA',
344
            'nicename'            => 'Angola',
345
            'iso3'                => 'AGO',
346
            'numcode'             => '24',
347
            'phonecode'           => '244', ]);
348
        CountryCode::create(['id' => '7',
349
            'iso'                 => 'AI',
350
            'name'                => 'ANGUILLA',
351
            'nicename'            => 'Anguilla',
352
            'iso3'                => 'AIA',
353
            'numcode'             => '660',
354
            'phonecode'           => '1264', ]);
355
        CountryCode::create(['id' => '8',
356
            'iso'                 => 'AQ',
357
            'name'                => 'ANTARCTICA',
358
            'nicename'            => 'Antarctica',
359
            'iso3'                => 'NULL',
360
            'numcode'             => 'NULL',
361
            'phonecode'           => '0', ]);
362
        CountryCode::create(['id' => '9',
363
            'iso'                 => 'AG',
364
            'name'                => 'ANTIGUA AND BARBUDA',
365
            'nicename'            => 'Antigua and Barbuda',
366
            'iso3'                => 'ATG',
367
            'numcode'             => '28',
368
            'phonecode'           => '1268', ]);
369
        CountryCode::create(['id' => '10',
370
            'iso'                 => 'AR',
371
            'name'                => 'ARGENTINA',
372
            'nicename'            => 'Argentina',
373
            'iso3'                => 'ARG',
374
            'numcode'             => '32',
375
            'phonecode'           => '54', ]);
376
        CountryCode::create(['id' => '11',
377
            'iso'                 => 'AM',
378
            'name'                => 'ARMENIA',
379
            'nicename'            => 'Armenia',
380
            'iso3'                => 'ARM',
381
            'numcode'             => '51',
382
            'phonecode'           => '374', ]);
383
        CountryCode::create(['id' => '12',
384
            'iso'                 => 'AW',
385
            'name'                => 'ARUBA',
386
            'nicename'            => 'Aruba',
387
            'iso3'                => 'ABW',
388
            'numcode'             => '533',
389
            'phonecode'           => '297', ]);
390
        CountryCode::create(['id' => '13',
391
            'iso'                 => 'AU',
392
            'name'                => 'AUSTRALIA',
393
            'nicename'            => 'Australia',
394
            'iso3'                => 'AUS',
395
            'numcode'             => '36',
396
            'phonecode'           => '61', ]);
397
        CountryCode::create(['id' => '14',
398
            'iso'                 => 'AT',
399
            'name'                => 'AUSTRIA',
400
            'nicename'            => 'Austria',
401
            'iso3'                => 'AUT',
402
            'numcode'             => '40',
403
            'phonecode'           => '43', ]);
404
        CountryCode::create(['id' => '15',
405
            'iso'                 => 'AZ',
406
            'name'                => 'AZERBAIJAN',
407
            'nicename'            => 'Azerbaijan',
408
            'iso3'                => 'AZE',
409
            'numcode'             => '31',
410
            'phonecode'           => '994', ]);
411
        CountryCode::create(['id' => '16',
412
            'iso'                 => 'BS',
413
            'name'                => 'BAHAMAS',
414
            'nicename'            => 'Bahamas',
415
            'iso3'                => 'BHS',
416
            'numcode'             => '44',
417
            'phonecode'           => '1242', ]);
418
        CountryCode::create(['id' => '17',
419
            'iso'                 => 'BH',
420
            'name'                => 'BAHRAIN',
421
            'nicename'            => 'Bahrain',
422
            'iso3'                => 'BHR',
423
            'numcode'             => '48',
424
            'phonecode'           => '973', ]);
425
        CountryCode::create(['id' => '18',
426
            'iso'                 => 'BD',
427
            'name'                => 'BANGLADESH',
428
            'nicename'            => 'Bangladesh',
429
            'iso3'                => 'BGD',
430
            'numcode'             => '50',
431
            'phonecode'           => '880', ]);
432
        CountryCode::create(['id' => '19',
433
            'iso'                 => 'BB',
434
            'name'                => 'BARBADOS',
435
            'nicename'            => 'Barbados',
436
            'iso3'                => 'BRB',
437
            'numcode'             => '52',
438
            'phonecode'           => '1246', ]);
439
        CountryCode::create(['id' => '20',
440
            'iso'                 => 'BY',
441
            'name'                => 'BELARUS',
442
            'nicename'            => 'Belarus',
443
            'iso3'                => 'BLR',
444
            'numcode'             => '112',
445
            'phonecode'           => '375', ]);
446
        CountryCode::create(['id' => '21',
447
            'iso'                 => 'BE',
448
            'name'                => 'BELGIUM',
449
            'nicename'            => 'Belgium',
450
            'iso3'                => 'BEL',
451
            'numcode'             => '56',
452
            'phonecode'           => '32', ]);
453
        CountryCode::create(['id' => '22',
454
            'iso'                 => 'BZ',
455
            'name'                => 'BELIZE',
456
            'nicename'            => 'Belize',
457
            'iso3'                => 'BLZ',
458
            'numcode'             => '84',
459
            'phonecode'           => '501', ]);
460
        CountryCode::create(['id' => '23',
461
            'iso'                 => 'BJ',
462
            'name'                => 'BENIN',
463
            'nicename'            => 'Benin',
464
            'iso3'                => 'BEN',
465
            'numcode'             => '204',
466
            'phonecode'           => '229', ]);
467
        CountryCode::create(['id' => '24',
468
            'iso'                 => 'BM',
469
            'name'                => 'BERMUDA',
470
            'nicename'            => 'Bermuda',
471
            'iso3'                => 'BMU',
472
            'numcode'             => '60',
473
            'phonecode'           => '1441', ]);
474
        CountryCode::create(['id' => '25',
475
            'iso'                 => 'BT',
476
            'name'                => 'BHUTAN',
477
            'nicename'            => 'Bhutan',
478
            'iso3'                => 'BTN',
479
            'numcode'             => '64',
480
            'phonecode'           => '975', ]);
481
        CountryCode::create(['id' => '26',
482
            'iso'                 => 'BO',
483
            'name'                => 'BOLIVIA',
484
            'nicename'            => 'Bolivia',
485
            'iso3'                => 'BOL',
486
            'numcode'             => '68',
487
            'phonecode'           => '591', ]);
488
        CountryCode::create(['id' => '27',
489
            'iso'                 => 'BA',
490
            'name'                => 'BOSNIA AND HERZEGOVINA',
491
            'nicename'            => 'Bosnia and Herzegovina',
492
            'iso3'                => 'BIH',
493
            'numcode'             => '70',
494
            'phonecode'           => '387', ]);
495
        CountryCode::create(['id' => '28',
496
            'iso'                 => 'BW',
497
            'name'                => 'BOTSWANA',
498
            'nicename'            => 'Botswana',
499
            'iso3'                => 'BWA',
500
            'numcode'             => '72',
501
            'phonecode'           => '267', ]);
502
        CountryCode::create(['id' => '29',
503
            'iso'                 => 'BV',
504
            'name'                => 'BOUVET ISLAND',
505
            'nicename'            => 'Bouvet Island',
506
            'iso3'                => 'NULL',
507
            'numcode'             => 'NULL',
508
            'phonecode'           => '0', ]);
509
        CountryCode::create(['id' => '30',
510
            'iso'                 => 'BR',
511
            'name'                => 'BRAZIL',
512
            'nicename'            => 'Brazil',
513
            'iso3'                => 'BRA',
514
            'numcode'             => '76',
515
            'phonecode'           => '55', ]);
516
        CountryCode::create(['id' => '31',
517
            'iso'                 => 'IO',
518
            'name'                => 'BRITISH INDIAN OCEAN TERRITORY',
519
            'nicename'            => 'British Indian Ocean Territory',
520
            'iso3'                => 'NULL',
521
            'numcode'             => 'NULL',
522
            'phonecode'           => '246', ]);
523
        CountryCode::create(['id' => '32',
524
            'iso'                 => 'BN',
525
            'name'                => 'BRUNEI DARUSSALAM',
526
            'nicename'            => 'Brunei Darussalam',
527
            'iso3'                => 'BRN',
528
            'numcode'             => '96',
529
            'phonecode'           => '673', ]);
530
        CountryCode::create(['id' => '33',
531
            'iso'                 => 'BG',
532
            'name'                => 'BULGARIA',
533
            'nicename'            => 'Bulgaria',
534
            'iso3'                => 'BGR',
535
            'numcode'             => '100',
536
            'phonecode'           => '359', ]);
537
        CountryCode::create(['id' => '34',
538
            'iso'                 => 'BF',
539
            'name'                => 'BURKINA FASO',
540
            'nicename'            => 'Burkina Faso',
541
            'iso3'                => 'BFA',
542
            'numcode'             => '854',
543
            'phonecode'           => '226', ]);
544
        CountryCode::create(['id' => '35',
545
            'iso'                 => 'BI',
546
            'name'                => 'BURUNDI',
547
            'nicename'            => 'Burundi',
548
            'iso3'                => 'BDI',
549
            'numcode'             => '108',
550
            'phonecode'           => '257', ]);
551
        CountryCode::create(['id' => '36',
552
            'iso'                 => 'KH',
553
            'name'                => 'CAMBODIA',
554
            'nicename'            => 'Cambodia',
555
            'iso3'                => 'KHM',
556
            'numcode'             => '116',
557
            'phonecode'           => '855', ]);
558
        CountryCode::create(['id' => '37',
559
            'iso'                 => 'CM',
560
            'name'                => 'CAMEROON',
561
            'nicename'            => 'Cameroon',
562
            'iso3'                => 'CMR',
563
            'numcode'             => '120',
564
            'phonecode'           => '237', ]);
565
        CountryCode::create(['id' => '38',
566
            'iso'                 => 'CA',
567
            'name'                => 'CANADA',
568
            'nicename'            => 'Canada',
569
            'iso3'                => 'CAN',
570
            'numcode'             => '124',
571
            'phonecode'           => '1', ]);
572
        CountryCode::create(['id' => '39',
573
            'iso'                 => 'CV',
574
            'name'                => 'CAPE VERDE',
575
            'nicename'            => 'Cape Verde',
576
            'iso3'                => 'CPV',
577
            'numcode'             => '132',
578
            'phonecode'           => '238', ]);
579
        CountryCode::create(['id' => '40',
580
            'iso'                 => 'KY',
581
            'name'                => 'CAYMAN ISLANDS',
582
            'nicename'            => 'Cayman Islands',
583
            'iso3'                => 'CYM',
584
            'numcode'             => '136',
585
            'phonecode'           => '1345', ]);
586
        CountryCode::create(['id' => '41',
587
            'iso'                 => 'CF',
588
            'name'                => 'CENTRAL AFRICAN REPUBLIC',
589
            'nicename'            => 'Central African Republic',
590
            'iso3'                => 'CAF',
591
            'numcode'             => '140',
592
            'phonecode'           => '236', ]);
593
        CountryCode::create(['id' => '42',
594
            'iso'                 => 'TD',
595
            'name'                => 'CHAD',
596
            'nicename'            => 'Chad',
597
            'iso3'                => 'TCD',
598
            'numcode'             => '148',
599
            'phonecode'           => '235', ]);
600
        CountryCode::create(['id' => '43',
601
            'iso'                 => 'CL',
602
            'name'                => 'CHILE',
603
            'nicename'            => 'Chile',
604
            'iso3'                => 'CHL',
605
            'numcode'             => '152',
606
            'phonecode'           => '56', ]);
607
        CountryCode::create(['id' => '44',
608
            'iso'                 => 'CN',
609
            'name'                => 'CHINA',
610
            'nicename'            => 'China',
611
            'iso3'                => 'CHN',
612
            'numcode'             => '156',
613
            'phonecode'           => '86', ]);
614
        CountryCode::create(['id' => '45',
615
            'iso'                 => 'CX',
616
            'name'                => 'CHRISTMAS ISLAND',
617
            'nicename'            => 'Christmas Island',
618
            'iso3'                => 'NULL',
619
            'numcode'             => 'NULL',
620
            'phonecode'           => '61', ]);
621
        CountryCode::create(['id' => '46',
622
            'iso'                 => 'CC',
623
            'name'                => 'COCOS (KEELING) ISLANDS',
624
            'nicename'            => 'Cocos (Keeling) Islands',
625
            'iso3'                => 'NULL',
626
            'numcode'             => 'NULL',
627
            'phonecode'           => '672', ]);
628
        CountryCode::create(['id' => '47',
629
            'iso'                 => 'CO',
630
            'name'                => 'COLOMBIA',
631
            'nicename'            => 'Colombia',
632
            'iso3'                => 'COL',
633
            'numcode'             => '170',
634
            'phonecode'           => '57', ]);
635
        CountryCode::create(['id' => '48',
636
            'iso'                 => 'KM',
637
            'name'                => 'COMOROS',
638
            'nicename'            => 'Comoros',
639
            'iso3'                => 'COM',
640
            'numcode'             => '174',
641
            'phonecode'           => '269', ]);
642
        CountryCode::create(['id' => '49',
643
            'iso'                 => 'CG',
644
            'name'                => 'CONGO',
645
            'nicename'            => 'Congo',
646
            'iso3'                => 'COG',
647
            'numcode'             => '178',
648
            'phonecode'           => '242', ]);
649
        CountryCode::create(['id' => '50',
650
            'iso'                 => 'CD',
651
            'name'                => 'CONGO, THE DEMOCRATIC REPUBLIC OF THE',
652
            'nicename'            => 'Congo, the Democratic Republic of the',
653
            'iso3'                => 'COD',
654
            'numcode'             => '180',
655
            'phonecode'           => '242', ]);
656
        CountryCode::create(['id' => '51',
657
            'iso'                 => 'CK',
658
            'name'                => 'COOK ISLANDS',
659
            'nicename'            => 'Cook Islands',
660
            'iso3'                => 'COK',
661
            'numcode'             => '184',
662
            'phonecode'           => '682', ]);
663
        CountryCode::create(['id' => '52',
664
            'iso'                 => 'CR',
665
            'name'                => 'COSTA RICA',
666
            'nicename'            => 'Costa Rica',
667
            'iso3'                => 'CRI',
668
            'numcode'             => '188',
669
            'phonecode'           => '506', ]);
670
        CountryCode::create(['id' => '53',
671
            'iso'                 => 'CI',
672
            'name'                => 'COTE DIVOIRE',
673
            'nicename'            => 'Cote DIvoire',
674
            'iso3'                => 'CIV',
675
            'numcode'             => '384',
676
            'phonecode'           => '225', ]);
677
        CountryCode::create(['id' => '54',
678
            'iso'                 => 'HR',
679
            'name'                => 'CROATIA',
680
            'nicename'            => 'Croatia',
681
            'iso3'                => 'HRV',
682
            'numcode'             => '191',
683
            'phonecode'           => '385', ]);
684
        CountryCode::create(['id' => '55',
685
            'iso'                 => 'CU',
686
            'name'                => 'CUBA',
687
            'nicename'            => 'Cuba',
688
            'iso3'                => 'CUB',
689
            'numcode'             => '192',
690
            'phonecode'           => '53', ]);
691
        CountryCode::create(['id' => '56',
692
            'iso'                 => 'CY',
693
            'name'                => 'CYPRUS',
694
            'nicename'            => 'Cyprus',
695
            'iso3'                => 'CYP',
696
            'numcode'             => '196',
697
            'phonecode'           => '357', ]);
698
        CountryCode::create(['id' => '57',
699
            'iso'                 => 'CZ',
700
            'name'                => 'CZECH REPUBLIC',
701
            'nicename'            => 'Czech Republic',
702
            'iso3'                => 'CZE',
703
            'numcode'             => '203',
704
            'phonecode'           => '420', ]);
705
        CountryCode::create(['id' => '58',
706
            'iso'                 => 'DK',
707
            'name'                => 'DENMARK',
708
            'nicename'            => 'Denmark',
709
            'iso3'                => 'DNK',
710
            'numcode'             => '208',
711
            'phonecode'           => '45', ]);
712
        CountryCode::create(['id' => '59',
713
            'iso'                 => 'DJ',
714
            'name'                => 'DJIBOUTI',
715
            'nicename'            => 'Djibouti',
716
            'iso3'                => 'DJI',
717
            'numcode'             => '262',
718
            'phonecode'           => '253', ]);
719
        CountryCode::create(['id' => '60',
720
            'iso'                 => 'DM',
721
            'name'                => 'DOMINICA',
722
            'nicename'            => 'Dominica',
723
            'iso3'                => 'DMA',
724
            'numcode'             => '212',
725
            'phonecode'           => '1767', ]);
726
        CountryCode::create(['id' => '61',
727
            'iso'                 => 'DO',
728
            'name'                => 'DOMINICAN REPUBLIC',
729
            'nicename'            => 'Dominican Republic',
730
            'iso3'                => 'DOM',
731
            'numcode'             => '214',
732
            'phonecode'           => '1809', ]);
733
        CountryCode::create(['id' => '62',
734
            'iso'                 => 'EC',
735
            'name'                => 'ECUADOR',
736
            'nicename'            => 'Ecuador',
737
            'iso3'                => 'ECU',
738
            'numcode'             => '218',
739
            'phonecode'           => '593', ]);
740
        CountryCode::create(['id' => '63',
741
            'iso'                 => 'EG',
742
            'name'                => 'EGYPT',
743
            'nicename'            => 'Egypt',
744
            'iso3'                => 'EGY',
745
            'numcode'             => '818',
746
            'phonecode'           => '20', ]);
747
        CountryCode::create(['id' => '64',
748
            'iso'                 => 'SV',
749
            'name'                => 'EL SALVADOR',
750
            'nicename'            => 'El Salvador',
751
            'iso3'                => 'SLV',
752
            'numcode'             => '222',
753
            'phonecode'           => '503', ]);
754
        CountryCode::create(['id' => '65',
755
            'iso'                 => 'GQ',
756
            'name'                => 'EQUATORIAL GUINEA',
757
            'nicename'            => 'Equatorial Guinea',
758
            'iso3'                => 'GNQ',
759
            'numcode'             => '226',
760
            'phonecode'           => '240', ]);
761
        CountryCode::create(['id' => '66',
762
            'iso'                 => 'ER',
763
            'name'                => 'ERITREA',
764
            'nicename'            => 'Eritrea',
765
            'iso3'                => 'ERI',
766
            'numcode'             => '232',
767
            'phonecode'           => '291', ]);
768
        CountryCode::create(['id' => '67',
769
            'iso'                 => 'EE',
770
            'name'                => 'ESTONIA',
771
            'nicename'            => 'Estonia',
772
            'iso3'                => 'EST',
773
            'numcode'             => '233',
774
            'phonecode'           => '372', ]);
775
        CountryCode::create(['id' => '68',
776
            'iso'                 => 'ET',
777
            'name'                => 'ETHIOPIA',
778
            'nicename'            => 'Ethiopia',
779
            'iso3'                => 'ETH',
780
            'numcode'             => '231',
781
            'phonecode'           => '251', ]);
782
        CountryCode::create(['id' => '69',
783
            'iso'                 => 'FK',
784
            'name'                => 'FALKLAND ISLANDS (MALVINAS)',
785
            'nicename'            => 'Falkland Islands (Malvinas)',
786
            'iso3'                => 'FLK',
787
            'numcode'             => '238',
788
            'phonecode'           => '500', ]);
789
        CountryCode::create(['id' => '70',
790
            'iso'                 => 'FO',
791
            'name'                => 'FAROE ISLANDS',
792
            'nicename'            => 'Faroe Islands',
793
            'iso3'                => 'FRO',
794
            'numcode'             => '234',
795
            'phonecode'           => '298', ]);
796
        CountryCode::create(['id' => '71',
797
            'iso'                 => 'FJ',
798
            'name'                => 'FIJI',
799
            'nicename'            => 'Fiji',
800
            'iso3'                => 'FJI',
801
            'numcode'             => '242',
802
            'phonecode'           => '679', ]);
803
        CountryCode::create(['id' => '72',
804
            'iso'                 => 'FI',
805
            'name'                => 'FINLAND',
806
            'nicename'            => 'Finland',
807
            'iso3'                => 'FIN',
808
            'numcode'             => '246',
809
            'phonecode'           => '358', ]);
810
        CountryCode::create(['id' => '73',
811
            'iso'                 => 'FR',
812
            'name'                => 'FRANCE',
813
            'nicename'            => 'France',
814
            'iso3'                => 'FRA',
815
            'numcode'             => '250',
816
            'phonecode'           => '33', ]);
817
        CountryCode::create(['id' => '74',
818
            'iso'                 => 'GF',
819
            'name'                => 'FRENCH GUIANA',
820
            'nicename'            => 'French Guiana',
821
            'iso3'                => 'GUF',
822
            'numcode'             => '254',
823
            'phonecode'           => '594', ]);
824
        CountryCode::create(['id' => '75',
825
            'iso'                 => 'PF',
826
            'name'                => 'FRENCH POLYNESIA',
827
            'nicename'            => 'French Polynesia',
828
            'iso3'                => 'PYF',
829
            'numcode'             => '258',
830
            'phonecode'           => '689', ]);
831
        CountryCode::create(['id' => '76',
832
            'iso'                 => 'TF',
833
            'name'                => 'FRENCH SOUTHERN TERRITORIES',
834
            'nicename'            => 'French Southern Territories',
835
            'iso3'                => 'NULL',
836
            'numcode'             => 'NULL',
837
            'phonecode'           => '0', ]);
838
        CountryCode::create(['id' => '77',
839
            'iso'                 => 'GA',
840
            'name'                => 'GABON',
841
            'nicename'            => 'Gabon',
842
            'iso3'                => 'GAB',
843
            'numcode'             => '266',
844
            'phonecode'           => '241', ]);
845
        CountryCode::create(['id' => '78',
846
            'iso'                 => 'GM',
847
            'name'                => 'GAMBIA',
848
            'nicename'            => 'Gambia',
849
            'iso3'                => 'GMB',
850
            'numcode'             => '270',
851
            'phonecode'           => '220', ]);
852
        CountryCode::create(['id' => '79',
853
            'iso'                 => 'GE',
854
            'name'                => 'GEORGIA',
855
            'nicename'            => 'Georgia',
856
            'iso3'                => 'GEO',
857
            'numcode'             => '268',
858
            'phonecode'           => '995', ]);
859
        CountryCode::create(['id' => '80',
860
            'iso'                 => 'DE',
861
            'name'                => 'GERMANY',
862
            'nicename'            => 'Germany',
863
            'iso3'                => 'DEU',
864
            'numcode'             => '276',
865
            'phonecode'           => '49', ]);
866
        CountryCode::create(['id' => '81',
867
            'iso'                 => 'GH',
868
            'name'                => 'GHANA',
869
            'nicename'            => 'Ghana',
870
            'iso3'                => 'GHA',
871
            'numcode'             => '288',
872
            'phonecode'           => '233', ]);
873
        CountryCode::create(['id' => '82',
874
            'iso'                 => 'GI',
875
            'name'                => 'GIBRALTAR',
876
            'nicename'            => 'Gibraltar',
877
            'iso3'                => 'GIB',
878
            'numcode'             => '292',
879
            'phonecode'           => '350', ]);
880
        CountryCode::create(['id' => '83',
881
            'iso'                 => 'GR',
882
            'name'                => 'GREECE',
883
            'nicename'            => 'Greece',
884
            'iso3'                => 'GRC',
885
            'numcode'             => '300',
886
            'phonecode'           => '30', ]);
887
        CountryCode::create(['id' => '84',
888
            'iso'                 => 'GL',
889
            'name'                => 'GREENLAND',
890
            'nicename'            => 'Greenland',
891
            'iso3'                => 'GRL',
892
            'numcode'             => '304',
893
            'phonecode'           => '299', ]);
894
        CountryCode::create(['id' => '85',
895
            'iso'                 => 'GD',
896
            'name'                => 'GRENADA',
897
            'nicename'            => 'Grenada',
898
            'iso3'                => 'GRD',
899
            'numcode'             => '308',
900
            'phonecode'           => '1473', ]);
901
        CountryCode::create(['id' => '86',
902
            'iso'                 => 'GP',
903
            'name'                => 'GUADELOUPE',
904
            'nicename'            => 'Guadeloupe',
905
            'iso3'                => 'GLP',
906
            'numcode'             => '312',
907
            'phonecode'           => '590', ]);
908
        CountryCode::create(['id' => '87',
909
            'iso'                 => 'GU',
910
            'name'                => 'GUAM',
911
            'nicename'            => 'Guam',
912
            'iso3'                => 'GUM',
913
            'numcode'             => '316',
914
            'phonecode'           => '1671', ]);
915
        CountryCode::create(['id' => '88',
916
            'iso'                 => 'GT',
917
            'name'                => 'GUATEMALA',
918
            'nicename'            => 'Guatemala',
919
            'iso3'                => 'GTM',
920
            'numcode'             => '320',
921
            'phonecode'           => '502', ]);
922
        CountryCode::create(['id' => '89',
923
            'iso'                 => 'GN',
924
            'name'                => 'GUINEA',
925
            'nicename'            => 'Guinea',
926
            'iso3'                => 'GIN',
927
            'numcode'             => '324',
928
            'phonecode'           => '224', ]);
929
        CountryCode::create(['id' => '90',
930
            'iso'                 => 'GW',
931
            'name'                => 'GUINEA-BISSAU',
932
            'nicename'            => 'Guinea-Bissau',
933
            'iso3'                => 'GNB',
934
            'numcode'             => '624',
935
            'phonecode'           => '245', ]);
936
        CountryCode::create(['id' => '91',
937
            'iso'                 => 'GY',
938
            'name'                => 'GUYANA',
939
            'nicename'            => 'Guyana',
940
            'iso3'                => 'GUY',
941
            'numcode'             => '328',
942
            'phonecode'           => '592', ]);
943
        CountryCode::create(['id' => '92',
944
            'iso'                 => 'HT',
945
            'name'                => 'HAITI',
946
            'nicename'            => 'Haiti',
947
            'iso3'                => 'HTI',
948
            'numcode'             => '332',
949
            'phonecode'           => '509', ]);
950
        CountryCode::create(['id' => '93',
951
            'iso'                 => 'HM',
952
            'name'                => 'HEARD ISLAND AND MCDONALD ISLANDS',
953
            'nicename'            => 'Heard Island and Mcdonald Islands',
954
            'iso3'                => 'NULL',
955
            'numcode'             => 'NULL',
956
            'phonecode'           => '0', ]);
957
        CountryCode::create(['id' => '94',
958
            'iso'                 => 'VA',
959
            'name'                => 'HOLY SEE (VATICAN CITY STATE)',
960
            'nicename'            => 'Holy See (Vatican City State)',
961
            'iso3'                => 'VAT',
962
            'numcode'             => '336',
963
            'phonecode'           => '39', ]);
964
        CountryCode::create(['id' => '95',
965
            'iso'                 => 'HN',
966
            'name'                => 'HONDURAS',
967
            'nicename'            => 'Honduras',
968
            'iso3'                => 'HND',
969
            'numcode'             => '340',
970
            'phonecode'           => '504', ]);
971
        CountryCode::create(['id' => '96',
972
            'iso'                 => 'HK',
973
            'name'                => 'HONG KONG',
974
            'nicename'            => 'Hong Kong',
975
            'iso3'                => 'HKG',
976
            'numcode'             => '344',
977
            'phonecode'           => '852', ]);
978
        CountryCode::create(['id' => '97',
979
            'iso'                 => 'HU',
980
            'name'                => 'HUNGARY',
981
            'nicename'            => 'Hungary',
982
            'iso3'                => 'HUN',
983
            'numcode'             => '348',
984
            'phonecode'           => '36', ]);
985
        CountryCode::create(['id' => '98',
986
            'iso'                 => 'IS',
987
            'name'                => 'ICELAND',
988
            'nicename'            => 'Iceland',
989
            'iso3'                => 'ISL',
990
            'numcode'             => '352',
991
            'phonecode'           => '354', ]);
992
        CountryCode::create(['id' => '99',
993
            'iso'                 => 'IN',
994
            'name'                => 'INDIA',
995
            'nicename'            => 'India',
996
            'iso3'                => 'IND',
997
            'numcode'             => '356',
998
            'phonecode'           => '91', ]);
999
        CountryCode::create(['id' => '100',
1000
            'iso'                 => 'ID',
1001
            'name'                => 'INDONESIA',
1002
            'nicename'            => 'Indonesia',
1003
            'iso3'                => 'IDN',
1004
            'numcode'             => '360',
1005
            'phonecode'           => '62', ]);
1006
        CountryCode::create(['id' => '101',
1007
            'iso'                 => 'IR',
1008
            'name'                => 'IRAN, ISLAMIC REPUBLIC OF',
1009
            'nicename'            => 'Iran, Islamic Republic of',
1010
            'iso3'                => 'IRN',
1011
            'numcode'             => '364',
1012
            'phonecode'           => '98', ]);
1013
        CountryCode::create(['id' => '102',
1014
            'iso'                 => 'IQ',
1015
            'name'                => 'IRAQ',
1016
            'nicename'            => 'Iraq',
1017
            'iso3'                => 'IRQ',
1018
            'numcode'             => '368',
1019
            'phonecode'           => '964', ]);
1020
        CountryCode::create(['id' => '103',
1021
            'iso'                 => 'IE',
1022
            'name'                => 'IRELAND',
1023
            'nicename'            => 'Ireland',
1024
            'iso3'                => 'IRL',
1025
            'numcode'             => '372',
1026
            'phonecode'           => '353', ]);
1027
        CountryCode::create(['id' => '104',
1028
            'iso'                 => 'IL',
1029
            'name'                => 'ISRAEL',
1030
            'nicename'            => 'Israel',
1031
            'iso3'                => 'ISR',
1032
            'numcode'             => '376',
1033
            'phonecode'           => '972', ]);
1034
        CountryCode::create(['id' => '105',
1035
            'iso'                 => 'IT',
1036
            'name'                => 'ITALY',
1037
            'nicename'            => 'Italy',
1038
            'iso3'                => 'ITA',
1039
            'numcode'             => '380',
1040
            'phonecode'           => '39', ]);
1041
        CountryCode::create(['id' => '106',
1042
            'iso'                 => 'JM',
1043
            'name'                => 'JAMAICA',
1044
            'nicename'            => 'Jamaica',
1045
            'iso3'                => 'JAM',
1046
            'numcode'             => '388',
1047
            'phonecode'           => '1876', ]);
1048
        CountryCode::create(['id' => '107',
1049
            'iso'                 => 'JP',
1050
            'name'                => 'JAPAN',
1051
            'nicename'            => 'Japan',
1052
            'iso3'                => 'JPN',
1053
            'numcode'             => '392',
1054
            'phonecode'           => '81', ]);
1055
        CountryCode::create(['id' => '108',
1056
            'iso'                 => 'JO',
1057
            'name'                => 'JORDAN',
1058
            'nicename'            => 'Jordan',
1059
            'iso3'                => 'JOR',
1060
            'numcode'             => '400',
1061
            'phonecode'           => '962', ]);
1062
        CountryCode::create(['id' => '109',
1063
            'iso'                 => 'KZ',
1064
            'name'                => 'KAZAKHSTAN',
1065
            'nicename'            => 'Kazakhstan',
1066
            'iso3'                => 'KAZ',
1067
            'numcode'             => '398',
1068
            'phonecode'           => '7', ]);
1069
        CountryCode::create(['id' => '110',
1070
            'iso'                 => 'KE',
1071
            'name'                => 'KENYA',
1072
            'nicename'            => 'Kenya',
1073
            'iso3'                => 'KEN',
1074
            'numcode'             => '404',
1075
            'phonecode'           => '254', ]);
1076
        CountryCode::create(['id' => '111',
1077
            'iso'                 => 'KI',
1078
            'name'                => 'KIRIBATI',
1079
            'nicename'            => 'Kiribati',
1080
            'iso3'                => 'KIR',
1081
            'numcode'             => '296',
1082
            'phonecode'           => '686', ]);
1083
        CountryCode::create(['id' => '112',
1084
            'iso'                 => 'KP',
1085
            'name'                => 'KOREA, DEMOCRATIC PEOPLES REPUBLIC OF',
1086
            'nicename'            => 'Korea, Democratic Peoples Republic of',
1087
            'iso3'                => 'PRK',
1088
            'numcode'             => '408',
1089
            'phonecode'           => '850', ]);
1090
        CountryCode::create(['id' => '113',
1091
            'iso'                 => 'KR',
1092
            'name'                => 'KOREA, REPUBLIC OF',
1093
            'nicename'            => 'Korea, Republic of',
1094
            'iso3'                => 'KOR',
1095
            'numcode'             => '410',
1096
            'phonecode'           => '82', ]);
1097
        CountryCode::create(['id' => '114',
1098
            'iso'                 => 'KW',
1099
            'name'                => 'KUWAIT',
1100
            'nicename'            => 'Kuwait',
1101
            'iso3'                => 'KWT',
1102
            'numcode'             => '414',
1103
            'phonecode'           => '965', ]);
1104
        CountryCode::create(['id' => '115',
1105
            'iso'                 => 'KG',
1106
            'name'                => 'KYRGYZSTAN',
1107
            'nicename'            => 'Kyrgyzstan',
1108
            'iso3'                => 'KGZ',
1109
            'numcode'             => '417',
1110
            'phonecode'           => '996', ]);
1111
        CountryCode::create(['id' => '116',
1112
            'iso'                 => 'LA',
1113
            'name'                => 'LAO PEOPLES DEMOCRATIC REPUBLIC',
1114
            'nicename'            => 'Lao Peoples Democratic Republic',
1115
            'iso3'                => 'LAO',
1116
            'numcode'             => '418',
1117
            'phonecode'           => '856', ]);
1118
        CountryCode::create(['id' => '117',
1119
            'iso'                 => 'LV',
1120
            'name'                => 'LATVIA',
1121
            'nicename'            => 'Latvia',
1122
            'iso3'                => 'LVA',
1123
            'numcode'             => '428',
1124
            'phonecode'           => '371', ]);
1125
        CountryCode::create(['id' => '118',
1126
            'iso'                 => 'LB',
1127
            'name'                => 'LEBANON',
1128
            'nicename'            => 'Lebanon',
1129
            'iso3'                => 'LBN',
1130
            'numcode'             => '422',
1131
            'phonecode'           => '961', ]);
1132
        CountryCode::create(['id' => '119',
1133
            'iso'                 => 'LS',
1134
            'name'                => 'LESOTHO',
1135
            'nicename'            => 'Lesotho',
1136
            'iso3'                => 'LSO',
1137
            'numcode'             => '426',
1138
            'phonecode'           => '266', ]);
1139
        CountryCode::create(['id' => '120',
1140
            'iso'                 => 'LR',
1141
            'name'                => 'LIBERIA',
1142
            'nicename'            => 'Liberia',
1143
            'iso3'                => 'LBR',
1144
            'numcode'             => '430',
1145
            'phonecode'           => '231', ]);
1146
        CountryCode::create(['id' => '121',
1147
            'iso'                 => 'LY',
1148
            'name'                => 'LIBYAN ARAB JAMAHIRIYA',
1149
            'nicename'            => 'Libyan Arab Jamahiriya',
1150
            'iso3'                => 'LBY',
1151
            'numcode'             => '434',
1152
            'phonecode'           => '218', ]);
1153
        CountryCode::create(['id' => '122',
1154
            'iso'                 => 'LI',
1155
            'name'                => 'LIECHTENSTEIN',
1156
            'nicename'            => 'Liechtenstein',
1157
            'iso3'                => 'LIE',
1158
            'numcode'             => '438',
1159
            'phonecode'           => '423', ]);
1160
        CountryCode::create(['id' => '123',
1161
            'iso'                 => 'LT',
1162
            'name'                => 'LITHUANIA',
1163
            'nicename'            => 'Lithuania',
1164
            'iso3'                => 'LTU',
1165
            'numcode'             => '440',
1166
            'phonecode'           => '370', ]);
1167
        CountryCode::create(['id' => '124',
1168
            'iso'                 => 'LU',
1169
            'name'                => 'LUXEMBOURG',
1170
            'nicename'            => 'Luxembourg',
1171
            'iso3'                => 'LUX',
1172
            'numcode'             => '442',
1173
            'phonecode'           => '352', ]);
1174
        CountryCode::create(['id' => '125',
1175
            'iso'                 => 'MO',
1176
            'name'                => 'MACAO',
1177
            'nicename'            => 'Macao',
1178
            'iso3'                => 'MAC',
1179
            'numcode'             => '446',
1180
            'phonecode'           => '853', ]);
1181
        CountryCode::create(['id' => '126',
1182
            'iso'                 => 'MK',
1183
            'name'                => 'MACEDONIA, THE FORMER YUGOSLAV REPUBLIC OF',
1184
            'nicename'            => 'Macedonia, the Former Yugoslav Republic of',
1185
            'iso3'                => 'MKD',
1186
            'numcode'             => '807',
1187
            'phonecode'           => '389', ]);
1188
        CountryCode::create(['id' => '127',
1189
            'iso'                 => 'MG',
1190
            'name'                => 'MADAGASCAR',
1191
            'nicename'            => 'Madagascar',
1192
            'iso3'                => 'MDG',
1193
            'numcode'             => '450',
1194
            'phonecode'           => '261', ]);
1195
        CountryCode::create(['id' => '128',
1196
            'iso'                 => 'MW',
1197
            'name'                => 'MALAWI',
1198
            'nicename'            => 'Malawi',
1199
            'iso3'                => 'MWI',
1200
            'numcode'             => '454',
1201
            'phonecode'           => '265', ]);
1202
        CountryCode::create(['id' => '129',
1203
            'iso'                 => 'MY',
1204
            'name'                => 'MALAYSIA',
1205
            'nicename'            => 'Malaysia',
1206
            'iso3'                => 'MYS',
1207
            'numcode'             => '458',
1208
            'phonecode'           => '60', ]);
1209
        CountryCode::create(['id' => '130',
1210
            'iso'                 => 'MV',
1211
            'name'                => 'MALDIVES',
1212
            'nicename'            => 'Maldives',
1213
            'iso3'                => 'MDV',
1214
            'numcode'             => '462',
1215
            'phonecode'           => '960', ]);
1216
        CountryCode::create(['id' => '131',
1217
            'iso'                 => 'ML',
1218
            'name'                => 'MALI',
1219
            'nicename'            => 'Mali',
1220
            'iso3'                => 'MLI',
1221
            'numcode'             => '466',
1222
            'phonecode'           => '223', ]);
1223
        CountryCode::create(['id' => '132',
1224
            'iso'                 => 'MT',
1225
            'name'                => 'MALTA',
1226
            'nicename'            => 'Malta',
1227
            'iso3'                => 'MLT',
1228
            'numcode'             => '470',
1229
            'phonecode'           => '356', ]);
1230
        CountryCode::create(['id' => '133',
1231
            'iso'                 => 'MH',
1232
            'name'                => 'MARSHALL ISLANDS',
1233
            'nicename'            => 'Marshall Islands',
1234
            'iso3'                => 'MHL',
1235
            'numcode'             => '584',
1236
            'phonecode'           => '692', ]);
1237
        CountryCode::create(['id' => '134',
1238
            'iso'                 => 'MQ',
1239
            'name'                => 'MARTINIQUE',
1240
            'nicename'            => 'Martinique',
1241
            'iso3'                => 'MTQ',
1242
            'numcode'             => '474',
1243
            'phonecode'           => '596', ]);
1244
        CountryCode::create(['id' => '135',
1245
            'iso'                 => 'MR',
1246
            'name'                => 'MAURITANIA',
1247
            'nicename'            => 'Mauritania',
1248
            'iso3'                => 'MRT',
1249
            'numcode'             => '478',
1250
            'phonecode'           => '222', ]);
1251
        CountryCode::create(['id' => '136',
1252
            'iso'                 => 'MU',
1253
            'name'                => 'MAURITIUS',
1254
            'nicename'            => 'Mauritius',
1255
            'iso3'                => 'MUS',
1256
            'numcode'             => '480',
1257
            'phonecode'           => '230', ]);
1258
        CountryCode::create(['id' => '137',
1259
            'iso'                 => 'YT',
1260
            'name'                => 'MAYOTTE',
1261
            'nicename'            => 'Mayotte',
1262
            'iso3'                => 'NULL',
1263
            'numcode'             => 'NULL',
1264
            'phonecode'           => '269', ]);
1265
        CountryCode::create(['id' => '138',
1266
            'iso'                 => 'MX',
1267
            'name'                => 'MEXICO',
1268
            'nicename'            => 'Mexico',
1269
            'iso3'                => 'MEX',
1270
            'numcode'             => '484',
1271
            'phonecode'           => '52', ]);
1272
        CountryCode::create(['id' => '139',
1273
            'iso'                 => 'FM',
1274
            'name'                => 'MICRONESIA, FEDERATED STATES OF',
1275
            'nicename'            => 'Micronesia, Federated States of',
1276
            'iso3'                => 'FSM',
1277
            'numcode'             => '583',
1278
            'phonecode'           => '691', ]);
1279
        CountryCode::create(['id' => '140',
1280
            'iso'                 => 'MD',
1281
            'name'                => 'MOLDOVA, REPUBLIC OF',
1282
            'nicename'            => 'Moldova, Republic of',
1283
            'iso3'                => 'MDA',
1284
            'numcode'             => '498',
1285
            'phonecode'           => '373', ]);
1286
        CountryCode::create(['id' => '141',
1287
            'iso'                 => 'MC',
1288
            'name'                => 'MONACO',
1289
            'nicename'            => 'Monaco',
1290
            'iso3'                => 'MCO',
1291
            'numcode'             => '492',
1292
            'phonecode'           => '377', ]);
1293
        CountryCode::create(['id' => '142',
1294
            'iso'                 => 'MN',
1295
            'name'                => 'MONGOLIA',
1296
            'nicename'            => 'Mongolia',
1297
            'iso3'                => 'MNG',
1298
            'numcode'             => '496',
1299
            'phonecode'           => '976', ]);
1300
        CountryCode::create(['id' => '143',
1301
            'iso'                 => 'MS',
1302
            'name'                => 'MONTSERRAT',
1303
            'nicename'            => 'Montserrat',
1304
            'iso3'                => 'MSR',
1305
            'numcode'             => '500',
1306
            'phonecode'           => '1664', ]);
1307
        CountryCode::create(['id' => '144',
1308
            'iso'                 => 'MA',
1309
            'name'                => 'MOROCCO',
1310
            'nicename'            => 'Morocco',
1311
            'iso3'                => 'MAR',
1312
            'numcode'             => '504',
1313
            'phonecode'           => '212', ]);
1314
        CountryCode::create(['id' => '145',
1315
            'iso'                 => 'MZ',
1316
            'name'                => 'MOZAMBIQUE',
1317
            'nicename'            => 'Mozambique',
1318
            'iso3'                => 'MOZ',
1319
            'numcode'             => '508',
1320
            'phonecode'           => '258', ]);
1321
        CountryCode::create(['id' => '146',
1322
            'iso'                 => 'MM',
1323
            'name'                => 'MYANMAR',
1324
            'nicename'            => 'Myanmar',
1325
            'iso3'                => 'MMR',
1326
            'numcode'             => '104',
1327
            'phonecode'           => '95', ]);
1328
        CountryCode::create(['id' => '147',
1329
            'iso'                 => 'NA',
1330
            'name'                => 'NAMIBIA',
1331
            'nicename'            => 'Namibia',
1332
            'iso3'                => 'NAM',
1333
            'numcode'             => '516',
1334
            'phonecode'           => '264', ]);
1335
        CountryCode::create(['id' => '148',
1336
            'iso'                 => 'NR',
1337
            'name'                => 'NAURU',
1338
            'nicename'            => 'Nauru',
1339
            'iso3'                => 'NRU',
1340
            'numcode'             => '520',
1341
            'phonecode'           => '674', ]);
1342
        CountryCode::create(['id' => '149',
1343
            'iso'                 => 'NP',
1344
            'name'                => 'NEPAL',
1345
            'nicename'            => 'Nepal',
1346
            'iso3'                => 'NPL',
1347
            'numcode'             => '524',
1348
            'phonecode'           => '977', ]);
1349
        CountryCode::create(['id' => '150',
1350
            'iso'                 => 'NL',
1351
            'name'                => 'NETHERLANDS',
1352
            'nicename'            => 'Netherlands',
1353
            'iso3'                => 'NLD',
1354
            'numcode'             => '528',
1355
            'phonecode'           => '31', ]);
1356
        CountryCode::create(['id' => '151',
1357
            'iso'                 => 'AN',
1358
            'name'                => 'NETHERLANDS ANTILLES',
1359
            'nicename'            => 'Netherlands Antilles',
1360
            'iso3'                => 'ANT',
1361
            'numcode'             => '530',
1362
            'phonecode'           => '599', ]);
1363
        CountryCode::create(['id' => '152',
1364
            'iso'                 => 'NC',
1365
            'name'                => 'NEW CALEDONIA',
1366
            'nicename'            => 'New Caledonia',
1367
            'iso3'                => 'NCL',
1368
            'numcode'             => '540',
1369
            'phonecode'           => '687', ]);
1370
        CountryCode::create(['id' => '153',
1371
            'iso'                 => 'NZ',
1372
            'name'                => 'NEW ZEALAND',
1373
            'nicename'            => 'New Zealand',
1374
            'iso3'                => 'NZL',
1375
            'numcode'             => '554',
1376
            'phonecode'           => '64', ]);
1377
        CountryCode::create(['id' => '154',
1378
            'iso'                 => 'NI',
1379
            'name'                => 'NICARAGUA',
1380
            'nicename'            => 'Nicaragua',
1381
            'iso3'                => 'NIC',
1382
            'numcode'             => '558',
1383
            'phonecode'           => '505', ]);
1384
        CountryCode::create(['id' => '155',
1385
            'iso'                 => 'NE',
1386
            'name'                => 'NIGER',
1387
            'nicename'            => 'Niger',
1388
            'iso3'                => 'NER',
1389
            'numcode'             => '562',
1390
            'phonecode'           => '227', ]);
1391
        CountryCode::create(['id' => '156',
1392
            'iso'                 => 'NG',
1393
            'name'                => 'NIGERIA',
1394
            'nicename'            => 'Nigeria',
1395
            'iso3'                => 'NGA',
1396
            'numcode'             => '566',
1397
            'phonecode'           => '234', ]);
1398
        CountryCode::create(['id' => '157',
1399
            'iso'                 => 'NU',
1400
            'name'                => 'NIUE',
1401
            'nicename'            => 'Niue',
1402
            'iso3'                => 'NIU',
1403
            'numcode'             => '570',
1404
            'phonecode'           => '683', ]);
1405
        CountryCode::create(['id' => '158',
1406
            'iso'                 => 'NF',
1407
            'name'                => 'NORFOLK ISLAND',
1408
            'nicename'            => 'Norfolk Island',
1409
            'iso3'                => 'NFK',
1410
            'numcode'             => '574',
1411
            'phonecode'           => '672', ]);
1412
        CountryCode::create(['id' => '159',
1413
            'iso'                 => 'MP',
1414
            'name'                => 'NORTHERN MARIANA ISLANDS',
1415
            'nicename'            => 'Northern Mariana Islands',
1416
            'iso3'                => 'MNP',
1417
            'numcode'             => '580',
1418
            'phonecode'           => '1670', ]);
1419
        CountryCode::create(['id' => '160',
1420
            'iso'                 => 'NO',
1421
            'name'                => 'NORWAY',
1422
            'nicename'            => 'Norway',
1423
            'iso3'                => 'NOR',
1424
            'numcode'             => '578',
1425
            'phonecode'           => '47', ]);
1426
        CountryCode::create(['id' => '161',
1427
            'iso'                 => 'OM',
1428
            'name'                => 'OMAN',
1429
            'nicename'            => 'Oman',
1430
            'iso3'                => 'OMN',
1431
            'numcode'             => '512',
1432
            'phonecode'           => '968', ]);
1433
        CountryCode::create(['id' => '162',
1434
            'iso'                 => 'PK',
1435
            'name'                => 'PAKISTAN',
1436
            'nicename'            => 'Pakistan',
1437
            'iso3'                => 'PAK',
1438
            'numcode'             => '586',
1439
            'phonecode'           => '92', ]);
1440
        CountryCode::create(['id' => '163',
1441
            'iso'                 => 'PW',
1442
            'name'                => 'PALAU',
1443
            'nicename'            => 'Palau',
1444
            'iso3'                => 'PLW',
1445
            'numcode'             => '585',
1446
            'phonecode'           => '680', ]);
1447
        CountryCode::create(['id' => '164',
1448
            'iso'                 => 'PS',
1449
            'name'                => 'PALESTINIAN TERRITORY, OCCUPIED',
1450
            'nicename'            => 'Palestinian Territory, Occupied',
1451
            'iso3'                => 'NULL',
1452
            'numcode'             => 'NULL',
1453
            'phonecode'           => '970', ]);
1454
        CountryCode::create(['id' => '165',
1455
            'iso'                 => 'PA',
1456
            'name'                => 'PANAMA',
1457
            'nicename'            => 'Panama',
1458
            'iso3'                => 'PAN',
1459
            'numcode'             => '591',
1460
            'phonecode'           => '507', ]);
1461
        CountryCode::create(['id' => '166',
1462
            'iso'                 => 'PG',
1463
            'name'                => 'PAPUA NEW GUINEA',
1464
            'nicename'            => 'Papua New Guinea',
1465
            'iso3'                => 'PNG',
1466
            'numcode'             => '598',
1467
            'phonecode'           => '675', ]);
1468
        CountryCode::create(['id' => '167',
1469
            'iso'                 => 'PY',
1470
            'name'                => 'PARAGUAY',
1471
            'nicename'            => 'Paraguay',
1472
            'iso3'                => 'PRY',
1473
            'numcode'             => '600',
1474
            'phonecode'           => '595', ]);
1475
        CountryCode::create(['id' => '168',
1476
            'iso'                 => 'PE',
1477
            'name'                => 'PERU',
1478
            'nicename'            => 'Peru',
1479
            'iso3'                => 'PER',
1480
            'numcode'             => '604',
1481
            'phonecode'           => '51', ]);
1482
        CountryCode::create(['id' => '169',
1483
            'iso'                 => 'PH',
1484
            'name'                => 'PHILIPPINES',
1485
            'nicename'            => 'Philippines',
1486
            'iso3'                => 'PHL',
1487
            'numcode'             => '608',
1488
            'phonecode'           => '63', ]);
1489
        CountryCode::create(['id' => '170',
1490
            'iso'                 => 'PN',
1491
            'name'                => 'PITCAIRN',
1492
            'nicename'            => 'Pitcairn',
1493
            'iso3'                => 'PCN',
1494
            'numcode'             => '612',
1495
            'phonecode'           => '0', ]);
1496
        CountryCode::create(['id' => '171',
1497
            'iso'                 => 'PL',
1498
            'name'                => 'POLAND',
1499
            'nicename'            => 'Poland',
1500
            'iso3'                => 'POL',
1501
            'numcode'             => '616',
1502
            'phonecode'           => '48', ]);
1503
        CountryCode::create(['id' => '172',
1504
            'iso'                 => 'PT',
1505
            'name'                => 'PORTUGAL',
1506
            'nicename'            => 'Portugal',
1507
            'iso3'                => 'PRT',
1508
            'numcode'             => '620',
1509
            'phonecode'           => '351', ]);
1510
        CountryCode::create(['id' => '173',
1511
            'iso'                 => 'PR',
1512
            'name'                => 'PUERTO RICO',
1513
            'nicename'            => 'Puerto Rico',
1514
            'iso3'                => 'PRI',
1515
            'numcode'             => '630',
1516
            'phonecode'           => '1787', ]);
1517
        CountryCode::create(['id' => '174',
1518
            'iso'                 => 'QA',
1519
            'name'                => 'QATAR',
1520
            'nicename'            => 'Qatar',
1521
            'iso3'                => 'QAT',
1522
            'numcode'             => '634',
1523
            'phonecode'           => '974', ]);
1524
        CountryCode::create(['id' => '175',
1525
            'iso'                 => 'RE',
1526
            'name'                => 'REUNION',
1527
            'nicename'            => 'Reunion',
1528
            'iso3'                => 'REU',
1529
            'numcode'             => '638',
1530
            'phonecode'           => '262', ]);
1531
        CountryCode::create(['id' => '176',
1532
            'iso'                 => 'RO',
1533
            'name'                => 'ROMANIA',
1534
            'nicename'            => 'Romania',
1535
            'iso3'                => 'ROM',
1536
            'numcode'             => '642',
1537
            'phonecode'           => '40', ]);
1538
        CountryCode::create(['id' => '177',
1539
            'iso'                 => 'RU',
1540
            'name'                => 'RUSSIAN FEDERATION',
1541
            'nicename'            => 'Russian Federation',
1542
            'iso3'                => 'RUS',
1543
            'numcode'             => '643',
1544
            'phonecode'           => '70', ]);
1545
        CountryCode::create(['id' => '178',
1546
            'iso'                 => 'RW',
1547
            'name'                => 'RWANDA',
1548
            'nicename'            => 'Rwanda',
1549
            'iso3'                => 'RWA',
1550
            'numcode'             => '646',
1551
            'phonecode'           => '250', ]);
1552
        CountryCode::create(['id' => '179',
1553
            'iso'                 => 'SH',
1554
            'name'                => 'SAINT HELENA',
1555
            'nicename'            => 'Saint Helena',
1556
            'iso3'                => 'SHN',
1557
            'numcode'             => '654',
1558
            'phonecode'           => '290', ]);
1559
        CountryCode::create(['id' => '180',
1560
            'iso'                 => 'KN',
1561
            'name'                => 'SAINT KITTS AND NEVIS',
1562
            'nicename'            => 'Saint Kitts and Nevis',
1563
            'iso3'                => 'KNA',
1564
            'numcode'             => '659',
1565
            'phonecode'           => '1869', ]);
1566
        CountryCode::create(['id' => '181',
1567
            'iso'                 => 'LC',
1568
            'name'                => 'SAINT LUCIA',
1569
            'nicename'            => 'Saint Lucia',
1570
            'iso3'                => 'LCA',
1571
            'numcode'             => '662',
1572
            'phonecode'           => '1758', ]);
1573
        CountryCode::create(['id' => '182',
1574
            'iso'                 => 'PM',
1575
            'name'                => 'SAINT PIERRE AND MIQUELON',
1576
            'nicename'            => 'Saint Pierre and Miquelon',
1577
            'iso3'                => 'SPM',
1578
            'numcode'             => '666',
1579
            'phonecode'           => '508', ]);
1580
        CountryCode::create(['id' => '183',
1581
            'iso'                 => 'VC',
1582
            'name'                => 'SAINT VINCENT AND THE GRENADINES',
1583
            'nicename'            => 'Saint Vincent and the Grenadines',
1584
            'iso3'                => 'VCT',
1585
            'numcode'             => '670',
1586
            'phonecode'           => '1784', ]);
1587
        CountryCode::create(['id' => '184',
1588
            'iso'                 => 'WS',
1589
            'name'                => 'SAMOA',
1590
            'nicename'            => 'Samoa',
1591
            'iso3'                => 'WSM',
1592
            'numcode'             => '882',
1593
            'phonecode'           => '684', ]);
1594
        CountryCode::create(['id' => '185',
1595
            'iso'                 => 'SM',
1596
            'name'                => 'SAN MARINO',
1597
            'nicename'            => 'San Marino',
1598
            'iso3'                => 'SMR',
1599
            'numcode'             => '674',
1600
            'phonecode'           => '378', ]);
1601
        CountryCode::create(['id' => '186',
1602
            'iso'                 => 'ST',
1603
            'name'                => 'SAO TOME AND PRINCIPE',
1604
            'nicename'            => 'Sao Tome and Principe',
1605
            'iso3'                => 'STP',
1606
            'numcode'             => '678',
1607
            'phonecode'           => '239', ]);
1608
        CountryCode::create(['id' => '187',
1609
            'iso'                 => 'SA',
1610
            'name'                => 'SAUDI ARABIA',
1611
            'nicename'            => 'Saudi Arabia',
1612
            'iso3'                => 'SAU',
1613
            'numcode'             => '682',
1614
            'phonecode'           => '966', ]);
1615
        CountryCode::create(['id' => '188',
1616
            'iso'                 => 'SN',
1617
            'name'                => 'SENEGAL',
1618
            'nicename'            => 'Senegal',
1619
            'iso3'                => 'SEN',
1620
            'numcode'             => '686',
1621
            'phonecode'           => '221', ]);
1622
        CountryCode::create(['id' => '189',
1623
            'iso'                 => 'CS',
1624
            'name'                => 'SERBIA AND MONTENEGRO',
1625
            'nicename'            => 'Serbia and Montenegro',
1626
            'iso3'                => 'NULL',
1627
            'numcode'             => 'NULL',
1628
            'phonecode'           => '381', ]);
1629
        CountryCode::create(['id' => '190',
1630
            'iso'                 => 'SC',
1631
            'name'                => 'SEYCHELLES',
1632
            'nicename'            => 'Seychelles',
1633
            'iso3'                => 'SYC',
1634
            'numcode'             => '690',
1635
            'phonecode'           => '248', ]);
1636
        CountryCode::create(['id' => '191',
1637
            'iso'                 => 'SL',
1638
            'name'                => 'SIERRA LEONE',
1639
            'nicename'            => 'Sierra Leone',
1640
            'iso3'                => 'SLE',
1641
            'numcode'             => '694',
1642
            'phonecode'           => '232', ]);
1643
        CountryCode::create(['id' => '192',
1644
            'iso'                 => 'SG',
1645
            'name'                => 'SINGAPORE',
1646
            'nicename'            => 'Singapore',
1647
            'iso3'                => 'SGP',
1648
            'numcode'             => '702',
1649
            'phonecode'           => '65', ]);
1650
        CountryCode::create(['id' => '193',
1651
            'iso'                 => 'SK',
1652
            'name'                => 'SLOVAKIA',
1653
            'nicename'            => 'Slovakia',
1654
            'iso3'                => 'SVK',
1655
            'numcode'             => '703',
1656
            'phonecode'           => '421', ]);
1657
        CountryCode::create(['id' => '194',
1658
            'iso'                 => 'SI',
1659
            'name'                => 'SLOVENIA',
1660
            'nicename'            => 'Slovenia',
1661
            'iso3'                => 'SVN',
1662
            'numcode'             => '705',
1663
            'phonecode'           => '386', ]);
1664
        CountryCode::create(['id' => '195',
1665
            'iso'                 => 'SB',
1666
            'name'                => 'SOLOMON ISLANDS',
1667
            'nicename'            => 'Solomon Islands',
1668
            'iso3'                => 'SLB',
1669
            'numcode'             => '90',
1670
            'phonecode'           => '677', ]);
1671
        CountryCode::create(['id' => '196',
1672
            'iso'                 => 'SO',
1673
            'name'                => 'SOMALIA',
1674
            'nicename'            => 'Somalia',
1675
            'iso3'                => 'SOM',
1676
            'numcode'             => '706',
1677
            'phonecode'           => '252', ]);
1678
        CountryCode::create(['id' => '197',
1679
            'iso'                 => 'ZA',
1680
            'name'                => 'SOUTH AFRICA',
1681
            'nicename'            => 'South Africa',
1682
            'iso3'                => 'ZAF',
1683
            'numcode'             => '710',
1684
            'phonecode'           => '27', ]);
1685
        CountryCode::create(['id' => '198',
1686
            'iso'                 => 'GS',
1687
            'name'                => 'SOUTH GEORGIA AND THE SOUTH SANDWICH ISLANDS',
1688
            'nicename'            => 'South Georgia and the South Sandwich Islands',
1689
            'iso3'                => 'NULL',
1690
            'numcode'             => 'NULL',
1691
            'phonecode'           => '0', ]);
1692
        CountryCode::create(['id' => '199',
1693
            'iso'                 => 'ES',
1694
            'name'                => 'SPAIN',
1695
            'nicename'            => 'Spain',
1696
            'iso3'                => 'ESP',
1697
            'numcode'             => '724',
1698
            'phonecode'           => '34', ]);
1699
        CountryCode::create(['id' => '200',
1700
            'iso'                 => 'LK',
1701
            'name'                => 'SRI LANKA',
1702
            'nicename'            => 'Sri Lanka',
1703
            'iso3'                => 'LKA',
1704
            'numcode'             => '144',
1705
            'phonecode'           => '94', ]);
1706
        CountryCode::create(['id' => '201',
1707
            'iso'                 => 'SD',
1708
            'name'                => 'SUDAN',
1709
            'nicename'            => 'Sudan',
1710
            'iso3'                => 'SDN',
1711
            'numcode'             => '736',
1712
            'phonecode'           => '249', ]);
1713
        CountryCode::create(['id' => '202',
1714
            'iso'                 => 'SR',
1715
            'name'                => 'SURINAME',
1716
            'nicename'            => 'Suriname',
1717
            'iso3'                => 'SUR',
1718
            'numcode'             => '740',
1719
            'phonecode'           => '597', ]);
1720
        CountryCode::create(['id' => '203',
1721
            'iso'                 => 'SJ',
1722
            'name'                => 'SVALBARD AND JAN MAYEN',
1723
            'nicename'            => 'Svalbard and Jan Mayen',
1724
            'iso3'                => 'SJM',
1725
            'numcode'             => '744',
1726
            'phonecode'           => '47', ]);
1727
        CountryCode::create(['id' => '204',
1728
            'iso'                 => 'SZ',
1729
            'name'                => 'SWAZILAND',
1730
            'nicename'            => 'Swaziland',
1731
            'iso3'                => 'SWZ',
1732
            'numcode'             => '748',
1733
            'phonecode'           => '268', ]);
1734
        CountryCode::create(['id' => '205',
1735
            'iso'                 => 'SE',
1736
            'name'                => 'SWEDEN',
1737
            'nicename'            => 'Sweden',
1738
            'iso3'                => 'SWE',
1739
            'numcode'             => '752',
1740
            'phonecode'           => '46', ]);
1741
        CountryCode::create(['id' => '206',
1742
            'iso'                 => 'CH',
1743
            'name'                => 'SWITZERLAND',
1744
            'nicename'            => 'Switzerland',
1745
            'iso3'                => 'CHE',
1746
            'numcode'             => '756',
1747
            'phonecode'           => '41', ]);
1748
        CountryCode::create(['id' => '207',
1749
            'iso'                 => 'SY',
1750
            'name'                => 'SYRIAN ARAB REPUBLIC',
1751
            'nicename'            => 'Syrian Arab Republic',
1752
            'iso3'                => 'SYR',
1753
            'numcode'             => '760',
1754
            'phonecode'           => '963', ]);
1755
        CountryCode::create(['id' => '208',
1756
            'iso'                 => 'TW',
1757
            'name'                => 'TAIWAN, PROVINCE OF CHINA',
1758
            'nicename'            => 'Taiwan, Province of China',
1759
            'iso3'                => 'TWN',
1760
            'numcode'             => '158',
1761
            'phonecode'           => '886', ]);
1762
        CountryCode::create(['id' => '209',
1763
            'iso'                 => 'TJ',
1764
            'name'                => 'TAJIKISTAN',
1765
            'nicename'            => 'Tajikistan',
1766
            'iso3'                => 'TJK',
1767
            'numcode'             => '762',
1768
            'phonecode'           => '992', ]);
1769
        CountryCode::create(['id' => '210',
1770
            'iso'                 => 'TZ',
1771
            'name'                => 'TANZANIA, UNITED REPUBLIC OF',
1772
            'nicename'            => 'Tanzania, United Republic of',
1773
            'iso3'                => 'TZA',
1774
            'numcode'             => '834',
1775
            'phonecode'           => '255', ]);
1776
        CountryCode::create(['id' => '211',
1777
            'iso'                 => 'TH',
1778
            'name'                => 'THAILAND',
1779
            'nicename'            => 'Thailand',
1780
            'iso3'                => 'THA',
1781
            'numcode'             => '764',
1782
            'phonecode'           => '66', ]);
1783
        CountryCode::create(['id' => '212',
1784
            'iso'                 => 'TL',
1785
            'name'                => 'TIMOR-LESTE',
1786
            'nicename'            => 'Timor-Leste',
1787
            'iso3'                => 'NULL',
1788
            'numcode'             => 'NULL',
1789
            'phonecode'           => '670', ]);
1790
        CountryCode::create(['id' => '213',
1791
            'iso'                 => 'TG',
1792
            'name'                => 'TOGO',
1793
            'nicename'            => 'Togo',
1794
            'iso3'                => 'TGO',
1795
            'numcode'             => '768',
1796
            'phonecode'           => '228', ]);
1797
        CountryCode::create(['id' => '214',
1798
            'iso'                 => 'TK',
1799
            'name'                => 'TOKELAU',
1800
            'nicename'            => 'Tokelau',
1801
            'iso3'                => 'TKL',
1802
            'numcode'             => '772',
1803
            'phonecode'           => '690', ]);
1804
        CountryCode::create(['id' => '215',
1805
            'iso'                 => 'TO',
1806
            'name'                => 'TONGA',
1807
            'nicename'            => 'Tonga',
1808
            'iso3'                => 'TON',
1809
            'numcode'             => '776',
1810
            'phonecode'           => '676', ]);
1811
        CountryCode::create(['id' => '216',
1812
            'iso'                 => 'TT',
1813
            'name'                => 'TRINIDAD AND TOBAGO',
1814
            'nicename'            => 'Trinidad and Tobago',
1815
            'iso3'                => 'TTO',
1816
            'numcode'             => '780',
1817
            'phonecode'           => '1868', ]);
1818
        CountryCode::create(['id' => '217',
1819
            'iso'                 => 'TN',
1820
            'name'                => 'TUNISIA',
1821
            'nicename'            => 'Tunisia',
1822
            'iso3'                => 'TUN',
1823
            'numcode'             => '788',
1824
            'phonecode'           => '216', ]);
1825
        CountryCode::create(['id' => '218',
1826
            'iso'                 => 'TR',
1827
            'name'                => 'TURKEY',
1828
            'nicename'            => 'Turkey',
1829
            'iso3'                => 'TUR',
1830
            'numcode'             => '792',
1831
            'phonecode'           => '90', ]);
1832
        CountryCode::create(['id' => '219',
1833
            'iso'                 => 'TM',
1834
            'name'                => 'TURKMENISTAN',
1835
            'nicename'            => 'Turkmenistan',
1836
            'iso3'                => 'TKM',
1837
            'numcode'             => '795',
1838
            'phonecode'           => '7370', ]);
1839
        CountryCode::create(['id' => '220',
1840
            'iso'                 => 'TC',
1841
            'name'                => 'TURKS AND CAICOS ISLANDS',
1842
            'nicename'            => 'Turks and Caicos Islands',
1843
            'iso3'                => 'TCA',
1844
            'numcode'             => '796',
1845
            'phonecode'           => '1649', ]);
1846
        CountryCode::create(['id' => '221',
1847
            'iso'                 => 'TV',
1848
            'name'                => 'TUVALU',
1849
            'nicename'            => 'Tuvalu',
1850
            'iso3'                => 'TUV',
1851
            'numcode'             => '798',
1852
            'phonecode'           => '688', ]);
1853
        CountryCode::create(['id' => '222',
1854
            'iso'                 => 'UG',
1855
            'name'                => 'UGANDA',
1856
            'nicename'            => 'Uganda',
1857
            'iso3'                => 'UGA',
1858
            'numcode'             => '800',
1859
            'phonecode'           => '256', ]);
1860
        CountryCode::create(['id' => '223',
1861
            'iso'                 => 'UA',
1862
            'name'                => 'UKRAINE',
1863
            'nicename'            => 'Ukraine',
1864
            'iso3'                => 'UKR',
1865
            'numcode'             => '804',
1866
            'phonecode'           => '380', ]);
1867
        CountryCode::create(['id' => '224',
1868
            'iso'                 => 'AE',
1869
            'name'                => 'UNITED ARAB EMIRATES',
1870
            'nicename'            => 'United Arab Emirates',
1871
            'iso3'                => 'ARE',
1872
            'numcode'             => '784',
1873
            'phonecode'           => '971', ]);
1874
        CountryCode::create(['id' => '225',
1875
            'iso'                 => 'GB',
1876
            'name'                => 'UNITED KINGDOM',
1877
            'nicename'            => 'United Kingdom',
1878
            'iso3'                => 'GBR',
1879
            'numcode'             => '826',
1880
            'phonecode'           => '44', ]);
1881
        CountryCode::create(['id' => '226',
1882
            'iso'                 => 'US',
1883
            'name'                => 'UNITED STATES',
1884
            'nicename'            => 'United States',
1885
            'iso3'                => 'USA',
1886
            'numcode'             => '840',
1887
            'phonecode'           => '1', ]);
1888
        CountryCode::create(['id' => '227',
1889
            'iso'                 => 'UM',
1890
            'name'                => 'UNITED STATES MINOR OUTLYING ISLANDS',
1891
            'nicename'            => 'United States Minor Outlying Islands',
1892
            'iso3'                => 'NULL',
1893
            'numcode'             => 'NULL',
1894
            'phonecode'           => '1', ]);
1895
        CountryCode::create(['id' => '228',
1896
            'iso'                 => 'UY',
1897
            'name'                => 'URUGUAY',
1898
            'nicename'            => 'Uruguay',
1899
            'iso3'                => 'URY',
1900
            'numcode'             => '858',
1901
            'phonecode'           => '598', ]);
1902
        CountryCode::create(['id' => '229',
1903
            'iso'                 => 'UZ',
1904
            'name'                => 'UZBEKISTAN',
1905
            'nicename'            => 'Uzbekistan',
1906
            'iso3'                => 'UZB',
1907
            'numcode'             => '860',
1908
            'phonecode'           => '998', ]);
1909
        CountryCode::create(['id' => '230',
1910
            'iso'                 => 'VU',
1911
            'name'                => 'VANUATU',
1912
            'nicename'            => 'Vanuatu',
1913
            'iso3'                => 'VUT',
1914
            'numcode'             => '548',
1915
            'phonecode'           => '678', ]);
1916
        CountryCode::create(['id' => '231',
1917
            'iso'                 => 'VE',
1918
            'name'                => 'VENEZUELA',
1919
            'nicename'            => 'Venezuela',
1920
            'iso3'                => 'VEN',
1921
            'numcode'             => '862',
1922
            'phonecode'           => '58', ]);
1923
        CountryCode::create(['id' => '232',
1924
            'iso'                 => 'VN',
1925
            'name'                => 'VIET NAM',
1926
            'nicename'            => 'Viet Nam',
1927
            'iso3'                => 'VNM',
1928
            'numcode'             => '704',
1929
            'phonecode'           => '84', ]);
1930
        CountryCode::create(['id' => '233',
1931
            'iso'                 => 'VG',
1932
            'name'                => 'VIRGIN ISLANDS, BRITISH',
1933
            'nicename'            => 'Virgin Islands, British',
1934
            'iso3'                => 'VGB',
1935
            'numcode'             => '92',
1936
            'phonecode'           => '1284', ]);
1937
        CountryCode::create(['id' => '234',
1938
            'iso'                 => 'VI',
1939
            'name'                => 'VIRGIN ISLANDS, U.S.',
1940
            'nicename'            => 'Virgin Islands, U.s.',
1941
            'iso3'                => 'VIR',
1942
            'numcode'             => '850',
1943
            'phonecode'           => '1340', ]);
1944
        CountryCode::create(['id' => '235',
1945
            'iso'                 => 'WF',
1946
            'name'                => 'WALLIS AND FUTUNA',
1947
            'nicename'            => 'Wallis and Futuna',
1948
            'iso3'                => 'WLF',
1949
            'numcode'             => '876',
1950
            'phonecode'           => '681', ]);
1951
        CountryCode::create(['id' => '236',
1952
            'iso'                 => 'EH',
1953
            'name'                => 'WESTERN SAHARA',
1954
            'nicename'            => 'Western Sahara',
1955
            'iso3'                => 'ESH',
1956
            'numcode'             => '732',
1957
            'phonecode'           => '212', ]);
1958
        CountryCode::create(['id' => '237',
1959
            'iso'                 => 'YE',
1960
            'name'                => 'YEMEN',
1961
            'nicename'            => 'Yemen',
1962
            'iso3'                => 'YEM',
1963
            'numcode'             => '887',
1964
            'phonecode'           => '967', ]);
1965
        CountryCode::create(['id' => '238',
1966
            'iso'                 => 'ZM',
1967
            'name'                => 'ZAMBIA',
1968
            'nicename'            => 'Zambia',
1969
            'iso3'                => 'ZMB',
1970
            'numcode'             => '894',
1971
            'phonecode'           => '260', ]);
1972
        CountryCode::create(['id' => '239',
1973
            'iso'                 => 'ZW',
1974
            'name'                => 'ZIMBABWE',
1975
            'nicename'            => 'Zimbabwe',
1976
            'iso3'                => 'ZWE',
1977
            'numcode'             => '716',
1978
            'phonecode'           => '263', ]);
1979
1980
        Security::create(['id' => '1', 'lockout_message' => 'You have been locked out of application due to too many failed login attempts.', 'backlist_offender' => '0', 'backlist_threshold' => '15', 'lockout_period' => '15', 'days_to_keep_logs' => '0']);
1981
1982
        TemplateSet::create(['id' => '1', 'name' => 'default', 'active' => '1']);
1983
1984
        TemplateType::create(['id' => '1', 'name' => 'assign-ticket']);
1985
        TemplateType::create(['id' => '2', 'name' => 'check-ticket']);
1986
        TemplateType::create(['id' => '3', 'name' => 'close-ticket']);
1987
        TemplateType::create(['id' => '4', 'name' => 'create-ticket']);
1988
        TemplateType::create(['id' => '5', 'name' => 'create-ticket-agent']);
1989
        TemplateType::create(['id' => '6', 'name' => 'create-ticket-by-agent']);
1990
        TemplateType::create(['id' => '7', 'name' => 'registration-notification']);
1991
        TemplateType::create(['id' => '8', 'name' => 'reset-password']);
1992
        TemplateType::create(['id' => '9', 'name' => 'ticket-reply']);
1993
        TemplateType::create(['id' => '10', 'name' => 'ticket-reply-agent']);
1994
        TemplateType::create(['id' => '11', 'name' => 'registration']);
1995
        TemplateType::create(['id' => '12', 'name' => 'team_assign_ticket']);
1996
        TemplateType::create(['id' => '13', 'name' => 'reset_new_password']);
1997
        TemplateType::create(['id' => '14', 'name' => 'merge-ticket-notification']);
1998
1999
        Template::create(['id' => '1', 'variable' => '0', 'name' => 'This template is for sending notice to agent when ticket is assigned to them', 'type' => '1', 'message' => '<div>Hello {!!$ticket_agent_name!!},<br /><br /><b>Ticket No:</b> {!!$ticket_number!!}<br />Has been assigned to you by {!!$ticket_assigner!!} <br/> Please check and resppond on the ticket.<br /> Link: {!!$ticket_link!!}<br /><br />Thank You<br />Kind Regards,<br /> {!!$system_from!!}</div>', 'set_id' => '1']);
2000
        Template::create(['id' => '2', 'variable' => '1', 'name' => 'This template is for sending notice to client with ticket link to check ticket without logging in to system', 'type' => '2', 'subject' => 'Check your Ticket', 'message' => '<div>Hello {!!$user!!},<br/><br/>Click the link below to view your requested ticket<br/> {!!$ticket_link_with_number!!}<br/><br/>Kind Regards,<br/> {!!$system_from!!}</div>', 'set_id' => '1']);
2001
        Template::create(['id' => '3', 'variable' => '0', 'name' => 'This template is for sending notice to client when ticket status is changed to close', 'type' => '3', 'message' => '<div>Hello,<br/><br/>This message is regarding your ticket ID {!!$ticket_number!!}. We are changing the status of this ticket to "Closed" as the issue appears to be resolved.<br/><br/>Thank you<br/>Kind regards,<br/> {!!$system_from!!}</div>', 'set_id' => '1']);
2002
        Template::create(['id' => '4', 'variable' => '0', 'name' => 'This template is for sending notice to client on successful ticket creation', 'type' => '4', 'message' => '<div><span>Hello {!!$user!!}<br/><br/></span><span>Thank you for contacting us. This is an automated response confirming the receipt of your ticket. Our team will get back to you as soon as possible. When replying, please make sure that the ticket ID is kept in the subject so that we can track your replies.<br/><br/></span><span><b>Ticket ID:</b> {!!$ticket_number!!} <br/><br/></span><span> {!!$department_sign!!}<br/></span>You can check the status of or update this ticket online at: {!!$system_link!!}</div>', 'set_id' => '1']);
2003
        Template::create(['id' => '5', 'variable' => '0', 'name' => 'This template is for sending notice to agent on new ticket creation', 'type' => '5', 'message' => '<div>Hello {!!$ticket_agent_name!!},<br/><br/>New ticket {!!$ticket_number!!}created <br/><br/><b>From</b><br/><b>Name:</b> {!!$ticket_client_name!!}   <br/><b>E-mail:</b> {!!$ticket_client_email!!}<br/><br/> {!!$content!!}<br/><br/>Kind Regards,<br/> {!!$system_from!!}</div>', 'set_id' => '1']);
2004
        Template::create(['id' => '6', 'variable' => '0', 'name' => 'This template is for sending notice to client on new ticket created by agent in name of client', 'type' => '6', 'message' => '<div> {!!$content!!}<br><br> {!!$agent_sign!!}<br><br>You can check the status of or update this ticket online at: {!!$system_link!!}</div>', 'set_id' => '1']);
2005
        Template::create(['id' => '7', 'variable' => '1', 'name' => 'This template is for sending notice to client on new registration during new ticket creation for un registered clients', 'type' => '7', 'subject' => 'Registration Confirmation', 'message' => '<p>Hello {!!$user!!}, </p><p>This email is confirmation that you are now registered at our helpdesk.</p><p><b>Registered Email:</b> {!!$email_address!!}</p><p><b>Password:</b> {!!$user_password!!}</p><p>You can visit the helpdesk to browse articles and contact us at any time: {!!$system_link!!}</p><p>Thank You.</p><p>Kind Regards,</p><p> {!!$system_from!!} </p>', 'set_id' => '1']);
2006
        Template::create(['id' => '8', 'variable' => '1', 'name' => 'This template is for sending notice to any user about reset password option', 'type' => '8', 'subject' => 'Reset your Password', 'message' => 'Hello {!!$user!!},<br/><br/>You asked to reset your password. To do so, please click this link:<br/><br/> {!!$password_reset_link!!}<br/><br/>This will let you change your password to something new.'." If you didn't ask for this, don't worry, we'll keep your password safe.<br/><br/>Thank You.<br/><br/>Kind Regards,<br/>".' {!!$system_from!!}', 'set_id' => '1']);
2007
        Template::create(['id' => '9', 'variable' => '0', 'name' => 'This template is for sending notice to client when a reply made to his/her ticket', 'type' => '9', 'message' => '<span></span><div><span></span><p> {!!$content!!}<br/></p><p> {!!$agent_sign!!} </p><p><b>Ticket Details</b></p><p><b>Ticket ID:</b> {!!$ticket_number!!}</p></div>', 'set_id' => '1']);
2008
        Template::create(['id' => '10', 'variable' => '0', 'name' => 'This template is for sending notice to agent when ticket reply is made by client on a ticket', 'type' => '10', 'message' => '<div>Hello {!!$ticket_agent_name!!},<br/><b><br/></b>A reply been made to ticket {!!$ticket_number!!}<br/><b><br/></b><b>From<br/></b><b>Name: </b>{!!$ticket_client_name!!}<br/><b>E-mail: </b>{!!$ticket_client_email!!}<br/><b><br/></b> {!!$content!!}<br/><b><br/></b>Kind Regards,<br/> {!!$system_from!!}</div>', 'set_id' => '1']);
2009
        Template::create(['id' => '11', 'variable' => '1', 'name' => 'This template is for sending notice to client about registration confirmation link', 'type' => '11', 'subject' => 'Verify your email address', 'message' => '<p>Hello {!!$user!!}, </p><p>This email is confirmation that you are now registered at our helpdesk.</p><p><b>Registered Email:</b> {!!$email_address!!}</p><p>Please click on the below link to activate your account and Login to the system {!!$password_reset_link!!}</p><p>Thank You.</p><p>Kind Regards,</p><p> {!!$system_from!!} </p>', 'set_id' => '1']);
2010
        Template::create(['id' => '12', 'variable' => '1', 'name' => 'This template is for sending notice to team when ticket is assigned to team', 'type' => '12', 'message' => '<div>Hello {!!$ticket_agent_name!!},<br /><br /><b>Ticket No:</b> {!!$ticket_number!!}<br />Has been assigned to your team : {!!$team!!} by {!!$ticket_assigner!!} <br /><br />Thank You<br />Kind Regards,<br />{!!$system_from!!}</div>', 'set_id' => '1']);
2011
        Template::create(['id' => '13', 'variable' => '1', 'name' => 'This template is for sending notice to client when password is changed', 'type' => '13', 'subject' => 'Verify your email address', 'message' => 'Hello {!!$user!!},<br /><br />Your password is successfully changed.Your new password is : {!!$user_password!!}<br /><br />Thank You.<br /><br />Kind Regards,<br /> {!!$system_from!!}', 'set_id' => '1']);
2012
        Template::create(['id' => '14', 'variable' => '1', 'name' => 'This template is to notify users when their tickets are merged.', 'type' => '14', 'subject' => 'Your tickets have been merged.', 'message' => '<p>Hello {!!$user!!},<br />&nbsp;</p><p>Your ticket(s) with ticket number {!!$merged_ticket_numbers!!} have been closed and&nbsp;merged with <a href="{!!$ticket_link!!}">{!!$ticket_number!!}</a>.&nbsp;</p><p>Possible reasons for merging tickets</p><ul><li>Tickets are duplicate</li<li>Tickets state&nbsp;the same issue</li><li>Another member from your organization has created a ticket for the same issue</li></ul><p><a href="{!!$system_link!!}">Click here</a> to login to your account and check your tickets.</p><p>Regards,</p><p>{!!$system_from!!}</p>', 'set_id' => '1']);
2013
2014
        /*
2015
         * All the common settings will be listed here
2016
         */
2017
        CommonSettings::create(['option_name' => 'ticket_token_time_duration', 'option_value' => '1']);
2018
        CommonSettings::create(['option_name' => 'enable_rtl', 'option_value' => '']);
2019
        CommonSettings::create(['option_name' => 'user_set_ticket_status', 'status' => 1]);
2020
        CommonSettings::create(['option_name' => 'send_otp', 'status' => 0]);
2021
        CommonSettings::create(['option_name' => 'email_mandatory', 'status' => 1]);
2022
        CommonSettings::create(['option_name' => 'user_priority', 'status' => 0]);
2023
2024
        /*
2025
         * Ratings
2026
         */
2027
        Rating::create(['id' => '1', 'name' => 'OverAll Satisfaction', 'display_order' => '1', 'allow_modification' => '1', 'rating_scale' => '5', 'rating_area' => 'Helpdesk Area']);
2028
        Rating::create(['id' => '2', 'name' => 'Reply Rating', 'display_order' => '1', 'allow_modification' => '1', 'rating_scale' => '5', 'rating_area' => 'Comment Area']);
2029
2030
        Limit_Login::create(['id' => '1']);
2031
    }
2032
}
2033