jive_forums_mysql_upgrade_4_0_to_4_1.sql

Jive Forums 论坛源码 v4.2.3

#
# Jive Forums Upgrade Script - Jive Forums 4.0 -> 4.1
#
# $RCSFile$
# $Revision: 16342 $
# $Date: 2005-06-10 13:19:18 -0700 (Fri, 10 Jun 2005) $


#
# NEW TABLES
#

CREATE TABLE jiveStatusLevel (
	statusLevelID	BIGINT		    NOT NULL,
	name			VARCHAR(255)	NOT NULL,
	description		TEXT,
	imagePath		VARCHAR(255)	NOT NULL,
    largeImagePath  VARCHAR(255)    NULL,
	minPoints		INT 		    NOT NULL,
	maxPoints		INT	    	    NOT NULL,
	groupID			BIGINT		    NOT NULL,
	PRIMARY KEY     (statusLevelID),
	UNIQUE          (name)
);

CREATE TABLE jiveStatusLevelProp (
  statusLevelID     BIGINT          NOT NULL,
  name              VARCHAR(100)    NOT NULL,
  propValue         TEXT            NOT NULL,
  PRIMARY KEY (statusLevelID,name)
);

CREATE TABLE jiveAvatar (
	avatarID	BIGINT		        NOT NULL,
	modValue	INTEGER		        NOT NULL,
	ownerID		BIGINT,
	PRIMARY KEY (avatarID),
	INDEX jiveAvatar_ownerID_idx (ownerID)
);

CREATE TABLE jiveAvatarProp (
	avatarID	BIGINT		        NOT NULL,
	name		VARCHAR(100)	    NOT NULL,
	propValue	TEXT            	NOT NULL,
	PRIMARY KEY (avatarID, name)
);

CREATE TABLE jiveAvatarUser (
	avatarID	BIGINT		        NOT NULL,
	userID		BIGINT              NOT NULL,
	PRIMARY KEY (avatarID,userID)
);

CREATE TABLE jiveQuestion (
	threadID		BIGINT NOT NULL,
	forumID			BIGINT NOT NULL,
	userID          BIGINT NOT NULL,
	creationDate	BIGINT NOT NULL,
	resolutionDate	BIGINT NULL,
	resolutionState	INT NOT NULL,
	PRIMARY KEY (threadID),
	INDEX jiveQuestion_cdate_idx (creationDate),
	INDEX jiveQuestion_rdate_idx (resolutionDate),
	INDEX jiveQuestion_state_idx (resolutionState)
);

CREATE TABLE jiveQuestionProp (
	threadID	BIGINT		        NOT NULL,
	name		VARCHAR(100)	    NOT NULL,
	propValue	TEXT            	NOT NULL,
	PRIMARY KEY (threadID, name)
);

CREATE TABLE jiveAnswer (
	threadID	   BIGINT NOT NULL,
	messageID      BIGINT NOT NULL,
	forumID        BIGINT NOT NULL,
	userID         BIGINT NULL,
	helpfulAnswer  INT NOT NULL,
	correctAnswer  INT NOT NULL,
	PRIMARY KEY (threadID, messageID)
);

# Fix the limit on attachment size (FORUMS-1322)
ALTER TABLE jiveAttachData MODIFY attachmentData LONGBLOB NOT NULL;

# Add 2 more ID values:

INSERT INTO jiveID (idType, id) VALUES (25, 1);
INSERT INTO jiveID (idType, id) VALUES (26, 1);