Guest User

Untitled

a guest
Nov 16th, 2017
95
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.90 KB | None | 0 0
  1. **RolesPermission migration table**
  2.  
  3. Schema::create('roles', function(Blueprint $table){
  4. $table->increments('id');
  5. $table->string('name')->unique();
  6. $table->string('label');
  7. $table->string('description')->nullable();
  8. $table->timestamps();
  9. });
  10.  
  11. Schema::create('permissions', function(Blueprint $table){
  12. $table->increments('id');
  13. $table->string('name')->unique();
  14. $table->string('label');
  15. $table->string('description')->nullable();
  16. $table->timestamps();
  17. });
  18.  
  19. Schema::create('permission_role', function(Blueprint $table){
  20. $table->integer('permission_id')->unsigned();
  21. $table->integer('role_id')->unsigned();
  22.  
  23. $table->foreign('permission_id')
  24. ->references('id')
  25. ->on('permissions')
  26. ->onDelete('cascade');
  27.  
  28. $table->foreign('role_id')
  29. ->references('id')
  30. ->on('roles')
  31. ->onDelete('cascade');
  32.  
  33. $table->primary(['permission_id', 'role_id']);
  34. });
  35.  
  36. Schema::create('role_user', function(Blueprint $table){
  37. $table->integer('role_id')->unsigned();
  38. $table->integer('user_id')->unsigned();
  39.  
  40. $table->foreign('role_id')
  41. ->references('id')
  42. ->on('roles')
  43. ->onDelete('cascade');
  44.  
  45. $table->foreign('user_id')
  46. ->references('id')
  47. ->on('users')
  48. ->onDelete('cascade');
  49.  
  50. $table->primary(['role_id', 'user_id']);
  51.  
  52. });
  53.  
  54.  
  55. .env file
  56. APP_ENV=local
  57. APP_DEBUG=true
  58. APP_KEY=W8YWZe3LCngvZzexH3WLWqCDlYRSufuy
  59.  
  60. DB_HOST=127.0.0.1
  61. DB_DATABASE=testing
  62. DB_USERNAME=root
  63. DB_PASSWORD=
  64.  
  65. CACHE_DRIVER=file
  66. SESSION_DRIVER=file
  67. QUEUE_DRIVER=sync
  68.  
  69. REDIS_HOST=127.0.0.1
  70. REDIS_PASSWORD=null
  71. REDIS_PORT=6379
  72.  
  73. MAIL_DRIVER=log
  74. MAIL_HOST=mailtrap.io
  75. MAIL_PORT=2525
  76. MAIL_USERNAME=null
  77. MAIL_PASSWORD=null
  78. MAIL_ENCRYPTION=null
  79.  
  80. SQLSTATE[42S02]: Base table or view not found: 1146 Table 'testing.permissions' doesn't exist
  81.  
  82. Schema::create('permission_role', function(Blueprint $table){
  83. $table->integer('permission_id')->unsigned();
  84. $table->integer('role_id')->unsigned();
  85.  
  86. $table->foreign('permission_id')
  87. ->references('id')
  88. ->on('permissions')
  89. ->onDelete('cascade');
  90.  
  91. $table->foreign('role_id')
  92. ->references('id')
  93. ->on('roles')
  94. ->onDelete('cascade');
  95.  
  96. $table->primary(['permission_id', 'role_id']);
  97. });
  98.  
  99. 2016_10_09_134416_create_permission_role_table
  100. 2016_10_09_134416_create_permissions_table
  101.  
  102. 2016_10_09_134415_create_permissions_table
  103. 2016_10_09_134416_create_permission_role_table
  104.  
  105. composer dump-autoload
Add Comment
Please, Sign In to add comment