diff options
| author | Mike Macgirvin <mike@macgirvin.com> | 2010-10-16 22:11:21 -0700 |
|---|---|---|
| committer | Mike Macgirvin <mike@macgirvin.com> | 2010-10-16 22:11:21 -0700 |
| commit | f5a8a92df101cbf37fedb9ac3f7702f60a40772e (patch) | |
| tree | 5f89c16597a4120148128af306e26c1d26f5666f /database.sql | |
| parent | 36e1afa6ae35890a26910951dec6dda98dcdee8f (diff) | |
| download | volse-hubzilla-f5a8a92df101cbf37fedb9ac3f7702f60a40772e.tar.gz volse-hubzilla-f5a8a92df101cbf37fedb9ac3f7702f60a40772e.tar.bz2 volse-hubzilla-f5a8a92df101cbf37fedb9ac3f7702f60a40772e.zip | |
infrastructure for supporting pages/groups
Diffstat (limited to 'database.sql')
| -rw-r--r-- | database.sql | 18 |
1 files changed, 12 insertions, 6 deletions
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` ( |