|
@@ 24-34 (lines=11) @@
|
| 21 |
|
}); |
| 22 |
|
|
| 23 |
|
// Create table for associating roles to users (Many-to-Many) |
| 24 |
|
Schema::create('role_user', function (Blueprint $table) { |
| 25 |
|
$table->integer('user_id')->unsigned(); |
| 26 |
|
$table->integer('role_id')->unsigned(); |
| 27 |
|
|
| 28 |
|
$table->foreign('user_id')->references('id')->on('users') |
| 29 |
|
->onUpdate('cascade')->onDelete('cascade'); |
| 30 |
|
$table->foreign('role_id')->references('id')->on('roles') |
| 31 |
|
->onUpdate('cascade')->onDelete('cascade'); |
| 32 |
|
|
| 33 |
|
$table->primary(['user_id', 'role_id']); |
| 34 |
|
}); |
| 35 |
|
|
| 36 |
|
// Create table for storing permissions |
| 37 |
|
Schema::create('permissions', function (Blueprint $table) { |
|
@@ 46-56 (lines=11) @@
|
| 43 |
|
}); |
| 44 |
|
|
| 45 |
|
// Create table for associating permissions to roles (Many-to-Many) |
| 46 |
|
Schema::create('permission_role', function (Blueprint $table) { |
| 47 |
|
$table->integer('permission_id')->unsigned(); |
| 48 |
|
$table->integer('role_id')->unsigned(); |
| 49 |
|
|
| 50 |
|
$table->foreign('permission_id')->references('id')->on('permissions') |
| 51 |
|
->onUpdate('cascade')->onDelete('cascade'); |
| 52 |
|
$table->foreign('role_id')->references('id')->on('roles') |
| 53 |
|
->onUpdate('cascade')->onDelete('cascade'); |
| 54 |
|
|
| 55 |
|
$table->primary(['permission_id', 'role_id']); |
| 56 |
|
}); |
| 57 |
|
} |
| 58 |
|
|
| 59 |
|
/** |