<?php

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

class CreateCsvFileDetailsTable extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {
        Schema::create('csv_file_details', function (Blueprint $table) {
            $table->id();
            $table->integer('csv_file_id');
            $table->smallInteger('type')->default(0);
            $table->smallInteger('status')->default(0);
            $table->longText('data_1')->nullable();
            $table->longText('data_2')->nullable();
            $table->longText('data_3')->nullable();
            $table->longText('data_4')->nullable();
            $table->longText('data_5')->nullable();
            $table->longText('data_6')->nullable();
            $table->longText('data_7')->nullable();
            $table->longText('data_8')->nullable();
            $table->longText('data_9')->nullable();
            $table->longText('data_10')->nullable();
            $table->longText('data_11')->nullable();
            $table->longText('data_12')->nullable();
            $table->longText('data_13')->nullable();
            $table->longText('data_14')->nullable();
            $table->longText('data_15')->nullable();
            $table->longText('data_16')->nullable();
            $table->longText('data_17')->nullable();
            $table->longText('data_18')->nullable();
            $table->longText('data_19')->nullable();
            $table->longText('data_20')->nullable();
            $table->longText('data_21')->nullable();
            $table->longText('data_22')->nullable();
            $table->longText('data_23')->nullable();
            $table->longText('data_24')->nullable();
            $table->longText('data_25')->nullable();
            $table->timestamps();
        });
    }

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