All tables are created automatically on first server start. For manual setup, use install/sql/install.sql.
Tables
Boss System
| Table | Purpose |
|---|
code9_boss_wallets | Boss wallet balances per mechanic |
code9_boss_transactions | Transaction history (deposits, withdrawals, etc) |
code9_boss_settings | Boss settings per mechanic (JSON) |
code9_boss_permissions | Permission overrides per grade |
Mechanics Editor
| Table | Purpose |
|---|
code9_mechanics_runtime | Editor-created mechanic locations (JSON) |
code9_shop_templates | Reusable shop item templates |
code9_craft_templates | Reusable craft recipe templates |
Vehicle Data
| Table | Purpose |
|---|
code9_wheel_tuning | Persistent wheel tuning (camber, offset, width) |
code9_saved_configs | Player-saved mod configurations with codes |
Invoices
| Table | Purpose |
|---|
code9_invoices | Mechanic service invoices |
Manual Installation
If auto-creation fails, run the SQL file manually:
This file contains all 10 CREATE TABLE IF NOT EXISTS statements.
