Articles

Complexity

Total Complexity

2

Size/Duplication

Total Lines	27
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	2

Importance

Changes

0

<?php
class Articles extends AbstractMigration
{
    public function up()
    {
        $this->table('articles', ['id' => false, 'primary_key' => 'article_uuid'])
            ->addColumn('article_uuid', 'binary', ['limit' => 16])
            ->addColumn('article_id', 'text')
            ->addColumn('slug', 'text', ['null' => true])
            ->addColumn('created_at', 'datetime', ['default' => 'CURRENT_TIMESTAMP'])
            ->addColumn('published_at', 'datetime', ['default' => 'CURRENT_TIMESTAMP'])
            ->addColumn('type', 'integer')      // see Article\Entity\ArticleType
            ->addColumn('status', 'integer')    // active, not active, ...
            ->addColumn('admin_user_uuid', 'binary', ['limit' => 16])
            ->addColumn('is_wysiwyg_editor', 'boolean', ['default' => false])
            ->addColumn('category_uuid', 'binary', ['limit' => 16])
            ->addForeignKey('category_uuid', 'category', 'category_uuid', ['delete' => 'NO_ACTION', 'update' => 'NO_ACTION'])
            ->addForeignKey('admin_user_uuid', 'admin_users', 'admin_user_uuid', ['delete' => 'NO_ACTION', 'update' => 'NO_ACTION'])
            ->addIndex('type', ['name' => 'type_INDEX'])
            ->addIndex('published_at', ['name' => 'published_at_INDEX'])
            ->create();
    }

    public function down()
    {
        $this->dropTable('articles');
    }
}