-- $Revision: 795 $ -- $Date: 2005-01-06 07:44:42 -0300 (Thu, 06 Jan 2005) $ -- jiveGroup: Recreate table from scratch DROP TABLE jiveGroup; CREATE TABLE jiveGroup ( groupName VARCHAR(50) NOT NULL, description VARCHAR(255), CONSTRAINT jiveGroup_pk PRIMARY KEY (groupName) ); -- jiveGroupProp: Recreate table from scratch DROP TABLE jiveGroupProp; CREATE TABLE jiveGroupProp ( groupName VARCHAR(50) NOT NULL, name VARCHAR(100) NOT NULL, propValue TEXT NOT NULL, CONSTRAINT jiveGroupProp_pk PRIMARY KEY (groupName, name) ); -- jiveGroupUser: Recreate table from scratch DROP TABLE jiveGroupUser; CREATE TABLE jiveGroupUser ( groupName VARCHAR(50) NOT NULL, username VARCHAR(32) NOT NULL, administrator INTEGER NOT NULL, CONSTRAINT jiveGroupUser_pk PRIMARY KEY (groupName, username, administrator) ); -- mucRoom: Add new columns: "lockedDate" and "emptyDate". Rename column "invitationRequired" to "membersOnly". Delete columns: "lastActiveDate" and "inMemory". ALTER TABLE mucRoom ADD COLUMN lockedDate CHAR(15) NOT NULL; ALTER TABLE mucRoom ADD COLUMN emptyDate CHAR(15) NULL; ALTER TABLE mucRoom RENAME COLUMN invitationRequired TO membersOnly; ALTER TABLE mucRoom DROP COLUMN lastActiveDate; ALTER TABLE mucRoom DROP COLUMN inMemory; -- mucMember: Add new columns ALTER TABLE mucMember ADD COLUMN firstName VARCHAR(100) NULL; ALTER TABLE mucMember ADD COLUMN lastName VARCHAR(100) NULL; ALTER TABLE mucMember ADD COLUMN url VARCHAR(100) NULL; ALTER TABLE mucMember ADD COLUMN email VARCHAR(100) NULL; ALTER TABLE mucMember ADD COLUMN faqentry VARCHAR(100) NULL; -- mucConversationLog: Add new index CREATE INDEX mucLog_time_idx ON mucConversationLog (time); -- Deletes no longer needed entries DELETE FROM jiveID where idType = 3; DELETE FROM jiveID where idType = 4; -- Add jiveVersion table CREATE TABLE jiveVersion ( majorVersion INTEGER NOT NULL, minorVersion INTEGER NOT NULL ); INSERT INTO jiveVersion (majorVersion, minorVersion) VALUES (2, 1);