Spaces:
Paused
Paused
| CREATE TABLE IF NOT EXISTS players ( | |
| id INTEGER PRIMARY KEY AUTOINCREMENT, | |
| username TEXT UNIQUE NOT NULL, | |
| password_hash TEXT NOT NULL, | |
| email TEXT UNIQUE, | |
| role TEXT, | |
| location TEXT DEFAULT 'Las Vegas', | |
| health INTEGER DEFAULT 100, | |
| money INTEGER DEFAULT 0 | |
| ); | |
| CREATE TABLE IF NOT EXISTS messages ( | |
| id INTEGER PRIMARY KEY AUTOINCREMENT, | |
| sender_id INTEGER, | |
| receiver_id INTEGER, | |
| content TEXT, | |
| timestamp DATETIME DEFAULT CURRENT_TIMESTAMP, | |
| FOREIGN KEY (sender_id) REFERENCES players (id), | |
| FOREIGN KEY (receiver_id) REFERENCES players (id) | |
| ); | |
| CREATE TABLE IF NOT EXISTS events ( | |
| id INTEGER PRIMARY KEY AUTOINCREMENT, | |
| event_type TEXT, | |
| description TEXT, | |
| player_id INTEGER, | |
| timestamp DATETIME DEFAULT CURRENT_TIMESTAMP, | |
| FOREIGN KEY (player_id) REFERENCES players (id) | |
| ); |