<?php use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; use Illuminate\Support\Facades\Schema; class CreateTimeSheetsTable extends Migration { /** * Run the migrations. * * @return void */ public function up() { Schema::create( 'time_sheets', function (Blueprint $table){ $table->bigIncrements('id'); $table->integer('employee_id')->default(0); $table->date('date'); $table->float('hours')->default(0.0); $table->text('remark')->nullable(); $table->integer('created_by')->default('0'); $table->timestamps(); } ); } /** * Reverse the migrations. * * @return void */ public function down() { Schema::dropIfExists('time_sheets'); } }