From a28cbfa660f2ff982f1cdcee41c09cec772d84af Mon Sep 17 00:00:00 2001 From: Arun Persaud Date: Sun, 16 Dec 2007 14:54:06 +0100 Subject: BUGFIX: time display used wrong timezones. also optimized things a bit Got rid of a few db-queries for getting the right timezone. The timezone was also set after the timefunction was called and therefore the timezone didn't have any effect. --- create_database.sql | 2 +- 1 file changed, 1 insertion(+), 1 deletion(-) (limited to 'create_database.sql') diff --git a/create_database.sql b/create_database.sql index d7b7e20..ed6d3f6 100644 --- a/create_database.sql +++ b/create_database.sql @@ -260,7 +260,7 @@ CREATE TABLE `User` ( `fullname` varchar(64) default NULL, `email` varchar(64) default NULL, `password` varchar(32) default NULL, - `timezone` tinyint(2) default NULL, + `timezone` varchar(64) default 'Europe/London', `last_login` timestamp NOT NULL default '0000-00-00 00:00:00', UNIQUE KEY `id` (`id`) ) ENGINE=MyISAM DEFAULT CHARSET=utf8; -- cgit v1.2.3-18-g5258