GenresMigration.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 GenresMigration extends Migration {
        public function up() {
      // A context's submission file genres.
      Capsule::schema()->create('genres', function (Blueprint $table) {
         $table->bigInteger('genre_id')->autoIncrement();
         $table->bigInteger('context_id');
         $table->bigInteger('seq');
         $table->tinyInteger('enabled')->default(1);
         $table->bigInteger('category')->default(1);
         $table->tinyInteger('dependent')->default(0);
         $table->tinyInteger('supplementary')->default(0);
         $table->string('entry_key', 30)->nullable();
      });
 
      // Genre settings
      Capsule::schema()->create('genre_settings', function (Blueprint $table) {
         $table->bigInteger('genre_id');
         $table->string('locale', 14)->default('');
         $table->string('setting_name', 255);
         $table->text('setting_value')->nullable();
         $table->string('setting_type', 6)->comment('(bool|int|float|string|object)');
         $table->index(['genre_id'], 'genre_settings_genre_id');
         $table->unique(['genre_id', 'locale', 'setting_name'], 'genre_settings_pkey');
      });
 
   }
 
   public function down() {
      Capsule::schema()->drop('genre_settings');
      Capsule::schema()->drop('genres');
   }
}