CREATE TABLE `recordedseek` ( `chanid` int(10) unsigned NOT NULL default '0', `starttime` datetime NOT NULL default '0000-00-00 00:00:00', `mark` mediumint(8) unsigned NOT NULL default '0', `offset` bigint(20) unsigned NOT NULL, `type` tinyint(4) NOT NULL default '0', PRIMARY KEY (`chanid`,`starttime`,`type`,`mark`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1