diff options
Diffstat (limited to 'src/main/resources/db/specific/postgresql/V1.2__Drop telegram_chats.sql')
-rw-r--r-- | src/main/resources/db/specific/postgresql/V1.2__Drop telegram_chats.sql | 3 |
1 files changed, 3 insertions, 0 deletions
diff --git a/src/main/resources/db/specific/postgresql/V1.2__Drop telegram_chats.sql b/src/main/resources/db/specific/postgresql/V1.2__Drop telegram_chats.sql new file mode 100644 index 00000000..00e7fdbe --- /dev/null +++ b/src/main/resources/db/specific/postgresql/V1.2__Drop telegram_chats.sql @@ -0,0 +1,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;
\ No newline at end of file |