   user_dateformat varchar(20) NOT NULL default '%d/%M/%Y %H:%i',
   user_new_privmsg smallint(5) NOT NULL default '0',
   user_unread_privmsg smallint(5) NOT NULL default '0',
-  user_last_privmsg datetime NULL,
-  user_emailtime datetime default NULL,
+  user_last_privmsg timestamp NULL,
+  user_emailtime timestamp default NULL,
   user_viewemail tinyint(1) default '0',
   user_attachsig tinyint(1) default '1',
   user_allowhtml tinyint(1) default '0',

  forum_id smallint(8) NOT NULL default '0',
  topic_title varchar(100) NOT NULL default '',
  user_id mediumint(8) NOT NULL default '0',
  topic_time datetime NOT NULL default '0',
  topic_views mediumint(8) default '1',
  topic_replies mediumint(8) default '0',
  topic_status tinyint(3) default '0',

CREATE TABLE jforum_sessions (
  session_id varchar(50) NOT NULL default '',
  session_user_id mediumint(8) NOT NULL default '0',
  session_start timestamp default null,
  session_time timestamp default null,
  session_ip varchar(8) NOT NULL default '',
  session_page int(11) NOT NULL default '0',
  session_logged_int tinyint(1) default NULL
