title: Error code 1067, SQL state 42000: Invalid default value for 'memberSince' when compiling a table
body: <p>I'm adding a new table to the list of existing tables:</p>
  
  <pre><code>CREATE TABLE Counselor (
      id SMALLINT UNSIGNED NOT NULL AUTO_INCREMENT,
      firstName VARCHAR (50),
      nickName VARCHAR (50),
      lastName VARCHAR (50),
      telephone VARCHAR (25),
      email VARCHAR (50),
      memberSince DATE DEFAULT '0000-00-00',
      PRIMARY KEY (id)
  );
  </code></pre>
  
  <p>Execution is interrupted with the following message:</p>
  
  <pre><code>Error code 1067, SQL state 42000: Invalid default value for 'memberSince'
  </code></pre>
  
  <p>What can I do to fix it?</p>