/**
 * @fileoverview Migration v3 — Registry sync tables for local-to-live synchronization
 * @module @skillsmith/core/db/migrations/v3-sync-tables
 */
export declare const MIGRATION_V3_SQL = "\n-- Sync configuration table (singleton pattern)\nCREATE TABLE IF NOT EXISTS sync_config (\n  id TEXT PRIMARY KEY DEFAULT 'default',\n  enabled INTEGER NOT NULL DEFAULT 1,\n  frequency TEXT NOT NULL DEFAULT 'daily' CHECK(frequency IN ('daily', 'weekly')),\n  interval_ms INTEGER NOT NULL DEFAULT 86400000,\n  last_sync_at TEXT,\n  next_sync_at TEXT,\n  last_sync_count INTEGER DEFAULT 0,\n  last_sync_error TEXT,\n  created_at TEXT NOT NULL DEFAULT (datetime('now')),\n  updated_at TEXT NOT NULL DEFAULT (datetime('now'))\n);\n\n-- Initialize default config if empty\nINSERT OR IGNORE INTO sync_config (id) VALUES ('default');\n\n-- Sync history table for tracking sync runs\nCREATE TABLE IF NOT EXISTS sync_history (\n  id TEXT PRIMARY KEY,\n  started_at TEXT NOT NULL,\n  completed_at TEXT,\n  status TEXT NOT NULL DEFAULT 'running' CHECK(status IN ('running', 'success', 'failed', 'partial')),\n  skills_added INTEGER DEFAULT 0,\n  skills_updated INTEGER DEFAULT 0,\n  skills_unchanged INTEGER DEFAULT 0,\n  error_message TEXT,\n  duration_ms INTEGER,\n  created_at TEXT NOT NULL DEFAULT (datetime('now'))\n);\n\n-- Index for efficient history queries\nCREATE INDEX IF NOT EXISTS idx_sync_history_started ON sync_history(started_at DESC);\nCREATE INDEX IF NOT EXISTS idx_sync_history_status ON sync_history(status);\n";
//# sourceMappingURL=v3-sync-tables.d.ts.map