   `perm_sighting` tinyint(1) NOT NULL DEFAULT 0,
   `perm_object_template` tinyint(1) NOT NULL DEFAULT 0,
   `default_role` tinyint(1) NOT NULL DEFAULT 0,
+  `memory_limit` VARCHAR(255) COLLATE utf8_bin DEFAULT "",
+  `max_execution_time` VARCHAR(255) COLLATE utf8_bin DEFAULT "",
+  `restricted_to_site_admin` tinyint(1) NOT NULL DEFAULT 0,
+  `perm_publish_zmq` tinyint(1) NOT NULL DEFAULT 0,
   PRIMARY KEY (`id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
 

-- -------------------------------------------------------

--
-- Table structure for `event_blacklists`
--

CREATE TABLE IF NOT EXISTS `event_blacklists` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `event_uuid` varchar(40) COLLATE utf8_bin NOT NULL,
  `created` datetime NOT NULL,
  PRIMARY KEY (`id`),
  `event_info` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `comment` TEXT CHARACTER SET utf8 COLLATE utf8_unicode_ci NOT NULL,
  `event_orgc` VARCHAR( 255 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

-- -------------------------------------------------------


  `input_source` varchar(255) COLLATE utf8_bin NOT NULL DEFAULT "network",
  `delete_local_file` tinyint(1) DEFAULT 0,
  `lookup_visible` tinyint(1) DEFAULT 0,
  `headers` TEXT COLLATE utf8_bin,
  `caching_enabled` tinyint(1) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  INDEX `input_source` (`input_source`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- -------------------------------------------------------

--
-- Table structure for `fuzzy_correlate_ssdeep`
--

CREATE TABLE IF NOT EXISTS `fuzzy_correlate_ssdeep` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `chunk` varchar(12) NOT NULL,
  `attribute_id` int(11) NOT NULL,
  PRIMARY KEY (`id`),
  INDEX `chunk` (`chunk`),
  INDEX `attribute_id` (`attribute_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


-- -------------------------------------------------------
