1 数据库 iot_service_pod
注： 生产已执行：
create table smart_cmty_space_extra(
id bigint(20) auto_increment,
key_name varchar(32) not null comment '字段名',
value varchar(64) not null comment '字段值',
space_id bigint not null comment '空间ID',
space_type varchar(32) not null comment '空间type',
unique key unique_space_id_key(space_id, key_name),
PRIMARY KEY(id),
KEY index_key_name (key_name)
) comment '空间拓展表' ;
alter TABLE `smart_cmty_space_location`
add column `community_introduce` varchar(500) DEFAULT NULL COMMENT '项目介绍',
add column `community_area` varchar(500) DEFAULT NULL COMMENT '项目面积',
add column `community_area_unit` tinyint(1) DEFAULT NULL COMMENT '项目面积的单位。枚举值：1:平方米；2:亩；3:公顷',
add column `community_delivery_status` tinyint(1) DEFAULT NULL COMMENT '项目交付状态。枚举值：0:未交付；1:已交付',
add column `community_delivery_date` datetime DEFAULT NULL COMMENT '项目交楼日期',
add column `community_phone` varchar(30) DEFAULT NULL COMMENT '项目联系电话';
CREATE TABLE `smart_cmty_house_lease_member_rel` (
`id` int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
`lease_id` int(11) DEFAULT null COMMENT '承租表主键id',
`space_id` int(11) DEFAULT null COMMENT '空间ID',
`customer_id` int(11) NOT NULL COMMENT '租户成员客户ID',
`person_name` varchar(32) COLLATE utf8mb4_bin NOT NULL COMMENT '租户成员名称',
`contact_phone` varchar(32) COLLATE utf8mb4_bin NOT NULL DEFAULT '' COMMENT '租户成员电话',
`lease_status` int(11) DEFAULT NULL COMMENT '承租状态 1承租2退租',
`create_by` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '创建人',
`create_time` datetime DEFAULT NULL COMMENT '创建时间',
`update_by` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '更新人',
`update_time` datetime DEFAULT NULL COMMENT '更新时间',
`create_by_id` varchar(255) COLLATE utf8mb4_bin DEFAULT null COMMENT '创建人ID',
`update_by_id` varchar(255) COLLATE utf8mb4_bin DEFAULT NULL COMMENT '更新人ID',
PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin COMMENT='租户和租户成员关联关系表';
alter TABLE smart_cmty_house_lease_member_rel
add index index_lease_id(lease_id),
add index index_space_id(space_id),
add index index_customer_id(customer_id);
alter TABLE smart_cmty_house_lease
add index index_space_id(space_id),
add index index_customer_id(customer_id);
alter table smart_customer_house_rel_record add column settle smallint default 1 comment '1:常住，2:不常住';
alter table smart_cmty_auth modify column space_code varchar(300) not null ;
alter table smart_cmty_auth add key index_key_space_code (space_code);
create table smart_cmty_admin_org_rel(
id bigint not null primary key,
admin_id bigint not null ,
org_id bigint not null,
create_by varchar(32),
create_by_id varchar(18),
update_by varchar(32),
update_by_id varchar(18),
create_time timestamp,
update_time timestamp,
UNIQUE KEY index_admin_org_id (admin_id,org_id)
);
alter table smart_cmty_admin_org_rel add column org_code varchar(128) ;
create index index_org_id on smart_cmty_admin_org_rel (org_id);
create index index_admin_id on smart_cmty_admin_org_rel (admin_id);
create index index_org_id on smart_cmty_org_role_admin_rel (org_id);
create index index_org_id on smart_cmty_org_role_menu_rel (org_id);
create index index_org_id on smart_cmty_org_menu_rel (org_id);
create index index_name on smart_cmty_role (name);
create index index_mobile on smart_cmty_admin(mobile);
create index index_space_name on smart_cmty_space (space_name);
create index index_top_org_code on smart_cmty_space (top_org_code);
create table smart_cmty_role_scene(
id bigint not null primary key,
role_id bigint not null,
role_code varchar(32) not null ,
business_code varchar(32) not null,
create_by varchar(32),
create_by_id varchar(18),
update_by varchar(32),
update_by_id varchar(18),
create_time timestamp,
update_time timestamp,
UNIQUE KEY index_ (role_id, role_code, business_code)
);
alter table smart_cmty_role_scen add key index_key_role_code (role_code);
alter table smart_cmty_role_scen add key index_key_role_code (business_code);
alter table smart_cmty_menu add column apis varchar(300);
alter table smart_cmty_menu add column extra varchar(300);
CREATE UNIQUE INDEX uni_menu_code ON smart_cmty_menu(menu_code);
delete from smart_cmty_menu;
alter table smart_cmty_menu add column apis varchar(300);
alter table smart_cmty_menu add column extra varchar(300);
INSERT INTO smart_cmty_menu (id,menu_code,menu_name,parent_code,parentid,menu_type,menu_url,full_menu_name,create_by,create_time,update_by,update_time,parent_name,identifier,create_by_id,update_by_id,zt_update_time,zt_create_time,apis,extra) VALUES
(303576,'100000','控制台',NULL,NULL,2,'/console','控制台','supperadm','2022-08-13 09:55:26','supperadm','2022-08-13 09:55:26',NULL,'console',NULL,NULL,'2022-08-13 09:55:25','2022-08-10 09:53:13','',''),
(303587,'100001','智慧人行',NULL,NULL,2,'#','智慧人行','supperadm','2022-08-10 11:41:45','supperadm','2022-08-10 11:41:45',NULL,'people',NULL,NULL,'2022-08-10 11:41:44','2022-08-10 11:41:44',NULL,NULL),
(303588,'100002','智慧车行',NULL,NULL,2,'#','智慧车行','supperadm','2022-08-10 11:43:42','supperadm','2022-08-10 11:43:42',NULL,'parking',NULL,NULL,'2022-08-10 11:43:41','2022-08-10 11:43:41',NULL,NULL),
(303589,'100002100000','临停缴费','100002',303588,2,'/smart-parking/temporary-fee/index','智慧车行/临停缴费','supperadm','2022-08-13 09:56:04','supperadm','2022-08-13 09:56:04','智慧车行','parking-temporary-fee',NULL,NULL,'2022-08-13 09:56:03','2022-08-10 11:46:26','',''),
(303590,'100003','智慧安防',NULL,NULL,2,'#','发卡管理','supperadm','2022-08-10 14:23:22','supperadm','2022-08-10 14:23:22',NULL,'smartGuard',NULL,NULL,'2022-08-10 14:23:22','2022-08-10 13:53:53',NULL,NULL),
(303591,'100002100001','通行管理','100002',303588,2,'#','智慧车行/通行管理','supperadm','2022-08-10 13:55:54','supperadm','2022-08-10 13:55:54','智慧车行','parking-pass-manage',NULL,NULL,'2022-08-10 13:55:54','2022-08-10 13:55:54',NULL,NULL),
(303592,'100002100001100000','进出场记录','100002100001',303591,2,'/smart-parking/park/pass-inout-log','通行管理/进出场记录','supperadm','2022-08-13 09:57:10','supperadm','2022-08-13 09:57:10','通行管理','parking-pass-inout-log',NULL,NULL,'2022-08-13 09:57:09','2022-08-10 13:57:08','',''),
(303593,'100002100001100001','免费放行','100002100001',303591,2,'/smart-parking/audit-management/free-release','通行管理/免费放行','supperadm','2022-08-13 09:57:09','supperadm','2022-08-13 09:57:09','通行管理','parking-free-pass',NULL,NULL,'2022-08-13 09:57:09','2022-08-10 13:57:38','',''),
(303594,'100002100001100002','异常进出记录','100002100001',303591,2,'/smart-parking/park/abnormal-pass-log','通行管理/异常进出记录','supperadm','2022-08-13 09:57:09','supperadm','2022-08-13 09:57:09','通行管理','parking-abnormal-pass-log',NULL,NULL,'2022-08-13 09:57:09','2022-08-10 13:58:06','',''),
(303595,'100002100001100003','频繁进出车辆','100002100001',303591,2,'/smart-parking/park/frequency-inout-car','通行管理/频繁进出车辆','supperadm','2022-08-13 09:57:09','supperadm','2022-08-13 09:57:09','通行管理','parking-frequency-inout-car',NULL,NULL,'2022-08-13 09:57:09','2022-08-10 13:58:35','','');
INSERT INTO smart_cmty_menu (id,menu_code,menu_name,parent_code,parentid,menu_type,menu_url,full_menu_name,create_by,create_time,update_by,update_time,parent_name,identifier,create_by_id,update_by_id,zt_update_time,zt_create_time,apis,extra) VALUES
(303603,'100002100002','发卡管理','100002',303588,2,'#','智慧车行/发卡管理','supperadm','2022-08-10 14:24:24','supperadm','2022-08-10 14:24:24','智慧车行','parking-card-manage',NULL,NULL,'2022-08-10 14:24:24','2022-08-10 14:24:24',NULL,NULL),
(303628,'100002100003','人车管理','100002',303588,2,'#','智慧车行/人车管理','supperadm','2022-08-10 15:05:26','supperadm','2022-08-10 15:05:26','智慧车行','parking-car-owner',NULL,NULL,'2022-08-10 15:05:25','2022-08-10 15:05:25',NULL,NULL),
(303644,'100004','智慧设备',NULL,NULL,2,'#','智慧设备','supperadm','2022-08-10 15:51:39','supperadm','2022-08-10 15:51:39',NULL,'smartDevice',NULL,NULL,'2022-08-10 15:51:38','2022-08-10 15:17:43',NULL,NULL),
(303645,'100002100004','锁车管理','100002',303588,2,'/smart-parking/lock-car-management/index','智慧车行/锁车管理','supperadm','2022-08-13 09:56:03','supperadm','2022-08-13 09:56:03','智慧车行','parking-lock-car-management',NULL,NULL,'2022-08-13 09:56:02','2022-08-10 15:18:33','',''),
(303646,'100002100005','稽核管理','100002',303588,2,'#','智慧车行/稽核管理','supperadm','2022-08-10 15:24:08','supperadm','2022-08-10 15:24:08','智慧车行','parking-smart-parking-manage',NULL,NULL,'2022-08-10 15:24:08','2022-08-10 15:24:08',NULL,NULL),
(303647,'100002100006','对账管理','100002',303588,2,'#','智慧车行/对账管理','supperadm','2022-08-10 15:25:16','supperadm','2022-08-10 15:25:16','智慧车行','parking-accout-manage',NULL,NULL,'2022-08-10 15:25:16','2022-08-10 15:25:16',NULL,NULL),
(303648,'100002100007','经营报表','100002',303588,2,'#','智慧车行/对账管理','supperadm','2022-08-10 15:36:37','supperadm','2022-08-10 15:36:37','智慧车行','parking-smart-parking-table',NULL,NULL,'2022-08-10 15:36:36','2022-08-10 15:25:44',NULL,NULL),
(303649,'100002100008','车场管理','100002',303588,2,'#','智慧车行/车场管理','supperadm','2022-08-13 10:08:29','supperadm','2022-08-13 10:08:29','智慧车行','parking-smart-parking',NULL,NULL,'2022-08-13 10:08:29','2022-08-10 15:25:54','',''),
(303650,'100002100009','基础配置','100002',303588,2,'#','智慧车行/系统管理','supperadm','2022-08-13 10:10:08','supperadm','2022-08-13 10:10:08','智慧车行','parking-base-config',NULL,NULL,'2022-08-13 10:10:08','2022-08-10 15:26:04','',''),
(303657,'100002100006100000','月卡收费对账','100002100006',303647,2,'/smart-parking/account-check/account-check-month','对账管理/月卡收费对账','supperadm','2022-08-13 10:06:20','supperadm','2022-08-13 10:06:20','对账管理','parking-account-check-month',NULL,NULL,'2022-08-13 10:06:19','2022-08-10 15:33:46','','');
INSERT INTO smart_cmty_menu (id,menu_code,menu_name,parent_code,parentid,menu_type,menu_url,full_menu_name,create_by,create_time,update_by,update_time,parent_name,identifier,create_by_id,update_by_id,zt_update_time,zt_create_time,apis,extra) VALUES
(303658,'100002100006100089','停车收费对账','100002100006',303647,2,'/smart-parking/account-check/account-check-temp','对账管理/停车收费对账','supperadm','2022-08-13 10:06:20','supperadm','2022-08-13 10:06:20','对账管理','parking-account-check-temp',NULL,NULL,'2022-08-22 13:09:12','2022-08-10 15:33:46','',''),
(303659,'100002100006100001','异常收费对账','100002100006',303647,2,'/smart-parking/account-check/account-check-abnormal','对账管理/异常收费对账','supperadm','2022-08-13 10:06:20','supperadm','2022-08-13 10:06:20','对账管理','parking-account-check-abnormal',NULL,NULL,'2022-08-13 10:06:19','2022-08-10 15:33:46','',''),
(303664,'100002100008100000','车场配置','100002100008',303649,2,'/smart-parking/parking-lot-management/list','车场管理/车场配置','supperadm','2022-08-13 10:07:41','supperadm','2022-08-13 10:07:41','车场管理','parking-parking-lot-config',NULL,NULL,'2022-08-13 10:07:41','2022-08-10 15:40:41','',''),
(303665,'100002100008100001','区域管理','100002100008',303649,2,'/smart-parking/parking-lot-management/area-management','车场管理/区域管理','supperadm','2022-08-13 10:07:42','supperadm','2022-08-13 10:07:42','车场管理','parking-area-management',NULL,NULL,'2022-08-13 10:07:41','2022-08-10 15:40:42','',''),
(303666,'100002100008100002','通道管理','100002100008',303649,2,'/smart-parking/parking-lot-management/channel-management','车场管理/通道管理','supperadm','2022-08-13 10:07:41','supperadm','2022-08-13 10:07:41','车场管理','parking-channel-management',NULL,NULL,'2022-08-13 10:07:40','2022-08-10 15:40:42','',''),
(303667,'100002100008100003','设备管理','100002100008',303649,2,'/smart-parking/parking-lot-management/device-management','车场管理/设备管理','supperadm','2022-08-13 10:07:41','supperadm','2022-08-13 10:07:41','车场管理','parking-device-management',NULL,NULL,'2022-08-13 10:07:41','2022-08-10 15:40:43','',''),
(303668,'100002100008100004','车位管理','100002100008',303649,2,'/smart-parking/parking-lot-management/parking-space-management','车场管理/车位管理','supperadm','2022-08-13 10:07:41','supperadm','2022-08-13 10:07:41','车场管理','parking-space-management',NULL,NULL,'2022-08-13 10:07:40','2022-08-10 15:40:43','',''),
(303669,'100003100000','设备管理','100003',303590,2,'/video-guard/device-list','智慧安防/设备管理','supperadm','2022-08-13 10:12:21','supperadm','2022-08-13 10:12:21','智慧安防','smart-guard-device-list',NULL,NULL,'2022-08-13 10:12:20','2022-08-10 15:45:54','',''),
(303670,'100003100001','视频巡更','100003',303590,2,'/video-guard/report-list','智慧安防/视频巡更','supperadm','2022-08-13 10:12:21','supperadm','2022-08-13 10:12:21','智慧安防','smart-guard-report-list',NULL,NULL,'2022-08-13 10:12:20','2022-08-10 15:46:09','',''),
(303671,'100003100002','监控点位','100003',303590,2,'/video-guard/map-pin/index','智慧安防/监控点位','supperadm','2022-08-13 10:12:20','supperadm','2022-08-13 10:12:20','智慧安防','smart-guard-map-pin',NULL,NULL,'2022-08-13 10:12:20','2022-08-10 15:49:02','','');
INSERT INTO smart_cmty_menu (id,menu_code,menu_name,parent_code,parentid,menu_type,menu_url,full_menu_name,create_by,create_time,update_by,update_time,parent_name,identifier,create_by_id,update_by_id,zt_update_time,zt_create_time,apis,extra) VALUES
(303672,'100003100003','人脸记录','100003',303590,2,'#','发卡管理/人脸记录','supperadm','2022-08-10 15:49:22','supperadm','2022-08-10 15:49:22','智慧安防','smart-guard-ai-face',NULL,NULL,'2022-08-10 15:49:21','2022-08-10 15:49:21',NULL,NULL),
(303673,'100003100004','类型配置','100003',303590,2,'/video-guard/type-config','智慧安防/类型配置','supperadm','2022-08-13 10:12:20','supperadm','2022-08-13 10:12:20','智慧安防','smart-guard-type-config',NULL,NULL,'2022-08-13 10:12:20','2022-08-10 15:49:31','',''),
(303674,'100003100003100000','人脸识别','100003100003',303672,2,'/video-guard/ai/face-recognize-index','人脸记录/人脸识别','supperadm','2022-08-13 10:12:45','supperadm','2022-08-13 10:12:45','人脸记录','smart-guard-face-recognize',NULL,NULL,'2022-08-13 10:12:44','2022-08-10 15:50:29','',''),
(303675,'100003100003100001','陌生人识别','100003100003',303672,2,'/video-guard/ai/stranger-recognize-index','人脸记录/陌生人识别','supperadm','2022-08-13 10:12:45','supperadm','2022-08-13 10:12:45','人脸记录','smart-guard-stranger-recognize',NULL,NULL,'2022-08-13 10:12:44','2022-08-10 15:50:29','',''),
(303676,'100004100000','台账管理','100004',303644,2,'#','智慧设备/台账管理','supperadm','2022-08-10 15:55:19','supperadm','2022-08-10 15:55:19','智慧设备','smart-device-equipment',NULL,NULL,'2022-08-10 15:55:18','2022-08-10 15:55:18',NULL,NULL),
(303677,'100004100001','任务管理','100004',303644,2,'#','智慧设备/任务管理','supperadm','2022-08-10 16:00:09','supperadm','2022-08-10 16:00:09','智慧设备','smart-device-equipment-task',NULL,NULL,'2022-08-10 16:00:08','2022-08-10 16:00:08',NULL,NULL),
(303678,'100004100001100000','任务标准','100004100001',303677,2,'/equipment-task/task-init','任务管理/任务标准','supperadm','2022-08-13 10:15:24','supperadm','2022-08-13 10:15:24','任务管理','smart-device-task-init',NULL,NULL,'2022-08-13 10:15:23','2022-08-10 16:00:08','',''),
(303681,'100004100001100001','任务排程','100004100001',303677,2,'/equipment-task/task-schedule','任务管理/任务排程','supperadm','2022-08-13 10:15:24','supperadm','2022-08-13 10:15:24','任务管理','smart-device-task-schedule',NULL,NULL,'2022-08-13 10:15:24','2022-08-10 16:00:09','',''),
(303689,'100004100001100002','任务列表','100004100001',303677,2,'/equipment-task/task-assign','任务管理/任务列表','supperadm','2022-08-13 10:15:24','supperadm','2022-08-13 10:15:24','任务管理','smart-device-task-assign',NULL,NULL,'2022-08-13 10:15:23','2022-08-10 16:00:09','',''),
(303877,'100004100002','设备房管理','100004',303644,2,'/eba-management/device-room-manager','智慧设备/设备房管理','supperadm','2022-08-13 10:13:36','supperadm','2022-08-13 10:13:36','智慧设备','smart-device-room-manager',NULL,NULL,'2022-08-13 10:13:36','2022-08-10 16:01:47','','');
INSERT INTO smart_cmty_menu (id,menu_code,menu_name,parent_code,parentid,menu_type,menu_url,full_menu_name,create_by,create_time,update_by,update_time,parent_name,identifier,create_by_id,update_by_id,zt_update_time,zt_create_time,apis,extra) VALUES
(303878,'100004100003','智能巡检','100004',303644,2,'#','智慧设备/智能巡检','supperadm','2022-08-10 16:02:10','supperadm','2022-08-10 16:02:10','智慧设备','smart-device-intelligent-inspection',NULL,NULL,'2022-08-10 16:02:09','2022-08-10 16:02:09',NULL,NULL),
(303879,'100004100003100000','巡检标准','100004100003',303878,2,'/intelligent-inspection-of-equipment/inspection-tasks','智能巡检/巡检标准','supperadm','2022-08-13 10:15:46','supperadm','2022-08-13 10:15:46','智能巡检','smart-device-patrol-standard',NULL,NULL,'2022-08-13 10:15:46','2022-08-10 16:02:10','',''),
(303880,'100004100003100001','巡检计划','100004100003',303878,2,'/intelligent-inspection-of-equipment/patrol-scheme','智能巡检/巡检计划','supperadm','2022-08-13 10:15:46','supperadm','2022-08-13 10:15:46','智能巡检','smart-device-patrol-scheme',NULL,NULL,'2022-08-13 10:15:45','2022-08-10 16:02:10','',''),
(303881,'100004100003100002','巡检报告','100004100003',303878,2,'/intelligent-inspection-of-equipment/inspection-report','智能巡检/巡检报告','supperadm','2022-08-13 10:15:46','supperadm','2022-08-13 10:15:46','智能巡检','smart-device-inspection-report',NULL,NULL,'2022-08-13 10:15:46','2022-08-10 16:02:11','',''),
(303882,'100005','服务云',NULL,NULL,2,'#','服务云','supperadm','2022-08-10 16:03:32','supperadm','2022-08-10 16:03:32',NULL,'service',NULL,NULL,'2022-08-10 16:03:31','2022-08-10 16:03:31',NULL,NULL),
(303883,'100005100000','智慧工单','100005',303882,2,'#','服务云/工单管理','supperadm','2022-08-22 17:05:30','功夫熊猫','2022-08-22 17:05:30','服务云','service-workorder-manage',NULL,'28449','2022-08-22 17:05:29','2022-08-10 16:06:00','',''),
(303884,'100005100000100000','工单列表','100005100000',303883,2,'/workorder/workorder-list','工单管理/工单列表','supperadm','2022-08-13 10:17:11','supperadm','2022-08-13 10:17:11','工单管理','service-workorder-list',NULL,NULL,'2022-08-13 10:17:11','2022-08-10 16:06:00','',''),
(303885,'100005100000100001','节点设置','100005100000',303883,2,'/workorder/workorder-node','工单管理/节点设置','supperadm','2022-08-13 10:17:11','supperadm','2022-08-13 10:17:11','工单管理','service-workorder-node',NULL,NULL,'2022-08-13 10:17:10','2022-08-10 16:06:00','',''),
(303886,'100005100000100002','流程设置','100005100000',303883,2,'/workorder/workorder-flow','工单管理/流程设置','supperadm','2022-08-13 10:17:11','supperadm','2022-08-13 10:17:11','工单管理','service-workorder-flow',NULL,NULL,'2022-08-13 10:17:10','2022-08-10 16:06:01','',''),
(303887,'100005100000100003','工单类别','100005100000',303883,2,'/workorder/workorder-category','工单管理/工单类别','supperadm','2022-08-13 10:17:11','supperadm','2022-08-13 10:17:11','工单管理','service-workorder-category',NULL,NULL,'2022-08-13 10:17:10','2022-08-10 16:06:01','','');
INSERT INTO smart_cmty_menu (id,menu_code,menu_name,parent_code,parentid,menu_type,menu_url,full_menu_name,create_by,create_time,update_by,update_time,parent_name,identifier,create_by_id,update_by_id,zt_update_time,zt_create_time,apis,extra) VALUES
(303888,'100005100000100004','评分设置','100005100000',303883,2,'/workorder/workorder-setting','工单管理/参数设置','supperadm','2022-08-22 17:42:01','功夫熊猫','2022-08-22 17:42:01','工单管理','service-workorder-setting',NULL,'28449','2022-08-22 17:42:01','2022-08-10 16:06:02','',''),
(303892,'100005100001','智慧品质','100005',303882,2,'#','服务云/智慧管理','supperadm','2022-08-18 15:45:58','supperadm','2022-08-18 15:45:58','服务云','service-quality',NULL,NULL,'2022-08-18 15:45:58','2022-08-10 16:06:42','',''),
(303893,'100005100001100000','专业目录','100005100001',303892,2,'/quality-base/quality-classify','品质管理/专业目录','supperadm','2022-08-13 10:17:32','supperadm','2022-08-13 10:17:32','品质管理','service-quality-classify',NULL,NULL,'2022-08-13 10:17:31','2022-08-10 16:06:42','',''),
(303894,'100005100001100001','检查指标','100005100001',303892,2,'/quality-base/quality-standard','品质管理/检查指标','supperadm','2022-08-13 10:17:31','supperadm','2022-08-13 10:17:31','品质管理','service-quality-standard',NULL,NULL,'2022-08-13 10:17:31','2022-08-10 16:06:42','',''),
(303895,'100005100001100002','任务模板','100005100001',303892,2,'/quality-check/quality-task-template','品质管理/任务模板','supperadm','2022-08-13 10:17:31','supperadm','2022-08-13 10:17:31','品质管理','service-quality-task-template',NULL,NULL,'2022-08-13 10:17:31','2022-08-10 16:06:43','',''),
(303896,'100005100001100003','计划管理','100005100001',303892,2,'/quality-check/quality-plan','品质管理/计划管理','supperadm','2022-08-13 10:17:31','supperadm','2022-08-13 10:17:31','品质管理','service-quality-plan',NULL,NULL,'2022-08-13 10:17:30','2022-08-10 16:06:43','',''),
(303897,'100005100001100004','品检记录','100005100001',303892,2,'/quality-check/quality-record','品质管理/品检记录','supperadm','2022-08-13 10:17:31','supperadm','2022-08-13 10:17:31','品质管理','service-quality-record',NULL,NULL,'2022-08-13 10:17:31','2022-08-10 16:06:44','',''),
(303898,'100006','运营云',NULL,NULL,2,'#','运营云','supperadm','2022-08-10 16:14:24','supperadm','2022-08-10 16:14:24',NULL,'content',NULL,NULL,'2022-08-10 16:14:24','2022-08-10 16:14:24',NULL,NULL),
(303899,'100006100000','便民信息','100006',303898,2,'/content-management/convenient','运营云/便民信息','supperadm','2022-08-13 10:17:59','supperadm','2022-08-13 10:17:59','运营云','content-convenient',NULL,NULL,'2022-08-13 10:17:59','2022-08-10 16:16:21','',''),
(303900,'100006100001','社区资讯','100006',303898,2,'/society-message/societyCons','运营云/社区资讯','supperadm','2022-08-13 10:17:59','supperadm','2022-08-13 10:17:59','运营云','content-societyCons',NULL,NULL,'2022-08-13 10:17:58','2022-08-10 16:16:44','','');
INSERT INTO smart_cmty_menu (id,menu_code,menu_name,parent_code,parentid,menu_type,menu_url,full_menu_name,create_by,create_time,update_by,update_time,parent_name,identifier,create_by_id,update_by_id,zt_update_time,zt_create_time,apis,extra) VALUES
(303901,'100006100002','信息大屏','100006',303898,2,'#','运营云/信息大屏','supperadm','2022-08-10 16:17:04','supperadm','2022-08-10 16:17:04','运营云','content-screenmanage',NULL,NULL,'2022-08-10 16:17:03','2022-08-10 16:17:03',NULL,NULL),
(303902,'100006100002100000','模板展示','100006100002',303901,2,'/information/template-demonstrate','信息大屏/模板展示','supperadm','2022-08-13 10:20:40','supperadm','2022-08-13 10:20:40','信息大屏','content-template-demonstrate',NULL,NULL,'2022-08-13 10:20:40','2022-08-10 16:17:04','',''),
(303903,'100006100002100001','位置管理','100006100002',303901,2,'/information/position-manage','信息大屏/位置管理','supperadm','2022-08-13 10:20:40','supperadm','2022-08-13 10:20:40','信息大屏','content-position-manage',NULL,NULL,'2022-08-13 10:20:39','2022-08-10 16:17:04','',''),
(303904,'100006100002100002','设备列表','100006100002',303901,2,'/information/device-list','信息大屏/设备列表','supperadm','2022-08-13 10:20:40','supperadm','2022-08-13 10:20:40','信息大屏','content-device-list',NULL,NULL,'2022-08-13 10:20:40','2022-08-10 16:17:05','',''),
(303905,'100006100002100003','信息列表','100006100002',303901,2,'/information/information-list','信息大屏/信息列表','supperadm','2022-08-13 10:20:40','supperadm','2022-08-13 10:20:40','信息大屏','content-information-list',NULL,NULL,'2022-08-13 10:20:39','2022-08-10 16:17:05','',''),
(303906,'100006100003','广告管理','100006',303898,2,'/advertise/advertise-management','运营云/广告管理','supperadm','2022-08-13 10:17:58','supperadm','2022-08-13 10:17:58','运营云','content-advertise-management',NULL,NULL,'2022-08-13 10:17:58','2022-08-10 16:17:43','',''),
(303907,'100006100004','社区活动','100006',303898,2,'/society-active/active-list','运营云/社区活动','supperadm','2022-08-13 10:17:58','supperadm','2022-08-13 10:17:58','运营云','content-active-list',NULL,NULL,'2022-08-13 10:17:58','2022-08-10 16:17:55','',''),
(303908,'100006100005','社区话题','100006',303898,2,'society-topic/society-topic','运营云/社区话题','supperadm','2022-08-17 14:00:49','supperadm','2022-08-17 14:00:49','运营云','content-society-topic',NULL,NULL,'2022-08-17 14:00:49','2022-08-10 16:18:22','',''),
(303909,'100006100006','社区评价','100006',303898,2,'/society-valuation/society-valuation','运营云/社区评价','supperadm','2022-08-13 10:17:58','supperadm','2022-08-13 10:17:58','运营云','content-society-valuation',NULL,NULL,'2022-08-13 10:17:57','2022-08-10 16:18:48','',''),
(303910,'100006100007','问卷调查','100006',303898,2,'#','运营云/问卷调查','supperadm','2022-08-10 16:19:09','supperadm','2022-08-10 16:19:09','运营云','content-ques',NULL,NULL,'2022-08-10 16:19:09','2022-08-10 16:19:09',NULL,NULL);
INSERT INTO smart_cmty_menu (id,menu_code,menu_name,parent_code,parentid,menu_type,menu_url,full_menu_name,create_by,create_time,update_by,update_time,parent_name,identifier,create_by_id,update_by_id,zt_update_time,zt_create_time,apis,extra) VALUES
(303911,'100006100007100000','问卷管理','100006100007',303910,2,'/questionnaire/ques-manage','问卷调查/问卷管理','supperadm','2022-08-13 10:21:06','supperadm','2022-08-13 10:21:06','问卷调查','content-ques-manage',NULL,NULL,'2022-08-13 10:21:05','2022-08-10 16:19:09','',''),
(303912,'100006100007100001','问卷模板','100006100007',303910,2,'/questionnaire/questionnaire-template','问卷调查/问卷模板','supperadm','2022-08-13 10:21:06','supperadm','2022-08-13 10:21:06','问卷调查','content-questionnaire-template',NULL,NULL,'2022-08-13 10:21:05','2022-08-10 16:19:10','',''),
(303913,'100006100007100002','问卷统计','100006100007',303910,2,'/questionnaire/questionnaire-statistics','问卷调查/问卷统计','supperadm','2022-08-13 10:21:06','supperadm','2022-08-13 10:21:06','问卷调查','content-questionnaire-statistics',NULL,NULL,'2022-08-13 10:21:05','2022-08-10 16:19:10','',''),
(303914,'100006100008','内容模板','100006',303898,2,'/content/content-template','运营云/内容模板','supperadm','2022-08-15 09:11:11','supperadm','2022-08-15 09:11:11','运营云','content-content-template',NULL,NULL,'2022-08-15 09:11:11','2022-08-10 16:19:44','',''),
(303915,'100006100009','植被百科','100006',303898,2,'/vegetation/content-vegetation','运营云/植被百科','supperadm','2022-08-15 09:11:22','supperadm','2022-08-15 09:11:22','运营云','content-content-vegetation',NULL,NULL,'2022-08-15 09:11:22','2022-08-10 16:19:58','',''),
(303916,'100007','客户云',NULL,NULL,2,'#','客户云','supperadm','2022-08-10 16:21:10','supperadm','2022-08-10 16:21:10',NULL,'customer',NULL,NULL,'2022-08-10 16:21:09','2022-08-10 16:21:09',NULL,NULL),
(303917,'100007100000','客户管理','100007',303916,2,'/customer/customer-list','客户云/客户管理','supperadm','2022-08-13 10:21:30','supperadm','2022-08-13 10:21:30','客户云','customer-customer-list',NULL,NULL,'2022-08-13 10:21:30','2022-08-10 16:22:28','',''),
(303918,'100007100001','产权管理','100007',303916,2,'#','客户云/产权管理','supperadm','2022-08-13 10:22:51','supperadm','2022-08-13 10:22:51','客户云','customer-property-manage',NULL,NULL,'2022-08-13 10:22:51','2022-08-10 16:22:49','',''),
(303919,'100007100001100000','入伙管理','100007100001',303918,2,'/property/join-list','产权管理/入伙管理','supperadm','2022-08-13 10:22:30','supperadm','2022-08-13 10:22:30','产权管理','customer-join-list',NULL,NULL,'2022-08-13 10:22:29','2022-08-10 16:22:49','',''),
(303920,'100007100001100001','出租管理','100007100001',303918,2,'/property/rental-list','产权管理/出租管理','supperadm','2022-08-13 10:22:30','supperadm','2022-08-13 10:22:30','产权管理','customer-rental-list',NULL,NULL,'2022-08-13 10:22:29','2022-08-10 16:22:49','','');
INSERT INTO smart_cmty_menu (id,menu_code,menu_name,parent_code,parentid,menu_type,menu_url,full_menu_name,create_by,create_time,update_by,update_time,parent_name,identifier,create_by_id,update_by_id,zt_update_time,zt_create_time,apis,extra) VALUES
(303921,'100007100002','信息认证','100007',303916,2,'/customer/auth-list','客户云/信息认证','supperadm','2022-08-13 10:21:30','supperadm','2022-08-13 10:21:30','客户云','customer-auth-list',NULL,NULL,'2022-08-13 10:21:29','2022-08-10 16:23:10','',''),
(303922,'100008','数字云',NULL,NULL,2,'#','数字云','supperadm','2022-08-10 16:24:31','supperadm','2022-08-10 16:24:31',NULL,'digital',NULL,NULL,'2022-08-10 16:24:31','2022-08-10 16:24:31',NULL,NULL),
(303923,'100008100000','组织权限','100008',303922,2,'#','数字云/组织权限','supperadm','2022-08-10 16:25:52','supperadm','2022-08-10 16:25:52','数字云','digital-org-authority',NULL,NULL,'2022-08-10 16:25:51','2022-08-10 16:25:51',NULL,NULL),
(303925,'100008100000100001','业务组织','100008100000',303923,2,'/sys-settings/biz-organization/list/business','组织权限/业务组织','supperadm','2022-08-13 10:23:56','supperadm','2022-08-13 10:23:56','组织权限','digital-business-organization-list',NULL,NULL,'2022-08-13 10:23:56','2022-08-10 16:25:52','',''),
(303926,'100008100000100002','账号管理','100008100000',303923,2,'/sys-settings/member-management','组织权限/账号管理','supperadm','2022-08-13 10:23:56','supperadm','2022-08-13 10:23:56','组织权限','digital-member-management',NULL,NULL,'2022-08-13 10:23:55','2022-08-10 16:25:53','',''),
(303927,'100008100000100003','角色管理','100008100000',303923,2,'/organization-management/views/role-organization','组织权限/角色管理','supperadm','2022-08-13 10:23:56','supperadm','2022-08-13 10:23:56','组织权限','digital-role-organization',NULL,NULL,'2022-08-13 10:23:55','2022-08-10 16:25:53','',''),
(303928,'100008100001','项目管理','100008',303922,2,'/project/project-list','数字云/项目管理','supperadm','2022-08-13 10:23:29','supperadm','2022-08-13 10:23:29','数字云','digital-project-list',NULL,NULL,'2022-08-13 10:23:29','2022-08-10 16:26:39','',''),
(303929,'100008100002','空间管理','100008',303922,2,'/space-manage','数字云/空间管理','supperadm','2022-08-20 16:31:37','supperadm','2022-08-20 16:31:37','数字云','digital-space-manage',NULL,NULL,'2022-08-20 16:31:36','2022-08-10 16:26:55','',''),
(303930,'100009','系统管理',NULL,NULL,2,'#','系统应用管理','supperadm','2022-08-24 08:40:15','功夫熊猫','2022-08-24 08:40:15',NULL,'sysManage',NULL,'28449','2022-08-24 08:40:14','2022-08-10 16:27:43','',''),
(303931,'100009100000','APP管理','100009',303930,2,'/application-management/app-list','系统应用管理/APP管理','supperadm','2022-08-13 10:24:20','supperadm','2022-08-13 10:24:20','系统应用管理','sys-manage-app-list',NULL,NULL,'2022-08-13 10:24:19','2022-08-10 16:29:08','','');
INSERT INTO smart_cmty_menu (id,menu_code,menu_name,parent_code,parentid,menu_type,menu_url,full_menu_name,create_by,create_time,update_by,update_time,parent_name,identifier,create_by_id,update_by_id,zt_update_time,zt_create_time,apis,extra) VALUES
(303932,'100009100001','插件管理','100009',303930,2,'/application-management/plugins/list','系统应用管理/插件管理','supperadm','2022-08-13 10:24:19','supperadm','2022-08-13 10:24:20','系统应用管理','sys-manage-plugins-list',NULL,NULL,'2022-08-13 10:24:19','2022-08-10 16:29:23','',''),
(303933,'100009100002','APP功能','100009',303930,2,'/application-management/features-list','系统应用管理/APP功能列表','supperadm','2022-08-22 20:08:17','功夫熊猫','2022-08-22 20:08:17','系统应用管理','sys-manage-features-list',NULL,'28449','2022-08-22 20:08:16','2022-08-10 16:29:30','',''),
(303934,'100009100003','APP授权','100009',303930,2,'/application-management/authorize','系统应用管理/APP功能授权','supperadm','2022-08-22 20:08:21','功夫熊猫','2022-08-22 20:08:21','系统应用管理','sys-manage-app-authorize',NULL,'28449','2022-08-22 20:08:21','2022-08-10 16:29:38','',''),
(303935,'100009100004','应用指引','100009',303930,2,'/application-management/platform','系统应用管理/应用与指引','supperadm','2022-08-24 08:40:31','功夫熊猫','2022-08-24 08:40:31','系统应用管理','sys-manage-platform',NULL,'28449','2022-08-24 08:40:31','2022-08-10 16:29:44','',''),
(303936,'100001100000','门禁设备','100001',303587,2,'/people/door','智慧人行/门禁设备','supperadm','2022-08-13 09:54:18','supperadm','2022-08-13 09:54:18','智慧人行','people-door',NULL,NULL,'2022-08-13 09:54:18','2022-08-10 16:33:08','',''),
(303937,'100001100001','梯控设备','100001',303587,2,'/people/elevator','智慧人行/梯控设备','supperadm','2022-08-13 09:54:18','supperadm','2022-08-13 09:54:18','智慧人行','people-elevator',NULL,NULL,'2022-08-13 09:54:18','2022-08-10 16:33:22','',''),
(303938,'100001100002','通行记录','100001',303587,2,'/people/record','智慧人行/通行记录','supperadm','2022-08-13 09:54:18','supperadm','2022-08-13 09:54:18','智慧人行','people-record',NULL,NULL,'2022-08-13 09:54:17','2022-08-10 16:33:29','',''),
(303939,'100001100003','人员授权','100001',303587,2,'/people/auth','智慧人行/人员授权','supperadm','2022-08-13 09:54:18','supperadm','2022-08-13 09:54:18','智慧人行','people-auth',NULL,NULL,'2022-08-13 09:54:17','2022-08-10 16:33:35','',''),
(303940,'100001100004','人脸管理','100001',303587,2,'/people/face','智慧人行/人脸管理','supperadm','2022-08-13 09:54:18','supperadm','2022-08-13 09:54:18','智慧人行','people-face',NULL,NULL,'2022-08-13 09:54:17','2022-08-10 16:33:42','',''),
(303941,'100001100005','智慧访客','100001',303587,2,'#','智慧人行/智慧访客','supperadm','2022-08-10 16:34:02','supperadm','2022-08-10 16:34:02','智慧人行','people-visitor',NULL,NULL,'2022-08-10 16:34:01','2022-08-10 16:34:01',NULL,NULL);
INSERT INTO smart_cmty_menu (id,menu_code,menu_name,parent_code,parentid,menu_type,menu_url,full_menu_name,create_by,create_time,update_by,update_time,parent_name,identifier,create_by_id,update_by_id,zt_update_time,zt_create_time,apis,extra) VALUES
(303942,'100001100005100000','访客记录','100001100005',303941,2,'/people/visitor/record','智慧访客/访客记录','supperadm','2022-08-13 09:55:08','supperadm','2022-08-13 09:55:08','智慧访客','people-visitor-record',NULL,NULL,'2022-08-13 09:55:08','2022-08-10 16:34:01','',''),
(303943,'100001100005100001','访客配置','100001100005',303941,2,'/people/visitor/setting','智慧访客/访客配置','supperadm','2022-08-13 09:55:09','supperadm','2022-08-13 09:55:09','智慧访客','people-visitor-setting',NULL,NULL,'2022-08-13 09:55:08','2022-08-10 16:34:02','',''),
(305760,'100002100002100000','卡类型管理','100002100002',303603,2,'/smart-parking/card-management/type','智慧车行/发卡管理/卡类型管理','supperadm','2022-08-13 10:03:30','supperadm','2022-08-13 10:03:30','发卡管理','parking-card-type-management',NULL,NULL,'2022-08-13 10:03:29','2022-08-13 10:03:29',NULL,NULL),
(305761,'100002100002100001','费率管理','100002100002',303603,2,'/smart-parking/card-management/rate','智慧车行/发卡管理/费率管理','supperadm','2022-08-13 10:03:30','supperadm','2022-08-13 10:03:30','发卡管理','parking-rate-management',NULL,NULL,'2022-08-13 10:03:30','2022-08-13 10:03:30',NULL,NULL),
(305762,'100002100002100002','套餐管理','100002100002',303603,2,'/smart-parking/card-management/package','智慧车行/发卡管理/套餐管理','supperadm','2022-08-13 10:03:31','supperadm','2022-08-13 10:03:31','发卡管理','parking-package-management',NULL,NULL,'2022-08-13 10:03:30','2022-08-13 10:03:30',NULL,NULL),
(305763,'100002100002100003','月卡申请','100002100002',303603,2,'/smart-parking/card-management/application','智慧车行/发卡管理/月卡申请','supperadm','2022-08-13 10:03:31','supperadm','2022-08-13 10:03:31','发卡管理','parking-card-application',NULL,NULL,'2022-08-13 10:03:31','2022-08-13 10:03:31',NULL,NULL),
(305764,'100002100002100004','月卡审批','100002100002',303603,2,'/smart-parking/card-management/approval','智慧车行/发卡管理/月卡审批','supperadm','2022-08-13 10:03:32','supperadm','2022-08-13 10:03:32','发卡管理','parking-card-approval',NULL,NULL,'2022-08-13 10:03:31','2022-08-13 10:03:31',NULL,NULL),
(305765,'100002100002100005','续卡审批','100002100002',303603,2,'/smart-parking/card-management/card-renew-approve','智慧车行/发卡管理/续卡审批','supperadm','2022-08-13 10:03:32','supperadm','2022-08-13 10:03:32','发卡管理','parking-card-renew-approve',NULL,NULL,'2022-08-13 10:03:32','2022-08-13 10:03:32',NULL,NULL),
(305766,'100002100002100006','月卡管理','100002100002',303603,2,'/smart-parking/card-management/card-month-list','智慧车行/发卡管理/月卡管理','supperadm','2022-08-13 10:03:33','supperadm','2022-08-13 10:03:33','发卡管理','parking-card-month-list',NULL,NULL,'2022-08-13 10:03:32','2022-08-13 10:03:32',NULL,NULL),
(305767,'100002100002100007','变更审批','100002100002',303603,2,'/smart-parking/card-management/car-modify','智慧车行/发卡管理/变更审批','supperadm','2022-08-13 10:03:33','supperadm','2022-08-13 10:03:33','发卡管理','parking-card-modify',NULL,NULL,'2022-08-13 10:03:33','2022-08-13 10:03:33',NULL,NULL);
INSERT INTO smart_cmty_menu (id,menu_code,menu_name,parent_code,parentid,menu_type,menu_url,full_menu_name,create_by,create_time,update_by,update_time,parent_name,identifier,create_by_id,update_by_id,zt_update_time,zt_create_time,apis,extra) VALUES
(305768,'100002100002100008','变更日志','100002100002',303603,2,'/smart-parking/card-management/card-change-log','智慧车行/发卡管理/变更日志','supperadm','2022-08-13 10:03:34','supperadm','2022-08-13 10:03:34','发卡管理','parking-card-change-log',NULL,NULL,'2022-08-13 10:03:33','2022-08-13 10:03:33',NULL,NULL),
(305773,'100002100009100000','支付配置','100002100009',303650,2,'/smart-parking/sys-management/pay-config','智慧车行/系统管理/支付配置','supperadm','2022-08-13 10:11:38','supperadm','2022-08-13 10:11:38','基础配置','parking-pay-config',NULL,NULL,'2022-08-13 10:11:38','2022-08-13 10:11:38','',''),
(305774,'100004100000100000','台账配置','100004100000',303676,2,'/equipment/ledger-setting','智慧设备/台账管理/台账配置','supperadm','2022-08-13 10:14:34','supperadm','2022-08-13 10:14:34','台账管理','smart-device-ledger-setting',NULL,NULL,'2022-08-13 10:14:33','2022-08-13 10:14:33','',''),
(305775,'100004100000100001','项目台账','100004100000',303676,2,'/equipment/device-ledger','智慧设备/台账管理/项目台账','supperadm','2022-08-13 10:14:55','supperadm','2022-08-13 10:14:55','台账管理','smart-device-device-ledger',NULL,NULL,'2022-08-13 10:14:54','2022-08-13 10:14:54','',''),
(305831,'100001100000100000','门禁关联','100001100000',303936,2,'/people/door/add','智慧人行/门禁设备/门禁关联','supperadm','2022-08-13 15:16:22','supperadm','2022-08-13 15:16:22','门禁设备','people-door-add',NULL,NULL,'2022-08-13 15:16:22','2022-08-13 15:16:22','',''),
(305832,'100001100001100000','梯控关联','100001100001',303937,2,'/people/elevator/add','智慧人行/梯控设备/梯控关联','supperadm','2022-08-13 15:18:36','supperadm','2022-08-13 15:18:36','梯控设备','people-elevator-add',NULL,NULL,'2022-08-13 15:18:36','2022-08-13 15:18:36','',''),
(305833,'100001100003100000','授权详情','100001100003',303939,2,'/people/auth/detail','智慧人行/人员授权/授权详情','supperadm','2022-08-13 15:19:28','supperadm','2022-08-13 15:19:28','人员授权','people-auth-detail',NULL,NULL,'2022-08-13 15:19:28','2022-08-13 15:19:28','',''),
(305834,'100001100004100000','授权详情','100001100004',303940,2,'/people/face/detail','智慧人行/人脸管理/授权详情','supperadm','2022-08-13 15:20:01','supperadm','2022-08-13 15:20:01','人脸管理','people-face-detail',NULL,NULL,'2022-08-13 15:20:01','2022-08-13 15:20:01','',''),
(305835,'100003100000100000','设置设备分组','100003100000',303669,2,'/video-guard/video-group-config','智慧安防/设备管理/设置设备分组','supperadm','2022-08-13 15:28:16','supperadm','2022-08-13 15:28:16','设备管理','smart-guard-video-group-config',NULL,NULL,'2022-08-13 15:28:16','2022-08-13 15:28:16','',''),
(305840,'100003100000100001','关联设备','100003100000',303669,2,'/video-guard/video-bind-device','智慧安防/设备管理/关联设备','supperadm','2022-08-13 15:31:08','supperadm','2022-08-13 15:31:08','设备管理','smart-guard-video-bind-device',NULL,NULL,'2022-08-13 15:31:08','2022-08-13 15:31:08','','');
INSERT INTO smart_cmty_menu (id,menu_code,menu_name,parent_code,parentid,menu_type,menu_url,full_menu_name,create_by,create_time,update_by,update_time,parent_name,identifier,create_by_id,update_by_id,zt_update_time,zt_create_time,apis,extra) VALUES
(305841,'100003100001100000','巡更报告详情','100003100001',303670,2,'/video-guard/report-detail','智慧安防/视频巡更/巡更报告详情','supperadm','2022-08-13 15:31:47','supperadm','2022-08-13 15:31:47','视频巡更','smart-guard-report-detail',NULL,NULL,'2022-08-13 15:31:46','2022-08-13 15:31:46','',''),
(305842,'100003100001100001','巡更任务','100003100001',303670,2,'/video-guard/tasks-list','智慧安防/视频巡更/巡更任务','supperadm','2022-08-13 15:32:06','supperadm','2022-08-13 15:32:06','视频巡更','smart-guard-tasks-list',NULL,NULL,'2022-08-13 15:32:05','2022-08-13 15:32:05','',''),
(305843,'100003100001100002','巡更计划','100003100001',303670,2,'/video-guard/plan-list','智慧安防/视频巡更/巡更计划','supperadm','2022-08-13 15:32:25','supperadm','2022-08-13 15:32:25','视频巡更','smart-guard-plan-list',NULL,NULL,'2022-08-13 15:32:25','2022-08-13 15:32:25','',''),
(305844,'100003100001100003','巡更计划-新增','100003100001',303670,2,'/video-guard/plan-add','智慧安防/视频巡更/巡更计划-新增','supperadm','2022-08-13 15:32:50','supperadm','2022-08-13 15:32:50','视频巡更','smart-guard-plan-add',NULL,NULL,'2022-08-13 15:32:49','2022-08-13 15:32:49','',''),
(305845,'100003100001100004','巡更计划-编辑','100003100001',303670,2,'/video-guard/plan-edit','智慧安防/视频巡更/巡更计划-编辑','supperadm','2022-08-13 15:33:46','supperadm','2022-08-13 15:33:46','视频巡更','smart-guard-plan-edit',NULL,NULL,'2022-08-13 15:33:46','2022-08-13 15:33:46','',''),
(305846,'100003100001100005','检查项','100003100001',303670,2,'/video-guard/checklist-list','智慧安防/视频巡更/检查项','supperadm','2022-08-13 15:34:20','supperadm','2022-08-13 15:34:20','视频巡更','smart-guard-checklist-list',NULL,NULL,'2022-08-13 15:34:19','2022-08-13 15:34:19','',''),
(305847,'100003100003100001100000','陌生人聚合详情','100003100003100001',303675,2,'/video-guard/ai/stranger-recognize-detail','人脸记录/陌生人识别/陌生人聚合详情','supperadm','2022-08-13 15:35:04','supperadm','2022-08-13 15:35:04','陌生人识别','smart-guard-stranger-recognize-detail',NULL,NULL,'2022-08-13 15:35:04','2022-08-13 15:35:04','',''),
(305848,'100004100001100002100000','未来任务','100004100001100002',303689,2,'/equipment-task/task-future','任务管理/任务列表/未来任务','supperadm','2022-08-13 15:36:39','supperadm','2022-08-13 15:36:39','任务列表','smart-device-task-future',NULL,NULL,'2022-08-13 15:36:39','2022-08-13 15:36:39','',''),
(305849,'100004100002100000','设备房列表','100004100002',303877,2,'/eba-management/device-room-manager/list','智慧设备/设备房管理/设备房列表','supperadm','2022-08-13 15:37:28','supperadm','2022-08-13 15:37:28','设备房管理','smart-device-room-manager-list',NULL,NULL,'2022-08-13 15:37:27','2022-08-13 15:37:27','',''),
(305850,'100004100002100001','设备房编辑','100004100002',303877,2,'/eba-management/device-room-manager/edit','智慧设备/设备房管理/设备房编辑','supperadm','2022-08-13 15:37:47','supperadm','2022-08-13 15:37:47','设备房管理','smart-device-room-manager-edit',NULL,NULL,'2022-08-13 15:37:46','2022-08-13 15:37:46','','');
INSERT INTO smart_cmty_menu (id,menu_code,menu_name,parent_code,parentid,menu_type,menu_url,full_menu_name,create_by,create_time,update_by,update_time,parent_name,identifier,create_by_id,update_by_id,zt_update_time,zt_create_time,apis,extra) VALUES
(305851,'100004100002100002','设备房详情','100004100002',303877,2,'/eba-management/device-room-manager/detail','智慧设备/设备房管理/设备房详情','supperadm','2022-08-13 15:38:05','supperadm','2022-08-13 15:38:05','设备房管理','smart-device-room-manager-detail',NULL,NULL,'2022-08-13 15:38:04','2022-08-13 15:38:04','',''),
(305852,'100004100002100003','设备房监控设置','100004100002',303877,2,'/eba-management/device-room-manager/monitor-settings','智慧设备/设备房管理/设备房监控设置','supperadm','2022-08-13 15:38:29','supperadm','2022-08-13 15:38:29','设备房管理','smart-device-monitor-settings',NULL,NULL,'2022-08-13 15:38:29','2022-08-13 15:38:29','',''),
(305853,'100004100003100000100000','新建巡检任务','100004100003100000',303879,2,'/intelligent-inspection-of-equipment/inspection-tasks-add','智能巡检/巡检标准/新建巡检任务','supperadm','2022-08-13 15:39:04','supperadm','2022-08-13 15:39:04','巡检标准','smart-device-inspection-tasks-add',NULL,NULL,'2022-08-13 15:39:04','2022-08-13 15:39:04','',''),
(305854,'100004100003100000100001','编辑巡检任务','100004100003100000',303879,2,'/intelligent-inspection-of-equipment/inspection-tasks-edit','智能巡检/巡检标准/编辑巡检任务','supperadm','2022-08-13 15:39:28','supperadm','2022-08-13 15:39:28','巡检标准','smart-device-inspection-tasks-edit',NULL,NULL,'2022-08-13 15:39:27','2022-08-13 15:39:27','',''),
(305855,'100004100003100001100000','编辑巡检计划','100004100003100001',303880,2,'/intelligent-inspection-of-equipment/patrol-scheme-edit','智能巡检/巡检计划/编辑巡检计划','supperadm','2022-08-13 15:40:04','supperadm','2022-08-13 15:40:04','巡检计划','smart-device-patrol-scheme-edit',NULL,NULL,'2022-08-13 15:40:04','2022-08-13 15:40:04','',''),
(305856,'100004100003100001100001','新增巡检计划','100004100003100001',303880,2,'/intelligent-inspection-of-equipment/patrol-scheme-add','智能巡检/巡检计划/新增巡检计划','supperadm','2022-08-13 15:40:23','supperadm','2022-08-13 15:40:23','巡检计划','smart-device-patrol-scheme-add',NULL,NULL,'2022-08-13 15:40:22','2022-08-13 15:40:22','',''),
(305857,'100006100005100000','子话题/评论记录','100006100005',303908,2,'/society-topic/*','社区话题/社区话题子路由','supperadm','2022-08-22 14:23:19','功夫熊猫','2022-08-22 14:23:19','社区话题','content-society-topic-all',NULL,'28449','2022-08-22 14:23:18','2022-08-13 15:46:52','',''),
(305858,'100006100004100000','活动记录','100006100004',303907,2,'/society-active/*','社区活动/社区活动子路由','supperadm','2022-08-22 14:21:19','功夫熊猫','2022-08-22 14:21:19','社区活动','content-society-active-all',NULL,'28449','2022-08-22 14:21:18','2022-08-13 15:47:10','',''),
(305859,'100006100006100000','评价记录','100006100006',303909,2,'/society-valuation/valuationRecord','运营云/社区评价/评价记录','supperadm','2022-08-13 15:48:32','supperadm','2022-08-13 15:48:32','社区评价','content-valuationRecord',NULL,NULL,'2022-08-13 15:48:31','2022-08-13 15:48:31','',''),
(305863,'100007100000100000','客户详情','100007100000',303917,2,'/customer/customer-detail','客户云/客户管理/客户详情','supperadm','2022-08-13 15:54:01','supperadm','2022-08-13 15:54:01','客户管理','customer-customer-detail',NULL,NULL,'2022-08-13 15:54:01','2022-08-13 15:54:01','','');
INSERT INTO smart_cmty_menu (id,menu_code,menu_name,parent_code,parentid,menu_type,menu_url,full_menu_name,create_by,create_time,update_by,update_time,parent_name,identifier,create_by_id,update_by_id,zt_update_time,zt_create_time,apis,extra) VALUES
(305864,'100007100000100001','编辑客户','100007100000',303917,2,'/customer/customer-edit','客户云/客户管理/编辑客户','supperadm','2022-08-13 15:54:20','supperadm','2022-08-13 15:54:20','客户管理','customer-customer-edit',NULL,NULL,'2022-08-13 15:54:19','2022-08-13 15:54:19','',''),
(305870,'100007100000100002','新增客户','100007100000',303917,2,'/customer/customer-add','客户云/客户管理/新增客户','supperadm','2022-08-13 15:55:01','supperadm','2022-08-13 15:55:01','客户管理','customer-customer-add',NULL,NULL,'2022-08-13 15:55:01','2022-08-13 15:55:01','',''),
(305871,'100007100002100000','认证审核','100007100002',303921,2,'/customer/auth-verify','客户云/信息认证/认证审核','supperadm','2022-08-13 15:55:44','supperadm','2022-08-13 15:55:44','信息认证','customer-auth-verify',NULL,NULL,'2022-08-13 15:55:44','2022-08-13 15:55:44','',''),
(305873,'100008100000100001100000','业务组织详情','100008100000100001',303925,2,'/sys-settings/biz-organization/business-detail','组织权限/业务组织/业务组织详情','supperadm','2022-08-13 15:56:50','supperadm','2022-08-13 15:56:50','业务组织','digital-business-detail',NULL,NULL,'2022-08-13 15:56:49','2022-08-13 15:56:49','',''),
(305874,'100008100000100002100000','员工列表','100008100000100002',303926,2,'/sys-settings/member-management/list','组织权限/账号管理/员工列表','supperadm','2022-08-13 15:58:18','supperadm','2022-08-13 15:58:18','账号管理','digital-member-management-list',NULL,NULL,'2022-08-13 15:58:18','2022-08-13 15:58:18','',''),
(305875,'100008100000100002100001','员工详情','100008100000100002',303926,2,'/sys-settings/member-management/member-detail','组织权限/账号管理/员工详情','supperadm','2022-08-13 15:58:43','supperadm','2022-08-13 15:58:43','账号管理','digital-member-detail',NULL,NULL,'2022-08-13 15:58:42','2022-08-13 15:58:42','',''),
(305876,'100008100000100002100002','编辑员工','100008100000100002',303926,2,'/sys-settings/member-management/member-edit','组织权限/账号管理/编辑员工','supperadm','2022-08-13 15:59:13','supperadm','2022-08-13 15:59:13','账号管理','digital-member-edit',NULL,NULL,'2022-08-13 15:59:12','2022-08-13 15:59:12','',''),
(305877,'100008100000100002100003','新增员工','100008100000100002',303926,2,'/sys-settings/member-management/member-add','组织权限/账号管理/新增员工','supperadm','2022-08-13 15:59:37','supperadm','2022-08-13 15:59:37','账号管理','digital-member-add',NULL,NULL,'2022-08-13 15:59:36','2022-08-13 15:59:36','',''),
(305879,'100008100000100002100005','员工关联','100008100000100002',303926,2,'/sys-settings/member-management/groups-rel','组织权限/账号管理/员工关联','supperadm','2022-08-13 16:00:23','supperadm','2022-08-13 16:00:23','账号管理','digital-groups-rel',NULL,NULL,'2022-08-13 16:00:22','2022-08-13 16:00:22','',''),
(305880,'100008100000100003100001','角色列表','100008100000100003',303927,2,'/organization-management/views/role-organization/role','组织权限/角色管理/角色列表','supperadm','2022-08-13 16:01:39','supperadm','2022-08-13 16:01:39','角色管理','digital-role-list',NULL,NULL,'2022-08-13 16:01:38','2022-08-13 16:01:38','','');
INSERT INTO smart_cmty_menu (id,menu_code,menu_name,parent_code,parentid,menu_type,menu_url,full_menu_name,create_by,create_time,update_by,update_time,parent_name,identifier,create_by_id,update_by_id,zt_update_time,zt_create_time,apis,extra) VALUES
(305881,'100008100000100003100002','绑定员工','100008100000100003',303927,2,'/organization-management/views/role-organization/staff','角色管理/员工授权','supperadm','2022-08-22 17:38:37','功夫熊猫','2022-08-22 17:38:37','角色管理','digital-staff-authority',NULL,'28449','2022-08-22 17:38:36','2022-08-13 16:01:59','',''),
(305882,'100008100001100000','项目详情','100008100001',303928,2,'/project/project-detail','数字云/项目管理/项目详情','supperadm','2022-08-13 16:02:40','supperadm','2022-08-13 16:02:40','项目管理','digital-project-detail',NULL,NULL,'2022-08-13 16:02:40','2022-08-13 16:02:40','',''),
(305883,'100008100001100001','项目新增编辑','100008100001',303928,2,'/project/project-add','数字云/项目管理/项目新增编辑','supperadm','2022-08-13 16:03:00','supperadm','2022-08-13 16:03:00','项目管理','digital-project-add',NULL,NULL,'2022-08-13 16:02:59','2022-08-13 16:02:59','',''),
(312460,'100006100007100002100000','统计','100006100007100002',303913,2,'/questionnaire/*','问卷统计/所有问卷应用','supperadm','2022-08-22 14:21:02','功夫熊猫','2022-08-22 14:21:02','问卷统计','content-questionnaire-all',NULL,'28449','2022-08-22 14:21:01','2022-08-16 16:28:31','',''),
(333054,'100009100001100000','插件详情','100009100001',303932,2,'/application-management/plugins/detail/:id','插件管理/插进详情','supperadm','2022-08-22 14:30:10','功夫熊猫','2022-08-22 14:30:10','插件管理','sys-manage-plugin-detail',NULL,'28449','2022-08-22 14:30:10','2022-08-17 14:10:12','',''),
(333055,'100009100000100000','APP管理详情','100009100000',303931,2,'/application-management/detail/:id','系统应用管理/APP管理/APP管理详情','supperadm','2022-08-17 14:11:58','supperadm','2022-08-17 14:11:58','APP管理','sys-manage-app-detail',NULL,NULL,'2022-08-17 14:11:58','2022-08-17 14:11:58','',''),
(338798,'100009100005','角色场景','100009',303930,2,'/application-management/role-scene','系统应用管理/角色场景','supperadm','2022-08-19 09:43:01','supperadm','2022-08-19 09:43:01','系统应用管理','system-setting-role-scene',NULL,NULL,'2022-08-19 09:43:01','2022-08-19 09:43:01','',''),
(341449,'100005100000100000100000','新增工单','100005100000100000',303884,2,'/workorder/workorder-add','工单管理/工单列表/新增工单','supperadm','2022-08-19 14:50:35','supperadm','2022-08-19 14:50:35','工单列表','service-workorder-list-add',NULL,NULL,'2022-08-19 14:50:35','2022-08-19 14:50:35','',''),
(341503,'100005100000100002100000','新增流程','100005100000100002',303886,2,'/workorder/workorder-flow-add','工单管理/流程设置/新增流程','supperadm','2022-08-19 14:51:06','supperadm','2022-08-19 14:51:06','流程设置','service-workorder-flow-add',NULL,NULL,'2022-08-19 14:51:05','2022-08-19 14:51:05','',''),
(341981,'100005100000100000100001','工单详情','100005100000100000',303884,2,'/workorder/workorder-detail','工单管理/工单列表/工单详情','supperadm','2022-08-19 14:52:46','supperadm','2022-08-19 14:52:46','工单列表','service-workorder-list-detail',NULL,NULL,'2022-08-19 14:52:45','2022-08-19 14:52:45','','');
INSERT INTO smart_cmty_menu (id,menu_code,menu_name,parent_code,parentid,menu_type,menu_url,full_menu_name,create_by,create_time,update_by,update_time,parent_name,identifier,create_by_id,update_by_id,zt_update_time,zt_create_time,apis,extra) VALUES
(349451,'100002100002100006100000','月卡管理详情','100002100002100006',305766,2,'/smart-parking/card-management/details/:id','月卡管理/月卡管理详情','supperadm','2022-08-22 17:25:44','功夫熊猫','2022-08-22 17:25:44','月卡管理','parking-card-management-details',NULL,'28449','2022-08-22 17:25:43','2022-08-22 17:21:21','',''),
(352549,'100002100006100000100000','月卡收费对账详情','100002100006100000',303657,2,'/smart-parking/account-check/detail1/:checkId/:powerId','对账管理/月卡收费对账/月卡收费对账详情','功夫熊猫','2022-08-23 16:47:27','supperadm','2022-08-23 16:47:27','月卡收费对账','parking-account-check-month-detail','28449',NULL,'2022-08-23 16:47:27','2022-08-23 16:47:27','',''),
(352915,'100002100008100000100000','车场配置详情','100002100008100000',303664,2,'/smart-parking/parking-lot-management/detail/:id','车场管理/车场配置/车场配置详情','功夫熊猫','2022-08-23 17:04:53','supperadm','2022-08-23 17:04:53','车场配置','parking-parking-lot-config-detail','28449',NULL,'2022-08-23 17:04:53','2022-08-23 17:04:53','',''),
(352917,'100002100006100089100000','停车收费对账详情','100002100006100089',303658,2,'/smart-parking/account-check/detail2/:checkId/:powerId','对账管理/停车收费对账/停车收费对账详情','功夫熊猫','2022-08-23 17:06:56','supperadm','2022-08-23 17:06:56','停车收费对账','parking-account-check-temp-detail','28449',NULL,'2022-08-23 17:06:55','2022-08-23 17:06:55','',''),
(352918,'100002100006100001100000','异常收费对账详情','100002100006100001',303659,2,'/smart-parking/account-check/detail3/:checkId/:powerId','对账管理/异常收费对账/异常收费对账详情','功夫熊猫','2022-08-23 17:07:31','supperadm','2022-08-23 17:07:31','异常收费对账','parking-account-check-abnormal-detail','28449',NULL,'2022-08-23 17:07:31','2022-08-23 17:07:31','',''),
(374241,'100003100005','儿童看护','100003',303590,2,'/video-guard/childcare/equipment','发卡管理/儿童看护','功夫熊猫','2022-08-29 11:18:25','supperadm','2022-08-29 11:18:25','智慧安防','smart-guard-childcare','28449',NULL,'2022-08-29 11:18:24','2022-08-29 11:18:24','',''),
(374242,'100003100005100000','设备看护','100003100005',374241,2,'/video-guard/childcare/equipment','发卡管理/儿童看护/设备看护','功夫熊猫','2022-08-29 11:18:54','supperadm','2022-08-29 11:18:54','儿童看护','smart-guard-childcare-equipment','28449',NULL,'2022-08-29 11:18:53','2022-08-29 11:18:53','',''),
(374288,'100003100005100001','看护儿童','100003100005',374241,2,'/video-guard/childcare/nurse','发卡管理/儿童看护/看护儿童','功夫熊猫','2022-08-29 11:19:19','supperadm','2022-08-29 11:19:19','儿童看护','smart-guard-childcare-nurse','28449',NULL,'2022-08-29 11:19:19','2022-08-29 11:19:19','',''),
(374312,'100003100005100002','看护记录','100003100005',374241,2,'/video-guard/childcare/record','发卡管理/儿童看护/看护记录','功夫熊猫','2022-08-29 11:19:54','supperadm','2022-08-29 11:19:54','儿童看护','smart-guard-childcare-record','28449',NULL,'2022-08-29 11:19:54','2022-08-29 11:19:54','',''),
(2333384,'100002100003106670','车主管理','100002100003',303628,2,'/smart-parking/car-owner-management/list','人车管理/1车主管理','supperadm','2022-08-30 16:52:40','功夫熊猫','2022-08-30 16:52:40','人车管理','parking-car-owner-management',NULL,'28449','2022-08-30 16:52:40','2022-08-30 16:44:18','','');
INSERT INTO smart_cmty_menu (id,menu_code,menu_name,parent_code,parentid,menu_type,menu_url,full_menu_name,create_by,create_time,update_by,update_time,parent_name,identifier,create_by_id,update_by_id,zt_update_time,zt_create_time,apis,extra) VALUES
(2333385,'100002100003106671','车辆管理','100002100003',303628,2,'/smart-parking/car-owner-management/vehicle-list','人车管理/1车辆管理','supperadm','2022-08-30 16:52:45','功夫熊猫','2022-08-30 16:52:45','人车管理','parking-vehicle-list',NULL,'28449','2022-08-30 16:52:45','2022-08-30 16:46:40','',''),
(2333386,'100002100003106672','白名单管理','100002100003',303628,2,'/smart-parking/car-owner-management/white-list/list','人车管理/1白名单管理','supperadm','2022-08-30 16:52:50','功夫熊猫','2022-08-30 16:52:50','人车管理','parking-white-list',NULL,'28449','2022-08-30 16:52:50','2022-08-30 16:47:13','',''),
(2333387,'100002100003106673','黑名单管理','100002100003',303628,2,'/smart-parking/car-owner-management/black-list/list','人车管理/1黑名单管理','supperadm','2022-08-30 16:52:55','功夫熊猫','2022-08-30 16:52:55','人车管理','parking-black-list',NULL,'28449','2022-08-30 16:52:55','2022-08-30 16:48:03','',''),
(2333388,'100002100003106674','车辆申诉','100002100003',303628,2,'/smart-parking/car-owner-management/vehicle-appeal','智慧车行/人车管理/车辆申诉','功夫熊猫','2022-08-30 16:48:24','supperadm','2022-08-30 16:48:24','人车管理','parking-vehicle-appeal','28449',NULL,'2022-08-30 16:48:23','2022-08-30 16:48:23','',''),
(2333389,'100002100003106671100000','车辆管理详情','100002100003106671',2333385,2,'/smart-parking/car-owner-management/vehicle-detail/:carId','人车管理/车辆管理/车辆管理详情','功夫熊猫','2022-08-30 16:49:09','supperadm','2022-08-30 16:49:09','1车辆管理','parking-vehicle-list-detail','28449',NULL,'2022-08-30 16:49:09','2022-08-30 16:49:09','',''),
(2333390,'100002100003106670100000','车主管理详情','100002100003106670',2333384,2,'/smart-parking/car-owner-management/detail/:id','智慧车行/人车管理/1车主管理/车主管理详情','功夫熊猫','2022-08-30 16:50:05','supperadm','2022-08-30 16:50:05','1车主管理','parking-car-owner-detail','28449',NULL,'2022-08-30 16:50:04','2022-08-30 16:50:04','',''),
(2334205,'100002100005100999','人工放行','100002100005',303646,2,'/smart-parking/audit-management/manual-release','稽核管理/1人工放行','supperadm','2022-08-30 16:59:15','功夫熊猫','2022-08-30 16:59:15','稽核管理','parking-manual-release',NULL,'28449','2022-08-30 16:59:14','2022-08-30 16:55:10','',''),
(2346954,'100002100005101000','手动开闸','100002100005',303646,2,'/smart-parking/audit-management/manual-brake','智慧车行/稽核管理/手动开闸','功夫熊猫','2022-08-30 16:57:18','supperadm','2022-08-30 16:57:18','稽核管理','parking-manual-brake','28449',NULL,'2022-08-30 16:57:17','2022-08-30 16:57:17','',''),
(2348648,'100002100005101001','车牌矫正','100002100005',303646,2,'/smart-parking/audit-management/plate-correction','智慧车行/稽核管理/车牌矫正','功夫熊猫','2022-08-30 16:57:34','supperadm','2022-08-30 16:57:34','稽核管理','parking-plate-correction','28449',NULL,'2022-08-30 16:57:34','2022-08-30 16:57:34','',''),
(2350592,'100002100005101002','异常收费','100002100005',303646,2,'/smart-parking/audit-management/abnormal-charges','智慧车行/稽核管理/异常收费','功夫熊猫','2022-08-30 16:57:53','supperadm','2022-08-30 16:57:53','稽核管理','parking-abnormal-charges','28449',NULL,'2022-08-30 16:57:53','2022-08-30 16:57:53','','');
INSERT INTO smart_cmty_menu (id,menu_code,menu_name,parent_code,parentid,menu_type,menu_url,full_menu_name,create_by,create_time,update_by,update_time,parent_name,identifier,create_by_id,update_by_id,zt_update_time,zt_create_time,apis,extra) VALUES
(2353081,'100002100005101003','免费放行','100002100005',303646,2,'/smart-parking/park/free-pass','智慧车行/稽核管理/免费放行','功夫熊猫','2022-08-30 16:58:18','supperadm','2022-08-30 16:58:18','稽核管理','parking-free-release','28449',NULL,'2022-08-30 16:58:17','2022-08-30 16:58:17','',''),
(2354824,'100002100005101004','其他异常','100002100005',303646,2,'/smart-parking/audit-management/other-abnormal-charges','智慧车行/稽核管理/其他异常','功夫熊猫','2022-08-30 16:58:35','supperadm','2022-08-30 16:58:35','稽核管理','parking-other-abnormal-charges','28449',NULL,'2022-08-30 16:58:34','2022-08-30 16:58:34','',''),
(2374365,'100002100007100090','月卡缴费记录','100002100007',303648,2,'/smart-parking/operating-statement/month-card','经营报表/1月卡缴费记录','supperadm','2022-08-30 17:02:54','功夫熊猫','2022-08-30 17:02:54','经营报表','parking-month-card-charge-record',NULL,'28449','2022-08-30 17:02:53','2022-08-30 17:01:47','',''),
(2375851,'100002100007100091','临时缴费记录','100002100007',303648,2,'/smart-parking/operating-statement/tem-parking','智慧车行/对账管理/临时缴费记录','功夫熊猫','2022-08-30 17:02:02','supperadm','2022-08-30 17:02:02','经营报表','parking-temp-charge-record','28449',NULL,'2022-08-30 17:02:01','2022-08-30 17:02:01','',''),
(2377441,'100002100007100092','月卡延期记录','100002100007',303648,2,'/smart-parking/operating-statement/report-mon-extension','智慧车行/对账管理/月卡延期记录','功夫熊猫','2022-08-30 17:02:17','supperadm','2022-08-30 17:02:17','经营报表','parking-report-mon-extension','28449',NULL,'2022-08-30 17:02:17','2022-08-30 17:02:17','',''),
(2378912,'100002100007100093','月卡注销记录','100002100007',303648,2,'/smart-parking/operating-statement/report-mon-logout','智慧车行/对账管理/月卡注销记录','功夫熊猫','2022-08-30 17:02:32','supperadm','2022-08-30 17:02:32','经营报表','parking-report-mon-logout','28449',NULL,'2022-08-30 17:02:31','2022-08-30 17:02:31','','');
2 工单库 remake_work_order_prod
注： 生产未执行：
alter table workorder add key index_key_order_no (order_no);
alter table workorder add key index_key_cust_id (cust_id);
alter table workorder add key index_key_user_id (user_id);
alter table workorder_score_rule add column top_org_id bigint comment '顶级业务组织ID';
3 iot_service_wechat
## 虚拟门店新增项目id
ALTER TABLE t_wechat_shop ADD space_id bigint(20) DEFAULT NULL COMMENT '项目id';
CREATE INDEX idx_spaceId on t_wechat_shop(space_id);
## 删除t_shop_subtenant_rel字段和唯一索引
DROP INDEX uniq_shop_subtenat_type ON t_shop_subtenant_rel;
ALTER TABLE t_shop_subtenant_rel drop column account_type;
## 删除t_subtenant索引和新增字段及索引
DROP INDEX admin_subid_unique ON t_subtenant;
DROP INDEX subid_unique ON t_subtenant;
ALTER TABLE t_subtenant ADD authen_type varchar(12) NOT NULL DEFAULT 'wechat' COMMENT 'wechat:微信公众号，alipay:支付宝生活号';
CREATE UNIQUE INDEX uni_subid_authenType ON t_subtenant(sub_id,authen_type);
CREATE INDEX idx_muchApiId on t_subtenant(much_api_id);
## t_wechat_much_root字段必填改为非必填
ALTER TABLE t_wechat_much_root CHANGE COLUMN comany_certificate_no comany_certificate_no varchar(32) DEFAULT NULL;
ALTER TABLE t_wechat_much_root CHANGE COLUMN ligal_person ligal_person varchar(32) DEFAULT NULL;
CREATE INDEX idx_companyName on t_wechat_much_root(company_name);
## 修改t_much_api_wechat
ALTER TABLE t_much_api_wechat MODIFY column appsecret varchar(64) NOT NULL;
ALTER TABLE t_much_api_wechat MODIFY column appid varchar(64) NOT NULL;