Miscellany

CREATE TABLE IF NOT EXISTS `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 NOT NULL default CURRENT_TIMESTAMP  on update CURRENT_TIMESTAMP,
PRIMARY KEY  (`mplexid`));