Znuny Open Source Ticketsystem

create a separate table (ticket_state_time) (id,ticket_id,ticket_state,calculatedtime,....etc etc) create a trigger on the "ticket" table which insert a record in the ticket_state_time table when the ticket_state changes (NEW.ticket_state_id <> OLD.ticket_state_id) with the desired informa...