From 04afbf26fc41bb44d1981ecc5acf0ed7bf72129f Mon Sep 17 00:00:00 2001 From: Cecil Date: Sun, 30 Jan 2011 21:16:37 -0800 Subject: gnome-keyring:bumped to latest. --- abs/extra/gnome-keyring/PKGBUILD | 34 +++++++++++---------------- abs/extra/gnome-keyring/gnome-keyring.install | 16 ++++--------- 2 files changed, 18 insertions(+), 32 deletions(-) diff --git a/abs/extra/gnome-keyring/PKGBUILD b/abs/extra/gnome-keyring/PKGBUILD index d0ea53d..5da3d28 100644 --- a/abs/extra/gnome-keyring/PKGBUILD +++ b/abs/extra/gnome-keyring/PKGBUILD @@ -1,34 +1,28 @@ -#$Id: PKGBUILD 15806 2008-10-19 09:55:58Z jgc $ -#Maintainer: Jan De Groot +#$Id: PKGBUILD 97123 2010-10-26 16:27:27Z ibiru $ +# Maintainer: Jan De Groot pkgname=gnome-keyring -pkgver=2.24.1 +pkgver=2.32.1 pkgrel=1 pkgdesc="GNOME Password Management daemon" arch=(i686 x86_64) license=('GPL' 'LGPL') -depends=('gconf>=2.24.0' 'hal>=0.5.11') -makedepends=('perlxml' 'pkgconfig') +depends=('gtk2>=2.22.0' 'dconf') +makedepends=('intltool' 'pkgconfig' 'python2') +groups=('gnome') options=('!libtool' '!emptydirs') url="http://www.gnome.org" install=gnome-keyring.install -source=(http://ftp.gnome.org/pub/gnome/sources/${pkgname}/2.24/${pkgname}-${pkgver}.tar.bz2 - gnome-keyring.service) -md5sums=('aa5552dc129f3509ee39145b7f0bf977' '16062d82eb8062201fb24f3e0ceb49a6') +source=(http://ftp.gnome.org/pub/gnome/sources/${pkgname}/2.32/${pkgname}-${pkgver}.tar.bz2) +sha256sums=('31fecec1430a97f59a6159a5a2ea8d6a1b44287f1e9e595b3594df46bf7f18f9') build() { cd "${srcdir}/${pkgname}-${pkgver}" ./configure --prefix=/usr --sysconfdir=/etc \ - --localstatedir=/var --disable-static \ - --libexecdir=/usr/lib/gnome-keyring \ - --with-pam-dir=/lib/security || return 1 - make || return 1 - make -j1 GCONF_DISABLE_MAKEFILE_SCHEMA_INSTALL=1 DESTDIR="${pkgdir}" install || return 1 - - install -m755 -d "${pkgdir}/usr/share/dbus-1/services" - install -m644 "${srcdir}/gnome-keyring.service" "${pkgdir}/usr/share/dbus-1/services/" || return 1 - - install -m755 -d "${pkgdir}/usr/share/gconf/schemas" - gconf-merge-schema "${pkgdir}/usr/share/gconf/schemas/${pkgname}.schemas" ${pkgdir}/etc/gconf/schemas/*.schemas || return 1 - rm -f ${pkgdir}/etc/gconf/schemas/*.schemas + --localstatedir=/var --disable-static \ + --libexecdir=/usr/lib/gnome-keyring \ + --with-pam-dir=/lib/security --with-root-certs=/etc/ssl/certs \ + --disable-schemas-compile + make + make DESTDIR="${pkgdir}" install } diff --git a/abs/extra/gnome-keyring/gnome-keyring.install b/abs/extra/gnome-keyring/gnome-keyring.install index 8874c6e..e5204bc 100644 --- a/abs/extra/gnome-keyring/gnome-keyring.install +++ b/abs/extra/gnome-keyring/gnome-keyring.install @@ -1,19 +1,11 @@ -pkgname=gnome-keyring - post_install() { - usr/sbin/gconfpkg --install ${pkgname} -} - -pre_upgrade() { - pre_remove $1 + usr/bin/glib-compile-schemas usr/share/glib-2.0/schemas } post_upgrade() { - post_install $1 + post_install $1 } -pre_remove() { - if [ -f usr/share/gconf/${pkgname}.schemas ]; then - usr/sbin/gconfpkg --uninstall ${pkgname} - fi +post_remove() { + post_install $1 } -- cgit v0.12 From ba384708e928b18cfa3b3dd648cee3194b266fcb Mon Sep 17 00:00:00 2001 From: Cecil Date: Sun, 30 Jan 2011 21:22:29 -0800 Subject: dconf:initial inclusion. Dep of gnome-keyring. --- abs/extra/dconf/PKGBUILD | 26 ++++++++++++++++++++++++++ abs/extra/dconf/dconf.install | 11 +++++++++++ 2 files changed, 37 insertions(+) create mode 100644 abs/extra/dconf/PKGBUILD create mode 100644 abs/extra/dconf/dconf.install diff --git a/abs/extra/dconf/PKGBUILD b/abs/extra/dconf/PKGBUILD new file mode 100644 index 0000000..4d95f6b --- /dev/null +++ b/abs/extra/dconf/PKGBUILD @@ -0,0 +1,26 @@ +# $Id: +# Maintainer: Ionut Biru +pkgname=dconf +pkgver=0.5.1 +pkgrel=1 +pkgdesc="A low-level configuration system." +arch=(i686 x86_64) +url="http://live.gnome.org/dconf" +license=('LGPL2.1') +depends=('glib2>=2.25.17') +makedepends=('vala' 'gobject-introspection' 'gtk2') +optdepends=('gtk2: for dconf-editor') +install=dconf.install +source=(http://download.gnome.org/sources/${pkgname}/0.5/${pkgname}-${pkgver}.tar.bz2) +sha256sums=('0083d70e1b5e540d8d4b3f04fa5d17dff4c574136682fe3bdd9b5ecc196ec4f6') + +build() { + cd "$srcdir/$pkgname-$pkgver" + + ./configure --prefix=/usr \ + --libexecdir=/usr/lib/dconf + make + make DESTDIR="$pkgdir/" install +} + +# vim:set ts=2 sw=2 et: diff --git a/abs/extra/dconf/dconf.install b/abs/extra/dconf/dconf.install new file mode 100644 index 0000000..5a87df8 --- /dev/null +++ b/abs/extra/dconf/dconf.install @@ -0,0 +1,11 @@ +post_install() { + usr/bin/gio-querymodules usr/lib/gio/modules +} + +post_upgrade(){ + post_install +} + +post_remove() { + post_install +} -- cgit v0.12 From ec706c9a90009fdfae49c23308bf5d94b7e49627 Mon Sep 17 00:00:00 2001 From: Cecil Date: Sun, 30 Jan 2011 21:22:44 -0800 Subject: vala:initial inclusion, dep of dconf. --- abs/extra/vala/PKGBUILD | 24 ++++++++++++++++++++++++ 1 file changed, 24 insertions(+) create mode 100644 abs/extra/vala/PKGBUILD diff --git a/abs/extra/vala/PKGBUILD b/abs/extra/vala/PKGBUILD new file mode 100644 index 0000000..b816dd4 --- /dev/null +++ b/abs/extra/vala/PKGBUILD @@ -0,0 +1,24 @@ +# $Id: PKGBUILD 97141 2010-10-26 21:06:27Z ibiru $ +# Maintainer : Ionut Biru +# Contributor: Timm Preetz + +pkgname=vala +pkgver=0.10.1 +pkgrel=1 +pkgdesc="Compiler for the GObject type system" +arch=('i686' 'x86_64') +url="http://live.gnome.org/Vala" +license=('LGPL') +depends=('glib2') +makedepends=('libxslt') +options=('!libtool') +source=(http://ftp.gnome.org/pub/gnome/sources/${pkgname}/0.10/${pkgname}-${pkgver}.tar.bz2) +sha256sums=('eae1d2f52b651e9d2ed31ae0877ab671b5f796a3013c714f86a926806337805a') + +build() { + cd "${srcdir}/${pkgname}-${pkgver}" + + ./configure --prefix=/usr --enable-vapigen + make + make DESTDIR="${pkgdir}" install +} -- cgit v0.12 From cbff59b7451fdf4afbca6c7d36fdb755685ab3a9 Mon Sep 17 00:00:00 2001 From: Cecil Date: Tue, 1 Feb 2011 22:27:23 -0800 Subject: linhes-theme:Updated for 0.24. --- abs/core/linhes-theme/PKGBUILD | 6 +++--- 1 file changed, 3 insertions(+), 3 deletions(-) diff --git a/abs/core/linhes-theme/PKGBUILD b/abs/core/linhes-theme/PKGBUILD index 1d289cd..13ca5cc 100644 --- a/abs/core/linhes-theme/PKGBUILD +++ b/abs/core/linhes-theme/PKGBUILD @@ -3,12 +3,12 @@ pkgname=linhes-theme pkgver=1 -pkgrel=12 +pkgrel=13 pkgdesc="Default LinHES theme." arch=('i686' 'x86_64') license=('GPL2') url="http://linhes.org/" -source=(ftp://ftp.knoppmyth.net/R6/sources/linhes-theme-1.2.tar.bz2) +source=(ftp://ftp.knoppmyth.net/R6/sources/linhes-theme-1.3.tar.bz2) build() { cd $startdir/src/ @@ -16,4 +16,4 @@ build() { cp -a LinHES $startdir/pkg/usr/share/mythtv/themes } -md5sums=('805cd304b07a0020ff4990077b2f65d5') +md5sums=('e243d40c5e76f78b1d98ec038ebe2da5') -- cgit v0.12 From 461ac3faecc423919c93b9f6d6a1c4777814e2de Mon Sep 17 00:00:00 2001 From: Cecil Date: Thu, 3 Feb 2011 21:05:54 -0800 Subject: mythdb-initial:backup before making changes --- abs/core/mythdb-initial/mc.sql.wrkn | 2996 +++++++++++++++++++++++++++++++++++ 1 file changed, 2996 insertions(+) create mode 100644 abs/core/mythdb-initial/mc.sql.wrkn diff --git a/abs/core/mythdb-initial/mc.sql.wrkn b/abs/core/mythdb-initial/mc.sql.wrkn new file mode 100644 index 0000000..6f93fe0 --- /dev/null +++ b/abs/core/mythdb-initial/mc.sql.wrkn @@ -0,0 +1,2996 @@ +-- MySQL dump 10.13 Distrib 5.1.52, for pc-linux-gnu (i686) +-- +-- Host: localhost Database: mythconverg +-- ------------------------------------------------------ +-- Server version 5.1.52 + +/*!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`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `archiveitems` ( + `intid` int(10) unsigned NOT NULL AUTO_INCREMENT, + `type` set('Recording','Video','File') CHARACTER SET latin1 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, + `duration` int(10) unsigned NOT NULL DEFAULT '0', + `cutduration` int(10) unsigned NOT NULL DEFAULT '0', + `videowidth` int(10) unsigned NOT NULL DEFAULT '0', + `videoheight` int(10) unsigned NOT NULL DEFAULT '0', + `filecodec` varchar(50) NOT NULL DEFAULT '', + `videocodec` varchar(50) NOT NULL DEFAULT '', + `encoderprofile` varchar(50) NOT NULL DEFAULT 'NONE', + PRIMARY KEY (`intid`), + KEY `title` (`title`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 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`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 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=utf8; +/*!40101 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`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 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(64) 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_speed` int(10) unsigned NOT NULL DEFAULT '0', + `firewire_model` varchar(32) DEFAULT NULL, + `firewire_connection` int(10) unsigned NOT NULL DEFAULT '0', + `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=utf8; +/*!40101 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`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 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, + `tunechan` varchar(10) DEFAULT NULL, + `startchan` varchar(10) DEFAULT NULL, + `displayname` varchar(64) NOT NULL DEFAULT '', + `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=utf8; +/*!40101 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`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 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', + `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, + `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=utf8; +/*!40101 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 `channelgroup` +-- + +DROP TABLE IF EXISTS `channelgroup`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `channelgroup` ( + `id` int(10) unsigned NOT NULL AUTO_INCREMENT, + `chanid` int(11) unsigned NOT NULL DEFAULT '0', + `grpid` int(11) NOT NULL DEFAULT '1', + PRIMARY KEY (`id`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Dumping data for table `channelgroup` +-- + +LOCK TABLES `channelgroup` WRITE; +/*!40000 ALTER TABLE `channelgroup` DISABLE KEYS */; +/*!40000 ALTER TABLE `channelgroup` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `channelgroupnames` +-- + +DROP TABLE IF EXISTS `channelgroupnames`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `channelgroupnames` ( + `grpid` int(10) unsigned NOT NULL AUTO_INCREMENT, + `name` varchar(64) NOT NULL DEFAULT '0', + PRIMARY KEY (`grpid`) +) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Dumping data for table `channelgroupnames` +-- + +LOCK TABLES `channelgroupnames` WRITE; +/*!40000 ALTER TABLE `channelgroupnames` DISABLE KEYS */; +INSERT INTO `channelgroupnames` (`grpid`, `name`) VALUES (1,'Favorites'); +/*!40000 ALTER TABLE `channelgroupnames` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `channelscan` +-- + +DROP TABLE IF EXISTS `channelscan`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `channelscan` ( + `scanid` int(3) unsigned NOT NULL AUTO_INCREMENT, + `cardid` int(3) unsigned NOT NULL, + `sourceid` int(3) unsigned NOT NULL, + `processed` tinyint(1) unsigned NOT NULL, + `scandate` datetime NOT NULL, + PRIMARY KEY (`scanid`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Dumping data for table `channelscan` +-- + +LOCK TABLES `channelscan` WRITE; +/*!40000 ALTER TABLE `channelscan` DISABLE KEYS */; +/*!40000 ALTER TABLE `channelscan` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `channelscan_channel` +-- + +DROP TABLE IF EXISTS `channelscan_channel`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `channelscan_channel` ( + `transportid` int(6) unsigned NOT NULL, + `scanid` int(3) unsigned NOT NULL, + `mplex_id` smallint(6) NOT NULL, + `source_id` int(3) unsigned NOT NULL, + `channel_id` int(3) unsigned NOT NULL DEFAULT '0', + `callsign` varchar(20) NOT NULL DEFAULT '', + `service_name` varchar(64) NOT NULL DEFAULT '', + `chan_num` varchar(10) NOT NULL DEFAULT '', + `service_id` mediumint(8) unsigned NOT NULL DEFAULT '0', + `atsc_major_channel` int(4) unsigned NOT NULL DEFAULT '0', + `atsc_minor_channel` int(4) unsigned NOT NULL DEFAULT '0', + `use_on_air_guide` tinyint(1) NOT NULL DEFAULT '0', + `hidden` tinyint(1) NOT NULL DEFAULT '0', + `hidden_in_guide` tinyint(1) NOT NULL DEFAULT '0', + `freqid` varchar(10) NOT NULL DEFAULT '', + `icon` varchar(255) NOT NULL DEFAULT '', + `tvformat` varchar(10) NOT NULL DEFAULT 'Default', + `xmltvid` varchar(64) NOT NULL DEFAULT '', + `pat_tsid` int(5) unsigned NOT NULL DEFAULT '0', + `vct_tsid` int(5) unsigned NOT NULL DEFAULT '0', + `vct_chan_tsid` int(5) unsigned NOT NULL DEFAULT '0', + `sdt_tsid` int(5) unsigned NOT NULL DEFAULT '0', + `orig_netid` int(5) unsigned NOT NULL DEFAULT '0', + `netid` int(5) unsigned NOT NULL DEFAULT '0', + `si_standard` varchar(10) NOT NULL, + `in_channels_conf` tinyint(1) unsigned NOT NULL DEFAULT '0', + `in_pat` tinyint(1) unsigned NOT NULL DEFAULT '0', + `in_pmt` tinyint(1) unsigned NOT NULL DEFAULT '0', + `in_vct` tinyint(1) unsigned NOT NULL DEFAULT '0', + `in_nit` tinyint(1) unsigned NOT NULL DEFAULT '0', + `in_sdt` tinyint(1) unsigned NOT NULL DEFAULT '0', + `is_encrypted` tinyint(1) unsigned NOT NULL DEFAULT '0', + `is_data_service` tinyint(1) unsigned NOT NULL DEFAULT '0', + `is_audio_service` tinyint(1) unsigned NOT NULL DEFAULT '0', + `is_opencable` tinyint(1) unsigned NOT NULL DEFAULT '0', + `could_be_opencable` tinyint(1) unsigned NOT NULL DEFAULT '0', + `decryption_status` smallint(2) unsigned NOT NULL DEFAULT '0', + `default_authority` varchar(32) NOT NULL DEFAULT '' +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Dumping data for table `channelscan_channel` +-- + +LOCK TABLES `channelscan_channel` WRITE; +/*!40000 ALTER TABLE `channelscan_channel` DISABLE KEYS */; +/*!40000 ALTER TABLE `channelscan_channel` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `channelscan_dtv_multiplex` +-- + +DROP TABLE IF EXISTS `channelscan_dtv_multiplex`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `channelscan_dtv_multiplex` ( + `transportid` int(6) unsigned NOT NULL AUTO_INCREMENT, + `scanid` int(3) unsigned NOT NULL, + `mplexid` smallint(6) unsigned NOT NULL, + `frequency` bigint(12) unsigned NOT NULL, + `inversion` char(1) NOT NULL DEFAULT 'a', + `symbolrate` bigint(12) unsigned NOT NULL DEFAULT '0', + `fec` varchar(10) NOT NULL DEFAULT 'auto', + `polarity` char(1) NOT NULL DEFAULT '', + `hp_code_rate` varchar(10) NOT NULL DEFAULT 'auto', + `mod_sys` varchar(10) DEFAULT NULL, + `rolloff` varchar(4) DEFAULT NULL, + `lp_code_rate` varchar(10) NOT NULL DEFAULT 'auto', + `modulation` varchar(10) NOT NULL DEFAULT 'auto', + `transmission_mode` char(1) NOT NULL DEFAULT 'a', + `guard_interval` varchar(10) NOT NULL DEFAULT 'auto', + `hierarchy` varchar(10) NOT NULL DEFAULT 'auto', + `bandwidth` char(1) NOT NULL DEFAULT 'a', + `sistandard` varchar(10) NOT NULL, + `tuner_type` smallint(2) unsigned NOT NULL, + `default_authority` varchar(32) NOT NULL DEFAULT '', + PRIMARY KEY (`transportid`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Dumping data for table `channelscan_dtv_multiplex` +-- + +LOCK TABLES `channelscan_dtv_multiplex` WRITE; +/*!40000 ALTER TABLE `channelscan_dtv_multiplex` DISABLE KEYS */; +/*!40000 ALTER TABLE `channelscan_dtv_multiplex` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `codecparams` +-- + +DROP TABLE IF EXISTS `codecparams`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 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=utf8; +/*!40101 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`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 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') CHARACTER SET latin1 NOT NULL DEFAULT '', + UNIQUE KEY `chanid` (`chanid`,`starttime`,`person`,`role`), + KEY `person` (`person`,`role`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 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`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `customexample` ( + `rulename` varchar(64) NOT NULL, + `fromclause` varchar(10000) NOT NULL DEFAULT '', + `whereclause` varchar(10000) NOT NULL DEFAULT '', + `search` tinyint(4) NOT NULL DEFAULT '0', + PRIMARY KEY (`rulename`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 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`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 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=utf8; +/*!40101 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`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 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', + `address` tinyint(3) unsigned NOT NULL DEFAULT '0', + PRIMARY KEY (`diseqcid`), + KEY `parentid` (`parentid`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 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`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `displayprofilegroups` ( + `name` varchar(128) NOT NULL, + `hostname` varchar(64) NOT NULL, + `profilegroupid` int(10) unsigned NOT NULL AUTO_INCREMENT, + PRIMARY KEY (`name`,`hostname`), + UNIQUE KEY `profilegroupid` (`profilegroupid`) +) ENGINE=MyISAM AUTO_INCREMENT=10 DEFAULT CHARSET=utf8; +/*!40101 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),('VDPAU High Quality','larch5',7),('VDPAU Normal','larch5',8),('VDPAU Slim','larch5',9); +/*!40000 ALTER TABLE `displayprofilegroups` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `displayprofiles` +-- + +DROP TABLE IF EXISTS `displayprofiles`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 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=29 DEFAULT CHARSET=utf8; +/*!40101 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',''),(7,25,'pref_priority','1'),(7,25,'pref_cmp0','> 0 0'),(7,25,'pref_decoder','vdpau'),(7,25,'pref_max_cpus','1'),(7,25,'pref_videorenderer','vdpau'),(7,25,'pref_osdrenderer','vdpau'),(7,25,'pref_osdfade','1'),(7,25,'pref_deint0','vdpauadvanceddoublerate'),(7,25,'pref_deint1','vdpauadvanced'),(7,25,'pref_filters',''),(8,26,'pref_priority','1'),(8,26,'pref_cmp0','>= 0 720'),(8,26,'pref_decoder','vdpau'),(8,26,'pref_max_cpus','1'),(8,26,'pref_videorenderer','vdpau'),(8,26,'pref_osdrenderer','vdpau'),(8,26,'pref_osdfade','1'),(8,26,'pref_deint0','vdpaubasicdoublerate'),(8,26,'pref_deint1','vdpaubasic'),(8,26,'pref_filters',''),(8,27,'pref_priority','2'),(8,27,'pref_cmp0','> 0 0'),(8,27,'pref_decoder','vdpau'),(8,27,'pref_max_cpus','1'),(8,27,'pref_videorenderer','vdpau'),(8,27,'pref_osdrenderer','vdpau'),(8,27,'pref_osdfade','1'),(8,27,'pref_deint0','vdpauadvanceddoublerate'),(8,27,'pref_deint1','vdpauadvanced'),(8,27,'pref_filters',''),(9,28,'pref_priority','1'),(9,28,'pref_cmp0','> 0 0'),(9,28,'pref_decoder','vdpau'),(9,28,'pref_max_cpus','1'),(9,28,'pref_videorenderer','vdpau'),(9,28,'pref_osdrenderer','vdpau'),(9,28,'pref_osdfade','0'),(9,28,'pref_deint0','vdpaubobdeint'),(9,28,'pref_deint1','vdpauonefield'),(9,28,'pref_filters','vdpauskipchroma'); +/*!40000 ALTER TABLE `displayprofiles` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `dtv_multiplex` +-- + +DROP TABLE IF EXISTS `dtv_multiplex`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 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', + `mod_sys` varchar(10) DEFAULT NULL, + `rolloff` varchar(4) DEFAULT NULL, + `sistandard` varchar(10) DEFAULT 'dvb', + `serviceversion` smallint(6) DEFAULT '33', + `updatetimestamp` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, + `default_authority` varchar(32) NOT NULL DEFAULT '', + PRIMARY KEY (`mplexid`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 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`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 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=utf8; +/*!40101 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`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 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=utf8; +/*!40101 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`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 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=utf8; +/*!40101 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`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 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=utf8; +/*!40101 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`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 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=utf8; +/*!40101 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 `filemarkup` +-- + +DROP TABLE IF EXISTS `filemarkup`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 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=utf8; +/*!40101 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`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `gallerymetadata` ( + `image` varchar(255) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, + `angle` int(11) NOT NULL, + PRIMARY KEY (`image`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 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`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 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 '', + `screenshot` varchar(255) NOT NULL, + `fanart` varchar(255) NOT NULL, + `plot` text NOT NULL, + `boxart` varchar(255) NOT NULL, + `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 '', + `inetref` text, + `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=utf8; +/*!40101 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`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 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=utf8; +/*!40101 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`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 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=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Dumping data for table `housekeeping` +-- + +LOCK TABLES `housekeeping` WRITE; +/*!40000 ALTER TABLE `housekeeping` DISABLE KEYS */; +INSERT INTO `housekeeping` (`tag`, `lastrun`) VALUES ('BackupDB','2010-11-29 17:02:27'),('MythFillDB','2010-05-23 00:32:23'),('DailyCleanup','2010-05-23 00:32:23'),('JobQueueRecover-larch5','2010-05-23 00:32:23'),('DBCleanup','2010-05-23 00:32:23'); +/*!40000 ALTER TABLE `housekeeping` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `inputgroup` +-- + +DROP TABLE IF EXISTS `inputgroup`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 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=utf8; +/*!40101 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 `internetcontent` +-- + +DROP TABLE IF EXISTS `internetcontent`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `internetcontent` ( + `name` varchar(255) NOT NULL, + `thumbnail` varchar(255) DEFAULT NULL, + `type` smallint(3) NOT NULL, + `author` varchar(128) NOT NULL, + `description` text NOT NULL, + `commandline` text NOT NULL, + `version` double NOT NULL, + `updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, + `search` tinyint(1) NOT NULL, + `tree` tinyint(1) NOT NULL, + `podcast` tinyint(1) NOT NULL, + `download` tinyint(1) NOT NULL, + `host` varchar(128) DEFAULT NULL +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Dumping data for table `internetcontent` +-- + +LOCK TABLES `internetcontent` WRITE; +/*!40000 ALTER TABLE `internetcontent` DISABLE KEYS */; +/*!40000 ALTER TABLE `internetcontent` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `internetcontentarticles` +-- + +DROP TABLE IF EXISTS `internetcontentarticles`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `internetcontentarticles` ( + `feedtitle` varchar(255) NOT NULL, + `path` text NOT NULL, + `paththumb` text NOT NULL, + `title` varchar(255) NOT NULL, + `subtitle` varchar(255) NOT NULL, + `season` smallint(5) NOT NULL DEFAULT '0', + `episode` smallint(5) NOT NULL DEFAULT '0', + `description` text NOT NULL, + `url` text NOT NULL, + `type` smallint(3) NOT NULL, + `thumbnail` text NOT NULL, + `mediaURL` text NOT NULL, + `author` varchar(255) NOT NULL, + `date` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, + `time` int(11) NOT NULL, + `rating` varchar(255) NOT NULL, + `filesize` bigint(20) NOT NULL, + `player` varchar(255) NOT NULL, + `playerargs` text NOT NULL, + `download` varchar(255) NOT NULL, + `downloadargs` text NOT NULL, + `width` smallint(6) NOT NULL, + `height` smallint(6) NOT NULL, + `language` varchar(128) NOT NULL, + `podcast` tinyint(1) NOT NULL, + `downloadable` tinyint(1) NOT NULL, + `customhtml` tinyint(1) NOT NULL, + `countries` varchar(255) NOT NULL +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Dumping data for table `internetcontentarticles` +-- + +LOCK TABLES `internetcontentarticles` WRITE; +/*!40000 ALTER TABLE `internetcontentarticles` DISABLE KEYS */; +/*!40000 ALTER TABLE `internetcontentarticles` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `inuseprograms` +-- + +DROP TABLE IF EXISTS `inuseprograms`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 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(64) 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=utf8; +/*!40101 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`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 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(64) 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=utf8; +/*!40101 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`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 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(64) NOT NULL DEFAULT '', + PRIMARY KEY (`destination`,`hostname`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 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'),('Manage Recording Rules','','','larch5'),('ScreenShot','','','larch5'),('Create DVD','','','larch5'),('Create Archive','','','larch5'),('Import Archive','','','larch5'),('View Archive Log','','','larch5'),('Play Created DVD','','','larch5'),('Burn DVD','','','larch5'),('MythSmolt','Hardware profiler','Ctrl+Alt+p','larch5'); +/*!40000 ALTER TABLE `jumppoints` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `keybindings` +-- + +DROP TABLE IF EXISTS `keybindings`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 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(64) NOT NULL DEFAULT '', + PRIMARY KEY (`context`,`action`,`hostname`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 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'),('TV Playback','CREATEPBPVIEW','Create Picture-by-Picture view','','larch5'),('TV Playback','CREATEPIPVIEW','Create Picture-in-Picture view','','larch5'),('TV Playback','NEXTPIPWINDOW','Toggle active PIP/PBP window','B','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','Cycle through channel groups and all channels 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','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','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 view','V','larch5'),('TV Playback','TOGGLEPIPWINDOW','Toggle active PiP window','B','larch5'),('TV Playback','SWAPPIP','Swap PBP/PIP Windows','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','TOGGLEPBPMODE','Toggle Picture-by-Picture view','Ctrl+V','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'),('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'),('Video','DOWNLOADDATA','Download metadata for current item','W','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'),('Video','INCSEARCH','Show Incremental Search Dialog','Ctrl+S','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','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','PLAYALT','Play selected item in alternate player','ALT+P','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'),('Global','NEXT','Move to next widget','Tab','larch5'),('Global','PREVIOUS','Move to preview widget','Backtab','larch5'),('Global','BACKSPACE','Backspace','Backspace','larch5'),('Global','DELETE','Delete','D','larch5'),('Global','EDIT','Edit','E','larch5'),('Global','PAGETOP','Page to top of list','','larch5'),('Global','PAGEMIDDLE','Page to middle of list','','larch5'),('Global','PAGEBOTTOM','Page to bottom of list','','larch5'),('Browser','ZOOMIN','Zoom in on browser window','.,>','larch5'),('Browser','ZOOMOUT','Zoom out on browser window',',,<','larch5'),('Browser','TOGGLEINPUT','Toggle where keyboard input goes to','F1','larch5'),('Browser','MOUSEUP','Move mouse pointer up','2','larch5'),('Browser','MOUSEDOWN','Move mouse pointer down','8','larch5'),('Browser','MOUSELEFT','Move mouse pointer left','4','larch5'),('Browser','MOUSERIGHT','Move mouse pointer right','6','larch5'),('Browser','MOUSELEFTBUTTON','Mouse Left button click','5','larch5'),('Browser','PAGEDOWN','Scroll down half a page','9','larch5'),('Browser','PAGEUP','Scroll up half a page','3','larch5'),('Browser','PAGELEFT','Scroll left half a page','7','larch5'),('Browser','PAGERIGHT','Scroll right half a page','1','larch5'),('Browser','NEXTLINK','Move selection to next link','Z','larch5'),('Browser','PREVIOUSLINK','Move selection to previous link','Q','larch5'),('Browser','FOLLOWLINK','Follow selected link','Return,Space,Enter','larch5'),('Browser','HISTORYBACK','Go back to previous page','R,Backspace','larch5'),('Browser','HISTORYFORWARD','Go forward to previous page','F','larch5'),('Welcome','STARTXTERM','Open an Xterm window','F12','larch5'),('Welcome','SHOWSETTINGS','Show Mythshutdown settings','F11','larch5'),('TV Playback','TOGGLEPIPSTATE','Change PxP view','','larch5'),('Browser','NEXTTAB','Move to next browser tab','P','larch5'),('Browser','PREVTAB','Move to previous browser tab','','larch5'),('Video','ITEMDETAIL','Display Item Detail Popup','','larch5'),('Global','CUT','Cut text from textedit','Ctrl+X','larch5'),('Global','COPY','Copy text from textedit','Ctrl+C','larch5'),('Global','PASTE','Paste text into textedit','Ctrl+V','larch5'),('Global','SYSEVENT01','Trigger System Key Event #1','','larch5'),('Global','SYSEVENT02','Trigger System Key Event #2','','larch5'),('Global','SYSEVENT03','Trigger System Key Event #3','','larch5'),('Global','SYSEVENT04','Trigger System Key Event #4','','larch5'),('Global','SYSEVENT05','Trigger System Key Event #5','','larch5'),('Global','SYSEVENT06','Trigger System Key Event #6','','larch5'),('Global','SYSEVENT07','Trigger System Key Event #7','','larch5'),('Global','SYSEVENT08','Trigger System Key Event #8','','larch5'),('Global','SYSEVENT09','Trigger System Key Event #9','','larch5'),('Global','SYSEVENT10','Trigger System Key Event #10','','larch5'),('TV Frontend','CUSTOMEDIT','Edit Custom Record Rule','','larch5'),('TV Playback','TOGGLEUPMIX','Toggle audio upmixer','Ctrl+U','larch5'),('Music','TOGGLEUPMIX','Toggle audio upmixer','Ctrl+U','larch5'),('Main Menu','EXIT','System Exit','Esc','larch5'),('TV Frontend','CYCLEAUDIOCHAN','Cycle audio channels','','larch5'),('TV Playback','BACK','Exit or return to DVD menu','','larch5'),('TV Playback','CYCLEAUDIOCHAN','Cycle audio channels','','larch5'),('TV Playback','TOGGLETEXT','Toggle External Subtitles','','larch5'),('TV Playback','TOGGLERAWTEXT','Toggle Text Subtitles','','larch5'),('TV Playback','SELECTRAWTEXT_0','Display Text Subtitle 1','','larch5'),('TV Playback','NEXTRAWTEXT','Next Text track','','larch5'),('TV Playback','PREVRAWTEXT','Previous Text track','','larch5'),('TV Editing','SAVEMAP','Save cut list','','larch5'),('Game','DOWNLOADDATA','Download metadata for current item','W','larch5'); +/*!40000 ALTER TABLE `keybindings` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `keyword` +-- + +DROP TABLE IF EXISTS `keyword`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `keyword` ( + `phrase` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '', + `searchtype` int(10) unsigned NOT NULL DEFAULT '3', + UNIQUE KEY `phrase` (`phrase`,`searchtype`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 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`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 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=utf8; +/*!40101 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`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 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=utf8; +/*!40101 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`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 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=utf8; +/*!40101 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`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 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=utf8; +/*!40101 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`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 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=utf8; +/*!40101 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`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 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(64) NOT NULL DEFAULT '', + PRIMARY KEY (`playlist_id`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 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`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 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=utf8; +/*!40101 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`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 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=utf8; +/*!40101 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`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 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') CHARACTER SET latin1 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=utf8; +/*!40101 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`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 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=utf8; +/*!40101 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`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 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=utf8; +/*!40101 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 `mythlog` +-- + +DROP TABLE IF EXISTS `mythlog`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 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` varchar(16000) NOT NULL DEFAULT '', + PRIMARY KEY (`logid`), + KEY `module` (`module`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 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`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 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=utf8; +/*!40101 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`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 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=utf8; +/*!40101 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`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 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=utf8; +/*!40101 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`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `oldprogram` ( + `oldtitle` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '', + `airdate` datetime NOT NULL DEFAULT '0000-00-00 00:00:00', + PRIMARY KEY (`oldtitle`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 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`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 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` varchar(16000) NOT NULL DEFAULT '', + `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=utf8; +/*!40101 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`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `people` ( + `person` mediumint(8) unsigned NOT NULL AUTO_INCREMENT, + `name` varchar(128) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '', + PRIMARY KEY (`person`), + UNIQUE KEY `name` (`name`(41)) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 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`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 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; +/*!40101 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`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 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; +/*!40101 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`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 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=utf8; +/*!40101 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`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 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=utf8; +/*!40101 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`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `powerpriority` ( + `priorityname` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL, + `recpriority` int(10) NOT NULL DEFAULT '0', + `selectclause` varchar(16000) NOT NULL DEFAULT '', + PRIMARY KEY (`priorityname`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 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`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 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(64) DEFAULT NULL, + PRIMARY KEY (`id`), + UNIQUE KEY `name` (`name`,`hostname`), + KEY `cardtype` (`cardtype`) +) ENGINE=MyISAM AUTO_INCREMENT=15 DEFAULT CHARSET=utf8; +/*!40101 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),(14,'Import Recorder','IMPORT',1,NULL),(10,'Freebox Input','Freebox',1,NULL),(11,'HDHomeRun Recorders','HDHOMERUN',1,NULL),(12,'CRC IP Recorders','CRC_IP',1,NULL),(13,'HD-PVR Recorders','HDPVR',1,NULL); +/*!40000 ALTER TABLE `profilegroups` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `program` +-- + +DROP TABLE IF EXISTS `program`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 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` varchar(16000) NOT NULL DEFAULT '', + `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(64) 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(64) 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') CHARACTER SET latin1 NOT NULL, + `subtitletypes` set('HARDHEAR','NORMAL','ONSCREEN','SIGNED') CHARACTER SET latin1 NOT NULL, + `videoprop` set('HDTV','WIDESCREEN','AVC') CHARACTER SET latin1 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=utf8; +/*!40101 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`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 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` varchar(30) DEFAULT NULL, + PRIMARY KEY (`chanid`,`starttime`,`relevance`), + KEY `genre` (`genre`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 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`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 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` varchar(8) DEFAULT NULL, + `rating` varchar(16) DEFAULT NULL, + UNIQUE KEY `chanid` (`chanid`,`starttime`,`system`,`rating`), + KEY `starttime` (`starttime`,`system`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 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`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `recgrouppassword` ( + `recgroup` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '', + `password` varchar(10) NOT NULL DEFAULT '', + PRIMARY KEY (`recgroup`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Dumping data for table `recgrouppassword` +-- + +LOCK TABLES `recgrouppassword` WRITE; +/*!40000 ALTER TABLE `recgrouppassword` DISABLE KEYS */; +INSERT INTO `recgrouppassword` (`recgroup`, `password`) VALUES ('All Programs',''); +/*!40000 ALTER TABLE `recgrouppassword` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `record` +-- + +DROP TABLE IF EXISTS `record`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 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` varchar(16000) NOT NULL DEFAULT '', + `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', + `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=utf8; +/*!40101 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`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 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` varchar(16000) NOT NULL DEFAULT '', + `category` varchar(64) NOT NULL DEFAULT '', + `hostname` varchar(64) 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', + `bookmarkupdate` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00', + 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=utf8; +/*!40101 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`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 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') CHARACTER SET latin1 NOT NULL DEFAULT '', + UNIQUE KEY `chanid` (`chanid`,`starttime`,`person`,`role`), + KEY `person` (`person`,`role`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 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`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 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 '', + `hostname` varchar(64) NOT NULL, + `storagegroup` varchar(32) NOT NULL, + `id` int(11) NOT NULL AUTO_INCREMENT, + PRIMARY KEY (`id`), + UNIQUE KEY `chanid` (`chanid`,`starttime`,`basename`), + KEY `basename` (`basename`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 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`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 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', + `type` tinyint(4) NOT NULL DEFAULT '0', + `data` int(11) unsigned DEFAULT NULL, + PRIMARY KEY (`chanid`,`starttime`,`type`,`mark`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 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`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 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` varchar(16000) NOT NULL DEFAULT '', + `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') CHARACTER SET latin1 NOT NULL, + `subtitletypes` set('HARDHEAR','NORMAL','ONSCREEN','SIGNED') CHARACTER SET latin1 NOT NULL, + `videoprop` set('HDTV','WIDESCREEN','AVC','720','1080') 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=utf8; +/*!40101 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`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 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` varchar(8) DEFAULT NULL, + `rating` varchar(16) DEFAULT NULL, + UNIQUE KEY `chanid` (`chanid`,`starttime`,`system`,`rating`), + KEY `starttime` (`starttime`,`system`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 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`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 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=utf8; +/*!40101 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`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 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=58 DEFAULT CHARSET=utf8; +/*!40101 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),(50,'Default',NULL,NULL,13),(51,'Live TV',NULL,NULL,13),(52,'High Quality',NULL,NULL,13),(53,'Low Quality',NULL,NULL,13),(54,'Default',NULL,NULL,14),(55,'Live TV',NULL,NULL,14),(56,'High Quality',NULL,NULL,14),(57,'Low Quality',NULL,NULL,14); +/*!40000 ALTER TABLE `recordingprofiles` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `recordmatch` +-- + +DROP TABLE IF EXISTS `recordmatch`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 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=utf8; +/*!40101 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`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 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=utf8; +/*!40101 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`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `schemalock` ( + `schemalock` int(1) DEFAULT NULL +) ENGINE=MyISAM DEFAULT CHARSET=latin1; +/*!40101 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`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `settings` ( + `value` varchar(128) NOT NULL DEFAULT '', + `data` varchar(16000) NOT NULL DEFAULT '', + `hostname` varchar(64) DEFAULT NULL, + KEY `value` (`value`,`hostname`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 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),('mythfilldatabaseLastRunEnd','',NULL),('mythfilldatabaseLastRunStatus','',NULL),('DataDirectMessage','',NULL),('HaveRepeats','0',NULL),('DBSchemaVer','1264',NULL),('DefaultTranscoder','0',NULL),('MythFillSuggestedRunTime','1970-01-01T00:00:00',NULL),('MythFillGrabberSuggestsTime','1',NULL),('MythFillFixProgramIDsHasRunOnce','1','larch5'),('Language','EN_US','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'),('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',' ','larch5'),('LongChannelFormat',' ','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','7',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','LinHES','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',NULL),('ISO639Language1','eng',NULL),('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','3','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','1005',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','1004',NULL),('GalleryDBSchemaVer','1003',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','1017',NULL),('MusicDBSchemaVer','1017',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','1038',NULL),('VideoStartupDir','/myth/video','larch5'),('VideoArtworkDir','/myth/video_stuff/coverart','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'),('mythvideo.fanartDir','/myth/video_stuff/fanart','larch5'),('mythvideo.screenshotDir','/myth/video_stuff/screenshots','larch5'),('mythvideo.bannerDir','/myth/video_stuff/banners','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','1004',NULL),('TVVidModeRefreshRate','0','larch5'),('TVVidModeRefreshRate0','0','larch5'),('TVVidModeRefreshRate1','0','larch5'),('TVVidModeRefreshRate2','0','larch5'),('GalleryRecursiveSlideshow','1','larch5'),('WebBrowserZoomLevel','20','larch5'),('WebBrowserCommand','Internal','larch5'),('WebBrowserScrollMode','1','larch5'),('WebBrowserScrollSpeed','4','larch5'),('WebBrowserHideScrollbars','0','larch5'),('RepeatMode','all','larch5'),('MusicAutoShowPlayer','1','larch5'),('HOSTOSsize','5','larch5'),('NetworkControlEnabled','1','larch5'),('Hostpluginmytharchive','1','larch5'),('Hostpluginmythbrowser','1','larch5'),('Hostpluginmythcontrols','1','larch5'),('Hostpluginmythflix','1','larch5'),('Hostpluginmythgallery','1','larch5'),('Hostpluginmythgame','1','larch5'),('HostpluginmythgameFceu','1','larch5'),('HostpluginmythgameMame','1','larch5'),('HostpluginmythgameZsnes','1','larch5'),('Hostpluginmythmovietime','1','larch5'),('Hostpluginmythmusic','1','larch5'),('Hostpluginmythnews','1','larch5'),('Hostpluginmythphone','1','larch5'),('Hostpluginmythsmolt','1','larch5'),('Hostpluginmythvideo','1','larch5'),('Hostpluginmythvideo_dvdcss','0','larch5'),('Hostpluginmythweather','1','larch5'),('HostAudiotype','ALSA','larch5'),('HostpluginmythgameZsnes','1','larch5'),('HostpluginmythgameMame','1','larch5'),('Hostpluginmythvideo_dvdcss','0','larch5'),('Hostpluginmythappletrailers','1','larch5'),('Hostpluginmythstream','1','larch5'),('Hostpluginmythvodka','1','larch5'),('HostMiro','1','larch5'),('HostpluginmythgameXE','1','larch5'),('HostpluginmythgameROMDB','1','larch5'),('HostXine','1','larch5'),('HOSTOSsize','5','larch5'),('HostMyhostname','larch5','larch5'),('NetworkControlEnabled','1','larch5'),('Hostaccessuser','1','larch5'),('WOLbackendReconnectWaitTime','5',NULL),('Hostbootsplash','0','larch5'),('HostIPeth0','192.168.1.177','larch5'),('HostNETMASKeth0','/24 255.255.255.0','larch5'),('HostGWeth0','192.168.1.1','larch5'),('HostDNSeth0','192.168.1.1','larch5'),('HostReceiverType','Hauppauge','larch5'),('HostRemoteType','no_remote','larch5'),('HOSTtemplatetype','Do Nothing','larch5'),('BackupDBLastRunStart','2010-11-29 17:02:26',NULL),('BackupDBLastRunEnd','2010-11-29 17:02:27',NULL),('StorageScheduler','Combination',NULL),('DisableAutomaticBackup','0',NULL),('BackendStopCommand','sudo sv stop mythbackend',NULL),('BackendStartCommand','sudo sv start mythbackend',NULL),('UPnP/WMPSource','0',NULL),('UPnP/RebuildDelay','30','larch5'),('GeneratePreviewRemotely','0','larch5'),('HWAccelPlaybackPreview','0','larch5'),('BrowseAllTuners','0','larch5'),('SubtitleCodec','UTF-8','larch5'),('ChannelGroupRememberLast','0','larch5'),('ChannelGroupDefault','-1','larch5'),('BrowseChannelGroup','0','larch5'),('UseFixedWindowSize','1','larch5'),('ScreenShotPath','/myth/video_stuff/screenshots','larch5'),('LircSocket','/dev/lircd','larch5'),('BrowserDBSchemaVer','1002',NULL),('CDWriterDevice','default','larch5'),('MusicExitAction','prompt','larch5'),('mythvideo.db_group_view','1','larch5'),('mythvideo.db_group_type','0','larch5'),('MovieListCommandLine','/usr/share/mythtv/mythvideo/scripts/tmdb.pl -M','larch5'),('MoviePosterCommandLine','/usr/share/mythtv/mythvideo/scripts/tmdb.pl -P','larch5'),('MovieFanartCommandLine','/usr/share/mythtv/mythvideo/scripts/tmdb.pl -B','larch5'),('MovieDataCommandLine','/usr/share/mythtv/mythvideo/scripts/tmdb.pl -D','larch5'),('mythvideo.TrailersDir','/myth/video_stuff/trailers','larch5'),('mythvideo.TrailersRandomEnabled','1','larch5'),('mythvideo.TrailersRandomCount','3','larch5'),('mythvideo.TVListCommandLine','/usr/share/mythtv/mythvideo/scripts/ttvdb.py -M','larch5'),('mythvideo.TVPosterCommandLine','/usr/share/mythtv/mythvideo/scripts/ttvdb.py -P','larch5'),('mythvideo.TVFanartCommandLine','/usr/share/mythtv/mythvideo/scripts/ttvdb.py -F','larch5'),('mythvideo.TVBannerCommandLine','/usr/share/mythtv/mythvideo/scripts/ttvdb.py -B','larch5'),('mythvideo.TVDataCommandLine','/usr/share/mythtv/mythvideo/scripts/ttvdb.py -D','larch5'),('mythvideo.TVTitleSubCommandLine','/usr/share/mythtv/mythvideo/scripts/ttvdb.py -N','larch5'),('mythvideo.TVScreenshotCommandLine','/usr/share/mythtv/mythvideo/scripts/ttvdb.py -S','larch5'),('mythvideo.EnableAlternatePlayer','1','larch5'),('mythvideo.VideoAlternatePlayer','Internal','larch5'),('AudioDefaultUpmix','1','larch5'),('AdvancedAudioSettings','0','larch5'),('SRCQualityOverride','0','larch5'),('SRCQuality','1','larch5'),('MusicDefaultUpmix','0','larch5'),('Country','US','larch5'),('OSDSubFont','FreeSans','larch5'),('CommFlagFast','0',NULL),('MultiChannelPCM','0','larch5'),('Audio48kOverride','0','larch5'),('PassThruDeviceOverride','0','larch5'),('MythArchiveM2VRequantiserCmd','M2VRequantiser','larch5'); +/*!40000 ALTER TABLE `settings` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `storagegroup` +-- + +DROP TABLE IF EXISTS `storagegroup`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 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(235) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL DEFAULT '', + PRIMARY KEY (`id`), + UNIQUE KEY `grouphostdir` (`groupname`,`hostname`,`dirname`), + KEY `hostname` (`hostname`) +) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=utf8; +/*!40101 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`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 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=utf8; +/*!40101 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 `tvosdmenu` +-- + +DROP TABLE IF EXISTS `tvosdmenu`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `tvosdmenu` ( + `osdcategory` varchar(32) NOT NULL, + `livetv` tinyint(4) NOT NULL DEFAULT '0', + `recorded` tinyint(4) NOT NULL DEFAULT '0', + `video` tinyint(4) NOT NULL DEFAULT '0', + `dvd` tinyint(4) NOT NULL DEFAULT '0', + `description` varchar(32) NOT NULL, + PRIMARY KEY (`osdcategory`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Dumping data for table `tvosdmenu` +-- + +LOCK TABLES `tvosdmenu` WRITE; +/*!40000 ALTER TABLE `tvosdmenu` DISABLE KEYS */; +/*!40000 ALTER TABLE `tvosdmenu` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `upnpmedia` +-- + +DROP TABLE IF EXISTS `upnpmedia`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 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`(333)), + KEY `parentid` (`parentid`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 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`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 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=utf8; +/*!40101 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`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 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=utf8; +/*!40101 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`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 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=utf8; +/*!40101 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`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 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=utf8; +/*!40101 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`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `videometadata` ( + `intid` int(10) unsigned NOT NULL AUTO_INCREMENT, + `title` varchar(128) NOT NULL, + `subtitle` text NOT NULL, + `tagline` varchar(255) DEFAULT NULL, + `director` varchar(128) NOT NULL, + `studio` varchar(128) DEFAULT NULL, + `plot` text, + `rating` varchar(128) NOT NULL, + `inetref` varchar(255) NOT NULL, + `homepage` text NOT NULL, + `year` int(10) unsigned NOT NULL, + `releasedate` date NOT NULL, + `userrating` float NOT NULL, + `length` int(10) unsigned NOT NULL, + `season` smallint(5) unsigned NOT NULL DEFAULT '0', + `episode` smallint(5) unsigned NOT NULL DEFAULT '0', + `showlevel` int(10) unsigned NOT NULL, + `filename` text NOT NULL, + `hash` varchar(128) NOT NULL, + `coverfile` text NOT NULL, + `childid` int(11) NOT NULL DEFAULT '-1', + `browse` tinyint(1) NOT NULL DEFAULT '1', + `watched` tinyint(1) NOT NULL DEFAULT '0', + `processed` tinyint(1) NOT NULL DEFAULT '0', + `playcommand` varchar(255) DEFAULT NULL, + `category` int(10) unsigned NOT NULL DEFAULT '0', + `trailer` text, + `host` text NOT NULL, + `screenshot` text, + `banner` text, + `fanart` text, + `insertdate` timestamp NULL DEFAULT CURRENT_TIMESTAMP, + PRIMARY KEY (`intid`), + KEY `director` (`director`), + KEY `title` (`title`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 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`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `videometadatacast` ( + `idvideo` int(10) unsigned NOT NULL, + `idcast` int(10) unsigned NOT NULL, + UNIQUE KEY `idvideo` (`idvideo`,`idcast`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 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`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `videometadatacountry` ( + `idvideo` int(10) unsigned NOT NULL, + `idcountry` int(10) unsigned NOT NULL, + UNIQUE KEY `idvideo_2` (`idvideo`,`idcountry`), + KEY `idvideo` (`idvideo`), + KEY `idcountry` (`idcountry`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 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`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `videometadatagenre` ( + `idvideo` int(10) unsigned NOT NULL, + `idgenre` int(10) unsigned NOT NULL, + UNIQUE KEY `idvideo_2` (`idvideo`,`idgenre`), + KEY `idvideo` (`idvideo`), + KEY `idgenre` (`idgenre`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 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`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 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', + `configpath` varchar(4096) DEFAULT NULL, + `dvb_nit_id` int(6) DEFAULT '-1', + PRIMARY KEY (`sourceid`), + UNIQUE KEY `name` (`name`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 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`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 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=33 DEFAULT CHARSET=utf8; +/*!40101 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),(8,'iso','Internal',0,0),(9,'img','Internal',0,0),(10,'mkv','Internal',0,1),(11,'mp4','Internal',0,0),(12,'m2ts','Internal',0,0),(13,'evo','Internal',0,0),(14,'divx','Internal',0,0),(15,'mov','Internal',0,0),(16,'qt','Internal',0,0),(17,'wmv','Internal',0,0),(18,'3gp','Internal',0,0),(19,'asf','Internal',0,0),(20,'ogg','Internal',0,0),(21,'ogm','Internal',0,0),(22,'flv','Internal',0,0),(23,'ogv','Internal',0,0),(25,'nut','Internal',0,0),(26,'mxf','Internal',0,0),(27,'m4v','Internal',0,0),(28,'rm','Internal',0,0),(29,'ts','Internal',0,0),(30,'swf','Internal',0,0),(31,'f4v','Internal',0,0),(32,'nuv','Internal',0,0); +/*!40000 ALTER TABLE `videotypes` ENABLE KEYS */; +UNLOCK TABLES; + +-- +-- Table structure for table `weatherdatalayout` +-- + +DROP TABLE IF EXISTS `weatherdatalayout`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 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=utf8; +/*!40101 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`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 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(64) DEFAULT NULL, + `units` tinyint(3) unsigned NOT NULL, + PRIMARY KEY (`screen_id`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 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`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 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(64) DEFAULT NULL, + `path` varchar(255) DEFAULT NULL, + `author` varchar(128) DEFAULT NULL, + `version` varchar(32) DEFAULT NULL, + `email` varchar(255) DEFAULT NULL, + `types` mediumtext, + `updated` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, + PRIMARY KEY (`sourceid`) +) ENGINE=InnoDB DEFAULT CHARSET=utf8; +/*!40101 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`; +/*!40101 SET @saved_cs_client = @@character_set_client */; +/*!40101 SET character_set_client = utf8 */; +CREATE TABLE `websites` ( + `id` int(10) unsigned NOT NULL AUTO_INCREMENT, + `category` varchar(100) NOT NULL, + `name` varchar(100) NOT NULL, + `url` varchar(255) NOT NULL, + PRIMARY KEY (`id`) +) ENGINE=MyISAM DEFAULT CHARSET=utf8; +/*!40101 SET character_set_client = @saved_cs_client */; + +-- +-- Dumping data for table `websites` +-- + +LOCK TABLES `websites` WRITE; +/*!40000 ALTER TABLE `websites` DISABLE KEYS */; +/*!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 2010-11-29 17:03:00 -- cgit v0.12 From cde3c5e56a01633b3e0dfaf71fea0469e843285e Mon Sep 17 00:00:00 2001 From: Cecil Date: Fri, 4 Feb 2011 19:04:23 -0800 Subject: screen:bumped --- abs/extra/community/screen/PKGBUILD | 7 ++++++- 1 file changed, 6 insertions(+), 1 deletion(-) diff --git a/abs/extra/community/screen/PKGBUILD b/abs/extra/community/screen/PKGBUILD index f97df4b..d8a60ca 100644 --- a/abs/extra/community/screen/PKGBUILD +++ b/abs/extra/community/screen/PKGBUILD @@ -4,7 +4,7 @@ pkgname=screen pkgver=4.0.3 -pkgrel=6 +pkgrel=7 _ptygroup=5 #the UID of our PTY/TTY group pkgdesc="Full-screen window manager that multiplexes a physical terminal" license=('GPL') @@ -26,6 +26,11 @@ build() { --enable-rxvt_osc --with-pty-group=$_ptygroup \ --mandir=/usr/share/man make || return 1 +} + +package() { + cd ${startdir}/src/${pkgname}-${pkgver} + make DESTDIR=${startdir}/pkg install || return 1 mkdir -p ${startdir}/pkg/etc/pam.d install -m644 ${startdir}/src/screen.pam ${startdir}/pkg/etc/pam.d/screen -- cgit v0.12 From 2fe6212b14ef52e8d8a91c37202909d769d478dc Mon Sep 17 00:00:00 2001 From: Cecil Date: Fri, 4 Feb 2011 19:04:50 -0800 Subject: php:fixed for location of mysqld. --- abs/core/php/PKGBUILD | 5 ++--- abs/core/php/__changelog | 2 ++ abs/core/php/php.ini | 2 +- 3 files changed, 5 insertions(+), 4 deletions(-) diff --git a/abs/core/php/PKGBUILD b/abs/core/php/PKGBUILD index e36353f..28bd83f 100644 --- a/abs/core/php/PKGBUILD +++ b/abs/core/php/PKGBUILD @@ -1,7 +1,7 @@ pkgbase=php pkgname=('php' 'php-cgi' 'php-pear') pkgver=5.3.3 -pkgrel=6 +pkgrel=7 _suhosinver=${pkgver}-0.9.10 pkgdesc='A high-level scripting language' arch=('i686' 'x86_64') @@ -181,8 +181,7 @@ package_php-pear() { [ ! -e "$i" ] || rm -rf "$i" done < <(find ${pkgdir} -name '.*') } - md5sums=('21ceeeb232813c10283a5ca1b4c87b48' 'b66b27c43b1332400ef8982944c3b95b' - '8ced1a21457e3d513425617667eb8588' + '25bf81e701f7914a3d8472a5636640e7' '96ca078be6729b665be8a865535a97bf') diff --git a/abs/core/php/__changelog b/abs/core/php/__changelog index 5c87426..592eff9 100644 --- a/abs/core/php/__changelog +++ b/abs/core/php/__changelog @@ -9,3 +9,5 @@ php.ini -jm split package into "php" "php-cgi" and "php-pear" -mh php-pear replaces PearLog -mh + +php.ini: mysql.default_socket = /var/run/mysqld/mysqld.sock Ref #753 -mh diff --git a/abs/core/php/php.ini b/abs/core/php/php.ini index 5ef9d1d..50413b9 100644 --- a/abs/core/php/php.ini +++ b/abs/core/php/php.ini @@ -730,7 +730,7 @@ mysql.default_port = ; Default socket name for local MySQL connects. If empty, uses the built-in ; MySQL defaults. -mysql.default_socket = +mysql.default_socket = /var/run/mysqld/mysqld.sock ; Default host for mysql_connect() (doesn't apply in safe mode). mysql.default_host = -- cgit v0.12 From 46a0be387b44ed4abea4eb8fdec128c512f3dfea Mon Sep 17 00:00:00 2001 From: Cecil Date: Fri, 4 Feb 2011 19:38:26 -0800 Subject: mythweb:Permission error --- abs/core/mythtv/stable-0.24/mythweb/PKGBUILD | 0 1 file changed, 0 insertions(+), 0 deletions(-) mode change 100644 => 100755 abs/core/mythtv/stable-0.24/mythweb/PKGBUILD diff --git a/abs/core/mythtv/stable-0.24/mythweb/PKGBUILD b/abs/core/mythtv/stable-0.24/mythweb/PKGBUILD old mode 100644 new mode 100755 -- cgit v0.12 From 56cffaefdd82172fda348e23dd98aa311d26b7ec Mon Sep 17 00:00:00 2001 From: Cecil Date: Fri, 4 Feb 2011 19:40:02 -0800 Subject: mythweb:chmod undone... --- abs/core/mythtv/stable-0.24/mythweb/PKGBUILD | 0 1 file changed, 0 insertions(+), 0 deletions(-) mode change 100755 => 100644 abs/core/mythtv/stable-0.24/mythweb/PKGBUILD diff --git a/abs/core/mythtv/stable-0.24/mythweb/PKGBUILD b/abs/core/mythtv/stable-0.24/mythweb/PKGBUILD old mode 100755 new mode 100644 -- cgit v0.12 From 7809f42740df5e8253fc7db360a8fbd1f0429d03 Mon Sep 17 00:00:00 2001 From: Cecil Date: Fri, 4 Feb 2011 20:42:47 -0800 Subject: tzdata:bumped to latest --- abs/core/tzdata/PKGBUILD | 36 ++++++++++++++++++++---------------- 1 file changed, 20 insertions(+), 16 deletions(-) diff --git a/abs/core/tzdata/PKGBUILD b/abs/core/tzdata/PKGBUILD index 544f1c7..f33a406 100644 --- a/abs/core/tzdata/PKGBUILD +++ b/abs/core/tzdata/PKGBUILD @@ -1,36 +1,40 @@ -# $Id: PKGBUILD 8190 2008-08-08 21:11:59Z andyrtr $ +# $Id: PKGBUILD 98331 2010-11-07 18:34:04Z andyrtr $ # Maintainer: Andreas Radke pkgname=tzdata -pkgver=2008e -pkgrel=10 -_tzcode=2008e -_tzdata=2008e +pkgver=2011a +pkgrel=1 +_tzcode=2011a +_tzdata=2011a pkgdesc="Sources for time zone and daylight saving time data" arch=('i686' 'x86_64') url="http://www.twinsun.com/tz/tz-link.htm" license=('GPL') -groups=('base') depends=() makedepends=() -options=() +optdepends=('sh: required by tzselect') +options=('!emptydirs') source=(ftp://elsie.nci.nih.gov/pub/tzcode${_tzcode}.tar.gz \ ftp://elsie.nci.nih.gov/pub/${pkgname}${_tzdata}.tar.gz \ Makefile.patch) -md5sums=('12ec2d85324ddcba39db1471a03f486b' - '3b4578110a3d193ed9a00d61f27aba28' - 'a64ed97d1fc03c66ee8612c0d9f40507') build() { - cd ${srcdir}/ + cd ${srcdir} + + tar -xf tzcode${_tzcode}.tar.gz + tar -xf ${pkgname}${_tzdata}.tar.gz - tar -xf tzcode${_tzcode}.tar.gz || return 1 - tar -xf ${pkgname}${_tzdata}.tar.gz || return 1 + patch -Np1 -i "${srcdir}/Makefile.patch" - patch -Np1 -i ../Makefile.patch || return 1 + make +} - make || return 1 +package() { + cd ${srcdir} make DESTDIR="${pkgdir}" install - rm ${pkgdir}/usr/share/zoneinfo/localtime + rm "${pkgdir}/usr/share/zoneinfo/localtime" } +md5sums=('001db5591974e6db7797a90cbdcbbadc' + 'd60f168fb7307d8c1b926c7dc3a6c5c1' + 'a64ed97d1fc03c66ee8612c0d9f40507') -- cgit v0.12 From 4c1086821aea4b77518ade3718a073421bbbd291 Mon Sep 17 00:00:00 2001 From: Cecil Date: Fri, 4 Feb 2011 20:44:26 -0800 Subject: abs:bumped to latest --- abs/extra/abs/ChangeLog | 41 ----------------------------------------- abs/extra/abs/PKGBUILD | 12 +++++------- abs/extra/abs/abs.install | 23 ++++++++++------------- 3 files changed, 15 insertions(+), 61 deletions(-) delete mode 100644 abs/extra/abs/ChangeLog diff --git a/abs/extra/abs/ChangeLog b/abs/extra/abs/ChangeLog deleted file mode 100644 index 03d6d88..0000000 --- a/abs/extra/abs/ChangeLog +++ /dev/null @@ -1,41 +0,0 @@ -2008-10-28 Allan McRae - - * 2.3-1 - Upstream update - - add ability to download files using tarballs on pacman mirror - -2008-08-10 Allan McRae - - * 2.2-1 - Upstream update - - adds ability to select which repos/packages - sync on commandline - - additional PKGBUILD and install script prototypes - -2008-04-19 Travis Willard - - * 2.1-1 - Upstream update - re-adds support for community - -2008-04-19 Travis Willard - - * 2.0-4 - Added install warning about /var/abs - -2008-04-15 Travis Willard - - * 2.0-3 - Added install message - Moved abs.conf to /etc instead of /etc/abs - -2008-04-13 Travis Willard - - * 2.0-2 - Moved rsyncd.conf.abs to /usr/share/abs - Made rsync server configurable - -2008-04-10 Travis Willard - - * 2.0-1 - Added ChangeLog - New rsync-based release diff --git a/abs/extra/abs/PKGBUILD b/abs/extra/abs/PKGBUILD index 872fc59..4273e8a 100644 --- a/abs/extra/abs/PKGBUILD +++ b/abs/extra/abs/PKGBUILD @@ -1,18 +1,18 @@ -# $Id: PKGBUILD 17300 2008-10-28 04:37:22Z allan $ +# $Id: PKGBUILD 65230 2010-01-25 13:11:11Z allan $ # Maintainer: Allan McRae pkgname=abs -pkgver=2.3 +pkgver=2.3.4.1 pkgrel=1 pkgdesc="Utilities to download and work with the Arch Build System (ABS)" arch=('i686' 'x86_64') -url="http://projects.archlinux.org/git/?p=abs.git" +url="http://projects.archlinux.org/abs.git/" license=('GPL') depends=('bash' 'rsync') backup=(etc/abs.conf) install=abs.install source=(ftp://ftp.archlinux.org/other/abs/${pkgname}-${pkgver}.tar.gz) -md5sums=('d6fd791aa487ba8bb5ff48c3ace20592') +md5sums=('286825d64f19f801d510ff1f7cc05ea6') build() { cd ${srcdir}/${pkgname} @@ -26,8 +26,6 @@ build() { # change ABS tags for x86_64 to correct values if [ "$CARCH" = "x86_64" ]; then - sed -i "s|i686|x86_64|g" ${pkgdir}/etc/abs.conf + sed -i 's|"i686"|"x86_64"|g' ${pkgdir}/etc/abs.conf fi } - -# vim: set ts=2 sw=2 noet: diff --git a/abs/extra/abs/abs.install b/abs/extra/abs/abs.install index 1b19b4a..c16a8d7 100644 --- a/abs/extra/abs/abs.install +++ b/abs/extra/abs/abs.install @@ -1,15 +1,12 @@ -## arg 1: the new package version -## arg 2: the old package version pre_upgrade() { - if [ "$(vercmp $2 2.0-1)" -lt 0 ]; then - echo "==> ABS now uses rsync, instead of cvsup, to synchronize your tree." - echo "==> Please note the new configuration in /etc/abs.conf" - fi - - if [ "$(vercmp $2 2.0-4)" -lt 0 ]; then - echo "==> Warning: abs clears out the contents of /var/abs when syncing." - echo "==> Keep all local PKGBUILDs in /var/abs/local, or they will disappear" - fi + if [ "$(vercmp $2 2.3.2-1)" -lt 0 ]; then + echo "==> Fixing potential ABS tree permission issues (this may take a while...)" + + for dir in core extra community testing; do + if [ -d /var/abs/$dir ]; then + find /var/abs/$dir -type d -exec chown root:root {} \; + find /var/abs/$dir -type d -exec chmod 755 {} \; + fi + done + fi } - -# vim:set ts=2 sw=2 et: -- cgit v0.12 From 0f6857999a17e17111ef7a76c2862096fadb376d Mon Sep 17 00:00:00 2001 From: Cecil Date: Fri, 4 Feb 2011 20:45:00 -0800 Subject: dbus-python:initial inclusion. dep of miro 3.5. --- abs/extra/dbus-python/PKGBUILD | 22 ++++++++++++++++++++++ abs/extra/dbus-python/__changelog | 1 + 2 files changed, 23 insertions(+) create mode 100644 abs/extra/dbus-python/PKGBUILD create mode 100644 abs/extra/dbus-python/__changelog diff --git a/abs/extra/dbus-python/PKGBUILD b/abs/extra/dbus-python/PKGBUILD new file mode 100644 index 0000000..b128c48 --- /dev/null +++ b/abs/extra/dbus-python/PKGBUILD @@ -0,0 +1,22 @@ +# $Id: PKGBUILD 87863 2010-08-18 14:30:02Z ibiru $ +# Contributor: Jan de Groot + +pkgname=dbus-python +pkgver=0.83.1 +pkgrel=2 +pkgdesc="Python bindings for DBUS" +arch=('i686' 'x86_64') +license=('GPL' 'LGPL') +url="http://www.freedesktop.org/wiki/Software/DBusBindings" +depends=('dbus-glib>=0.82' 'python2>=2.6') +makedepends=('pkg-config' 'docutils') +options=('!libtool') +source=(http://dbus.freedesktop.org/releases/${pkgname}/${pkgname}-${pkgver}.tar.gz) +md5sums=('5fdf3970aa0c00020289de7ba8f3be18') + +build() { + cd "${srcdir}/${pkgname}-${pkgver}" + ./configure --prefix=/usr + make + make DESTDIR="${pkgdir}" install +} diff --git a/abs/extra/dbus-python/__changelog b/abs/extra/dbus-python/__changelog new file mode 100644 index 0000000..ac7685d --- /dev/null +++ b/abs/extra/dbus-python/__changelog @@ -0,0 +1 @@ +2/5/11 - chw - Change python dep from 2.7 to 2.6. -- cgit v0.12 From 563dee18bd3a6bff9115147a07b33b411818abd7 Mon Sep 17 00:00:00 2001 From: Cecil Date: Fri, 4 Feb 2011 20:45:19 -0800 Subject: pyrex:initial inclusion. dep of miro 3.5 --- abs/extra/pyrex/PKGBUILD | 21 +++++++++++++++++++++ 1 file changed, 21 insertions(+) create mode 100644 abs/extra/pyrex/PKGBUILD diff --git a/abs/extra/pyrex/PKGBUILD b/abs/extra/pyrex/PKGBUILD new file mode 100644 index 0000000..1ca2af6 --- /dev/null +++ b/abs/extra/pyrex/PKGBUILD @@ -0,0 +1,21 @@ +# $Id: PKGBUILD 89621 2010-09-02 16:28:29Z remy $ +# Maintainer: Jan de Groot +# Contributor: Douglas Soares de Andrade +# Contributor: Arjan timmerman +# Contributor: Link Dupont + +pkgname=pyrex +pkgver=0.9.9 +pkgrel=2 +pkgdesc="Language for writing Python extension modules" +arch=(any) +url="http://www.cosc.canterbury.ac.nz/~greg/python/Pyrex/" +license=('APACHE') +depends=('python2') +source=(http://www.cosc.canterbury.ac.nz/~greg/python/Pyrex/Pyrex-${pkgver}.tar.gz) +md5sums=('515dee67d15d4393841e2d60e8341947') + +build() { + cd "${srcdir}/Pyrex-${pkgver}" + python2 setup.py install --root="${pkgdir}" --prefix=/usr || return 1 +} -- cgit v0.12 From 7e4ae9d59f07f7a6a4f476202b88fb6e89706670 Mon Sep 17 00:00:00 2001 From: Cecil Date: Fri, 4 Feb 2011 20:45:32 -0800 Subject: miro:bumed to latest. --- abs/extra/miro/PKGBUILD | 37 +++++++++++++++++-------------------- abs/extra/miro/__changelog | 1 + 2 files changed, 18 insertions(+), 20 deletions(-) create mode 100644 abs/extra/miro/__changelog diff --git a/abs/extra/miro/PKGBUILD b/abs/extra/miro/PKGBUILD index 1411c43..627e7b8 100644 --- a/abs/extra/miro/PKGBUILD +++ b/abs/extra/miro/PKGBUILD @@ -1,32 +1,29 @@ -# $Id: PKGBUILD 35621 2009-04-14 18:07:17Z ronald $ +# $Id: PKGBUILD 96701 2010-10-24 10:50:35Z ronald $ # Maintainer: Ronald van Haren pkgname=miro -pkgver=2.0.4 -pkgrel=9 +pkgver=3.5 +pkgrel=1 pkgdesc="The free and open source internet TV platform" arch=('i686' 'x86_64') url="http://www.getmiro.com" license=('GPL2') -depends=('xine-lib>=1.1.16.1' 'boost>=1.37.0' 'gnome-python-extras>=2.25.3' - 'dbus-python>=0.82.4' 'pyrex' 'xulrunner>=1.9.0.1' 'gtk2' 'nspr' - 'desktop-file-utils') -makedepends=('pkgconfig' 'pm-utils' 'qt3') -optdepends=('gstreamer0.10-python: gstreamer backend (potentially unstable)' 'gstreamer0.10: gstreamer backend (potentially unstable') +depends=('dbus-python' 'pyrex' 'pygtk' 'gstreamer0.10' 'gnome-python' + 'python-pysqlite' 'pywebkitgtk' 'shared-mime-info' + 'desktop-file-utils' 'gstreamer0.10' 'hicolor-icon-theme' + 'gstreamer0.10-python' 'python-notify' 'libtorrent-rasterbar' + 'gstreamer0.10-base-plugins' 'gstreamer0.10-good-plugins' 'python-pycurl') +makedepends=('pkgconfig') install=miro.install -conflicts=('democracy') -replaces=('democracy') -provides=('democracy') -source=(http://ftp.osuosl.org/pub/pculture.org/miro/src/Miro-${pkgver}.tar.gz - miro.exec.patch) -md5sums=('e6cf48252496b2bddd290f375fc0ca33' - '355648eac790d52c51ccb014736f90fc') +source=(http://ftp.osuosl.org/pub/pculture.org/${pkgname}/src/${pkgname}-${pkgver}.tar.gz) +sha1sums=('a5e72b39e3a1bb5ec918bd8fddeb6b079f44c9b3') build() { - cd ${srcdir}/Miro-${pkgver}/platform/gtk-x11 - python setup.py install --root=${pkgdir} || return 1 + cd "${srcdir}/${pkgname}-${pkgver}/linux" - # Fix FS#14196 - cd ${pkgdir} - patch -Np0 -i ${srcdir}/miro.exec.patch || return 1 + python2 setup.py install --root=${pkgdir} || return 1 + + # fix miro startup script so --debug works with python2 + sed -i "s|which python|which python2|" ${pkgdir}/usr/bin/miro + sed -i "s|./miro.real|/usr/bin/miro.real|" ${pkgdir}/usr/bin/miro } diff --git a/abs/extra/miro/__changelog b/abs/extra/miro/__changelog new file mode 100644 index 0000000..27c5164 --- /dev/null +++ b/abs/extra/miro/__changelog @@ -0,0 +1 @@ +2/5/11 - chw - the miro.install that is used is LinHES specfic. -- cgit v0.12 From b7d3bd7c288f0f242c56ef0dec0c2b6af7a8da33 Mon Sep 17 00:00:00 2001 From: Cecil Date: Fri, 4 Feb 2011 20:47:43 -0800 Subject: pygtk:initial inclusion. dep of miro 3.5. --- abs/extra/pygtk/PKGBUILD | 34 ++++++++++++++++++++++++++++ abs/extra/pygtk/python27.patch | 50 ++++++++++++++++++++++++++++++++++++++++++ 2 files changed, 84 insertions(+) create mode 100644 abs/extra/pygtk/PKGBUILD create mode 100644 abs/extra/pygtk/python27.patch diff --git a/abs/extra/pygtk/PKGBUILD b/abs/extra/pygtk/PKGBUILD new file mode 100644 index 0000000..fa405e1 --- /dev/null +++ b/abs/extra/pygtk/PKGBUILD @@ -0,0 +1,34 @@ +# $Id: PKGBUILD 94310 2010-10-06 15:16:23Z ibiru $ +# Maintainer: Jan de Groot +# Contributor: Sarah Hay + +pkgname=pygtk +pkgver=2.22.0 +pkgrel=3 +pkgdesc="Python bindings for the GTK widget set" +arch=('i686' 'x86_64') +license=('LGPL') +depends=('libglade>=2.6.4' 'pycairo>=1.8.10' 'pygobject>=2.21.5') +makedepends=('python-numpy') +optdepends=('python-numpy') +options=('!libtool') +url="http://www.pygtk.org/" +source=(http://ftp.gnome.org/pub/gnome/sources/pygtk/2.22/${pkgname}-${pkgver}.tar.bz2 + python27.patch) +sha256sums=('4acf0ef2bde8574913c40ee4a43d9c4f43bb77b577b67147271b534501a54cc8' + '39a30456cba055a452bb55c74ef1ff2f5f7bfaad22855b4dd569ab009b56b682') + +build() { + cd "${srcdir}/${pkgname}-${pkgver}" + #https://bugzilla.gnome.org/show_bug.cgi?id=623965 + patch -Np1 -i "${srcdir}/python27.patch" + ./configure --prefix=/usr + make +} + +package() { + cd "${srcdir}/${pkgname}-${pkgver}" + make DESTDIR="${pkgdir}" install + sed -i -e 's#env python$#env python2#' "${pkgdir}"/usr/lib/pygtk/2.0/{,demos/}*.py + install -m644 gtk/gtk-extrafuncs.defs "${pkgdir}/usr/share/pygtk/2.0/defs/" +} diff --git a/abs/extra/pygtk/python27.patch b/abs/extra/pygtk/python27.patch new file mode 100644 index 0000000..9bbe2b5 --- /dev/null +++ b/abs/extra/pygtk/python27.patch @@ -0,0 +1,50 @@ +diff --git a/gtk/gtkmodule.c b/gtk/gtkmodule.c +index c0e1493..aa8cf10 100644 +--- a/gtk/gtkmodule.c ++++ b/gtk/gtkmodule.c +@@ -227,8 +227,12 @@ init_gtk(void) + pygtk_add_stock_items(d); + + /* extension API */ +- PyDict_SetItemString(d, "_PyGtk_API", +- o=PyCObject_FromVoidPtr(&functions, NULL)); ++#if PY_VERSION_HEX >= 0x02070000 ++ o = PyCapsule_New(&functions, "gtk._gtk._PyGtk_API", NULL); ++#else ++ o = PyCObject_FromVoidPtr(&functions, NULL); ++#endif ++ PyDict_SetItemString(d, "_PyGtk_API", o); + Py_DECREF(o); + + PyGtkDeprecationWarning = PyErr_NewException("gtk.GtkDeprecationWarning", +diff --git a/gtk/pygtk.h b/gtk/pygtk.h +index 573c3b9..e4c680f 100644 +--- a/gtk/pygtk.h ++++ b/gtk/pygtk.h +@@ -60,6 +60,18 @@ struct _PyGtk_FunctionStruct *_PyGtk_API; + + + /* a function to initialise the pygtk functions */ ++ ++/* Python 2.7 introduced the PyCapsule API and deprecated the CObject API */ ++#if PY_VERSION_HEX >= 0x02070000 ++#define init_pygtk() G_STMT_START { \ ++ void *capsule = PyCapsule_Import("gtk._gtk._PyGtk_API", 0); \ ++ if (!capsule) { \ ++ return; \ ++ } \ ++ _PyGtk_API = (struct _PyGtk_FunctionStruct*)capsule; \ ++} G_STMT_END ++#else /* PY_VERSION_HEX */ ++/* Python 2.6 and earlier use the CObject API */ + #define init_pygtk() G_STMT_START { \ + PyObject *pygtk = PyImport_ImportModule("gtk"); \ + if (pygtk != NULL) { \ +@@ -79,6 +91,7 @@ struct _PyGtk_FunctionStruct *_PyGtk_API; + return; \ + } \ + } G_STMT_END ++#endif /* PY_VERSION_HEX */ + + #endif + -- cgit v0.12 From f7d1fbea0c55186bf6773b15828648f21d334ad6 Mon Sep 17 00:00:00 2001 From: Cecil Date: Fri, 4 Feb 2011 20:55:38 -0800 Subject: pygtk:already in core --- abs/extra/pygtk/PKGBUILD | 34 ---------------------------- abs/extra/pygtk/python27.patch | 50 ------------------------------------------ 2 files changed, 84 deletions(-) delete mode 100644 abs/extra/pygtk/PKGBUILD delete mode 100644 abs/extra/pygtk/python27.patch diff --git a/abs/extra/pygtk/PKGBUILD b/abs/extra/pygtk/PKGBUILD deleted file mode 100644 index fa405e1..0000000 --- a/abs/extra/pygtk/PKGBUILD +++ /dev/null @@ -1,34 +0,0 @@ -# $Id: PKGBUILD 94310 2010-10-06 15:16:23Z ibiru $ -# Maintainer: Jan de Groot -# Contributor: Sarah Hay - -pkgname=pygtk -pkgver=2.22.0 -pkgrel=3 -pkgdesc="Python bindings for the GTK widget set" -arch=('i686' 'x86_64') -license=('LGPL') -depends=('libglade>=2.6.4' 'pycairo>=1.8.10' 'pygobject>=2.21.5') -makedepends=('python-numpy') -optdepends=('python-numpy') -options=('!libtool') -url="http://www.pygtk.org/" -source=(http://ftp.gnome.org/pub/gnome/sources/pygtk/2.22/${pkgname}-${pkgver}.tar.bz2 - python27.patch) -sha256sums=('4acf0ef2bde8574913c40ee4a43d9c4f43bb77b577b67147271b534501a54cc8' - '39a30456cba055a452bb55c74ef1ff2f5f7bfaad22855b4dd569ab009b56b682') - -build() { - cd "${srcdir}/${pkgname}-${pkgver}" - #https://bugzilla.gnome.org/show_bug.cgi?id=623965 - patch -Np1 -i "${srcdir}/python27.patch" - ./configure --prefix=/usr - make -} - -package() { - cd "${srcdir}/${pkgname}-${pkgver}" - make DESTDIR="${pkgdir}" install - sed -i -e 's#env python$#env python2#' "${pkgdir}"/usr/lib/pygtk/2.0/{,demos/}*.py - install -m644 gtk/gtk-extrafuncs.defs "${pkgdir}/usr/share/pygtk/2.0/defs/" -} diff --git a/abs/extra/pygtk/python27.patch b/abs/extra/pygtk/python27.patch deleted file mode 100644 index 9bbe2b5..0000000 --- a/abs/extra/pygtk/python27.patch +++ /dev/null @@ -1,50 +0,0 @@ -diff --git a/gtk/gtkmodule.c b/gtk/gtkmodule.c -index c0e1493..aa8cf10 100644 ---- a/gtk/gtkmodule.c -+++ b/gtk/gtkmodule.c -@@ -227,8 +227,12 @@ init_gtk(void) - pygtk_add_stock_items(d); - - /* extension API */ -- PyDict_SetItemString(d, "_PyGtk_API", -- o=PyCObject_FromVoidPtr(&functions, NULL)); -+#if PY_VERSION_HEX >= 0x02070000 -+ o = PyCapsule_New(&functions, "gtk._gtk._PyGtk_API", NULL); -+#else -+ o = PyCObject_FromVoidPtr(&functions, NULL); -+#endif -+ PyDict_SetItemString(d, "_PyGtk_API", o); - Py_DECREF(o); - - PyGtkDeprecationWarning = PyErr_NewException("gtk.GtkDeprecationWarning", -diff --git a/gtk/pygtk.h b/gtk/pygtk.h -index 573c3b9..e4c680f 100644 ---- a/gtk/pygtk.h -+++ b/gtk/pygtk.h -@@ -60,6 +60,18 @@ struct _PyGtk_FunctionStruct *_PyGtk_API; - - - /* a function to initialise the pygtk functions */ -+ -+/* Python 2.7 introduced the PyCapsule API and deprecated the CObject API */ -+#if PY_VERSION_HEX >= 0x02070000 -+#define init_pygtk() G_STMT_START { \ -+ void *capsule = PyCapsule_Import("gtk._gtk._PyGtk_API", 0); \ -+ if (!capsule) { \ -+ return; \ -+ } \ -+ _PyGtk_API = (struct _PyGtk_FunctionStruct*)capsule; \ -+} G_STMT_END -+#else /* PY_VERSION_HEX */ -+/* Python 2.6 and earlier use the CObject API */ - #define init_pygtk() G_STMT_START { \ - PyObject *pygtk = PyImport_ImportModule("gtk"); \ - if (pygtk != NULL) { \ -@@ -79,6 +91,7 @@ struct _PyGtk_FunctionStruct *_PyGtk_API; - return; \ - } \ - } G_STMT_END -+#endif /* PY_VERSION_HEX */ - - #endif - -- cgit v0.12 From c8e875e106f5002ade452ac0ead295b37f7e08ce Mon Sep 17 00:00:00 2001 From: Cecil Date: Fri, 4 Feb 2011 20:55:48 -0800 Subject: pyrex:already in core --- abs/extra/pyrex/PKGBUILD | 21 --------------------- 1 file changed, 21 deletions(-) delete mode 100644 abs/extra/pyrex/PKGBUILD diff --git a/abs/extra/pyrex/PKGBUILD b/abs/extra/pyrex/PKGBUILD deleted file mode 100644 index 1ca2af6..0000000 --- a/abs/extra/pyrex/PKGBUILD +++ /dev/null @@ -1,21 +0,0 @@ -# $Id: PKGBUILD 89621 2010-09-02 16:28:29Z remy $ -# Maintainer: Jan de Groot -# Contributor: Douglas Soares de Andrade -# Contributor: Arjan timmerman -# Contributor: Link Dupont - -pkgname=pyrex -pkgver=0.9.9 -pkgrel=2 -pkgdesc="Language for writing Python extension modules" -arch=(any) -url="http://www.cosc.canterbury.ac.nz/~greg/python/Pyrex/" -license=('APACHE') -depends=('python2') -source=(http://www.cosc.canterbury.ac.nz/~greg/python/Pyrex/Pyrex-${pkgver}.tar.gz) -md5sums=('515dee67d15d4393841e2d60e8341947') - -build() { - cd "${srcdir}/Pyrex-${pkgver}" - python2 setup.py install --root="${pkgdir}" --prefix=/usr || return 1 -} -- cgit v0.12 From 1d06229e230037207b5d8ac83617da6e8e135d2f Mon Sep 17 00:00:00 2001 From: Cecil Date: Fri, 4 Feb 2011 20:57:21 -0800 Subject: pywebkitgtk:initial inclusion. dep for miro 3.5. --- abs/core/python_modules/pywebkitgtk/PKGBUILD | 27 +++++++++++++++++++++++++++ 1 file changed, 27 insertions(+) create mode 100644 abs/core/python_modules/pywebkitgtk/PKGBUILD diff --git a/abs/core/python_modules/pywebkitgtk/PKGBUILD b/abs/core/python_modules/pywebkitgtk/PKGBUILD new file mode 100644 index 0000000..6f56900 --- /dev/null +++ b/abs/core/python_modules/pywebkitgtk/PKGBUILD @@ -0,0 +1,27 @@ +# Contributor: kasa +# Maintainer: Daniel J Griffiths + +pkgname=pywebkitgtk +pkgver=1.1.7 +pkgrel=4 +pkgdesc="Python bindings to the WebKit GTK+ port" +arch=('i686' 'x86_64') +url="http://code.google.com/p/pywebkitgtk/" +license=('LGPL') +depends=('libwebkit' 'pygtk') +options=('!libtool' '!makeflags') +source=(http://pywebkitgtk.googlecode.com/files/${pkgname}-${pkgver}.tar.gz) +md5sums=('4dbe0111c0b0ad2280052e4534903a9b') + +build() { + cd ${srcdir}/${pkgname}-${pkgver} + + ./configure --prefix=/usr + make +} + +package() { + cd ${srcdir}/${pkgname}-${pkgver} + + make DESTDIR=${pkgdir} install +} -- cgit v0.12 From f6c24f6da227a7ad5def4bcdc2bba5ff1bd5c2db Mon Sep 17 00:00:00 2001 From: Cecil Date: Fri, 4 Feb 2011 21:03:15 -0800 Subject: gstreamer0.10-python:initial inclusion. dep of miro 3.5. --- abs/extra/community/gstreamer0.10-python/PKGBUILD | 27 +++++++++++++++++++++++ 1 file changed, 27 insertions(+) create mode 100644 abs/extra/community/gstreamer0.10-python/PKGBUILD diff --git a/abs/extra/community/gstreamer0.10-python/PKGBUILD b/abs/extra/community/gstreamer0.10-python/PKGBUILD new file mode 100644 index 0000000..c9cb0db --- /dev/null +++ b/abs/extra/community/gstreamer0.10-python/PKGBUILD @@ -0,0 +1,27 @@ +# $Id: PKGBUILD 94427 2010-10-07 08:56:26Z remy $ +# Maintainer: Jan de Groot + +pkgname=gstreamer0.10-python +pkgver=0.10.18 +pkgrel=3 +pkgdesc="Python bindings for GStreamer 0.10" +arch=('i686' 'x86_64') +license=('LGPL') +url="http://gstreamer.freedesktop.org/" +depends=('pygobject>=2.20.0' 'gstreamer0.10-base>=0.10.28') +makedepends=('pkgconfig') +options=('!libtool') +source=(http://gstreamer.freedesktop.org/src/gst-python/gst-python-${pkgver}.tar.bz2) +sha256sums=('21a6a13736bd4c2cdcbde7d9c2791f1e47085d161eda84f8ee901bb744ddb897') + +build() { + cd "${srcdir}/gst-python-${pkgver}" + sed -i -e 's%^#!.*env python$%#!/usr/bin/env python2%' examples/* gst/extend/*.py + ./configure --prefix=/usr + make +} + +package() { + cd "${srcdir}/gst-python-${pkgver}" + make DESTDIR="${pkgdir}" install +} -- cgit v0.12 From dae512b7c06bc8d05ce4fe2aa169309aa0748d70 Mon Sep 17 00:00:00 2001 From: Cecil Date: Fri, 4 Feb 2011 21:18:04 -0800 Subject: libavc1394:bumped to latest --- abs/core/libavc1394/PKGBUILD | 16 ++++++++-------- 1 file changed, 8 insertions(+), 8 deletions(-) diff --git a/abs/core/libavc1394/PKGBUILD b/abs/core/libavc1394/PKGBUILD index 23aa5cc..1a359f4 100644 --- a/abs/core/libavc1394/PKGBUILD +++ b/abs/core/libavc1394/PKGBUILD @@ -1,22 +1,22 @@ -# $Id: PKGBUILD 8934 2008-08-17 00:56:51Z eric $ +# $Id: PKGBUILD 37800 2009-05-03 21:23:26Z jgc $ # Maintainer: damir # Contributor: Robert Emil Berge pkgname=libavc1394 pkgver=0.5.3 -pkgrel=2 +pkgrel=3 pkgdesc="A library to control A/V devices using the 1394ta AV/C commands." arch=("i686" "x86_64") url="http://sourceforge.net/projects/libavc1394/" -depends=('libraw1394') +license=('LGPL') +depends=('libraw1394>=2.0.2') options=('!libtool') -source=(http://internap.dl.sourceforge.net/sourceforge/libavc1394/$pkgname\-$pkgver.tar.gz) +source=(http://downloads.sourceforge.net/sourceforge/libavc1394/${pkgname}-${pkgver}.tar.gz) md5sums=('09e30b1fb5ae455b6d8407e457a711a3') build() { - cd $startdir/src/$pkgname-$pkgver - ./configure --prefix=/usr + cd "${srcdir}/${pkgname}-${pkgver}" + ./configure --prefix=/usr --mandir=/usr/share/man || return 1 make || return 1 - make DESTDIR=$startdir/pkg install + make DESTDIR="${pkgdir}" install || return 1 } - -- cgit v0.12 From d8e0d5da25780b011ef365927c2db678736e636f Mon Sep 17 00:00:00 2001 From: Cecil Date: Fri, 4 Feb 2011 21:18:35 -0800 Subject: python-notify:initial inclusion. dep of miro 3.5. --- abs/core/python_modules/python-notify/PKGBUILD | 30 ++++++++++++++++++++++++++ 1 file changed, 30 insertions(+) create mode 100644 abs/core/python_modules/python-notify/PKGBUILD diff --git a/abs/core/python_modules/python-notify/PKGBUILD b/abs/core/python_modules/python-notify/PKGBUILD new file mode 100644 index 0000000..47c25e5 --- /dev/null +++ b/abs/core/python_modules/python-notify/PKGBUILD @@ -0,0 +1,30 @@ +# $Id: PKGBUILD 82 2009-07-17 19:56:55Z aaron $ +# Contributor: Andrea Scarpino +# Contributor: Roman Kyrylych +# Contributor: Mario Danic +# Maintainer: Daniel J Griffiths + +pkgname=python-notify +pkgver=0.1.1 +pkgrel=8 +pkgdesc="Python bindings for libnotify" +arch=('i686' 'x86_64') +url="http://www.galago-project.org/" +license=('GPL') +depends=('pygtk>=2.22.0' 'libnotify>=0.4.5') +makedepends=('pkgconfig' 'python2') +options=(!libtool) +source=(http://www.galago-project.org/files/releases/source/notify-python/notify-python-${pkgver}.tar.gz) +md5sums=('8f0ef0939cc8edd2efd896ce5ba80cf4') + +build() { + cd ${srcdir}/notify-python-${pkgver} + ./configure --prefix=/usr + make clean + make +} + +package() { + cd ${srcdir}/notify-python-${pkgver} + make DESTDIR=${pkgdir} install +} -- cgit v0.12 From c1a4776c72fccc340c88c025b313f5c6ce28373b Mon Sep 17 00:00:00 2001 From: Cecil Date: Fri, 4 Feb 2011 21:19:37 -0800 Subject: gstreamer0.10-good:initial inclusion. dep of miro 3.5. --- abs/extra/community/gstreamer0.10-good/PKGBUILD | 52 ++++++++++++++++++++++ .../gstreamer0.10-good-plugins.install | 19 ++++++++ 2 files changed, 71 insertions(+) create mode 100644 abs/extra/community/gstreamer0.10-good/PKGBUILD create mode 100644 abs/extra/community/gstreamer0.10-good/gstreamer0.10-good-plugins.install diff --git a/abs/extra/community/gstreamer0.10-good/PKGBUILD b/abs/extra/community/gstreamer0.10-good/PKGBUILD new file mode 100644 index 0000000..a77d52d --- /dev/null +++ b/abs/extra/community/gstreamer0.10-good/PKGBUILD @@ -0,0 +1,52 @@ +# $Id: PKGBUILD 87774 2010-08-18 09:32:26Z jgc $ +# Maintainer: Jan de Groot + +pkgbase=gstreamer0.10-good +pkgname=('gstreamer0.10-good' 'gstreamer0.10-good-plugins') +pkgver=0.10.24 +pkgrel=1 +arch=('i686' 'x86_64') +license=('LGPL') +makedepends=('intltool' 'pkgconfig' 'gstreamer0.10-base>=0.10.30' 'libavc1394>=0.5.3-3' 'libiec61883>=1.2.0' 'aalib>=1.4rc5-6' 'libshout>=2.2.2' 'libdv>=1.0.0' 'esound>=0.2.41' 'flac>=1.2.1' 'gconf>=2.28.1' 'wavpack>=4.60.1' 'taglib>=1.6.3' 'libsoup-gnome>=2.30.1' 'libv4l>=0.6.4' 'libcaca>=0.99.beta17' 'bzip2>=1.0.5' 'gtk2>=2.20.1') +url="http://gstreamer.freedesktop.org/" +options=(!libtool !emptydirs) +source=(${url}/src/gst-plugins-good/gst-plugins-good-${pkgver}.tar.bz2) +sha256sums=('f274aac9c5b8efc66833c33cfad353209c785ac111465b37146680ee0de2d0be') + +build() { + cd "${srcdir}/gst-plugins-good-${pkgver}" + ./configure --prefix=/usr --sysconfdir=/etc --localstatedir=/var \ + --disable-static --enable-experimental \ + --disable-schemas-install \ + --disable-hal \ + --with-package-name="GStreamer Good Plugins (Archlinux)" \ + --with-package-origin="http://www.archlinux.org/" + + make + sed -e 's/gst sys ext/gst/' -i Makefile +} + +package_gstreamer0.10-good() { + depends=('gstreamer0.10-base>=0.10.30' 'bzip2>=1.0.5') + pkgdesc="GStreamer Multimedia Framework Good plugin libraries" + conflicts=('gstreamer0.10-bad<=0.10.17') + + cd "${srcdir}/gst-plugins-good-${pkgver}" + make GCONF_DISABLE_MAKEFILE_SCHEMA_INSTALL=1 DESTDIR="${pkgdir}" install + rm -rf "${pkgdir}/etc/gconf" +} + +package_gstreamer0.10-good-plugins() { + depends=("gstreamer0.10-good=${pkgver}" 'libavc1394>=0.5.3-3' 'libiec61883>=1.2.0' 'aalib>=1.4rc5-6' 'libshout>=2.2.2' 'libdv>=1.0.0' 'esound>=0.2.41' 'flac>=1.2.1' 'gconf>=2.28.1' 'wavpack>=4.60.1' 'taglib>=1.6.3' 'libsoup-gnome>=2.30.1' 'libv4l>=0.6.3' 'libcaca>=0.99.beta17' 'libpng>=1.4.1' 'libjpeg>=8.0.1') + pkgdesc="GStreamer Multimedia Framework Good Plugins (gst-plugins-good)" + groups=('gstreamer0.10-plugins') + replaces=('gstreamer0.10-aalib' 'gstreamer0.10-wavpack' 'gstreamer0.10-shout2' 'gstreamer0.10-taglib' 'gstreamer0.10-libcaca' 'gstreamer0.10-libpng' 'gstreamer0.10-jpeg' 'gstreamer0.10-cairo' 'gstreamer0.10-flac' 'gstreamer0.10-speex' 'gstreamer0.10-gdkpixbuf' 'gstreamer0.10-dv1394' 'gstreamer0.10-annodex' 'gstreamer0.10-gconf' 'gstreamer0.10-esd' 'gstreamer0.10-cdio' 'gstreamer0.10-dv' 'gstreamer0.10-soup') + conflicts=('gstreamer0.10-aalib' 'gstreamer0.10-wavpack' 'gstreamer0.10-shout2' 'gstreamer0.10-taglib' 'gstreamer0.10-libcaca' 'gstreamer0.10-libpng' 'gstreamer0.10-jpeg' 'gstreamer0.10-cairo' 'gstreamer0.10-flac' 'gstreamer0.10-speex' 'gstreamer0.10-gdkpixbuf' 'gstreamer0.10-dv1394' 'gstreamer0.10-annodex' 'gstreamer0.10-gconf' 'gstreamer0.10-esd' 'gstreamer0.10-cdio' 'gstreamer0.10-dv' 'gstreamer0.10-bad-plugins<0.10.7' 'gstreamer0.10-soup') + install=gstreamer0.10-good-plugins.install + + cd "${srcdir}/gst-plugins-good-${pkgver}" + make -C sys DESTDIR="${pkgdir}" install || return 1 + make -C ext GCONF_DISABLE_MAKEFILE_SCHEMA_INSTALL=1 DESTDIR="${pkgdir}" install + install -m755 -d "${pkgdir}/usr/share/gconf/schemas" + install -m644 gconf/gstreamer-0.10.schemas "${pkgdir}/usr/share/gconf/schemas/gstreamer0.10-good-plugins.schemas" || return 1 +} diff --git a/abs/extra/community/gstreamer0.10-good/gstreamer0.10-good-plugins.install b/abs/extra/community/gstreamer0.10-good/gstreamer0.10-good-plugins.install new file mode 100644 index 0000000..bcb0039 --- /dev/null +++ b/abs/extra/community/gstreamer0.10-good/gstreamer0.10-good-plugins.install @@ -0,0 +1,19 @@ +pkgname=gstreamer0.10-good-plugins + +post_install() { + usr/sbin/gconfpkg --install ${pkgname} +} + +pre_upgrade() { + if [ -f usr/share/gconf/schemas/${pkgname}.schemas ]; then + pre_remove $1 + fi +} + +post_upgrade() { + post_install $1 +} + +pre_remove() { + usr/sbin/gconfpkg --uninstall ${pkgname} +} -- cgit v0.12 From c4b87ad8d15557c37937f4ca68c64c9e3c4ed460 Mon Sep 17 00:00:00 2001 From: Cecil Date: Sat, 5 Feb 2011 00:18:03 -0800 Subject: libcaca:bumped to latest. --- abs/core/libcaca/PKGBUILD | 19 +++++++++++-------- 1 file changed, 11 insertions(+), 8 deletions(-) diff --git a/abs/core/libcaca/PKGBUILD b/abs/core/libcaca/PKGBUILD index f0c3710..65485d1 100644 --- a/abs/core/libcaca/PKGBUILD +++ b/abs/core/libcaca/PKGBUILD @@ -1,20 +1,23 @@ -# $Id: PKGBUILD 9776 2008-08-19 00:46:51Z eric $ +# $Id: PKGBUILD 71245 2010-03-05 16:17:11Z jgc $ # Maintainer: Jan de Groot pkgname=libcaca -pkgver=0.9 -pkgrel=2 +pkgver=0.99.beta17 +pkgrel=1 pkgdesc="Color AsCii Art library" arch=('i686' 'x86_64') license=('LGPL') url="http://libcaca.zoy.org/" -depends=('freetype2' 'imlib2' 'ncurses>=5.6-7') +depends=('imlib2' 'ncurses>=5.7') +options=(!libtool !emptydirs) source=(http://libcaca.zoy.org/files/libcaca/${pkgname}-${pkgver}.tar.gz) -md5sums=('97b0f526f39491389e159055f574c921') +md5sums=('790d6e26b7950e15909fdbeb23a7ea87') build() { - cd ${startdir}/src/${pkgname}-${pkgver} - ./configure --prefix=/usr --mandir=/usr/share/man --enable-shared --disable-doc + cd "${srcdir}/${pkgname}-${pkgver}" + ./configure --prefix=/usr --mandir=/usr/share/man \ + --enable-shared --disable-doc \ + --disable-cxx --disable-gl --disable-csharp || return 1 make || return 1 - make DESTDIR=${startdir}/pkg install + make DESTDIR="${pkgdir}" install || return 1 } -- cgit v0.12 From 7f522bca496d41ea929a0bb0346cc2418dbebf9d Mon Sep 17 00:00:00 2001 From: Cecil Date: Sat, 5 Feb 2011 00:18:14 -0800 Subject: wavpack:bumped to latest --- abs/extra/wavpack/PKGBUILD | 28 ++++++++++++++++------------ 1 file changed, 16 insertions(+), 12 deletions(-) diff --git a/abs/extra/wavpack/PKGBUILD b/abs/extra/wavpack/PKGBUILD index c0ab01a..87e19c3 100644 --- a/abs/extra/wavpack/PKGBUILD +++ b/abs/extra/wavpack/PKGBUILD @@ -1,25 +1,29 @@ -# $Id: PKGBUILD 3456 2008-06-22 19:29:25Z jgc $ -# Maintainer: Jan de Groot +# $Id: PKGBUILD 69146 2010-02-18 00:37:49Z dgriffiths $ +# Maintainer: François Charette # Contributor: Shinlun Hsieh # Contributor: Michal Hybner pkgname=wavpack -pkgver=4.50.0 +pkgver=4.60.1 pkgrel=1 -pkgdesc="A completely open audio compression format providing lossless, high-quality lossy, and a unique hybrid compression mode" +pkgdesc="Audio compression format with lossless, lossy, and hybrid compression modes" arch=('i686' 'x86_64') url="http://www.wavpack.com/" license=('custom') depends=('glibc') options=('!libtool') source=(http://www.wavpack.com/${pkgname}-${pkgver}.tar.bz2) -md5sums=('9cf854fc2e5757f6534a3a231ec6bfbc') +md5sums=('7bb1528f910e4d0003426c02db856063') build() { - cd ${startdir}/src/${pkgname}-${pkgver} - ./configure --prefix=/usr --enable-mmx --disable-static || return 1 - make || return 1 - make DESTDIR=${startdir}/pkg install || return 1 - install -m755 -d ${pkgdir}/usr/share/licenses/${pkgname} - install -m644 license.txt ${pkgdir}/usr/share/licenses/${pkgname}/ || return 1 - rm -f ${startdir}/pkg/usr/lib/*.a + cd ${srcdir}/${pkgname}-${pkgver} + ./configure --prefix=/usr --enable-mmx --disable-static || return 1 + make || return 1 +} + +package() { + cd ${srcdir}/${pkgname}-${pkgver} + make DESTDIR=${pkgdir} install || return 1 + install -m755 -d ${pkgdir}/usr/share/licenses/${pkgname} + install -m644 license.txt ${pkgdir}/usr/share/licenses/${pkgname}/ || return 1 + rm -f ${pkgdir}/usr/lib/*.a } -- cgit v0.12 From a4bb0fdbcfcd42cbe2dfce9e0d28513d11c75107 Mon Sep 17 00:00:00 2001 From: Cecil Date: Sat, 5 Feb 2011 00:18:57 -0800 Subject: v4l-utils:userspace tools --- abs/core/v4l-utils/PKGBUILD | 31 +++++++++++++++++++++++++++++++ 1 file changed, 31 insertions(+) create mode 100644 abs/core/v4l-utils/PKGBUILD diff --git a/abs/core/v4l-utils/PKGBUILD b/abs/core/v4l-utils/PKGBUILD new file mode 100644 index 0000000..a43df65 --- /dev/null +++ b/abs/core/v4l-utils/PKGBUILD @@ -0,0 +1,31 @@ +# $Id: PKGBUILD 90013 2010-09-06 06:34:17Z thomas $ +# Maintainer: Thomas Bächler +pkgname=v4l-utils +pkgver=0.8.1 +pkgrel=1 +pkgdesc="Userspace tools and conversion library for Video 4 Linux" +arch=('i686' 'x86_64') +url="http://freshmeat.net/projects/libv4l" +provides=("libv4l=$pkgver") +replaces=('libv4l') +conflicts=('libv4l') +license=('LGPL') +makedepends=('qt') +optdepends=('qt') +depends=('glibc' 'gcc-libs' 'sysfsutils') +source=(http://linuxtv.org/downloads/v4l-utils/${pkgname}-${pkgver}.tar.bz2) +sha256sums=('2b03003f1e081c5c98d1fe287c0d88a6c720ca972c4d80a1782146bbde1ac5ea') + +build() { + cd "${srcdir}/${pkgname}-${pkgver}" + + sed -i 's|CFLAGS :=|CFLAGS ?=|' Make.rules + + make PREFIX="/usr" +} + +package() { + cd "${srcdir}/${pkgname}-${pkgver}" + make install PREFIX="/usr" DESTDIR="${pkgdir}/" + rm -f "${pkgdir}/usr/bin/ivtv-ctl" +} -- cgit v0.12