From b9d768972e94dfa5e1511779726091214dece5cf Mon Sep 17 00:00:00 2001 From: Mike Macgirvin 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