# Mysql column type set

**URL:** <https://www.ruby-forum.com/t/mysql-column-type-set/158045>\
**Category:** Rails\
**Created:** [January 18, 2009, 1:55pm UTC](https://www.ruby-forum.com/t/mysql-column-type-set/158045 "2009-01-18T13:55:30Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![dave](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/ee7513/32.png) [@dave](https://www.ruby-forum.com/u/dave)\
**Post date:** [January 18, 2009, 1:55pm UTC](https://www.ruby-forum.com/t/mysql-column-type-set/158045/1 "2009-01-18T13:55:30Z")

</div>

Is it possible to use Mysql column type SET within RoR migration files?

---

<div class="post-metadata">

**Author:** ![dave](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/ee7513/32.png) [@dave](https://www.ruby-forum.com/u/dave)\
**Post date:** [January 18, 2009, 4:08pm UTC](https://www.ruby-forum.com/t/mysql-column-type-set/158045/2 "2009-01-18T16:08:48Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![dave](https://www.ruby-forum.com/letter_avatar_proxy/v4/letter/d/ee7513/32.png) [@dave](https://www.ruby-forum.com/u/dave)\
**Post date:** [January 18, 2009, 4:16pm UTC](https://www.ruby-forum.com/t/mysql-column-type-set/158045/3 "2009-01-18T16:16:41Z")

</div>

Thank you Teedub Ill pass it as an sql statement guess that’s the  
easiest  
way 🙂