Difference between revisions of "Recorded table"
From MythTV Official Wiki
(Start headers a level 2. MythTV:Manual of Style) |
m (Remove unnecessary sub-heading) |
||
| Line 1: | Line 1: | ||
| − | |||
| − | |||
The 'recorded' table, unsurprisingly, lists programs which have already been recorded (or recorded and then transcoded), translating the [[Internal Filenames]] into something safe for human consumption. | The 'recorded' table, unsurprisingly, lists programs which have already been recorded (or recorded and then transcoded), translating the [[Internal Filenames]] into something safe for human consumption. | ||
Revision as of 13:52, 6 March 2006
The 'recorded' table, unsurprisingly, lists programs which have already been recorded (or recorded and then transcoded), translating the Internal Filenames into something safe for human consumption.
SVN Version
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| 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 |
Stable Version
| Field | Type | Null | Key | Default | Extra |
|---|---|---|---|---|---|
| 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 | varchar(128) | YES | NULL | ||
| editing | int(10) unsigned | 0 | |||
| cutlist | text | YES | NULL | ||
| 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 |
