3 use Phinx\Migration\AbstractMigration;
4 use Phinx\Db\Adapter\MysqlAdapter;
20 if ($this->hasTable(
"users_apisessions")) {
24 $table = $this->table(
"users_apisessions", [
26 'encoding' =>
"utf8mb4",
27 'collation' =>
"utf8mb4_general_ci",
30 $table->addColumn(
'user_guid',
'integer', [
32 'limit' => MysqlAdapter::INT_BIG,
37 $table->addColumn(
'token',
'string', [
42 $table->addColumn(
'expires',
'integer', [
44 'limit' => MysqlAdapter::INT_REGULAR,
49 $table->addIndex([
'user_guid'], [
50 'name' =>
"user_guid",
54 $table->addIndex([
'token'], [
change()
CREATE TABLE prefix_users_apisessions ( id int(11) NOT NULL AUTO_INCREMENT, user_guid bigint(20) unsi...