basic database migration for a simple laravel project

migration.php

<?php


// up users
$table = 'users';
if (!Schema::hasTable($table)) {
	Schema::create($table, function (Blueprint $table) {
	    $table->increments('id');
	    
	    $table->string('display_name');
	    $table->string('email');

	    $table->timestamps();
	    $table->softDeletes();
	});
}

// down users
Schema::dropIfExists($table);



// up credentials
$table = 'credentials';
if (!Schema::hasTable($table)) {
	Schema::create($table, function (Blueprint $table) {
	    $table->increments('id');
	    $table->integer('user_id')->unsigned();
        $table->foreign('user_id')->references('id')->on('users');

	    $table->string('username');
	    $table->string('password');

	    $table->datetime('last_login_at');
	    $table->timestamps();
	    $table->softDeletes();
	});
}

// down credentials
Schema::dropIfExists($table);