ruoyi-vue/sql/ry_community_20220920.sql

-- ----------------------------
-- Table structure for che_addr_building
-- ----------------------------
DROP TABLE IF EXISTS `che_addr_building`;
CREATE TABLE `che_addr_building` (
  `building_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '楼栋Id',
  `number` varchar(10) DEFAULT NULL COMMENT '楼栋编号',
  `linkman` varchar(45) DEFAULT NULL COMMENT '联系人',
  `phone` varchar(20) DEFAULT NULL COMMENT '手机号',
  `estate_id` bigint(20) DEFAULT NULL COMMENT '所属小区',
  `dept_id` bigint(20) DEFAULT NULL COMMENT '所属网格',
  PRIMARY KEY (`building_id`)
) ENGINE=InnoDB AUTO_INCREMENT=32 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for che_addr_estate
-- ----------------------------
DROP TABLE IF EXISTS `che_addr_estate`;
CREATE TABLE `che_addr_estate` (
  `estate_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '小区Id',
  `name` varchar(45) DEFAULT NULL COMMENT '小区名称',
  `linkman` varchar(45) DEFAULT NULL COMMENT '联系人',
  `phone` varchar(20) DEFAULT NULL COMMENT '手机号',
  `dept_id` bigint(20) DEFAULT NULL COMMENT '所属社区',
  PRIMARY KEY (`estate_id`)
) ENGINE=InnoDB AUTO_INCREMENT=20 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for che_addr_house
-- ----------------------------
DROP TABLE IF EXISTS `che_addr_house`;
CREATE TABLE `che_addr_house` (
  `house_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '住宅Id',
  `unit` varchar(10) DEFAULT NULL COMMENT '单元',
  `floor` int(11) DEFAULT NULL COMMENT '楼层',
  `number` varchar(10) DEFAULT NULL COMMENT '门牌号',
  `building_id` bigint(20) DEFAULT NULL COMMENT '所属楼栋',
  `estate_id` bigint(20) DEFAULT NULL COMMENT '所属小区',
  `dept_id` bigint(20) DEFAULT NULL COMMENT '所属网格',
  PRIMARY KEY (`house_id`)
) ENGINE=InnoDB AUTO_INCREMENT=24 DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for che_nat_log
-- ----------------------------
DROP TABLE IF EXISTS `che_nat_log`;
CREATE TABLE `che_nat_log` (
  `nat_log_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `nat_task_id` bigint(20) DEFAULT NULL COMMENT '检测任务id',
  `resident_id` varchar(45) DEFAULT NULL COMMENT '居民id',
  `name` varchar(45) DEFAULT NULL COMMENT '姓名',
  `house_id` bigint(20) DEFAULT NULL COMMENT '住址id',
  `building_number` varchar(16) DEFAULT NULL COMMENT '楼栋编号',
  `estate_name` varchar(45) DEFAULT NULL COMMENT '小区名称',
  `grid_name` varchar(30) DEFAULT NULL COMMENT '网格编号',
  `community_name` varchar(30) DEFAULT NULL COMMENT '社区名称',
  `phone` varchar(16) DEFAULT NULL COMMENT '手机号',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `status` varchar(20) DEFAULT NULL COMMENT '状态',
  `remark` varchar(128) DEFAULT NULL  COMMENT '备注',
  PRIMARY KEY (`nat_log_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for che_nat_task
-- ----------------------------
DROP TABLE IF EXISTS `che_nat_task`;
CREATE TABLE `che_nat_task` (
  `nat_task_id` bigint(20) NOT NULL AUTO_INCREMENT,
  `name` varchar(45) DEFAULT NULL COMMENT '任务名称',
  `start_time` datetime DEFAULT NULL COMMENT '开始时间',
  `end_time` datetime DEFAULT NULL COMMENT '结束时间',
  `status` varchar(20) DEFAULT NULL COMMENT '任务状态',
  `detail` varchar(256) DEFAULT NULL COMMENT '任务详情',
  `remark` varchar(128) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`nat_task_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for che_resident
-- ----------------------------
DROP TABLE IF EXISTS `che_resident`;
CREATE TABLE `che_resident` (
  `resident_id` varchar(45) NOT NULL COMMENT '居民Id',
  `name` varchar(45) DEFAULT NULL COMMENT '姓名',
  `sex` int(11) DEFAULT NULL COMMENT '性别',
  `birthday` varchar(16) DEFAULT NULL COMMENT '出生年月',
  `phone` varchar(20) DEFAULT NULL COMMENT '手机号',
  `house_id` bigint(20) DEFAULT NULL COMMENT '住址',
  `applicant_id` varchar(45) DEFAULT NULL COMMENT '申请人ID',
  `entrusted` int(11) DEFAULT NULL COMMENT '是否代领',
  `dept_id` bigint(20) DEFAULT NULL COMMENT '所属部门',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(45) DEFAULT NULL COMMENT '备注',
  `delete_flag` int(11) DEFAULT 0 COMMENT '删除标识',
  PRIMARY KEY (`resident_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for che_resident_req
-- ----------------------------
DROP TABLE IF EXISTS `che_resident_req`;
CREATE TABLE `che_resident_req` (
  `resident_req_id` varchar(45) NOT NULL COMMENT '申请Id',
  `applicant_id` varchar(45) DEFAULT NULL COMMENT '申请人Id',
  `name` varchar(45) DEFAULT NULL COMMENT '姓名',
  `sex` int(11) DEFAULT NULL COMMENT '性别',
  `birthday` varchar(16) DEFAULT NULL COMMENT '出生年月',
  `phone` varchar(20) DEFAULT NULL COMMENT '手机号',
  `house_id` bigint(20) DEFAULT NULL COMMENT '住宅Id',
  `dept_id` bigint(20) DEFAULT NULL COMMENT '所属部门',
  `req_type` varchar(16) DEFAULT NULL COMMENT '申请类型',
  `req_status` varchar(16) DEFAULT NULL COMMENT '申请状态',
  `reject_reason` varchar(128) DEFAULT NULL COMMENT '拒绝原因',
  `entrusted` int(11) DEFAULT NULL COMMENT '是否代领',
  `resident_id` varchar(45) DEFAULT NULL COMMENT '居民ID',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(45) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`resident_req_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for biz_user
-- ----------------------------
DROP TABLE IF EXISTS `biz_user`;
CREATE TABLE `biz_user` (
  `user_id` varchar(45) NOT NULL COMMENT '用户Id',
  `name` varchar(45) DEFAULT NULL COMMENT '姓名',
  `sex` int(11) DEFAULT NULL COMMENT '性别',
  `birthday` varchar(16) DEFAULT NULL COMMENT '出生年月',
  `phone` varchar(20) NOT NULL COMMENT '手机号',
  `openid` varchar(45) NOT NULL COMMENT '微信OpenId',
  `resident_id` varchar(45) DEFAULT NULL COMMENT '居民ID',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '修改时间',
  `remark` varchar(45) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for che_rel_user_resident
-- ----------------------------
DROP TABLE IF EXISTS `che_rel_user_resident`;
CREATE TABLE `che_rel_user_resident` (
  `rel_user_resident_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '关联ID',
  `user_id` varchar(45) NOT NULL COMMENT '用户Id',
  `resident_id` varchar(45) NOT NULL COMMENT '居民Id',
  `entrusted` int(11) DEFAULT NULL COMMENT '是否代领',
  PRIMARY KEY (`rel_user_resident_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for che_activity
-- ----------------------------
DROP TABLE IF EXISTS `che_activity`;
CREATE TABLE `che_activity` (
  `activity_id` varchar(45) NOT NULL COMMENT '活动Id',
  `topic` varchar(128) DEFAULT NULL COMMENT '主题',
  `type` varchar(45) DEFAULT NULL COMMENT '类型：文体、民生、志愿、直播',
  `image` varchar(256) DEFAULT NULL COMMENT '宣传图片路径',
  `start_time` datetime DEFAULT NULL COMMENT '活动开始时间',
  `end_time` datetime DEFAULT NULL COMMENT '活动结束时间',
  `reg_start_time` datetime DEFAULT NULL COMMENT '报名开始时间',
  `reg_end_time` datetime DEFAULT NULL COMMENT '报名截止时间',
  `reg_max_count` int(11) DEFAULT NULL COMMENT '报名人数限制',
  `sponsor_type` varchar(45) DEFAULT NULL COMMENT '发起人类型：社区、用户',
  `sponsor_sys_id` varchar(45) DEFAULT NULL COMMENT '社区发起人Id',
  `sponsor_user_id` bigint(20) DEFAULT NULL COMMENT '用户发起人Id',
  `sponsor_name` varchar(128) DEFAULT NULL COMMENT '发起者',
  `sponsor_phone` varchar(20) DEFAULT NULL COMMENT '联系电话',
  `description`     longblob COMMENT '内容',
  `status` varchar(16) DEFAULT NULL COMMENT '活动状态',
  `point` int(11) DEFAULT NULL COMMENT '奖励积分',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(45) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`activity_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for che_activity_log
-- ----------------------------
DROP TABLE IF EXISTS `che_activity_log`;
CREATE TABLE `che_activity_log` (
  `activity_log_id` varchar(45) NOT NULL COMMENT '活动记录Id',
  `activity_id` varchar(45) NOT NULL COMMENT '活动Id',
  `user_id` varchar(45) NOT NULL COMMENT '用户Id',
  `checkin_status` varchar(16) DEFAULT NULL COMMENT '签到状态：未签到，已签到',
  `point_status` varchar(16) DEFAULT NULL COMMENT '积分发放状态：未发放，已发放',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  PRIMARY KEY (`activity_log_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for che_activity_photo
-- ----------------------------
DROP TABLE IF EXISTS `che_activity_photo`;
CREATE TABLE `che_activity_photo` (
  `activity_photo_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '活动图片Id',
  `activity_log_id` varchar(45) NOT NULL COMMENT '活动记录Id',
  `photo` varchar(256) NOT NULL COMMENT '图片路径',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  PRIMARY KEY (`activity_photo_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for che_points
-- ----------------------------
DROP TABLE IF EXISTS `che_points`;
CREATE TABLE `che_points` (
  `user_id` varchar(45) NOT NULL COMMENT '用户Id',
  `honor_points` int(11) DEFAULT NULL COMMENT '荣誉积分',
  `spend_points` int(11) DEFAULT NULL COMMENT '消费积分',
  PRIMARY KEY (`user_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for che_points_log
-- ----------------------------
DROP TABLE IF EXISTS `che_points_log`;
CREATE TABLE `che_points_log` (
  `points_log_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '自增ID',
  `user_id` varchar(45) NOT NULL COMMENT '用户Id',
  `change_type` varchar(45) NOT NULL COMMENT '变更类型：增加，减少',
  `change_points` int(11) NOT NULL COMMENT '变更数值',
  `change_reason` varchar(128) NOT NULL COMMENT '变更原因',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `relation_id` varchar(45) DEFAULT NULL COMMENT '变更事件关联Id',
  PRIMARY KEY (`points_log_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for che_dangyuan
-- ----------------------------
DROP TABLE IF EXISTS `che_dangyuan`;
CREATE TABLE `che_dangyuan` (
  `dangyuan_id` varchar(45) NOT NULL COMMENT '党员Id',
  `user_id` varchar(45) NOT NULL COMMENT '用户Id',
  `name` varchar(45) DEFAULT NULL COMMENT '姓名',
  `sex` int(11) DEFAULT NULL COMMENT '性别',
  `dept_id` bigint(20) DEFAULT NULL COMMENT '报到社区',
  `work_unit` varchar(256) DEFAULT NULL COMMENT '工作单位',
  `report_location` varchar(256) DEFAULT NULL COMMENT '报道位置',
  `report_type` varchar(45)  DEFAULT NULL COMMENT '报道类别',
  `residence` varchar(256) DEFAULT NULL COMMENT '居住地',
  `phone` varchar(20) DEFAULT NULL COMMENT '联系方式',
  `content` varchar(256) DEFAULT NULL COMMENT '服务内容',
  `video_path` varchar(256)  DEFAULT NULL COMMENT '影像资料',
  `status` int(11) DEFAULT NULL COMMENT '当前状态',
  `reject_reason` varchar(128) DEFAULT NULL COMMENT '驳回原因',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(45) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`dangyuan_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for che_xiachenganbu
-- ----------------------------
DROP TABLE IF EXISTS `che_xiachenganbu`;
CREATE TABLE `che_xiachenganbu` (
  `xiachenganbu_id` varchar(45) NOT NULL COMMENT '下沉干部Id',
  `user_id` varchar(45) NOT NULL COMMENT '用户Id',
  `name` varchar(45) DEFAULT NULL COMMENT '姓名',
  `sex` int(11) DEFAULT NULL COMMENT '性别',
  `dept_id` bigint(20) DEFAULT NULL COMMENT '报到社区',
  `work_unit` varchar(256) DEFAULT NULL COMMENT '工作单位',
  `baobaoloudong` varchar(256) DEFAULT NULL COMMENT '包保楼栋',
  `phone` varchar(20) DEFAULT NULL COMMENT '联系方式',
  `jianrensanzhang` int(11) DEFAULT NULL COMMENT '是否兼任三长',
  `status` int(11) DEFAULT NULL COMMENT '当前状态',
  `reject_reason` varchar(128) DEFAULT NULL COMMENT '驳回原因',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(45) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`xiachenganbu_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for che_recruit
-- ----------------------------
DROP TABLE IF EXISTS `che_recruit`;
CREATE TABLE `che_recruit` (
  `recruit_id` varchar(45) NOT NULL COMMENT '招募信息Id',
  `topic` varchar(128) DEFAULT NULL COMMENT '主题',
  `content` longblob COMMENT '内容',
  `count` int(11) DEFAULT NULL COMMENT '计划招募人数',
  `sponsor_name` varchar(128) DEFAULT NULL COMMENT '发起者',
  `sponsor_phone` varchar(20) DEFAULT NULL COMMENT '联系电话',
  `start_time` datetime DEFAULT NULL COMMENT '活动开始时间',
  `end_time` datetime DEFAULT NULL COMMENT '活动结束时间',
  `status` varchar(16) DEFAULT NULL COMMENT '状态',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(45) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`recruit_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for che_recruit_log
-- ----------------------------
DROP TABLE IF EXISTS `che_recruit_log`;
CREATE TABLE `che_recruit_log` (
  `recruit_log_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '招募记录Id',
  `recruit_id` varchar(45) NOT NULL COMMENT '招募信息Id',
  `user_id` varchar(45) NOT NULL COMMENT '报名用户Id',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '更新时间',
  `remark` varchar(45) DEFAULT NULL COMMENT '备注',
  PRIMARY KEY (`recruit_log_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

-- ----------------------------
-- Table structure for che_dangjian_clockin
-- ----------------------------
DROP TABLE IF EXISTS `che_dangjian_clockin`;
CREATE TABLE `che_dangjian_clockin` (
  `dangjian_clockin_id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '自增ID',
  `user_id` varchar(45) NOT NULL COMMENT '用户Id',
  `dept_id` bigint(20) DEFAULT NULL COMMENT '签到社区',
  `description` varchar(256) DEFAULT NULL COMMENT '服务内容',
  `photo` varchar(256) NOT NULL COMMENT '图片路径',
  `clockin_time` datetime DEFAULT NULL COMMENT '签到时间',
  PRIMARY KEY (`dangjian_clockin_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;

delimiter $$
DROP TRIGGER IF EXISTS `tri_building_update` $$
CREATE TRIGGER `tri_building_update` AFTER UPDATE ON `che_addr_building` FOR EACH ROW
BEGIN
    UPDATE che_addr_house SET dept_id = NEW.dept_id where building_id = NEW.building_id;
END $$
delimiter;

--
-- -- ----------------------------
-- -- Insert data for sys_menu
-- -- ----------------------------
-- INSERT INTO `sys_menu` (`menu_id`,`menu_name`,`parent_id`,`order_num`,`path`,`component`,`query`,`is_frame`,`is_cache`,`menu_type`,`visible`,`status`,`perms`,`icon`,`create_by`,`create_time`,`update_by`,`update_time`,`remark`) VALUES (3000,'社区管理',0,3,'community',NULL,NULL,1,0,'M','0','0','','international','admin','2022-09-19 09:45:32','admin','2022-09-19 09:51:28','');
-- INSERT INTO `sys_menu` (`menu_id`,`menu_name`,`parent_id`,`order_num`,`path`,`component`,`query`,`is_frame`,`is_cache`,`menu_type`,`visible`,`status`,`perms`,`icon`,`create_by`,`create_time`,`update_by`,`update_time`,`remark`) VALUES (3001,'地址管理',3000,1,'addr',NULL,NULL,1,0,'M','0','0','','tree-table','admin','2022-09-19 09:45:45','admin','2022-09-19 09:53:03','');
-- INSERT INTO `sys_menu` (`menu_id`,`menu_name`,`parent_id`,`order_num`,`path`,`component`,`query`,`is_frame`,`is_cache`,`menu_type`,`visible`,`status`,`perms`,`icon`,`create_by`,`create_time`,`update_by`,`update_time`,`remark`) VALUES (3002,'居民管理',3000,2,'resident',NULL,NULL,1,0,'M','0','0','','peoples','admin','2022-09-19 09:45:59','admin','2022-09-19 09:51:59','');
-- INSERT INTO `sys_menu` (`menu_id`,`menu_name`,`parent_id`,`order_num`,`path`,`component`,`query`,`is_frame`,`is_cache`,`menu_type`,`visible`,`status`,`perms`,`icon`,`create_by`,`create_time`,`update_by`,`update_time`,`remark`) VALUES (3003,'检测任务',3000,3,'nat',NULL,NULL,1,0,'M','0','0','','list','admin','2022-09-19 09:46:15','admin','2022-09-19 09:52:14','');
-- INSERT INTO `sys_menu` (`menu_id`,`menu_name`,`parent_id`,`order_num`,`path`,`component`,`query`,`is_frame`,`is_cache`,`menu_type`,`visible`,`status`,`perms`,`icon`,`create_by`,`create_time`,`update_by`,`update_time`,`remark`) VALUES (3004,'小区管理',3001,1,'estate','community/estate/index',NULL,1,0,'C','0','0','community:estate:list','#','admin','2022-09-19 09:47:09','',NULL,'');
-- INSERT INTO `sys_menu` (`menu_id`,`menu_name`,`parent_id`,`order_num`,`path`,`component`,`query`,`is_frame`,`is_cache`,`menu_type`,`visible`,`status`,`perms`,`icon`,`create_by`,`create_time`,`update_by`,`update_time`,`remark`) VALUES (3016,'楼栋管理',3001,2,'building','community/building/index',NULL,1,0,'C','0','0','community:building:list','#','admin','2022-09-20 08:09:42','admin','2022-09-21 07:52:33','楼栋管理菜单');
-- INSERT INTO `sys_menu` (`menu_id`,`menu_name`,`parent_id`,`order_num`,`path`,`component`,`query`,`is_frame`,`is_cache`,`menu_type`,`visible`,`status`,`perms`,`icon`,`create_by`,`create_time`,`update_by`,`update_time`,`remark`) VALUES (3005,'住宅管理',3001,3,'house','community/house/index',NULL,1,0,'C','0','0','community:house:list','#','admin','2022-09-19 09:47:48','admin','2022-09-21 07:52:43','');
-- INSERT INTO `sys_menu` (`menu_id`,`menu_name`,`parent_id`,`order_num`,`path`,`component`,`query`,`is_frame`,`is_cache`,`menu_type`,`visible`,`status`,`perms`,`icon`,`create_by`,`create_time`,`update_by`,`update_time`,`remark`) VALUES (3006,'居民信息',3002,1,'resident','community/resident/index',NULL,1,0,'C','0','0','community:resident:list','#','admin','2022-09-19 09:48:57','',NULL,'');
-- INSERT INTO `sys_menu` (`menu_id`,`menu_name`,`parent_id`,`order_num`,`path`,`component`,`query`,`is_frame`,`is_cache`,`menu_type`,`visible`,`status`,`perms`,`icon`,`create_by`,`create_time`,`update_by`,`update_time`,`remark`) VALUES (3007,'审核申请',3002,2,'req','community/req/index',NULL,1,0,'C','0','0','community:req:list','#','admin','2022-09-19 09:49:34','',NULL,'');
-- INSERT INTO `sys_menu` (`menu_id`,`menu_name`,`parent_id`,`order_num`,`path`,`component`,`query`,`is_frame`,`is_cache`,`menu_type`,`visible`,`status`,`perms`,`icon`,`create_by`,`create_time`,`update_by`,`update_time`,`remark`) VALUES (3008,'任务管理',3003,1,'task','community/task/index',NULL,1,0,'C','0','0','community:task:list','#','admin','2022-09-19 09:50:04','',NULL,'');
-- INSERT INTO `sys_menu` (`menu_id`,`menu_name`,`parent_id`,`order_num`,`path`,`component`,`query`,`is_frame`,`is_cache`,`menu_type`,`visible`,`status`,`perms`,`icon`,`create_by`,`create_time`,`update_by`,`update_time`,`remark`) VALUES (3009,'检测记录',3003,2,'log','community/log/index',NULL,1,0,'C','0','0','community:log:list','#','admin','2022-09-19 09:50:49','',NULL,'');
--
-- -- ----------------------------
-- -- Insert data for estateMenu
-- -- ----------------------------
-- -- 菜单 SQL
-- insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
-- values('小区管理', '3004', '1', 'estate', 'community/estate/index', 1, 0, 'C', '0', '0', 'community:estate:list', '#', 'admin', sysdate(), '', null, '小区管理菜单');
--
-- -- 按钮父菜单ID
-- SELECT @parentId := LAST_INSERT_ID();
--
-- -- 按钮 SQL
-- insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
-- values('小区管理查询', @parentId, '1',  '#', '', 1, 0, 'F', '0', '0', 'community:estate:query',        '#', 'admin', sysdate(), '', null, '');
--
-- insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
-- values('小区管理新增', @parentId, '2',  '#', '', 1, 0, 'F', '0', '0', 'community:estate:add',          '#', 'admin', sysdate(), '', null, '');
--
-- insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
-- values('小区管理修改', @parentId, '3',  '#', '', 1, 0, 'F', '0', '0', 'community:estate:edit',         '#', 'admin', sysdate(), '', null, '');
--
-- insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
-- values('小区管理删除', @parentId, '4',  '#', '', 1, 0, 'F', '0', '0', 'community:estate:remove',       '#', 'admin', sysdate(), '', null, '');
--
-- insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
-- values('小区管理导出', @parentId, '5',  '#', '', 1, 0, 'F', '0', '0', 'community:estate:export',       '#', 'admin', sysdate(), '', null, '');
--
--
-- -- ----------------------------
-- -- Insert data for buildingMenu
-- -- ----------------------------
-- -- 菜单 SQL
-- insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
-- values('楼栋管理', '3004', '1', 'building', 'community/building/index', 1, 0, 'C', '0', '0', 'community:building:list', '#', 'admin', sysdate(), '', null, '楼栋管理菜单');
--
-- -- 按钮父菜单ID
-- SELECT @parentId := LAST_INSERT_ID();
--
-- -- 按钮 SQL
-- insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
-- values('楼栋管理查询', @parentId, '1',  '#', '', 1, 0, 'F', '0', '0', 'community:building:query',        '#', 'admin', sysdate(), '', null, '');
--
-- insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
-- values('楼栋管理新增', @parentId, '2',  '#', '', 1, 0, 'F', '0', '0', 'community:building:add',          '#', 'admin', sysdate(), '', null, '');
--
-- insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
-- values('楼栋管理修改', @parentId, '3',  '#', '', 1, 0, 'F', '0', '0', 'community:building:edit',         '#', 'admin', sysdate(), '', null, '');
--
-- insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
-- values('楼栋管理删除', @parentId, '4',  '#', '', 1, 0, 'F', '0', '0', 'community:building:remove',       '#', 'admin', sysdate(), '', null, '');
--
-- insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
-- values('楼栋管理导出', @parentId, '5',  '#', '', 1, 0, 'F', '0', '0', 'community:building:export',       '#', 'admin', sysdate(), '', null, '');
--
-- -- ----------------------------
-- -- Insert data for houseMenu
-- -- ----------------------------
-- -- 菜单 SQL
-- insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
-- values('住宅管理', '3005', '1', 'house', 'community/house/index', 1, 0, 'C', '0', '0', 'community:house:list', '#', 'admin', sysdate(), '', null, '住宅管理菜单');
--
-- -- 按钮父菜单ID
-- SELECT @parentId := LAST_INSERT_ID();
--
-- -- 按钮 SQL
-- insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
-- values('住宅管理查询', @parentId, '1',  '#', '', 1, 0, 'F', '0', '0', 'community:house:query',        '#', 'admin', sysdate(), '', null, '');
--
-- insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
-- values('住宅管理新增', @parentId, '2',  '#', '', 1, 0, 'F', '0', '0', 'community:house:add',          '#', 'admin', sysdate(), '', null, '');
--
-- insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
-- values('住宅管理修改', @parentId, '3',  '#', '', 1, 0, 'F', '0', '0', 'community:house:edit',         '#', 'admin', sysdate(), '', null, '');
--
-- insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
-- values('住宅管理删除', @parentId, '4',  '#', '', 1, 0, 'F', '0', '0', 'community:house:remove',       '#', 'admin', sysdate(), '', null, '');
--
-- insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
-- values('住宅管理导出', @parentId, '5',  '#', '', 1, 0, 'F', '0', '0', 'community:house:export',       '#', 'admin', sysdate(), '', null, '');
--
-- -- ----------------------------
-- -- Insert data for residentMenu
-- -- ----------------------------
-- -- 菜单 SQL
-- insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
-- values('居民信息管理', '3006', '1', 'resident', 'community/resident/index', 1, 0, 'C', '0', '0', 'community:resident:list', '#', 'admin', sysdate(), '', null, '居民信息管理菜单');
--
-- -- 按钮父菜单ID
-- SELECT @parentId := LAST_INSERT_ID();
--
-- -- 按钮 SQL
-- insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
-- values('居民信息管理查询', @parentId, '1',  '#', '', 1, 0, 'F', '0', '0', 'community:resident:query',        '#', 'admin', sysdate(), '', null, '');
--
-- insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
-- values('居民信息管理新增', @parentId, '2',  '#', '', 1, 0, 'F', '0', '0', 'community:resident:add',          '#', 'admin', sysdate(), '', null, '');
--
-- insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
-- values('居民信息管理修改', @parentId, '3',  '#', '', 1, 0, 'F', '0', '0', 'community:resident:edit',         '#', 'admin', sysdate(), '', null, '');
--
-- insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
-- values('居民信息管理删除', @parentId, '4',  '#', '', 1, 0, 'F', '0', '0', 'community:resident:remove',       '#', 'admin', sysdate(), '', null, '');
--
-- insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
-- values('居民信息管理导出', @parentId, '5',  '#', '', 1, 0, 'F', '0', '0', 'community:resident:export',       '#', 'admin', sysdate(), '', null, '');
--
-- -- ----------------------------
-- -- Insert data for reqMenu
-- -- ----------------------------
-- -- 菜单 SQL
-- insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
-- values('审核申请', '3007', '1', 'req', 'community/req/index', 1, 0, 'C', '0', '0', 'community:req:list', '#', 'admin', sysdate(), '', null, '审核申请菜单');
--
-- -- 按钮父菜单ID
-- SELECT @parentId := LAST_INSERT_ID();
--
-- -- 按钮 SQL
-- insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
-- values('审核申请查询', @parentId, '1',  '#', '', 1, 0, 'F', '0', '0', 'community:req:query',        '#', 'admin', sysdate(), '', null, '');
--
-- insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
-- values('审核申请新增', @parentId, '2',  '#', '', 1, 0, 'F', '0', '0', 'community:req:add',          '#', 'admin', sysdate(), '', null, '');
--
-- insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
-- values('审核申请修改', @parentId, '3',  '#', '', 1, 0, 'F', '0', '0', 'community:req:edit',         '#', 'admin', sysdate(), '', null, '');
--
-- insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
-- values('审核申请删除', @parentId, '4',  '#', '', 1, 0, 'F', '0', '0', 'community:req:remove',       '#', 'admin', sysdate(), '', null, '');
--
-- insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
-- values('审核申请导出', @parentId, '5',  '#', '', 1, 0, 'F', '0', '0', 'community:req:export',       '#', 'admin', sysdate(), '', null, '');
--
-- -- ----------------------------
-- -- Insert data for wechatMenu
-- -- ----------------------------
-- -- 菜单 SQL
-- insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
-- values('微信信息管理', '3002', '1', 'wechat', 'community/wechat/index', 1, 0, 'C', '0', '0', 'community:wechat:list', '#', 'admin', sysdate(), '', null, '微信信息管理菜单');
--
-- -- 按钮父菜单ID
-- SELECT @parentId := LAST_INSERT_ID();
--
-- -- 按钮 SQL
-- insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
-- values('微信信息管理查询', @parentId, '1',  '#', '', 1, 0, 'F', '0', '0', 'community:wechat:query',        '#', 'admin', sysdate(), '', null, '');
--
-- insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
-- values('微信信息管理新增', @parentId, '2',  '#', '', 1, 0, 'F', '0', '0', 'community:wechat:add',          '#', 'admin', sysdate(), '', null, '');
--
-- insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
-- values('微信信息管理修改', @parentId, '3',  '#', '', 1, 0, 'F', '0', '0', 'community:wechat:edit',         '#', 'admin', sysdate(), '', null, '');
--
-- insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
-- values('微信信息管理删除', @parentId, '4',  '#', '', 1, 0, 'F', '0', '0', 'community:wechat:remove',       '#', 'admin', sysdate(), '', null, '');
--
-- insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
-- values('微信信息管理导出', @parentId, '5',  '#', '', 1, 0, 'F', '0', '0', 'community:wechat:export',       '#', 'admin', sysdate(), '', null, '');
--
-- -- ----------------------------
-- -- Insert data for taskMenu
-- -- ----------------------------
-- -- 菜单 SQL
-- insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
-- values('检测任务管理', '3008', '1', 'task', 'community/task/index', 1, 0, 'C', '0', '0', 'community:task:list', '#', 'admin', sysdate(), '', null, '检测任务管理菜单');
--
-- -- 按钮父菜单ID
-- SELECT @parentId := LAST_INSERT_ID();
--
-- -- 按钮 SQL
-- insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
-- values('检测任务管理查询', @parentId, '1',  '#', '', 1, 0, 'F', '0', '0', 'community:task:query',        '#', 'admin', sysdate(), '', null, '');
--
-- insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
-- values('检测任务管理新增', @parentId, '2',  '#', '', 1, 0, 'F', '0', '0', 'community:task:add',          '#', 'admin', sysdate(), '', null, '');
--
-- insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
-- values('检测任务管理修改', @parentId, '3',  '#', '', 1, 0, 'F', '0', '0', 'community:task:edit',         '#', 'admin', sysdate(), '', null, '');
--
-- insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
-- values('检测任务管理删除', @parentId, '4',  '#', '', 1, 0, 'F', '0', '0', 'community:task:remove',       '#', 'admin', sysdate(), '', null, '');
--
-- insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
-- values('检测任务管理导出', @parentId, '5',  '#', '', 1, 0, 'F', '0', '0', 'community:task:export',       '#', 'admin', sysdate(), '', null, '');
--
-- -- ----------------------------
-- -- Insert data for logMenu
-- -- ----------------------------
-- -- 菜单 SQL
-- insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
-- values('检测日志管理', '3009', '1', 'log', 'community/log/index', 1, 0, 'C', '0', '0', 'community:log:list', '#', 'admin', sysdate(), '', null, '检测日志管理菜单');
--
-- -- 按钮父菜单ID
-- SELECT @parentId := LAST_INSERT_ID();
--
-- -- 按钮 SQL
-- insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
-- values('检测日志管理查询', @parentId, '1',  '#', '', 1, 0, 'F', '0', '0', 'community:log:query',        '#', 'admin', sysdate(), '', null, '');
--
-- insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
-- values('检测日志管理新增', @parentId, '2',  '#', '', 1, 0, 'F', '0', '0', 'community:log:add',          '#', 'admin', sysdate(), '', null, '');
--
-- insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
-- values('检测日志管理修改', @parentId, '3',  '#', '', 1, 0, 'F', '0', '0', 'community:log:edit',         '#', 'admin', sysdate(), '', null, '');
--
-- insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
-- values('检测日志管理删除', @parentId, '4',  '#', '', 1, 0, 'F', '0', '0', 'community:log:remove',       '#', 'admin', sysdate(), '', null, '');
--
-- insert into sys_menu (menu_name, parent_id, order_num, path, component, is_frame, is_cache, menu_type, visible, status, perms, icon, create_by, create_time, update_by, update_time, remark)
-- values('检测日志管理导出', @parentId, '5',  '#', '', 1, 0, 'F', '0', '0', 'community:log:export',       '#', 'admin', sysdate(), '', null, '');