2020_12_14_101617_create_customerlogs_table.php 706 B

12345678910111213141516171819202122232425
  1. <?php
  2. use Illuminate\Database\Schema\Blueprint;
  3. use Illuminate\Database\Migrations\Migration;
  4. use Illuminate\Support\Facades\Schema;
  5. class CreateCustomerLogsTable extends Migration
  6. {
  7. public function up()
  8. {
  9. Schema::create('customer_logs', function (Blueprint $table) {
  10. $table->increments('id');
  11. $table->bigInteger('customer_id')->unsigned()->index();
  12. $table->integer('customer_log_status_id')->unsigned()->index();
  13. $table->bigInteger('user_id')->unsigned()->index();
  14. $table->text('description');
  15. $table->timestamps();
  16. });
  17. }
  18. public function down()
  19. {
  20. Schema::drop('customer_logs');
  21. }
  22. }