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?