From 6e796416510c82a61f1e764618e2ad6d340d4692 Mon Sep 17 00:00:00 2001
From: ketmar <ketmar@ketmar.no-ip.org>
Date: Thu, 4 Nov 2021 14:03:35 +0000
Subject: [PATCH] version, sqlite

FossilOrigin-Name: 475308a5e3c8e04892af5d0050774a8d2e52738a842b313605ac58d01cc1052b
---
 install.rdf                         | 4 ++--
 main/modules/sbapi/scriptstorage.js | 7 ++++---
 2 files changed, 6 insertions(+), 5 deletions(-)

diff --git a/install.rdf b/install.rdf
index 6710690..9a3a00f 100644
--- a/install.rdf
+++ b/install.rdf
@@ -2,7 +2,7 @@
 <RDF:RDF xmlns:RDF="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns="http://www.mozilla.org/2004/em-rdf#">
  <RDF:Description about="urn:mozilla:install-manifest">
   <id>guerilla@ketmar.no-ip.org</id>
-  <version>0.0.3.7.5</version>
+  <version>0.0.3.7.6</version>
   <type>2</type>
   <name>Guerilla Scripting</name>
   <description>Userscript injecting engine for power users.</description>
@@ -49,7 +49,7 @@
    <RDF:Description>
     <id>{8de7fcbb-c55c-4fbe-bfc5-fc555c87dbc4}</id>
     <minVersion>27.0</minVersion>
-    <maxVersion>28.*</maxVersion>
+    <maxVersion>*</maxVersion>
    </RDF:Description>
   </targetApplication>
  </RDF:Description>
diff --git a/main/modules/sbapi/scriptstorage.js b/main/modules/sbapi/scriptstorage.js
index 6fe6fa6..43427fe 100644
--- a/main/modules/sbapi/scriptstorage.js
+++ b/main/modules/sbapi/scriptstorage.js
@@ -46,19 +46,20 @@ ScriptStorage.prototype.__defineGetter__("db", function () {
     // the auto_vacuum pragma has to be set before the table is created
     //this.dbObj.executeSimpleSQL("PRAGMA auto_vacuum = INCREMENTAL;");
     //this.dbObj.executeSimpleSQL("PRAGMA incremental_vacuum(10);");
+    this.dbObj.executeSimpleSQL("PRAGMA page_size = 512;");
     this.dbObj.executeSimpleSQL("PRAGMA auto_vacuum = NONE;");
     //this.dbObj.executeSimpleSQL("PRAGMA journal_mode = WAL;");
     //this.dbObj.executeSimpleSQL("PRAGMA wal_autocheckpoint = 10;");
     this.dbObj.executeSimpleSQL("PRAGMA journal_mode = DELETE;"); // will slow down bulk inserts, but IDC
     this.dbObj.executeSimpleSQL(
       "CREATE TABLE IF NOT EXISTS scriptvals ("+
-      "  name TEXT PRIMARY KEY NOT NULL,"+
-      "  value TEXT"+
+      "    name TEXT PRIMARY KEY NOT NULL"+
+      "  , value TEXT"+
       ")"
     );
     // run vacuum once manually to switch to the correct auto_vacuum mode for
     // databases that were created with incorrect auto_vacuum
-    this.dbObj.executeSimpleSQL("VACUUM;");
+    //this.dbObj.executeSimpleSQL("VACUUM;");
   }
   return this.dbObj;
 });
-- 
2.11.4.GIT