/home/mip/mip/database/migrations/likod/2016_05_17_081819_create_client_users_table.php
<?php
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
class CreateClientUsersTable extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('client_users', function (Blueprint $table) {
$table->engine = 'MYISAM';
$table->increments('id');
$table->integer('client_id')->unsigned()->index();
$table->string('name', 100)->index();
$table->string('username', 50)->index();
$table->string('email', 50)->index();
$table->string('password')->index();
$table->smallInteger('type_id')->unsigned()->index();
$table->smallInteger('role_id')->unsigned()->index();
$table->smallInteger('status')->unsigned()->index();
$table->string('photo')->index();
$table->rememberToken();
$table->timestamps();
});
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::drop('client_users');
}
}