If you tell me the table name, I can supply the SQL to run to recreate it.
CREATE TABLE `program` (
`idProgram` int(11) NOT NULL AUTO_INCREMENT,
`idChannel` int(11) NOT NULL,
`startTime` datetime NOT NULL,
`endTime` datetime NOT NULL,
`title` varchar(2000) NOT NULL,
`description` text NOT NULL,
`seriesNum` varchar(200) NOT NULL,
`episodeNum` varchar(200) NOT NULL,
`genre` varchar(200) NOT NULL,
`originalAirDate` datetime NOT NULL,
`classification` varchar(200) NOT NULL,
`starRating` int(11) NOT NULL,
`parentalRating` int(11) NOT NULL,
`episodeName` text NOT NULL,
`episodePart` text NOT NULL,
`state` int(11) NOT NULL DEFAULT '0',
PRIMARY KEY (`idProgram`),
UNIQUE KEY `idProgramBeginEnd` (`idChannel`,`startTime`,`endTime`),
KEY `IDX_Program_State` (`state`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC$$
Here's the SQL:
Sorry for the delayed response