-- Active: 1773863639252@@192.168.100.177@3306@colinasdellago_1 DROP TABLE IF EXISTS systems; DROP TABLE IF EXISTS systems_modules; CREATE TABLE `systems` ( `sys_id` int(11) NOT NULL, `sys_name` varchar(255) DEFAULT NULL, `sys_description` tinytext, `sys_pathurl` varchar(500) DEFAULT NULL, `sys_path` varchar(500) DEFAULT NULL, `sys_mod_default` int (11) NOT NULL DEFAULT '0', `sys_code` varchar(11) NOT NULL, `sys_icon` varchar(240) DEFAULT NULL, `sys_color` varchar(10) DEFAULT NULL, `sys_parent_id` int(11) DEFAULT NULL, `sys_indexjs` varchar(255) NOT NULL, `sys_css` varchar(255) NOT NULL, `sys_order` int(11) NOT NULL, `sys_state` int(11) NOT NULL DEFAULT '0' ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4; -- -- Volcado de datos para la tabla `systems` -- INSERT INTO `systems` (`sys_id`, `sys_name`, `sys_description`, `sys_pathurl`, `sys_path`, `sys_mod_default`,`sys_code`, `sys_icon`, `sys_color`, `sys_parent_id`, `sys_indexjs`, `sys_css`, `sys_order`, `sys_state`) VALUES (1, 'Websites', NULL, 'websites', 'modules/websites/', '10', '', 'icon icon-code', '#6F91E9', 0, 'components/websites.js', 'assets/css/dist/websites.css', 0, 1), (2, 'Recursos Humanos', NULL, 'rrhh', 'modules/rrhh/', '200', '', 'icon icon-category', '#6F91E9', 0, 'components/rrhh.js', 'assets/css/dist/rrhh.css', 0, 1), (6, 'Consejeria', NULL, 'counseling', 'modules/counseling/', '600', '', 'icon icon-users', '#27d27c', 0, 'components/counseling.js', 'assets/css/dist/counseling.css', 0, 1), (7, 'Ventas', NULL, 'sales', 'modules/sales/', '700', '', 'icon icon-sales', '#fc9835', 0, 'components/sales.js', 'assets/css/dist/sales.css', 0, 0), (10, 'Suscriptiones', NULL, 'suscriptions', 'core/accounts/', '1000', '', 'icon icon-tag', '#1be5fc', 0, 'components/subscriptions.js', 'assets/css/dist/subscriptions.css', 0, 1), (12, 'Finalcial Services Leeds', NULL, 'fls', 'modules/fls/', '1200', '', 'icon icon-circle', '#27d27c', 0, 'components/fls.js', 'assets/css/dist/fls.css', 0, 0), (13, 'Boletería', NULL, 'tickets', 'modules/tickets/', '1300', '', 'icon icon-tag', '#27d27c', 0, 'components/tickets.js', 'assets/css/dist/tickets.min.css', 0, 1), (16, 'LMS', NULL, 'lms', 'modules/lms/', '1600', '', 'icon icon-graduation', '#FEBF10', 0, 'components/lms.js', 'assets/css/dist/lms.min.css', 0, 1), (19, 'CRM', NULL, 'crm', 'modules/crm/', '1900', '', 'icon icon-crm', '#ef4848', 0, 'components/crm.js', 'assets/css/dist/crm.min.css', 0, 1), (20, 'Restaurant', NULL, 'restaurants', 'modules/restaurants/', '2000', '', 'icon icon-restaurant', '#6b6fa9', 0, 'components/restaurants.js', 'assets/css/dist/restaurants.min.css', 0, 1), (23, 'Deportes', NULL, 'sports', 'modules/sports/', '2200', '', 'icon icon-sport', '#ff7629', 0, 'components/sports.js', 'assets/css/dist/sports.min.css', 0, 1), (24, 'Concursos', NULL, 'competitions', 'modules/competitions/', '2400', '', 'icon icon-copy', '#ff3333', 0, 'components/competitions.js', 'assets/css/dist/competitions.min.css', 0, 1), (37, 'Tributo App', NULL, 'app_tributo', 'modules/app_tributo/', '3700', '', 'icon icon-coin', '#003767', 0, 'components/app_tributo.js', 'assets/css/dist/app_tributo.min.css', 0, 1), (38, 'Finance (GL)', 'Gestión Financiera y Contabilidad General', 'finance', 'modules/finance/', '3800', '', 'icon icon-coin', '#10b981', 0, 'components/finance.js', 'assets/css/dist/finance.min.css', 0, 1), (39, 'REMS', NULL, 'rems', 'modules/rems/', '3900', '', 'icon icon-home', '#003900', 0, 'components/rems.js', 'assets/css/dist/rems.min.css', 0, 1), (40, 'PIM', 'Product Information Management - Gestión de Información de Productos', 'pim', 'modules/pim/', '4000', '', 'icon icon-box', '#f59e0b', 0, 'components/pim.js', 'assets/css/dist/pim.min.css', 0, 1), (41, 'WMS', 'Warehouse Management System - Gestión de Almacenes e Inventario', 'wms', 'modules/wms/', '4100', '', 'icon icon-checked', '#06b6d4', 0, 'components/wms.js', 'assets/css/dist/wms.min.css', 0, 1), (42, 'OMS', 'Order Management System - Gestión de Órdenes y Fulfillment', 'oms', 'modules/oms/', '4200', '', 'icon icon-sales', '#ef4444', 0, 'components/oms.js', 'assets/css/dist/oms.min.css', 0, 1), (43, 'FSS', 'Financial Settlement System - Sistema de Liquidación Financiera', 'fss', 'modules/fss/', '4300', '', 'icon icon-coin', '#14b8a6', 0, 'components/fss.js', 'assets/css/dist/fss.min.css', 0, 1), (44, 'CCM', 'Customer & Communication Management - Gestión de Clientes y Comunicación', 'ccm', 'modules/ccm/', '4400', '', 'icon icon-users', '#ec4899', 0, 'components/ccm.js', 'assets/css/dist/ccm.min.css', 0, 1), (45, 'BI Analytics', 'Business Intelligence - Análisis y Reportes', 'bi', 'modules/bi/', '4500', '', 'icon icon-table-check', '#6366f1', 0, 'components/bi.js', 'assets/css/dist/bi.min.css', 0, 1), (46, 'VMS', 'Vendor Management System - Gestión de Vendedores', 'vms', 'modules/vms/', '4600', '', 'icon icon-users', '#8b5cf6', 0, 'components/vms.js', 'assets/css/dist/vms.min.css', 0, 1) ; -- -- Indices de la tabla `systems` -- ALTER TABLE `systems` ADD PRIMARY KEY (`sys_id`) USING BTREE; -- -- AUTO_INCREMENT de la tabla `systems` -- ALTER TABLE `systems` MODIFY `sys_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=1; COMMIT; CREATE TABLE `systems_modules` ( `sys_mod_sys_id` int(11) NOT NULL, `sys_mod_mod_id` int(11) NOT NULL, `sys_mod_ent_id` int(11) NOT NULL, `sys_mod_order` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4; INSERT INTO `systems_modules` (`sys_mod_sys_id`, `sys_mod_mod_id`, `sys_mod_ent_id`, `sys_mod_order`) VALUES (1, 10, 1, 1), (1, 11, 1, 2), (1, 12, 1, 3), (1, 13, 1, 4), (1, 14, 1, 5), (1, 15, 1, 6), (1, 16, 1, 7), (1, 17, 1, 8), (1, 18, 1, 9), (1, 19, 1, 10), (2, 200, 1, 1), (2, 210, 1, 2), (2, 220, 1, 3), (6, 600, 1, 1), (6, 601, 1, 2), (6, 602, 1, 3), (6, 603, 1, 4), (7, 700, 1, 1), (7, 701, 1, 2), (10, 1000, 1, 1), (10, 1001, 1, 2), (10, 1002, 1, 3), (12, 1200, 1, 1), (12, 1201, 1, 2), (13, 1300, 1, 1), (13, 1301, 1, 2), (16, 1600, 1, 1), (16, 1601, 1, 2), (19, 1900, 1, 1), (19, 1901, 1, 2), (19, 1902, 1, 3), (19, 1903, 1, 4), (20, 2000, 1, 1), (20, 2001, 1, 2), (23, 2300, 1, 1), (23, 2301, 1, 2), (24, 2400, 1, 1), (37, 3700, 1, 1), (37, 3701, 1, 2), (37, 3702, 1, 3), (37, 3703, 1, 4), (38, 3800, 1, 1), (38, 3801, 1, 2), (38, 3802, 1, 3), (39, 3900, 1, 1), (39, 3901, 1, 2), (39, 3902, 1, 3), (39, 3903, 1, 4), (39, 3904, 1, 5), (39, 3905, 1, 6), (39, 3906, 1, 7), (39, 3907, 1, 8), (39, 3908, 1, 9), (39, 3909, 1, 10), (39, 3910, 1, 11), (39, 3911, 1, 12), (39, 3912, 1, 13), (39, 3913, 1, 14), (39, 3914, 1, 15), (39, 3915, 1, 16), (39, 3916, 1, 17), (40, 4000, 1, 1), (40, 4001, 1, 2), (40, 4002, 1, 3), (40, 4003, 1, 4), (41, 4100, 1, 1), (41, 4101, 1, 2), (41, 4102, 1, 3), (42, 4200, 1, 1), (42, 4201, 1, 2), (42, 4202, 1, 3), (42, 4203, 1, 4), (42, 4204, 1, 5), (43, 4300, 1, 1), (43, 4301, 1, 2), (44, 4400, 1, 1), (44, 4401, 1, 2), (44, 4402, 1, 3), (45, 4500, 1, 1), (45, 4501, 1, 2), (45, 4502, 1, 3), (46, 4600, 1, 1), (46, 4601, 1, 2), (46, 4602, 1, 3) ; -- -- Índices para tablas volcadas -- -- -- Indices de la tabla `systems_modules` -- ALTER TABLE `systems_modules` ADD PRIMARY KEY (`sys_mod_sys_id`,`sys_mod_mod_id`,`sys_mod_ent_id`) USING BTREE;