Longtext in a Migration

Hey, I need to use "longtext" as a data type in a migration.

It works when I make create a table, like this:
  create_table :joes do |t|
    t.column :lots_o_content, :longtext

But if I try to add it to another table in a later migration, like this:
  add_column :sams, :lots_o_other_content, :longtext

Then I get this error when trying to run the migration:
-- add_column(:sams, :lots_o_other_content, :longtext)
rake aborted!
You have a nil object when you didn't expect it!
You might have expected an instance of Array.
The error occurred while evaluating nil.[]

My question is, how can I add a column of type "longtext" in a

You can’t, as it isn’t one of the column types, use :text, which is what you want for a text blob:


Best regards

Peter De Berdt

Never mind, I found out how to do it.

I just put this in the migration instead of using "add_column":
execute "ALTER TABLE sams ADD COLUMN lots_o_other_content LONGTEXT"