用友升级数据库报错解决方法

使用这个语句成功解决：

-- 补全rpt_itmdef（之前的表）
IF NOT EXISTS (SELECT * FROM sysobjects WHERE name='rpt_itmdef' AND xtype='U')
CREATE TABLE rpt_itmdef (
FieldName varchar(50) NOT NULL,
TableName varchar(50) NOT NULL,
FieldDef varchar(100) NULL,
TableDef varchar(100) NULL,
FieldType int NULL,
TableType int NULL,
PRIMARY KEY (FieldName,TableName)
)
GO

-- 补全Rpt_Folder（当前表）
IF NOT EXISTS (SELECT * FROM sysobjects WHERE name='Rpt_Folder' AND xtype='U')
BEGIN
CREATE TABLE Rpt_Folder (
    cSystemID varchar(2) NOT NULL,
    iFolderID int NOT NULL IDENTITY(1,1),
    cFolderName varchar(50) NOT NULL,
    bSystem bit NOT NULL,
    CONSTRAINT PK_Rpt_Folder PRIMARY KEY CLUSTERED (cSystemID, iFolderID)
)
END
GO

-- 补全Rpt_Item（报表项目表，常见后续缺失表）
IF NOT EXISTS (SELECT * FROM sysobjects WHERE name='Rpt_Item' AND xtype='U')
BEGIN
CREATE TABLE Rpt_Item (
    cItemID varchar(30) NOT NULL,
    cSystemID varchar(2) NOT NULL,
    iFolderID int NOT NULL,
    cItemName varchar(100) NOT NULL,
    cItemDef text NULL,
    bSystem bit NOT NULL,
    CONSTRAINT PK_Rpt_Item PRIMARY KEY CLUSTERED (cItemID)
)
END
GO

-- 插入折旧表目录
IF NOT EXISTS (SELECT 1 FROM Rpt_Folder WHERE cSystemID='FA' AND iFolderID=71)
BEGIN
    SET IDENTITY_INSERT Rpt_Folder ON
    INSERT INTO Rpt_Folder(cSystemID,iFolderID,cFolderName,bSystem)
    VALUES('FA',71,'折旧表',1)
    SET IDENTITY_INSERT Rpt_Folder OFF
END
GO