jg.ini

异洲酒店管理系统

if Not exists (select * from sysobjects where id = object_id(N'[dbo].[并台记录表]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
Begin
CREATE TABLE [dbo].[并台记录表] (
	[记录号] [int] IDENTITY (1, 1) NOT NULL ,
	[原单据编号] [int] NULL ,
	[目的单据号] [int] NULL ,
	[操作员] [char] (16) NULL ,
	[操作时间] [datetime] NULL ,
	[描述] [char] (150) NULL 
) ON [PRIMARY]

ALTER TABLE [dbo].[并台记录表] WITH NOCHECK ADD 
	CONSTRAINT [DF_并台记录表_操作时间] DEFAULT (getdate()) FOR [操作时间],
	CONSTRAINT [PK_并台记录表] PRIMARY KEY  NONCLUSTERED 
	(
		[记录号]
	)  ON [PRIMARY] 
End