CREATE TABLE IF NOT EXISTS `#__eguillage_node` (
  `ctrid` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `namekey` varchar(100) NOT NULL,
  `app` varchar(100) NOT NULL,
  `task` varchar(100) NOT NULL,
  `premium` tinyint(4) NOT NULL DEFAULT '0',
  `admin` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `type` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `yid` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `wid` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `level` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `publish` tinyint(4) NOT NULL DEFAULT '1',
  `path` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `core` tinyint(4) NOT NULL DEFAULT '1',
  `rolid` smallint(5) unsigned NOT NULL DEFAULT '1',
  `trigger` tinyint(3) unsigned NOT NULL DEFAULT '1',
  `visible` tinyint(3) unsigned NOT NULL DEFAULT '9',
  `checkowner` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `reload` tinyint(3) unsigned NOT NULL DEFAULT '1',
  `created` int(10) unsigned NOT NULL DEFAULT '0',
  `modified` int(10) unsigned NOT NULL DEFAULT '0',
  `checkadminowner` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `pnamekey` varchar(100) NOT NULL,
  PRIMARY KEY (`ctrid`),
  UNIQUE KEY `UK_controller_app_task_admin` (`app`,`task`,`admin`),
  UNIQUE KEY `UK_controller_namekey` (`namekey`),
  KEY `IX_controller_publish_premium_level` (`publish`,`level`,`premium`),
  KEY `IX_controller_node_wid` (`wid`),
  KEY `IX_controller_node_yid` (`yid`)
) ENGINE=InnoDB   /*!40100 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci*/;