#876 ✓duplicate
Calj

dm-migrations MySQL CREATE TABLE syntax is wrong

Reported by Calj | June 2nd, 2009 @ 01:13 PM

I have just launched the migration example and I have this create table query for mysql :

CREATE TABLE people ENGINE = InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci (id serial PRIMARY KEY, name VARCHAR(50), age INT(11))

As you can see in http://dev.mysql.com/doc/refman/5.1/en/create-table.html the table_options should be at the end of the (create_definition,...)

The correct syntax is :

CREATE TABLE people (id serial PRIMARY KEY, name VARCHAR(50), age INT(11)) ENGINE = InnoDB CHARACTER SET utf8 COLLATE utf8_general_ci

I attached a suggestion patch.

Comments and changes to this ticket

Please Sign in or create a free account to add a new ticket.

With your very own profile, you can contribute to projects, track your activity, watch tickets, receive and update tickets through your email and much more.

New-ticket Create new ticket

Create your profile

Help contribute to this project by taking a few moments to create your personal profile. Create your profile »

People watching this ticket

Attachments

Tags

Referenced by

Pages