@@ 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 | /** |