1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
|
<?php
class CreateUserTable extends \Psecio\Gatekeeper\PhinxMigration
{
protected $tableName = 'users';
/**
* Migrate Up, create the user table
*/
public function up()
{
$tableName = $this->getTableName();
$users = $this->table($tableName);
$users->addColumn('username', 'string', array('limit' => 20))
->addColumn('password', 'string', array('limit' => 100))
->addColumn('email', 'string', array('limit' => 100))
->addColumn('first_name', 'string', array('limit' => 30))
->addColumn('last_name', 'string', array('limit' => 30))
->addColumn('status', 'string', array('limit' => 30, 'default' => 'active'))
->addColumn('created', 'datetime')
->addColumn('updated', 'datetime', array('default' => null))
->addIndex(array('username'), array('unique' => true))
->save();
// Manually add these as there seems to be a bug in Phinx...
$this->execute('alter table '.$tableName.' add password_reset_code VARCHAR(100)');
$this->execute('alter table '.$tableName.' add password_reset_code_timeout DATETIME');
}
/**
* Migrate Down, remove the user table
*/
public function down()
{
$this->dropTable($this->getTableName());
}
}
|
