Database Schema
The script uses several tables for shop state, pawns, missions, vehicles, and loyalty data.
Main shop table
The main shop table stores the long-term shop state.
Typical fields include:
owner and owner name
current funds
shop XP
worker data
active state flags
selected categories
shelves and stash data
special items
packaging areas
computer style
Database-created shops
Shops made through the admin wizard are stored separately.
That table stores:
created shop name
ped data
ownership settings
price and starting equity
selected categories
special items
creator info
timestamps
Pawn records
Pawn records store:
shop
player identifier
player name
pawned items
pawn price
buyback price
pawn time
expiry time
current status
Export orders
Export order records track:
item and category
required quantity
estimated payout and XP
worker assigned
order status
pending and delivery timers
completion data
Shop vehicles
Vehicle records track:
model
plate
destroyed state
purchase info
engine and body health
fuel level
Loyalty data
Loyalty records track:
player membership tier
loyalty points
spending history
sold and pawned totals
subscription cost and expiry
auto-renew state
Other supporting tables
You should also expect tables for:
activity logs
payslips
supplier offers
permission presets
The exact schema can change between builds. Treat this page as a field guide, not a migration script.
Related pages
Last updated