ALTER TABLE dbo.ProductCode
DROP CONSTRAINT PK_ProductCode
GO
ALTER TABLE dbo.ProductCode ADD CONSTRAINT
PK_ProductCode PRIMARY KEY CLUSTERED
(
AutoID,
Prod_ID,
u_Code
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[UserReportList] (
[Autoid] [int] IDENTITY (1, 1) NOT NULL ,
[ReportID] [int] NOT NULL ,
[userID] [int] NOT NULL ,
[ReportTypeid] [int] NULL ,
[OrderID] [int] NULL
) ON [PRIMARY]
GO
CREATE TABLE [dbo].[OnlinePayInfo] (
[AutoID] [int] IDENTITY (1, 1) NOT NULL ,
[BillNO] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[Customer] [varchar] (250) COLLATE Chinese_PRC_CI_AS NULL ,
[Amount] [numeric](18, 6) NULL ,
[Emp] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[Paytime] [datetime] NULL ,
[Reason] [varchar] (250) COLLATE Chinese_PRC_CI_AS NULL ,
[UnipayNo] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[Customerback] [varchar] (250) COLLATE Chinese_PRC_CI_AS NULL ,
[RealAmount] [numeric](18, 6) NULL ,
[UniPaytime] [datetime] NULL ,
[ServiceCharge] [numeric](18, 6) NULL ,
SFType int null
) ON [PRIMARY]
go
ALTER TABLE moneyAccount ADD Act_IFZFB bit
go
ALTER TABLE masterbill ADD UnipayNo varchar (50)
go
ALTER TABLE masterbilldft ADD UnipayNo varchar (50)
go
ALTER TABLE masterorder ADD UnipayNo varchar (50)
go
ALTER TABLE dbo.DTS_MasterBill ADD UnipayNo varchar (50)
go
ALTER TABLE dbo.Units ADD Birthday varchar (10)
go
ALTER TABLE moneyAccount ADD Act_ZFBUser varchar(200)
go
ALTER TABLE moneyAccount ADD Act_ZFBPass varchar(200)
go
ALTER TABLE moneyAccount ADD Act_ZFBName varchar(200)
go
CREATE TABLE [dbo].[UFmobileSet] (
[s_ID] [int] IDENTITY (1, 1) NOT NULL ,
[s_Syb] [smallint] NULL ,
[ContentInfo] [image] NULL ,
[note_username] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[note_password] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
[note_IncID] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[note_gateway] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
[proxy] [int] NULL ,
[proxy_server] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[proxy_port] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[proxy_username] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[proxy_password] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
[rest] [int] NULL ,
[Remark] [varchar] (200) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[UFmobileSet] WITH NOCHECK ADD
CONSTRAINT [PK_UFmobileSet] PRIMARY KEY CLUSTERED
(
[s_ID]
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[UFmobileSet] ADD
CONSTRAINT [DF_UFmobileSet_proxy] DEFAULT (0) FOR [proxy],
CONSTRAINT [DF_UFmobileSet_rest] DEFAULT (1) FOR [rest]
GO
