Platine\Framework\Migration\AddApiTokensTable20210823152146::up()

Complexity

Conditions	1
Paths	1

Size

Total Lines	30
Code Lines	20

Duplication

Lines	0
Ratio	0 %

Importance

Changes	2
Bugs	0	Features	0

<?php
    public function up(): void
    {
      //Action when migrate up
        $this->create('tokens', function (CreateTable $table) {
            $table->integer('id')
                    ->autoincrement()
                    ->primary();

            $table->string('token')
                   ->unique()
                   ->notNull();

            $table->string('refresh_token')
                   ->unique()
                   ->notNull();

            $table->datetime('expire_at')
                  ->notNull();

            $table->integer('user_id')
                   ->description('The owner of the token')
                   ->notNull();

            $table->timestamps();
            
            $table->foreign('user_id')
                    ->references('users', 'id')
                    ->onDelete('NO ACTION');
            
            $table->engine('INNODB');
        });