up.sql
315 Bytes
CREATE TABLE images (
id INTEGER PRIMARY KEY AUTO_INCREMENT NOT NULL,
-- identical uuid means identical file.
upload_uuid BLOB(16) UNIQUE,
uuid BLOB(16) UNIQUE,
size INTEGER NOT NULL,
dim_x INTEGER,
dim_y INTEGER,
mime_type VARCHAR(256) NOT NULL,
date_created TEXT NOT NULL,
date_updated TEXT NOT NULL
);