Someone
public text v1 · immutable+-------------------------+-------------------------------------------------------------------+------+-----+---------------------+-------+
| 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 | NULL | |
| subtitle | varchar(128) | NO | | NULL | |
| description | text | NO | | NULL | |
| category | varchar(64) | NO | | NULL | |
| category_type | varchar(64) | NO | | NULL | |
| airdate | year(4) | NO | | 0000 | |
| stars | float unsigned | NO | | 0 | |
| previouslyshown | tinyint(4) | NO | MUL | 0 | |
| title_pronounce | varchar(128) | NO | MUL | NULL | |
| stereo | tinyint(1) | NO | | 0 | |
| subtitled | tinyint(1) | NO | | 0 | |
| hdtv | tinyint(1) | NO | | 0 | |
| closecaptioned | tinyint(1) | NO | | 0 | |
| partnumber | int(11) | NO | | 0 | |
| parttotal | int(11) | NO | | 0 | |
| seriesid | varchar(40) | NO | MUL | NULL | |
| originalairdate | date | YES | | NULL | |
| showtype | varchar(30) | NO | | NULL | |
| colorcode | varchar(20) | NO | | NULL | |
| syndicatedepisodenumber | varchar(20) | NO | | NULL | |
| programid | varchar(40) | NO | MUL | NULL | |
| manualid | int(10) unsigned | NO | PRI | 0 | |
| generic | tinyint(1) | YES | | 0 | |
| listingsource | int(11) | NO | | 0 | |
| first | tinyint(1) | NO | | 0 | |
| last | tinyint(1) | NO | | 0 | |
| audioprop | set('STEREO','MONO','SURROUND','DOLBY','HARDHEAR','VISUALIMPAIR') | NO | | NULL | |
| subtitletypes | set('HARDHEAR','NORMAL','ONSCREEN','SIGNED') | NO | | NULL | |
| videoprop | set('HDTV','WIDESCREEN','AVC') | NO | | NULL | |
+-------------------------+-------------------------------------------------------------------+------+-----+---------------------+-------+