/** * @fileoverview Migration v10 — skill_dependencies table * @module @skillsmith/core/db/migrations/v10-dependencies * @see Architecture: ../research/skill-dependency-intelligence-architecture.md §4 * * Stores declared and inferred dependency records for skills. * Three signal sources: author declaration, static mcp__* analysis, * and co-install behavioral inference. * * Design notes: * - No FK on skill_id — soft reference, dep records survive skill removal * (matches SkillVersionRepository pattern) * - dep_source distinguishes declared vs inferred for confidence filtering * - Unique index on (skill_id, dep_type, dep_target, dep_source) prevents * duplicate rows from repeated inference runs */ export declare const MIGRATION_V10_SQL = "\nCREATE TABLE IF NOT EXISTS skill_dependencies (\n id INTEGER PRIMARY KEY AUTOINCREMENT,\n skill_id TEXT NOT NULL,\n dep_type TEXT NOT NULL CHECK (dep_type IN (\n 'skill_hard', 'skill_soft', 'skill_peer',\n 'mcp_server',\n 'model_minimum', 'model_capability',\n 'env_tool', 'env_os', 'env_node',\n 'cli_version',\n 'conflict'\n )),\n dep_target TEXT NOT NULL,\n dep_version TEXT,\n dep_source TEXT NOT NULL CHECK (dep_source IN (\n 'declared',\n 'inferred_static',\n 'inferred_coinstall'\n )),\n confidence REAL CHECK (confidence IS NULL OR (confidence >= 0.0 AND confidence <= 1.0)),\n metadata TEXT,\n created_at TEXT NOT NULL DEFAULT (datetime('now')),\n updated_at TEXT NOT NULL DEFAULT (datetime('now'))\n);\n\nCREATE INDEX IF NOT EXISTS idx_skill_deps_skill ON skill_dependencies(skill_id);\nCREATE INDEX IF NOT EXISTS idx_skill_deps_target ON skill_dependencies(dep_target);\nCREATE INDEX IF NOT EXISTS idx_skill_deps_type ON skill_dependencies(dep_type);\nCREATE INDEX IF NOT EXISTS idx_skill_deps_source ON skill_dependencies(dep_source);\n\nCREATE UNIQUE INDEX IF NOT EXISTS idx_skill_deps_unique\n ON skill_dependencies(skill_id, dep_type, dep_target, dep_source);\n"; //# sourceMappingURL=v10-dependencies.d.ts.map