CREATE TABLE all_zero_date_and_time_table (
  A TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00',
  B TIMESTAMP NULL DEFAULT '0000-00-00 00:00:00',
  C TIMESTAMP DEFAULT '0000-00-00 00:00:00' NOT NULL,
  D TIMESTAMP DEFAULT '0000-00-00 00:00:00' NULL,
  E DATE NOT NULL DEFAULT '0000-00-00',
  F DATE NULL DEFAULT '0000-00-00',
  G DATE DEFAULT '0000-00-00' NOT NULL,
  H DATE DEFAULT '0000-00-00' NULL,
  I DATETIME NOT NULL DEFAULT '0000-00-00 00:00:00',
  J DATETIME NULL DEFAULT '0000-00-00 00:00:00',
  K DATETIME DEFAULT '0000-00-00 00:00:00' NOT NULL,
  L DATETIME DEFAULT '0000-00-00 00:00:00' NULL
);
INSERT INTO all_zero_date_and_time_table
VALUES (DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT );

CREATE TABLE part_zero_date_and_time_table (
  A TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00',
  B TIMESTAMP NULL DEFAULT '0000-00-00 00:00:00',
  C DATETIME NOT NULL DEFAULT '0000-00-00 01:00:00.000',
  D DATETIME NULL DEFAULT '0000-00-00 01:00:00.000',
  E DATE NOT NULL DEFAULT '1000-00-00 01:00:00.000',
  F DATE NULL DEFAULT '1000-00-00 01:00:00.000',
  G TIME DEFAULT '0000-00-00 01:00:00.000' NOT NULL,
  H TIME DEFAULT '0000-00-00 01:00:00.000' NULL
);
INSERT INTO part_zero_date_and_time_table
VALUES (DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT, DEFAULT);