r5929 - in /vdr/vdr-xxv/trunk/debian: changelog upgrade/1.0
tiber-guest at users.alioth.debian.org
tiber-guest at users.alioth.debian.org
Sun Nov 25 15:50:58 UTC 2007
Author: tiber-guest
Date: Sun Nov 25 15:50:58 2007
New Revision: 5929
URL: http://svn.debian.org/wsvn/pkg-vdr-dvb/?sc=1&rev=5929
Log:
* Simplified db upgrade script
Modified:
vdr/vdr-xxv/trunk/debian/changelog
vdr/vdr-xxv/trunk/debian/upgrade/1.0
Modified: vdr/vdr-xxv/trunk/debian/changelog
URL: http://svn.debian.org/wsvn/pkg-vdr-dvb/vdr/vdr-xxv/trunk/debian/changelog?rev=5929&op=diff
==============================================================================
--- vdr/vdr-xxv/trunk/debian/changelog (original)
+++ vdr/vdr-xxv/trunk/debian/changelog Sun Nov 25 15:50:58 2007
@@ -1,6 +1,7 @@
vdr-xxv (1.0-2) unstable; urgency=low
* Updated debian/copyright
+ * Simplified db upgrade script
-- Tobias Grimm <tg at e-tobi.net> Sun, 25 Nov 2007 15:57:49 +0100
Modified: 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=5929&op=diff
==============================================================================
--- vdr/vdr-xxv/trunk/debian/upgrade/1.0 (original)
+++ vdr/vdr-xxv/trunk/debian/upgrade/1.0 Sun Nov 25 15:50:58 2007
@@ -1,124 +1,21 @@
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
-#
+DROP TABLE IF EXISTS RECORDS;
+DROP TABLE IF EXISTS OLDEPG;
+DROP TABLE IF EXISTS MUSIC;
+DROP TABLE IF EXISTS EPG;
+DROP TABLE IF EXISTS CHANNELGROUPS;
+DROP TABLE IF EXISTS CHANNELS;
+DROP TABLE IF EXISTS TIMERS;
+
+DELETE FROM VERSION;
+INSERT INTO VERSION (Version) VALUES ('23');
SET FOREIGN_KEY_CHECKS = 1;
More information about the pkg-vdr-dvb-changes
mailing list