CREATE TABLE `registro` (
  `id` int PRIMARY KEY,
  `uid` varchar(255),
  `display_name` varchar(255),
  `pais` varchar(255),
  `correo` varchar(255),
  `fecha_registro` datetime,
  `usos` integer,
  `prompt` varchar(255),
  `prompt_type` varchar(255),
  `prompt_eval` varchar(255),
  `estilo` varchar(255),
  `estilo_agregado` varchar(255),
  `calificacion` int,
  `proveedor` varchar(255),
  `seed` int,
  `created_at` timestamp
);

CREATE TABLE `actions` (
  `id` int AUTO_INCREMENT PRIMARY KEY,
  `usuario` varchar(255) UNIQUE,
  `uid` varchar(255),
  `displayName` varchar(255),
  `email` varchar(255),
  `action_call` boolean,
  `trigger_action` varchar(255),
  `country_header` varchar(10),
  `country_ip` varchar(10),
  `creditos` int,
  `esta_hora` int,
  `explicit_counter` int,
  `fecha_registro` datetime,
  `gaClient` varchar(255),
  `open_use` boolean,
  `ritmo` decimal(10,2),
  `streak` int,
  `ultima_generacion_hora` datetime,
  `ultimo_uso` datetime,
  `usos` int,
  `created_at` timestamp DEFAULT CURRENT_TIMESTAMP,
  `updated_at` timestamp DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
);

CREATE TABLE `funel_compra` (
  `id` int AUTO_INCREMENT PRIMARY KEY,
  `usuario` varchar(255) NOT NULL,
  `mail` varchar(255) NOT NULL,
  `accion` varchar(255) NOT NULL,
  `created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  INDEX idx_usuario (usuario),
  INDEX idx_mail (mail),
  INDEX idx_accion (accion),
  INDEX idx_created_at (created_at)
);