below is a small snippet where I would have expected these statements for check for the table, index and column
Code: Select all
--
-- Drop index `om_cmn_location_om_cmn_application_fk` from table `OM_CMN_Application`
--
ALTER TABLE OM_CMN_Application
DROP INDEX om_cmn_location_om_cmn_application_fk;
--
-- Alter column `updatedOnDTime` on table `OM_CMN_Application`
--
ALTER TABLE OM_CMN_Application
CHANGE COLUMN updatedOnDTime updatedOnDTime DATETIME DEFAULT CURRENT_TIMESTAMP;