| @@ 29-44 (lines=16) @@ | ||
| 26 | $table->timestamps(); |
|
| 27 | }); |
|
| 28 | ||
| 29 | Schema::create('permission_role', function (Blueprint $table) { |
|
| 30 | $table->integer('permission_id')->unsigned(); |
|
| 31 | $table->integer('role_id')->unsigned(); |
|
| 32 | ||
| 33 | $table->foreign('permission_id') |
|
| 34 | ->references('id') |
|
| 35 | ->on('permissions') |
|
| 36 | ->onDelete('cascade'); |
|
| 37 | ||
| 38 | $table->foreign('role_id') |
|
| 39 | ->references('id') |
|
| 40 | ->on('roles') |
|
| 41 | ->onDelete('cascade'); |
|
| 42 | ||
| 43 | $table->primary(['permission_Id', 'role_id']); |
|
| 44 | }); |
|
| 45 | ||
| 46 | Schema::create('admin_role', function (Blueprint $table) { |
|
| 47 | $table->integer('role_id')->unsigned(); |
|
| @@ 46-61 (lines=16) @@ | ||
| 43 | $table->primary(['permission_Id', 'role_id']); |
|
| 44 | }); |
|
| 45 | ||
| 46 | Schema::create('admin_role', function (Blueprint $table) { |
|
| 47 | $table->integer('role_id')->unsigned(); |
|
| 48 | $table->integer('admin_id')->unsigned(); |
|
| 49 | ||
| 50 | $table->foreign('role_id') |
|
| 51 | ->references('id') |
|
| 52 | ->on('roles') |
|
| 53 | ->onDelete('cascade'); |
|
| 54 | ||
| 55 | $table->foreign('admin_id') |
|
| 56 | ->references('id') |
|
| 57 | ->on('admins') |
|
| 58 | ->onDelete('cascade'); |
|
| 59 | ||
| 60 | $table->primary(['role_id', 'admin_id']); |
|
| 61 | }); |
|
| 62 | //seed database for admin and initiate super role |
|
| 63 | DB::table('roles')->insert([ |
|
| 64 | 'name' => 'super', |
|