# $RCSfile$ # $Revision$ # $Date$ # upgrades from Messenger 1.1.x to 2.0.x CREATE TABLE jiveProperty ( name VARCHAR(100) NOT NULL, propValue TEXT NOT NULL, PRIMARY KEY (name) ); # MUC Tables CREATE TABLE mucRoom ( roomID BIGINT NOT NULL, creationDate CHAR(15) NOT NULL, modificationDate CHAR(15) NOT NULL, name VARCHAR(50) NOT NULL, naturalName VARCHAR(255) NOT NULL, description VARCHAR(255), canChangeSubject TINYINT NOT NULL, maxUsers INTEGER NOT NULL, publicRoom TINYINT NOT NULL, moderated TINYINT NOT NULL, invitationRequired TINYINT NOT NULL, canInvite TINYINT NOT NULL, password VARCHAR(50) NULL, canDiscoverJID TINYINT NOT NULL, logEnabled TINYINT NOT NULL, subject VARCHAR(100) NULL, rolesToBroadcast TINYINT NOT NULL, lastActiveDate CHAR(15) NULL, inMemory TINYINT NOT NULL, PRIMARY KEY (name), INDEX mucRoom_roomid_idx (roomID) ); CREATE TABLE mucAffiliation ( roomID BIGINT NOT NULL, jid TEXT NOT NULL, affiliation TINYINT NOT NULL, PRIMARY KEY (roomID,jid(70)) ); CREATE TABLE mucMember ( roomID BIGINT NOT NULL, jid TEXT NOT NULL, nickname VARCHAR(255) NULL, PRIMARY KEY (roomID,jid(70)) ); CREATE TABLE mucConversationLog ( roomID BIGINT NOT NULL, sender TEXT NOT NULL, nickname VARCHAR(255) NULL, time CHAR(15) NOT NULL, subject VARCHAR(255) NULL, body TEXT NULL ); # Unique ID entry for mucRoom INSERT INTO jiveID (idType, id) VALUES (23, 1);