hoteldb.sql

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

  `planebooksex` varchar(2) default NULL COMMENT '性　　别',
  `planebookaddress` varchar(100) NOT NULL default 'null' COMMENT '通讯地址',
  `planebookcode` varchar(6) NOT NULL default 'null' COMMENT '邮　　编',
  `planebooktel` varchar(15) NOT NULL default 'null' COMMENT '联系电话',
  `planebookphone` varchar(15) NOT NULL default 'null' COMMENT '手    机',
  `planebooktype` varchar(6) NOT NULL default 'null' COMMENT '航班类型',
  `planebooktravel` varchar(6) NOT NULL default 'null' COMMENT '单程/往返',
  `planebookseat` varchar(8) NOT NULL default 'null' COMMENT '乘舱类型',
  `planebooknumadult` int(11) NOT NULL default '0' COMMENT '机票数量成人',
  `planebooknumchild` int(11) default '0' COMMENT '机票数量儿童',
  `planebookprice` float NOT NULL default '0' COMMENT '机票价格',
  `planebookdate` varchar(20) NOT NULL default 'null' COMMENT '出发时间',
  `planebookindate` varchar(20) default '无' COMMENT '返回时间',
  `planeyes` int(11) NOT NULL default '0' COMMENT '处理与未处理',
  PRIMARY KEY  (`planebookid`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

#
# Dumping data for table planebook
#
INSERT INTO `planebook` VALUES (1,'eeee','eeee','男','qeqeqe','qeqeqe','qeqeqe','qeqeqeq','直达','往返','头等舱',1,1,0,'2006-09-21','2006-09-21',1);
INSERT INTO `planebook` VALUES (2,'456456','456456','男','456456','456456','456456','456456','直达','单程','头等舱',456,456,0,'4564','4564',1);


#
# Table structure for table planein
#

CREATE TABLE `planein` (
  `planeinid` int(11) NOT NULL auto_increment COMMENT '国内特价机票',
  `planeintravel` varchar(30) NOT NULL default 'null' COMMENT '行程',
  `planename` varchar(100) NOT NULL default 'null' COMMENT '航班',
  `planesales` varchar(16) NOT NULL default 'null' COMMENT '折扣',
  `planeseat1` varchar(16) default NULL COMMENT '经济舱',
  `planeseat2` varchar(16) default NULL COMMENT '商务舱',
  `planeseat3` varchar(16) default NULL COMMENT '头等舱',
  `planetime` varchar(16) NOT NULL default 'null' COMMENT '飞行时间',
  PRIMARY KEY  (`planeinid`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

#
# Dumping data for table planein
#
INSERT INTO `planein` VALUES (1,'北京-上海','全部','9','1888','3000','6000','12');


#
# Table structure for table supply
#

CREATE TABLE `supply` (
  `supply_id` int(11) NOT NULL auto_increment COMMENT '供求ID',
  `supply_title` varchar(50) NOT NULL default 'null' COMMENT '供求标题',
  `supply_type` varchar(20) NOT NULL default 'null' COMMENT '供/求',
  `supply_class` varchar(20) NOT NULL default 'null' COMMENT '供求类型',
  `supply_text` text NOT NULL COMMENT '供求内容',
  `supply_tel` varchar(100) NOT NULL default 'null' COMMENT '联系电话',
  `supply_date` varchar(20) NOT NULL default 'null' COMMENT '发布时间',
  `user_id` int(11) NOT NULL default '0' COMMENT '用户ID',
  PRIMARY KEY  (`supply_id`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

#
# Dumping data for table supply
#
INSERT INTO `supply` VALUES (1,'华人携月饼入美频遭抽检查扣 或上美海关黑名单','供','酒店供求','<P>华人携月饼入美频遭抽检查扣 或上美海关黑名单华人携月饼入美频遭抽检查扣 或上美海关黑名单华人携月饼入美频遭抽检查扣 或上美海关黑名单</P>\r\n<P>华人携月饼入美频遭抽检查扣 或上美海关黑名单</P>','华人携月饼入美频遭抽检查扣 或上美海关黑名单华人携月饼入美频遭抽检查扣 或上美海关黑名单','2006-09-27 11:39:26',14);
INSERT INTO `supply` VALUES (2,'aaaaaaa','供','酒店供求','aaaaaaaaaa','aaaa','2006-09-29',4);
INSERT INTO `supply` VALUES (3,'sssssssssssssssss','供','酒店供求','sssssssssssssss','sssssss','2006-09-29 14:23:33',14);
INSERT INTO `supply` VALUES (4,'dafsdaf','求','酒店供求','fdsaf','fdsaf','2006-10-08',4);
INSERT INTO `supply` VALUES (5,'三言堂：手机实名制 本末倒置的“乌托邦”','供','酒店供求','<P><SPAN class=ed1 id=strNewsTitle name=\"strNewsTitle\"><STRONG><FONT color=#e61a6b size=5>三言堂：手机实名制 本末倒置的“乌托邦”</FONT></STRONG></SPAN></P>\r\n<P><SPAN class=ed1 name=\"strNewsTitle\"><SPAN class=ed1 id=strNewsTitle name=\"strNewsTitle\"><STRONG><FONT color=#e61a6b size=5>三言堂：手机实名制 本末倒置的“乌托邦”</FONT></STRONG></SPAN></SPAN></P>','11111111','2006-10-10',14);
INSERT INTO `supply` VALUES (6,'aaaa','供','旅游供求','aaaaa','aaaaaaa','2006-10-12',14);
INSERT INTO `supply` VALUES (7,'aaaa','供','旅游供求','aaaaa','aaaaaaa','2006-10-12',14);
INSERT INTO `supply` VALUES (8,'aaaa','供','旅游供求','aaaaa','aaaaaaa','2006-10-12',14);
INSERT INTO `supply` VALUES (9,'aaaa','供','旅游供求','aaaaa','aaaaaaa','2006-10-12',14);
INSERT INTO `supply` VALUES (10,'aaaa','供','旅游供求','aaaaa','aaaaaaa','2006-10-12',14);
INSERT INTO `supply` VALUES (11,'aaaa','供','旅游供求','aaaaa','aaaaaaa','2006-10-12',14);
INSERT INTO `supply` VALUES (12,'aaaa','供','旅游供求','aaaaa','aaaaaaa','2006-10-211 14:23:33',14);
INSERT INTO `supply` VALUES (13,'aaaa','供','旅游供求','aaaaa','aaaaaaa','2006-10-211 14:23:33',14);
INSERT INTO `supply` VALUES (14,'aaaa','供','旅游供求','aaaaa','aaaaaaa','2006-10-211 14:23:33',14);
INSERT INTO `supply` VALUES (15,'aaaa','供','旅游供求','aaaaa','aaaaaaa','2006-10-211 14:23:33',14);
INSERT INTO `supply` VALUES (16,'aaaa','供','旅游供求','aaaaa','aaaaaaa','2006-10-211 14:23:33',14);
INSERT INTO `supply` VALUES (17,'aaaa','供','旅游供求','aaaaa','aaaaaaa','2006-10-211 14:23:33',14);
INSERT INTO `supply` VALUES (18,'aaaa','供','旅游供求','aaaaa','aaaaaaa','2006-10-211 14:23:33',14);
INSERT INTO `supply` VALUES (19,'aaaa','供','旅游供求','aaaaa','aaaaaaa','2006-10-211 14:23:33',14);
INSERT INTO `supply` VALUES (20,'bbbb','求','旅游供求','aaaaa','aaaaaaa','2006-10-211 14:23:33',14);
INSERT INTO `supply` VALUES (21,'bbbb','求','旅游供求','aaaaa','aaaaaaa','2006-10-211 14:23:33',14);