CREATE TABLE `timers` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT,
`inssp` int(11) DEFAULT NULL,
`updsp` int(11) DEFAULT NULL,
`eventid` int(11) unsigned DEFAULT NULL COMMENT 'useid',
`channelid` varchar(50) DEFAULT NULL,
`_starttime` int(10) DEFAULT NULL COMMENT 'pre filled start timer for trigger',
`vdruuid` varchar(40) DEFAULT NULL,
`source` varchar(40) DEFAULT NULL COMMENT 'like osd, webif, epgd',
`type` varchar(1) DEFAULT NULL COMMENT '''R''ecord, ''V''iew (umschalt)',
`state` varchar(1) DEFAULT 'u' COMMENT '''D''eleted, ''R''unning, ''F''inished',
`info` varchar(255) DEFAULT NULL COMMENT 'error reason if state is failed',
`action` varchar(1) DEFAULT 'a',
`tccmailcnt` int(11) unsigned DEFAULT NULL,
`wrncount` int(11) unsigned DEFAULT NULL,
`retrys` int(11) unsigned DEFAULT NULL,
`namingmode` int(11) DEFAULT NULL,
`template` varchar(100) DEFAULT NULL,
`active` int(11) unsigned DEFAULT NULL,
`day` int(10) DEFAULT NULL,
`weekdays` int(10) DEFAULT NULL,
`starttime` int(10) DEFAULT NULL,
`endtime` int(10) DEFAULT NULL,
`file` varchar(512) DEFAULT NULL,
`directory` varchar(512) DEFAULT NULL,
`priority` int(11) DEFAULT NULL,
`lifetime` int(11) DEFAULT NULL,
`vps` int(11) DEFAULT NULL,
`childlock` int(11) DEFAULT NULL,
`aux` varchar(1000) DEFAULT NULL,
`autotimername` varchar(100) DEFAULT NULL COMMENT 'Bezeichung des Suchtimers',
`autotimerid` int(11) unsigned DEFAULT NULL COMMENT 'id of autotimer',
`autotimerinssp` int(11) DEFAULT NULL,
`doneid` int(11) unsigned DEFAULT NULL COMMENT 'id of done entry',
`expression` varchar(200) DEFAULT NULL,
PRIMARY KEY (`id`),
KEY `idxeventidchannelidvdruuid` (`eventid`,`channelid`,`vdruuid`),
KEY `idxvdruuidstate` (`vdruuid`,`state`),
KEY `idxupdsp` (`updsp`)
) ENGINE=InnoDB AUTO_INCREMENT=4358 DEFAULT CHARSET=utf8
Display More