In Chapter 4 of Sitepoint’s Simply Rails 2, you are told to run the command

sqlite3 db/development.sqlite3


then execute the sql query

CREATE TABLE `stories` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(255) default NULL,
`link` varchar(255) default NULL,
PRIMARY KEY (`id`)
);


Unfortunately, following these directions you get the error: Unable to open database "db/development.sqlite3": unable to open database file.

After searching a sitepoint post I found that you have to run rake db:migrate first in the command line from the shovell directory project first, and then run this SQL query instead:

CREATE TABLE `stories` (
`id` int(11) autoincrement NOT NULL,
`name` varchar(255) default NULL,
`link` varchar(255) default NULL,
`created_at` datetime DEFAULT NULL,
`updated_at` datetime DEFAULT NULL,
PRIMARY KEY (`id`)
);