max / goingson

500 B · 15 lines History Blame Raw

1	-- Automated backup settings
2	CREATE TABLE IF NOT EXISTS backup_settings (
3	id TEXT PRIMARY KEY,
4	user_id TEXT NOT NULL REFERENCES users(id),
5	auto_backup_enabled INTEGER NOT NULL DEFAULT 1,
6	backup_frequency_hours INTEGER NOT NULL DEFAULT 24,
7	max_backups_to_keep INTEGER NOT NULL DEFAULT 7,
8	last_backup_at TEXT,
9	created_at TEXT NOT NULL,
10	updated_at TEXT NOT NULL,
11	UNIQUE(user_id)
12	);
13
14	CREATE INDEX IF NOT EXISTS idx_backup_settings_user_id ON backup_settings(user_id);
15