tmp.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 CommonSchema extends Migration {
        public function up() {
      // Journals and basic journal settings.
      Capsule::schema()->create('journals', function (Blueprint $table) {
         $table->bigInteger('journal_id')->autoIncrement();
         $table->string('path', 32);
         $table->float('seq', 8, 2)->default('0')->comment('Used to order lists of journals');
         $table->string('primary_locale', 14);
         $table->boolean('enabled')->default('1')->comment('Controls whether or not the journal is considered "live" and will appear on the website. (Note that disabled journals may still be accessible, but only if the user knows the URL.)');
      });
 
      // Journal settings.
      Capsule::schema()->create('journal_settings', function (Blueprint $table) {
         $table->bigInteger('journal_id');
         $table->string('locale', 14)->default('');
         $table->string('setting_name', 255);
         $table->text('setting_value')->nullable();
         $table->string('setting_type', 6)->nullable();
      });
 
      // Journal sections.
      Capsule::schema()->create('sections', function (Blueprint $table) {
         $table->bigInteger('section_id')->autoIncrement();
         $table->bigInteger('journal_id');
         $table->bigInteger('review_form_id')->nullable();
         $table->float('seq', 8, 2)->default('0');
         $table->boolean('editor_restricted')->default('0');
         $table->boolean('meta_indexed')->default('0');
         $table->boolean('meta_reviewed')->default('1');
         $table->boolean('abstracts_not_required')->default('0');
         $table->boolean('hide_title')->default('0');
         $table->boolean('hide_author')->default('0');
         $table->bigInteger('abstract_word_count')->nullable();
      });
 
      // Section-specific settings
      Capsule::schema()->create('section_settings', function (Blueprint $table) {
         $table->bigInteger('section_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)');
      });
 
      // Journal issues.
      Capsule::schema()->create('issues', function (Blueprint $table) {
         $table->bigInteger('issue_id')->autoIncrement();
         $table->bigInteger('journal_id');
         $table->smallInteger('volume')->nullable();
         $table->string('number', 40)->nullable();
         $table->smallInteger('year')->nullable();
         $table->boolean('published')->default('0');
         $table->boolean('current')->default('0');
         $table->timestamp('date_published')->nullable();
         $table->timestamp('date_notified')->nullable();
         $table->timestamp('last_modified')->nullable();
         $table->boolean('access_status')->default('1');
         $table->timestamp('open_access_date')->nullable();
         $table->boolean('show_volume')->default('0');
         $table->boolean('show_number')->default('0');
         $table->boolean('show_year')->default('0');
         $table->boolean('show_title')->default('0');
         $table->string('style_file_name', 90)->nullable();
         $table->string('original_style_file_name', 255)->nullable();
         $table->string('url_path', 64)->nullable();
      });
 
      // Locale-specific issue data
      Capsule::schema()->create('issue_settings', function (Blueprint $table) {
         $table->bigInteger('issue_id');
         $table->string('locale', 14)->default('');
         $table->string('setting_name', 255);
         $table->text('setting_value')->nullable();
         $table->string('setting_type', 6);
      });
 
      // Issue galleys.
      Capsule::schema()->create('issue_galleys', function (Blueprint $table) {
         $table->bigInteger('galley_id')->autoIncrement();
         $table->string('locale', 14)->nullable();
         $table->bigInteger('issue_id');
         $table->bigInteger('file_id');
         $table->string('label', 32)->nullable();
         $table->float('seq', 8, 2)->default('0');
         $table->string('url_path', 64)->nullable();
      });
 
      // Issue galley metadata.
      Capsule::schema()->create('issue_galley_settings', function (Blueprint $table) {
         $table->bigInteger('galley_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)');
      });
 
      Capsule::schema()->create('issue_files', function (Blueprint $table) {
         $table->bigInteger('file_id')->autoIncrement();
         $table->bigInteger('issue_id');
         $table->string('file_name', 90);
         $table->string('file_type', 255);
         $table->bigInteger('file_size');
         $table->bigInteger('content_type');
         $table->string('original_file_name', 127)->nullable();
         $table->timestamp('date_uploaded');
         $table->timestamp('date_modified');
      });
 
      // Custom sequencing information for journal issues, when available
      Capsule::schema()->create('custom_issue_orders', function (Blueprint $table) {
         $table->bigInteger('issue_id');
         $table->bigInteger('journal_id');
         $table->float('seq', 8, 2)->default('0');
      });
 
      // Custom sequencing information for journal sections by issue, when available.
      Capsule::schema()->create('custom_section_orders', function (Blueprint $table) {
         $table->bigInteger('issue_id');
         $table->bigInteger('section_id');
         $table->float('seq', 8, 2)->default('0');
      });
 
      // Archived, removed from TOC, unscheduled or unpublished journal articles.
      Capsule::schema()->create('submission_tombstones', function (Blueprint $table) {
         $table->bigInteger('tombstone_id')->autoIncrement();
         $table->bigInteger('submission_id');
         $table->timestamp('date_deleted');
         $table->bigInteger('journal_id');
         $table->bigInteger('section_id');
         $table->string('set_spec', 255);
         $table->string('set_name', 255);
         $table->string('oai_identifier', 255);
      });
 
      // Publications
      Capsule::schema()->create('publications', function (Blueprint $table) {
         $table->bigInteger('publication_id')->autoIncrement();
         $table->bigInteger('access_status')->default('0')->nullable();
         $table->date('date_published')->nullable();
         $table->timestamp('last_modified')->nullable();
         $table->string('locale', 14)->nullable();
         $table->bigInteger('primary_contact_id')->nullable();
         $table->bigInteger('section_id')->nullable();
         $table->float('seq', 8, 2)->default('0');
         $table->bigInteger('submission_id');
         $table->boolean('status')->default('1');
         $table->string('url_path', 64)->nullable();
         $table->bigInteger('version')->nullable();
      });
 
      // Publication galleys
      Capsule::schema()->create('publication_galleys', function (Blueprint $table) {
         $table->bigInteger('galley_id')->autoIncrement();
         $table->string('locale', 14)->nullable();
         $table->bigInteger('publication_id');
         $table->string('label', 255)->nullable();
         $table->bigInteger('file_id')->nullable();
         $table->float('seq', 8, 2)->default('0');
         $table->string('remote_url', 2047)->nullable();
         $table->boolean('is_approved')->default('0');
         $table->string('url_path', 64)->nullable();
      });
 
      // Galley metadata.
      Capsule::schema()->create('publication_galley_settings', function (Blueprint $table) {
         $table->bigInteger('galley_id');
         $table->string('locale', 14)->default('');
         $table->string('setting_name', 255);
         $table->text('setting_value')->nullable();
      });
 
      // Subscription types.
      Capsule::schema()->create('subscription_types', function (Blueprint $table) {
         $table->bigInteger('type_id')->autoIncrement();
         $table->bigInteger('journal_id');
         $table->float('cost', 8, 2);
         $table->string('currency_code_alpha', 3);
         $table->boolean('non_expiring')->default('0');
         $table->smallInteger('duration')->nullable();
         $table->smallInteger('format');
         $table->boolean('institutional')->default('0');
         $table->boolean('membership')->default('0');
         $table->boolean('disable_public_display');
         $table->float('seq', 8, 2);
      });
 
      // Locale-specific subscription type data
      Capsule::schema()->create('subscription_type_settings', function (Blueprint $table) {
         $table->bigInteger('type_id');
         $table->string('locale', 14)->default('');
         $table->string('setting_name', 255);
         $table->text('setting_value')->nullable();
         $table->string('setting_type', 6);
      });
 
      // Journal subscriptions.
      Capsule::schema()->create('subscriptions', function (Blueprint $table) {
         $table->bigInteger('subscription_id')->autoIncrement();
         $table->bigInteger('journal_id');
         $table->bigInteger('user_id');
         $table->bigInteger('type_id');
         $table->date('date_start')->nullable();
         $table->timestamp('date_end')->nullable();
         $table->boolean('status')->default('1');
         $table->string('membership', 40)->nullable();
         $table->string('reference_number', 40)->nullable();
         $table->text('notes')->nullable();
      });
 
      // Journal institutional subscriptions.
      Capsule::schema()->create('institutional_subscriptions', function (Blueprint $table) {
         $table->bigInteger('institutional_subscription_id')->autoIncrement();
         $table->bigInteger('subscription_id');
         $table->string('institution_name', 255);
         $table->string('mailing_address', 255)->nullable();
         $table->string('domain', 255)->nullable();
      });
 
      // Journal institutional subscription IPs and IP ranges.
      Capsule::schema()->create('institutional_subscription_ip', function (Blueprint $table) {
         $table->bigInteger('institutional_subscription_ip_id')->autoIncrement();
         $table->bigInteger('subscription_id');
         $table->string('ip_string', 40);
         $table->bigInteger('ip_start');
         $table->bigInteger('ip_end')->nullable();
      });
 
      // Logs queued (unfulfilled) payments.
      Capsule::schema()->create('queued_payments', function (Blueprint $table) {
         $table->bigInteger('queued_payment_id')->autoIncrement();
         $table->timestamp('date_created');
         $table->timestamp('date_modified');
         $table->date('expiry_date')->nullable();
         $table->text('payment_data')->nullable();
      });
 
      // Logs completed (fulfilled) payments.
      Capsule::schema()->create('completed_payments', function (Blueprint $table) {
         $table->bigInteger('completed_payment_id')->autoIncrement();
         $table->timestamp('timestamp');
         $table->bigInteger('payment_type');
         $table->bigInteger('context_id');
         $table->bigInteger('user_id')->nullable();
         $table->bigInteger('assoc_id')->nullable();
         $table->float('amount', 8, 2);
         $table->string('currency_code_alpha', 3)->nullable();
         $table->string('payment_method_plugin_name', 80)->nullable();
      });
 
   }
}