MySql World Database as YAML fixture

For Symfony application I’m developing I needed all the Region separated by continent (7 continents model). I converted the MySql World Database (http://dev.mysql.com/doc/world-setup/en/world-setup.html) to a YAML NestedSet fixture file.
I just had to make 4 minor changes to it:
- rename the 3 continents that had region with the same name name (North America, South America, Antarctica)
- rename the Micronesia/Caribbean region to Micronesia-Caribbean.

thats’ all, enjoy the file Region.yml

Marco

You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

Leave a Reply

XHTML: You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> <pre lang="" line="" escaped="">