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
);