aboutsummaryrefslogtreecommitdiffstats
path: root/database.sql
diff options
context:
space:
mode:
authorMike Macgirvin <mike@macgirvin.com>2010-10-11 23:22:38 -0700
committerMike Macgirvin <mike@macgirvin.com>2010-10-11 23:22:38 -0700
commitb9d768972e94dfa5e1511779726091214dece5cf (patch)
tree6d0f25ec30afa8801506818e427d434e96fe36f5 /database.sql
parent6b67d00fce5daaa26afa738beb06a91a4b10ccac (diff)
downloadvolse-hubzilla-b9d768972e94dfa5e1511779726091214dece5cf.tar.gz
volse-hubzilla-b9d768972e94dfa5e1511779726091214dece5cf.tar.bz2
volse-hubzilla-b9d768972e94dfa5e1511779726091214dece5cf.zip
added 's' keys - salmon keys, small keys, stupid keys, whatever...
Diffstat (limited to 'database.sql')
-rw-r--r--database.sql18
1 files changed, 8 insertions, 10 deletions
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` (