summaryrefslogtreecommitdiffstats
path: root/create_database.sql
diff options
context:
space:
mode:
authorArun Persaud <arun@nubati.net>2008-03-01 19:05:01 -0800
committerArun Persaud <arun@nubati.net>2008-03-01 19:10:04 -0800
commitfc2fadb0033767d7e75ff501af60b6120f982f77 (patch)
tree36a0f353c6765d02d0701eaaee8e30b710ed5a64 /create_database.sql
parent73a6f86691f53d8eb6339b5bb5e9156822cc7e54 (diff)
downloade-DoKo-fc2fadb0033767d7e75ff501af60b6120f982f77.tar.gz
e-DoKo-fc2fadb0033767d7e75ff501af60b6120f982f77.tar.bz2
e-DoKo-fc2fadb0033767d7e75ff501af60b6120f982f77.zip
FEATURE: display names of new players and last logged in players
instead of showing all registered players, just display the above. Signed-off-by: Arun Persaud <arun@nubati.net>
Diffstat (limited to 'create_database.sql')
-rw-r--r--create_database.sql1
1 files changed, 1 insertions, 0 deletions
diff --git a/create_database.sql b/create_database.sql
index 396862d..e863f53 100644
--- a/create_database.sql
+++ b/create_database.sql
@@ -269,6 +269,7 @@ CREATE TABLE `User` (
`password` varchar(32) default NULL,
`timezone` varchar(64) default 'Europe/London',
`last_login` timestamp NOT NULL default '0000-00-00 00:00:00',
+ `create_date` timestamp NOT NULL default '0000-00-00 00:00:00',
UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;