Re: [Bodington-developers] sql - versions?

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

Yes, you're right. I misread your email. Thought you said stable2 -> 2.4...

The tables are dropped and recreated, but I think the columns change. 
The details are all in org/bodington/installation/upgrade_2_1_to_2_1_1.sql

Colin

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