旅游网设计代码+及时聊天功能+数据库+文档

/* Navicat MySQL Data Transfer Source Server : sms Source Server Version : 50155 Source Host : localhost:3306 Source Database : tourism Target Server Type : MYSQL Target Server Version : 50155 File Encoding : 65001 Date: 2012-05-11 11:48:54 */ SET FOREIGN_KEY_CHECKS=0; -- ---------------------------- -- Table structure for `info_car` -- ---------------------------- DROP TABLE IF EXISTS `info_car`; CREATE TABLE `info_car` ( `sid` int(11) NOT NULL AUTO_INCREMENT, `information` text COMMENT '介绍', `pic` varchar(50) DEFAULT NULL, `createtime` varchar(11) DEFAULT NULL, `name` varchar(20) NOT NULL COMMENT '姓名', PRIMARY KEY (`sid`) ) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of info_car -- ---------------------------- INSERT INTO `info_car` VALUES ('1', '13657227016', 'm_4f80fe7072540.jpg', '1333851791', ''); INSERT INTO `info_car` VALUES ('2', '13657227016', 'm_4f8103cc89024.jpg', '1333855155', ''); INSERT INTO `info_car` VALUES ('3', 'dfgdd', null, '1333855651', ''); INSERT INTO `info_car` VALUES ('4', 'dfgdd', null, '1333855651', ''); INSERT INTO `info_car` VALUES ('6', '长沙荣天租车网是一家专业的汽车租赁公司。公司提供国宾车队、世界名车、商务车、轿车、面包车、各类型豪华大中巴车，配套齐全，承接大型会议、贵宾接待、明星机场接送、政府、学校、企业单位、个人自驾、旅游等，长', 'm_4f83d9c458d71.png', '1334040808', '长沙荣天租车'); -- ---------------------------- -- Table structure for `info_car_pic` -- ---------------------------- DROP TABLE IF EXISTS `info_car_pic`; CREATE TABLE `info_car_pic` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `belong` int(10) DEFAULT NULL COMMENT '所属酒店', `name` varchar(30) DEFAULT NULL COMMENT '图片名称', `imagebig` text, `image` text COMMENT '图片', `description` varchar(30) DEFAULT NULL COMMENT '图片描述', `time` int(11) DEFAULT NULL, `status` int(11) DEFAULT '0' COMMENT '0 未标记 1已经标记', PRIMARY KEY (`id`), KEY `belong` (`belong`) ) ENGINE=MyISAM AUTO_INCREMENT=272 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of info_car_pic -- ---------------------------- INSERT INTO `info_car_pic` VALUES ('260', '1', '大法官', 'm_4f816d7bc2640.png', 's_4f81015f291b0.jpg', '地方', '1333854559', '0'); INSERT INTO `info_car_pic` VALUES ('261', '2', '形成v', 'm_4f816d7bc2640.png', 's_4f8103cc89024.jpg', '形成v', '1333855180', '0'); INSERT INTO `info_car_pic` VALUES ('271', '6', '45', 'm_4f83d9cf08bc7.png', 's_4f83d9cf08bc7.png', '45', '1334041039', '0'); INSERT INTO `info_car_pic` VALUES ('269', '6', '1', 'm_4f83d9b9d340e.png', 's_4f83d9b9d340e.png', '1', '1334041017', '0'); INSERT INTO `info_car_pic` VALUES ('270', '6', '23', 'm_4f83d9c458d71.png', 's_4f83d9c458d71.png', '23', '1334041028', '1'); INSERT INTO `info_car_pic` VALUES ('266', '3', '呆呆', 'm_4f816d7bc2640.png', 's_4f816d7bc2640.png', '呆呆', '1333882235', '0'); INSERT INTO `info_car_pic` VALUES ('267', '3', '士大夫', 'm_4f816d7bc2640.png', 's_4f816decedd20.png', '士大夫', '1333882349', '0'); INSERT INTO `info_car_pic` VALUES ('268', '3', '大师傅', 'm_4f816d7bc2640.png', 's_4f816e8f7e96b.png', '士大夫', '1333882511', '0'); -- ---------------------------- -- Table structure for `info_car_product` -- ---------------------------- DROP TABLE IF EXISTS `info_car_product`; CREATE TABLE `info_car_product` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(50) DEFAULT NULL COMMENT '车名', `cartype` int(1) DEFAULT NULL COMMENT '1 小轿车，2小巴，3中巴，4大巴', `type` int(1) DEFAULT '1' COMMENT '1新 2旧', `introduct` varchar(150) DEFAULT NULL COMMENT '介绍', `pic` varchar(150) DEFAULT NULL COMMENT '照片', `trade` varchar(20) DEFAULT NULL COMMENT '同行价', `market` varchar(20) DEFAULT NULL COMMENT '市场价', `createtime` varchar(11) DEFAULT NULL COMMENT '创建时间', `status` int(1) DEFAULT '1', `supplierid` varchar(11) DEFAULT NULL, `publish` varchar(11) DEFAULT NULL, `imagebig` varchar(150) DEFAULT NULL, `table` varchar(10) DEFAULT 'hotel', `recommand` int(1) DEFAULT '0' COMMENT '0不推荐 1推荐', PRIMARY KEY (`id`) ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of info_car_product -- ---------------------------- INSERT INTO `info_car_product` VALUES ('7', '骏捷 ', '1', '1', '长沙商务租车 ', 's_4f83da099d5a3.png', '3332', '232323', '1334041097', '1', '99', '1', 'm_4f83da099d5a3.png', 'hotel', '0'); INSERT INTO `info_car_product` VALUES ('8', ' 奔驰MB100(12座)', '4', '1', ' 奔驰MB100(12座)', 's_4f83da2dc6ecd.png', '3223', '2323', '1334041133', '1', '99', '1', 'm_4f83da2dc6ecd.png', 'hotel', '1'); INSERT INTO `info_car_product` VALUES ('9', '考斯特 ', '3', '1', '考斯特 ', 's_4f83da4682669.png', '3443', '3434', '1334041158', '1', '99', '1', 'm_4f83da4682669.png', 'hotel', '0'); -- ---------------------------- -- Table structure for `info_cicerone` -- ---------------------------- DROP TABLE IF EXISTS `info_cicerone`; CREATE TABLE `info_cicerone` ( `sid` int(11) NOT NULL AUTO_INCREMENT, `auth` varchar(20) DEFAULT NULL COMMENT '导游证号', `level` int(1) DEFAULT NULL COMMENT '等级', `createtime` varchar(11) DEFAULT NULL, `name` varchar(50) DEFAULT NULL, `pic` varchar(150) DEFAULT NULL, PRIMARY KEY (`sid`) ) ENGINE=InnoDB AUTO_INCREMENT=15 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of info_cicerone -- ---------------------------- INSERT INTO `info_cicerone` VALUES ('14', '45623512t0256yu', '1', '1334283619', '北京导游员', 'm_4f87d4f15cf37.jpg'); -- ---------------------------- -- Table structure for `info_cicerone_pic` -- ---------------------------- DROP TABLE IF EXISTS `info_cicerone_pic`; CREATE TABLE `info_cicerone_pic` ( `id` bigint(20) NOT NULL AUTO_INCREMENT, `belong` int(10) DEFAULT NULL COMMENT '所属酒店', `name` varchar(30) DEFAULT NULL COMMENT '图片名称', `imagebig` text, `image` text COMMENT '图片', `description` varchar(30) DEFAULT NULL COMMENT '图片描述', `time` int(11) DEFAULT NULL, `status` int(11) DEFAULT '0' COMMENT '0 未标记 1已经标记', PRIMARY KEY (`id`), KEY `belong` (`belong`) ) ENGINE=MyISAM AUTO_INCREMENT=283 DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of info_cicerone_pic -- ---------------------------- INSERT INTO `info_cicerone_pic` VALUES ('282', '14', '6', 'm_4f87d4f15cf37.jpg', 's_4f87d4f15cf37.jpg', '9', '1334301937', '1'); -- ---------------------------- -- Table structure for `info_follower` -- ---------------------------- DROP TABLE IF EXISTS `info_follower`; CREATE TABLE `info_follower` ( `follower` int(11) NOT NULL DEFAULT '0' COMMENT '关注者', `following` int(11) DEFAULT NULL COMMENT '被专注', `groupid` int(11) DEFAULT '0', KEY `group` (`groupid`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- ---------------------------- -- Records of info_follower -- ---------------------------- INSERT INTO `info_follower` VALUES ('75', '95', '1'); INSERT INTO `info_follower` VALUES ('75', '93', '1'); INSERT INTO `info_follower` VALUES ('75', '109', '1'); INSERT INTO `info_follower` VALUES ('75', '98', '1'); INSERT INTO `info_follower` VALUES ('75', '101', '1'); INSERT INTO `info_follower` VALUES ('75', '99', '2'); INSERT INTO `info_follower` VALUES ('75', '102', '1'); INSERT INTO `info_follower` VALUES ('75', '108', '1'); INSERT INTO `info_follower` VALUES ('75', '110', '2'); INSERT INTO `info_follower` VALUES ('75', '112', '2'); INSERT INTO `info_follower` VALUES ('139', '109', '1'); INSERT INTO `info_follower` VALUES ('139', '99', '2'); INSERT INTO `inf