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

[Brett Henderson]

Brett Henderson wrote:
> Still plenty of room for improvement but getting there.
>
> Anyway, I've packaged up another version available at:
> http://www.bretth.com/osmosis/osmosis-0.2.zip
> http://www.bretth.com/osmosis/osmosis-latest.zip
>
> As an aside, I've "finished" coding the database replication tasks which 
> are --read-mysql-change and --write-mysql-change.  Completely untested 
> though so the chances of anything working at this point are remote.
>
> I've updated the instructions at:
> http://www.bretth.com/wiki/Wiki.jsp?page=OpenStreetMap
>
> I'm unlikely to get any more time on this for a couple of days, my 
> weekend is booked out :-)
>   
Just to clarify, it doesn't create the table structure, the rails 
migration scripts are still required for this.

However, I've taken a dump of my current schema using mysqldump 
--no-data.  It won't create the database itself, just the tables.  It's 
available at:
http://www.bretth.com/osmosis/osm_schema_20070707.sql
http://www.bretth.com/osmosis/osm_schema_latest.sql