title: Database Schema, Default Value is NOW()
body: <p>I have database schema for users. It looks like...</p>
  
  <pre><code>CREATE TABLE `users` (
  
  `id` int( 8 ) unsigned AUTO_INCREMENT,
  `username` varchar( 255 ),
  `password` varchar( 40 ),
  `level` tinyint( 1 ) unsigned DEFAULT 1,
  `time` datetime DEFAULT NOW(),
  `email` varchar( 255 ),
  
  PRIMARY KEY (`id`)
  
  ) ENGINE=InnoDB;
  </code></pre>
  
  <p>There are six fields: <em>id</em>, <em>username</em>, <em>password</em>, <em>level</em>, <em>time</em>, <em>email</em>, but I want to insert only three of them - when user is registration: <em>username</em>, <em>password</em> and <em>email</em>. Rest of them will have default values.</p>
  
  <p>Problem is that MySQL throws error: <strong>#1067 - Invalid default value for 'time'</strong>. Any ideas, guys?</p>