-- MySQL dump 10.13  Distrib 5.7.33, for Linux (x86_64)
--
-- Host: localhost    Database: swadwebsite_wp
-- ------------------------------------------------------
-- Server version	5.7.33-0ubuntu0.16.04.1

/*!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 */;
/*!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 `ares`
--

DROP TABLE IF EXISTS `ares`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ares` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT NULL,
  `type` int(11) DEFAULT NULL,
  `list` int(11) DEFAULT NULL,
  `custom_field` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ares`
--

LOCK TABLES `ares` WRITE;
/*!40000 ALTER TABLE `ares` DISABLE KEYS */;
/*!40000 ALTER TABLE `ares` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `ares_emails`
--

DROP TABLE IF EXISTS `ares_emails`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `ares_emails` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `ares_id` int(11) DEFAULT NULL,
  `from_name` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `from_email` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `reply_to` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `title` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `plain_text` longtext COLLATE utf8mb4_unicode_ci,
  `html_text` longtext COLLATE utf8mb4_unicode_ci,
  `query_string` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `time_condition` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `timezone` varchar(100) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `created` int(11) DEFAULT NULL,
  `recipients` int(100) DEFAULT '0',
  `opens` longtext COLLATE utf8mb4_unicode_ci,
  `wysiwyg` int(11) DEFAULT '0',
  `opens_tracking` int(1) DEFAULT '1',
  `links_tracking` int(1) DEFAULT '1',
  `enabled` int(11) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `ares_emails`
--

LOCK TABLES `ares_emails` WRITE;
/*!40000 ALTER TABLE `ares_emails` DISABLE KEYS */;
/*!40000 ALTER TABLE `ares_emails` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `blocked_domains`
--

DROP TABLE IF EXISTS `blocked_domains`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `blocked_domains` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `app` int(11) DEFAULT NULL,
  `domain` varchar(100) DEFAULT NULL,
  `timestamp` varchar(100) DEFAULT NULL,
  `block_attempts` int(100) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `blocked_domains`
--

LOCK TABLES `blocked_domains` WRITE;
/*!40000 ALTER TABLE `blocked_domains` DISABLE KEYS */;
/*!40000 ALTER TABLE `blocked_domains` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `queue`
--

DROP TABLE IF EXISTS `queue`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `queue` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `query_str` longtext,
  `campaign_id` int(11) DEFAULT NULL,
  `subscriber_id` int(11) DEFAULT NULL,
  `sent` int(11) DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `s_id` (`subscriber_id`),
  KEY `st_id` (`sent`),
  KEY `s_campaign_id` (`campaign_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `queue`
--

LOCK TABLES `queue` WRITE;
/*!40000 ALTER TABLE `queue` DISABLE KEYS */;
/*!40000 ALTER TABLE `queue` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `seg`
--

DROP TABLE IF EXISTS `seg`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `seg` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `name` varchar(100) DEFAULT NULL,
  `app` int(11) DEFAULT NULL,
  `list` int(11) DEFAULT NULL,
  `last_updated` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `s_list` (`list`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `seg`
--

LOCK TABLES `seg` WRITE;
/*!40000 ALTER TABLE `seg` DISABLE KEYS */;
/*!40000 ALTER TABLE `seg` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `seg_cons`
--

DROP TABLE IF EXISTS `seg_cons`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `seg_cons` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `seg_id` int(11) DEFAULT NULL,
  `grouping` int(11) DEFAULT NULL,
  `operator` char(3) DEFAULT NULL,
  `field` varchar(100) DEFAULT NULL,
  `comparison` varchar(11) DEFAULT NULL,
  `val` varchar(500) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `s_seg_id` (`seg_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `seg_cons`
--

LOCK TABLES `seg_cons` WRITE;
/*!40000 ALTER TABLE `seg_cons` DISABLE KEYS */;
/*!40000 ALTER TABLE `seg_cons` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `skipped_emails`
--

DROP TABLE IF EXISTS `skipped_emails`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `skipped_emails` (
  `app` int(11) DEFAULT NULL,
  `list` int(11) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `reason` int(1) DEFAULT NULL,
  KEY `s_list` (`list`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `skipped_emails`
--

LOCK TABLES `skipped_emails` WRITE;
/*!40000 ALTER TABLE `skipped_emails` DISABLE KEYS */;
/*!40000 ALTER TABLE `skipped_emails` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `subscribers_seg`
--

DROP TABLE IF EXISTS `subscribers_seg`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `subscribers_seg` (
  `seg_id` int(11) NOT NULL,
  `subscriber_id` int(11) NOT NULL,
  PRIMARY KEY (`seg_id`,`subscriber_id`),
  KEY `s_sid` (`seg_id`),
  KEY `s_subscriber_id` (`subscriber_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `subscribers_seg`
--

LOCK TABLES `subscribers_seg` WRITE;
/*!40000 ALTER TABLE `subscribers_seg` DISABLE KEYS */;
/*!40000 ALTER TABLE `subscribers_seg` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `suppression_list`
--

DROP TABLE IF EXISTS `suppression_list`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `suppression_list` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `app` int(11) DEFAULT NULL,
  `email` varchar(100) DEFAULT NULL,
  `timestamp` varchar(100) DEFAULT NULL,
  `block_attempts` int(100) DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `suppression_list`
--

LOCK TABLES `suppression_list` WRITE;
/*!40000 ALTER TABLE `suppression_list` DISABLE KEYS */;
/*!40000 ALTER TABLE `suppression_list` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `template`
--

DROP TABLE IF EXISTS `template`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `template` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `userID` int(11) DEFAULT NULL,
  `app` int(11) DEFAULT NULL,
  `template_name` varchar(500) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
  `html_text` longtext COLLATE utf8mb4_unicode_ci,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `template`
--

LOCK TABLES `template` WRITE;
/*!40000 ALTER TABLE `template` DISABLE KEYS */;
/*!40000 ALTER TABLE `template` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `zapier`
--

DROP TABLE IF EXISTS `zapier`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `zapier` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT,
  `subscribe_endpoint` varchar(100) DEFAULT NULL,
  `event` varchar(100) DEFAULT NULL,
  `list` int(11) DEFAULT NULL,
  `app` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `zapier`
--

LOCK TABLES `zapier` WRITE;
/*!40000 ALTER TABLE `zapier` DISABLE KEYS */;
/*!40000 ALTER TABLE `zapier` 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 2025-01-23 17:27:53
