delimiter $$
CREATE TRIGGER prop_trigger
BEFORE UPDATE ON DataOnDisk
FOR EACH ROW
BEGIN
	IF NEW.header > 0 THEN
		SET NEW.calibration = 6;
	END IF;
	IF NEW.calibration > 0 THEN
		SET NEW.auxiliary = 6;
		SET NEW.callisto = 6;
	END IF;
	IF NEW.callisto > 0 THEN
		SET NEW.star = 6;
	END IF;
END; $$
delimiter ;
