mirror of
https://github.com/iamxvbaba/gramsrv.git
synced 2026-11-19 05:16:55 +03:00
fff8de783a
Implements collectible usernames, official verification workflows, and third-party bot verification after maintainer protocol and migration review. The composite activity/moderation rating remains an admin-only read model; Telegram Stars Rating wire fields stay unset pending a dedicated official-semantics implementation. Reviewed-Head:2796345775Original-Head:fa082b892fCo-authored-by: Egor Egorov <business.egor.sg@gmail.com>
10 lines
423 B
SQL
10 lines
423 B
SQL
-- Remove the built-in @verifybot seed. Its private history is left alone: chat
|
|
-- rows reference the account, and dropping them would rewrite users' dialogs.
|
|
DELETE FROM public.read_model_versions
|
|
WHERE owner_user_id = 1250000011 AND peer_type = 'user' AND peer_id = 1250000011;
|
|
|
|
DELETE FROM public.peer_usernames
|
|
WHERE peer_type = 'user' AND peer_id = 1250000011;
|
|
|
|
DELETE FROM public.bots WHERE bot_user_id = 1250000011;
|