V1.18__increase messages and replies timestamp precision copy.sql « postgresql « specific « db « resources « main « src - Juick - Juick development tree

about summary refs log tree commit diff

path: root/src/main/resources/db/specific/postgresql/V1.18__increase messages and replies timestamp precision copy.sql

blob: 99b7f5d5c4fdb20693f27ce0a430a7dd0968e82e (plain) (blame)

1
2
3

ALTER TABLE users DROP COLUMN lastmessage;
ALTER TABLE users ADD COLUMN lastmessage timestamp with time zone;
UPDATE users SET lastmessage=last_seen;