Re: [Bodington-developers] sql - versions?

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

I was referring to schema changes between stable1 and stable2...


Alistair Young wrote:
> 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
>>
> 
> 
> 
> -------------------------------------------------------
> 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
>