title: Create Mysql datetime column with default 0000-00-00
body: <p>I want to create a table with column like this.</p>
  
  <pre><code>CREATE  TABLE `user_gender` (
    `user_gender_id` INT(11) UNSIGNED NOT NULL AUTO_INCREMENT ,
    `user_gender_title` VARCHAR(100) NOT NULL ,
    `user_gender_modified_on` DATETIME NOT NULL DEFAULT 0000-00-00 00:00:00 ,
    `user_gender_created_on` DATETIME NOT NULL DEFAULT 0000-00-00 00:00:00 ,
    PRIMARY KEY (`user_gender_id`) )
  ENGINE = InnoDB;
  </code></pre>
  
  <p>but it seem that the default 0000-00-00 cant work in mysql. however i imitated it from joomla database model so I am pretty sure that it should work correctly. but my phpadmin keep saying there is a syntax errors in -00-00. can anyone explain this?</p>