Im trying to do the message board tutorial here but I have rain into a
problem
I get this error message
SQLite3::SQLException: table posts already exists: CREATE TABLE posts
("id" INTE
GER PRIMARY KEY AUTOINCREMENT NOT NULL, "body" text DEFAULT NULL,
"created_at" d
atetime NOT NULL, "name" varchar(100) DEFAULT NULL,
"discussion_id"
integer NOT
NULL)
when I try to migrate this bit of code
class CreatePostsTable < ActiveRecord::Migration
def self.up
create_table :posts do |table|
table.column :body, :text
table.column :created_at, :datetime, :null => false
table.column :name, :string, :limit=>100
table.column :discussion_id, :integer, :null => false
end
execute "ALTER TABLE posts ADD CONSTRAINT fk_posts
FOREIGN KEY(discussion_id) REFERENCES discussions(id)"
end
def self.down
drop_table :posts
end
end
can anyone help me?
--
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
-~----------~----~----~----~------~----~------~--~---
