diff options
author | friendica <info@friendica.com> | 2012-04-29 01:08:28 -0700 |
---|---|---|
committer | friendica <info@friendica.com> | 2012-04-29 01:08:28 -0700 |
commit | 249a6814cd777e8eb9d4feb788058ec4683e9522 (patch) | |
tree | ef6af6b92562af0d0c78acc32998c0eacde321ee /database.sql | |
parent | 64060f82dc68d490f3d729f3fbe139527c831fd0 (diff) | |
download | volse-hubzilla-249a6814cd777e8eb9d4feb788058ec4683e9522.tar.gz volse-hubzilla-249a6814cd777e8eb9d4feb788058ec4683e9522.tar.bz2 volse-hubzilla-249a6814cd777e8eb9d4feb788058ec4683e9522.zip |
add db field for removed account, which will also be the first test of update error checking
Diffstat (limited to 'database.sql')
-rw-r--r-- | database.sql | 4 |
1 files changed, 3 insertions, 1 deletions
diff --git a/database.sql b/database.sql index 78b26922b..80a9197fa 100644 --- a/database.sql +++ b/database.sql @@ -1019,6 +1019,7 @@ CREATE TABLE IF NOT EXISTS `user` ( `pwdreset` char(255) NOT NULL, `maxreq` int(11) NOT NULL DEFAULT '10', `expire` int(10) unsigned NOT NULL DEFAULT '0', + `account_removed` tinyint(1) NOT NULL DEFAULT '0', `account_expired` tinyint(1) NOT NULL DEFAULT '0', `account_expires_on` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `expire_notification_sent` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', @@ -1036,7 +1037,8 @@ CREATE TABLE IF NOT EXISTS `user` ( KEY `blocked` (`blocked`), KEY `verified` (`verified`), KEY `unkmail` (`unkmail`), - KEY `cntunkmail` (`cntunkmail`) + KEY `cntunkmail` (`cntunkmail`), + KEY `account_removed` (`account_removed`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- -------------------------------------------------------- |