jive_forums_oracle_upgrade_3_0_to_3_2_2.sql

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

REM
REM Jive Forums Upgrade Script - Jive Forums 3.0 through 3.2.1 -> 3.2.2
REM
REM $RCSFile$
REM $Revision: 13293 $
REM $Date: 2004-12-13 09:22:09 -0800 (Mon, 13 Dec 2004) $

REM /////////////////////////////////////////////////////////////////
REM //                                                             //
REM //    Works on any Oracle DB version                           //
REM //                                                             //
REM /////////////////////////////////////////////////////////////////

ALTER TABLE jiveAttachment MODIFY (messageID INTEGER CONSTRAINT nn_attachmentID NULL);
UPDATE jiveAttachment SET messageID=null WHERE messageID=-1;