     END$$
 DELIMITER ;
 
-# VolumeSnapshotTreeEO
-DROP TRIGGER IF EXISTS trigger_clean_AccountResourceRefVO_for_VolumeSnapshotTreeEO;
-DELIMITER $$
-CREATE TRIGGER trigger_clean_AccountResourceRefVO_for_VolumeSnapshotTreeEO AFTER UPDATE ON `VolumeSnapshotTreeEO`
-FOR EACH ROW
-    BEGIN
-        IF OLD.`deleted` IS NULL AND NEW.`deleted` IS NOT NULL THEN
-            DELETE FROM `AccountResourceRefVO` WHERE `resourceUuid` = OLD.`uuid` AND `resourceType` = 'VolumeSnapshotTreeVO';
-        END IF;
-    END$$
-DELIMITER ;
-
-# ZoneEO
-DROP TRIGGER IF EXISTS trigger_clean_AccountResourceRefVO_for_ZoneEO;
-DELIMITER $$
-CREATE TRIGGER trigger_clean_AccountResourceRefVO_for_ZoneEO AFTER UPDATE ON `ZoneEO`
-FOR EACH ROW
-    BEGIN
-        IF OLD.`deleted` IS NULL AND NEW.`deleted` IS NOT NULL THEN
-            DELETE FROM `AccountResourceRefVO` WHERE `resourceUuid` = OLD.`uuid` AND `resourceType` = 'ZoneVO';
-        END IF;
-    END$$
-DELIMITER ;
 
 ALTER TABLE `zstack`.`SharedResourceVO` ADD UNIQUE INDEX(`ownerAccountUuid`,`receiverAccountUuid`,`resourceUuid`);
 ALTER TABLE `zstack`.`ShareableVolumeVmInstanceRefVO` ADD UNIQUE INDEX(`volumeUuid`,`vmInstanceUuid`);

    END$$
DELIMITER ;

# QuotaVO
DROP TRIGGER IF EXISTS trigger_clean_AccountResourceRefVO_for_QuotaVO;
DELIMITER $$

    END$$
DELIMITER ;

# L3NetworkEO
DROP TRIGGER IF EXISTS trigger_clean_AccountResourceRefVO_for_L3NetworkEO;
DELIMITER $$
