-- Active: 1773863639252@@192.168.100.177@3306@colinasdellago_1
DROP TABLE IF EXISTS modules;


CREATE TABLE `modules` (
  `mod_id` int(11) NOT NULL,
  `mod_name` varchar(255) DEFAULT NULL,
  `mod_description` tinytext,
  `mod_pathurl` varchar(255) DEFAULT NULL,
  `mod_path` varchar(500) DEFAULT NULL,
  `mod_code` varchar(11) DEFAULT NULL,
  `mod_icon` varchar(255) DEFAULT NULL,
  `mod_color` varchar(10) DEFAULT NULL,
  `mod_parent_id` int(11) DEFAULT NULL,
  `mod_indexjs` varchar(400) NOT NULL,
  `mod_css` varchar(255) NOT NULL,
  `mod_db` varchar(255) NOT NULL COMMENT 'database',
  `mod_prefix_db` varchar(255) NOT NULL,
  `mod_relations_db` text NOT NULL,
  `mod_state` int(11) NOT NULL DEFAULT '0'
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4;

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

INSERT INTO `modules` (`mod_id`, `mod_name`, `mod_description`, `mod_pathurl`, `mod_path`, `mod_code`, `mod_icon`, `mod_color`, `mod_parent_id`, `mod_indexjs`, `mod_css`, `mod_db`, `mod_prefix_db`, `mod_relations_db`, `mod_state`) VALUES
(3, 'sites', NULL, 'sites', 'modules/websites/', 'SIT1', 'icon icon-blocks', '#8900ff', 0, 'components/sites.js', 'assets/css/dist/sites.css', 'sites', 'site_', '', 0),
(4, 'Hojas de Trabajo', NULL, 'worksheets', 'modules/websites/', 'WS1', 'icon icon-worksheets', '#26fff6', 0, 'components/worksheets.js', 'assets/css/dist/worksheets.css', 'worksheets', 'ws_', '', 1),
(5, 'Bloques', NULL, 'blocks', 'modules/websites/', 'BL1', 'icon icon-blocks-web', '#FEBF10', 0, 'components/blocks.js', 'assets/css/dist/blocks.css', 'blocks', 'block_', '', 1),
(6, 'Publicaciones', NULL, 'publications', 'modules/websites/', 'PUB1', 'icon icon-webpart', '#FEBF10', 0, 'components/publications.js', 'assets/css/dist/publications.css', 'publications', 'pub_', '', 1),
(10, 'Dashboard WebSites', NULL, 'websites', 'modules/websites/', 'WEB1', 'icon icon-dashboard', '#99C14C', 0, 'components/websites.js', 'assets/css/dist/websites.min.css', '', '', '', 1),
(11, 'Contenidos', NULL, 'contents', 'modules/websites/', 'CON1', 'icon icon-content', '#1ff4ed', 0, 'components/contents.js', 'assets/css/dist/contents.min.css', 'contents', 'cont_', 'contents_categorys:cont_cat_cont_id,contents_files:cont_file_cont_id', 1),
(12, 'Categorias', NULL, 'categorys', 'modules/websites/', 'CAT1', 'icon icon-category', '#dd4b4d', 0, 'components/categorys.js', 'assets/css/dist/categorys.min.css', '', '', '', 1),
(13, 'Media', NULL, 'media', 'modules/websites/', 'MED1', 'icon icon-media', '#f04f04', 0, 'components/media.js', 'assets/css/dist/media.min.css', '', '', '', 1),
(14, 'Documentos', NULL, 'docs', 'modules/websites/', 'DOC1', 'icon icon-folder', '#FEBF10', 0, 'components/docs.js', 'assets/css/dist/docs.min.css', '', '', '', 1),
(15, 'Posts', NULL, 'posts', 'modules/websites/', 'POST1', 'icon icon-news', '#37ff2c', 0, 'components/posts.js', 'assets/css/dist/posts.min.css', '', '', '', 1),
(16, 'Sliders', NULL, 'sliders', 'modules/websites/', 'SLD1', 'icon icon-slider', '#8900ff', 0, 'components/sliders.js', 'assets/css/dist/sliders.min.css', '', '', '', 1),
(17, 'Menus', NULL, 'menus', 'modules/websites/', 'MENU1', 'icon icon-list', '#26fff6', 0, 'components/menus.js', 'assets/css/dist/menus.min.css', '', '', '', 1),
(18, 'Formularios', NULL, 'formularies', 'modules/websites/', 'SLD1', 'icon icon-unchecked', '#8aec49ff', 0, 'components/formularies.js', 'assets/css/dist/formularies.min.css', '', '', '', 1),
(19, 'Popups', NULL, 'popups', 'modules/websites/', 'POP1', 'icon icon-copy', '#468de9ff', 0, 'components/popups.js', 'assets/css/dist/popups.min.css', '', '', '', 1),
(200, 'Dashboard RRHH', NULL, 'rrhh', 'modules/rrhh/', 'RRHH', 'icon icon-category', '#99C14C', 0, 'components/rrhh.js', 'assets/css/dist/rrhh.min.css', '', '', '', 0),
(210, 'kardex', NULL, 'kardex', 'modules/rrhh/', 'KDX', 'icon icon-users', '#FEBF10', 0, 'components/kardex.js', '', '', '', '', 0),
(220, 'Organigrama', NULL, 'organizationChart', 'modules/rrhh/', 'KDX', 'icon icon-users', '#FEBF10', 0, 'components/organizationChart.js', 'assets/css/dist/organizationChart', '', '', '', 0),
(600, 'Dashboard Consejeria', NULL, 'counseling', 'modules/counseling/', NULL, 'icon icon-dashboard', '#99C14C', 0, 'components/counseling.js', '', '', '', '', 1),
(601, 'Aconsejados', NULL, 'advised', 'modules/counseling/', NULL, 'icon icon-users', '#FEBF10', 0, 'components/advised.js', '', '', '', '', 1),
(602, 'Agenda', NULL, 'calendarAdvised', 'modules/counseling/', NULL, 'icon icon-calendar', '#FEBF10', 0, 'components/calendarAdvised.js', 'assets/css/dist/calendarAdvised.css', '', '', '', 1),
(603, 'Reportes', NULL, 'reportsCounseling', 'modules/counseling/', NULL, 'icon icon-table-check', '#FEBF10', 0, 'components/reportCounseling.js', 'assets/css/dist/reportCounseling.css', '', '', '', 1),
(700, 'Dashboard Ventas', NULL, 'sales', 'modules/sales/', 'PVD', 'icon icon-dashboard', '#fcc54e', 0, 'components/sales.js', 'assets/css/dist/sales.css', '', '', '', 1),
(701, 'Punto de Venta Tickets', NULL, 'salesPointTickets', 'modules/sales/', 'PVT', 'icon icon-cash-register', '#fcc54e', 0, 'components/salesPointTickets.js', 'assets/css/dist/salesPointTickets.css', '', '', '', 1),
(1000, 'Dashboard Suscripciones', NULL, 'suscriptions', 'core/accounts/', 'SC1', 'icon icon-dashboard', '#99C14', 0, 'components/subscriptions.js', 'assets/css/dist/subscriptions.css', '', '', '', 1),
(1001, 'Cuentas de Usuarios', NULL, 'accountsUsers', 'core/accounts/', 'ACC1', 'icon icon-user', '#8900ff', 0, 'components/accountsUsers.js', 'assets/css/dist/subscriptions.css', '', '', '', 1),
(1002, 'Cuentas de Clientes', NULL, 'customers', 'core/accounts/', 'CS1', 'icon icon-folder-open', '#07c472', 0, 'components/customers.js', 'assets/css/dist/customers.css', '', '', '', 1),
(1200, 'Dashboard FLS', NULL, 'fls', 'modules/fls/', 'FLS', 'icon icon-dashboard', '#fcc54e', 0, 'components/fls.js', 'assets/css/dist/fls.css', '', '', '', 1),
(1201, 'Clientes', NULL, 'flsCustomers', 'modules/fls/', 'PV', 'icon icon-users', '#fcc54e', 0, 'components/flsCustomers.js', 'assets/css/dist/flsCustomers.css', '', '', '', 1),
(1300, 'Dashboard Boletería', NULL, 'tickets', 'modules/tickets/', 'TKS', 'icon icon-dashboard', '#fcc54e', 0, 'components/tickets.js', 'assets/css/dist/tickets.min.css', '', '', '', 1),
(1301, 'Eventos', NULL, 'ticketingEvents', 'modules/tickets/', 'EVTKS', 'icon icon-tag', '#fcc54e', 0, 'components/ticketingEvents.js', 'assets/css/dist/ticketingEvents.min.css', 'mod_events', 'mod_eve_', '', 1),
(1600, 'Dashboard LMS', NULL, 'lms', 'modules/lms/', 'ADS1', 'icon icon-dashboard', '#8900ff', 0, 'components/lms.js', 'assets/css/dist/lms.min.css', '', '', '', 1),
(1601, 'Plan de Estudios', NULL, 'syllabus', 'modules/lms/', 'SB1', 'icon icon-category-r', '#8900ff', 0, 'components/syllabus.js', 'assets/css/dist/syllabus.min.css', '', '', '', 1),
(1900, 'Dashboard CRM', NULL, 'crm', 'modules/crm/', 'CRM1', 'icon icon-dashboard', '#8900ff', 0, 'components/crm.js', 'assets/css/dist/crm.min.css', '', '', '', 1),
(1901, 'Contactos', NULL, 'contacts', 'modules/crm/', 'CNT1', 'icon icon-user-plus', '#3b82f6', 0, 'components/contacts.js', 'assets/css/dist/contacts.min.css', 'mod_contacts', 'mod_con_', '', 1),
(1902, 'Clientes', NULL, 'customersCrm', 'modules/crm/', 'CS1', 'icon icon-folder-open', '#8900ff', 0, 'components/customersCrm.js', 'assets/css/dist/customersCrm.min.css', '', '', '', 1),
(1903, 'Suscripciones',NULL, 'suscriptionsCrm', 'modules/crm/', 'SC1', 'icon icon-bell', '#99C144', 0, 'components/subscriptionsCrm.js', 'assets/css/dist/suscriptionsCrm.min.css', '', '', '', 1),
(2000, 'Dashboard', NULL, 'restaurants', 'modules/restaurants/', 'RST1', 'icon icon-dashboard', '#8900ff', 0, 'components/restaurants.js', 'assets/css/dist/restaurants.min.css', '', '', '', 1),
(2001, 'Ordenes', NULL, 'commands', 'modules/restaurants/', 'CS1', 'icon icon-command', '#8900ff', 0, 'components/commands.js', 'assets/css/dist/commands.min.css', '', '', '', 1),
(2300, 'Dashboard Deportes', NULL, 'sports', 'modules/sports/', 'GEO-1', 'icon icon-dashboard', '#ff9040', 0, 'components/sports.js', 'assets/css/dist/sports.min.css', '', '', '', 1),
(2301, 'Futbol', NULL, 'futbol', 'modules/sports/', 'GEO-2', 'icon icon-futbol', '#E74745', 0, 'components/futbol.js', 'assets/css/dist/futbol.min.css', '', '', '', 1),
(2400, 'Dashboard Concursos', NULL, 'competitions', 'modules/competitions/', 'GEO-1', 'icon icon-dashboard', '#ff9040', 0, 'components/competitions.js', 'assets/css/dist/competitions.min.css', '', '', '', 1),
(3700, 'Dashboard', NULL, 'app_tributo', 'modules/app_tributo/', 'TAPP-1', 'icon icon-dashboard', '#E74745', 0, 'components/app_tributo.js', 'assets/css/dist/app_tributo.min.css', '', '', '', 1),
(3701, 'Selección', NULL, 'app_tributo_selection', 'modules/app_tributo/', 'TAPP-2', 'icon icon-tag', '#E74745', 0, 'components/app_tributo_selection.js', 'assets/css/dist/app_tributo_selection.min.css', '', '', '', 1),
(3702, 'Clientes', NULL, 'app_tributo_clients', 'modules/app_tributo/', 'TAPP-3', 'icon icon-users', '#E74745', 0, 'components/app_tributo_clients.js', 'assets/css/dist/app_tributo_clients.min.css', '', '', '', 1),
(3800, 'Dashboard Finance', 'Panel principal de gestión financiera y contabilidad', 'finance', 'modules/finance/', 'FIN-1', 'icon icon-dashboard', '#10b981', 0, 'components/finance.js', 'assets/css/dist/finance.min.css', '', '', '', 1),
(3801, 'Cuentas Contables', 'Catálogo de cuentas contables (Chart of Accounts)', 'glAccounts', 'modules/finance/', 'FIN-2', 'icon icon-category', '#10b981', 0, 'components/glAccounts.js', 'assets/css/dist/glAccounts.min.css', 'mod_gl_accounts', 'mod_gl_', '', 1),
(3802, 'Transacciones', 'Registro de transacciones y asientos contables', 'glTransactions', 'modules/finance/', 'FIN-3', 'icon icon-table-check', '#10b981', 0, 'components/glTransactions.js', 'assets/css/dist/glTransactions.min.css', 'mod_gl_transactions', 'mod_gt_', '', 1),
(3900, 'Dashboard', NULL, 'rems', 'modules/rems/', 'RAPP-1', 'icon icon-dashboard', '#E74745', 0, 'components/rems.js', 'assets/css/dist/rems.min.css', '', '', '', 1),
(3901, 'Proyectos', NULL, 'rems_projects', 'modules/rems/', 'PAPP-2', 'icon icon-operations', '#E74745', 0, 'components/rems_projects.js', 'assets/css/dist/rems_projects.min.css', '', '', '', 1),
(3902, 'Lotes', NULL, 'rems_lots', 'modules/rems/', 'LAPP-2', 'icon icon-blocks', '#E74745', 0, 'components/rems_lots.js', 'assets/css/dist/rems_lots.min.css', '', '', '', 1),
(3903, 'Fases', NULL, 'rems_phases', 'modules/rems/', 'FAPP-2', 'icon icon-list', '#E74745', 0, 'components/rems_phases.js', 'assets/css/dist/rems_phases.min.css', '', '', '', 1),
(3904, 'Contactos', NULL, 'rems_contacts', 'modules/rems/', 'CAPP-3', 'icon icon-users', '#E74745', 0, 'components/rems_contacts.js', 'assets/css/dist/rems_contacts.min.css', '', '', '', 1),
(3905, 'Documentos', NULL, 'rems_documents', 'modules/rems/', 'DAPP-4', 'icon icon-folder', '#E74745', 0, 'components/rems_documents.js', 'assets/css/dist/rems_documents.min.css', '', '', '', 1),
(3906, 'Campañas', NULL, 'rems_campaigns', 'modules/rems/', 'CAMAPP-5', 'icon icon-loudspeaker', '#E74745', 0, 'components/rems_campaigns.js', 'assets/css/dist/rems_campaigns.min.css', '', '', '', 1),
(3907, 'Leads', NULL, 'rems_leads', 'modules/rems/', 'LEAPP-6', 'icon icon-user', '#E74745', 0, 'components/rems_leads.js', 'assets/css/dist/rems_leads.min.css', '', '', '', 1),
(3908, 'Propiedades', NULL, 'rems_properties', 'modules/rems/', 'PROAPP-7', 'icon icon-fixed-assets', '#E74745', 0, 'components/rems_properties.js', 'assets/css/dist/rems_properties.min.css', '', '', '', 1),
(3909, 'Unidades', NULL, 'rems_units', 'modules/rems/', 'UNAPP-8', 'icon icon-checked', '#E74745', 0, 'components/rems_units.js', 'assets/css/dist/rems_units.min.css', '', '', '', 1),
(3910, 'Reservas', NULL, 'rems_reservations', 'modules/rems/', 'RESAPP-9', 'icon icon-tag', '#E74745', 0, 'components/rems_reservations.js', 'assets/css/dist/rems_reservations.min.css', '', '', '', 1),
(3911, 'Ventas', NULL, 'rems_sales', 'modules/rems/', 'SAAPP-10', 'icon icon-cash-register', '#E74745', 0, 'components/rems_sales.js', 'assets/css/dist/rems_sales.min.css', '', '', '', 1),
(3912, 'Transferencias', NULL, 'rems_property_transfers', 'modules/rems/', 'TRAPP-11', 'icon icon-sort', '#E74745', 0, 'components/rems_property_transfers.js', 'assets/css/dist/rems_property_transfers.min.css', '', '', '', 1),
(3913, 'Incidentes', NULL, 'rems_incidents', 'modules/rems/', 'INCAPP-12', 'icon icon-square-minus', '#E74745', 0, 'components/rems_incidents.js', 'assets/css/dist/rems_incidents.min.css', '', '', '', 1),
(3914, 'Pagos', NULL, 'rems_payments', 'modules/rems/', 'PAYAPP-13', 'icon icon-coin', '#E74745', 0, 'components/rems_payments.js', 'assets/css/dist/rems_payments.min.css', '', '', '', 1),
(3915, 'Reportes', NULL, 'rems_reports', 'modules/rems/', 'REPAPP-10', 'icon icon-doc', '#E74745', 0, 'components/rems_reports.js', 'assets/css/dist/rems_reports.min.css', '', '', '', 1),
(3916, 'Configuración', NULL, 'rems_config', 'modules/rems/', 'CONFAPP-11', 'icon icon-settings', '#E74745', 0, 'components/rems_config.js', 'assets/css/dist/rems_config.min.css', '', '', '', 1),
(4000, 'Dashboard PIM', 'Panel de gestión de información de productos', 'pim', 'modules/pim/', 'PIM-1', 'icon icon-dashboard', '#f59e0b', 0, 'components/pim.js', 'assets/css/dist/pim.min.css', '', '', '', 1),
(4001, 'Productos', 'Catálogo de productos base (entidad lógica)', 'pimProducts', 'modules/pim/', 'PIM-3', 'icon icon-box', '#f59e0b', 0, 'components/pimProducts.js', 'assets/css/dist/pimProducts.min.css', 'mod_pim_products', 'mod_pp_', '', 1),
(4002, 'Colecciones', 'Gestión de colecciones de productos', 'pimCollections', 'modules/pim/', 'PIM-2', 'icon icon-tag', '#f59e0b', 0, 'components/pimCollections.js', 'assets/css/dist/pimCollections.min.css', 'mod_pim_collections', 'mod_pcol_', '', 1),
(4003, 'SKUs', 'Variantes de producto - Unidad transaccional/inventario', 'pimSkus', 'modules/pim/', 'PIM-4', 'icon icon-tag', '#f59e0b', 0, 'components/pimSkus.js', 'assets/css/dist/pimSkus.min.css', 'mod_pim_skus', 'mod_ps_', '', 1),
(4100, 'Dashboard WMS', 'Panel de gestión de almacenes e inventario', 'wms', 'modules/wms/', 'WMS-1', 'icon icon-dashboard', '#06b6d4', 0, 'components/wms.js', 'assets/css/dist/wms.min.css', '', '', '', 1),
(4101, 'Almacenes', 'Maestro de almacenes y centros de distribución', 'warehouses', 'modules/wms/', 'WMS-2', 'icon icon-warehouse', '#06b6d4', 0, 'components/warehouses.js', 'assets/css/dist/warehouses.min.css', 'mod_wms_warehouses', 'mod_ww_', '', 1),
(4102, 'Stock', 'Balance de inventario por SKU y ubicación', 'wmsStock', 'modules/wms/', 'WMS-3', 'icon icon-box', '#06b6d4', 0, 'components/wmsStock.js', 'assets/css/dist/wmsStock.min.css', 'mod_wms_stock', 'mod_ws_', '', 1),
(4200, 'Dashboard OMS', 'Panel de gestión de órdenes y fulfillment', 'oms', 'modules/oms/', 'OMS-1', 'icon icon-dashboard', '#ef4444', 0, 'components/oms.js', 'assets/css/dist/oms.min.css', '', '', '', 1),
(4201, 'Órdenes', 'Gestión de órdenes de cliente (cabecera y detalle)', 'orders', 'modules/oms/', 'OMS-2', 'icon icon-sales', '#ef4444', 0, 'components/orders.js', 'assets/css/dist/orders.min.css', 'mod_oms_orders', 'mod_oo_', '', 1),
(4202, 'Fulfillments', 'Unidades de cumplimiento y asignación de almacenes', 'fulfillments', 'modules/oms/', 'OMS-3', 'icon icon-box', '#ef4444', 0, 'components/fulfillments.js', 'assets/css/dist/fulfillments.min.css', 'mod_oms_fulfillments', 'mod_of_', '', 1),
(4203, 'Envíos', 'Tracking de envíos y gestión de paquetería', 'shipments', 'modules/oms/', 'OMS-4', 'icon icon-pointer', '#ef4444', 0, 'components/shipments.js', 'assets/css/dist/shipments.min.css', 'mod_oms_shipments', 'mod_os_', '', 1),
(4204, 'Devoluciones', 'Gestión de devoluciones y reembolsos', 'returns', 'modules/oms/', 'OMS-5', 'icon icon-return', '#ef4444', 0, 'components/returns.js', 'assets/css/dist/returns.min.css', 'mod_oms_returns', 'mod_or_', '', 1),
(4300, 'Dashboard FSS', 'Panel de liquidación financiera a vendedores', 'fss', 'modules/fss/', 'FSS-1', 'icon icon-dashboard', '#14b8a6', 0, 'components/fss.js', 'assets/css/dist/fss.min.css', '', '', '', 1),
(4301, 'Pagos a Vendors', 'Transferencias y liquidaciones a vendedores', 'payouts', 'modules/fss/', 'FSS-2', 'icon icon-coin', '#14b8a6', 0, 'components/payouts.js', 'assets/css/dist/payouts.min.css', 'mod_fss_payouts', 'mod_fp_', '', 1),
(4400, 'Dashboard CCM', 'Panel de gestión de clientes y comunicación', 'ccm', 'modules/ccm/', 'CCM-1', 'icon icon-dashboard', '#ec4899', 0, 'components/ccm.js', 'assets/css/dist/ccm.min.css', '', '', '', 1),
(4401, 'Reseñas', 'Reseñas y ratings de productos por clientes', 'reviews', 'modules/ccm/', 'CCM-2', 'icon icon-star', '#ec4899', 0, 'components/reviews.js', 'assets/css/dist/reviews.min.css', 'mod_ccm_reviews', 'mod_cr_', '', 1),
(4402, 'Tickets Soporte', 'Sistema de tickets y atención al cliente', 'supportTickets', 'modules/ccm/', 'CCM-3', 'icon icon-tag', '#ec4899', 0, 'components/supportTickets.js', 'assets/css/dist/supportTickets.min.css', 'mod_ccm_tickets', 'mod_ct_', '', 1),
(4500, 'Dashboard BI', 'Panel de análisis y business intelligence', 'bi', 'modules/bi/', 'BI-1', 'icon icon-dashboard', '#6366f1', 0, 'components/bi.js', 'assets/css/dist/bi.min.css', '', '', '', 1),
(4501, 'Dimensiones', 'Dimensiones de tiempo, vendedores y clientes', 'biDimensions', 'modules/bi/', 'BI-2', 'icon icon-category', '#6366f1', 0, 'components/biDimensions.js', 'assets/css/dist/biDimensions.min.css', '', '', '', 1),
(4502, 'Ventas Analytics', 'Análisis de ventas, GMV y métricas del marketplace', 'biSales', 'modules/bi/', 'BI-3', 'icon icon-table-check', '#6366f1', 0, 'components/biSales.js', 'assets/css/dist/biSales.min.css', 'mod_bi_fact_sales', 'mod_bfs_', '', 1),
(4600, 'Dashboard VMS', 'Panel de gestión de vendedores del marketplace', 'vms', 'modules/vms/', 'VMS-1', 'icon icon-dashboard', '#8b5cf6', 0, 'components/vms.js', 'assets/css/dist/vms.min.css', '', '', '', 1),
(4601, 'Vendedores', 'Registro y gestión de vendedores (Vendors)', 'vendors', 'modules/vms/', 'VMS-2', 'icon icon-users', '#8b5cf6', 0, 'components/vendors.js', 'assets/css/dist/vendors.min.css', 'mod_vms_vendors', 'mod_vv_', '', 1),
(4602, 'Comisiones', 'Reglas y cálculo de comisiones del marketplace', 'commissionRules', 'modules/vms/', 'VMS-3', 'icon icon-coin', '#8b5cf6', 0, 'components/commissionRules.js', 'assets/css/dist/commissionRules.min.css', 'mod_vms_commission_rules', 'mod_vcr_', '', 1)
;
 
ALTER TABLE `modules`
  ADD PRIMARY KEY (`mod_id`) USING BTREE;

ALTER TABLE `modules`
  MODIFY `mod_id` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=4503;