App\Ship\Migration\Users_21012021130204_migration

Complexity

Total Complexity

1

Size/Duplication

Total Lines	20
Duplicated Lines	0 %

Importance

Changes

0

1 Method

Rating	Name	Duplication	Size	Complexity
A	up()	0	18	1

<?php

namespace App\Ship\Migration;

use Rudra\Container\Facades\Rudra;

class Users_21012021130204_migration
{
    public function up(): void
    {
        $table = "users";

        $query = Rudra::get("DSN")->prepare("
            CREATE TABLE {$table} ( 
            `id` INT NOT NULL AUTO_INCREMENT ,
            `name` VARCHAR(255) NOT NULL , 
            `email` VARCHAR(255) NOT NULL , 
            `password` VARCHAR(255) NOT NULL ,
            `role` VARCHAR(255) NOT NULL ,
            `status` VARCHAR(255) NOT NULL ,
            `created_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ,
            `updated_at` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ,
             PRIMARY KEY (`id`)) ENGINE = InnoDB
         ");

        $query->execute();
    }
}