I'm working with an existing MySQL schema and am adapting Sequel to work
with it for a Rails project. The primary keys of most of the database are
binary blobs representing UUIDs. I used Sequel's schema dumper as a
starting place for future migrations and got something like this:
create_table(:example_table, :ignore_index_errors=>true) do
File :id, :size=>16, :null=>false
primary_key [:id]
index [:id], :name=>:id_UNIQUE, :unique=>true, :size=>16
end
Unfortunately, when I attempt to run a migration like this, I get the
following error:
Mysql2::Error: BLOB/TEXT column 'id' used in key specification without a
key length
The short question is, how do I get around this problem and still use
migrations?
--
You received this message because you are subscribed to the Google Groups
"sequel-talk" group.
To view this discussion on the web visit
https://groups.google.com/d/msg/sequel-talk/-/J7d10BCm67EJ.
To post to this group, send email to [email protected].
To unsubscribe from this group, send email to
[email protected].
For more options, visit this group at
http://groups.google.com/group/sequel-talk?hl=en.
