From 22e2e9cf49411855fd896337210a890fb61a8670 Mon Sep 17 00:00:00 2001
From: =?UTF-8?q?Daniel=20Sch=C3=BCrmann?= <daschuer@mixxx.org>
Date: Sun, 4 Nov 2018 01:49:28 +0100
Subject: user DROP instead of DELETE

---
 src/library/banshee/bansheeplaylistmodel.cpp | 8 ++++----
 src/library/banshee/bansheeplaylistmodel.h   | 2 +-
 2 files changed, 5 insertions(+), 5 deletions(-)

(limited to 'src/library/banshee')

diff --git a/src/library/banshee/bansheeplaylistmodel.cpp b/src/library/banshee/bansheeplaylistmodel.cpp
index 8d70427f16..4f2b52caee 100644
--- a/src/library/banshee/bansheeplaylistmodel.cpp
+++ b/src/library/banshee/bansheeplaylistmodel.cpp
@@ -44,15 +44,15 @@ BansheePlaylistModel::BansheePlaylistModel(QObject* pParent, TrackCollection* pT
 }
 
 BansheePlaylistModel::~BansheePlaylistModel() {
-    deleteTempTable();
+    dropTempTable();
 }
 
-void BansheePlaylistModel::deleteTempTable() {
+void BansheePlaylistModel::dropTempTable() {
     if (m_playlistId >= 0) {
         // Clear old playlist
         m_playlistId = -1;
         QSqlQuery query(m_pTrackCollection->database());
-        QString strQuery("DELETE FROM %1");
+        QString strQuery("DROP TABLE IF EXISTS %1");
         if (!query.exec(strQuery.arg(m_tempTableName))) {
             LOG_FAILED_QUERY(query);
         }
@@ -66,7 +66,7 @@ void BansheePlaylistModel::setTableModel(int playlistId) {
         return;
     }
 
-    deleteTempTable();
+    dropTempTable();
 
     if (playlistId >= 0) {
         // setup new playlist
diff --git a/src/library/banshee/bansheeplaylistmodel.h b/src/library/banshee/bansheeplaylistmodel.h
index 398e8b7c72..d89fc20a8a 100644
--- a/src/library/banshee/bansheeplaylistmodel.h
+++ b/src/library/banshee/bansheeplaylistmodel.h
@@ -43,7 +43,7 @@ class BansheePlaylistModel : public BaseSqlTableModel {
   private:
     QString getFieldString(const QModelIndex& index, const QString& fieldName) const;
     QVariant getFieldVariant(const QModelIndex& index, const QString& fieldName) const;
-    void deleteTempTable();
+    void dropTempTable();
 
     BansheeDbConnection* m_pConnection;
     int m_playlistId;
-- 
cgit v1.2.3