Something went wrong. Try again.
A lexicon-driven AppView for ATProto.
Something went wrong. Try again.
272 B · 9 lines
SQL
at main
12345678910-- Rename tableALTER TABLE admins RENAME TO users;
-- Add is_super columnALTER TABLE users ADD COLUMN is_super BOOLEAN NOT NULL DEFAULT FALSE;
-- Set earliest admin as super userUPDATE users SET is_super = TRUEWHERE created_at = (SELECT MIN(created_at) FROM users);