Something went wrong. Try again.
A lexicon-driven AppView for ATProto.
Something went wrong. Try again.
489 B · 14 lines
SQL
at dev
123456789101112131415CREATE TABLE IF NOT EXISTS service_entries ( id SERIAL PRIMARY KEY, fragment_id TEXT UNIQUE NOT NULL, service_type TEXT NOT NULL, access_mode TEXT NOT NULL DEFAULT 'all', created_at TEXT NOT NULL, updated_at TEXT NOT NULL);
CREATE TABLE IF NOT EXISTS service_entry_xrpcs ( service_entry_id INTEGER NOT NULL REFERENCES service_entries(id) ON DELETE CASCADE, lexicon_id TEXT NOT NULL, PRIMARY KEY (service_entry_id, lexicon_id));