   `date_created` int(11) unsigned NOT NULL,
   PRIMARY KEY (`id`)
 ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+-- -------------------------------------------------------
+
+--
+-- Table structure for `noticelists`
+--
+
+CREATE TABLE IF NOT EXISTS `noticelists` (
+    `id` int(11) NOT NULL AUTO_INCREMENT,
+    `name` varchar(255) COLLATE utf8_unicode_ci NOT NULL,
+    `expanded_name` text COLLATE utf8_unicode_ci NOT NULL,
+    `ref` text COLLATE utf8_unicode_ci,
+    `geographical_area` varchar(255) COLLATE utf8_unicode_ci,
+    `version` int(11) NOT NULL DEFAULT 1,
+    `enabled` tinyint(1) NOT NULL DEFAULT 0,
+    PRIMARY KEY (`id`),
+    INDEX `name` (`name`),
+    INDEX `geographical_area` (`geographical_area`)
+  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
+
+-- -------------------------------------------------------
+
+--
+-- Table structure for `noticelist_entries`
+--
+
+CREATE TABLE IF NOT EXISTS `noticelist_entries` (
+    `id` int(11) NOT NULL AUTO_INCREMENT,
+    `noticelist_id` int(11) NOT NULL,
+    `data` text COLLATE utf8_unicode_ci NOT NULL,
+    PRIMARY KEY (`id`),
+    INDEX `noticelist_id` (`noticelist_id`)
+  ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
 
 -- -------------------------------------------------------
 

  `description` text COLLATE utf8_bin NOT NULL,
  `version` varchar(255) COLLATE utf8_bin NOT NULL,
  `icon` VARCHAR(255) COLLATE utf8_bin NOT NULL DEFAULT '',
  PRIMARY KEY (id),
  INDEX `name` (`name`),
  INDEX `uuid` (`uuid`),
  INDEX `type` (`type`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 COLLATE=utf8_bin;

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

--

INSERT INTO `admin_settings` (`id`, `setting`, `value`) VALUES
(1, 'db_version', '11');

INSERT INTO `feeds` (`id`, `provider`, `name`, `url`, `distribution`, `default`, `enabled`) VALUES
(1, 'CIRCL', 'CIRCL OSINT Feed', 'https://www.circl.lu/doc/misp/feed-osint', 3, 1, 0),
