diff options
| author | horchi <vdr@jwendel.de> | 2018-04-20 06:22:48 +0200 |
|---|---|---|
| committer | horchi <vdr@jwendel.de> | 2018-04-20 06:22:48 +0200 |
| commit | 0e35ada8c0b0838310b2fda0357acfd8a106ce4c (patch) | |
| tree | 71e50f061b93bdc623a1d7e9c0339b6ccd324c60 /scripts/epgd-dropall | |
| parent | cc0ddd47a78d451b445cfa7667757400c619cd5b (diff) | |
| download | vdr-epg-daemon-0e35ada8c0b0838310b2fda0357acfd8a106ce4c.tar.gz vdr-epg-daemon-0e35ada8c0b0838310b2fda0357acfd8a106ce4c.tar.bz2 | |
2018-04-18: version 1.1.139 (horchi)\n change: Prepared search timer filter by channel number (to be added to WEBIF)\n\n1.1.139
Diffstat (limited to 'scripts/epgd-dropall')
| -rwxr-xr-x | scripts/epgd-dropall | 6 |
1 files changed, 5 insertions, 1 deletions
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 "-----------------------------" |