foreman/db/migrate/20101018120603_create_sources.rb @ 8a65dff7
4cbaa406 | Ohad Levy | class CreateSources < ActiveRecord::Migration
|
|
def self.up
|
|||
create_table :sources do |t|
|
|||
t.text :value
|
|||
end
|
|||
if ActiveRecord::Base.connection.instance_values["config"][:adapter] == "mysql"
|
|||
execute "ALTER TABLE sources ENGINE = MYISAM"
|
|||
execute "ALTER TABLE sources ADD FULLTEXT (value)"
|
|||
else
|
|||
add_index :sources, :value
|
|||
end
|
|||
end
|
|||
def self.down
|
|||
remove_index :sources, :value
|
|||
drop_table :sources
|
|||
end
|
|||
end
|