We're updating the issue view to help you get more done. 

Allow to install Openfire and Clearspace in the same database

Description

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.

Environment

None

Acceptance Test - Entry

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

Activity

Show:
Daniel Henninger
March 10, 2008, 12:38 PM

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.

Daniel Henninger
March 10, 2008, 9:51 PM

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.

Daniel Henninger
April 1, 2008, 7:34 AM

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?

Daniel Henninger
April 1, 2008, 7:54 AM

Found and fixed. Only affects anyone who snuck into SVN for that brief time when it was broken.

Assignee

Daniel Henninger

Reporter

Gaston Dombiak

Labels

None

Expected Effort

None

Ignite Forum URL

None

Components

Fix versions

Affects versions

Priority

Major
Configure