[livejournal] r18655: LJSUP-8195 E-mail unsubscription

U   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 {