-- WZAuth V1.2 - Estado operacional das licenças
-- Execute APÓS migration_admin_v1.sql e migration_client_v1.sql.
-- Não remove nem altera dados existentes.

CREATE TABLE IF NOT EXISTS license_runtime_state (
    license_id INT UNSIGNED NOT NULL PRIMARY KEY,
    machine_id VARCHAR(255) NOT NULL DEFAULT '',
    app_version VARCHAR(50) NOT NULL DEFAULT '',
    last_ip VARCHAR(45) NOT NULL DEFAULT '',
    last_seen_at DATETIME NULL,
    auth_count BIGINT UNSIGNED NOT NULL DEFAULT 0,
    updated_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
    INDEX idx_runtime_seen (last_seen_at),
    INDEX idx_runtime_version (app_version),
    CONSTRAINT fk_runtime_license FOREIGN KEY (license_id) REFERENCES licenses(id) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;