-- CESTÃO VALENÇA — FASES 103 A 105
-- Rastreamento real do entregador.
-- Não altera config/database.php.

SET NAMES utf8mb4;

CREATE TABLE IF NOT EXISTS delivery_live_locations (
    id BIGINT UNSIGNED NOT NULL AUTO_INCREMENT,
    assignment_id BIGINT UNSIGNED NOT NULL,
    order_id BIGINT UNSIGNED NOT NULL,
    driver_id BIGINT UNSIGNED NOT NULL,
    latitude DECIMAL(10,7) NOT NULL,
    longitude DECIMAL(10,7) NOT NULL,
    accuracy_m DECIMAL(8,2) NULL,
    updated_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
    PRIMARY KEY (id),
    UNIQUE KEY uq_delivery_live_assignment (assignment_id),
    KEY idx_delivery_live_order (order_id),
    KEY idx_delivery_live_driver (driver_id),
    KEY idx_delivery_live_updated (updated_at)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;