-- Table structure for table `l0eco_fields`
--

CREATE TABLE `l0eco_fields` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `asset_id` int(10) unsigned NOT NULL DEFAULT 0,
  `context` varchar(255) NOT NULL DEFAULT '',
  `group_id` int(10) unsigned NOT NULL DEFAULT 0,
  `title` varchar(255) NOT NULL DEFAULT '',
  `name` varchar(255) NOT NULL DEFAULT '',
  `label` varchar(255) NOT NULL DEFAULT '',
  `default_value` text DEFAULT NULL,
  `type` varchar(255) NOT NULL DEFAULT 'text',
  `note` varchar(255) NOT NULL DEFAULT '',
  `description` text NOT NULL,
  `state` tinyint(4) NOT NULL DEFAULT 0,
  `required` tinyint(4) NOT NULL DEFAULT 0,
  `only_use_in_subform` tinyint(4) NOT NULL DEFAULT 0,
  `checked_out` int(10) unsigned DEFAULT NULL,
  `checked_out_time` datetime DEFAULT NULL,
  `ordering` int(11) NOT NULL DEFAULT 0,
  `params` text NOT NULL,
  `fieldparams` text NOT NULL,
  `language` char(7) NOT NULL DEFAULT '',
  `created_time` datetime NOT NULL,
  `created_user_id` int(10) unsigned NOT NULL DEFAULT 0,
  `modified_time` datetime NOT NULL,
  `modified_by` int(10) unsigned NOT NULL DEFAULT 0,
  `access` int(11) NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`),
  KEY `idx_checkout` (`checked_out`),
  KEY `idx_state` (`state`),
  KEY `idx_created_user_id` (`created_user_id`),
  KEY `idx_access` (`access`),
  KEY `idx_context` (`context`(191)),
  KEY `idx_language` (`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `l0eco_fields`
--


--
-- Table structure for table `l0eco_fields_categories`
--

CREATE TABLE `l0eco_fields_categories` (
  `field_id` int(11) NOT NULL DEFAULT 0,
  `category_id` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`field_id`,`category_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `l0eco_fields_categories`
--


--
-- Table structure for table `l0eco_fields_groups`
--

CREATE TABLE `l0eco_fields_groups` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `asset_id` int(10) unsigned NOT NULL DEFAULT 0,
  `context` varchar(255) NOT NULL DEFAULT '',
  `title` varchar(255) NOT NULL DEFAULT '',
  `note` varchar(255) NOT NULL DEFAULT '',
  `description` text NOT NULL,
  `state` tinyint(4) NOT NULL DEFAULT 0,
  `checked_out` int(10) unsigned DEFAULT NULL,
  `checked_out_time` datetime DEFAULT NULL,
  `ordering` int(11) NOT NULL DEFAULT 0,
  `params` text NOT NULL,
  `language` char(7) NOT NULL DEFAULT '',
  `created` datetime NOT NULL,
  `created_by` int(10) unsigned NOT NULL DEFAULT 0,
  `modified` datetime NOT NULL,
  `modified_by` int(10) unsigned NOT NULL DEFAULT 0,
  `access` int(11) NOT NULL DEFAULT 1,
  PRIMARY KEY (`id`),
  KEY `idx_checkout` (`checked_out`),
  KEY `idx_state` (`state`),
  KEY `idx_created_by` (`created_by`),
  KEY `idx_access` (`access`),
  KEY `idx_context` (`context`(191)),
  KEY `idx_language` (`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `l0eco_fields_groups`
--


--
-- Table structure for table `l0eco_fields_values`
--

CREATE TABLE `l0eco_fields_values` (
  `field_id` int(10) unsigned NOT NULL,
  `item_id` varchar(255) NOT NULL COMMENT 'Allow references to items which have strings as ids, eg. none db systems.',
  `value` text DEFAULT NULL,
  KEY `idx_field_id` (`field_id`),
  KEY `idx_item_id` (`item_id`(191))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `l0eco_fields_values`
--


--
-- Table structure for table `l0eco_finder_filters`
--

CREATE TABLE `l0eco_finder_filters` (
  `filter_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(255) NOT NULL,
  `alias` varchar(255) NOT NULL,
  `state` tinyint(4) NOT NULL DEFAULT 1,
  `created` datetime NOT NULL,
  `created_by` int(10) unsigned NOT NULL DEFAULT 0,
  `created_by_alias` varchar(255) NOT NULL DEFAULT '',
  `modified` datetime NOT NULL,
  `modified_by` int(10) unsigned NOT NULL DEFAULT 0,
  `checked_out` int(10) unsigned DEFAULT NULL,
  `checked_out_time` datetime DEFAULT NULL,
  `map_count` int(10) unsigned NOT NULL DEFAULT 0,
  `data` text DEFAULT NULL,
  `params` mediumtext DEFAULT NULL,
  PRIMARY KEY (`filter_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `l0eco_finder_filters`
--


--
-- Table structure for table `l0eco_finder_links`
--

CREATE TABLE `l0eco_finder_links` (
  `link_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `url` varchar(255) NOT NULL,
  `route` varchar(400) NOT NULL,
  `title` varchar(400) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `indexdate` datetime NOT NULL,
  `md5sum` varchar(32) DEFAULT NULL,
  `published` tinyint(4) NOT NULL DEFAULT 1,
  `state` int(11) NOT NULL DEFAULT 1,
  `access` int(11) NOT NULL DEFAULT 0,
  `language` char(7) NOT NULL DEFAULT '',
  `publish_start_date` datetime DEFAULT NULL,
  `publish_end_date` datetime DEFAULT NULL,
  `start_date` datetime DEFAULT NULL,
  `end_date` datetime DEFAULT NULL,
  `list_price` double unsigned NOT NULL DEFAULT 0,
  `sale_price` double unsigned NOT NULL DEFAULT 0,
  `type_id` int(11) NOT NULL,
  `object` mediumblob DEFAULT NULL,
  PRIMARY KEY (`link_id`),
  KEY `idx_type` (`type_id`),
  KEY `idx_title` (`title`(100)),
  KEY `idx_md5` (`md5sum`),
  KEY `idx_url` (`url`(75)),
  KEY `idx_language` (`language`),
  KEY `idx_published_list` (`published`,`state`,`access`,`publish_start_date`,`publish_end_date`,`list_price`),
  KEY `idx_published_sale` (`published`,`state`,`access`,`publish_start_date`,`publish_end_date`,`sale_price`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `l0eco_finder_links`
--

INSERT INTO `l0eco_finder_links` VALUES (2,'index.php?option=com_content&view=article&id=2','index.php?option=com_content&view=article&id=2:goal-and-objective&catid=2','Στόχοι & Επιδιώξεις',' Το τμήμα αποσκοπεί: bla bla ','2023-01-28 10:52:10','2a9d3c3a00a762809bbe17f626c9b47b',1,1,1,'*','2023-01-28 10:52:10',NULL,'2023-01-28 10:52:10',NULL,0,0,3,'O:52:\"Joomla\\Component\\Finder\\Administrator\\Indexer\\Result\":19:{i:0;i:1;i:1;s:5:\"el-GR\";i:2;s:45:\" Το τμήμα αποσκοπεί: bla bla \";i:3;a:25:{s:2:\"id\";i:2;s:5:\"alias\";s:18:\"goal and objective\";s:7:\"summary\";s:58:\"<p>Το τμήμα αποσκοπεί:</p>\r\n<p>bla bla</p>\";s:4:\"body\";s:0:\"\";s:6:\"images\";s:173:\"{\"image_intro\":\"\",\"image_intro_alt\":\"\",\"float_intro\":\"\",\"image_intro_caption\":\"\",\"image_fulltext\":\"\",\"image_fulltext_alt\":\"\",\"float_fulltext\":\"\",\"image_fulltext_caption\":\"\"}\";s:5:\"catid\";i:2;s:10:\"created_by\";i:179;s:16:\"created_by_alias\";s:0:\"\";s:8:\"modified\";s:19:\"2023-01-28 10:52:10\";s:11:\"modified_by\";i:179;s:6:\"params\";O:24:\"Joomla\\Registry\\Registry\":3:{s:7:\"\0*\0data\";O:8:\"stdClass\":86:{s:14:\"article_layout\";s:9:\"_:default\";s:10:\"show_title\";s:1:\"1\";s:11:\"link_titles\";s:1:\"1\";s:10:\"show_intro\";s:1:\"1\";s:19:\"info_block_position\";s:1:\"0\";s:21:\"info_block_show_title\";s:1:\"1\";s:13:\"show_category\";s:1:\"1\";s:13:\"link_category\";s:1:\"1\";s:20:\"show_parent_category\";s:1:\"0\";s:20:\"link_parent_category\";s:1:\"0\";s:17:\"show_associations\";s:1:\"0\";s:5:\"flags\";s:1:\"1\";s:11:\"show_author\";s:1:\"1\";s:11:\"link_author\";s:1:\"0\";s:16:\"show_create_date\";s:1:\"0\";s:16:\"show_modify_date\";s:1:\"0\";s:17:\"show_publish_date\";s:1:\"1\";s:20:\"show_item_navigation\";s:1:\"1\";s:13:\"show_readmore\";s:1:\"1\";s:19:\"show_readmore_title\";s:1:\"1\";s:14:\"readmore_limit\";i:100;s:9:\"show_tags\";s:1:\"1\";s:11:\"record_hits\";s:1:\"1\";s:9:\"show_hits\";s:1:\"1\";s:11:\"show_noauth\";s:1:\"0\";s:13:\"urls_position\";i:0;s:7:\"captcha\";s:0:\"\";s:23:\"show_publishing_options\";s:1:\"1\";s:20:\"show_article_options\";s:1:\"1\";s:27:\"show_configure_edit_options\";s:1:\"1\";s:16:\"show_permissions\";s:1:\"1\";s:22:\"show_associations_edit\";s:1:\"1\";s:12:\"save_history\";s:1:\"1\";s:13:\"history_limit\";i:10;s:25:\"show_urls_images_frontend\";s:1:\"0\";s:24:\"show_urls_images_backend\";s:1:\"1\";s:7:\"targeta\";i:0;s:7:\"targetb\";i:0;s:7:\"targetc\";i:0;s:11:\"float_intro\";s:4:\"left\";s:14:\"float_fulltext\";s:4:\"left\";s:15:\"category_layout\";s:6:\"_:blog\";s:19:\"show_category_title\";s:1:\"0\";s:16:\"show_description\";s:1:\"0\";s:22:\"show_description_image\";s:1:\"0\";s:8:\"maxLevel\";s:1:\"1\";s:21:\"show_empty_categories\";s:1:\"0\";s:16:\"show_no_articles\";s:1:\"1\";s:32:\"show_category_heading_title_text\";s:1:\"1\";s:16:\"show_subcat_desc\";s:1:\"1\";s:21:\"show_cat_num_articles\";s:1:\"0\";s:13:\"show_cat_tags\";s:1:\"1\";s:21:\"show_base_description\";s:1:\"1\";s:11:\"maxLevelcat\";s:2:\"-1\";s:25:\"show_empty_categories_cat\";s:1:\"0\";s:20:\"show_subcat_desc_cat\";s:1:\"1\";s:25:\"show_cat_num_articles_cat\";s:1:\"1\";s:20:\"num_leading_articles\";i:1;s:18:\"blog_class_leading\";s:0:\"\";s:18:\"num_intro_articles\";i:4;s:10:\"blog_class\";s:0:\"\";s:11:\"num_columns\";i:1;s:18:\"multi_column_order\";s:1:\"0\";s:9:\"num_links\";i:4;s:24:\"show_subcategory_content\";s:1:\"0\";s:16:\"link_intro_image\";s:1:\"0\";s:21:\"show_pagination_limit\";s:1:\"1\";s:12:\"filter_field\";s:4:\"hide\";s:13:\"show_headings\";s:1:\"1\";s:14:\"list_show_date\";s:1:\"0\";s:11:\"date_format\";s:0:\"\";s:14:\"list_show_hits\";s:1:\"1\";s:16:\"list_show_author\";s:1:\"1\";s:11:\"display_num\";s:2:\"10\";s:11:\"orderby_pri\";s:5:\"order\";s:11:\"orderby_sec\";s:5:\"rdate\";s:10:\"order_date\";s:9:\"published\";s:15:\"show_pagination\";s:1:\"2\";s:23:\"show_pagination_results\";s:1:\"1\";s:13:\"show_featured\";s:4:\"show\";s:14:\"show_feed_link\";s:1:\"1\";s:12:\"feed_summary\";s:1:\"0\";s:18:\"feed_show_readmore\";s:1:\"0\";s:7:\"sef_ids\";i:1;s:20:\"custom_fields_enable\";s:1:\"1\";s:16:\"workflow_enabled\";s:1:\"0\";}s:14:\"\0*\0initialized\";b:1;s:9:\"separator\";s:1:\".\";}s:7:\"metakey\";s:0:\"\";s:8:\"metadesc\";s:0:\"\";s:8:\"metadata\";O:24:\"Joomla\\Registry\\Registry\":3:{s:7:\"\0*\0data\";O:8:\"stdClass\":3:{s:6:\"robots\";s:0:\"\";s:6:\"author\";s:0:\"\";s:6:\"rights\";s:0:\"\";}s:14:\"\0*\0initialized\";b:1;s:9:\"separator\";s:1:\".\";}s:7:\"version\";i:1;s:8:\"ordering\";i:0;s:8:\"category\";s:13:\"Uncategorised\";s:9:\"cat_state\";i:1;s:10:\"cat_access\";i:1;s:4:\"slug\";s:20:\"2:goal-and-objective\";s:7:\"catslug\";s:15:\"2:uncategorised\";s:6:\"author\";s:35:\"Λεωνίδας Φραγγίδης\";s:6:\"layout\";s:7:\"article\";s:7:\"context\";s:19:\"com_content.article\";s:10:\"metaauthor\";N;}i:4;N;i:5;a:5:{i:1;a:3:{i:0;s:5:\"title\";i:1;s:8:\"subtitle\";i:2;s:2:\"id\";}i:2;a:2:{i:0;s:7:\"summary\";i:1;s:4:\"body\";}i:3;a:8:{i:0;s:4:\"meta\";i:1;s:10:\"list_price\";i:2;s:10:\"sale_price\";i:3;s:7:\"metakey\";i:4;s:8:\"metadesc\";i:5;s:10:\"metaauthor\";i:6;s:6:\"author\";i:7;s:16:\"created_by_alias\";}i:4;a:2:{i:0;s:4:\"path\";i:1;s:5:\"alias\";}i:5;a:1:{i:0;s:8:\"comments\";}}i:6;s:1:\"*\";i:7;N;i:8;N;i:9;s:19:\"2023-01-28 10:52:10\";i:10;N;i:11;s:73:\"index.php?option=com_content&view=article&id=2:goal-and-objective&catid=2\";i:12;N;i:13;s:19:\"2023-01-28 10:52:10\";i:14;i:1;i:15;a:4:{s:4:\"Type\";a:1:{i:0;O:8:\"stdClass\":6:{s:5:\"title\";s:7:\"Article\";s:5:\"state\";i:1;s:6:\"access\";i:1;s:8:\"language\";s:0:\"\";s:6:\"nested\";b:0;s:2:\"id\";i:3;}}s:6:\"Author\";a:1:{i:0;O:8:\"stdClass\":6:{s:5:\"title\";s:35:\"Λεωνίδας Φραγγίδης\";s:5:\"state\";i:1;s:6:\"access\";i:1;s:8:\"language\";s:0:\"\";s:6:\"nested\";b:0;s:2:\"id\";i:5;}}s:8:\"Category\";a:1:{i:0;O:8:\"stdClass\":6:{s:5:\"title\";s:13:\"Uncategorised\";s:5:\"state\";i:1;s:6:\"access\";i:1;s:8:\"language\";s:1:\"*\";s:6:\"nested\";b:1;s:2:\"id\";i:7;}}s:8:\"Language\";a:1:{i:0;O:8:\"stdClass\":6:{s:5:\"title\";s:1:\"*\";s:5:\"state\";i:1;s:6:\"access\";i:1;s:8:\"language\";s:0:\"\";s:6:\"nested\";b:0;s:2:\"id\";i:9;}}}i:16;s:35:\"Στόχοι & Επιδιώξεις\";i:17;i:3;i:18;s:46:\"index.php?option=com_content&view=article&id=2\";}'),(3,'index.php?option=com_content&view=article&id=1','index.php?option=com_content&view=article&id=1:home&catid=2','Γνωριμία με το τμήμα',' bla bla ','2023-01-28 10:52:29','9a6193d452f09944ad59c27ee4307f1f',1,1,1,'*','2023-01-28 10:44:34',NULL,'2023-01-28 10:44:34',NULL,0,0,3,'O:52:\"Joomla\\Component\\Finder\\Administrator\\Indexer\\Result\":19:{i:0;i:1;i:1;s:5:\"el-GR\";i:2;s:9:\" bla bla \";i:3;a:25:{s:2:\"id\";i:1;s:5:\"alias\";s:4:\"home\";s:7:\"summary\";s:14:\"<p>bla bla</p>\";s:4:\"body\";s:0:\"\";s:6:\"images\";s:173:\"{\"image_intro\":\"\",\"image_intro_alt\":\"\",\"float_intro\":\"\",\"image_intro_caption\":\"\",\"image_fulltext\":\"\",\"image_fulltext_alt\":\"\",\"float_fulltext\":\"\",\"image_fulltext_caption\":\"\"}\";s:5:\"catid\";i:2;s:10:\"created_by\";i:179;s:16:\"created_by_alias\";s:0:\"\";s:8:\"modified\";s:19:\"2023-01-28 10:52:29\";s:11:\"modified_by\";i:179;s:6:\"params\";O:24:\"Joomla\\Registry\\Registry\":3:{s:7:\"\0*\0data\";O:8:\"stdClass\":86:{s:14:\"article_layout\";s:9:\"_:default\";s:10:\"show_title\";s:1:\"1\";s:11:\"link_titles\";s:1:\"1\";s:10:\"show_intro\";s:1:\"1\";s:19:\"info_block_position\";s:1:\"0\";s:21:\"info_block_show_title\";s:1:\"1\";s:13:\"show_category\";s:1:\"1\";s:13:\"link_category\";s:1:\"1\";s:20:\"show_parent_category\";s:1:\"0\";s:20:\"link_parent_category\";s:1:\"0\";s:17:\"show_associations\";s:1:\"0\";s:5:\"flags\";s:1:\"1\";s:11:\"show_author\";s:1:\"1\";s:11:\"link_author\";s:1:\"0\";s:16:\"show_create_date\";s:1:\"0\";s:16:\"show_modify_date\";s:1:\"0\";s:17:\"show_publish_date\";s:1:\"1\";s:20:\"show_item_navigation\";s:1:\"1\";s:13:\"show_readmore\";s:1:\"1\";s:19:\"show_readmore_title\";s:1:\"1\";s:14:\"readmore_limit\";i:100;s:9:\"show_tags\";s:1:\"1\";s:11:\"record_hits\";s:1:\"1\";s:9:\"show_hits\";s:1:\"1\";s:11:\"show_noauth\";s:1:\"0\";s:13:\"urls_position\";i:0;s:7:\"captcha\";s:0:\"\";s:23:\"show_publishing_options\";s:1:\"1\";s:20:\"show_article_options\";s:1:\"1\";s:27:\"show_configure_edit_options\";s:1:\"1\";s:16:\"show_permissions\";s:1:\"1\";s:22:\"show_associations_edit\";s:1:\"1\";s:12:\"save_history\";s:1:\"1\";s:13:\"history_limit\";i:10;s:25:\"show_urls_images_frontend\";s:1:\"0\";s:24:\"show_urls_images_backend\";s:1:\"1\";s:7:\"targeta\";i:0;s:7:\"targetb\";i:0;s:7:\"targetc\";i:0;s:11:\"float_intro\";s:4:\"left\";s:14:\"float_fulltext\";s:4:\"left\";s:15:\"category_layout\";s:6:\"_:blog\";s:19:\"show_category_title\";s:1:\"0\";s:16:\"show_description\";s:1:\"0\";s:22:\"show_description_image\";s:1:\"0\";s:8:\"maxLevel\";s:1:\"1\";s:21:\"show_empty_categories\";s:1:\"0\";s:16:\"show_no_articles\";s:1:\"1\";s:32:\"show_category_heading_title_text\";s:1:\"1\";s:16:\"show_subcat_desc\";s:1:\"1\";s:21:\"show_cat_num_articles\";s:1:\"0\";s:13:\"show_cat_tags\";s:1:\"1\";s:21:\"show_base_description\";s:1:\"1\";s:11:\"maxLevelcat\";s:2:\"-1\";s:25:\"show_empty_categories_cat\";s:1:\"0\";s:20:\"show_subcat_desc_cat\";s:1:\"1\";s:25:\"show_cat_num_articles_cat\";s:1:\"1\";s:20:\"num_leading_articles\";i:1;s:18:\"blog_class_leading\";s:0:\"\";s:18:\"num_intro_articles\";i:4;s:10:\"blog_class\";s:0:\"\";s:11:\"num_columns\";i:1;s:18:\"multi_column_order\";s:1:\"0\";s:9:\"num_links\";i:4;s:24:\"show_subcategory_content\";s:1:\"0\";s:16:\"link_intro_image\";s:1:\"0\";s:21:\"show_pagination_limit\";s:1:\"1\";s:12:\"filter_field\";s:4:\"hide\";s:13:\"show_headings\";s:1:\"1\";s:14:\"list_show_date\";s:1:\"0\";s:11:\"date_format\";s:0:\"\";s:14:\"list_show_hits\";s:1:\"1\";s:16:\"list_show_author\";s:1:\"1\";s:11:\"display_num\";s:2:\"10\";s:11:\"orderby_pri\";s:5:\"order\";s:11:\"orderby_sec\";s:5:\"rdate\";s:10:\"order_date\";s:9:\"published\";s:15:\"show_pagination\";s:1:\"2\";s:23:\"show_pagination_results\";s:1:\"1\";s:13:\"show_featured\";s:4:\"show\";s:14:\"show_feed_link\";s:1:\"1\";s:12:\"feed_summary\";s:1:\"0\";s:18:\"feed_show_readmore\";s:1:\"0\";s:7:\"sef_ids\";i:1;s:20:\"custom_fields_enable\";s:1:\"1\";s:16:\"workflow_enabled\";s:1:\"0\";}s:14:\"\0*\0initialized\";b:1;s:9:\"separator\";s:1:\".\";}s:7:\"metakey\";s:0:\"\";s:8:\"metadesc\";s:0:\"\";s:8:\"metadata\";O:24:\"Joomla\\Registry\\Registry\":3:{s:7:\"\0*\0data\";O:8:\"stdClass\":3:{s:6:\"robots\";s:0:\"\";s:6:\"author\";s:0:\"\";s:6:\"rights\";s:0:\"\";}s:14:\"\0*\0initialized\";b:1;s:9:\"separator\";s:1:\".\";}s:7:\"version\";i:2;s:8:\"ordering\";i:1;s:8:\"category\";s:13:\"Uncategorised\";s:9:\"cat_state\";i:1;s:10:\"cat_access\";i:1;s:4:\"slug\";s:6:\"1:home\";s:7:\"catslug\";s:15:\"2:uncategorised\";s:6:\"author\";s:35:\"Λεωνίδας Φραγγίδης\";s:6:\"layout\";s:7:\"article\";s:7:\"context\";s:19:\"com_content.article\";s:10:\"metaauthor\";N;}i:4;N;i:5;a:5:{i:1;a:3:{i:0;s:5:\"title\";i:1;s:8:\"subtitle\";i:2;s:2:\"id\";}i:2;a:2:{i:0;s:7:\"summary\";i:1;s:4:\"body\";}i:3;a:8:{i:0;s:4:\"meta\";i:1;s:10:\"list_price\";i:2;s:10:\"sale_price\";i:3;s:7:\"metakey\";i:4;s:8:\"metadesc\";i:5;s:10:\"metaauthor\";i:6;s:6:\"author\";i:7;s:16:\"created_by_alias\";}i:4;a:2:{i:0;s:4:\"path\";i:1;s:5:\"alias\";}i:5;a:1:{i:0;s:8:\"comments\";}}i:6;s:1:\"*\";i:7;N;i:8;N;i:9;s:19:\"2023-01-28 10:44:34\";i:10;N;i:11;s:59:\"index.php?option=com_content&view=article&id=1:home&catid=2\";i:12;N;i:13;s:19:\"2023-01-28 10:44:34\";i:14;i:1;i:15;a:4:{s:4:\"Type\";a:1:{i:0;O:8:\"stdClass\":6:{s:5:\"title\";s:7:\"Article\";s:5:\"state\";i:1;s:6:\"access\";i:1;s:8:\"language\";s:0:\"\";s:6:\"nested\";b:0;s:2:\"id\";i:3;}}s:6:\"Author\";a:1:{i:0;O:8:\"stdClass\":6:{s:5:\"title\";s:35:\"Λεωνίδας Φραγγίδης\";s:5:\"state\";i:1;s:6:\"access\";i:1;s:8:\"language\";s:0:\"\";s:6:\"nested\";b:0;s:2:\"id\";i:5;}}s:8:\"Category\";a:1:{i:0;O:8:\"stdClass\":6:{s:5:\"title\";s:13:\"Uncategorised\";s:5:\"state\";i:1;s:6:\"access\";i:1;s:8:\"language\";s:1:\"*\";s:6:\"nested\";b:1;s:2:\"id\";i:7;}}s:8:\"Language\";a:1:{i:0;O:8:\"stdClass\":6:{s:5:\"title\";s:1:\"*\";s:5:\"state\";i:1;s:6:\"access\";i:1;s:8:\"language\";s:0:\"\";s:6:\"nested\";b:0;s:2:\"id\";i:9;}}}i:16;s:37:\"Γνωριμία με το τμήμα\";i:17;i:3;i:18;s:46:\"index.php?option=com_content&view=article&id=1\";}');

--
-- Table structure for table `l0eco_finder_links_terms`
--

CREATE TABLE `l0eco_finder_links_terms` (
  `link_id` int(10) unsigned NOT NULL,
  `term_id` int(10) unsigned NOT NULL,
  `weight` float unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`link_id`,`term_id`),
  KEY `idx_term_weight` (`term_id`,`weight`),
  KEY `idx_link_term_weight` (`link_id`,`term_id`,`weight`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `l0eco_finder_links_terms`
--

INSERT INTO `l0eco_finder_links_terms` VALUES (2,4,0.63996),(3,4,0.63996),(2,6,0.23331),(3,6,0.56661),(2,7,0.09331),(3,7,0.22661),(2,8,0.72),(3,8,0.72),(2,16,0.17),(2,17,0.4),(2,18,0.28),(3,18,0.28),(2,19,0.5334),(2,20,1.2),(2,21,0.42),(2,22,1.13339),(2,23,0.68),(3,31,0.17),(3,32,0.5334),(3,33,0.90661),(3,34,0.22661);

--
-- Table structure for table `l0eco_finder_logging`
--

CREATE TABLE `l0eco_finder_logging` (
  `searchterm` varchar(255) NOT NULL DEFAULT '',
  `md5sum` varchar(32) NOT NULL DEFAULT '',
  `query` blob NOT NULL,
  `hits` int(11) NOT NULL DEFAULT 1,
  `results` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`md5sum`),
  KEY `searchterm` (`searchterm`(191))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `l0eco_finder_logging`
--


--
-- Table structure for table `l0eco_finder_taxonomy`
--

CREATE TABLE `l0eco_finder_taxonomy` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `parent_id` int(10) unsigned NOT NULL DEFAULT 0,
  `lft` int(11) NOT NULL DEFAULT 0,
  `rgt` int(11) NOT NULL DEFAULT 0,
  `level` int(10) unsigned NOT NULL DEFAULT 0,
  `path` varchar(400) NOT NULL DEFAULT '',
  `title` varchar(255) NOT NULL DEFAULT '',
  `alias` varchar(400) NOT NULL DEFAULT '',
  `state` tinyint(3) unsigned NOT NULL DEFAULT 1,
  `access` tinyint(3) unsigned NOT NULL DEFAULT 1,
  `language` char(7) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `idx_state` (`state`),
  KEY `idx_access` (`access`),
  KEY `idx_path` (`path`(100)),
  KEY `idx_level` (`level`),
  KEY `idx_left_right` (`lft`,`rgt`),
  KEY `idx_alias` (`alias`(100)),
  KEY `idx_language` (`language`),
  KEY `idx_parent_published` (`parent_id`,`state`,`access`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `l0eco_finder_taxonomy`
--

INSERT INTO `l0eco_finder_taxonomy` VALUES (1,0,0,17,0,'','ROOT','root',1,1,'*'),(2,1,1,4,1,'type','Type','type',1,1,''),(3,2,2,3,2,'type/article','Article','article',1,1,''),(4,1,5,8,1,'author','Author','author',1,1,''),(5,4,6,7,2,'author/leonidas-fraggidis','Λεωνίδας Φραγγίδης','leonidas-fraggidis',1,1,''),(6,1,9,12,1,'category','Category','category',1,1,''),(7,6,10,11,2,'category/uncategorised','Uncategorised','uncategorised',1,1,'*'),(8,1,13,16,1,'language','Language','language',1,1,''),(9,8,14,15,2,'language/779103c53079431d1af01ce15b36e61f','*','779103c53079431d1af01ce15b36e61f',1,1,'');

--
-- Table structure for table `l0eco_finder_taxonomy_map`
--

CREATE TABLE `l0eco_finder_taxonomy_map` (
  `link_id` int(10) unsigned NOT NULL,
  `node_id` int(10) unsigned NOT NULL,
  PRIMARY KEY (`link_id`,`node_id`),
  KEY `link_id` (`link_id`),
  KEY `node_id` (`node_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `l0eco_finder_taxonomy_map`
--

INSERT INTO `l0eco_finder_taxonomy_map` VALUES (2,3),(2,5),(2,7),(2,9),(3,3),(3,5),(3,7),(3,9);

--
-- Table structure for table `l0eco_finder_terms`
--

CREATE TABLE `l0eco_finder_terms` (
  `term_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `term` varchar(75) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `stem` varchar(75) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  `common` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `phrase` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `weight` float unsigned NOT NULL DEFAULT 0,
  `soundex` varchar(75) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  `links` int(11) NOT NULL DEFAULT 0,
  `language` char(7) NOT NULL DEFAULT '',
  PRIMARY KEY (`term_id`),
  UNIQUE KEY `idx_term_language` (`term`,`language`),
  KEY `idx_stem` (`stem`),
  KEY `idx_term_phrase` (`term`,`phrase`),
  KEY `idx_stem_phrase` (`stem`,`phrase`),
  KEY `idx_soundex_phrase` (`soundex`,`phrase`),
  KEY `idx_language` (`language`)
) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `l0eco_finder_terms`
--

INSERT INTO `l0eco_finder_terms` VALUES (4,'λεωνίδας','λεωνίδας',0,0,0.5333,'λ000',2,'*'),(6,'τμήμα','τμήμα',0,0,0.3333,'τ000',2,'*'),(7,'το','το',0,0,0.1333,'τ000',2,'*'),(8,'φραγγίδης','φραγγίδης',0,0,0.6,'φ000',2,'*'),(16,'2','2',0,0,0.1,'',1,'*'),(17,'and','and',0,0,0.2,'A530',1,'*'),(18,'bla','bla',0,0,0.2,'B400',2,'*'),(19,'goal','goal',0,0,0.2667,'G400',1,'*'),(20,'objective','objective',0,0,0.6,'O1231',1,'*'),(21,'αποσκοπεί','αποσκοπεί',0,0,0.6,'α000',1,'*'),(22,'επιδιώξεις','επιδιώξεις',0,0,0.6667,'ε000',1,'*'),(23,'στόχοι','στόχοι',0,0,0.4,'σ000',1,'*'),(31,'1','1',0,0,0.1,'',1,'*'),(32,'home','home',0,0,0.2667,'H500',1,'*'),(33,'γνωριμία','γνωριμία',0,0,0.5333,'γ000',1,'*'),(34,'με','με',0,0,0.1333,'μ000',1,'*');

--
-- Table structure for table `l0eco_finder_terms_common`
--

CREATE TABLE `l0eco_finder_terms_common` (
  `term` varchar(75) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  `language` char(7) NOT NULL DEFAULT '',
  `custom` int(11) NOT NULL DEFAULT 0,
  UNIQUE KEY `idx_term_language` (`term`,`language`),
  KEY `idx_lang` (`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `l0eco_finder_terms_common`
--

INSERT INTO `l0eco_finder_terms_common` VALUES ('a','en',0),('about','en',0),('above','en',0),('after','en',0),('again','en',0),('against','en',0),('all','en',0),('am','en',0),('an','en',0),('and','en',0),('any','en',0),('are','en',0),('aren\'t','en',0),('as','en',0),('at','en',0),('be','en',0),('because','en',0),('been','en',0),('before','en',0),('being','en',0),('below','en',0),('between','en',0),('both','en',0),('but','en',0),('by','en',0),('can\'t','en',0),('cannot','en',0),('could','en',0),('couldn\'t','en',0),('did','en',0),('didn\'t','en',0),('do','en',0),('does','en',0),('doesn\'t','en',0),('doing','en',0),('don\'t','en',0),('down','en',0),('during','en',0),('each','en',0),('few','en',0),('for','en',0),('from','en',0),('further','en',0),('had','en',0),('hadn\'t','en',0),('has','en',0),('hasn\'t','en',0),('have','en',0),('haven\'t','en',0),('having','en',0),('he','en',0),('he\'d','en',0),('he\'ll','en',0),('he\'s','en',0),('her','en',0),('here','en',0),('here\'s','en',0),('hers','en',0),('herself','en',0),('him','en',0),('himself','en',0),('his','en',0),('how','en',0),('how\'s','en',0),('i','en',0),('i\'d','en',0),('i\'ll','en',0),('i\'m','en',0),('i\'ve','en',0),('if','en',0),('in','en',0),('into','en',0),('is','en',0),('isn\'t','en',0),('it','en',0),('it\'s','en',0),('its','en',0),('itself','en',0),('let\'s','en',0),('me','en',0),('more','en',0),('most','en',0),('mustn\'t','en',0),('my','en',0),('myself','en',0),('no','en',0),('nor','en',0),('not','en',0),('of','en',0),('off','en',0),('on','en',0),('once','en',0),('only','en',0),('or','en',0),('other','en',0),('ought','en',0),('our','en',0),('ours','en',0),('ourselves','en',0),('out','en',0),('over','en',0),('own','en',0),('same','en',0),('shan\'t','en',0),('she','en',0),('she\'d','en',0),('she\'ll','en',0),('she\'s','en',0),('should','en',0),('shouldn\'t','en',0),('so','en',0),('some','en',0),('such','en',0),('than','en',0),('that','en',0),('that\'s','en',0),('the','en',0),('their','en',0),('theirs','en',0),('them','en',0),('themselves','en',0),('then','en',0),('there','en',0),('there\'s','en',0),('these','en',0),('they','en',0),('they\'d','en',0),('they\'ll','en',0),('they\'re','en',0),('they\'ve','en',0),('this','en',0),('those','en',0),('through','en',0),('to','en',0),('too','en',0),('under','en',0),('until','en',0),('up','en',0),('very','en',0),('was','en',0),('wasn\'t','en',0),('we','en',0),('we\'d','en',0),('we\'ll','en',0),('we\'re','en',0),('we\'ve','en',0),('were','en',0),('weren\'t','en',0),('what','en',0),('what\'s','en',0),('when','en',0),('when\'s','en',0),('where','en',0),('where\'s','en',0),('which','en',0),('while','en',0),('who','en',0),('who\'s','en',0),('whom','en',0),('why','en',0),('why\'s','en',0),('with','en',0),('won\'t','en',0),('would','en',0),('wouldn\'t','en',0),('you','en',0),('you\'d','en',0),('you\'ll','en',0),('you\'re','en',0),('you\'ve','en',0),('your','en',0),('yours','en',0),('yourself','en',0),('yourselves','en',0);

--
-- Table structure for table `l0eco_finder_tokens`
--

CREATE TABLE `l0eco_finder_tokens` (
  `term` varchar(75) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `stem` varchar(75) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  `common` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `phrase` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `weight` float unsigned NOT NULL DEFAULT 1,
  `context` tinyint(3) unsigned NOT NULL DEFAULT 2,
  `language` char(7) NOT NULL DEFAULT '',
  KEY `idx_word` (`term`),
  KEY `idx_stem` (`stem`),
  KEY `idx_context` (`context`),
  KEY `idx_language` (`language`)
) ENGINE=MEMORY DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `l0eco_finder_tokens`
--


--
-- Table structure for table `l0eco_finder_tokens_aggregate`
--

CREATE TABLE `l0eco_finder_tokens_aggregate` (
  `term_id` int(10) unsigned NOT NULL,
  `term` varchar(75) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `stem` varchar(75) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  `common` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `phrase` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `term_weight` float unsigned NOT NULL DEFAULT 0,
  `context` tinyint(3) unsigned NOT NULL DEFAULT 2,
  `context_weight` float unsigned NOT NULL DEFAULT 0,
  `total_weight` float unsigned NOT NULL DEFAULT 0,
  `language` char(7) NOT NULL DEFAULT '',
  KEY `token` (`term`),
  KEY `keyword_id` (`term_id`)
) ENGINE=MEMORY DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `l0eco_finder_tokens_aggregate`
--


--
-- Table structure for table `l0eco_finder_types`
--

CREATE TABLE `l0eco_finder_types` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `title` varchar(100) NOT NULL,
  `mime` varchar(100) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  UNIQUE KEY `title` (`title`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `l0eco_finder_types`
--

INSERT INTO `l0eco_finder_types` VALUES (1,'Category',''),(2,'Contact',''),(3,'Article',''),(4,'News Feed',''),(5,'Tag','');

--
-- Table structure for table `l0eco_history`
--

CREATE TABLE `l0eco_history` (
  `version_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `item_id` varchar(50) NOT NULL,
  `version_note` varchar(255) NOT NULL DEFAULT '' COMMENT 'Optional version name',
  `save_date` datetime NOT NULL,
  `editor_user_id` int(10) unsigned NOT NULL DEFAULT 0,
  `character_count` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Number of characters in this version.',
  `sha1_hash` varchar(50) NOT NULL DEFAULT '' COMMENT 'SHA1 hash of the version_data column.',
  `version_data` mediumtext NOT NULL COMMENT 'json-encoded string of version data',
  `keep_forever` tinyint(4) NOT NULL DEFAULT 0 COMMENT '0=auto delete; 1=keep',
  PRIMARY KEY (`version_id`),
  KEY `idx_ucm_item_id` (`item_id`),
  KEY `idx_save_date` (`save_date`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `l0eco_history`
--

INSERT INTO `l0eco_history` VALUES (1,'com_content.article.1','','2023-01-28 10:44:34',179,1667,'4c5d70652ed341704883d5a9735d02da96cb3f7e','{\"id\":1,\"asset_id\":92,\"title\":\"\\u0393\\u03bd\\u03c9\\u03c1\\u03b9\\u03bc\\u03af\\u03b1 \\u03bc\\u03b5 \\u03c4\\u03bf \\u03c4\\u03bc\\u03ae\\u03bc\\u03b1\",\"alias\":\"home\",\"introtext\":\"\",\"fulltext\":\"\",\"state\":\"1\",\"catid\":2,\"created\":\"2023-01-28 10:44:34\",\"created_by\":179,\"created_by_alias\":\"\",\"modified\":\"2023-01-28 10:44:34\",\"modified_by\":179,\"checked_out\":null,\"checked_out_time\":null,\"publish_up\":\"2023-01-28 10:44:34\",\"publish_down\":null,\"images\":\"{\\\"image_intro\\\":\\\"\\\",\\\"image_intro_alt\\\":\\\"\\\",\\\"float_intro\\\":\\\"\\\",\\\"image_intro_caption\\\":\\\"\\\",\\\"image_fulltext\\\":\\\"\\\",\\\"image_fulltext_alt\\\":\\\"\\\",\\\"float_fulltext\\\":\\\"\\\",\\\"image_fulltext_caption\\\":\\\"\\\"}\",\"urls\":\"{\\\"urla\\\":\\\"\\\",\\\"urlatext\\\":\\\"\\\",\\\"targeta\\\":\\\"\\\",\\\"urlb\\\":\\\"\\\",\\\"urlbtext\\\":\\\"\\\",\\\"targetb\\\":\\\"\\\",\\\"urlc\\\":\\\"\\\",\\\"urlctext\\\":\\\"\\\",\\\"targetc\\\":\\\"\\\"}\",\"attribs\":\"{\\\"article_layout\\\":\\\"\\\",\\\"show_title\\\":\\\"\\\",\\\"link_titles\\\":\\\"\\\",\\\"show_tags\\\":\\\"\\\",\\\"show_intro\\\":\\\"\\\",\\\"info_block_position\\\":\\\"\\\",\\\"info_block_show_title\\\":\\\"\\\",\\\"show_category\\\":\\\"\\\",\\\"link_category\\\":\\\"\\\",\\\"show_parent_category\\\":\\\"\\\",\\\"link_parent_category\\\":\\\"\\\",\\\"show_author\\\":\\\"\\\",\\\"link_author\\\":\\\"\\\",\\\"show_create_date\\\":\\\"\\\",\\\"show_modify_date\\\":\\\"\\\",\\\"show_publish_date\\\":\\\"\\\",\\\"show_item_navigation\\\":\\\"\\\",\\\"show_hits\\\":\\\"\\\",\\\"show_noauth\\\":\\\"\\\",\\\"urls_position\\\":\\\"\\\",\\\"alternative_readmore\\\":\\\"\\\",\\\"article_page_title\\\":\\\"\\\",\\\"show_publishing_options\\\":\\\"\\\",\\\"show_article_options\\\":\\\"\\\",\\\"show_urls_images_backend\\\":\\\"\\\",\\\"show_urls_images_frontend\\\":\\\"\\\"}\",\"version\":\"1\",\"ordering\":null,\"metakey\":\"\",\"metadesc\":\"\",\"access\":1,\"hits\":0,\"metadata\":\"{\\\"robots\\\":\\\"\\\",\\\"author\\\":\\\"\\\",\\\"rights\\\":\\\"\\\"}\",\"featured\":\"0\",\"language\":\"*\",\"note\":\"\"}',0),(2,'com_content.article.2','','2023-01-28 10:52:10',179,1801,'0baa2d14b7dc902eb347eee59e94e9658fe25f96','{\"id\":2,\"asset_id\":93,\"title\":\"\\u03a3\\u03c4\\u03cc\\u03c7\\u03bf\\u03b9 & \\u0395\\u03c0\\u03b9\\u03b4\\u03b9\\u03ce\\u03be\\u03b5\\u03b9\\u03c2\",\"alias\":\"goal-and-objective\",\"introtext\":\"<p>\\u03a4\\u03bf \\u03c4\\u03bc\\u03ae\\u03bc\\u03b1 \\u03b1\\u03c0\\u03bf\\u03c3\\u03ba\\u03bf\\u03c0\\u03b5\\u03af:<\\/p>\\r\\n<p>bla bla<\\/p>\",\"fulltext\":\"\",\"state\":\"1\",\"catid\":2,\"created\":\"2023-01-28 10:52:10\",\"created_by\":179,\"created_by_alias\":\"\",\"modified\":\"2023-01-28 10:52:10\",\"modified_by\":179,\"checked_out\":null,\"checked_out_time\":null,\"publish_up\":\"2023-01-28 10:52:10\",\"publish_down\":null,\"images\":\"{\\\"image_intro\\\":\\\"\\\",\\\"image_intro_alt\\\":\\\"\\\",\\\"float_intro\\\":\\\"\\\",\\\"image_intro_caption\\\":\\\"\\\",\\\"image_fulltext\\\":\\\"\\\",\\\"image_fulltext_alt\\\":\\\"\\\",\\\"float_fulltext\\\":\\\"\\\",\\\"image_fulltext_caption\\\":\\\"\\\"}\",\"urls\":\"{\\\"urla\\\":\\\"\\\",\\\"urlatext\\\":\\\"\\\",\\\"targeta\\\":\\\"\\\",\\\"urlb\\\":\\\"\\\",\\\"urlbtext\\\":\\\"\\\",\\\"targetb\\\":\\\"\\\",\\\"urlc\\\":\\\"\\\",\\\"urlctext\\\":\\\"\\\",\\\"targetc\\\":\\\"\\\"}\",\"attribs\":\"{\\\"article_layout\\\":\\\"\\\",\\\"show_title\\\":\\\"\\\",\\\"link_titles\\\":\\\"\\\",\\\"show_tags\\\":\\\"\\\",\\\"show_intro\\\":\\\"\\\",\\\"info_block_position\\\":\\\"\\\",\\\"info_block_show_title\\\":\\\"\\\",\\\"show_category\\\":\\\"\\\",\\\"link_category\\\":\\\"\\\",\\\"show_parent_category\\\":\\\"\\\",\\\"link_parent_category\\\":\\\"\\\",\\\"show_author\\\":\\\"\\\",\\\"link_author\\\":\\\"\\\",\\\"show_create_date\\\":\\\"\\\",\\\"show_modify_date\\\":\\\"\\\",\\\"show_publish_date\\\":\\\"\\\",\\\"show_item_navigation\\\":\\\"\\\",\\\"show_hits\\\":\\\"\\\",\\\"show_noauth\\\":\\\"\\\",\\\"urls_position\\\":\\\"\\\",\\\"alternative_readmore\\\":\\\"\\\",\\\"article_page_title\\\":\\\"\\\",\\\"show_publishing_options\\\":\\\"\\\",\\\"show_article_options\\\":\\\"\\\",\\\"show_urls_images_backend\\\":\\\"\\\",\\\"show_urls_images_frontend\\\":\\\"\\\"}\",\"version\":\"1\",\"ordering\":null,\"metakey\":\"\",\"metadesc\":\"\",\"access\":1,\"hits\":0,\"metadata\":\"{\\\"robots\\\":\\\"\\\",\\\"author\\\":\\\"\\\",\\\"rights\\\":\\\"\\\"}\",\"featured\":\"0\",\"language\":\"*\",\"note\":\"\"}',0),(3,'com_content.article.1','','2023-01-28 10:52:29',179,1697,'95b3ddb9b795ae345ef776f45969a5b00ce445a1','{\"id\":\"1\",\"asset_id\":92,\"title\":\"\\u0393\\u03bd\\u03c9\\u03c1\\u03b9\\u03bc\\u03af\\u03b1 \\u03bc\\u03b5 \\u03c4\\u03bf \\u03c4\\u03bc\\u03ae\\u03bc\\u03b1\",\"alias\":\"home\",\"introtext\":\"<p>bla bla<\\/p>\",\"fulltext\":\"\",\"state\":\"1\",\"catid\":2,\"created\":\"2023-01-28 10:44:34\",\"created_by\":\"179\",\"created_by_alias\":\"\",\"modified\":\"2023-01-28 10:52:29\",\"modified_by\":179,\"checked_out\":179,\"checked_out_time\":\"2023-01-28 10:52:21\",\"publish_up\":\"2023-01-28 10:44:34\",\"publish_down\":null,\"images\":\"{\\\"image_intro\\\":\\\"\\\",\\\"image_intro_alt\\\":\\\"\\\",\\\"float_intro\\\":\\\"\\\",\\\"image_intro_caption\\\":\\\"\\\",\\\"image_fulltext\\\":\\\"\\\",\\\"image_fulltext_alt\\\":\\\"\\\",\\\"float_fulltext\\\":\\\"\\\",\\\"image_fulltext_caption\\\":\\\"\\\"}\",\"urls\":\"{\\\"urla\\\":\\\"\\\",\\\"urlatext\\\":\\\"\\\",\\\"targeta\\\":\\\"\\\",\\\"urlb\\\":\\\"\\\",\\\"urlbtext\\\":\\\"\\\",\\\"targetb\\\":\\\"\\\",\\\"urlc\\\":\\\"\\\",\\\"urlctext\\\":\\\"\\\",\\\"targetc\\\":\\\"\\\"}\",\"attribs\":\"{\\\"article_layout\\\":\\\"\\\",\\\"show_title\\\":\\\"\\\",\\\"link_titles\\\":\\\"\\\",\\\"show_tags\\\":\\\"\\\",\\\"show_intro\\\":\\\"\\\",\\\"info_block_position\\\":\\\"\\\",\\\"info_block_show_title\\\":\\\"\\\",\\\"show_category\\\":\\\"\\\",\\\"link_category\\\":\\\"\\\",\\\"show_parent_category\\\":\\\"\\\",\\\"link_parent_category\\\":\\\"\\\",\\\"show_author\\\":\\\"\\\",\\\"link_author\\\":\\\"\\\",\\\"show_create_date\\\":\\\"\\\",\\\"show_modify_date\\\":\\\"\\\",\\\"show_publish_date\\\":\\\"\\\",\\\"show_item_navigation\\\":\\\"\\\",\\\"show_hits\\\":\\\"\\\",\\\"show_noauth\\\":\\\"\\\",\\\"urls_position\\\":\\\"\\\",\\\"alternative_readmore\\\":\\\"\\\",\\\"article_page_title\\\":\\\"\\\",\\\"show_publishing_options\\\":\\\"\\\",\\\"show_article_options\\\":\\\"\\\",\\\"show_urls_images_backend\\\":\\\"\\\",\\\"show_urls_images_frontend\\\":\\\"\\\"}\",\"version\":2,\"ordering\":1,\"metakey\":\"\",\"metadesc\":\"\",\"access\":1,\"hits\":1,\"metadata\":\"{\\\"robots\\\":\\\"\\\",\\\"author\\\":\\\"\\\",\\\"rights\\\":\\\"\\\"}\",\"featured\":\"0\",\"language\":\"*\",\"note\":\"\"}',0);

--
-- Table structure for table `l0eco_languages`
--

CREATE TABLE `l0eco_languages` (
  `lang_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `asset_id` int(10) unsigned NOT NULL DEFAULT 0,
  `lang_code` char(7) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL,
  `title` varchar(50) NOT NULL,
  `title_native` varchar(50) NOT NULL,
  `sef` varchar(50) NOT NULL,
  `image` varchar(50) NOT NULL,
  `description` varchar(512) NOT NULL,
  `metakey` text DEFAULT NULL,
  `metadesc` text NOT NULL,
  `sitename` varchar(1024) NOT NULL DEFAULT '',
  `published` int(11) NOT NULL DEFAULT 0,
  `access` int(10) unsigned NOT NULL DEFAULT 0,
  `ordering` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`lang_id`),
  UNIQUE KEY `idx_sef` (`sef`),
  UNIQUE KEY `idx_langcode` (`lang_code`),
  KEY `idx_access` (`access`),
  KEY `idx_ordering` (`ordering`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `l0eco_languages`
--

INSERT INTO `l0eco_languages` VALUES (1,0,'en-GB','English (en-GB)','English (United Kingdom)','en','en_gb','','','','',1,1,2),(2,91,'el-GR','Greek (el-GR)','Greek (el-GR)','el','el_gr','',NULL,'','',0,1,1);

--
-- Table structure for table `l0eco_mail_templates`
--

CREATE TABLE `l0eco_mail_templates` (
  `template_id` varchar(127) NOT NULL DEFAULT '',
  `extension` varchar(127) NOT NULL DEFAULT '',
  `language` char(7) NOT NULL DEFAULT '',
  `subject` varchar(255) NOT NULL DEFAULT '',
  `body` text NOT NULL,
  `htmlbody` mediumtext NOT NULL,
  `attachments` text NOT NULL,
  `params` text NOT NULL,
  PRIMARY KEY (`template_id`,`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `l0eco_mail_templates`
--

INSERT INTO `l0eco_mail_templates` VALUES ('com_actionlogs.notification','com_actionlogs','','COM_ACTIONLOGS_EMAIL_SUBJECT','COM_ACTIONLOGS_EMAIL_BODY','COM_ACTIONLOGS_EMAIL_HTMLBODY','','{\"tags\":[\"message\",\"date\",\"extension\",\"username\"]}'),('com_config.test_mail','com_config','','COM_CONFIG_SENDMAIL_SUBJECT','COM_CONFIG_SENDMAIL_BODY','','','{\"tags\":[\"sitename\",\"method\"]}'),('com_contact.mail','com_contact','','COM_CONTACT_ENQUIRY_SUBJECT','COM_CONTACT_ENQUIRY_TEXT','','','{\"tags\":[\"sitename\",\"name\",\"email\",\"subject\",\"body\",\"url\",\"customfields\"]}'),('com_contact.mail.copy','com_contact','','COM_CONTACT_COPYSUBJECT_OF','COM_CONTACT_COPYTEXT_OF','','','{\"tags\":[\"sitename\",\"name\",\"email\",\"subject\",\"body\",\"url\",\"customfields\",\"contactname\"]}'),('com_messages.new_message','com_messages','','COM_MESSAGES_NEW_MESSAGE','COM_MESSAGES_NEW_MESSAGE_BODY','','','{\"tags\":[\"subject\",\"message\",\"fromname\",\"sitename\",\"siteurl\",\"fromemail\",\"toname\",\"toemail\"]}'),('com_privacy.notification.admin.export','com_privacy','','COM_PRIVACY_EMAIL_ADMIN_REQUEST_SUBJECT_EXPORT_REQUEST','COM_PRIVACY_EMAIL_ADMIN_REQUEST_BODY_EXPORT_REQUEST','','','{\"tags\":[\"sitename\",\"url\",\"tokenurl\",\"formurl\",\"token\"]}'),('com_privacy.notification.admin.remove','com_privacy','','COM_PRIVACY_EMAIL_ADMIN_REQUEST_SUBJECT_REMOVE_REQUEST','COM_PRIVACY_EMAIL_ADMIN_REQUEST_BODY_REMOVE_REQUEST','','','{\"tags\":[\"sitename\",\"url\",\"tokenurl\",\"formurl\",\"token\"]}'),('com_privacy.notification.export','com_privacy','','COM_PRIVACY_EMAIL_REQUEST_SUBJECT_EXPORT_REQUEST','COM_PRIVACY_EMAIL_REQUEST_BODY_EXPORT_REQUEST','','','{\"tags\":[\"sitename\",\"url\",\"tokenurl\",\"formurl\",\"token\"]}'),('com_privacy.notification.remove','com_privacy','','COM_PRIVACY_EMAIL_REQUEST_SUBJECT_REMOVE_REQUEST','COM_PRIVACY_EMAIL_REQUEST_BODY_REMOVE_REQUEST','','','{\"tags\":[\"sitename\",\"url\",\"tokenurl\",\"formurl\",\"token\"]}'),('com_privacy.userdataexport','com_privacy','','COM_PRIVACY_EMAIL_DATA_EXPORT_COMPLETED_SUBJECT','COM_PRIVACY_EMAIL_DATA_EXPORT_COMPLETED_BODY','','','{\"tags\":[\"sitename\",\"url\"]}'),('com_users.massmail.mail','com_users','','COM_USERS_MASSMAIL_MAIL_SUBJECT','COM_USERS_MASSMAIL_MAIL_BODY','','','{\"tags\":[\"subject\",\"body\",\"subjectprefix\",\"bodysuffix\"]}'),('com_users.password_reset','com_users','','COM_USERS_EMAIL_PASSWORD_RESET_SUBJECT','COM_USERS_EMAIL_PASSWORD_RESET_BODY','','','{\"tags\":[\"name\",\"email\",\"sitename\",\"link_text\",\"link_html\",\"token\"]}'),('com_users.registration.admin.new_notification','com_users','','COM_USERS_EMAIL_ACCOUNT_DETAILS','COM_USERS_EMAIL_REGISTERED_NOTIFICATION_TO_ADMIN_BODY','','','{\"tags\":[\"name\",\"sitename\",\"siteurl\",\"username\"]}'),('com_users.registration.admin.verification_request','com_users','','COM_USERS_EMAIL_ACTIVATE_WITH_ADMIN_ACTIVATION_SUBJECT','COM_USERS_EMAIL_ACTIVATE_WITH_ADMIN_ACTIVATION_BODY','','','{\"tags\":[\"name\",\"sitename\",\"email\",\"username\",\"activate\"]}'),('com_users.registration.user.admin_activated','com_users','','COM_USERS_EMAIL_ACTIVATED_BY_ADMIN_ACTIVATION_SUBJECT','COM_USERS_EMAIL_ACTIVATED_BY_ADMIN_ACTIVATION_BODY','','','{\"tags\":[\"name\",\"sitename\",\"siteurl\",\"username\"]}'),('com_users.registration.user.admin_activation','com_users','','COM_USERS_EMAIL_ACCOUNT_DETAILS','COM_USERS_EMAIL_REGISTERED_WITH_ADMIN_ACTIVATION_BODY_NOPW','','','{\"tags\":[\"name\",\"sitename\",\"activate\",\"siteurl\",\"username\"]}'),('com_users.registration.user.admin_activation_w_pw','com_users','','COM_USERS_EMAIL_ACCOUNT_DETAILS','COM_USERS_EMAIL_REGISTERED_WITH_ADMIN_ACTIVATION_BODY','','','{\"tags\":[\"name\",\"sitename\",\"activate\",\"siteurl\",\"username\",\"password_clear\"]}'),('com_users.registration.user.registration_mail','com_users','','COM_USERS_EMAIL_ACCOUNT_DETAILS','COM_USERS_EMAIL_REGISTERED_BODY_NOPW','','','{\"tags\":[\"name\",\"sitename\",\"activate\",\"siteurl\",\"username\"]}'),('com_users.registration.user.registration_mail_w_pw','com_users','','COM_USERS_EMAIL_ACCOUNT_DETAILS','COM_USERS_EMAIL_REGISTERED_BODY','','','{\"tags\":[\"name\",\"sitename\",\"activate\",\"siteurl\",\"username\",\"password_clear\"]}'),('com_users.registration.user.self_activation','com_users','','COM_USERS_EMAIL_ACCOUNT_DETAILS','COM_USERS_EMAIL_REGISTERED_WITH_ACTIVATION_BODY_NOPW','','','{\"tags\":[\"name\",\"sitename\",\"activate\",\"siteurl\",\"username\"]}'),('com_users.registration.user.self_activation_w_pw','com_users','','COM_USERS_EMAIL_ACCOUNT_DETAILS','COM_USERS_EMAIL_REGISTERED_WITH_ACTIVATION_BODY','','','{\"tags\":[\"name\",\"sitename\",\"activate\",\"siteurl\",\"username\",\"password_clear\"]}'),('com_users.reminder','com_users','','COM_USERS_EMAIL_USERNAME_REMINDER_SUBJECT','COM_USERS_EMAIL_USERNAME_REMINDER_BODY','','','{\"tags\":[\"name\",\"username\",\"sitename\",\"email\",\"link_text\",\"link_html\"]}'),('plg_multifactorauth_email.mail','plg_multifactorauth_email','','PLG_MULTIFACTORAUTH_EMAIL_EMAIL_SUBJECT','PLG_MULTIFACTORAUTH_EMAIL_EMAIL_BODY','','','{\"tags\":[\"code\",\"sitename\",\"siteurl\",\"username\",\"email\",\"fullname\"]}'),('plg_system_privacyconsent.request.reminder','plg_system_privacyconsent','','PLG_SYSTEM_PRIVACYCONSENT_EMAIL_REMIND_SUBJECT','PLG_SYSTEM_PRIVACYCONSENT_EMAIL_REMIND_BODY','','','{\"tags\":[\"sitename\",\"url\",\"tokenurl\",\"formurl\",\"token\"]}'),('plg_system_tasknotification.failure_mail','plg_system_tasknotification','','PLG_SYSTEM_TASK_NOTIFICATION_FAILURE_MAIL_SUBJECT','PLG_SYSTEM_TASK_NOTIFICATION_FAILURE_MAIL_BODY','','','{\"tags\": [\"task_id\", \"task_title\", \"exit_code\", \"exec_data_time\", \"task_output\"]}'),('plg_system_tasknotification.fatal_recovery_mail','plg_system_tasknotification','','PLG_SYSTEM_TASK_NOTIFICATION_FATAL_MAIL_SUBJECT','PLG_SYSTEM_TASK_NOTIFICATION_FATAL_MAIL_BODY','','','{\"tags\": [\"task_id\", \"task_title\"]}'),('plg_system_tasknotification.orphan_mail','plg_system_tasknotification','','PLG_SYSTEM_TASK_NOTIFICATION_ORPHAN_MAIL_SUBJECT','PLG_SYSTEM_TASK_NOTIFICATION_ORPHAN_MAIL_BODY','','','{\"tags\": [\"task_id\", \"task_title\"]}'),('plg_system_tasknotification.success_mail','plg_system_tasknotification','','PLG_SYSTEM_TASK_NOTIFICATION_SUCCESS_MAIL_SUBJECT','PLG_SYSTEM_TASK_NOTIFICATION_SUCCESS_MAIL_BODY','','','{\"tags\":[\"task_id\", \"task_title\", \"exec_data_time\", \"task_output\"]}'),('plg_system_updatenotification.mail','plg_system_updatenotification','','PLG_SYSTEM_UPDATENOTIFICATION_EMAIL_SUBJECT','PLG_SYSTEM_UPDATENOTIFICATION_EMAIL_BODY','','','{\"tags\":[\"newversion\",\"curversion\",\"sitename\",\"url\",\"link\",\"releasenews\"]}'),('plg_user_joomla.mail','plg_user_joomla','','PLG_USER_JOOMLA_NEW_USER_EMAIL_SUBJECT','PLG_USER_JOOMLA_NEW_USER_EMAIL_BODY','','','{\"tags\":[\"name\",\"sitename\",\"url\",\"username\",\"password\",\"email\"]}');

--
-- Table structure for table `l0eco_menu`
--

CREATE TABLE `l0eco_menu` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `menutype` varchar(24) NOT NULL COMMENT 'The type of menu this item belongs to. FK to #__menu_types.menutype',
  `title` varchar(255) NOT NULL COMMENT 'The display title of the menu item.',
  `alias` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL COMMENT 'The SEF alias of the menu item.',
  `note` varchar(255) NOT NULL DEFAULT '',
  `path` varchar(1024) NOT NULL COMMENT 'The computed path of the menu item based on the alias field.',
  `link` varchar(1024) NOT NULL COMMENT 'The actually link the menu item refers to.',
  `type` varchar(16) NOT NULL COMMENT 'The type of link: Component, URL, Alias, Separator',
  `published` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'The published state of the menu link.',
  `parent_id` int(10) unsigned NOT NULL DEFAULT 1 COMMENT 'The parent menu item in the menu tree.',
  `level` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'The relative level in the tree.',
  `component_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'FK to #__extensions.id',
  `checked_out` int(10) unsigned DEFAULT NULL COMMENT 'FK to #__users.id',
  `checked_out_time` datetime DEFAULT NULL COMMENT 'The time the menu item was checked out.',
  `browserNav` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'The click behaviour of the link.',
  `access` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'The access level required to view the menu item.',
  `img` varchar(255) NOT NULL COMMENT 'The image of the menu item.',
  `template_style_id` int(10) unsigned NOT NULL DEFAULT 0,
  `params` text NOT NULL COMMENT 'JSON encoded data for the menu item.',
  `lft` int(11) NOT NULL DEFAULT 0 COMMENT 'Nested set lft.',
  `rgt` int(11) NOT NULL DEFAULT 0 COMMENT 'Nested set rgt.',
  `home` tinyint(3) unsigned NOT NULL DEFAULT 0 COMMENT 'Indicates if this menu item is the home or default page.',
  `language` char(7) NOT NULL DEFAULT '',
  `client_id` tinyint(4) NOT NULL DEFAULT 0,
  `publish_up` datetime DEFAULT NULL,
  `publish_down` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_client_id_parent_id_alias_language` (`client_id`,`parent_id`,`alias`(100),`language`),
  KEY `idx_componentid` (`component_id`,`menutype`,`published`,`access`),
  KEY `idx_menutype` (`menutype`),
  KEY `idx_left_right` (`lft`,`rgt`),
  KEY `idx_alias` (`alias`(100)),
  KEY `idx_path` (`path`(100)),
  KEY `idx_language` (`language`)
) ENGINE=InnoDB AUTO_INCREMENT=103 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `l0eco_menu`
--

INSERT INTO `l0eco_menu` VALUES (1,'','Menu_Item_Root','root','','','','',1,0,0,0,NULL,NULL,0,0,'',0,'',0,45,0,'*',0,NULL,NULL),(2,'main','com_banners','Banners','','Banners','index.php?option=com_banners','component',1,1,1,3,NULL,NULL,0,0,'class:bookmark',0,'',1,10,0,'*',1,NULL,NULL),(3,'main','com_banners','Banners','','Banners/Banners','index.php?option=com_banners&view=banners','component',1,2,2,3,NULL,NULL,0,0,'class:banners',0,'',2,3,0,'*',1,NULL,NULL),(4,'main','com_banners_categories','Categories','','Banners/Categories','index.php?option=com_categories&view=categories&extension=com_banners','component',1,2,2,5,NULL,NULL,0,0,'class:banners-cat',0,'',4,5,0,'*',1,NULL,NULL),(5,'main','com_banners_clients','Clients','','Banners/Clients','index.php?option=com_banners&view=clients','component',1,2,2,3,NULL,NULL,0,0,'class:banners-clients',0,'',6,7,0,'*',1,NULL,NULL),(6,'main','com_banners_tracks','Tracks','','Banners/Tracks','index.php?option=com_banners&view=tracks','component',1,2,2,3,NULL,NULL,0,0,'class:banners-tracks',0,'',8,9,0,'*',1,NULL,NULL),(7,'main','com_contact','Contacts','','Contacts','index.php?option=com_contact','component',1,1,1,7,NULL,NULL,0,0,'class:address-book',0,'',11,20,0,'*',1,NULL,NULL),(8,'main','com_contact_contacts','Contacts','','Contacts/Contacts','index.php?option=com_contact&view=contacts','component',1,7,2,7,NULL,NULL,0,0,'class:contact',0,'',12,13,0,'*',1,NULL,NULL),(9,'main','com_contact_categories','Categories','','Contacts/Categories','index.php?option=com_categories&view=categories&extension=com_contact','component',1,7,2,5,NULL,NULL,0,0,'class:contact-cat',0,'',14,15,0,'*',1,NULL,NULL),(10,'main','com_newsfeeds','News Feeds','','News Feeds','index.php?option=com_newsfeeds','component',1,1,1,16,NULL,NULL,0,0,'class:rss',0,'',23,28,0,'*',1,NULL,NULL),(11,'main','com_newsfeeds_feeds','Feeds','','News Feeds/Feeds','index.php?option=com_newsfeeds&view=newsfeeds','component',1,10,2,16,NULL,NULL,0,0,'class:newsfeeds',0,'',24,25,0,'*',1,NULL,NULL),(12,'main','com_newsfeeds_categories','Categories','','News Feeds/Categories','index.php?option=com_categories&view=categories&extension=com_newsfeeds','component',1,10,2,5,NULL,NULL,0,0,'class:newsfeeds-cat',0,'',26,27,0,'*',1,NULL,NULL),(13,'main','com_finder','Smart Search','','Smart Search','index.php?option=com_finder','component',1,1,1,23,NULL,NULL,0,0,'class:search-plus',0,'',29,38,0,'*',1,NULL,NULL),(14,'main','com_tags','Tags','','Tags','index.php?option=com_tags&view=tags','component',1,1,1,25,NULL,NULL,0,1,'class:tags',0,'',39,40,0,'',1,NULL,NULL),(15,'main','com_associations','Multilingual Associations','','Multilingual Associations','index.php?option=com_associations&view=associations','component',1,1,1,30,NULL,NULL,0,0,'class:language',0,'',21,22,0,'*',1,NULL,NULL),(16,'main','mod_menu_fields','Contact Custom Fields','','contact/Custom Fields','index.php?option=com_fields&context=com_contact.contact','component',1,7,2,29,NULL,NULL,0,0,'class:messages-add',0,'',16,17,0,'*',1,NULL,NULL),(17,'main','mod_menu_fields_group','Contact Custom Fields Group','','contact/Custom Fields Group','index.php?option=com_fields&view=groups&context=com_contact.contact','component',1,7,2,29,NULL,NULL,0,0,'class:messages-add',0,'',18,19,0,'*',1,NULL,NULL),(18,'main','com_finder_index','Smart-Search-Index','','Smart Search/Index','index.php?option=com_finder&view=index','component',1,13,2,23,NULL,NULL,0,0,'class:finder',0,'',30,31,0,'*',1,NULL,NULL),(19,'main','com_finder_maps','Smart-Search-Maps','','Smart Search/Maps','index.php?option=com_finder&view=maps','component',1,13,2,23,NULL,NULL,0,0,'class:finder-maps',0,'',32,33,0,'*',1,NULL,NULL),(20,'main','com_finder_filters','Smart-Search-Filters','','Smart Search/Filters','index.php?option=com_finder&view=filters','component',1,13,2,23,NULL,NULL,0,0,'class:finder-filters',0,'',34,35,0,'*',1,NULL,NULL),(21,'main','com_finder_searches','Smart-Search-Searches','','Smart Search/Searches','index.php?option=com_finder&view=searches','component',1,13,2,23,NULL,NULL,0,0,'class:finder-searches',0,'',36,37,0,'*',1,NULL,NULL),(101,'mainmenu','Αρχική','home','','home','index.php?option=com_content&view=article&id=1','component',1,1,1,19,NULL,NULL,0,1,' ',0,'{\"show_title\":\"\",\"link_titles\":\"\",\"show_intro\":\"\",\"info_block_position\":\"\",\"info_block_show_title\":\"\",\"show_category\":\"\",\"link_category\":\"\",\"show_parent_category\":\"\",\"link_parent_category\":\"\",\"show_author\":\"\",\"link_author\":\"\",\"show_create_date\":\"\",\"show_modify_date\":\"\",\"show_publish_date\":\"\",\"show_item_navigation\":\"\",\"show_hits\":\"\",\"show_tags\":\"\",\"show_noauth\":\"\",\"urls_position\":\"\",\"menu-anchor_title\":\"\",\"menu-anchor_css\":\"\",\"menu_icon_css\":\"\",\"menu_image\":\"\",\"menu_image_css\":\"\",\"menu_text\":1,\"menu_show\":1,\"page_title\":\"\",\"show_page_heading\":\"0\",\"page_heading\":\"\",\"pageclass_sfx\":\"\",\"menu-meta_description\":\"\",\"robots\":\"\"}',41,42,1,'*',0,NULL,NULL),(102,'mainmenu','Στόχοι & Επιδιώξεις','goal-and-objective','','goal-and-objective','index.php?option=com_content&view=article&id=2','component',1,1,1,19,NULL,NULL,0,1,' ',0,'{\"show_title\":\"\",\"link_titles\":\"\",\"show_intro\":\"\",\"info_block_position\":\"\",\"info_block_show_title\":\"\",\"show_category\":\"\",\"link_category\":\"\",\"show_parent_category\":\"\",\"link_parent_category\":\"\",\"show_author\":\"\",\"link_author\":\"\",\"show_create_date\":\"\",\"show_modify_date\":\"\",\"show_publish_date\":\"\",\"show_item_navigation\":\"\",\"show_hits\":\"\",\"show_tags\":\"\",\"show_noauth\":\"\",\"urls_position\":\"\",\"menu-anchor_title\":\"\",\"menu-anchor_css\":\"\",\"menu_icon_css\":\"\",\"menu_image\":\"\",\"menu_image_css\":\"\",\"menu_text\":1,\"menu_show\":1,\"page_title\":\"\",\"show_page_heading\":\"\",\"page_heading\":\"\",\"pageclass_sfx\":\"\",\"menu-meta_description\":\"\",\"robots\":\"\"}',43,44,0,'*',0,NULL,NULL);

--
-- Table structure for table `l0eco_menu_types`
--

CREATE TABLE `l0eco_menu_types` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `asset_id` int(10) unsigned NOT NULL DEFAULT 0,
  `menutype` varchar(24) NOT NULL,
  `title` varchar(48) NOT NULL,
  `description` varchar(255) NOT NULL DEFAULT '',
  `client_id` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_menutype` (`menutype`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `l0eco_menu_types`
--

INSERT INTO `l0eco_menu_types` VALUES (1,0,'mainmenu','Main Menu','The main menu for the site',0);

--
-- Table structure for table `l0eco_messages`
--

CREATE TABLE `l0eco_messages` (
  `message_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id_from` int(10) unsigned NOT NULL DEFAULT 0,
  `user_id_to` int(10) unsigned NOT NULL DEFAULT 0,
  `folder_id` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `date_time` datetime NOT NULL,
  `state` tinyint(4) NOT NULL DEFAULT 0,
  `priority` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `subject` varchar(255) NOT NULL DEFAULT '',
  `message` text NOT NULL,
  PRIMARY KEY (`message_id`),
  KEY `useridto_state` (`user_id_to`,`state`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `l0eco_messages`
--


--
-- Table structure for table `l0eco_messages_cfg`
--

CREATE TABLE `l0eco_messages_cfg` (
  `user_id` int(10) unsigned NOT NULL DEFAULT 0,
  `cfg_name` varchar(100) NOT NULL DEFAULT '',
  `cfg_value` varchar(255) NOT NULL DEFAULT '',
  UNIQUE KEY `idx_user_var_name` (`user_id`,`cfg_name`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `l0eco_messages_cfg`
--


--
-- Table structure for table `l0eco_modules`
--

CREATE TABLE `l0eco_modules` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `asset_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'FK to the #__assets table.',
  `title` varchar(100) NOT NULL DEFAULT '',
  `note` varchar(255) NOT NULL DEFAULT '',
  `content` text DEFAULT NULL,
  `ordering` int(11) NOT NULL DEFAULT 0,
  `position` varchar(50) NOT NULL DEFAULT '',
  `checked_out` int(10) unsigned DEFAULT NULL,
  `checked_out_time` datetime DEFAULT NULL,
  `publish_up` datetime DEFAULT NULL,
  `publish_down` datetime DEFAULT NULL,
  `published` tinyint(4) NOT NULL DEFAULT 0,
  `module` varchar(50) DEFAULT NULL,
  `access` int(10) unsigned NOT NULL DEFAULT 0,
  `showtitle` tinyint(3) unsigned NOT NULL DEFAULT 1,
  `params` text NOT NULL,
  `client_id` tinyint(4) NOT NULL DEFAULT 0,
  `language` char(7) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `published` (`published`,`access`),
  KEY `newsfeeds` (`module`,`published`),
  KEY `idx_language` (`language`)
) ENGINE=InnoDB AUTO_INCREMENT=111 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `l0eco_modules`
--

INSERT INTO `l0eco_modules` VALUES (1,39,'Main Menu','','',1,'menu',NULL,NULL,NULL,NULL,1,'mod_menu',1,0,'{\"menutype\":\"mainmenu\",\"base\":\"\",\"startLevel\":1,\"endLevel\":0,\"showAllChildren\":1,\"tag_id\":\"\",\"class_sfx\":\"\",\"window_open\":\"\",\"layout\":\"cassiopeia:collapse-metismenu\",\"moduleclass_sfx\":\"\",\"cache\":1,\"cache_time\":900,\"cachemode\":\"itemid\",\"module_tag\":\"div\",\"bootstrap_size\":\"0\",\"header_tag\":\"h3\",\"header_class\":\"\",\"style\":\"0\"}',0,'*'),(2,40,'Login','','',1,'login',NULL,NULL,NULL,NULL,1,'mod_login',1,1,'',1,'*'),(3,41,'Popular Articles','','',3,'cpanel',NULL,NULL,NULL,NULL,1,'mod_popular',3,1,'{\"count\":\"5\",\"catid\":\"\",\"user_id\":\"0\",\"layout\":\"_:default\",\"moduleclass_sfx\":\"\",\"cache\":\"0\", \"bootstrap_size\": \"12\",\"header_tag\":\"h2\"}',1,'*'),(4,42,'Recently Added Articles','','',4,'cpanel',NULL,NULL,NULL,NULL,1,'mod_latest',3,1,'{\"count\":\"5\",\"ordering\":\"c_dsc\",\"catid\":\"\",\"user_id\":\"0\",\"layout\":\"_:default\",\"moduleclass_sfx\":\"\",\"cache\":\"0\", \"bootstrap_size\": \"12\",\"header_tag\":\"h2\"}',1,'*'),(8,43,'Toolbar','','',1,'toolbar',NULL,NULL,NULL,NULL,1,'mod_toolbar',3,1,'',1,'*'),(9,44,'Notifications','','',3,'icon',NULL,NULL,NULL,NULL,1,'mod_quickicon',3,1,'{\"context\":\"update_quickicon\",\"header_icon\":\"icon-sync\",\"show_jupdate\":\"1\",\"show_eupdate\":\"1\",\"show_oupdate\":\"1\",\"show_privacy\":\"1\",\"layout\":\"_:default\",\"moduleclass_sfx\":\"\",\"cache\":1,\"cache_time\":900,\"style\":\"0\",\"module_tag\":\"div\",\"bootstrap_size\":\"12\",\"header_tag\":\"h2\",\"header_class\":\"\"}',1,'*'),(10,45,'Logged-in Users','','',2,'cpanel',NULL,NULL,NULL,NULL,1,'mod_logged',3,1,'{\"count\":\"5\",\"name\":\"1\",\"layout\":\"_:default\",\"moduleclass_sfx\":\"\",\"cache\":\"0\", \"bootstrap_size\": \"12\",\"header_tag\":\"h2\"}',1,'*'),(12,46,'Admin Menu','','',1,'menu',NULL,NULL,NULL,NULL,1,'mod_menu',3,1,'{\"layout\":\"\",\"moduleclass_sfx\":\"\",\"shownew\":\"1\",\"showhelp\":\"1\",\"cache\":\"0\"}',1,'*'),(15,49,'Title','','',1,'title',NULL,NULL,NULL,NULL,1,'mod_title',3,1,'',1,'*'),(16,50,'Login Form','','',7,'sidebar-right',NULL,NULL,NULL,NULL,1,'mod_login',1,1,'{\"greeting\":\"1\",\"name\":\"0\"}',0,'*'),(17,51,'Breadcrumbs','','',1,'breadcrumbs',NULL,NULL,NULL,NULL,1,'mod_breadcrumbs',1,1,'{\"moduleclass_sfx\":\"\",\"showHome\":\"1\",\"homeText\":\"\",\"showComponent\":\"1\",\"separator\":\"\",\"cache\":\"0\",\"cache_time\":\"0\",\"cachemode\":\"itemid\"}',0,'*'),(79,52,'Multilanguage status','','',2,'status',NULL,NULL,NULL,NULL,1,'mod_multilangstatus',3,1,'{\"layout\":\"_:default\",\"moduleclass_sfx\":\"\",\"cache\":\"0\"}',1,'*'),(86,53,'Joomla Version','','',1,'status',NULL,NULL,NULL,NULL,1,'mod_version',3,1,'{\"layout\":\"_:default\",\"moduleclass_sfx\":\"\",\"cache\":\"0\"}',1,'*'),(87,55,'Sample Data','','',0,'cpanel',NULL,NULL,NULL,NULL,1,'mod_sampledata',6,1,'{\"bootstrap_size\": \"12\",\"header_tag\":\"h2\"}',1,'*'),(88,67,'Latest Actions','','',0,'cpanel',NULL,NULL,NULL,NULL,1,'mod_latestactions',6,1,'{\"bootstrap_size\": \"12\",\"header_tag\":\"h2\"}',1,'*'),(89,68,'Privacy Dashboard','','',0,'cpanel',NULL,NULL,NULL,NULL,1,'mod_privacy_dashboard',6,1,'{\"bootstrap_size\": \"12\",\"header_tag\":\"h2\"}',1,'*'),(90,89,'Login Support','','',1,'sidebar',NULL,NULL,NULL,NULL,1,'mod_loginsupport',1,1,'{\"forum_url\":\"https://forum.joomla.org/\",\"documentation_url\":\"https://docs.joomla.org/\",\"news_url\":\"https://www.joomla.org/announcements.html\",\"automatic_title\":1,\"prepare_content\":1,\"layout\":\"_:default\",\"moduleclass_sfx\":\"\",\"cache\":1,\"cache_time\":900,\"module_tag\":\"div\",\"bootstrap_size\":\"0\",\"header_tag\":\"h3\",\"header_class\":\"\",\"style\":\"0\"}',1,'*'),(91,72,'System Dashboard','','',1,'cpanel-system',NULL,NULL,NULL,NULL,1,'mod_submenu',1,0,'{\"menutype\":\"*\",\"preset\":\"system\",\"layout\":\"_:default\",\"moduleclass_sfx\":\"\",\"module_tag\":\"div\",\"bootstrap_size\":\"12\",\"header_tag\":\"h2\",\"header_class\":\"\",\"style\":\"System-none\"}',1,'*'),(92,73,'Content Dashboard','','',1,'cpanel-content',NULL,NULL,NULL,NULL,1,'mod_submenu',1,0,'{\"menutype\":\"*\",\"preset\":\"content\",\"layout\":\"_:default\",\"moduleclass_sfx\":\"\",\"module_tag\":\"div\",\"bootstrap_size\":\"12\",\"header_tag\":\"h2\",\"header_class\":\"\",\"style\":\"System-none\"}',1,'*'),(93,74,'Menus Dashboard','','',1,'cpanel-menus',NULL,NULL,NULL,NULL,1,'mod_submenu',1,0,'{\"menutype\":\"*\",\"preset\":\"menus\",\"layout\":\"_:default\",\"moduleclass_sfx\":\"\",\"module_tag\":\"div\",\"bootstrap_size\":\"12\",\"header_tag\":\"h2\",\"header_class\":\"\",\"style\":\"System-none\"}',1,'*'),(94,75,'Components Dashboard','','',1,'cpanel-components',NULL,NULL,NULL,NULL,1,'mod_submenu',1,0,'{\"menutype\":\"*\",\"preset\":\"components\",\"layout\":\"_:default\",\"moduleclass_sfx\":\"\",\"module_tag\":\"div\",\"bootstrap_size\":\"12\",\"header_tag\":\"h2\",\"header_class\":\"\",\"style\":\"System-none\"}',1,'*'),(95,76,'Users Dashboard','','',1,'cpanel-users',NULL,NULL,NULL,NULL,1,'mod_submenu',1,0,'{\"menutype\":\"*\",\"preset\":\"users\",\"layout\":\"_:default\",\"moduleclass_sfx\":\"\",\"module_tag\":\"div\",\"bootstrap_size\":\"12\",\"header_tag\":\"h2\",\"header_class\":\"\",\"style\":\"System-none\"}',1,'*'),(96,86,'Popular Articles','','',3,'cpanel-content',NULL,NULL,NULL,NULL,1,'mod_popular',3,1,'{\"count\":\"5\",\"catid\":\"\",\"user_id\":\"0\",\"layout\":\"_:default\",\"moduleclass_sfx\":\"\",\"cache\":\"0\", \"bootstrap_size\": \"12\",\"header_tag\":\"h2\"}',1,'*'),(97,87,'Recently Added Articles','','',4,'cpanel-content',NULL,NULL,NULL,NULL,1,'mod_latest',3,1,'{\"count\":\"5\",\"ordering\":\"c_dsc\",\"catid\":\"\",\"user_id\":\"0\",\"layout\":\"_:default\",\"moduleclass_sfx\":\"\",\"cache\":\"0\", \"bootstrap_size\": \"12\",\"header_tag\":\"h2\"}',1,'*'),(98,88,'Logged-in Users','','',2,'cpanel-users',NULL,NULL,NULL,NULL,1,'mod_logged',3,1,'{\"count\":\"5\",\"name\":\"1\",\"layout\":\"_:default\",\"moduleclass_sfx\":\"\",\"cache\":\"0\", \"bootstrap_size\": \"12\",\"header_tag\":\"h2\"}',1,'*'),(99,77,'Frontend Link','','',5,'status',NULL,NULL,NULL,NULL,1,'mod_frontend',1,1,'',1,'*'),(100,78,'Messages','','',4,'status',NULL,NULL,NULL,NULL,1,'mod_messages',3,1,'',1,'*'),(101,79,'Post Install Messages','','',3,'status',NULL,NULL,NULL,NULL,1,'mod_post_installation_messages',3,1,'',1,'*'),(102,80,'User Status','','',6,'status',NULL,NULL,NULL,NULL,1,'mod_user',3,1,'',1,'*'),(103,70,'Site','','',1,'icon',NULL,NULL,NULL,NULL,1,'mod_quickicon',1,1,'{\"context\":\"site_quickicon\",\"header_icon\":\"icon-desktop\",\"show_users\":\"1\",\"show_articles\":\"1\",\"show_categories\":\"1\",\"show_media\":\"1\",\"show_menuItems\":\"1\",\"show_modules\":\"1\",\"show_plugins\":\"1\",\"show_templates\":\"1\",\"layout\":\"_:default\",\"moduleclass_sfx\":\"\",\"cache\":1,\"cache_time\":900,\"style\":\"0\",\"module_tag\":\"div\",\"bootstrap_size\":\"12\",\"header_tag\":\"h2\",\"header_class\":\"\"}',1,'*'),(104,71,'System','','',2,'icon',NULL,NULL,NULL,NULL,1,'mod_quickicon',1,1,'{\"context\":\"system_quickicon\",\"header_icon\":\"icon-wrench\",\"show_global\":\"1\",\"show_checkin\":\"1\",\"show_cache\":\"1\",\"layout\":\"_:default\",\"moduleclass_sfx\":\"\",\"cache\":1,\"cache_time\":900,\"style\":\"0\",\"module_tag\":\"div\",\"bootstrap_size\":\"12\",\"header_tag\":\"h2\",\"header_class\":\"\"}',1,'*'),(105,82,'3rd Party','','',4,'icon',NULL,NULL,NULL,NULL,1,'mod_quickicon',1,1,'{\"context\":\"mod_quickicon\",\"header_icon\":\"icon-boxes\",\"load_plugins\":\"1\",\"layout\":\"_:default\",\"moduleclass_sfx\":\"\",\"cache\":1,\"cache_time\":900,\"style\":\"0\",\"module_tag\":\"div\",\"bootstrap_size\":\"12\",\"header_tag\":\"h2\",\"header_class\":\"\"}',1,'*'),(106,83,'Help Dashboard','','',1,'cpanel-help',NULL,NULL,NULL,NULL,1,'mod_submenu',1,0,'{\"menutype\":\"*\",\"preset\":\"help\",\"layout\":\"_:default\",\"moduleclass_sfx\":\"\",\"style\":\"System-none\",\"module_tag\":\"div\",\"bootstrap_size\":\"12\",\"header_tag\":\"h2\",\"header_class\":\"\"}',1,'*'),(107,84,'Privacy Requests','','',1,'cpanel-privacy',NULL,NULL,NULL,NULL,1,'mod_privacy_dashboard',1,1,'{\"layout\":\"_:default\",\"moduleclass_sfx\":\"\",\"cache\":1,\"cache_time\":900,\"cachemode\":\"static\",\"style\":\"0\",\"module_tag\":\"div\",\"bootstrap_size\":\"12\",\"header_tag\":\"h2\",\"header_class\":\"\"}',1,'*'),(108,85,'Privacy Status','','',1,'cpanel-privacy',NULL,NULL,NULL,NULL,1,'mod_privacy_status',1,1,'{\"layout\":\"_:default\",\"moduleclass_sfx\":\"\",\"cache\":1,\"cache_time\":900,\"cachemode\":\"static\",\"style\":\"0\",\"module_tag\":\"div\",\"bootstrap_size\":\"12\",\"header_tag\":\"h2\",\"header_class\":\"\"}',1,'*'),(109,94,'Αναζήτηση','',NULL,1,'search',NULL,NULL,NULL,NULL,1,'mod_finder',1,0,'{\"searchfilter\":\"\",\"show_autosuggest\":1,\"show_advanced\":0,\"show_label\":1,\"alt_label\":\"\",\"show_button\":0,\"opensearch\":1,\"opensearch_name\":\"\",\"set_itemid\":0,\"layout\":\"_:default\",\"moduleclass_sfx\":\"\",\"module_tag\":\"div\",\"bootstrap_size\":\"0\",\"header_tag\":\"h3\",\"header_class\":\"\",\"style\":\"0\"}',0,'*'),(110,95,'Banner','',NULL,1,'banner',NULL,NULL,NULL,NULL,1,'mod_random_image',1,0,'{\"type\":\"jpg\",\"folder\":\"images\\/fotos\",\"link\":\"\",\"width\":1000,\"height\":500,\"layout\":\"_:default\",\"moduleclass_sfx\":\"\",\"module_tag\":\"div\",\"bootstrap_size\":\"0\",\"header_tag\":\"h3\",\"header_class\":\"\",\"style\":\"0\"}',0,'*');

--
-- Table structure for table `l0eco_modules_menu`
--

CREATE TABLE `l0eco_modules_menu` (
  `moduleid` int(11) NOT NULL DEFAULT 0,
  `menuid` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`moduleid`,`menuid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `l0eco_modules_menu`
--

INSERT INTO `l0eco_modules_menu` VALUES (1,0),(2,0),(3,0),(4,0),(6,0),(7,0),(8,0),(9,0),(10,0),(12,0),(14,0),(15,0),(16,0),(17,0),(79,0),(86,0),(87,0),(88,0),(89,0),(90,0),(91,0),(92,0),(93,0),(94,0),(95,0),(96,0),(97,0),(98,0),(99,0),(100,0),(101,0),(102,0),(103,0),(104,0),(105,0),(106,0),(107,0),(108,0),(109,0),(110,0);

--
-- Table structure for table `l0eco_newsfeeds`
--

CREATE TABLE `l0eco_newsfeeds` (
  `catid` int(11) NOT NULL DEFAULT 0,
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(100) NOT NULL DEFAULT '',
  `alias` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  `link` varchar(2048) NOT NULL DEFAULT '',
  `published` tinyint(4) NOT NULL DEFAULT 0,
  `numarticles` int(10) unsigned NOT NULL DEFAULT 1,
  `cache_time` int(10) unsigned NOT NULL DEFAULT 3600,
  `checked_out` int(10) unsigned DEFAULT NULL,
  `checked_out_time` datetime DEFAULT NULL,
  `ordering` int(11) NOT NULL DEFAULT 0,
  `rtl` tinyint(4) NOT NULL DEFAULT 0,
  `access` int(10) unsigned NOT NULL DEFAULT 0,
  `language` char(7) NOT NULL DEFAULT '',
  `params` text NOT NULL,
  `created` datetime NOT NULL,
  `created_by` int(10) unsigned NOT NULL DEFAULT 0,
  `created_by_alias` varchar(255) NOT NULL DEFAULT '',
  `modified` datetime NOT NULL,
  `modified_by` int(10) unsigned NOT NULL DEFAULT 0,
  `metakey` text DEFAULT NULL,
  `metadesc` text NOT NULL,
  `metadata` text NOT NULL,
  `publish_up` datetime DEFAULT NULL,
  `publish_down` datetime DEFAULT NULL,
  `description` text NOT NULL,
  `version` int(10) unsigned NOT NULL DEFAULT 1,
  `hits` int(10) unsigned NOT NULL DEFAULT 0,
  `images` text NOT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_access` (`access`),
  KEY `idx_checkout` (`checked_out`),
  KEY `idx_state` (`published`),
  KEY `idx_catid` (`catid`),
  KEY `idx_createdby` (`created_by`),
  KEY `idx_language` (`language`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `l0eco_newsfeeds`
--


--
-- Table structure for table `l0eco_overrider`
--

CREATE TABLE `l0eco_overrider` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'Primary Key',
  `constant` varchar(255) NOT NULL,
  `string` text NOT NULL,
  `file` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `l0eco_overrider`
--


--
-- Table structure for table `l0eco_postinstall_messages`
--

CREATE TABLE `l0eco_postinstall_messages` (
  `postinstall_message_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `extension_id` bigint(20) NOT NULL DEFAULT 700 COMMENT 'FK to #__extensions',
  `title_key` varchar(255) NOT NULL DEFAULT '' COMMENT 'Lang key for the title',
  `description_key` varchar(255) NOT NULL DEFAULT '' COMMENT 'Lang key for description',
  `action_key` varchar(255) NOT NULL DEFAULT '',
  `language_extension` varchar(255) NOT NULL DEFAULT 'com_postinstall' COMMENT 'Extension holding lang keys',
  `language_client_id` tinyint(4) NOT NULL DEFAULT 1,
  `type` varchar(10) NOT NULL DEFAULT 'link' COMMENT 'Message type - message, link, action',
  `action_file` varchar(255) DEFAULT '' COMMENT 'RAD URI to the PHP file containing action method',
  `action` varchar(255) DEFAULT '' COMMENT 'Action method name or URL',
  `condition_file` varchar(255) DEFAULT NULL COMMENT 'RAD URI to file holding display condition method',
  `condition_method` varchar(255) DEFAULT NULL COMMENT 'Display condition method, must return boolean',
  `version_introduced` varchar(50) NOT NULL DEFAULT '3.2.0' COMMENT 'Version when this message was introduced',
  `enabled` tinyint(4) NOT NULL DEFAULT 1,
  PRIMARY KEY (`postinstall_message_id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `l0eco_postinstall_messages`
--

INSERT INTO `l0eco_postinstall_messages` VALUES (1,224,'COM_CPANEL_WELCOME_BEGINNERS_TITLE','COM_CPANEL_WELCOME_BEGINNERS_MESSAGE','','com_cpanel',1,'message','','','','','3.2.0',1),(2,224,'COM_CPANEL_MSG_STATS_COLLECTION_TITLE','COM_CPANEL_MSG_STATS_COLLECTION_BODY','','com_cpanel',1,'message','','','admin://components/com_admin/postinstall/statscollection.php','admin_postinstall_statscollection_condition','3.5.0',1),(3,224,'PLG_SYSTEM_UPDATENOTIFICATION_POSTINSTALL_UPDATECACHETIME','PLG_SYSTEM_UPDATENOTIFICATION_POSTINSTALL_UPDATECACHETIME_BODY','PLG_SYSTEM_UPDATENOTIFICATION_POSTINSTALL_UPDATECACHETIME_ACTION','plg_system_updatenotification',1,'action','site://plugins/system/updatenotification/postinstall/updatecachetime.php','updatecachetime_postinstall_action','site://plugins/system/updatenotification/postinstall/updatecachetime.php','updatecachetime_postinstall_condition','3.6.3',1),(4,224,'PLG_SYSTEM_HTTPHEADERS_POSTINSTALL_INTRODUCTION_TITLE','PLG_SYSTEM_HTTPHEADERS_POSTINSTALL_INTRODUCTION_BODY','PLG_SYSTEM_HTTPHEADERS_POSTINSTALL_INTRODUCTION_ACTION','plg_system_httpheaders',1,'action','site://plugins/system/httpheaders/postinstall/introduction.php','httpheaders_postinstall_action','site://plugins/system/httpheaders/postinstall/introduction.php','httpheaders_postinstall_condition','4.0.0',1),(5,224,'COM_USERS_POSTINSTALL_MULTIFACTORAUTH_TITLE','COM_USERS_POSTINSTALL_MULTIFACTORAUTH_BODY','COM_USERS_POSTINSTALL_MULTIFACTORAUTH_ACTION','com_users',1,'action','admin://components/com_users/postinstall/multifactorauth.php','com_users_postinstall_mfa_action','admin://components/com_users/postinstall/multifactorauth.php','com_users_postinstall_mfa_condition','4.2.0',1);

--
-- Table structure for table `l0eco_privacy_consents`
--

CREATE TABLE `l0eco_privacy_consents` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL DEFAULT 0,
  `state` int(11) NOT NULL DEFAULT 1,
  `created` datetime NOT NULL,
  `subject` varchar(255) NOT NULL DEFAULT '',
  `body` text NOT NULL,
  `remind` tinyint(4) NOT NULL DEFAULT 0,
  `token` varchar(100) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `idx_user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `l0eco_privacy_consents`
--


--
-- Table structure for table `l0eco_privacy_requests`
--

CREATE TABLE `l0eco_privacy_requests` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `email` varchar(100) NOT NULL DEFAULT '',
  `requested_at` datetime NOT NULL,
  `status` tinyint(4) NOT NULL DEFAULT 0,
  `request_type` varchar(25) NOT NULL DEFAULT '',
  `confirm_token` varchar(100) NOT NULL DEFAULT '',
  `confirm_token_created_at` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `l0eco_privacy_requests`
--


--
-- Table structure for table `l0eco_redirect_links`
--

CREATE TABLE `l0eco_redirect_links` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `old_url` varchar(2048) NOT NULL,
  `new_url` varchar(2048) DEFAULT NULL,
  `referer` varchar(2048) NOT NULL,
  `comment` varchar(255) NOT NULL DEFAULT '',
  `hits` int(10) unsigned NOT NULL DEFAULT 0,
  `published` tinyint(4) NOT NULL,
  `created_date` datetime NOT NULL,
  `modified_date` datetime NOT NULL,
  `header` smallint(6) NOT NULL DEFAULT 301,
  PRIMARY KEY (`id`),
  KEY `idx_old_url` (`old_url`(100)),
  KEY `idx_link_modified` (`modified_date`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `l0eco_redirect_links`
--


--
-- Table structure for table `l0eco_scheduler_tasks`
--

CREATE TABLE `l0eco_scheduler_tasks` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `asset_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'FK to the #__assets table.',
  `title` varchar(255) NOT NULL DEFAULT '',
  `type` varchar(128) NOT NULL COMMENT 'unique identifier for job defined by plugin',
  `execution_rules` text DEFAULT NULL COMMENT 'Execution Rules, Unprocessed',
  `cron_rules` text DEFAULT NULL COMMENT 'Processed execution rules, crontab-like JSON form',
  `state` tinyint(4) NOT NULL DEFAULT 0,
  `last_exit_code` int(11) NOT NULL DEFAULT 0 COMMENT 'Exit code when job was last run',
  `last_execution` datetime DEFAULT NULL COMMENT 'Timestamp of last run',
  `next_execution` datetime DEFAULT NULL COMMENT 'Timestamp of next (planned) run, referred for execution on trigger',
  `times_executed` int(11) DEFAULT 0 COMMENT 'Count of successful triggers',
  `times_failed` int(11) DEFAULT 0 COMMENT 'Count of failures',
  `locked` datetime DEFAULT NULL,
  `priority` smallint(6) NOT NULL DEFAULT 0,
  `ordering` int(11) NOT NULL DEFAULT 0 COMMENT 'Configurable list ordering',
  `cli_exclusive` smallint(6) NOT NULL DEFAULT 0 COMMENT 'If 1, the task is only accessible via CLI',
  `params` text NOT NULL,
  `note` text DEFAULT NULL,
  `created` datetime NOT NULL,
  `created_by` int(10) unsigned NOT NULL DEFAULT 0,
  `checked_out` int(10) unsigned DEFAULT NULL,
  `checked_out_time` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_type` (`type`),
  KEY `idx_state` (`state`),
  KEY `idx_last_exit` (`last_exit_code`),
  KEY `idx_next_exec` (`next_execution`),
  KEY `idx_locked` (`locked`),
  KEY `idx_priority` (`priority`),
  KEY `idx_cli_exclusive` (`cli_exclusive`),
  KEY `idx_checked_out` (`checked_out`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `l0eco_scheduler_tasks`
--


--
-- Table structure for table `l0eco_schemas`
--

CREATE TABLE `l0eco_schemas` (
  `extension_id` int(11) NOT NULL,
  `version_id` varchar(20) NOT NULL,
  PRIMARY KEY (`extension_id`,`version_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `l0eco_schemas`
--

INSERT INTO `l0eco_schemas` VALUES (224,'4.2.3-2022-09-07');

--
-- Table structure for table `l0eco_session`
--

CREATE TABLE `l0eco_session` (
  `session_id` varbinary(192) NOT NULL,
  `client_id` tinyint(3) unsigned DEFAULT NULL,
  `guest` tinyint(3) unsigned DEFAULT 1,
  `time` int(11) NOT NULL DEFAULT 0,
  `data` mediumtext DEFAULT NULL,
  `userid` int(11) DEFAULT 0,
  `username` varchar(150) DEFAULT '',
  PRIMARY KEY (`session_id`),
  KEY `userid` (`userid`),
  KEY `time` (`time`),
  KEY `client_id_guest` (`client_id`,`guest`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `l0eco_session`
--

INSERT INTO `l0eco_session` VALUES ('1pe1g613a2sfn7eh9vn40l08sn',0,1,1674921169,'joomla|s:840:\"TzoyNDoiSm9vbWxhXFJlZ2lzdHJ5XFJlZ2lzdHJ5IjozOntzOjc6IgAqAGRhdGEiO086ODoic3RkQ2xhc3MiOjQ6e3M6Nzoic2Vzc2lvbiI7Tzo4OiJzdGRDbGFzcyI6Mzp7czo3OiJjb3VudGVyIjtpOjY1O3M6NToidGltZXIiO086ODoic3RkQ2xhc3MiOjM6e3M6NToic3RhcnQiO2k6MTY3NDg5ODU4ODtzOjQ6Imxhc3QiO2k6MTY3NDkyMDcxMDtzOjM6Im5vdyI7aToxNjc0OTIxMTY5O31zOjU6InRva2VuIjtzOjMyOiJhYjQ5YTc1NWUxNjM4NTIwOWU4MTQ3Y2IzZmQ2YzU5OCI7fXM6ODoicmVnaXN0cnkiO086MjQ6Ikpvb21sYVxSZWdpc3RyeVxSZWdpc3RyeSI6Mzp7czo3OiIAKgBkYXRhIjtPOjg6InN0ZENsYXNzIjowOnt9czoxNDoiACoAaW5pdGlhbGl6ZWQiO2I6MDtzOjk6InNlcGFyYXRvciI7czoxOiIuIjt9czo0OiJ1c2VyIjtPOjIwOiJKb29tbGFcQ01TXFVzZXJcVXNlciI6MTp7czoyOiJpZCI7aTowO31zOjE5OiJwbGdfc3lzdGVtX3dlYmF1dGhuIjtPOjg6InN0ZENsYXNzIjoxOntzOjk6InJldHVyblVybCI7czo0MjoiaHR0cHM6Ly9sYWIubXN0LmlodS5nci9kbS9lbGZvdG9wMS9Kb29tbGEvIjt9fXM6MTQ6IgAqAGluaXRpYWxpemVkIjtiOjA7czo5OiJzZXBhcmF0b3IiO3M6MToiLiI7fQ==\";',0,''),('8bdf0g767ijpo2b4kvarkuqnni',1,0,1674921163,'joomla|s:3076:\"TzoyNDoiSm9vbWxhXFJlZ2lzdHJ5XFJlZ2lzdHJ5IjozOntzOjc6IgAqAGRhdGEiO086ODoic3RkQ2xhc3MiOjY6e3M6Nzoic2Vzc2lvbiI7Tzo4OiJzdGRDbGFzcyI6Mzp7czo1OiJ0aW1lciI7Tzo4OiJzdGRDbGFzcyI6Mzp7czo1OiJzdGFydCI7aToxNjc0OTAyNTgwO3M6NDoibGFzdCI7aToxNjc0OTIwMzIzO3M6Mzoibm93IjtpOjE2NzQ5MjExNjM7fXM6NToidG9rZW4iO3M6MzI6IjEyOTFiODdiNjMzOTFmOWMzODUzZmQ2ZGFmOThmYjhhIjtzOjc6ImNvdW50ZXIiO2k6MjUwO31zOjE5OiJwbGdfc3lzdGVtX3dlYmF1dGhuIjtPOjg6InN0ZENsYXNzIjoxOntzOjk6InJldHVyblVybCI7czo2NToiaHR0cHM6Ly9sYWIubXN0LmlodS5nci9kbS9lbGZvdG9wMS9Kb29tbGEvYWRtaW5pc3RyYXRvci9pbmRleC5waHAiO31zOjg6InJlZ2lzdHJ5IjtPOjI0OiJKb29tbGFcUmVnaXN0cnlcUmVnaXN0cnkiOjM6e3M6NzoiACoAZGF0YSI7Tzo4OiJzdGRDbGFzcyI6Njp7czoxMToiY29tX2NvbnRlbnQiO086ODoic3RkQ2xhc3MiOjE6e3M6NDoiZWRpdCI7Tzo4OiJzdGRDbGFzcyI6MTp7czo3OiJhcnRpY2xlIjtPOjg6InN0ZENsYXNzIjoyOntzOjQ6ImRhdGEiO047czoyOiJpZCI7YToxOntpOjA7aToyO319fX1zOjk6ImNvbV9tZW51cyI7Tzo4OiJzdGRDbGFzcyI6Mjp7czo1OiJpdGVtcyI7Tzo4OiJzdGRDbGFzcyI6NDp7czo4OiJtZW51dHlwZSI7czo4OiJtYWlubWVudSI7czo5OiJjbGllbnRfaWQiO2k6MDtzOjEwOiJsaW1pdHN0YXJ0IjtpOjA7czo0OiJsaXN0IjthOjQ6e3M6OToiZGlyZWN0aW9uIjtzOjM6ImFzYyI7czo1OiJsaW1pdCI7aToyMDtzOjg6Im9yZGVyaW5nIjtzOjU6ImEubGZ0IjtzOjU6InN0YXJ0IjtkOjA7fX1zOjQ6ImVkaXQiO086ODoic3RkQ2xhc3MiOjE6e3M6NDoiaXRlbSI7Tzo4OiJzdGRDbGFzcyI6NDp7czoyOiJpZCI7YTowOnt9czo0OiJkYXRhIjtOO3M6NDoidHlwZSI7TjtzOjQ6ImxpbmsiO047fX19czoxMDoiY29tX2NvbmZpZyI7Tzo4OiJzdGRDbGFzcyI6MTp7czo0OiJlZGl0IjtPOjg6InN0ZENsYXNzIjoxOntzOjk6ImNvbXBvbmVudCI7Tzo4OiJzdGRDbGFzcyI6Mjp7czoxMToiY29tX2NvbnRlbnQiO086ODoic3RkQ2xhc3MiOjE6e3M6NDoiZGF0YSI7Tjt9czo5OiJjb21fbWVkaWEiO086ODoic3RkQ2xhc3MiOjE6e3M6NDoiZGF0YSI7Tjt9fX19czoxMzoiY29tX2luc3RhbGxlciI7Tzo4OiJzdGRDbGFzcyI6Mjp7czo3OiJtZXNzYWdlIjtzOjA6IiI7czoxNzoiZXh0ZW5zaW9uX21lc3NhZ2UiO3M6MDoiIjt9czoxMzoiY29tX3RlbXBsYXRlcyI7Tzo4OiJzdGRDbGFzcyI6Mjp7czo2OiJzdHlsZXMiO086ODoic3RkQ2xhc3MiOjQ6e3M6OToiY2xpZW50X2lkIjtzOjE6IjAiO3M6MTA6ImxpbWl0c3RhcnQiO2k6MDtzOjQ6Imxpc3QiO2E6MTp7czoxMjoiZnVsbG9yZGVyaW5nIjtzOjA6IiI7fXM6NjoiZmlsdGVyIjthOjI6e3M6Njoic2VhcmNoIjtzOjA6IiI7czo4OiJ0ZW1wbGF0ZSI7czowOiIiO319czo0OiJlZGl0IjtPOjg6InN0ZENsYXNzIjoxOntzOjU6InN0eWxlIjtPOjg6InN0ZENsYXNzIjoyOntzOjI6ImlkIjthOjA6e31zOjQ6ImRhdGEiO047fX19czoxMToiY29tX21vZHVsZXMiO086ODoic3RkQ2xhc3MiOjM6e3M6NzoibW9kdWxlcyI7Tzo4OiJzdGRDbGFzcyI6Mjp7czo5OiJjbGllbnRfaWQiO3M6MToiMCI7czoxOiIwIjtPOjg6InN0ZENsYXNzIjoyOntzOjk6ImNsaWVudF9pZCI7aTowO3M6NDoibGlzdCI7YTo0OntzOjk6ImRpcmVjdGlvbiI7czozOiJhc2MiO3M6NToibGltaXQiO2k6MjA7czo4OiJvcmRlcmluZyI7czoxMDoiYS5wb3NpdGlvbiI7czo1OiJzdGFydCI7ZDowO319fXM6NDoiZWRpdCI7Tzo4OiJzdGRDbGFzcyI6MTp7czo2OiJtb2R1bGUiO086ODoic3RkQ2xhc3MiOjI6e3M6MjoiaWQiO2E6MDp7fXM6NDoiZGF0YSI7Tjt9fXM6MzoiYWRkIjtPOjg6InN0ZENsYXNzIjoxOntzOjY6Im1vZHVsZSI7Tzo4OiJzdGRDbGFzcyI6Mjp7czoxMjoiZXh0ZW5zaW9uX2lkIjtOO3M6NjoicGFyYW1zIjtOO319fX1zOjE0OiIAKgBpbml0aWFsaXplZCI7YjowO3M6OToic2VwYXJhdG9yIjtzOjE6Ii4iO31zOjQ6InVzZXIiO086MjA6Ikpvb21sYVxDTVNcVXNlclxVc2VyIjoxOntzOjI6ImlkIjtpOjE3OTt9czo5OiJjb21fdXNlcnMiO086ODoic3RkQ2xhc3MiOjE6e3M6MTE6Im1mYV9jaGVja2VkIjtpOjE7fXM6MTE6ImFwcGxpY2F0aW9uIjtPOjg6InN0ZENsYXNzIjoxOntzOjU6InF1ZXVlIjthOjA6e319fXM6MTQ6IgAqAGluaXRpYWxpemVkIjtiOjA7czo5OiJzZXBhcmF0b3IiO3M6MToiLiI7fQ==\";',179,'admin'),('ccbhuef2orh9todk1k1rckrvk7',0,1,1675005137,'joomla|s:836:\"TzoyNDoiSm9vbWxhXFJlZ2lzdHJ5XFJlZ2lzdHJ5IjozOntzOjc6IgAqAGRhdGEiO086ODoic3RkQ2xhc3MiOjQ6e3M6Nzoic2Vzc2lvbiI7Tzo4OiJzdGRDbGFzcyI6Mzp7czo3OiJjb3VudGVyIjtpOjI7czo1OiJ0aW1lciI7Tzo4OiJzdGRDbGFzcyI6Mzp7czo1OiJzdGFydCI7aToxNjc1MDA0NjE5O3M6NDoibGFzdCI7aToxNjc1MDA0NjE5O3M6Mzoibm93IjtpOjE2NzUwMDUxMzc7fXM6NToidG9rZW4iO3M6MzI6IjcyZjQ5ZGQ4MWFjNTE2ODAyMzVjNWY0YjIwZmUzM2Y2Ijt9czo4OiJyZWdpc3RyeSI7TzoyNDoiSm9vbWxhXFJlZ2lzdHJ5XFJlZ2lzdHJ5IjozOntzOjc6IgAqAGRhdGEiO086ODoic3RkQ2xhc3MiOjA6e31zOjE0OiIAKgBpbml0aWFsaXplZCI7YjowO3M6OToic2VwYXJhdG9yIjtzOjE6Ii4iO31zOjQ6InVzZXIiO086MjA6Ikpvb21sYVxDTVNcVXNlclxVc2VyIjoxOntzOjI6ImlkIjtpOjA7fXM6MTk6InBsZ19zeXN0ZW1fd2ViYXV0aG4iO086ODoic3RkQ2xhc3MiOjE6e3M6OToicmV0dXJuVXJsIjtzOjQyOiJodHRwczovL2xhYi5tc3QuaWh1LmdyL2RtL2VsZm90b3AxL0pvb21sYS8iO319czoxNDoiACoAaW5pdGlhbGl6ZWQiO2I6MDtzOjk6InNlcGFyYXRvciI7czoxOiIuIjt9\";',0,''),('uv1kk31ein2m5iv7thpokdlk55',1,0,1675005129,'joomla|s:948:\"TzoyNDoiSm9vbWxhXFJlZ2lzdHJ5XFJlZ2lzdHJ5IjozOntzOjc6IgAqAGRhdGEiO086ODoic3RkQ2xhc3MiOjU6e3M6Nzoic2Vzc2lvbiI7Tzo4OiJzdGRDbGFzcyI6Mzp7czo3OiJjb3VudGVyIjtpOjQ7czo1OiJ0aW1lciI7Tzo4OiJzdGRDbGFzcyI6Mzp7czo1OiJzdGFydCI7aToxNjc1MDA1MTI2O3M6NDoibGFzdCI7aToxNjc1MDA1MTI5O3M6Mzoibm93IjtpOjE2NzUwMDUxMjk7fXM6NToidG9rZW4iO3M6MzI6IjNhM2JkZWQ1OTU4Y2E0ZGUwYzIzZGJmODcyZjk5YjhlIjt9czo4OiJyZWdpc3RyeSI7TzoyNDoiSm9vbWxhXFJlZ2lzdHJ5XFJlZ2lzdHJ5IjozOntzOjc6IgAqAGRhdGEiO086ODoic3RkQ2xhc3MiOjA6e31zOjE0OiIAKgBpbml0aWFsaXplZCI7YjowO3M6OToic2VwYXJhdG9yIjtzOjE6Ii4iO31zOjQ6InVzZXIiO086MjA6Ikpvb21sYVxDTVNcVXNlclxVc2VyIjoxOntzOjI6ImlkIjtpOjE3OTt9czoxOToicGxnX3N5c3RlbV93ZWJhdXRobiI7Tzo4OiJzdGRDbGFzcyI6MTp7czo5OiJyZXR1cm5VcmwiO3M6NjU6Imh0dHBzOi8vbGFiLm1zdC5paHUuZ3IvZG0vZWxmb3RvcDEvSm9vbWxhL2FkbWluaXN0cmF0b3IvaW5kZXgucGhwIjt9czo5OiJjb21fdXNlcnMiO086ODoic3RkQ2xhc3MiOjE6e3M6MTE6Im1mYV9jaGVja2VkIjtpOjE7fX1zOjE0OiIAKgBpbml0aWFsaXplZCI7YjowO3M6OToic2VwYXJhdG9yIjtzOjE6Ii4iO30=\";',179,'admin');

--
-- Table structure for table `l0eco_tags`
--

CREATE TABLE `l0eco_tags` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `parent_id` int(10) unsigned NOT NULL DEFAULT 0,
  `lft` int(11) NOT NULL DEFAULT 0,
  `rgt` int(11) NOT NULL DEFAULT 0,
  `level` int(10) unsigned NOT NULL DEFAULT 0,
  `path` varchar(400) NOT NULL DEFAULT '',
  `title` varchar(255) NOT NULL,
  `alias` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  `note` varchar(255) NOT NULL DEFAULT '',
  `description` mediumtext NOT NULL,
  `published` tinyint(4) NOT NULL DEFAULT 0,
  `checked_out` int(10) unsigned DEFAULT NULL,
  `checked_out_time` datetime DEFAULT NULL,
  `access` int(10) unsigned NOT NULL DEFAULT 0,
  `params` text NOT NULL,
  `metadesc` varchar(1024) NOT NULL COMMENT 'The meta description for the page.',
  `metakey` varchar(1024) NOT NULL DEFAULT '' COMMENT 'The keywords for the page.',
  `metadata` varchar(2048) NOT NULL COMMENT 'JSON encoded metadata properties.',
  `created_user_id` int(10) unsigned NOT NULL DEFAULT 0,
  `created_time` datetime NOT NULL,
  `created_by_alias` varchar(255) NOT NULL DEFAULT '',
  `modified_user_id` int(10) unsigned NOT NULL DEFAULT 0,
  `modified_time` datetime NOT NULL,
  `images` text NOT NULL,
  `urls` text NOT NULL,
  `hits` int(10) unsigned NOT NULL DEFAULT 0,
  `language` char(7) NOT NULL,
  `version` int(10) unsigned NOT NULL DEFAULT 1,
  `publish_up` datetime DEFAULT NULL,
  `publish_down` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `tag_idx` (`published`,`access`),
  KEY `idx_access` (`access`),
  KEY `idx_checkout` (`checked_out`),
  KEY `idx_path` (`path`(100)),
  KEY `idx_left_right` (`lft`,`rgt`),
  KEY `idx_alias` (`alias`(100)),
  KEY `idx_language` (`language`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `l0eco_tags`
--

INSERT INTO `l0eco_tags` VALUES (1,0,0,1,0,'','ROOT','root','','',1,NULL,NULL,1,'','','','',179,'2023-01-28 09:33:51','',179,'2023-01-28 09:33:51','','',0,'*',1,NULL,NULL);

--
-- Table structure for table `l0eco_template_overrides`
--

CREATE TABLE `l0eco_template_overrides` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `template` varchar(50) NOT NULL DEFAULT '',
  `hash_id` varchar(255) NOT NULL DEFAULT '',
  `extension_id` int(11) DEFAULT 0,
  `state` tinyint(4) NOT NULL DEFAULT 0,
  `action` varchar(50) NOT NULL DEFAULT '',
  `client_id` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `created_date` datetime NOT NULL,
  `modified_date` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_template` (`template`),
  KEY `idx_extension_id` (`extension_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `l0eco_template_overrides`
--


--
-- Table structure for table `l0eco_template_styles`
--

CREATE TABLE `l0eco_template_styles` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `template` varchar(50) NOT NULL DEFAULT '',
  `client_id` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `home` char(7) NOT NULL DEFAULT '0',
  `title` varchar(255) NOT NULL DEFAULT '',
  `inheritable` tinyint(4) NOT NULL DEFAULT 0,
  `parent` varchar(50) DEFAULT '',
  `params` text NOT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_template` (`template`),
  KEY `idx_client_id` (`client_id`),
  KEY `idx_client_id_home` (`client_id`,`home`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `l0eco_template_styles`
--

INSERT INTO `l0eco_template_styles` VALUES (10,'atum',1,'1','Atum - Default',1,'','{\"hue\":\"hsl(214, 63%, 20%)\",\"bg-light\":\"#f0f4fb\",\"text-dark\":\"#495057\",\"text-light\":\"#ffffff\",\"link-color\":\"#2a69b8\",\"special-color\":\"#001b4c\",\"monochrome\":\"0\",\"loginLogo\":\"\",\"loginLogoAlt\":\"\",\"logoBrandLarge\":\"\",\"logoBrandLargeAlt\":\"\",\"logoBrandSmall\":\"\",\"logoBrandSmallAlt\":\"\"}'),(11,'cassiopeia',0,'1','Cassiopeia - Default',1,'','{\"brand\":true,\"logoFile\":\"images\\/sampledata\\/IHU_logo_blue_gr.jpg#joomlaImage:\\/\\/local-images\\/sampledata\\/IHU_logo_blue_gr.jpg?width=1132&height=354\",\"siteTitle\":\"\\u03a4\\u03bc\\u03ae\\u03bc\\u03b1 \\u0394\\u03b9\\u03bf\\u03b9\\u03ba\\u03b7\\u03c4\\u03b9\\u03ba\\u03ae\\u03c2 \\u0395\\u03c0\\u03b9\\u03c3\\u03c4\\u03ae\\u03bc\\u03b7\\u03c2 & \\u03a4\\u03b5\\u03c7\\u03bd\\u03bf\\u03bb\\u03bf\\u03b3\\u03af\\u03b1\\u03c2\",\"siteDescription\":\"\\u03a4\\u03bc\\u03ae\\u03bc\\u03b1 \\u0394\\u03b9\\u03bf\\u03b9\\u03ba\\u03b7\\u03c4\\u03b9\\u03ba\\u03ae\\u03c2 \\u0395\\u03c0\\u03b9\\u03c3\\u03c4\\u03ae\\u03bc\\u03b7\\u03c2 & \\u03a4\\u03b5\\u03c7\\u03bd\\u03bf\\u03bb\\u03bf\\u03b3\\u03af\\u03b1\\u03c2\",\"useFontScheme\":\"0\",\"colorName\":\"colors_standard\",\"fluidContainer\":\"0\",\"stickyHeader\":0,\"backTop\":0}');

--
-- Table structure for table `l0eco_ucm_base`
--

CREATE TABLE `l0eco_ucm_base` (
  `ucm_id` int(10) unsigned NOT NULL,
  `ucm_item_id` int(11) NOT NULL,
  `ucm_type_id` int(11) NOT NULL,
  `ucm_language_id` int(11) NOT NULL,
  PRIMARY KEY (`ucm_id`),
  KEY `idx_ucm_item_id` (`ucm_item_id`),
  KEY `idx_ucm_type_id` (`ucm_type_id`),
  KEY `idx_ucm_language_id` (`ucm_language_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `l0eco_ucm_base`
--


--
-- Table structure for table `l0eco_ucm_content`
--

CREATE TABLE `l0eco_ucm_content` (
  `core_content_id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `core_type_alias` varchar(400) NOT NULL DEFAULT '' COMMENT 'FK to the content types table',
  `core_title` varchar(400) NOT NULL DEFAULT '',
  `core_alias` varchar(400) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin NOT NULL DEFAULT '',
  `core_body` mediumtext DEFAULT NULL,
  `core_state` tinyint(4) NOT NULL DEFAULT 0,
  `core_checked_out_time` datetime DEFAULT NULL,
  `core_checked_out_user_id` int(10) unsigned DEFAULT NULL,
  `core_access` int(10) unsigned NOT NULL DEFAULT 0,
  `core_params` text DEFAULT NULL,
  `core_featured` tinyint(3) unsigned NOT NULL DEFAULT 0,
  `core_metadata` varchar(2048) NOT NULL DEFAULT '' COMMENT 'JSON encoded metadata properties.',
  `core_created_user_id` int(10) unsigned NOT NULL DEFAULT 0,
  `core_created_by_alias` varchar(255) NOT NULL DEFAULT '',
  `core_created_time` datetime NOT NULL,
  `core_modified_user_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Most recent user that modified',
  `core_modified_time` datetime NOT NULL,
  `core_language` char(7) NOT NULL DEFAULT '',
  `core_publish_up` datetime DEFAULT NULL,
  `core_publish_down` datetime DEFAULT NULL,
  `core_content_item_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'ID from the individual type table',
  `asset_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'FK to the #__assets table.',
  `core_images` text DEFAULT NULL,
  `core_urls` text DEFAULT NULL,
  `core_hits` int(10) unsigned NOT NULL DEFAULT 0,
  `core_version` int(10) unsigned NOT NULL DEFAULT 1,
  `core_ordering` int(11) NOT NULL DEFAULT 0,
  `core_metakey` text DEFAULT NULL,
  `core_metadesc` text DEFAULT NULL,
  `core_catid` int(10) unsigned NOT NULL DEFAULT 0,
  `core_type_id` int(10) unsigned NOT NULL DEFAULT 0,
  PRIMARY KEY (`core_content_id`),
  KEY `tag_idx` (`core_state`,`core_access`),
  KEY `idx_access` (`core_access`),
  KEY `idx_alias` (`core_alias`(100)),
  KEY `idx_language` (`core_language`),
  KEY `idx_title` (`core_title`(100)),
  KEY `idx_modified_time` (`core_modified_time`),
  KEY `idx_created_time` (`core_created_time`),
  KEY `idx_content_type` (`core_type_alias`(100)),
  KEY `idx_core_modified_user_id` (`core_modified_user_id`),
  KEY `idx_core_checked_out_user_id` (`core_checked_out_user_id`),
  KEY `idx_core_created_user_id` (`core_created_user_id`),
  KEY `idx_core_type_id` (`core_type_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Contains core content data in name spaced fields';

--
-- Dumping data for table `l0eco_ucm_content`
--


--
-- Table structure for table `l0eco_update_sites`
--

CREATE TABLE `l0eco_update_sites` (
  `update_site_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT '',
  `type` varchar(20) DEFAULT '',
  `location` text NOT NULL,
  `enabled` int(11) DEFAULT 0,
  `last_check_timestamp` bigint(20) DEFAULT 0,
  `extra_query` varchar(1000) DEFAULT '',
  `checked_out` int(10) unsigned DEFAULT NULL,
  `checked_out_time` datetime DEFAULT NULL,
  PRIMARY KEY (`update_site_id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Update Sites';

--
-- Dumping data for table `l0eco_update_sites`
--

INSERT INTO `l0eco_update_sites` VALUES (1,'Joomla! Core','collection','https://update.joomla.org/core/list.xml',1,1675004619,'',NULL,NULL),(2,'Accredited Joomla! Translations','collection','https://update.joomla.org/language/translationlist_4.xml',1,1674898433,'',NULL,NULL),(3,'Joomla! Update Component','extension','https://update.joomla.org/core/extensions/com_joomlaupdate.xml',1,1674898493,'',NULL,NULL);

--
-- Table structure for table `l0eco_update_sites_extensions`
--

CREATE TABLE `l0eco_update_sites_extensions` (
  `update_site_id` int(11) NOT NULL DEFAULT 0,
  `extension_id` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`update_site_id`,`extension_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Links extensions to update sites';

--
-- Dumping data for table `l0eco_update_sites_extensions`
--

INSERT INTO `l0eco_update_sites_extensions` VALUES (1,224),(2,225),(2,232),(3,24);

--
-- Table structure for table `l0eco_updates`
--

CREATE TABLE `l0eco_updates` (
  `update_id` int(11) NOT NULL AUTO_INCREMENT,
  `update_site_id` int(11) DEFAULT 0,
  `extension_id` int(11) DEFAULT 0,
  `name` varchar(100) DEFAULT '',
  `description` text NOT NULL,
  `element` varchar(100) DEFAULT '',
  `type` varchar(20) DEFAULT '',
  `folder` varchar(20) DEFAULT '',
  `client_id` tinyint(4) DEFAULT 0,
  `version` varchar(32) DEFAULT '',
  `data` text NOT NULL,
  `detailsurl` text NOT NULL,
  `infourl` text NOT NULL,
  `changelogurl` text DEFAULT NULL,
  `extra_query` varchar(1000) DEFAULT '',
  PRIMARY KEY (`update_id`)
) ENGINE=InnoDB AUTO_INCREMENT=50 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Available Updates';

--
-- Dumping data for table `l0eco_updates`
--

INSERT INTO `l0eco_updates` VALUES (1,2,0,'Afrikaans','','pkg_af-ZA','package','',0,'4.2.6.1','','https://update.joomla.org/language/details4/af-ZA_details.xml','','',''),(2,2,0,'Arabic Unitag','','pkg_ar-AA','package','',0,'4.0.2.1','','https://update.joomla.org/language/details4/ar-AA_details.xml','','',''),(3,2,0,'Bulgarian','','pkg_bg-BG','package','',0,'4.1.5.1','','https://update.joomla.org/language/details4/bg-BG_details.xml','','',''),(4,2,0,'Catalan','','pkg_ca-ES','package','',0,'4.0.4.2','','https://update.joomla.org/language/details4/ca-ES_details.xml','','',''),(5,2,0,'Chinese, Simplified','','pkg_zh-CN','package','',0,'4.2.0.1','','https://update.joomla.org/language/details4/zh-CN_details.xml','','',''),(6,2,0,'Chinese, Traditional','','pkg_zh-TW','package','',0,'4.2.3.1','','https://update.joomla.org/language/details4/zh-TW_details.xml','','',''),(7,2,0,'Czech','','pkg_cs-CZ','package','',0,'4.2.0.1','','https://update.joomla.org/language/details4/cs-CZ_details.xml','','',''),(8,2,0,'Danish','','pkg_da-DK','package','',0,'4.2.6.1','','https://update.joomla.org/language/details4/da-DK_details.xml','','',''),(9,2,0,'Dutch','','pkg_nl-NL','package','',0,'4.2.6.1','','https://update.joomla.org/language/details4/nl-NL_details.xml','','',''),(10,2,0,'English, Australia','','pkg_en-AU','package','',0,'4.2.2.3','','https://update.joomla.org/language/details4/en-AU_details.xml','','',''),(11,2,0,'English, Canada','','pkg_en-CA','package','',0,'4.2.2.2','','https://update.joomla.org/language/details4/en-CA_details.xml','','',''),(12,2,0,'English, New Zealand','','pkg_en-NZ','package','',0,'4.2.2.2','','https://update.joomla.org/language/details4/en-NZ_details.xml','','',''),(13,2,0,'English, USA','','pkg_en-US','package','',0,'4.2.2.2','','https://update.joomla.org/language/details4/en-US_details.xml','','',''),(14,2,0,'Estonian','','pkg_et-EE','package','',0,'4.2.7.3','','https://update.joomla.org/language/details4/et-EE_details.xml','','',''),(15,2,0,'Finnish','','pkg_fi-FI','package','',0,'4.1.1.2','','https://update.joomla.org/language/details4/fi-FI_details.xml','','',''),(16,2,0,'Flemish','','pkg_nl-BE','package','',0,'4.2.6.1','','https://update.joomla.org/language/details4/nl-BE_details.xml','','',''),(17,2,0,'French','','pkg_fr-FR','package','',0,'4.2.6.1','','https://update.joomla.org/language/details4/fr-FR_details.xml','','',''),(18,2,0,'Georgian','','pkg_ka-GE','package','',0,'4.2.6.1','','https://update.joomla.org/language/details4/ka-GE_details.xml','','',''),(19,2,0,'German','','pkg_de-DE','package','',0,'4.2.6.1','','https://update.joomla.org/language/details4/de-DE_details.xml','','',''),(20,2,0,'German, Austria','','pkg_de-AT','package','',0,'4.2.6.1','','https://update.joomla.org/language/details4/de-AT_details.xml','','',''),(21,2,0,'German, Liechtenstein','','pkg_de-LI','package','',0,'4.2.6.1','','https://update.joomla.org/language/details4/de-LI_details.xml','','',''),(22,2,0,'German, Luxembourg','','pkg_de-LU','package','',0,'4.2.6.1','','https://update.joomla.org/language/details4/de-LU_details.xml','','',''),(23,2,0,'German, Switzerland','','pkg_de-CH','package','',0,'4.2.6.1','','https://update.joomla.org/language/details4/de-CH_details.xml','','',''),(25,2,0,'Hungarian','','pkg_hu-HU','package','',0,'4.2.4.1','','https://update.joomla.org/language/details4/hu-HU_details.xml','','',''),(26,2,0,'Italian','','pkg_it-IT','package','',0,'4.2.6.3','','https://update.joomla.org/language/details4/it-IT_details.xml','','',''),(27,2,0,'Japanese','','pkg_ja-JP','package','',0,'4.2.6.1','','https://update.joomla.org/language/details4/ja-JP_details.xml','','',''),(28,2,0,'Kazakh','','pkg_kk-KZ','package','',0,'4.1.2.1','','https://update.joomla.org/language/details4/kk-KZ_details.xml','','',''),(29,2,0,'Lithuanian','','pkg_lt-LT','package','',0,'4.2.6.1','','https://update.joomla.org/language/details4/lt-LT_details.xml','','',''),(30,2,0,'Macedonian','','pkg_mk-MK','package','',0,'4.2.4.1','','https://update.joomla.org/language/details4/mk-MK_details.xml','','',''),(31,2,0,'Norwegian Bokmål','','pkg_nb-NO','package','',0,'4.0.1.1','','https://update.joomla.org/language/details4/nb-NO_details.xml','','',''),(32,2,0,'Persian Farsi','','pkg_fa-IR','package','',0,'4.2.6.1','','https://update.joomla.org/language/details4/fa-IR_details.xml','','',''),(33,2,0,'Polish','','pkg_pl-PL','package','',0,'4.2.2.4','','https://update.joomla.org/language/details4/pl-PL_details.xml','','',''),(34,2,0,'Portuguese, Brazil','','pkg_pt-BR','package','',0,'4.0.3.1','','https://update.joomla.org/language/details4/pt-BR_details.xml','','',''),(35,2,0,'Portuguese, Portugal','','pkg_pt-PT','package','',0,'4.0.0-rc4.2','','https://update.joomla.org/language/details4/pt-PT_details.xml','','',''),(36,2,0,'Romanian','','pkg_ro-RO','package','',0,'4.2.1.1','','https://update.joomla.org/language/details4/ro-RO_details.xml','','',''),(37,2,0,'Russian','','pkg_ru-RU','package','',0,'4.2.5.1','','https://update.joomla.org/language/details4/ru-RU_details.xml','','',''),(38,2,0,'Serbian, Cyrillic','','pkg_sr-RS','package','',0,'4.2.7.1','','https://update.joomla.org/language/details4/sr-RS_details.xml','','',''),(39,2,0,'Serbian, Latin','','pkg_sr-YU','package','',0,'4.2.5.1','','https://update.joomla.org/language/details4/sr-YU_details.xml','','',''),(40,2,0,'Slovak','','pkg_sk-SK','package','',0,'4.0.6.1','','https://update.joomla.org/language/details4/sk-SK_details.xml','','',''),(41,2,0,'Slovenian','','pkg_sl-SI','package','',0,'4.2.6.1','','https://update.joomla.org/language/details4/sl-SI_details.xml','','',''),(42,2,0,'Spanish','','pkg_es-ES','package','',0,'4.2.3.1','','https://update.joomla.org/language/details4/es-ES_details.xml','','',''),(43,2,0,'Swedish','','pkg_sv-SE','package','',0,'4.2.6.1','','https://update.joomla.org/language/details4/sv-SE_details.xml','','',''),(44,2,0,'Tamil, India','','pkg_ta-IN','package','',0,'4.2.6.1','','https://update.joomla.org/language/details4/ta-IN_details.xml','','',''),(45,2,0,'Thai','','pkg_th-TH','package','',0,'4.2.6.1','','https://update.joomla.org/language/details4/th-TH_details.xml','','',''),(46,2,0,'Turkish','','pkg_tr-TR','package','',0,'4.2.6.1','','https://update.joomla.org/language/details4/tr-TR_details.xml','','',''),(47,2,0,'Ukrainian','','pkg_uk-UA','package','',0,'4.2.5.1','','https://update.joomla.org/language/details4/uk-UA_details.xml','','',''),(48,2,0,'Vietnamese','','pkg_vi-VN','package','',0,'4.2.2.1','','https://update.joomla.org/language/details4/vi-VN_details.xml','','',''),(49,2,0,'Welsh','','pkg_cy-GB','package','',0,'4.2.6.1','','https://update.joomla.org/language/details4/cy-GB_details.xml','','','');

--
-- Table structure for table `l0eco_user_keys`
--

CREATE TABLE `l0eco_user_keys` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` varchar(150) NOT NULL,
  `token` varchar(255) NOT NULL,
  `series` varchar(191) NOT NULL,
  `time` varchar(200) NOT NULL,
  `uastring` varchar(255) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `series` (`series`),
  KEY `user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `l0eco_user_keys`
--


--
-- Table structure for table `l0eco_user_mfa`
--

CREATE TABLE `l0eco_user_mfa` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL,
  `title` varchar(255) NOT NULL DEFAULT '',
  `method` varchar(100) NOT NULL,
  `default` tinyint(4) NOT NULL DEFAULT 0,
  `options` mediumtext NOT NULL,
  `created_on` datetime NOT NULL,
  `last_used` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_user_id` (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Multi-factor Authentication settings';

--
-- Dumping data for table `l0eco_user_mfa`
--


--
-- Table structure for table `l0eco_user_notes`
--

CREATE TABLE `l0eco_user_notes` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `user_id` int(10) unsigned NOT NULL DEFAULT 0,
  `catid` int(10) unsigned NOT NULL DEFAULT 0,
  `subject` varchar(100) NOT NULL DEFAULT '',
  `body` text NOT NULL,
  `state` tinyint(4) NOT NULL DEFAULT 0,
  `checked_out` int(10) unsigned DEFAULT NULL,
  `checked_out_time` datetime DEFAULT NULL,
  `created_user_id` int(10) unsigned NOT NULL DEFAULT 0,
  `created_time` datetime NOT NULL,
  `modified_user_id` int(10) unsigned NOT NULL DEFAULT 0,
  `modified_time` datetime NOT NULL,
  `review_time` datetime DEFAULT NULL,
  `publish_up` datetime DEFAULT NULL,
  `publish_down` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_user_id` (`user_id`),
  KEY `idx_category_id` (`catid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `l0eco_user_notes`
--


--
-- Table structure for table `l0eco_user_profiles`
--

CREATE TABLE `l0eco_user_profiles` (
  `user_id` int(11) NOT NULL,
  `profile_key` varchar(100) NOT NULL,
  `profile_value` text NOT NULL,
  `ordering` int(11) NOT NULL DEFAULT 0,
  UNIQUE KEY `idx_user_id_profile_key` (`user_id`,`profile_key`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci COMMENT='Simple user profile storage table';

--
-- Dumping data for table `l0eco_user_profiles`
--


--
-- Table structure for table `l0eco_user_usergroup_map`
--

CREATE TABLE `l0eco_user_usergroup_map` (
  `user_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Foreign Key to #__users.id',
  `group_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Foreign Key to #__usergroups.id',
  PRIMARY KEY (`user_id`,`group_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `l0eco_user_usergroup_map`
--

INSERT INTO `l0eco_user_usergroup_map` VALUES (179,8);

--
-- Table structure for table `l0eco_usergroups`
--

CREATE TABLE `l0eco_usergroups` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary Key',
  `parent_id` int(10) unsigned NOT NULL DEFAULT 0 COMMENT 'Adjacency List Reference Id',
  `lft` int(11) NOT NULL DEFAULT 0 COMMENT 'Nested set lft.',
  `rgt` int(11) NOT NULL DEFAULT 0 COMMENT 'Nested set rgt.',
  `title` varchar(100) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_usergroup_parent_title_lookup` (`parent_id`,`title`),
  KEY `idx_usergroup_title_lookup` (`title`),
  KEY `idx_usergroup_adjacency_lookup` (`parent_id`),
  KEY `idx_usergroup_nested_set_lookup` (`lft`,`rgt`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `l0eco_usergroups`
--

INSERT INTO `l0eco_usergroups` VALUES (1,0,1,18,'Public'),(2,1,8,15,'Registered'),(3,2,9,14,'Author'),(4,3,10,13,'Editor'),(5,4,11,12,'Publisher'),(6,1,4,7,'Manager'),(7,6,5,6,'Administrator'),(8,1,16,17,'Super Users'),(9,1,2,3,'Guest');

--
-- Table structure for table `l0eco_users`
--

CREATE TABLE `l0eco_users` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(400) NOT NULL DEFAULT '',
  `username` varchar(150) NOT NULL DEFAULT '',
  `email` varchar(100) NOT NULL DEFAULT '',
  `password` varchar(100) NOT NULL DEFAULT '',
  `block` tinyint(4) NOT NULL DEFAULT 0,
  `sendEmail` tinyint(4) DEFAULT 0,
  `registerDate` datetime NOT NULL,
  `lastvisitDate` datetime DEFAULT NULL,
  `activation` varchar(100) NOT NULL DEFAULT '',
  `params` text NOT NULL,
  `lastResetTime` datetime DEFAULT NULL COMMENT 'Date of last password reset',
  `resetCount` int(11) NOT NULL DEFAULT 0 COMMENT 'Count of password resets since lastResetTime',
  `otpKey` varchar(1000) NOT NULL DEFAULT '' COMMENT 'Two factor authentication encrypted keys',
  `otep` varchar(1000) NOT NULL DEFAULT '' COMMENT 'Backup Codes',
  `requireReset` tinyint(4) NOT NULL DEFAULT 0 COMMENT 'Require user to reset password on next login',
  `authProvider` varchar(100) NOT NULL DEFAULT '' COMMENT 'Name of used authentication plugin',
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_username` (`username`),
  KEY `idx_name` (`name`(100)),
  KEY `idx_block` (`block`),
  KEY `email` (`email`)
) ENGINE=InnoDB AUTO_INCREMENT=180 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `l0eco_users`
--

INSERT INTO `l0eco_users` VALUES (179,'Λεωνίδας Φραγγίδης','admin','fragidis@mst.ihu.gr','$2y$10$XZN57pPXa.93ecEWboYRGey8c.4o9VJafYpqovMW0ejwF8Sw6GeQ2',0,1,'2023-01-28 09:33:52','2023-01-29 15:12:09','0','',NULL,0,'','',0,'');

--
-- Table structure for table `l0eco_viewlevels`
--

CREATE TABLE `l0eco_viewlevels` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT COMMENT 'Primary Key',
  `title` varchar(100) NOT NULL DEFAULT '',
  `ordering` int(11) NOT NULL DEFAULT 0,
  `rules` varchar(5120) NOT NULL COMMENT 'JSON encoded access control.',
  PRIMARY KEY (`id`),
  UNIQUE KEY `idx_assetgroup_title_lookup` (`title`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `l0eco_viewlevels`
--

INSERT INTO `l0eco_viewlevels` VALUES (1,'Public',0,'[1]'),(2,'Registered',2,'[6,2,8]'),(3,'Special',3,'[6,3,8]'),(5,'Guest',1,'[9]'),(6,'Super Users',4,'[8]');

--
-- Table structure for table `l0eco_webauthn_credentials`
--

CREATE TABLE `l0eco_webauthn_credentials` (
  `id` varchar(1000) NOT NULL COMMENT 'Credential ID',
  `user_id` varchar(128) NOT NULL COMMENT 'User handle',
  `label` varchar(190) NOT NULL COMMENT 'Human readable label',
  `credential` mediumtext NOT NULL COMMENT 'Credential source data, JSON format',
  PRIMARY KEY (`id`(100)),
  KEY `user_id` (`user_id`(100))
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `l0eco_webauthn_credentials`
--


--
-- Table structure for table `l0eco_workflow_associations`
--

CREATE TABLE `l0eco_workflow_associations` (
  `item_id` int(11) NOT NULL DEFAULT 0 COMMENT 'Extension table id value',
  `stage_id` int(11) NOT NULL COMMENT 'Foreign Key to #__workflow_stages.id',
  `extension` varchar(50) NOT NULL,
  PRIMARY KEY (`item_id`,`extension`),
  KEY `idx_item_stage_extension` (`item_id`,`stage_id`,`extension`),
  KEY `idx_item_id` (`item_id`),
  KEY `idx_stage_id` (`stage_id`),
  KEY `idx_extension` (`extension`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `l0eco_workflow_associations`
--

INSERT INTO `l0eco_workflow_associations` VALUES (1,1,'com_content.article'),(2,1,'com_content.article');

--
-- Table structure for table `l0eco_workflow_stages`
--

CREATE TABLE `l0eco_workflow_stages` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `asset_id` int(11) DEFAULT 0,
  `ordering` int(11) NOT NULL DEFAULT 0,
  `workflow_id` int(11) NOT NULL,
  `published` tinyint(4) NOT NULL DEFAULT 0,
  `title` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `default` tinyint(4) NOT NULL DEFAULT 0,
  `checked_out_time` datetime DEFAULT NULL,
  `checked_out` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_workflow_id` (`workflow_id`),
  KEY `idx_checked_out` (`checked_out`),
  KEY `idx_title` (`title`(191)),
  KEY `idx_asset_id` (`asset_id`),
  KEY `idx_default` (`default`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `l0eco_workflow_stages`
--

INSERT INTO `l0eco_workflow_stages` VALUES (1,57,1,1,1,'COM_WORKFLOW_BASIC_STAGE','',1,NULL,NULL);

--
-- Table structure for table `l0eco_workflow_transitions`
--

CREATE TABLE `l0eco_workflow_transitions` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `asset_id` int(11) DEFAULT 0,
  `ordering` int(11) NOT NULL DEFAULT 0,
  `workflow_id` int(11) NOT NULL,
  `published` tinyint(4) NOT NULL DEFAULT 0,
  `title` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `from_stage_id` int(11) NOT NULL,
  `to_stage_id` int(11) NOT NULL,
  `options` text NOT NULL,
  `checked_out_time` datetime DEFAULT NULL,
  `checked_out` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_title` (`title`(191)),
  KEY `idx_asset_id` (`asset_id`),
  KEY `idx_checked_out` (`checked_out`),
  KEY `idx_from_stage_id` (`from_stage_id`),
  KEY `idx_to_stage_id` (`to_stage_id`),
  KEY `idx_workflow_id` (`workflow_id`)
) ENGINE=InnoDB AUTO_INCREMENT=8 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `l0eco_workflow_transitions`
--

INSERT INTO `l0eco_workflow_transitions` VALUES (1,58,1,1,1,'UNPUBLISH','',-1,1,'{\"publishing\":\"0\"}',NULL,NULL),(2,59,2,1,1,'PUBLISH','',-1,1,'{\"publishing\":\"1\"}',NULL,NULL),(3,60,3,1,1,'TRASH','',-1,1,'{\"publishing\":\"-2\"}',NULL,NULL),(4,61,4,1,1,'ARCHIVE','',-1,1,'{\"publishing\":\"2\"}',NULL,NULL),(5,62,5,1,1,'FEATURE','',-1,1,'{\"featuring\":\"1\"}',NULL,NULL),(6,63,6,1,1,'UNFEATURE','',-1,1,'{\"featuring\":\"0\"}',NULL,NULL),(7,64,7,1,1,'PUBLISH_AND_FEATURE','',-1,1,'{\"publishing\":\"1\",\"featuring\":\"1\"}',NULL,NULL);

--
-- Table structure for table `l0eco_workflows`
--

CREATE TABLE `l0eco_workflows` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `asset_id` int(11) DEFAULT 0,
  `published` tinyint(4) NOT NULL DEFAULT 0,
  `title` varchar(255) NOT NULL,
  `description` text NOT NULL,
  `extension` varchar(50) NOT NULL,
  `default` tinyint(4) NOT NULL DEFAULT 0,
  `ordering` int(11) NOT NULL DEFAULT 0,
  `created` datetime NOT NULL,
  `created_by` int(11) NOT NULL DEFAULT 0,
  `modified` datetime NOT NULL,
  `modified_by` int(11) NOT NULL DEFAULT 0,
  `checked_out_time` datetime DEFAULT NULL,
  `checked_out` int(10) unsigned DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `idx_asset_id` (`asset_id`),
  KEY `idx_title` (`title`(191)),
  KEY `idx_extension` (`extension`),
  KEY `idx_default` (`default`),
  KEY `idx_created` (`created`),
  KEY `idx_created_by` (`created_by`),
  KEY `idx_modified` (`modified`),
  KEY `idx_modified_by` (`modified_by`),
  KEY `idx_checked_out` (`checked_out`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `l0eco_workflows`
--

INSERT INTO `l0eco_workflows` VALUES (1,56,1,'COM_WORKFLOW_BASIC_WORKFLOW','','com_content.article',1,1,'2023-01-28 09:33:51',179,'2023-01-28 09:33:51',179,NULL,NULL);

--
-- Table structure for table `masters`
--

CREATE TABLE `masters` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `parent_id` int(11) DEFAULT NULL,
  `type` varchar(50) DEFAULT NULL,
  `name` varchar(50) DEFAULT NULL,
  `code` varchar(20) DEFAULT NULL,
  `amount` double(10,2) DEFAULT NULL,
  `abbr` varchar(50) DEFAULT NULL,
  `description` text DEFAULT NULL,
  `icon` varchar(50) DEFAULT NULL,
  `image` text DEFAULT NULL,
  `images` text DEFAULT NULL,
  `file` text DEFAULT NULL,
  `order` int(11) DEFAULT NULL,
  `status` enum('Show','Hide') DEFAULT 'Show',
  `extras` text DEFAULT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `masters`
--


--
-- Table structure for table `menus`
--

CREATE TABLE `menus` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `parent_id` int(11) DEFAULT 0,
  `key` varchar(100) DEFAULT NULL,
  `url` varchar(100) DEFAULT NULL,
  `icon` varchar(100) DEFAULT NULL,
  `permission` varchar(1000) DEFAULT NULL,
  `role` varchar(1000) DEFAULT NULL,
  `name` text DEFAULT NULL,
  `description` text DEFAULT NULL,
  `target` enum('_blank','_self') DEFAULT NULL,
  `order` int(11) DEFAULT NULL,
  `uload_folder` varchar(150) DEFAULT NULL,
  `slug` varchar(200) DEFAULT NULL,
  `status` enum('Show','Hide') DEFAULT 'Show',
  `upload_folder` varchar(100) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=26 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `menus`
--

INSERT INTO `menus` VALUES (1,0,'admin','/admin',NULL,NULL,NULL,'Admin',NULL,NULL,1,NULL,NULL,'Show',NULL,NULL,NULL,NULL),(2,0,'user','/user',NULL,NULL,NULL,'User',NULL,NULL,1,NULL,NULL,'Show',NULL,NULL,NULL,NULL),(3,0,'client','/client',NULL,NULL,NULL,'Client',NULL,NULL,1,NULL,NULL,'Show',NULL,NULL,NULL,NULL),(4,0,'main','',NULL,NULL,NULL,'Main','Website main menu',NULL,2,NULL,NULL,'Show',NULL,NULL,NULL,NULL),(5,0,'footer','',NULL,NULL,NULL,'Footer','Footer menu',NULL,3,NULL,NULL,'Show',NULL,NULL,NULL,NULL),(6,0,'social','',NULL,NULL,NULL,'Social','Social media menu',NULL,3,NULL,NULL,'Show',NULL,NULL,NULL,NULL),(7,6,NULL,'https://twitter.com/lavalitecms','fab fa-twitter',NULL,NULL,'Twitter',NULL,'_blank',11,NULL,NULL,'Show',NULL,NULL,NULL,NULL),(8,6,NULL,'https://github.com/LavaLite/cms','fab fa-github',NULL,NULL,'GitHub',NULL,'_blank',12,NULL,NULL,'Show',NULL,NULL,NULL,NULL),(9,6,NULL,'https://www.facebook.com/lavalite/','fab fa-facebook-square',NULL,NULL,'Facebook',NULL,'_blank',13,NULL,NULL,'Show',NULL,NULL,NULL,NULL),(16,2,NULL,'user','dashboard',NULL,NULL,'Dashborad',NULL,NULL,50,NULL,NULL,'Show',NULL,NULL,NULL,NULL),(17,1,NULL,'admin/block/block','las la-dice',NULL,NULL,'Blocks',NULL,NULL,100,NULL,NULL,'Show',NULL,NULL,NULL,NULL),(18,1,NULL,'admin/blog/blog','las la-book-open',NULL,NULL,'Blog',NULL,NULL,190,NULL,NULL,'Show',NULL,NULL,NULL,NULL),(19,4,NULL,'blog',NULL,NULL,NULL,'Blogs',NULL,NULL,190,NULL,NULL,'Show',NULL,NULL,NULL,NULL),(20,1,NULL,'admin/contact/contact','las la-address-card',NULL,NULL,'Contact',NULL,NULL,190,NULL,NULL,'Show',NULL,NULL,NULL,NULL),(21,4,NULL,'contact.htm',NULL,NULL,NULL,'Contact',NULL,NULL,190,NULL,NULL,'Show',NULL,NULL,NULL,NULL),(22,5,NULL,'contact.htm',NULL,NULL,NULL,'Contact',NULL,NULL,190,NULL,NULL,'Show',NULL,NULL,NULL,NULL),(23,1,NULL,'admin/page/page','lab la-product-hunt',NULL,NULL,'Pages',NULL,NULL,5,NULL,NULL,'Show',NULL,NULL,NULL,NULL),(24,4,NULL,'about-us.html',NULL,NULL,NULL,'About Us',NULL,NULL,8,NULL,NULL,'Show',NULL,NULL,NULL,NULL),(25,5,NULL,'about-us.html',NULL,NULL,NULL,'About Us',NULL,NULL,8,NULL,NULL,'Show',NULL,NULL,NULL,NULL);

--
-- Table structure for table `migrations`
--

CREATE TABLE `migrations` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `migration` varchar(255) NOT NULL,
  `batch` int(11) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=39 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `migrations`
--

INSERT INTO `migrations` VALUES (20,'2015_01_05_100001_create_clients_table',1),(21,'2015_01_05_100001_create_users_table',1),(22,'2015_01_05_100010_create_password_resets_table',1),(23,'2015_08_05_100011_create_pages_table',1),(24,'2017_01_02_100001_create_contacts_table',1),(25,'2017_05_05_100001_create_menus_table',1),(26,'2017_05_23_100001_create_settings_table',1),(27,'2017_11_09_100001_create_roles_table',1),(28,'2017_11_09_100002_create_role_user_table',1),(29,'2017_11_09_100003_create_permissions_table',1),(30,'2017_11_09_100004_create_permission_user_table',1),(31,'2017_11_09_100005_create_permission_role_table',1),(32,'2018_02_05_100001_create_action_log_table',1),(33,'2018_02_05_100001_create_activity_log_table',1),(34,'2018_07_25_100001_create_masters_table',1),(35,'2019_07_10_100001_create_teams_table',1),(36,'2019_12_14_000001_create_personal_access_tokens_table',1),(37,'2021_08_07_100001_create_blocks_table',1),(38,'2021_08_23_100001_create_blogs_table',1);

--
-- Table structure for table `pages`
--

CREATE TABLE `pages` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT NULL,
  `title` text DEFAULT NULL,
  `heading` text DEFAULT NULL,
  `sub_heading` text DEFAULT NULL,
  `abstract` text DEFAULT NULL,
  `content` text DEFAULT NULL,
  `meta_title` text DEFAULT NULL,
  `meta_keyword` text DEFAULT NULL,
  `meta_description` text DEFAULT NULL,
  `banner` mediumtext DEFAULT NULL,
  `images` text DEFAULT NULL,
  `compile` tinyint(1) DEFAULT 0,
  `view` varchar(20) DEFAULT 'default',
  `category` varchar(20) DEFAULT 'default',
  `order` int(11) DEFAULT NULL,
  `slug` varchar(200) DEFAULT NULL,
  `status` enum('Show','Hide') DEFAULT 'Show',
  `upload_folder` varchar(100) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `pages`
--

INSERT INTO `pages` VALUES (1,'Home','Build, Website or Web Application!','Build, Website or Web Application!',NULL,NULL,'Create custom website for your business in Laravel. Or build a robust web application like ERP or CRM for your business that can handle many number user requests and complex business logic.','Home','Home','Home',NULL,NULL,NULL,'page','default',0,'home','Show',NULL,NULL,NULL,NULL),(2,'About Us','About Us','Meet Lavalite',NULL,NULL,'<div class=\"section-title\">\n                    <h2 class=\"title\">Our mission is to make your life beautiful.</h2>\n                    <div class=\"right-side\">\n                        <p>Lavalite (lavalite.org) is a free and open-source which can be used as a content management system (CMS), Enterprise Resource Planning (ERP) &  Customer Relationship Management (CRM) software written in Laravel and it can be pair with a wide range of databases like MySQL or MariaDB etc. Features include a package architecture and a template system.</p>\n                    </div>\n                </div>\n                <div class=\"row\">\n                    <div class=\"col-lg-4 col-md-5\">\n                        <div class=\"content-img\">\n                            <img src=\"/assets/img/easy-image-2-1.png\" class=\"img-fluid\" alt=\"\">\n                        </div>\n                    </div>\n                    <div class=\"col-lg-8 col-md-7\">\n                        <div class=\"content-img\">\n                            <img src=\"/assets/img/easy-image-2-2.png\" class=\"img-fluid\" alt=\"\">\n                        </div>\n                    </div>\n                </div>','About Us','About Us','This is a started theme for Lavalite cms, you can customize according to your requirement.',NULL,NULL,NULL,'page','default',0,'about-us','Show',NULL,NULL,NULL,NULL),(3,'Contact Us','Contact Us','Contact Us',NULL,NULL,'<p><br></p>','Contact Us','Contact Us','Contact Us',NULL,NULL,NULL,'page','default',0,'contact','Show',NULL,NULL,NULL,NULL),(4,'Page Not found','Page Not found','Page Not found',NULL,NULL,'<p><br></p>','Page Not found','Page Not found','Page Not found',NULL,NULL,NULL,'page','default',0,'404','Show',NULL,NULL,NULL,NULL);

--
-- Table structure for table `password_resets`
--

CREATE TABLE `password_resets` (
  `email` varchar(128) NOT NULL,
  `token` varchar(64) NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  KEY `password_resets_email_index` (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `password_resets`
--


--
-- Table structure for table `permission_role`
--

CREATE TABLE `permission_role` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `permission_id` int(10) unsigned NOT NULL,
  `role_id` int(10) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `permission_role_permission_id_index` (`permission_id`),
  KEY `permission_role_role_id_index` (`role_id`),
  CONSTRAINT `permission_role_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
  CONSTRAINT `permission_role_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `permission_role`
--


--
-- Table structure for table `permission_user`
--

CREATE TABLE `permission_user` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `permission_id` int(10) unsigned NOT NULL,
  `user_id` int(10) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `permission_user_permission_id_index` (`permission_id`),
  KEY `permission_user_user_id_index` (`user_id`),
  CONSTRAINT `permission_user_permission_id_foreign` FOREIGN KEY (`permission_id`) REFERENCES `permissions` (`id`) ON DELETE CASCADE,
  CONSTRAINT `permission_user_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `permission_user`
--


--
-- Table structure for table `permissions`
--

CREATE TABLE `permissions` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `permissions`
--

INSERT INTO `permissions` VALUES (1,'View Block','block.block.view',NULL,NULL,NULL,NULL),(2,'Create Block','block.block.create',NULL,NULL,NULL,NULL),(3,'Update Block','block.block.edit',NULL,NULL,NULL,NULL),(4,'Delete Block','block.block.delete',NULL,NULL,NULL,NULL),(5,'View Blog','blog.blog.view',NULL,NULL,NULL,NULL),(6,'Create Blog','blog.blog.create',NULL,NULL,NULL,NULL),(7,'Update Blog','blog.blog.edit',NULL,NULL,NULL,NULL),(8,'Delete Blog','blog.blog.delete',NULL,NULL,NULL,NULL),(9,'View Contact','contact.contact.view',NULL,NULL,NULL,NULL),(10,'Create Contact','contact.contact.create',NULL,NULL,NULL,NULL),(11,'Update Contact','contact.contact.edit',NULL,NULL,NULL,NULL),(12,'Delete Contact','contact.contact.delete',NULL,NULL,NULL,NULL),(13,'View Page','page.page.view',NULL,NULL,NULL,NULL),(14,'Create Page','page.page.create',NULL,NULL,NULL,NULL),(15,'Update Page','page.page.edit',NULL,NULL,NULL,NULL),(16,'Delete Page','page.page.delete',NULL,NULL,NULL,NULL);

--
-- Table structure for table `personal_access_tokens`
--

CREATE TABLE `personal_access_tokens` (
  `id` bigint(20) unsigned NOT NULL AUTO_INCREMENT,
  `tokenable_type` varchar(255) NOT NULL,
  `tokenable_id` bigint(20) unsigned NOT NULL,
  `name` varchar(255) NOT NULL,
  `token` varchar(64) NOT NULL,
  `abilities` text DEFAULT NULL,
  `last_used_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `personal_access_tokens_token_unique` (`token`),
  KEY `personal_access_tokens_tokenable_type_tokenable_id_index` (`tokenable_type`,`tokenable_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `personal_access_tokens`
--


--
-- Table structure for table `role_user`
--

CREATE TABLE `role_user` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `role_id` int(10) unsigned NOT NULL,
  `user_id` int(10) unsigned NOT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `role_user_role_id_index` (`role_id`),
  KEY `role_user_user_id_index` (`user_id`),
  CONSTRAINT `role_user_role_id_foreign` FOREIGN KEY (`role_id`) REFERENCES `roles` (`id`),
  CONSTRAINT `role_user_user_id_foreign` FOREIGN KEY (`user_id`) REFERENCES `users` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `role_user`
--

INSERT INTO `role_user` VALUES (1,1,1,NULL,NULL),(2,2,1,NULL,NULL),(3,3,2,NULL,NULL);

--
-- Table structure for table `roles`
--

CREATE TABLE `roles` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `slug` varchar(255) DEFAULT NULL,
  `description` varchar(255) DEFAULT NULL,
  `level` int(11) NOT NULL DEFAULT 1,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `roles`
--

INSERT INTO `roles` VALUES (1,'Super User','superuser',NULL,1,NULL,NULL,NULL),(2,'Admin','admin',NULL,1,NULL,NULL,NULL),(3,'User','user',NULL,1,NULL,NULL,NULL),(4,'Client','client',NULL,1,NULL,NULL,NULL);

--
-- Table structure for table `settings`
--

CREATE TABLE `settings` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `key` varchar(255) DEFAULT NULL,
  `package` varchar(255) DEFAULT NULL,
  `module` varchar(255) DEFAULT NULL,
  `name` varchar(100) DEFAULT NULL,
  `value` varchar(255) DEFAULT NULL,
  `file` varchar(500) DEFAULT NULL,
  `control` varchar(255) DEFAULT 'text',
  `type` enum('System','Default','User') DEFAULT NULL,
  `slug` varchar(200) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `user_type` varchar(50) DEFAULT NULL,
  `upload_folder` varchar(100) DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `settings`
--

INSERT INTO `settings` VALUES (1,'main.company.name','Main','Company','Company name','Lavalite',NULL,'text',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(2,'main.company.address','Main','Company','Company address','3481 Melrose Place <br>\nBeverly Hills, CA 90210',NULL,'textarea',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(3,'main.company.email','Main','Company','Company address','info@lavalite.org',NULL,'email',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL),(4,'main.company.logo','Main','Company','Company logo','img/logo.png',NULL,'file',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL);

--
-- Table structure for table `team_user`
--

CREATE TABLE `team_user` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `team_id` int(11) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  `role` enum('Admin','Manager','User') DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `team_user`
--


--
-- Table structure for table `teams`
--

CREATE TABLE `teams` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `name` text DEFAULT NULL,
  `status` text DEFAULT NULL,
  `deleted_at` timestamp NULL DEFAULT NULL,
  `created_at` timestamp NULL DEFAULT NULL,
  `updated_at` timestamp NULL DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `teams`
--

INSERT INTO `teams` VALUES (1,'Default','Active',NULL,NULL,NULL);

--
-- Table structure for table `txttextpattern`
--

CREATE TABLE `txttextpattern` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `Posted` datetime NOT NULL,
  `Expires` datetime DEFAULT NULL,
  `AuthorID` varchar(64) NOT NULL DEFAULT '',
  `LastMod` datetime NOT NULL,
  `LastModID` varchar(64) NOT NULL DEFAULT '',
  `Title` varchar(255) NOT NULL DEFAULT '',
  `Title_html` varchar(255) NOT NULL DEFAULT '',
  `Body` mediumtext NOT NULL,
  `Body_html` mediumtext NOT NULL,
  `Excerpt` text NOT NULL,
  `Excerpt_html` mediumtext NOT NULL,
  `Image` varchar(255) NOT NULL DEFAULT '',
  `Category1` varchar(64) NOT NULL DEFAULT '',
  `Category2` varchar(64) NOT NULL DEFAULT '',
  `Annotate` int(11) NOT NULL DEFAULT 0,
  `AnnotateInvite` varchar(255) NOT NULL DEFAULT '',
  `comments_count` int(11) NOT NULL DEFAULT 0,
  `Status` int(11) NOT NULL DEFAULT 4,
  `textile_body` varchar(32) NOT NULL DEFAULT '1',
  `textile_excerpt` varchar(32) NOT NULL DEFAULT '1',
  `Section` varchar(255) NOT NULL DEFAULT '',
  `override_form` varchar(255) NOT NULL DEFAULT '',
  `Keywords` varchar(255) NOT NULL DEFAULT '',
  `description` varchar(255) NOT NULL DEFAULT '',
  `url_title` varchar(255) NOT NULL DEFAULT '',
  `custom_1` varchar(255) NOT NULL DEFAULT '',
  `custom_2` varchar(255) NOT NULL DEFAULT '',
  `custom_3` varchar(255) NOT NULL DEFAULT '',
  `custom_4` varchar(255) NOT NULL DEFAULT '',
  `custom_5` varchar(255) NOT NULL DEFAULT '',
  `custom_6` varchar(255) NOT NULL DEFAULT '',
  `custom_7` varchar(255) NOT NULL DEFAULT '',
  `custom_8` varchar(255) NOT NULL DEFAULT '',
  `custom_9` varchar(255) NOT NULL DEFAULT '',
  `custom_10` varchar(255) NOT NULL DEFAULT '',
  `uid` varchar(32) NOT NULL DEFAULT '',
  `feed_time` date NOT NULL,
  PRIMARY KEY (`ID`),
  KEY `categories_idx` (`Category1`(10),`Category2`(10)),
  KEY `Posted` (`Posted`),
  KEY `Expires_idx` (`Expires`),
  KEY `author_idx` (`AuthorID`),
  KEY `section_status_idx` (`Section`(249),`Status`),
  KEY `url_title_idx` (`url_title`(250)),
  FULLTEXT KEY `searching` (`Title`,`Body`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `txttextpattern`
--

INSERT INTO `txttextpattern` VALUES (1,'2023-01-30 20:20:02',NULL,'elfotop1','2023-01-30 20:20:02','','Welcome to your site','','h3. What do you want to do next?\n\n* Write a \"new article\"://lab.mst.ihu.gr/dm/elfotop1/textpattern/textpattern/index.php?event=article? Let your creativity flow!\n* Change this site\'s name, slogan or select a different article URL style? Check and modify your \"preferences\"://lab.mst.ihu.gr/dm/elfotop1/textpattern/textpattern/index.php?event=prefs.\n* Edit or delete this article? Your \"articles\"://lab.mst.ihu.gr/dm/elfotop1/textpattern/textpattern/index.php?event=list list is the place to start.\n* Upload \"images\"://lab.mst.ihu.gr/dm/elfotop1/textpattern/textpattern/index.php?event=image or \"files\"://lab.mst.ihu.gr/dm/elfotop1/textpattern/textpattern/index.php?event=file to accompany your articles?\n* Learn Textile, the markup generator included with Textpattern? You can try it in the \"Textile sandbox\":https://textpattern.com/textile-sandbox.\n** If you want to learn more, you can refer to an extensive \"Textile manual\":https://textpattern.com/textile-reference-manual.\n* Be guided through your \"Textpattern first steps\":https://textpattern.com/textpattern-first-steps by completing some tasks?\n* Study the \"Textpattern Semantic Model\":https://textpattern.com/textpattern-semantic-model?\n* Add one or more additional \"users\"://lab.mst.ihu.gr/dm/elfotop1/textpattern/textpattern/index.php?event=admin, or extend Textpattern\'s capabilities with \"plugins\"://lab.mst.ihu.gr/dm/elfotop1/textpattern/textpattern/index.php?event=plugin from the \"Textpattern plugin directory\":https://textpattern.com/plugins?\n* Dive in and learn by doing? Please note:\n** When you write an article you assign it to a \"section\"://lab.mst.ihu.gr/dm/elfotop1/textpattern/textpattern/index.php?event=section of your site.\n** Sections use a \"page\"://lab.mst.ihu.gr/dm/elfotop1/textpattern/textpattern/index.php?event=page template and a \"style\"://lab.mst.ihu.gr/dm/elfotop1/textpattern/textpattern/index.php?event=css to define how site content appears in a browser.\n** Page templates typically use HTML(HyperText Markup Language) and \"Textpattern tags\":https://docs.textpattern.com/tags/ (like this: @<txp:article />@) to build the output code.\n** Some Textpattern tags use \"forms\"://lab.mst.ihu.gr/dm/elfotop1/textpattern/textpattern/index.php?event=form, reusable building blocks that provide extensive control and customization over your site construction.\n** Pages, styles and forms can be packaged into \"themes\"://lab.mst.ihu.gr/dm/elfotop1/textpattern/textpattern/index.php?event=skin and assigned to one or more sections.\n\nTextpattern tags, their attributes and values are explained within the \"Textpattern User Documentation\":https://docs.textpattern.com/, where you will also find valuable examples, advice and tutorials.\n\nThere\'s also a group of friendly, helpful Textpattern users and administrators at the \"Textpattern support forum\":https://forum.textpattern.com/.\n\nAdditional language translations and corrections are welcomed. Please visit \"Textpattern language translations\":https://textpattern.com/languages for further details.\n\nThis is an <txp:permlink id=\"1\">example article</txp:permlink> included with Textpattern to demonstrate some of the first steps you can undertake. An example comment is associated with this article. The article and comment can be safely deleted using the \"articles\"://lab.mst.ihu.gr/dm/elfotop1/textpattern/textpattern/index.php?event=list and \"comments\"://lab.mst.ihu.gr/dm/elfotop1/textpattern/textpattern/index.php?event=discuss lists.','<h3>What do you want to do next?</h3>\n\n<ul>\n	<li>Write a <a href=\"//lab.mst.ihu.gr/dm/elfotop1/textpattern/textpattern/index.php?event=article\">new article</a>? Let your creativity flow!</li>\n	<li>Change this site&#8217;s name, slogan or select a different article <span class=\"caps\">URL</span> style? Check and modify your <a href=\"//lab.mst.ihu.gr/dm/elfotop1/textpattern/textpattern/index.php?event=prefs\">preferences</a>.</li>\n	<li>Edit or delete this article? Your <a href=\"//lab.mst.ihu.gr/dm/elfotop1/textpattern/textpattern/index.php?event=list\">articles</a> list is the place to start.</li>\n	<li>Upload <a href=\"//lab.mst.ihu.gr/dm/elfotop1/textpattern/textpattern/index.php?event=image\">images</a> or <a href=\"//lab.mst.ihu.gr/dm/elfotop1/textpattern/textpattern/index.php?event=file\">files</a> to accompany your articles?</li>\n	<li>Learn Textile, the markup generator included with Textpattern? You can try it in the <a href=\"https://textpattern.com/textile-sandbox\">Textile sandbox</a>.\n	<ul>\n		<li>If you want to learn more, you can refer to an extensive <a href=\"https://textpattern.com/textile-reference-manual\">Textile manual</a>.</li>\n	</ul></li>\n	<li>Be guided through your <a href=\"https://textpattern.com/textpattern-first-steps\">Textpattern first steps</a> by completing some tasks?</li>\n	<li>Study the <a href=\"https://textpattern.com/textpattern-semantic-model\">Textpattern Semantic Model</a>?</li>\n	<li>Add one or more additional <a href=\"//lab.mst.ihu.gr/dm/elfotop1/textpattern/textpattern/index.php?event=admin\">users</a>, or extend Textpattern&#8217;s capabilities with <a href=\"//lab.mst.ihu.gr/dm/elfotop1/textpattern/textpattern/index.php?event=plugin\">plugins</a> from the <a href=\"https://textpattern.com/plugins\">Textpattern plugin directory</a>?</li>\n	<li>Dive in and learn by doing? Please note:\n	<ul>\n		<li>When you write an article you assign it to a <a href=\"//lab.mst.ihu.gr/dm/elfotop1/textpattern/textpattern/index.php?event=section\">section</a> of your site.</li>\n		<li>Sections use a <a href=\"//lab.mst.ihu.gr/dm/elfotop1/textpattern/textpattern/index.php?event=page\">page</a> template and a <a href=\"//lab.mst.ihu.gr/dm/elfotop1/textpattern/textpattern/index.php?event=css\">style</a> to define how site content appears in a browser.</li>\n		<li>Page templates typically use <abbr title=\"HyperText Markup Language\"><span class=\"caps\">HTML</span></abbr> and <a href=\"https://docs.textpattern.com/tags/\">Textpattern tags</a> (like this: <code>&lt;txp:article /&gt;</code>) to build the output code.</li>\n		<li>Some Textpattern tags use <a href=\"//lab.mst.ihu.gr/dm/elfotop1/textpattern/textpattern/index.php?event=form\">forms</a>, reusable building blocks that provide extensive control and customization over your site construction.</li>\n		<li>Pages, styles and forms can be packaged into <a href=\"//lab.mst.ihu.gr/dm/elfotop1/textpattern/textpattern/index.php?event=skin\">themes</a> and assigned to one or more sections.</li>\n	</ul></li>\n	</ul>\n\n<p>Textpattern tags, their attributes and values are explained within the <a href=\"https://docs.textpattern.com/\">Textpattern User Documentation</a>, where you will also find valuable examples, advice and tutorials.</p>\n\n<p>There&#8217;s also a group of friendly, helpful Textpattern users and administrators at the <a href=\"https://forum.textpattern.com/\">Textpattern support forum</a>.</p>\n\n<p>Additional language translations and corrections are welcomed. Please visit <a href=\"https://textpattern.com/languages\">Textpattern language translations</a> for further details.</p>\n\n<p>This is an <txp:permlink id=\"1\">example article</txp:permlink> included with Textpattern to demonstrate some of the first steps you can undertake. An example comment is associated with this article. The article and comment can be safely deleted using the <a href=\"//lab.mst.ihu.gr/dm/elfotop1/textpattern/textpattern/index.php?event=list\">articles</a> and <a href=\"//lab.mst.ihu.gr/dm/elfotop1/textpattern/textpattern/index.php?event=discuss\">comments</a> lists.</p>','This is a Textpattern article excerpt. Article excerpts are optional and can be used effectively to summarize an article\'s content, for example with Textpattern\'s built-in article syndication.','<p>This is a Textpattern article excerpt. Article excerpts are optional and can be used effectively to summarize an article&#8217;s content, for example with Textpattern&#8217;s built-in article syndication.</p>','','hope-for-the-future','meaningful-labor',1,'Comment',1,4,'1','1','articles','','','','welcome-to-your-site','','','','','','','','','','','38a452874ccb1165d56afa1c5bf622ff','2023-01-30');

--
-- Table structure for table `txttxp_category`
--

CREATE TABLE `txttxp_category` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(64) NOT NULL DEFAULT '',
  `type` varchar(64) NOT NULL DEFAULT '',
  `parent` varchar(64) NOT NULL DEFAULT '',
  `lft` int(11) NOT NULL DEFAULT 0,
  `rgt` int(11) NOT NULL DEFAULT 0,
  `title` varchar(255) NOT NULL DEFAULT '',
  `description` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `txttxp_category`
--

INSERT INTO `txttxp_category` VALUES (1,'root','article','',1,8,'root',''),(2,'root','link','',1,4,'root',''),(3,'root','image','',1,2,'root',''),(4,'root','file','',1,2,'root',''),(5,'everything-is-going-to-be-alright','article','root',2,3,'Everything is going to be alright',''),(6,'hope-for-the-future','article','root',4,5,'Hope for the future',''),(7,'meaningful-labor','article','root',6,7,'Meaningful labor',''),(8,'textpattern','link','root',2,3,'Textpattern','');

--
-- Table structure for table `txttxp_css`
--

CREATE TABLE `txttxp_css` (
  `name` varchar(255) NOT NULL,
  `css` mediumtext NOT NULL,
  `skin` varchar(63) NOT NULL DEFAULT 'default',
  `lastmod` datetime DEFAULT NULL,
  UNIQUE KEY `name_skin` (`name`(63),`skin`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `txttxp_css`
--

INSERT INTO `txttxp_css` VALUES ('default','@charset \"UTF-8\";\n/* ==========================================================================\n   Styling and layout for all media\n   ========================================================================== */\n/* Reset\n   ========================================================================== */\n/**\n * Add the correct display in IE 11 and Firefox.\n */\ndetails,\nmain {\n  display: block;\n}\n\n/**\n * Add the correct vertical alignment in Chrome, Edge, Firefox, and Opera.\n */\nprogress {\n  vertical-align: baseline;\n}\n\n/**\n * Add the correct display in all browsers.\n */\nsummary {\n  display: list-item;\n}\n\n/* Clearfix\n   ========================================================================== */\nheader::after,\nfooter::after,\nnav ul::after,\nnav ol::after,\n.container::after {\n  content: \"\";\n  display: table;\n  clear: both;\n}\n\n/* ==========================================================================\n   Styling and layout for screen media (mobile first)\n   ========================================================================== */\n@media screen {\n  /* Layout\n     ========================================================================== */\n  /**\n   * 1. Prevent adjustments of font size after orientation changes in\n   *    IE on Windows Phone and in iOS.\n   */\n  html {\n    /* 1 */\n    -webkit-text-size-adjust: 100%;\n            text-size-adjust: 100%;\n  }\n\n  /**\n   * 1. Set `body` to `relative` to allow positioning of absolute elements.\n   * 2. Remove default margin.\n   */\n  body {\n    /* 1 */\n    position: relative;\n    /* 2 */\n    margin: 0;\n    background: #f7f7f7;\n  }\n\n  /**\n   * Outer wrapper for main layouts.\n   *\n   * Example HTML:\n   *\n   * <div class=\"wrapper\">\n   *     <div class=\"container\">\n   *         Content\n   *     </div>\n   * </div>\n   */\n  .wrapper {\n    padding: 1px 0;\n    border-bottom: 1px solid #cccccc;\n    background: #ffffff;\n  }\n\n  /**\n   * Wrapper for layouts, and for site header/footer.\n   *\n   * Example HTML:\n   *\n   * <div class=\"wrapper\">\n   *     <div class=\"container\">\n   *         Content\n   *     </div>\n   * </div>\n   */\n  .site-header,\n.site-footer,\n.container {\n    width: 88%;\n    max-width: 54em;\n    margin: 0 auto;\n  }\n\n  /**\n   * Additional styling for child content within site header.\n   */\n  .site-header {\n    padding: 1em 0;\n  }\n  .site-header h2 {\n    margin: 0;\n  }\n  .site-header h3 {\n    margin: 0.5em 0 0;\n    font-family: \"PT Serif\", Constantia, \"Lucida Bright\", Lucidabright, \"Lucida Serif\", Lucida, \"DejaVu Serif\", \"Bitstream Vera Serif\", \"Liberation Serif\", Georgia, serif;\n    font-size: 1.25rem;\n    font-style: italic;\n    font-weight: normal;\n    line-height: 1.4;\n  }\n\n  /**\n   * Additional styling for child content within site footer.\n   */\n  .site-footer {\n    padding: 0.5em 0;\n  }\n\n  /**\n   * Styling for articles.\n   *\n   * 1. Prevent really, really long words in article from breaking layout.\n   */\n  .article {\n    margin-bottom: 2em;\n    /* 1 */\n    word-wrap: break-word;\n  }\n\n  /**\n   * Styling for complementary content.\n   *\n   * Initially the sidebar appears under main content, it is then repositioned\n   * with media queries at 2nd breakpoint.\n   *\n   * 1. Prevent really, really long words in article from breaking layout.\n   */\n  .complementary-content {\n    margin: 2em -6% 0;\n    padding: 0 6%;\n    border-top: 2px dashed #cccccc;\n    /* 1 */\n    word-wrap: break-word;\n  }\n\n  /**\n   * Hide text but still allow screen reader access.\n   *\n   * Example HTML:\n   *\n   * <p class=\"accessibility\">\n   */\n  .accessibility {\n    position: absolute;\n    width: 1px;\n    height: 1px;\n    margin: -1px;\n    padding: 0;\n    overflow: hidden;\n    clip: rect(0 0 0 0);\n    border: 0;\n    white-space: nowrap;\n  }\n\n  /* Navigation\n     ========================================================================== */\n  /**\n   * Style mobile first version of the navigation menu. Desktop version will\n   * override some rules with extra styling at 1st breakpoint.\n   *\n   * Example HTML:\n   *\n   * <nav class=\"site-navigation\">\n   *     <div>\n   *         <ul>\n   *             <li class=\"active\"><a></li>\n   *             <li><a></li>\n   *             <li><a></li>\n   *         </ul>\n   *         <div class=\"search\">\n   *             <form>\n   *                 <input type=\"search\">\n   *             </form>\n   *        </div>\n   *    </div>\n   * </nav>\n   */\n  .site-navigation {\n    background-color: #dddddd;\n  }\n  .site-navigation > div {\n    position: relative;\n    max-width: 54em;\n    margin: 0 auto;\n  }\n  .site-navigation ul {\n    margin: 0;\n    padding: 0;\n    border: solid #cccccc;\n    border-width: 1px 0;\n    list-style: none;\n  }\n  .site-navigation li {\n    border: solid #cccccc;\n    border-width: 1px 0;\n    background-color: #eeeeee;\n  }\n  .site-navigation li:hover {\n    background-color: #f8f8f8;\n  }\n  .site-navigation li:active {\n    background-color: lightgray;\n    box-shadow: inset 0 0.2em 0.25em rgba(0, 0, 0, 0.15);\n  }\n  .site-navigation li.active {\n    background-color: white;\n    box-shadow: none;\n  }\n  .site-navigation a {\n    display: block;\n    padding: 0.5em 6%;\n    color: #333333;\n  }\n  .site-navigation a:hover, .site-navigation a:visited {\n    color: #333333;\n    text-decoration: none;\n  }\n  .site-navigation a:active {\n    color: #1a1a1a;\n    text-decoration: none;\n  }\n\n  /**\n   * Search field in navigation.\n   */\n  .search {\n    padding: 1em 6% 0.5em;\n    background: #ffffff;\n  }\n  .search input[type=search] {\n    width: 16em;\n    height: 2.125em;\n    padding-right: 0.1875em;\n    padding-left: 2em;\n    border-radius: 0.5em;\n    background: url(\"data:image/svg+xml,%3Csvg xmlns=%27http://www.w3.org/2000/svg%27 width=%2732%27 height=%2732%27 viewBox=%270 0 32 32%27%3E%3Cg fill=%27%23333%27%3E%3Cpath d=%27M4,13c0-5,4-9,9-9c5,0,9,4,9,9c0,5-4,9-9,9C8,22,4,18,4,13z M13,19c3.3,0,6-2.7,6-6s-2.7-6-6-6s-6,2.7-6,6S9.7,19,13,19z%27/%3E%3Cpath d=%27M17.5,19l1.5-1.5l4.5,3L28,25c0,0,0,1.5-0.75,2.25S25,28,25,28l-4.5-4.5L17.5,19z%27/%3E%3C/g%3E%3C/svg%3E\") no-repeat left center;\n    background-size: 2em 2em;\n  }\n\n  /* Links\n     ========================================================================== */\n  /**\n   * 1. Specify link colour.\n   * 2. Remove default underline style from non-hover state links.\n   * 3. Interrupt the decoration line to let the shape of the text show through\n   *    in supported browsers.\n   * 4. Remove tap delay in modern browsers.\n   */\n  a {\n    /* 1 */\n    color: #004cbf;\n    /* 2 */\n    text-decoration: none;\n    /* 3 */\n    -webkit-text-decoration-skip: ink;\n            text-decoration-skip-ink: auto;\n    /* 4 */\n    touch-action: manipulation;\n  }\n  a:hover, a:active {\n    outline: 0;\n    color: #0066ff;\n    text-decoration: underline;\n  }\n  a:focus {\n    outline: 1px solid #0066ff;\n  }\n\n  /**\n   * Additional styling for `h1`-`h3` heading links.\n   *\n   * 1. Expanded CSS level 3 `text-decoration-color` property in supported\n   *    browsers, older browsers ignore this addition.\n   */\n  h1 a,\nh2 a,\nh3 a,\nh4 a,\nh5 a,\nh6 a {\n    color: #000000;\n  }\n  h1 a:hover, h1 a:active,\nh2 a:hover,\nh2 a:active,\nh3 a:hover,\nh3 a:active,\nh4 a:hover,\nh4 a:active,\nh5 a:hover,\nh5 a:active,\nh6 a:hover,\nh6 a:active {\n    color: #000000;\n    /* 1 */\n    -webkit-text-decoration-color: rgba(51, 51, 51, 0.5);\n            text-decoration-color: rgba(51, 51, 51, 0.5);\n  }\n\n  /**\n   * Paginator (prev/next) navigation links on articles/article lists.\n   *\n   * Example HTML:\n   *\n   * <nav class=\"paginator\">\n   *     <a rel=\"prev\">\n   *     <a rel=\"next\">\n   */\n  .paginator {\n    display: flex;\n    justify-content: space-between;\n  }\n\n  /**\n   * Visually hide unfocussed/inactive ‘skip links’.\n   *\n   * Example HTML:\n   *\n   * <a class=\"skip-link\">\n   */\n  .skip-link {\n    position: absolute;\n    z-index: 2;\n    top: 1px;\n    left: 1px;\n    padding: 0.25em 0.5em;\n    transform: translateY(-5em);\n    transition: transform 0.25s ease-in-out;\n    background-color: white;\n    color: #333333;\n    font-family: system-ui, -apple-system, \"Segoe UI\", Helvetica, Arial, sans-serif, \"Apple Color Emoji\", \"Segoe UI Emoji\", \"Segoe UI Symbol\";\n  }\n  .skip-link:focus, .skip-link:active {\n    transform: translateY(0);\n  }\n\n  /* Typography\n     ========================================================================== */\n  /**\n   * Establish baseline.\n   */\n  html {\n    font-size: 16px;\n    line-height: 1.5;\n  }\n\n  /**\n   * Global font and text colour.\n   */\n  body {\n    color: #333333;\n    font-family: \"PT Serif\", Constantia, \"Lucida Bright\", Lucidabright, \"Lucida Serif\", Lucida, \"DejaVu Serif\", \"Bitstream Vera Serif\", \"Liberation Serif\", Georgia, serif;\n  }\n\n  /**\n   * Sans-serif font for main navigation menu.\n   */\n  .site-navigation {\n    font-family: system-ui, -apple-system, \"Segoe UI\", Helvetica, Arial, sans-serif, \"Apple Color Emoji\", \"Segoe UI Emoji\", \"Segoe UI Symbol\";\n    font-weight: bold;\n  }\n\n  /**\n   * Harmonize size, style and vertical margin of headings.\n   */\n  h1,\nh2,\nh3,\nh4,\nh5,\nh6 {\n    clear: both;\n    color: #000000;\n    font-family: system-ui, -apple-system, \"Segoe UI\", Helvetica, Arial, sans-serif, \"Apple Color Emoji\", \"Segoe UI Emoji\", \"Segoe UI Symbol\";\n  }\n\n  h1 {\n    margin: 0.6315789em 0;\n    font-size: 2.375rem;\n    letter-spacing: -0.25px;\n    line-height: 1.1842105;\n  }\n\n  h2 {\n    margin: 0.75em 0;\n    font-size: 2rem;\n    letter-spacing: -0.25px;\n    line-height: 1.25;\n  }\n\n  h3 {\n    margin: 1em 0;\n    font-size: 1.5rem;\n    letter-spacing: -0.25px;\n    line-height: 1.3333333;\n  }\n\n  h4 {\n    margin: 1em 0;\n    font-size: 1.25rem;\n    line-height: 1.4;\n  }\n\n  h5 {\n    margin: 1em 0;\n    font-size: 1.125rem;\n    line-height: 1.4444444;\n  }\n\n  h6 {\n    margin: 1em 0;\n    font-size: 1rem;\n    line-height: 1.5;\n  }\n\n  /**\n   * Add the correct font weight in Chrome, Edge, and Safari.\n   */\n  b,\nstrong {\n    font-weight: bolder;\n  }\n\n  /**\n   * Add vertical margin to addresses.\n   */\n  address {\n    margin: 1em 0;\n  }\n\n  /**\n   * Additional styling for blockquotes.\n   */\n  blockquote {\n    margin: 0.8em 0;\n    font-size: 1.25rem;\n    font-style: italic;\n    line-height: 1.4;\n    text-align: center;\n  }\n\n  /**\n   * 1. Remove the bottom border in Chrome 57+.\n   * 2. Add the correct text decoration in Chrome, Edge, IE, Opera, and Safari.\n   */\n  abbr[title] {\n    /* 1 */\n    border-bottom: 0;\n    /* 2 */\n    -webkit-text-decoration: underline dotted;\n            text-decoration: underline dotted;\n  }\n\n  /**\n   * Consistent styling for `mark` and `var` tags.\n   */\n  mark,\nvar {\n    padding: 0 0.25em;\n    border-radius: 0.25em;\n    background: #fff9e1;\n    color: #333333;\n  }\n\n  /**\n   * Harmonize size and style of computer text.\n   */\n  pre,\ncode,\nkbd,\nsamp {\n    border: 1px solid #e3e3e3;\n    border-radius: 0.2857143em;\n    background-color: #f7f7f7;\n    color: #333333;\n    font-family: Menlo, Consolas, Monaco, monospace;\n    font-size: 0.875rem;\n    line-height: 1.5;\n  }\n\n  code,\nkbd,\nsamp {\n    padding: 1px 0.21429em;\n  }\n\n  /**\n   * Additional stylng for preformatted text/code.\n   *\n   * 1. Contain overflow in all browsers.\n   * 2. Don\'t wrap long words.\n   * 3. Set tab size to 4 spaces.\n   */\n  pre {\n    padding: 0.5714286em 1.1428571em;\n    /* 1 */\n    overflow-x: auto;\n    /* 2 */\n    word-wrap: normal;\n    /* 3 */\n    -moz-tab-size: 4;\n      -o-tab-size: 4;\n         tab-size: 4;\n  }\n  pre code {\n    padding: 0;\n    border: 0;\n    background-color: transparent;\n    direction: ltr;\n    font-size: 1em;\n    -webkit-hyphens: none;\n        -ms-hyphens: none;\n            hyphens: none;\n    text-align: left;\n    word-wrap: normal;\n    word-break: normal;\n    word-spacing: normal;\n    white-space: pre;\n  }\n\n  /**\n   * Prevent `sub` and `sup` elements from affecting the line height in all\n   * browsers.\n   */\n  sub,\nsup.footnote,\nsup {\n    position: relative;\n    font-size: 0.75em;\n    line-height: 0;\n    vertical-align: baseline;\n  }\n\n  sup {\n    top: -0.5em;\n  }\n\n  sub {\n    bottom: -0.25em;\n  }\n\n  /**\n   * Harmonize size and style of small text.\n   */\n  small,\nfigcaption,\ntfoot,\n.footnote {\n    font-size: 0.8125rem;\n    line-height: 1.5;\n  }\n\n  figcaption,\ntfoot,\n.footnote {\n    color: #585858;\n  }\n\n  figcaption {\n    margin-top: 0.5em;\n    font-style: italic;\n  }\n\n  /**\n   * 1. Add the correct box sizing in Firefox.\n   * 2. Show the overflow in Edge and IE.\n   */\n  hr {\n    /* 1 */\n    box-sizing: content-box;\n    height: 24px;\n    margin: 1em 0;\n    /* 2 */\n    overflow: visible;\n    border: 0;\n    background: url(\"data:image/svg+xml,%3Csvg xmlns=%27http://www.w3.org/2000/svg%27 viewBox=%270 0 240 24%27%3E%3Cpath fill=%27%23333%27 d=%27M0,0c1.742,13.61,54.74,20.912,119.995,15.279C184.922,9.679,238.594,13.024,240,24c-1.744-13.613-54.742-20.913-120.005-15.284C55.078,14.32,1.405,10.973,0,0z%27/%3E%3C/svg%3E\") 50% 50% no-repeat;\n    background-size: 240px 24px;\n  }\n\n  /* Support for non-latin languages (can be removed if not required)\n     ========================================================================== */\n  /**\n   * Bidirectional (bidi) text support.\n   * See: https://www.w3.org/International/articles/inline-bidi-markup/#cssshim\n   */\n  [dir=ltr],\n[dir=rtl] {\n    unicode-bidi: -webkit-isolate;\n    unicode-bidi: isolate;\n  }\n\n  bdo[dir=ltr],\nbdo[dir=rtl] {\n    unicode-bidi: isolate-override;\n  }\n\n  /**\n   * Preferred font for Japanese language.\n   */\n  :lang(ja) {\n    font-family: \"Hiragino Sans\", \"Hiragino Kaku Gothic Pro\", \"Meiryo UI\", sans-serif;\n    font-weight: 300;\n  }\n\n  /**\n   * Preferred font for Korean language.\n   */\n  :lang(ko) {\n    font-family: GulimChe, Gulim, sans-serif;\n  }\n\n  /**\n   * Preferred font for simplified Chinese (PRC) language.\n   */\n  :lang(zh-cn) {\n    font-family: \"PingFang SC\", SimHei, sans-serif;\n  }\n\n  /**\n   * Preferred font for traditional Chinese (Taiwan, Hong Kong) language.\n   */\n  :lang(zh-tw) {\n    font-family: \"PingFang TC\", PMingLiU, sans-serif;\n  }\n\n  /**\n   * Suppress `text-decoration` in some RTL languages for better legibility.\n   */\n  [lang|=ar] a:hover,\n[lang|=fa] a:hover,\n[lang|=ur] a:hover {\n    text-decoration: none;\n  }\n\n  /**\n   * Computer code should be LTR.\n   */\n  [dir=rtl] code {\n    direction: ltr;\n  }\n\n  /**\n   * Swap image alignment right/left positions in RTL languages.\n   */\n  [dir=rtl] img.align-left {\n    margin: 1em 0 1em 1em;\n    float: right;\n  }\n  [dir=rtl] img.align-right {\n    margin: 1em 1em 1em 0;\n    float: left;\n  }\n\n  /**\n   * Swap table caption alignment in RTL languages.\n   */\n  [dir=rtl] caption {\n    text-align: right;\n  }\n\n  /**\n   * Swap table cell text alignments in RTL languages.\n   */\n  [dir=rtl] th,\n[dir=rtl] td {\n    text-align: right;\n  }\n\n  /**\n   * Swap menu/list padding positions in RTL languages.\n   */\n  [dir=rtl] menu,\n[dir=rtl] ol,\n[dir=rtl] ul {\n    padding: 0 2em 0 0;\n  }\n\n  [dir=rtl] .site-navigation ul,\n[dir=rtl] .article-list {\n    padding: 0;\n  }\n\n  /**\n   * Swap definition description margin positions in RTL languages.\n   */\n  [dir=rtl] dd {\n    margin: 0 2em 0 0;\n  }\n\n  /**\n   * Swap checkbox/radio margin positions in RTL languages.\n   */\n  [dir=rtl] input[type=checkbox] + label,\n[dir=rtl] input[type=radio] + label {\n    margin: 0 0 0 0.5em;\n  }\n  [dir=rtl] input[type=checkbox] + label:last-of-type,\n[dir=rtl] input[type=radio] + label:last-of-type {\n    margin: 0;\n  }\n\n  /**\n   * Swap `select` icon position in RTL languages.\n   */\n  [dir=rtl] select {\n    padding-right: 0.1875em;\n    padding-left: 1.5em;\n    background-position: 0.5em center;\n  }\n\n  /**\n   * Swap ‘skip links’ position in RTL languages.\n   */\n  [dir=rtl] .skip-link {\n    right: 1px;\n    left: auto;\n  }\n\n  /**\n   * Swap anchor float position on comments.\n   */\n  [dir=rtl] .comments h4 .comment-anchor {\n    float: left;\n  }\n\n  /* Embedded content\n     ========================================================================== */\n  /**\n   * Add the correct display in IE 11.\n   */\n  video {\n    display: inline-block;\n  }\n\n  /**\n   * Make embedded elements responsive.\n   */\n  img,\nvideo {\n    max-width: 100%;\n    height: auto;\n  }\n\n  /**\n   * Images.\n   *\n   * 1. Remove the gap between images and the bottom of their containers.\n   *\n   * Image alignment (compatible with Textile markup syntax).\n   *\n   * Example HTML:\n   *\n   * <img class=\"align-left\">\n   * <img class=\"align-right\">\n   * <img class=\"align-center\">\n   */\n  img {\n    /* 1 */\n    vertical-align: middle;\n  }\n  img.align-left {\n    margin: 1em 1em 1em 0;\n    float: left;\n  }\n  img.align-right {\n    margin: 1em 0 1em 1em;\n    float: right;\n  }\n  img.align-center {\n    display: block;\n    margin: 1em auto;\n  }\n\n  /**\n   * Consistent margins on `figure`.\n   */\n  figure {\n    margin: 1em 0;\n  }\n\n  /* Tables\n     ========================================================================== */\n  /**\n   * Consistent tables.\n   */\n  table {\n    width: 100%;\n    margin-bottom: 1em;\n    border-spacing: 0;\n    border-collapse: collapse;\n  }\n\n  /**\n   * Styling of table captions.\n   */\n  caption {\n    margin-bottom: 0.5em;\n    font-style: italic;\n    text-align: left;\n  }\n\n  /**\n   * Make table cells align top and left by default.\n   */\n  th,\ntd {\n    padding: 0.5em;\n    border: 1px solid #d4d4d4;\n    vertical-align: top;\n    text-align: left;\n  }\n\n  /**\n   * Emphasize table header.\n   */\n  thead tr {\n    background-color: #eeeeee;\n  }\n  thead th,\nthead td {\n    border: 1px solid #cccccc;\n  }\n\n  /**\n   * \'Zebra striping\' of `tbody` rows.\n   */\n  tbody tr:nth-child(even) {\n    background-color: #f7f7f7;\n  }\n\n  /**\n   * Adjust padding of table footer due to smaller font size.\n   */\n  tfoot th,\ntfoot td {\n    padding: 0.6666667em;\n  }\n\n  /**\n   * Multi-row span vertical cell alignments.\n   */\n  [rowspan] {\n    vertical-align: middle;\n  }\n\n  /* Lists\n     ========================================================================== */\n  /**\n   * Address paddings set differently.\n   */\n  menu,\nol,\nul {\n    padding: 0 0 0 2em;\n  }\n\n  /**\n   * Remove margins from nested lists.\n   */\n  li > ul,\nli > ol {\n    margin: 0;\n  }\n\n  /**\n   * CSS Lists and Counters Module Level 3 list marker styling.\n   */\n  li::marker {\n    color: color-text-heading;\n  }\n\n  /**\n   * Address margins set differently.\n   */\n  dd {\n    margin: 0 0 0 2em;\n  }\n\n  /**\n   * Additional styling for article lists.\n   *\n   * Example HTML:\n   *\n   * <ul class=\"article-list\">\n   */\n  .article-list {\n    margin: 0 0 2em;\n    padding: 0;\n    border-top: 1px solid #cccccc;\n    list-style: none;\n  }\n  .article-list li {\n    margin-bottom: 0;\n    border-bottom: 1px solid #cccccc;\n  }\n\n  /* Forms\n     ========================================================================== */\n  /**\n   * 1. Address width being affected by wide descendants in Chrome, Firefox.\n   * 2. Define consistent fieldset border, margin, and padding.\n   */\n  fieldset {\n    /* 1 */\n    min-width: 0;\n    /* 2 */\n    margin: 1em 0;\n    padding: 1px 1em;\n    border: 1px solid #cccccc;\n  }\n\n  /**\n   * Normalize styling of `legend`.\n   *\n   * 1. Correct wrapping not present in IE 11 and Edge 12/13.\n   * 2. Remove padding so people aren\'t caught out if they zero out fieldsets.\n   * 3. Correct `color` not being inherited from fieldset in IE 11.\n   */\n  legend {\n    /* 1 */\n    display: table;\n    /* 1 */\n    box-sizing: border-box;\n    /* 1 */\n    max-width: 100%;\n    /* 2 */\n    padding: 0;\n    /* 3 */\n    color: inherit;\n    /* 1 */\n    white-space: normal;\n  }\n\n  /**\n   * 1. Show the overflow in Edge.\n   * 2. Remove tap delay in modern browsers.\n   */\n  button,\ninput {\n    /* 1 */\n    overflow: visible;\n    /* 2 */\n    touch-action: manipulation;\n  }\n\n  /**\n   * 1. Prevent elements from spilling out of their parent.\n   * 2. Address margins set differently in Firefox 4+, Safari, and Chrome.\n   * 3. Correct font properties not being inherited.\n   */\n  button,\ninput,\noptgroup,\nselect,\ntextarea {\n    box-sizing: border-box;\n    /* 1 */\n    max-width: 100%;\n    /* 2 */\n    margin: 0;\n    color: #000000;\n    font-family: system-ui, -apple-system, \"Segoe UI\", Helvetica, Arial, sans-serif, \"Apple Color Emoji\", \"Segoe UI Emoji\", \"Segoe UI Symbol\";\n    /* 3 */\n    font-size: 1rem;\n    line-height: 1.375;\n    vertical-align: baseline;\n  }\n\n  /**\n   * Styling of form input fields.\n   *\n   * 1. Remove browser-specific default styling.\n   */\n  [type=color],\n[type=date],\n[type=datetime],\n[type=datetime-local],\n[type=email],\n[type=month],\n[type=number],\n[type=password],\n[type=search],\n[type=tel],\n[type=text],\n[type=time],\n[type=url],\n[type=week],\nselect,\ntextarea {\n    height: 2em;\n    padding: 0.25em 0.1875em;\n    border: 1px solid #cccccc;\n    border-radius: 0;\n    background: #ffffff;\n    /* 1 */\n    -webkit-appearance: none;\n       -moz-appearance: none;\n            appearance: none;\n  }\n  [type=color]:focus,\n[type=date]:focus,\n[type=datetime]:focus,\n[type=datetime-local]:focus,\n[type=email]:focus,\n[type=month]:focus,\n[type=number]:focus,\n[type=password]:focus,\n[type=search]:focus,\n[type=tel]:focus,\n[type=text]:focus,\n[type=time]:focus,\n[type=url]:focus,\n[type=week]:focus,\nselect:focus,\ntextarea:focus {\n    border-color: #0066ff;\n    outline: 1px solid transparent;\n  }\n\n  /**\n   * 1. Remove any excess padding.\n   * 2. Correct margins for inline checkbox/radio labels.\n   */\n  [type=checkbox],\n[type=radio] {\n    /* 1 */\n    padding: 0;\n  }\n  [type=checkbox] + label,\n[type=radio] + label {\n    /* 2 */\n    margin: 0 0.5em 0 0;\n  }\n  [type=checkbox] + label:last-of-type,\n[type=radio] + label:last-of-type {\n    /* 2 */\n    margin: 0;\n  }\n\n  /**\n   * Correct the cursor style of increment and decrement buttons in Safari.\n   */\n  [type=number]::-webkit-inner-spin-button,\n[type=number]::-webkit-outer-spin-button {\n    height: auto;\n  }\n\n  /**\n   * Remove the inner padding in Chrome and Safari on macOS.\n   */\n  [type=search]::-webkit-search-decoration {\n    /* autoprefixer: off */\n    appearance: none;\n  }\n\n  /**\n   * Use indicator icon to signify the drop-down ability of `select`.\n   */\n  select {\n    padding-right: 1.5em;\n    background: #ffffff url(\"data:image/svg+xml,%3Csvg xmlns=%27http://www.w3.org/2000/svg%27 width=%2717%27 height=%275%27 viewBox=%270 0 17 5%27%3E%3Cpolygon fill=%27%23333%27 points=%270,0 5,5 10,0%27/%3E%3C/svg%3E\") right center no-repeat;\n    background-size: 1.0625em 0.3125em;\n    text-transform: none;\n  }\n\n  /**\n   * Remove browser-specific `select` UI in IE 11.\n   */\n  select::-ms-expand {\n    opacity: 0;\n  }\n\n  /**\n   * Override height and background set in a previous rule and allow auto height.\n   */\n  select[size],\nselect[multiple] {\n    height: auto;\n    padding-right: 0.5em;\n    background-image: none;\n  }\n\n  /**\n   * Override height set in rule above and restrict to one line field.\n   */\n  select[size=\"0\"],\nselect[size=\"1\"] {\n    height: 2em;\n  }\n\n  /**\n   * Normalize styling of `optgroup`.\n   */\n  optgroup {\n    font-style: normal;\n    font-weight: bold;\n  }\n\n  /**\n   * 1. Remove default vertical scrollbar in IE 11.\n   * 2. Remove unwanted space below `textarea` in Safari, Chrome, Opera.\n   * 3. Restrict to vertical resizing to prevent layout breakage.\n   */\n  textarea {\n    width: 100%;\n    height: auto;\n    min-height: 3em;\n    /* 1 */\n    overflow: auto;\n    /* 2 */\n    vertical-align: top;\n    /* 3 */\n    resize: vertical;\n  }\n\n  /**\n   * Make sure disabled elements really are disabled and styled appropriately.\n   *\n   * 1. Override default iOS opacity setting.\n   * 2. Re-set default cursor for disabled elements.\n   */\n  [disabled],\n[disabled] option,\n[disabled] optgroup,\nspan.disabled {\n    border-color: #d4d4d4 !important;\n    /* 1 */\n    opacity: 1;\n    background: #eeeeee !important;\n    box-shadow: none !important;\n    color: #aaaaaa !important;\n    text-shadow: none !important;\n    /* 2 */\n    cursor: default !important;\n  }\n\n  /**\n   * Width display options for `input` fields. Height display options\n   * for textareas.\n   *\n   * Example HTML:\n   *\n   * <input class=\"small\">\n   * <input class=\"large\">\n   */\n  .small input {\n    width: 25%;\n    min-width: 151px;\n  }\n  .small textarea {\n    height: 5.5em;\n  }\n\n  .large input {\n    width: 50%;\n    min-width: 302px;\n  }\n  .large textarea {\n    height: 9.75em;\n  }\n\n  /**\n   * Styling for form field validation.\n   */\n  input:focus:invalid,\nselect:focus:invalid,\ntextarea:focus:invalid {\n    border-color: #9d261d;\n    box-shadow: none;\n  }\n\n  /**\n   * Styling for Firefox-specfic form field validation.\n   */\n  input:-moz-ui-invalid,\nselect:-moz-ui-invalid,\ntextarea:-moz-ui-invalid {\n    border-color: #9d261d;\n    box-shadow: none;\n  }\n\n  /**\n   * Normalize form placeholder style across browsers.\n   *\n   * 1. Fix placeholder font properties inheritance.\n   */\n  :-ms-input-placeholder {\n    opacity: 1;\n    color: #999999;\n    /* 1 */\n    font: inherit;\n  }\n  ::placeholder {\n    opacity: 1;\n    color: #999999;\n    /* 1 */\n    font: inherit;\n  }\n\n  /**\n   * Styling for required field indicators.\n   *\n   * Example HTML:\n   *\n   * <b class=\"required\" title=\"Required\">*</b>\n   */\n  .required {\n    border: 0;\n    color: #9d261d;\n  }\n\n  /* Buttons\n     ========================================================================== */\n  /**\n   * 1. Address `overflow` set to `hidden` in IE 11.\n   * 2. Remove the inheritance of text transform in Edge, Firefox, and IE 11.\n   */\n  button {\n    /* 1 */\n    overflow: visible;\n    /* 2 */\n    text-transform: none;\n  }\n\n  /**\n   * Remove the inner border and padding in Firefox.\n   */\n  button::-moz-focus-inner,\n[type=button]::-moz-focus-inner,\n[type=reset]::-moz-focus-inner,\n[type=submit]::-moz-focus-inner {\n    padding: 0;\n    border-style: none;\n  }\n\n  /**\n   * 1. Remove browser-specific default styling.\n   * 2. Improve usability and consistency of cursor style between image-type\n   *    `input` and others.\n   */\n  button,\n[type=button],\n[type=reset],\n[type=submit] {\n    background-color: #dfdfdf;\n    background-image: linear-gradient(#eeeeee, #dfdfdf);\n    display: inline-block;\n    position: relative;\n    width: auto;\n    height: 2em;\n    padding: 0.25em 1em;\n    border: 1px solid #dfdfdf;\n    border-radius: 1em;\n    background-clip: padding-box;\n    box-shadow: 0 2px 0 #acacac;\n    color: #333333;\n    font-weight: normal;\n    text-align: center;\n    /* 1 */\n    -webkit-appearance: none;\n       -moz-appearance: none;\n            appearance: none;\n    /* 2 */\n    cursor: pointer;\n  }\n  button:hover,\n[type=button]:hover,\n[type=reset]:hover,\n[type=submit]:hover {\n    background-color: #e9e9e9;\n    background-image: linear-gradient(#f8f8f8, #e9e9e9);\n    border-color: #bebebe;\n    color: #333333;\n    text-decoration: none;\n  }\n  button:active,\n[type=button]:active,\n[type=reset]:active,\n[type=submit]:active {\n    top: 2px;\n    border-color: #bebebe;\n    box-shadow: none;\n    color: #1a1a1a;\n    text-decoration: none;\n  }\n  button:focus,\n[type=button]:focus,\n[type=reset]:focus,\n[type=submit]:focus {\n    border-color: #0066ff;\n    outline: 1px solid transparent;\n  }\n\n  /**\n   * Disbaled button additional styling.\n   */\n  button[disabled],\n[type=button][disabled],\n[type=reset][disabled],\n[type=submit][disabled] {\n    top: 2px !important;\n  }\n\n  /* Comments\n     ========================================================================== */\n  /**\n   * Styling for user comments.\n   *\n   * Example HTML:\n   *\n   * <article class=\"comments\">\n   */\n  .comments {\n    margin-bottom: 1em;\n    padding: 1px 1em;\n    border-radius: 0.5em;\n    background: #f7f7f7;\n    word-wrap: break-word;\n  }\n  .comments h4 .is-author {\n    font-weight: normal;\n  }\n  .comments h4 .comment-anchor {\n    float: right;\n    font-weight: normal;\n  }\n\n  /**\n   * Additional styling for article author\'s comments.\n   *\n   * Example HTML:\n   *\n   * <article class=\"comments comments-author\">\n   */\n  .comments-author {\n    background: #efefef;\n  }\n\n  /**\n   * Styling for user comments preview.\n   */\n  #cpreview {\n    margin-bottom: 2px;\n    padding: 1em;\n    border-radius: 0.5em;\n    background-color: #fff9e1;\n  }\n\n  /**\n   * Highlight text colour for comment errors.\n   */\n  .error_message li {\n    color: #9d261d;\n  }\n\n  /**\n   * Highlighting for comment form errors.\n   */\n  .comments_error {\n    border-color: #9d261d;\n  }\n\n  /* Popup comments (can be removed if you don\'t use popups)\n     ========================================================================== */\n  /**\n   * Restrict maximum width of popup container.\n   */\n  #popup-page .container {\n    max-width: 52em;\n  }\n}\n/* ==========================================================================\n   Additional layout for screen media 576px and up\n   ========================================================================== */\n@media only screen and (min-width: 38em) {\n  /**\n   * Desktop version of the navigation menu. Overrides mobile first version.\n   *\n   * Example HTML:\n   *\n   * <nav class=\"site-navigation\">\n   *     <div>\n   *         <ul>\n   *             <li class=\"active\"><a></li>\n   *             <li><a></li>\n   *             <li><a></li>\n   *         </ul>\n   *         <div class=\"search\">\n   *             <form>\n   *                 <input type=\"search\">\n   *             </form>\n   *        </div>\n   *    </div>\n   * </nav>\n   */\n  .site-navigation {\n    border-top: 1px solid #cccccc;\n    border-bottom: 1px solid #cccccc;\n  }\n  .site-navigation > div {\n    display: flex;\n    flex-wrap: wrap;\n    justify-content: space-between;\n    width: 88%;\n  }\n  .site-navigation ul {\n    display: flex;\n    flex-wrap: wrap;\n    border: 0;\n  }\n  .site-navigation li {\n    border-width: 0 1px;\n  }\n  .site-navigation a {\n    padding: 0.5em 1em;\n  }\n\n  .search {\n    margin-top: 0.2em;\n    padding: 0;\n    background: transparent;\n  }\n  .search input[type=search] {\n    width: 2.125em;\n    padding-right: 0;\n    transition: width 0.2s ease-in-out, border-color 0.2s ease-in-out;\n    background-color: #eeeeee;\n    cursor: pointer;\n  }\n  .search input[type=search]:hover {\n    background-color: #f8f8f8;\n  }\n  .search input[type=search]:focus {\n    width: 16em;\n    padding-right: 0.1875em;\n    background-color: white;\n    cursor: auto;\n  }\n}\n/* ==========================================================================\n   Additional layout for screen media 864px and up\n   ========================================================================== */\n@media only screen and (min-width: 46em) {\n  /**\n   * Enlarge baseline text size.\n   */\n  html {\n    font-size: 1.125rem;\n  }\n}\n/* ==========================================================================\n   Additional accessibility for screen media\n   ========================================================================== */\n@media screen and (prefers-reduced-motion: reduce), (update: slow) {\n  .search input[type=search] {\n    transition-duration: 0;\n  }\n}\n/* ==========================================================================\n   Styling and layout for print media\n   ========================================================================== */\n@media print {\n  /**\n   * Remove unnecessary global styling from printed media.\n   */\n  *,\n*::before,\n*::after {\n    background: transparent !important;\n    box-shadow: none !important;\n    color: #000000 !important;\n    text-shadow: none !important;\n  }\n\n  /**\n   * Use a print-friendly font size.\n   */\n  html {\n    font-size: 8pt;\n    line-height: 1.5;\n  }\n\n  /**\n   * Use a print-friendly font family.\n   */\n  body {\n    margin: 0.5cm;\n    padding: 2em 5em;\n    font-family: \"Helvetica Neue\", sans-serif;\n  }\n\n  /**\n   * Make sure links are not underlined.\n   */\n  a {\n    text-decoration: none;\n  }\n\n  /**\n   * Visually separate header from body.\n   */\n  .site-header {\n    border-bottom: 1pt solid #000000;\n  }\n\n  /**\n   * Visually separate footer from body.\n   */\n  .site-footer {\n    margin-top: 12pt;\n    border-top: 1pt solid #000000;\n  }\n\n  /**\n   * Hide unnecessary content from print.\n   */\n  nav,\naudio,\nvideo,\nform,\n#comments-form,\n.comments h4 a:last-child,\n.complementary-content,\n.paginator,\n.skip-link {\n    display: none;\n  }\n\n  /**\n   * Show long-form for abbreviations in print.\n   */\n  abbr[title]::after {\n    content: \" (\" attr(title) \")\";\n  }\n\n  /**\n   * Harmonize size, style and vertical margin of headings.\n   */\n  h1 {\n    margin: 16pt 0;\n    font-size: 32pt;\n    font-weight: normal;\n    line-height: 36pt;\n  }\n\n  h2 {\n    margin: 14pt 0;\n    font-size: 24pt;\n    line-height: 28pt;\n    orphans: 2;\n    widows: 2;\n    page-break-after: avoid;\n  }\n\n  h3 {\n    margin: 12pt 0;\n    font-size: 18pt;\n    line-height: 22pt;\n    orphans: 2;\n    widows: 2;\n    page-break-after: avoid;\n  }\n\n  h4 {\n    margin: 11pt 0;\n    font-size: 14pt;\n    line-height: 18pt;\n    orphans: 2;\n    widows: 2;\n    page-break-after: avoid;\n  }\n\n  h5 {\n    margin: 10pt 0;\n    font-size: 12pt;\n    line-height: 16pt;\n    orphans: 2;\n    widows: 2;\n    page-break-after: avoid;\n  }\n\n  h6 {\n    margin: 9pt 0;\n    font-size: 10pt;\n    line-height: 14pt;\n    orphans: 2;\n    widows: 2;\n    page-break-after: avoid;\n  }\n\n  /**\n   * Prevent widows (single final paragraph line on next page) and orphans (single\n   * first paragraph line on previous page).\n   */\n  p {\n    orphans: 2;\n    widows: 2;\n  }\n\n  /**\n   * Harmonize size and style of small text.\n   */\n  footer,\nfigcaption,\ntfoot,\nsmall,\n.footnote {\n    font-size: 6pt;\n  }\n\n  /**\n   * Simple blockquote styling.\n   *\n   * 1. Avoid blockquotes breaking across multiple pages.\n   */\n  blockquote {\n    padding: 0 0 0 8pt;\n    border-left: 3pt solid #000000;\n    font-size: 16pt;\n    /* 1 */\n    page-break-inside: avoid;\n  }\n\n  [dir=rtl] blockquote {\n    padding: 0 8pt 0 0;\n    border-right: 3pt solid #000000;\n    border-left: 0;\n  }\n\n  /**\n   * Simple preformatted text styling.\n   *\n   * 1. Ensure pre blocks are wrapped when printed.\n   */\n  pre {\n    margin-bottom: 8pt;\n    padding: 8pt;\n    border: 1pt solid #000000;\n    /* 1 */\n    white-space: pre-wrap !important;\n  }\n\n  /**\n   * Use a print-friendly monospaced font and size.\n   */\n  pre,\ncode,\nkbd,\nsamp,\nvar {\n    font-family: \"Courier New\", Courier, monospace;\n  }\n\n  /**\n   * Images.\n   *\n   * 1. Avoid images breaking across multiple pages.\n   *\n   * Image alignment (compatible with Textile markup syntax).\n   *\n   * Example HTML:\n   *\n   * <img class=\"align-left\">\n   * <img class=\"align-right\">\n   * <img class=\"align-center\">\n   */\n  img {\n    /* 1 */\n    page-break-inside: avoid;\n  }\n  img.align-left {\n    margin: 1em 1em 1em 0;\n    float: left;\n  }\n  img.align-right {\n    margin: 1em 0 1em 1em;\n    float: right;\n  }\n  img.align-center {\n    display: block;\n    margin: 1em auto;\n  }\n\n  /**\n   * Swap image alignment right/left positions in RTL languages.\n   */\n  [dir=rtl] img.align-left {\n    margin: 1em 0 1em 1em;\n    float: right;\n  }\n  [dir=rtl] img.align-right {\n    margin: 1em 1em 1em 0;\n    float: left;\n  }\n\n  /**\n   * Ensure margin below `figure`.\n   */\n  figure {\n    margin-bottom: 8pt;\n  }\n\n  /**\n   * Ensure margin above `figcaption`.\n   */\n  figcaption {\n    margin-top: 4pt;\n  }\n\n  /**\n   * Simple bullet styling for `ul` unordered lists.\n   */\n  ul {\n    padding: 0 0 8pt 1.8em;\n    list-style: square;\n  }\n\n  [dir=rtl] ul {\n    padding: 0 1.8em 8pt 0;\n  }\n\n  /**\n   * Simple numerical styling for `ol` ordered lists.\n   */\n  ol {\n    padding: 0 0 8pt 1.8em;\n    list-style: decimal;\n  }\n\n  [dir=rtl] ol {\n    padding: 0 1.8em 8pt 0;\n  }\n\n  /**\n   * Normalize margins on `dl` definition lists.\n   */\n  dl {\n    padding: 0 0 8pt 1.8em;\n  }\n\n  [dir=rtl] dl {\n    padding: 0 1.8em 8pt 0;\n  }\n\n  /**\n   * 1. Make `table` span entire page width.\n   * 2. Ensure margin below `table`.\n   */\n  table {\n    /* 1 */\n    width: 100%;\n    /* 2 */\n    margin-bottom: 8pt;\n  }\n\n  /**\n   * Harmonize styling for `caption`.\n   */\n  caption {\n    margin-bottom: 4pt;\n    font-weight: bold;\n  }\n\n  /**\n   * Avoid table rows breaking across multiple pages.\n   */\n  tr {\n    page-break-inside: avoid;\n  }\n\n  /**\n   * Simple styling for table cells.\n   */\n  th,\ntd {\n    padding: 4pt 8pt;\n    border-bottom: 1pt solid #000000;\n  }\n\n  /**\n   * Display table head across multi-page tables.\n   */\n  thead {\n    display: table-header-group;\n  }\n  thead th {\n    border-top: 1pt solid #000000;\n  }\n\n  /**\n   * Avoid user comments breaking across multiple pages.\n   */\n  .comments {\n    page-break-inside: avoid;\n  }\n}','four-point-eight',NULL);

--
-- Table structure for table `txttxp_discuss`
--

CREATE TABLE `txttxp_discuss` (
  `discussid` int(6) unsigned zerofill NOT NULL AUTO_INCREMENT,
  `parentid` int(11) NOT NULL DEFAULT 0,
  `name` varchar(255) NOT NULL DEFAULT '',
  `email` varchar(254) NOT NULL DEFAULT '',
  `web` varchar(255) NOT NULL DEFAULT '',
  `posted` datetime NOT NULL,
  `message` text NOT NULL,
  `visible` tinyint(4) NOT NULL DEFAULT 1,
  PRIMARY KEY (`discussid`),
  KEY `parentid` (`parentid`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `txttxp_discuss`
--

INSERT INTO `txttxp_discuss` VALUES (000001,1,'Donald Swain','donald-swain@example.com','https://docs.textpattern.com/brand/donald-swain','2023-01-30 20:20:02','<p>I enjoy your site very much.</p>',1);

--
-- Table structure for table `txttxp_discuss_nonce`
--

CREATE TABLE `txttxp_discuss_nonce` (
  `issue_time` datetime NOT NULL,
  `nonce` varchar(255) NOT NULL DEFAULT '',
  `used` tinyint(4) NOT NULL DEFAULT 0,
  `secret` varchar(255) NOT NULL DEFAULT '',
  PRIMARY KEY (`nonce`(250))
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `txttxp_discuss_nonce`
--


--
-- Table structure for table `txttxp_file`
--

CREATE TABLE `txttxp_file` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `filename` varchar(255) NOT NULL DEFAULT '',
  `title` varchar(255) DEFAULT NULL,
  `category` varchar(64) NOT NULL DEFAULT '',
  `permissions` varchar(32) NOT NULL DEFAULT '0',
  `description` text NOT NULL,
  `downloads` int(10) unsigned NOT NULL DEFAULT 0,
  `status` smallint(6) NOT NULL DEFAULT 4,
  `modified` datetime NOT NULL,
  `created` datetime NOT NULL,
  `size` bigint(20) DEFAULT NULL,
  `author` varchar(64) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  UNIQUE KEY `filename` (`filename`(250)),
  KEY `author_idx` (`author`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `txttxp_file`
--


--
-- Table structure for table `txttxp_form`
--

CREATE TABLE `txttxp_form` (
  `name` varchar(255) NOT NULL DEFAULT '',
  `type` varchar(28) NOT NULL DEFAULT '',
  `Form` text NOT NULL,
  `skin` varchar(63) NOT NULL DEFAULT 'default',
  `lastmod` datetime DEFAULT NULL,
  UNIQUE KEY `name_skin` (`name`(63),`skin`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `txttxp_form`
--

INSERT INTO `txttxp_form` VALUES ('article_listing','article','<li class=\"article\" itemprop=\"blogPost\" itemscope itemtype=\"https://schema.org/BlogPosting\">\n    <h4 itemprop=\"headline\">\n        <a href=\"<txp:permlink />\" itemprop=\"url mainEntityOfPage\" title=\"<txp:text item=\"read_more\" />\">\n            <txp:title />\n        </a>\n    </h4>\n\n    <!-- if the article has an excerpt, display that -->\n    <txp:if_excerpt>\n        <div itemprop=\"description\">\n            <txp:excerpt />\n        </div>\n    </txp:if_excerpt>\n\n    <p class=\"footnote\">\n        <txp:text item=\"posted\" />\n        <time datetime=\"<txp:posted format=\"iso8601\" />\" itemprop=\"datePublished\">\n            <txp:posted />\n        </time>\n        <meta itemprop=\"dateModified\" content=\"<txp:modified format=\"iso8601\" />\" />\n        &#183;\n        <txp:text item=\"author\" />\n        <span itemprop=\"author\" itemscope itemtype=\"https://schema.org/Person\">\n            <span itemprop=\"name\">\n                <txp:author link this_section />\n            </span>\n        </span>\n    </p>\n</li>','four-point-eight',NULL),('default','article','<article class=\"article\" itemprop=\"blogPost\" itemscope itemtype=\"https://schema.org/BlogPosting\">\n    <meta itemprop=\"mainEntityOfPage\" content=\"<txp:permlink />\">\n\n    <txp:if_individual_article>\n        <h1 itemprop=\"headline\"><txp:title /></h1>\n    <txp:else />\n        <h1 itemprop=\"headline\"><a href=\"<txp:permlink />\" itemprop=\"url\" title=\"<txp:text item=\"read_more\" />\"><txp:title /></a>\n        </h1>\n    </txp:if_individual_article>\n\n    <p>\n        <strong>\n            <txp:text item=\"posted\" />\n        </strong>\n        <time datetime=\"<txp:posted format=\"iso8601\" />\" itemprop=\"datePublished\">\n            <txp:posted />\n        </time>\n        <meta itemprop=\"dateModified\" content=\"<txp:modified format=\"iso8601\" />\" />\n\n        <!-- only display comments count if comments posted, or if new comments allowed -->\n        <txp:if_comments>\n            <br>\n            <strong>\n                <txp:text item=\"comments\" />\n            </strong>\n            <a href=\"<txp:permlink />#comments-head\" title=\"<txp:text item=\"go_comments\" />\" itemprop=\"discussionUrl\">\n                <span itemprop=\"interactionStatistic\" itemscope itemtype=\"https://schema.org/InteractionCounter\">\n                    <meta itemprop=\"interactionType\" content=\"https://schema.org/CommentAction\" />\n                    <span itemprop=\"userInteractionCount\"><txp:comments_count /></span>\n                </span>\n            </a>\n        <txp:else />\n            <txp:if_comments_allowed>\n                <br>\n                <strong>\n                    <txp:text item=\"comments\" />\n                </strong>\n                <a href=\"<txp:permlink />#comments-head\" title=\"<txp:text item=\"go_comments\" />\" itemprop=\"discussionUrl\">\n                    <span itemprop=\"interactionStatistic\" itemscope itemtype=\"https://schema.org/InteractionCounter\">\n                        <meta itemprop=\"interactionType\" content=\"https://schema.org/CommentAction\" />\n                        <span itemprop=\"userInteractionCount\">0</span>\n                    </span>\n                </a>\n            </txp:if_comments_allowed>\n        </txp:if_comments>\n    </p>\n\n    <txp:if_article_image>\n        <txp:images form=\"images\" />\n    </txp:if_article_image>\n\n    <div itemprop=\"articleBody\">\n        <txp:body />\n    </div>\n\n    <p>\n        <strong>\n            <txp:text item=\"author\" />\n        </strong>\n        <span itemprop=\"author\" itemscope itemtype=\"https://schema.org/Person\">\n            <span itemprop=\"name\">\n                <txp:author link this_section />\n            </span>\n        </span>\n\n        <!-- only display categories if they are actually set for an article, otherwise omit -->\n        <txp:if_article_category>\n            <br>\n            <strong>\n                <txp:text item=\"categories\" />\n            </strong>\n            <span itemprop=\"keywords\">\n                <txp:category_list categories=\'<txp:category1 />,<txp:category2 />\' children=\"0\" break=\", \" trim>\n                    <txp:category title link />\n                </txp:category_list>\n            </span>\n        </txp:if_article_category>\n    </p>\n\n    <!-- if this is an individual article then add the comments section via form: comments_display.article.txp -->\n    <txp:if_individual_article>\n        <txp:output_form form=\"comments_display\" />\n    </txp:if_individual_article>\n\n</article>','four-point-eight',NULL),('search_results','article','<li class=\"article\" itemscope itemtype=\"https://schema.org/Article\">\n    <h4 itemprop=\"headline\">\n        <a href=\"<txp:permlink />\" itemprop=\"url mainEntityOfPage\" title=\"<txp:text item=\"read_more\" />\">\n            <txp:title />\n        </a>\n    </h4>\n\n    <!-- if the article has an excerpt, display that, otherwise show highlighted keywords in context of article -->\n    <txp:if_excerpt>\n        <div itemprop=\"description\">\n            <txp:excerpt />\n        </div>\n    <txp:else />\n        <p>\n            <txp:search_result_excerpt />\n        </p>\n    </txp:if_excerpt>\n\n    <p class=\"footnote\">\n        <txp:text item=\"posted\" />\n        <time datetime=\"<txp:posted format=\"iso8601\" />\" itemprop=\"datePublished\">\n            <txp:posted />\n        </time>\n        <meta itemprop=\"dateModified\" content=\"<txp:modified format=\"iso8601\" />\" />\n        &#183;\n        <txp:text item=\"author\" />\n        <span itemprop=\"author\" itemscope itemtype=\"https://schema.org/Person\">\n            <span itemprop=\"name\">\n                <txp:author link this_section />\n            </span>\n        </span>\n    </p>\n</li>','four-point-eight',NULL),('plainlinks','link','<!-- This is being used as an external links form, therefore rel is set to \'external\' -->\n<txp:linkdesctitle rel=\"external\" />','four-point-eight',NULL),('comment_form','comment','<p>\n    <txp:text item=\"enter_comment_here\" />\n</p>\n\n<!-- if there is an error, then inform user -->\n<txp:if_comments_error>\n    <txp:comments_error class=\"error_message\" wraptag=\"ol\" break=\"li\" />\n</txp:if_comments_error>\n\n<p class=\"large\">\n    <label for=\"name\">\n        <txp:text item=\"comment_name\" />\n        <b class=\"required\" title=\"<txp:text item=\"required\" />\">*</b>\n    </label>\n    <br>\n    <txp:comment_name_input size=\"32\" />\n</p>\n\n<p class=\"large\">\n    <label for=\"email\">\n        <txp:text item=\"comment_email\" />\n        <b class=\"required\" title=\"<txp:text item=\"required\" />\">*</b>\n    </label>\n    <br>\n    <txp:comment_email_input size=\"32\" />\n</p>\n\n<p class=\"large\">\n    <label for=\"web\">\n        <txp:text item=\"comment_web\" />\n    </label>\n    <br>\n    <txp:comment_web_input size=\"32\" />\n</p>\n\n<p class=\"small\">\n    <label for=\"message\">\n        <txp:text item=\"comment_message\" />\n        <b class=\"required\" title=\"<txp:text item=\"required\" />\">*</b>\n    </label>\n    <br>\n    <txp:comment_message_input cols=\"64\" rows=\"4\" />\n</p>\n\n<!-- preview and submit buttons (note: submit button will have a class of \'disabled\'\n     applied until you have previewed the message at least once) -->\n<p>\n    <txp:comment_preview />\n    <txp:comment_submit />\n</p>','four-point-eight',NULL),('popup_comments','comment','<!DOCTYPE html>\n<html lang=\"<txp:lang />\" dir=\"<txp:text item=\"lang_dir\" />\">\n\n<head>\n    <meta charset=\"utf-8\">\n    <meta name=\"viewport\" content=\"width=device-width, initial-scale=1, viewport-fit=cover\">\n    <title><txp:page_title /></title>\n\n    <!-- CSS -->\n    <txp:css format=\"link\" media=\"\" />\n    <!-- ...or you can use (faster) external CSS files e.g. <link rel=\"stylesheet\" href=\"<txp:page_url type=\"theme_path\" />/styles/default.css\"> -->\n\n    <meta name=\"generator\" content=\"Textpattern CMS\">\n    <meta name=\"robots\" content=\"noindex, follow\">\n</head>\n\n<body class=\"popup-page\">\n    <div class=\"wrapper\">\n        <div class=\"container\">\n\n            <!-- this form is only used if you set \'Comments mode\' to \'popup\' format in preferences -->\n            <txp:popup_comments />\n\n        </div> <!-- /.container -->\n    </div> <!-- /.wrapper -->\n</body>\n</html>','four-point-eight',NULL),('comments','comment','<!-- load the comment email into a variable. you will be using this below along with author email variable loaded in form: default.article.txp\n     then check the comment email variable against article author email variable, and if it matches add \'comments-author\' class -->\n<txp:variable name=\"this_comment\" value=\'<txp:comment_email />\' />\n<txp:if_variable name=\"this_comment\" value=\'<txp:author_email />\'>\n    <article class=\"comments comments-author\" itemscope itemtype=\"https://schema.org/Comment\">\n<txp:else />\n    <article class=\"comments\" itemscope itemtype=\"https://schema.org/Comment\">\n</txp:if_variable>\n\n    <h4>\n        <span class=\"comment-author\" itemprop=\"author\" itemscope itemtype=\"https://schema.org/Person\">\n            <span itemprop=\"name\">\n                <txp:comment_name />\n            </span>\n        </span>\n\n        <!-- ...now check the comment email variable against article author email variable, and if it matches add \'(author)\' text -->\n        <txp:if_variable name=\"this_comment\" value=\'<txp:author_email />\'>\n            <span class=\"is-author\">\n                (<txp:text item=\"author\" />)\n            </span>\n        </txp:if_variable>\n\n        <!-- add a permlink so people can link direct to this comment -->\n        <span class=\"comment-anchor\" itemprop=\"url\">\n            <txp:comment_permlink>#</txp:comment_permlink>\n        </span>\n\n    </h4>\n\n    <!-- also add a \'since\' to show comment freshness -->\n    <p class=\"footnote\">\n        <time datetime=\"<txp:comment_time format=\"iso8601\" />\" itemprop=\"dateCreated\">\n            <txp:comment_time />\n            (<txp:comment_time format=\"since\" />)\n        </time>\n    </p>\n\n    <div itemprop=\"text\">\n        <txp:comment_message />\n    </div>\n\n</article>','four-point-eight',NULL),('comments_display','comment','<!-- if there are comments, display them (note: example code below overrides the global preference setting for comments wrapping by stating\n     attributes of wraptag=\"\" and break=\"\", you are instead using ol and li tags below)... -->\n<txp:if_comments>\n\n    <section id=\"comments-head\">\n        <h3>\n            <txp:text item=\"comments\" />\n        </h3>\n        <ol class=\"comments-list\">\n\n            <txp:comments wraptag=\"\" break=\"li\" /> <!-- links by default to form: \'comments.comment.txp\' unless you specify a different form -->\n\n            <!-- if this is a comment preview, display it (but only if there is no error) -->\n            <txp:if_comments_preview>\n                <li>\n                    <p id=\"cpreview\">\n                        <txp:text item=\"press_preview_then_submit\" />\n                    </p>\n\n                    <!-- links by default to form: \'comments.comment.txp\' unless you specify a different form -->\n                    <txp:comments_preview wraptag=\"\" />\n\n                </li>\n            </txp:if_comments_preview>\n\n        </ol>\n\n<!-- else if there are no comments yet and user is currently previewing comment, display it (but only if there is no error) -->\n<txp:else />\n\n    <txp:if_comments_preview>\n        <section id=\"comments-head\">\n            <h3>\n                <txp:text item=\"comments\" />\n            </h3>\n            <ol class=\"comments-list\">\n                <li>\n                    <p id=\"cpreview\">\n                        <txp:text item=\"press_preview_then_submit\" />\n                    </p>\n\n                    <!-- links by default to form: \'comments.comment.txp\' unless you specify a different form -->\n                    <txp:comments_preview wraptag=\"\" />\n\n                </li>\n            </ol>\n\n<!-- else just display that there are simply no comments whatsoever :( ...but only if comments are allowed -->\n    <txp:else />\n\n        <txp:if_comments_allowed>\n            <section id=\"comments-head\">\n                <h3>\n                    <txp:text item=\"comments\" />\n                </h3>\n                <p>\n                    <txp:text item=\"no_comments\" />\n                </p>\n\n        </txp:if_comments_allowed>\n    </txp:if_comments_preview>\n</txp:if_comments>\n\n<!-- next, if new comments are allowed for this article then display comment form -->\n<txp:if_comments_allowed>\n\n    <section id=\"comments-form\">\n\n        <!-- comment invite text is taken for the article\'s comment invitation field on the \'write\' screen -->\n        <h3>\n            <txp:comments_invite showcount=\"0\" textonly showalways />\n        </h3>\n\n        <!-- links by default to form: \'comment_form.comment.txp\' unless you specify a different form -->\n        <txp:comments_form />\n\n    </section>\n\n<!-- else display a comments expired message ...but only if comments had previously been allowed -->\n<txp:else />\n\n    <txp:if_comments>\n        <p>\n            <strong>\n                <txp:text item=\"comments_expired\" />\n            </strong>\n        </p>\n    </txp:if_comments>\n\n</txp:if_comments_allowed>\n\n<!-- if a comments section was rendered above, close the tag -->\n<txp:if_comments>\n    </section>\n<txp:else />\n    <txp:if_comments_allowed>\n        </section>\n    </txp:if_comments_allowed>\n</txp:if_comments>','four-point-eight',NULL),('files','file','<div itemscope itemtype=\"https://schema.org/DataDownload\">\n\n    <!-- ...if exists, use the file title, otherwise use file name -->\n    <a href=\"<txp:file_download_link />\" itemprop=\"url contentUrl\">\n        <strong itemprop=\"name\">\n            <txp:evaluate>\n                <txp:file_download_name title />\n            <txp:else />\n                <txp:file_download_name />\n            </txp:evaluate>\n        </strong>\n    </a>\n\n    <!-- ...if exists, use the file description, otherwise omit that line -->\n    <txp:evaluate test>\n        <div itemprop=\"description\">\n            <txp:file_download_description />\n        </div>\n    </txp:evaluate>\n\n    <div class=\"footnote\">\n\n        <!-- ...if exists, use the file category, otherwise omit that line -->\n        <txp:evaluate test=\"file_download_category\">\n            <strong>\n                <txp:text item=\"category\" />\n            </strong>\n            <span itemprop=\"keywords\">\n                <txp:file_download_category title />\n            </span>\n            &#183;\n        </txp:evaluate>\n\n        <strong>\n            <txp:text item=\"author\" />\n        </strong>\n        <span itemprop=\"author\" itemscope itemtype=\"https://schema.org/Person\">\n            <span itemprop=\"name\">\n                <txp:file_download_author link />\n            </span>\n        </span>\n        &#183;\n        <strong>\n            <txp:text item=\"file_size\" />\n        </strong>\n        <span itemprop=\"contentSize\">\n            <txp:file_download_size />\n        </span>\n        &#183;\n        <strong>\n            <txp:text item=\"last_modified\" />\n        </strong>\n        <time datetime=\"<txp:file_download_modified format=\"iso8601\" />\" itemprop=\"dateModified\">\n            <txp:file_download_modified />\n        </time>\n        &#183;\n        <strong>\n            <txp:text item=\"download_count\" />\n        </strong>\n        <span itemprop=\"interactionStatistic\" itemscope itemtype=\"https://schema.org/InteractionCounter\">\n            <meta itemprop=\"interactionType\" content=\"https://schema.org/DownloadAction\" />\n            <span itemprop=\"userInteractionCount\">\n                <txp:file_download_downloads />\n            </span>\n        </span>\n\n    </div>\n\n</div>','four-point-eight',NULL),('search_input','misc','<div class=\"search\" aria-label=\"<txp:text item=\"search\" />\" itemscope itemtype=\"https://schema.org/WebSite\">\n    <meta itemprop=\"url\" content=\"<txp:site_url />\">\n    <form role=\"search\" method=\"get\" action=\"<txp:site_url />\" itemprop=\"potentialAction\" itemscope itemtype=\"https://schema.org/SearchAction\">\n        <meta itemprop=\"target\" content=\"<txp:site_url />?q={q}\">\n        <label class=\"accessibility\" for=\"search\"><txp:text item=\"search\" /></label>\n        <input id=\"search\" name=\"q\" type=\"search\" itemprop=\"query-input\" placeholder=\"<txp:text item=\"search\" />\"<txp:if_search> value=\"<txp:search_term />\"</txp:if_search>>\n    </form>\n</div>','four-point-eight',NULL),('body_footer','misc','<footer class=\"site-footer\">\n    <p><small><txp:text item=\"published_with\" /> <a rel=\"external\" href=\"https://textpattern.com/\" title=\"<txp:text item=\"go_txp_com\" />\">Textpattern CMS</a></small></p>\n</footer>','four-point-eight',NULL),('body_aside','misc','<aside class=\"complementary-content\">\n    <!-- feed links, default flavor is RSS, so we don\'t need to specify a flavor on the first feed_link -->\n    <p><txp:feed_link class=\"feed-rss\" label=\"RSS\" /> / <txp:feed_link class=\"feed-atom\" flavor=\"atom\" label=\"Atom\" /></p>\n\n    <!-- if links exist, renders a links list -->\n    <txp:evaluate test=\"linklist\">\n        <section>\n            <h4><txp:text item=\"links\" /></h4>\n            <!-- links by default to form: \'plainlinks.txp\' unless you specify a different form -->\n            <txp:linklist wraptag=\"ul\" break=\"li\" />\n        </section>\n    </txp:evaluate>\n</aside>','four-point-eight',NULL),('search_display','misc','<h1 itemprop=\"name\"><txp:text item=\"search_results\" /></h1>\n\n<txp:if_search_results>\n\n    <!-- if search result count greater than 200 then display excessive results message, otherwise show search result count -->\n    <txp:if_search_results max=\"200\">\n        <h3>\n            <txp:search_result_count />\n            <txp:text item=\"matching_search_request\" />\n            <q><txp:search_term /></q>\n        </h3>\n    <txp:else />\n        <h3>\n            <txp:text item=\"too_common_search_term\" />\n            <q><txp:search_term /></q>\n        </h3>\n    </txp:if_search_results>\n\n<!-- if no search results, then display no search results message -->\n<txp:else />\n    <h3>\n        <txp:text item=\"no_search_matches\" />\n    </h3>\n\n</txp:if_search_results>\n\n<!-- display resulting articles (10 per page; default setting) -->\n<txp:article class=\"article-list\" wraptag=\"ul\" />\n\n<!-- check if there are further results and provide pagination links depending on the result -->\n<txp:if_search_results min=\"11\">\n    <nav class=\"paginator\" aria-label=\"<txp:text item=\"page_nav\" />\">\n        <txp:evaluate>\n            <txp:newer rel=\"prev\">\n                <txp:text item=\"prev\" />\n            </txp:newer>\n            <txp:older rel=\"next\">\n                <txp:text item=\"next\" />\n            </txp:older>\n        </txp:evaluate>\n    </nav>\n</txp:if_search_results>','four-point-eight',NULL),('images','misc','<!-- set up a variable to check whether an image also has a caption associated with it... -->\n<txp:variable name=\"caption\" value=\'<txp:image_info />\' />\n\n<!-- ...now use that image caption and wrap img inside a figure with figcaption tags, otherwise just use a plain img tag -->\n<txp:if_variable name=\"caption\" value=\"\">\n\n    <p itemprop=\"image\" itemscope itemtype=\"https://schema.org/ImageObject\">\n        <img loading=\"lazy\" itemprop=\"url contentUrl\" src=\"<txp:image_url link=\'0\' />\" alt=\"<txp:image_info type=\'alt\' />\">\n        <meta itemprop=\"width\" content=\"<txp:image_info type=\"w\" />\">\n        <meta itemprop=\"height\" content=\"<txp:image_info type=\"h\" />\">\n    </p>\n\n<txp:else />\n\n    <figure itemprop=\"image\" itemscope itemtype=\"https://schema.org/ImageObject\">\n\n        <img loading=\"lazy\" itemprop=\"url contentUrl\" src=\"<txp:image_url link=\'0\' />\" alt=\"<txp:image_info type=\'alt\' />\">\n        <meta itemprop=\"width\" content=\"<txp:image_info type=\"w\" />\">\n        <meta itemprop=\"height\" content=\"<txp:image_info type=\"h\" />\">\n\n        <!-- you do not need to specify the attribute type=\"caption\" as that is the default setting for <txp:image_info /> tag -->\n        <figcaption itemprop=\"caption\">\n            <txp:image_info />\n        </figcaption>\n\n    </figure>\n\n</txp:if_variable>','four-point-eight',NULL),('body_header','misc','<a class=\"skip-link\" href=\"#main\"><txp:text item=\"go_content\" /></a>\n\n<header class=\"site-header\">\n    <h2><txp:link_to_home><txp:site_name /></txp:link_to_home></h2>\n    <txp:evaluate>\n        <h3><txp:site_slogan /></h3>\n    </txp:evaluate>\n</header>\n\n<nav id=\"navigation\" class=\"site-navigation\" aria-label=\"<txp:text item=\"site_nav\" />\" itemscope itemtype=\"https://schema.org/SiteNavigationElement\">\n    <div>\n        <txp:section_list default_title=\'<txp:text item=\"home\" />\' include_default wraptag=\"ul\" break=\"\">\n            <txp:if_status>\n                <li<txp:if_section name=\'<txp:section />\'> class=\"active\"</txp:if_section>>\n                    <a itemprop=\"url\" href=\"<txp:section url />\"<txp:if_section name=\'<txp:section />\'> aria-current=\"page\"</txp:if_section>>\n                        <txp:section title />\n                    </a>\n                </li>\n            <txp:else />\n                <li>\n                    <a itemprop=\"url\" href=\"<txp:section url />\">\n                        <txp:section title />\n                    </a>\n                </li>\n            </txp:if_status>\n        </txp:section_list>\n\n        <!-- links by default to form: \'search_input.txp\' unless you specify a different form -->\n        <txp:search_input />\n    </div>\n</nav>','four-point-eight',NULL);

--
-- Table structure for table `txttxp_image`
--

CREATE TABLE `txttxp_image` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) NOT NULL DEFAULT '',
  `category` varchar(64) NOT NULL DEFAULT '',
  `ext` varchar(20) NOT NULL DEFAULT '',
  `w` int(11) NOT NULL DEFAULT 0,
  `h` int(11) NOT NULL DEFAULT 0,
  `alt` varchar(255) NOT NULL DEFAULT '',
  `caption` text NOT NULL,
  `date` datetime NOT NULL,
  `author` varchar(64) NOT NULL DEFAULT '',
  `thumbnail` int(11) NOT NULL DEFAULT 0,
  `thumb_w` int(11) NOT NULL DEFAULT 0,
  `thumb_h` int(11) NOT NULL DEFAULT 0,
  PRIMARY KEY (`id`),
  KEY `author_idx` (`author`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `txttxp_image`
--


--
-- Table structure for table `txttxp_lang`
--

CREATE TABLE `txttxp_lang` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `lang` varchar(16) NOT NULL,
  `name` varchar(64) NOT NULL,
  `event` varchar(64) NOT NULL,
  `owner` varchar(64) NOT NULL DEFAULT '',
  `data` text DEFAULT NULL,
  `lastmod` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
  PRIMARY KEY (`id`),
  UNIQUE KEY `lang` (`lang`,`name`),
  KEY `lang_2` (`lang`,`event`),
  KEY `owner` (`owner`)
) ENGINE=MyISAM AUTO_INCREMENT=1077 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `txttxp_lang`
--



--
-- Table structure for table `txttxp_link`
--

CREATE TABLE `txttxp_link` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `date` datetime NOT NULL,
  `category` varchar(64) NOT NULL DEFAULT '',
  `url` text NOT NULL,
  `linkname` varchar(255) NOT NULL DEFAULT '',
  `linksort` varchar(128) NOT NULL DEFAULT '',
  `description` text NOT NULL,
  `author` varchar(64) NOT NULL DEFAULT '',
  PRIMARY KEY (`id`),
  KEY `author_idx` (`author`)
) ENGINE=MyISAM AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `txttxp_link`
--

INSERT INTO `txttxp_link` VALUES (1,'2023-01-30 20:20:02','textpattern','https://textpattern.com/','Textpattern website','10','',''),(2,'2023-01-30 20:20:02','textpattern','https://docs.textpattern.com/','Textpattern user documentation','20','',''),(3,'2023-01-30 20:20:02','textpattern','https://textpattern.com/github','Textpattern on GitHub','30','',''),(4,'2023-01-30 20:20:02','textpattern','https://textpattern.com/@textpattern','Textpattern on Twitter','40','','');

--
-- Table structure for table `txttxp_log`
--

CREATE TABLE `txttxp_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `time` datetime NOT NULL,
  `page` varchar(255) NOT NULL DEFAULT '',
  `refer` mediumtext NOT NULL,
  `status` int(11) NOT NULL DEFAULT 200,
  `method` varchar(16) NOT NULL DEFAULT 'GET',
  PRIMARY KEY (`id`),
  KEY `time` (`time`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `txttxp_log`
--


--
-- Table structure for table `txttxp_page`
--

CREATE TABLE `txttxp_page` (
  `name` varchar(255) NOT NULL DEFAULT '',
  `user_html` text NOT NULL,
  `skin` varchar(63) NOT NULL DEFAULT 'default',
  `lastmod` datetime DEFAULT NULL,
  UNIQUE KEY `name_skin` (`name`(63),`skin`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `txttxp_page`
--

INSERT INTO `txttxp_page` VALUES ('default','<!DOCTYPE html>\n<html lang=\"<txp:lang />\" dir=\"<txp:text item=\"lang_dir\" />\">\n\n<head>\n    <meta charset=\"utf-8\">\n    <meta name=\"viewport\" content=\"width=device-width, initial-scale=1, viewport-fit=cover\">\n    <title><txp:page_title /></title>\n\n    <!-- CSS -->\n    <txp:css format=\"link\" media=\"\" />\n    <!-- ...or you can use (faster) external CSS files e.g. <link rel=\"stylesheet\" href=\"<txp:page_url type=\"theme_path\" />/styles/default.css\"> -->\n\n    <meta name=\"generator\" content=\"Textpattern CMS\">\n\n    <txp:if_search>\n        <meta name=\"robots\" content=\"none\">\n    <txp:else />\n        <txp:if_author>\n            <meta name=\"robots\" content=\"noindex, follow\">\n        <txp:else />\n            <txp:meta_description />\n            <txp:if_category>\n                <meta name=\"robots\" content=\"noindex, follow\">\n            <txp:else />\n                <txp:variable name=\"page\" value=\'<txp:page_url type=\"pg\" />\' />\n                <txp:if_variable name=\"page\" value=\"1\">\n                    <meta name=\"robots\" content=\"index, follow\">\n                    <link rel=\"canonical\" href=\"<txp:site_url />\">\n                    <script type=\"application/ld+json\">\n                        {\n                            \"@context\": \"https://schema.org\",\n                            \"@type\": \"WebSite\",\n                            \"headline\": \"<txp:site_name escape=\"json\" />\",\n                            <txp:if_description>\"description\": \"<txp:meta_description format=\"\" escape=\"json\" />\",</txp:if_description>\n                            \"url\": \"<txp:site_url escape=\"json\" />\"\n                        }\n                    </script>\n                <txp:else />\n                    <meta name=\"robots\" content=\"noindex, follow\">\n                </txp:if_variable>\n                <txp:variable name=\"front-page\" value=\"1\" />\n            </txp:if_category>\n        </txp:if_author>\n    </txp:if_search>\n\n    <!-- content feeds -->\n    <txp:feed_link flavor=\"atom\" format=\"link\" label=\"Atom\" />\n    <txp:feed_link flavor=\"rss\" format=\"link\" label=\"RSS\" />\n</head>\n\n<txp:if_variable name=\"front-page\">\n    <body class=\"front-page\" itemscope itemtype=\"https://schema.org/WebPage\">\n<txp:else />\n    <txp:if_search>\n        <body class=\"search-page\" itemscope itemtype=\"https://schema.org/SearchResultsPage\">\n    <txp:else />\n        <body class=\"listing-page\" itemscope itemtype=\"https://schema.org/CollectionPage\">\n    </txp:if_search>\n</txp:if_variable>\n\n    <txp:output_form form=\"body_header\" />\n\n    <div class=\"wrapper\">\n        <div class=\"container\">\n\n            <!-- Main content -->\n            <main id=\"main\" aria-label=\"<txp:text item=\"main_content\" />\" itemscope itemtype=\"https://schema.org/Blog\">\n\n                <!-- is this the search result page? also omits the pagination links below (uses pagination format within search_display.txp instead) -->\n                <txp:if_search>\n                    <txp:output_form form=\"search_display\" />\n\n                <txp:else />\n                    <!-- else is this the front page? -->\n                    <txp:if_variable name=\"front-page\">\n                        <!-- links by default to form: \'default.txp\' unless you specify a different form -->\n                        <txp:article limit=\"5\" />\n\n                    <txp:else />\n                        <!-- else is this an article author list? -->\n                        <txp:if_author>\n                            <h1 itemprop=\"name\"><txp:text item=\"author\" /> <txp:author /></h1>\n\n                        <txp:else />\n                            <!-- else is this an article category list? -->\n                            <txp:if_category>\n                                <h1 itemprop=\"name\"><txp:text item=\"category\" /> <txp:category title /></h1>\n                            </txp:if_category>\n                        </txp:if_author>\n                        <txp:article form=\"article_listing\" limit=\"10\" wraptag=\"ul\" class=\"article-list\" />\n                    </txp:if_variable>\n\n                    <!-- add pagination links to foot of front page/author listings/category listings if there are more articles available -->\n                    <txp:evaluate test=\"newer,older\">\n                        <nav class=\"paginator\" aria-label=\"<txp:text item=\"page_nav\" />\">\n                            <txp:newer rel=\"prev\">\n                                <txp:text item=\"newer\" />\n                            </txp:newer>\n                            <txp:older rel=\"next\">\n                                <txp:text item=\"older\" />\n                            </txp:older>\n                        </nav>\n                    </txp:evaluate>\n                </txp:if_search>\n\n            </main>\n\n            <txp:output_form form=\"body_aside\" />\n\n        </div> <!-- /.container -->\n    </div> <!-- /.wrapper -->\n\n    <txp:output_form form=\"body_footer\" />\n\n</body>\n</html>','four-point-eight',NULL),('error_default','<!DOCTYPE html>\n<html lang=\"<txp:lang />\" dir=\"<txp:text item=\"lang_dir\" />\">\n\n<head>\n    <meta charset=\"utf-8\">\n    <meta name=\"viewport\" content=\"width=device-width, initial-scale=1, viewport-fit=cover\">\n    <title><txp:error_status /></title>\n\n    <!-- CSS -->\n    <txp:css format=\"link\" media=\"\" />\n    <!-- ...or you can use (faster) external CSS files e.g. <link rel=\"stylesheet\" href=\"<txp:page_url type=\"theme_path\" />/styles/default.css\"> -->\n\n    <meta name=\"generator\" content=\"Textpattern CMS\">\n    <meta name=\"robots\" content=\"none\">\n\n    <!-- content feeds -->\n    <txp:feed_link flavor=\"atom\" format=\"link\" label=\"Atom\" />\n    <txp:feed_link flavor=\"rss\" format=\"link\" label=\"RSS\" />\n</head>\n\n<body class=\"error-page\" itemscope itemtype=\"https://schema.org/WebPage\">\n\n    <txp:output_form form=\"body_header\" />\n\n    <div class=\"wrapper\">\n        <div class=\"container\">\n\n            <!-- Main content -->\n            <main id=\"main\" aria-label=\"<txp:text item=\"main_content\" />\">\n                <h1 class=\"error-status\"><txp:error_status /></h1>\n                <p class=\"error-msg\"><txp:error_message /></p>\n            </main>\n\n            <txp:output_form form=\"body_aside\" />\n\n        </div> <!-- /.container -->\n    </div> <!-- /.wrapper -->\n\n    <txp:output_form form=\"body_footer\" />\n\n</body>\n</html>','four-point-eight',NULL),('archive','<!DOCTYPE html>\n<html lang=\"<txp:lang />\" dir=\"<txp:text item=\"lang_dir\" />\">\n\n<head>\n    <meta charset=\"utf-8\">\n    <meta name=\"viewport\" content=\"width=device-width, initial-scale=1, viewport-fit=cover\">\n    <title><txp:page_title /></title>\n\n    <!-- CSS -->\n    <txp:css format=\"link\" media=\"\" />\n    <!-- ...or you can use (faster) external CSS files e.g. <link rel=\"stylesheet\" href=\"<txp:page_url type=\"theme_path\" />/styles/default.css\"> -->\n\n    <meta name=\"generator\" content=\"Textpattern CMS\">\n\n    <txp:if_search>\n        <meta name=\"robots\" content=\"none\">\n    <txp:else />\n        <txp:if_author>\n            <meta name=\"robots\" content=\"noindex, follow\">\n        <txp:else />\n            <txp:meta_description />\n            <txp:if_article_list>\n                <txp:variable name=\"page\" value=\'<txp:page_url type=\"pg\" />\' />\n                <txp:if_variable name=\"page\" value=\"1\">\n                    <meta name=\"robots\" content=\"index, follow\">\n                    <link rel=\"canonical\" href=\"<txp:section url />\">\n                    <script type=\"application/ld+json\">\n                        {\n                            \"@context\": \"https://schema.org\",\n                            \"@type\": \"Blog\",\n                            \"headline\": \"<txp:section title escape=\"json\" />\",\n                            <txp:if_description>\"description\": \"<txp:meta_description format=\"\" escape=\"json\" />\",</txp:if_description>\n                            \"url\": \"<txp:section url escape=\"json\" />\"\n                        }\n                    </script>\n                <txp:else />\n                    <meta name=\"robots\" content=\"noindex, follow\">\n                </txp:if_variable>\n            <txp:else />\n                <txp:meta_keywords separator=\",\" />\n                <txp:meta_author title />\n                <meta name=\"robots\" content=\"<txp:if_expires>unavailable_after: <txp:expires gmt format=\"%d-%b-%y %T\" /> GMT<txp:else />index, follow</txp:if_expires>\">\n                <link rel=\"canonical\" href=\"<txp:permlink />\">\n                <meta property=\"og:site_name\" content=\"<txp:site_name />\">\n                <meta property=\"og:type\" content=\"article\">\n                <meta property=\"og:title\" content=\"<txp:title />\">\n                <txp:if_description><meta property=\"og:description\" content=\"<txp:meta_description format=\"\" />\"></txp:if_description>\n                <meta property=\"og:url\" content=\"<txp:permlink />\">\n                <txp:if_article_image>\n                    <txp:images limit=\"1\">\n                        <meta property=\"og:image\" content=\"<txp:image_url />\">\n                        <meta property=\"og:image:width\" content=\"<txp:image_info type=\"w\" />\">\n                        <meta property=\"og:image:height\" content=\"<txp:image_info type=\"h\" />\">\n                        <meta property=\"og:image:alt\" content=\"<txp:image_info type=\"alt\" />\">\n                    </txp:images>\n                </txp:if_article_image>\n                <script type=\"application/ld+json\">\n                    {\n                        \"@context\": \"https://schema.org\",\n                        \"@type\": \"Blog\",\n                        \"blogPost\": [{\n                            \"@type\": \"BlogPosting\",\n                            \"headline\": \"<txp:title escape=\"json\" />\",\n                            <txp:if_description>\"description\": \"<txp:meta_description format=\"\" escape=\"json\" />\",</txp:if_description>\n                            \"url\": \"<txp:permlink escape=\"json\" />\"\n                        }]\n                    }\n                </script>\n            </txp:if_article_list>\n        </txp:if_author>\n    </txp:if_search>\n\n    <!-- content feeds -->\n    <txp:feed_link flavor=\"atom\" format=\"link\" label=\"Atom\" />\n    <txp:feed_link flavor=\"rss\" format=\"link\" label=\"RSS\" />\n</head>\n\n<txp:if_search>\n    <body class=\"search-page\" itemscope itemtype=\"https://schema.org/SearchResultsPage\">\n<txp:else />\n    <txp:if_article_list>\n        <body class=\"<txp:section />-page\" itemscope itemtype=\"https://schema.org/CollectionPage\">\n    <txp:else />\n        <body class=\"<txp:section />-page\" itemscope itemtype=\"https://schema.org/WebPage\">\n    </txp:if_article_list>\n</txp:if_search>\n\n    <txp:output_form form=\"body_header\" />\n\n    <div class=\"wrapper\">\n        <div class=\"container\">\n\n            <!-- Main content -->\n            <main id=\"main\" aria-label=\"<txp:text item=\"main_content\" />\" itemscope itemtype=\"https://schema.org/Blog\">\n\n                <!-- is this the search result page? also omits the pagination links below (uses pagination format within search_display.txp instead) -->\n                <txp:if_search>\n                    <txp:output_form form=\"search_display\" />\n\n                <txp:else />\n                    <txp:if_article_list>\n\n                        <h1 itemprop=\"name\"><txp:section title /></h1>\n                        <txp:article class=\"article-list\" form=\"article_listing\" limit=\"10\" wraptag=\"ul\" />\n                        <!-- ...or if you want to list all articles from all sections instead, then replace txp:article with txp:article_custom -->\n\n                        <!-- add pagination links to foot of article listings if there are more articles available -->\n                        <txp:evaluate test=\"newer,older\">\n                            <nav class=\"paginator\" aria-label=\"<txp:text item=\"page_nav\" />\">\n                                <txp:newer rel=\"prev\">\n                                    <txp:text item=\"newer\" />\n                                </txp:newer>\n                                <txp:older rel=\"next\">\n                                    <txp:text item=\"older\" />\n                                </txp:older>\n                            </nav>\n                        </txp:evaluate>\n\n                    <txp:else />\n                        <txp:article status />\n\n                        <!-- add pagination links to foot of article if there are more articles available -->\n                        <txp:evaluate test=\"link_to_prev,link_to_next\">\n                            <nav class=\"paginator\" aria-label=\"<txp:text item=\"page_nav\" />\">\n                                <txp:link_to_prev>\n                                    <txp:text item=\"prev\" />\n                                </txp:link_to_prev>\n                                <txp:link_to_next>\n                                    <txp:text item=\"next\" />\n                                </txp:link_to_next>\n                            </nav>\n                        </txp:evaluate>\n                    </txp:if_article_list>\n                </txp:if_search>\n\n            </main>\n\n            <txp:output_form form=\"body_aside\" />\n\n        </div> <!-- /.container -->\n    </div> <!-- /.wrapper -->\n\n    <txp:output_form form=\"body_footer\" />\n\n</body>\n</html>','four-point-eight',NULL);

--
-- Table structure for table `txttxp_plugin`
--

CREATE TABLE `txttxp_plugin` (
  `name` varchar(64) NOT NULL DEFAULT '',
  `status` int(11) NOT NULL DEFAULT 1,
  `author` varchar(128) NOT NULL DEFAULT '',
  `author_uri` varchar(128) NOT NULL DEFAULT '',
  `version` varchar(255) NOT NULL DEFAULT '1.0',
  `description` text NOT NULL,
  `help` mediumtext NOT NULL,
  `code` mediumtext NOT NULL,
  `code_restore` mediumtext NOT NULL,
  `code_md5` varchar(32) NOT NULL DEFAULT '',
  `textpack` mediumtext NOT NULL,
  `data` mediumtext NOT NULL,
  `type` int(11) NOT NULL DEFAULT 0,
  `load_order` tinyint(3) unsigned NOT NULL DEFAULT 5,
  `flags` smallint(5) unsigned NOT NULL DEFAULT 0,
  UNIQUE KEY `name` (`name`),
  KEY `status_type_idx` (`status`,`type`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `txttxp_plugin`
--


--
-- Table structure for table `txttxp_prefs`
--

CREATE TABLE `txttxp_prefs` (
  `name` varchar(255) NOT NULL DEFAULT '',
  `val` text NOT NULL,
  `type` smallint(5) unsigned NOT NULL DEFAULT 2,
  `event` varchar(255) NOT NULL DEFAULT 'publish',
  `html` varchar(255) NOT NULL DEFAULT 'text_input',
  `position` smallint(5) unsigned NOT NULL DEFAULT 0,
  `user_name` varchar(64) NOT NULL DEFAULT '',
  UNIQUE KEY `prefs_idx` (`name`(185),`user_name`),
  KEY `name` (`name`(250)),
  KEY `user_name` (`user_name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `txttxp_prefs`
--

INSERT INTO `txttxp_prefs` VALUES ('img_dir','images',0,'admin','text_input',20,''),('skin_dir','themes',0,'admin','text_input',30,''),('file_base_path','/var/www/html/dm/elfotop1/textpattern/files',0,'admin','text_input',40,''),('file_max_upload_size','2000000',0,'admin','text_input',60,''),('tempdir','/var/www/html/dm/elfotop1/textpattern/textpattern/tmp',0,'admin','text_input',80,''),('plugin_cache_dir','',0,'admin','text_input',100,''),('smtp_from','',0,'admin','text_input',110,''),('publisher_email','',0,'admin','text_input',115,''),('override_emailcharset','0',0,'admin','yesnoradio',120,''),('enable_xmlrpc_server','0',0,'admin','yesnoradio',130,''),('default_event','article',0,'admin','default_event',150,''),('theme_name','hive',0,'admin','themename',160,''),('module_pophelp','1',0,'admin','module_pophelp',170,''),('advanced_options','0',0,'admin','onoffradio',200,''),('comments_on_default','0',0,'comments','yesnoradio',20,''),('comments_default_invite','Comment',0,'comments','text_input',40,''),('comments_moderate','1',0,'comments','yesnoradio',60,''),('comments_disabled_after','42',0,'comments','weeks',80,''),('comments_auto_append','0',0,'comments','yesnoradio',100,''),('comments_mode','0',0,'comments','commentmode',120,''),('comments_dateformat','%b %d, %I:%M %p',0,'comments','dateformats',140,''),('comments_sendmail','0',0,'comments','commentsendmail',160,''),('comments_are_ol','1',0,'comments','yesnoradio',180,''),('comment_means_site_updated','1',0,'comments','yesnoradio',200,''),('comments_require_name','1',0,'comments','yesnoradio',220,''),('comments_require_email','1',0,'comments','yesnoradio',240,''),('never_display_email','1',0,'comments','yesnoradio',260,''),('comment_nofollow','1',0,'comments','yesnoradio',280,''),('comments_disallow_images','0',0,'comments','yesnoradio',300,''),('comments_use_fat_textile','0',0,'comments','yesnoradio',320,''),('spam_blacklists','',0,'comments','text_input',340,''),('custom_1_set','custom1',0,'custom','custom_set',1,''),('custom_2_set','custom2',0,'custom','custom_set',2,''),('custom_3_set','',0,'custom','custom_set',3,''),('custom_4_set','',0,'custom','custom_set',4,''),('custom_5_set','',0,'custom','custom_set',5,''),('custom_6_set','',0,'custom','custom_set',6,''),('custom_7_set','',0,'custom','custom_set',7,''),('custom_8_set','',0,'custom','custom_set',8,''),('custom_9_set','',0,'custom','custom_set',9,''),('custom_10_set','',0,'custom','custom_set',10,''),('syndicate_body_or_excerpt','1',0,'feeds','yesnoradio',20,''),('rss_how_many','5',0,'feeds','text_input',40,''),('show_comment_count_in_feed','1',0,'feeds','yesnoradio',60,''),('include_email_atom','0',0,'feeds','yesnoradio',80,''),('use_mail_on_feeds_id','0',0,'feeds','yesnoradio',100,''),('articles_use_excerpts','1',0,'publish','yesnoradio',40,''),('allow_form_override','1',0,'publish','yesnoradio',60,''),('override_form_types','article',0,'publish','overrideTypes',70,''),('attach_titles_to_permalinks','1',0,'publish','yesnoradio',80,''),('permlink_format','1',0,'publish','permlink_format',100,''),('send_lastmod','1',0,'publish','yesnoradio',120,''),('publish_expired_articles','0',0,'publish','yesnoradio',130,''),('use_textile','1',0,'publish','pref_text',200,''),('enable_short_tags','1',0,'publish','yesnoradio',230,''),('use_plugins','1',0,'publish','yesnoradio',260,''),('admin_side_plugins','1',0,'publish','yesnoradio',280,''),('allow_page_php_scripting','1',0,'publish','yesnoradio',300,''),('allow_article_php_scripting','1',0,'publish','yesnoradio',320,''),('max_url_len','1000',0,'publish','text_input',340,''),('blog_mail_uid','aa9ffacd72e1d09849b6ec1b949547d0blog@example.com',2,'publish','text_input',0,''),('blog_time_uid','2005',2,'publish','text_input',0,''),('blog_uid','aac5f2a72b05f2c545e8e3710eea891a',2,'publish','text_input',0,''),('dbupdatetime','0',2,'publish','text_input',0,''),('language','en',2,'publish','text_input',0,''),('lastmod','2005-07-23 16:24:10',2,'publish','text_input',0,''),('locale','en_US.UTF-8',2,'publish','text_input',0,''),('path_from_root','/',2,'publish','text_input',0,''),('path_to_site','/var/www/html/dm/elfotop1/textpattern',2,'publish','text_input',0,''),('searchable_article_fields','Title, Body',2,'publish','text_input',0,''),('textile_updated','1',2,'publish','text_input',0,''),('timeoffset','0',2,'publish','text_input',0,''),('timezone_key','',2,'publish','text_input',0,''),('url_mode','1',2,'publish','text_input',0,''),('use_categories','1',2,'publish','text_input',0,''),('use_sections','1',2,'publish','text_input',0,''),('sql_now_posted','2147483647',2,'publish','text_input',0,''),('sql_now_expires','2147483647',2,'publish','text_input',0,''),('sql_now_created','1675110002',2,'publish','text_input',0,''),('version','4.8.8',2,'publish','text_input',0,''),('default_section','articles',2,'section','text_input',0,''),('sitename','My site',0,'site','text_input',20,''),('siteurl','lab.mst.ihu.gr/dm/elfotop1/textpattern',0,'site','text_input',40,''),('site_slogan','My site slogan',0,'site','text_input',60,''),('production_status','testing',0,'site','prod_levels',80,''),('gmtoffset','+7200',0,'site','gmtoffset_select',110,''),('auto_dst','0',0,'site','yesnoradio',115,''),('is_dst','0',0,'site','is_dst',120,''),('dateformat','since',0,'site','dateformats',140,''),('archive_dateformat','%b %d, %I:%M %p',0,'site','dateformats',160,''),('permlink_mode','section_title',0,'site','permlinkmodes',180,''),('doctype','html5',0,'site','doctypes',190,''),('logging','none',0,'site','logging',220,''),('expire_logs_after','7',0,'site','text_input',230,''),('use_comments','0',0,'site','yesnoradio',240,''),('txp_evaluate_functions','',0,'advanced_options','text_input',100,''),('custom_form_types',';[js]\n;mediatype=\"application/javascript\"\n;title=\"JavaScript\"',0,'advanced_options','longtext_input',200,''),('secondpass','1',0,'advanced_options','text_input',300,''),('skin_delete_from_database','',2,'skin','text_input',0,'elfotop1'),('enable_dev_preview','1',0,'admin','yesnoradio',180,'elfotop1'),('language_ui','en',2,'admin','text_input',0,'elfotop1'),('default_publish_status','4',0,'publish','defaultPublishStatus',15,'elfotop1');

--
-- Table structure for table `txttxp_section`
--

CREATE TABLE `txttxp_section` (
  `name` varchar(255) NOT NULL DEFAULT '',
  `skin` varchar(63) NOT NULL DEFAULT 'default',
  `page` varchar(255) NOT NULL DEFAULT '',
  `css` varchar(255) NOT NULL DEFAULT '',
  `permlink_mode` varchar(63) NOT NULL DEFAULT '',
  `description` varchar(255) NOT NULL DEFAULT '',
  `in_rss` int(11) NOT NULL DEFAULT 1,
  `on_frontpage` int(11) NOT NULL DEFAULT 1,
  `searchable` int(11) NOT NULL DEFAULT 1,
  `title` varchar(255) NOT NULL DEFAULT '',
  `dev_skin` varchar(63) NOT NULL DEFAULT '',
  `dev_page` varchar(255) NOT NULL DEFAULT '',
  `dev_css` varchar(255) NOT NULL DEFAULT '',
  KEY `page_skin` (`page`(50),`skin`),
  KEY `css_skin` (`css`(50),`skin`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `txttxp_section`
--

INSERT INTO `txttxp_section` VALUES ('default','four-point-eight','default','default','','',1,1,1,'Default','','',''),('articles','four-point-eight','archive','default','','',1,1,1,'Articles','','','');

--
-- Table structure for table `txttxp_skin`
--

CREATE TABLE `txttxp_skin` (
  `name` varchar(63) NOT NULL DEFAULT 'default',
  `title` varchar(255) NOT NULL DEFAULT 'Default',
  `version` varchar(255) DEFAULT '1.0',
  `description` varchar(10240) DEFAULT '',
  `author` varchar(255) DEFAULT '',
  `author_uri` varchar(255) DEFAULT '',
  `lastmod` datetime DEFAULT NULL,
  PRIMARY KEY (`name`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `txttxp_skin`
--

INSERT INTO `txttxp_skin` VALUES ('four-point-eight','Four Point Eight','4.8.8','The default theme shipped with Textpattern CMS 4.8.','Team Textpattern','https://github.com/textpattern/textpattern-default-theme',NULL);

--
-- Table structure for table `txttxp_token`
--

