aboutsummaryrefslogtreecommitdiffstats
path: root/database.sql
diff options
context:
space:
mode:
authorMike Macgirvin <mike@macgirvin.com>2010-07-30 06:09:20 -0700
committerMike Macgirvin <mike@macgirvin.com>2010-07-30 06:09:20 -0700
commitb399b20dee2752a038a64a8be2c89df142aae280 (patch)
treed94e361d0ec77efa3b0ceade9b762f6595bbc7eb /database.sql
parentf83aa6c8a57e0ba9be2cd5842899488a4c2a8514 (diff)
downloadvolse-hubzilla-b399b20dee2752a038a64a8be2c89df142aae280.tar.gz
volse-hubzilla-b399b20dee2752a038a64a8be2c89df142aae280.tar.bz2
volse-hubzilla-b399b20dee2752a038a64a8be2c89df142aae280.zip
mail, i18n, etc.
Diffstat (limited to 'database.sql')
-rw-r--r--database.sql6
1 files changed, 5 insertions, 1 deletions
diff --git a/database.sql b/database.sql
index ca9485777..cfe0df9d2 100644
--- a/database.sql
+++ b/database.sql
@@ -178,7 +178,7 @@ CREATE TABLE IF NOT EXISTS `item` (
--
CREATE TABLE IF NOT EXISTS `mail` (
- `id` int(10) unsigned NOT NULL,
+ `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`uid` int(10) unsigned NOT NULL,
`from-name` char(255) NOT NULL,
`from-photo` char(255) NOT NULL,
@@ -314,6 +314,10 @@ CREATE TABLE IF NOT EXISTS `user` (
`blocked` tinyint(1) unsigned NOT NULL DEFAULT '0',
`notify-flags` int(11) unsigned NOT NULL DEFAULT '65535',
`pwdreset` char(255) NOT NULL,
+ `allow_cid` mediumtext NOT NULL,
+ `allow_gid` mediumtext NOT NULL,
+ `deny_cid` mediumtext NOT NULL,
+ `deny_gid` mediumtext NOT NULL,
PRIMARY KEY (`uid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;