r5927 - in /vdr/vdr-xxv/trunk/debian: changelog control copyright install logrotate patches/03_defaults.dpatch upgrade/1.0
tiber-guest at users.alioth.debian.org
tiber-guest at users.alioth.debian.org
Sun Nov 25 15:04:06 UTC 2007
Author: tiber-guest
Date: Sun Nov 25 15:04:06 2007
New Revision: 5927
URL: http://svn.debian.org/wsvn/pkg-vdr-dvb/?sc=1&rev=5927
Log:
* Updated debian/copyright
* New upstream release
Added:
vdr/vdr-xxv/trunk/debian/upgrade/1.0
Modified:
vdr/vdr-xxv/trunk/debian/changelog
vdr/vdr-xxv/trunk/debian/control
vdr/vdr-xxv/trunk/debian/copyright
vdr/vdr-xxv/trunk/debian/install
vdr/vdr-xxv/trunk/debian/logrotate
vdr/vdr-xxv/trunk/debian/patches/03_defaults.dpatch
Modified: vdr/vdr-xxv/trunk/debian/changelog
URL: http://svn.debian.org/wsvn/pkg-vdr-dvb/vdr/vdr-xxv/trunk/debian/changelog?rev=5927&op=diff
==============================================================================
--- vdr/vdr-xxv/trunk/debian/changelog (original)
+++ vdr/vdr-xxv/trunk/debian/changelog Sun Nov 25 15:04:06 2007
@@ -1,10 +1,14 @@
-vdr-xxv (0.80+svn20061130-2) UNRELEASED; urgency=low
-
- * NOT RELEASED YET
- * Removed logrotate section for the preview log - this isn't needed anymore,
- because XXV does not use this log anymore (reported by Andreas Brachold)
-
- -- Tobias Grimm <tg at e-tobi.net> Sat, 16 Dec 2006 20:27:29 +0100
+vdr-xxv (1.0-2) unstable; urgency=low
+
+ * Updated debian/copyright
+
+ -- Tobias Grimm <tg at e-tobi.net> Sun, 25 Nov 2007 15:57:49 +0100
+
+vdr-xxv (1.0-1) unstable; urgency=low
+
+ * New upstream release
+
+ -- Sebastian Ortwein <kron at animeland.de> Sat, 1 Sep 2007 14:16:23 +0100
vdr-xxv (0.80+svn20061130-1) unstable; urgency=low
Modified: vdr/vdr-xxv/trunk/debian/control
URL: http://svn.debian.org/wsvn/pkg-vdr-dvb/vdr/vdr-xxv/trunk/debian/control?rev=5927&op=diff
==============================================================================
--- vdr/vdr-xxv/trunk/debian/control (original)
+++ vdr/vdr-xxv/trunk/debian/control Sun Nov 25 15:04:06 2007
@@ -8,7 +8,7 @@
Package: vdr-xxv
Architecture: all
-Depends: ${perl:Depends}, debconf (>= 0.5.00), dbconfig-common (>= 1.8.12), vdr (>= 1.4.0-1), mysql-client, ttf-bitstream-vera, libdbi-perl, libconfig-tiny-perl, libtemplate-perl, libproc-process-perl, libterm-readline-gnu-perl, libwww-mechanize-perl, libwww-mechanize-formfiller-perl, libgd-gd2-noxpm-perl | libgd-gd2-perl, libdate-manip-perl, txt2html, libio-zlib-perl, libxml-simple-perl, libgd-graph-perl, libtext-asciitable-perl, libdigest-hmac-perl, libxml-rss-perl, libnet-xmpp-perl, libevent-perl, libterm-readline-perl-perl, libsoap-lite-perl, liblog-log4perl-perl
+Depends: ${perl:Depends}, debconf (>= 0.5.00), dbconfig-common (>= 1.8.12), vdr (>= 1.4.0-1), mysql-client, ttf-bitstream-vera, libdbi-perl, libconfig-tiny-perl, libtemplate-perl, libproc-process-perl, libterm-readline-gnu-perl, libwww-mechanize-perl, libwww-mechanize-formfiller-perl, libgd-gd2-noxpm-perl | libgd-gd2-perl, libdate-manip-perl, txt2html, libio-zlib-perl, libxml-simple-perl, libgd-graph-perl, libtext-asciitable-perl, libdigest-hmac-perl, libxml-rss-perl, libnet-xmpp-perl, libevent-perl, libterm-readline-perl-perl, libsoap-lite-perl, liblog-log4perl-perl, libgd-graph3d-perl, libgd-text-perl, libhtml-parser-perl, libhtml-tagset-perl, libhtml-template-perl, libhtml-tree-perl , liblocale-gettext-perl, libnet-telnet-perl, libterm-readkey-perl, liburi-perl, libwww-perl
Recommends: mysql-server
Suggests: mplayer, vdr-plugin-osdteletext | vdr-plugin-teletext
Description: Provides a central service to administer VDR
Modified: vdr/vdr-xxv/trunk/debian/copyright
URL: http://svn.debian.org/wsvn/pkg-vdr-dvb/vdr/vdr-xxv/trunk/debian/copyright?rev=5927&op=diff
==============================================================================
--- vdr/vdr-xxv/trunk/debian/copyright (original)
+++ vdr/vdr-xxv/trunk/debian/copyright Sun Nov 25 15:04:06 2007
@@ -1,16 +1,39 @@
-This package was debianized by Tobias Grimm <tg at e-tobi.net> on
-Thu, 3 Feb 2005 19:17:39 +0100.
+Upstream Homepage:
+ http://xxv.berlios.de/
-It was downloaded from http://xpix.dieserver.de/content/vdr/xxv/
+Upstream Authors:
+ Frank Herrmann <xpix at xpix dot de>
+ Andreas Brachold <anbr at users.berlios.de>.
-Upstream Authors:
+Debian Maintainers:
+ Tobias Grimm <tg at e-tobi.net>
+ Thomas Schmidt <tschmidt at debian.org>
+ Sebastian Ortwein <kron at animeland.de>
-Frank Herrmann <xpix at xpix.de>
-Andreas Brachold <vdr04 at deltab.de>
+Copyright:
+ (C) 2004 - 2007 Frank Herrmann / Berlin
+
+Copyright (Debian packaging):
+ (C) 2005 - 2007 Tobias Grimm, Sebastian Ortwein
License:
+ This program is free software; you can redistribute it and/or
+ modify it under the terms of the GNU Lesser General Public
+ License as published by the Free Software Foundation; either
+ version 2.1 of the License, or (at your option) any later version.
- You are free to distribute this software under the terms of
- the GNU General Public License.
- On Debian systems, the complete text of the GNU General Public
- License can be found in /usr/share/common-licenses/GPL file.
+ This program is distributed in the hope that it will be useful,
+ but WITHOUT ANY WARRANTY; without even the implied warranty of
+ MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
+ Lesser General Public License for more details.
+
+ You should have received a copy of the GNU Lesser General Public
+ License along with this program; if not, write to the Free Software
+ Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301 USA
+
+ On Debian systems, the complete text of the GNU Lesser General Public
+ License, can be found in /usr/share/common-licenses/LGPL.
+
+License (Debian packaging):
+ The Debian packaging is licensed under the GPL, version 2 or any
+ later version, see /usr/share/common-licenses/GPL.
Modified: vdr/vdr-xxv/trunk/debian/install
URL: http://svn.debian.org/wsvn/pkg-vdr-dvb/vdr/vdr-xxv/trunk/debian/install?rev=5927&op=diff
==============================================================================
--- vdr/vdr-xxv/trunk/debian/install (original)
+++ vdr/vdr-xxv/trunk/debian/install Sun Nov 25 15:04:06 2007
@@ -1,23 +1,24 @@
-debian/scripts/* usr/share/vdr-xxv/debian
-debian/upgrade/* usr/share/dbconfig-common/data/vdr-xxv/upgrade/mysql/
+debian/scripts/* usr/share/vdr-xxv/debian
+debian/upgrade/* usr/share/dbconfig-common/data/vdr-xxv/upgrade/mysql/
-bin/xxvd usr/bin/
+bin/xxvd usr/bin/
-locale/de usr/share/locale/
+locale/de usr/share/locale/
-html/* usr/share/vdr-xxv/html/default
-wml/ usr/share/vdr-xxv/html/
-doc/docu.tmpl usr/share/vdr-xxv/doc/
-contrib usr/share/vdr-xxv/
-share/news/ usr/share/vdr-xxv/
-share/vtx/ usr/share/vdr-xxv/
+html/* usr/share/vdr-xxv/html/default
+wml/ usr/share/vdr-xxv/html/
+doc/docu.tmpl usr/share/vdr-xxv/doc/
+contrib usr/share/vdr-xxv/
+share/news/ usr/share/vdr-xxv/
+share/vtx/ usr/share/vdr-xxv/
-lib/Tools.pm usr/share/perl5/vdr-xxv/
-lib/Tie/ usr/share/perl5/vdr-xxv/
-lib/XXV/ usr/share/perl5/vdr-xxv/
-lib/Event/ usr/share/perl5/vdr-xxv/
-lib/Module/ usr/share/perl5/vdr-xxv/
-lib/MP3/ usr/share/perl5/vdr-xxv/
-lib/Net/ usr/share/perl5/vdr-xxv/
-lib/Mail/ usr/share/perl5/vdr-xxv/
-lib/SOAP/ usr/share/perl5/vdr-xxv/
+lib/Tools.pm usr/share/perl5/vdr-xxv/
+lib/MediaLibParser.pm usr/share/perl5/vdr-xxv/
+lib/MediaLibParser usr/share/perl5/vdr-xxv/
+lib/XXV/ usr/share/perl5/vdr-xxv/
+lib/Event/ usr/share/perl5/vdr-xxv/
+lib/Module/ usr/share/perl5/vdr-xxv/
+lib/MP3/ usr/share/perl5/vdr-xxv/
+lib/Net/ usr/share/perl5/vdr-xxv/
+lib/Mail/ usr/share/perl5/vdr-xxv/
+lib/SOAP/ usr/share/perl5/vdr-xxv/
Modified: vdr/vdr-xxv/trunk/debian/logrotate
URL: http://svn.debian.org/wsvn/pkg-vdr-dvb/vdr/vdr-xxv/trunk/debian/logrotate?rev=5927&op=diff
==============================================================================
--- vdr/vdr-xxv/trunk/debian/logrotate (original)
+++ vdr/vdr-xxv/trunk/debian/logrotate Sun Nov 25 15:04:06 2007
@@ -6,3 +6,12 @@
missingok
copytruncate
}
+
+/var/log/vdr-xxv/xxvd_preview.log {
+ compress
+ rotate 99
+ size=+4096k
+ notifempty
+ missingok
+ copytruncate
+}
Modified: vdr/vdr-xxv/trunk/debian/patches/03_defaults.dpatch
URL: http://svn.debian.org/wsvn/pkg-vdr-dvb/vdr/vdr-xxv/trunk/debian/patches/03_defaults.dpatch?rev=5927&op=diff
==============================================================================
--- vdr/vdr-xxv/trunk/debian/patches/03_defaults.dpatch (original)
+++ vdr/vdr-xxv/trunk/debian/patches/03_defaults.dpatch Sun Nov 25 15:04:06 2007
@@ -6,10 +6,22 @@
## DP: changed by a user on a Debian system
@DPATCH@
-diff -urNad vdr-xxv-0.72~/lib/XXV/MODULES/LOGREAD.pm vdr-xxv-0.72/lib/XXV/MODULES/LOGREAD.pm
---- vdr-xxv-0.72~/lib/XXV/MODULES/LOGREAD.pm 2006-04-09 05:41:58.000000000 +0200
-+++ vdr-xxv-0.72/lib/XXV/MODULES/LOGREAD.pm 2006-05-20 18:37:25.000000000 +0200
-@@ -33,7 +33,7 @@
+diff -burN vdr-xxv-1.0/lib/XXV/MODULES/CHANNELS.pm vdr-xxv-1.0.new/lib/XXV/MODULES/CHANNELS.pm
+--- vdr-xxv-1.0/lib/XXV/MODULES/CHANNELS.pm 2007-10-20 08:28:30.000000000 +0200
++++ vdr-xxv-1.0.new/lib/XXV/MODULES/CHANNELS.pm 2007-11-18 12:01:48.000000000 +0100
+@@ -25,7 +25,7 @@
+ file => {
+ description => sprintf(gettext("Path of file '%s'"),'channels.conf'),
+ default => '/var/lib/vdr/channels.conf',
+- type => 'file',
++ type => 'hidden', #'file',
+ required => gettext('This is required!'),
+ },
+ interval => {
+diff -burN vdr-xxv-1.0/lib/XXV/MODULES/LOGREAD.pm vdr-xxv-1.0.new/lib/XXV/MODULES/LOGREAD.pm
+--- vdr-xxv-1.0/lib/XXV/MODULES/LOGREAD.pm 2007-11-18 11:42:07.000000000 +0100
++++ vdr-xxv-1.0.new/lib/XXV/MODULES/LOGREAD.pm 2007-11-18 11:46:47.000000000 +0100
+@@ -34,7 +34,7 @@
tail => {
description => sprintf(gettext("Path of command '%s'"),'tail'),
default => '/usr/bin/tail',
@@ -18,36 +30,66 @@
required => gettext('This is required!'),
},
rows => {
-@@ -45,7 +45,7 @@
+@@ -46,7 +46,7 @@
syslog => {
- description => gettext('Path of syslog file?'),
+ description => sprintf(gettext("Path of file '%s'"),'syslog'),
default => '/var/log/syslog',
- type => 'file',
+ type => 'hidden', #'file',
required => gettext('This is required!'),
},
},
-diff -urNad vdr-xxv-0.72~/lib/XXV/MODULES/MUSIC.pm vdr-xxv-0.72/lib/XXV/MODULES/MUSIC.pm
---- vdr-xxv-0.72~/lib/XXV/MODULES/MUSIC.pm 2006-05-17 19:45:02.000000000 +0200
-+++ vdr-xxv-0.72/lib/XXV/MODULES/MUSIC.pm 2006-05-20 18:38:47.000000000 +0200
-@@ -79,8 +79,8 @@
+diff -burN vdr-xxv-1.0/lib/XXV/MODULES/MEDIALIB.pm vdr-xxv-1.0.new/lib/XXV/MODULES/MEDIALIB.pm
+--- vdr-xxv-1.0/lib/XXV/MODULES/MEDIALIB.pm 2007-11-18 11:42:07.000000000 +0100
++++ vdr-xxv-1.0.new/lib/XXV/MODULES/MEDIALIB.pm 2007-11-18 11:47:53.000000000 +0100
+@@ -41,7 +41,7 @@
+ },
+ libraryimagedir => {
+ description => gettext('Location of coverimages.'),
+- default => '/var/cache/xxv/libraryimages',
++ default => '/var/cache/vdr-xxv/libraryimages',
+ type => 'dir',
+ required => gettext("This is required!"),
+ },
+diff -burN vdr-xxv-1.0/lib/XXV/MODULES/MUSIC.pm vdr-xxv-1.0.new/lib/XXV/MODULES/MUSIC.pm
+--- vdr-xxv-1.0/lib/XXV/MODULES/MUSIC.pm 2007-11-18 11:42:07.000000000 +0100
++++ vdr-xxv-1.0.new/lib/XXV/MODULES/MUSIC.pm 2007-11-18 11:50:33.000000000 +0100
+@@ -71,7 +71,7 @@
+ },
+ coverimages => {
+ description => gettext('Common directory for cover images'),
+- default => '/var/cache/xxv/cover',
++ default => '/var/cache/vdr-xxv/cover',
+ type => 'dir',
+ required => gettext('This is required!'),
+ },
+@@ -87,8 +87,8 @@
},
mugglei => {
- description => gettext('Path to the binary from mugglei.'),
-- default => '/usr/local/bin/mugglei',
+ description => sprintf(gettext("Path of command '%s'"),'mugglei'),
+- default => 'mugglei',
- type => 'file',
+ default => '/usr/lib/vdr-plugin-muggle/mugglei',
+ type => 'hidden', #'file',
},
},
Commands => {
-diff -urNad vdr-xxv-0.72~/lib/XXV/MODULES/RECORDS.pm vdr-xxv-0.72/lib/XXV/MODULES/RECORDS.pm
---- vdr-xxv-0.72~/lib/XXV/MODULES/RECORDS.pm 2006-05-11 01:00:27.000000000 +0200
-+++ vdr-xxv-0.72/lib/XXV/MODULES/RECORDS.pm 2006-05-20 18:37:25.000000000 +0200
-@@ -78,8 +78,8 @@
+diff -burN vdr-xxv-1.0/lib/XXV/MODULES/RECORDS.pm vdr-xxv-1.0.new/lib/XXV/MODULES/RECORDS.pm
+--- vdr-xxv-1.0/lib/XXV/MODULES/RECORDS.pm 2007-11-18 11:42:07.000000000 +0100
++++ vdr-xxv-1.0.new/lib/XXV/MODULES/RECORDS.pm 2007-11-18 12:00:05.000000000 +0100
+@@ -57,7 +57,7 @@
+ previewbinary => {
+ description => gettext('Location of used program to produce thumbnails on your system.'),
+ default => '/usr/bin/mplayer',
+- type => 'file',
++ type => 'hidden', #'file',
+ required => gettext("This is required!"),
+ },
+ previewcommand => {
+@@ -84,8 +84,8 @@
},
previewimages => {
- description => gettext('common directory for preview images'),
+ description => gettext('Common directory for preview images'),
- default => '/var/cache/xxv/preview',
- type => 'dir',
+ default => '/var/cache/vdr-xxv/preview',
@@ -55,10 +97,22 @@
required => gettext('This is required!'),
},
vfat => {
-diff -urNad vdr-xxv-0.72~/lib/XXV/MODULES/STATUS.pm vdr-xxv-0.72/lib/XXV/MODULES/STATUS.pm
---- vdr-xxv-0.72~/lib/XXV/MODULES/STATUS.pm 2006-04-09 05:41:59.000000000 +0200
-+++ vdr-xxv-0.72/lib/XXV/MODULES/STATUS.pm 2006-05-20 18:37:25.000000000 +0200
-@@ -33,20 +33,20 @@
+diff -burN vdr-xxv-1.0/lib/XXV/MODULES/REMOTE.pm vdr-xxv-1.0.new/lib/XXV/MODULES/REMOTE.pm
+--- vdr-xxv-1.0/lib/XXV/MODULES/REMOTE.pm 2007-10-20 08:28:30.000000000 +0200
++++ vdr-xxv-1.0.new/lib/XXV/MODULES/REMOTE.pm 2007-11-18 12:03:38.000000000 +0100
+@@ -36,7 +36,7 @@
+ commands => {
+ description => sprintf(gettext("Path of file '%s'"),'commands.conf'),
+ default => '/var/lib/vdr/commands.conf',
+- type => 'file',
++ type => 'hidden', #'file',
+ required => gettext('This is required!'),
+ },
+ },
+diff -burN vdr-xxv-1.0/lib/XXV/MODULES/STATUS.pm vdr-xxv-1.0.new/lib/XXV/MODULES/STATUS.pm
+--- vdr-xxv-1.0/lib/XXV/MODULES/STATUS.pm 2007-11-18 11:42:07.000000000 +0100
++++ vdr-xxv-1.0.new/lib/XXV/MODULES/STATUS.pm 2007-11-18 11:53:05.000000000 +0100
+@@ -34,20 +34,20 @@
whoBinary => {
description => sprintf(gettext("Path of command '%s'"),'who'),
default => "/usr/bin/who",
@@ -81,30 +135,28 @@
+ type => 'hidden', #"file",
},
interval => {
- description => gettext('Interval in seconds to remember data'),
-diff -urNad vdr-xxv-0.72~/lib/XXV/MODULES/USER.pm vdr-xxv-0.72/lib/XXV/MODULES/USER.pm
---- vdr-xxv-0.72~/lib/XXV/MODULES/USER.pm 2006-05-17 19:45:02.000000000 +0200
-+++ vdr-xxv-0.72/lib/XXV/MODULES/USER.pm 2006-05-20 18:37:25.000000000 +0200
-@@ -62,8 +62,8 @@
+ description => gettext('Interval in seconds to save data'),
+diff -burN vdr-xxv-1.0/lib/XXV/MODULES/USER.pm vdr-xxv-1.0.new/lib/XXV/MODULES/USER.pm
+--- vdr-xxv-1.0/lib/XXV/MODULES/USER.pm 2007-11-18 11:42:07.000000000 +0100
++++ vdr-xxv-1.0.new/lib/XXV/MODULES/USER.pm 2007-11-18 11:54:43.000000000 +0100
+@@ -63,7 +63,7 @@
},
tempimages => {
description => gettext('common directory for temporary images'),
- default => '/var/cache/xxv/temp',
-- type => 'dir',
-+ default => '/tmp/.vdr-xxv/images',
-+ type => 'hidden', #'dir',
++ default => '/var/cache/vdr-xxv/images',
+ type => 'dir',
required => gettext('This is required!'),
},
- },
-diff -urNad vdr-xxv-0.72~/lib/XXV/MODULES/VTX.pm vdr-xxv-0.72/lib/XXV/MODULES/VTX.pm
---- vdr-xxv-0.72~/lib/XXV/MODULES/VTX.pm 2006-04-09 05:41:58.000000000 +0200
-+++ vdr-xxv-0.72/lib/XXV/MODULES/VTX.pm 2006-05-20 18:37:25.000000000 +0200
-@@ -27,7 +27,7 @@
+diff -burN vdr-xxv-1.0/lib/XXV/MODULES/VTX.pm vdr-xxv-1.0.new/lib/XXV/MODULES/VTX.pm
+--- vdr-xxv-1.0/lib/XXV/MODULES/VTX.pm 2007-11-18 11:42:07.000000000 +0100
++++ vdr-xxv-1.0.new/lib/XXV/MODULES/VTX.pm 2007-11-18 12:08:02.000000000 +0100
+@@ -28,7 +28,7 @@
},
- dir => {
- description => gettext('Directory where the teletext files are be located'),
-- default => '/vtx',
-+ default => '/var/cache/vdr/vtx',
- type => 'dir',
- required => gettext('This is required!'),
- },
+ dir => {
+ description => gettext('Directory where the teletext files are be located'),
+- default => '/vtx',
++ default => '/var/cache/vdr/vtx',
+ type => 'dir',
+ required => gettext('This is required!'),
+ },
Added: vdr/vdr-xxv/trunk/debian/upgrade/1.0
URL: http://svn.debian.org/wsvn/pkg-vdr-dvb/vdr/vdr-xxv/trunk/debian/upgrade/1.0?rev=5927&op=file
==============================================================================
--- vdr/vdr-xxv/trunk/debian/upgrade/1.0 (added)
+++ vdr/vdr-xxv/trunk/debian/upgrade/1.0 Sun Nov 25 15:04:06 2007
@@ -1,0 +1,124 @@
+SET FOREIGN_KEY_CHECKS = 0;
+
+#
+# DDL START
+#
+CREATE TABLE MEDIALIB_ACTORS (
+ name varchar(255) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
+ actorid varchar(15) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
+ imgurl varchar(255) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci,
+ checked timestamp NOT NULL DEFAULT 'CURRENT_TIMESTAMP' COMMENT '',
+ PRIMARY KEY (name)
+) DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci COMMENT='1.0(1157)';
+
+CREATE TABLE MEDIALIB_VIDEODATA (
+ id int(10) unsigned NOT NULL DEFAULT 0 COMMENT '' auto_increment,
+ md5 varchar(32) NULL DEFAULT NULL COMMENT '' COLLATE latin1_swedish_ci,
+ title varchar(255) NULL DEFAULT NULL COMMENT '' COLLATE latin1_swedish_ci,
+ subtitle varchar(255) NULL DEFAULT NULL COMMENT '' COLLATE latin1_swedish_ci,
+ language varchar(255) NULL DEFAULT NULL COMMENT '' COLLATE latin1_swedish_ci,
+ diskid varchar(15) NULL DEFAULT NULL COMMENT '' COLLATE latin1_swedish_ci,
+ comment varchar(255) NULL DEFAULT NULL COMMENT '' COLLATE latin1_swedish_ci,
+ disklabel varchar(32) NULL DEFAULT NULL COMMENT '' COLLATE latin1_swedish_ci,
+ imdbID varchar(15) NULL DEFAULT NULL COMMENT '' COLLATE latin1_swedish_ci,
+ year year(4) NULL DEFAULT NULL COMMENT '',
+ imgurl varchar(255) NULL DEFAULT NULL COMMENT '' COLLATE latin1_swedish_ci,
+ director varchar(255) NULL DEFAULT NULL COMMENT '' COLLATE latin1_swedish_ci,
+ actors text NULL DEFAULT NULL COMMENT '' COLLATE latin1_swedish_ci,
+ runtime int(10) unsigned NULL DEFAULT NULL COMMENT '',
+ country varchar(255) NULL DEFAULT NULL COMMENT '' COLLATE latin1_swedish_ci,
+ plot text NULL DEFAULT NULL COMMENT '' COLLATE latin1_swedish_ci,
+ filename varchar(255) NULL DEFAULT NULL COMMENT '' COLLATE latin1_swedish_ci,
+ filesize int(16) unsigned NULL DEFAULT NULL COMMENT '',
+ filedate datetime NULL DEFAULT NULL COMMENT '',
+ audio_codec varchar(255) NULL DEFAULT NULL COMMENT '' COLLATE latin1_swedish_ci,
+ video_codec varchar(255) NULL DEFAULT NULL COMMENT '' COLLATE latin1_swedish_ci,
+ video_width int(10) unsigned NULL DEFAULT NULL COMMENT '',
+ video_height int(10) unsigned NULL DEFAULT NULL COMMENT '',
+ istv tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '',
+ lastupdate timestamp NOT NULL DEFAULT 'CURRENT_TIMESTAMP' COMMENT '',
+ seen tinyint(1) unsigned NOT NULL DEFAULT '0' COMMENT '',
+ mediatype int(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
+ custom1 varchar(255) NULL DEFAULT NULL COMMENT '' COLLATE latin1_swedish_ci,
+ custom2 varchar(255) NULL DEFAULT NULL COMMENT '' COLLATE latin1_swedish_ci,
+ custom3 varchar(255) NULL DEFAULT NULL COMMENT '' COLLATE latin1_swedish_ci,
+ custom4 varchar(255) NULL DEFAULT NULL COMMENT '' COLLATE latin1_swedish_ci,
+ created datetime NULL DEFAULT NULL COMMENT '',
+ owner_id int(11) NOT NULL DEFAULT '0' COMMENT '',
+ PRIMARY KEY (id),
+ INDEX seen (seen),
+ INDEX title_idx (title),
+ INDEX diskid_idx (diskid),
+ INDEX mediatype (mediatype, istv),
+ FULLTEXT INDEX actors_idx (actors),
+ FULLTEXT INDEX comment (comment)
+) DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci COMMENT='1.0(1157)';
+
+CREATE TABLE MEDIALIB_VIDEOGENRE (
+ video_id int(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
+ genre_id int(10) unsigned NOT NULL DEFAULT '0' COMMENT '',
+ PRIMARY KEY (video_id, genre_id)
+) DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci COMMENT='1.0(1157)';
+
+ALTER TABLE AUTOTIMER
+ COMMENT='1.0(1157)';
+
+
+ALTER TABLE CHANNELGROUPS
+ COMMENT='1.0(1157)';
+
+
+ALTER TABLE CHANNELS
+ COMMENT='1.0(1157)';
+
+
+ALTER TABLE CHRONICLE
+ COMMENT='1.0(1157)';
+
+
+ALTER TABLE EPG
+ COMMENT='1.0(1157)';
+
+
+ALTER TABLE MUSIC
+ MODIFY YEAR smallint(4) unsigned NULL DEFAULT NULL COMMENT '',
+ MODIFY BITRATE smallint(4) unsigned NULL DEFAULT NULL COMMENT '',
+ COMMENT='1.0(1157)';
+#
+# Fieldformats of
+# MUSIC.YEAR changed from tinyint(4) NULL DEFAULT NULL COMMENT '' to smallint(4) unsigned NULL DEFAULT NULL COMMENT ''.
+# MUSIC.BITRATE changed from tinyint(4) NULL DEFAULT NULL COMMENT '' to smallint(4) unsigned NULL DEFAULT NULL COMMENT ''.
+# Possibly data modifications needed!
+#
+
+ALTER TABLE OLDEPG
+ COMMENT='1.0(1157)';
+
+
+ALTER TABLE RECORDS
+ ADD RecordMD5 varchar(32) NOT NULL DEFAULT '' COMMENT '' COLLATE latin1_swedish_ci AFTER RecordId,
+ COMMENT='1.0(1157)';
+
+
+ALTER TABLE TIMERS
+ ADD eventid bigint(20) unsigned NULL DEFAULT '0' COMMENT '' AFTER Collision,
+ ADD eventstarttime datetime NULL DEFAULT NULL COMMENT '' AFTER eventid,
+ ADD eventduration int(10) unsigned NULL DEFAULT '0' COMMENT '' AFTER eventstarttime,
+ DROP NextEpgId,
+ COMMENT='1.0(1157)';
+
+
+ALTER TABLE USER
+ MODIFY Deny set('tlist','alist','rlist','mlist','tedit','aedit','redit','remote','stream','cedit','media') NULL DEFAULT NULL COMMENT '' COLLATE latin1_swedish_ci,
+ COMMENT='1.0(1157)';
+#
+# Fieldformat of
+# USER.Deny changed from set('tlist','alist','rlist','mlist','tedit','aedit','redit','remote','stream','cedit') NULL DEFAULT NULL COMMENT '' COLLATE latin1_swedish_ci to set('tlist','alist','rlist','mlist','tedit','aedit','redit','remote','stream','cedit','media') NULL DEFAULT NULL COMMENT '' COLLATE latin1_swedish_ci.
+# Possibly data modifications needed!
+#
+
+#
+# DDL END
+#
+
+SET FOREIGN_KEY_CHECKS = 1;
More information about the pkg-vdr-dvb-changes
mailing list