user7457679186173
获得徽章 0
- DROP TRIGGER IF EXISTS branch_remove;
CREATE TRIGGER branch_remove BEFORE DELETE
ON branch_table FOR EACH ROW
BEGIN
INSERT INTO branch_table_ar (`branch_id`, `xid`, `transaction_id`, `resource_group_id`, `resource_id`, `branch_type`, `status`, `client_id`, `application_data`, `gmt_create`, `gmt_modified`)
VALUES (old.branch_id, old.xid, old.transaction_id, old.resource_group_id, old.resource_id, old.branch_type, old.status, old.client_id, old.application_data, old.gmt_create, old.gmt_modified);
END展开评论点赞 - DROP TRIGGER IF EXISTS global_remove;
CREATE TRIGGER global_remove BEFORE DELETE
ON global_table FOR EACH ROW
BEGIN
INSERT INTO `global_table_ar` (`xid`, `transaction_id`, `status`, `application_id`, `transaction_service_group`, `transaction_name`, `timeout`, `begin_time`, `application_data`, `gmt_create`, `gmt_modified`) VALUES (old.xid, old.transaction_id, old.status, old.application_id, old.transaction_service_group, old.transaction_name, old.timeout, old.begin_time, old.application_data, old.gmt_create, old.gmt_modified);
IF OLD.STATUS in( 2, 3, 4, 5) THEN
DELETE FROM branch_table WHERE branch_table.xid = old.xid;
end IF;
END展开评论点赞
