[OSM-dev] How do I build the latest db schema?

Brett Henderson brett at bretth.com
Wed Jun 27 05:37:47 BST 2007


Is there a script somewhere for building the current database schema?

The database schema wiki page at 
http://wiki.openstreetmap.org/index.php/Database_schema links to 
http://trac.openstreetmap.org/browser/sites/rails_port/db/create_database.sql 
but this link is broken.

Checking the sites\rails_port\db directory in svn, I found a file named 
MAKE_MIGRATIONS_AND_TEST_THEM_DONT_PUT_SQL_HERE_ANY_MORE along with a 
readme stating to use a ruby rake tool.

In addition, there is a file in a migrate subdirectory called 
001_create_osm_db.rb that seems to contain a complete schema, not just a 
migration from an older schema.  Given that it is 001, perhaps this is 
intended to be the first such script.

Apologies, but my ruby/rails knowledge doesn't extend much past knowing 
that they exist.

Is rake the preferred method for building the latest schema?  If so, 
I'll try to get it running.






More information about the dev mailing list