ReviewFormsMigration.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 ReviewFormsMigration extends Migration {
        public function up() {
      // Review forms.
      Capsule::schema()->create('review_forms', function (Blueprint $table) {
         $table->bigInteger('review_form_id')->autoIncrement();
         $table->bigInteger('assoc_type');
         $table->bigInteger('assoc_id');
         $table->float('seq', 8, 2)->nullable();
         $table->smallInteger('is_active')->nullable();
      });
 
      // Review form settings
      Capsule::schema()->create('review_form_settings', function (Blueprint $table) {
         $table->bigInteger('review_form_id');
         $table->string('locale', 14)->default('');
         $table->string('setting_name', 255);
         $table->text('setting_value')->nullable();
         $table->string('setting_type', 6);
         $table->index(['review_form_id'], 'review_form_settings_review_form_id');
         $table->unique(['review_form_id', 'locale', 'setting_name'], 'review_form_settings_pkey');
      });
 
      // Review form elements.
      Capsule::schema()->create('review_form_elements', function (Blueprint $table) {
         $table->bigInteger('review_form_element_id')->autoIncrement();
         $table->bigInteger('review_form_id');
         $table->float('seq', 8, 2)->nullable();
         $table->bigInteger('element_type')->nullable();
         $table->smallInteger('required')->nullable();
         $table->smallInteger('included')->nullable();
         $table->index(['review_form_id'], 'review_form_elements_review_form_id');
      });
 
      // Review form element settings
      Capsule::schema()->create('review_form_element_settings', function (Blueprint $table) {
         $table->bigInteger('review_form_element_id');
         $table->string('locale', 14)->default('');
         $table->string('setting_name', 255);
         $table->text('setting_value')->nullable();
         $table->string('setting_type', 6);
         $table->index(['review_form_element_id'], 'review_form_element_settings_review_form_element_id');
         $table->unique(['review_form_element_id', 'locale', 'setting_name'], 'review_form_element_settings_pkey');
      });
 
      // Review form responses.
      Capsule::schema()->create('review_form_responses', function (Blueprint $table) {
         $table->bigInteger('review_form_element_id');
         $table->bigInteger('review_id');
         $table->string('response_type', 6)->nullable();
         $table->text('response_value')->nullable();
         $table->index(['review_form_element_id', 'review_id'], 'review_form_responses_pkey');
      });
   }
 
   public function down() {
      Capsule::schema()->drop('review_form_responses');
      Capsule::schema()->drop('review_form_element_settings');
      Capsule::schema()->drop('review_form_elements');
      Capsule::schema()->drop('review_form_settings');
      Capsule::schema()->drop('review_forms');
   }
}