Inventory System Installation
CREATE TABLE IF NOT EXISTS `stashdata` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`typeofdata` varchar(15) NOT NULL,
`stashname` varchar(50) NOT NULL,
`stashmaxweight` varchar(50) NOT NULL,
`uniqeid` varchar(50) NOT NULL,
PRIMARY KEY (`id`)
)ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
CREATE TABLE IF NOT EXISTS `stashdataitems` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`uniqeid` varchar(50) NOT NULL,
`typeofdata` varchar(50) NOT NULL,
`itemname` varchar(50) NOT NULL,
`itemlabel` varchar(50) NOT NULL,
`itemcount` varchar(50) NOT NULL,
PRIMARY KEY (`id`)
)ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci ROW_FORMAT=DYNAMIC;
INSERT INTO `items`(name, label, `weight`, `rare`, `can_remove`) VALUES
("bread", "Bread", 1, 1 ,2),
("cheeseburger", "Cheese Burger", 1, 1 ,2),
("cheese", "Cheese", 1, 1 ,2),
("paper", "Paper", 1, 1 ,2),
("weed", "Weed", 1, 1 ,2),
("filter", "Filter", 1, 1 ,2),
("doener", "Doenner", 1, 1 ,2),
("salat", "Salat", 1, 1 ,2);
Thats All! Enjoy the Script on your Server!