diff SQLite/Plugins/SQLiteIndex.cpp @ 238:f033cc039264

new table: "ServerProperties"
author Sebastien Jodogne <s.jodogne@gmail.com>
date Thu, 08 Apr 2021 19:33:36 +0200
parents 35598014f140
children a063bbf10a3e
line wrap: on
line diff
--- a/SQLite/Plugins/SQLiteIndex.cpp	Thu Apr 08 19:09:04 2021 +0200
+++ b/SQLite/Plugins/SQLiteIndex.cpp	Thu Apr 08 19:33:36 2021 +0200
@@ -133,6 +133,18 @@
           
       t.Commit();
     }
+
+    {
+      DatabaseManager::Transaction t(manager, TransactionType_ReadWrite);
+
+      if (!t.DoesTableExist("ServerProperties"))
+      {
+        t.ExecuteMultiLines("CREATE TABLE ServerProperties(server TEXT, "
+                            "property INTEGER, value TEXT, PRIMARY KEY(server, property))");
+      }
+
+      t.Commit();
+    }    
   }