20170728074729_create_entity_subtypes_table.php

Go to the documentation of this file.

<?php

use Phinx\Migration\AbstractMigration;

class CreateEntitySubtypesTable extends AbstractMigration {
    public function change() {

        if ($this->hasTable("entity_subtypes")) {
            return;
        }

        $table = $this->table("entity_subtypes", [
            'engine' => "InnoDB",
            'encoding' => "utf8",
            'collation' => "utf8_general_ci",
        ]);

        $table->addColumn('type', 'enum', [
            'null' => false,
            'limit' => 6,
            'values' => [
                'object',
                'user',
                'group',
                'site'
            ],
        ]);

        $table->addColumn('subtype', 'string', [
            'null' => false,
            'limit' => 50,
        ]);

        $table->addColumn('class', 'string', [
            'null' => false,
            'default' => '',
            'limit' => 255,
        ]);

        $table->addIndex([
            'type',
            'subtype'
        ], [
            'name' => "type",
            'unique' => true
        ]);

        $table->insert([
            [
                'type' => 'object',
                'subtype' => 'plugin',
                'class' => 'ElggPlugin',
            ],
            [
                'type' => 'object',
                'subtype' => 'file',
                'class' => 'ElggFile',
            ],
            [
                'type' => 'object',
                'subtype' => 'widget',
                'class' => 'ElggWidget',
            ],
            [
                'type' => 'object',
                'subtype' => 'comment',
                'class' => 'ElggComment',
            ],
            [
                'type' => 'object',
                'subtype' => 'elgg_upgrade',
                'class' => 'ElggUpgrade',
            ],
            [
                'type' => 'object',
                'subtype' => 'admin_notice',
                'class' => '',
            ],
        ]);

        $table->save();
    }
}