/*
Navicat MySQL Data Transfer

Source Server         : mysql
Source Server Version : 50641
Source Host           : localhost:3306
Source Database       : lerp

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

Date: 2020-08-04 21:09:32
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `tb_account`
-- ----------------------------
DROP TABLE IF EXISTS `tb_account`;
CREATE TABLE `tb_account` (
  `accountId` int(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `accountName` varchar(50) DEFAULT NULL COMMENT '名称',
  `serialNo` varchar(50) DEFAULT NULL COMMENT '编号',
  `initialAmount` double(24,6) DEFAULT NULL COMMENT '期初金额',
  `currentAmount` double(24,6) DEFAULT NULL COMMENT '当前余额',
  `remark` varchar(100) DEFAULT NULL COMMENT '备注',
  `isDefault` int(1) DEFAULT NULL COMMENT '是否默认',
  `tenantId` int(20) DEFAULT NULL COMMENT '租户id',
  `deleteFlag` varchar(1) DEFAULT '0' COMMENT '删除标记，0未删除，1删除',
  PRIMARY KEY (`accountId`)
) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8 COMMENT='账户信息';

-- ----------------------------
-- Records of tb_account
-- ----------------------------
INSERT INTO `tb_account` VALUES ('4', '南通建行', '652346523465234623', '1200.000000', '215.000000', '建行账户', '0', null, '0');
INSERT INTO `tb_account` VALUES ('9', '流动总账', '65234624523452364', '2000.000000', '393.000000', '现在账户', '1', null, '0');

-- ----------------------------
-- Table structure for `tb_account_head`
-- ----------------------------
DROP TABLE IF EXISTS `tb_account_head`;
CREATE TABLE `tb_account_head` (
  `accountHeadId` int(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `type` varchar(50) DEFAULT NULL COMMENT '类型(支出/收入/收款/付款/转账)',
  `organId` int(20) DEFAULT NULL COMMENT '单位Id(收款/付款单位)',
  `handsPersonId` int(20) DEFAULT NULL COMMENT '经手人Id',
  `changeAmount` double(24,6) DEFAULT NULL COMMENT '变动金额(优惠/收款/付款/实付)',
  `totalPrice` double(24,6) DEFAULT NULL COMMENT '合计金额',
  `accountId` int(20) DEFAULT NULL COMMENT '账户(收款/付款)',
  `billNo` varchar(50) DEFAULT NULL COMMENT '单据编号',
  `billTime` datetime DEFAULT NULL COMMENT '单据日期',
  `remark` varchar(100) DEFAULT NULL COMMENT '备注',
  `tenantId` int(20) DEFAULT NULL COMMENT '租户id',
  `deleteFlag` varchar(1) DEFAULT '0' COMMENT '删除标记，0未删除，1删除',
  PRIMARY KEY (`accountHeadId`),
  KEY `FK9F4C0D8DB610FC06` (`organId`),
  KEY `FK9F4C0D8DAAE50527` (`accountId`),
  KEY `FK9F4C0D8DC4170B37` (`handsPersonId`)
) ENGINE=InnoDB AUTO_INCREMENT=101 DEFAULT CHARSET=utf8 COMMENT='财务主表';

-- ----------------------------
-- Records of tb_account_head
-- ----------------------------
INSERT INTO `tb_account_head` VALUES ('99', '收款', '60', '1', '0.000000', '20.000000', '4', 'SK20191228121908', '2019-12-28 12:19:08', '', '1', '0');
INSERT INTO `tb_account_head` VALUES ('100', '付款', '51', '1', '0.000000', '20.000000', '4', 'FK20191228121920', '2019-12-28 12:19:20', '', '1', '0');

-- ----------------------------
-- Table structure for `tb_account_item`
-- ----------------------------
DROP TABLE IF EXISTS `tb_account_item`;
CREATE TABLE `tb_account_item` (
  `accountItemId` int(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `headerId` int(20) NOT NULL COMMENT '表头Id',
  `accountId` int(20) DEFAULT NULL COMMENT '账户Id',
  `inOutItemId` int(20) DEFAULT NULL COMMENT '收支项目Id',
  `eachAmount` double(24,6) DEFAULT NULL COMMENT '单项金额',
  `remark` varchar(100) DEFAULT NULL COMMENT '单据备注',
  `tenantId` int(20) DEFAULT NULL COMMENT '租户id',
  `deleteFlag` varchar(1) DEFAULT '0' COMMENT '删除标记，0未删除，1删除',
  PRIMARY KEY (`accountItemId`),
  KEY `FK9F4CBAC0AAE50527` (`accountId`),
  KEY `FK9F4CBAC0C5FE6007` (`headerId`),
  KEY `FK9F4CBAC0D203EDC5` (`inOutItemId`)
) ENGINE=InnoDB AUTO_INCREMENT=63 DEFAULT CHARSET=utf8 COMMENT='财务子表';

-- ----------------------------
-- Records of tb_account_item
-- ----------------------------
INSERT INTO `tb_account_item` VALUES ('58', '57', '9', null, '1000.000000', '', '1', '0');
INSERT INTO `tb_account_item` VALUES ('62', '61', '4', null, '33.000000', '', '1', '0');

-- ----------------------------
-- Table structure for `tb_depot`
-- ----------------------------
DROP TABLE IF EXISTS `tb_depot`;
CREATE TABLE `tb_depot` (
  `depotId` int(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `depotName` varchar(20) DEFAULT NULL COMMENT '仓库名称',
  `address` varchar(50) DEFAULT NULL COMMENT '仓库地址',
  `warehousing` double(24,6) DEFAULT NULL COMMENT '仓储费',
  `truckage` double(24,6) DEFAULT NULL COMMENT '搬运费',
  `type` int(10) DEFAULT NULL COMMENT '类型',
  `sort` varchar(10) DEFAULT NULL COMMENT '排序',
  `remark` varchar(100) DEFAULT NULL COMMENT '描述',
  `principal` int(20) DEFAULT NULL COMMENT '负责人',
  `tenantId` int(20) DEFAULT NULL COMMENT '租户id',
  `deleteFlag` varchar(1) DEFAULT '0' COMMENT '删除标记，0未删除，1删除',
  `isDefault` int(1) DEFAULT NULL COMMENT '是否默认',
  PRIMARY KEY (`depotId`)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8 COMMENT='仓库表';

-- ----------------------------
-- Records of tb_depot
-- ----------------------------
INSERT INTO `tb_depot` VALUES ('1', '叠石桥店', '地址222', '0.000000', '0.000000', '0', '2', '上海33', '17', '1', '0', '0');
INSERT INTO `tb_depot` VALUES ('2', '公司总部', '地址12355', '0.000000', '0.000000', '0', '1', '总部', '18', '1', '0', '1');
INSERT INTO `tb_depot` VALUES ('3', '金沙店', '地址666', '0.000000', '0.000000', '0', '3', '苏州', '17', '1', '0', '0');
INSERT INTO `tb_depot` VALUES ('4', 'aa', 'qqqq', '0.000000', '0.000000', '0', '4', 'aaaa', '0', '1', '1', '0');
INSERT INTO `tb_depot` VALUES ('5', 'bb', 'aaa', '0.000000', '0.000000', '0', '111', '1', '0', '1', '1', '0');
INSERT INTO `tb_depot` VALUES ('6', 'www', 'ww', '0.000000', '0.000000', '0', '22', 'wwwww', '0', '1', '1', '0');
INSERT INTO `tb_depot` VALUES ('7', 'vvv', 'vv1', '0.000000', '0.000000', '0', '551', 'vv1', '0', '1', '1', '0');
INSERT INTO `tb_depot` VALUES ('8', 'rrrr', 'rrr', '0.000000', '0.000000', '0', '4rrr', 'rr', '0', '1', '1', '0');

-- ----------------------------
-- Table structure for `tb_depot_head`
-- ----------------------------
DROP TABLE IF EXISTS `tb_depot_head`;
CREATE TABLE `tb_depot_head` (
  `depotHeadId` int(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `type` varchar(50) DEFAULT NULL COMMENT '类型(出库/入库)',
  `subType` varchar(50) DEFAULT NULL COMMENT '出入库分类',
  `defaultNumber` varchar(50) DEFAULT NULL COMMENT '初始票据号',
  `number` varchar(50) DEFAULT NULL COMMENT '票据号',
  `operPersonName` varchar(50) DEFAULT NULL COMMENT '操作员名字',
  `createTime` datetime DEFAULT NULL COMMENT '创建时间',
  `operTime` datetime DEFAULT NULL COMMENT '出入库时间',
  `organId` int(20) DEFAULT NULL COMMENT '供应商Id',
  `handsPersonId` int(20) DEFAULT NULL COMMENT '采购/领料-经手人Id',
  `accountId` int(20) DEFAULT NULL COMMENT '账户Id',
  `changeAmount` double(24,6) DEFAULT NULL COMMENT '变动金额(收款/付款)',
  `totalPrice` double(24,6) DEFAULT NULL COMMENT '合计金额',
  `payType` varchar(50) DEFAULT NULL COMMENT '付款类型(现金、记账等)',
  `remark` varchar(1000) DEFAULT NULL COMMENT '备注',
  `salesMan` varchar(50) DEFAULT NULL COMMENT '业务员（可以多个）',
  `accountIdList` varchar(50) DEFAULT NULL COMMENT '多账户ID列表',
  `accountMoneyList` varchar(200) DEFAULT '' COMMENT '多账户金额列表',
  `discount` double(24,6) DEFAULT NULL COMMENT '优惠率',
  `discountMoney` double(24,6) DEFAULT NULL COMMENT '优惠金额',
  `discountLastMoney` double(24,6) DEFAULT NULL COMMENT '优惠后金额',
  `otherMoney` double(24,6) DEFAULT NULL COMMENT '销售或采购费用合计',
  `otherMoneyList` varchar(200) DEFAULT NULL COMMENT '销售或采购费用涉及项目Id数组（包括快递、招待等）',
  `otherMoneyItem` varchar(200) DEFAULT NULL COMMENT '销售或采购费用涉及项目（包括快递、招待等）',
  `accountDay` int(10) DEFAULT NULL COMMENT '结算天数',
  `status` varchar(1) DEFAULT '0' COMMENT '状态，0未审核、1已审核、2已转采购|销售',
  `linkNumber` varchar(50) DEFAULT NULL COMMENT '关联订单号',
  `tenantId` int(20) DEFAULT NULL COMMENT '租户id',
  `deleteFlag` varchar(1) DEFAULT '0' COMMENT '删除标记，0未删除，1删除',
  PRIMARY KEY (`depotHeadId`),
  KEY `FK2A80F214C4170B37` (`handsPersonId`),
  KEY `FK2A80F214B610FC06` (`organId`),
  KEY `FK2A80F214AAE50527` (`accountId`)
) ENGINE=InnoDB AUTO_INCREMENT=195 DEFAULT CHARSET=utf8 COMMENT='单据主表';

-- ----------------------------
-- Records of tb_depot_head
-- ----------------------------
INSERT INTO `tb_depot_head` VALUES ('193', '出库', '销售', 'XSCK00000000268', 'XSCK00000000268', '季圣华', '2019-04-29 23:41:02', '2020-02-20 23:52:17', '51', null, '4', '300.000000', '300.000000', '现付', '', '', '', '', '0.000000', '0.000000', '300.000000', '0.000000', '', '', null, '0', '', '1', '0');
INSERT INTO `tb_depot_head` VALUES ('194', '入库', '采购', 'CGRK00000000272', 'CGRK00000000272', '季圣华', '2019-04-30 22:33:24', '2020-02-20 23:50:28', '51', '1', '4', '1000.000000', '1000.000000', '现付', '', '', '', '', '0.000000', '0.000000', '800.000000', '0.000000', '[\"undefined\"]', '[\"undefined\"]', null, '0', '', '1', '0');

-- ----------------------------
-- Table structure for `tb_depot_item`
-- ----------------------------
DROP TABLE IF EXISTS `tb_depot_item`;
CREATE TABLE `tb_depot_item` (
  `depotItemId` int(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `headerId` int(20) NOT NULL COMMENT '表头Id',
  `materialId` int(20) NOT NULL COMMENT '材料Id',
  `materialExtendId` int(20) DEFAULT NULL COMMENT '商品扩展id',
  `mUnit` varchar(20) DEFAULT NULL COMMENT '商品计量单位',
  `operNumber` double(24,6) DEFAULT NULL COMMENT '数量',
  `basicNumber` double(24,6) DEFAULT NULL COMMENT '基础数量，如kg、瓶',
  `unitPrice` double(24,6) DEFAULT NULL COMMENT '单价',
  `taxUnitPrice` double(24,6) DEFAULT NULL COMMENT '含税单价',
  `allPrice` double(24,6) DEFAULT NULL COMMENT '金额',
  `remark` varchar(200) DEFAULT NULL COMMENT '描述',
  `img` varchar(50) DEFAULT NULL COMMENT '图片',
  `incidentals` double(24,6) DEFAULT NULL COMMENT '运杂费',
  `depotId` int(20) DEFAULT NULL COMMENT '仓库ID（库存是统计出来的）',
  `anotherDepotId` int(20) DEFAULT NULL COMMENT '调拨时，对方仓库Id',
  `taxRate` double(24,6) DEFAULT NULL COMMENT '税率',
  `taxMoney` double(24,6) DEFAULT NULL COMMENT '税额',
  `taxLastMoney` double(24,6) DEFAULT NULL COMMENT '价税合计',
  `otherField1` varchar(50) DEFAULT NULL COMMENT '自定义字段1-名称',
  `otherField2` varchar(50) DEFAULT NULL COMMENT '自定义字段2-型号',
  `otherField3` varchar(50) DEFAULT NULL COMMENT '自定义字段3-制造商',
  `otherField4` varchar(50) DEFAULT NULL COMMENT '自定义字段4',
  `otherField5` varchar(50) DEFAULT NULL COMMENT '自定义字段5',
  `mType` varchar(20) DEFAULT NULL COMMENT '商品类型',
  `tenantId` int(20) DEFAULT NULL COMMENT '租户id',
  `deleteFlag` varchar(1) DEFAULT '0' COMMENT '删除标记，0未删除，1删除',
  PRIMARY KEY (`depotItemId`),
  KEY `FK2A819F475D61CCF7` (`materialId`),
  KEY `FK2A819F474BB6190E` (`headerId`),
  KEY `FK2A819F479485B3F5` (`depotId`),
  KEY `FK2A819F47729F5392` (`anotherDepotId`)
) ENGINE=InnoDB AUTO_INCREMENT=199 DEFAULT CHARSET=utf8 COMMENT='单据子表';

-- ----------------------------
-- Records of tb_depot_item
-- ----------------------------
INSERT INTO `tb_depot_item` VALUES ('198', '198', '569', '3', '只', '12.000000', '12.000000', '10.000000', '10.000000', '120.000000', '', '', '0.000000', '14', null, '0.000000', '0.000000', '120.000000', '', '', '', '', '', '', '63', '0');

-- ----------------------------
-- Table structure for `tb_functions`
-- ----------------------------
DROP TABLE IF EXISTS `tb_functions`;
CREATE TABLE `tb_functions` (
  `functionsId` int(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `number` varchar(50) DEFAULT NULL COMMENT '编号',
  `name` varchar(50) DEFAULT NULL COMMENT '名称',
  `pNumber` varchar(50) DEFAULT NULL COMMENT '上级编号',
  `url` varchar(100) DEFAULT NULL COMMENT '链接',
  `state` int(1) DEFAULT NULL COMMENT '收缩',
  `sort` varchar(50) DEFAULT NULL COMMENT '排序',
  `enabled` int(1) DEFAULT NULL COMMENT '启用',
  `type` varchar(50) DEFAULT NULL COMMENT '类型',
  `pushBtn` varchar(50) DEFAULT NULL COMMENT '功能按钮',
  `icon` varchar(50) DEFAULT NULL COMMENT '图标',
  `deleteFlag` varchar(1) DEFAULT '0' COMMENT '删除标记，0未删除，1删除',
  PRIMARY KEY (`functionsId`)
) ENGINE=InnoDB AUTO_INCREMENT=246 DEFAULT CHARSET=utf8 COMMENT='功能模块表';

-- ----------------------------
-- Records of tb_functions
-- ----------------------------
INSERT INTO `tb_functions` VALUES ('1', '0001', '系统管理', '0', '', '1', '0910', '1', '电脑版', '', 'icon-settings', '0');
INSERT INTO `tb_functions` VALUES ('13', '000102', '角色管理', '0001', '../page/role', '0', '0130', '1', '电脑版', '', 'icon-notebook', '0');
INSERT INTO `tb_functions` VALUES ('14', '000103', '用户管理', '0001', '../page/user', '0', '0140', '1', '电脑版', '', 'icon-notebook', '0');
INSERT INTO `tb_functions` VALUES ('15', '000104', '日志管理', '0001', '../page/log', '0', '0160', '1', '电脑版', '', 'icon-notebook', '0');
INSERT INTO `tb_functions` VALUES ('16', '000105', '功能管理', '0001', '../page/functions', '0', '0135', '1', '电脑版', '', 'icon-notebook', '0');
INSERT INTO `tb_functions` VALUES ('21', '0101', '商品管理', '0', '', '0', '0620', '1', '电脑版', '', 'icon-social-dropbox', '0');
INSERT INTO `tb_functions` VALUES ('22', '010101', '商品类别', '0101', '../page/materialcategory', '0', '0230', '1', '电脑版', '', 'icon-notebook', '0');
INSERT INTO `tb_functions` VALUES ('23', '010102', '商品信息', '0101', '../page/material', '0', '0240', '1', '电脑版', '', 'icon-notebook', '0');
INSERT INTO `tb_functions` VALUES ('24', '0102', '基本资料', '0', '', '0', '0750', '1', '电脑版', '', 'icon-grid', '0');
INSERT INTO `tb_functions` VALUES ('25', '01020101', '供应商信息', '0102', '../page/vendor', '0', '0260', '1', '电脑版', '1,2', 'icon-notebook', '0');
INSERT INTO `tb_functions` VALUES ('26', '010202', '仓库信息', '0102', '../page/depot', '0', '0270', '1', '电脑版', '', 'icon-notebook', '0');
INSERT INTO `tb_functions` VALUES ('31', '010206', '经手人管理', '0102', '../page/person', '0', '0284', '1', '电脑版', '', 'icon-notebook', '0');
INSERT INTO `tb_functions` VALUES ('32', '0502', '采购管理', '0', '', '0', '0330', '1', '电脑版', '', 'icon-loop', '0');
INSERT INTO `tb_functions` VALUES ('33', '050201', '采购入库', '0502', '../page/purchase_in_list', '0', '0340', '1', '电脑版', '3,4,5', 'icon-notebook', '0');
INSERT INTO `tb_functions` VALUES ('38', '0603', '销售管理', '0', '', '0', '0390', '1', '电脑版', '', 'icon-briefcase', '0');
INSERT INTO `tb_functions` VALUES ('40', '080107', '调拨出库', '0801', '../page/allocation_out_list', '0', '0807', '1', '电脑版', '3,4,5', 'icon-notebook', '0');
INSERT INTO `tb_functions` VALUES ('41', '060303', '销售出库', '0603', '../page/sale_out_list', '0', '0394', '1', '电脑版', '3,4,5', 'icon-notebook', '0');
INSERT INTO `tb_functions` VALUES ('44', '0704', '财务管理', '0', '', '0', '0450', '1', '电脑版', '', 'icon-map', '0');
INSERT INTO `tb_functions` VALUES ('59', '030101', '库存状况', '0301', '../page/in_out_stock_report', '0', '0600', '1', '电脑版', '', 'icon-notebook', '0');
INSERT INTO `tb_functions` VALUES ('194', '010204', '收支项目', '0102', '../page/inOutItem', '0', '0282', '1', '电脑版', '', 'icon-notebook', '0');
INSERT INTO `tb_functions` VALUES ('195', '010205', '结算账户', '0102', '../page/account', '0', '0283', '1', '电脑版', '', 'icon-notebook', '0');
INSERT INTO `tb_functions` VALUES ('197', '070402', '收入单', '0704', '../page/item_in', '0', '0465', '1', '电脑版', '', 'icon-notebook', '0');
INSERT INTO `tb_functions` VALUES ('198', '0301', '报表查询', '0', '', '0', '0570', '1', '电脑版', '', 'icon-pie-chart', '0');
INSERT INTO `tb_functions` VALUES ('199', '050204', '采购退货', '0502', '../page/purchase_back_list', '0', '0345', '1', '电脑版', '3,4,5', 'icon-notebook', '0');
INSERT INTO `tb_functions` VALUES ('200', '060305', '销售退货', '0603', '../page/sale_back_list', '0', '0396', '1', '电脑版', '3,4,5', 'icon-notebook', '0');
INSERT INTO `tb_functions` VALUES ('201', '080103', '其它入库', '0801', '../page/other_in_list', '0', '0803', '1', '电脑版', '3,4,5', 'icon-notebook', '0');
INSERT INTO `tb_functions` VALUES ('202', '080105', '其它出库', '0801', '../page/other_out_list', '0', '0805', '1', '电脑版', '3,4,5', 'icon-notebook', '0');
INSERT INTO `tb_functions` VALUES ('203', '070403', '支出单', '0704', '../page/item_out', '0', '0470', '1', '电脑版', '', 'icon-notebook', '0');
INSERT INTO `tb_functions` VALUES ('204', '070404', '收款单', '0704', '../page/money_in', '0', '0475', '1', '电脑版', '', 'icon-notebook', '0');
INSERT INTO `tb_functions` VALUES ('205', '070405', '付款单', '0704', '../page/money_out', '0', '0480', '1', '电脑版', '', 'icon-notebook', '0');
INSERT INTO `tb_functions` VALUES ('206', '070406', '转账单', '0704', '../page/giro', '0', '0490', '1', '电脑版', '', 'icon-notebook', '0');
INSERT INTO `tb_functions` VALUES ('207', '030102', '账户统计', '0301', '../page/account_report', '0', '0610', '1', '电脑版', '', 'icon-notebook', '0');
INSERT INTO `tb_functions` VALUES ('208', '030103', '进货统计', '0301', '../page/buy_in_report', '0', '0620', '1', '电脑版', '', 'icon-notebook', '0');
INSERT INTO `tb_functions` VALUES ('209', '030104', '销售统计', '0301', '../page/sale_out_report', '0', '0630', '1', '电脑版', '', 'icon-notebook', '0');
INSERT INTO `tb_functions` VALUES ('210', '040102', '零售出库', '0401', '../page/retail_out_list', '0', '0405', '1', '电脑版', '3,4,5', 'icon-notebook', '0');
INSERT INTO `tb_functions` VALUES ('211', '040104', '零售退货', '0401', '../page/retail_back_list', '0', '0407', '1', '电脑版', '3,4,5', 'icon-notebook', '0');
INSERT INTO `tb_functions` VALUES ('212', '070407', '收预付款', '0704', '../page/advance_in', '0', '0495', '1', '电脑版', '', 'icon-notebook', '0');
INSERT INTO `tb_functions` VALUES ('217', '01020102', '客户信息', '0102', '../page/customer', '0', '0262', '1', '电脑版', '1,2', 'icon-notebook', '0');
INSERT INTO `tb_functions` VALUES ('218', '01020103', '会员信息', '0102', '../page/member', '0', '0263', '1', '电脑版', '1,2', 'icon-notebook', '0');
INSERT INTO `tb_functions` VALUES ('220', '010103', '计量单位', '0101', '../page/unit', '0', '0245', '1', '电脑版', '', 'icon-notebook', '0');
INSERT INTO `tb_functions` VALUES ('225', '0401', '零售管理', '0', '', '0', '0101', '1', '电脑版', '', 'icon-present', '0');
INSERT INTO `tb_functions` VALUES ('226', '030106', '入库明细', '0301', '../page/in_detail', '0', '0640', '1', '电脑版', '', 'icon-notebook', '0');
INSERT INTO `tb_functions` VALUES ('227', '030107', '出库明细', '0301', '../page/out_detail', '0', '0645', '1', '电脑版', '', 'icon-notebook', '0');
INSERT INTO `tb_functions` VALUES ('228', '030108', '入库汇总', '0301', '../page/in_material_count', '0', '0650', '1', '电脑版', '', 'icon-notebook', '0');
INSERT INTO `tb_functions` VALUES ('229', '030109', '出库汇总', '0301', '../page/out_material_count', '0', '0655', '1', '电脑版', '', 'icon-notebook', '0');
INSERT INTO `tb_functions` VALUES ('232', '080109', '组装单', '0801', '../page/assemble_list', '0', '0809', '1', '电脑版', '3,4,5', 'icon-notebook', '0');
INSERT INTO `tb_functions` VALUES ('233', '080111', '拆卸单', '0801', '../page/disassemble_list', '0', '0811', '1', '电脑版', '3,4,5', 'icon-notebook', '0');
INSERT INTO `tb_functions` VALUES ('234', '000105', '系统配置', '0001', '../page/systemConfig', '0', '0165', '1', '电脑版', '', 'icon-notebook', '0');
INSERT INTO `tb_functions` VALUES ('235', '030110', '客户对账', '0301', '../page/customer_account', '0', '0660', '1', '电脑版', '', 'icon-notebook', '0');
INSERT INTO `tb_functions` VALUES ('236', '000106', '商品属性', '0001', '../page/materialProperty', '0', '0168', '1', '电脑版', '', 'icon-notebook', '0');
INSERT INTO `tb_functions` VALUES ('237', '030111', '供应商对账', '0301', '../page/vendor_account', '0', '0665', '1', '电脑版', '', 'icon-notebook', '0');
INSERT INTO `tb_functions` VALUES ('239', '0801', '仓库管理', '0', '', '0', '0420', '1', '电脑版', '', 'icon-layers', '0');
INSERT INTO `tb_functions` VALUES ('240', '010104', '序列号', '0101', '../page/serialNumber', '0', '0246', '1', '电脑版', '', 'icon-notebook', '0');
INSERT INTO `tb_functions` VALUES ('241', '050202', '采购订单', '0502', '../page/purchase_orders_list', '0', '0335', '1', '电脑版', '3', 'icon-notebook', '0');
INSERT INTO `tb_functions` VALUES ('242', '060301', '销售订单', '0603', '../page/sale_orders_list', '0', '0392', '1', '电脑版', '3', 'icon-notebook', '0');
INSERT INTO `tb_functions` VALUES ('243', '000108', '机构管理', '0001', '../page/organization', '1', '0139', '1', '电脑版', '', 'icon-notebook', '0');
INSERT INTO `tb_functions` VALUES ('244', '030112', '库存预警', '0301', '../page/stock_warning_report', '0', '0670', '1', '电脑版', '', 'icon-notebook', '0');
INSERT INTO `tb_functions` VALUES ('245', '000107', '插件管理', '0001', '../page/plugin', '0', '0170', '1', '电脑版', '', 'icon-notebook', '0');

-- ----------------------------
-- Table structure for `tb_in_out_item`
-- ----------------------------
DROP TABLE IF EXISTS `tb_in_out_item`;
CREATE TABLE `tb_in_out_item` (
  `inOutItemId` int(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(50) DEFAULT NULL COMMENT '名称',
  `type` varchar(20) DEFAULT NULL COMMENT '类型',
  `remark` varchar(100) DEFAULT NULL COMMENT '备注',
  `tenantId` int(20) DEFAULT NULL COMMENT '租户id',
  `deleteFlag` varchar(1) DEFAULT '0' COMMENT '删除标记，0未删除，1删除',
  PRIMARY KEY (`inOutItemId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='收支项目';

-- ----------------------------
-- Records of tb_in_out_item
-- ----------------------------

-- ----------------------------
-- Table structure for `tb_log`
-- ----------------------------
DROP TABLE IF EXISTS `tb_log`;
CREATE TABLE `tb_log` (
  `logId` int(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `userID` int(20) NOT NULL COMMENT '操作用户ID',
  `operation` varchar(500) DEFAULT NULL COMMENT '操作模块名称',
  `clientIP` varchar(50) DEFAULT NULL COMMENT '客户端IP',
  `createTime` datetime DEFAULT NULL COMMENT '创建时间',
  `status` int(4) DEFAULT NULL COMMENT '操作状态 0==成功，1==失败',
  `contentDetails` varchar(1000) DEFAULT NULL COMMENT '操作详情',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注信息',
  `tenantId` int(20) DEFAULT NULL COMMENT '租户id',
  PRIMARY KEY (`logId`),
  KEY `FKF2696AA13E226853` (`userID`)
) ENGINE=InnoDB AUTO_INCREMENT=325 DEFAULT CHARSET=utf8 COMMENT='操作日志';

-- ----------------------------
-- Records of tb_log
-- ----------------------------
INSERT INTO `tb_log` VALUES ('1', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-15 09:57:36', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('2', '12', '关联关系', '0:0:0:0:0:0:0:1', '2020-07-16 12:41:49', '0', '新增', null, '12');
INSERT INTO `tb_log` VALUES ('3', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-16 12:50:57', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('4', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-16 12:51:25', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('5', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-16 12:52:36', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('6', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-16 12:55:54', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('7', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-16 12:57:39', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('8', '13', '关联关系', '0:0:0:0:0:0:0:1', '2020-07-16 12:58:51', '0', '新增', null, '13');
INSERT INTO `tb_log` VALUES ('9', '13', '用户', '0:0:0:0:0:0:0:1', '2020-07-16 12:58:59', '0', 'lin登陆了', null, '13');
INSERT INTO `tb_log` VALUES ('10', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-16 13:00:37', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('11', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-17 03:12:40', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('12', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-17 03:27:22', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('13', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-17 08:10:42', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('14', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-17 08:22:04', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('15', '1', '角色', '0:0:0:0:0:0:0:1', '2020-07-17 08:23:00', '0', '新增{\"name\":\"123\"}', null, '1');
INSERT INTO `tb_log` VALUES ('16', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-17 08:47:46', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('17', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-17 09:06:12', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('18', '1', '角色', '0:0:0:0:0:0:0:1', '2020-07-17 09:06:21', '0', '新增qwe', null, '1');
INSERT INTO `tb_log` VALUES ('19', '1', '角色', '0:0:0:0:0:0:0:1', '2020-07-17 09:07:31', '0', '新增测试1', null, '1');
INSERT INTO `tb_log` VALUES ('20', '1', '角色', '0:0:0:0:0:0:0:1', '2020-07-17 09:09:01', '0', '新增测试2', null, '1');
INSERT INTO `tb_log` VALUES ('21', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-17 10:24:17', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('22', '1', '角色', '0:0:0:0:0:0:0:1', '2020-07-17 10:25:23', '0', '删除', null, '1');
INSERT INTO `tb_log` VALUES ('23', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-17 13:31:06', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('24', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-17 13:54:56', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('25', '1', '用户', '127.0.0.1', '2020-07-17 14:02:08', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('26', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-17 14:04:23', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('27', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-17 14:11:39', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('28', '1', '角色', '0:0:0:0:0:0:0:1', '2020-07-17 14:13:04', '0', '新增测试0', null, '1');
INSERT INTO `tb_log` VALUES ('29', '1', '角色', '0:0:0:0:0:0:0:1', '2020-07-17 14:13:18', '0', '删除', null, '1');
INSERT INTO `tb_log` VALUES ('30', '1', '角色', '0:0:0:0:0:0:0:1', '2020-07-17 14:14:16', '0', '新增测试0', null, '1');
INSERT INTO `tb_log` VALUES ('31', '1', '角色', '0:0:0:0:0:0:0:1', '2020-07-17 14:14:20', '0', '删除', null, '1');
INSERT INTO `tb_log` VALUES ('32', '1', '角色', '0:0:0:0:0:0:0:1', '2020-07-17 14:15:46', '0', '新增测试0', null, '1');
INSERT INTO `tb_log` VALUES ('33', '1', '角色', '0:0:0:0:0:0:0:1', '2020-07-17 14:15:50', '0', '删除', null, '1');
INSERT INTO `tb_log` VALUES ('34', '1', '角色', '0:0:0:0:0:0:0:1', '2020-07-17 14:16:51', '0', '新增测试0', null, '1');
INSERT INTO `tb_log` VALUES ('35', '1', '角色', '0:0:0:0:0:0:0:1', '2020-07-17 14:16:54', '0', '删除', null, '1');
INSERT INTO `tb_log` VALUES ('36', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-17 14:31:51', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('37', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-17 14:33:59', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('38', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-18 01:42:47', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('39', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-18 09:39:17', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('40', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-18 09:48:06', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('41', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-18 09:57:38', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('42', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-18 10:02:18', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('43', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-18 14:13:19', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('44', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-18 14:16:21', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('45', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-18 14:22:43', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('46', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-18 14:33:50', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('47', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-18 14:36:05', '0', '修改了id=12的信息', null, '1');
INSERT INTO `tb_log` VALUES ('48', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-18 14:43:25', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('49', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-18 14:44:27', '0', '修改了id=13的信息', null, '1');
INSERT INTO `tb_log` VALUES ('50', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-18 14:58:51', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('51', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-18 15:06:18', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('52', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-18 15:14:57', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('53', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-18 15:17:06', '0', '删除', null, '1');
INSERT INTO `tb_log` VALUES ('54', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-18 15:18:30', '0', '新增', null, '1');
INSERT INTO `tb_log` VALUES ('55', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-18 15:19:51', '0', '删除', null, '1');
INSERT INTO `tb_log` VALUES ('56', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-18 15:21:16', '0', '新增', null, '1');
INSERT INTO `tb_log` VALUES ('57', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-18 15:23:42', '0', '删除', null, '1');
INSERT INTO `tb_log` VALUES ('58', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-18 15:24:04', '0', '新增', null, '1');
INSERT INTO `tb_log` VALUES ('59', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-18 15:29:13', '0', '新增', null, '1');
INSERT INTO `tb_log` VALUES ('60', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-19 02:09:00', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('61', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-19 07:47:27', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('62', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-19 08:24:54', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('63', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-19 08:26:50', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('64', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-19 08:39:43', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('65', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-19 08:49:06', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('66', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-19 08:50:47', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('67', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-19 09:05:22', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('68', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-19 09:27:06', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('69', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-19 09:29:53', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('70', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-19 09:49:47', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('71', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-19 09:57:34', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('72', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-19 09:59:30', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('73', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-19 10:03:33', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('74', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-19 12:54:09', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('75', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-19 13:24:07', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('76', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-20 07:36:08', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('77', '1', '功能', '0:0:0:0:0:0:0:1', '2020-07-20 07:45:07', '0', '新增测试功能', null, '1');
INSERT INTO `tb_log` VALUES ('78', '1', '功能', '0:0:0:0:0:0:0:1', '2020-07-20 07:51:37', '0', '修改测试功能1', null, '1');
INSERT INTO `tb_log` VALUES ('79', '1', '功能', '0:0:0:0:0:0:0:1', '2020-07-20 07:53:48', '0', '修改测试功能1', null, '1');
INSERT INTO `tb_log` VALUES ('80', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-20 07:56:22', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('81', '1', '功能', '0:0:0:0:0:0:0:1', '2020-07-20 07:57:50', '0', '新增测试功能', null, '1');
INSERT INTO `tb_log` VALUES ('82', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-20 08:06:36', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('83', '1', '功能', '0:0:0:0:0:0:0:1', '2020-07-20 08:07:55', '0', '修改测试功能1', null, '1');
INSERT INTO `tb_log` VALUES ('84', '1', '功能', '0:0:0:0:0:0:0:1', '2020-07-20 08:09:09', '0', '新增测试22', null, '1');
INSERT INTO `tb_log` VALUES ('85', '1', '功能', '0:0:0:0:0:0:0:1', '2020-07-20 08:18:34', '0', '新增qqqq', null, '1');
INSERT INTO `tb_log` VALUES ('86', '1', '功能', '0:0:0:0:0:0:0:1', '2020-07-20 08:23:21', '0', '新增测试功能', null, '1');
INSERT INTO `tb_log` VALUES ('87', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-20 08:48:15', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('88', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-20 08:52:46', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('89', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-20 09:20:21', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('90', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-20 09:47:16', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('91', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-20 13:50:22', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('92', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-20 13:56:08', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('93', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-20 14:03:50', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('94', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-20 14:07:54', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('95', '1', '系统配置', '0:0:0:0:0:0:0:1', '2020-07-20 14:08:36', '0', '新增德意龙科技有限公司', null, '1');
INSERT INTO `tb_log` VALUES ('96', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-20 14:12:17', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('97', '1', '系统配置', '0:0:0:0:0:0:0:1', '2020-07-20 14:21:32', '0', '新增aaaa', null, '1');
INSERT INTO `tb_log` VALUES ('98', '1', '系统配置', '0:0:0:0:0:0:0:1', '2020-07-20 14:22:09', '0', '修改aa14', null, '1');
INSERT INTO `tb_log` VALUES ('99', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-20 14:23:44', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('100', '1', '系统配置', '0:0:0:0:0:0:0:1', '2020-07-20 14:24:16', '0', '修改aa1455', null, '1');
INSERT INTO `tb_log` VALUES ('101', '1', '系统配置', '0:0:0:0:0:0:0:1', '2020-07-20 14:24:45', '0', '删除id=2', null, '1');
INSERT INTO `tb_log` VALUES ('102', '1', '系统配置', '0:0:0:0:0:0:0:1', '2020-07-20 14:25:06', '0', '新增aa', null, '1');
INSERT INTO `tb_log` VALUES ('103', '1', '系统配置', '0:0:0:0:0:0:0:1', '2020-07-20 14:25:52', '0', '删除id=3', null, '1');
INSERT INTO `tb_log` VALUES ('104', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-21 09:40:44', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('105', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-21 10:08:08', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('106', '1', '商品属性', '0:0:0:0:0:0:0:1', '2020-07-21 10:09:51', '0', '修改制造商', null, '1');
INSERT INTO `tb_log` VALUES ('107', '1', '用户', '127.0.0.1', '2020-07-21 14:29:13', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('108', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-21 14:35:23', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('109', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-22 02:24:26', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('110', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-22 02:32:17', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('111', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-22 02:39:48', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('112', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-22 02:52:46', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('113', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-22 02:56:14', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('114', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-22 02:56:49', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('115', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-22 03:00:15', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('116', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-22 04:54:38', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('117', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-22 04:58:19', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('118', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-22 05:01:13', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('119', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-22 05:11:41', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('120', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-22 05:28:34', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('121', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-22 05:32:56', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('122', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-22 05:35:58', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('123', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-22 05:38:02', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('124', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-22 05:41:29', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('125', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-22 05:52:20', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('126', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-22 05:57:38', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('127', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-22 06:39:45', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('128', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-22 06:44:47', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('129', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-22 06:47:56', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('130', '1', '机构', '0:0:0:0:0:0:0:1', '2020-07-22 06:49:12', '0', '新增测试2', null, '1');
INSERT INTO `tb_log` VALUES ('131', '1', '机构', '0:0:0:0:0:0:0:1', '2020-07-22 06:50:46', '0', '新增测试1', null, '1');
INSERT INTO `tb_log` VALUES ('132', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-22 08:53:48', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('133', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-22 09:06:26', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('134', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-22 09:09:23', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('135', '1', '机构', '0:0:0:0:0:0:0:1', '2020-07-22 09:18:33', '0', '修改bbbb11', null, '1');
INSERT INTO `tb_log` VALUES ('136', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-22 09:22:54', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('137', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-22 09:26:48', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('138', '1', '机构', '0:0:0:0:0:0:0:1', '2020-07-22 09:28:13', '0', '修改测试公司1', null, '1');
INSERT INTO `tb_log` VALUES ('139', '1', '机构', '0:0:0:0:0:0:0:1', '2020-07-22 09:33:06', '0', '修改测试机构2', null, '1');
INSERT INTO `tb_log` VALUES ('140', '1', '机构', '0:0:0:0:0:0:0:1', '2020-07-22 09:34:08', '0', '修改测试机构2', null, '1');
INSERT INTO `tb_log` VALUES ('141', '1', '机构', '0:0:0:0:0:0:0:1', '2020-07-22 09:34:56', '0', '修改测试公司2', null, '1');
INSERT INTO `tb_log` VALUES ('142', '1', '机构', '0:0:0:0:0:0:0:1', '2020-07-22 09:36:14', '0', '新增测试公司2', null, '1');
INSERT INTO `tb_log` VALUES ('143', '1', '机构', '0:0:0:0:0:0:0:1', '2020-07-22 09:36:57', '0', '修改测试公司3', null, '1');
INSERT INTO `tb_log` VALUES ('144', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-22 13:36:34', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('145', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-22 14:10:14', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('146', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-23 03:57:37', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('147', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-23 09:34:30', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('148', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-23 09:37:26', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('149', '1', '关联关系', '0:0:0:0:0:0:0:1', '2020-07-23 09:40:01', '0', '新增', null, '1');
INSERT INTO `tb_log` VALUES ('150', '1', '关联关系', '0:0:0:0:0:0:0:1', '2020-07-23 09:41:09', '0', '新增', null, '1');
INSERT INTO `tb_log` VALUES ('151', '1', '关联关系', '0:0:0:0:0:0:0:1', '2020-07-23 09:43:09', '0', '修改', null, '1');
INSERT INTO `tb_log` VALUES ('152', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-23 11:00:51', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('153', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-23 11:16:10', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('154', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-23 11:17:40', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('155', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-23 11:22:21', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('156', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-23 11:23:47', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('157', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-23 11:26:11', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('158', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-23 11:31:00', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('159', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-23 11:38:54', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('160', '1', '关联关系', '0:0:0:0:0:0:0:1', '2020-07-23 11:47:27', '0', '修改id=81', null, '1');
INSERT INTO `tb_log` VALUES ('161', '1', '关联关系', '0:0:0:0:0:0:0:1', '2020-07-23 11:51:38', '0', '修改id=81', null, '1');
INSERT INTO `tb_log` VALUES ('162', '1', '关联关系', '0:0:0:0:0:0:0:1', '2020-07-23 11:52:35', '0', '修改id=81', null, '1');
INSERT INTO `tb_log` VALUES ('163', '1', '关联关系', '0:0:0:0:0:0:0:1', '2020-07-23 11:53:29', '0', '修改', null, '1');
INSERT INTO `tb_log` VALUES ('164', '1', '关联关系', '0:0:0:0:0:0:0:1', '2020-07-23 11:57:27', '0', '修改', null, '1');
INSERT INTO `tb_log` VALUES ('165', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-23 12:09:29', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('166', '1', '关联关系', '0:0:0:0:0:0:0:1', '2020-07-23 12:10:32', '0', '修改id=81', null, '1');
INSERT INTO `tb_log` VALUES ('167', '1', '关联关系', '0:0:0:0:0:0:0:1', '2020-07-23 12:10:51', '0', '修改', null, '1');
INSERT INTO `tb_log` VALUES ('168', '1', '关联关系', '0:0:0:0:0:0:0:1', '2020-07-23 12:11:29', '0', '修改id=81', null, '1');
INSERT INTO `tb_log` VALUES ('169', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-23 12:14:28', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('170', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-23 12:42:52', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('171', '1', '关联关系', '0:0:0:0:0:0:0:1', '2020-07-23 12:43:44', '0', '新增', null, '1');
INSERT INTO `tb_log` VALUES ('172', '17', '用户', '0:0:0:0:0:0:0:1', '2020-07-23 12:45:42', '0', 'yao登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('173', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-24 08:31:48', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('174', '1', '关联关系', '0:0:0:0:0:0:0:1', '2020-07-24 09:05:03', '0', '新增', null, '1');
INSERT INTO `tb_log` VALUES ('175', '1', '关联关系', '0:0:0:0:0:0:0:1', '2020-07-24 09:06:59', '0', '修改', null, '1');
INSERT INTO `tb_log` VALUES ('176', '1', '关联关系', '0:0:0:0:0:0:0:1', '2020-07-24 09:08:05', '0', '新增', null, '1');
INSERT INTO `tb_log` VALUES ('177', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-24 15:15:26', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('178', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-24 15:15:36', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('179', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-25 04:53:59', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('180', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-25 06:44:57', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('181', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-25 09:07:40', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('182', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-25 09:10:30', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('183', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-25 09:29:15', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('184', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-25 09:43:57', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('185', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-25 09:51:13', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('186', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-25 09:55:47', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('187', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-25 09:58:24', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('188', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-25 14:30:09', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('189', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-25 15:07:12', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('190', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-25 16:13:29', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('191', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-26 05:34:17', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('192', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-26 08:35:36', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('193', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-26 13:12:14', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('194', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-28 13:03:24', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('195', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-29 13:05:36', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('196', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-29 13:07:56', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('197', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-29 13:16:24', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('198', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-29 13:50:10', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('199', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-30 03:45:40', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('200', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-30 06:34:56', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('201', '1', '商家', '0:0:0:0:0:0:0:1', '2020-07-30 06:41:14', '0', '新增供应商3', null, '1');
INSERT INTO `tb_log` VALUES ('202', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-30 07:05:32', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('203', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-30 07:07:59', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('204', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-30 07:11:20', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('205', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-30 07:17:36', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('206', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-30 11:49:16', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('207', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-30 12:33:20', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('208', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-30 13:05:52', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('209', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-30 14:05:13', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('210', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-30 15:07:17', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('211', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-31 07:38:52', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('212', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-31 08:10:08', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('213', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-31 08:14:56', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('214', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-31 08:27:01', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('215', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-31 08:28:56', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('216', '1', '用户', '0:0:0:0:0:0:0:1', '2020-07-31 11:11:39', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('217', '1', '商家', '0:0:0:0:0:0:0:1', '2020-07-31 11:15:36', '0', '修改供应商33', null, '1');
INSERT INTO `tb_log` VALUES ('218', '1', '用户', '0:0:0:0:0:0:0:1', '2020-08-01 03:38:34', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('219', '1', '商家', '0:0:0:0:0:0:0:1', '2020-08-01 03:39:25', '0', '新增供应商4', null, '1');
INSERT INTO `tb_log` VALUES ('220', '1', '商家', '0:0:0:0:0:0:0:1', '2020-08-01 03:39:39', '0', '新增供应商5', null, '1');
INSERT INTO `tb_log` VALUES ('221', '1', '商家', '0:0:0:0:0:0:0:1', '2020-08-01 03:39:46', '0', '新增供应商6', null, '1');
INSERT INTO `tb_log` VALUES ('222', '1', '商家', '0:0:0:0:0:0:0:1', '2020-08-01 03:39:53', '0', '新增供应商7', null, '1');
INSERT INTO `tb_log` VALUES ('223', '1', '商家', '0:0:0:0:0:0:0:1', '2020-08-01 03:39:58', '0', '新增供应商8', null, '1');
INSERT INTO `tb_log` VALUES ('224', '1', '商家', '0:0:0:0:0:0:0:1', '2020-08-01 03:40:03', '0', '新增供应商9', null, '1');
INSERT INTO `tb_log` VALUES ('225', '1', '商家', '0:0:0:0:0:0:0:1', '2020-08-01 03:40:08', '0', '新增供应商10', null, '1');
INSERT INTO `tb_log` VALUES ('226', '1', '商家', '0:0:0:0:0:0:0:1', '2020-08-01 03:40:16', '0', '新增供应商11', null, '1');
INSERT INTO `tb_log` VALUES ('227', '1', '商家', '0:0:0:0:0:0:0:1', '2020-08-01 03:40:20', '0', '新增供应商12', null, '1');
INSERT INTO `tb_log` VALUES ('228', '1', '商家', '0:0:0:0:0:0:0:1', '2020-08-01 03:40:24', '0', '新增供应商13', null, '1');
INSERT INTO `tb_log` VALUES ('229', '1', '商家', '0:0:0:0:0:0:0:1', '2020-08-01 03:40:30', '0', '新增供应商14', null, '1');
INSERT INTO `tb_log` VALUES ('230', '1', '商家', '0:0:0:0:0:0:0:1', '2020-08-01 03:53:41', '0', '删除[供应商14]', null, '1');
INSERT INTO `tb_log` VALUES ('231', '1', '商家', '0:0:0:0:0:0:0:1', '2020-08-01 03:56:18', '0', '删除[供应商4]', null, '1');
INSERT INTO `tb_log` VALUES ('232', '1', '用户', '0:0:0:0:0:0:0:1', '2020-08-01 03:59:11', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('233', '1', '商家', '0:0:0:0:0:0:0:1', '2020-08-01 04:02:26', '0', '删除[供应商5]', null, '1');
INSERT INTO `tb_log` VALUES ('234', '1', '用户', '0:0:0:0:0:0:0:1', '2020-08-01 04:04:19', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('235', '1', '商家', '0:0:0:0:0:0:0:1', '2020-08-01 04:04:34', '0', '删除[供应商6]', null, '1');
INSERT INTO `tb_log` VALUES ('236', '1', '用户', '0:0:0:0:0:0:0:1', '2020-08-01 14:02:07', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('237', '1', '商家', '0:0:0:0:0:0:0:1', '2020-08-01 14:03:09', '0', '删除[供应商7][供应商8][供应商9][供应商10][供应商11][供应商12][供应商13]', null, '1');
INSERT INTO `tb_log` VALUES ('238', '1', '用户', '0:0:0:0:0:0:0:1', '2020-08-01 14:25:08', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('239', '1', '商家', '0:0:0:0:0:0:0:1', '2020-08-01 14:25:48', '0', '删除[供应商8][供应商9][供应商10][供应商11][供应商12][供应商13]', null, '1');
INSERT INTO `tb_log` VALUES ('240', '1', '商家', '0:0:0:0:0:0:0:1', '2020-08-01 14:27:59', '0', '删除[供应商14]', null, '1');
INSERT INTO `tb_log` VALUES ('241', '1', '商家', '0:0:0:0:0:0:0:1', '2020-08-01 14:29:44', '0', '删除[供应商13]', null, '1');
INSERT INTO `tb_log` VALUES ('242', '1', '用户', '0:0:0:0:0:0:0:1', '2020-08-01 14:35:41', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('243', '1', '商家', '0:0:0:0:0:0:0:1', '2020-08-01 14:36:52', '0', '删除[供应商12]', null, '1');
INSERT INTO `tb_log` VALUES ('244', '1', '商家', '0:0:0:0:0:0:0:1', '2020-08-01 14:37:06', '0', '删除[供应商4][供应商5][供应商6][供应商7][供应商8][供应商9][供应商10][供应商11]', null, '1');
INSERT INTO `tb_log` VALUES ('245', '1', '用户', '0:0:0:0:0:0:0:1', '2020-08-02 07:54:30', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('246', '1', '商家', '0:0:0:0:0:0:0:1', '2020-08-02 07:55:38', '0', '修改:47,50,51', null, '1');
INSERT INTO `tb_log` VALUES ('247', '1', '商家', '0:0:0:0:0:0:0:1', '2020-08-02 07:56:18', '0', '修改:47,50,51', null, '1');
INSERT INTO `tb_log` VALUES ('248', '1', '用户', '0:0:0:0:0:0:0:1', '2020-08-02 08:36:06', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('249', '1', '用户', '0:0:0:0:0:0:0:1', '2020-08-02 09:17:17', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('250', '1', '用户', '0:0:0:0:0:0:0:1', '2020-08-02 14:03:12', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('251', '1', '仓库', '0:0:0:0:0:0:0:1', '2020-08-02 14:06:39', '0', '新增null', null, '1');
INSERT INTO `tb_log` VALUES ('252', '1', '仓库', '0:0:0:0:0:0:0:1', '2020-08-02 14:08:12', '0', '删除:[null]', null, '1');
INSERT INTO `tb_log` VALUES ('253', '1', '仓库', '0:0:0:0:0:0:0:1', '2020-08-02 14:08:23', '0', '新增null', null, '1');
INSERT INTO `tb_log` VALUES ('254', '1', '用户', '0:0:0:0:0:0:0:1', '2020-08-02 15:13:52', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('255', '1', '仓库', '0:0:0:0:0:0:0:1', '2020-08-02 15:14:13', '0', '新增www', null, '1');
INSERT INTO `tb_log` VALUES ('256', '1', '用户', '0:0:0:0:0:0:0:1', '2020-08-02 15:18:14', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('257', '1', '仓库', '0:0:0:0:0:0:0:1', '2020-08-02 15:18:37', '0', '新增vvv', null, '1');
INSERT INTO `tb_log` VALUES ('258', '1', '仓库', '0:0:0:0:0:0:0:1', '2020-08-02 15:22:47', '0', '修改:vvv', null, '1');
INSERT INTO `tb_log` VALUES ('259', '1', '仓库', '0:0:0:0:0:0:0:1', '2020-08-02 15:23:09', '0', '删除:[aa][bb][www][vvv]', null, '1');
INSERT INTO `tb_log` VALUES ('260', '1', '仓库', '0:0:0:0:0:0:0:1', '2020-08-02 15:23:40', '0', '修改:2', null, '1');
INSERT INTO `tb_log` VALUES ('261', '1', '仓库', '0:0:0:0:0:0:0:1', '2020-08-02 15:23:40', '0', '修改:1', null, '1');
INSERT INTO `tb_log` VALUES ('262', '1', '仓库', '0:0:0:0:0:0:0:1', '2020-08-02 15:23:40', '0', '修改:3', null, '1');
INSERT INTO `tb_log` VALUES ('263', '1', '用户', '0:0:0:0:0:0:0:1', '2020-08-03 03:49:58', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('264', '1', '用户', '0:0:0:0:0:0:0:1', '2020-08-03 03:54:36', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('265', '1', '仓库', '0:0:0:0:0:0:0:1', '2020-08-03 03:55:31', '0', '修改:2', null, '1');
INSERT INTO `tb_log` VALUES ('266', '1', '仓库', '0:0:0:0:0:0:0:1', '2020-08-03 03:55:31', '0', '修改:1', null, '1');
INSERT INTO `tb_log` VALUES ('267', '1', '仓库', '0:0:0:0:0:0:0:1', '2020-08-03 03:55:31', '0', '修改:3', null, '1');
INSERT INTO `tb_log` VALUES ('268', '1', '用户', '0:0:0:0:0:0:0:1', '2020-08-03 05:20:57', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('269', '1', '用户', '0:0:0:0:0:0:0:1', '2020-08-03 05:23:39', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('270', '1', '用户', '0:0:0:0:0:0:0:1', '2020-08-03 05:25:13', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('271', '1', '用户', '0:0:0:0:0:0:0:1', '2020-08-03 05:32:18', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('272', '1', '用户', '0:0:0:0:0:0:0:1', '2020-08-03 05:44:53', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('273', '1', '用户', '0:0:0:0:0:0:0:1', '2020-08-03 05:57:59', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('274', '1', '用户', '0:0:0:0:0:0:0:1', '2020-08-03 06:04:39', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('275', '1', '仓库', '0:0:0:0:0:0:0:1', '2020-08-03 06:13:12', '0', '修改:金沙店', null, '1');
INSERT INTO `tb_log` VALUES ('276', '1', '仓库', '0:0:0:0:0:0:0:1', '2020-08-03 06:17:02', '0', '修改:金沙店', null, '1');
INSERT INTO `tb_log` VALUES ('277', '1', '用户', '0:0:0:0:0:0:0:1', '2020-08-03 06:18:16', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('278', '1', '仓库', '0:0:0:0:0:0:0:1', '2020-08-03 06:18:30', '0', '修改:金沙店', null, '1');
INSERT INTO `tb_log` VALUES ('279', '1', '仓库', '0:0:0:0:0:0:0:1', '2020-08-03 06:18:44', '0', '修改:公司总部', null, '1');
INSERT INTO `tb_log` VALUES ('280', '1', '仓库', '0:0:0:0:0:0:0:1', '2020-08-03 06:18:52', '0', '修改:叠石桥店', null, '1');
INSERT INTO `tb_log` VALUES ('281', '1', '仓库', '0:0:0:0:0:0:0:1', '2020-08-03 06:19:10', '0', '修改:2', null, '1');
INSERT INTO `tb_log` VALUES ('282', '1', '仓库', '0:0:0:0:0:0:0:1', '2020-08-03 06:19:10', '0', '修改:1', null, '1');
INSERT INTO `tb_log` VALUES ('283', '1', '仓库', '0:0:0:0:0:0:0:1', '2020-08-03 06:19:10', '0', '修改:3', null, '1');
INSERT INTO `tb_log` VALUES ('284', '1', '用户', '0:0:0:0:0:0:0:1', '2020-08-03 06:41:04', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('285', '1', '仓库', '0:0:0:0:0:0:0:1', '2020-08-03 06:49:09', '0', '修改:金沙店', null, '1');
INSERT INTO `tb_log` VALUES ('286', '1', '仓库', '0:0:0:0:0:0:0:1', '2020-08-03 06:49:29', '0', '修改:公司总部', null, '1');
INSERT INTO `tb_log` VALUES ('287', '1', '仓库', '0:0:0:0:0:0:0:1', '2020-08-03 06:49:34', '0', '修改:叠石桥店', null, '1');
INSERT INTO `tb_log` VALUES ('288', '1', '仓库', '0:0:0:0:0:0:0:1', '2020-08-03 06:49:42', '0', '修改:2', null, '1');
INSERT INTO `tb_log` VALUES ('289', '1', '仓库', '0:0:0:0:0:0:0:1', '2020-08-03 06:49:42', '0', '修改:1', null, '1');
INSERT INTO `tb_log` VALUES ('290', '1', '仓库', '0:0:0:0:0:0:0:1', '2020-08-03 06:49:42', '0', '修改:3', null, '1');
INSERT INTO `tb_log` VALUES ('291', '1', '用户', '0:0:0:0:0:0:0:1', '2020-08-03 09:35:58', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('292', '1', '仓库', '0:0:0:0:0:0:0:1', '2020-08-03 10:17:59', '0', '修改:3', null, '1');
INSERT INTO `tb_log` VALUES ('293', '1', '仓库', '0:0:0:0:0:0:0:1', '2020-08-03 10:17:59', '0', '修改:1', null, '1');
INSERT INTO `tb_log` VALUES ('294', '1', '仓库', '0:0:0:0:0:0:0:1', '2020-08-03 10:17:59', '0', '修改:2', null, '1');
INSERT INTO `tb_log` VALUES ('295', '1', '用户', '0:0:0:0:0:0:0:1', '2020-08-03 10:24:32', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('296', '1', '仓库', '0:0:0:0:0:0:0:1', '2020-08-03 10:24:41', '0', '修改:金沙店', null, '1');
INSERT INTO `tb_log` VALUES ('297', '1', '仓库', '0:0:0:0:0:0:0:1', '2020-08-03 10:24:48', '0', '修改:2', null, '1');
INSERT INTO `tb_log` VALUES ('298', '1', '仓库', '0:0:0:0:0:0:0:1', '2020-08-03 10:24:54', '0', '修改:1', null, '1');
INSERT INTO `tb_log` VALUES ('299', '1', '仓库', '0:0:0:0:0:0:0:1', '2020-08-03 10:24:54', '0', '修改:3', null, '1');
INSERT INTO `tb_log` VALUES ('300', '1', '仓库', '0:0:0:0:0:0:0:1', '2020-08-03 10:25:04', '0', '修改:公司总部', null, '1');
INSERT INTO `tb_log` VALUES ('301', '1', '用户', '0:0:0:0:0:0:0:1', '2020-08-03 10:26:56', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('302', '1', '仓库', '0:0:0:0:0:0:0:1', '2020-08-03 10:27:08', '0', '修改:2', null, '1');
INSERT INTO `tb_log` VALUES ('303', '1', '仓库', '0:0:0:0:0:0:0:1', '2020-08-03 10:27:08', '0', '修改:1', null, '1');
INSERT INTO `tb_log` VALUES ('304', '1', '仓库', '0:0:0:0:0:0:0:1', '2020-08-03 10:27:09', '0', '修改:3', null, '1');
INSERT INTO `tb_log` VALUES ('305', '1', '仓库', '0:0:0:0:0:0:0:1', '2020-08-03 10:27:16', '0', '修改:叠石桥店', null, '1');
INSERT INTO `tb_log` VALUES ('306', '1', '仓库', '0:0:0:0:0:0:0:1', '2020-08-03 10:27:25', '0', '修改:3', null, '1');
INSERT INTO `tb_log` VALUES ('307', '1', '仓库', '0:0:0:0:0:0:0:1', '2020-08-03 10:27:25', '0', '修改:1', null, '1');
INSERT INTO `tb_log` VALUES ('308', '1', '仓库', '0:0:0:0:0:0:0:1', '2020-08-03 10:27:25', '0', '修改:2', null, '1');
INSERT INTO `tb_log` VALUES ('309', '1', '仓库', '0:0:0:0:0:0:0:1', '2020-08-03 10:27:32', '0', '修改:2', null, '1');
INSERT INTO `tb_log` VALUES ('310', '1', '仓库', '0:0:0:0:0:0:0:1', '2020-08-03 10:27:32', '0', '修改:1', null, '1');
INSERT INTO `tb_log` VALUES ('311', '1', '仓库', '0:0:0:0:0:0:0:1', '2020-08-03 10:27:32', '0', '修改:3', null, '1');
INSERT INTO `tb_log` VALUES ('312', '1', '仓库', '0:0:0:0:0:0:0:1', '2020-08-03 10:28:19', '0', '新增rrrr', null, '1');
INSERT INTO `tb_log` VALUES ('313', '1', '仓库', '0:0:0:0:0:0:0:1', '2020-08-03 10:28:39', '0', '删除:[rrrr]', null, '1');
INSERT INTO `tb_log` VALUES ('314', '1', '用户', '0:0:0:0:0:0:0:1', '2020-08-03 10:56:37', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('315', '1', '用户', '0:0:0:0:0:0:0:1', '2020-08-04 09:12:25', '0', 'leo登陆了', null, '1');
INSERT INTO `tb_log` VALUES ('316', '1', '经手人', '0:0:0:0:0:0:0:1', '2020-08-04 09:13:23', '0', '新增:小林', null, '1');
INSERT INTO `tb_log` VALUES ('317', '1', '经手人', '0:0:0:0:0:0:0:1', '2020-08-04 09:13:43', '0', '新增:小耀', null, '1');
INSERT INTO `tb_log` VALUES ('318', '1', '经手人', '0:0:0:0:0:0:0:1', '2020-08-04 09:13:48', '0', '新增:aa', null, '1');
INSERT INTO `tb_log` VALUES ('319', '1', '经手人', '0:0:0:0:0:0:0:1', '2020-08-04 09:13:54', '0', '新增:bb', null, '1');
INSERT INTO `tb_log` VALUES ('320', '1', '经手人', '0:0:0:0:0:0:0:1', '2020-08-04 09:13:58', '0', '新增:cc', null, '1');
INSERT INTO `tb_log` VALUES ('321', '1', '经手人', '0:0:0:0:0:0:0:1', '2020-08-04 09:15:16', '0', '修改:ccss', null, '1');
INSERT INTO `tb_log` VALUES ('322', '1', '经手人', '0:0:0:0:0:0:0:1', '2020-08-04 09:15:43', '0', '[aa][bb][ccss]', null, '1');
INSERT INTO `tb_log` VALUES ('323', '1', '经手人', '0:0:0:0:0:0:0:1', '2020-08-04 09:20:09', '0', '[ccss]', null, '1');
INSERT INTO `tb_log` VALUES ('324', '1', '经手人', '0:0:0:0:0:0:0:1', '2020-08-04 09:20:18', '0', '[aa][bb]', null, '1');

-- ----------------------------
-- Table structure for `tb_material`
-- ----------------------------
DROP TABLE IF EXISTS `tb_material`;
CREATE TABLE `tb_material` (
  `materialId` int(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `categoryId` int(20) DEFAULT NULL COMMENT '产品类型',
  `name` varchar(50) DEFAULT NULL COMMENT '名称',
  `mfrs` varchar(50) DEFAULT NULL COMMENT '制造商',
  `safetyStock` double(24,6) DEFAULT NULL COMMENT '安全存量（KG）',
  `model` varchar(50) DEFAULT NULL COMMENT '型号',
  `standard` varchar(50) DEFAULT NULL COMMENT '规格',
  `color` varchar(50) DEFAULT NULL COMMENT '颜色',
  `unit` varchar(50) DEFAULT NULL COMMENT '单位-单个',
  `remark` varchar(100) DEFAULT NULL COMMENT '备注',
  `unitId` int(20) DEFAULT NULL COMMENT '计量单位Id',
  `enabled` int(1) DEFAULT NULL COMMENT '启用 0-禁用  1-启用',
  `otherField1` varchar(50) DEFAULT NULL COMMENT '自定义1',
  `otherField2` varchar(50) DEFAULT NULL COMMENT '自定义2',
  `otherField3` varchar(50) DEFAULT NULL COMMENT '自定义3',
  `enableSerialNumber` varchar(1) DEFAULT '0' COMMENT '是否开启序列号，0否，1是',
  `tenantId` int(20) DEFAULT NULL COMMENT '租户id',
  `deleteFlag` varchar(1) DEFAULT '0' COMMENT '删除标记，0未删除，1删除',
  PRIMARY KEY (`materialId`),
  KEY `FK675951272AB6672C` (`categoryId`),
  KEY `UnitId` (`unitId`)
) ENGINE=InnoDB AUTO_INCREMENT=570 DEFAULT CHARSET=utf8 COMMENT='产品表';

-- ----------------------------
-- Records of tb_material
-- ----------------------------
INSERT INTO `tb_material` VALUES ('569', '17', '商品2', '', '200.000000', 'sp2', '', '', '只', '', null, '1', '', '', '', '0', '63', '0');

-- ----------------------------
-- Table structure for `tb_material_category`
-- ----------------------------
DROP TABLE IF EXISTS `tb_material_category`;
CREATE TABLE `tb_material_category` (
  `materialCategoryId` int(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(50) DEFAULT NULL COMMENT '名称',
  `categoryLevel` int(6) DEFAULT NULL COMMENT '等级',
  `parentId` int(20) DEFAULT NULL COMMENT '上级ID',
  `sort` varchar(10) DEFAULT NULL COMMENT '显示顺序',
  `status` varchar(1) DEFAULT '0' COMMENT '状态，0系统默认，1启用，2删除',
  `serialNo` varchar(100) DEFAULT NULL COMMENT '编号',
  `remark` varchar(1024) DEFAULT NULL COMMENT '备注',
  `createTime` datetime DEFAULT NULL COMMENT '创建时间',
  `creator` int(20) DEFAULT NULL COMMENT '创建人',
  `updateTime` datetime DEFAULT NULL COMMENT '更新时间',
  `updater` int(20) DEFAULT NULL COMMENT '更新人',
  `tenantId` int(20) DEFAULT NULL COMMENT '租户id',
  PRIMARY KEY (`materialCategoryId`),
  KEY `FK3EE7F725237A77D8` (`parentId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='产品类型表';

-- ----------------------------
-- Records of tb_material_category
-- ----------------------------

-- ----------------------------
-- Table structure for `tb_material_extend`
-- ----------------------------
DROP TABLE IF EXISTS `tb_material_extend`;
CREATE TABLE `tb_material_extend` (
  `materialExtendid` int(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `materialId` int(20) DEFAULT NULL COMMENT '商品id',
  `barCode` varchar(50) DEFAULT NULL COMMENT '商品条码',
  `commodityUnit` varchar(50) DEFAULT NULL COMMENT '商品单位',
  `purchaseDecimal` double(24,6) DEFAULT NULL COMMENT '采购价格',
  `commodityDecimal` double(24,6) DEFAULT NULL COMMENT '零售价格',
  `wholesaleDecimal` double(24,6) DEFAULT NULL COMMENT '销售价格',
  `lowDecimal` double(24,6) DEFAULT NULL COMMENT '最低售价',
  `defaultFlag` varchar(1) DEFAULT '1' COMMENT '是否为默认单位，1是，0否',
  `createTime` datetime DEFAULT NULL COMMENT '创建日期',
  `createSerial` varchar(50) DEFAULT NULL COMMENT '创建人编码',
  `updateSerial` varchar(50) DEFAULT NULL COMMENT '更新人编码',
  `updateTime` int(20) DEFAULT NULL COMMENT '更新时间戳',
  `tenantId` int(20) DEFAULT NULL COMMENT '租户id',
  `deleteFlag` varchar(1) DEFAULT '0' COMMENT '删除标记，0未删除，1删除',
  PRIMARY KEY (`materialExtendid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='产品价格扩展';

-- ----------------------------
-- Records of tb_material_extend
-- ----------------------------

-- ----------------------------
-- Table structure for `tb_material_property`
-- ----------------------------
DROP TABLE IF EXISTS `tb_material_property`;
CREATE TABLE `tb_material_property` (
  `materialPropertyId` int(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `nativeName` varchar(50) DEFAULT NULL COMMENT '原始名称',
  `enabled` int(1) DEFAULT NULL COMMENT '是否启用',
  `sort` varchar(10) DEFAULT NULL COMMENT '排序',
  `anotherName` varchar(50) DEFAULT NULL COMMENT '别名',
  `deleteFlag` varchar(1) DEFAULT '0' COMMENT '删除标记，0未删除，1删除',
  PRIMARY KEY (`materialPropertyId`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='产品扩展字段表';

-- ----------------------------
-- Records of tb_material_property
-- ----------------------------
INSERT INTO `tb_material_property` VALUES ('1', '规格', '1', '02', '规格', '0');
INSERT INTO `tb_material_property` VALUES ('2', '颜色', '1', '01', '颜色', '0');
INSERT INTO `tb_material_property` VALUES ('3', '制造商', '1', '03', '制造商', '0');
INSERT INTO `tb_material_property` VALUES ('4', '自定义1', '0', '04', '自定义1', '0');
INSERT INTO `tb_material_property` VALUES ('5', '自定义2', '0', '05', '自定义2', '0');
INSERT INTO `tb_material_property` VALUES ('6', '自定义3', '0', '06', '自定义3', '0');

-- ----------------------------
-- Table structure for `tb_material_stock`
-- ----------------------------
DROP TABLE IF EXISTS `tb_material_stock`;
CREATE TABLE `tb_material_stock` (
  `materialStockId` int(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `materialId` int(20) DEFAULT NULL COMMENT '产品id',
  `depotId` int(20) DEFAULT NULL COMMENT '仓库id',
  `number` double(24,6) DEFAULT NULL COMMENT '初始库存数量',
  `tenantId` int(20) DEFAULT NULL COMMENT '租户id',
  `deleteFlag` varchar(1) DEFAULT '0' COMMENT '删除标记，0未删除，1删除',
  PRIMARY KEY (`materialStockId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='产品初始库存';

-- ----------------------------
-- Records of tb_material_stock
-- ----------------------------

-- ----------------------------
-- Table structure for `tb_msg`
-- ----------------------------
DROP TABLE IF EXISTS `tb_msg`;
CREATE TABLE `tb_msg` (
  `msgId` int(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `msgTitle` varchar(100) DEFAULT NULL COMMENT '消息标题',
  `msgContent` varchar(500) DEFAULT NULL COMMENT '消息内容',
  `createTime` datetime DEFAULT NULL COMMENT '创建时间',
  `type` varchar(20) DEFAULT NULL COMMENT '消息类型',
  `status` varchar(1) DEFAULT NULL COMMENT '状态，1未读 2已读',
  `tenantId` int(20) DEFAULT NULL COMMENT '租户id',
  `deleteFlag` varchar(1) DEFAULT '0' COMMENT '删除标记，0未删除，1删除',
  PRIMARY KEY (`msgId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='消息表';

-- ----------------------------
-- Records of tb_msg
-- ----------------------------

-- ----------------------------
-- Table structure for `tb_organization`
-- ----------------------------
DROP TABLE IF EXISTS `tb_organization`;
CREATE TABLE `tb_organization` (
  `orgId` int(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `orgNo` varchar(20) DEFAULT NULL COMMENT '机构编号',
  `orgFullName` varchar(500) DEFAULT NULL COMMENT '机构全称',
  `orgAbr` varchar(20) DEFAULT NULL COMMENT '机构简称',
  `orgTpcd` varchar(9) DEFAULT NULL COMMENT '机构类型',
  `orgStcd` char(1) DEFAULT NULL COMMENT '机构状态,1未营业、2正常营业、3暂停营业、4终止营业、5已除名',
  `orgParentNo` varchar(20) DEFAULT NULL COMMENT '机构父节点编号',
  `sort` varchar(20) DEFAULT NULL COMMENT '机构显示顺序',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注',
  `createTime` datetime DEFAULT NULL COMMENT '创建时间',
  `creator` int(20) DEFAULT NULL COMMENT '创建人',
  `updateTime` datetime DEFAULT NULL COMMENT '更新时间',
  `updater` int(20) DEFAULT NULL COMMENT '更新人',
  `orgCreateTime` datetime DEFAULT NULL COMMENT '机构创建时间',
  `orgStopTime` datetime DEFAULT NULL COMMENT '机构停运时间',
  `tenantId` int(20) DEFAULT NULL COMMENT '租户id',
  PRIMARY KEY (`orgId`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8 COMMENT='机构表';

-- ----------------------------
-- Records of tb_organization
-- ----------------------------
INSERT INTO `tb_organization` VALUES ('12', '001', '测试机构', '测试机构', '', '2', '-1', '001', '', '2019-12-28 12:13:01', '1', '2019-12-28 12:13:01', '1', '0000-00-00 00:00:00', '0000-00-00 00:00:00', '1');
INSERT INTO `tb_organization` VALUES ('13', '002', '测试公司1', '测试公司1', '', '2', '001', '12', '测试公司1', '2020-07-21 18:21:15', '1', '2020-07-22 09:28:13', '1', '2020-07-17 18:21:05', '2020-07-30 18:21:10', '1');
INSERT INTO `tb_organization` VALUES ('16', '1003', '测试公司2', '测试公司2', null, '2', '1002', '16', '测试公司2', '2020-07-22 06:48:34', '1', '2020-07-22 09:34:56', '1', '2020-07-22 06:48:24', '2020-07-31 06:48:25', '1');
INSERT INTO `tb_organization` VALUES ('17', '1002', '测试机构2', '测试机构2', null, '2', '-1', '002', '测试机构2', '2020-07-22 06:50:46', '1', '2020-07-22 09:34:08', '1', '2020-07-22 06:50:34', '2020-07-31 06:50:35', '1');
INSERT INTO `tb_organization` VALUES ('18', '1004', '测试公司3', '测试公司3', null, '2', '1002', '17', '测试公司4', '2020-07-22 09:36:14', '1', '2020-07-22 09:36:57', '1', '2020-07-22 09:36:05', '2020-07-31 09:36:09', '1');

-- ----------------------------
-- Table structure for `tb_orga_user_rel`
-- ----------------------------
DROP TABLE IF EXISTS `tb_orga_user_rel`;
CREATE TABLE `tb_orga_user_rel` (
  `orgaUserRelId` int(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `orgaId` int(20) NOT NULL COMMENT '机构id',
  `userId` int(20) NOT NULL COMMENT '用户id',
  `userBlngOrgaDsplSeq` varchar(20) DEFAULT NULL COMMENT '用户在所属机构中显示顺序',
  `deleteFlag` varchar(1) DEFAULT '0' COMMENT '删除标记，0未删除，1删除',
  `createTime` datetime DEFAULT NULL COMMENT '创建时间',
  `creator` int(20) DEFAULT NULL COMMENT '创建人',
  `updateTime` datetime DEFAULT NULL COMMENT '更新时间',
  `updater` int(20) DEFAULT NULL COMMENT '更新人',
  `tenantId` int(20) DEFAULT NULL COMMENT '租户id',
  PRIMARY KEY (`orgaUserRelId`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8 COMMENT='机构用户关系表';

-- ----------------------------
-- Records of tb_orga_user_rel
-- ----------------------------
INSERT INTO `tb_orga_user_rel` VALUES ('1', '0', '15', '44', '0', null, '0', null, '0', '0');
INSERT INTO `tb_orga_user_rel` VALUES ('2', '0', '16', '55', '0', null, '0', null, '0', '0');
INSERT INTO `tb_orga_user_rel` VALUES ('3', '13', '17', '56', '0', null, '0', null, '0', '1');
INSERT INTO `tb_orga_user_rel` VALUES ('4', '13', '18', '78', '0', null, '0', null, '0', '1');

-- ----------------------------
-- Table structure for `tb_person`
-- ----------------------------
DROP TABLE IF EXISTS `tb_person`;
CREATE TABLE `tb_person` (
  `personId` int(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `type` varchar(20) DEFAULT NULL COMMENT '类型',
  `name` varchar(50) DEFAULT NULL COMMENT '姓名',
  `tenantId` int(20) DEFAULT NULL COMMENT '租户id',
  `deleteFlag` varchar(1) DEFAULT '0' COMMENT '删除标记，0未删除，1删除',
  PRIMARY KEY (`personId`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='经手人表';

-- ----------------------------
-- Records of tb_person
-- ----------------------------
INSERT INTO `tb_person` VALUES ('1', '业务员', '小汤', '1', '0');
INSERT INTO `tb_person` VALUES ('2', '仓管员', '小林', '1', '0');
INSERT INTO `tb_person` VALUES ('3', '财务员', '小耀', '1', '0');
INSERT INTO `tb_person` VALUES ('4', '业务员', 'aa', '1', '1');
INSERT INTO `tb_person` VALUES ('5', '业务员', 'bb', '1', '1');
INSERT INTO `tb_person` VALUES ('6', '仓管员', 'ccss', '1', '1');

-- ----------------------------
-- Table structure for `tb_role`
-- ----------------------------
DROP TABLE IF EXISTS `tb_role`;
CREATE TABLE `tb_role` (
  `roleId` int(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `name` varchar(50) DEFAULT NULL COMMENT '名称',
  `type` varchar(50) DEFAULT NULL COMMENT '类型',
  `value` varchar(200) DEFAULT NULL COMMENT '值',
  `description` varchar(100) DEFAULT NULL COMMENT '描述',
  `tenantId` int(20) DEFAULT NULL COMMENT '租户id',
  `deleteFlag` varchar(1) DEFAULT '0' COMMENT '删除标记，0未删除，1删除',
  PRIMARY KEY (`roleId`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8 COMMENT='角色表';

-- ----------------------------
-- Records of tb_role
-- ----------------------------
INSERT INTO `tb_role` VALUES ('1', '测试角色', null, null, null, '1', '0');
INSERT INTO `tb_role` VALUES ('4', '测试0', null, null, null, '1', '0');
INSERT INTO `tb_role` VALUES ('5', '测试1', null, null, null, '1', '0');
INSERT INTO `tb_role` VALUES ('6', '测试2', null, null, null, '1', '0');

-- ----------------------------
-- Table structure for `tb_sequence`
-- ----------------------------
DROP TABLE IF EXISTS `tb_sequence`;
CREATE TABLE `tb_sequence` (
  `seqName` varchar(50) NOT NULL COMMENT '序列名称',
  `minValue` int(20) NOT NULL COMMENT '最小值',
  `maxValue` int(20) NOT NULL COMMENT '最大值',
  `currentVal` int(20) NOT NULL COMMENT '当前值',
  `incrementVal` int(11) NOT NULL DEFAULT '1' COMMENT '增长步数',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`seqName`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='单据编号表';

-- ----------------------------
-- Records of tb_sequence
-- ----------------------------

-- ----------------------------
-- Table structure for `tb_serial_number`
-- ----------------------------
DROP TABLE IF EXISTS `tb_serial_number`;
CREATE TABLE `tb_serial_number` (
  `serialId` int(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `materialId` int(20) DEFAULT NULL COMMENT '产品表id',
  `serialNumber` varchar(64) DEFAULT NULL COMMENT '序列号',
  `isSell` varchar(1) DEFAULT '0' COMMENT '是否卖出，0未卖出，1卖出',
  `remark` varchar(1024) DEFAULT NULL COMMENT '备注',
  `deleteFlag` varchar(1) DEFAULT '0' COMMENT '删除标记，0未删除，1删除',
  `createTime` datetime DEFAULT NULL COMMENT '创建时间',
  `creator` int(20) DEFAULT NULL COMMENT '创建人',
  `updateTime` datetime DEFAULT NULL COMMENT '更新时间',
  `updater` int(20) DEFAULT NULL COMMENT '更新人',
  `depotHeadId` int(20) DEFAULT NULL COMMENT '单据主表id，用于跟踪序列号流向',
  `tenantId` int(20) DEFAULT NULL COMMENT '租户id',
  PRIMARY KEY (`serialId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='序列号表';

-- ----------------------------
-- Records of tb_serial_number
-- ----------------------------

-- ----------------------------
-- Table structure for `tb_supplier`
-- ----------------------------
DROP TABLE IF EXISTS `tb_supplier`;
CREATE TABLE `tb_supplier` (
  `supplierId` int(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `supplier` varchar(255) NOT NULL COMMENT '供应商名称',
  `contacts` varchar(100) DEFAULT NULL COMMENT '联系人',
  `phoneNum` varchar(30) DEFAULT NULL COMMENT '联系电话',
  `email` varchar(50) DEFAULT NULL COMMENT '电子邮箱',
  `description` varchar(500) DEFAULT NULL COMMENT '备注',
  `isSystem` int(4) DEFAULT NULL COMMENT '是否系统自带 0==系统 1==非系统',
  `type` varchar(20) DEFAULT NULL COMMENT '类型',
  `enabled` int(1) DEFAULT NULL COMMENT '启用',
  `advanceIn` double(24,6) DEFAULT '0.000000' COMMENT '预收款',
  `beginNeedGet` double(24,6) DEFAULT NULL COMMENT '期初应收',
  `beginNeedPay` double(24,6) DEFAULT NULL COMMENT '期初应付',
  `allNeedGet` double(24,6) DEFAULT NULL COMMENT '累计应收',
  `allNeedPay` double(24,6) DEFAULT NULL COMMENT '累计应付',
  `fax` varchar(30) DEFAULT NULL COMMENT '传真',
  `telephone` varchar(30) DEFAULT NULL COMMENT '手机',
  `address` varchar(50) DEFAULT NULL COMMENT '地址',
  `taxNum` varchar(50) DEFAULT NULL COMMENT '纳税人识别号',
  `bankName` varchar(50) DEFAULT NULL COMMENT '开户行',
  `accountNumber` varchar(50) DEFAULT NULL COMMENT '账号',
  `taxRate` double(24,6) DEFAULT NULL COMMENT '税率',
  `tenantId` int(20) DEFAULT NULL COMMENT '租户id',
  `deleteFlag` varchar(1) DEFAULT '0' COMMENT '删除标记，0未删除，1删除',
  PRIMARY KEY (`supplierId`)
) ENGINE=InnoDB AUTO_INCREMENT=63 DEFAULT CHARSET=utf8 COMMENT='供应商/客户信息表';

-- ----------------------------
-- Records of tb_supplier
-- ----------------------------
INSERT INTO `tb_supplier` VALUES ('47', '供应商1', '', '', '', '', '0', '供应商', '1', '0.000000', '0.000000', '0.000000', '0.000000', '0.000000', '', '', '', '', '', '', '0.000000', '1', '0');
INSERT INTO `tb_supplier` VALUES ('48', '客户1', '', '', '', '', null, '客户', '1', '0.000000', '0.000000', '0.000000', '0.000000', '0.000000', '', '', '', '', '', '', '0.000000', '1', '0');
INSERT INTO `tb_supplier` VALUES ('49', '会员1', '', '', '', '', null, '会员', '1', '6.000000', '0.000000', '0.000000', '0.000000', '0.000000', '', '', '', '', '', '', '0.000000', '1', '0');
INSERT INTO `tb_supplier` VALUES ('50', '供应商2', '', '', '', '', '0', '供应商', '1', '0.000000', '0.000000', '0.000000', '0.000000', '0.000000', '', '', '', '', '', '', '0.000000', '1', '0');
INSERT INTO `tb_supplier` VALUES ('51', '供应商33', '唐生', '100861', 'tanglinyao_web@163.com', 'xxxx1', '0', '供应商', '1', '0.000000', '0.000000', '0.000000', '0.000000', '0.000000', '0021-159357', '10086111', 'xxxxx1', '1101', '农业银行1', '11112222333344441', '0.000000', '1', '0');
INSERT INTO `tb_supplier` VALUES ('52', '供应商4', '', '', '', '', '0', '供应商', '0', '0.000000', '0.000000', '0.000000', '0.000000', '0.000000', '', '', '', '', '', '', '0.000000', '1', '1');
INSERT INTO `tb_supplier` VALUES ('53', '供应商5', '', '', '', '', '0', '供应商', '0', '0.000000', '0.000000', '0.000000', '0.000000', '0.000000', '', '', '', '', '', '', '0.000000', '1', '1');
INSERT INTO `tb_supplier` VALUES ('54', '供应商6', '', '', '', '', '0', '供应商', '0', '0.000000', '0.000000', '0.000000', '0.000000', '0.000000', '', '', '', '', '', '', '0.000000', '1', '1');
INSERT INTO `tb_supplier` VALUES ('55', '供应商7', '', '', '', '', '0', '供应商', '0', '0.000000', '0.000000', '0.000000', '0.000000', '0.000000', '', '', '', '', '', '', '0.000000', '1', '1');
INSERT INTO `tb_supplier` VALUES ('56', '供应商8', '', '', '', '', '0', '供应商', '0', '0.000000', '0.000000', '0.000000', '0.000000', '0.000000', '', '', '', '', '', '', '0.000000', '1', '1');
INSERT INTO `tb_supplier` VALUES ('57', '供应商9', '', '', '', '', '0', '供应商', '0', '0.000000', '0.000000', '0.000000', '0.000000', '0.000000', '', '', '', '', '', '', '0.000000', '1', '1');
INSERT INTO `tb_supplier` VALUES ('58', '供应商10', '', '', '', '', '0', '供应商', '0', '0.000000', '0.000000', '0.000000', '0.000000', '0.000000', '', '', '', '', '', '', '0.000000', '1', '1');
INSERT INTO `tb_supplier` VALUES ('59', '供应商11', '', '', '', '', '0', '供应商', '0', '0.000000', '0.000000', '0.000000', '0.000000', '0.000000', '', '', '', '', '', '', '0.000000', '1', '1');
INSERT INTO `tb_supplier` VALUES ('60', '供应商12', '', '', '', '', '0', '供应商', '0', '0.000000', '0.000000', '0.000000', '0.000000', '0.000000', '', '', '', '', '', '', '0.000000', '1', '1');
INSERT INTO `tb_supplier` VALUES ('61', '供应商13', '', '', '', '', '0', '供应商', '0', '0.000000', '0.000000', '0.000000', '0.000000', '0.000000', '', '', '', '', '', '', '0.000000', '1', '1');
INSERT INTO `tb_supplier` VALUES ('62', '供应商14', '', '', '', '', '0', '供应商', '0', '0.000000', '0.000000', '0.000000', '0.000000', '0.000000', '', '', '', '', '', '', '0.000000', '1', '1');

-- ----------------------------
-- Table structure for `tb_system_config`
-- ----------------------------
DROP TABLE IF EXISTS `tb_system_config`;
CREATE TABLE `tb_system_config` (
  `systemConfigId` int(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `companyName` varchar(50) DEFAULT NULL COMMENT '公司名称',
  `companyContacts` varchar(20) DEFAULT NULL COMMENT '公司联系人',
  `companyAddress` varchar(50) DEFAULT NULL COMMENT '公司地址',
  `companyTel` varchar(20) DEFAULT NULL COMMENT '公司电话',
  `companyFax` varchar(20) DEFAULT NULL COMMENT '公司传真',
  `companyPostCode` varchar(20) DEFAULT NULL COMMENT '公司邮编',
  `depotFlag` varchar(1) DEFAULT '0' COMMENT '仓库启用标记，0未启用，1启用',
  `customerFlag` varchar(1) DEFAULT '0' COMMENT '客户启用标记，0未启用，1启用',
  `minusStockFlag` varchar(1) DEFAULT '0' COMMENT '负库存启用标记，0未启用，1启用',
  `tenantId` int(20) DEFAULT NULL COMMENT '租户id',
  `deleteFlag` varchar(1) DEFAULT '0' COMMENT '删除标记，0未删除，1删除',
  PRIMARY KEY (`systemConfigId`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='系统参数';

-- ----------------------------
-- Records of tb_system_config
-- ----------------------------
INSERT INTO `tb_system_config` VALUES ('1', '德意龙科技有限公司', '龙生', '得得地1号', '10088', 'fix-123', 'dylong_web@163.com', '1', '1', '1', '1', '0');

-- ----------------------------
-- Table structure for `tb_tenant`
-- ----------------------------
DROP TABLE IF EXISTS `tb_tenant`;
CREATE TABLE `tb_tenant` (
  `id` int(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `tenantId` int(20) DEFAULT NULL COMMENT '用户id',
  `loginName` varchar(255) DEFAULT NULL COMMENT '登录名',
  `userNumLimit` int(11) DEFAULT NULL COMMENT '用户数量限制',
  `billsNumLimit` int(11) DEFAULT NULL COMMENT '单据数量限制',
  `createTime` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8 COMMENT='租户';

-- ----------------------------
-- Records of tb_tenant
-- ----------------------------
INSERT INTO `tb_tenant` VALUES ('1', '1', 'leo', '20', '2000', '2020-07-15 16:39:54');
INSERT INTO `tb_tenant` VALUES ('2', '12', 'tang', '1000000', '100000000', '2020-07-16 12:42:03');
INSERT INTO `tb_tenant` VALUES ('3', '13', 'lin', '1000000', '100000000', '2020-07-16 12:58:51');

-- ----------------------------
-- Table structure for `tb_unit`
-- ----------------------------
DROP TABLE IF EXISTS `tb_unit`;
CREATE TABLE `tb_unit` (
  `unitId` int(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `uName` varchar(50) DEFAULT NULL COMMENT '名称，支持多单位',
  `basicUnit` varchar(50) DEFAULT NULL COMMENT '基础单位',
  `otherUnit` varchar(50) DEFAULT NULL COMMENT '副单位',
  `ratio` int(11) DEFAULT NULL COMMENT '比例',
  `tenantId` int(20) DEFAULT NULL COMMENT '租户id',
  `deleteFlag` varchar(1) DEFAULT '0' COMMENT '删除标记，0未删除，1删除',
  PRIMARY KEY (`unitId`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='多单位表';

-- ----------------------------
-- Records of tb_unit
-- ----------------------------

-- ----------------------------
-- Table structure for `tb_user`
-- ----------------------------
DROP TABLE IF EXISTS `tb_user`;
CREATE TABLE `tb_user` (
  `userId` int(11) NOT NULL AUTO_INCREMENT,
  `userName` varchar(255) NOT NULL,
  `loginName` varchar(255) NOT NULL,
  `password` varchar(50) NOT NULL,
  `position` varchar(200) DEFAULT NULL COMMENT '职位',
  `department` varchar(255) DEFAULT NULL COMMENT '所属部门',
  `email` varchar(100) DEFAULT NULL COMMENT '电子邮箱',
  `phoneNum` varchar(100) DEFAULT NULL COMMENT '手机号码',
  `isManager` int(4) DEFAULT NULL COMMENT '是否为管理者1:管理者 2:员工',
  `isSystem` int(4) DEFAULT NULL COMMENT '是否系统自带数据',
  `status` int(4) DEFAULT NULL COMMENT '状态,1:正常,2:删除,3.封禁',
  `description` varchar(500) DEFAULT NULL COMMENT '用户描述信息',
  `remark` varchar(500) DEFAULT NULL COMMENT '备注',
  `tenantId` int(20) DEFAULT NULL COMMENT '租户id',
  PRIMARY KEY (`userId`)
) ENGINE=InnoDB AUTO_INCREMENT=19 DEFAULT CHARSET=utf8 COMMENT='用户表';

-- ----------------------------
-- Records of tb_user
-- ----------------------------
INSERT INTO `tb_user` VALUES ('1', 'leo', 'leo', '202cb962ac59075b964b07152d234b70', null, null, null, null, '1', '0', '0', null, null, '1');
INSERT INTO `tb_user` VALUES ('12', 'tang1', 'tang', '202cb962ac59075b964b07152d234b70', 'qq', null, '123@qq.com', '114', '0', '0', '0', 'xxx', null, '12');
INSERT INTO `tb_user` VALUES ('13', 'lin1', 'lin', '202cb962ac59075b964b07152d234b70', 'AA', null, '23@qq.com', '119', '0', '0', '0', 'dd', null, '13');
INSERT INTO `tb_user` VALUES ('17', 'yao', 'yao', 'e10adc3949ba59abbe56e057f20f883e', 'er', null, '554@qq.com', '334', '1', '0', '0', 'lll', null, '1');
INSERT INTO `tb_user` VALUES ('18', 'biu', 'biu', 'e10adc3949ba59abbe56e057f20f883e', 'bbb', null, '6672@qq.com', '6677', '1', '0', '0', 'llff', null, '1');

-- ----------------------------
-- Table structure for `tb_user_business`
-- ----------------------------
DROP TABLE IF EXISTS `tb_user_business`;
CREATE TABLE `tb_user_business` (
  `userBusinessId` int(20) NOT NULL AUTO_INCREMENT COMMENT '主键',
  `type` varchar(50) DEFAULT NULL COMMENT '类别',
  `keyId` varchar(50) DEFAULT NULL COMMENT '主ID',
  `value` varchar(10000) DEFAULT NULL COMMENT '值',
  `btnStr` varchar(2000) DEFAULT NULL COMMENT '按钮权限',
  `deleteFlag` varchar(1) DEFAULT '0' COMMENT '删除标记，0未删除，1删除',
  PRIMARY KEY (`userBusinessId`)
) ENGINE=InnoDB AUTO_INCREMENT=86 DEFAULT CHARSET=utf8 COMMENT='用户/角色/模块关系表';

-- ----------------------------
-- Records of tb_user_business
-- ----------------------------
INSERT INTO `tb_user_business` VALUES ('5', 'RoleFunctions', '4', '[245][13][12][16][243][14][15][234][236][22][23][220][240][25][217][218][26][194][195][31][59][207][208][209][226][227][228][229][235][237][244][210][211][241][33][199][242][41][200][201][202][40][232][233][197][203][204][205][206][212][246][245]', '[{\"funId\":\"25\",\"btnStr\":\"1\"},{\"funId\":\"217\",\"btnStr\":\"1\"},{\"funId\":\"218\",\"btnStr\":\"1\"},{\"funId\":\"241\",\"btnStr\":\"3\"},{\"funId\":\"242\",\"btnStr\":\"3\"}]', '0');
INSERT INTO `tb_user_business` VALUES ('6', 'RoleFunctions', '5', '[22][23][25][26][194][195][31][33][200][201][41][199][202]', '', '0');
INSERT INTO `tb_user_business` VALUES ('7', 'RoleFunctions', '6', '[22][23][220][240][25][217][218][26][194][195][31][59][207][208][209][226][227][228][229][235][237][210][211][241][33][199][242][41][200][201][202][40][232][233][197][203][204][205][206][212]', '[{\"funId\":\"33\",\"btnStr\":\"4\"}]', '0');
INSERT INTO `tb_user_business` VALUES ('9', 'RoleFunctions', '7', '[168][13][12][16][14][15][189][18][19][132]', '', '0');
INSERT INTO `tb_user_business` VALUES ('10', 'RoleFunctions', '8', '[168][13][12][16][14][15][189][18][19][132][22][23][25][26][27][157][158][155][156][125][31][127][126][128][33][34][35][36][37][39][40][41][42][43][46][47][48][49][50][51][52][53][54][55][56][57][192][59][60][61][62][63][65][66][68][69][70][71][73][74][76][77][79][191][81][82][83][85][89][161][86][176][165][160][28][134][91][92][29][94][95][97][104][99][100][101][102][105][107][108][110][111][113][114][116][117][118][120][121][131][135][123][122][20][130][146][147][138][148][149][153][140][145][184][152][143][170][171][169][166][167][163][164][172][173][179][178][181][182][183][186][187]', '', '0');
INSERT INTO `tb_user_business` VALUES ('11', 'RoleFunctions', '9', '[168][13][12][16][14][15][189][18][19][132][22][23][25][26][27][157][158][155][156][125][31][127][126][128][33][34][35][36][37][39][40][41][42][43][46][47][48][49][50][51][52][53][54][55][56][57][192][59][60][61][62][63][65][66][68][69][70][71][73][74][76][77][79][191][81][82][83][85][89][161][86][176][165][160][28][134][91][92][29][94][95][97][104][99][100][101][102][105][107][108][110][111][113][114][116][117][118][120][121][131][135][123][122][20][130][146][147][138][148][149][153][140][145][184][152][143][170][171][169][166][167][163][164][172][173][179][178][181][182][183][186][187][188]', '', '0');
INSERT INTO `tb_user_business` VALUES ('12', 'UserRole', '1', '[666]', '', '0');
INSERT INTO `tb_user_business` VALUES ('13', 'UserRole', '2', '[6][7]', '', '0');
INSERT INTO `tb_user_business` VALUES ('14', 'UserDepot', '2', '[1][2][6][7]', '', '0');
INSERT INTO `tb_user_business` VALUES ('15', 'UserDepot', '1', '[1][2][5][6][7][10][12][14][15][17]', '', '0');
INSERT INTO `tb_user_business` VALUES ('16', 'UserRole', '63', '[10]', '', '0');
INSERT INTO `tb_user_business` VALUES ('18', 'UserDepot', '63', '[14][15]', '', '0');
INSERT INTO `tb_user_business` VALUES ('19', 'UserDepot', '5', '[6][45][46][50]', '', '0');
INSERT INTO `tb_user_business` VALUES ('20', 'UserRole', '5', '[5]', '', '0');
INSERT INTO `tb_user_business` VALUES ('21', 'UserRole', '64', '[13]', '', '0');
INSERT INTO `tb_user_business` VALUES ('22', 'UserDepot', '64', '[1]', '', '0');
INSERT INTO `tb_user_business` VALUES ('23', 'UserRole', '65', '[5]', '', '0');
INSERT INTO `tb_user_business` VALUES ('24', 'UserDepot', '65', '[1]', '', '0');
INSERT INTO `tb_user_business` VALUES ('25', 'UserCustomer', '64', '[5][2]', '', '0');
INSERT INTO `tb_user_business` VALUES ('26', 'UserCustomer', '65', '[6]', '', '0');
INSERT INTO `tb_user_business` VALUES ('27', 'UserCustomer', '63', '[58]', '', '0');
INSERT INTO `tb_user_business` VALUES ('28', 'UserDepot', '96', '[7]', '', '0');
INSERT INTO `tb_user_business` VALUES ('29', 'UserRole', '96', '[6]', '', '0');
INSERT INTO `tb_user_business` VALUES ('30', 'UserRole', '113', '[10]', '', '0');
INSERT INTO `tb_user_business` VALUES ('32', 'RoleFunctions', '10', '[210][211][241][33][199][242][41][200][201][202][40][232][233][197][203][204][205][206][212][59][207][208][209][226][227][228][229][235][237][244][22][23][220][240][25][217][218][26][194][195][31][13][243][14][15][234]', '[{\"funId\":\"25\",\"btnStr\":\"1\"},{\"funId\":\"217\",\"btnStr\":\"1\"},{\"funId\":\"218\",\"btnStr\":\"1\"},{\"funId\":\"241\",\"btnStr\":\"3\"},{\"funId\":\"242\",\"btnStr\":\"3\"}]', '0');
INSERT INTO `tb_user_business` VALUES ('34', 'UserRole', '115', '[10]', '', '0');
INSERT INTO `tb_user_business` VALUES ('35', 'UserRole', '117', '[10]', '', '0');
INSERT INTO `tb_user_business` VALUES ('36', 'UserDepot', '117', '[8][9]', '', '0');
INSERT INTO `tb_user_business` VALUES ('37', 'UserCustomer', '117', '[52]', '', '0');
INSERT INTO `tb_user_business` VALUES ('38', 'UserRole', '120', '[4]', '', '0');
INSERT INTO `tb_user_business` VALUES ('39', 'UserDepot', '120', '[7][8][9][10][11][12][2][1][3]', '', '0');
INSERT INTO `tb_user_business` VALUES ('40', 'UserCustomer', '120', '[52][48][6][5][2]', '', '0');
INSERT INTO `tb_user_business` VALUES ('41', 'RoleFunctions', '12', '', '', '0');
INSERT INTO `tb_user_business` VALUES ('48', 'RoleFunctions', '13', '[59][207][208][209][226][227][228][229][235][237][210][211][241][33][199][242][41][200]', '', '0');
INSERT INTO `tb_user_business` VALUES ('51', 'UserRole', '74', '[10]', '', '0');
INSERT INTO `tb_user_business` VALUES ('52', 'UserDepot', '121', '[13]', '', '0');
INSERT INTO `tb_user_business` VALUES ('54', 'UserDepot', '115', '[13]', '', '0');
INSERT INTO `tb_user_business` VALUES ('56', 'UserCustomer', '115', '[56]', '', '0');
INSERT INTO `tb_user_business` VALUES ('57', 'UserCustomer', '121', '[56]', '', '0');
INSERT INTO `tb_user_business` VALUES ('58', 'UserRole', '121', '[15]', '', '0');
INSERT INTO `tb_user_business` VALUES ('59', 'UserRole', '123', '[10]', '', '0');
INSERT INTO `tb_user_business` VALUES ('60', 'UserRole', '124', '[10]', '', '0');
INSERT INTO `tb_user_business` VALUES ('61', 'UserRole', '125', '[10]', '', '0');
INSERT INTO `tb_user_business` VALUES ('62', 'UserRole', '126', '[10]', '', '0');
INSERT INTO `tb_user_business` VALUES ('63', 'UserRole', '127', '[10]', '', '0');
INSERT INTO `tb_user_business` VALUES ('64', 'UserRole', '128', '[10]', '', '0');
INSERT INTO `tb_user_business` VALUES ('65', 'UserRole', '129', '[10]', '', '0');
INSERT INTO `tb_user_business` VALUES ('66', 'UserRole', '130', '[10]', '', '0');
INSERT INTO `tb_user_business` VALUES ('67', 'UserRole', '131', '[16]', '', '0');
INSERT INTO `tb_user_business` VALUES ('78', 'UserRole', '12', '[10]', null, '0');
INSERT INTO `tb_user_business` VALUES ('79', 'UserRole', '13', '[10]', null, '0');
INSERT INTO `tb_user_business` VALUES ('80', 'RoleFunctions', '666', '[13][14][15][16][22][23][25][26][31][33][40][41][59][194][195][197][199][200][201][202][203][204][205][206][207][208][209][210][211][212][217][218][220][226][227][228][229][232][233][234][235][236][237][240][241][242][243][244][245][251]', '[{\"funId\":\"25\",\"btnStr\":\"1\"},{\"funId\":\"217\",\"btnStr\":\"1\"},{\"funId\":\"218\",\"btnStr\":\"1\"},{\"funId\":\"241\",\"btnStr\":\"3\"},{\"funId\":\"242\",\"btnStr\":\"3\"}]', '0');
INSERT INTO `tb_user_business` VALUES ('81', 'RoleFunctions', '1', '[210][211][241][33][199][242][41][200]', '[{\"funId\":\"241\",\"btnStr\":\"3\"},{\"funId\":\"33\",\"btnStr\":\"4\"},{\"funId\":\"199\",\"btnStr\":\"4\"},{\"funId\":\"242\",\"btnStr\":\"3\"},{\"funId\":\"41\",\"btnStr\":\"4\"},{\"funId\":\"200\",\"btnStr\":\"4\"},{\"funId\":\"210\",\"btnStr\":\"4\"},{\"funId\":\"211\",\"btnStr\":\"4\"}]', '0');
INSERT INTO `tb_user_business` VALUES ('83', 'UserRole', '17', '[1]', null, '0');
INSERT INTO `tb_user_business` VALUES ('84', 'UserDepot', '17', '[2][1]', null, '0');
INSERT INTO `tb_user_business` VALUES ('85', 'UserCustomer', '17', '[48]', null, '0');