aboutsummaryrefslogtreecommitdiff
path: root/juick-server/src/main/resources/db/migration/V1.2__Drop telegram_chats.sql
diff options
context:
space:
mode:
authorGravatar Vitaly Takmazov2018-08-15 00:02:13 +0300
committerGravatar Vitaly Takmazov2018-08-15 00:10:16 +0300
commitc8487940bfd0e796e7fd572e543fe2cf88e191b1 (patch)
tree7dd8fea69b4f2362470479add1d545d62f0220d9 /juick-server/src/main/resources/db/migration/V1.2__Drop telegram_chats.sql
parent2c0cdf69f7273ffd2c2120e93ca9388cb2ec0fcd (diff)
Migrate telegram_chats to telegram table
Diffstat (limited to 'juick-server/src/main/resources/db/migration/V1.2__Drop telegram_chats.sql')
-rw-r--r--juick-server/src/main/resources/db/migration/V1.2__Drop telegram_chats.sql2
1 files changed, 2 insertions, 0 deletions
diff --git a/juick-server/src/main/resources/db/migration/V1.2__Drop telegram_chats.sql b/juick-server/src/main/resources/db/migration/V1.2__Drop telegram_chats.sql
new file mode 100644
index 00000000..c8faee0d
--- /dev/null
+++ b/juick-server/src/main/resources/db/migration/V1.2__Drop telegram_chats.sql
@@ -0,0 +1,2 @@
+INSERT INTO telegram(tg_id, tg_name, loginhash) SELECT chat_id AS tg_id, 'Anonymous', UUID() FROM telegram_chats;
+DROP TABLE telegram_chats; \ No newline at end of file