Project involves merging multiple MySQL databases of identical structure into one large database housing all the data.
Since there are multiple foreign keys in this database, any conversion script will have to insert tables that have no foreign key dependencies first, and then import tables with dependencies, replacing the old ids for new ids.
Conversion script should be written in PHP using mysql module.
See the attached file (should save as a zip file) for a database layout.
Attached is a copy of our database specification. From this document, the coder should be able to determine how to combine all the the information into one site.
Note: In the case of your conversion script, all websiteid columns should be kept to 0. Some of these tables we will ask for you to check for and remove duplicate entries. In the case of the contentgroup table, we will ask that with each imported row, you add an additional row to category_contentgroup. We will give you more details in our formal specification.
NOTE: The script should NOT assume that all these tables exist. Some of these tables are plugins that not all of our clients use. If your conversion script cannot find a table, it should gracefully handle that instead of error out.