aboutsummaryrefslogtreecommitdiffstats
path: root/database.sql
diff options
context:
space:
mode:
Diffstat (limited to 'database.sql')
-rw-r--r--database.sql18
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` (