ViewsMigration.inc.php

<?php
 
use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Schema\Builder;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Database\Capsule\Manager as Capsule;
 
class ViewsMigration extends Migration {
        public function up() {
      // Tracking of views for various types of objects such as files, reviews, etc
      Capsule::schema()->create('item_views', function (Blueprint $table) {
         $table->bigInteger('assoc_type');
         $table->string('assoc_id', 32);
         $table->bigInteger('user_id')->nullable();
         $table->datetime('date_last_viewed')->nullable();
         $table->unique(['assoc_type', 'assoc_id', 'user_id'], 'item_views_pkey');
      });
   }
 
   public function down() {
      Capsule::schema()->drop('item_views');
   }
}