Skip to content
8 linesCodeBlameRaw
1-- Usernames keep the case their owner chose: `Ana`, not only `ana`.
2--
3-- `users.username` stays the lowercased name everything finds a person by:
4-- its UNIQUE index is what makes names unique whatever their case, and
5-- URLs, lookups, mentions, git and every other service join on it. The
6-- name as its owner wrote it is kept beside it, for showing. NULL (every
7-- account so far) means it is shown as `username`.
8ALTER TABLE users ADD COLUMN display_username TEXT;