Doclea MCP

/**
 * Pending memories migration
 *
 * Creates schema for storing pending memories in suggested/manual storage modes.
 * Pending memories are stored here before user approval, then moved to the
 * main memories table and vector store upon approval.
 */

import type { Migration, MigrationDatabase } from "./types";

export const migration006PendingMemories: Migration = {
  version: "006",
  name: "pending_memories",
  destructive: false,

  up(db: MigrationDatabase): void {
    // Create pending_memories table
    db.exec(`
			CREATE TABLE IF NOT EXISTS pending_memories (
				id TEXT PRIMARY KEY,
				memory_data TEXT NOT NULL,
				qdrant_id TEXT NOT NULL,
				suggested_at INTEGER NOT NULL,
				source TEXT NOT NULL,
				reason TEXT NOT NULL
			)
		`);

    // Create index for efficient queries by suggested_at
    db.exec(`
			CREATE INDEX IF NOT EXISTS idx_pending_memories_suggested_at
			ON pending_memories(suggested_at)
		`);

    // Create index for source filtering
    db.exec(`
			CREATE INDEX IF NOT EXISTS idx_pending_memories_source
			ON pending_memories(source)
		`);
  },

  down(db: MigrationDatabase): void {
    db.exec("DROP TABLE IF EXISTS pending_memories");
  },
};