/*!999999\- enable the sandbox mode */ 
-- MariaDB dump 10.19  Distrib 10.5.25-MariaDB, for Linux (x86_64)
--
-- Host: localhost    Database: leimatfi_joomla
-- ------------------------------------------------------
-- Server version	10.5.25-MariaDB-cll-lve

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `xrx2w_mail_templates`
--

DROP TABLE IF EXISTS `xrx2w_mail_templates`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `xrx2w_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;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `xrx2w_mail_templates`
--

LOCK TABLES `xrx2w_mail_templates` WRITE;
/*!40000 ALTER TABLE `xrx2w_mail_templates` DISABLE KEYS */;
INSERT INTO `xrx2w_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_admintools.adminloginfail','com_admintools','','COM_ADMINTOOLS_EMAIL_ADMINLOGINFAIL_SUBJECT','COM_ADMINTOOLS_EMAIL_ADMINLOGINFAIL_BODY','COM_ADMINTOOLS_EMAIL_ADMINLOGINFAIL_BODY_HTML','','{\"tags\":[\"USER\",\"SITENAME\",\"DATE\",\"IP\",\"URL\",\"LOOKUP\",\"UA\",\"RESCUEINFO\",\"RESCUE_TRIGGER_URL\"]}'),('com_admintools.adminloginsuccess','com_admintools','','COM_ADMINTOOLS_EMAIL_ADMINLOGINSUCCESS_SUBJECT','COM_ADMINTOOLS_EMAIL_ADMINLOGINSUCCESS_BODY','COM_ADMINTOOLS_EMAIL_ADMINLOGINSUCCESS_BODY_HTML','','{\"tags\":[\"USER\",\"SITENAME\",\"DATE\",\"IP\",\"URL\",\"LOOKUP\",\"UA\",\"RESCUEINFO\",\"RESCUE_TRIGGER_URL\"]}'),('com_admintools.blockedrequest','com_admintools','','COM_ADMINTOOLS_EMAIL_BLOCKEDREQUEST_SUBJECT','COM_ADMINTOOLS_EMAIL_BLOCKEDREQUEST_BODY','COM_ADMINTOOLS_EMAIL_BLOCKEDREQUEST_BODY_HTML','','{\"tags\":[\"INFO_HTML\",\"USER\",\"SITENAME\",\"DATE\",\"IP\",\"URL\",\"LOOKUP\",\"UA\",\"RESCUEINFO\",\"RESCUE_TRIGGER_URL\"]}'),('com_admintools.configmonitor','com_admintools','','COM_ADMINTOOLS_EMAIL_CONFIGMONITOR_SUBJECT','COM_ADMINTOOLS_EMAIL_CONFIGMONITOR_BODY','COM_ADMINTOOLS_EMAIL_CONFIGMONITOR_BODY_HTML','','{\"tags\":[\"AREA\",\"USER\",\"SITENAME\",\"DATE\",\"IP\",\"URL\",\"LOOKUP\",\"UA\",\"RESCUEINFO\",\"RESCUE_TRIGGER_URL\"]}'),('com_admintools.criticalfiles','com_admintools','','COM_ADMINTOOLS_EMAIL_CRITICALFILES_SUBJECT','COM_ADMINTOOLS_EMAIL_CRITICALFILES_BODY','COM_ADMINTOOLS_EMAIL_CRITICALFILES_BODY_HTML','','{\"tags\":[\"INFO\",\"INFO_HTML\",\"USER\",\"SITENAME\",\"DATE\",\"IP\",\"URL\",\"LOOKUP\",\"UA\",\"RESCUEINFO\",\"RESCUE_TRIGGER_URL\"]}'),('com_admintools.criticalfiles_global','com_admintools','','COM_ADMINTOOLS_EMAIL_CRITICALFILES_GLOBAL_SUBJECT','COM_ADMINTOOLS_EMAIL_CRITICALFILES_GLOBAL_BODY','COM_ADMINTOOLS_EMAIL_CRITICALFILES_GLOBAL_BODY_HTML','','{\"tags\":[\"INFO\",\"INFO_HTML\",\"USER\",\"SITENAME\",\"DATE\",\"IP\",\"URL\",\"LOOKUP\",\"UA\",\"RESCUEINFO\",\"RESCUE_TRIGGER_URL\"]}'),('com_admintools.ipautoban','com_admintools','','COM_ADMINTOOLS_EMAIL_IPAUTOBAN_SUBJECT','COM_ADMINTOOLS_EMAIL_IPAUTOBAN_BODY','COM_ADMINTOOLS_EMAIL_IPAUTOBAN_BODY_HTML','','{\"tags\":[\"UNTIL\",\"USER\",\"SITENAME\",\"DATE\",\"IP\",\"URL\",\"LOOKUP\",\"UA\",\"RESCUEINFO\",\"RESCUE_TRIGGER_URL\"]}'),('com_admintools.rescueurl','com_admintools','','COM_ADMINTOOLS_EMAIL_RESCUEURL_SUBJECT','COM_ADMINTOOLS_EMAIL_RESCUEURL_BODY','COM_ADMINTOOLS_EMAIL_RESCUEURL_BODY_HTML','','{\"tags\":[\"RESCUEURL\",\"INFO_HTML\",\"USER\",\"SITENAME\",\"DATE\",\"IP\",\"URL\",\"LOOKUP\",\"UA\"]}'),('com_admintools.superuserslist','com_admintools','','COM_ADMINTOOLS_EMAIL_SUPERUSERSLIST_SUBJECT','COM_ADMINTOOLS_EMAIL_SUPERUSERSLIST_BODY','COM_ADMINTOOLS_EMAIL_SUPERUSERSLIST_BODY_HTML','','{\"tags\":[\"INFO\",\"INFO_HTML\",\"USER\",\"SITENAME\",\"DATE\",\"IP\",\"URL\",\"LOOKUP\",\"UA\",\"RESCUEINFO\",\"RESCUE_TRIGGER_URL\"]}'),('com_admintools.troubleshooting','com_admintools','','COM_ADMINTOOLS_EMAIL_TROUBLESHOOTING_SUBJECT','COM_ADMINTOOLS_EMAIL_TROUBLESHOOTING_BODY','COM_ADMINTOOLS_EMAIL_TROUBLESHOOTING_BODY_HTML','','{\"tags\":[\"USERNAME\",\"ACTION\",\"SITENAME\",\"TROUBLESHOOTING_URLS\",\"TROUBLESHOOTING_URLS_HTML\"]}'),('com_admintools.userreactivate','com_admintools','','COM_ADMINTOOLS_EMAIL_USER_REACTIVATE_SUBJECT','COM_ADMINTOOLS_EMAIL_USER_REACTIVATE_BODY','COM_ADMINTOOLS_EMAIL_USER_REACTIVATE_BODY_HTML','','{\"tags\":[\"ACTIVATE\",\"USER\",\"SITENAME\",\"DATE\",\"IP\",\"URL\",\"LOOKUP\",\"UA\",\"RESCUEINFO\",\"RESCUE_TRIGGER_URL\"]}'),('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\",\"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\",\"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_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_task_privacyconsent.request.reminder','plg_task_privacyconsent','','PLG_TASK_PRIVACYCONSENT_EMAIL_REMIND_SUBJECT','PLG_TASK_PRIVACYCONSENT_EMAIL_REMIND_BODY','','','{\"tags\":[\"sitename\",\"url\",\"tokenurl\",\"formurl\",\"token\"]}'),('plg_task_updatenotification.mail','plg_task_updatenotification','','PLG_TASK_UPDATENOTIFICATION_EMAIL_SUBJECT','PLG_TASK_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\"]}');
/*!40000 ALTER TABLE `xrx2w_mail_templates` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2024-08-01  0:48:16
