/* Navicat Premium Data Transfer Source Server : EIS CLOUD MYSQL Source Server Type : MySQL Source Server Version : 50626 Source Host : 151.106.62.86:3306 Source Schema : easyphonedb Target Server Type : MySQL Target Server Version : 50626 File Encoding : 65001 Date: 26/03/2025 15:05:26 */ SET NAMES utf8mb4; SET FOREIGN_KEY_CHECKS = 0; -- ---------------------------- -- Table structure for a_clone_group -- ---------------------------- DROP TABLE IF EXISTS `a_clone_group`; CREATE TABLE `a_clone_group` ( `id` int(11) NOT NULL, `caracteristica` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `description` varchar(4000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `homePage` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `isAdmin` tinyint(11) NULL DEFAULT NULL, `name` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `notificaciones` tinyint(11) NULL DEFAULT NULL, `active` tinyint(11) NULL DEFAULT NULL ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact; -- ---------------------------- -- Records of a_clone_group -- ---------------------------- -- ---------------------------- -- Table structure for aaa_hojarandom -- ---------------------------- DROP TABLE IF EXISTS `aaa_hojarandom`; CREATE TABLE `aaa_hojarandom` ( `phone` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL, `name` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL, `address` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL, `test` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL ) ENGINE = MyISAM CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of aaa_hojarandom -- ---------------------------- -- ---------------------------- -- Table structure for caracteristica -- ---------------------------- DROP TABLE IF EXISTS `caracteristica`; CREATE TABLE `caracteristica` ( `id` int(11) NOT NULL AUTO_INCREMENT, `nombre` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `description` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `code` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of caracteristica -- ---------------------------- INSERT INTO `caracteristica` VALUES (1, 'Admin', 'Admin', 'AA'); INSERT INTO `caracteristica` VALUES (2, 'Otros', 'Otros', 'OO'); -- ---------------------------- -- Table structure for code_generator -- ---------------------------- DROP TABLE IF EXISTS `code_generator`; CREATE TABLE `code_generator` ( `id` int(11) NOT NULL AUTO_INCREMENT, `nomenclatura` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `modulo` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `compania` int(11) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 132 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact; -- ---------------------------- -- Records of code_generator -- ---------------------------- INSERT INTO `code_generator` VALUES (118, 'DOC-@YY@M-@S', 'Módulo de Calidad -> Documentos', 35); INSERT INTO `code_generator` VALUES (119, 'PRO-@S', 'Módulo de Calidad -> Procesos', 35); INSERT INTO `code_generator` VALUES (122, 'SOL-@YY@M-@S', 'Módulo de Calidad -> Solicitud de Documentos', 35); INSERT INTO `code_generator` VALUES (123, 'PRO-@S', 'Módulo de Calidad -> Solicitud de Procesos', 35); INSERT INTO `code_generator` VALUES (124, 'DOC-@S', 'Módulo de Calidad -> Documentos', 56); INSERT INTO `code_generator` VALUES (125, 'PRO-@S', 'Módulo de Calidad -> Procesos', 56); INSERT INTO `code_generator` VALUES (126, 'DOC-@S', 'Módulo de Calidad -> Solicitud de Documentos', 56); INSERT INTO `code_generator` VALUES (127, 'PRO-@S', 'Módulo de Calidad -> Solicitud de Procesos', 56); INSERT INTO `code_generator` VALUES (128, 'DOC-@S', 'Módulo de Calidad -> Documentos', 13); INSERT INTO `code_generator` VALUES (129, 'PRO-@S', 'Módulo de Calidad -> Procesos', 13); INSERT INTO `code_generator` VALUES (130, 'DOC-@S', 'Módulo de Calidad -> Solicitud de Documentos', 13); INSERT INTO `code_generator` VALUES (131, 'PRO-@S', 'Módulo de Calidad -> Solicitud de Procesos', 13); -- ---------------------------- -- Table structure for compania_config -- ---------------------------- DROP TABLE IF EXISTS `compania_config`; CREATE TABLE `compania_config` ( `notificaciones_correo` tinyint(1) NULL DEFAULT 1, `notificaciones_push` tinyint(1) NULL DEFAULT 0, `formularios` tinyint(1) NULL DEFAULT 0, `historial_acceso` tinyint(1) NULL DEFAULT 1, `mesa_ayuda` tinyint(1) NULL DEFAULT 1, `repositorio_archivos` tinyint(1) NULL DEFAULT 0, `interfaces` tinyint(1) NULL DEFAULT 0, `color_principal` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '#192649', `color_secundario` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '#9c282d', `hora_notificacion` varchar(15) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '08:00', `onesignal_key` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'ZjI5ZDQyNDktOTE2ZC00MGM2LTkwNmQtYjNlZDRhYjdjZjM0', `onesignal_appauth` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'NzJkYTEwMDQtY2JiYS00YTA3LTkzODMtZGRlODNhNWEzZDZl', `onesignal_appid` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '27b730f2-ca4a-4fc5-989f-3cc59e3a89db', `smtp_host` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'smtp.gmail.com', `smtp_port` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT '465', `smtp_ssl` tinyint(11) NULL DEFAULT 1, `smtp_email` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'tec@eisdr.com', `smtp_password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'TeCDe2s.c0m@2', `smtp_sender` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'tec@eisdr.com', `smtp_sender_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT 'SYPLANS', `notificaciones` tinyint(1) NULL DEFAULT NULL, `id` int(1) NOT NULL AUTO_INCREMENT, `dias_de_gracia` int(11) NULL DEFAULT NULL, `db_user` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `db_password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `db_server` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `db_database` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `db_port` int(11) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 2 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact; -- ---------------------------- -- Records of compania_config -- ---------------------------- INSERT INTO `compania_config` VALUES (1, 1, 1, 1, 1, 1, 1, '#114c01', '#114c01', '08:00', 'ZjI5ZDQyNDktOTE2ZC00MGM2LTkwNmQtYjNlZDRhYjdjZjM0', 'NzJkYTEwMDQtY2JiYS00YTA3LTkzODMtZGRlODNhNWEzZDZl', '27b730f2-ca4a-4fc5-989f-3cc59e3a89db', 'smtp.gmail.com', '465', 1, 'tec@eisdr.com', 'TeCDe2s.c0m@2', 'tec@eisdr.com', 'SYPLANS', 1, 1, 3, 'as', '%Luch@134679()^^()Mortero$', '151.106.62.86', 'dragon', 1433); -- ---------------------------- -- Table structure for dragon_audit -- ---------------------------- DROP TABLE IF EXISTS `dragon_audit`; CREATE TABLE `dragon_audit` ( `id` bigint(11) NOT NULL AUTO_INCREMENT, `modelname` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `varname` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `action` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `username` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `dataJson` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL, `date` datetime NULL DEFAULT CURRENT_TIMESTAMP, `version` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ip` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `compania` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `pei` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `poa` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `custom_sub_action` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `updatedJson` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL, `user_id` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 236 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact; -- ---------------------------- -- Table structure for group -- ---------------------------- DROP TABLE IF EXISTS `group`; CREATE TABLE `group` ( `id` int(11) NOT NULL AUTO_INCREMENT, `caracteristica` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `description` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL, `homePage` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `isAdmin` tinyint(4) NULL DEFAULT NULL, `name` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL, `notificaciones` tinyint(4) NULL DEFAULT NULL, `active` tinyint(4) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = MyISAM AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of group -- ---------------------------- INSERT INTO `group` VALUES (1, NULL, 'Administrador', '#hometwo', 1, 'Administrador', NULL, 1); INSERT INTO `group` VALUES (4, NULL, 'Cliente', '#hometwo', 0, 'Suplidor', NULL, 1); -- ---------------------------- -- Table structure for ia_llaves -- ---------------------------- DROP TABLE IF EXISTS `ia_llaves`; CREATE TABLE `ia_llaves` ( `id` int(11) NOT NULL AUTO_INCREMENT, `llave` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `full` int(11) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = MyISAM AUTO_INCREMENT = 12 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of ia_llaves -- ---------------------------- INSERT INTO `ia_llaves` VALUES (1, '050a959c8amshc63e1077497d200p1f174ajsnaac283750ae4', 1); INSERT INTO `ia_llaves` VALUES (2, '28ccc2c1c2mshe2fb37e2a19557fp10e3fbjsn296d6173f5dc', 1); INSERT INTO `ia_llaves` VALUES (3, '1983932697mshf3ace7d3cdc388ep10e0a0jsn139a082b3ed4', 0); INSERT INTO `ia_llaves` VALUES (4, '6d59663e89msh5a36a734d05c09ep1ef4dbjsn7411085ceced', 0); INSERT INTO `ia_llaves` VALUES (5, 'dcf99cb3e7msh08cad86b1e99ec9p1aa666jsn8757fd3bc7e2', 0); INSERT INTO `ia_llaves` VALUES (6, 'ed45948cd7msh99d59836b48e36fp1e029ajsnd8fe501e9c4f', 0); INSERT INTO `ia_llaves` VALUES (7, '1612f8a02dmshfdd217d1536edc7p1d5211jsn4719ba200211', 0); INSERT INTO `ia_llaves` VALUES (8, 'a685681a9dmshf39fb816c87c933p137a3cjsn0d4d6ee16f81', 0); INSERT INTO `ia_llaves` VALUES (9, '0117bd1c33msh5b8c728b8fa6c33p107da4jsn93eba1d19e86', 0); INSERT INTO `ia_llaves` VALUES (10, '2e2694555fmsh92f7e40347ff631p1ff7cbjsnb23b7d13cce8', 0); INSERT INTO `ia_llaves` VALUES (11, '4245a2c86dmshaca018dd3c137a2p1f0d96jsn59a0ead6a510', 0); -- ---------------------------- -- Table structure for import_actions -- ---------------------------- DROP TABLE IF EXISTS `import_actions`; CREATE TABLE `import_actions` ( `id` int(11) NOT NULL AUTO_INCREMENT, `user_id` int(255) NULL DEFAULT NULL, `fecha` datetime(6) NULL DEFAULT NULL, `mensaje` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL, `description` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL, `field_phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `field_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `owner_id` int(11) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = DYNAMIC; -- ---------------------------- -- Records of import_actions -- ---------------------------- -- ---------------------------- -- Table structure for language -- ---------------------------- DROP TABLE IF EXISTS `language`; CREATE TABLE `language` ( `id` int(11) NOT NULL AUTO_INCREMENT, `nombre` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `label` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `api` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `voice` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = MyISAM AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of language -- ---------------------------- INSERT INTO `language` VALUES (1, 'en', 'Ingles', NULL, NULL); INSERT INTO `language` VALUES (2, 'es', 'Español', NULL, NULL); -- ---------------------------- -- Table structure for login_history -- ---------------------------- DROP TABLE IF EXISTS `login_history`; CREATE TABLE `login_history` ( `id` int(11) NOT NULL AUTO_INCREMENT, `usuario` int(11) NULL DEFAULT NULL, `date` datetime(6) NULL DEFAULT NULL, `ip` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 60 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact; -- ---------------------------- -- Records of login_history -- ---------------------------- -- ---------------------------- -- Table structure for module_lan -- ---------------------------- DROP TABLE IF EXISTS `module_lan`; CREATE TABLE `module_lan` ( `id` int(11) NOT NULL AUTO_INCREMENT, `category` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `key` varchar(280) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `es` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `en` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `ia` tinyint(1) NULL DEFAULT NULL, `exist` int(11) NULL DEFAULT NULL, `human` tinyint(1) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE, UNIQUE INDEX `category`(`category`, `key`) USING BTREE ) ENGINE = MyISAM AUTO_INCREMENT = 271 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of module_lan -- ---------------------------- INSERT INTO `module_lan` VALUES (1, 'mono', 'cancel', 'cancelar', 'cancel', 1, 0, 0); INSERT INTO `module_lan` VALUES (2, 'mono', 'choose', 'elegir', 'choose', 1, 0, 0); INSERT INTO `module_lan` VALUES (3, 'mono', 'more', 'mas', 'more', 1, 0, 0); INSERT INTO `module_lan` VALUES (4, 'mono', 'less', 'menos', 'less', 1, 0, 0); INSERT INTO `module_lan` VALUES (5, 'mono', 'ClearColorSelection', 'Limpiar selección', 'reset selection', 1, 0, 0); INSERT INTO `module_lan` VALUES (6, 'mono', 'NoColorSelected', 'Color no seleccionado', 'Color not selected', 1, 0, 0); INSERT INTO `module_lan` VALUES (7, 'menu', 'Administrador', 'Administrador', 'Administrator', 1, 0, 0); INSERT INTO `module_lan` VALUES (8, 'menu', 'Compañía', 'Compañía', 'company', 1, 0, 0); INSERT INTO `module_lan` VALUES (9, 'menu', 'Usuarios', 'Usuarios', 'Users', 1, 0, 0); INSERT INTO `module_lan` VALUES (10, 'menu', 'Grupos', 'Grupos', 'Groups', 1, 0, 0); INSERT INTO `module_lan` VALUES (11, 'menu', 'GLobalización', 'Globalización', 'Globalization', 1, 0, 0); INSERT INTO `module_lan` VALUES (12, 'menu', 'Servicios', 'Servicios', 'services', 1, 0, 0); INSERT INTO `module_lan` VALUES (13, 'menu', 'HistorialdeAccesos', 'Historial de Accesos', 'Access History', 1, 0, 0); INSERT INTO `module_lan` VALUES (14, 'mono', 'GoToUp', 'Ir arriba', 'go to top', 1, 0, 0); INSERT INTO `module_lan` VALUES (15, 'navbar', 'HideMenu_toolkit', 'Esconder menu [ctrl + alt + h]', 'hide menu [ctrl alt h]', 1, 0, 0); INSERT INTO `module_lan` VALUES (16, 'navbar', 'RestoreallConfiguration_toolkit', 'Restablecer valores de fábrica, [ctrl + alt + r]', 'factory reset, [ctrl alt r]', 1, 0, 0); INSERT INTO `module_lan` VALUES (17, 'navbar', 'RestoreallConfiguration', 'Restablecer valores de fábrica, [ctrl + alt + r]', 'factory reset, [ctrl alt r]', 1, 0, 0); INSERT INTO `module_lan` VALUES (18, 'mono', 'myprofile', 'Mi perfil', 'my profile', 1, 0, 0); INSERT INTO `module_lan` VALUES (19, 'mono', 'about', 'acerca de', 'about', 1, 0, 0); INSERT INTO `module_lan` VALUES (20, 'navbar', 'Logout', 'Cerrar Sesión', 'logout', 1, 0, 0); INSERT INTO `module_lan` VALUES (21, 'mono', 'developedby', 'desarrollado por', 'developed by', 1, 0, 0); INSERT INTO `module_lan` VALUES (22, 'mono', 'config_toolkit', 'Configuración [ctrl + alt + c]', 'settings [ctrl alt c]', 1, 0, 0); INSERT INTO `module_lan` VALUES (23, 'restore', 'Restoreconfigurationforthistable', 'Restaurar la configuración para esta tabla', 'restore settings for this table', 1, 0, 0); INSERT INTO `module_lan` VALUES (24, 'mono', 'audit', 'auditoría', 'Audit', 1, 0, 0); INSERT INTO `module_lan` VALUES (25, 'mono', 'ShowAll', 'Mostrar todo', 'show all', 1, 0, 0); INSERT INTO `module_lan` VALUES (26, 'navbar', 'HideColumns', 'Ocultar Columna', 'Hide column', 1, 0, 0); INSERT INTO `module_lan` VALUES (27, 'navbar', 'RecordsPerPage', 'Registros por pagina', 'records per page', 1, 0, 0); INSERT INTO `module_lan` VALUES (28, 'mono', 'Clipboard', 'portapapaeles', 'clipboard', 1, 0, 0); INSERT INTO `module_lan` VALUES (29, 'mono', 'Exportas', 'Exportar como', 'Export As', 1, 0, 0); INSERT INTO `module_lan` VALUES (30, 'navbar', 'DonwloadExample', 'Descargar ejemplo', 'Download sample', 1, 0, 0); INSERT INTO `module_lan` VALUES (31, 'mono', 'import', 'importar', 'import', 1, 0, 0); INSERT INTO `module_lan` VALUES (32, 'mono', 'remove', 'eliminar', 'Delete', 1, 0, 0); INSERT INTO `module_lan` VALUES (33, 'mono', 'enable', 'habilitar', 'enable', 1, 0, 0); INSERT INTO `module_lan` VALUES (34, 'mono', 'disable', 'desactivar', 'disable', 1, 0, 0); INSERT INTO `module_lan` VALUES (35, 'mono', 'CopySelected', 'Copiar Selección', 'Copy selected', 1, 0, 0); INSERT INTO `module_lan` VALUES (36, 'mono', 'Actions', 'Acciones', 'Actions', 1, 0, 0); INSERT INTO `module_lan` VALUES (37, 'mono', 'refresh', 'Refrescar', 'Refresh', 1, 0, 0); INSERT INTO `module_lan` VALUES (38, 'mono', 'add', 'añadir', 'add', 1, 0, 0); INSERT INTO `module_lan` VALUES (39, 'special', 'ia', 'IA', 'IA', 1, 0, 0); INSERT INTO `module_lan` VALUES (40, 'special', 'human', 'Humano', 'Human', 1, 0, 0); INSERT INTO `module_lan` VALUES (41, 'special', 'nowork', 'Sin trabajar', 'Without working', 1, 0, 0); INSERT INTO `module_lan` VALUES (42, 'table', 'nodata', 'No hay datos para mostrar.', 'There is no data to be displayed.', 1, 0, 0); INSERT INTO `module_lan` VALUES (43, 'columns', 'category', 'categoría', 'category', 1, 0, 0); INSERT INTO `module_lan` VALUES (44, 'columns', 'key', 'key', 'key', 1, 0, 0); INSERT INTO `module_lan` VALUES (45, 'columns', 'value', 'valor', 'value', 1, 0, 0); INSERT INTO `module_lan` VALUES (46, 'mono', 'youselect', 'Seleccione', 'Please select', 1, 0, 0); INSERT INTO `module_lan` VALUES (47, 'mono', 'operator', 'operador', 'Operator', 1, 0, 0); INSERT INTO `module_lan` VALUES (48, 'mono', 'field', 'campo', 'Field', 1, 0, 0); INSERT INTO `module_lan` VALUES (49, 'mono', 'Contains', 'Contiene', 'Contains', 1, 0, 0); INSERT INTO `module_lan` VALUES (50, 'mono', 'Notcontains', 'No Contiene', 'does not contain', 1, 0, 0); INSERT INTO `module_lan` VALUES (51, 'mono', 'Equalto', 'Igual a', 'equal to', 1, 0, 0); INSERT INTO `module_lan` VALUES (52, 'mono', 'Differentto', 'Diferente a', 'not equal to 0', 1, 0, 0); INSERT INTO `module_lan` VALUES (53, 'mono', 'Startswith', 'Inicia con', 'Starts with', 1, 0, 0); INSERT INTO `module_lan` VALUES (54, 'mono', 'Notstartswith', 'No Inicia con', 'does not start with', 1, 0, 0); INSERT INTO `module_lan` VALUES (55, 'mono', 'Endswith', 'Termina con', 'ends with', 1, 0, 0); INSERT INTO `module_lan` VALUES (56, 'mono', 'Notendswith', 'No Termina con', 'does not end with', 1, 0, 0); INSERT INTO `module_lan` VALUES (57, 'mono', 'Onlynotset', 'Solo no asignados', 'Not allocated', 1, 0, 0); INSERT INTO `module_lan` VALUES (58, 'mono', 'Lessthan', 'Menor que', 'less than', 1, 0, 0); INSERT INTO `module_lan` VALUES (59, 'mono', 'Lessthanorequalto', 'Menor o igual', 'lower or equal', 1, 0, 0); INSERT INTO `module_lan` VALUES (60, 'mono', 'Greaterthan', 'Mayor a', 'Greater than', 1, 0, 0); INSERT INTO `module_lan` VALUES (61, 'mono', 'Greaterthanorequalto', 'Mayor o igual', 'Greater than or equal', 1, 0, 0); INSERT INTO `module_lan` VALUES (62, 'mono', 'Existin', 'Existe', 'Exist', 1, 0, 0); INSERT INTO `module_lan` VALUES (63, 'mono', 'NotExistin', 'No Existe', 'Not exists', 1, 0, 0); INSERT INTO `module_lan` VALUES (64, 'mono', 'IsTrue', 'Verdadero', 'true', 1, 0, 0); INSERT INTO `module_lan` VALUES (65, 'mono', 'IsFalse', 'Falso', 'False', 1, 0, 0); INSERT INTO `module_lan` VALUES (66, 'mono', 'and', 'y', 'and', 1, 0, 0); INSERT INTO `module_lan` VALUES (67, 'mono', 'or', 'o', 'or', 1, 0, 0); INSERT INTO `module_lan` VALUES (68, 'mono', 'filters', 'filtros', 'filters', 1, 0, 0); INSERT INTO `module_lan` VALUES (69, 'mono', 'for', 'para', 'for', 1, 0, 0); INSERT INTO `module_lan` VALUES (70, 'actions', 'Loading', 'Cargando', 'loading', 1, 0, 0); INSERT INTO `module_lan` VALUES (71, 'mono', 'close', 'cerrar', 'close', 1, 0, 0); INSERT INTO `module_lan` VALUES (72, 'mono', 'clicktosort', 'Clic para ordenar', 'Click to sort', 1, 0, 0); INSERT INTO `module_lan` VALUES (73, 'mono', 'sort_alphanumeric', 'Alfanuméricamente', 'Alphanumerically', 1, 0, 0); INSERT INTO `module_lan` VALUES (74, 'mono', 'by', 'por', 'by', 1, 0, 0); INSERT INTO `module_lan` VALUES (75, 'mono', 'desc', 'Descendente', 'descendant', 1, 0, 0); INSERT INTO `module_lan` VALUES (76, 'mono', 'sorted', 'ordenado', 'sorted', 1, 0, 0); INSERT INTO `module_lan` VALUES (77, 'mono', 'asc', 'Ascendente', 'ascending', 1, 0, 0); INSERT INTO `module_lan` VALUES (78, 'mono', 'sort_bool', '(verdadero/falso)', '(True/False)', 1, 0, 0); INSERT INTO `module_lan` VALUES (79, 'mono', 'refresing', 'refrescando', 'refreshing...', 1, 0, 0); INSERT INTO `module_lan` VALUES (80, 'navbar', 'ShowColumns', 'Mostrar Columna', 'Display Column', 1, 0, 0); INSERT INTO `module_lan` VALUES (81, 'mono', 'open', 'abrir', 'open', 1, 0, 0); INSERT INTO `module_lan` VALUES (82, 'mono', 'ClearAll', 'Limpiar todos', 'Clear All', 1, 0, 0); INSERT INTO `module_lan` VALUES (83, 'mono', 'no', 'no', 'no', 1, 0, 0); INSERT INTO `module_lan` VALUES (84, 'actions', 'Edit', 'Editar', 'Edit', 1, 0, 0); INSERT INTO `module_lan` VALUES (85, 'actions', 'View', 'Ver', 'Show', 1, 0, 0); INSERT INTO `module_lan` VALUES (86, 'actions', 'Remove', 'Eliminar', 'Delete', 1, 0, 0); INSERT INTO `module_lan` VALUES (87, 'actions', 'Copy', 'Copiar', 'Copy', 1, 0, 0); INSERT INTO `module_lan` VALUES (88, 'actions', 'audit', 'Auditoría', 'Audit', 1, 0, 0); INSERT INTO `module_lan` VALUES (89, 'mono', 'sort_time', 'Cronológicamente', 'Chronologically', 1, 0, 0); INSERT INTO `module_lan` VALUES (90, 'validations', 'Fieldisrequired', 'Campo requerido', 'Field is required', 1, 0, 0); INSERT INTO `module_lan` VALUES (91, 'mono', 'save', 'guardar', 'save', 1, 0, 0); INSERT INTO `module_lan` VALUES (92, 'mono', 'saveAndContinue', 'y continuar', 'and continue', 1, 0, 0); INSERT INTO `module_lan` VALUES (93, 'mono', 'yes', 'si', 'si', 1, 0, 0); INSERT INTO `module_lan` VALUES (94, 'menu', 'Periodos', 'Periodos', 'Periods', 1, 0, 0); INSERT INTO `module_lan` VALUES (95, 'menu', 'Planes', 'Planes', 'Plans', 1, 0, 0); INSERT INTO `module_lan` VALUES (96, 'menu', 'Paquetes', 'Paquetes', 'Packages', 1, 0, 0); INSERT INTO `module_lan` VALUES (97, 'menu', 'Atributos', 'Atributos', 'Attributes', 1, 0, 0); INSERT INTO `module_lan` VALUES (98, 'menu', 'Cumplimiento', 'Cumplimiento', 'Compliance', 1, 0, 0); INSERT INTO `module_lan` VALUES (99, 'menu', 'AsistenteServicios', 'Asistente de Servicios', 'Assistant services', 1, 0, 0); INSERT INTO `module_lan` VALUES (100, 'mono', 'sort_numeric', 'Numéricamente', 'Numerically', 1, 0, 0); INSERT INTO `module_lan` VALUES (101, 'actions', 'permissions', 'Permisos', 'Permissions', 1, 0, 0); INSERT INTO `module_lan` VALUES (102, 'actions', 'Enable', 'Habilitar', 'Enable', 1, 0, 0); INSERT INTO `module_lan` VALUES (103, 'actions', 'Disable', 'Deshabilitar', 'Disable', 1, 0, 0); INSERT INTO `module_lan` VALUES (104, 'actions', 'unlock', 'Desbloquear', 'Unlock', 1, 0, 0); INSERT INTO `module_lan` VALUES (105, 'mono', 'options', 'Opciones', 'Options', 1, 0, 0); INSERT INTO `module_lan` VALUES (106, 'mono', 'RefreshList', 'Refrescar Lista', 'Refresh list', 1, 0, 0); INSERT INTO `module_lan` VALUES (107, 'mono', 'Viewitem', 'Ver elemento', 'See item', 1, 0, 0); INSERT INTO `module_lan` VALUES (108, 'mono', 'Additem', 'Añadir elemento', 'Add item', 1, 0, 0); INSERT INTO `module_lan` VALUES (109, 'mono', 'Edititem', 'Editar elemento', 'Edit item', 1, 0, 0); INSERT INTO `module_lan` VALUES (110, 'mono', 'saving', 'guardando', 'saving', 1, 0, 0); INSERT INTO `module_lan` VALUES (111, 'mono', 'saved', 'guardado(a)', 'saved', 1, 0, 0); INSERT INTO `module_lan` VALUES (112, 'table', 'tableStatus', '{0} ordenado por {1} {2}, mostrando {3} a {4} de {5} registros', '{0} sorted by {1} {2}, showing {3} to {4} of {5} records', 1, 0, 0); INSERT INTO `module_lan` VALUES (113, 'columns', 'id', 'id', 'id', 1, 0, 0); INSERT INTO `module_lan` VALUES (114, 'mono', 'ok', 'ok', 'ok', 1, 0, 0); INSERT INTO `module_lan` VALUES (177, 'menu', 'ConfiguracióndelaConexión', 'Configuración de la Conexión', 'Connection Settings', 1, 0, 0); INSERT INTO `module_lan` VALUES (115, 'columns', 'servicio_plural', 'Servicio', 'Service', 1, 0, 0); INSERT INTO `module_lan` VALUES (116, 'columns', 'servicio', 'Servicio', 'Service', 1, 0, 0); INSERT INTO `module_lan` VALUES (117, 'columns', 'prefix', 'Prefijo', 'Prefix', 1, 0, 0); INSERT INTO `module_lan` VALUES (118, 'columns', 'nombre', 'Nombre', 'Name', 1, 0, 0); INSERT INTO `module_lan` VALUES (119, 'columns', 'periodo_nombre', 'Periodo', 'Period', 1, 0, 0); INSERT INTO `module_lan` VALUES (120, 'columns', 'precio', 'Precio', 'Price', 1, 0, 0); INSERT INTO `module_lan` VALUES (121, 'columns', 'bundle_nombre', 'Paquete', 'Bundle', 1, 0, 0); INSERT INTO `module_lan` VALUES (122, 'columns', 'category_nombre', 'Categorías', 'Category', 1, 0, 0); INSERT INTO `module_lan` VALUES (123, 'columns', 'cumplimientos', 'Cumplimientos', 'Compliance.', 1, 0, 0); INSERT INTO `module_lan` VALUES (124, 'columns', 'periodo', 'Periodo', 'Period', 1, 0, 0); INSERT INTO `module_lan` VALUES (125, 'columns', 'bundle', 'Paquete', 'Bundle', 1, 0, 0); INSERT INTO `module_lan` VALUES (126, 'columns', 'servicio_compliance', 'Cumplimientos', 'Compliance', 1, 0, 0); INSERT INTO `module_lan` VALUES (127, 'columns', 'periodo_plural', 'Periodo', 'Period', 1, 0, 0); INSERT INTO `module_lan` VALUES (128, 'columns', 'formula', 'Formula', 'Formula', 1, 0, 0); INSERT INTO `module_lan` VALUES (129, 'columns', 'bundle_plural', 'Paquetes', 'Bundles', 1, 0, 0); INSERT INTO `module_lan` VALUES (130, 'alerts', 'CloseToComplete', '¿Está cerca de completar el formulario, está seguro de que desea cerrarlo?', 'are you close to completing the form, are you sure you want to close it?', 1, 0, 0); INSERT INTO `module_lan` VALUES (131, 'columns', 'grupo_plural', 'Grupo', 'Group', 1, 0, 0); INSERT INTO `module_lan` VALUES (132, 'columns', 'grupo', 'Grupo', 'Group', 1, 0, 0); INSERT INTO `module_lan` VALUES (133, 'columns', 'description', 'Descripción', 'Description', 1, 0, 0); INSERT INTO `module_lan` VALUES (134, 'columns', 'category_plural', 'Categorías', 'Categories', 1, 0, 0); INSERT INTO `module_lan` VALUES (135, 'columns', 'descripcion', 'Descripción', 'Description', 1, 0, 0); INSERT INTO `module_lan` VALUES (136, 'columns', 'attribute_plural', 'Atributo', 'Attribute', 1, 0, 0); INSERT INTO `module_lan` VALUES (137, 'columns', 'attribute', 'Atributo', 'Attribute', 1, 0, 0); INSERT INTO `module_lan` VALUES (138, 'alerts', 'ContainsError', 'Existen campos en el formulario con errores, favor revisarlos.', 'there are fields in the form with errors, please check them.', 1, 0, 0); INSERT INTO `module_lan` VALUES (139, 'alerts', 'ClientDbError', 'Ocurrió un error en la base de datos, ¿le gustaría enviar este error?', 'a database error occurred, would you like to submit this error?', 1, 0, 0); INSERT INTO `module_lan` VALUES (140, 'alerts', 'AYSDelete', '¿Está seguro de que desea eliminar este registro?', 'Are you sure you wish to delete this record?', 1, 0, 0); INSERT INTO `module_lan` VALUES (141, 'mono', 'deleting', 'eliminando', 'deleting', 1, 0, 0); INSERT INTO `module_lan` VALUES (142, 'mono', 'deleted', 'eliminado(s)', 'removed', 1, 0, 0); INSERT INTO `module_lan` VALUES (143, 'columns', 'compliance_plural', 'Cumplimiento', 'Compliance', 1, 0, 0); INSERT INTO `module_lan` VALUES (144, 'columns', 'compliance', 'Cumplimiento', 'Compliance', 1, 0, 0); INSERT INTO `module_lan` VALUES (145, 'mono', 'timeouttitle', '¿Sigues ahí?', 'Are you still here?!', 1, 0, 0); INSERT INTO `module_lan` VALUES (146, 'mono', 'timeoutbody', 'Parece que has estado fuera de la aplicación durante mucho tiempo, debido a esto la sesión pronto se cerrará. ¿Deseas continuar conectado?', 'it looks like you\'ve been out of the app for a long time, due to this the session will soon be closed. do you want to continue logged in?', 1, 0, 0); INSERT INTO `module_lan` VALUES (147, 'mono', 'extendsession', 'Extender la sesión', 'Extend session', 1, 0, 0); INSERT INTO `module_lan` VALUES (148, 'mono', 'logmeout', 'Desconectame!', 'Disconnect me!', 1, 0, 0); INSERT INTO `module_lan` VALUES (149, 'columns', 'compania_plural', 'Compañía', 'Company', 1, 0, 0); INSERT INTO `module_lan` VALUES (150, 'columns', 'compania', 'Compañía', 'Company', 1, 0, 0); INSERT INTO `module_lan` VALUES (151, 'columns', 'direccion', 'Direccion', 'Address', 1, 0, 0); INSERT INTO `module_lan` VALUES (152, 'columns', 'language_label', 'Lenguaje', 'Language', 1, 0, 0); INSERT INTO `module_lan` VALUES (153, 'columns', 'perfil', 'Perfil', 'Profile', 1, 0, 0); INSERT INTO `module_lan` VALUES (154, 'columns', 'language', 'Lenguaje', 'Language', 1, 0, 0); INSERT INTO `module_lan` VALUES (155, 'columns', 'template', 'Plantilla del Correo', 'Mail Template', 1, 0, 0); INSERT INTO `module_lan` VALUES (156, 'mono', 'session', 'Sesión', 'Session', 1, 0, 0); INSERT INTO `module_lan` VALUES (157, 'alerts', 'SessionEnd', 'Su sesión ha finalizado, por favor inicie sesión', 'Your session has ended, please log in', 1, 0, 0); INSERT INTO `module_lan` VALUES (158, 'columns', 'selection_plural', 'Selección', 'Selection', 1, 0, 0); INSERT INTO `module_lan` VALUES (159, 'columns', 'selection', 'Selección', 'Selection', 1, 0, 0); INSERT INTO `module_lan` VALUES (160, 'columns', 'compania_nombre', 'Compañía', 'Company', 1, 0, 0); INSERT INTO `module_lan` VALUES (161, 'columns', 'grupos', 'Grupos', 'Groups', 1, 0, 0); INSERT INTO `module_lan` VALUES (162, 'menu', 'Configuración', 'Configuración', 'Configuration', 1, 0, 0); INSERT INTO `module_lan` VALUES (163, 'mono', 'back', 'Atrás', 'Back', 1, 0, 0); INSERT INTO `module_lan` VALUES (164, 'columns', 'paquetes', 'Paquetes', 'Packages', 1, 0, 0); INSERT INTO `module_lan` VALUES (165, 'columns', 'servicios', 'Servicios', 'Services', 1, 0, 0); INSERT INTO `module_lan` VALUES (166, 'columns', 'servicio_attribute', 'Atributos', 'Attribute', 1, 0, 0); INSERT INTO `module_lan` VALUES (167, 'columns', 'atributos', 'Atributos', 'Attributes', 1, 0, 0); INSERT INTO `module_lan` VALUES (168, 'alerts', 'emptyRelations', 'Este formulario contiene las siguientes relaciones vacías: ${relations} deseas guardar de todos modos?', 'this form contains the following empty relationships: ${relations} do you want to save anyway?', 1, 0, 0); INSERT INTO `module_lan` VALUES (169, 'mono', 'completetext', 'Texto Completo', 'Full Text', 1, 0, 0); INSERT INTO `module_lan` VALUES (170, 'mono', 'of', 'de', 'of', 1, 0, 0); INSERT INTO `module_lan` VALUES (171, 'alerts', 'AYSCloseSession', '¿Está seguro de que desea cerrar la sesión?', 'Are you sure you would like to logout?', 1, 0, 0); INSERT INTO `module_lan` VALUES (172, 'mono', 'repeatpassword', 'Repetir contraseña', 'Confirm password', 1, 0, 0); INSERT INTO `module_lan` VALUES (173, 'mono', 'password', 'Contraseña', 'Password', 1, 0, 0); INSERT INTO `module_lan` VALUES (174, 'login', 'Enteryourcredentialsbelow', 'Digite sus credenciales', 'enter your credentials', 1, 0, 0); INSERT INTO `module_lan` VALUES (175, 'login', 'forgotpassword', 'Olvidó contraseña', 'Forgot password', 1, 0, 0); INSERT INTO `module_lan` VALUES (176, 'validations', 'Isnotavalidemail', 'Correo inválido', 'Invalid email.', 1, 0, 0); INSERT INTO `module_lan` VALUES (178, 'menu', 'OpcionesAdministrativas', 'Opciones Administrativas', 'Administrative Options', 1, 0, 0); INSERT INTO `module_lan` VALUES (179, 'menu', 'Permisos', 'Permisos', 'Permmisions', 1, 0, 0); INSERT INTO `module_lan` VALUES (180, 'menu', 'Opciones', 'Opciones', 'Options', 1, 0, 0); INSERT INTO `module_lan` VALUES (181, 'menu', 'Campañas', 'Campañas', 'Campaign', 1, 0, 0); INSERT INTO `module_lan` VALUES (182, 'mono', 'group_selection', 'Agrupar selección', 'Group Selection', 1, 0, 0); INSERT INTO `module_lan` VALUES (183, 'mono', 'condition', 'Condición', 'Condition', 1, 0, 0); INSERT INTO `module_lan` VALUES (184, 'mono', 'apply', 'aplicar', 'apply', 1, 0, 0); INSERT INTO `module_lan` VALUES (185, 'mono', 'clear', 'limpiar', 'clear', 1, 0, 0); INSERT INTO `module_lan` VALUES (186, 'mono', 'add_fiter', 'Añadir Filtro', 'Add filter', 1, 0, 0); INSERT INTO `module_lan` VALUES (187, 'columns', 'module_lan_plural', 'Globalización', 'Globalization', 1, 0, 0); INSERT INTO `module_lan` VALUES (188, 'columns', 'module_lan', 'Globalización', 'Globalization', 1, 0, 0); INSERT INTO `module_lan` VALUES (189, 'columns', 'en', 'en', 'en', 1, 0, 0); INSERT INTO `module_lan` VALUES (190, 'columns', 'es', 'es', 'es', 1, 0, 0); INSERT INTO `module_lan` VALUES (191, 'columns', 'ia', 'ia', 'ia', 1, 0, 0); INSERT INTO `module_lan` VALUES (192, 'restore', 'norestore', 'No hay configuración para restaurar en esta pantalla', 'There are no settings to restore', 1, 0, 0); INSERT INTO `module_lan` VALUES (193, 'restore', 'yesrestore', 'Esta opción elimina todos los datos de configuración persistentes para esta tabla, clasificación, reordenación de columnas, página actual, límite por página y filtros, ¿estás seguro?', 'this option removes all persistent configuration data for this table, sorting, column reordering, current page, limit per page and filters, are you sure?', 1, 0, 0); INSERT INTO `module_lan` VALUES (194, 'columns', 'Create', 'Crear', 'Create', 1, 0, 0); INSERT INTO `module_lan` VALUES (195, 'columns', 'Delete', 'Eliminar', 'Delete', 1, 0, 0); INSERT INTO `module_lan` VALUES (196, 'columns', 'Update', 'Editar', 'Update', 1, 0, 0); INSERT INTO `module_lan` VALUES (197, 'permissions', 'permissions', 'Permisos', 'Permissions', 1, 0, 0); INSERT INTO `module_lan` VALUES (198, 'mono', 'persmissionTitle', 'Permisos', 'Persmission', 1, 0, 0); INSERT INTO `module_lan` VALUES (199, 'mono', 'search', 'Buscar', 'Search', 1, 0, 0); INSERT INTO `module_lan` VALUES (200, 'mono', 'checkall', 'Asignar Todos', 'Check All', 1, 0, 0); INSERT INTO `module_lan` VALUES (201, 'mono', 'uncheckall', 'Quitar Todos', 'Uncheck All', 1, 0, 0); INSERT INTO `module_lan` VALUES (202, 'actions', 'Clipboard', 'Portapapeles', 'Clipboard', 1, 0, 0); INSERT INTO `module_lan` VALUES (203, 'columns', 'Name', 'Nombre', 'Name', 1, 0, 0); INSERT INTO `module_lan` VALUES (204, 'columns', 'Caracteristica', 'Característica', 'Feature', 1, 0, 0); INSERT INTO `module_lan` VALUES (205, 'mono', 'edit', 'Editar', 'Edit', 1, 0, 0); INSERT INTO `module_lan` VALUES (206, 'mono', 'files', 'Archivos', 'Files', 1, 0, 0); INSERT INTO `module_lan` VALUES (207, 'mono', 'ViewPassword', 'Ver Contraseña', 'View password', 1, 0, 0); INSERT INTO `module_lan` VALUES (208, 'validations', 'fieldPassword', '${field} debe de ser igual que ${field2}', '${field} must be equal to ${field2}', 1, 0, 0); INSERT INTO `module_lan` VALUES (209, 'login', 'passwordrecovery', 'Recuperar contraseña', 'Recover password', 1, 0, 0); INSERT INTO `module_lan` VALUES (210, 'login', 'willsendemail', 'Estaremos enviando un correo con las instrucciones para el cambio de tu contraseña', 'we will be sending an email with instructions for changing your password', 1, 0, 0); INSERT INTO `module_lan` VALUES (211, 'login', 'resetpassword', 'Reiniciar contraseña', 'Reset password ', 1, 0, 0); INSERT INTO `module_lan` VALUES (212, 'planificacion', 'titleUsuario', 'Usuario', 'User', 1, 0, 0); INSERT INTO `module_lan` VALUES (213, 'validations', 'malicious_code', 'Existen caracteres inválidos', 'invalid characters exist', 1, 0, 0); INSERT INTO `module_lan` VALUES (214, 'mono', 'Viewof', 'Vista de', 'View of', 1, 0, 0); INSERT INTO `module_lan` VALUES (215, 'alerts', 'AYSEnable', '¿Está seguro de que desea habilitar este registro?', 'are you sure you want to enable this record?', 1, 0, 0); INSERT INTO `module_lan` VALUES (216, 'alerts', 'AYSDisable', '¿Está seguro de que desea Deshabilitar este registro?', 'are you sure you want to disable this record?', 1, 0, 0); INSERT INTO `module_lan` VALUES (217, 'mono', 'auditof', 'Auditoría de', 'Audit of', 1, 0, 0); INSERT INTO `module_lan` VALUES (218, 'columns', 'created_at', 'Creado en', 'Created at', 1, 0, 0); INSERT INTO `module_lan` VALUES (219, 'columns', 'created_by', 'Creado por', 'Created by', 1, 0, 0); INSERT INTO `module_lan` VALUES (220, 'columns', 'created_ip', 'Creado desde el IP', 'Created from the ip', 1, 0, 0); INSERT INTO `module_lan` VALUES (221, 'columns', 'updated_at', 'Actualizado en', 'Updated at', 1, 0, 0); INSERT INTO `module_lan` VALUES (222, 'columns', 'updated_by', 'Actualizado por', 'Updated by', 1, 0, 0); INSERT INTO `module_lan` VALUES (223, 'columns', 'updated_ip', 'Actualizado desde el IP', 'Updated from ip', 1, 0, 0); INSERT INTO `module_lan` VALUES (224, 'mono', 'select', 'seleccionado', 'selected', 1, 0, 0); INSERT INTO `module_lan` VALUES (225, 'mono', 'list', 'lista', 'list', 1, 0, 0); INSERT INTO `module_lan` VALUES (226, 'columns', 'usuario_plural', 'Usuarios', 'Users', 1, 0, 0); INSERT INTO `module_lan` VALUES (227, 'columns', 'usuario', 'Usuario', 'User', 1, 0, 0); INSERT INTO `module_lan` VALUES (228, 'columns', 'apellido', 'Apellido', 'Last name', 1, 0, 0); INSERT INTO `module_lan` VALUES (229, 'columns', 'correo', 'Correo', 'Email', 1, 0, 0); INSERT INTO `module_lan` VALUES (230, 'columns', 'profile', 'Perfil', 'Profile', 1, 0, 0); INSERT INTO `module_lan` VALUES (231, 'columns', 'active', '¿Activo?', 'Active?', 1, 0, 0); INSERT INTO `module_lan` VALUES (232, 'columns', 'import_actions_plural', 'Campaña', 'Campaigns', 1, 0, 0); INSERT INTO `module_lan` VALUES (233, 'columns', 'import_actions', 'Campaña', 'Campaign', 1, 0, 0); INSERT INTO `module_lan` VALUES (234, 'columns', 'detalles', 'Detalles', 'Details', 1, 0, 0); INSERT INTO `module_lan` VALUES (235, 'columns', 'mensaje', 'Mensaje', 'Message', 1, 0, 0); INSERT INTO `module_lan` VALUES (236, 'columns', 'login_history_plural', 'Historial de acceso ', 'Login history', 1, 0, 0); INSERT INTO `module_lan` VALUES (237, 'columns', 'login_history', 'Historial de acceso', 'Login history', 1, 0, 0); INSERT INTO `module_lan` VALUES (238, 'columns', 'date', 'fecha', 'date', 1, 0, 0); INSERT INTO `module_lan` VALUES (239, 'columns', 'ip', 'IP', 'IP', 1, 0, 0); INSERT INTO `module_lan` VALUES (240, 'columns', 'compania_config_plural', 'Configuración de la Conexión', 'Connection Settings', 1, 0, 0); INSERT INTO `module_lan` VALUES (241, 'columns', 'compania_config', 'Configuración de la conexión', 'Connection Settings', 1, 0, 0); INSERT INTO `module_lan` VALUES (242, 'columns', 'group_plural', 'grupos', 'groups', 1, 0, 0); INSERT INTO `module_lan` VALUES (243, 'columns', 'group', 'Grupo', 'Group', 1, 0, 0); INSERT INTO `module_lan` VALUES (244, 'columns', 'undefined', 'Sin Definir', 'undefined', 1, 0, 0); INSERT INTO `module_lan` VALUES (245, 'columns', 'homePage', 'Página principal', 'Home Page', 1, 0, 0); INSERT INTO `module_lan` VALUES (246, 'columns', 'isAdmin', '¿Es Administrador?', 'Is Admin?', 1, 0, 0); INSERT INTO `module_lan` VALUES (247, 'columns', 'gracia', 'Días de Gracia', 'Grace days', 1, 0, 0); INSERT INTO `module_lan` VALUES (248, 'columns', 'repeat', 'Repetir', 'Repeat', 1, 0, 0); INSERT INTO `module_lan` VALUES (249, 'columns', 'created', 'creado en', 'created at', 1, 0, 0); INSERT INTO `module_lan` VALUES (250, 'columns', 'updated', 'actualizado en', 'updated at', 1, 0, 0); INSERT INTO `module_lan` VALUES (251, 'columns', 'user_created', 'creado por', 'created by', 1, 0, 0); INSERT INTO `module_lan` VALUES (252, 'columns', 'user_updated', 'actualizador', 'updated by', 1, 0, 0); INSERT INTO `module_lan` VALUES (253, 'columns', 'notificaciones', 'notificaciones', 'notifications', 1, 0, 0); INSERT INTO `module_lan` VALUES (254, 'mono', 'new', 'agregar', 'add', 1, 0, 0); INSERT INTO `module_lan` VALUES (255, 'columns', 'db_user', 'Usuario', 'User', 1, 0, 0); INSERT INTO `module_lan` VALUES (256, 'columns', 'db_password', 'Contraseña', 'Password**', 1, 0, 0); INSERT INTO `module_lan` VALUES (257, 'columns', 'db_server', 'Servidor', 'Server', 1, 0, 0); INSERT INTO `module_lan` VALUES (258, 'columns', 'db_database', 'Base de datos', 'Database', 1, 0, 0); INSERT INTO `module_lan` VALUES (259, 'columns', 'db_port', 'Puerto', 'Port', 1, 0, 0); INSERT INTO `module_lan` VALUES (260, 'columns', 'tempphones_plural', 'Historial de Registros', 'Record History', 1, 0, 0); INSERT INTO `module_lan` VALUES (261, 'columns', 'tempphones', 'Historial de Registros', 'Record History', 1, 0, 0); INSERT INTO `module_lan` VALUES (262, 'columns', 'phone', 'teléfono', 'phone', 1, 0, 0); INSERT INTO `module_lan` VALUES (263, 'columns', 'import', 'Import', 'import', 1, 0, 0); INSERT INTO `module_lan` VALUES (264, 'alerts', 'upload', 'Soltar archivos para subir o HACER CLIC', 'Drop files to upload or CLICK', 1, 0, 0); INSERT INTO `module_lan` VALUES (265, 'alerts', 'SelectorDropFiles', 'Seleccionar o eliminar archivos', 'Select or delete files', 1, 0, 0); INSERT INTO `module_lan` VALUES (266, 'mono', 'Thereisnofilestoshow', 'No hay archivos a mostrar.', 'There are no files to display.', 1, 0, 0); INSERT INTO `module_lan` VALUES (267, 'alerts', 'AYSDeleteFileFolder', '¿Está seguro de que desea eliminar archivo?', 'Are you sure you want to delete file?', 1, 0, 0); INSERT INTO `module_lan` VALUES (268, 'mono', 'preview', 'Vista Previa', 'Preview', 1, 0, 0); INSERT INTO `module_lan` VALUES (269, 'error', 'e500', 'e500', 'e500', 1, 0, 0); INSERT INTO `module_lan` VALUES (270, 'error', 'Oopsanerrorhasoccurred', 'Oops, ha ocurrido un error', 'Oops, an error has occurred', 1, 0, 0); -- ---------------------------- -- Table structure for modulo_formulario -- ---------------------------- DROP TABLE IF EXISTS `modulo_formulario`; CREATE TABLE `modulo_formulario` ( `id` int(11) NOT NULL AUTO_INCREMENT, `nombre` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `descripcion` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `config` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL, `indicador` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `formula` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `sufijo` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `prefijo` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact; -- ---------------------------- -- Records of modulo_formulario -- ---------------------------- -- ---------------------------- -- Table structure for modulo_formulario_registro -- ---------------------------- DROP TABLE IF EXISTS `modulo_formulario_registro`; CREATE TABLE `modulo_formulario_registro` ( `id` int(11) NOT NULL AUTO_INCREMENT, `modulo_formulario` int(11) NULL DEFAULT NULL, `respuestas` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL, `fecha` datetime NULL DEFAULT NULL, `ip` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `nombre` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `origen` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `usuario` int(11) NULL DEFAULT NULL, `browser` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 12 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact; -- ---------------------------- -- Records of modulo_formulario_registro -- ---------------------------- -- ---------------------------- -- Table structure for modulo_notificacion -- ---------------------------- DROP TABLE IF EXISTS `modulo_notificacion`; CREATE TABLE `modulo_notificacion` ( `id` int(11) NOT NULL AUTO_INCREMENT, `nombre` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `descripcion` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `view` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `template` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL, `code` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL, `field_email` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `field_date` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `field_code` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `masterpage` tinyint(1) NULL DEFAULT NULL, `campos` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL, `direct_emails` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL, `field_email_exc` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `date_strict` tinyint(1) NULL DEFAULT NULL, `disparo_type` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `field_vigencia` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `field_tiempo` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `field_tiempocondition` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `field_estimado` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `field_estatus` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `field_entidad` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `template_push` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `tambienpush` tinyint(1) NULL DEFAULT NULL, `subject` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL, `send_one` tinyint(1) NULL DEFAULT NULL, `field_action` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `destiny_roles` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `destiny_usuario` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `destiny_fix` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `field_email_cc` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `field_email_cco` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `field_fechacondition` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `active` tinyint(1) NULL DEFAULT NULL, `dias_de_gracia` int(11) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact; -- ---------------------------- -- Records of modulo_notificacion -- ---------------------------- -- ---------------------------- -- Table structure for modulo_notificacion_cache -- ---------------------------- DROP TABLE IF EXISTS `modulo_notificacion_cache`; CREATE TABLE `modulo_notificacion_cache` ( `code` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `module_notification` int(11) NULL DEFAULT NULL, `date` date NULL DEFAULT NULL, `permanent` tinyint(11) NULL DEFAULT NULL, `to` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL, `cc` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL, `subject` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL, `email` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL, `sendDate` timestamp NULL DEFAULT CURRENT_TIMESTAMP, `push` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact; -- ---------------------------- -- Records of modulo_notificacion_cache -- ---------------------------- -- ---------------------------- -- Table structure for modulo_notificacion_group -- ---------------------------- DROP TABLE IF EXISTS `modulo_notificacion_group`; CREATE TABLE `modulo_notificacion_group` ( `id` int(11) NOT NULL AUTO_INCREMENT, `modulo_notificacion` int(11) NULL DEFAULT NULL, `a_clone_group` int(11) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact; -- ---------------------------- -- Records of modulo_notificacion_group -- ---------------------------- -- ---------------------------- -- Table structure for modulo_notificacion_task -- ---------------------------- DROP TABLE IF EXISTS `modulo_notificacion_task`; CREATE TABLE `modulo_notificacion_task` ( `id` int(11) NOT NULL AUTO_INCREMENT, `accion` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `sended` tinyint(1) NULL DEFAULT NULL, `record_id` int(11) NULL DEFAULT NULL, `date` date NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact; -- ---------------------------- -- Records of modulo_notificacion_task -- ---------------------------- -- ---------------------------- -- Table structure for modulo_notificacion_usuario -- ---------------------------- DROP TABLE IF EXISTS `modulo_notificacion_usuario`; CREATE TABLE `modulo_notificacion_usuario` ( `id` int(11) NOT NULL AUTO_INCREMENT, `modulo_notificacion` int(11) NULL DEFAULT NULL, `usuario` int(11) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 1 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact; -- ---------------------------- -- Records of modulo_notificacion_usuario -- ---------------------------- -- ---------------------------- -- Table structure for tempphones -- ---------------------------- DROP TABLE IF EXISTS `tempphones`; CREATE TABLE `tempphones` ( `id` int(11) NOT NULL AUTO_INCREMENT, `phone` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `campaign` int(11) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE ) ENGINE = MyISAM AUTO_INCREMENT = 340 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic; -- ---------------------------- -- Records of tempphones -- ---------------------------- -- ---------------------------- -- Table structure for usuario -- ---------------------------- DROP TABLE IF EXISTS `usuario`; CREATE TABLE `usuario` ( `id` int(11) NOT NULL AUTO_INCREMENT, `nombre` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `apellido` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `correo` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `esadmin` int(11) NULL DEFAULT NULL, `user_id` int(11) UNSIGNED NULL DEFAULT NULL, `password` varchar(250) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `repeatPassword` varchar(250) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `profile` int(11) NULL DEFAULT NULL, `active` int(11) NULL DEFAULT NULL, PRIMARY KEY (`id`) USING BTREE, INDEX `user_id`(`user_id`) USING BTREE ) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact; -- ---------------------------- -- Records of usuario -- ---------------------------- INSERT INTO `usuario` VALUES (1, 'Admin', 'Admin', 'admin@eisdr.com', 1, 1, '0148172d54e8599c4a429146b154f3b6', '0148172d54e8599c4a429146b154f3b6', 1, 1); INSERT INTO `usuario` VALUES (6, 'Amaury', 'González', 'agonzalez@binarits.com', 0, 6, '63eb9541c7be2477dda2b10d8d70e492', '63eb9541c7be2477dda2b10d8d70e492', 1, 1); -- ---------------------------- -- Table structure for viewcache -- ---------------------------- DROP TABLE IF EXISTS `viewcache`; CREATE TABLE `viewcache` ( `tabla` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL, `views` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact; -- ---------------------------- -- Records of viewcache -- ---------------------------- -- ---------------------------- -- View structure for vw_full_extension -- ---------------------------- DROP VIEW IF EXISTS `vw_full_extension`; CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `vw_full_extension` AS SELECT fe.id AS id, f.nombre AS full, fe.nombre as nombre, fe.tempid FROM dragon.full_extension fe JOIN dragon.full f ON fe.full = f.id ; -- ---------------------------- -- View structure for vw_lancategory -- ---------------------------- DROP VIEW IF EXISTS `vw_lancategory`; CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `vw_lancategory` AS select distinct category id, category name from module_lan ; -- ---------------------------- -- View structure for vw_login_history -- ---------------------------- DROP VIEW IF EXISTS `vw_login_history`; CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `vw_login_history` AS SELECT `t`.`id` AS `id`, concat( `u`.`nombre`, ' ', `u`.`apellido` ) AS `usuario`, `t`.`date` AS `date`, `t`.`ip` AS `ip` FROM `login_history` `t` JOIN `usuario` `u` ON `u`.`id` = `t`.`usuario` ; -- ---------------------------- -- View structure for vw_mdnfields -- ---------------------------- DROP VIEW IF EXISTS `vw_mdnfields`; CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `vw_mdnfields` AS select concat(table_name,'_',COLUMN_NAME) id, table_name,column_name,data_type from information_schema.`COLUMNS` where table_schema=DATABASE() and table_name like 'mdn_%' ; -- ---------------------------- -- View structure for vw_modificacion_pedido -- ---------------------------- DROP VIEW IF EXISTS `vw_modificacion_pedido`; CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `vw_modificacion_pedido` AS SELECT `f`.`id` AS `id`, `f`.`letter` AS `letter`, `f`.`nombre` AS `nombre`, `f`.`telefono` AS `telefono`, `f`.`descripcion` AS `descripcion`, `f`.`template` AS `template`, `f`.`numero` AS `numero`, IFNULL(`f`.`monto`, 0.00) AS `monto`, `f`.`decimal` AS `decimal`, `f`.`calificacion` AS `calificacion`, `f`.`activo` AS `activo`, `f`.`activo_entre_from` AS `activo_entre_from`, `f`.`activo_entre_to` AS `activo_entre_to`, `f`.`fecha_nacimiento` AS `fecha_nacimiento`, `f`.`registrado_en` AS `registrado_en`, `f`.`registro_padre` AS `registro_padre`, COALESCE(GROUP_CONCAT(DISTINCT `p`.`id` ORDER BY `p`.`id` ASC SEPARATOR ', '), '') AS `pedido`, COALESCE(GROUP_CONCAT(DISTINCT `pr`.`nombre` ORDER BY `pr`.`nombre` ASC SEPARATOR ', '), '') AS `producto`, COALESCE(GROUP_CONCAT(`fc`.`full_child` ORDER BY `fc`.`full_child` ASC SEPARATOR ', '), '') AS `dropdown_multiple` FROM ((((`full` `f` LEFT JOIN `full_child` `fc` ON ((`f`.`id` = `fc`.`full`))) LEFT JOIN `pedido` `p` ON ((`f`.`pedido` = `p`.`id`))) LEFT JOIN `pedido_producto` `pp` ON ((`p`.`id` = `pp`.`id_pedido`))) LEFT JOIN `producto` `pr` ON ((`pp`.`id_producto` = `pr`.`id`))) GROUP BY `f`.`id` , `f`.`letter` , `f`.`nombre` , `f`.`telefono` , `f`.`descripcion` , `f`.`template` , `f`.`numero` , `f`.`monto` , `f`.`decimal` , `f`.`calificacion` , `f`.`activo` , `f`.`activo_entre_from` , `f`.`activo_entre_to` , `f`.`fecha_nacimiento` , `f`.`registrado_en` , `f`.`registro_padre` ; -- ---------------------------- -- View structure for vw_pedido -- ---------------------------- DROP VIEW IF EXISTS `vw_pedido`; CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `vw_pedido` AS SELECT `p`.`id` AS `id`, `u`.`nombre` AS `id_cliente`, GROUP_CONCAT(`pr`.`nombre` ORDER BY `pr`.`nombre` SEPARATOR ', ') AS `nombre_productos`, `p`.`descripcion` AS `descripcion_pedido` FROM (((`pedido` `p` JOIN `pedido_producto` `pp` ON ((`p`.`id` = `pp`.`id_pedido`))) JOIN `producto` `pr` ON ((`pp`.`id_producto` = `pr`.`id`))) JOIN `usuario` `u` ON ((`u`.`id` = `p`.`cliente`))) GROUP BY `p`.`id`, `u`.`nombre`, `p`.`descripcion` ; -- ---------------------------- -- View structure for vw_pedidos_productos -- ---------------------------- DROP VIEW IF EXISTS `vw_pedidos_productos`; CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `vw_pedidos_productos` AS SELECT `pp`.`id_pedido` AS `id`, `p`.`nombre` AS `nombre_producto` FROM (`pedido_producto` `pp` JOIN `producto` `p` ON ((`pp`.`id_producto` = `p`.`id`))) ; -- ---------------------------- -- View structure for vw_product -- ---------------------------- DROP VIEW IF EXISTS `vw_product`; CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `vw_product` AS SELECT id, nombre, descripcion FROM dragon.producto ; -- ---------------------------- -- View structure for vw_usuarios -- ---------------------------- DROP VIEW IF EXISTS `vw_usuarios`; CREATE ALGORITHM = UNDEFINED SQL SECURITY DEFINER VIEW `vw_usuarios` AS SELECT `u`.`id` AS `id`, `u`.`id` AS `usuario_id`, concat( `u`.`nombre`, ' ', `u`.`apellido` ) AS `usuario`, `u`.`nombre` AS `nombre`, `u`.`apellido` AS `apellido`, `u`.`correo` AS `correo`, `u`.`id` AS `id2`, `u`.`active` AS `active`, u.`password` , u.profile FROM `usuario` `u` ; SET FOREIGN_KEY_CHECKS = 1;