PhpMyNewsLetter 2.0

ALTER TABLE `pmn2_config` 
            CHANGE  `sending_method` `sending_method` ENUM( 'smtp','lbsmtp','php_mail','php_mail_infomaniak','smtp_gmail_tls',
					'smtp_gmail_ssl','smtp_mutu_ovh','smtp_mutu_1and1','smtp_mutu_gandi','smtp_mutu_online','smtp_mutu_infomaniak' );


ALTER TABLE `pmn2_config` ADD `smtp_port` VARCHAR(5) NOT NULL AFTER `smtp_host`;

ALTER TABLE `pmn2_config` 
            ADD  `table_email_deleted` VARCHAR( 255 ) NOT NULL DEFAULT '',
            ADD  `table_smtp` varchar(255) NOT NULL DEFAULT '',
            ADD  `alert_sub` ENUM(  '0',  '1' ) NOT NULL default '1',
            ADD  `active_tracking` enum('0','1') NOT NULL DEFAULT '1';

UPDATE `pmn2_config` SET table_email_deleted='pmn2_email_deleted',table_smtp='pmn2_smtp';

ALTER TABLE `pmn2_email`
            ADD `campaign_id` INT(7) DEFAULT NULL,
            ADD KEY `categorie` (`categorie`),
            ADD KEY `campaign_id` (`campaign_id`);


CREATE TABLE IF NOT EXISTS `pmn2_email_deleted` (
            `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
            `email` varchar(255) NOT NULL DEFAULT '',
            `list_id` int(5) unsigned NOT NULL DEFAULT '0',
            `hash` varchar(40) NOT NULL DEFAULT '',
            `error` enum('N','Y') NOT NULL DEFAULT 'N',
            `status` varchar(255) DEFAULT NULL,
            `type` enum('','autoreply','blocked','generic','soft','hard','temporary','unsub','by_admin') NOT NULL,
            `categorie` varchar(255) NOT NULL,
            `short_desc` text NOT NULL,
            `long_desc` text NOT NULL,
            `campaign_id` int(7) unsigned NOT NULL DEFAULT '0',
            PRIMARY KEY (`id`),
            UNIQUE KEY `unique_email_by_list` (`email`,`list_id`),
            KEY `hash` (`hash`),
            KEY `error` (`error`),
            KEY `status` (`status`),
            KEY `type` (`type`),
            KEY `categorie` (`categorie`),
            KEY `campaign_id` (`campaign_id`)
            ) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

CREATE TABLE IF NOT EXISTS `pmn2_smtp` (
            `smtp_id` int(7) NOT NULL AUTO_INCREMENT,
            `smtp_name` text NOT NULL,
            `smtp_url` varchar(255) NOT NULL,
            `smtp_user` text NOT NULL,
            `smtp_pass` text NOT NULL,
            `smtp_port` int(5) unsigned NOT NULL,
            `smtp_secure` text NOT NULL,
            `smtp_limite` int(4) unsigned NOT NULL,
            `smtp_used` int(4) unsigned NOT NULL,
            `smtp_date_create` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
            `smtp_date_update` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
            `id_use` int(6) unsigned NOT NULL DEFAULT '0',
            PRIMARY KEY (`smtp_id`),
            UNIQUE KEY `smtp_url` (`smtp_url`,`smtp_port`),
            KEY `smtp_used` (`smtp_used`),
            KEY `smtp_limite` (`smtp_limite`)
            ) ENGINE=MyISAM  DEFAULT CHARSET=utf8;

ALTER TABLE `pmn2_track`
            ADD `browser` varchar(150) NOT NULL,
            ADD `version` varchar(150) NOT NULL,
            ADD `platform` varchar(255) NOT NULL,
            ADD `useragent` text NOT NULL,
            ADD `devicetype` varchar(10) NOT NULL,
            ADD KEY `ip` (`ip`),
            ADD KEY `browser` (`browser`),
            ADD KEY `version` (`version`),
            ADD KEY `platform` (`platform`),
            ADD KEY `devicetype` (`devicetype`);

ALTER TABLE `pmn2_track_links` CHANGE `cpt` `cpt` INT( 7 ) UNSIGNED NOT NULL DEFAULT  '0';