PKPv3_2_1SubeditorCategoriesMigration.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 PKPv3_2_1SubeditorCategoriesMigration extends Migration {
   public function up() {
      // Schema changes
      Capsule::schema()->rename('section_editors', 'subeditor_submission_group');
      Capsule::schema()->table('subeditor_submission_group', function (Blueprint $table) {
         // Change section_id to assoc_type/assoc_id
         $table->bigInteger('assoc_type');
         $table->renameColumn('section_id', 'assoc_id');
 
         // Drop indexes
         $table->dropIndex('section_editors_pkey');
         $table->dropIndex('section_editors_context_id');
         $table->dropIndex('section_editors_section_id');
         $table->dropIndex('section_editors_user_id');
 
         // Create indexes
         $table->index(['context_id'], 'section_editors_context_id');
         $table->index(['assoc_id', 'assoc_type'], 'subeditor_submission_group_assoc_id');
         $table->index(['user_id'], 'subeditor_submission_group_user_id');
         $table->unique(['context_id', 'assoc_id', 'assoc_type', 'user_id'], 'section_editors_pkey');
      });
 
      // Populate the assoc_type data in the newly created column
      Capsule::table('subeditor_submission_group')->update(['assoc_type' => ASSOC_TYPE_SECTION]);
   }
 
   public function down() {
      throw new PKP\install\DowngradeNotSupportedException();
   }
}