Recorded table
From MythTV Official Wiki
Revision as of 07:24, 17 August 2008 by Harvest316 (talk | contribs)
Note: The correct title of this article is recorded table. It appears incorrectly here due to technical restrictions.
The recorded table, lists programs which have already been recorded(or recorded and then transcoded) and are still available for viewing, translating the Internal Filenames into something safe for human consumption.
Table Description
Field name | Type | Null | Key | Default | Extras |
---|---|---|---|---|---|
chanid | int(10) unsigned | PRI | 0 | ||
starttime | timestamp(14) | YES | PRI | NULL | |
endtime | timestamp(14) | YES | MUL | 00000000000000 | |
title | varchar(128) | ||||
subtitle | varchar(128) | ||||
description | text | ||||
category | varchar(64) | ||||
hostname | varchar(255) | ||||
bookmark | tinyint(1) | 0 | |||
editing | int(10) unsigned | 0 | |||
cutlist | tinyint(1) | 0 | |||
autoexpire | int(11) | 0 | |||
commflagged | int(10) unsigned | 0 | |||
recgroup | varchar(32) | Default | |||
recordid | int(11) | YES | NULL | ||
seriesid | varchar(12) | MUL | |||
programid | varchar(12) | MUL |
Fields
- recgroup is the name of the recording group this recording belongs to. This relates to the recgroup field of the recgrouppassword table.
- bookmark=1 indicates that there is a 'Position Saved' for this recording (ie: user pressed space during playback, or exited playback early).
Hacks
If you want all bookmarked recordings to show up in the "Recording List" in their own category (say, '_Bookmarked'), you can use these mysql commands:
To update any shows already bookmarked:
UPDATE recorded
SET category = '_Bookmarked'
WHERE bookmark = 1;
and then, for all future bookmarks:
CREATE TRIGGER recorded_category BEFORE UPDATE ON recorded
FOR EACH ROW BEGIN
IF NEW.bookmark = 1 THEN
SET NEW.category = '_Bookmarked';
END IF;
END;
You then need to press M in Recording List, and Change Group View to show categories.
-- by harvest316