I did start some time ago writing a script to convert openfire.sql to openfire_db2.sql, openfire_mysql.sql, openfire_oracle.sql etc. Currently it’s a shell script which parses one sql file to create db dependent sql files.
The openfire.sql file looks like this
CREATE TABLE jiveUser ( username _nodeI_ NOT NULL, password _chr32_, encryptedPassword _chr255_, name _chr100_, email _chr100_, creationDate _jivedate_ NOT NULL, modificationDate _jivedate_ NOT NULL, CONSTRAINT jiveUser_pk PRIMARY KEY (username) );
and my m4 based parser replaces the _foo_ fields with the right values for the database (at least for HSQLDB and Oracle). That’s a little bit lame and one may want to write something like this in Java so every plugin (thinking of Reuters XEP-0136 plugin which supports only a few databases) and also Openfire could be delivered with only one sql script. I did talk with JS about this but they do a lot of other things so they’ll likely not write such a tool within the next months.
PS: If one is interested in writing this I’d be glad to hear.