If I use rake db:rollback it will delete a table I don''t want. Then I add another migration with a new table. Then I run db:migrate. The table I didn''t want is created again. How do I delete it so it doesn''t come back? -- Posted via http://www.ruby-forum.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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
Example :
class CreateNewTable< ActiveRecord::Migration
def self.up
create_table :new_tables do |t|
t.column :name, :string
end
drop_table :old_tables
#rename_table :old_tables, :new_tables
rename_table :books, :libraries
#remove_column(table_name, column_name)
remove_column :items, :price
#remove_column(table_name, column_name)
rename_column "users", "password",
"hashed_password"
#add_column table_names, new_column_names
add_column "users", "email"
end
def self.down
drop_table :lupa_passwords
end
end
---------------------------------------------------
ANOTHER SCENARIO
---------------------------------------------------
I created a series of migrations named 001_migration.rb through
007_migration.rb. The last migration worked fine until I attempted to
rollback to the previous version using
rake db:migrate VERSION=6
which dropped all the tables in my database.
Now the migration refuses to do anything, regardless of which version
number I tell it to use. It always tried to run the latest version,
which fails because the relevant tables do not exist. What is wrong?
ANSWER: My migration names were the same. Each migration filename must
be different or you will receive errors.
Reinhart
http://teapoci.blogspot.com
-------------------------------------------------
FREE eBook Ruby
http://teapoci.blogspot.com/search/label/eBook
--
Posted via http://www.ruby-forum.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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
To unsubscribe from this group, send email to
rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org
For more options, visit this group at
http://groups.google.com/group/rubyonrails-talk?hl=en
-~----------~----~----~----~------~----~------~--~---
Visit Indonesia 2008 wrote:> Example : > > class CreateNewTable< ActiveRecord::Migration > def self.up > create_table :new_tables do |t| > t.column :name, :string > end > > drop_table :old_tables > >Thanks. Now I got it. -- Posted via http://www.ruby-forum.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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---
Pål Bergström wrote:>> class CreateNewTable< ActiveRecord::Migration >> def self.up >> create_table :new_tables do |t| >> t.column :name, :string >> end >> >> drop_table :old_tables> Thanks. Now I got it.Your customers won''t mind copying all the data from the old table to the new one. (-: -- Phlip --~--~---------~--~----~------------~-------~--~----~ 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-/JYPxA39Uh5TLH3MbocFFw@public.gmane.org To unsubscribe from this group, send email to rubyonrails-talk-unsubscribe@googlegroups.com For more options, visit this group at http://groups.google.com/group/rubyonrails-talk?hl=en -~----------~----~----~----~------~----~------~--~---