Table Non_unique Key_name Seq_in_index Column_name Collation Cardinality Sub_part Packed Null Index_type Comment Index_comment record 0 PRIMARY 1 recordid A 1 NULL NULL BTREE record 0 chanid 1 chanid A NULL NULL NULL YES BTREE record 0 chanid 2 starttime A NULL NULL NULL YES BTREE record 0 chanid 3 startdate A NULL NULL NULL YES BTREE record 0 chanid 4 title A NULL NULL NULL BTREE record 0 chanid 5 type A NULL NULL NULL BTREE record 1 title 1 title A NULL NULL NULL BTREE record 1 seriesid 1 seriesid A NULL NULL NULL YES BTREE record 1 programid 1 programid A NULL NULL NULL YES BTREE record 1 maxepisodes 1 maxepisodes A NULL NULL NULL BTREE record 1 search 1 search A NULL NULL NULL BTREE record 1 type 1 type A NULL NULL NULL BTREE record 1 recgroupid 1 recgroupid A NULL NULL NULL BTREE