create_table syntax for MySQL creates MyISAM tables
Reported by Mark Bates | October 15th, 2008 @ 05:37 PM
When using the create_table syntax with MySQL and dm-migrations, it creates tables of the type MyISAM, the default should probably be InnoDB, as this supports transactions and is generally considered to be the type to be used going forward. Also, InnoDB appears to be the type created by auto_migrate!
Comments and changes to this ticket
-
Paul Sadauskas (Rando) October 16th, 2008 @ 01:14 AM
- Assigned user changed from “Sam Smoot” to “Paul Sadauskas (Rando)”
- State changed from “new” to “open”
It created InnoDB tables for me. I'm guessing I never specify what table type to use, so it just uses whatever MySQL has configured as it own default.
-
Dan Kubb (dkubb) December 1st, 2008 @ 01:21 AM
I think dm-migrations should behave in a consistent manner with how dm-core auto-migration behaves. In this case the table will always be created as InnoDB. Also the character set and collation of the table will be set to match whatever the connection is using.. otherwise defaulting to utf8 and utf8_general_ci respectively.
Here's a link to the associated code:
-
Dan Kubb (dkubb) January 8th, 2009 @ 03:05 PM
- State changed from “open” to “unconfirmed”
What's the status of this ticket? Is it confirmed to be an issue? Can the CREATE TABLE syntax specify InnoDB explicitly like auto-migrate does in dm-core?
-
Greg Campbell January 23rd, 2009 @ 08:22 PM
I can verify that tables are still created as MyISAM by dm-migrations.
-
Greg Campbell January 23rd, 2009 @ 10:51 PM
I've submitted a patch to fix this bug as a pull request to Rando; see http://github.com/gcampbell/dm-m... for the changes.
-
Greg Campbell January 25th, 2009 @ 05:04 PM
Sorry for the spam; I did some rebasing and reorganization (my git-fu is improving every day!) and the correct commit is http://github.com/gcampbell/dm-m...
-
Paul Sadauskas (Rando) January 27th, 2009 @ 04:10 PM
- State changed from “unconfirmed” to “resolved”
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.
Create new ticket
Create your profile
Help contribute to this project by taking a few moments to create your personal profile. Create your profile »
Paul Sadauskas (Rando)
Rick