Create table with empty default timestamp is incorrect

[wojtekn]

When we dump an SQLite database table with a timestamp that has a default set to the empty string, it produces an SQL dump that can't be inserted into a MySQL database.

The following table:

CREATE TABLE `test_table` (
  `timestamp1` datetime NOT NULL,
  `timestamp2` date NOT NULL,
  `timestamp3` time NOT NULL,
  `timestamp4` timestamp NOT NULL,
  `timestamp5` year NOT NULL
);

Is exported as:

CREATE TABLE `test_table` (
  `timestamp1` datetime NOT NULL DEFAULT '',
  `timestamp2` date NOT NULL DEFAULT '',
  `timestamp3` time NOT NULL DEFAULT '',
  `timestamp4` timestamp NOT NULL DEFAULT '',
  `timestamp5` year NOT NULL DEFAULT ''
);

Done is:

• DEFAULT '' does not appear in produced table structure