[mythtv] RFC: Program table change timestamp

[Chase Douglas]

On Apr 19, 2009, at 12:00 AM, George Nassas wrote:
> On 18-Apr-09, at 11:25 PM, Chase Douglas wrote:
>
>> This gives me a table-wide update time, but I need an update time  
>> for each row.
>
>
> create table stamps (n int, o int,
>    t timestamp default current_timestamp on update current_timestamp);
> insert into stamps (n) values (1), (2);
> select * from stamps;
>
> -- wait a second or two --
>
> update stamps set o = 1 where n = 2;
> select * from stamps;
>
> For me row 1 keeps the original time while row 2 shows an update.  
> What do you see?

I think this is exactly what I was looking for. Thanks for the tip!  
Now I need to figure out if it's possible to have mythfilldatabase  
update program info instead of wiping everything clean and repopulating.