transform xml data to database native import

[brettatoms]

If we saved the default data in XML we could then transform this data using XSL to CSV or some other native import format the database could import directly. This would make the imports a helluva lot faster but would be database dependent.

Also, SQLite 3 doesn't support a load/import command so this can only be done from the command line with SQLite at least.

If we could either export the default data as SQL92 import statements or transform xml to import statements then we could just parse the lines one by one send them directly to the engine to be inserted.