Something went wrong. Try again.
A fork of @slices.network/slices forked from slices.network/slices
Something went wrong. Try again.
328 B · 9 lines
SQL
at main
123456789-- Add actors table for storing AT Protocol actor/profile dataCREATE 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");