Skip to content

Database Structure

Zoriot edited this page Nov 8, 2026 · 23 revisions

Database Structure

For the full schema, see Plot-System-DB.

Operator summary (v5+)

  • Schema is rebuilt in v5 (db_version / current_plot_version live in system_info). Plot version is 4 — older plot rows are not loadable.
  • Schematics (initial / complete) are stored as MEDIUMBLOB in 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.feedback is 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) and is_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.

Clone this wiki locally