βοΈInstallation
Steps to follow to install the script
1 - DATABASE
CREATE TABLE IF NOT EXISTS `businesses_decorations` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`data` longtext DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
CREATE TABLE IF NOT EXISTS `created_businesses` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`business_info` longtext DEFAULT NULL,
`business_data` longtext DEFAULT NULL,
`business_items` longtext DEFAULT NULL,
`business_logs` text DEFAULT NULL,
`business_jobs` longtext DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
CREATE TABLE IF NOT EXISTS `businesses_lonja_types` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`data` longtext DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
CREATE TABLE IF NOT EXISTS `businesses_types` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`data` longtext DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
CREATE TABLE IF NOT EXISTS `businesses_workbenches` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`data` longtext DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
CREATE TABLE IF NOT EXISTS `business_outfits` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`business` varchar(60) NOT NULL,
`label` longtext DEFAULT NULL,
`ped` longtext DEFAULT NULL,
`components` longtext DEFAULT NULL,
`props` longtext DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `id_UNIQUE` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb3 COLLATE=utf8mb3_general_ci;
-- ONLY FOR ESX DEFAULT INVENTORY
-- ONLY FOR ESX DEFAULT INVENTORY
CREATE TABLE business_stashes (
id INT AUTO_INCREMENT PRIMARY KEY,
name varchar(255),
items LONGTEXT
);2 - INTEGRATIONS
qb-inventory
qb-inventoryqb-clothing
qb-clothingVehicle fuel
Vehicle fuelPlayer outfits
Player outfits3 - CFG
Last updated