22 lines
718 B
TypeScript
22 lines
718 B
TypeScript
import { getDb } from '../db'
|
|
|
|
export function ensureBackupSchema(): void {
|
|
getDb().exec(`
|
|
CREATE TABLE IF NOT EXISTS backup_jobs (
|
|
id TEXT PRIMARY KEY,
|
|
type TEXT NOT NULL CHECK(type IN ('full_export', 'full_restore', 'backend_sync')),
|
|
status TEXT NOT NULL CHECK(status IN ('pending', 'running', 'done', 'failed')),
|
|
progress INTEGER NOT NULL DEFAULT 0,
|
|
total INTEGER NOT NULL DEFAULT 0,
|
|
message TEXT NOT NULL DEFAULT '',
|
|
payload_json TEXT NOT NULL DEFAULT '{}',
|
|
output_path TEXT,
|
|
error TEXT,
|
|
created_at TEXT NOT NULL,
|
|
finished_at TEXT
|
|
);
|
|
CREATE INDEX IF NOT EXISTS idx_backup_jobs_created_at
|
|
ON backup_jobs(created_at DESC);
|
|
`)
|
|
}
|