8.1.1 to 8.2.sql
121 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
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
/*
change.sql 说明
1.数据库相关修改添加到对应的 change.sql 文件,无需调整其他 sql 文件
2.sql 语句验证正确后再提交
*/
-- 2022-12-29 修改任务名称长度
alter table bpm_task modify NAME_ varchar(100) not null comment '任务名称';
-- 2023-3-6 liangjc 会议室配置默认不需要绑定流程脚本补充
update portal_meeting_config set BIND_FLOW_=0;
-- 2023-1-3 jjx 更新移动端待办列表配置
UPDATE `portal_sys_column` SET `TEMPLATE_HTML` = 'PGRpdj4KICA8ZGl2ICBjbGFzcz0idG9kby1oZWFkZXIiIHN0eWxlPSJkaXNwbGF5OmZsZXg7anVzdGlmeS1jb250ZW50OiBzcGFjZS1iZXR3ZWVuO2hlaWdodDogMS4wNjY3cmVtO2FsaWduLWl0ZW1zOiBjZW50ZXI7cGFkZGluZzowIDAuMzJyZW07Ij4KICAgIDxodC1oNCBpbmxpbmU+5oiR55qE5b6F5YqePC9odC1oND4KICAgIDxzcGFuICBjbGFzcz0iaGVhZGVyLXJpZ2h0X19idG4iICBAY2xpY2s9IiRyb3V0ZXIucHVzaCgnL3dvcmsvbXlNYXR0ZXJzJykiPgogICAgICDmm7TlpJo8aSBjbGFzcz0iZWwtaWNvbi1hcnJvdy1yaWdodCI+PC9pPgogICAgPC9zcGFuPgogIDwvZGl2PgogIDx1bCBjbGFzcz0idG9kby1jb250ZW50X191bCIgc3R5bGU9InBhZGRpbmc6MCAwLjMycmVtOyI+CiAgICA8bGkgY2xhc3M9InRvZG8tY29udGVudF9faXRlbSIgc3R5bGU9ImRpc3BsYXk6ZmxleDtmbGV4LWRpcmVjdGlvbjogY29sdW1uOyIgdi1mb3I9IihpdGVtLGluZGV4KSBpbiBjdXJyZW50U2hvd0RhdGEiIDprZXk9Iml0ZW0uaWQiPgogICAgICA8cCBzdHlsZT0iY29sb3I6IzIyMjIyMjtmb250LXNpemU6MC40cmVtO2ZvbnQtd2VpZ2h0OiBib2xkO21hcmdpbjowLjIxMzNyZW0gMDt3aGl0ZS1zcGFjZTogbm93cmFwO292ZXJmbG93OiBoaWRkZW47dGV4dC1vdmVyZmxvdzogZWxsaXBzaXM7IiBAY2xpY2s9ImdvVG9EZXRhaWwoaXRlbSkiPnt7aXRlbS5zdWJqZWN0fX08L3A+CiAgICAgIDxkaXYgY2xhc3M9ImNvbnRlbnQtaXRlbV9fYm90dG9tIiBzdHlsZT0iZGlzcGxheTpmbGV4O2p1c3RpZnktY29udGVudDogc3BhY2UtYmV0d2Vlbjtib3JkZXItYm90dG9tOjFweCBzb2xpZCAjRUVFRUVFO3BhZGRpbmctYm90dG9tOjAuMzJyZW0iIDpzdHlsZT0iaW5kZXggPT09IDQgPyAnYm9yZGVyLWJvdHRvbTpub25lJzonJyI+CiAgICAgICAgPGRpdiBjbGFzcz0iY29udGVudC1pdGVtX19ib3R0b20tbGVmdCI+CiAgICAgICAgICA8c3BhbiBzdHlsZT0iY29sb3I6Izk5OTtmb250LXNpemU6MC4zMnJlbSI+PGkgY2xhc3M9Imljb24teW9uZ2h1MSIgc3R5bGU9ImZvbnQtc2l6ZTowLjM3MzNyZW07cGFkZGluZy1yaWdodDowLjA1MzNyZW0iPjwvaT57e2l0ZW0uY3JlYXRvcn19PC9zcGFuPgogICAgICAgICAgPHNwYW4gc3R5bGU9ImNvbG9yOiM5OTk7Zm9udC1zaXplOjAuMzJyZW07cGFkZGluZy1sZWZ0OjAuNTMzM3JlbSI+PGkgY2xhc3M9Imljb24tdGltZS1jaXJjbGUiIHN0eWxlPSJmb250LXNpemU6MC4zNzMzcmVtO3BhZGRpbmctcmlnaHQ6MC4wNTMzcmVtIj48L2k+e3tmb3JtYXRlRGF0ZShpdGVtLmNyZWF0ZVRpbWUpfX08L3NwYW4+CiAgICAgICAgPC9kaXY+CiAgICAgICAgPGRpdiBzdHlsZT0iY29sb3I6IzQwOUVGRjtmb250LXNpemU6MC4zMnJlbSI+e3tmaWx0ZXJEYXRlKGl0ZW0uY3JlYXRlVGltZSl9fTwvZGl2PgogICAgICA8L2Rpdj4KICAgIDwvbGk+CiAgPC91bD4KPC9kaXY', `TEMPLATE_JAVA_SCRIPT_` = 'ewogIGNvbXB1dGVkOnsKICAgIGN1cnJlbnRTaG93RGF0YSgpewogICAgICBsZXQgZGF0YSA9IFtdCiAgICAgIGlmKHRoaXMuZGF0YSYmdGhpcy5kYXRhLnJvd3MmJnRoaXMuZGF0YS5yb3dzLmxlbmd0aCl7CiAgICAgICAgZGF0YSA9IHRoaXMuZGF0YS5yb3dzLnNwbGljZSgwLDUpCiAgICAgIH0KICAgICAgcmV0dXJuIGRhdGEKICAgIH0sCiAgIAogIH0sCiAgICBtb3VudGVkKCl7CiAgICAgCiAgICB9LAogICAgIG1ldGhvZHM6IHsKICAgICAgIGdvVG9EZXRhaWwocm93KXsKICAgICAgICAgaWYgKHJvdy5zdGF0dXMgPT0gJ1NIQVJFJyB8fCByb3cuc3RhdHVzID09ICdCQUNLU0hBUkUnKSB7CiAgICAgICAgICAgIGlmIChyb3cuaWRlbnRpdHlMaXN0ICYmIHJvdy5pZGVudGl0eUxpc3QubGVuZ3RoID09IDEpIHsKICAgICAgICAgICAgICB0aGlzLiRyb3V0ZXIucHVzaCgKICAgICAgICAgICAgICAgICcvdGFzay8nICsgcm93LmlkICsgJy8nICsgcm93LmlkZW50aXR5TGlzdFswXS5pZAogICAgICAgICAgICAgICkKICAgICAgICAgICAgfSBlbHNlIHsKICAgICAgICAgICAgICBsZXQgaHRtbCA9CiAgICAgICAgICAgICAgICAnPHNlbGVjdCByZWY9JyArCiAgICAgICAgICAgICAgICBNYXRoLnJhbmRvbSgpICsKICAgICAgICAgICAgICAgICcgaWQ9ImFwcHJvdmFsTGVhZGVyU2VsZWN0IiBzdHlsZT0id2lkdGg6IDIwMHB4O2hlaWdodDogMzBweDtib3JkZXItcmFkaXVzOiA0cHg7bWFyZ2luOiAyMHB4IDcwcHg7IiA+PG9wdGlvbiB2YWx1ZT0iIj7or7fpgInmi6k8L29wdGlvbj4nCiAgICAgICAgICAgICAgcm93LmlkZW50aXR5TGlzdC5mb3JFYWNoKChpZGVudGl0eSkgPT4gewogICAgICAgICAgICAgICAgaHRtbCArPQogICAgICAgICAgICAgICAgICAnPG9wdGlvbiB2YWx1ZT0iJyArCiAgICAgICAgICAgICAgICAgIGlkZW50aXR5LmlkICsKICAgICAgICAgICAgICAgICAgJyI+JyArCiAgICAgICAgICAgICAgICAgIGlkZW50aXR5Lm5hbWUgKwogICAgICAgICAgICAgICAgICAnPC9vcHRpb24+JwogICAgICAgICAgICAgIH0pCiAgICAgICAgICAgICAgaHRtbCArPSAnPC9zZWxlY3Q+JwogICAgICAgICAgICAgIGxldCB0aGlzXyA9IHRoaXMKICAgICAgICAgICAgICB0aGlzLiRhbGVydChodG1sLCAn6K+36YCJ5oup5LiA5Liq6aKG5a+85Luj5Li65a6h5om5JywgewogICAgICAgICAgICAgICAgZGFuZ2Vyb3VzbHlVc2VIVE1MU3RyaW5nOiB0cnVlLAogICAgICAgICAgICAgICAgYmVmb3JlQ2xvc2U6IGZ1bmN0aW9uIChhY3Rpb24sIGluc3RhbmNlLCBkb25lKSB7CiAgICAgICAgICAgICAgICAgIGlmIChhY3Rpb24gPT0gJ2NvbmZpcm0nKSB7CiAgICAgICAgICAgICAgICAgICAgbGV0IHNlID0gZG9jdW1lbnQuZ2V0RWxlbWVudEJ5SWQoJ2FwcHJvdmFsTGVhZGVyU2VsZWN0JykKICAgICAgICAgICAgICAgICAgICBpZiAoc2Uuc2VsZWN0ZWRJbmRleCA9PSAwKSB7CiAgICAgICAgICAgICAgICAgICAgICBOb3RpZnkoewogICAgICAgICAgICAgICAgICAgICAgICB0eXBlOiAnd2FybmluZycsCiAgICAgICAgICAgICAgICAgICAgICAgIG1lc3NhZ2U6ICfor7fpgInmi6nku6PkuLrlrqHmibnnmoTpooblr7wnLAogICAgICAgICAgICAgICAgICAgICAgfSkKICAgICAgICAgICAgICAgICAgICB9IGVsc2UgewogICAgICAgICAgICAgICAgICAgICAgaW5zdGFuY2UuY2xvc2UoKQogICAgICAgICAgICAgICAgICAgICAgdGhpc18uJHJvdXRlci5wdXNoKAogICAgICAgICAgICAgICAgICAgICAgICAnL3Rhc2svJyArIHJvdy5pZCArICcvJyArIHNlW3NlLnNlbGVjdGVkSW5kZXhdLnZhbHVlCiAgICAgICAgICAgICAgICAgICAgICApCiAgICAgICAgICAgICAgICAgICAgfQogICAgICAgICAgICAgICAgICB9IGVsc2UgewogICAgICAgICAgICAgICAgICAgIGluc3RhbmNlLmNsb3NlKCkKICAgICAgICAgICAgICAgICAgfQogICAgICAgICAgICAgICAgfSwKICAgICAgICAgICAgICB9KQogICAgICAgICAgICB9CiAgICAgICAgICB9IGVsc2UgaWYgKAogICAgICAgICAgICByb3cuc3RhdHVzID09ICdBR0VOVCcgJiYKICAgICAgICAgICAgcm93Lm93bmVySWQgIT0gcm93LmFzc2lnbmVlSWQgJiYKICAgICAgICAgICAgcm93Lm93bmVySWQgPT0gdGhpcy4kc3RvcmUuc3RhdGUubG9naW4uY3VycmVudFVzZXIudXNlcklkCiAgICAgICAgICApIHsKICAgICAgICAgICAgLy/lp5TmiZjku7vliqEKICAgICAgICAgICAgdGhpcy4kcm91dGVyLnB1c2goJy9pbnN0UmVhZC8nICsgcm93LnByb2NJbnN0SWQgKyAnL2FnZW50JykKICAgICAgICAgIH0gZWxzZSB7CiAgICAgICAgICAgIHRoaXMuJHJvdXRlci5wdXNoKCcvdGFzay8nICsgcm93LmlkICsgJy8wJykKICAgICAgICAgIH0KICAgICAgIH0sCiAgICAgIGZpbHRlckRhdGUoZGF0ZSkgewogICAgICAgIHZhciBjdXJyZW50RGF0ZSA9IG5ldyBEYXRlKCkuZ2V0VGltZSgpCiAgICAgICAgZGF0ZSA9IG5ldyBEYXRlKGRhdGUucmVwbGFjZSgvLS9nLCAnLycpKS5nZXRUaW1lKCkKICAgICAgICBpZiAoZGF0ZSAhPSB1bmRlZmluZWQpIHsKICAgICAgICAgIHZhciB0b3RhbCA9IChjdXJyZW50RGF0ZSAtIGRhdGUpIC8gMTAwMAogICAgICAgICAgdmFyIGRheSA9IHBhcnNlSW50KHRvdGFsIC8gKDI0ICogNjAgKiA2MCkpIC8v6K6h566X5pW05pWw5aSp5pWwCiAgICAgICAgICB2YXIgYWZ0ZXJEYXkgPSB0b3RhbCAtIGRheSAqIDI0ICogNjAgKiA2MCAvL+WPluW+l+eul+WHuuWkqeaVsOWQjuWJqeS9meeahOenkuaVsAogICAgICAgICAgdmFyIGhvdXIgPSBwYXJzZUludChhZnRlckRheSAvICg2MCAqIDYwKSkgLy/orqHnrpfmlbTmlbDlsI/ml7bmlbAKICAgICAgICAgIHZhciBhZnRlckhvdXIgPSB0b3RhbCAtIGRheSAqIDI0ICogNjAgKiA2MCAtIGhvdXIgKiA2MCAqIDYwIC8v5Y+W5b6X566X5Ye65bCP5pe25pWw5ZCO5Ymp5L2Z55qE56eS5pWwCiAgICAgICAgICB2YXIgbWluID0gcGFyc2VJbnQoYWZ0ZXJIb3VyIC8gNjApIC8v6K6h566X5pW05pWw5YiGCiAgICAgICAgICB2YXIgYWZ0ZXJNaW4gPSBwYXJzZUludCgKICAgICAgICAgICAgdG90YWwgLSBkYXkgKiAyNCAqIDYwICogNjAgLSBob3VyICogNjAgKiA2MCAtIG1pbiAqIDYwIC8v5Y+W5b6X566X5Ye65YiG5ZCO5Ymp5L2Z55qE56eS5pWwCiAgICAgICAgICApCiAgICAgICAgICB2YXIgdmFsID0gJycKICAgICAgICAgIGlmIChkYXkgIT0gMCkgewogICAgICAgICAgICByZXR1cm4gKHZhbCArPSBkYXkgKyAnZCcpCiAgICAgICAgICB9IGVsc2UgaWYgKGhvdXIgIT0gMCkgewogICAgICAgICAgICByZXR1cm4gKHZhbCArPSBob3VyICsgJ2gnKQogICAgICAgICAgfSBlbHNlIGlmIChtaW4gIT0gMCkgewogICAgICAgICAgICByZXR1cm4gKHZhbCArPSBtaW4gKyAnbScpCiAgICAgICAgICB9IGVsc2UgaWYgKGFmdGVyTWluICE9IDApIHsKICAgICAgICAgICAgcmV0dXJuICh2YWwgKz0gYWZ0ZXJNaW4gKyAncycpCiAgICAgICAgICB9CiAgICAgICAgfQogICAgICB9LAogICAgfSwKICAgIAp9' WHERE `ALIAS` = 'wddbmobile';
ALTER TABLE uc_org_job DROP INDEX `IDX_JOB_CODE_UNQ`;
ALTER TABLE uc_org_job ADD UNIQUE KEY `IDX_JOB_CODE_UNQ` (`CODE_`,`TENANT_ID_`,`IS_DELE_`) USING BTREE;
-- 2023年1月5日 huangtp 修改【栏目管理】数据参数字段范围加大
alter table portal_sys_column modify DATA_PARAM longtext null;
-- jason 2022-08-19 新增流程设计模式字段
ALTER TABLE `bpm_definition` ADD COLUMN `DESIGN_PATTERN_` varchar(20) NULL COMMENT '设计模式 normal simple' AFTER `TAGS_`;
-- 增加一张查看记录表
CREATE TABLE `bpm_check_record` (
`ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '主键',
`TENANT_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '租户ID',
`CREATE_TIME_` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
`UPDATE_TIME_` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
`CREATE_BY_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人',
`TASK_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '任务id',
`INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '实例id',
`create_org_id_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`update_by_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
PRIMARY KEY (`ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '任务阅读记录' ROW_FORMAT = Dynamic;
-- 系统属性 数据修改
UPDATE `portal_sys_properties` SET `NAME` = '待办列表字段显示配置', `ALIAS` = 'taskListFiledConf', `GROUP_` = NULL, `VALUE` = 'MvLiL4mE1+YRNj4cfPOGzXCMA5F/amaoWCA2iUnRVhcK9aZEof2/M5Ii3zWaCcQBtNG6T6/bDsspNohzSqq8MBg+UkEo+A+fojqBP9nm9s/mxAH5v+HcvPi7H00ryd0W0eMInCQ2rplU+UgHvJNr0D8+1FkL/EyQPsOG5SazUTWOWI14OS+R1tHUvVzGk6jSxrZqAz5Pi5RTNDitHrypfbF9nas8LjVzqrnYGrRimXaSaPX7zmNtlm+NoKRpX0ckQDyjgSvwAgnLtSbyqiTS4AMBxjGgbzHEtD+UwDcyWFD/y99DaWyKe1CkC/kfZ4mr5cRTrOUWsGIHBsHnz+Czx3Ip6tQxeSxFm3A4xn0YWzDENJLO7IPN9bixemLAj38RGZf+/2+uFRZx/WKKiVUHYuBxrvZN/E9Qxxg0JMpXPC4srBSSngEFv72KDwc1t7lpQ8+nOduRG5dkZcl9Do+qRj7JH6CouiXEyXZybr7hItFKZiClQgfDGd5wldTxTZ0apGjFB8lNecOIvY+DelsMAKG5+8VqplSVF3S6zJ6+kxqIt4OcPTIm+MPUgIFeLbm9XJ1Kn0tdEk5PhsiWdYBVrrhFafpPzw/AXsQAYZgh7T1TCnYGUidLOis1G8khS4T7QDyjgSvwAgnLtSbyqiTS4HtJ/Yl9yGzl/94R0THof8UO6B1Ej+GnOnQEFRi2izAf5cRTrOUWsGIHBsHnz+Czx3Ip6tQxeSxFm3A4xn0YWzAa38uRHjrujYZ4pZX1yWAEpGjFB8lNecOIvY+DelsMANq/cufeuL275D7sZygkW0WQ57F5AtPCv6Wki5lAM0CBL25Enrb6+rlNuY32fRM0z7OMt4w6vXJHgjkO4Txe4/srk4QuiRDQvyq9K+wGQLQNuVl7HPlrJDfOPnb2xbCOxzoWCUKQpYW9tKqrx692LMILy5x9J/NfUxSi3gtHMI1RX6LfluBuGRpjhcDsxxaxeuSZGrk7zbVgoGRM49OtyaS/GnH7v+Xskxs4/geWWITXL/QE10IQ2v6ewmFdLAPwdZF2NNzjnuS+GkbyHPVH0bsP/eux6jbu1R2wK9GjI4MP/iYjy9b7jaqbc/XYGtFM6EigZrL18hlemzh/Fvu7/oIQD2Pe+5+2JS2EmXX4zF29VG5OCoeL5VM11eDDbZn4a0A8o4Er8AIJy7Um8qok0uCjZmgZKQ6XiFCyp9UNkumLJA32CqzvKUNEPNLwf+CR7eXEU6zlFrBiBwbB58/gs8dyKerUMXksRZtwOMZ9GFswB3chkFVZb6XCc45/PdrIYfl4c0Vbog/TuxP3MMXBpXbiEGklcBZ0q1FsT2tSEMBwOd6njPSzdZF2cVWQSvZ+IUA8dxrZx2EGWpBF11V6cfBWup6zeRqkyJTBIaVQzubzEs/ZpNz8lKFyCEBsdEgalnVPakFyhb8G0ea5P3CAlreN6TBxepcUHthlX77p5CuPGOA+8yi2NynjMKDXg9Awklca0dcpoMR1Ofat3kj4YuzTzbMrfilpzvg8cWw3e1wpZQtx04v+/jzDBbCC8JXJz7lZexz5ayQ3zj529sWwjsfyIJ/lSzTXRC7Kp1P1uBBn/vFT7Gy1mpBZk9tpUGzLVbuNtUx7/8H2OaeT73vqems4Z5KEjTP+oIX9LWzRxee0UaHFyfk6CgnGeF4CwTIdw0A8o4Er8AIJy7Um8qok0uCjmdwbIcTthJHSl8xgXePabA8lXEkV/j2ESgV5AS/N8lhJyDS5ZqlumY28Bawy49EQD2Pe+5+2JS2EmXX4zF29an1LjdWEv13RH3vqxzFW2+IQaSVwFnSrUWxPa1IQwHB/eigOQncmnJkQFuV61QidQDx3GtnHYQZakEXXVXpx8Fa6nrN5GqTIlMEhpVDO5vMSz9mk3PyUoXIIQGx0SBqWEbFvnZzHRIliGHlLOUY3cA==', `ENCRYPT` = 1, `DESCRIPTION` = '应用端待办列表字段显示配置', `UPDATE_TIME_` = '2022-11-09 15:53:45', `CREATE_BY_` = '1', `CREATE_TIME_` = '2021-10-14 16:41:40', `CREATE_ORG_ID_` = '', `UPDATE_BY_` = '1', `TENANT_ID_` = NULL WHERE `ID` = '1448569683989442560';
-- 流程定义增加字段
ALTER TABLE `bpm_definition`
ADD COLUMN `FLOW_TYPE_` int(2) NULL COMMENT '流程类型' AFTER `DESIGN_PATTERN_`;
-- 2023-03-02 催办添加转办功能
ALTER TABLE `bpm_task_reminder`
ADD COLUMN `TRANSFER_ID_` varchar(64) NULL COMMENT '转办人id' AFTER `REL_TIME_SCRIPT_`,
ADD COLUMN `TRANSFER_NAME_` varchar(255) NULL COMMENT '转办人名称' AFTER `TRANSFER_ID_`,
ADD COLUMN `DIRECT_LEADER_` int(0) NULL COMMENT '催办直接上级' AFTER `TRANSFER_NAME_`,
ADD COLUMN `MAIN_ORG_LEADER_` int(0) NULL COMMENT '催办主组织负责人' AFTER `DIRECT_LEADER_`,
ADD COLUMN `DIRECT_USER_IDS_` varchar(1000) NULL COMMENT '指定用户id' AFTER `MAIN_ORG_LEADER_`,
ADD COLUMN `DIRECT_USER_NAMES_` varchar(1000) NULL COMMENT '指定用户名称' AFTER `DIRECT_USER_IDS_`,
ADD COLUMN `DIRECT_USER_` int(0) NULL COMMENT '催办指定用户' AFTER `DIRECT_USER_NAMES_`;
-- wanghb 2023-02-27 日志配置表新增字段
ALTER TABLE `portal_sys_logs_settings` ADD COLUMN `FROM_` varchar(1) NULL COMMENT '1:初始化。2:手动添加';
ALTER TABLE `portal_sys_logs_settings` ADD COLUMN `MODULE_NAME_` varchar(200) NULL COMMENT '模块名称';
-- jjx 2023-3-7 脚本添加租户id
UPDATE `bpm_multi_script` SET`TENANT_ID_` = '-1' WHERE `ID_` = '1318030354614980608';
UPDATE `bpm_multi_script` SET`TENANT_ID_` = '-1' WHERE `ID_` = '1338367741324824576';
UPDATE `bpm_multi_script` SET`TENANT_ID_` = '-1' WHERE `ID_` = '1338375124944031744';
UPDATE `bpm_multi_script` SET`TENANT_ID_` = '-1' WHERE `ID_` = '1338377219818524672';
UPDATE `bpm_multi_script` SET`TENANT_ID_` = '-1' WHERE `ID_` = '1338379764150439936';
UPDATE `bpm_multi_script` SET`TENANT_ID_` = '-1' WHERE `ID_` = '1338381406014935040';
-- 2023-03-02 字典表新增字段
ALTER TABLE `portal_sys_dic` ADD COLUMN `CREATE_TIME_` datetime NULL COMMENT '创建时间' AFTER `TENANT_ID_`;
ALTER TABLE `portal_sys_dic` ADD COLUMN `CREATE_BY_` varchar(255) NULL COMMENT '创建人id' AFTER `CREATE_TIME_`;
-- 2023-3-8 liangjc 系统日志和接口日志增加 接口耗时字段
alter table portal_sys_logs add column elapsed_time_ decimal(10,3) default null comment '接口耗时(单位:秒)';
alter table bpm_call_log add column elapsed_time_ decimal(10,3) default null comment '接口耗时(单位:秒)';
-- 2023-3-17 wanghb 会签数据表新增任务来源字段。
ALTER TABLE `bpm_task_signdata` ADD COLUMN `FROM_` varchar(64) NULL COMMENT '来源。assign由指定历史会签处理人产生的';
-- 2023-3-17 jjx 新视窗简易流程迁移
INSERT INTO `portal_sys_menu`(`ID_`, `PARENT_ID_`, `NAME_`, `ALIAS_`, `ACTIVE_TAB_`, `MENU_ICON_`, `OPENED_`, `SN_`, `TABS_STYLE_`, `PATH_`, `HREF_`, `TENANT_ID_`, `ROUTE_EXTEND_`, `TYPE_`) VALUES ('1572106298114183168', '3641025', '简易流程', 'simpleFlowTable', '', '', 1, 2, '', '-1.1.3641025.1572106298114183168.', '', '-1', '{\"path\":\"/simpleFlowTable\",\"component\":\"\",\"redirect\":\"\",\"alwaysShow\":false,\"caseSensitive\":false,\"meta\":{\"title\":\"简易流程\"}}', NULL);
CREATE TABLE `form_simple_design` (
`ID_` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`CATEGORY_ID_` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '分类ID',
`CATEGORY_NAME_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '分类名称',
`ALIAS_` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '别名',
`NAME_` varchar(150) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '名称',
`CREATE_BY_` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人ID',
`CREATE_TIME_` datetime(0) NULL DEFAULT NULL,
`CREATE_ORG_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`UPDATE_BY_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`UPDATE_TIME_` datetime(0) NULL DEFAULT NULL,
`TENANT_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`DESC_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '描述',
PRIMARY KEY (`ID_`) USING BTREE,
UNIQUE INDEX `IDX_FORM_BO_DEF_ALIAS`(`ALIAS_`, `TENANT_ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '简易设计' ROW_FORMAT = DYNAMIC;
SET FOREIGN_KEY_CHECKS = 1;
-- 2023-3-17 liangjc 增加个人信息菜单及国际化数据
INSERT INTO portal_sys_menu(ID_, PARENT_ID_, NAME_, ALIAS_, ACTIVE_TAB_, MENU_ICON_, OPENED_, SN_, TABS_STYLE_, PATH_, HREF_, TENANT_ID_, ROUTE_EXTEND_, TYPE_, IS_REFRESH_, token_Enabled_, TOKEN_TYPE_, TOKEN_KEY_, TOKEN_API_) VALUES ('1631183759799828480', '1441341228585766912', '个人信息', 'information', '', '', NULL, 1, '', '-1.3.1441341228585766912.1631183759799828480.', '', '-1', '{\"path\":\"information\",\"component\":\"@/views/personal/information\",\"redirect\":\"\",\"alwaysShow\":false,\"caseSensitive\":false,\"meta\":{\"title\":\"个人信息\",\"isChildren\":true,\"icon\":\"\"}}', 'page', 1, 0, 0, NULL, NULL);
INSERT INTO portal_i18n_message(ID_, TYPE_, KEY_, VALUE_, CREATE_TIME_, CREATE_BY_, CREATE_ORG_ID_, UPDATE_BY_, UPDATE_TIME_, TENANT_ID_) VALUES ('1630743663304851456', 'en', 'Personal.center', 'Personal center', '2023-03-01 09:36:02', '1', '', NULL, NULL, '-1');
INSERT INTO portal_i18n_message(ID_, TYPE_, KEY_, VALUE_, CREATE_TIME_, CREATE_BY_, CREATE_ORG_ID_, UPDATE_BY_, UPDATE_TIME_, TENANT_ID_) VALUES ('1630743663363571712', 'zh-TW', 'Personal.center', '個人中心', '2023-03-01 09:36:02', '1', '', NULL, NULL, '-1');
INSERT INTO portal_i18n_message(ID_, TYPE_, KEY_, VALUE_, CREATE_TIME_, CREATE_BY_, CREATE_ORG_ID_, UPDATE_BY_, UPDATE_TIME_, TENANT_ID_) VALUES ('1630743663392931840', 'zh-CN', 'Personal.center', '个人中心', '2023-03-01 09:36:02', '1', '', NULL, NULL, '-1');
-- 2023-3-21 liangjc 新增表单css脚本字段
ALTER TABLE form_history_record ADD COLUMN FORM_CSS_ text NULL COMMENT '表单css脚本' AFTER TENANT_ID_;
ALTER TABLE form_definition ADD COLUMN FORM_CSS_ text NULL COMMENT '表单css脚本' AFTER TENANT_ID_;
-- 2023-3-21 jjx 新视窗自由流程表
DROP TABLE IF EXISTS `bpm_free_process_def`;
CREATE TABLE `bpm_free_process_def` (
`id_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '新流程定义ID',
`source_def_id_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '原流程定义ID',
`proc_inst_id_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '实例ID',
`BPMN_XML_` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT 'xml',
`TENANT_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '租户ID',
PRIMARY KEY (`id_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '自由流程定义备份表' ROW_FORMAT = Dynamic;
SET FOREIGN_KEY_CHECKS = 1;
-- 2023-3-29 liangjc 新增服务节点执行日志表
CREATE TABLE bpm_service_log (
ID_ varchar(64) NOT NULL,
SUBJECT_ varchar(600) DEFAULT NULL COMMENT ' 流程标题',
PROC_DEF_ID_ varchar(64) DEFAULT NULL COMMENT ' 流程定义ID',
PROC_INST_ID_ varchar(64) DEFAULT NULL COMMENT '流程实例ID',
NODE_ID_ varchar(64) DEFAULT NULL COMMENT '节点ID',
STATUS_ int(2) DEFAULT NULL COMMENT '处理结果:1.处理成功 0.处理失败',
CREATE_TIME_ datetime DEFAULT NULL,
TENANT_ID_ varchar(64) DEFAULT NULL,
PRIMARY KEY (ID_) USING BTREE,
KEY PROC_INST_ID_ (PROC_INST_ID_) USING BTREE
) COMMENT='服务节点执行日志';
-- 2023-3-29 lizx 数据归档配置表
CREATE TABLE bpm_documentation_config (
ID_ varchar(255) NOT NULL,
DATA_KEY_ varchar(255) DEFAULT NULL COMMENT '数据源key',
AUTORUN_ varchar(10) DEFAULT NULL COMMENT '是否自动执行',
AUTORUN_CONFIG_ varchar(255) DEFAULT NULL COMMENT '自动执行配置',
DELETE_DATA_ varchar(10) DEFAULT NULL COMMENT '是否删除数据',
LIMIT_ varchar(10) DEFAULT NULL COMMENT '是否限制数据',
LIMIT_NUMBER_ varchar(255) DEFAULT NULL COMMENT '限制数量',
UPDATE_BY_ varchar(255) DEFAULT NULL COMMENT '修改人',
UPDATE_TIME_ datetime(0) DEFAULT NULL COMMENT '修改时间',
BEFORE_MONTH_ varchar(10) DEFAULT NULL COMMENT '同步时间',
JOB_NAME_ varchar(255) DEFAULT NULL COMMENT '定时任务名称',
TENANT_ID_ varchar(255) DEFAULT NULL,
PRIMARY KEY (ID_) USING BTREE
) COMMENT = '数据归档配置表';
-- 2023-3-29 lizx 同步错误日志表
CREATE TABLE portal_documentation_error_log (
ID_ varchar(255) NOT NULL,
TABLE_NAME_ varchar(255) DEFAULT NULL COMMENT '表名',
DATA_ID_ varchar(255) DEFAULT NULL COMMENT '数据id',
DATA_ varchar(1000) DEFAULT NULL COMMENT '数据',
REASON_ text DEFAULT NULL COMMENT '失败原因',
TABLE_ID_ varchar(255) DEFAULT NULL COMMENT '数据表id',
TIME_ datetime(0) NULL DEFAULT NULL COMMENT '时间',
TENANT_ID_ varchar(255) NOT NULL,
PRIMARY KEY (ID_) USING BTREE
) COMMENT = '同步错误日志表';
-- 2023-3-29 lizx 同步数据目标表
CREATE TABLE bpm_documentation_table (
ID_ varchar(255) NOT NULL,
TABLE_NAME_ varchar(255) DEFAULT NULL COMMENT '表名',
DML_ text DEFAULT NULL COMMENT '表查询语句',
DDL_ text COMMENT '表定义语句',
SYSTEM_ varchar(10) DEFAULT NULL COMMENT '是否系统默认表',
START_ varchar(255) DEFAULT NULL COMMENT '是否启动',
INFO_ varchar(255) DEFAULT NULL COMMENT '说明',
ORDER_ varchar(255) DEFAULT NULL COMMENT '同步顺序',
UPDATE_BY_ varchar(255) DEFAULT NULL COMMENT '创建人',
PARENT_FIELD_ varchar(255) DEFAULT NULL COMMENT '主表字段',
FIELD_ varchar(255) DEFAULT NULL COMMENT '子表字段',
TIME_KEY_ varchar(255) DEFAULT NULL COMMENT '同步表时间字段',
PARENT_ID_ varchar(255) DEFAULT NULL COMMENT '父表id',
UPDATE_TIME_ datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
TENANT_ID_ varchar(255) DEFAULT NULL,
PRIMARY KEY (ID_) USING BTREE
) COMMENT = '同步数据目标表';
-- 2023-04-04 wanghb 表单列表新增字段
ALTER TABLE `form_data_template`
ADD COLUMN `SHOW_TYPE_` varchar(20) NULL COMMENT '展示类型。',
ADD COLUMN `GANTT_CONFIG_` longtext NULL COMMENT '甘特图独有一些配置';
-- 2023-04-11 qiuxd 表单列表新增字段
ALTER TABLE `form_data_template`
ADD COLUMN `KANBAN_CONFIG_` longtext NULL COMMENT '看板独有一些配置';
-- 2023-04-12 wanghb 表单列表新增字段
ALTER TABLE `form_data_template`
ADD COLUMN `XMIND_CONFIG_` longtext NULL COMMENT '思维导图的配置' ;
-- 2023-04-25 yijj 增加栏目快照图片id
ALTER TABLE `portal_sys_column`
ADD COLUMN `SNAPSHOT_ID_` varchar(64) NULL COMMENT '快照图片id' AFTER `is_init_`;
-- 2023-04-26 liangjc 栏目表新增字段
ALTER TABLE portal_sys_column
ADD COLUMN TEMPLATE_STYLE_ text NULL COMMENT '模板样式';
-- 2023-04-25 yijj 增加移动端用户最近应用点击记录表
CREATE TABLE `portal_recently_app` (
`ID_` varchar(64) NOT NULL COMMENT 'ID',
`APP_ID_` varchar(64) NULL COMMENT '应用ID',
`ACCOUNT_` varchar(64) NULL COMMENT '用户账号',
`COUNT_` int NULL COMMENT '点击次数',
`CREATE_TIME_` datetime(0) NULL DEFAULT NULL COMMENT '创建时间',
`UPDATE_TIME_` datetime(0) NULL DEFAULT NULL COMMENT '更新时间',
`CREATE_BY_` varchar(64) NULL DEFAULT NULL COMMENT '创建人',
`CREATE_ORG_ID_` varchar(64) NULL DEFAULT NULL ,
`UPDATE_BY_` varchar(64) NULL DEFAULT NULL COMMENT '更新人',
`TENANT_ID_` varchar(64) NULL DEFAULT NULL,
PRIMARY KEY (`ID_`)
) COMMENT = '用户最近应用点击记录表';
-- 2023-04-26 liangjc 布局管理增加轮播图分类id数组字段
ALTER TABLE portal_sys_layout_manage
ADD COLUMN BANNER_TYPE_IDS_ text NULL COMMENT '轮播图分类ids';
-- 2023-04-27 yijj 表单列表增加移动端显示字段
ALTER TABLE `form_data_template`
ADD COLUMN `MOBILE_DISPLAY_FIELD_` longtext NULL COMMENT '移动端显示字段' AFTER `DISPLAY_FIELD_`;
-- 2023-05-04 yijj 表单列表增加移动端功能按钮字段
ALTER TABLE `form_data_template`
ADD COLUMN `mobile_manage_field_` longtext NULL COMMENT '移动端功能按钮' AFTER `manage_field_`;
-- 2023-05-05 yijj 增加手机端自定义门户初始化数据
INSERT INTO `portal_sys_column`(`ID`, `NAME`, `ALIAS`, `CATALOG`, `COL_TYPE`, `DATA_MODE`, `DATA_FROM`, `DS_ALIAS`, `DS_NAME`, `COL_HEIGHT`, `COL_URL`, `TEMPLATE_HTML`, `IS_PUBLIC`, `SUPPORT_REFESH`, `REFESH_TIME`, `SHOW_EFFECT`, `MEMO`, `DATA_PARAM`, `NEEDPAGE`, `ORG_ID`, `CREATOR`, `CREATE_BY_`, `UPDATE_BY_`, `CREATE_TIME_`, `UPDATE_TIME_`, `REQUEST_TYPE`, `CATALOG_NAME`, `CREATE_ORG_ID_`, `TENANT_ID_`, `SHOW_TITLE_`, `CONTAIN_COL_`, `APPID_`, `SECRET_`, `TEMPLATE_JAVA_SCRIPT_`, `STYLE_`, `is_init_`, `SNAPSHOT_ID_`, `TEMPLATE_STYLE_`) VALUES ('1651467475169812480', '个人信息栏目移动端', 'grxxlmydd', NULL, 'HtCustom', NULL, NULL, NULL, NULL, 0, '', 'ICA8ZGl2IGNsYXNzPSJhbGxIb21lIj4KICAgIDxkaXYgY2xhc3M9ImFsbEhvbWVfaGVhZGVycyI+CiAgICAgIDx0ZW1wbGF0ZSB2LWlmPSJkYXRhLnVzZXIucGhvdG8iPgogICAgICAgIDxpbWcKICAgICAgICAgIDpzcmM9IiRyZXF1ZXN0Q29uZmlnLmdldEltZ1NyYyhkYXRhLnVzZXIucGhvdG8pIgogICAgICAgICAgYWx0PSIiCiAgICAgICAgICB3aWR0aD0iNTIiCiAgICAgICAgICBoZWlnaHQ9IjUyIgogICAgICAgIC8+CiAgICAgIDwvdGVtcGxhdGU+CgogICAgICA8aSB2LWVsc2UgY2xhc3M9Imljb24temhhbmdoYW8iIHN0eWxlPSJmb250LXNpemU6IDM2cHg7IGNvbG9yOiAjZmZmIj48L2k+CiAgICAgIDxkaXYgY2xhc3M9InRpdGxlIj4KICAgICAgICA8ZGl2IGNsYXNzPSJ0aXRsZV90b3AiPgogICAgICAgICAge3sgdGl0bGUgfX0KICAgICAgICA8L2Rpdj4KCiAgICAgICAgPGRpdiBjbGFzcz0idGl0bGVfYm90dG9tIj4KICAgICAgICAgIOS9oOWlve+8gSB7eyBkYXRhLnVzZXIuZnVsbG5hbWUgfX0s56Wd5L2g5byA5b+D5q+P5LiA5aSpCiAgICAgICAgPC9kaXY+CiAgICAgIDwvZGl2PgogICAgPC9kaXY+CiAgICA8ZGl2IGNsYXNzPSJhbGxIb21lX2NvbnRlbnQiPgogICAgICA8ZGl2IHYtZm9yPSIoaXRlbSwgaSkgb2YgbGlzdERhdGEiIDprZXk9ImkiIGNsYXNzPSJhbGxIb21lX2NvbnRlbnRfaXRlbSIgQGNsaWNrPSdjbGlja0l0ZW0oaXRlbSknPgogICAgICAgIDxkaXYgY2xhc3M9ImFsbEhvbWVfY29udGVudF9pdGVtX251bSI+CiAgICAgICAgICB7eyBpdGVtLm51bSA+PSA5OSA/ICI5OSsiIDogaXRlbS5udW0gfX0KICAgICAgICA8L2Rpdj4KICAgICAgICA8ZGl2IGNsYXNzPSJhbGxIb21lX2NvbnRlbnRfaXRlbV9uYW1lIj4KICAgICAgICAgIHt7IGl0ZW0ubmFtZSB9fQogICAgICAgIDwvZGl2PgogICAgICA8L2Rpdj4KICAgIDwvZGl2PgogIDwvZGl2Pg==', 1, NULL, 10, NULL, '', '{\"colType\":\"custom\",\"processPublicity\":[],\"announcementOrPictures\":null,\"filterType\":\"all\",\"filterScope\":[],\"selectType\":[],\"pullFrequency\":\"everyDay\",\"dataFrom\":\"${bpmRunTime}/runtime/instance/v1/getDefaultInfoMap\",\"model\":\"upDown\",\"colHeightType\":\"custom\",\"timeType\":\"day\",\"date\":\"\",\"currentDataType\":\"\",\"dataType\":\"\",\"dataMode\":3,\"requestType\":\"GET\"}', 0, NULL, NULL, '1', '1', '2023-04-27 14:05:04', '2023-05-04 16:08:15', NULL, '', '', '-1', 0, NULL, '', '', 'ewogIGRhdGEoKSB7CiAgICByZXR1cm4gewogICAgICBuYW1lOiAi6LaF57qn566h55CG5ZGYIiwKICAgICAgdGl0bGU6ICLmrKLov47kvb/nlKjlro/lpKlFSVAiLAogICAgICBpbWc6ICIiLAoKICAgICAgbGlzdERhdGE6IFsKICAgICAgICB7CiAgICAgICAgICBuYW1lOiAi5b6F5Yqe5pWw6YePIiwKICAgICAgICAgIG51bTogMCwKICAgICAgICAgIHRvOiAiL21hdHRlci9teVRhc2svMCIsCiAgICAgICAgICBpZDogIm15VGFrcyIsCiAgICAgICAgfSwKICAgICAgICB7CiAgICAgICAgICBuYW1lOiAi5bey5Yqe5pWw6YePIiwKICAgICAgICAgIG51bTogMCwKICAgICAgICAgIHRvOiAiL21hdHRlci9teVRhc2svMSIsCiAgICAgICAgICBpZDogIm15QWxyZWFkeSIsCiAgICAgICAgfSwKICAgICAgICB7CiAgICAgICAgICBuYW1lOiAi5oiR55qE55Sz6K+3IiwKICAgICAgICAgIG51bTogMCwKICAgICAgICAgIHRvOiAiL21hdHRlci9teVJlcXVlc3QiLAogICAgICAgICAgaWQ6ICJteVJlcXVlc3QiLAogICAgICAgICAKICAgICAgICB9LAogICAgICAgIHsKICAgICAgICAgIG5hbWU6ICLmiJHnmoTovazlip4iLAogICAgICAgICAgbnVtOiAwLAogICAgICAgICAgdG86ICIvbWF0dGVyL215RGVsZWdhdGUiLAogICAgICAgICAgaWQ6ICJteUFjY29yZGluZ01hdHRlcnMiLAogICAgICAgIH0sCiAgICAgIF0sCiAgICB9OwogIH0sCiAgbW91bnRlZCgpIHsKICAgIAogICAgZm9yIChsZXQgaXRlbT0wOyAgaXRlbSA8IHRoaXMubGlzdERhdGEubGVuZ3RoOyBpdGVtKyspIHsKICAKICAgICAgdGhpcy5saXN0RGF0YVtpdGVtXS5udW0gPSB0aGlzLmRhdGFbdGhpcy5saXN0RGF0YVtpdGVtXS5pZF0uZGF0YVRleHQgfHwgMDsKICAgIH0KICB9LAogIG1ldGhvZHM6IHsKICAgIGNsaWNrSXRlbShpdGVtKSB7CiAgICAgY29uc29sZS5sb2coaXRlbSkKICAgICAgdGhpcy4kcm91dGVyLnB1c2goaXRlbS50byk7CiAgICB9LAogIH0sCn0=', '', 0, '1654035192534351872', 'LmFsbEhvbWUgewoKICB3aWR0aDogY2FsYygxMDAlIC0gMjRweCk7CiAgICBkaXNwbGF5OiBmbGV4OwogICAgZmxleC1kaXJlY3Rpb246IGNvbHVtbjsKICAgIGp1c3RpZnktY29udGVudDogc3BhY2UtYmV0d2VlbjsKICBoZWlnaHQ6IDExOHB4OwogIGJhY2tncm91bmQ6ICNmZmZmZmY7CiAgYm9yZGVyLXJhZGl1czogMTJweCAxMnB4IDEycHggMTJweDsKICBwYWRkaW5nOiAxNnB4IDEycHg7Cn0KIC5hbGxIb21lX2hlYWRlcnMgewogIGRpc3BsYXk6IGZsZXg7CiAganVzdGlmeS1jb250ZW50OiBmbGV4LXN0YXJ0OwogIGFsaWduLWl0ZW1zOiBjZW50ZXI7Cn0KLmFsbEhvbWUgLmFsbEhvbWVfaGVhZGVycyBpbWcgewogIG1hcmdpbi1yaWdodDogOHB4OwogIGJvcmRlci1yYWRpdXM6IDUwJTsKfQouYWxsSG9tZSAuYWxsSG9tZV9oZWFkZXJzIC50aXRsZSAudGl0bGVfdG9wIAp7ICAgIG1hcmdpbi1ib3R0b206IDdweDsKICBjb2xvcjogIzI2MjYyNjsKICBmb250LXdlaWdodDogODAwOwogIGZvbnQtc2l6ZTogMThweDsKfQoKLmFsbEhvbWUgLmFsbEhvbWVfY29udGVudCAuYWxsSG9tZV9jb250ZW50X2l0ZW1fbnVtewogIG1hcmdpbi10b3A6MTZweDsKaGVpZ2h0OiAzMHB4Owpjb2xvcjogIzI2MjYyNjsKZm9udC13ZWlnaHQ6IDkwMDsKZm9udC1zaXplOiAyNHB4OwptYXJnaW4tYm90dG9tOiA2cHg7dGV4dC1hbGlnbjogY2VudGVyOwp9Ci5hbGxIb21lIC5hbGxIb21lX2hlYWRlcnMgLnRpdGxlIC50aXRsZV9ib3R0b20gewogIGNvbG9yOiAjNTg1ODU4OwogIGZvbnQtd2VpZ2h0OiA0MDA7CiAgZm9udC1zaXplOiAxNHB4Owp9Ci5hbGxIb21lIC5hbGxIb21lX2NvbnRlbnQgLmFsbEhvbWVfY29udGVudF9pdGVtX25hbWV7CiAgCmZvbnQtc2l6ZTogMTFweDsKZm9udC13ZWlnaHQ6IDQwMDsKY29sb3I6ICM4QzhDOEM7Cn0KCi5hbGxIb21lIC5hbGxIb21lX2NvbnRlbnR7CgogIGRpc3BsYXk6IGZsZXg7CiAganVzdGlmeS1jb250ZW50OiBzcGFjZS1iZXR3ZWVuOwogIGFsaWduLWl0ZW1zOiBjZW50ZXI7Cn0=');
INSERT INTO `portal_sys_column`(`ID`, `NAME`, `ALIAS`, `CATALOG`, `COL_TYPE`, `DATA_MODE`, `DATA_FROM`, `DS_ALIAS`, `DS_NAME`, `COL_HEIGHT`, `COL_URL`, `TEMPLATE_HTML`, `IS_PUBLIC`, `SUPPORT_REFESH`, `REFESH_TIME`, `SHOW_EFFECT`, `MEMO`, `DATA_PARAM`, `NEEDPAGE`, `ORG_ID`, `CREATOR`, `CREATE_BY_`, `UPDATE_BY_`, `CREATE_TIME_`, `UPDATE_TIME_`, `REQUEST_TYPE`, `CATALOG_NAME`, `CREATE_ORG_ID_`, `TENANT_ID_`, `SHOW_TITLE_`, `CONTAIN_COL_`, `APPID_`, `SECRET_`, `TEMPLATE_JAVA_SCRIPT_`, `STYLE_`, `is_init_`, `SNAPSHOT_ID_`, `TEMPLATE_STYLE_`) VALUES ('1651134508916514816', '常用功能', 'cygnsjd', NULL, 'HtCustom', NULL, NULL, NULL, NULL, NULL, '', 'PGRpdiBzdHlsZT0icGFkZGluZzoxNnB4IDAiPgogIDxkaXYgY2xhc3M9ImNvbW1vbi1mdW5jdGlvbiIgc3R5bGU9ImRpc3BsYXk6IGZsZXg7IGZsZXgtd3JhcDogd3JhcCI+CiAgICA8ZGl2CiAgICAgIGNsYXNzPSJtb2JpbGUtY3VzdG9tLWl0ZW0gaG92ZXItZm9sbG93LXRoZW1lLWNvbG9yIgogICAgICBvbmNsaWNrPSJ3aW5kb3cub3BlbignaHR0cDovL3d3dy5ob3RlbnQub3JnOjg4ODgvY2hhbnpoaS9pbmRleC5waHAvYm9vay91c2UxLzg3OC5odG1sJywnX2JsYW5rJykiCiAgICA+CiAgICAgIDxzdmcKICAgICAgICB0PSIxNjY0NTIzOTc1NDcxIgogICAgICAgIGNsYXNzPSJpY29uIgogICAgICAgIHZpZXdCb3g9IjAgMCAxMDI0IDEwMjQiCiAgICAgICAgdmVyc2lvbj0iMS4xIgogICAgICAgIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyIKICAgICAgICBwLWlkPSIxNjM1NiIKICAgICAgICB3aWR0aD0iMzIiCiAgICAgICAgaGVpZ2h0PSIzNiIKICAgICAgPgogICAgICAgIDxwYXRoCiAgICAgICAgICBkPSJNODE4LjAxODk4OCAwLjAwMDUzOUgxMDIuMzA1MzczYTc1LjE4NTA5NyA3NS4xODUwOTcgMCAwIDAtNzUuNDU0NTc4IDc0Ljk0MjU2NHY4MzIuNjk1MTU5YTc1LjIxMjA0NSA3NS4yMTIwNDUgMCAwIDAgNzUuNDU0NTc4IDc0Ljk2OTUxM2gzMjEuNDYzNDQ4bDQ2OS42MjM5MDEtNDY2LjkwMjE0N1Y3NC45NDMxMDNBNzUuMTU4MTQ5IDc1LjE1ODE0OSAwIDAgMCA4MTguMDE4OTg4IDAuMDAwNTM5ek00MTkuNTExMDI3IDY4Mi42NDg4ODFIMjI5Ljk1ODM0OWE0MC40MjIwOTUgNDAuNDIyMDk1IDAgMSAxIDAtODAuODQ0MTloMTg5LjU1MjY3OGE0MC40MjIwOTUgNDAuNDIyMDk1IDAgMSAxIDAgODAuODQ0MTl6IG0yNzAuNzc0MTQxLTE2Ni43ODE1NjRIMjI5Ljk4NTI5N2E0MC40MjIwOTUgNDAuNDIyMDk1IDAgMSAxIDAtODAuODQ0MTkxaDQ2MC4zMjY4MTlhNDAuNDIyMDk1IDQwLjQyMjA5NSAwIDEgMSAwIDgwLjg0NDE5MXogbTQwLjYzNzY3OS0yMTMuNDU1NjExYTQwLjQyMjA5NSA0MC40MjIwOTUgMCAwIDEtNDAuNjM3Njc5IDQwLjQyMjA5NkgyMjkuOTg1Mjk3YTQwLjQyMjA5NSA0MC40MjIwOTUgMCAwIDEtNDAuNjEwNzMyLTQwLjQyMjA5NiA0MC40MjIwOTUgNDAuNDIyMDk1IDAgMCAxIDQwLjYxMDczMi00MC40MjIwOTVoNDYwLjMyNjgxOWE0MC40MjIwOTUgNDAuNDIyMDk1IDAgMCAxIDQwLjYzNzY3OSA0MC40MjIwOTV6IgogICAgICAgICAgZmlsbD0iIzA3QzE2MCIKICAgICAgICAgIHAtaWQ9IjE2MzU3IgogICAgICAgID48L3BhdGg+CiAgICAgICAgPHBhdGgKICAgICAgICAgIGQ9Ik03MDUuMTYwNDk5IDc2Mi43OTI0MjFMNjYzLjE0ODQ2OCA4MDMuODYxMjdsLTM4Ljc3ODI2MyAzNy43MjcyODktMjkuMDUwMDEzIDI4LjI5NTQ2Ni0xNS4yNzk1NTIgMTQuNDcxMTFhODcuNjg4OTk4IDg3LjY4ODk5OCAwIDAgMC0xOC44NjM2NDQgMjUuNDkyODY4IDE4Mi4wMDcyMiAxODIuMDA3MjIgMCAwIDAtNi41MjE0MzEgMTcuMzgxNTAxbC04Ljg2NTkxMyAyNi4yNzQzNjItOC4wODQ0MTkgMjcuMjcxNDRjLTEuODA1NTIgNi42MDIyNzYtMy4zMTQ2MTIgMTMuMjg1Mzk1LTQuNjM1MDY3IDE5Ljk5NTQ2M2EyMy41Nzk1NTUgMjMuNTc5NTU1IDAgMCAwIDIuMjA5NzQxIDE5LjA3OTIyOWMzLjIzMzc2OCAzLjY5MTg4NSA5LjI0MzE4NiA0Ljg3NzU5OSAxOS4xMDYxNzcgMy42OTE4ODVhMTg5LjkyOTk1MSAxODkuOTI5OTUxIDAgMCAwIDIwLjgwMzkwNS00Ljk4NTM5MiAyNTYuNDkxNjY3IDI1Ni40OTE2NjcgMCAwIDAgMjkuNjQyODctNy44MTQ5MzhjMTAuMTU5NDItMi42OTQ4MDYgMTkuODg3NjcxLTYuMzg2NjkxIDI5LjkzOTI5OC05LjQ4NTcxOWwyNC40MTQ5NDYtMTAuOTk0ODA5IDEzLjg3ODI1Mi04LjA4NDQxOSAxMi44NTQyMjctOS40ODU3MTkgMzkuODAyMjg5LTM5LjE1NTUzNiAzOC45MTMwMDQtMzcuMjY5MTcyIDQxLjk4NTA4My00MC40MjIwOTUgMTEzLjc3NDcyMy0xMDguNzA4NDg3LTk4LjM4NzM3OS05NC41MDY4NTl6IG0yOTEuODQ3NTI2LTEwNC4yMDgxNjFhMTAzLjUwNzUxMiAxMDMuNTA3NTEyIDAgMCAwLTQuNjA4MTE4LTIyLjc3MTExMyA5Mi4zNTEwMTMgOTIuMzUxMDEzIDAgMCAwLTIwLjgwMzkwNS0yOS42NDI4NyA4MC40NjY5MTcgODAuNDY2OTE3IDAgMCAwLTI0LjkyNjk1OS0xOS41OTEyNDIgNjMuNjI0Mzc4IDYzLjYyNDM3OCAwIDAgMC0yNy4zNTIyODQtNy4xOTUxMzMgMzcuNTM4NjUyIDM3LjUzODY1MiAwIDAgMC0zMC4wNDcwOTEgMTAuMzc1MDA0bC0xNC43Njc1MzkgMTIuMzE1MjY1YTE4Ny4wNDY1MDggMTg3LjA0NjUwOCAwIDAgMS0xNS41NzU5OCAxMy42NjI2NjlsOTkuMzg0NDU3IDk0LjUzMzgwNmE1NC40ODg5ODQgNTQuNDg4OTg0IDAgMCAwIDguMjQ2MTA4LTYuNzkwOTEybDguMjQ2MTA3LTguNzA0MjI1IDEwLjUzNjY5My0xMC4zNzUwMDRhMzIuOTg0NDMgMzIuOTg0NDMgMCAwIDAgMTEuNjk1NDU5LTI1LjgxNjI0NXoiCiAgICAgICAgICBmaWxsPSIjMDdDMTYwN0EiCiAgICAgICAgICBwLWlkPSIxNjM1OCIKICAgICAgICA+PC9wYXRoPgogICAgICA8L3N2Zz4KICAgICAgPHNwYW4+5bel5pe255m76K6wPC9zcGFuPgogICAgPC9kaXY+CiAgICA8ZGl2CiAgICAgIGNsYXNzPSJtb2JpbGUtY3VzdG9tLWl0ZW0iCiAgICAgIG9uY2xpY2s9IndpbmRvdy5vcGVuKCdodHRwOi8vd3d3LmhvdGVudC5vcmc6ODg4OC9jaGFuemhpL2luZGV4LnBocC9ib29rL3VzZTEvODgwLmh0bWwnLCdfYmxhbmsnKSIKICAgID4KICAgICAgPHN2ZwogICAgICAgIHQ9IjE2NjQ1MjQ0MTY4NTMiCiAgICAgICAgY2xhc3M9Imljb24iCiAgICAgICAgdmlld0JveD0iMCAwIDExMzcgMTAyNCIKICAgICAgICB2ZXJzaW9uPSIxLjEiCiAgICAgICAgeG1sbnM9Imh0dHA6Ly93d3cudzMub3JnLzIwMDAvc3ZnIgogICAgICAgIHAtaWQ9IjE2NDkyIgogICAgICAgIHdpZHRoPSIzMiIKICAgICAgICBoZWlnaHQ9IjM2IgogICAgICA+CiAgICAgICAgPHBhdGgKICAgICAgICAgIGQ9Ik04NjYuMDE4MTcgNTgxLjI0MjIwMmExMDkuMDgwNjg3IDEwOS4wODA2ODcgMCAwIDEgNS45NzMxMjggMzMuMTM2NjM2djEwMi4zOTY0NzNhMTAzLjY3NjQyOSAxMDMuNjc2NDI5IDAgMCAxLTEwNC41Mjk3MzMgMTAyLjM5NjQ3M2gtMTA3LjUxNjI5NmExMDEuNzk5MTYgMTAxLjc5OTE2IDAgMCAxLTEwNC41Mjk3MzMtMTAyLjM5NjQ3M3YtMTAyLjM5NjQ3M2ExMjkuMDQ3OTk5IDEyOS4wNDc5OTkgMCAwIDEgNS45NzMxMjctMzMuMTM2NjM2Yy0xNTguMjU5NDM4IDQyLjE1MzIxNS0yNjguNzYyMjk4IDE0NC41NDk2ODgtMjY4Ljc2MjI5OCAyNjIuMDIxMTk3VjkyMS41NjgyNTdhMTAzLjY3NjQyOSAxMDMuNjc2NDI5IDAgMCAwIDEwNC41Mjk3MzMgMTAyLjM5NjQ3M2g2MzYuMDgxMjAyYTEwMS43OTkxNiAxMDEuNzk5MTYgMCAwIDAgMTA0LjUyOTczMi0xMDIuMzk2NDczdi03OC4zMDQ4NThjLTIuODQ0MzQ2LTExNy40NDMwNjYtMTEzLjQ4OTQyNC0yMTkuODM5NTM5LTI3MS43NDg4NjItMjYyLjAyMTE5N3pNNzEwLjc3Mzc0IDYxNC4zNzg4MzhhNTMuMTg5Mjc5IDUzLjE4OTI3OSAwIDAgMC01My43NTgxNDggNTEuMTk4MjM3djUxLjE5ODIzNmE1My44MTUwMzUgNTMuODE1MDM1IDAgMCAwIDEwNy41MTYyOTYgMHYtNTEuMTk4MjM2YTUwLjA4ODk0MSA1MC4wODg5NDEgMCAwIDAtMTQuOTMyODE5LTM2LjE1MTY0NCA1Ni41MTcxNjQgNTYuNTE3MTY0IDAgMCAwLTM4LjgyNTMyOS0xNS4wNDY1OTN6IG0wLTUxLjE5ODIzNmEyNzQuMTk1IDI3NC4xOTUgMCAwIDAgMjY1Ljc3NTczNC0yODAuMDgyNzk4YzAtMTUzLjU5NDcxLTExNi40NzU5ODgtMjgzLjA5NzgwNC0yNjIuNzg5MTctMjgzLjA5NzgwNFM0NDcuOTg0NTY5IDEyNi40ODgwODggNDQ3Ljk4NDU2OSAyODMuMDk3ODA0czExOS40MDU2NjUgMjgwLjA4Mjc5NyAyNjIuNzg5MTcxIDI4MC4wODI3OTh6IgogICAgICAgICAgZmlsbD0iI0ZFOUM1NCIKICAgICAgICAgIHAtaWQ9IjE2NDkzIgogICAgICAgID48L3BhdGg+CiAgICAgICAgPHBhdGgKICAgICAgICAgIGQ9Ik0xNzMuMTkyMjU3IDkxMy40NjE4N2ExMDIuNjUyNDY0IDEwMi42NTI0NjQgMCAwIDEtMTQuOTMyODE5LTUxLjM0MDQ1NHYtNzguNTMyNDA2YzAtMTExLjc1NDM3MyAxMDQuNTI5NzMzLTIxMS40MjAyNzMgMjU5LjgwMjYwNy0yNTYuNzAyMjY5YTI5OS44Nzk0NDkgMjk5Ljg3OTQ0OSAwIDAgMS05OC41NTY2MDYtMjI5LjUzODc2MUEzNDUuOTI5NDE4IDM0NS45Mjk0MTggMCAwIDEgMzU4LjM4NzY1NiAxNDMuMzI2NjE5YTIyNC4wMjA3MjggMjI0LjAyMDcyOCAwIDAgMC0xOTcuMDg0NzY4IDIyOS41Mzg3NiAyMzUuNTY4Nzc1IDIzNS41Njg3NzUgMCAwIDAgOTIuNTgzNDc4IDE5MC4yNTgzMzZDMTA3LjUxNjI5NyA1OTMuMzMwNjc0IDAgNjgwLjkwODEwMiAwIDc4MC40NjAyMjlWODU4Ljk5MjYzNWE1My4yNDYxNjYgNTMuMjQ2MTY2IDAgMCAwIDUzLjc1ODE0OCA1MS40NTQyMjd6IgogICAgICAgICAgZmlsbD0iI0ZGQzI5NSIKICAgICAgICAgIHAtaWQ9IjE2NDk0IgogICAgICAgID48L3BhdGg+CiAgICAgIDwvc3ZnPgogICAgICA8c3Bhbj7mlrDlu7rlrqLmiLc8L3NwYW4+CiAgICA8L2Rpdj4KICAgIDxkaXYKICAgICAgY2xhc3M9Im1vYmlsZS1jdXN0b20taXRlbSIKICAgICAgb25jbGljaz0id2luZG93Lm9wZW4oJ2h0dHA6Ly93d3cuaG90ZW50Lm9yZzo4ODg4L2NoYW56aGkvaW5kZXgucGhwL2Jvb2svdXNlMS84NzkuaHRtbCcsJ19ibGFuaycpIgogICAgPgogICAgICA8c3ZnCiAgICAgICAgdD0iMTY2NDUyNDQ0OTUyNyIKICAgICAgICBjbGFzcz0iaWNvbiIKICAgICAgICB2aWV3Qm94PSIwIDAgMTAyNCAxMDI0IgogICAgICAgIHZlcnNpb249IjEuMSIKICAgICAgICB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciCiAgICAgICAgcC1pZD0iMTY2MjgiCiAgICAgICAgd2lkdGg9IjMyIgogICAgICAgIGhlaWdodD0iMzYiCiAgICAgID4KICAgICAgICA8cGF0aAogICAgICAgICAgZD0iTTQ5OC40MTAyNjMgODIxLjg1Njg1NGEyNjkuNDUyMzQxIDI2OS40NTIzNDEgMCAwIDEgNDE4LjY3NTA0Ny0yMjQuMjkyMTI4VjI2MS40NDk4NzZhMTIyLjI1MDUyNyAxMjIuMjUwNTI3IDAgMCAwLTMwLjA3MDg4MS02NC45MzgwMTRMNzEzLjY3NTczOCAyNS42MjUxODdBMTAxLjY2NDM2OCAxMDEuNjY0MzY4IDAgMCAwIDY0Ni40NDczNzkgMC4wMDAyNjloLTUxNC42NTM5N0E3Ny41NDgzODQgNzcuNTQ4Mzg0IDAgMCAwIDUzLjk3NTU3MyA3Ni45MDE5Njh2ODMwLjk5MTAxOGE3My4wMjE1ODQgNzMuMDIxNTg0IDAgMCAwIDczLjAyMTU4NCA3My4wMjE1ODVoNDIzLjg0ODUzMmEyNjcuNzU0NzkxIDI2Ny43NTQ3OTEgMCAwIDEtNTIuNDM1NDI2LTE1OS4wNTc3MTd6TTI1Ni40MTUxMTYgMjYwLjg4NDAyNmg0NTguMDY4OTc5YTQwLjQxNzg1MSA0MC40MTc4NTEgMCAwIDEgMCA4MC44MzU3MDJoLTQ1OC4wNjg5NzlhNDAuNDE3ODUxIDQwLjQxNzg1MSAwIDAgMSAwLTgwLjgzNTcwMnogbTAgMTczLjIzMDkxaDQ1OC4wNjg5NzlhNDAuNDE3ODUxIDQwLjQxNzg1MSAwIDEgMSAwIDgwLjgzNTcwMmgtNDU4LjA2ODk3OWE0MC40MTc4NTEgNDAuNDE3ODUxIDAgMSAxIDAtODAuODM1NzAyeiBtMTg4LjYxNjYzOSAyNDcuNzA3NTM2aC0xODguNjE2NjM5YTQwLjQxNzg1MSA0MC40MTc4NTEgMCAxIDEgMC04MC44MzU3MDJoMTg4LjYxNjYzOWE0MC40MTc4NTEgNDAuNDE3ODUxIDAgMSAxIDAgODAuODM1NzAyeiIKICAgICAgICAgIGZpbGw9IiM0MDUzRkYiCiAgICAgICAgICBwLWlkPSIxNjYyOSIKICAgICAgICA+PC9wYXRoPgogICAgICAgIDxwYXRoCiAgICAgICAgICBkPSJNNzY3LjkxNjQ5NSA2MTkuODIxNDg5YTIwMi4wODkyNTYgMjAyLjA4OTI1NiAwIDEgMCAyMDIuMDg5MjU1IDIwMi4wODkyNTUgMjAyLjA4OTI1NiAyMDIuMDg5MjU2IDAgMCAwLTIwMi4wODkyNTUtMjAyLjA4OTI1NXogbTEzMC4wOTE1OSAxOTEuMzExMTYybC00My43ODYwMDYgMzcuNzIzMzI4YTI0LjI1MDcxMSAyNC4yNTA3MTEgMCAwIDAtNS43MTIzODkgMTYuMTY3MTRsOS41MTE2NjcgNTUuODg0NDE1YTIwLjM0MzY1MiAyMC4zNDM2NTIgMCAwIDEtMjguNTYxOTQ4IDE5LjgzMTY5M2wtNTEuMzg0NTYxLTI2Ljk0NTIzNGExNS4wMDg0OTUgMTUuMDA4NDk1IDAgMCAwLTE3LjEzNzE2OSAwbC01My4yOTc2NzMgMjYuOTQ1MjM0YTE5LjY3MDAyMSAxOS42NzAwMjEgMCAwIDEtMjguNTYxOTQ4LTE5LjgzMTY5M2w5LjUxMTY2Ny01NS44ODQ0MTVhMTcuNTQxMzQ3IDE3LjU0MTM0NyAwIDAgMC01LjcxMjM4OS0xNi4xNjcxNGwtNDMuNzg2MDA2LTM5LjYzNjQ0YTE3LjU0MTM0NyAxNy41NDEzNDcgMCAwIDEgMTEuNDI0NzgtMzAuNjYzNjc2bDU5LjAxMDA2Mi04Ljk5OTcwOGEyNi40ODcxNjUgMjYuNDg3MTY1IDAgMCAwIDE1LjI1MTAwMy05LjAyNjY1NGwyNi42NDg4MzYtNTAuNDQxNDc4YTIwLjIwODkyNiAyMC4yMDg5MjYgMCAwIDEgMzQuMjQ3MzkzIDBsMjYuNjQ4ODM2IDUwLjQ0MTQ3OGEyOS42Mzk3NTcgMjkuNjM5NzU3IDAgMCAwIDE1LjI1MTAwMyAxMC43NzgwOTRsNTkuMDEwMDYyIDguOTk5NzA4YTE4LjQ4NDQzMSAxOC40ODQ0MzEgMCAwIDEgMTEuNDI0NzggMzAuNTgyODQxeiIKICAgICAgICAgIGZpbGw9IiM0MDUzRkY3QSIKICAgICAgICAgIHAtaWQ9IjE2NjMwIgogICAgICAgID48L3BhdGg+CiAgICAgIDwvc3ZnPgogICAgICA8c3Bhbj7mlrDlu7rlkIjlkIw8L3NwYW4+CiAgICA8L2Rpdj4KICAgIDxkaXYKICAgICAgY2xhc3M9Im1vYmlsZS1jdXN0b20taXRlbSIKICAgICAgb25jbGljaz0id2luZG93Lm9wZW4oJ2h0dHA6Ly93d3cuaG90ZW50Lm9yZzo4ODg4L2NoYW56aGkvaW5kZXgucGhwL2Jvb2svZGVwbG95LzYuaHRtbCwnX2JsYW5rJykiCiAgICA+CiAgICAgIDxzdmcKICAgICAgICB0PSIxNjY0NTI0NTM4MzAxIgogICAgICAgIGNsYXNzPSJpY29uIgogICAgICAgIHZpZXdCb3g9IjAgMCAxMDI0IDEwMjQiCiAgICAgICAgdmVyc2lvbj0iMS4xIgogICAgICAgIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyIKICAgICAgICBwLWlkPSIxNjc2NCIKICAgICAgICB3aWR0aD0iMzIiCiAgICAgICAgaGVpZ2h0PSIzNiIKICAgICAgPgogICAgICAgIDxwYXRoCiAgICAgICAgICBkPSJNMTEwLjg4NzM0MSAxNDAuMTM0OTIybDQwLjQyMDY1OS00OC41MDQ3OTFhNDY5LjA5NTIyMiA0NjkuMDk1MjIyIDAgMCAxIDMyLjMzNjUyOC0zNy43MjU5NDhsMjYuOTQ3MTA2LTI2Ljk0NzEwN2E5Ni43NDAxMTEgOTYuNzQwMTExIDAgMCAxIDI2Ljk0NzEwNi0xOC44NjI5NzQgODUuOTg4MjE1IDg1Ljk4ODIxNSAwIDAgMSAzNy43MjU5NDgtOC4wODQxMzJoNDg0LjcyNDU0NGExNTcuNTU5NzI5IDE1Ny41NTk3MjkgMCAwIDEgMzUuMDMxMjM4IDUuMzg5NDIyIDEyMS4zOTY3MTMgMTIxLjM5NjcxMyAwIDAgMSAzNy43MjU5NDggMjYuOTQ3MTA2IDE5Ni41MjUyNDQgMTk2LjUyNTI0NCAwIDAgMCAyNC4yNTIzOTUgMjkuNjQxODE2IDMwNC45ODczNDYgMzA0Ljk4NzM0NiAwIDAgMSAyNi45NDcxMDYgMzUuMDMxMjM4YzEwLjc3ODg0MiAxMy40NzM1NTMgMjEuNTU3Njg1IDI5LjY0MTgxNyAzMi4zMzY1MjggNDMuMTE1Mzd6IgogICAgICAgICAgZmlsbD0iIzdGQzdGMSIKICAgICAgICAgIHAtaWQ9IjE2NzY1IgogICAgICAgID48L3BhdGg+CiAgICAgICAgPHBhdGgKICAgICAgICAgIGQ9Ik0xMDIxLjI5NTMxOSAzMzEuMzI0NjM5YTk0LjEyNjI0MSA5NC4xMjYyNDEgMCAwIDAtMjEuNTU3Njg1LTY0LjY3MzA1NCA4My4yNjY1NTggODMuMjY2NTU4IDAgMCAwLTcyLjc1NzE4Ni0yNi45NDcxMDZIMTAwLjEwODQ5OWE5MS40MDQ1ODQgOTEuNDA0NTg0IDAgMCAwLTcyLjc1NzE4NiAyNi45NDcxMDYgODYuMDY5MDU3IDg2LjA2OTA1NyAwIDAgMC0yMS41NTc2ODUgNjQuNjczMDU0djE3Ny44NTA5YTg5Ljg2ODU5OSA4OS44Njg1OTkgMCAwIDAgOTQuMzE0ODcxIDgzLjUzNjAyOWg4MzIuMjg4MzE3YTgwLjQ5MTAwNiA4MC40OTEwMDYgMCAwIDAgNjcuMzY3NzY1LTI2Ljk0NzEwNiA5Ni41Nzg0MjggOTYuNTc4NDI4IDAgMCAwIDI0LjI1MjM5Ni02NC42NzMwNTV6IG0tNDQxLjc3MDg1NiAxMjMuOTU2Njg4aC0xMzQuNzM1NTMxYTQwLjQyMDY1OSA0MC40MjA2NTkgMCAwIDEgMC04MC44NDEzMThoMTM0LjczNTUzMWE0MS40NDQ2NDkgNDEuNDQ0NjQ5IDAgMCAxIDQwLjQyMDY1OSA0MC40MjA2NTkgMzkuNjY2MTQgMzkuNjY2MTQgMCAwIDEtNDAuNDIwNjU5IDQwLjQyMDY1OXoiCiAgICAgICAgICBmaWxsPSIjMkZBQUYyIgogICAgICAgICAgcC1pZD0iMTY3NjYiCiAgICAgICAgPjwvcGF0aD4KICAgICAgICA8cGF0aAogICAgICAgICAgZD0iTTEwMjMuOTkwMDMgNzU2LjgxOTQ0NGE5MS44MDg3OSA5MS44MDg3OSAwIDAgMC0yNC4yNTIzOTYtNjQuNjczMDU1IDg1Ljg1MzQ4IDg1Ljg1MzQ4IDAgMCAwLTcwLjA2MjQ3Ni0yNi45NDcxMDZIMTAwLjEwODQ5OWExMDAuODA5MTI0IDEwMC44MDkxMjQgMCAwIDAtNzUuNDUxODk3IDI2Ljk0NzEwNiAxMDMuNTAzODM0IDEwMy41MDM4MzQgMCAwIDAtMjQuMjUyMzk1IDY3LjM2Nzc2NXYxNjEuNjgyNjM2YTkwLjU5NjE3MSA5MC41OTYxNzEgMCAwIDAgMjkuNjQxODE2IDc1LjQ1MTg5NyA5NC4wNDU0IDk0LjA0NTQgMCAwIDAgNjQuNjczMDU1IDI2Ljk0NzEwNmg4MzIuMjg4MzE3YTkyLjIzOTk0NCA5Mi4yMzk5NDQgMCAwIDAgOTcuMDA5NTgyLTk0LjMxNDg3MXogbS00NDQuNDY1NTY3IDE1OC45ODc5MjVoLTEzNC43MzU1MzFhNDAuNDIwNjU5IDQwLjQyMDY1OSAwIDAgMSAwLTgwLjg0MTMxOGgxMzQuNzM1NTMxYTQxLjQ0NDY0OSA0MS40NDQ2NDkgMCAwIDEgNDAuNDIwNjU5IDQwLjQyMDY1OSAzOC4xODQwNDkgMzguMTg0MDQ5IDAgMCAxLTQwLjQyMDY1OSA0MC40MjA2NTl6IgogICAgICAgICAgZmlsbD0iIzJGQUFGMiIKICAgICAgICAgIHAtaWQ9IjE2NzY3IgogICAgICAgID48L3BhdGg+CiAgICAgIDwvc3ZnPgogICAgICA8c3Bhbj7mlrDlu7rpobnnm648L3NwYW4+CiAgICA8L2Rpdj4KICAgIDxkaXYKICAgICAgY2xhc3M9Im1vYmlsZS1jdXN0b20taXRlbSIKICAgICAgb25jbGljaz0id2luZG93Lm9wZW4oJ2h0dHA6Ly93d3cuaG90ZW50Lm9yZzo4ODg4L2NoYW56aGkvaW5kZXgucGhwL2Jvb2svZGVwbG95LzYuaHRtbCwnX2JsYW5rJykiCiAgICA+CiAgICAgIDxzdmcKICAgICAgICB0PSIxNjY0NTI0Njc5NTI3IgogICAgICAgIGNsYXNzPSJpY29uIgogICAgICAgIHZpZXdCb3g9IjAgMCAxMTM3IDEwMjQiCiAgICAgICAgdmVyc2lvbj0iMS4xIgogICAgICAgIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyIKICAgICAgICBwLWlkPSIxNzQ0OCIKICAgICAgICB3aWR0aD0iMzIiCiAgICAgICAgaGVpZ2h0PSIzNiIKICAgICAgPgogICAgICAgIDxwYXRoCiAgICAgICAgICBkPSJNMTAzOC4yMjIyMjIgMEExMDAuNzc4NjY3IDEwMC43Nzg2NjcgMCAwIDEgMTEzNy43Nzc3NzggOTkuNTU1NTU2djY2OC4xNmExMDAuNzc4NjY3IDEwMC43Nzg2NjcgMCAwIDEtOTkuNTU1NTU2IDk5LjU1NTU1NUg1MTQuODQ0NDQ0bC0yMzAuNCAxNTAuNzU1NTU2YTMyLjE5OTExMSAzMi4xOTkxMTEgMCAwIDEtNDUuNTExMTExLTguNTMzMzM0IDQwLjM5MTExMSA0MC4zOTExMTEgMCAwIDEtNS42ODg4ODktMTcuMDY2NjY2di0xMjIuMzExMTExSDk5LjU1NTU1NmExMDAuNzc4NjY3IDEwMC43Nzg2NjcgMCAwIDEtOTkuNTU1NTU2LTk5LjU1NTU1NlY5OS41NTU1NTZBMTAwLjc3ODY2NyAxMDAuNzc4NjY3IDAgMCAxIDk5LjU1NTU1NiAwaDkzOC42NjY2NjZ6IgogICAgICAgICAgZmlsbD0iIzg1NTBFMSIKICAgICAgICAgIHAtaWQ9IjE3NDQ5IgogICAgICAgID48L3BhdGg+CiAgICAgICAgPHBhdGgKICAgICAgICAgIGQ9Ik03NTMuNzc3Nzc4IDMzMi43MTQ2NjdoLTM2OS43Nzc3NzhhNDMuNzQ3NTU2IDQzLjc0NzU1NiAwIDAgMS00Mi42NjY2NjctNDIuNjY2NjY3IDQzLjc0NzU1NiA0My43NDc1NTYgMCAwIDEgNDIuNjY2NjY3LTQyLjY2NjY2N2gzNjkuNzc3Nzc4YTQzLjc0NzU1NiA0My43NDc1NTYgMCAwIDEgNDIuNjY2NjY2IDQyLjY2NjY2NyA0My43NDc1NTYgNDMuNzQ3NTU2IDAgMCAxLTQyLjY2NjY2NiA0Mi42NjY2Njd6IgogICAgICAgICAgZmlsbD0iI0ZGRkZGRjdBIgogICAgICAgICAgcC1pZD0iMTc0NTAiCiAgICAgICAgPjwvcGF0aD4KICAgICAgICA8cGF0aAogICAgICAgICAgZD0iTTU4My4xMTExMTEgNTMxLjc0MDQ0NGgtMTk5LjExMTExMWE0My43NDc1NTYgNDMuNzQ3NTU2IDAgMCAxLTQyLjY2NjY2Ny00Mi42NjY2NjYgNDMuNzQ3NTU2IDQzLjc0NzU1NiAwIDAgMSA0Mi42NjY2NjctNDIuNjY2NjY3aDE5OS4xMTExMTFhNDMuNzQ3NTU2IDQzLjc0NzU1NiAwIDAgMSA0Mi42NjY2NjcgNDIuNjY2NjY3IDQxLjg5ODY2NyA0MS44OTg2NjcgMCAwIDEtNDIuNjY2NjY3IDQyLjY2NjY2NnoiCiAgICAgICAgICBmaWxsPSIjRkZGRkZGN0EiCiAgICAgICAgICBwLWlkPSIxNzQ1MSIKICAgICAgICA+PC9wYXRoPgogICAgICA8L3N2Zz4KICAgICAgPHNwYW4+5ZSu5YmN5pSv5oyBPC9zcGFuPgogICAgPC9kaXY+CiAgICA8ZGl2CiAgICAgIGNsYXNzPSJtb2JpbGUtY3VzdG9tLWl0ZW0iCiAgICAgIG9uY2xpY2s9IndpbmRvdy5vcGVuKCdodHRwOi8vd3d3LmhvdGVudC5vcmc6ODg4OC9jaGFuemhpL2luZGV4LnBocC9ib29rL2RlcGxveS82Lmh0bWwsJ19ibGFuaycpIgogICAgPgogICAgICA8c3ZnCiAgICAgICAgdD0iMTY2NDUyNDY2NDE0MiIKICAgICAgICBjbGFzcz0iaWNvbiIKICAgICAgICB2aWV3Qm94PSIwIDAgMTAyNCAxMDI0IgogICAgICAgIHZlcnNpb249IjEuMSIKICAgICAgICB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciCiAgICAgICAgcC1pZD0iMTczMTEiCiAgICAgICAgd2lkdGg9IjMyIgogICAgICAgIGhlaWdodD0iMzYiCiAgICAgID4KICAgICAgICA8cGF0aAogICAgICAgICAgZD0iTTUxMi4wMjkyMzYgMTMxLjI0OTczYTI4Mi45MzM3NDMgMjgyLjkzMzc0MyAwIDEgMCAyODguMzIyOTU4IDI4Mi45MzM3NDMgMjgyLjkzMzc0MyAyODIuOTMzNzQzIDAgMCAwLTI4OC4zMjI5NTgtMjgyLjkzMzc0M3oiCiAgICAgICAgICBmaWxsPSIjMDdDMTYwIgogICAgICAgICAgcC1pZD0iMTczMTIiCiAgICAgICAgPjwvcGF0aD4KICAgICAgICA8cGF0aAogICAgICAgICAgZD0iTTE3Ny44OTc5NTkgNTIxLjk2Nzc1NnYtMjYxLjM3Njg4N2gtMTAuNzc4NDI4YTM4MS4zNjc3MzkgMzgxLjM2NzczOSAwIDAgMSA1MDYuNTg2MTMtMTgwLjUzODY3NCAzOTAuODUyNzU2IDM5MC44NTI3NTYgMCAwIDEgMTgwLjUzODY3NCAxODAuNTM4Njc0aC0xMC43Nzg0Mjh2MjYxLjM3Njg4N2ExMjkuOTYwODk5IDEyOS45NjA4OTkgMCAwIDAgMTMyLjAzNTc0Ni0xMjkuMzQxMTQgMTI4LjI2MzI5NyAxMjguMjYzMjk3IDAgMCAwLTY3LjM2NTE3Ni0xMTMuMTczNDk3IDQyMy4wNTMzMTEgNDIzLjA1MzMxMSAwIDAgMC03OTQuOTA5MDg4LTIuNjk0NjA3IDEyNi4xODg0NDkgMTI2LjE4ODQ0OSAwIDAgMC02Ny4zNjUxNzcgMTEzLjE3MzQ5NyAxMzIuMjUxMzE1IDEzMi4yNTEzMTUgMCAwIDAgMTMyLjAzNTc0NyAxMzIuMDM1NzQ3eiIKICAgICAgICAgIGZpbGw9IiMwN0MxNjA3QSIKICAgICAgICAgIHAtaWQ9IjE3MzEzIgogICAgICAgID48L3BhdGg+CiAgICAgICAgPHBhdGgKICAgICAgICAgIGQ9Ik03OTcuNjU3NTg2IDY3MS4wMDY0NzNhNDI2LjA0NDMyNSA0MjYuMDQ0MzI1IDAgMCAxLTU3My45NTEzMDcgMEEzODEuODc5NzE1IDM4MS44Nzk3MTUgMCAwIDAgMC4wNTM4OTIgMTAyNGgxMDIzLjk1MDY4OWMwLTE2NC4zNzEwMzItODguOTIyMDMzLTI4NS42MjgzNS0yMjYuMzQ2OTk1LTM1Mi45OTM1Mjd6IgogICAgICAgICAgZmlsbD0iIzA3QzE2MCIKICAgICAgICAgIHAtaWQ9IjE3MzE0IgogICAgICAgID48L3BhdGg+CiAgICAgIDwvc3ZnPgogICAgICA8c3Bhbj7llK7lkI7mlK/mjIE8L3NwYW4+CiAgICA8L2Rpdj4KICAgIDxkaXYKICAgICAgY2xhc3M9Im1vYmlsZS1jdXN0b20taXRlbSIKICAgICAgb25jbGljaz0id2luZG93Lm9wZW4oJ2h0dHA6Ly93d3cuaG90ZW50Lm9yZzo4ODg4L2NoYW56aGkvaW5kZXgucGhwL2Jvb2svY2p3dC8yNzMuaHRtbCwnX2JsYW5rJykiCiAgICA+CiAgICAgIDxzdmcKICAgICAgICB0PSIxNjY0NTI0NjUyMDAyIgogICAgICAgIGNsYXNzPSJpY29uIgogICAgICAgIHZpZXdCb3g9IjAgMCAxMDI0IDEwMjQiCiAgICAgICAgdmVyc2lvbj0iMS4xIgogICAgICAgIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyIKICAgICAgICBwLWlkPSIxNzE3NSIKICAgICAgICB3aWR0aD0iMzIiCiAgICAgICAgaGVpZ2h0PSIzNiIKICAgICAgPgogICAgICAgIDxwYXRoCiAgICAgICAgICBkPSJNNTEyIDUxMm0tNTEyIDBhNTEyIDUxMiAwIDEgMCAxMDI0IDAgNTEyIDUxMiAwIDEgMC0xMDI0IDBaIgogICAgICAgICAgZmlsbD0iI0VGQTEzQyIKICAgICAgICAgIHAtaWQ9IjE3MTc2IgogICAgICAgID48L3BhdGg+CiAgICAgICAgPHBhdGgKICAgICAgICAgIGQ9Ik03MjUuNjgzMiAyNjcuNDQzMmE1MS4zMjggNTEuMzI4IDAgMCAwLTM0LjcxMzYgMGwtMjYwLjM3NzYgOTMuNzcyOGExMTUuMiAxMTUuMiAwIDAgMC02OS4zNzYgNjkuMzc2bC05My43NDcyIDI2MC4zNzc2YTUxLjIgNTEuMiAwIDAgMCA2NS41MzYgNjUuNTM2bDI2MC40MDMyLTkzLjc0NzJhMTE1LjIgMTE1LjIgMCAwIDAgNjkuMzUwNC02OS4zNzZsOTMuNzQ3Mi0yNjAuNDAzMmE1MS4yIDUxLjIgMCAwIDAtMzAuODIyNC02NS41MzZ6IG0tMjEzLjY4MzIgMzA4LjUzMTJhNjQgNjQgMCAxIDEgNjQtNjQgNjQgNjQgMCAwIDEtNjQuMDI1NiA2NC4wMjU2eiIKICAgICAgICAgIGZpbGw9IiNGRkRBQUIiCiAgICAgICAgICBwLWlkPSIxNzE3NyIKICAgICAgICA+PC9wYXRoPgogICAgICA8L3N2Zz4KICAgICAgPHNwYW4+57u85ZCI5bmz5Y+wPC9zcGFuPgogICAgPC9kaXY+CiAgICA8ZGl2CiAgICAgIGNsYXNzPSJtb2JpbGUtY3VzdG9tLWl0ZW0iCiAgICAgIG9uY2xpY2s9IndpbmRvdy5vcGVuKCdodHRwOi8vd3d3LmhvdGVudC5vcmc6ODg4OC9jaGFuemhpL2luZGV4LnBocC9ib29rL2V4dGVuZC9qc2NoZWNrLTE1OS5odG1sLCdfYmxhbmsnKSIKICAgID4KICAgICAgPHN2ZwogICAgICAgIHQ9IjE2NjQ1MjQ2MzQ5NzciCiAgICAgICAgY2xhc3M9Imljb24iCiAgICAgICAgdmlld0JveD0iMCAwIDEwODEgMTAyNCIKICAgICAgICB2ZXJzaW9uPSIxLjEiCiAgICAgICAgeG1sbnM9Imh0dHA6Ly93d3cudzMub3JnLzIwMDAvc3ZnIgogICAgICAgIHAtaWQ9IjE3MDM5IgogICAgICAgIHdpZHRoPSIzMiIKICAgICAgICBoZWlnaHQ9IjM2IgogICAgICA+CiAgICAgICAgPHBhdGgKICAgICAgICAgIGQ9Ik05My44NzcxMzcgNjQyLjg0MjEyM0gwLjAxMDgwOXYxMTMuNzc3MzY3QTk3LjE5NDMxNiA5Ny4xOTQzMTYgMCAwIDAgOTMuODc3MTM3IDg1My4zMzAyNTJoMzk4LjIyMDc4NHY3Ni43OTk3MjNoLTE0Mi4yMjE3MDlhNDUuNTEwOTQ3IDQ1LjUxMDk0NyAwIDAgMC00NS41MTA5NDcgNDguMzU1MzggNDQuOTQyMDYgNDQuOTQyMDYgMCAwIDAgNDUuNTEwOTQ3IDQ1LjUxMDk0N2gzNzUuNDY1MzExYTQ1LjUxMDk0NyA0NS41MTA5NDcgMCAwIDAgNDUuNTEwOTQ3LTQ4LjM1NTM4MSA0NC45NDIwNiA0NC45NDIwNiAwIDAgMC00NS41MTA5NDctNDUuNTEwOTQ2aC0xNDIuMjIxNzA5Vjg1My4zMzAyNTJoNDAxLjA2NTIxOWE5NS4zMTY5ODkgOTUuMzE2OTg5IDAgMCAwIDkzLjg2NjMyNy05Ni43MTA3NjJ2LTExMy43NzczNjdIOTMuODc3MTM3eiIKICAgICAgICAgIGZpbGw9IiM0MDUzRkY3QSIKICAgICAgICAgIHAtaWQ9IjE3MDQwIgogICAgICAgID48L3BhdGg+CiAgICAgICAgPHBhdGgKICAgICAgICAgIGQ9Ik05ODcuMDI5NDY3IDBIOTMuODc3MTM3QTk1LjMxNjk4OSA5NS4zMTY5ODkgMCAwIDAgMC4wMTA4MDkgOTYuNzEwNzYydjQ0OS40MjA1OTloMTA4MC44ODQ5ODZWOTYuNzEwNzYyQTk1LjIwMzIxMiA5NS4yMDMyMTIgMCAwIDAgOTg3LjAyOTQ2NyAwIgogICAgICAgICAgZmlsbD0iIzQwNTNGRiIKICAgICAgICAgIHAtaWQ9IjE3MDQxIgogICAgICAgID48L3BhdGg+CiAgICAgIDwvc3ZnPgogICAgICA8c3Bhbj7lkI7lj7DnrqHnkIY8L3NwYW4+CiAgICA8L2Rpdj4KICA8L2Rpdj4KPC9kaXY+Cg==', 1, NULL, 10, NULL, '', '{\"colType\":\"custom\",\"processPublicity\":[],\"announcementOrPictures\":null,\"filterType\":\"all\",\"filterScope\":[],\"selectType\":[],\"pullFrequency\":\"everyDay\",\"dataFrom\":\"\",\"model\":\"upDown\",\"colHeightType\":\"default\",\"timeType\":\"day\",\"date\":\"\",\"currentDataType\":\"\",\"dataType\":\"\"}', 0, NULL, NULL, '1', '1', '2023-04-26 16:01:58', '2023-05-05 17:09:33', NULL, '', '', '-1', 1, NULL, '', '', 'e30=', '', 0, '1654413008396435456', 'Lm1vYmlsZS1jdXN0b20taXRlbXsKICAgZGlzcGxheTogZmxleDsKICAgIGZsZXgtZGlyZWN0aW9uOiBjb2x1bW47CiAgICBhbGlnbi1pdGVtczogY2VudGVyOwogICAganVzdGlmeS1jb250ZW50OiBzcGFjZS1hcm91bmQ7CiAgICBoZWlnaHQ6IDgycHg7CiAgICBjb2xvcjogIzI2MjYyNjsKICAgIGZvbnQtc2l6ZTogMTNweDsKICAgIHdpZHRoOiAyNSU7CiAgICBtYXJnaW4tYm90dG9tOiA4cHg7Cn0KICA=');
INSERT INTO `portal_sys_column`(`ID`, `NAME`, `ALIAS`, `CATALOG`, `COL_TYPE`, `DATA_MODE`, `DATA_FROM`, `DS_ALIAS`, `DS_NAME`, `COL_HEIGHT`, `COL_URL`, `TEMPLATE_HTML`, `IS_PUBLIC`, `SUPPORT_REFESH`, `REFESH_TIME`, `SHOW_EFFECT`, `MEMO`, `DATA_PARAM`, `NEEDPAGE`, `ORG_ID`, `CREATOR`, `CREATE_BY_`, `UPDATE_BY_`, `CREATE_TIME_`, `UPDATE_TIME_`, `REQUEST_TYPE`, `CATALOG_NAME`, `CREATE_ORG_ID_`, `TENANT_ID_`, `SHOW_TITLE_`, `CONTAIN_COL_`, `APPID_`, `SECRET_`, `TEMPLATE_JAVA_SCRIPT_`, `STYLE_`, `is_init_`, `SNAPSHOT_ID_`, `TEMPLATE_STYLE_`) VALUES ('1651056986864828416', '数据台', 'sjt', NULL, 'HtCustom', NULL, NULL, NULL, NULL, NULL, '', 'PGRpdiBjbGFzcz0ibW9iaWxlLWFwcGx5LWNhcmQiIDpjbGFzcz0ieyAnYm9yZGVyLWJvdHRvbSc6IGlzU2hvd0JvdHRvbU1hcmdpbiB9Ij4KICA8ZGl2CiAgICA6Ym9yZGVyPSJmYWxzZSIKICAgIGNsYXNzPSJtb2JpbGUtYXBwbHktY2FyZC0tY29udGVudCIKICAgIHYtaWY9ImFwcGx5TGlzdCAmJiBhcHBseUxpc3QubGVuZ3RoIgogID4KICAgIDxkaXYKICAgICAgY2xhc3M9Im1vYmlsZS1hcHBseS1jYXJkLS1pdGVtIgogICAgICB2LWZvcj0iKGl0ZW0sIGluZGV4KSBpbiBhcHBseUxpc3QiCiAgICAgIDprZXk9ImAke2l0ZW0ubmFtZX1fJHtpbmRleH1gIgogICAgICBAY2xpY2s9ImhhbmRsZUNsaWNrKGl0ZW0pIgogICAgPgogICAgICA8ZGl2CiAgICAgICAgY2xhc3M9Iml0ZW0tdG9wLS1pY29uIgogICAgICAgIDpzdHlsZT0ieyBiYWNrZ3JvdW5kOiBpdGVtLmljb25Db2xvciB8fCAnIzQwOUVGRicgfSIKICAgICAgPgogICAgICAgIDxpIGNsYXNzPSJtb2JpbGUtYXBwbHktaWNvbiIgOmNsYXNzPSJpdGVtLmljb24gfHwgJ2ljb24tYXNpZGUtYXBwLWNlbnRlciciPjwvaT4KICAgICAgPC9kaXY+CiAgICAgIDxkaXYgY2xhc3M9Im1vYmlsZS1pdGVtLWJvdHRvbS0tbmFtZSI+e3sgaXRlbS5uYW1lfX08L2Rpdj4KICAgIDwvZGl2PgogIDwvZGl2Pgo8L2Rpdj4=', 1, NULL, 10, NULL, '', '{\"colType\":\"custom\",\"processPublicity\":[],\"announcementOrPictures\":null,\"filterType\":\"all\",\"filterScope\":[],\"selectType\":[],\"pullFrequency\":\"everyDay\",\"dataFrom\":\"\",\"model\":\"upDown\",\"colHeightType\":\"default\",\"timeType\":\"day\",\"date\":\"\",\"currentDataType\":\"\",\"dataType\":\"\"}', 0, NULL, NULL, '1', '1', '2023-04-26 10:53:55', '2023-05-05 15:05:57', NULL, '', '', '-1', 1, NULL, '', '', 'ewogICBkYXRhKCkgewogICAgICByZXR1cm4gewogICAgICAgIGlzU2hvd0JvdHRvbU1hcmdpbjpmYWxzZSwKICAgICAgICBhcHBseUxpc3Q6IFsKICAgICAgICAgIHsKICAgICAgICAgICAgbmFtZTogJ+aWsOW7uua1geeoiycsCiAgICAgICAgICAgIGljb246ICdpY29uLXhpbmppYW5saXVjaGVuZzExJywKICAgICAgICAgICAgaWNvbkNvbG9yOiAnIzQwOUVGRicsCiAgICAgICAgICAgIHBhdGg6ICcvbWF0dGVyL25ld01hdHRlcicsCiAgICAgICAgICB9LAogICAgICAgICAgewogICAgICAgICAgICBuYW1lOiAn5b6F5Yqe5bey5YqeJywKICAgICAgICAgICAgaWNvbjogJ2ljb24tZGFpYmFuJywKICAgICAgICAgICAgaWNvbkNvbG9yOiAnIzQwNTNGRicsCiAgICAgICAgICAgIHBhdGg6ICcvbWF0dGVyL215VGFzaycsCiAgICAgICAgICB9LAogICAgICAgICAgewogICAgICAgICAgICBuYW1lOiAn5oiR55qE55Sz6K+3JywKICAgICAgICAgICAgaWNvbjogJ2ljb24td29kZXNoZW5xaW5nJywKICAgICAgICAgICAgaWNvbkNvbG9yOiAnI0Y2Qjg1QScsCiAgICAgICAgICAgIHBhdGg6ICcvbWF0dGVyL215UmVxdWVzdCcsCiAgICAgICAgICB9LAogICAgICAgICAgewogICAgICAgICAgICBuYW1lOiAn5oiR55qE5Lyg6ZiFJywKICAgICAgICAgICAgaWNvbjogJ2ljb24td29kZWNodWFueXVlJywKICAgICAgICAgICAgaWNvbkNvbG9yOiAnIzg1NTBFMScsCiAgICAgICAgICAgIHBhdGg6ICcvbWF0dGVyL2NpcmN1bGF0ZU1hdHRlcicsCiAgICAgICAgICB9LAogICAgICAgICAgewogICAgICAgICAgICBuYW1lOiAn5oiR55qE6L2s5YqeJywKICAgICAgICAgICAgaWNvbjogJ2ljb24td29kZXpodWFuYmFuJywKICAgICAgICAgICAgaWNvbkNvbG9yOiAnI0ZGOEE0NicsCiAgICAgICAgICAgIHBhdGg6ICcvbWF0dGVyL215RGVsZWdhdGUnLAogICAgICAgICAgfSwKICAgICAgICBdLAogICAgICB9CiAgIH0sCiAgICAgbWV0aG9kczogewogICAgICBoYW5kbGVDbGljayhpdGVtKSB7CiAgICAgICAgaWYgKGl0ZW0ucGF0aCkgewogICAgICAgICAgdGhpcy4kcm91dGVyLnB1c2goaXRlbS5wYXRoKQogICAgICAgIH0KICAgICAgfSwKICAgIH0sCn0=', '', 0, '1654381902993375232', 'Lm1vYmlsZS1hcHBseS1jYXJkIHsKICBiYWNrZ3JvdW5kOiAjZmZmOwp9CgoubW9iaWxlLWFwcGx5LWNhcmQtLWNvbnRlbnR7CiAgIGRpc3BsYXk6IGZsZXg7CiAgIGZsZXgtd3JhcDogd3JhcDsKICAgcGFkZGluZy10b3A6IDE2cHg7Cn0KLm1vYmlsZS1hcHBseS1jYXJkLS1jb250ZW50IC5tb2JpbGUtYXBwbHktY2FyZC0taXRlbXsKICAgIHdpZHRoOiAyNSU7CiAgICBkaXNwbGF5OiBmbGV4OwogICAgdGV4dC1hbGlnbjogY2VudGVyOwogICAgZmxleC1kaXJlY3Rpb246IGNvbHVtbjsKICAgIGFsaWduLWl0ZW1zOiBjZW50ZXI7CiAgICBqdXN0aWZ5LWNvbnRlbnQ6IHNwYWNlLWFyb3VuZDsKICAgIGhlaWdodDogOTBweDsKICAgIG1hcmdpbi1ib3R0b206OHB4Owp9Ci5tb2JpbGUtYXBwbHktY2FyZC0tY29udGVudCAubW9iaWxlLWFwcGx5LWNhcmQtLWl0ZW0gLml0ZW0tdG9wLS1pY29uIHsKICB3aWR0aDogNDBweDsKICBoZWlnaHQ6IDQwcHg7CiAgZGlzcGxheTogZmxleDsKICBqdXN0aWZ5LWNvbnRlbnQ6IGNlbnRlcjsKICBhbGlnbi1pdGVtczogY2VudGVyOwogIGJvcmRlci1yYWRpdXM6IDhweDsKICBjb2xvcjogI2ZmZjsKfQoKLm1vYmlsZS1hcHBseS1jYXJkLS1jb250ZW50IC5tb2JpbGUtYXBwbHktY2FyZC0taXRlbSAuaXRlbS10b3AtLWljb24gLm1vYmlsZS1hcHBseS1pY29uIHsKICBmb250LXNpemU6IDI0cHg7Cn0KCi5tb2JpbGUtYXBwbHktY2FyZC0tY29udGVudCAubW9iaWxlLWFwcGx5LWNhcmQtLWl0ZW0gLm1vYmlsZS1pdGVtLWJvdHRvbS0tbmFtZSB7CiAgaGVpZ2h0OiAzMHB4OwogIGZvbnQtc2l6ZTogMTNweDsKICBjb2xvcjogIzMzMzsKICBwYWRkaW5nLXRvcDogOHB4OwogIHRleHQtYWxpZ246IGNlbnRlcjsKICBvdmVyZmxvdzogaGlkZGVuOwogIHRleHQtb3ZlcmZsb3c6IGVsbGlwc2lzOwogIGRpc3BsYXk6IC13ZWJraXQtYm94OwogIC13ZWJraXQtbGluZS1jbGFtcDogMjsKICAtd2Via2l0LWJveC1vcmllbnQ6IHZlcnRpY2FsOwp9');
-- 2023-05-08 lizhenxing 数据归档初始化脚本
INSERT INTO `bpm_documentation_config`(`ID_`, `DATA_KEY_`, `AUTORUN_`, `AUTORUN_CONFIG_`, `DELETE_DATA_`, `LIMIT_`, `LIMIT_NUMBER_`, `UPDATE_BY_`, `UPDATE_TIME_`, `BEFORE_MONTH_`, `JOB_NAME_`, `TENANT_ID_`) VALUES ('1', NULL, '1', '{\"type\":4,\"timeInterval\":\"MON,TUE,WED,SUN|11:49:20\"}', '2', '1', '500', '1', '2023-03-23 15:46:12', '0', '流程归档数据同步', '-1');
INSERT INTO `bpm_documentation_table`(`ID_`, `TABLE_NAME_`, `DML_`, `DDL_`, `SYSTEM_`, `START_`, `INFO_`, `ORDER_`, `UPDATE_BY_`, `PARENT_FIELD_`, `FIELD_`, `TIME_KEY_`, `PARENT_ID_`, `UPDATE_TIME_`, `TENANT_ID_`) VALUES ('1644250277726375936', 'bpm_pro_inst', '', 'CREATE TABLE `bpm_pro_inst` (\n `ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,\n `SUBJECT_` varchar(256) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,\n `PROC_DEF_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT \'流程定义ID\',\n `BPMN_DEF_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT \'BPMN流程定义ID\',\n `PROC_DEF_KEY_` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT \'流程定义Key\',\n `PROC_DEF_NAME_` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT \'流程名称\',\n `BIZ_KEY_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT \'业务主键\',\n `SYS_CODE_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT \'业务系统编码\',\n `FORM_KEY_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT \'绑定的表单主键\',\n `STATUS_` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT \'实例状态\',\n `END_TIME_` datetime(0) NULL DEFAULT NULL,\n `DURATION_` bigint(0) NULL DEFAULT NULL COMMENT \'持续时间(ms)\',\n `TYPE_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT \'所属分类ID\',\n `RESULT_TYPE_` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT \'流程结束后的最终审批结果,agree=同意;refuse=拒绝\',\n `BPMN_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT \'BPMN流程实例ID\',\n `CREATE_BY_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT \'创建人ID\',\n `CREATE_TIME_` datetime(0) NULL DEFAULT NULL,\n `CREATE_ORG_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT \'创建者所属组织ID\',\n `UPDATE_BY_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT \'更新人ID\',\n `UPDATE_TIME_` datetime(0) NULL DEFAULT NULL,\n `IS_FORMMAL_` char(1) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT \'是否正式数据\',\n `PARENT_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT \'父实例Id\',\n `IS_FORBIDDEN_` smallint(0) NULL DEFAULT NULL COMMENT \'禁止\',\n `DATA_MODE_` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT \'业务数据存储模式。\\r\\npk:主键\\r\\nbo:业务对象\',\n `CREATOR_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT \'创建人\',\n `SUPPORT_MOBILE_` int(0) NULL DEFAULT 0 COMMENT \'支持手机端\',\n `SUPER_NODE_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT \'子流程节点的ID\',\n `IS_DELE_` int(0) NOT NULL DEFAULT 0 COMMENT \'是否已删,1已删除,0未删除\',\n `URGENT_STATE_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT \'紧急状态\',\n `TENANT_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,\n `MOBILE_INST_URL_` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT \'手机端实例地址\',\n `PC_INST_URL_` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT \'pc端实例地址\',\n `CREATE_ORG_PATH_` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL,\n `CREATE_ACCOUNT_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT \'流程发起人账号\',\n PRIMARY KEY (`ID_`) USING BTREE,\n UNIQUE INDEX `IDX_PRO_INST_BPMNINSTID`(`BPMN_INST_ID_`) USING BTREE,\n INDEX `IDX_PRO_INST_PROCDEFKEY`(`PROC_DEF_KEY_`) USING BTREE,\n INDEX `IDX_PRO_INST_PROCDEFID`(`PROC_DEF_ID_`) USING BTREE\n) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = \'流程实例\' ROW_FORMAT = Dynamic;', '1', '1', NULL, '1', '1', NULL, NULL, 'UPDATE_TIME_', '0', '2023-04-14 10:04:31', '-1');
INSERT INTO `bpm_documentation_table`(`ID_`, `TABLE_NAME_`, `DML_`, `DDL_`, `SYSTEM_`, `START_`, `INFO_`, `ORDER_`, `UPDATE_BY_`, `PARENT_FIELD_`, `FIELD_`, `TIME_KEY_`, `PARENT_ID_`, `UPDATE_TIME_`, `TENANT_ID_`) VALUES ('1644251197944090624', 'bpm_bus_link', NULL, 'CREATE TABLE `bpm_bus_link` (\n `ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,\n `DEF_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT \'流程定义ID\',\n `PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT \'流程实例ID\',\n `BUSINESSKEY_` bigint(0) NULL DEFAULT NULL COMMENT \'业务键\',\n `BUSINESSKEY_STR_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT \'业务键字符型\',\n `SYS_CODE_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT \'业务系统编码\',\n `FORM_IDENTIFY_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT \'表单标识\',\n `START_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT \'发起人\',\n `STARTOR_` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT \'发起人\',\n `CREATE_DATE_` datetime(0) NULL DEFAULT NULL,\n `START_GROUP_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT \'发起组织ID\',\n `START_GROUP_` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT \'发起组织\',\n `IS_MAIN_` smallint(0) NULL DEFAULT NULL COMMENT \'主记录\',\n `BO_DEF_CODE_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT \'bodefcode数据\',\n `SAVE_MODE_` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT \'保存模式 (boObject,database)\',\n `TENANT_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,\n PRIMARY KEY (`ID_`) USING BTREE,\n INDEX `IDX_BUSLINK_INSTID`(`PROC_INST_ID_`) USING BTREE,\n INDEX `IDX_BUSLINK_BUSINESSKEY`(`BUSINESSKEY_STR_`) USING BTREE\n) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = \'流程实例与业务数据关系表,每一条记录对应业务的物理表,属于物理表的额外属性\' ROW_FORMAT = Dynamic;\n', '1', '0', NULL, '1', '1', 'id_', 'PROC_INST_ID_', NULL, '1644250277726375936', '2023-04-07 16:10:09', '-1');
INSERT INTO `bpm_documentation_table`(`ID_`, `TABLE_NAME_`, `DML_`, `DDL_`, `SYSTEM_`, `START_`, `INFO_`, `ORDER_`, `UPDATE_BY_`, `PARENT_FIELD_`, `FIELD_`, `TIME_KEY_`, `PARENT_ID_`, `UPDATE_TIME_`, `TENANT_ID_`) VALUES ('1644251940189097984', 'bpm_pro_status', NULL, 'CREATE TABLE `bpm_pro_status` (\n `ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,\n `PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT \'流程实例ID\',\n `PROC_DEF_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT \'ACT流程定义ID\',\n `NODE_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT \'节点ID\',\n `NODE_NAME_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT \'节点名称\',\n `STATUS_` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT \'状态\',\n `LAST_UPDATE_` datetime(0) NULL DEFAULT NULL,\n `LAST_USERID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT \'最后更新人\',\n `TENANT_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,\n `RECYCLE_NODE_` varchar(2) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT \'驳回按流程图执行回收的节点 0默认值 1因为驳回按照流程图执行目标节点之后的节点为1,如果重新运行到该节点变为0\',\n PRIMARY KEY (`ID_`) USING BTREE,\n INDEX `IDX_PROSTATUS_INSTID`(`PROC_INST_ID_`) USING BTREE,\n INDEX `IDX_PROSTATUS_NODEID`(`NODE_ID_`) USING BTREE\n) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = \'流程节点审批状态\' ROW_FORMAT = Dynamic;', '1', '0', NULL, '2', '1', 'id_', 'PROC_INST_ID_', NULL, '1644250277726375936', '2023-04-07 16:13:06', '-1');
INSERT INTO `bpm_documentation_table`(`ID_`, `TABLE_NAME_`, `DML_`, `DDL_`, `SYSTEM_`, `START_`, `INFO_`, `ORDER_`, `UPDATE_BY_`, `PARENT_FIELD_`, `FIELD_`, `TIME_KEY_`, `PARENT_ID_`, `UPDATE_TIME_`, `TENANT_ID_`) VALUES ('1644252316812431360', 'bpm_check_opinion', NULL, 'CREATE TABLE `bpm_check_opinion` (\n `ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,\n `PROC_DEF_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT \'流程定义ID\',\n `SUP_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT \'父流程实例ID\',\n `PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT \'流程实例ID\',\n `TASK_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT \'任务ID\',\n `TASK_KEY_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT \'任务定义Key\',\n `TASK_NAME_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT \'任务名称\',\n `TOKEN_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT \'任务令牌\',\n `QUALFIEDS_` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT \'有审批资格用户ID串\',\n `QUALFIED_NAMES_` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT \'有审批资格用户名称串\',\n `AUDITOR_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT \'执行人ID\',\n `AUDITOR_NAME_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT \'执行人名\',\n `ORG_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT \'组织ID\',\n `ORG_PATH_` varchar(600) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT \'组织全路径\',\n `OPINION_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT \'审批意见\',\n `STATUS_` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT \'审批状态。start=发起流程;awaiting_check=待审批;agree=同意;against=反对;return=驳回;abandon=弃权;retrieve=追回\',\n `FORM_DEF_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT \'表单定义ID\',\n `FORM_NAME_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT \'表单名\',\n `CREATE_TIME_` datetime(0) NULL DEFAULT NULL,\n `ASSIGN_TIME_` datetime(0) NULL DEFAULT NULL,\n `COMPLETE_TIME_` datetime(0) NULL DEFAULT NULL,\n `DUR_MS_` bigint(0) NULL DEFAULT NULL,\n `FILES_` varchar(4000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT \'附件\',\n `INTERPOSE_` smallint(0) NULL DEFAULT NULL COMMENT \'是否干预\',\n `IS_DELE_` int(0) NOT NULL DEFAULT 0 COMMENT \'是否已删,1已删除,0未删除\',\n `IS_READ_` int(0) NOT NULL DEFAULT 0 COMMENT \'0:待阅,1:已阅\',\n `AGENT_LEADER_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT \'被代理的领导人id\',\n `PROP1_` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT \'扩展属性1\',\n `PROP2_` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT \'扩展属性2\',\n `PROP3_` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT \'扩展属性3\',\n `PROP4_` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT \'扩展属性4\',\n `PROP5_` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT \'扩展属性5\',\n `PROP6_` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT \'扩展属性6\',\n `Z_FILES_` varchar(1000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT \'正文附件\',\n `FORM_DATA_` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL,\n `PARENT_TASK_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT \'父任务id\',\n `SIGN_TYPE_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT \'任务类型\',\n `SKIP_TYPE_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT \'跳过类型 启动跳过 审批跳过 执行人为空跳过 相同执行人跳过\',\n `TENANT_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,\n `QUALFIEDS_ACCOUNT_` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT \'有审批资格用户帐号串\',\n `AUDITOR_ACCOUNT_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT \'实际审判人\',\n `VARS_` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT \'流程变量\',\n PRIMARY KEY (`ID_`) USING BTREE,\n INDEX `IDX_OPINION_AUDITOR`(`AUDITOR_`) USING BTREE,\n INDEX `IDX_OPINION_INSTID`(`PROC_INST_ID_`) USING BTREE,\n INDEX `IDX_OPINION_TASK`(`TASK_ID_`) USING BTREE,\n INDEX `IDX_CHECKOPINION_SUPINSTID`(`SUP_INST_ID_`) USING BTREE\n) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = \'流程审批意见\' ROW_FORMAT = Dynamic;\n', '1', '0', NULL, '3', '1', 'id_', 'proc_inst_id_', NULL, '1644250277726375936', '2023-04-07 16:15:43', '-1');
INSERT INTO `bpm_documentation_table`(`ID_`, `TABLE_NAME_`, `DML_`, `DDL_`, `SYSTEM_`, `START_`, `INFO_`, `ORDER_`, `UPDATE_BY_`, `PARENT_FIELD_`, `FIELD_`, `TIME_KEY_`, `PARENT_ID_`, `UPDATE_TIME_`, `TENANT_ID_`) VALUES ('1644253067093725184', 'bpm_exe_stack', NULL, 'CREATE TABLE `bpm_exe_stack` (\n `ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,\n `PRCO_DEF_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT \'流程定义ID\',\n `NODE_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT \'节点ID\',\n `NODE_NAME_` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT \'节点名\',\n `START_TIME_` datetime(0) NULL DEFAULT NULL,\n `END_TIME` datetime(0) NULL DEFAULT NULL,\n `IS_MULITI_TASK_` smallint(0) NOT NULL COMMENT \'多实例任务\\r\\n1=是\\r\\n0=否\',\n `PARENT_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT \'父ID\',\n `PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT \'流程实例ID\',\n `NODE_PATH_` varchar(1024) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT \'节点路径\\r\\n格式如:\\r\\n0.1.2.\\r\\n其中2则为本行记录的主键值\',\n `DEPTH_` smallint(0) NULL DEFAULT NULL COMMENT \'节点层\',\n `TASK_TOKEN_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT \'是针对分发任务时,携带的令牌,方便查找其父任务堆栈\',\n `NODE_TYPE_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT \'节点类型\',\n `TARGET_NODE_` varchar(200) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT \'驳回时返回节点\',\n `TARGET_TOKEN_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,\n `INTERPOSE_` smallint(0) NULL DEFAULT NULL COMMENT \'是否干预执行\',\n `TENANT_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,\n PRIMARY KEY (`ID_`) USING BTREE,\n INDEX `IDX_EXESTACK_INSTID`(`PROC_INST_ID_`) USING BTREE\n) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = \'流程执行堆栈树\' ROW_FORMAT = Dynamic;', '1', '0', NULL, '4', '1', 'id_', 'PROC_INST_ID_', NULL, '1644250277726375936', '2023-04-14 10:04:54', '-1');
INSERT INTO `bpm_documentation_table`(`ID_`, `TABLE_NAME_`, `DML_`, `DDL_`, `SYSTEM_`, `START_`, `INFO_`, `ORDER_`, `UPDATE_BY_`, `PARENT_FIELD_`, `FIELD_`, `TIME_KEY_`, `PARENT_ID_`, `UPDATE_TIME_`, `TENANT_ID_`) VALUES ('1644254426346016768', 'bpm_flow_mq_log', NULL, 'CREATE TABLE `bpm_flow_mq_log` (\n `ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT \'主键\',\n `TYPE_` varchar(40) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT \'类型\',\n `TITLE_` varchar(300) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT \'标题\',\n `CONTENT_` text CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT \'内容\',\n `STATUS_` int(0) NOT NULL COMMENT \'状态\',\n `TRY_TIME_` int(0) NULL DEFAULT NULL COMMENT \'重试次数\',\n `EXCEPTION_` varchar(2000) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT \'异常信息\',\n `LOG_TIME_` datetime(0) NULL DEFAULT NULL COMMENT \'日志记录时间\',\n `TARGET_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT \'日志目标类型\',\n `PROC_INST_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT \'实例ID\',\n `TASK_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT \'任务ID\',\n `OWNER_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT \'任务所属人id\',\n `OWNER_NAME_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT \'任务所属人姓名\',\n `TENANT_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT \'租户id\',\n `YEARS_PARTITION_` int(0) NULL DEFAULT NULL COMMENT \'日志所属年份\',\n PRIMARY KEY (`ID_`) USING BTREE,\n INDEX `IDX_YEARS_PARTITION_`(`YEARS_PARTITION_`) USING BTREE,\n INDEX `IDX_PROC_INST_ID_`(`PROC_INST_ID_`) USING BTREE,\n INDEX `idx_bpm_flow_message_type`(`TYPE_`) USING BTREE\n) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = \'统一待办推送日志\' ROW_FORMAT = Dynamic;', '1', '0', NULL, '5', '1', 'id_', 'PROC_INST_ID_', NULL, '1644250277726375936', '2023-04-07 16:23:10', '-1');
INSERT INTO `bpm_documentation_table`(`ID_`, `TABLE_NAME_`, `DML_`, `DDL_`, `SYSTEM_`, `START_`, `INFO_`, `ORDER_`, `UPDATE_BY_`, `PARENT_FIELD_`, `FIELD_`, `TIME_KEY_`, `PARENT_ID_`, `UPDATE_TIME_`, `TENANT_ID_`) VALUES ('1644254843394052096', 'bpm_read_record', NULL, 'CREATE TABLE `bpm_read_record` (\n `ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,\n `PROC_DEF_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT \'流程定义ID\',\n `SUP_INST_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT \'父流程实例ID\',\n `PROC_INST_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT \'流程实例ID\',\n `TASK_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT \'任务ID\',\n `TASK_KEY_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT \'任务定义Key\',\n `TASK_NAME_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT \'任务名称\',\n `READER_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT \'阅读人ID\',\n `READER_NAME_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT \'阅读人名\',\n `READ_TIME_` datetime(0) NULL DEFAULT NULL,\n `ORG_ID_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT \'组织id\',\n `ORG_PATH_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT \'组织名称\',\n `TENANT_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,\n PRIMARY KEY (`ID_`) USING BTREE,\n INDEX `IDX_READRECORD_PROCINSTID`(`PROC_INST_ID_`) USING BTREE,\n INDEX `IDX_READRECORD_TASKID`(`TASK_ID_`) USING BTREE,\n INDEX `IDX_READRECORD_TASKKEY`(`TASK_KEY_`) USING BTREE\n) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = \'任务阅读记录表\' ROW_FORMAT = Dynamic;', '1', '0', NULL, '6', '1', 'id_', 'PROC_INST_ID_', NULL, '1644250277726375936', '2023-04-07 16:24:59', '-1');
INSERT INTO `bpm_documentation_table`(`ID_`, `TABLE_NAME_`, `DML_`, `DDL_`, `SYSTEM_`, `START_`, `INFO_`, `ORDER_`, `UPDATE_BY_`, `PARENT_FIELD_`, `FIELD_`, `TIME_KEY_`, `PARENT_ID_`, `UPDATE_TIME_`, `TENANT_ID_`) VALUES ('1644272017298935808', 'bpm_exe_stack_executor', NULL, 'CREATE TABLE `bpm_exe_stack_executor` (\n `ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,\n `STACK_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT \'堆栈ID\',\n `TASK_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT \'任务ID\',\n `ASSIGNEE_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT \'执行人\',\n `CREATE_TIME_` datetime(0) NULL DEFAULT NULL,\n `END_TIME_` datetime(0) NULL DEFAULT NULL,\n `STATUS_` smallint(0) NULL DEFAULT NULL COMMENT \'状态(0,初始,1,完成,2,取消)\',\n `TENANT_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,\n `TARGET_NODE_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT \'目标节点\',\n PRIMARY KEY (`ID_`) USING BTREE,\n INDEX `IDX_STACKEXECUTOR_STACKID`(`STACK_ID_`) USING BTREE,\n INDEX `IDX_STACKEXECUTOR_TASKID`(`TASK_ID_`) USING BTREE\n) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = \'堆栈执行人\' ROW_FORMAT = Dynamic;', NULL, '0', NULL, '7', '1', 'id_', 'STACK_ID_', '', '1644253067093725184', '2023-04-14 10:05:07', '-1');
-- 2023-05-08 liangjc 数据视图增加移动端数据模板别名、移动端数据模板代码字段
alter table form_data_template add column MOBILE_TEMPLATE_ALIAS_ varchar(128) DEFAULT NULL COMMENT '移动端数据模板别名' AFTER TEMPLATE_HTML_ ;
alter table form_data_template add column MOBILE_TEMPLATE_HTML_ LONGTEXT DEFAULT NULL COMMENT '移动端数据模板代码' AFTER MOBILE_TEMPLATE_ALIAS_ ;
-- 2023-05-06 qiuxd pc应用菜单添加类型
ALTER TABLE `portal_sys_app` ADD COLUMN `ALIAS_` varchar(64) NULL COMMENT '应用别名' AFTER `NAME_`;
ALTER TABLE `portal_sys_app_menu` ADD COLUMN `MENU_TYPE_` varchar(64) NULL COMMENT '菜单类型' AFTER `TYPE_`;
ALTER TABLE `portal_sys_app_menu` ADD COLUMN `ICON_` varchar(64) NULL COMMENT '图标' AFTER `MENU_TYPE_`;
ALTER TABLE `portal_sys_app_menu` MODIFY `SN_` int not null COMMENT '排序';
-- 2023-05-10 jjx 修改PC模块菜单别名
UPDATE PORTAL_SYS_MENU SET ALIAS_ = 'pcAppCenter' WHERE ID_ LIKE '1296282423985836032';
-- 2023年5月12日14:51:47 huangtp 新增流程实例或者流程任务查阅记录表
create table bpm_show_record
(
id_ varchar(32) not null comment '主键id'
primary key,
account_ varchar(32) not null comment '查阅人账号',
full_name_ varchar(32) not null comment '查阅人名称',
show_time_ datetime not null comment '查阅时间',
task_id_ varchar(32) null comment '流程实例id或者任务id',
action_ varchar(32) null comment '流程定义中的动作:发布新版本/保存',
show_type_ varchar(20) null comment '展示类型:实例/任务/流程定义',
reasons_ text not null comment '查阅原因',
create_by_ varchar(32) null comment '创建人',
create_time_ datetime null comment '创建时间',
create_org_id_ varchar(32) null,
update_by_ varchar(32) null comment '更新人',
update_time_ datetime null comment '更新时间',
tenant_id_ varchar(32) null comment '租户id'
)
comment '流程实例和流程任务查阅记录';
create index show_record_task_id__show_type__index
on bpm_show_record (task_id_, show_type_);
UPDATE PORTAL_SYS_MENU SET ALIAS_ = 'pcAppCenter' WHERE ID_ LIKE '1296282423985836032';
-- 2023-05-12 yijj 增加手机端自定义门户权限初始化数据
INSERT INTO `portal_sys_auth_user`(`ID_`, `AUTHORIZE_ID_`, `OWNER_ID_`, `OWNER_NAME_`, `RIGHT_TYPE_`, `OBJ_TYPE_`, `TENANT_ID_`) VALUES ('1656920738508091392', '1651467475169812480', NULL, NULL, 'everyone', 'indexColumn', '-1');
INSERT INTO `portal_sys_auth_user`(`ID_`, `AUTHORIZE_ID_`, `OWNER_ID_`, `OWNER_NAME_`, `RIGHT_TYPE_`, `OBJ_TYPE_`, `TENANT_ID_`) VALUES ('1656921529427996672', '1651134508916514816', NULL, NULL, 'everyone', 'indexColumn', '-1');
INSERT INTO `portal_sys_auth_user`(`ID_`, `AUTHORIZE_ID_`, `OWNER_ID_`, `OWNER_NAME_`, `RIGHT_TYPE_`, `OBJ_TYPE_`, `TENANT_ID_`) VALUES ('1656921540433850368', '1651056986864828416', NULL, NULL, 'everyone', 'indexColumn', '-1');
-- 2023-05-15 欧阳高龙 调整流程定义版本管理-发布说明
ALTER TABLE `bpm_definition`
ADD COLUMN `DEPLOY_DESC_` varchar(500) DEFAULT NULL COMMENT '发布说明';
-- 2023-05-17 wanghb 表单列表新增字段
ALTER TABLE `form_data_template`
ADD COLUMN `INNER_BTN_CONFIG_` longtext NULL COMMENT '页内按钮的配置' ;
-- 2023-05-18 liangjc 流程公示阅读记录表
CREATE TABLE bpm_pro_publicity_read (
ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
PROC_INST_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '实例id',
USER_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '用户id',
TENANT_ID_ varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL,
PRIMARY KEY (ID_) USING BTREE,
KEY PROC_INST_ID_ (PROC_INST_ID_) USING BTREE,
KEY IDX_USER_ID (USER_ID_) USING BTREE
) ENGINE=InnoDB ROW_FORMAT=DYNAMIC COMMENT='流程公示阅读记录';
-- 2023-05-19 JJX 添加流程归档菜单
INSERT INTO `portal_sys_menu`(`ID_`, `PARENT_ID_`, `NAME_`, `ALIAS_`, `ACTIVE_TAB_`, `MENU_ICON_`, `OPENED_`, `SN_`, `TABS_STYLE_`, `PATH_`, `HREF_`, `TENANT_ID_`, `ROUTE_EXTEND_`, `TYPE_`, `IS_REFRESH_`, `token_Enabled_`, `TOKEN_TYPE_`, `TOKEN_KEY_`, `TOKEN_API_`) VALUES ('1643794670103810048', '4291768', '流程归档', 'historyDataConfig', '', '', NULL, 7, '', '-1.1.3641025.4291768.1643794670103810048.', '', '-1', '{\"path\":\"historyDataConfig\",\"component\":\"MultilevelMenuLayout\",\"redirect\":\"\",\"alwaysShow\":true,\"caseSensitive\":false,\"meta\":{\"title\":\"流程归档\",\"icon\":\"\",\"isChildren\":true}}', 'catalog', 1, 0, 0, NULL, NULL);
-- 2023-05-22 删除移动端流程分类菜单
delete from portal_sys_menu where NAME_ = '移动端流程分类';
-- 2023-05-22 lizhenxing 流程归档定时任务初始数据
INSERT INTO `qrtz_job_details`(`SCHED_NAME`, `JOB_NAME`, `JOB_GROUP`, `DESCRIPTION`, `JOB_CLASS_NAME`, `IS_DURABLE`, `IS_NONCONCURRENT`, `IS_UPDATE_DATA`, `REQUESTS_RECOVERY`, `JOB_DATA`) VALUES ('quartzScheduler', '数据归档定时任务', '-1', '数据归档定时任务', 'com.hotent.job.job.DocumentationJob', '1', '1', '0', '0', 0xACED0005737200156F72672E71756172747A2E4A6F62446174614D61709FB083E8BFA9B0CB020000787200266F72672E71756172747A2E7574696C732E537472696E674B65794469727479466C61674D61708208E8C3FBC55D280200015A0013616C6C6F77735472616E7369656E74446174617872001D6F72672E71756172747A2E7574696C732E4469727479466C61674D617013E62EAD28760ACE0200025A000564697274794C00036D617074000F4C6A6176612F7574696C2F4D61703B787000737200116A6176612E7574696C2E486173684D61700507DAC1C31660D103000246000A6C6F6164466163746F724900097468726573686F6C6478703F40000000000010770800000010000000007800);
-- 2023-05-25 liangjc 维度管理菜单置空tabs_style_
update portal_sys_menu set tabs_style_='' where alias_='demension';
-- 2023-05-26 wanghb 新增表单资源授权的相关表
CREATE TABLE `form_authorize` (
`ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`AUTHORIZE_DESC_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '授权说明',
`CREATE_BY_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人ID',
`CREATOR_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '创建人',
`CREATE_TIME_` datetime(0) NULL DEFAULT NULL,
`MULTI_PLE` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`TENANT_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`AUTHORIZE_MODEL_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '授权对象',
PRIMARY KEY (`ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '表单模块相关授权主表' ROW_FORMAT = DYNAMIC;
CREATE TABLE `form_authorize_act` (
`ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`AUTHORIZE_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '授权主表ID',
`MODEL_KEY_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '授权KEY',
`MODEL_NAME_` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '授权名称',
`RIGHT_CONTENT_` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '授权内容',
`TYPE_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '1,对象。2,对象分类',
`TENANT_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
PRIMARY KEY (`ID_`) USING BTREE,
INDEX `IDX_AUTHDEF_AUTHID`(`AUTHORIZE_ID_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '表单相关授权定义' ROW_FORMAT = DYNAMIC;
CREATE TABLE `form_authorize_user` (
`ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL,
`AUTHORIZE_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '流程授权主表ID',
`OWNER_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '授权对象ID',
`OWNER_NAME_` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '授权对象名称',
`RIGHT_TYPE_` varchar(20) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '授权对象类型(角色,用户,岗位等)',
`OBJ_TYPE_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`AUTH_ORG_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`AUTH_ORG_NAME_` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`TENANT_ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
PRIMARY KEY (`ID_`) USING BTREE,
INDEX `IDX_DEFUSER_AUTHID`(`AUTHORIZE_ID_`) USING BTREE,
INDEX `IDX_DEFUSER_RIGHTTYPE`(`RIGHT_TYPE_`) USING BTREE,
INDEX `IDX_DEFUSER_OBJTYPE`(`OBJ_TYPE_`) USING BTREE
) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_general_ci COMMENT = '表单相关授权的用户' ROW_FORMAT = DYNAMIC;
INSERT INTO `portal_sys_menu`(`ID_`, `PARENT_ID_`, `NAME_`, `ALIAS_`, `ACTIVE_TAB_`, `MENU_ICON_`, `OPENED_`, `SN_`, `TABS_STYLE_`, `PATH_`, `HREF_`, `TENANT_ID_`, `ROUTE_EXTEND_`, `TYPE_`, `IS_REFRESH_`, `token_Enabled_`, `TOKEN_TYPE_`, `TOKEN_KEY_`, `TOKEN_API_`) VALUES ('1660521382890016768', '3391046', '资源授权', 'formAuthorizeManager', '', '', NULL, 6, '', '-1.1.3441002.3391046.1660521382890016768.', '', '-1', '{\"path\":\"formAuthorizeManager\",\"component\":\"\",\"redirect\":\"\",\"alwaysShow\":false,\"caseSensitive\":false,\"meta\":{\"title\":\"资源授权\",\"isChildren\":true,\"icon\":\"\"}}', 'catalog', 1, 0, 0, NULL, NULL);
-- 2023-06-01 yijj 更新常用功能和数据台初始化脚本
UPDATE `portal_sys_column` SET `NAME` = '常用功能', `ALIAS` = 'cygnsjd', `CATALOG` = NULL, `COL_TYPE` = 'HtCustom', `DATA_MODE` = NULL, `DATA_FROM` = NULL, `DS_ALIAS` = NULL, `DS_NAME` = NULL, `COL_HEIGHT` = NULL, `COL_URL` = '', `TEMPLATE_HTML` = 'PGRpdiBzdHlsZT0icGFkZGluZzoxNnB4IDAiPgogIDxkaXYgY2xhc3M9ImNvbW1vbi1mdW5jdGlvbiIgc3R5bGU9ImRpc3BsYXk6IGZsZXg7IGZsZXgtd3JhcDogd3JhcCI+CiAgICA8ZGl2CiAgICAgIGNsYXNzPSJtb2JpbGUtY3VzdG9tLWl0ZW0gaG92ZXItZm9sbG93LXRoZW1lLWNvbG9yIgogICAgICBvbmNsaWNrPSJ3aW5kb3cub3BlbignaHR0cDovL3d3dy5ob3RlbnQub3JnOjg4ODgvY2hhbnpoaS9pbmRleC5waHAvYm9vay91c2UxLzg3OC5odG1sJywnX2JsYW5rJykiCiAgICA+CiAgICAgIDxzdmcKICAgICAgICB0PSIxNjY0NTIzOTc1NDcxIgogICAgICAgIGNsYXNzPSJpY29uIgogICAgICAgIHZpZXdCb3g9IjAgMCAxMDI0IDEwMjQiCiAgICAgICAgdmVyc2lvbj0iMS4xIgogICAgICAgIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyIKICAgICAgICBwLWlkPSIxNjM1NiIKICAgICAgICB3aWR0aD0iMzIiCiAgICAgICAgaGVpZ2h0PSIzNiIKICAgICAgPgogICAgICAgIDxwYXRoCiAgICAgICAgICBkPSJNODE4LjAxODk4OCAwLjAwMDUzOUgxMDIuMzA1MzczYTc1LjE4NTA5NyA3NS4xODUwOTcgMCAwIDAtNzUuNDU0NTc4IDc0Ljk0MjU2NHY4MzIuNjk1MTU5YTc1LjIxMjA0NSA3NS4yMTIwNDUgMCAwIDAgNzUuNDU0NTc4IDc0Ljk2OTUxM2gzMjEuNDYzNDQ4bDQ2OS42MjM5MDEtNDY2LjkwMjE0N1Y3NC45NDMxMDNBNzUuMTU4MTQ5IDc1LjE1ODE0OSAwIDAgMCA4MTguMDE4OTg4IDAuMDAwNTM5ek00MTkuNTExMDI3IDY4Mi42NDg4ODFIMjI5Ljk1ODM0OWE0MC40MjIwOTUgNDAuNDIyMDk1IDAgMSAxIDAtODAuODQ0MTloMTg5LjU1MjY3OGE0MC40MjIwOTUgNDAuNDIyMDk1IDAgMSAxIDAgODAuODQ0MTl6IG0yNzAuNzc0MTQxLTE2Ni43ODE1NjRIMjI5Ljk4NTI5N2E0MC40MjIwOTUgNDAuNDIyMDk1IDAgMSAxIDAtODAuODQ0MTkxaDQ2MC4zMjY4MTlhNDAuNDIyMDk1IDQwLjQyMjA5NSAwIDEgMSAwIDgwLjg0NDE5MXogbTQwLjYzNzY3OS0yMTMuNDU1NjExYTQwLjQyMjA5NSA0MC40MjIwOTUgMCAwIDEtNDAuNjM3Njc5IDQwLjQyMjA5NkgyMjkuOTg1Mjk3YTQwLjQyMjA5NSA0MC40MjIwOTUgMCAwIDEtNDAuNjEwNzMyLTQwLjQyMjA5NiA0MC40MjIwOTUgNDAuNDIyMDk1IDAgMCAxIDQwLjYxMDczMi00MC40MjIwOTVoNDYwLjMyNjgxOWE0MC40MjIwOTUgNDAuNDIyMDk1IDAgMCAxIDQwLjYzNzY3OSA0MC40MjIwOTV6IgogICAgICAgICAgZmlsbD0iIzA3QzE2MCIKICAgICAgICAgIHAtaWQ9IjE2MzU3IgogICAgICAgID48L3BhdGg+CiAgICAgICAgPHBhdGgKICAgICAgICAgIGQ9Ik03MDUuMTYwNDk5IDc2Mi43OTI0MjFMNjYzLjE0ODQ2OCA4MDMuODYxMjdsLTM4Ljc3ODI2MyAzNy43MjcyODktMjkuMDUwMDEzIDI4LjI5NTQ2Ni0xNS4yNzk1NTIgMTQuNDcxMTFhODcuNjg4OTk4IDg3LjY4ODk5OCAwIDAgMC0xOC44NjM2NDQgMjUuNDkyODY4IDE4Mi4wMDcyMiAxODIuMDA3MjIgMCAwIDAtNi41MjE0MzEgMTcuMzgxNTAxbC04Ljg2NTkxMyAyNi4yNzQzNjItOC4wODQ0MTkgMjcuMjcxNDRjLTEuODA1NTIgNi42MDIyNzYtMy4zMTQ2MTIgMTMuMjg1Mzk1LTQuNjM1MDY3IDE5Ljk5NTQ2M2EyMy41Nzk1NTUgMjMuNTc5NTU1IDAgMCAwIDIuMjA5NzQxIDE5LjA3OTIyOWMzLjIzMzc2OCAzLjY5MTg4NSA5LjI0MzE4NiA0Ljg3NzU5OSAxOS4xMDYxNzcgMy42OTE4ODVhMTg5LjkyOTk1MSAxODkuOTI5OTUxIDAgMCAwIDIwLjgwMzkwNS00Ljk4NTM5MiAyNTYuNDkxNjY3IDI1Ni40OTE2NjcgMCAwIDAgMjkuNjQyODctNy44MTQ5MzhjMTAuMTU5NDItMi42OTQ4MDYgMTkuODg3NjcxLTYuMzg2NjkxIDI5LjkzOTI5OC05LjQ4NTcxOWwyNC40MTQ5NDYtMTAuOTk0ODA5IDEzLjg3ODI1Mi04LjA4NDQxOSAxMi44NTQyMjctOS40ODU3MTkgMzkuODAyMjg5LTM5LjE1NTUzNiAzOC45MTMwMDQtMzcuMjY5MTcyIDQxLjk4NTA4My00MC40MjIwOTUgMTEzLjc3NDcyMy0xMDguNzA4NDg3LTk4LjM4NzM3OS05NC41MDY4NTl6IG0yOTEuODQ3NTI2LTEwNC4yMDgxNjFhMTAzLjUwNzUxMiAxMDMuNTA3NTEyIDAgMCAwLTQuNjA4MTE4LTIyLjc3MTExMyA5Mi4zNTEwMTMgOTIuMzUxMDEzIDAgMCAwLTIwLjgwMzkwNS0yOS42NDI4NyA4MC40NjY5MTcgODAuNDY2OTE3IDAgMCAwLTI0LjkyNjk1OS0xOS41OTEyNDIgNjMuNjI0Mzc4IDYzLjYyNDM3OCAwIDAgMC0yNy4zNTIyODQtNy4xOTUxMzMgMzcuNTM4NjUyIDM3LjUzODY1MiAwIDAgMC0zMC4wNDcwOTEgMTAuMzc1MDA0bC0xNC43Njc1MzkgMTIuMzE1MjY1YTE4Ny4wNDY1MDggMTg3LjA0NjUwOCAwIDAgMS0xNS41NzU5OCAxMy42NjI2NjlsOTkuMzg0NDU3IDk0LjUzMzgwNmE1NC40ODg5ODQgNTQuNDg4OTg0IDAgMCAwIDguMjQ2MTA4LTYuNzkwOTEybDguMjQ2MTA3LTguNzA0MjI1IDEwLjUzNjY5My0xMC4zNzUwMDRhMzIuOTg0NDMgMzIuOTg0NDMgMCAwIDAgMTEuNjk1NDU5LTI1LjgxNjI0NXoiCiAgICAgICAgICBmaWxsPSIjMDdDMTYwN0EiCiAgICAgICAgICBwLWlkPSIxNjM1OCIKICAgICAgICA+PC9wYXRoPgogICAgICA8L3N2Zz4KICAgICAgPHNwYW4+5bel5pe255m76K6wPC9zcGFuPgogICAgPC9kaXY+CiAgICA8ZGl2CiAgICAgIGNsYXNzPSJtb2JpbGUtY3VzdG9tLWl0ZW0iCiAgICAgIG9uY2xpY2s9IndpbmRvdy5vcGVuKCdodHRwOi8vd3d3LmhvdGVudC5vcmc6ODg4OC9jaGFuemhpL2luZGV4LnBocC9ib29rL3VzZTEvODgwLmh0bWwnLCdfYmxhbmsnKSIKICAgID4KICAgICAgPHN2ZwogICAgICAgIHQ9IjE2NjQ1MjQ0MTY4NTMiCiAgICAgICAgY2xhc3M9Imljb24iCiAgICAgICAgdmlld0JveD0iMCAwIDExMzcgMTAyNCIKICAgICAgICB2ZXJzaW9uPSIxLjEiCiAgICAgICAgeG1sbnM9Imh0dHA6Ly93d3cudzMub3JnLzIwMDAvc3ZnIgogICAgICAgIHAtaWQ9IjE2NDkyIgogICAgICAgIHdpZHRoPSIzMiIKICAgICAgICBoZWlnaHQ9IjM2IgogICAgICA+CiAgICAgICAgPHBhdGgKICAgICAgICAgIGQ9Ik04NjYuMDE4MTcgNTgxLjI0MjIwMmExMDkuMDgwNjg3IDEwOS4wODA2ODcgMCAwIDEgNS45NzMxMjggMzMuMTM2NjM2djEwMi4zOTY0NzNhMTAzLjY3NjQyOSAxMDMuNjc2NDI5IDAgMCAxLTEwNC41Mjk3MzMgMTAyLjM5NjQ3M2gtMTA3LjUxNjI5NmExMDEuNzk5MTYgMTAxLjc5OTE2IDAgMCAxLTEwNC41Mjk3MzMtMTAyLjM5NjQ3M3YtMTAyLjM5NjQ3M2ExMjkuMDQ3OTk5IDEyOS4wNDc5OTkgMCAwIDEgNS45NzMxMjctMzMuMTM2NjM2Yy0xNTguMjU5NDM4IDQyLjE1MzIxNS0yNjguNzYyMjk4IDE0NC41NDk2ODgtMjY4Ljc2MjI5OCAyNjIuMDIxMTk3VjkyMS41NjgyNTdhMTAzLjY3NjQyOSAxMDMuNjc2NDI5IDAgMCAwIDEwNC41Mjk3MzMgMTAyLjM5NjQ3M2g2MzYuMDgxMjAyYTEwMS43OTkxNiAxMDEuNzk5MTYgMCAwIDAgMTA0LjUyOTczMi0xMDIuMzk2NDczdi03OC4zMDQ4NThjLTIuODQ0MzQ2LTExNy40NDMwNjYtMTEzLjQ4OTQyNC0yMTkuODM5NTM5LTI3MS43NDg4NjItMjYyLjAyMTE5N3pNNzEwLjc3Mzc0IDYxNC4zNzg4MzhhNTMuMTg5Mjc5IDUzLjE4OTI3OSAwIDAgMC01My43NTgxNDggNTEuMTk4MjM3djUxLjE5ODIzNmE1My44MTUwMzUgNTMuODE1MDM1IDAgMCAwIDEwNy41MTYyOTYgMHYtNTEuMTk4MjM2YTUwLjA4ODk0MSA1MC4wODg5NDEgMCAwIDAtMTQuOTMyODE5LTM2LjE1MTY0NCA1Ni41MTcxNjQgNTYuNTE3MTY0IDAgMCAwLTM4LjgyNTMyOS0xNS4wNDY1OTN6IG0wLTUxLjE5ODIzNmEyNzQuMTk1IDI3NC4xOTUgMCAwIDAgMjY1Ljc3NTczNC0yODAuMDgyNzk4YzAtMTUzLjU5NDcxLTExNi40NzU5ODgtMjgzLjA5NzgwNC0yNjIuNzg5MTctMjgzLjA5NzgwNFM0NDcuOTg0NTY5IDEyNi40ODgwODggNDQ3Ljk4NDU2OSAyODMuMDk3ODA0czExOS40MDU2NjUgMjgwLjA4Mjc5NyAyNjIuNzg5MTcxIDI4MC4wODI3OTh6IgogICAgICAgICAgZmlsbD0iI0ZFOUM1NCIKICAgICAgICAgIHAtaWQ9IjE2NDkzIgogICAgICAgID48L3BhdGg+CiAgICAgICAgPHBhdGgKICAgICAgICAgIGQ9Ik0xNzMuMTkyMjU3IDkxMy40NjE4N2ExMDIuNjUyNDY0IDEwMi42NTI0NjQgMCAwIDEtMTQuOTMyODE5LTUxLjM0MDQ1NHYtNzguNTMyNDA2YzAtMTExLjc1NDM3MyAxMDQuNTI5NzMzLTIxMS40MjAyNzMgMjU5LjgwMjYwNy0yNTYuNzAyMjY5YTI5OS44Nzk0NDkgMjk5Ljg3OTQ0OSAwIDAgMS05OC41NTY2MDYtMjI5LjUzODc2MUEzNDUuOTI5NDE4IDM0NS45Mjk0MTggMCAwIDEgMzU4LjM4NzY1NiAxNDMuMzI2NjE5YTIyNC4wMjA3MjggMjI0LjAyMDcyOCAwIDAgMC0xOTcuMDg0NzY4IDIyOS41Mzg3NiAyMzUuNTY4Nzc1IDIzNS41Njg3NzUgMCAwIDAgOTIuNTgzNDc4IDE5MC4yNTgzMzZDMTA3LjUxNjI5NyA1OTMuMzMwNjc0IDAgNjgwLjkwODEwMiAwIDc4MC40NjAyMjlWODU4Ljk5MjYzNWE1My4yNDYxNjYgNTMuMjQ2MTY2IDAgMCAwIDUzLjc1ODE0OCA1MS40NTQyMjd6IgogICAgICAgICAgZmlsbD0iI0ZGQzI5NSIKICAgICAgICAgIHAtaWQ9IjE2NDk0IgogICAgICAgID48L3BhdGg+CiAgICAgIDwvc3ZnPgogICAgICA8c3Bhbj7mlrDlu7rlrqLmiLc8L3NwYW4+CiAgICA8L2Rpdj4KICAgIDxkaXYKICAgICAgY2xhc3M9Im1vYmlsZS1jdXN0b20taXRlbSIKICAgICAgb25jbGljaz0id2luZG93Lm9wZW4oJ2h0dHA6Ly93d3cuaG90ZW50Lm9yZzo4ODg4L2NoYW56aGkvaW5kZXgucGhwL2Jvb2svdXNlMS84NzkuaHRtbCcsJ19ibGFuaycpIgogICAgPgogICAgICA8c3ZnCiAgICAgICAgdD0iMTY2NDUyNDQ0OTUyNyIKICAgICAgICBjbGFzcz0iaWNvbiIKICAgICAgICB2aWV3Qm94PSIwIDAgMTAyNCAxMDI0IgogICAgICAgIHZlcnNpb249IjEuMSIKICAgICAgICB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciCiAgICAgICAgcC1pZD0iMTY2MjgiCiAgICAgICAgd2lkdGg9IjMyIgogICAgICAgIGhlaWdodD0iMzYiCiAgICAgID4KICAgICAgICA8cGF0aAogICAgICAgICAgZD0iTTQ5OC40MTAyNjMgODIxLjg1Njg1NGEyNjkuNDUyMzQxIDI2OS40NTIzNDEgMCAwIDEgNDE4LjY3NTA0Ny0yMjQuMjkyMTI4VjI2MS40NDk4NzZhMTIyLjI1MDUyNyAxMjIuMjUwNTI3IDAgMCAwLTMwLjA3MDg4MS02NC45MzgwMTRMNzEzLjY3NTczOCAyNS42MjUxODdBMTAxLjY2NDM2OCAxMDEuNjY0MzY4IDAgMCAwIDY0Ni40NDczNzkgMC4wMDAyNjloLTUxNC42NTM5N0E3Ny41NDgzODQgNzcuNTQ4Mzg0IDAgMCAwIDUzLjk3NTU3MyA3Ni45MDE5Njh2ODMwLjk5MTAxOGE3My4wMjE1ODQgNzMuMDIxNTg0IDAgMCAwIDczLjAyMTU4NCA3My4wMjE1ODVoNDIzLjg0ODUzMmEyNjcuNzU0NzkxIDI2Ny43NTQ3OTEgMCAwIDEtNTIuNDM1NDI2LTE1OS4wNTc3MTd6TTI1Ni40MTUxMTYgMjYwLjg4NDAyNmg0NTguMDY4OTc5YTQwLjQxNzg1MSA0MC40MTc4NTEgMCAwIDEgMCA4MC44MzU3MDJoLTQ1OC4wNjg5NzlhNDAuNDE3ODUxIDQwLjQxNzg1MSAwIDAgMSAwLTgwLjgzNTcwMnogbTAgMTczLjIzMDkxaDQ1OC4wNjg5NzlhNDAuNDE3ODUxIDQwLjQxNzg1MSAwIDEgMSAwIDgwLjgzNTcwMmgtNDU4LjA2ODk3OWE0MC40MTc4NTEgNDAuNDE3ODUxIDAgMSAxIDAtODAuODM1NzAyeiBtMTg4LjYxNjYzOSAyNDcuNzA3NTM2aC0xODguNjE2NjM5YTQwLjQxNzg1MSA0MC40MTc4NTEgMCAxIDEgMC04MC44MzU3MDJoMTg4LjYxNjYzOWE0MC40MTc4NTEgNDAuNDE3ODUxIDAgMSAxIDAgODAuODM1NzAyeiIKICAgICAgICAgIGZpbGw9IiM0MDUzRkYiCiAgICAgICAgICBwLWlkPSIxNjYyOSIKICAgICAgICA+PC9wYXRoPgogICAgICAgIDxwYXRoCiAgICAgICAgICBkPSJNNzY3LjkxNjQ5NSA2MTkuODIxNDg5YTIwMi4wODkyNTYgMjAyLjA4OTI1NiAwIDEgMCAyMDIuMDg5MjU1IDIwMi4wODkyNTUgMjAyLjA4OTI1NiAyMDIuMDg5MjU2IDAgMCAwLTIwMi4wODkyNTUtMjAyLjA4OTI1NXogbTEzMC4wOTE1OSAxOTEuMzExMTYybC00My43ODYwMDYgMzcuNzIzMzI4YTI0LjI1MDcxMSAyNC4yNTA3MTEgMCAwIDAtNS43MTIzODkgMTYuMTY3MTRsOS41MTE2NjcgNTUuODg0NDE1YTIwLjM0MzY1MiAyMC4zNDM2NTIgMCAwIDEtMjguNTYxOTQ4IDE5LjgzMTY5M2wtNTEuMzg0NTYxLTI2Ljk0NTIzNGExNS4wMDg0OTUgMTUuMDA4NDk1IDAgMCAwLTE3LjEzNzE2OSAwbC01My4yOTc2NzMgMjYuOTQ1MjM0YTE5LjY3MDAyMSAxOS42NzAwMjEgMCAwIDEtMjguNTYxOTQ4LTE5LjgzMTY5M2w5LjUxMTY2Ny01NS44ODQ0MTVhMTcuNTQxMzQ3IDE3LjU0MTM0NyAwIDAgMC01LjcxMjM4OS0xNi4xNjcxNGwtNDMuNzg2MDA2LTM5LjYzNjQ0YTE3LjU0MTM0NyAxNy41NDEzNDcgMCAwIDEgMTEuNDI0NzgtMzAuNjYzNjc2bDU5LjAxMDA2Mi04Ljk5OTcwOGEyNi40ODcxNjUgMjYuNDg3MTY1IDAgMCAwIDE1LjI1MTAwMy05LjAyNjY1NGwyNi42NDg4MzYtNTAuNDQxNDc4YTIwLjIwODkyNiAyMC4yMDg5MjYgMCAwIDEgMzQuMjQ3MzkzIDBsMjYuNjQ4ODM2IDUwLjQ0MTQ3OGEyOS42Mzk3NTcgMjkuNjM5NzU3IDAgMCAwIDE1LjI1MTAwMyAxMC43NzgwOTRsNTkuMDEwMDYyIDguOTk5NzA4YTE4LjQ4NDQzMSAxOC40ODQ0MzEgMCAwIDEgMTEuNDI0NzggMzAuNTgyODQxeiIKICAgICAgICAgIGZpbGw9IiM0MDUzRkY3QSIKICAgICAgICAgIHAtaWQ9IjE2NjMwIgogICAgICAgID48L3BhdGg+CiAgICAgIDwvc3ZnPgogICAgICA8c3Bhbj7mlrDlu7rlkIjlkIw8L3NwYW4+CiAgICA8L2Rpdj4KICAgIDxkaXYKICAgICAgY2xhc3M9Im1vYmlsZS1jdXN0b20taXRlbSIKICAgICAgb25jbGljaz0id2luZG93Lm9wZW4oJ2h0dHA6Ly93d3cuaG90ZW50Lm9yZzo4ODg4L2NoYW56aGkvaW5kZXgucGhwL2Jvb2svZGVwbG95LzYuaHRtbCwnX2JsYW5rJykiCiAgICA+CiAgICAgIDxzdmcKICAgICAgICB0PSIxNjY0NTI0NTM4MzAxIgogICAgICAgIGNsYXNzPSJpY29uIgogICAgICAgIHZpZXdCb3g9IjAgMCAxMDI0IDEwMjQiCiAgICAgICAgdmVyc2lvbj0iMS4xIgogICAgICAgIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyIKICAgICAgICBwLWlkPSIxNjc2NCIKICAgICAgICB3aWR0aD0iMzIiCiAgICAgICAgaGVpZ2h0PSIzNiIKICAgICAgPgogICAgICAgIDxwYXRoCiAgICAgICAgICBkPSJNMTEwLjg4NzM0MSAxNDAuMTM0OTIybDQwLjQyMDY1OS00OC41MDQ3OTFhNDY5LjA5NTIyMiA0NjkuMDk1MjIyIDAgMCAxIDMyLjMzNjUyOC0zNy43MjU5NDhsMjYuOTQ3MTA2LTI2Ljk0NzEwN2E5Ni43NDAxMTEgOTYuNzQwMTExIDAgMCAxIDI2Ljk0NzEwNi0xOC44NjI5NzQgODUuOTg4MjE1IDg1Ljk4ODIxNSAwIDAgMSAzNy43MjU5NDgtOC4wODQxMzJoNDg0LjcyNDU0NGExNTcuNTU5NzI5IDE1Ny41NTk3MjkgMCAwIDEgMzUuMDMxMjM4IDUuMzg5NDIyIDEyMS4zOTY3MTMgMTIxLjM5NjcxMyAwIDAgMSAzNy43MjU5NDggMjYuOTQ3MTA2IDE5Ni41MjUyNDQgMTk2LjUyNTI0NCAwIDAgMCAyNC4yNTIzOTUgMjkuNjQxODE2IDMwNC45ODczNDYgMzA0Ljk4NzM0NiAwIDAgMSAyNi45NDcxMDYgMzUuMDMxMjM4YzEwLjc3ODg0MiAxMy40NzM1NTMgMjEuNTU3Njg1IDI5LjY0MTgxNyAzMi4zMzY1MjggNDMuMTE1Mzd6IgogICAgICAgICAgZmlsbD0iIzdGQzdGMSIKICAgICAgICAgIHAtaWQ9IjE2NzY1IgogICAgICAgID48L3BhdGg+CiAgICAgICAgPHBhdGgKICAgICAgICAgIGQ9Ik0xMDIxLjI5NTMxOSAzMzEuMzI0NjM5YTk0LjEyNjI0MSA5NC4xMjYyNDEgMCAwIDAtMjEuNTU3Njg1LTY0LjY3MzA1NCA4My4yNjY1NTggODMuMjY2NTU4IDAgMCAwLTcyLjc1NzE4Ni0yNi45NDcxMDZIMTAwLjEwODQ5OWE5MS40MDQ1ODQgOTEuNDA0NTg0IDAgMCAwLTcyLjc1NzE4NiAyNi45NDcxMDYgODYuMDY5MDU3IDg2LjA2OTA1NyAwIDAgMC0yMS41NTc2ODUgNjQuNjczMDU0djE3Ny44NTA5YTg5Ljg2ODU5OSA4OS44Njg1OTkgMCAwIDAgOTQuMzE0ODcxIDgzLjUzNjAyOWg4MzIuMjg4MzE3YTgwLjQ5MTAwNiA4MC40OTEwMDYgMCAwIDAgNjcuMzY3NzY1LTI2Ljk0NzEwNiA5Ni41Nzg0MjggOTYuNTc4NDI4IDAgMCAwIDI0LjI1MjM5Ni02NC42NzMwNTV6IG0tNDQxLjc3MDg1NiAxMjMuOTU2Njg4aC0xMzQuNzM1NTMxYTQwLjQyMDY1OSA0MC40MjA2NTkgMCAwIDEgMC04MC44NDEzMThoMTM0LjczNTUzMWE0MS40NDQ2NDkgNDEuNDQ0NjQ5IDAgMCAxIDQwLjQyMDY1OSA0MC40MjA2NTkgMzkuNjY2MTQgMzkuNjY2MTQgMCAwIDEtNDAuNDIwNjU5IDQwLjQyMDY1OXoiCiAgICAgICAgICBmaWxsPSIjMkZBQUYyIgogICAgICAgICAgcC1pZD0iMTY3NjYiCiAgICAgICAgPjwvcGF0aD4KICAgICAgICA8cGF0aAogICAgICAgICAgZD0iTTEwMjMuOTkwMDMgNzU2LjgxOTQ0NGE5MS44MDg3OSA5MS44MDg3OSAwIDAgMC0yNC4yNTIzOTYtNjQuNjczMDU1IDg1Ljg1MzQ4IDg1Ljg1MzQ4IDAgMCAwLTcwLjA2MjQ3Ni0yNi45NDcxMDZIMTAwLjEwODQ5OWExMDAuODA5MTI0IDEwMC44MDkxMjQgMCAwIDAtNzUuNDUxODk3IDI2Ljk0NzEwNiAxMDMuNTAzODM0IDEwMy41MDM4MzQgMCAwIDAtMjQuMjUyMzk1IDY3LjM2Nzc2NXYxNjEuNjgyNjM2YTkwLjU5NjE3MSA5MC41OTYxNzEgMCAwIDAgMjkuNjQxODE2IDc1LjQ1MTg5NyA5NC4wNDU0IDk0LjA0NTQgMCAwIDAgNjQuNjczMDU1IDI2Ljk0NzEwNmg4MzIuMjg4MzE3YTkyLjIzOTk0NCA5Mi4yMzk5NDQgMCAwIDAgOTcuMDA5NTgyLTk0LjMxNDg3MXogbS00NDQuNDY1NTY3IDE1OC45ODc5MjVoLTEzNC43MzU1MzFhNDAuNDIwNjU5IDQwLjQyMDY1OSAwIDAgMSAwLTgwLjg0MTMxOGgxMzQuNzM1NTMxYTQxLjQ0NDY0OSA0MS40NDQ2NDkgMCAwIDEgNDAuNDIwNjU5IDQwLjQyMDY1OSAzOC4xODQwNDkgMzguMTg0MDQ5IDAgMCAxLTQwLjQyMDY1OSA0MC40MjA2NTl6IgogICAgICAgICAgZmlsbD0iIzJGQUFGMiIKICAgICAgICAgIHAtaWQ9IjE2NzY3IgogICAgICAgID48L3BhdGg+CiAgICAgIDwvc3ZnPgogICAgICA8c3Bhbj7mlrDlu7rpobnnm648L3NwYW4+CiAgICA8L2Rpdj4KICAgIDxkaXYKICAgICAgY2xhc3M9Im1vYmlsZS1jdXN0b20taXRlbSIKICAgICAgb25jbGljaz0id2luZG93Lm9wZW4oJ2h0dHA6Ly93d3cuaG90ZW50Lm9yZzo4ODg4L2NoYW56aGkvaW5kZXgucGhwL2Jvb2svZGVwbG95LzYuaHRtbCwnX2JsYW5rJykiCiAgICA+CiAgICAgIDxzdmcKICAgICAgICB0PSIxNjY0NTI0Njc5NTI3IgogICAgICAgIGNsYXNzPSJpY29uIgogICAgICAgIHZpZXdCb3g9IjAgMCAxMTM3IDEwMjQiCiAgICAgICAgdmVyc2lvbj0iMS4xIgogICAgICAgIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyIKICAgICAgICBwLWlkPSIxNzQ0OCIKICAgICAgICB3aWR0aD0iMzIiCiAgICAgICAgaGVpZ2h0PSIzNiIKICAgICAgPgogICAgICAgIDxwYXRoCiAgICAgICAgICBkPSJNMTAzOC4yMjIyMjIgMEExMDAuNzc4NjY3IDEwMC43Nzg2NjcgMCAwIDEgMTEzNy43Nzc3NzggOTkuNTU1NTU2djY2OC4xNmExMDAuNzc4NjY3IDEwMC43Nzg2NjcgMCAwIDEtOTkuNTU1NTU2IDk5LjU1NTU1NUg1MTQuODQ0NDQ0bC0yMzAuNCAxNTAuNzU1NTU2YTMyLjE5OTExMSAzMi4xOTkxMTEgMCAwIDEtNDUuNTExMTExLTguNTMzMzM0IDQwLjM5MTExMSA0MC4zOTExMTEgMCAwIDEtNS42ODg4ODktMTcuMDY2NjY2di0xMjIuMzExMTExSDk5LjU1NTU1NmExMDAuNzc4NjY3IDEwMC43Nzg2NjcgMCAwIDEtOTkuNTU1NTU2LTk5LjU1NTU1NlY5OS41NTU1NTZBMTAwLjc3ODY2NyAxMDAuNzc4NjY3IDAgMCAxIDk5LjU1NTU1NiAwaDkzOC42NjY2NjZ6IgogICAgICAgICAgZmlsbD0iIzg1NTBFMSIKICAgICAgICAgIHAtaWQ9IjE3NDQ5IgogICAgICAgID48L3BhdGg+CiAgICAgICAgPHBhdGgKICAgICAgICAgIGQ9Ik03NTMuNzc3Nzc4IDMzMi43MTQ2NjdoLTM2OS43Nzc3NzhhNDMuNzQ3NTU2IDQzLjc0NzU1NiAwIDAgMS00Mi42NjY2NjctNDIuNjY2NjY3IDQzLjc0NzU1NiA0My43NDc1NTYgMCAwIDEgNDIuNjY2NjY3LTQyLjY2NjY2N2gzNjkuNzc3Nzc4YTQzLjc0NzU1NiA0My43NDc1NTYgMCAwIDEgNDIuNjY2NjY2IDQyLjY2NjY2NyA0My43NDc1NTYgNDMuNzQ3NTU2IDAgMCAxLTQyLjY2NjY2NiA0Mi42NjY2Njd6IgogICAgICAgICAgZmlsbD0iI0ZGRkZGRjdBIgogICAgICAgICAgcC1pZD0iMTc0NTAiCiAgICAgICAgPjwvcGF0aD4KICAgICAgICA8cGF0aAogICAgICAgICAgZD0iTTU4My4xMTExMTEgNTMxLjc0MDQ0NGgtMTk5LjExMTExMWE0My43NDc1NTYgNDMuNzQ3NTU2IDAgMCAxLTQyLjY2NjY2Ny00Mi42NjY2NjYgNDMuNzQ3NTU2IDQzLjc0NzU1NiAwIDAgMSA0Mi42NjY2NjctNDIuNjY2NjY3aDE5OS4xMTExMTFhNDMuNzQ3NTU2IDQzLjc0NzU1NiAwIDAgMSA0Mi42NjY2NjcgNDIuNjY2NjY3IDQxLjg5ODY2NyA0MS44OTg2NjcgMCAwIDEtNDIuNjY2NjY3IDQyLjY2NjY2NnoiCiAgICAgICAgICBmaWxsPSIjRkZGRkZGN0EiCiAgICAgICAgICBwLWlkPSIxNzQ1MSIKICAgICAgICA+PC9wYXRoPgogICAgICA8L3N2Zz4KICAgICAgPHNwYW4+5ZSu5YmN5pSv5oyBPC9zcGFuPgogICAgPC9kaXY+CiAgICA8ZGl2CiAgICAgIGNsYXNzPSJtb2JpbGUtY3VzdG9tLWl0ZW0iCiAgICAgIG9uY2xpY2s9IndpbmRvdy5vcGVuKCdodHRwOi8vd3d3LmhvdGVudC5vcmc6ODg4OC9jaGFuemhpL2luZGV4LnBocC9ib29rL2RlcGxveS82Lmh0bWwsJ19ibGFuaycpIgogICAgPgogICAgICA8c3ZnCiAgICAgICAgdD0iMTY2NDUyNDY2NDE0MiIKICAgICAgICBjbGFzcz0iaWNvbiIKICAgICAgICB2aWV3Qm94PSIwIDAgMTAyNCAxMDI0IgogICAgICAgIHZlcnNpb249IjEuMSIKICAgICAgICB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciCiAgICAgICAgcC1pZD0iMTczMTEiCiAgICAgICAgd2lkdGg9IjMyIgogICAgICAgIGhlaWdodD0iMzYiCiAgICAgID4KICAgICAgICA8cGF0aAogICAgICAgICAgZD0iTTUxMi4wMjkyMzYgMTMxLjI0OTczYTI4Mi45MzM3NDMgMjgyLjkzMzc0MyAwIDEgMCAyODguMzIyOTU4IDI4Mi45MzM3NDMgMjgyLjkzMzc0MyAyODIuOTMzNzQzIDAgMCAwLTI4OC4zMjI5NTgtMjgyLjkzMzc0M3oiCiAgICAgICAgICBmaWxsPSIjMDdDMTYwIgogICAgICAgICAgcC1pZD0iMTczMTIiCiAgICAgICAgPjwvcGF0aD4KICAgICAgICA8cGF0aAogICAgICAgICAgZD0iTTE3Ny44OTc5NTkgNTIxLjk2Nzc1NnYtMjYxLjM3Njg4N2gtMTAuNzc4NDI4YTM4MS4zNjc3MzkgMzgxLjM2NzczOSAwIDAgMSA1MDYuNTg2MTMtMTgwLjUzODY3NCAzOTAuODUyNzU2IDM5MC44NTI3NTYgMCAwIDEgMTgwLjUzODY3NCAxODAuNTM4Njc0aC0xMC43Nzg0Mjh2MjYxLjM3Njg4N2ExMjkuOTYwODk5IDEyOS45NjA4OTkgMCAwIDAgMTMyLjAzNTc0Ni0xMjkuMzQxMTQgMTI4LjI2MzI5NyAxMjguMjYzMjk3IDAgMCAwLTY3LjM2NTE3Ni0xMTMuMTczNDk3IDQyMy4wNTMzMTEgNDIzLjA1MzMxMSAwIDAgMC03OTQuOTA5MDg4LTIuNjk0NjA3IDEyNi4xODg0NDkgMTI2LjE4ODQ0OSAwIDAgMC02Ny4zNjUxNzcgMTEzLjE3MzQ5NyAxMzIuMjUxMzE1IDEzMi4yNTEzMTUgMCAwIDAgMTMyLjAzNTc0NyAxMzIuMDM1NzQ3eiIKICAgICAgICAgIGZpbGw9IiMwN0MxNjA3QSIKICAgICAgICAgIHAtaWQ9IjE3MzEzIgogICAgICAgID48L3BhdGg+CiAgICAgICAgPHBhdGgKICAgICAgICAgIGQ9Ik03OTcuNjU3NTg2IDY3MS4wMDY0NzNhNDI2LjA0NDMyNSA0MjYuMDQ0MzI1IDAgMCAxLTU3My45NTEzMDcgMEEzODEuODc5NzE1IDM4MS44Nzk3MTUgMCAwIDAgMC4wNTM4OTIgMTAyNGgxMDIzLjk1MDY4OWMwLTE2NC4zNzEwMzItODguOTIyMDMzLTI4NS42MjgzNS0yMjYuMzQ2OTk1LTM1Mi45OTM1Mjd6IgogICAgICAgICAgZmlsbD0iIzA3QzE2MCIKICAgICAgICAgIHAtaWQ9IjE3MzE0IgogICAgICAgID48L3BhdGg+CiAgICAgIDwvc3ZnPgogICAgICA8c3Bhbj7llK7lkI7mlK/mjIE8L3NwYW4+CiAgICA8L2Rpdj4KICAgIDxkaXYKICAgICAgY2xhc3M9Im1vYmlsZS1jdXN0b20taXRlbSIKICAgICAgb25jbGljaz0id2luZG93Lm9wZW4oJ2h0dHA6Ly93d3cuaG90ZW50Lm9yZzo4ODg4L2NoYW56aGkvaW5kZXgucGhwL2Jvb2svY2p3dC8yNzMuaHRtbCwnX2JsYW5rJykiCiAgICA+CiAgICAgIDxzdmcKICAgICAgICB0PSIxNjY0NTI0NjUyMDAyIgogICAgICAgIGNsYXNzPSJpY29uIgogICAgICAgIHZpZXdCb3g9IjAgMCAxMDI0IDEwMjQiCiAgICAgICAgdmVyc2lvbj0iMS4xIgogICAgICAgIHhtbG5zPSJodHRwOi8vd3d3LnczLm9yZy8yMDAwL3N2ZyIKICAgICAgICBwLWlkPSIxNzE3NSIKICAgICAgICB3aWR0aD0iMzIiCiAgICAgICAgaGVpZ2h0PSIzNiIKICAgICAgPgogICAgICAgIDxwYXRoCiAgICAgICAgICBkPSJNNTEyIDUxMm0tNTEyIDBhNTEyIDUxMiAwIDEgMCAxMDI0IDAgNTEyIDUxMiAwIDEgMC0xMDI0IDBaIgogICAgICAgICAgZmlsbD0iI0VGQTEzQyIKICAgICAgICAgIHAtaWQ9IjE3MTc2IgogICAgICAgID48L3BhdGg+CiAgICAgICAgPHBhdGgKICAgICAgICAgIGQ9Ik03MjUuNjgzMiAyNjcuNDQzMmE1MS4zMjggNTEuMzI4IDAgMCAwLTM0LjcxMzYgMGwtMjYwLjM3NzYgOTMuNzcyOGExMTUuMiAxMTUuMiAwIDAgMC02OS4zNzYgNjkuMzc2bC05My43NDcyIDI2MC4zNzc2YTUxLjIgNTEuMiAwIDAgMCA2NS41MzYgNjUuNTM2bDI2MC40MDMyLTkzLjc0NzJhMTE1LjIgMTE1LjIgMCAwIDAgNjkuMzUwNC02OS4zNzZsOTMuNzQ3Mi0yNjAuNDAzMmE1MS4yIDUxLjIgMCAwIDAtMzAuODIyNC02NS41MzZ6IG0tMjEzLjY4MzIgMzA4LjUzMTJhNjQgNjQgMCAxIDEgNjQtNjQgNjQgNjQgMCAwIDEtNjQuMDI1NiA2NC4wMjU2eiIKICAgICAgICAgIGZpbGw9IiNGRkRBQUIiCiAgICAgICAgICBwLWlkPSIxNzE3NyIKICAgICAgICA+PC9wYXRoPgogICAgICA8L3N2Zz4KICAgICAgPHNwYW4+57u85ZCI5bmz5Y+wPC9zcGFuPgogICAgPC9kaXY+CiAgICA8ZGl2CiAgICAgIGNsYXNzPSJtb2JpbGUtY3VzdG9tLWl0ZW0iCiAgICAgIG9uY2xpY2s9IndpbmRvdy5vcGVuKCdodHRwOi8vd3d3LmhvdGVudC5vcmc6ODg4OC9jaGFuemhpL2luZGV4LnBocC9ib29rL2V4dGVuZC9qc2NoZWNrLTE1OS5odG1sLCdfYmxhbmsnKSIKICAgID4KICAgICAgPHN2ZwogICAgICAgIHQ9IjE2NjQ1MjQ2MzQ5NzciCiAgICAgICAgY2xhc3M9Imljb24iCiAgICAgICAgdmlld0JveD0iMCAwIDEwODEgMTAyNCIKICAgICAgICB2ZXJzaW9uPSIxLjEiCiAgICAgICAgeG1sbnM9Imh0dHA6Ly93d3cudzMub3JnLzIwMDAvc3ZnIgogICAgICAgIHAtaWQ9IjE3MDM5IgogICAgICAgIHdpZHRoPSIzMiIKICAgICAgICBoZWlnaHQ9IjM2IgogICAgICA+CiAgICAgICAgPHBhdGgKICAgICAgICAgIGQ9Ik05My44NzcxMzcgNjQyLjg0MjEyM0gwLjAxMDgwOXYxMTMuNzc3MzY3QTk3LjE5NDMxNiA5Ny4xOTQzMTYgMCAwIDAgOTMuODc3MTM3IDg1My4zMzAyNTJoMzk4LjIyMDc4NHY3Ni43OTk3MjNoLTE0Mi4yMjE3MDlhNDUuNTEwOTQ3IDQ1LjUxMDk0NyAwIDAgMC00NS41MTA5NDcgNDguMzU1MzggNDQuOTQyMDYgNDQuOTQyMDYgMCAwIDAgNDUuNTEwOTQ3IDQ1LjUxMDk0N2gzNzUuNDY1MzExYTQ1LjUxMDk0NyA0NS41MTA5NDcgMCAwIDAgNDUuNTEwOTQ3LTQ4LjM1NTM4MSA0NC45NDIwNiA0NC45NDIwNiAwIDAgMC00NS41MTA5NDctNDUuNTEwOTQ2aC0xNDIuMjIxNzA5Vjg1My4zMzAyNTJoNDAxLjA2NTIxOWE5NS4zMTY5ODkgOTUuMzE2OTg5IDAgMCAwIDkzLjg2NjMyNy05Ni43MTA3NjJ2LTExMy43NzczNjdIOTMuODc3MTM3eiIKICAgICAgICAgIGZpbGw9IiM0MDUzRkY3QSIKICAgICAgICAgIHAtaWQ9IjE3MDQwIgogICAgICAgID48L3BhdGg+CiAgICAgICAgPHBhdGgKICAgICAgICAgIGQ9Ik05ODcuMDI5NDY3IDBIOTMuODc3MTM3QTk1LjMxNjk4OSA5NS4zMTY5ODkgMCAwIDAgMC4wMTA4MDkgOTYuNzEwNzYydjQ0OS40MjA1OTloMTA4MC44ODQ5ODZWOTYuNzEwNzYyQTk1LjIwMzIxMiA5NS4yMDMyMTIgMCAwIDAgOTg3LjAyOTQ2NyAwIgogICAgICAgICAgZmlsbD0iIzQwNTNGRiIKICAgICAgICAgIHAtaWQ9IjE3MDQxIgogICAgICAgID48L3BhdGg+CiAgICAgIDwvc3ZnPgogICAgICA8c3Bhbj7lkI7lj7DnrqHnkIY8L3NwYW4+CiAgICA8L2Rpdj4KICA8L2Rpdj4KPC9kaXY+Cg==', `IS_PUBLIC` = 1, `SUPPORT_REFESH` = NULL, `REFESH_TIME` = 10, `SHOW_EFFECT` = NULL, `MEMO` = '', `DATA_PARAM` = '{\"colType\":\"custom\",\"processPublicity\":[],\"announcementOrPictures\":null,\"filterType\":\"all\",\"filterScope\":[],\"selectType\":[],\"pullFrequency\":\"everyDay\",\"dataFrom\":\"\",\"model\":\"upDown\",\"colHeightType\":\"default\",\"timeType\":\"day\",\"date\":\"\",\"currentDataType\":\"\",\"dataType\":\"\"}', `NEEDPAGE` = 0, `ORG_ID` = NULL, `CREATOR` = NULL, `CREATE_BY_` = '1', `UPDATE_BY_` = '1', `CREATE_TIME_` = '2023-04-26 16:01:58', `UPDATE_TIME_` = '2023-06-01 17:20:53', `REQUEST_TYPE` = NULL, `CATALOG_NAME` = '', `CREATE_ORG_ID_` = '', `TENANT_ID_` = '-1', `SHOW_TITLE_` = 1, `CONTAIN_COL_` = NULL, `APPID_` = '', `SECRET_` = '', `TEMPLATE_JAVA_SCRIPT_` = 'e30=', `STYLE_` = '', `is_init_` = 0, `SNAPSHOT_ID_` = '1664200329970925568', `TEMPLATE_STYLE_` = 'Lm1vYmlsZS1jdXN0b20taXRlbXsKICAgZGlzcGxheTogZmxleDsKICAgIGZsZXgtZGlyZWN0aW9uOiBjb2x1bW47CiAgICBhbGlnbi1pdGVtczogY2VudGVyOwogICAganVzdGlmeS1jb250ZW50OiBjZW50ZXI7CiAgICBoZWlnaHQ6IDgycHg7CiAgICBjb2xvcjogIzI2MjYyNjsKICAgIGZvbnQtc2l6ZTogMTNweDsKICAgIHdpZHRoOiAyNSU7CiAgICBtYXJnaW4tYm90dG9tOiA4cHg7Cn0KLm1vYmlsZS1jdXN0b20taXRlbSBzcGFuewogIHBhZGRpbmctdG9wOjhweDsKfQogIA==' WHERE `ID` = '1651134508916514816';
UPDATE `portal_sys_column` SET `NAME` = '数据台', `ALIAS` = 'sjt', `CATALOG` = NULL, `COL_TYPE` = 'HtCustom', `DATA_MODE` = NULL, `DATA_FROM` = NULL, `DS_ALIAS` = NULL, `DS_NAME` = NULL, `COL_HEIGHT` = NULL, `COL_URL` = '', `TEMPLATE_HTML` = 'PGRpdiBjbGFzcz0ibW9iaWxlLWFwcGx5LWNhcmQiIDpjbGFzcz0ieyAnYm9yZGVyLWJvdHRvbSc6IGlzU2hvd0JvdHRvbU1hcmdpbiB9Ij4KICA8ZGl2CiAgICA6Ym9yZGVyPSJmYWxzZSIKICAgIGNsYXNzPSJtb2JpbGUtYXBwbHktY2FyZC0tY29udGVudCIKICAgIHYtaWY9ImFwcGx5TGlzdCAmJiBhcHBseUxpc3QubGVuZ3RoIgogID4KICAgIDxkaXYKICAgICAgY2xhc3M9Im1vYmlsZS1hcHBseS1jYXJkLS1pdGVtIgogICAgICB2LWZvcj0iKGl0ZW0sIGluZGV4KSBpbiBhcHBseUxpc3QiCiAgICAgIDprZXk9ImAke2l0ZW0ubmFtZX1fJHtpbmRleH1gIgogICAgICBAY2xpY2s9ImhhbmRsZUNsaWNrKGl0ZW0pIgogICAgPgogICAgICA8ZGl2CiAgICAgICAgY2xhc3M9Iml0ZW0tdG9wLS1pY29uIgogICAgICAgIDpzdHlsZT0ieyBiYWNrZ3JvdW5kOiBpdGVtLmljb25Db2xvciB8fCAnIzQwOUVGRicgfSIKICAgICAgPgogICAgICAgIDxpIGNsYXNzPSJtb2JpbGUtYXBwbHktaWNvbiIgOmNsYXNzPSJpdGVtLmljb24gfHwgJ2ljb24tYXNpZGUtYXBwLWNlbnRlciciPjwvaT4KICAgICAgPC9kaXY+CiAgICAgIDxkaXYgY2xhc3M9Im1vYmlsZS1pdGVtLWJvdHRvbS0tbmFtZSI+e3sgaXRlbS5uYW1lfX08L2Rpdj4KICAgIDwvZGl2PgogIDwvZGl2Pgo8L2Rpdj4=', `IS_PUBLIC` = 1, `SUPPORT_REFESH` = NULL, `REFESH_TIME` = 10, `SHOW_EFFECT` = NULL, `MEMO` = '', `DATA_PARAM` = '{\"colType\":\"custom\",\"processPublicity\":[],\"announcementOrPictures\":null,\"filterType\":\"all\",\"filterScope\":[],\"selectType\":[],\"pullFrequency\":\"everyDay\",\"dataFrom\":\"\",\"model\":\"upDown\",\"colHeightType\":\"default\",\"timeType\":\"day\",\"date\":\"\",\"currentDataType\":\"\",\"dataType\":\"\"}', `NEEDPAGE` = 0, `ORG_ID` = NULL, `CREATOR` = NULL, `CREATE_BY_` = '1', `UPDATE_BY_` = '1', `CREATE_TIME_` = '2023-04-26 10:53:55', `UPDATE_TIME_` = '2023-06-01 17:16:52', `REQUEST_TYPE` = NULL, `CATALOG_NAME` = '', `CREATE_ORG_ID_` = '', `TENANT_ID_` = '-1', `SHOW_TITLE_` = 1, `CONTAIN_COL_` = NULL, `APPID_` = '', `SECRET_` = '', `TEMPLATE_JAVA_SCRIPT_` = 'ewogICBkYXRhKCkgewogICAgICByZXR1cm4gewogICAgICAgIGlzU2hvd0JvdHRvbU1hcmdpbjpmYWxzZSwKICAgICAgICBhcHBseUxpc3Q6IFsKICAgICAgICAgIHsKICAgICAgICAgICAgbmFtZTogJ+aWsOW7uua1geeoiycsCiAgICAgICAgICAgIGljb246ICdpY29uLXhpbmppYW5saXVjaGVuZzExJywKICAgICAgICAgICAgaWNvbkNvbG9yOiAnIzQwOUVGRicsCiAgICAgICAgICAgIHBhdGg6ICcvbWF0dGVyL25ld01hdHRlcicsCiAgICAgICAgICB9LAogICAgICAgICAgewogICAgICAgICAgICBuYW1lOiAn5b6F5Yqe5bey5YqeJywKICAgICAgICAgICAgaWNvbjogJ2ljb24tZGFpYmFuJywKICAgICAgICAgICAgaWNvbkNvbG9yOiAnIzQwNTNGRicsCiAgICAgICAgICAgIHBhdGg6ICcvbWF0dGVyL215VGFzaycsCiAgICAgICAgICB9LAogICAgICAgICAgewogICAgICAgICAgICBuYW1lOiAn5oiR55qE55Sz6K+3JywKICAgICAgICAgICAgaWNvbjogJ2ljb24td29kZXNoZW5xaW5nJywKICAgICAgICAgICAgaWNvbkNvbG9yOiAnI0Y2Qjg1QScsCiAgICAgICAgICAgIHBhdGg6ICcvbWF0dGVyL215UmVxdWVzdCcsCiAgICAgICAgICB9LAogICAgICAgICAgewogICAgICAgICAgICBuYW1lOiAn5Lyg6ZiF5LqL6aG5JywKICAgICAgICAgICAgaWNvbjogJ2ljb24td29kZWNodWFueXVlJywKICAgICAgICAgICAgaWNvbkNvbG9yOiAnIzg1NTBFMScsCiAgICAgICAgICAgIHBhdGg6ICcvbWF0dGVyL2NpcmN1bGF0ZU1hdHRlcicsCiAgICAgICAgICB9LAogICAgICAgICAgewogICAgICAgICAgICBuYW1lOiAn5oiR55qE6L2s5YqeJywKICAgICAgICAgICAgaWNvbjogJ2ljb24td29kZXpodWFuYmFuJywKICAgICAgICAgICAgaWNvbkNvbG9yOiAnI0ZGOEE0NicsCiAgICAgICAgICAgIHBhdGg6ICcvbWF0dGVyL215RGVsZWdhdGUnLAogICAgICAgICAgfSwKICAgICAgICBdLAogICAgICB9CiAgIH0sCiAgICAgbWV0aG9kczogewogICAgICBoYW5kbGVDbGljayhpdGVtKSB7CiAgICAgICAgaWYgKGl0ZW0ucGF0aCkgewogICAgICAgICAgdGhpcy4kcm91dGVyLnB1c2goaXRlbS5wYXRoKQogICAgICAgIH0KICAgICAgfSwKICAgIH0sCn0=', `STYLE_` = '', `is_init_` = 0, `SNAPSHOT_ID_` = '1664199322310361088', `TEMPLATE_STYLE_` = 'Lm1vYmlsZS1hcHBseS1jYXJkIHsKICBiYWNrZ3JvdW5kOiAjZmZmOwp9CgoubW9iaWxlLWFwcGx5LWNhcmQtLWNvbnRlbnR7CiAgIGRpc3BsYXk6IGZsZXg7CiAgIGZsZXgtd3JhcDogd3JhcDsKICAgcGFkZGluZy10b3A6IDE2cHg7Cn0KLm1vYmlsZS1hcHBseS1jYXJkLS1jb250ZW50IC5tb2JpbGUtYXBwbHktY2FyZC0taXRlbXsKICAgIHdpZHRoOiAyNSU7CiAgICBkaXNwbGF5OiBmbGV4OwogICAgdGV4dC1hbGlnbjogY2VudGVyOwogICAgZmxleC1kaXJlY3Rpb246IGNvbHVtbjsKICAgIGFsaWduLWl0ZW1zOiBjZW50ZXI7CiAgICBqdXN0aWZ5LWNvbnRlbnQ6IGNlbnRlcjsKICAgIGhlaWdodDogOTBweDsKICAgIG1hcmdpbi1ib3R0b206OHB4Owp9Ci5tb2JpbGUtYXBwbHktY2FyZC0tY29udGVudCAubW9iaWxlLWFwcGx5LWNhcmQtLWl0ZW0gLml0ZW0tdG9wLS1pY29uIHsKICB3aWR0aDogNDBweDsKICBoZWlnaHQ6IDQwcHg7CiAgZGlzcGxheTogZmxleDsKICBqdXN0aWZ5LWNvbnRlbnQ6IGNlbnRlcjsKICBhbGlnbi1pdGVtczogY2VudGVyOwogIGJvcmRlci1yYWRpdXM6IDhweDsKICBjb2xvcjogI2ZmZjsKfQoKLm1vYmlsZS1hcHBseS1jYXJkLS1jb250ZW50IC5tb2JpbGUtYXBwbHktY2FyZC0taXRlbSAuaXRlbS10b3AtLWljb24gLm1vYmlsZS1hcHBseS1pY29uIHsKICBmb250LXNpemU6IDI0cHg7Cn0KCi5tb2JpbGUtYXBwbHktY2FyZC0tY29udGVudCAubW9iaWxlLWFwcGx5LWNhcmQtLWl0ZW0gLm1vYmlsZS1pdGVtLWJvdHRvbS0tbmFtZSB7CiAgaGVpZ2h0OiAzMHB4OwogIGZvbnQtc2l6ZTogMTNweDsKICBjb2xvcjogIzMzMzsKICBwYWRkaW5nLXRvcDogOHB4OwogIHRleHQtYWxpZ246IGNlbnRlcjsKICBvdmVyZmxvdzogaGlkZGVuOwogIHRleHQtb3ZlcmZsb3c6IGVsbGlwc2lzOwogIGRpc3BsYXk6IC13ZWJraXQtYm94OwogIC13ZWJraXQtbGluZS1jbGFtcDogMjsKICAtd2Via2l0LWJveC1vcmllbnQ6IHZlcnRpY2FsOwp9' WHERE `ID` = '1651056986864828416';
-- 2023-06-12 lizhenxing 修改表前缀
rename table portal_documentation_error_log to bpm_documentation_error_log
UPDATE `portal_sys_column` SET `NAME` = '数据台', `ALIAS` = 'sjt', `CATALOG` = NULL, `COL_TYPE` = 'HtCustom', `DATA_MODE` = NULL, `DATA_FROM` = NULL, `DS_ALIAS` = NULL, `DS_NAME` = NULL, `COL_HEIGHT` = NULL, `COL_URL` = '', `TEMPLATE_HTML` = 'PGRpdiBjbGFzcz0ibW9iaWxlLWFwcGx5LWNhcmQiIDpjbGFzcz0ieyAnYm9yZGVyLWJvdHRvbSc6IGlzU2hvd0JvdHRvbU1hcmdpbiB9Ij4KICA8ZGl2CiAgICA6Ym9yZGVyPSJmYWxzZSIKICAgIGNsYXNzPSJtb2JpbGUtYXBwbHktY2FyZC0tY29udGVudCIKICAgIHYtaWY9ImFwcGx5TGlzdCAmJiBhcHBseUxpc3QubGVuZ3RoIgogID4KICAgIDxkaXYKICAgICAgY2xhc3M9Im1vYmlsZS1hcHBseS1jYXJkLS1pdGVtIgogICAgICB2LWZvcj0iKGl0ZW0sIGluZGV4KSBpbiBhcHBseUxpc3QiCiAgICAgIDprZXk9ImAke2l0ZW0ubmFtZX1fJHtpbmRleH1gIgogICAgICBAY2xpY2s9ImhhbmRsZUNsaWNrKGl0ZW0pIgogICAgPgogICAgICA8ZGl2CiAgICAgICAgY2xhc3M9Iml0ZW0tdG9wLS1pY29uIgogICAgICAgIDpzdHlsZT0ieyBiYWNrZ3JvdW5kOiBpdGVtLmljb25Db2xvciB8fCAnIzQwOUVGRicgfSIKICAgICAgPgogICAgICAgIDxpIGNsYXNzPSJtb2JpbGUtYXBwbHktaWNvbiIgOmNsYXNzPSJpdGVtLmljb24gfHwgJ2ljb24tYXNpZGUtYXBwLWNlbnRlciciPjwvaT4KICAgICAgPC9kaXY+CiAgICAgIDxkaXYgY2xhc3M9Im1vYmlsZS1pdGVtLWJvdHRvbS0tbmFtZSI+e3sgaXRlbS5uYW1lfX08L2Rpdj4KICAgIDwvZGl2PgogIDwvZGl2Pgo8L2Rpdj4=', `IS_PUBLIC` = 1, `SUPPORT_REFESH` = NULL, `REFESH_TIME` = 10, `SHOW_EFFECT` = NULL, `MEMO` = '', `DATA_PARAM` = '{\"colType\":\"custom\",\"processPublicity\":[],\"announcementOrPictures\":null,\"filterType\":\"all\",\"filterScope\":[],\"selectType\":[],\"pullFrequency\":\"everyDay\",\"dataFrom\":\"\",\"model\":\"upDown\",\"colHeightType\":\"default\",\"timeType\":\"day\",\"date\":\"\",\"currentDataType\":\"\",\"dataType\":\"\"}', `NEEDPAGE` = 0, `ORG_ID` = NULL, `CREATOR` = NULL, `CREATE_BY_` = '1', `UPDATE_BY_` = '1', `CREATE_TIME_` = '2023-04-26 10:53:55', `UPDATE_TIME_` = '2023-06-16 10:43:09', `REQUEST_TYPE` = NULL, `CATALOG_NAME` = '', `CREATE_ORG_ID_` = '', `TENANT_ID_` = '-1', `SHOW_TITLE_` = 1, `CONTAIN_COL_` = NULL, `APPID_` = '', `SECRET_` = '', `TEMPLATE_JAVA_SCRIPT_` = 'ewogICBkYXRhKCkgewogICAgICByZXR1cm4gewogICAgICAgIGlzU2hvd0JvdHRvbU1hcmdpbjpmYWxzZSwKICAgICAgICBhcHBseUxpc3Q6IFsKICAgICAgICAgIHsKICAgICAgICAgICAgbmFtZTogJ+aWsOW7uua1geeoiycsCiAgICAgICAgICAgIGljb246ICdpY29uLXhpbmppYW5saXVjaGVuZzExJywKICAgICAgICAgICAgaWNvbkNvbG9yOiAnIzQwOUVGRicsCiAgICAgICAgICAgIHBhdGg6ICcvbWF0dGVyL25ld01hdHRlcicsCiAgICAgICAgICB9LAogICAgICAgICAgewogICAgICAgICAgICBuYW1lOiAn5oiR55qE5Lu75YqhJywKICAgICAgICAgICAgaWNvbjogJ2ljb24tZGFpYmFuJywKICAgICAgICAgICAgaWNvbkNvbG9yOiAnIzQwNTNGRicsCiAgICAgICAgICAgIHBhdGg6ICcvbWF0dGVyL215VGFzaycsCiAgICAgICAgICB9LAogICAgICAgICAgewogICAgICAgICAgICBuYW1lOiAn5oiR55qE55Sz6K+3JywKICAgICAgICAgICAgaWNvbjogJ2ljb24td29kZXNoZW5xaW5nJywKICAgICAgICAgICAgaWNvbkNvbG9yOiAnI0Y2Qjg1QScsCiAgICAgICAgICAgIHBhdGg6ICcvbWF0dGVyL215UmVxdWVzdCcsCiAgICAgICAgICB9LAogICAgICAgICAgewogICAgICAgICAgICBuYW1lOiAn5Lyg6ZiF5LqL6aG5JywKICAgICAgICAgICAgaWNvbjogJ2ljb24td29kZWNodWFueXVlJywKICAgICAgICAgICAgaWNvbkNvbG9yOiAnIzg1NTBFMScsCiAgICAgICAgICAgIHBhdGg6ICcvbWF0dGVyL2NpcmN1bGF0ZU1hdHRlcicsCiAgICAgICAgICB9LAogICAgICAgIF0sCiAgICAgIH0KICAgfSwKICAgICBtZXRob2RzOiB7CiAgICAgIGhhbmRsZUNsaWNrKGl0ZW0pIHsKICAgICAgICBpZiAoaXRlbS5wYXRoKSB7CiAgICAgICAgICB0aGlzLiRyb3V0ZXIucHVzaChpdGVtLnBhdGgpCiAgICAgICAgfQogICAgICB9LAogICAgfSwKfQ==', `STYLE_` = '', `is_init_` = 0, `SNAPSHOT_ID_` = '', `TEMPLATE_STYLE_` = 'Lm1vYmlsZS1hcHBseS1jYXJkIHsKICBiYWNrZ3JvdW5kOiAjZmZmOwp9CgoubW9iaWxlLWFwcGx5LWNhcmQtLWNvbnRlbnR7CiAgIGRpc3BsYXk6IGZsZXg7CiAgIGZsZXgtd3JhcDogd3JhcDsKICAgcGFkZGluZy10b3A6IDE2cHg7Cn0KLm1vYmlsZS1hcHBseS1jYXJkLS1jb250ZW50IC5tb2JpbGUtYXBwbHktY2FyZC0taXRlbXsKICAgIHdpZHRoOiAyNSU7CiAgICBkaXNwbGF5OiBmbGV4OwogICAgdGV4dC1hbGlnbjogY2VudGVyOwogICAgZmxleC1kaXJlY3Rpb246IGNvbHVtbjsKICAgIGFsaWduLWl0ZW1zOiBjZW50ZXI7CiAgICBqdXN0aWZ5LWNvbnRlbnQ6IGNlbnRlcjsKICAgIGhlaWdodDogOTBweDsKICAgIG1hcmdpbi1ib3R0b206OHB4Owp9Ci5tb2JpbGUtYXBwbHktY2FyZC0tY29udGVudCAubW9iaWxlLWFwcGx5LWNhcmQtLWl0ZW0gLml0ZW0tdG9wLS1pY29uIHsKICB3aWR0aDogNDBweDsKICBoZWlnaHQ6IDQwcHg7CiAgZGlzcGxheTogZmxleDsKICBqdXN0aWZ5LWNvbnRlbnQ6IGNlbnRlcjsKICBhbGlnbi1pdGVtczogY2VudGVyOwogIGJvcmRlci1yYWRpdXM6IDhweDsKICBjb2xvcjogI2ZmZjsKfQoKLm1vYmlsZS1hcHBseS1jYXJkLS1jb250ZW50IC5tb2JpbGUtYXBwbHktY2FyZC0taXRlbSAuaXRlbS10b3AtLWljb24gLm1vYmlsZS1hcHBseS1pY29uIHsKICBmb250LXNpemU6IDI0cHg7Cn0KCi5tb2JpbGUtYXBwbHktY2FyZC0tY29udGVudCAubW9iaWxlLWFwcGx5LWNhcmQtLWl0ZW0gLm1vYmlsZS1pdGVtLWJvdHRvbS0tbmFtZSB7CiAgaGVpZ2h0OiAzMHB4OwogIGZvbnQtc2l6ZTogMTNweDsKICBjb2xvcjogIzMzMzsKICBwYWRkaW5nLXRvcDogOHB4OwogIHRleHQtYWxpZ246IGNlbnRlcjsKICBvdmVyZmxvdzogaGlkZGVuOwogIHRleHQtb3ZlcmZsb3c6IGVsbGlwc2lzOwogIGRpc3BsYXk6IC13ZWJraXQtYm94OwogIC13ZWJraXQtbGluZS1jbGFtcDogMjsKICAtd2Via2l0LWJveC1vcmllbnQ6IHZlcnRpY2FsOwp9' WHERE `ALIAS` = 'sjt';
-- 2023-6-20 jjx 更新我的申请国际化内容
update `portal_i18n_message` set VALUE_ = '流程编号' where `ID_` = '1613098875580936192';
update `portal_i18n_message` set VALUE_ = 'Process number' where `ID_` = '1613099384089964544';
update `portal_i18n_message` set VALUE_ = '流程編號' where `ID_` = '1613352041601921024';
-- 2023-6-20 liangjc 修复portal_sys_dic旧数据字典排序sn_为空的数据,解决5.7及以下不支持over()函数问题
UPDATE portal_sys_dic t1,( SELECT dic.id_, @rowno:= @rowno+1 AS rowNum FROM portal_sys_dic dic,(select @rowno:=0) r ) t2
SET t1.sn_ = t2.rowNum
WHERE
t1.id_ = t2.id_
AND t1.sn_ IS NULL;
-- 2023-6-20 jjx 更新门户配置椒,解决初始化图片加载失败问题
UPDATE `portal_sys_layout_manage` SET `DESIGN_HTML` = 'eyJ0b3BCb3R0b21MYXlvdXQiOltdLCJoZWFkZXIiOltdLCJtYWluIjp7ImxlZnQiOltdLCJjZW50ZXIiOltdLCJyaWdodCI6W10sImxheW91dENvbCI6InR3byJ9LCJib3R0b20iOltdLCJtb2JpbGVMaXN0IjpbXSwibGlzdCI6W3sidHlwZSI6Im9uZSIsIm5hbWUiOiLkuIDooYzkuIDliJciLCJpY29uIjoiaWNvbi15aWhhbmd5aWxpZSIsImNvbHVtbnMiOlt7InNwYW4iOjI0LCJsaXN0IjpbeyJuYW1lIjoi5Liq5Lq65L+h5oGv5qCP55uu566h55CG56uvIiwiYWxpYXMiOiJncnh4bG1nbGQiLCJrZXkiOiIxNjY3NDYwMjE4MDAwXzY3ODI5NDciLCJzbmFwc2hvdElkIjoiIn1dfV0sImtleSI6IjE2Njc0NTk4NDIwMDBfOTE4Mzk0OCJ9LHsidHlwZSI6Im9uZSIsIm5hbWUiOiLkuIDooYzkuIDliJciLCJpY29uIjoiaWNvbi15aWhhbmd5aWxpZSIsImNvbHVtbnMiOlt7InNwYW4iOjI0LCJsaXN0IjpbeyJuYW1lIjoi5Lu75Yqh6Z2i5p2/566h55CG56uvIiwiYWxpYXMiOiJyd21iZ2xkIiwia2V5IjoiMTY2NzQ2MDIyMjAwMF82NzYzMTIwIiwic25hcHNob3RJZCI6IiJ9XX1dLCJrZXkiOiIxNjY3NDYwMjIxMDAwXzgzMDk3MTcifSx7InR5cGUiOiJvbmUiLCJuYW1lIjoi5LiA6KGM5LiA5YiXIiwiaWNvbiI6Imljb24teWloYW5neWlsaWUiLCJjb2x1bW5zIjpbeyJzcGFuIjoyNCwibGlzdCI6W3sibmFtZSI6IuWFs+S6juaIkeS7rOeuoeeQhuerryIsImFsaWFzIjoiZ3l3bWdsZCIsImtleSI6IjE2Njc0NjAyMjUwMDBfMjUzMDM1NiIsInNuYXBzaG90SWQiOiIifV19XSwia2V5IjoiMTY2NzQ2MDIyMzAwMF8xNzEyMDk0In1dLCJjb25maWciOnsibGFiZWxXaWR0aCI6MTAwLCJsYWJlbFBvc2l0aW9uIjoicmlnaHQiLCJzaXplIjoic21hbGwifX0K' WHERE `ID` = '0';
UPDATE `portal_sys_layout_manage` SET `DESIGN_HTML` = 'eyJ0b3BCb3R0b21MYXlvdXQiOltdLCJoZWFkZXIiOltdLCJtYWluIjp7ImxlZnQiOltdLCJjZW50ZXIiOltdLCJyaWdodCI6W10sImxheW91dENvbCI6InR3byJ9LCJib3R0b20iOltdLCJtb2JpbGVMaXN0IjpbeyJzbmFwc2hvdElkIjoiIiwibmFtZSI6IuaVsOaNruWPsCIsImFsaWFzIjoic2p0Iiwia2V5IjoiMTY4NjIxOTY3MTAwMF85NzA4ODU0In0seyJzbmFwc2hvdElkIjoiIiwibmFtZSI6IuW4uOeUqOWKn+iDvSIsImFsaWFzIjoiY3lnbnNqZCIsImtleSI6IjE2ODYyMTk2ODAwMDBfMTExNjQxNSJ9LHsic25hcHNob3RJZCI6IiIsIm5hbWUiOiLlvoXlip7liIbmnpAiLCJhbGlhcyI6InlkZGRiZngiLCJrZXkiOiIxNjg2MjIwMzU1MDAwXzk0NDA4MTUifSx7InNuYXBzaG90SWQiOiIiLCJuYW1lIjoi5paw6Ze75Lit5b+DIiwiYWxpYXMiOiJ5ZGR4d3p4Iiwia2V5IjoiMTY4NzE0NTc5MTAwMF85MTkwNDg4In1dLCJsaXN0IjpbXSwiY29uZmlnIjp7ImxhYmVsV2lkdGgiOjEwMCwibGFiZWxQb3NpdGlvbiI6InJpZ2h0Iiwic2l6ZSI6InNtYWxsIn19Cg==' WHERE `ID` = '1';
UPDATE `portal_sys_layout_manage` SET `DESIGN_HTML` = 'eyJ0b3BCb3R0b21MYXlvdXQiOltdLCJoZWFkZXIiOltdLCJtYWluIjp7ImxlZnQiOlt7Im5hbWUiOiLkuKrkurrkv6Hmga/moI/nm64iLCJhbGlhcyI6ImdyeHhsbSJ9LHsibmFtZSI6IuW4uOeUqOa1geeoiyIsImFsaWFzIjoidnVlT2Z0ZW5GbG93In0seyJuYW1lIjoi5Lu75Yqh6Z2i5p2/IiwiYWxpYXMiOiJyd21idnVlIn1dLCJjZW50ZXIiOltdLCJyaWdodCI6W3sibmFtZSI6IuaIkeeahOW+heWKniIsImFsaWFzIjoidnVlVG9kbyJ9LHsibmFtZSI6IuaIkeeahOivt+axgiIsImFsaWFzIjoidnVlTXlyZXF1ZXN0In0seyJuYW1lIjoi5pyA5paw6aG555uuIiwiYWxpYXMiOiJ6eHhtdnVlIn1dLCJsYXlvdXRDb2wiOiJ0d28ifSwiYm90dG9tIjpbXSwibW9iaWxlTGlzdCI6W10sImxpc3QiOlt7InR5cGUiOiJvbmUiLCJuYW1lIjoi5LiA6KGM5LiA5YiXIiwiaWNvbiI6Imljb24teWloYW5neWlsaWUiLCJjb2x1bW5zIjpbeyJzcGFuIjoyNCwibGlzdCI6W3sic25hcHNob3RJZCI6IiIsIm5hbWUiOiLova7mkq3lm74iLCJhbGlhcyI6ImxidCIsImtleSI6IjE2ODcxNDEzMzEwMDBfNjM1MDcyNyJ9XX1dLCJrZXkiOiIxNjg3MTQxMzI3MDAwXzI2Nzg4NTIifSx7InR5cGUiOiJ0d28iLCJuYW1lIjoi5LiA6KGM5Lik5YiXIiwiaWNvbiI6Imljb24teWloYW5nbGlhbmdsaWUiLCJjb2x1bW5zIjpbeyJzcGFuIjoxNiwibGlzdCI6W3sibmFtZSI6IuS4quS6uuS/oeaBr+agj+ebriIsImFsaWFzIjoiZ3J4eGxtIiwia2V5IjoiMTY2NTI5OTk3MDAwMF8xMTQ5NzY0Iiwic25hcHNob3RJZCI6IiJ9LHsibmFtZSI6IuW+heWKniIsImFsaWFzIjoiZGIiLCJrZXkiOiIxNjg2MjEyOTIyMDAwXzY0ODMzIiwic25hcHNob3RJZCI6IiJ9LHsic25hcHNob3RJZCI6IiIsIm5hbWUiOiLmtYHnqIvkuK3lv4MiLCJhbGlhcyI6ImxjengiLCJrZXkiOiIxNjg2MjIwNTM1MDAwXzcxNDM3MDMifSx7Im5hbWUiOiLml6XnqIsiLCJhbGlhcyI6InJjIiwia2V5IjoiMTY4NjIyMDU1NTAwMF81NzI1NTkyIiwic25hcHNob3RJZCI6IiJ9LHsibmFtZSI6IuS8muiuriIsImFsaWFzIjoiaHkiLCJrZXkiOiIxNjg2MjEyOTc4MDAwXzgxMjg1MzUiLCJzbmFwc2hvdElkIjoiIn1dfSx7InNwYW4iOjgsImxpc3QiOlt7Im5hbWUiOiLluLjnlKjlip/og70iLCJhbGlhcyI6ImN5Z24iLCJrZXkiOiIxNjg2MjEyOTQwMDAwXzQ3NzMzNDAiLCJzbmFwc2hvdElkIjoiIn0seyJzbmFwc2hvdElkIjoiIiwibmFtZSI6IuS8geS4muaWsOmXuyIsImFsaWFzIjoicXl4dyIsImtleSI6IjE2ODYyMTQ1OTEwMDBfNDQ2NDg4OSJ9LHsic25hcHNob3RJZCI6IiIsIm5hbWUiOiLluLjnlKjmtYHnqIsiLCJhbGlhcyI6ImN5bGMiLCJrZXkiOiIxNjg2MjIwMzk5MDAwXzQwMDk4NTIifSx7InNuYXBzaG90SWQiOiIiLCJuYW1lIjoi5Liq5Lq65LqL6aG5IiwiYWxpYXMiOiJncnN4Iiwia2V5IjoiMTY4NjIyMDU0NzAwMF81ODgxMzk2In0seyJzbmFwc2hvdElkIjoiIiwibmFtZSI6IuW+heWKnuWIhuaekCIsImFsaWFzIjoiZGJmeCIsImtleSI6IjE2ODYyMTI5NTAwMDBfOTQ1ODUxNiJ9XX1dLCJrZXkiOiIxNjY1Mjk5MjA4MDAwXzYwNjA0MjEifSx7InR5cGUiOiJvbmUiLCJuYW1lIjoi5LiA6KGM5LiA5YiXIiwiaWNvbiI6Imljb24teWloYW5neWlsaWUiLCJjb2x1bW5zIjpbeyJzcGFuIjoyNCwibGlzdCI6W3sibmFtZSI6IuS7u+WKoemdouadv+W6lOeUqOerryIsImFsaWFzIjoicndtYnl5ZCIsImtleSI6IjE2Njc0NTkyNjQwMDBfMTE5NTkyNyIsInNuYXBzaG90SWQiOiIifV19XSwia2V5IjoiMTY2NzQ1OTI1OTAwMF81NzEyMTgyIn0seyJ0eXBlIjoib25lIiwibmFtZSI6IuS4gOihjOS4gOWIlyIsImljb24iOiJpY29uLXlpaGFuZ3lpbGllIiwiY29sdW1ucyI6W3sic3BhbiI6MjQsImxpc3QiOlt7Im5hbWUiOiLlhbPkuo7miJHku6wiLCJhbGlhcyI6Imd5d20iLCJrZXkiOiIxNjY3NDU5MjcwMDAwXzYwMjUwODkiLCJzbmFwc2hvdElkIjoiIn1dfV0sImtleSI6IjE2Njc0NTkyNjcwMDBfMjM3NDY4MSJ9XSwiY29uZmlnIjp7ImxhYmVsV2lkdGgiOjEwMCwibGFiZWxQb3NpdGlvbiI6InJpZ2h0Iiwic2l6ZSI6InNtYWxsIn19Cg==' WHERE `ID` = '2';
-- 2023-6-25 jjx 更新维度菜单接口
UPDATE portal_sys_method SET REQUEST_URL_ = '/api/demension/v1/dem/deleteDemByIds' WHERE ALIAS_ = 'uc_demension_del';
-- 2023-6-26 liangjc 默认平台的给人事管理员和系统管理员授权
INSERT INTO portal_sys_method(id_, ALIAS_, NAME_, MENU_ALIAS_, REQUEST_URL_, PATH_, TENANT_ID_) select '1666702693495816192', 'updateUserPsw', '修改密码接口权限', ALIAS_, '/api/user/v1/user/updateUserPsw', PATH_, TENANT_ID_ from portal_sys_menu where ALIAS_='ucManager' and TENANT_ID_='-1';
INSERT INTO portal_sys_role_auth(id_, ROLE_ALIAS_, METHOD_ALIAS_, TENANT_ID_) select '1666702693495816192', 'rsgly', ALIAS_, '-1' from portal_sys_method where MENU_ALIAS_='ucManager' and TENANT_ID_='-1';
INSERT INTO portal_sys_role_auth(ID_, ROLE_ALIAS_, METHOD_ALIAS_, TENANT_ID_) select '1666702693495816193', 'xtgly', ALIAS_, '-1' from portal_sys_method where MENU_ALIAS_='ucManager' and TENANT_ID_='-1';
-- 2023-06-27 yijj 修改DESIGN_HTML类型为longtext
ALTER TABLE `portal_sys_layout_manage` MODIFY COLUMN `DESIGN_HTML` longtext NULL AFTER `TEMPLATE_HTML`;
-- 2023-06-29 yijj 修改标签key长度
ALTER TABLE `portal_sys_tag`
MODIFY COLUMN `KEY_` varchar(128) NULL DEFAULT NULL COMMENT '标签KEY' AFTER `TYPE_ID_`;