From f60f82727f96c033aaff9f5b5f0767c722e25f28 Mon Sep 17 00:00:00 2001 From: Friendika Date: Thu, 16 Dec 2010 16:35:45 -0800 Subject: register/login timestamps --- database.sql | 2 ++ 1 file changed, 2 insertions(+) (limited to 'database.sql') diff --git a/database.sql b/database.sql index 148a8d0d8..dab7c179d 100644 --- a/database.sql +++ b/database.sql @@ -357,6 +357,8 @@ CREATE TABLE IF NOT EXISTS `user` ( `email` char(255) NOT NULL, `openid` char(255) NOT NULL, `timezone` char(128) NOT NULL, + `register_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', + `login_date` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', `default-location` char(255) NOT NULL, `allow_location` tinyint(1) NOT NULL DEFAULT '0', `theme` char(255) NOT NULL, -- cgit v1.2.3