-- Table structure for table `lfuve_scheduler_tasks`
--

CREATE TABLE `lfuve_scheduler_tasks` (
  `id` int UNSIGNED NOT NULL,
  `asset_id` int UNSIGNED NOT NULL DEFAULT '0' COMMENT 'FK to the #__assets table.',
  `title` varchar(255) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '',
  `type` varchar(128) COLLATE utf8mb4_unicode_ci NOT NULL COMMENT 'unique identifier for job defined by plugin',
  `execution_rules` text COLLATE utf8mb4_unicode_ci COMMENT 'Execution Rules, Unprocessed',
  `cron_rules` text COLLATE utf8mb4_unicode_ci COMMENT 'Processed execution rules, crontab-like JSON form',
  `state` tinyint NOT NULL DEFAULT '0',
  `last_exit_code` int 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 DEFAULT '0' COMMENT 'Count of successful triggers',
  `times_failed` int DEFAULT '0' COMMENT 'Count of failures',
  `locked` datetime DEFAULT NULL,
  `priority` smallint NOT NULL DEFAULT '0',
  `ordering` int NOT NULL DEFAULT '0' COMMENT 'Configurable list ordering',
  `cli_exclusive` smallint NOT NULL DEFAULT '0' COMMENT 'If 1, the task is only accessible via CLI',
  `params` text COLLATE utf8mb4_unicode_ci NOT NULL,
  `note` text COLLATE utf8mb4_unicode_ci,
  `created` datetime NOT NULL,
  `created_by` int UNSIGNED NOT NULL DEFAULT '0',
  `checked_out` int UNSIGNED DEFAULT NULL,
  `checked_out_time` datetime DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `lfuve_scheduler_tasks`
--

INSERT INTO `lfuve_scheduler_tasks` (`id`, `asset_id`, `title`, `type`, `execution_rules`, `cron_rules`, `state`, `last_exit_code`, `last_execution`, `next_execution`, `times_executed`, `times_failed`, `locked`, `priority`, `ordering`, `cli_exclusive`, `params`, `note`, `created`, `created_by`, `checked_out`, `checked_out_time`) VALUES
(1, 217, 'Rotate Logs', 'rotation.logs', '{\"rule-type\":\"interval-days\",\"interval-days\":30,\"exec-time\":\"06:55\",\"exec-day\":\"15\"}', '{\"type\":\"interval\",\"exp\":\"P30D\"}', 1, 0, '2024-08-18 00:40:17', '2024-09-17 00:40:17', 3, 0, NULL, 0, 0, 0, '{\"logstokeep\":1}', NULL, '2024-01-15 04:11:58', 465, NULL, NULL),
(2, 218, 'Session GC', 'session.gc', '{\"rule-type\":\"interval-hours\",\"interval-hours\":24,\"exec-time\":\"04:11\",\"exec-day\":\"15\"}', '{\"type\":\"interval\",\"exp\":\"PT24H\"}', 1, 0, '2024-08-18 00:36:06', '2024-08-19 00:36:06', 6, 0, NULL, 0, 0, 0, '{\"enable_session_gc\":1,\"enable_session_metadata_gc\":1}', NULL, '2024-01-15 04:11:58', 465, NULL, NULL),
(3, 219, 'Update Notification', 'update.notification', '{\"rule-type\":\"interval-hours\",\"interval-hours\":6,\"exec-time\":\"01:15\",\"exec-day\":\"15\"}', '{\"type\":\"interval\",\"exp\":\"PT6H\"}', 1, 5, '2024-08-18 00:31:40', '2024-08-18 06:31:40', 6, 4, NULL, 0, 0, 0, '{\"email\":\"\",\"language_override\":\"\"}', NULL, '2024-01-15 04:11:58', 465, NULL, NULL);

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

--
-- Table structure for table `lfuve_schemaorg`
--

CREATE TABLE `lfuve_schemaorg` (
  `id` int UNSIGNED NOT NULL,
  `itemId` int UNSIGNED DEFAULT NULL,
  `context` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `schemaType` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `schema` text COLLATE utf8mb4_unicode_ci
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

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

--
-- Table structure for table `lfuve_schemas`
--

CREATE TABLE `lfuve_schemas` (
  `extension_id` int NOT NULL,
  `version_id` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `lfuve_schemas`
--

INSERT INTO `lfuve_schemas` (`extension_id`, `version_id`) VALUES
(21, '4.0.0'),
(700, '5.1.1-2024-04-18'),
(10360, '');

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

--
-- Table structure for table `lfuve_securitycheckpro_online_checks`
--

CREATE TABLE `lfuve_securitycheckpro_online_checks` (
  `id` int UNSIGNED NOT NULL,
  `filename` varchar(35) NOT NULL,
  `files_checked` int DEFAULT '0',
  `threats_found` int DEFAULT '0',
  `scan_date` datetime DEFAULT NULL,
  `infected_files` varchar(300) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8mb3;

--
-- Dumping data for table `lfuve_securitycheckpro_online_checks`
--

INSERT INTO `lfuve_securitycheckpro_online_checks` (`id`, `filename`, `files_checked`, `threats_found`, `scan_date`, `infected_files`) VALUES
(1, '2s6mi3z3p6tehgdp2w13.php', 1, 0, '2016-11-28 10:27:32', ''),
(2, 'nlduq0ag3jrafuv321cf.php', 1, 0, '2016-11-28 10:30:30', ''),
(3, 'pkdyjegbh4xzlsk531f5.php', 16, 0, '2018-09-09 13:07:14', '');

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

--
-- Table structure for table `lfuve_session`
--

CREATE TABLE `lfuve_session` (
  `session_id` varbinary(192) NOT NULL,
  `client_id` tinyint UNSIGNED DEFAULT NULL,
  `guest` tinyint UNSIGNED DEFAULT '1',
  `time` int NOT NULL DEFAULT '0',
  `data` longtext CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci,
  `userid` int DEFAULT '0',
  `username` varchar(150) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci DEFAULT ''
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

--
-- Dumping data for table `lfuve_session`
--

INSERT INTO `lfuve_session` (`session_id`, `client_id`, `guest`, `time`, `data`, `userid`, `username`) VALUES
(0x64623761343268666134666b63633330683673726132756e6c68, 1, 0, 1723943630, 'joomla|s:775284:\"[encoded data, 518554 characters]