用友U8.52网银模块，NB_开头的数据库表修补脚本

USE [UFDATA_002_2008]
GO
/****** 对象:  Table [dbo].[NB_Account]    脚本日期: 07/11/2013 14:12:37 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[NB_Account](
	[cAccountNumber] [varchar](50) NOT NULL,
	[cAccountName] [varchar](60) NULL,
	[cBankId] [varchar](5) NOT NULL,
	[cBankName] [varchar](100) NULL,
	[cBankAddress] [varchar](60) NULL,
	[cPrinvince] [varchar](20) NULL,
	[cCity] [varchar](20) NULL,
	[cMoneyType] [varchar](10) NOT NULL,
	[cBankCode] [varchar](15) NOT NULL,
	[mBalance] [money] NOT NULL,
	[iProperty] [tinyint] NULL CONSTRAINT [DF_NB_Account_iProperty]  DEFAULT (0),
	[dOpenDate] [datetime] NULL,
	[dCancelDate] [datetime] NULL,
 CONSTRAINT [PK_NB_Account] PRIMARY KEY CLUSTERED 
(
	[cAccountNumber] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF


GO
/****** 对象:  Table [dbo].[NB_Authority]    脚本日期: 07/11/2013 14:13:26 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[NB_Authority](
	[cAuthorID] [varchar](5) NOT NULL,
	[cDescription] [varchar](50) NULL,
	[cEnName] [varchar](20) NULL,
 CONSTRAINT [PK_NB_Authority] PRIMARY KEY CLUSTERED 
(
	[cAuthorID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF



/****** 对象:  Table [dbo].[NB_bank]    脚本日期: 07/11/2013 14:13:42 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[NB_bank](
	[cBankId] [varchar](5) NOT NULL,
	[cBankName] [varchar](30) NOT NULL,
	[iAccountLength] [tinyint] NULL CONSTRAINT [DF_NB_bank_iAccountLength]  DEFAULT (12),
 CONSTRAINT [PK_NB_bank] PRIMARY KEY CLUSTERED 
(
	[cBankId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF


/****** 对象:  Table [dbo].[NB_BusinessClass]    脚本日期: 07/11/2013 14:13:53 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[NB_BusinessClass](
	[cID] [int] IDENTITY(1,1) NOT NULL,
	[cBusinessClass] [varchar](50) NULL,
	[cBalanceClass] [varchar](3) NULL,
 CONSTRAINT [PK_NB_BusinessClass] PRIMARY KEY CLUSTERED 
(
	[cID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF



/****** 对象:  Table [dbo].[nb_DetailFromBank]    脚本日期: 07/11/2013 14:14:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[nb_DetailFromBank](
	[iid] [int] IDENTITY(1,1) NOT NULL,
	[cAccountFrom] [varchar](50) NOT NULL,
	[dPayDate] [datetime] NOT NULL,
	[cAccountTo] [varchar](50) NOT NULL,
	[mMoney] [money] NOT NULL,
	[cSign] [varchar](10) NOT NULL,
	[cBillId] [varchar](30) NULL,
	[cCheckNum] [varchar](20) NULL,
	[cAbstract] [varchar](60) NULL,
	[cTransType] [varchar](50) NULL,
	[cPurpose] [varchar](60) NULL,
	[bBalanced] [bit] NULL,
	[iDZPeriod] [tinyint] NULL,
	[iExported] [tinyint] NULL,
 CONSTRAINT [PK_nb_DetailFromBank] PRIMARY KEY NONCLUSTERED 
(
	[iid] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF



/****** 对象:  Table [dbo].[NB_MaxNo]    脚本日期: 07/11/2013 14:14:12 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[NB_MaxNo](
	[cType] [varchar](10) NOT NULL,
	[iMaxNo] [int] NOT NULL,
 CONSTRAINT [PK_nb_MaxNo] PRIMARY KEY NONCLUSTERED 
(
	[cType] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF


/****** 对象:  Table [dbo].[NB_OperateLog]    脚本日期: 07/11/2013 14:14:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[NB_OperateLog](
	[iAutoId] [int] IDENTITY(1,1) NOT NULL,
	[iId] [int] NOT NULL,
	[cBillId] [varchar](30) NOT NULL,
	[mMoney] [money] NOT NULL,
	[cAccountFrom] [varchar](50) NOT NULL,
	[cAccountGroup] [varchar](50) NULL,
	[cAccountTo] [varchar](50) NOT NULL,
	[cOperatorName] [varchar](20) NOT NULL,
	[cOperateType] [varchar](20) NOT NULL,
	[dLogDate] [datetime] NOT NULL,
 CONSTRAINT [PK_NB_OperateLog] PRIMARY KEY NONCLUSTERED 
(
	[iAutoId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF



/****** 对象:  Table [dbo].[NB_Option]    脚本日期: 07/11/2013 14:14:35 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[NB_Option](
	[cAccountNumber] [varchar](50) NOT NULL,
	[bQueryBalance] [bit] NOT NULL CONSTRAINT [DF_NB_Option_bQueryBalance]  DEFAULT (0),
	[bQueryDailyDetail] [bit] NULL,
	[iBalanceInterval] [tinyint] NULL,
	[bPopupWindow] [bit] NULL,
	[dQueryDetailTime] [smalldatetime] NULL,
	[bStoreTo] [bit] NULL,
	[cStoreDir] [varchar](255) NULL,
 CONSTRAINT [PK_NB_Option] PRIMARY KEY CLUSTERED 
(
	[cAccountNumber] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF


/****** 对象:  Table [dbo].[NB_PayAccountInfo]    脚本日期: 07/11/2013 14:14:49 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[NB_PayAccountInfo](
	[cAccountNumber] [varchar](50) NOT NULL,
	[cPayUnitId] [varchar](30) NOT NULL,
	[bIsDefault] [bit] NOT NULL CONSTRAINT [DF_NB_PayAccountInfo_bIsDefault]  DEFAULT (0),
	[cBankId] [varchar](5) NOT NULL,
	[cBankName] [varchar](100) NOT NULL,
	[cPrinvince] [varchar](20) NULL,
	[cCity] [varchar](20) NULL,
	[cAccName] [varchar](60) NULL,
 CONSTRAINT [PK_NB_PayAccountInfo] PRIMARY KEY CLUSTERED 
(
	[cAccountNumber] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF


/****** 对象:  Table [dbo].[NB_payment]    脚本日期: 07/11/2013 14:15:00 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[NB_payment](
	[iID] [int] NOT NULL,
	[cBillID] [varchar](30) NOT NULL,
	[cBillIdInput] [varchar](50) NULL,
	[dBillDate] [datetime] NOT NULL,
	[mOriginMoney] [money] NOT NULL,
	[cPaySpeed] [varchar](4) NOT NULL,
	[sExchRate] [decimal](18, 9) NOT NULL,
	[mNativeMoney] [money] NOT NULL,
	[cMoneyType] [varchar](8) NOT NULL,
	[cAccountFrom] [varchar](50) NOT NULL,
	[cAccountGroup] [varchar](50) NULL,
	[cAccountTo] [varchar](50) NOT NULL,
	[cSettle] [varchar](3) NULL,
	[cComeFrom] [varchar](10) NOT NULL,
	[cPurpose] [varchar](60) NULL,
	[cAppend] [varchar](60) NULL,
	[cRemark] [varchar](60) NULL,
	[cComment] [varchar](60) NULL,
	[cExaminer] [varchar](20) NULL,
	[cApprover] [varchar](20) NULL,
	[bExamPass] [bit] NULL,
	[bApprovePass] [bit] NULL,
	[bPayed] [bit] NULL CONSTRAINT [DF_nb_payment_HasPayed]  DEFAULT (0),
	[iExported] [tinyint] NULL CONSTRAINT [DF_nb_payment_Exported]  DEFAULT (0),
	[bBalanced] [bit] NULL CONSTRAINT [DF_nb_payment_balanced]  DEFAULT (0),
	[iDZPeriod] [tinyint] NULL,
	[bMakeBill] [bit] NULL CONSTRAINT [DF_nb_payment_bMakeBill]  DEFAULT (0),
	[dOperateDate] [datetime] NULL,
	[cOperator] [varchar](20) NOT NULL,
	[cModifier] [varchar](20) NULL,
	[cPayer] [varchar](20) NULL,
	[cTransNo] [varchar](10) NULL,
	[cPzSys] [varchar](10) NULL,
	[cDepCode] [varchar](12) NULL,
	[cItemClass] [varchar](2) NULL,
	[cItemCode] [varchar](20) NULL,
	[cPerson] [varchar](8) NULL,
	[ufts] [timestamp] NOT NULL,
	[cPackageId] [varchar](60) NULL,
 CONSTRAINT [PK_nb_payment] PRIMARY KEY NONCLUSTERED 
(
	[iID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF




/****** 对象:  Table [dbo].[NB_PayUnitClass]    脚本日期: 07/11/2013 14:15:11 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[NB_PayUnitClass](
	[cClassId] [varchar](2) NOT NULL,
	[cClassName] [varchar](20) NOT NULL,
 CONSTRAINT [PK_PayUnitClass] PRIMARY KEY CLUSTERED 
(
	[cClassId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF




/****** 对象:  Table [dbo].[NB_PayUnitInfo]    脚本日期: 07/11/2013 14:15:24 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[NB_PayUnitInfo](
	[cUnitID] [varchar](30) NOT NULL,
	[cUnitName] [varchar](98) NOT NULL,
	[cUnitSName] [varchar](60) NULL,
	[cClass] [varchar](2) NOT NULL,
	[cCusId] [varchar](20) NULL,
	[cSupId] [varchar](20) NULL,
	[cAddress] [varchar](200) NULL,
	[cPostCode] [varchar](6) NOT NULL,
	[cTelephone] [varchar](100) NULL,
	[cTeleFax] [varchar](20) NULL,
	[cBP] [varchar](20) NULL,
	[cMobileTele] [varchar](20) NULL,
	[cEmail] [varchar](30) NULL,
	[cLinkman] [varchar](10) NULL,
	[cRemark] [varchar](120) NULL,
	[cBankCode] [varchar](15) NULL,
 CONSTRAINT [PK_PayUnitInfo] PRIMARY KEY CLUSTERED 
(
	[cUnitID] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF





/****** 对象:  Table [dbo].[nb_PzAbstract]    脚本日期: 07/11/2013 14:15:42 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[nb_PzAbstract](
	[iType] [tinyint] NOT NULL,
	[cName] [varchar](12) NOT NULL,
	[cEnName] [varchar](20) NOT NULL,
	[bSelected] [bit] NOT NULL,
	[iPosition] [tinyint] NOT NULL,
 CONSTRAINT [PK_PzAbstract] PRIMARY KEY CLUSTERED 
(
	[iType] ASC,
	[cEnName] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF




/****** 对象:  Table [dbo].[NB_regions]    脚本日期: 07/11/2013 14:15:51 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[NB_regions](
	[cRegionId] [varchar](4) NOT NULL,
	[cPrinvince] [varchar](20) NULL,
	[cCity] [varchar](20) NOT NULL,
 CONSTRAINT [PK_NB_regions] PRIMARY KEY NONCLUSTERED 
(
	[cRegionId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF





/****** 对象:  Table [dbo].[NB_UserAuthority]    脚本日期: 07/11/2013 14:16:02 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[NB_UserAuthority](
	[cUserId] [varchar](12) NOT NULL,
	[cAccountNumber] [varchar](50) NOT NULL,
	[cAuthorId] [varchar](5) NOT NULL,
	[bIsNotValid] [bit] NOT NULL,
	[mMoneyLimit] [money] NULL,
 CONSTRAINT [PK_NB_UserAuthority] PRIMARY KEY CLUSTERED 
(
	[cUserId] ASC,
	[cAccountNumber] ASC,
	[cAuthorId] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF



/****** 对象:  Table [dbo].[NB_VisibleField]    脚本日期: 07/11/2013 14:16:10 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[NB_VisibleField](
	[cTableName] [varchar](20) NOT NULL,
	[cFieldName] [varchar](20) NOT NULL,
	[cFieldEnName] [varchar](20) NOT NULL,
	[bVisible] [bit] NOT NULL CONSTRAINT [DF_NB_VisibleField_bVisible]  DEFAULT (0),
	[bDefault] [bit] NOT NULL CONSTRAINT [DF_NB_VisibleField_bDefault]  DEFAULT (0),
 CONSTRAINT [PK_NB_VisibleField] PRIMARY KEY NONCLUSTERED 
(
	[cTableName] ASC,
	[cFieldName] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]

GO
SET ANSI_PADDING OFF