/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 50734
 Source Host           : localhost:3306
 Source Schema         : ams

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

 Date: 13/11/2021 00:34:11
*/
DROP DATABASE IF EXISTS `ams`;
CREATE DATABASE `ams` ;
USE `ams` ;


SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for asset_borrow_return
-- ----------------------------


DROP TABLE IF EXISTS `asset_borrow_return`;
CREATE TABLE `asset_borrow_return`  (
  `asset_borrow_return_id` int(11) NOT NULL AUTO_INCREMENT,
  `asset_id` int(11) NOT NULL,
  `borrow_date` date NULL DEFAULT NULL,
  `department_id` int(11) NOT NULL,
  `borrow_info` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `return_date` date NULL DEFAULT NULL,
  `state` int(11) NOT NULL DEFAULT 1,
  PRIMARY KEY (`asset_borrow_return_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1008 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of asset_borrow_return
-- ----------------------------
INSERT INTO `asset_borrow_return` VALUES (1001, 1001, '2020-10-27', 1, '借用', '2020-11-09', 3);
INSERT INTO `asset_borrow_return` VALUES (1004, 1004, '2020-10-28', 8, '新员工入职', '2020-10-28', 0);
INSERT INTO `asset_borrow_return` VALUES (1005, 1002, '2020-10-28', 9, '开会', '2020-11-05', 0);
INSERT INTO `asset_borrow_return` VALUES (1006, 1003, '2020-11-27', 8, '借用', '2021-04-06', 0);
INSERT INTO `asset_borrow_return` VALUES (1007, 1003, '2021-04-06', 1, '111', NULL, 1);

-- ----------------------------
-- Table structure for asset_storage
-- ----------------------------
DROP TABLE IF EXISTS `asset_storage`;
CREATE TABLE `asset_storage`  (
  `asset_id` int(11) NOT NULL AUTO_INCREMENT,
  `asset_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `asset_type_id` int(11) NOT NULL,
  `supplier_id` int(11) NOT NULL,
  `brand_id` int(11) NOT NULL,
  `in_bound_date` datetime NULL DEFAULT CURRENT_TIMESTAMP,
  `storage_location_id` int(11) NOT NULL,
  PRIMARY KEY (`asset_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1006 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of asset_storage
-- ----------------------------
INSERT INTO `asset_storage` VALUES (1001, '电脑', 1008, 1002, 1007, '2020-10-22 16:15:25', 1001);
INSERT INTO `asset_storage` VALUES (1002, '资产111', 1001, 1003, 1006, '2020-10-23 17:04:40', 1002);
INSERT INTO `asset_storage` VALUES (1003, '资产1112', 1001, 1002, 1007, '2020-10-26 23:22:26', 1001);
INSERT INTO `asset_storage` VALUES (1004, '0', 1002, 1002, 1007, '2020-10-27 14:06:50', 1001);
INSERT INTO `asset_storage` VALUES (1005, '213213', 1002, 1003, 1006, '2020-11-27 09:41:10', 1001);

-- ----------------------------
-- Table structure for asset_type
-- ----------------------------
DROP TABLE IF EXISTS `asset_type`;
CREATE TABLE `asset_type`  (
  `asset_type_id` int(11) NOT NULL AUTO_INCREMENT,
  `asset_type_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `state` int(11) NULL DEFAULT 0,
  `create_date` datetime NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`asset_type_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1335 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of asset_type
-- ----------------------------
INSERT INTO `asset_type` VALUES (1001, '资产类型1111', 1, '2020-10-22 15:18:22');
INSERT INTO `asset_type` VALUES (1002, '资产类型2', 1, '2020-10-22 15:18:22');
INSERT INTO `asset_type` VALUES (1008, '笔记本电脑', 1, '2020-10-22 15:18:22');
INSERT INTO `asset_type` VALUES (1010, '6', 0, '2020-11-09 11:11:49');
INSERT INTO `asset_type` VALUES (1011, '资产类别31', 0, '2020-11-18 10:07:41');
INSERT INTO `asset_type` VALUES (1012, '资产类别3', 0, '2020-11-18 10:13:31');
INSERT INTO `asset_type` VALUES (1226, 'ZCYL24修改', 0, '2020-12-25 10:55:52');
INSERT INTO `asset_type` VALUES (1227, 'ZCLZ2', 0, '2020-12-25 10:55:52');
INSERT INTO `asset_type` VALUES (1228, 'ZCLZ3', 0, '2020-12-25 10:55:52');
INSERT INTO `asset_type` VALUES (1229, 'ZCHF1', 0, '2020-12-25 10:55:52');
INSERT INTO `asset_type` VALUES (1230, 'ZCHF2', 0, '2020-12-25 10:55:52');
INSERT INTO `asset_type` VALUES (1231, 'ZCHF3', 0, '2020-12-25 10:55:52');
INSERT INTO `asset_type` VALUES (1282, 'ZCYL1', 0, '2020-12-25 10:58:10');
INSERT INTO `asset_type` VALUES (1283, 'ZCYL2a', 0, '2020-12-25 10:58:10');
INSERT INTO `asset_type` VALUES (1284, 'ZCYL3修改', 0, '2020-12-25 10:58:10');
INSERT INTO `asset_type` VALUES (1285, 'ZCYL4jjjj', 0, '2020-12-25 10:58:10');
INSERT INTO `asset_type` VALUES (1286, 'ZCYL15', 0, '2020-12-25 10:58:10');
INSERT INTO `asset_type` VALUES (1287, 'ZCYL6', 0, '2020-12-25 10:58:10');
INSERT INTO `asset_type` VALUES (1288, 'ZCYL7', 0, '2020-12-25 10:58:10');
INSERT INTO `asset_type` VALUES (1289, 'ZCYL8', 0, '2020-12-25 10:58:10');
INSERT INTO `asset_type` VALUES (1290, 'ZCYL9', 0, '2020-12-25 10:58:10');
INSERT INTO `asset_type` VALUES (1291, 'ZCYL10', 0, '2020-12-25 10:58:10');
INSERT INTO `asset_type` VALUES (1292, 'ZCYL11', 0, '2020-12-25 10:58:10');
INSERT INTO `asset_type` VALUES (1293, 'ZCYL12', 0, '2020-12-25 10:58:10');
INSERT INTO `asset_type` VALUES (1294, 'ZCYL13', 0, '2020-12-25 10:58:10');
INSERT INTO `asset_type` VALUES (1295, 'ZCYL14', 0, '2020-12-25 10:58:10');
INSERT INTO `asset_type` VALUES (1296, 'ZCYL15', 0, '2020-12-25 10:58:10');
INSERT INTO `asset_type` VALUES (1297, 'ZCYL16', 0, '2020-12-25 10:58:10');
INSERT INTO `asset_type` VALUES (1298, 'ZCYL17', 0, '2020-12-25 10:58:10');
INSERT INTO `asset_type` VALUES (1299, 'ZCYL18', 0, '2020-12-25 10:58:10');
INSERT INTO `asset_type` VALUES (1300, 'ZCYL19', 0, '2020-12-25 10:58:10');
INSERT INTO `asset_type` VALUES (1301, 'ZCYL20', 0, '2020-12-25 10:58:10');
INSERT INTO `asset_type` VALUES (1302, 'ZCYL21', 0, '2020-12-25 10:58:10');
INSERT INTO `asset_type` VALUES (1303, 'ZCYL22', 0, '2020-12-25 10:58:10');
INSERT INTO `asset_type` VALUES (1304, 'ZCYL23', 0, '2020-12-25 10:58:10');
INSERT INTO `asset_type` VALUES (1305, 'ZCYL24', 0, '2020-12-25 10:58:10');
INSERT INTO `asset_type` VALUES (1306, 'ZCYL25', 0, '2020-12-25 10:58:11');
INSERT INTO `asset_type` VALUES (1307, 'ZCYL26', 0, '2020-12-25 10:58:11');
INSERT INTO `asset_type` VALUES (1308, 'ZCYL27', 0, '2020-12-25 10:58:11');
INSERT INTO `asset_type` VALUES (1309, 'ZCYL28', 0, '2020-12-25 10:58:11');
INSERT INTO `asset_type` VALUES (1310, 'ZCYL29', 0, '2020-12-25 10:58:11');
INSERT INTO `asset_type` VALUES (1311, 'ZCYL30', 0, '2020-12-25 10:58:11');
INSERT INTO `asset_type` VALUES (1312, 'ZCYL31', 0, '2020-12-25 10:58:11');
INSERT INTO `asset_type` VALUES (1313, 'ZCYL32', 0, '2020-12-25 10:58:11');
INSERT INTO `asset_type` VALUES (1314, 'ZCYL33', 0, '2020-12-25 10:58:11');
INSERT INTO `asset_type` VALUES (1315, 'ZCYL34', 0, '2020-12-25 10:58:11');
INSERT INTO `asset_type` VALUES (1316, 'ZCYL35', 0, '2020-12-25 10:58:11');
INSERT INTO `asset_type` VALUES (1317, 'ZCYL36', 0, '2020-12-25 10:58:11');
INSERT INTO `asset_type` VALUES (1318, 'ZCYL37', 0, '2020-12-25 10:58:11');
INSERT INTO `asset_type` VALUES (1319, 'ZCYL38', 0, '2020-12-25 10:58:11');
INSERT INTO `asset_type` VALUES (1320, 'ZCYL39', 0, '2020-12-25 10:58:11');
INSERT INTO `asset_type` VALUES (1321, 'ZCYL40', 0, '2020-12-25 10:58:11');
INSERT INTO `asset_type` VALUES (1322, 'ZCYL41', 0, '2020-12-25 10:58:11');
INSERT INTO `asset_type` VALUES (1323, 'ZCYL42', 0, '2020-12-25 10:58:11');
INSERT INTO `asset_type` VALUES (1324, 'ZCYL43', 0, '2020-12-25 10:58:11');
INSERT INTO `asset_type` VALUES (1325, 'ZCYL44', 0, '2020-12-25 10:58:11');
INSERT INTO `asset_type` VALUES (1326, 'ZCYL45', 0, '2020-12-25 10:58:11');
INSERT INTO `asset_type` VALUES (1327, 'ZCYL46', 0, '2020-12-25 10:58:11');
INSERT INTO `asset_type` VALUES (1328, 'ZCYL47', 0, '2020-12-25 10:58:11');
INSERT INTO `asset_type` VALUES (1330, 'ZCYL49', 0, '2020-12-25 10:58:11');
INSERT INTO `asset_type` VALUES (1331, 'ZCYL50', 0, '2020-12-25 10:58:11');
INSERT INTO `asset_type` VALUES (1333, 'ZCBF01', 0, '2020-12-25 16:14:59');
INSERT INTO `asset_type` VALUES (1334, 'KKKK01', 1, '2020-12-25 16:18:01');

-- ----------------------------
-- Table structure for brand
-- ----------------------------
DROP TABLE IF EXISTS `brand`;
CREATE TABLE `brand`  (
  `brand_id` int(11) NOT NULL AUTO_INCREMENT,
  `brand_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `state` int(11) NULL DEFAULT 0,
  `create_date` datetime NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`brand_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1012 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of brand
-- ----------------------------
INSERT INTO `brand` VALUES (1006, '耐克1', 1, '2020-10-22 15:18:42');
INSERT INTO `brand` VALUES (1007, '耐克', 1, '2020-10-22 15:18:42');
INSERT INTO `brand` VALUES (1009, '耐克2', 1, '2020-10-22 15:18:42');
INSERT INTO `brand` VALUES (1011, '华硕', 0, '2020-10-27 16:29:58');

-- ----------------------------
-- Table structure for department
-- ----------------------------
DROP TABLE IF EXISTS `department`;
CREATE TABLE `department`  (
  `department_id` int(11) NOT NULL AUTO_INCREMENT,
  `department_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `department_address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `create_date` datetime NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`department_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 10 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of department
-- ----------------------------
INSERT INTO `department` VALUES (1, '资产管理部门', '郴州市苏仙区xxx', '2020-10-22 09:04:40');
INSERT INTO `department` VALUES (8, '部门2', '湖南郴州', '2020-10-23 12:08:36');
INSERT INTO `department` VALUES (9, '15', 'eee', '2020-10-26 19:29:46');

-- ----------------------------
-- Table structure for scrap
-- ----------------------------
DROP TABLE IF EXISTS `scrap`;
CREATE TABLE `scrap`  (
  `scrap_id` int(11) NOT NULL AUTO_INCREMENT,
  `scrap_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `state` int(11) NULL DEFAULT 0,
  `create_date` datetime NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`scrap_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1005 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of scrap
-- ----------------------------
INSERT INTO `scrap` VALUES (1003, '报废方式1', 1, '2020-11-26 15:22:36');
INSERT INTO `scrap` VALUES (1004, '报废方式2', 1, '2020-11-26 15:22:44');

-- ----------------------------
-- Table structure for storage_location
-- ----------------------------
DROP TABLE IF EXISTS `storage_location`;
CREATE TABLE `storage_location`  (
  `sl_id` int(11) NOT NULL AUTO_INCREMENT,
  `sl_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `sl_type` varchar(25) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `state` int(11) NULL DEFAULT 0,
  `sl_info` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `create_date` datetime NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`sl_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1003 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of storage_location
-- ----------------------------
INSERT INTO `storage_location` VALUES (1001, '电脑耗材库', '耗材物品', 1, 'xxx', '2020-10-21 09:07:41');
INSERT INTO `storage_location` VALUES (1002, '会计办公室', '固定资产', 1, 'xxxx', '2020-10-21 23:28:55');

-- ----------------------------
-- Table structure for supplier
-- ----------------------------
DROP TABLE IF EXISTS `supplier`;
CREATE TABLE `supplier`  (
  `supplier_id` int(11) NOT NULL AUTO_INCREMENT,
  `supplier_name` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `supplier_type` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `state` int(11) NULL DEFAULT 0,
  `linkman` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `phone` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `create_date` datetime NULL DEFAULT CURRENT_TIMESTAMP,
  PRIMARY KEY (`supplier_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 1005 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of supplier
-- ----------------------------
INSERT INTO `supplier` VALUES (1002, '李四有限公司', '供应商', 1, '李四', '2321321312', '广东广州', '2020-10-15 15:54:44');
INSERT INTO `supplier` VALUES (1003, '张三有限公司', '代理商', 1, '李四', '213213123', '湖南郴州', '2020-10-15 16:29:27');
INSERT INTO `supplier` VALUES (1004, '李四公司3', '代理商1', 1, '李四', '123', '广东广州', '2020-10-22 00:48:26');

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user`  (
  `user_id` int(11) NOT NULL AUTO_INCREMENT,
  `user_name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `pass_word` varchar(64) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
  `name` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `phone` varchar(12) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
  `sex` int(11) NULL DEFAULT NULL,
  `department_id` int(11) NULL DEFAULT NULL,
  `position_data` int(11) NOT NULL,
  `perms` text CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL,
  PRIMARY KEY (`user_id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES (1, 'zhangsan', '9bad41710724cf6511abde2a52416881', '张三', '12323213213', 1, 1, 2, 'user:all,assettype:disable,assettype:add,assettype:update,brand:disable,brand:add,brand:update,scrap:disable,scrap:add,scrap:update,department:add,department:update,assetStorage:add,assetStorage:update');
INSERT INTO `user` VALUES (2, 'lisi', '1b539b60601b934441308049a9526e7d', '李四', '12345678901', 0, 1, 1, 'user:all,assettype:disable,assettype:add,assettype:delete,assettype:update,brand:disable,brand:add,brand:delete,brand:update,scrap:disable,scrap:add,scrap:delete,scrap:update,supplier:disable,supplier:add,supplier:delete,supplier:update,supplier:operation,storageLocation:operation,storageLocation:add,storageLocation:update,storageLocation:delete,storageLocation:disable,department:delete,department:add,department:update,assetStorage:add,assetStorage:update,assetStorage:delete');

SET FOREIGN_KEY_CHECKS = 1;