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

Shaun McDonald shaun at shaunmcdonald.me.uk
Tue Dec 9 18:03:11 GMT 2008


Maarten Deen wrote:
> Shaun McDonald wrote:
>   
>> For MySQL, you can setup rails api06 branch, and run rake db:migrate.
>>     
>
> 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.
>
>   
The migrations run through the full history of how the database used to 
be structured.

I have uploaded the current structure to:
http://dev.openstreetmap.org/~shaunmcdonald/development_structure.23.sql
There are more foreign key constraints due to be added before 0.6 is 
released.

Shaun

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.openstreetmap.org/pipermail/dev/attachments/20081209/bf9d876c/attachment.html>


More information about the dev mailing list