1) remove this following line from the script file:

ALTER TABLE melete_module_shdates add ALLOWUNTIL_DATE date default NULL;
2)add the following:
ALTER TABLE melete_module_shdates modify START_DATE timestamp(6);
ALTER TABLE melete_module_shdates modify END_DATE timestamp(6);
ALTER TABLE melete_module_shdates add ALLOWUNTIL_DATE timestamp(6) default NULL;