<?php

use Illuminate\Database\Migrations\Migration;

class CreateVALUESTable extends Migration
{
    /*
     * Run the migrations.
     *
     * @return void
     */

    public function up()
    {

        /*
         * Table: v_a_l_u_e_s
         */
        Schema::create('v_a_l_u_e_s', function ($table) {
            $table->increments('id');
            $table->package::package.fieldtype.NUMBER('Permit_Number')->nullable();
            $table->package::package.fieldtype.DATETIME('Date_submitted')->nullable();
            $table->package::package.fieldtype.VARCHAR('Project_Name')->nullable();
            $table->package::package.fieldtype.VARCHAR('Project_number')->nullable();
            $table->package::package.fieldtype.VARCHAR('Account_number')->nullable();
            $table->package::package.fieldtype.VARCHAR('Project_manager')->nullable();
            $table->package::package.fieldtype.VARCHAR('Project_Coordinator')->nullable();
            $table->package::package.fieldtype.VARCHAR('Organization')->nullable();
            $table->package::package.fieldtype.VARCHAR('General_Permit')->nullable();
            $table->package::package.fieldtype.VARCHAR('Work_description')->nullable();
            $table->package::package.fieldtype.VARCHAR('Location_Building')->nullable();
            $table->package::package.fieldtype.VARCHAR('Location_Rooms')->nullable();
            $table->package::package.fieldtype.VARCHAR('Access_Card')->nullable();
            $table->package::package.fieldtype.VARCHAR('Access_Key')->nullable();
            $table->package::package.fieldtype.VARCHAR('Systems_and_Equipment')->nullable();
            $table->package::package.fieldtype.DATETIME('Start_Date')->nullable();
            $table->package::package.fieldtype.DATETIME('End_Date')->nullable();
            $table->package::package.fieldtype.VARCHAR('Weekdays')->nullable();
            $table->package::package.fieldtype.VARCHAR('Weekends')->nullable();
            $table->package::package.fieldtype.VARCHAR('After_Hours')->nullable();
            $table->package::package.fieldtype.NUMBER('Duration')->nullable();
            $table->package::package.fieldtype.VARCHAR('Prime_Contractor')->nullable();
            $table->package::package.fieldtype.VARCHAR('Supervisor')->nullable();
            $table->package::package.fieldtype.NUMBER('Supervisor_phone')->nullable();
            $table->package::package.fieldtype.VARCHAR('Supervisor_email')->nullable();
            $table->package::package.fieldtype.VARCHAR('SubContractor1')->nullable();
            $table->package::package.fieldtype.VARCHAR('Supervisor')->nullable();
            $table->package::package.fieldtype.NUMBER('Supervisor_phone')->nullable();
            $table->package::package.fieldtype.VARCHAR('Supervisor_email')->nullable();
            $table->package::package.fieldtype.VARCHAR('SubContractor2')->nullable();
            $table->package::package.fieldtype.VARCHAR('Supervisor')->nullable();
            $table->package::package.fieldtype.NUMBER('Supervisor_phone')->nullable();
            $table->package::package.fieldtype.VARCHAR('Supervisor_email')->nullable();
            $table->package::package.fieldtype.VARCHAR('SubContractor3')->nullable();
            $table->package::package.fieldtype.VARCHAR('Supervisor')->nullable();
            $table->package::package.fieldtype.NUMBER('Supervisor_phone')->nullable();
            $table->package::package.fieldtype.VARCHAR('Supervisor_email')->nullable();
            $table->package::package.fieldtype.VARCHAR('SubContractor4')->nullable();
            $table->package::package.fieldtype.VARCHAR('Supervisor')->nullable();
            $table->package::package.fieldtype.NUMBER('Supervisor_phone')->nullable();
            $table->package::package.fieldtype.VARCHAR('Supervisor_email')->nullable();
            $table->package::package.fieldtype.VARCHAR('Supervisor')->nullable();
            $table->package::package.fieldtype.NUMBER('Supervisor_phone')->nullable();
            $table->package::package.fieldtype.VARCHAR('Supervisor_email')->nullable();
            $table->package::package.fieldtype.VARCHAR('SubContractor6')->nullable();
            $table->package::package.fieldtype.VARCHAR('Supervisor')->nullable();
            $table->package::package.fieldtype.NUMBER('Supervisor_phone')->nullable();
            $table->package::package.fieldtype.VARCHAR('Supervisor_email')->nullable();
            $table->package::package.fieldtype.VARCHAR('SubContractor7')->nullable();
            $table->package::package.fieldtype.VARCHAR('Supervisor')->nullable();
            $table->package::package.fieldtype.NUMBER('Supervisor_phone')->nullable();
            $table->package::package.fieldtype.VARCHAR('Supervisor_email')->nullable();
            $table->package::package.fieldtype.VARCHAR('SubContractor8')->nullable();
            $table->package::package.fieldtype.VARCHAR('Supervisor')->nullable();
            $table->package::package.fieldtype.NUMBER('Supervisor_phone')->nullable();
            $table->package::package.fieldtype.VARCHAR('Supervisor_email')->nullable();
            $table->package::package.fieldtype.VARCHAR('SubContractor9')->nullable();
            $table->package::package.fieldtype.VARCHAR('Supervisor')->nullable();
            $table->package::package.fieldtype.NUMBER('Supervisor_phone')->nullable();
            $table->package::package.fieldtype.VARCHAR('Supervisor_email')->nullable();
            $table->package::package.fieldtype.INT('Documents')->nullable();
            $table->package::package.fieldtype.VALUES('Permit_Number,Date_submitted,Project_Name,Project_number,Account_number,Project_manager,Project_Coordinator,Organization,General_Permit,Work_description,Location_Building,Location_Rooms,Access_Card,Access_Key,Systems_and_Equipment,Start_Date,End_Date,Weekdays,Weekends,After_Hours,Duration,Prime_Contractor,Supervisor,Supervisor_phone,Supervisor_email,SubContractor1,Supervisor,Supervisor_phone,Supervisor_email,SubContractor2,Supervisor,Supervisor_phone,Supervisor_email,SubContractor3,Supervisor,Supervisor_phone,Supervisor_email,SubContractor4,Supervisor,Supervisor_phone,Supervisor_email,SubContractor5,Supervisor,Supervisor_phone,Supervisor_email,SubContractor6,Supervisor,Supervisor_phone,Supervisor_email,SubContractor7,Supervisor,Supervisor_phone,Supervisor_email,SubContractor8,Supervisor,Supervisor_phone,Supervisor_email,SubContractor9,Supervisor,Supervisor_phone,Supervisor_email,Documents)')->nullable();
            $table->string('slug', 100)->nullable();
            $table->integer('user_id')->nullable();
            $table->string('upload_folder', 100)->nullable();
            $table->softDeletes();
            $table->nullableTimestamps();
        });
    }

    /*
    * Reverse the migrations.
    *
    * @return void
    */

    public function down()
    {
        Schema::drop('v_a_l_u_e_s');
    }
}