Porto-SAP /
Hello-API
| @@ 33-48 (lines=16) @@ | ||
| 30 | $table->timestamps(); |
|
| 31 | }); |
|
| 32 | ||
| 33 | Schema::create($config['user_has_permissions'], function (Blueprint $table) use ($config) { |
|
| 34 | $table->integer('user_id')->unsigned(); |
|
| 35 | $table->integer('permission_id')->unsigned(); |
|
| 36 | ||
| 37 | $table->foreign('user_id') |
|
| 38 | ->references('id') |
|
| 39 | ->on($config['users']) |
|
| 40 | ->onDelete('cascade'); |
|
| 41 | ||
| 42 | $table->foreign('permission_id') |
|
| 43 | ->references('id') |
|
| 44 | ->on($config['permissions']) |
|
| 45 | ->onDelete('cascade'); |
|
| 46 | ||
| 47 | $table->primary(['user_id', 'permission_id']); |
|
| 48 | }); |
|
| 49 | ||
| 50 | Schema::create($config['user_has_roles'], function (Blueprint $table) use ($config) { |
|
| 51 | $table->integer('role_id')->unsigned(); |
|
| @@ 50-65 (lines=16) @@ | ||
| 47 | $table->primary(['user_id', 'permission_id']); |
|
| 48 | }); |
|
| 49 | ||
| 50 | Schema::create($config['user_has_roles'], function (Blueprint $table) use ($config) { |
|
| 51 | $table->integer('role_id')->unsigned(); |
|
| 52 | $table->integer('user_id')->unsigned(); |
|
| 53 | ||
| 54 | $table->foreign('role_id') |
|
| 55 | ->references('id') |
|
| 56 | ->on($config['roles']) |
|
| 57 | ->onDelete('cascade'); |
|
| 58 | ||
| 59 | $table->foreign('user_id') |
|
| 60 | ->references('id') |
|
| 61 | ->on($config['users']) |
|
| 62 | ->onDelete('cascade'); |
|
| 63 | ||
| 64 | $table->primary(['role_id', 'user_id']); |
|
| 65 | }); |
|
| 66 | ||
| 67 | Schema::create($config['role_has_permissions'], function (Blueprint $table) use ($config) { |
|
| 68 | $table->integer('permission_id')->unsigned(); |
|
| @@ 67-82 (lines=16) @@ | ||
| 64 | $table->primary(['role_id', 'user_id']); |
|
| 65 | }); |
|
| 66 | ||
| 67 | Schema::create($config['role_has_permissions'], function (Blueprint $table) use ($config) { |
|
| 68 | $table->integer('permission_id')->unsigned(); |
|
| 69 | $table->integer('role_id')->unsigned(); |
|
| 70 | ||
| 71 | $table->foreign('permission_id') |
|
| 72 | ->references('id') |
|
| 73 | ->on($config['permissions']) |
|
| 74 | ->onDelete('cascade'); |
|
| 75 | ||
| 76 | $table->foreign('role_id') |
|
| 77 | ->references('id') |
|
| 78 | ->on($config['roles']) |
|
| 79 | ->onDelete('cascade'); |
|
| 80 | ||
| 81 | $table->primary(['permission_id', 'role_id']); |
|
| 82 | }); |
|
| 83 | } |
|
| 84 | ||
| 85 | /** |
|
