import sql files into migrations


    # first, create the method import_sql:

class ActiveRecord::ConnectionAdapters::MysqlAdapter
  def import_sql(file)
    conf = ActiveRecord::Base.configurations[RAILS_ENV]
    sql_file = File.join(RAILS_ROOT, 'db', file + '.sql')
    cmd_line = "mysql -h "+conf["host"]+" -D "+conf["database"]+ " --user="+conf["username"]+" --password="+conf["password"]+" < "+sql_file
    raise Exception, "Error executing " + cmd_line unless system(cmd_line)    
  end
end


# create a migration. ex:

./script/generate migration sql_external_test

# save your sql file with sql commands in db/. migration's sample:

class SqlExternalTest < ActiveRecord::Migration
  def self.up
    import_sql("test")
  end

  def self.down
  end
end


    2009-02-02T18:46:51Z
    it's a small how to import a file in migrations.

from: http://code-ronin.com/articles/rails-migrations-directly-import-sql
    151
    39
    false
    import sql files into migrations
    2009-02-02T18:46:51Z
    7


      create_table :table do |t|
    t.column # adds an ordinary column. Ex: t.column(:name, :string)
    t.index # adds a new index.
    t.timestamps
    t.change # changes the column definition. Ex: t.change(:name, :string, :limit => 80)
    t.change_default # changes the column default value.
    t.rename # changes the name of the column.
    t.references
    t.belongs_to
    t.string
    t.text
    t.integer
    t.float
    t.decimal
    t.datetime
    t.timestamp
    t.time
    t.date
    t.binary
    t.boolean
    t.remove
    t.remove_references
    t.remove_belongs_to
    t.remove_index
    t.remove_timestamps
  end
    2008-12-14T13:38:12Z
    
    132
    39
    false
    [rails] create_table methods
    2008-12-14T13:38:12Z
    7


    config.active_record.timestamped_migrations = false
    2008-11-26T23:34:49Z
    set in your environment.rb
    120
    39
    false
    migrations without timestamp
    2008-11-26T23:34:49Z
    7