20020926.txt

来自「此为我2001年为东莞建发楦头开发的企业管理软件他们使用至今,望斑竹指教! 其」· 文本 代码 · 共 115 行

if exists (select * from sysobjects where id = object_id(N'[dbo].[lendinfo]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[lendinfo]
GO

CREATE TABLE [dbo].[lendinfo] (
	[clino] [nvarchar] (10) NOT NULL ,
	[model] [nvarchar] (30) NULL ,
	[lend_date] [datetime] NULL ,
	[return_date] [datetime] NULL ,
	[lend_info] [nvarchar] (200) NULL ,
	[state] [nvarchar] (10) NULL ,
	[lister] [nvarchar] (10) NULL ,
	[lender] [nvarchar] (10) NULL 
) ON [PRIMARY]
GO


if exists (select * from sysobjects where id = object_id(N'[dbo].[op]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[op]
GO

CREATE TABLE [dbo].[op] (
	[OP] [nvarchar] (8) NULL ,
	[NAME] [nvarchar] (8) NULL ,
	[PSD] [nvarchar] (20) NULL ,
	[ID] [nvarchar] (15) NULL ,
	[ADDR] [nvarchar] (40) NULL ,
	[TEL] [nvarchar] (40) NULL ,
	[zhiwu] [nvarchar] (6) NULL ,
	[client] [bit] NOT NULL ,
	[sproduce1] [bit] NOT NULL ,
	[sproduce2] [bit] NOT NULL ,
	[total] [bit] NOT NULL ,
	[delete] [bit] NOT NULL ,
	[employee] [bit] NOT NULL ,
	[ti] [bit] NOT NULL ,
	[Din] [bit] NOT NULL ,
	[SN] [bit] NOT NULL ,
	[everyday] [bit] NOT NULL ,
	[sheng] [bit] NOT NULL ,
	[stk] [bit] NOT NULL ,
	[find] [bit] NOT NULL ,
	[kf] [bit] NOT NULL ,
	[kfmodi] [bit] NOT NULL ,
	[kffind] [bit] NOT NULL ,
	[qinflag] [bit] NOT NULL ,
	[pdelete] [bit] NOT NULL ,
	[base1] [bit] NOT NULL ,
	[base2] [bit] NOT NULL ,
	[base3] [bit] NOT NULL ,
	[base4] [bit] NOT NULL ,
	[base5] [bit] NOT NULL ,
	[base6] [bit] NOT NULL ,
	[base7] [bit] NOT NULL ,
	[base8] [bit] NOT NULL ,
	[base9] [bit] NOT NULL ,
	[base10] [bit] NOT NULL ,
	[gr1] [bit] NOT NULL ,
	[gr2] [bit] NOT NULL ,
	[gr3] [bit] NOT NULL ,
	[gr4] [bit] NOT NULL ,
	[gr5] [bit] NOT NULL ,
	[gr6] [bit] NOT NULL ,
	[gr7] [bit] NOT NULL ,
	[gr8] [bit] NOT NULL ,
	[gr9] [bit] NOT NULL ,
	[gr10] [bit] NOT NULL ,
	[gr11] [bit] NOT NULL ,
	[gr12] [bit] NOT NULL ,
	[gr13] [bit] NOT NULL ,
	[gr14] [bit] NOT NULL ,
	[gr15] [bit] NOT NULL ,
	[tq1] [bit] NOT NULL ,
	[tq2] [bit] NOT NULL ,
	[tq3] [bit] NOT NULL ,
	[tq4] [bit] NOT NULL ,
	[tq5] [bit] NOT NULL ,
	[cube1] [bit] NOT NULL ,
	[cube2] [bit] NOT NULL ,
	[cube3] [bit] NOT NULL ,
	[cube4] [bit] NOT NULL ,
	[cube5] [bit] NOT NULL ,
	[cube6] [bit] NOT NULL ,
	[cube7] [bit] NOT NULL ,
	[cube8] [bit] NOT NULL ,
	[cube9] [bit] NOT NULL ,
	[cube10] [bit] NOT NULL ,
	[kf1] [bit] NOT NULL ,
	[kf2] [bit] NOT NULL ,
	[kf3] [bit] NOT NULL ,
	[kf4] [bit] NOT NULL ,
	[kf5] [bit] NOT NULL ,
	[zl1] [bit] NOT NULL ,
	[zl2] [bit] NOT NULL ,
	[zl3] [bit] NOT NULL ,
	[zl4] [bit] NOT NULL ,
	[zl5] [bit] NOT NULL ,
	[zl6] [bit] NOT NULL ,
	[exit1] [bit] NOT NULL ,
	[exit2] [bit] NOT NULL ,
	[exit3] [bit] NOT NULL ,
	[tool1] [bit] NOT NULL ,
	[tool2] [bit] NOT NULL ,
	[tool3] [bit] NOT NULL ,
	[tool4] [bit] NOT NULL ,
	[tool5] [bit] NOT NULL ,
	[tool6] [bit] NOT NULL ,
	[tool7] [bit] NOT NULL ,
	[tool8] [bit] NOT NULL ,
	[tool9] [bit] NOT NULL 
) ON [PRIMARY]
GO


/* exit1,exit2,exit3,tool9 default value is 1, other is 0 */