MySQL建表语句综合

最新推荐文章于 2024-05-01 16:28:23 发布

Wolf of Wall Street

最新推荐文章于 2024-05-01 16:28:23 发布

阅读量4.2k

点赞数

文章标签： mysql 数据库 database

本文链接：https://blog.csdn.net/m0_60322480/article/details/122830702

版权

带主键和外键，索引，和约束条件的

第一张表
/*
 Navicat Premium Data Transfer

 Source Server         : MySQL_local
 Source Server Type    : MySQL
 Source Server Version : 80026
 Source Host           : localhost:3306
 Source Schema         : ljp_jxc

 Target Server Type    : MySQL
 Target Server Version : 80026
 File Encoding         : 65001

 Date: 08/02/2022 20:26:12
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

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

SET FOREIGN_KEY_CHECKS = 1;

第二张表
/*
 Navicat Premium Data Transfer

 Source Server         : MySQL_local
 Source Server Type    : MySQL
 Source Server Version : 80026
 Source Host           : localhost:3306
 Source Schema         : ljp_jxc

 Target Server Type    : MySQL
 Target Server Version : 80026
 File Encoding         : 65001

 Date: 08/02/2022 20:30:15
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- 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 NOT NULL AUTO_INCREMENT COMMENT '主键',
  `code` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '商品编码',
  `model` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '商品型号',
  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '商品名称',
  `num` int NOT NULL COMMENT '数量',
  `price` float NOT NULL COMMENT '价格',
  `total` float NOT NULL COMMENT '总价',
  `unit` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '单位',
  `customer_return_list_id` int NULL DEFAULT NULL COMMENT '客户退货id',
  `type_id` int NULL DEFAULT NULL COMMENT '商品类别',
  `goods_id` int NULL DEFAULT NULL COMMENT '商品id',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `FKtqt67mbn96lxn8hvtl4piblhi`(`customer_return_list_id`) USING BTREE,
  INDEX `FK4sm5si4swbj3gae46jfk441yx`(`type_id`) USING BTREE,
  CONSTRAINT `FK4sm5si4swbj3gae46jfk441yx` FOREIGN KEY (`type_id`) REFERENCES `t_goods_type` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `FKtqt67mbn96lxn8hvtl4piblhi` FOREIGN KEY (`customer_return_list_id`) REFERENCES `t_customer_return_list` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '客户退货单商品表' ROW_FORMAT = DYNAMIC;

SET FOREIGN_KEY_CHECKS = 1;

只有索引的和主键

/*
 Navicat Premium Data Transfer

 Source Server         : MySQL_local
 Source Server Type    : MySQL
 Source Server Version : 80026
 Source Host           : localhost:3306
 Source Schema         : ljp_jxc

 Target Server Type    : MySQL
 Target Server Version : 80026
 File Encoding         : 65001

 Date: 08/02/2022 20:32:20
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

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

SET FOREIGN_KEY_CHECKS = 1;

只有主键的

/*
 Navicat Premium Data Transfer

 Source Server         : MySQL_local
 Source Server Type    : MySQL
 Source Server Version : 80026
 Source Host           : localhost:3306
 Source Schema         : ljp_jxc

 Target Server Type    : MySQL
 Target Server Version : 80026
 File Encoding         : 65001

 Date: 08/02/2022 20:35:52
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

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

SET FOREIGN_KEY_CHECKS = 1;

完整的sql脚本

/*
 Navicat Premium Data Transfer

 Source Server         : local
 Source Server Type    : MySQL
 Source Server Version : 80018
 Source Host           : 127.0.0.1:3306
 Source Schema         : lzj_jxc

 Target Server Type    : MySQL
 Target Server Version : 80018
 File Encoding         : 65001

 Date: 10/03/2021 16:16:17
*/
drop database if exists Purchase_inventory;
create database Purchase_inventory;
use Purchase_inventory;

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

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

-- ----------------------------
-- Records of persistent_logins
-- ----------------------------
INSERT INTO `persistent_logins` VALUES ('admin', '6EsPh12h+beYGhqQ6yNVWg==', 'vqaVLoYoA906R6c3Zl31ug==', '2021-03-02 15:14:46');
INSERT INTO `persistent_logins` VALUES ('admin', '8b4IxmLT05Zg+T5tsGWr4Q==', '4LZewoF1gD2Z7SQwh6LUVA==', '2021-03-03 22:04:26');
INSERT INTO `persistent_logins` VALUES ('admin', 'a15HZ0GqgBfGrHlOJ8TMFw==', 'vEkB6vpQtOCm887p3RNFZA==', '2021-03-01 21:03:01');
INSERT INTO `persistent_logins` VALUES ('admin', 'B/hEuyZv14ybtS347cc/Hw==', 'zswxvADxbGKioXapPVzOkw==', '2021-03-08 14:38:33');
INSERT INTO `persistent_logins` VALUES ('admin', 'bhUPJf2uUTI6tl77JEK5dQ==', '3664ed1tnD9Pmm/f+1M6AQ==', '2021-03-01 21:02:35');
INSERT INTO `persistent_logins` VALUES ('admin', 'DkBufmEuenDVpfiYea3BCQ==', 'wwmJYR/RzJaPf5M4u/MiKQ==', '2021-03-03 23:23:36');
INSERT INTO `persistent_logins` VALUES ('admin', 'gEiMrGu1xxZbTIUHQPmg8Q==', 'dN9L67Tep0jRWFSHiTAAkw==', '2021-03-03 19:44:51');
INSERT INTO `persistent_logins` VALUES ('admin', 'gFMN3/4ojNtQXOFip1fzcw==', 'OAXCeAumWpFGyFVJeLQrSQ==', '2021-03-01 20:59:07');
INSERT INTO `persistent_logins` VALUES ('admin', 'hfLiW16dqXK+qo2cxP4y8Q==', 'i1oc349XCjeO9AhKw4+znQ==', '2021-03-01 22:09:02');
INSERT INTO `persistent_logins` VALUES ('admin', 'hQeZFjrFtdGy8znGk+GZ2w==', 'L+fgfvZOTxxG3x+TSn/ALg==', '2021-03-02 22:19:52');
INSERT INTO `persistent_logins` VALUES ('admin', 'IgE34qj1a8I5yijVY4hyFw==', 'SnXrXrD7JUEaXbJghlsXzQ==', '2021-03-01 21:07:45');
INSERT INTO `persistent_logins` VALUES ('admin', 'iwHGhy6jYFR5D7YbGFOKXQ==', '8bT/DZOtjJAsCFKTgGCVbA==', '2021-03-05 14:00:08');
INSERT INTO `persistent_logins` VALUES ('admin', 'jTgjxPlrWvBDqE1NwkgYAA==', 'GX5TgypS7fjgYeb/cVscaQ==', '2021-03-04 16:29:06');
INSERT INTO `persistent_logins` VALUES ('admin', 'K2/Z+kdE4MYVhCycin/G/g==', 'zKd67/XiNxJ7JgHM/GpEYA==', '2021-03-03 21:49:28');
INSERT INTO `persistent_logins` VALUES ('admin', 'K8LQ1eZ9BEhcAF/x5dLHqw==', '3vyqE0+ueZLZ3WEFfvg6RQ==', '2021-03-05 15:19:54');
INSERT INTO `persistent_logins` VALUES ('admin', 'KQflCO986WiVjQ8edmWfOQ==', 'UVIpgdAHyB5sujFRi4Dmgw==', '2021-03-08 13:55:37');
INSERT INTO `persistent_logins` VALUES ('admin', 'kv457usZz+g9qHFmZiJzyQ==', 'bJuyZe9126Y3m7FB9eh6qQ==', '2021-03-05 15:23:09');
INSERT INTO `persistent_logins` VALUES ('admin', 'M1dGmicBgax82XZXm26DGQ==', 'yftCDdbHnnqif66DgrH3yw==', '2021-03-01 21:33:40');
INSERT INTO `persistent_logins` VALUES ('admin', 'Oep3tDrvrLuLLhwPc/rXdw==', 'yabH18rYcZUjd8w+rIFI2g==', '2021-03-02 14:22:46');
INSERT INTO `persistent_logins` VALUES ('admin', 'omZk5IRkVjIIH27OBFFYKA==', 'dOm8x5kpH8nCXxZ1iCUkmQ==', '2021-03-03 15:30:55');
INSERT INTO `persistent_logins` VALUES ('admin', 'Rj5ZYIa+nWO+CpPj0GchFg==', 'ythyu7rU+eNjz3rJoswe4Q==', '2021-03-03 15:27:14');
INSERT INTO `persistent_logins` VALUES ('admin', 'UL/wgo7U81fV3M+GRyACCw==', 'HxDbW5pVGSuAbt3rvaYTTg==', '2021-03-03 15:27:40');
INSERT INTO `persistent_logins` VALUES ('admin', 'vePEhz/9eddMxh+pgwHiGw==', 'zSUwEXJ2mfOxHvrwjK1QOw==', '2021-03-03 22:57:53');
INSERT INTO `persistent_logins` VALUES ('admin', 'VNUKDOenM2L5oNWJPT1/7w==', '/U6vcCOGQ3dYjNrBikA65Q==', '2021-03-03 20:45:11');
INSERT INTO `persistent_logins` VALUES ('admin', 'W70ZH/0NN4iA+0GJZMufSw==', 'O0s76GBYf+muz9pgPZd8JA==', '2021-03-02 19:56:51');
INSERT INTO `persistent_logins` VALUES ('admin', 'W71zJbOzSQV7s/JMlRvzjQ==', 'v/sV5Z0NmGesDbv8T6R0UQ==', '2021-03-04 15:27:40');
INSERT INTO `persistent_logins` VALUES ('admin', 'WHyJzqAI8+H41aFA7oNwBg==', 'e1SBDs1LVoXS/QkkUgSBUw==', '2021-03-03 21:50:13');
INSERT INTO `persistent_logins` VALUES ('admin', 'WIl7Uwk0uPbearMsspVAig==', '2hFHznhgC9ABd7RPYmGCGA==', '2021-03-05 21:22:40');
INSERT INTO `persistent_logins` VALUES ('admin', 'xWmSiIBquAhfCHoUGh8z/Q==', '6nalAe3tHhxEUx5Z+k2BYA==', '2021-03-03 21:51:57');
INSERT INTO `persistent_logins` VALUES ('admin', 'Y1YevwUVVg1wCKSBxhhO3w==', '0WSYPS7X3M1cRAezUst0Tg==', '2021-03-03 22:43:21');
INSERT INTO `persistent_logins` VALUES ('admin', 'YEvAFb7Vaq9IgPwglyXMiQ==', 'ULbZqd9QqXzWf+pv6ZmYEQ==', '2021-03-03 23:13:50');
INSERT INTO `persistent_logins` VALUES ('admin', 'yZsVNCqxyJ9tdan8+MwSYw==', 'twWXAcKmN9GBZzoWOKYDCg==', '2021-03-04 15:25:05');
INSERT INTO `persistent_logins` VALUES ('admin', 'zzcPkM0GMdLThfhFhb9YrQ==', 'xUCeY5WrM74Fj7+tb8QiKQ==', '2021-03-02 16:21:46');

-- ----------------------------
-- 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) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '客户地址',
  `contact` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '联系人',
  `name` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '客户名称',
  `number` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '客户联系电话',
  `remarks` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
  `is_del` int(11) NULL DEFAULT NULL COMMENT '是否删除',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '客户表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- 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);

-- ----------------------------
-- 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(0) NULL DEFAULT NULL COMMENT '退货日期',
  `customer_return_number` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '退货单号',
  `remarks` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
  `state` int(11) NULL DEFAULT NULL COMMENT '交易状态',
  `user_id` int(11) NULL DEFAULT NULL COMMENT '操作用户',
  `customer_id` int(11) NULL DEFAULT NULL COMMENT '客户id',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `FKd55ju83f0ntixagdvdrsmw10c`(`user_id`) USING BTREE,
  INDEX `FKl0ahdwa8slkocbfe57opembfx`(`customer_id`) USING BTREE,
  CONSTRAINT `FKd55ju83f0ntixagdvdrsmw10c` FOREIGN KEY (`user_id`) REFERENCES `t_user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `FKl0ahdwa8slkocbfe57opembfx` FOREIGN KEY (`customer_id`) REFERENCES `t_customer` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '客户退货单表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- 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);
INSERT INTO `t_customer_return_list` VALUES (6, 38, 38, '2017-11-03 00:00:00', 'XT201711030001', '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) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '商品编码',
  `model` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '商品型号',
  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '商品名称',
  `num` int(11) NOT NULL COMMENT '数量',
  `price` float NOT NULL COMMENT '价格',
  `total` float NOT NULL COMMENT '总价',
  `unit` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '单位',
  `customer_return_list_id` int(11) NULL DEFAULT NULL COMMENT '客户退货id',
  `type_id` int(11) NULL DEFAULT NULL COMMENT '商品类别',
  `goods_id` int(11) NULL DEFAULT NULL COMMENT '商品id',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `FKtqt67mbn96lxn8hvtl4piblhi`(`customer_return_list_id`) USING BTREE,
  INDEX `FK4sm5si4swbj3gae46jfk441yx`(`type_id`) USING BTREE,
  CONSTRAINT `FK4sm5si4swbj3gae46jfk441yx` FOREIGN KEY (`type_id`) REFERENCES `t_goods_type` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `FKtqt67mbn96lxn8hvtl4piblhi` FOREIGN KEY (`customer_return_list_id`) REFERENCES `t_customer_return_list` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 12 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '客户退货单商品表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- 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);
INSERT INTO `t_customer_return_list_goods` VALUES (10, '0003', '500g装', '野生东北黑木耳', 1, 38, 38, '袋', 6, 11, 11);

-- ----------------------------
-- 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(0) NULL DEFAULT NULL COMMENT '报损日期',
  `damage_number` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '报损单号',
  `remarks` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
  `user_id` int(11) NULL DEFAULT NULL COMMENT '操作用户id',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `FKpn094ma69sch1icjc2gu7xus`(`user_id`) USING BTREE,
  CONSTRAINT `FKpn094ma69sch1icjc2gu7xus` FOREIGN KEY (`user_id`) REFERENCES `t_user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 6 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '报损单表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- 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) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '商品编码',
  `model` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '型号',
  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '商品名称',
  `num` int(11) NOT NULL COMMENT '数量',
  `price` float NOT NULL COMMENT '价格',
  `total` float NOT NULL COMMENT '总价',
  `unit` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '单位',
  `damage_list_id` int(11) NULL DEFAULT NULL COMMENT '报损单id',
  `type_id` int(11) NULL DEFAULT NULL COMMENT '商品类别id',
  `goods_id` int(11) NULL DEFAULT NULL COMMENT '商品id',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `FKbf5m8mm3gctrnuubr9xkjamj8`(`damage_list_id`) USING BTREE,
  INDEX `FKdbdfmp09hlf2raktincwroe9n`(`type_id`) USING BTREE,
  CONSTRAINT `FKbf5m8mm3gctrnuubr9xkjamj8` FOREIGN KEY (`damage_list_id`) REFERENCES `t_damage_list` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `FKdbdfmp09hlf2raktincwroe9n` FOREIGN KEY (`type_id`) REFERENCES `t_goods_type` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '报损单商品表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- 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) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '商品编码',
  `inventory_quantity` int(11) NOT NULL COMMENT '库存数量',
  `min_num` int(11) NOT NULL COMMENT '库存下限',
  `model` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '商品型号',
  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '商品名称',
  `producer` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '生产产商',
  `purchasing_price` float NOT NULL COMMENT '采购价格',
  `remarks` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
  `selling_price` float NOT NULL COMMENT '出售价格',
  `unit` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '商品单位',
  `type_id` int(11) NULL DEFAULT NULL COMMENT '商品类别',
  `state` int(11) NOT NULL COMMENT '商品状态',
  `last_purchasing_price` float NOT NULL COMMENT '上次采购价格',
  `is_del` int(11) NULL DEFAULT NULL COMMENT '是否删除',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `FKlxnna5ngumghp4f279mmbjtyo`(`type_id`) USING BTREE,
  CONSTRAINT `FKlxnna5ngumghp4f279mmbjtyo` FOREIGN KEY (`type_id`) REFERENCES `t_goods_type` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 38 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '商品表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of t_goods
-- ----------------------------
INSERT INTO `t_goods` VALUES (1, '0001', 175, 1000, '红色装', '陶华碧老干妈香辣脆油辣椒', '贵州省贵阳南明老干妈风味食品有限公司', 6.32, '好卖', 8.5, '13', 10, 2, 8.5, 0);
INSERT INTO `t_goods` VALUES (2, '0002', 142, 400, 'Note8', '华为荣耀Note8', '华为计算机系统有限公司', 1950.05, '热销', 2200, '5', 16, 2, 2220, 0);
INSERT INTO `t_goods` VALUES (11, '0003', 2897, 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', 36, 1999, '300g装', '冰糖金桔干', '揭西县同心食品有限公司', 5.1, '', 13, '3', 11, 2, 5, 0);
INSERT INTO `t_goods` VALUES (15, '0007', 100651, 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', 1000, '', 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);

-- ----------------------------
-- 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) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '类别名',
  `p_id` int(11) NULL DEFAULT NULL COMMENT '父级类别id',
  `state` int(11) NULL DEFAULT NULL COMMENT '节点类型',
  `icon` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '节点图标',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 28 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '商品类别表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- 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) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '单位名',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 13 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '商品单位表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- 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) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `time` datetime(0) NULL DEFAULT NULL,
  `type` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
  `user_id` int(11) NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `FKbvn5yabu3vqwvtjoh32i9r4ip`(`user_id`) USING BTREE,
  CONSTRAINT `FKbvn5yabu3vqwvtjoh32i9r4ip` FOREIGN KEY (`user_id`) REFERENCES `t_user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 3226 CHARACTER SET = utf8 COLLATE = utf8_general_ci 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) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '菜单图标',
  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '菜单名称',
  `state` int(11) NULL DEFAULT NULL COMMENT '节点类型',
  `url` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '菜单url',
  `p_id` int(11) NULL DEFAULT NULL COMMENT '上级菜单id',
  `acl_value` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '权限码',
  `grade` int(255) NULL DEFAULT NULL COMMENT '菜单层级',
  `is_del` int(11) NULL DEFAULT 0 COMMENT '是否删除',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `FKsni20f28wjqrmpp44uawa2ky4`(`p_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 21 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '菜单表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- 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', 2, 0);
INSERT INTO `t_menu` VALUES (6, 'menu-6', '安全退出', 0, '/signout', 2, '101002', 2, 0);
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);

-- ----------------------------
-- 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(0) NULL DEFAULT NULL COMMENT '报溢日期',
  `overflow_number` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '报溢单号',
  `remarks` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
  `user_id` int(11) NULL DEFAULT NULL COMMENT '操作用户id',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `FK3bu8hj2xniqwbrtg6ls6b8ej2`(`user_id`) USING BTREE,
  CONSTRAINT `FK3bu8hj2xniqwbrtg6ls6b8ej2` FOREIGN KEY (`user_id`) REFERENCES `t_user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '报溢单表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- 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 (4, '2017-10-27 00:00:00', 'BY201710270002', 'ccc', 1);
INSERT INTO `t_overflow_list` VALUES (5, '2021-03-04 00:00:00', 'BY202103040001', '', 1);

-- ----------------------------
-- 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) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '编码',
  `model` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '型号',
  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '商品名',
  `num` int(11) NOT NULL COMMENT '数量',
  `price` float NOT NULL COMMENT '价格',
  `total` float NOT NULL COMMENT '总价',
  `unit` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '单位',
  `overflow_list_id` int(11) NULL DEFAULT NULL COMMENT '报溢单id',
  `type_id` int(11) NULL DEFAULT NULL COMMENT '商品类别id',
  `goods_id` int(11) NULL DEFAULT NULL COMMENT '商品id',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `FKd3s9761mgl456tn2xb0d164h7`(`overflow_list_id`) USING BTREE,
  INDEX `FK8t46iik5kpciki8fnqtiuq5q3`(`type_id`) USING BTREE,
  CONSTRAINT `FK8t46iik5kpciki8fnqtiuq5q3` FOREIGN KEY (`type_id`) REFERENCES `t_goods_type` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `FKd3s9761mgl456tn2xb0d164h7` FOREIGN KEY (`overflow_list_id`) REFERENCES `t_overflow_list` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '报溢单商品表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- 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 (6, '0004', '2斤装', '新疆红枣', 2, 13, 26, '袋', 4, 10, 12);
INSERT INTO `t_overflow_list_goods` VALUES (7, '0006', '300g装', '冰糖金桔干', 3, 5, 15, '盒', 4, 11, 14);
INSERT INTO `t_overflow_list_goods` VALUES (8, '0002', 'Note8', '华为荣耀Note8', 20, 2220, 44400, '台', 5, 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(0) NULL DEFAULT NULL COMMENT '进货日期',
  `remarks` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
  `state` int(11) NOT NULL COMMENT '交易状态',
  `purchase_number` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '进货单号',
  `supplier_id` int(11) NULL DEFAULT NULL COMMENT '供应商',
  `user_id` int(11) NULL DEFAULT NULL COMMENT '操作用户',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `FK5j2dev8b2b5d0l69nb8vtr4yb`(`supplier_id`) USING BTREE,
  INDEX `FK69s6eyxr4wwvsywe9hbthef1h`(`user_id`) USING BTREE,
  CONSTRAINT `FK5j2dev8b2b5d0l69nb8vtr4yb` FOREIGN KEY (`supplier_id`) REFERENCES `t_supplier` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `FK69s6eyxr4wwvsywe9hbthef1h` FOREIGN KEY (`user_id`) REFERENCES `t_user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 42 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '进货单' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of t_purchase_list
-- ----------------------------
INSERT INTO `t_purchase_list` VALUES (25, 73299, 73299, '2017-10-27 00:00:00', 'cc', 1, 'JH201710270001', 2, 1);
INSERT INTO `t_purchase_list` VALUES (26, 69099, 69099, '2017-10-28 00:00:00', 'cc', 1, 'JH201710280001', 2, 1);
INSERT INTO `t_purchase_list` VALUES (28, 17, 17, '2017-10-31 00:00:00', 'cc', 1, 'JH201710310001', 5, 1);
INSERT INTO `t_purchase_list` VALUES (29, 463, 463, '2017-11-03 00:00:00', 'cc', 1, 'JH201711030001', 1, 1);
INSERT INTO `t_purchase_list` VALUES (30, 1240, 1240, '2017-11-03 00:00:00', 'cc', 1, 'JH201711030002', 1, 1);
INSERT INTO `t_purchase_list` VALUES (41, 11185, 11185, '2021-03-02 00:00:00', '', 1, 'JH202103020001', 1, 1);
INSERT INTO `t_purchase_list` VALUES (42, 170, 170, '2021-03-05 00:00:00', '', 1, 'JH202103050001', 1, 1);

-- ----------------------------
-- 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) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '商品编码',
  `model` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '商品型号',
  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '商品名称',
  `num` int(11) NOT NULL COMMENT '数量',
  `price` float NOT NULL COMMENT '单价',
  `total` float NOT NULL COMMENT '总价',
  `unit` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '商品单位',
  `purchase_list_id` int(11) NULL DEFAULT NULL COMMENT '进货单id',
  `type_id` int(11) NULL DEFAULT NULL COMMENT '商品类别',
  `goods_id` int(11) NULL DEFAULT NULL COMMENT '商品id',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `FKfvdvgcebqkkokyn0o00idqnpy`(`purchase_list_id`) USING BTREE,
  INDEX `FK83ikbi2x3epn49fwcco8jlfwu`(`type_id`) USING BTREE,
  CONSTRAINT `FK83ikbi2x3epn49fwcco8jlfwu` FOREIGN KEY (`type_id`) REFERENCES `t_goods_type` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `FKfvdvgcebqkkokyn0o00idqnpy` FOREIGN KEY (`purchase_list_id`) REFERENCES `t_purchase_list` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 58 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '进货单商品表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of t_purchase_list_goods
-- ----------------------------
INSERT INTO `t_purchase_list_goods` VALUES (35, '0002', 'Note8', '华为荣耀Note8', 33, 2220, 73260, '台', 25, 16, 2);
INSERT INTO `t_purchase_list_goods` VALUES (36, '0004', '2斤装', '新疆红枣', 3, 13, 39, '袋', 25, 10, 12);
INSERT INTO `t_purchase_list_goods` VALUES (37, '0003', '500g装', '野生东北黑木耳', 3000, 23, 69000, '袋', 26, 11, 11);
INSERT INTO `t_purchase_list_goods` VALUES (38, '0007', '500g装', '吉利人家牛肉味蛋糕', 22, 4.5, 99, '袋', 26, 11, 15);
INSERT INTO `t_purchase_list_goods` VALUES (41, '0001', '红色装', '陶华碧老干妈香辣脆油辣椒', 2, 8.5, 17, '瓶', 28, 10, 1);
INSERT INTO `t_purchase_list_goods` VALUES (42, '0001', '红色装', '陶华碧老干妈香辣脆油辣椒', 4, 8.5, 34, '瓶', 29, 10, 1);
INSERT INTO `t_purchase_list_goods` VALUES (43, '0004', '2斤装', '新疆红枣', 33, 13, 429, '袋', 29, 10, 12);
INSERT INTO `t_purchase_list_goods` VALUES (44, '0001', '红色装', '陶华碧老干妈香辣脆油辣椒', 100, 8.5, 850, '瓶', 30, 10, 1);
INSERT INTO `t_purchase_list_goods` VALUES (45, '0004', '2斤装', '新疆红枣', 30, 13, 390, '袋', 30, 10, 12);
INSERT INTO `t_purchase_list_goods` VALUES (46, '0015', 'X', ' iPhone X', 30, 0, 0, '台', 30, 16, 24);
INSERT INTO `t_purchase_list_goods` VALUES (56, '0001', '红色装', '陶华碧老干妈香辣脆油辣椒', 10, 8.5, 85, '瓶', 41, 10, 1);
INSERT INTO `t_purchase_list_goods` VALUES (57, '0002', 'Note8', '华为荣耀Note8', 5, 2220, 11100, '台', 41, 16, 2);
INSERT INTO `t_purchase_list_goods` VALUES (58, '0005', '散装500克', '麦片燕麦巧克力', 20, 8.5, 170, '袋', 42, 11, 13);

-- ----------------------------
-- 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) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
  `return_date` datetime(0) NULL DEFAULT NULL COMMENT '退货日期',
  `return_number` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '退货单号',
  `state` int(11) NOT NULL COMMENT '交易状态',
  `supplier_id` int(11) NULL DEFAULT NULL COMMENT '供应商',
  `user_id` int(11) NULL DEFAULT NULL COMMENT '操作用户',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `FK4qxjj8bvj2etne243xluni0vn`(`supplier_id`) USING BTREE,
  INDEX `FK904juw2v1hm2av0ig26gae9jb`(`user_id`) USING BTREE,
  CONSTRAINT `FK4qxjj8bvj2etne243xluni0vn` FOREIGN KEY (`supplier_id`) REFERENCES `t_supplier` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `FK904juw2v1hm2av0ig26gae9jb` FOREIGN KEY (`user_id`) REFERENCES `t_user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '退货单表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of t_return_list
-- ----------------------------
INSERT INTO `t_return_list` VALUES (4, 4464, 4464, 'cc', '2017-10-27 00:00:00', 'TH201710270001', 1, 2, 1);
INSERT INTO `t_return_list` VALUES (5, 4440, 4440, 'cc', '2017-11-03 00:00:00', 'TH201711030001', 1, 2, 1);
INSERT INTO `t_return_list` VALUES (7, 85, 85, '', '2021-03-03 00:00:00', 'TH202103030001', 1, 1, 1);
INSERT INTO `t_return_list` VALUES (8, 230, 230, '', '2021-03-03 00:00:00', 'TH202103030002', 1, 1, 1);

-- ----------------------------
-- 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) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '商品编码',
  `model` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '商品型号',
  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '商品名称',
  `num` int(11) NOT NULL COMMENT '数量',
  `price` float NOT NULL COMMENT '单价',
  `total` float NOT NULL COMMENT '总价',
  `unit` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '单位',
  `return_list_id` int(11) NULL DEFAULT NULL COMMENT '退货单id',
  `type_id` int(11) NULL DEFAULT NULL COMMENT '商品类别',
  `goods_id` int(11) NULL DEFAULT NULL COMMENT '商品id',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `FKemclu281vyvyk063c3foafq1w`(`return_list_id`) USING BTREE,
  INDEX `FKa1prpd96fcs0x2oe0omny9vio`(`type_id`) USING BTREE,
  CONSTRAINT `FKa1prpd96fcs0x2oe0omny9vio` FOREIGN KEY (`type_id`) REFERENCES `t_goods_type` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `FKemclu281vyvyk063c3foafq1w` FOREIGN KEY (`return_list_id`) REFERENCES `t_return_list` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 13 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '退货单商品表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of t_return_list_goods
-- ----------------------------
INSERT INTO `t_return_list_goods` VALUES (7, '0002', 'Note8', '华为荣耀Note8', 2, 2220, 4440, '台', 4, 16, 2);
INSERT INTO `t_return_list_goods` VALUES (8, '0005', '散装500克', '麦片燕麦巧克力', 3, 8, 24, '袋', 4, 11, 13);
INSERT INTO `t_return_list_goods` VALUES (9, '0002', 'Note8', '华为荣耀Note8', 2, 2220, 4440, '台', 5, 16, 2);
INSERT INTO `t_return_list_goods` VALUES (10, '0015', 'X', ' iPhone X', 3, 0, 0, '台', 5, 16, 24);
INSERT INTO `t_return_list_goods` VALUES (12, '0001', '红色装', '陶华碧老干妈香辣脆油辣椒', 10, 8.5, 85, '瓶', 7, 10, 1);
INSERT INTO `t_return_list_goods` VALUES (13, '0003', '500g装', '野生东北黑木耳', 10, 23, 230, '袋', 8, 11, 11);

-- ----------------------------
-- 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) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '角色名',
  `remarks` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '描述',
  `is_del` int(11) UNSIGNED NULL DEFAULT 0 COMMENT '是否删除',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '角色表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- 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, '仓库管理员', '仓库管理员', NULL, 0);
INSERT INTO `t_role` VALUES (9, '总经理', '总经理', NULL, 1);
INSERT INTO `t_role` VALUES (10, 'test', '管理员02', '', 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) NULL DEFAULT NULL COMMENT '菜单id',
  `role_id` int(11) NULL DEFAULT NULL COMMENT '角色id',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `FKsonb0rbt2u99hbrqqvv3r0wse`(`role_id`) USING BTREE,
  INDEX `FKhayg4ib6v7h1wyeyxhq6xlddq`(`menu_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 148 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '角色菜单表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of t_role_menu
-- ----------------------------
INSERT INTO `t_role_menu` VALUES (134, 1, 1);
INSERT INTO `t_role_menu` VALUES (135, 2, 1);
INSERT INTO `t_role_menu` VALUES (136, 3, 1);
INSERT INTO `t_role_menu` VALUES (137, 7, 1);
INSERT INTO `t_role_menu` VALUES (138, 8, 1);
INSERT INTO `t_role_menu` VALUES (139, 9, 1);
INSERT INTO `t_role_menu` VALUES (140, 10, 1);
INSERT INTO `t_role_menu` VALUES (141, 4, 1);
INSERT INTO `t_role_menu` VALUES (142, 11, 1);
INSERT INTO `t_role_menu` VALUES (143, 12, 1);
INSERT INTO `t_role_menu` VALUES (144, 13, 1);
INSERT INTO `t_role_menu` VALUES (145, 14, 1);
INSERT INTO `t_role_menu` VALUES (146, 15, 1);
INSERT INTO `t_role_menu` VALUES (147, 5, 1);
INSERT INTO `t_role_menu` VALUES (148, 6, 1);

-- ----------------------------
-- 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) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
  `sale_date` datetime(0) NULL DEFAULT NULL COMMENT '销售日期',
  `sale_number` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '销售单号',
  `state` int(11) NULL DEFAULT NULL COMMENT '交易状态',
  `user_id` int(11) NULL DEFAULT NULL COMMENT '操作用户',
  `customer_id` int(11) NULL DEFAULT NULL COMMENT '客户id',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `FK34bnujemrdqimbhg133enp8k8`(`user_id`) USING BTREE,
  INDEX `FKox4qfs87eu3fvwdmrvelqhi8e`(`customer_id`) USING BTREE,
  CONSTRAINT `FK34bnujemrdqimbhg133enp8k8` FOREIGN KEY (`user_id`) REFERENCES `t_user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `FKox4qfs87eu3fvwdmrvelqhi8e` FOREIGN KEY (`customer_id`) REFERENCES `t_customer` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 27 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '销售单表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- 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', 1, 1, 2);
INSERT INTO `t_sale_list` VALUES (7, 4400, 4400, 'cccc', '2017-03-30 00:00:00', 'XS201703300001', 1, 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', 2, 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);

-- ----------------------------
-- 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) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '商品编码',
  `model` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '商品型号',
  `name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '商品名称',
  `num` int(11) NOT NULL COMMENT '数量',
  `price` float NOT NULL COMMENT '单价',
  `total` float NOT NULL COMMENT '总价',
  `unit` varchar(10) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '单位',
  `sale_list_id` int(11) NULL DEFAULT NULL COMMENT '销售单',
  `type_id` int(11) NULL DEFAULT NULL COMMENT '商品类别',
  `goods_id` int(11) NULL DEFAULT NULL COMMENT '商品id',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `FK20ehd6ta9geyql4hxtdsnhbox`(`sale_list_id`) USING BTREE,
  INDEX `FKn9i5p1d8f0gek5x7q45cq8ibw`(`type_id`) USING BTREE,
  CONSTRAINT `FK20ehd6ta9geyql4hxtdsnhbox` FOREIGN KEY (`sale_list_id`) REFERENCES `t_sale_list` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `FKn9i5p1d8f0gek5x7q45cq8ibw` FOREIGN KEY (`type_id`) REFERENCES `t_goods_type` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 49 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '销售单商品表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- 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);

-- ----------------------------
-- 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) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '联系地址',
  `contact` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '联系人',
  `name` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '供应商名称',
  `number` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '联系电话',
  `remarks` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
  `is_del` int(11) NULL DEFAULT NULL COMMENT '是否删除',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 15 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '供应商表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- 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', 1);
INSERT INTO `t_supplier` VALUES (13, '南京将军路800号', '小吴', '南京大陆食品公司', '1243-2135487', 'cc', 1);
INSERT INTO `t_supplier` VALUES (14, '32423', 'test', 'test', '33', NULL, 1);
INSERT INTO `t_supplier` VALUES (15, '杭州滨江', 'test', '男士马甲', '33', 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) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注名',
  `password` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '密码',
  `true_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '真实姓名',
  `user_name` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户名',
  `remarks` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '备注',
  `is_del` int(11) NULL DEFAULT 0 COMMENT '是否删除',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of t_user
-- ----------------------------
INSERT INTO `t_user` VALUES (1, 'admin', '$2a$10$PSYNTHhzJdEERw6e9ge45upuKjdfLoHEXGingO3529NQqS8XyA2l.', '乐字节', 'admin', 'admin', 0);
INSERT INTO `t_user` VALUES (2, '主管', '$2a$10$82VhQUlpNAK2M1P9XUuESed8.Sh3irIl8LGcrH13M3uAk6Bl5kor.', '乐字节', 'jack', '乐字节', 0);
INSERT INTO `t_user` VALUES (3, '销售经理', '$2a$10$82VhQUlpNAK2M1P9XUuESed8.Sh3irIl8LGcrH13M3uAk6Bl5kor.', '玛丽', 'marry', '33', 1);

-- ----------------------------
-- 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) NULL DEFAULT NULL COMMENT '角色id',
  `user_id` int(11) NULL DEFAULT NULL COMMENT '用户id',
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `FKa9c8iiy6ut0gnx491fqx4pxam`(`role_id`) USING BTREE,
  INDEX `FKq5un6x7ecoef5w1n39cop66kl`(`user_id`) USING BTREE,
  CONSTRAINT `FKa9c8iiy6ut0gnx491fqx4pxam` FOREIGN KEY (`role_id`) REFERENCES `t_role` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT,
  CONSTRAINT `FKq5un6x7ecoef5w1n39cop66kl` FOREIGN KEY (`user_id`) REFERENCES `t_user` (`id`) ON DELETE RESTRICT ON UPDATE RESTRICT
) ENGINE = InnoDB AUTO_INCREMENT = 42 CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '用户角色表' ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of t_user_role
-- ----------------------------
INSERT INTO `t_user_role` VALUES (42, 1, 1);

SET FOREIGN_KEY_CHECKS = 1;

Wolf of Wall Street

关注

0
点赞
踩
3

收藏

觉得还不错? 一键收藏
0
评论
MySQL建表语句综合

带主键和外键，索引，和约束条件的第一张表/* Navicat Premium Data Transfer Source Server : MySQL_local Source Server Type : MySQL Source Server Version : 80026 Source Host : localhost:3306 Source Schema : ljp_jxc Target Server Type .
复制链接

扫一扫