title: Altering Mysql column default value to CURRENT_DATE gives error?
body: <pre><code>ALTER TABLE `mysystem`.`projects` 
  MODIFY COLUMN `project_capture_date` DATE NOT NULL DEFAULT CURRENT_DATE();
  </code></pre>
  
  <p>gives:</p>
  
  <pre><code>Error Code: 1064. You have an error in your SQL syntax; 
  check the manual that corresponds to your MySQL server
  version for the right syntax to use near 'CURRENT_DATE()'
   at line 2
  </code></pre>
  
  <p>Current row definition:</p>
  
  <pre><code>project_capture_date, date, NO, , 0000-00-00
  </code></pre>
  
  <p>Just recently changed the engine to <code>InnoDB</code> from <code>MyISAM</code>.</p>