-- printServer SQLite 建表脚本 -- 数据库文件: printserver.db -- 海康 NVR 下载记录表(存储配额管理) CREATE TABLE IF NOT EXISTS hik_downloads ( id INTEGER PRIMARY KEY AUTOINCREMENT, task_id TEXT NOT NULL UNIQUE, ip TEXT DEFAULT '', channel INTEGER DEFAULT 0, output_path TEXT NOT NULL, file_size INTEGER DEFAULT 0, duration REAL DEFAULT 0, resolution TEXT DEFAULT '', status TEXT DEFAULT 'done', deleted INTEGER DEFAULT 0, created_at TEXT DEFAULT (datetime('now')) ); CREATE INDEX IF NOT EXISTS idx_hik_downloads_deleted ON hik_downloads(deleted); CREATE INDEX IF NOT EXISTS idx_hik_downloads_status ON hik_downloads(status); -- 海康 NVR 任务池表(调度、重试、超时管理) CREATE TABLE IF NOT EXISTS hik_tasks ( id INTEGER PRIMARY KEY AUTOINCREMENT, task_id TEXT NOT NULL UNIQUE, unique_code TEXT DEFAULT '', task_params TEXT, status TEXT DEFAULT 'pending', worker_id INTEGER, retry INTEGER DEFAULT 0, weight INTEGER DEFAULT 0, notice INTEGER DEFAULT 0, timeout INTEGER DEFAULT 0, error_message TEXT, result TEXT, tmp_file_path TEXT DEFAULT '', pushed INTEGER DEFAULT 0, push_retry INTEGER DEFAULT 0, push_next_retry_at TEXT DEFAULT '', start_time TEXT, end_time TEXT, created_at TEXT DEFAULT (datetime('now')), fail_logged INTEGER DEFAULT 0 ); CREATE INDEX IF NOT EXISTS idx_hik_tasks_unique_code ON hik_tasks(unique_code); CREATE INDEX IF NOT EXISTS idx_hik_tasks_status ON hik_tasks(status); CREATE INDEX IF NOT EXISTS idx_hik_tasks_worker ON hik_tasks(worker_id); CREATE INDEX IF NOT EXISTS idx_hik_tasks_weight ON hik_tasks(status, weight); -- 任务失败记录表(每次重试耗尽记一条;失败记录 > 10 条的任务不再被重扫) CREATE TABLE IF NOT EXISTS hik_task_fail_log ( id INTEGER PRIMARY KEY AUTOINCREMENT, task_id TEXT NOT NULL, created_at TEXT DEFAULT (datetime('now')) ); CREATE INDEX IF NOT EXISTS idx_hik_fail_log_task ON hik_task_fail_log(task_id);