-- --------------------------------------------------------
-- Host:                         108.61.8.67
-- Server version:               5.5.33-cll-lve - MySQL Community Server (GPL) by Atomicorp
-- Server OS:                    Linux
-- HeidiSQL version:             7.0.0.4053
-- Date/time:                    2015-03-14 17:56:26
-- --------------------------------------------------------

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET NAMES utf8 */;
/*!40014 SET FOREIGN_KEY_CHECKS=0 */;

-- Dumping structure for table demomailer.bp_statistics
DROP TABLE IF EXISTS `bp_statistics`;
CREATE TABLE IF NOT EXISTS `bp_statistics` (
  `qid` int(10) DEFAULT NULL,
  `emails` longtext
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- Data exporting was unselected.


-- Dumping structure for table demomailer.config
DROP TABLE IF EXISTS `config`;
CREATE TABLE IF NOT EXISTS `config` (
  `cfg_id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(200) NOT NULL,
  `value` varchar(500) NOT NULL,
  PRIMARY KEY (`cfg_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

INSERT INTO `config` (`cfg_id`, `name`, `value`) VALUES
	(1, 'full_url', 'http://184.22.28.10:8080/smtpswitchmailer/');


-- Data exporting was unselected.


-- Dumping structure for table demomailer.import_databases
DROP TABLE IF EXISTS `import_databases`;
CREATE TABLE IF NOT EXISTS `import_databases` (
  `user_id` int(10) NOT NULL DEFAULT '0',
  `driver` varchar(50) NOT NULL DEFAULT '0',
  `host` varchar(200) DEFAULT NULL,
  `port` int(20) DEFAULT NULL,
  `username` varchar(100) DEFAULT NULL,
  `password` varchar(100) DEFAULT NULL,
  `database` varchar(100) DEFAULT NULL,
  `table` varchar(100) DEFAULT NULL,
  `table_column` varchar(100) DEFAULT NULL,
  `mail_id` int(10) NOT NULL,
  `min` int(10) DEFAULT NULL,
  PRIMARY KEY (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- Data exporting was unselected.


-- Dumping structure for table demomailer.mail
DROP TABLE IF EXISTS `mail`;
CREATE TABLE IF NOT EXISTS `mail` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `filename` varchar(255) NOT NULL,
  `data` longtext CHARACTER SET utf8 NOT NULL,
  `verify` int(1) NOT NULL,
  `verify_on` int(1) NOT NULL,
  `sub_spli_merge_on` int(1) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- Data exporting was unselected.


-- Dumping structure for table demomailer.mailer_queue
DROP TABLE IF EXISTS `mailer_queue`;
CREATE TABLE IF NOT EXISTS `mailer_queue` (
  `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `pid` int(10) unsigned NOT NULL,
  `userid` int(10) unsigned NOT NULL,
  `bounce_email` text NOT NULL,
  `list_id` longtext NOT NULL,
  `track_link` enum('N','Y') NOT NULL,
  `from_name` varchar(255) NOT NULL,
  `from_email` varchar(255) DEFAULT NULL,
  `attachment` text NOT NULL,
  `subject` text NOT NULL,
  `message` text NOT NULL,
  `to` longtext NOT NULL,
  `to_id` longtext NOT NULL,
  `last` text NOT NULL,
  `position` int(10) unsigned NOT NULL DEFAULT '0',
  `total` int(10) unsigned NOT NULL,
  `started` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `sleep_for` int(11) NOT NULL,
  `after_sending` int(11) NOT NULL,
  `completed` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
  `status` varchar(255) NOT NULL,
  `status_message` text NOT NULL,
  `failed_to` longtext NOT NULL,
  `failed_list_id` longtext NOT NULL,
  `total_sent` int(10) NOT NULL,
  `apikey` varchar(50) NOT NULL,
  `deep_verification` varchar(3) DEFAULT NULL,
  `total_emails` int(10) DEFAULT NULL,
  `continuous` int(1) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- Data exporting was unselected.


-- Dumping structure for table demomailer.mailer_saved
DROP TABLE IF EXISTS `mailer_saved`;
CREATE TABLE IF NOT EXISTS `mailer_saved` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `from_name` varchar(255) NOT NULL,
  `from_email` varchar(255) DEFAULT NULL,
  `subject` varchar(255) NOT NULL,
  `message` text NOT NULL,
  `sleep_for` int(11) NOT NULL,
  `track_link` enum('Y','N') NOT NULL DEFAULT 'N',
  `after_sending` int(11) NOT NULL,
  `noOfthreads` int(10) DEFAULT NULL,
  `continuous` int(1) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- Data exporting was unselected.


-- Dumping structure for table demomailer.mailer_user
DROP TABLE IF EXISTS `mailer_user`;
CREATE TABLE IF NOT EXISTS `mailer_user` (
  `user_id` mediumint(9) NOT NULL AUTO_INCREMENT,
  `user_firstname` varchar(200) NOT NULL DEFAULT '',
  `user_lastname` varchar(200) NOT NULL DEFAULT '',
  `user_name` varchar(200) NOT NULL,
  `user_nickname` varchar(200) NOT NULL DEFAULT '',
  `user_password` varchar(50) NOT NULL,
  `user_primary_email` varchar(200) NOT NULL,
  `user_office_phone` varchar(50) NOT NULL DEFAULT '',
  `user_fax` varchar(50) NOT NULL DEFAULT '',
  `user_address` varchar(255) NOT NULL DEFAULT '',
  `user_admin_status` enum('Y','N') NOT NULL DEFAULT 'N',
  `user_expire` varchar(11) NOT NULL DEFAULT '',
  `user_status` enum('Active','Inactive') NOT NULL DEFAULT 'Active',
  `max_email_upload` int(10) unsigned NOT NULL,
  `max_email_relay` int(10) unsigned NOT NULL,
  `remaining_relay_quota` int(10) unsigned NOT NULL,
  `need_upload_restrict` varchar(1) DEFAULT NULL,
  `need_relay_restrict` varchar(1) DEFAULT NULL,
  PRIMARY KEY (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- Data exporting was unselected.


-- Dumping structure for table demomailer.mail_list_bounce
DROP TABLE IF EXISTS `mail_list_bounce`;
CREATE TABLE IF NOT EXISTS `mail_list_bounce` (
  `b_id` int(11) NOT NULL AUTO_INCREMENT,
  `listid` int(11) NOT NULL,
  `email` varchar(250) NOT NULL,
  `server` varchar(250) NOT NULL,
  `port` varchar(10) NOT NULL,
  `encryption` varchar(10) NOT NULL,
  `username` varchar(250) NOT NULL,
  `password` varchar(250) NOT NULL,
  `delete` int(1) NOT NULL,
  PRIMARY KEY (`b_id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- Data exporting was unselected.


-- Dumping structure for table demomailer.mail_list_data
DROP TABLE IF EXISTS `mail_list_data`;
CREATE TABLE IF NOT EXISTS `mail_list_data` (
  `emailid` int(10) unsigned NOT NULL AUTO_INCREMENT,
  `listid` int(10) unsigned NOT NULL,
  `email` varchar(255) NOT NULL,
  `name` varchar(255) NOT NULL,
  `hash` varchar(200) NOT NULL,
  PRIMARY KEY (`emailid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- Data exporting was unselected.


-- Dumping structure for table demomailer.smtp
DROP TABLE IF EXISTS `smtp`;
CREATE TABLE IF NOT EXISTS `smtp` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user_id` int(11) NOT NULL,
  `hostname` varchar(255) NOT NULL,
  `pop_hostname` varchar(100) NOT NULL,
  `username` varchar(255) NOT NULL,
  `password` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `port` varchar(255) NOT NULL,
  `pop_port` int(11) NOT NULL,
  `limit` varchar(255) NOT NULL,
  `encryption` enum('None','SSL','TLS','STARTTLS') NOT NULL DEFAULT 'None',
  `pop_encryption` varchar(10) NOT NULL,
  `pop_delete` int(11) NOT NULL,
  `status` enum('Enabled','Disabled') NOT NULL DEFAULT 'Enabled',
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- Data exporting was unselected.


-- Dumping structure for table demomailer.statistics
DROP TABLE IF EXISTS `statistics`;
CREATE TABLE IF NOT EXISTS `statistics` (
  `qid` int(10) NOT NULL,
  `listid` int(10) NOT NULL,
  `total_opened` int(10) NOT NULL,
  `total_unsubscribed` int(10) NOT NULL,
  `total` int(10) NOT NULL,
  `opened_emails` longtext,
  `unsubscribed_emails` longtext
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- Data exporting was unselected.


-- Dumping structure for table demomailer.verification
DROP TABLE IF EXISTS `verification`;
CREATE TABLE IF NOT EXISTS `verification` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `filename` varchar(255) NOT NULL,
  `email` varchar(255) NOT NULL,
  `status` varchar(255) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

-- Data exporting was unselected.
/*!40014 SET FOREIGN_KEY_CHECKS=1 */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
