-- Repair Kit System Database Schema
-- Compatible with both QB-Core and ESX frameworks

-- Table for tracking vehicle damage states (optional)
CREATE TABLE IF NOT EXISTS `vehicle_damage` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `plate` varchar(20) NOT NULL,
    `engine_health` float DEFAULT 1000.0,
    `body_health` float DEFAULT 1000.0,
    `last_updated` timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    `owner` varchar(50) DEFAULT NULL,
    PRIMARY KEY (`id`),
    UNIQUE KEY `plate` (`plate`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- Table for repair kit usage logs (optional)
CREATE TABLE IF NOT EXISTS `repairkit_logs` (
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `player_id` varchar(50) NOT NULL,
    `player_name` varchar(100) NOT NULL,
    `vehicle_plate` varchar(20) NOT NULL,
    `vehicle_model` varchar(50) DEFAULT NULL,
    `engine_health_before` float DEFAULT NULL,
    `body_health_before` float DEFAULT NULL,
    `repair_time` timestamp DEFAULT CURRENT_TIMESTAMP,
    `location` varchar(100) DEFAULT NULL,
    PRIMARY KEY (`id`),
    KEY `player_id` (`player_id`),
    KEY `repair_time` (`repair_time`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- Insert repair kit item for QB-Core (if using qb-core items table)
-- INSERT IGNORE INTO `items` (`name`, `label`, `weight`, `rare`, `can_remove`) 
-- VALUES ('repairkit', 'Fahrzeug Reparaturkit', 500, 0, 1);

-- Insert repair kit item for ESX (if using esx items table)
-- INSERT IGNORE INTO `items` (`name`, `label`, `weight`, `rare`, `can_remove`) 
-- VALUES ('repairkit', 'Fahrzeug Reparaturkit', 5, 0, 1);
