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

PATH: home / centosnipponia / public_html / apptt-oldgit / database / migrations

<?php

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

class CreatePickDelsTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('pick_dels', function (Blueprint $table) {
            $table->id();
            $table->timestamps();
            $table->string('pickingtype')->nullable();
            $table->string('operationtype')->nullable();
            $table->string('vin')->nullable();
            $table->longText('model')->nullable();
            $table->longText('modeldet')->nullable();
            $table->string('licencenbr')->nullable();
            $table->longText('dealer')->nullable();
            $table->longText('dealerloc')->nullable();
            $table->longText('address')->nullable();
            $table->string('dealeremail')->nullable();
            $table->string('phone')->nullable();
            $table->string('maila')->nullable();
            $table->boolean('vehicleworks')->nullable();
            $table->boolean('keyspresent')->nullable();
            $table->boolean('remotepresent')->nullable();
            $table->boolean('toolkitpresent')->nullable();
            $table->boolean('vinplatematch')->nullable();
            $table->boolean('casespresent')->nullable();
            $table->boolean('mirrorspresent')->nullable();
            $table->boolean('batterypresent')->nullable();
            $table->boolean('chargerpresent')->nullable();
            $table->boolean('chargertested')->nullable();
            $table->boolean('damage')->nullable();
            $table->string('batterynbr')->nullable();
            $table->string('batterytype')->nullable();
            $table->string('chargernbr')->nullable();
            $table->longText('comments')->nullable();
            $table->string('created_by')->nullable();
            $table->boolean('isfinalized')->nullable();
            $table->string('routingnbr')->nullable();
            $table->date('routingdate')->nullable();
            $table->longText('imagesignurl')->nullable();
            $table->longText('imageurl')->nullable();

});
    }

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

[+] ..
[-] 2014_10_12_000000_create_users_table.php [edit]
[-] 2014_10_12_100000_create_password_resets_table.php [edit]
[-] 2019_08_19_000000_create_failed_jobs_table.php [edit]
[-] 2020_09_26_195528_create_statnls_table.php [edit]
[-] 2021_09_13_105205_create_snelstart_inv_clients_table.php [edit]
[-] 2021_11_15_083214_add_role_to_users.php [edit]
[-] 2021_11_22_074735_create_mol_edits_table.php [edit]
[-] 2021_12_15_102808_create_sale_target_table.php [edit]
[-] 2021_12_23_123002_add_menu_image_to_users.php [edit]
[-] 2022_01_19_082335_sales_unit_target.php [edit]
[-] 2022_01_19_082421_product_groups.php [edit]
[-] 2022_01_19_082429_group_prod_bind.php [edit]
[-] error_log [edit]
[-] 2022_03_11_124442_sales_unit_target_rename_to_categ_add_sale_price.php [edit]
[-] 2022_03_11_130412_drop_tablegroup_prod_bind.php [edit]
[-] 2022_03_11_130449_drop_product_groups_bind.php [edit]
[-] 2022_05_13_102126_create_added_stock_table.php [edit]
[-] 2022_11_09_075318_create_costpervins_table.php [edit]
[-] 2022_11_10_142519_create_vins_in_stocks_table.php [edit]
[-] 2022_11_23_093024_create_pick_dels_table.php [edit]
[-] 2022_12_19_200133_add_internalnotes_to_pickdel_table.php [edit]
[-] 2023_01_11_144033_add_hide_reason_table.php [edit]
[-] .htaccess.disabled [edit]