table("ticket_comment", ["signed" => false, "collation" => "utf8mb4_general_ci"]) ->addColumn("ticket_id", "integer", ["signed" => false]) ->addColumn("user_id", "integer", ["signed" => false]) ->addColumn("content", "text") ->addColumn("internal", "boolean", ["signed" => false, "default" => 0]) ->addColumn("dts_created", "datetime") ->addColumn("dts_deleted", "datetime", ["null" => true]) ->addForeignKey("ticket_id", "ticket", "id", ["update" => "CASCADE", "delete" => "CASCADE"]) ->addForeignKey("user_id", "user", "id", ["update" => "CASCADE", "delete" => "CASCADE"]) ->create(); } }