/** * @fileoverview Migration v12 -- Risk score history for trend detection * @see SMI-3864 * * Stores point-in-time risk score snapshots after each security scan. * No FOREIGN KEY on skill_id — direct-install skills (GitHub URLs) may not * exist in the local skills table (Review #6). */ export declare const MIGRATION_V12_SQL = "\nCREATE TABLE IF NOT EXISTS risk_score_history (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n skill_id TEXT NOT NULL,\n risk_score INTEGER NOT NULL CHECK(risk_score >= 0 AND risk_score <= 100),\n findings_count INTEGER NOT NULL DEFAULT 0,\n content_hash TEXT,\n scanned_at TEXT NOT NULL DEFAULT (datetime('now')),\n source TEXT NOT NULL DEFAULT 'install'\n);\n\nCREATE INDEX IF NOT EXISTS idx_risk_score_history_skill_id\n ON risk_score_history(skill_id);\nCREATE INDEX IF NOT EXISTS idx_risk_score_history_scanned_at\n ON risk_score_history(skill_id, scanned_at);\n"; //# sourceMappingURL=v12-risk-score-history.d.ts.map