diff options
Diffstat (limited to 'abs/core/mythtv/stable')
25 files changed, 3828 insertions, 0 deletions
diff --git a/abs/core/mythtv/stable/mytharchive/PKGBUILD b/abs/core/mythtv/stable/mytharchive/PKGBUILD new file mode 100644 index 0000000..fb3b755 --- /dev/null +++ b/abs/core/mythtv/stable/mytharchive/PKGBUILD @@ -0,0 +1,35 @@ +# $Id: PKGBUILD 356 2008-04-18 22:56:27Z aaron $ +# Maintainer: Juergen Hoetzel <juergen@archlinux.org> +# Contributor: kleptophobiac@gmail.com + +pkgname=mytharchive +pkgver=0.21 +pkgrel=1 +pkgdesc="MythTV plugin that lets you create DVDs from or archive your recorded shows." +arch=('i686' 'x86_64') +url="http://www.mythtv.org" +license=('GPL') +depends=("mythtv>=${pkgver}" 'libxmu' 'mysql-python' 'pil' 'dvdauthor') +source=("ftp://ftp.knoppmyth.net/R6/sources/mythplugins-$pkgver-fixes.tar.bz2") +md5sums=('af20a78ac66719feddf9a39f1a799ded') +groups=('mythtv-extras') + +build() { + cd $startdir/src/mythplugins-${pkgver} + . /etc/profile.d/qt3.sh + + # use QT3 qmake + export PATH=$QTDIR/bin:$PATH + + sed -i 's#kde3#kde#' configure || return 1 + ./configure --prefix=/usr --enable-opengl --disable-all \ + --enable-create-archive --enable-create-dvd --enable-mytharchive || return 1 + + qmake mythplugins.pro || return 1 + make qmake || return 1 + sed -i 's#kde3#kde#' ./mytharchive/mytharchive/Makefile || return 1 + make -j 2 || return 1 + + make INSTALL_ROOT=$startdir/pkg install +} + diff --git a/abs/core/mythtv/stable/mythbrowser/PKGBUILD b/abs/core/mythtv/stable/mythbrowser/PKGBUILD new file mode 100644 index 0000000..5a53093 --- /dev/null +++ b/abs/core/mythtv/stable/mythbrowser/PKGBUILD @@ -0,0 +1,33 @@ +# $Id: PKGBUILD 7374 2008-07-31 06:53:36Z eric $ +# Maintainer: Juergen Hoetzel <juergen@archlinux.org> +# Contributor: kleptophobiac@gmail.com + +pkgname=mythbrowser +pkgver=0.21 +pkgrel=2 +pkgdesc="Mini web browser for MythTV" +arch=('i686' 'x86_64') +url="http://www.mythtv.org" +license=('GPL') +depends=("mythtv>=${pkgver}" 'wget' 'libxvmc' 'kdelibs3') +groups=('mythtv-extras') +options=('!makeflags') +source=("ftp://ftp.knoppmyth.net/R6/sources/mythplugins-$pkgver-fixes.tar.bz2") +md5sums=('af20a78ac66719feddf9a39f1a799ded') + +build() { + cd $startdir/src/mythplugins-${pkgver} + . /etc/profile.d/qt3.sh + . /etc/profile.d/kde3.sh + + sed -i 's#kde3#kde#' configure || return 1 + ./configure --prefix=/usr --enable-opengl --disable-all --enable-mythbrowser || return 1 + + qmake mythplugins.pro || return 1 + make qmake || return 1 + sed -i 's#kde3#kde#' ./mythbrowser/mythbrowser/Makefile || return 1 + make || return 1 + + make INSTALL_ROOT=$startdir/pkg install +} + diff --git a/abs/core/mythtv/stable/mythcontrols/PKGBUILD b/abs/core/mythtv/stable/mythcontrols/PKGBUILD new file mode 100644 index 0000000..cf7f43c --- /dev/null +++ b/abs/core/mythtv/stable/mythcontrols/PKGBUILD @@ -0,0 +1,32 @@ +# $Id: PKGBUILD 356 2008-04-18 22:56:27Z aaron $ +# Maintainer: Juergen Hoetzel <travis@archlinux.org> +# Contributor: kleptophobiac@gmail.com + +pkgname=mythcontrols +pkgver=0.21 +pkgrel=1 +pkgdesc="Experimental controls for MythTV" +arch=('i686' 'x86_64') +url="http://www.mythtv.org" +license=('GPL') +depends=("mythtv>=${pkgver}") +options=('!makeflags') +source=("ftp://ftp.knoppmyth.net/R6/sources/mythplugins-$pkgver-fixes.tar.bz2") +md5sums=('af20a78ac66719feddf9a39f1a799ded') +groups=('mythtv-extras') + +build() { + cd $startdir/src/mythplugins-${pkgver} + . /etc/profile.d/qt3.sh + + # use QT3 qmake + export PATH=$QTDIR/bin:$PATH + ./configure --prefix=/usr --disable-all --enable-opengl --enable-mythcontrols + + qmake mythplugins.pro + make qmake || return 1 + make || return 1 + + make INSTALL_ROOT=$startdir/pkg install +} + diff --git a/abs/core/mythtv/stable/mythdb-initial/PKGBUILD b/abs/core/mythtv/stable/mythdb-initial/PKGBUILD new file mode 100755 index 0000000..02f2789 --- /dev/null +++ b/abs/core/mythtv/stable/mythdb-initial/PKGBUILD @@ -0,0 +1,21 @@ +pkgname=mythdb-initial +pkgver=1 +pkgrel=3 +pkgdesc="setup the initial mythtv database for linhes" +url="" +license="" +depends=(mysql) +makedepends=() +conflicts=() +replaces=() +backup=() +install=mythdb.install +source=(mc.sql permissions.sql) +md5sums=() +arch=('i686') +build() { + cd $startdir/src + mkdir -p $startdir/pkg/data/database + cp mc.sql $startdir/pkg/data/database/mc.sql.initial + cp permissions.sql $startdir/pkg/data/database/permissions.sql +} diff --git a/abs/core/mythtv/stable/mythdb-initial/mc.sql b/abs/core/mythtv/stable/mythdb-initial/mc.sql new file mode 100644 index 0000000..6e9bdaa --- /dev/null +++ b/abs/core/mythtv/stable/mythdb-initial/mc.sql @@ -0,0 +1,2797 @@ +-- MySQL dump 10.11 +-- +-- Host: localhost Database: mythconverg +-- ------------------------------------------------------ +-- Server version 5.0.60 + +/*!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 */; +/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */; +/*!40103 SET TIME_ZONE='+00:00' */; +/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */; +/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */; +/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */; +/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */; + +-- +-- Table structure for table `archiveitems` +-- + +DROP TABLE IF EXISTS `archiveitems`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `archiveitems` ( + `intid` int(10) unsigned NOT NULL auto_increment, + `type` set('Recording','Video','File') default NULL, + `title` varchar(128) default NULL, + `subtitle` varchar(128) default NULL, + `description` text, + `startdate` varchar(30) default NULL, + `starttime` varchar(30) default NULL, + `size` bigint(20) unsigned NOT NULL, + `filename` text NOT NULL, + `hascutlist` tinyint(1) NOT NULL default '0', + `cutlist` text, + PRIMARY KEY (`intid`), + KEY `title` (`title`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Dumping data for table `archiveitems` +-- + +LOCK TABLES `archiveitems` WRITE; +/*!40000 ALTER TABLE `archiveitems` DISABLE KEYS */; +/*!40000 ALTER TABLE `archiveitems` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `callsignnetworkmap` +-- + +DROP TABLE IF EXISTS `callsignnetworkmap`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `callsignnetworkmap` ( + `id` int(11) NOT NULL auto_increment, + `callsign` varchar(20) NOT NULL default '', + `network` varchar(20) NOT NULL default '', + PRIMARY KEY (`id`), + UNIQUE KEY `callsign` (`callsign`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Dumping data for table `callsignnetworkmap` +-- + +LOCK TABLES `callsignnetworkmap` WRITE; +/*!40000 ALTER TABLE `callsignnetworkmap` DISABLE KEYS */; +/*!40000 ALTER TABLE `callsignnetworkmap` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `capturecard` +-- + +DROP TABLE IF EXISTS `capturecard`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +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_sat_type` int(11) NOT NULL default '0', + `dvb_wait_for_seqstart` int(11) NOT NULL default '1', + `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', + `dbox2_port` int(10) unsigned NOT NULL default '31338', + `dbox2_httpport` int(10) unsigned NOT NULL default '80', + `dbox2_host` varchar(32) default NULL, + `signal_timeout` int(11) NOT NULL default '1000', + `channel_timeout` int(11) NOT NULL default '3000', + `dvb_tuning_delay` int(10) unsigned NOT NULL default '0', + `contrast` int(11) NOT NULL default '0', + `brightness` int(11) NOT NULL default '0', + `colour` int(11) NOT NULL default '0', + `hue` int(11) NOT NULL default '0', + `diseqcid` int(10) unsigned default NULL, + `dvb_eitscan` tinyint(1) NOT NULL default '1', + PRIMARY KEY (`cardid`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Dumping data for table `capturecard` +-- + +LOCK TABLES `capturecard` WRITE; +/*!40000 ALTER TABLE `capturecard` DISABLE KEYS */; +/*!40000 ALTER TABLE `capturecard` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `cardinput` +-- + +DROP TABLE IF EXISTS `cardinput`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +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(10) default NULL, + `startchan` varchar(10) default NULL, + `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', + `displayname` varchar(64) NOT NULL default '', + `radioservices` tinyint(1) default '1', + `dishnet_eit` tinyint(1) NOT NULL default '0', + `recpriority` int(11) NOT NULL default '0', + `quicktune` tinyint(4) NOT NULL default '0', + PRIMARY KEY (`cardinputid`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Dumping data for table `cardinput` +-- + +LOCK TABLES `cardinput` WRITE; +/*!40000 ALTER TABLE `cardinput` DISABLE KEYS */; +/*!40000 ALTER TABLE `cardinput` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `channel` +-- + +DROP TABLE IF EXISTS `channel`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `channel` ( + `chanid` int(10) unsigned NOT NULL default '0', + `channum` varchar(10) 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` mediumint(8) unsigned default NULL, + `atscsrcid` int(11) default NULL, + `tmoffset` int(11) NOT NULL default '0', + `atsc_major_chan` int(10) unsigned NOT NULL default '0', + `atsc_minor_chan` int(10) unsigned NOT NULL default '0', + `last_record` datetime NOT NULL, + `default_authority` varchar(32) NOT NULL default '', + `commmethod` int(11) NOT NULL default '-1', + PRIMARY KEY (`chanid`), + KEY `channel_src` (`channum`,`sourceid`), + KEY `sourceid` (`sourceid`,`xmltvid`,`chanid`), + KEY `visible` (`visible`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Dumping data for table `channel` +-- + +LOCK TABLES `channel` WRITE; +/*!40000 ALTER TABLE `channel` DISABLE KEYS */; +/*!40000 ALTER TABLE `channel` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `codecparams` +-- + +DROP TABLE IF EXISTS `codecparams`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `codecparams` ( + `profile` int(10) unsigned NOT NULL default '0', + `name` varchar(128) NOT NULL default '', + `value` varchar(128) default NULL, + PRIMARY KEY (`profile`,`name`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Dumping data for table `codecparams` +-- + +LOCK TABLES `codecparams` WRITE; +/*!40000 ALTER TABLE `codecparams` DISABLE KEYS */; +/*!40000 ALTER TABLE `codecparams` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `credits` +-- + +DROP TABLE IF EXISTS `credits`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `credits` ( + `person` mediumint(8) unsigned NOT NULL default '0', + `chanid` int(10) unsigned NOT NULL default '0', + `starttime` datetime NOT NULL default '0000-00-00 00:00:00', + `role` set('actor','director','producer','executive_producer','writer','guest_star','host','adapter','presenter','commentator','guest') NOT NULL default '', + UNIQUE KEY `chanid` (`chanid`,`starttime`,`person`,`role`), + KEY `person` (`person`,`role`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Dumping data for table `credits` +-- + +LOCK TABLES `credits` WRITE; +/*!40000 ALTER TABLE `credits` DISABLE KEYS */; +/*!40000 ALTER TABLE `credits` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `customexample` +-- + +DROP TABLE IF EXISTS `customexample`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `customexample` ( + `rulename` varchar(64) NOT NULL, + `fromclause` text NOT NULL, + `whereclause` text NOT NULL, + `search` tinyint(4) NOT NULL default '0', + PRIMARY KEY (`rulename`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Dumping data for table `customexample` +-- + +LOCK TABLES `customexample` WRITE; +/*!40000 ALTER TABLE `customexample` DISABLE KEYS */; +INSERT INTO `customexample` (`rulename`, `fromclause`, `whereclause`, `search`) VALUES ('New Flix','','program.category_type = \'movie\' AND program.airdate >= \n YEAR(DATE_SUB(NOW(), INTERVAL 1 YEAR)) \nAND program.stars > 0.5 ',1); +/*!40000 ALTER TABLE `customexample` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `diseqc_config` +-- + +DROP TABLE IF EXISTS `diseqc_config`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `diseqc_config` ( + `cardinputid` int(10) unsigned NOT NULL, + `diseqcid` int(10) unsigned NOT NULL, + `value` varchar(16) NOT NULL default '', + KEY `id` (`cardinputid`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Dumping data for table `diseqc_config` +-- + +LOCK TABLES `diseqc_config` WRITE; +/*!40000 ALTER TABLE `diseqc_config` DISABLE KEYS */; +/*!40000 ALTER TABLE `diseqc_config` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `diseqc_tree` +-- + +DROP TABLE IF EXISTS `diseqc_tree`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `diseqc_tree` ( + `diseqcid` int(10) unsigned NOT NULL auto_increment, + `parentid` int(10) unsigned default NULL, + `ordinal` tinyint(3) unsigned NOT NULL, + `type` varchar(16) NOT NULL default '', + `subtype` varchar(16) NOT NULL default '', + `description` varchar(32) NOT NULL default '', + `switch_ports` tinyint(3) unsigned NOT NULL default '0', + `rotor_hi_speed` float NOT NULL default '0', + `rotor_lo_speed` float NOT NULL default '0', + `rotor_positions` varchar(255) NOT NULL default '', + `lnb_lof_switch` int(10) NOT NULL default '0', + `lnb_lof_hi` int(10) NOT NULL default '0', + `lnb_lof_lo` int(10) NOT NULL default '0', + `cmd_repeat` int(11) NOT NULL default '1', + `lnb_pol_inv` tinyint(4) NOT NULL default '0', + PRIMARY KEY (`diseqcid`), + KEY `parentid` (`parentid`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Dumping data for table `diseqc_tree` +-- + +LOCK TABLES `diseqc_tree` WRITE; +/*!40000 ALTER TABLE `diseqc_tree` DISABLE KEYS */; +/*!40000 ALTER TABLE `diseqc_tree` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `displayprofilegroups` +-- + +DROP TABLE IF EXISTS `displayprofilegroups`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `displayprofilegroups` ( + `name` varchar(128) NOT NULL, + `hostname` varchar(255) NOT NULL, + `profilegroupid` int(10) unsigned NOT NULL auto_increment, + PRIMARY KEY (`name`,`hostname`), + UNIQUE KEY `profilegroupid` (`profilegroupid`) +) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Dumping data for table `displayprofilegroups` +-- + +LOCK TABLES `displayprofilegroups` WRITE; +/*!40000 ALTER TABLE `displayprofilegroups` DISABLE KEYS */; +INSERT INTO `displayprofilegroups` (`name`, `hostname`, `profilegroupid`) VALUES ('CPU++','larch5',1),('CPU+','larch5',2),('CPU--','larch5',3),('High Quality','larch5',4),('Normal','larch5',5),('Slim','larch5',6); +/*!40000 ALTER TABLE `displayprofilegroups` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `displayprofiles` +-- + +DROP TABLE IF EXISTS `displayprofiles`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `displayprofiles` ( + `profilegroupid` int(10) unsigned NOT NULL, + `profileid` int(10) unsigned NOT NULL auto_increment, + `value` varchar(128) NOT NULL, + `data` varchar(255) NOT NULL default '', + KEY `profilegroupid` (`profilegroupid`), + KEY `profileid` (`profileid`,`value`), + KEY `profileid_2` (`profileid`) +) ENGINE=MyISAM AUTO_INCREMENT=25 DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Dumping data for table `displayprofiles` +-- + +LOCK TABLES `displayprofiles` WRITE; +/*!40000 ALTER TABLE `displayprofiles` DISABLE KEYS */; +INSERT INTO `displayprofiles` (`profilegroupid`, `profileid`, `value`, `data`) VALUES (1,1,'pref_priority','1'),(1,1,'pref_cmp0','> 0 0'),(1,1,'pref_decoder','ffmpeg'),(1,1,'pref_max_cpus','1'),(1,1,'pref_videorenderer','xv-blit'),(1,1,'pref_osdrenderer','softblend'),(1,1,'pref_osdfade','1'),(1,1,'pref_deint0','bobdeint'),(1,1,'pref_deint1','linearblend'),(1,1,'pref_filters',''),(1,2,'pref_priority','2'),(1,2,'pref_cmp0','> 0 0'),(1,2,'pref_decoder','ffmpeg'),(1,2,'pref_max_cpus','1'),(1,2,'pref_videorenderer','quartz-blit'),(1,2,'pref_osdrenderer','softblend'),(1,2,'pref_osdfade','1'),(1,2,'pref_deint0','linearblend'),(1,2,'pref_deint1','linearblend'),(1,2,'pref_filters',''),(2,3,'pref_priority','1'),(2,3,'pref_cmp0','<= 720 576'),(2,3,'pref_cmp1','> 0 0'),(2,3,'pref_decoder','ffmpeg'),(2,3,'pref_max_cpus','1'),(2,3,'pref_videorenderer','xv-blit'),(2,3,'pref_osdrenderer','softblend'),(2,3,'pref_osdfade','1'),(2,3,'pref_deint0','bobdeint'),(2,3,'pref_deint1','linearblend'),(2,3,'pref_filters',''),(2,4,'pref_priority','2'),(2,4,'pref_cmp0','<= 1280 720'),(2,4,'pref_cmp1','> 720 576'),(2,4,'pref_decoder','xvmc'),(2,4,'pref_max_cpus','1'),(2,4,'pref_videorenderer','xvmc-blit'),(2,4,'pref_osdrenderer','opengl'),(2,4,'pref_osdfade','1'),(2,4,'pref_deint0','bobdeint'),(2,4,'pref_deint1','onefield'),(2,4,'pref_filters',''),(2,5,'pref_priority','3'),(2,5,'pref_cmp0','<= 1280 720'),(2,5,'pref_cmp1','> 720 576'),(2,5,'pref_decoder','libmpeg2'),(2,5,'pref_max_cpus','1'),(2,5,'pref_videorenderer','xv-blit'),(2,5,'pref_osdrenderer','softblend'),(2,5,'pref_osdfade','1'),(2,5,'pref_deint0','bobdeint'),(2,5,'pref_deint1','onefield'),(2,5,'pref_filters',''),(2,6,'pref_priority','4'),(2,6,'pref_cmp0','> 0 0'),(2,6,'pref_decoder','xvmc'),(2,6,'pref_max_cpus','1'),(2,6,'pref_videorenderer','xvmc-blit'),(2,6,'pref_osdrenderer','ia44blend'),(2,6,'pref_osdfade','0'),(2,6,'pref_deint0','bobdeint'),(2,6,'pref_deint1','onefield'),(2,6,'pref_filters',''),(2,7,'pref_priority','5'),(2,7,'pref_cmp0','> 0 0'),(2,7,'pref_decoder','libmpeg2'),(2,7,'pref_max_cpus','1'),(2,7,'pref_videorenderer','xv-blit'),(2,7,'pref_osdrenderer','chromakey'),(2,7,'pref_osdfade','0'),(2,7,'pref_deint0','bobdeint'),(2,7,'pref_deint1','onefield'),(2,7,'pref_filters',''),(3,8,'pref_priority','1'),(3,8,'pref_cmp0','<= 720 576'),(3,8,'pref_cmp1','> 0 0'),(3,8,'pref_decoder','ivtv'),(3,8,'pref_max_cpus','1'),(3,8,'pref_videorenderer','ivtv'),(3,8,'pref_osdrenderer','ivtv'),(3,8,'pref_osdfade','1'),(3,8,'pref_deint0','none'),(3,8,'pref_deint1','none'),(3,8,'pref_filters',''),(3,9,'pref_priority','2'),(3,9,'pref_cmp0','<= 720 576'),(3,9,'pref_cmp1','> 0 0'),(3,9,'pref_decoder','xvmc'),(3,9,'pref_max_cpus','1'),(3,9,'pref_videorenderer','xvmc-blit'),(3,9,'pref_osdrenderer','ia44blend'),(3,9,'pref_osdfade','0'),(3,9,'pref_deint0','bobdeint'),(3,9,'pref_deint1','onefield'),(3,9,'pref_filters',''),(3,10,'pref_priority','3'),(3,10,'pref_cmp0','<= 1280 720'),(3,10,'pref_cmp1','> 720 576'),(3,10,'pref_decoder','xvmc'),(3,10,'pref_max_cpus','1'),(3,10,'pref_videorenderer','xvmc-blit'),(3,10,'pref_osdrenderer','ia44blend'),(3,10,'pref_osdfade','0'),(3,10,'pref_deint0','bobdeint'),(3,10,'pref_deint1','onefield'),(3,10,'pref_filters',''),(3,11,'pref_priority','4'),(3,11,'pref_cmp0','> 0 0'),(3,11,'pref_decoder','xvmc'),(3,11,'pref_max_cpus','1'),(3,11,'pref_videorenderer','xvmc-blit'),(3,11,'pref_osdrenderer','ia44blend'),(3,11,'pref_osdfade','0'),(3,11,'pref_deint0','bobdeint'),(3,11,'pref_deint1','onefield'),(3,11,'pref_filters',''),(3,12,'pref_priority','5'),(3,12,'pref_cmp0','> 0 0'),(3,12,'pref_decoder','libmpeg2'),(3,12,'pref_max_cpus','1'),(3,12,'pref_videorenderer','xv-blit'),(3,12,'pref_osdrenderer','chromakey'),(3,12,'pref_osdfade','0'),(3,12,'pref_deint0','none'),(3,12,'pref_deint1','none'),(3,12,'pref_filters',''),(4,13,'pref_priority','1'),(4,13,'pref_cmp0','>= 1920 1080'),(4,13,'pref_decoder','ffmpeg'),(4,13,'pref_max_cpus','2'),(4,13,'pref_videorenderer','xv-blit'),(4,13,'pref_osdrenderer','softblend'),(4,13,'pref_osdfade','1'),(4,13,'pref_deint0','linearblend'),(4,13,'pref_deint1','linearblend'),(4,13,'pref_filters',''),(4,14,'pref_priority','2'),(4,14,'pref_cmp0','> 0 0'),(4,14,'pref_decoder','ffmpeg'),(4,14,'pref_max_cpus','1'),(4,14,'pref_videorenderer','xv-blit'),(4,14,'pref_osdrenderer','softblend'),(4,14,'pref_osdfade','1'),(4,14,'pref_deint0','yadifdoubleprocessdeint'),(4,14,'pref_deint1','yadifdeint'),(4,14,'pref_filters',''),(4,15,'pref_priority','3'),(4,15,'pref_cmp0','>= 1920 1080'),(4,15,'pref_decoder','ffmpeg'),(4,15,'pref_max_cpus','2'),(4,15,'pref_videorenderer','quartz-blit'),(4,15,'pref_osdrenderer','softblend'),(4,15,'pref_osdfade','1'),(4,15,'pref_deint0','linearblend'),(4,15,'pref_deint1','linearblend'),(4,15,'pref_filters',''),(4,16,'pref_priority','4'),(4,16,'pref_cmp0','> 0 0'),(4,16,'pref_decoder','ffmpeg'),(4,16,'pref_max_cpus','1'),(4,16,'pref_videorenderer','quartz-blit'),(4,16,'pref_osdrenderer','softblend'),(4,16,'pref_osdfade','1'),(4,16,'pref_deint0','yadifdoubleprocessdeint'),(4,16,'pref_deint1','yadifdeint'),(4,16,'pref_filters',''),(5,17,'pref_priority','1'),(5,17,'pref_cmp0','>= 1280 720'),(5,17,'pref_decoder','ffmpeg'),(5,17,'pref_max_cpus','1'),(5,17,'pref_videorenderer','xv-blit'),(5,17,'pref_osdrenderer','softblend'),(5,17,'pref_osdfade','0'),(5,17,'pref_deint0','linearblend'),(5,17,'pref_deint1','linearblend'),(5,17,'pref_filters',''),(5,18,'pref_priority','2'),(5,18,'pref_cmp0','> 0 0'),(5,18,'pref_decoder','ffmpeg'),(5,18,'pref_max_cpus','1'),(5,18,'pref_videorenderer','xv-blit'),(5,18,'pref_osdrenderer','softblend'),(5,18,'pref_osdfade','1'),(5,18,'pref_deint0','greedyhdoubleprocessdeint'),(5,18,'pref_deint1','kerneldeint'),(5,18,'pref_filters',''),(5,19,'pref_priority','3'),(5,19,'pref_cmp0','>= 1280 720'),(5,19,'pref_decoder','ffmpeg'),(5,19,'pref_max_cpus','1'),(5,19,'pref_videorenderer','quartz-blit'),(5,19,'pref_osdrenderer','softblend'),(5,19,'pref_osdfade','0'),(5,19,'pref_deint0','linearblend'),(5,19,'pref_deint1','linearblend'),(5,19,'pref_filters',''),(5,20,'pref_priority','4'),(5,20,'pref_cmp0','> 0 0'),(5,20,'pref_decoder','ffmpeg'),(5,20,'pref_max_cpus','1'),(5,20,'pref_videorenderer','quartz-blit'),(5,20,'pref_osdrenderer','softblend'),(5,20,'pref_osdfade','1'),(5,20,'pref_deint0','greedyhdoubleprocessdeint'),(5,20,'pref_deint1','kerneldeint'),(5,20,'pref_filters',''),(6,21,'pref_priority','1'),(6,21,'pref_cmp0','>= 1280 720'),(6,21,'pref_decoder','ffmpeg'),(6,21,'pref_max_cpus','1'),(6,21,'pref_videorenderer','xv-blit'),(6,21,'pref_osdrenderer','softblend'),(6,21,'pref_osdfade','0'),(6,21,'pref_deint0','onefield'),(6,21,'pref_deint1','onefield'),(6,21,'pref_filters',''),(6,22,'pref_priority','2'),(6,22,'pref_cmp0','> 0 0'),(6,22,'pref_decoder','ffmpeg'),(6,22,'pref_max_cpus','1'),(6,22,'pref_videorenderer','xv-blit'),(6,22,'pref_osdrenderer','softblend'),(6,22,'pref_osdfade','1'),(6,22,'pref_deint0','linearblend'),(6,22,'pref_deint1','linearblend'),(6,22,'pref_filters',''),(6,23,'pref_priority','3'),(6,23,'pref_cmp0','>= 1280 720'),(6,23,'pref_decoder','ffmpeg'),(6,23,'pref_max_cpus','1'),(6,23,'pref_videorenderer','quartz-blit'),(6,23,'pref_osdrenderer','softblend'),(6,23,'pref_osdfade','0'),(6,23,'pref_deint0','onefield'),(6,23,'pref_deint1','onefield'),(6,23,'pref_filters',''),(6,24,'pref_priority','4'),(6,24,'pref_cmp0','> 0 0'),(6,24,'pref_decoder','ffmpeg'),(6,24,'pref_max_cpus','1'),(6,24,'pref_videorenderer','quartz-blit'),(6,24,'pref_osdrenderer','softblend'),(6,24,'pref_osdfade','1'),(6,24,'pref_deint0','linearblend'),(6,24,'pref_deint1','linearblend'),(6,24,'pref_filters',''); +/*!40000 ALTER TABLE `displayprofiles` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `dtv_multiplex` +-- + +DROP TABLE IF EXISTS `dtv_multiplex`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +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 NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, + PRIMARY KEY (`mplexid`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Dumping data for table `dtv_multiplex` +-- + +LOCK TABLES `dtv_multiplex` WRITE; +/*!40000 ALTER TABLE `dtv_multiplex` DISABLE KEYS */; +/*!40000 ALTER TABLE `dtv_multiplex` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `dtv_privatetypes` +-- + +DROP TABLE IF EXISTS `dtv_privatetypes`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +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 '' +) ENGINE=MyISAM DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Dumping data for table `dtv_privatetypes` +-- + +LOCK TABLES `dtv_privatetypes` WRITE; +/*!40000 ALTER TABLE `dtv_privatetypes` DISABLE KEYS */; +INSERT INTO `dtv_privatetypes` (`sitype`, `networkid`, `private_type`, `private_value`) VALUES ('dvb',9018,'channel_numbers','131'),('dvb',9018,'guide_fixup','2'),('dvb',256,'guide_fixup','1'),('dvb',257,'guide_fixup','1'),('dvb',256,'tv_types','1,150,134,133'),('dvb',257,'tv_types','1,150,134,133'),('dvb',4100,'sdt_mapping','1'),('dvb',4101,'sdt_mapping','1'),('dvb',4102,'sdt_mapping','1'),('dvb',4103,'sdt_mapping','1'),('dvb',4104,'sdt_mapping','1'),('dvb',4105,'sdt_mapping','1'),('dvb',4106,'sdt_mapping','1'),('dvb',4107,'sdt_mapping','1'),('dvb',4097,'sdt_mapping','1'),('dvb',4098,'sdt_mapping','1'),('dvb',4100,'tv_types','1,145,154'),('dvb',4101,'tv_types','1,145,154'),('dvb',4102,'tv_types','1,145,154'),('dvb',4103,'tv_types','1,145,154'),('dvb',4104,'tv_types','1,145,154'),('dvb',4105,'tv_types','1,145,154'),('dvb',4106,'tv_types','1,145,154'),('dvb',4107,'tv_types','1,145,154'),('dvb',4097,'tv_types','1,145,154'),('dvb',4098,'tv_types','1,145,154'),('dvb',4100,'guide_fixup','1'),('dvb',4101,'guide_fixup','1'),('dvb',4102,'guide_fixup','1'),('dvb',4103,'guide_fixup','1'),('dvb',4104,'guide_fixup','1'),('dvb',4105,'guide_fixup','1'),('dvb',4106,'guide_fixup','1'),('dvb',4107,'guide_fixup','1'),('dvb',4096,'guide_fixup','5'),('dvb',4097,'guide_fixup','1'),('dvb',4098,'guide_fixup','1'),('dvb',94,'tv_types','1,128'),('atsc',1793,'guide_fixup','3'),('dvb',40999,'guide_fixup','4'),('dvb',70,'force_guide_present','yes'),('dvb',70,'guide_ranges','80,80,96,96'),('dvb',4112,'channel_numbers','131'),('dvb',4115,'channel_numbers','131'),('dvb',4116,'channel_numbers','131'),('dvb',12802,'channel_numbers','131'),('dvb',12803,'channel_numbers','131'),('dvb',12829,'channel_numbers','131'),('dvb',40999,'parse_subtitle_list','1070,1308,1041,1306,1307,1030,1016,1131,1068,1069'),('dvb',4096,'guide_fixup','5'); +/*!40000 ALTER TABLE `dtv_privatetypes` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `dvdbookmark` +-- + +DROP TABLE IF EXISTS `dvdbookmark`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `dvdbookmark` ( + `serialid` varchar(16) NOT NULL default '', + `name` varchar(32) default NULL, + `title` smallint(6) NOT NULL default '0', + `audionum` tinyint(4) NOT NULL default '-1', + `subtitlenum` tinyint(4) NOT NULL default '-1', + `framenum` bigint(20) NOT NULL default '0', + `timestamp` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, + PRIMARY KEY (`serialid`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Dumping data for table `dvdbookmark` +-- + +LOCK TABLES `dvdbookmark` WRITE; +/*!40000 ALTER TABLE `dvdbookmark` DISABLE KEYS */; +/*!40000 ALTER TABLE `dvdbookmark` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `dvdinput` +-- + +DROP TABLE IF EXISTS `dvdinput`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `dvdinput` ( + `intid` int(10) unsigned NOT NULL, + `hsize` int(10) unsigned default NULL, + `vsize` int(10) unsigned default NULL, + `ar_num` int(10) unsigned default NULL, + `ar_denom` int(10) unsigned default NULL, + `fr_code` int(10) unsigned default NULL, + `letterbox` tinyint(1) default NULL, + `v_format` varchar(16) default NULL, + PRIMARY KEY (`intid`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Dumping data for table `dvdinput` +-- + +LOCK TABLES `dvdinput` WRITE; +/*!40000 ALTER TABLE `dvdinput` DISABLE KEYS */; +INSERT INTO `dvdinput` (`intid`, `hsize`, `vsize`, `ar_num`, `ar_denom`, `fr_code`, `letterbox`, `v_format`) VALUES (1,720,480,16,9,1,1,'ntsc'),(2,720,480,16,9,1,0,'ntsc'),(3,720,480,4,3,1,1,'ntsc'),(4,720,480,4,3,1,0,'ntsc'),(5,720,576,16,9,3,1,'pal'),(6,720,576,16,9,3,0,'pal'),(7,720,576,4,3,3,1,'pal'),(8,720,576,4,3,3,0,'pal'); +/*!40000 ALTER TABLE `dvdinput` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `dvdtranscode` +-- + +DROP TABLE IF EXISTS `dvdtranscode`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `dvdtranscode` ( + `intid` int(11) NOT NULL auto_increment, + `input` int(10) unsigned default NULL, + `name` varchar(128) NOT NULL, + `sync_mode` int(10) unsigned default NULL, + `use_yv12` tinyint(1) default NULL, + `cliptop` int(11) default NULL, + `clipbottom` int(11) default NULL, + `clipleft` int(11) default NULL, + `clipright` int(11) default NULL, + `f_resize_h` int(11) default NULL, + `f_resize_w` int(11) default NULL, + `hq_resize_h` int(11) default NULL, + `hq_resize_w` int(11) default NULL, + `grow_h` int(11) default NULL, + `grow_w` int(11) default NULL, + `clip2top` int(11) default NULL, + `clip2bottom` int(11) default NULL, + `clip2left` int(11) default NULL, + `clip2right` int(11) default NULL, + `codec` varchar(128) NOT NULL, + `codec_param` varchar(128) default NULL, + `bitrate` int(11) default NULL, + `a_sample_r` int(11) default NULL, + `a_bitrate` int(11) default NULL, + `two_pass` tinyint(1) default NULL, + `tc_param` varchar(128) default NULL, + PRIMARY KEY (`intid`) +) ENGINE=MyISAM AUTO_INCREMENT=12 DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Dumping data for table `dvdtranscode` +-- + +LOCK TABLES `dvdtranscode` WRITE; +/*!40000 ALTER TABLE `dvdtranscode` DISABLE KEYS */; +INSERT INTO `dvdtranscode` (`intid`, `input`, `name`, `sync_mode`, `use_yv12`, `cliptop`, `clipbottom`, `clipleft`, `clipright`, `f_resize_h`, `f_resize_w`, `hq_resize_h`, `hq_resize_w`, `grow_h`, `grow_w`, `clip2top`, `clip2bottom`, `clip2left`, `clip2right`, `codec`, `codec_param`, `bitrate`, `a_sample_r`, `a_bitrate`, `two_pass`, `tc_param`) VALUES (1,1,'Good',2,1,16,16,0,0,2,0,0,0,0,0,32,32,8,8,'divx5',NULL,1618,NULL,NULL,0,NULL),(2,2,'Excellent',2,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,'divx5',NULL,0,NULL,NULL,1,NULL),(3,2,'Good',2,1,0,0,8,8,0,0,0,0,0,0,0,0,0,0,'divx5',NULL,1618,NULL,NULL,0,NULL),(4,2,'Medium',2,1,0,0,8,8,5,5,0,0,0,0,0,0,0,0,'divx5',NULL,1200,NULL,NULL,0,NULL),(5,3,'Good',2,1,0,0,0,0,0,0,0,0,2,0,80,80,8,8,'divx5',NULL,0,NULL,NULL,0,NULL),(6,4,'Excellent',2,1,0,0,0,0,0,0,0,0,2,0,0,0,0,0,'divx5',NULL,0,NULL,NULL,1,NULL),(7,4,'Good',2,1,0,0,8,8,0,2,0,0,0,0,0,0,0,0,'divx5',NULL,1618,NULL,NULL,0,NULL),(8,5,'Good',1,1,16,16,0,0,5,0,0,0,0,0,40,40,8,8,'divx5',NULL,1618,NULL,NULL,0,NULL),(9,6,'Good',1,1,0,0,16,16,5,0,0,0,0,0,0,0,0,0,'divx5',NULL,1618,NULL,NULL,0,NULL),(10,7,'Good',1,1,0,0,0,0,1,0,0,0,0,0,76,76,8,8,'divx5',NULL,1618,NULL,NULL,0,NULL),(11,8,'Good',1,1,0,0,0,0,1,0,0,0,0,0,0,0,0,0,'divx5',NULL,1618,NULL,NULL,0,NULL); +/*!40000 ALTER TABLE `dvdtranscode` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `eit_cache` +-- + +DROP TABLE IF EXISTS `eit_cache`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `eit_cache` ( + `chanid` int(10) NOT NULL, + `eventid` int(10) unsigned NOT NULL default '0', + `tableid` tinyint(3) unsigned NOT NULL, + `version` tinyint(3) unsigned NOT NULL, + `endtime` int(10) unsigned NOT NULL, + `status` tinyint(4) NOT NULL default '0', + PRIMARY KEY (`chanid`,`eventid`,`status`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Dumping data for table `eit_cache` +-- + +LOCK TABLES `eit_cache` WRITE; +/*!40000 ALTER TABLE `eit_cache` DISABLE KEYS */; +/*!40000 ALTER TABLE `eit_cache` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `favorites` +-- + +DROP TABLE IF EXISTS `favorites`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `favorites` ( + `favid` int(11) unsigned NOT NULL auto_increment, + `userid` int(11) unsigned NOT NULL default '0', + `chanid` int(11) unsigned NOT NULL default '0', + PRIMARY KEY (`favid`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Dumping data for table `favorites` +-- + +LOCK TABLES `favorites` WRITE; +/*!40000 ALTER TABLE `favorites` DISABLE KEYS */; +/*!40000 ALTER TABLE `favorites` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `filemarkup` +-- + +DROP TABLE IF EXISTS `filemarkup`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `filemarkup` ( + `filename` text NOT NULL, + `mark` mediumint(8) unsigned NOT NULL default '0', + `offset` bigint(20) unsigned default NULL, + `type` tinyint(4) NOT NULL default '0', + KEY `filename` (`filename`(255)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Dumping data for table `filemarkup` +-- + +LOCK TABLES `filemarkup` WRITE; +/*!40000 ALTER TABLE `filemarkup` DISABLE KEYS */; +/*!40000 ALTER TABLE `filemarkup` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `gallerymetadata` +-- + +DROP TABLE IF EXISTS `gallerymetadata`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `gallerymetadata` ( + `image` varchar(255) NOT NULL, + `angle` int(11) NOT NULL, + PRIMARY KEY (`image`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Dumping data for table `gallerymetadata` +-- + +LOCK TABLES `gallerymetadata` WRITE; +/*!40000 ALTER TABLE `gallerymetadata` DISABLE KEYS */; +/*!40000 ALTER TABLE `gallerymetadata` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `gamemetadata` +-- + +DROP TABLE IF EXISTS `gamemetadata`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `gamemetadata` ( + `system` varchar(128) NOT NULL default '', + `romname` varchar(128) NOT NULL default '', + `gamename` varchar(128) NOT NULL default '', + `genre` varchar(128) NOT NULL default '', + `year` varchar(10) NOT NULL default '', + `publisher` varchar(128) NOT NULL default '', + `favorite` tinyint(1) default NULL, + `rompath` varchar(255) NOT NULL default '', + `gametype` varchar(64) NOT NULL default '', + `diskcount` tinyint(1) NOT NULL default '1', + `country` varchar(128) NOT NULL default '', + `crc_value` varchar(64) NOT NULL default '', + `display` tinyint(1) NOT NULL default '1', + `version` varchar(64) NOT NULL default '', + KEY `system` (`system`), + KEY `year` (`year`), + KEY `romname` (`romname`), + KEY `gamename` (`gamename`), + KEY `genre` (`genre`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Dumping data for table `gamemetadata` +-- + +LOCK TABLES `gamemetadata` WRITE; +/*!40000 ALTER TABLE `gamemetadata` DISABLE KEYS */; +/*!40000 ALTER TABLE `gamemetadata` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `gameplayers` +-- + +DROP TABLE IF EXISTS `gameplayers`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `gameplayers` ( + `gameplayerid` int(10) unsigned NOT NULL auto_increment, + `playername` varchar(64) NOT NULL default '', + `workingpath` varchar(255) NOT NULL default '', + `rompath` varchar(255) NOT NULL default '', + `screenshots` varchar(255) NOT NULL default '', + `commandline` text NOT NULL, + `gametype` varchar(64) NOT NULL default '', + `extensions` varchar(128) NOT NULL default '', + `spandisks` tinyint(1) NOT NULL default '0', + PRIMARY KEY (`gameplayerid`), + UNIQUE KEY `playername` (`playername`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Dumping data for table `gameplayers` +-- + +LOCK TABLES `gameplayers` WRITE; +/*!40000 ALTER TABLE `gameplayers` DISABLE KEYS */; +/*!40000 ALTER TABLE `gameplayers` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `housekeeping` +-- + +DROP TABLE IF EXISTS `housekeeping`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `housekeeping` ( + `tag` varchar(64) NOT NULL default '', + `lastrun` datetime default NULL, + PRIMARY KEY (`tag`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Dumping data for table `housekeeping` +-- + +LOCK TABLES `housekeeping` WRITE; +/*!40000 ALTER TABLE `housekeeping` DISABLE KEYS */; +/*!40000 ALTER TABLE `housekeeping` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `inputgroup` +-- + +DROP TABLE IF EXISTS `inputgroup`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `inputgroup` ( + `cardinputid` int(10) unsigned NOT NULL, + `inputgroupid` int(10) unsigned NOT NULL, + `inputgroupname` varchar(32) NOT NULL +) ENGINE=MyISAM DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Dumping data for table `inputgroup` +-- + +LOCK TABLES `inputgroup` WRITE; +/*!40000 ALTER TABLE `inputgroup` DISABLE KEYS */; +/*!40000 ALTER TABLE `inputgroup` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `inuseprograms` +-- + +DROP TABLE IF EXISTS `inuseprograms`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `inuseprograms` ( + `chanid` int(10) unsigned NOT NULL default '0', + `starttime` datetime NOT NULL default '0000-00-00 00:00:00', + `recusage` varchar(128) NOT NULL default '', + `lastupdatetime` datetime NOT NULL default '0000-00-00 00:00:00', + `hostname` varchar(255) NOT NULL default '', + `rechost` varchar(64) NOT NULL, + `recdir` varchar(255) NOT NULL default '', + KEY `chanid` (`chanid`,`starttime`), + KEY `recusage` (`recusage`,`lastupdatetime`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Dumping data for table `inuseprograms` +-- + +LOCK TABLES `inuseprograms` WRITE; +/*!40000 ALTER TABLE `inuseprograms` DISABLE KEYS */; +/*!40000 ALTER TABLE `inuseprograms` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `jobqueue` +-- + +DROP TABLE IF EXISTS `jobqueue`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `jobqueue` ( + `id` int(11) NOT NULL auto_increment, + `chanid` int(10) NOT NULL default '0', + `starttime` datetime NOT NULL default '0000-00-00 00:00:00', + `inserttime` datetime NOT NULL default '0000-00-00 00:00:00', + `type` int(11) NOT NULL default '0', + `cmds` int(11) NOT NULL default '0', + `flags` int(11) NOT NULL default '0', + `status` int(11) NOT NULL default '0', + `statustime` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, + `hostname` varchar(255) NOT NULL default '', + `args` blob NOT NULL, + `comment` varchar(128) NOT NULL default '', + `schedruntime` datetime NOT NULL default '2007-01-01 00:00:00', + PRIMARY KEY (`id`), + UNIQUE KEY `chanid` (`chanid`,`starttime`,`type`,`inserttime`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Dumping data for table `jobqueue` +-- + +LOCK TABLES `jobqueue` WRITE; +/*!40000 ALTER TABLE `jobqueue` DISABLE KEYS */; +/*!40000 ALTER TABLE `jobqueue` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `jumppoints` +-- + +DROP TABLE IF EXISTS `jumppoints`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `jumppoints` ( + `destination` varchar(128) NOT NULL default '', + `description` varchar(255) default NULL, + `keylist` varchar(128) default NULL, + `hostname` varchar(255) NOT NULL default '', + PRIMARY KEY (`destination`,`hostname`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Dumping data for table `jumppoints` +-- + +LOCK TABLES `jumppoints` WRITE; +/*!40000 ALTER TABLE `jumppoints` DISABLE KEYS */; +INSERT INTO `jumppoints` (`destination`, `description`, `keylist`, `hostname`) VALUES ('Reload Theme','','','larch5'),('Main Menu','','','larch5'),('Program Guide','','','larch5'),('Program Finder','','','larch5'),('Manage Recordings / Fix Conflicts','','','larch5'),('Program Recording Priorities','','','larch5'),('Channel Recording Priorities','','','larch5'),('TV Recording Playback','','','larch5'),('TV Recording Deletion','','','larch5'),('Live TV','','','larch5'),('Live TV In Guide','','','larch5'),('Manual Record Scheduling','','','larch5'),('Status Screen','','','larch5'),('Previously Recorded','','','larch5'),('Netflix Browser','Browse Netflix titles','','larch5'),('Netflix Queue','Administer Netflix Queue','','larch5'),('Netflix History','View Netflix History','','larch5'),('MythGallery','Image viewer / slideshow','','larch5'),('MythGame','Game frontend','','larch5'),('Play music','','','larch5'),('Select music playlists','','','larch5'),('Rip CD','','','larch5'),('Scan music','','','larch5'),('Show Music Miniplayer','','','larch5'),('MythNews','RSS News feed reader','','larch5'),('MythVideo','The MythVideo default view','','larch5'),('Video Manager','The MythVideo video manager','','larch5'),('Video Browser','The MythVideo video browser','','larch5'),('Video Listings','The MythVideo video listings','','larch5'),('Video Gallery','The MythVideo video gallery','','larch5'),('Play DVD','Play a DVD','','larch5'),('Play VCD','Play a VCD','','larch5'),('Rip DVD','Import a DVD into your MythVideo database','','larch5'),('MythWeather','Weather forecasts','','larch5'); +/*!40000 ALTER TABLE `jumppoints` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `keybindings` +-- + +DROP TABLE IF EXISTS `keybindings`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `keybindings` ( + `context` varchar(32) NOT NULL default '', + `action` varchar(32) NOT NULL default '', + `description` varchar(255) default NULL, + `keylist` varchar(128) default NULL, + `hostname` varchar(255) NOT NULL default '', + PRIMARY KEY (`context`,`action`,`hostname`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Dumping data for table `keybindings` +-- + +LOCK TABLES `keybindings` WRITE; +/*!40000 ALTER TABLE `keybindings` DISABLE KEYS */; +INSERT INTO `keybindings` (`context`, `action`, `description`, `keylist`, `hostname`) VALUES ('Global','UP','Up Arrow','Up','larch5'),('Global','DOWN','Down Arrow','Down','larch5'),('Global','LEFT','Left Arrow','Left','larch5'),('Global','RIGHT','Right Arrow','Right','larch5'),('Global','SELECT','Select','Return,Enter,Space','larch5'),('Global','ESCAPE','Escape','Esc','larch5'),('Global','MENU','Pop-up menu','M','larch5'),('Global','INFO','More information','I','larch5'),('Global','PAGEUP','Page Up','PgUp','larch5'),('Global','PAGEDOWN','Page Down','PgDown','larch5'),('Global','PREVVIEW','Previous View','Home','larch5'),('Global','NEXTVIEW','Next View','End','larch5'),('Global','HELP','Help','F1','larch5'),('Global','EJECT','Eject Removable Media','','larch5'),('Global','0','0','0','larch5'),('Global','1','1','1','larch5'),('Global','2','2','2','larch5'),('Global','3','3','3','larch5'),('Global','4','4','4','larch5'),('Global','5','5','5','larch5'),('Global','6','6','6','larch5'),('Global','7','7','7','larch5'),('Global','8','8','8','larch5'),('Global','9','9','9','larch5'),('qt','DELETE','Delete','D','larch5'),('qt','EDIT','Edit','E','larch5'),('TV Frontend','PAGEUP','Page Up','3','larch5'),('TV Frontend','PAGEDOWN','Page Down','9','larch5'),('TV Frontend','PAGETOP','Page to top of list','','larch5'),('TV Frontend','PAGEMIDDLE','Page to middle of list','','larch5'),('TV Frontend','PAGEBOTTOM','Page to bottom of list','','larch5'),('TV Frontend','DELETE','Delete Program','D','larch5'),('TV Frontend','PLAYBACK','Play Program','P','larch5'),('TV Frontend','TOGGLERECORD','Toggle recording status of current program','R','larch5'),('TV Frontend','DAYLEFT','Page the program guide back one day','Home,7','larch5'),('TV Frontend','DAYRIGHT','Page the program guide forward one day','End,1','larch5'),('TV Frontend','PAGELEFT','Page the program guide left',',,<','larch5'),('TV Frontend','PAGERIGHT','Page the program guide right','>,.','larch5'),('TV Frontend','TOGGLEFAV','Toggle the current channel as a favorite','?','larch5'),('TV Frontend','TOGGLEEPGORDER','Reverse the channel order in the program guide','0','larch5'),('TV Frontend','GUIDE','Show the Program Guide','S','larch5'),('TV Frontend','FINDER','Show the Program Finder','#','larch5'),('TV Frontend','NEXTFAV','Toggle showing all channels or just favorites in the program guide.','/','larch5'),('TV Frontend','CHANUPDATE','Switch channels without exiting guide in Live TV mode.','X','larch5'),('TV Frontend','VOLUMEDOWN','Volume down','[,{,F10,Volume Down','larch5'),('TV Frontend','VOLUMEUP','Volume up','],},F11,Volume Up','larch5'),('TV Frontend','MUTE','Mute','|,\\,F9,Volume Mute','larch5'),('TV Frontend','RANKINC','Increase program or channel rank','Right','larch5'),('TV Frontend','RANKDEC','Decrease program or channel rank','Left','larch5'),('TV Frontend','UPCOMING','List upcoming episodes','O','larch5'),('TV Frontend','DETAILS','Show program details','U','larch5'),('TV Frontend','VIEWCARD','Switch Capture Card view','Y','larch5'),('TV Frontend','VIEWINPUT','Switch Capture Card view','C','larch5'),('TV Frontend','CUSTOMEDIT','Edit Custom Record Rule','E','larch5'),('TV Frontend','CHANGERECGROUP','Change Recording Group','','larch5'),('TV Frontend','CHANGEGROUPVIEW','Change Group View','','larch5'),('TV Playback','CLEAROSD','Clear OSD','Backspace','larch5'),('TV Playback','PAUSE','Pause','P','larch5'),('TV Playback','DELETE','Delete Program','D','larch5'),('TV Playback','SEEKFFWD','Fast Forward','Right','larch5'),('TV Playback','SEEKRWND','Rewind','Left','larch5'),('TV Playback','ARBSEEK','Arbitrary Seek','*','larch5'),('TV Playback','CHANNELUP','Channel up','Up','larch5'),('TV Playback','CHANNELDOWN','Channel down','Down','larch5'),('TV Playback','NEXTFAV','Switch to the next favorite channel','/','larch5'),('TV Playback','PREVCHAN','Switch to the previous channel','H','larch5'),('TV Playback','JUMPFFWD','Jump ahead','PgDown','larch5'),('TV Playback','JUMPRWND','Jump back','PgUp','larch5'),('TV Playback','JUMPBKMRK','Jump to bookmark','K','larch5'),('TV Playback','FFWDSTICKY','Fast Forward (Sticky) or Forward one frame while paused','>,.','larch5'),('TV Playback','RWNDSTICKY','Rewind (Sticky) or Rewind one frame while paused',',,<','larch5'),('TV Playback','NEXTSOURCE','Next Video Source','Y','larch5'),('TV Playback','PREVSOURCE','Previous Video Source','Ctrl+Y','larch5'),('TV Playback','NEXTINPUT','Next Input','C','larch5'),('TV Playback','NEXTCARD','Next Card','','larch5'),('TV Playback','SKIPCOMMERCIAL','Skip Commercial','Z,End','larch5'),('TV Playback','SKIPCOMMBACK','Skip Commercial (Reverse)','Q,Home','larch5'),('TV Playback','JUMPSTART','Jump to the start of the recording.','Ctrl+B','larch5'),('TV Playback','TOGGLEBROWSE','Toggle channel browse mode','O','larch5'),('TV Playback','TOGGLERECORD','Toggle recording status of current program','R','larch5'),('TV Playback','TOGGLEFAV','Toggle the current channel as a favorite','?','larch5'),('TV Playback','VOLUMEDOWN','Volume down','[,{,F10,Volume Down','larch5'),('TV Playback','VOLUMEUP','Volume up','],},F11,Volume Up','larch5'),('TV Playback','MUTE','Mute','|,\\,F9,Volume Mute','larch5'),('TV Playback','TOGGLEPIPMODE','Toggle Picture-in-Picture mode','V','larch5'),('TV Playback','TOGGLEPIPWINDOW','Toggle active PiP window','B','larch5'),('TV Playback','SWAPPIP','Swap PiP/Main','N','larch5'),('TV Playback','TOGGLEASPECT','Toggle the video aspect ratio','Ctrl+W','larch5'),('TV Playback','TOGGLEFILL','Next Preconfigured Zoom mode','W','larch5'),('TV Playback','TOGGLECC','Toggle any captions','T','larch5'),('TV Playback','TOGGLETTC','Toggle Teletext Captions','','larch5'),('TV Playback','TOGGLESUBTITLE','Toggle Subtitles','','larch5'),('TV Playback','TOGGLECC608','Toggle VBI CC','','larch5'),('TV Playback','TOGGLECC708','Toggle ATSC CC','','larch5'),('TV Playback','TOGGLETTM','Toggle Teletext Menu','','larch5'),('TV Playback','SELECTAUDIO_0','Play audio track 1','','larch5'),('TV Playback','SELECTAUDIO_1','Play audio track 2','','larch5'),('TV Playback','SELECTSUBTITLE_0','Display subtitle 1','','larch5'),('TV Playback','SELECTSUBTITLE_1','Display subtitle 2','','larch5'),('TV Playback','SELECTCC608_0','Display VBI CC1','','larch5'),('TV Playback','SELECTCC608_1','Display VBI CC2','','larch5'),('TV Playback','SELECTCC608_2','Display VBI CC3','','larch5'),('TV Playback','SELECTCC608_3','Display VBI CC4','','larch5'),('TV Playback','SELECTCC708_0','Display ATSC CC1','','larch5'),('TV Playback','SELECTCC708_1','Display ATSC CC2','','larch5'),('TV Playback','SELECTCC708_2','Display ATSC CC3','','larch5'),('TV Playback','SELECTCC708_3','Display ATSC CC4','','larch5'),('TV Playback','NEXTAUDIO','Next audio track','+','larch5'),('TV Playback','PREVAUDIO','Previous audio track','-','larch5'),('TV Playback','NEXTSUBTITLE','Next subtitle track','','larch5'),('TV Playback','PREVSUBTITLE','Previous subtitle track','','larch5'),('TV Playback','NEXTCC608','Next VBI CC track','','larch5'),('TV Playback','PREVCC608','Previous VBI CC track','','larch5'),('TV Playback','NEXTCC708','Next ATSC CC track','','larch5'),('TV Playback','PREVCC708','Previous ATSC CC track','','larch5'),('TV Playback','NEXTCC','Next of any captions','','larch5'),('TV Playback','NEXTSCAN','Next video scan overidemode','','larch5'),('TV Playback','QUEUETRANSCODE','Queue the current recording for transcoding','X','larch5'),('TV Playback','SPEEDINC','Increase the playback speed','U','larch5'),('TV Playback','SPEEDDEC','Decrease the playback speed','J','larch5'),('TV Playback','ADJUSTSTRETCH','Turn on time stretch control','A','larch5'),('TV Playback','STRETCHINC','Increase time stretch speed','','larch5'),('TV Playback','STRETCHDEC','Decrease time stretch speed','','larch5'),('TV Playback','TOGGLESTRETCH','Toggle time stretch speed','','larch5'),('TV Playback','TOGGLEAUDIOSYNC','Turn on audio sync adjustment controls','','larch5'),('TV Playback','TOGGLEPICCONTROLS','Playback picture adjustments','F','larch5'),('TV Playback','TOGGLECHANCONTROLS','Recording picture adjustments for this channel','Ctrl+G','larch5'),('TV Playback','TOGGLERECCONTROLS','Recording picture adjustments for this recorder','G','larch5'),('TV Playback','TOGGLEEDIT','Start Edit Mode','E','larch5'),('TV Playback','CYCLECOMMSKIPMODE','Cycle Commercial Skip mode','','larch5'),('TV Playback','GUIDE','Show the Program Guide','S','larch5'),('TV Playback','FINDER','Show the Program Finder','#','larch5'),('TV Playback','TOGGLESLEEP','Toggle the Sleep Timer','F8','larch5'),('TV Playback','PLAY','Play','Ctrl+P','larch5'),('TV Playback','JUMPPREV','Jump to previously played recording','','larch5'),('TV Playback','JUMPREC','Display menu of recorded programs to jump to','','larch5'),('TV Playback','VIEWSCHEDULED','Display scheduled recording list','','larch5'),('TV Playback','SIGNALMON','Monitor Signal Quality','Alt+F7','larch5'),('TV Playback','JUMPTODVDROOTMENU','Jump to the DVD Root Menu','','larch5'),('TV Playback','EXITSHOWNOPROMPTS','Exit Show without any prompts','','larch5'),('TV Playback','SCREENSHOT','Save screenshot of current video frame','','larch5'),('TV Playback','MENURED','Menu Red','F2','larch5'),('TV Playback','MENUGREEN','Menu Green','F3','larch5'),('TV Playback','MENUYELLOW','Menu Yellow','F4','larch5'),('TV Playback','MENUBLUE','Menu Blue','F5','larch5'),('TV Playback','TEXTEXIT','Menu Exit','F6','larch5'),('TV Playback','MENUTEXT','Menu Text','F7','larch5'),('TV Playback','MENUEPG','Menu EPG','F12','larch5'),('TV Editing','CLEARMAP','Clear editing cut points','C,Q,Home','larch5'),('TV Editing','INVERTMAP','Invert Begin/End cut points','I','larch5'),('TV Editing','LOADCOMMSKIP','Load cut list from commercial skips','Z,End','larch5'),('TV Editing','NEXTCUT','Jump to the next cut point','PgDown','larch5'),('TV Editing','PREVCUT','Jump to the previous cut point','PgUp','larch5'),('TV Editing','BIGJUMPREW','Jump back 10x the normal amount',',,<','larch5'),('TV Editing','BIGJUMPFWD','Jump forward 10x the normal amount','>,.','larch5'),('TV Editing','TOGGLEEDIT','Exit out of Edit Mode','E','larch5'),('Teletext Menu','NEXTPAGE','Next Page','Down','larch5'),('Teletext Menu','PREVPAGE','Previous Page','Up','larch5'),('Teletext Menu','NEXTSUBPAGE','Next Subpage','Right','larch5'),('Teletext Menu','PREVSUBPAGE','Previous Subpage','Left','larch5'),('Teletext Menu','TOGGLETT','Toggle Teletext','T','larch5'),('Teletext Menu','MENURED','Menu Red','F2','larch5'),('Teletext Menu','MENUGREEN','Menu Green','F3','larch5'),('Teletext Menu','MENUYELLOW','Menu Yellow','F4','larch5'),('Teletext Menu','MENUBLUE','Menu Blue','F5','larch5'),('Teletext Menu','MENUWHITE','Menu White','F6','larch5'),('Teletext Menu','TOGGLEBACKGROUND','Toggle Background','F7','larch5'),('Teletext Menu','REVEAL','Reveal hidden Text','F8','larch5'),('Archive','TOGGLECUT','Toggle use cut list state for selected program','C','larch5'),('NetFlix','MOVETOTOP','Moves movie to top of queue','1','larch5'),('NetFlix','REMOVE','Removes movie from queue','D','larch5'),('Gallery','PLAY','Start/Stop Slideshow','P','larch5'),('Gallery','HOME','Go to the first image in thumbnail view','Home','larch5'),('Gallery','END','Go to the last image in thumbnail view','End','larch5'),('Gallery','MENU','Toggle activating menu in thumbnail view','M','larch5'),('Gallery','SLIDESHOW','Start Slideshow in thumbnail view','S','larch5'),('Gallery','RANDOMSHOW','Start Random Slideshow in thumbnail view','R','larch5'),('Gallery','ROTRIGHT','Rotate image right 90 degrees','],3','larch5'),('Gallery','ROTLEFT','Rotate image left 90 degrees','[,1','larch5'),('Gallery','ZOOMOUT','Zoom image out','7','larch5'),('Gallery','ZOOMIN','Zoom image in','9','larch5'),('Gallery','SCROLLUP','Scroll image up','2','larch5'),('Gallery','SCROLLLEFT','Scroll image left','4','larch5'),('Gallery','SCROLLRIGHT','Scroll image right','6','larch5'),('Gallery','SCROLLDOWN','Scroll image down','8','larch5'),('Gallery','RECENTER','Recenter image','5','larch5'),('Gallery','FULLSIZE','Full-size (un-zoom) image','0','larch5'),('Gallery','UPLEFT','Go to the upper-left corner of the image','PgUp','larch5'),('Gallery','LOWRIGHT','Go to the lower-right corner of the image','PgDown','larch5'),('Gallery','INFO','Toggle Showing Information about Image','I','larch5'),('Gallery','DELETE','Delete marked images or current image if none are marked','D','larch5'),('Gallery','MARK','Mark image','T','larch5'),('Gallery','FULLSCREEN','Toggle scale to fullscreen/scale to fit','W','larch5'),('Game','TOGGLEFAV','Toggle the current game as a favorite','?,/','larch5'),('Game','INCSEARCH','Show incremental search dialog','Ctrl+S','larch5'),('Game','INCSEARCHNEXT','Incremental search find next match','Ctrl+N','larch5'),('Music','DELETE','Delete track from playlist','D','larch5'),('Music','NEXTTRACK','Move to the next track','>,.,Z,End','larch5'),('Music','PREVTRACK','Move to the previous track',',,<,Q,Home','larch5'),('Music','FFWD','Fast forward','PgDown','larch5'),('Music','RWND','Rewind','PgUp','larch5'),('Music','PAUSE','Pause/Start playback','P','larch5'),('Music','PLAY','Start playback','','larch5'),('Music','STOP','Stop playback','O','larch5'),('Music','VOLUMEDOWN','Volume down','[,{,F10,Volume Down','larch5'),('Music','VOLUMEUP','Volume up','],},F11,Volume Up','larch5'),('Music','MUTE','Mute','|,\\,F9,Volume Mute','larch5'),('Music','CYCLEVIS','Cycle visualizer mode','6','larch5'),('Music','BLANKSCR','Blank screen','5','larch5'),('Music','THMBUP','Increase rating','9','larch5'),('Music','THMBDOWN','Decrease rating','7','larch5'),('Music','REFRESH','Refresh music tree','8','larch5'),('Music','FILTER','Filter All My Music','F','larch5'),('Music','INCSEARCH','Show incremental search dialog','Ctrl+S','larch5'),('Music','INCSEARCHNEXT','Incremental search find next match','Ctrl+N','larch5'),('Music','SPEEDUP','Increase Play Speed','W','larch5'),('Music','SPEEDDOWN','Decrease Play Speed','X','larch5'),('News','RETRIEVENEWS','Update news items','I','larch5'),('News','FORCERETRIEVE','Force update news items','M','larch5'),('News','CANCEL','Cancel news item updating','C','larch5'),('Phone','0','0','0','larch5'),('Phone','1','1','1','larch5'),('Phone','2','2','2','larch5'),('Phone','3','3','3','larch5'),('Phone','4','4','4','larch5'),('Phone','5','5','5','larch5'),('Phone','6','6','6','larch5'),('Phone','7','7','7','larch5'),('Phone','8','8','8','larch5'),('Phone','9','9','9','larch5'),('Phone','HASH','HASH','#','larch5'),('Phone','STAR','STAR','*','larch5'),('Phone','Up','Up','Up','larch5'),('Phone','Down','Down','Down','larch5'),('Phone','Left','Left','Left','larch5'),('Phone','Right','Right','Right','larch5'),('Phone','VOLUMEDOWN','Volume down','[,{,F10,Volume Down','larch5'),('Phone','VOLUMEUP','Volume up','],},F11,Volume Up','larch5'),('Phone','MUTE','Mute','|,\\,F9,Volume Mute','larch5'),('Phone','ZOOMIN','Zoom the video window in','>,.,Z,End','larch5'),('Phone','ZOOMOUT','Zoom the video window out',',,<,Q,Home','larch5'),('Phone','FULLSCRN','Show received video full-screen','P','larch5'),('Phone','HANGUP','Hangup an active call','O','larch5'),('Phone','LOOPBACK','Loopback Video','L','larch5'),('Video','FILTER','Open video filter dialog','F','larch5'),('Video','DELETE','Delete video','D','larch5'),('Video','BROWSE','Change browsable in video manager','B','larch5'),('Video','INCPARENT','Increase Parental Level','],},F11','larch5'),('Video','DECPARENT','Decrease Parental Level','[,{,F10','larch5'),('Video','HOME','Go to the first video','Home','larch5'),('Video','END','Go to the last video','End','larch5'),('Weather','PAUSE','Pause current page','P','larch5'),('Weather','SEARCH','Search List','/','larch5'),('Weather','NEXTSEARCH','Search List','n','larch5'),('Weather','UPDATE','Search List','u','larch5'),('Weather','DELETE','Delete screen from list','D','larch5'); +/*!40000 ALTER TABLE `keybindings` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `keyword` +-- + +DROP TABLE IF EXISTS `keyword`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `keyword` ( + `phrase` varchar(128) NOT NULL default '', + `searchtype` int(10) unsigned NOT NULL default '3', + UNIQUE KEY `phrase` (`phrase`,`searchtype`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Dumping data for table `keyword` +-- + +LOCK TABLES `keyword` WRITE; +/*!40000 ALTER TABLE `keyword` DISABLE KEYS */; +/*!40000 ALTER TABLE `keyword` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `music_albumart` +-- + +DROP TABLE IF EXISTS `music_albumart`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `music_albumart` ( + `albumart_id` int(20) NOT NULL auto_increment, + `filename` varchar(255) NOT NULL default '', + `directory_id` int(20) NOT NULL default '0', + `imagetype` tinyint(3) NOT NULL default '0', + `song_id` int(11) NOT NULL default '0', + `embedded` tinyint(1) NOT NULL default '0', + PRIMARY KEY (`albumart_id`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Dumping data for table `music_albumart` +-- + +LOCK TABLES `music_albumart` WRITE; +/*!40000 ALTER TABLE `music_albumart` DISABLE KEYS */; +/*!40000 ALTER TABLE `music_albumart` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `music_albums` +-- + +DROP TABLE IF EXISTS `music_albums`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `music_albums` ( + `album_id` int(11) unsigned NOT NULL auto_increment, + `artist_id` int(11) unsigned NOT NULL default '0', + `album_name` varchar(255) NOT NULL default '', + `year` smallint(6) NOT NULL default '0', + `compilation` tinyint(1) unsigned NOT NULL default '0', + PRIMARY KEY (`album_id`), + KEY `idx_album_name` (`album_name`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Dumping data for table `music_albums` +-- + +LOCK TABLES `music_albums` WRITE; +/*!40000 ALTER TABLE `music_albums` DISABLE KEYS */; +/*!40000 ALTER TABLE `music_albums` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `music_artists` +-- + +DROP TABLE IF EXISTS `music_artists`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `music_artists` ( + `artist_id` int(11) unsigned NOT NULL auto_increment, + `artist_name` varchar(255) NOT NULL default '', + PRIMARY KEY (`artist_id`), + KEY `idx_artist_name` (`artist_name`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Dumping data for table `music_artists` +-- + +LOCK TABLES `music_artists` WRITE; +/*!40000 ALTER TABLE `music_artists` DISABLE KEYS */; +/*!40000 ALTER TABLE `music_artists` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `music_directories` +-- + +DROP TABLE IF EXISTS `music_directories`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `music_directories` ( + `directory_id` int(20) NOT NULL auto_increment, + `path` text NOT NULL, + `parent_id` int(20) NOT NULL default '0', + PRIMARY KEY (`directory_id`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Dumping data for table `music_directories` +-- + +LOCK TABLES `music_directories` WRITE; +/*!40000 ALTER TABLE `music_directories` DISABLE KEYS */; +/*!40000 ALTER TABLE `music_directories` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `music_genres` +-- + +DROP TABLE IF EXISTS `music_genres`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `music_genres` ( + `genre_id` int(11) unsigned NOT NULL auto_increment, + `genre` varchar(255) NOT NULL default '', + PRIMARY KEY (`genre_id`), + KEY `idx_genre` (`genre`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Dumping data for table `music_genres` +-- + +LOCK TABLES `music_genres` WRITE; +/*!40000 ALTER TABLE `music_genres` DISABLE KEYS */; +/*!40000 ALTER TABLE `music_genres` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `music_playlists` +-- + +DROP TABLE IF EXISTS `music_playlists`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `music_playlists` ( + `playlist_id` int(11) unsigned NOT NULL auto_increment, + `playlist_name` varchar(255) NOT NULL default '', + `playlist_songs` text NOT NULL, + `last_accessed` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, + `length` int(11) unsigned NOT NULL default '0', + `songcount` smallint(8) unsigned NOT NULL default '0', + `hostname` varchar(255) NOT NULL default '', + PRIMARY KEY (`playlist_id`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Dumping data for table `music_playlists` +-- + +LOCK TABLES `music_playlists` WRITE; +/*!40000 ALTER TABLE `music_playlists` DISABLE KEYS */; +/*!40000 ALTER TABLE `music_playlists` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `music_smartplaylist_categories` +-- + +DROP TABLE IF EXISTS `music_smartplaylist_categories`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `music_smartplaylist_categories` ( + `categoryid` int(10) unsigned NOT NULL auto_increment, + `name` varchar(128) NOT NULL, + PRIMARY KEY (`categoryid`), + KEY `name` (`name`) +) ENGINE=MyISAM AUTO_INCREMENT=4 DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Dumping data for table `music_smartplaylist_categories` +-- + +LOCK TABLES `music_smartplaylist_categories` WRITE; +/*!40000 ALTER TABLE `music_smartplaylist_categories` DISABLE KEYS */; +INSERT INTO `music_smartplaylist_categories` (`categoryid`, `name`) VALUES (1,'Decades'),(2,'Favourite Tracks'),(3,'New Tracks'); +/*!40000 ALTER TABLE `music_smartplaylist_categories` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `music_smartplaylist_items` +-- + +DROP TABLE IF EXISTS `music_smartplaylist_items`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `music_smartplaylist_items` ( + `smartplaylistitemid` int(10) unsigned NOT NULL auto_increment, + `smartplaylistid` int(10) unsigned NOT NULL, + `field` varchar(50) NOT NULL, + `operator` varchar(20) NOT NULL, + `value1` varchar(255) NOT NULL, + `value2` varchar(255) NOT NULL, + PRIMARY KEY (`smartplaylistitemid`), + KEY `smartplaylistid` (`smartplaylistid`) +) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Dumping data for table `music_smartplaylist_items` +-- + +LOCK TABLES `music_smartplaylist_items` WRITE; +/*!40000 ALTER TABLE `music_smartplaylist_items` DISABLE KEYS */; +INSERT INTO `music_smartplaylist_items` (`smartplaylistitemid`, `smartplaylistid`, `field`, `operator`, `value1`, `value2`) VALUES (1,1,'Year','is between','1960','1969'),(2,2,'Year','is between','1970','1979'),(3,3,'Year','is between','1980','1989'),(4,4,'Year','is between','1990','1999'),(5,5,'Year','is between','2000','2009'),(6,6,'Rating','is greater than','7','0'),(7,7,'Play Count','is greater than','0','0'),(8,8,'Play Count','is equal to','0','0'); +/*!40000 ALTER TABLE `music_smartplaylist_items` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `music_smartplaylists` +-- + +DROP TABLE IF EXISTS `music_smartplaylists`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `music_smartplaylists` ( + `smartplaylistid` int(10) unsigned NOT NULL auto_increment, + `name` varchar(128) NOT NULL, + `categoryid` int(10) unsigned NOT NULL, + `matchtype` set('All','Any') NOT NULL default 'All', + `orderby` varchar(128) NOT NULL default '', + `limitto` int(10) unsigned NOT NULL default '0', + PRIMARY KEY (`smartplaylistid`), + KEY `name` (`name`), + KEY `categoryid` (`categoryid`) +) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Dumping data for table `music_smartplaylists` +-- + +LOCK TABLES `music_smartplaylists` WRITE; +/*!40000 ALTER TABLE `music_smartplaylists` DISABLE KEYS */; +INSERT INTO `music_smartplaylists` (`smartplaylistid`, `name`, `categoryid`, `matchtype`, `orderby`, `limitto`) VALUES (1,'1960\'s',1,'All','Artist (A)',0),(2,'1970\'s',1,'All','Artist (A)',0),(3,'1980\'s',1,'All','Artist (A)',0),(4,'1990\'s',1,'All','Artist (A)',0),(5,'2000\'s',1,'All','Artist (A)',0),(6,'Favorite Tracks',2,'All','Artist (A), Album (A)',0),(7,'100 Most Played Tracks',2,'All','Play Count (D)',100),(8,'Never Played Tracks',3,'All','Artist (A), Album (A)',0); +/*!40000 ALTER TABLE `music_smartplaylists` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `music_songs` +-- + +DROP TABLE IF EXISTS `music_songs`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `music_songs` ( + `song_id` int(11) unsigned NOT NULL auto_increment, + `filename` text NOT NULL, + `name` varchar(255) NOT NULL default '', + `track` smallint(6) unsigned NOT NULL default '0', + `artist_id` int(11) unsigned NOT NULL default '0', + `album_id` int(11) unsigned NOT NULL default '0', + `genre_id` int(11) unsigned NOT NULL default '0', + `year` smallint(6) NOT NULL default '0', + `length` int(11) unsigned NOT NULL default '0', + `numplays` int(11) unsigned NOT NULL default '0', + `rating` tinyint(4) unsigned NOT NULL default '0', + `lastplay` datetime default NULL, + `date_entered` datetime default NULL, + `date_modified` datetime default NULL, + `format` varchar(4) NOT NULL default '0', + `mythdigest` varchar(255) default NULL, + `size` bigint(20) unsigned default NULL, + `description` varchar(255) default NULL, + `comment` varchar(255) default NULL, + `disc_count` smallint(5) unsigned default '0', + `disc_number` smallint(5) unsigned default '0', + `track_count` smallint(5) unsigned default '0', + `start_time` int(10) unsigned default '0', + `stop_time` int(10) unsigned default NULL, + `eq_preset` varchar(255) default NULL, + `relative_volume` tinyint(4) default '0', + `sample_rate` int(10) unsigned default '0', + `bitrate` int(10) unsigned default '0', + `bpm` smallint(5) unsigned default NULL, + `directory_id` int(20) NOT NULL default '0', + PRIMARY KEY (`song_id`), + KEY `idx_name` (`name`), + KEY `idx_mythdigest` (`mythdigest`), + KEY `directory_id` (`directory_id`), + KEY `album_id` (`album_id`), + KEY `genre_id` (`genre_id`), + KEY `artist_id` (`artist_id`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Dumping data for table `music_songs` +-- + +LOCK TABLES `music_songs` WRITE; +/*!40000 ALTER TABLE `music_songs` DISABLE KEYS */; +/*!40000 ALTER TABLE `music_songs` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `music_stats` +-- + +DROP TABLE IF EXISTS `music_stats`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `music_stats` ( + `num_artists` smallint(5) unsigned NOT NULL default '0', + `num_albums` smallint(5) unsigned NOT NULL default '0', + `num_songs` mediumint(8) unsigned NOT NULL default '0', + `num_genres` tinyint(3) unsigned NOT NULL default '0', + `total_time` varchar(12) NOT NULL default '0', + `total_size` varchar(10) NOT NULL default '0' +) ENGINE=MyISAM DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Dumping data for table `music_stats` +-- + +LOCK TABLES `music_stats` WRITE; +/*!40000 ALTER TABLE `music_stats` DISABLE KEYS */; +/*!40000 ALTER TABLE `music_stats` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `musicmetadata` +-- + +DROP TABLE IF EXISTS `musicmetadata`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `musicmetadata` ( + `intid` int(10) unsigned NOT NULL auto_increment, + `artist` varchar(128) NOT NULL, + `compilation_artist` varchar(128) NOT NULL, + `album` varchar(128) NOT NULL, + `title` varchar(128) NOT NULL, + `genre` varchar(128) NOT NULL, + `year` int(10) unsigned NOT NULL, + `tracknum` int(10) unsigned NOT NULL, + `length` int(10) unsigned NOT NULL, + `filename` text NOT NULL, + `rating` int(10) unsigned NOT NULL default '5', + `lastplay` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, + `playcount` int(10) unsigned NOT NULL default '0', + `mythdigest` varchar(255) default NULL, + `size` bigint(20) unsigned default NULL, + `date_added` datetime default NULL, + `date_modified` datetime default NULL, + `format` varchar(4) default NULL, + `description` varchar(255) default NULL, + `comment` varchar(255) default NULL, + `compilation` tinyint(4) default '0', + `composer` varchar(255) default NULL, + `disc_count` smallint(5) unsigned default '0', + `disc_number` smallint(5) unsigned default '0', + `track_count` smallint(5) unsigned default '0', + `start_time` int(10) unsigned default '0', + `stop_time` int(10) unsigned default NULL, + `eq_preset` varchar(255) default NULL, + `relative_volume` tinyint(4) default '0', + `sample_rate` int(10) unsigned default NULL, + `bpm` smallint(5) unsigned default NULL, + PRIMARY KEY (`intid`), + KEY `artist` (`artist`), + KEY `album` (`album`), + KEY `title` (`title`), + KEY `genre` (`genre`), + KEY `mythdigest` (`mythdigest`), + KEY `compilation_artist` (`compilation_artist`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Dumping data for table `musicmetadata` +-- + +LOCK TABLES `musicmetadata` WRITE; +/*!40000 ALTER TABLE `musicmetadata` DISABLE KEYS */; +/*!40000 ALTER TABLE `musicmetadata` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `musicplaylist` +-- + +DROP TABLE IF EXISTS `musicplaylist`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `musicplaylist` ( + `playlistid` int(10) unsigned NOT NULL auto_increment, + `name` varchar(128) NOT NULL, + `hostname` varchar(255) default NULL, + `songlist` text NOT NULL, + PRIMARY KEY (`playlistid`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Dumping data for table `musicplaylist` +-- + +LOCK TABLES `musicplaylist` WRITE; +/*!40000 ALTER TABLE `musicplaylist` DISABLE KEYS */; +/*!40000 ALTER TABLE `musicplaylist` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `mythlog` +-- + +DROP TABLE IF EXISTS `mythlog`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `mythlog` ( + `logid` int(10) unsigned NOT NULL auto_increment, + `module` varchar(32) NOT NULL default '', + `priority` int(11) NOT NULL default '0', + `acknowledged` tinyint(1) default '0', + `logdate` datetime default NULL, + `host` varchar(128) default NULL, + `message` varchar(255) NOT NULL default '', + `details` text, + PRIMARY KEY (`logid`), + KEY `module` (`module`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Dumping data for table `mythlog` +-- + +LOCK TABLES `mythlog` WRITE; +/*!40000 ALTER TABLE `mythlog` DISABLE KEYS */; +/*!40000 ALTER TABLE `mythlog` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `netflix` +-- + +DROP TABLE IF EXISTS `netflix`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `netflix` ( + `name` varchar(100) NOT NULL, + `category` varchar(255) NOT NULL, + `url` varchar(255) NOT NULL, + `ico` varchar(255) default NULL, + `updated` int(10) unsigned default NULL, + `is_queue` int(10) unsigned default NULL, + `queue` varchar(32) NOT NULL default '', + PRIMARY KEY (`name`,`queue`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Dumping data for table `netflix` +-- + +LOCK TABLES `netflix` WRITE; +/*!40000 ALTER TABLE `netflix` DISABLE KEYS */; +/*!40000 ALTER TABLE `netflix` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `networkiconmap` +-- + +DROP TABLE IF EXISTS `networkiconmap`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `networkiconmap` ( + `id` int(11) NOT NULL auto_increment, + `network` varchar(20) NOT NULL default '', + `url` varchar(255) NOT NULL default '', + PRIMARY KEY (`id`), + UNIQUE KEY `network` (`network`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Dumping data for table `networkiconmap` +-- + +LOCK TABLES `networkiconmap` WRITE; +/*!40000 ALTER TABLE `networkiconmap` DISABLE KEYS */; +/*!40000 ALTER TABLE `networkiconmap` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `oldfind` +-- + +DROP TABLE IF EXISTS `oldfind`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `oldfind` ( + `recordid` int(11) NOT NULL default '0', + `findid` int(11) NOT NULL default '0', + PRIMARY KEY (`recordid`,`findid`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Dumping data for table `oldfind` +-- + +LOCK TABLES `oldfind` WRITE; +/*!40000 ALTER TABLE `oldfind` DISABLE KEYS */; +/*!40000 ALTER TABLE `oldfind` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `oldprogram` +-- + +DROP TABLE IF EXISTS `oldprogram`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `oldprogram` ( + `oldtitle` varchar(128) NOT NULL default '', + `airdate` datetime NOT NULL default '0000-00-00 00:00:00', + PRIMARY KEY (`oldtitle`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Dumping data for table `oldprogram` +-- + +LOCK TABLES `oldprogram` WRITE; +/*!40000 ALTER TABLE `oldprogram` DISABLE KEYS */; +/*!40000 ALTER TABLE `oldprogram` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `oldrecorded` +-- + +DROP TABLE IF EXISTS `oldrecorded`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `oldrecorded` ( + `chanid` int(10) unsigned NOT NULL default '0', + `starttime` datetime NOT NULL default '0000-00-00 00:00:00', + `endtime` datetime NOT NULL default '0000-00-00 00:00:00', + `title` varchar(128) NOT NULL default '', + `subtitle` varchar(128) NOT NULL default '', + `description` text NOT NULL, + `category` varchar(64) NOT NULL default '', + `seriesid` varchar(40) NOT NULL default '', + `programid` varchar(40) NOT NULL default '', + `findid` int(11) NOT NULL default '0', + `recordid` int(11) NOT NULL default '0', + `station` varchar(20) NOT NULL default '', + `rectype` int(10) unsigned NOT NULL default '0', + `duplicate` tinyint(1) NOT NULL default '0', + `recstatus` int(11) NOT NULL default '0', + `reactivate` smallint(6) NOT NULL default '0', + `generic` tinyint(1) default '0', + PRIMARY KEY (`station`,`starttime`,`title`), + KEY `endtime` (`endtime`), + KEY `title` (`title`), + KEY `seriesid` (`seriesid`), + KEY `programid` (`programid`), + KEY `recordid` (`recordid`), + KEY `recstatus` (`recstatus`,`programid`,`seriesid`), + KEY `recstatus_2` (`recstatus`,`title`,`subtitle`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Dumping data for table `oldrecorded` +-- + +LOCK TABLES `oldrecorded` WRITE; +/*!40000 ALTER TABLE `oldrecorded` DISABLE KEYS */; +/*!40000 ALTER TABLE `oldrecorded` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `people` +-- + +DROP TABLE IF EXISTS `people`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `people` ( + `person` mediumint(8) unsigned NOT NULL auto_increment, + `name` char(128) NOT NULL default '', + PRIMARY KEY (`person`), + UNIQUE KEY `name` (`name`(41)) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Dumping data for table `people` +-- + +LOCK TABLES `people` WRITE; +/*!40000 ALTER TABLE `people` DISABLE KEYS */; +/*!40000 ALTER TABLE `people` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `phonecallhistory` +-- + +DROP TABLE IF EXISTS `phonecallhistory`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `phonecallhistory` ( + `recid` int(10) unsigned NOT NULL auto_increment, + `displayname` text NOT NULL, + `url` text NOT NULL, + `timestamp` text NOT NULL, + `duration` int(10) unsigned NOT NULL, + `directionin` int(10) unsigned NOT NULL, + `directoryref` int(10) unsigned default NULL, + PRIMARY KEY (`recid`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Dumping data for table `phonecallhistory` +-- + +LOCK TABLES `phonecallhistory` WRITE; +/*!40000 ALTER TABLE `phonecallhistory` DISABLE KEYS */; +/*!40000 ALTER TABLE `phonecallhistory` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `phonedirectory` +-- + +DROP TABLE IF EXISTS `phonedirectory`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `phonedirectory` ( + `intid` int(10) unsigned NOT NULL auto_increment, + `nickname` text NOT NULL, + `firstname` text, + `surname` text, + `url` text NOT NULL, + `directory` text NOT NULL, + `photofile` text, + `speeddial` int(10) unsigned NOT NULL, + `onhomelan` int(10) unsigned default '0', + PRIMARY KEY (`intid`) +) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Dumping data for table `phonedirectory` +-- + +LOCK TABLES `phonedirectory` WRITE; +/*!40000 ALTER TABLE `phonedirectory` DISABLE KEYS */; +INSERT INTO `phonedirectory` (`intid`, `nickname`, `firstname`, `surname`, `url`, `directory`, `photofile`, `speeddial`, `onhomelan`) VALUES (1,'Me(larch5)','Local Myth Host','larch5','','My MythTVs','',1,1); +/*!40000 ALTER TABLE `phonedirectory` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `pidcache` +-- + +DROP TABLE IF EXISTS `pidcache`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `pidcache` ( + `chanid` smallint(6) NOT NULL default '0', + `pid` int(11) NOT NULL default '-1', + `tableid` int(11) NOT NULL default '-1', + KEY `chanid` (`chanid`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Dumping data for table `pidcache` +-- + +LOCK TABLES `pidcache` WRITE; +/*!40000 ALTER TABLE `pidcache` DISABLE KEYS */; +/*!40000 ALTER TABLE `pidcache` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `playgroup` +-- + +DROP TABLE IF EXISTS `playgroup`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `playgroup` ( + `name` varchar(32) NOT NULL default '', + `titlematch` varchar(255) NOT NULL default '', + `skipahead` int(11) NOT NULL default '0', + `skipback` int(11) NOT NULL default '0', + `timestretch` int(11) NOT NULL default '0', + `jump` int(11) NOT NULL default '0', + PRIMARY KEY (`name`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Dumping data for table `playgroup` +-- + +LOCK TABLES `playgroup` WRITE; +/*!40000 ALTER TABLE `playgroup` DISABLE KEYS */; +INSERT INTO `playgroup` (`name`, `titlematch`, `skipahead`, `skipback`, `timestretch`, `jump`) VALUES ('Default','',30,5,100,0); +/*!40000 ALTER TABLE `playgroup` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `powerpriority` +-- + +DROP TABLE IF EXISTS `powerpriority`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `powerpriority` ( + `priorityname` varchar(64) NOT NULL, + `recpriority` int(10) NOT NULL default '0', + `selectclause` text NOT NULL, + PRIMARY KEY (`priorityname`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Dumping data for table `powerpriority` +-- + +LOCK TABLES `powerpriority` WRITE; +/*!40000 ALTER TABLE `powerpriority` DISABLE KEYS */; +/*!40000 ALTER TABLE `powerpriority` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `profilegroups` +-- + +DROP TABLE IF EXISTS `profilegroups`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `profilegroups` ( + `id` int(10) unsigned NOT NULL auto_increment, + `name` varchar(128) default NULL, + `cardtype` varchar(32) NOT NULL default 'V4L', + `is_default` int(1) default '0', + `hostname` varchar(255) default NULL, + PRIMARY KEY (`id`), + UNIQUE KEY `name` (`name`,`hostname`), + KEY `cardtype` (`cardtype`) +) ENGINE=MyISAM AUTO_INCREMENT=13 DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Dumping data for table `profilegroups` +-- + +LOCK TABLES `profilegroups` WRITE; +/*!40000 ALTER TABLE `profilegroups` DISABLE KEYS */; +INSERT INTO `profilegroups` (`id`, `name`, `cardtype`, `is_default`, `hostname`) VALUES (1,'Software Encoders (v4l based)','V4L',1,NULL),(2,'MPEG-2 Encoders (PVR-x50, PVR-500)','MPEG',1,NULL),(3,'Hardware MJPEG Encoders (Matrox G200-TV, Miro DC10, etc)','MJPEG',1,NULL),(4,'Hardware HDTV','HDTV',1,NULL),(5,'Hardware DVB Encoders','DVB',1,NULL),(6,'Transcoders','TRANSCODE',1,NULL),(7,'FireWire Input','FIREWIRE',1,NULL),(8,'USB Mpeg-4 Encoder (Plextor ConvertX, etc)','GO7007',1,NULL),(9,'DBOX2 Input','DBOX2',1,NULL),(10,'Freebox Input','Freebox',1,NULL),(11,'HDHomeRun Recorders','HDHOMERUN',1,NULL),(12,'CRC IP Recorders','CRC_IP',1,NULL); +/*!40000 ALTER TABLE `profilegroups` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `program` +-- + +DROP TABLE IF EXISTS `program`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `program` ( + `chanid` int(10) unsigned NOT NULL default '0', + `starttime` datetime NOT NULL default '0000-00-00 00:00:00', + `endtime` datetime NOT NULL default '0000-00-00 00:00:00', + `title` varchar(128) NOT NULL default '', + `subtitle` varchar(128) NOT NULL default '', + `description` text NOT NULL, + `category` varchar(64) NOT NULL default '', + `category_type` varchar(64) NOT NULL default '', + `airdate` year(4) NOT NULL default '0000', + `stars` float NOT NULL default '0', + `previouslyshown` tinyint(4) NOT NULL default '0', + `title_pronounce` varchar(128) NOT NULL default '', + `stereo` tinyint(1) NOT NULL default '0', + `subtitled` tinyint(1) NOT NULL default '0', + `hdtv` tinyint(1) NOT NULL default '0', + `closecaptioned` tinyint(1) NOT NULL default '0', + `partnumber` int(11) NOT NULL default '0', + `parttotal` int(11) NOT NULL default '0', + `seriesid` varchar(40) NOT NULL default '', + `originalairdate` date default NULL, + `showtype` varchar(30) NOT NULL default '', + `colorcode` varchar(20) NOT NULL default '', + `syndicatedepisodenumber` varchar(20) NOT NULL default '', + `programid` varchar(40) NOT NULL default '', + `manualid` int(10) unsigned NOT NULL default '0', + `generic` tinyint(1) default '0', + `listingsource` int(11) NOT NULL default '0', + `first` tinyint(1) NOT NULL default '0', + `last` tinyint(1) NOT NULL default '0', + `audioprop` set('STEREO','MONO','SURROUND','DOLBY','HARDHEAR','VISUALIMPAIR') NOT NULL, + `subtitletypes` set('HARDHEAR','NORMAL','ONSCREEN','SIGNED') NOT NULL, + `videoprop` set('HDTV','WIDESCREEN','AVC') NOT NULL, + PRIMARY KEY (`chanid`,`starttime`,`manualid`), + KEY `endtime` (`endtime`), + KEY `title` (`title`), + KEY `title_pronounce` (`title_pronounce`), + KEY `seriesid` (`seriesid`), + KEY `id_start_end` (`chanid`,`starttime`,`endtime`), + KEY `program_manualid` (`manualid`), + KEY `previouslyshown` (`previouslyshown`), + KEY `programid` (`programid`,`starttime`), + KEY `starttime` (`starttime`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Dumping data for table `program` +-- + +LOCK TABLES `program` WRITE; +/*!40000 ALTER TABLE `program` DISABLE KEYS */; +/*!40000 ALTER TABLE `program` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `programgenres` +-- + +DROP TABLE IF EXISTS `programgenres`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `programgenres` ( + `chanid` int(10) unsigned NOT NULL default '0', + `starttime` datetime NOT NULL default '0000-00-00 00:00:00', + `relevance` char(1) NOT NULL default '', + `genre` char(30) default NULL, + PRIMARY KEY (`chanid`,`starttime`,`relevance`), + KEY `genre` (`genre`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Dumping data for table `programgenres` +-- + +LOCK TABLES `programgenres` WRITE; +/*!40000 ALTER TABLE `programgenres` DISABLE KEYS */; +/*!40000 ALTER TABLE `programgenres` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `programrating` +-- + +DROP TABLE IF EXISTS `programrating`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `programrating` ( + `chanid` int(10) unsigned NOT NULL default '0', + `starttime` datetime NOT NULL default '0000-00-00 00:00:00', + `system` char(8) NOT NULL default '', + `rating` char(16) default NULL, + UNIQUE KEY `chanid` (`chanid`,`starttime`,`system`,`rating`), + KEY `starttime` (`starttime`,`system`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Dumping data for table `programrating` +-- + +LOCK TABLES `programrating` WRITE; +/*!40000 ALTER TABLE `programrating` DISABLE KEYS */; +/*!40000 ALTER TABLE `programrating` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `recgrouppassword` +-- + +DROP TABLE IF EXISTS `recgrouppassword`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `recgrouppassword` ( + `recgroup` varchar(32) NOT NULL default '', + `password` varchar(10) NOT NULL default '', + PRIMARY KEY (`recgroup`), + UNIQUE KEY `recgroup` (`recgroup`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Dumping data for table `recgrouppassword` +-- + +LOCK TABLES `recgrouppassword` WRITE; +/*!40000 ALTER TABLE `recgrouppassword` DISABLE KEYS */; +/*!40000 ALTER TABLE `recgrouppassword` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `record` +-- + +DROP TABLE IF EXISTS `record`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `record` ( + `recordid` int(10) unsigned NOT NULL auto_increment, + `type` int(10) unsigned NOT NULL default '0', + `chanid` int(10) unsigned default NULL, + `starttime` time NOT NULL default '00:00:00', + `startdate` date NOT NULL default '0000-00-00', + `endtime` time NOT NULL default '00:00:00', + `enddate` date NOT NULL default '0000-00-00', + `title` varchar(128) NOT NULL default '', + `subtitle` varchar(128) NOT NULL default '', + `description` text NOT NULL, + `category` varchar(64) NOT NULL default '', + `profile` varchar(128) NOT NULL default 'Default', + `recpriority` int(10) NOT NULL default '0', + `autoexpire` int(11) NOT NULL default '0', + `maxepisodes` int(11) NOT NULL default '0', + `maxnewest` int(11) NOT NULL default '0', + `startoffset` int(11) NOT NULL default '0', + `endoffset` int(11) NOT NULL default '0', + `recgroup` varchar(32) NOT NULL default 'Default', + `dupmethod` int(11) NOT NULL default '6', + `dupin` int(11) NOT NULL default '15', + `station` varchar(20) NOT NULL default '', + `seriesid` varchar(40) NOT NULL default '', + `programid` varchar(40) NOT NULL default '', + `search` int(10) unsigned NOT NULL default '0', + `autotranscode` tinyint(1) NOT NULL default '0', + `autocommflag` tinyint(1) NOT NULL default '0', + `autouserjob1` tinyint(1) NOT NULL default '0', + `autouserjob2` tinyint(1) NOT NULL default '0', + `autouserjob3` tinyint(1) NOT NULL default '0', + `autouserjob4` tinyint(1) NOT NULL default '0', + `findday` tinyint(4) NOT NULL default '0', + `findtime` time NOT NULL default '00:00:00', + `findid` int(11) NOT NULL default '0', + `inactive` tinyint(1) NOT NULL default '0', + `parentid` int(11) NOT NULL default '0', + `transcoder` int(11) NOT NULL default '0', + `tsdefault` float NOT NULL default '1', + `playgroup` varchar(32) NOT NULL default 'Default', + `prefinput` int(10) NOT NULL default '0', + `next_record` datetime NOT NULL, + `last_record` datetime NOT NULL, + `last_delete` datetime NOT NULL, + `storagegroup` varchar(32) NOT NULL default 'Default', + `avg_delay` int(11) NOT NULL default '100', + PRIMARY KEY (`recordid`), + KEY `chanid` (`chanid`,`starttime`), + KEY `title` (`title`), + KEY `seriesid` (`seriesid`), + KEY `programid` (`programid`), + KEY `maxepisodes` (`maxepisodes`), + KEY `search` (`search`), + KEY `type` (`type`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Dumping data for table `record` +-- + +LOCK TABLES `record` WRITE; +/*!40000 ALTER TABLE `record` DISABLE KEYS */; +/*!40000 ALTER TABLE `record` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `recorded` +-- + +DROP TABLE IF EXISTS `recorded`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `recorded` ( + `chanid` int(10) unsigned NOT NULL default '0', + `starttime` datetime NOT NULL default '0000-00-00 00:00:00', + `endtime` datetime NOT NULL default '0000-00-00 00:00:00', + `title` varchar(128) NOT NULL default '', + `subtitle` varchar(128) NOT NULL default '', + `description` text NOT NULL, + `category` varchar(64) NOT NULL default '', + `hostname` varchar(255) NOT NULL default '', + `bookmark` tinyint(1) NOT NULL default '0', + `editing` int(10) unsigned NOT NULL default '0', + `cutlist` tinyint(1) NOT NULL default '0', + `autoexpire` int(11) NOT NULL default '0', + `commflagged` int(10) unsigned NOT NULL default '0', + `recgroup` varchar(32) NOT NULL default 'Default', + `recordid` int(11) default NULL, + `seriesid` varchar(40) NOT NULL default '', + `programid` varchar(40) NOT NULL default '', + `lastmodified` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP, + `filesize` bigint(20) NOT NULL default '0', + `stars` float NOT NULL default '0', + `previouslyshown` tinyint(1) default '0', + `originalairdate` date default NULL, + `preserve` tinyint(1) NOT NULL default '0', + `findid` int(11) NOT NULL default '0', + `deletepending` tinyint(1) NOT NULL default '0', + `transcoder` int(11) NOT NULL default '0', + `timestretch` float NOT NULL default '1', + `recpriority` int(11) NOT NULL default '0', + `basename` varchar(255) NOT NULL, + `progstart` datetime NOT NULL default '0000-00-00 00:00:00', + `progend` datetime NOT NULL default '0000-00-00 00:00:00', + `playgroup` varchar(32) NOT NULL default 'Default', + `profile` varchar(32) NOT NULL default '', + `duplicate` tinyint(1) NOT NULL default '0', + `transcoded` tinyint(1) NOT NULL default '0', + `watched` tinyint(4) NOT NULL default '0', + `storagegroup` varchar(32) NOT NULL default 'Default', + PRIMARY KEY (`chanid`,`starttime`), + KEY `endtime` (`endtime`), + KEY `seriesid` (`seriesid`), + KEY `programid` (`programid`), + KEY `title` (`title`), + KEY `recordid` (`recordid`), + KEY `deletepending` (`deletepending`,`lastmodified`), + KEY `recgroup` (`recgroup`,`endtime`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Dumping data for table `recorded` +-- + +LOCK TABLES `recorded` WRITE; +/*!40000 ALTER TABLE `recorded` DISABLE KEYS */; +/*!40000 ALTER TABLE `recorded` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `recordedcredits` +-- + +DROP TABLE IF EXISTS `recordedcredits`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `recordedcredits` ( + `person` mediumint(8) unsigned NOT NULL default '0', + `chanid` int(10) unsigned NOT NULL default '0', + `starttime` datetime NOT NULL default '0000-00-00 00:00:00', + `role` set('actor','director','producer','executive_producer','writer','guest_star','host','adapter','presenter','commentator','guest') NOT NULL default '', + UNIQUE KEY `chanid` (`chanid`,`starttime`,`person`,`role`), + KEY `person` (`person`,`role`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Dumping data for table `recordedcredits` +-- + +LOCK TABLES `recordedcredits` WRITE; +/*!40000 ALTER TABLE `recordedcredits` DISABLE KEYS */; +/*!40000 ALTER TABLE `recordedcredits` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `recordedfile` +-- + +DROP TABLE IF EXISTS `recordedfile`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `recordedfile` ( + `chanid` int(10) unsigned NOT NULL default '0', + `starttime` datetime NOT NULL default '0000-00-00 00:00:00', + `basename` varchar(128) NOT NULL default '', + `filesize` bigint(20) NOT NULL default '0', + `width` smallint(5) unsigned NOT NULL default '0', + `height` smallint(5) unsigned NOT NULL default '0', + `fps` float(6,3) NOT NULL default '0.000', + `aspect` float(8,6) NOT NULL default '0.000000', + `audio_sample_rate` smallint(5) unsigned NOT NULL default '0', + `audio_bits_per_sample` smallint(5) unsigned NOT NULL default '0', + `audio_channels` tinyint(3) unsigned NOT NULL default '0', + `audio_type` varchar(255) NOT NULL default '', + `video_type` varchar(255) NOT NULL default '', + `comment` varchar(255) NOT NULL default '', + PRIMARY KEY (`chanid`,`starttime`), + KEY `basename` (`basename`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Dumping data for table `recordedfile` +-- + +LOCK TABLES `recordedfile` WRITE; +/*!40000 ALTER TABLE `recordedfile` DISABLE KEYS */; +/*!40000 ALTER TABLE `recordedfile` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `recordedmarkup` +-- + +DROP TABLE IF EXISTS `recordedmarkup`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `recordedmarkup` ( + `chanid` int(10) unsigned NOT NULL default '0', + `starttime` datetime NOT NULL default '0000-00-00 00:00:00', + `mark` mediumint(8) unsigned NOT NULL default '0', + `offset` varchar(32) default NULL, + `type` tinyint(4) NOT NULL default '0', + PRIMARY KEY (`chanid`,`starttime`,`type`,`mark`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Dumping data for table `recordedmarkup` +-- + +LOCK TABLES `recordedmarkup` WRITE; +/*!40000 ALTER TABLE `recordedmarkup` DISABLE KEYS */; +/*!40000 ALTER TABLE `recordedmarkup` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `recordedprogram` +-- + +DROP TABLE IF EXISTS `recordedprogram`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `recordedprogram` ( + `chanid` int(10) unsigned NOT NULL default '0', + `starttime` datetime NOT NULL default '0000-00-00 00:00:00', + `endtime` datetime NOT NULL default '0000-00-00 00:00:00', + `title` varchar(128) NOT NULL default '', + `subtitle` varchar(128) NOT NULL default '', + `description` text NOT NULL, + `category` varchar(64) NOT NULL default '', + `category_type` varchar(64) NOT NULL default '', + `airdate` year(4) NOT NULL default '0000', + `stars` float unsigned NOT NULL default '0', + `previouslyshown` tinyint(4) NOT NULL default '0', + `title_pronounce` varchar(128) NOT NULL default '', + `stereo` tinyint(1) NOT NULL default '0', + `subtitled` tinyint(1) NOT NULL default '0', + `hdtv` tinyint(1) NOT NULL default '0', + `closecaptioned` tinyint(1) NOT NULL default '0', + `partnumber` int(11) NOT NULL default '0', + `parttotal` int(11) NOT NULL default '0', + `seriesid` varchar(40) NOT NULL default '', + `originalairdate` date default NULL, + `showtype` varchar(30) NOT NULL default '', + `colorcode` varchar(20) NOT NULL default '', + `syndicatedepisodenumber` varchar(20) NOT NULL default '', + `programid` varchar(40) NOT NULL default '', + `manualid` int(10) unsigned NOT NULL default '0', + `generic` tinyint(1) default '0', + `listingsource` int(11) NOT NULL default '0', + `first` tinyint(1) NOT NULL default '0', + `last` tinyint(1) NOT NULL default '0', + `audioprop` set('STEREO','MONO','SURROUND','DOLBY','HARDHEAR','VISUALIMPAIR') NOT NULL, + `subtitletypes` set('HARDHEAR','NORMAL','ONSCREEN','SIGNED') NOT NULL, + `videoprop` set('HDTV','WIDESCREEN','AVC') NOT NULL, + PRIMARY KEY (`chanid`,`starttime`,`manualid`), + KEY `endtime` (`endtime`), + KEY `title` (`title`), + KEY `title_pronounce` (`title_pronounce`), + KEY `seriesid` (`seriesid`), + KEY `programid` (`programid`), + KEY `id_start_end` (`chanid`,`starttime`,`endtime`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Dumping data for table `recordedprogram` +-- + +LOCK TABLES `recordedprogram` WRITE; +/*!40000 ALTER TABLE `recordedprogram` DISABLE KEYS */; +/*!40000 ALTER TABLE `recordedprogram` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `recordedrating` +-- + +DROP TABLE IF EXISTS `recordedrating`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `recordedrating` ( + `chanid` int(10) unsigned NOT NULL default '0', + `starttime` datetime NOT NULL default '0000-00-00 00:00:00', + `system` char(8) NOT NULL default '', + `rating` char(16) default NULL, + UNIQUE KEY `chanid` (`chanid`,`starttime`,`system`,`rating`), + KEY `starttime` (`starttime`,`system`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Dumping data for table `recordedrating` +-- + +LOCK TABLES `recordedrating` WRITE; +/*!40000 ALTER TABLE `recordedrating` DISABLE KEYS */; +/*!40000 ALTER TABLE `recordedrating` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `recordedseek` +-- + +DROP TABLE IF EXISTS `recordedseek`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `recordedseek` ( + `chanid` int(10) unsigned NOT NULL default '0', + `starttime` datetime NOT NULL default '0000-00-00 00:00:00', + `mark` mediumint(8) unsigned NOT NULL default '0', + `offset` bigint(20) unsigned NOT NULL, + `type` tinyint(4) NOT NULL default '0', + PRIMARY KEY (`chanid`,`starttime`,`type`,`mark`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Dumping data for table `recordedseek` +-- + +LOCK TABLES `recordedseek` WRITE; +/*!40000 ALTER TABLE `recordedseek` DISABLE KEYS */; +/*!40000 ALTER TABLE `recordedseek` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `recordingprofiles` +-- + +DROP TABLE IF EXISTS `recordingprofiles`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `recordingprofiles` ( + `id` int(10) unsigned NOT NULL auto_increment, + `name` varchar(128) default NULL, + `videocodec` varchar(128) default NULL, + `audiocodec` varchar(128) default NULL, + `profilegroup` int(10) unsigned NOT NULL default '0', + PRIMARY KEY (`id`), + KEY `profilegroup` (`profilegroup`) +) ENGINE=MyISAM AUTO_INCREMENT=50 DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Dumping data for table `recordingprofiles` +-- + +LOCK TABLES `recordingprofiles` WRITE; +/*!40000 ALTER TABLE `recordingprofiles` DISABLE KEYS */; +INSERT INTO `recordingprofiles` (`id`, `name`, `videocodec`, `audiocodec`, `profilegroup`) VALUES (1,'Default',NULL,NULL,1),(2,'Live TV',NULL,NULL,1),(3,'High Quality',NULL,NULL,1),(4,'Low Quality',NULL,NULL,1),(5,'Default',NULL,NULL,2),(6,'Live TV',NULL,NULL,2),(7,'High Quality',NULL,NULL,2),(8,'Low Quality',NULL,NULL,2),(9,'Default',NULL,NULL,3),(10,'Live TV',NULL,NULL,3),(11,'High Quality',NULL,NULL,3),(12,'Low Quality',NULL,NULL,3),(13,'Default',NULL,NULL,4),(14,'Live TV',NULL,NULL,4),(15,'High Quality',NULL,NULL,4),(16,'Low Quality',NULL,NULL,4),(17,'Default',NULL,NULL,5),(18,'Live TV',NULL,NULL,5),(19,'High Quality',NULL,NULL,5),(20,'Low Quality',NULL,NULL,5),(21,'RTjpeg/MPEG4',NULL,NULL,6),(22,'MPEG2',NULL,NULL,6),(23,'Default',NULL,NULL,8),(24,'Live TV',NULL,NULL,8),(25,'High Quality',NULL,NULL,8),(26,'Low Quality',NULL,NULL,8),(27,'High Quality',NULL,NULL,6),(28,'Medium Quality',NULL,NULL,6),(29,'Low Quality',NULL,NULL,6),(30,'Default',NULL,NULL,10),(31,'Live TV',NULL,NULL,10),(32,'High Quality',NULL,NULL,10),(33,'Low Quality',NULL,NULL,10),(34,'Default',NULL,NULL,11),(35,'Live TV',NULL,NULL,11),(36,'High Quality',NULL,NULL,11),(37,'Low Quality',NULL,NULL,11),(38,'Default',NULL,NULL,12),(39,'Live TV',NULL,NULL,12),(40,'High Quality',NULL,NULL,12),(41,'Low Quality',NULL,NULL,12),(42,'Default',NULL,NULL,7),(43,'Live TV',NULL,NULL,7),(44,'High Quality',NULL,NULL,7),(45,'Low Quality',NULL,NULL,7),(46,'Default',NULL,NULL,9),(47,'Live TV',NULL,NULL,9),(48,'High Quality',NULL,NULL,9),(49,'Low Quality',NULL,NULL,9); +/*!40000 ALTER TABLE `recordingprofiles` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `recordmatch` +-- + +DROP TABLE IF EXISTS `recordmatch`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `recordmatch` ( + `recordid` int(10) unsigned default NULL, + `chanid` int(10) unsigned default NULL, + `starttime` datetime default NULL, + `manualid` int(10) unsigned default NULL, + `oldrecduplicate` tinyint(1) default NULL, + `recduplicate` tinyint(1) default NULL, + `findduplicate` tinyint(1) default NULL, + `oldrecstatus` int(11) default NULL, + KEY `recordid` (`recordid`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Dumping data for table `recordmatch` +-- + +LOCK TABLES `recordmatch` WRITE; +/*!40000 ALTER TABLE `recordmatch` DISABLE KEYS */; +/*!40000 ALTER TABLE `recordmatch` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `romdb` +-- + +DROP TABLE IF EXISTS `romdb`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `romdb` ( + `crc` varchar(64) NOT NULL default '', + `name` varchar(128) NOT NULL default '', + `description` varchar(128) NOT NULL default '', + `category` varchar(128) NOT NULL default '', + `year` varchar(10) NOT NULL default '', + `manufacturer` varchar(128) NOT NULL default '', + `country` varchar(128) NOT NULL default '', + `publisher` varchar(128) NOT NULL default '', + `platform` varchar(64) NOT NULL default '', + `filesize` int(12) default NULL, + `flags` varchar(64) NOT NULL default '', + `version` varchar(64) NOT NULL default '', + `binfile` varchar(64) NOT NULL default '', + KEY `crc` (`crc`), + KEY `year` (`year`), + KEY `category` (`category`), + KEY `name` (`name`), + KEY `description` (`description`), + KEY `platform` (`platform`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Dumping data for table `romdb` +-- + +LOCK TABLES `romdb` WRITE; +/*!40000 ALTER TABLE `romdb` DISABLE KEYS */; +/*!40000 ALTER TABLE `romdb` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `schemalock` +-- + +DROP TABLE IF EXISTS `schemalock`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `schemalock` ( + `schemalock` int(1) default NULL +) ENGINE=MyISAM DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Dumping data for table `schemalock` +-- + +LOCK TABLES `schemalock` WRITE; +/*!40000 ALTER TABLE `schemalock` DISABLE KEYS */; +/*!40000 ALTER TABLE `schemalock` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `settings` +-- + +DROP TABLE IF EXISTS `settings`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `settings` ( + `value` varchar(128) NOT NULL default '', + `data` text, + `hostname` varchar(255) default NULL, + KEY `value` (`value`,`hostname`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Dumping data for table `settings` +-- + +LOCK TABLES `settings` WRITE; +/*!40000 ALTER TABLE `settings` DISABLE KEYS */; +INSERT INTO `settings` (`value`, `data`, `hostname`) VALUES ('mythfilldatabaseLastRunStart',NULL,NULL),('mythfilldatabaseLastRunEnd',NULL,NULL),('mythfilldatabaseLastRunStatus',NULL,NULL),('DataDirectMessage',NULL,NULL),('HaveRepeats','0',NULL),('DBSchemaVer','1214',NULL),('DefaultTranscoder','0',NULL),('MythFillSuggestedRunTime','1970-01-01T00:00:00',NULL),('MythFillGrabberSuggestsTime','1',NULL),('MythFillFixProgramIDsHasRunOnce','1','larch5'),('Language','EN','larch5'),('BackendServerIP','127.0.0.1','larch5'),('BackendServerPort','6543','larch5'),('BackendStatusPort','6544','larch5'),('SecurityPin','','larch5'),('MasterServerIP','127.0.0.1',NULL),('MasterServerPort','6543',NULL),('TVFormat','NTSC',NULL),('VbiFormat','None',NULL),('FreqTable','us-bcast',NULL),('TimeOffset','None',NULL),('MasterBackendOverride','1',NULL),('DeletesFollowLinks','1',NULL),('TruncateDeletesSlowly','0','larch5'),('HDRingbufferSize','9400',NULL),('MiscStatusScript','','larch5'),('DisableFirewireReset','0','larch5'),('EITTransportTimeout','5',NULL),('EITIgnoresSource','0',NULL),('EITCrawIdleStart','60',NULL),('startupCommand','',NULL),('blockSDWUwithoutClient','1',NULL),('idleWaitForRecordingTime','15',NULL),('StartupSecsBeforeRecording','120',NULL),('WakeupTimeFormat','hh:mm yyyy-MM-dd',NULL),('SetWakeuptimeCommand','',NULL),('ServerHaltCommand','sudo /sbin/halt -p',NULL),('preSDWUCheckCommand','',NULL),('WOLbackendConnectRetry','5',NULL),('WOLbackendCommand','',NULL),('WOLslaveBackendsCommand','',NULL),('JobQueueMaxSimultaneousJobs','1','larch5'),('JobQueueCheckFrequency','60','larch5'),('JobQueueWindowStart','00:00','larch5'),('JobQueueWindowEnd','23:59','larch5'),('JobQueueCPU','0','larch5'),('JobAllowCommFlag','1','larch5'),('JobAllowTranscode','1','larch5'),('JobAllowUserJob1','0','larch5'),('JobAllowUserJob2','0','larch5'),('JobAllowUserJob3','0','larch5'),('JobAllowUserJob4','0','larch5'),('JobsRunOnRecordHost','0',NULL),('AutoCommflagWhileRecording','0',NULL),('JobQueueCommFlagCommand','mythcommflag',NULL),('JobQueueTranscodeCommand','mythtranscode',NULL),('AutoTranscodeBeforeAutoCommflag','0',NULL),('SaveTranscoding','0',NULL),('UserJobDesc1','User Job #1',NULL),('UserJob1','',NULL),('UserJobDesc2','User Job #2',NULL),('UserJob2','',NULL),('UserJobDesc3','User Job #3',NULL),('UserJob3','',NULL),('UserJobDesc4','User Job #4',NULL),('UserJob4','',NULL),('DefaultVideoPlaybackProfile','CPU+','larch5'),('RealtimePriority','1','larch5'),('DecodeExtraAudio','1','larch5'),('AudioNag','1','larch5'),('UseVideoTimebase','0','larch5'),('ClearSavedPosition','1','larch5'),('AltClearSavedPosition','1','larch5'),('JumpToProgramOSD','1','larch5'),('ContinueEmbeddedTVPlay','0','larch5'),('AutomaticSetWatched','0','larch5'),('AlwaysStreamFiles','1','larch5'),('UseOpenGLVSync','0','larch5'),('UseOutputPictureControls','1','larch5'),('AspectOverride','0','larch5'),('AdjustFill','0','larch5'),('LetterboxColour','0','larch5'),('PIPLocation','0','larch5'),('PlaybackExitPrompt','2','larch5'),('EndOfRecordingExitPrompt','1','larch5'),('PlayBoxOrdering','1','larch5'),('PlayBoxEpisodeSort','Date','larch5'),('GeneratePreviewPixmaps','0','larch5'),('PreviewPixmapOffset','64',NULL),('PreviewFromBookmark','1','larch5'),('PlaybackPreview','1','larch5'),('PlaybackBoxStartInTitle','1','larch5'),('ShowGroupInfo','0','larch5'),('AllRecGroupPassword','',NULL),('DisplayRecGroup','All Programs','larch5'),('QueryInitialFilter','0','larch5'),('RememberRecGroup','1','larch5'),('DispRecGroupAsAllProg','0','larch5'),('LiveTVInAllPrograms','0','larch5'),('DisplayGroupDefaultView','0','larch5'),('DisplayGroupTitleSort','0','larch5'),('PlaybackWatchList','1','larch5'),('PlaybackWLStart','0','larch5'),('PlaybackWLAutoExpire','0','larch5'),('PlaybackWLMaxAge','60','larch5'),('PlaybackWLBlackOut','2','larch5'),('SmartForward','0','larch5'),('StickyKeys','0','larch5'),('FFRewReposTime','100','larch5'),('FFRewReverse','1','larch5'),('ExactSeeking','0','larch5'),('AutoCommercialSkip','0','larch5'),('MaximumCommercialSkip','3600',NULL),('CommSkipAllBlanks','1',NULL),('PVR350OutputEnable','0','larch5'),('PVR350EPGAlphaValue','164','larch5'),('PVR350InternalAudioOnly','0','larch5'),('OSDTheme','blueosd','larch5'),('OSDGeneralTimeout','2','larch5'),('OSDProgramInfoTimeout','3','larch5'),('OSDFont','FreeMono.ttf','larch5'),('OSDThemeFontSizeType','default','larch5'),('EnableMHEG','0','larch5'),('PersistentBrowseMode','1','larch5'),('OSDNotifyTimeout','5','larch5'),('UDPNotifyPort','6948','larch5'),('OSDCCFont','FreeMono.ttf','larch5'),('CCBackground','0','larch5'),('DefaultCCMode','0','larch5'),('Prefer708Captions','1','larch5'),('OSDCC708TextZoom','100','larch5'),('OSDCC708DefaultFontType','MonoSerif','larch5'),('OSDCC708MonoSerifFont','FreeMono.ttf','larch5'),('OSDCC708PropSerifFont','FreeMono.ttf','larch5'),('OSDCC708MonoSansSerifFont','FreeMono.ttf','larch5'),('OSDCC708PropSansSerifFont','FreeMono.ttf','larch5'),('OSDCC708CasualFont','FreeMono.ttf','larch5'),('OSDCC708CursiveFont','FreeMono.ttf','larch5'),('OSDCC708CapitalsFont','FreeMono.ttf','larch5'),('OSDCC708MonoSerifItalicFont','FreeMono.ttf','larch5'),('OSDCC708PropSerifItalicFont','FreeMono.ttf','larch5'),('OSDCC708MonoSansSerifItalicFont','FreeMono.ttf','larch5'),('OSDCC708PropSansSerifItalicFont','FreeMono.ttf','larch5'),('OSDCC708CasualItalicFont','FreeMono.ttf','larch5'),('OSDCC708CursiveItalicFont','FreeMono.ttf','larch5'),('OSDCC708CapitalsItalicFont','FreeMono.ttf','larch5'),('ChannelOrdering','channum','larch5'),('ChannelFormat','<num> <sign>','larch5'),('LongChannelFormat','<num> <name>','larch5'),('SmartChannelChange','0','larch5'),('LastFreeCard','0',NULL),('LiveTVPriority','0',NULL),('AutoExpireMethod','2',NULL),('AutoExpireDefault','1',NULL),('RerecordWatched','1',NULL),('AutoExpireWatchedPriority','0',NULL),('AutoExpireLiveTVMaxAge','1',NULL),('AutoExpireDayPriority','3',NULL),('AutoExpireExtraSpace','1',NULL),('AutoExpireInsteadOfDelete','0',NULL),('DeletedFifoOrder','0',NULL),('CommercialSkipMethod','255',NULL),('AggressiveCommDetect','1',NULL),('AutoCommercialFlag','1',NULL),('AutoTranscode','0',NULL),('AutoRunUserJob1','0',NULL),('AutoRunUserJob2','0',NULL),('AutoRunUserJob3','0',NULL),('AutoRunUserJob4','0',NULL),('OverTimeCategory','category name',NULL),('CategoryOverTime','30',NULL),('EPGFillType','12','larch5'),('EPGShowCategoryColors','1','larch5'),('EPGShowCategoryText','1','larch5'),('EPGScrollType','1','larch5'),('EPGShowChannelIcon','1','larch5'),('EPGShowFavorites','0','larch5'),('WatchTVGuide','0','larch5'),('chanPerPage','5','larch5'),('timePerPage','4','larch5'),('UnknownTitle','Unknown','larch5'),('UnknownCategory','Unknown','larch5'),('DefaultTVChannel','3','larch5'),('SelectChangesChannel','0','larch5'),('SelChangeRecThreshold','16','larch5'),('EPGEnableJumpToChannel','0',NULL),('Theme','G.A.N.T','larch5'),('RandomTheme','0','larch5'),('ThemeCacheSize','1','larch5'),('ThemePainter','qt','larch5'),('Style','Desktop Style','larch5'),('ThemeFontSizeType','default','larch5'),('MenuTheme','default','larch5'),('XineramaScreen','0','larch5'),('XineramaMonitorAspectRatio','1.3333','larch5'),('GuiSizeForTV','1','larch5'),('HideMouseCursor','1','larch5'),('RunFrontendInWindow','0','larch5'),('UseVideoModes','0','larch5'),('GuiVidModeResolution','640x480','larch5'),('TVVidModeResolution','320x200','larch5'),('TVVidModeForceAspect','0.0','larch5'),('TVVidModeResolution0','320x200','larch5'),('TVVidModeForceAspect0','0.0','larch5'),('TVVidModeResolution1','320x200','larch5'),('TVVidModeForceAspect1','0.0','larch5'),('TVVidModeResolution2','320x200','larch5'),('TVVidModeForceAspect2','0.0','larch5'),('ISO639Language0','eng','larch5'),('ISO639Language1','eng','larch5'),('DateFormat','ddd MMM d','larch5'),('ShortDateFormat','M/d','larch5'),('TimeFormat','h:mm AP','larch5'),('QtFontSmall','12','larch5'),('QtFontMedium','16','larch5'),('QtFontBig','25','larch5'),('PlayBoxTransparency','1','larch5'),('PlayBoxShading','0','larch5'),('UseVirtualKeyboard','1','larch5'),('LCDEnable','0','larch5'),('LCDShowTime','1','larch5'),('LCDShowMenu','1','larch5'),('LCDShowMusic','1','larch5'),('LCDShowMusicItems','ArtistTitle','larch5'),('LCDShowChannel','1','larch5'),('LCDShowRecStatus','0','larch5'),('LCDShowVolume','1','larch5'),('LCDShowGeneric','1','larch5'),('LCDBacklightOn','1','larch5'),('LCDHeartBeatOn','0','larch5'),('LCDBigClock','0','larch5'),('LCDKeyString','ABCDEF','larch5'),('LCDPopupTime','5','larch5'),('AudioOutputDevice','ALSA:default','larch5'),('PassThruOutputDevice','Default','larch5'),('MaxChannels','2','larch5'),('AudioUpmixType','0','larch5'),('AC3PassThru','0','larch5'),('DTSPassThru','0','larch5'),('AggressiveSoundcardBuffer','0','larch5'),('MythControlsVolume','1','larch5'),('MixerDevice','ALSA:default','larch5'),('MixerControl','PCM','larch5'),('MasterMixerVolume','100','larch5'),('PCMMixerVolume','50','larch5'),('IndividualMuteControl','0','larch5'),('LircKeyPressedApp','','larch5'),('AllowQuitShutdown','4','larch5'),('NoPromptOnExit','1','larch5'),('UseArrowAccels','1','larch5'),('NetworkControlEnabled','0','larch5'),('NetworkControlPort','6546','larch5'),('MonitorDrives','0','larch5'),('MediaChangeEvents','0','larch5'),('IgnoreDevices','','larch5'),('SetupPinCodeRequired','0','larch5'),('OverrideExitMenu','0','larch5'),('HaltCommand','sudo /sbin/halt','larch5'),('RebootCommand','sudo /sbin/reboot','larch5'),('EnableXbox','0','larch5'),('LogEnabled','0',NULL),('LogMaxCount','100','larch5'),('LogPrintLevel','8','larch5'),('LogCleanEnabled','0','larch5'),('LogCleanPeriod','14','larch5'),('LogCleanDays','14','larch5'),('LogCleanMax','30','larch5'),('MythFillEnabled','1',NULL),('MythFillDatabasePath','mythfilldatabase',NULL),('MythFillDatabaseArgs','',NULL),('MythFillDatabaseLog','',NULL),('MythFillPeriod','1',NULL),('MythFillMinHour','2',NULL),('MythFillMaxHour','5',NULL),('SchedMoveHigher','1',NULL),('SchedOpenEnd','0',NULL),('ComplexPriority','0',NULL),('PrefInputPriority','2',NULL),('SingleRecordRecPriority','1',NULL),('FindOneRecordRecPriority','-1',NULL),('ArchiveDBSchemaVer','1001',NULL),('MythArchiveTempDir','/myth/tmp','larch5'),('MythArchiveShareDir','/usr/share/mythtv/mytharchive/','larch5'),('MythArchiveVideoFormat','NTSC','larch5'),('MythArchiveFileFilter','*.mpg *.mov *.avi *.mpeg *.nuv','larch5'),('MythArchiveDVDLocation','/dev/dvd','larch5'),('MythArchiveDVDPlayerCmd','Internal','larch5'),('MythArchiveEncodeToAc3','0','larch5'),('MythArchiveCopyRemoteFiles','0','larch5'),('MythArchiveAlwaysUseMythTranscode','1','larch5'),('MythArchiveUseProjectX','0','larch5'),('MythArchiveAddSubtitles','0','larch5'),('MythArchiveUseFIFO','1','larch5'),('MythArchiveDefaultEncProfile','SP','larch5'),('MythArchiveMainMenuAR','16:9','larch5'),('MythArchiveChapterMenuAR','Video','larch5'),('MythArchiveDateFormat','%a %b %d','larch5'),('MythArchiveTimeFormat','%I:%M %p','larch5'),('MythArchiveFfmpegCmd','ffmpeg','larch5'),('MythArchiveMplexCmd','mplex','larch5'),('MythArchiveDvdauthorCmd','dvdauthor','larch5'),('MythArchiveSpumuxCmd','spumux','larch5'),('MythArchiveMpeg2encCmd','mpeg2enc','larch5'),('MythArchiveMkisofsCmd','mkisofs','larch5'),('MythArchiveGrowisofsCmd','growisofs','larch5'),('MythArchiveTcrequantCmd','tcrequant','larch5'),('MythArchiveJpeg2yuvCmd','jpeg2yuv','larch5'),('MythArchiveProjectXCmd','projectx','larch5'),('FlixDBSchemaVer','1001',NULL),('GalleryDBSchemaVer','1000',NULL),('GalleryDir','/myth/gallery','larch5'),('GalleryThumbnailLocation','1','larch5'),('GallerySortOrder','20','larch5'),('GalleryImportDirs','/mnt/cdrom:/mnt/camera','larch5'),('GalleryMoviePlayerCmd','mplayer -fs %s','larch5'),('SlideshowUseOpenGL','0','larch5'),('SlideshowDelay','5','larch5'),('SlideshowOpenGLTransition','none','larch5'),('SlideshowOpenGLTransitionLength','2000','larch5'),('SlideshowTransition','random','larch5'),('SlideshowBackground','black','larch5'),('GameDBSchemaVer','1012',NULL),('MusicDBSchemaVer','1013',NULL),('VisualMode','','larch5'),('MusicLocation','/myth/music/','larch5'),('MusicAudioDevice','default','larch5'),('CDDevice','/dev/cdrom','larch5'),('AutoLookupCD','1','larch5'),('AutoPlayCD','0','larch5'),('KeyboardAccelerators','1','larch5'),('TreeLevels','splitartist artist album title','larch5'),('ArtistTreeGroups','0','larch5'),('NonID3FileNameFormat','GENRE/ARTIST/ALBUM/TRACK_TITLE','larch5'),('Ignore_ID3','0','larch5'),('MusicTagEncoding','utf16','larch5'),('CDWriterEnabled','1','larch5'),('CDDiskSize','1','larch5'),('CDCreateDir','1','larch5'),('CDWriteSpeed','0','larch5'),('CDBlankType','fast','larch5'),('PlayMode','none','larch5'),('ResumeMode','off','larch5'),('MaxSearchResults','300','larch5'),('MusicShowRatings','0','larch5'),('ShowWholeTree','0','larch5'),('ListAsShuffled','0','larch5'),('IntelliRatingWeight','35','larch5'),('IntelliPlayCountWeight','25','larch5'),('IntelliLastPlayWeight','25','larch5'),('IntelliRandomWeight','15','larch5'),('VisualCycleOnSongChange','0','larch5'),('VisualAlbumArtOnSongChange','0','larch5'),('VisualRandomize','0','larch5'),('VisualModeDelay','0','larch5'),('VisualScaleWidth','1','larch5'),('VisualScaleHeight','1','larch5'),('ParanoiaLevel','Full','larch5'),('FilenameTemplate','ARTIST/ALBUM/TRACK-TITLE','larch5'),('NoWhitespace','0','larch5'),('PostCDRipScript','','larch5'),('EjectCDAfterRipping','1','larch5'),('EncoderType','ogg','larch5'),('DefaultRipQuality','1','larch5'),('Mp3UseVBR','0','larch5'),('PhoneDBSchemaVer','1001',NULL),('SipRegisterWithProxy','1','larch5'),('SipProxyName','fwd.pulver.com','larch5'),('SipProxyAuthName','','larch5'),('SipProxyAuthPassword','','larch5'),('MySipName','Me','larch5'),('SipAutoanswer','0','larch5'),('SipBindInterface','eth0','larch5'),('SipLocalPort','5060','larch5'),('NatTraversalMethod','None','larch5'),('NatIpAddress','http://checkip.dyndns.org','larch5'),('AudioLocalPort','21232','larch5'),('VideoLocalPort','21234','larch5'),('MicrophoneDevice','None','larch5'),('CodecPriorityList','GSM;G.711u;G.711a','larch5'),('PlayoutAudioCall','40','larch5'),('PlayoutVideoCall','110','larch5'),('TxResolution','176x144','larch5'),('TransmitFPS','5','larch5'),('TransmitBandwidth','256','larch5'),('CaptureResolution','352x288','larch5'),('TimeToAnswer','10','larch5'),('DefaultVxmlUrl','http://127.0.0.1/vxml/index.vxml','larch5'),('DefaultVoicemailPrompt','I am not at home, please leave a message after the tone','larch5'),('mythvideo.DBSchemaVer','1016',NULL),('VideoStartupDir','/myth/video','larch5'),('VideoArtworkDir','/myth/video/.covers','larch5'),('Default MythVideo View','2','larch5'),('VideoListUnknownFiletypes','1','larch5'),('VideoBrowserNoDB','1','larch5'),('VideoGalleryNoDB','1','larch5'),('VideoTreeNoDB','1','larch5'),('VideoTreeLoadMetaData','1','larch5'),('VideoNewBrowsable','1','larch5'),('mythvideo.sort_ignores_case','1','larch5'),('mythvideo.db_folder_view','1','larch5'),('mythvideo.VideoTreeRemember','1','larch5'),('mythvideo.ImageCacheSize','50','larch5'),('DVDDeviceLocation','/dev/dvd','larch5'),('VCDDeviceLocation','/dev/cdrom','larch5'),('DVDOnInsertDVD','1','larch5'),('DVDDriveSpeed','2','larch5'),('EnableDVDBookmark','1','larch5'),('DVDBookmarkPrompt','1','larch5'),('DVDBookmarkDays','10','larch5'),('MovieListCommandLine','/usr/share/mythtv/mythvideo/scripts/imdb.pl -M tv=no;video=no','larch5'),('MoviePosterCommandLine','/usr/share/mythtv/mythvideo/scripts/imdb.pl -P','larch5'),('MovieDataCommandLine','/usr/share/mythtv/mythvideo/scripts/imdb.pl -D','larch5'),('VideoGalleryColsPerPage','4','larch5'),('VideoGalleryRowsPerPage','3','larch5'),('VideoGallerySubtitle','1','larch5'),('VideoDefaultParentalLevel','4','larch5'),('VideoAggressivePC','0','larch5'),('mythvideo.ParentalLevelFromRating','0','larch5'),('mythvideo.AutoR2PL1','G','larch5'),('mythvideo.AutoR2PL2','PG','larch5'),('mythvideo.AutoR2PL3','PG-13','larch5'),('mythvideo.AutoR2PL4','R:NC-17','larch5'),('VideoDefaultPlayer','mplayer -fs -zoom -quiet -vo xv %s','larch5'),('mythdvd.DVDPlayerCommand','Internal','larch5'),('VCDPlayerCommand','mplayer vcd:// -cdrom-device %d -fs -zoom -vo xv','larch5'),('DVDRipLocation','/myth/tmp','larch5'),('TitlePlayCommand','mplayer dvd://%t -dvd-device %d -fs -zoom -vo xv -aid %a -channels %c','larch5'),('SubTitleCommand','-sid %s','larch5'),('TranscodeCommand','transcode','larch5'),('MTDPort','2442','larch5'),('MTDNiceLevel','20','larch5'),('MTDConcurrentTranscodes','1','larch5'),('MTDLogFlag','0','larch5'),('MTDac3Flag','0','larch5'),('MTDxvidFlag','1','larch5'),('mythvideo.TrustTranscodeFRDetect','1','larch5'),('WeatherDBSchemaVer','1000',NULL),('TVVidModeRefreshRate','0','larch5'),('TVVidModeRefreshRate0','0','larch5'),('TVVidModeRefreshRate1','0','larch5'),('TVVidModeRefreshRate2','0','larch5'),('GalleryRecursiveSlideshow','1','larch5'),('WebBrowserZoomLevel','20','larch5'),('WebBrowserCommand','/usr/bin/mythbrowser','larch5'),('WebBrowserScrollMode','1','larch5'),('WebBrowserScrollSpeed','4','larch5'),('WebBrowserHideScrollbars','0','larch5'),('RepeatMode','all','larch5'),('MusicAutoShowPlayer','1','larch5'); +/*!40000 ALTER TABLE `settings` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `storagegroup` +-- + +DROP TABLE IF EXISTS `storagegroup`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `storagegroup` ( + `id` int(11) NOT NULL auto_increment, + `groupname` varchar(32) NOT NULL, + `hostname` varchar(64) NOT NULL default '', + `dirname` varchar(255) NOT NULL default '', + PRIMARY KEY (`id`), + UNIQUE KEY `grouphostdir` (`groupname`,`hostname`,`dirname`), + KEY `hostname` (`hostname`) +) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Dumping data for table `storagegroup` +-- + +LOCK TABLES `storagegroup` WRITE; +/*!40000 ALTER TABLE `storagegroup` DISABLE KEYS */; +INSERT INTO `storagegroup` (`id`, `groupname`, `hostname`, `dirname`) VALUES (1,'Default','larch5','/myth/tv/'); +/*!40000 ALTER TABLE `storagegroup` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `tvchain` +-- + +DROP TABLE IF EXISTS `tvchain`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `tvchain` ( + `chanid` int(10) unsigned NOT NULL default '0', + `starttime` datetime NOT NULL default '0000-00-00 00:00:00', + `chainid` varchar(128) NOT NULL default '', + `chainpos` int(10) NOT NULL default '0', + `discontinuity` tinyint(1) NOT NULL default '0', + `watching` int(10) NOT NULL default '0', + `hostprefix` varchar(128) NOT NULL default '', + `cardtype` varchar(32) NOT NULL default 'V4L', + `input` varchar(32) NOT NULL default '', + `channame` varchar(32) NOT NULL default '', + `endtime` datetime NOT NULL default '0000-00-00 00:00:00', + PRIMARY KEY (`chanid`,`starttime`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Dumping data for table `tvchain` +-- + +LOCK TABLES `tvchain` WRITE; +/*!40000 ALTER TABLE `tvchain` DISABLE KEYS */; +/*!40000 ALTER TABLE `tvchain` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `upnpmedia` +-- + +DROP TABLE IF EXISTS `upnpmedia`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `upnpmedia` ( + `intid` int(10) unsigned NOT NULL default '0', + `class` varchar(64) NOT NULL default '', + `itemtype` varchar(128) NOT NULL default '', + `parentid` int(10) unsigned NOT NULL default '0', + `itemproperties` varchar(255) NOT NULL default '', + `filepath` varchar(512) NOT NULL default '', + `title` varchar(255) NOT NULL default '', + `filename` varchar(512) NOT NULL default '', + `coverart` varchar(512) NOT NULL default '', + PRIMARY KEY (`intid`), + KEY `class` (`class`), + KEY `filepath` (`filepath`), + KEY `parentid` (`parentid`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Dumping data for table `upnpmedia` +-- + +LOCK TABLES `upnpmedia` WRITE; +/*!40000 ALTER TABLE `upnpmedia` DISABLE KEYS */; +/*!40000 ALTER TABLE `upnpmedia` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `videocast` +-- + +DROP TABLE IF EXISTS `videocast`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `videocast` ( + `intid` int(10) unsigned NOT NULL auto_increment, + `cast` varchar(128) NOT NULL, + PRIMARY KEY (`intid`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Dumping data for table `videocast` +-- + +LOCK TABLES `videocast` WRITE; +/*!40000 ALTER TABLE `videocast` DISABLE KEYS */; +/*!40000 ALTER TABLE `videocast` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `videocategory` +-- + +DROP TABLE IF EXISTS `videocategory`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `videocategory` ( + `intid` int(10) unsigned NOT NULL auto_increment, + `category` varchar(128) NOT NULL, + PRIMARY KEY (`intid`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Dumping data for table `videocategory` +-- + +LOCK TABLES `videocategory` WRITE; +/*!40000 ALTER TABLE `videocategory` DISABLE KEYS */; +/*!40000 ALTER TABLE `videocategory` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `videocountry` +-- + +DROP TABLE IF EXISTS `videocountry`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `videocountry` ( + `intid` int(10) unsigned NOT NULL auto_increment, + `country` varchar(128) NOT NULL, + PRIMARY KEY (`intid`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Dumping data for table `videocountry` +-- + +LOCK TABLES `videocountry` WRITE; +/*!40000 ALTER TABLE `videocountry` DISABLE KEYS */; +/*!40000 ALTER TABLE `videocountry` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `videogenre` +-- + +DROP TABLE IF EXISTS `videogenre`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `videogenre` ( + `intid` int(10) unsigned NOT NULL auto_increment, + `genre` varchar(128) NOT NULL, + PRIMARY KEY (`intid`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Dumping data for table `videogenre` +-- + +LOCK TABLES `videogenre` WRITE; +/*!40000 ALTER TABLE `videogenre` DISABLE KEYS */; +/*!40000 ALTER TABLE `videogenre` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `videometadata` +-- + +DROP TABLE IF EXISTS `videometadata`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `videometadata` ( + `intid` int(10) unsigned NOT NULL auto_increment, + `title` varchar(128) NOT NULL, + `director` varchar(128) NOT NULL, + `plot` text, + `rating` varchar(128) NOT NULL, + `inetref` varchar(255) NOT NULL, + `year` int(10) unsigned NOT NULL, + `userrating` float NOT NULL, + `length` int(10) unsigned NOT NULL, + `showlevel` int(10) unsigned NOT NULL, + `filename` text NOT NULL, + `coverfile` text NOT NULL, + `childid` int(11) NOT NULL default '-1', + `browse` tinyint(1) NOT NULL default '1', + `playcommand` varchar(255) default NULL, + `category` int(10) unsigned NOT NULL default '0', + PRIMARY KEY (`intid`), + KEY `director` (`director`), + KEY `title` (`title`), + KEY `title_2` (`title`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Dumping data for table `videometadata` +-- + +LOCK TABLES `videometadata` WRITE; +/*!40000 ALTER TABLE `videometadata` DISABLE KEYS */; +/*!40000 ALTER TABLE `videometadata` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `videometadatacast` +-- + +DROP TABLE IF EXISTS `videometadatacast`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `videometadatacast` ( + `idvideo` int(10) unsigned NOT NULL, + `idcast` int(10) unsigned NOT NULL +) ENGINE=MyISAM DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Dumping data for table `videometadatacast` +-- + +LOCK TABLES `videometadatacast` WRITE; +/*!40000 ALTER TABLE `videometadatacast` DISABLE KEYS */; +/*!40000 ALTER TABLE `videometadatacast` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `videometadatacountry` +-- + +DROP TABLE IF EXISTS `videometadatacountry`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `videometadatacountry` ( + `idvideo` int(10) unsigned NOT NULL, + `idcountry` int(10) unsigned NOT NULL, + KEY `idvideo` (`idvideo`), + KEY `idcountry` (`idcountry`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Dumping data for table `videometadatacountry` +-- + +LOCK TABLES `videometadatacountry` WRITE; +/*!40000 ALTER TABLE `videometadatacountry` DISABLE KEYS */; +/*!40000 ALTER TABLE `videometadatacountry` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `videometadatagenre` +-- + +DROP TABLE IF EXISTS `videometadatagenre`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `videometadatagenre` ( + `idvideo` int(10) unsigned NOT NULL, + `idgenre` int(10) unsigned NOT NULL, + KEY `idvideo` (`idvideo`), + KEY `idgenre` (`idgenre`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Dumping data for table `videometadatagenre` +-- + +LOCK TABLES `videometadatagenre` WRITE; +/*!40000 ALTER TABLE `videometadatagenre` DISABLE KEYS */; +/*!40000 ALTER TABLE `videometadatagenre` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `videosource` +-- + +DROP TABLE IF EXISTS `videosource`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `videosource` ( + `sourceid` int(10) unsigned NOT NULL auto_increment, + `name` varchar(128) NOT NULL default '', + `xmltvgrabber` varchar(128) default NULL, + `userid` varchar(128) NOT NULL default '', + `freqtable` varchar(16) NOT NULL default 'default', + `lineupid` varchar(64) default NULL, + `password` varchar(64) default NULL, + `useeit` smallint(6) NOT NULL default '0', + PRIMARY KEY (`sourceid`), + UNIQUE KEY `name` (`name`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Dumping data for table `videosource` +-- + +LOCK TABLES `videosource` WRITE; +/*!40000 ALTER TABLE `videosource` DISABLE KEYS */; +/*!40000 ALTER TABLE `videosource` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `videotypes` +-- + +DROP TABLE IF EXISTS `videotypes`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `videotypes` ( + `intid` int(10) unsigned NOT NULL auto_increment, + `extension` varchar(128) NOT NULL, + `playcommand` varchar(255) NOT NULL, + `f_ignore` tinyint(1) default NULL, + `use_default` tinyint(1) default NULL, + PRIMARY KEY (`intid`) +) ENGINE=MyISAM AUTO_INCREMENT=11 DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Dumping data for table `videotypes` +-- + +LOCK TABLES `videotypes` WRITE; +/*!40000 ALTER TABLE `videotypes` DISABLE KEYS */; +INSERT INTO `videotypes` (`intid`, `extension`, `playcommand`, `f_ignore`, `use_default`) VALUES (1,'txt','',1,0),(2,'log','',1,0),(3,'mpg','Internal',0,0),(4,'avi','',0,1),(5,'vob','Internal',0,0),(6,'mpeg','Internal',0,0),(7,'VIDEO_TS','Internal',0,0),(8,'iso','Internal',0,0),(9,'img','Internal',0,0),(10,'mkv','Internal',0,1); +/*!40000 ALTER TABLE `videotypes` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `weatherdatalayout` +-- + +DROP TABLE IF EXISTS `weatherdatalayout`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `weatherdatalayout` ( + `location` varchar(64) NOT NULL, + `dataitem` varchar(64) NOT NULL, + `weatherscreens_screen_id` int(10) unsigned NOT NULL, + `weathersourcesettings_sourceid` int(10) unsigned NOT NULL, + PRIMARY KEY (`location`,`dataitem`,`weatherscreens_screen_id`,`weathersourcesettings_sourceid`), + KEY `weatherdatalayout_FKIndex1` (`weatherscreens_screen_id`), + KEY `weatherdatalayout_FKIndex2` (`weathersourcesettings_sourceid`), + CONSTRAINT `weatherdatalayout_ibfk_1` FOREIGN KEY (`weatherscreens_screen_id`) REFERENCES `weatherscreens` (`screen_id`) ON DELETE CASCADE ON UPDATE CASCADE, + CONSTRAINT `weatherdatalayout_ibfk_2` FOREIGN KEY (`weathersourcesettings_sourceid`) REFERENCES `weathersourcesettings` (`sourceid`) ON UPDATE CASCADE +) ENGINE=InnoDB DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Dumping data for table `weatherdatalayout` +-- + +LOCK TABLES `weatherdatalayout` WRITE; +/*!40000 ALTER TABLE `weatherdatalayout` DISABLE KEYS */; +/*!40000 ALTER TABLE `weatherdatalayout` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `weatherscreens` +-- + +DROP TABLE IF EXISTS `weatherscreens`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `weatherscreens` ( + `screen_id` int(10) unsigned NOT NULL auto_increment, + `draworder` int(10) unsigned NOT NULL, + `container` varchar(64) NOT NULL, + `hostname` varchar(255) default NULL, + `units` tinyint(3) unsigned NOT NULL, + PRIMARY KEY (`screen_id`) +) ENGINE=InnoDB DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Dumping data for table `weatherscreens` +-- + +LOCK TABLES `weatherscreens` WRITE; +/*!40000 ALTER TABLE `weatherscreens` DISABLE KEYS */; +/*!40000 ALTER TABLE `weatherscreens` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `weathersourcesettings` +-- + +DROP TABLE IF EXISTS `weathersourcesettings`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `weathersourcesettings` ( + `sourceid` int(10) unsigned NOT NULL auto_increment, + `source_name` varchar(64) NOT NULL, + `update_timeout` int(10) unsigned NOT NULL default '600', + `retrieve_timeout` int(10) unsigned NOT NULL default '60', + `hostname` varchar(255) default NULL, + `path` varchar(255) default NULL, + `author` varchar(128) default NULL, + `version` varchar(32) default NULL, + `email` varchar(255) default NULL, + `types` mediumtext, + PRIMARY KEY (`sourceid`) +) ENGINE=InnoDB DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Dumping data for table `weathersourcesettings` +-- + +LOCK TABLES `weathersourcesettings` WRITE; +/*!40000 ALTER TABLE `weathersourcesettings` DISABLE KEYS */; +/*!40000 ALTER TABLE `weathersourcesettings` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `websites` +-- + +DROP TABLE IF EXISTS `websites`; +SET @saved_cs_client = @@character_set_client; +SET character_set_client = utf8; +CREATE TABLE `websites` ( + `grp` varchar(255) NOT NULL, + `dsc` varchar(255) default NULL, + `url` varchar(255) NOT NULL, + `updated` int(10) unsigned default NULL, + PRIMARY KEY (`url`) +) ENGINE=MyISAM DEFAULT CHARSET=latin1; +SET character_set_client = @saved_cs_client; + +-- +-- Dumping data for table `websites` +-- + +LOCK TABLES `websites` WRITE; +/*!40000 ALTER TABLE `websites` DISABLE KEYS */; +INSERT INTO `websites` (`grp`, `dsc`, `url`, `updated`) VALUES ('LinHES','','http://knoppmyth.net',NULL),('LinHES','','http://knoppmythwiki.org',NULL); +/*!40000 ALTER TABLE `websites` ENABLE KEYS */; +UNLOCK TABLES; +/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */; + +/*!40101 SET SQL_MODE=@OLD_SQL_MODE */; +/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */; +/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */; +/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */; +/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */; +/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */; +/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */; + +-- Dump completed on 2008-09-07 21:09:33 diff --git a/abs/core/mythtv/stable/mythdb-initial/mythdb.install b/abs/core/mythtv/stable/mythdb-initial/mythdb.install new file mode 100755 index 0000000..4834c69 --- /dev/null +++ b/abs/core/mythtv/stable/mythdb-initial/mythdb.install @@ -0,0 +1,31 @@ +mydate=`date +%m-%d-%y` +HOST=`hostname` +post_install() { +#echo backup the old database + mysqldump mythconverg >/data/database/mythconverg.${mydate}.sql +# echo dropping the old database + mysql -u root -e 'drop database mythconverg;' + mysql -u root -e 'create database mythconverg;' + echo installing the default database + if [ $HOST = 'larch5' ] + then + cp /data/database/mc.sql.initial /data/database/mc.sql.fixed + cp /data/database/permissions.sql /data/database/permissions.sql.fixed + else + sed -e "s/larch5/$HOST/g" /data/database/mc.sql.initial > /data/database/mc.sql.fixed + sed -e "s/larch5/$HOST/g" /data/database/permissions.sql > /data/database/permissions.sql.fixed + + fi + + mysql mythconverg < /data/database/mc.sql.fixed 2>/dev/null + mysql < /data/database/permissions.sql.fixed 2>/dev/null + + rm /data/database/mc.sql.initial +} +post_upgrade() { + echo "nothing to do" +} + +op=$1 +shift +$op $* diff --git a/abs/core/mythtv/stable/mythdb-initial/permissions.sql b/abs/core/mythtv/stable/mythdb-initial/permissions.sql new file mode 100755 index 0000000..acb4673 --- /dev/null +++ b/abs/core/mythtv/stable/mythdb-initial/permissions.sql @@ -0,0 +1,11 @@ + +GRANT ALL ON mythconverg.* TO mythtv@localhost IDENTIFIED BY "mythtv"; +GRANT ALL ON mythconverg.* TO mythtv@"%" IDENTIFIED BY "mythtv"; +GRANT ALL ON mythconverg.* TO mythtv@myhost IDENTIFIED BY "mythtv"; +GRANT FILE ON *.* TO 'mythtv'@'%'; +FLUSH PRIVILEGES; +GRANT CREATE TEMPORARY TABLES ON mythconverg.* TO mythtv@localhost IDENTIFIED BY "mythtv"; +GRANT CREATE TEMPORARY TABLES ON mythconverg.* TO mythtv@'%' IDENTIFIED BY "mythtv"; +GRANT CREATE TEMPORARY TABLES ON mythconverg.* TO mythtv@myhost IDENTIFIED BY "mythtv"; +FLUSH PRIVILEGES; +ALTER DATABASE mythconverg DEFAULT CHARACTER SET latin1; diff --git a/abs/core/mythtv/stable/mythflix/PKGBUILD b/abs/core/mythtv/stable/mythflix/PKGBUILD new file mode 100644 index 0000000..f613963 --- /dev/null +++ b/abs/core/mythtv/stable/mythflix/PKGBUILD @@ -0,0 +1,31 @@ +# $Id: PKGBUILD 356 2008-04-18 22:56:27Z aaron $ +# Maintainer: Juergen Hoetzel <juergen@archlinux.org> +# Maintainer: kleptophobiac@gmail.com + +pkgname=mythflix +pkgver=0.21 +pkgrel=1 +pkgdesc="Netflix access plugin for MythTV" +arch=('i686' 'x86_64') +url="http://www.mythtv.org" +license=('GPL') +depends=("mythtv>=${pkgver}") +source=("ftp://ftp.knoppmyth.net/R6/sources/mythplugins-$pkgver-fixes.tar.bz2") +md5sums=('af20a78ac66719feddf9a39f1a799ded') +groups=('mythtv-extras') + +build() { + cd $startdir/src/mythplugins-${pkgver} + . /etc/profile.d/qt3.sh + + # use QT3 qmake + export PATH=$QTDIR/bin:$PATH + ./configure --prefix=/usr --disable-all --enable-opengl --enable-mythflix + + qmake mythplugins.pro + make qmake || return 1 + make -j 2 || return 1 + + make INSTALL_ROOT=$startdir/pkg install +} + diff --git a/abs/core/mythtv/stable/mythgallery/PKGBUILD b/abs/core/mythtv/stable/mythgallery/PKGBUILD new file mode 100644 index 0000000..76a66c5 --- /dev/null +++ b/abs/core/mythtv/stable/mythgallery/PKGBUILD @@ -0,0 +1,32 @@ +# $Id: PKGBUILD 356 2008-04-18 22:56:27Z aaron $ +# Maintainer: Juergen Hoetzel <travis@archlinux.org> +# Contributor: kleptophobiac@gmail.com + +pkgname=mythgallery +pkgver=0.21 +pkgrel=1 +pkgdesc="Image gallery plugin for MythTV" +arch=('i686' 'x86_64') +url="http://www.mythtv.org" +license=('GPL') +depends=("mythtv>=${pkgver}" 'libexif' 'libtiff') +source=("ftp://ftp.knoppmyth.net/R6/sources/mythplugins-$pkgver-fixes.tar.bz2") +md5sums=('af20a78ac66719feddf9a39f1a799ded') +groups=('mythtv-extras') + +build() { + cd $startdir/src/mythplugins-${pkgver} + . /etc/profile.d/qt3.sh + + # use QT3 qmake + export PATH=$QTDIR/bin:$PATH + ./configure --prefix=/usr --disable-all --enable-opengl --enable-mythgallery --enable-exif + + qmake mythplugins.pro + make qmake || return 1 + make -j 2 || return 1 + + make INSTALL_ROOT=$startdir/pkg install +} + + diff --git a/abs/core/mythtv/stable/mythgame/PKGBUILD b/abs/core/mythtv/stable/mythgame/PKGBUILD new file mode 100644 index 0000000..33fb9a5 --- /dev/null +++ b/abs/core/mythtv/stable/mythgame/PKGBUILD @@ -0,0 +1,31 @@ +# $Id: PKGBUILD 356 2008-04-18 22:56:27Z aaron $ +# Maintainer: Juergen Hoetzel <juergen@archlinux.org> +# Contributor: kleptophobiac@gmail.com + +pkgname=mythgame +pkgver=0.21 +pkgrel=1 +pkgdesc="Emulation plugin for MythTV" +arch=('i686' 'x86_64') +url="http://www.mythtv.org" +license=('GPL') +depends=("mythtv>=${pkgver}" 'zlib') +source=("ftp://ftp.knoppmyth.net/R6/sources/mythplugins-$pkgver-fixes.tar.bz2") +md5sums=('af20a78ac66719feddf9a39f1a799ded') +groups=('mythtv-extras') + +build() { + cd $startdir/src/mythplugins-$pkgver + export QMAKESPEC='linux-g++' + source /etc/profile.d/qt3.sh + + ./configure --prefix=/usr --disable-all --enable-opengl --enable-mythgame + + qmake mythplugins.pro + make qmake || return 1 +# make -j 2 || return 1 + make || return 1 + + make INSTALL_ROOT=$startdir/pkg install +} + diff --git a/abs/core/mythtv/stable/mythmusic/PKGBUILD b/abs/core/mythtv/stable/mythmusic/PKGBUILD new file mode 100644 index 0000000..02adcce --- /dev/null +++ b/abs/core/mythtv/stable/mythmusic/PKGBUILD @@ -0,0 +1,33 @@ +# $Id: PKGBUILD 5680 2008-07-20 05:15:42Z eric $ +# Maintainer: Juergen Hoetzel <travis@archlinux.org> +# Contributor: kleptophobiac@gmail.com + +pkgname=mythmusic +pkgver=0.21 +pkgrel=2 +pkgdesc="Music playing plugin for MythTV" +arch=('i686' 'x86_64') +url="http://www.mythtv.org" +license=('GPL') +depends=("mythtv>=${pkgver}" 'libid3tag' 'libmad' 'libvorbis' 'flac>=1.1.4' 'libcdaudio' \ + 'cdparanoia' 'fftw2' 'sdl' 'faad2>=2.6.1' 'lame' 'taglib') +source=("ftp://ftp.knoppmyth.net/R6/sources/mythplugins-$pkgver-fixes.tar.bz2") +md5sums=('af20a78ac66719feddf9a39f1a799ded') +groups=('mythtv-extras') + +build() { + cd $startdir/src/mythplugins-${pkgver} + . /etc/profile.d/qt3.sh + + # use QT3 qmake + export PATH=$QTDIR/bin:$PATH + ./configure --prefix=/usr --disable-all --enable-mythmusic --enable-fftw \ + --enable-sdl --enable-aac --enable-opengl + + qmake mythplugins.pro + make qmake || return 1 + make -j 2 || return 1 + + make INSTALL_ROOT=$startdir/pkg install +} + diff --git a/abs/core/mythtv/stable/mythmusic/music_flac.patch b/abs/core/mythtv/stable/mythmusic/music_flac.patch new file mode 100644 index 0000000..b152249 --- /dev/null +++ b/abs/core/mythtv/stable/mythmusic/music_flac.patch @@ -0,0 +1,293 @@ +--- flacdecoder.cpp.old 2007-03-11 18:14:37.000000000 -0400 ++++ flacdecoder.cpp 2007-03-11 18:15:34.000000000 -0400 +@@ -17,7 +17,7 @@ + + #include <qtimer.h> + +-static FLAC__SeekableStreamDecoderReadStatus flacread(const FLAC__SeekableStreamDecoder *decoder, FLAC__byte bufferp[], unsigned *bytes, void *client_data) ++static FLAC__StreamDecoderReadStatus flacread(const FLAC__StreamDecoder *decoder, FLAC__byte bufferp[], unsigned *bytes, void *client_data) + { + decoder = decoder; + +@@ -26,27 +26,27 @@ + + if (len == -1) + { +- return FLAC__SEEKABLE_STREAM_DECODER_READ_STATUS_ERROR; ++ return FLAC__STREAM_DECODER_READ_STATUS_END_OF_STREAM; + } + + *bytes = len; +- return FLAC__SEEKABLE_STREAM_DECODER_READ_STATUS_OK; ++ return FLAC__STREAM_DECODER_READ_STATUS_CONTINUE; + } + +-static FLAC__SeekableStreamDecoderSeekStatus flacseek(const FLAC__SeekableStreamDecoder *decoder, FLAC__uint64 absolute_byte_offset, void *client_data) ++static FLAC__StreamDecoderSeekStatus flacseek(const FLAC__StreamDecoder *decoder, FLAC__uint64 absolute_byte_offset, void *client_data) + { + decoder = decoder; + FlacDecoder *dflac = (FlacDecoder *)client_data; + + if (!dflac->input()->isDirectAccess()) +- return FLAC__SEEKABLE_STREAM_DECODER_SEEK_STATUS_ERROR; ++ return FLAC__STREAM_DECODER_SEEK_STATUS_ERROR; + + if (dflac->input()->at(absolute_byte_offset)) +- return FLAC__SEEKABLE_STREAM_DECODER_SEEK_STATUS_OK; +- return FLAC__SEEKABLE_STREAM_DECODER_SEEK_STATUS_ERROR; ++ return FLAC__STREAM_DECODER_SEEK_STATUS_OK; ++ return FLAC__STREAM_DECODER_SEEK_STATUS_ERROR; + } + +-static FLAC__SeekableStreamDecoderTellStatus flactell(const FLAC__SeekableStreamDecoder *decoder, FLAC__uint64 *absolute_byte_offset, void *client_data) ++static FLAC__StreamDecoderTellStatus flactell(const FLAC__StreamDecoder *decoder, FLAC__uint64 *absolute_byte_offset, void *client_data) + { + decoder = decoder; + FlacDecoder *dflac = (FlacDecoder *)client_data; +@@ -54,20 +54,20 @@ + long t = dflac->input()->at(); + *absolute_byte_offset = t; + +- return FLAC__SEEKABLE_STREAM_DECODER_TELL_STATUS_OK; ++ return FLAC__STREAM_DECODER_TELL_STATUS_OK; + } + +-static FLAC__SeekableStreamDecoderLengthStatus flaclength(const FLAC__SeekableStreamDecoder *decoder, FLAC__uint64 *stream_length, void *client_data) ++static FLAC__StreamDecoderLengthStatus flaclength(const FLAC__StreamDecoder *decoder, FLAC__uint64 *stream_length, void *client_data) + { + decoder = decoder; + + FlacDecoder *dflac = (FlacDecoder *)client_data; + + *stream_length = dflac->input()->size(); +- return FLAC__SEEKABLE_STREAM_DECODER_LENGTH_STATUS_OK; ++ return FLAC__STREAM_DECODER_LENGTH_STATUS_OK; + } + +-static FLAC__bool flaceof(const FLAC__SeekableStreamDecoder *decoder, void *client_data) ++static FLAC__bool flaceof(const FLAC__StreamDecoder *decoder, void *client_data) + { + decoder = decoder; + +@@ -76,7 +76,7 @@ + return dflac->input()->atEnd(); + } + +-static FLAC__StreamDecoderWriteStatus flacwrite(const FLAC__SeekableStreamDecoder *decoder, const FLAC__Frame *frame, const FLAC__int32 * const buffer[], void *client_data) ++static FLAC__StreamDecoderWriteStatus flacwrite(const FLAC__StreamDecoder *decoder, const FLAC__Frame *frame, const FLAC__int32 * const buffer[], void *client_data) + { + decoder = decoder; + +@@ -132,7 +132,7 @@ + } + } + +-static void flacmetadata(const FLAC__SeekableStreamDecoder *decoder, const FLAC__StreamMetadata *metadata, void *client_data) ++static void flacmetadata(const FLAC__StreamDecoder *decoder, const FLAC__StreamMetadata *metadata, void *client_data) + { + decoder = decoder; + +@@ -156,11 +156,11 @@ + } + } + +-static void flacerror(const FLAC__SeekableStreamDecoder *decoder, FLAC__StreamDecoderErrorStatus status, void *client_data) ++static void flacerror(const FLAC__StreamDecoder *decoder, FLAC__StreamDecoderErrorStatus status, void *client_data) + { + decoder = decoder; + +- FLAC__FileDecoder *file_decoder = (FLAC__FileDecoder *)client_data; ++ FLAC__StreamDecoder *file_decoder = (FLAC__StreamDecoder *)client_data; + + file_decoder = file_decoder; + status = status; +@@ -262,17 +262,8 @@ + } + } + +- decoder = FLAC__seekable_stream_decoder_new(); +- FLAC__seekable_stream_decoder_set_md5_checking(decoder, false); +- FLAC__seekable_stream_decoder_set_read_callback(decoder, flacread); +- FLAC__seekable_stream_decoder_set_seek_callback(decoder, flacseek); +- FLAC__seekable_stream_decoder_set_tell_callback(decoder, flactell); +- FLAC__seekable_stream_decoder_set_length_callback(decoder, flaclength); +- FLAC__seekable_stream_decoder_set_eof_callback(decoder, flaceof); +- FLAC__seekable_stream_decoder_set_write_callback(decoder, flacwrite); +- FLAC__seekable_stream_decoder_set_metadata_callback(decoder, flacmetadata); +- FLAC__seekable_stream_decoder_set_error_callback(decoder, flacerror); +- FLAC__seekable_stream_decoder_set_client_data(decoder, this); ++ decoder = FLAC__stream_decoder_new(); ++ FLAC__stream_decoder_set_md5_checking(decoder, false); + + freq = 0; + bitrate = 0; +@@ -281,8 +272,17 @@ + totalTime = 0; + totalTime = totalTime < 0 ? 0 : totalTime; + +- FLAC__seekable_stream_decoder_init(decoder); +- FLAC__seekable_stream_decoder_process_until_end_of_metadata(decoder); ++ FLAC__stream_decoder_init_stream(decoder, ++ flacread, ++ flacseek, ++ flactell, ++ flaclength, ++ flaceof, ++ flacwrite, ++ flacmetadata, ++ flacerror, ++ this); ++ FLAC__stream_decoder_process_until_end_of_metadata(decoder); + + inited = TRUE; + return TRUE; +@@ -295,8 +295,8 @@ + + void FlacDecoder::deinit() + { +- FLAC__seekable_stream_decoder_finish(decoder); +- FLAC__seekable_stream_decoder_delete(decoder); ++ FLAC__stream_decoder_finish(decoder); ++ FLAC__stream_decoder_delete(decoder); + + if (input()->isOpen()) + input()->close(); +@@ -330,7 +330,7 @@ + } + + bool flacok = true; +- FLAC__SeekableStreamDecoderState decoderstate; ++ FLAC__StreamDecoderState decoderstate; + + while (! done && ! finish) { + lock(); +@@ -340,12 +340,12 @@ + FLAC__uint64 sample = (FLAC__uint64)(seekTime * 44100.0); + if (sample > totalsamples - 50) + sample = totalsamples - 50; +- FLAC__seekable_stream_decoder_seek_absolute(decoder, sample); ++ FLAC__stream_decoder_seek_absolute(decoder, sample); + seekTime = -1.0; + } + +- flacok = FLAC__seekable_stream_decoder_process_single(decoder); +- decoderstate = FLAC__seekable_stream_decoder_get_state(decoder); ++ flacok = FLAC__stream_decoder_process_single(decoder); ++ decoderstate = FLAC__stream_decoder_get_state(decoder); + + if (decoderstate == 0 || decoderstate == 1) + { +--- flacdecoder.h.old 2007-03-11 18:14:37.000000000 -0400 ++++ flacdecoder.h 2007-03-11 18:14:12.000000000 -0400 +@@ -35,7 +35,7 @@ + char *output_buf; + ulong output_bytes, output_at; + +- FLAC__SeekableStreamDecoder *decoder; ++ FLAC__StreamDecoder *decoder; + + unsigned int bks; + bool done, finish; +--- flacencoder.cpp.old 2007-03-11 18:14:37.000000000 -0400 ++++ flacencoder.cpp 2007-03-11 18:14:12.000000000 -0400 +@@ -9,7 +9,7 @@ + #include "flacencoder.h" + #include "metaioflacvorbiscomment.h" + +-#include <FLAC/file_encoder.h> ++#include <FLAC/stream_encoder.h> + #include <FLAC/assert.h> + #include <mythtv/mythcontext.h> + +@@ -29,32 +29,32 @@ + int rice_parameter_search_dist = 0; + int max_lpc_order = 8; + +- encoder = FLAC__file_encoder_new(); ++ encoder = FLAC__stream_encoder_new(); + +- FLAC__file_encoder_set_streamable_subset(encoder, true); +- FLAC__file_encoder_set_do_mid_side_stereo(encoder, do_mid_side); +- FLAC__file_encoder_set_loose_mid_side_stereo(encoder, loose_mid_side); +- FLAC__file_encoder_set_channels(encoder, NUM_CHANNELS); +- FLAC__file_encoder_set_bits_per_sample(encoder, 16); +- FLAC__file_encoder_set_sample_rate(encoder, 44100); +- FLAC__file_encoder_set_blocksize(encoder, blocksize); +- FLAC__file_encoder_set_max_lpc_order(encoder, max_lpc_order); +- FLAC__file_encoder_set_qlp_coeff_precision(encoder, qlp_coeff_precision); +- FLAC__file_encoder_set_do_qlp_coeff_prec_search(encoder, false); +- FLAC__file_encoder_set_do_escape_coding(encoder, do_escape_coding); +- FLAC__file_encoder_set_do_exhaustive_model_search(encoder, ++ FLAC__stream_encoder_set_streamable_subset(encoder, true); ++ FLAC__stream_encoder_set_do_mid_side_stereo(encoder, do_mid_side); ++ FLAC__stream_encoder_set_loose_mid_side_stereo(encoder, loose_mid_side); ++ FLAC__stream_encoder_set_channels(encoder, NUM_CHANNELS); ++ FLAC__stream_encoder_set_bits_per_sample(encoder, 16); ++ FLAC__stream_encoder_set_sample_rate(encoder, 44100); ++ FLAC__stream_encoder_set_blocksize(encoder, blocksize); ++ FLAC__stream_encoder_set_max_lpc_order(encoder, max_lpc_order); ++ FLAC__stream_encoder_set_qlp_coeff_precision(encoder, qlp_coeff_precision); ++ FLAC__stream_encoder_set_do_qlp_coeff_prec_search(encoder, false); ++ FLAC__stream_encoder_set_do_escape_coding(encoder, do_escape_coding); ++ FLAC__stream_encoder_set_do_exhaustive_model_search(encoder, + do_exhaustive_model_search); +- FLAC__file_encoder_set_min_residual_partition_order(encoder, ++ FLAC__stream_encoder_set_min_residual_partition_order(encoder, + min_residual_partition_order); +- FLAC__file_encoder_set_max_residual_partition_order(encoder, ++ FLAC__stream_encoder_set_max_residual_partition_order(encoder, + max_residual_partition_order); +- FLAC__file_encoder_set_rice_parameter_search_dist(encoder, ++ FLAC__stream_encoder_set_rice_parameter_search_dist(encoder, + rice_parameter_search_dist); + +- FLAC__file_encoder_set_filename(encoder, outfile.local8Bit()); ++ + +- int ret = FLAC__file_encoder_init(encoder); +- if (ret != FLAC__FILE_ENCODER_OK) ++ int ret = FLAC__stream_encoder_init_file(encoder, outfile.local8Bit(), NULL, NULL); ++ if (ret != FLAC__STREAM_ENCODER_OK) + { + VERBOSE(VB_GENERAL, QString("Error initializing FLAC encoder." + " Got return code: %1").arg(ret)); +@@ -70,8 +70,8 @@ + + if (encoder) + { +- FLAC__file_encoder_finish(encoder); +- FLAC__file_encoder_delete(encoder); ++ FLAC__stream_encoder_finish(encoder); ++ FLAC__stream_encoder_delete(encoder); + } + + if (metadata) +@@ -102,7 +102,7 @@ + + if(sampleindex == MAX_SAMPLES || (length == 0 && sampleindex > 0) ) + { +- if (!FLAC__file_encoder_process(encoder, ++ if (!FLAC__stream_encoder_process(encoder, + (const FLAC__int32 * const *) input, + sampleindex)) + { +--- flacencoder.h.old 2007-03-11 18:14:37.000000000 -0400 ++++ flacencoder.h 2007-03-11 18:14:12.000000000 -0400 +@@ -4,7 +4,7 @@ + #include <qstring.h> + + #define HAVE_INTTYPES_H +-#include <FLAC/file_encoder.h> ++#include <FLAC/stream_encoder.h> + + #include "encoder.h" + +@@ -21,7 +21,7 @@ + int addSamples(int16_t *bytes, unsigned int len); + + private: +- FLAC__FileEncoder *encoder; ++ FLAC__StreamEncoder *encoder; + unsigned int sampleindex; + FLAC__int32 inputin[NUM_CHANNELS][MAX_SAMPLES]; + FLAC__int32 *input[NUM_CHANNELS]; diff --git a/abs/core/mythtv/stable/mythmusic/mythmusic-0.21.patch b/abs/core/mythtv/stable/mythmusic/mythmusic-0.21.patch new file mode 100644 index 0000000..f3fa930 --- /dev/null +++ b/abs/core/mythtv/stable/mythmusic/mythmusic-0.21.patch @@ -0,0 +1,22 @@ +diff -ur mythplugins-0.21.old/mythmusic/mythmusic/aacdecoder.cpp mythplugins-0.21/mythmusic/mythmusic/aacdecoder.cpp +--- mythplugins-0.21.old/mythmusic/mythmusic/aacdecoder.cpp 2007-08-25 17:49:44.000000000 +0200 ++++ mythplugins-0.21/mythmusic/mythmusic/aacdecoder.cpp 2008-03-27 00:16:38.000000000 +0100 +@@ -19,6 +19,7 @@ + #include <qobject.h> + #include <qiodevice.h> + #include <qfile.h> ++#include <stdlib.h> + + #include "aacdecoder.h" + #include "constants.h" +diff -ur mythplugins-0.21.old/mythmusic/mythmusic/metaiomp4.cpp mythplugins-0.21/mythmusic/mythmusic/metaiomp4.cpp +--- mythplugins-0.21.old/mythmusic/mythmusic/metaiomp4.cpp 2006-08-22 04:06:03.000000000 +0200 ++++ mythplugins-0.21/mythmusic/mythmusic/metaiomp4.cpp 2008-03-27 00:17:05.000000000 +0100 +@@ -3,6 +3,7 @@ + #include <fcntl.h> + #include <unistd.h> + #include <sys/types.h> ++#include <stdlib.h> + + using namespace std; + diff --git a/abs/core/mythtv/stable/mythnews/PKGBUILD b/abs/core/mythtv/stable/mythnews/PKGBUILD new file mode 100644 index 0000000..9133755 --- /dev/null +++ b/abs/core/mythtv/stable/mythnews/PKGBUILD @@ -0,0 +1,31 @@ +# $Id: PKGBUILD 356 2008-04-18 22:56:27Z aaron $ +# Maintainer: Juergen Hoetzel <travis@archlinux.org> +# Contributor: kleptophobiac@gmail.com + +pkgname=mythnews +pkgver=0.21 +pkgrel=1 +pkgdesc="News checking plugin for MythTV" +arch=('i686' 'x86_64') +url="http://www.mythtv.org" +license=('GPL') +depends=("mythtv>=${pkgver}") +source=("ftp://ftp.knoppmyth.net/R6/sources/mythplugins-$pkgver-fixes.tar.bz2") +md5sums=('af20a78ac66719feddf9a39f1a799ded') +groups=('mythtv-extras') + +build() { + cd $startdir/src/mythplugins-${pkgver} + . /etc/profile.d/qt3.sh + + # use QT3 qmake + export PATH=$QTDIR/bin:$PATH + ./configure --prefix=/usr --disable-all --enable-mythnews + + qmake mythplugins.pro + make qmake || return 1 + make -j 2 || return 1 + + make INSTALL_ROOT=$startdir/pkg install +} + diff --git a/abs/core/mythtv/stable/mythphone/PKGBUILD b/abs/core/mythtv/stable/mythphone/PKGBUILD new file mode 100644 index 0000000..24cd04f --- /dev/null +++ b/abs/core/mythtv/stable/mythphone/PKGBUILD @@ -0,0 +1,32 @@ +# $Id: PKGBUILD 356 2008-04-18 22:56:27Z aaron $ +# Maintainer: Juergen Hoetzel <travis@archlinux.org> +# Contributor: kleptophobiac@gmail.com + +pkgname=mythphone +pkgver=0.21 +pkgrel=1 +pkgdesc="Plugin that allows phone calls to be made to MythTv" +arch=('i686' 'x86_64') +url="http://www.mythtv.org" +license=('GPL') +depends=("mythtv>=${pkgver}") +source=("ftp://ftp.knoppmyth.net/R6/sources/mythplugins-$pkgver-fixes.tar.bz2") +md5sums=('af20a78ac66719feddf9a39f1a799ded') +groups=('mythtv-extras') + +build() { + cd $startdir/src/mythplugins-${pkgver} + . /etc/profile.d/qt3.sh + + # use QT3 qmake + export PATH=$QTDIR/bin:$PATH + ./configure --prefix=/usr --enable-opengl --disable-all --enable-mythphone || return 1 + + qmake mythplugins.pro || return 1 + make qmake || return 1 + sed -i 's#kde3#kde#' ./mythphone/mythphone/Makefile || return 1 + make -j 2 || return 1 + + make INSTALL_ROOT=$startdir/pkg install +} + diff --git a/abs/core/mythtv/stable/myththemes/PKGBUILD b/abs/core/mythtv/stable/myththemes/PKGBUILD new file mode 100644 index 0000000..5223b92 --- /dev/null +++ b/abs/core/mythtv/stable/myththemes/PKGBUILD @@ -0,0 +1,32 @@ +# $Id: PKGBUILD 356 2008-04-18 22:56:27Z aaron $ +# Maintainer: Juergen Hoetzel <juergen@archlinux.org> +# Contributor: kleptophobiac@gmail.com + +pkgname=myththemes +pkgver=0.21 +pkgrel=1 +pkgdesc="Themes for MythTV" +arch=('i686' 'x86_64') +url="http://www.mythtv.org/" +license=('GPL') +depends=("mythtv>=${pkgver}") +source=("ftp://ftp.knoppmyth.net/R6/sources/${pkgname}-${pkgver}-fixes.tar.bz2") +md5sums=('f13db28f928d70a11eaf416970d06eda') +groups=('mythtv-extras') + +build() { + cd $startdir/src/$pkgname-$pkgver + . /etc/profile.d/qt3.sh + + # use QT3 qmake + export PATH=$QTDIR/bin:$PATH + ./configure --prefix=/usr || return 1 + + qmake $pkgname.pro + make qmake || return 1 + make || return 1 + + # basic install + make INSTALL_ROOT=$startdir/pkg install || return 1 +} + diff --git a/abs/core/mythtv/stable/mythtv/PKGBUILD b/abs/core/mythtv/stable/mythtv/PKGBUILD new file mode 100644 index 0000000..72c6855 --- /dev/null +++ b/abs/core/mythtv/stable/mythtv/PKGBUILD @@ -0,0 +1,70 @@ +# $Id: PKGBUILD 356 2008-04-18 22:56:27Z aaron $ +# Contributor: <kleptophobiac@gmail.com> +# Contributor: dorphell <dorphell@archlinux.org> +# Maintainer: Paul Mattal <paul@archlinux.org> + +pkgname=mythtv +pkgver=0.21 +pkgrel=4 +pkgdesc="A Homebrew PVR project" +arch=('i686' 'x86_64') +depends=('bash' 'mysql-clients>=5.0' 'qt3' 'lame' 'lirc-utils' 'ffmpeg' \ + 'libxvmc') +backup=(etc/mythtv/mythbackend.conf etc/mythtv/mysql.txt) +source=(ftp://ftp.knoppmyth.net/R6/sources/${pkgname}-${pkgver}-fixes.tar.bz2 \ + mythbackend\ + QUICKSTART.archlinux) +md5sums=('08506f0c5120c072085b6995f529167a' '7ef6de58240e7aad389a0b13d91b1cf6'\ + 'a0ecb7f476cb71c0c1ac90d349fc7695') +license=('GPL2') +makedepends=(libgl subversion) +groups=('pvr') +url="http://www.mythtv.org/" +install=mythtv.install + +build() { + cd $startdir/src/${pkgname}-${pkgver} || return 1 + . /etc/profile.d/qt3.sh + + # use QT3 qmake + export PATH=$QTDIR/bin:$PATH + [ "$CARCH" = "i686" ] && ARCH="i686" + [ "$CARCH" = "x86_64" ] && ARCH="x86-64" + + ./configure --prefix=/usr --cpu=${ARCH} --enable-mmx --enable-audio-oss \ + --enable-audio-alsa --enable-dvb --enable-lirc --enable-joystick-menu \ + --disable-firewire --enable-v4l --enable-ivtv --enable-dvb \ + --dvb-path=/usr/include/linux/dvb --enable-xvmc --disable-ffmpeg \ + --enable-xvmc-pro --enable-xvmc-vld --enable-opengl-vsync \ + --disable-audio-jack --disable-audio-arts || return 1 + + # build + #needs the subversion program + pkgversubversion=`svnversion` + echo $pkgversubversion + sed -i -e "s/\`(svnversion \$\${SVNTREEDIR} 2>\/dev\/null) || echo Unknown\`/$pkgversubversion/" version.pro + + +# qmake mythtv.pro || return 1 +# make qmake || return 1 + make || return 1 + + # basic install + make INSTALL_ROOT=$startdir/pkg install || return 1 + + # install db schema + install -m0644 database/mc.sql $startdir/pkg/usr/share/mythtv/ \ + || return 1 + install -D -m0755 ../mythbackend $startdir/pkg/etc/rc.d/mythbackend \ + || return 1 + cp -r docs $startdir/pkg/usr/share/mythtv/ || return 1 + cp ../QUICKSTART.archlinux $startdir/pkg/usr/share/mythtv/ \ + || return 1 + + # install contrib + mkdir -p $startdir/pkg/usr/share/mythtv/contrib || return 1 + install -m0755 contrib/* $startdir/pkg/usr/share/mythtv/contrib + + # set suid on mythfrontend + chmod a+s $startdir/pkg/usr/bin/mythfrontend +} diff --git a/abs/core/mythtv/stable/mythtv/QUICKSTART.archlinux b/abs/core/mythtv/stable/mythtv/QUICKSTART.archlinux new file mode 100644 index 0000000..310705c --- /dev/null +++ b/abs/core/mythtv/stable/mythtv/QUICKSTART.archlinux @@ -0,0 +1,69 @@ +MythTV QUICKSTART
+=================
+This Arch Linux package provides a generic MythTV installation. It
+requires extensive user configuration. This is a skeletal document, and
+more extensive information is available in /usr/share/mythtv/docs.
+
+MythTV is split into a backend and a frontend. The backend records
+television programming, keeps up with scheduling, does commercial
+flagging, transcoding, and other such jobs. The frontend provides a
+pretty GUI which allows playback and edition of the recorded programs.
+It also provides a means to schedule recordings. There are a number of
+plugins available for MythTV, and most of the official ones are
+available as Arch packages. There are two configurations; the backend
+and frontend can be on the same machine, or on two different machines on
+the same network.
+
+Backend Configuration
+---------------------
+MythTV keeps the majority of its settings and program information in a
+mysql database. Before running the backend configuration program, it is
+necessary to initialize the datase. Make sure mysql is running properly.
+
+# mysql < /usr/share/mythtv/mc.sql
+
+If your frontend is going to be remote, you must allow other computers
+on your network to have access to your database. Substitute 192.168.1.%
+with whatever IP range you use. If you have a root mysql password (as
+you should), leave the -p in the mysql command line. Otherwise remove
+the switch.
+
+# mysql -u root -p
+ mysql> connect mythconverg;
+ mysql> grant all on mythconverg.* to mythtv@"192.168.1.%" identified by "mythtv";
+ mysql> flush privileges;
+ mysql> quit
+
+In order to configure the MythTV backend, you will need to run the
+mythtv-setup program. Note that this requires X. If your backend is
+headless, considering using vnc as a quick and dirty "fix".
+
+# mythtv-setup
+
+Go through all the menus. You will need to know information like your
+capture card device (/dev/v4l/video[0-9]) and your program information
+acquisition method. United States users will most likely subscribe to
+Zap2it Labs' DataDirect service. It requires that users take a survey
+every three months in order to continue service. This isn't as hard as
+it sounds.
+
+It is necessary to update the database with all the current TV listings.
+Run the mythfilldatabase program to grab the listings using whatever
+method you specified in mythtv-setup.
+
+# mythfilldatabase
+
+Run mythbackend from the command line to make sure everything starts ok.
+
+# mythbackend
+
+If so, you may kill the task with "ctrl-c" on your keyboard, and add the
+backend to /etc/rc.conf. In the DAEMONS line, just add "mythbackend" to
+the list.
+
+In the future, you will need to run mythfilldatabase regularly. I allow
+my frontend computer to do this, as it runs continuously, and it is an
+option within MythTV. Otherwise, you can set up a cron job, or move
+mythfilldatabasecron to /etc/cron.daily
+
+cp /usr/share/mythtv/mythfilldatabasecron /etc/cron.daily
diff --git a/abs/core/mythtv/stable/mythtv/mythbackend b/abs/core/mythtv/stable/mythtv/mythbackend new file mode 100755 index 0000000..93773a2 --- /dev/null +++ b/abs/core/mythtv/stable/mythtv/mythbackend @@ -0,0 +1,38 @@ +#!/bin/bash + +. /etc/rc.conf +. /etc/rc.d/functions + +PID=`pidof -o %PPID /usr/bin/mythbackend` +case "$1" in + start) + stat_busy "Starting MythTV Backend" + [ ! -e /var/run/mysqld.pid ] && echo -n "mysqld not started" && stat_fail && exit + [ -z "$PID" ] && /usr/bin/mythbackend -d -l /var/log/mythbackend.log -v important + if [ $? -gt 0 ]; then + stat_fail + else + echo $PID > /var/run/mythbackend.pid + add_daemon mythbackend + stat_done + fi + ;; + stop) + stat_busy "Stopping MythTV Backend" + [ ! -z "$PID" ] && kill $PID &>/dev/null + if [ $? -gt 0 ]; then + stat_fail + else + rm_daemon mythbackend + stat_done + fi + ;; + restart) + $0 stop + sleep 1s + $0 start + ;; + *) + echo "usage: $0 {start|stop|restart}" +esac +exit 0 diff --git a/abs/core/mythtv/stable/mythtv/mythtv.install b/abs/core/mythtv/stable/mythtv/mythtv.install new file mode 100644 index 0000000..c460f19 --- /dev/null +++ b/abs/core/mythtv/stable/mythtv/mythtv.install @@ -0,0 +1,13 @@ +# arg 1: the new package version +post_install() { + echo "See \"MythTV\" on the Archlinux Wiki for installation information - Extensive!!" +} + +# arg 1: the old package version +post_remove() { + echo -e "NOTE: mysql database was not removed. To remove run:\nmysql -u root -e 'drop database mythconverg;'" +} + +op=$1 +shift +$op $* diff --git a/abs/core/mythtv/stable/mythvideo/PKGBUILD b/abs/core/mythtv/stable/mythvideo/PKGBUILD new file mode 100644 index 0000000..21f2a22 --- /dev/null +++ b/abs/core/mythtv/stable/mythvideo/PKGBUILD @@ -0,0 +1,36 @@ +# $Id: PKGBUILD 356 2008-04-18 22:56:27Z aaron $ +# Maintainer: Juergen Hoetzel <travis@archlinux.org> +# Contributor: kleptophobiac@gmail.com + +pkgname=mythvideo +pkgver=0.21 +pkgrel=2 +pkgdesc="Video playback and browsing plugin for MythTV" +arch=('i686' 'x86_64') +url="http://www.mythtv.org" +license=('GPL') +depends=("mythtv>=${pkgver}" 'mplayer' 'perlxml' 'perl-libwww' 'perl-uri' 'perl-xml-simple' 'ffmpeg') +source=("ftp://ftp.knoppmyth.net/R6/sources/mythplugins-$pkgver-fixes.tar.bz2"\ + mtd) +md5sums=('af20a78ac66719feddf9a39f1a799ded' '476c12ba074794ad7f4ae092bdf949d6') +replaces=('mythdvd') +groups=('mythtv-extras') + +build() { + cd $startdir/src/mythplugins-${pkgver} + . /etc/profile.d/qt3.sh + + # use QT3 qmake + export PATH=$QTDIR/bin:$PATH + + ./configure --prefix=/usr --disable-all --enable-mythvideo + + qmake mythplugins.pro + make qmake || return 1 + make -j 2 || return 1 + + make INSTALL_ROOT=$startdir/pkg install + install -D -m755 ../mtd $startdir/pkg/etc/rc.d/mtd +} + + diff --git a/abs/core/mythtv/stable/mythvideo/mtd b/abs/core/mythtv/stable/mythvideo/mtd new file mode 100644 index 0000000..1f46dfe --- /dev/null +++ b/abs/core/mythtv/stable/mythvideo/mtd @@ -0,0 +1,36 @@ +#!/bin/bash + +. /etc/rc.conf +. /etc/rc.d/functions + +PID=`pidof -o %PPID /usr/bin/mtd` +case "$1" in + start) + stat_busy "Starting Myth Transcoding Daemon" + [ -z "$PID" ] && /usr/bin/mtd -d + if [ $? -gt 0 ]; then + stat_fail + else + echo $PID > /var/run/mtd.pid + add_daemon mythtranscode + stat_done + fi + ;; + stop) + stat_busy "Stopping Myth Transcoding Daemon" + [ ! -z "$PID" ] && kill $PID &>/dev/null + if [ $? -gt 0 ]; then + stat_fail + else + rm_daemon mtd + stat_done + fi + ;; + restart) + $0 stop + $0 start + ;; + *) + echo "usage: $0 {start|stop|restart}" +esac +exit 0 diff --git a/abs/core/mythtv/stable/mythweather/PKGBUILD b/abs/core/mythtv/stable/mythweather/PKGBUILD new file mode 100644 index 0000000..ce2894a --- /dev/null +++ b/abs/core/mythtv/stable/mythweather/PKGBUILD @@ -0,0 +1,32 @@ +# $Id: PKGBUILD 356 2008-04-18 22:56:27Z aaron $ +# Maintainer: Juergen Hoetzel <juergen@archlinux.org> +# Contributor: kleptophobiac@gmail.com + +pkgname=mythweather +pkgver=0.21 +pkgrel=1 +pkgdesc="Weather checking plugin for MythTV" +arch=('i686' 'x86_64') +url="http://www.mythtv.org" +license=('GPL') +depends=("mythtv>=${pkgver}" 'wget') +source=("ftp://ftp.knoppmyth.net/R6/sources/mythplugins-$pkgver-fixes.tar.bz2") +md5sums=('af20a78ac66719feddf9a39f1a799ded') +groups=('mythtv-extras') + +build() { + cd $startdir/src/mythplugins-${pkgver} + . /etc/profile.d/qt3.sh + + # use QT3 qmake + export PATH=$QTDIR/bin:$PATH + + ./configure --prefix=/usr --enable-opengl --disable-all --enable-mythweather + + qmake mythplugins.pro + make qmake || return 1 + make -j 2 || return 1 + + make INSTALL_ROOT=$startdir/pkg install +} + diff --git a/abs/core/mythtv/stable/mythweb/PKGBUILD b/abs/core/mythtv/stable/mythweb/PKGBUILD new file mode 100644 index 0000000..e01323c --- /dev/null +++ b/abs/core/mythtv/stable/mythweb/PKGBUILD @@ -0,0 +1,27 @@ +# $Id: PKGBUILD 356 2008-04-18 22:56:27Z aaron $ +# Maintainer: Juergen Hoetzel <juergen@archlinux.org> +# Contributor: Philipp Giebel <arch@ambience-design.net> + +pkgname=mythweb +pkgver=0.21 +pkgrel=1 +pkgdesc="Web interface for MythTV's backend" +arch=('i686' 'x86_64') +url="http://www.mythtv.org" +license=('GPL') +depends=("mythtv>=${pkgver}" 'apache' 'php') +install=mythweb.install +source=("ftp://ftp.knoppmyth.net/R6/sources/mythplugins-$pkgver-fixes.tar.bz2") +md5sums=('af20a78ac66719feddf9a39f1a799ded') +groups=('mythtv-extras') + +build() { + mkdir -p $startdir/pkg/srv/www/mythweb/{image_cache,php_sessions} + cp -r $startdir/src/mythplugins-$pkgver/$pkgname/* $startdir/pkg/srv/www/mythweb + cp $startdir/src/mythplugins-$pkgver/$pkgname/data/.htaccess $startdir/pkg/srv/www/mythweb + rm $startdir/pkg/srv/www/mythweb/README + chown -R nobody:nobody $startdir/pkg/srv/www/mythweb + chmod g+rw $startdir/pkg/srv/www/mythweb/{image_cache,php_sessions,data} +} + + diff --git a/abs/core/mythtv/stable/mythweb/mythweb.install b/abs/core/mythtv/stable/mythweb/mythweb.install new file mode 100644 index 0000000..470cbd1 --- /dev/null +++ b/abs/core/mythtv/stable/mythweb/mythweb.install @@ -0,0 +1,10 @@ +post_install() { + echo "You must create a symlink from /home/httpd/html/mythweb/video_dir" + echo "to your MythTV recordings directory. Don't forget to change the" + echo "permissions so that the webserver can read those files and create" + echo "thumbnails." +} + +op=$1 +shift +$op $* |