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  One NOT NULL
removed, one DEFAULT added.

The change to 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
  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,!
Bacula-devel mailing list

Reply via email to