From 7cbc904be722b493a060e2ad69849344124fbe91 Mon Sep 17 00:00:00 2001
From: Bharat Mediratta <bharat@menalto.com>
Date: Sun, 8 Mar 2009 21:11:01 +0000
Subject: Post process the sql generation code to support prefixes

---
 core/controllers/scaffold.php | 9 +++++++++
 1 file changed, 9 insertions(+)

(limited to 'core/controllers/scaffold.php')

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");
   }
 
-- 
cgit v1.2.3