ꦫꦣꦺꦤ꧀ꦄꦤ꧀ꦠꦱꦺꦤ

PATH: home / lab2454c / tripvare.com / backup / database / migrations

<?php

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

class CreateTravelInformationsTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('travel_informations', function (Blueprint $table) {
            $table->uuid('id')->primary();
            $table->uuid('user_id')->nullable();
            $table->text('information')->nullable();
            $table->text('date_submitted')->nullable();

$table->string('first_name')->nullable();
            $table->string('middle_name')->nullable();
            $table->string('last_name')->nullable();
            $table->string('sex_age')->nullable();
            $table->string('mobile_contact_number')->nullable();
            $table->string('business_contact_number')->nullable();
            $table->string('home_contact_number')->nullable();
            $table->string('other_contact_number')->nullable();
            $table->string('email_address')->nullable();
            $table->text('passport')->nullable();
            $table->text('driving_license')->nullable();
            $table->string('airline_name')->nullable();
            $table->string('flight_number')->nullable();
            $table->text('date_of_arrival')->nullable();
            $table->text('point_of_entry')->nullable();
            $table->string('country_permanent')->nullable();
            $table->string('state_permanent')->nullable();
            $table->string('city_permanent')->nullable();
            $table->text('street_permanent')->nullable();
            $table->text('apartment_permanent')->nullable();
            $table->text('previous_visited_country_permanent')->nullable();

$table->string('country_temporary')->nullable();
            $table->string('state_temporary')->nullable();
            $table->string('city_temporary')->nullable();
            $table->text('street_temporary')->nullable();
            $table->text('apartment_temporary')->nullable();
            $table->text('previous_visited_country_temporary')->nullable();

$table->string('first_name_emergency')->nullable();           
            $table->string('last_name_emergency')->nullable();
            $table->text('country_city_emergency')->nullable();
            $table->string('mobile_contact_number_emergency')->nullable();
            $table->string('other_contact_number_emergency')->nullable();
            $table->string('email_address_emergency')->nullable();

$table->string('first_name_digital')->nullable();
            $table->string('last_name_digital')->nullable();  
            $table->string('national_id_digital')->nullable();  
            $table->string('certificate_type_digital')->nullable();
            $table->string('credential_type_digital')->nullable();
            $table->string('certificate_id_digital')->nullable();
            $table->string('vaccination_country_digital')->nullable();
            $table->string('vaccination_manufacturer_digital')->nullable();

$table->timestamps();
            
            $table->foreign('user_id')
                  ->references('id')
                  ->on('users');
        });
    }

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

[-] 2017_08_11_074006_create_menu_items_wp_table.php [edit]
[-] 2014_10_12_100000_create_password_resets_table.php [edit]
[-] 2019_08_19_000000_create_failed_jobs_table.php [edit]
[+] ..
[-] 2021_02_19_083338_update_users_table.php [edit]
[-] 2021_07_28_035835_create_travel_informations_table.php [edit]
[-] 2022_02_11_121633_update_settings_table.php [edit]
[-] 2021_02_25_064056_create_admins_table.php [edit]
[-] 2014_10_12_000000_create_users_table.php [edit]
[-] 2021_02_19_080928_create_countries_table.php [edit]
[-] 2021_02_19_141605_update_user_table_chng_column_name.php [edit]
[-] 2021_07_28_114122_create_pages_table.php [edit]
[-] 2021_02_22_081845_create_applications_table.php [edit]
[-] 2021_02_19_084034_update_users_table_drop_column.php [edit]
[-] 2017_08_11_073824_create_menus_wp_table.php [edit]
[-] 2017_09_01_000000_create_authentication_log_table.php [edit]
[-] 2021_07_29_140434_create_settings_table.php [edit]
[-] 2021_07_29_121729_create_rewards_table.php [edit]
[-] 2021_07_28_034341_create_membership_informations_table.php [edit]