| 1 |
CREATE TABLE users ( |
| 2 |
mnw_account_id UUID PRIMARY KEY, |
| 3 |
username TEXT NOT NULL UNIQUE, |
| 4 |
display_name TEXT, |
| 5 |
avatar_url TEXT, |
| 6 |
created_at TIMESTAMPTZ NOT NULL DEFAULT now(), |
| 7 |
updated_at TIMESTAMPTZ NOT NULL DEFAULT now() |
| 8 |
); |
| 9 |
|
| 10 |
CREATE INDEX idx_users_username ON users (username); |
| 11 |
|