+global\UsersData::change()

Complexity

Conditions	1
Paths	1

Size

Total Lines	13
Code Lines	11

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

<?php
    public function change()
    {
        $users = $this->table('users_data');
        $users->addColumn('uuid', 'string', ['comment' => 'UUID', 'limit' => 36])
              ->addColumn('users_uuid', 'string', ['comment' => 'User UUID', 'limit' => 36])
              ->addColumn('key', 'string', ['comment' => 'Key', 'limit' => 255])
              ->addColumn('value', 'text', ['comment' => 'Value', 'null' => true])
              ->addColumn('type', 'string', ['comment' => 'Type', 'limit' => 255])
              ->addIndex(['uuid'], ['unique' => true])
              ->addIndex(['users_uuid', 'key'], ['unique' => true])
              ->addForeignKey('users_uuid', 'users', 'uuid', ['delete'=> 'CASCADE', 'update'=> 'CASCADE'])
              ->save();
    }
}