Re: [Bodington-developers] sql - versions?

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

surely they would have shown up between stable1 and 2.4.0? Does that  
mean that deleted tables in stable2 ended up back in 2.4.0?

Alistair

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

>
> 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
>>
>
>
> -------------------------------------------------------
> 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
>