[linux-dvb] DVB file formats

[Marcus Metzler]

Hi, 
I had a look at the wiki and just to be complete here is the structure
of the mysql database for mythtv:

You can have a look at the database with 
mysqldump -c -a -p mythconverg

I just list the tables that may be relevant for DVB:

CREATE TABLE `capturecard` (
  `cardid` int(10) unsigned NOT NULL auto_increment,
  `videodevice` varchar(128) default NULL,
  `audiodevice` varchar(128) default NULL,
  `vbidevice` varchar(128) default NULL,
  `cardtype` varchar(32) default 'V4L',
  `defaultinput` varchar(32) default 'Television',
  `audioratelimit` int(11) default NULL,
  `hostname` varchar(255) default NULL,
  `dvb_swfilter` int(11) default '0',
  `dvb_recordts` int(11) default '0',
  `dvb_sat_type` int(11) NOT NULL default '0',
  `dvb_wait_for_seqstart` int(11) NOT NULL default '1',
  `dvb_dmx_buf_size` int(11) NOT NULL default '8192',
  `dvb_pkt_buf_size` int(11) NOT NULL default '8192',
  `skipbtaudio` tinyint(1) default '0',
  `dvb_on_demand` tinyint(4) NOT NULL default '0',
  `dvb_diseqc_type` smallint(6) default NULL,
  `firewire_port` int(10) unsigned NOT NULL default '0',
  `firewire_node` int(10) unsigned NOT NULL default '2',
  `firewire_speed` int(10) unsigned NOT NULL default '0',
  `firewire_model` varchar(32) default NULL,
  `firewire_connection` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`cardid`)
) TYPE=MyISAM;


CREATE TABLE `cardinput` (
  `cardinputid` int(10) unsigned NOT NULL auto_increment,
  `cardid` int(10) unsigned NOT NULL default '0',
  `sourceid` int(10) unsigned NOT NULL default '0',
  `inputname` varchar(32) NOT NULL default '',
  `externalcommand` varchar(128) default NULL,
  `preference` int(11) NOT NULL default '0',
  `shareable` char(1) default 'N',
  `tunechan` varchar(5) NOT NULL default '',
  `startchan` varchar(5) NOT NULL default '',
  `freetoaironly` tinyint(1) default '1',
  `diseqc_port` smallint(6) default NULL,
  `diseqc_pos` float default NULL,
  `lnb_lof_switch` int(11) default '11700000',
  `lnb_lof_hi` int(11) default '10600000',
  `lnb_lof_lo` int(11) default '9750000',
  PRIMARY KEY  (`cardinputid`)
) TYPE=MyISAM;

CREATE TABLE `channel` (
  `chanid` int(10) unsigned NOT NULL default '0',
  `channum` varchar(5) NOT NULL default '',
  `freqid` varchar(10) default NULL,
  `sourceid` int(10) unsigned default NULL,
  `callsign` varchar(20) NOT NULL default '',
  `name` varchar(64) NOT NULL default '',
  `icon` varchar(255) NOT NULL default 'none',
  `finetune` int(11) default NULL,
  `videofilters` varchar(255) NOT NULL default '',
  `xmltvid` varchar(64) NOT NULL default '',
  `recpriority` int(10) NOT NULL default '0',
  `contrast` int(11) default '32768',
  `brightness` int(11) default '32768',
  `colour` int(11) default '32768',
  `hue` int(11) default '32768',
  `tvformat` varchar(10) NOT NULL default 'Default',
  `commfree` tinyint(4) NOT NULL default '0',
  `visible` tinyint(1) NOT NULL default '1',
  `outputfilters` varchar(255) NOT NULL default '',
  `useonairguide` tinyint(1) default '0',
  `mplexid` smallint(6) default NULL,
  `serviceid` smallint(6) default NULL,
  `atscsrcid` int(11) default NULL,
  PRIMARY KEY  (`chanid`),
  KEY `channel_src` (`channum`,`sourceid`)
) TYPE=MyISAM;

CREATE TABLE `dtv_multiplex` (
  `mplexid` smallint(6) NOT NULL auto_increment,
  `sourceid` smallint(6) default NULL,
  `transportid` int(11) default NULL,
  `networkid` int(11) default NULL,
  `frequency` int(11) default NULL,
  `inversion` char(1) default 'a',
  `symbolrate` int(11) default NULL,
  `fec` varchar(10) default 'auto',
  `polarity` char(1) default NULL,
  `modulation` varchar(10) default 'auto',
  `bandwidth` char(1) default 'a',
  `lp_code_rate` varchar(10) default 'auto',
  `transmission_mode` char(1) default 'a',
  `guard_interval` varchar(10) default 'auto',
  `visible` smallint(1) NOT NULL default '0',
  `constellation` varchar(10) default 'auto',
  `hierarchy` varchar(10) default 'auto',
  `hp_code_rate` varchar(10) default 'auto',
  `sistandard` varchar(10) default 'dvb',
  `serviceversion` smallint(6) default '33',
  `updatetimestamp` timestamp(14) NOT NULL,
  PRIMARY KEY  (`mplexid`)
) TYPE=MyISAM;


CREATE TABLE `dtv_privatetypes` (
  `sitype` varchar(4) NOT NULL default '',
  `networkid` int(11) NOT NULL default '0',
  `private_type` varchar(20) NOT NULL default '',
  `private_value` varchar(100) NOT NULL default ''
) TYPE=MyISAM;


CREATE TABLE `dvb_channel` (
  `chanid` smallint(6) NOT NULL default '0',
  `serviceid` smallint(6) default NULL,
  `networkid` smallint(6) default NULL,
  `providerid` smallint(6) default NULL,
  `transportid` smallint(6) default NULL,
  `frequency` int(11) default NULL,
  `inversion` char(1) default NULL,
  `symbolrate` int(11) default NULL,
  `fec` varchar(10) default NULL,
  `polarity` char(1) default NULL,
  `satid` smallint(6) default NULL,
  `modulation` varchar(10) default NULL,
  `bandwidth` char(1) default NULL,
  `lp_code_rate` varchar(10) default NULL,
  `transmission_mode` char(1) default NULL,
  `guard_interval` varchar(10) default NULL,
  `hierarchy` char(1) default NULL,
  `pmtcache` blob,
  PRIMARY KEY  (`chanid`)
) TYPE=MyISAM;

CREATE TABLE `dvb_pids` (
  `chanid` smallint(6) NOT NULL default '0',
  `pid` smallint(6) NOT NULL default '0',
  `type` char(1) NOT NULL default 'o',
  `lang` char(3) NOT NULL default '',
  PRIMARY KEY  (`chanid`,`pid`)
) TYPE=MyISAM;


CREATE TABLE `dvb_sat` (
  `satid` smallint(6) NOT NULL auto_increment,
  `cardid` int(11) default NULL,
  `pos` float default NULL,
  `name` varchar(128) default NULL,
  `diseqc_type` smallint(6) default '0',
  `diseqc_port` smallint(6) default '0',
  `diseqc_pos` smallint(6) default '0',
  `lnb_lof_switch` int(11) default '11700000',
  `lnb_lof_hi` int(11) default '10600000',
  `lnb_lof_lo` int(11) default '9750000',
  PRIMARY KEY  (`satid`)
) TYPE=MyISAM;