title: Invalid default value for 'last_modified'
body: <p><strong>MySQL Distrib 5.5</strong></p>
  
  <p><strong>OS: Ubuntu 14.04</strong></p>
  
  <p>I tried to import a database sql script into MySQL using this command:</p>
  
  <pre><code>mysql -u root databaseName &lt; databaseName.sql
  </code></pre>
  
  <p>While creating a BD and loading a dump I am getting the following errors:</p>
  
  <pre><code>ERROR 1067 (42000) at line 5: Invalid default value for 'last_modified'
  </code></pre>
  
  <p><strong>42000</strong></p>
  
  <pre><code>CREATE TABLE IF NOT EXISTS `vote`.`user` (
    `id` BIGINT(20) NOT NULL AUTO_INCREMENT,
    `first_name` VARCHAR(100) NOT NULL,
    `last_name` VARCHAR(100) NOT NULL,
    `username` VARCHAR(100) NOT NULL,
    `password` VARCHAR(100) NOT NULL,
    `phone` VARCHAR(20) NOT NULL,
    `enabled` TINYINT(1) NOT NULL,
    `last_modified` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `validation_code` VARCHAR(255) NOT NULL,
    PRIMARY KEY (`id`),
    UNIQUE INDEX `username_idx` (`username` ASC),
    INDEX `first_last_name_idx` (`first_name` ASC, `last_name` ASC),
    INDEX `last_first_name_idx` (`last_name` ASC, `first_name` ASC),
    UNIQUE INDEX `phone_idx` (`phone` ASC))
  ENGINE = InnoDB
  DEFAULT CHARACTER SET = utf8;
  </code></pre>
  
  <p>Do you have any idea what caused this error? and how can i fix it?</p>