Post process the sql generation code to support prefixes

1 files changed, 9 insertions, 0 deletions

diff --git a/core/controllers/scaffold.php b/core/controllers/scaffold.php
index 76b4ff71..768968fa 100644
--- a/core/controllers/scaffold.php
+++ b/core/controllers/scaffold.php
@@ -518,6 +518,15 @@ class Scaffold_Controller extends Template_Controller {
       print implode("\n", $output);
       return;
     }
+
+    // Post-process the sql file to support prefixes
+    foreach (file($sql_file) as $line) {
+      $buf .= preg_replace("/(CREATE TABLE|IF EXISTS|INSERT INTO) `(\w+)`/", "\\1 {\\2}", $line);
+    }
+    $fd = fopen($sql_file, "wb");
+    fwrite($fd, $buf);
+    fclose($fd);
+
     url::redirect("scaffold/dump_var");
   }