wildfire_oracle.sql 2.09 KB
Newer Older
1 2
-- $Revision: 795 $
-- $Date: 2005-01-06 07:44:42 -0300 (Thu, 06 Jan 2005) $
Gaston Dombiak's avatar
Gaston Dombiak committed
3

4
-- jiveGroup: Recreate table from scratch
Gaston Dombiak's avatar
Gaston Dombiak committed
5 6 7 8 9 10 11 12
DROP TABLE jiveGroup;
CREATE TABLE jiveGroup (
  groupName             VARCHAR2(50)    NOT NULL,
  description           VARCHAR2(255),
  CONSTRAINT jiveGroup_pk PRIMARY KEY (groupName)
);


13
-- jiveGroupProp: Recreate table from scratch
Gaston Dombiak's avatar
Gaston Dombiak committed
14 15 16 17 18 19 20 21 22
DROP TABLE jiveGroupProp;
CREATE TABLE jiveGroupProp (
  groupName             VARCHAR(50)     NOT NULL,
  name                  VARCHAR2(100)   NOT NULL,
  propValue             VARCHAR2(4000)  NOT NULL,
  CONSTRAINT jiveGroupProp_pk PRIMARY KEY (groupName, name)
);


23
-- jiveGroupUser: Recreate table from scratch
Gaston Dombiak's avatar
Gaston Dombiak committed
24 25 26 27 28 29 30 31 32
DROP TABLE jiveGroupUser;
CREATE TABLE jiveGroupUser (
  groupName             VARCHAR(50)     NOT NULL,
  username              VARCHAR2(32)    NOT NULL,
  administrator         INTEGER         NOT NULL,
  CONSTRAINT jiveGroupUser PRIMARY KEY (groupName, username, administrator)
);


33
-- mucRoom: Add new columns: "lockedDate" and "emptyDate". Rename column "invitationRequired" to "membersOnly". Delete columns: "lastActiveDate" and "inMemory".
Gaston Dombiak's avatar
Gaston Dombiak committed
34 35 36 37 38 39
ALTER TABLE mucRoom ADD lockedDate CHAR(15) NOT NULL;
ALTER TABLE mucRoom ADD emptyDate CHAR(15) NULL;
ALTER TABLE mucRoom RENAME COLUMN invitationRequired TO membersOnly;
ALTER TABLE mucRoom DROP COLUMN lastActiveDate;
ALTER TABLE mucRoom DROP COLUMN inMemory;

40
-- mucMember: Add new columns
Gaston Dombiak's avatar
Gaston Dombiak committed
41 42 43 44 45 46
ALTER TABLE mucMember ADD firstName VARCHAR2(100) NULL;
ALTER TABLE mucMember ADD lastName  VARCHAR2(100) NULL;
ALTER TABLE mucMember ADD url VARCHAR2(100) NULL;
ALTER TABLE mucMember ADD email VARCHAR2(100) NULL;
ALTER TABLE mucMember ADD faqentry VARCHAR2(100) NULL;

47
-- mucConversationLog: Add new index
Gaston Dombiak's avatar
Gaston Dombiak committed
48 49
CREATE INDEX mucLog_time_idx ON mucConversationLog (time);

50
-- Deletes no longer needed entries
Gaston Dombiak's avatar
Gaston Dombiak committed
51 52 53
DELETE FROM jiveID where idType = 3;
DELETE FROM jiveID where idType = 4;

54
-- Add jiveVersion table
Gaston Dombiak's avatar
Gaston Dombiak committed
55 56 57 58 59
CREATE TABLE jiveVersion (
  majorVersion  INTEGER  NOT NULL,
  minorVersion  INTEGER  NOT NULL
);
INSERT INTO jiveVersion (majorVersion, minorVersion) VALUES (2, 1);