Something went wrong. Try again.
A lexicon-driven AppView for ATProto.
Something went wrong. Try again.
648 B · 13 lines
SQL
1234567891011121314-- Merge network_lexicons metadata into the lexicons table.ALTER TABLE lexicons ADD COLUMN source TEXT NOT NULL DEFAULT 'manual';ALTER TABLE lexicons ADD COLUMN authority_did TEXT;ALTER TABLE lexicons ADD COLUMN last_fetched_at TEXT;
-- SQLite doesn't support UPDATE ... FROM, so use a correlated subqueryUPDATE lexiconsSET source = 'network', authority_did = (SELECT authority_did FROM network_lexicons WHERE network_lexicons.nsid = lexicons.id), last_fetched_at = (SELECT last_fetched_at FROM network_lexicons WHERE network_lexicons.nsid = lexicons.id)WHERE id IN (SELECT nsid FROM network_lexicons);
DROP TABLE network_lexicons;