api/migrations/002_actors.sql at main

danabra.mov / slices

forked from slices.network/slices

fork atom

Highly ambitious ATProtocol AppView service and sdks

fork atom

slices / api / migrations / 002_actors.sql

at main 9 lines 328 B view raw

wrap content

chadtmiller.com clean up /api, use social.slices 6mo ago

3b6e8dbb

1-- Add actors table for storing AT Protocol actor/profile data
2CREATE TABLE IF NOT EXISTS "actor" (
3    "did" TEXT PRIMARY KEY NOT NULL,
4    "handle" TEXT,
5    "indexedAt" TEXT NOT NULL
6);
7
8CREATE INDEX IF NOT EXISTS idx_actor_handle ON "actor"("handle");
9CREATE INDEX IF NOT EXISTS idx_actor_indexed_at ON "actor"("indexedAt");