diff options
author | Arun Persaud <arun@nubati.net> | 2007-12-16 14:54:06 +0100 |
---|---|---|
committer | Arun Persaud <arun@nubati.net> | 2007-12-16 22:33:43 +0100 |
commit | a28cbfa660f2ff982f1cdcee41c09cec772d84af (patch) | |
tree | e2c70082d93a44b373b6d57899590ac01dcc0d5c /create_database.sql | |
parent | 672791e22e1de68e278e2f0d5c6d7331d5994ecb (diff) | |
download | e-DoKo-a28cbfa660f2ff982f1cdcee41c09cec772d84af.tar.gz e-DoKo-a28cbfa660f2ff982f1cdcee41c09cec772d84af.tar.bz2 e-DoKo-a28cbfa660f2ff982f1cdcee41c09cec772d84af.zip |
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.
Diffstat (limited to 'create_database.sql')
-rw-r--r-- | create_database.sql | 2 |
1 files changed, 1 insertions, 1 deletions
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; |