[mythtv-users] Baseball Season

[Gregorio Gervasio, Jr.]

>>>>> Bruce Markey writes:

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

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


        It only updates the first timestamp column automatically.
That's what the manual claims and I've done this multiple times.

        Hmm, that suggests an alternative (hack) to switching to
"datetime" everywhere:  insert a dummy "modtime" column and make it
the first timestamp column in the table.
-- 
Gregorio Gervasio, Jr.