shaolin.master.tab

1:首先要导入hotel数据

/****** Object:  Table [dbo].[book]    Script Date: 2007-7-4 21:52:29 ******/
if not exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[book]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
 BEGIN
CREATE TABLE [dbo].[book] (
	[bno] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[class] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[publish] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[writer] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[bname] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[bmoney] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[test] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[bcount] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[buydate] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
)
END

GO

/****** Object:  Table [dbo].[book1]    Script Date: 2007-7-4 21:52:30 ******/
if not exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[book1]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
 BEGIN
CREATE TABLE [dbo].[book1] (
	[bno] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[class] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[publish] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[writer] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[bname] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[bmoney] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[test] [char] (20) COLLATE Chinese_PRC_CI_AS NULL ,
	[bcount] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[buydate] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
)
END

GO

/****** Object:  Table [dbo].[borrow]    Script Date: 2007-7-4 21:52:30 ******/
if not exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[borrow]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
 BEGIN
CREATE TABLE [dbo].[borrow] (
	[bno] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[rno] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[rdate] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[returndate] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
)
END

GO

/****** Object:  Table [dbo].[reader]    Script Date: 2007-7-4 21:52:30 ******/
if not exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[reader]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
 BEGIN
CREATE TABLE [dbo].[reader] (
	[rno] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NOT NULL ,
	[rname] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[place] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL ,
	[sex] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ,
	[phone] [nvarchar] (50) COLLATE Chinese_PRC_CI_AS NULL 
)
END

GO