[mythtv-users] Recordedmarkup table structure

Phill Edwards philledwards at gmail.com
Sat Jun 18 05:52:52 UTC 2005


> I had some horrible power fluctuations at home last night and it
> severely corrupted my recordedmarkup table.  I decided not to repair it
> since it was really big and I thought it would be best to re-create it
> from scratch.  My backup was invalid because I didn't realize the error
> until just now.  This is what I have for the table structure from old
> Google caches of others:
> 
> Field           Type            Null    Default
> chanid          int(10)         No      0
> starttime       datetime        No      0000-00-00 00:00:00
> mark    bigint(20)      No      0
> type    int(11)         No      0
> offset          varchar(32)     Yes     NULL
> 
> 
>  Indexes :
> Keyname         Type    Cardinality     Field
> PRIMARY         PRIMARY         1500    chanid
> starttime
> mark
> Type


Mine looks like this. I'm on 0.18.1.

+-----------+------------------+------+-----+---------------------+-------+
| Field     | Type             | Null | Key | Default             | Extra |
+-----------+------------------+------+-----+---------------------+-------+
| chanid    | int(10) unsigned |      | PRI | 0                   |       |
| starttime | datetime         |      | PRI | 0000-00-00 00:00:00 |       |
| mark      | bigint(20)       |      | PRI | 0                   |       |
| offset    | varchar(32)      | YES  |     | NULL                |       |
| type      | int(11)          |      | PRI | 0                   |       |
+-----------+------------------+------+-----+---------------------+-------+

Sorry, I don't know how to show the indexes.

Regards,
Phill


More information about the mythtv-users mailing list