jive_forums_mysql_upgrade_3_0_to_3_2_2.sql

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

#
# 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) $

ALTER TABLE jiveAttachment MODIFY messageID BIGINT NULL;
UPDATE jiveAttachment SET messageID=null WHERE messageID=-1;