master

分支 (1)

管理

管理

master

carshopsys
/
carshopsys.sql

/*
 Navicat MySQL Data Transfer

 Source Server         : localhost_3306
 Source Server Type    : MySQL
 Source Server Version : 50562
 Source Host           : localhost:3306
 Source Schema         : carshopsys

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

 Date: 21/02/2022 19:47:11
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for admin
-- ----------------------------
DROP TABLE IF EXISTS `admin`;
CREATE TABLE `admin`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '自增id',
  `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '管理员账号',
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '管理员密码',
  `create_time` datetime NOT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 7 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of admin
-- ----------------------------
INSERT INTO `admin` VALUES (1, 'admin', 'admin', '2021-01-28 00:00:00');
INSERT INTO `admin` VALUES (2, 'boss', '123456', '2021-10-28 19:41:14');
INSERT INTO `admin` VALUES (3, 'hr', '123456', '2021-10-14 20:06:29');
INSERT INTO `admin` VALUES (4, 'manager', '123456', '2021-10-22 20:08:46');
INSERT INTO `admin` VALUES (5, 'db', '132456', '2021-09-29 20:10:10');
INSERT INTO `admin` VALUES (6, 'sell', '123456', '2021-10-01 20:11:03');

-- ----------------------------
-- Table structure for afterorder
-- ----------------------------
DROP TABLE IF EXISTS `afterorder`;
CREATE TABLE `afterorder`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '自增id',
  `afterordernum` bigint(255) NOT NULL COMMENT '订单号',
  `carno` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '车牌号',
  `carid` bigint(255) NOT NULL COMMENT '汽车id',
  `service` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '服务',
  `price` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '价钱',
  `empid` bigint(20) NOT NULL COMMENT '负责员工',
  `state` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '状态',
  `create_time` date NOT NULL COMMENT '创建时间',
  `update_time` date NOT NULL COMMENT '更新时间',
  `afterremarks` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 8 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of afterorder
-- ----------------------------
INSERT INTO `afterorder` VALUES (1, 2021120916126, '粤S367520', 1, '洗车服务', '50', 6, '已支付', '2021-12-24', '2021-12-26', '不用洗座椅');
INSERT INTO `afterorder` VALUES (3, 20211210410123, '粤A22Q15', 4, '补漆', '599', 10, '已支付', '2021-12-10', '2021-12-10', '无');
INSERT INTO `afterorder` VALUES (5, 202112101810123, '粤B12R56', 18, '换挡风玻璃', '499', 10, '已支付', '2021-12-10', '2021-12-10', '活动减100');
INSERT INTO `afterorder` VALUES (6, 20211226264114, '粤B2T20Y', 26, '换挡风玻璃', '16000', 4, '已支付', '2021-12-26', '2021-12-26', '无');
INSERT INTO `afterorder` VALUES (7, 20211226334147, '粤A25V1E', 33, '换轮胎', '13500', 4, '已支付', '2021-12-26', '2021-12-26', '无');

-- ----------------------------
-- Table structure for carorder
-- ----------------------------
DROP TABLE IF EXISTS `carorder`;
CREATE TABLE `carorder`  (
  `id` bigint(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `ordernum` bigint(11) NOT NULL COMMENT '订单编号',
  `carid` bigint(11) NOT NULL COMMENT '汽车编号',
  `empid` bigint(11) NOT NULL COMMENT '员工编号',
  `custid` bigint(255) NOT NULL COMMENT '客户编号',
  `quantity` bigint(11) NOT NULL COMMENT '数量',
  `create_time` date NOT NULL COMMENT '创建时间',
  `update_time` date NOT NULL COMMENT '更新时间',
  `state` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '支付情况',
  `remarks` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 34 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of carorder
-- ----------------------------
INSERT INTO `carorder` VALUES (1, 20211121311125, 3, 1, 1, 1, '2021-11-21', '2021-11-21', '已支付', '无');
INSERT INTO `carorder` VALUES (2, 20211125533125, 5, 3, 3, 1, '2021-11-25', '2021-11-25', '未支付', '已预定');
INSERT INTO `carorder` VALUES (3, 20211124716136, 7, 1, 6, 2, '2021-11-24', '2021-11-24', '已取消', '订单写错');
INSERT INTO `carorder` VALUES (4, 20210806433158, 4, 3, 3, 1, '2021-08-06', '2021-11-25', '未支付', '无');
INSERT INTO `carorder` VALUES (5, 20211125612815, 6, 1, 2, 1, '2021-11-25', '2021-11-25', '已支付', '无');
INSERT INTO `carorder` VALUES (6, 20211112115236, 1, 1, 5, 1, '2021-11-12', '2021-11-17', '已取消', '无');
INSERT INTO `carorder` VALUES (18, 20211201636200, 6, 3, 6, 1, '2021-12-01', '2021-12-01', '已取消', '活动减100');
INSERT INTO `carorder` VALUES (19, 202112011232437, 12, 3, 2, 2, '2021-12-01', '2021-12-01', '未支付', '付定金了');
INSERT INTO `carorder` VALUES (22, 2021120291183, 9, 1, 1, 2, '2021-12-02', '2021-12-02', '已支付', '无');
INSERT INTO `carorder` VALUES (23, 202112051106302, 1, 10, 6, 1, '2021-12-05', '2021-12-05', '已支付', '无');
INSERT INTO `carorder` VALUES (24, 2021120521010552, 2, 10, 10, 2, '2021-12-05', '2021-12-05', '已支付', '无');
INSERT INTO `carorder` VALUES (25, 20211214101215661, 10, 12, 15, 2, '2021-12-14', '2021-12-14', '已支付', '无');
INSERT INTO `carorder` VALUES (26, 202112161103315, 1, 10, 3, 2, '2021-12-16', '2021-12-26', '已支付', '无');
INSERT INTO `carorder` VALUES (27, 20211216144536, 1, 4, 4, 1, '2021-12-16', '2021-12-27', '未支付', '无');
INSERT INTO `carorder` VALUES (28, 20211216345507, 3, 4, 5, 1, '2021-12-16', '2021-12-16', '已支付', '无');
INSERT INTO `carorder` VALUES (29, 20211216141121966, 14, 11, 21, 2, '2021-12-16', '2021-12-16', '已支付', '无');
INSERT INTO `carorder` VALUES (30, 2021121681216815, 8, 12, 16, 1, '2021-12-16', '2021-12-16', '已支付', '无');
INSERT INTO `carorder` VALUES (31, 202112165414336, 5, 4, 14, 1, '2021-12-16', '2021-12-16', '已支付', '无');
INSERT INTO `carorder` VALUES (32, 20211216121210636, 12, 12, 10, 3, '2021-12-16', '2021-12-16', '已支付', '无');
INSERT INTO `carorder` VALUES (33, 2021122621114140, 2, 11, 14, 1, '2021-12-26', '2021-12-26', '未支付', '无');

-- ----------------------------
-- Table structure for carstock
-- ----------------------------
DROP TABLE IF EXISTS `carstock`;
CREATE TABLE `carstock`  (
  `id` bigint(11) NOT NULL AUTO_INCREMENT COMMENT '唯一id',
  `brand` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '汽车品牌',
  `carname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '汽车型号',
  `price` bigint(20) NOT NULL COMMENT '价格',
  `color` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '颜色',
  `type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '挡位类型',
  `quantity` bigint(255) NOT NULL COMMENT '数量',
  `configuration` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '配置',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 15 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of carstock
-- ----------------------------
INSERT INTO `carstock` VALUES (1, '广汽本田', '雅阁 ', 200000, '蓝色', '自动挡', 47, '2022款 260TURBO 豪华版');
INSERT INTO `carstock` VALUES (2, '广汽本田', '思域', 153500, '白色', '手动挡', 15, '2022款 180TURBO CVT尚动版');
INSERT INTO `carstock` VALUES (3, '比亚迪', '秦 ', 90000, '白色', '自动挡', 32, '2021款 出行版');
INSERT INTO `carstock` VALUES (4, '一汽丰田', 'C-RV', 195000, '黑色', '自动挡', 22, '2021款 240TURBO CVT两驱黑爵士版');
INSERT INTO `carstock` VALUES (5, '广汽传祺', '影豹', 125000, '黄色', '自动挡', 49, '2021款 270T 影豹J11版');
INSERT INTO `carstock` VALUES (6, '长城哈弗', 'h6', 98000, '白色', '自动挡', 25, '2021款 第三代 1.5GDIT 自动Plus版');
INSERT INTO `carstock` VALUES (7, '东风日产', '轩逸', 110000, '灰色', '自动挡', 122, '2022款 e-POWER 全电驱Pro');
INSERT INTO `carstock` VALUES (8, '五宏菱光', 'mini', 3000, '蓝色', '自动挡', 151, '2021款 马卡龙臻享款 磷酸铁锂');
INSERT INTO `carstock` VALUES (9, '特斯拉', 'model3', 200000, '黑色', '自动挡', 1, '2021款 Performance高性能全轮驱动版 3D3/3D6');
INSERT INTO `carstock` VALUES (10, '华晨宝马', '宝马3系', 420000, '白色', '自动挡', 60, '2022款 325i M运动套装');
INSERT INTO `carstock` VALUES (11, '广汽本田', '飞度', 85300, '墨绿色', '手动挡', 16, '2021款 1.5L CVT潮享版');
INSERT INTO `carstock` VALUES (12, '上海大众', '辉腾', 13500, '黑色', '自动挡', 23, '2015款 3.0L 专享版');
INSERT INTO `carstock` VALUES (14, '广汽奥迪', 'A6', 230000, '黑色', '自动挡', 24, '2022款 40 TFSI 豪华动感型');

-- ----------------------------
-- Table structure for custmer
-- ----------------------------
DROP TABLE IF EXISTS `custmer`;
CREATE TABLE `custmer`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '客户唯一id',
  `cust_name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '客户名字',
  `sex` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '客户性别',
  `job` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '工作',
  `telphone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '电话',
  `address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '地址',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 25 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of custmer
-- ----------------------------
INSERT INTO `custmer` VALUES (1, '王思聪', '男', '房地产经理', '18024731206', '广东广州');
INSERT INTO `custmer` VALUES (2, '马化腾', '男', '程序员', '13360685412', '广东深圳');
INSERT INTO `custmer` VALUES (3, '李华', '男', '老师', '15625734123', '广东东莞');
INSERT INTO `custmer` VALUES (4, '钟小红', '女', '公务员', '13245231578', '湖南长沙');
INSERT INTO `custmer` VALUES (5, '张小明', '男', '售货员', '13684123545', '广西桂林');
INSERT INTO `custmer` VALUES (6, '王小华', '男', '滴滴司机', '13687412542', '广东东莞');
INSERT INTO `custmer` VALUES (10, '叶雯', '女', '经理', '18024731258', '广东深圳');
INSERT INTO `custmer` VALUES (14, '朱员焕', '男', '收银员', '13713168112', '广东清远');
INSERT INTO `custmer` VALUES (15, '黄关', '男', '待业', '13360684125', '广东云浮');
INSERT INTO `custmer` VALUES (16, '谭文杉', '男', '警察', '13713168445', '广东东莞');
INSERT INTO `custmer` VALUES (17, '陈望余', '男', '程序员', '18321265554', '广东佛山');
INSERT INTO `custmer` VALUES (18, '郭凯峰', '男', '司机', '15325236846', '广东东莞');
INSERT INTO `custmer` VALUES (19, '廖明远', '男', '文员', '13685123215', '广东广州');
INSERT INTO `custmer` VALUES (20, '陈小怡', '女', '秘书', '13325284965', '广东深圳');
INSERT INTO `custmer` VALUES (21, '吴哓年', '男', '公务员', '15824756982', '广东广州');
INSERT INTO `custmer` VALUES (22, '梁文龙', '男', '自媒体', '13685412565', '广东深圳');
INSERT INTO `custmer` VALUES (23, '许浩峰', '男', '教师', '18954123658', '广东东莞');
INSERT INTO `custmer` VALUES (24, '王微微', '女', '待业', '13725621225', '广东广州');

-- ----------------------------
-- Table structure for emp
-- ----------------------------
DROP TABLE IF EXISTS `emp`;
CREATE TABLE `emp`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '员工id',
  `empno` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '员工编号',
  `ename` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '员工姓名',
  `sex` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '员工性别',
  `job` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '工作',
  `dname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '部门名称',
  `hiredate` date NOT NULL COMMENT '入职时间',
  `telphone` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '手机号',
  `sal` int(255) NOT NULL COMMENT '工资',
  `state` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '状态',
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL DEFAULT '888888' COMMENT '密码',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 17 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of emp
-- ----------------------------
INSERT INTO `emp` VALUES (1, 'XS2018123', '张建峰', '男', '销售经理', '销售部', '2018-09-01', '13713152946', 8000, '在职', '888888');
INSERT INTO `emp` VALUES (3, 'XS2021412', '陈俊杰', '男', '销售', '销售部', '2021-11-03', '18025431511', 3000, '在职', '888888');
INSERT INTO `emp` VALUES (4, 'WX2020832', '李大铭', '男', '维修经理', '维修部', '2020-11-03', '13713158551', 7500, '在职', '888888');
INSERT INTO `emp` VALUES (5, 'CW2019745', '刘小花', '女', '财务', '财务部', '2019-11-05', '18925541112', 4500, '请假', '888888');
INSERT INTO `emp` VALUES (6, 'WX2017254', '肖焕春', '男', '维修工', '维修部', '2017-06-05', '13603021152', 2500, '在职', '888888');
INSERT INTO `emp` VALUES (7, 'RS2019321', '黄志忠', '男', '人事经理', '人事部', '2019-01-01', '13691151111', 8500, '在职', '888888');
INSERT INTO `emp` VALUES (8, 'RS2014321', '陈国浩', '男', '人事', '人事部', '2021-10-20', '18512365112', 3400, '离职', '888888');
INSERT INTO `emp` VALUES (9, 'CW2021132', '王学君', '男', '财务经理', '财务部', '2021-11-01', '18924732541', 8000, '在职', '888888');
INSERT INTO `emp` VALUES (10, 'XS2020515', '伍皓峰', '男', '销售', '销售部', '2020-05-15', '15252145698', 5630, '在职', '888888');
INSERT INTO `emp` VALUES (11, 'XS2021112', '萧铄', '男', '销售', '销售部', '2021-12-01', '13684251215', 7800, '离职', '888888');
INSERT INTO `emp` VALUES (12, 'XS2021156', '赵彭', '男', '销售', '销售部', '2021-12-01', '13360689654', 3300, '在职', '888888');
INSERT INTO `emp` VALUES (13, 'WX2021452', '黄从逸', '男', '维修工', '维修部', '2021-10-14', '18024731206', 1800, '在职', '888888');
INSERT INTO `emp` VALUES (14, 'CW2021123', '李梅梅', '女', '财务', '财务部', '2021-12-24', '13360684157', 2500, '在职', '888888');
INSERT INTO `emp` VALUES (15, 'XS2021153', '李俊杰', '男', '销售', '销售部', '2021-12-01', '13713154226', 3500, '请假', 'ljj12532');
INSERT INTO `emp` VALUES (16, 'WX2021666', '莫金韬', '男', '维修工', '维修部', '2021-12-05', '18026532154', 3600, '在职', '888888');

-- ----------------------------
-- Table structure for partorder
-- ----------------------------
DROP TABLE IF EXISTS `partorder`;
CREATE TABLE `partorder`  (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `ordernum` bigint(11) NULL DEFAULT NULL COMMENT '订单编号',
  `partid` bigint(20) NULL DEFAULT NULL COMMENT '配件编号',
  `empid` bigint(20) NULL DEFAULT NULL COMMENT '员工编号',
  `custid` int(11) NULL DEFAULT NULL COMMENT '客户编号',
  `quantity` bigint(20) NULL DEFAULT NULL COMMENT '数量',
  `create_time` date NULL DEFAULT NULL COMMENT '创建时间',
  `update_time` date NULL DEFAULT NULL COMMENT '更新时间',
  `state` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '支付情况',
  `remarks` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 11 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of partorder
-- ----------------------------
INSERT INTO `partorder` VALUES (1, 202112061109225, 6, 10, 2, 1, '2021-12-06', '2021-12-06', '已取消', '无');
INSERT INTO `partorder` VALUES (3, 202112075103578, 5, 10, 3, 2, '2021-12-07', '2021-12-26', '已支付', '无');
INSERT INTO `partorder` VALUES (4, 202112079104251, 9, 10, 4, 3, '2021-12-07', '2021-12-07', '已取消', '无');
INSERT INTO `partorder` VALUES (5, 202112072310789, 2, 3, 10, 6, '2021-12-07', '2021-12-07', '已支付', '大单');
INSERT INTO `partorder` VALUES (7, 202112075103187, 5, 10, 3, 2, '2021-12-07', '2021-12-07', '已支付', '无');
INSERT INTO `partorder` VALUES (8, 202112079106928, 9, 10, 6, 3, '2021-12-07', '2021-12-07', '未支付', '');
INSERT INTO `partorder` VALUES (9, 202112265101495, 5, 10, 14, 2, '2021-12-26', '2021-12-26', '已支付', '无');
INSERT INTO `partorder` VALUES (10, 2021122651014199, 5, 10, 14, 1, '2021-12-26', '2021-12-26', '已支付', '无');

-- ----------------------------
-- Table structure for partstock
-- ----------------------------
DROP TABLE IF EXISTS `partstock`;
CREATE TABLE `partstock`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `pname` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '配件名字',
  `quantity` int(255) NOT NULL COMMENT '库存',
  `unit` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '单位',
  `price` double(10, 2) NOT NULL COMMENT '价钱',
  `factory` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '生存厂家',
  `source` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '来源，进口或者国产',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 18 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of partstock
-- ----------------------------
INSERT INTO `partstock` VALUES (1, '轮胎', 50, '条', 3200.00, '菲利浦', '国产');
INSERT INTO `partstock` VALUES (2, '车灯', 94, '台', 1200.00, '丰田', '进口');
INSERT INTO `partstock` VALUES (3, '挡风玻璃', 6, '个', 5680.00, '长城', '国产');
INSERT INTO `partstock` VALUES (4, '红色喷漆', 500, '瓶', 68.99, '奥普特', '国产');
INSERT INTO `partstock` VALUES (5, '车灯', 9, '台', 3000.00, '比亚迪', '国产');
INSERT INTO `partstock` VALUES (6, '玻璃水', 232, '瓶', 30.88, '洁净邦', '国产');
INSERT INTO `partstock` VALUES (7, '安全气囊', 50, '个', 5855.00, '奥迪', '进口');
INSERT INTO `partstock` VALUES (8, '刹车片', 62, '个', 699.00, '传祺', '国产');
INSERT INTO `partstock` VALUES (9, '方向盘', 1, '个', 2552.00, '宝马', '国产');
INSERT INTO `partstock` VALUES (10, '活塞', 622, '个', 505.00, '本田', '进口');
INSERT INTO `partstock` VALUES (11, '仪表盘', 22, '个', 252.00, '表奥瑞', '进口');
INSERT INTO `partstock` VALUES (12, '润滑油', 52, '瓶', 200.00, '速马力', '国产');
INSERT INTO `partstock` VALUES (13, '防冻液', 11, '瓶', 78.99, '捷科', '国产');
INSERT INTO `partstock` VALUES (14, '保险杆', 22, '个', 8555.00, '奔驰', '进口');
INSERT INTO `partstock` VALUES (15, '轮胎', 62, '条', 2082.00, '飞驰', '国产');
INSERT INTO `partstock` VALUES (16, '白色补漆笔', 50, '支', 5.22, '杂牌', '国产');
INSERT INTO `partstock` VALUES (17, '空调', 60, '台', 4899.00, '格力', '国产');

-- ----------------------------
-- Table structure for sys_log
-- ----------------------------
DROP TABLE IF EXISTS `sys_log`;
CREATE TABLE `sys_log`  (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT 'id',
  `username` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用户名',
  `operation` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '描述',
  `time` decimal(10, 0) NULL DEFAULT NULL COMMENT '时间',
  `method` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '调用方法',
  `params` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '参数',
  `ip` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'IP地址',
  `create_time` datetime NULL DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 84 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Compact;

-- ----------------------------
-- Records of sys_log
-- ----------------------------
INSERT INTO `sys_log` VALUES (27, 'admin', '查询汽车库存', 8, 'com.gk.carshopsys.controller.CarController.queryCar()', '  params: {color=, configuration=, hight_price=, carname=, id=, type=, low_price=, brand=}', '127.0.0.1', '2022-01-01 23:01:53');
INSERT INTO `sys_log` VALUES (28, 'admin', '查询配件库存', 19, 'com.gk.carshopsys.controller.PartController.queryPart()', '  params: {factory=, hight_price=, pname=, id=, source=, low_price=}', '127.0.0.1', '2022-01-01 23:01:54');
INSERT INTO `sys_log` VALUES (29, 'admin', '查询汽车订单', 43, 'com.gk.carshopsys.controller.CarOrderController.quryCarOrderList()', '  params: {start_time=, car=, end_time=, emp=, ordernum=, state=, cust=}', '127.0.0.1', '2022-01-01 23:01:55');
INSERT INTO `sys_log` VALUES (30, 'admin', '查询配件订单', 24, 'com.gk.carshopsys.controller.PartOrderController.quryPartOrderList()', '  params: {start_time=, part=, end_time=, emp=, ordernum=, state=, cust=}', '127.0.0.1', '2022-01-01 23:01:56');
INSERT INTO `sys_log` VALUES (31, 'admin', '查询售后订单', 9, 'com.gk.carshopsys.controller.AfterOrderController.quryCarOrderList()', '  params: {start_time=, carno=, service=, afterordernum=, end_time=, emp=, ordernum=, state=}', '127.0.0.1', '2022-01-01 23:01:56');
INSERT INTO `sys_log` VALUES (32, 'admin', '查询员工', 7, 'com.gk.carshopsys.controller.EmpController.findemp()', '  params: {ename=, empno=, dname=, job=, hiredate=}', '127.0.0.1', '2022-01-01 23:01:57');
INSERT INTO `sys_log` VALUES (33, 'admin', '查询管理员', 27, 'com.gk.carshopsys.controller.AdminController.findAdmin()', '  param: {username=, id=null}', '127.0.0.1', '2022-01-01 23:02:01');
INSERT INTO `sys_log` VALUES (34, 'admin', '查询管理员', 111, 'com.gk.carshopsys.controller.AdminController.findAdmin()', '  param: {username=, id=null}', '127.0.0.1', '2022-01-02 22:18:58');
INSERT INTO `sys_log` VALUES (35, 'admin', '查询管理员', 2, 'com.gk.carshopsys.controller.AdminController.findAdmin()', '  param: {username=, id=null}', '127.0.0.1', '2022-01-02 22:21:18');
INSERT INTO `sys_log` VALUES (36, 'admin', '查询管理员', 13, 'com.gk.carshopsys.controller.AdminController.findAdmin()', '  param: {username=, id=null}', '127.0.0.1', '2022-01-02 22:31:13');
INSERT INTO `sys_log` VALUES (37, 'admin', '查询管理员', 20, 'com.gk.carshopsys.controller.AdminController.findAdmin()', '  param: {username=, id=null}', '127.0.0.1', '2022-01-02 22:32:09');
INSERT INTO `sys_log` VALUES (38, 'admin', '查询管理员', 4, 'com.gk.carshopsys.controller.AdminController.findAdmin()', '  param: {username=, id=null}', '127.0.0.1', '2022-01-02 22:33:40');
INSERT INTO `sys_log` VALUES (39, 'admin', '查询管理员', 4, 'com.gk.carshopsys.controller.AdminController.findAdmin()', '  param: {username=, id=null}', '127.0.0.1', '2022-01-02 22:34:59');
INSERT INTO `sys_log` VALUES (40, 'boss', '查询客户', 21, 'com.gk.carshopsys.controller.CustController.findcust()', '  params: {address=, custid=, job=, custname=}', '127.0.0.1', '2022-01-02 22:41:30');
INSERT INTO `sys_log` VALUES (41, 'boss', '查询管理员', 5, 'com.gk.carshopsys.controller.AdminController.findAdmin()', '  param: {username=, id=null}', '127.0.0.1', '2022-01-02 22:41:32');
INSERT INTO `sys_log` VALUES (42, 'XS2018123', '查询汽车库存', 37, 'com.gk.carshopsys.controller.CarController.queryCar()', '  params: {color=, configuration=, hight_price=, carname=, id=, type=, low_price=, brand=}', '127.0.0.1', '2022-01-02 22:41:55');
INSERT INTO `sys_log` VALUES (43, 'XS2018123', '查询配件库存', 11, 'com.gk.carshopsys.controller.PartController.queryPart()', '  params: {factory=, hight_price=, pname=, id=, source=, low_price=}', '127.0.0.1', '2022-01-02 22:41:56');
INSERT INTO `sys_log` VALUES (44, 'XS2018123', '查询汽车订单', 37, 'com.gk.carshopsys.controller.CarOrderController.quryCarOrderList()', '  params: {start_time=, car=, end_time=, emp=, ordernum=, state=, cust=}', '127.0.0.1', '2022-01-02 22:41:57');
INSERT INTO `sys_log` VALUES (45, 'XS2018123', '查询配件订单', 17, 'com.gk.carshopsys.controller.PartOrderController.quryPartOrderList()', '  params: {start_time=, part=, end_time=, emp=, ordernum=, state=, cust=}', '127.0.0.1', '2022-01-02 22:41:58');
INSERT INTO `sys_log` VALUES (46, 'XS2018123', '查询售后订单', 14, 'com.gk.carshopsys.controller.AfterOrderController.quryCarOrderList()', '  params: {start_time=, carno=, service=, afterordernum=, end_time=, emp=, ordernum=, state=}', '127.0.0.1', '2022-01-02 22:41:59');
INSERT INTO `sys_log` VALUES (47, 'admin', '查询管理员', 5, 'com.gk.carshopsys.controller.AdminController.findAdmin()', '  param: {username=, id=null}', '127.0.0.1', '2022-01-02 22:42:58');
INSERT INTO `sys_log` VALUES (48, 'admin', '查询员工', 3, 'com.gk.carshopsys.controller.EmpController.findemp()', '  params: {ename=, empno=, dname=, job=, hiredate=}', '127.0.0.1', '2022-01-02 22:47:37');
INSERT INTO `sys_log` VALUES (49, 'admin', '查询员工', 13, 'com.gk.carshopsys.controller.EmpController.findemp()', '  params: {ename=, empno=, dname=, job=, hiredate=}', '127.0.0.1', '2022-01-02 23:00:16');
INSERT INTO `sys_log` VALUES (50, 'admin', '查询客户', 5, 'com.gk.carshopsys.controller.CustController.findcust()', '  params: {address=, custid=, job=, custname=}', '127.0.0.1', '2022-01-02 23:00:41');
INSERT INTO `sys_log` VALUES (51, 'admin', '查询客户', 2, 'com.gk.carshopsys.controller.CustController.findcust()', '  params: {address=, custid=0, job=, custname=}', '127.0.0.1', '2022-01-02 23:00:51');
INSERT INTO `sys_log` VALUES (52, 'admin', '查询客户', 11, 'com.gk.carshopsys.controller.CustController.findcust()', '  params: {address=, custid=, job=, custname=理}', '127.0.0.1', '2022-01-02 23:01:01');
INSERT INTO `sys_log` VALUES (53, 'admin', '导出客户', 1927, 'com.gk.carshopsys.controller.CustController.excelexport()', '  response: com.alibaba.druid.support.http.WebStatFilter$StatHttpServletResponseWrapper@1fb61a5f', '127.0.0.1', '2022-01-02 23:01:05');
INSERT INTO `sys_log` VALUES (54, 'admin', '查询汽车库存', 3, 'com.gk.carshopsys.controller.CarController.queryCar()', '  params: {color=, configuration=, hight_price=, carname=, id=, type=, low_price=, brand=}', '127.0.0.1', '2022-01-02 23:01:13');
INSERT INTO `sys_log` VALUES (55, 'admin', '查询汽车库存', 18, 'com.gk.carshopsys.controller.CarController.queryCar()', '  params: {color=, configuration=, hight_price=, carname=, id=, type=, low_price=200000000000000, brand=}', '127.0.0.1', '2022-01-02 23:01:19');
INSERT INTO `sys_log` VALUES (56, 'admin', '导出汽车库存', 72, 'com.gk.carshopsys.controller.CarController.excelexport()', '  response: com.alibaba.druid.support.http.WebStatFilter$StatHttpServletResponseWrapper@595773b0', '127.0.0.1', '2022-01-02 23:01:20');
INSERT INTO `sys_log` VALUES (57, 'admin', '查询配件库存', 5, 'com.gk.carshopsys.controller.PartController.queryPart()', '  params: {factory=, hight_price=, pname=, id=, source=, low_price=}', '127.0.0.1', '2022-01-02 23:01:23');
INSERT INTO `sys_log` VALUES (58, 'admin', '查询配件库存', 2, 'com.gk.carshopsys.controller.PartController.queryPart()', '  params: {factory=, hight_price=, pname=, id=, source=, low_price=222222222222222222222222}', '127.0.0.1', '2022-01-02 23:01:28');
INSERT INTO `sys_log` VALUES (59, 'admin', '导出配件库存', 2, 'com.gk.carshopsys.controller.PartController.excelexport()', '  response: com.alibaba.druid.support.http.WebStatFilter$StatHttpServletResponseWrapper@77339e33', '127.0.0.1', '2022-01-02 23:01:29');
INSERT INTO `sys_log` VALUES (60, 'admin', '导出配件库存', 1, 'com.gk.carshopsys.controller.PartController.excelexport()', '  response: com.alibaba.druid.support.http.WebStatFilter$StatHttpServletResponseWrapper@4f413897', '127.0.0.1', '2022-01-02 23:03:03');
INSERT INTO `sys_log` VALUES (61, 'admin', '查询配件库存', 2, 'com.gk.carshopsys.controller.PartController.queryPart()', '  params: {factory=, hight_price=, pname=, id=, source=, low_price=}', '127.0.0.1', '2022-01-02 23:03:11');
INSERT INTO `sys_log` VALUES (62, 'admin', '查询配件库存', 11, 'com.gk.carshopsys.controller.PartController.queryPart()', '  params: {factory=, hight_price=, pname=, id=, source=国产, low_price=}', '127.0.0.1', '2022-01-02 23:03:15');
INSERT INTO `sys_log` VALUES (63, 'admin', '查询配件库存', 2, 'com.gk.carshopsys.controller.PartController.queryPart()', '  params: {factory=, hight_price=, pname=, id=, source=进口, low_price=}', '127.0.0.1', '2022-01-02 23:03:17');
INSERT INTO `sys_log` VALUES (64, 'admin', '查询配件库存', 2, 'com.gk.carshopsys.controller.PartController.queryPart()', '  params: {factory=, hight_price=, pname=, id=2, source=进口, low_price=}', '127.0.0.1', '2022-01-02 23:03:19');
INSERT INTO `sys_log` VALUES (65, 'admin', '导出配件库存', 314, 'com.gk.carshopsys.controller.PartController.excelexport()', '  response: com.alibaba.druid.support.http.WebStatFilter$StatHttpServletResponseWrapper@29f5387', '127.0.0.1', '2022-01-02 23:03:21');
INSERT INTO `sys_log` VALUES (66, 'admin', '查询管理员', 25, 'com.gk.carshopsys.controller.AdminController.findAdmin()', '  param: {username=, id=null}', '127.0.0.1', '2022-01-03 11:22:02');
INSERT INTO `sys_log` VALUES (67, 'admin', '查询汽车订单', 48, 'com.gk.carshopsys.controller.CarOrderController.quryCarOrderList()', '  params: {start_time=, car=, end_time=, emp=, ordernum=, state=, cust=}', '127.0.0.1', '2022-01-03 11:27:30');
INSERT INTO `sys_log` VALUES (68, 'admin', '查询配件订单', 23, 'com.gk.carshopsys.controller.PartOrderController.quryPartOrderList()', '  params: {start_time=, part=, end_time=, emp=, ordernum=, state=, cust=}', '127.0.0.1', '2022-01-03 11:27:31');
INSERT INTO `sys_log` VALUES (69, 'admin', '查询售后订单', 16, 'com.gk.carshopsys.controller.AfterOrderController.quryCarOrderList()', '  params: {start_time=, carno=, service=, afterordernum=, end_time=, emp=, ordernum=, state=}', '127.0.0.1', '2022-01-03 11:27:32');
INSERT INTO `sys_log` VALUES (70, 'admin', '查询汽车库存', 35, 'com.gk.carshopsys.controller.CarController.queryCar()', '  params: {color=, configuration=, hight_price=, carname=, id=, type=, low_price=, brand=}', '127.0.0.1', '2022-01-03 11:27:34');
INSERT INTO `sys_log` VALUES (71, 'admin', '查询配件库存', 14, 'com.gk.carshopsys.controller.PartController.queryPart()', '  params: {factory=, hight_price=, pname=, id=, source=, low_price=}', '127.0.0.1', '2022-01-03 11:27:35');
INSERT INTO `sys_log` VALUES (72, 'admin', '查询客户', 3, 'com.gk.carshopsys.controller.CustController.findcust()', '  params: {address=, custid=, job=, custname=}', '127.0.0.1', '2022-01-03 11:27:36');
INSERT INTO `sys_log` VALUES (73, 'admin', '查询汽车订单', 115, 'com.gk.carshopsys.controller.CarOrderController.quryCarOrderList()', '  params: {start_time=, car=, end_time=, emp=, ordernum=, state=, cust=}', '127.0.0.1', '2022-01-03 11:45:21');
INSERT INTO `sys_log` VALUES (74, 'admin', '查询配件订单', 30, 'com.gk.carshopsys.controller.PartOrderController.quryPartOrderList()', '  params: {start_time=, part=, end_time=, emp=, ordernum=, state=, cust=}', '127.0.0.1', '2022-01-03 11:45:22');
INSERT INTO `sys_log` VALUES (75, 'admin', '查询售后订单', 16, 'com.gk.carshopsys.controller.AfterOrderController.quryCarOrderList()', '  params: {start_time=, carno=, service=, afterordernum=, end_time=, emp=, ordernum=, state=}', '127.0.0.1', '2022-01-03 11:45:24');
INSERT INTO `sys_log` VALUES (76, 'admin', '查询汽车库存', 35, 'com.gk.carshopsys.controller.CarController.queryCar()', '  params: {color=, configuration=, hight_price=, carname=, id=, type=, low_price=, brand=}', '127.0.0.1', '2022-01-03 11:45:27');
INSERT INTO `sys_log` VALUES (77, 'admin', '查询配件库存', 12, 'com.gk.carshopsys.controller.PartController.queryPart()', '  params: {factory=, hight_price=, pname=, id=, source=, low_price=}', '127.0.0.1', '2022-01-03 11:45:29');
INSERT INTO `sys_log` VALUES (78, 'admin', '查询客户', 10, 'com.gk.carshopsys.controller.CustController.findcust()', '  params: {address=, custid=, job=, custname=}', '127.0.0.1', '2022-01-03 11:45:30');
INSERT INTO `sys_log` VALUES (79, 'admin', '查询员工', 9, 'com.gk.carshopsys.controller.EmpController.findemp()', '  params: {ename=, empno=, dname=, job=, hiredate=}', '127.0.0.1', '2022-01-03 11:45:31');
INSERT INTO `sys_log` VALUES (80, 'admin', '查询管理员', 25, 'com.gk.carshopsys.controller.AdminController.findAdmin()', '  param: {username=, id=null}', '127.0.0.1', '2022-01-03 11:45:34');
INSERT INTO `sys_log` VALUES (81, 'admin', '查询汽车订单', 50, 'com.gk.carshopsys.controller.CarOrderController.quryCarOrderList()', '  params: {start_time=, car=, end_time=, emp=, ordernum=, state=, cust=}', '127.0.0.1', '2022-01-03 20:27:42');
INSERT INTO `sys_log` VALUES (82, 'admin', '查询员工', 32, 'com.gk.carshopsys.controller.EmpController.findemp()', '  params: {ename=, empno=, dname=, job=, hiredate=}', '127.0.0.1', '2022-01-03 20:27:55');
INSERT INTO `sys_log` VALUES (83, 'admin', '查询管理员', 17, 'com.gk.carshopsys.controller.AdminController.findAdmin()', '  param: {username=, id=null}', '127.0.0.1', '2022-01-03 20:28:06');

SET FOREIGN_KEY_CHECKS = 1;