aboutsummaryrefslogtreecommitdiff
path: root/src/main/resources/db/specific/postgresql/V1.16__last seen.sql
blob: 9543ca1433c40ca2ac35ba133ea97be927984e44 (plain) (blame)
1
2
ALTER TABLE users ADD COLUMN last_seen timestamp with time zone NULL;
UPDATE users SET last_seen=TO_TIMESTAMP(lastmessage::double precision / 1000);