đ ī¸Installation
1. Run the SQL:
CREATE TABLE IF NOT EXISTS `m_blackmarket` (
`name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
`price` decimal(10,2) NOT NULL,
`label` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
`stock` int NOT NULL,
`experience` int DEFAULT NULL,
`category` varchar(50) COLLATE utf8mb4_general_ci DEFAULT NULL,
PRIMARY KEY (`name`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
INSERT INTO `m_blackmarket` (`name`, `price`, `label`, `stock`, `experience`, `category`) VALUES
('advancedlockpick', 250.00, 'Advanced Lockpick', 3, 0, 'general'),
('lockpick', 500.00, 'Lockpick', 1, 0, 'general'),
('weapon_assaultrifle', 50000.00, 'Assaultrifle', 7, 674, 'guns'),
('weapon_battleaxe', 25000.00, 'Battleaxe', 4, 123, 'guns'),
('weapon_pistol', 35000.00, 'Pistol', 4, 455, 'guns');
CREATE TABLE IF NOT EXISTS `m_blackmarket_xp` (
`id` varchar(55) COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'AUTO_INCREMENT',
`experience` int DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
Last updated