hoteldb.sql

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

# MySQL-Front 3.2  (Build 7.5)
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES 'gbk' */;


# Host: 127.0.0.1    Database: hoteldb
# ------------------------------------------------------
# Server version 4.1.11-nt

DROP DATABASE IF EXISTS `hoteldb`;
CREATE DATABASE `hoteldb` /*!40100 DEFAULT CHARACTER SET gbk */;
USE `hoteldb`;


#
# Table structure for table companyauthor
#

CREATE TABLE `companyauthor` (
  `ID` int(11) NOT NULL auto_increment COMMENT '酒店ID',
  `hotelauthorid` int(11) default '0' COMMENT '用户ID',
  `hotelname` varchar(30) NOT NULL default 'null' COMMENT '酒店名称',
  `hotelstar` varchar(20) default 'null' COMMENT '酒店星级',
  `hotelstartype` varchar(20) default 'null' COMMENT '酒店星级类别',
  `hotelpeople` varchar(20) default 'null' COMMENT '法人姓名',
  `hoteltel` varchar(15) default 'null' COMMENT '法人手机号',
  `hotelprovince` varchar(30) default 'null' COMMENT '酒店所在省份',
  `hotelcity` varchar(30) default 'null' COMMENT '酒店所在县市',
  `hotelborough` varchar(30) default 'null' COMMENT '酒店所在区',
  `hoteladdress` varchar(50) default 'null' COMMENT '酒店详细地址',
  `hotelpostcode` varchar(50) default 'null' COMMENT '酒店邮编',
  `hotelphone` varchar(30) NOT NULL default 'null' COMMENT '酒店联系电话',
  `hotelfax` varchar(30) NOT NULL default 'null' COMMENT '酒店传真',
  `remark` varchar(200) NOT NULL default 'null' COMMENT '酒店简介',
  `traffic` varchar(200) NOT NULL default 'null' COMMENT '酒店交通情况',
  `service` varchar(200) NOT NULL default 'null' COMMENT '酒店服务设施',
  `quanxian` varchar(20) default 'null' COMMENT '金牌银牌普通',
  PRIMARY KEY  (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

#
# Dumping data for table companyauthor
#
INSERT INTO `companyauthor` VALUES (1,4,'aaaa','四星级','挂','cccccc','324324324','aa','aa','aaaa','aa','aa','454453543554','3244324324','aa','aa','aa','金牌');
INSERT INTO `companyauthor` VALUES (2,14,'北京饭店','四星级','准','ghost','12345678977','null','null','null','北京','102458','01086235696','01086235696','1111','11111','11111','银牌');
INSERT INTO `companyauthor` VALUES (3,22,'asdf','一星级','准','fasdf','fsdaf','dasff','fsadf','fsdaf','fdsaf','119','null','null','null','null','null','普通');
INSERT INTO `companyauthor` VALUES (4,24,'dfsafdsf','一星级','准','dsf','fdsfdsf','fdsf','fdsf','fdsf','dsfds','dsfds','null','null','null','null','null','普通');
INSERT INTO `companyauthor` VALUES (5,24,'dfsafdsafdsaf','一星级','准','dsf','fdsfdsf','fdsf','fdsf','fdsf','dsfds','dsfds','null','null','null','null','null','普通');
INSERT INTO `companyauthor` VALUES (6,25,'aaaaaaaaaaaaaaaaa','一星级','准','aaaaaaaaaaaaaa','aaaaaaaaaaaaaa','aaaaaaaaa','aaaaaaaa','aaaaaaaaaaa','dsafdsf','fdsfasd','null','null','null','null','null','普通');
INSERT INTO `companyauthor` VALUES (7,26,'dsfdsafdsaf','一星级','准','fdsafdsfsdf','fdsfdsaf','null','null','null','dsfdsaf','119','null','null','null','null','null','普通');
INSERT INTO `companyauthor` VALUES (8,27,'fdsfdsf','一星级','准','fdsafdsaf','fdsfdsf','null','null','null','dsfdsfa','dsfdasf','null','null','null','null','null','普通');
INSERT INTO `companyauthor` VALUES (9,28,'dasfdasf','一星级','准','fdsafdsaf','fdsafdsaf','null','null','null','dsafdsaf','fdsafdsaf','null','null','null','null','null','普通');
INSERT INTO `companyauthor` VALUES (10,29,'fdsafdsaf','一星级','准','dsafdsaf','fdsafdsaf','null','null','null','fdsafsdaf','dfsafdsaf','null','null','null','null','null','普通');
INSERT INTO `companyauthor` VALUES (11,30,'fdsafdsafadsf','一星级','准','fdasfdsaf','fadsfsdaf','null','null','null','fdsafdsaf','fasdfdsaf','null','null','null','null','null','普通');
INSERT INTO `companyauthor` VALUES (12,31,'fdsafdsafdsaf','一星级','准','fadsfdsaf','fdasfdsaf','null','null','null','fdsaf','dasfdasf','null','null','null','null','null','普通');
INSERT INTO `companyauthor` VALUES (13,32,'kkkkkkkkkkkkkkkkkk','一星级','准','kkkkkkkkkkkkkkk','kkkkkkkkkk','null','null','null','kkkkkkkkkkkkkkk','kkkkkkkkk','null','null','null','null','null','普通');


#
# Table structure for table hotelauthor
#

CREATE TABLE `hotelauthor` (
  `ID` int(11) NOT NULL auto_increment COMMENT '用户ID',
  `username` varchar(30) NOT NULL default 'null' COMMENT '用户名',
  `password` varchar(30) NOT NULL default 'null' COMMENT '用户密码',
  `email` varchar(30) NOT NULL default 'null' COMMENT '电子邮件',
  `relname` varchar(30) NOT NULL default 'null' COMMENT '用户真实性名',
  `idcard` varchar(30) NOT NULL default 'null' COMMENT '身份证号',
  `sex` varchar(4) NOT NULL default 'null' COMMENT '性别',
  `job` varchar(30) NOT NULL default 'null' COMMENT '工作',
  `address` varchar(30) NOT NULL default 'null' COMMENT '地址',
  `phone` varchar(30) NOT NULL default 'null' COMMENT '联系电话',
  `postcode` varchar(20) NOT NULL default 'null' COMMENT '邮编',
  `integral` bigint(20) NOT NULL default '0' COMMENT '积分',
  `regtime` varchar(20) default 'null' COMMENT '注册时间',
  `type` varchar(20) default 'null' COMMENT '个人酒店旅行社管理员',
  PRIMARY KEY  (`ID`)
) ENGINE=InnoDB DEFAULT CHARSET=gbk;

#
# Dumping data for table hotelauthor
#
INSERT INTO `hotelauthor` VALUES (1,'lklkl','96E79218965EB72C','[e-mail]','kl','12321321321312','男','dsfdsf','sdfsfdsfdsf','d32424','32424243',0,'2006年09月26日','酒店');