Re: [Bodington-developers] sql - versions?

[Alistair Y. <ali...@sm...>]

My eye breaking research so far:

2.1.1 stable1 -> 2.4.0
log_book_entries - columns added
log_book_pages tables - columns added

xml_tokens - columns added
xml_words - columns added

user_x509s created

Colin - no sign of any tables that were deleted. That's worrying! Why  
do you need to delete tables in 2.4.0?

 From a fresh install, no tables have been removed.

Alistair

On 25 Jul 2005, at 12:15, Colin Tatham wrote:

> 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.
>>
>
>
> -------------------------------------------------------
> SF.Net email is sponsored by: Discover Easy Linux Migration Strategies
> from IBM. Find simple to follow Roadmaps, straightforward articles,
> informative Webcasts and more! Get everything you need to get up to
> speed, fast. http://ads.osdn.com/?ad_id=7477&alloc_id=16492&op=click
> _______________________________________________
> Bodington-developers mailing list
> Bod...@li...
> https://lists.sourceforge.net/lists/listinfo/bodington-developers
>