openfire_mysql.sql 546 Bytes
Newer Older
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18
# $Revision:  $
# $Date:  $

ALTER TABLE pubsubItem CHANGE payload payload MEDIUMTEXT;

ALTER TABLE jiveRemoteServerConf CHANGE domain xmppDomain VARCHAR(255) NOT NULL;

ALTER TABLE jiveOffline CHANGE message stanza TEXT NOT NULL;

ALTER TABLE jiveVCard CHANGE value vcard MEDIUMTEXT NOT NULL;

ALTER TABLE jivePrivate CHANGE value privateData TEXT NOT NULL;

ALTER TABLE jiveUser CHANGE password plainPassword VARCHAR(32);

ALTER TABLE mucRoom CHANGE password roomPassword VARCHAR(50);

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