r1604 - in vdr/vdr-xxv/trunk/debian: . upgrade

[Tobias Grimm]

Author: tiber-guest
Date: 2005-12-08 21:02:57 +0000 (Thu, 08 Dec 2005)
New Revision: 1604

Added:
   vdr/vdr-xxv/trunk/debian/upgrade/0.52
Modified:
   vdr/vdr-xxv/trunk/debian/changelog
   vdr/vdr-xxv/trunk/debian/control
Log:
new upstream version

Modified: vdr/vdr-xxv/trunk/debian/changelog
===================================================================
--- vdr/vdr-xxv/trunk/debian/changelog	2005-12-08 18:31:22 UTC (rev 1603)
+++ vdr/vdr-xxv/trunk/debian/changelog	2005-12-08 21:02:57 UTC (rev 1604)
@@ -1,3 +1,12 @@
+vdr-xxv (0.52-1) UNRELEASED; urgency=low
+
+  * (NOT RELEASED YET) New upstream release
+  * Due to a bug in dbconfig-common, previous database updates might not have
+    been applied. By dropping all tables but AUTOTIMERS and USERS, the
+    creation of a fresh database structure is forced.
+
+ -- Tobias Grimm <tg at e-tobi.net>  Thu,  8 Dec 2005 18:26:26 +0100
+
 vdr-xxv (0.50+svn599-1) unstable; urgency=low
 
   * Tobias Grimm <tg at e-tobi.net>

Modified: vdr/vdr-xxv/trunk/debian/control
===================================================================
--- vdr/vdr-xxv/trunk/debian/control	2005-12-08 18:31:22 UTC (rev 1603)
+++ vdr/vdr-xxv/trunk/debian/control	2005-12-08 21:02:57 UTC (rev 1604)
@@ -8,7 +8,7 @@
 
 Package: vdr-xxv
 Architecture: all
-Depends:  ${perl:Depends}, debconf (>= 0.5.00), dbconfig-common (> 1.8.6), vdr (>= 1.3.33-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
+Depends:  ${perl:Depends}, debconf (>= 0.5.00), dbconfig-common (> 1.8.8), vdr (>= 1.3.33-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
 Recommends: mysql-server
 Suggests: mplayer, vdr-plugin-osdteletext | vdr-plugin-teletext
 Description: Provides a central service to administer VDR

Added: vdr/vdr-xxv/trunk/debian/upgrade/0.52
===================================================================
--- vdr/vdr-xxv/trunk/debian/upgrade/0.52	2005-12-08 18:31:22 UTC (rev 1603)
+++ vdr/vdr-xxv/trunk/debian/upgrade/0.52	2005-12-08 21:02:57 UTC (rev 1604)
@@ -0,0 +1,19 @@
+SET FOREIGN_KEY_CHECKS = 0;
+
+ALTER TABLE AUTOTIMER
+    ALTER VPS SET DEFAULT 'n',
+    MODIFY Weekdays set('Mon','Tue','Wed','Thu','Fri','Sat','Sun') NOT NULL DEFAULT '',
+    COMMENT='';
+
+ALTER TABLE USER
+    COMMENT='';
+
+DROP TABLE IF EXISTS CHANNELGROUPS
+DROP TABLE IF EXISTS CHANNELS;
+DROP TABLE IF EXISTS MUSIC
+DROP TABLE IF EXISTS EPG;
+DROP TABLE IF EXISTS OLDEPG;
+DROP TABLE IF EXISTS RECORDS;
+DROP TABLE IF EXISTS TIMERS;
+
+SET FOREIGN_KEY_CHECKS = 1;