Difference between revisions of "Recorded table"
From MythTV Official Wiki
m (Table recorded moved to Recorded table) |
Goldfishbot (talk | contribs) (Added to Category:DB Table) |
||
Line 25: | Line 25: | ||
+-------------+------------------+------+-----+----------------+-------+ | +-------------+------------------+------+-----+----------------+-------+ | ||
</nowiki></pre> | </nowiki></pre> | ||
+ | [[Category:DB Table]] |
Revision as of 17:33, 3 March 2006
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 | | | +-------------+------------------+------+-----+----------------+-------+