| 12345678910111213141516 |
- <?php
- declare(strict_types=1);
- use Phinx\Migration\AbstractMigration;
- final class AddTicketCommentAttachmentTable extends AbstractMigration {
- public function change(): void {
- $this->table("ticket_comment_attachment", ["signed" => false, "collation" => "utf8mb4_general_ci"])
- ->addColumn("ticket_comment_id", "integer", ["signed" => false])
- ->addColumn("mime_type", "string")
- ->addColumn("file_name", "string")
- ->addColumn("file_size", "integer", ["signed" => false])
- ->addForeignKey("ticket_comment_id", "ticket_comment", "id", ["update" => "CASCADE", "delete" => "RESTRICT"])
- ->create();
- }
- }
|