-- Active: 1754444322322@@dev.io@3306@nucleo_base
-- https://www.phpmyadmin.net/
--
-- Servidor: localhost
-- Tiempo de generación: 15-12-2025 a las 22:19:54
-- Versión del servidor: 8.0.44-0ubuntu0.24.04.2
-- Versión de PHP: 8.3.28

START TRANSACTION;



--
-- Disparadores `ai_responses`
--
DELIMITER $$
DELIMITER ;
DELIMITER $$
DELIMITER ;
DELIMITER $$
DELIMITER ;
DELIMITER $$

--
-- Eventos
--
CREATE DEFINER=`dev`@`%` EVENT `mod_crm_evt_update_overdue_activities` ON SCHEDULE EVERY 1 HOUR STARTS '2025-10-25 16:35:40' ON COMPLETION NOT PRESERVE ENABLE DO BEGIN
    UPDATE mod_crm_activities
    SET mod_crm_act_status = 'overdue'
    WHERE mod_crm_act_due_date < NOW()
    AND mod_crm_act_status = 'pending';
END$$
DELIMITER ;

COMMIT;

CREATE TRIGGER `ai_responses_delete` AFTER DELETE ON `ai_responses` FOR EACH ROW BEGIN
    INSERT INTO ai_responses_history
    SELECT OLD.*, 'DELETE', NOW();
END
$$
CREATE TRIGGER `ai_responses_insert` AFTER INSERT ON `ai_responses` FOR EACH ROW BEGIN
    INSERT INTO ai_responses_history
    SELECT NEW.*, 'INSERT', NOW();
END
$$
CREATE TRIGGER `ai_responses_update` AFTER UPDATE ON `ai_responses` FOR EACH ROW BEGIN
    INSERT INTO ai_responses_history
    SELECT NEW.*, 'UPDATE', NOW();
END
$$

--
-- Base de datos: `nucleo_base`
----------------------------------------------

--
-- Estructura de tabla para la tabla `ai_categories`
--

CREATE TABLE `ai_categories` (
  `ai_cat_id` int NOT NULL,
  `ai_cat_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `ai_cat_ent_id` int NOT NULL,
  `ai_cat_state` int DEFAULT '0' COMMENT '0=active, 1=archived, 2=deleted',
  `ai_cat_create_user_id` int DEFAULT NULL COMMENT 'Usuario que creó el registro'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Volcado de datos para la tabla `ai_categories`
--

INSERT INTO `ai_categories` (`ai_cat_id`, `ai_cat_name`, `ai_cat_ent_id`, `ai_cat_state`, `ai_cat_create_user_id`) VALUES
(1, 'support', 1, 0, NULL),
(2, 'sales', 1, 0, NULL),
(3, 'inventory', 1, 0, NULL),
(4, 'other', 1, 0, NULL);

--
-- Índices para tablas volcadas
--

--
-- Indices de la tabla `ai_categories`
--
ALTER TABLE `ai_categories`
  ADD PRIMARY KEY (`ai_cat_id`) USING BTREE,
  ADD UNIQUE KEY `ai_cat_name` (`ai_cat_name`) USING BTREE;

--
-- AUTO_INCREMENT de las tablas volcadas
--

--
-- AUTO_INCREMENT de la tabla `ai_categories`
--
ALTER TABLE `ai_categories`
  MODIFY `ai_cat_id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=5;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `ai_categorys`
--

CREATE TABLE `ai_categorys` (
  `ai_cat_id` int NOT NULL,
  `ai_cat_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `ai_cat_ent_id` int NOT NULL,
  `ai_cat_state` int DEFAULT '0' COMMENT '0=active, 1=archived, 2=deleted',
  `ai_cat_create_user_id` int DEFAULT NULL COMMENT 'Usuario que creó el registro'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Indices de la tabla `ai_categorys`
--
ALTER TABLE `ai_categorys`
  ADD PRIMARY KEY (`ai_cat_id`) USING BTREE,
  ADD UNIQUE KEY `ai_cat_name` (`ai_cat_name`) USING BTREE;

--
-- AUTO_INCREMENT de la tabla `ai_categorys`
--
ALTER TABLE `ai_categorys`
  MODIFY `ai_cat_id` int NOT NULL AUTO_INCREMENT;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `ai_keys`
--

CREATE TABLE `ai_keys` (
  `ai_key_id` int NOT NULL,
  `ai_key_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `ai_key_value` varbinary(255) NOT NULL,
  `ai_key_provider` enum('OpenAI','Azure','Google','Other') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT 'OpenAI',
  `ai_key_created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `ai_key_updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `ai_key_ent_id` int NOT NULL,
  `ai_key_state` int DEFAULT '0' COMMENT '0=active, 1=archived, 2=deleted',
  `ai_key_create_user_id` int DEFAULT NULL COMMENT 'Usuario que creó el registro'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Indices de la tabla `ai_keys`
--
ALTER TABLE `ai_keys`
  ADD PRIMARY KEY (`ai_key_id`) USING BTREE,
  ADD UNIQUE KEY `ai_key_name` (`ai_key_name`) USING BTREE,
  ADD KEY `idx_provider` (`ai_key_provider`) USING BTREE;

--
-- AUTO_INCREMENT de la tabla `ai_keys`
--
ALTER TABLE `ai_keys`
  MODIFY `ai_key_id` int NOT NULL AUTO_INCREMENT;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `ai_logs`
--

CREATE TABLE `ai_logs` (
  `ai_log_id` int NOT NULL,
  `ai_log_user_id` int DEFAULT NULL,
  `ai_log_prompt_id` int NOT NULL,
  `ai_log_response_id` int NOT NULL,
  `ai_log_execution_time` float DEFAULT NULL,
  `ai_log_status` enum('success','error','pending') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT 'success',
  `ai_log_error_details` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `ai_log_request_metadata` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin,
  `ai_log_created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `ai_log_ent_id` int NOT NULL,
  `ai_log_state` int DEFAULT '0' COMMENT '0=active, 1=archived, 2=deleted'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Indices de la tabla `ai_logs`
--
ALTER TABLE `ai_logs`
  ADD PRIMARY KEY (`ai_log_id`) USING BTREE,
  ADD KEY `idx_fechas` (`ai_log_created_at`) USING BTREE;

--
-- AUTO_INCREMENT de la tabla `ai_logs`
--
ALTER TABLE `ai_logs`
  MODIFY `ai_log_id` int NOT NULL AUTO_INCREMENT;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `ai_module_relations`
--

CREATE TABLE `ai_module_relations` (
  `ai_mod_rel_id` int NOT NULL,
  `ai_mod_rel_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `ai_mod_rel_feature` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `ai_mod_rel_created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `ai_mod_rel_updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `ai_mod_rel_mod_id` int NOT NULL,
  `ai_mod_rel_ent_id` int NOT NULL,
  `ai_mod_rel_json` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin,
  `ai_mod_rel_state` int DEFAULT '0' COMMENT '0=active, 1=archived, 2=deleted',
  `ai_mod_rel_create_user_id` int DEFAULT NULL COMMENT 'Usuario que creó el registro'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Indices de la tabla `ai_module_relations`
--
ALTER TABLE `ai_module_relations`
  ADD PRIMARY KEY (`ai_mod_rel_id`) USING BTREE;

--
-- AUTO_INCREMENT de la tabla `ai_module_relations`
--
ALTER TABLE `ai_module_relations`
  MODIFY `ai_mod_rel_id` int NOT NULL AUTO_INCREMENT;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `ai_prompts`
--

CREATE TABLE `ai_prompts` (
  `ai_prt_id` int NOT NULL,
  `ai_prt_text` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `ai_prt_cat_id` int NOT NULL,
  `ai_prt_created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `ai_prt_updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `ai_prt_ent_id` int NOT NULL,
  `ai_prt_state` int DEFAULT '0' COMMENT '0=active, 1=archived, 2=deleted',
  `ai_prt_create_user_id` int DEFAULT NULL COMMENT 'Usuario que creó el registro'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Volcado de datos para la tabla `ai_prompts`
--

INSERT INTO `ai_prompts` (`ai_prt_id`, `ai_prt_text`, `ai_prt_cat_id`, `ai_prt_created_at`, `ai_prt_updated_at`, `ai_prt_ent_id`, `ai_prt_state`, `ai_prt_create_user_id`) VALUES
(1, 'Actúa como un escritor de un periódico líder en periodismo digital, con un estilo similar al de Jorge Ramos (México). Reescribe el siguiente titular con un enfoque atractivo y efectivo para aumentar el tráfico y la interacción en nuestro sitio web.\n\nRequisitos:\n	•	Mantén el tono profesional, confiable y riguroso de un medio de noticias de primer nivel.\n	•	Crea títulos con ganchos llamativos que despierten curiosidad, sin perder precisión ni caer en la exageración.\n	•	Adapta el lenguaje para un público digital, asegurando claridad, rapidez e interés visual.\n	•	Destaca la relevancia de la noticia y su impacto en la audiencia, sin descontextualizar la información.\n	•	Asegura que la llamada a la acción motive al usuario a hacer clic e interactuar.\n\nTitular original: {{_TITLE}}\n\nGenera 5 opciones que cumplan con estos criterios, válido con la siguiente estructura: \"{\"respuesta 1\",\"respuesta 2\",\"respuesta 3\",\"respuesta 4\",\"respuesta 5\"}\"', 0, '2025-03-20 00:13:51', '2025-03-20 21:06:16', 1, 1, 1),
(2, 'Actúa como un periodista de un medio digital de primer nivel, con un estilo similar al de Jorge Ramos (México). Resume la siguiente nota de manera atractiva y efectiva para aumentar el tráfico y la interacción en nuestro sitio web.\n\nRequisitos:\n•Tono profesional y riguroso, asegurando la confiabilidad del medio.\n•Resumen conciso y llamativo, sin perder precisión ni contexto.\n•Lenguaje adaptado para el público digital, asegurando claridad e impacto.\n•Enfoque en la relevancia de la noticia, destacando su importancia para la audiencia.\n•Mantener el interés del lector, asegurando que quiera seguir explorando la información.\n\nTitulo original: {{_TITLE}}\nResumen original: {{_SUMMARY}}\n\nGenera 3 opciones de resumen que cumplan con estos criterios, devuélveme un JSON válido con la siguiente estructura:\n{\"respuesta 1\",\"respuesta 2\",\"respuesta 3\"}', 0, '2025-03-20 16:41:24', '2025-03-20 21:05:48', 1, 1, 1);

--
-- Indices de la tabla `ai_prompts`
--
ALTER TABLE `ai_prompts`
  ADD PRIMARY KEY (`ai_prt_id`) USING BTREE,
  ADD KEY `idx_entidad` (`ai_prt_ent_id`) USING BTREE;

--
-- AUTO_INCREMENT de la tabla `ai_prompts`
--
ALTER TABLE `ai_prompts`
  MODIFY `ai_prt_id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `ai_responses`
--

CREATE TABLE `ai_responses` (
  `ai_rsp_id` int NOT NULL,
  `ai_rsp_prompt_id` int NOT NULL,
  `ai_rsp_text` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `ai_rsp_model_used` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT 'GPT-4',
  `ai_rsp_confidence_score` decimal(5,2) DEFAULT NULL,
  `ai_rsp_created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `ai_rsp_updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `ai_rsp_ent_id` int NOT NULL,
  `ai_rsp_state` int DEFAULT '0' COMMENT '0=active, 1=archived, 2=deleted',
  `ai_rsp_create_user_id` int DEFAULT NULL COMMENT 'Usuario que creó el registro'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Indices de la tabla `ai_responses`
--
ALTER TABLE `ai_responses`
  ADD PRIMARY KEY (`ai_rsp_id`) USING BTREE,
  ADD KEY `idx_prompt` (`ai_rsp_prompt_id`) USING BTREE;

--
-- AUTO_INCREMENT de la tabla `ai_responses`
--
ALTER TABLE `ai_responses`
  MODIFY `ai_rsp_id` int NOT NULL AUTO_INCREMENT;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `ai_responses_history`
--

CREATE TABLE `ai_responses_history` (
  `ai_rsp_id` int NOT NULL,
  `ai_rsp_prompt_id` int NOT NULL,
  `ai_rsp_text` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `ai_rsp_model_used` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT 'GPT-4',
  `ai_rsp_confidence_score` decimal(5,2) DEFAULT NULL,
  `ai_rsp_created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `ai_rsp_updated_at` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
  `ai_rsp_ent_id` int NOT NULL,
  `ai_rsp_state` int DEFAULT '0',
  `operation_type` enum('INSERT','UPDATE','DELETE') CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `operation_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Indices de la tabla `ai_responses_history`
--
ALTER TABLE `ai_responses_history`
  ADD PRIMARY KEY (`ai_rsp_id`) USING BTREE,
  ADD KEY `idx_prompt_id` (`ai_rsp_prompt_id`) USING BTREE,
  ADD KEY `idx_ent_id` (`ai_rsp_ent_id`) USING BTREE,
  ADD KEY `idx_operation_time` (`operation_time`) USING BTREE;

--
-- AUTO_INCREMENT de la tabla `ai_responses_history`
--
ALTER TABLE `ai_responses_history`
  MODIFY `ai_rsp_id` int NOT NULL AUTO_INCREMENT;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `blocks`
--

CREATE TABLE `blocks` (
  `block_id` int NOT NULL,
  `block_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `block_class` varchar(44) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `block_order` int DEFAULT NULL,
  `block_parent_id` int NOT NULL,
  `block_ent_id` int NOT NULL DEFAULT '0',
  `block_state` int NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Volcado de datos para la tabla `blocks`
--

INSERT INTO `blocks` (`block_id`, `block_name`, `block_class`, `block_order`, `block_parent_id`, `block_ent_id`, `block_state`) VALUES
(1, 'Header', 'headerPage', 1, 0, 1, 1),
(2, 'Body', 'bodyPage', 2, 0, 1, 1),
(3, 'Footer', 'footerPage', 3, 0, 1, 1),
(4, 'Aside', 'asidePage', 2, 2, 1, 0),
(9, 'Aside Fluid', 'asideFluid', 1, 4, 1, 0);

--
-- Indices de la tabla `blocks`
--
ALTER TABLE `blocks`
  ADD PRIMARY KEY (`block_id`) USING BTREE;

--
-- AUTO_INCREMENT de la tabla `blocks`
--
ALTER TABLE `blocks`
  MODIFY `block_id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `categorys`
--

CREATE TABLE `categorys` (
  `cat_id` int NOT NULL,
  `cat_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `cat_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `cat_pathurl` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `cat_description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `cat_order` int DEFAULT NULL,
  `cat_parent_id` int DEFAULT '0',
  `cat_related` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `cat_icon` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `cat_color` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `cat_img` int DEFAULT NULL,
  `cat_banner` int DEFAULT NULL,
  `cat_ent_id` int DEFAULT NULL,
  `cat_configpath` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `cat_cls` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `cat_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `cat_state_collapse` int NOT NULL DEFAULT '1',
  `cat_site_id` int NOT NULL DEFAULT '1',
  `cat_state` int NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Volcado de datos para la tabla `categorys`
--

INSERT INTO `categorys` (`cat_id`, `cat_name`, `cat_path`, `cat_pathurl`, `cat_description`, `cat_order`, `cat_parent_id`, `cat_related`, `cat_icon`, `cat_color`, `cat_img`, `cat_banner`, `cat_ent_id`, `cat_configpath`, `cat_cls`, `cat_json`, `cat_state_collapse`, `cat_site_id`, `cat_state`) VALUES
(1, 'Home', 'home', 'home', '', 0, 0, '', '', '', 0, 0, 1, '', '', '', 1, 1, 1),
(3, 'Contact', 'contact', 'contact', 'Contact category', 4, 0, '', '', '', 0, 0, 1, '', '', '', 1, 1, 1),
(2, 'Productos', 'productos', 'productos', '', 1, 0, '', '', '', 0, 0, 1, '', '', '', 1, 1, 1),
(4, 'Dormitorio', 'dormitorio', 'dormitorio', '', 1, 2, '', '', '', 0, 0, 1, '', '', '', 1, 1, 1),
(5, 'Cocina', 'cocina', 'cocina', '', 2, 2, '', '', '', 0, 0, 1, '', '', '', 1, 1, 1),
(6, 'Oficina', 'oficina', 'oficina', '', 3, 2, '', '', '', 0, 0, 1, '', '', '', 1, 1, 1),
(7, 'Tecnología', 'tecnologia', 'tecnologia', '', 4, 2, '', '', '', 0, 0, 1, '', '', '', 1, 1, 1);

--
-- Indices de la tabla `categorys`
--
ALTER TABLE `categorys`
  ADD PRIMARY KEY (`cat_id`) USING BTREE;

--
-- AUTO_INCREMENT de la tabla `categorys`
--
ALTER TABLE `categorys`
  MODIFY `cat_id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=8;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `categorys_files`
--

CREATE TABLE `categorys_files` (
  `cat_file_file_id` int NOT NULL,
  `cat_file_cat_id` int NOT NULL,
  `cat_file_order` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Indices de la tabla `categorys_files`
--
ALTER TABLE `categorys_files`
  ADD PRIMARY KEY (`cat_file_file_id`,`cat_file_cat_id`) USING BTREE;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `contents`
--

CREATE TABLE `contents` (
  `cont_id` int NOT NULL,
  `cont_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `cont_pathurl` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `cont_summary` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `cont_tags` varchar(300) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `cont_img` int DEFAULT NULL,
  `cont_body` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `cont_author` int DEFAULT NULL,
  `cont_register_date` datetime DEFAULT NULL,
  `cont_user_id` int DEFAULT NULL COMMENT 'user register',
  `cont_notitle` int DEFAULT '0',
  `cont_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `cont_btn_title` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `cont_icon` varchar(21) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `cont_target` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '_blank',
  `cont_cls` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'css class',
  `cont_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `cont_state` int NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Indices de la tabla `contents`
--
ALTER TABLE `contents`
  ADD PRIMARY KEY (`cont_id`) USING BTREE;

--
-- AUTO_INCREMENT de la tabla `contents`
--
ALTER TABLE `contents`
  MODIFY `cont_id` int NOT NULL AUTO_INCREMENT;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `contents_categorys`
--

CREATE TABLE `contents_categorys` (
  `cont_cat_cont_id` int NOT NULL,
  `cont_cat_cat_id` int NOT NULL,
  `cont_cat_ent_id` int DEFAULT NULL,
  `cont_cat_order` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Indices de la tabla `contents_categorys`
--
ALTER TABLE `contents_categorys`
  ADD PRIMARY KEY (`cont_cat_cont_id`,`cont_cat_cat_id`) USING BTREE;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `contents_files`
--

CREATE TABLE `contents_files` (
  `cont_file_cont_id` int NOT NULL,
  `cont_file_file_id` int NOT NULL,
  `cont_file_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `cont_file_summary` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `cont_file_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `cont_file_btn_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `cont_file_icon` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `cont_file_target` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '_blank',
  `cont_file_order` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Indices de la tabla `contents_files`
--
ALTER TABLE `contents_files`
  ADD PRIMARY KEY (`cont_file_cont_id`,`cont_file_file_id`) USING BTREE;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `contents_pubs`
--

CREATE TABLE `contents_pubs` (
  `cont_pub_cont_id` int NOT NULL,
  `cont_pub_pub_id` int NOT NULL,
  `cont_pub_order` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Indices de la tabla `contents_pubs`
--
ALTER TABLE `contents_pubs`
  ADD PRIMARY KEY (`cont_pub_cont_id`,`cont_pub_pub_id`) USING BTREE;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `docs`
--

CREATE TABLE `docs` (
  `doc_id` int NOT NULL,
  `doc_file_id` int DEFAULT NULL,
  `doc_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `doc_description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `doc_tags` varchar(455) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `doc_img` int NOT NULL DEFAULT '0' COMMENT 'customized',
  `doc_date` datetime DEFAULT NULL,
  `doc_register_date` datetime DEFAULT NULL,
  `doc_user_id` int NOT NULL DEFAULT '0',
  `doc_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `doc_ent_id` int DEFAULT NULL,
  `doc_state` int NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Indices de la tabla `docs`
--
ALTER TABLE `docs`
  ADD PRIMARY KEY (`doc_id`) USING BTREE;

--
-- AUTO_INCREMENT de la tabla `docs`
--
ALTER TABLE `docs`
  MODIFY `doc_id` int NOT NULL AUTO_INCREMENT;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `docs_categorys`
--

CREATE TABLE `docs_categorys` (
  `doc_cat_doc_id` int NOT NULL,
  `doc_cat_cat_id` int NOT NULL,
  `doc_cat_order` int NOT NULL,
  `doc_cat_ent_id` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Indices de la tabla `docs_categorys`
--
ALTER TABLE `docs_categorys`
  ADD PRIMARY KEY (`doc_cat_doc_id`,`doc_cat_cat_id`) USING BTREE;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `entities`
--

CREATE TABLE `entities` (
  `ent_id` int NOT NULL,
  `ent_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `ent_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `ent_brand` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `ent_code` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `ent_token` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `ent_record_date` datetime DEFAULT NULL,
  `ent_type` int DEFAULT NULL,
  `ent_notes` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `ent_state` int DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Volcado de datos para la tabla `entities`
--

INSERT INTO `entities` (`ent_id`, `ent_name`, `ent_path`, `ent_brand`, `ent_code`, `ent_token`, `ent_record_date`, `ent_type`, `ent_notes`, `ent_state`) VALUES
(1, 'Wappcom', 'wappcom', 'assets/img/logo.svg', 'CO1', 'eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJzdWIiOiI3IiwibmFtZSI6IkNhc2EgZGUgT3JhY2lvbiIsImlhdCI6MTIzNDU2Nzg5fQ.y1fa_y48leQNYbZGDlvJewtehVj78zMhkJ73B-8MGyE', '2020-10-20 14:55:39', 1, '', 1);

--
-- Indices de la tabla `entities`
--
ALTER TABLE `entities`
  ADD PRIMARY KEY (`ent_id`) USING BTREE;

--
-- AUTO_INCREMENT de la tabla `entities`
--
ALTER TABLE `entities`
  MODIFY `ent_id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `files`
--

CREATE TABLE `files` (
  `file_id` int NOT NULL,
  `file_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `file_description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `file_pathurl` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `file_embed` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `file_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `file_btn_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `file_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `file_target` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '_self',
  `file_ext` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `file_alt` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `file_filename_md5` binary(255) DEFAULT NULL,
  `file_datatime` datetime DEFAULT NULL,
  `file_ent_id` int DEFAULT NULL,
  `file_state` int DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Volcado de datos para la tabla `files`
--

INSERT INTO `files` (`file_id`, `file_name`, `file_description`, `file_pathurl`, `file_embed`, `file_title`, `file_btn_title`, `file_url`, `file_target`, `file_ext`, `file_alt`, `file_filename_md5`, `file_datatime`, `file_ent_id`, `file_state`) VALUES
(2, 'logo-wappcom_20251129_2333', '', 'files/sliders/logo-wappcom_20251129_2333.png', NULL, NULL, NULL, NULL, '_self', 'png', NULL, 0x323165633862343032343730363662353766343763343836356631353939623100000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000, '2025-11-29 23:33:02', 1, 1),
(3, 'link', '', 'files/sliders/link.png', NULL, NULL, NULL, NULL, '_self', 'png', NULL, 0x326133303461313334383435366363643232333463643731613831626433333800000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000, '2025-11-30 16:18:54', 1, 1);

--
-- Indices de la tabla `files`
--
ALTER TABLE `files`
  ADD PRIMARY KEY (`file_id`) USING BTREE;

--
-- AUTO_INCREMENT de la tabla `files`
--
ALTER TABLE `files`
  MODIFY `file_id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `forms`
--

CREATE TABLE `forms` (
  `form_id` bigint UNSIGNED NOT NULL COMMENT 'Identificador único del formulario',
  `form_title` varchar(255) NOT NULL COMMENT 'Título del formulario',
  `form_slug` varchar(255) DEFAULT NULL COMMENT 'Slug/identificador legible',
  `form_description` text COMMENT 'Descripción del formulario',
  `form_settings` text COMMENT 'JSON/text con opciones: confirmation, notifications, redirect, etc',
  `form_notify_email` varchar(255) DEFAULT NULL COMMENT 'Email para notificaciones',
  `form_user_id` bigint UNSIGNED DEFAULT NULL COMMENT 'Usuario creador',
  `form_ent_id` int UNSIGNED DEFAULT NULL COMMENT 'ID de la entidad',
  `form_site_id` int NOT NULL DEFAULT '1' COMMENT 'ID del sitio',
  `form_created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Fecha de creación del registro',
  `form_updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Fecha de última actualización',
  `form_status` int DEFAULT '1' COMMENT 'Estado (1=activo, 0=inactivo)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Definición de Formularios (Maestro)';

--
-- Volcado de datos para la tabla `forms`
--

INSERT INTO `forms` (`form_id`, `form_title`, `form_slug`, `form_description`, `form_settings`, `form_notify_email`, `form_user_id`, `form_ent_id`, `form_site_id`, `form_created_at`, `form_updated_at`, `form_status`) VALUES
(1, 'Formulario de contacto', 'contacto', 'Formulario de contacto básico', NULL, NULL, NULL, 1, 1, '2025-12-09 19:12:13', '2025-12-09 19:12:13', 1);

--
-- Indices de la tabla `forms`
--
ALTER TABLE `forms`
  ADD PRIMARY KEY (`form_id`),
  ADD UNIQUE KEY `form_slug` (`form_slug`);

--
-- AUTO_INCREMENT de la tabla `forms`
--
ALTER TABLE `forms`
  MODIFY `form_id` bigint UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'Identificador único del formulario', AUTO_INCREMENT=2;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `forms_entries`
--

CREATE TABLE `forms_entries` (
  `form_entry_id` bigint UNSIGNED NOT NULL COMMENT 'Identificador único del envío/entrada',
  `form_entry_form_id` bigint UNSIGNED NOT NULL COMMENT 'Referencia al formulario (form_id)',
  `form_entry_ent_id` int UNSIGNED DEFAULT NULL COMMENT 'ID de la entidad',
  `form_entry_site_id` int NOT NULL DEFAULT '1' COMMENT 'ID del sitio',
  `form_entry_date` datetime DEFAULT CURRENT_TIMESTAMP COMMENT 'Fecha del envío',
  `form_entry_ip` varchar(45) DEFAULT NULL COMMENT 'IP del remitente',
  `form_entry_user_id` bigint UNSIGNED DEFAULT NULL COMMENT 'Usuario asociado (si aplica)',
  `form_entry_meta` text COMMENT 'Metadatos adicionales (JSON)',
  `form_entry_created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Fecha de creación del registro',
  `form_entry_updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Fecha de última actualización',
  `form_entry_status` int DEFAULT '1' COMMENT 'Estado (1=activo,0=eliminado)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Entradas/Envios generados por los formularios';

--
-- Indices de la tabla `forms_entries`
--
ALTER TABLE `forms_entries`
  ADD PRIMARY KEY (`form_entry_id`),
  ADD KEY `idx_forms_entries_form` (`form_entry_form_id`),
  ADD KEY `idx_forms_entries_ent` (`form_entry_ent_id`),
  ADD KEY `idx_forms_entries_site` (`form_entry_site_id`);

--
-- AUTO_INCREMENT de la tabla `forms_entries`
--
ALTER TABLE `forms_entries`
  MODIFY `form_entry_id` bigint UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'Identificador único del envío/entrada';

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `forms_fields`
--

CREATE TABLE `forms_fields` (
  `form_fld_id` bigint UNSIGNED NOT NULL COMMENT 'Identificador único del campo',
  `form_fld_form_id` bigint UNSIGNED NOT NULL COMMENT 'Referencia al formulario (form_id)',
  `form_fld_ent_id` int UNSIGNED DEFAULT NULL COMMENT 'ID de la entidad',
  `form_fld_site_id` int NOT NULL DEFAULT '1' COMMENT 'ID del sitio',
  `form_fld_name` varchar(255) NOT NULL COMMENT 'Nombre interno del campo (ej: email)',
  `form_fld_label` varchar(255) DEFAULT NULL COMMENT 'Etiqueta visible para UI',
  `form_fld_type` varchar(50) DEFAULT 'text' COMMENT 'Tipo de campo (text, textarea, email, select, checkbox, file, etc)',
  `form_fld_options` text COMMENT 'Opciones para select/checkbox (JSON o CSV)',
  `form_fld_required` tinyint(1) DEFAULT '0' COMMENT '1=obligatorio,0=opcional',
  `form_fld_order` int DEFAULT '0' COMMENT 'Orden de visualización',
  `form_fld_placeholder` varchar(255) DEFAULT NULL COMMENT 'Placeholder para el input',
  `form_fld_created_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Fecha de creación del registro',
  `form_fld_updated_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Fecha de última actualización',
  `form_fld_status` int DEFAULT '1' COMMENT 'Estado del campo (1=activo,0=inactivo)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Campos pertenecientes a cada formulario';

--
-- Volcado de datos para la tabla `forms_fields`
--

INSERT INTO `forms_fields` (`form_fld_id`, `form_fld_form_id`, `form_fld_ent_id`, `form_fld_site_id`, `form_fld_name`, `form_fld_label`, `form_fld_type`, `form_fld_options`, `form_fld_required`, `form_fld_order`, `form_fld_placeholder`, `form_fld_created_at`, `form_fld_updated_at`, `form_fld_status`) VALUES
(1, 1, NULL, 1, 'name', 'Nombre', 'text', NULL, 1, 1, 'Tu nombre', '2025-12-09 19:12:13', '2025-12-09 19:12:13', 1),
(2, 1, NULL, 1, 'email', 'Correo electrónico', 'email', NULL, 1, 2, 'tu@correo.com', '2025-12-09 19:12:13', '2025-12-09 19:12:13', 1),
(3, 1, NULL, 1, 'message', 'Mensaje', 'textarea', NULL, 1, 3, 'Escribe tu mensaje', '2025-12-09 19:12:13', '2025-12-09 19:12:13', 1),
(4, 1, NULL, 1, 'attachment', 'Adjunto', 'file', NULL, 0, 4, NULL, '2025-12-09 19:12:13', '2025-12-09 19:12:13', 1);

--
-- Indices de la tabla `forms_fields`
--
ALTER TABLE `forms_fields`
  ADD PRIMARY KEY (`form_fld_id`),
  ADD KEY `idx_forms_fields_form` (`form_fld_form_id`),
  ADD KEY `idx_forms_fields_ent` (`form_fld_ent_id`),
  ADD KEY `idx_forms_fields_site` (`form_fld_site_id`);

--
-- AUTO_INCREMENT de la tabla `forms_fields`
--
ALTER TABLE `forms_fields`
  MODIFY `form_fld_id` bigint UNSIGNED NOT NULL AUTO_INCREMENT COMMENT 'Identificador único del campo', AUTO_INCREMENT=5;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `forms_files`
--

CREATE TABLE `forms_files` (
  `form_file_entry_id` bigint UNSIGNED NOT NULL COMMENT 'Referencia al envío (form_entry_id)',
  `form_file_file_id` bigint UNSIGNED NOT NULL COMMENT 'ID del archivo en el sistema de archivos/tabla de archivos',
  `form_file_ent_id` int UNSIGNED DEFAULT NULL COMMENT 'ID de la entidad',
  `form_file_site_id` int NOT NULL DEFAULT '1' COMMENT 'ID del sitio',
  `form_file_field` varchar(255) DEFAULT NULL COMMENT 'Nombre del campo al que pertenece el archivo',
  `form_file_name` varchar(255) DEFAULT NULL COMMENT 'Nombre original del archivo',
  `form_file_size` int DEFAULT NULL COMMENT 'Tamaño en bytes',
  `form_file_mime` varchar(100) DEFAULT NULL COMMENT 'Tipo MIME'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Mapeo de archivos subidos por entrada';

--
-- Indices de la tabla `forms_files`
--
ALTER TABLE `forms_files`
  ADD PRIMARY KEY (`form_file_entry_id`,`form_file_file_id`),
  ADD KEY `idx_forms_files_ent` (`form_file_ent_id`),
  ADD KEY `idx_forms_files_site` (`form_file_site_id`);

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `forms_values`
--

CREATE TABLE `forms_values` (
  `form_val_entry_id` bigint UNSIGNED NOT NULL COMMENT 'Referencia al envío (form_entry_id)',
  `form_val_field_id` bigint UNSIGNED NOT NULL COMMENT 'Referencia al campo (form_fld_id)',
  `form_val_ent_id` int UNSIGNED DEFAULT NULL COMMENT 'ID de la entidad',
  `form_val_site_id` int NOT NULL DEFAULT '1' COMMENT 'ID del sitio',
  `form_val_value` text COMMENT 'Valor almacenado (texto, json, etc)',
  `form_val_file_id` bigint UNSIGNED DEFAULT NULL COMMENT 'Si el campo es archivo, referencia al id del archivo externo',
  `form_val_order` int DEFAULT '0' COMMENT 'Orden (si aplica)'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='Valores por campo de cada entrada (EAV simple)';

--
-- Indices de la tabla `forms_values`
--
ALTER TABLE `forms_values`
  ADD PRIMARY KEY (`form_val_entry_id`,`form_val_field_id`),
  ADD KEY `idx_forms_values_field` (`form_val_field_id`),
  ADD KEY `idx_forms_values_ent` (`form_val_ent_id`),
  ADD KEY `idx_forms_values_site` (`form_val_site_id`);

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `groups`
--

CREATE TABLE `groups` (
  `group_id` int NOT NULL,
  `group_ent_id` int DEFAULT '1' COMMENT 'ID de la entidad/empresa',
  `group_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Nombre del grupo',
  `group_description` text COLLATE utf8mb4_unicode_ci COMMENT 'Descripción del grupo',
  `group_state` tinyint(1) NOT NULL DEFAULT '1' COMMENT '0=Inactivo, 1=Activo',
  `group_created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Fecha de creación',
  `group_updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Fecha de actualización'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Grupos de usuarios y archivos';

--
-- Indices de la tabla `groups`
--
ALTER TABLE `groups`
  ADD PRIMARY KEY (`group_id`),
  ADD KEY `idx_group_ent_id` (`group_ent_id`),
  ADD KEY `idx_group_state` (`group_state`);

--
-- AUTO_INCREMENT de la tabla `groups`
--
ALTER TABLE `groups`
  MODIFY `group_id` int NOT NULL AUTO_INCREMENT;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `groups_files`
--

CREATE TABLE `groups_files` (
  `group_file_group_id` int NOT NULL COMMENT 'ID del grupo',
  `group_file_file_id` int NOT NULL COMMENT 'ID del archivo',
  `group_file_order` int NOT NULL DEFAULT '0' COMMENT 'Orden del archivo en el grupo'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Asignación de archivos a grupos';

--
-- Indices de la tabla `groups_files`
--
ALTER TABLE `groups_files`
  ADD KEY `idx_gf_group_id` (`group_file_group_id`),
  ADD KEY `idx_gf_file_id` (`group_file_file_id`);

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `groups_users`
--

CREATE TABLE `groups_users` (
  `group_user_group_id` int NOT NULL COMMENT 'ID del grupo',
  `group_user_user_id` int NOT NULL COMMENT 'ID del usuario'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Asignación de usuarios a grupos';

--
-- Indices de la tabla `groups_users`
--
ALTER TABLE `groups_users`
  ADD KEY `idx_gu_group_id` (`group_user_group_id`),
  ADD KEY `idx_gu_user_id` (`group_user_user_id`);

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `links`
--

CREATE TABLE `links` (
  `lnk_id` int NOT NULL,
  `lnk_title` varchar(455) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `lnk_description` varchar(445) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `lnk_tags` varchar(455) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `lnk_url` varchar(455) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '#',
  `lnk_target` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '_blank',
  `lnk_icon` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `lnk_attr` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `lnk_cls` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `lnk_alt` varchar(120) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `lnk_img` int DEFAULT NULL,
  `lnk_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `lnk_ent_id` int DEFAULT NULL,
  `lnk_state` int NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Indices de la tabla `links`
--
ALTER TABLE `links`
  ADD PRIMARY KEY (`lnk_id`) USING BTREE;

--
-- AUTO_INCREMENT de la tabla `links`
--
ALTER TABLE `links`
  MODIFY `lnk_id` int NOT NULL AUTO_INCREMENT;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `links_categorys`
--

CREATE TABLE `links_categorys` (
  `lnk_cat_cat_id` int NOT NULL,
  `lnk_cat_lnk_id` int NOT NULL,
  `lnk_cat_order` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Indices de la tabla `links_categorys`
--
ALTER TABLE `links_categorys`
  ADD PRIMARY KEY (`lnk_cat_cat_id`,`lnk_cat_lnk_id`) USING BTREE;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `links_pubs`
--

CREATE TABLE `links_pubs` (
  `lnk_pub_pub_id` int NOT NULL,
  `lnk_pub_lnk_id` int NOT NULL,
  `lnk_pub_order` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Indices de la tabla `links_pubs`
--
ALTER TABLE `links_pubs`
  ADD PRIMARY KEY (`lnk_pub_pub_id`,`lnk_pub_lnk_id`) USING BTREE;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `media_categorys`
--

CREATE TABLE `media_categorys` (
  `media_cat_file_id` int NOT NULL,
  `media_cat_cat_id` int NOT NULL,
  `media_cat_order` int NOT NULL,
  `media_cat_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `media_cat_description` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `media_cat_ent_id` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Indices de la tabla `media_categorys`
--
ALTER TABLE `media_categorys`
  ADD PRIMARY KEY (`media_cat_file_id`,`media_cat_cat_id`) USING BTREE;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `menus`
--

CREATE TABLE `menus` (
  `menu_id` int NOT NULL,
  `menu_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Nombre del menú',
  `menu_description` text COLLATE utf8mb4_unicode_ci COMMENT 'Descripción del menú',
  `menu_site_id` int DEFAULT NULL COMMENT 'ID del sitio web al que pertenece',
  `menu_ent_id` int DEFAULT '1' COMMENT 'ID de la entidad/empresa',
  `menu_state` tinyint(1) NOT NULL DEFAULT '1' COMMENT '0=Inactivo, 1=Activo',
  `menu_created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Fecha de creación',
  `menu_updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Fecha de actualización'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Menús principales del sistema';

--
-- Volcado de datos para la tabla `menus`
--

INSERT INTO `menus` (`menu_id`, `menu_name`, `menu_description`, `menu_site_id`, `menu_ent_id`, `menu_state`, `menu_created_at`, `menu_updated_at`) VALUES
(1, 'Menú Principal', 'Menú de navegación principal del sitio', NULL, 1, 1, '2025-12-08 15:56:11', '2025-12-08 15:56:11'),
(2, 'pie de pagina', '', NULL, 1, 1, '2025-12-08 23:10:52', '2025-12-08 23:10:52');

--
-- Indices de la tabla `menus`
--
ALTER TABLE `menus`
  ADD PRIMARY KEY (`menu_id`),
  ADD KEY `idx_menu_site_id` (`menu_site_id`),
  ADD KEY `idx_menu_ent_id` (`menu_ent_id`),
  ADD KEY `idx_menu_state` (`menu_state`),
  ADD KEY `idx_site_state` (`menu_site_id`,`menu_state`);

--
-- AUTO_INCREMENT de la tabla `menus`
--
ALTER TABLE `menus`
  MODIFY `menu_id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=3;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `menus_items`
--

CREATE TABLE `menus_items` (
  `menu_item_id` int NOT NULL,
  `menu_item_menu_id` int NOT NULL COMMENT 'ID del menú al que pertenece',
  `menu_item_name` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'Etiqueta de navegación',
  `menu_item_description` text COLLATE utf8mb4_unicode_ci COMMENT 'Descripción del item',
  `menu_item_pathurl` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'URL del enlace',
  `menu_item_target` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '_self' COMMENT 'Target del enlace: _self, _blank, etc.',
  `menu_item_parent_id` int DEFAULT '0' COMMENT 'ID del item padre (0 = item raíz)',
  `menu_item_level` tinyint NOT NULL DEFAULT '0' COMMENT 'Nivel de profundidad (0=raíz, 1=hijo, 2=nieto, etc.)',
  `menu_item_order` int NOT NULL DEFAULT '0' COMMENT 'Orden de visualización',
  `menu_item_icon` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Clase del icono o URL de imagen',
  `menu_item_img` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'URL de imagen (alternativa al icono)',
  `menu_item_html_id` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'ID HTML personalizado',
  `menu_item_css_class` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL COMMENT 'Clases CSS adicionales',
  `menu_item_cat_id` int DEFAULT NULL COMMENT 'ID de categoría asociada',
  `menu_item_cat_active` tinyint(1) DEFAULT '0' COMMENT 'Si la categoría está activa',
  `menu_item_data` text COLLATE utf8mb4_unicode_ci COMMENT 'Datos JSON adicionales',
  `menu_item_state` tinyint(1) NOT NULL DEFAULT '1' COMMENT '0=Inactivo, 1=Activo',
  `menu_item_created_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Fecha de creación',
  `menu_item_updated_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT 'Fecha de actualización'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Items de menú con soporte jerárquico';

--
-- Volcado de datos para la tabla `menus_items`
--

INSERT INTO `menus_items` (`menu_item_id`, `menu_item_menu_id`, `menu_item_name`, `menu_item_description`, `menu_item_pathurl`, `menu_item_target`, `menu_item_parent_id`, `menu_item_level`, `menu_item_order`, `menu_item_icon`, `menu_item_img`, `menu_item_html_id`, `menu_item_css_class`, `menu_item_cat_id`, `menu_item_cat_active`, `menu_item_data`, `menu_item_state`, `menu_item_created_at`, `menu_item_updated_at`) VALUES
(235, 1, 'Home', NULL, '/', '_self', 0, 0, 0, 'icon-home', '', '', '', NULL, 0, '', 1, '2025-12-08 22:56:46', '2025-12-08 22:56:46'),
(236, 1, '', NULL, '', '_self', 0, 0, 1, '', '', '', '', NULL, 0, '', 1, '2025-12-08 22:56:46', '2025-12-08 22:56:46'),
(237, 1, 'Products', NULL, '/products', '_self', 0, 0, 2, 'icon-box', '', '', '', NULL, 0, '', 1, '2025-12-08 22:56:46', '2025-12-08 22:56:46'),
(238, 1, 'Books', NULL, '/products/categories/books', '_self', 237, 1, 3, 'icon-book', '', '', '', NULL, 0, '', 1, '2025-12-08 22:56:46', '2025-12-08 22:56:46'),
(239, 1, 'Electronics', NULL, '/products/categories/electronics', '_self', 237, 1, 4, 'icon-cpu', '', '', '', NULL, 0, '', 1, '2025-12-08 22:56:46', '2025-12-08 22:56:46'),
(240, 1, 'Categories', NULL, '/products/categories', '_self', 237, 1, 5, 'icon-folder', '', '', '', NULL, 0, '', 1, '2025-12-08 22:56:46', '2025-12-08 22:56:46'),
(241, 1, 'About Us', NULL, '/about', '_self', 240, 2, 6, 'icon-info', '', '', '', NULL, 0, '', 1, '2025-12-08 22:56:46', '2025-12-08 22:56:46'),
(242, 1, 'prueba menu', NULL, '', '_self', 0, 0, 7, '', '', '', '', NULL, 0, '', 1, '2025-12-08 22:56:46', '2025-12-08 22:56:46'),
(243, 1, 'Featured', NULL, '/products/featured', '_self', 0, 0, 8, 'icon-star', '', '', '', NULL, 0, '', 1, '2025-12-08 22:56:46', '2025-12-08 22:56:46'),
(244, 1, 'Contact', NULL, '/contact', '_self', 243, 1, 9, 'icon-mail', '', '', '', NULL, 0, '', 1, '2025-12-08 22:56:46', '2025-12-08 22:56:46'),
(245, 1, 'Clothing', NULL, '/products/categories/clothing', '_self', 243, 1, 10, 'icon-shirt', '', '', '', NULL, 0, '', 1, '2025-12-08 22:56:46', '2025-12-08 22:56:46'),
(246, 1, 'All Products', NULL, '/products/all', '_self', 0, 0, 11, 'icon-list', '', '', '', NULL, 0, '', 1, '2025-12-08 22:56:46', '2025-12-08 22:56:46'),
(250, 2, 'prueba 2', NULL, '', '_self', 0, 0, 0, '', '', '', '', NULL, 0, '', 1, '2025-12-08 23:11:01', '2025-12-08 23:11:01'),
(251, 2, 'About Us', NULL, '', '_self', 250, 1, 1, '', '', '', '', NULL, 0, '', 1, '2025-12-08 23:11:01', '2025-12-08 23:11:01'),
(252, 2, 'Books', NULL, '', '_self', 251, 2, 2, '', '', '', '', NULL, 0, '', 1, '2025-12-08 23:11:01', '2025-12-08 23:11:01');

--
-- Indices de la tabla `menus_items`
--
ALTER TABLE `menus_items`
  ADD PRIMARY KEY (`menu_item_id`),
  ADD KEY `idx_menu_id` (`menu_item_menu_id`),
  ADD KEY `idx_parent_id` (`menu_item_parent_id`),
  ADD KEY `idx_level` (`menu_item_level`),
  ADD KEY `idx_order` (`menu_item_order`),
  ADD KEY `idx_state` (`menu_item_state`),
  ADD KEY `idx_menu_parent` (`menu_item_menu_id`,`menu_item_parent_id`),
  ADD KEY `idx_menu_order` (`menu_item_menu_id`,`menu_item_order`);

--
-- AUTO_INCREMENT de la tabla `menus_items`
--
ALTER TABLE `menus_items`
  MODIFY `menu_item_id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=253;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `modules_categorys`
--

CREATE TABLE `modules_categorys` (
  `mod_cat_mod_id` int NOT NULL,
  `mod_cat_cat_id` int NOT NULL,
  `mod_cat_ent_id` int NOT NULL,
  `mod_cat_order` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Indices de la tabla `modules_categorys`
--
ALTER TABLE `modules_categorys`
  ADD PRIMARY KEY (`mod_cat_mod_id`,`mod_cat_cat_id`,`mod_cat_ent_id`) USING BTREE;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `notifications`
--

CREATE TABLE `notifications` (
  `ntf_id` int NOT NULL,
  `ntf_recipient_id` int NOT NULL COMMENT 'Id del destinatario',
  `ntf_recipient_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'Tipo de destinatario (customer,provider)',
  `ntf_message` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `ntf_sent_at` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `ntf_status` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT 'pending,send,delivered',
  `ntf_ent_id` int NOT NULL,
  `ntf_custom_data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_bin,
  `ntf_class` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `ntf_custom_id` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `ntf_state` int DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Indices de la tabla `notifications`
--
ALTER TABLE `notifications`
  ADD PRIMARY KEY (`ntf_id`) USING BTREE;

--
-- AUTO_INCREMENT de la tabla `notifications`
--
ALTER TABLE `notifications`
  MODIFY `ntf_id` int NOT NULL AUTO_INCREMENT;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `options`
--

CREATE TABLE `options` (
  `option_id` bigint UNSIGNED NOT NULL,
  `option_name` varchar(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '',
  `option_value` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `autoload` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT 'yes'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Volcado de datos para la tabla `options`
--

INSERT INTO `options` (`option_id`, `option_name`, `option_value`, `autoload`) VALUES
(1, 'site_title', 'Ion', 'yes'),
(2, 'site_favicon', 'ion/assets/img/favicon.png', 'yes'),
(3, 'site_img', 'ion/assets/img/logo.svg', 'yes'),
(4, 'site_version', '22662', 'yes'),
(5, 'user_id_default', '3', 'yes'),
(6, 'bearer_token', 'eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJzdWIiOiI3MjM0OTIzODczNDkiLCJuYW1lIjoibnVjbGVvIiwiaWF0Ijo5MzI0MjQzNDl9.jIsiHIdOGa-KHCJ2mUhLLKqlvTYVLolUyrp1HM6E7Cs-gedeon', 'yes'),
(7, 'client_id', 'eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9-gedeon', 'yes'),
(8, 'client_secret', 'eyJzdWIiOiI3MjM0OTIzODczNDkiLCJuYW1lIjoibnVjbGVvIiwiaWF0Ijo5MzI0MjQzNDl9-gedeon', 'yes'),
(9, 'locale', 'es_ES', 'yes'),
(10, 'timezone', 'America/La_Paz', 'yes'),
(12, 'site-meta', 'sites/default/controllers/pub/meta.pub.php', 'yes'),
(13, 'entitie_id_default', '1', 'yes'),
(14, 'dashboard_img', 'assets/img/logo.svg', 'yes'),
(15, 'dashboard_favicon', 'assets/img/favicon.png', 'yes'),
(16, 'dashboard_brand', 'assets/img/logo.svg', 'yes'),
(17, 'path_icons_pub', 'ion/assets/img/pubs', 'yes'),
(18, 'dial_code_default', '+591', 'yes'),
(19, 'country', 'bo', 'yes'),
(20, 'cron', '', 'yes'),
(21, 'path_activation', '{{_PATH_WEB}}activation', 'yes'),
(22, 'callback', '', 'yes'),
(23, 'footer', 'Nucleo v1.0', 'yes'),
(24, 'path_resetpw', '{{_PATH_WEB}}pages/reserpassword.php', 'yes'),
(26, 'path_logo', '{{_PATH_WEB}}assets/img/logo.svg', 'yes');

--
-- Indices de la tabla `options`
--
ALTER TABLE `options`
  ADD PRIMARY KEY (`option_id`) USING BTREE;

--
-- AUTO_INCREMENT de la tabla `options`
--
ALTER TABLE `options`
  MODIFY `option_id` bigint UNSIGNED NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=27;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `posts`
--

CREATE TABLE `posts` (
  `post_id` int NOT NULL,
  `post_title` varchar(455) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `post_pathurl` varchar(455) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `post_shortlink` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `post_tags` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `post_review` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `post_img` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT '0',
  `post_img_ref` varchar(445) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `post_embed` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `post_preview_embed` int DEFAULT '0',
  `post_intern_embed` int DEFAULT '0',
  `post_video` int DEFAULT '0',
  `post_preview_video` int DEFAULT '0',
  `post_intern_video` int DEFAULT '0',
  `post_body` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `post_place` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `post_author` int DEFAULT NULL,
  `post_cls` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `post_top_relations` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `post_middle_relations` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `post_last_relations` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `post_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `post_date` datetime DEFAULT NULL,
  `post_register_date` datetime NOT NULL,
  `post_ent_id` int DEFAULT NULL,
  `post_user_id` int DEFAULT NULL,
  `post_state` int DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Indices de la tabla `posts`
--
ALTER TABLE `posts`
  ADD PRIMARY KEY (`post_id`) USING BTREE;

--
-- AUTO_INCREMENT de la tabla `posts`
--
ALTER TABLE `posts`
  MODIFY `post_id` int NOT NULL AUTO_INCREMENT;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `posts_authors`
--

CREATE TABLE `posts_authors` (
  `post_au_id` int NOT NULL,
  `post_au_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `post_au_summary` tinytext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `post_au_img` int DEFAULT '0',
  `post_au_ent_id` int DEFAULT NULL,
  `post_au_contact` tinytext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `post_au_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `post_au_state` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Volcado de datos para la tabla `posts_authors`
--

INSERT INTO `posts_authors` (`post_au_id`, `post_au_name`, `post_au_summary`, `post_au_img`, `post_au_ent_id`, `post_au_contact`, `post_au_path`, `post_au_state`) VALUES
(1, '', '', 0, 1, '', '', 1);

--
-- Indices de la tabla `posts_authors`
--
ALTER TABLE `posts_authors`
  ADD PRIMARY KEY (`post_au_id`) USING BTREE;

--
-- AUTO_INCREMENT de la tabla `posts_authors`
--
ALTER TABLE `posts_authors`
  MODIFY `post_au_id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `posts_categorys`
--

CREATE TABLE `posts_categorys` (
  `post_cat_post_id` int NOT NULL,
  `post_cat_cat_id` int NOT NULL,
  `post_cat_ent_id` int DEFAULT NULL,
  `post_cat_order` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Indices de la tabla `posts_categorys`
--
ALTER TABLE `posts_categorys`
  ADD PRIMARY KEY (`post_cat_post_id`,`post_cat_cat_id`) USING BTREE;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `posts_files`
--

CREATE TABLE `posts_files` (
  `post_file_post_id` int NOT NULL,
  `post_file_file_id` int NOT NULL,
  `post_file_order` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Indices de la tabla `posts_files`
--
ALTER TABLE `posts_files`
  ADD PRIMARY KEY (`post_file_post_id`,`post_file_file_id`) USING BTREE;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `publications`
--

CREATE TABLE `publications` (
  `pub_id` int NOT NULL,
  `pub_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `pub_description` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `pub_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `pub_summary` mediumtext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `pub_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `pub_path_ui` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `pub_path_icon` varchar(455) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `pub_icon` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `pub_type` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `pub_class` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `pub_attr_id` varchar(455) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `pub_attr` varchar(445) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `pub_count` int DEFAULT NULL,
  `pub_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `pub_html` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `pub_state` int DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Volcado de datos para la tabla `publications`
--

INSERT INTO `publications` (`pub_id`, `pub_name`, `pub_description`, `pub_title`, `pub_summary`, `pub_path`, `pub_path_ui`, `pub_path_icon`, `pub_icon`, `pub_type`, `pub_class`, `pub_attr_id`, `pub_attr`, `pub_count`, `pub_json`, `pub_html`, `pub_state`) VALUES
(7, 'Nav', 'Barra de Navegación de la página', '', '', 'sites/default/controllers/pub/nav.pub.php', '', 'sites/default/assets/img/pubs/nav.pub.svg', '', 'host', 'pub-nav', '', '', 1, '', '', 1),
(8, 'home', '', '', '', 'sites/default/controllers/pub/home.pub.php', '', '', '', 'host', 'pub-home', '', '', 1, '', '', 1),
(9, 'map', '', '', '', 'sites/default/controllers/pub/map.pub.php', '', '', '', 'host', 'pub-map', '', '', 1, '', '', 1);

--
-- Indices de la tabla `publications`
--
ALTER TABLE `publications`
  ADD PRIMARY KEY (`pub_id`) USING BTREE;

--
-- AUTO_INCREMENT de la tabla `publications`
--
ALTER TABLE `publications`
  MODIFY `pub_id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=10;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `publications_pattern`
--

CREATE TABLE `publications_pattern` (
  `pub_pat_id` int NOT NULL,
  `pub_pat_name` varchar(250) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `pub_pat_description` tinytext CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `pub_pat_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `pub_pat_ent_id` int DEFAULT '0',
  `pub_pat_order` int DEFAULT '0',
  `pub_pat_state` int NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Indices de la tabla `publications_pattern`
--
ALTER TABLE `publications_pattern`
  ADD PRIMARY KEY (`pub_pat_id`) USING BTREE;

--
-- AUTO_INCREMENT de la tabla `publications_pattern`
--
ALTER TABLE `publications_pattern`
  MODIFY `pub_pat_id` int NOT NULL AUTO_INCREMENT;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `publications_relations`
--

CREATE TABLE `publications_relations` (
  `pub_rel_id` int NOT NULL,
  `pub_rel_cat_id` int DEFAULT NULL,
  `pub_rel_ws_id` int DEFAULT NULL,
  `pub_rel_block_id` int DEFAULT NULL,
  `pub_rel_pub_id` int DEFAULT NULL,
  `pub_rel_state` int NOT NULL DEFAULT '1',
  `pub_rel_order` int NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Volcado de datos para la tabla `publications_relations`
--

INSERT INTO `publications_relations` (`pub_rel_id`, `pub_rel_cat_id`, `pub_rel_ws_id`, `pub_rel_block_id`, `pub_rel_pub_id`, `pub_rel_state`, `pub_rel_order`) VALUES
(1, 1, 1, 1, 7, 1, 1),
(2, 1, 1, 2, 8, 1, 1),
(3, 6, 1, 2, 9, 1, 1);

--
-- Indices de la tabla `publications_relations`
--
ALTER TABLE `publications_relations`
  ADD PRIMARY KEY (`pub_rel_id`) USING BTREE;

--
-- AUTO_INCREMENT de la tabla `publications_relations`
--
ALTER TABLE `publications_relations`
  MODIFY `pub_rel_id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `roles`
--

CREATE TABLE `roles` (
  `rol_id` int NOT NULL,
  `rol_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `rol_description` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `rol_parent_id` int DEFAULT NULL,
  `rol_redirection_url` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `rol_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `rol_state` int DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Volcado de datos para la tabla `roles`
--

INSERT INTO `roles` (`rol_id`, `rol_name`, `rol_description`, `rol_parent_id`, `rol_redirection_url`, `rol_json`, `rol_state`) VALUES
(1, 'Super Administrador', NULL, 0, '{_PATH_WEB}dashboard', NULL, 1),
(2, 'Administrador', NULL, 1, '{_PATH_WEB}dashboard', NULL, 1),
(3, 'Administrador de Entidad', NULL, 2, '{_PATH_WEB}dashboard', NULL, 1),
(4, 'Administrador RRHH', NULL, 2, '{_PATH_WEB}dashboard', NULL, 1),
(10, 'Encargado de Contabilidad', NULL, 2, '{_PATH_WEB}dashboard', NULL, 1),
(5, 'Jefe de Inventario', NULL, 2, '{_PATH_WEB}dashboard', NULL, 1),
(6, 'Digitador', NULL, 2, '{_PATH_WEB}dashboard', NULL, 1),
(11, 'Encargado de Ventas', NULL, 2, '{_PATH_WEB}dashboard', NULL, 0),
(12, 'Encargado de Mantenimiento\r\n', NULL, 2, '{_PATH_WEB}dashboard', NULL, 0);

--
-- Indices de la tabla `roles`
--
ALTER TABLE `roles`
  ADD PRIMARY KEY (`rol_id`) USING BTREE;

--
-- AUTO_INCREMENT de la tabla `roles`
--
ALTER TABLE `roles`
  MODIFY `rol_id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=13;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `roles_categorys`
--

CREATE TABLE `roles_categorys` (
  `rol_cat_rol_id` int NOT NULL,
  `rol_cat_cat_id` int NOT NULL,
  `rol_cat_order` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Indices de la tabla `roles_categorys`
--
ALTER TABLE `roles_categorys`
  ADD PRIMARY KEY (`rol_cat_rol_id`,`rol_cat_cat_id`) USING BTREE;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `roles_entities`
--

CREATE TABLE `roles_entities` (
  `rol_ent_rol_id` int NOT NULL,
  `rol_ent_ent_id` int NOT NULL,
  `rol_ent_state` int DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Indices de la tabla `roles_entities`
--
ALTER TABLE `roles_entities`
  ADD PRIMARY KEY (`rol_ent_rol_id`,`rol_ent_ent_id`) USING BTREE;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `roles_modules`
--

CREATE TABLE `roles_modules` (
  `rol_mod_rol_id` int NOT NULL,
  `rol_mod_mod_id` int NOT NULL,
  `rol_mod_ent_id` int NOT NULL,
  `rol_mod_order` int NOT NULL,
  `rol_mod_permits` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '0,0,0,0,0' COMMENT 'See,Publish,Add,Edit,Delete'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Volcado de datos para la tabla `roles_modules`
--

INSERT INTO `roles_modules` (`rol_mod_rol_id`, `rol_mod_mod_id`, `rol_mod_ent_id`, `rol_mod_order`, `rol_mod_permits`) VALUES
(5, 500, 1, 1, '0,0,0,0,0'),
(6, 500, 1, 0, '0,0,0,0,0'),
(7, 500, 1, 0, '0,0,0,0,0'),
(5, 501, 1, 1, '0,0,0,0,0'),
(6, 501, 1, 0, '0,0,0,0,0'),
(7, 501, 1, 1, '0,0,0,0,0'),
(10, 1000, 1, 1, '0,0,0,0,0'),
(10, 1001, 1, 1, '0,0,0,0,0');

--
-- Indices de la tabla `roles_modules`
--
ALTER TABLE `roles_modules`
  ADD PRIMARY KEY (`rol_mod_mod_id`,`rol_mod_rol_id`) USING BTREE;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `roles_sites`
--

CREATE TABLE `roles_sites` (
  `rol_site_rol_id` int NOT NULL COMMENT 'ID del rol',
  `rol_site_site_id` int NOT NULL COMMENT 'ID del sitio',
  `rol_site_order` int NOT NULL COMMENT 'Orden del rol en el sitio'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Indices de la tabla `roles_sites`
--
ALTER TABLE `roles_sites`
  ADD PRIMARY KEY (`rol_site_rol_id`,`rol_site_site_id`) USING BTREE,
  ADD KEY `idx_site_id` (`rol_site_site_id`) USING BTREE,
  ADD KEY `idx_order` (`rol_site_site_id`,`rol_site_order`) USING BTREE;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `roles_systems`
--

CREATE TABLE `roles_systems` (
  `rol_sys_rol_id` int NOT NULL,
  `rol_sys_sys_id` int NOT NULL,
  `rol_sys_ent_id` int NOT NULL,
  `rol_sys_order` int DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Volcado de datos para la tabla `roles_systems`
--

INSERT INTO `roles_systems` (`rol_sys_rol_id`, `rol_sys_sys_id`, `rol_sys_ent_id`, `rol_sys_order`) VALUES
(2, 6, 1, 0),
(5, 6, 1, 1),
(6, 6, 1, 2),
(7, 6, 1, 0),
(10, 5, 1, 1);

--
-- Indices de la tabla `roles_systems`
--
ALTER TABLE `roles_systems`
  ADD PRIMARY KEY (`rol_sys_rol_id`,`rol_sys_sys_id`,`rol_sys_ent_id`) USING BTREE;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `sites`
--

CREATE TABLE `sites` (
  `site_id` int NOT NULL COMMENT 'ID único del sitio',
  `site_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'Nombre descriptivo del sitio',
  `site_path_web` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'URL completa del sitio (ej: https://example.com/)',
  `site_path_host` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'Ruta física del servidor (ej: /var/www/html/)',
  `site_title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL COMMENT 'Título del sitio para SEO y navegador',
  `site_head` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci COMMENT 'Código HTML personalizado para la sección <head>',
  `site_head_path_url` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT 'URL del archivo head externo',
  `site_default` int NOT NULL DEFAULT '0' COMMENT 'Indica si es el sitio por defecto (0=No, 1=Sí)',
  `site_created_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Fecha de creación del sitio',
  `site_updated_at` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'Última actualización del sitio',
  `site_ent_id` int NOT NULL DEFAULT '0' COMMENT 'ID de la entidad propietaria del sitio',
  `site_state` int NOT NULL DEFAULT '0' COMMENT 'Estado del sitio (0=Inactivo, 1=Activo, 2=Mantenimiento, 3=Suspendido)'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Volcado de datos para la tabla `sites`
--

INSERT INTO `sites` (`site_id`, `site_name`, `site_path_web`, `site_path_host`, `site_title`, `site_head`, `site_head_path_url`, `site_default`, `site_created_at`, `site_updated_at`, `site_ent_id`, `site_state`) VALUES
(1, 'Sitio 1', 'https://dev.wappcom.com/home/site/', '/var/html/', 'Sitio 1', '', '', 0, '2025-12-10 00:24:23', '2025-12-10 00:24:23', 1, 1);

--
-- Indices de la tabla `sites`
--
ALTER TABLE `sites`
  ADD PRIMARY KEY (`site_id`) USING BTREE,
  ADD KEY `idx_state` (`site_state`) USING BTREE,
  ADD KEY `idx_ent_id` (`site_ent_id`) USING BTREE,
  ADD KEY `idx_path_web` (`site_path_web`(250)) USING BTREE,
  ADD KEY `idx_path_host` (`site_path_host`(250)) USING BTREE,
  ADD KEY `idx_ent_state` (`site_ent_id`,`site_state`) USING BTREE;

--
-- AUTO_INCREMENT de la tabla `sites`
--
ALTER TABLE `sites`
  MODIFY `site_id` int NOT NULL AUTO_INCREMENT COMMENT 'ID único del sitio', AUTO_INCREMENT=2;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `sites_entities`
--

CREATE TABLE `sites_entities` (
  `site_ent_site_id` int NOT NULL COMMENT 'ID del sitio',
  `site_ent_ent_id` int NOT NULL COMMENT 'ID de la entidad asociada',
  `site_ent_order` int NOT NULL COMMENT 'Orden de la entidad en el sitio'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Indices de la tabla `sites_entities`
--
ALTER TABLE `sites_entities`
  ADD PRIMARY KEY (`site_ent_site_id`,`site_ent_ent_id`) USING BTREE,
  ADD KEY `idx_site_id` (`site_ent_site_id`) USING BTREE,
  ADD KEY `idx_ent_id` (`site_ent_ent_id`) USING BTREE,
  ADD KEY `idx_order` (`site_ent_site_id`,`site_ent_order`) USING BTREE;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `sites_users`
--

CREATE TABLE `sites_users` (
  `site_user_site_id` int NOT NULL COMMENT 'ID del sitio',
  `site_user_user_id` int NOT NULL COMMENT 'ID del usuario',
  `site_user_rol_id` int NOT NULL COMMENT 'ID del rol asignado al usuario en el sitio',
  `site_user_order` int NOT NULL COMMENT 'Orden del usuario en el sitio'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Indices de la tabla `sites_users`
--
ALTER TABLE `sites_users`
  ADD PRIMARY KEY (`site_user_site_id`,`site_user_user_id`) USING BTREE,
  ADD KEY `idx_user_id` (`site_user_user_id`) USING BTREE,
  ADD KEY `idx_rol_id` (`site_user_rol_id`) USING BTREE,
  ADD KEY `idx_order` (`site_user_site_id`,`site_user_order`) USING BTREE;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `users`
--

CREATE TABLE `users` (
  `user_id` int NOT NULL,
  `user_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `user_lastname` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `user_email` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `user_password` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `user_img` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `user_username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `user_user_id` int NOT NULL COMMENT 'usuario que guarda',
  `user_level` int NOT NULL DEFAULT '0',
  `user_state` int DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Volcado de datos para la tabla `users`
--

INSERT INTO `users` (`user_id`, `user_name`, `user_lastname`, `user_email`, `user_password`, `user_img`, `user_username`, `user_user_id`, `user_level`, `user_state`) VALUES
(1, 'admin', 'general', 'adm@wappcom.com', 'd2FwcGNvbSM=', 'https://lh3.googleusercontent.com/a-/AOh14Gg0Q2OTE5-h1lN_wfEqTXCcrB_gY0tSmuF8UIi6Kw=s96-c', NULL, 0, 0, 1);

--
-- Indices de la tabla `users`
--
ALTER TABLE `users`
  ADD PRIMARY KEY (`user_id`) USING BTREE;

--
-- AUTO_INCREMENT de la tabla `users`
--
ALTER TABLE `users`
  MODIFY `user_id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=2;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `users_firms`
--

CREATE TABLE `users_firms` (
  `user_firm_id` int NOT NULL,
  `user_firm_user_id` int NOT NULL,
  `user_firm_img` varchar(455) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `user_firm_reference` int DEFAULT NULL,
  `user_firm_md5` int DEFAULT NULL,
  `user_firm_state` int NOT NULL DEFAULT '0'
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Indices de la tabla `users_firms`
--
ALTER TABLE `users_firms`
  ADD PRIMARY KEY (`user_firm_id`,`user_firm_user_id`) USING BTREE;

--
-- AUTO_INCREMENT de la tabla `users_firms`
--
ALTER TABLE `users_firms`
  MODIFY `user_firm_id` int NOT NULL AUTO_INCREMENT;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `users_groups`
--

CREATE TABLE `users_groups` (
  `user_group_user_id` int NOT NULL,
  `user_group_group_id` int NOT NULL,
  `user_group_ent_id` int NOT NULL,
  `user_group_order` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Indices de la tabla `users_groups`
--
ALTER TABLE `users_groups`
  ADD PRIMARY KEY (`user_group_user_id`,`user_group_group_id`) USING BTREE;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `users_path`
--

CREATE TABLE `users_path` (
  `user_path_user_id` int NOT NULL,
  `user_path_mod_id` int NOT NULL,
  `user_path_path` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `user_path_order` int NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Indices de la tabla `users_path`
--
ALTER TABLE `users_path`
  ADD PRIMARY KEY (`user_path_user_id`,`user_path_mod_id`) USING BTREE;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `users_roles`
--

CREATE TABLE `users_roles` (
  `user_rol_user_id` int NOT NULL,
  `user_rol_rol_id` int NOT NULL,
  `user_rol_ent_id` int NOT NULL,
  `user_rol_order` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Volcado de datos para la tabla `users_roles`
--

INSERT INTO `users_roles` (`user_rol_user_id`, `user_rol_rol_id`, `user_rol_ent_id`, `user_rol_order`) VALUES
(1, 1, 1, 0),
(3, 10, 1, 1),
(4, 10, 1, 1);

--
-- Indices de la tabla `users_roles`
--
ALTER TABLE `users_roles`
  ADD PRIMARY KEY (`user_rol_user_id`,`user_rol_rol_id`) USING BTREE;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `users_tabs`
--

CREATE TABLE `users_tabs` (
  `user_tab_user_id` int NOT NULL,
  `user_tab_sys_id` int NOT NULL,
  `user_tab_ent_id` int NOT NULL,
  `user_tab_sys_active` int NOT NULL,
  `user_tab_start_mod_id` int DEFAULT '0',
  `user_tab_json` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci,
  `user_tab_order` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Volcado de datos para la tabla `users_tabs`
--

INSERT INTO `users_tabs` (`user_tab_user_id`, `user_tab_sys_id`, `user_tab_ent_id`, `user_tab_sys_active`, `user_tab_start_mod_id`, `user_tab_json`, `user_tab_order`) VALUES
(1, 1, 1, 0, 18, NULL, 2),
(1, 19, 1, 1, 1902, NULL, 1),
(1, 40, 1, 0, 4002, NULL, 3);

--
-- Indices de la tabla `users_tabs`
--
ALTER TABLE `users_tabs`
  ADD PRIMARY KEY (`user_tab_user_id`,`user_tab_sys_id`,`user_tab_ent_id`) USING BTREE;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `users_tokens`
--

CREATE TABLE `users_tokens` (
  `user_tk_user_id` bigint NOT NULL,
  `user_tk_type` varchar(15) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `user_tk_token` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `user_tk_expires_in` datetime DEFAULT NULL,
  `user_tk_date` datetime DEFAULT NULL,
  `user_tk_dates_browser` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Volcado de datos para la tabla `users_tokens`
--

INSERT INTO `users_tokens` (`user_tk_user_id`, `user_tk_type`, `user_tk_token`, `user_tk_expires_in`, `user_tk_date`, `user_tk_dates_browser`) VALUES
(1, 'access_token', 'ZXlKaGJHY2lPaUpJVXpJMU5pSXNJblI1Y0NJNklrcFhWQ0o5LWdlZGVvbi4xLjEuMC40MjcyODAwMCAxNzYxMTYxNTA5NjhmOTMxMjU2ODUyMTkuMjE1MjM4NTY=', NULL, '2025-10-22 15:31:49', 'Google Chrome,141.0.0.0,Mac Os:Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/141.0.0.0 Safari/537.36'),
(1, 'access_token', 'ZXlKaGJHY2lPaUpJVXpJMU5pSXNJblI1Y0NJNklrcFhWQ0o5LWdlZGVvbi4xLjEuMC40MTg4MjQwMCAxNzMxNTk3MzU3NjczNjE0MmQ2NjQxMzkuNDc3NTQ1NzY=', NULL, '2024-11-14 11:15:57', 'Google Chrome,130.0.0.0,Windows:Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Safari/537.36'),
(1, 'access_token', 'ZXlKaGJHY2lPaUpJVXpJMU5pSXNJblI1Y0NJNklrcFhWQ0o5LWdlZGVvbi4xLjEuMC40NTcyOTQwMCAxNzMxMzc1NTEyNjczMmIxOTg2ZmE1NzIuNTM3NjE0ODI=', NULL, '2024-11-11 21:38:32', 'Google Chrome,130.0.0.0,Mac Os:Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Safari/537.36'),
(1, 'access_token', 'ZXlKaGJHY2lPaUpJVXpJMU5pSXNJblI1Y0NJNklrcFhWQ0o5LWdlZGVvbi4xLjEuMC40NzUwMDUwMCAxNzU3NTE4NjEyNjhjMTliMTQ3M2ZmMjAuMjQxMzA1NzQ=', NULL, '2025-09-10 11:36:52', 'Google Chrome,139.0.0.0,Mac Os:Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36'),
(1, 'access_token', 'ZXlKaGJHY2lPaUpJVXpJMU5pSXNJblI1Y0NJNklrcFhWQ0o5LWdlZGVvbi4xLjEuMC40NzYwMzEwMCAxNzI3OTU2MzEyNjZmZTg1NTg3NDM4ODcuMDc4NjEzNjI=', NULL, '2024-10-03 07:51:52', 'Google Chrome,129.0.0.0,Windows:Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Safari/537.36'),
(1, 'access_token', 'ZXlKaGJHY2lPaUpJVXpJMU5pSXNJblI1Y0NJNklrcFhWQ0o5LWdlZGVvbi4xLjEuMC41MjI4ODcwMCAxNzQyODIzODIzNjdlMTYxOGY3ZmE5NDQuMDI2OTc3MTI=', NULL, '2025-03-24 09:43:43', 'Google Chrome,134.0.0.0,Mac Os:Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36'),
(1, 'access_token', 'ZXlKaGJHY2lPaUpJVXpJMU5pSXNJblI1Y0NJNklrcFhWQ0o5LWdlZGVvbi4xLjEuMC41MTc3NjMwMCAxNjUyNTU5MjUwNjI4MDBkOTI3ZTY4YjkuNTE2ODQ2MDk=', NULL, '2022-05-14 16:14:10', 'Apple Safari,604.1,Mac Os:Mozilla/5.0 (iPhone; CPU iPhone OS 15_4 like Mac OS X) AppleWebKit/605.1.15 (KHTML, like Gecko) CriOS/101.0.4951.58 Mobile/15E148 Safari/604.1'),
(1, 'access_token', 'ZXlKaGJHY2lPaUpJVXpJMU5pSXNJblI1Y0NJNklrcFhWQ0o5LWdlZGVvbi4xLjEuMC41NDk3MzAwMCAxNzI4NDEzNzAwNjcwNTgwMDQ4NjM2YTIuNjExODU1NjU=', NULL, '2024-10-08 14:55:00', 'Google Chrome,129.0.0.0,Windows:Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Safari/537.36'),
(1, 'access_token', 'ZXlKaGJHY2lPaUpJVXpJMU5pSXNJblI1Y0NJNklrcFhWQ0o5LWdlZGVvbi4xLjEuMC41NzExMzkwMCAxNzU1NDcyMjU4NjhhMjYxODI4YjcwZjkuMzMxNjA4MjE=', NULL, '2025-08-17 19:10:58', 'Google Chrome,139.0.0.0,Mac Os:Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36'),
(1, 'access_token', 'ZXlKaGJHY2lPaUpJVXpJMU5pSXNJblI1Y0NJNklrcFhWQ0o5LWdlZGVvbi4xLjEuMC42MTIwNDUwMCAxNzM1NjUzODU2Njc3M2Y5ZTA5NTcwNDQuMjc0NTA4Mzk=', NULL, '2024-12-31 10:04:16', 'Google Chrome,131.0.0.0,Mac Os:Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Safari/537.36'),
(1, 'access_token', 'ZXlKaGJHY2lPaUpJVXpJMU5pSXNJblI1Y0NJNklrcFhWQ0o5LWdlZGVvbi4xLjEuMC42NDYzNDUwMCAxNjUyNDA3MDkwNjI3ZGJiMzI5ZGNkMzMuOTIzMjgzNzA=', NULL, '2022-05-12 21:58:10', 'Google Chrome,101.0.4951.64,Mac Os:Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/101.0.4951.64 Safari/537.36'),
(1, 'access_token', 'ZXlKaGJHY2lPaUpJVXpJMU5pSXNJblI1Y0NJNklrcFhWQ0o5LWdlZGVvbi4xLjEuMC42OTA5ODIwMCAxNzQ1MjQ2NTg5NjgwNjU5N2RhOGIyZDQuNDEwOTk0MTc=', NULL, '2025-04-21 10:43:09', 'Google Chrome,135.0.0.0,Mac Os:Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36'),
(1, 'access_token', 'ZXlKaGJHY2lPaUpJVXpJMU5pSXNJblI1Y0NJNklrcFhWQ0o5LWdlZGVvbi4xLjEuMC43NDcxODcwMCAxNzY0NjgxMTU1NjkyZWU1YzNiNjZiZDAuNTE3MjIzMjE=', NULL, '2025-12-02 09:12:35', 'Google Chrome,142.0.0.0,Mac Os:Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36'),
(1, 'access_token', 'ZXlKaGJHY2lPaUpJVXpJMU5pSXNJblI1Y0NJNklrcFhWQ0o5LWdlZGVvbi4xLjEuMC43NTYxMTcwMCAxNzQzMTI2MDU5NjdlNWZlMmJiODlhOTcuMzcxNTQwNjI=', NULL, '2025-03-27 21:40:59', 'Google Chrome,134.0.0.0,Mac Os:Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36'),
(1, 'access_token', 'ZXlKaGJHY2lPaUpJVXpJMU5pSXNJblI1Y0NJNklrcFhWQ0o5LWdlZGVvbi4xLjEuMC43ODk1NzEwMCAxNzQzODgzMTg2NjdmMThiYjJjMGM1MjEuMjcxODUyNjc=', NULL, '2025-04-05 15:59:46', 'Google Chrome,134.0.0.0,Mac Os:Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36'),
(1, 'access_token', 'ZXlKaGJHY2lPaUpJVXpJMU5pSXNJblI1Y0NJNklrcFhWQ0o5LWdlZGVvbi4xLjEuMC44Njc2ODIwMCAxNzQyMjY4NDcxNjdkOGU4MzdkM2Q2ODQuNzA2NjkxNjQ=', NULL, '2025-03-17 23:27:51', 'Google Chrome,134.0.0.0,Mac Os:Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36'),
(1, 'access_token', 'ZXlKaGJHY2lPaUpJVXpJMU5pSXNJblI1Y0NJNklrcFhWQ0o5LWdlZGVvbi4xLjEuMC44NzkxOTUwMCAxNzQwNTkyMDMyNjdiZjUzYTBkNmE2NzcuMzM3NTMwODQ=', NULL, '2025-02-26 13:47:12', 'Google Chrome,133.0.0.0,Mac Os:Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36'),
(1, 'access_token', 'ZXlKaGJHY2lPaUpJVXpJMU5pSXNJblI1Y0NJNklrcFhWQ0o5LWdlZGVvbi4xLjEuMC45MTExNTQwMCAxNzUwOTA4NTY5Njg1Y2JlOTlkZTc0YTkuMTA2MTMyMTc=', NULL, '2025-06-25 23:29:29', 'Google Chrome,137.0.0.0,Mac Os:Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/137.0.0.0 Safari/537.36'),
(1, 'access_token', 'ZXlKaGJHY2lPaUpJVXpJMU5pSXNJblI1Y0NJNklrcFhWQ0o5LWdlZGVvbi4xLjEuMC45MTkyMTAwMCAxNzQwNTM3OTQ2NjdiZTgwNWFlMDZjYTMuNTA5MTMzNzc=', NULL, '2025-02-25 22:45:46', 'Google Chrome,133.0.0.0,Mac Os:Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36'),
(1, 'access_token', 'ZXlKaGJHY2lPaUpJVXpJMU5pSXNJblI1Y0NJNklrcFhWQ0o5LWdlZGVvbi4xLjEuMC45MTQyNTcwMCAxNzQzNTMwOTMxNjdlYzJiYjNkZjM1NzUuODM2NzM0ODI=', NULL, '2025-04-01 14:08:51', 'Google Chrome,134.0.0.0,Mac Os:Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36'),
(1, 'access_token', 'ZXlKaGJHY2lPaUpJVXpJMU5pSXNJblI1Y0NJNklrcFhWQ0o5LWdlZGVvbi4xLjEuMC45MzkyMzQwMCAxNzMzOTQ4MTAxNjc1OWYyYzVlNTRlZjIuMjk3NzE0NDA=', NULL, '2024-12-11 16:15:01', 'Google Chrome,128.0.0.0,Mac Os:Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/128.0.0.0 Safari/537.36'),
(1, 'access_token', 'ZXlKaGJHY2lPaUpJVXpJMU5pSXNJblI1Y0NJNklrcFhWQ0o5LWdlZGVvbi4xLjEuMC45MzQzMTMwMCAxNzYwODIxNDk1NjhmNDAwZjdlNDFiMzQuMTU5MDA2MDk=', NULL, '2025-10-18 17:04:55', 'Google Chrome,141.0.0.0,Mac Os:Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/141.0.0.0 Safari/537.36'),
(1, 'access_token', 'ZXlKaGJHY2lPaUpJVXpJMU5pSXNJblI1Y0NJNklrcFhWQ0o5LWdlZGVvbi4xLjEuMC45NzY4MzMwMCAxNzQ1NTA2NzM1NjgwYTUxYWZlZTdjYzcuMjUyMjA1Nzk=', NULL, '2025-04-24 10:58:55', 'Google Chrome,135.0.0.0,Mac Os:Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36'),
(1, 'access_token', 'ZXlKaGJHY2lPaUpJVXpJMU5pSXNJblI1Y0NJNklrcFhWQ0o5LWdlZGVvbi4xLjEuMC4wMjE1NjIwMCAxNzY0NDY0NDA1NjkyYjk3MTUwNTQ0NjcuMDc4OTIwMTg=', NULL, '2025-11-29 21:00:05', 'Google Chrome,142.0.0.0,Mac Os:Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36'),
(1, 'access_token', 'ZXlKaGJHY2lPaUpJVXpJMU5pSXNJblI1Y0NJNklrcFhWQ0o5LWdlZGVvbi4xLjEuMC4wMjk0MDcwMCAxNzY0OTc3ODc4NjkzMzZjZDYwNzJlODMuNTM5Mjc2MDc=', NULL, '2025-12-05 19:37:58', 'Google Chrome,142.0.0.0,Mac Os:Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36'),
(1, 'access_token', 'ZXlKaGJHY2lPaUpJVXpJMU5pSXNJblI1Y0NJNklrcFhWQ0o5LWdlZGVvbi4xLjEuMC4wMjk5MDYwMCAxNzM1NTc1MjE1Njc3MmM2YWYwNzRmNDcuNjQ2MjU5MTQ=', NULL, '2024-12-30 12:13:35', 'Google Chrome,128.0.0.0,Mac Os:Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/128.0.0.0 Safari/537.36'),
(1, 'access_token', 'ZXlKaGJHY2lPaUpJVXpJMU5pSXNJblI1Y0NJNklrcFhWQ0o5LWdlZGVvbi4xLjEuMC4wNTMzNzEwMCAxNzY0NTI3NzIyNjkyYzhlNmEwZDA4OTUuMTI0MDkzNTA=', NULL, '2025-11-30 14:35:22', 'Google Chrome,142.0.0.0,Mac Os:Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36'),
(1, 'access_token', 'ZXlKaGJHY2lPaUpJVXpJMU5pSXNJblI1Y0NJNklrcFhWQ0o5LWdlZGVvbi4xLjEuMC4wOTk3NzEwMCAxNzYwODAyNjQ3NjhmM2I3NTcxODVjNjguOTE0NjUwMjg=', NULL, '2025-10-18 11:50:47', 'Google Chrome,141.0.0.0,Mac Os:Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/141.0.0.0 Safari/537.36'),
(1, 'access_token', 'ZXlKaGJHY2lPaUpJVXpJMU5pSXNJblI1Y0NJNklrcFhWQ0o5LWdlZGVvbi4xLjEuMC4xMjU4ODkwMCAxNzM2OTQ4NjQ1Njc4N2JiYTUxZWJkOTIuNTE4MDY0NDA=', NULL, '2025-01-15 09:44:05', 'Google Chrome,131.0.0.0,Mac Os:Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Safari/537.36'),
(1, 'access_token', 'ZXlKaGJHY2lPaUpJVXpJMU5pSXNJblI1Y0NJNklrcFhWQ0o5LWdlZGVvbi4xLjEuMC4xMTc3ODcwMCAxNzQzNTMyMzY3NjdlYzMxNGYxY2MyNjguNzE5NDYxMTI=', NULL, '2025-04-01 14:32:47', 'Google Chrome,134.0.0.0,Linux:Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36'),
(1, 'access_token', 'ZXlKaGJHY2lPaUpJVXpJMU5pSXNJblI1Y0NJNklrcFhWQ0o5LWdlZGVvbi4xLjEuMC4xMTUxOTgwMCAxNzI3NjI1MDc4NjZmOTc3NzYxYzIwNzkuOTIwNTUyMzU=', NULL, '2024-09-29 11:51:18', 'Google Chrome,129.0.0.0,Mac Os:Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Safari/537.36'),
(1, 'access_token', 'ZXlKaGJHY2lPaUpJVXpJMU5pSXNJblI1Y0NJNklrcFhWQ0o5LWdlZGVvbi4xLjEuMC4xNjQ5ODUwMCAxNzQzNjI0ODQ4NjdlZDlhOTAyODQ4MjMuODQ0MjI2MDM=', NULL, '2025-04-02 16:14:08', 'Google Chrome,134.0.0.0,Mac Os:Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36'),
(1, 'access_token', 'ZXlKaGJHY2lPaUpJVXpJMU5pSXNJblI1Y0NJNklrcFhWQ0o5LWdlZGVvbi4xLjEuMC4xNjYwNzQwMCAxNzQ0NjAzMDQ0NjdmYzg3YTQyODhkMDkuMzE5MDcxNjU=', NULL, '2025-04-13 23:57:24', 'Google Chrome,135.0.0.0,Mac Os:Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36'),
(1, 'access_token', 'ZXlKaGJHY2lPaUpJVXpJMU5pSXNJblI1Y0NJNklrcFhWQ0o5LWdlZGVvbi4xLjEuMC4xNzU3MDkwMCAxNzYxMzUwMjExNjhmYzEyNDMyYWU2YzkuNTAzMjkxMzk=', NULL, '2025-10-24 19:56:51', 'Google Chrome,141.0.0.0,Mac Os:Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/141.0.0.0 Safari/537.36'),
(1, 'access_token', 'ZXlKaGJHY2lPaUpJVXpJMU5pSXNJblI1Y0NJNklrcFhWQ0o5LWdlZGVvbi4xLjEuMC4xOTE5MTkwMCAxNzYxNTc0MjMzNjhmZjdkNTkyZWRjODAuMTU0MDIxOTE=', NULL, '2025-10-27 10:10:33', 'Google Chrome,141.0.0.0,Mac Os:Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/141.0.0.0 Safari/537.36'),
(1, 'access_token', 'ZXlKaGJHY2lPaUpJVXpJMU5pSXNJblI1Y0NJNklrcFhWQ0o5LWdlZGVvbi4xLjEuMC4xOTI5MjYwMCAxNzQwMzk5OTYyNjdiYzY1NWEyZjFlNTguOTQwMDc3Nzg=', NULL, '2025-02-24 08:26:02', 'Google Chrome,133.0.0.0,Mac Os:Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36'),
(1, 'access_token', 'ZXlKaGJHY2lPaUpJVXpJMU5pSXNJblI1Y0NJNklrcFhWQ0o5LWdlZGVvbi4xLjEuMC4yMDIxNjMwMCAxNzY1MDM3MzM2NjkzNDU1MTgzMTVjOTUuNTIwOTM5NDQ=', NULL, '2025-12-06 12:08:56', 'Google Chrome,142.0.0.0,Mac Os:Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36'),
(1, 'access_token', 'ZXlKaGJHY2lPaUpJVXpJMU5pSXNJblI1Y0NJNklrcFhWQ0o5LWdlZGVvbi4xLjEuMC4yMDQ4OTcwMCAxNzI4NzQyMjg1NjcwYTgzOGQzMjA2YzAuMjk5Mzc1NDg=', NULL, '2024-10-12 10:11:25', 'Google Chrome,129.0.0.0,Mac Os:Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Safari/537.36'),
(1, 'access_token', 'ZXlKaGJHY2lPaUpJVXpJMU5pSXNJblI1Y0NJNklrcFhWQ0o5LWdlZGVvbi4xLjEuMC4yODI0OTUwMCAxNzUwNDc1ODAwNjg1NjI0MTg0NGY4NjcuMzA2MzQ2Njg=', NULL, '2025-06-20 23:16:40', 'Google Chrome,137.0.0.0,Mac Os:Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/137.0.0.0 Safari/537.36'),
(1, 'access_token', 'ZXlKaGJHY2lPaUpJVXpJMU5pSXNJblI1Y0NJNklrcFhWQ0o5LWdlZGVvbi4xLjEuMC4yOTM0ODIwMCAxNzI3NzY4NTU2NjZmYmE3ZWM0N2E3MzMuOTM5NDg0MDk=', NULL, '2024-10-01 03:42:36', 'Google Chrome,129.0.0.0,Mac Os:Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Safari/537.36'),
(1, 'access_token', 'ZXlKaGJHY2lPaUpJVXpJMU5pSXNJblI1Y0NJNklrcFhWQ0o5LWdlZGVvbi4xLjEuMC4yOTU3NDMwMCAxNzY0NzEyMDEwNjkyZjVlNGE0ODM0NjQuMDAwMjIzMDU=', NULL, '2025-12-02 17:46:50', 'Google Chrome,142.0.0.0,Mac Os:Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36'),
(1, 'access_token', 'ZXlKaGJHY2lPaUpJVXpJMU5pSXNJblI1Y0NJNklrcFhWQ0o5LWdlZGVvbi4xLjEuMC4zMDgyOTcwMCAxNzM1NjExNjMwNjc3MzU0ZWU0YjQ3OTMuODY5NDI1MTA=', NULL, '2024-12-30 22:20:30', 'Google Chrome,131.0.0.0,Mac Os:Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Safari/537.36'),
(1, 'access_token', 'ZXlKaGJHY2lPaUpJVXpJMU5pSXNJblI1Y0NJNklrcFhWQ0o5LWdlZGVvbi4xLjEuMC4zMjMzMTkwMCAxNzI4MTgxNDkwNjcwMWY0ZjI0ZWYwMDkuNTE4MDU3OTk=', NULL, '2024-10-05 22:24:50', 'Google Chrome,129.0.0.0,Windows:Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Safari/537.36'),
(1, 'access_token', 'ZXlKaGJHY2lPaUpJVXpJMU5pSXNJblI1Y0NJNklrcFhWQ0o5LWdlZGVvbi4xLjEuMC4zMTg3NDQwMCAxNzQzMDA3MzcyNjdlNDJlOGM0ZGQyNTIuMDA2OTc1MzM=', NULL, '2025-03-26 12:42:52', 'Google Chrome,134.0.0.0,Mac Os:Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36'),
(1, 'access_token', 'ZXlKaGJHY2lPaUpJVXpJMU5pSXNJblI1Y0NJNklrcFhWQ0o5LWdlZGVvbi4xLjEuMC4zMzI4MTAwMCAxNzYxNDAzOTAxNjhmY2UzZmQ1MTQzNzQuMTI2NDMxNTE=', NULL, '2025-10-25 10:51:41', 'Google Chrome,141.0.0.0,Mac Os:Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/141.0.0.0 Safari/537.36'),
(1, 'access_token', 'ZXlKaGJHY2lPaUpJVXpJMU5pSXNJblI1Y0NJNklrcFhWQ0o5LWdlZGVvbi4xLjEuMC4zNjI1MTkwMCAxNzU5ODU5MTM2NjhlNTUxYzA1ODgyMzQuODc4MDIwNTY=', NULL, '2025-10-07 13:45:36', 'Google Chrome,140.0.0.0,Mac Os:Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36'),
(1, 'access_token', 'ZXlKaGJHY2lPaUpJVXpJMU5pSXNJblI1Y0NJNklrcFhWQ0o5LWdlZGVvbi4xLjEuMC4zNjkxNzAwMCAxNzQ0NjU1NDI5NjdmZDU0NDU1YTIxYzAuNzU1NzY3MDE=', NULL, '2025-04-14 14:30:29', 'Google Chrome,135.0.0.0,Mac Os:Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36'),
(1, 'access_token', 'ZXlKaGJHY2lPaUpJVXpJMU5pSXNJblI1Y0NJNklrcFhWQ0o5LWdlZGVvbi4xLjEuMC4zNTAwMzkwMCAxNzM3NTA5ODI4Njc5MDRiYzQ1NTg1YzQuMjk2NjIyNjg=', NULL, '2025-01-21 21:37:08', 'Google Chrome,132.0.0.0,Mac Os:Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/132.0.0.0 Safari/537.36'),
(1, 'access_token', 'ZXlKaGJHY2lPaUpJVXpJMU5pSXNJblI1Y0NJNklrcFhWQ0o5LWdlZGVvbi4xLjEuMC4zNTUwNzQwMCAxNzMxNjMzNjI1NjczNmExZDk1NmIxODguNTI3NjUwMzk=', NULL, '2024-11-14 21:20:25', 'Google Chrome,131.0.0.0,Mac Os:Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Safari/537.36'),
(1, 'access_token', 'ZXlKaGJHY2lPaUpJVXpJMU5pSXNJblI1Y0NJNklrcFhWQ0o5LWdlZGVvbi4xLjEuMC4zOTAzOTkwMCAxNzMzOTQ4MTUyNjc1OWYyZjg1ZjUwOTEuMjM1NjgzMjM=', NULL, '2024-12-11 16:15:52', 'Google Chrome,128.0.0.0,Mac Os:Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/128.0.0.0 Safari/537.36'),
(1, 'refresh_token', '023b1b60bfbc82eae087c3a3288b481b', NULL, '2024-10-08 14:55:00', 'Google Chrome,129.0.0.0,Windows:Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Safari/537.36'),
(1, 'refresh_token', '0501c9be8b395ac86993ba9a6491c492', NULL, '2024-10-05 22:24:50', 'Google Chrome,129.0.0.0,Windows:Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Safari/537.36'),
(1, 'refresh_token', '126dd14bdd34a4da0f01cf05887c764c', NULL, '2024-11-11 21:38:32', 'Google Chrome,130.0.0.0,Mac Os:Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Safari/537.36'),
(1, 'refresh_token', '168015f922e05647894c20dfde16ea3b', NULL, '2025-06-25 23:29:29', 'Google Chrome,137.0.0.0,Mac Os:Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/137.0.0.0 Safari/537.36'),
(1, 'refresh_token', '2142904861bb9aa803265718bae2658e', NULL, '2025-10-24 19:56:51', 'Google Chrome,141.0.0.0,Mac Os:Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/141.0.0.0 Safari/537.36'),
(1, 'refresh_token', '2230c726260957d39c32efe2e004f1cf', NULL, '2025-01-21 21:37:08', 'Google Chrome,132.0.0.0,Mac Os:Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/132.0.0.0 Safari/537.36'),
(1, 'refresh_token', '28a939bdd3973b6388a06435d1f29d82', NULL, '2025-09-10 11:36:52', 'Google Chrome,139.0.0.0,Mac Os:Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36'),
(1, 'refresh_token', '2fd9ef6787daabe7812e599e9e90cced', NULL, '2024-09-29 11:51:18', 'Google Chrome,129.0.0.0,Mac Os:Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Safari/537.36'),
(1, 'refresh_token', '316d0fa527f3928f33af5c87edc9e01c', NULL, '2024-10-12 10:11:25', 'Google Chrome,129.0.0.0,Mac Os:Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Safari/537.36'),
(1, 'refresh_token', '3743440cc544c5510810c055c8df967e', NULL, '2025-12-05 19:37:58', 'Google Chrome,142.0.0.0,Mac Os:Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36'),
(1, 'refresh_token', '3c5f6e0d1fd05dcde5691b7bf0a29fcf', NULL, '2025-04-02 16:14:08', 'Google Chrome,134.0.0.0,Mac Os:Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36'),
(1, 'refresh_token', '3fe07c7c6089b99d0ed08e03df0c04bb', NULL, '2025-08-17 19:10:58', 'Google Chrome,139.0.0.0,Mac Os:Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/139.0.0.0 Safari/537.36'),
(1, 'refresh_token', '46b55c3b9bded190aeb0a2d6cf743441', NULL, '2025-03-26 12:42:52', 'Google Chrome,134.0.0.0,Mac Os:Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36'),
(1, 'refresh_token', '485561b0115755998c2ee911c82952eb', NULL, '2025-06-20 23:16:40', 'Google Chrome,137.0.0.0,Mac Os:Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/137.0.0.0 Safari/537.36'),
(1, 'refresh_token', '4e624a7f6185c8ee65d3b56bc318c2f4', NULL, '2024-11-14 11:15:57', 'Google Chrome,130.0.0.0,Windows:Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/130.0.0.0 Safari/537.36'),
(1, 'refresh_token', '57e68eb28c1e53299804893a80d343bb', NULL, '2025-10-27 10:10:33', 'Google Chrome,141.0.0.0,Mac Os:Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/141.0.0.0 Safari/537.36'),
(1, 'refresh_token', '5e1de14aedc3963c18954e7909ec69b4', NULL, '2025-01-15 09:44:05', 'Google Chrome,131.0.0.0,Mac Os:Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Safari/537.36'),
(1, 'refresh_token', '61cbe23fc39bbb58e4fb10de5cc2d5ea', NULL, '2024-12-30 22:20:30', 'Google Chrome,131.0.0.0,Mac Os:Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Safari/537.36'),
(1, 'refresh_token', '61f442c7686cf6f4b7ad9c20e7f69876', NULL, '2025-10-18 17:04:55', 'Google Chrome,141.0.0.0,Mac Os:Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/141.0.0.0 Safari/537.36'),
(1, 'refresh_token', '64ac0295f12cb624289f85ddd233deea', NULL, '2024-12-31 10:04:16', 'Google Chrome,131.0.0.0,Mac Os:Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Safari/537.36'),
(1, 'refresh_token', '6758e8259e40da026a5bbea52f3db8ff', NULL, '2025-10-22 15:31:49', 'Google Chrome,141.0.0.0,Mac Os:Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/141.0.0.0 Safari/537.36'),
(1, 'refresh_token', '6ac21d0e1f3fdcbd5abc091a63f704b1', NULL, '2025-03-27 21:40:59', 'Google Chrome,134.0.0.0,Mac Os:Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36'),
(1, 'refresh_token', '70613f8dc59784a39a82daf14d34dff7', NULL, '2024-10-01 03:42:36', 'Google Chrome,129.0.0.0,Mac Os:Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Safari/537.36'),
(1, 'refresh_token', '70c2fb5e8333d157882c1b67d2df8ab2', NULL, '2025-02-26 13:47:12', 'Google Chrome,133.0.0.0,Mac Os:Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36'),
(1, 'refresh_token', '7305830aa602db68acbe1de92a3f6248', NULL, '2024-11-14 21:20:25', 'Google Chrome,131.0.0.0,Mac Os:Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/131.0.0.0 Safari/537.36'),
(1, 'refresh_token', '75da2963797476ec244d1d65ba108ce9', NULL, '2025-11-29 21:00:05', 'Google Chrome,142.0.0.0,Mac Os:Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36'),
(1, 'refresh_token', '78ae1c817c2392cd5e8c660219db5341', NULL, '2025-02-25 22:45:46', 'Google Chrome,133.0.0.0,Mac Os:Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36'),
(1, 'refresh_token', '79aa3773954e145abc7027d37755e47a', NULL, '2025-12-02 17:46:50', 'Google Chrome,142.0.0.0,Mac Os:Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36'),
(1, 'refresh_token', '7d61840634ba3fff4ac371d883f9d8de', NULL, '2025-10-18 11:50:47', 'Google Chrome,141.0.0.0,Mac Os:Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/141.0.0.0 Safari/537.36'),
(1, 'refresh_token', '859455b6489fd85814584e6766c13f3a', NULL, '2024-12-30 12:13:35', 'Google Chrome,128.0.0.0,Mac Os:Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/128.0.0.0 Safari/537.36'),
(1, 'refresh_token', '8a09695946fcc5ace035ecd8fda80585', NULL, '2025-04-01 14:32:47', 'Google Chrome,134.0.0.0,Linux:Mozilla/5.0 (X11; Linux x86_64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36'),
(1, 'refresh_token', '8b3e78800e9a6e563f9192b49e9b4b93', NULL, '2025-04-24 10:58:55', 'Google Chrome,135.0.0.0,Mac Os:Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36'),
(1, 'refresh_token', '907e95c3428ac129ff9a15374624d65f', NULL, '2025-03-24 09:43:43', 'Google Chrome,134.0.0.0,Mac Os:Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36'),
(1, 'refresh_token', '95eedf105238b46bf165a74e79f960ec', NULL, '2024-12-11 16:15:01', 'Google Chrome,128.0.0.0,Mac Os:Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/128.0.0.0 Safari/537.36'),
(1, 'refresh_token', '9fd21f971943838a34cfee038e2b1b80', NULL, '2025-04-14 14:30:29', 'Google Chrome,135.0.0.0,Mac Os:Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36'),
(1, 'refresh_token', 'a42e09213eaa70b150075c76e9673b35', NULL, '2025-04-05 15:59:46', 'Google Chrome,134.0.0.0,Mac Os:Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36'),
(1, 'refresh_token', 'aa3df4417cfab14db14cb4244112038e', NULL, '2025-11-30 14:35:22', 'Google Chrome,142.0.0.0,Mac Os:Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36'),
(1, 'refresh_token', 'aab19d4353b0f2e556d10858af986efd', NULL, '2025-03-17 23:27:51', 'Google Chrome,134.0.0.0,Mac Os:Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36'),
(1, 'refresh_token', 'ac0697cc4036311213ecd9914d69b9a6', NULL, '2025-12-06 12:08:56', 'Google Chrome,142.0.0.0,Mac Os:Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36'),
(1, 'refresh_token', 'b9dd2ca29ef34d2b3a4b3d30f356fbfb', NULL, '2025-04-21 10:43:09', 'Google Chrome,135.0.0.0,Mac Os:Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36'),
(1, 'refresh_token', 'bf9b6046a74cd534166725e363f04ed0', NULL, '2025-12-02 09:12:35', 'Google Chrome,142.0.0.0,Mac Os:Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/142.0.0.0 Safari/537.36'),
(1, 'refresh_token', 'd3c171f4448dc47e58ee4f7e8a4bfc80', NULL, '2025-10-25 10:51:41', 'Google Chrome,141.0.0.0,Mac Os:Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/141.0.0.0 Safari/537.36'),
(1, 'refresh_token', 'e0826f41574424e197a3f0272b5b3b97', NULL, '2025-10-07 13:45:36', 'Google Chrome,140.0.0.0,Mac Os:Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/140.0.0.0 Safari/537.36'),
(1, 'refresh_token', 'e24a3fe3f30acf4157001e4b6d5a6105', NULL, '2025-04-01 14:08:51', 'Google Chrome,134.0.0.0,Mac Os:Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/134.0.0.0 Safari/537.36'),
(1, 'refresh_token', 'e4c56dd641674bb4ec8d67dc7493ca8f', NULL, '2025-02-24 08:26:02', 'Google Chrome,133.0.0.0,Mac Os:Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/133.0.0.0 Safari/537.36'),
(1, 'refresh_token', 'e530380a6f2c8ab20f3b58c62de7a0a4', NULL, '2024-12-11 16:15:52', 'Google Chrome,128.0.0.0,Mac Os:Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/128.0.0.0 Safari/537.36'),
(1, 'refresh_token', 'f57ecab4d24d657251849c3bdac63856', NULL, '2024-10-03 07:51:52', 'Google Chrome,129.0.0.0,Windows:Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/129.0.0.0 Safari/537.36'),
(1, 'refresh_token', 'fb8a5979d4b434bcde4149d91a6cc8f1', NULL, '2025-04-13 23:57:24', 'Google Chrome,135.0.0.0,Mac Os:Mozilla/5.0 (Macintosh; Intel Mac OS X 10_15_7) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/135.0.0.0 Safari/537.36');

--
-- Indices de la tabla `users_tokens`
--
ALTER TABLE `users_tokens`
  ADD PRIMARY KEY (`user_tk_type`,`user_tk_token`) USING BTREE;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `worksheets`
--

CREATE TABLE `worksheets` (
  `ws_id` int NOT NULL,
  `ws_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci DEFAULT NULL,
  `ws_level` int DEFAULT NULL,
  `ws_class` varchar(44) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `ws_ent_id` int NOT NULL DEFAULT '0',
  `ws_state` int DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Volcado de datos para la tabla `worksheets`
--

INSERT INTO `worksheets` (`ws_id`, `ws_name`, `ws_level`, `ws_class`, `ws_ent_id`, `ws_state`) VALUES
(1, 'planilla 1', 1, 'ws1', 1, 1),
(2, 'planilla 2', 2, 'ws2', 1, 1),
(3, 'planilla 3', 3, 'ws3', 1, 1);

--
-- Indices de la tabla `worksheets`
--
ALTER TABLE `worksheets`
  ADD PRIMARY KEY (`ws_id`) USING BTREE;

--
-- AUTO_INCREMENT de la tabla `worksheets`
--
ALTER TABLE `worksheets`
  MODIFY `ws_id` int NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4;

-- --------------------------------------------------------

--
-- Estructura de tabla para la tabla `worksheets_blocks`
--

CREATE TABLE `worksheets_blocks` (
  `ws_block_ws_id` int NOT NULL,
  `ws_block_block_id` int NOT NULL,
  `ws_block_order` int NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

--
-- Volcado de datos para la tabla `worksheets_blocks`
--

INSERT INTO `worksheets_blocks` (`ws_block_ws_id`, `ws_block_block_id`, `ws_block_order`) VALUES
(1, 1, 1),
(1, 2, 2),
(1, 3, 3);

--
-- Indices de la tabla `worksheets_blocks`
--
ALTER TABLE `worksheets_blocks`
  ADD PRIMARY KEY (`ws_block_ws_id`,`ws_block_block_id`) USING BTREE;
