X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=database.sql;h=84bb42ff3993abee15edd18853b387fe3d623a79;hb=1e967eddb75ebed6712e33735971d53b009442dd;hp=e134d74381dc0db9c0a7e8fa0dd2c97e9ea9e7db;hpb=27cbb830a7bd72f13181acc5999a6bed4f74f5ae;p=friendica.git

diff --git a/database.sql b/database.sql
index e134d74381..84bb42ff39 100644
--- 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;