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

[Maarten Deen]

Shaun McDonald wrote:
> 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.

Ah, that was not clear to me. In general, why would you bother someone who just 
wants the latest database with the full history?

> 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.

Thanks, much appreciated.

And IMHO it is not very considerate to expect people who just want to have the 
database to have them install rails and then get the output of one mangy little 
file.

For all I'm worth, the latest database structure should be available for 
download as an easy create script. Just include it in Osmosis or so. I mean: you 
only have to include the script that osmosis works with (currently 0.5 and 0.6), 
it's not like there are a dozen versions to consider.

Regards,
Maarten