/home/mip/mip/database/migrations/client/2016_05_20_010852_create_role_permissions_table.php
<?php
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Migrations\Migration;
class CreateRolePermissionsTable extends Migration
{
/**
* Run the migrations.
*
* @return void
*/
public function up()
{
Schema::create('role_permissions', function (Blueprint $table) {
$table->engine = 'MYISAM';
$table->increments('id');
$table->integer('role_id')->unsigned()->index();
$table->integer('menu_id')->unsigned()->index();
$table->integer('can_access')->unsigned()->index();
$table->integer('can_create')->unsigned()->index();
$table->integer('can_update')->unsigned()->index();
$table->integer('can_delete')->unsigned()->index();
$table->integer('can_export')->unsigned()->index();
$table->integer('can_import')->unsigned()->index();
$table->integer('can_print')->unsigned()->index();
$table->timestamps();
});
DB::table('role_permissions')->truncate();
}
/**
* Reverse the migrations.
*
* @return void
*/
public function down()
{
Schema::drop('role_permissions');
}
}