Difference between revisions of "Recorded table"
From MythTV Official Wiki
Goldfishbot (talk | contribs) (Added to Category:DB Table) |
|||
| Line 2: | Line 2: | ||
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. | ||
| + | |||
| + | = SVN Version = | ||
| + | |||
| + | <pre><nowiki> | ||
| + | +-------------+------------------+------+-----+----------------+-------+ | ||
| + | | 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 | | | | ||
| + | +-------------+------------------+------+-----+----------------+-------+ | ||
| + | </nowiki></pre> | ||
| + | |||
| + | = Stable Version = | ||
| + | |||
<pre><nowiki> | <pre><nowiki> | ||
+-------------+------------------+------+-----+----------------+-------+ | +-------------+------------------+------+-----+----------------+-------+ | ||
| Line 25: | Line 54: | ||
+-------------+------------------+------+-----+----------------+-------+ | +-------------+------------------+------+-----+----------------+-------+ | ||
</nowiki></pre> | </nowiki></pre> | ||
| + | |||
[[Category:DB Table]] | [[Category:DB Table]] | ||
Revision as of 08:40, 6 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.
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 | | | +-------------+------------------+------+-----+----------------+-------+
