Hi,
We’re in the process of migrating from an old iChat server to Openfire and I’d like to transfer the user rosters.
Looking at the databases it looks like the “roster-items” and “oFRoster” tables are broadly the same but I’ve got some questions regarding the mapping of some of the fields.
iChat has:
“roster-items” (
“collection-owner” TEXT NOT NULL,
“object-sequence” INTEGER PRIMARY KEY,
“jid” TEXT NOT NULL,
“name” TEXT,
“to” BOOLEAN NOT NULL,
“from” BOOLEAN NOT NULL,
“ask” INTEGER NOT NULL );
ofRoster has:
±---------±--------------±-----±----±--------±------+
| Field | Type | Null | Key | Default | Extra |
±---------±--------------±-----±----±--------±------+
| rosterID | bigint(20) | NO | PRI | NULL | |
| username | varchar(64) | NO | MUL | NULL | |
| jid | varchar(1024) | NO | MUL | NULL | |
| sub | tinyint(4) | NO | | NULL | |
| ask | tinyint(4) | NO | | NULL | |
| recv | tinyint(4) | NO | | NULL | |
| nick | varchar(255) | YES | | NULL | |
±---------±--------------±-----±----±--------±------+
Does anyone know what the sub/ask/recv fields are and how (if?) the numeric values map across to the to/from values in the iChat database?