



--
-- Database: `geeklog222`
--

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

--
-- Table structure for table `[[dbprefix]]access`
--

CREATE TABLE `[[dbprefix]]access` (
  `acc_ft_id` mediumint(8) NOT NULL DEFAULT '0',
  `acc_grp_id` mediumint(8) NOT NULL DEFAULT '0',
  PRIMARY KEY (`acc_ft_id`,`acc_grp_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `[[dbprefix]]access`
--

INSERT INTO `[[dbprefix]]access` VALUES
(1, 3),
(2, 3),
(4, 3),
(5, 9),
(5, 11),
(6, 9),
(6, 11),
(7, 12),
(8, 5),
(9, 8),
(10, 4),
(11, 6),
(13, 10),
(14, 11),
(15, 11),
(16, 4),
(17, 10),
(18, 10),
(19, 11),
(20, 14),
(21, 15),
(23, 16),
(24, 16),
(25, 16),
(26, 16),
(27, 16),
(28, 16),
(29, 16),
(30, 16),
(31, 16),
(32, 16),
(33, 16),
(34, 16),
(35, 16),
(36, 16),
(37, 16),
(38, 16),
(39, 16),
(40, 16),
(41, 16),
(42, 16),
(43, 16),
(44, 16),
(45, 16),
(46, 16),
(47, 16),
(48, 16),
(49, 16),
(50, 16),
(51, 16),
(52, 16),
(53, 16),
(54, 16),
(55, 16),
(56, 16),
(57, 16),
(58, 16),
(59, 16),
(60, 16),
(61, 16),
(62, 3),
(62, 17),
(62, 25),
(63, 16),
(64, 16),
(65, 16),
(66, 16),
(67, 16),
(68, 18),
(69, 19),
(70, 3),
(70, 25),
(71, 20),
(72, 20),
(73, 20),
(74, 20),
(75, 20),
(76, 20),
(77, 20),
(78, 21),
(79, 21),
(80, 21),
(81, 21),
(82, 21),
(83, 21),
(84, 21),
(85, 21),
(86, 22),
(87, 22),
(88, 22),
(89, 22),
(90, 22),
(91, 22),
(92, 23),
(93, 24),
(95, 24),
(96, 24),
(97, 25),
(98, 25),
(100, 25),
(101, 25),
(102, 25),
(103, 25),
(104, 25),
(105, 26),
(106, 26),
(107, 26),
(108, 26),
(109, 26);

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

--
-- Table structure for table `[[dbprefix]]article_images`
--

CREATE TABLE `[[dbprefix]]article_images` (
  `ai_sid` varchar(128) NOT NULL,
  `ai_img_num` tinyint(2) unsigned NOT NULL,
  `ai_filename` varchar(128) NOT NULL,
  PRIMARY KEY (`ai_sid`,`ai_img_num`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

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

--
-- Table structure for table `[[dbprefix]]backup_codes`
--

CREATE TABLE `[[dbprefix]]backup_codes` (
  `code` varchar(16) NOT NULL,
  `uid` mediumint(8) NOT NULL DEFAULT '0',
  `is_used` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`code`),
  UNIQUE KEY `code` (`code`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

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

--
-- Table structure for table `[[dbprefix]]blocks`
--

CREATE TABLE `[[dbprefix]]blocks` (
  `bid` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `is_enabled` tinyint(1) unsigned NOT NULL DEFAULT '1',
  `name` varchar(48) NOT NULL DEFAULT '',
  `type` varchar(20) NOT NULL DEFAULT 'normal',
  `title` varchar(48) DEFAULT NULL,
  `blockorder` smallint(5) unsigned NOT NULL DEFAULT '1',
  `device` varchar(15) NOT NULL DEFAULT 'all',
  `content` text,
  `allow_autotags` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `convert_newlines` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `cache_time` int(11) NOT NULL DEFAULT '0',
  `rdfurl` varchar(255) DEFAULT NULL,
  `rdfupdated` datetime DEFAULT NULL,
  `rdf_last_modified` varchar(40) DEFAULT NULL,
  `rdf_etag` varchar(40) DEFAULT NULL,
  `rdflimit` smallint(5) unsigned NOT NULL DEFAULT '0',
  `onleft` tinyint(1) unsigned NOT NULL DEFAULT '1',
  `location` varchar(48) NOT NULL DEFAULT '',
  `phpblockfn` varchar(128) DEFAULT '',
  `help` varchar(255) DEFAULT '',
  `css_id` varchar(255) NOT NULL DEFAULT '',
  `css_classes` varchar(255) NOT NULL DEFAULT '',
  `owner_id` mediumint(8) unsigned NOT NULL DEFAULT '1',
  `group_id` mediumint(8) unsigned NOT NULL DEFAULT '1',
  `perm_owner` tinyint(1) unsigned NOT NULL DEFAULT '3',
  `perm_group` tinyint(1) unsigned NOT NULL DEFAULT '3',
  `perm_members` tinyint(1) unsigned NOT NULL DEFAULT '2',
  `perm_anon` tinyint(1) unsigned NOT NULL DEFAULT '2',
  PRIMARY KEY (`bid`),
  KEY `blocks_bid` (`bid`),
  KEY `blocks_is_enabled` (`is_enabled`),
  KEY `blocks_type` (`type`),
  KEY `blocks_name` (`name`),
  KEY `blocks_onleft` (`onleft`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=8 ;

--
-- Dumping data for table `[[dbprefix]]blocks`
--

INSERT INTO `[[dbprefix]]blocks` VALUES
(1, 1, 'user_block', 'gldefault', 'User Functions', 30, 'all', '', 0, 0, 0, '', '[[regtime]]', NULL, NULL, 0, 1, '', '', '', '', '', 2, 4, 3, 3, 2, 2),
(2, 1, 'admin_block', 'gldefault', 'Admins Only', 20, 'all', '', 0, 0, 0, '', '[[regtime]]', NULL, NULL, 0, 1, '', '', '', '', '', 2, 4, 3, 3, 2, 2),
(3, 1, 'section_block', 'gldefault', 'Topics', 10, 'all', '', 0, 0, 0, '', '[[regtime]]', NULL, NULL, 0, 1, '', '', '', '', '', 2, 4, 3, 3, 2, 2),
(4, 1, 'whats_new_block', 'gldefault', 'What''s New', 30, 'all', '', 0, 0, 0, '', '[[regtime]]', NULL, NULL, 0, 0, '', '', '', '', '', 2, 4, 3, 3, 2, 2),
(5, 1, 'first_block', 'normal', 'About Geeklog', 20, 'all', '<p><b>Welcome to Geeklog!</b></p><p>If you''re already familiar with Geeklog - and especially if you''re not: There have been many improvements to Geeklog since earlier versions that you might want to read up on. Please read the <a href="docs/english/changes.html">release notes</a>. If you need help, please see the <a href="docs/english/support.html">support options</a>.</p>', 0, 0, 0, '', '[[regtime]]', NULL, NULL, 0, 0, '', '', '', '', '', 2, 4, 3, 3, 2, 2),
(6, 1, 'whosonline_block', 'phpblock', 'Who''s Online', 10, 'all', '', 0, 0, 0, '', '[[regtime]]', NULL, NULL, 0, 0, '', 'phpblock_whosonline', '', '', '', 2, 4, 3, 3, 2, 2),
(7, 1, 'older_stories', 'gldefault', 'Older Stories', 40, 'all', '', 0, 0, 0, '', '[[regtime]]', NULL, NULL, 0, 1, '', '', '', '', '', 2, 4, 3, 3, 2, 2);

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

--
-- Table structure for table `[[dbprefix]]commentedits`
--

CREATE TABLE `[[dbprefix]]commentedits` (
  `cid` int(10) NOT NULL,
  `uid` mediumint(8) NOT NULL,
  `time` datetime NOT NULL,
  PRIMARY KEY (`cid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

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

--
-- Table structure for table `[[dbprefix]]commentnotifications`
--

CREATE TABLE `[[dbprefix]]commentnotifications` (
  `cid` int(10) DEFAULT NULL,
  `uid` mediumint(8) NOT NULL,
  `deletehash` varchar(32) NOT NULL,
  `mid` int(10) DEFAULT NULL,
  PRIMARY KEY (`deletehash`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

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

--
-- Table structure for table `[[dbprefix]]comments`
--

CREATE TABLE `[[dbprefix]]comments` (
  `cid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `type` varchar(30) NOT NULL DEFAULT 'article',
  `sid` varchar(128) NOT NULL DEFAULT '',
  `date` datetime DEFAULT NULL,
  `title` varchar(128) DEFAULT NULL,
  `comment` text,
  `pid` int(10) unsigned NOT NULL DEFAULT '0',
  `lft` mediumint(10) unsigned NOT NULL DEFAULT '0',
  `rht` mediumint(10) unsigned NOT NULL DEFAULT '0',
  `indent` mediumint(10) unsigned NOT NULL DEFAULT '0',
  `name` varchar(32) DEFAULT NULL,
  `uid` mediumint(8) NOT NULL DEFAULT '1',
  `seq` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`cid`),
  KEY `comments_sid` (`sid`),
  KEY `comments_uid` (`uid`),
  KEY `comments_lft` (`lft`),
  KEY `comments_rht` (`rht`),
  KEY `comments_date` (`date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `[[dbprefix]]commentsubmissions`
--

CREATE TABLE `[[dbprefix]]commentsubmissions` (
  `cid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `type` varchar(30) NOT NULL DEFAULT 'article',
  `sid` varchar(128) NOT NULL,
  `date` datetime DEFAULT NULL,
  `title` varchar(128) DEFAULT NULL,
  `comment` text,
  `uid` mediumint(8) NOT NULL DEFAULT '1',
  `name` varchar(32) DEFAULT NULL,
  `pid` int(10) NOT NULL DEFAULT '0',
  `seq` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`cid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `[[dbprefix]]conf_values`
--

CREATE TABLE `[[dbprefix]]conf_values` (
  `name` varchar(50) DEFAULT NULL,
  `value` text,
  `type` varchar(50) DEFAULT NULL,
  `group_name` varchar(50) DEFAULT NULL,
  `default_value` text,
  `subgroup` int(11) DEFAULT NULL,
  `selectionArray` int(11) DEFAULT NULL,
  `sort_order` int(11) DEFAULT NULL,
  `tab` int(11) DEFAULT NULL,
  `fieldset` int(11) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;


INSERT INTO `[[dbprefix]]conf_values` VALUES
('score_story', 'd:0.5;', 'text', 'recaptcha', 'd:0.5;', 0, -1, 270, 2, 0),
('sg_main', 'N;', 'subgroup', 'spamx', 'N;', 0, -1, 0, 0, 0),
('tab_main', 'N;', 'tab', 'spamx', 'N;', 0, -1, 0, 0, 0),
('fs_main', 'N;', 'fieldset', 'spamx', 'N;', 0, -1, 0, 0, 0),
('logging', 'b:1;', 'select', 'spamx', 'b:1;', 0, 1, 10, 0, 0),
('timeout', 'i:5;', 'text', 'spamx', 'i:5;', 0, -1, 30, 0, 0),
('notification_email', 'unset', 'text', 'spamx', 's:0:"";', 0, -1, 40, 0, 0),
('spamx_action', 'unset', 'text', 'spamx', 'i:128;', 0, -1, 50, 0, 0),
('max_age', 'i:0;', 'text', 'spamx', 'i:0;', 0, -1, 60, 0, 0),
('records_delete', 'a:2:{i:0;s:5:"email";i:1;s:2:"IP";}', '%text', 'spamx', 'a:2:{i:0;s:5:"email";i:1;s:2:"IP";}', 0, -1, 70, 0, 0),
('tab_modules', 'N;', 'tab', 'spamx', 'N;', 0, -1, 0, 10, 0),
('fs_sfs', 'N;', 'fieldset', 'spamx', 'N;', 0, -1, 0, 10, 0),
('sfs_enabled', 'b:0;', 'select', 'spamx', 'b:0;', 0, 1, 10, 10, 0),
('sfs_confidence', 'i:25;', 'text', 'spamx', 'i:25;', 0, -1, 20, 10, 0),
('fs_snl', 'N;', 'fieldset', 'spamx', 'N;', 0, -1, 0, 10, 10),
('snl_enabled', 'b:0;', 'select', 'spamx', 'b:0;', 0, 1, 10, 10, 10),
('snl_num_links', 'i:5;', 'text', 'spamx', 'i:5;', 0, -1, 20, 10, 10),
('fs_akismet', 'N;', 'fieldset', 'spamx', 'N;', 0, -1, 0, 10, 20),
('akismet_enabled', 'b:0;', 'select', 'spamx', 'b:0;', 0, 1, 10, 10, 20),
('akismet_api_key', 's:0:"";', 'text', 'spamx', 's:0:"";', 0, -1, 20, 10, 20),
('sg_main', 'N;', 'subgroup', 'staticpages', 'N;', 0, -1, 0, 0, 0),
('tab_main', 'N;', 'tab', 'staticpages', 'N;', 0, -1, 0, 0, 0),
('fs_main', 'N;', 'fieldset', 'staticpages', 'N;', 0, -1, 0, 0, 0),
('allow_php', 'i:0;', 'select', 'staticpages', 'i:0;', 0, 0, 10, 0, 0),
('enable_eval_php_save', 'i:0;', 'select', 'staticpages', 'i:0;', 0, 0, 15, 0, 0),
('sort_by', 's:2:"id";', 'select', 'staticpages', 's:2:"id";', 0, 2, 20, 0, 0),
('sort_menu_by', 's:5:"label";', 'select', 'staticpages', 's:5:"label";', 0, 3, 30, 0, 0),
('sort_list_by', 's:5:"title";', 'select', 'staticpages', 's:5:"title";', 0, 4, 35, 0, 0),
('delete_pages', 'i:0;', 'select', 'staticpages', 'i:0;', 0, 0, 40, 0, 0),
('in_block', 'i:1;', 'select', 'staticpages', 'i:1;', 0, 0, 50, 0, 0),
('show_hits', 'i:1;', 'select', 'staticpages', 'i:1;', 0, 0, 60, 0, 0),
('show_date', 'i:1;', 'select', 'staticpages', 'i:1;', 0, 0, 70, 0, 0),
('filter_html', 'i:0;', 'select', 'staticpages', 'i:0;', 0, 0, 80, 0, 0),
('censor', 'i:0;', 'select', 'staticpages', 'i:0;', 0, 0, 90, 0, 0),
('aftersave', 's:4:"list";', 'select', 'staticpages', 's:4:"list";', 0, 9, 100, 0, 0),
('atom_max_items', 'i:10;', 'text', 'staticpages', 'i:10;', 0, -1, 110, 0, 0),
('meta_tags', 'i:0;', 'select', 'staticpages', 'i:0;', 0, 0, 120, 0, 0),
('comment_code', 'i:-1;', 'select', 'staticpages', 'i:-1;', 0, 17, 125, 0, 0),
('structured_data_type_default', 's:12:"core-webpage";', 'select', 'staticpages', 's:12:"core-webpage";', 0, 39, 126, 0, 0),
('draft_flag', 'i:0;', 'select', 'staticpages', 'i:0;', 0, 0, 127, 0, 0),
('disable_breadcrumbs_staticpages', 'i:0;', 'select', 'staticpages', 'i:0;', 0, 0, 128, 0, 0),
('default_cache_time', 'i:0;', 'text', 'staticpages', 'i:0;', 0, -1, 129, 0, 0),
('likes_pages', 'i:0;', 'select', 'staticpages', 'i:0;', 0, 41, 130, 0, 0),
('langurl_staticpages', 'a:3:{i:0;s:11:"staticpages";i:1;s:9:"index.php";i:2;s:4:"page";}', '@hidden', 'Core', 'a:3:{i:0;s:11:"staticpages";i:1;s:9:"index.php";i:2;s:4:"page";}', 7, 1, 1830, 31, 31),
('tab_whatsnew', 'N;', 'tab', 'staticpages', 'N;', 0, -1, 0, 1, 1),
('fs_whatsnew', 'N;', 'fieldset', 'staticpages', 'N;', 0, -1, 0, 1, 1),
('newstaticpagesinterval', 'i:1209600;', 'text', 'staticpages', 'i:1209600;', 0, -1, 10, 1, 1),
('hidenewstaticpages', 's:4:"hide";', 'select', 'staticpages', 's:4:"hide";', 0, 5, 20, 1, 1),
('title_trim_length', 'i:20;', 'text', 'staticpages', 'i:20;', 0, -1, 30, 1, 1),
('includecenterblocks', 'i:0;', 'select', 'staticpages', 'i:0;', 0, 0, 40, 1, 1),
('includephp', 'i:0;', 'select', 'staticpages', 'i:0;', 0, 0, 50, 1, 1),
('tab_search', 'N;', 'tab', 'staticpages', 'N;', 0, -1, 0, 2, 2),
('fs_search', 'N;', 'fieldset', 'staticpages', 'N;', 0, -1, 0, 2, 2),
('includesearch', 'i:1;', 'select', 'staticpages', 'i:1;', 0, 0, 10, 2, 2),
('includesearchcenterblocks', 'i:0;', 'select', 'staticpages', 'i:0;', 0, 0, 20, 2, 2),
('includesearchphp', 'i:0;', 'select', 'staticpages', 'i:0;', 0, 0, 30, 2, 2),
('includesearchtemplate', 'i:0;', 'select', 'staticpages', 'i:0;', 0, 0, 40, 2, 2),
('tab_permissions', 'N;', 'tab', 'staticpages', 'N;', 0, -1, 0, 3, 3),
('fs_permissions', 'N;', 'fieldset', 'staticpages', 'N;', 0, -1, 0, 3, 3),
('default_permissions', 'a:4:{i:0;i:3;i:1;i:2;i:2;i:2;i:3;i:2;}', '@select', 'staticpages', 'a:4:{i:0;i:3;i:1;i:2;i:2;i:2;i:3;i:2;}', 0, 12, 130, 3, 3),
('tab_autotag_permissions', 'N;', 'tab', 'staticpages', 'N;', 0, -1, 0, 10, 10),
('fs_autotag_permissions', 'N;', 'fieldset', 'staticpages', 'N;', 0, -1, 0, 10, 10),
('autotag_permissions_staticpage', 'a:4:{i:0;i:2;i:1;i:2;i:2;i:2;i:3;i:2;}', '@select', 'staticpages', 'a:4:{i:0;i:2;i:1;i:2;i:2;i:2;i:3;i:2;}', 0, 13, 10, 10, 10),
('autotag_permissions_staticpage_content', 'a:4:{i:0;i:2;i:1;i:2;i:2;i:0;i:3;i:0;}', '@select', 'staticpages', 'a:4:{i:0;i:2;i:1;i:2;i:2;i:0;i:3;i:0;}', 0, 13, 10, 10, 10),
('sg_main', 'N;', 'subgroup', 'xmlsitemap', 'N;', 0, -1, 0, 0, 0),
('tab_main', 'N;', 'tab', 'xmlsitemap', 'N;', 0, -1, 0, 0, 0),
('fs_main', 'N;', 'fieldset', 'xmlsitemap', 'N;', 0, -1, 0, 0, 0),
('sitemap_file', 's:11:"sitemap.xml";', 'text', 'xmlsitemap', 's:11:"sitemap.xml";', 0, -1, 10, 0, 0),
('mobile_sitemap_file', 'unset', 'text', 'xmlsitemap', 's:18:"mobile_sitemap.xml";', 0, -1, 20, 0, 0),
('include_homepage', 'b:0;', 'select', 'xmlsitemap', 'b:0;', 0, 1, 25, 0, 0),
('types', 'a:4:{i:0;s:7:"article";i:1;s:8:"calendar";i:2;s:5:"polls";i:3;s:11:"staticpages";}', '%text', 'xmlsitemap', 'a:4:{i:0;s:7:"article";i:1;s:8:"calendar";i:2;s:5:"polls";i:3;s:11:"staticpages";}', 0, -1, 30, 0, 0),
('lastmod', 'a:4:{i:0;s:7:"article";i:1;s:8:"calendar";i:2;s:5:"polls";i:3;s:11:"staticpages";}', '%text', 'xmlsitemap', 'a:4:{i:0;s:7:"article";i:1;s:8:"calendar";i:2;s:5:"polls";i:3;s:11:"staticpages";}', 0, -1, 50, 0, 0),
('tab_pri', 'N;', 'tab', 'xmlsitemap', 'N;', 0, -1, 0, 1, 1),
('fs_pri', 'N;', 'fieldset', 'xmlsitemap', 'N;', 0, -1, 0, 1, 1),
('priorities', 'a:4:{s:7:"article";d:0.5;s:8:"calendar";d:0.5;s:5:"polls";d:0.5;s:11:"staticpages";d:0.5;}', '*text', 'xmlsitemap', 'a:4:{s:7:"article";d:0.5;s:8:"calendar";d:0.5;s:5:"polls";d:0.5;s:11:"staticpages";d:0.5;}', 0, -1, 50, 1, 1),
('tab_freq', 'N;', 'tab', 'xmlsitemap', 'N;', 0, -1, 0, 2, 2),
('fs_freq', 'N;', 'fieldset', 'xmlsitemap', 'N;', 0, -1, 0, 2, 2),
('frequencies', 'a:4:{s:7:"article";s:5:"daily";s:8:"calendar";s:5:"daily";s:5:"polls";s:5:"daily";s:11:"staticpages";s:6:"weekly";}', '@select', 'xmlsitemap', 'a:4:{s:7:"article";s:5:"daily";s:8:"calendar";s:5:"daily";s:5:"polls";s:5:"daily";s:11:"staticpages";s:6:"weekly";}', 0, 20, 60, 2, 2),
('tab_ping', 'N;', 'tab', 'xmlsitemap', 'N;', 0, -1, 0, 3, 3),
('fs_ping', 'N;', 'fieldset', 'xmlsitemap', 'N;', 0, -1, 0, 3, 3),
('ping_google', 'b:1;', 'select', 'xmlsitemap', 'b:1;', 0, 1, 100, 3, 3),
('indexnow', 'b:0;', 'select', 'xmlsitemap', 'b:0;', 0, 1, 110, 3, 3),
('indexnow_key', 's:0:"";', 'text', 'xmlsitemap', 's:0:"";', 0, -1, 111, 3, 3),
('indexnow_key_location', 's:0:"";', 'text', 'xmlsitemap', 's:0:"";', 0, -1, 112, 3, 3),
('tab_news', 'N;', 'tab', 'xmlsitemap', 'N;', 0, -1, 0, 4, 4),
('fs_news', 'N;', 'fieldset', 'xmlsitemap', 'N;', 0, -1, 0, 4, 4),
('news_sitemap_file', 'unset', 'text', 'xmlsitemap', 's:16:"news_sitemap.xml";', 0, -1, 120, 4, 4),
('news_sitemap_topics', 'a:0:{}', '%text', 'xmlsitemap', 'a:0:{}', 0, -1, 130, 4, 4),
('news_sitemap_age', 'i:172800;', 'text', 'xmlsitemap', 'i:172800;', 0, -1, 140, 4, 4);

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

--
-- Table structure for table `[[dbprefix]]events`
--

CREATE TABLE `[[dbprefix]]events` (
  `eid` varchar(20) NOT NULL DEFAULT '',
  `title` varchar(128) DEFAULT NULL,
  `description` text,
  `postmode` varchar(10) NOT NULL DEFAULT 'plaintext',
  `datestart` date DEFAULT NULL,
  `dateend` date DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `hits` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `owner_id` mediumint(8) unsigned NOT NULL DEFAULT '1',
  `group_id` mediumint(8) unsigned NOT NULL DEFAULT '1',
  `perm_owner` tinyint(1) unsigned NOT NULL DEFAULT '3',
  `perm_group` tinyint(1) unsigned NOT NULL DEFAULT '3',
  `perm_members` tinyint(1) unsigned NOT NULL DEFAULT '2',
  `perm_anon` tinyint(1) unsigned NOT NULL DEFAULT '2',
  `address1` varchar(40) DEFAULT NULL,
  `address2` varchar(40) DEFAULT NULL,
  `city` varchar(60) DEFAULT NULL,
  `state` varchar(40) DEFAULT NULL,
  `zipcode` varchar(16) DEFAULT NULL,
  `allday` tinyint(1) NOT NULL DEFAULT '0',
  `event_type` varchar(40) NOT NULL DEFAULT '',
  `location` varchar(128) DEFAULT NULL,
  `timestart` time DEFAULT NULL,
  `timeend` time DEFAULT NULL,
  PRIMARY KEY (`eid`),
  KEY `events_eid` (`eid`),
  KEY `events_event_type` (`event_type`),
  KEY `events_datestart` (`datestart`),
  KEY `events_dateend` (`dateend`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

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

--
-- Table structure for table `[[dbprefix]]eventsubmission`
--

CREATE TABLE `[[dbprefix]]eventsubmission` (
  `eid` varchar(20) NOT NULL DEFAULT '',
  `title` varchar(128) DEFAULT NULL,
  `description` text,
  `location` varchar(128) DEFAULT NULL,
  `datestart` date DEFAULT NULL,
  `dateend` date DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `allday` tinyint(1) NOT NULL DEFAULT '0',
  `zipcode` varchar(16) DEFAULT NULL,
  `state` varchar(40) DEFAULT NULL,
  `city` varchar(60) DEFAULT NULL,
  `address2` varchar(40) DEFAULT NULL,
  `address1` varchar(40) DEFAULT NULL,
  `event_type` varchar(40) NOT NULL DEFAULT '',
  `timestart` time DEFAULT NULL,
  `timeend` time DEFAULT NULL,
  `owner_id` mediumint(8) unsigned NOT NULL DEFAULT '1',
  PRIMARY KEY (`eid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `[[dbprefix]]eventsubmission`
--

INSERT INTO `[[dbprefix]]eventsubmission` VALUES
('2008050110130162', 'Installed the Calendar plugin', 'Today, you successfully installed the Calendar plugin.', 'Your webserver', '[[regday]]', '[[regday]]', 'https://www.geeklog.net/', 1, NULL, NULL, NULL, NULL, NULL, '', NULL, NULL, 1);

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

--
-- Table structure for table `[[dbprefix]]features`
--

CREATE TABLE `[[dbprefix]]features` (
  `ft_id` mediumint(8) NOT NULL AUTO_INCREMENT,
  `ft_name` varchar(50) NOT NULL DEFAULT '',
  `ft_descr` varchar(255) NOT NULL DEFAULT '',
  `ft_gl_core` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`ft_id`),
  KEY `ft_name` (`ft_name`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=110 ;

--
-- Dumping data for table `[[dbprefix]]features`
--

INSERT INTO `[[dbprefix]]features` VALUES
(1, 'story.edit', 'Access to story editor', 1),
(2, 'story.moderate', 'Ability to moderate pending stories', 1),
(3, 'story.submit', 'May skip the story submission queue', 1),
(4, 'story.ping', 'Ability to send pings, pingbacks, or trackbacks for stories', 1),
(5, 'user.edit', 'Access to user editor', 1),
(6, 'user.delete', 'Ability to delete a user', 1),
(7, 'user.mail', 'Ability to send email to members', 1),
(8, 'syndication.edit', 'Access to Content Syndication', 1),
(9, 'webservices.atompub', 'May use Atompub Webservices (if restricted)', 1),
(10, 'block.edit', 'Access to block editor', 1),
(11, 'topic.edit', 'Access to topic editor', 1),
(13, 'plugin.edit', 'Can change plugin status', 1),
(14, 'group.edit', 'Ability to edit groups', 1),
(15, 'group.delete', 'Ability to delete groups', 1),
(16, 'block.delete', 'Ability to delete a block', 1),
(17, 'plugin.install', 'Can install/uninstall plugins', 1),
(18, 'plugin.upload', 'Can upload new plugins', 1),
(19, 'group.assign', 'Ability to assign users to groups', 1),
(20, 'comment.moderate', 'Ability to moderate comments', 1),
(21, 'comment.submit', 'Comments are automatically published', 1),
(22, 'htmlfilter.skip', 'Skip filtering posts for HTML', 1),
(23, 'config.Core.tab_site', 'Access to configure site', 1),
(24, 'config.Core.tab_mail', 'Access to configure mail', 1),
(25, 'config.Core.tab_syndication', 'Access to configure syndication', 1),
(26, 'config.Core.tab_paths', 'Access to configure paths', 1),
(27, 'config.Core.tab_pear', 'Access to configure PEAR', 1),
(28, 'config.Core.tab_mysql', 'Access to configure MySQL', 1),
(29, 'config.Core.tab_search', 'Access to configure search', 1),
(30, 'config.Core.tab_story', 'Access to configure story', 1),
(31, 'config.Core.tab_trackback', 'Access to configure trackback', 1),
(32, 'config.Core.tab_pingback', 'Access to configure pingback', 1),
(33, 'config.Core.tab_theme', 'Access to configure theme', 1),
(34, 'config.Core.tab_theme_advanced', 'Access to configure theme advanced settings', 1),
(35, 'config.Core.tab_admin_block', 'Access to configure admin block', 1),
(36, 'config.Core.tab_topics_block', 'Access to configure topics block', 1),
(37, 'config.Core.tab_whosonline_block', 'Access to configure who''s online block', 1),
(38, 'config.Core.tab_whatsnew_block', 'Access to configure what''s new block', 1),
(39, 'config.Core.tab_users', 'Access to configure users', 1),
(40, 'config.Core.tab_spamx', 'Access to configure Spam-x', 1),
(41, 'config.Core.tab_login', 'Access to configure login settings', 1),
(42, 'config.Core.tab_user_submission', 'Access to configure user submission', 1),
(43, 'config.Core.tab_submission', 'Access to configure submission settings', 1),
(44, 'config.Core.tab_comments', 'Access to configure comments', 1),
(45, 'config.Core.tab_imagelib', 'Access to configure image library', 1),
(46, 'config.Core.tab_upload', 'Access to configure upload', 1),
(47, 'config.Core.tab_articleimg', 'Access to configure images in article', 1),
(48, 'config.Core.tab_topicicon', 'Access to configure topic icons', 1),
(49, 'config.Core.tab_userphoto', 'Access to configure photos', 1),
(50, 'config.Core.tab_gravatar', 'Access to configure gravatar', 1),
(51, 'config.Core.tab_language', 'Access to configure language', 1),
(52, 'config.Core.tab_locale', 'Access to configure locale', 1),
(53, 'config.Core.tab_cookies', 'Access to configure cookies', 1),
(54, 'config.Core.tab_misc', 'Access to configure miscellaneous settings', 1),
(55, 'config.Core.tab_debug', 'Access to configure debug', 1),
(56, 'config.Core.tab_daily_digest', 'Access to configure daily digest', 1),
(57, 'config.Core.tab_htmlfilter', 'Access to configure HTML filtering', 1),
(58, 'config.Core.tab_censoring', 'Access to configure censoring', 1),
(59, 'config.Core.tab_iplookup', 'Access to configure IP lookup', 1),
(60, 'config.Core.tab_permissions', 'Access to configure default permissions for story, topic, block and autotags', 1),
(61, 'config.Core.tab_webservices', 'Access to configure webservices', 1),
(62, 'filemanager.admin', 'Ability to use File Manager', 0),
(63, 'config.Filemanager.tab_general', 'Access to configure Filemanager General Settings', 0),
(64, 'config.Filemanager.tab_upload', 'Access to configure Filemanager Upload Settings', 0),
(65, 'config.Filemanager.tab_images', 'Access to configure Filemanager Images Settings', 0),
(66, 'config.Filemanager.tab_videos', 'Access to configure Filemanager Videos Settings', 0),
(67, 'config.Filemanager.tab_audios', 'Access to configure Filemanager Audios Settings', 0),
(68, 'language.edit', 'Can manage Language Settings', 1),
(69, 'theme.edit', 'Can manage Theme Settings', 1),
(70, 'structureddata.autotag', 'Can use the Structured Data Autotag', 1),
(71, 'calendar.moderate', 'Ability to moderate pending events', 0),
(72, 'calendar.edit', 'Access to event editor', 0),
(73, 'calendar.submit', 'May skip the event submission queue', 0),
(74, 'config.calendar.tab_main', 'Access to configure general calendar settings', 0),
(75, 'config.calendar.tab_permissions', 'Access to configure event default permissions', 0),
(76, 'config.calendar.tab_autotag_permissions', 'Access to configure event autotag usage permissions', 0),
(77, 'config.calendar.tab_events_block', 'Access to configure events block', 0),
(78, 'links.edit', 'Access to links editor', 0),
(79, 'links.moderate', 'Ability to moderate pending links', 0),
(80, 'links.submit', 'May skip the links submission queue', 0),
(81, 'config.links.tab_public', 'Access to configure public links list settings', 0),
(82, 'config.links.tab_admin', 'Access to configure links admin settings', 0),
(83, 'config.links.tab_permissions', 'Access to configure link permissions', 0),
(84, 'config.links.tab_cpermissions', 'Access to configure link''s category permissions', 0),
(85, 'config.links.tab_autotag_permissions', 'Access to configure link''s autotag usage permissions', 0),
(86, 'polls.edit', 'Access to polls editor', 0),
(87, 'config.polls.tab_whatsnew', 'Access to configure polls what''s new block', 0),
(88, 'config.polls.tab_main', 'Access to configure general polls settings', 0),
(89, 'config.polls.tab_permissions', 'Access to configure polls default permissions', 0),
(90, 'config.polls.tab_autotag_permissions', 'Access to configure polls autotag usage permissions', 0),
(91, 'config.polls.tab_poll_block', 'Access to configure polls block', 0),
(92, 'recaptcha.edit', 'Access to reCAPTCHA editor', 0),
(93, 'spamx.admin', 'Full access to Spam-X plugin', 0),
(94, 'spamx.skip', 'Skip checking posts for Spam', 0),
(95, 'config.spamx.tab_main', 'Access to configure Spam-x main settings', 0),
(96, 'config.spamx.tab_modules', 'Access to configure Spam-x modules', 0),
(97, 'staticpages.edit', 'Access to Static Pages editor', 0),
(98, 'staticpages.delete', 'Ability to delete static pages', 0),
(99, 'staticpages.PHP', 'Ability to use PHP in static pages', 0),
(100, 'config.staticpages.tab_main', 'Access to configure static pages main settings', 0),
(101, 'config.staticpages.tab_whatsnew', 'Access to configure static pages what''s new block', 0),
(102, 'config.staticpages.tab_search', 'Access to configure static pages search results', 0),
(103, 'config.staticpages.tab_permissions', 'Access to configure static pages default permissions', 0),
(104, 'config.staticpages.tab_autotag_permissions', 'Access to configure static pages autotag usage permissions', 0),
(105, 'xmlsitemap.edit', 'Access to XMLSitemap administration screen', 0),
(106, 'config.xmlsitemap.tab_main', 'Access to configure general XMLSitemap settings', 0),
(107, 'config.xmlsitemap.tab_pri', 'Access to configure XMLSitemap priorities', 0),
(108, 'config.xmlsitemap.tab_freq', 'Access to configure XMLSitemap update frequency', 0),
(109, 'config.xmlsitemap.tab_ping', 'Access to configure XMLSitemap pings', 0);

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

--
-- Table structure for table `[[dbprefix]]groups`
--

CREATE TABLE `[[dbprefix]]groups` (
  `grp_id` mediumint(8) NOT NULL AUTO_INCREMENT,
  `grp_name` varchar(50) NOT NULL DEFAULT '',
  `grp_descr` varchar(255) NOT NULL DEFAULT '',
  `grp_gl_core` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `grp_default` tinyint(1) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`grp_id`),
  UNIQUE KEY `grp_name` (`grp_name`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=27 ;

--
-- Dumping data for table `[[dbprefix]]groups`
--

INSERT INTO `[[dbprefix]]groups` VALUES
(1, 'Root', 'Has full access to the site', 1, 0),
(2, 'All Users', 'Group that a typical user is added to', 1, 0),
(3, 'Story Admin', 'Has full access to story features', 1, 0),
(4, 'Block Admin', 'Has full access to block features', 1, 0),
(5, 'Syndication Admin', 'Can create and modify web feeds for the site', 1, 0),
(6, 'Topic Admin', 'Has full access to topic features', 1, 0),
(7, 'Remote Users', 'Users in this group can have authenticated against a remote server.', 1, 0),
(8, 'Webservices Users', 'Can use the Webservices API (if restricted)', 0, 0),
(9, 'User Admin', 'Has full access to user features', 1, 0),
(10, 'Plugin Admin', 'Has full access to plugin features', 1, 0),
(11, 'Group Admin', 'Is a User Admin with access to groups, too', 1, 0),
(12, 'Mail Admin', 'Can use Mail Utility', 1, 0),
(13, 'Logged-in Users', 'All registered members', 1, 0),
(14, 'Comment Admin', 'Can moderate comments', 1, 0),
(15, 'Comment Submitters', 'Can submit comments', 0, 0),
(16, 'Configuration Admin', 'Has full access to configuration', 1, 0),
(17, 'Filemanager Admin', 'Has full access to File Manager', 1, 0),
(18, 'Language Admin', 'Has full access to language', 1, 0),
(19, 'Theme Admin', 'Has full access to themes', 1, 0),
(20, 'Calendar Admin', 'Has full access to Calendar features', 0, 0),
(21, 'Links Admin', 'Has full access to Links features', 0, 0),
(22, 'Polls Admin', 'Has full access to Polls features', 0, 0),
(23, 'reCAPTCHA Admin', 'Users in this group can administer the ReCAPTCHA plugin', 0, 0),
(24, 'spamx Admin', 'Users in this group can administer the Spam-X plugin', 0, 0),
(25, 'Static Page Admin', 'Users in this group can administer the Static Pages plugin', 0, 0),
(26, 'XMLSitemap Admin', 'Has full access to XMLSitemap features', 0, 0);

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

--
-- Table structure for table `[[dbprefix]]group_assignments`
--

CREATE TABLE `[[dbprefix]]group_assignments` (
  `ug_main_grp_id` mediumint(8) NOT NULL DEFAULT '0',
  `ug_uid` mediumint(8) unsigned DEFAULT NULL,
  `ug_grp_id` mediumint(8) unsigned DEFAULT NULL,
  KEY `group_assignments_ug_main_grp_id` (`ug_main_grp_id`),
  KEY `group_assignments_ug_uid` (`ug_uid`),
  KEY `ug_main_grp_id` (`ug_main_grp_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `[[dbprefix]]group_assignments`
--

INSERT INTO `[[dbprefix]]group_assignments` VALUES
(2, 1, NULL),
(2, 2, NULL),
(13, 2, NULL),
(1, 2, NULL),
(9, NULL, 11),
(3, NULL, 1),
(4, NULL, 1),
(5, NULL, 1),
(6, NULL, 1),
(8, NULL, 1),
(9, NULL, 1),
(10, NULL, 1),
(11, NULL, 1),
(12, NULL, 1),
(14, NULL, 1),
(15, NULL, 1),
(16, NULL, 1),
(17, NULL, 1),
(18, NULL, 1),
(19, NULL, 1),
(20, NULL, 1),
(21, NULL, 1),
(22, NULL, 1),
(23, NULL, 1),
(24, NULL, 1),
(25, NULL, 1),
(26, NULL, 1);

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

--
-- Table structure for table `[[dbprefix]]ip_addresses`
--

CREATE TABLE `[[dbprefix]]ip_addresses` (
  `seq` int(11) NOT NULL AUTO_INCREMENT,
  `ipaddress` varchar(39) NOT NULL DEFAULT '0.0.0.0',
  `created_at` int(11) NOT NULL DEFAULT '0',
  `is_anonymized` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`seq`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;

--
-- Dumping data for table `[[dbprefix]]ip_addresses`
--



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

--
-- Table structure for table `[[dbprefix]]language_items`
--

CREATE TABLE `[[dbprefix]]language_items` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `var_name` varchar(30) NOT NULL,
  `language` varchar(30) NOT NULL,
  `name` varchar(30) NOT NULL,
  `value` text,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `[[dbprefix]]likes`
--

CREATE TABLE `[[dbprefix]]likes` (
  `lid` int(11) NOT NULL AUTO_INCREMENT,
  `type` varchar(30) NOT NULL,
  `subtype` varchar(15) NOT NULL DEFAULT '',
  `id` varchar(128) NOT NULL,
  `uid` mediumint(9) NOT NULL,
  `seq` int(11) NOT NULL DEFAULT '0',
  `action` tinyint(4) NOT NULL,
  `created` datetime NOT NULL,
  PRIMARY KEY (`lid`),
  KEY `type` (`type`,`subtype`,`id`),
  KEY `type_2` (`type`,`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `[[dbprefix]]linkcategories`
--

CREATE TABLE `[[dbprefix]]linkcategories` (
  `cid` varchar(32) NOT NULL,
  `pid` varchar(32) NOT NULL,
  `category` varchar(32) NOT NULL,
  `description` text,
  `tid` varchar(20) DEFAULT NULL,
  `created` datetime DEFAULT NULL,
  `modified` datetime DEFAULT NULL,
  `owner_id` mediumint(8) unsigned NOT NULL DEFAULT '1',
  `group_id` mediumint(8) unsigned NOT NULL DEFAULT '1',
  `perm_owner` tinyint(1) unsigned NOT NULL DEFAULT '3',
  `perm_group` tinyint(1) unsigned NOT NULL DEFAULT '2',
  `perm_members` tinyint(1) unsigned NOT NULL DEFAULT '2',
  `perm_anon` tinyint(1) unsigned NOT NULL DEFAULT '2',
  PRIMARY KEY (`cid`),
  KEY `links_pid` (`pid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `[[dbprefix]]linkcategories`
--

INSERT INTO `[[dbprefix]]linkcategories` VALUES
('geeklog-sites', 'site', 'Geeklog Sites', 'Sites using or related to the Geeklog CMS', NULL, '[[regtime]]', '[[regtime]]', 2, 21, 3, 3, 2, 2),
('site', 'root', 'Root', 'Website root', '', '[[regtime]]', '[[regtime]]', 2, 21, 3, 3, 2, 2);

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

--
-- Table structure for table `[[dbprefix]]links`
--

CREATE TABLE `[[dbprefix]]links` (
  `lid` varchar(40) NOT NULL DEFAULT '',
  `cid` varchar(32) DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `description` text,
  `title` varchar(96) DEFAULT NULL,
  `hits` int(11) NOT NULL DEFAULT '0',
  `date` datetime DEFAULT NULL,
  `owner_id` mediumint(8) unsigned NOT NULL DEFAULT '1',
  `group_id` mediumint(8) unsigned NOT NULL DEFAULT '1',
  `perm_owner` tinyint(1) unsigned NOT NULL DEFAULT '3',
  `perm_group` tinyint(1) unsigned NOT NULL DEFAULT '2',
  `perm_members` tinyint(1) unsigned NOT NULL DEFAULT '2',
  `perm_anon` tinyint(1) unsigned NOT NULL DEFAULT '2',
  PRIMARY KEY (`lid`),
  KEY `links_category` (`cid`),
  KEY `links_date` (`date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `[[dbprefix]]links`
--

INSERT INTO `[[dbprefix]]links` VALUES
('geeklog.net', 'geeklog-sites', 'https://www.geeklog.net/', 'Visit the Geeklog homepage for support, FAQs, updates, add-ons, and a great community.', 'Geeklog Project Homepage', 123, '[[regtime]]', 1, 21, 3, 3, 2, 2);

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

--
-- Table structure for table `[[dbprefix]]linksubmission`
--

CREATE TABLE `[[dbprefix]]linksubmission` (
  `lid` varchar(40) NOT NULL DEFAULT '',
  `cid` varchar(32) DEFAULT NULL,
  `url` varchar(255) DEFAULT NULL,
  `description` text,
  `title` varchar(96) DEFAULT NULL,
  `hits` int(11) DEFAULT NULL,
  `date` datetime DEFAULT NULL,
  `owner_id` mediumint(8) unsigned NOT NULL DEFAULT '1',
  PRIMARY KEY (`lid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

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

--
-- Table structure for table `[[dbprefix]]personal_events`
--

CREATE TABLE `[[dbprefix]]personal_events` (
  `eid` varchar(20) NOT NULL DEFAULT '',
  `title` varchar(128) DEFAULT NULL,
  `event_type` varchar(40) NOT NULL DEFAULT '',
  `datestart` date DEFAULT NULL,
  `dateend` date DEFAULT NULL,
  `address1` varchar(40) DEFAULT NULL,
  `address2` varchar(40) DEFAULT NULL,
  `city` varchar(60) DEFAULT NULL,
  `state` varchar(40) DEFAULT NULL,
  `zipcode` varchar(16) DEFAULT NULL,
  `allday` tinyint(1) NOT NULL DEFAULT '0',
  `url` varchar(255) DEFAULT NULL,
  `description` text,
  `postmode` varchar(10) NOT NULL DEFAULT 'plaintext',
  `owner_id` mediumint(8) unsigned NOT NULL DEFAULT '1',
  `group_id` mediumint(8) unsigned NOT NULL DEFAULT '1',
  `perm_owner` tinyint(1) unsigned NOT NULL DEFAULT '3',
  `perm_group` tinyint(1) unsigned NOT NULL DEFAULT '3',
  `perm_members` tinyint(1) unsigned NOT NULL DEFAULT '2',
  `perm_anon` tinyint(1) unsigned NOT NULL DEFAULT '2',
  `uid` mediumint(8) NOT NULL DEFAULT '0',
  `location` varchar(128) DEFAULT NULL,
  `timestart` time DEFAULT NULL,
  `timeend` time DEFAULT NULL,
  PRIMARY KEY (`eid`,`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

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

--
-- Table structure for table `[[dbprefix]]pingservice`
--

CREATE TABLE `[[dbprefix]]pingservice` (
  `pid` smallint(5) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(128) DEFAULT NULL,
  `ping_url` varchar(255) DEFAULT NULL,
  `site_url` varchar(255) DEFAULT NULL,
  `method` varchar(80) DEFAULT NULL,
  `is_enabled` tinyint(1) unsigned NOT NULL DEFAULT '1',
  PRIMARY KEY (`pid`),
  KEY `pingservice_is_enabled` (`is_enabled`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=2 ;

--
-- Dumping data for table `[[dbprefix]]pingservice`
--

INSERT INTO `[[dbprefix]]pingservice` VALUES
(1, 'Ping-O-Matic', 'http://rpc.pingomatic.com/', 'http://pingomatic.com/', 'weblogUpdates.ping', 1);

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

--
-- Table structure for table `[[dbprefix]]plugins`
--

CREATE TABLE `[[dbprefix]]plugins` (
  `pi_name` varchar(30) NOT NULL DEFAULT '',
  `pi_version` varchar(20) NOT NULL DEFAULT '',
  `pi_gl_version` varchar(20) NOT NULL DEFAULT '',
  `pi_enabled` tinyint(1) unsigned NOT NULL DEFAULT '1',
  `pi_homepage` varchar(128) NOT NULL DEFAULT '',
  `pi_load` smallint(5) unsigned NOT NULL DEFAULT '10000',
  PRIMARY KEY (`pi_name`),
  KEY `plugins_enabled` (`pi_enabled`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `[[dbprefix]]plugins`
--

INSERT INTO `[[dbprefix]]plugins` VALUES
('calendar', '1.1.9', '2.2.2', 1, 'https://www.geeklog.net/', 10000),
('links', '2.1.8', '2.2.2', 1, 'https://www.geeklog.net/', 10000),
('polls', '2.2.1', '2.2.2', 1, 'https://www.geeklog.net/', 10000),
('recaptcha', '1.2.4', '2.2.2', 1, 'https://github.com/Geeklog-Core/geeklog', 10000),
('spamx', '1.3.6', '2.2.0', 1, 'https://www.geeklog.net/', 10000),
('staticpages', '1.7.3', '2.2.2', 1, 'https://www.geeklog.net/', 10000),
('xmlsitemap', '2.0.3', '2.2.2', 1, 'https://github.com/Geeklog-Core/geeklog', 10000);

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

--
-- Table structure for table `[[dbprefix]]pollanswers`
--

CREATE TABLE `[[dbprefix]]pollanswers` (
  `pid` varchar(128) NOT NULL DEFAULT '',
  `qid` mediumint(9) NOT NULL DEFAULT '0',
  `aid` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `answer` varchar(255) DEFAULT NULL,
  `votes` mediumint(8) unsigned DEFAULT NULL,
  `remark` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`pid`,`qid`,`aid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `[[dbprefix]]pollanswers`
--

INSERT INTO `[[dbprefix]]pollanswers` VALUES
('geeklogfeaturepoll', 0, 1, 'Child Topics Support', 0, ''),
('geeklogfeaturepoll', 0, 2, 'Multiple Topics for Articles and Blocks', 0, ''),
('geeklogfeaturepoll', 0, 3, 'Updated Password Security', 0, ''),
('geeklogfeaturepoll', 0, 4, 'New Theme', 0, ''),
('geeklogfeaturepoll', 0, 5, 'Other', 0, ''),
('geeklogfeaturepoll', 1, 1, 'Permissions Handling', 0, ''),
('geeklogfeaturepoll', 1, 2, 'Spam Protection', 0, ''),
('geeklogfeaturepoll', 1, 3, 'Focus on Security', 0, ''),
('geeklogfeaturepoll', 1, 4, 'Plugin Availability', 0, ''),
('geeklogfeaturepoll', 1, 5, 'The Community', 0, '');

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

--
-- Table structure for table `[[dbprefix]]pollquestions`
--

CREATE TABLE `[[dbprefix]]pollquestions` (
  `qid` mediumint(9) NOT NULL DEFAULT '0',
  `pid` varchar(128) NOT NULL DEFAULT '',
  `question` varchar(255) NOT NULL,
  `allow_multipleanswers` tinyint(1) DEFAULT NULL,
  `description` mediumtext,
  PRIMARY KEY (`qid`,`pid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `[[dbprefix]]pollquestions`
--

INSERT INTO `[[dbprefix]]pollquestions` VALUES
(0, 'geeklogfeaturepoll', 'What is the best new feature of Geeklog?', NULL, NULL),
(1, 'geeklogfeaturepoll', 'What is the all-time best feature of Geeklog?', NULL, NULL);

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

--
-- Table structure for table `[[dbprefix]]polltopics`
--

CREATE TABLE `[[dbprefix]]polltopics` (
  `pid` varchar(128) NOT NULL DEFAULT '',
  `topic` varchar(255) DEFAULT NULL,
  `meta_description` text,
  `meta_keywords` text,
  `voters` mediumint(8) unsigned DEFAULT NULL,
  `questions` int(11) NOT NULL DEFAULT '0',
  `created` datetime DEFAULT NULL,
  `modified` datetime DEFAULT NULL,
  `display` tinyint(4) NOT NULL DEFAULT '0',
  `is_open` tinyint(1) NOT NULL DEFAULT '1',
  `hideresults` tinyint(1) NOT NULL DEFAULT '0',
  `commentcode` tinyint(4) NOT NULL DEFAULT '0',
  `statuscode` tinyint(4) NOT NULL DEFAULT '0',
  `owner_id` mediumint(8) unsigned NOT NULL DEFAULT '1',
  `group_id` mediumint(8) unsigned NOT NULL DEFAULT '1',
  `perm_owner` tinyint(1) unsigned NOT NULL DEFAULT '3',
  `perm_group` tinyint(1) unsigned NOT NULL DEFAULT '2',
  `perm_members` tinyint(1) unsigned NOT NULL DEFAULT '2',
  `perm_anon` tinyint(1) unsigned NOT NULL DEFAULT '2',
  `description` mediumtext,
  PRIMARY KEY (`pid`),
  KEY `pollquestions_qid` (`pid`),
  KEY `pollquestions_created` (`created`),
  KEY `pollquestions_display` (`display`),
  KEY `pollquestions_commentcode` (`commentcode`),
  KEY `pollquestions_statuscode` (`statuscode`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `[[dbprefix]]polltopics`
--

INSERT INTO `[[dbprefix]]polltopics` VALUES
('geeklogfeaturepoll', 'Tell us your opinion about Geeklog', 'A poll about users opinions of Geeklog.', 'Poll, Geeklog, Opinion', 0, 2, '[[regtime]]', '[[regtime]]', 1, 1, 1, 0, 0, 1, 22, 3, 2, 2, 2, NULL);

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

--
-- Table structure for table `[[dbprefix]]pollvoters`
--

CREATE TABLE `[[dbprefix]]pollvoters` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `pid` varchar(128) NOT NULL,
  `seq` int(11) NOT NULL DEFAULT '0',
  `date` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `[[dbprefix]]routes`
--

CREATE TABLE `[[dbprefix]]routes` (
  `rid` int(11) NOT NULL AUTO_INCREMENT,
  `method` int(11) NOT NULL DEFAULT '1',
  `rule` varchar(255) NOT NULL DEFAULT '',
  `route` varchar(255) NOT NULL DEFAULT '',
  `status_code` int(11) NOT NULL DEFAULT '200',
  `priority` int(11) NOT NULL DEFAULT '100',
  `enabled` tinyint(1) unsigned NOT NULL DEFAULT '1',
  PRIMARY KEY (`rid`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=11 ;

--
-- Dumping data for table `[[dbprefix]]routes`
--

INSERT INTO `[[dbprefix]]routes` VALUES
(1, 1, '/article/@sid', '/article.php?story=@sid', 200, 100, 1),
(2, 1, '/article/@sid/print', '/article.php?story=@sid&mode=print', 200, 110, 1),
(3, 1, '/article/@sid/@page', '/article.php?story=@sid&page=@page', 200, 120, 1),
(4, 1, '/topic/@topic', '/index.php?topic=@topic', 200, 130, 1),
(5, 1, '/topic/@topic/@page', '/index.php?topic=@topic&page=@page', 200, 140, 1),
(6, 1, '/archives/@topic/@year/@month', '/directory.php?topic=@topic&year=@year&month=@month', 200, 150, 1),
(7, 1, '/page/@page', '/staticpages/index.php?page=@page', 200, 160, 1),
(8, 1, '/page/@page/print', '/staticpages/index.php?page=@page&disp_mode=print', 200, 170, 1),
(9, 1, '/links/portal/@item', '/links/portal.php?what=link&item=@item', 200, 180, 1),
(10, 1, '/links/category/@cat', '/links/index.php?category=@cat', 200, 190, 1);

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

--
-- Table structure for table `[[dbprefix]]sessions`
--

CREATE TABLE `[[dbprefix]]sessions` (
  `sess_id` varchar(190) NOT NULL DEFAULT '',
  `start_time` int(10) unsigned NOT NULL DEFAULT '0',
  `seq` int(11) NOT NULL DEFAULT '0',
  `uid` mediumint(8) NOT NULL DEFAULT '1',
  `whos_online` tinyint(1) NOT NULL DEFAULT '1',
  `autologin_key_hash` varchar(190) NOT NULL DEFAULT '',
  PRIMARY KEY (`sess_id`),
  KEY `start_time` (`start_time`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `[[dbprefix]]sessions`
--



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

--
-- Table structure for table `[[dbprefix]]spamx`
--

CREATE TABLE `[[dbprefix]]spamx` (
  `name` varchar(20) NOT NULL DEFAULT '',
  `value` varchar(191) NOT NULL DEFAULT '',
  `counter` int(11) NOT NULL DEFAULT '0',
  `regdate` datetime DEFAULT NULL,
  PRIMARY KEY (`name`,`value`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

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

--
-- Table structure for table `[[dbprefix]]speedlimit`
--

CREATE TABLE `[[dbprefix]]speedlimit` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `ipaddress` varchar(39) NOT NULL DEFAULT '',
  `date` int(10) unsigned DEFAULT NULL,
  `type` varchar(30) NOT NULL DEFAULT 'submit',
  PRIMARY KEY (`id`),
  KEY `type_ipaddress` (`type`,`ipaddress`),
  KEY `date` (`date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `[[dbprefix]]staticpage`
--

CREATE TABLE `[[dbprefix]]staticpage` (
  `sp_id` varchar(128) NOT NULL DEFAULT '',
  `sp_title` varchar(128) NOT NULL DEFAULT '',
  `sp_page_title` varchar(128) NOT NULL DEFAULT '',
  `sp_content` text NOT NULL,
  `page_data` text,
  `sp_hits` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `created` datetime DEFAULT NULL,
  `modified` datetime DEFAULT NULL,
  `sp_format` varchar(20) NOT NULL DEFAULT '',
  `sp_onmenu` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `sp_onhits` tinyint(1) unsigned NOT NULL DEFAULT '1',
  `sp_onlastupdate` tinyint(1) unsigned NOT NULL DEFAULT '1',
  `sp_label` varchar(64) DEFAULT NULL,
  `commentcode` tinyint(4) NOT NULL DEFAULT '0',
  `structured_data_type` varchar(40) NOT NULL DEFAULT '',
  `meta_description` text,
  `meta_keywords` text,
  `template_flag` tinyint(1) unsigned DEFAULT '0',
  `template_id` varchar(40) NOT NULL DEFAULT '',
  `cache_time` int(11) NOT NULL DEFAULT '0',
  `draft_flag` tinyint(1) unsigned DEFAULT '0',
  `search` tinyint(1) NOT NULL DEFAULT '1',
  `likes` tinyint(1) NOT NULL DEFAULT '-1',
  `owner_id` mediumint(8) unsigned NOT NULL DEFAULT '1',
  `group_id` mediumint(8) unsigned NOT NULL DEFAULT '1',
  `perm_owner` tinyint(1) unsigned NOT NULL DEFAULT '3',
  `perm_group` tinyint(1) unsigned NOT NULL DEFAULT '2',
  `perm_members` tinyint(1) unsigned NOT NULL DEFAULT '2',
  `perm_anon` tinyint(1) unsigned NOT NULL DEFAULT '2',
  `sp_centerblock` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `sp_help` varchar(255) DEFAULT '',
  `sp_where` tinyint(1) unsigned NOT NULL DEFAULT '1',
  `sp_php` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `sp_nf` tinyint(1) unsigned DEFAULT '0',
  `sp_inblock` tinyint(1) unsigned DEFAULT '1',
  `postmode` varchar(16) NOT NULL DEFAULT 'html',
  `sp_prev` varchar(128) NOT NULL DEFAULT '',
  `sp_next` varchar(128) NOT NULL DEFAULT '',
  `sp_parent` varchar(128) NOT NULL DEFAULT '',
  PRIMARY KEY (`sp_id`),
  KEY `staticpage_created` (`created`),
  KEY `staticpage_sp_onmenu` (`sp_onmenu`),
  KEY `staticpage_sp_centerblock` (`sp_centerblock`),
  KEY `staticpage_sp_where` (`sp_where`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

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

--
-- Table structure for table `[[dbprefix]]stories`
--

CREATE TABLE `[[dbprefix]]stories` (
  `sid` varchar(128) NOT NULL DEFAULT '',
  `uid` mediumint(8) NOT NULL DEFAULT '1',
  `draft_flag` tinyint(1) unsigned DEFAULT '0',
  `date` datetime DEFAULT NULL,
  `modified` datetime DEFAULT NULL,
  `title` varchar(128) DEFAULT NULL,
  `page_title` varchar(128) DEFAULT NULL,
  `introtext` text,
  `bodytext` text,
  `text_version` tinyint(2) NOT NULL DEFAULT '1',
  `hits` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `numpages` tinyint(1) NOT NULL DEFAULT '1',
  `numemails` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `comments` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `comment_expire` datetime DEFAULT NULL,
  `trackbacks` mediumint(8) unsigned NOT NULL DEFAULT '0',
  `related` text,
  `featured` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `show_topic_icon` tinyint(1) unsigned NOT NULL DEFAULT '1',
  `commentcode` tinyint(4) NOT NULL DEFAULT '0',
  `structured_data_type` varchar(40) NOT NULL DEFAULT '',
  `trackbackcode` tinyint(4) NOT NULL DEFAULT '0',
  `statuscode` tinyint(4) NOT NULL DEFAULT '0',
  `expire` datetime DEFAULT NULL,
  `postmode` varchar(10) NOT NULL DEFAULT 'html',
  `advanced_editor_mode` tinyint(1) unsigned DEFAULT '0',
  `frontpage` tinyint(1) unsigned DEFAULT '1',
  `meta_description` text,
  `meta_keywords` text,
  `cache_time` int(11) NOT NULL DEFAULT '0',
  `owner_id` mediumint(8) NOT NULL DEFAULT '1',
  `group_id` mediumint(8) NOT NULL DEFAULT '2',
  `perm_owner` tinyint(1) unsigned NOT NULL DEFAULT '3',
  `perm_group` tinyint(1) unsigned NOT NULL DEFAULT '3',
  `perm_members` tinyint(1) unsigned NOT NULL DEFAULT '2',
  `perm_anon` tinyint(1) unsigned NOT NULL DEFAULT '2',
  PRIMARY KEY (`sid`),
  KEY `stories_sid` (`sid`),
  KEY `stories_uid` (`uid`),
  KEY `stories_featured` (`featured`),
  KEY `stories_hits` (`hits`),
  KEY `stories_statuscode` (`statuscode`),
  KEY `stories_expire` (`expire`),
  KEY `stories_date` (`date`),
  KEY `stories_frontpage` (`frontpage`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `[[dbprefix]]stories`
--

INSERT INTO `[[dbprefix]]stories` VALUES
('welcome', 2, 0, '[[regtime]]', NULL, 'Welcome to Geeklog!', NULL, '<p>Welcome and let me be the first to congratulate you on installing Geeklog. Please take the time to read everything in the <a href="docs/english/index.html">docs directory</a>. Geeklog now has enhanced, user-based security.  You should thoroughly understand how these work before you run a production Geeklog Site.</p>\r<p>To log into your new Geeklog site, please use this account:</p>\r<p>Username: <b>Admin</b><br />\rPassword: <b>password</b></p><p><b>And don''t forget to <a href="usersettings.php">change your password</a> after logging in!</b></p>', '', 1, 100, 1, 1, 0, NULL, 0, '', 1, 1, 0, 'core-article', 0, 0, NULL, 'html', 0, 1, NULL, NULL, 0, 2, 3, 3, 2, 2, 2);

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

--
-- Table structure for table `[[dbprefix]]storysubmission`
--

CREATE TABLE `[[dbprefix]]storysubmission` (
  `sid` varchar(20) NOT NULL DEFAULT '',
  `uid` mediumint(8) NOT NULL DEFAULT '1',
  `title` varchar(128) DEFAULT NULL,
  `introtext` text,
  `bodytext` text,
  `text_version` tinyint(2) NOT NULL DEFAULT '1',
  `date` datetime DEFAULT NULL,
  `postmode` varchar(10) NOT NULL DEFAULT 'html',
  `meta_description` text,
  `meta_keywords` text,
  PRIMARY KEY (`sid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `[[dbprefix]]storysubmission`
--

INSERT INTO `[[dbprefix]]storysubmission` VALUES
('security-reminder', 2, 'Are you secure?', '<p>This is a reminder to secure your site once you have Geeklog up and running. What you should do:</p>\r\r<ol>\r<li>Change the default password for the Admin account.</li>\r<li>Remove the install directory (you won''t need it any more).</li>\r</ol>', NULL, 1, '[[regtime]]', 'html', NULL, NULL);

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

--
-- Table structure for table `[[dbprefix]]syndication`
--

CREATE TABLE `[[dbprefix]]syndication` (
  `fid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `type` varchar(30) NOT NULL DEFAULT 'article',
  `topic` varchar(75) NOT NULL DEFAULT '::all',
  `header_tid` varchar(75) NOT NULL DEFAULT 'none',
  `format` varchar(20) NOT NULL DEFAULT 'RSS-2.0',
  `limits` varchar(5) NOT NULL DEFAULT '10',
  `content_length` smallint(5) unsigned NOT NULL DEFAULT '0',
  `title` varchar(40) NOT NULL DEFAULT '',
  `description` text,
  `feedlogo` varchar(255) DEFAULT NULL,
  `filename` varchar(40) NOT NULL DEFAULT 'geeklog.rss',
  `charset` varchar(20) NOT NULL DEFAULT 'UTF-8',
  `language` varchar(20) NOT NULL DEFAULT 'en-gb',
  `is_enabled` tinyint(1) unsigned NOT NULL DEFAULT '1',
  `updated` datetime DEFAULT NULL,
  `update_info` text,
  PRIMARY KEY (`fid`),
  KEY `syndication_type` (`type`),
  KEY `syndication_topic` (`topic`),
  KEY `syndication_is_enabled` (`is_enabled`),
  KEY `syndication_updated` (`updated`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=2 ;

--
-- Dumping data for table `[[dbprefix]]syndication`
--

INSERT INTO `[[dbprefix]]syndication` VALUES
(1, 'article', '::all', 'all', 'RSS-2.0', '10', 1, 'Geeklog Site', 'Another Nifty Geeklog Site', NULL, 'geeklog.rss', 'iso-8859-1', 'en-gb', 1, '[[regtime]]', 'welcome');

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

--
-- Table structure for table `[[dbprefix]]tokens`
--

CREATE TABLE `[[dbprefix]]tokens` (
  `token` varchar(32) NOT NULL,
  `created` datetime NOT NULL,
  `owner_id` mediumint(8) unsigned NOT NULL,
  `urlfor` varchar(255) NOT NULL,
  `ttl` mediumint(8) unsigned NOT NULL DEFAULT '1',
  PRIMARY KEY (`token`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

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

--
-- Table structure for table `[[dbprefix]]topics`
--

CREATE TABLE `[[dbprefix]]topics` (
  `tid` varchar(75) NOT NULL DEFAULT '',
  `topic` varchar(75) DEFAULT NULL,
  `title` varchar(128) DEFAULT NULL,
  `imageurl` varchar(255) DEFAULT NULL,
  `meta_description` text,
  `meta_keywords` text,
  `sortnum` smallint(3) DEFAULT NULL,
  `limitnews` tinyint(3) DEFAULT NULL,
  `is_default` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `archive_flag` tinyint(1) unsigned NOT NULL DEFAULT '0',
  `parent_id` varchar(128) NOT NULL DEFAULT 'root',
  `inherit` tinyint(1) NOT NULL DEFAULT '1',
  `hidden` tinyint(1) NOT NULL DEFAULT '0',
  `owner_id` mediumint(8) unsigned NOT NULL DEFAULT '1',
  `group_id` mediumint(8) unsigned NOT NULL DEFAULT '1',
  `perm_owner` tinyint(1) unsigned NOT NULL DEFAULT '3',
  `perm_group` tinyint(1) unsigned NOT NULL DEFAULT '3',
  `perm_members` tinyint(1) unsigned NOT NULL DEFAULT '2',
  `perm_anon` tinyint(1) unsigned NOT NULL DEFAULT '2',
  PRIMARY KEY (`tid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `[[dbprefix]]topics`
--

INSERT INTO `[[dbprefix]]topics` VALUES
('Geeklog', 'Geeklog', NULL, '/images/topics/topic_gl.png', 'A topic that contains posts about Geeklog.', 'Geeklog, Posts, Information', 2, 10, 0, 0, 'root', 1, 0, 2, 6, 3, 2, 2, 2),
('General', 'General News', NULL, '/images/topics/topic_news.png', 'A topic that contains general news related posts.', 'News, Post, Information', 1, 10, 0, 0, 'root', 1, 0, 2, 6, 3, 2, 2, 2);

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

--
-- Table structure for table `[[dbprefix]]topic_assignments`
--

CREATE TABLE `[[dbprefix]]topic_assignments` (
  `tid` varchar(75) NOT NULL,
  `type` varchar(30) NOT NULL,
  `subtype` varchar(15) NOT NULL DEFAULT '',
  `id` varchar(128) NOT NULL,
  `inherit` tinyint(1) NOT NULL DEFAULT '1',
  `tdefault` tinyint(1) NOT NULL DEFAULT '0',
  PRIMARY KEY (`tid`,`type`,`subtype`,`id`),
  KEY `tid` (`tid`,`type`,`id`),
  KEY `type` (`type`,`subtype`,`id`),
  KEY `type_2` (`type`,`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `[[dbprefix]]topic_assignments`
--

INSERT INTO `[[dbprefix]]topic_assignments` VALUES
('all', 'block', '', '1', 1, 0),
('all', 'block', '', '2', 1, 0),
('all', 'block', '', '3', 1, 0),
('all', 'block', '', '4', 1, 0),
('all', 'block', '', '6', 1, 0),
('all', 'block', '', '7', 1, 0),
('Geeklog', 'article', '', 'security-reminder', 1, 1),
('Geeklog', 'article', '', 'welcome', 1, 1),
('homeonly', 'block', '', '5', 1, 0);

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

--
-- Table structure for table `[[dbprefix]]trackback`
--

CREATE TABLE `[[dbprefix]]trackback` (
  `cid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `sid` varchar(128) NOT NULL,
  `url` varchar(250) DEFAULT NULL,
  `title` varchar(128) DEFAULT NULL,
  `blog` varchar(80) DEFAULT NULL,
  `excerpt` text,
  `date` datetime DEFAULT NULL,
  `type` varchar(30) NOT NULL DEFAULT 'article',
  `seq` int(11) NOT NULL DEFAULT '0',
  PRIMARY KEY (`cid`),
  KEY `trackback_sid` (`sid`),
  KEY `trackback_url` (`url`(191)),
  KEY `trackback_type` (`type`),
  KEY `trackback_date` (`date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC AUTO_INCREMENT=1 ;

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

--
-- Table structure for table `[[dbprefix]]userautologin`
--

CREATE TABLE `[[dbprefix]]userautologin` (
  `autologin_key_hash` varchar(190) NOT NULL DEFAULT '',
  `expiry_time` int(10) unsigned NOT NULL DEFAULT '0',
  `uid` mediumint(8) NOT NULL,
  PRIMARY KEY (`autologin_key_hash`),
  KEY `expiry_time` (`expiry_time`),
  KEY `uid` (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

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

--
-- Table structure for table `[[dbprefix]]user_attributes`
--

CREATE TABLE `[[dbprefix]]user_attributes` (
  `uid` mediumint(8) NOT NULL DEFAULT '1',
  `commentmode` varchar(10) NOT NULL DEFAULT 'nested',
  `commentorder` varchar(4) NOT NULL DEFAULT 'ASC',
  `commentlimit` mediumint(8) unsigned NOT NULL DEFAULT '100',
  `etids` text NOT NULL,
  `noboxes` tinyint(4) NOT NULL DEFAULT '0',
  `maxstories` tinyint(4) NOT NULL DEFAULT '0',
  `about` text NOT NULL,
  `location` varchar(96) NOT NULL DEFAULT '',
  `pgpkey` text NOT NULL,
  `tokens` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `lastgranted` int(10) unsigned NOT NULL DEFAULT '0',
  `lastlogin` varchar(10) NOT NULL DEFAULT '0',
  `dfid` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `advanced_editor` tinyint(1) unsigned NOT NULL DEFAULT '1',
  `tzid` varchar(125) NOT NULL DEFAULT '',
  `emailfromadmin` tinyint(1) NOT NULL DEFAULT '1',
  `emailfromuser` tinyint(1) NOT NULL DEFAULT '1',
  `showonline` tinyint(1) NOT NULL DEFAULT '1',
  PRIMARY KEY (`uid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `[[dbprefix]]user_attributes`
--

INSERT INTO `[[dbprefix]]user_attributes` VALUES
(1, 'nested', 'ASC', 100, '', 0, 0, '', '', '', 0, 0, '[[timestamp]]', 0, 0, '', 0, 0, 1),
(2, 'nested', 'ASC', 100, '', 0, 0, '', '', '', 0, 0, '0', 0, 1, '', 1, 1, 1);

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

--
-- Table structure for table `[[dbprefix]]vars`
--

CREATE TABLE `[[dbprefix]]vars` (
  `name` varchar(20) NOT NULL DEFAULT '',
  `value` text,
  PRIMARY KEY (`name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 ROW_FORMAT=DYNAMIC;

--
-- Dumping data for table `[[dbprefix]]vars`
--

INSERT INTO `[[dbprefix]]vars` VALUES
('database_engine', 'InnoDB'),
('database_version', '2.2.2'),
('lastemailedstories', ''),
('last_article_publish', '[[regtime]]'),
('last_scheduled_run', ''),
('spamx.counter', '0'),
('totalhits', '1'),
('xmlsitemap.pings', '{"google":[[timestamp]]}'),
('xmlsitemap_filename', 'sitemap.xml'),
('xmlsitemap_mobile', 'mobile_sitemap.xml'),
('xmlsitemap_news', 'news_sitemap.xml');

