1 | <?php |
||
5 | class CreateUsers extends AbstractMigration |
||
6 | { |
||
7 | public function change() |
||
8 | { |
||
9 | $users = $this->table('users'); |
||
10 | //Id column automatically created by Phinx |
||
11 | $users->addColumn('enabled', 'boolean', ['limit' => 1, 'default' => 0]) |
||
12 | ->addColumn('email', 'string', ['limit' => 255]) |
||
13 | ->addColumn('password', 'string', ['limit' => 255]) |
||
14 | ->addColumn('salt', 'string', ['limit' => 16]) |
||
15 | ->addColumn('name', 'string', ['limit' => 100]) |
||
16 | ->addColumn('roles', 'string', ['limit' => 255]) |
||
17 | ->addColumn('verificiationKey', 'string', ['limit' => 16, 'null' => true, 'default' => null]) |
||
18 | ->addColumn('creationTime', 'datetime') |
||
19 | ->addIndex('email', ['unique' => true, 'name' => 'unique_email']) |
||
20 | ->create(); |
||
21 | } |
||
22 | } |
||
23 |