2020_01_02_100001_create_matrix_milestones_table.php

<?php
/**
 * Playground
 */

declare(strict_types=1);

use Illuminate\Database\Migrations\Migration;
use Illuminate\Database\Query\Expression;
use Illuminate\Database\Schema\Blueprint;
use Illuminate\Support\Facades\Schema;

/**
 * \Playground\Matrix\Models\Milestone
 */
return new class() extends Migration
{
    /**
     * Run the migrations.
     */
    public function up(): void
    {
        Schema::create('matrix_milestones', function (Blueprint $table) {

            // Primary key

            $table->uuid('id')->primary();

            // IDs

            $table->string('milestone_type')->nullable()->index();
            $table->uuid('created_by_id')->nullable()->index();
            $table->uuid('modified_by_id')->nullable()->index();
            $table->uuid('owned_by_id')->nullable()->index();
            $table->uuid('parent_id')->nullable()->index();
            $table->uuid('backlog_id')->nullable()->index();
            $table->uuid('board_id')->nullable()->index();
            $table->uuid('epic_id')->nullable()->index();
            $table->uuid('flow_id')->nullable()->index();
            $table->uuid('matrix_id')->nullable()->index();
            $table->uuid('note_id')->nullable()->index();
            $table->uuid('project_id')->nullable()->index();
            $table->uuid('release_id')->nullable()->index();
            $table->uuid('roadmap_id')->nullable()->index();
            $table->uuid('source_id')->nullable()->index();
            $table->uuid('sprint_id')->nullable()->index();
            $table->uuid('tag_id')->nullable()->index();
            $table->uuid('team_id')->nullable()->index();
            $table->uuid('ticket_id')->nullable()->index();
            $table->uuid('version_id')->nullable()->index();

            // Dates

            $table->timestamps();

            $table->softDeletes();

            $table->dateTime('canceled_at')->nullable();
            $table->dateTime('closed_at')->nullable()->index();
            $table->dateTime('embargo_at')->nullable();
            $table->dateTime('planned_end_at')->nullable();
            $table->dateTime('planned_start_at')->nullable();
            $table->dateTime('postponed_at')->nullable();
            $table->dateTime('published_at')->nullable();
            $table->dateTime('resolved_at')->nullable()->index();
            $table->dateTime('resumed_at')->nullable();
            $table->dateTime('suspended_at')->nullable();
            $table->dateTime('timer_end_at')->nullable()->index();
            $table->dateTime('timer_start_at')->nullable()->index();

            // Permissions

            $table->bigInteger('gids')->default(0)->unsigned();
            $table->tinyInteger('po')->default(0)->unsigned();
            $table->tinyInteger('pg')->default(0)->unsigned();
            $table->tinyInteger('pw')->default(0)->unsigned();
            $table->boolean('only_admin')->default(0);
            $table->boolean('only_user')->default(0);
            $table->boolean('only_guest')->default(0);
            $table->boolean('allow_public')->default(0);

            // Status

            $table->bigInteger('status')->default(0)->unsigned();
            $table->bigInteger('rank')->default(0);
            $table->bigInteger('size')->default(0);

            // Matrix

            $table->json('matrix')->nullable()->default(new Expression('(JSON_OBJECT())'));
            $table->bigInteger('x')->nullable();
            $table->bigInteger('y')->nullable();
            $table->bigInteger('z')->nullable();
            $table->decimal('r', 65, 10)->nullable();
            $table->decimal('theta', 10, 6)->nullable();
            $table->decimal('rho', 10, 6)->nullable();
            $table->decimal('phi', 10, 6)->nullable();
            $table->decimal('elevation', 65, 10)->nullable();
            $table->decimal('latitude', 8, 6)->nullable();
            $table->decimal('longitude', 9, 6)->nullable();

            // Flags

            $table->boolean('active')->default(1)->index();
            $table->boolean('canceled')->default(0);
            $table->boolean('closed')->default(0);
            $table->boolean('completed')->default(0);
            $table->boolean('cron')->default(0)->index();
            $table->boolean('featured')->default(0);
            $table->boolean('flagged')->default(0);
            $table->boolean('internal')->default(0);
            $table->boolean('locked')->default(0);
            $table->boolean('pending')->default(0);
            $table->boolean('planned')->default(0);
            $table->boolean('prioritized')->default(0);
            $table->boolean('problem')->default(0);
            $table->boolean('published')->default(0);
            $table->boolean('released')->default(0);
            $table->boolean('retired')->default(0);
            $table->boolean('special')->default(0);
            $table->boolean('suspended')->default(0);
            $table->boolean('unknown')->default(0);

            // Columns

            $table->string('locale', 255)->default('');
            $table->string('label', 128)->default('');
            $table->string('title', 255)->default('');
            $table->string('byline', 255)->default('');
            $table->string('slug', 128)->nullable()->index();
            $table->string('url', 512)->default('');
            $table->string('description', 512)->default('');
            $table->string('introduction', 512)->default('');
            $table->mediumText('content')->nullable();
            $table->mediumText('summary')->nullable();

            // Ui

            $table->string('icon', 128)->default('');
            $table->string('image', 512)->default('');
            $table->string('avatar', 512)->default('');
            $table->json('ui')->nullable()->default(new Expression('(JSON_OBJECT())'));

            // JSON

            $table->json('assets')->nullable()->default(new Expression('(JSON_OBJECT())'));
            $table->json('backlog')->nullable()->default(new Expression('(JSON_OBJECT())'));
            $table->json('board')->nullable()->default(new Expression('(JSON_OBJECT())'));
            $table->json('flow')->nullable()->default(new Expression('(JSON_OBJECT())'));
            $table->json('history')->nullable()->default(new Expression('(JSON_OBJECT())'));
            $table->json('meta')->nullable()->default(new Expression('(JSON_OBJECT())'));
            $table->json('notes')->nullable()->default(new Expression('(JSON_ARRAY())'))->comment('Array of note objects');
            $table->json('options')->nullable()->default(new Expression('(JSON_OBJECT())'));
            $table->json('roadmap')->nullable()->default(new Expression('(JSON_OBJECT())'));
            $table->json('sources')->nullable()->default(new Expression('(JSON_OBJECT())'));
        });
    }

    /**
     * Reverse the migrations.
     */
    public function down(): void
    {
        Schema::dropIfExists('matrix_milestones');
    }
};