From 6c493fa8cf9f864bd41774c94c150293bd8ae311 Mon Sep 17 00:00:00 2001
From: Nicolas Boisselier <nicolas.boisselier@semantico.com>
Date: Fri, 1 Jul 2016 10:19:13 +0100
Subject: [PATCH] table.sql sqlite

---
 lib/php/db/types/sqlite.php | 4 ++--
 1 file changed, 2 insertions(+), 2 deletions(-)

diff --git a/lib/php/db/types/sqlite.php b/lib/php/db/types/sqlite.php
index ead4fc79..a36afe7d 100644
--- a/lib/php/db/types/sqlite.php
+++ b/lib/php/db/types/sqlite.php
@@ -11,8 +11,8 @@ $DB_TYPES['sqlite'] = array (
 'quote_name' => '`',
 'quote' => function(&$v) { return "'".str_replace("'","''",$v)."'"; },
 
-'table.sql' => 'SELECT sql FROM sqlite_master WHERE name=\'<NAME>\'',
-'table.truncate' => 'DELETE FROM \'<NAME>\'',
+#'table.sql' => 'SELECT sql FROM sqlite_master WHERE name=\'<NAME>\'',
+'table.sql' => "SELECT GROUP_CONCAT(sql,';') FROM sqlite_master WHERE tbl_name='<NAME>'",
 'table.csv.load' => ['.mode csv','.sep \\t','.import <FILE> <NAME>'],
 
 'sqliteCreateFunction' => array (
-- 
2.47.3