-- phpMyAdmin SQL Dump
-- version 3.3.7deb7
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Jan 06, 2013 at 11:49 PM
-- Server version: 5.1.63
-- PHP Version: 5.3.3-7+squeeze13

SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";

--
-- Database: `mythconverg`
--

-- --------------------------------------------------------

--
-- Table structure for table `dtv_multiplex`
--

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',
  `mod_sys` VARCHAR(10) DEFAULT NULL,
  `rolloff` VARCHAR(4) DEFAULT NULL,
  `sistandard` VARCHAR(10) DEFAULT 'dvb',
  `serviceversion` SMALLINT(6) DEFAULT '33',
  `updatetimestamp` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  `default_authority` VARCHAR(32) NOT NULL DEFAULT '',
  PRIMARY KEY (`mplexid`)
) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=336 ;

--
-- Dumping data for table `dtv_multiplex`
--

INSERT INTO `dtv_multiplex` (`mplexid`, `sourceid`, `transportid`, `networkid`, `frequency`, `inversion`, `symbolrate`, `fec`, `polarity`, `modulation`, `bandwidth`, `lp_code_rate`, `transmission_mode`, `guard_interval`, `visible`, `constellation`, `hierarchy`, `hp_code_rate`, `mod_sys`, `rolloff`, `sistandard`, `serviceversion`, `updatetimestamp`, `default_authority`) VALUES
(335, 1, 1115, 1, 12662250, 'a', 22000000, '5/6', 'h', 'qpsk', 'a', 'auto', 'a', 'auto', 0, 'qpsk', 'a', 'auto', 'DVB-S', '0.35', 'dvb', 33, '2013-01-06 23:15:31', ''),
(334, 1, 17, 133, 11758500, 'a', 27500000, '3/4', 'h', 'qpsk', 'a', 'auto', 'a', 'auto', 0, 'qpsk', 'a', 'auto', 'DVB-S', '0.35', 'dvb', 33, '2013-01-06 21:25:34', ''),
(332, 1, 1101, 1, 11836500, 'a', 27500000, '3/4', 'h', 'qpsk', 'a', 'auto', 'a', 'auto', 0, 'qpsk', 'a', 'auto', 'DVB-S', '0.35', 'dvb', 33, '2013-01-06 21:25:34', ''),
(331, 1, 1074, 1, 11895000, 'a', 27500000, '3/4', 'v', 'qpsk', 'a', 'auto', 'a', 'auto', 0, 'qpsk', 'a', 'auto', 'DVB-S', '0.35', 'dvb', 33, '2013-01-06 21:25:34', ''),
(330, 1, 1070, 1, 11817000, 'a', 27500000, '3/4', 'v', 'qpsk', 'a', 'auto', 'a', 'auto', 0, 'qpsk', 'a', 'auto', 'DVB-S', '0.35', 'dvb', 33, '2013-01-06 21:25:34', ''),
(329, 1, 1068, 1, 11778000, 'a', 27500000, '3/4', 'v', 'qpsk', 'a', 'auto', 'a', 'auto', 0, 'qpsk', 'a', 'auto', 'DVB-S', '0.35', 'dvb', 33, '2013-01-06 21:25:34', ''),
(328, 1, 1059, 1, 10861750, 'a', 22000000, '7/8', 'h', 'qpsk', 'a', 'auto', 'a', 'auto', 0, 'qpsk', 'a', 'auto', 'DVB-S', '0.35', 'dvb', 33, '2013-01-06 21:25:34', ''),
(327, 1, 1058, 1, 10847000, 'a', 22000000, '5/6', 'v', 'qpsk', 'a', 'auto', 'a', 'auto', 0, 'qpsk', 'a', 'auto', 'DVB-S', '0.35', 'dvb', 33, '2013-01-06 21:25:34', ''),
(326, 1, 1055, 1, 10802750, 'a', 22000000, '3/4', 'h', '8psk', 'a', 'auto', 'a', 'auto', 0, '8psk', 'a', 'auto', 'DVB-S2', '0.35', 'dvb', 33, '2013-01-06 21:25:34', ''),
(325, 1, 1054, 1, 10788000, 'a', 22000000, '5/6', 'v', 'qpsk', 'a', 'auto', 'a', 'auto', 0, 'qpsk', 'a', 'auto', 'DVB-S', '0.35', 'dvb', 33, '2013-01-06 21:25:34', ''),
(324, 1, 1053, 1, 10773250, 'a', 22000000, '3/4', 'h', '8psk', 'a', 'auto', 'a', 'auto', 0, '8psk', 'a', 'auto', 'DVB-S2', '0.25', 'dvb', 33, '2013-01-06 21:25:34', ''),
(323, 1, 1052, 1, 10758500, 'a', 22000000, '5/6', 'v', 'qpsk', 'a', 'auto', 'a', 'auto', 0, 'qpsk', 'a', 'auto', 'DVB-S', '0.35', 'dvb', 33, '2013-01-06 21:25:34', ''),
(322, 1, 1051, 1, 10743750, 'a', 22000000, '5/6', 'h', 'qpsk', 'a', 'auto', 'a', 'auto', 0, 'qpsk', 'a', 'auto', 'DVB-S', '0.35', 'dvb', 33, '2013-01-06 21:25:34', ''),
(321, 1, 1048, 1, 11185500, 'a', 22000000, '5/6', 'v', 'qpsk', 'a', 'auto', 'a', 'auto', 0, 'qpsk', 'a', 'auto', 'DVB-S', '0.35', 'dvb', 33, '2013-01-06 21:25:34', ''),
(320, 1, 1042, 1, 11097000, 'a', 22000000, '5/6', 'v', 'qpsk', 'a', 'auto', 'a', 'auto', 0, 'qpsk', 'a', 'auto', 'DVB-S', '0.35', 'dvb', 33, '2013-01-06 21:25:34', ''),
(319, 1, 1040, 1, 11067500, 'a', 22000000, '5/6', 'v', 'qpsk', 'a', 'auto', 'a', 'auto', 0, 'qpsk', 'a', 'auto', 'DVB-S', '0.35', 'dvb', 33, '2013-01-06 21:25:34', ''),
(318, 1, 1037, 1, 11023250, 'a', 22000000, '5/6', 'h', 'qpsk', 'a', 'auto', 'a', 'auto', 0, 'qpsk', 'a', 'auto', 'DVB-S', '0.35', 'dvb', 33, '2013-01-06 21:25:34', ''),
(317, 1, 1034, 1, 10979000, 'a', 22000000, '5/6', 'v', 'qpsk', 'a', 'auto', 'a', 'auto', 0, 'qpsk', 'a', 'auto', 'DVB-S', '0.35', 'dvb', 33, '2013-01-06 21:25:34', ''),
(316, 1, 1032, 1, 11685500, 'a', 22000000, '5/6', 'v', 'qpsk', 'a', 'auto', 'a', 'auto', 0, 'qpsk', 'a', 'auto', 'DVB-S', '0.35', 'dvb', 33, '2013-01-06 21:25:34', ''),
(315, 1, 1028, 1, 11626500, 'a', 22000000, '2/3', 'v', '8psk', 'a', 'auto', 'a', 'auto', 0, '8psk', 'a', 'auto', 'DVB-S2', '0.35', 'dvb', 33, '2013-01-06 21:25:34', ''),
(314, 1, 1027, 1, 11611750, 'a', 22000000, '5/6', 'h', 'qpsk', 'a', 'auto', 'a', 'auto', 0, 'qpsk', 'a', 'auto', 'DVB-S', '0.35', 'dvb', 33, '2013-01-06 21:25:34', ''),
(313, 1, 1026, 1, 11597000, 'a', 22000000, '5/6', 'v', 'qpsk', 'a', 'auto', 'a', 'auto', 0, 'qpsk', 'a', 'auto', 'DVB-S', '0.35', 'dvb', 33, '2013-01-06 21:25:34', ''),
(312, 1, 1025, 1, 11582250, 'a', 22000000, '2/3', 'h', '8psk', 'a', 'auto', 'a', 'auto', 0, '8psk', 'a', 'auto', 'DVB-S2', '0.35', 'dvb', 33, '2013-01-06 21:25:34', ''),
(311, 1, 1024, 1, 11567500, 'a', 22000000, '5/6', 'v', 'qpsk', 'a', 'auto', 'a', 'auto', 0, 'qpsk', 'a', 'auto', 'DVB-S', '0.35', 'dvb', 33, '2013-01-06 21:25:34', ''),
(310, 1, 1022, 1, 11538000, 'a', 22000000, '5/6', 'v', 'qpsk', 'a', 'auto', 'a', 'auto', 0, 'qpsk', 'a', 'auto', 'DVB-S', '0.35', 'dvb', 33, '2013-01-06 21:25:34', ''),
(309, 1, 1021, 1, 11523250, 'a', 22000000, '5/6', 'h', 'qpsk', 'a', 'auto', 'a', 'auto', 0, 'qpsk', 'a', 'auto', 'DVB-S', '0.35', 'dvb', 33, '2013-01-06 21:25:34', ''),
(308, 1, 1020, 1, 11508500, 'a', 22000000, '5/6', 'v', 'qpsk', 'a', 'auto', 'a', 'auto', 0, 'qpsk', 'a', 'auto', 'DVB-S', '0.35', 'dvb', 33, '2013-01-06 21:25:34', ''),
(307, 1, 1019, 1, 11493750, 'a', 22000000, '2/3', 'h', '8psk', 'a', 'auto', 'a', 'auto', 0, '8psk', 'a', 'auto', 'DVB-S2', '0.35', 'dvb', 33, '2013-01-06 21:25:34', ''),
(306, 1, 1018, 1, 11479000, 'a', 22000000, '5/6', 'v', 'qpsk', 'a', 'auto', 'a', 'auto', 0, 'qpsk', 'a', 'auto', 'DVB-S', '0.35', 'dvb', 33, '2013-01-06 21:25:34', ''),
(305, 1, 1015, 1, 11420750, 'a', 22000000, '5/6', 'h', 'qpsk', 'a', 'auto', 'a', 'auto', 0, 'qpsk', 'a', 'auto', 'DVB-S', '0.35', 'dvb', 33, '2013-01-06 21:25:34', ''),
(304, 1, 1012, 1, 11376500, 'a', 22000000, '2/3', 'v', '8psk', 'a', 'auto', 'a', 'auto', 0, '8psk', 'a', 'auto', 'DVB-S2', '0.35', 'dvb', 33, '2013-01-06 21:25:34', ''),
(303, 1, 1011, 1, 11361750, 'a', 22000000, '2/3', 'h', '8psk', 'a', 'auto', 'a', 'auto', 0, '8psk', 'a', 'auto', 'DVB-S2', '0.35', 'dvb', 33, '2013-01-06 21:25:34', ''),
(302, 1, 1010, 1, 11347000, 'a', 22000000, '2/3', 'v', '8psk', 'a', 'auto', 'a', 'auto', 0, '8psk', 'a', 'auto', 'DVB-S2', '0.35', 'dvb', 33, '2013-01-06 21:25:34', ''),
(301, 1, 1007, 1, 11302750, 'a', 22000000, '2/3', 'h', '8psk', 'a', 'auto', 'a', 'auto', 0, '8psk', 'a', 'auto', 'DVB-S2', '0.35', 'dvb', 33, '2013-01-06 21:25:34', ''),
(300, 1, 1004, 1, 11258500, 'a', 22000000, '2/3', 'v', '8psk', 'a', 'auto', 'a', 'auto', 0, '8psk', 'a', 'auto', 'DVB-S2', '0.35', 'dvb', 33, '2013-01-06 21:25:34', ''),
(299, 1, 1003, 1, 11243750, 'a', 22000000, '5/6', 'h', 'qpsk', 'a', 'auto', 'a', 'auto', 0, 'qpsk', 'a', 'auto', 'DVB-S', '0.35', 'dvb', 33, '2013-01-06 21:25:34', '');