用友畅捷通T1商贸宝11.1升级到11.5升级脚本补丁文件下载
发布时间：2021-03-04 21:56:00 访问数:1310
-------------------------------------------------------------------
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@--
--2015年08月28日14点51分49秒
--清除触发器
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@--
declare c_c cursor local for
select name from sysobjects where xtype='TR'
declare @trname sysname
open c_c
fetch c_c into @trname
while @@fetch_status=0
begin
exec('drop trigger '+@trname)
fetch c_c into @trname
end
close c_c
deallocate c_c
go
go
-------------------------------------------------------------------
-------------------------------------------------------------------
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@--
--2015年08月28日14点51分49秒
--插入表纪录
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@--
-----批发零售增加字段的脚本11.1.1.0到11.1.2.0 begin----
if not exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[VIPLogUser]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
begin
CREATE TABLE [dbo].[VIPLogUser] (
[s_ID] [int] IDENTITY (1, 1) NOT NULL ,
[s_Syb] [smallint] NULL ,
[u_Remark] [text] COLLATE Chinese_PRC_CI_AS NULL ,
[VIP_ID] [int] NULL ,
[RecDate] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[Unit_ID] [int] NULL ,
[Holder] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[IDTType] [smallint] NULL ,
[IDTCard] [varchar] (25) COLLATE Chinese_PRC_CI_AS NULL ,
[Oper_ID] [int] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
ALTER TABLE [dbo].[VIPLogUser] WITH NOCHECK ADD
CONSTRAINT [PK_VIPLogUser] PRIMARY KEY CLUSTERED
(
[s_ID]
) ON [PRIMARY]
ALTER TABLE [dbo].[VIPLogUser] ADD
CONSTRAINT [DF_VIPLogUser_s_Syb] DEFAULT (0) FOR [s_Syb]
end
go
ALTER TABLE VIPCard
ADD [Oper_ID] int
go
ALTER TABLE ListBuy
ADD [Remark1] varchar(800), [Remark2] varchar(800),[Remark3] varchar(800)
go
ALTER TABLE ListBuyDft
ADD [Remark1] varchar(800), [Remark2] varchar(800),[Remark3] varchar(800)
go
ALTER TABLE ListMoney
ADD [Remark1] varchar(800), [Remark2] varchar(800),[Remark3] varchar(800)
go
ALTER TABLE ListMoneyDft
ADD [Remark1] varchar(800), [Remark2] varchar(800),[Remark3] varchar(800)
go
ALTER TABLE ListOrder
ADD [Remark1] varchar(800), [Remark2] varchar(800),[Remark3] varchar(800)
go
ALTER TABLE ListOther
ADD [Remark1] varchar(800), [Remark2] varchar(800),[Remark3] varchar(800)
go
ALTER TABLE ListOtherDft
ADD [Remark1] varchar(800), [Remark2] varchar(800),[Remark3] varchar(800)
go
ALTER TABLE ListSale
ADD [Remark1] varchar(800), [Remark2] varchar(800),[Remark3] varchar(800)
go
ALTER TABLE ListSaleDft
ADD [Remark1] varchar(800), [Remark2] varchar(800),[Remark3] varchar(800)
go
ALTER TABLE ListProdCheckDft
ADD [Remark1] varchar(800), [Remark2] varchar(800),[Remark3] varchar(800)
go
ALTER TABLE ListProdCheck
ADD [Remark1] varchar(800), [Remark2] varchar(800),[Remark3] varchar(800)
go
ALTER TABLE DTS_ListBuy
ADD [Remark1] varchar(800), [Remark2] varchar(800),[Remark3] varchar(800)
go
ALTER TABLE DTS_ListMoney
ADD [Remark1] varchar(800), [Remark2] varchar(800),[Remark3] varchar(800)
go
ALTER TABLE DTS_ListOther
ADD [Remark1] varchar(800), [Remark2] varchar(800),[Remark3] varchar(800)
go
ALTER TABLE DTS_ListSale
ADD [Remark1] varchar(800), [Remark2] varchar(800),[Remark3] varchar(800)
go
ALTER TABLE DTS_ListSale
ADD [Remark1] varchar(800), [Remark2] varchar(800),[Remark3] varchar(800)
go
ALTER TABLE DTS_ListProdCheck
ADD [Remark1] varchar(800), [Remark2] varchar(800),[Remark3] varchar(800)
go
ALTER TABLE MasterBill ADD
UfidaPZH2 varchar(50) NULL
go
ALTER TABLE MasterBill ADD
MakeUfidaPZ varchar(50) DEFAULT (''),UfidaPZH varchar(50)
go
ALTER TABLE ListOtherDft ADD
Prod_BaseNumber numeric(20, 8)
go
ALTER TABLE ListBuyDft ADD
AddProd bit
go
ALTER TABLE ListBuy ADD
AddProd bit
go
ALTER TABLE ListSale ADD
AddProd bit
go
ALTER TABLE ListSaleDft ADD
AddProd bit
go
ALTER TABLE DTS_ListBuy ADD
AddProd bit
go
ALTER TABLE DTS_ListSale ADD
AddProd bit
go
ALTER TABLE Product ADD
AddProd bit
go
ALTER TABLE ProductInOut ADD
AddProd bit
go
CREATE TABLE [WarPBLog] (
[AutoID] [int] IDENTITY (1, 1) NOT NULL ,
[WarDate] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[WarTime] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[WarIndex] [int] NULL ,
[BillType] [int] NULL ,
[SIn_ID] [int] NULL ,
[SOut_ID] [int] NULL ,
CONSTRAINT [PK_WarPBLog] PRIMARY KEY CLUSTERED
(
[AutoID]
) ON [PRIMARY]
) ON [PRIMARY]
GO
----------------------财务接口------------------------------------------
ALTER TABLE Product ADD
Backup_ID varchar(100)
go
ALTER TABLE Employee ADD
Backup_ID varchar(100),Backup_Name varchar(100)
go
ALTER TABLE Units ADD
Backup_ID varchar(100),Backup_Name varchar(100)
go
ALTER TABLE dbo.Units ADD
Backup_ID1 varchar(100) NULL,
Backup_Name1 varchar(100) NULL
go
ALTER TABLE Department ADD
Backup_ID varchar(100),Backup_Name varchar(100)
go
ALTER TABLE Area ADD
Backup_ID varchar(100),Backup_Name varchar(100)
go
ALTER TABLE StorHouse ADD
Backup_ID varchar(100)
go
CREATE TABLE [dbo].[F_PZList] (
[AutoID] [int] IDENTITY (1, 1) NOT NULL ,
[FullID] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[ChoiceID] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[Bill_ID] [int] NULL ,
[Bill_SN] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[BillType] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[BillType_Sale] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[Abst] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[Act_List_ID] [int] NULL ,
[Act_List_Code] [varchar] (60) COLLATE Chinese_PRC_CI_AS NULL ,
[Act_List_Name] [varchar] (60) COLLATE Chinese_PRC_CI_AS NULL ,
[CodeType] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[CodeID] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[CodeName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[MoneyJF] [numeric](20, 8) NULL ,
[MoneyDF] [numeric](20, 8) NULL ,
[NumJF] [numeric](28, 8) NULL ,
[NumDF] [numeric](20, 8) NULL ,
[Prod_ID_Ufida] [varchar] (60) COLLATE Chinese_PRC_CI_AS NULL ,
[Prod_Name_Ufida] [varchar] (60) COLLATE Chinese_PRC_CI_AS NULL ,
[Prod_ID] [int] NULL ,
[Prod_Code] [varchar] (60) COLLATE Chinese_PRC_CI_AS NULL ,
[Prod_Name] [varchar] (60) COLLATE Chinese_PRC_CI_AS NULL ,
[Dept_ID_Ufida] [varchar] (60) COLLATE Chinese_PRC_CI_AS NULL ,
[Dept_Name_Ufida] [varchar] (60) COLLATE Chinese_PRC_CI_AS NULL ,
[Dept_ID] [int] NULL ,
[Dept_Code] [varchar] (60) COLLATE Chinese_PRC_CI_AS NULL ,
[Dept_Name] [varchar] (60) COLLATE Chinese_PRC_CI_AS NULL ,
[Oper_ID_Ufida] [varchar] (60) COLLATE Chinese_PRC_CI_AS NULL ,
[Oper_Name_Ufida] [varchar] (60) COLLATE Chinese_PRC_CI_AS NULL ,
[Oper_ID] [int] NULL ,
[Oper_Code] [varchar] (60) COLLATE Chinese_PRC_CI_AS NULL ,
[Oper_Name] [varchar] (60) COLLATE Chinese_PRC_CI_AS NULL ,
[Emp_ID_Ufida] [varchar] (60) COLLATE Chinese_PRC_CI_AS NULL ,
[Emp_Name_Ufida] [varchar] (60) COLLATE Chinese_PRC_CI_AS NULL ,
[Emp_ID] [int] NULL ,
[Emp_Code] [varchar] (60) COLLATE Chinese_PRC_CI_AS NULL ,
[Emp_Name] [varchar] (60) COLLATE Chinese_PRC_CI_AS NULL ,
[Audit_ID_Ufida] [varchar] (60) COLLATE Chinese_PRC_CI_AS NULL ,
[Audit_Name_Ufida] [varchar] (60) COLLATE Chinese_PRC_CI_AS NULL ,
[Audit_ID] [int] NULL ,
[Audit_Code] [varchar] (60) COLLATE Chinese_PRC_CI_AS NULL ,
[Audit_Name] [varchar] (60) COLLATE Chinese_PRC_CI_AS NULL ,
[Unit_GH_ID_Ufida] [varchar] (60) COLLATE Chinese_PRC_CI_AS NULL ,
[Unit_GH_Name_Ufida] [varchar] (60) COLLATE Chinese_PRC_CI_AS NULL ,
[Unit_GH_ID] [int] NULL ,
[Unit_GH_Code] [varchar] (60) COLLATE Chinese_PRC_CI_AS NULL ,
[Unit_GH_Name] [varchar] (60) COLLATE Chinese_PRC_CI_AS NULL ,
[Unit_KH_ID_Ufida] [varchar] (60) COLLATE Chinese_PRC_CI_AS NULL ,
[Unit_KH_Name_Ufida] [varchar] (60) COLLATE Chinese_PRC_CI_AS NULL ,
[Unit_KH_ID] [int] NULL ,
[Unit_KH_Code] [varchar] (60) COLLATE Chinese_PRC_CI_AS NULL ,
[Unit_KH_Name] [varchar] (60) COLLATE Chinese_PRC_CI_AS NULL ,
[Bill_Date] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[Info] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
[ZS] [int] NULL ,
[PZFlag] [bit] NOT NULL
) ON [PRIMARY]
GO
