CREATE TABLE IF NOT EXISTS `#__dropset_node` (
 `did` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
 `namekey` varchar(50) NOT NULL,
 `type` tinyint(3) unsigned NOT NULL DEFAULT '0',
 `wid` smallint(5) unsigned NOT NULL DEFAULT '0',
 `alias` varchar(100) NOT NULL,
 `outype` tinyint(3) unsigned NOT NULL DEFAULT '0',
 `sid` smallint(5) unsigned NOT NULL DEFAULT '0',
 `map` varchar(20) NOT NULL,
 `ref_sid` smallint(5) unsigned NOT NULL DEFAULT '0',
 `first_value` int(10) unsigned NOT NULL DEFAULT '0',
 `first_all` tinyint(4) NOT NULL DEFAULT '0',
 `lib_ext` tinyint(4) NOT NULL DEFAULT '0',
 `external` varchar(60) NOT NULL,
 `first_caption` varchar(50) NOT NULL,
 `core` tinyint(3) unsigned NOT NULL DEFAULT '1',
 `publish` tinyint(4) NOT NULL DEFAULT '1',
 `modified` int(10) unsigned NOT NULL DEFAULT '0',
 `params` text NOT NULL,
 `mon` tinyint(4) NOT NULL DEFAULT '0',
 `level` tinyint(3) unsigned NOT NULL DEFAULT '0',
 `rolid` smallint(5) unsigned NOT NULL DEFAULT '1',
 `created` int(10) unsigned NOT NULL DEFAULT '0',
 `reload` tinyint(3) unsigned NOT NULL DEFAULT '1',
 `parent` varchar(50) NOT NULL,
 `isparent` tinyint(3) unsigned NOT NULL DEFAULT '0',
 `allowothers` tinyint(3) unsigned NOT NULL DEFAULT '0',
 `colorstyle` tinyint(3) unsigned NOT NULL DEFAULT '0',
 PRIMARY KEY (`did`),
 UNIQUE KEY `UK_dropset_node_namekey` (`namekey`),
 KEY `IX_dropset_node_wid_publish_level_rolid` (`publish`,`wid`,`level`,`rolid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 DEFAULT COLLATE=utf8mb4_unicode_ci;