diff options
| author | Fabio Comuni <fabrix.xm@gmail.com> | 2011-04-18 16:58:20 +0200 |
|---|---|---|
| committer | Fabio Comuni <fabrix.xm@gmail.com> | 2011-04-18 16:58:20 +0200 |
| commit | ee1641393550eea9200f792707070e024879d466 (patch) | |
| tree | ee9e19d380cdf4fee74d4b7c1fa323098c72b93b /database.sql | |
| parent | 62dbfffe399333cd4a792cc77256a2bcd689a14f (diff) | |
| parent | 741a262f1b2d5c8f911896da32e80d543afb5cd1 (diff) | |
| download | volse-hubzilla-ee1641393550eea9200f792707070e024879d466.tar.gz volse-hubzilla-ee1641393550eea9200f792707070e024879d466.tar.bz2 volse-hubzilla-ee1641393550eea9200f792707070e024879d466.zip | |
Merge remote-tracking branch 'friendika-master/master'
Diffstat (limited to 'database.sql')
| -rw-r--r-- | database.sql | 8 |
1 files changed, 7 insertions, 1 deletions
diff --git a/database.sql b/database.sql index b88e5e5ff..84bb42ff3 100644 --- a/database.sql +++ b/database.sql @@ -64,6 +64,7 @@ CREATE TABLE IF NOT EXISTS `contact` ( `issued-id` char(255) NOT NULL, `dfrn-id` char(255) NOT NULL, `url` char(255) NOT NULL, + `addr` char(255) NOT NULL, `alias` char(255) NOT NULL, `pubkey` text NOT NULL, `prvkey` text NOT NULL, @@ -194,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', @@ -508,9 +510,13 @@ CREATE TABLE IF NOT EXISTS `mailacct` ( `id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY , `uid` INT NOT NULL, `server` CHAR( 255 ) NOT NULL , +`port` INT NOT NULL, +`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; |