aboutsummaryrefslogtreecommitdiff
path: root/src/main/resources/db/migration/V1.16__last seen.sql
blob: 52ca4e90978b7bc39dda364a58c9c63612827fb3 (plain) (blame)
1
2
ALTER TABLE users ADD COLUMN last_seen timestamp(6) NULL;
UPDATE users SET last_seen=lastmessage;