Kern, Rather than re-opening the ticket again - the schema patch doesn't do NEARLY as much as it looks as though it does.
The make_mysql_tables script currently creates a new Bacula schema in which all DATETIME fields *except one* are left as unadorned DATETIME with no NOT NULL or DEFAULT. The one exception is the DATETIME field in Snapshot, and we talked about that and you agreed the NOT NULL was unnecessary. So the patch removes it, so that the column is not declared NOT NULL without a default. The Snapshot table also contains one BIGINT declared NOT NULL without a DEFAULT, which is invalid. The patch adds a DEFAULT 0 to that column. Those are the only changes made to make_mysql_tables.in. One NOT NULL removed, one DEFAULT added. The change to update_mysql_tables.in does only one thing: It makes all the DATETIME columns in an *existing* Bacula catalog database match the DATETIME columns in a brand new one created by make_mysql_tables. (It should also fix the missing DEFAULT on Snapshot.CreateTDate, but I just realized this morning I missed that.) -- 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