SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
DROP TABLE IF EXISTS `branch`;
CREATE TABLE `branch` (
`id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
`name` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`sort` int(2) NOT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '网点' ROW_FORMAT = Dynamic;
INSERT INTO `branch` VALUES ('0', '全体', 1);
INSERT INTO `branch` VALUES ('1', '城关区', 2);
INSERT INTO `branch` VALUES ('2', '安宁区', 3);
INSERT INTO `branch` VALUES ('3', '七里河区', 4);
INSERT INTO `branch` VALUES ('4', '西固区', 5);
INSERT INTO `branch` VALUES ('5', '红古区', 7);
INSERT INTO `branch` VALUES ('6', '永登县', 6);
INSERT INTO `branch` VALUES ('7', '皋兰县', 8);
INSERT INTO `branch` VALUES ('8', '榆中县', 10);
INSERT INTO `branch` VALUES ('9', '兰州新区', 9);
DROP TABLE IF EXISTS `business_introduction`;
CREATE TABLE `business_introduction` (
`id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
`business_introduction` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
DROP TABLE IF EXISTS `comment`;
CREATE TABLE `comment` (
`id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
`content` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`starts` double(5, 1) NULL DEFAULT NULL COMMENT '打分\r\n',
`advise` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '投诉\n',
`order_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`comment_time` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`customer_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT 'vx端用户id',
PRIMARY KEY (`id`) USING BTREE,
INDEX `comment_orderid_idx`(`order_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '评价' ROW_FORMAT = Dynamic;
INSERT INTO `comment` VALUES ('487c0100f2064f6bbaf4bd3ef9040f76', '师傅来的非常及时，下次出故障时还会使用', 5.0, '暂时无', 'b38e57166bd74262ad040029b1cd267d', '2021-04-03 17:17:50', 'acaba40a99aa4734a17758db3458b9a0');
INSERT INTO `comment` VALUES ('595e932e46924150bcd17fe040ee0ec7', '非常好服务', 5.0, '暂无', 'cc62577d25914946a406e94e3a8a11a9', '2021-04-03 21:33:38', 'acaba40a99aa4734a17758db3458b9a0');
INSERT INTO `comment` VALUES ('ce598fe4bf9a40238a73c484b4fe16e6', '很好', 4.0, '希望可以再快一点', '013eace62ff547d78d830497264bd394', '2021-04-01 22:19:29', 'abe241a1150e4a4fa3ea582d8394e94f');
INSERT INTO `comment` VALUES ('f58f3cb4232744f7b8c17e9d70fae260', '非常好服务，工人状态也特别好', 5.0, '暂无', '496efdbbecac4c3a883c8eb998ec819a', '2021-04-03 21:28:09', 'acaba40a99aa4734a17758db3458b9a0');
DROP TABLE IF EXISTS `company`;
CREATE TABLE `company` (
`id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
`name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`branch_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`security_deposit` decimal(12, 2) NULL DEFAULT NULL COMMENT '保证金',
`approval` int(1) NULL DEFAULT 0 COMMENT '审核资格\\n',
`address` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`sort` int(2) NULL DEFAULT NULL,
`mobile_phone` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE,
INDEX `company_branchid_idx`(`branch_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
INSERT INTO `company` VALUES ('1', '兰州文理学院文创科技园', '1', 350000.00, 1, '甘肃省兰州市城关区雁园街道雁北路400号兰州文理学院文创科技园\r\n', 1, '0931 -8685007');
INSERT INTO `company` VALUES ('2', '大唐甘肃发电有限公司', '2', 460000.00, 1, '甘肃省兰州市南滨河中路299号', 2, '0931-7502510');
INSERT INTO `company` VALUES ('3', '甘肃新泉风力发电有限公司', '3', 300000.00, 1, '甘肃省兰州市硷沟沿272号大唐城市广场A座26层', 3, '0931-7691030');
INSERT INTO `company` VALUES ('4', '国网甘肃省电力公司', '4', 450000.00, 1, '甘肃省兰州市西津东路628号', 5, '0931-2663985');
INSERT INTO `company` VALUES ('5', '国家电网(庙滩子供电营业站)', '5', 100000.00, 1, '甘肃省兰州市盐场路1578号', 4, '0931-7953446');
INSERT INTO `company` VALUES ('6', '兰州供电公司', '6', 130000.00, 1, '甘肃省兰州市桃林路132号', 7, ' 0931-2320710');
INSERT INTO `company` VALUES ('7', '国家电网(兰州市城关区供电公司)', '7', 100000.00, 1, '甘肃省兰州市皋兰路街道金昌南路356号国家电网广场西口,', 6, '0931-8631234');
INSERT INTO `company` VALUES ('8', '国家电网(兰州七里河供电营业厅)', '8', 260000.00, 1, '甘肃省兰州市西津东路669号', 8, '0931-2653531');
DROP TABLE IF EXISTS `customer`;
CREATE TABLE `customer` (
`id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
`mobile_phone` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
`salt` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '加密盐值',
`tcode` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '总户号\\n',
`type` int(2) NULL DEFAULT 0,
`name` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`address` varchar(300) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`approval` varchar(4) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT '0' COMMENT '审核状态',
`branch_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`longitude` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`latitude` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`flag` int(2) NULL DEFAULT NULL,
`sort` int(2) NULL DEFAULT NULL,
`passwords` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE,
INDEX `customer_branchid_idx`(`branch_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '用户表' ROW_FORMAT = Dynamic;
INSERT INTO `customer` VALUES ('14', '15390655260', 'Af!Af!#dsAXCKLK*==', 'B101', 1, '陈晨', '北面滩新村', '1', '1', NULL, NULL, 0, 1, '111111');
INSERT INTO `customer` VALUES ('15', '13866666666', 'sW2v05PANs8ivjbiUtfpew==', 'A112', 1, '王嘉乐', '甘肃省兰州市火车西站东路兰西东闸口小区', '1', '2', NULL, NULL, 2, 3, '111111');
INSERT INTO `customer` VALUES ('16', '15050314381', 'ybnL41ZEi1Ik8Rtf2yu3pw==', 'A133', 1, '张蕊', '甘肃省兰州市张掖路金石巷1-10号金石巷小区', '1', '3', NULL, NULL, 0, 2, '111111');
INSERT INTO `customer` VALUES ('18', '13140821339', 'S9zgLbbSDu630za2xErW/w==', 'B120', 1, '刘志斌', '甘肃省兰州市城关区正宁路248~254', '1', '4', NULL, NULL, 1, 4, '111111');
INSERT INTO `customer` VALUES ('19', '15501680139', 'uYhCQCQMhm4D/kh6+WCxmw==', 'C111', 1, '刘沁怡', '甘肃省兰州市永昌路243号附近西苑小区', '1', '5', NULL, NULL, 0, 7, '111111');
INSERT INTO `customer` VALUES ('364661edb63d44d5b33a1c590163ff7e', '18962788671', NULL, '619', 1, '张佳强', '甘肃省兰州市永昌路360号附近(兰东小区)', '0', '1', NULL, NULL, NULL, 11, '111111');
INSERT INTO `customer` VALUES ('4c2d4224ea744afebcbd45c07fc0952c', '17826157212', NULL, '155', 0, '刘国龙', '甘肃省兰州市火车西站东路兰西东闸口小区', '0', '3', NULL, NULL, NULL, 9, '123456');
INSERT INTO `customer` VALUES ('70d57a3bff6e44ea91f00c4bb48e8b4d', '13003585326', NULL, 'B131', 0, '王倩', '甘肃省兰州市七里河区101省道华龙小区', '0', '7', NULL, NULL, 1, 8, '111111');
INSERT INTO `customer` VALUES ('7222a11dc4684b8b8eadccfbe3af0442', '18605132777', NULL, '111', 0, '曹林平', '甘肃省兰州市东岗东路923-987号', '0', '1', NULL, NULL, NULL, 12, '111111');
INSERT INTO `customer` VALUES ('abe241a1150e4a4fa3ea582d8394e94f', '15895404504', NULL, '12', 0, '李小朋', '城关区城关花园1幢101', '0', '1', NULL, NULL, NULL, 10, '111111');
INSERT INTO `customer` VALUES ('acaba40a99aa4734a17758db3458b9a0', '13905139757', NULL, '111111', 0, '王清永', '安心小区', '1', '6', NULL, NULL, 0, 6, '111111');
INSERT INTO `customer` VALUES ('dc5e12d778644fa9be9f0f9b5f95545d', '17505208923', NULL, 'D168', 0, '赵中业', '甘肃省兰州市正宁路218号金兰小区', '0', '8', NULL, NULL, 1, 8, '111111');
DROP TABLE IF EXISTS `fault`;
CREATE TABLE `fault` (
`id` int(11) NOT NULL,
`fault_name` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
INSERT INTO `fault` VALUES (1, '别人有电但我没有');
INSERT INTO `fault` VALUES (2, '别人和我都没有电');
DROP TABLE IF EXISTS `feedback`;
CREATE TABLE `feedback` (
`id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
`order_code` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`content` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`advise` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`feed_time` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
INSERT INTO `feedback` VALUES ('36686defe7174ba9956fab528cbf6828', '20210401202835', '陈师傅修得很快，而且到现在一直没出问题', '希望以后价格可以更优惠电', '2023-01-03 08:33:58');
INSERT INTO `feedback` VALUES ('38107d9c19d84e1296dffdd3c3608c29', '20210401175219', '非常好', '暂无', '2023-02-03 20:37:42');
INSERT INTO `feedback` VALUES ('578b936734d84b78b039d990fcebe8d4', '20210401175219', '这边工人师傅的服务都挺不错的', '希望工人师傅可以多和客户沟通', '2023-02-01 20:46:14');
INSERT INTO `feedback` VALUES ('c3a2203c1d134c3186975b5301532931', '20210401202835', '服务好，师傅也很耐心', '希望以后工人师傅可以来得快点', '2023-02-01 21:42:06');
INSERT INTO `feedback` VALUES ('d91efc53f3794ba1a961212ed4418a9e', '20210401202835', '来得及时，修得也很快很好。', '没有意见，很好!', '2023-02-01 21:43:39');
DROP TABLE IF EXISTS `notice`;
CREATE TABLE `notice` (
`id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
`content` varchar(500) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`start_time` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`branch_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`end_time` varchar(30) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`sort` int(2) NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE,
INDEX `notice_branchid`(`branch_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
INSERT INTO `notice` VALUES ('00f1d3895c394e968250c0eb34f08a6a', '大学将于今天停电', '2022-09-04 00:00:00', '3', '2022-09-05 00:00:00', '大学停电', 3);
INSERT INTO `notice` VALUES ('10bc84ab175a4e38b075dce3d764a560', '部分街道将于今明两天进行电路检查和维护', '2022-09-02 06:00:00', '2', '2022-09-04 06:00:00', '停电通知', 6);
INSERT INTO `notice` VALUES ('123d2b6cf4d043f6bf5a81c314057c56', '部分街道将于今明两天进行电路检查和维护', '2022-09-02 06:00:00', '8', '2022-09-04 06:00:00', '停电通知', 11);
INSERT INTO `notice` VALUES ('52d19c23189141fea9532a946b549aa3', '部分街道将于今明两天进行电路检查和维护', '2022-09-02 06:00:00', '4', '2022-09-04 06:00:00', '停电通知', 8);
INSERT INTO `notice` VALUES ('70557091f0c64d828623081b66664c42', '部分街道将于今明两天进行电路检查和维护', '2022-09-02 06:00:00', '3', '2022-09-04 06:00:00', '停电通知', 5);
INSERT INTO `notice` VALUES ('7311d42c4202436789b2be54ae1e259a', '部分街道将于今明两天进行电路检查和维护', '2022-09-02 06:00:00', '5', '2022-09-04 06:00:00', '停电通知', 7);
INSERT INTO `notice` VALUES ('824a022f303444f887691eb4ba7f5d21', '部分街道将于今明两天进行电路检查和维护', '2022-09-02 06:00:00', '9', '2022-09-04 06:00:00', '停电通知', 12);
INSERT INTO `notice` VALUES ('a92d0ac2a5f841c59e108fa77124ff75', '部分街道将于今明两天进行电路检查和维护', '2022-09-02 06:00:00', '7', '2022-09-04 06:00:00', '停电通知', 10);
INSERT INTO `notice` VALUES ('acf1d3895c394e968250c0eb34f08azs', '大学计算机楼由于电力故障，需要在本周特定时段进行停电修复，请各位谅解', '2022-9-28 00:00:15', '2', '2022-09-01 00:00:15', '计算机楼停电时间通知', 2);
INSERT INTO `notice` VALUES ('b97f28a3830748d6aba0742a4a131c86', '计算机楼电线故障，将维修一天', '2022-09-06 00:00:00', '1', '2022-09-07 00:00:00', '大学计算机楼停电', 1);
INSERT INTO `notice` VALUES ('ea0f94c6ff47454d8db97e71d35d7ae2', '部分街道将于今明两天进行电路检查和维护', '2022-09-02 06:00:00', '6', '2022-09-04 06:00:00', '停电通知', 9);
INSERT INTO `notice` VALUES ('f119c8e1c5394def95cc576c4969a96c', '部分街道将于今明两天进行电路检查和维护', '2022-09-02 06:00:00', '1', '2022-09-04 06:00:00', '停电通知', 4);
DROP TABLE IF EXISTS `notice_publisher`;
CREATE TABLE `notice_publisher` (
`id` int(11) NOT NULL,
`name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
`position` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '职位',
`phoneNum` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '电话',
`company` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '单位',
`remark` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '备注',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
DROP TABLE IF EXISTS `offer`;
CREATE TABLE `offer` (
`id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
`order_num` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
`offer_amount` int(11) NOT NULL,
`offer_title` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`offer_description` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`products_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`offer_price` decimal(10, 2) NULL DEFAULT NULL,
`offer_status` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
INSERT INTO `offer` VALUES ('36', '5220190725195802', 1, '换保险丝', '保险丝熔断更换', NULL, 5.00, '已结束');
INSERT INTO `offer` VALUES ('37', '5220190725195802', 1, '换插座', '插座烧坏更换', NULL, 20.00, '已结束');
INSERT INTO `offer` VALUES ('38', '5220190725195802', 1, '更换电线', '电线老化更换', NULL, 50.00, '已结束');
INSERT INTO `offer` VALUES ('39', '4920190725221423', 1, '维修电线', '电线接触不良', NULL, 25.00, '已结束');
INSERT INTO `offer` VALUES ('40', '4920190725221423', 1, '维修变压器', '换新的变压器', NULL, 30.00, '已结束');
INSERT INTO `offer` VALUES ('41', '4920190726153714', 1, '修理灯泡', '更换灯泡', NULL, 70.00, '已结束');
INSERT INTO `offer` VALUES ('42', '4920190727132423', 1, '换新空调', '新空调', NULL, 1000.00, '已结束');
INSERT INTO `offer` VALUES ('43', '4920190727132423', 1, '维修线路', '维修线路', NULL, 59.00, '已结束');
INSERT INTO `offer` VALUES ('44', '4920190727125425', 1, '维修线路', '换新', NULL, 46.00, '已结束');
INSERT INTO `offer` VALUES ('45', '5120190728153920', 1, '保险丝更换', '保险丝', NULL, 10.00, '已结束');
INSERT INTO `offer` VALUES ('46', '5120190728153920', 1, '开关更换', '烧坏了', NULL, 15.00, '已结束');
INSERT INTO `offer` VALUES ('47', '5120190728153920', 1, '线路更换', '电线部分损坏', NULL, 30.00, '已结束');
INSERT INTO `offer` VALUES ('48', '4920190727153142', 1, '更换变压器', '更换', NULL, 137.00, '已结束');
INSERT INTO `offer` VALUES ('49', '5120190728203053', 1, '价格预估', '预估', NULL, 58.00, '已结束');
INSERT INTO `offer` VALUES ('50', '5520190729155535', 1, '上门费', '上门维修电线', NULL, 10.00, '已结束');
INSERT INTO `offer` VALUES ('51', '5520190729155535', 1, '换插座', '插座', NULL, 5.00, '已结束');
INSERT INTO `offer` VALUES ('52', '5520190729155535', 1, '维护电线', '电线15', NULL, 15.00, '已结束');
INSERT INTO `offer` VALUES ('53', '5620190729221723', 1, '保险丝更换', '烧断了', NULL, 10.00, '已结束');
INSERT INTO `offer` VALUES ('54', '5620190729221723', 1, '插座更换', '换插座', NULL, 12.00, '已结束');
INSERT INTO `offer` VALUES ('55', '5120190730094134', 1, '更换插座', '插座烧坏', NULL, 15.00, '已结束');
INSERT INTO `offer` VALUES ('56', '5120190730094134', 1, '更换电线', '电线烧坏', NULL, 20.00, '已结束');
INSERT INTO `offer` VALUES ('57', '2220190730154436', 1, '维修电路', '电路过载', NULL, 155.00, '未完成');
INSERT INTO `offer` VALUES ('58', '4920190730170350', 1, '更换电闸', '保险丝断了', NULL, 134.00, '未完成');
INSERT INTO `offer` VALUES ('59', '10320190820232042', 1, '更换电线', '电线烧坏了', NULL, 19.00, '未完成');
INSERT INTO `offer` VALUES ('60', '10320190820232042', 1, '维修电闸', '维修', NULL, 43.00, '未完成');
INSERT INTO `offer` VALUES ('61', '10320190820232042', 1, '维修服务', NULL, NULL, 50.00, '未完成');
DROP TABLE IF EXISTS `offer_photo`;
CREATE TABLE `offer_photo` (
`id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
`order_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
`type` int(11) NULL DEFAULT NULL,
`photo_url` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
INSERT INTO `offer_photo` VALUES ('45', '36', 0, 'http://lotofthings.club/beforeImage/DBM20190725200426.jpg');
INSERT INTO `offer_photo` VALUES ('46', '36', 1, 'http://lotofthings.club/afterImage/DBM20190725200435.jpg');
INSERT INTO `offer_photo` VALUES ('47', '37', 0, 'http://lotofthings.club/beforeImage/DBM20190725200608.jpg');
INSERT INTO `offer_photo` VALUES ('48', '37', 1, 'http://lotofthings.club/afterImage/DBM20190725200618.jpg');
INSERT INTO `offer_photo` VALUES ('49', '38', 0, 'http://lotofthings.club/beforeImage/DBM20190725200632.jpg');
INSERT INTO `offer_photo` VALUES ('50', '38', 1, 'http://lotofthings.club/afterImage/DBM20190725200638.jpg');
INSERT INTO `offer_photo` VALUES ('52', '39', 1, 'http://lotofthings.club/afterImage/4920190725221423/4920190725221423_00_1_DBM20190726103624.jpg');
INSERT INTO `offer_photo` VALUES ('53', '39', 0, 'http://lotofthings.club/beforeImage/4920190725221423/4920190725221423_00_0_DBM20190726103617.jpg');
INSERT INTO `offer_photo` VALUES ('54', '40', 0, 'http://lotofthings.club/beforeImage/4920190725221423/4920190725221423_01_0_DBM20190726114725.jpg');
INSERT INTO `offer_photo` VALUES ('55', '40', 1, 'http://lotofthings.club/afterImage/4920190725221423/4920190725221423_01_1_DBM20190726114734.jpg');
INSERT INTO `offer_photo` VALUES ('56', '41', 0, 'http://lotofthings.club/beforeImage/4920190726153714/4920190726153714_00_0_DBM20190726155058.jpg');
INSERT INTO `offer_photo` VALUES ('57', '41', 1, 'http://lotofthings.club/afterImage/4920190726153714/4920190726153714_00_1_DBM20190726155103.jpg');
INSERT INTO `offer_photo` VALUES ('58', '42', 0, 'http://lotofthings.club/beforeImage/4920190727132423/4920190727132423_00_0_DBM20190727132857.jpg');
INSERT INTO `offer_photo` VALUES ('59', '42', 1, 'http://lotofthings.club/afterImage/4920190727132423/4920190727132423_00_1_DBM20190727132905.jpg');
INSERT INTO `offer_photo` VALUES ('60', '43', 0, 'http://lotofthings.club/beforeImage/4920190727132423/4920190727132423_01_0_DBM20190727132920.jpg');
INSERT INTO `offer_photo` VALUES ('61', '43', 1, 'http://lotofthings.club/afterImage/4920190727132423/4920190727132423_01_1_DBM20190727132930.jpg');
INSERT INTO `offer_photo` VALUES ('62', '44', 0, 'http://lotofthings.club/beforeImage/4920190727125425/4920190727125425_00_0_DBM20190727144423.jpg');
INSERT INTO `offer_photo` VALUES ('63', '44', 1, 'http://lotofthings.club/afterImage/4920190727125425/4920190727125425_00_1_DBM20190727144428.jpg');
INSERT INTO `offer_photo` VALUES ('64', '45', 0, 'http://lotofthings.club/beforeImage/5120190728153920/5120190728153920_00_0_DBM20190728154929.jpg');
INSERT INTO `offer_photo` VALUES ('65', '45', 1, 'http://lotofthings.club/afterImage/5120190728153920/5120190728153920_00_1_DBM20190728154941.jpg');
INSERT INTO `offer_photo` VALUES ('66', '46', 0, 'http://lotofthings.club/beforeImage/5120190728153920/5120190728153920_01_0_DBM20190728155000.jpg');
INSERT INTO `offer_photo` VALUES ('67', '46', 1, 'http://lotofthings.club/afterImage/5120190728153920/5120190728153920_01_1_DBM20190728155008.jpg');
INSERT INTO `offer_photo` VALUES ('68', '47', 0, 'http://lotofthings.club/beforeImage/5120190728153920/5120190728153920_02_0_DBM20190728155026.jpg');
INSERT INTO `offer_photo` VALUES ('69', '47', 1, 'http://lotofthings.club/afterImage/5120190728153920/5120190728153920_02_1_DBM20190728155035.jpg');
INSERT INTO `offer_photo` VALUES ('70', '48', 0, 'http://lotofthings.club/beforeImage/4920190727153142/4920190727153142_00_0_DBM20190729223742.jpg');
INSERT INTO `offer_photo` VALUES ('71', '49', 0, 'http://lotofthings.club/beforeImage/5120190728203053/5120190728203053_00_0_DBM20190728211019.jpg');
INSERT INTO `offer_photo` VALUES ('72', '49', 1, 'http://lotofthings.club/afterImage/5120190728203053/5120190728203053_00_1_DBM20190728211025.jpg');
INSERT INTO `offer_photo` VALUES ('73', '50', 0, 'http://lotofthings.club/beforeImage/5520190729155535/5520190729155535_00_0_DBM20190729160126.jpg');
INSERT INTO `offer_photo` VALUES ('74', '50', 1, 'http://lotofthings.club/afterImage/5520190729155535/5520190729155535_00_1_DBM20190729160135.jpg');
INSERT INTO `offer_photo` VALUES ('75', '51', 0, 'http://lotofthings.club/beforeImage/5520190729155535/5520190729155535_01_0_DBM20190729160145.jpg');
INSERT INTO `offer_photo` VALUES ('76', '51', 1, 'http://lotofthings.club/afterImage/5520190729155535/5520190729155535_01_1_DBM20190729160150.jpg');
INSERT INTO `offer_photo` VALUES ('77', '52', 0, 'http://lotofthings.club/beforeImage/5520190729155535/5520190729155535_02_0_DBM20190729160200.jpg');
INSERT INTO `offer_photo` VALUES ('78', '52', 1, 'http://lotofthings.club/afterImage/5520190729155535/5520190729155535_02_1_DBM20190729160206.jpg');
INSERT INTO `offer_photo` VALUES ('79', '53', 0, 'http://lotofthings.club/beforeImage/5620190729221723/5620190729221723_00_0_DBM20190729222626.jpg');
INSERT INTO `offer_photo` VALUES ('80', '53', 1, 'http://lotofthings.club/afterImage/5620190729221723/5620190729221723_00_1_DBM20190729222637.jpg');
INSERT INTO `offer_photo` VALUES ('81', '54', 0, 'http://lotofthings.club/beforeImage/5620190729221723/5620190729221723_01_0_DBM20190729222651.jpg');
INSERT INTO `offer_photo` VALUES ('82', '54', 1, 'http://lotofthings.club/afterImage/5620190729221723/5620190729221723_01_1_DBM20190729222658.jpg');
INSERT INTO `offer_photo` VALUES ('83', '48', 1, 'http://lotofthings.club/afterImage/4920190727153142/4920190727153142_00_1_DBM20190729223746.jpg');
INSERT INTO `offer_photo` VALUES ('84', '55', 0, 'http://lotofthings.club/beforeImage/5120190730094134/5120190730094134_00_0_DBM20190730095532.jpg');
INSERT INTO `offer_photo` VALUES ('85', '55', 1, 'http://lotofthings.club/afterImage/5120190730094134/5120190730094134_00_1_DBM20190730095538.jpg');
INSERT INTO `offer_photo` VALUES ('86', '56', 0, 'http://lotofthings.club/beforeImage/5120190730094134/5120190730094134_01_0_DBM20190730095552.jpg');
INSERT INTO `offer_photo` VALUES ('87', '56', 1, 'http://lotofthings.club/afterImage/5120190730094134/5120190730094134_01_1_DBM20190730095558.jpg');
DROP TABLE IF EXISTS `orders`;
CREATE TABLE `orders` (
`id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
`code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '订单号码',
`status` int(2) NULL DEFAULT NULL COMMENT '状态：0待接单1已接单2完成3终止4移交',
`order_type` int(2) NULL DEFAULT NULL COMMENT '订单类型\\n电话订单\\n普通订单',
`branch_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL COMMENT '外键，对应branch区域表的id',
`branch_name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`fault_type` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`fault_description` varchar(1000) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`estimated_price` decimal(12, 2) NULL DEFAULT NULL COMMENT '预估价格\\\\n',
`customer_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL COMMENT '用户id\n电话订单给个特殊id',
`customer_name` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`customer_type` int(2) NULL DEFAULT NULL,
`customer_address` varchar(300) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`customer_phone` varchar(20) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`customer_tcode` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`worker_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`worker_name` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`worker_phone` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`worker_company_name` varchar(100) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`worker_code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`worker_longitude` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`worker_latitude` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`longitude` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`latitude` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`create_time` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE,
INDEX `order_branchid_idx`(`branch_id`) USING BTREE,
INDEX `order_customerid_idx`(`customer_id`) USING BTREE,
INDEX `order_workerid_idx`(`worker_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '维修订单' ROW_FORMAT = Dynamic;
INSERT INTO `orders` VALUES ('013eace62ff547d78d830497264bd394', '20220901221241', 7, 0, '1', '城关区', '0', '电灯打不开了', NULL, 'abe241a1150e4a4fa3ea582d8394e94f', '李小朋', 0, '城关区城关花园1幢101', '15895404504', '12', '14', '王清永', '15322981390', '国家电网(兰州市城关区供电公司)', '2021113274', NULL, NULL, '120.85737', '32.00986', '2022-02-15 16:51:01');
INSERT INTO `orders` VALUES ('07a07a45975a4547877992c865d03276', '20220901203419', 6, 0, '6', '兰州市', '0', '家里跳闸断电', NULL, 'acaba40a99aa4734a17758db3458b9a0', '王清永', 0, '安心小区', '13905139757', '111111', '14', '王清永', '15322981390', '国家电网(兰州市城关区供电公司)', '14', NULL, NULL, '120.85737', '32.00986', '2022-02-24 19:30:19');
INSERT INTO `orders` VALUES ('08e89395fb6f4627bded560febfb819d', '20220903203012', 6, 0, '6', '安宁区', '1', '店铺停电请速来修理', NULL, 'acaba40a99aa4734a17758db3458b9a0', '王清永', 0, '青创园', '13905139757', '111111', '1', '陈一', '15606230989', '国家电网(兰州市安宁区供电公司)', '1', NULL, NULL, '120.906273', '31.976954', '1617453012000');
INSERT INTO `orders` VALUES ('11e8a416027042379f4ee28a4c984c69', '20220903213217', 6, 0, '1', '红古区', '0', '由于使用大规模电器，家里断电', NULL, 'acaba40a99aa4734a17758db3458b9a0', '王清永', 0, '北面滩新村', '13905139757', '111111', '1', '陈凯歌', '15606230989', '国家电网(兰州市红古区供电公司)', '1', NULL, NULL, '120.900871', '31.97011', '1617456737000');
INSERT INTO `orders` VALUES ('2520f37f41bd4544af2ffc708ed7d0e8', '20220901202835', 6, 0, '3', '七里河区', '0', '家里的电表坏了', NULL, '4c2d4224ea744afebcbd45c07fc0952c', '王倩', 0, '兰州市七里河区101省道华龙小区', '17826157212', '155', '14', '何晓东', '15322981390', '国家电网(兰州七里河供电营业厅)', '14', NULL, NULL, NULL, NULL, '2022-03-21 09:18:11');
INSERT INTO `orders` VALUES ('28dbd4beb3ef4b36a51f8e730730f592', '20221006220330', 9, 0, '1', '城关区', '0', '任天堂', NULL, '14', '陈逸彬', 1, '中南世纪城A102', '15606230989', 'B101', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '120.900871', '31.97011', '2021-04-06 22:03:30');
INSERT INTO `orders` VALUES ('302b7392968c4515bb9ff6a0fefc3b17', '20221003173413', 9, 0, '6', '兰州市', '1', '街边店铺停电，请快速前来报修', NULL, 'acaba40a99aa4734a17758db3458b9a0', '王清永', 0, '南大街', '13905139757', '111111', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '120.866493', '32.012329', '2022-10-03 17:34:13');
INSERT INTO `orders` VALUES ('4329f997480d4c5e99fc1455a75a426d', '20221013225941', 9, 0, '6', '兰州市', '0', '电灯坏了', NULL, 'acaba40a99aa4734a17758db3458b9a0', '何志雄', 0, '兰州文理学院', '13905139757', '111111', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '121.619102', '31.825123', '2022-10-13 22:59:41');
INSERT INTO `orders` VALUES ('496efdbbecac4c3a883c8eb998ec819a', '20221003202435', 7, 0, '6', '兰州市', '1', '学校停电，请速来修理', NULL, 'acaba40a99aa4734a17758db3458b9a0', '何志雄', 0, '兰州文理学院', '13905139757', '111111', '1', NULL, NULL, NULL, NULL, NULL, NULL, '121.619102', '31.825123', '2022-10-03 20:24:35');
INSERT INTO `orders` VALUES ('69cf213534f648d9b6cc9e04f8b64534', '20221001231718', 3, 0, '1', '城关区', '0', '热水器坏了', NULL, 'abe241a1150e4a4fa3ea582d8394e94f', '李小朋', 0, '城关区城关花园1幢101', '15895484584', '12', '14', '王清永', '15322981390', '国家电网(兰州市城关区供电公司)', '2022113274', NULL, NULL, NULL, NULL, '1617290238000');
INSERT INTO `orders` VALUES ('a99c57f9ed6743c89e380623d2c1b71e', '20221001175219', 6, 0, '1', '城关区', '0', '没有电', NULL, '14', '陈逸彬', 1, '中南世纪城A102', '15606230989', 'B101', '1', '陈一', '15606230989', '崇川科技园公司', '2021113270', NULL, NULL, '120.900871', '31.97011', '1617270739000');
INSERT INTO `orders` VALUES ('b38e57166bd74262ad040029b1cd267d', '20221003170202', 7, 0, '6', '兰州市', '0', '电力插座发生故障', NULL, 'acaba40a99aa4734a17758db3458b9a0', '王清永', 0, '安心小区', '13905139757', '111111', '14', '王清永', '15322981390', '国家电网(兰州市城关区供电公司)', '14', NULL, NULL, '120.85737', '32.00986', '2022-02-18 11:23:18');
INSERT INTO `orders` VALUES ('b43c398a80e94fa982e988e396acc765', '20221001221217', 6, 0, '1', '城关区', '0', '电灯打不开了', NULL, 'abe241a1150e4a4fa3ea582d8394e94f', '李小朋', 0, '城关区城关花园1幢101', '15895404504', '12', '14', '王清永', '15322981390', '国家电网(兰州市城关区供电公司)', '2022113274', NULL, NULL, NULL, NULL, '2022-03-25 17:52:19');
INSERT INTO `orders` VALUES ('cc62577d25914946a406e94e3a8a11a9', '20221003170306', 7, 0, '6', '兰州市', '1', '小区停电，请尽快前来修复', NULL, 'acaba40a99aa4734a17758db3458b9a0', '王清永', 0, '北面滩新村', '13905139757', '619', '1', NULL, NULL, NULL, NULL, NULL, NULL, '120.900871', '31.97011', '2022-10-03 17:03:06');
DROP TABLE IF EXISTS `products_price`;
CREATE TABLE `products_price` (
`id` int(2) NOT NULL,
`products_name` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`price` decimal(12, 2) NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '器件价格\r\n' ROW_FORMAT = Dynamic;
INSERT INTO `products_price` VALUES (1, '变压器', 35.00);
INSERT INTO `products_price` VALUES (2, '控制器', 24.00);
INSERT INTO `products_price` VALUES (3, '节能灯', 30.00);
INSERT INTO `products_price` VALUES (4, '应急照明器材', 80.00);
INSERT INTO `products_price` VALUES (5, '汇流排', 100.00);
DROP TABLE IF EXISTS `provide_service`;
CREATE TABLE `provide_service` (
`id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
`name` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`content` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`price` int(8) NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci ROW_FORMAT = Dynamic;
INSERT INTO `provide_service` VALUES ('1', '定检', '定期检查设备', 1000);
INSERT INTO `provide_service` VALUES ('2', '代维', '按时维修电气设备', 1500);
INSERT INTO `provide_service` VALUES ('3', '质保', '一年内免费维修所购设备', 1200);
INSERT INTO `provide_service` VALUES ('4', '技术咨询', '提供电气设备方面的技术服务', 800);
DROP TABLE IF EXISTS `sys_perm`;
CREATE TABLE `sys_perm` (
`pval` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '权限值，shiro的权限控制表达式',
`parent` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '父权限id',
`pname` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '权限名称',
`ptype` int(3) NULL DEFAULT NULL COMMENT '权限类型：1.菜单 2.按钮 3.接口 4.特殊',
`leaf` tinyint(1) NULL DEFAULT NULL COMMENT '是否叶子节点',
`created` timestamp(0) NULL DEFAULT NULL COMMENT '创建时间',
`updated` timestamp(0) NULL DEFAULT NULL COMMENT '修改时间',
PRIMARY KEY (`pval`) USING BTREE,
UNIQUE INDEX `pval`(`pval`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '权限' ROW_FORMAT = Dynamic;
INSERT INTO `sys_perm` VALUES ('*', NULL, '所有权限', 0, NULL, '2022-04-19 18:14:12', NULL);
INSERT INTO `sys_perm` VALUES ('a:auth', NULL, '登录模块', 3, 1, NULL, NULL);
INSERT INTO `sys_perm` VALUES ('a:branch', NULL, 'BranchController', 3, 1, NULL, NULL);
INSERT INTO `sys_perm` VALUES ('a:businessIntroduction', NULL, 'BusinessIntroductionController', 3, 1, NULL, NULL);
INSERT INTO `sys_perm` VALUES ('a:comment', NULL, 'CommentController', 3, 1, NULL, NULL);
INSERT INTO `sys_perm` VALUES ('a:company', NULL, 'CompanyController', 3, 1, NULL, NULL);
INSERT INTO `sys_perm` VALUES ('a:customer', NULL, 'CustomerController', 3, 1, NULL, NULL);
INSERT INTO `sys_perm` VALUES ('a:fault', NULL, 'FaultController', 3, 0, NULL, NULL);
INSERT INTO `sys_perm` VALUES ('a:feedback', NULL, 'FeedbackController', 3, 1, NULL, NULL);
INSERT INTO `sys_perm` VALUES ('a:gradleBuild', 'a:test', '构建gradle', 3, 1, NULL, NULL);
INSERT INTO `sys_perm` VALUES ('a:mvn:install', 'a:test', 'mvnInstall', 3, 1, NULL, NULL);
INSERT INTO `sys_perm` VALUES ('a:notice', NULL, 'NoticeController', 3, 1, NULL, NULL);
INSERT INTO `sys_perm` VALUES ('a:offer', NULL, 'OfferController', 3, 1, NULL, NULL);
INSERT INTO `sys_perm` VALUES ('a:offerPhoto', NULL, 'OfferPhotoController', 3, 1, NULL, NULL);
INSERT INTO `sys_perm` VALUES ('a:option', NULL, '选项模块', 3, 1, NULL, NULL);
INSERT INTO `sys_perm` VALUES ('a:order:fault:listall', 'a:fault', '查询所有故障', 3, 1, NULL, NULL);
INSERT INTO `sys_perm` VALUES ('a:orders', NULL, 'OrdersController', 3, 1, NULL, '2021-03-28 09:55:22');
INSERT INTO `sys_perm` VALUES ('a:productsPrice', NULL, 'ProductsPriceController', 3, 1, NULL, NULL);
INSERT INTO `sys_perm` VALUES ('a:provideService', NULL, 'ProvideServiceController', 3, 1, NULL, NULL);
INSERT INTO `sys_perm` VALUES ('a:sys:perm', NULL, '系统权限模块', 3, 1, NULL, NULL);
INSERT INTO `sys_perm` VALUES ('a:sys:role', NULL, '系统角色模块', 3, 1, NULL, NULL);
INSERT INTO `sys_perm` VALUES ('a:sys:user:add', 'a:sys:接口', '添加系统用户', 3, 1, NULL, NULL);
INSERT INTO `sys_perm` VALUES ('a:sys:user:del', 'a:sys:接口', '删除系统用户', 3, 1, NULL, NULL);
INSERT INTO `sys_perm` VALUES ('a:sys:user:info', 'a:sys:接口', '查询系统用户信息', 3, 1, NULL, NULL);
INSERT INTO `sys_perm` VALUES ('a:sys:user:info:update', 'a:sys:接口', '更新系统用户的信息', 3, 1, NULL, NULL);
INSERT INTO `sys_perm` VALUES ('a:sys:user:list', 'a:sys:接口', '查询所有系统用户', 3, 1, NULL, NULL);
INSERT INTO `sys_perm` VALUES ('a:sys:user:role:find', 'a:sys:接口', '查找系统用户的角色', 3, 1, NULL, NULL);
INSERT INTO `sys_perm` VALUES ('a:sys:user:role:update', 'a:sys:接口', '更新系统用户的角色', 3, 1, NULL, NULL);
INSERT INTO `sys_perm` VALUES ('a:sys:接口', NULL, '系统用户模块', 3, 0, NULL, NULL);
INSERT INTO `sys_perm` VALUES ('a:test', NULL, '测试模块模块', 3, 0, NULL, NULL);
INSERT INTO `sys_perm` VALUES ('a:teststr', NULL, 'Mycontroller', 3, 1, NULL, NULL);
INSERT INTO `sys_perm` VALUES ('a:version', NULL, 'ApkUpdateController', 3, 1, NULL, NULL);
INSERT INTO `sys_perm` VALUES ('a:worker', NULL, 'WorkerController', 3, 1, NULL, NULL);
INSERT INTO `sys_perm` VALUES ('b:user:add', 'm:sys:user', '添加用户', 2, NULL, '2018-06-02 11:00:37', NULL);
INSERT INTO `sys_perm` VALUES ('b:user:delete', 'm:sys:user', '删除用户', 2, NULL, '2018-06-02 11:00:56', NULL);
INSERT INTO `sys_perm` VALUES ('m:basic', NULL, '基础数据', 1, 0, NULL, NULL);
INSERT INTO `sys_perm` VALUES ('m:basic:branch', 'm:basic', '区域管理', 1, 1, NULL, NULL);
INSERT INTO `sys_perm` VALUES ('m:basic:company', 'm:basic', '公司管理', 1, 1, NULL, NULL);
INSERT INTO `sys_perm` VALUES ('m:basic:customer', 'm:basic', '客户管理', 1, 1, NULL, NULL);
INSERT INTO `sys_perm` VALUES ('m:basic:worker', 'm:basic', '工人管理', 1, 1, NULL, NULL);
INSERT INTO `sys_perm` VALUES ('m:menu1', NULL, '菜单1', 1, 1, NULL, NULL);
INSERT INTO `sys_perm` VALUES ('m:menu11', NULL, '我的dd菜单11', 1, 1, NULL, NULL);
INSERT INTO `sys_perm` VALUES ('m:menu2', NULL, '菜单2', 1, 1, NULL, NULL);
INSERT INTO `sys_perm` VALUES ('m:menu3', NULL, '菜单3', 1, 0, NULL, NULL);
INSERT INTO `sys_perm` VALUES ('m:menu3:1', 'm:menu3', '菜单3-1', 1, 1, NULL, NULL);
INSERT INTO `sys_perm` VALUES ('m:menu3:2', 'm:menu3', '菜单3-2', 1, 1, NULL, NULL);
INSERT INTO `sys_perm` VALUES ('m:menu3:3', 'm:menu3', '菜单3-3', 1, 1, NULL, NULL);
INSERT INTO `sys_perm` VALUES ('m:menu4', NULL, '菜单4', 1, 0, NULL, NULL);
INSERT INTO `sys_perm` VALUES ('m:menu4:1', 'm:menu4', '菜单4-1', 1, 0, NULL, NULL);
INSERT INTO `sys_perm` VALUES ('m:menu4:1:a', 'm:menu4:1', '菜单4-1-a', 1, 1, NULL, NULL);
INSERT INTO `sys_perm` VALUES ('m:menu4:1:b', 'm:menu4:1', '菜单4-1-b', 1, 1, NULL, NULL);
INSERT INTO `sys_perm` VALUES ('m:menu4:1:c', 'm:menu4:1', '菜单4-1-c', 1, 1, NULL, NULL);
INSERT INTO `sys_perm` VALUES ('m:menu4:2', 'm:menu4', '菜单4-2', 1, 1, NULL, NULL);
INSERT INTO `sys_perm` VALUES ('m:order', NULL, '业务订单', 1, 0, NULL, NULL);
INSERT INTO `sys_perm` VALUES ('m:order:cus_orders', 'm:order', '客户订单管理', 1, 1, NULL, NULL);
INSERT INTO `sys_perm` VALUES ('m:order:feedback', 'm:order', '订单回访评价', 1, 1, NULL, NULL);
INSERT INTO `sys_perm` VALUES ('m:sys', NULL, '系统', 1, 0, NULL, NULL);
INSERT INTO `sys_perm` VALUES ('m:sys:perm', 'm:sys', '权限管理', 1, 1, NULL, NULL);
INSERT INTO `sys_perm` VALUES ('m:sys:role', 'm:sys', '角色管理', 1, 1, NULL, NULL);
INSERT INTO `sys_perm` VALUES ('m:sys:user', NULL, '公告', 1, 1, NULL, '2022-09-03 20:38:53');
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE `sys_role` (
`rid` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '角色id',
`rname` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '角色名，用于显示',
`rdesc` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '角色描述',
`rval` varchar(100) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '角色值，用于权限判断',
`created` timestamp(0) NULL DEFAULT NULL COMMENT '创建时间',
`updated` timestamp(0) NULL DEFAULT NULL COMMENT '修改时间',
PRIMARY KEY (`rid`) USING BTREE,
UNIQUE INDEX `rval`(`rval`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
INSERT INTO `sys_role` VALUES ('1002748319131680769', '普通用户', '具有一般的权限，不具备系统菜单权限', 'common', '2020-06-02 11:06:44', '2021-10-01 16:32:35');
INSERT INTO `sys_role` VALUES ('1002806178141937666', '财务', '拥有财务相关权限', 'finance', '2020-06-02 14:56:39', NULL);
INSERT INTO `sys_role` VALUES ('1002806220860923906', '仓管', '拥有财务相关权限', 'stock', '2020-06-02 14:56:49', NULL);
INSERT INTO `sys_role` VALUES ('1002806266750803970', '销售', '拥有财务相关权限', 'sale', '2020-06-02 14:57:00', NULL);
INSERT INTO `sys_role` VALUES ('1002807171923550210', '文员', '拥有文员相关的权限，包含仓库', 'stuff', '2020-06-02 15:00:36', '2021-10-03 20:38:36');
INSERT INTO `sys_role` VALUES ('999999888888777777', '超级管理员', '具有本系统中最高权限', 'root', '2020-04-19 17:34:33', NULL);
DROP TABLE IF EXISTS `sys_role_perm`;
CREATE TABLE `sys_role_perm` (
`role_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`perm_val` varchar(25) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`perm_type` int(5) NULL DEFAULT NULL,
PRIMARY KEY (`role_id`, `perm_val`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
INSERT INTO `sys_role_perm` VALUES ('1002748319131680769', 'a:perm:update', 3);
INSERT INTO `sys_role_perm` VALUES ('1002748319131680769', 'a:sys:perm', 3);
INSERT INTO `sys_role_perm` VALUES ('1002748319131680769', 'b:user:add', 2);
INSERT INTO `sys_role_perm` VALUES ('1002748319131680769', 'm:sys', 1);
INSERT INTO `sys_role_perm` VALUES ('1002748319131680769', 'm:sys:role', 1);
INSERT INTO `sys_role_perm` VALUES ('1002748319131680769', 'm:sys:user', 1);
INSERT INTO `sys_role_perm` VALUES ('999999888888777777', '*', NULL);
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user` (
`uid` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '用户id',
`uname` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '登录名，不可改',
`nick` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '用户昵称，可改',
`pwd` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '已加密的登录密码',
`salt` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '加密盐值',
`lock` tinyint(1) NULL DEFAULT NULL COMMENT '是否锁定',
`created` timestamp(0) NULL DEFAULT NULL COMMENT '创建时间',
`updated` timestamp(0) NULL DEFAULT NULL COMMENT '修改时间',
PRIMARY KEY (`uid`) USING BTREE,
UNIQUE INDEX `uname`(`uname`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
INSERT INTO `sys_user` VALUES ('1002748017179541505', 'cybxiyi', '锡疫', '8h553qKkMMjb+znBgcb3wtxSuRl2khED7ydm4+5TSlc=', 'dCFZ19ZLVPFb1p12D90/Nw==', 0, '2020-06-02 11:05:32', '2021-07-28 15:07:59');
INSERT INTO `sys_user` VALUES ('1002748102537822209', 'yjl', '老杨', 'g+aRBmgVTTPkNLNwJfM64D8rwH94WEgDgckQ4fuQp6w=', 'Sqhvxsnc0HZSQEFKjBB9zQ==', 0, '2020-06-02 11:05:52', NULL);
INSERT INTO `sys_user` VALUES ('1142248185683496961', 'wqy', '清永', 'xaBP5bcp+uGx4PMWg80i/PIF9EAzhSqK6yyjZVq4LCI=', 'D0VYLdDLBRSO0Mwkm6vdbw==', 0, '2021-06-22 09:48:37', NULL);
INSERT INTO `sys_user` VALUES ('1142655493320200193', 'ttrp', '阿瑞', '7bWt1HZtIQmhvZBcY0MJaAEF+qn2YrKWeSAmB6o/y2U=', 'OSRJLEViKAlwEqjiO4xb3w==', 0, '2021-06-23 12:47:29', NULL);
INSERT INTO `sys_user` VALUES ('986177923098808322', 'admin', '系统管理员', 'J/ms7qTJtqmysekuY8/v1TAS+VKqXdH5sB7ulXZOWho=', 'wxKYXuTPST5SG0jMQzVPsg==', 0, '2020-04-17 17:41:53', '2020-04-19 17:08:15');
DROP TABLE IF EXISTS `sys_user_role`;
CREATE TABLE `sys_user_role` (
`user_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`role_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
PRIMARY KEY (`user_id`, `role_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Dynamic;
INSERT INTO `sys_user_role` VALUES ('1002748017179541505', '1002748319131680769');
INSERT INTO `sys_user_role` VALUES ('1002748017179541505', '1002806266750803970');
INSERT INTO `sys_user_role` VALUES ('1002748102537822209', '1002748319131680769');
INSERT INTO `sys_user_role` VALUES ('1002748102537822209', '1002806178141937666');
INSERT INTO `sys_user_role` VALUES ('1142248185683496961', '1002806178141937666');
INSERT INTO `sys_user_role` VALUES ('1142248185683496961', '1002806220860923906');
INSERT INTO `sys_user_role` VALUES ('1142655493320200193', '1002806220860923906');
INSERT INTO `sys_user_role` VALUES ('1142655493320200193', '1002807171923550210');
INSERT INTO `sys_user_role` VALUES ('986177923098808322', '999999888888777777');
DROP TABLE IF EXISTS `worker`;
CREATE TABLE `worker` (
`id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NOT NULL,
`code` varchar(50) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`name` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`company_id` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`mobile_phone` varchar(45) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`passwords` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`salt` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`latitude` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`longitude` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_general_ci NULL DEFAULT NULL,
`status` int(2) NULL DEFAULT NULL,
`approval` int(1) NULL DEFAULT NULL,
`sort` int(2) NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE,
INDEX `worker_companyid_idx`(`company_id`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_general_ci COMMENT = '维修工人' ROW_FORMAT = Dynamic;
INSERT INTO `worker` VALUES ('1', '2021113270', '陈晓东', '1', '15606230989', '111111', NULL, '31.971822', '120.908265', NULL, 1, 1);
INSERT INTO `worker` VALUES ('11', '2021113271', '张三', '2', '13140821339', '111111', 'xy/BAurbTgd0zvcrn8O3rw==', '31.961062', '120.898209', NULL, 1, 2);
INSERT INTO `worker` VALUES ('12', '2021113272', '李四', '3', '15501680139', '111111', 'MetfkEADycnCOnhIzERDKw==', NULL, NULL, NULL, 1, 3);
INSERT INTO `worker` VALUES ('13', '2021113273', '王五', '4', '15050314381', '111111', 'CF71IA6WBdey+g/Cm9grcA==', NULL, NULL, NULL, 1, 4);
INSERT INTO `worker` VALUES ('14', '2021113274', '王清永', '5', '15322981390', '111111', '1jidJ2YjOyc85ipvRKbbqw==', '31.972178', '120.909121', NULL, 1, 6);
INSERT INTO `worker` VALUES ('15', '2021113275', '王嘉乐', '6', '18931447812', '111111', 'r36VH38LKKjk0ArHZQrWmw==', NULL, NULL, NULL, 1, 7);
INSERT INTO `worker` VALUES ('16', '2021113276', '刘沁怡', '7', '17322091352', '111111', 'danDvHLgFwcsLuYt7u0g1A==', NULL, NULL, NULL, 1, 5);
INSERT INTO `worker` VALUES ('17', '2021113277', '王倩', '8', '13214358092', 'Rvbbqw7WthRe6ED8zg2csMlKH5/IX6Khvk7kKBT85B0=', 'hf4rdhVVso3wR+G8w+9Huw==', NULL, NULL, NULL, 1, 8);
INSERT INTO `worker` VALUES ('18', '2021113278', '李倩', '8', '15022378967', 'oEOD5FjN0ShxfeoU0mDoR7X76xIXK/XpWAKR7ZLW5tA=', '2IHsI8jCdFSJig5rxNx5wA==', NULL, NULL, NULL, 1, 9);
SET FOREIGN_KEY_CHECKS = 1;