Committer: iaskarov
LJSUP-8195 E-mail unsubscriptionU trunk/bin/upgrading/update-db-general.pl
Modified: trunk/bin/upgrading/update-db-general.pl =================================================================== --- trunk/bin/upgrading/update-db-general.pl 2011-03-21 10:39:38 UTC (rev 18654) +++ trunk/bin/upgrading/update-db-general.pl 2011-03-21 10:43:40 UTC (rev 18655) @@ -3414,6 +3414,18 @@ ) Type=InnoDB EOC +register_tablecreate("email_status", <<'EOC'); +CREATE TABLE `email_status` ( + `email` varchar(50) NOT NULL default '', + `first_error_time` int(10) unsigned NOT NULL, + `last_error_time` int(10) unsigned NOT NULL, + `error_count` tinyint(3) unsigned NOT NULL, + `disabled` tinyint(3) unsigned NOT NULL, + PRIMARY KEY (`email`), + KEY `first_error_time` (`first_error_time`) + ) TYPE=InnoDB +EOC + ### changes register_alter(sub {