From 982346b162844377b2c8f25fa012741d820b4f38 Mon Sep 17 00:00:00 2001
From: Nicolas Boisselier <nicolas.boisselier@gmail.com>
Date: Thu, 11 Jan 2018 02:31:32 +0000
Subject: [PATCH] etc/profile.d/dbq.sh

---
 etc/profile.d/dbq.sh       | 6 +++---
 lib/php/db.php             | 2 +-
 lib/php/db/types/mysql.php | 2 +-
 3 files changed, 5 insertions(+), 5 deletions(-)

diff --git a/etc/profile.d/dbq.sh b/etc/profile.d/dbq.sh
index 91c71b52..8660e136 100644
--- a/etc/profile.d/dbq.sh
+++ b/etc/profile.d/dbq.sh
@@ -1,15 +1,15 @@
 which dbq > /dev/null || return 0
 
 dbq2sqlite() {
-  dbq f=txt a=db.dump db_type=sqlite $@
+  dbq f=txt a=db.dump db-type=sqlite $@
 }
 
 dbq2mysql() {
-  dbq f=txt a=db.dump db_type=mysql $@
+  dbq f=txt a=db.dump db-type=mysql $@
 }
 
 dbq2pgsql() {
-  dbq f=txt a=db.dump db_type=pgsql $@
+  dbq f=txt a=db.dump db-type=pgsql $@
 }
 
 dbq_template() {
diff --git a/lib/php/db.php b/lib/php/db.php
index f4a91f56..64cce67d 100644
--- a/lib/php/db.php
+++ b/lib/php/db.php
@@ -978,7 +978,7 @@ class Db extends nb {
 
   public function sql($insert=null,$db_type='') {
     if ($insert === null) $insert = self::p('insert');
-    if (empty($db_type)) $db_type = self::p('db_type');
+    if (empty($db_type)) $db_type = self::p('db-type');
 
     # Params ! dirty !
 # NB 10.01.18     $this->pset('orderby',null);
diff --git a/lib/php/db/types/mysql.php b/lib/php/db/types/mysql.php
index f3a66d46..8a2ff631 100644
--- a/lib/php/db/types/mysql.php
+++ b/lib/php/db/types/mysql.php
@@ -15,7 +15,7 @@ $DB_TYPES['mysql'] = array (
 'file2table' => "LOAD DATA INFILE '<FILE> REPLACE INTO TABLE '<T.NAME>' TERMINATED BY '\\t' ENCLOSED BY '' LINES TERMINATED BY '\\r\\n' IGNORE 0 LINES",
 
 'table.sql' => 'SHOW CREATE TABLE `<T.NAME>`',
-'table.sql.index' => "SELECT ".(Db::p('db_type') ? "CONCAT(s.TABLE_NAME,'_',s.INDEX_NAME,'_idx')" : 's.INDEX_NAME')." as name,(CASE NON_UNIQUE WHEN 1 THEN 0 ELSE 1 END) as uniqe,GROUP_CONCAT(COLUMN_NAME) as field FROM INFORMATION_SCHEMA.STATISTICS s LEFT OUTER JOIN INFORMATION_SCHEMA.TABLE_CONSTRAINTS t ON t.TABLE_SCHEMA=s.TABLE_SCHEMA AND t.TABLE_NAME=s.TABLE_NAME  AND s.INDEX_NAME=t.CONSTRAINT_NAME  WHERE 0=0 AND t.CONSTRAINT_NAME IS NULL AND s.TABLE_SCHEMA = DATABASE() AND s.TABLE_NAME='<T.NAME>' GROUP BY name,uniqe,SEQ_IN_INDEX ORDER BY SEQ_IN_INDEX",
+'table.sql.index' => "SELECT ".(Db::p('db-type') ? "CONCAT(s.TABLE_NAME,'_',s.INDEX_NAME,'_idx')" : 's.INDEX_NAME')." as name,(CASE NON_UNIQUE WHEN 1 THEN 0 ELSE 1 END) as uniqe,GROUP_CONCAT(COLUMN_NAME) as field FROM INFORMATION_SCHEMA.STATISTICS s LEFT OUTER JOIN INFORMATION_SCHEMA.TABLE_CONSTRAINTS t ON t.TABLE_SCHEMA=s.TABLE_SCHEMA AND t.TABLE_NAME=s.TABLE_NAME  AND s.INDEX_NAME=t.CONSTRAINT_NAME  WHERE 0=0 AND t.CONSTRAINT_NAME IS NULL AND s.TABLE_SCHEMA = DATABASE() AND s.TABLE_NAME='<T.NAME>' GROUP BY name,uniqe,SEQ_IN_INDEX ORDER BY SEQ_IN_INDEX",
 # NB 04.07.16 '_table.sql.index' => [
 # NB 04.07.16   'SHOW INDEX FROM `<T.NAME>`', function(&$r) {
 # NB 04.07.16     if ($r['Key_name'] != 'PRIMARY') return [
-- 
2.47.3