-- Add actors table for storing AT Protocol actor/profile data
CREATE TABLE IF NOT EXISTS "actor" (
    "did" TEXT PRIMARY KEY NOT NULL,
    "handle" TEXT,
    "indexedAt" TEXT NOT NULL
);

CREATE INDEX IF NOT EXISTS idx_actor_handle ON "actor"("handle");
CREATE INDEX IF NOT EXISTS idx_actor_indexed_at ON "actor"("indexedAt");