[mythtv] database schema
ijr at po.cwru.edu
Sun Mar 16 00:05:09 EST 2003
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.
More information about the mythtv-dev