Repository navigation
Database Structure
Zoriot edited this page Nov 8, 2026
·
23 revisions
For the full schema, see Plot-System-DB.
- Schema is rebuilt in v5 (
db_version/current_plot_versionlive insystem_info). Plot version is 4 — older plot rows are not loadable. -
Schematics (
initial/complete) are stored asMEDIUMBLOBin the database. FTP sync and filesystem schematic trees for plots are gone. - City projects, countries, and difficulties store string IDs; display names/descriptions come from LangLibs language files under
database:(see Translation). - Review 2.0 tables include
review_toggle_criteria,build_team_uses_toggle_criteria,review_contains_toggle_criteria, plus reviewer assignment (build_team_has_reviewer) and notification flags (builder_has_review_notification). -
plot_review.feedbackis limited (VARCHAR 512). Ratings store Accuracy + Block Palette; toggles are separate rows. - Terra API mode uses
build_team.api_key/api_create_date. - Cities have
city_project_id(string) andis_visible. - Default difficulties are
EASY/MEDIUM/HARD.
After a successful v4→v5 migration you can eventually drop leftover v4 tables and clean old schematic folders — see Upgrade from v4 to v5.