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

Complexity

Conditions	1
Paths	1

Size

Total Lines	41
Code Lines	29

Duplication

Lines	0
Ratio	0 %

Importance

Changes	1
Bugs	0	Features	0

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

            $table->string('username')
                 ->description('The username')
                 ->unique()
                 ->notNull();

            $table->string('email')
                 ->description('The user email')
                 ->unique()
                 ->notNull();

            $table->string('password')
                 ->description('The user password')
                 ->notNull();

            $table->enum('status', ['A', 'D'])
                 ->description('The user status, A=Active, D=Deactive/Locked')
                 ->defaultValue('D')
                 ->notNull();

            $table->string('lastname')
                 ->description('The user lastname')
                 ->notNull();

            $table->string('firstname')
                 ->description('The user firstname')
                  ->notNull();

            $table->string('role')
                 ->description('The user role or job');

            $table->timestamps();

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