Ticket #1035: malta_channel_dump

File malta_channel_dump, 13.6 KB (added by btsglw@…, 13 years ago)

Channel dump as requested by Daniel

Line 
1-- MySQL dump 10.10
2--
3-- Host: myth    Database: mythconverg
4-- ------------------------------------------------------
5-- Server version       5.0.22
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 `channel`
20--
21
22DROP TABLE IF EXISTS `channel`;
23CREATE TABLE `channel` (
24  `chanid` int(10) unsigned NOT NULL default '0',
25  `channum` varchar(10) NOT NULL default '',
26  `freqid` varchar(10) default NULL,
27  `sourceid` int(10) unsigned default NULL,
28  `callsign` varchar(20) NOT NULL default '',
29  `name` varchar(64) NOT NULL default '',
30  `icon` varchar(255) NOT NULL default 'none',
31  `finetune` int(11) default NULL,
32  `videofilters` varchar(255) NOT NULL default '',
33  `xmltvid` varchar(64) NOT NULL default '',
34  `recpriority` int(10) NOT NULL default '0',
35  `contrast` int(11) default '32768',
36  `brightness` int(11) default '32768',
37  `colour` int(11) default '32768',
38  `hue` int(11) default '32768',
39  `tvformat` varchar(10) NOT NULL default 'Default',
40  `commfree` tinyint(4) NOT NULL default '0',
41  `visible` tinyint(1) NOT NULL default '1',
42  `outputfilters` varchar(255) NOT NULL default '',
43  `useonairguide` tinyint(1) default '0',
44  `mplexid` smallint(6) default NULL,
45  `serviceid` mediumint(8) unsigned default NULL,
46  `atscsrcid` int(11) default NULL,
47  `tmoffset` int(11) NOT NULL default '0',
48  `atsc_major_chan` int(10) unsigned NOT NULL default '0',
49  `atsc_minor_chan` int(10) unsigned NOT NULL default '0',
50  PRIMARY KEY  (`chanid`),
51  KEY `channel_src` (`channum`,`sourceid`)
52) ENGINE=MyISAM DEFAULT CHARSET=latin1;
53
54--
55-- Dumping data for table `channel`
56--
57
58
59/*!40000 ALTER TABLE `channel` DISABLE KEYS */;
60LOCK TABLES `channel` WRITE;
61INSERT INTO `channel` VALUES (4906,'906',NULL,4,'BLOOM','Bloomberg','',NULL,'','',0,32768,32768,32768,32768,'Default',0,1,'',1,48,906,NULL,0,0,0),(4901,'901',NULL,4,'BBCW','BBC World','',NULL,'','',0,32768,32768,32768,32768,'Default',0,1,'',1,48,901,NULL,0,0,0),(4506,'506',NULL,4,'BioCH','Biography Channel','',NULL,'','',0,32768,32768,32768,32768,'Default',0,1,'',1,48,506,NULL,0,0,0),(3005,'260','260',3,'Hall','Hallmark Channel','',NULL,'','www.hallmarkchannel.com',0,32768,32768,32768,32768,'Default',0,1,'',0,NULL,0,NULL,0,0,0),(3004,'802','202',3,'EuroS2','Eurosport 2','',NULL,'','www.eurosport2.com',0,32768,32768,32768,32768,'Default',0,1,'',0,NULL,0,NULL,0,0,0),(4306,'306',NULL,4,'Paramount Comedy','Paramount Comedy','',NULL,'','',0,32768,32768,32768,32768,'',0,1,'',1,50,306,NULL,0,0,0),(4508,'508',NULL,4,'Adventure 1','Adventure 1','',NULL,'','',0,32768,32768,32768,32768,'',0,1,'',1,50,508,NULL,0,0,0),(4307,'307',NULL,4,'Wine TV','Wine TV','',NULL,'','',0,32768,32768,32768,32768,'',0,1,'',1,50,307,NULL,0,0,0),(4305,'305',NULL,4,'Trouble','Trouble','',NULL,'','',0,32768,32768,32768,32768,'',0,1,'',1,50,305,NULL,0,0,0),(3006,'',NULL,3,'RAINE','Rai News 24','',NULL,'','www.rainews24.rai.it',0,32768,32768,32768,32768,'Default',0,1,'',0,NULL,0,NULL,0,0,0),(4808,'808',NULL,4,'ESPN Classic','ESPN Classic','',NULL,'','',0,32768,32768,32768,32768,'',0,1,'',1,50,808,NULL,0,0,0),(4401,'401',NULL,4,'Boomerang','Boomerang','',NULL,'','',0,32768,32768,32768,32768,'',0,1,'',1,50,401,NULL,0,0,0),(4807,'807',NULL,4,'Motors','Motors TV','',NULL,'','',0,32768,32768,32768,32768,'Default',0,1,'',1,47,807,NULL,0,0,0),(4207,'207',NULL,4,'La7','La 7','',NULL,'','',0,32768,32768,32768,32768,'Default',0,1,'',1,47,207,NULL,0,0,0),(4104,'104',NULL,4,'ED22','ED22','',NULL,'','',0,32768,32768,32768,32768,'Default',0,1,'',1,43,104,NULL,0,0,0),(4201,'201',NULL,4,'Rai1','Rai Uno','',NULL,'','',0,32768,32768,32768,32768,'Default',0,1,'',1,43,201,NULL,0,0,0),(4202,'202',NULL,4,'Rai2','Rai Due','',NULL,'','',0,32768,32768,32768,32768,'Default',0,1,'',1,43,202,NULL,0,0,0),(4302,'302',NULL,4,'LivTV','LIVINGtv','',NULL,'','',0,32768,32768,32768,32768,'Default',0,1,'',1,44,302,NULL,0,0,0),(4304,'304',NULL,4,'E!','E! Entertainment','',NULL,'','',0,32768,32768,32768,32768,'Default',0,1,'',1,44,304,NULL,0,0,0),(4904,'904',NULL,4,'CNBC','CNBC Europe','',NULL,'','',0,32768,32768,32768,32768,'Default',0,1,'',1,44,904,NULL,0,0,0),(4402,'402',NULL,4,'TCN','TCN','',NULL,'','',0,32768,32768,32768,32768,'Default',0,1,'',1,44,402,NULL,0,0,0),(4801,'801',NULL,4,'EuroS','Eurosport','',NULL,'','',0,32768,32768,32768,32768,'Default',0,1,'',1,44,801,NULL,0,0,0),(4404,'404',NULL,4,'TOON','Toonami','',NULL,'','',0,32768,32768,32768,32768,'Default',0,1,'',1,45,404,NULL,0,0,0),(4100,'100',NULL,4,'M+','M+','',NULL,'','',0,32768,32768,32768,32768,'Default',0,1,'',1,45,100,NULL,0,0,0),(4602,'602',NULL,4,'VH1','VH1','',NULL,'','',0,32768,32768,32768,32768,'Default',0,1,'',1,45,602,NULL,0,0,0),(4301,'301',NULL,4,'BBCP','BBC Prime','',NULL,'','',0,32768,32768,32768,32768,'Default',0,1,'',1,45,301,NULL,0,0,0),(4903,'903',NULL,4,'CNN','CNN','',NULL,'','',0,32768,32768,32768,32768,'Default',0,1,'',1,45,903,NULL,0,0,0),(4403,'403',NULL,4,'Nick','Nickelodeon','',NULL,'','',0,32768,32768,32768,32768,'Default',0,1,'',1,45,403,NULL,0,0,0),(4601,'601',NULL,4,'MTV 1','MTV 1','',NULL,'','',0,32768,32768,32768,32768,'Default',0,1,'',1,45,601,NULL,0,0,0),(4204,'204',NULL,4,'Ital1','Italia 1','',NULL,'','',0,32768,32768,32768,32768,'Default',0,1,'',1,46,204,NULL,0,0,0),(4303,'303',NULL,4,'World Fashion TV','World Fashion TV','',NULL,'','',0,32768,32768,32768,32768,'Default',0,1,'',1,46,303,NULL,0,0,0),(4205,'205',NULL,4,'Can5','Canale 5','',NULL,'','',0,32768,32768,32768,32768,'Default',0,1,'',1,46,205,NULL,0,0,0),(4902,'902',NULL,4,'EuroN','EuroNews','',NULL,'','',0,32768,32768,32768,32768,'Default',0,1,'',1,46,902,NULL,0,0,0),(4206,'206',NULL,4,'Rete4','Rete 4','',NULL,'','',0,32768,32768,32768,32768,'Default',0,1,'',1,46,206,NULL,0,0,0),(4802,'802',NULL,4,'EuroS2','Eurosport 2','',NULL,'','',0,32768,32768,32768,32768,'Default',0,1,'',1,46,802,NULL,0,0,0),(4504,'504',NULL,4,'DCiv','Discovery Civilisation','',NULL,'','',0,32768,32768,32768,32768,'Default',0,1,'',1,49,504,NULL,0,0,0),(4701,'701',NULL,4,'TCMDVB','TCM','',NULL,'','',0,32768,32768,32768,32768,'Default',0,1,'',1,49,701,NULL,0,0,0),(4502,'502',NULL,4,'DSci','Discovery Science','',NULL,'','',0,32768,32768,32768,32768,'Default',0,1,'',1,49,502,NULL,0,0,0),(4501,'501',NULL,4,'DISC','Discovery','',NULL,'','',0,32768,32768,32768,32768,'Default',0,1,'',1,49,501,NULL,0,0,0),(4503,'503',NULL,4,'Trav','Travel & Living','',NULL,'','',0,32768,32768,32768,32768,'Default',0,1,'',1,49,503,NULL,0,0,0),(4505,'505',NULL,4,'NGeo','National Geographic','',NULL,'','',0,32768,32768,32768,32768,'Default',0,1,'',1,49,505,NULL,0,0,0),(4208,'208',NULL,4,'Sat 2000','Sat 2000','',NULL,'','',0,32768,32768,32768,32768,'Default',0,1,'',1,47,208,NULL,0,0,0),(4806,'806',NULL,4,'Sailing Channel','Sailing Channel','',NULL,'','',0,32768,32768,32768,32768,'Default',0,1,'',1,47,806,NULL,0,0,0),(2032,'205','154',3,'Can5','Canale 5','none',0,'','www.canale5.com',0,32768,32768,32768,32768,'Default',0,1,'',0,0,0,0,0,0,0),(2033,'801','201',3,'EuroS','Eurosport','none',0,'','www.eurosport.com',0,32768,32768,32768,32768,'Default',0,1,'',0,0,0,0,0,0,0),(2034,'207','156',3,'La7','La 7','none',0,'','www.la7.it',0,32768,32768,32768,32768,'Default',0,1,'',0,0,0,0,0,0,0),(2035,'201','150',3,'RAI1','Rai Uno','none',0,'','www.raiuno.rai.it',0,32768,32768,32768,32768,'Default',0,1,'',0,0,0,0,0,0,0),(2036,'202','151',3,'Rai2','Rai Due','none',0,'','www.raidue.rai.it',0,32768,32768,32768,32768,'Default',0,1,'',0,0,0,0,0,0,0),(2037,'203','152',3,'Rai3','Rai Tre','none',0,'','www.raitre.rai.it',0,32768,32768,32768,32768,'Default',0,1,'',0,0,0,0,0,0,0),(2038,'206','153',3,'Rete4','Rete 4','none',0,'','www.rete4.com',0,32768,32768,32768,32768,'Default',0,1,'',0,0,0,0,0,0,0),(2039,'501','450',3,'DISC','Discovery','none',0,'','020.port.ro',0,32768,32768,32768,32768,'Default',0,1,'',0,0,0,0,0,0,0),(2040,'504','451',3,'DCiv','Discovery Civilisations','none',0,'','043.port.ro',0,32768,32768,32768,32768,'Default',0,1,'',0,0,0,0,0,0,0),(2041,'502','452',3,'DSci','Discovery Science','none',0,'','044.port.ro',0,32768,32768,32768,32768,'Default',0,1,'',0,0,0,0,0,0,0),(2042,'503','453',3,'Trav','Travel & Living','none',0,'','045.port.ro',0,32768,32768,32768,32768,'Default',0,1,'',0,0,0,0,0,0,0),(2043,'301','254',3,'BBCP','BBC Prime','none',0,'','prime.bbc.com',0,32768,32768,32768,32768,'Default',0,1,'',0,0,0,0,0,0,0),(2044,'302','262',3,'LivTV','LIVINGtv','none',0,'','livingtv.co.uk',0,32768,32768,32768,32768,'Default',0,1,'',0,0,0,0,0,0,0),(2045,'401','505',3,'Boom','Boomerang','none',0,'','boomerang.cartoonnetwork.com',0,32768,32768,32768,32768,'Default',0,1,'',0,0,0,0,0,0,0),(2046,'305','507',3,'Trou','Trouble','none',0,'','trouble.co.uk',0,32768,32768,32768,32768,'Default',0,1,'',0,0,0,0,0,0,0),(2047,'256','256',3,'TCM','TCM','none',0,'','tcm.turner.com',1,32768,32768,32768,32768,'Default',0,1,'',0,0,0,0,0,0,0),(2048,'904','405',3,'CNBC','CNBC','none',0,'','europe.cnbc.com',0,32768,32768,32768,32768,'Default',0,1,'',0,0,0,0,0,0,0),(2049,'903','402',3,'CNN','CNN','none',0,'','europe.cnn.com',0,32768,32768,32768,32768,'Default',0,1,'',0,0,0,0,0,0,0),(2050,'402','502',3,'TCN','TCN','none',0,'','uk.cartoonnetwork.com',0,32768,32768,32768,32768,'Default',0,1,'',0,0,0,0,0,0,0),(2051,'902','401',3,'EuroN','Euronews','none',0,'','euronews.com',0,32768,32768,32768,32768,'Default',0,1,'',0,0,0,0,0,0,0),(2052,'403','501',3,'Nick','Nickelodeon','none',0,'','nickelodeon.co.uk',0,32768,32768,32768,32768,'Default',0,1,'',0,0,0,0,0,0,0),(2053,'261','261',3,'PCom','Paramount Comedy','none',0,'','paramountcomedy.com',0,32768,32768,32768,32768,'Default',0,1,'',0,0,0,0,0,0,0),(2054,'905','403',3,'SkyN','Sky News','none',0,'','sky-news.sky.com',0,32768,32768,32768,32768,'Default',0,1,'',0,0,0,0,0,0,0),(2055,'404','504',3,'TOON','Toonami','none',0,'','Toonami.cartoonnetwork.com',0,32768,32768,32768,32768,'Default',0,1,'',0,0,0,0,0,0,0),(2056,'807','204',3,'Motors','Motors TV','none',0,'','motors.tv',0,32768,32768,32768,32768,'Default',0,1,'',0,0,0,0,0,0,0),(2057,'506','458',3,'BioCH','Biography','none',0,'','biography-channel.biography.com',0,32768,32768,32768,32768,'Default',0,1,'',0,0,0,0,0,0,0),(2058,'507','456',3,'Hist','History Channel','none',0,'','thehistorychannel.co.uk',0,32768,32768,32768,32768,'Default',0,1,'',0,0,0,0,0,0,0),(2059,'901','400',3,'BBCW','BBC World','none',0,'','world-tv.bbc.com',0,32768,32768,32768,32768,'Default',0,1,'',0,0,0,0,0,0,0),(2060,'906','404',3,'BLOOM','Bloomberg','none',0,'','bloomberg.com',0,32768,32768,32768,32768,'Default',0,1,'',0,0,0,0,0,0,0),(2061,'505','454',3,'NGeo','National Geographic','none',0,'','024.port.ro',0,32768,32768,32768,32768,'Default',0,1,'',0,0,0,0,0,0,0),(2062,'207','207',3,'NASN','North American Sports Channel','none',0,'','',0,32768,32768,32768,32768,'Default',0,1,'',0,0,0,0,0,0,0),(2063,'257','257',3,'TCM2','TCM 2','none',0,'','',0,32768,32768,32768,32768,'Default',0,1,'',0,0,0,0,0,0,0),(2064,'602','554',3,'VH1','VH1','none',0,'','',0,32768,32768,32768,32768,'Default',0,1,'',0,0,0,0,0,0,0),(2065,'550','550',3,'MTV','MTV','none',0,'','',0,32768,32768,32768,32768,'Default',0,1,'',0,0,0,0,0,0,0),(2066,'552','552',3,'MTVH','MTV Hits','none',0,'','',0,32768,32768,32768,32768,'Default',0,1,'',0,0,0,0,0,0,0),(2067,'553','553',3,'MTVB','MTV Base','none',0,'','',0,32768,32768,32768,32768,'Default',0,1,'',0,0,0,0,0,0,0),(2069,'300','300',3,'TV5','TV 5','none',0,'','',0,32768,32768,32768,32768,'Default',0,1,'',0,0,0,0,0,0,0),(2071,'303','303',3,'RTL2','RTL 2','none',0,'','',0,32768,32768,32768,32768,'Default',0,1,'',0,0,0,0,0,0,0),(3003,'808','203',3,'ESPN','ESPN Classic','',NULL,'','www.espnclassicsport.com',0,32768,32768,32768,32768,'Default',0,1,'',0,NULL,0,NULL,0,0,0),(4400,'400',NULL,4,'Baby TV','Baby TV','',NULL,'','',0,32768,32768,32768,32768,'',0,1,'',1,50,400,NULL,0,0,0),(4103,'103',NULL,4,'One Tv','One Tv','',NULL,'','',0,32768,32768,32768,32768,'Default',0,1,'',1,43,103,NULL,0,0,0),(3000,'204','155',3,'Ital1','Italia 1','none',0,'','www.italia1.com',0,32768,32768,32768,32768,'Default',0,1,'',0,NULL,0,NULL,0,0,0),(2072,'508','459',3,'ANIP','Animal Planet','none',0,'','021.port.ro',0,32768,32768,32768,32768,'Default',0,1,'',0,0,0,0,0,0,0),(4905,'905',NULL,4,'SkyN','Sky News','',NULL,'','',0,32768,32768,32768,32768,'Default',0,1,'',1,48,905,NULL,0,0,0),(4203,'203',NULL,4,'Rai3','Rai Tre','',NULL,'','',0,32768,32768,32768,32768,'Default',0,1,'',1,43,203,NULL,0,0,0),(4603,'603',NULL,4,'Trace TV','Trace TV','',NULL,'','',0,32768,32768,32768,32768,'Default',0,1,'',1,48,603,NULL,0,0,0),(4507,'507',NULL,4,'Hist','History Channel','',NULL,'','',0,32768,32768,32768,32768,'Default',0,1,'',1,48,507,NULL,0,0,0),(4101,'101',NULL,4,'PBS','PBS','',NULL,'','',0,32768,32768,32768,32768,'Default',0,1,'',1,43,101,NULL,0,0,0),(4102,'102',NULL,4,'Net','Net','',NULL,'','',0,32768,32768,32768,32768,'Default',0,1,'',1,43,102,NULL,0,0,0);
62UNLOCK TABLES;
63/*!40000 ALTER TABLE `channel` ENABLE KEYS */;
64/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
65
66/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
67/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
68/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
69/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
70/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
71/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
72/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
73