Advertisement
vitareinforce

ganti fk inventory histories

Sep 16th, 2021
42
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.05 KB | None | 0 0
  1. <?php
  2.  
  3. use Illuminate\Database\Migrations\Migration;
  4. use Illuminate\Database\Schema\Blueprint;
  5. use Illuminate\Support\Facades\Schema;
  6.  
  7. class ChangeFkOnDeleteInventoryHistories extends Migration
  8. {
  9. /**
  10. * Run the migrations.
  11. *
  12. * @return void
  13. */
  14. public function up()
  15. {
  16. Schema::table('inventory_histories', function (Blueprint $table) {
  17. $table->dropForeign(['ItemId'])->nullable();
  18. $table->bigInteger('ItemId')->unsigned()->nullable()->change();
  19. $table->foreign('ItemId')->references('Id')->on('inventories')->onDelete('no action');
  20. });
  21. }
  22.  
  23. /**
  24. * Reverse the migrations.
  25. *
  26. * @return void
  27. */
  28. public function down()
  29. {
  30. Schema::table('inventory_histories', function (Blueprint $table) {
  31. $table->dropForeign(['ItemId'])->nullable();
  32. $table->bigInteger('ItemId')->unsigned()->change();
  33. $table->foreign('ItemId')->references('Id')->on('inventories')->onDelete('cascade');
  34. });
  35. }
  36. }
  37.  
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement