8.0.sql
22.7 KB
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
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
/*
change.sql 说明
1.数据库相关修改添加到对应的 change.sql 文件,无需调整其他 sql 文件
2.sql 语句验证正确后再提交
*/
alter table portal_sys_identity alter column alias_ type varchar(64) using alias_::varchar(64);
drop index idx_sys_properties_alias;
create unique index idx_sys_properties_alias
on portal_sys_properties (alias);
-- yujl 2021-12-03 增加外部系统授权人的姓名字段
ALTER TABLE PORTAL_BIZ_SYSTEM ADD COLUMN ROBOT_NAME_ varchar2 (64);
-- yujl 2021-12-03 增加外部系统管理员表
CREATE TABLE portal_biz_system_auth(
ID_ VARCHAR(64),
SYS_CODE_ VARCHAR(50),
SYS_NAME_ VARCHAR(50),
MANAGER_ID_ VARCHAR(255),
MANAGER_NAME_ VARCHAR(255),
CREATE_TIME_ timestamp,
CREATE_BY_ VARCHAR(255),
CREATE_ORG_ID_ VARCHAR(255),
IS_DELE_ VARCHAR(10),
UPDATE_TIME_ timestamp,
UPDATE_BY_ VARCHAR(64),
TENANT_ID_ VARCHAR(255)
);
COMMENT ON TABLE portal_biz_system_auth IS '外部系统管理员表';
-- yujl 2021-12-03 新增【外部系统消息日志】菜单
INSERT into portal_sys_menu(ID_, PARENT_ID_, NAME_, ALIAS_, ACTIVE_TAB_, MENU_ICON_, OPENED_, SN_, TABS_STYLE_, PATH_, HREF_, ROUTE_EXTEND_, TENANT_ID_) VALUES ('1467391005218881536', '5403008', '外部系统消息日志', 'externalSystemQueueLog', '', '', NULL, 7, '', '-1.1.3421053.5403008.1467391005218881536.', '', '{\"path\":\"\",\"component\":\"Layout\",\"redirect\":\"\",\"alwaysShow\":false,\"caseSensitive\":false,\"meta\":{\"title\":\"\"}}', '-1');
-- jason 2021-12-10 新增表单脚本js字段
alter table "form_history_record" add column("DIY_JS_" TEXT);
comment on column "form_history_record"."DIY_JS_" is '表单脚本js';
-- yujl 2021-12-10 门户设计-个人信息栏目更新显示岗位的字段属性
update portal_sys_column set template_html ='PGRpdj4KICA8ZWwtcm93IDpndXR0ZXI9IjIwIiBzdHlsZT0icGFkZGluZy10b3A6IDEwcHg7IHBhZGRpbmctYm90dG9tOiAxMHB4Ij4KICAgIDxlbC1jb2wgOnNwYW49IjEyIj4KICAgICAgPGRpdiBzdHlsZT0iZmxvYXQ6IGxlZnQ7IHdpZHRoOiA2MHB4OyBoZWlnaHQ6IDYwcHg7IGJvcmRlci1yYWRpdXM6IDUwJSI+CiAgICAgICAgPGltZwogICAgICAgICAgICAgc3JjPSJodHRwczovL2Z1c3MxMC5lbGVtZWNkbi5jb20vZS81ZC80YTczMWE5MDU5NGE0YWY1NDRjMGMyNTk0MTE3MWpwZWcuanBlZyIKICAgICAgICAgICAgIHN0eWxlPSJ3aWR0aDogNjBweDsgaGVpZ2h0OiA2MHB4OyBiYWNrZ3JvdW5kOiByZ2JhKDI0NSwgMjQ1LCAyNDUsIDEpOyBib3JkZXItcmFkaXVzOiA1MCUiCiAgICAgICAgICAgICAvPgogICAgICA8L2Rpdj4KICAgICAgPGRpdiBzdHlsZT0iZmxvYXQ6IGxlZnQ7IHBhZGRpbmctbGVmdDogOHB4Ij4KICAgICAgICA8c3BhbgogICAgICAgICAgICAgIHN0eWxlPSIKICAgICAgICAgICAgICAgICAgICAgZm9udC1zaXplOiAyMHB4OwogICAgICAgICAgICAgICAgICAgICBmb250LWZhbWlseTogTWljcm9zb2Z0IFlhSGVpOwogICAgICAgICAgICAgICAgICAgICBmb250LXdlaWdodDogNDAwOwogICAgICAgICAgICAgICAgICAgICBjb2xvcjogcmdiYSg4NSwgODUsIDg1LCAxKTsKICAgICAgICAgICAgICAgICAgICAgbGluZS1oZWlnaHQ6IDMwcHg7CiAgICAgICAgICAgICAgICAgICAgICIKICAgICAgICAgICAgICA+CiAgICAgICAgICDmgqjlpb3vvIF7eyBkYXRhLnVzZXIgPyBkYXRhLnVzZXIuZnVsbG5hbWUgOiAnJyB9fe+8jOelneS9oOW8gOW/g+avj+S4gOWkqe+8gQogICAgICAgIDwvc3Bhbj4KICAgICAgICA8YnIgLz4KICAgICAgICA8c3BhbgogICAgICAgICAgICAgIHN0eWxlPSIKICAgICAgICAgICAgICAgICAgICAgZm9udC1zaXplOiAxMnB4OwogICAgICAgICAgICAgICAgICAgICBmb250LWZhbWlseTogTWljcm9zb2Z0IFlhSGVpOwogICAgICAgICAgICAgICAgICAgICBmb250LXdlaWdodDogNDAwOwogICAgICAgICAgICAgICAgICAgICBjb2xvcjogcmdiYSgxNDUsIDE0NSwgMTQ1LCAxKTsKICAgICAgICAgICAgICAgICAgICAgbGluZS1oZWlnaHQ6IDMwcHg7CiAgICAgICAgICAgICAgICAgICAgICIKICAgICAgICAgICAgICA+CiAgICAgICAgICB7eyBkYXRhLmN1clBvc3R9fQogICAgICAgIDwvc3Bhbj4KICAgICAgPC9kaXY+CiAgICA8L2VsLWNvbD4KICAgIDxlbC1jb2wgOnNwYW49IjMiIHN0eWxlPSJwYWRkaW5nLXRvcDogNXB4Ij4KICAgICAgPGRpdiBzdHlsZT0iZmxvYXQ6IGxlZnQiIEBjbGljaz0iaGFuZGxlUm93Q2xpY2soJy9tYXR0ZXIvbXlUYXNrP3RhYkFjdGl2ZU5hbWU9dG9kbycpIj4KICAgICAgICA8ZGl2CiAgICAgICAgICAgICBzdHlsZT0iZmxvYXQ6IGxlZnQ7IHdpZHRoOiA0MnB4OyBoZWlnaHQ6IDQycHg7IGJhY2tncm91bmQ6IHJnYmEoMTA0LCAxOTUsIDI1MywgMSk7IGJvcmRlci1yYWRpdXM6IDIxcHgiCiAgICAgICAgICAgICA+CiAgICAgICAgICA8c3BhbiBjbGFzcz0iaWNvbi10b2RvIiBzdHlsZT0iZm9udC1zaXplOiAyOHB4OyBwYWRkaW5nOiA4cHg7IGNvbG9yOiByZ2IoMjU1LCAyNTUsIDI1NSkiPjwvc3Bhbj4KICAgICAgICA8L2Rpdj4KICAgICAgICA8ZGl2IHN0eWxlPSJmbG9hdDogbGVmdDsgcGFkZGluZy1sZWZ0OiA4cHgiPgogICAgICAgICAgPGRpdiBzdHlsZT0iaGVpZ2h0OiAxOHB4Ij4KICAgICAgICAgICAgPHNwYW4KICAgICAgICAgICAgICAgICAgc3R5bGU9IgogICAgICAgICAgICAgICAgICAgICAgICAgZm9udC1zaXplOiAyMHB4OwogICAgICAgICAgICAgICAgICAgICAgICAgZm9udC1mYW1pbHk6IE1pY3Jvc29mdCBZYUhlaTsKICAgICAgICAgICAgICAgICAgICAgICAgIGZvbnQtd2VpZ2h0OiA0MDA7CiAgICAgICAgICAgICAgICAgICAgICAgICBjb2xvcjogcmdiYSgyOCwgMjgsIDI4LCAxKTsKICAgICAgICAgICAgICAgICAgICAgICAgIGxpbmUtaGVpZ2h0OiAzMHB4OwogICAgICAgICAgICAgICAgICAgICAgICAgIgogICAgICAgICAgICAgICAgICA+CiAgICAgICAgICAgICAge3sgZGF0YS5teVRha3MgPyBkYXRhLm15VGFrcy5kYXRhVGV4dCA6ICcnIH19CiAgICAgICAgICAgIDwvc3Bhbj4KICAgICAgICAgIDwvZGl2PgogICAgICAgICAgPGRpdj4KICAgICAgICAgICAgPHNwYW4KICAgICAgICAgICAgICAgICAgc3R5bGU9IgogICAgICAgICAgICAgICAgICAgICAgICAgZm9udC1zaXplOiAxMnB4OwogICAgICAgICAgICAgICAgICAgICAgICAgZm9udC1mYW1pbHk6IE1pY3Jvc29mdCBZYUhlaTsKICAgICAgICAgICAgICAgICAgICAgICAgIGZvbnQtd2VpZ2h0OiA0MDA7CiAgICAgICAgICAgICAgICAgICAgICAgICBjb2xvcjogcmdiYSgxNDUsIDE0NSwgMTQ1LCAxKTsKICAgICAgICAgICAgICAgICAgICAgICAgIGxpbmUtaGVpZ2h0OiAzMHB4OwogICAgICAgICAgICAgICAgICAgICAgICAgIgogICAgICAgICAgICAgICAgICA+CiAgICAgICAgICAgICAg5b6F5Yqe5pWw6YePCiAgICAgICAgICAgIDwvc3Bhbj4KICAgICAgICAgIDwvZGl2PgogICAgICAgIDwvZGl2PgogICAgICA8L2Rpdj4KICAgICAgPGRpdiBzdHlsZT0iZmxvYXQ6IHJpZ2h0Ij4KICAgICAgICA8c3BhbiBjbGFzcz0iZWwtZGl2aWRlciBlbC1kaXZpZGVyLS12ZXJ0aWNhbCIgc3R5bGU9ImZvbnQtc2l6ZTogNDBweCI+PC9zcGFuPgogICAgICA8L2Rpdj4KICAgIDwvZWwtY29sPgogICAgPGVsLWNvbCA6c3Bhbj0iMyIgc3R5bGU9InBhZGRpbmctdG9wOiA1cHgiPgogICAgICA8ZGl2IHN0eWxlPSJmbG9hdDogbGVmdCIgQGNsaWNrPSJoYW5kbGVSb3dDbGljaygnL21hdHRlci9teVRhc2s/dGFiQWN0aXZlTmFtZT1kb25lJykiPgogICAgICAgIDxkaXYKICAgICAgICAgICAgIHN0eWxlPSJmbG9hdDogbGVmdDsgd2lkdGg6IDQycHg7IGhlaWdodDogNDJweDsgYmFja2dyb3VuZDogcmdiYSgxMTcsIDE3MSwgMjQ0LCAxKTsgYm9yZGVyLXJhZGl1czogMjFweCIKICAgICAgICAgICAgID4KICAgICAgICAgIDxzcGFuIGNsYXNzPSJpY29uLXlpYmFuIiBzdHlsZT0iZm9udC1zaXplOiAyOHB4OyBwYWRkaW5nOiA4cHg7IGNvbG9yOiByZ2IoMjU1LCAyNTUsIDI1NSkiPjwvc3Bhbj4KICAgICAgICA8L2Rpdj4KICAgICAgICA8ZGl2IHN0eWxlPSJmbG9hdDogbGVmdDsgcGFkZGluZy1sZWZ0OiA4cHgiPgogICAgICAgICAgPGRpdiBzdHlsZT0iaGVpZ2h0OiAxOHB4Ij4KICAgICAgICAgICAgPHNwYW4KICAgICAgICAgICAgICAgICAgc3R5bGU9IgogICAgICAgICAgICAgICAgICAgICAgICAgZm9udC1zaXplOiAyMHB4OwogICAgICAgICAgICAgICAgICAgICAgICAgZm9udC1mYW1pbHk6IE1pY3Jvc29mdCBZYUhlaTsKICAgICAgICAgICAgICAgICAgICAgICAgIGZvbnQtd2VpZ2h0OiA0MDA7CiAgICAgICAgICAgICAgICAgICAgICAgICBjb2xvcjogcmdiYSgyOCwgMjgsIDI4LCAxKTsKICAgICAgICAgICAgICAgICAgICAgICAgIGxpbmUtaGVpZ2h0OiAzMHB4OwogICAgICAgICAgICAgICAgICAgICAgICAgIgogICAgICAgICAgICAgICAgICA+CiAgICAgICAgICAgICAge3sgZGF0YS5teUFscmVhZHkgPyBkYXRhLm15QWxyZWFkeS5kYXRhVGV4dCA6ICcnIH19CiAgICAgICAgICAgIDwvc3Bhbj4KICAgICAgICAgIDwvZGl2PgogICAgICAgICAgPGRpdj4KICAgICAgICAgICAgPHNwYW4KICAgICAgICAgICAgICAgICAgc3R5bGU9IgogICAgICAgICAgICAgICAgICAgICAgICAgZm9udC1zaXplOiAxMnB4OwogICAgICAgICAgICAgICAgICAgICAgICAgZm9udC1mYW1pbHk6IE1pY3Jvc29mdCBZYUhlaTsKICAgICAgICAgICAgICAgICAgICAgICAgIGZvbnQtd2VpZ2h0OiA0MDA7CiAgICAgICAgICAgICAgICAgICAgICAgICBjb2xvcjogcmdiYSgxNDUsIDE0NSwgMTQ1LCAxKTsKICAgICAgICAgICAgICAgICAgICAgICAgIGxpbmUtaGVpZ2h0OiAzMHB4OwogICAgICAgICAgICAgICAgICAgICAgICAgIgogICAgICAgICAgICAgICAgICA+CiAgICAgICAgICAgICAg5bey5Yqe5pWw6YePCiAgICAgICAgICAgIDwvc3Bhbj4KICAgICAgICAgIDwvZGl2PgogICAgICAgIDwvZGl2PgogICAgICA8L2Rpdj4KICAgICAgPGRpdiBzdHlsZT0iZmxvYXQ6IHJpZ2h0Ij4KICAgICAgICA8c3BhbiBjbGFzcz0iZWwtZGl2aWRlciBlbC1kaXZpZGVyLS12ZXJ0aWNhbCIgc3R5bGU9ImZvbnQtc2l6ZTogNDBweCI+PC9zcGFuPgogICAgICA8L2Rpdj4KICAgIDwvZWwtY29sPgogICAgPGVsLWNvbCA6c3Bhbj0iMyIgc3R5bGU9InBhZGRpbmctdG9wOiA1cHgiPgogICAgICA8ZGl2IHN0eWxlPSJmbG9hdDogbGVmdCIgQGNsaWNrPSJoYW5kbGVSb3dDbGljaygnL21hdHRlci9hcHBseScpIj4KICAgICAgICA8ZGl2IHN0eWxlPSJmbG9hdDogbGVmdDsgd2lkdGg6IDQycHg7IGhlaWdodDogNDJweDsgYmFja2dyb3VuZDogcmdiYSg5NywgMTk1LCAyMjksIDEpOyBib3JkZXItcmFkaXVzOiAyMXB4Ij4KICAgICAgICAgIDxzcGFuIGNsYXNzPSJpY29uLXJlcWV1c3Qtc3RhcnQiIHN0eWxlPSJmb250LXNpemU6IDI4cHg7IHBhZGRpbmc6IDhweDsgY29sb3I6IHJnYigyNTUsIDI1NSwgMjU1KSI+PC9zcGFuPgogICAgICAgIDwvZGl2PgogICAgICAgIDxkaXYgc3R5bGU9ImZsb2F0OiBsZWZ0OyBwYWRkaW5nLWxlZnQ6IDhweCI+CiAgICAgICAgICA8ZGl2IHN0eWxlPSJoZWlnaHQ6IDE4cHgiPgogICAgICAgICAgICA8c3BhbgogICAgICAgICAgICAgICAgICBzdHlsZT0iCiAgICAgICAgICAgICAgICAgICAgICAgICBmb250LXNpemU6IDIwcHg7CiAgICAgICAgICAgICAgICAgICAgICAgICBmb250LWZhbWlseTogTWljcm9zb2Z0IFlhSGVpOwogICAgICAgICAgICAgICAgICAgICAgICAgZm9udC13ZWlnaHQ6IDQwMDsKICAgICAgICAgICAgICAgICAgICAgICAgIGNvbG9yOiByZ2JhKDI4LCAyOCwgMjgsIDEpOwogICAgICAgICAgICAgICAgICAgICAgICAgbGluZS1oZWlnaHQ6IDMwcHg7CiAgICAgICAgICAgICAgICAgICAgICAgICAiCiAgICAgICAgICAgICAgICAgID4KICAgICAgICAgICAgICB7eyBkYXRhLm15UmVxdWVzdCA/IGRhdGEubXlSZXF1ZXN0LmRhdGFUZXh0IDogJycgfX0KICAgICAgICAgICAgPC9zcGFuPgogICAgICAgICAgPC9kaXY+CiAgICAgICAgICA8ZGl2PgogICAgICAgICAgICA8c3BhbgogICAgICAgICAgICAgICAgICBzdHlsZT0iCiAgICAgICAgICAgICAgICAgICAgICAgICBmb250LXNpemU6IDEycHg7CiAgICAgICAgICAgICAgICAgICAgICAgICBmb250LWZhbWlseTogTWljcm9zb2Z0IFlhSGVpOwogICAgICAgICAgICAgICAgICAgICAgICAgZm9udC13ZWlnaHQ6IDQwMDsKICAgICAgICAgICAgICAgICAgICAgICAgIGNvbG9yOiByZ2JhKDE0NSwgMTQ1LCAxNDUsIDEpOwogICAgICAgICAgICAgICAgICAgICAgICAgbGluZS1oZWlnaHQ6IDMwcHg7CiAgICAgICAgICAgICAgICAgICAgICAgICAiCiAgICAgICAgICAgICAgICAgID4KICAgICAgICAgICAgICDmiJHnmoTor7fmsYIKICAgICAgICAgICAgPC9zcGFuPgogICAgICAgICAgPC9kaXY+CiAgICAgICAgPC9kaXY+CiAgICAgIDwvZGl2PgogICAgICA8ZGl2IHN0eWxlPSJmbG9hdDogcmlnaHQiPgogICAgICAgIDxzcGFuIGNsYXNzPSJlbC1kaXZpZGVyIGVsLWRpdmlkZXItLXZlcnRpY2FsIiBzdHlsZT0iZm9udC1zaXplOiA0MHB4Ij48L3NwYW4+CiAgICAgIDwvZGl2PgogICAgPC9lbC1jb2w+CiAgICA8ZWwtY29sIDpzcGFuPSIzIiBzdHlsZT0icGFkZGluZy10b3A6IDVweCI+CiAgICAgIDxkaXYgc3R5bGU9ImZsb2F0OiBsZWZ0IiBAY2xpY2s9ImhhbmRsZVJvd0NsaWNrKCcvbWF0dGVyL215VGFzaz90YWJBY3RpdmVOYW1lPW15RGVsZWdhdGUnKSI+CiAgICAgICAgPGRpdgogICAgICAgICAgICAgc3R5bGU9ImZsb2F0OiBsZWZ0OyB3aWR0aDogNDJweDsgaGVpZ2h0OiA0MnB4OyBiYWNrZ3JvdW5kOiByZ2JhKDEyMCwgMjE2LCAyMTcsIDEpOyBib3JkZXItcmFkaXVzOiAyMXB4IgogICAgICAgICAgICAgPgogICAgICAgICAgPHNwYW4gY2xhc3M9Imljb24tdG9kbyIgc3R5bGU9ImZvbnQtc2l6ZTogMjhweDsgcGFkZGluZzogOHB4OyBjb2xvcjogcmdiKDI1NSwgMjU1LCAyNTUpIj48L3NwYW4+CiAgICAgICAgPC9kaXY+CiAgICAgICAgPGRpdiBzdHlsZT0iZmxvYXQ6IGxlZnQ7IHBhZGRpbmctbGVmdDogOHB4Ij4KICAgICAgICAgIDxkaXYgc3R5bGU9ImhlaWdodDogMThweCI+CiAgICAgICAgICAgIDxzcGFuCiAgICAgICAgICAgICAgICAgIHN0eWxlPSIKICAgICAgICAgICAgICAgICAgICAgICAgIGZvbnQtc2l6ZTogMjBweDsKICAgICAgICAgICAgICAgICAgICAgICAgIGZvbnQtZmFtaWx5OiBNaWNyb3NvZnQgWWFIZWk7CiAgICAgICAgICAgICAgICAgICAgICAgICBmb250LXdlaWdodDogNDAwOwogICAgICAgICAgICAgICAgICAgICAgICAgY29sb3I6IHJnYmEoMjgsIDI4LCAyOCwgMSk7CiAgICAgICAgICAgICAgICAgICAgICAgICBsaW5lLWhlaWdodDogMzBweDsKICAgICAgICAgICAgICAgICAgICAgICAgICIKICAgICAgICAgICAgICAgICAgPgogICAgICAgICAgICAgIHt7IGRhdGEubXlBY2NvcmRpbmdNYXR0ZXJzID8gZGF0YS5teUFjY29yZGluZ01hdHRlcnMuZGF0YVRleHQgOiAnJyB9fQogICAgICAgICAgICA8L3NwYW4+CiAgICAgICAgICA8L2Rpdj4KICAgICAgICAgIDxkaXY+CiAgICAgICAgICAgIDxzcGFuCiAgICAgICAgICAgICAgICAgIHN0eWxlPSIKICAgICAgICAgICAgICAgICAgICAgICAgIGZvbnQtc2l6ZTogMTJweDsKICAgICAgICAgICAgICAgICAgICAgICAgIGZvbnQtZmFtaWx5OiBNaWNyb3NvZnQgWWFIZWk7CiAgICAgICAgICAgICAgICAgICAgICAgICBmb250LXdlaWdodDogNDAwOwogICAgICAgICAgICAgICAgICAgICAgICAgY29sb3I6IHJnYmEoMTQ1LCAxNDUsIDE0NSwgMSk7CiAgICAgICAgICAgICAgICAgICAgICAgICBsaW5lLWhlaWdodDogMzBweDsKICAgICAgICAgICAgICAgICAgICAgICAgICIKICAgICAgICAgICAgICAgICAgPgogICAgICAgICAgICAgIOi9rOWKnuaVsOmHjwogICAgICAgICAgICA8L3NwYW4+CiAgICAgICAgICA8L2Rpdj4KICAgICAgICA8L2Rpdj4KICAgICAgPC9kaXY+CiAgICAgIDxkaXYgc3R5bGU9ImZsb2F0OiByaWdodCI+CiAgICAgICAgPHNwYW4gY2xhc3M9ImVsLWRpdmlkZXIgZWwtZGl2aWRlci0tdmVydGljYWwiIHN0eWxlPSJmb250LXNpemU6IDQwcHgiPjwvc3Bhbj4KICAgICAgPC9kaXY+CiAgICA8L2VsLWNvbD4KICA8L2VsLXJvdz4KPC9kaXY+'
where id='1267766070928871424';
-- yujl 2021-12-18 增加外部系统管理员唯一索引
CREATE UNIQUE INDEX uni_auth ON portal_biz_system_auth (sys_code_,manager_id_);
-- zhqa 2022-1-20 流程图表添加别名字段
alter table bpm_report_list
add ALIAS_ varchar(64);
comment on column bpm_report_list.ALIAS_ is '别名';
--oyhj 2022-1-11增加通过下属管理获取当前用户的上级的人员脚本
INSERT INTO BPM_MULTI_SCRIPT(ID_, ALIAS_NAME_, ALIAS_DESC_, CLASS_NAME_, CLASS_INS_NAME_, METHOD_NAME_, METHOD_DESC_, RETURN_TYPE_, ARGUMENT_, ENABLE_, TYPE_, TENANT_ID_) VALUES ('22', NULL, NULL, 'com.hotent.runtime.script.OrgScript', 'orgScript', 'getMasterFromUnder', '通过下属管理获取当前用户的上级', 'java.util.Set', '[{\"paraName\":\"arg0\",\"paraType\":\"java.lang.String\",\"paraDesc\":\"维度id或编码\",\"multiSelect\":false,\"paraCt\":\"base:dem-selector\",\"paraCtBindKey\":\"id\",\"paraCtBindName\":\"id\"}]', 1, 2, '-1');
--oyhj2022-01-24 新增在线用户管理菜单。目录:用户管理-在线用户
INSERT INTO portal_sys_menu(ID_, PARENT_ID_, NAME_, ALIAS_, ACTIVE_TAB_, MENU_ICON_, OPENED_, SN_, TABS_STYLE_, PATH_, HREF_, TENANT_ID_) VALUES ('1376480241760997376', '3441027', '在线用户', 'onlineUserManager', '', '', NULL, 4, '', '-1.1.3441009.3441027.1376480241760997376.', '', '-1');
-- oyhj 2021-01-26 关系矩阵添加搜索条件字段标识
ALTER TABLE uc_matrix_col_def
ADD COLUMN SEARCH_FIELD_ varchar(50) null;
COMMENT ON column uc_matrix_col_def.SEARCH_FIELD_ IS '是否作为搜索条件';
-- oyhj 2021-02-9 流程自动发起配置表添加定时任务关联key
ALTER TABLE bpm_auto_start_conf
ADD COLUMN trigger_name_ varchar(100) NULL;
COMMENT ON column bpm_auto_start_conf.trigger_name_ is '触发器key';
-- yujl 2022-02-09 弹窗提醒字段名称改为name_
ALTER TABLE portal_sys_popup RENAME name TO name_;
-- jjx 2022-02-18 新增内部消息菜单地址
INSERT INTO portal_sys_menu VALUES ('1494487013470261248', '1441341228585766912', '消息中心', 'xxzx', '', '', NULL, 1, '', '-1.3.1441341228585766912.1494487013470261248.', '', '-1', '{"path":"message","component":"@/views/personal/message","redirect":"","alwaysShow":false,"caseSensitive":false,"meta":{"title":"消息中心","isChildren":true}}');
-- oyhj 2022-01-24 新增在线用户管理菜单。目录:用户管理-在线用户
INSERT INTO portal_sys_menu ("id_","parent_id_","name_","alias_","active_tab_","menu_icon_","opened_","sn_","tabs_style_","path_","href_","tenant_id_","route_extend_") VALUES ('1485448086022848512','3441027','在线用户','onlineUserManager',NULL,NULL,NULL,4,NULL,'-1.1.3441009.3441027.1485448086022848512.',NULL,'-1','{"path":"","component":"Layout","redirect":"","alwaysShow":false,"caseSensitive":false,"meta":{"title":""}}');
-- oyhj 2022-2-21 新增流程发起人账号属性
ALTER TABLE bpm_pro_inst
ADD COLUMN CREATE_ACCOUNT_ varchar(64) null;
COMMENT ON column bpm_pro_inst.CREATE_ACCOUNT_ is '流程发起人账号';
-- 2022-02-21 chenzm 新增扩展jar相关的菜单
INSERT INTO PORTAL_SYS_MENU(ID_, PARENT_ID_, NAME_, ALIAS_, ACTIVE_TAB_, MENU_ICON_, OPENED_, SN_, TABS_STYLE_, PATH_, HREF_, TENANT_ID_) VALUES ('1351410819870625792', '4291768', '已发布脚本', 'extendClassManager', '', '', 1, 6, '', '-1.1.3641025.4291768.1351410819870625792.', '', '-1');
INSERT INTO PORTAL_SYS_MENU(ID_, PARENT_ID_, NAME_, ALIAS_, ACTIVE_TAB_, MENU_ICON_, OPENED_, SN_, TABS_STYLE_, PATH_, HREF_, TENANT_ID_) VALUES ('1351409335724544000', '4291768', '扩展Jar包管理', 'extendJarManager', '', '', 1, 5, '', '-1.1.3641025.4291768.1351409335724544000.', '', '-1');
-- 2022-02-21 chenzm 新增扩展jar包管理表
CREATE TABLE bpm_extend_class(
ID_ VARCHAR(64) NOT NULL,
JAR_ID_ VARCHAR(64),
SIMPLE_NAME_ VARCHAR(255),
PATH_ VARCHAR(500),
DESC_ VARCHAR(255),
MD5_ VARCHAR(255),
TYPE_ VARCHAR(1),
PRIMARY KEY (ID_)
);
COMMENT ON TABLE bpm_extend_class IS '已发布扩展脚本管理表';
COMMENT ON COLUMN bpm_extend_class.JAR_ID_ IS '所属jar包id';
COMMENT ON COLUMN bpm_extend_class.SIMPLE_NAME_ IS '类名首字母小写;即beanId';
COMMENT ON COLUMN bpm_extend_class.PATH_ IS '类名全路径';
COMMENT ON COLUMN bpm_extend_class.DESC_ IS '类描述';
COMMENT ON COLUMN bpm_extend_class.MD5_ IS 'MD5版本号';
COMMENT ON COLUMN bpm_extend_class.TYPE_ IS '脚本类型1:条件脚本;2:人员脚本';
-- 2022-02-21 chenzm 新增已发布扩展脚本管理表
CREATE TABLE bpm_extend_jar(
ID_ VARCHAR(64) NOT NULL,
NAME_ VARCHAR(255),
DESC_ VARCHAR(255),
JAR_FILE_ VARCHAR(2000),
JAR_BYTES_ BYTEA,
CREATE_BY_ VARCHAR(255),
CREATE_NAME_ VARCHAR(255),
UPDATE_BY_ VARCHAR(255),
UPDATE_NAME_ VARCHAR(255),
CREATE_TIME_ DATE,
UPDATE_TIME_ DATE,
SIZE_ INT,
STATUS_ INT,
PRIMARY KEY (ID_)
);
COMMENT ON TABLE bpm_extend_jar IS '扩展jar包管理表';
COMMENT ON COLUMN bpm_extend_jar.NAME_ IS 'jar包名称';
COMMENT ON COLUMN bpm_extend_jar.DESC_ IS 'jar包描述';
COMMENT ON COLUMN bpm_extend_jar.JAR_FILE_ IS 'jar包的附件路径';
COMMENT ON COLUMN bpm_extend_jar.JAR_BYTES_ IS 'jar包的二进制数据';
COMMENT ON COLUMN bpm_extend_jar.CREATE_BY_ IS '上传人id';
COMMENT ON COLUMN bpm_extend_jar.CREATE_NAME_ IS '上传人姓名';
COMMENT ON COLUMN bpm_extend_jar.UPDATE_BY_ IS '发布人id';
COMMENT ON COLUMN bpm_extend_jar.UPDATE_NAME_ IS '发布人姓名';
COMMENT ON COLUMN bpm_extend_jar.CREATE_TIME_ IS '创建时间';
COMMENT ON COLUMN bpm_extend_jar.UPDATE_TIME_ IS '更新时间';
COMMENT ON COLUMN bpm_extend_jar.SIZE_ IS 'jar包大小;kb)';
COMMENT ON COLUMN bpm_extend_jar.STATUS_ IS 'jar包状态。1:未发布;2:已发布';
-- 2022-02-25 oyhj 新增流程实例彻底删除日志记录表
CREATE TABLE BPM_INST_DELETE_LOG (
ID_ VARCHAR2(64) DEFAULT NULL,
FULLNAME_ VARCHAR2(255) DEFAULT NULL,
ACCOUNT_ VARCHAR2(255) DEFAULT NULL,
DELETE_TIME_ TIMESTAMP(0) DEFAULT NULL,
INST_SUBJECT_ VARCHAR2(128) DEFAULT NULL,
CONTENT_ VARCHAR2(255) DEFAULT NULL
);
COMMENT ON TABLE BPM_INST_DELETE_LOG IS '流程实例删除日志';
COMMENT ON COLUMN BPM_INST_DELETE_LOG.FULLNAME_ IS '操作人姓名';
COMMENT ON COLUMN BPM_INST_DELETE_LOG.ACCOUNT_ IS '操作人账号';
COMMENT ON COLUMN BPM_INST_DELETE_LOG.DELETE_TIME_ IS '删除时间';
COMMENT ON COLUMN BPM_INST_DELETE_LOG.INST_SUBJECT_ IS '删除流程实例对象';
COMMENT ON COLUMN BPM_INST_DELETE_LOG.CONTENT_ IS '删除事由';
-- 2022-03-01 oyhj 添加菜单默认图标
UPDATE "PORTAL_SYS_MENU" SET "MENU_ICON_" = 'icon-design'
WHERE 'ID_' = '3441002';
UPDATE "PORTAL_SYS_MENU" SET "MENU_ICON_" = 'icon-integrate'
WHERE 'ID_' = '1437982148582154240';
UPDATE "PORTAL_SYS_MENU" SET "MENU_ICON_" = 'icon-system'
WHERE 'ID_' = '3421053';
UPDATE "PORTAL_SYS_MENU" SET "MENU_ICON_" = 'icon-user1'
WHERE 'ID_' = '3441009';
UPDATE "PORTAL_SYS_MENU" SET "MENU_ICON_" = 'icon-process'
WHERE 'ID_' = '1441339605377536000';
UPDATE "PORTAL_SYS_MENU" SET "MENU_ICON_" = 'icon-process'
WHERE 'ID_' = '3641025';
UPDATE "PORTAL_SYS_MENU" SET "MENU_ICON_" = 'icon-application1'
WHERE 'ID_' = '1254651824338767872';
UPDATE "PORTAL_SYS_MENU" SET "MENU_ICON_" = 'icon-application1'
WHERE 'ID_' = '1441341831483412480';
UPDATE "PORTAL_SYS_MENU" SET "MENU_ICON_" = 'icon-user1'
WHERE 'ID_' = '1441341228585766912';
UPDATE "PORTAL_SYS_MENU" SET "MENU_ICON_" = 'icon-aside-home'
WHERE 'ID_' = '1441359555827781632';
-- 2022-03-02 oyhj 去除系统属性 超时时间sql
DELETE FROM portal_sys_properties WHERE ALIAS='overTime';
-- 2022-03-03 zengst 一般用户添加默认菜单的权限
INSERT INTO portal_sys_role_auth (ID_, ROLE_ALIAS_, MENU_ALIAS_, METHOD_ALIAS_, DATA_PERMISSION_, TENANT_ID_) VALUES ('1499226092684890112', 'ybyh', 'matter', null, null, '-1');
INSERT INTO portal_sys_role_auth (ID_, ROLE_ALIAS_, MENU_ALIAS_, METHOD_ALIAS_, DATA_PERMISSION_, TENANT_ID_) VALUES ('1499226092705861632', 'ybyh', 'personal', null, null, '-1');
INSERT INTO portal_sys_role_auth (ID_, ROLE_ALIAS_, MENU_ALIAS_, METHOD_ALIAS_, DATA_PERMISSION_, TENANT_ID_) VALUES ('1499226092705861633', 'ybyh', 'appCenter1', null, null, '-1');
INSERT INTO portal_sys_role_auth (ID_, ROLE_ALIAS_, MENU_ALIAS_, METHOD_ALIAS_, DATA_PERMISSION_, TENANT_ID_) VALUES ('1499226092705861634', 'ybyh', 'new', null, null, '-1');
INSERT INTO portal_sys_role_auth (ID_, ROLE_ALIAS_, MENU_ALIAS_, METHOD_ALIAS_, DATA_PERMISSION_, TENANT_ID_) VALUES ('1499226092705861635', 'ybyh', 'myTask', null, null, '-1');
INSERT INTO portal_sys_role_auth (ID_, ROLE_ALIAS_, MENU_ALIAS_, METHOD_ALIAS_, DATA_PERMISSION_, TENANT_ID_) VALUES ('1499226092710055936', 'ybyh', 'apply', null, null, '-1');
INSERT INTO portal_sys_role_auth (ID_, ROLE_ALIAS_, MENU_ALIAS_, METHOD_ALIAS_, DATA_PERMISSION_, TENANT_ID_) VALUES ('1499226092710055937', 'ybyh', 'homePage', null, null, '-1');
INSERT INTO portal_sys_role_auth (ID_, ROLE_ALIAS_, MENU_ALIAS_, METHOD_ALIAS_, DATA_PERMISSION_, TENANT_ID_) VALUES ('1499226092714250240', 'ybyh', 'Index', null, null, '-1');
INSERT INTO portal_sys_role_auth (ID_, ROLE_ALIAS_, MENU_ALIAS_, METHOD_ALIAS_, DATA_PERMISSION_, TENANT_ID_) VALUES ('1499226092714250241', 'ybyh', 'setting', null, null, '-1');
INSERT INTO portal_sys_role_auth (ID_, ROLE_ALIAS_, MENU_ALIAS_, METHOD_ALIAS_, DATA_PERMISSION_, TENANT_ID_) VALUES ('1499226092718444544', 'ybyh', 'mail', null, null, '-1');
INSERT INTO portal_sys_role_auth (ID_, ROLE_ALIAS_, MENU_ALIAS_, METHOD_ALIAS_, DATA_PERMISSION_, TENANT_ID_) VALUES ('1499226092718444545', 'ybyh', 'appCenter2', null, null, '-1');
INSERT INTO portal_sys_role_auth (ID_, ROLE_ALIAS_, MENU_ALIAS_, METHOD_ALIAS_, DATA_PERMISSION_, TENANT_ID_) VALUES ('1499226092718444546', 'ybyh', 'personalCenter', null, null, '-1');
INSERT INTO portal_sys_role_auth (ID_, ROLE_ALIAS_, MENU_ALIAS_, METHOD_ALIAS_, DATA_PERMISSION_, TENANT_ID_) VALUES ('1499226092718444547', 'ybyh', 'approvalForm', null, null, '-1');
INSERT INTO portal_sys_role_auth (ID_, ROLE_ALIAS_, MENU_ALIAS_, METHOD_ALIAS_, DATA_PERMISSION_, TENANT_ID_) VALUES ('1499226092718444548', 'ybyh', 'circulateMatter', null, null, '-1');
INSERT INTO portal_sys_role_auth (ID_, ROLE_ALIAS_, MENU_ALIAS_, METHOD_ALIAS_, DATA_PERMISSION_, TENANT_ID_) VALUES ('1499226092722638848', 'ybyh', 'xxzx', null, null, '-1');
INSERT INTO portal_sys_role_auth (ID_, ROLE_ALIAS_, MENU_ALIAS_, METHOD_ALIAS_, DATA_PERMISSION_, TENANT_ID_) VALUES ('1499226092722638849', 'ybyh', 'startProcess', null, null, '-1');
-- 2022-03-02 oyhj 新增流程实例回收站菜单
INSERT INTO portal_sys_menu(ID_, PARENT_ID_, NAME_, ALIAS_, ACTIVE_TAB_, MENU_ICON_, OPENED_, SN_, TABS_STYLE_, PATH_, HREF_, TENANT_ID_, ROUTE_EXTEND_) VALUES ('1497089603655909376', '4171077', '实例回收站', 'instanceRecovery', '', '', NULL, 4, '', '-1.1.3641025.4171077.1497089603655909376.', '', '-1', '{"path":"","component":"Layout","redirect":"","alwaysShow":false,"caseSensitive":false,"meta":{"title":""}}');
-- 2022-03-15 oyhj 添加首页布局标题名
UPDATE "PORTAL_SYS_MENU" SET "ROUTE_EXTEND_" = '{\"meta\":{\"title\":\"首页\"},\"component\":\"Layout\",\"redirect\":\"index\",\"path\":\"/\"}'
WHERE 'ID_' = '1441359555827781632';
-- 2022-03-19 oyhj 修改索引
CREATE INDEX "IDX_PORTAL_SYS_COLUMNNULL577" ON portal_sys_column (ALIAS, TENANT_ID_);