sql.hotel.management.software.rar_SQL代码_hotel

use master go if exists (select * from dbo.sysdatabases where name = 'Hotel') drop database Hotel GO create database Hotel go use Hotel go if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[bookin]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[bookin] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[rooms]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[rooms] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[roomtype]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[roomtype] GO CREATE TABLE [dbo].[bookin] ( [bookno] [char] (14) COLLATE Chinese_PRC_CI_AS NOT NULL , [customname] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , [customID] [char] (18) COLLATE Chinese_PRC_CI_AS NOT NULL , [roomno] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , [indate] [datetime] NULL , [discount] [numeric](2, 0) NULL , [inmemo] [text] COLLATE Chinese_PRC_CI_AS NULL , [checkdate] [datetime] NULL , [ammount] [numeric](10, 2) NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO CREATE TABLE [dbo].[rooms] ( [roomNO] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , [roomtype] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , [roomposition] [char] (20) COLLATE Chinese_PRC_CI_AS NULL , [roomprice] [numeric](10, 2) NULL , [putup] [char] (2) COLLATE Chinese_PRC_CI_AS NOT NULL , [roommemo] [text] COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO CREATE TABLE [dbo].[roomtype] ( [typeid] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , [typename] [char] (10) COLLATE Chinese_PRC_CI_AS NOT NULL , [area] [numeric](5, 0) NULL , [bednum] [numeric](2, 0) NULL , [haircondition] [char] (2) COLLATE Chinese_PRC_CI_AS NULL , [htelephone] [char] (2) COLLATE Chinese_PRC_CI_AS NULL , [htelevision] [char] (2) COLLATE Chinese_PRC_CI_AS NULL , [htoilet] [char] (2) COLLATE Chinese_PRC_CI_AS NULL , [price] [numeric](10, 2) NULL ) ON [PRIMARY] GO