1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
| ALTER TABLE HUGETEST.dyh_judic_info ADD handle_unit_id VARCHAR(256);
| COMMENT ON COLUMN HUGETEST.dyh_judic_info.handle_unit_id IS '审核人单位编号';
|
| ALTER TABLE HUGETEST.dyh_judic_info ADD handle_unit_name VARCHAR(256);
| COMMENT ON COLUMN HUGETEST.dyh_judic_info.handle_unit_name IS '审核人单位名称';
|
| ALTER TABLE HUGETEST.dyh_judic_info ADD handle_dept_id VARCHAR(256);
| COMMENT ON COLUMN HUGETEST.dyh_judic_info.handle_dept_id IS '审核人部门编号';
|
| ALTER TABLE HUGETEST.dyh_judic_info ADD handle_dept_name VARCHAR(256);
| COMMENT ON COLUMN HUGETEST.dyh_judic_info.handle_dept_name IS '审核人部门名称';
|
| ALTER TABLE HUGETEST.dyh_judic_info ADD handle_user_id VARCHAR(256);
| COMMENT ON COLUMN HUGETEST.dyh_judic_info.handle_user_id IS '审核人编号';
|
| ALTER TABLE HUGETEST.dyh_judic_info ADD handle_user_name VARCHAR(256);
| COMMENT ON COLUMN HUGETEST.dyh_judic_info.handle_user_name IS '审核人名称';
|
| ALTER TABLE HUGETEST.dyh_judic_info ADD handle_content VARCHAR(6000);
| COMMENT ON COLUMN HUGETEST.dyh_judic_info.handle_content IS '审核意见';
|
| ALTER TABLE HUGETEST.dyh_judic_info ADD status INT;
| COMMENT ON COLUMN HUGETEST.dyh_judic_info.status IS '审核进度，0：进行中，1：已完成';
|
| ALTER TABLE HUGETEST.dyh_judic_info ADD handle_time TIMESTAMP(6);
| COMMENT ON COLUMN HUGETEST.dyh_judic_info.handle_time IS '审核时间';
|
|
| insert into "HUGETEST"."dyh_rs_menu" ("id", "menu_type", "menu_tag", "menu_name", "menu_icon", "menu_url", "menu_des", "app_client", "app_type", "sorts", "parent_id", "delete_status", "create_time", "update_time") values ('202409101005311026', 2, 'sfqr', '司法确认', 'BarChartOutlined', '/mediate/judicialSubmit', '司法确认', 1, 1, 11, '202409101005311000', 0, null, null);
| insert into "HUGETEST"."dyh_rs_menu" ("id", "menu_type", "menu_tag", "menu_name", "menu_icon", "menu_url", "menu_des", "app_client", "app_type", "sorts", "parent_id", "delete_status", "create_time", "update_time") values ('202409101005311027', 3, 'show', '显示', null, null, '显示', 1, 1, 1, '202409101005311026', 0, null, null);
| insert into "HUGETEST"."dyh_rs_menu" ("id", "menu_type", "menu_tag", "menu_name", "menu_icon", "menu_url", "menu_des", "app_client", "app_type", "sorts", "parent_id", "delete_status", "create_time", "update_time") values ('202409101005311028', 2, 'sfcl', '司法处理', 'BarChartOutlined', '/mediate/courtList', '司法处理', 1, 1, 13, '202409101005311000', 0, null, null);
| insert into "HUGETEST"."dyh_rs_menu" ("id", "menu_type", "menu_tag", "menu_name", "menu_icon", "menu_url", "menu_des", "app_client", "app_type", "sorts", "parent_id", "delete_status", "create_time", "update_time") values ('202409101005311029', 3, 'show', '显示', null, null, '显示', 1, 1, 1, '202409101005311028', 0, null, null);
| insert into "HUGETEST"."dyh_rs_menu" ("id", "menu_type", "menu_tag", "menu_name", "menu_icon", "menu_url", "menu_des", "app_client", "app_type", "sorts", "parent_id", "delete_status", "create_time", "update_time") values ('202409101005311030', 2, 'sfsh', '司法审核', 'BarChartOutlined', '/mediate/courtAuditList', '司法审核', 1, 1, 12, '202409101005311000', 0, null, null);
| insert into "HUGETEST"."dyh_rs_menu" ("id", "menu_type", "menu_tag", "menu_name", "menu_icon", "menu_url", "menu_des", "app_client", "app_type", "sorts", "parent_id", "delete_status", "create_time", "update_time") values ('202409101005311031', 3, 'show', '显示', null, null, '显示', 1, 1, 1, '202409101005311030', 0, null, null);
|
| insert into "HUGETEST"."dyh_rs_role" ("id", "name", "role_type", "delete_status", "create_time", "update_time") values ('22_00024-5', '法院', 1, 0, null, null);
| insert into "HUGETEST"."dyh_rs_role" ("id", "name", "role_type", "delete_status", "create_time", "update_time") values ('22_00024-6', '法官', 1, 0, null, null);
| insert into "HUGETEST"."dyh_rs_role" ("id", "name", "role_type", "delete_status", "create_time", "update_time") values ('22_00024-8', '法官助理/书记员', 1, 0, null, null);
|
|
|
| insert into "gzdyh_prod"."dyh_rs_rolefun" ("id", "role_id", "menu_id", "parent_id", "create_time", "update_time") values ('2409101144491099', '22_00024-1', '202409101005311026', null, null, null);
| insert into "gzdyh_prod"."dyh_rs_rolefun" ("id", "role_id", "menu_id", "parent_id", "create_time", "update_time") values ('2409101144491100', '22_00024-2', '202409101005311026', null, null, null);
| insert into "gzdyh_prod"."dyh_rs_rolefun" ("id", "role_id", "menu_id", "parent_id", "create_time", "update_time") values ('2409101144491101', '22_00024-3', '202409101005311026', null, null, null);
| insert into "gzdyh_prod"."dyh_rs_rolefun" ("id", "role_id", "menu_id", "parent_id", "create_time", "update_time") values ('2409101144491102', '22_00024-4', '202409101005311026', null, null, null);
| insert into "gzdyh_prod"."dyh_rs_rolefun" ("id", "role_id", "menu_id", "parent_id", "create_time", "update_time") values ('2409101144491103', '22_00024-5', '202409101005311026', null, null, null);
| insert into "gzdyh_prod"."dyh_rs_rolefun" ("id", "role_id", "menu_id", "parent_id", "create_time", "update_time") values ('2409101144491104', '22_00024-6', '202409101005311026', null, null, null);
| insert into "gzdyh_prod"."dyh_rs_rolefun" ("id", "role_id", "menu_id", "parent_id", "create_time", "update_time") values ('2409101144491105', '22_00024-8', '202409101005311026', null, null, null);
| insert into "gzdyh_prod"."dyh_rs_rolefun" ("id", "role_id", "menu_id", "parent_id", "create_time", "update_time") values ('2409101144491106', '22_00024-1', '202409101005311027', null, null, null);
| insert into "gzdyh_prod"."dyh_rs_rolefun" ("id", "role_id", "menu_id", "parent_id", "create_time", "update_time") values ('2409101144491107', '22_00024-2', '202409101005311027', null, null, null);
| insert into "gzdyh_prod"."dyh_rs_rolefun" ("id", "role_id", "menu_id", "parent_id", "create_time", "update_time") values ('2409101144491108', '22_00024-3', '202409101005311027', null, null, null);
| insert into "gzdyh_prod"."dyh_rs_rolefun" ("id", "role_id", "menu_id", "parent_id", "create_time", "update_time") values ('2409101144491109', '22_00024-4', '202409101005311027', null, null, null);
| insert into "gzdyh_prod"."dyh_rs_rolefun" ("id", "role_id", "menu_id", "parent_id", "create_time", "update_time") values ('2409101144491110', '22_00024-5', '202409101005311027', null, null, null);
| insert into "gzdyh_prod"."dyh_rs_rolefun" ("id", "role_id", "menu_id", "parent_id", "create_time", "update_time") values ('2409101144491111', '22_00024-6', '202409101005311027', null, null, null);
| insert into "gzdyh_prod"."dyh_rs_rolefun" ("id", "role_id", "menu_id", "parent_id", "create_time", "update_time") values ('2409101144491112', '22_00024-8', '202409101005311027', null, null, null);
| insert into "gzdyh_prod"."dyh_rs_rolefun" ("id", "role_id", "menu_id", "parent_id", "create_time", "update_time") values ('2409101144491113', '22_00024-2', '202409101005311028', null, null, null);
| insert into "gzdyh_prod"."dyh_rs_rolefun" ("id", "role_id", "menu_id", "parent_id", "create_time", "update_time") values ('2409101144491114', '22_00024-3', '202409101005311028', null, null, null);
| insert into "gzdyh_prod"."dyh_rs_rolefun" ("id", "role_id", "menu_id", "parent_id", "create_time", "update_time") values ('2409101144491115', '22_00024-6', '202409101005311028', null, null, null);
| insert into "gzdyh_prod"."dyh_rs_rolefun" ("id", "role_id", "menu_id", "parent_id", "create_time", "update_time") values ('2409101144491116', '22_00024-8', '202409101005311028', null, null, null);
| insert into "gzdyh_prod"."dyh_rs_rolefun" ("id", "role_id", "menu_id", "parent_id", "create_time", "update_time") values ('2409101144491117', '22_00024-2', '202409101005311029', null, null, null);
| insert into "gzdyh_prod"."dyh_rs_rolefun" ("id", "role_id", "menu_id", "parent_id", "create_time", "update_time") values ('2409101144491118', '22_00024-3', '202409101005311029', null, null, null);
| insert into "gzdyh_prod"."dyh_rs_rolefun" ("id", "role_id", "menu_id", "parent_id", "create_time", "update_time") values ('2409101144491119', '22_00024-6', '202409101005311029', null, null, null);
| insert into "gzdyh_prod"."dyh_rs_rolefun" ("id", "role_id", "menu_id", "parent_id", "create_time", "update_time") values ('2409101144491120', '22_00024-8', '202409101005311029', null, null, null);
| insert into "gzdyh_prod"."dyh_rs_rolefun" ("id", "role_id", "menu_id", "parent_id", "create_time", "update_time") values ('2409101144491121', '22_00024-2', '202409101005311030', null, null, null);
| insert into "gzdyh_prod"."dyh_rs_rolefun" ("id", "role_id", "menu_id", "parent_id", "create_time", "update_time") values ('2409101144491122', '22_00024-3', '202409101005311030', null, null, null);
| insert into "gzdyh_prod"."dyh_rs_rolefun" ("id", "role_id", "menu_id", "parent_id", "create_time", "update_time") values ('2409101144491123', '22_00024-6', '202409101005311030', null, null, null);
| insert into "gzdyh_prod"."dyh_rs_rolefun" ("id", "role_id", "menu_id", "parent_id", "create_time", "update_time") values ('2409101144491124', '22_00024-8', '202409101005311030', null, null, null);
| insert into "gzdyh_prod"."dyh_rs_rolefun" ("id", "role_id", "menu_id", "parent_id", "create_time", "update_time") values ('2409101144491125', '22_00024-2', '202409101005311031', null, null, null);
| insert into "gzdyh_prod"."dyh_rs_rolefun" ("id", "role_id", "menu_id", "parent_id", "create_time", "update_time") values ('2409101144491126', '22_00024-3', '202409101005311031', null, null, null);
| insert into "gzdyh_prod"."dyh_rs_rolefun" ("id", "role_id", "menu_id", "parent_id", "create_time", "update_time") values ('2409101144491127', '22_00024-6', '202409101005311031', null, null, null);
| insert into "gzdyh_prod"."dyh_rs_rolefun" ("id", "role_id", "menu_id", "parent_id", "create_time", "update_time") values ('2409101144491128', '22_00024-8', '202409101005311031', null, null, null);
|
|
