Recorded table

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 |                |       |
+-------------+------------------+------+-----+----------------+-------+