/** * @fileoverview Migration v4 — Add security scan columns to skills table * @module @skillsmith/core/db/migrations/v4-security-columns * @see SMI-825 */ export declare const MIGRATION_V4_SQL = "\n-- Add security columns to skills table\nALTER TABLE skills ADD COLUMN risk_score INTEGER CHECK(risk_score IS NULL OR (risk_score >= 0 AND risk_score <= 100));\nALTER TABLE skills ADD COLUMN security_findings_count INTEGER DEFAULT 0;\nALTER TABLE skills ADD COLUMN security_scanned_at TEXT;\nALTER TABLE skills ADD COLUMN security_passed INTEGER;\n\n-- Index for efficient security queries\nCREATE INDEX IF NOT EXISTS idx_skills_risk_score ON skills(risk_score);\nCREATE INDEX IF NOT EXISTS idx_skills_security_passed ON skills(security_passed);\n"; //# sourceMappingURL=v4-security-columns.d.ts.map