From b9d768972e94dfa5e1511779726091214dece5cf Mon Sep 17 00:00:00 2001
From: Mike Macgirvin <mike@macgirvin.com>
Date: Mon, 11 Oct 2010 23:22:38 -0700
Subject: added 's' keys - salmon keys, small keys, stupid keys, whatever...

---
 database.sql | 18 ++++++++----------
 1 file changed, 8 insertions(+), 10 deletions(-)

(limited to 'database.sql')

diff --git a/database.sql b/database.sql
index 43d6c0041..24dd9495d 100644
--- a/database.sql
+++ b/database.sql
@@ -349,16 +349,14 @@ CREATE TABLE IF NOT EXISTS `user` (
   `theme` char(255) NOT NULL,
   `pubkey` text NOT NULL,
   `prvkey` 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;
+  `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;
 
 
 CREATE TABLE IF NOT EXISTS `register` (
-- 
cgit v1.2.3

