AnnouncementsMigration.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 AnnouncementsMigration extends Migration {
   public function up() {
      // Announcement types.
      Capsule::schema()->create('announcement_types', function (Blueprint $table) {
         $table->bigInteger('type_id')->autoIncrement();
         $table->smallInteger('assoc_type');
         $table->bigInteger('assoc_id');
         $table->index(['assoc_type', 'assoc_id'], 'announcement_types_assoc');
      });
 
      // Locale-specific announcement type data
      Capsule::schema()->create('announcement_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);
         $table->index(['type_id'], 'announcement_type_settings_type_id');
         $table->unique(['type_id', 'locale', 'setting_name'], 'announcement_type_settings_pkey');
      });
 
      // Announcements.
      Capsule::schema()->create('announcements', function (Blueprint $table) {
         $table->bigInteger('announcement_id')->autoIncrement();
         //  NOT NULL not included for upgrade purposes
         $table->smallInteger('assoc_type')->nullable();
         $table->bigInteger('assoc_id');
         $table->bigInteger('type_id')->nullable();
         $table->date('date_expire')->nullable();
         $table->datetime('date_posted');
         $table->index(['assoc_type', 'assoc_id'], 'announcements_assoc');
      });
 
      // Locale-specific announcement data
      Capsule::schema()->create('announcement_settings', function (Blueprint $table) {
         $table->bigInteger('announcement_id');
         $table->string('locale', 14)->default('');
         $table->string('setting_name', 255);
         $table->text('setting_value')->nullable();
         $table->string('setting_type', 6)->nullable();
         $table->index(['announcement_id'], 'announcement_settings_announcement_id');
         $table->unique(['announcement_id', 'locale', 'setting_name'], 'announcement_settings_pkey');
      });
   }
 
   public function down() {
      Capsule::schema()->drop('announcement_types');
      Capsule::schema()->drop('announcement_type_settings');
      Capsule::schema()->drop('announcements');
      Capsule::schema()->drop('announcement_settings');
   }
}