SQL

If you are upgrading from v1.x. Please also run this new query provided below:

ALTER TABLE weed_plants
DROP COLUMN maleseeds;

That will help you remove all strain information for maleseed

---

Run the SQL provided in your package, should be as below:

qb-core or qbx_core:

CREATE TABLE IF NOT EXISTS `weed_plants` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`timestamp` varchar(255) DEFAULT NULL,
`citizenid` varchar(255) DEFAULT NULL,
`x` varchar(255) DEFAULT NULL,
`y` varchar(255) DEFAULT NULL,
`z` varchar(255) DEFAULT NULL,
`gender` int(1) DEFAULT 0,
`water` float(2) DEFAULT 10,
`strain` text DEFAULT NULL,
`harvest` int(1) DEFAULT 0,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4;

CREATE TABLE IF NOT EXISTS `strain` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`owner` varchar(255) DEFAULT NULL,
`name` varchar(255) DEFAULT NULL,
`n` int(2) DEFAULT 0,
`p` int(2) DEFAULT 0,
`k` int(2) DEFAULT 0,
`rep` int(2) DEFAULT 0,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4;

esx:

CREATE TABLE IF NOT EXISTS `weed_plants` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`timestamp` varchar(255) DEFAULT NULL,
`citizenid` varchar(255) DEFAULT NULL,
`x` varchar(255) DEFAULT NULL,
`y` varchar(255) DEFAULT NULL,
`z` varchar(255) DEFAULT NULL,
`gender` int(1) DEFAULT 0,
`water` float(2) DEFAULT 10,
`strain` text DEFAULT NULL,
`harvest` int(1) DEFAULT 0,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4;

CREATE TABLE IF NOT EXISTS `strain` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`owner` varchar(255) DEFAULT NULL,
`name` varchar(255) DEFAULT NULL,
`n` int(2) DEFAULT 0,
`p` int(2) DEFAULT 0,
`k` int(2) DEFAULT 0,
`rep` int(2) DEFAULT 0,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4;

ALTER TABLE `users` ADD COLUMN `strainrep` int(2) DEFAULT 0;