diff options
Diffstat (limited to 'database.sql')
| -rw-r--r-- | database.sql | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/database.sql b/database.sql index e134d7438..84bb42ff3 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; |