From 34a7c36127316f72c6a3a7fcad1686693dab19b5 Mon Sep 17 00:00:00 2001
From: Nicolas Boisselier <nicolas.boisselier@gmail.com>
Date: Tue, 1 Mar 2016 21:25:40 +0000
Subject: [PATCH] Add view for sqlite

---
 lib/php/db.php | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

diff --git a/lib/php/db.php b/lib/php/db.php
index 28791206..6d2c0428 100644
--- a/lib/php/db.php
+++ b/lib/php/db.php
@@ -213,7 +213,7 @@ class db extends nb {
     if (isset($this->_tables) and $this->_tables) return $this->_tables;
 
     if ($this->type == 'sqlite') {
-      $sql = "SELECT name FROM sqlite_master WHERE type='table' AND name NOT LIKE 'sqlite_%' ORDER BY name";
+      $sql = "SELECT name FROM sqlite_master WHERE type IN('table','view') AND name NOT LIKE 'sqlite_%' ORDER BY name";
 
     } elseif ($this->type == 'pgsql') {
       $sql = "SELECT table_name FROM information_schema.tables WHERE table_type in('BASE TABLE','VIEW') AND table_schema NOT IN ('pg_catalog', 'information_schema')";
-- 
2.47.3