openfire_hsqldb.sql

开源OA办公系统！！！！！！！！！！！！！！！！！！！！！

ALTER TABLE jiveRemoteServerConf ALTER COLUMN domain RENAME TO xmppDomain;

ALTER TABLE jiveOffline ALTER COLUMN message RENAME TO stanza;

ALTER TABLE jiveVCard ALTER COLUMN value RENAME TO vcard;

ALTER TABLE jivePrivate ALTER COLUMN value RENAME TO privateData;

ALTER TABLE jiveUser ALTER COLUMN password RENAME TO plainPassword;

ALTER TABLE mucRoom ALTER COLUMN password RENAME TO roomPassword;

UPDATE jiveVersion set version=13 where name = 'openfire';