# 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","aa@21cn.com","你是誰？","豬","aaa123","0","0");
INSERT INTO member VALUES("bb","456","時光","廈門市思明區6號","2223365","bb@163.com","你表姐貴姓？","鄭","bbb123","0","0");
INSERT INTO member VALUES("cc","789","崔秀","廈門市海滄區33號","7445888","cc@21cn.com","有沒有結婚？","沒有","cc123","0","0");
INSERT INTO member VALUES("www","123456","nini","12448ddaad","","123@163.com","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)
);



#