-- WZAuth Painel do Cliente V1
-- Execute APÓS sql/migration_admin_v1.sql.
-- Não apaga nenhuma tabela ou dado existente.

CREATE TABLE IF NOT EXISTS portal_activity_logs (
    id BIGINT UNSIGNED AUTO_INCREMENT PRIMARY KEY,
    customer_id INT UNSIGNED NOT NULL,
    license_id INT UNSIGNED NULL,
    action VARCHAR(60) NOT NULL,
    details VARCHAR(500) NOT NULL DEFAULT '',
    ip VARCHAR(45) NOT NULL DEFAULT '',
    created_at DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
    INDEX idx_portal_customer (customer_id),
    INDEX idx_portal_license (license_id),
    INDEX idx_portal_created (created_at),
    CONSTRAINT fk_portal_activity_customer FOREIGN KEY (customer_id) REFERENCES customers(id) ON DELETE CASCADE,
    CONSTRAINT fk_portal_activity_license FOREIGN KEY (license_id) REFERENCES licenses(id) ON DELETE SET NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;