aboutsummaryrefslogtreecommitdiff
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;