From f5a8a92df101cbf37fedb9ac3f7702f60a40772e Mon Sep 17 00:00:00 2001 From: Mike Macgirvin Date: Sat, 16 Oct 2010 22:11:21 -0700 Subject: infrastructure for supporting pages/groups --- database.sql | 18 ++++++++++++------ 1 file changed, 12 insertions(+), 6 deletions(-) (limited to 'database.sql') diff --git a/database.sql b/database.sql index 24dd9495d..8b1f35cd2 100644 --- a/database.sql +++ b/database.sql @@ -351,12 +351,18 @@ CREATE TABLE IF NOT EXISTS `user` ( `prvkey` text NOT NULL, `spubkey` text NOT NULL, `sprvkey` text NOT NULL, - `verified` tinyint(1) unsigned NOT NULL DEFAULT '0', `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; + `verified` tinyint(1) unsigned NOT NULL DEFAULT '0', + `blocked` tinyint(1) unsigned NOT NULL DEFAULT '0', + `notify-flags` int(11) unsigned NOT NULL DEFAULT '65535', + `page-flags` int(11) unsigned NOT NULL DEFAULT '0', + `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`), + KEY `nickname` (`nickname`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; CREATE TABLE IF NOT EXISTS `register` ( -- cgit v1.2.3