带主键和外键、索引和约束条件
第一张表 /* 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:2