I am not familiar with "SET" but you can pass any sql in a migration with the "Execute" command Like so: (this is adding a foreign key and a GUID id rather than an auto-increment integer, but you get the point.)
class CreateSeats < ActiveRecord::Migration def self.up create_table(:seats, :id => false) do |t| t.string :id, :limit => 32, :null => false t.string :venue_id, :limit => 32, :null => false t.string :name t.string :section t.string :seat_row t.string :seat_number t.string :seat_type t.timestamps end execute "ALTER TABLE `seats` ADD PRIMARY KEY (`id`)" #add a foreign key execute "ALTER TABLE seats ADD CONSTRAINT fk_seats_venues FOREIGN KEY (venue_id) REFERENCES venues(id)" end def self.down #Drop foreign key execute "ALTER TABLE seats DROP FOREIGN KEY fk_seats_venues" drop_table :seats end end On Jan 18, 12:35 am, Dave <nec...@gmail.com> wrote: > Is it possible to use Mysql column type SET within RoR migration files? --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Ruby on Rails: Talk" group. To post to this group, send email to rubyonrails-talk@googlegroups.com To unsubscribe from this group, send email to rubyonrails-talk+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---