/*
Navicat MySQL Data Transfer

Source Server         : mysql
Source Server Version : 50724
Source Host           : localhost:3306
Source Database       : jxc-admin

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

Date: 2021-10-06 15:03:18
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `persistent_logins`
-- ----------------------------
DROP TABLE IF EXISTS `persistent_logins`;
CREATE TABLE `persistent_logins` (
  `username` varchar(64) NOT NULL,
  `series` varchar(64) NOT NULL,
  `token` varchar(64) NOT NULL,
  `last_used` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,
  PRIMARY KEY (`series`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of persistent_logins
-- ----------------------------
INSERT INTO `persistent_logins` VALUES ('asdf2', '19Cf43kDeOVayBvY5lyfyQ==', 'abxb8ZeJFvpYN3Uc2KzsrA==', '2021-09-15 22:09:32');
INSERT INTO `persistent_logins` VALUES ('asdf4', '3eV+1ErAaWMol+xbuKJxOg==', '5xN+xV1yu15PLXdbgH4bjQ==', '2021-09-15 22:59:03');
INSERT INTO `persistent_logins` VALUES ('asdf1', '61NRRHEm1UgAx03KmuCK3A==', 'Sae4KxqwWvDsu2DrhkCOcQ==', '2021-09-18 23:45:44');
INSERT INTO `persistent_logins` VALUES ('asdf3', 'i42QfXtVAaby4t7hFe+gkg==', 'hFWG5nwDIhjS84r9vebFLQ==', '2021-09-15 22:12:25');

-- ----------------------------
-- Table structure for `t_customer`
-- ----------------------------
DROP TABLE IF EXISTS `t_customer`;
CREATE TABLE `t_customer` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `address` varchar(300) DEFAULT NULL COMMENT '客户地址',
  `contact` varchar(50) DEFAULT NULL COMMENT '联系人',
  `name` varchar(200) DEFAULT NULL COMMENT '客户名称',
  `number` varchar(50) DEFAULT NULL COMMENT '客户联系电话',
  `remarks` varchar(1000) DEFAULT NULL COMMENT '备注',
  `is_del` int(11) DEFAULT NULL COMMENT '是否删除',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='客户表';

-- ----------------------------
-- Records of t_customer
-- ----------------------------
INSERT INTO `t_customer` VALUES ('1', '福州新弯曲5号', '小李子', '福州艾玛超市', '2132-23213421', '', '0');
INSERT INTO `t_customer` VALUES ('2', '天津兴达大街888号', '小张', '天津王大连锁酒店', '23432222311', '优质客户', '0');
INSERT INTO `t_customer` VALUES ('3', '大凉山妥洛村', '小爱', '大凉山希望小学', '233243211', '照顾客户2', '1');
INSERT INTO `t_customer` VALUES ('4', '南通通州新金路888号', '王二小', '南通通州综艺集团', '1832132321', '', '1');
INSERT INTO `t_customer` VALUES ('5', '12321', 'test', 'test', '33', null, '1');
INSERT INTO `t_customer` VALUES ('6', '1', '1', '111', '1111111', null, '1');

-- ----------------------------
-- Table structure for `t_customer_return_list`
-- ----------------------------
DROP TABLE IF EXISTS `t_customer_return_list`;
CREATE TABLE `t_customer_return_list` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `amount_paid` float NOT NULL COMMENT '实付金额',
  `amount_payable` float NOT NULL COMMENT '应付金额',
  `customer_return_date` datetime DEFAULT NULL COMMENT '退货日期',
  `customer_return_number` varchar(100) DEFAULT NULL COMMENT '退货单号',
  `remarks` varchar(1000) DEFAULT NULL COMMENT '备注',
  `state` int(11) DEFAULT NULL COMMENT '交易状态',
  `user_id` int(11) DEFAULT NULL COMMENT '操作用户',
  `customer_id` int(11) DEFAULT NULL COMMENT '客户id',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `FKd55ju83f0ntixagdvdrsmw10c` (`user_id`) USING BTREE,
  KEY `FKl0ahdwa8slkocbfe57opembfx` (`customer_id`) USING BTREE,
  CONSTRAINT `FKd55ju83f0ntixagdvdrsmw10c` FOREIGN KEY (`user_id`) REFERENCES `t_user` (`id`),
  CONSTRAINT `FKl0ahdwa8slkocbfe57opembfx` FOREIGN KEY (`customer_id`) REFERENCES `t_customer` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='客户退货单表';

-- ----------------------------
-- Records of t_customer_return_list
-- ----------------------------
INSERT INTO `t_customer_return_list` VALUES ('2', '2200', '2200', '2017-10-27 00:00:00', 'XT201710270001', 'cc', '1', '1', '3');
INSERT INTO `t_customer_return_list` VALUES ('3', '4514', '4514', '2017-10-28 00:00:00', 'XT201710280001', 'cc', '1', '1', '3');
INSERT INTO `t_customer_return_list` VALUES ('4', '4400', '4400', '2017-10-30 00:00:00', 'XT201710300001', 'cc', '1', '1', '3');
INSERT INTO `t_customer_return_list` VALUES ('5', '139', '139', '2017-10-30 00:00:00', 'XT201710300002', 'cc', '1', '1', '2');

-- ----------------------------
-- Table structure for `t_customer_return_list_goods`
-- ----------------------------
DROP TABLE IF EXISTS `t_customer_return_list_goods`;
CREATE TABLE `t_customer_return_list_goods` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `code` varchar(50) DEFAULT NULL COMMENT '商品编码',
  `model` varchar(50) DEFAULT NULL COMMENT '商品型号',
  `name` varchar(50) DEFAULT NULL COMMENT '商品名称',
  `num` int(11) NOT NULL COMMENT '数量',
  `price` float NOT NULL COMMENT '价格',
  `total` float NOT NULL COMMENT '总价',
  `unit` varchar(10) DEFAULT NULL COMMENT '单位',
  `customer_return_list_id` int(11) DEFAULT NULL COMMENT '客户退货id',
  `type_id` int(11) DEFAULT NULL COMMENT '商品类别',
  `goods_id` int(11) DEFAULT NULL COMMENT '商品id',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `FKtqt67mbn96lxn8hvtl4piblhi` (`customer_return_list_id`) USING BTREE,
  KEY `FK4sm5si4swbj3gae46jfk441yx` (`type_id`) USING BTREE,
  CONSTRAINT `FK4sm5si4swbj3gae46jfk441yx` FOREIGN KEY (`type_id`) REFERENCES `t_goods_type` (`id`),
  CONSTRAINT `FKtqt67mbn96lxn8hvtl4piblhi` FOREIGN KEY (`customer_return_list_id`) REFERENCES `t_customer_return_list` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='客户退货单商品表';

-- ----------------------------
-- Records of t_customer_return_list_goods
-- ----------------------------
INSERT INTO `t_customer_return_list_goods` VALUES ('3', '0002', 'Note8', '华为荣耀Note8', '1', '2200', '2200', '台', '2', '16', '2');
INSERT INTO `t_customer_return_list_goods` VALUES ('4', '0002', 'Note8', '华为荣耀Note8', '2', '2200', '4400', '台', '3', '16', '2');
INSERT INTO `t_customer_return_list_goods` VALUES ('5', '0003', '500g装', '野生东北黑木耳', '3', '38', '114', '袋', '3', '11', '11');
INSERT INTO `t_customer_return_list_goods` VALUES ('6', '0002', 'Note8', '华为荣耀Note8', '2', '2200', '4400', '台', '4', '16', '2');
INSERT INTO `t_customer_return_list_goods` VALUES ('7', '0007', '500g装', '吉利人家牛肉味蛋糕', '2', '10', '20', '袋', '5', '11', '15');
INSERT INTO `t_customer_return_list_goods` VALUES ('8', '0009', '240g装', '休闲零食坚果特产精品干果无漂白大个开心果', '3', '33', '99', '袋', '5', '11', '17');
INSERT INTO `t_customer_return_list_goods` VALUES ('9', '0010', '250g装', '劲仔小鱼干', '1', '20', '20', '袋', '5', '11', '18');

-- ----------------------------
-- Table structure for `t_damage_list`
-- ----------------------------
DROP TABLE IF EXISTS `t_damage_list`;
CREATE TABLE `t_damage_list` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `damage_date` datetime DEFAULT NULL COMMENT '报损日期',
  `damage_number` varchar(100) DEFAULT NULL COMMENT '报损单号',
  `remarks` varchar(1000) DEFAULT NULL COMMENT '备注',
  `user_id` int(11) DEFAULT NULL COMMENT '操作用户id',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `FKpn094ma69sch1icjc2gu7xus` (`user_id`) USING BTREE,
  CONSTRAINT `FKpn094ma69sch1icjc2gu7xus` FOREIGN KEY (`user_id`) REFERENCES `t_user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='报损单表';

-- ----------------------------
-- Records of t_damage_list
-- ----------------------------
INSERT INTO `t_damage_list` VALUES ('3', '2017-10-27 00:00:00', 'BS201710270001', 'cc', '1');
INSERT INTO `t_damage_list` VALUES ('4', '2017-10-27 00:00:00', 'BS201710270002', 'cc', '1');
INSERT INTO `t_damage_list` VALUES ('5', '2017-11-03 00:00:00', 'BS201711030001', '', '1');
INSERT INTO `t_damage_list` VALUES ('6', '2021-03-04 00:00:00', 'BS202103040001', '', '1');

-- ----------------------------
-- Table structure for `t_damage_list_goods`
-- ----------------------------
DROP TABLE IF EXISTS `t_damage_list_goods`;
CREATE TABLE `t_damage_list_goods` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `code` varchar(50) DEFAULT NULL COMMENT '商品编码',
  `model` varchar(50) DEFAULT NULL COMMENT '型号',
  `name` varchar(50) DEFAULT NULL COMMENT '商品名称',
  `num` int(11) NOT NULL COMMENT '数量',
  `price` float NOT NULL COMMENT '价格',
  `total` float NOT NULL COMMENT '总价',
  `unit` varchar(10) DEFAULT NULL COMMENT '单位',
  `damage_list_id` int(11) DEFAULT NULL COMMENT '报损单id',
  `type_id` int(11) DEFAULT NULL COMMENT '商品类别id',
  `goods_id` int(11) DEFAULT NULL COMMENT '商品id',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `FKbf5m8mm3gctrnuubr9xkjamj8` (`damage_list_id`) USING BTREE,
  KEY `FKdbdfmp09hlf2raktincwroe9n` (`type_id`) USING BTREE,
  CONSTRAINT `FKbf5m8mm3gctrnuubr9xkjamj8` FOREIGN KEY (`damage_list_id`) REFERENCES `t_damage_list` (`id`),
  CONSTRAINT `FKdbdfmp09hlf2raktincwroe9n` FOREIGN KEY (`type_id`) REFERENCES `t_goods_type` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=11 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='报损单商品表';

-- ----------------------------
-- Records of t_damage_list_goods
-- ----------------------------
INSERT INTO `t_damage_list_goods` VALUES ('4', '0003', '500g装', '野生东北黑木耳', '2', '23', '46', '袋', '3', '11', '11');
INSERT INTO `t_damage_list_goods` VALUES ('5', '0006', '300g装', '冰糖金桔干', '2', '5', '10', '盒', '3', '11', '14');
INSERT INTO `t_damage_list_goods` VALUES ('6', '0003', '500g装', '野生东北黑木耳', '2', '23', '46', '袋', '4', '11', '11');
INSERT INTO `t_damage_list_goods` VALUES ('7', '0005', '散装500克', '麦片燕麦巧克力', '32', '8', '256', '袋', '4', '11', '13');
INSERT INTO `t_damage_list_goods` VALUES ('8', '0007', '500g装', '吉利人家牛肉味蛋糕', '2', '4.5', '9', '袋', '4', '11', '15');
INSERT INTO `t_damage_list_goods` VALUES ('9', '0002', 'Note8', '华为荣耀Note8', '1', '2220', '2220', '台', '5', '16', '2');
INSERT INTO `t_damage_list_goods` VALUES ('10', '0002', 'Note8', '华为荣耀Note8', '20', '2220', '44400', '台', '6', '16', '2');

-- ----------------------------
-- Table structure for `t_goods`
-- ----------------------------
DROP TABLE IF EXISTS `t_goods`;
CREATE TABLE `t_goods` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `code` varchar(50) DEFAULT NULL COMMENT '商品编码',
  `inventory_quantity` int(11) NOT NULL COMMENT '库存数量',
  `min_num` int(11) NOT NULL COMMENT '库存下限',
  `model` varchar(50) DEFAULT NULL COMMENT '商品型号',
  `name` varchar(50) DEFAULT NULL COMMENT '商品名称',
  `producer` varchar(200) DEFAULT NULL COMMENT '生产产商',
  `purchasing_price` float NOT NULL COMMENT '采购价格',
  `remarks` varchar(1000) DEFAULT NULL COMMENT '备注',
  `selling_price` float NOT NULL COMMENT '出售价格',
  `unit` varchar(10) DEFAULT NULL COMMENT '商品单位',
  `type_id` int(11) DEFAULT NULL COMMENT '商品类别',
  `state` int(11) NOT NULL COMMENT '商品状态',
  `last_purchasing_price` float NOT NULL COMMENT '上次采购价格',
  `is_del` int(11) DEFAULT NULL COMMENT '是否删除',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `FKlxnna5ngumghp4f279mmbjtyo` (`type_id`) USING BTREE,
  CONSTRAINT `FKlxnna5ngumghp4f279mmbjtyo` FOREIGN KEY (`type_id`) REFERENCES `t_goods_type` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='商品表';

-- ----------------------------
-- Records of t_goods
-- ----------------------------
INSERT INTO `t_goods` VALUES ('1', '0001', '1373', '1000', '红色装', '陶华碧老干妈香辣脆油辣椒', '贵州省贵阳南明老干妈风味食品有限公司', '6.32', '好卖', '8.5', '13', '10', '2', '8.5', '0');
INSERT INTO `t_goods` VALUES ('2', '0002', '2456', '400', 'Note8', '华为荣耀Note8', '华为计算机系统有限公司', '1950.05', '热销', '2200', '5', '16', '2', '2220', '0');
INSERT INTO `t_goods` VALUES ('11', '0003', '4095', '400', '500g装', '野生东北黑木耳', '辉南县博康土特产有限公司', '23', '够黑2', '38', '2', '11', '2', '23', '0');
INSERT INTO `t_goods` VALUES ('12', '0004', '326', '300', '2斤装', '新疆红枣', '沧州铭鑫食品有限公司', '13', '好吃', '25', '2', '10', '2', '13', '0');
INSERT INTO `t_goods` VALUES ('13', '0005', '53', '1000', '散装500克', '麦片燕麦巧克力', '福建省麦德好食品工业有限公司', '8', 'Goods', '15', '2', '11', '2', '8', '0');
INSERT INTO `t_goods` VALUES ('14', '0006', '24', '1999', '300g装', '冰糖金桔干', '揭西县同心食品有限公司', '5.1', '', '13', '3', '11', '2', '5', '0');
INSERT INTO `t_goods` VALUES ('15', '0007', '387', '400', '500g装', '吉利人家牛肉味蛋糕', '合肥吉利人家食品有限公司', '4.5', 'good', '10', '2', '11', '2', '4.5', '0');
INSERT INTO `t_goods` VALUES ('16', '0008', '196', '500', '128g装', '奕森奶油桃肉蜜饯果脯果干桃肉干休闲零食品', '潮州市潮安区正大食品有限公司', '3', '', '10', '3', '11', '2', '3', '0');
INSERT INTO `t_goods` VALUES ('17', '0009', '365', '1000', '240g装', '休闲零食坚果特产精品干果无漂白大个开心果', '石家庄博群食品有限公司', '20', '', '33', '2', '11', '2', '20', '0');
INSERT INTO `t_goods` VALUES ('18', '0010', '10', '300', '250g装', '劲仔小鱼干', '湖南省华文食品有限公司', '12', '', '20', '2', '11', '2', '12', '0');
INSERT INTO `t_goods` VALUES ('19', '0011', '11', '300', '198g装', '山楂条', '临朐县七贤升利食品厂', '3.2', '', '10', '2', '11', '0', '3.2', '0');
INSERT INTO `t_goods` VALUES ('20', '0012', '22', '200', '500g装', '大乌梅干', '长春市鼎丰真食品有限责任公司', '20', '', '25', '2', '11', '0', '20', '0');
INSERT INTO `t_goods` VALUES ('21', '0013', '400', '100', '250g装', '手工制作芝麻香酥麻通', '桂林兰雨食品有限公司', '3', '', '8', '2', '11', '2', '3', '0');
INSERT INTO `t_goods` VALUES ('22', '0014', '12', '200', '250g装', '美国青豆原味 蒜香', '菲律宾', '5', '', '8', '2', '11', '2', '5', '0');
INSERT INTO `t_goods` VALUES ('24', '0015', '-3', '100', 'X', ' iPhone X', 'xx2', '8000', 'xxx2', '9500', '5', '16', '2', '8000', '0');
INSERT INTO `t_goods` VALUES ('26', '0017', '-1', '100', 'ILCE-A6000L', 'Sony/索尼 ILCE-A6000L WIFI微单数码相机高清单电', 'xxx', '3000', 'xxx', '3650', '5', '15', '2', '3000', '0');
INSERT INTO `t_goods` VALUES ('27', '0018', '-1', '400', 'IXUS 285 HS', 'Canon/佳能 IXUS 285 HS 数码相机 2020万像素高清拍摄', 'xx', '800', 'xxx', '1299', '5', '15', '2', '800', '0');
INSERT INTO `t_goods` VALUES ('28', '0019', '100', '300', 'Q8', 'Golden Field/金河田 Q8电脑音响台式多媒体家用音箱低音炮重低音', 'xxxx', '60', '', '129', '5', '17', '0', '60', '0');
INSERT INTO `t_goods` VALUES ('29', '0020', '0', '50', '190WDPT', 'Haier/海尔冰箱BCD-190WDPT双门电冰箱大两门冷藏冷冻', 'cc', '6666', '', '1699', '5', '14', '0', '1000', '0');
INSERT INTO `t_goods` VALUES ('30', '0021', '0', '320', '4A ', 'Xiaomi/小米 小米电视4A 32英寸 智能液晶平板电视机', 'cc', '700', '', '1199', '5', '12', '0', '700', '0');
INSERT INTO `t_goods` VALUES ('31', '0022', '0', '40', 'XQB55-36SP', 'TCL XQB55-36SP 5.5公斤全自动波轮迷你小型洗衣机家用单脱抗菌', 'cc', '400', '', '729', '5', '13', '0', '400', '0');
INSERT INTO `t_goods` VALUES ('32', '0023', '0', '1000', '80g*2', '台湾进口膨化零食品张君雅小妹妹日式串烧丸子80g*2', 'cc', '4', '', '15', '2', '9', '0', '4', '0');
INSERT INTO `t_goods` VALUES ('33', '0024', '0', '10', 'A字裙', '卓图女装立领针织格子印花拼接高腰A字裙2017秋冬新款碎花连衣裙', 'cc', '168', '', '298', '11', '6', '0', '168', '0');
INSERT INTO `t_goods` VALUES ('34', '0025', '0', '10', '三件套秋', '西服套装男三件套秋季新款商务修身职业正装男士西装新郎结婚礼服', 'cc', '189', '', '299', '11', '7', '0', '189', '0');
INSERT INTO `t_goods` VALUES ('35', '0026', '0', '10', 'AFS JEEP', '加绒加厚正品AFS JEEP/战地吉普男大码长裤植绒保暖男士牛仔裤子', 'c', '60', '', '89', '12', '8', '0', '60', '0');
INSERT INTO `t_goods` VALUES ('38', '0027', '0', '10', 'xxl', '男士马甲453455', '男士马甲', '50', '', '200', '1', '7', '0', '0', '0');
INSERT INTO `t_goods` VALUES ('39', '0028', '0', '1', '1', 'test01', '1', '1', '1', '1', '1', '1', '0', '0', '0');
INSERT INTO `t_goods` VALUES ('40', '0029', '0', '1', '1', 'test02', '1', '1', '1', '1', '1', '1', '0', '0', '0');

-- ----------------------------
-- Table structure for `t_goods_type`
-- ----------------------------
DROP TABLE IF EXISTS `t_goods_type`;
CREATE TABLE `t_goods_type` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(50) DEFAULT NULL COMMENT '类别名',
  `p_id` int(11) DEFAULT NULL COMMENT '父级类别id',
  `state` int(11) DEFAULT NULL COMMENT '节点类型',
  `icon` varchar(100) DEFAULT NULL COMMENT '节点图标',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='商品类别表';

-- ----------------------------
-- Records of t_goods_type
-- ----------------------------
INSERT INTO `t_goods_type` VALUES ('1', '所有类别', '-1', '1', 'icon-folderOpen');
INSERT INTO `t_goods_type` VALUES ('2', '服饰', '1', '1', 'icon-folder');
INSERT INTO `t_goods_type` VALUES ('3', '食品', '1', '1', 'icon-folder');
INSERT INTO `t_goods_type` VALUES ('4', '家电', '1', '1', 'icon-folder');
INSERT INTO `t_goods_type` VALUES ('5', '数码', '1', '1', 'icon-folder');
INSERT INTO `t_goods_type` VALUES ('6', '连衣裙', '2', '0', 'icon-folder');
INSERT INTO `t_goods_type` VALUES ('7', '男士西装', '2', '0', 'icon-folder');
INSERT INTO `t_goods_type` VALUES ('8', '牛仔裤', '2', '0', 'icon-folder');
INSERT INTO `t_goods_type` VALUES ('9', '进口食品', '3', '0', 'icon-folder');
INSERT INTO `t_goods_type` VALUES ('10', '地方特产', '3', '0', 'icon-folder');
INSERT INTO `t_goods_type` VALUES ('11', '休闲食品', '3', '0', 'icon-folder');
INSERT INTO `t_goods_type` VALUES ('12', '电视机', '4', '0', 'icon-folder');
INSERT INTO `t_goods_type` VALUES ('13', '洗衣机', '4', '0', 'icon-folder');
INSERT INTO `t_goods_type` VALUES ('14', '冰箱', '4', '0', 'icon-folder');
INSERT INTO `t_goods_type` VALUES ('15', '相机', '5', '0', 'icon-folder');
INSERT INTO `t_goods_type` VALUES ('16', '手机', '5', '0', 'icon-folder');
INSERT INTO `t_goods_type` VALUES ('17', '音箱', '5', '0', 'icon-folder');

-- ----------------------------
-- Table structure for `t_goods_unit`
-- ----------------------------
DROP TABLE IF EXISTS `t_goods_unit`;
CREATE TABLE `t_goods_unit` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(10) DEFAULT NULL COMMENT '单位名',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='商品单位表';

-- ----------------------------
-- Records of t_goods_unit
-- ----------------------------
INSERT INTO `t_goods_unit` VALUES ('1', '个');
INSERT INTO `t_goods_unit` VALUES ('2', '袋');
INSERT INTO `t_goods_unit` VALUES ('3', '盒');
INSERT INTO `t_goods_unit` VALUES ('4', '箱');
INSERT INTO `t_goods_unit` VALUES ('5', '台');
INSERT INTO `t_goods_unit` VALUES ('6', '包');
INSERT INTO `t_goods_unit` VALUES ('11', '件');
INSERT INTO `t_goods_unit` VALUES ('12', '条');
INSERT INTO `t_goods_unit` VALUES ('13', '瓶');

-- ----------------------------
-- Table structure for `t_log`
-- ----------------------------
DROP TABLE IF EXISTS `t_log`;
CREATE TABLE `t_log` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `content` varchar(1000) DEFAULT NULL,
  `time` datetime DEFAULT NULL,
  `type` varchar(100) DEFAULT NULL,
  `user_id` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  KEY `FKbvn5yabu3vqwvtjoh32i9r4ip` (`user_id`) USING BTREE,
  CONSTRAINT `FKbvn5yabu3vqwvtjoh32i9r4ip` FOREIGN KEY (`user_id`) REFERENCES `t_user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3227 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;

-- ----------------------------
-- Records of t_log
-- ----------------------------
INSERT INTO `t_log` VALUES ('1911', '查询用户信息', '2017-10-26 19:47:31', '查询操作', '1');
INSERT INTO `t_log` VALUES ('1912', '查询用户信息', '2017-10-26 19:47:31', '查询操作', '1');
INSERT INTO `t_log` VALUES ('1913', '用户注销', '2017-10-26 19:47:40', '注销操作', '1');
INSERT INTO `t_log` VALUES ('1914', '用户登录', '2017-10-26 19:47:45', '登录操作', '1');
INSERT INTO `t_log` VALUES ('1915', '用户登录', '2017-10-26 19:56:16', '登录操作', '1');
INSERT INTO `t_log` VALUES ('1916', '用户登录', '2017-10-26 19:56:52', '登录操作', '1');
INSERT INTO `t_log` VALUES ('1917', '用户登录', '2017-10-26 19:59:18', '登录操作', '1');
INSERT INTO `t_log` VALUES ('1918', '用户登录', '2017-10-26 20:53:34', '登录操作', '1');
INSERT INTO `t_log` VALUES ('1919', '查询商品信息', '2017-10-26 20:54:41', '查询操作', '1');
INSERT INTO `t_log` VALUES ('1920', '查询商品信息', '2017-10-26 20:54:41', '查询操作', '1');
INSERT INTO `t_log` VALUES ('1921', '查询商品类别信息', '2017-10-26 20:54:45', '查询操作', '1');
INSERT INTO `t_log` VALUES ('1922', '用户登录', '2017-10-27 08:39:36', '登录操作', '1');
INSERT INTO `t_log` VALUES ('1923', '查询商品信息', '2017-10-27 08:41:20', '查询操作', '1');
INSERT INTO `t_log` VALUES ('1924', '查询商品信息', '2017-10-27 08:41:20', '查询操作', '1');
INSERT INTO `t_log` VALUES ('1925', '用户登录', '2017-10-27 09:51:40', '登录操作', '1');
INSERT INTO `t_log` VALUES ('1926', '查询商品信息', '2017-10-27 09:52:54', '查询操作', '1');
INSERT INTO `t_log` VALUES ('1927', '查询商品信息', '2017-10-27 09:52:54', '查询操作', '1');
INSERT INTO `t_log` VALUES ('1928', '查询商品类别信息', '2017-10-27 09:53:34', '查询操作', '1');
INSERT INTO `t_log` VALUES ('1929', '添加进货单', '2017-10-27 09:54:02', '添加操作', '1');
INSERT INTO `t_log` VALUES ('1930', '查询商品信息', '2017-10-27 09:54:03', '查询操作', '1');
INSERT INTO `t_log` VALUES ('1931', '查询商品信息', '2017-10-27 09:54:03', '查询操作', '1');
INSERT INTO `t_log` VALUES ('1932', '用户登录', '2017-10-27 09:54:58', '登录操作', '1');
INSERT INTO `t_log` VALUES ('1933', '查询商品信息', '2017-10-27 09:55:20', '查询操作', '1');
INSERT INTO `t_log` VALUES ('1934', '查询商品信息', '2017-10-27 09:55:20', '查询操作', '1');
INSERT INTO `t_log` VALUES ('1935', '查询商品类别信息', '2017-10-27 09:55:22', '查询操作', '1');
INSERT INTO `t_log` VALUES ('1936', '添加进货单', '2017-10-27 09:55:33', '添加操作', '1');
INSERT INTO `t_log` VALUES ('1937', '查询商品信息', '2017-10-27 09:55:34', '查询操作', '1');
INSERT INTO `t_log` VALUES ('1938', '查询商品信息', '2017-10-27 09:55:34', '查询操作', '1');
INSERT INTO `t_log` VALUES ('1939', '用户登录', '2017-10-27 09:59:02', '登录操作', '1');
INSERT INTO `t_log` VALUES ('1940', '用户登录', '2017-10-27 10:03:30', '登录操作', '1');
INSERT INTO `t_log` VALUES ('1941', '查询商品信息', '2017-10-27 10:03:35', '查询操作', '1');
INSERT INTO `t_log` VALUES ('1942', '查询商品信息', '2017-10-27 10:03:35', '查询操作', '1');
INSERT INTO `t_log` VALUES ('1943', '查询商品类别信息', '2017-10-27 10:03:39', '查询操作', '1');
INSERT INTO `t_log` VALUES ('1944', '添加进货单', '2017-10-27 10:03:51', '添加操作', '1');
INSERT INTO `t_log` VALUES ('1945', '查询商品信息', '2017-10-27 10:03:52', '查询操作', '1');
INSERT INTO `t_log` VALUES ('1946', '查询商品信息', '2017-10-27 10:03:52', '查询操作', '1');
INSERT INTO `t_log` VALUES ('1947', '查询商品类别信息', '2017-10-27 10:03:53', '查询操作', '1');
INSERT INTO `t_log` VALUES ('1948', '添加进货单', '2017-10-27 10:04:09', '添加操作', '1');
INSERT INTO `t_log` VALUES ('1949', '查询商品信息', '2017-10-27 10:04:10', '查询操作', '1');
INSERT INTO `t_log` VALUES ('1950', '查询商品信息', '2017-10-27 10:04:10', '查询操作', '1');
INSERT INTO `t_log` VALUES ('1951', '查询商品信息', '2017-10-27 10:06:37', '查询操作', '1');
INSERT INTO `t_log` VALUES ('1952', '查询商品信息', '2017-10-27 10:06:37', '查询操作', '1');
INSERT INTO `t_log` VALUES ('1953', '查询商品信息', '2017-10-27 10:11:11', '查询操作', '1');
INSERT INTO `t_log` VALUES ('1954', '查询商品信息', '2017-10-27 10:11:11', '查询操作', '1');
INSERT INTO `t_log` VALUES ('1955', '查询商品类别信息', '2017-10-27 10:11:12', '查询操作', '1');
INSERT INTO `t_log` VALUES ('1956', '添加退货单', '2017-10-27 10:11:22', '添加操作', '1');
INSERT INTO `t_log` VALUES ('1957', '查询商品信息', '2017-10-27 10:11:23', '查询操作', '1');
INSERT INTO `t_log` VALUES ('1958', '查询商品信息', '2017-10-27 10:11:23', '查询操作', '1');
INSERT INTO `t_log` VALUES ('1959', '查询商品信息', '2017-10-27 10:14:05', '查询操作', '1');
INSERT INTO `t_log` VALUES ('1960', '查询商品信息', '2017-10-27 10:14:05', '查询操作', '1');
INSERT INTO `t_log` VALUES ('1961', '查询商品类别信息', '2017-10-27 10:14:07', '查询操作', '1');
INSERT INTO `t_log` VALUES ('1962', '添加销售单', '2017-10-27 10:14:59', '添加操作', '1');
INSERT INTO `t_log` VALUES ('1963', '查询商品信息', '2017-10-27 10:15:01', '查询操作', '1');
INSERT INTO `t_log` VALUES ('1964', '查询商品信息', '2017-10-27 10:15:01', '查询操作', '1');
INSERT INTO `t_log` VALUES ('1965', '查询商品信息', '2017-10-27 10:15:07', '查询操作', '1');
INSERT INTO `t_log` VALUES ('1966', '查询商品信息', '2017-10-27 10:15:07', '查询操作', '1');
INSERT INTO `t_log` VALUES ('1967', '查询商品类别信息', '2017-10-27 10:15:10', '查询操作', '1');
INSERT INTO `t_log` VALUES ('1968', '添加客户退货单', '2017-10-27 10:15:18', '添加操作', '1');
INSERT INTO `t_log` VALUES ('1969', '查询商品信息', '2017-10-27 10:15:20', '查询操作', '1');
INSERT INTO `t_log` VALUES ('1970', '查询商品信息', '2017-10-27 10:15:20', '查询操作', '1');
INSERT INTO `t_log` VALUES ('1971', '查询商品信息', '2017-10-27 10:15:28', '查询操作', '1');
INSERT INTO `t_log` VALUES ('1972', '查询商品信息', '2017-10-27 10:15:28', '查询操作', '1');
INSERT INTO `t_log` VALUES ('1973', '查询商品信息', '2017-10-27 10:15:34', '查询操作', '1');
INSERT INTO `t_log` VALUES ('1974', '查询商品信息', '2017-10-27 10:15:34', '查询操作', '1');
INSERT INTO `t_log` VALUES ('1975', '查询商品类别信息', '2017-10-27 10:16:55', '查询操作', '1');
INSERT INTO `t_log` VALUES ('1976', '添加报损单', '2017-10-27 10:17:05', '添加操作', '1');
INSERT INTO `t_log` VALUES ('1977', '查询商品信息', '2017-10-27 10:17:06', '查询操作', '1');
INSERT INTO `t_log` VALUES ('1978', '查询商品信息', '2017-10-27 10:17:06', '查询操作', '1');
INSERT INTO `t_log` VALUES ('1979', '查询商品类别信息', '2017-10-27 10:17:09', '查询操作', '1');
INSERT INTO `t_log` VALUES ('1980', '添加报溢单', '2017-10-27 10:17:20', '添加操作', '1');
INSERT INTO `t_log` VALUES ('1981', '查询商品信息', '2017-10-27 10:17:21', '查询操作', '1');
INSERT INTO `t_log` VALUES ('1982', '查询商品信息', '2017-10-27 10:17:21', '查询操作', '1');
INSERT INTO `t_log` VALUES ('1983', '用户登录', '2017-10-27 18:55:03', '登录操作', '1');
INSERT INTO `t_log` VALUES ('1984', '用户注销', '2017-10-27 18:55:31', '注销操作', '1');
INSERT INTO `t_log` VALUES ('1985', '用户登录', '2017-10-27 18:55:35', '登录操作', '1');
INSERT INTO `t_log` VALUES ('1986', '用户注销', '2017-10-27 18:56:00', '注销操作', '1');
INSERT INTO `t_log` VALUES ('1987', '用户登录', '2017-10-27 18:56:04', '登录操作', '1');
INSERT INTO `t_log` VALUES ('1988', '用户注销', '2017-10-27 18:56:44', '注销操作', '1');
INSERT INTO `t_log` VALUES ('1989', '用户登录', '2017-10-27 18:56:48', '登录操作', '1');
INSERT INTO `t_log` VALUES ('1990', '用户登录', '2017-10-27 19:36:59', '登录操作', '1');
INSERT INTO `t_log` VALUES ('1991', '查询商品信息', '2017-10-27 19:40:14', '查询操作', '1');
INSERT INTO `t_log` VALUES ('1992', '查询商品信息', '2017-10-27 19:40:14', '查询操作', '1');
INSERT INTO `t_log` VALUES ('1993', '查询商品类别信息', '2017-10-27 19:40:15', '查询操作', '1');
INSERT INTO `t_log` VALUES ('1994', '添加报损单', '2017-10-27 19:40:25', '添加操作', '1');
INSERT INTO `t_log` VALUES ('1995', '查询商品信息', '2017-10-27 19:40:26', '查询操作', '1');
INSERT INTO `t_log` VALUES ('1996', '查询商品信息', '2017-10-27 19:40:26', '查询操作', '1');
INSERT INTO `t_log` VALUES ('1997', '删除进货单信息null', '2017-10-27 19:49:02', '删除操作', '1');
INSERT INTO `t_log` VALUES ('1998', '查询商品信息', '2017-10-27 19:54:18', '查询操作', '1');
INSERT INTO `t_log` VALUES ('1999', '查询商品信息', '2017-10-27 19:54:18', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2000', '查询商品类别信息', '2017-10-27 19:54:22', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2001', '添加报溢单', '2017-10-27 19:54:28', '添加操作', '1');
INSERT INTO `t_log` VALUES ('2002', '查询商品信息', '2017-10-27 19:54:29', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2003', '查询商品信息', '2017-10-27 19:54:29', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2004', '用户登录', '2017-10-27 20:00:43', '登录操作', '1');
INSERT INTO `t_log` VALUES ('2005', '用户登录', '2017-10-28 10:13:17', '登录操作', '1');
INSERT INTO `t_log` VALUES ('2006', '查询商品信息', '2017-10-28 10:13:38', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2007', '查询商品信息', '2017-10-28 10:13:38', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2008', '查询商品信息', '2017-10-28 10:33:23', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2009', '查询商品信息', '2017-10-28 10:33:23', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2010', '查询商品类别信息', '2017-10-28 10:34:28', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2011', '添加销售单', '2017-10-28 10:34:39', '添加操作', '1');
INSERT INTO `t_log` VALUES ('2012', '查询商品信息', '2017-10-28 10:34:40', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2013', '查询商品信息', '2017-10-28 10:34:40', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2014', '查询商品信息', '2017-10-28 10:41:00', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2015', '查询商品信息', '2017-10-28 10:41:00', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2016', '查询商品类别信息', '2017-10-28 10:41:01', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2017', '添加客户退货单', '2017-10-28 10:41:09', '添加操作', '1');
INSERT INTO `t_log` VALUES ('2018', '查询商品信息', '2017-10-28 10:41:10', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2019', '查询商品信息', '2017-10-28 10:41:10', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2020', '查询供应商信息', '2017-10-28 11:08:08', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2021', '查询供应商信息', '2017-10-28 11:08:08', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2022', '查询客户信息', '2017-10-28 11:08:08', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2023', '查询客户信息', '2017-10-28 11:08:08', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2024', '查询商品类别信息', '2017-10-28 11:08:15', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2025', '查询商品单位信息', '2017-10-28 11:08:15', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2026', '查询商品信息', '2017-10-28 11:08:15', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2027', '查询商品信息', '2017-10-28 11:08:15', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2028', '查询商品类别信息', '2017-10-28 11:08:46', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2029', '查询商品类别信息', '2017-10-28 11:08:54', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2030', '查询商品类别信息', '2017-10-28 11:18:39', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2031', '查询商品信息（无库存）', '2017-10-28 11:18:58', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2032', '查询商品信息（有库存）', '2017-10-28 11:18:58', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2033', '查询商品信息（有库存）', '2017-10-28 11:18:58', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2034', '查询商品信息（无库存）', '2017-10-28 11:18:58', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2035', '用户登录', '2017-10-28 11:32:06', '登录操作', '1');
INSERT INTO `t_log` VALUES ('2036', '查询商品信息（无库存）', '2017-10-28 11:32:26', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2037', '查询商品信息（无库存）', '2017-10-28 11:32:35', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2038', '用户登录', '2017-10-28 12:07:49', '登录操作', '1');
INSERT INTO `t_log` VALUES ('2039', '查询商品库存信息', '2017-10-28 12:07:52', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2040', '查询商品库存信息', '2017-10-28 12:07:56', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2041', '查询商品库存信息', '2017-10-28 12:07:58', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2042', '查询商品库存信息', '2017-10-28 12:08:21', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2043', '查询商品库存信息', '2017-10-28 12:08:23', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2044', '查询商品库存信息', '2017-10-28 12:08:38', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2045', '查询商品库存信息', '2017-10-28 12:08:45', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2046', '查询商品信息', '2017-10-28 12:09:06', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2047', '查询商品信息', '2017-10-28 12:09:06', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2048', '查询商品类别信息', '2017-10-28 12:09:08', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2049', '添加销售单', '2017-10-28 12:09:23', '添加操作', '1');
INSERT INTO `t_log` VALUES ('2050', '查询商品信息', '2017-10-28 12:09:24', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2051', '查询商品信息', '2017-10-28 12:09:24', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2052', '查询商品库存信息', '2017-10-28 12:09:26', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2053', '查询商品库存信息', '2017-10-28 12:09:30', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2054', '查询商品库存信息', '2017-10-28 12:09:34', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2055', '用户登录', '2017-10-28 20:06:03', '登录操作', '1');
INSERT INTO `t_log` VALUES ('2056', '查询商品类别信息', '2017-10-28 20:06:06', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2057', '查询商品信息', '2017-10-28 20:06:06', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2058', '查询商品单位信息', '2017-10-28 20:06:06', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2059', '查询商品信息', '2017-10-28 20:06:06', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2060', '查询商品库存信息', '2017-10-28 20:08:00', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2061', '查询商品类别信息', '2017-10-28 20:08:01', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2062', '查询商品库存信息', '2017-10-28 20:08:29', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2063', '查询商品类别信息', '2017-10-28 20:08:39', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2064', '查询商品库存信息', '2017-10-28 20:08:47', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2065', '查询商品类别信息', '2017-10-28 20:08:48', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2066', '查询商品类别信息', '2017-10-28 20:09:02', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2067', '查询商品类别信息', '2017-10-28 20:09:04', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2068', '查询商品库存信息', '2017-10-28 20:11:06', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2069', '查询商品类别信息', '2017-10-28 20:11:06', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2070', '查询商品库存信息', '2017-10-28 20:11:21', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2071', '查询商品库存信息', '2017-10-28 20:11:30', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2072', '查询商品类别信息', '2017-10-28 20:11:30', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2073', '查询商品库存信息', '2017-10-28 20:11:43', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2074', '查询商品类别信息', '2017-10-28 20:11:44', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2075', '查询商品库存信息', '2017-10-28 20:12:01', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2076', '查询商品类别信息', '2017-10-28 20:12:02', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2077', '查询商品类别信息', '2017-10-28 20:12:11', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2078', '查询商品库存信息', '2017-10-28 20:12:14', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2079', '查询商品类别信息', '2017-10-28 20:12:14', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2080', '查询商品库存信息', '2017-10-28 20:12:26', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2081', '查询商品类别信息', '2017-10-28 20:12:27', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2082', '查询商品库存信息', '2017-10-28 20:12:30', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2083', '查询商品类别信息', '2017-10-28 20:12:31', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2084', '查询商品类别信息', '2017-10-28 20:12:33', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2085', '查询商品库存信息', '2017-10-28 20:14:01', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2086', '查询商品库存信息', '2017-10-28 20:15:34', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2087', '查询商品类别信息', '2017-10-28 20:15:35', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2088', '查询商品类别信息', '2017-10-28 20:15:37', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2089', '查询商品库存信息', '2017-10-28 20:15:39', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2090', '查询商品类别信息', '2017-10-28 20:15:40', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2091', '查询商品库存信息', '2017-10-28 20:15:43', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2092', '查询商品类别信息', '2017-10-28 20:15:44', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2093', '查询商品类别信息', '2017-10-28 20:15:47', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2094', '查询商品库存信息', '2017-10-28 20:15:59', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2095', '查询商品类别信息', '2017-10-28 20:16:00', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2096', '查询商品库存信息', '2017-10-28 20:16:02', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2097', '查询商品类别信息', '2017-10-28 20:16:03', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2098', '查询商品库存信息', '2017-10-28 20:16:05', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2099', '查询商品类别信息', '2017-10-28 20:16:06', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2100', '查询商品库存信息', '2017-10-28 20:16:19', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2101', '查询商品库存信息', '2017-10-28 20:16:24', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2102', '查询商品库存信息', '2017-10-28 20:16:33', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2103', '查询商品库存信息', '2017-10-28 20:16:33', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2104', '查询商品库存信息', '2017-10-28 20:17:07', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2105', '查询商品类别信息', '2017-10-28 20:17:11', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2106', '查询商品库存信息', '2017-10-28 20:17:25', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2107', '用户登录', '2017-10-28 20:20:53', '登录操作', '1');
INSERT INTO `t_log` VALUES ('2108', '查询商品库存信息', '2017-10-28 20:20:56', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2109', '查询商品库存信息', '2017-10-28 20:20:58', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2110', '查询商品库存信息', '2017-10-28 20:21:00', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2111', '查询商品库存信息', '2017-10-28 20:21:02', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2112', '查询商品类别信息', '2017-10-28 20:21:03', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2113', '查询商品库存信息', '2017-10-28 20:21:07', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2114', '查询商品库存信息', '2017-10-28 20:21:27', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2115', '查询商品库存信息', '2017-10-28 20:21:36', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2116', '用户登录', '2017-10-28 20:22:38', '登录操作', '1');
INSERT INTO `t_log` VALUES ('2117', '查询商品库存信息', '2017-10-28 20:22:39', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2118', '查询商品库存信息', '2017-10-28 20:22:42', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2119', '查询商品库存信息', '2017-10-28 20:22:46', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2120', '查询商品库存信息', '2017-10-28 20:27:27', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2121', '查询商品库存信息', '2017-10-28 20:27:32', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2122', '查询商品库存信息', '2017-10-28 20:27:34', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2123', '查询商品库存信息', '2017-10-28 20:27:40', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2124', '查询商品库存信息', '2017-10-28 20:27:41', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2125', '查询商品库存信息', '2017-10-28 20:27:42', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2126', '查询商品库存信息', '2017-10-28 20:27:44', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2127', '查询商品库存信息', '2017-10-28 20:30:49', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2128', '查询商品信息', '2017-10-28 20:31:05', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2129', '查询商品信息', '2017-10-28 20:31:05', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2130', '查询商品类别信息', '2017-10-28 20:31:10', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2131', '查询商品信息', '2017-10-28 20:31:22', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2132', '查询商品信息', '2017-10-28 20:31:22', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2133', '查询商品类别信息', '2017-10-28 20:31:22', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2134', '查询商品类别信息', '2017-10-28 20:31:31', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2135', '添加进货单', '2017-10-28 20:31:38', '添加操作', '1');
INSERT INTO `t_log` VALUES ('2136', '查询商品信息', '2017-10-28 20:31:40', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2137', '查询商品信息', '2017-10-28 20:31:40', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2138', '查询商品库存信息', '2017-10-28 20:31:59', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2139', '查询商品库存信息', '2017-10-28 20:32:00', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2140', '查询商品库存信息', '2017-10-28 20:32:00', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2141', '用户登录', '2017-10-29 08:55:04', '登录操作', '1');
INSERT INTO `t_log` VALUES ('2142', '查询商品库存信息', '2017-10-29 08:55:04', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2143', '查询商品库存信息', '2017-10-29 08:55:07', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2144', '查询商品库存信息', '2017-10-29 08:55:33', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2145', '用户登录', '2017-10-29 09:35:36', '登录操作', '1');
INSERT INTO `t_log` VALUES ('2146', '查询商品库存信息', '2017-10-29 09:35:36', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2147', '查询商品库存信息', '2017-10-29 09:35:38', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2148', '查询商品信息', '2017-10-29 09:35:41', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2149', '查询商品信息', '2017-10-29 09:35:41', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2150', '查询商品信息', '2017-10-29 09:35:41', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2151', '查询商品信息', '2017-10-29 09:35:41', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2152', '用户登录', '2017-10-29 16:12:34', '登录操作', '1');
INSERT INTO `t_log` VALUES ('2153', '查询商品库存信息', '2017-10-29 16:12:35', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2154', '查询商品库存信息', '2017-10-29 16:16:19', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2155', '查询客户信息', '2017-10-29 16:16:20', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2156', '查询客户信息', '2017-10-29 16:16:20', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2157', '查询商品类别信息', '2017-10-29 16:16:21', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2158', '查询商品单位信息', '2017-10-29 16:16:21', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2159', '查询商品信息', '2017-10-29 16:16:21', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2160', '查询商品信息', '2017-10-29 16:16:21', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2161', '查询商品信息（无库存）', '2017-10-29 16:16:22', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2162', '查询商品信息（有库存）', '2017-10-29 16:16:22', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2163', '查询商品信息（有库存）', '2017-10-29 16:16:22', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2164', '查询商品信息（无库存）', '2017-10-29 16:16:22', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2165', '查询供应商信息', '2017-10-29 16:16:23', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2166', '查询供应商信息', '2017-10-29 16:16:23', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2167', '查询角色信息', '2017-10-29 16:16:25', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2168', '查询角色信息', '2017-10-29 16:16:25', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2169', '查询用户信息', '2017-10-29 16:16:26', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2170', '查询用户信息', '2017-10-29 16:16:26', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2171', '查询商品信息', '2017-10-29 16:16:33', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2172', '查询商品信息', '2017-10-29 16:16:33', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2173', '查询商品信息', '2017-10-29 16:16:35', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2174', '查询商品信息', '2017-10-29 16:16:35', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2175', '用户登录', '2017-10-29 16:52:51', '登录操作', '1');
INSERT INTO `t_log` VALUES ('2176', '查询商品库存信息', '2017-10-29 16:52:51', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2177', '查询供应商信息', '2017-10-29 16:52:54', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2178', '查询供应商信息', '2017-10-29 16:52:54', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2179', '用户注销', '2017-10-29 17:10:28', '注销操作', '1');
INSERT INTO `t_log` VALUES ('2180', '用户登录', '2017-10-29 17:10:56', '登录操作', '1');
INSERT INTO `t_log` VALUES ('2181', '查询商品库存信息', '2017-10-29 17:10:56', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2182', '查询角色信息', '2017-10-29 17:11:03', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2183', '查询角色信息', '2017-10-29 17:11:03', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2184', '查询用户信息', '2017-10-29 17:11:15', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2185', '查询用户信息', '2017-10-29 17:11:15', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2186', '查询所有角色信息', '2017-10-29 17:11:16', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2187', '查询商品信息（无库存）', '2017-10-29 17:11:29', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2188', '查询商品信息（无库存）', '2017-10-29 17:11:29', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2189', '查询商品信息（有库存）', '2017-10-29 17:11:29', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2190', '查询商品信息（有库存）', '2017-10-29 17:11:29', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2191', '查询商品类别信息', '2017-10-29 17:11:33', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2192', '查询商品信息', '2017-10-29 17:11:33', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2193', '查询商品单位信息', '2017-10-29 17:11:33', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2194', '查询商品信息', '2017-10-29 17:11:33', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2195', '查询商品类别信息', '2017-10-29 17:11:40', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2196', '用户登录', '2017-10-29 17:42:10', '登录操作', '1');
INSERT INTO `t_log` VALUES ('2197', '查询商品库存信息', '2017-10-29 17:42:10', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2198', '用户登录', '2017-10-29 19:40:13', '登录操作', '1');
INSERT INTO `t_log` VALUES ('2199', '查询商品库存信息', '2017-10-29 19:40:14', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2200', '查询商品信息', '2017-10-29 19:48:19', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2201', '查询商品信息', '2017-10-29 19:48:19', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2202', '查询商品类别信息', '2017-10-29 19:48:20', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2203', '添加进货单', '2017-10-29 19:48:37', '添加操作', '1');
INSERT INTO `t_log` VALUES ('2204', '查询商品信息', '2017-10-29 19:48:38', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2205', '查询商品信息', '2017-10-29 19:48:38', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2206', '查询商品库存信息', '2017-10-29 20:24:31', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2207', '查询商品库存信息', '2017-10-29 20:24:33', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2208', '用户登录', '2017-10-29 20:24:56', '登录操作', '1');
INSERT INTO `t_log` VALUES ('2209', '查询商品库存信息', '2017-10-29 20:24:56', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2210', '用户登录', '2017-10-29 20:33:48', '登录操作', '1');
INSERT INTO `t_log` VALUES ('2211', '查询商品库存信息', '2017-10-29 20:33:48', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2212', '查询商品库存信息', '2017-10-29 20:34:36', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2213', '用户注销', '2017-10-29 20:34:39', '注销操作', '1');
INSERT INTO `t_log` VALUES ('2214', '用户登录', '2017-10-29 20:34:44', '登录操作', '1');
INSERT INTO `t_log` VALUES ('2215', '查询商品库存信息', '2017-10-29 20:34:44', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2216', '查询商品类别信息', '2017-10-29 20:34:56', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2217', '用户登录', '2017-10-30 09:35:23', '登录操作', '1');
INSERT INTO `t_log` VALUES ('2218', '查询商品库存信息', '2017-10-30 09:35:23', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2219', '查询商品信息', '2017-10-30 09:35:26', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2220', '查询商品信息', '2017-10-30 09:35:26', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2221', '查询商品信息', '2017-10-30 09:35:27', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2222', '查询商品信息', '2017-10-30 09:35:27', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2223', '查询供应商信息', '2017-10-30 09:41:15', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2224', '查询供应商信息', '2017-10-30 09:41:15', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2225', '查询客户信息', '2017-10-30 09:42:13', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2226', '查询客户信息', '2017-10-30 09:42:13', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2227', '查询商品信息', '2017-10-30 09:42:28', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2228', '查询商品信息', '2017-10-30 09:42:28', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2229', '查询商品库存信息', '2017-10-30 09:43:06', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2230', '用户登录', '2017-10-30 10:47:44', '登录操作', '1');
INSERT INTO `t_log` VALUES ('2231', '查询商品库存信息', '2017-10-30 10:47:45', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2232', '查询商品信息', '2017-10-30 10:47:56', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2233', '查询商品信息', '2017-10-30 10:47:56', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2234', '查询商品信息', '2017-10-30 10:48:04', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2235', '查询商品信息', '2017-10-30 10:48:04', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2236', '查询商品类别信息', '2017-10-30 10:48:12', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2237', '查询商品库存信息', '2017-10-30 11:04:51', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2238', '查询商品信息', '2017-10-30 11:04:54', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2239', '查询商品信息', '2017-10-30 11:04:54', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2240', '查询商品信息', '2017-10-30 11:05:17', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2241', '查询商品信息', '2017-10-30 11:05:17', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2242', '查询商品类别信息', '2017-10-30 11:05:21', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2243', '添加销售单', '2017-10-30 11:05:25', '添加操作', '1');
INSERT INTO `t_log` VALUES ('2244', '查询商品信息', '2017-10-30 11:05:27', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2245', '查询商品信息', '2017-10-30 11:05:27', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2246', '查询商品信息', '2017-10-30 11:05:51', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2247', '查询商品信息', '2017-10-30 11:05:51', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2248', '查询商品信息', '2017-10-30 11:08:58', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2249', '查询商品信息', '2017-10-30 11:08:58', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2250', '查询商品类别信息', '2017-10-30 11:09:08', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2251', '添加客户退货单', '2017-10-30 11:09:12', '添加操作', '1');
INSERT INTO `t_log` VALUES ('2252', '查询商品信息', '2017-10-30 11:09:13', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2253', '查询商品信息', '2017-10-30 11:09:13', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2254', '用户登录', '2017-10-30 12:06:06', '登录操作', '1');
INSERT INTO `t_log` VALUES ('2255', '查询商品库存信息', '2017-10-30 12:06:07', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2256', '查询商品库存信息', '2017-10-30 12:15:05', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2257', '用户登录', '2017-10-30 12:15:23', '登录操作', '1');
INSERT INTO `t_log` VALUES ('2258', '查询商品库存信息', '2017-10-30 12:15:24', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2259', '用户登录', '2017-10-30 12:16:19', '登录操作', '1');
INSERT INTO `t_log` VALUES ('2260', '查询商品库存信息', '2017-10-30 12:16:19', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2261', '用户登录', '2017-10-30 12:31:48', '登录操作', '1');
INSERT INTO `t_log` VALUES ('2262', '查询商品库存信息', '2017-10-30 12:31:49', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2263', '查询商品信息', '2017-10-30 12:33:08', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2264', '查询商品信息', '2017-10-30 12:33:08', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2265', '查询商品类别信息', '2017-10-30 12:33:12', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2266', '查询商品信息', '2017-10-30 12:33:17', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2267', '添加销售单', '2017-10-30 12:33:24', '添加操作', '1');
INSERT INTO `t_log` VALUES ('2268', '查询商品信息', '2017-10-30 12:33:26', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2269', '查询商品信息', '2017-10-30 12:33:26', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2270', '查询商品信息', '2017-10-30 12:33:53', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2271', '查询商品信息', '2017-10-30 12:33:53', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2272', '查询商品类别信息', '2017-10-30 12:34:01', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2273', '添加客户退货单', '2017-10-30 12:34:17', '添加操作', '1');
INSERT INTO `t_log` VALUES ('2274', '查询商品信息', '2017-10-30 12:34:19', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2275', '查询商品信息', '2017-10-30 12:34:19', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2276', '用户登录', '2017-10-30 18:20:23', '登录操作', '1');
INSERT INTO `t_log` VALUES ('2277', '查询商品库存信息', '2017-10-30 18:20:23', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2278', '用户登录', '2017-10-31 10:49:39', '登录操作', '1');
INSERT INTO `t_log` VALUES ('2279', '查询商品库存信息', '2017-10-31 10:49:40', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2280', '用户注销', '2017-10-31 10:50:19', '注销操作', '1');
INSERT INTO `t_log` VALUES ('2281', '用户登录', '2017-10-31 10:50:23', '登录操作', '1');
INSERT INTO `t_log` VALUES ('2282', '查询商品库存信息', '2017-10-31 10:50:23', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2283', '查询商品类别信息', '2017-10-31 11:02:29', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2284', '查询商品信息', '2017-10-31 11:04:10', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2285', '查询商品信息', '2017-10-31 11:04:10', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2286', '查询商品库存信息', '2017-10-31 11:04:12', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2287', '查询商品类别信息', '2017-10-31 11:07:16', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2288', '用户注销', '2017-10-31 11:20:24', '注销操作', '1');
INSERT INTO `t_log` VALUES ('2289', '用户登录', '2017-10-31 11:21:19', '登录操作', '1');
INSERT INTO `t_log` VALUES ('2290', '查询商品库存信息', '2017-10-31 11:21:20', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2291', '查询商品信息', '2017-10-31 11:22:11', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2292', '查询商品信息', '2017-10-31 11:22:11', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2293', '查询角色信息', '2017-10-31 11:22:14', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2294', '查询角色信息', '2017-10-31 11:22:14', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2295', '查询用户信息', '2017-10-31 11:22:21', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2296', '查询用户信息', '2017-10-31 11:22:21', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2297', '查询所有角色信息', '2017-10-31 11:22:22', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2298', '查询商品类别信息', '2017-10-31 11:22:45', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2299', '查询商品类别信息', '2017-10-31 11:22:55', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2300', '查询供应商信息', '2017-10-31 11:23:06', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2301', '查询供应商信息', '2017-10-31 11:23:06', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2302', '查询客户信息', '2017-10-31 11:23:07', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2303', '查询客户信息', '2017-10-31 11:23:07', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2304', '查询商品类别信息', '2017-10-31 11:23:10', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2305', '查询商品单位信息', '2017-10-31 11:23:10', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2306', '查询商品信息', '2017-10-31 11:23:10', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2307', '查询商品信息', '2017-10-31 11:23:10', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2308', '查询商品类别信息', '2017-10-31 11:23:13', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2309', '查询商品库存信息', '2017-10-31 11:37:13', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2310', '用户登录', '2017-10-31 12:10:54', '登录操作', '1');
INSERT INTO `t_log` VALUES ('2311', '查询商品库存信息', '2017-10-31 12:10:54', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2312', '查询商品库存信息', '2017-10-31 12:13:32', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2313', '用户登录', '2017-10-31 12:21:21', '登录操作', '1');
INSERT INTO `t_log` VALUES ('2314', '查询商品库存信息', '2017-10-31 12:21:22', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2315', '用户登录', '2017-10-31 16:28:16', '登录操作', '1');
INSERT INTO `t_log` VALUES ('2316', '查询商品库存信息', '2017-10-31 16:28:16', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2317', '用户登录', '2017-10-31 16:50:55', '登录操作', '1');
INSERT INTO `t_log` VALUES ('2318', '查询商品库存信息', '2017-10-31 16:50:56', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2319', '用户登录', '2017-10-31 16:55:11', '登录操作', '1');
INSERT INTO `t_log` VALUES ('2320', '查询商品库存信息', '2017-10-31 16:55:12', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2321', '用户登录', '2017-10-31 17:06:04', '登录操作', '1');
INSERT INTO `t_log` VALUES ('2322', '查询商品库存信息', '2017-10-31 17:06:05', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2323', '用户登录', '2017-10-31 17:06:36', '登录操作', '1');
INSERT INTO `t_log` VALUES ('2324', '查询商品库存信息', '2017-10-31 17:06:37', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2325', '用户登录', '2017-10-31 17:13:40', '登录操作', '1');
INSERT INTO `t_log` VALUES ('2326', '查询商品库存信息', '2017-10-31 17:13:41', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2327', '查询商品信息', '2017-10-31 17:13:52', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2328', '查询商品信息', '2017-10-31 17:13:52', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2329', '查询商品信息', '2017-10-31 17:13:59', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2330', '查询商品信息', '2017-10-31 17:13:59', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2331', '查询商品类别信息', '2017-10-31 17:14:00', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2332', '添加进货单', '2017-10-31 17:14:12', '添加操作', '1');
INSERT INTO `t_log` VALUES ('2333', '查询商品信息', '2017-10-31 17:14:14', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2334', '查询商品信息', '2017-10-31 17:14:14', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2335', '用户登录', '2017-10-31 17:24:29', '登录操作', '1');
INSERT INTO `t_log` VALUES ('2336', '查询商品库存信息', '2017-10-31 17:24:30', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2337', '用户登录', '2017-10-31 17:27:32', '登录操作', '1');
INSERT INTO `t_log` VALUES ('2338', '查询商品库存信息', '2017-10-31 17:27:32', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2339', '用户登录', '2017-10-31 17:31:43', '登录操作', '1');
INSERT INTO `t_log` VALUES ('2340', '查询商品库存信息', '2017-10-31 17:31:44', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2341', '查询商品类别信息', '2017-10-31 17:44:53', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2342', '用户登录', '2017-10-31 18:19:21', '登录操作', '1');
INSERT INTO `t_log` VALUES ('2343', '查询商品库存信息', '2017-10-31 18:19:21', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2344', '用户登录', '2017-10-31 18:23:15', '登录操作', '1');
INSERT INTO `t_log` VALUES ('2345', '查询商品库存信息', '2017-10-31 18:23:16', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2346', '用户登录', '2017-10-31 18:42:43', '登录操作', '1');
INSERT INTO `t_log` VALUES ('2347', '查询商品库存信息', '2017-10-31 18:42:44', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2348', '用户登录', '2017-10-31 20:04:44', '登录操作', '1');
INSERT INTO `t_log` VALUES ('2349', '查询商品库存信息', '2017-10-31 20:04:45', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2350', '用户登录', '2017-10-31 20:07:13', '登录操作', '1');
INSERT INTO `t_log` VALUES ('2351', '查询商品库存信息', '2017-10-31 20:07:14', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2352', '用户登录', '2017-10-31 20:08:07', '登录操作', '1');
INSERT INTO `t_log` VALUES ('2353', '查询商品库存信息', '2017-10-31 20:08:07', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2354', '用户登录', '2017-10-31 20:12:51', '登录操作', '1');
INSERT INTO `t_log` VALUES ('2355', '查询商品库存信息', '2017-10-31 20:12:52', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2356', '查询商品库存信息', '2017-10-31 20:13:39', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2357', '查询商品库存信息', '2017-10-31 20:17:50', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2358', '查询商品类别信息', '2017-10-31 20:26:50', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2359', '查询商品类别信息', '2017-10-31 20:26:59', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2360', '查询商品类别信息', '2017-10-31 20:28:35', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2361', '查询商品类别信息', '2017-10-31 20:28:39', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2362', '用户登录', '2017-11-01 17:38:14', '登录操作', '1');
INSERT INTO `t_log` VALUES ('2363', '查询商品库存信息', '2017-11-01 17:38:15', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2364', '用户登录', '2017-11-01 18:21:17', '登录操作', '1');
INSERT INTO `t_log` VALUES ('2365', '查询商品库存信息', '2017-11-01 18:21:17', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2366', '查询商品信息', '2017-11-01 18:26:37', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2367', '查询商品信息', '2017-11-01 18:26:37', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2368', '查询商品类别信息', '2017-11-01 18:26:40', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2369', '添加销售单', '2017-11-01 18:28:03', '添加操作', '1');
INSERT INTO `t_log` VALUES ('2370', '查询商品信息', '2017-11-01 18:28:04', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2371', '查询商品信息', '2017-11-01 18:28:04', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2372', '查询商品类别信息', '2017-11-01 18:30:24', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2373', '查询商品类别信息', '2017-11-01 18:30:32', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2374', '添加销售单', '2017-11-01 18:30:53', '添加操作', '1');
INSERT INTO `t_log` VALUES ('2375', '查询商品信息', '2017-11-01 18:30:54', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2376', '查询商品信息', '2017-11-01 18:30:54', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2377', '查询商品类别信息', '2017-11-01 18:33:10', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2378', '查询商品类别信息', '2017-11-01 18:33:17', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2379', '添加销售单', '2017-11-01 18:33:28', '添加操作', '1');
INSERT INTO `t_log` VALUES ('2380', '查询商品信息', '2017-11-01 18:33:30', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2381', '查询商品信息', '2017-11-01 18:33:30', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2382', '用户登录', '2017-11-01 20:01:18', '登录操作', '1');
INSERT INTO `t_log` VALUES ('2383', '查询商品库存信息', '2017-11-01 20:01:18', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2384', '用户登录', '2017-11-01 20:02:43', '登录操作', '1');
INSERT INTO `t_log` VALUES ('2385', '查询商品库存信息', '2017-11-01 20:02:44', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2386', '用户登录', '2017-11-01 20:11:52', '登录操作', '1');
INSERT INTO `t_log` VALUES ('2387', '查询商品库存信息', '2017-11-01 20:11:52', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2388', '用户登录', '2017-11-01 20:13:32', '登录操作', '1');
INSERT INTO `t_log` VALUES ('2389', '查询商品库存信息', '2017-11-01 20:13:32', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2390', '用户登录', '2017-11-01 20:19:35', '登录操作', '1');
INSERT INTO `t_log` VALUES ('2391', '查询商品库存信息', '2017-11-01 20:19:35', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2392', '用户登录', '2017-11-01 20:20:35', '登录操作', '1');
INSERT INTO `t_log` VALUES ('2393', '查询商品库存信息', '2017-11-01 20:20:36', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2394', '用户登录', '2017-11-01 20:22:19', '登录操作', '1');
INSERT INTO `t_log` VALUES ('2395', '查询商品库存信息', '2017-11-01 20:22:19', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2396', '用户登录', '2017-11-01 20:23:31', '登录操作', '1');
INSERT INTO `t_log` VALUES ('2397', '查询商品库存信息', '2017-11-01 20:23:32', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2398', '用户登录', '2017-11-01 20:24:04', '登录操作', '1');
INSERT INTO `t_log` VALUES ('2399', '查询商品库存信息', '2017-11-01 20:24:05', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2400', '用户登录', '2017-11-01 20:25:38', '登录操作', '1');
INSERT INTO `t_log` VALUES ('2401', '查询商品库存信息', '2017-11-01 20:25:38', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2402', '用户登录', '2017-11-01 20:28:01', '登录操作', '1');
INSERT INTO `t_log` VALUES ('2403', '查询商品库存信息', '2017-11-01 20:28:02', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2404', '用户登录', '2017-11-01 20:35:00', '登录操作', '1');
INSERT INTO `t_log` VALUES ('2405', '查询商品库存信息', '2017-11-01 20:35:01', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2406', '用户登录', '2017-11-01 20:35:55', '登录操作', '1');
INSERT INTO `t_log` VALUES ('2407', '查询商品库存信息', '2017-11-01 20:35:55', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2408', '用户登录', '2017-11-02 10:10:14', '登录操作', '1');
INSERT INTO `t_log` VALUES ('2409', '查询商品库存信息', '2017-11-02 10:10:15', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2410', '用户登录', '2017-11-02 14:31:46', '登录操作', '1');
INSERT INTO `t_log` VALUES ('2411', '查询商品库存信息', '2017-11-02 14:31:47', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2412', '查询商品信息', '2017-11-02 14:31:57', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2413', '查询商品信息', '2017-11-02 14:31:57', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2414', '查询商品信息', '2017-11-02 14:31:58', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2415', '查询商品信息', '2017-11-02 14:31:58', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2416', '查询商品信息', '2017-11-02 14:32:31', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2417', '查询商品信息', '2017-11-02 14:32:31', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2418', '用户登录', '2017-11-02 18:17:40', '登录操作', '1');
INSERT INTO `t_log` VALUES ('2419', '查询商品库存信息', '2017-11-02 18:17:41', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2420', '查询商品信息', '2017-11-02 18:28:44', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2421', '查询商品信息', '2017-11-02 18:28:44', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2422', '用户登录', '2017-11-02 19:01:25', '登录操作', '1');
INSERT INTO `t_log` VALUES ('2423', '查询商品库存信息', '2017-11-02 19:01:25', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2424', '用户登录', '2017-11-02 19:03:17', '登录操作', '1');
INSERT INTO `t_log` VALUES ('2425', '查询商品库存信息', '2017-11-02 19:03:18', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2426', '查询商品信息', '2017-11-02 19:03:21', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2427', '查询商品信息', '2017-11-02 19:03:21', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2428', '查询商品库存信息', '2017-11-02 20:17:58', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2429', '查询商品库存信息', '2017-11-02 20:18:22', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2430', '查询商品库存信息', '2017-11-02 20:18:23', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2431', '查询商品库存信息', '2017-11-02 20:20:06', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2432', '用户登录', '2017-11-03 09:12:17', '登录操作', '1');
INSERT INTO `t_log` VALUES ('2433', '查询商品库存信息', '2017-11-03 09:12:18', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2434', '用户登录', '2017-11-03 09:33:36', '登录操作', '1');
INSERT INTO `t_log` VALUES ('2435', '查询商品库存信息', '2017-11-03 09:33:37', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2436', '查询商品库存信息', '2017-11-03 09:36:05', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2437', '查询商品库存信息', '2017-11-03 09:36:06', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2438', '查询商品库存信息', '2017-11-03 09:36:15', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2439', '查询商品库存信息', '2017-11-03 09:36:17', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2440', '查询商品库存信息', '2017-11-03 10:10:08', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2441', '查询商品库存信息', '2017-11-03 10:10:08', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2442', '查询商品库存信息', '2017-11-03 10:10:09', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2443', '查询商品库存信息', '2017-11-03 10:23:04', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2444', '用户登录', '2017-11-03 11:17:35', '登录操作', '1');
INSERT INTO `t_log` VALUES ('2445', '查询商品库存信息', '2017-11-03 11:17:35', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2446', '用户登录', '2017-11-03 11:19:20', '登录操作', '1');
INSERT INTO `t_log` VALUES ('2447', '查询商品库存信息', '2017-11-03 11:19:21', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2448', '查询商品库存信息', '2017-11-03 11:20:39', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2449', '用户登录', '2017-11-03 15:18:40', '登录操作', '1');
INSERT INTO `t_log` VALUES ('2450', '查询商品库存信息', '2017-11-03 15:18:40', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2451', '查询商品库存信息', '2017-11-03 15:32:43', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2452', '查询商品库存信息', '2017-11-03 15:32:46', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2453', '查询商品库存信息', '2017-11-03 15:32:48', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2454', '用户登录', '2017-11-03 18:50:34', '登录操作', '1');
INSERT INTO `t_log` VALUES ('2455', '查询商品库存信息', '2017-11-03 18:50:35', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2456', '用户登录', '2017-11-03 18:51:23', '登录操作', '1');
INSERT INTO `t_log` VALUES ('2457', '查询商品库存信息', '2017-11-03 18:51:23', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2458', '查询商品信息', '2017-11-03 18:57:55', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2459', '查询商品信息', '2017-11-03 18:57:55', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2460', '查询商品库存信息', '2017-11-03 18:57:58', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2461', '查询商品类别信息', '2017-11-03 19:02:08', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2462', '查询供应商信息', '2017-11-03 19:03:33', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2463', '查询供应商信息', '2017-11-03 19:03:33', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2464', '添加供应商信息[id=null, name=南京大王科技, contact=小二, number=0112-1426789, address=南京鼓楼区世纪大楼123号, remarks=]', '2017-11-03 19:04:30', '添加操作', '1');
INSERT INTO `t_log` VALUES ('2465', '查询供应商信息', '2017-11-03 19:04:30', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2466', '查询供应商信息', '2017-11-03 19:04:32', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2467', '更新供应商信息[id=12, name=南京大王科技, contact=小二, number=0112-1426789, address=南京鼓楼区世纪大楼123号, remarks=123]', '2017-11-03 19:04:40', '更新操作', '1');
INSERT INTO `t_log` VALUES ('2468', '查询供应商信息', '2017-11-03 19:04:40', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2469', '查询供应商信息', '2017-11-03 19:04:43', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2470', '查询供应商信息', '2017-11-03 19:04:44', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2471', '添加供应商信息[id=null, name=南京大陆食品公司, contact=小吴, number=1243-2135487, address=南京将军路800号, remarks=cc]', '2017-11-03 19:13:43', '添加操作', '1');
INSERT INTO `t_log` VALUES ('2472', '查询供应商信息', '2017-11-03 19:13:43', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2473', '添加供应商信息[id=null, name=ew, contact=ewq, number=ewq, address=ewq, remarks=ewq]', '2017-11-03 19:14:47', '添加操作', '1');
INSERT INTO `t_log` VALUES ('2474', '查询供应商信息', '2017-11-03 19:14:47', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2475', '删除供应商信息[id=14, name=ew, contact=ewq, number=ewq, address=ewq, remarks=ewq]', '2017-11-03 19:14:53', '删除操作', '1');
INSERT INTO `t_log` VALUES ('2476', '查询供应商信息', '2017-11-03 19:14:53', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2477', '查询供应商信息', '2017-11-03 19:14:59', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2478', '查询客户信息', '2017-11-03 19:15:02', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2479', '查询客户信息', '2017-11-03 19:15:02', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2480', '添加客户信息[id=null, name=21, contact=321, number=312, address=321, remarks=23]', '2017-11-03 19:19:34', '添加操作', '1');
INSERT INTO `t_log` VALUES ('2481', '查询客户信息', '2017-11-03 19:19:34', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2482', '更新客户信息[id=5, name=21, contact=321, number=312, address=321, remarks=232]', '2017-11-03 19:19:38', '更新操作', '1');
INSERT INTO `t_log` VALUES ('2483', '查询客户信息', '2017-11-03 19:19:39', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2484', '更新客户信息[id=5, name=212, contact=3212, number=3122, address=3212, remarks=2322]', '2017-11-03 19:19:45', '更新操作', '1');
INSERT INTO `t_log` VALUES ('2485', '查询客户信息', '2017-11-03 19:19:45', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2486', '删除客户信息[id=5, name=212, contact=3212, number=3122, address=3212, remarks=2322]', '2017-11-03 19:19:47', '删除操作', '1');
INSERT INTO `t_log` VALUES ('2487', '查询客户信息', '2017-11-03 19:19:47', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2488', '查询客户信息', '2017-11-03 19:19:53', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2489', '查询商品类别信息', '2017-11-03 19:22:25', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2490', '查询商品信息', '2017-11-03 19:22:25', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2491', '查询商品单位信息', '2017-11-03 19:22:25', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2492', '查询商品信息', '2017-11-03 19:22:25', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2493', '查询商品信息', '2017-11-03 19:22:26', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2494', '查询商品信息', '2017-11-03 19:22:27', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2495', '查询商品信息', '2017-11-03 19:22:27', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2496', '查询商品信息', '2017-11-03 19:22:28', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2497', '查询商品信息', '2017-11-03 19:22:28', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2498', '查询商品信息', '2017-11-03 19:22:29', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2499', '查询商品信息', '2017-11-03 19:22:30', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2500', '查询商品信息', '2017-11-03 19:22:30', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2501', '查询商品信息', '2017-11-03 19:22:32', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2502', '查询商品信息', '2017-11-03 19:22:33', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2503', '查询商品信息', '2017-11-03 19:22:34', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2504', '查询商品信息', '2017-11-03 19:22:35', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2505', '查询商品信息', '2017-11-03 19:22:35', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2506', '查询商品信息', '2017-11-03 19:22:36', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2507', '查询商品信息', '2017-11-03 19:22:37', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2508', '查询商品信息', '2017-11-03 19:22:37', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2509', '查询商品信息', '2017-11-03 19:22:37', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2510', '查询商品信息', '2017-11-03 19:22:38', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2511', '查询商品信息', '2017-11-03 19:22:44', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2512', '添加商品类别信息[id=null, name=xx, state=0, icon=icon-folder, pId=1]', '2017-11-03 19:22:51', '添加操作', '1');
INSERT INTO `t_log` VALUES ('2513', '查询商品类别信息', '2017-11-03 19:22:51', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2514', '查询商品信息', '2017-11-03 19:22:54', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2515', '添加商品类别信息[id=null, name=22, state=0, icon=icon-folder, pId=18]', '2017-11-03 19:22:58', '添加操作', '1');
INSERT INTO `t_log` VALUES ('2516', '查询商品类别信息', '2017-11-03 19:22:58', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2517', '查询商品信息', '2017-11-03 19:23:00', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2518', '查询商品信息', '2017-11-03 19:23:01', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2519', '删除商品类别信息[id=19, name=22, state=0, icon=icon-folder, pId=18]', '2017-11-03 19:23:02', '删除操作', '1');
INSERT INTO `t_log` VALUES ('2520', '查询商品类别信息', '2017-11-03 19:23:02', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2521', '查询商品信息', '2017-11-03 19:23:03', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2522', '删除商品类别信息[id=18, name=xx, state=0, icon=icon-folder, pId=1]', '2017-11-03 19:23:04', '删除操作', '1');
INSERT INTO `t_log` VALUES ('2523', '查询商品类别信息', '2017-11-03 19:23:04', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2524', '查询商品信息', '2017-11-03 19:23:34', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2525', '查询商品信息', '2017-11-03 19:23:34', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2526', '查询商品信息', '2017-11-03 19:23:35', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2527', '查询商品信息', '2017-11-03 19:23:35', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2528', '查询商品信息', '2017-11-03 19:23:36', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2529', '查询商品信息', '2017-11-03 19:23:41', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2530', '查询商品信息', '2017-11-03 19:23:43', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2531', '查询商品类别信息', '2017-11-03 19:23:51', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2532', '添加商品单位信息[id=null, name=2]', '2017-11-03 19:25:11', '添加操作', '1');
INSERT INTO `t_log` VALUES ('2533', '查询商品单位信息', '2017-11-03 19:25:11', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2534', '查询商品类别信息', '2017-11-03 19:25:18', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2535', '删除商品单位信息[id=10, name=2]', '2017-11-03 19:25:26', '删除操作', '1');
INSERT INTO `t_log` VALUES ('2536', '查询商品单位信息', '2017-11-03 19:25:26', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2537', '添加商品信息[id=null, code=0015, name=xx, model=fds, unit=盒, purchasingPrice=50.0, sellingPrice=100.0, inventoryQuantity=0, minNum=20, producer=21, remarks=321]', '2017-11-03 19:25:36', '添加操作', '1');
INSERT INTO `t_log` VALUES ('2538', '查询商品信息', '2017-11-03 19:25:36', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2539', '查询商品信息', '2017-11-03 19:25:40', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2540', '更新商品信息[id=23, code=0015, name=xx22, model=fds2, unit=盒, purchasingPrice=50.0, sellingPrice=100.0, inventoryQuantity=0, minNum=20, producer=21, remarks=3211]', '2017-11-03 19:35:31', '更新操作', '1');
INSERT INTO `t_log` VALUES ('2541', '查询商品信息', '2017-11-03 19:35:31', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2542', '删除商品信息[id=23, code=0015, name=xx22, model=fds2, unit=盒, purchasingPrice=50.0, sellingPrice=100.0, inventoryQuantity=0, minNum=20, producer=21, remarks=3211]', '2017-11-03 19:35:40', '删除操作', '1');
INSERT INTO `t_log` VALUES ('2543', '查询商品信息', '2017-11-03 19:35:40', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2544', '查询商品信息', '2017-11-03 19:35:50', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2545', '查询商品信息', '2017-11-03 19:35:52', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2546', '查询商品信息', '2017-11-03 19:35:54', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2547', '查询商品信息', '2017-11-03 19:35:56', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2548', '查询商品信息', '2017-11-03 19:35:58', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2549', '查询商品信息（无库存）', '2017-11-03 19:36:02', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2550', '查询商品信息（无库存）', '2017-11-03 19:36:02', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2551', '查询商品信息（有库存）', '2017-11-03 19:36:02', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2552', '查询商品信息（有库存）', '2017-11-03 19:36:02', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2553', '查询商品信息（无库存）', '2017-11-03 19:36:05', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2554', '查询商品信息（无库存）', '2017-11-03 19:36:06', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2555', '查询商品类别信息', '2017-11-03 19:37:53', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2556', '查询商品类别信息', '2017-11-03 19:40:02', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2557', '添加商品信息[id=null, code=0015, name= iPhone X, model=X, unit=台, purchasingPrice=8000.0, sellingPrice=9500.0, inventoryQuantity=0, minNum=100, producer=xx, remarks=xxx]', '2017-11-03 19:40:22', '添加操作', '1');
INSERT INTO `t_log` VALUES ('2558', '查询商品信息', '2017-11-03 19:40:22', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2559', '查询商品信息', '2017-11-03 19:40:24', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2560', '查询商品信息', '2017-11-03 19:40:25', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2561', '查询商品信息', '2017-11-03 19:40:29', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2562', '更新商品信息[id=24, code=0015, name= iPhone X, model=X, unit=台, purchasingPrice=8000.0, sellingPrice=9500.0, inventoryQuantity=0, minNum=100, producer=xx2, remarks=xxx2]', '2017-11-03 19:40:32', '更新操作', '1');
INSERT INTO `t_log` VALUES ('2563', '查询商品信息', '2017-11-03 19:40:32', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2564', '查询商品信息（无库存）', '2017-11-03 19:40:37', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2565', '查询商品信息（无库存）', '2017-11-03 19:40:40', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2566', '查询商品信息（无库存）', '2017-11-03 19:40:40', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2567', '查询商品信息（无库存）', '2017-11-03 19:40:42', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2568', '查询商品信息（无库存）', '2017-11-03 19:40:43', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2569', '修改商品[id=24, code=0015, name= iPhone X, model=X, unit=台, purchasingPrice=8000.0, sellingPrice=9500.0, inventoryQuantity=50, minNum=100, producer=xx2, remarks=xxx2]，价格=8000.0,库存=50', '2017-11-03 19:41:01', '更新操作', '1');
INSERT INTO `t_log` VALUES ('2570', '查询商品信息（无库存）', '2017-11-03 19:41:01', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2571', '查询商品信息（有库存）', '2017-11-03 19:41:01', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2572', '查询商品信息（有库存）', '2017-11-03 19:41:04', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2573', '查询商品信息（无库存）', '2017-11-03 19:41:13', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2574', '查询商品信息（有库存）', '2017-11-03 19:41:13', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2575', '查询商品类别信息', '2017-11-03 19:46:21', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2576', '查询商品信息', '2017-11-03 19:46:21', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2577', '查询商品单位信息', '2017-11-03 19:46:21', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2578', '查询商品信息', '2017-11-03 19:46:21', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2579', '查询商品单位信息', '2017-11-03 19:46:21', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2580', '查询商品类别信息', '2017-11-03 19:46:28', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2581', '查询角色信息', '2017-11-03 19:47:11', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2582', '查询角色信息', '2017-11-03 19:47:11', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2583', '添加角色信息[id=null, name=xx, remarks=]', '2017-11-03 19:47:20', '添加操作', '1');
INSERT INTO `t_log` VALUES ('2584', '查询角色信息', '2017-11-03 19:47:20', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2585', '添加角色信息[id=null, name=xx2, remarks=x]', '2017-11-03 19:47:24', '添加操作', '1');
INSERT INTO `t_log` VALUES ('2586', '查询角色信息', '2017-11-03 19:47:24', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2587', '更新角色信息[id=11, name=xx23, remarks=x3]', '2017-11-03 19:47:29', '更新操作', '1');
INSERT INTO `t_log` VALUES ('2588', '查询角色信息', '2017-11-03 19:47:29', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2589', '删除角色信息[id=11, name=xx23, remarks=x3]', '2017-11-03 19:47:42', '删除操作', '1');
INSERT INTO `t_log` VALUES ('2590', '查询角色信息', '2017-11-03 19:47:42', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2591', '删除角色信息[id=10, name=xx, remarks=]', '2017-11-03 19:47:45', '删除操作', '1');
INSERT INTO `t_log` VALUES ('2592', '查询角色信息', '2017-11-03 19:47:45', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2593', '保存角色权限设置', '2017-11-03 19:48:30', '添加操作', '1');
INSERT INTO `t_log` VALUES ('2594', '查询角色信息', '2017-11-03 19:48:40', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2595', '查询角色信息', '2017-11-03 19:48:42', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2596', '查询用户信息', '2017-11-03 19:48:51', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2597', '查询用户信息', '2017-11-03 19:48:51', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2598', '查询所有角色信息', '2017-11-03 19:48:56', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2599', '查询所有角色信息', '2017-11-03 19:49:02', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2600', '保存用户角色设置', '2017-11-03 19:49:03', '更新操作', '1');
INSERT INTO `t_log` VALUES ('2601', '查询用户信息', '2017-11-03 19:49:03', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2602', '查询所有角色信息', '2017-11-03 19:49:05', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2603', '用户注销', '2017-11-03 19:49:14', '注销操作', '1');
INSERT INTO `t_log` VALUES ('2604', '用户登录', '2017-11-03 19:49:22', '登录操作', '3');
INSERT INTO `t_log` VALUES ('2605', '查询商品库存信息', '2017-11-03 19:49:25', '查询操作', '3');
INSERT INTO `t_log` VALUES ('2606', '查询商品类别信息', '2017-11-03 19:49:45', '查询操作', '3');
INSERT INTO `t_log` VALUES ('2607', '查询商品库存信息', '2017-11-03 19:49:47', '查询操作', '3');
INSERT INTO `t_log` VALUES ('2608', '查询商品类别信息', '2017-11-03 19:49:48', '查询操作', '3');
INSERT INTO `t_log` VALUES ('2609', '查询商品库存信息', '2017-11-03 19:49:51', '查询操作', '3');
INSERT INTO `t_log` VALUES ('2610', '查询商品库存信息', '2017-11-03 19:49:54', '查询操作', '3');
INSERT INTO `t_log` VALUES ('2611', '查询商品库存信息', '2017-11-03 19:49:58', '查询操作', '3');
INSERT INTO `t_log` VALUES ('2612', '查询商品库存信息', '2017-11-03 19:49:59', '查询操作', '3');
INSERT INTO `t_log` VALUES ('2613', '用户登录', '2017-11-03 19:50:15', '登录操作', '3');
INSERT INTO `t_log` VALUES ('2614', '查询商品库存信息', '2017-11-03 19:50:17', '查询操作', '3');
INSERT INTO `t_log` VALUES ('2615', '用户登录', '2017-11-03 19:50:42', '登录操作', '1');
INSERT INTO `t_log` VALUES ('2616', '查询商品库存信息', '2017-11-03 19:50:42', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2617', '用户登录', '2017-11-03 19:56:23', '登录操作', '1');
INSERT INTO `t_log` VALUES ('2618', '查询商品库存信息', '2017-11-03 19:56:24', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2619', '用户登录', '2017-11-03 19:58:41', '登录操作', '1');
INSERT INTO `t_log` VALUES ('2620', '查询商品库存信息', '2017-11-03 19:58:41', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2621', '修改密码', '2017-11-03 20:03:18', '更新操作', '1');
INSERT INTO `t_log` VALUES ('2622', '用户注销', '2017-11-03 20:03:20', '注销操作', '1');
INSERT INTO `t_log` VALUES ('2623', '用户登录', '2017-11-03 20:03:27', '登录操作', '1');
INSERT INTO `t_log` VALUES ('2624', '查询商品库存信息', '2017-11-03 20:03:27', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2625', '查询商品信息', '2017-11-03 20:03:30', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2626', '查询商品信息', '2017-11-03 20:03:30', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2627', '查询商品类别信息', '2017-11-03 20:04:10', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2628', '查询商品信息', '2017-11-03 20:04:12', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2629', '查询商品信息', '2017-11-03 20:04:13', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2630', '查询商品信息', '2017-11-03 20:04:13', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2631', '查询商品信息', '2017-11-03 20:04:14', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2632', '添加商品类别信息[id=null, name=是, state=0, icon=icon-folder, pId=1]', '2017-11-03 20:04:50', '添加操作', '1');
INSERT INTO `t_log` VALUES ('2633', '查询商品类别信息', '2017-11-03 20:04:50', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2634', '查询商品信息', '2017-11-03 20:04:51', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2635', '删除商品类别信息[id=20, name=是, state=0, icon=icon-folder, pId=1]', '2017-11-03 20:04:52', '删除操作', '1');
INSERT INTO `t_log` VALUES ('2636', '查询商品类别信息', '2017-11-03 20:04:52', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2637', '查询商品信息', '2017-11-03 20:05:40', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2638', '查询商品信息', '2017-11-03 20:05:40', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2639', '查询商品信息', '2017-11-03 20:05:41', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2640', '查询商品信息', '2017-11-03 20:05:41', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2641', '查询商品信息', '2017-11-03 20:05:42', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2642', '查询商品信息', '2017-11-03 20:05:43', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2643', '查询商品信息', '2017-11-03 20:05:43', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2644', '查询商品信息', '2017-11-03 20:05:44', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2645', '查询商品信息', '2017-11-03 20:05:44', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2646', '查询商品信息', '2017-11-03 20:05:45', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2647', '添加进货单', '2017-11-03 20:06:22', '添加操作', '1');
INSERT INTO `t_log` VALUES ('2648', '查询商品信息', '2017-11-03 20:06:23', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2649', '查询商品信息', '2017-11-03 20:06:23', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2650', '删除进货单信息null', '2017-11-03 20:07:18', '删除操作', '1');
INSERT INTO `t_log` VALUES ('2651', '查询商品信息', '2017-11-03 20:07:22', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2652', '查询商品信息', '2017-11-03 20:07:22', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2653', '查询商品类别信息', '2017-11-03 20:07:52', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2654', '查询商品信息', '2017-11-03 20:07:58', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2655', '查询商品信息', '2017-11-03 20:08:03', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2656', '查询商品信息', '2017-11-03 20:08:09', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2657', '查询商品信息', '2017-11-03 20:08:09', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2658', '查询商品信息', '2017-11-03 20:08:11', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2659', '查询商品信息', '2017-11-03 20:08:16', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2660', '查询商品信息', '2017-11-03 20:08:17', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2661', '添加进货单', '2017-11-03 20:08:25', '添加操作', '1');
INSERT INTO `t_log` VALUES ('2662', '查询商品信息', '2017-11-03 20:08:26', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2663', '查询商品信息', '2017-11-03 20:08:26', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2664', '查询商品信息', '2017-11-03 20:08:28', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2665', '查询商品信息', '2017-11-03 20:08:28', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2666', '查询商品类别信息', '2017-11-03 20:08:38', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2667', '查询商品信息', '2017-11-03 20:08:43', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2668', '查询商品信息', '2017-11-03 20:08:44', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2669', '查询商品信息', '2017-11-03 20:08:44', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2670', '添加商品类别信息[id=null, name=cc, state=0, icon=icon-folder, pId=1]', '2017-11-03 20:08:47', '添加操作', '1');
INSERT INTO `t_log` VALUES ('2671', '查询商品类别信息', '2017-11-03 20:08:47', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2672', '查询商品信息', '2017-11-03 20:08:48', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2673', '添加商品类别信息[id=null, name=cc, state=0, icon=icon-folder, pId=21]', '2017-11-03 20:08:50', '添加操作', '1');
INSERT INTO `t_log` VALUES ('2674', '查询商品类别信息', '2017-11-03 20:08:50', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2675', '查询商品信息', '2017-11-03 20:08:52', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2676', '查询商品信息', '2017-11-03 20:08:52', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2677', '删除商品类别信息[id=22, name=cc, state=0, icon=icon-folder, pId=21]', '2017-11-03 20:08:53', '删除操作', '1');
INSERT INTO `t_log` VALUES ('2678', '查询商品类别信息', '2017-11-03 20:08:53', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2679', '查询商品信息', '2017-11-03 20:08:53', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2680', '删除商品类别信息[id=21, name=cc, state=0, icon=icon-folder, pId=1]', '2017-11-03 20:08:54', '删除操作', '1');
INSERT INTO `t_log` VALUES ('2681', '查询商品类别信息', '2017-11-03 20:08:54', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2682', '查询商品信息', '2017-11-03 20:08:55', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2683', '查询商品信息', '2017-11-03 20:08:56', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2684', '查询商品信息', '2017-11-03 20:08:56', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2685', '查询商品信息', '2017-11-03 20:08:57', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2686', '查询商品信息', '2017-11-03 20:08:58', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2687', '查询商品信息', '2017-11-03 20:08:59', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2688', '查询商品类别信息', '2017-11-03 20:09:18', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2689', '查询商品信息', '2017-11-03 20:09:18', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2690', '查询商品单位信息', '2017-11-03 20:09:18', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2691', '查询商品信息', '2017-11-03 20:09:18', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2692', '查询商品单位信息', '2017-11-03 20:09:18', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2693', '查询商品信息', '2017-11-03 20:09:25', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2694', '更新商品信息[id=24, code=0015, name= iPhone X, model=X, unit=台, purchasingPrice=8000.0, sellingPrice=9500.0, inventoryQuantity=0, minNum=100, producer=xx2, remarks=xxx2]', '2017-11-03 20:09:41', '更新操作', '1');
INSERT INTO `t_log` VALUES ('2695', '查询商品信息', '2017-11-03 20:09:41', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2696', '更新商品信息[id=24, code=0015, name= iPhone X, model=X, unit=台, purchasingPrice=8000.0, sellingPrice=9500.0, inventoryQuantity=0, minNum=100, producer=xx2, remarks=xxx2]', '2017-11-03 20:09:47', '更新操作', '1');
INSERT INTO `t_log` VALUES ('2697', '查询商品信息', '2017-11-03 20:09:47', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2698', '查询商品信息（无库存）', '2017-11-03 20:09:50', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2699', '查询商品信息（无库存）', '2017-11-03 20:09:50', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2700', '查询商品信息（有库存）', '2017-11-03 20:09:50', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2701', '查询商品信息（有库存）', '2017-11-03 20:09:50', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2702', '修改商品[id=24, code=0015, name= iPhone X, model=X, unit=台, purchasingPrice=8000.0, sellingPrice=9500.0, inventoryQuantity=50, minNum=100, producer=xx2, remarks=xxx2]，价格=8000.0,库存=50', '2017-11-03 20:10:01', '更新操作', '1');
INSERT INTO `t_log` VALUES ('2703', '查询商品信息（有库存）', '2017-11-03 20:10:01', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2704', '查询商品信息（无库存）', '2017-11-03 20:10:01', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2705', '查询商品信息（有库存）', '2017-11-03 20:10:02', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2706', '查询商品信息（有库存）', '2017-11-03 20:10:26', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2707', '查询商品信息（无库存）', '2017-11-03 20:10:26', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2708', '查询商品信息', '2017-11-03 20:10:29', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2709', '查询商品信息', '2017-11-03 20:10:31', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2710', '查询商品类别信息', '2017-11-03 20:10:52', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2711', '查询商品信息', '2017-11-03 20:10:55', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2712', '查询商品信息', '2017-11-03 20:11:21', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2713', '查询客户信息', '2017-11-03 20:20:52', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2714', '查询客户信息', '2017-11-03 20:20:52', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2715', '查询商品类别信息', '2017-11-03 20:21:20', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2716', '查询商品单位信息', '2017-11-03 20:21:20', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2717', '查询商品信息', '2017-11-03 20:21:20', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2718', '查询商品信息', '2017-11-03 20:21:20', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2719', '查询商品单位信息', '2017-11-03 20:21:20', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2720', '查询商品类别信息', '2017-11-03 20:21:22', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2721', '添加商品信息[id=null, code=0016, name=21, model=X, unit=盒, purchasingPrice=100.0, sellingPrice=120.0, inventoryQuantity=0, minNum=12, producer=32, remarks=21]', '2017-11-03 20:21:42', '添加操作', '1');
INSERT INTO `t_log` VALUES ('2722', '查询商品信息', '2017-11-03 20:21:42', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2723', '查询商品信息（无库存）', '2017-11-03 20:22:00', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2724', '查询商品信息（有库存）', '2017-11-03 20:22:00', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2725', '查询商品信息（无库存）', '2017-11-03 20:22:00', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2726', '查询商品信息（有库存）', '2017-11-03 20:22:00', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2727', '修改商品[id=25, code=0016, name=21, model=X, unit=盒, purchasingPrice=100.0, sellingPrice=120.0, inventoryQuantity=100, minNum=12, producer=32, remarks=21]，价格=100.0,库存=100', '2017-11-03 20:22:15', '更新操作', '1');
INSERT INTO `t_log` VALUES ('2728', '查询商品信息（无库存）', '2017-11-03 20:22:15', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2729', '查询商品信息（有库存）', '2017-11-03 20:22:15', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2730', '查询商品信息（有库存）', '2017-11-03 20:22:24', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2731', '查询商品信息（有库存）', '2017-11-03 20:22:26', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2732', '查询商品信息（无库存）', '2017-11-03 20:22:26', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2733', '查询商品类别信息', '2017-11-03 20:22:58', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2734', '添加退货单', '2017-11-03 20:23:15', '添加操作', '1');
INSERT INTO `t_log` VALUES ('2735', '查询商品信息', '2017-11-03 20:23:16', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2736', '查询商品信息', '2017-11-03 20:23:16', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2737', '查询商品类别信息', '2017-11-03 20:24:08', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2738', '查询商品类别信息', '2017-11-03 20:36:59', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2739', '查询商品单位信息', '2017-11-03 20:37:00', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2740', '查询商品信息', '2017-11-03 20:37:00', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2741', '查询商品信息', '2017-11-03 20:37:00', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2742', '查询商品单位信息', '2017-11-03 20:37:00', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2743', '查询商品类别信息', '2017-11-03 20:37:04', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2744', '查询商品库存信息', '2017-11-03 20:37:21', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2745', '查询商品类别信息', '2017-11-03 20:37:22', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2746', '查询商品库存信息', '2017-11-03 20:37:25', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2747', '查询商品库存信息', '2017-11-03 20:37:26', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2748', '查询商品类别信息', '2017-11-03 20:37:28', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2749', '查询商品库存信息', '2017-11-03 20:37:32', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2750', '查询商品库存信息', '2017-11-03 20:37:35', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2751', '查询商品信息', '2017-11-03 20:37:48', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2752', '添加商品信息[id=null, code=0017, name=Sony/索尼 ILCE-A6000L WIFI微单数码相机高清单电, model=ILCE-A6000L, unit=台, purchasingPrice=3000.0, sellingPrice=3650.0, inventoryQuantity=0, minNum=100, producer=xxx, remarks=xxx]', '2017-11-03 20:44:59', '添加操作', '1');
INSERT INTO `t_log` VALUES ('2753', '查询商品信息', '2017-11-03 20:44:59', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2754', '添加商品信息[id=null, code=0018, name=Canon/佳能 IXUS 285 HS 数码相机 2020万像素高清拍摄, model=IXUS 285 HS, unit=台, purchasingPrice=800.0, sellingPrice=1299.0, inventoryQuantity=0, minNum=400, producer=xx, remarks=xxx]', '2017-11-03 20:45:33', '添加操作', '1');
INSERT INTO `t_log` VALUES ('2755', '查询商品信息', '2017-11-03 20:45:33', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2756', '查询商品信息', '2017-11-03 20:45:41', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2757', '添加商品信息[id=null, code=0019, name=Golden Field/金河田 Q8电脑音响台式多媒体家用音箱低音炮重低音, model=Q8, unit=台, purchasingPrice=60.0, sellingPrice=129.0, inventoryQuantity=0, minNum=300, producer=xxxx, remarks=]', '2017-11-03 20:47:08', '添加操作', '1');
INSERT INTO `t_log` VALUES ('2758', '查询商品信息', '2017-11-03 20:47:08', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2759', '查询商品信息', '2017-11-03 20:47:14', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2760', '查询商品信息', '2017-11-03 20:47:16', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2761', '查询商品信息', '2017-11-03 20:47:16', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2762', '查询商品信息', '2017-11-03 20:47:17', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2763', '查询商品信息', '2017-11-03 20:47:17', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2764', '查询商品信息', '2017-11-03 20:47:17', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2765', '查询商品信息', '2017-11-03 20:47:18', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2766', '添加商品信息[id=null, code=0020, name=Haier/海尔冰箱BCD-190WDPT双门电冰箱大两门冷藏冷冻, model=190WDPT, unit=台, purchasingPrice=1000.0, sellingPrice=1699.0, inventoryQuantity=0, minNum=50, producer=cc, remarks=]', '2017-11-03 20:48:10', '添加操作', '1');
INSERT INTO `t_log` VALUES ('2767', '查询商品信息', '2017-11-03 20:48:10', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2768', '查询商品信息', '2017-11-03 20:48:19', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2769', '查询商品信息', '2017-11-03 20:48:20', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2770', '查询商品信息', '2017-11-03 20:48:21', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2771', '查询商品信息', '2017-11-03 20:48:21', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2772', '添加商品信息[id=null, code=0021, name=Xiaomi/小米 小米电视4A 32英寸 智能液晶平板电视机, model=4A , unit=台, purchasingPrice=700.0, sellingPrice=1199.0, inventoryQuantity=0, minNum=320, producer=cc, remarks=]', '2017-11-03 20:49:11', '添加操作', '1');
INSERT INTO `t_log` VALUES ('2773', '查询商品信息', '2017-11-03 20:49:11', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2774', '查询商品信息', '2017-11-03 20:49:13', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2775', '查询商品信息', '2017-11-03 20:49:14', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2776', '查询商品信息', '2017-11-03 20:49:15', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2777', '添加商品信息[id=null, code=0022, name=TCL XQB55-36SP 5.5公斤全自动波轮迷你小型洗衣机家用单脱抗菌, model=XQB55-36SP, unit=台, purchasingPrice=400.0, sellingPrice=729.0, inventoryQuantity=0, minNum=40, producer=cc, remarks=]', '2017-11-03 20:49:46', '添加操作', '1');
INSERT INTO `t_log` VALUES ('2778', '查询商品信息', '2017-11-03 20:49:46', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2779', '查询商品信息', '2017-11-03 20:49:48', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2780', '查询商品信息', '2017-11-03 20:49:49', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2781', '查询商品信息', '2017-11-03 20:49:49', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2782', '添加商品信息[id=null, code=0023, name=台湾进口膨化零食品张君雅小妹妹日式串烧丸子80g*2, model=80g*2, unit=袋, purchasingPrice=4.0, sellingPrice=15.0, inventoryQuantity=0, minNum=1000, producer=cc, remarks=]', '2017-11-03 20:50:34', '添加操作', '1');
INSERT INTO `t_log` VALUES ('2783', '查询商品信息', '2017-11-03 20:50:34', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2784', '查询商品信息', '2017-11-03 20:50:37', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2785', '查询商品信息', '2017-11-03 20:50:38', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2786', '查询商品信息', '2017-11-03 20:50:38', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2787', '删除商品单位信息[id=9, name=扫]', '2017-11-03 20:51:09', '删除操作', '1');
INSERT INTO `t_log` VALUES ('2788', '查询商品单位信息', '2017-11-03 20:51:09', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2789', '添加商品单位信息[id=null, name=件]', '2017-11-03 20:51:18', '添加操作', '1');
INSERT INTO `t_log` VALUES ('2790', '查询商品单位信息', '2017-11-03 20:51:18', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2791', '添加商品信息[id=null, code=0024, name=卓图女装立领针织格子印花拼接高腰A字裙2017秋冬新款碎花连衣裙, model=A字裙, unit=件, purchasingPrice=168.0, sellingPrice=298.0, inventoryQuantity=0, minNum=10, producer=cc, remarks=]', '2017-11-03 20:51:32', '添加操作', '1');
INSERT INTO `t_log` VALUES ('2792', '查询商品信息', '2017-11-03 20:51:32', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2793', '查询商品信息', '2017-11-03 20:51:33', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2794', '添加商品信息[id=null, code=0025, name=西服套装男三件套秋季新款商务修身职业正装男士西装新郎结婚礼服, model=三件套秋, unit=件, purchasingPrice=189.0, sellingPrice=299.0, inventoryQuantity=0, minNum=10, producer=cc, remarks=]', '2017-11-03 20:52:14', '添加操作', '1');
INSERT INTO `t_log` VALUES ('2795', '查询商品信息', '2017-11-03 20:52:14', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2796', '查询商品信息', '2017-11-03 20:52:15', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2797', '添加商品单位信息[id=null, name=条]', '2017-11-03 20:52:50', '添加操作', '1');
INSERT INTO `t_log` VALUES ('2798', '查询商品单位信息', '2017-11-03 20:52:50', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2799', '添加商品信息[id=null, code=0026, name=加绒加厚正品AFS JEEP/战地吉普男大码长裤植绒保暖男士牛仔裤子, model=AFS JEEP, unit=条, purchasingPrice=60.0, sellingPrice=89.0, inventoryQuantity=0, minNum=10, producer=c, remarks=]', '2017-11-03 20:53:04', '添加操作', '1');
INSERT INTO `t_log` VALUES ('2800', '查询商品信息', '2017-11-03 20:53:04', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2801', '查询商品信息', '2017-11-03 20:53:06', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2802', '查询商品信息', '2017-11-03 20:53:06', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2803', '查询商品库存信息', '2017-11-03 20:53:11', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2804', '查询商品库存信息', '2017-11-03 20:53:14', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2805', '查询商品库存信息', '2017-11-03 20:53:15', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2806', '查询商品库存信息', '2017-11-03 20:53:23', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2807', '查询商品库存信息', '2017-11-03 20:53:25', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2808', '查询商品类别信息', '2017-11-03 20:53:47', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2809', '查询商品信息', '2017-11-03 20:53:50', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2810', '添加进货单', '2017-11-03 20:54:04', '添加操作', '1');
INSERT INTO `t_log` VALUES ('2811', '查询商品信息', '2017-11-03 20:54:06', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2812', '查询商品信息', '2017-11-03 20:54:06', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2813', '查询商品库存信息', '2017-11-03 20:54:07', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2814', '查询商品库存信息', '2017-11-03 20:54:11', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2815', '查询商品信息', '2017-11-03 20:54:16', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2816', '查询商品信息', '2017-11-03 20:54:16', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2817', '查询商品类别信息', '2017-11-03 20:54:18', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2818', '查询商品类别信息', '2017-11-03 20:54:28', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2819', '查询商品类别信息', '2017-11-03 20:54:44', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2820', '查询商品类别信息', '2017-11-03 20:54:58', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2821', '添加销售单', '2017-11-03 20:55:08', '添加操作', '1');
INSERT INTO `t_log` VALUES ('2822', '查询商品信息', '2017-11-03 20:55:09', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2823', '查询商品信息', '2017-11-03 20:55:09', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2824', '查询商品信息', '2017-11-03 20:55:09', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2825', '查询商品信息', '2017-11-03 20:55:09', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2826', '查询商品类别信息', '2017-11-03 20:55:10', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2827', '添加客户退货单', '2017-11-03 20:55:18', '添加操作', '1');
INSERT INTO `t_log` VALUES ('2828', '查询商品信息', '2017-11-03 20:55:19', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2829', '查询商品信息', '2017-11-03 20:55:19', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2830', '查询商品类别信息', '2017-11-03 20:55:31', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2831', '添加销售单', '2017-11-03 20:55:35', '添加操作', '1');
INSERT INTO `t_log` VALUES ('2832', '查询商品信息', '2017-11-03 20:55:36', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2833', '查询商品信息', '2017-11-03 20:55:36', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2834', '删除销售单信息null', '2017-11-03 20:56:16', '删除操作', '1');
INSERT INTO `t_log` VALUES ('2835', '查询商品信息', '2017-11-03 20:56:24', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2836', '查询商品信息', '2017-11-03 20:56:24', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2837', '查询商品类别信息', '2017-11-03 20:56:25', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2838', '添加报损单', '2017-11-03 20:56:31', '添加操作', '1');
INSERT INTO `t_log` VALUES ('2839', '查询商品信息', '2017-11-03 20:56:32', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2840', '查询商品信息', '2017-11-03 20:56:32', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2841', '查询商品信息', '2017-11-03 20:56:48', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2842', '查询商品信息', '2017-11-03 20:56:49', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2843', '查询商品类别信息', '2017-11-03 20:58:56', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2844', '添加销售单', '2017-11-03 20:59:10', '添加操作', '1');
INSERT INTO `t_log` VALUES ('2845', '查询商品信息', '2017-11-03 20:59:11', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2846', '查询商品信息', '2017-11-03 20:59:11', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2847', '查询商品类别信息', '2017-11-03 20:59:13', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2848', '查询商品类别信息', '2017-11-03 20:59:18', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2849', '查询商品信息', '2017-11-03 20:59:19', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2850', '查询商品信息', '2017-11-03 20:59:19', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2851', '查询商品信息', '2017-11-03 20:59:20', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2852', '查询商品信息', '2017-11-03 20:59:20', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2853', '添加销售单', '2017-11-03 20:59:28', '添加操作', '1');
INSERT INTO `t_log` VALUES ('2854', '查询商品信息', '2017-11-03 20:59:29', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2855', '查询商品信息', '2017-11-03 20:59:29', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2856', '查询商品类别信息', '2017-11-03 20:59:31', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2857', '添加销售单', '2017-11-03 20:59:37', '添加操作', '1');
INSERT INTO `t_log` VALUES ('2858', '查询商品信息', '2017-11-03 20:59:38', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2859', '查询商品信息', '2017-11-03 20:59:38', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2860', '查询商品类别信息', '2017-11-03 20:59:39', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2861', '添加销售单', '2017-11-03 20:59:48', '添加操作', '1');
INSERT INTO `t_log` VALUES ('2862', '查询商品信息', '2017-11-03 20:59:50', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2863', '查询商品信息', '2017-11-03 20:59:50', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2864', '查询商品类别信息', '2017-11-03 20:59:51', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2865', '添加销售单', '2017-11-03 21:00:01', '添加操作', '1');
INSERT INTO `t_log` VALUES ('2866', '查询商品信息', '2017-11-03 21:00:02', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2867', '查询商品信息', '2017-11-03 21:00:02', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2868', '查询商品类别信息', '2017-11-03 21:00:03', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2869', '添加销售单', '2017-11-03 21:00:16', '添加操作', '1');
INSERT INTO `t_log` VALUES ('2870', '查询商品信息', '2017-11-03 21:00:17', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2871', '查询商品信息', '2017-11-03 21:00:17', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2872', '查询商品类别信息', '2017-11-03 21:00:18', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2873', '添加销售单', '2017-11-03 21:00:27', '添加操作', '1');
INSERT INTO `t_log` VALUES ('2874', '查询商品信息', '2017-11-03 21:00:28', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2875', '查询商品信息', '2017-11-03 21:00:28', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2876', '查询商品类别信息', '2017-11-03 21:06:58', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2877', '查询商品类别信息', '2017-11-03 21:07:06', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2878', '添加销售单', '2017-11-03 21:07:18', '添加操作', '1');
INSERT INTO `t_log` VALUES ('2879', '查询商品信息', '2017-11-03 21:07:20', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2880', '查询商品信息', '2017-11-03 21:07:20', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2881', '查询商品类别信息', '2017-11-03 21:07:30', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2882', '查询商品信息', '2017-11-03 21:07:32', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2883', '添加销售单', '2017-11-03 21:07:43', '添加操作', '1');
INSERT INTO `t_log` VALUES ('2884', '查询商品信息', '2017-11-03 21:07:45', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2885', '查询商品信息', '2017-11-03 21:07:45', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2886', '查询商品类别信息', '2017-11-03 21:07:46', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2887', '添加销售单', '2017-11-03 21:07:53', '添加操作', '1');
INSERT INTO `t_log` VALUES ('2888', '查询商品信息', '2017-11-03 21:07:55', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2889', '查询商品信息', '2017-11-03 21:07:55', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2890', '查询商品类别信息', '2017-11-03 21:07:59', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2891', '查询商品信息', '2017-11-03 21:08:06', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2892', '添加销售单', '2017-11-03 21:08:09', '添加操作', '1');
INSERT INTO `t_log` VALUES ('2893', '查询商品信息', '2017-11-03 21:08:10', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2894', '查询商品信息', '2017-11-03 21:08:10', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2895', '查询商品类别信息', '2017-11-03 21:08:12', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2896', '查询商品类别信息', '2017-11-03 21:08:20', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2897', '查询商品信息', '2017-11-03 21:08:21', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2898', '添加销售单', '2017-11-03 21:08:27', '添加操作', '1');
INSERT INTO `t_log` VALUES ('2899', '查询商品信息', '2017-11-03 21:08:28', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2900', '查询商品信息', '2017-11-03 21:08:28', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2901', '查询商品类别信息', '2017-11-03 21:22:12', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2902', '查询商品类别信息', '2017-11-03 21:22:17', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2903', '查询商品信息', '2017-11-03 21:22:20', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2904', '查询商品信息', '2017-11-03 21:22:20', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2905', '查询商品类别信息', '2017-11-03 21:22:21', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2906', '查询商品库存信息', '2017-11-03 21:22:38', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2907', '查询商品信息', '2017-11-03 21:22:40', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2908', '查询商品信息', '2017-11-03 21:22:40', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2909', '查询商品库存信息', '2017-11-03 21:23:29', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2910', '查询客户信息', '2017-11-03 21:26:49', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2911', '查询客户信息', '2017-11-03 21:26:49', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2912', '查询用户信息', '2017-11-03 21:26:52', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2913', '查询用户信息', '2017-11-03 21:26:52', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2914', '查询角色信息', '2017-11-03 21:26:53', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2915', '查询角色信息', '2017-11-03 21:26:53', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2916', '查询商品信息', '2017-11-03 21:30:47', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2917', '查询商品信息', '2017-11-03 21:30:47', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2918', '查询商品库存信息', '2017-11-03 21:31:11', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2919', '用户登录', '2017-11-07 09:33:56', '登录操作', '1');
INSERT INTO `t_log` VALUES ('2920', '查询商品库存信息', '2017-11-07 09:33:57', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2921', '查询商品信息', '2017-11-07 09:34:07', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2922', '查询商品信息', '2017-11-07 09:34:07', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2923', '查询商品信息', '2017-11-07 09:34:11', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2924', '查询商品信息', '2017-11-07 09:34:11', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2925', '查询商品库存信息', '2017-11-07 09:34:16', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2926', '查询商品类别信息', '2017-11-07 09:34:20', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2927', '查询商品信息', '2017-11-07 09:34:32', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2928', '查询商品信息', '2017-11-07 09:34:32', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2929', '查询商品信息', '2017-11-07 09:34:57', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2930', '查询商品信息', '2017-11-07 09:34:57', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2931', '查询商品信息', '2017-11-07 09:35:01', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2932', '查询商品信息', '2017-11-07 09:35:01', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2933', '查询商品库存信息', '2017-11-07 09:35:10', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2934', '查询供应商信息', '2017-11-07 09:35:37', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2935', '查询供应商信息', '2017-11-07 09:35:37', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2936', '查询客户信息', '2017-11-07 09:35:41', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2937', '查询客户信息', '2017-11-07 09:35:41', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2938', '查询商品类别信息', '2017-11-07 09:35:43', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2939', '查询商品信息', '2017-11-07 09:35:43', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2940', '查询商品单位信息', '2017-11-07 09:35:43', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2941', '查询商品信息', '2017-11-07 09:35:43', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2942', '查询商品单位信息', '2017-11-07 09:35:43', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2943', '查询角色信息', '2017-11-07 09:35:49', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2944', '查询角色信息', '2017-11-07 09:35:49', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2945', '查询用户信息', '2017-11-07 09:35:59', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2946', '查询用户信息', '2017-11-07 09:35:59', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2947', '查询商品信息', '2017-11-07 09:41:36', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2948', '查询商品信息', '2017-11-07 09:41:36', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2949', '查询商品库存信息', '2017-11-07 09:42:06', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2950', '查询商品库存信息', '2017-11-07 09:42:09', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2951', '查询商品库存信息', '2017-11-07 09:42:12', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2952', '查询商品库存信息', '2017-11-07 09:42:14', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2953', '查询商品库存信息', '2017-11-07 09:42:14', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2954', '查询商品库存信息', '2017-11-07 09:42:17', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2955', '查询商品库存信息', '2017-11-07 09:42:21', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2956', '查询商品库存信息', '2017-11-07 09:46:10', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2957', '查询商品信息', '2017-11-07 09:46:13', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2958', '查询商品信息', '2017-11-07 09:46:13', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2959', '查询商品类别信息', '2017-11-07 09:46:18', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2960', '查询商品信息', '2017-11-07 09:46:23', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2961', '查询商品信息', '2017-11-07 09:46:23', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2962', '查询商品信息', '2017-11-07 09:46:31', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2963', '查询商品信息', '2017-11-07 09:46:31', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2964', '用户登录', '2017-11-07 09:48:27', '登录操作', '1');
INSERT INTO `t_log` VALUES ('2965', '查询商品库存信息', '2017-11-07 09:49:07', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2966', '查询商品信息', '2017-11-07 09:49:26', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2967', '查询商品信息', '2017-11-07 09:49:31', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2968', '查询商品信息', '2017-11-07 09:49:53', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2969', '查询商品信息', '2017-11-07 09:49:54', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2970', '查询商品信息', '2017-11-07 09:50:29', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2971', '查询商品信息', '2017-11-07 09:50:29', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2972', '查询角色信息', '2017-11-07 09:50:40', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2973', '查询角色信息', '2017-11-07 09:50:40', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2974', '查询用户信息', '2017-11-07 09:50:48', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2975', '查询用户信息', '2017-11-07 09:50:48', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2976', '查询商品信息', '2017-11-07 09:52:13', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2977', '查询商品信息', '2017-11-07 09:52:14', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2978', '????', '2019-01-18 13:22:11', '????', '1');
INSERT INTO `t_log` VALUES ('2979', '????????', '2019-01-18 13:22:16', '????', '1');
INSERT INTO `t_log` VALUES ('2980', '??????', '2019-01-18 13:22:21', '????', '1');
INSERT INTO `t_log` VALUES ('2981', '??????', '2019-01-18 13:22:21', '????', '1');
INSERT INTO `t_log` VALUES ('2982', '??????', '2019-01-18 13:22:23', '????', '1');
INSERT INTO `t_log` VALUES ('2983', '??????', '2019-01-18 13:22:24', '????', '1');
INSERT INTO `t_log` VALUES ('2984', '????????', '2019-01-18 13:22:27', '????', '1');
INSERT INTO `t_log` VALUES ('2985', '??????', '2019-01-18 13:22:28', '????', '1');
INSERT INTO `t_log` VALUES ('2986', '??????', '2019-01-18 13:22:29', '????', '1');
INSERT INTO `t_log` VALUES ('2987', '??????', '2019-01-18 13:22:48', '????', '1');
INSERT INTO `t_log` VALUES ('2988', '??????', '2019-01-18 13:22:48', '????', '1');
INSERT INTO `t_log` VALUES ('2989', '??????', '2019-01-18 13:22:50', '????', '1');
INSERT INTO `t_log` VALUES ('2990', '??????', '2019-01-18 13:22:50', '????', '1');
INSERT INTO `t_log` VALUES ('2991', '用户登录', '2019-01-18 13:27:25', '登录操作', '1');
INSERT INTO `t_log` VALUES ('2992', '查询商品库存信息', '2019-01-18 13:27:28', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2993', '用户注销', '2019-01-18 13:29:18', '注销操作', '1');
INSERT INTO `t_log` VALUES ('2994', '用户登录', '2019-01-18 13:31:29', '登录操作', '1');
INSERT INTO `t_log` VALUES ('2995', '查询商品库存信息', '2019-01-18 13:31:31', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2996', '查询商品信息', '2019-01-18 13:31:50', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2997', '查询商品信息', '2019-01-18 13:31:51', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2998', '查询商品类别信息', '2019-01-18 13:31:52', '查询操作', '1');
INSERT INTO `t_log` VALUES ('2999', '查询商品信息', '2019-01-18 13:31:56', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3000', '用户注销', '2019-01-18 13:32:09', '注销操作', '1');
INSERT INTO `t_log` VALUES ('3001', '用户登录', '2019-01-18 13:36:53', '登录操作', '1');
INSERT INTO `t_log` VALUES ('3002', '查询商品库存信息', '2019-01-18 13:36:56', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3003', '查询用户信息', '2019-01-18 13:37:39', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3004', '查询用户信息', '2019-01-18 13:37:39', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3005', '查询商品信息', '2019-01-18 13:38:10', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3006', '查询商品信息', '2019-01-18 13:38:10', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3007', '查询商品库存信息', '2019-01-18 13:38:13', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3008', '查询用户信息', '2019-01-18 13:38:15', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3009', '查询用户信息', '2019-01-18 13:38:16', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3010', '查询商品库存信息', '2019-01-18 13:39:57', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3011', '查询商品库存信息', '2019-01-18 13:40:42', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3012', '用户注销', '2019-01-18 13:40:43', '注销操作', '1');
INSERT INTO `t_log` VALUES ('3013', '用户登录', '2019-01-18 13:40:56', '登录操作', '1');
INSERT INTO `t_log` VALUES ('3014', '查询商品库存信息', '2019-01-18 13:40:59', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3015', '查询商品库存信息', '2019-01-18 13:41:02', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3016', '用户登录', '2019-01-18 13:41:46', '登录操作', '1');
INSERT INTO `t_log` VALUES ('3017', '查询商品库存信息', '2019-01-18 13:41:51', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3018', '查询商品库存信息', '2019-01-18 13:42:24', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3019', '查询商品信息', '2019-01-18 13:42:31', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3020', '查询商品信息', '2019-01-18 13:42:32', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3021', '查询商品库存信息', '2019-01-18 13:43:39', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3022', '查询商品库存信息', '2019-01-18 13:43:43', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3023', '查询商品库存信息', '2019-01-18 13:43:47', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3024', '用户注销', '2019-01-18 13:43:50', '注销操作', '1');
INSERT INTO `t_log` VALUES ('3025', '用户登录', '2019-01-18 13:44:04', '登录操作', '1');
INSERT INTO `t_log` VALUES ('3026', '查询商品库存信息', '2019-01-18 13:44:06', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3027', '查询商品信息', '2019-01-18 13:44:24', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3028', '查询商品信息', '2019-01-18 13:44:25', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3029', '查询商品库存信息', '2019-01-18 13:44:30', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3030', '查询商品信息', '2019-01-18 13:44:36', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3031', '查询商品信息', '2019-01-18 13:44:36', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3032', '查询商品信息（无库存）', '2019-01-18 13:45:39', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3033', '查询商品信息（有库存）', '2019-01-18 13:45:39', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3034', '查询商品信息（无库存）', '2019-01-18 13:45:39', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3035', '查询商品信息（有库存）', '2019-01-18 13:45:39', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3036', '用户登录', '2021-02-02 15:13:42', '登录操作', '1');
INSERT INTO `t_log` VALUES ('3037', '查询商品库存信息', '2021-02-02 15:13:44', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3038', '查询商品信息', '2021-02-02 15:13:52', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3039', '查询商品信息', '2021-02-02 15:13:52', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3040', '查询商品信息', '2021-02-02 15:13:56', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3041', '查询商品信息', '2021-02-02 15:13:56', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3042', '查询商品库存信息', '2021-02-02 15:14:01', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3043', '查询商品信息', '2021-02-02 15:14:12', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3044', '查询商品信息', '2021-02-02 15:14:12', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3045', '查询商品信息', '2021-02-02 15:14:15', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3046', '查询商品信息', '2021-02-02 15:14:15', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3047', '查询供应商信息', '2021-02-02 15:14:27', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3048', '查询供应商信息', '2021-02-02 15:14:27', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3049', '查询商品类别信息', '2021-02-02 15:14:27', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3050', '查询商品信息', '2021-02-02 15:14:28', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3051', '查询商品单位信息', '2021-02-02 15:14:28', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3052', '查询商品信息', '2021-02-02 15:14:28', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3053', '查询商品单位信息', '2021-02-02 15:14:28', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3054', '查询角色信息', '2021-02-02 15:15:17', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3055', '查询角色信息', '2021-02-02 15:15:17', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3056', '查询用户信息', '2021-02-02 15:15:18', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3057', '查询用户信息', '2021-02-02 15:15:19', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3058', '查询所有角色信息', '2021-02-02 15:15:40', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3059', '查询商品库存信息', '2021-02-02 15:16:05', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3060', '查询商品库存信息', '2021-02-02 15:16:08', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3061', '用户登录', '2021-02-02 16:59:19', '登录操作', '1');
INSERT INTO `t_log` VALUES ('3062', '查询商品库存信息', '2021-02-02 16:59:20', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3063', '查询商品信息', '2021-02-02 16:59:37', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3064', '查询商品信息', '2021-02-02 16:59:37', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3065', '查询商品库存信息', '2021-02-02 16:59:59', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3066', '查询商品类别信息', '2021-02-02 17:00:14', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3067', '查询商品信息', '2021-02-02 17:00:22', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3068', '查询商品信息', '2021-02-02 17:00:30', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3069', '查询商品信息', '2021-02-02 17:00:32', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3070', '查询商品信息', '2021-02-02 17:00:34', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3071', '查询商品信息', '2021-02-02 17:00:35', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3072', '查询商品信息', '2021-02-02 17:00:36', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3073', '查询商品类别信息', '2021-02-02 17:01:00', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3074', '查询商品信息', '2021-02-02 17:01:04', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3075', '查询商品信息', '2021-02-02 17:01:33', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3076', '查询商品信息', '2021-02-02 17:01:53', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3077', '查询商品信息', '2021-02-02 17:01:53', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3078', '查询商品类别信息', '2021-02-02 17:01:55', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3079', '查询商品信息', '2021-02-02 17:01:59', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3080', '查询商品信息', '2021-02-02 17:02:09', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3081', '查询商品信息', '2021-02-02 17:02:18', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3082', '查询商品信息', '2021-02-02 17:02:23', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3083', '查询商品信息', '2021-02-02 17:02:23', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3084', '查询商品类别信息', '2021-02-02 17:02:26', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3085', '查询商品信息', '2021-02-02 17:02:41', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3086', '查询商品信息', '2021-02-02 17:02:41', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3087', '查询商品类别信息', '2021-02-02 17:02:42', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3088', '查询商品库存信息', '2021-02-02 17:03:10', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3089', '查询供应商信息', '2021-02-02 17:03:12', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3090', '查询供应商信息', '2021-02-02 17:03:12', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3091', '查询客户信息', '2021-02-02 17:03:17', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3092', '查询客户信息', '2021-02-02 17:03:17', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3093', '查询商品类别信息', '2021-02-02 17:03:21', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3094', '查询商品单位信息', '2021-02-02 17:03:21', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3095', '查询商品信息', '2021-02-02 17:03:21', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3096', '查询商品单位信息', '2021-02-02 17:03:21', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3097', '查询商品信息', '2021-02-02 17:03:21', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3098', '查询商品信息', '2021-02-02 17:03:24', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3099', '查询商品信息（无库存）', '2021-02-02 17:03:33', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3100', '查询商品信息（有库存）', '2021-02-02 17:03:33', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3101', '查询商品信息（无库存）', '2021-02-02 17:03:33', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3102', '查询商品信息（有库存）', '2021-02-02 17:03:33', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3103', '查询用户信息', '2021-02-02 17:04:07', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3104', '查询用户信息', '2021-02-02 17:04:07', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3105', '用户登录', '2021-02-03 14:10:30', '登录操作', '1');
INSERT INTO `t_log` VALUES ('3106', '查询商品库存信息', '2021-02-03 14:10:32', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3107', '查询商品库存信息', '2021-02-03 14:10:52', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3108', '查询商品信息', '2021-02-03 14:14:17', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3109', '查询商品信息', '2021-02-03 14:14:17', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3110', '查询商品信息', '2021-02-03 14:14:23', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3111', '查询商品信息', '2021-02-03 14:14:23', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3112', '查询商品库存信息', '2021-02-03 14:14:34', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3113', '查询商品类别信息', '2021-02-03 14:14:42', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3114', '查询商品信息', '2021-02-03 14:14:57', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3115', '查询商品信息', '2021-02-03 14:15:19', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3116', '查询商品类别信息', '2021-02-03 14:15:51', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3117', '查询商品类别信息', '2021-02-03 14:16:18', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3118', '查询供应商信息', '2021-02-03 14:16:46', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3119', '查询供应商信息', '2021-02-03 14:16:46', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3120', '查询客户信息', '2021-02-03 14:16:49', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3121', '查询客户信息', '2021-02-03 14:16:49', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3122', '查询商品类别信息', '2021-02-03 14:16:52', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3123', '查询商品信息', '2021-02-03 14:16:53', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3124', '查询商品单位信息', '2021-02-03 14:16:53', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3125', '查询商品单位信息', '2021-02-03 14:16:53', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3126', '查询商品信息', '2021-02-03 14:16:53', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3127', '查询商品信息（无库存）', '2021-02-03 14:16:57', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3128', '查询商品信息（有库存）', '2021-02-03 14:16:57', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3129', '查询商品信息（无库存）', '2021-02-03 14:16:57', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3130', '查询商品信息（有库存）', '2021-02-03 14:16:57', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3131', '查询角色信息', '2021-02-03 14:17:15', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3132', '查询角色信息', '2021-02-03 14:17:15', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3133', '用户登录', '2021-02-03 15:02:21', '登录操作', '1');
INSERT INTO `t_log` VALUES ('3134', '查询商品库存信息', '2021-02-03 15:02:22', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3135', '用户登录', '2021-02-03 15:31:40', '登录操作', '1');
INSERT INTO `t_log` VALUES ('3136', '查询商品库存信息', '2021-02-03 15:31:41', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3137', '查询商品信息', '2021-02-03 15:31:53', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3138', '查询商品信息', '2021-02-03 15:31:53', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3139', '查询角色信息', '2021-02-03 15:32:09', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3140', '查询角色信息', '2021-02-03 15:32:09', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3141', '查询用户信息', '2021-02-03 15:32:10', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3142', '查询用户信息', '2021-02-03 15:32:10', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3143', '查询商品类别信息', '2021-02-03 15:32:53', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3144', '查询商品信息', '2021-02-03 15:33:26', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3145', '查询商品信息', '2021-02-03 15:33:30', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3146', '查询商品信息', '2021-02-03 15:33:31', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3147', '查询商品信息', '2021-02-03 15:33:32', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3148', '查询商品信息', '2021-02-03 15:33:42', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3149', '查询商品信息', '2021-02-03 15:33:42', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3150', '查询商品类别信息', '2021-02-03 15:33:42', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3151', '查询商品信息', '2021-02-03 15:34:11', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3152', '查询商品信息', '2021-02-03 15:34:11', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3153', '查询商品类别信息', '2021-02-03 15:34:12', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3154', '查询商品库存信息', '2021-02-03 15:34:25', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3155', '查询商品信息', '2021-02-03 15:34:29', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3156', '查询商品信息', '2021-02-03 15:34:29', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3157', '查询商品类别信息', '2021-02-03 15:34:31', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3158', '查询商品信息', '2021-02-03 15:34:34', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3159', '查询商品信息', '2021-02-03 15:34:35', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3160', '查询供应商信息', '2021-02-03 15:34:40', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3161', '查询供应商信息', '2021-02-03 15:34:40', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3162', '查询客户信息', '2021-02-03 15:34:48', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3163', '查询客户信息', '2021-02-03 15:34:48', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3164', '查询商品类别信息', '2021-02-03 15:34:51', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3165', '查询商品单位信息', '2021-02-03 15:34:51', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3166', '查询商品信息', '2021-02-03 15:34:51', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3167', '查询商品单位信息', '2021-02-03 15:34:51', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3168', '查询商品信息', '2021-02-03 15:34:51', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3169', '添加商品类别信息[id=null, name=test, state=0, icon=icon-folder, pId=1]', '2021-02-03 15:35:03', '添加操作', '1');
INSERT INTO `t_log` VALUES ('3170', '查询商品类别信息', '2021-02-03 15:35:03', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3171', '查询商品信息', '2021-02-03 15:35:08', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3172', '查询商品信息', '2021-02-03 15:35:12', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3173', '添加商品类别信息[id=null, name=234234, state=0, icon=icon-folder, pId=18]', '2021-02-03 15:35:17', '添加操作', '1');
INSERT INTO `t_log` VALUES ('3174', '查询商品类别信息', '2021-02-03 15:35:17', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3175', '查询商品信息', '2021-02-03 15:35:19', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3176', '查询商品信息', '2021-02-03 15:35:20', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3177', '删除商品类别信息[id=19, name=234234, state=0, icon=icon-folder, pId=18]', '2021-02-03 15:35:21', '删除操作', '1');
INSERT INTO `t_log` VALUES ('3178', '查询商品类别信息', '2021-02-03 15:35:21', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3179', '查询商品信息', '2021-02-03 15:35:22', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3180', '删除商品类别信息[id=18, name=test, state=0, icon=icon-folder, pId=1]', '2021-02-03 15:35:25', '删除操作', '1');
INSERT INTO `t_log` VALUES ('3181', '查询商品类别信息', '2021-02-03 15:35:25', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3182', '查询商品信息', '2021-02-03 15:35:31', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3183', '查询商品信息', '2021-02-03 15:35:32', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3184', '查询商品信息', '2021-02-03 15:35:34', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3185', '查询商品信息', '2021-02-03 15:35:35', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3186', '查询商品信息', '2021-02-03 15:35:36', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3187', '查询商品信息', '2021-02-03 15:35:37', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3188', '查询商品信息', '2021-02-03 15:35:38', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3189', '查询商品信息', '2021-02-03 15:35:38', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3190', '查询商品信息', '2021-02-03 15:35:54', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3191', '查询商品信息', '2021-02-03 15:35:55', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3192', '查询商品信息', '2021-02-03 15:35:55', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3193', '查询商品信息', '2021-02-03 15:35:59', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3194', '查询商品信息', '2021-02-03 15:36:00', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3195', '查询商品信息', '2021-02-03 15:36:01', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3196', '查询商品信息', '2021-02-03 15:36:02', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3197', '用户登录', '2021-02-05 15:45:00', '登录操作', '1');
INSERT INTO `t_log` VALUES ('3198', '查询商品库存信息', '2021-02-05 15:45:02', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3199', '查询角色信息', '2021-02-05 15:45:13', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3200', '查询角色信息', '2021-02-05 15:45:13', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3201', '查询用户信息', '2021-02-05 15:45:14', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3202', '查询用户信息', '2021-02-05 15:45:14', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3203', '查询商品信息', '2021-02-05 15:46:30', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3204', '查询商品信息', '2021-02-05 15:46:30', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3205', '查询供应商信息', '2021-02-05 15:46:41', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3206', '查询供应商信息', '2021-02-05 15:46:41', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3207', '查询客户信息', '2021-02-05 15:46:42', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3208', '查询客户信息', '2021-02-05 15:46:42', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3209', '查询商品类别信息', '2021-02-05 15:46:42', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3210', '查询商品单位信息', '2021-02-05 15:46:43', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3211', '查询商品信息', '2021-02-05 15:46:43', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3212', '查询商品单位信息', '2021-02-05 15:46:43', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3213', '查询商品信息', '2021-02-05 15:46:43', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3214', '查询商品信息（无库存）', '2021-02-05 15:46:43', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3215', '查询商品信息（有库存）', '2021-02-05 15:46:43', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3216', '查询商品信息（无库存）', '2021-02-05 15:46:43', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3217', '查询商品信息（有库存）', '2021-02-05 15:46:43', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3218', '查询商品信息（有库存）', '2021-02-05 15:47:07', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3219', '用户登录', '2021-02-07 22:08:03', '登录操作', '1');
INSERT INTO `t_log` VALUES ('3220', '查询商品库存信息', '2021-02-07 22:08:05', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3221', '用户登录', '2021-02-18 16:19:55', '登录操作', '1');
INSERT INTO `t_log` VALUES ('3222', '查询商品库存信息', '2021-02-18 16:19:57', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3223', '查询角色信息', '2021-02-18 16:20:06', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3224', '查询角色信息', '2021-02-18 16:20:06', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3225', '查询用户信息', '2021-02-18 16:20:07', '查询操作', '1');
INSERT INTO `t_log` VALUES ('3226', '查询用户信息', '2021-02-18 16:20:07', '查询操作', '1');

-- ----------------------------
-- Table structure for `t_menu`
-- ----------------------------
DROP TABLE IF EXISTS `t_menu`;
CREATE TABLE `t_menu` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `icon` varchar(100) DEFAULT NULL COMMENT '菜单图标',
  `name` varchar(50) DEFAULT NULL COMMENT '菜单名称',
  `state` int(11) DEFAULT NULL COMMENT '节点类型',
  `url` varchar(200) DEFAULT NULL COMMENT '菜单url',
  `p_id` int(11) DEFAULT NULL COMMENT '上级菜单id',
  `acl_value` varchar(255) DEFAULT NULL COMMENT '权限码',
  `grade` int(255) DEFAULT NULL COMMENT '菜单层级',
  `is_del` int(11) DEFAULT '0' COMMENT '是否删除',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `FKsni20f28wjqrmpp44uawa2ky4` (`p_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='菜单表';

-- ----------------------------
-- Records of t_menu
-- ----------------------------
INSERT INTO `t_menu` VALUES ('1', 'menu-1', '系统菜单', '1', '/', '-1', '2099', '-1', '0');
INSERT INTO `t_menu` VALUES ('2', 'menu-2', '系统设置', '0', '/', '1', '10', '0', '0');
INSERT INTO `t_menu` VALUES ('3', 'menu-3', '用户管理', '0', '/user/index', '2', '1010', '1', '0');
INSERT INTO `t_menu` VALUES ('4', 'menu-4', '角色管理', '0', '/role/index', '2', '1020', '1', '0');
INSERT INTO `t_menu` VALUES ('5', 'menu-5', '密码修改', '0', '/user/toPasswordPage', '2', '101001', '1', '1');
INSERT INTO `t_menu` VALUES ('6', 'menu-6', '安全退出', '0', '/signout', '2', '101002', '1', '1');
INSERT INTO `t_menu` VALUES ('7', null, '用户列表查询', '0', null, '3', '101003', '2', '0');
INSERT INTO `t_menu` VALUES ('8', null, '用户添加', '0', null, '3', '101004', '2', '0');
INSERT INTO `t_menu` VALUES ('9', null, '用户更新', '0', null, '3', '101005', '2', '0');
INSERT INTO `t_menu` VALUES ('10', null, '用户删除', '0', null, '3', '101006', '2', '0');
INSERT INTO `t_menu` VALUES ('11', null, '角色列表查询', '0', null, '4', '102001', '2', '0');
INSERT INTO `t_menu` VALUES ('12', null, '角色添加', '0', null, '4', '102002', '2', '0');
INSERT INTO `t_menu` VALUES ('13', null, '角色更新', '0', null, '4', '102003', '2', '0');
INSERT INTO `t_menu` VALUES ('14', null, '角色删除', '0', null, '4', '102004', '2', '0');
INSERT INTO `t_menu` VALUES ('15', null, '角色授权', '0', null, '4', '102005', '2', '0');
INSERT INTO `t_menu` VALUES ('16', null, 'test', '0', null, '1', '23454', '0', '1');
INSERT INTO `t_menu` VALUES ('17', null, 'test1', '0', null, '1', '1234', '1', '1');
INSERT INTO `t_menu` VALUES ('18', null, '菜单管理', '0', '/user', '2', '1030', '1', '0');
INSERT INTO `t_menu` VALUES ('19', null, '基础资料', '0', null, '1', '20', '0', '0');
INSERT INTO `t_menu` VALUES ('20', null, '进货管理', '0', null, '1', '30', '0', '0');
INSERT INTO `t_menu` VALUES ('21', null, '销售管理', '0', null, '1', '40', '0', '0');
INSERT INTO `t_menu` VALUES ('22', null, '库存管理', '0', null, '1', '50', '0', '0');
INSERT INTO `t_menu` VALUES ('23', null, '统计报表', '0', null, '1', '60', '0', '0');
INSERT INTO `t_menu` VALUES ('24', null, '供应商管理', '0', '', '19', '2001', '1', '0');
INSERT INTO `t_menu` VALUES ('25', null, '客户管理', '0', '', '19', '2002', '1', '0');
INSERT INTO `t_menu` VALUES ('26', null, '商品管理', '0', '', '19', '2003', '1', '0');
INSERT INTO `t_menu` VALUES ('27', null, '商品分类管理', '0', '', '19', '2004', '1', '0');
INSERT INTO `t_menu` VALUES ('28', null, '期初库存', '0', '', '19', '2005', '1', '0');
INSERT INTO `t_menu` VALUES ('29', null, '添加删除更新查看', '0', null, '18', '103001', '2', '0');
INSERT INTO `t_menu` VALUES ('30', null, '主管', '0', null, '1', '23454', '0', '1');
INSERT INTO `t_menu` VALUES ('31', null, '主管', '0', 'https://www.youtube.com/watch?v=FOIjvHjK0Rw&ab_channel=relaxdaily', '21', '23454', '1', '1');

-- ----------------------------
-- Table structure for `t_overflow_list`
-- ----------------------------
DROP TABLE IF EXISTS `t_overflow_list`;
CREATE TABLE `t_overflow_list` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `overflow_date` datetime DEFAULT NULL COMMENT '报溢日期',
  `overflow_number` varchar(100) DEFAULT NULL COMMENT '报溢单号',
  `remarks` varchar(1000) DEFAULT NULL COMMENT '备注',
  `user_id` int(11) DEFAULT NULL COMMENT '操作用户id',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `FK3bu8hj2xniqwbrtg6ls6b8ej2` (`user_id`) USING BTREE,
  CONSTRAINT `FK3bu8hj2xniqwbrtg6ls6b8ej2` FOREIGN KEY (`user_id`) REFERENCES `t_user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='报溢单表';

-- ----------------------------
-- Records of t_overflow_list
-- ----------------------------
INSERT INTO `t_overflow_list` VALUES ('3', '2017-10-27 00:00:00', 'BY201710270001', 'dd', '1');
INSERT INTO `t_overflow_list` VALUES ('5', '2021-03-04 00:00:00', 'BY202103040001', '', '1');
INSERT INTO `t_overflow_list` VALUES ('6', '2021-09-06 00:00:00', 'BY202109250002', '', '2');
INSERT INTO `t_overflow_list` VALUES ('8', '2021-09-24 00:00:00', 'BY202109250004', '', '2');

-- ----------------------------
-- Table structure for `t_overflow_list_goods`
-- ----------------------------
DROP TABLE IF EXISTS `t_overflow_list_goods`;
CREATE TABLE `t_overflow_list_goods` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `code` varchar(50) DEFAULT NULL COMMENT '编码',
  `model` varchar(50) DEFAULT NULL COMMENT '型号',
  `name` varchar(50) DEFAULT NULL COMMENT '商品名',
  `num` int(11) NOT NULL COMMENT '数量',
  `price` float NOT NULL COMMENT '价格',
  `total` float NOT NULL COMMENT '总价',
  `unit` varchar(10) DEFAULT NULL COMMENT '单位',
  `overflow_list_id` int(11) DEFAULT NULL COMMENT '报溢单id',
  `type_id` int(11) DEFAULT NULL COMMENT '商品类别id',
  `goods_id` int(11) DEFAULT NULL COMMENT '商品id',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `FKd3s9761mgl456tn2xb0d164h7` (`overflow_list_id`) USING BTREE,
  KEY `FK8t46iik5kpciki8fnqtiuq5q3` (`type_id`) USING BTREE,
  CONSTRAINT `FK8t46iik5kpciki8fnqtiuq5q3` FOREIGN KEY (`type_id`) REFERENCES `t_goods_type` (`id`),
  CONSTRAINT `FKd3s9761mgl456tn2xb0d164h7` FOREIGN KEY (`overflow_list_id`) REFERENCES `t_overflow_list` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='报溢单商品表';

-- ----------------------------
-- Records of t_overflow_list_goods
-- ----------------------------
INSERT INTO `t_overflow_list_goods` VALUES ('4', '0002', 'Note8', '华为荣耀Note8', '2', '2220', '4440', '台', '3', '16', '2');
INSERT INTO `t_overflow_list_goods` VALUES ('5', '0006', '300g装', '冰糖金桔干', '3', '5', '15', '盒', '3', '11', '14');
INSERT INTO `t_overflow_list_goods` VALUES ('8', '0002', 'Note8', '华为荣耀Note8', '20', '2220', '44400', '台', '5', '16', '2');
INSERT INTO `t_overflow_list_goods` VALUES ('9', '0002', 'Note8', '华为荣耀Note8', '1234', '2220', '2739480', '台', '6', '16', '2');
INSERT INTO `t_overflow_list_goods` VALUES ('11', '0002', 'Note8', '华为荣耀Note8', '1234', '2220', '2739480', '台', '8', '16', '2');

-- ----------------------------
-- Table structure for `t_purchase_list`
-- ----------------------------
DROP TABLE IF EXISTS `t_purchase_list`;
CREATE TABLE `t_purchase_list` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `amount_paid` float NOT NULL COMMENT '实付金额',
  `amount_payable` float NOT NULL COMMENT '应付金额',
  `purchase_date` datetime DEFAULT NULL COMMENT '进货日期',
  `remarks` varchar(1000) DEFAULT NULL COMMENT '备注',
  `state` int(11) NOT NULL COMMENT '交易状态',
  `purchase_number` varchar(100) DEFAULT NULL COMMENT '进货单号',
  `supplier_id` int(11) DEFAULT NULL COMMENT '供应商',
  `user_id` int(11) DEFAULT NULL COMMENT '操作用户',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `FK5j2dev8b2b5d0l69nb8vtr4yb` (`supplier_id`) USING BTREE,
  KEY `FK69s6eyxr4wwvsywe9hbthef1h` (`user_id`) USING BTREE,
  CONSTRAINT `FK5j2dev8b2b5d0l69nb8vtr4yb` FOREIGN KEY (`supplier_id`) REFERENCES `t_supplier` (`id`),
  CONSTRAINT `FK69s6eyxr4wwvsywe9hbthef1h` FOREIGN KEY (`user_id`) REFERENCES `t_user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=47 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='进货单';

-- ----------------------------
-- Records of t_purchase_list
-- ----------------------------
INSERT INTO `t_purchase_list` VALUES ('43', '10489', '10489', '2021-09-14 00:00:00', 'zxcv', '1', 'JH202109240005', '3', '2');
INSERT INTO `t_purchase_list` VALUES ('44', '0', '0', '2021-09-16 00:00:00', '', '0', 'JH202109250001', '2', '2');
INSERT INTO `t_purchase_list` VALUES ('45', '0', '0', '2021-09-23 00:00:00', '', '0', 'JH202109260001', '2', '2');
INSERT INTO `t_purchase_list` VALUES ('46', '2739480', '2739480', '2021-09-09 00:00:00', '', '1', 'JH202109260002', '4', '2');

-- ----------------------------
-- Table structure for `t_purchase_list_goods`
-- ----------------------------
DROP TABLE IF EXISTS `t_purchase_list_goods`;
CREATE TABLE `t_purchase_list_goods` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `code` varchar(50) DEFAULT NULL COMMENT '商品编码',
  `model` varchar(50) DEFAULT NULL COMMENT '商品型号',
  `name` varchar(50) DEFAULT NULL COMMENT '商品名称',
  `num` int(11) NOT NULL COMMENT '数量',
  `price` float NOT NULL COMMENT '单价',
  `total` float NOT NULL COMMENT '总价',
  `unit` varchar(10) DEFAULT NULL COMMENT '商品单位',
  `purchase_list_id` int(11) DEFAULT NULL COMMENT '进货单id',
  `type_id` int(11) DEFAULT NULL COMMENT '商品类别',
  `goods_id` int(11) DEFAULT NULL COMMENT '商品id',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `FKfvdvgcebqkkokyn0o00idqnpy` (`purchase_list_id`) USING BTREE,
  KEY `FK83ikbi2x3epn49fwcco8jlfwu` (`type_id`) USING BTREE,
  CONSTRAINT `FK83ikbi2x3epn49fwcco8jlfwu` FOREIGN KEY (`type_id`) REFERENCES `t_goods_type` (`id`),
  CONSTRAINT `FKfvdvgcebqkkokyn0o00idqnpy` FOREIGN KEY (`purchase_list_id`) REFERENCES `t_purchase_list` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=63 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='进货单商品表';

-- ----------------------------
-- Records of t_purchase_list_goods
-- ----------------------------
INSERT INTO `t_purchase_list_goods` VALUES ('59', '0001', '红色装', '陶华碧老干妈香辣脆油辣椒', '1234', '8.5', '10489', '瓶', '43', '10', '1');
INSERT INTO `t_purchase_list_goods` VALUES ('60', '0001', '红色装', '陶华碧老干妈香辣脆油辣椒', '0', '8.5', '0', '瓶', '44', '10', '1');
INSERT INTO `t_purchase_list_goods` VALUES ('61', '0001', '红色装', '陶华碧老干妈香辣脆油辣椒', '0', '8.5', '0', '瓶', '45', '10', '1');
INSERT INTO `t_purchase_list_goods` VALUES ('62', '0002', 'Note8', '华为荣耀Note8', '1234', '2220', '2739480', '台', '46', '16', '2');

-- ----------------------------
-- Table structure for `t_return_list`
-- ----------------------------
DROP TABLE IF EXISTS `t_return_list`;
CREATE TABLE `t_return_list` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `amount_paid` float NOT NULL COMMENT '实付金额',
  `amount_payable` float NOT NULL COMMENT '应付金额',
  `remarks` varchar(1000) DEFAULT NULL COMMENT '备注',
  `return_date` datetime DEFAULT NULL COMMENT '退货日期',
  `return_number` varchar(100) DEFAULT NULL COMMENT '退货单号',
  `state` int(11) NOT NULL COMMENT '交易状态',
  `supplier_id` int(11) DEFAULT NULL COMMENT '供应商',
  `user_id` int(11) DEFAULT NULL COMMENT '操作用户',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `FK4qxjj8bvj2etne243xluni0vn` (`supplier_id`) USING BTREE,
  KEY `FK904juw2v1hm2av0ig26gae9jb` (`user_id`) USING BTREE,
  CONSTRAINT `FK4qxjj8bvj2etne243xluni0vn` FOREIGN KEY (`supplier_id`) REFERENCES `t_supplier` (`id`),
  CONSTRAINT `FK904juw2v1hm2av0ig26gae9jb` FOREIGN KEY (`user_id`) REFERENCES `t_user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='退货单表';

-- ----------------------------
-- Records of t_return_list
-- ----------------------------
INSERT INTO `t_return_list` VALUES ('11', '26976', '26976', 'asdf', '2021-09-28 00:00:00', 'TH202110060001', '1', '1', '2');
INSERT INTO `t_return_list` VALUES ('12', '156', '156', 'test', '2021-09-22 00:00:00', 'TH202110060002', '1', '2', '2');

-- ----------------------------
-- Table structure for `t_return_list_goods`
-- ----------------------------
DROP TABLE IF EXISTS `t_return_list_goods`;
CREATE TABLE `t_return_list_goods` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `code` varchar(50) DEFAULT NULL COMMENT '商品编码',
  `model` varchar(50) DEFAULT NULL COMMENT '商品型号',
  `name` varchar(50) DEFAULT NULL COMMENT '商品名称',
  `num` int(11) NOT NULL COMMENT '数量',
  `price` float NOT NULL COMMENT '单价',
  `total` float NOT NULL COMMENT '总价',
  `unit` varchar(10) DEFAULT NULL COMMENT '单位',
  `return_list_id` int(11) DEFAULT NULL COMMENT '退货单id',
  `type_id` int(11) DEFAULT NULL COMMENT '商品类别',
  `goods_id` int(11) DEFAULT NULL COMMENT '商品id',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `FKemclu281vyvyk063c3foafq1w` (`return_list_id`) USING BTREE,
  KEY `FKa1prpd96fcs0x2oe0omny9vio` (`type_id`) USING BTREE,
  CONSTRAINT `FKa1prpd96fcs0x2oe0omny9vio` FOREIGN KEY (`type_id`) REFERENCES `t_goods_type` (`id`),
  CONSTRAINT `FKemclu281vyvyk063c3foafq1w` FOREIGN KEY (`return_list_id`) REFERENCES `t_return_list` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='退货单商品表';

-- ----------------------------
-- Records of t_return_list_goods
-- ----------------------------
INSERT INTO `t_return_list_goods` VALUES ('14', '0002', 'Note8', '华为荣耀Note8', '12', '2220', '26640', '台', '11', '16', '2');
INSERT INTO `t_return_list_goods` VALUES ('15', '0003', '500g装', '野生东北黑木耳', '12', '23', '276', '袋', '11', '11', '11');
INSERT INTO `t_return_list_goods` VALUES ('16', '0006', '300g装', '冰糖金桔干', '12', '5', '60', '盒', '11', '11', '14');
INSERT INTO `t_return_list_goods` VALUES ('17', '0001', '红色装', '陶华碧老干妈香辣脆油辣椒', '12', '8.5', '102', '瓶', '12', '10', '1');
INSERT INTO `t_return_list_goods` VALUES ('18', '0007', '500g装', '吉利人家牛肉味蛋糕', '12', '4.5', '54', '袋', '12', '11', '15');

-- ----------------------------
-- Table structure for `t_role`
-- ----------------------------
DROP TABLE IF EXISTS `t_role`;
CREATE TABLE `t_role` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `bz` varchar(1000) DEFAULT NULL COMMENT '备注',
  `name` varchar(50) DEFAULT NULL COMMENT '角色名',
  `remarks` varchar(1000) DEFAULT NULL COMMENT '描述',
  `is_del` int(11) unsigned DEFAULT '0' COMMENT '是否删除',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='角色表';

-- ----------------------------
-- Records of t_role
-- ----------------------------
INSERT INTO `t_role` VALUES ('1', '系统管理员 最高权限', '管理员', null, '0');
INSERT INTO `t_role` VALUES ('2', '主管', '主管', null, '0');
INSERT INTO `t_role` VALUES ('4', '采购员', '采购员', null, '0');
INSERT INTO `t_role` VALUES ('5', '销售经理', '销售经理', '', '0');
INSERT INTO `t_role` VALUES ('7', '仓库管理员', '仓库经理', '', '0');
INSERT INTO `t_role` VALUES ('9', '总经理', '总经理', null, '1');
INSERT INTO `t_role` VALUES ('10', 'test', '管理员02', '', '1');
INSERT INTO `t_role` VALUES ('11', 'test', 'test', 'test', '1');

-- ----------------------------
-- Table structure for `t_role_menu`
-- ----------------------------
DROP TABLE IF EXISTS `t_role_menu`;
CREATE TABLE `t_role_menu` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `menu_id` int(11) DEFAULT NULL COMMENT '菜单id',
  `role_id` int(11) DEFAULT NULL COMMENT '角色id',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `FKsonb0rbt2u99hbrqqvv3r0wse` (`role_id`) USING BTREE,
  KEY `FKhayg4ib6v7h1wyeyxhq6xlddq` (`menu_id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=336 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='角色菜单表';

-- ----------------------------
-- Records of t_role_menu
-- ----------------------------
INSERT INTO `t_role_menu` VALUES ('255', '1', '1');
INSERT INTO `t_role_menu` VALUES ('256', '2', '1');
INSERT INTO `t_role_menu` VALUES ('257', '3', '1');
INSERT INTO `t_role_menu` VALUES ('258', '7', '1');
INSERT INTO `t_role_menu` VALUES ('259', '8', '1');
INSERT INTO `t_role_menu` VALUES ('260', '9', '1');
INSERT INTO `t_role_menu` VALUES ('261', '10', '1');
INSERT INTO `t_role_menu` VALUES ('262', '4', '1');
INSERT INTO `t_role_menu` VALUES ('263', '11', '1');
INSERT INTO `t_role_menu` VALUES ('264', '12', '1');
INSERT INTO `t_role_menu` VALUES ('265', '13', '1');
INSERT INTO `t_role_menu` VALUES ('266', '14', '1');
INSERT INTO `t_role_menu` VALUES ('267', '15', '1');
INSERT INTO `t_role_menu` VALUES ('268', '18', '1');
INSERT INTO `t_role_menu` VALUES ('269', '19', '1');
INSERT INTO `t_role_menu` VALUES ('270', '24', '1');
INSERT INTO `t_role_menu` VALUES ('271', '25', '1');
INSERT INTO `t_role_menu` VALUES ('272', '26', '1');
INSERT INTO `t_role_menu` VALUES ('273', '27', '1');
INSERT INTO `t_role_menu` VALUES ('274', '28', '1');
INSERT INTO `t_role_menu` VALUES ('275', '20', '1');
INSERT INTO `t_role_menu` VALUES ('276', '21', '1');
INSERT INTO `t_role_menu` VALUES ('277', '22', '1');
INSERT INTO `t_role_menu` VALUES ('278', '23', '1');
INSERT INTO `t_role_menu` VALUES ('279', '1', '4');
INSERT INTO `t_role_menu` VALUES ('280', '2', '4');
INSERT INTO `t_role_menu` VALUES ('281', '3', '4');
INSERT INTO `t_role_menu` VALUES ('282', '7', '4');
INSERT INTO `t_role_menu` VALUES ('283', '8', '4');
INSERT INTO `t_role_menu` VALUES ('284', '9', '4');
INSERT INTO `t_role_menu` VALUES ('285', '10', '4');
INSERT INTO `t_role_menu` VALUES ('294', '1', '5');
INSERT INTO `t_role_menu` VALUES ('295', '2', '5');
INSERT INTO `t_role_menu` VALUES ('296', '3', '5');
INSERT INTO `t_role_menu` VALUES ('297', '7', '5');
INSERT INTO `t_role_menu` VALUES ('298', '8', '5');
INSERT INTO `t_role_menu` VALUES ('299', '9', '5');
INSERT INTO `t_role_menu` VALUES ('300', '10', '5');
INSERT INTO `t_role_menu` VALUES ('301', '4', '5');
INSERT INTO `t_role_menu` VALUES ('302', '11', '5');
INSERT INTO `t_role_menu` VALUES ('303', '12', '5');
INSERT INTO `t_role_menu` VALUES ('304', '13', '5');
INSERT INTO `t_role_menu` VALUES ('305', '14', '5');
INSERT INTO `t_role_menu` VALUES ('306', '15', '5');
INSERT INTO `t_role_menu` VALUES ('321', '1', '7');
INSERT INTO `t_role_menu` VALUES ('322', '2', '7');
INSERT INTO `t_role_menu` VALUES ('323', '3', '7');
INSERT INTO `t_role_menu` VALUES ('324', '7', '7');
INSERT INTO `t_role_menu` VALUES ('325', '8', '7');
INSERT INTO `t_role_menu` VALUES ('326', '9', '7');
INSERT INTO `t_role_menu` VALUES ('327', '10', '7');
INSERT INTO `t_role_menu` VALUES ('328', '4', '7');
INSERT INTO `t_role_menu` VALUES ('329', '11', '7');
INSERT INTO `t_role_menu` VALUES ('330', '12', '7');
INSERT INTO `t_role_menu` VALUES ('331', '13', '7');
INSERT INTO `t_role_menu` VALUES ('332', '14', '7');
INSERT INTO `t_role_menu` VALUES ('333', '15', '7');
INSERT INTO `t_role_menu` VALUES ('334', '18', '7');
INSERT INTO `t_role_menu` VALUES ('335', '29', '7');

-- ----------------------------
-- Table structure for `t_sale_list`
-- ----------------------------
DROP TABLE IF EXISTS `t_sale_list`;
CREATE TABLE `t_sale_list` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `amount_paid` float NOT NULL COMMENT '实付金额',
  `amount_payable` float NOT NULL COMMENT '应付金额',
  `remarks` varchar(1000) DEFAULT NULL COMMENT '备注',
  `sale_date` datetime DEFAULT NULL COMMENT '销售日期',
  `sale_number` varchar(100) DEFAULT NULL COMMENT '销售单号',
  `state` int(11) DEFAULT NULL COMMENT '交易状态',
  `user_id` int(11) DEFAULT NULL COMMENT '操作用户',
  `customer_id` int(11) DEFAULT NULL COMMENT '客户id',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `FK34bnujemrdqimbhg133enp8k8` (`user_id`) USING BTREE,
  KEY `FKox4qfs87eu3fvwdmrvelqhi8e` (`customer_id`) USING BTREE,
  CONSTRAINT `FK34bnujemrdqimbhg133enp8k8` FOREIGN KEY (`user_id`) REFERENCES `t_user` (`id`),
  CONSTRAINT `FKox4qfs87eu3fvwdmrvelqhi8e` FOREIGN KEY (`customer_id`) REFERENCES `t_customer` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='销售单表';

-- ----------------------------
-- Records of t_sale_list
-- ----------------------------
INSERT INTO `t_sale_list` VALUES ('4', '5060', '5060', 'cc', '2017-01-27 00:00:00', 'XS201701270001', '1', '1', '2');
INSERT INTO `t_sale_list` VALUES ('6', '4889', '4889', 'dd', '2017-02-28 00:00:00', 'XS201702280002', '0', '1', '2');
INSERT INTO `t_sale_list` VALUES ('7', '4400', '4400', 'cccc', '2017-03-30 00:00:00', 'XS201703300001', '0', '1', '2');
INSERT INTO `t_sale_list` VALUES ('8', '860', '860', 'cc', '2017-04-30 00:00:00', 'XS201704300002', '1', '1', '2');
INSERT INTO `t_sale_list` VALUES ('11', '83', '83', 'ccc', '2017-05-01 00:00:00', 'XS201705100003', '1', '1', '2');
INSERT INTO `t_sale_list` VALUES ('12', '6626', '6626', 'cccc', '2017-06-03 00:00:00', 'XS201706300001', '1', '1', '2');
INSERT INTO `t_sale_list` VALUES ('13', '76', '76', 'cc', '2017-06-03 00:00:00', 'XS201706300002', '1', '1', '1');
INSERT INTO `t_sale_list` VALUES ('14', '127', '127', 'cc', '2017-07-03 00:00:00', 'XS201707300003', '1', '1', '2');
INSERT INTO `t_sale_list` VALUES ('15', '1579.5', '1579.5', 'cc', '2017-08-03 00:00:00', 'XS201708300004', '1', '1', '2');
INSERT INTO `t_sale_list` VALUES ('16', '76', '76', 'cc', '2017-09-03 00:00:00', 'XS201709300005', '1', '1', '2');
INSERT INTO `t_sale_list` VALUES ('17', '111', '111', 'cc', '2017-10-28 00:00:00', 'XS201710280006', '1', '1', '2');
INSERT INTO `t_sale_list` VALUES ('18', '40', '40', 'cc', '2017-10-29 00:00:00', 'XS201710290007', '1', '1', '1');
INSERT INTO `t_sale_list` VALUES ('19', '45', '45', 'cc', '2017-10-30 00:00:00', 'XS201710300008', '1', '1', '1');
INSERT INTO `t_sale_list` VALUES ('20', '10', '10', 'cc', '2017-10-31 00:00:00', 'XS201710310009', '1', '1', '1');
INSERT INTO `t_sale_list` VALUES ('21', '202', '202', 'cc', '2017-11-01 00:00:00', 'XS201711010010', '1', '1', '2');
INSERT INTO `t_sale_list` VALUES ('22', '3650', '3650', '11', '2017-11-02 00:00:00', 'XS201711020011', '1', '1', '2');
INSERT INTO `t_sale_list` VALUES ('23', '20', '20', 'cc', '2017-11-03 00:00:00', 'XS201711030012', '1', '1', '1');
INSERT INTO `t_sale_list` VALUES ('24', '59', '59', 'cc', '2016-12-03 00:00:00', 'XS201712030013', '1', '1', '2');
INSERT INTO `t_sale_list` VALUES ('25', '146', '146', 'cc', '2016-11-03 00:00:00', 'XS201711030014', '1', '1', '1');
INSERT INTO `t_sale_list` VALUES ('26', '215', '215', '', '2021-03-03 00:00:00', 'XS202103030001', '1', '1', '1');
INSERT INTO `t_sale_list` VALUES ('27', '2783', '2783', '', '2021-03-03 00:00:00', 'XS202103030002', '1', '1', '2');
INSERT INTO `t_sale_list` VALUES ('31', '378', '378', 'asdf', '2021-09-15 00:00:00', 'XS202109240001', '1', '2', '1');
INSERT INTO `t_sale_list` VALUES ('32', '315240', '315240', 'asdf', '2021-09-23 00:00:00', 'XS202109240002', '1', '2', '1');
INSERT INTO `t_sale_list` VALUES ('33', '0', '0', '', '2021-09-22 00:00:00', 'XS202109250001', '1', '2', '1');

-- ----------------------------
-- Table structure for `t_sale_list_goods`
-- ----------------------------
DROP TABLE IF EXISTS `t_sale_list_goods`;
CREATE TABLE `t_sale_list_goods` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `code` varchar(50) DEFAULT NULL COMMENT '商品编码',
  `model` varchar(50) DEFAULT NULL COMMENT '商品型号',
  `name` varchar(50) DEFAULT NULL COMMENT '商品名称',
  `num` int(11) NOT NULL COMMENT '数量',
  `price` float NOT NULL COMMENT '单价',
  `total` float NOT NULL COMMENT '总价',
  `unit` varchar(10) DEFAULT NULL COMMENT '单位',
  `sale_list_id` int(11) DEFAULT NULL COMMENT '销售单',
  `type_id` int(11) DEFAULT NULL COMMENT '商品类别',
  `goods_id` int(11) DEFAULT NULL COMMENT '商品id',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `FK20ehd6ta9geyql4hxtdsnhbox` (`sale_list_id`) USING BTREE,
  KEY `FKn9i5p1d8f0gek5x7q45cq8ibw` (`type_id`) USING BTREE,
  CONSTRAINT `FK20ehd6ta9geyql4hxtdsnhbox` FOREIGN KEY (`sale_list_id`) REFERENCES `t_sale_list` (`id`),
  CONSTRAINT `FKn9i5p1d8f0gek5x7q45cq8ibw` FOREIGN KEY (`type_id`) REFERENCES `t_goods_type` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=54 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='销售单商品表';

-- ----------------------------
-- Records of t_sale_list_goods
-- ----------------------------
INSERT INTO `t_sale_list_goods` VALUES ('7', '0002', 'Note8', '华为荣耀Note8', '2', '2200', '4400', '台', '4', '16', '2');
INSERT INTO `t_sale_list_goods` VALUES ('8', '0010', '250g装', '劲仔小鱼干', '33', '20', '660', '袋', '4', '11', '18');
INSERT INTO `t_sale_list_goods` VALUES ('11', '0003', '500g装', '野生东北黑木耳', '100', '38', '3800', '袋', '6', '11', '11');
INSERT INTO `t_sale_list_goods` VALUES ('12', '0009', '240g装', '休闲零食坚果特产精品干果无漂白大个开心果', '33', '33', '1089', '袋', '6', '11', '17');
INSERT INTO `t_sale_list_goods` VALUES ('13', '0002', 'Note8', '华为荣耀Note8', '2', '2200', '4400', '台', '7', '16', '2');
INSERT INTO `t_sale_list_goods` VALUES ('14', '0003', '500g装', '野生东北黑木耳', '22', '38', '836', '袋', '8', '11', '11');
INSERT INTO `t_sale_list_goods` VALUES ('15', '0014', '250g装', '美国青豆原味 蒜香', '3', '8', '24', '袋', '8', '11', '22');
INSERT INTO `t_sale_list_goods` VALUES ('20', '0003', '500g装', '野生东北黑木耳', '1', '38', '38', '袋', '11', '11', '11');
INSERT INTO `t_sale_list_goods` VALUES ('21', '0005', '散装500克', '麦片燕麦巧克力', '3', '15', '45', '袋', '11', '11', '13');
INSERT INTO `t_sale_list_goods` VALUES ('22', '0002', 'Note8', '华为荣耀Note8', '3', '2200', '6600', '台', '12', '16', '2');
INSERT INTO `t_sale_list_goods` VALUES ('23', '0006', '300g装', '冰糖金桔干', '2', '13', '26', '盒', '12', '11', '14');
INSERT INTO `t_sale_list_goods` VALUES ('24', '0003', '500g装', '野生东北黑木耳', '2', '38', '76', '袋', '13', '11', '11');
INSERT INTO `t_sale_list_goods` VALUES ('25', '0004', '2斤装', '新疆红枣', '3', '25', '75', '袋', '14', '10', '12');
INSERT INTO `t_sale_list_goods` VALUES ('26', '0006', '300g装', '冰糖金桔干', '4', '13', '52', '盒', '14', '11', '14');
INSERT INTO `t_sale_list_goods` VALUES ('27', '0001', '红色装', '陶华碧老干妈香辣脆油辣椒', '33', '8.5', '280.5', '瓶', '15', '10', '1');
INSERT INTO `t_sale_list_goods` VALUES ('28', '0018', 'IXUS 285 HS', 'Canon/佳能 IXUS 285 HS 数码相机 2020万像素高清拍摄', '1', '1299', '1299', '台', '15', '15', '27');
INSERT INTO `t_sale_list_goods` VALUES ('29', '0003', '500g装', '野生东北黑木耳', '2', '38', '76', '袋', '16', '11', '11');
INSERT INTO `t_sale_list_goods` VALUES ('30', '0005', '散装500克', '麦片燕麦巧克力', '3', '15', '45', '袋', '17', '11', '13');
INSERT INTO `t_sale_list_goods` VALUES ('31', '0009', '240g装', '休闲零食坚果特产精品干果无漂白大个开心果', '2', '33', '66', '袋', '17', '11', '17');
INSERT INTO `t_sale_list_goods` VALUES ('32', '0010', '250g装', '劲仔小鱼干', '1', '20', '20', '袋', '18', '11', '18');
INSERT INTO `t_sale_list_goods` VALUES ('33', '0008', '128g装', '奕森奶油桃肉蜜饯果脯果干桃肉干休闲零食品', '2', '10', '20', '盒', '18', '11', '16');
INSERT INTO `t_sale_list_goods` VALUES ('34', '0004', '2斤装', '新疆红枣', '1', '25', '25', '袋', '19', '10', '12');
INSERT INTO `t_sale_list_goods` VALUES ('35', '0008', '128g装', '奕森奶油桃肉蜜饯果脯果干桃肉干休闲零食品', '2', '10', '20', '盒', '19', '11', '16');
INSERT INTO `t_sale_list_goods` VALUES ('36', '0007', '500g装', '吉利人家牛肉味蛋糕', '1', '10', '10', '袋', '20', '11', '15');
INSERT INTO `t_sale_list_goods` VALUES ('37', '0003', '500g装', '野生东北黑木耳', '2', '38', '76', '袋', '21', '11', '11');
INSERT INTO `t_sale_list_goods` VALUES ('38', '0007', '500g装', '吉利人家牛肉味蛋糕', '2', '10', '20', '袋', '21', '11', '15');
INSERT INTO `t_sale_list_goods` VALUES ('39', '0009', '240g装', '休闲零食坚果特产精品干果无漂白大个开心果', '2', '33', '66', '袋', '21', '11', '17');
INSERT INTO `t_sale_list_goods` VALUES ('40', '0010', '250g装', '劲仔小鱼干', '2', '20', '40', '袋', '21', '11', '18');
INSERT INTO `t_sale_list_goods` VALUES ('41', '0017', 'ILCE-A6000L', 'Sony/索尼 ILCE-A6000L WIFI微单数码相机高清单电', '1', '3650', '3650', '台', '22', '15', '26');
INSERT INTO `t_sale_list_goods` VALUES ('42', '0010', '250g装', '劲仔小鱼干', '1', '20', '20', '袋', '23', '11', '18');
INSERT INTO `t_sale_list_goods` VALUES ('43', '0009', '240g装', '休闲零食坚果特产精品干果无漂白大个开心果', '1', '33', '33', '袋', '24', '11', '17');
INSERT INTO `t_sale_list_goods` VALUES ('44', '0006', '300g装', '冰糖金桔干', '2', '13', '26', '盒', '24', '11', '14');
INSERT INTO `t_sale_list_goods` VALUES ('45', '0009', '240g装', '休闲零食坚果特产精品干果无漂白大个开心果', '2', '33', '66', '袋', '25', '11', '17');
INSERT INTO `t_sale_list_goods` VALUES ('46', '0014', '250g装', '美国青豆原味 蒜香', '10', '8', '80', '袋', '25', '11', '22');
INSERT INTO `t_sale_list_goods` VALUES ('47', '0001', '红色装', '陶华碧老干妈香辣脆油辣椒', '10', '8.5', '85', '瓶', '26', '10', '1');
INSERT INTO `t_sale_list_goods` VALUES ('48', '0004', '2斤装', '新疆红枣', '10', '13', '130', '袋', '26', '10', '12');
INSERT INTO `t_sale_list_goods` VALUES ('49', '0003', '500g装', '野生东北黑木耳', '121', '23', '2783', '袋', '27', '11', '11');
INSERT INTO `t_sale_list_goods` VALUES ('50', '0001', '红色装', '陶华碧老干妈香辣脆油辣椒', '12', '8.5', '102', '瓶', '31', '10', '1');
INSERT INTO `t_sale_list_goods` VALUES ('51', '0003', '500g装', '野生东北黑木耳', '12', '23', '276', '袋', '31', '11', '11');
INSERT INTO `t_sale_list_goods` VALUES ('52', '0002', 'Note8', '华为荣耀Note8', '142', '2220', '315240', '台', '32', '16', '2');
INSERT INTO `t_sale_list_goods` VALUES ('53', '0002', 'Note8', '华为荣耀Note8', '0', '2220', '0', '台', '33', '16', '2');

-- ----------------------------
-- Table structure for `t_supplier`
-- ----------------------------
DROP TABLE IF EXISTS `t_supplier`;
CREATE TABLE `t_supplier` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `address` varchar(300) DEFAULT NULL COMMENT '联系地址',
  `contact` varchar(50) DEFAULT NULL COMMENT '联系人',
  `name` varchar(200) DEFAULT NULL COMMENT '供应商名称',
  `number` varchar(50) DEFAULT NULL COMMENT '联系电话',
  `remarks` varchar(1000) DEFAULT NULL COMMENT '备注',
  `is_del` int(11) DEFAULT NULL COMMENT '是否删除',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='供应商表';

-- ----------------------------
-- Records of t_supplier
-- ----------------------------
INSERT INTO `t_supplier` VALUES ('1', '上海市金山区张堰镇松金公路2072号6607室', '小张', '上海福桂食品有限公司', '0773-7217175', '失信供应商', '0');
INSERT INTO `t_supplier` VALUES ('2', '安徽省合肥市肥西县桃花工业园合派路', '小王', '安徽麦堡食品工业有限公司', '0773-7217275', null, '0');
INSERT INTO `t_supplier` VALUES ('3', '晋江市罗山后林西区41号', '小李', '福建省晋江市罗山惠康食品有限公司', '1273-1217175', '优质供应商', '0');
INSERT INTO `t_supplier` VALUES ('4', '南京市江宁区科学园竹山路565号1幢', '小丽', '南京含羞草食品有限公司', '2121-7217175', null, '0');
INSERT INTO `t_supplier` VALUES ('5', '南京市高淳县阳江镇新桥村下桥278号', '王大狗', '南京禾乃美工贸有限公司', '2133-7217125', null, '0');
INSERT INTO `t_supplier` VALUES ('6', '开平市水口镇东埠路６号', '小七', '开平广合腐乳有限公司', '3332-7217175', '2', '0');
INSERT INTO `t_supplier` VALUES ('7', '汕头市跃进路２３号利鸿基中心大厦写字楼２座', '刘钩子', '汕头市金茂食品有限公司', '0723-7232175', null, '0');
INSERT INTO `t_supplier` VALUES ('8', '南京市溧水区经济开发区', '七枷社', '南京喜之郎食品有限公司', '1773-7217175', null, '0');
INSERT INTO `t_supplier` VALUES ('9', '深圳市罗湖区翠竹北路中深石化区厂房B栋6楼', '小蔡', '深圳昌信实业有限公司', '1773-7217175', null, '0');
INSERT INTO `t_supplier` VALUES ('10', '南京市下关区金陵小区6村27-2-203室', '小路', '南京市下关区红鹰调味品商行', '2132-7217175', null, '0');
INSERT INTO `t_supplier` VALUES ('11', '荔浦县荔塔路１６－３６号', '亲亲', '桂林阜康食品工业有限公司', '2123-7217175', null, '0');
INSERT INTO `t_supplier` VALUES ('12', '南京鼓楼区世纪大楼123号', '小二', '南京大王科技', '0112-1426789', '123', '0');
INSERT INTO `t_supplier` VALUES ('13', '南京将军路800号', '小吴', '南京大陆食品公司', '1243-2135487', 'cc', '0');
INSERT INTO `t_supplier` VALUES ('14', '32423', 'test', 'test', '33', null, '1');
INSERT INTO `t_supplier` VALUES ('15', '海澜之家', 'test', '男士马甲', '33', null, '0');
INSERT INTO `t_supplier` VALUES ('16', '666', '666', 'test666666', '666', null, '1');
INSERT INTO `t_supplier` VALUES ('17', '1', 'asdf', 'Leo Fitz', '1111111', null, '1');

-- ----------------------------
-- Table structure for `t_user`
-- ----------------------------
DROP TABLE IF EXISTS `t_user`;
CREATE TABLE `t_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键id',
  `bz` varchar(100) DEFAULT NULL COMMENT '备注名',
  `password` varchar(255) DEFAULT NULL COMMENT '密码',
  `true_name` varchar(50) DEFAULT NULL COMMENT '真实姓名',
  `user_name` varchar(50) DEFAULT NULL COMMENT '用户名',
  `remarks` varchar(1000) DEFAULT NULL COMMENT '备注',
  `is_del` int(11) DEFAULT '0' COMMENT '是否删除',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='用户表';

-- ----------------------------
-- Records of t_user
-- ----------------------------
INSERT INTO `t_user` VALUES ('1', '管理员', '$2a$10$Ke8AQubHMdCKToOisc449ehiK7EfjkqMoiUJhW6p9MO/sID4QJfBC', '666', 'admin', '系统管理员', '0');
INSERT INTO `t_user` VALUES ('2', '主管', '$2a$10$Ke8AQubHMdCKToOisc449ehiK7EfjkqMoiUJhW6p9MO/sID4QJfBC', '666', 'asdf', '负责管理工作', '0');
INSERT INTO `t_user` VALUES ('3', '销售经理', '$2a$10$Ke8AQubHMdCKToOisc449ehiK7EfjkqMoiUJhW6p9MO/sID4QJfBC', '666', 'jack', '负责管理销售', '0');
INSERT INTO `t_user` VALUES ('6', '临时账号', '$2a$10$8xMO0e1IXbss3R71fyTTSewZK6.Cr6u6qyVHbFRMYUNlHa0oDAa92', '临时账号', 'grant1', '具有 用户 管理权限', '0');
INSERT INTO `t_user` VALUES ('7', '临时账号', '$2a$10$bfa2C134OCjkewsOvJEK.OVa2rM6LYIQXSGpuWIV.34O78geBbfVm', '临时账号', 'grant2', '具有 用户、角色 管理权限', '0');
INSERT INTO `t_user` VALUES ('8', '临时账号', '$2a$10$zC85ra8S1Ss1S2eI6BWxXuIoBu2bqkWXsjOiAiMGA/94XpuHBRqIy', '临时账号', 'grant3', '具有 用户、角色、菜单 管理权限', '0');

-- ----------------------------
-- Table structure for `t_user_role`
-- ----------------------------
DROP TABLE IF EXISTS `t_user_role`;
CREATE TABLE `t_user_role` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `role_id` int(11) DEFAULT NULL COMMENT '角色id',
  `user_id` int(11) DEFAULT NULL COMMENT '用户id',
  PRIMARY KEY (`id`) USING BTREE,
  KEY `FKa9c8iiy6ut0gnx491fqx4pxam` (`role_id`) USING BTREE,
  KEY `FKq5un6x7ecoef5w1n39cop66kl` (`user_id`) USING BTREE,
  CONSTRAINT `FKa9c8iiy6ut0gnx491fqx4pxam` FOREIGN KEY (`role_id`) REFERENCES `t_role` (`id`),
  CONSTRAINT `FKq5un6x7ecoef5w1n39cop66kl` FOREIGN KEY (`user_id`) REFERENCES `t_user` (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=76 DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='用户角色表';

-- ----------------------------
-- Records of t_user_role
-- ----------------------------
INSERT INTO `t_user_role` VALUES ('52', '2', '3');
INSERT INTO `t_user_role` VALUES ('53', '4', '3');
INSERT INTO `t_user_role` VALUES ('54', '5', '3');
INSERT INTO `t_user_role` VALUES ('55', '7', '3');
INSERT INTO `t_user_role` VALUES ('60', '1', '2');
INSERT INTO `t_user_role` VALUES ('61', '2', '2');
INSERT INTO `t_user_role` VALUES ('62', '4', '2');
INSERT INTO `t_user_role` VALUES ('63', '5', '2');
INSERT INTO `t_user_role` VALUES ('64', '7', '2');
INSERT INTO `t_user_role` VALUES ('65', '11', '2');
INSERT INTO `t_user_role` VALUES ('66', '1', '1');
INSERT INTO `t_user_role` VALUES ('67', '2', '1');
INSERT INTO `t_user_role` VALUES ('68', '4', '1');
INSERT INTO `t_user_role` VALUES ('69', '5', '1');
INSERT INTO `t_user_role` VALUES ('73', '4', '6');
INSERT INTO `t_user_role` VALUES ('74', '5', '7');
INSERT INTO `t_user_role` VALUES ('75', '7', '8');