blob: 1c8607ebf15db8386de0b39fde56572bddc83428 (
plain) (
blame)
1
2
3
4
5
6
7
|
- Presence, for showing how many of your friends are around right now.
- Written as a plain timestamp column rather than a separate table: it is a
- single value per user, overwritten in place, with no history worth keeping.
ALTER TABLE users ADD COLUMN last_seen TEXT;
- The friends list filters on it for every accepted friendship.
CREATE INDEX idx_users_last_seen ON users(last_seen);
|