mysql.sql

机械工业出版社的《jsp2.0动态网站开发实例指南》的源代码

DROP TABLE IF EXISTS hotel_room;
CREATE TABLE hotel_room (
  roomID mediumint(8) unsigned NOT NULL auto_increment,
  roomType int(4) NOT NULL default '',
  hoteID int(4) NOT NULL default '',
  hotelName varchar(20) NOT NULL default '',
  roomBuilderName varchar(20) NOT NULL default '',
  roomFloorNum int(3) NOT NULL default '',
  roomRoomNum varchar(10) NOT NULL default '',
  roomBedNum int(2) NOT NULL default '',
  roomPrice float(4) NOT NULL default '100',
  roomStatus tinyint(1) NOT NULL default '0',
  roomOrderPrice float(4) NOT NULL default '50',
  roomImage varchar(30) NOT NULL default '',
  roomDescription varchar(100) NOT NULL default '',
  roomOfferBreakfast tinyint(1) NOT NULL default '0',
  roomIsAvaliable tinyint(1) NOT NULL default '0',
  roomHasPhone tinyint(1) NOT NULL default '1',
  roomOrderList varchar(255) NOT NULL default '',
  PRIMARY KEY  (roomID)
);


DROP TABLE IF EXISTS hotel_user;
CREATE TABLE hotel_user (
	userID mediumint(8) unsigned NOT NULL auto_increment,
	userName varchar(15) NOT NULL default '',
  	password varchar(32) NOT NULL default '',
	userGroup int(2) NOT NULL default '', 
	userIDinGroup int(4) NOT NULL default '',
	type int(4) NOT NULL default '',
	point int(10) NOT NULL default '0',
	vip tinyint(1) NOT NULL default '0',
	lastLoginIP varchar(15) NOT NULL default '',
	lastLoginTime bigint(32) NOT NULL default '',
	address varchar(75) NOT NULL default '',
	fromCity varchar(20) NOT NULL default '',
	fromCountry varchar(20) NOT NULL default '',
	email varchar(60) NOT NULL default '',
	mobile varchar(11) NOT NULL default '',
	phone varchar(25) NOT NULL default '',
	realName varchar(20) NOT NULL default '',
	birthday bigint(32) NOT NULL default '',
	sex tinyint(1) NOT NULL default '0',
	description varchar(200) NOT NULL default '',
	habit varchar(100) NOT NULL default '',
	ICQ int(15) NOT NULL default '',
	fax varchar(25) NOT NULL default '',
	PRIMARY KEY  (userName), KEY(userID)
);

DROP TABLE IF EXISTS hotel_order;
CREATE TABLE hotel_order(
	orderID int(10) unsigned NOT NULL auto_increment,
	roomType int(4) NOT NULL default '0',
	startTime bigint(32) NOT NULL default '0',
	endTime bigint(32) NOT NULL default '0',
	orderTime bigint(32) NOT NULL default '0',
	roomCount smallint(2) NOT NULL default '0',
	userID int(8) NOT NULL default '0',
	userName varchar(15) NOT NULL default '',
	needPay int(8) NOT NULL default '0',
	nowPay int(8) NOT NULL default '0',
	status int(4) NOT NULL default '0',
	roomIDs varchar(255) NOT NULL default '0',
	PRIMARY KEY  (orderID)
);


DROP TABLE IF EXISTS hotel_op_log;
CREATE TABLE hotel_op_log(
	logID bigint(16) unsigned NOT NULL auto_increment,
	opType int(4) NOT NULL default '0',
	opTime bigint(32) NOT NULL default '0',
	opUserID int(8) NOT NULL default '0',
	operName varchar(15) NOT NULL default '',
	decription varchar(255) NOT NULL default '',
	PRIMARY KEY  (logID)
);

INSERT INTO hotel_user VALUES( NULL,'op','op','1','-1','0','0','0','null','1113335564452','','','China','','','','null','1113335564452','0','null','null','null','null');
INSERT INTO hotel_user VALUES( NULL,'admin','admin','2','-1','0','0','0','null','1113335564452','','','China','','','','null','1113335564452','0','null','null','null','null');
INSERT INTO hotel_user VALUES( NULL,'user','user','0','-1','0','0','0','null','1113335564452','','','China','','','','null','1113335564452','0','null','null','null','null');