| 12345678910111213141516171819202122 |
- <?php
- declare(strict_types=1);
- use Phinx\Migration\AbstractMigration;
- final class AddUserTable extends AbstractMigration {
- public function change(): void {
- $this->table("user", ["signed" => false, "collation" => "utf8mb4_general_ci"])
- ->addColumn("title", "string", ["limit" => 3, "null" => true])
- ->addColumn("first_name", "string", ["limit" => 100, "null" => true])
- ->addColumn("last_name", "string", ["limit" => 100, "null" => true])
- ->addColumn("email", "string")
- ->addColumn("password", "string")
- ->addColumn("admin", "boolean", ["signed" => false, "default" => 0])
- ->addColumn("csrf_token", "string", ["null" => true])
- ->addColumn("dts_last_seen", "datetime", ["null" => true])
- ->addColumn("dts_created", "datetime")
- ->addColumn("dts_updated", "datetime", ["null" => true])
- ->addColumn("dts_deleted", "datetime", ["null" => true])
- ->create();
- }
- }
|