On 10/03/16 05:19, Ralph Bolton wrote: > Yeah, Oracle are making changes alright - not all of them are good :-( > > It's a relatively easy to fix, and actually, it's probably something > that should be changed in the "make_mysql_tables" file supplied with > Bacula (as it's backwards compatible with older MySQL and MariaDBs). The > change is a search and replace for: > > DATETIME DEFAULT 0, > > ...to... > > DATETIME DEFAULT '0000-00-00 00:00:00',
Currently supported versions of MySQL also object (quite rightly) to NOT NULL without DEFAULT. So `JobStatus` binary(1) NOT NULL, is not strict SQL compliant. DEFAULT 0 will work fine here. -- Phil Stracchino Babylon Communications ph...@caerllewys.net p...@co.ordinate.org Landline: 603.293.8485 ------------------------------------------------------------------------------ Check out the vibrant tech community on one of the world's most engaging tech sites, SlashDot.org! http://sdm.link/slashdot _______________________________________________ Bacula-users mailing list Bacula-users@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/bacula-users
