aboutsummaryrefslogtreecommitdiff
path: root/src/main/resources/db/specific/postgresql/V1.2__Drop telegram_chats.sql
blob: 00e7fdbe54af4e8d1722736dedde63a801d2e564 (plain) (blame)
1
2
3
CREATE EXTENSION IF NOT EXISTS "pgcrypto";
INSERT INTO telegram(tg_id, tg_name, loginhash) SELECT chat_id AS tg_id, 'Anonymous', gen_random_uuid() FROM telegram_chats;
DROP TABLE telegram_chats;