Platine\Framework\Migration\AddUsersTable20210705065248

Complexity

Total Complexity

2

Size/Duplication

Total Lines	55
Duplicated Lines	0 %

Importance

Changes	1
Bugs	0	Features	0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	down()	0	4	1
A	up()	0	45	1

<?php
namespace Platine\Framework\Migration;

use Platine\Database\Schema\CreateTable;
use Platine\Framework\Migration\AbstractMigration;

class AddUsersTable20210705065248 extends AbstractMigration
{

    public function up(): void
    {
      //Action when migrate up
      $this->create('users', function (CreateTable $table) {
          $table->integer('id')
                  ->autoincrement()
                 ->primary();
          
          $table->string('username')
                 ->description('The user username')
                 ->unique()
                 ->notNull();
          
          $table->string('email')
                 ->description('The user email')
                 ->unique()
                 ->notNull();
          
          $table->string('password')
                 ->description('The user password')
                 ->notNull();
          
          $table->integer('status')
                 ->size('tiny')
                 ->description('The user status')
                 ->defaultValue(0);
          
          $table->integer('age')
                 ->size('tiny')
                 ->description('The user age');
          
          $table->string('lastname')
                 ->description('The user lastname');
          
          $table->string('firstname')
                 ->description('The user firstname');
          
          $table->datetime('created_at')
                  ->description('created date')
                  ->notNull();
          
          $table->datetime('updated_at')
                  ->description('last updated date');

          $table->engine('INNODB');
      });
    }

    public function down(): void
    {
      //Action when migrate down
      $this->drop('users');
    }
}