Ticket #4757: record.sql

File record.sql, 1.1 KB (added by Ron Frazier <ron@…>, 12 years ago)

power search example

Line 
1INSERT INTO `record` (`recordid`, `type`, `chanid`, `starttime`, `startdate`, `endtime`, `enddate`, `title`, `subtitle`, `description`, `category`, `profile`, `recpriority`, `autoexpire`, `maxepisodes`, `maxnewest`, `startoffset`, `endoffset`, `recgroup`, `dupmethod`, `dupin`, `station`, `seriesid`, `programid`, `search`, `autotranscode`, `autocommflag`, `autouserjob1`, `autouserjob2`, `autouserjob3`, `autouserjob4`, `findday`, `findtime`, `findid`, `inactive`, `parentid`, `transcoder`, `tsdefault`, `playgroup`, `prefinput`, `next_record`, `last_record`, `last_delete`, `storagegroup`, `avg_delay`) VALUES
2(173, 4, 0, '11:47:09', '2008-02-10', '11:47:09', '2008-02-10', 'Survivor        (Power Search)', 'LEFT JOIN programgenres ON program.chanid = programgenres.chanid AND program.starttime = programgenres.starttime \n', 'program.title LIKE ''Survivor: %'' \nAND programgenres.genre = ''Reality'' \nAND channel.callsign = ''WWJ'' ', '', 'Default', 0, 1, 0, 0, 0, 0, 'Default', 6, 31, '', '', '', 1, 0, 1, 1, 0, 0, 0, 1, '00:00:00', 733447, 0, 0, 0, 1, 'Default', 0, '0000-00-00 00:00:00', '2008-05-11 22:00:04', '2008-05-12 08:45:42', 'Default', 43);