[{"_1":2,"_185":-5,"_186":-5},"loaderData",{"_3":4,"_93":94},"root",{"_5":6,"_36":37,"_66":67},"ctx",{"_7":8,"_23":-5,"_24":25,"_26":27,"_28":20,"_29":20,"_30":20,"_31":-5,"_32":33,"_34":20,"_35":20},"auth",{"_9":-5,"_10":-5,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":20,"_21":22},"sessionClaims","sessionId","sessionStatus","userId","actor","orgId","orgRole","orgSlug","orgPermissions","factorVerificationAge","isAuthenticated",false,"tokenType","session_token","user","preferencesKeybindings","default","preferencesTheme","light","preferencesFixers","preferencesCopilot","preferencesSelectionAi","preferencesChatPanelState","notificationCount",0,"flagDenols","isTeamOrgMember","ENV",{"_38":39,"_40":41,"_42":43,"_44":45,"_46":47,"_48":49,"_50":51,"_52":53,"_54":55,"_56":57,"_58":59,"_60":61,"_62":63,"_64":65},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","VAL_RUNTIME_NAME","prod","RENDER_GIT_COMMIT","e9e636d7b466d0cb012ac9b89f74068c1d9c5525","RENDER_GIT_BRANCH","main","CLERK_PUBLISHABLE_KEY","pk_live_Y2xlcmsudmFsLnRvd24k","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","VANITY_WEB_API_TEMPLATE","https://{label}.val.run/","DENOLS_URL","https://lsp.val.town","NODE_ENV","production","API_URL","https://api.val.town","clerkState",{"_68":69},"__internal_clerk_state",{"_70":71,"_72":47,"_73":74,"_75":74,"_76":20,"_77":74,"_78":74,"_79":74,"_80":74,"_81":82,"_91":20,"_92":20},"__clerk_ssr_state",{"_21":22,"_9":-5,"_10":-5,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5,"_18":-5,"_19":20},"__publishableKey","__proxyUrl","","__domain","__isSatellite","__signInUrl","__signUpUrl","__afterSignInUrl","__afterSignUpUrl","__clerk_debug",{"_83":20,"_19":20,"_84":74,"_85":86,"_87":74,"_88":47,"_89":20,"_90":74},"isSignedIn","proxyUrl","reason","session-token-and-uat-missing","message","publishableKey","isSatellite","domain","__telemetryDisabled","__telemetryDebug","routes/embed.x.$handle.$name.$",{"_95":96,"_97":98,"_99":100,"_101":102,"_161":162,"_182":183,"_184":-5},"handle","defi_failure","name","claude-plugins-registry","path","database/db.ts","project",{"_103":104,"_97":98,"_105":106,"_107":-5,"_108":20,"_109":110,"_111":112,"_113":-5,"_12":114,"_115":116,"_117":20,"_118":-5,"_119":-5,"_120":33,"_14":121,"_122":123,"_124":125,"_126":127,"_128":127,"_129":130,"_131":130,"_132":130,"_133":127,"_134":127,"_23":135,"_138":139,"_143":144,"_160":20},"id","d8d14fd6-12d4-11f1-a18f-42dde27851f2","createdAt",["D",1772084080460],"deletedAt","legacyEnvVars","privacy","public","description","A lightweight registry for Agent Skills and Plugins","imageUrl","019c986f-7c11-7508-87c4-72ab9fa4fa8c","pinnedFileId","019c9871-2ff1-70a8-ad62-bf0347d83c94","pinPreview","pinMigrated","screenshotVersion","likeCount","019c986f-7c11-7508-87c4-75699825b54a","tursoName","d8d14fd612d411f1a18f42dde27851f2","tursoHostname","d8d14fd612d411f1a18f42dde27851f2-val-town.aws-us-east-2.turso.io","userPerm","r","valPerm","blobPerm","rw","emailPerm","sqlitePerm","projectPerm","telemetryPerm",{"_95":96,"_136":137},"profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvb2F1dGhfZ2l0aHViL2ltZ18zQUM1d243TThuU2N5UWQ2VUhPRXlHYzY1ejgifQ","org",{"_95":96,"_140":137,"_12":114,"_141":142},"avatar","tier","free","branch",{"_145":146,"_97":45,"_103":147,"_148":104,"_149":150,"_151":152,"_153":110,"_154":155,"_156":157,"_158":98,"_159":96},"version",1,"d8db1b7e-12d4-11f1-a18f-42dde27851f2","projectId","forkedBranchId","4482de86-a753-11f0-8f88-0224a6c84d84","forkedBranchVersion",665,"forkedProjectPrivacy","forkedProjectId","44825312-a753-11f0-8f88-0224a6c84d84","forkedProjectOrgId","f427167a-3263-4778-81d8-f79626323ff5","projectName","userHandle","isOwned","file",{"_103":163,"_97":164,"_165":166,"_167":168,"_169":147,"_170":146,"_171":172,"_105":173,"_145":33,"_174":175,"_176":177,"_178":20,"_179":-5,"_99":180},"d8ea3910-12d4-11f1-a18f-42dde27851f2","db.ts","fileId","019c9871-2ff1-70a8-ad62-7c644fd11849","parentId","019c9871-2ff1-70a8-ad62-8895219ab8ca","branchId","branchVersion","latest",true,["D",1772084080460],"fileType","script","content","/**\n * Database connection and utilities\n */\nimport { sqlite } from \"../clients/sqlite.ts\";\nimport { sql } from \"npm:drizzle-orm@0.44.2\";\nimport { drizzle } from \"npm:drizzle-orm@0.44.2/libsql\";\nimport * as schema from \"./schema.ts\";\n\n// Initialize Drizzle with Val Town SQLite (without schema to avoid circular refs)\nexport const db = drizzle(sqlite as any);\n\nasync function runCreateSearchBuckets() {\n console.log(\"Running create search buckets\");\n try {\n // Check if tables exist by attempting to query them\n const tableCheck = await db\n .select({ count: sql`count(*)` })\n .from(schema.searchBuckets)\n .limit(1)\n .catch(() => null);\n\n if (tableCheck === null) {\n console.log(\"Creating table for Search Buckets...\");\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS search_buckets (\n id TEXT PRIMARY KEY,\n name TEXT NOT NULL,\n buckets TEXT,\n created_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP,\n updated_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP\n )\n `);\n console.log(\"Search buckets created successfully\");\n }\n } catch (e) {\n console.error(\"Table creation failed\");\n throw e;\n }\n}\n\n/**\n * Run database migrations to create tables and indexes\n */\nasync function runCreateTablesAndIndexes() {\n console.log(\"Running create tables and indexes...\");\n\n try {\n // Check if tables exist by attempting to query them\n const tableCheck = await db\n .select({ count: sql`count(*)` })\n .from(schema.plugins)\n .limit(1)\n .catch(() => null);\n\n if (tableCheck === null) {\n // Tables don't exist, create them using schema-driven SQL\n console.log(\"Creating database schema...\");\n\n // Create tables using Drizzle schema definitions\n // This ensures schema and database stay in sync\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS plugins (\n id TEXT PRIMARY KEY,\n name TEXT NOT NULL,\n namespace TEXT NOT NULL,\n git_url TEXT NOT NULL,\n description TEXT,\n keywords TEXT,\n category TEXT,\n version TEXT NOT NULL DEFAULT '1.0.0',\n author TEXT NOT NULL,\n metadata TEXT,\n stars INTEGER NOT NULL DEFAULT 0,\n verified INTEGER NOT NULL DEFAULT 0,\n downloads INTEGER NOT NULL DEFAULT 0,\n first_commit_at TEXT,\n content_hash TEXT,\n created_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP,\n updated_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS plugin_stats (\n plugin_id TEXT PRIMARY KEY,\n downloads_total INTEGER NOT NULL DEFAULT 0,\n downloads_week INTEGER NOT NULL DEFAULT 0,\n downloads_month INTEGER NOT NULL DEFAULT 0,\n last_downloaded_at TEXT,\n FOREIGN KEY (plugin_id) REFERENCES plugins(id) ON DELETE CASCADE\n )\n `);\n\n // Create indexes for query performance\n await sqlite.execute(\n `CREATE INDEX IF NOT EXISTS idx_plugins_namespace ON plugins(namespace)`,\n );\n await sqlite.execute(\n `CREATE INDEX IF NOT EXISTS idx_plugins_name ON plugins(name)`,\n );\n await sqlite.execute(\n `CREATE INDEX IF NOT EXISTS idx_plugins_category ON plugins(category)`,\n );\n await sqlite.execute(\n `CREATE INDEX IF NOT EXISTS idx_plugins_content_hash ON plugins(content_hash)`,\n );\n await sqlite.execute(\n `CREATE UNIQUE INDEX IF NOT EXISTS idx_plugins_namespace_name ON plugins(namespace, name)`,\n );\n\n console.log(\"Schema created successfully\");\n }\n\n console.log(\"Creating database completed successfully\");\n } catch (error) {\n console.error(\"Migration failed:\", error);\n throw error;\n }\n}\n\nasync function runAddSkillsMigration(): Promise {\n console.log(\"Running migration: add `skills` column to `plugins`…\");\n const pragma = await sqlite.execute(`PRAGMA table_info(plugins);`);\n const hasSkills = Array.isArray(pragma?.rows)\n ? pragma.rows.some((r: any) => r.name === \"skills\")\n : false;\n\n if (hasSkills) {\n console.log(\"Column `skills` already exists. Skipping ALTER TABLE.\");\n } else {\n console.log(\"Adding `skills` column (TEXT, nullable) to `plugins`…\");\n await sqlite.execute(`ALTER TABLE plugins ADD COLUMN skills TEXT;`);\n console.log(\"Column `skills` added.\");\n }\n\n await sqlite.execute(\n `CREATE INDEX IF NOT EXISTS idx_plugins_skills ON plugins(skills);`,\n );\n\n console.log(\"Migration completed: add `skills` column.\");\n}\n\nasync function runAddSkillsTableMigration(): Promise {\n console.log(\"Running migration: create skills and skill_stats tables...\");\n\n try {\n // Check if skills table exists\n const skillsTableCheck = await sqlite\n .execute(\n `SELECT name FROM sqlite_master WHERE type='table' AND name='skills';`,\n )\n .catch(() => null);\n\n if (!skillsTableCheck || skillsTableCheck.rows.length === 0) {\n console.log(\"Creating skills table...\");\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS skills (\n id TEXT PRIMARY KEY,\n name TEXT NOT NULL,\n namespace TEXT NOT NULL,\n source_url TEXT NOT NULL,\n source_type TEXT NOT NULL DEFAULT 'github',\n description TEXT NOT NULL,\n version TEXT,\n dependencies TEXT,\n author TEXT NOT NULL,\n stars INTEGER NOT NULL DEFAULT 0,\n installs INTEGER NOT NULL DEFAULT 0,\n verified INTEGER NOT NULL DEFAULT 0,\n metadata TEXT,\n first_commit_at TEXT,\n content_hash TEXT,\n created_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP,\n updated_at TEXT NOT NULL DEFAULT CURRENT_TIMESTAMP\n )\n `);\n\n await sqlite.execute(`\n CREATE TABLE IF NOT EXISTS skill_stats (\n skill_id TEXT PRIMARY KEY,\n installs_total INTEGER NOT NULL DEFAULT 0,\n installs_week INTEGER NOT NULL DEFAULT 0,\n installs_month INTEGER NOT NULL DEFAULT 0,\n last_installed_at TEXT,\n FOREIGN KEY (skill_id) REFERENCES skills(id) ON DELETE CASCADE\n )\n `);\n\n // Create indexes\n await sqlite.execute(\n `CREATE UNIQUE INDEX IF NOT EXISTS idx_skills_namespace ON skills(namespace)`,\n );\n await sqlite.execute(\n `CREATE INDEX IF NOT EXISTS idx_skills_name ON skills(name)`,\n );\n await sqlite.execute(\n `CREATE INDEX IF NOT EXISTS idx_skills_author ON skills(author)`,\n );\n await sqlite.execute(\n `CREATE INDEX IF NOT EXISTS idx_skills_content_hash ON skills(content_hash)`,\n );\n\n console.log(\"Skills tables created successfully\");\n } else {\n console.log(\"Skills table already exists. Skipping.\");\n }\n } catch (error) {\n console.error(\"Skills table migration failed:\", error);\n throw error;\n }\n\n console.log(\"Migration completed: skills tables\");\n}\n\nasync function runAddDeletedColumnMigration(): Promise {\n console.log(\"Running migration: add `deleted` and `deleted_at` to skills...\");\n try {\n const skillsTableCheck = await sqlite\n .execute(\n `SELECT name FROM sqlite_master WHERE type='table' AND name='skills';`,\n )\n .catch(() => null);\n\n if (!skillsTableCheck) {\n throw new Error(\"Run runAddSkillsTableMigration before this migration\");\n }\n\n const pragma = await sqlite.execute(`PRAGMA table_info(skills);`);\n const cols = new Set(\n (pragma?.rows ?? []).map((r: any) =>\n (r?.name ?? r?.[1] ?? \"\").toLowerCase()\n ),\n );\n if (!cols.has(\"deleted\")) {\n console.log(\"Adding `deleted` column to skills...\");\n await sqlite.execute(\n `ALTER TABLE skills ADD COLUMN deleted INTEGER NOT NULL DEFAULT 0;`,\n );\n } else {\n console.log(\"`deleted` column already exists. Skipping.\");\n }\n } catch (e) {\n console.error(\"Skills table migration failed:\", e);\n throw e;\n }\n}\n\n/**\n * FTS5 Full-Text Search migration for skills table\n * \n * Uses CONTENTLESS FTS5 (no content='...' option) to avoid:\n * - Turso/libSQL auto-populate bug with external content tables\n * - Rowid sync issues between FTS and skills table\n * \n * Includes skill_id column for joining back to skills table.\n * Triggers are scoped to only fire on text column changes.\n */\nasync function runCreateSkillsFTS5Migration(): Promise {\n console.log(\"Running migration: create FTS5 virtual table for skills...\");\n\n try {\n // Check if FTS table already exists\n const ftsTableCheck = await sqlite\n .execute(\n `SELECT name FROM sqlite_master WHERE type='table' AND name='skills_fts';`,\n )\n .catch(() => null);\n\n if (ftsTableCheck && ftsTableCheck.rows.length > 0) {\n console.log(\"skills_fts table already exists. Skipping creation.\");\n return;\n }\n\n // Create CONTENTLESS FTS5 virtual table\n // No content='...' option - FTS stores its own copy of text\n // Includes skill_id for joining back to skills table\n console.log(\"Creating FTS5 virtual table (contentless)...\");\n await sqlite.execute(`\n CREATE VIRTUAL TABLE IF NOT EXISTS skills_fts USING fts5(\n skill_id,\n name,\n description,\n namespace,\n author,\n tokenize='porter unicode61 remove_diacritics 1'\n );\n `);\n\n // Populate FTS table from existing skills\n console.log(\"Populating FTS5 table with existing skills...\");\n await sqlite.execute(`\n INSERT INTO skills_fts(skill_id, name, description, namespace, author)\n SELECT id, name, description, namespace, author\n FROM skills\n WHERE deleted = 0 AND duplicate = 0;\n `);\n\n // Create triggers to keep FTS in sync\n console.log(\"Creating triggers for FTS5 sync...\");\n\n // After INSERT trigger\n await sqlite.execute(`\n CREATE TRIGGER IF NOT EXISTS skills_ai AFTER INSERT ON skills\n WHEN NEW.deleted = 0 AND NEW.duplicate = 0\n BEGIN\n INSERT INTO skills_fts(skill_id, name, description, namespace, author)\n VALUES (NEW.id, NEW.name, NEW.description, NEW.namespace, NEW.author);\n END;\n `);\n\n // After DELETE trigger - only for rows that were in FTS\n await sqlite.execute(`\n CREATE TRIGGER IF NOT EXISTS skills_ad AFTER DELETE ON skills\n WHEN OLD.deleted = 0 AND OLD.duplicate = 0\n BEGIN\n DELETE FROM skills_fts WHERE skill_id = OLD.id;\n END;\n `);\n\n // After UPDATE trigger - only fires when FTS-relevant columns change\n // This prevents install increments and other non-text updates from touching FTS\n await sqlite.execute(`\n CREATE TRIGGER IF NOT EXISTS skills_au AFTER UPDATE ON skills\n WHEN OLD.name != NEW.name \n OR OLD.description != NEW.description \n OR OLD.namespace != NEW.namespace \n OR OLD.author != NEW.author\n OR OLD.deleted != NEW.deleted\n OR OLD.duplicate != NEW.duplicate\n BEGIN\n DELETE FROM skills_fts WHERE skill_id = OLD.id;\n INSERT INTO skills_fts(skill_id, name, description, namespace, author)\n SELECT NEW.id, NEW.name, NEW.description, NEW.namespace, NEW.author\n WHERE NEW.deleted = 0 AND NEW.duplicate = 0;\n END;\n `);\n\n console.log(\"FTS5 migration completed successfully\");\n } catch (error) {\n console.error(\"FTS5 migration failed:\", error);\n throw error;\n }\n}\n\n/**\n * Rebuild FTS5 index from scratch\n * Use this if FTS gets out of sync with skills table\n */\nexport async function rebuildSkillsFTS(): Promise {\n console.log(\"Rebuilding skills_fts index...\");\n\n // Delete all existing FTS data\n await sqlite.execute(`DELETE FROM skills_fts;`);\n\n // Repopulate from skills table using skill_id\n await sqlite.execute(`\n INSERT INTO skills_fts(skill_id, name, description, namespace, author)\n SELECT id, name, description, namespace, author\n FROM skills\n WHERE deleted = 0 AND duplicate = 0;\n `);\n\n console.log(\"FTS5 index rebuilt successfully\");\n}\n\n\n/**\n * Add lastCheckedAt column to skills table for health check tracking\n */\nasync function runAddLastCheckedAtMigration(): Promise {\n console.log(\"Running migration: add `last_checked_at` to skills...\");\n try {\n const pragma = await sqlite.execute(`PRAGMA table_info(skills);`);\n const cols = new Set(\n (pragma?.rows ?? []).map((r: any) =>\n (r?.name ?? r?.[1] ?? \"\").toLowerCase()\n ),\n );\n\n if (!cols.has(\"last_checked_at\")) {\n console.log(\"Adding `last_checked_at` column to skills...\");\n await sqlite.execute(\n `ALTER TABLE skills ADD COLUMN last_checked_at TEXT;`,\n );\n\n // Create index for efficient querying by lastCheckedAt\n await sqlite.execute(\n `CREATE INDEX IF NOT EXISTS idx_skills_last_checked_at ON skills(last_checked_at);`,\n );\n\n console.log(\"`last_checked_at` column added successfully.\");\n } else {\n console.log(\"`last_checked_at` column already exists. Skipping.\");\n }\n } catch (e) {\n console.error(\"last_checked_at migration failed:\", e);\n throw e;\n }\n}\n\nasync function runAddpartialIndexesMigration() {\n console.log('Running migration: add partial indxes for query optimization')\n\n try {\n await sqlite.execute(`\n CREATE INDEX IF NOT EXISTS idx_skills_health_queue\n ON skills(last_checked_at)\n WHERE deleted = 0 AND duplicate = 0;\n `)\n console.log(\"Created idx_skills_health_queue\");\n\n // Partial index for active skills listing (ordered by installs, stars)\n // This eliminates full table scans for search/listing without query\n await sqlite.execute(`\n CREATE INDEX IF NOT EXISTS idx_skills_active\n ON skills(installs DESC, stars DESC, id)\n WHERE deleted = 0 AND duplicate = 0;\n `)\n\n console.log(\"Created idx_skills_active_order\");\n // Composite index for namespace lookups (already unique but ensure it exists)\n await sqlite.execute(\n `CREATE UNIQUE INDEX IF NOT EXISTS idx_skills_namespace ON skills(namespace);`\n );\n\n console.log(\"Partial indexes migration completed successfully\"); \n } catch (error) {\n console.error('Partial indexes migration failed', error)\n }\n}\n\nasync function runPluginsFTSAndCoveringIndexesMigration(): Promise {\n console.log(\"Running migration: plugins FTS5 and covering indexes...\");\n\n try {\n // 1. Create covering indexes (These were fine!)\n console.log(\"Creating covering indexes...\");\n await sqlite.execute(`\n CREATE INDEX IF NOT EXISTS idx_skills_active_covering \n ON skills(installs DESC, stars DESC)\n WHERE deleted = 0 AND duplicate = 0;\n `);\n\n await sqlite.execute(`\n CREATE INDEX IF NOT EXISTS idx_plugins_downloads_stars \n ON plugins(downloads DESC, stars DESC);\n `);\n\n // 2. Cleanup: Drop old table/triggers if they exist to ensure clean state\n await sqlite.execute(`DROP TABLE IF EXISTS plugins_fts;`);\n await sqlite.execute(`DROP TRIGGER IF EXISTS plugins_ai;`);\n await sqlite.execute(`DROP TRIGGER IF EXISTS plugins_ad;`);\n await sqlite.execute(`DROP TRIGGER IF EXISTS plugins_au;`);\n\n // 3. Create FTS5 virtual table (Contentless)\n // CHANGE: Removed 'plugin_id'. We will use the built-in 'rowid' instead.\n console.log(\"Creating plugins_fts FTS5 virtual table...\");\n await sqlite.execute(`\n CREATE VIRTUAL TABLE plugins_fts USING fts5(\n name,\n description,\n keywords,\n namespace,\n skills,\n tokenize='porter unicode61 remove_diacritics 1',\n content='' -- Contentless mode\n );\n `);\n\n // 4. Populate FTS using the Main Table's rowid\n // CHANGE: Mapping 'rowid' explicitly ensures O(1) lookups later\n console.log(\"Populating plugins_fts...\");\n await sqlite.execute(`\n INSERT INTO plugins_fts(rowid, name, description, keywords, namespace, skills)\n SELECT rowid, name, description, keywords, namespace, skills\n FROM plugins;\n `);\n\n // 5. Create Triggers (The Complex Part)\n console.log(\"Creating triggers for plugins_fts sync...\");\n\n // INSERT: Sync the rowid\n await sqlite.execute(`\n CREATE TRIGGER plugins_ai AFTER INSERT ON plugins\n BEGIN\n INSERT INTO plugins_fts(rowid, name, description, keywords, namespace, skills)\n VALUES (NEW.rowid, NEW.name, NEW.description, NEW.keywords, NEW.namespace, NEW.skills);\n END;\n `);\n\n // DELETE: Use 'delete' magic command (Required for Contentless tables)\n await sqlite.execute(`\n CREATE TRIGGER plugins_ad AFTER DELETE ON plugins\n BEGIN\n INSERT INTO plugins_fts(plugins_fts, rowid, name, description, keywords, namespace, skills)\n VALUES('delete', OLD.rowid, OLD.name, OLD.description, OLD.keywords, OLD.namespace, OLD.skills);\n END;\n `);\n\n // UPDATE: Delete old entries + Insert new ones\n await sqlite.execute(`\n CREATE TRIGGER plugins_au AFTER UPDATE ON plugins\n WHEN OLD.name != NEW.name \n OR OLD.description != NEW.description \n OR OLD.keywords != NEW.keywords\n OR OLD.namespace != NEW.namespace\n OR OLD.skills != NEW.skills\n BEGIN\n -- Step 1: Delete old (Magic Syntax)\n INSERT INTO plugins_fts(plugins_fts, rowid, name, description, keywords, namespace, skills)\n VALUES('delete', OLD.rowid, OLD.name, OLD.description, OLD.keywords, OLD.namespace, OLD.skills);\n \n -- Step 2: Insert new\n INSERT INTO plugins_fts(rowid, name, description, keywords, namespace, skills)\n VALUES (NEW.rowid, NEW.name, NEW.description, NEW.keywords, NEW.namespace, NEW.skills);\n END;\n `);\n\n console.log(\"Plugins FTS5 migration completed successfully\");\n } catch (error) {\n console.error(\"Plugins FTS5 migration failed:\", error);\n throw error;\n }\n}\n\nasync function fixSkillsFTSMigration(): Promise {\n console.log(\"Running migration: REPAIR skills_fts...\");\n\n try {\n // 1. Drop the broken setup (Triggers first!)\n await sqlite.execute(`DROP TRIGGER IF EXISTS skills_ai;`);\n await sqlite.execute(`DROP TRIGGER IF EXISTS skills_ad;`);\n await sqlite.execute(`DROP TRIGGER IF EXISTS skills_au;`);\n await sqlite.execute(`DROP TABLE IF EXISTS skills_fts;`);\n\n // 2. Recreate correctly (No skill_id column, use rowid, contentless)\n await sqlite.execute(`\n CREATE VIRTUAL TABLE skills_fts USING fts5(\n name,\n description,\n namespace,\n author,\n tokenize='porter unicode61 remove_diacritics 1',\n content='' \n );\n `);\n\n // 3. Repopulate (using rowid mapping)\n console.log(\"Repopulating skills_fts...\");\n await sqlite.execute(`\n INSERT INTO skills_fts(rowid, name, description, namespace, author)\n SELECT rowid, name, description, namespace, author\n FROM skills\n WHERE deleted = 0 AND duplicate = 0;\n `);\n\n // 4. Recreate Triggers (using rowid and 'delete' magic)\n \n // INSERT\n await sqlite.execute(`\n CREATE TRIGGER skills_ai AFTER INSERT ON skills\n WHEN NEW.deleted = 0 AND NEW.duplicate = 0\n BEGIN\n INSERT INTO skills_fts(rowid, name, description, namespace, author)\n VALUES (NEW.rowid, NEW.name, NEW.description, NEW.namespace, NEW.author);\n END;\n `);\n\n // DELETE\n await sqlite.execute(`\n CREATE TRIGGER skills_ad AFTER DELETE ON skills\n WHEN OLD.deleted = 0 AND OLD.duplicate = 0\n BEGIN\n INSERT INTO skills_fts(skills_fts, rowid, name, description, namespace, author)\n VALUES('delete', OLD.rowid, OLD.name, OLD.description, OLD.namespace, OLD.author);\n END;\n `);\n\n // UPDATE (The full logic)\n await sqlite.execute(`\n CREATE TRIGGER skills_au AFTER UPDATE ON skills\n WHEN OLD.name != NEW.name \n OR OLD.description != NEW.description \n OR OLD.namespace != NEW.namespace\n OR OLD.author != NEW.author\n OR OLD.deleted != NEW.deleted\n OR OLD.duplicate != NEW.duplicate\n BEGIN\n -- 1. Remove old entry (Magic 'delete')\n INSERT INTO skills_fts(skills_fts, rowid, name, description, namespace, author)\n VALUES('delete', OLD.rowid, OLD.name, OLD.description, OLD.namespace, OLD.author);\n \n -- 2. Add new entry (if not deleted/duplicate)\n INSERT INTO skills_fts(rowid, name, description, namespace, author)\n SELECT NEW.rowid, NEW.name, NEW.description, NEW.namespace, NEW.author\n WHERE NEW.deleted = 0 AND NEW.duplicate = 0;\n END;\n `);\n\n console.log(\"REPAIR of skills_fts completed.\");\n } catch (error) {\n console.error(\"Skills Repair failed:\", error);\n throw error;\n }\n}\n\nexport async function runMigrations(): Promise {\n // await runCreateTablesAndIndexes();\n // await runAddSkillsMigration();\n // await runAddSkillsTableMigration();\n // await runCreateSearchBuckets()\n // await runAddDeletedColumnMigration();\n // await runCreateSkillsFTS5Migration();\n // await runAddLastCheckedAtMigration();\n // await runAddpartialIndexesMigration();\n \n await runPluginsFTSAndCoveringIndexesMigration();\n await fixSkillsFTSMigration();\n}","deleted","label",[181,164],"database","permalink","https://www.val.town/x/defi_failure/claude-plugins-registry/code/database/db.ts","extension","actionData","errors"]