title: java.sql.SQLException: Field 'id' doesn't have a default value
body: <p>I am trying to insert data into <code>arrivaltimes</code> tables but I am getting the following error:</p>
  
  <blockquote>
    <p>java.sql.SQLException: Field 'id' doesn't have a default value</p>
  </blockquote>
  
  <pre><code>stt.execute("CREATE TABLE IF NOT EXISTS stops"
              + "(stop_id INT(11) NOT NULL AUTO_INCREMENT PRIMARY KEY, "
              + " name varchar(30) NOT NULL, "
              + " route INT(11) NOT NULL, "
              + " lat double(10,6) NOT NULL, "
              + " longi double(10,6)NOT NULL) " );
  
      stt.execute("INSERT INTO stops(name, route, lat, longi) values"
              + "('blabla', '1', '93.838039', '15.700440' ),"
              + "('backery', '9', '98.868863', '19.665438' )" );
  
      stt.execute("CREATE TABLE IF NOT EXISTS arrivaltimes(id INT(11) NOT NULL PRIMARY KEY,"
              +  " weekday VARCHAR(20) NOT NULL,"
              + "arrivaltime time NOT NULL,"
              + " stop_id INT, FOREIGN KEY fk_stop_id(stop_id) REFERENCES stops(stop_id) )" );
      //The error appears in this execution statement.
      stt.execute("INSERT INTO arrivaltimes(weekday, arrivaltime) values"
              + "('mon-fri', '05:30' ),"
              + "('mon-fri', '06:07' )" );
  </code></pre>