Files
fm_be/migrations/20260421_file_thumbnail_metadata.sql
2026-07-16 22:16:45 +07:00

9 lines
558 B
SQL

ALTER TABLE file_files
ADD COLUMN thumbnail_mime_type VARCHAR(255) NULL AFTER etag,
ADD COLUMN thumbnail_size_bytes BIGINT UNSIGNED NULL AFTER thumbnail_mime_type,
ADD COLUMN thumbnail_bucket VARCHAR(128) NULL AFTER thumbnail_size_bytes,
ADD COLUMN thumbnail_object_key VARCHAR(512) NULL AFTER thumbnail_bucket,
ADD COLUMN thumbnail_object_version VARCHAR(128) NULL AFTER thumbnail_object_key,
ADD COLUMN thumbnail_etag VARCHAR(128) NULL AFTER thumbnail_object_version,
ADD UNIQUE KEY uq_file_files_thumbnail_object_key (thumbnail_object_key);