hoteldb.sql

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

INSERT INTO `hotelauthor` VALUES (2,'fgfgfg','9CAFEEF08DB2DD47','[e-mail]','dddd','d34343434','男','324','dsfdf','3432434','sdfdsf',0,'2006年09月26日','酒店');
INSERT INTO `hotelauthor` VALUES (3,'joywang','53C91501CF43E913','[e-mail]','joy','11101111111111','男','ddd','sdfdsfdf','324324','324423',0,'2006年09月26日','酒店');
INSERT INTO `hotelauthor` VALUES (4,'ha','E10ADC3949BA59AB','[e-mail]','joy','110102199020110022','男','ddd','sdfdsfdf','324324','324423',0,'2006年09月26日','酒店');
INSERT INTO `hotelauthor` VALUES (6,'liudehua','E10ADC3949BA59AB','null','null','null','null','null','null','null','null',0,'null','admin');
INSERT INTO `hotelauthor` VALUES (7,'aaaaaa','E10ADC3949BA59AB','[e-mail]','aaaaaaaaaaaa','110102199020110022','男','null','null','null','null',0,'2006年09月26日','酒店');
INSERT INTO `hotelauthor` VALUES (8,'yuyu','5B1B68A9ABF4D2CD','[e-mail]','rtrt','333333333','男','rr','rtretetret','234324324324','34434324',0,'2006年09月26日','旅游');
INSERT INTO `hotelauthor` VALUES (9,'null','D41D8CD98F00B204','null','null','null','男','null','null','null','null',0,'2006年09月26日','null');
INSERT INTO `hotelauthor` VALUES (10,'asasas','E3CEB5881A0A1FDA','[e-mail]','ssdf','2323434324324324','男','ee','dsfdsffdssdfsfsdfdsf','234332','32233323',0,'2006年09月26日','旅游');
INSERT INTO `hotelauthor` VALUES (11,'ioiu','6D2FE1D6F0978169','[e-mail]','gfh','56546546546','男','456','ffgghgfhgfhfh','5656546','546546',0,'2006年09月26日','酒店');
INSERT INTO `hotelauthor` VALUES (12,'zhangsan','E10ADC3949BA59AB','[e-mail]','aaaaaaaaa','11111','男','null','null','null','null',0,'2006年09月26日','个人');
INSERT INTO `hotelauthor` VALUES (13,'yyyyyyyy','5A05211EC33A102C','[e-mail]','joy','1212121212','男','aaa','aaaaaaa','23231','2323',0,'2006年09月26日','个人');
INSERT INTO `hotelauthor` VALUES (14,'ghost','E10ADC3949BA59AB','[e-mail]','ghost','123456789','男','null','北京','010 86235696','102587',0,'2006年09月26日','酒店');
INSERT INTO `hotelauthor` VALUES (15,'opopop','E882B72BCCFC2AD5','[e-mail]','dfgdfg','23424324234324234','男','reewrt','rtrgregrgr','234324234234','34342324',0,'2006年09月27日','旅游');
INSERT INTO `hotelauthor` VALUES (16,'cvcv','4693FBB215B8CA15','[e-mail]','dfgdfg','23424324234324234','男','reewrt','rtrgregrgr','234324234234','34342324',0,'2006年09月27日','旅游');
INSERT INTO `hotelauthor` VALUES (17,'cctv','96E79218965EB72C','[e-mail]','dfgdfg','23424324234324234','男','reewrt','rtrgregrgr','234324234234','34342324',0,'2006年09月27日','旅游');
INSERT INTO `hotelauthor` VALUES (18,'ssssssssss','AF15D5FDACD5FDFE','[e-mail]','sdfsdf','3424234324','男','sdfd','sdfsdfsfd','234324','23434',0,'2006年09月27日','酒店');
INSERT INTO `hotelauthor` VALUES (19,'rtrtrtrt','BCC720F2981D1A68','[e-mail]','dsfdsf','342324324324','男','xvxcvcx','xvcxvcxvxvxcvxc','2343234','werere',0,'2006年09月27日','旅游');
INSERT INTO `hotelauthor` VALUES (20,'8989','52C69E3A57331081','[e-mail]','2323','232323232332','男','dfddfd','dfdf','2332323','32323',0,'2006年09月27日','旅游');
INSERT INTO `hotelauthor` VALUES (21,'eeeq','96E79218965EB72C','[e-mail]','111111','123456789012345678','女','111','11111111','111111','111111',0,'2006年09月27日','旅游');
INSERT INTO `hotelauthor` VALUES (22,'cvs','E10ADC3949BA59AB','[e-mail]','aaaa','110102199020110022','男','aaaa','aaa','110110110','100031',0,'2006年09月27日','酒店');
INSERT INTO `hotelauthor` VALUES (23,'xxcxc','DAD3A37AA9D50688','[e-mail]','sdfdsf','3324323','男','sefds','sdfsdfdsf','23432432','2324232',0,'2006年09月27日','旅游');
INSERT INTO `hotelauthor` VALUES (24,'dsafdsafsdf','E10ADC3949BA59AB','[e-mail]','dsfsd','dsf','男','null','null','null','null',0,'2006年09月27日','酒店');
INSERT INTO `hotelauthor` VALUES (25,'dfdsfdsfdsfdsfadsf','E10ADC3949BA59AB','[e-mail]','fdsfdsafdsf','110102199020110022','男','null','null','null','null',0,'2006年09月27日','酒店');
INSERT INTO `hotelauthor` VALUES (26,'dasfdsafdsafdsaf','E10ADC3949BA59AB','[e-mail]','aaaa','110102199020110022','男','null','null','null','null',0,'2006年09月27日','酒店');
INSERT INTO `hotelauthor` VALUES (27,'rtfgf','E10ADC3949BA59AB','[e-mail]','dsfdsfdsaf','110102199020110022','男','null','null','null','null',0,'2006年09月27日','酒店');
INSERT INTO `hotelauthor` VALUES (28,'fdsafdsafdsfdsfdsaf','E10ADC3949BA59AB','[e-mail]','fdsafdsaf','null','男','null','null','null','null',0,'2006年09月27日','酒店');
INSERT INTO `hotelauthor` VALUES (29,'fdsafsdafdsaf','E10ADC3949BA59AB','[e-mail]','dfdsafdsaf','110102199020110022','男','null','null','null','null',0,'2006年09月27日','酒店');
INSERT INTO `hotelauthor` VALUES (30,'fdsafdsafdsaf','E10ADC3949BA59AB','[e-mail]','fdsafdsaf','110102199020110022','男','null','null','null','null',0,'2006年09月27日','酒店');
INSERT INTO `hotelauthor` VALUES (31,'ssssssssssssssssss','E10ADC3949BA59AB','[e-mail]','dfasfdsaf','dsafdsaf','男','null','null','null','null',0,'2006年09月27日','酒店');
INSERT INTO `hotelauthor` VALUES (32,'hhhhhhhhhhhhhhhhhhhh','E10ADC3949BA59AB','[e-mail]','aaaa','110102199020110022','男','null','null','null','null',0,'2006年09月27日','酒店');
INSERT INTO `hotelauthor` VALUES (33,'1111','96E79218965EB72C','[e-mail]','2222','1111','男','121','null','null','null',0,'2006年09月28日','个人');
INSERT INTO `hotelauthor` VALUES (34,'666','F379EAF3C831B04D','[e-mail]','6666','666666','男','666','6666','666','6666',0,'2006年09月28日','其它类');
INSERT INTO `hotelauthor` VALUES (35,'666666','F379EAF3C831B04D','[e-mail]','6666','666666','男','666','6666','666','6666',0,'2006年09月28日','旅游');
INSERT INTO `hotelauthor` VALUES (36,'66666666661111','96E79218965EB72C','[e-mail]','6666','666666','男','666','6666','666','6666',0,'2006年09月28日','旅游');
INSERT INTO `hotelauthor` VALUES (37,'888888','21218CCA77804D2B','[e-mail]','888888','888888','男','888888','888888','888888','888888',0,'2006年09月28日','旅游');
INSERT INTO `hotelauthor` VALUES (38,'eeeq567','8C33DA8906A3BD81','[e-mail]','eeeq','222222','男','2222','2222','22222','2222',0,'2006年10月08日','旅游');


#
# Table structure for table hotelpic
#

CREATE TABLE `hotelpic` (
  `Id` int(11) NOT NULL auto_increment,
  `panorama` varchar(150) default NULL COMMENT '酒店全景图',
  `anteroom` varchar(150) default NULL COMMENT '酒店前厅图',
  `guestroom` varchar(150) default NULL COMMENT '酒店客房图',
  `hotelid` int(11) NOT NULL default '0' COMMENT '酒店ID值',
  PRIMARY KEY  (`Id`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk COMMENT='酒店图片表';

#
# Dumping data for table hotelpic
#
INSERT INTO `hotelpic` VALUES (1,'null','null','null',0);
INSERT INTO `hotelpic` VALUES (2,'null','null','null',0);
INSERT INTO `hotelpic` VALUES (3,'null','null','null',0);
INSERT INTO `hotelpic` VALUES (4,'null','null','null',0);
INSERT INTO `hotelpic` VALUES (5,'null','null','null',0);
INSERT INTO `hotelpic` VALUES (6,'null','null','null',0);
INSERT INTO `hotelpic` VALUES (7,'null','null','null',0);
INSERT INTO `hotelpic` VALUES (8,'null','null','null',13);
INSERT INTO `hotelpic` VALUES (9,'../upload_picture/2090hotelpic1.jpg','../upload_picture/2090hotelpic2.jpg','../upload_picture/2090hotelpic3.jpg',1);
INSERT INTO `hotelpic` VALUES (10,'../upload_picture/2116hotelpic1.jpg','../upload_picture/2116hotelpic2.jpg','../upload_picture/2116hotelpic3.jpg',1);
INSERT INTO `hotelpic` VALUES (11,'../upload_picture/2100hotelpic1.jpg','../upload_picture/2100hotelpic2.jpg','../upload_picture/2100hotelpic3.jpg',1);
INSERT INTO `hotelpic` VALUES (12,'null','null','null',2);


#
# Table structure for table hotelplane
#

CREATE TABLE `hotelplane` (
  `hotelplaneid` int(11) NOT NULL auto_increment COMMENT '机票ID',
  `hotelplanename` varchar(30) NOT NULL default '未知' COMMENT '航空公司',
  `hotelplanetype` varchar(20) NOT NULL default '未知' COMMENT '航段类型',
  `hotelplaneouttime` varchar(20) NOT NULL default '未知' COMMENT '出发日期',
  `hotelplaneintime` varchar(20) default '未知' COMMENT '返程日期',
  `hotelplaneoutcity` varchar(30) NOT NULL default '未知' COMMENT '出发城市',
  `hotelplaneincity` varchar(30) NOT NULL default '未知' COMMENT '到达城市',
  `hotelplaneseattype` varchar(16) NOT NULL default '未知' COMMENT '乘舱类型',
  `hotelplaneclass` varchar(10) NOT NULL default '未知' COMMENT '航班类型',
  `hotelplanetrave` varchar(10) NOT NULL default '未知' COMMENT '单程/往返',
  `hotelplanePM` varchar(20) default NULL COMMENT '上/下午',
  `hotelplanesales` varchar(10) default '0' COMMENT '折扣',
  `hotelplaneprice` varchar(20) default NULL COMMENT '价格',