mr.sql

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

		[VCCODE]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[TMR_DRAFT<<YEAR>>] WITH NOCHECK ADD 
	CONSTRAINT [PK_TMR_DRAFT<<YEAR>>] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[TMR_DRAFTASSISTANT<<YEAR>>] WITH NOCHECK ADD 
	CONSTRAINT [PK_TMR_DRAFTASSISTANT<<YEAR>>] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[TMR_LOCKREPORT] WITH NOCHECK ADD 
	CONSTRAINT [PK_TMR_LOCKREPORT] PRIMARY KEY  CLUSTERED 
	(
		[VCREPORTCODE],
		[IMONTH],
		[IYEAR],
		[COMPANYCODE]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[TMR_MANUSCRIPTDESIGN] WITH NOCHECK ADD 
	CONSTRAINT [PK_TMR_MANUSCRIPTDESIGN] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[TMR_MERGECOL] WITH NOCHECK ADD 
	CONSTRAINT [PK_TMR_MERGECOL] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[TMR_OFFSET<<YEAR>>] WITH NOCHECK ADD 
	CONSTRAINT [PK_TMR_OFFSET<<YEAR>>] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[TMR_OFFSETBILL] WITH NOCHECK ADD 
	CONSTRAINT [PK_TMR_OFFSETBILL] PRIMARY KEY  CLUSTERED 
	(
		[KJNF],
		[KJQJ],
		[DWBH],
		[BH],
		[JLHM]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[TMR_OFFSETBILLMODEL] WITH NOCHECK ADD 
	CONSTRAINT [PK_TMR_OFFSETBILLMODEL] PRIMARY KEY  CLUSTERED 
	(
		[VCCODE],
		[VCYEAR]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[TMR_OFFSETDATA<<YEAR>>] WITH NOCHECK ADD 
	CONSTRAINT [PK_TMR_OFFSETDATA<<YEAR>>] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[TMR_OFFSETEQUAL<<YEAR>>] WITH NOCHECK ADD 
	CONSTRAINT [PK_TMR_OFFSETEQUAL<<YEAR>>] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[TMR_OFFSETITEM<<YEAR>>] WITH NOCHECK ADD 
	CONSTRAINT [PK_TMR_OFFSETITEM<<YEAR>>] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[TMR_OFFSETSUB<<YEAR>>] WITH NOCHECK ADD 
	CONSTRAINT [PK_TMR_OFFSETSUB<<YEAR>>] PRIMARY KEY  CLUSTERED 
	(
		[ID],
		[SISERIAL]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[TMR_PARAMETER] WITH NOCHECK ADD 
	CONSTRAINT [PK_TMR_PARAMETER] PRIMARY KEY  CLUSTERED 
	(
		[ID],
		[COMPANYCODE],
		[CYEAR]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[TMR_REPORT<<YEAR>>] WITH NOCHECK ADD 
	CONSTRAINT [PK_TMR_REPORT<<YEAR>>] PRIMARY KEY  CLUSTERED 
	(
		[VCREPORTCODE]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[TMR_REPORTAREA] WITH NOCHECK ADD 
	CONSTRAINT [PK_TMR_REPORTAREA] PRIMARY KEY  CLUSTERED 
	(
		[CYEAR],
		[VCREPORTCODE],
		[siStartRow],
		[siStartCol],
		[siEndRow],
		[siEndCol]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[TMR_REPORTDATA<<YEAR>>] WITH NOCHECK ADD 
	CONSTRAINT [PK_TMR_REPORTDATA<<YEAR>>] PRIMARY KEY  CLUSTERED 
	(
		[REPORTCODE],
		[ENTERCODE],
		[MONTH],
		[IROWLABEL],
		[COLLABEL]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[TMR_REPORTEQUALIN] WITH NOCHECK ADD 
	CONSTRAINT [PK_TMR_REPORTEQUALIN] PRIMARY KEY  CLUSTERED 
	(
		[CYEAR],
		[VCREPORTCODE],
		[ISORTID]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[TMR_REPORTEQUALOUT] WITH NOCHECK ADD 
	CONSTRAINT [PK_TMR_REPORTEQUALOUT] PRIMARY KEY  CLUSTERED 
	(
		[CYEAR],
		[VCREPORTCODE],
		[ISORTID]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[TMR_REPORTFORMULA] WITH NOCHECK ADD 
	CONSTRAINT [PK_TMR_REPORTFORMULA] PRIMARY KEY  CLUSTERED 
	(
		[CYEAR],
		[VCREPORTCODE],
		[SIROWLABEL],
		[SICOLLABEL]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[TMR_REPORTITEM] WITH NOCHECK ADD 
	CONSTRAINT [PK_TMR_REPORTITEM] PRIMARY KEY  CLUSTERED 
	(
		[CYEAR],
		[VCREPORTCODE],
		[SIROWLABEL],
		[SICOLLABEL],
		[VCITEMNAME]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[TMR_REPORTMODE] WITH NOCHECK ADD 
	CONSTRAINT [PK_TMR_REPORTMODE] PRIMARY KEY  CLUSTERED 
	(
		[CYEAR],
		[CMONTH],
		[VCREPORTCODE]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[TMR_TEMPLETDETAIL<<YEAR>>] WITH NOCHECK ADD 
	CONSTRAINT [PK_TMR_TEMPLETDETAIL<<YEAR>>] PRIMARY KEY  CLUSTERED 
	(
		[CCODE],
		[JLHM]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[TMR_TEMPLETMAIN<<YEAR>>] WITH NOCHECK ADD 
	CONSTRAINT [PK_TMR_TEMPLETMAIN<<YEAR>>] PRIMARY KEY  CLUSTERED 
	(
		[CCODE]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[TMR_WBHL] WITH NOCHECK ADD 
	CONSTRAINT [PK_TMR_WBHL] PRIMARY KEY  CLUSTERED 
	(
		[ID]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[TMR_ZYWH] WITH NOCHECK ADD 
	CONSTRAINT [PK_TMR_ZYWH] PRIMARY KEY  CLUSTERED 
	(
		[DMID]
	)  ON [PRIMARY] 
;

ALTER TABLE [dbo].[TMR_COLLATEFORMULA] WITH NOCHECK ADD 
	CONSTRAINT [DF_TMR_COLLATEFORMULA_JF] DEFAULT ('') FOR [JF],
	CONSTRAINT [DF_TMR_COLLATEFORMULA_DF] DEFAULT ('') FOR [DF]
;

ALTER TABLE [dbo].[TMR_COMPANY] WITH NOCHECK ADD 
	CONSTRAINT [DF_TMR_COMPANY_CTYPE] DEFAULT ('二级') FOR [CTYPE],
	CONSTRAINT [DF_TMR_COMPANY_BMERGE] DEFAULT (0) FOR [BMERGE],
	CONSTRAINT [DF_TMR_COMPANY_STOCK] DEFAULT ('全资') FOR [STOCK]
;

ALTER TABLE [dbo].[TMR_DRAFT<<YEAR>>] WITH NOCHECK ADD 
	CONSTRAINT [DF_TMR_DRAFT<<YEAR>>_MONTH] DEFAULT ('00') FOR [MONTH],
	CONSTRAINT [DF_TMR_DRAFT<<YEAR>>_MERGECOLID] DEFAULT (0) FOR [MERGECOLID],
	CONSTRAINT [DF_TMR_DRAFT<<YEAR>>_OFFSETITEMID] DEFAULT (0) FOR [OFFSETITEMID],
	CONSTRAINT [DF_TMR_DRAFT<<YEAR>>_TOTAL] DEFAULT (0) FOR [TOTAL],
	CONSTRAINT [DF_TMR_DRAFT<<YEAR>>_JF] DEFAULT (0) FOR [JF],
	CONSTRAINT [DF_TMR_DRAFT<<YEAR>>_DF] DEFAULT (0) FOR [DF],
	CONSTRAINT [DF_TMR_DRAFT<<YEAR>>_GQ] DEFAULT (0) FOR [GQ],
	CONSTRAINT [DF_TMR_DRAFT<<YEAR>>_MERGE] DEFAULT (0) FOR [MERGE]
;

ALTER TABLE [dbo].[TMR_DRAFTASSISTANT<<YEAR>>] WITH NOCHECK ADD 
	CONSTRAINT [DF_TMR_DRAFTASSISTANT<<YEAR>>_DRAFTID] DEFAULT (0) FOR [DRAFTID],
	CONSTRAINT [DF_TMR_DRAFTASSISTANT<<YEAR>>_MANUSCRIPTCOLID] DEFAULT (0) FOR [MANUSCRIPTCOLID],
	CONSTRAINT [DF_TMR_DRAFTASSISTANT<<YEAR>>_DATA] DEFAULT (0) FOR [DATA]
;

ALTER TABLE [dbo].[TMR_MANUSCRIPTDESIGN] WITH NOCHECK ADD 
	CONSTRAINT [DF_TMR_MANUSCRIPTDESIGN_ICOL] DEFAULT (0) FOR [ICOL]
;

ALTER TABLE [dbo].[TMR_MERGECOL] WITH NOCHECK ADD 
	CONSTRAINT [DF_TMR_MERGECOL_VCFORMULA] DEFAULT ('') FOR [VCFORMULA]
;

ALTER TABLE [dbo].[TMR_OFFSET<<YEAR>>] WITH NOCHECK ADD 
	CONSTRAINT [DF_TMR_OFFSET<<YEAR>>_CMONTH] DEFAULT ('00') FOR [CMONTH],
	CONSTRAINT [DF_TMR_OFFSET<<YEAR>>_CNUMBER] DEFAULT ('0000') FOR [CNUMBER],
	CONSTRAINT [DF_TMR_OFFSET<<YEAR>>_VCREPORTCODE] DEFAULT ('') FOR [VCREPORTCODE],
	CONSTRAINT [DF_TMR_OFFSET<<YEAR>>_CUSERID] DEFAULT ('') FOR [CUSERID],
	CONSTRAINT [DF_TMR_OFFSET<<YEAR>>_CUSERNAME] DEFAULT ('') FOR [CUSERNAME],
	CONSTRAINT [DF_TMR_OFFSET<<YEAR>>_VCCOMMENT] DEFAULT ('') FOR [VCCOMMENT],
	CONSTRAINT [DF_TMR_OFFSET<<YEAR>>_BAUTO] DEFAULT (0) FOR [BAUTO]
;

ALTER TABLE [dbo].[TMR_OFFSETBILL] WITH NOCHECK ADD 
	CONSTRAINT [DF_TMR_OFFSETBILL_ID] DEFAULT (0) FOR [ID],
	CONSTRAINT [DF_TMR_OFFSETBILL_JE] DEFAULT (0) FOR [JE],
	CONSTRAINT [DF_TMR_OFFSETBILL_QRJE] DEFAULT (0) FOR [QRJE],
	CONSTRAINT [DF_TMR_OFFSETBILL_XGBZ] DEFAULT (0) FOR [XGBZ],
	CONSTRAINT [DF_TMR_OFFSETBILL_PROFIT] DEFAULT (0) FOR [PROFIT]
;

ALTER TABLE [dbo].[TMR_OFFSETBILLMODEL] WITH NOCHECK ADD 
	CONSTRAINT [DF_TMR_OFFSETBILLMODEL_VCNAME] DEFAULT ('') FOR [VCNAME],
	CONSTRAINT [DF_TMR_OFFSETBILLMODEL_VCTYPE] DEFAULT ('往来') FOR [VCTYPE],
	CONSTRAINT [DF_TMR_OFFSETBILLMODEL_VCITEM] DEFAULT ('') FOR [VCITEM]
;

ALTER TABLE [dbo].[TMR_OFFSETDATA<<YEAR>>] WITH NOCHECK ADD 
	CONSTRAINT [DF_TMR_OFFSETDATA<<YEAR>>_COID] DEFAULT ('0') FOR [COID],
	CONSTRAINT [DF_TMR_OFFSETDATA<<YEAR>>_OFFSETITEMID] DEFAULT (0) FOR [OFFSETITEMID],
	CONSTRAINT [DF_TMR_OFFSETDATA<<YEAR>>_CUSTOMERCOID] DEFAULT ('0') FOR [CUSTOMERCOID],
	CONSTRAINT [DF_TMR_OFFSETDATA<<YEAR>>_DATA] DEFAULT (0) FOR [DATA],
	CONSTRAINT [DF_TMR_OFFSETDATA<<YEAR>>_MONTH] DEFAULT ('00') FOR [MONTH],
	CONSTRAINT [DF_TMR_OFFSETDATA<<YEAR>>_BUSED] DEFAULT (1) FOR [BUSED]
;

ALTER TABLE [dbo].[TMR_OFFSETEQUAL<<YEAR>>] WITH NOCHECK ADD 
	CONSTRAINT [DF_TMR_OFFSETEQUAL<<YEAR>>_ISORTID] DEFAULT (0) FOR [ISORTID],
	CONSTRAINT [DF_TMR_OFFSETEQUAL<<YEAR>>_EQUALFORMULA] DEFAULT ('') FOR [EQUALFORMULA],
	CONSTRAINT [DF_TMR_OFFSETEQUAL<<YEAR>>_EQUALRESULT] DEFAULT (0) FOR [EQUALRESULT]
;

ALTER TABLE [dbo].[TMR_OFFSETITEM<<YEAR>>] WITH NOCHECK ADD 
	CONSTRAINT [DF_TMR_OFFSETITEM<<YEAR>>_ITEMNAME] DEFAULT ('') FOR [ITEMNAME],
	CONSTRAINT [DF_TMR_OFFSETITEM<<YEAR>>_VCREPORTCODE] DEFAULT ('') FOR [VCREPORTCODE],
	CONSTRAINT [DF_TMR_OFFSETITEM<<YEAR>>_VCREPORTITEM] DEFAULT ('') FOR [VCREPORTITEM],
	CONSTRAINT [DF_TMR_OFFSETITEM<<YEAR>>_SIROWLABEL] DEFAULT (0) FOR [SIROWLABEL],
	CONSTRAINT [DF_TMR_OFFSETITEM<<YEAR>>_SICOLLABEL] DEFAULT (0) FOR [SICOLLABEL],
	CONSTRAINT [DF_TMR_OFFSETITEM<<YEAR>>_MERGECOLID] DEFAULT (0) FOR [MERGECOLID],
	CONSTRAINT [DF_TMR_OFFSETITEM<<YEAR>>_TYPE] DEFAULT (0) FOR [TYPE],
	CONSTRAINT [DF_TMR_OFFSETITEM<<YEAR>>_BEXPORT] DEFAULT (1) FOR [BEXPORT],
	CONSTRAINT [DF_TMR_OFFSETITEM<<YEAR>>_BENTER] DEFAULT (1) FOR [BENTER]
;

ALTER TABLE [dbo].[TMR_OFFSETSUB<<YEAR>>] WITH NOCHECK ADD 
	CONSTRAINT [DF_TMR_OFFSETSUB<<YEAR>>_VCSUMMARY] DEFAULT ('') FOR [VCSUMMARY],
	CONSTRAINT [DF_TMR_OFFSETSUB<<YEAR>>_DEJE] DEFAULT (0) FOR [DEJE],
	CONSTRAINT [DF_TMR_OFFSETSUB<<YEAR>>_VCREPORTITEM] DEFAULT ('') FOR [VCREPORTITEM],
	CONSTRAINT [DF_TMR_OFFSETSUB<<YEAR>>_IITEMROW] DEFAULT (0) FOR [IITEMROW],
	CONSTRAINT [DF_TMR_OFFSETSUB<<YEAR>>_ITEMID] DEFAULT (0) FOR [ITEMID]
;

ALTER TABLE [dbo].[TMR_PARAMETER] WITH NOCHECK ADD 
	CONSTRAINT [DF_TMR_PARAMETER_ID] DEFAULT ('0') FOR [ID],
	CONSTRAINT [DF_TMR_PARAMETER_CNAME] DEFAULT ('') FOR [CNAME],
	CONSTRAINT [DF_TMR_PARAMETER_CVALUE] DEFAULT ('0') FOR [CVALUE]
;

ALTER TABLE [dbo].[TMR_REPORT<<YEAR>>] WITH NOCHECK ADD 
	CONSTRAINT [DF_TMR_REPORT<<YEAR>>_SISERIAL] DEFAULT (0) FOR [SISERIAL],
	CONSTRAINT [DF_TMR_REPORT<<YEAR>>_ID] DEFAULT (0) FOR [ID],
	CONSTRAINT [DF_TMR_REPORT<<YEAR>>_BACCESSORY] DEFAULT (0) FOR [BACCESSORY],
	CONSTRAINT [DF_TMR_REPORT<<YEAR>>_PARENTCODE] DEFAULT ('') FOR [PARENTCODE]
;

ALTER TABLE [dbo].[TMR_REPORTHEAD] WITH NOCHECK ADD 
	CONSTRAINT [DF_TMR_REPORTHEAD_MERGECOLID] DEFAULT (0) FOR [MERGECOLID]
;

ALTER TABLE [dbo].[TMR_REPORTMODE] WITH NOCHECK ADD 
	CONSTRAINT [DF_TMR_REPORTMODE_LENGTH] DEFAULT (0) FOR [LENGTH]
;

ALTER TABLE [dbo].[TMR_TEMPLETMAIN<<YEAR>>] WITH NOCHECK ADD 
	CONSTRAINT [DF_TMR_TEMPLETMAIN<<YEAR>>_TIFJZS] DEFAULT (0) FOR [TIFJZS]
;

ALTER TABLE [dbo].[TMR_WBHL] WITH NOCHECK ADD 
	CONSTRAINT [DF_TMR_WBHL_HL] DEFAULT (1) FOR [HL]
;

;