Antes créala y añadimos estos campos

ALTER TABLE `mitabla`
ADD COLUMN `created_by` INT(11) NOT NULL,
ADD COLUMN `creation_date` DATETIME NOT NULL AFTER `created_by`,
ADD COLUMN `modified_by` INT(11) NULL AFTER `creation_date`,
ADD COLUMN `modification_date` DATETIME NULL AFTER `modified_by`,
ADD COLUMN `deleted_by` INT(11) NULL AFTER `modification_date`,
	ADD COLUMN `deleted_date` DATETIME NULL AFTER `deleted_by`;

# En caso de que la tabla no esté vacía, será necesario actualizar los siguientes 
# campos cuyo contenido no puede ser nulo
update mitabla set created_by = 1;

update mitabla set creation_date = now();


ALTER TABLE `mitabla`
 ADD CONSTRAINT `table_fk01` FOREIGN KEY (`created_by`) REFERENCES `users` (`user_id`),
 ADD CONSTRAINT `table_fk02` FOREIGN KEY (`modified_by`) REFERENCES `users` (`user_id`),
 ADD CONSTRAINT `table_fk03` FOREIGN KEY (`deleted_by`) REFERENCES `users` (`user_id`);