create table party(
id bigint(20) unsigned auto_increment,
irrad tinyint(1),
power double,
next_dose double,
dose double,
left_time double,
takeoff datetime,
primary key(id));

create table doses(
id bigint(20) unsigned auto_increment,
party_id bigint(20) unsigned,
power double,
begintime datetime,
endtime datetime,
irrad tinyint(1),
dose double,
primary key(id));

update doses set endtime=now(),dose=(now()-begintime)*power where irrad=true;
update party set dose=(select sum(dose) from doses where party_id=party.id,
left_time=(next_dose-dose)/power,takeoff=from_unixtime(unix_timestamp()+(next_dose-dose)/power)
where irrad=true;