diff options
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 "-----------------------------" |