From a28cbfa660f2ff982f1cdcee41c09cec772d84af Mon Sep 17 00:00:00 2001
From: Arun Persaud <arun@nubati.net>
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

