-- ============================================================
-- Global Gemini token prices
-- scripts/Version20261019203000_chatbot_ai_price_up.sql
--
-- Equivalente a: migrations/Version20261019203000.php
-- Un solo precio para todas las empresas, en chatbot_ai_price.
-- Si un intento anterior dejó los precios en chatbot_configuration,
-- este script los quita.
-- ============================================================

SET NAMES utf8mb4;

CREATE TABLE IF NOT EXISTS `chatbot_ai_price` (
    `id` INT NOT NULL,
    `input_token_price_per_million` DECIMAL(12, 6) NOT NULL DEFAULT '0.000000',
    `output_token_price_per_million` DECIMAL(12, 6) NOT NULL DEFAULT '0.000000',
    `updated_at` DATETIME DEFAULT NULL,
    PRIMARY KEY (`id`)
) DEFAULT CHARACTER SET utf8mb4 COLLATE `utf8mb4_unicode_ci` ENGINE = InnoDB;

INSERT INTO `chatbot_ai_price` (`id`, `input_token_price_per_million`, `output_token_price_per_million`)
SELECT 1, '0.000000', '0.000000'
WHERE NOT EXISTS (SELECT 1 FROM `chatbot_ai_price` WHERE `id` = 1);