/home/mip/mip/database/migrations/client/2018_04_17_141120_create_job_applied_table.php
<?php
use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
class CreateJobAppliedTable extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('job_applied', function (Blueprint $table) {
$table->engine = 'MYISAM';
$table->increments('id');
$table->integer('applicant_id')->unsigned()->index();
$table->integer('job_id')->unsigned()->index();
$table->date('apply_date');
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('job_applied');
}
}