FAILS FOR DATE COLUMN

ISSUE: select with union is used in create table.
       In case of columns that cannot be null,
       0 is set as default value. For date columns,
       0000-00-00 is set as default value which is
       invalid when server is running in strict mode.

SOLUTION: In strict mode, for create using select
          with union, for date columns, do not set
          the default value.