`CIOTOTALRATE` decimal(14,2) NOT NULL, `CIOBEDRATE` decimal(14,2) default NULL, `CIOORDERID` varchar(32) NOT NULL, PRIMARY KEY USING BTREE (`CIOID`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `tb_checkinorder` VALUES
('402881e51a448696011a4489373e0001','esperamier',2,'散客','普通客人',NULL,'身份证','362422198611160012',NULL,'已结账','2008-06-01 21:15:00','2008-06-02 12:00:00','2008-06-01 22:30:37','现金',0,NULL,'FoGhost','男',320,0,'CIO00000001');
INSERT INTO `tb_checkinorder` VALUES
('402881e51a53efae011a53f77fc40001','esperamier',2,'散客','普通客人',NULL,'身份证','362422198611160012',NULL,'已结账','2008-06-04 22:24:00','2008-06-05 12:00:00','2008-06-04 22:26:09','现金',0,NULL,'FoGhost','男',350,0,'CIO00000001');
INSERT INTO `tb_checkinorder` VALUES
('402881e51a579a4b011a57d29ea50003','esperamier',2,'散客','普通客人',NULL,'身份证','362422198611160012',NULL,'已入住','2008-06-05 16:22:00','2008-06-06 12:00:00','2008-06-06 12:00:00','现金',0,NULL,'Admin','男',320,0,'CIO00000002');
INSERT INTO `tb_checkinorder` VALUES
('402881e5267907ec01267915e32e0004','刘明',2,'散客','普通客人',NULL,'身份证','123456789789123',NULL,'已入住','2010-01-29
15:53:00','2010-01-30 12:00:00','2010-01-30 12:00:00','现金',0,NULL,'Admin','男',260,0,'CIO00000009');
INSERT INTO `tb_checkinorder` VALUES
('402881e6254e53a001254e58d93e0001','庞永庆',2,'散客','普通客人',NULL,'身份证','1234567891234567',NULL,'已入住','2009-12-02 15:43:00','2009-12-03 12:00:00','2009-12-03 12:00:00','现金',0,NULL,'Admin','男',260,0,'CIO00000004');
INSERT INTO `tb_checkinorder` VALUES
('402881e6254e53a001254e5be9230004','庞永庆',2,'散客','普通客人',NULL,'身份证','12345678945465151',NULL,'已入住','2009-12-02 15:46:00','2009-12-03 12:00:00','2009-12-03 12:00:00','现金',0,NULL,'Admin','男',260,0,'CIO00000005');
INSERT INTO `tb_checkinorder` VALUES
('402881e6254e53a001254e64b91d0007','庞永庆',2,'散客','普通客人',NULL,'身份证','123456789123456',NULL,'已入住','2009-12-02 15:54:00','2009-12-03 12:00:00','2009-12-03 12:00:00','现金',0,NULL,'Admin','男',260,0,'CIO00000006');
INSERT INTO `tb_checkinorder` VALUES
('402881e625587aa7012559003f2d0003','刘明',2,'散客','普通客人',NULL,'身份证','123456789789456',NULL,'已结账','2009-12-04
15:55:00','2009-12-05 12:00:00','2009-12-06 18:08:47','现金',0,NULL,'Admin','男',260,0,'CIO00000007');
INSERT INTO `tb_checkinorder` VALUES
('402881e625587aa70125590883f60005','刘明',2,'散客','普通客人',NULL,'身份证','123456789789456',NULL,'已入住','2009-12-04
15:55:00','2009-12-05 12:00:00','2009-12-05 12:00:00','现金',0,NULL,'Admin','男',260,0,'CIO00000008');
INSERT INTO `tb_checkinorder` VALUES
('ff808081012a13dc01012a1aff7c0001','esperamier',2,'散客','普通客人',NULL,'身份证','362422198611160012',NULL,'已入住','2005-01-01 01:06:00','2005-01-02 12:00:00','2005-01-02 12:00:00','现金',0,NULL,'Admin','男',320,0,'CIO00000003'); #
# Table structure for table tb_guest #
DROP TABLE IF EXISTS `tb_guest`; CREATE TABLE `tb_guest` ( `GTID` varchar(32) NOT NULL, `GTNAME` varchar(20) NOT NULL, `GTTYPE` varchar(16) NOT NULL, `GTCARDCATALOG` varchar(16) NOT NULL,
`GTCARDID` varchar(32) NOT NULL, `GTCOUNTRY` varchar(32) default NULL, `GTADDRESS` varchar(100) default NULL, `GTZIP` varchar(10) default NULL, `GTCOMPANY` varchar(50) default NULL, `GTTELPHONE` varchar(16) default NULL, `GTMOBILE` varchar(16) default NULL, `GTGENDER` varchar(4) NOT NULL, `GTEMAIL` varchar(32) default NULL,
`GTCREATETIME` timestamp NOT NULL default CURRENT_TIMESTAMP, PRIMARY KEY (`GTID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `tb_guest` VALUES ('402881e6254e53a001254e63196c0006','庞小庆','普通客人','身份证','123456789123456','中国','','','','','','男','','2009-12-02 15:55:35');
INSERT INTO `tb_guest` VALUES ('402881e625587aa7012558e59ffa0001','刘明','普通客人','身份证','123456789789456','中国','北京市海淀区上地西里XXX栋X单元XXX室','100000','中国石化','456789123','13778945612','男','test@qq.com','2009-12-04 16:54:21');
INSERT INTO `tb_guest` VALUES ('402881e6256404d20125641b17560001','李立明','普通客人','身份证','456789123456789','中国','中国上海','','','','','男','','2009-12-06 21:08:34'); #
# Table structure for table tb_guesthistory #
DROP TABLE IF EXISTS `tb_guesthistory`; CREATE TABLE `tb_guesthistory` ( `GHID` varchar(32) NOT NULL,
`GHBALANCEMENTID` varchar(32) NOT NULL, `GHREMARK` varchar(100) NOT NULL, `GHGUESTID` varchar(45) NOT NULL, `GHGUESTNAME` varchar(32) NOT NULL, PRIMARY KEY (`GHID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `tb_guesthistory` VALUES
('402881e51a448696011a4489790a0004','402881e51a448696011a4489783f0003','
controll
','402881e51a39c232011a39da4d3e0005','esperamier');
INSERT INTO `tb_guesthistory` VALUES
('402881e51a53efae011a53f874e20005','402881e51a53efae011a53f874550004','fdsafdsa','402881e51a39c232011a39da4d3e0005','esperamier'); INSERT INTO `tb_guesthistory` VALUES
('402881e625636b70012563767f580002','402881e625636b70012563767c6c0001','','402881e625587aa7012558e59ffa0001','刘明'); #
# Table structure for table tb_operator #
DROP TABLE IF EXISTS `tb_operator`; CREATE TABLE `tb_operator` (
`OPUSERNAME` varchar(20) NOT NULL, `OPPASSWORD` varchar(32) NOT NULL, `OPPRIVILEGE` int(10) unsigned NOT NULL, `OPADDRESS` varchar(100) default NULL, `OPNAME` varchar(20) NOT NULL,
`OPTELEPHONE` varchar(16) default NULL, `OPMOBILE` varchar(16) default NULL, `OPZIP` varchar(10) default NULL,
`OPCREATETIME` timestamp NOT NULL default CURRENT_TIMESTAMP, PRIMARY KEY (`OPUSERNAME`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `tb_operator` VALUES
('admin','admin',255,NULL,'NeoStudio',NULL,NULL,NULL,'2008-05-05 16:32:22');
INSERT INTO `tb_operator` VALUES
('FoGhost','330022',0,NULL,'Liang',NULL,NULL,NULL,'2008-04-20 16:32:22');
INSERT INTO `tb_operator` VALUES
('user','',0,'','','0','0','0','2010-01-29 15:52:59'); #
# Table structure for table tb_reservitem #
DROP TABLE IF EXISTS `tb_reservitem`; CREATE TABLE `tb_reservitem` (