title: Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause
body: <p>I always get the error:</p>
  
  <blockquote>
    <p>Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause</p>
  </blockquote>
  
  <pre><code>DROP TABLE IF EXISTS `characters`;
  CREATE TABLE `characters`(
    `id` int(11) NOT NULL AUTO_INCREMENT,
    `accId` int(11) NOT NULL,
    `charId` int(11) NOT NULL,
    `charType` int(11) NOT NULL,
    `level` int(11) NOT NULL,
    `exp` int(11) NOT NULL,
    `fame` int(11) NOT NULL,
    `items` varchar(128) NOT NULL,
    `hp` int(11) NOT NULL,
    `mp` int(11) NOT NULL,
    `stats` varchar(64) NOT NULL DEFAULT '"1,2,3,4,5,6,7,8"',
    `dead` tinyint(1) NOT NULL DEFAULT '0',
    `tex1` int(11) NOT NULL DEFAULT '0',
    `tex2` int(11) NOT NULL DEFAULT '0',
    `pet` int(11) NOT NULL DEFAULT '0',
    `fameStats` varchar(128) NOT NULL DEFAULT 'eNoVytkRgCAMRdGH4IIbgmsPdmNVNmZf5n7kzM0kksLjJN2V4b30vcHK1YYam9hCxxqh5zpQI0wwQ4IFMhRYYeNjpw444YIfA3kDIA',
    `createTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `deathTime` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `totalFame` int(11) NOT NULL DEFAULT '0',
    PRIMARY KEY (`id`)
  ) ENGINE=MyISAM AUTO_INCREMENT=14 DEFAULT CHARSET=utf8;
  </code></pre>
  
  <p>This is my first time using MySQL stuff. The reason I am using it because I downloaded a source for a game with server and this is needed.</p>