finallyhoteldb.sql

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

# MySQL-Front Dump 2.1
#
# Host: localhost   Database: hoteldb
#--------------------------------------------------------
# Server version 4.0.16-nt

USE hoteldb;


#
# Table structure for table 'guestroom'
#

DROP TABLE IF EXISTS guestroom;
CREATE TABLE IF NOT EXISTS guestroom (
  roomID int(4) unsigned NOT NULL auto_increment,
  hotelID int(4) NOT NULL DEFAULT '0' ,
  roomType int(3) unsigned NOT NULL DEFAULT '0' ,
  roomNum int(4) unsigned NOT NULL DEFAULT '0' ,
  roomPrice float ,
  cancelDate tinyint(3) unsigned DEFAULT '0' ,
  PRIMARY KEY (hotelID,roomType),
  UNIQUE KEY IDX_guestroom2 (roomID),
   KEY IDX_guestroom1 (hotelID)
);



#
# Dumping data for table 'guestroom'
#
INSERT INTO guestroom VALUES("1","1","1","50","400","0");
INSERT INTO guestroom VALUES("2","1","2","20","600","0");
INSERT INTO guestroom VALUES("3","2","4","15","380","0");
INSERT INTO guestroom VALUES("4","2","5","25","800","0");
INSERT INTO guestroom VALUES("5","3","2","12","425","0");
INSERT INTO guestroom VALUES("6","3","7","15","750","0");


#
# Table structure for table 'hotel'
#

DROP TABLE IF EXISTS hotel;
CREATE TABLE IF NOT EXISTS hotel (
  hotelID int(4) unsigned NOT NULL auto_increment,
  hotelName varchar(40) NOT NULL DEFAULT '' ,
  HotelAddr varchar(40) ,
  HotelPlace varchar(40) ,
  HotelLevel int(4) unsigned NOT NULL DEFAULT '0' ,
  description varchar(200) ,
  image blob ,
  User varchar(40) NOT NULL DEFAULT '' ,
  Password varchar(20) NOT NULL DEFAULT '' ,
  lastupDate datetime ,
  PRIMARY KEY (hotelID),
  UNIQUE KEY IDX_hotel1 (hotelID)
);



#
# Dumping data for table 'hotel'
#
INSERT INTO hotel VALUES("1","厦门悦华酒店","厦门湖里悦华路","湖里区","5","酒店以五星级为标准，住、食、行、游、购、娱以及商务、会议设施成龙配套，是来厦进行商贸活动、探亲访友、度假旅游的理想下榻场所。","","abc","123","2005-09-25 16:46:07");
INSERT INTO hotel VALUES("2","厦门长升大酒店","厦门长青路433号","思明区","4","厦门长升大酒店是家高档商务酒店的后起之秀，位于厦门经济金融中心湖滨北路东段，与风景秀丽的筼筜湖、松柏公园及沃尔玛、莱雅、SM城市广场等购物中心相邻。酒店地段优越，交通极为便捷","","xyz","123456","0000-00-00 00:00:00");
INSERT INTO hotel VALUES("3","厦门宝龙大酒店","厦门白鹭洲","思明区","5","宝龙大酒店是一家全新的四星级豪华大酒店，座落于风景怡人的白鹭洲湖畔，地处厦门休闲、金融及商务中心，闹中取静，交通便捷。","","viva","abc","0000-00-00 00:00:00");
INSERT INTO hotel VALUES("4","厦门京闽中心酒店","厦门嘉禾路","思明区","4","酒店拥有233间各式精致舒适的客房，其中包括标准房、豪华房、商务房及套房等八款房型，大部分客房可免费宽带上网。酒店总台接待为独特的座式服务，专设商务会所、行政会议室，供商务楼层客人免费使用。","","qq","12345","0000-00-00 00:00:00");
INSERT INTO hotel VALUES("5","厦门闽南大酒店","厦门湖滨南路","思明区","4","闽南大酒店位于厦门湖滨南路闽南大厦内，是由大厦门闽南实业股份有限公司投资兴建的国际性商务酒店。酒店地处繁华的金融和商贸中心，交通便利，离火车站仅5分钟车程，至国际机场也只需10分钟。","","power","123abc","0000-00-00 00:00:00");


#
# Table structure for table 'inuseroom'
#

DROP TABLE IF EXISTS inuseroom;
CREATE TABLE IF NOT EXISTS inuseroom (
  roomID int(4) NOT NULL DEFAULT '0' ,
  resDate date NOT NULL DEFAULT '0000-00-00' ,
  inuseNumber int(4) ,
  hotelID int(4) ,
  PRIMARY KEY (roomID,resDate),
   KEY IDX_inuseroom1 (hotelID)
);



#
# Dumping data for table 'inuseroom'
#
INSERT INTO inuseroom VALUES("1","2005-09-01","-3","0");
INSERT INTO inuseroom VALUES("1","2005-09-02","-3","0");
INSERT INTO inuseroom VALUES("1","2005-09-03","-3","0");
INSERT INTO inuseroom VALUES("1","2005-09-04","-3","0");
INSERT INTO inuseroom VALUES("1","2005-09-05","-7","0");
INSERT INTO inuseroom VALUES("1","2005-09-06","-7","0");
INSERT INTO inuseroom VALUES("1","2005-09-07","-4","0");
INSERT INTO inuseroom VALUES("1","2005-09-08","-4","0");
INSERT INTO inuseroom VALUES("1","2005-09-09","-7","0");
INSERT INTO inuseroom VALUES("1","2005-09-10","-7","0");
INSERT INTO inuseroom VALUES("1","2005-09-11","-7","0");
INSERT INTO inuseroom VALUES("1","2005-09-12","-7","0");
INSERT INTO inuseroom VALUES("1","2005-09-13","-7","0");
INSERT INTO inuseroom VALUES("1","2005-09-14","-7","0");
INSERT INTO inuseroom VALUES("1","2005-10-01","1","0");
INSERT INTO inuseroom VALUES("1","2005-10-02","1","0");
INSERT INTO inuseroom VALUES("1","2005-10-03","1","0");
INSERT INTO inuseroom VALUES("1","2005-10-04","2","0");
INSERT INTO inuseroom VALUES("1","2005-10-05","2","0");
INSERT INTO inuseroom VALUES("1","2005-10-06","2","0");
INSERT INTO inuseroom VALUES("1","2005-10-07","2","0");
INSERT INTO inuseroom VALUES("1","2005-10-08","2","0");
INSERT INTO inuseroom VALUES("1","2005-10-09","2","0");
INSERT INTO inuseroom VALUES("1","2005-10-10","2","0");
INSERT INTO inuseroom VALUES("1","2005-10-11","2","0");
INSERT INTO inuseroom VALUES("1","2005-10-12","2","0");
INSERT INTO inuseroom VALUES("1","2005-10-13","2","0");
INSERT INTO inuseroom VALUES("1","2005-10-14","2","0");
INSERT INTO inuseroom VALUES("1","2005-10-15","2","0");
INSERT INTO inuseroom VALUES("1","2005-10-16","1","0");
INSERT INTO inuseroom VALUES("1","2005-10-17","1","0");
INSERT INTO inuseroom VALUES("1","2005-10-18","1","0");
INSERT INTO inuseroom VALUES("1","2005-10-19","1","0");
INSERT INTO inuseroom VALUES("1","2005-10-20","1","0");
INSERT INTO inuseroom VALUES("1","2005-10-21","1","0");
INSERT INTO inuseroom VALUES("1","2005-10-22","1","0");
INSERT INTO inuseroom VALUES("1","2005-10-23","1","0");
INSERT INTO inuseroom VALUES("1","2005-10-24","1","0");
INSERT INTO inuseroom VALUES("1","2005-10-25","1","0");
INSERT INTO inuseroom VALUES("1","2005-10-26","1","0");
INSERT INTO inuseroom VALUES("1","2005-10-27","1","0");
INSERT INTO inuseroom VALUES("1","2005-10-28","1","0");
INSERT INTO inuseroom VALUES("3","2005-10-01","2","0");
INSERT INTO inuseroom VALUES("3","2005-10-02","2","0");
INSERT INTO inuseroom VALUES("3","2005-10-03","2","0");
INSERT INTO inuseroom VALUES("3","2005-10-04","0","0");
INSERT INTO inuseroom VALUES("3","2005-10-05","0","0");


#
# Table structure for table 'member'
#

DROP TABLE IF EXISTS member;
CREATE TABLE IF NOT EXISTS member (
  memID varchar(40) NOT NULL DEFAULT '' ,
  MemPwd varchar(20) NOT NULL DEFAULT '' ,
  Name varchar(20) NOT NULL DEFAULT '' ,
  MemAddr varchar(40) ,
  TelNumber varchar(20) NOT NULL DEFAULT '' ,
  Email varchar(40) ,
  question varchar(40) NOT NULL DEFAULT '' ,
  answer varchar(20) NOT NULL DEFAULT '' ,
  MemCardID varchar(40) ,
  Integral int(4) ,
  balance int(4) ,
  PRIMARY KEY (memID),
  UNIQUE KEY IDX_member1 (memID)
);



#
# Dumping data for table 'member'
#
INSERT INTO member VALUES("aa","aa","张行","厦门市湖里区2号","5366193","[e-mail]","你是谁？","猪","aaa123","0","0");
INSERT INTO member VALUES("bb","456","时光","厦门市思明区6号","2223365","[e-mail]","你表姐贵姓？","郑","bbb123","0","0");
INSERT INTO member VALUES("cc","789","崔秀","厦门市海沧区33号","7445888","[e-mail]","有没有结婚？","没有","cc123","0","0");
INSERT INTO member VALUES("www","123456","nini","12448ddaad","","[e-mail]","ni","wo","","0","0");


#
# Table structure for table 'querydetail'
#

DROP TABLE IF EXISTS querydetail;
CREATE TABLE IF NOT EXISTS querydetail (
  id int(3) unsigned NOT NULL auto_increment,
  roomID int(3) unsigned NOT NULL DEFAULT '0' ,
  bookDate date ,
  price float DEFAULT '0' ,
  leftNum int(10) unsigned ,
  guid varchar(32) DEFAULT '0' ,
  PRIMARY KEY (id)
);



#