/
20190912072543_create_user_sessions.php
76 lines (65 loc) · 1.92 KB
/
20190912072543_create_user_sessions.php
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
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
<?php
use Phinx\Migration\AbstractMigration;
class CreateUserSessions extends AbstractMigration
{
/**
* Change Method.
*
* Write your reversible migrations using this method.
*
* More information on writing migrations is available here:
* http://docs.phinx.org/en/latest/migrations.html#the-abstractmigration-class
*
* The following commands can be used in this method and Phinx will
* automatically reverse them when rolling back:
*
* createTable
* renameTable
* addColumn
* renameColumn
* addIndex
* addForeignKey
*
* Remember to call "create()" or "update()" and NOT "save()" when working
* with the Table class.
*/
public function change()
{
$table = $this->table('directus_user_sessions', ['signed' => false]);
$table->addColumn('user', 'integer', [
'signed' => false,
'null' => true,
'default' => null
]);
$table->addColumn('token_type', 'string', [
'null' => true,
'default' => null
]);
$table->addColumn('token', 'string', [
'limit' => 520,
'encoding' => 'utf8',
'null' => true,
'default' => null
]);
$table->addColumn('ip_address', 'string', [
'limit' => 255,
'encoding' => 'utf8',
'null' => true,
'default' => null
]);
$table->addColumn('user_agent', 'text', [
'default' => null,
'null' => true,
'default' => null
]);
$table->addColumn('created_on', 'datetime', [
'null' => true,
'default' => null
]);
$table->addColumn('token_expired_at', 'datetime', [
'null' => true,
'default' => null
]);
$table->create();
}
}