20221109224846_add_ticket_comment_table.php 796 B

12345678910111213141516171819
  1. <?php
  2. declare(strict_types=1);
  3. use Phinx\Migration\AbstractMigration;
  4. final class AddTicketCommentTable extends AbstractMigration {
  5. public function change(): void {
  6. $this->table("ticket_comment", ["signed" => false, "collation" => "utf8mb4_general_ci"])
  7. ->addColumn("ticket_id", "integer", ["signed" => false])
  8. ->addColumn("user_id", "integer", ["signed" => false])
  9. ->addColumn("content", "text")
  10. ->addColumn("internal", "boolean", ["signed" => false, "default" => 0])
  11. ->addColumn("dts_created", "datetime")
  12. ->addColumn("dts_deleted", "datetime", ["null" => true])
  13. ->addForeignKey("ticket_id", "ticket", "id", ["update" => "CASCADE", "delete" => "CASCADE"])
  14. ->addForeignKey("user_id", "user", "id", ["update" => "CASCADE", "delete" => "CASCADE"])
  15. ->create();
  16. }
  17. }