RoxiReports SQL

RoxiReports stores moderation data in MySQL through oxmysql. Import the included sql/schema.sql once before going live, then let the resource use those tables normally.

Tables

• roxi_reports - report records, state, owner, priority, category, assigned staff, and archive data.
• roxi_report_comments - public replies and internal staff messages.
• roxi_report_evidence - screenshot and evidence URLs.
• roxi_report_ratings - one-time player feedback after report close.
• roxi_report_timeline - audit trail used by the report detail timeline.
• roxi_report_bans - temporary and permanent report restrictions.
• roxi_report_discord_links - Discord user links and identifier snapshots.
• roxi_report_discord_categories - Discord report category tracking.
• roxi_report_discord_channels - report-to-channel mapping for Discord sync.

Manual install

-- Import the included file before starting the resource:
-- RoxiReports/sql/schema.sql

Production note

Do not drop or rename tables on a live server unless you are intentionally wiping report history. Back up your database before changing table names or moving installs.

Startup order

ensure oxmysql
ensure ox_lib
ensure screencapture
ensure RoxiReports

If screenshot capture is disabled, screencapture can be removed from the startup order.