-- Active: 1755472439040@@dev.wappcom.com@3306@nucleo_base
-- ============================================
-- Tabla: mod_sliders
-- ============================================
DROP TABLE IF EXISTS `mod_sliders`;

CREATE TABLE `mod_sliders` (
  `mod_sli_id` int(11) NOT NULL AUTO_INCREMENT,
  `mod_sli_name` varchar(255) NOT NULL,
  `mod_sli_description` tinytext NOT NULL,
  `mod_sli_cls` varchar(45) NOT NULL,
  `mod_sli_json` text,
  `mod_sli_date` datetime DEFAULT NULL,
  `mod_sli_date_register` datetime DEFAULT NULL,
  `mod_sli_user_id` int(11) DEFAULT NULL,
  `mod_sli_ent_id` int(11) NOT NULL,
  `mod_sli_state` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`mod_sli_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci AUTO_INCREMENT=1;

-- ============================================
-- Tabla: mod_sliders_files
-- ============================================
DROP TABLE IF EXISTS `mod_sliders_files`;

CREATE TABLE `mod_sliders_files` (
  `mod_sli_file_id` int(11) NOT NULL AUTO_INCREMENT,
  `mod_sli_file_sli_id` int(11) NOT NULL,
  `mod_sli_file_file_id` int(11) NOT NULL,
  `mod_sli_file_title` varchar(255) DEFAULT NULL,
  `mod_sli_file_btn_title` varchar(255) DEFAULT NULL,
  `mod_sli_file_link` varchar(445) DEFAULT NULL,
  `mod_sli_file_target` varchar(22) DEFAULT '_self',
  `mod_sli_file_description` tinytext,
  `mod_sli_file_order` int(11) DEFAULT '0',
  `mod_sli_file_cls` varchar(45) DEFAULT NULL,
  PRIMARY KEY (`mod_sli_file_id`) USING BTREE,
  KEY `idx_slider_id` (`mod_sli_file_sli_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci AUTO_INCREMENT=1;

-- ============================================
-- Tabla: mod_sliders_categorys
-- ============================================
DROP TABLE IF EXISTS `mod_sliders_categorys`;

CREATE TABLE `mod_sliders_categorys` (
  `mod_sli_cat_sli_id` int(11) NOT NULL,
  `mod_sli_cat_cat_id` int(11) NOT NULL,
  `mod_sli_cat_order` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`mod_sli_cat_sli_id`, `mod_sli_cat_cat_id`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;

COMMIT;