CREATE TRIGGER civicrm_case_after_update
after update ON civicrm_case
FOR EACH ROW BEGIN
    IF (
        (
            IFNULL(OLD.id,'') <> IFNULL(NEW.id,'')
            OR IFNULL(OLD.case_type_id,'') <> IFNULL(NEW.case_type_id,'')
            OR IFNULL(OLD.subject,'') <> IFNULL(NEW.subject,'')
            OR IFNULL(OLD.start_date,'') <> IFNULL(NEW.start_date,'')
            OR IFNULL(OLD.end_date,'') <> IFNULL(NEW.end_date,'')
            OR IFNULL(OLD.details,'') <> IFNULL(NEW.details,'')
            OR IFNULL(OLD.status_id,'') <> IFNULL(NEW.status_id,'')
            OR IFNULL(OLD.is_deleted,'') <> IFNULL(NEW.is_deleted,'')
        ) AND (
            @civicrm_disable_logging IS NULL OR @civicrm_disable_logging = 0
        )
    ) THEN
        INSERT INTO `log_civicrm`.log_civicrm_case
            (id, case_type_id, subject, start_date, end_date, details, status_id, is_deleted, log_conn_id, log_user_id, log_action)
            VALUES (NEW.id, NEW.case_type_id, NEW.subject, NEW.start_date, NEW.end_date, NEW.details, NEW.status_id, NEW.is_deleted, CONNECTION_ID(), @civicrm_user_id, 'update');
    END IF;
END

CREATE TABLE log_civicrm.`log_civicrm_setting` (
  `id` int(10) unsigned DEFAULT NULL,
  `group_name` varchar(64) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'group name for setting element, useful in caching setting elements',
  `name` varchar(255) COLLATE utf8_unicode_ci DEFAULT NULL COMMENT 'Unique name for setting',
  `value` text COLLATE utf8_unicode_ci COMMENT 'data associated with this group / name combo',
  `domain_id` int(10) unsigned DEFAULT NULL COMMENT 'Which Domain is this menu item for',
  `contact_id` int(10) unsigned DEFAULT NULL COMMENT 'FK to Contact ID if the setting is localized to a contact',
  `is_domain` tinyint(4) DEFAULT NULL COMMENT 'Is this setting a contact specific or site wide setting?',
  `component_id` int(10) unsigned DEFAULT NULL COMMENT 'Component that this menu item belongs to',
  `created_date` datetime DEFAULT NULL COMMENT 'When was the setting created',
  `created_id` int(10) unsigned DEFAULT NULL COMMENT 'FK to civicrm_contact, who created this setting',
  `log_date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
  `log_conn_id` varchar(17) COLLATE utf8_unicode_ci DEFAULT NULL,
  `log_user_id` int(11) DEFAULT NULL,
  `log_action` enum('Initialization','Insert','Update','Delete') COLLATE utf8_unicode_ci DEFAULT NULL,
  KEY `index_id` (`id`),
  KEY `index_log_conn_id` (`log_conn_id`),
  KEY `index_log_date` (`log_date`),
  KEY `index_contact_id` (`contact_id`),
  KEY `index_created_id` (`created_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci ROW_FORMAT=COMPRESSED KEY_BLOCK_SIZE=4 ;

INSERT INTO `log_civicrm`.log_civicrm_setting (id, group_name, name, value, domain_id, contact_id, is_domain, component_id, created_date, created_id, log_conn_id, log_user_id, log_action) 
SELECT id, group_name, name, value, domain_id, contact_id, is_domain, component_id, created_date, created_id, 
COALESCE(@uniqueID, LEFT(CONCAT('c_', unix_timestamp()/3600, CONNECTION_ID()), 17)), @civicrm_user_id, 'Initialization' 
FROM civicrm_setting;

DELIMITER //

DROP TRIGGER IF EXISTS civicrm_setting_after_insert//

CREATE TRIGGER civicrm_setting_after_insert after insert ON civicrm_setting FOR EACH ROW BEGIN  IF ( @civicrm_disable_logging IS NULL OR @civicrm_disable_logging = 0 ) THEN INSERT INTO `log_civicrm`.log_civicrm_setting (id, group_name, name, value, domain_id, contact_id, is_domain, component_id, created_date, created_id, log_conn_id, log_user_id, log_action) VALUES ( NEW.id, NEW.group_name, NEW.name, NEW.value, NEW.domain_id, NEW.contact_id, NEW.is_domain, NEW.component_id, NEW.created_date, NEW.created_id, COALESCE(@uniqueID, LEFT(CONCAT('c_', unix_timestamp()/3600, CONNECTION_ID()), 17)), @civicrm_user_id, 'insert');END IF; END//

DROP TRIGGER IF EXISTS civicrm_setting_after_update//

CREATE TRIGGER civicrm_setting_after_update after update ON civicrm_setting FOR EACH ROW BEGIN  IF ( (IFNULL(OLD.id,'') <> IFNULL(NEW.id,'') OR IFNULL(OLD.group_name,'') <> IFNULL(NEW.group_name,'') OR IFNULL(OLD.name,'') <> IFNULL(NEW.name,'') OR IFNULL(OLD.value,'') <> IFNULL(NEW.value,'') OR IFNULL(OLD.domain_id,'') <> IFNULL(NEW.domain_id,'') OR IFNULL(OLD.contact_id,'') <> IFNULL(NEW.contact_id,'') OR IFNULL(OLD.is_domain,'') <> IFNULL(NEW.is_domain,'') OR IFNULL(OLD.component_id,'') <> IFNULL(NEW.component_id,'') OR IFNULL(OLD.created_date,'') <> IFNULL(NEW.created_date,'') OR IFNULL(OLD.created_id,'') <> IFNULL(NEW.created_id,'')) AND ( @civicrm_disable_logging IS NULL OR @civicrm_disable_logging = 0 ) ) THEN INSERT INTO `log_civicrm`.log_civicrm_setting (id, group_name, name, value, domain_id, contact_id, is_domain, component_id, created_date, created_id, log_conn_id, log_user_id, log_action) VALUES (NEW.id, NEW.group_name, NEW.name, NEW.value, NEW.domain_id, NEW.contact_id, NEW.is_domain, NEW.component_id, NEW.created_date, NEW.created_id, COALESCE(@uniqueID, LEFT(CONCAT('c_', unix_timestamp()/3600, CONNECTION_ID()), 17)), @civicrm_user_id, 'update');END IF; END//



DROP TRIGGER IF EXISTS civicrm_setting_after_delete//


CREATE TRIGGER civicrm_setting_after_delete after delete ON civicrm_setting FOR EACH ROW BEGIN  IF ( @civicrm_disable_logging IS NULL OR @civicrm_disable_logging = 0 ) THEN INSERT INTO `log_civicrm`.log_civicrm_setting (id, group_name, name, value, domain_id, contact_id, is_domain, component_id, created_date, created_id, log_conn_id, log_user_id, log_action) VALUES ( OLD.id, OLD.group_name, OLD.name, OLD.value, OLD.domain_id, OLD.contact_id, OLD.is_domain, OLD.component_id, OLD.created_date, OLD.created_id, COALESCE(@uniqueID, LEFT(CONCAT('c_', unix_timestamp()/3600, CONNECTION_ID()), 17)), @civicrm_user_id, 'delete');END IF; END//

DELIMITER ;