Installation guide — please follow each step carefully and exactly as described to ensure the script works correctly on your server. Skipping or modifying steps may cause the system to not function properly, so follow it step by step.
This script requires some mandatory dependencies to function correctly. Make sure to download and extract them inside your server’s main directory, keeping their original folder structure intact.
This script includes an essential database required for its operation.You must import it before starting your server, preferably using HeidiSQL or any other manager compatible with MariaDB/MySQL.
ESX/QB
sql
-- qs-starterpack — schema. Idempotent, safe to re-run.
CREATE TABLE IF NOT EXISTS `qs_starterpack_admin_config` (
`id` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
`server_key` VARCHAR(190) NOT NULL DEFAULT 'main',
`config_json` LONGTEXT NOT NULL,
`updated_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP
ON UPDATE CURRENT_TIMESTAMP,
UNIQUE KEY `uniq_qsstarterpack_cfg_server` (`server_key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
CREATE TABLE IF NOT EXISTS `qs_starterpack_claims` (
`id` INT UNSIGNED NOT NULL AUTO_INCREMENT PRIMARY KEY,
`server_key` VARCHAR(190) NOT NULL DEFAULT 'main',
`license` VARCHAR(128) NOT NULL,
`gender` VARCHAR(16) NOT NULL,
`pack_id` VARCHAR(64) NOT NULL,
`claimed_at` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
`claim_period` VARCHAR(32) NULL,
UNIQUE INDEX `uniq_qsstarterpack_claim_period` (`server_key`, `license`, `claim_period`),
INDEX `idx_qsstarterpack_claims_license` (`server_key`, `license`),
INDEX `idx_qsstarterpack_claims_pack` (`pack_id`),
INDEX `idx_qsstarterpack_claims_at` (`claimed_at`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;