Skip to content

Instantly share code, notes, and snippets.

@introwit
Created October 18, 2016 10:19
Show Gist options
  • Save introwit/bdcfebfb257e340eb425da2ab6aa596a to your computer and use it in GitHub Desktop.
Save introwit/bdcfebfb257e340eb425da2ab6aa596a to your computer and use it in GitHub Desktop.
<?php
use Illuminate\Support\Facades\Schema;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
class CreateUsersTable extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('users', function (Blueprint $table) {
$table->increments('id');
$table->string('name');
$table->string('email')->unique();
$table->string('password');
$table->tinyInteger('verified')->default(0); // this column will be a TINYINT with a default value of 0 , [0 for false & 1 for true i.e. verified]
$table->string('email_token')->nullable(); // this column will be a VARCHAR with no default value and will also BE NULLABLE
$table->rememberToken();
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::dropIfExists('users');
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment