[mythtv] database schema

[Isaac Richards]

On Saturday 15 March 2003 06:51 am, Chris Palmer wrote:
> My guess is that when the schema was first designed, that it
> was assumed that the TIMESTAMP datatype was the proper type
> based solely on its name.  As a datatype it is interchangeable
> with the DATETIME field, but it has other specific built-in
> functionality which makes it useful for logging/tracking of
> database updates.

I chose the timestamp datatype because I liked its storage format more, and 
it's half the size of the datetime datatype.  Modification to the records in 
question rarely happens, so I figured it wasn't that big of a deal.

Isaac