Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- phpMyAdmin SQL Dump
- -- version 3.3.2deb1
- -- http://www.phpmyadmin.net
- --
- -- Machine: localhost
- -- Genereertijd: 27 Feb 2011 om 16:20
- -- Serverversie: 5.1.41
- -- PHP-Versie: 5.3.2-1ubuntu4.7
- SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
- /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
- /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
- /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
- /*!40101 SET NAMES utf8 */;
- --
- -- Database: `mythconverg`
- --
- -- --------------------------------------------------------
- --
- -- Tabelstructuur voor tabel `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=319 ;
- --
- -- Gegevens worden uitgevoerd voor tabel `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
- (299, 4, 17, 500, 586750000, 'a', 6875000, 'none', 'v', 'qam_64', 'a', 'auto', 'a', 'auto', 0, 'qam_64', 'a', 'auto', 'UNDEFINED', '0.35', 'dvb', 33, '2009-10-03 10:00:45', ''),
- (298, 4, 150, 500, 562750000, 'a', 6875000, 'none', 'v', 'qam_64', 'a', 'auto', 'a', 'auto', 0, 'qam_64', 'a', 'auto', 'UNDEFINED', '0.35', 'dvb', 33, '2009-10-02 17:55:22', ''),
- (297, 4, 1, 500, 404000000, 'a', 6875000, 'none', 'v', 'qam_64', 'a', 'auto', 'a', 'auto', 0, 'qam_64', 'a', 'auto', 'UNDEFINED', '0.35', 'dvb', 33, '2009-10-02 17:55:22', ''),
- (296, 4, 6, 500, 444000000, 'a', 6875000, 'none', 'v', 'qam_64', 'a', 'auto', 'a', 'auto', 0, 'qam_64', 'a', 'auto', 'UNDEFINED', '0.35', 'dvb', 33, '2009-10-02 17:53:02', ''),
- (250, 4, 7, 500, 514000000, 'a', 6875000, 'none', 'v', 'qam_64', 'a', 'auto', 'a', 'auto', 0, 'qam_64', 'a', 'auto', 'UNDEFINED', '0.35', 'dvb', 33, '2009-10-03 01:00:39', ''),
- (251, 4, 8, 500, 452000000, 'a', 6875000, 'none', 'v', 'qam_64', 'a', 'auto', 'a', 'auto', 0, 'qam_64', 'a', 'auto', 'UNDEFINED', '0.35', 'dvb', 33, '2009-10-03 00:50:51', ''),
- (301, 4, 10, 500, 468000000, 'a', 6875000, 'auto', NULL, 'qam_64', 'a', 'auto', 'a', 'auto', 0, 'auto', 'auto', 'auto', NULL, NULL, 'dvb', 33, '2009-10-03 09:53:52', ''),
- (302, 4, 11, 500, 476000000, 'a', 6875000, 'auto', NULL, 'qam_64', 'a', 'auto', 'a', 'auto', 0, 'auto', 'auto', 'auto', NULL, NULL, 'dvb', 33, '2009-10-03 09:54:11', ''),
- (303, 4, 12, 500, 546750000, 'a', 6875000, 'auto', NULL, 'qam_64', 'a', 'auto', 'a', 'auto', 0, 'auto', 'auto', 'auto', NULL, NULL, 'dvb', 33, '2009-10-03 09:54:49', ''),
- (304, 4, 13, 500, 626750000, 'a', 6875000, 'auto', NULL, 'qam_64', 'a', 'auto', 'a', 'auto', 0, 'auto', 'auto', 'auto', NULL, NULL, 'dvb', 33, '2009-10-03 09:55:08', ''),
- (305, 4, 14, 500, 634750000, 'a', 6875000, 'auto', NULL, 'qam_64', 'a', 'auto', 'a', 'auto', 0, 'auto', 'auto', 'auto', NULL, NULL, 'dvb', 33, '2009-10-03 09:54:35', ''),
- (306, 4, 15, 500, 666750000, 'a', 6875000, 'auto', NULL, 'qam_64', 'a', 'auto', 'a', 'auto', 0, 'auto', 'auto', 'auto', NULL, NULL, 'dvb', 33, '2009-10-03 10:02:10', ''),
- (294, 4, 4, 500, 428000000, 'a', 6875000, 'none', 'v', 'qam_64', 'a', 'auto', 'a', 'auto', 0, 'qam_64', 'a', 'auto', 'UNDEFINED', '0.35', 'dvb', 33, '2009-10-02 17:53:02', ''),
- (295, 4, 5, 500, 436000000, 'a', 6875000, 'none', 'v', 'qam_64', 'a', 'auto', 'a', 'auto', 0, 'qam_64', 'a', 'auto', 'UNDEFINED', '0.35', 'dvb', 33, '2009-10-02 17:53:02', ''),
- (268, 4, 22, 500, 714750000, 'a', 6875000, 'none', 'v', 'qam_64', 'a', 'auto', 'a', 'auto', 0, 'qam_64', 'a', 'auto', 'UNDEFINED', '0.35', 'dvb', 33, '2009-10-03 01:00:46', ''),
- (307, 4, 16, 500, 578750000, 'a', 6875000, 'auto', NULL, 'qam_64', 'a', 'auto', 'a', 'auto', 0, 'auto', 'auto', 'auto', NULL, NULL, 'dvb', 33, '2009-10-03 10:01:55', ''),
- (308, 4, 20, 500, 682750000, 'a', 6875000, 'auto', NULL, 'qam_64', 'a', 'auto', 'a', 'auto', 0, 'auto', 'auto', 'auto', NULL, NULL, 'dvb', 33, '2009-10-03 10:02:34', ''),
- (312, 4, 21, 500, 706750000, 'a', 6875000, 'auto', NULL, 'qam_64', 'a', 'auto', 'a', 'auto', 0, 'auto', 'auto', 'auto', NULL, NULL, 'dvb', 33, '2009-10-03 10:18:01', ''),
- (310, 4, 18, 500, 642750000, 'a', 6875000, 'auto', NULL, 'qam_64', 'a', 'auto', 'a', 'auto', 0, 'auto', 'auto', 'auto', NULL, NULL, 'dvb', 33, '2009-10-03 10:10:31', ''),
- (311, 4, 19, 500, 658750000, 'a', 6875000, 'auto', NULL, 'qam_64', 'a', 'auto', 'a', 'auto', 0, 'auto', 'auto', 'auto', NULL, NULL, 'dvb', 33, '2009-10-03 10:13:02', ''),
- (313, 4, 23, 500, 722750000, 'a', 6875000, 'auto', NULL, 'qam_64', 'a', 'auto', 'a', 'auto', 0, 'auto', 'auto', 'auto', NULL, NULL, 'dvb', 33, '2009-10-03 10:24:10', ''),
- (314, 4, 24, 500, 762750000, 'a', 6875000, 'auto', NULL, 'qam_64', 'a', 'auto', 'a', 'auto', 0, 'auto', 'auto', 'auto', NULL, NULL, 'dvb', 33, '2009-10-03 10:25:28', ''),
- (292, 4, 2, 500, 412000000, 'a', 6875000, 'none', 'v', 'qam_64', 'a', 'auto', 'a', 'auto', 0, 'qam_64', 'a', 'auto', 'UNDEFINED', '0.35', 'dvb', 33, '2009-10-02 17:53:01', ''),
- (293, 4, 3, 500, 420000000, 'a', 6875000, 'none', 'v', 'qam_64', 'a', 'auto', 'a', 'auto', 0, 'qam_64', 'a', 'auto', 'UNDEFINED', '0.35', 'dvb', 33, '2009-10-02 17:53:02', ''),
- (290, 4, 27, 500, 570750000, 'a', 6875000, 'none', 'v', 'qam_64', 'a', 'auto', 'a', 'auto', 0, 'qam_64', 'a', 'auto', 'UNDEFINED', '0.35', 'dvb', 33, '2009-10-03 01:00:57', ''),
- (315, 4, 25, 500, 794750000, 'a', 6875000, 'auto', NULL, 'qam_64', 'a', 'auto', 'a', 'auto', 0, 'auto', 'auto', 'auto', NULL, NULL, 'dvb', 33, '2009-10-03 10:26:45', ''),
- (316, 4, 26, 500, 826750000, 'a', 6875000, 'auto', NULL, 'qam_64', 'a', 'auto', 'a', 'auto', 0, 'auto', 'auto', 'auto', NULL, NULL, 'dvb', 33, '2009-10-03 10:28:06', ''),
- (318, 4, 28, 500, 730750000, 'a', 6875000, 'auto', NULL, 'qam_64', 'a', 'auto', 'a', 'auto', 0, 'auto', 'auto', 'auto', NULL, NULL, 'dvb', 33, '2009-10-03 10:37:30', ''),
- (300, 4, 9, 500, 460000000, 'a', 6875000, 'none', 'v', 'qam_64', 'a', 'auto', 'a', 'auto', 0, 'qam_64', 'a', 'auto', NULL, '0.35', 'dvb', 33, '2009-10-03 09:30:23', '');
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement