Just an addendum to this, I don't think there's any way to do this at the
moment in Sequel using it's own methods, your best bet is probably to insert
it in your code like this:
If I'm incorrect about Sequel's lack of support for this I'm sure someone
will shout be down ;)
unless DB2[:mytable].table_exists?
DB2.create_table :mytable do
column :username, :text
...
..
end
DB2.execute("ALTER TABLE mytable ADD INDEX mytable_username_index
(username(256));")
end
Clive
2009/2/28 Clive Crous <[email protected]>
> => ALTER TABLE mytable ADD INDEX mytable_username_index (username(256));
>
> You have to give a key size ( the 256 above ) to columns of TEXT and BLOB
> type in MySQL.
>
> Clive
>
>
>
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sequel-talk" group.
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
-~----------~----~----~----~------~----~------~--~---
