Skip to content

Instantly share code, notes, and snippets.

@shmohawk
Created March 29, 2018 03:51
Show Gist options
  • Save shmohawk/a4e3a90d54b071baad812a99baa63fa8 to your computer and use it in GitHub Desktop.
Save shmohawk/a4e3a90d54b071baad812a99baa63fa8 to your computer and use it in GitHub Desktop.
diff --git a/mdb2sql.sh b/mdb2sql.sh
index ffba647..9f62730 100755
--- a/mdb2sql.sh
+++ b/mdb2sql.sh
@@ -26,4 +26,5 @@ done
echo "regenerating searchable text..."
./xml2txt.py ${dbfile}
+sqlite3 ${dbfile} "CREATE VIRTUAL TABLE fts USING fts4(ft text, id INTEGER); INSERT INTO fts SELECT value_xml,id FROM xml"
echo "done"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment