multi-user, do not cache open mbox

[friendica.git] / database.sql

diff --git a/database.sql b/database.sql
index e134d74381dc0db9c0a7e8fa0dd2c97e9ea9e7db..84bb42ff3993abee15edd18853b387fe3d623a79 100644 (file)
--- a/database.sql
+++ b/database.sql
@@ -195,6 +195,7 @@ CREATE TABLE IF NOT EXISTS `item` (
   `deny_cid` mediumtext NOT NULL,
   `deny_gid` mediumtext NOT NULL,
   `private` tinyint(1) NOT NULL DEFAULT '0',
+  `pubmail` tinyint(1) NOT NULL DEFAULT '0',
   `visible` tinyint(1) NOT NULL DEFAULT '0',
   `unseen` tinyint(1) NOT NULL DEFAULT '1',
   `deleted` tinyint(1) NOT NULL DEFAULT '0',
@@ -513,8 +514,9 @@ CREATE TABLE IF NOT EXISTS `mailacct` (
 `ssltype` CHAR( 16 ) NOT NULL,
 `mailbox` CHAR( 255 ) NOT NULL,
 `user` CHAR( 255 ) NOT NULL ,
-`pass` CHAR( 255 ) NOT NULL ,
+`pass` TEXT NOT NULL ,
 `reply_to` 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;