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