Re: [Bodington-developers] sql - versions?

[Colin T. <col...@co...>]

I think Alistair's starting point is what's deployed at UHI (stable2)?

There were some database schema changes between stable1 and stable2 
(from memory, although I have some notes: Logbook, XML repository)

We had trouble upgrading from stable1 to 2_4, because the code that was 
supposed to run some SQL on the database to drop XML repository related 
tables didn't run, so we've ended up with a broken search tool (only 
finds resources created after the upgrade). It was looking for 
bod.properties identifying the current Bod version, which weren't 
present (and as far as I could tell don't ever get created unless you 
add them manually..)

Colin

Matthew Buckett wrote:
> Alistair Young wrote:
> 
>>> still accepting more stuff into HEAD
>>
>>
>> so I'll work the other way as it's an upgrade path, so it seems  
>> logical to do:
>> 2_1_1_stable2 -> 2_4
>> 2_4 -> 2_6
>>
>> I'll ignore the rc "releases".
> 
> 
> Looking at the release notes on sourceforge the 2.1.0 series was the 
> stable one and the 2.1.1 was aimed at being shapshots for 
> experiments/developers, but I may be wrong as I wasn't around in the 
> Bodington community when these versions were released.
>