- id INTEGER PRIMARY KEY,
- username TEXT,
- password TEXT,
- status TEXT DEFAULT 'active'
+ id INTEGER PRIMARY KEY,
+ email TEXT,
+ username TEXT UNIQUE,
+ password TEXT NOT NULL,
+ status TEXT DEFAULT 'active',
+ current_room INTEGER REFERENCES room(id)