nyazoom/migrations/20241115182043_init.up.sql

9 lines
313 B
MySQL
Raw Permalink Normal View History

2024-11-15 18:54:01 +00:00
-- Add up migration script here
CREATE TABLE IF NOT EXISTS records (
id INTEGER NOT NULL PRIMARY KEY,
2024-11-16 13:13:28 +00:00
cache_name TEXT NOT NULL UNIQUE,
uploaded TEXT NOT NULL DEFAULT (datetime('now')),
2024-11-15 18:54:01 +00:00
downloads INTEGER NOT NULL DEFAULT 0,
max_downloads INTEGER NOT NULL
) STRICT;