script.ini

异洲酒店管理系统

if Not exists (select * from sysobjects where id = object_id(N'[dbo].[挂单菜谱]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
begin
CREATE TABLE [dbo].[挂单菜谱] (
	[id] [uniqueidentifier] NOT NULL ,
	[挂单编号] [int] NOT NULL ,
	[房间台号] [int] NULL ,
	[类别] [char] (10) NULL ,
	[编号] [int] NULL ,
	[名称] [char] (50) NULL ,
	[类型] [char] (20) NULL ,
	[单位] [char] (10) NULL ,
	[数量] [int] NULL ,
	[价格] [money] NULL ,
	[合计] [money] NULL ,
	[点单日期] [datetime] NULL ,
	[结单日期] [datetime] NULL ,
	[服务员编号] [int] NULL ,
	[服务员姓名] [char] (12) NULL ,
	[状态] [char] (10) NULL ,
	[结帐编号] [int] NULL ,
	[是否结单] [char] (10) NULL 
) ON [PRIMARY]


ALTER TABLE [dbo].[挂单菜谱] WITH NOCHECK ADD 
	CONSTRAINT [DF_挂单菜谱_id] DEFAULT (newid()) FOR [id],
	CONSTRAINT [PK_挂单菜谱] PRIMARY KEY  NONCLUSTERED 
	(
		[id]
	)  ON [PRIMARY] 

end