Code: Select all
CREATE TABLE `recorded` (
`chanid` int(10) unsigned NOT NULL DEFAULT 0,
`starttime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`endtime` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`title` varchar(128) NOT NULL DEFAULT '',
`subtitle` varchar(128) NOT NULL DEFAULT '',
`description` varchar(16000) NOT NULL DEFAULT '',
`season` smallint(5) NOT NULL,
`episode` smallint(5) NOT NULL,
`category` varchar(64) NOT NULL DEFAULT '',
`hostname` varchar(64) NOT NULL DEFAULT '',
`bookmark` tinyint(1) NOT NULL DEFAULT 0,
`lastplay` tinyint(3) unsigned DEFAULT 0,
`editing` int(10) unsigned NOT NULL DEFAULT 0,
`cutlist` tinyint(1) NOT NULL DEFAULT 0,
`autoexpire` int(11) NOT NULL DEFAULT 0,
`commflagged` int(10) unsigned NOT NULL DEFAULT 0,
`recgroup` varchar(32) NOT NULL DEFAULT 'Default',
`recordid` int(11) DEFAULT NULL,
`seriesid` varchar(64) DEFAULT NULL,
`programid` varchar(64) DEFAULT NULL,
`inetref` varchar(40) NOT NULL,
`lastmodified` timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp(),
`filesize` bigint(20) NOT NULL DEFAULT 0,
`stars` float NOT NULL DEFAULT 0,
`previouslyshown` tinyint(1) DEFAULT 0,
`originalairdate` date DEFAULT NULL,
`preserve` tinyint(1) NOT NULL DEFAULT 0,
`findid` int(11) NOT NULL DEFAULT 0,
`deletepending` tinyint(1) NOT NULL DEFAULT 0,
`transcoder` int(11) NOT NULL DEFAULT 0,
`timestretch` float NOT NULL DEFAULT 1,
`recpriority` int(11) NOT NULL DEFAULT 0,
`basename` varchar(255) NOT NULL,
`progstart` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`progend` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',
`playgroup` varchar(32) NOT NULL DEFAULT 'Default',
`profile` varchar(32) NOT NULL DEFAULT '',
`duplicate` tinyint(1) NOT NULL DEFAULT 0,
`transcoded` tinyint(1) NOT NULL DEFAULT 0,
`watched` tinyint(4) NOT NULL DEFAULT 0,
`storagegroup` varchar(32) NOT NULL DEFAULT 'Default',
`bookmarkupdate` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00',
`recgroupid` smallint(4) NOT NULL DEFAULT 1,
`recordedid` int(10) unsigned NOT NULL AUTO_INCREMENT,
`inputname` varchar(32) DEFAULT NULL,
PRIMARY KEY (`recordedid`),
UNIQUE KEY `chanid` (`chanid`,`starttime`),
KEY `endtime` (`endtime`),
KEY `seriesid` (`seriesid`),
KEY `programid` (`programid`),
KEY `title` (`title`),
KEY `recordid` (`recordid`),
KEY `deletepending` (`deletepending`,`lastmodified`),
KEY `recgroup` (`recgroup`,`endtime`),
KEY `recgroupid` (`recgroupid`)
) ENGINE=Aria AUTO_INCREMENT=9355 DEFAULT CHARSET=utf8 COLLATE=utf8_general_ci PAGE_CHECKSUM=1
Code: Select all
SELECT TABLE_NAME, COLUMN_NAME, DATA_TYPE, IS_NULLABLE, COLUMN_DEFAULT FROM...
"program" "starttime" "datetime" "NO" "'0000-00-00 00:00:00'"
"recorded" "starttime" "datetime" "NO" "'0000-00-00 00:00:00'"
Code: Select all
Mar 25 18:29:57 <host> mythbackend: mythbackend[713]: N ProcessRequest recordinginfo.cpp:633 (ApplyRecordRecGroupChange) ApplyRecordRecGroupChange: Film to Deleted (3)
Mar 25 18:29:57 <host> mythbackend: mythbackend[713]: I ProcessRequest mythdbcon.cpp:733 (exec) MSqlQuery::exec(DBManager15) UPDATE recorded SET recgroup = 'Deleted', recgroupid = 'Deleted'ID WHERE chanid = '37954' AND starttime = '2022-08-10T22:20:00.000Z' ; <<<< Took 0ms
Mar 25 18:29:57 <host> mythbackend: mythbackend[713]: I ProcessRequest mythdbcon.cpp:733 (exec) MSqlQuery::exec(DBManager15) UPDATE recorded SET autoexpire = '9999' WHERE chanid = '37954' AND starttime = '2022-08-10T22:20:00.000Z' ; <<<< Took 0ms
Mar 25 18:29:57 <host> mythbackend: mythbackend[713]: I ProcessRequest mythdbcon.cpp:733 (exec) MSqlQuery::exec(DBManager15) UPDATE record SET last_delete = '2023-03-25T18:29:57.056Z', avg_delay = (avg_delay * 3 + '200') / 4 WHERE recordid = '668' <<<< Took 0ms