Database
All tables are created and repaired automatically when the resource starts — no manual import is needed. data.sql is kept for reference / fully manual setups.
The automatic setup also migrates older installations (e.g. the legacy multichar_music.license INT column is converted to VARCHAR(60)).
Tables
multichar_music
Per-player background music preferences.
| Column | Type | Description |
|---|---|---|
id | INT (PK, AI) | Unique identifier |
license | VARCHAR(60) | Player license |
url | LONGTEXT | Music URL (YouTube/SoundCloud) |
volume | INT | Volume level |
multichar_purchases
Tebex transaction records for slot purchases.
| Column | Type | Default | Description |
|---|---|---|---|
id | INT (PK, AI) | Unique identifier | |
transaction | VARCHAR(50) | Tebex transaction ID | |
slots | INT | 0 | Number of slots purchased |
used | INT | 0 | Number of slots redeemed |
multichar_slots
Per-player additional slot count.
| Column | Type | Description |
|---|---|---|
id | INT (PK, AI) | Unique identifier |
license | VARCHAR(60) | Player license |
slots | INT | Additional purchased slots |
players / users (ALTER)
A settings column (LONGTEXT) is added automatically to your framework's player table — players for QB/QBox, users for ESX — for storing character display preferences (pose, background, camera, profile photo).