宾馆管理系统数据库文件
--
-- Server version 5.0.45-community-nt
/*!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 utf8 */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
--
-- Create schema neohotel
--
-- CREATE DATABASE IF NOT EXISTS neohotel;
USE neohotel;
--
-- Definition of table `nhbalancement`
--
DROP TABLE IF EXISTS `nhbalancement`;
CREATE TABLE `nhbalancement` (
`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;
--
-- Dumping data for table `nhbalancement`
--
/*!40000 ALTER TABLE `nhbalancement` DISABLE KEYS */;
INSERT INTO `nhbalancement` (`BMID`,`BMCHECKINORDERID`,`BMGUESTID`,`BMTYPE`,`BMTOTALRATE`,`BMPAIDMONEY`,`BMRECEIVMONEY`,`BMCREATETIME`,`BMOPERATOR`,`BMPAYMENTMODEL`,`BMREMARK`) VALUES
('402881e51a448696011a4489783f0003','402881e51a448696011a4489373e0001','402881e51a39c232011a39da4d3e0005','结单','320.00','1000.00','200.00','2008-06-01 22:30:37','admin','现金','remark'),
('402881e51a53efae011a53f874550004','402881e51a53efae011a53f77fc40001','402881e51a39c232011a39da4d3e0005','结单','350.00','0.00','0.00','2008-06-04 22:26:09','admin','现金','fdsafdsa');
/*!40000 ALTER TABLE `nhbalancement` ENABLE KEYS */;
--
-- Definition of table `nhbaseinfo`
--