Spaces:
Sleeping
Sleeping
| 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) | |
| ); | |