#!/bin/bash 

echo "---------------------"
echo "-- Drop all tables --"
echo "-- (except images) --"
echo "---------------------"
echo -n "Are you sure? [y/N] " 

read -n 1 c

echo ""

if [ "${c}" = "y" ]; then 

   mysql -u epg2vdr -pepg -Depg2vdr -e 'drop table events;'
   mysql -u epg2vdr -pepg -Depg2vdr -e 'drop table fileref;'
   mysql -u epg2vdr -pepg -Depg2vdr -e 'drop table imagerefs;'
   mysql -u epg2vdr -pepg -Depg2vdr -e 'drop table channelmap;'
   mysql -u epg2vdr -pepg -Depg2vdr -e 'drop table episodes;'
   mysql -u epg2vdr -pepg -Depg2vdr -e 'drop view eventsview;'
   mysql -u epg2vdr -pepg -Depg2vdr -e 'drop table components;'
   mysql -u epg2vdr -pepg -Depg2vdr -e 'drop table parameters;'

   mysql -u epg2vdr -pepg -Depg2vdr -e 'drop table vdrs;'

   mysql -u epg2vdr -pepg -Depg2vdr -e 'drop table analyse;'
   mysql -u epg2vdr -pepg -Depg2vdr -e 'drop table snapshot;'

   echo "Tables droped!"
fi

echo "---------------------"
echo "-- Drop procedures --"
echo "---------------------"
echo -n "Are you sure? [y/N] " 

read -n 1 c

echo ""

if [ "${c}" = "y" ]; then
   mysql -u epg2vdr -pepg -Depg2vdr -e 'drop procedure reverseepg;'
   mysql -u epg2vdr -pepg -Depg2vdr -e 'drop procedure mergeepg;'

   mysql -u epg2vdr -pepg -Depg2vdr -e 'drop function getupdflg;'
   mysql -u epg2vdr -pepg -Depg2vdr -e 'drop function getcrosslvr;'
   mysql -u epg2vdr -pepg -Depg2vdr -e 'drop function getlvrmin;'
fi

echo "-------------------"
echo "--  Drop images  --"
echo "-------------------"
echo "In most cases you dont need to drop the image table."
echo -n "Drop image tables? [y/N] " 

read -n 1 i

if [ "${i}" = "y" ]; then 
   mysql -u epg2vdr -pepg -Depg2vdr -e 'drop table images;'
   echo ""
   echo "Table images droped!"
fi
