/home/mip/mip/database/migrations/client/2017_11_29_101804_create_job_opening_table.php
<?php
use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
class CreateJobOpeningTable extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('job_opening', function (Blueprint $table) {
$table->engine = 'MYISAM';
$table->increments('id');
$table->string('position');
$table->integer('no_position');
$table->string('proposed_salary');
$table->string('gender');
$table->integer('min_age');
$table->integer('max_age');
$table->date('opening_date');
$table->date('closing_date');
$table->enum('status', ['Open', 'Close', 'Draft']);
$table->longText('job_details');
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('job_opening');
}
}