Rename the tables whose name collide with Clearspace. The goal is to be able to install both products in the same databases. Also make sure that the list of supported DBs are the same (i.e. CS is included in OF). For now, Clearspace and Openfire will use their own tables and will not read from each others table. We just need to let admins install them in the same database.
1. Install CS and OF in the same database
2. Check that tables were created and no collision exist
3. Both products should work fine and not share the same tables
If we must do this, I see no reason to pick and choose. We should rename all of the tables across the board to be prefixed with something like of. ofJiveProperties. stuff like that. In my opinion, we should also be renaming the Clearspace tables to have a prefix as well, so as to aim to prevent conflicts in the future.
Also, I don't think it will be a good idea to plan on having CS and OF use the same tables in the future. CS owns it's tables. It knows it's tables. It should be able to freely mess with them without having to be concerned that Openfire (or anything external for that matter) is screwing with it's tables. =) Same goes for Openfire.
Obviously we can't force them, but we should also put in the plugin dev docs a recommendation to prefix their plugin tables the same way.
Completed and committed to trunk, but through jdbc and apparently through jdbc only, the old table is being left around even after a rename? What sense does that make?
Found and fixed. Only affects anyone who snuck into SVN for that brief time when it was broken.