From f5a8a92df101cbf37fedb9ac3f7702f60a40772e Mon Sep 17 00:00:00 2001
From: Mike Macgirvin <mike@macgirvin.com>
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

