Re: Merge table weirdness

On Sat, 8 May 2004, Sebastian Bergmann wrote:

> Mika Tuupola wrote:
> > 	Note that the per-month tables dont hae weekday and hour
> > 	columns. Since the per-month tables and the "main"
> > 	table have differing schemas the whole union is
> > 	broken:
> 
>   You have to update your old tables using the update script that ships
>   with phpOpenTracker >= 1.3.0 *before* you split them.

	phpOpenTracker-1.4.1 ships only with

		mysql/update/1_1_X_to_1_2_0.sql

	update script which does not look right to me. I guess you mean
	
		mysql/update/1_2_X_to_1_3_0.sql

	which can be found from cvs. The latter seems to add the missing
	weekday and hour columns. 	

-- 
Mika Tuupola                      http://www.appelsiini.net/~tuupola/



-------------------------------------------------------
This SF.Net email is sponsored by Sleepycat Software
Learn developer strategies Cisco, Motorola, Ericsson & Lucent use to deliver
higher performing products faster, at low TCO.
http://www.sleepycat.com/telcomwpreg.php?From=osdnemail3