/*
Navicat MySQL Data Transfer

Source Server         : 127.0.0.1
Source Server Version : 50714
Source Host           : 127.0.0.1:3306
Source Database       : sales

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

Date: 2018-07-15 13:59:56
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for commodity
-- ----------------------------
DROP TABLE IF EXISTS `commodity`;
CREATE TABLE `commodity` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `classify` varchar(50) DEFAULT NULL COMMENT '分类名称',
  `name` varchar(50) DEFAULT NULL COMMENT '零件名称',
  `cnumber` varchar(50) DEFAULT NULL COMMENT '配件编号',
  `carType` varchar(50) DEFAULT NULL COMMENT '车型',
  `producingArea` varchar(50) DEFAULT NULL COMMENT '产地',
  `unit` varchar(20) DEFAULT NULL COMMENT '单位',
  `purchasePrice` double(10,2) DEFAULT NULL COMMENT '进货价',
  `sellingPrice` double(10,2) DEFAULT NULL COMMENT '零售价',
  `createTime` datetime DEFAULT NULL COMMENT '创建时间',
  `inventory` int(11) DEFAULT NULL COMMENT '库存',
  `priceGrade` int(11) DEFAULT '1' COMMENT '1-默认价，2-记忆价',
  `remark` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10017 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of commodity
-- ----------------------------
INSERT INTO `commodity` VALUES ('10014', '互联网', '笔记本', '1123', '123', '广东深圳', '个', '1500.00', '200.00', '2017-03-19 21:39:28', '1655', '1', null);
INSERT INTO `commodity` VALUES ('10015', '互联网', '硬盘', '1122', '22', '22', '个', '22.00', '22.00', '2017-04-04 00:28:15', '2', '1', null);
INSERT INTO `commodity` VALUES ('10016', '互联网', '内存条', '22', '225', '22', '个', '22.00', '22.00', '2017-04-04 00:28:36', '34', '1', null);

-- ----------------------------
-- Table structure for cuscash
-- ----------------------------
DROP TABLE IF EXISTS `cuscash`;
CREATE TABLE `cuscash` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `amount` double(16,0) DEFAULT NULL COMMENT '收支金额',
  `billNum` varchar(100) DEFAULT NULL COMMENT '单据编号',
  `customerId` int(11) DEFAULT NULL,
  `reason` varchar(255) DEFAULT NULL COMMENT '收款原因',
  `createTime` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of cuscash
-- ----------------------------
INSERT INTO `cuscash` VALUES ('4', '1111', '11', '1', '11', '2017-04-06 15:34:29');
INSERT INTO `cuscash` VALUES ('5', '200', null, '2', '收款', '2017-04-06 18:19:16');

-- ----------------------------
-- Table structure for cusrmbdetail
-- ----------------------------
DROP TABLE IF EXISTS `cusrmbdetail`;
CREATE TABLE `cusrmbdetail` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `num` double(16,0) DEFAULT '0' COMMENT '变化金额',
  `amount` double(16,0) DEFAULT NULL COMMENT '原金额',
  `parentId` int(11) DEFAULT NULL,
  `type` int(11) DEFAULT NULL,
  `customerId` int(11) DEFAULT NULL,
  `createTime` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COMMENT='客户金额流水';

-- ----------------------------
-- Records of cusrmbdetail
-- ----------------------------
INSERT INTO `cusrmbdetail` VALUES ('1', '244', '24000', '4', null, '1', null);
INSERT INTO `cusrmbdetail` VALUES ('2', '1221', '23283', '10000', null, '1', '2017-04-06 16:28:37');
INSERT INTO `cusrmbdetail` VALUES ('3', '1221', '24504', '10000', null, '1', '2017-04-06 16:28:53');
INSERT INTO `cusrmbdetail` VALUES ('4', '11', '25725', '10004', null, '1', '2017-04-06 16:30:57');
INSERT INTO `cusrmbdetail` VALUES ('5', '200', '25736', '10003', null, '1', '2017-04-06 18:06:04');
INSERT INTO `cusrmbdetail` VALUES ('6', '200', '0', '5', null, '2', '2017-04-06 18:19:16');
INSERT INTO `cusrmbdetail` VALUES ('7', '93', '200', '10005', null, '2', '2017-04-07 09:51:52');
INSERT INTO `cusrmbdetail` VALUES ('8', '86', '250', '10007', null, '2', '2018-04-22 22:18:41');

-- ----------------------------
-- Table structure for customer
-- ----------------------------
DROP TABLE IF EXISTS `customer`;
CREATE TABLE `customer` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(50) NOT NULL COMMENT '客户名称',
  `phone` varchar(55) DEFAULT NULL COMMENT '电话号码',
  `address` varchar(255) DEFAULT NULL COMMENT '地址',
  `createTime` datetime DEFAULT NULL COMMENT '创建时间',
  `receivable` double(15,2) DEFAULT '0.00' COMMENT '应收金额',
  `numbe` varchar(55) DEFAULT NULL,
  `remark` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of customer
-- ----------------------------
INSERT INTO `customer` VALUES ('1', '刘德华', '10010', '6666', '2017-02-15 00:36:06', '25936.00', 'liu', null);
INSERT INTO `customer` VALUES ('2', '小明', '10086', '6666', '2017-03-16 20:28:48', '316.00', 'xiaoming', null);

-- ----------------------------
-- Table structure for customermemory
-- ----------------------------
DROP TABLE IF EXISTS `customermemory`;
CREATE TABLE `customermemory` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `customerId` int(11) DEFAULT NULL,
  `commodityId` int(11) DEFAULT NULL,
  `price` double(15,2) DEFAULT '0.00' COMMENT '记忆价格',
  PRIMARY KEY (`id`),
  KEY `customer_id_cusMemory_id` (`customerId`),
  KEY `commodity_id_cusMemory_id` (`commodityId`),
  CONSTRAINT `commodity_id_cusMemory_id` FOREIGN KEY (`commodityId`) REFERENCES `commodity` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `customer_id_cusMemory_id` FOREIGN KEY (`customerId`) REFERENCES `customer` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of customermemory
-- ----------------------------
INSERT INTO `customermemory` VALUES ('1', '1', '10014', '11.00');
INSERT INTO `customermemory` VALUES ('2', '2', '10014', '11.00');
INSERT INTO `customermemory` VALUES ('3', '2', '10015', '12.00');
INSERT INTO `customermemory` VALUES ('4', '2', '10016', '43.00');

-- ----------------------------
-- Table structure for inventory
-- ----------------------------
DROP TABLE IF EXISTS `inventory`;
CREATE TABLE `inventory` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `num` int(11) DEFAULT NULL COMMENT '调整数量',
  `commodityId` int(11) DEFAULT NULL,
  `reason` varchar(255) DEFAULT NULL COMMENT '调整原因',
  `createTime` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of inventory
-- ----------------------------
INSERT INTO `inventory` VALUES ('1', '5', '10014', '2', '2017-04-06 14:45:53');
INSERT INTO `inventory` VALUES ('2', '-5', '10014', '11', '2017-04-06 14:47:00');
INSERT INTO `inventory` VALUES ('3', '-5', '10015', '111', '2017-04-06 14:47:19');
INSERT INTO `inventory` VALUES ('4', '-2', '10016', '111', '2017-04-06 14:49:15');
INSERT INTO `inventory` VALUES ('5', '11', '10016', '11', '2017-04-06 14:49:29');
INSERT INTO `inventory` VALUES ('6', '5', '10016', '555', '2017-04-17 17:24:36');

-- ----------------------------
-- Table structure for market
-- ----------------------------
DROP TABLE IF EXISTS `market`;
CREATE TABLE `market` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `number` varchar(50) DEFAULT NULL COMMENT '单据编号',
  `summoney` double(16,2) DEFAULT '0.00' COMMENT '销售总金额',
  `marketTime` date DEFAULT NULL COMMENT '销售时间',
  `remark` varchar(300) DEFAULT NULL COMMENT '备注',
  `customerId` int(11) DEFAULT NULL COMMENT '客户ID',
  `grade` int(11) DEFAULT NULL COMMENT '价格等级，1-默认价，2-记忆价',
  `payAmount` double(16,2) DEFAULT '0.00' COMMENT '付款金额',
  `createTime` datetime DEFAULT NULL,
  `status` int(11) DEFAULT '0' COMMENT '0-未审核，1-已审核',
  `favorable` double(16,2) DEFAULT '0.00' COMMENT '优惠金额',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10008 DEFAULT CHARSET=utf8 COMMENT='销售表';

-- ----------------------------
-- Records of market
-- ----------------------------
INSERT INTO `market` VALUES ('10003', null, '200.00', '2017-04-06', null, '1', '1', '0.00', '2017-04-06 16:08:26', '1', '0.00');
INSERT INTO `market` VALUES ('10004', null, '11.00', '2017-04-06', null, '1', '2', '0.00', '2017-04-06 16:28:34', '1', '0.00');
INSERT INTO `market` VALUES ('10005', null, '143.00', '2017-04-07', null, '2', '2', '50.00', '2017-04-07 09:46:28', '1', '43.00');
INSERT INTO `market` VALUES ('10006', null, '144.00', '2017-04-07', '2222', '2', '1', '20.00', '2017-04-07 10:11:26', '0', '20.00');
INSERT INTO `market` VALUES ('10007', null, '206.00', '2018-04-22', 'hhh', '2', '2', '120.00', '2018-04-22 22:18:11', '1', '20.00');

-- ----------------------------
-- Table structure for marketdetail
-- ----------------------------
DROP TABLE IF EXISTS `marketdetail`;
CREATE TABLE `marketdetail` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `marketId` int(11) DEFAULT NULL COMMENT '销售单ID',
  `commodityId` int(11) DEFAULT NULL COMMENT '商品id',
  `price` double(16,2) DEFAULT '0.00' COMMENT '单价',
  `quantity` int(11) DEFAULT '0' COMMENT '数量',
  `amount` double(16,2) DEFAULT '0.00' COMMENT '金额',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `inventory` int(11) DEFAULT NULL COMMENT '原库存',
  `createTime` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_market` (`marketId`) USING BTREE,
  CONSTRAINT `fk_market` FOREIGN KEY (`marketId`) REFERENCES `market` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8 COMMENT='销售订单商品明细表';

-- ----------------------------
-- Records of marketdetail
-- ----------------------------
INSERT INTO `marketdetail` VALUES ('11', '10004', '10014', '11.00', '1', '11.00', '', '1635', '2017-04-06 16:28:34');
INSERT INTO `marketdetail` VALUES ('12', '10005', '10014', '11.00', '1', '11.00', '1', '1656', '2017-04-07 09:46:28');
INSERT INTO `marketdetail` VALUES ('13', '10005', '10015', '12.00', '11', '132.00', '', '23', '2017-04-07 09:46:28');
INSERT INTO `marketdetail` VALUES ('14', '10006', '10015', '12.00', '12', '144.00', '', '12', '2017-04-07 10:11:26');
INSERT INTO `marketdetail` VALUES ('15', '10007', '10015', '12.00', '10', '120.00', '', '12', '2018-04-22 22:18:11');
INSERT INTO `marketdetail` VALUES ('16', '10007', '10016', '43.00', '2', '86.00', '', '36', '2018-04-22 22:18:11');

-- ----------------------------
-- Table structure for options
-- ----------------------------
DROP TABLE IF EXISTS `options`;
CREATE TABLE `options` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `type` int(11) NOT NULL COMMENT '1-商品分类，2-商品车型，3-商品单位，4-供应商分类',
  `name` varchar(50) NOT NULL COMMENT '选项名称',
  PRIMARY KEY (`id`,`type`)
) ENGINE=InnoDB AUTO_INCREMENT=10042 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of options
-- ----------------------------
INSERT INTO `options` VALUES ('10029', '2', '4535');
INSERT INTO `options` VALUES ('10030', '2', '45354');
INSERT INTO `options` VALUES ('10031', '2', '5465456');
INSERT INTO `options` VALUES ('10035', '1', '电机');
INSERT INTO `options` VALUES ('10036', '3', '台');
INSERT INTO `options` VALUES ('10037', '3', '个');
INSERT INTO `options` VALUES ('10038', '4', '马达');
INSERT INTO `options` VALUES ('10039', '1', '互联网');
INSERT INTO `options` VALUES ('10040', '4', 'IT');
INSERT INTO `options` VALUES ('10041', '4', '铁塔');

-- ----------------------------
-- Table structure for purchase
-- ----------------------------
DROP TABLE IF EXISTS `purchase`;
CREATE TABLE `purchase` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `number` varchar(50) DEFAULT NULL COMMENT '单据编号',
  `summoney` double(10,2) DEFAULT '0.00' COMMENT '总金额',
  `purchaseTime` date DEFAULT NULL COMMENT '采购时间',
  `remark` varchar(300) DEFAULT NULL COMMENT '备注',
  `supplierId` int(11) DEFAULT NULL COMMENT '供应商',
  `grade` int(11) DEFAULT '1' COMMENT '价格等级，1-默认价，2-记忆价',
  `payAmount` double(16,2) DEFAULT '0.00' COMMENT '付款金额',
  `createTime` datetime DEFAULT NULL,
  `status` int(11) DEFAULT '0' COMMENT '0-未审核，1-已审核',
  `favorable` double(16,2) DEFAULT '0.00' COMMENT '优惠金额',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10011 DEFAULT CHARSET=utf8 COMMENT='采购表';

-- ----------------------------
-- Records of purchase
-- ----------------------------
INSERT INTO `purchase` VALUES ('10000', null, '132.00', '2017-04-06', null, '4', '2', '0.00', '2017-04-06 16:04:52', '1', '0.00');
INSERT INTO `purchase` VALUES ('10001', null, '122.00', '2017-04-06', null, '4', '2', '0.00', '2017-04-06 16:26:49', '1', '0.00');
INSERT INTO `purchase` VALUES ('10002', null, '2696.00', '2017-04-07', null, '4', '2', '0.00', '2017-04-07 09:44:57', '1', '96.00');
INSERT INTO `purchase` VALUES ('10003', null, '12.00', '2017-04-07', null, '4', '2', '1.00', '2017-04-07 10:10:50', '0', '1.00');
INSERT INTO `purchase` VALUES ('10004', null, '26000.00', '2018-04-22', null, '5', '1', '400000.00', '2018-04-22 22:22:12', '0', '2000.00');
INSERT INTO `purchase` VALUES ('10005', null, '22.00', '2018-04-25', null, '4', '1', '0.00', '2018-04-25 23:13:09', '0', null);
INSERT INTO `purchase` VALUES ('10006', null, '400.00', '2018-04-25', null, '4', '1', '0.00', '2018-04-25 23:13:26', '0', null);
INSERT INTO `purchase` VALUES ('10007', null, '662.00', '2018-04-25', null, '4', '1', '0.00', '2018-04-25 23:14:26', '0', null);
INSERT INTO `purchase` VALUES ('10008', null, '200.00', '2018-04-25', null, '4', '1', '0.00', '2018-04-25 23:14:44', '0', null);
INSERT INTO `purchase` VALUES ('10009', null, '200.00', '2018-04-25', null, '5', '1', '0.00', '2018-04-25 23:14:52', '0', null);
INSERT INTO `purchase` VALUES ('10010', null, '22.00', '2018-04-25', null, '4', '1', '0.00', '2018-04-25 23:15:01', '0', null);

-- ----------------------------
-- Table structure for purchasedetail
-- ----------------------------
DROP TABLE IF EXISTS `purchasedetail`;
CREATE TABLE `purchasedetail` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `purchaseId` int(11) DEFAULT NULL COMMENT '采购单ID',
  `commodityId` int(11) DEFAULT NULL COMMENT '商品ID',
  `price` double(16,2) DEFAULT '0.00' COMMENT '单价',
  `quantity` int(11) DEFAULT '0' COMMENT '数量',
  `amount` double(16,2) DEFAULT '0.00' COMMENT '金额',
  `remark` varchar(255) DEFAULT NULL COMMENT '备注',
  `inventory` int(11) DEFAULT NULL COMMENT '原库存',
  `createTime` datetime DEFAULT NULL,
  PRIMARY KEY (`id`),
  KEY `fk_purchase` (`purchaseId`) USING BTREE,
  CONSTRAINT `fk_purchase` FOREIGN KEY (`purchaseId`) REFERENCES `purchase` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of purchasedetail
-- ----------------------------
INSERT INTO `purchasedetail` VALUES ('9', '10000', '10014', '12.00', '11', '132.00', '', '1634', '2017-04-06 16:04:52');
INSERT INTO `purchasedetail` VALUES ('10', '10001', '10014', '122.00', '1', '122.00', '', '1634', '2017-04-06 16:26:49');
INSERT INTO `purchasedetail` VALUES ('11', '10002', '10014', '122.00', '22', '2684.00', '', '1634', '2017-04-07 09:44:57');
INSERT INTO `purchasedetail` VALUES ('12', '10002', '10015', '12.00', '1', '12.00', '111', '22', '2017-04-07 09:44:57');
INSERT INTO `purchasedetail` VALUES ('13', '10003', '10015', '12.00', '1', '12.00', '', '12', '2017-04-07 10:10:50');
INSERT INTO `purchasedetail` VALUES ('14', '10004', '10014', '200.00', '20', '4000.00', '', '1655', '2018-04-22 22:22:12');
INSERT INTO `purchasedetail` VALUES ('15', '10004', '10015', '22.00', '1000', '22000.00', '', '2', '2018-04-22 22:22:12');
INSERT INTO `purchasedetail` VALUES ('16', '10005', '10015', '22.00', '1', '22.00', '', '2', '2018-04-25 23:13:09');
INSERT INTO `purchasedetail` VALUES ('17', '10006', '10014', '200.00', '2', '400.00', '', '1655', '2018-04-25 23:13:26');
INSERT INTO `purchasedetail` VALUES ('18', '10007', '10014', '200.00', '1', '200.00', '', '1655', '2018-04-25 23:14:26');
INSERT INTO `purchasedetail` VALUES ('19', '10007', '10015', '22.00', '1', '22.00', '', '2', '2018-04-25 23:14:26');
INSERT INTO `purchasedetail` VALUES ('20', '10007', '10016', '22.00', '20', '440.00', '', '34', '2018-04-25 23:14:26');
INSERT INTO `purchasedetail` VALUES ('21', '10008', '10014', '200.00', '1', '200.00', '', '1655', '2018-04-25 23:14:44');
INSERT INTO `purchasedetail` VALUES ('22', '10009', '10014', '200.00', '1', '200.00', '', '1655', '2018-04-25 23:14:52');
INSERT INTO `purchasedetail` VALUES ('23', '10010', '10016', '22.00', '1', '22.00', '', '34', '2018-04-25 23:15:01');

-- ----------------------------
-- Table structure for session
-- ----------------------------
DROP TABLE IF EXISTS `session`;
CREATE TABLE `session` (
  `id` varchar(50) NOT NULL DEFAULT '',
  `userId` int(11) DEFAULT NULL,
  `expireAlt` bigint(19) DEFAULT NULL COMMENT '失效时间',
  `platform` int(11) DEFAULT NULL COMMENT '平台',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of session
-- ----------------------------
INSERT INTO `session` VALUES ('008475945a2344c385e4faf65ebf9417', '10001', '1491579825452', null);
INSERT INTO `session` VALUES ('061675fe6bbf49ee8c27a16a340f235f', '10001', '1491346632765', null);
INSERT INTO `session` VALUES ('0a20ec1b891e49a684ce42e687e0dee4', '10001', '1489968755703', null);
INSERT INTO `session` VALUES ('0f9a942abb2a4cb8800e1bc1f06677fb', '10001', '1489999901082', null);
INSERT INTO `session` VALUES ('10ad7efb20814b5cb5655ac0f28aaa73', '10001', '1491402082586', null);
INSERT INTO `session` VALUES ('11ab615e60db4416a0444f88dd2c32e2', '10001', '1489956250866', null);
INSERT INTO `session` VALUES ('1d29c52f9a7d4a10aa6c3aa15b63d6da', '10001', '1491046537114', null);
INSERT INTO `session` VALUES ('226ddbde4bd2495b9370f8d73a4d937e', '10001', '1489960227486', null);
INSERT INTO `session` VALUES ('233ce9d02335463594b894086074ca30', '10001', '1491387286177', null);
INSERT INTO `session` VALUES ('2eee088b896244c5aed4ae24a7bd0083', '10001', '1491484235720', null);
INSERT INTO `session` VALUES ('38355f765cfe43858cf54be231023687', '10001', '1489969337546', null);
INSERT INTO `session` VALUES ('42343e0388bd449a9a94cca03306ec48', '10001', '1489960069323', null);
INSERT INTO `session` VALUES ('42c81913e51845fcb1d93921835a6025', '10001', '1531655160294', null);
INSERT INTO `session` VALUES ('4a5e166993514b60a9b5e8597a342e3a', '10001', '1531655229028', null);
INSERT INTO `session` VALUES ('508bddfd18b542daa7c3293c840b58d1', '10001', '1523832481982', null);
INSERT INTO `session` VALUES ('5a3b59c9011e44ffa9f362f6a4b3ef1b', '10001', '1491061926709', null);
INSERT INTO `session` VALUES ('5a92a2d578d44c23b5b4212074af8393', '10001', '1491261256907', null);
INSERT INTO `session` VALUES ('5e1332fee1244dc1a7b210a77794271e', '10001', '1490001957087', null);
INSERT INTO `session` VALUES ('6248b6ea9a5746ad8a95cc6c4defb19d', '10001', '1491062729153', null);
INSERT INTO `session` VALUES ('6bcdfd18f6bc4f8eb486e5a76919f819', '10001', '1493047026782', null);
INSERT INTO `session` VALUES ('73296869165f4bccabadf3072cd7db11', '10001', '1491556456663', null);
INSERT INTO `session` VALUES ('7509d50364fb4f38af55d466ddfd823e', '10001', '1491067757049', null);
INSERT INTO `session` VALUES ('775876ca21734b9ca24708d63d5ecf6c', '10001', '1491406781498', null);
INSERT INTO `session` VALUES ('8a8ca167c15f41b6b44a4bae3c77f0dd', '10001', '1493058481694', null);
INSERT INTO `session` VALUES ('8b42b0c3b3c7469d87dab1dad3f35768', '10001', '1490008432144', null);
INSERT INTO `session` VALUES ('9330a2124d6543bea04f6de102a80960', '10001', '1492010000397', null);
INSERT INTO `session` VALUES ('97f41378118c4a9783718e231bcece29', '10001', '1490001483845', null);
INSERT INTO `session` VALUES ('9ab9e929a44e4554a0997f53c35e52be', '10001', '1489959286843', null);
INSERT INTO `session` VALUES ('9cac032a40d246058e8f7dd08a9f8a1a', '10001', '1524436488586', null);
INSERT INTO `session` VALUES ('9fc4d9f138cf486db0edb34f6d523d18', '10001', '1524697652960', null);
INSERT INTO `session` VALUES ('a27f169ac7f341049bb7599cf4866878', '10001', '1491388248538', null);
INSERT INTO `session` VALUES ('a7b4ab9fe11240818af8a26379feb5f6', '10001', '1490136754474', null);
INSERT INTO `session` VALUES ('b49f701d1ece467fa86555c45423b823', '10001', '1489970697931', null);
INSERT INTO `session` VALUES ('b81b075a95334b7e95c43b899fef0cf2', '10001', '1491408079121', null);
INSERT INTO `session` VALUES ('be82479b53fd468ead0b7d538682c2e5', '10001', '1493045766403', null);
INSERT INTO `session` VALUES ('bf44ebe3a2e2442086dc60ee507d1344', '10001', '1491407019508', null);
INSERT INTO `session` VALUES ('ca304693e40948108a9cd304c3b446e5', '10001', '1490001959895', null);
INSERT INTO `session` VALUES ('cc862a4adb094b8db66c79ecc63149e4', '10001', '1491501648384', null);
INSERT INTO `session` VALUES ('cdc29ab9f7444559a2cdb17c328a0c1d', '10001', '1490014139679', null);
INSERT INTO `session` VALUES ('d1240c4bfc734d649a1f3c0581680613', '10001', '1490435819543', null);
INSERT INTO `session` VALUES ('d43a61bf570644de83c0cb3fc51b52b7', '10001', '1493058484811', null);
INSERT INTO `session` VALUES ('d74293b9acb1430bb22bc1c012ecaf03', '10001', '1491572353486', null);
INSERT INTO `session` VALUES ('dc98e54a75c54c939974d601607bb52c', '10001', '1492079743981', null);
INSERT INTO `session` VALUES ('df4599469b2548c297d625a61b9f8d2d', '10001', '1490459701920', null);
INSERT INTO `session` VALUES ('dfd0aa98ea8244ab822b168377399a7d', '10001', '1491498433829', null);
INSERT INTO `session` VALUES ('ec8cfc9326474d13a1d4f66e7500d3ef', '10001', '1489964133965', null);
INSERT INTO `session` VALUES ('ecd2572843df4d6c8fd528aa0f77c202', '10001', '1531654944034', null);
INSERT INTO `session` VALUES ('f4429c9a35a54ab399f041c36eae39bf', '10001', '1489971521262', null);
INSERT INTO `session` VALUES ('f5a7722d33c346e0b9d78fc02cd0f778', '10001', '1489867582965', null);
INSERT INTO `session` VALUES ('f63bd008f4354f048277b08d01879a0d', '10001', '1491162063681', null);
INSERT INTO `session` VALUES ('faf1bc54b4794b86ad0f529d4a042600', '10001', '1491488234753', null);
INSERT INTO `session` VALUES ('fb9f6e5b7ffc457396e39c2096a0a943', '10001', '1491566030761', null);
INSERT INTO `session` VALUES ('fdb3322a1ec6424dba96aab4858bae7d', '10001', '1490036167573', null);
INSERT INTO `session` VALUES ('fe6a7f13348845b68e4e1de6bde4597d', '10001', '1492449781285', null);

-- ----------------------------
-- Table structure for supcash
-- ----------------------------
DROP TABLE IF EXISTS `supcash`;
CREATE TABLE `supcash` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `amount` double(16,0) DEFAULT NULL,
  `billNum` varchar(100) DEFAULT NULL,
  `supplierId` int(11) DEFAULT NULL,
  `reason` varchar(255) DEFAULT NULL,
  `createTime` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='供应商冲账';

-- ----------------------------
-- Records of supcash
-- ----------------------------
INSERT INTO `supcash` VALUES ('1', '25', '22', '4', '22', '2017-04-06 15:48:10');
INSERT INTO `supcash` VALUES ('4', '1000', '11', '4', '11', '2017-04-06 15:49:02');

-- ----------------------------
-- Table structure for supplier
-- ----------------------------
DROP TABLE IF EXISTS `supplier`;
CREATE TABLE `supplier` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `classify` varchar(50) DEFAULT NULL COMMENT '分类名称',
  `name` varchar(50) DEFAULT NULL COMMENT '供应商名称',
  `company` varchar(150) DEFAULT NULL COMMENT '公司名称',
  `telephone` varchar(50) DEFAULT NULL COMMENT '常用电话',
  `phone` varchar(50) DEFAULT NULL COMMENT '手机',
  `address` varchar(255) DEFAULT NULL COMMENT '公司地址',
  `createTime` datetime DEFAULT NULL COMMENT '创建时间',
  `contacts` varchar(50) DEFAULT NULL COMMENT '联系人',
  `numbe` varchar(55) DEFAULT NULL COMMENT '编号',
  `payment` double(15,2) DEFAULT '0.00' COMMENT '应付金额',
  `remark` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of supplier
-- ----------------------------
INSERT INTO `supplier` VALUES ('4', '马达', '阿里巴巴', '阿里巴巴', '12345', '12345', '杭州', '2017-03-19 21:37:04', '马云', 'ali', '6331.00', null);
INSERT INTO `supplier` VALUES ('5', '铁塔', '铁塔集团', '河北铁塔', '13620401778', '13620401778', '北京', '2018-04-22 22:20:29', '谷歌', 'www111111', '230.00', '0');

-- ----------------------------
-- Table structure for suppliermemory
-- ----------------------------
DROP TABLE IF EXISTS `suppliermemory`;
CREATE TABLE `suppliermemory` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '供应商记忆价id',
  `supplierId` int(11) DEFAULT NULL COMMENT '供应商id',
  `commodityId` int(11) DEFAULT NULL COMMENT '商品id',
  `price` double(16,2) DEFAULT '0.00' COMMENT '记忆价格',
  PRIMARY KEY (`id`),
  KEY `commodity_id_supMemory_id` (`commodityId`),
  KEY `supplier_id_supMemory_id` (`supplierId`),
  CONSTRAINT `commodity_id_supMemory_id` FOREIGN KEY (`commodityId`) REFERENCES `commodity` (`id`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `supplier_id_supMemory_id` FOREIGN KEY (`supplierId`) REFERENCES `supplier` (`id`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='供应商记忆价';

-- ----------------------------
-- Records of suppliermemory
-- ----------------------------
INSERT INTO `suppliermemory` VALUES ('1', '4', '10014', '122.00');
INSERT INTO `suppliermemory` VALUES ('2', '4', '10015', '12.00');

-- ----------------------------
-- Table structure for suprmbdetail
-- ----------------------------
DROP TABLE IF EXISTS `suprmbdetail`;
CREATE TABLE `suprmbdetail` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `num` double(16,0) DEFAULT NULL,
  `amount` double(16,0) DEFAULT NULL,
  `parentId` int(11) DEFAULT NULL,
  `type` int(11) DEFAULT NULL,
  `supplierId` int(11) DEFAULT NULL,
  `createTime` datetime DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='供应商金额流水';

-- ----------------------------
-- Records of suprmbdetail
-- ----------------------------
INSERT INTO `suprmbdetail` VALUES ('1', '122', '3609', '10001', null, '4', '2017-04-06 16:26:53');
INSERT INTO `suprmbdetail` VALUES ('2', '2696', '3731', '10002', null, '4', '2017-04-07 09:45:13');