gd.sql

一个用VB写的财务软件源码

	CONSTRAINT [DF_TGD_KPXM_ZSCD] DEFAULT (0) FOR [ZSCD],
	CONSTRAINT [DF_TGD_KPXM_XSCD] DEFAULT (0) FOR [XSCD],
	CONSTRAINT [DF__TGD_KPXM__XT__3335971A] DEFAULT (0) FOR [XT],
	CONSTRAINT [DF__TGD_KPXM__BB__3429BB53] DEFAULT (0) FOR [BB],
	CONSTRAINT [DF__TGD_KPXM__KXG__351DDF8C] DEFAULT (0) FOR [KXG],
	CONSTRAINT [DF__TGD_KPXM__CXXM__1B13F4C6] DEFAULT ('999') FOR [CXXM]
; 

ALTER TABLE [dbo].[TGD_LINK] WITH NOCHECK ADD 
	CONSTRAINT [DF_TGD_LINK_VCLINKNAME] DEFAULT ('') FOR [VCLINKNAME],
	CONSTRAINT [DF_TGD_LINK_VCRELATION] DEFAULT ('') FOR [VCRELATION],
	CONSTRAINT [DF_TGD_LINK_VCLEFT] DEFAULT ('') FOR [VCLEFT],
	CONSTRAINT [DF_TGD_LINK_VCCHINAME1] DEFAULT ('') FOR [VCCHINAME1],
	CONSTRAINT [DF_TGD_LINK_VCTABLENAME1] DEFAULT ('') FOR [VCTABLENAME1],
	CONSTRAINT [DF_TGD_LINK_VCITEMCHI1] DEFAULT ('') FOR [VCITEMCHI1],
	CONSTRAINT [DF_TGD_LINK_VCITEMENG1] DEFAULT ('') FOR [VCITEMENG1],
	CONSTRAINT [DF_TGD_LINK_VCCOMPARE] DEFAULT ('') FOR [VCCOMPARE],
	CONSTRAINT [DF_TGD_LINK_VCCHINAME2] DEFAULT ('') FOR [VCCHINAME2],
	CONSTRAINT [DF_TGD_LINK_VCTABLENAME2] DEFAULT ('') FOR [VCTABLENAME2],
	CONSTRAINT [DF_TGD_LINK_VCITEMCHI2] DEFAULT ('') FOR [VCITEMCHI2],
	CONSTRAINT [DF_TGD_LINK_VCITEMENG2] DEFAULT ('') FOR [VCITEMENG2],
	CONSTRAINT [DF_TGD_LINK_VCRIGHT] DEFAULT ('') FOR [VCRIGHT],
	CONSTRAINT [DF_TGD_LINK_VCUSE] DEFAULT ('') FOR [VCUSE],
	CONSTRAINT [DF_TGD_LINK_IORDERNUM] DEFAULT ('') FOR [IORDERNUM]
 ;

ALTER TABLE [dbo].[TGD_OPTION] WITH NOCHECK ADD 
	CONSTRAINT [DF_TGD_OPTION_JTZJ_1] DEFAULT ('1') FOR [JTZJ]
 ;

ALTER TABLE [dbo].[TGD_ORIGINCHANGED] WITH NOCHECK ADD 
	CONSTRAINT [DF_TGD_ORIGINCHANGED_KPBH] DEFAULT ('') FOR [KPBH],
	CONSTRAINT [DF_TGD_ORIGINCHANGED_DJH] DEFAULT ('') FOR [DJH],
	CONSTRAINT [DF_TGD_ORIGINCHANGED_BDQZJLYDM] DEFAULT ('') FOR [BDQZJLYDM],
	CONSTRAINT [DF_TGD_ORIGINCHANGED_BDQZJLYMC] DEFAULT ('') FOR [BDQZJLYMC],
	CONSTRAINT [DF_TGD_ORIGINCHANGED_BDHZJLYDM] DEFAULT ('') FOR [BDHZJLYDM],
	CONSTRAINT [DF_TGD_ORIGINCHANGED_BDHZJLYMC] DEFAULT ('') FOR [BDHZJLYMC],
	CONSTRAINT [DF_TGD_ORIGINCHANGED_BDRQ] DEFAULT ('') FOR [BDRQ],
	CONSTRAINT [DF_TGD_ORIGINCHANGED_JSR] DEFAULT ('') FOR [JSR],
	CONSTRAINT [DF_TGD_ORIGINCHANGED_BDYY] DEFAULT ('') FOR [BDYY]
 ;

ALTER TABLE [dbo].[TGD_OTHERMODE] WITH NOCHECK ADD 
	CONSTRAINT [DF_TGD_OTHERMODE_VCFILENAME] DEFAULT ('') FOR [VCFILENAME],
	CONSTRAINT [DF_TGD_OTHERMODE_LCONTENT] DEFAULT ('') FOR [LCONTENT],
	CONSTRAINT [DF_TGD_OTHERMODE_LENGTH] DEFAULT (0) FOR [LENGTH],
	CONSTRAINT [DF_TGD_OTHERMODE_TCHINAME] DEFAULT ('') FOR [TCHINAME]
 ;

ALTER TABLE [dbo].[TGD_OTHERXM] WITH NOCHECK ADD 
	CONSTRAINT [DF_TGD_OTHERXM_TENGNAME] DEFAULT ('') FOR [TENGNAME],
	CONSTRAINT [DF_TGD_OTHERXM_TCHINAME] DEFAULT ('') FOR [TCHINAME],
	CONSTRAINT [DF_TGD_OTHERXM_XMMC] DEFAULT ('') FOR [XMMC],
	CONSTRAINT [DF_TGD_OTHERXM_LX1] DEFAULT ('') FOR [LX],
	CONSTRAINT [DF_TGD_OTHERXM_BMMC] DEFAULT ('') FOR [BMMC],
	CONSTRAINT [DF_TGD_OTHERXM_ZSCD] DEFAULT (0) FOR [ZSCD],
	CONSTRAINT [DF_TGD_OTHERXM_XSCD] DEFAULT (0) FOR [XSCD],
	CONSTRAINT [DF_TGD_OTHERXM_KPUSED] DEFAULT ('0') FOR [KPUSED]
 ;

ALTER TABLE [dbo].[TGD_PLZD<<YEAR>>] WITH NOCHECK ADD 
	CONSTRAINT [DF_TGD_PLZD<<YEAR>>_ID_1] DEFAULT (0) FOR [ID],
	CONSTRAINT [DF_TGD_PLZD<<YEAR>>_DJH_1] DEFAULT ('') FOR [DJH],
	CONSTRAINT [DF_TGD_PLZD<<YEAR>>_JLBH_1] DEFAULT (0) FOR [JLBH],
	CONSTRAINT [DF_TGD_PLZD<<YEAR>>_KJQJ_1] DEFAULT (0) FOR [KJQJ],
	CONSTRAINT [DF_TGD_PLZD<<YEAR>>_YW_1] DEFAULT ('') FOR [YW],
	CONSTRAINT [DF_TGD_PLZD<<YEAR>>_DJLX_1] DEFAULT ('') FOR [DJLX],
	CONSTRAINT [DF_TGD_PLZD<<YEAR>>_KMDM_1] DEFAULT ('') FOR [KMDM],
	CONSTRAINT [DF_TGD_PLZD<<YEAR>>_FX_1] DEFAULT ('') FOR [FX],
	CONSTRAINT [DF_TGD_PLZD<<YEAR>>_JE_1] DEFAULT (0) FOR [JE],
	CONSTRAINT [DF_TGD_PLZD<<YEAR>>_ZDBZ_1] DEFAULT ('') FOR [ZDBZ],
	CONSTRAINT [DF_TGD_PLZD<<YEAR>>_PZZL_1] DEFAULT ('') FOR [PZZL],
	CONSTRAINT [DF_TGD_PLZD<<YEAR>>_PZKJQJ_1] DEFAULT (0) FOR [PZKJQJ]
; 

ALTER TABLE [dbo].[TGD_QUERYSET] WITH NOCHECK ADD 
	CONSTRAINT [DF_TGD_QUERYSET_VCQUERYNAME] DEFAULT ('') FOR [VCQUERYNAME],
	CONSTRAINT [DF_TGD_QUERYSET_VCRELATION] DEFAULT ('') FOR [VCRELATION],
	CONSTRAINT [DF_TGD_QUERYSET_VCLEFT] DEFAULT ('') FOR [VCLEFT],
	CONSTRAINT [DF_TGD_QUERYSET_VCCHINAME] DEFAULT ('') FOR [VCCHINAME],
	CONSTRAINT [DF_TGD_QUERYSET_VCTABLENAME] DEFAULT ('') FOR [VCTABLENAME],
	CONSTRAINT [DF_TGD_QUERYSET_VCITEMCHI] DEFAULT ('') FOR [VCITEMCHI],
	CONSTRAINT [DF_TGD_QUERYSET_VCITEMENG] DEFAULT ('') FOR [VCITEMENG],
	CONSTRAINT [DF_TGD_QUERYSET_VCCOMPARE] DEFAULT ('') FOR [VCCOMPARE],
	CONSTRAINT [DF_TGD_QUERYSET_VCVALUES] DEFAULT ('') FOR [VCVALUES],
	CONSTRAINT [DF_TGD_QUERYSET_VCRIGHT] DEFAULT ('') FOR [VCRIGHT],
	CONSTRAINT [DF_TGD_QUERYSET_IORDERNUM] DEFAULT ('') FOR [IORDERNUM]
 ;

ALTER TABLE [dbo].[TGD_SYZK] WITH NOCHECK ADD 
	CONSTRAINT [DF_TGD_SYZK_DM] DEFAULT ('') FOR [DM],
	CONSTRAINT [DF_TGD_SYZK_SYZKMC] DEFAULT ('') FOR [SYZKMC],
	CONSTRAINT [DF__TGD_SYZK__SFJTZJ__28B808A7] DEFAULT (0) FOR [SFJTZJ]
 ;

ALTER TABLE [dbo].[TGD_XFFF] WITH NOCHECK ADD 
	CONSTRAINT [DF_TGD_XFFF_BH] DEFAULT ('') FOR [BH],
	CONSTRAINT [DF_TGD_XFFF_MC] DEFAULT ('') FOR [MC],
	CONSTRAINT [DF_TGD_XFFF_JSFF] DEFAULT ('') FOR [JSFF],
	CONSTRAINT [DF_TGD_XFFF_USED] DEFAULT ('0') FOR [USED]
 ;

ALTER TABLE [dbo].[TGD_YEARADJUSTGS] WITH NOCHECK ADD 
	CONSTRAINT [DF_TGD_YEARADJUSTGS_TZRQ] DEFAULT ('') FOR [TZRQ],
	CONSTRAINT [DF_TGD_YEARADJUSTGS_ZCLBBH] DEFAULT ('') FOR [ZCLBBH],
	CONSTRAINT [DF_TGD_YEARADJUSTGS_ZCLBMC] DEFAULT ('') FOR [ZCLBMC],
	CONSTRAINT [DF_TGD_YEARADJUSTGS_TZQZJGS] DEFAULT ('') FOR [TZQZJGS],
	CONSTRAINT [DF_TGD_YEARADJUSTGS_TZHZJGS] DEFAULT ('') FOR [TZHZJGS],
	CONSTRAINT [DF_TGD_YEARADJUSTGS_JSR] DEFAULT ('') FOR [JSR],
	CONSTRAINT [DF_TGD_YEARADJUSTGS_TZYY] DEFAULT ('') FOR [TZYY]
 ;

ALTER TABLE [dbo].[TGD_YSXM] WITH NOCHECK ADD 
	CONSTRAINT [DF_TGD_YSXM_YSMC] DEFAULT ('') FOR [YSMC],
	CONSTRAINT [DF_TGD_YSXM_XMMC] DEFAULT ('') FOR [XMMC],
	CONSTRAINT [PK_GD_YSXM] PRIMARY KEY  NONCLUSTERED 
	(
		[YSMC],
		[XMMC]
	)  ON [PRIMARY]; 
 ;

ALTER TABLE [dbo].[TGD_YTXF] WITH NOCHECK ADD 
	CONSTRAINT [DF_TGD_YTXF_KPBH] DEFAULT ('') FOR [KPBH],
	CONSTRAINT [DF_TGD_YTXF_YTNY] DEFAULT ('') FOR [YTNY],
	CONSTRAINT [DF_TGD_YTXF_BYYTE] DEFAULT (0) FOR [BYYTE],
	CONSTRAINT [DF_TGD_YTXF_LJYT] DEFAULT (0) FOR [LJYT],
	CONSTRAINT [DF_TGD_YTXF_ZYTE] DEFAULT (0) FOR [ZYTE],
	CONSTRAINT [DF_TGD_YTXF_YTYZ] DEFAULT (0) FOR [YTYZ],
	CONSTRAINT [DF_TGD_YTXF_TXQ] DEFAULT (0) FOR [TXQ],
	CONSTRAINT [DF_TGD_YTXF_NYTL] DEFAULT (0) FOR [NYTL]
; 

ALTER TABLE [dbo].[TGD_ZCBMFA] WITH NOCHECK ADD 
	CONSTRAINT [DF_TGD_ZCBMFA_BMFS] DEFAULT ('') FOR [BMFS],
	CONSTRAINT [DF_TGD_ZCBMFA_BMGZ] DEFAULT ('') FOR [BMGZ],
	CONSTRAINT [DF_TGD_ZCBMFA_XHCD] DEFAULT ('') FOR [XHCD],
	CONSTRAINT [DF_TGD_ZCBMFA_BMFGF] DEFAULT ('') FOR [BMFGF],
	CONSTRAINT [DF_TGD_ZCBMFA_ZXYZ] DEFAULT (0) FOR [ZXYZ]
; 

ALTER TABLE [dbo].[TGD_ZCBMZY] WITH NOCHECK ADD 
	CONSTRAINT [DF_TGD_ZCBMZY_DJH] DEFAULT ('') FOR [DJH],
	CONSTRAINT [DF_TGD_ZCBMZY_BDRQ] DEFAULT ('') FOR [BDRQ],
	CONSTRAINT [DF_TGD_ZCBMZY_JSR] DEFAULT ('') FOR [JSR],
	CONSTRAINT [DF_TGD_ZCBMZY_BDYY] DEFAULT ('') FOR [BDYY],
	CONSTRAINT [DF_TGD_ZCBMZY_BDQBM] DEFAULT ('') FOR [BDQBM],
	CONSTRAINT [DF_TGD_ZCBMZY_BDQDD] DEFAULT ('') FOR [BDQDD],
	CONSTRAINT [DF_TGD_ZCBMZY_BDHBM] DEFAULT ('') FOR [BDHBM],
	CONSTRAINT [DF_TGD_ZCBMZY_BDHDD] DEFAULT ('') FOR [BDHDD],
	CONSTRAINT [DF_TGD_ZCBMZY_BDQBMBH] DEFAULT ('') FOR [BDQBMBH],
	CONSTRAINT [DF_TGD_ZCBMZY_BDHBMBH] DEFAULT ('') FOR [BDHBMBH]
 ;

ALTER TABLE [dbo].[TGD_ZCDXJL] WITH NOCHECK ADD 
	CONSTRAINT [DF_TGD_ZCDXJL_KPBH] DEFAULT ('') FOR [KPBH],
	CONSTRAINT [DF_TGD_ZCDXJL_DJH] DEFAULT ('') FOR [DJH],
	CONSTRAINT [DF_TGD_ZCDXJL_KSRQ] DEFAULT ('') FOR [KSRQ],
	CONSTRAINT [DF_TGD_ZCDXJL_JSRQ] DEFAULT ('') FOR [JSRQ],
	CONSTRAINT [DF_TGD_ZCDXJL_XLYY] DEFAULT ('') FOR [XLYY],
	CONSTRAINT [DF_TGD_ZCDXJL_BZ] DEFAULT ('') FOR [BZ]
 ;

ALTER TABLE [dbo].[TGD_ZCFL] WITH NOCHECK ADD 
	CONSTRAINT [DF_TGD_ZCFL_DM] DEFAULT ('') FOR [DM],
	CONSTRAINT [DF_TGD_ZCFL_MC] DEFAULT ('') FOR [MC]
; 

ALTER TABLE [dbo].[TGD_ZCFSSB] WITH NOCHECK ADD 
	CONSTRAINT [DF_TGD_ZCFSSB_KPBH] DEFAULT ('') FOR [KPBH],
	CONSTRAINT [DF_TGD_ZCFSSB_SBBH] DEFAULT ('') FOR [SBBH],
	CONSTRAINT [DF_TGD_ZCFSSB_SBMC] DEFAULT ('') FOR [SBMC],
	CONSTRAINT [DF_TGD_ZCFSSB_XH] DEFAULT ('') FOR [XH],
	CONSTRAINT [DF_TGD_ZCFSSB_JZ] DEFAULT (0) FOR [JZ],
	CONSTRAINT [DF_TGD_ZCFSSB_SL] DEFAULT (0) FOR [SL],
	CONSTRAINT [DF_TGD_ZCFSSB_DW] DEFAULT ('') FOR [DW],
	CONSTRAINT [DF_TGD_ZCFSSB_SYRQ] DEFAULT ('') FOR [SYRQ],
	CONSTRAINT [DF_TGD_ZCFSSB_BZ] DEFAULT ('') FOR [BZ]
 ;

ALTER TABLE [dbo].[TGD_ZCGZZLTZ] WITH NOCHECK ADD 
	CONSTRAINT [DF_TGD_ZCGZZLTZ_DJH] DEFAULT ('') FOR [DJH],
	CONSTRAINT [DF_TGD_ZCGZZLTZ_BDRQ] DEFAULT ('') FOR [BDRQ],
	CONSTRAINT [DF_TGD_ZCGZZLTZ_JSR] DEFAULT ('') FOR [JSR],
	CONSTRAINT [DF_TGD_ZCGZZLTZ_BDYY] DEFAULT ('') FOR [BDYY],
	CONSTRAINT [DF_TGD_ZCGZZLTZ_BDQGZZL] DEFAULT (0) FOR [BDQGZZL],
	CONSTRAINT [DF_TGD_ZCGZZLTZ_BDHGZZL] DEFAULT (0) FOR [BDHGZZL]
; 

ALTER TABLE [dbo].[TGD_ZCJCZLBD] WITH NOCHECK ADD 
	CONSTRAINT [DF_TGD_ZCJCZLBD_KPBH] DEFAULT ('') FOR [KPBH],
	CONSTRAINT [DF_TGD_ZCJCZLBD_DJH] DEFAULT ('') FOR [DJH],
	CONSTRAINT [DF_TGD_ZCJCZLBD_BDRQ] DEFAULT ('') FOR [BDRQ],
	CONSTRAINT [DF_TGD_ZCJCZLBD_JSR] DEFAULT ('') FOR [JSR],
	CONSTRAINT [DF_TGD_ZCJCZLBD_BDYY] DEFAULT ('') FOR [BDYY],
	CONSTRAINT [DF_TGD_ZCJCZLBD_BDQJCZ] DEFAULT (0) FOR [BDQJCZ],
	CONSTRAINT [DF_TGD_ZCJCZLBD_BDHJCZ] DEFAULT (0) FOR [BDHJCZ],
	CONSTRAINT [DF_TGD_ZCJCZLBD_BDQJCZL] DEFAULT (0) FOR [BDQJCZL],
	CONSTRAINT [DF_TGD_ZCJCZLBD_BDHJCZL] DEFAULT (0) FOR [BDHJCZL]
; 

ALTER TABLE [dbo].[TGD_ZCJS] WITH NOCHECK ADD 
	CONSTRAINT [DF_TGD_ZCJS_KPBH] DEFAULT ('') FOR [KPBH],
	CONSTRAINT [DF_TGD_ZCJS_JSRQ] DEFAULT ('') FOR [JSRQ],
	CONSTRAINT [DF_TGD_ZCJS_JSFS] DEFAULT ('') FOR [JSFS],
	CONSTRAINT [DF_TGD_ZCJS_QLSR] DEFAULT (0) FOR [QLSR],
	CONSTRAINT [DF_TGD_ZCJS_QLFY] DEFAULT (0) FOR [QLFY],
	CONSTRAINT [DF_TGD_ZCJS_QLYY] DEFAULT ('') FOR [QLYY],
	CONSTRAINT [DF_TGD_ZCJS_JSR] DEFAULT ('') FOR [JSR],
	CONSTRAINT [DF_TGD_ZCJS_ZXRQ] DEFAULT ('') FOR [ZXRQ]
; 

ALTER TABLE [dbo].[TGD_ZCJZZB] WITH NOCHECK ADD 
	CONSTRAINT [DF_TGD_ZCJZZB_KPBH] DEFAULT ('') FOR [KPBH],
	CONSTRAINT [DF_TGD_ZCJZZB_DJH] DEFAULT ('') FOR [DJH],
	CONSTRAINT [DF_TGD_ZCJZZB_LJJZZB] DEFAULT (0) FOR [LJJZZB],
	CONSTRAINT [DF_TGD_ZCJZZB_YZ] DEFAULT (0) FOR [YZ],
	CONSTRAINT [DF_TGD_ZCJZZB_LJZJ] DEFAULT (0) FOR [LJZJ],
	CONSTRAINT [DF_TGD_ZCJZZB_JZJE] DEFAULT (0) FOR [JZJE],
	CONSTRAINT [DF_TGD_ZCJZZB_JSR] DEFAULT ('') FOR [JSR],
	CONSTRAINT [DF_TGD_ZCJZZB_BDRQ] DEFAULT ('') FOR [BDRQ],
	CONSTRAINT [DF_TGD_ZCJZZB_BDYY] DEFAULT ('') FOR [BDYY]
 ;

ALTER TABLE [dbo].[TGD_ZCLB] WITH NOCHECK ADD 
	CONSTRAINT [DF_TGD_ZCLB_DM] DEFAULT ('') FOR [DM],
	CONSTRAINT [DF_TGD_ZCLB_MC] DEFAULT ('') FOR [MC],
	CONSTRAINT [DF_TGD_ZCLB_SYNX] DEFAULT (0) FOR [SYNX],
	CONSTRAINT [DF_TGD_ZCLB_JLDW] DEFAULT ('') FOR [JLDW],
	CONSTRAINT [DF_TGD_ZCLB_JTSX] DEFAULT ('') FOR [JTSX],
	CONSTRAINT [DF_TGD_ZCLB_ZJFF] DEFAULT ('') FOR [ZJFF],
	CONSTRAINT [DF_TGD_ZCLB_KPYS] DEFAULT ('') FOR [KPYS],
	CONSTRAINT [DF_TGD_ZCLB_ZCKM] DEFAULT ('') FOR [ZCKM],
	CONSTRAINT [DF_TGD_ZCLB_ZJKM] DEFAULT ('') FOR [ZJKM],
	CONSTRAINT [DF_TGD_ZCLB_TXQ] DEFAULT (0) FOR [TXQ],
	CONSTRAINT [DF_TGD_ZCLB_YTXFL] DEFAULT (0) FOR [YTXFL],
	CONSTRAINT [DF_TGD_ZCLB_XFKM] DEFAULT ('') FOR [XFKM],
	CONSTRAINT [DF_TGD_ZCLB_JZZBKM_1] DEFAULT ('') FOR [JZZBKM]
 ;

ALTER TABLE [dbo].[TGD_ZCLBJS] WITH NOCHECK ADD 
	CONSTRAINT [DF_TGD_ZCLBJS_JC] DEFAULT (0) FOR [JC],
	CONSTRAINT [DF__TGD_ZCLBJS__WS__2D7CBDC4] DEFAULT (0) FOR [WS]
; 

ALTER TABLE [dbo].[TGD_ZCLBTZ] WITH NOCHECK ADD 
	CONSTRAINT [DF_TGD_ZCLBTZ_DJH] DEFAULT ('') FOR [DJH],
	CONSTRAINT [DF_TGD_ZCLBTZ_BDRQ] DEFAULT ('') FOR [BDRQ],
	CONSTRAINT [DF_TGD_ZCLBTZ_JSR] DEFAULT ('') FOR [JSR],
	CONSTRAINT [DF_TGD_ZCLBTZ_BDYY] DEFAULT ('') FOR [BDYY],
	CONSTRAINT [DF_TGD_ZCLBTZ_BDQZCLB] DEFAULT ('') FOR [BDQZCLB],
	CONSTRAINT [DF_TGD_ZCLBTZ_BDHZCLB] DEFAULT ('') FOR [BDHZCLB],
	CONSTRAINT [DF_TGD_ZCLBTZ_BDQZCLBBH] DEFAULT ('') FOR [BDQZCLBBH],
	CONSTRAINT [DF_TGD_ZCLBTZ_BDHZCLBBH] DEFAULT ('') FOR [BDHZCLBBH],
	CONSTRAINT [DF_TGD_ZCLBTZ_TXQ] DEFAULT (0) FOR [TXQ],
	CONSTRAINT [DF_TGD_ZCLBTZ_YTFL] DEFAULT (0) FOR [YTFL]
; 

ALTER TABLE [dbo].[TGD_ZCLJZJTZ] WITH NOCHECK ADD 
	CONSTRAINT [DF_TGD_ZCLJZJTZ_KPBH] DEFAULT ('') FOR [KPBH],
	CONSTRAINT [DF_TGD_ZCLJZJTZ_DJH] DEFAULT ('') FOR [DJH],
	CONSTRAINT [DF_TGD_ZCLJZJTZ_BDRQ] DEFAULT ('') FOR [BDRQ],
	CONSTRAINT [DF_TGD_ZCLJZJTZ_JSR] DEFAULT ('') FOR [JSR],
	CONSTRAINT [DF_TGD_ZCLJZJTZ_BDYY] DEFAULT ('') FOR [BDYY],
	CONSTRAINT [DF_TGD_ZCLJZJTZ_BDQLJZJ] DEFAULT (0) FOR [BDQLJZJ],
	CONSTRAINT [DF_TGD_ZCLJZJTZ_BDHLJZJ] DEFAULT (0) FOR [BDHLJZJ]
 ;

ALTER TABLE [dbo].[TGD_ZCPG] WITH NOCHECK ADD 
	CONSTRAINT [DF_TGD_ZCPG_KPBH] DEFAULT ('') FOR [KPBH],
	CONSTRAINT [DF_TGD_ZCPG_DJH] DEFAULT ('') FOR [DJH],
	CONSTRAINT [DF_TGD_ZCPG_PGQYZ] DEFAULT (0) FOR [PGQYZ],
	CONSTRAINT [DF_TGD_ZCPG_PGHYZ] DEFAULT (0) FOR [PGHYZ],
	CONSTRAINT [DF_TGD_ZCPG_PGQLJZJ] DEFAULT (0) FOR [PGQLJZJ],
	CONSTRAINT [DF_TGD_ZCPG_PGHLJZJ] DEFAULT (0) FOR [PGHLJZJ],
	CONSTRAINT [DF_TGD_ZCPG_PGQJZ] DEFAULT (0) FOR [PGQJZ],
	CONSTRAINT [DF_TGD_ZCPG_PGHJZ] DEFAULT (0) FOR [PGHJZ],
	CONSTRAINT [DF_TGD_ZCPG_PGQJCZL] DEFAULT (0) FOR [PGQJCZL],
	CONSTRAINT [DF_TGD_ZCPG_PGHJCZL] DEFAULT (0) FOR [PGHJCZL],
	CONSTRAINT [DF_TGD_ZCPG_PGQSYNX] DEFAULT (0) FOR [PGQSYNX],
	CONSTRAINT [DF_TGD_ZCPG_PGHSYNX] DEFAULT (0) FOR [PGHSYNX],
	CONSTRAINT [DF_TGD_ZCPG_PGQGZZL] DEFAULT (0) FOR [PGQGZZL],
	CONSTRAINT [DF_TGD_ZCPG_PGHGZZL] DEFAULT (0) FOR [PGHGZZL],
	CONSTRAINT [DF_TGD_ZCPG_PGQJZZB] DEFAULT (0) FOR [PGQJZZB],
	CONSTRAINT [DF_TGD_ZCPG_PGHJZZB] DEFAULT (0) FOR [PGHJZZB],
	CONSTRAINT [DF_TGD_ZCPG_PGRQ] DEFAULT ('') FOR [PGRQ],
	CONSTRAINT [DF_TGD_ZCPG_JSR] DEFAULT ('') FOR [JSR],
	CONSTRAINT [DF_TGD_ZCPG_BZ] DEFAULT ('') FOR [BZ]
; 

ALTER TABLE [dbo].[TGD_ZCSYNXTZ] WITH NOCHECK ADD 
	CONSTRAINT [DF_TGD_ZCSYNXTZ_KPBH] DEFAULT ('') FOR [KPBH],
	CONSTRAINT [DF_TGD_ZCSYNXTZ_DJH] DEFAULT ('') FOR [DJH],
	CONSTRAINT [DF_TGD_ZCSYNXTZ_BDRQ] DEFAULT ('') FOR [BDRQ],
	CONSTRAINT [DF_TGD_ZCSYNXTZ_JSR] DEFAULT ('') FOR [JSR],
	CONSTRAINT [DF_TGD_ZCSYNXTZ_BDYY] DEFAULT ('') FOR [BDYY],
	CONSTRAINT [DF_TGD_ZCSYNXTZ_BZ] DEFAULT ('') FOR [BZ],
	CONSTRAINT [DF_TGD_ZCSYNXTZ_BDQSYNX] DEFAULT ('') FOR [BDQSYNX],
	CONSTRAINT [DF_TGD_ZCSYNXTZ_BDHSYNX] DEFAULT ('') FOR [BDHSYNX]
 ;

ALTER TABLE [dbo].[TGD_ZCTQYJL]