Cloudflare Storage: Link too long to be stored to resource.reference

[chez14]

Describe the bug

When setting up Memo to use Cloudflare R2, upon saving, it shows the following error on the screen:

Here's the console log:

memos  | 2025/01/27 14:54:55 ERROR server error method=/memos.api.v1.ResourceService/CreateResource error="rpc error: code = Internal desc = failed to create resource: Error 1406 (22001): Data too long for column 'reference' at row 1"

After digging around, I think i know the issue: the reference column in resource name is not sufficient to store signed URL from Clouadlare R2. The usual Cloudflare R2 URL uses the https://[bucket].[account-id].r2.cloudflarestorage.com. Here's R2 sample link:

https://bucket-name.aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa.r2.cloudflarestorage.com/assets/aaaaaaaaaaaaaaaaaaa-aaaa-aaaa-aaaa-aaaaaaaaaaaa.jpg?X-Amz-Algorithm=AWS4-HMAC-SHA256&X-Amz-Credential=aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa%2Faaaaaaaa%2Fauto%2Fs3%2Faws4_request&X-Amz-Date=20250123T110829Z&X-Amz-Expires=432000&X-Amz-SignedHeaders=host&x-id=GetObject&X-Amz-Signature=aaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaaa

It has 427 charactes while the column were set only to varchar(256). I think we can just create a new migration to update the column to be TEXT for mysql. Waht do you think? I kinda want to send a PR for this.

Steps to reproduce

1. Install & Setup memo with the following info:

• Install using Docker Compose
• Use MariaDB.

2. Use Cloudflare R2 for storage option, as described in the following documentations:
   https://www.usememos.com/docs/advanced-settings/cloudflare-r2
3. Save the configurations
4. Create a new Memo, and upload an image. The screen immediately shows error.

The version of Memos you're using

v0.23.0

Screenshots or additional context

No response