aboutsummaryrefslogtreecommitdiffstats
path: root/database.sql
diff options
context:
space:
mode:
authorfriendica <info@friendica.com>2012-04-29 01:08:28 -0700
committerfriendica <info@friendica.com>2012-04-29 01:08:28 -0700
commit249a6814cd777e8eb9d4feb788058ec4683e9522 (patch)
treeef6af6b92562af0d0c78acc32998c0eacde321ee /database.sql
parent64060f82dc68d490f3d729f3fbe139527c831fd0 (diff)
downloadvolse-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.sql4
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;
-- --------------------------------------------------------