CREATE TRIGGER delete_season
  AFTER DELETE
  ON seasons
BEGIN
        DELETE FROM art WHERE media_id=old.idSeason AND media_type='season';
        DELETE FROM episode WHERE Season=old.Season AND idShow=old.idShow;
        DELETE FROM uniqueid WHERE media_id=old.idSeason AND media_type='season';
        END;