<?php

use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;

class CreateCountriesTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('countries', function (Blueprint $table) {
            $table->engine = "MYISAM";
            $table->increments('id');
            $table->string('name');
            $table->string('code');
            $table->integer('orden_number')->index()->unsigned();
            $table->timestamps();
        });
        DB::unprepared("
            Truncate countries;
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (4, 'PHILIPPINES', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (6, 'LIBERIA', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (7, 'PANAMA', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (8, 'MALTA', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (13, 'NORWAY', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (12, 'MONACO', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (14, 'UNITED KINGDOM', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (15, 'SINGAPORE', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (16, 'JAPAN', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (17, 'BAHAMAS', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (18, 'HONGKONG', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (19, 'KUWAIT', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (20, 'QATAR', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (21, 'NIGERIA', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (22, 'ANTIGUA & BARBUDA', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (23, 'MARSHALL ISLANDS', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (24, 'CYPRUS', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (25, 'ITALY', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (26, 'DAMMAM', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (27, 'SAUDI ARABIA', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (28, 'TAIWAN', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (29, 'UNITED ARAB EMIRATES', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (30, 'UASC', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (31, 'NETHERLANDS', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (32, 'CHINA', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (33, 'INDONESIA', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (34, 'BELGIUM', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (35, 'GERMANY', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (36, 'DUBAI', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (37, 'DOMINICA', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (38, 'LIMASSOL', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (100, 'CROATIA', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (40, 'MAJURO', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (41, 'SOUTH KOREA', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (42, 'FRANCE', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (99, 'ESTONIA', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (44, 'TURKEY', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (45, 'HONDURAS', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (46, 'INDIA', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (47, 'MOROCCO', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (48, 'U.S.A.', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (49, 'TUNISIA', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (50, 'BANGLADESH', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (98, 'RUSSIA', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (51, 'UKRAINE', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (52, 'AUSTRALIA', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (53, 'GREECE', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (54, 'ISRAEL', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (55, 'BRAZIL', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (56, 'SWITZERLAND', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (57, 'TANZANIA', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (58, 'EGYPT', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (59, 'CAYMAN', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (60, 'SOUTH AFRICA', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (61, 'VANUATU', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (62, 'LONDON', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (63, 'GIBRALTAR', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (64, 'DENMARK', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (65, 'BERMUDA', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (66, 'SAINT KITTS & NEVIS', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (67, 'GUINEA', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (68, 'THAILAND', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (69, 'CANADA', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (70, 'MANILA, PHILIPPINES', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (71, 'GRAN CANARIAS', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (72, 'SPAIN', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (73, 'JORDAN', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (74, 'URUGUAY', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (75, 'VENEZUELA', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (76, 'ROMANIA', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (77, 'KENYA', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (78, 'PERU', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (79, 'CHILE', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (80, 'PORTUGAL', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (81, 'CAPE VERDE', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (82, 'DOMINICAN REPUBLIC', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (83, 'SAINT VINCENT AND THE GRENADINES', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (84, 'SRI LANKA', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (85, 'MALAYSIA', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (86, 'VIETNAM', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (87, 'PAKISTAN', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (88, 'MEXICO', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (89, 'BELFAST', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (101, 'ENGLAND', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (91, 'IVORY COAST', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (92, 'BAHRAIN', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (93, 'ICELAND', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (94, 'LITHUANIA', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (95, 'SWEDEN', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (96, 'OMAN', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (97, 'SERBIA', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (102, 'FLORIDA', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (103, 'BARBADOS', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (104, 'TUVALU', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (105, 'CALIFORNIA', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (106, 'FEDERAL STATES OF MICRONESIA', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (107, 'MONROVIA', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (108, 'NASSAU', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (109, 'PAPUA NEW GUINEA', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (110, 'CAMBODIA', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (111, 'IRELAND', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (112, 'LEBANON', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (113, 'SYRIA', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (114, 'ARGENTINA', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (115, 'ECUADOR', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (116, 'CAMEROON', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (117, 'ALGERIA', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (118, 'SIERRA LEONE', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (119, 'SOLOMON ISLANDS', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (120, 'BELIZE', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (121, 'ST. JOHN\'S', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (122, 'COSTA RICA', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (123, 'JAMAICA', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (124, 'GEORGIA', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (125, 'NEW ZEALAND', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (126, 'VIRGINIA', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (127, 'CURACAO', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (128, 'LATVIA', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (129, 'MADAGASCAR', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (130, 'GIORGIA', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (131, 'MAURITANIA', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (132, 'YEMEN', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (133, 'FINLAND', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (134, 'NAURU', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (135, 'LIBYA', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (136, 'SEYCHELLES', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (137, 'GHANA', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (138, 'MAURITIUS', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (139, 'MAN OF ISLE', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (140, 'LUXEMBOURG', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (141, 'ISLE OF MAN', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (142, 'TOGO', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (143, 'VALLETA', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (144, 'MANILA', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (145, 'TOKYO', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (146, 'JEDDAH', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (147, 'CEBU', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (148, 'COOK ISLAND', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (149, 'CAYMAN ISLAND', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (150, 'DANISH', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (151, 'KINGSTOWN', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (152, 'BATANGAS', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (153, 'SHARJAH', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
            INSERT INTO `countries` (`id`, `name`, `code`, `orden_number`, `created_at`, `updated_at`) VALUES (154, 'PIRAEUS', '', 0, '2016-06-24 01:33:15', '2016-06-24 01:33:15');
        ");
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        Schema::drop('countries');
    }
}

• [F] 2016_05_20_010746_create_roles_table.php
  Delete
• [F] 2016_05_20_010852_create_role_permissions_table.php
  Delete
• [F] 2016_06_14_111620_create_login_logs_table.php
  Delete
• [F] 2016_06_14_111620_create_principals_table.php
  Delete
• [F] 2016_06_14_155701_create_countries_table.php
  Delete
• [F] 2017_01_27_110940_create_assigned_users_principals_table.php
  Delete
• [F] 2017_07_12_065054_create_survey_templates_table.php
  Delete
• [F] 2017_07_13_060233_create_survey_questions_table.php
  Delete
• [F] 2017_07_13_070622_create_survey_answers_table.php
  Delete
• [F] 2017_07_31_084448_create_principal_contact_persons.php
  Delete
• [F] 2017_07_31_084801_create_principal_contact_person_numbers.php
  Delete
• [F] 2017_08_03_082621_create_survey_subjects.php
  Delete
• [F] 2017_08_15_010613_create_directories_table.php
  Delete
• [F] 2017_08_15_023814_create_locations_table.php
  Delete
• [F] 2017_08_15_024339_create_provinces_table.php
  Delete
• [F] 2017_08_15_024512_create_cities_table.php
  Delete
• [F] 2017_08_15_024638_create_municipalities_table.php
  Delete
• [F] 2017_08_15_024759_create_affiliates_table.php
  Delete
• [F] 2017_08_15_024843_create_specializations_table.php
  Delete
• [F] 2017_08_17_004853_create_products_table.php
  Delete
• [F] 2017_08_17_005015_create_product_brand_table.php
  Delete
• [F] 2017_08_17_005104_create_product_categories_table.php
  Delete
• [F] 2017_08_23_011601_create_posts_category_table.php
  Delete
• [F] 2017_08_23_011705_create_posts_table.php
  Delete
• [F] 2017_08_30_073310_change_expired_at_to_posts_table.php
  Delete
• [F] 2017_08_31_012059_create_user_logs_table.php
  Delete
• [F] 2017_09_06_001933_add_sub_module_to_users_logs_table.php
  Delete
• [F] 2017_09_13_101313_create_participants_table.php
  Delete
• [F] 2017_09_13_143949_create_participants_answers_table.php
  Delete
• [F] 2017_10_04_170315_add_keyword_field_in_posts_table.php
  Delete
• [F] 2017_10_10_144933_add_pageviews_field_in_posts_table.php
  Delete
• [F] 2017_11_29_101804_create_job_opening_table.php
  Delete
• [F] 2017_12_01_091106_add_country_to_job_opening_table.php
  Delete
• [F] 2017_12_07_095724_add_slug_to_job_opening_table.php
  Delete
• [F] 2018_04_10_152021_add_location_to_job_opening_table.php
  Delete
• [F] 2018_04_11_153027_create_faq_table.php
  Delete
• [F] 2018_04_12_142025_create_about_us_table.php
  Delete
• [F] 2018_04_16_113317_create_contact_us_table.php
  Delete
• [F] 2018_04_17_110756_create_applicants_table.php
  Delete
• [F] 2018_04_17_141120_create_job_applied_table.php
  Delete