IP : 3.135.212.250Hostname : host45.registrar-servers.comKernel : Linux host45.registrar-servers.com 4.18.0-513.18.1.lve.2.el8.x86_64 #1 SMP Sat Mar 30 15:36:11 UTC 2024 x86_64Disable Function : None :) OS : Linux
PATH:
/
home/
../
var/
softaculous/
x2/
../
suitecrm/
../
flat/
../
cjdpoll/
../
fusion/
fusion.sql/
/
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO"; SET time_zone = "+00:00";
/*!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 utf8 */;
-- -- Table structure for table `[[dbprefix]]email_templates` --
CREATE TABLE `[[dbprefix]]email_templates` ( `template_id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, `template_key` varchar(20) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `template_format` varchar(10) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `template_active` tinyint(1) NOT NULL DEFAULT '0', `template_name` varchar(300) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `template_subject` text COLLATE utf8mb4_unicode_ci NOT NULL, `template_content` text COLLATE utf8mb4_unicode_ci NOT NULL, `template_sender_name` varchar(30) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `template_sender_email` varchar(100) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `template_language` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT 'English', PRIMARY KEY (`template_id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=4 ;
-- -- Dumping data for table `[[dbprefix]]email_templates` --
INSERT INTO `[[dbprefix]]email_templates` VALUES (1, 'PM', 'html', 0, 'Notification on new PM', 'You have a new private message from [USER] waiting at [SITENAME]', 'Hello [RECEIVER],<br/>You have received a new Private Message titled [SUBJECT] from [USER] at [SITENAME]. You can read your private message at <a href=''[SITEURL]messages.php''>[SITEURL]messages.php</a><br/>Message: [MESSAGE]<br/>You can disable email notification through the options panel of the Private Message page if you no longer wish to be notified of new messages.<br/>Regards,<br/>[SENDER].', '', '', 'English'), (2, 'POST', 'html', 0, 'Notification on new forum posts', 'Thread Reply Notification - [SUBJECT]', 'Hello [RECEIVER],<br/>A reply has been posted in the forum thread ''[SUBJECT]'' which you are tracking at [SITENAME]. You can use the following link to view the reply:<br/>[THREAD_URL]<br/>If you no longer wish to watch this thread you can click the ''Stop tracking this thread'' link located at the top of the thread.<br/>Regards,<br/>[SENDER].', '', '', 'English'), (3, 'CONTACT', 'html', 0, 'Contact form', '[SUBJECT]', '[MESSAGE]', '', '', 'English');
-- -- Table structure for table `[[dbprefix]]user_log` --
CREATE TABLE `[[dbprefix]]user_log` ( `userlog_id` bigint(20) unsigned NOT NULL AUTO_INCREMENT, `userlog_user_id` bigint(20) unsigned NOT NULL DEFAULT '0', `userlog_field` varchar(50) COLLATE utf8mb4_unicode_ci NOT NULL DEFAULT '', `userlog_value_new` text COLLATE utf8mb4_unicode_ci NOT NULL, `userlog_value_old` text COLLATE utf8mb4_unicode_ci NOT NULL, `userlog_timestamp` int(10) unsigned NOT NULL DEFAULT '0', PRIMARY KEY (`userlog_id`), KEY `userlog_field` (`userlog_field`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci AUTO_INCREMENT=1 ;
/*!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 */;