Yes, I agree that the second migration seems to be trying to re-create
the schema table.
The database is a legacy SQL Server db with over 100 tables already in
existence.
I've noticed that db/schema.rb contains no information re the table
that was built, hence rake trying to re-create the schema_migrations
table.
The first migration created a searches table:
class CreateSearches < ActiveRecord::Migration
def self.up
create_table :searches do |t|
t.date :start
t.date :end
t.integer :team_id
t.integer :match_id
t.integer :innings_id
t.integer :over_id
t.integer :ball_id
t.integer :match_session_id
t.integer :bowler_id
t.integer :delivery_type_id
t.integer :extra_type_id
t.integer :appeal_id
t.integer :shot_type_id
t.integer :runs_id
t.integer :batter_id
t.integer :umpire_id
t.integer :validity_id
t.integer :decison_id
t.integer :height_id
t.integer :extra_runs_id
t.timestamps
end
end
def self.down
drop_table :searches
end
end
and the second migration tried to rename one of the columns:
class RenameTeamId < ActiveRecord::Migration
def self.up
rename_column :searches, :team_id, :home_team_id
end
def self.down
rename_column :searches, :home_team_id, :team_id
end
end
Dropping the whole DB is really not an option.
Martin
On Jan 8, 4:41 pm, "Hassan Schroeder" <hassan.schroe...@gmail.com>
wrote:
> On Thu, Jan 8, 2009 at 8:36 AM, Martin Hawkins <martin.hawk...@gmail.com>
> wrote:
> > No, I didn't edit an existing migration - I created a new one for the
> > rename.
>
> It sounds like your second migration is trying to create the schema table
> which already exists.
>
> Maybe you could post your migrations, or at least the failing one?
>
> > I understand what you are saying about dropping the table (not the
> > entire db surely :-0).
>
> Yes, the whole DB -- if you're wanting to fix a bad migration and run
> it all from the beginning. That's not a bad thing early in a project.
>
> --
> Hassan Schroeder ------------------------ hassan.schroe...@gmail.com
--~--~---------~--~----~------------~-------~--~----~
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
-~----------~----~----~----~------~----~------~--~---
