ty.sql

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

	CONSTRAINT [DF__tUSU_Fz20__ljjsl__1273C1CD] DEFAULT (0) FOR [ljjsl00],
	CONSTRAINT [DF__tUSU_Fz20__ljjwb__1367E606] DEFAULT (0) FOR [ljjwb00],
	CONSTRAINT [DF__tUSU_Fz20__ljj00__145C0A3F] DEFAULT (0) FOR [ljj00],
	CONSTRAINT [DF__tUSU_Fz20__ljdsl__15502E78] DEFAULT (0) FOR [ljdsl00],
	CONSTRAINT [DF__tUSU_Fz20__ljdwb__164452B1] DEFAULT (0) FOR [ljdwb00],
	CONSTRAINT [DF__tUSU_Fz20__ljd00__173876EA] DEFAULT (0) FOR [ljd00],
	CONSTRAINT [DF__tUSU_Fz20__ljjsl__182C9B23] DEFAULT (0) FOR [ljjsl01],
	CONSTRAINT [DF__tUSU_Fz20__ljjwb__1920BF5C] DEFAULT (0) FOR [ljjwb01],
	CONSTRAINT [DF__tUSU_Fz20__ljj01__1A14E395] DEFAULT (0) FOR [ljj01],
	CONSTRAINT [DF__tUSU_Fz20__ljdsl__1B0907CE] DEFAULT (0) FOR [ljdsl01],
	CONSTRAINT [DF__tUSU_Fz20__ljdwb__1BFD2C07] DEFAULT (0) FOR [ljdwb01],
	CONSTRAINT [DF__tUSU_Fz20__ljd01__1CF15040] DEFAULT (0) FOR [ljd01],
	CONSTRAINT [DF__tUSU_Fz20__ljjsl__1DE57479] DEFAULT (0) FOR [ljjsl02],
	CONSTRAINT [DF__tUSU_Fz20__ljjwb__1ED998B2] DEFAULT (0) FOR [ljjwb02],
	CONSTRAINT [DF__tUSU_Fz20__ljj02__1FCDBCEB] DEFAULT (0) FOR [ljj02],
	CONSTRAINT [DF__tUSU_Fz20__ljdsl__20C1E124] DEFAULT (0) FOR [ljdsl02],
	CONSTRAINT [DF__tUSU_Fz20__ljdwb__21B6055D] DEFAULT (0) FOR [ljdwb02],
	CONSTRAINT [DF__tUSU_Fz20__ljd02__22AA2996] DEFAULT (0) FOR [ljd02],
	CONSTRAINT [DF__tUSU_Fz20__ljjsl__239E4DCF] DEFAULT (0) FOR [ljjsl03],
	CONSTRAINT [DF__tUSU_Fz20__ljjwb__24927208] DEFAULT (0) FOR [ljjwb03],
	CONSTRAINT [DF__tUSU_Fz20__ljj03__25869641] DEFAULT (0) FOR [ljj03],
	CONSTRAINT [DF__tUSU_Fz20__ljdsl__267ABA7A] DEFAULT (0) FOR [ljdsl03],
	CONSTRAINT [DF__tUSU_Fz20__ljdwb__276EDEB3] DEFAULT (0) FOR [ljdwb03],
	CONSTRAINT [DF__tUSU_Fz20__ljd03__286302EC] DEFAULT (0) FOR [ljd03],
	CONSTRAINT [DF__tUSU_Fz20__ljjsl__29572725] DEFAULT (0) FOR [ljjsl04],
	CONSTRAINT [DF__tUSU_Fz20__ljjwb__2A4B4B5E] DEFAULT (0) FOR [ljjwb04],
	CONSTRAINT [DF__tUSU_Fz20__ljj04__2B3F6F97] DEFAULT (0) FOR [ljj04],
	CONSTRAINT [DF__tUSU_Fz20__ljdsl__2C3393D0] DEFAULT (0) FOR [ljdsl04],
	CONSTRAINT [DF__tUSU_Fz20__ljdwb__2D27B809] DEFAULT (0) FOR [ljdwb04],
	CONSTRAINT [DF__tUSU_Fz20__ljd04__2E1BDC42] DEFAULT (0) FOR [ljd04],
	CONSTRAINT [DF__tUSU_Fz20__ljjsl__2F10007B] DEFAULT (0) FOR [ljjsl05],
	CONSTRAINT [DF__tUSU_Fz20__ljjwb__300424B4] DEFAULT (0) FOR [ljjwb05],
	CONSTRAINT [DF__tUSU_Fz20__ljj05__30F848ED] DEFAULT (0) FOR [ljj05],
	CONSTRAINT [DF__tUSU_Fz20__ljdsl__31EC6D26] DEFAULT (0) FOR [ljdsl05],
	CONSTRAINT [DF__tUSU_Fz20__ljdwb__32E0915F] DEFAULT (0) FOR [ljdwb05],
	CONSTRAINT [DF__tUSU_Fz20__ljd05__33D4B598] DEFAULT (0) FOR [ljd05],
	CONSTRAINT [DF__tUSU_Fz20__ljjsl__34C8D9D1] DEFAULT (0) FOR [ljjsl06],
	CONSTRAINT [DF__tUSU_Fz20__ljjwb__35BCFE0A] DEFAULT (0) FOR [ljjwb06],
	CONSTRAINT [DF__tUSU_Fz20__ljj06__36B12243] DEFAULT (0) FOR [ljj06],
	CONSTRAINT [DF__tUSU_Fz20__ljdsl__37A5467C] DEFAULT (0) FOR [ljdsl06],
	CONSTRAINT [DF__tUSU_Fz20__ljdwb__38996AB5] DEFAULT (0) FOR [ljdwb06],
	CONSTRAINT [DF__tUSU_Fz20__ljd06__398D8EEE] DEFAULT (0) FOR [ljd06],
	CONSTRAINT [DF__tUSU_Fz20__ljjsl__3A81B327] DEFAULT (0) FOR [ljjsl07],
	CONSTRAINT [DF__tUSU_Fz20__ljjwb__3B75D760] DEFAULT (0) FOR [ljjwb07],
	CONSTRAINT [DF__tUSU_Fz20__ljj07__3C69FB99] DEFAULT (0) FOR [ljj07],
	CONSTRAINT [DF__tUSU_Fz20__ljdsl__3D5E1FD2] DEFAULT (0) FOR [ljdsl07],
	CONSTRAINT [DF__tUSU_Fz20__ljdwb__3E52440B] DEFAULT (0) FOR [ljdwb07],
	CONSTRAINT [DF__tUSU_Fz20__ljd07__3F466844] DEFAULT (0) FOR [ljd07],
	CONSTRAINT [DF__tUSU_Fz20__ljjsl__403A8C7D] DEFAULT (0) FOR [ljjsl08],
	CONSTRAINT [DF__tUSU_Fz20__ljjwb__412EB0B6] DEFAULT (0) FOR [ljjwb08],
	CONSTRAINT [DF__tUSU_Fz20__ljj08__4222D4EF] DEFAULT (0) FOR [ljj08],
	CONSTRAINT [DF__tUSU_Fz20__ljdsl__4316F928] DEFAULT (0) FOR [ljdsl08],
	CONSTRAINT [DF__tUSU_Fz20__ljdwb__440B1D61] DEFAULT (0) FOR [ljdwb08],
	CONSTRAINT [DF__tUSU_Fz20__ljd08__44FF419A] DEFAULT (0) FOR [ljd08],
	CONSTRAINT [DF__tUSU_Fz20__ljjsl__45F365D3] DEFAULT (0) FOR [ljjsl09],
	CONSTRAINT [DF__tUSU_Fz20__ljjwb__46E78A0C] DEFAULT (0) FOR [ljjwb09],
	CONSTRAINT [DF__tUSU_Fz20__ljj09__47DBAE45] DEFAULT (0) FOR [ljj09],
	CONSTRAINT [DF__tUSU_Fz20__ljdsl__48CFD27E] DEFAULT (0) FOR [ljdsl09],
	CONSTRAINT [DF__tUSU_Fz20__ljdwb__49C3F6B7] DEFAULT (0) FOR [ljdwb09],
	CONSTRAINT [DF__tUSU_Fz20__ljd09__4AB81AF0] DEFAULT (0) FOR [ljd09],
	CONSTRAINT [DF__tUSU_Fz20__ljjsl__4BAC3F29] DEFAULT (0) FOR [ljjsl10],
	CONSTRAINT [DF__tUSU_Fz20__ljjwb__4CA06362] DEFAULT (0) FOR [ljjwb10],
	CONSTRAINT [DF__tUSU_Fz20__ljj10__4D94879B] DEFAULT (0) FOR [ljj10],
	CONSTRAINT [DF__tUSU_Fz20__ljdsl__4E88ABD4] DEFAULT (0) FOR [ljdsl10],
	CONSTRAINT [DF__tUSU_Fz20__ljdwb__4F7CD00D] DEFAULT (0) FOR [ljdwb10],
	CONSTRAINT [DF__tUSU_Fz20__ljd10__5070F446] DEFAULT (0) FOR [ljd10],
	CONSTRAINT [DF__tUSU_Fz20__ljjsl__5165187F] DEFAULT (0) FOR [ljjsl11],
	CONSTRAINT [DF__tUSU_Fz20__ljjwb__52593CB8] DEFAULT (0) FOR [ljjwb11],
	CONSTRAINT [DF__tUSU_Fz20__ljj11__534D60F1] DEFAULT (0) FOR [ljj11],
	CONSTRAINT [DF__tUSU_Fz20__ljdsl__5441852A] DEFAULT (0) FOR [ljdsl11],
	CONSTRAINT [DF__tUSU_Fz20__ljdwb__5535A963] DEFAULT (0) FOR [ljdwb11],
	CONSTRAINT [DF__tUSU_Fz20__ljd11__5629CD9C] DEFAULT (0) FOR [ljd11],
	CONSTRAINT [DF__tUSU_Fz20__ljjsl__571DF1D5] DEFAULT (0) FOR [ljjsl12],
	CONSTRAINT [DF__tUSU_Fz20__ljjwb__5812160E] DEFAULT (0) FOR [ljjwb12],
	CONSTRAINT [DF__tUSU_Fz20__ljj12__59063A47] DEFAULT (0) FOR [ljj12],
	CONSTRAINT [DF__tUSU_Fz20__ljdsl__59FA5E80] DEFAULT (0) FOR [ljdsl12],
	CONSTRAINT [DF__tUSU_Fz20__ljdwb__5AEE82B9] DEFAULT (0) FOR [ljdwb12],
	CONSTRAINT [DF__tUSU_Fz20__ljd12__5BE2A6F2] DEFAULT (0) FOR [ljd12],
	 PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[tUSU_PzMutex] WITH NOCHECK ADD 
	CONSTRAINT [PK_USU_PzMutex] PRIMARY KEY  NONCLUSTERED 
	(
		[iPeriod],
		[cPzzl]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[tUSU_SubCompany] WITH NOCHECK ADD 
	CONSTRAINT [DF__tUSU_SubC__bMerg__08EA5793] DEFAULT ((-1)) FOR [bMerge],
	CONSTRAINT [PK_USU_SubCompany] PRIMARY KEY  CLUSTERED 
	(
		[cCode]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[tUSU_Trade] WITH NOCHECK ADD 
	CONSTRAINT [PK_USU_Trade] PRIMARY KEY  CLUSTERED 
	(
		[vcName]
	)  ON [PRIMARY] 
;
SET QUOTED_IDENTIFIER ON;
SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;
SET ARITHABORT ON;
SET NUMERIC_ROUNDABORT OFF;
SET CONCAT_NULL_YIELDS_NULL ON;
SET ANSI_NULLS ON;
SET ANSI_PADDING ON;
SET ANSI_WARNINGS ON;
ALTER TABLE [dbo].[tZW_Balance<<YEAR>>] WITH NOCHECK ADD 
	CONSTRAINT [DF__tZW_Balance2__bz__6D0D32F4] DEFAULT ('人民币') FOR [bz],
	CONSTRAINT [DF__tZW_Balan__ljjsl__6E01572D] DEFAULT (0) FOR [ljjsl00],
	CONSTRAINT [DF__tZW_Balan__ljjwb__6EF57B66] DEFAULT (0) FOR [ljjwb00],
	CONSTRAINT [DF__tZW_Balan__ljj00__6FE99F9F] DEFAULT (0) FOR [ljj00],
	CONSTRAINT [DF__tZW_Balan__ljdsl__70DDC3D8] DEFAULT (0) FOR [ljdsl00],
	CONSTRAINT [DF__tZW_Balan__ljdwb__71D1E811] DEFAULT (0) FOR [ljdwb00],
	CONSTRAINT [DF__tZW_Balan__ljd00__72C60C4A] DEFAULT (0) FOR [ljd00],
	CONSTRAINT [DF__tZW_Balan__ljjsl__73BA3083] DEFAULT (0) FOR [ljjsl01],
	CONSTRAINT [DF__tZW_Balan__ljjwb__74AE54BC] DEFAULT (0) FOR [ljjwb01],
	CONSTRAINT [DF__tZW_Balan__ljj01__75A278F5] DEFAULT (0) FOR [ljj01],
	CONSTRAINT [DF__tZW_Balan__ljdsl__76969D2E] DEFAULT (0) FOR [ljdsl01],
	CONSTRAINT [DF__tZW_Balan__ljdwb__778AC167] DEFAULT (0) FOR [ljdwb01],
	CONSTRAINT [DF__tZW_Balan__ljd01__787EE5A0] DEFAULT (0) FOR [ljd01],
	CONSTRAINT [DF__tZW_Balan__ljjsl__797309D9] DEFAULT (0) FOR [ljjsl02],
	CONSTRAINT [DF__tZW_Balan__ljjwb__7A672E12] DEFAULT (0) FOR [ljjwb02],
	CONSTRAINT [DF__tZW_Balan__ljj02__7B5B524B] DEFAULT (0) FOR [ljj02],
	CONSTRAINT [DF__tZW_Balan__ljdsl__7C4F7684] DEFAULT (0) FOR [ljdsl02],
	CONSTRAINT [DF__tZW_Balan__ljdwb__7D439ABD] DEFAULT (0) FOR [ljdwb02],
	CONSTRAINT [DF__tZW_Balan__ljd02__7E37BEF6] DEFAULT (0) FOR [ljd02],
	CONSTRAINT [DF__tZW_Balan__ljjsl__7F2BE32F] DEFAULT (0) FOR [ljjsl03],
	CONSTRAINT [DF__tZW_Balan__ljjwb__00200768] DEFAULT (0) FOR [ljjwb03],
	CONSTRAINT [DF__tZW_Balan__ljj03__01142BA1] DEFAULT (0) FOR [ljj03],
	CONSTRAINT [DF__tZW_Balan__ljdsl__02084FDA] DEFAULT (0) FOR [ljdsl03],
	CONSTRAINT [DF__tZW_Balan__ljdwb__02FC7413] DEFAULT (0) FOR [ljdwb03],
	CONSTRAINT [DF__tZW_Balan__ljd03__03F0984C] DEFAULT (0) FOR [ljd03],
	CONSTRAINT [DF__tZW_Balan__ljjsl__04E4BC85] DEFAULT (0) FOR [ljjsl04],
	CONSTRAINT [DF__tZW_Balan__ljjwb__05D8E0BE] DEFAULT (0) FOR [ljjwb04],
	CONSTRAINT [DF__tZW_Balan__ljj04__06CD04F7] DEFAULT (0) FOR [ljj04],
	CONSTRAINT [DF__tZW_Balan__ljdsl__07C12930] DEFAULT (0) FOR [ljdsl04],
	CONSTRAINT [DF__tZW_Balan__ljdwb__08B54D69] DEFAULT (0) FOR [ljdwb04],
	CONSTRAINT [DF__tZW_Balan__ljd04__09A971A2] DEFAULT (0) FOR [ljd04],
	CONSTRAINT [DF__tZW_Balan__ljjsl__0A9D95DB] DEFAULT (0) FOR [ljjsl05],
	CONSTRAINT [DF__tZW_Balan__ljjwb__0B91BA14] DEFAULT (0) FOR [ljjwb05],
	CONSTRAINT [DF__tZW_Balan__ljj05__0C85DE4D] DEFAULT (0) FOR [ljj05],
	CONSTRAINT [DF__tZW_Balan__ljdsl__0D7A0286] DEFAULT (0) FOR [ljdsl05],
	CONSTRAINT [DF__tZW_Balan__ljdwb__0E6E26BF] DEFAULT (0) FOR [ljdwb05],
	CONSTRAINT [DF__tZW_Balan__ljd05__0F624AF8] DEFAULT (0) FOR [ljd05],
	CONSTRAINT [DF__tZW_Balan__ljjsl__10566F31] DEFAULT (0) FOR [ljjsl06],
	CONSTRAINT [DF__tZW_Balan__ljjwb__114A936A] DEFAULT (0) FOR [ljjwb06],
	CONSTRAINT [DF__tZW_Balan__ljj06__123EB7A3] DEFAULT (0) FOR [ljj06],
	CONSTRAINT [DF__tZW_Balan__ljdsl__1332DBDC] DEFAULT (0) FOR [ljdsl06],
	CONSTRAINT [DF__tZW_Balan__ljdwb__14270015] DEFAULT (0) FOR [ljdwb06],
	CONSTRAINT [DF__tZW_Balan__ljd06__151B244E] DEFAULT (0) FOR [ljd06],
	CONSTRAINT [DF__tZW_Balan__ljjsl__160F4887] DEFAULT (0) FOR [ljjsl07],
	CONSTRAINT [DF__tZW_Balan__ljjwb__17036CC0] DEFAULT (0) FOR [ljjwb07],
	CONSTRAINT [DF__tZW_Balan__ljj07__17F790F9] DEFAULT (0) FOR [ljj07],
	CONSTRAINT [DF__tZW_Balan__ljdsl__18EBB532] DEFAULT (0) FOR [ljdsl07],
	CONSTRAINT [DF__tZW_Balan__ljdwb__19DFD96B] DEFAULT (0) FOR [ljdwb07],
	CONSTRAINT [DF__tZW_Balan__ljd07__1AD3FDA4] DEFAULT (0) FOR [ljd07],
	CONSTRAINT [DF__tZW_Balan__ljjsl__1BC821DD] DEFAULT (0) FOR [ljjsl08],
	CONSTRAINT [DF__tZW_Balan__ljjwb__1CBC4616] DEFAULT (0) FOR [ljjwb08],
	CONSTRAINT [DF__tZW_Balan__ljj08__1DB06A4F] DEFAULT (0) FOR [ljj08],
	CONSTRAINT [DF__tZW_Balan__ljdsl__1EA48E88] DEFAULT (0) FOR [ljdsl08],
	CONSTRAINT [DF__tZW_Balan__ljdwb__1F98B2C1] DEFAULT (0) FOR [ljdwb08],
	CONSTRAINT [DF__tZW_Balan__ljd08__208CD6FA] DEFAULT (0) FOR [ljd08],
	CONSTRAINT [DF__tZW_Balan__ljjsl__2180FB33] DEFAULT (0) FOR [ljjsl09],
	CONSTRAINT [DF__tZW_Balan__ljjwb__22751F6C] DEFAULT (0) FOR [ljjwb09],
	CONSTRAINT [DF__tZW_Balan__ljj09__236943A5] DEFAULT (0) FOR [ljj09],
	CONSTRAINT [DF__tZW_Balan__ljdsl__245D67DE] DEFAULT (0) FOR [ljdsl09],
	CONSTRAINT [DF__tZW_Balan__ljdwb__25518C17] DEFAULT (0) FOR [ljdwb09],
	CONSTRAINT [DF__tZW_Balan__ljd09__2645B050] DEFAULT (0) FOR [ljd09],
	CONSTRAINT [DF__tZW_Balan__ljjsl__2739D489] DEFAULT (0) FOR [ljjsl10],
	CONSTRAINT [DF__tZW_Balan__ljjwb__282DF8C2] DEFAULT (0) FOR [ljjwb10],
	CONSTRAINT [DF__tZW_Balan__ljj10__29221CFB] DEFAULT (0) FOR [ljj10],
	CONSTRAINT [DF__tZW_Balan__ljdsl__2A164134] DEFAULT (0) FOR [ljdsl10],
	CONSTRAINT [DF__tZW_Balan__ljdwb__2B0A656D] DEFAULT (0) FOR [ljdwb10],
	CONSTRAINT [DF__tZW_Balan__ljd10__2BFE89A6] DEFAULT (0) FOR [ljd10],
	CONSTRAINT [DF__tZW_Balan__ljjsl__2CF2ADDF] DEFAULT (0) FOR [ljjsl11],
	CONSTRAINT [DF__tZW_Balan__ljjwb__2DE6D218] DEFAULT (0) FOR [ljjwb11],
	CONSTRAINT [DF__tZW_Balan__ljj11__2EDAF651] DEFAULT (0) FOR [ljj11],
	CONSTRAINT [DF__tZW_Balan__ljdsl__2FCF1A8A] DEFAULT (0) FOR [ljdsl11],
	CONSTRAINT [DF__tZW_Balan__ljdwb__30C33EC3] DEFAULT (0) FOR [ljdwb11],
	CONSTRAINT [DF__tZW_Balan__ljd11__31B762FC] DEFAULT (0) FOR [ljd11],
	CONSTRAINT [DF__tZW_Balan__ljjsl__32AB8735] DEFAULT (0) FOR [ljjsl12],
	CONSTRAINT [DF__tZW_Balan__ljjwb__339FAB6E] DEFAULT (0) FOR [ljjwb12],
	CONSTRAINT [DF__tZW_Balan__ljj12__3493CFA7] DEFAULT (0) FOR [ljj12],
	CONSTRAINT [DF__tZW_Balan__ljdsl__3587F3E0] DEFAULT (0) FOR [ljdsl12],
	CONSTRAINT [DF__tZW_Balan__ljdwb__367C1819] DEFAULT (0) FOR [ljdwb12],
	CONSTRAINT [DF__tZW_Balan__ljd12__37703C52] DEFAULT (0) FOR [ljd12],
	CONSTRAINT [PK_ZW_balance<<YEAR>>] PRIMARY KEY  NONCLUSTERED 
	(
		[kmdm],
		[bz]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[tZW_km<<YEAR>>] WITH NOCHECK ADD 
	CONSTRAINT [DF__tZW_km<<YEAR>>__IsEnd__5EBF139D] DEFAULT ((-1)) FOR [IsEndkm],
	CONSTRAINT [DF__tZW_km<<YEAR>>__zygs__5FB337D6] DEFAULT ('金额式') FOR [zygs],
	CONSTRAINT [DF__tZW_km<<YEAR>>__IsRjz__60A75C0F] DEFAULT (0) FOR [IsRjz],
	CONSTRAINT [DF__tZW_km<<YEAR>>__IsYhz__619B8048] DEFAULT (0) FOR [IsYhz],
	CONSTRAINT [DF__tZW_km<<YEAR>>__IsGrw__628FA481] DEFAULT (0) FOR [IsGrwlhs],
	CONSTRAINT [DF__tZW_km<<YEAR>>__IsKhw__6383C8BA] DEFAULT (0) FOR [IsKhwlhs],
	CONSTRAINT [DF__tZW_km<<YEAR>>__IsGys__6477ECF3] DEFAULT (0) FOR [IsGyswlhs],
	CONSTRAINT [DF__tZW_km<<YEAR>>__IsBmh__656C112C] DEFAULT (0) FOR [IsBmhs],
	CONSTRAINT [DF__tZW_km<<YEAR>>__IsXmh__66603565] DEFAULT (0) FOR [IsXmhs],
	CONSTRAINT [DF__tZW_km<<YEAR>>__IsXjl__6754599E] DEFAULT (0) FOR [IsXjllkm],
	CONSTRAINT [DF__tZW_km<<YEAR>>__kmqx__68487DD7] DEFAULT (0) FOR [kmqx],
	CONSTRAINT [DF__tZW_km<<YEAR>>__IsFc__693CA210] DEFAULT (0) FOR [IsFc],
	CONSTRAINT [DF__tZW_km<<YEAR>>__bUse__6A30C649] DEFAULT (0) FOR [bUse],
	CONSTRAINT [DF__tZW_km<<YEAR>>__bAdd__6B24EA82] DEFAULT ((-1)) FOR [bAdd],
	 PRIMARY KEY  CLUSTERED 
	(
		[kmdm]
	)  ON [PRIMARY] 
;