# $RCSfile$ # $Revision$ # $Date$ # upgrades from Messenger 1.1.x to 2.0.x CREATE TABLE jiveProperty ( name NVARCHAR(100) NOT NULL, propValue NTEXT NOT NULL, CONSTRAINT jiveProperty_pk PRIMARY KEY (name) ); /* MUC Tables */ CREATE TABLE mucRoom ( roomID INT NOT NULL, creationDate CHAR(15) NOT NULL, modificationDate CHAR(15) NOT NULL, name NVARCHAR(50) NOT NULL, naturalName NVARCHAR(255) NOT NULL, description NVARCHAR(255), canChangeSubject INT NOT NULL, maxUsers INT NOT NULL, publicRoom INT NOT NULL, moderated INT NOT NULL, invitationRequired INT NOT NULL, canInvite INT NOT NULL, password NVARCHAR(50) NULL, canDiscoverJID INT NOT NULL, logEnabled INT NOT NULL, subject NVARCHAR(100) NULL, rolesToBroadcast INT NOT NULL, lastActiveDate CHAR(15) NULL, inMemory INT NOT NULL, CONSTRAINT mucRoom__pk PRIMARY KEY (name) ); CREATE INDEX mucRoom_roomID_idx on mucRoom(roomID); CREATE TABLE mucAffiliation ( roomID INT NOT NULL, jid NVARCHAR(3000) NOT NULL, affiliation INT NOT NULL, CONSTRAINT mucAffiliation__pk PRIMARY KEY (roomID,jid) ); CREATE TABLE mucMember ( roomID INT NOT NULL, jid NVARCHAR(3000) NOT NULL, nickname NVARCHAR(255) NULL, CONSTRAINT mucMember__pk PRIMARY KEY (roomID,jid) ); CREATE TABLE mucConversationLog ( roomID INT NOT NULL, sender NVARCHAR(3000) NOT NULL, nickname NVARCHAR(255) NULL, time CHAR(15) NOT NULL, subject NVARCHAR(255) NULL, body NVARCHAR(3700) NULL ); # Unique ID entry for mucRoom INSERT INTO jiveID (idType, id) VALUES (23, 1);