Method migrate

packages/memos-core/src/storage/sqlite.ts:21–124

()

  // ─── Schema ───

  private migrate(): void {
    this.db.exec(`
      CREATE TABLE IF NOT EXISTS chunks (
        id          TEXT PRIMARY KEY,
        session_key TEXT NOT NULL,
        turn_id     TEXT NOT NULL,
        seq         INTEGER NOT NULL,
        role        TEXT NOT NULL,
        content     TEXT NOT NULL,
        kind        TEXT NOT NULL DEFAULT 'paragraph',
        summary     TEXT NOT NULL DEFAULT '',
        created_at  INTEGER NOT NULL,
        updated_at  INTEGER NOT NULL
      );

      CREATE INDEX IF NOT EXISTS idx_chunks_session
        ON chunks(session_key);
      CREATE INDEX IF NOT EXISTS idx_chunks_turn
        ON chunks(session_key, turn_id, seq);
      CREATE INDEX IF NOT EXISTS idx_chunks_created
        ON chunks(created_at);
      CREATE INDEX IF NOT EXISTS idx_chunks_session_created
        ON chunks(session_key, created_at, seq);

      CREATE VIRTUAL TABLE IF NOT EXISTS chunks_fts USING fts5(
        summary,
        content,
        content='chunks',
        content_rowid='rowid',
        tokenize='trigram'
      );

      CREATE TRIGGER IF NOT EXISTS chunks_ai AFTER INSERT ON chunks BEGIN
        INSERT INTO chunks_fts(rowid, summary, content)
        VALUES (new.rowid, new.summary, new.content);
      END;

      CREATE TRIGGER IF NOT EXISTS chunks_ad AFTER DELETE ON chunks BEGIN
        INSERT INTO chunks_fts(chunks_fts, rowid, summary, content)
        VALUES ('delete', old.rowid, old.summary, old.content);
      END;

      CREATE TRIGGER IF NOT EXISTS chunks_au AFTER UPDATE ON chunks BEGIN
        INSERT INTO chunks_fts(chunks_fts, rowid, summary, content)
        VALUES ('delete', old.rowid, old.summary, old.content);
        INSERT INTO chunks_fts(rowid, summary, content)
        VALUES (new.rowid, new.summary, new.content);
      END;

      CREATE TABLE IF NOT EXISTS embeddings (
        chunk_id   TEXT PRIMARY KEY REFERENCES chunks(id) ON DELETE CASCADE,
        vector     BLOB NOT NULL,
        dimensions INTEGER NOT NULL,
        updated_at INTEGER NOT NULL
      );

      CREATE TABLE IF NOT EXISTS viewer_events (
        id         INTEGER PRIMARY KEY AUTOINCREMENT,