# Server version 5.0.67-community-nt #
# Table structure for table tb_balancement #
DROP TABLE IF EXISTS `tb_balancement`; CREATE TABLE `tb_balancement` ( `BMID` varchar(32) NOT NULL,
`BMCHECKINORDERID` varchar(32) NOT NULL, `BMGUESTID` varchar(32) default NULL, `BMTYPE` varchar(16) NOT NULL, `BMTOTALRATE` decimal(14,2) NOT NULL, `BMPAIDMONEY` decimal(14,2) NOT NULL, `BMRECEIVMONEY` decimal(14,2) NOT NULL,
`BMCREATETIME` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`BMOPERATOR` varchar(20) NOT NULL, `BMPAYMENTMODEL` varchar(16) NOT NULL, `BMREMARK` varchar(100) default NULL, PRIMARY KEY (`BMID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `tb_balancement` VALUES
('402881e51a448696011a4489783f0003','402881e51a448696011a4489373e0001','402881e51a39c232011a39da4d3e0005','结单',320,1000,200,'2008-06-01
22:30:37','admin','现金','remark');
INSERT INTO `tb_balancement` VALUES
('402881e51a53efae011a53f874550004','402881e51a53efae011a53f77fc40001','402881e51a39c232011a39da4d3e0005','结单',350,0,0,'2008-06-04 22:26:09','admin','现金','fdsafdsa');
INSERT INTO `tb_balancement` VALUES
('402881e625636b70012563767c6c0001','402881e625587aa7012559003f2d0003','402881e625587aa7012558e59ffa0001','结单',260,0,0,'2009-12-06 18:08:47','admin','现金',''); #
# Table structure for table tb_baseinfo #
DROP TABLE IF EXISTS `tb_baseinfo`; CREATE TABLE `tb_baseinfo` ( `BIOID` varchar(32) NOT NULL, `BIONAME` varchar(32) NOT NULL, `BIOVALUE` varchar(200) NOT NULL, PRIMARY KEY (`BIOID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `tb_baseinfo` VALUES ('BIO0011234','CheckinOrderID','10'); INSERT INTO `tb_baseinfo` VALUES ('BIO0011323','ReservOrderID','4'); INSERT INTO `tb_baseinfo` VALUES
('BIO0056859','ReservUpdated','2008-06-05 00:52:57.375'); #
# Table structure for table tb_checkinitem #
DROP TABLE IF EXISTS `tb_checkinitem`; CREATE TABLE `tb_checkinitem` ( `CIMID` varchar(32) NOT NULL,
`CHECKINORDER_CIOID` varchar(32) NOT NULL, `ROOM_RMID` varchar(32) NOT NULL, `CIMPRCTPRICE` decimal(14,2) NOT NULL, `CIMDISCOUNT` decimal(5,2) default '100.00',
`CIMINDATETIME` timestamp NOT NULL default CURRENT_TIMESTAMP on update CURRENT_TIMESTAMP,
`CIMOUTDATETIME` timestamp NOT NULL default '0000-00-00 00:00:00', `CIMSTATE` varchar(16) NOT NULL, PRIMARY KEY (`CIMID`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
INSERT INTO `tb_checkinitem` VALUES
('402881e51a448696011a4489376d0002','402881e51a448696011a4489373e0001','8109',320,100,'2008-06-01 21:15:00','2008-06-02 12:00:00','已结账');
INSERT INTO `tb_checkinitem` VALUES
('402881e51a53efae011a53f77fd30002','402881e51a53efae011a53f77fc40001','8308',100,31.25,'2008-06-04 22:24:00','2008-06-05 12:00:00','已结账');
INSERT INTO `tb_checkinitem` VALUES
('402881e51a53efae011a53f77fd30003','402881e51a53efae011a53f77fc40001','8209',250,96.15,'2008-06-04 22:24:00','2008-06-05 12:00:00','已结账');
INSERT INTO `tb_checkinitem` VALUES
('402881e51a579a4b011a57d29eb50004','402881e51a579a4b011a57d29ea50003','8208',320,100,'2008-06-05 16:22:00','2008-06-06 12:00:00','已入住');
INSERT INTO `tb_checkinitem` VALUES
('402881e5267907ec01267915e3390005','402881e5267907ec01267915e32e0004','8101',260,100,'2010-01-29 15:53:00','2010-01-30 12:00:00','已入住');
INSERT INTO `tb_checkinitem` VALUES
('402881e6254e53a001254e58d94e0002','402881e6254e53a001254e58d93e0001','8106',260,100,'2009-12-02 15:43:00','2009-12-03 12:00:00','已入住');
INSERT INTO `tb_checkinitem` VALUES
('402881e6254e53a001254e58d94e0003','402881e6254e53a001254e58d93e0001','8107',0,0,'2009-12-02 15:43:00','2009-12-03 12:00:00','已入住'); INSERT INTO `tb_checkinitem` VALUES
('402881e6254e53a001254e5be9230005','402881e6254e53a001254e5be9230004','8118',260,100,'2009-12-02 15:46:00','2009-12-03 12:00:00','已入住');
INSERT INTO `tb_checkinitem` VALUES
('402881e6254e53a001254e64b91d0008','402881e6254e53a001254e64b91d0007','8106',260,100,'2009-12-02 15:54:00','2009-12-03 12:00:00','已入住');
INSERT INTO `tb_checkinitem` VALUES
('402881e625587aa7012559003f440004','402881e625587aa7012559003f2d0003','8104',260,100,'2009-12-04 15:55:00','2009-12-05 12:00:00','已结账');
INSERT INTO `tb_checkinitem` VALUES
('402881e625587aa70125590883f60006','402881e625587aa70125590883f60005','8103',260,100,'2009-12-04 15:55:00','2009-12-05 12:00:00','已入住');
INSERT INTO `tb_checkinitem` VALUES
('ff808081012a13dc01012a1aff9b0002','ff808081012a13dc01012a1aff7c0001','8109',320,100,'2005-01-01 01:06:00','2005-01-02 12:00:00','已入住');
#
# Table structure for table tb_checkinorder #
DROP TABLE IF EXISTS `tb_checkinorder`; CREATE TABLE `tb_checkinorder` ( `CIOID` varchar(32) NOT NULL, `CIOGUESTNAME` varchar(20) NOT NULL, `CIOMANNUMBER` int(10) unsigned NOT NULL, `CIOGUESTCATALOG` varchar(16) NOT NULL, `CIOGUESTTYPE` varchar(16) NOT NULL, `CIOGROUPNAME` varchar(32) default NULL, `CIOGUESTCARDCATALOG` varchar(16) NOT NULL, `CIOGUESTCARDID` varchar(32) NOT NULL, `CIOCAUSE` varchar(100) default NULL, `CIOSTATE` varchar(16) NOT NULL,
`CIOINDATETIME` timestamp NOT NULL default CURRENT_TIMESTAMP, `CIOPREOUTDATETIME` timestamp NOT NULL default '0000-00-00 00:00:00', `CIOPRCTOUTDATETIME` timestamp NOT NULL default '0000-00-00 00:00:00', `CIOPAYMENTMODEL` varchar(16) NOT NULL, `CIOPAIDMONEY` decimal(14,2) NOT NULL, `CIOISRESERVID` varchar(32) default NULL, `CIOOPERATOR` varchar(20) NOT NULL, `CIOGUESTGENDER` varchar(6) NOT NULL,