20220625101544_add_user_table.php 895 B

12345678910111213141516171819202122
  1. <?php
  2. declare(strict_types=1);
  3. use Phinx\Migration\AbstractMigration;
  4. final class AddUserTable extends AbstractMigration {
  5. public function change(): void {
  6. $this->table("user", ["signed" => false, "collation" => "utf8mb4_general_ci"])
  7. ->addColumn("title", "string", ["limit" => 3, "null" => true])
  8. ->addColumn("first_name", "string", ["limit" => 100, "null" => true])
  9. ->addColumn("last_name", "string", ["limit" => 100, "null" => true])
  10. ->addColumn("email", "string")
  11. ->addColumn("password", "string")
  12. ->addColumn("admin", "boolean", ["signed" => false, "default" => 0])
  13. ->addColumn("csrf_token", "string", ["null" => true])
  14. ->addColumn("dts_last_seen", "datetime", ["null" => true])
  15. ->addColumn("dts_created", "datetime")
  16. ->addColumn("dts_updated", "datetime", ["null" => true])
  17. ->addColumn("dts_deleted", "datetime", ["null" => true])
  18. ->create();
  19. }
  20. }