<?php use Illuminate\Database\Migrations\Migration; use Illuminate\Support\Facades\Schema; use Illuminate\Database\Schema\Blueprint; class CreateLitecmsLegalLegalCasesTable extends Migration { /* * Run the migrations. * * @return void */ public function up() { /* * Table: litecms_legal_legal_cases */ Schema::create('litecms_legal_legal_cases', function ($table) { $table->increments('id'); $table->integer('building_id')->nullable(); $table->integer('unit_id')->nullable(); $table->integer('lease_id')->nullable(); $table->integer('legal_id')->nullable(); $table->enum('status', ['Yes', 'No'])->nullable(); $table->date('date')->nullable(); $table->text('details')->nullable(); $table->text('documents')->nullable(); $table->tinyInteger('block_tenant')->nullable(); $table->integer('user_id')->nullable(); $table->text('marking', 200)->nullable(); $table->softDeletes(); $table->nullableTimestamps(); }); } /* * Reverse the migrations. * * @return void */ public function down() { Schema::drop('litecms_legal_legal_cases'); } }