[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