jive_forums_sqlserver2000_upgrade_3_0_to_3_2_2.sql

来自「Jive Forums 论坛源码 v4.2.3」· SQL 代码 · 共 14 行

#
# Jive Forums Upgrade Script - Jive Forums 3.0 through 3.2.1 -> 3.2.2
#
# $RCSFile: $
# $Revision: 11859 $
# $Date: 2004-09-21 12:30:18 -0700 (Tue, 21 Sep 2004) $

DROP INDEX jiveAttachment.jiveAttachment_messageID_idx;
ALTER TABLE jiveAttachment DROP CONSTRAINT jiveAttachment_msgID_fk;
ALTER TABLE jiveAttachment ALTER COLUMN messageID BIGINT NULL;
CREATE INDEX jiveAttachment_messageID_idx ON jiveAttachment (messageID);
ALTER TABLE jiveAttachment ADD CONSTRAINT jiveAttachment_msgID_fk FOREIGN KEY (messageID) REFERENCES jiveMessage;
UPDATE jiveAttachment SET messageID=null WHERE messageID=-1;