sql.srcipt

CREATE TABLE [dbo].[BBS_BOARD] (
[BOARDID] [int] NOT NULL ,
[BOARDNAME] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[BOARDMASTER] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[ICONFILE] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[BOARDUSER] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[BOARDFLAG] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[BOARDSTATE] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NULL ,
[BOARDNOTE] [ntext] COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[BBS_LISTBOARD] (
[ANNOUNCEID] [int] NOT NULL ,
[RELAID] [int] NOT NULL ,
[BOARDID] [int] NOT NULL ,
[USERID] [int] NOT NULL ,
[TOPIC] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[BODY] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[SUBMITDATE] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[REPLYDATE] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[HITS] [int] NOT NULL ,
[NOTELEVEL] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[MSGREMIND] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[BBS_USER] (
[USERID] [int] NOT NULL ,
[USERNAME] [nvarchar] (25) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[USERPASS] [char] (15) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[LASTLOGINDATE] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[USERSTATE] [char] (1) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[TRUENAME] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[SEX] [nvarchar] (2) COLLATE Chinese_PRC_CI_AS NULL ,
[EMAIL] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[HOMEPAGE] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[BookMarks] (
[BookMarkID] [int] IDENTITY (1, 1) NOT NULL ,
[BookMarkName] [nvarchar] (64) COLLATE Chinese_PRC_CI_AS NULL ,
[BookMarkDesc] [nvarchar] (128) COLLATE Chinese_PRC_CI_AS NULL ,
[BookMarkText] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Document] (
[DocumentID] [int] IDENTITY (1, 1) NOT NULL ,
[RecordID] [varchar] (16) COLLATE Chinese_PRC_CI_AS NULL ,
[Template] [varchar] (16) COLLATE Chinese_PRC_CI_AS NULL ,
[Subject] [varchar] (254) COLLATE Chinese_PRC_CI_AS NULL ,
[Author] [varchar] (64) COLLATE Chinese_PRC_CI_AS NULL ,
[FileDate] [datetime] NULL ,
[FileType] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[HtmlPath] [varchar] (128) COLLATE Chinese_PRC_CI_AS NULL ,
[Status] [varchar] (4) COLLATE Chinese_PRC_CI_AS NULL ,
[oaid] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[lbid] [char] (10) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[Document_File] (
[FileID] [int] IDENTITY (1, 1) NOT NULL ,
[RecordID] [varchar] (16) COLLATE Chinese_PRC_CI_AS NULL ,
[FileName] [varchar] (254) COLLATE Chinese_PRC_CI_AS NULL ,
[FileType] [varchar] (4) COLLATE Chinese_PRC_CI_AS NULL ,
[FileSize] [int] NULL ,
[FileDate] [datetime] NULL ,
[FileBody] [image] NULL ,
[FilePath] [varchar] (128) COLLATE Chinese_PRC_CI_AS NULL ,
[UserName] [varchar] (64) COLLATE Chinese_PRC_CI_AS NULL ,
[Descript] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[Document_Signature] (
[SignatureID] [int] IDENTITY (1, 1) NOT NULL ,
[RecordID] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[MarkName] [varchar] (64) COLLATE Chinese_PRC_CI_AS NULL ,
[UserName] [varchar] (64) COLLATE Chinese_PRC_CI_AS NULL ,
[DateTime] [datetime] NULL ,
[HostName] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[MarkGuid] [varchar] (128) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[KQ_CSB] (
[SBSJ] [nvarchar] (5) COLLATE Chinese_PRC_CI_AS NULL ,
[XBSJ] [nvarchar] (5) COLLATE Chinese_PRC_CI_AS NULL ,
[CDSJ1] [int] NULL ,
[CDSJ2] [int] NULL ,
[CDSJ3] [int] NULL ,
[KQYQSRQ] [int] NULL ,
[KQYQSBZ] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[KQ_KQB] (
[YGBH] [int] NOT NULL ,
[KQRQ] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[QDSJ] [nvarchar] (8) COLLATE Chinese_PRC_CI_AS NULL ,
[QTSJ] [nvarchar] (8) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[KQ_QJD] (
[SQXH] [int] NOT NULL ,
[YJKSSJ] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[YJJSSJ] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[JB] [int] NULL ,
[SJKSSJ] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[SJJSSJ] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[XJQK] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[XJYJ] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[JDBZ] [char] (1) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[KQ_XXRB] (
[XXR] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[KQ_YTJB] (
[NY] [nvarchar] (7) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[YGBH] [int] NOT NULL ,
[JB] [int] NOT NULL ,
[SJ] [real] NULL ,
[CS] [int] NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[LOGRECORD] (
[IDNUM] [int] NOT NULL ,
[DLZIP] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[DLRQ] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[DLSJ] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[DLYHM] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[DLZDQ] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[BZ] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[MPJ] (
[YGBH] [int] NOT NULL ,
[XH] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[LBBH] [int] NULL ,
[ZT] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NULL ,
[XM] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[XB] [nvarchar] (2) COLLATE Chinese_PRC_CI_AS NULL ,
[DW] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[ZW] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[JTDZ] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[JTYB] [nvarchar] (6) COLLATE Chinese_PRC_CI_AS NULL ,
[DWDZ] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[DWYB] [nvarchar] (6) COLLATE Chinese_PRC_CI_AS NULL ,
[JTDH] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[YDDH] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[HJ] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[BGSDH] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[BGSCZ] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[DZYJ1] [nvarchar] (60) COLLATE Chinese_PRC_CI_AS NULL ,
[DZYJ2] [nvarchar] (60) COLLATE Chinese_PRC_CI_AS NULL ,
[DZYJ3] [nvarchar] (60) COLLATE Chinese_PRC_CI_AS NULL ,
[ZYDZ] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[ICQ1] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[OICQ1] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[OICQ2] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[SR] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[NC] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[BZ] [ntext] COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[MPLBZD] (
[YGBH] [int] NOT NULL ,
[BH] [int] NOT NULL ,
[MC] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_BGSWDJ] (
[DJXH] [int] NOT NULL ,
[LB] [nvarchar] (2) COLLATE Chinese_PRC_CI_AS NULL ,
[SQXH] [int] NULL ,
[BM] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[JBR] [int] NULL ,
[SY] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[DJR] [int] NULL ,
[DJSJ] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_BGXX] (
[ID] [int] NOT NULL ,
[HEADER] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[CONTENT] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[FB_DATE] [datetime] NULL ,
[PROVIDER] [int] NULL ,
[VIEW_BZ] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[SYGS] [real] NULL ,
[TPLJ] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[TPSM] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[WJLJ] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[WJSM] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[XXLB] [int] NULL ,
[JHXH] [int] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_BGXX_LBZD] (
[LBID] [int] NOT NULL ,
[LBMC] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[LBMS] [ntext] COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_BGYPCGDJ] (
[CGRKDH] [int] NOT NULL ,
[JBR] [int] NULL ,
[DJRQ] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[BZ] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[gs] [int] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_BGYPCGDJMX] (
[CGRKDH] [int] NOT NULL ,
[CGXH] [int] NOT NULL ,
[YPBH] [int] NULL ,
[CGRQ] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[SL] [decimal](14, 4) NULL ,
[DJ] [decimal](10, 4) NULL ,
[GS] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_BGYPCGSQMXB] (
[MXBH] [int] NOT NULL ,
[SQXH] [int] NULL ,
[PMGG] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[SL] [decimal](14, 4) NULL ,
[DJ] [decimal](10, 4) NULL ,
[JE] [decimal](14, 2) NULL ,
[YQJHRQ] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[BZ] [ntext] COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_BGYPKC] (
[YPBH] [int] NOT NULL ,
[YPMC] [nvarchar] (60) COLLATE Chinese_PRC_CI_AS NULL ,
[LBBH] [int] NULL ,
[GG] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[DW] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[PJJJ] [decimal](14, 2) NULL ,
[RKSL] [decimal](14, 4) NULL ,
[CKSL] [decimal](14, 4) NULL ,
[GXSJ] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[KCBJ] [decimal](14, 4) NULL ,
[gs] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_BGYPLB] (
[LBBH] [decimal](18, 0) NOT NULL ,
[LBMC] [nvarchar] (60) COLLATE Chinese_PRC_CI_AS NULL ,
[gs] [int] NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_BGYPLYDJ] (
[MXBH] [int] NOT NULL ,
[DJXH] [int] NULL ,
[YPBH] [int] NULL ,
[SQSL] [decimal](14, 4) NULL ,
[LYSL] [decimal](14, 4) NULL ,
[LYDJ] [decimal](10, 4) NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_BGYPLYSQ] (
[MXBH] [int] NOT NULL ,
[SQXH] [int] NULL ,
[YPBH] [int] NULL ,
[SQSL] [decimal](14, 4) NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_BGYPYS] (
[BMBH] [varchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[NY] [char] (7) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[YSJE] [decimal](14, 2) NOT NULL ,
[SJLYJE] [decimal](14, 2) NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_BLDLR] (
[GWLB] [int] NOT NULL ,
[YGBH] [int] NOT NULL ,
[DLRBH] [int] NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_BLGZDYB] (
[BLGZBH] [nvarchar] (2) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[BLGZMC] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[QTGZBH] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[DTCS1] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[DTCS2] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[DTCS3] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[DTCS4] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[DZLCQX] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_BXDJMXB] (
[MXBH] [int] NOT NULL ,
[DJXH] [int] NULL ,
[BXLB] [int] NULL ,
[YBJE] [decimal](14, 2) NULL ,
[SBJE] [decimal](14, 2) NULL ,
[JHXH] [int] NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_BXSQMXB] (
[MXBH] [int] NOT NULL ,
[SQXH] [int] NULL ,
[BXLB] [int] NULL ,
[YBJE] [decimal](14, 2) NULL ,
[JHXH] [int] NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_CBJLB] (
[CBXH] [int] NOT NULL ,
[GWXH] [int] NOT NULL ,
[CBSJ] [nvarchar] (19) COLLATE Chinese_PRC_CI_AS NULL ,
[ZSRYXM] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[FSRYXM] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[CBNR] [ntext] COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_CLDJ] (
[CLXH] [int] NOT NULL ,
[HPHM] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[CLMC] [nvarchar] (40) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[CLZT] [int] NULL ,
[CLLX] [int] NULL ,
[CPXH] [nvarchar] (60) COLLATE Chinese_PRC_CI_AS NULL ,
[FDJH] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[CJH] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[ZZL] [int] NULL ,
[HDZZL] [int] NULL ,
[DJRQ] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[KSSYRQ] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[FZRQ] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[FZJG] [nvarchar] (60) COLLATE Chinese_PRC_CI_AS NULL ,
[HDZK] [int] NULL ,
[QBZR] [int] NULL ,
[BGLYH] [real] NULL ,
[GCFY] [decimal](18, 0) NULL ,
[CZZZ] [nvarchar] (60) COLLATE Chinese_PRC_CI_AS NULL ,
[ZPLJ] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[BZ] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[SCBZ] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NULL ,
[CZMC] [nvarchar] (60) COLLATE Chinese_PRC_CI_AS NULL ,
[gs] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_CLLCBT] (
[XH] [int] NOT NULL ,
[CLXH] [int] NULL ,
[CH] [nvarchar] (40) COLLATE Chinese_PRC_CI_AS NULL ,
[NY] [nvarchar] (7) COLLATE Chinese_PRC_CI_AS NULL ,
[DYLCS] [int] NULL ,
[BTJEHJ] [decimal](14, 2) NULL ,
[YBJEHJ] [decimal](14, 2) NULL ,
[LCBTHJ] [decimal](14, 2) NULL ,
[DYBTZJ] [decimal](14, 2) NULL ,
[BZ] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[JBR] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[JBRQ] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_CLLXZDXX] (
[LXXH] [int] NULL ,
[LXMC] [nvarchar] (40) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_CLWXDJ] (
[MXBH] [int] NOT NULL ,
[DJXH] [int] NULL ,
[CLXH] [int] NULL ,
[CH] [nvarchar] (40) COLLATE Chinese_PRC_CI_AS NULL ,
[XLXM] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[WXFY] [decimal](14, 2) NULL ,
[WXRQ] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[BZ] [ntext] COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_CLWXSQ] (
[MXBH] [int] NOT NULL ,
[SQXH] [int] NULL ,
[CLXH] [int] NULL ,
[CH] [nvarchar] (40) COLLATE Chinese_PRC_CI_AS NULL ,
[BXRQ] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[XLXM] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[WXFY] [decimal](14, 2) NULL ,
[JDYJ] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[JDR] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[JDRQ] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[JCYJ] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[JCR] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[JCRQ] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_CLYHDJ] (
[XH] [int] NOT NULL ,
[CLXH] [int] NULL ,
[CH] [nvarchar] (40) COLLATE Chinese_PRC_CI_AS NULL ,
[RQ] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[LMBDS] [int] NULL ,
[LCS] [int] NULL ,
[JYL] [decimal](14, 4) NULL ,
[JE] [decimal](14, 2) NULL ,
[JYR] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[BZ] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[gs] [int] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_CLZTZDXX] (
[ZTXH] [int] NULL ,
[ZTMC] [nvarchar] (40) COLLATE Chinese_PRC_CI_AS NULL ,
[ZTLX] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_CRM_CPZL] (
[CPBH] [int] NOT NULL ,
[FJXH] [int] NOT NULL ,
[FJMC] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[FJLJ] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_CRM_DQZD] (
[BH] [int] NOT NULL ,
[MC] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_CRM_DWXZZD] (
[BH] [int] NOT NULL ,
[MC] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_CRM_DZCPFWXX] (
[CPBH] [int] NOT NULL ,
[MC] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[CPSM] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[FBRQ] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[BJ] [decimal](14, 2) NULL ,
[SCBZ] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_CRM_KHCPB] (
[KHBH] [int] NOT NULL ,
[CPBH] [int] NOT NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_CRM_KHLBZD] (
[BH] [int] NOT NULL ,
[MC] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_CRM_KHLXRJLB] (
[KHBH] [int] NOT NULL ,
[LXRBH] [int] NOT NULL ,
[LXRXM] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[XB] [nvarchar] (2) COLLATE Chinese_PRC_CI_AS NULL ,
[CSRQ] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[XZW] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[TXDZ] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[YZBM] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[DH] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[SJ] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[CH] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[CZ] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[DZYJ] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[GRWZ] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[BJSM] [ntext] COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_CRM_KHXX] (
[KHBH] [int] NOT NULL ,
[KHMC] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[DWXZ] [int] NULL ,
[SSHY] [int] NULL ,
[DQ] [int] NULL ,
[TXDZ] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[YZBM] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[DH] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[CZ] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[DZYJ] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[DWWZ] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[KHH] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[YHZH] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[DWJS] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[XYZK] [nvarchar] (5) COLLATE Chinese_PRC_CI_AS NULL ,
[KHLB] [int] NULL ,
[JDRQ] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[FZR] [int] NULL ,
[SCBZ] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

'''''''''''''By Winner ''9:43 2006-3-24'''''''''''''''''''

CREATE TABLE [dbo].[OA_CRM_LXJL] (
[GZXH] [int] NOT NULL ,
[KHBH] [int] NOT NULL ,
[RQ] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[LXJLLX] [int] NULL ,
[YWZT] [int] NULL ,
[YGBH] [int] NULL ,
[LXRBH] [int] NULL ,
[YWMS] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[JJBF] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[CZY] [int] NULL ,
[SCBZ] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NULL ,
[CPBH] [int] NULL ,
[oaid] [int] IDENTITY (1, 1) NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
'''''''''''''By Winner ''9:43 2006-3-24'''''''''''''''''''

CREATE TABLE [dbo].[OA_CRM_LXJLLXZD] (
[BH] [int] NOT NULL ,
[MC] [nvarchar] (60) COLLATE Chinese_PRC_CI_AS NOT NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_CRM_SSHYZD] (
[BH] [int] NOT NULL ,
[MC] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_CRM_XSJLB] (
[JLBH] [int] NOT NULL ,
[KHBH] [int] NOT NULL ,
[QDRQ] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[HTJE] [decimal](14, 2) NULL ,
[FKFS] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[WCBZ] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NULL ,
[HTWBLJ] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[FZR] [int] NULL ,
[SCBZ] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_CRM_XSJLMXB] (
[JLBH] [int] NOT NULL ,
[MXBH] [int] NOT NULL ,
[CPBH] [int] NOT NULL ,
[JLDW] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[DJ] [decimal](14, 2) NULL ,
[SL] [decimal](18, 4) NULL ,
[jldw1] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[zx] [int] NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_CRM_XSRY] (
[YGBH] [int] NOT NULL ,
[QXBZ] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_CRM_XSZXB] (
[JLBH] [int] NOT NULL ,
[ZXXH] [int] NOT NULL ,
[RQ] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[ZXBZ] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NULL ,
[FKJE] [decimal](14, 2) NULL ,
[BZ] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[zxx] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_CRM_YGCPQXB] (
[CPBH] [int] NOT NULL ,
[YGBH] [int] NOT NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_CRM_YGDQQXB] (
[DQBH] [int] NOT NULL ,
[YGBH] [int] NOT NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_CRM_YWZTZD] (
[BH] [int] NOT NULL ,
[MC] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_DA_FJ] (
[FJXH] [int] NOT NULL ,
[DAXH] [int] NULL ,
[FJBT] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[CDLJ] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[CCGS] [nvarchar] (3) COLLATE Chinese_PRC_CI_AS NULL ,
[XGCX] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_DA_JL] (
[DAXH] [int] NOT NULL ,
[DABH] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[DABT] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[FLH] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[WDZY] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[BZ] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[BCQX] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[DAZT] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[GDSJ] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[GDR] [int] NULL ,
[XHSJ] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[WDLY] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
[GWXH] [int] NULL ,
[XSLB] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
[DAT] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[DAW] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[ZTC] [varchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[DABZ] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
[SQXH] [int] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_DA_LM] (
[FLH] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[LMMC] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[LMZS] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[SJFLH] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[LMLJ] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[CXXSBZ] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NULL ,
[GLQX] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[QXBZ] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NULL ,
[CXQX] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[ZHXGR] [int] NOT NULL ,
[ZHXGSJ] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_DHQHDZB] (
[XH] [int] NOT NULL ,
[SSLB] [int] NOT NULL ,
[DQMC] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[YZBM] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[CTQH] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[BZ] [ntext] COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_DJFJ] (
[FJBH] [int] NOT NULL ,
[DJXH] [int] NULL ,
[FJSM] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[FJYSLJ] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_DJLB] (
[DJLB] [int] NOT NULL ,
[DJLBMC] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[ZTBZ] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_DQZD] (
[BH] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[DQDM] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[YZBM] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[DQMC] [nvarchar] (60) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_DSTXSZ] (
[BH] [int] NOT NULL ,
[YGBH] [int] NOT NULL ,
[FSSJ] [nvarchar] (5) COLLATE Chinese_PRC_CI_AS NULL ,
[BT] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[NR] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[TQTXTS] [int] NULL ,
[KSRQ] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[ZZLB] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NULL ,
[ZZRQ] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[QYBZ] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NULL ,
[DQMS] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NULL ,
[CFJGLX] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NULL ,
[CFJG] [nvarchar] (7) COLLATE Chinese_PRC_CI_AS NULL ,
[YTXBZ] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NULL ,
[YTXRQ] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_DWJWJL] (
[DWBH] [int] NOT NULL ,
[JWXH] [int] NOT NULL ,
[RQ] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[WFRY] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[DFRY] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[LXJLLX] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[JWJL] [ntext] COLLATE Chinese_PRC_CI_AS NOT NULL ,
[QKFX] [ntext] COLLATE Chinese_PRC_CI_AS NOT NULL ,
[SCBZ] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_DWKHXX] (
[DWBH] [int] NOT NULL ,
[DWMC] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[DWXZ] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[SSHY] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[GJ] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[SF] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[CS] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[TXDZ] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[YZBM] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[CZ] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[DZYJ] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[DWWZ] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[KHH] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[YHZH] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[DWJS] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[XYZK] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[KHLB] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[GKBZ] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NULL ,
[XGBZ] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NULL ,
[XSFZR] [int] NULL ,
[JDRQ] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[DQXSZT] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[SCBZ] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NULL ,
[CZRQ] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_DWXZZD] (
[BH] [int] NOT NULL ,
[MC] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_DZZZ] (
[XH] [int] NOT NULL ,
[FBSJ] [datetime] NULL ,
[LJMC] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[NRMS] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[LJLJ] [ntext] COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_FJHBDZB] (
[XH] [int] NOT NULL ,
[HBH] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[CFZ] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[DDZ] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[CFSK] [nvarchar] (5) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[DDSK] [nvarchar] (5) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[HBRQ] [nvarchar] (7) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[SSHKGS] [int] NULL ,
[FJXH] [int] NULL ,
[JGBZ] [int] NULL ,
[JBJG] [decimal](14, 2) NULL ,
[BZ] [ntext] COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_FJJLB] (
[DWBH] [int] NOT NULL ,
[XGXH] [int] NOT NULL ,
[LB] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[FJXH] [int] NOT NULL ,
[FJMC] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[FJLJ] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_FJXHZDB] (
[XH] [int] NOT NULL ,
[MC] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_GDZC_CP] (
[GZXH] [int] NOT NULL ,
[BH] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[LB] [int] NULL ,
[MC] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[GG] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[DW] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[SYBM] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[ZJFF] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[SY_UID] [int] NULL ,
[KSRQ] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[DQZT] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NULL ,
[GZPZBH] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[GZJE] [decimal](14, 2) NULL ,
[GZRQ] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[YZ] [decimal](14, 2) NULL ,
[CZL] [decimal](14, 2) NULL ,
[GHF] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[CFDD] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[BZ] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[BFRQ] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[BFYY] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[SYNX] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[gs] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_GDZC_PJ] (
[GZXH] [int] NOT NULL ,
[PJXH] [int] NOT NULL ,
[MC] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[GGXH] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[SL] [decimal](14, 4) NULL ,
[GHF] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[GMRQ] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[BZ] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_GDZC_SYXX] (
[JLXH] [int] NOT NULL ,
[GZXH] [int] NULL ,
[SYBM] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[SY_UID] [int] NULL ,
[SYRQ] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[SYDJR] [int] NULL ,
[SYDJRQ] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[GHRQ] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[GHZT] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[GHDJR] [int] NULL ,
[GHDJRQ] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_GDZC_ZCLBZD] (
[BM] [nvarchar] (2) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[MC] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[GLQX] [ntext] COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_GRBQ] (
[XH] [int] NOT NULL ,
[BQNR] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[YGBH] [int] NOT NULL ,
[SJ] [nvarchar] (19) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_GRSZ] (
[YGBH] [int] NOT NULL ,
[SZXH] [int] NOT NULL ,
[SZXM] [int] NULL ,
[ZHBH] [int] NULL ,
[RQ] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[SM] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[SR] [real] NULL ,
[ZC] [real] NULL ,
[BZ] [ntext] COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_GRSZXM] (
[YGBH] [int] NOT NULL ,
[XMBH] [int] NOT NULL ,
[XMMC] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[SZLB] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_GRSZZH] (
[YGBH] [int] NOT NULL ,
[ZHBH] [int] NOT NULL ,
[ZHMC] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_GSB] (
[GSBS] [nvarchar] (2) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[GSMC] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[GSZG] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[BZ] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[PASSWORD] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_GSJS] (
[ID] [int] NOT NULL ,
[HEADER] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[CONTENT] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[FB_DATE] [datetime] NULL ,
[PROVIDER] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[VIEW_BZ] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[TPLJ] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[TPSM] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[WJLJ] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[WJSM] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[XXLB] [int] NULL ,
[WJT] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[WH] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[ZTC] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[WJW] [ntext] COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_GWBLB] (
[GWXH] [int] NOT NULL ,
[BLXH] [int] NOT NULL ,
[GZDBH] [int] NULL ,
[GZDXH] [int] NULL ,
[BLR] [int] NULL ,
[DLR] [int] NULL ,
[BLRQ] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[BLYJ] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[XGBZ] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NULL ,
[BLBZ] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NULL ,
[ZCBZ] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NULL ,
[TJLZBJ] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NULL ,
[CLSJ] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[CLSX] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[LYGZDXH] [int] NULL ,
[LYBLXH] [char] (10) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_GWLBZD] (
[LBXH] [int] NOT NULL ,
[LBMC] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[LBSM] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[GDQX] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[XHQX] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[NZQX] [ntext] COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_GWMBZD] (
[MBXH] [int] NOT NULL ,
[LBXH] [int] NOT NULL ,
[MBMC] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[MBNR] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[MBSM] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[MBSDR] [int] NULL ,
[MBSDSJ] [nvarchar] (19) COLLATE Chinese_PRC_CI_AS NULL ,
[MBSDBZ] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_GWNRB] (
[GWXH] [int] NOT NULL ,
[FJXH] [int] NOT NULL ,
[FJBT] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[FJLJ] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[DQXGR] [int] NULL ,
[XGSJ] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[ZXXGBZ] [char] (1) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_GWPBB] (
[BBXH] [int] NOT NULL ,
[GWXH] [int] NULL ,
[XGRQ] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[XGR] [int] NULL ,
[ZW] [ntext] COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_GWSXB] (
[GWXH] [int] NOT NULL ,
[GWLB] [int] NULL ,
[WBGWBZ] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NULL ,
[GWZH] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[GWBT] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[GWZY] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[MJ] [int] NULL ,
[JJCD] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NULL ,
[FWDWMC] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
[ZSDWMC] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
[CSDWMC] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
[SWDWMC] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
[FZ] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[ZTC] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[NZBM] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[NZR] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[NZRQ] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[QFR] [int] NULL ,
[QFRQ] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[DJR] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[DJRQ] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[WDFLML] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[GDR] [int] NULL ,
[GDRQ] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[XHR] [int] NULL ,
[XHRQ] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[BGQX] [int] NULL ,
[BLLB] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NULL ,
[BLZT] [nvarchar] (2) COLLATE Chinese_PRC_CI_AS NULL ,
[WCBZ] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NULL ,
[ZW] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[ZWSDR] [int] NULL ,
[ZWSDSJ] [nvarchar] (19) COLLATE Chinese_PRC_CI_AS NULL ,
[ZWSDBZ] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NULL ,
[GWBLSX] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[CXBLXH] [int] NULL ,
[GDQBLZT] [nvarchar] (2) COLLATE Chinese_PRC_CI_AS NULL ,
[gs] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_GW_FJ] (
[GWXH] [int] NOT NULL ,
[FJXH] [int] NOT NULL ,
[FJBH] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[FJBT] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[FJYSLJ] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_GW_HQJL] (
[GWXH] [int] NOT NULL ,
[HQR] [int] NOT NULL ,
[CLRQ] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[HQRQ] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[HQYJ] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[XLHQR] [ntext] COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_GW_HYFJ] (
[HYXH] [int] NOT NULL ,
[FJXH] [int] NOT NULL ,
[FJBH] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[FJBT] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[FJYSLJ] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_GW_HYJYDJ] (
[HYXH] [int] NOT NULL ,
[HYRQ] [datetime] NULL ,
[KSSJ] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[JSSJ] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[HYMC] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[HYZT] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[HYZCR] [int] NULL ,
[HYCJR] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[HYNR] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[DJRQ] [datetime] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_GW_JL] (
[GWXH] [int] NOT NULL ,
[GWWH] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
[GWMC] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[ZTC] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[GWNR] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[FWR] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[FWRQ] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[HQR] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[SHR] [int] NULL ,
[SHBZ] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NULL ,
[GWLB] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[GDRQ] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[XHRQ] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[XHYY] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[XHR] [int] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_GZDDYB] (
[GWXH] [int] NOT NULL ,
[BLGZBH] [nvarchar] (2) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[GZDXH] [int] NOT NULL ,
[GZDMC] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[BLRYLB] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[BLRYSM] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
[TQQX] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NULL ,
[TIQX] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NULL ,
[JQQX] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NULL ,
[CXQX] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NULL ,
[LZBZ] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NULL ,
[TXZB] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[GZSX] [int] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_GZDMBB] (
[LCBH] [int] NOT NULL ,
[BLGZBH] [nvarchar] (2) COLLATE Chinese_PRC_CI_AS NULL ,
[GZDXH] [int] NOT NULL ,
[GZDMC] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[BLRYLB] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[BLRYSM] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
[TQQX] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NULL ,
[JQQX] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NULL ,
[CXQX] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NULL ,
[LZBZ] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NULL ,
[TXZB] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[GZSX] [int] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_GZLCB] (
[LCBH] [int] NOT NULL ,
[GWLB] [int] NULL ,
[LCMC] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[BLLB] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NULL ,
[BZ] [ntext] COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_GZLCMBB] (
[LCBH] [int] NOT NULL ,
[LCMC] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[BZ] [ntext] COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_GZLDYB] (
[GWXH] [int] NOT NULL ,
[GZLBH] [int] NOT NULL ,
[SGZBH] [nvarchar] (2) COLLATE Chinese_PRC_CI_AS NULL ,
[SGZDXH] [int] NULL ,
[ZGZBH] [nvarchar] (2) COLLATE Chinese_PRC_CI_AS NULL ,
[ZGZDXH] [int] NULL ,
[TXZB] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_GZLMBB] (
[LCBH] [int] NOT NULL ,
[GZLBH] [int] NOT NULL ,
[SGZBH] [nvarchar] (2) COLLATE Chinese_PRC_CI_AS NULL ,
[SGZDXH] [int] NULL ,
[ZGZBH] [nvarchar] (2) COLLATE Chinese_PRC_CI_AS NULL ,
[ZGZDXH] [int] NULL ,
[TXZB] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_HCCSB] (
[CC] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[CCMC] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[SFZM] [int] NOT NULL ,
[ZDZM] [int] NOT NULL ,
[JL] [int] NULL ,
[YXSJ] [nvarchar] (8) COLLATE Chinese_PRC_CI_AS NULL ,
[BZ] [ntext] COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_HCCZB] (
[CCM] [int] NOT NULL ,
[CZM] [int] NOT NULL ,
[CZMC] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_HCDQB] (
[DQM] [int] NOT NULL ,
[DQMC] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_HCSKB] (
[CC] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[CX] [int] NOT NULL ,
[TKZM] [int] NOT NULL ,
[DDSK] [nvarchar] (5) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[KCSK] [nvarchar] (5) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[BZ] [ntext] COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_HKGSZDB] (
[XH] [int] NOT NULL ,
[MC] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_HYDJB] (
[TZXH] [int] NOT NULL ,
[HYXH] [int] NOT NULL ,
[TZBT] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[TZSM] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[TZFW] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[FBYG] [int] NULL ,
[FBSJ] [nvarchar] (16) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_HYS] (
[HYSBH] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[HYSMC] [nvarchar] (60) COLLATE Chinese_PRC_CI_AS NULL ,
[HYSDD] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[KRNRS] [int] NULL ,
[HYSSBQK] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[HYSSYSM] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[BZ] [ntext] COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_HYSDJB] (
[MXBH] [int] NOT NULL ,
[DJXH] [int] NULL ,
[QSSJ] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[JZSJ] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[HYSBH] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[BZ] [ntext] COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_HYSYD] (
[MXBH] [int] NOT NULL ,
[SQXH] [int] NULL ,
[HYSBH] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[QSSJ] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[JZSJ] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[BZ] [ntext] COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_HYTZHFB] (
[HFXH] [int] NOT NULL ,
[YGBH] [int] NOT NULL ,
[HYXH] [int] NOT NULL ,
[HFSJ] [nvarchar] (16) COLLATE Chinese_PRC_CI_AS NULL ,
[HFSM] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[CYBZ] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_HYXXB] (
[HYXH] [int] NOT NULL ,
[HYMC] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[HYZT] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[QSRQ] [nvarchar] (16) COLLATE Chinese_PRC_CI_AS NULL ,
[ZZRQ] [nvarchar] (16) COLLATE Chinese_PRC_CI_AS NULL ,
[FBR] [int] NULL ,
[FBSJ] [nvarchar] (16) COLLATE Chinese_PRC_CI_AS NULL ,
[HYSM] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[ZCR] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[CYR] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[SJY] [int] NULL ,
[DDBZ] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
[HYSXH] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[HYDD] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[JYZT] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[JYNR] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[JYZLRQ] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[CXFW] [char] (1) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_JBMX] (
[SQXH] [int] NOT NULL ,
[YJKSSJ] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[YJJSSJ] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[YJGS] [real] NULL ,
[SJKSSJ] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[SJJSSJ] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[SJGS] [real] NULL ,
[HZQK] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NULL ,
[HZYJ] [ntext] COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_JCDJ] (
[MXBH] [int] NOT NULL ,
[DJXH] [int] NULL ,
[JCSJ] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[LKDW] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[ZRS] [int] NULL ,
[CF] [decimal](14, 2) NULL ,
[YJF] [decimal](14, 2) NULL ,
[QTFY] [decimal](14, 2) NULL ,
[ZJ] [decimal](14, 2) NULL ,
[BZ] [ntext] COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_JCSQ] (
[MXBH] [int] NOT NULL ,
[SQXH] [int] NULL ,
[JCSJ] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[LKDW] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[LKRS] [int] NULL ,
[ZRS] [int] NULL ,
[BZ] [decimal](14, 2) NULL ,
[JDBZ] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_JGBZZDB] (
[XH] [int] NOT NULL ,
[MC] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_JHXX] (
[JHXH] [int] NOT NULL ,
[JHLJ] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[JHMC] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[JHMS] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[WJMC] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[WJLJ] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[JHLB] [int] NULL ,
[QSRQ] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[ZZRQ] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[JHGS] [real] NULL ,
[SJWCRQ] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[JHFZR] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[JHCYR] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[JHFBR] [int] NULL ,
[FBRQ] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[WCBZ] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NULL ,
[WCSQR] [int] NULL ,
[SJSYGS] [real] NULL ,
[FJBZ] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_JH_LBZD] (
[LBXH] [int] NOT NULL ,
[LBMC] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[LBMS] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[LBFZR] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[LBCYR] [ntext] COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_JYFJXXB] (
[FJXH] [int] NOT NULL ,
[HYXH] [int] NULL ,
[FJSM] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[FJLJ] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_KHGZJH] (
[DWBH] [int] NOT NULL ,
[GZXH] [int] NOT NULL ,
[JHRQ] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[JHNR] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[TQTXTS] [smallint] NULL ,
[ZZQXSZ] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NULL ,
[ZZBZ] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NULL ,
[ZXBG] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[BGRQ] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[TXDX] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[ZDR] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[SCBZ] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_KHLBZD] (
[LBBH] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[LBMC] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_KHLXRJLB] (
[DWBH] [int] NOT NULL ,
[LXRBH] [int] NULL ,
[LXRXM] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[XB] [nvarchar] (2) COLLATE Chinese_PRC_CI_AS NULL ,
[CSRQ] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[XZW] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[TXDZ] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[YZBM] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[DH] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[SJ] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[CH] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[CZ] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[DZYJ] [nvarchar] (60) COLLATE Chinese_PRC_CI_AS NULL ,
[GRWZ] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[BJSM] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[SCBZ] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_LXJLLXZD] (
[LXBH] [int] NOT NULL ,
[LXMC] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_LXYYZD] (
[YGBH] [int] NOT NULL ,
[XH] [int] NOT NULL ,
[LXYY] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_MAIL_FJ] (
[YJXH] [int] NOT NULL ,
[FJXH] [int] IDENTITY (1, 1) NOT NULL ,
[FJMC] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[FJLJ] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[FJBZ] [char] (1) COLLATE Chinese_PRC_CI_AS NOT NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_MAIL_GRYJJ] (
[RYBH] [nvarchar] (6) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[YJJMC] [nvarchar] (60) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[YJJBZ] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NULL ,
[YJJXH] [nvarchar] (6) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_MAIL_GRYXCS] (
[RYBH] [nvarchar] (6) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[GRQMD] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[JSYJDZ] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[XSHS] [int] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_MAIL_POP3] (
[ID] [int] NOT NULL ,
[RYBH] [int] NOT NULL ,
[POP3MC] [varchar] (60) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[POP3] [varchar] (60) COLLATE Chinese_PRC_CI_AS NULL ,
[POP3YHM] [varchar] (60) COLLATE Chinese_PRC_CI_AS NULL ,
[POP3DLMM] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[ZDSXBZ] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
[SCBZ] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
[JSYJJ] [varchar] (60) COLLATE Chinese_PRC_CI_AS NULL ,
[XSXM] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[XSDZ] [varchar] (60) COLLATE Chinese_PRC_CI_AS NULL ,
[SMTPSERVER] [varchar] (60) COLLATE Chinese_PRC_CI_AS NULL ,
[SMTPAUTH] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
[SMTPUSER] [varchar] (60) COLLATE Chinese_PRC_CI_AS NULL ,
[SMTPPWD] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[USEFLAG] [char] (1) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO
'''''''''''''By Winner.9:41 2006-3-24.....................
CREATE TABLE [dbo].[OA_MAIL_YJ] (
[YGBH] [int] NOT NULL ,
[YJXH] [int] IDENTITY (1, 1) NOT NULL ,
[JJRXM] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[JJRDZ] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[SJRDZ] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[CS] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[RQ] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[ZHUTI] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[ZWLJWJ] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[YJJMC] [nvarchar] (60) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[TSBZ] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
[YDBZ] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
[YJBZ] [char] (1) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[YXJB] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
[YJDX] [int] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
'''''''''''''By Winner.9:41 2006-3-24.....................
CREATE TABLE [dbo].[OA_MAIL_YXCS] (
[YGBH] [int] NOT NULL ,
[YXRL] [decimal](10, 2) NULL ,
[RLCCXZ] [char] (1) COLLATE Chinese_PRC_CI_AS NULL ,
[XZBZ] [char] (1) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_MESSAGE] (
[XXXH] [int] NOT NULL ,
[YGBH] [int] NULL ,
[XXNR] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[FSRBH] [int] NULL ,
[XXFSSJ] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[YDBZ] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NULL ,
[YDSJ] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[BZ] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_MJQXB] (
[MJXH] [int] NOT NULL ,
[JBJB] [int] NOT NULL ,
[MJMC] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[YDNRQX] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[CKBTQX] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[MJSM] [ntext] COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_QTJDDJ] (
[MXBH] [int] NOT NULL ,
[DJXH] [int] NULL ,
[LB] [int] NULL ,
[PM] [nvarchar] (60) COLLATE Chinese_PRC_CI_AS NULL ,
[SL] [decimal](14, 4) NULL ,
[DJ] [decimal](10, 4) NULL ,
[XJ] [decimal](14, 2) NULL ,
[BZ] [ntext] COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_QTJDSQ] (
[MXBH] [int] NOT NULL ,
[SQXH] [int] NULL ,
[LB] [int] NULL ,
[PM] [nvarchar] (60) COLLATE Chinese_PRC_CI_AS NULL ,
[BZ] [decimal](14, 2) NULL ,
[SL] [decimal](14, 4) NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_QX_GNMKLB] (
[GNMKBH] [nvarchar] (4) COLLATE Chinese_PRC_CI_AS NULL ,
[CDXSMC] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[DYWJ] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[CDZBH] [nvarchar] (3) COLLATE Chinese_PRC_CI_AS NULL ,
[BTN_PIC_UP] [nvarchar] (150) COLLATE Chinese_PRC_CI_AS NULL ,
[BTN_PIC_DOWN] [nvarchar] (150) COLLATE Chinese_PRC_CI_AS NULL ,
[QXBZ] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_QX_KTGNMKLB] (
[GNMKBH] [nvarchar] (4) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[CDXSMC] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[DYWJ] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[CDZBH] [nvarchar] (3) COLLATE Chinese_PRC_CI_AS NULL ,
[BTN_PIC_UP] [nvarchar] (150) COLLATE Chinese_PRC_CI_AS NULL ,
[BTN_PIC_DOWN] [nvarchar] (150) COLLATE Chinese_PRC_CI_AS NULL ,
[QXBZ] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_QX_MENUMASTER] (
[NAME] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[NUMBER] [nvarchar] (3) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[PICTUREPATH] [nvarchar] (150) COLLATE Chinese_PRC_CI_AS NULL ,
[BMPPATH] [nvarchar] (150) COLLATE Chinese_PRC_CI_AS NULL ,
[PICTUREPATH1] [nvarchar] (150) COLLATE Chinese_PRC_CI_AS NULL ,
[SYBZ] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_QX_ZW] (
[ZWBH] [int] NOT NULL ,
[BMBH] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[ZWMC] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[QXLB] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[qx] [int] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_RCB] (
[RCBH] [int] NOT NULL ,
[YGBH] [int] NOT NULL ,
[RCBT] [nvarchar] (150) COLLATE Chinese_PRC_CI_AS NULL ,
[RCNR] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[RCLB] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[ZYX] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NULL ,
[RCRQ] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[KSSJ] [nvarchar] (5) COLLATE Chinese_PRC_CI_AS NULL ,
[YDJSSJ] [nvarchar] (5) COLLATE Chinese_PRC_CI_AS NULL ,
[WCBZ] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NULL ,
[WCQK] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[SCRBH] [int] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_RSDDJL] (
[DDXH] [int] NOT NULL ,
[YGBH] [int] NULL ,
[DDRQ] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[DCBM] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[DRBM] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[DDQZW] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[DDHZW] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_RSLLXXB] (
[LLXH] [int] NOT NULL ,
[YGBH] [int] NOT NULL ,
[QSNY] [nvarchar] (7) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[ZZNY] [nvarchar] (7) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[RZDW] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[RZBM] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[RZZW] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[GZJJ] [ntext] COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_RZCS] (
[RQFW] [int] NOT NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_RZXX] (
[ID] [int] NOT NULL ,
[CONTENT] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[FB_DATE] [datetime] NULL ,
[PROVIDER] [int] NOT NULL ,
[WJLJ] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[WJSM] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[JHXH] [int] NULL ,
[QSSJ] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[ZZSJ] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[TXRQ] [datetime] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_SPDLR] (
[SQLB] [nvarchar] (2) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[YGBH] [int] NOT NULL ,
[DLRBH] [int] NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_SPJL] (
[SPXH] [int] NOT NULL ,
[SQXH] [int] NULL ,
[LCBH] [int] NULL ,
[RKXH] [int] NULL ,
[CLSJ] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[SPSJ] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[SPR] [int] NULL ,
[SPBZ] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NULL ,
[SPYJ] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[SPDLR] [int] NULL ,
[TJLZBZ] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NULL ,
[FJLJ] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[SJLCBH] [int] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_SPLC] (
[RKXH] [int] NOT NULL ,
[LCXH] [int] NOT NULL ,
[SJBTYLCXH] [int] NULL ,
[SJLCXH] [int] NULL ,
[LCRKBZ] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NULL ,
[RKTJ] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[RKSM] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[SPGLTJ] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[SPGLTJSM] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[SPDMC] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[SPZW] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[BMSPBZ] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NULL ,
[SPQX] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[SPQXSM] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[TJLZBZ] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_SPLCRK] (
[SQLB] [nvarchar] (2) COLLATE Chinese_PRC_CI_AS NULL ,
[RKXH] [int] NOT NULL ,
[LCMC] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[BZ] [ntext] COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_SQFJ] (
[FJBH] [int] NOT NULL ,
[SQXH] [int] NULL ,
[FJSM] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[FJYSLJ] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_SQJBXX] (
[SQXH] [int] NOT NULL ,
[SQLB] [nvarchar] (2) COLLATE Chinese_PRC_CI_AS NULL ,
[SQZW] [int] NULL ,
[TBR] [int] NULL ,
[SQR] [int] NULL ,
[SQSJ] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[SQBM] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[SQSY] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[SPBZ] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NULL ,
[DJBZ] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NULL ,
[gs] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_SQLB] (
[LBBH] [nvarchar] (2) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[MC] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[SM] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[XTBZ] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NULL ,
[DJR] [ntext] COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_SSHYZD] (
[BH] [int] NOT NULL ,
[MC] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_TS_JYJL] (
[TSXH] [int] NULL ,
[JYXH] [int] NOT NULL ,
[SQR] [int] NULL ,
[SQRQ] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[SQXX] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[HFR] [int] NULL ,
[HFRQ] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[HFXX] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[HFZT] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NULL ,
[JCRQ] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[JCJSR] [int] NULL ,
[JCXX] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[GHRQ] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[GHJSR] [int] NULL ,
[GHXX] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[GHZT] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_TS_LBZD] (
[LB] [int] NOT NULL ,
[MC] [nvarchar] (40) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_TS_ZL] (
[TSXH] [int] NOT NULL ,
[ZLBH] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[LB] [int] NULL ,
[ZLMC] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[CBS] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[CBH] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[ZZ] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[CBRQ] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[BC] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[YS] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[GRRQ] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[JG] [decimal](14, 2) NULL ,
[ZK] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NULL ,
[NRSM] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[SYR] [int] NULL ,
[gs] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_XSJLXX] (
[XH] [int] NOT NULL ,
[DWBH] [int] NOT NULL ,
[SXJE] [decimal](12, 2) NOT NULL ,
[DJRQ] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[XSRY] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[DJRY] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[LB] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[SCBZ] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[BZ] [ntext] COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_XSRYZD] (
[RYBH] [int] NOT NULL ,
[GLJB] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NOT NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_XSZTBGSM] (
[DWBH] [int] NOT NULL ,
[XH] [int] NOT NULL ,
[BGRQ] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[BGYY] [ntext] COLLATE Chinese_PRC_CI_AS NOT NULL ,
[YZT] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[XZT] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[SXJE] [int] NULL ,
[CZY] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[SCBZ] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_XSZTZD] (
[ZTBH] [int] NOT NULL ,
[ZTMC] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_XXZX_LMZD] (
[LMID] [int] NOT NULL ,
[LMMC] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[MRBZ] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NULL ,
[CXQX] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[FBQX] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[XGQX] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[XSSX] [int] NULL ,
[XSBZ] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[LMLJ] [ntext] COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_XYZTZD] (
[XYZTBH] [int] NOT NULL ,
[XYZTMC] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_YCDJ] (
[DJXH] [int] NOT NULL ,
[QSSJ] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[JZSJ] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[CCRS] [int] NULL ,
[YCLJ] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[ZSBZ] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_YCDJMXB] (
[MXBH] [int] NOT NULL ,
[DJXH] [int] NULL ,
[CLXH] [int] NULL ,
[CH] [nvarchar] (40) COLLATE Chinese_PRC_CI_AS NULL ,
[ZCR] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[XCLCS] [int] NULL ,
[BTJE] [real] NULL ,
[YBBTJE] [real] NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_YCSQ] (
[SQXH] [int] NOT NULL ,
[CCRS] [smallint] NULL ,
[QSSJ] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[JZSJ] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[YCLJ] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[ZSBZ] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_YCSQMXB] (
[MXBH] [int] NOT NULL ,
[SQXH] [int] NULL ,
[CLXH] [int] NULL ,
[CH] [nvarchar] (40) COLLATE Chinese_PRC_CI_AS NULL ,
[ZCR] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_YGDQZT] (
[YGBH] [int] NOT NULL ,
[DQZT] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NULL ,
[LXYY] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[SJLXSJ] [nvarchar] (16) COLLATE Chinese_PRC_CI_AS NULL ,
[LXQSSJ] [nvarchar] (16) COLLATE Chinese_PRC_CI_AS NULL ,
[YJHLSJ] [nvarchar] (16) COLLATE Chinese_PRC_CI_AS NULL ,
[LXSS] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[LXFS] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[ssid] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_YGHYKMXB] (
[GHXH] [int] NOT NULL ,
[DJXH] [int] NULL ,
[GHRQ] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[GHR] [int] NULL ,
[GHJE] [decimal](14, 2) NULL ,
[BXDXH] [int] NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_YKDJMXB] (
[MXBH] [int] NOT NULL ,
[DJXH] [int] NULL ,
[YKLB] [int] NULL ,
[SJLYJE] [decimal](14, 2) NULL ,
[BZ] [ntext] COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_YKSQMXB] (
[MXBH] [int] NOT NULL ,
[SQXH] [int] NULL ,
[YKLB] [int] NULL ,
[YJJE] [decimal](14, 2) NULL ,
[SJXQ] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_YZZD] (
[YZXH] [int] NOT NULL ,
[YZMC] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[YYR] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[YYMA] [nvarchar] (8) COLLATE Chinese_PRC_CI_AS NULL ,
[SYSGMM] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NULL ,
[TYBZ] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NULL ,
[YZWJLJ] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[BZ] [ntext] COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_ZL_QKDJ] (
[DJXH] [int] NOT NULL ,
[DJR] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[DJRQ] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[ZLMC] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[SLYQ] [int] NULL ,
[SM] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[HFR] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[HFRQ] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[HFSM] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[gs] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_ZSDJ] (
[MXBH] [int] NOT NULL ,
[DJXH] [int] NULL ,
[QSRQ] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[JZRQ] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[FH] [nvarchar] (30) COLLATE Chinese_PRC_CI_AS NULL ,
[ZSF] [decimal](14, 2) NULL ,
[DHF] [decimal](14, 2) NULL ,
[XYF] [decimal](14, 2) NULL ,
[SGF] [decimal](14, 2) NULL ,
[QTFY] [decimal](14, 2) NULL ,
[ZJ] [decimal](14, 2) NULL ,
[BZ] [ntext] COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_ZSSQ] (
[MXBH] [int] NOT NULL ,
[SQXH] [int] NULL ,
[LKDW] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[LKRS] [int] NULL ,
[QSRQ] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[JZRQ] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[JDBZ] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[OA_ZWXGRZB] (
[RZXH] [int] NOT NULL ,
[GWXH] [int] NULL ,
[XGSJ] [nvarchar] (19) COLLATE Chinese_PRC_CI_AS NULL ,
[XGR] [int] NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[RCAP] (
[YGBH] [int] NULL ,
[RCBH] [int] NOT NULL ,
[RCMC] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[RCSM] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[RCLX] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NULL ,
[FSRQ] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[FSSJ] [nvarchar] (7) COLLATE Chinese_PRC_CI_AS NULL ,
[KSRQ] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[ZZRQ] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[TQTXTS] [int] NULL ,
[ZTBZ] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NULL ,
[YXJB] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[RS_BMB] (
[BMBH] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[BMMC] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[BMZG] [int] NULL ,
[ZTBZ] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NULL ,
[BZ] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[BMJC] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[gh] [int] NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[RS_YGB] (
[YGBH] [int] NOT NULL ,
[YGXM] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[XB] [nvarchar] (2) COLLATE Chinese_PRC_CI_AS NULL ,
[HF] [nvarchar] (4) COLLATE Chinese_PRC_CI_AS NULL ,
[CSSJ] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[JG] [int] NULL ,
[ZZMM] [int] NULL ,
[SSBM] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[BYZY] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[BYXX] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[CJGZSJ] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[ZC] [int] NULL ,
[ZW] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[MZ] [int] NULL ,
[SFZH] [nvarchar] (18) COLLATE Chinese_PRC_CI_AS NULL ,
[DHHM] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[HJHM] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[DZYJ] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[YWJZ] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NULL ,
[TXDZ] [nvarchar] (100) COLLATE Chinese_PRC_CI_AS NULL ,
[YZBM] [nvarchar] (6) COLLATE Chinese_PRC_CI_AS NULL ,
[RYZT] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NULL ,
[DZRQ] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[LZRQ] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[LDHTQSRQ] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[LDHTZZRQ] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[WYYZ] [int] NULL ,
[DBXYQDSJ] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[BMXDQDSJ] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[DADRSJ] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[SFTJSFZ] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NULL ,
[SFTJXLZJ] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NULL ,
[SFTJTJB] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NULL ,
[ZP] [nvarchar] (200) COLLATE Chinese_PRC_CI_AS NULL ,
[SFFFXK] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NULL ,
[BM] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[KL] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[BZ] [ntext] COLLATE Chinese_PRC_CI_AS NULL ,
[SJHM] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[FJHM] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[gs] [int] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[Signature] (
[SignatureID] [int] IDENTITY (1, 1) NOT NULL ,
[UserName] [varchar] (64) COLLATE Chinese_PRC_CI_AS NULL ,
[PassWord] [varchar] (64) COLLATE Chinese_PRC_CI_AS NULL ,
[MarkName] [varchar] (254) COLLATE Chinese_PRC_CI_AS NULL ,
[MarkType] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[MarkBody] [image] NULL ,
[MarkPath] [varchar] (128) COLLATE Chinese_PRC_CI_AS NULL ,
[MarkSize] [int] NULL ,
[MarkDate] [datetime] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[Template] (
[TemplateID] [int] IDENTITY (1, 1) NOT NULL ,
[RecordID] [varchar] (16) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[FileName] [varchar] (254) COLLATE Chinese_PRC_CI_AS NULL ,
[FileType] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[FileSize] [int] NULL ,
[FileDate] [datetime] NULL ,
[FileBody] [image] NULL ,
[FilePath] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[UserName] [varchar] (64) COLLATE Chinese_PRC_CI_AS NULL ,
[Descript] [varchar] (255) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO

CREATE TABLE [dbo].[Template_BookMarks] (
[BookMarkID] [int] IDENTITY (1, 1) NOT NULL ,
[RecordID] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[BookMarkName] [varchar] (120) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[ZDGWLB] (
[XH] [nvarchar] (2) COLLATE Chinese_PRC_CI_AS NOT NULL ,
[MC] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[ZDJB] (
[DM] [int] NOT NULL ,
[MC] [nvarchar] (40) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[ZDJG] (
[DM] [int] NOT NULL ,
[MC] [nvarchar] (40) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[ZDLB] (
[BH] [int] NOT NULL ,
[ZDMC] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[ZDBM] [nvarchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[LBBZ] [nvarchar] (10) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[ZDMZ] (
[DM] [int] NOT NULL ,
[MC] [nvarchar] (40) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[ZDWYYZ] (
[DM] [int] NOT NULL ,
[MC] [nvarchar] (40) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[ZDZC] (
[DM] [int] NOT NULL ,
[MC] [nvarchar] (40) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[ZDZZMM] (
[DM] [int] NOT NULL ,
[MC] [nvarchar] (40) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[ZD_BXLB] (
[DM] [int] NOT NULL ,
[MC] [nvarchar] (40) COLLATE Chinese_PRC_CI_AS NULL ,
[YXBZ] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[ZD_YKLB] (
[DM] [int] NOT NULL ,
[MC] [nvarchar] (40) COLLATE Chinese_PRC_CI_AS NULL ,
[YXBZ] [nvarchar] (1) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

'''''''''''''''''''''''By Winner '''9:40 2006-3-24''''''''''''''''''
CREATE TABLE [dbo].[logguestbook] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[saytime] [smalldatetime] NULL ,
[ren] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[content] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[title] [nvarchar] (255) COLLATE Chinese_PRC_CI_AS NULL ,
[rzid] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[islook] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[ygbh] [char] (10) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO
'''''''''''''''''''''''By Winner '''9:40 2006-3-24''''''''''''''''''
CREATE TABLE [dbo].[oa_temp] (
[id] [int] NOT NULL ,
[username1] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[username2] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[urlname] [char] (50) COLLATE Chinese_PRC_CI_AS NULL ,
[zhuangtai] [int] NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[reg] (
[id] [int] IDENTITY (1, 1) NOT NULL ,
[reg] [char] (50) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

CREATE TABLE [dbo].[wxjl] (
[wxbh] [int] IDENTITY (1, 1) NOT NULL ,
[khbh] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[sj] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[isok] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[khmc] [char] (20) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO

posted @ 2006-03-31 10:35 Winner.Net(2007) 阅读(814) 评论(0) 编辑收藏举报

刷新页面返回顶部

Winner.Net@2007

专注与.Net技术

sql.srcipt

公告