Has the database schema changed?

[John Ralls]

> On Apr 3, 2016, at 7:59 AM, Colin Law <clanlaw at gmail.com> wrote:
> 
> Has the database schema changed recently?  I have some scripts that
> extract reports from the mysql db and the prices table appears to be
> empty.  I cannot immediately find where they have moved to.  To save
> me wading through everything can anyone help me out?  I am now on
> 2.6.9, I think I was on 2.6.3 before.

No schema changes, but a change in the way currency exchange rates are handled. This has been discussed at length here over the last several months. If you're querying currency exchange rates try reversing the exchange-rate direction. BTW, the change was introduced in 2.6.9 and naturally produced a few bugs. All of the reported ones have been fixed in 2.6.12 so I suggest that you upgrade to that if you're doing multi-currency transactions. 

Regards,
John Ralls