From 0e35ada8c0b0838310b2fda0357acfd8a106ce4c Mon Sep 17 00:00:00 2001 From: horchi Date: Fri, 20 Apr 2018 06:22:48 +0200 Subject: 2018-04-18: version 1.1.139 (horchi)\n change: Prepared search timer filter by channel number (to be added to WEBIF)\n\n --- scripts/epgd-dropall | 6 +++++- 1 file changed, 5 insertions(+), 1 deletion(-) (limited to 'scripts/epgd-dropall') diff --git a/scripts/epgd-dropall b/scripts/epgd-dropall index f8a2d00..2e3910d 100755 --- a/scripts/epgd-dropall +++ b/scripts/epgd-dropall @@ -110,11 +110,15 @@ if [ "${i}" = "y" ]; then mysql -u epg2vdr -Depg2vdr -e 'drop table if exists movie_media;' mysql -u epg2vdr -Depg2vdr -e 'drop view if exists thetvdbview;' + mysql -u epg2vdr -Depg2vdr -e 'update events set scrseriesid = null, scrseriesepisode = null, scrmovieid = null, scrsp = null;' + mysql -u epg2vdr -Depg2vdr -e 'update recordinglist set scrseriesid = null, scrseriesepisode = null, scrmovieid = null, scrnew = null, scrsp = null;' + + mysql -u epg2vdr -Depg2vdr -e 'drop table if exists usevents;' + echo "" echo "Scraper tables dropped!" fi - echo "-----------------------------" echo "-- Tables with User Data --" echo "-----------------------------" -- cgit v1.2.3