-- MySQL dump 10.13 Distrib 5.7.44, for Linux (x86_64)
--
-- Host: localhost Database: mensajeria__data
-- ------------------------------------------------------
-- Server version 5.7.44
/*!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 `phplist_admin`
--
DROP TABLE IF EXISTS `phplist_admin`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `phplist_admin` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`loginname` varchar(66) DEFAULT '',
`namelc` varchar(255) DEFAULT NULL,
`email` varchar(255) NOT NULL,
`created` datetime DEFAULT NULL,
`modified` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
`modifiedby` varchar(25) DEFAULT NULL,
`password` varchar(255) DEFAULT NULL,
`passwordchanged` date DEFAULT NULL,
`superuser` tinyint(4) DEFAULT '0',
`disabled` tinyint(4) DEFAULT '0',
`privileges` text,
PRIMARY KEY (`id`),
UNIQUE KEY `loginnameidx` (`loginname`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `phplist_admin`
--
LOCK TABLES `phplist_admin` WRITE;
/*!40000 ALTER TABLE `phplist_admin` DISABLE KEYS */;
INSERT INTO `phplist_admin` VALUES (1,'admin','admin','lapulgavirtual@gmail.com','2020-01-08 16:15:33','2023-03-09 03:02:26',NULL,'0db967d3704c8173fa741e80db52cc0732f56951b893b7898654801328246698','2020-01-08',1,0,NULL);
/*!40000 ALTER TABLE `phplist_admin` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `phplist_admin_attribute`
--
DROP TABLE IF EXISTS `phplist_admin_attribute`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `phplist_admin_attribute` (
`adminattributeid` int(11) NOT NULL,
`adminid` int(11) NOT NULL,
`value` varchar(255) DEFAULT NULL,
PRIMARY KEY (`adminattributeid`,`adminid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `phplist_admin_attribute`
--
LOCK TABLES `phplist_admin_attribute` WRITE;
/*!40000 ALTER TABLE `phplist_admin_attribute` DISABLE KEYS */;
/*!40000 ALTER TABLE `phplist_admin_attribute` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `phplist_admin_password_request`
--
DROP TABLE IF EXISTS `phplist_admin_password_request`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `phplist_admin_password_request` (
`id_key` int(11) NOT NULL AUTO_INCREMENT,
`date` datetime DEFAULT NULL,
`admin` int(11) DEFAULT NULL,
`key_value` varchar(32) NOT NULL,
PRIMARY KEY (`id_key`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `phplist_admin_password_request`
--
LOCK TABLES `phplist_admin_password_request` WRITE;
/*!40000 ALTER TABLE `phplist_admin_password_request` DISABLE KEYS */;
/*!40000 ALTER TABLE `phplist_admin_password_request` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `phplist_adminattribute`
--
DROP TABLE IF EXISTS `phplist_adminattribute`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `phplist_adminattribute` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(255) NOT NULL,
`type` varchar(30) DEFAULT NULL,
`listorder` int(11) DEFAULT NULL,
`default_value` varchar(255) DEFAULT NULL,
`required` tinyint(4) DEFAULT NULL,
`tablename` varchar(255) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `phplist_adminattribute`
--
LOCK TABLES `phplist_adminattribute` WRITE;
/*!40000 ALTER TABLE `phplist_adminattribute` DISABLE KEYS */;
/*!40000 ALTER TABLE `phplist_adminattribute` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `phplist_admintoken`
--
DROP TABLE IF EXISTS `phplist_admintoken`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `phplist_admintoken` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`adminid` int(11) NOT NULL,
`value` varchar(255) DEFAULT NULL,
`entered` int(11) NOT NULL,
`expires` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=830 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `phplist_admintoken`
--
LOCK TABLES `phplist_admintoken` WRITE;
/*!40000 ALTER TABLE `phplist_admintoken` DISABLE KEYS */;
INSERT INTO `phplist_admintoken` VALUES (827,1,'d7f4ce7404519821d284894adde80b42',1690511785,'2023-07-27 23:36:25'),(829,1,'125e7a7751b591fd44ef5464355b9eb6',1690512126,'2023-07-27 23:42:06'),(828,1,'698140f49b664a7e8797e8e78a3fbeb5',1690511816,'2023-07-27 23:36:56');
/*!40000 ALTER TABLE `phplist_admintoken` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `phplist_attachment`
--
DROP TABLE IF EXISTS `phplist_attachment`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `phplist_attachment` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`filename` varchar(255) DEFAULT NULL,
`remotefile` varchar(255) DEFAULT NULL,
`mimetype` varchar(255) DEFAULT NULL,
`description` text,
`size` int(11) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `phplist_attachment`
--
LOCK TABLES `phplist_attachment` WRITE;
/*!40000 ALTER TABLE `phplist_attachment` DISABLE KEYS */;
/*!40000 ALTER TABLE `phplist_attachment` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `phplist_bounce`
--
DROP TABLE IF EXISTS `phplist_bounce`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `phplist_bounce` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`date` datetime DEFAULT NULL,
`header` text,
`data` mediumblob,
`status` varchar(255) DEFAULT NULL,
`comment` text,
PRIMARY KEY (`id`),
KEY `dateindex` (`date`),
KEY `statusidx` (`status`(20))
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `phplist_bounce`
--
LOCK TABLES `phplist_bounce` WRITE;
/*!40000 ALTER TABLE `phplist_bounce` DISABLE KEYS */;
/*!40000 ALTER TABLE `phplist_bounce` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `phplist_bounceregex`
--
DROP TABLE IF EXISTS `phplist_bounceregex`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `phplist_bounceregex` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`regex` varchar(2083) DEFAULT NULL,
`action` varchar(255) DEFAULT NULL,
`listorder` int(11) DEFAULT '0',
`admin` int(11) DEFAULT NULL,
`comment` text,
`status` varchar(255) DEFAULT NULL,
`count` int(11) DEFAULT '0',
`regexhash` char(32) DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `regex` (`regexhash`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `phplist_bounceregex`
--
LOCK TABLES `phplist_bounceregex` WRITE;
/*!40000 ALTER TABLE `phplist_bounceregex` DISABLE KEYS */;
/*!40000 ALTER TABLE `phplist_bounceregex` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `phplist_bounceregex_bounce`
--
DROP TABLE IF EXISTS `phplist_bounceregex_bounce`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `phplist_bounceregex_bounce` (
`regex` int(11) NOT NULL,
`bounce` int(11) NOT NULL,
PRIMARY KEY (`regex`,`bounce`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `phplist_bounceregex_bounce`
--
LOCK TABLES `phplist_bounceregex_bounce` WRITE;
/*!40000 ALTER TABLE `phplist_bounceregex_bounce` DISABLE KEYS */;
/*!40000 ALTER TABLE `phplist_bounceregex_bounce` ENABLE KEYS */;
UNLOCK TABLES;
--
-- Table structure for table `phplist_config`
--
DROP TABLE IF EXISTS `phplist_config`;
/*!40101 SET @saved_cs_client = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `phplist_config` (
`item` varchar(35) NOT NULL,
`value` longtext,
`editable` tinyint(4) DEFAULT '1',
`type` varchar(25) DEFAULT NULL,
PRIMARY KEY (`item`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;
--
-- Dumping data for table `phplist_config`
--
LOCK TABLES `phplist_config` WRITE;
/*!40000 ALTER TABLE `phplist_config` DISABLE KEYS */;
INSERT INTO `phplist_config` VALUES ('179086c5f0269ea80def0b97d4af3062','1578514691',0,NULL),('3edea309deeb5d328a3ee19cfa6b6da8','1578514691',0,NULL),('version','3.6.13',0,NULL),('updatelastcheck','2023-03-16 23:57:30',0,NULL),('admin_address','lapulgavirtual@gmail.com',1,NULL),('message_from_name','IPS',1,NULL),('campaignfrom_default','noresponder@lapulga.com.do La Pulga Virtual',1,NULL),('notifystart_default','lapulgavirtual@gmail.com',1,NULL),('notifyend_default','lapulgavirtual@gmail.com',1,NULL),('report_address','lapulgavirtual@gmail.com',1,NULL),('message_from_address','lapulgavirtual@gmail.com',1,NULL),('message_replyto_address','lapulgavirtual@gmail.com',1,NULL),('organisation_name','La Pulga Virtual',1,NULL),('lastlanguageupdate-es','1684951114',0,NULL),('xormask','33a0b142d5660af4c6faec81203cd76b',0,NULL),('hmackey','a073e9c358b79043165e9504b13db7deedca5d44e1e3a12b9506e60bc7077e8ce7fd56e7b63524a541ceb3c04f763642b5e8ddc4890334dbf3bc61a053b7ffb45ad49df8a64839da57adfc52ba63f9231602e730f8178d51d9cc16e5bb701c77685eca69fb2a3e1ed201410cc839c843196c659c9b5e6de8bd2aba966364f650bc35c2c55b323401bdaff9c25ef4c287ddeae5754e5e2192a907425f731b37d29d3b4ba7ec0ed589efaa235f362829755b8e8cd19fabbe7dc93c5d34ccae35578c749e0ce64f845260d188e6d89aa6d1273fba49c68d02ffd1514cdc1ac59e2df29ca535a1f14ada4d506d251e6a0a8ac84edc25dcf73d841bb9eb06b79a0450',0,NULL),('domain','mensajeria.lapulga.com.do',1,NULL),('website','mensajeria.lapulga.com.do',1,NULL),('plugins_disabled','a:11:{s:12:\"CommonPlugin\";i:1;s:13:\"CaptchaPlugin\";i:1;s:29:\"subjectLinePlaceholdersPlugin\";i:1;s:12:\"inviteplugin\";i:1;s:13:\"SegmentPlugin\";i:1;s:19:\"disposablemailblock\";i:1;s:17:\"domainthrottlemap\";i:1;s:13:\"UpdaterPlugin\";i:1;s:14:\"campaignslicer\";i:1;s:15:\"dateplaceholder\";i:1;s:17:\"embedremoteimages\";i:1;}',0,NULL),('pqchoice','',1,NULL),('readnews1','',1,NULL),('viewednews1','',1,NULL),('phpListNewsLastChecked-es','1690473786',0,NULL),('remoteurl_append','',1,NULL),('phpListNewsIndex-es','',0,NULL),('organisation_logo','2',1,NULL),('UITheme','dressprow',1,NULL),('check_new_version','7',1,NULL),('remote_processing_secret','861bbf8583b190ca5451',1,NULL),('send_admin_copies','0',1,NULL),('always_add_googletracking','0',1,NULL),('defaultmessagetemplate','0',1,NULL),('messagefooter','\r\n\r\n ',1,NULL),('membership_columns','',1,NULL),('lastlanguageupdate-ru','',1,NULL),('lastlanguageupdate-nl','',1,NULL),('lastlanguageupdate-it','',1,NULL),('lastlanguageupdate-fa','',1,NULL),('forwardfooter','\n \n ',1,NULL),('wordwrap','75',1,NULL),('html_email_style','',1,NULL),('alwayssendtextto','',1,NULL),('systemmessagetemplate','1',1,NULL),('subscribesubject','Request for confirmation',1,NULL),('subscribemessage','\n\n Almost welcome to our newsletter(s) ...\n\n Someone, hopefully you, has subscribed your email address to the following newsletters:\n \n [LISTS]\n\n If this is correct, please click the following link to confirm your subscription.\n Without this confirmation, you will not receive any newsletters.\n \n [CONFIRMATIONURL]\n \n If this is not correct, you do not need to do anything, simply delete this message.\n\n Thank you\n \n ',1,NULL),('unsubscribesubject','Goodbye from our Newsletter',1,NULL),('unsubscribemessage','\n \n Goodbye from our Newsletter, sorry to see you go.\n\n You have been unsubscribed from our newsletters.\n\n This is the last email you will receive from us. Our newsletter system, phpList,\n will refuse to send you any further messages, without manual intervention by our administrator.\n\n If there is an error in this information, you can re-subscribe:\n please go to [SUBSCRIBEURL] and follow the steps.\n\n Thank you\n \n ',1,NULL),('confirmationsubject','Welcome to our Newsletter',1,NULL),('confirmationmessage','\n \n Welcome to our Newsletter\n\n Please keep this message for later reference.\n\n Your email address has been added to the following newsletter(s):\n [LISTS]\n\n To update your details and preferences please go to [PREFERENCESURL].\n If you do not want to receive any more messages, please go to [UNSUBSCRIBEURL].\n\n Thank you\n \n ',1,NULL),('updatesubject','[notify] Change of List-Membership details',1,NULL),('updatemessage','\n \n This message is to inform you of a change of your details on our newsletter database\n\n You are currently member of the following newsletters:\n \n [LISTS]\n \n [CONFIRMATIONINFO]\n \n The information on our system for you is as follows:\n \n [USERDATA]\n \n If this is not correct, please update your information at the following location:\n \n [PREFERENCESURL]\n \n Thank you\n \n ',1,NULL),('emailchanged_text','\n When updating your details, your email address has changed.\n Please confirm your new email address by visiting this webpage:\n \n [CONFIRMATIONURL]\n \n ',1,NULL),('emailchanged_text_oldaddress','\n Please Note: when updating your details, your email address has changed.\n\n A message has been sent to your new email address with a URL\n to confirm this change. Please visit this website to activate\n your membership.\n ',1,NULL),('personallocation_subject','Your personal location',1,NULL),('personallocation_message','\n\nYou have requested your personal location to update your details from our website.\nThe location is below. Please make sure that you use the full line as mentioned below.\nSometimes email programmes can wrap the line into multiple lines.\n\nYour personal location is:\n[PREFERENCESURL]\n\nThank you.\n',1,NULL),('hide_single_list','1',1,NULL),('textline_width','40',1,NULL),('textarea_dimensions','10,40',1,NULL),('pageheader','\n\n\n\n\n\n\n\n\n\n