[mythtv-users] Baseball Season

[Bruce Markey]

Joseph A. Caputo wrote:
> On Monday 05 April 2004 15:38, Bruce Markey wrote:
> 
>>The others who posted are correct, this is because the starttime
>>and endtime are TIMESTAMP fields. However, they both are timestamp
>>so you need to (re)set endtime=endtime also =).
>>
> 
> 
> Is this necessarily true?  I was under the impression that only the 
> *first* TIMESTAMP field in a table is automatically updated, so the 
> 'endtime' field could safely be left alone.

I believe it is the first unspecified field but the proof is
in the pudding. Try it and see what happens.  I seem to remember
that the second field would timestamp update if the first was
specified but I've long since altered these to be "datetime"
to avoid the issue completely =).

--  bjm