rendered paste bodymysql> desc recorded;
+-----------------+------------------+------+-----+---------------------+-------+
| Field | Type | Null | Key | Default | Extra |
+-----------------+------------------+------+-----+---------------------+-------+
| chanid | int(10) unsigned | NO | PRI | 0 | |
| starttime | datetime | NO | PRI | 0000-00-00 00:00:00 | |
| endtime | datetime | NO | MUL | 0000-00-00 00:00:00 | |
| title | varchar(128) | NO | MUL | | |
| subtitle | varchar(128) | NO | | | |
| description | text | NO | | NULL | |
| category | varchar(64) | NO | | | |
| hostname | varchar(255) | NO | | | |
| bookmark | tinyint(1) | NO | | 0 | |
| editing | int(10) unsigned | NO | | 0 | |
| cutlist | tinyint(1) | NO | | 0 | |
| autoexpire | int(11) | NO | | 0 | |
| commflagged | int(10) unsigned | NO | | 0 | |
| recgroup | varchar(32) | NO | MUL | Default | |
| recordid | int(11) | YES | MUL | NULL | |
| seriesid | varchar(40) | NO | MUL | | |
| programid | varchar(40) | NO | MUL | | |
| lastmodified | timestamp | NO | | CURRENT_TIMESTAMP | |
| filesize | bigint(20) | NO | | 0 | |
| stars | float | NO | | 0 | |
| previouslyshown | tinyint(1) | YES | | 0 | |
| originalairdate | date | YES | | NULL | |
| preserve | tinyint(1) | NO | | 0 | |
| findid | int(11) | NO | | 0 | |
| deletepending | tinyint(1) | NO | MUL | 0 | |
| transcoder | int(11) | NO | | 0 | |
| timestretch | float | NO | | 1 | |
| recpriority | int(11) | NO | | 0 | |
| basename | varchar(255) | NO | | NULL | |
| progstart | datetime | NO | | 0000-00-00 00:00:00 | |
| progend | datetime | NO | | 0000-00-00 00:00:00 | |
| playgroup | varchar(32) | NO | | Default | |
| profile | varchar(32) | NO | | | |
| duplicate | tinyint(1) | NO | | 0 | |
| transcoded | tinyint(1) | NO | | 0 | |
| watched | tinyint(4) | NO | | 0 | |
| storagegroup | varchar(32) | NO | | Default | |
+-----------------+------------------+------+-----+---------------------+-------+
37 rows in set (0.00 sec)
select * from recorded where basename='1019_20080711155800.mpg'
-> ;
+--------+---------------------+---------------------+----------+----------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------+----------+----------+---------+---------+------------+-------------+----------+----------+-----------+-----------+---------------------+-----------+-------+-----------------+-----------------+----------+--------+---------------+------------+-------------+-------------+-------------------------+---------------------+---------------------+-----------+---------+-----------+------------+---------+--------------+
| chanid | starttime | endtime | title | subtitle | description | category | hostname | bookmark | editing | cutlist | autoexpire | commflagged | recgroup | recordid | seriesid | programid | lastmodified | filesize | stars | previouslyshown | originalairdate | preserve | findid | deletepending | transcoder | timestretch | recpriority | basename | progstart | progend | playgroup | profile | duplicate | transcoded | watched | storagegroup |
+--------+---------------------+---------------------+----------+----------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------+----------+----------+---------+---------+------------+-------------+----------+----------+-----------+-----------+---------------------+-----------+-------+-----------------+-----------------+----------+--------+---------------+------------+-------------+-------------+-------------------------+---------------------+---------------------+-----------+---------+-----------+------------+---------+--------------+
| 1019 | 2008-07-11 15:58:00 | 2008-07-11 17:02:00 | Top Gear | | Motoring magazine show with Jeremy Clarkson, James May and Richard Hammond. This week they build their own stretch limos out of the most improbable cars and then use them to take some top celebrities to the Brit Awards. Meanwhile, a good ol' boy Ford Mustang whoops around the test track and Billie Piper is the star in a reasonably priced car. | Transport | mythtv | 0 | 0 | 0 | 1 | 0 | Default | 147 | 103079474 | | 2008-07-11 16:36:58 | 891964684 | 0 | 0 | 0000-00-00 | 0 | 0 | 0 | 0 | 1 | 0 | 1019_20080711155800.mpg | 2008-07-11 16:00:00 | 2008-07-11 17:00:00 | Default | Default | 0 | 0 | 0 | Default |
+--------+---------------------+---------------------+----------+----------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+-----------+----------+----------+---------+---------+------------+-------------+----------+----------+-----------+-----------+---------------------+-----------+-------+-----------------+-----------------+----------+--------+---------------+------------+-------------+-------------+-------------------------+---------------------+---------------------+-----------+---------+-----------+------------+---------+--------------+
1 row in set (0.00 sec)