### Installation Guides Source: https://context7_llms Provides instructions on how to install various script modules. These guides are essential for setting up the project components. ```markdown - [Installation](/scripts/multichar-and-spawn/installation.md) - [Installation](/scripts/yacht-creator/installation.md) - [Installation](/scripts/gangs-and-territories/installation.md) - [Installation](/scripts/shops-creator/installation.md) - [Installation](/scripts/dispatch-and-mdt/installation.md) - [Installation](/scripts/crafting-creator/installation.md) - [Installation](/scripts/fuel-stations/installation.md) - [Installation](/scripts/deathmatch-creator/installation.md) - [Installation](/scripts/banking-and-cards/installation.md) - [Installation](/scripts/realistic-gym/installation.md) - [Installation](/scripts/lumberjack-job/installation.md) - [Installation](/scripts/vehicleshop-creator/installation.md) - [Installation](/scripts/tv-and-billboards-creator/installation.md) - [Installation](/scripts/apartments/installation.md) - [Installation](/scripts/daily-rewards-christmas/installation.md) - [Installation](/scripts/job-center/installation.md) - [Installation](/scripts/outfit-bag/installation.md) ``` -------------------------------- ### Install Script Source: https://context7_llms Provides instructions for installing various scripts. This typically involves copying files and potentially running setup commands. Specific dependencies may vary per script. ```markdown - [Installation](/scripts/taxi-job/installation.md) - [Installation](/scripts/motels-creator/installation.md) - [Installation](/scripts/trading-cards/installation.md) - [Installation](/scripts/camera/installation.md) - [Installation](/scripts/books-creator/installation.md) - [Installation](/scripts/newspaper-job/installation.md) - [Installation](/scripts/trucker-job/installation.md) - [Installation](/scripts/scoreboard/installation.md) - [Installation](/scripts/hunter-job/installation.md) - [Installation](/scripts/miner-job/installation.md) - [Installation](/scripts/fishing-job/installation.md) - [Installation](/scripts/treasure-hunting/installation.md) - [Installation](/scripts/multijob/installation.md) - [Installation](/scripts/black-market/installation.md) - [Installation](/scripts/realistic-billing/installation.md) - [Installation](/scripts/gangwars-and-drugs/installation.md) - [Installation](/scripts/shutters-creator/installation.md) - [Installation](/scripts/bus-driver-job/installation.md) - [Installation](/scripts/vehiclekeys/installation.md) - [Installation](/scripts/garbage-job/installation.md) - [Installation](/scripts/dog-walker-job/installation.md) - [Installation](/scripts/pause-menu/installation.md) - [Installation](/scripts/backrooms/installation.md) ``` -------------------------------- ### Database Setup for QBCORE Source: https://docs.quasar-store.com/scripts/taxi-job/installation SQL command to create the 'qs_taxijob' table for player progression. This is specific to the QBCORE framework and assumes job definitions are handled elsewhere. ```sql CREATE TABLE IF NOT EXISTS `qs_taxijob` ( `identifier` VARCHAR(46) NOT NULL COLLATE 'utf8mb4_general_ci', `level` INT(10) UNSIGNED NOT NULL DEFAULT '1', `experience` INT(10) UNSIGNED NOT NULL DEFAULT '0', PRIMARY KEY (`identifier`) USING BTREE ); ``` -------------------------------- ### Database Setup for ESX Source: https://docs.quasar-store.com/scripts/taxi-job/installation SQL commands to set up the 'jobs' and 'job_grades' tables for the Taxi job, and create the 'qs_taxijob' table for player progression. This is specific to the ESX framework. ```sql INSERT INTO `jobs` (name, label) VALUES ('taxi','Taxi') ; INSERT INTO `job_grades` (job_name, grade, name, label, salary, skin_male, skin_female) VALUES ('taxi',0,'novice','Novice',10,'{}','{}') ; CREATE TABLE IF NOT EXISTS `qs_taxijob` ( `identifier` VARCHAR(46) NOT NULL COLLATE 'utf8mb4_general_ci', `level` INT(10) UNSIGNED NOT NULL DEFAULT '1', `experience` INT(10) UNSIGNED NOT NULL DEFAULT '0', PRIMARY KEY (`identifier`) USING BTREE ) ; ``` -------------------------------- ### Database Setup for QBCORE Framework - Quasar Store Source: https://docs.quasar-store.com/scripts/yacht-creator/installation This SQL script initializes the database for the Quasar Store project using the QBCORE framework. It includes altering the 'players' table and creating the 'qs_yachts' table. This setup is crucial before server startup. ```sql ALTER TABLE `players` ADD COLUMN IF NOT EXISTS `yacht_inside` VARCHAR(40) NULL DEFAULT NULL; CREATE TABLE IF NOT EXISTS `qs_yachts` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `yacht_id` INT(11) NOT NULL, `owner` VARCHAR(60) NOT NULL COLLATE 'utf8mb4_unicode_ci', `owner_name` VARCHAR(100) NOT NULL COLLATE 'utf8mb4_unicode_ci', `name` VARCHAR(100) NULL DEFAULT '' COLLATE 'utf8mb4_unicode_ci', `modifications` LONGTEXT NOT NULL COLLATE 'utf8mb4_unicode_ci', ``` -------------------------------- ### Database Setup for Truck Driver Job (QBCORE) Source: https://docs.quasar-store.com/scripts/trucker-job/installation SQL script to set up the database for the truck driver job within the QBCORE framework. It creates necessary tables for tracking experience, earnings, and rewards. Ensure this script is run before starting the server. ```sql CREATE TABLE IF NOT EXISTS `qs_truckdriverjob` ( `identifier` VARCHAR(46) NOT NULL COLLATE 'utf8mb4_general_ci', `level` INT(10) UNSIGNED NOT NULL DEFAULT '1', `experience` INT(10) UNSIGNED NOT NULL DEFAULT '0', `total_experience` INT(10) UNSIGNED NOT NULL DEFAULT '0', `total_earnings` INT(10) UNSIGNED NOT NULL DEFAULT '0', `season_experience` INT(10) UNSIGNED NOT NULL DEFAULT '0', `season_earnings` INT(10) UNSIGNED NOT NULL DEFAULT '0', `daily_experience` INT(10) UNSIGNED NOT NULL DEFAULT '0', `daily_earnings` INT(10) UNSIGNED NOT NULL DEFAULT '0', PRIMARY KEY (`identifier`) USING BTREE ) ; CREATE TABLE IF NOT EXISTS `qs_truckdriverjob_resets` ( `identifier` VARCHAR(46) NOT NULL COLLATE 'utf8mb4_general_ci', `last_daily_reset` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, `last_season_reset` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`identifier`) USING BTREE ) ; CREATE TABLE IF NOT EXISTS `qs_truckdriverjob_rewards` ( id INT AUTO_INCREMENT PRIMARY KEY, identifier VARCHAR(255) NOT NULL, reward_type VARCHAR(50) NOT NULL, reward_amount INT NOT NULL ) ; CREATE TABLE IF NOT EXISTS `qs_truckdriverjob_leaderboard_winners` ( id INT AUTO_INCREMENT PRIMARY KEY, position INT NOT NULL, identifier VARCHAR(255) NOT NULL, reward_amount INT NOT NULL, reward_type VARCHAR(10) NOT NULL, UNIQUE KEY (position, reward_type) ) ; ``` -------------------------------- ### QBCORE Player and House Table Setup (SQL) Source: https://docs.quasar-store.com/scripts/housing-creator/installation Defines and modifies SQL tables for the QBCORE framework, including player data extensions, house locations, player-house associations, house rents, house objects, and house plants. It ensures tables exist before creation and adds columns if they don't. ```sql ALTER TABLE `players" ADD IF NOT EXISTS `inside` VARCHAR(50) NULL DEFAULT ''; CREATE TABLE IF NOT EXISTS `houselocations` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `name` VARCHAR(255) NOT NULL DEFAULT '' COLLATE 'latin1_swedish_ci', `label` VARCHAR(255) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci', `coords` TEXT NULL DEFAULT NULL COLLATE 'latin1_swedish_ci', `owned` TINYINT(2) NULL DEFAULT NULL, `price` INT(11) NULL DEFAULT NULL, `defaultPrice` INT(11) NULL DEFAULT NULL, `tier` TINYINT(2) NULL DEFAULT NULL, `garage` TEXT NULL DEFAULT NULL COLLATE 'latin1_swedish_ci', `garageShell` TEXT NULL DEFAULT NULL COLLATE 'latin1_swedish_ci', `creator` VARCHAR(50) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci', `mlo` TEXT NULL DEFAULT NULL COLLATE 'latin1_swedish_ci', `ipl` TEXT NULL DEFAULT NULL COLLATE 'latin1_swedish_ci', `console` INT(11) NULL DEFAULT NULL, `board` TEXT NULL DEFAULT NULL COLLATE 'latin1_swedish_ci', `for_sale` INT(11) NULL DEFAULT '1', `extra_imgs` TEXT NULL DEFAULT NULL COLLATE 'latin1_swedish_ci', `description` TEXT NOT NULL DEFAULT '' COLLATE 'latin1_swedish_ci', `creatorJob` VARCHAR(50) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci', `blip` TEXT NULL DEFAULT NULL COLLATE 'latin1_swedish_ci', `upgrades` TEXT NULL DEFAULT NULL COLLATE 'latin1_swedish_ci', `apartmentCount` INT(11) NULL DEFAULT NULL, PRIMARY KEY (`name`) USING BTREE, INDEX `name` (`name`) USING BTREE, INDEX `id` (`id`) USING BTREE ) COLLATE='utf8mb4_general_ci' ENGINE=InnoDB AUTO_INCREMENT=1 ; CREATE TABLE IF NOT EXISTS `player_houses` ( `id` INT(255) NOT NULL AUTO_INCREMENT, `house` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci', `citizenid` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci', `owner` VARCHAR(46) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci', `keyholders` TEXT NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci', `stash` TEXT NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci', `outfit` TEXT NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci', `logout` TEXT NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci', `decorateStash` TEXT NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci', `charge` TEXT NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci', `credit` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci', `creditPrice` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci', `console` TEXT NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci', `decorateCoords` TEXT NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci', `rented` INT(11) NULL DEFAULT NULL, `rentPrice` INT(11) NULL DEFAULT NULL, `rentable` INT(11) NULL DEFAULT NULL, `purchasable` INT(11) NULL DEFAULT NULL, `vaultCodes` TEXT NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci', PRIMARY KEY (`id`) USING BTREE, INDEX `house` (`house`) USING BTREE, INDEX `owner` (`owner`) USING BTREE, INDEX `citizenid` (`citizenid`) USING BTREE ) COLLATE='utf8mb4_general_ci' ENGINE=InnoDB AUTO_INCREMENT=3 ; CREATE TABLE IF NOT EXISTS `house_rents` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `house` VARCHAR(50) NOT NULL DEFAULT '' COLLATE 'utf8mb4_general_ci', `identifier` VARCHAR(80) NOT NULL DEFAULT '' COLLATE 'utf8mb4_general_ci', `payed` INT(11) NOT NULL DEFAULT '0', `date` TIMESTAMP NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (`id`) USING BTREE ) COLLATE = 'utf8mb4_general_ci' ENGINE = InnoDB AUTO_INCREMENT = 1; CREATE TABLE IF NOT EXISTS `house_objects` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `creator` VARCHAR(50) NOT NULL DEFAULT '0' COLLATE 'latin1_swedish_ci', `model` VARCHAR(50) NOT NULL DEFAULT '0' COLLATE 'latin1_swedish_ci', `coords` TEXT NOT NULL COLLATE 'latin1_swedish_ci', `house` VARCHAR(80) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci', `construction` VARCHAR(50) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci', `created` TIMESTAMP NULL DEFAULT current_timestamp(), PRIMARY KEY (`id`) USING BTREE ) COLLATE='latin1_swedish_ci' ENGINE=InnoDB AUTO_INCREMENT=1 ; ALTER TABLE `house_objects` ADD IF NOT EXISTS `construction` VARCHAR(50) NULL DEFAULT NULL, ADD IF NOT EXISTS `created` TIMESTAMP NULL DEFAULT current_timestamp() ; CREATE TABLE IF NOT EXISTS `house_plants` ( `id` int(11) NOT NULL AUTO_INCREMENT, `building` varchar(50) DEFAULT NULL, `stage` varchar(50) DEFAULT 'stage-a', `sort` varchar(50) DEFAULT NULL, `gender` varchar(50) DEFAULT NULL, `food` int(11) DEFAULT 100, `health` int(11) DEFAULT 100, `progress` int(11) DEFAULT 0, `coords` text DEFAULT NULL, `plantid` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`), KEY `building` (`building`), KEY `plantid` (`plantid`) ) ENGINE = InnoDB AUTO_INCREMENT = 1 DEFAULT CHARSET = utf8mb4; CREATE TABLE IF NOT EXISTS `house_meta_keys` ( ``` -------------------------------- ### Database Setup for ESX Framework Source: https://docs.quasar-store.com/scripts/advanced-garages/installation This SQL script sets up the database tables required for the ESX framework, including 'owned_vehicles', 'player_garages', and 'qs_garage_decorations'. It also alters the 'users' table to add a 'shell_garage' column. Ensure this script is imported before starting your server. ```sql ALTER TABLE `users` ADD IF NOT EXISTS `shell_garage` TEXT NULL DEFAULT ''; DROP TABLE IF EXISTS `owned_vehicles`; CREATE TABLE `owned_vehicles` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `owner` VARCHAR(255) NOT NULL COLLATE 'utf8mb4_bin', `tag` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_bin', `plate` VARCHAR(250) NOT NULL COLLATE 'utf8mb4_bin', `vehicle` LONGTEXT NULL DEFAULT NULL COLLATE 'utf8mb4_bin', `type` VARCHAR(20) NOT NULL DEFAULT 'vehicle' COLLATE 'utf8mb4_bin', `garage` VARCHAR(200) NULL DEFAULT 'OUT' COLLATE 'utf8mb4_bin', `impound_data` TEXT NULL DEFAULT '' COLLATE 'utf8mb4_bin', `favorite` INT(3) NOT NULL DEFAULT '0', `stored` TINYINT(4) NULL DEFAULT '0', `jobVehicle` VARCHAR(50) NULL DEFAULT '' COLLATE 'utf8mb4_bin', `jobGarage` VARCHAR(50) NULL DEFAULT '' COLLATE 'utf8mb4_bin', PRIMARY KEY (`id`) USING BTREE ) COLLATE = 'utf8mb4_bin' ENGINE = InnoDB AUTO_INCREMENT = 1; ALTER TABLE `owned_vehicles` CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_bin; DROP TABLE IF EXISTS `player_garages`; CREATE TABLE `player_garages` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `creator` VARCHAR(80) NULL DEFAULT NULL, `owner` VARCHAR(80) NULL DEFAULT NULL, `name` VARCHAR(50) NULL DEFAULT NULL, `price` INT(11) NOT NULL, `coords` LONGTEXT NULL DEFAULT NULL, `zone` LONGTEXT NULL DEFAULT NULL, `shell` LONGTEXT NULL DEFAULT NULL, `type` VARCHAR(50) NULL DEFAULT 'vehicle', `holders` TEXT NULL DEFAULT NULL, `available` TINYINT(1) NULL DEFAULT NULL, `isImpound` TINYINT(1) NULL DEFAULT NULL, `jobs` LONGTEXT NULL DEFAULT NULL, `gangs` LONGTEXT NULL DEFAULT NULL, `interior_type` ENUM('ipl','shell') NOT NULL DEFAULT 'ipl', PRIMARY KEY (`id`) USING BTREE, INDEX `creator` (`creator`) USING BTREE )COLLATE='utf8mb4_unicode_ci'; CREATE TABLE IF NOT EXISTS `qs_garage_decorations` ( `id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT, `insideId` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci', `creator` VARCHAR(70) NOT NULL DEFAULT '0' COLLATE 'utf8mb3_general_ci', `modelName` VARCHAR(50) NOT NULL DEFAULT '0' COLLATE 'utf8mb3_general_ci', `coords` TEXT NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci', `rotation` TEXT NOT NULL DEFAULT '' COLLATE 'utf8mb3_general_ci', `inStash` TINYINT(1) NOT NULL DEFAULT '0', `inside` TINYINT(1) UNSIGNED NOT NULL DEFAULT '0', `uniq` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci', `created` TIMESTAMP NULL DEFAULT NULL, `lightData` TEXT NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci', PRIMARY KEY (`id`) USING BTREE, INDEX `id` (`id`, `insideId`) USING BTREE )COLLATE='utf8mb3_general_ci'; DROP TABLE IF EXISTS `qs_garage_furnitures`; CREATE TABLE `qs_garage_furnitures` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `creator` VARCHAR(80) NULL DEFAULT NULL, `category_key` VARCHAR(100) NOT NULL, `object` VARCHAR(200) NOT NULL, `label` VARCHAR(255) NOT NULL, `description` TEXT NULL DEFAULT NULL, `price` INT(11) NOT NULL DEFAULT '0', `img` TEXT NULL DEFAULT NULL, `colorlabel` VARCHAR(255) NULL DEFAULT NULL, `type` VARCHAR(50) NULL DEFAULT NULL, `stash` LONGTEXT NULL DEFAULT NULL, `offset` LONGTEXT NULL DEFAULT NULL, `colors` LONGTEXT NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE, INDEX `creator` (`creator`) USING BTREE, INDEX `category_key` (`category_key`) USING BTREE )COLLATE='utf8mb4_unicode_ci' ENGINE=InnoDB; ``` -------------------------------- ### FiveManage Token Setup (Configuration) Source: https://docs.quasar-store.com/scripts/housing-creator/installation This configuration snippet shows where to paste the FiveManage token in the fivemanage.lua file. This token is essential for the phone's photo and video system to function correctly. ```lua Config.FiveManageToken = "YOUR_FIVE_MANAGE_TOKEN" ``` -------------------------------- ### SQL Database Table Creation for ESX Housing System Source: https://docs.quasar-store.com/scripts/housing-creator/installation This SQL script defines the necessary tables for managing housing locations, player-owned houses, house rents, house objects, junk, and plant data within an ESX framework. It includes primary keys, indexes, and default values for various columns to ensure data integrity and efficient querying. This setup is crucial for the housing system's functionality. ```sql CREATE TABLE IF NOT EXISTS `houselocations` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `name` VARCHAR(255) NOT NULL DEFAULT '', `label` VARCHAR(255) NULL DEFAULT NULL, `coords` TEXT NULL DEFAULT NULL, `owned` TINYINT(2) NULL DEFAULT NULL, `price` INT(11) NULL DEFAULT NULL, `defaultPrice` INT(11) NULL DEFAULT NULL, `tier` TINYINT(2) NULL DEFAULT NULL, `garage` TEXT NULL DEFAULT NULL, `garageShell` TEXT NULL DEFAULT NULL, `creator` VARCHAR(50) NULL DEFAULT NULL, `mlo` TEXT NULL DEFAULT NULL, `ipl` TEXT NULL DEFAULT NULL, `console` INT(11) NULL DEFAULT NULL, `board` TEXT NULL DEFAULT NULL, `for_sale` INT(11) NULL DEFAULT '1', `extra_imgs` TEXT NULL DEFAULT NULL, `description` TEXT NOT NULL DEFAULT '', `creatorJob` VARCHAR(50) NULL DEFAULT NULL, `blip` TEXT NULL DEFAULT NULL, `upgrades` TEXT NULL DEFAULT NULL, `apartmentCount` INT(11) NULL DEFAULT NULL, PRIMARY KEY (`name`) USING BTREE, INDEX `name` (`name`) USING BTREE, INDEX `id` (`id`) USING BTREE ) COLLATE='utf8mb4_general_ci' ; CREATE TABLE IF NOT EXISTS `player_houses` ( `id` INT(255) NOT NULL AUTO_INCREMENT, `house` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci', `citizenid` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci', `owner` VARCHAR(46) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci', `keyholders` TEXT NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci', `stash` TEXT NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci', `outfit` TEXT NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci', `logout` TEXT NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci', `decorateStash` TEXT NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci', `charge` TEXT NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci', `credit` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci', `creditPrice` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci', `console` TEXT NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci', `decorateCoords` TEXT NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci', `rented` INT(11) NULL DEFAULT NULL, `rentPrice` INT(11) NULL DEFAULT NULL, `rentable` INT(11) NULL DEFAULT NULL, `purchasable` INT(11) NULL DEFAULT NULL, `vaultCodes` TEXT NULL DEFAULT NULL COLLATE 'utf8mb4_general_ci', PRIMARY KEY (`id`) USING BTREE, INDEX `house` (`house`) USING BTREE, INDEX `owner` (`owner`) USING BTREE, INDEX `citizenid` (`citizenid`) USING BTREE ) COLLATE='utf8mb4_general_ci' ENGINE=InnoDB AUTO_INCREMENT=3 ; CREATE TABLE IF NOT EXISTS `house_rents` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `house` VARCHAR(50) NOT NULL DEFAULT '' COLLATE 'utf8mb4_general_ci', `identifier` VARCHAR(80) NOT NULL DEFAULT '' COLLATE 'utf8mb4_general_ci', `payed` INT(11) NOT NULL DEFAULT '0', `date` TIMESTAMP NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(), PRIMARY KEY (`id`) USING BTREE ) COLLATE = 'utf8mb4_general_ci' ENGINE = InnoDB AUTO_INCREMENT = 1; CREATE TABLE IF NOT EXISTS `house_objects` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `creator` VARCHAR(50) NOT NULL DEFAULT '0' COLLATE 'latin1_swedish_ci', `model` VARCHAR(50) NOT NULL DEFAULT '0' COLLATE 'latin1_swedish_ci', `coords` TEXT NOT NULL COLLATE 'latin1_swedish_ci', `house` VARCHAR(80) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci', `construction` VARCHAR(50) NULL DEFAULT NULL COLLATE 'latin1_swedish_ci', `created` TIMESTAMP NULL DEFAULT current_timestamp(), PRIMARY KEY (`id`) USING BTREE ) COLLATE='latin1_swedish_ci' ENGINE=InnoDB AUTO_INCREMENT=1 ; CREATE TABLE IF NOT EXISTS `house_junk` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `house` VARCHAR(255) NOT NULL, `model` VARCHAR(255) NOT NULL, `coords` LONGTEXT NULL DEFAULT NULL, `created_at` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP(), PRIMARY KEY (`id`) USING BTREE, INDEX `idx_house` (`house`) USING BTREE ) COLLATE='utf8mb4_unicode_ci' ENGINE=InnoDB AUTO_INCREMENT=1; ALTER TABLE `house_objects` ADD IF NOT EXISTS `construction` VARCHAR(50) NULL DEFAULT NULL, ADD IF NOT EXISTS `created` TIMESTAMP NULL DEFAULT current_timestamp() ; CREATE TABLE IF NOT EXISTS `house_plants` ( `id` int(11) NOT NULL AUTO_INCREMENT, `building` varchar(50) DEFAULT NULL, `stage` varchar(50) DEFAULT 'stage-a', `sort` varchar(50) DEFAULT NULL, `gender` varchar(50) DEFAULT NULL, `food` int(11) DEFAULT 100, `health` int(11) DEFAULT 100, `progress` int(11) DEFAULT 0, `coords` text DEFAULT NULL, `plantid` varchar(50) DEFAULT NULL, PRIMARY KEY (`id`), KEY `building` (`building`), KEY `plantid` (`plantid`) ) ENGINE = InnoDB AUTO_INCREMENT = 7123 DEFAULT CHARSET = utf8mb4; CREATE TABLE IF NOT EXISTS `house_meta_keys` ( ``` -------------------------------- ### Database Setup for QBCORE Framework Source: https://docs.quasar-store.com/scripts/garbage-job/installation This SQL script sets up the database for the QBCORE framework. It creates several new tables ('qs_garbagejob', 'qs_garbagejob_resets', 'qs_garbagejob_rewards', 'qs_garbagejob_leaderboard_winners') to manage garbage job-related data, including player levels, experience, earnings, and reward systems. This script is designed for environments using the QBCORE framework. ```sql CREATE TABLE IF NOT EXISTS `qs_garbagejob` ( `identifier` VARCHAR(46) NOT NULL COLLATE 'utf8mb4_general_ci', `level` INT(10) UNSIGNED NOT NULL DEFAULT '1', `experience` INT(10) UNSIGNED NOT NULL DEFAULT '0', `total_experience` INT(10) UNSIGNED NOT NULL DEFAULT '0', `total_earnings` INT(10) UNSIGNED NOT NULL DEFAULT '0', `season_experience` INT(10) UNSIGNED NOT NULL DEFAULT '0', `season_earnings` INT(10) UNSIGNED NOT NULL DEFAULT '0', `daily_experience` INT(10) UNSIGNED NOT NULL DEFAULT '0', `daily_earnings` INT(10) UNSIGNED NOT NULL DEFAULT '0', PRIMARY KEY (`identifier`) USING BTREE ) ; CREATE TABLE IF NOT EXISTS `qs_garbagejob_resets` ( `identifier` VARCHAR(46) NOT NULL COLLATE 'utf8mb4_general_ci', `last_daily_reset` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, `last_season_reset` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`identifier`) USING BTREE ) ; CREATE TABLE IF NOT EXISTS `qs_garbagejob_rewards` ( id INT AUTO_INCREMENT PRIMARY KEY, identifier VARCHAR(255) NOT NULL, reward_type VARCHAR(50) NOT NULL, reward_amount INT NOT NULL ) ; CREATE TABLE IF NOT EXISTS `qs_garbagejob_leaderboard_winners` ( id INT AUTO_INCREMENT PRIMARY KEY, position INT NOT NULL, identifier VARCHAR(255) NOT NULL, reward_amount INT NOT NULL, reward_type VARCHAR(10) NOT NULL, UNIQUE KEY (position, reward_type) ) ; ``` -------------------------------- ### Database Setup for Newspaper Job (QBCORE) Source: https://docs.quasar-store.com/scripts/newspaper-job/installation SQL statement to create the 'qs_newspaper' table for player data in a QBCORE environment. This table stores player level and experience for the newspaper job. ```sql CREATE TABLE IF NOT EXISTS `qs_newspaper` ( `identifier` VARCHAR(46) NOT NULL COLLATE 'utf8mb4_general_ci', `level` INT(10) UNSIGNED NOT NULL DEFAULT '1', `experience` INT(10) UNSIGNED NOT NULL DEFAULT '0', PRIMARY KEY (`identifier`) USING BTREE ) ; ``` -------------------------------- ### Database Setup Scripts for ESX and QBCORE Frameworks Source: https://docs.quasar-store.com/scripts/fishing-job/installation These SQL scripts are used to set up the database for the Quasar Store project. They include table creation for fishing-related data, rewards, and leaderboards, with specific adjustments for ESX and QBCORE compatibility. Ensure these are imported before running the server. ```sql INSERT INTO `jobs` (name, label) VALUES ('fisher','Fisher') ; INSERT INTO `job_grades` (job_name, grade, name, label, salary, skin_male, skin_female) VALUES ('fisher',0,'novice','Novice',10,'{}','{}') ; CREATE TABLE IF NOT EXISTS `qs_fisher` ( `identifier` VARCHAR(46) NOT NULL COLLATE 'utf8mb4_general_ci', `level` INT(10) UNSIGNED NOT NULL DEFAULT '1', `experience` INT(10) UNSIGNED NOT NULL DEFAULT '0', `total_experience` INT(10) UNSIGNED NOT NULL DEFAULT '0', `total_earnings` INT(10) UNSIGNED NOT NULL DEFAULT '0', `season_experience` INT(10) UNSIGNED NOT NULL DEFAULT '0', `season_earnings` INT(10) UNSIGNED NOT NULL DEFAULT '0', `daily_experience` INT(10) UNSIGNED NOT NULL DEFAULT '0', `daily_earnings` INT(10) UNSIGNED NOT NULL DEFAULT '0', PRIMARY KEY (`identifier`) USING BTREE ) ENGINE=InnoDB COLLATE='utf8mb4_general_ci' ; CREATE TABLE IF NOT EXISTS `qs_fisher_resets` ( `identifier` VARCHAR(46) NOT NULL COLLATE 'utf8mb4_general_ci', `last_daily_reset` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, `last_season_reset` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`identifier`) USING BTREE ) ENGINE=InnoDB COLLATE='utf8mb4_general_ci' ; CREATE TABLE IF NOT EXISTS `qs_fisher_rewards` ( id INT AUTO_INCREMENT PRIMARY KEY, identifier VARCHAR(255) NOT NULL, reward_type VARCHAR(50) NOT NULL, reward_amount INT NOT NULL ) ENGINE=InnoDB COLLATE='utf8mb4_general_ci' ; CREATE TABLE IF NOT EXISTS `qs_fisher_leaderboard_winners` ( id INT AUTO_INCREMENT PRIMARY KEY, position INT NOT NULL, identifier VARCHAR(255) NOT NULL, reward_amount INT NOT NULL, reward_type VARCHAR(10) NOT NULL, UNIQUE KEY (position, reward_type) ) ENGINE=InnoDB COLLATE='utf8mb4_general_ci' ; ``` ```sql CREATE TABLE IF NOT EXISTS `qs_fisher` ( `identifier` VARCHAR(46) NOT NULL COLLATE 'utf8mb4_general_ci', `level` INT(10) UNSIGNED NOT NULL DEFAULT '1', `experience` INT(10) UNSIGNED NOT NULL DEFAULT '0', `total_experience` INT(10) UNSIGNED NOT NULL DEFAULT '0', `total_earnings` INT(10) UNSIGNED NOT NULL DEFAULT '0', `season_experience` INT(10) UNSIGNED NOT NULL DEFAULT '0', `season_earnings` INT(10) UNSIGNED NOT NULL DEFAULT '0', `daily_experience` INT(10) UNSIGNED NOT NULL DEFAULT '0', `daily_earnings` INT(10) UNSIGNED NOT NULL DEFAULT '0', PRIMARY KEY (`identifier`) USING BTREE ) ENGINE=InnoDB COLLATE='utf8mb4_general_ci' ; CREATE TABLE IF NOT EXISTS `qs_fisher_resets` ( `identifier` VARCHAR(46) NOT NULL COLLATE 'utf8mb4_general_ci', `last_daily_reset` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, `last_season_reset` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`identifier`) USING BTREE ) ENGINE=InnoDB COLLATE='utf8mb4_general_ci' ; CREATE TABLE IF NOT EXISTS `qs_fisher_rewards` ( id INT AUTO_INCREMENT PRIMARY KEY, identifier VARCHAR(255) NOT NULL, reward_type VARCHAR(50) NOT NULL, reward_amount INT NOT NULL ) ENGINE=InnoDB COLLATE='utf8mb4_general_ci' ; CREATE TABLE IF NOT EXISTS `qs_fisher_leaderboard_winners` ( id INT AUTO_INCREMENT PRIMARY KEY, position INT NOT NULL, identifier VARCHAR(255) NOT NULL, reward_amount INT NOT NULL, reward_type VARCHAR(10) NOT NULL, UNIQUE KEY (position, reward_type) ) ENGINE=InnoDB COLLATE='utf8mb4_general_ci' ; ``` -------------------------------- ### Database Setup for Newspaper Job (ESX) Source: https://docs.quasar-store.com/scripts/newspaper-job/installation SQL statements to set up the 'jobs' and 'job_grades' tables for the Newspaper Delivery job and create the 'qs_newspaper' table for player data in an ESX environment. ```sql INSERT INTO `jobs` (name, label) VALUES ('newspaper_delivery','Newspaper Delivery') ; INSERT INTO `job_grades` (job_name, grade, name, label, salary, skin_male, skin_female) VALUES ('newspaper_delivery',0,'novice','Novice',10,'{}','{}') ; CREATE TABLE IF NOT EXISTS `qs_newspaper` ( `identifier` VARCHAR(46) NOT NULL COLLATE 'utf8mb4_general_ci', `level` INT(10) UNSIGNED NOT NULL DEFAULT '1', `experience` INT(10) UNSIGNED NOT NULL DEFAULT '0', PRIMARY KEY (`identifier`) USING BTREE ) ; ``` -------------------------------- ### Database Setup for QB Core Hunter Job Source: https://docs.quasar-store.com/scripts/hunter-job/installation SQL statement to create the 'qs_hunter' table for the QB Core framework. This table stores player identifier, level, and experience for the hunter job. ```sql CREATE TABLE IF NOT EXISTS `qs_hunter` ( `identifier` VARCHAR(46) NOT NULL COLLATE 'utf8mb4_general_ci', `level` INT(10) UNSIGNED NOT NULL DEFAULT '1', `experience` INT(10) UNSIGNED NOT NULL DEFAULT '0', PRIMARY KEY (`identifier`) USING BTREE ) ; ``` -------------------------------- ### SQL Database Setup for QBCORE Framework Source: https://docs.quasar-store.com/scripts/crafting-creator/installation This SQL script sets up the necessary database tables ('crafting_queue', 'crafting_tables') and adds a 'crafting_skill' column to the 'players' table for the QBCORE framework. It includes a stored procedure to migrate existing 'crafting_tables' by dropping 'job', 'grades', 'gang', 'gangGrades' columns and adding 'jobs', 'gangs' columns. ```sql DROP TABLE IF EXISTS `crafting_queue`; DROP TABLE IF EXISTS `crafting_tables`; CREATE TABLE IF NOT EXISTS `crafting_queue` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `owner` VARCHAR(80) NOT NULL DEFAULT '0' COLLATE 'utf8mb3_general_ci', `tableId` VARCHAR(30) NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci', `item` VARCHAR(50) NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci', `amount` INT(11) NOT NULL DEFAULT '1', `startDate` TIMESTAMP NULL DEFAULT NULL, `duration` INT(11) NULL DEFAULT NULL, `earn` INT(11) NULL DEFAULT '0', PRIMARY KEY (`id`) USING BTREE, INDEX `owner_tableId` (`owner`, `tableId`) USING BTREE ) COLLATE='utf8mb3_general_ci'; CREATE TABLE IF NOT EXISTS `crafting_tables` ( `id` INT(11) NOT NULL AUTO_INCREMENT, `creator` VARCHAR(80) NOT NULL DEFAULT '0' COLLATE 'utf8mb3_general_ci', `label` VARCHAR(50) NOT NULL DEFAULT '0' COLLATE 'utf8mb3_general_ci', `size` SMALLINT(6) NOT NULL DEFAULT '0', `job` VARCHAR(30) NULL DEFAULT '0' COLLATE 'utf8mb3_general_ci', `grades` LONGTEXT NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci', `gang` VARCHAR(30) NULL DEFAULT NULL, `gangGrades` LONGTEXT NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci', `object` VARCHAR(50) NULL DEFAULT '0' COLLATE 'utf8mb3_general_ci', `coords` LONGTEXT NOT NULL COLLATE 'utf8mb3_general_ci', `recipes` LONGTEXT NOT NULL COLLATE 'utf8mb4_bin', `blip` LONGTEXT NULL DEFAULT NULL COLLATE 'utf8mb3_general_ci', `global` TINYINT(1) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) COLLATE='utf8mb3_general_ci'; ALTER TABLE `players` ADD IF NOT EXISTS `crafting_skill` LONGTEXT NULL DEFAULT NULL; DELIMITER $$ CREATE PROCEDURE migrate_crafting_tables() BEGIN IF EXISTS ( SELECT * FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'crafting_tables' AND COLUMN_NAME = 'job' AND TABLE_SCHEMA = DATABASE() ) THEN ALTER TABLE `crafting_tables` DROP COLUMN `job`, DROP COLUMN `grades`, DROP COLUMN `gang`, DROP COLUMN `gangGrades`; ALTER TABLE `crafting_tables` ``` -------------------------------- ### Database Setup for Dog Walker Job (ESX) Source: https://docs.quasar-store.com/scripts/dog-walker-job/installation SQL statements to set up the 'dog_walker' job and its grades for the ESX framework. It also creates the 'qs_dog_walker' table to store player progression data. ```sql INSERT INTO `jobs` (name, label) VALUES ('dog_walker','Dog Walker') ; INSERT INTO `job_grades` (job_name, grade, name, label, salary, skin_male, skin_female) VALUES ('dog_walker',0,'novice','Novice',10,'{}','{}') ; CREATE TABLE IF NOT EXISTS `qs_dog_walker` ( `identifier` VARCHAR(46) NOT NULL COLLATE 'utf8mb4_general_ci', `level` INT(10) UNSIGNED NOT NULL DEFAULT '1', `experience` INT(10) UNSIGNED NOT NULL DEFAULT '0', PRIMARY KEY (`identifier`) USING BTREE ) ``` -------------------------------- ### Database Setup for QBCORE Framework Source: https://docs.quasar-store.com/scripts/lumberjack-job/installation This SQL script sets up the database for the QBCORE framework, creating tables for 'qs_lumberjack', 'qs_lumberjack_resets', 'qs_lumberjack_rewards', and 'qs_lumberjack_leaderboard_winners'. These tables manage player progress, reset timers, reward distributions, and leaderboard data for the lumberjack job. ```sql CREATE TABLE IF NOT EXISTS `qs_lumberjack` ( `identifier` VARCHAR(46) NOT NULL COLLATE 'utf8mb4_general_ci', `level` INT(10) UNSIGNED NOT NULL DEFAULT '1', `experience` INT(10) UNSIGNED NOT NULL DEFAULT '0', `total_experience` INT(10) UNSIGNED NOT NULL DEFAULT '0', `total_earnings` INT(10) UNSIGNED NOT NULL DEFAULT '0', `season_experience` INT(10) UNSIGNED NOT NULL DEFAULT '0', `season_earnings` INT(10) UNSIGNED NOT NULL DEFAULT '0', `daily_experience` INT(10) UNSIGNED NOT NULL DEFAULT '0', `daily_earnings` INT(10) UNSIGNED NOT NULL DEFAULT '0', PRIMARY KEY (`identifier`) USING BTREE ) ENGINE=InnoDB COLLATE='utf8mb4_general_ci' ; CREATE TABLE IF NOT EXISTS `qs_lumberjack_resets` ( `identifier` VARCHAR(46) NOT NULL COLLATE 'utf8mb4_general_ci', `last_daily_reset` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, `last_season_reset` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`identifier`) USING BTREE ) ENGINE=InnoDB COLLATE='utf8mb4_general_ci' ; CREATE TABLE IF NOT EXISTS `qs_lumberjack_rewards` ( id INT AUTO_INCREMENT PRIMARY KEY, identifier VARCHAR(255) NOT NULL, reward_type VARCHAR(50) NOT NULL, reward_amount INT NOT NULL ) ENGINE=InnoDB COLLATE='utf8mb4_general_ci' ; CREATE TABLE IF NOT EXISTS `qs_lumberjack_leaderboard_winners` ( id INT AUTO_INCREMENT PRIMARY KEY, position INT NOT NULL, identifier VARCHAR(255) NOT NULL, reward_amount INT NOT NULL, reward_type VARCHAR(10) NOT NULL, UNIQUE KEY (position, reward_type) ) ENGINE=InnoDB COLLATE='utf8mb4_general_ci' ; ``` -------------------------------- ### Database Setup for ESX Hunter Job Source: https://docs.quasar-store.com/scripts/hunter-job/installation SQL statements to set up the 'hunter' job and its grades for the ESX framework. It also includes the creation of the 'qs_hunter' table to store player level and experience data. ```sql INSERT INTO `jobs` (name, label) VALUES ('hunter','Hunter') ; INSERT INTO `job_grades` (job_name, grade, name, label, salary, skin_male, skin_female) VALUES ('hunter',0,'novice','Novice',10,'{}','{}') ; CREATE TABLE IF NOT EXISTS `qs_hunter` ( `identifier` VARCHAR(46) NOT NULL COLLATE 'utf8mb4_general_ci', `level` INT(10) UNSIGNED NOT NULL DEFAULT '1', `experience` INT(10) UNSIGNED NOT NULL DEFAULT '0', PRIMARY KEY (`identifier`) USING BTREE ) ; ``` -------------------------------- ### Database Setup for QBCORE Framework Source: https://docs.quasar-store.com/scripts/miner-job/installation This SQL script sets up the database for the QBCORE framework. It includes creating tables for miner stats, reset times, rewards, and leaderboard winners. This script is intended to be run with a MariaDB/MySQL compatible database manager like HeidiSQL. ```sql CREATE TABLE IF NOT EXISTS `qs_miner` ( `identifier` VARCHAR(46) NOT NULL COLLATE 'utf8mb4_general_ci', `level` INT(10) UNSIGNED NOT NULL DEFAULT '1', `experience` INT(10) UNSIGNED NOT NULL DEFAULT '0', `total_experience` INT(10) UNSIGNED NOT NULL DEFAULT '0', `total_earnings` INT(10) UNSIGNED NOT NULL DEFAULT '0', `season_experience` INT(10) UNSIGNED NOT NULL DEFAULT '0', `season_earnings` INT(10) UNSIGNED NOT NULL DEFAULT '0', `daily_experience` INT(10) UNSIGNED NOT NULL DEFAULT '0', `daily_earnings` INT(10) UNSIGNED NOT NULL DEFAULT '0', PRIMARY KEY (`identifier`) USING BTREE ) ENGINE=InnoDB COLLATE='utf8mb4_general_ci' ; CREATE TABLE IF NOT EXISTS `qs_miner_resets` ( `identifier` VARCHAR(46) NOT NULL COLLATE 'utf8mb4_general_ci', `last_daily_reset` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, `last_season_reset` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`identifier`) USING BTREE ) ENGINE=InnoDB COLLATE='utf8mb4_general_ci' ; CREATE TABLE IF NOT EXISTS `qs_miner_rewards` ( id INT AUTO_INCREMENT PRIMARY KEY, identifier VARCHAR(255) NOT NULL, reward_type VARCHAR(50) NOT NULL, reward_amount INT NOT NULL ) ENGINE=InnoDB COLLATE='utf8mb4_general_ci' ; CREATE TABLE IF NOT EXISTS `qs_miner_leaderboard_winners` ( id INT AUTO_INCREMENT PRIMARY KEY, position INT NOT NULL, identifier VARCHAR(255) NOT NULL, reward_amount INT NOT NULL, reward_type VARCHAR(10) NOT NULL, UNIQUE KEY (position, reward_type) ) ENGINE=InnoDB COLLATE='utf8mb4_general_ci' ; ``` -------------------------------- ### Database Setup for ESX - Treasure Hunter Job and Player Data Source: https://docs.quasar-store.com/scripts/treasure-hunting/installation This SQL script sets up the 'treasure_hunter' job and its grades for the ESX framework. It also creates the 'qs_treasure_hunter' table to store player level and experience data, essential for progression in the game. ```sql INSERT INTO `jobs` (name, label) VALUES ('treasure_hunter','Treasure Hunter') ; INSERT INTO `job_grades` (job_name, grade, name, label, salary, skin_male, skin_female) VALUES ('treasure_hunter',0,'novice','Novice',10,'{}','{}') ; CREATE TABLE IF NOT EXISTS `qs_treasure_hunter` ( `identifier` VARCHAR(46) NOT NULL COLLATE 'utf8mb4_general_ci', `level` INT(10) UNSIGNED NOT NULL DEFAULT '1', `experience` INT(10) UNSIGNED NOT NULL DEFAULT '0', PRIMARY KEY (`identifier`) USING BTREE ) ENGINE=InnoDB COLLATE='utf8mb4_general_ci' ; ```