Files
blog-server/internal/db/migrations/000013_add_file_image_metadata.up.sql
2026-08-19 22:05:49 +08:00

10 lines
289 B
SQL

CREATE TABLE file_image_metadata
(
id INTEGER PRIMARY KEY GENERATED ALWAYS AS IDENTITY,
file_id INTEGER UNIQUE NOT NULL,
width INTEGER NOT NULL,
height INTEGER NOT NULL,
format TEXT NOT NULL,
created_at TIMESTAMPTZ NOT NULL DEFAULT NOW()
);