用text
CREATE TABLE jiveMessage (
messageID INT NOT NULL,
parentMessageID INT NULL,
threadID INT NOT NULL,
forumID INT NOT NULL,
userID INT NULL,
subject VARCHAR(255) NULL,
body TEXT NULL,
modValue INT NOT NULL,
rewardPoints INT NOT NULL,
creationDate CHAR(15) NOT NULL,
modifiedDate CHAR(15) NOT NULL,
CONSTRAINT message_pk PRIMARY KEY (messageID)
);
这个是jive2.5
的论坛消息表结构的创建sql语句。就是用的text