| @@ 29-44 (lines=16) @@ | ||
| 26 | $table->timestamps(); |
|
| 27 | }); |
|
| 28 | ||
| 29 | Schema::create('acl_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('acl_permissions') |
|
| 36 | ->onDelete('cascade'); |
|
| 37 | ||
| 38 | $table->foreign('role_id') |
|
| 39 | ->references('id') |
|
| 40 | ->on('acl_roles') |
|
| 41 | ->onDelete('cascade'); |
|
| 42 | ||
| 43 | $table->primary(['permission_Id', 'role_id']); |
|
| 44 | }); |
|
| 45 | ||
| 46 | Schema::create('acl_role_user', 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('acl_role_user', function (Blueprint $table) { |
|
| 47 | $table->integer('role_id')->unsigned(); |
|
| 48 | $table->integer('user_id')->unsigned(); |
|
| 49 | ||
| 50 | $table->foreign('role_id') |
|
| 51 | ->references('id') |
|
| 52 | ->on('acl_roles') |
|
| 53 | ->onDelete('cascade'); |
|
| 54 | ||
| 55 | $table->foreign('user_id') |
|
| 56 | ->references('id') |
|
| 57 | ->on('users') |
|
| 58 | ->onDelete('cascade'); |
|
| 59 | ||
| 60 | $table->primary(['role_id', 'user_id']); |
|
| 61 | }); |
|
| 62 | } |
|
| 63 | ||
| 64 | /** |
|