RoxiCrosshairs SQL

RoxiCrosshairs stores normalized JSON configs, favorite links, and active player preferences. The full schema is included in sql/schema.sql.

Tables

• roxi_crosshairs - saved crosshair configs, labels, owners, and public state.
• roxi_crosshair_favorites - saved favorites when community favorites are enabled.
• roxi_crosshair_preferences - active crosshair selection per configured owner key.

Schema example

CREATE TABLE IF NOT EXISTS `roxi_crosshairs` (
  `id` int NOT NULL AUTO_INCREMENT,
  `config` longtext NOT NULL,
  `label` varchar(80) NOT NULL DEFAULT 'My Crosshair',
  `owner_identifier` varchar(80) NOT NULL,
  `owner_name` varchar(80) NOT NULL,
  `is_public` tinyint(1) NOT NULL DEFAULT 0,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`),
  KEY `idx_owner` (`owner_identifier`),
  KEY `idx_public` (`is_public`)
);

Manual install

-- Import this file:
-- RoxiCrosshairs/sql/schema.sql

Ownership note

The owner_identifier column stores whichever owner key your config chooses. With license, it stores a license-based key. With citizenid, it stores a citizenid-based key.