Drop create index contraint alerts

show create table alerts\G

DROP INDEX `alerts_1` ON `alerts`;
DROP INDEX `alerts_2` ON `alerts`;
DROP INDEX `alerts_3` ON `alerts`;
DROP INDEX `alerts_4` ON `alerts`;
DROP INDEX `alerts_5` ON `alerts`;
DROP INDEX `alerts_6` ON `alerts`;
DROP INDEX `alerts_7` ON `alerts`;
DROP INDEX `c_alerts_6` ON `alerts`;

ALTER TABLE `alerts` DROP CONSTRAINT `c_alerts_1` ;
ALTER TABLE `alerts` DROP CONSTRAINT `c_alerts_2` ;
ALTER TABLE `alerts` DROP CONSTRAINT `c_alerts_3` ;
ALTER TABLE `alerts` DROP CONSTRAINT `c_alerts_4` ;
ALTER TABLE `alerts` DROP CONSTRAINT `c_alerts_5` ;
ALTER TABLE `alerts` DROP CONSTRAINT `c_alerts_6` ;

CREATE INDEX `alerts_1` ON `alerts` (`actionid`);
CREATE INDEX `alerts_2` ON `alerts` (`clock`);
CREATE INDEX `alerts_3` ON `alerts` (`eventid`);
CREATE INDEX `alerts_4` ON `alerts` (`status`);
CREATE INDEX `alerts_5` ON `alerts` (`mediatypeid`);
CREATE INDEX `alerts_6` ON `alerts` (`userid`);
CREATE INDEX `alerts_7` ON `alerts` (`p_eventid`);

ALTER TABLE `alerts` ADD CONSTRAINT `c_alerts_1` FOREIGN KEY (`actionid`) REFERENCES `actions` (`actionid`) ON DELETE CASCADE;
ALTER TABLE `alerts` ADD CONSTRAINT `c_alerts_2` FOREIGN KEY (`eventid`) REFERENCES `events` (`eventid`) ON DELETE CASCADE;
ALTER TABLE `alerts` ADD CONSTRAINT `c_alerts_3` FOREIGN KEY (`userid`) REFERENCES `users` (`userid`) ON DELETE CASCADE;
ALTER TABLE `alerts` ADD CONSTRAINT `c_alerts_4` FOREIGN KEY (`mediatypeid`) REFERENCES `media_type` (`mediatypeid`) ON DELETE CASCADE;
ALTER TABLE `alerts` ADD CONSTRAINT `c_alerts_5` FOREIGN KEY (`p_eventid`) REFERENCES `events` (`eventid`) ON DELETE CASCADE;
ALTER TABLE `alerts` ADD CONSTRAINT `c_alerts_6` FOREIGN KEY (`acknowledgeid`) REFERENCES `acknowledges` (`acknowledgeid`) ON DELETE CASCADE;