using triggers to update applicable_from for all MySQL versions