hoteldb.sql

本人做的酒店宾馆管理系统网站,仅供大家参考或扩展

  PRIMARY KEY  (`hotelplaneid`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

#
# Dumping data for table hotelplane
#
INSERT INTO `hotelplane` VALUES (1,'深圳航空公司','直达','111111','112222','aa','wwwww','经济舱','国内航班','单程','不限','1','1222');
INSERT INTO `hotelplane` VALUES (2,'中国东方航空公司','所有','点击选择日期','点击选择日期','dfg','df','公务舱','国际航班','单程','上午(06:00以后)','fd','df');
INSERT INTO `hotelplane` VALUES (3,'上海航空公司','所有','2004-09-28','2004-09-29','上海','北京','头等舱','国内航班','单程','上午(06:00以后)','6','380');


#
# Table structure for table hotelroomtype
#

CREATE TABLE `hotelroomtype` (
  `Id` int(11) NOT NULL auto_increment,
  `housetype` varchar(50) default NULL COMMENT '客房类型',
  `salesroomprice` varchar(50) default '0' COMMENT '原价',
  `internetprice` varchar(50) default '0' COMMENT '会员价',
  `agreementprice` varchar(50) default '0' COMMENT '协议价',
  `breakfast` varchar(50) default '无' COMMENT '有无早餐',
  `remark` varchar(150) default NULL COMMENT '简介',
  `hotelid` int(11) NOT NULL default '0' COMMENT '酒店ID值',
  `limittime` varchar(20) default NULL COMMENT '最后期限',
  PRIMARY KEY  (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk COMMENT='酒店房间类型';

#
# Dumping data for table hotelroomtype
#
INSERT INTO `hotelroomtype` VALUES (1,'null','0','0','0','无','null',0,'null');
INSERT INTO `hotelroomtype` VALUES (2,'null','0','0','0','无','null',0,'null');
INSERT INTO `hotelroomtype` VALUES (3,'null','0','0','0','无','null',0,'null');
INSERT INTO `hotelroomtype` VALUES (4,'null','0','0','0','无','null',0,'null');
INSERT INTO `hotelroomtype` VALUES (5,'null','0','0','0','无','null',8,'null');
INSERT INTO `hotelroomtype` VALUES (6,'null','0','0','0','无','null',0,'null');
INSERT INTO `hotelroomtype` VALUES (7,'null','0','0','0','无','null',0,'null');
INSERT INTO `hotelroomtype` VALUES (8,'null','0','0','0','无','null',0,'null');
INSERT INTO `hotelroomtype` VALUES (9,'null','0','0','0','无','null',13,'null');
INSERT INTO `hotelroomtype` VALUES (10,'aa','11','11','11','有','aaa',0,'11111');
INSERT INTO `hotelroomtype` VALUES (11,'zzzzzz','11','12','13','无','zzzzzzzzzzzzzzzz',1,'12343243');
INSERT INTO `hotelroomtype` VALUES (12,'dsf','fdsaf','fds','afdsf','有','fdsafads',1,'fdasf');
INSERT INTO `hotelroomtype` VALUES (13,'12121','12121','12121','1212','有','121212',1,'12121');
INSERT INTO `hotelroomtype` VALUES (14,'null','null','null','null','null','null',1,'null');
INSERT INTO `hotelroomtype` VALUES (15,'dsf','dsfsd','dsff','dsfdsf','null','sdfffff',1,'sdf');
INSERT INTO `hotelroomtype` VALUES (16,'d','d','d','d','有','dd',1,'d');
INSERT INTO `hotelroomtype` VALUES (17,'df','fds','fd','f','无','fds',1,'dfs');
INSERT INTO `hotelroomtype` VALUES (18,'fdsf','fsdf','sdf','dsff','有','fsd',1,'fdsf');
INSERT INTO `hotelroomtype` VALUES (19,'dsf','fsdf','dsf','fdsfsf','有','fdsfdsf',1,'2006-09-13');


#
# Table structure for table hotelzuche
#

CREATE TABLE `hotelzuche` (
  `ID` int(11) NOT NULL auto_increment,
  `chetype` varchar(80) default NULL COMMENT '汽车款式',
  `cheseat` varchar(30) default '0座' COMMENT '座位',
  `chepurpose` varchar(30) default NULL COMMENT '服务范围',
  `checarId` varchar(30) default NULL COMMENT '车主',
  `cheserver` varchar(30) default NULL COMMENT '出租公司',
  `cheprice` varchar(30) default '00.0' COMMENT '价钱',
  `chenet` varchar(30) default '00.0' COMMENT '网上价',
  `chedata` date default NULL COMMENT '时间',
  `cheovertime` varchar(50) default '0' COMMENT '超时',
  `cheimage` varchar(60) default NULL COMMENT '汽车图片',
  `chebiezu` mediumtext COMMENT '备注',
  PRIMARY KEY  (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

#
# Dumping data for table hotelzuche
#
INSERT INTO `hotelzuche` VALUES (1,'大众','0座','市内','个人出租','一汽公司','200.0','150.0','2006-09-30','0','null','出玩');


#
# Table structure for table planebook
#

CREATE TABLE `planebook` (
  `planebookid` int(11) NOT NULL auto_increment COMMENT '订票ID',
  `planebookname` varchar(50) NOT NULL default 'null' COMMENT '姓    名',
  `planebookidcard` varchar(18) NOT NULL default 'null' COMMENT '身份证号',