Hi,

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           &nbsp ;  _nodeI_     NOT NULL,
  password           &nbsp ;  _chr32_,
  encryptedPassword     _chr255_,
  name            &nb sp;     _chr100_,
  email            &n bsp;    _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.

LG

PS: If one is interested in writing this I'd be glad to hear.