aboutsummaryrefslogtreecommitdiffstats
path: root/database.sql
diff options
context:
space:
mode:
authorOlivier Migeot <olivier@migeot.org>2011-04-12 13:55:43 +0200
committerOlivier Migeot <olivier@migeot.org>2011-04-12 13:55:43 +0200
commit85f709320b588f3231875d097217bd9abd223c9f (patch)
tree988f92ae345657ece74dbcc9dd0d8f17d41f20a5 /database.sql
parent294577a48b2d6356dd7695716ea0379bf3a087df (diff)
parent6da84027afa18633ac5d5dacce99bb244be2aa7b (diff)
downloadvolse-hubzilla-85f709320b588f3231875d097217bd9abd223c9f.tar.gz
volse-hubzilla-85f709320b588f3231875d097217bd9abd223c9f.tar.bz2
volse-hubzilla-85f709320b588f3231875d097217bd9abd223c9f.zip
Merge remote branch 'mike/master'
Diffstat (limited to 'database.sql')
-rw-r--r--database.sql12
1 files changed, 12 insertions, 0 deletions
diff --git a/database.sql b/database.sql
index eb6eebc4a..2fd289d74 100644
--- a/database.sql
+++ b/database.sql
@@ -85,6 +85,7 @@ CREATE TABLE IF NOT EXISTS `contact` (
`priority` tinyint(3) NOT NULL,
`blocked` tinyint(1) NOT NULL DEFAULT '1',
`readonly` tinyint(1) NOT NULL DEFAULT '0',
+ `writable` tinyint(1) NOT NULL DEFAULT '0',
`pending` tinyint(1) NOT NULL DEFAULT '1',
`rating` tinyint(1) NOT NULL DEFAULT '0',
`reason` text NOT NULL,
@@ -502,3 +503,14 @@ CREATE TABLE IF NOT EXISTS `ffinder` (
`fid` INT UNSIGNED NOT NULL
) ENGINE = MYISAM DEFAULT CHARSET=utf8;
+
+CREATE TABLE IF NOT EXISTS `mailacct` (
+`id` INT NOT NULL AUTO_INCREMENT PRIMARY KEY ,
+`uid` INT NOT NULL,
+`server` CHAR( 255 ) NOT NULL ,
+`user` CHAR( 255 ) NOT NULL ,
+`pass` CHAR( 255 ) NOT NULL ,
+`reply_to` CHAR( 255 ) NOT NULL ,
+`last_check` DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00'
+) ENGINE = MYISAM DEFAULT CHARSET=utf8;
+