-- MySQL dump 10.13  Distrib 8.0.31, for Linux (x86_64)
--
-- Host: 192.168.1.99    Database: ech_autoresp
-- ------------------------------------------------------
-- Server version	5.7.35-log

/*!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 */;
/*!50503 SET NAMES utf8 */;
/*!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 */;
SET @MYSQLDUMP_TEMP_LOG_BIN = @@SESSION.SQL_LOG_BIN;
SET @@SESSION.SQL_LOG_BIN= 0;

--
-- GTID state at the beginning of the backup 
--



--
-- Table structure for table `mes`
--

DROP TABLE IF EXISTS `mes`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `mes` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int NOT NULL,
  `aid` int(11) DEFAULT NULL,
  `use_header` int(11) DEFAULT NULL,
  `use_footer` int(11) DEFAULT NULL,
  `subject` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `time_interval` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `default_format` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `attachments` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `cc` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `bcc` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `schedule` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `plain_text` text COLLATE utf8_unicode_ci,
  `html_text` text COLLATE utf8_unicode_ci,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `mes`
--

LOCK TABLES `mes` WRITE;
/*!40000 ALTER TABLE `mes` DISABLE KEYS */;
INSERT INTO `mes` VALUES (1,1,1,NULL,NULL,'Test Subject 1','1','T','','','','INT','AUTORESPONSE PLUS 3 TEST AUTORESPONDER\r\n\r\nThis is plain message 1\r\n\r\n{NEXT_LINK_TEXT}\r\n{NEXT_LINK}','<html>\r\n<head>\r\n<title>AutoResponse Plus 3 Test Autoresponder</title>\r\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=iso-8859-1\">\r\n</head>\r\n<body bgcolor=\"#FFFFFF\" text=\"#000000\">\r\n<table width=\"80%\" border=\"0\" cellspacing=\"0\" cellpadding=\"1\" align=\"center\">\r\n<tr>\r\n<td bgcolor=\"#003366\">\r\n<table width=\"100%\" border=\"1\" cellspacing=\"1\" cellpadding=\"4\">\r\n<tr>\r\n<td><b><font color=\"#FFFFFF\">&raquo; AutoResponse Plus 3 Test Autoresponder</font></b></td>\r\n</tr>\r\n<tr><td bgcolor=\"#FFFFFF\">\r\n<p>This is HTML message 1</p>\r\n<p>This message should be formatted in a neat table with color.</p>\r\n</td>\r\n</tr>\r\n</table\r\n</td>\r\n</tr>\r\n</table>\r\n</body>\r\n</html>'),(2,1,0,0,'Test Subject 2','1','T','','','','NEX','AUTORESPONSE PLUS 3 TEST AUTORESPONDER\n\nThis is plain message 2\n\n{NEXT_LINK_TEXT}\n{NEXT_LINK}','<html>\n<head>\n<title>AutoResponse Plus 3 Test Autoresponder</title>\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=iso-8859-1\">\n</head>\n<body bgcolor=\"#FFFFFF\" text=\"#000000\">\n<table width=\"80%\" border=\"0\" cellspacing=\"0\" cellpadding=\"1\" align=\"center\">\n<tr>\n<td bgcolor=\"#003366\">\n<table width=\"100%\" border=\"1\" cellspacing=\"1\" cellpadding=\"4\">\n<tr>\n<td><b><font color=\"#FFFFFF\">&raquo; AutoResponse Plus 3 Test Autoresponder</font></b></td>\n</tr>\n<tr><td bgcolor=\"#FFFFFF\">\n<p>This is HTML message 2</p>\n<p>This message should be formatted in a neat table with color.</p>\n</td>\n</tr>\n</table\n</td>\n</tr>\n</table>\n</body>\n</html>'),(3,1,0,0,'Test Subject 3','1','T','','','','NEX','AUTORESPONSE PLUS 3 TEST AUTORESPONDER\n\nThis is plain message 3','<html>\n<head>\n<title>AutoResponse Plus 3 Test Autoresponder</title>\n<meta http-equiv=\"Content-Type\" content=\"text/html; charset=iso-8859-1\">\n</head>\n<body bgcolor=\"#FFFFFF\" text=\"#000000\">\n<table width=\"80%\" border=\"0\" cellspacing=\"0\" cellpadding=\"1\" align=\"center\">\n<tr>\n<td bgcolor=\"#003366\">\n<table width=\"100%\" border=\"1\" cellspacing=\"1\" cellpadding=\"4\">\n<tr>\n<td><b><font color=\"#FFFFFF\">&raquo; AutoResponse Plus 3 Test Autoresponder</font></b></td>\n</tr>\n<tr><td bgcolor=\"#FFFFFF\">\n<p>This is HTML message 3</p>\n<p>This message should be formatted in a neat table with color.</p>\n</td>\n</tr>\n</table\n</td>\n</tr>\n</table>\n</body>\n</html>');
/*!40000 ALTER TABLE `mes` ENABLE KEYS */;
UNLOCK TABLES;
SET @@SESSION.SQL_LOG_BIN = @MYSQLDUMP_TEMP_LOG_BIN;
/*!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 2022-11-16 20:00:30
