djid_siput/ISR/database/migrations/2020_03_25_134142_privillage.php

<?php

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

class Privillage extends Migration
{
    /**
     * Run the migrations.
     *
     * @return void
     */
    public function up()
    {   
        Schema::create('roles', function (Blueprint $table) {
          $table->increments('id');
          $table->string('role_name',100);
          $table->string('description',255);
          $table->string('akses',20);
          $table->timestamps();
      });

        Schema::create('role_acl', function (Blueprint $table) {
            $table->increments('id');
            $table->unsignedInteger('role_id')->nullable();
            $table->string('module_id')->nullable();
            $table->string('create_acl')->nullable();
            $table->string('read_acl')->nullable();
            $table->string('update_acl')->nullable();
            $table->string('delete_acl')->nullable();
            $table->integer('module_parent'); 
            $table->timestamps();
        });

        Schema::create('modules', function (Blueprint $table) {
          $table->increments('id');
          $table->integer('menu_parent')->nullable();
          $table->string('module_name');
          $table->string('menu_mask');
          $table->string('menu_path');
          $table->string('menu_icon')->nullable();
          $table->integer('menu_order')->nullable();
          $table->integer('divider')->nullable();
          $table->string('pathParent');
          $table->string('kdModule');
          $table->timestamps();
      });


        Schema::table('users', function (Blueprint $table) {
          $table->unsignedInteger('role_id');
      });
    }

    /**
     * Reverse the migrations.
     *
     * @return void
     */
    public function down()
    {
        //
    }
}