aboutsummaryrefslogtreecommitdiff
path: root/src/main/resources/db/specific/postgresql/V1.18__increase messages and replies timestamp precision copy.sql
diff options
context:
space:
mode:
authorGravatar Vitaly Takmazov2022-12-15 16:03:23 +0300
committerGravatar Vitaly Takmazov2022-12-15 16:03:23 +0300
commite13c2e7e970fdfb30186edbb58d2982551f1607f (patch)
tree760f4716d05baaeacdf524325b33a3f8d33bf671 /src/main/resources/db/specific/postgresql/V1.18__increase messages and replies timestamp precision copy.sql
parentaa90e6ca91d42af291458a8730d5a03c60f9dd33 (diff)
postgres: baseline full schema to 1.22
Diffstat (limited to 'src/main/resources/db/specific/postgresql/V1.18__increase messages and replies timestamp precision copy.sql')
-rw-r--r--src/main/resources/db/specific/postgresql/V1.18__increase messages and replies timestamp precision copy.sql3
1 files changed, 0 insertions, 3 deletions
diff --git a/src/main/resources/db/specific/postgresql/V1.18__increase messages and replies timestamp precision copy.sql b/src/main/resources/db/specific/postgresql/V1.18__increase messages and replies timestamp precision copy.sql
deleted file mode 100644
index 99b7f5d5..00000000
--- a/src/main/resources/db/specific/postgresql/V1.18__increase messages and replies timestamp precision copy.sql
+++ /dev/null
@@ -1,3 +0,0 @@
-ALTER TABLE users DROP COLUMN lastmessage;
-ALTER TABLE users ADD COLUMN lastmessage timestamp with time zone;
-UPDATE users SET lastmessage=last_seen;