[OSM-dev] 0.6 database table creation script for mysql?

Matt Amos zerebubuth at gmail.com
Tue Dec 9 17:54:00 GMT 2008


On Tue, Dec 9, 2008 at 5:41 PM, Maarten Deen <mdeen at xs4all.nl> wrote:
> Shaun McDonald wrote:
>> For MySQL, you can setup rails api06 branch, and run rake db:migrate.

and for 0.6 you can in postgres as well :-)

> And to comment on rails_port_branches/api06/db/migrate/001_create_osm_db.rb in
> svn: I thought the tags on nodes were put in a separate table? At least that's
> what I I understand from the 0.6 wiki page.
> But the ruby script still makes a node table with a tags column and there is no
> node_tags.

this is the essence of migrations - they follow the evolution of the
database. the change to a separate table was made in
018_populate_node_tags_and_remove_helper.rb.

if you like i could send you the output of mysqldump -d?

cheers,

matt




More information about the dev mailing list