-- ------------------------------------------------
-- Changed AC log to accomodate L10N changes
-- Created 20150225
-- ------------------------------------------------

ALTER TABLE `sod_log` 
ADD COLUMN `action` VARCHAR(16) NULL DEFAULT NULL AFTER `log`,
ADD COLUMN `regarding_id` INT NULL DEFAULT 0 AFTER `action`,
ADD COLUMN `replaced_id` INT NULL DEFAULT 0 AFTER `regarding_id`;

ALTER TABLE `sod_log` 
CHANGE COLUMN `log_type` `log_type` ENUM('rule','functionality','activity','group') NULL DEFAULT 'rule' ;