On 08/04/17 12:42, Kern Sibbald wrote:
> Great.  At least I have one positive vote out there :-)


FYI, I just posted a schema cleaning patch for make_mysql_tables.in and
update_mysql_tables.in that simply removes any existing NOT NULL or
DEFAULT constraints from DATETIME fields left over from older database
versions.  It also fixes one missing DEFAULT from a BIGINT NOT NULL in
the Snapshot table.

I'm pretty sure MySQL 5.7 /MariaDB 10.2 users will still need to turn
off NO_ZERO_DATE and NO_ZERO_IN_DATE from the default SQL_MODE.


-- 
  Phil Stracchino
  Babylon Communications
  ph...@caerllewys.net
  p...@co.ordinate.org
  Landline: +1.603.293.8485
  Mobile:   +1.603.998.6958

------------------------------------------------------------------------------
Check out the vibrant tech community on one of the world's most
engaging tech sites, Slashdot.org! http://sdm.link/slashdot
_______________________________________________
Bacula-devel mailing list
Bacula-devel@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/bacula-devel

Reply via email to