Database
Player preferences and music data are stored in a single MySQL table. Import data.sql to create it.
Table: code9_carplay
| Column | Type | Default | Description |
|---|---|---|---|
identifier | VARCHAR(64) | PK | Player license identifier |
playlist | LONGTEXT | NULL | JSON array of user playlists |
liked_songs | LONGTEXT | NULL | JSON array of liked songs |
autopilot_pos | LONGTEXT | NULL | JSON of saved autopilot position |
ui_theme | VARCHAR(50) | NULL | Selected theme ID |
nav_active | BOOLEAN | TRUE | Navigation overlay enabled |
volume | INT | 50 | Music volume level (0-100) |
Auto-Creation
The server automatically creates a row for new players using INSERT IGNORE when they first open CarPlay.
Supported Database Drivers
oxmysqlmysql-asyncghmattimysql