Something went wrong. Try again.
A lexicon-driven AppView for ATProto.
Something went wrong. Try again.
556 B · 14 lines
SQL
at dev
123456789101112131415CREATE TABLE IF NOT EXISTS service_entries ( id INTEGER PRIMARY KEY AUTOINCREMENT, fragment_id TEXT UNIQUE NOT NULL, service_type TEXT NOT NULL, access_mode TEXT NOT NULL DEFAULT 'all', created_at TEXT NOT NULL DEFAULT (datetime('now')), updated_at TEXT NOT NULL DEFAULT (datetime('now')));
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));