From 5bb9073f49852a417a99ce8c6187860393102cef Mon Sep 17 00:00:00 2001
From: Nicolas Boisselier <nicolas.boisselier@semantico.com>
Date: Tue, 5 Jul 2016 16:13:32 +0100
Subject: [PATCH] create index

---
 lib/php/db.php | 12 +++++++++---
 1 file changed, 9 insertions(+), 3 deletions(-)

diff --git a/lib/php/db.php b/lib/php/db.php
index 23420257..bb268c4a 100644
--- a/lib/php/db.php
+++ b/lib/php/db.php
@@ -618,10 +618,11 @@ class Db extends nb {
     #if (NB_EOL == "\n")
 
     # Cache before changing db type
-    foreach ($tables as $t) {
+    foreach ($tables as $k=>$t) {
       unset($t->orderby);
       $t->fields();
       $t->sql();
+      if ($t->type == 'sql') unset($tables[$k]);
     }
 
     echo ''
@@ -637,7 +638,7 @@ class Db extends nb {
     }
 
     $type = self::p('type','');
-    $name = self::p('name','');
+    $name = self::p('name',self::p('table',''));
 
     foreach ($this->sql_exec() as $s) {
       echo rtrim($s,';').";\n";
@@ -653,7 +654,12 @@ class Db extends nb {
       }
       #echo 'DROP TABLE IF EXISTS '.$t->sql_name().';'.NB_EOL;
       echo 'DROP '.strtoupper($t->type).' IF EXISTS '.$t->sql_name().';'.NB_EOL;
-      echo str_replace(';CREATE',";\nCREATE",rtrim($t->create(),';')).';'.NB_EOL;
+
+      $sql = rtrim($t->create(),';');
+      $sql = str_replace(';CREATE',";\nCREATE",$sql);
+      #$sql = preg_replace('/;CREATE\s+(INDEX)\s+(\S+)(\s+ON\s+\S+[^;]+)/',";\nDROP $1 IF EXISTS $2;\nCREATE $1 $2",$sql);
+      echo $sql.';'.NB_EOL;
+
       if ($insert and $t->type == 'table') $t->rows();
       #break;
     }
-- 
2.47.3