up.sql 316 Bytes
CREATE TABLE "images" (
	id INTEGER PRIMARY KEY AUTOINCREMENT 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
);