Ticket #6296: record.sql

File record.sql, 19.1 KB (added by steltek@…, 15 years ago)

Record and Record_tmp tables (SQL dump)

Line 
1-- MySQL dump 10.11
2--
3-- Host: localhost    Database: mythconverg
4-- ------------------------------------------------------
5-- Server version       5.0.51a-24-log
6
7/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
8/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
9/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
10/*!40101 SET NAMES utf8 */;
11/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
12/*!40103 SET TIME_ZONE='+00:00' */;
13/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
14/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
15/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
16/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
17
18--
19-- Table structure for table `record`
20--
21
22DROP TABLE IF EXISTS `record`;
23SET @saved_cs_client     = @@character_set_client;
24SET character_set_client = utf8;
25CREATE TABLE `record` (
26  `recordid` int(10) unsigned NOT NULL auto_increment,
27  `type` int(10) unsigned NOT NULL default '0',
28  `chanid` int(10) unsigned default NULL,
29  `starttime` time NOT NULL default '00:00:00',
30  `startdate` date NOT NULL default '0000-00-00',
31  `endtime` time NOT NULL default '00:00:00',
32  `enddate` date NOT NULL default '0000-00-00',
33  `title` varchar(128) NOT NULL default '',
34  `subtitle` varchar(128) NOT NULL default '',
35  `description` text NOT NULL,
36  `category` varchar(64) NOT NULL default '',
37  `profile` varchar(128) NOT NULL default 'Default',
38  `recpriority` int(10) NOT NULL default '0',
39  `autoexpire` int(11) NOT NULL default '0',
40  `maxepisodes` int(11) NOT NULL default '0',
41  `maxnewest` int(11) NOT NULL default '0',
42  `startoffset` int(11) NOT NULL default '0',
43  `endoffset` int(11) NOT NULL default '0',
44  `recgroup` varchar(32) NOT NULL default 'Default',
45  `dupmethod` int(11) NOT NULL default '6',
46  `dupin` int(11) NOT NULL default '15',
47  `station` varchar(20) NOT NULL default '',
48  `seriesid` varchar(40) NOT NULL default '',
49  `programid` varchar(40) NOT NULL default '',
50  `search` int(10) unsigned NOT NULL default '0',
51  `autotranscode` tinyint(1) NOT NULL default '0',
52  `autocommflag` tinyint(1) NOT NULL default '0',
53  `autouserjob1` tinyint(1) NOT NULL default '0',
54  `autouserjob2` tinyint(1) NOT NULL default '0',
55  `autouserjob3` tinyint(1) NOT NULL default '0',
56  `autouserjob4` tinyint(1) NOT NULL default '0',
57  `findday` tinyint(4) NOT NULL default '0',
58  `findtime` time NOT NULL default '00:00:00',
59  `findid` int(11) NOT NULL default '0',
60  `inactive` tinyint(1) NOT NULL default '0',
61  `parentid` int(11) NOT NULL default '0',
62  `transcoder` int(11) NOT NULL default '0',
63  `tsdefault` float NOT NULL default '1',
64  `playgroup` varchar(32) NOT NULL default 'Default',
65  `prefinput` int(10) NOT NULL default '0',
66  `next_record` datetime NOT NULL,
67  `last_record` datetime NOT NULL,
68  `last_delete` datetime NOT NULL,
69  `storagegroup` varchar(32) NOT NULL default 'Default',
70  `avg_delay` int(11) NOT NULL default '100',
71  PRIMARY KEY  (`recordid`),
72  KEY `chanid` (`chanid`,`starttime`),
73  KEY `title` (`title`),
74  KEY `seriesid` (`seriesid`),
75  KEY `programid` (`programid`),
76  KEY `maxepisodes` (`maxepisodes`),
77  KEY `search` (`search`),
78  KEY `type` (`type`)
79) ENGINE=MyISAM AUTO_INCREMENT=567 DEFAULT CHARSET=latin1;
80SET character_set_client = @saved_cs_client;
81
82--
83-- Dumping data for table `record`
84--
85
86LOCK TABLES `record` WRITE;
87/*!40000 ALTER TABLE `record` DISABLE KEYS */;
88INSERT INTO `record` VALUES (260,3,18501,'00:45:00','2007-07-04','01:15:00','2007-07-04','Kalkofes Mattscheibe','','','Unknown','Default',3,1,0,0,0,0,'Default',6,15,'ProSieben','69168613','',0,1,1,0,0,0,0,6,'00:50:00',732949,0,0,28,1,'Default',0,'0000-00-00 00:00:00','2008-11-22 08:02:34','2009-02-10 21:53:20','Default',195),(527,3,18501,'07:15:00','2008-04-06','09:20:00','2008-04-06','Germany\'s Next Topmodel - by Heidi Klum','Casting-Show,D 2006','Die MÀdchen von \'Germany\'s next Topmodel - by Heidi Klum\' sind auch diese Woche in New York. Auf sie warten weitere spannende Castings und ein aufregendes Fotoshooting.','','Default',0,1,0,0,5,15,'Default',6,15,'ProSieben','8727613','',0,1,1,0,0,0,0,5,'20:15:00',0,0,0,28,1,'Default',0,'2009-02-26 20:09:00','2009-02-22 07:50:15','2009-02-22 20:02:46','Default',66),(545,3,1052,'21:00:00','2008-06-29','22:00:00','2008-06-29','Top Gear','','Top Gear runs the gamut this week, from the very cool Audi RS6 estate to the so-uncool-it-almost-comes-around-the-other-side-and-is-cool-again MG Maestro. The Audi is put to the test by Richard Hammond in one of his head-to-head man v machine contests, this time involving French skiers. We can assume mountain roads make an appearance and that the ending is very close. The MG Maestro, meanwhile, is roped into a challenge for the new stuntman/bravery expert. Top Gear doesn\'t issue DVDs, so at the time of writing we still don\'t know who this mystery newcomer is or what he\'ll do, but it\'s a safe bet that smashing things up comes into it. As for Clarkson, he gets effusive about the Mercedes CLK Black, a car he\'s described in print as \"exciting beyond words\", though we can be sure he\'ll find quite a few. And the famous folk dropping by for a chat and a spin around the track are Spooks actors Rupert Penry-Jones and Peter Firth.RT reviewer - David Butcher','Entertainment','Default',-1,1,0,0,0,0,'Default',8,15,'BBC 2 England','103079474','',0,1,1,0,0,0,0,1,'21:00:00',733588,0,0,28,1,'Default',0,'2009-03-01 20:10:00','2009-02-22 20:04:01','2009-02-22 20:37:42','Default',117),(566,1,18501,'00:05:27','2009-02-24','00:38:14','2009-02-24','red! Die Oscar-Highlights','','In der Nacht vom 22. Februar 2009 wurden in Hollywoods Kodak Theatre zum 81. Mal die Oscars an die Besten der Filmbranche verliehen - ProSieben hat live und exklusiv berichtet. Live vor Ort war Moderatorin Annemarie Warnkross. Sie prÀsentiert heute noch einmal die Gewinner und die Höhepunkte der Academy Awards.','Preisverleihung','Default',0,1,0,0,0,0,'Default',6,15,'ProSieben','45968675','',0,0,0,0,0,0,0,3,'00:05:27',733827,0,0,0,1,'Default',0,'2009-02-24 00:05:27','0000-00-00 00:00:00','0000-00-00 00:00:00','Default',100),(565,1,18501,'17:29:47','2009-02-23','17:59:35','2009-02-23','red! Die Oscar-Highlights','','In der Nacht vom 22. Februar 2009 wurden in Hollywoods Kodak Theatre zum 81. Mal die Oscars an die Besten der Filmbranche verliehen - ProSieben hat live und exklusiv berichtet. Live vor Ort war Moderatorin Annemarie Warnkross. Sie prÀsentiert heute noch einmal die Gewinner und die Höhepunkte der Academy Awards.','Preisverleihung','Default',0,1,0,0,0,0,'Default',6,15,'ProSieben','45968675','',0,0,0,0,0,0,0,2,'17:29:47',733827,0,0,0,1,'Default',0,'0000-00-00 00:00:00','2009-02-23 17:28:49','0000-00-00 00:00:00','Default',100),(563,1,18501,'02:00:00','2009-02-23','05:50:00','2009-02-23','Oscar 2009 - Die Academy Awards - live aus L.A.','LIVE:','ProSieben prÀsentiert die 81. Academy Awards - live und exklusiv aus dem Kodak Theatre in Hollywood! Durch die Show wird diesmal der australische Schauspieler Hugh Jackman fÌhren.','Preisverleihung','Default',0,1,0,0,0,0,'Default',6,15,'ProSieben','28821070','',0,0,0,0,0,0,0,2,'02:00:00',733826,0,0,0,1,'Default',0,'0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','Default',100),(564,1,18501,'01:30:00','2009-02-23','02:00:00','2009-02-23','red! Carpet - live beim Oscar 2009','LIVE:','Der rote Teppich ist ausgerollt - fÌr die 81. Verleihung der Oscars! Annemarie Warnkross befindet sich live vor Ort und begleitet das Eintreffen der Filmstars im Blitzlichtgewitter mit Interviews und Kommentaren ...','Preisverleihung','Default',0,1,0,0,0,0,'Default',6,15,'ProSieben','140748585','',0,0,0,0,0,0,0,2,'01:30:00',733826,0,0,0,1,'Default',0,'0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00','Default',100);
89/*!40000 ALTER TABLE `record` ENABLE KEYS */;
90UNLOCK TABLES;
91
92--
93-- Table structure for table `record_tmp`
94--
95
96DROP TABLE IF EXISTS `record_tmp`;
97SET @saved_cs_client     = @@character_set_client;
98SET character_set_client = utf8;
99CREATE TABLE `record_tmp` (
100  `recordid` int(10) unsigned NOT NULL default '0',
101  `type` int(10) unsigned NOT NULL default '0',
102  `chanid` int(10) unsigned default NULL,
103  `starttime` time NOT NULL default '00:00:00',
104  `startdate` date NOT NULL default '0000-00-00',
105  `endtime` time NOT NULL default '00:00:00',
106  `enddate` date NOT NULL default '0000-00-00',
107  `title` varchar(128) NOT NULL default '',
108  `subtitle` varchar(128) NOT NULL default '',
109  `description` text NOT NULL,
110  `category` varchar(64) NOT NULL default '',
111  `profile` varchar(128) NOT NULL default 'Default',
112  `recpriority` int(10) NOT NULL default '0',
113  `autoexpire` int(11) NOT NULL default '0',
114  `maxepisodes` int(11) NOT NULL default '0',
115  `maxnewest` int(11) NOT NULL default '0',
116  `startoffset` int(11) NOT NULL default '0',
117  `endoffset` int(11) NOT NULL default '0',
118  `recgroup` varchar(32) NOT NULL default 'Default',
119  `dupmethod` int(11) NOT NULL default '6',
120  `dupin` int(11) NOT NULL default '15',
121  `station` varchar(20) NOT NULL default '',
122  `seriesid` varchar(12) NOT NULL default '',
123  `programid` varchar(20) NOT NULL default '',
124  `search` int(10) unsigned NOT NULL default '0',
125  `autotranscode` tinyint(1) NOT NULL default '0',
126  `autocommflag` tinyint(1) NOT NULL default '0',
127  `autouserjob1` tinyint(1) NOT NULL default '0',
128  `autouserjob2` tinyint(1) NOT NULL default '0',
129  `autouserjob3` tinyint(1) NOT NULL default '0',
130  `autouserjob4` tinyint(1) NOT NULL default '0',
131  `findday` tinyint(4) NOT NULL default '0',
132  `findtime` time NOT NULL default '00:00:00',
133  `findid` int(11) NOT NULL default '0',
134  `inactive` tinyint(1) NOT NULL default '0',
135  `parentid` int(11) NOT NULL default '0',
136  `transcoder` int(11) NOT NULL default '0',
137  `tsdefault` float NOT NULL default '1',
138  `playgroup` varchar(32) NOT NULL default 'Default',
139  `prefinput` int(10) NOT NULL default '0',
140  `next_record` datetime NOT NULL,
141  `last_record` datetime NOT NULL,
142  `last_delete` datetime NOT NULL
143) ENGINE=MyISAM DEFAULT CHARSET=latin1;
144SET character_set_client = @saved_cs_client;
145
146--
147-- Dumping data for table `record_tmp`
148--
149
150LOCK TABLES `record_tmp` WRITE;
151/*!40000 ALTER TABLE `record_tmp` DISABLE KEYS */;
152INSERT INTO `record_tmp` VALUES (388,3,1001,'22:45:00','2006-09-27','23:15:00','2006-09-27','Harald Schmidt','','Late Night Show * Ob FuÃŞball, Papstbesuch oder Politikerkaste: Wenn ordentlich was los ist im LÀndle, lÀuft Harald Schmidt zur Höchstform auf. Mal zynisch, bissig, gnadenlos oder einfach auch mal platt.','Show','Low Quality',2,1,10,0,0,15,'Default',6,15,'Das Erste','18291972','',0,1,0,0,0,0,0,4,'23:00:00',732946,0,0,29,1,'Default',0,'0000-00-00 00:00:00','2006-10-26 23:14:01','2006-10-26 22:28:31'),(206,3,1028,'10:00:00','2005-02-13','11:00:00','2005-02-13','SchillerstraÃŞe','','Die Observation * Spielleiter: Georg Uecker','Comedy-Show','Default',0,0,0,0,0,5,'Default',6,15,'SAT.1','','',0,0,1,0,0,0,0,0,'00:00:00',0,0,0,0,1,'Default',0,'0000-00-00 00:00:00','2006-10-29 10:29:01','2006-10-17 21:24:46'),(260,3,1024,'00:00:00','2006-09-30','00:00:00','2006-09-30','Kalkofes Mattscheibe','2','','Comedy','Default',3,1,0,0,10,10,'Default',6,15,'ProSieben','69168613','',0,0,1,0,0,0,0,6,'00:50:00',732949,0,0,0,1,'Default',0,'0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00'),(256,3,1024,'11:30:00','2005-04-02','11:55:00','2005-04-02','switch','TV gnadenlos parodiert!','','Comedy-Reihe','Default',0,1,0,0,0,0,'Default',6,15,'ProSieben','128846488','',0,0,1,0,0,0,0,0,'00:00:00',0,0,0,0,1,'Default',0,'0000-00-00 00:00:00','2006-10-07 11:15:02','2006-10-07 17:46:12'),(405,8,1024,'09:15:00','2006-11-05','11:30:00','2006-11-05','Popstars','','Castingshow','Unknown','Low Quality',1,1,0,0,5,10,'Default',6,15,'ProSieben','108703203','',0,1,1,0,0,0,0,5,'20:15:00',732948,0,0,29,1,'Default',0,'0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00'),(403,9,1042,'21:45:00','2006-10-23','22:15:00','2006-10-23','Dittsche - Das wirklich wahre Leben','','Olli Dittrich','Unknown','Default',0,1,0,0,0,0,'Default',6,15,'EinsFestival','54707726','',0,1,0,0,0,0,0,2,'21:45:00',732972,0,0,28,1,'Default',0,'0000-00-00 00:00:00','2006-10-30 21:44:01','2006-10-26 22:04:30'),(399,10,1024,'20:15:00','2006-10-16','21:15:00','2006-10-16','Michael Mittermeier: Paranoid','','\"Das Ende der Welt ist nah: Eine Frau ist unsere Chefin, ein Bayer der Papst und Italien FuÃŞballweltmeister.\" In seinem ersten BÌhnenprogramm \"Zapped!\" outete sich Michi Mittermeier noch als TV-Junkie. SpÀtestens seit einem lÀngeren Aufenthalt in New York ist er politischer geworden - und fÌllt noch immer oder erst recht groÃŞe Hallen. Seine Mischung aus gut sitzender Pointe, vollem Körpereinsatz und unnachahmlicher Stimme macht\'s. Zu sehen endlich auch im TV in einer aktualisierten Version von \"Paranoid\".','Satire','Default',0,1,0,0,10,10,'Default',6,15,'ProSieben','184871108','',0,0,0,0,0,0,0,2,'20:15:00',732965,0,0,0,1,'Default',0,'0000-00-00 00:00:00','2006-10-23 20:04:01','0000-00-00 00:00:00'),(378,3,1024,'00:00:00','2006-09-29','00:00:00','2006-09-29','Popstars','','Castingshow * Jury-Mitglied Nina Hagen (M.) schlÌpft gern in Rollen. Hier zeigt sie Mutter-Teresa-ZÌge und fasst selbst talentfreieste Kandidaten noch gaanz sanft an - zum Leidwesen ihrer Kollegen Dieter Falk (l.) und Detlef D! Soost (r.). Um 23.30 Uhr folgen die Highlights der Castings.','Castingshow','Low Quality',1,1,0,0,5,10,'Default',6,15,'ProSieben','108703203','',0,1,1,0,0,0,0,5,'20:15:00',732948,0,0,29,1,'Default',0,'0000-00-00 00:00:00','2006-10-26 20:09:02','2006-10-28 02:35:31'),(365,4,1024,'22:10:00','2006-06-27','23:10:00','2006-06-27','The L Word - Wenn Frauen Frauen lieben','','Dramaserie - LÌgen, LÌgen, LÌgen - Deutschland-Premiere * Bette und Tina (Jennifer Beals, l., und Laurel Holloman, r.) strahlen nicht ohne Grund: Sie erwarten ein Baby. Tim fÌrchtet, dass ihn seine Freundin Jenny mit ihrem ehemaligen Professor Nick betrÌgt. Aber die treibt es lieber mit Lesbe Miriam auf einer Toilette... \"LÌgen, LÌgen, LÌgen\".','Dramaserie','Default',0,1,0,0,5,5,'Default',6,15,'ProSieben','125536766','',0,0,0,0,0,0,0,3,'22:10:00',732854,0,0,0,1,'Default',0,'0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00'),(362,10,1024,'22:15:00','2006-05-30','23:15:00','2006-05-30','The L Word – Wenn Frauen Frauen lieben','','Dramaserie - Frauen, die Frauen lieben - 12;Deutschland-Premiere;Serienstart Staffel I / 14 Episoden * (USA 2004). WÀhrend andere US-Serien allerhöchstens mit einer Quoten-Lesbe aufwarten, dreht sich hier alles um eine Gruppe homosexueller Frauen. Im Mittelpunkt steht das langjÀhrige Paar Bette (Jennifer Beals, vorn, M., „Flashdance“) und Tina (Laurel Hollman, hinten, 3. v. l.), das sich ein Kind wÌnscht. MÀnner spielen dagegen kaum eine Rolle. Sie dienen, wie im Auftakt dieser Folge, höchstens als SamenspenderÂ  Ein durchgestyltes, fÌr US-VerhÀltnisse freizÌgiges Geschlechterdrama, ohne den Witz von „Sex and the City“.','Dramaserie','Default',0,1,0,0,3,7,'Default',6,15,'ProSieben','125554942','',0,0,0,0,0,0,0,3,'22:15:00',732826,0,0,0,1,'Default',0,'0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00'),(404,8,1024,'17:05:00','2006-11-01','18:00:00','2006-11-01','Michael Mittermeier: Paranoid','','','Satire','Default',0,1,0,0,10,10,'Default',6,15,'ProSieben','184871108','',0,0,0,0,0,0,0,2,'20:15:00',732965,0,0,0,1,'Default',0,'0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00'),(406,1,1001,'16:00:00','2006-10-31','16:30:00','2006-10-31','Test  low','2006-10-31 15:15:00 (30 mins)','Manually scheduled','Manual recording','Default',0,1,0,0,0,0,'Default',6,15,'Das Erste','','',5,1,0,0,0,0,0,2,'16:10:00',732980,0,0,29,1,'Default',0,'0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00'),(407,1,1001,'15:10:00','2006-10-31','15:40:00','2006-10-31','Test High','2006-10-31 15:10:00 (30 mins)','Manually scheduled','Manual recording','Default',0,1,0,0,0,0,'Default',6,15,'Das Erste','','',5,1,0,0,0,0,0,2,'15:10:00',732980,0,0,27,1,'Default',0,'0000-00-00 00:00:00','2006-10-31 15:09:02','0000-00-00 00:00:00'),(408,1,1001,'15:45:00','2006-10-31','16:15:00','2006-10-31','test Medium','2006-10-31 15:45:00 (30 mins)','Manually scheduled','Manual recording','Default',0,1,0,0,0,0,'Default',6,15,'Das Erste','','',5,0,0,0,0,0,0,2,'15:10:00',732980,0,0,28,1,'Default',0,'0000-00-00 00:00:00','2006-10-31 15:44:01','0000-00-00 00:00:00'),(394,3,1037,'17:30:00','2006-09-30','18:00:00','2006-09-30','Voxtours','','Neuseeland','Reisemagazin','Low Quality',-1,1,10,0,0,0,'Default',6,15,'VOX','117139779','',0,1,0,0,0,0,0,0,'17:30:00',0,0,0,29,1,'Default',0,'0000-00-00 00:00:00','2006-10-29 03:59:01','2006-10-31 14:31:42'),(409,1,1001,'16:20:00','2006-10-31','16:50:00','2006-10-31','1 (Das Erste)','Test High','Manually scheduled','Manual recording','Default',0,1,0,0,0,0,'Default',6,15,'Das Erste','','',5,0,0,0,0,0,0,2,'16:10:00',732980,0,0,27,1,'Default',0,'0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00'),(410,8,1001,'16:20:00','2006-10-31','16:50:00','2006-10-31','1 (Das Erste)','Tue Oct 31 16:20:00 2006','','Unknown','Default',0,1,0,0,0,0,'Default',6,15,'Das Erste','','',0,0,0,0,0,0,0,2,'16:10:00',732980,0,0,27,1,'Default',0,'0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00'),(411,1,1001,'16:20:00','2006-10-31','16:50:00','2006-10-31','1 (Das Erste)','Tue Oct 31 16:20:00 2006','','Unknown','Default',0,1,0,0,0,0,'Default',6,15,'Das Erste','','',0,1,0,0,0,0,0,3,'16:20:00',732980,0,0,29,1,'Default',0,'0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00'),(412,7,1001,'16:20:00','2006-10-31','16:50:00','2006-10-31','1 (Das Erste)','Tue Oct 31 16:20:00 2006','','Unknown','Default',0,1,0,0,0,0,'Default',6,15,'Das Erste','','',0,1,0,0,0,0,0,3,'16:20:00',732980,0,0,29,1,'Default',0,'0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00'),(413,1,1001,'16:45:00','2006-10-31','17:15:00','2006-10-31','Test Low','2006-10-31 16:45:00 (30 mins)','Manually scheduled','Manual recording','Default',0,1,0,0,0,0,'Default',6,15,'Das Erste','','',5,1,0,0,0,0,0,2,'16:10:00',732980,0,0,29,1,'Default',0,'0000-00-00 00:00:00','2006-10-31 16:44:01','0000-00-00 00:00:00'),(414,1,1001,'17:30:00','2006-10-31','18:00:00','2006-10-31','Test Autodetect','2006-10-31 17:30:00 (30 mins)','Manually scheduled','Manual recording','Default',0,1,0,0,0,0,'Default',6,15,'Das Erste','','',5,1,0,0,0,0,0,2,'17:10:00',732980,0,0,0,1,'Default',0,'0000-00-00 00:00:00','2006-10-31 17:29:01','0000-00-00 00:00:00'),(415,1,1001,'18:20:00','2006-10-31','18:50:00','2006-10-31','adthjest (Manual Record)','','','','Default',0,1,0,0,0,0,'Default',6,15,'Das Erste','','',5,1,0,0,0,0,0,3,'18:20:00',732980,0,0,28,1,'Default',0,'0000-00-00 00:00:00','0000-00-00 00:00:00','0000-00-00 00:00:00');
153/*!40000 ALTER TABLE `record_tmp` ENABLE KEYS */;
154UNLOCK TABLES;
155/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
156
157/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
158/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
159/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
160/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
161/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
162/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
163/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
164
165-- Dump completed on 2009-02-23 18:30:33