title: Having both a Created and Last Updated timestamp columns in MySQL 4.0
body: <p>I have the following table schema;</p>
  
  <pre><code>CREATE TABLE `db1`.`sms_queue` (
    `Id` INTEGER UNSIGNED NOT NULL AUTO_INCREMENT,
    `Message` VARCHAR(160) NOT NULL DEFAULT 'Unknown Message Error',
    `CurrentState` VARCHAR(10) NOT NULL DEFAULT 'None',
    `Phone` VARCHAR(14) DEFAULT NULL,
    `Created` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `LastUpdated` TIMESTAMP NOT NULL ON UPDATE CURRENT_TIMESTAMP,
    `TriesLeft` tinyint NOT NULL DEFAULT 3,
    PRIMARY KEY (`Id`)
  )
  ENGINE = InnoDB;
  </code></pre>
  
  <p>It fails with the following error:</p>
  
  <pre><code>ERROR 1293 (HY000): Incorrect table definition; there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT or ON UPDATE clause.
  </code></pre>
  
  <p>My question is, can I have both of those fields? or do I have to manually set a LastUpdated field during each transaction?</p>