1  <?php
 2  
 3  use Illuminate\Database\Migrations\Migration;
 4  use Illuminate\Database\Schema\Blueprint;
 5  use Illuminate\Support\Facades\Schema;
 6  
 7  class CreateDocumentRoleTable extends Migration
 8  {
 9      /**
10       * Run the migrations.
11       *
12       * @return void
13       */
14      public function up()
15      {
16          Schema::create('document_role', function (Blueprint $table) {
17              $table->id();
18              $table->foreignId('document_id')->constrained('documents')->cascadeOnUpdate()->cascadeOnDelete();
19              $table->foreignId('role_id')->constrained('roles')->cascadeOnUpdate()->cascadeOnDelete();
20              $table->boolean('can_approve')->default(false);
21              $table->boolean('can_review')->default(false);
22              $table->boolean('can_read')->default(false);
23              $table->boolean('can_write')->default(false);
24              $table->timestamps();
25          });
26      }
27  
28      /**
29       * Reverse the migrations.
30       *
31       * @return void
32       */
33      public function down()
34      {
35          Schema::dropIfExists('document_role');
36      }
37  }