From b399b20dee2752a038a64a8be2c89df142aae280 Mon Sep 17 00:00:00 2001 From: Mike Macgirvin Date: Fri, 30 Jul 2010 06:09:20 -0700 Subject: mail, i18n, etc. --- database.sql | 6 +++++- 1 file changed, 5 insertions(+), 1 deletion(-) (limited to 'database.sql') 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; -- cgit v1.2.3