Schema Storage Suggestions

[figment]

Here is my issue:

I am building apps and I want them to be as multi platform/database/storage adaptable as possable.
I have decided to use PEAR for DB abstraction.

My Goal:
To store the database/table schemas in a way that is usable to as many DB's as PEAR supports; plus XML.

Any suggestions?

Case in point:
For instalation, the admin user should have the option to select data storage method, and have tables/databases automaticaly created based on what already exists.

Or if they decide to use XML, then the appropriate XML files with the same structure will be created.

[OhLordy]

I don't know about Pear but I personally would use XML to store the schemas because it is so simple. Once you have the basic structure you could create a translation class very easily to parse the XML file and translate it to the required format. The format rules and database functions would be set constructor (one option, $db_type)

HTH
Rob