Reports

Complexity

Total Complexity

1

Size/Duplication

Total Lines	22
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	2

Importance

Changes	1
Bugs	0	Features	0

<?php
class Reports extends AbstractMigration
{
    /**
    * Create OAuth2 application tokens table
      */
    public function change()
    {
        $oauthTokens = $this->table('reports');
        $oauthTokens->addColumn('uuid', 'string', ['comment' => 'UUID', 'limit' => 36, 'null' => false])
              ->addColumn('users_uuid', 'string', ['comment' => 'User UUID', 'limit' => 36])
              ->addColumn('groups', 'string', ['comment' => 'Account Groups', 'limit' => 64, 'default' => 'user'])
              ->addColumn('key', 'string', ['comment' => 'Key', 'limit' => 255])
              ->addColumn('name', 'string', ['comment' => 'Name', 'limit' => 255])
              ->addColumn('description', 'text', ['comment' => 'Description', 'null' => true])
              ->addColumn('query', 'text', ['comment' => 'Query', 'null' => true])
              ->addColumn('options', 'text', ['comment' => 'Extra Options', 'null' => true])
              ->addColumn('created', 'datetime', ['comment' => 'Created'])
              ->addIndex(['uuid'], ['unique' => true])
              ->addForeignKey('users_uuid', 'users', 'uuid', ['delete'=> 'CASCADE', 'update'=> 'CASCADE'])
              ->save();
    }
}