20221109224205_add_ticket_table.php 1.4 KB

1234567891011121314151617181920212223242526272829303132
  1. <?php
  2. declare(strict_types=1);
  3. use Phinx\Db\Adapter\MysqlAdapter;
  4. use Phinx\Migration\AbstractMigration;
  5. final class AddTicketTable extends AbstractMigration {
  6. public function change(): void {
  7. $this->table("ticket", ["signed" => false, "collation" => "utf8mb4_general_ci"])
  8. ->addColumn("location_id", "integer", ["signed" => false])
  9. ->addColumn("creator_user_id", "integer", ["signed" => false])
  10. ->addColumn("assigned_user_id", "integer", ["signed" => false, "null" => true])
  11. ->addColumn("subject", "string")
  12. ->addColumn("contact_name", "string", ["null" => true])
  13. ->addColumn("status", "integer", ["signed" => false, "limit" => MysqlAdapter::INT_TINY, "default" => "0"])
  14. ->addColumn("priority", "integer", ["signed" => false, "limit" => MysqlAdapter::INT_TINY, "default" => "2"])
  15. ->addColumn("rating", "integer", ["signed" => false, "limit" => MysqlAdapter::INT_TINY, "null" => true])
  16. ->addColumn("dts_due", "datetime", ["null" => true])
  17. ->addColumn("dts_created", "datetime")
  18. ->addColumn("dts_updated", "datetime", ["null" => true])
  19. ->addColumn("dts_deleted", "datetime", ["null" => true])
  20. ->addForeignKey("location_id", "location", "id", ["update" => "CASCADE", "delete" => "CASCADE"])
  21. ->addForeignKey("creator_user_id", "user", "id", ["update" => "CASCADE", "delete" => "CASCADE"])
  22. ->addForeignKey("assigned_user_id", "user", "id", ["update" => "CASCADE", "delete" => "CASCADE"])
  23. ->create();
  24. }
  25. }