[Summary view] [Print] [Text view]

   1  --
   2  -- Table structure for table `#__scheduler_tasks`
   3  --
   4  
   5  CREATE TABLE IF NOT EXISTS `#__scheduler_tasks` (
   6    `id` int unsigned NOT NULL AUTO_INCREMENT,
   7    `asset_id` int unsigned NOT NULL DEFAULT 0 COMMENT 'FK to the #__assets table.',
   8    `title` varchar(255) NOT NULL DEFAULT '',
   9    `type` varchar(128) NOT NULL COMMENT 'unique identifier for job defined by plugin',
  10    `execution_rules` text COMMENT 'Execution Rules, Unprocessed',
  11    `cron_rules` text COMMENT 'Processed execution rules, crontab-like JSON form',
  12    `state` tinyint NOT NULL DEFAULT FALSE,
  13    `last_exit_code` int NOT NULL DEFAULT 0 COMMENT 'Exit code when job was last run',
  14    `last_execution` datetime COMMENT 'Timestamp of last run',
  15    `next_execution` datetime COMMENT 'Timestamp of next (planned) run, referred for execution on trigger',
  16    `times_executed` int DEFAULT 0 COMMENT 'Count of successful triggers',
  17    `times_failed` int DEFAULT 0 COMMENT 'Count of failures',
  18    `locked` datetime,
  19    `priority` smallint NOT NULL DEFAULT 0,
  20    `ordering` int NOT NULL DEFAULT 0 COMMENT 'Configurable list ordering',
  21    `cli_exclusive` smallint NOT NULL DEFAULT 0 COMMENT 'If 1, the task is only accessible via CLI',
  22    `params` text NOT NULL,
  23    `note` text,
  24    `created` datetime NOT NULL,
  25    `created_by` int UNSIGNED NOT NULL DEFAULT 0,
  26    `checked_out` int unsigned,
  27    `checked_out_time` datetime,
  28    PRIMARY KEY (id),
  29    KEY `idx_type` (`type`),
  30    KEY `idx_state` (`state`),
  31    KEY `idx_last_exit` (`last_exit_code`),
  32    KEY `idx_next_exec` (`next_execution`),
  33    KEY `idx_locked` (`locked`),
  34    KEY `idx_priority` (`priority`),
  35    KEY `idx_cli_exclusive` (`cli_exclusive`),
  36    KEY `idx_checked_out` (`checked_out`)
  37  ) ENGINE = InnoDB DEFAULT CHARSET = utf8mb4 DEFAULT COLLATE = utf8mb4_unicode_ci;
  38  
  39  -- Add `com_scheduler` to `#__extensions`
  40  INSERT INTO `#__extensions` (`package_id`, `name`, `type`, `element`, `folder`, `client_id`, `enabled`, `access`, `protected`, `locked`, `manifest_cache`, `params`, `custom_data`) VALUES
  41  (0, 'com_scheduler', 'component', 'com_scheduler', '', 1, 1, 1, 0, 1, '', '{}', '');
  42  
  43  -- Add plugins to `#__extensions`
  44  INSERT INTO `#__extensions` (`package_id`, `name`, `type`, `element`, `folder`, `client_id`, `enabled`, `access`, `protected`, `locked`, `manifest_cache`, `params`, `custom_data`, `ordering`, `state`) VALUES
  45  (0, 'plg_system_schedulerunner', 'plugin', 'schedulerunner', 'system', 0, 1, 1, 0, 0, '', '{}', '', 15, 0),
  46  (0, 'plg_system_tasknotification', 'plugin', 'tasknotification', 'system', 0, 1, 1, 0, 1, '', '', '', 22, 0),
  47  (0, 'plg_task_checkfiles', 'plugin', 'checkfiles', 'task', 0, 1, 1, 0, 0, '', '{}', '', 15, 0),
  48  (0, 'plg_task_demotasks', 'plugin', 'demotasks', 'task', 0, 1, 1, 0, 0, '', '{}', '', 15, 0),
  49  (0, 'plg_task_requests', 'plugin', 'requests', 'task', 0, 1, 1, 0, 0, '', '{}', '', 15, 0),
  50  (0, 'plg_task_sitestatus', 'plugin', 'sitestatus', 'task', 0, 1, 1, 0, 0, '', '{}', '', 15, 0);
  51  
  52  -- Add com_scheduler to action logs
  53  INSERT INTO `#__action_logs_extensions` (`extension`) VALUES ('com_scheduler');
  54  
  55  INSERT INTO `#__action_log_config` (`type_title`, `type_alias`, `id_holder`, `title_holder`, `table_name`, `text_prefix`) VALUES
  56  ('task', 'com_scheduler.task', 'id', 'title', '#__scheduler_tasks', 'PLG_ACTIONLOG_JOOMLA');
  57  
  58  -- Add mail templates
  59  -- The following statement was modified for 4.1.1 by adding the "IGNORE" keyword.
  60  -- See https://github.com/joomla/joomla-cms/pull/37156
  61  INSERT IGNORE INTO `#__mail_templates` (`template_id`, `extension`, `language`, `subject`, `body`, `htmlbody`, `attachments`, `params`) VALUES
  62  ('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"]}'),
  63  ('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"]}'),
  64  ('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"]}'),
  65  ('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"]}');