reapack

commit 9f491283ae7c19f132db0b79fb5490b6e6038e12
parent bec8855cff19d05a0282f85acd5b52b76dcdef3e
Author: cfillion <cfillion@users.noreply.github.com>
Date:   Sun, 22 May 2016 16:44:26 -0400

registry; write migration for adding `pinned` column to table `entries`

Diffstat:
M
src/registry.cpp
 | 
5
+++--

1 file changed, 3 insertions(+), 2 deletions(-)
diff --git a/src/registry.cpp b/src/registry.cpp
@@ -80,8 +80,6 @@ void Registry::migrate()
   case 0:
     // new database!
     m_db.exec(
-      "PRAGMA user_version = 1;"
-
       "CREATE TABLE entries ("
       "  id INTEGER PRIMARY KEY,"
       "  remote TEXT NOT NULL,"
@@ -104,6 +102,8 @@ void Registry::migrate()
     );
     break;
   case 1:
+    m_db.exec("ALTER TABLE entries ADD COLUMN pinned INTEGER DEFAULT 0;");
+  case 2:
     // current schema version
     break;
   default:
@@ -111,6 +111,7 @@ void Registry::migrate()
       "The package registry was created by a newer version of ReaPack");
   }
 
+  m_db.exec("PRAGMA user_version = 2");
   m_db.commit();
 }