005_release_assets.sql · rin/polar

005_release_assets.sql · 14 lines · 667 B

1	-- Uploaded release assets (binaries, archives, checksums).
2	CREATE TABLE IF NOT EXISTS release_assets (
3	id INTEGER PRIMARY KEY AUTOINCREMENT,
4	release_id INTEGER NOT NULL REFERENCES releases(id) ON DELETE CASCADE,
5	uploader_id INTEGER NOT NULL REFERENCES users(id) ON DELETE CASCADE,
6	filename TEXT NOT NULL,
7	stored_name TEXT NOT NULL,
8	size INTEGER NOT NULL DEFAULT 0,
9	content_type TEXT NOT NULL DEFAULT 'application/octet-stream',
10	download_count INTEGER NOT NULL DEFAULT 0,
11	created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP
12	);
13
14	CREATE INDEX IF NOT EXISTS idx_release_assets_release ON release_assets(release_id, created_at ASC);