From fe3dfbee5638dd2988bd8b126652b3138572f02c Mon Sep 17 00:00:00 2001 From: Michael Date: Sun, 26 Feb 2012 23:39:29 +0100 Subject: Mail: New options for actions after importing mails. --- database.sql | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) (limited to 'database.sql') diff --git a/database.sql b/database.sql index 9ad96ca77..ced646f59 100755 --- a/database.sql +++ b/database.sql @@ -634,7 +634,8 @@ CREATE TABLE IF NOT EXISTS `mailacct` ( `mailbox` CHAR( 255 ) NOT NULL, `user` CHAR( 255 ) NOT NULL , `pass` TEXT NOT NULL , -`reply_to` CHAR( 255 ) NOT NULL , +`action` INT NOT NULL , +`movetofolder` CHAR(255) NOT NULL , `pubmail` TINYINT(1) NOT NULL DEFAULT '0', `last_check` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00' ) ENGINE = MyISAM DEFAULT CHARSET=utf8; -- cgit v1.2.3 From fc036210fb599cff936b647689362ebacf86a16b Mon Sep 17 00:00:00 2001 From: friendica Date: Sun, 26 Feb 2012 18:53:48 -0800 Subject: spam db --- database.sql | 12 ++++++++++++ 1 file changed, 12 insertions(+) (limited to 'database.sql') diff --git a/database.sql b/database.sql index ced646f59..349dd2a27 100755 --- a/database.sql +++ b/database.sql @@ -838,4 +838,16 @@ INDEX ( `master-parent-item` ), INDEX ( `receiver-uid` ) ) ENGINE = MyISAM DEFAULT CHARSET=utf8; +CREATE TABLE IF NOT EXISTS `spam` ( +`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY , +`uid` INT NOT NULL, +`spam` INT NOT NULL DEFAULT '0', +`ham` INT NOT NULL DEFAULT '0', +`term` CHAR(255) NOT NULL, +INDEX ( `uid` ), +INDEX ( `spam` ), +INDEX ( `ham` ), +INDEX ( `term` ) +) ENGINE = MyISAM DEFAULT CHARSET=utf8; + -- cgit v1.2.3 From 53412dacd4cb52f0c1162af7ba66aa01f71147b3 Mon Sep 17 00:00:00 2001 From: friendica Date: Mon, 27 Feb 2012 23:27:16 -0800 Subject: update globaldir when page-type changes, add spam date field --- database.sql | 1 + 1 file changed, 1 insertion(+) (limited to 'database.sql') diff --git a/database.sql b/database.sql index 349dd2a27..8c74ecddf 100755 --- a/database.sql +++ b/database.sql @@ -844,6 +844,7 @@ CREATE TABLE IF NOT EXISTS `spam` ( `spam` INT NOT NULL DEFAULT '0', `ham` INT NOT NULL DEFAULT '0', `term` CHAR(255) NOT NULL, +`date` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00', INDEX ( `uid` ), INDEX ( `spam` ), INDEX ( `ham` ), -- cgit v1.2.3