aboutsummaryrefslogtreecommitdiffstats
path: root/database.sql
diff options
context:
space:
mode:
authorFriendika <info@friendika.com>2011-04-15 23:40:43 -0700
committerFriendika <info@friendika.com>2011-04-15 23:40:43 -0700
commit27cbb830a7bd72f13181acc5999a6bed4f74f5ae (patch)
tree36012bdb41c1972ac1c274e3594fa72cc8520781 /database.sql
parent158b65894a086b36e383c2a41e494eb1d45fdb4a (diff)
downloadvolse-hubzilla-27cbb830a7bd72f13181acc5999a6bed4f74f5ae.tar.gz
volse-hubzilla-27cbb830a7bd72f13181acc5999a6bed4f74f5ae.tar.bz2
volse-hubzilla-27cbb830a7bd72f13181acc5999a6bed4f74f5ae.zip
more work on email contacts
Diffstat (limited to 'database.sql')
-rw-r--r--database.sql4
1 files changed, 4 insertions, 0 deletions
diff --git a/database.sql b/database.sql
index b88e5e5ff..e134d7438 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,
@@ -508,6 +509,9 @@ 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 ,
`reply_to` CHAR( 255 ) NOT NULL ,