title: #1067 - Invalid default value for 'bonusid' how can i fix this error?
body: <p>SQL query:</p>
  
  <pre><code>CREATE TABLE bonus(
  bonusid INT( 10 ) DEFAULT  '0' NOT NULL AUTO_INCREMENT ,
  empid INT( 10 ) DEFAULT  '0' NOT NULL ,
  datebonus DATE DEFAULT  '0000-00-00' NOT NULL ,
  bonuspayment VARCHAR( 200 ) NOT NULL ,
  note TEXT NOT NULL ,
  PRIMARY KEY ( bonusid )
  );
  </code></pre>
  
  <p>MySQL said: Documentation</p>
  
  <blockquote>
    <p>1067 - Invalid default value for 'bonusid'</p>
  </blockquote>