DUXPLIMA Documentation

Overview

What is stored, the tables, and sharing one database across servers.

The database holds each Bedrock player's choices, the glyph slots, the items learned and the heads seen.

BackendFor
SQLiteOne server. The default
MySQL and MariaDBA network
PostgreSQLThe same, on PostgreSQL

Tables

Every table name starts with storage.table-prefix, uxmbedrock_ by default.

TableHolds
uxmbedrock_playersEach Bedrock player's choices: forms or chests, the features switched off, the animated pack, whether they answered the first question
uxmbedrock_glyphsThe letter each colour, face and font picture is drawn with
uxmbedrock_learned_itemsThe vanilla item, stack size, durability, food and equipment learned for each item model
uxmbedrock_skullsThe skin of every custom head seen
uxmbedrock_schema_historyThe version the tables are at

A network

Point every server at the same database with the same table-prefix. A player's choices then follow them, every server draws a colour with the same letters, and the items and heads one server learned reach every build. Give each server its own server-name.

Keeping one server apart

storage.local-only = true keeps this one server's rows in its own SQLite file while the block stays the same as the other servers'.

Moving off SQLite

Set the new type and its connection, set copy-from-file = true, and restart once. The rows of the SQLite file are copied into the empty tables and the log says how many. Tables that already hold rows are left alone.