/*
MySQL Data Transfer
Source Host: localhost
Source Database: paytest
Target Host: localhost
Target Database: paytest
Date: 2011-06-25 02:24:43
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for payrecord
-- ----------------------------
CREATE TABLE `payrecord` (
  `payID` int(11) NOT NULL auto_increment,
  `payNumID` varchar(50) character set utf8 NOT NULL,
  `payType` varchar(50) character set utf8 NOT NULL,
  `payUser` varchar(50) character set utf8 NOT NULL,
  `payMoney` float NOT NULL,
  `payState` varchar(50) character set utf8 NOT NULL,
  `userRealName` varchar(50) character set utf8 NOT NULL,
  `curMoney` float NOT NULL default '0',
  `oldMoney` float NOT NULL default '0',
  `thisPayState` varchar(50) character set utf8 NOT NULL,
  `payTime` timestamp NULL default NULL,
  `source` varchar(50) character set utf8 NOT NULL,
  `createTime` timestamp NULL default CURRENT_TIMESTAMP,
  PRIMARY KEY  (`payID`,`payNumID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

-- ----------------------------
-- Records 
-- ----------------------------
