From dec81616ef768b438065810e096ef66b8bddebf5 Mon Sep 17 00:00:00 2001
From: "Nathan T. Weeks" <nathan.weeks@ars.usda.gov>
Date: Thu, 23 Feb 2017 13:31:33 -0600
Subject: [PATCH] Support the SQLite FTS5 extension.

---
 Bio/DB/SeqFeature/Store/DBI/SQLite.pm | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/Bio/DB/SeqFeature/Store/DBI/SQLite.pm b/Bio/DB/SeqFeature/Store/DBI/SQLite.pm
index 846cb7523..2d0d070cd 100644
--- a/Bio/DB/SeqFeature/Store/DBI/SQLite.pm
+++ b/Bio/DB/SeqFeature/Store/DBI/SQLite.pm
@@ -436,7 +436,7 @@ sub _create_attribute_fts{
         $dbh->do("CREATE VIRTUAL TABLE "
              . $self->_attribute_table
              . " USING " . $fts_versions[-1]
-             . "(id integer not null, attribute_id integer not null, attribute_value text)");
+             . "(id, attribute_id, attribute_value)");
     }
 }
 
-- 
2.11.4.GIT