Recorded table
From MythTV Official Wiki
Revision as of 16:48, 28 February 2006 by Gwilford (talk | contribs) (Recorded moved to Table recorded)
recorded
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.
+-------------+------------------+------+-----+----------------+-------+ | 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 | | | +-------------+------------------+------+-----+----------------+-------+