Installation
Dependencies
es_extended or qb-core
Installation
2
SQL
ESX version ⬇️
DROP TABLE IF EXISTS `drug_levels`;
CREATE TABLE `drug_levels` (
`identifier` varchar(46) DEFAULT NULL,
`xp` int(11) NOT NULL,
`level` int(11) NOT NULL,
UNIQUE KEY `unique_identifier` (`identifier`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
DROP TABLE IF EXISTS `drug_machines`;
CREATE TABLE `drug_machines` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`model` varchar(64) NOT NULL,
`entity` varchar(64) NOT NULL,
`coords` longtext NOT NULL,
`heading` float NOT NULL,
`identifier` varchar(64) DEFAULT NULL,
`items` longtext DEFAULT NULL,
`money` int(11) DEFAULT 0,
`xp` int(11) DEFAULT 0,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
QB Core version ⬇️
DROP TABLE IF EXISTS `drug_levels`;
CREATE TABLE `drug_levels` (
`citizenid` varchar(46) DEFAULT NULL,
`xp` int(11) NOT NULL,
`level` int(11) NOT NULL,
UNIQUE KEY `unique_citizenid` (`citizenid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
DROP TABLE IF EXISTS `drug_machines`;
CREATE TABLE `drug_machines` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`model` varchar(64) NOT NULL,
`entity` varchar(64) NOT NULL,
`coords` longtext NOT NULL,
`heading` float NOT NULL,
`citizenid` varchar(64) DEFAULT NULL,
`items` longtext DEFAULT NULL,
`money` int(11) DEFAULT 0,
`xp` int(11) DEFAULT 0,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
Item
Image
Name
Label
Last updated