| Server IP : 66.29.137.217 / Your IP : 3.140.248.104 Web Server : LiteSpeed System : Linux premium294.web-hosting.com 4.18.0-513.11.1.lve.el8.x86_64 #1 SMP Thu Jan 18 16:21:02 UTC 2024 x86_64 User : gltevjme ( 1095) PHP Version : 7.0.33 Disable Function : NONE MySQL : OFF | cURL : ON | WGET : ON | Perl : ON | Python : ON | Sudo : OFF | Pkexec : OFF Directory : /home/gltevjme/greatlifehub.ng/glfiles.name.ng/plugins/newsletters/offline/ |
Upload File : |
CREATE TABLE IF NOT EXISTS `plugin_newsletter` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`title` varchar(255) COLLATE utf8_bin NOT NULL,
`subject` text COLLATE utf8_bin NOT NULL,
`html_content` text COLLATE utf8_bin NOT NULL,
`user_group` enum('all registered','free only','premium only','admin only') COLLATE utf8_bin NOT NULL,
`status` enum('draft','sending','sent') COLLATE utf8_bin NOT NULL,
`date_created` datetime NOT NULL,
`date_sent` datetime NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
CREATE TABLE IF NOT EXISTS `plugin_newsletter_sent` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`to_email_address` varchar(255) COLLATE utf8_bin NOT NULL,
`to_user_id` int(11) NOT NULL,
`subject` text COLLATE utf8_bin NOT NULL,
`html_content` text COLLATE utf8_bin NOT NULL,
`date_created` datetime NOT NULL,
`date_sent` datetime NOT NULL,
`newsletter_id` int(11) NOT NULL,
`status` enum('sent','failed') COLLATE utf8_bin NOT NULL,
PRIMARY KEY (`id`),
KEY `to_user_id` (`to_user_id`),
KEY `newsletter_id` (`newsletter_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
CREATE TABLE IF NOT EXISTS `plugin_newsletter_unsubscribe` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`user_id` int(11) NOT NULL,
`date_unsubscribed` datetime NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `user_id` (`user_id`),
KEY `user_id_2` (`user_id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_bin;
ALTER TABLE `plugin_newsletter` CHANGE `user_group` `user_group` VARCHAR( 20 ) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL;
INSERT INTO plugin_newsletter_unsubscribe (user_id, date_unsubscribed) SELECT id, NOW() FROM users;
UPDATE plugin_newsletter SET date_sent = '2038-01-01 00:00:00' WHERE CAST(date_sent AS CHAR(20)) = '0000-00-00 00:00:00';
ALTER TABLE `plugin_newsletter` CHANGE `date_sent` `date_sent` datetime NULL AFTER `date_created`;
UPDATE plugin_newsletter SET date_sent = NULL WHERE date_sent = '2038-01-01 00:00:00';
ALTER TABLE `plugin_newsletter` ADD `form_type` int(1) NOT NULL DEFAULT '1' AFTER `html_content`;
ALTER TABLE `plugin_newsletter` CHANGE `subject` `subject` text COLLATE 'utf8_bin' NULL AFTER `title`, CHANGE `html_content` `html_content` text COLLATE 'utf8_bin' NULL AFTER `subject`;
ALTER TABLE `plugin_newsletter` CHANGE `user_group` `user_group` varchar(20) COLLATE 'utf8_bin' NULL AFTER `form_type`;