bank.sql

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

/*
Navicat MySQL Data Transfer

Source Server         : serv
Source Server Version : 50710
Source Host           : localhost:3306
Source Database       : bank

Target Server Type    : MYSQL
Target Server Version : 50710
File Encoding         : 65001

Date: 2017-03-11 10:43:20
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for manage
-- ----------------------------
DROP TABLE IF EXISTS `manage`;
CREATE TABLE `manage` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `passWord` varchar(255) DEFAULT NULL,
  `realName` varchar(255) DEFAULT NULL,
  `userName` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of manage
-- ----------------------------
INSERT INTO `manage` VALUES ('1', null, '111111', 'admin', 'admin');

-- ----------------------------
-- Table structure for record
-- ----------------------------
DROP TABLE IF EXISTS `record`;
CREATE TABLE `record` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `createTime` datetime DEFAULT NULL,
  `money` double DEFAULT NULL,
  `receiveCode` varchar(255) DEFAULT NULL,
  `type` int(11) DEFAULT NULL,
  `receive_id` int(11) DEFAULT NULL,
  `send_id` int(11) DEFAULT NULL,
  `code` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `FK_d8muiimdadj4ptrg955ao4u1t` (`receive_id`),
  KEY `FK_jcw17g9e7gh2vcjjnq0amawbf` (`send_id`),
  CONSTRAINT `FK_d8muiimdadj4ptrg955ao4u1t` FOREIGN KEY (`receive_id`) REFERENCES `user` (`id`),
  CONSTRAINT `FK_jcw17g9e7gh2vcjjnq0amawbf` FOREIGN KEY (`send_id`) REFERENCES `user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=44 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of record
-- ----------------------------
INSERT INTO `record` VALUES ('1', '2017-03-10 23:21:40', '50', '5281421296932400', '1', '3', '3', null);
INSERT INTO `record` VALUES ('2', '2017-03-10 23:33:41', '2', '5281421296932400', '1', '3', '3', '2017031000002');