Advertisement
lukmanulhakim

1. Migration table create_table_rev_his

Feb 17th, 2020
117
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.48 KB | None | 0 0
  1. <?php
  2.  
  3. use Illuminate\Support\Facades\Schema;
  4. use Illuminate\Database\Schema\Blueprint;
  5. use Illuminate\Database\Migrations\Migration;
  6.  
  7. class CreateTableRevHis extends Migration
  8. {
  9. /**
  10. * Run the migrations.
  11. *
  12. * @return void
  13. */
  14. public function up()
  15. {
  16. Schema::create('revisi_history', function (Blueprint $table) {
  17. $table->increments('id');
  18. $table->integer('machine_id');
  19. $table->string('rev')->nullable();
  20. $table->string('date')->nullable();
  21. $table->string('change_item')->nullable();
  22. $table->string('reason')->nullable();
  23. $table->string('checked')->nullable();
  24. $table->string('change')->nullable();
  25. $table->string('gambar1')->nullable();
  26. $table->string('gambar2')->nullable();
  27. $table->string('gambar3')->nullable();
  28. $table->string('gambar4')->nullable();
  29. $table->string('gambar5')->nullable();
  30. $table->string('cadangan1')->nullable();
  31. $table->string('cadangan2')->nullable();
  32. $table->string('cadangan3')->nullable();
  33. $table->string('cadangan4')->nullable();
  34. $table->string('cadangan5')->nullable();
  35. $table->timestamps();
  36. });
  37. }
  38.  
  39. /**
  40. * Reverse the migrations.
  41. *
  42. * @return void
  43. */
  44. public function down()
  45. {
  46. Schema::dropIfExists('revisi_history');
  47. }
  48. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement