-- 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 `settings`
--

DROP TABLE IF EXISTS `settings`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!50503 SET character_set_client = utf8mb4 */;
CREATE TABLE `settings` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int NOT NULL,
  `cookie_life` int(11) DEFAULT NULL,
  `time_difference` int(11) DEFAULT NULL,
  `mail_failures` int(11) DEFAULT NULL,
  `send_unconf` int(11) DEFAULT NULL,
  `subscribe_notify` int(11) DEFAULT NULL,
  `unsubscribe_notify` int(11) DEFAULT NULL,
  `remote_notify` int(11) DEFAULT NULL,
  `daily_report` int(11) DEFAULT NULL,
  `force_default_personalisation` int(11) DEFAULT NULL,
  `cron_backup` int(11) DEFAULT NULL,
  `backup_interval` int(11) DEFAULT NULL,
  `cron_dedup` int(11) DEFAULT NULL,
  `message_limit` int(11) DEFAULT NULL,
  `max_list` int(11) DEFAULT NULL,
  `show_news` int(11) DEFAULT NULL,
  `show_habeas` int(11) DEFAULT NULL,
  `count_subscribers` int(11) DEFAULT NULL,
  `show_extra` int(11) DEFAULT NULL,
  `your_domain` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `cgi_arplus_url` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `support_email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `optin_success` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `optin_failure` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `subscribe_success` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `subscribe_failure` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `unsubscribe_success` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `unsubscribe_failure` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `system_email` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `mailer` varchar(10) COLLATE utf8_unicode_ci DEFAULT NULL,
  `sendmail` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `smtp_server` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `attachments_path` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `preview_font` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `double_subject` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL,
  `affiliate_text` text COLLATE utf8_unicode_ci,
  `affiliate_ad` text COLLATE utf8_unicode_ci,
  `message_page_header` text COLLATE utf8_unicode_ci,
  `message_page_footer` text COLLATE utf8_unicode_ci,
  `double_text` text COLLATE utf8_unicode_ci,
  `unsubscribe_text` text COLLATE utf8_unicode_ci,
  `edit_text` text COLLATE utf8_unicode_ci,
  `next_text` text COLLATE utf8_unicode_ci,
  `unsubscribe_email` text COLLATE utf8_unicode_ci,
  `sig_1` text COLLATE utf8_unicode_ci,
  `sig_2` text COLLATE utf8_unicode_ci,
  `sig_3` text COLLATE utf8_unicode_ci,
  `ad1` text COLLATE utf8_unicode_ci,
  `ad2` text COLLATE utf8_unicode_ci,
  `ad3` text COLLATE utf8_unicode_ci,
  `reserved_email` text COLLATE utf8_unicode_ci,
  `banned_email` text COLLATE utf8_unicode_ci,
  `spam_message` text COLLATE utf8_unicode_ci,
  `privacy_statement` text COLLATE utf8_unicode_ci,
  PRIMARY KEY (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `settings`
--

LOCK TABLES `settings` WRITE;
/*!40000 ALTER TABLE `settings` DISABLE KEYS */;
INSERT INTO `settings` VALUES (1,1,365,0,3,1,1,1,NULL,NULL,NULL,1,24,1,999999,50,NULL,NULL,NULL,1,'streetsurvivors.org','http://www.streetsurvivors.org/mailz','admin@echhost.com','','','','','','','nobody@echhost.com','SMTP','/usr/sbin/ssmtp','192.168.1.25','/var/www/streetsurvivors_web/cgi-bin/mailz/attachments','Courier New, Courier, mono','','Powered by AutoResponse Plus','=================================================================\r\nSTOP Paying Monthly Fees For Autoresponders!\r\nWhy waste your profits on expensive monthly fees?  Install\r\nAutoResponse Plus on your web site today.  Multiply your sales by\r\ncapturing e-mail addresses, sending unlimited personalized\r\nfollow-ups, and much more.\r\n\r\nOne user said: \"Congratulations on a brilliant product. This is\r\nexactly what the world of internet marketing needs!\"\r\n\r\nClick to find out why our customers RAVE about AutoResponse Plus!\r\n{AFFILIATE_LINK}\r\n=================================================================','','','Hello\r\n\r\nThank you for subscribing. Please confirm your subscription by clicking once on the link below or copying and pasting it into your browser.\r\n\r\n{CONFIRMATION_LINK}\r\n\r\nThank you.','If you wish to cancel your subscription, simply click once on the link below.','If you would like to change your e-mail address, message format preference or other aspects of your subscription, click the link below.','If you would like to receive the next message in this series immediately, simply click once on the link below.','Thank you for subscribing. \r\n\r\nYou have now unsubscribed and no more messages will be sent.','','','','','','','','','We do not support unsolicited e-mail (spam) in any form. If you feel you have been subscribed without your permission, please contact the sender and we will investigate.','We respect your privacy and will not share your details with anyone else.');
/*!40000 ALTER TABLE `settings` 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
