* Chronicle: store also epg description (change db layout version-32)

* Chronicle: ignore cutted recordings
* jason: show description from recording stored by chronicle

3 files changed, 5 insertions, 4 deletions

diff --git a/contrib/chronicle-remove-duplicate.pl b/contrib/chronicle-remove-duplicate.pl
index 2902107..fca29ef 100755
--- a/contrib/chronicle-remove-duplicate.pl
+++ b/contrib/chronicle-remove-duplicate.pl
@@ -56,7 +56,7 @@ sub dump_duplicates {
     or die "Couldn't execute dump statement: " . $sth->errstr;
 
   while (@data = $sth->fetchrow_array()) {
-    print sprintf("%3d: %20s   %s\n",$data[0],$data[2],$data[1]);
+    print sprintf("%3d: %20s   %s\n",$data[0],$data[2] || '',$data[1]);
   }
 
   if ($sth->rows == 0) {
diff --git a/contrib/update-xxv b/contrib/update-xxv
index 8567cd4..f94facb 100755
--- a/contrib/update-xxv
+++ b/contrib/update-xxv
@@ -18,7 +18,7 @@
 
 # Increment the version number each time the database changes!
 #
-actualVersion=31
+actualVersion=32
 
 # Specify tables to export before and import after update
 #
diff --git a/contrib/upgrade-xxv-db.sql b/contrib/upgrade-xxv-db.sql
index 885a777..6b4a050 100644
--- a/contrib/upgrade-xxv-db.sql
+++ b/contrib/upgrade-xxv-db.sql
@@ -32,11 +32,12 @@ CREATE TABLE IF NOT EXISTS `AUTOTIMER` (
 
 CREATE TABLE IF NOT EXISTS `CHRONICLE` (
   `id` int(10) unsigned NOT NULL auto_increment,
-  `hash` varchar(16) NOT NULL default '',
+  `hash` varchar(32) NOT NULL default '',
   `title` text NOT NULL,
-  `channel_id` varchar(100) NOT NULL default '',
+  `channel_id` varchar(32) default '',
   `starttime` datetime NOT NULL default '0000-00-00 00:00:00',
   `duration` int(11) NOT NULL default '0',
+  `description` text,
   PRIMARY KEY  (`id`),
   UNIQUE KEY `hash` (`hash`)
 );