SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES';

ALTER TABLE `event`
ADD COLUMN `deleted` TINYINT(4) NOT NULL DEFAULT 0 AFTER `active`,
ADD COLUMN `modified` INT(11) NULL DEFAULT 0 AFTER `deleted`,
ADD INDEX `idx_modified` (`modified` ASC),
ADD INDEX `idx_featured` (`featured` ASC),
ADD INDEX `idx_active` (`active` ASC),
ADD INDEX `idx_deleted` (`deleted` ASC);

SET SQL_MODE=@OLD_SQL_MODE;
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;