finallyhoteldb.sql

酒店管理,主要从事酒店管理都可以.这可是北大青鸟的程序

# Dumping data for table 'querydetail'
#
INSERT INTO querydetail VALUES("333","1","2005-09-01","300","7","9e15e722303d4675a6b50922c2bb7980");
INSERT INTO querydetail VALUES("334","1","2005-09-02","300","16","9e15e722303d4675a6b50922c2bb7980");
INSERT INTO querydetail VALUES("335","1","2005-09-03","280","13","9e15e722303d4675a6b50922c2bb7980");
INSERT INTO querydetail VALUES("336","2","2005-09-01","350","30","9e15e722303d4675a6b50922c2bb7980");
INSERT INTO querydetail VALUES("337","2","2005-09-02","350","29","9e15e722303d4675a6b50922c2bb7980");
INSERT INTO querydetail VALUES("338","2","2005-09-03","350","30","9e15e722303d4675a6b50922c2bb7980");


#
# Table structure for table 'reserve'
#

DROP TABLE IF EXISTS reserve;
CREATE TABLE IF NOT EXISTS reserve (
  resID int(4) unsigned NOT NULL auto_increment,
  roomID int(4) ,
  resStartDate date ,
  resEndDate date ,
  MemID varchar(40) NOT NULL DEFAULT '' ,
  status int(4) unsigned NOT NULL DEFAULT '1' ,
  resNumber int(4) unsigned ,
  bookdate datetime ,
  PRIMARY KEY (resID),
   KEY IDX_reserve1 (roomID),
   KEY IDX_reserve2 (MemID)
);



#
# Dumping data for table 'reserve'
#
INSERT INTO reserve VALUES("93","1","2005-09-01","2005-09-15","aa","0","2","2005-10-16 14:54:18");
INSERT INTO reserve VALUES("94","1","2005-09-07","2005-09-09","aa","0","3","2005-10-16 14:54:54");
INSERT INTO reserve VALUES("95","1","2005-09-01","2005-09-05","aa","0","4","2005-10-16 14:58:39");
INSERT INTO reserve VALUES("96","1","2005-10-01","2005-10-16","","1","1","2005-10-16 17:14:14");
INSERT INTO reserve VALUES("97","3","2005-10-01","2005-10-04","","1","2","2005-10-16 17:14:54");
INSERT INTO reserve VALUES("98","3","2005-10-01","2005-10-06","aa","0","2","2005-10-16 17:18:35");
INSERT INTO reserve VALUES("99","1","2005-10-04","2005-10-29","aa","1","1","2005-10-16 17:38:16");


#
# Table structure for table 'roomavailable'
#

DROP TABLE IF EXISTS roomavailable;
CREATE TABLE IF NOT EXISTS roomavailable (
  id int(3) unsigned NOT NULL auto_increment,
  roomid int(3) unsigned NOT NULL DEFAULT '0' ,
  roomnum int(10) unsigned NOT NULL DEFAULT '0' ,
  begindate date ,
  enddate date ,
  price float ,
  lastupdate date ,
  isPromotion char(1) DEFAULT '0' ,
  PRIMARY KEY (id)
);



#
# Dumping data for table 'roomavailable'
#
INSERT INTO roomavailable VALUES("1","1","30","2005-09-01","2005-12-09","300","2005-10-31","0");
INSERT INTO roomavailable VALUES("2","3","30","2005-09-01","2005-12-10","350","2006-10-11","1");
INSERT INTO roomavailable VALUES("3","1","15","2005-09-03","2006-10-10","200","2007-10-10","1");
INSERT INTO roomavailable VALUES("4","1","1","2005-10-31","2005-10-31","320","2005-10-31","1");


#
# Table structure for table 'roominfo'
#

DROP TABLE IF EXISTS roominfo;
CREATE TABLE IF NOT EXISTS roominfo (
  roomID int(4) unsigned NOT NULL DEFAULT '0' ,
  serviceID int(3) unsigned NOT NULL DEFAULT '0' ,
   KEY IDX_roominfo1 (roomID)
);



#
# Dumping data for table 'roominfo'
#
INSERT INTO roominfo VALUES("1","1");
INSERT INTO roominfo VALUES("1","3");
INSERT INTO roominfo VALUES("2","1");
INSERT INTO roominfo VALUES("2","2");
INSERT INTO roominfo VALUES("2","3");


#
# Table structure for table 'roomservice'
#

DROP TABLE IF EXISTS roomservice;
CREATE TABLE IF NOT EXISTS roomservice (
  serviceID int(3) unsigned NOT NULL auto_increment,
  serviceName varchar(10) NOT NULL DEFAULT '0' ,
  description varchar(100) DEFAULT '0' ,
  PRIMARY KEY (serviceID)
);



#
# Dumping data for table 'roomservice'
#
INSERT INTO roomservice VALUES("1","叫醒服务","提供客户预约的叫醒服务");
INSERT INTO roomservice VALUES("2","送餐服务","提供客户预订的送餐服务");
INSERT INTO roomservice VALUES("3","洗衣服务","提供客户预约的各类干洗或水洗服务");
INSERT INTO roomservice VALUES("4","桑拿按摩","提供客户预约的桑拿按摩服务");


#
# Table structure for table 'roomtype'
#

DROP TABLE IF EXISTS roomtype;
CREATE TABLE IF NOT EXISTS roomtype (
  typeid int(3) unsigned NOT NULL auto_increment,
  typename varchar(20) DEFAULT '0' ,
  description varchar(100) DEFAULT '0' ,
  PRIMARY KEY (typeid),
  UNIQUE KEY un (typename)
);



#
# Dumping data for table 'roomtype'
#
INSERT INTO roomtype VALUES("1","标准单人间","含单早，客房内配置国际/国内直拨，卫星电视，冰箱等");
INSERT INTO roomtype VALUES("2","标准双人间","含双早，客房内配置国际/国内直拨，卫星电视，冰箱，私人保险箱等");
INSERT INTO roomtype VALUES("3","商务单人间","含单早，客房内配置国际/国内直拨，互联网，卫星电视，冰箱，私人保险箱等");
INSERT INTO roomtype VALUES("4","商务双人间","含双早，客房内配置国际/国内直拨，互联网，卫星电视，冰箱，私人保险箱等");
INSERT INTO roomtype VALUES("5","商务套房","含双早，客房内配置国际/国内直拨，数字电视，互联网，冰箱，私人保险箱等");
INSERT INTO roomtype VALUES("6","豪华套房","含双早，客房内配置国际/国内直拨，数字电视，互联网，冰箱，私人保险箱等");
INSERT INTO roomtype VALUES("7","标准湖景房","含双早，客房内配置国际/国内直拨，数字电视，互联网，冰箱，私人保险箱等");
INSERT INTO roomtype VALUES("8","豪华湖景房","含双早，客房内配置国际/国内直拨，数字电视，互联网，冰箱，私人保险箱等");


#
# Table structure for table 'temproom'
#

DROP TABLE IF EXISTS temproom;
CREATE TABLE IF NOT EXISTS temproom (
  id int(3) unsigned NOT NULL auto_increment,
  roomid int(3) unsigned DEFAULT '0' ,
  hotelid int(3) unsigned DEFAULT '0' ,
  hotellevel int(10) unsigned NOT NULL DEFAULT '0' ,
  roomtype int(3) unsigned DEFAULT '0' ,
  typename varchar(10) DEFAULT '0' ,
  hotelname varchar(20) DEFAULT '0' ,
  leftnum int(3) unsigned DEFAULT '0' ,
  price float NOT NULL DEFAULT '0' ,
  guid varchar(32) DEFAULT '0' ,
  PRIMARY KEY (id)
);



#
# Dumping data for table 'temproom'
#
INSERT INTO temproom VALUES("119","1","1","5","1","双人标间","厦门悦华酒店","7","880","9e15e722303d4675a6b50922c2bb7980");
INSERT INTO temproom VALUES("120","2","1","5","2","单人标间","厦门悦华酒店","29","1050","9e15e722303d4675a6b50922c2bb7980");
INSERT INTO temproom VALUES("121","1","1","5","1","双人标间","厦门悦华酒店","20","600","66672a7d8a784511bc7d05af1b92884f");
INSERT INTO temproom VALUES("122","2","1","5","2","单人标间","厦门悦华酒店","30","700","66672a7d8a784511bc7d05af1b92884f");
INSERT INTO temproom VALUES("132","2","1","5","2","单人标间","厦门悦华酒店","30","1050","e06fc0a26d5d4be5b0f22445f748744e");
INSERT INTO temproom VALUES("133","1","1","5","1","双人标间","厦门悦华酒店","15","3000","a602dcd9284c43219ea55732606c91cf");
INSERT INTO temproom VALUES("134","2","1","5","2","单人标间","厦门悦华酒店","30","4900","a602dcd9284c43219ea55732606c91cf");
INSERT INTO temproom VALUES("135","1","1","5","1","双人标间","厦门悦华酒店","13","400","16a6f8e39138450697c58980944875dd");
INSERT INTO temproom VALUES("154","2","1","5","2","单人标间","厦门悦华酒店","30","3850","8dfbca1cd36f46658333ecc463f37f0a");
INSERT INTO temproom VALUES("155","1","1","5","1","双人标间","厦门悦华酒店","15","2200","c3fb552a5b5d479593689025341e8ef3");
INSERT INTO temproom VALUES("156","3","2","5","1","双人标间","厦门喜来登大酒店","30","3850","c3fb552a5b5d479593689025341e8ef3");
INSERT INTO temproom VALUES("157","1","1","5","1","双人标间","厦门悦华酒店","15","3000","a0548b235ab3479097990c38f5e34cf6");
INSERT INTO temproom VALUES("158","3","2","5","1","双人标间","厦门喜来登大酒店","30","5250","a0548b235ab3479097990c38f5e34cf6");
INSERT INTO temproom VALUES("159","1","1","5","1","双人标间","厦门悦华酒店","15","3000","b57fa59e2b3b4a0dbfbc47ab5be3ffb6");
INSERT INTO temproom VALUES("160","3","2","5","1","双人标间","厦门喜来登大酒店","30","5250","b57fa59e2b3b4a0dbfbc47ab5be3ffb6");
INSERT INTO temproom VALUES("161","1","1","5","1","双人标间","厦门悦华酒店","15","1800","6e4c842f6d5546429454e3e41adf8a7e");
INSERT INTO temproom VALUES("162","3","2","5","1","双人标间","厦门喜来登大酒店","30","3150","6e4c842f6d5546429454e3e41adf8a7e");
INSERT INTO temproom VALUES("163","1","1","5","1","双人标间","厦门悦华酒店","15","3000","36040fa8747645c9aca78bba7fa2a650");