From: Nathan Bird <nathan@acceleration.net>
Date: Tue, 24 Apr 2012 15:49:08 +0000 (-0400)
Subject: Mysql > CREATE TABLE: use 'engine' keyword instead of 'type'.
X-Git-Tag: v6.1.1~4
X-Git-Url: http://git.kpe.io/?p=clsql.git;a=commitdiff_plain;h=49b3604f1b86ad2de1487f2da3b3b53c904eaf4a

Mysql > CREATE TABLE: use 'engine' keyword instead of 'type'.
---

diff --git a/ChangeLog b/ChangeLog
index 8ee52db..1dee24a 100644
--- a/ChangeLog
+++ b/ChangeLog
@@ -1,3 +1,10 @@
+2012-04-24  Nathan Bird  <nathan@acceleration.net>
+
+	* sql/expressions.lisp (output-sql): on mysql CREATE TABLE
+	statements use 'ENGINE=innodb' instead of 'Type=InnoDB'. This has
+	apparently been preferred since mysql 4.1 and mysql 5.5 removed
+	type as a valid keyword.
+
 2012-03-28  Russ Tyndall <russ@acceleration.net>
 
         * sql/sequences.lisp: [A Patch FROM 2011-07-28 changed sequences.
diff --git a/sql/expressions.lisp b/sql/expressions.lisp
index 9335ae0..1479e67 100644
--- a/sql/expressions.lisp
+++ b/sql/expressions.lisp
@@ -939,7 +939,7 @@ uninclusive, and the args from that keyword to the end."
       (when (and (eq :mysql (database-underlying-type database))
                  transactions
                  (db-type-transaction-capable? :mysql database))
-        (write-string " Type=InnoDB" *sql-stream*))))
+        (write-string " ENGINE=innodb" *sql-stream*))))
   t)