/*
Navicat MySQL Data Transfer

Source Server         : 密码1-6
Source Server Version : 80012
Source Host           : localhost:3306
Source Database       : erp

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

Date: 2020-05-20 21:01:43
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for buy_details
-- ----------------------------
DROP TABLE IF EXISTS `buy_details`;
CREATE TABLE `buy_details` (
  `id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `orderId` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `marId` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `num` int(11) DEFAULT NULL,
  `price` double DEFAULT NULL,
  `inNum` int(11) DEFAULT '0',
  `inState` int(1) DEFAULT '1',
  `finishState` int(1) DEFAULT '1',
  `lastInTime` datetime DEFAULT NULL,
  `numbers` int(11) NOT NULL AUTO_INCREMENT,
  `supplierId` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  PRIMARY KEY (`numbers`,`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1024 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of buy_details
-- ----------------------------
INSERT INTO `buy_details` VALUES ('2e6ad525-1139-46cc-a12a-e0df2075062f', 'b453e17a-a775-479e-ada5-c95d624e1ad9', 'qwefdfj', '100', '70', '0', '1', '1', null, '102', '1');
INSERT INTO `buy_details` VALUES ('019c7602-592d-4b61-b0cf-da5328c881cd', 'b453e17a-a775-479e-ada5-c95d624e1ad9', 'kbfd-tmsj-ddjf', '100', '70', '0', '1', '1', null, '109', '2');
INSERT INTO `buy_details` VALUES ('605e6940-a1e8-4dbc-8881-181feba80d42', '9313ba94-f2e5-4152-a29a-91fc1be0d2eb', 'vbdf-asdj-xsdn', '40', '20', '0', '1', '1', null, '1000', '2');
INSERT INTO `buy_details` VALUES ('61c1b0cf-0006-4adc-9314-6dc6248fd7ef', 'fdfa3ea3-bec2-4262-8335-9ba224ba439b', 'kbfd-tmsj-ddjf', '100', '70', '0', '1', '1', null, '1001', '2');
INSERT INTO `buy_details` VALUES ('ad72a91e-f8d4-436f-9c46-9897d19daa39', 'fdfa3ea3-bec2-4262-8335-9ba224ba439b', 'fgjgldai', '3000', '0.08', '0', '1', '1', null, '1002', '3');
INSERT INTO `buy_details` VALUES ('91c4aba5-ff9c-451d-86af-8fb191785630', 'fdfa3ea3-bec2-4262-8335-9ba224ba439b', 'qwefdfj', '100', '20', '0', '1', '1', null, '1003', '1');
INSERT INTO `buy_details` VALUES ('e735103c-c67b-491f-bb7d-b0d0fa9f5950', '2317c4c5-5048-416c-b45c-e16782f26552', 'vbdf-asdj-xsdn', '100', '70', '0', '1', '1', null, '1004', '5');
INSERT INTO `buy_details` VALUES ('632fb21f-836b-446a-bd94-71c9d7af4cad', '4ab51445-a715-4437-99a2-7b8632ad2be1', 'kbfd-tmsj-ddjf', '20', '50', '40', '3', '2', '2019-12-21 21:43:56', '1010', '2');
INSERT INTO `buy_details` VALUES ('4e916b31-c157-41bc-a9fe-f96ab8b0b0f3', '4ab51445-a715-4437-99a2-7b8632ad2be1', 'fgjgldai', '100', '70', '5000', '3', '2', '2019-12-21 21:47:44', '1011', '3');
INSERT INTO `buy_details` VALUES ('0d9245b6-2450-4954-9f5d-fd28616bd774', '4ab51445-a715-4437-99a2-7b8632ad2be1', 'qwefdfj', '100', '70', '100', '3', '2', '2019-12-21 21:48:24', '1012', '3');
INSERT INTO `buy_details` VALUES ('008f0254-4520-4357-93cb-e7de98cb5dc9', 'b0952fc4-18a1-400b-a2a5-10da29694332', 'kbfd-tmsj-ddjf', '100', '70', '0', '1', '1', null, '1013', '3');
INSERT INTO `buy_details` VALUES ('40ce014b-99de-4b96-a647-9c3eacc129fc', 'b0952fc4-18a1-400b-a2a5-10da29694332', 'fgjgldai', '100', '70', '0', '1', '1', null, '1014', '2');
INSERT INTO `buy_details` VALUES ('fc288cb2-97cc-4c56-a203-08a9a2f1d093', 'b0952fc4-18a1-400b-a2a5-10da29694332', 'qwefdfj', '100', '70', '0', '1', '1', null, '1015', '3');
INSERT INTO `buy_details` VALUES ('e8358b12-d2d5-418f-ba3b-648e1f893afd', '7cf7af8b-1dfc-42cd-9f69-c29b32f499d3', 'jysmdz', '100', '20', '120', '3', '2', '2019-12-22 22:02:59', '1016', '1');
INSERT INTO `buy_details` VALUES ('a2c72db1-61f5-4dc8-989c-6ab0dd6ffd50', '7cf7af8b-1dfc-42cd-9f69-c29b32f499d3', 'fgjgldai', '3000', '0.02', '0', '1', '1', null, '1017', '3');
INSERT INTO `buy_details` VALUES ('1aae1e5b-165f-4642-9560-dc6107f36463', '7cf7af8b-1dfc-42cd-9f69-c29b32f499d3', 'ba7a96c7-340a-4cdc-adaa-712012995fea', '30', '70', '0', '1', '1', null, '1018', 'cd3bc9ed-c3c4-40cb-aa9e-c4ef3394aea0');
INSERT INTO `buy_details` VALUES ('8b7572a5-f61b-4c2c-8be6-9ec3d830c028', '7cf7af8b-1dfc-42cd-9f69-c29b32f499d3', 'qwer-ngfy-dcpm', '30', '100', '0', '1', '1', null, '1019', '2');
INSERT INTO `buy_details` VALUES ('e99c1db7-d123-40fe-a36c-1e7b3aeb6d50', 'bd5597ff-7d01-47c6-b453-88438ac0d1d9', 'jysmdz', '100', '20', '200', '3', '2', '2019-12-31 23:41:59', '1020', '1');
INSERT INTO `buy_details` VALUES ('18aec733-b3bf-4013-aadd-629a62e05328', 'bd5597ff-7d01-47c6-b453-88438ac0d1d9', 'fgjgldai', '3000', '0.02', '3000', '3', '2', '2019-12-31 23:43:40', '1021', '3');
INSERT INTO `buy_details` VALUES ('ad5f4b43-f744-4269-b3c6-120747b3ce8d', 'bd5597ff-7d01-47c6-b453-88438ac0d1d9', 'ba7a96c7-340a-4cdc-adaa-712012995fea', '30', '70', '0', '1', '1', null, '1022', 'cd3bc9ed-c3c4-40cb-aa9e-c4ef3394aea0');
INSERT INTO `buy_details` VALUES ('d49e758c-ffa9-4f36-aaa0-2ef741ba8dea', 'bd5597ff-7d01-47c6-b453-88438ac0d1d9', 'qwer-ngfy-dcpm', '30', '100', '0', '1', '1', null, '1023', '2');

-- ----------------------------
-- Table structure for buy_order
-- ----------------------------
DROP TABLE IF EXISTS `buy_order`;
CREATE TABLE `buy_order` (
  `id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `planId` varchar(50) NOT NULL,
  `buyUserId` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `orderTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `lastInTime` datetime DEFAULT NULL,
  `state` int(1) DEFAULT '1',
  `numbers` int(11) NOT NULL AUTO_INCREMENT,
  `checker` varchar(100) DEFAULT NULL,
  `money` double DEFAULT NULL,
  PRIMARY KEY (`numbers`,`id`)
) ENGINE=InnoDB AUTO_INCREMENT=29 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of buy_order
-- ----------------------------
INSERT INTO `buy_order` VALUES ('9313ba94-f2e5-4152-a29a-91fc1be0d2eb', 'dcb9509d-fdc3-4f9d-9328-026604a346b7', '1', '2019-11-20 10:42:45', null, '2', '21', '张三山', '800');
INSERT INTO `buy_order` VALUES ('fdfa3ea3-bec2-4262-8335-9ba224ba439b', '043a1ff6-588d-4c6b-9cd5-201e4012e8d9', '1', '2019-11-20 13:06:55', null, '3', '22', '张三山', '9240');
INSERT INTO `buy_order` VALUES ('2317c4c5-5048-416c-b45c-e16782f26552', 'a77a1ea2-7dcb-47fd-b3cc-f9e905cabb61', '1', '2019-11-20 14:43:06', null, '2', '23', '张三山', '7000');
INSERT INTO `buy_order` VALUES ('b453e17a-a775-479e-ada5-c95d624e1ad9', '043a1ff6-588d-4c6b-9cd5-201e4012e8d9', '1', '2019-11-20 14:48:25', null, '2', '24', '张三山', '21000');
INSERT INTO `buy_order` VALUES ('4ab51445-a715-4437-99a2-7b8632ad2be1', '043a1ff6-588d-4c6b-9cd5-201e4012e8d9', '1', '2019-11-20 15:59:47', '2019-12-21 21:48:24', '5', '25', '张三山', '15000');
INSERT INTO `buy_order` VALUES ('b0952fc4-18a1-400b-a2a5-10da29694332', '043a1ff6-588d-4c6b-9cd5-201e4012e8d9', '1', '2019-11-23 00:05:58', null, '1', '26', null, '21000');
INSERT INTO `buy_order` VALUES ('7cf7af8b-1dfc-42cd-9f69-c29b32f499d3', '261fb726-6c7e-4e22-9633-6303b3fd8187', '1', '2019-12-19 23:16:49', '2019-12-22 22:02:59', '4', '27', '张三山', '7160');
INSERT INTO `buy_order` VALUES ('bd5597ff-7d01-47c6-b453-88438ac0d1d9', '261fb726-6c7e-4e22-9633-6303b3fd8187', '1', '2019-12-31 23:39:53', '2019-12-31 23:43:40', '4', '28', '张三山', '7160');

-- ----------------------------
-- Table structure for buy_plan
-- ----------------------------
DROP TABLE IF EXISTS `buy_plan`;
CREATE TABLE `buy_plan` (
  `id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `planName` varchar(100) DEFAULT NULL,
  `startTime` varchar(50) NOT NULL,
  `endTime` varchar(50) NOT NULL,
  `state` int(1) DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of buy_plan
-- ----------------------------
INSERT INTO `buy_plan` VALUES ('043a1ff6-588d-4c6b-9cd5-201e4012e8d9', '测试的采购计划', '2019-11-11', '2019-11-12', '2');
INSERT INTO `buy_plan` VALUES ('0bc767a6-7969-4272-8333-55d16fa497dd', '20191120采购计划', '2019-11-20', '2019-11-29', '2');
INSERT INTO `buy_plan` VALUES ('1', '测试采购计划', '2019-11-10', '2019-11-28', '2');
INSERT INTO `buy_plan` VALUES ('261fb726-6c7e-4e22-9633-6303b3fd8187', '公司测试采购计划', '2019-12-19', '2019-12-26', '2');
INSERT INTO `buy_plan` VALUES ('31f18562-c6a1-407e-b1d6-ff8cb2bd0cd3', '测试化学品类采购计划', '2019-11-11', '2019-11-15', '2');
INSERT INTO `buy_plan` VALUES ('a77a1ea2-7dcb-47fd-b3cc-f9e905cabb61', '化学品类采购计划1', '2019-11-20', '2019-11-28', '2');
INSERT INTO `buy_plan` VALUES ('da846657-ace7-440a-bdb0-0ba4664913a3', '公司测试采购计划b', '2019-12-11', '2019-12-21', '1');
INSERT INTO `buy_plan` VALUES ('dcb9509d-fdc3-4f9d-9328-026604a346b7', '测试的设备采购计划', '2019-11-11 ', '2019-11-15', '2');

-- ----------------------------
-- Table structure for buy_plan_details
-- ----------------------------
DROP TABLE IF EXISTS `buy_plan_details`;
CREATE TABLE `buy_plan_details` (
  `id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `planId` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `marId` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `planNum` int(11) DEFAULT NULL,
  `currentNum` int(11) DEFAULT '0',
  `planPrice` double DEFAULT NULL,
  `currentPrice` double DEFAULT '0',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of buy_plan_details
-- ----------------------------
INSERT INTO `buy_plan_details` VALUES ('030914e5-cac8-4186-8412-d95b85e89d44', '043a1ff6-588d-4c6b-9cd5-201e4012e8d9', 'kbfd-tmsj-ddjf', '100', '0', '70', '0');
INSERT INTO `buy_plan_details` VALUES ('1', '1', 'fgjgldai', '5000', '0', '0.1', '0.09');
INSERT INTO `buy_plan_details` VALUES ('2', '1', 'fgjgldai', '5000', '0', '0.11', '0.1');
INSERT INTO `buy_plan_details` VALUES ('2ef2708e-ba54-4850-a7a5-1d7348adc268', '0bc767a6-7969-4272-8333-55d16fa497dd', 'kbfd-tmsj-ddjf', '100', '0', '60', '0');
INSERT INTO `buy_plan_details` VALUES ('3', 'dcb9509d-fdc3-4f9d-9328-026604a346b7', 'vbdf-asdj-xsdn', '40', '0', '120', '115');
INSERT INTO `buy_plan_details` VALUES ('31d63d60-0cfc-477a-9e31-367df20fc116', '31f18562-c6a1-407e-b1d6-ff8cb2bd0cd3', 'qwer-ngfy-dcpm', '100', '0', '70', '0');
INSERT INTO `buy_plan_details` VALUES ('3878cc6b-9784-41d7-8f71-40130fc77940', '261fb726-6c7e-4e22-9633-6303b3fd8187', 'jysmdz', '100', '0', '20', '0');
INSERT INTO `buy_plan_details` VALUES ('429aaadc-e29b-4bc0-ab32-1a8f705ea969', '043a1ff6-588d-4c6b-9cd5-201e4012e8d9', 'fgjgldai', '100', '0', '70', '0');
INSERT INTO `buy_plan_details` VALUES ('65264338-05cb-4761-a423-3a9de2347ace', '261fb726-6c7e-4e22-9633-6303b3fd8187', 'fgjgldai', '3000', '0', '0.02', '0');
INSERT INTO `buy_plan_details` VALUES ('8623ea0e-01e3-452c-a463-8c4611ea1040', '261fb726-6c7e-4e22-9633-6303b3fd8187', 'ba7a96c7-340a-4cdc-adaa-712012995fea', '30', '0', '70', '0');
INSERT INTO `buy_plan_details` VALUES ('b3461f6d-7af7-4201-8594-221a442d962f', '043a1ff6-588d-4c6b-9cd5-201e4012e8d9', 'qwefdfj', '100', '0', '70', '0');
INSERT INTO `buy_plan_details` VALUES ('b8684dec-5144-421e-ace6-718f60e707f6', 'a77a1ea2-7dcb-47fd-b3cc-f9e905cabb61', 'vbdf-asdj-xsdn', '100', '0', '65', '0');
INSERT INTO `buy_plan_details` VALUES ('cbb3e04d-8f39-4636-8e41-c08f0277c176', 'http://localhost:8080/ERP/main/admin/addBuyPlanDetailsPage', 'kbfd-tmsj-ddjf', '100', '0', '70', '0');
INSERT INTO `buy_plan_details` VALUES ('f9d38655-287f-4924-a169-65b8193c585c', '261fb726-6c7e-4e22-9633-6303b3fd8187', 'qwer-ngfy-dcpm', '30', '0', '100', '0');

-- ----------------------------
-- Table structure for department
-- ----------------------------
DROP TABLE IF EXISTS `department`;
CREATE TABLE `department` (
  `id` varchar(100) NOT NULL,
  `name` varchar(50) DEFAULT NULL,
  `top` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `dtype` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of department
-- ----------------------------
INSERT INTO `department` VALUES ('1', '总经理部门', '-1', '1');
INSERT INTO `department` VALUES ('13', '测试部门', '-1', '1');
INSERT INTO `department` VALUES ('19e71737-a0d7-4b39-94d3-453bea73dd11', '测试', '87c74f48-01c4-458d-a11b-56f6868406b7', '2');
INSERT INTO `department` VALUES ('2', '财务部门', '-1', '1');
INSERT INTO `department` VALUES ('20', '项目小组', '5', '1');
INSERT INTO `department` VALUES ('21', '项目组员', '20', '2');
INSERT INTO `department` VALUES ('3', '人事部门', '1', '1');
INSERT INTO `department` VALUES ('4', '出纳部门', '2', '1');
INSERT INTO `department` VALUES ('5', '项目部门', '1', '1');
INSERT INTO `department` VALUES ('6', '出纳主任', '2', '2');
INSERT INTO `department` VALUES ('7', '项目总监', '5', '2');
INSERT INTO `department` VALUES ('71aac414-4c9d-41ac-854a-a54ca35fea01', '开发部二部', 'da4f9514-17c1-4d57-903a-ce792c0a5bf1', '1');
INSERT INTO `department` VALUES ('87c74f48-01c4-458d-a11b-56f6868406b7', 'be部门测试', '13', '1');
INSERT INTO `department` VALUES ('967fd0a1-c2c9-4bf9-a20a-858a0faa6f72', '开发部一部', 'da4f9514-17c1-4d57-903a-ce792c0a5bf1', '1');
INSERT INTO `department` VALUES ('da4f9514-17c1-4d57-903a-ce792c0a5bf1', '开发部', '1', '1');

-- ----------------------------
-- Table structure for goods
-- ----------------------------
DROP TABLE IF EXISTS `goods`;
CREATE TABLE `goods` (
  `id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `receiveType` varchar(100) DEFAULT NULL,
  `marId` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `num` varchar(100) DEFAULT NULL,
  `receiveId` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `numbers` int(11) DEFAULT '99',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of goods
-- ----------------------------
INSERT INTO `goods` VALUES ('1b6a2ae1-42e1-48d8-a153-43f191947fc4', '物品', 'kbfd-tmsj-ddjf', '1', '6718972a-78a7-4418-865d-57935016bb9b', '2');
INSERT INTO `goods` VALUES ('1beabc83-476a-4176-8843-6e8476519ae6', '物品', 'kbfd-tmsj-ddjf', '10', 'b1b47e93-f942-4d73-a203-26c3b590535f', '3');
INSERT INTO `goods` VALUES ('4b614301-274c-487a-af47-4f4597a2629c', '物品', 'fgjgldai', '1000', '0ff1cc3f-4e79-4f23-a8fb-1fb2e28fcdd8', '99');
INSERT INTO `goods` VALUES ('586c1b72-e4b9-4e50-8038-ec888c301657', '物品', 'fgjgldai', '6000', '8762fa58-3a79-44e8-88d4-b9ca6aef6818', '6');
INSERT INTO `goods` VALUES ('8d3bf5c2-522d-4335-bd89-3191e9f92f46', '物品', 'fgjgldai', '20', '59fb82dc-5a46-4c7a-9527-58b112c00cac', '99');
INSERT INTO `goods` VALUES ('b8ecb0f3-b5bf-43f5-80e1-97c09a0234c9', '物品', 'fgjgldai', '20', '6718972a-78a7-4418-865d-57935016bb9b', '1');
INSERT INTO `goods` VALUES ('bd1fd898-3219-49b8-abde-6c10c7212925', '资金', '91bdbf00-6636-4f44-83e4-a1141044700d', '100', '1fab1a04-7f29-44f3-a82f-fb478d2421d3', '99');
INSERT INTO `goods` VALUES ('d5a33383-7f82-477a-b8cb-27c8d24a443e', '物品', 'qwer-ngfy-dcpm', '100', '1fab1a04-7f29-44f3-a82f-fb478d2421d3', '99');
INSERT INTO `goods` VALUES ('e3f52195-132f-48c8-946a-b4417d03aec3', '物品', 'kbfd-tmsj-ddjf', '2', '3a3cefdd-9d85-40e5-9d6d-62da69419092', '99');
INSERT INTO `goods` VALUES ('f3eb0a3e-df4b-4847-985e-9575f1d744f5', '资金', '91bdbf00-6636-4f44-83e4-a1141044700d', '100', '3a3cefdd-9d85-40e5-9d6d-62da69419092', '1');
INSERT INTO `goods` VALUES ('fab764d0-4c99-40f7-979c-10e0d30f8751', '物品', 'vbdf-asdj-xsdn', '20', 'df7ca90c-ca79-4ae3-b54a-9335925b60b5', '99');
INSERT INTO `goods` VALUES ('kgvbujac', '物品', 'fgjgldai', '5000', 'asvbfas', '99');
INSERT INTO `goods` VALUES ('sfgaaxs', '物品', 'kbfd-tmsj-ddjf', '20', 'asvbfas', '99');

-- ----------------------------
-- Table structure for in_warehouse
-- ----------------------------
DROP TABLE IF EXISTS `in_warehouse`;
CREATE TABLE `in_warehouse` (
  `id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `marId` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `num` int(11) DEFAULT NULL,
  `inVoucher` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `inDesc` varchar(100) DEFAULT NULL,
  `inUnit` varchar(50) DEFAULT NULL,
  `inWareTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `wareId` varchar(100) DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of in_warehouse
-- ----------------------------
INSERT INTO `in_warehouse` VALUES ('0f60e3de-405a-40c3-b471-3d80088c17d3', 'fgjgldai', '5000', '4e916b31-c157-41bc-a9fe-f96ab8b0b0f3', '纸张', '张', '2019-12-21 21:47:43', 'd889be59-6d1a-4894-bb24-3bb821be0507');
INSERT INTO `in_warehouse` VALUES ('8236aab7-49c3-422d-8de6-9bba9740c37b', 'fgjgldai', '3000', '18aec733-b3bf-4013-aadd-629a62e05328', '纸张入库\n            ', '张', '2019-12-31 23:43:40', 'd889be59-6d1a-4894-bb24-3bb821be0507');
INSERT INTO `in_warehouse` VALUES ('867eb5b6-87c4-4765-b149-c307a2e30774', 'jysmdz', '100', 'e8358b12-d2d5-418f-ba3b-648e1f893afd', '物料信息\n            ', '米', '2019-12-22 22:02:58', '3e2566aa-af89-4904-ab09-81dcddd91a9f');
INSERT INTO `in_warehouse` VALUES ('95077d7a-9c0f-44df-81ad-22aeb317d58f', 'qwer-ngfy-dcpm', '100', '0d9245b6-2450-4954-9f5d-fd28616bd774', '消防水管入库', '米', '2019-12-21 21:48:24', '3e2566aa-af89-4904-ab09-81dcddd91a9f');
INSERT INTO `in_warehouse` VALUES ('a4a1a9b4-f1d9-424e-bfad-046289853847', 'jysmdz', '20', 'e8358b12-d2d5-418f-ba3b-648e1f893afd', '测试入库 \n            ', '米', '2019-12-22 22:02:18', '3e2566aa-af89-4904-ab09-81dcddd91a9f');
INSERT INTO `in_warehouse` VALUES ('a98fa10e-070a-4e2a-89b2-cb989e5aaa61', 'kbfd-tmsj-ddjf', '40', '632fb21f-836b-446a-bd94-71c9d7af4cad', '灭火器入库\n', '个', '2019-12-21 21:43:56', '3e2566aa-af89-4904-ab09-81dcddd91a9f');
INSERT INTO `in_warehouse` VALUES ('fd6d3553-024b-41e9-9ca3-7c086a1e8d7a', 'jysmdz', '200', 'e99c1db7-d123-40fe-a36c-1e7b3aeb6d50', '测试消防水管入库\n            ', '米', '2019-12-31 23:41:58', '3e2566aa-af89-4904-ab09-81dcddd91a9f');

-- ----------------------------
-- Table structure for login_info
-- ----------------------------
DROP TABLE IF EXISTS `login_info`;
CREATE TABLE `login_info` (
  `id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `loginName` varchar(100) DEFAULT NULL,
  `password` varchar(50) DEFAULT NULL,
  `loginTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `regTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `ip` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `loginName` (`loginName`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of login_info
-- ----------------------------
INSERT INTO `login_info` VALUES ('057764c3-48da-4fb7-a51c-895897ff2e38', 'eqr', '123', '2019-11-06 14:37:45', '2019-11-06 14:37:45', '0:0:0:0:0:0:0:1');
INSERT INTO `login_info` VALUES ('1', 'admin', 'WdmqQhWQFcx4jFc6fqi7nw==', '2020-05-18 22:27:13', '2019-10-14 23:35:22', '0:0:0:0:0:0:0:1');
INSERT INTO `login_info` VALUES ('125b1cad-5090-4134-8d2c-eb2eb6c784d7', 'lxg', '123', '2019-10-29 10:29:31', '2019-10-29 10:29:31', null);
INSERT INTO `login_info` VALUES ('15f1e929-35f4-4211-90d2-86964c61d4ea', null, '123', '2019-11-10 00:11:09', '2019-11-10 00:11:09', '0:0:0:0:0:0:0:1');
INSERT INTO `login_info` VALUES ('1a187ba0-fef6-47fe-be4b-b2b5a09a21a2', null, '123', '2019-11-10 00:13:01', '2019-11-10 00:13:01', '0:0:0:0:0:0:0:1');
INSERT INTO `login_info` VALUES ('2c5cc335-e7a8-4c1e-9c1c-ad5cd50a73a5', 'testa', '123', '2019-11-07 20:33:32', '2019-11-07 20:33:32', '0:0:0:0:0:0:0:1');
INSERT INTO `login_info` VALUES ('34750c43-195d-44c8-9ca9-abeaf4c58d63', null, '123', '2019-11-10 00:11:33', '2019-11-10 00:11:33', '0:0:0:0:0:0:0:1');
INSERT INTO `login_info` VALUES ('3c1b1b19-a805-45b1-88c9-958a017258c9', '徐梦茹', '123', '2020-04-04 22:24:55', '2020-04-04 22:24:55', '0:0:0:0:0:0:0:1');
INSERT INTO `login_info` VALUES ('3c29b8d7-b011-4ba3-9ec6-7c5ef647a3ac', 'aswen', 'gkLcSow6A79SoTz7AFDAmQ==', '2019-12-08 20:17:53', '2019-12-08 20:17:53', '0:0:0:0:0:0:0:1');
INSERT INTO `login_info` VALUES ('3f089865-b619-4cef-ae5d-13dbc99f4087', 'lingxia', 'j/Y5NuWiLVRWfdOCTnNgxQ==', '2019-12-08 20:38:21', '2019-12-08 20:38:21', '0:0:0:0:0:0:0:1');
INSERT INTO `login_info` VALUES ('4394cb56-4667-43df-9132-f3dc67c4e648', null, '123', '2019-11-10 00:11:34', '2019-11-10 00:11:34', '0:0:0:0:0:0:0:1');
INSERT INTO `login_info` VALUES ('4e9ff6ec-c9bc-462f-8f20-1a4e8cf0456b', null, '123', '2019-11-10 00:11:32', '2019-11-10 00:11:32', '0:0:0:0:0:0:0:1');
INSERT INTO `login_info` VALUES ('52b7a21f-37a3-4041-ae0e-abf61ae0b4d7', 'eeeee', '123', '2019-11-06 15:11:32', '2019-11-06 15:11:32', '0:0:0:0:0:0:0:1');
INSERT INTO `login_info` VALUES ('58348f9b-3968-4a67-af1c-d39cd1fd057e', 'ty', '123', '2019-12-08 20:14:23', '2019-12-08 20:14:23', '0:0:0:0:0:0:0:1');
INSERT INTO `login_info` VALUES ('663e6b1b-f798-4175-86e1-c8f71a9d3d37', 'ccc', '123', '2019-11-10 00:15:35', '2019-11-10 00:15:35', '0:0:0:0:0:0:0:1');
INSERT INTO `login_info` VALUES ('7cb148a8-6929-459a-aee4-def8a044a8f8', null, '123', '2019-11-10 00:11:33', '2019-11-10 00:11:33', '0:0:0:0:0:0:0:1');
INSERT INTO `login_info` VALUES ('7d92e4be-a979-494d-b790-72d7cd497b50', 'lixiu', '123', '2019-10-31 14:37:33', '2019-10-30 10:14:57', '0:0:0:0:0:0:0:1');
INSERT INTO `login_info` VALUES ('9118704a-00c1-4780-99e4-85bfad78ea61', 'lixiao', '123', '2019-11-06 14:39:54', '2019-11-06 14:39:54', '0:0:0:0:0:0:0:1');
INSERT INTO `login_info` VALUES ('96c72ae6-e2e1-4b44-beb5-cb4c5ce5eab4', null, '123', '2019-11-10 00:11:33', '2019-11-10 00:11:33', '0:0:0:0:0:0:0:1');
INSERT INTO `login_info` VALUES ('9e75346f-a52c-4ed7-bd7b-f7fbedb3d44c', null, '123', '2019-11-10 00:11:33', '2019-11-10 00:11:33', '0:0:0:0:0:0:0:1');
INSERT INTO `login_info` VALUES ('ae5e1d8d-1e70-4554-832b-1f76a4c0bbc5', null, '123', '2019-11-10 00:11:34', '2019-11-10 00:11:34', '0:0:0:0:0:0:0:1');
INSERT INTO `login_info` VALUES ('af2b7312-bab0-4b5f-b2e5-fb57a6ad7793', 'bbbb', '123', '2019-11-06 15:04:01', '2019-11-06 15:04:01', '0:0:0:0:0:0:0:1');
INSERT INTO `login_info` VALUES ('c883d008-4bdf-4176-ae9c-5a4d9885d23a', 'q1', '123', '2019-11-09 16:22:20', '2019-11-09 16:22:20', '0:0:0:0:0:0:0:1');
INSERT INTO `login_info` VALUES ('cc0c820c-8bcb-470c-b811-9feaa6db6c37', 'zeyu', '123', '2019-11-09 16:31:11', '2019-11-09 16:31:11', '0:0:0:0:0:0:0:1');
INSERT INTO `login_info` VALUES ('e34cce93-c2a1-46a0-bd09-7f967b2136ed', 'qqq', '123', '2019-12-08 16:19:17', '2019-12-08 16:19:17', '0:0:0:0:0:0:0:1');
INSERT INTO `login_info` VALUES ('e5409f3c-e7ff-4ec5-a6a3-2d03f3a1976d', 'eee', '123', '2019-11-06 15:08:42', '2019-11-06 15:08:42', '0:0:0:0:0:0:0:1');
INSERT INTO `login_info` VALUES ('ece17555-4d9a-484a-8614-5ced51dd5b44', 'aaa', '123', '2019-11-06 15:03:15', '2019-11-06 15:03:15', '0:0:0:0:0:0:0:1');
INSERT INTO `login_info` VALUES ('ee2c5d2c-2b3e-4410-9797-d7e13b29c0fa', 'ly', '123', '2019-12-08 20:15:09', '2019-12-08 20:15:09', '0:0:0:0:0:0:0:1');

-- ----------------------------
-- Table structure for maintain_details
-- ----------------------------
DROP TABLE IF EXISTS `maintain_details`;
CREATE TABLE `maintain_details` (
  `id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `maintainId` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `marId` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `num` int(11) DEFAULT NULL,
  `description` varchar(100) DEFAULT NULL,
  `mainTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `uId` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of maintain_details
-- ----------------------------
INSERT INTO `maintain_details` VALUES ('56cd8dd0-3810-48e3-bf59-5df35aff0542', '55639d3f-82b2-487a-b2c9-9083eeed1874', 'kbfd-tmsj-ddjf', '20', '灭火器设备维护', '2019-12-26 00:00:00', '1');
INSERT INTO `maintain_details` VALUES ('a87525a8-33e1-4c41-9520-9395c6939f46', '55639d3f-82b2-487a-b2c9-9083eeed1874', 'hjfsah', '100', '水管维护', '2019-12-25 00:00:00', '1');

-- ----------------------------
-- Table structure for maintain_plan
-- ----------------------------
DROP TABLE IF EXISTS `maintain_plan`;
CREATE TABLE `maintain_plan` (
  `id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `name` varchar(100) DEFAULT NULL,
  `startTime` varchar(100) DEFAULT NULL,
  `endTime` varchar(100) DEFAULT NULL,
  `state` int(1) DEFAULT '1',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of maintain_plan
-- ----------------------------
INSERT INTO `maintain_plan` VALUES ('55639d3f-82b2-487a-b2c9-9083eeed1874', '维护设备的计划aa', '2019-12-03', '2019-12-25', '1');

-- ----------------------------
-- Table structure for materielinfo
-- ----------------------------
DROP TABLE IF EXISTS `materielinfo`;
CREATE TABLE `materielinfo` (
  `id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `materielName` varchar(50) DEFAULT NULL,
  `marType` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `description` varchar(100) DEFAULT NULL,
  `specs` varchar(100) DEFAULT NULL,
  `specsType` varchar(100) DEFAULT NULL,
  `icons` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `unit` varchar(100) DEFAULT NULL,
  `numbers` int(8) NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of materielinfo
-- ----------------------------
INSERT INTO `materielinfo` VALUES ('91bdbf00-6636-4f44-83e4-a1141044700d', '资金', '资金', '资金', '元', '1', null, '元', '99');
INSERT INTO `materielinfo` VALUES ('ba7a96c7-340a-4cdc-adaa-712012995fea', '测试复杂物料数据', '化学品类', '测试的复杂物料信息数据', '没有简单规格', '2', 'a', '个', '99');
INSERT INTO `materielinfo` VALUES ('fgjgldai', '打印纸张', '纸张类', '打印用的纸张', 'A4 21.0*29.7（厘米）', '1', 'i', '张', '9');
INSERT INTO `materielinfo` VALUES ('hjfsah', '消防水管', '水管类', '消防水管', 'DN25(1寸)', '1', 'g', '米', '7');
INSERT INTO `materielinfo` VALUES ('ijkmwsztgv', '打印纸张', '纸张类', '打印用的纸张', 'A2 42.0*59.4（厘米）', '1', 'l', '张', '12');
INSERT INTO `materielinfo` VALUES ('jysmdz', '消防水管', '水管类', '消防水管', 'DN32(1寸半)', '1', 'h', '米', '8');
INSERT INTO `materielinfo` VALUES ('kbfd-tmsj-ddjf', '卤代烷型灭火器', '灭火器材类', '卤代烷型的灭火器', '卤代烷型', '1', 'd', '个', '4');
INSERT INTO `materielinfo` VALUES ('liutyetyuig', '打印纸张', '纸张类', '打印用的纸张', ' A0 84*118.9（厘米）', '1', 'j', '张', '10');
INSERT INTO `materielinfo` VALUES ('qwefdfj', '消防水管', '水管类', '消防水管', 'DN16(4分)', '1', 'f', '米', '6');
INSERT INTO `materielinfo` VALUES ('qwer-ngfy-dcpm', '泡沫灭火器', '灭火器材类', '泡沫类型灭火器', '泡沫型', '1', 'c', '个', '3');
INSERT INTO `materielinfo` VALUES ('snihfdsjhfv', '水型灭火器', '灭火器材类', '最常规的灭火方法使用的灭火器', '水型', '1', 'e', '个', '5');
INSERT INTO `materielinfo` VALUES ('vbdf-asdj-xsdn', '二氧化碳灭火器', '灭火器材类', '二氧化碳类型的灭火器，适用于各种场景', '二氧化碳类', '1', 'a', '个', '1');
INSERT INTO `materielinfo` VALUES ('wdbnfgu', '打印纸张', '纸张类', '打印用的纸张', 'A3 29.7*42.0（厘米）', '1', 'm', '张', '13');
INSERT INTO `materielinfo` VALUES ('yhcbdru', '打印纸张', '纸张类', '打印用的纸张', 'A1 59.4*84.1（厘米）', '1', 'k', '张', '11');

-- ----------------------------
-- Table structure for materiel_and_unit
-- ----------------------------
DROP TABLE IF EXISTS `materiel_and_unit`;
CREATE TABLE `materiel_and_unit` (
  `id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `marId` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `unitId` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `numbers` int(8) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`numbers`,`id`)
) ENGINE=InnoDB AUTO_INCREMENT=14 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of materiel_and_unit
-- ----------------------------
INSERT INTO `materiel_and_unit` VALUES ('3a31912a-b500-4c1e-b17f-1c6ff9b8ca49', 'ba7a96c7-340a-4cdc-adaa-712012995fea', '1', '8');
INSERT INTO `materiel_and_unit` VALUES ('ef558b02-dda8-4c92-a390-298238fea774', 'ba7a96c7-340a-4cdc-adaa-712012995fea', 'dfsgi', '9');
INSERT INTO `materiel_and_unit` VALUES ('33f0a2a8-87ec-45fe-9c4a-9e9392124bea', 'ba7a96c7-340a-4cdc-adaa-712012995fea', 'fdhg', '10');
INSERT INTO `materiel_and_unit` VALUES ('5a9c1f6b-da3a-44eb-b0ba-6a4811e498f0', 'c1927084-9d3d-45b1-81ae-7c61a69f64c8', 'dfsgi', '11');
INSERT INTO `materiel_and_unit` VALUES ('b71c6a6b-2c84-45d5-bc86-a80304d63be3', 'c1927084-9d3d-45b1-81ae-7c61a69f64c8', 'dsafas', '12');
INSERT INTO `materiel_and_unit` VALUES ('4ee4a7ee-d505-4151-b251-f807809c8ddb', 'c1927084-9d3d-45b1-81ae-7c61a69f64c8', 'fdhg', '13');

-- ----------------------------
-- Table structure for materiel_type
-- ----------------------------
DROP TABLE IF EXISTS `materiel_type`;
CREATE TABLE `materiel_type` (
  `id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `materielName` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `descrip` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `top` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `icon` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT '',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of materiel_type
-- ----------------------------
INSERT INTO `materiel_type` VALUES ('257fbddd-3b2d-40f0-82e4-5509f6b71cff', '监控探头类', '探头', 'gfhj', '');
INSERT INTO `materiel_type` VALUES ('a6d62d18-f3e8-496f-8638-6e261fa0dab5', '水管类', '消防用的水管', '-1', '');
INSERT INTO `materiel_type` VALUES ('b4e4c1ba-3a19-4a9b-ae32-86ebd14eec28', '资金', '资金', '-1', null);
INSERT INTO `materiel_type` VALUES ('ce26ebc7-cd47-44b6-b329-865e87807ee9', '测试物料类型', '测试物料', 'asdf', '');
INSERT INTO `materiel_type` VALUES ('doin', '打印机类', '办公打印机', 'gfhj', '');
INSERT INTO `materiel_type` VALUES ('eghs', '纸张类', '办公所用纸张', '-1', '');
INSERT INTO `materiel_type` VALUES ('gfhj', '电子设备类', '工作所需要的电子设备', '-1', ' ');
INSERT INTO `materiel_type` VALUES ('gsagr', '烟雾报警器类', '烟雾报警器', 'gfhj', ' ');
INSERT INTO `materiel_type` VALUES ('iosdjffs-svfgasfg-fba', '劳保类', ' ', '-1', ' ');
INSERT INTO `materiel_type` VALUES ('nmfdm-5gf3-h5qd1', '设备类', ' ', '-1', ' ');
INSERT INTO `materiel_type` VALUES ('qwer-sdfg-436x', '化学品类', ' ', '-1', ' ');
INSERT INTO `materiel_type` VALUES ('rdfgfv-gfzDsa-sfdg', '商品类', ' ', '-1', ' ');
INSERT INTO `materiel_type` VALUES ('trey-nfdk-dgje', '灭火器材', '消防用品', '-1', ' ');
INSERT INTO `materiel_type` VALUES ('ujytre-sdfghfjg-cvfd', '原材料类', ' ', '-1', '  ');

-- ----------------------------
-- Table structure for materiel_unit
-- ----------------------------
DROP TABLE IF EXISTS `materiel_unit`;
CREATE TABLE `materiel_unit` (
  `id` varchar(50) NOT NULL,
  `name` varchar(50) DEFAULT NULL,
  `content` varchar(50) DEFAULT NULL,
  `del` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of materiel_unit
-- ----------------------------
INSERT INTO `materiel_unit` VALUES ('1', '颜色', '黄色', '1');
INSERT INTO `materiel_unit` VALUES ('2', '颜色', '绿色', '1');
INSERT INTO `materiel_unit` VALUES ('3', '颜色', '黄绿色', '1');
INSERT INTO `materiel_unit` VALUES ('300b477a-1c4d-4450-9d08-4e60ddb4fdba', '纸张规格', 'aaaaaaaaa', '-1');
INSERT INTO `materiel_unit` VALUES ('4', '颜色', '七彩色', '1');
INSERT INTO `materiel_unit` VALUES ('5', '大小', '比手指甲小', '1');
INSERT INTO `materiel_unit` VALUES ('6', '大小', '1平方分米', '1');
INSERT INTO `materiel_unit` VALUES ('7', '大小', '1*10平方分米', '1');
INSERT INTO `materiel_unit` VALUES ('asdf', '水管尺寸', 'DN16(4分)', '1');
INSERT INTO `materiel_unit` VALUES ('bepond', '纸张规格', 'A4 21.0*29.7（厘米）', '1');
INSERT INTO `materiel_unit` VALUES ('d0e1b99c-bf19-4ec0-982f-c2e6a52a7775', '测试规格2', '测试数据2', '-1');
INSERT INTO `materiel_unit` VALUES ('dfsgi', '灭火器型号', '泡沫型', '1');
INSERT INTO `materiel_unit` VALUES ('dsafas', '灭火器型号', '卤代烷型', '1');
INSERT INTO `materiel_unit` VALUES ('fdhg', '灭火器型号', '二氧化碳类', '1');
INSERT INTO `materiel_unit` VALUES ('fdhgfa', '纸张规格', ' A0 84*118.9（厘米）', '1');
INSERT INTO `materiel_unit` VALUES ('gdhjsz', '纸张规格', 'A1 59.4*84.1（厘米）', '1');
INSERT INTO `materiel_unit` VALUES ('kfhi', '灭火器型号', '干粉类', '1');
INSERT INTO `materiel_unit` VALUES ('sdefa', '水管尺寸', 'DN25(1寸)', '1');
INSERT INTO `materiel_unit` VALUES ('sdffsdww', '水管尺寸', 'DN32(1寸半)', '1');
INSERT INTO `materiel_unit` VALUES ('sfdgbkhjl', '纸张规格', 'A2 42.0*59.4（厘米）', '1');
INSERT INTO `materiel_unit` VALUES ('vfdm', '灭火器型号', '水型', '1');
INSERT INTO `materiel_unit` VALUES ('wfgas', '水管尺寸', 'DN20(6分)', '1');
INSERT INTO `materiel_unit` VALUES ('xbvd', '纸张规格', 'A3 29.7*42.0（厘米）', '-1');

-- ----------------------------
-- Table structure for out_warehouse
-- ----------------------------
DROP TABLE IF EXISTS `out_warehouse`;
CREATE TABLE `out_warehouse` (
  `id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `marId` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `num` int(11) DEFAULT NULL,
  `outVoucher` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `outUnit` varchar(50) DEFAULT NULL,
  `outTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `outObject` varchar(50) DEFAULT NULL,
  `wareId` varchar(100) DEFAULT NULL,
  `outDesc` varchar(255) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of out_warehouse
-- ----------------------------
INSERT INTO `out_warehouse` VALUES ('a8553c56-8e1a-426d-b3a8-5c8ebc5f2464', 'fgjgldai', '6000', '586c1b72-e4b9-4e50-8038-ec888c301657', '张', '2019-12-31 23:55:18', '张三山', 'd889be59-6d1a-4894-bb24-3bb821be0507', '测试数据3');
INSERT INTO `out_warehouse` VALUES ('d6162afe-1678-4299-9cbd-67a05a54d76f', 'fgjgldai', '20', '8d3bf5c2-522d-4335-bd89-3191e9f92f46', '张', '2019-12-31 22:54:44', '张三山', 'd889be59-6d1a-4894-bb24-3bb821be0507', '测试出库数据2');
INSERT INTO `out_warehouse` VALUES ('ef4313c2-27c4-4055-a25a-ad50df2627df', 'fgjgldai', '1000', '4b614301-274c-487a-af47-4f4597a2629c', '张', '2019-12-31 23:05:31', '张三山', 'd889be59-6d1a-4894-bb24-3bb821be0507', '办公用纸领用');

-- ----------------------------
-- Table structure for permission
-- ----------------------------
DROP TABLE IF EXISTS `permission`;
CREATE TABLE `permission` (
  `id` int(8) NOT NULL AUTO_INCREMENT,
  `pername` varchar(50) DEFAULT NULL,
  `path` varchar(100) DEFAULT NULL,
  `pertype` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `top` varchar(8) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=43 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of permission
-- ----------------------------
INSERT INTO `permission` VALUES ('1', '用户管理', '  1', '1', '-1');
INSERT INTO `permission` VALUES ('2', '系统管理', ' 1', '1', '-1');
INSERT INTO `permission` VALUES ('3', '用户信息管理', 'main/admin/userinfoPage', '2', '1');
INSERT INTO `permission` VALUES ('4', '部门信息管理', 'main/admin/departmentPage', '2', '1');
INSERT INTO `permission` VALUES ('5', '权限管理', 'main/admin/permissionPage', '2', '2');
INSERT INTO `permission` VALUES ('6', '权限绑定', 'main/admin/bingPermission', '2', '2');
INSERT INTO `permission` VALUES ('14', '文件上传', 'main/admin/uploadPage', '2', '2');
INSERT INTO `permission` VALUES ('17', '物料管理', ' 1', '1', '-1');
INSERT INTO `permission` VALUES ('18', '规格管理', ' 1', '1', '-1');
INSERT INTO `permission` VALUES ('19', '规格信息管理', 'main/admin/materielUnit', '2', '18');
INSERT INTO `permission` VALUES ('20', '物料信息管理', 'main/admin/materielInfo', '2', '17');
INSERT INTO `permission` VALUES ('21', '物料类型管理', 'main/admin/materielType', '2', '17');
INSERT INTO `permission` VALUES ('22', '采购计划维护', ' 1', '1', '-1');
INSERT INTO `permission` VALUES ('23', '采购计划管理', 'main/admin/buyPlanManage', '2', '22');
INSERT INTO `permission` VALUES ('24', '采购与供应商管理', ' 1', '1', '-1');
INSERT INTO `permission` VALUES ('25', '供应商管理', 'main/admin/supplierManagePage', '2', '24');
INSERT INTO `permission` VALUES ('26', '采购订单维护', 'main/admin/buyOrderManagePage', '2', '24');
INSERT INTO `permission` VALUES ('29', '仓库库存管理', '1', '1', '-1');
INSERT INTO `permission` VALUES ('30', '仓库管理', 'main/admin/wareHouseManagePage', '2', '29');
INSERT INTO `permission` VALUES ('31', '库存管理', 'main/admin/stockManagePage', '2', '29');
INSERT INTO `permission` VALUES ('32', '出入库管理', ' 1', '1', '-1');
INSERT INTO `permission` VALUES ('33', '入库管理', 'main/admin/queryNotAddOrder', '2', '32');
INSERT INTO `permission` VALUES ('35', '入库记录查询', 'main/admin/inHouseQuery', '2', '32');
INSERT INTO `permission` VALUES ('36', '出库管理', 'main/admin/outHousePage', '2', '32');
INSERT INTO `permission` VALUES ('37', '出库记录查询', 'main/admin/outHouseQuery', '2', '32');
INSERT INTO `permission` VALUES ('38', '不允许访问页', 'main/admin/notAccess', '2', '2');
INSERT INTO `permission` VALUES ('39', '领用与设备维护', ' 1', '1', '-1');
INSERT INTO `permission` VALUES ('40', '设备维护信息管理', 'main/admin/maintainManage', '2', '39');
INSERT INTO `permission` VALUES ('41', '领用信息维护', 'main/admin/receiveInfoMaintain', '2', '39');
INSERT INTO `permission` VALUES ('42', '领用审核', 'main/admin/receiveCheck', '2', '39');

-- ----------------------------
-- Table structure for per_relationship
-- ----------------------------
DROP TABLE IF EXISTS `per_relationship`;
CREATE TABLE `per_relationship` (
  `id` int(8) NOT NULL AUTO_INCREMENT,
  `did` varchar(100) DEFAULT NULL,
  `pid` varchar(100) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=58 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of per_relationship
-- ----------------------------
INSERT INTO `per_relationship` VALUES ('1', '1', '1');
INSERT INTO `per_relationship` VALUES ('2', '1', '2');
INSERT INTO `per_relationship` VALUES ('3', '1', '3');
INSERT INTO `per_relationship` VALUES ('4', '1', '4');
INSERT INTO `per_relationship` VALUES ('5', '1', '5');
INSERT INTO `per_relationship` VALUES ('6', '1', '6');
INSERT INTO `per_relationship` VALUES ('7', '1', '7');
INSERT INTO `per_relationship` VALUES ('13', '13', '7');
INSERT INTO `per_relationship` VALUES ('14', '13', '4');
INSERT INTO `per_relationship` VALUES ('15', '13', '5');
INSERT INTO `per_relationship` VALUES ('17', '13', '1');
INSERT INTO `per_relationship` VALUES ('18', '13', '2');
INSERT INTO `per_relationship` VALUES ('19', '13', '3');
INSERT INTO `per_relationship` VALUES ('20', '1', '14');
INSERT INTO `per_relationship` VALUES ('21', '13', '6');
INSERT INTO `per_relationship` VALUES ('24', '1', '17');
INSERT INTO `per_relationship` VALUES ('25', '1', '18');
INSERT INTO `per_relationship` VALUES ('26', '1', '19');
INSERT INTO `per_relationship` VALUES ('27', '1', '20');
INSERT INTO `per_relationship` VALUES ('28', '1', '21');
INSERT INTO `per_relationship` VALUES ('29', '2', '1');
INSERT INTO `per_relationship` VALUES ('30', '2', '3');
INSERT INTO `per_relationship` VALUES ('31', '2', '4');
INSERT INTO `per_relationship` VALUES ('32', '1', '22');
INSERT INTO `per_relationship` VALUES ('35', '1', '23');
INSERT INTO `per_relationship` VALUES ('36', '1', '24');
INSERT INTO `per_relationship` VALUES ('37', '1', '25');
INSERT INTO `per_relationship` VALUES ('38', '1', '26');
INSERT INTO `per_relationship` VALUES ('39', '1', '27');
INSERT INTO `per_relationship` VALUES ('40', '1', '28');
INSERT INTO `per_relationship` VALUES ('43', '1', '29');
INSERT INTO `per_relationship` VALUES ('44', '1', '30');
INSERT INTO `per_relationship` VALUES ('45', '1', '31');
INSERT INTO `per_relationship` VALUES ('46', '1', '32');
INSERT INTO `per_relationship` VALUES ('47', '1', '33');
INSERT INTO `per_relationship` VALUES ('48', '1', '34');
INSERT INTO `per_relationship` VALUES ('49', '1', '35');
INSERT INTO `per_relationship` VALUES ('50', '1', '36');
INSERT INTO `per_relationship` VALUES ('51', '1', '37');
INSERT INTO `per_relationship` VALUES ('52', '1', '38');
INSERT INTO `per_relationship` VALUES ('53', '13', '14');
INSERT INTO `per_relationship` VALUES ('54', '1', '39');
INSERT INTO `per_relationship` VALUES ('55', '1', '40');
INSERT INTO `per_relationship` VALUES ('56', '1', '41');
INSERT INTO `per_relationship` VALUES ('57', '1', '42');

-- ----------------------------
-- Table structure for receive
-- ----------------------------
DROP TABLE IF EXISTS `receive`;
CREATE TABLE `receive` (
  `id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `applyId` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `checkState` varchar(50) DEFAULT NULL,
  `checkId` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `receiveState` int(1) DEFAULT NULL,
  `reason` varchar(100) DEFAULT NULL,
  `applyTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `checkTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of receive
-- ----------------------------
INSERT INTO `receive` VALUES ('0ff1cc3f-4e79-4f23-a8fb-1fb2e28fcdd8', '0e7a275f-9192-40ee-a914-b58ec660c8af', '2', '-1', '2', '测试数据3 办公用纸', '2019-12-31 23:04:47', '2019-12-31 23:04:47');
INSERT INTO `receive` VALUES ('1fab1a04-7f29-44f3-a82f-fb478d2421d3', '9822d27f-c5c3-46c0-ad95-80cf5e77c920', '2', '-1', '1', '数据测试', '2019-12-31 23:46:01', '2019-12-31 23:46:01');
INSERT INTO `receive` VALUES ('3a3cefdd-9d85-40e5-9d6d-62da69419092', '1', '1', '-1', '1', '灭火器消耗', '2019-12-25 08:39:39', '2019-12-25 08:39:39');
INSERT INTO `receive` VALUES ('59fb82dc-5a46-4c7a-9527-58b112c00cac', '7', '2', '-1', '2', '测试可以通过的出库的数据', '2019-12-31 20:16:12', '2019-12-31 20:16:12');
INSERT INTO `receive` VALUES ('6718972a-78a7-4418-865d-57935016bb9b', '3', '2', '-1', '1', '数据测试', '2019-12-31 20:03:19', '2019-12-31 20:03:19');
INSERT INTO `receive` VALUES ('8762fa58-3a79-44e8-88d4-b9ca6aef6818', '9bc2bb05-e82c-4c70-af85-38e6cb746fdc', '2', '-1', '2', '超过数量的数据测试', '2019-12-31 20:10:00', '2019-12-31 20:10:00');
INSERT INTO `receive` VALUES ('asvbfas', '1', '2', '-1', '1', '灭火器失效', '2019-12-24 23:37:04', '2019-12-24 23:37:04');
INSERT INTO `receive` VALUES ('b1b47e93-f942-4d73-a203-26c3b590535f', '6', '3', '-1', '1', '测试数据', '2019-12-31 20:06:20', '2019-12-31 20:06:20');
INSERT INTO `receive` VALUES ('df7ca90c-ca79-4ae3-b54a-9335925b60b5', '6', '2', '-1', '1', '仓库库中不存在的物料数据测试', '2019-12-31 20:13:12', '2019-12-31 20:13:12');

-- ----------------------------
-- Table structure for stock
-- ----------------------------
DROP TABLE IF EXISTS `stock`;
CREATE TABLE `stock` (
  `id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `wareId` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `marId` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `changeFormula` varchar(100) DEFAULT NULL,
  `unit` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `num` int(11) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of stock
-- ----------------------------
INSERT INTO `stock` VALUES ('07041ad2-d14b-428e-98e0-548ebce95365', '3e2566aa-af89-4904-ab09-81dcddd91a9f', 'kbfd-tmsj-ddjf', '个=个', '个', '40');
INSERT INTO `stock` VALUES ('b2fad876-e158-4947-bd63-72604f46a4a6', '3e2566aa-af89-4904-ab09-81dcddd91a9f', 'jysmdz', '米=米', '米', '320');
INSERT INTO `stock` VALUES ('b8c32253-1297-4650-bed3-bb6bb47ff373', 'd889be59-6d1a-4894-bb24-3bb821be0507', 'fgjgldai', '张=张', '张', '880');
INSERT INTO `stock` VALUES ('ea90ed71-b938-401c-9425-d288f08e8c71', '3e2566aa-af89-4904-ab09-81dcddd91a9f', 'qwer-ngfy-dcpm', '米=个', '个', '100');

-- ----------------------------
-- Table structure for supplier
-- ----------------------------
DROP TABLE IF EXISTS `supplier`;
CREATE TABLE `supplier` (
  `id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `area` varchar(50) DEFAULT NULL,
  `contacter` varchar(50) DEFAULT NULL,
  `phone` varchar(50) DEFAULT NULL,
  `money` double DEFAULT NULL,
  `numbers` int(11) DEFAULT NULL,
  `description` varchar(100) DEFAULT NULL,
  `quality` varchar(50) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of supplier
-- ----------------------------
INSERT INTO `supplier` VALUES ('1', '消防水管供应商', '四川成都', '刘泽宇', '13730724461', '500000', '1', '位于四川省的消防水管供应商', 'B');
INSERT INTO `supplier` VALUES ('2', '消防灭火器供应商', '四川绵阳', '李霞', '15282415651', '300000', '2', '主要负责各种类型的灭火器的提供', 'B');
INSERT INTO `supplier` VALUES ('3', '办公用纸供应商', '山东大连', '张洪', '18228515671', '200000', '3', '各种办公用纸供应', 'C');
INSERT INTO `supplier` VALUES ('4', '劳保用品供应商', '四川成都', '杨秀', '15828479359', '200000', '4', '劳保用品供应', 'C');
INSERT INTO `supplier` VALUES ('476c83bf-c6b7-42b5-abd3-64351003fb71', '设备类供应商', '浙江金华', '何雪娇', '18328249757', '3000000', '6', '各类大型消防设备供应商', 'A');
INSERT INTO `supplier` VALUES ('5', '化学品供应商', '河南郑州', '陈晓君', '13730724467', '700000', '5', '各种化学品的供应', 'A');
INSERT INTO `supplier` VALUES ('cd3bc9ed-c3c4-40cb-aa9e-c4ef3394aea0', '打印机供应商', '广州深圳', '李向东', '15881585926', '300000', '7', '打印机供应', 'B');

-- ----------------------------
-- Table structure for userinfo
-- ----------------------------
DROP TABLE IF EXISTS `userinfo`;
CREATE TABLE `userinfo` (
  `id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `username` varchar(50) DEFAULT NULL,
  `sex` int(1) DEFAULT NULL,
  `email` varchar(50) DEFAULT NULL,
  `loginId` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_bin DEFAULT NULL,
  `dId` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL,
  `numbers` int(6) NOT NULL AUTO_INCREMENT,
  `telephone` varchar(50) DEFAULT NULL,
  `head` varchar(255) DEFAULT '',
  PRIMARY KEY (`numbers`,`id`)
) ENGINE=InnoDB AUTO_INCREMENT=35 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of userinfo
-- ----------------------------
INSERT INTO `userinfo` VALUES ('1', '张三山', '1', 'zhangsan@qq.com', '1', '1', '1', '15882415632', '');
INSERT INTO `userinfo` VALUES ('2', '李四', '1', 'lisi@qq.com', '2', '5', '2', '17352415632', '');
INSERT INTO `userinfo` VALUES ('3', '秀云', '2', 'xiuyun@qq.com', '3', '3', '3', '18315882415', '');
INSERT INTO `userinfo` VALUES ('4', '成语花', '2', 'cheng@qq.com', '-1', '1', '4', '13915173415', '');
INSERT INTO `userinfo` VALUES ('5', '鞠萍', '2', 'ping@qq.com', '5', '1', '5', '15932355632', '');
INSERT INTO `userinfo` VALUES ('6', '张白水', '1', 'baishui@qq.com', '6', '1', '6', '18228444192', '');
INSERT INTO `userinfo` VALUES ('7', '林珏', '2', 'linyu@qq.com', '7', '2', '7', '17428445631', '');
INSERT INTO `userinfo` VALUES ('8', '王海波', '1', 'haibo@qq.com', '8', '2', '8', '18228441922', '');
INSERT INTO `userinfo` VALUES ('9', '刘青山', '1', 'qingshan@qq.com', '-1', '2', '9', '17356243361', '');
INSERT INTO `userinfo` VALUES ('b0f25cf7-dd98-4978-85ec-8b2fcd189c46', '张骏杨', '1', 'ada@qq.com', '-1', '2', '10', '17381585927', '');
INSERT INTO `userinfo` VALUES ('6d2684d7-3beb-49c3-8868-c5aeb49817d8', '刘晓干', '1', 'liuxiaogan@qq.com', '125b1cad-5090-4134-8d2c-eb2eb6c784d7', '7', '15', '17352415641', '');
INSERT INTO `userinfo` VALUES ('7ebb2356-3d99-4f13-8a29-6360d8ccd2ad', '李秀极', '1', 'lixiu@qq.com', '7d92e4be-a979-494d-b790-72d7cd497b50', '13', '18', '15882513251', '');
INSERT INTO `userinfo` VALUES ('9bf361b7-8d44-4d63-b22b-0c8cee909445', '秦晓', '1', 'qinxiao@qq.com', '057764c3-48da-4fb7-a51c-895897ff2e38', '1', '19', '15828439257', '');
INSERT INTO `userinfo` VALUES ('a0fe94e1-1bab-4fc6-adf5-32011ee70981', '李笑', '1', 'lixiao@qq.com', '-1', '1', '20', '17352415721', '');
INSERT INTO `userinfo` VALUES ('09a4db20-3392-49b2-989f-57996c0145f0', 'aaaa', '2', 'aaa@qq.com', '-1', '1', '21', '15882411234', '');
INSERT INTO `userinfo` VALUES ('b685d3b2-c1fa-4ef3-ab87-24896157dbb5', 'bbbb', '2', 'bbbb@qq.com', '-1', '1', '22', '18228441234', '');
INSERT INTO `userinfo` VALUES ('2e5cdf57-c93c-4ab9-83b8-c9d67e2f0c95', 'eee', '2', 'eee@qq.com', '-1', '13', '23', '17381581253', '');
INSERT INTO `userinfo` VALUES ('6cd56f5a-6775-493f-83f1-c404b14ca97b', 'eeeee', '2', 'eeeeee@qq.com', '-1', '1', '24', '15845678921', '');
INSERT INTO `userinfo` VALUES ('cdf0af79-5592-4c31-96c3-871464891bd2', '测试用户', '2', 'testyh@qq.com', '-1', '21', '25', '18228441234', '');
INSERT INTO `userinfo` VALUES ('603f45cb-70ca-4931-9ec5-eeb668f8175a', '测试的用户', '2', 'q1@qq.com', '-1', '2', '26', '15882417456', '');
INSERT INTO `userinfo` VALUES ('93752d36-246b-46be-9f5b-40a169ae1825', '城择宇', '1', 'chengzeyu@qq.com', 'cc0c820c-8bcb-470c-b811-9feaa6db6c37', '1', '27', '18228441923', '');
INSERT INTO `userinfo` VALUES ('e04a2c6f-a0dd-454c-ae2a-3f8272cb16c3', 'ccc', '2', 'ccc@qq.com', '-1', '20', '28', '17381585241', '');
INSERT INTO `userinfo` VALUES ('9822d27f-c5c3-46c0-ad95-80cf5e77c920', 'qqq', '2', 'qqq@qq.com', 'e34cce93-c2a1-46a0-bd09-7f967b2136ed', '4', '29', '15881585241', '');
INSERT INTO `userinfo` VALUES ('9bc2bb05-e82c-4c70-af85-38e6cb746fdc', '李欣泽', '2', 'lisi@qq.com', '58348f9b-3968-4a67-af1c-d39cd1fd057e', '13', '30', '15281585241', '');
INSERT INTO `userinfo` VALUES ('0e7a275f-9192-40ee-a914-b58ec660c8af', '刘勇', '2', 'ly@qq.com', 'ee2c5d2c-2b3e-4410-9797-d7e13b29c0fa', '13', '31', '15883585241', '');
INSERT INTO `userinfo` VALUES ('4c4bfcc7-90cb-4d4d-bc1c-7a48dcc6ca17', '刘文玉', '2', 'aswenyu@qq.com', '3c29b8d7-b011-4ba3-9ec6-7c5ef647a3ac', '19e71737-a0d7-4b39-94d3-453bea73dd11', '32', '15681585241', '');
INSERT INTO `userinfo` VALUES ('7b52ebba-0bba-4e3d-8fb7-1ed8a0be7647', '凌霞', '2', 'lingxia@qq.com', '3f089865-b619-4cef-ae5d-13dbc99f4087', '13', '33', '15681585247', '');
INSERT INTO `userinfo` VALUES ('879d6d63-b033-47ef-b4b5-701b5e37e2a7', '徐梦茹', '2', 'mengru@qq.com', '3c1b1b19-a805-45b1-88c9-958a017258c9', '2', '34', '15882415632', '');

-- ----------------------------
-- Table structure for warehouses
-- ----------------------------
DROP TABLE IF EXISTS `warehouses`;
CREATE TABLE `warehouses` (
  `id` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,
  `warehouseName` varchar(50) DEFAULT NULL,
  `warehousePosition` varchar(50) DEFAULT NULL,
  `putType` varchar(50) DEFAULT NULL,
  `createTime` timestamp NULL DEFAULT CURRENT_TIMESTAMP,
  `numbers` int(11) NOT NULL AUTO_INCREMENT,
  PRIMARY KEY (`numbers`,`id`)
) ENGINE=InnoDB AUTO_INCREMENT=100 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of warehouses
-- ----------------------------
INSERT INTO `warehouses` VALUES ('aeb3c125-1ecb-43ee-a924-ee65776968a7', '1号仓库', 'A区一幢', '化学品类', '2019-12-19 23:21:38', '1');
INSERT INTO `warehouses` VALUES ('181aed69-55a3-48e1-a933-951f33b7d0f8', '2号仓库', 'A区二幢', '劳保类', '2019-12-19 23:21:48', '2');
INSERT INTO `warehouses` VALUES ('3e2566aa-af89-4904-ab09-81dcddd91a9f', '3号仓库', 'B区一幢', '消防灭火器类', '2019-12-19 23:21:57', '3');
INSERT INTO `warehouses` VALUES ('d889be59-6d1a-4894-bb24-3bb821be0507', '4号仓库', 'A区三幢', '办公类', '2019-12-19 23:22:16', '6');
INSERT INTO `warehouses` VALUES ('22bc5dab-80d3-4fdd-8f78-6c58e359c280', '5号仓库', 'B区二幢', '电子设备', '2019-12-19 23:22:25', '99');