Database
Koja Inventory creates its tables with CREATE TABLE IF NOT EXISTS every time it starts. There is no SQL file to import, and nothing in the upstream ox_inventory table changes.
Tables
| Table | What is in it |
|---|---|
koja_inv_items | Items created or edited on the admin Items pages (name, data as JSON) |
koja_inv_rarities | Rarities edited on Edit Rarity |
koja_inv_shops | Shops created or edited on Shops |
koja_inv_stashes | Stashes created or edited on Stashes |
koja_inv_crafting | Crafting benches created or edited on Crafting benches |
koja_inv_roles | Staff roles and their page permissions |
koja_inv_staff | Staff members: identifier, name, role, last_seen |
koja_inv_locales | String overrides from Locales (lang, k, v) |
koja_inv_settings | Panel settings: addon toggles (features), ped preview mode (pedMode), world containers (containers), clothing (clothing), security (security) |
koja_inv_history | The inventory history: time, action, actor, from / to inventory, item, count, slot, serial, metadata |
koja_inv_security | Security reports: time, player, kind, detail |
koja_inv_attachment_offsets | Marker offsets of the 3D attachments view per weapon and component |
Values in these tables override the matching data/ files. Delete a row (or use the panel's restore / reset buttons) to go back to the file.
Worn clothes and mini stashes
These are normal ox_inventory inventories, saved in the upstream ox_inventory table like stashes:
| Inventory id | What it holds |
|---|---|
koja_clothes:<identifier> | The clothes a character wears, one slot per clothing slot |
koja_mini_<serial> | The contents of one mini stash or hanger, keyed by the item's serial number |
They are private: players cannot open them by id.
History cleanup
History rows older than history.retentionDays (30 days) are deleted on start and every 6 hours. Set it to 0 to keep everything. To exclude noisy actions, add them to history.ignore:
data/koja/admin.lua
history = {
retentionDays = 14,
ignore = { open = true, close = true },
},