From 49b3604f1b86ad2de1487f2da3b3b53c904eaf4a Mon Sep 17 00:00:00 2001 From: Nathan Bird Date: Tue, 24 Apr 2012 11:49:08 -0400 Subject: [PATCH] Mysql > CREATE TABLE: use 'engine' keyword instead of 'type'. --- ChangeLog | 7 +++++++ sql/expressions.lisp | 2 +- 2 files changed, 8 insertions(+), 1 deletion(-) diff --git a/ChangeLog b/ChangeLog index 8ee52db..1dee24a 100644 --- a/ChangeLog +++ b/ChangeLog @@ -1,3 +1,10 @@ +2012-04-24 Nathan Bird + + * 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 * 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) -- 2.34.1