SQL
SQL runs automatically, but if it doesn't start automatically, use this code.
CREATE TABLE IF NOT EXISTS `crafting_stations` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`player_id` varchar(50) NOT NULL,
`location_id` varchar(50) NOT NULL,
`blueprint_id` varchar(50) DEFAULT NULL,
`upgrade_type` varchar(50) DEFAULT NULL,
`upgrade_level` int(11) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `unique_blueprint` (`player_id`, `location_id`, `blueprint_id`),
UNIQUE KEY `unique_upgrade` (`player_id`, `location_id`, `upgrade_type`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;
Last updated