Brad Eck wrote:
I’ve got a bunch of table creations in the schema.rb file and all is
well. However, I have to manually go and create the db first. Is there a
way (something like a create_database method) to get this to work?
(execute “create database …” didn’t seem to cut it either.)
Which database are you using? Which version of Rails?
I am using Rails 1.0.0 with mySQL 4.1 on Mac OS X.
I created a migration:
script/generate migration CreateDatabase
in my ‘up’ method, I put
in my ‘down’ method, I put:
‘foo’ is there
rake migrate VERSION=0
‘foo’ is not there
Of course, you can’t connect to this database with settings in
database.yml until it is already created. Secondly, I am using the root
user on mysql which has CREATE TABLE permissions.
But if you are wanting to create some other database, it should work
just fine (depending on which db and Rails version you are using).