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