7.2.4 To 7.2.4_Beta02.sql
32.5 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
-- 2020-09-14 李洪桥 将排版规则的是否删除的字段改为字符串格式
alter table uc_shift_rule alter column is_dele_ type varchar(1) using is_dele_::varchar(1);
alter table uc_shift_user alter column is_dele_ type varchar(1) using is_dele_::varchar(1);
-- 2020-09-14 赵祥云 我的企业信息栏目表添加默认应用端名称“宏天企业信息平台”
UPDATE UC_TENANT_MANAGE SET NAME_FRONT_='宏天企业信息平台' where ID_ = '-1';
-- 2020-09-15 李洪桥 调整pgsql的新闻高度的数据类型 防止报错
alter table portal_news_notice_ alter column page_height_ type varchar(10) using page_height_::varchar(10);
-- 2020-09-15 lingpj 调整栏目数据
UPDATE PORTAL_SYS_COLUMN SET TEMPLATE_HTML = 'PGRpdiBzdHlsZT0icGFkZGluZy10b3A6MTBweDtwYWRkaW5nLWJvdHRvbToxMHB4O3RleHQtYWxpZ246Y2VudGVyO2Rpc3BsYXk6IGZsZXg7anVzdGlmeS1jb250ZW50OiBjZW50ZXI7Ij4KICA8ZGl2IHN0eWxlPSJmbG9hdDpsZWZ0OyI+CiAgICA8ZGl2PgogICAgPHNwYW4gc3R5bGU9ImZvbnQtc2l6ZToxNnB4O2ZvbnQtZmFtaWx5Ok1pY3Jvc29mdCBZYUhlaTtmb250LXdlaWdodDo0MDA7Y29sb3I6cmdiYSg4NSw4NSw4NSwxKTtsaW5lLWhlaWdodDozMHB4OyI+5ZKo6K+i5LiO5pyN5YqhPC9zcGFuPgogICAgICA8L2Rpdj4KICAgIDxkaXY+CiAgICAgPHNwYW4gc3R5bGU9ImZvbnQtc2l6ZToxMnB4O2ZvbnQtZmFtaWx5Ok1pY3Jvc29mdCBZYUhlaTtmb250LXdlaWdodDo0MDA7Y29sb3I6cmdiYSgxNDUsMTQ1LDE0NSwxKTtsaW5lLWhlaWdodDoyNHB4OyJvbmNsaWNrPSJqYXZhc2NyaXB0OndpbmRvdy5vcGVuKCdodHRwOi8vd3d3LmhvdGVudC5jb20vc29sdXRpb25zLmh0bWwnKSI+6Kej5Yaz5pa55qGIPC9zcGFuPgogICAgICA8L2Rpdj4KICAgIDxkaXY+CiAgICAgPHNwYW4gc3R5bGU9ImZvbnQtc2l6ZToxMnB4O2ZvbnQtZmFtaWx5Ok1pY3Jvc29mdCBZYUhlaTtmb250LXdlaWdodDo0MDA7Y29sb3I6cmdiYSgxNDUsMTQ1LDE0NSwxKTtsaW5lLWhlaWdodDoyNHB4OyJvbmNsaWNrPSJqYXZhc2NyaXB0OndpbmRvdy5vcGVuKCdodHRwOi8vd3d3LmhvdGVudC5jb20vcHJvZHVjdHMuaHRtbCcpIj7kuqflk4HkuK3lv4M8L3NwYW4+CiAgICAgIDwvZGl2PgogICAgPGRpdj4KICAgICA8c3BhbiBzdHlsZT0iZm9udC1zaXplOjEycHg7Zm9udC1mYW1pbHk6TWljcm9zb2Z0IFlhSGVpO2ZvbnQtd2VpZ2h0OjQwMDtjb2xvcjpyZ2JhKDE0NSwxNDUsMTQ1LDEpO2xpbmUtaGVpZ2h0OjI0cHg7Im9uY2xpY2s9ImphdmFzY3JpcHQ6d2luZG93Lm9wZW4oJ2h0dHA6Ly93d3cuaG90ZW50LmNvbS9jYXNlLmh0bWwnKSI+5a6i5oi35qGI5L6LPC9zcGFuPgogICAgICA8L2Rpdj4KICAgIDxkaXY+CiAgICAgPHNwYW4gc3R5bGU9ImZvbnQtc2l6ZToxMnB4O2ZvbnQtZmFtaWx5Ok1pY3Jvc29mdCBZYUhlaTtmb250LXdlaWdodDo0MDA7Y29sb3I6cmdiYSgxNDUsMTQ1LDE0NSwxKTtsaW5lLWhlaWdodDoyNHB4OyJvbmNsaWNrPSJqYXZhc2NyaXB0OndpbmRvdy5vcGVuKCdodHRwOi8vd3d3LmhvdGVudC5jb20vYnVzaW5lc3MuaHRtbCcpIj7kuJrliqHlkIjkvZw8L3NwYW4+CiAgICAgIDwvZGl2PgogIDwvZGl2PgogIDxkaXYgc3R5bGU9ImZsb2F0OmxlZnQ7IHBhZGRpbmctbGVmdDoxOTBweDsiPgogICAgPGRpdj4KICAgIDxzcGFuIHN0eWxlPSJmb250LXNpemU6MTZweDtmb250LWZhbWlseTpNaWNyb3NvZnQgWWFIZWk7Zm9udC13ZWlnaHQ6NDAwO2NvbG9yOnJnYmEoODUsODUsODUsMSk7bGluZS1oZWlnaHQ6MzBweDsiPuWSqOivouS4juacjeWKoTwvc3Bhbj4KICAgICAgPC9kaXY+CiAgICA8ZGl2PgogICAgIDxzcGFuIHN0eWxlPSJmb250LXNpemU6MTJweDtmb250LWZhbWlseTpNaWNyb3NvZnQgWWFIZWk7Zm9udC13ZWlnaHQ6NDAwO2NvbG9yOnJnYmEoMTQ1LDE0NSwxNDUsMSk7bGluZS1oZWlnaHQ6MjRweDsib25jbGljaz0iamF2YXNjcmlwdDp3aW5kb3cub3BlbignaHR0cDovL3d3dy5ob3RlbnQuY29tL2gtY29sLTEwOS5odG1sJykiPkhvdGVudCBFSVA8L3NwYW4+CiAgICAgIDwvZGl2PgogICAgPGRpdj4KICAgICA8c3BhbiBzdHlsZT0iZm9udC1zaXplOjEycHg7Zm9udC1mYW1pbHk6TWljcm9zb2Z0IFlhSGVpO2ZvbnQtd2VpZ2h0OjQwMDtjb2xvcjpyZ2JhKDE0NSwxNDUsMTQ1LDEpO2xpbmUtaGVpZ2h0OjI0cHg7Im9uY2xpY2s9ImphdmFzY3JpcHQ6d2luZG93Lm9wZW4oJ2h0dHA6Ly93d3cuaG90ZW50LmNvbS9oLWNvbC0xNTkuaHRtbCcpIj5Ib3RlbnQgTVMgQlBNPC9zcGFuPgogICAgICA8L2Rpdj4KICAgIDxkaXY+CiAgICAgPHNwYW4gc3R5bGU9ImZvbnQtc2l6ZToxMnB4O2ZvbnQtZmFtaWx5Ok1pY3Jvc29mdCBZYUhlaTtmb250LXdlaWdodDo0MDA7Y29sb3I6cmdiYSgxNDUsMTQ1LDE0NSwxKTtsaW5lLWh' WHERE ID = '1267779342914686976';
UPDATE PORTAL_SYS_COLUMN SET TEMPLATE_HTML=CONCAT(TEMPLATE_HTML, 'laWdodDoyNHB4OyJvbmNsaWNrPSJqYXZhc2NyaXB0OndpbmRvdy5vcGVuKCdodHRwOi8vd3d3LmhvdGVudC5jb20vaC1jb2wtMTUyLmh0bWwnKSI+SG90ZW50IFBvcnRhbDwvc3Bhbj4KICAgICAgPC9kaXY+CiAgICA8ZGl2PgogICAgIDxzcGFuIHN0eWxlPSJmb250LXNpemU6MTJweDtmb250LWZhbWlseTpNaWNyb3NvZnQgWWFIZWk7Zm9udC13ZWlnaHQ6NDAwO2NvbG9yOnJnYmEoMTQ1LDE0NSwxNDUsMSk7bGluZS1oZWlnaHQ6MjRweDsib25jbGljaz0iamF2YXNjcmlwdDp3aW5kb3cub3BlbignaHR0cDovL3d3dy5ob3RlbnQuY29tL2gtY29sLTE1My5odG1sJykiPkhvdGVudCBNb2JpbGU8L3NwYW4+CiAgICAgIDwvZGl2PgogIDwvZGl2PgogIDxkaXYgc3R5bGU9ImZsb2F0OmxlZnQ7IHBhZGRpbmctbGVmdDoxOTBweDtwYWRkaW5nLXRvcDoxMHB4Ij4KICAgICA8ZGl2IHN0eWxlPSJmbG9hdDpsZWZ0OyI+CiAgPGltZyBzcmM9Ii9tdnVlL2ltZy93ZWJzaXRlLXFyY29kZS5qcGciICBzdHlsZT0id2lkdGg6OTBweDtoZWlnaHQ6OTBweDtiYWNrZ3JvdW5kOnJnYmEoMjQ1LDI0NSwyNDUsMSk7Ij48YnIvPgogICAgPHNwYW4gc3R5bGU9ImZvbnQtc2l6ZToxMnB4O2ZvbnQtZmFtaWx5Ok1pY3Jvc29mdCBZYUhlaTtmb250LXdlaWdodDo0MDA7Y29sb3I6cmdiYSgxNDUsMTQ1LDE0NSwxKTtsaW5lLWhlaWdodDoyNHB4OyI+5a6P5aSp5a6Y572RPC9zcGFuPiAKICAgIDwvZGl2PgogICAgPGRpdiBzdHlsZT0iZmxvYXQ6cmlnaHQ7cGFkZGluZy1sZWZ0OjIwcHg7Ij4KICA8aW1nIHNyYz0iL212dWUvaW1nL2d6aC1xcmNvZGUuanBnIiAgc3R5bGU9IndpZHRoOjkwcHg7aGVpZ2h0OjkwcHg7YmFja2dyb3VuZDpyZ2JhKDI0NSwyNDUsMjQ1LDEpOyI+PGJyLz4KICAgIDxzcGFuIHN0eWxlPSJmb250LXNpemU6MTJweDtmb250LWZhbWlseTpNaWNyb3NvZnQgWWFIZWk7Zm9udC13ZWlnaHQ6NDAwO2NvbG9yOnJnYmEoMTQ1LDE0NSwxNDUsMSk7bGluZS1oZWlnaHQ6MjRweDsiPuWuj+WkqeWFrOS8l+WPtzwvc3Bhbj4gCiAgICA8L2Rpdj4KICA8L2Rpdj4KICA8ZGl2IHN0eWxlPSJmbG9hdDpsZWZ0O3BhZGRpbmctbGVmdDoxOTBweDsiPgogICAgPGRpdj4KICAgIDxzcGFuIHN0eWxlPSJmb250LXNpemU6MTZweDtmb250LWZhbWlseTpNaWNyb3NvZnQgWWFIZWk7Zm9udC13ZWlnaHQ6NDAwO2NvbG9yOnJnYmEoODUsODUsODUsMSk7bGluZS1oZWlnaHQ6MzBweDsiPuiBlOezu+aIkeS7rDwvc3Bhbj4KICAgICAgPC9kaXY+CiAgICA8ZGl2PgogICAgIDxzcGFuIHN0eWxlPSJmb250LXNpemU6MTJweDtmb250LWZhbWlseTpNaWNyb3NvZnQgWWFIZWk7Zm9udC13ZWlnaHQ6NDAwO2NvbG9yOnJnYmEoMTQ1LDE0NSwxNDUsMSk7bGluZS1oZWlnaHQ6MjRweDsiPuWFrOWPuOeUteivne+8mjAyMC04OTA4OTEyMzwvc3Bhbj4KICAgICAgPC9kaXY+CiAgICA8ZGl2PgogICAgIDxzcGFuIHN0eWxlPSJmb250LXNpemU6MTJweDtmb250LWZhbWlseTpNaWNyb3NvZnQgWWFIZWk7Zm9udC13ZWlnaHQ6NDAwO2NvbG9yOnJnYmEoMTQ1LDE0NSwxNDUsMSk7bGluZS1oZWlnaHQ6MjRweDsiPuS8oOecn+WPt+egge+8mjAyMC04OTA4OTM2Njwvc3Bhbj4KICAgICAgPC9kaXY+CiAgICA8ZGl2PgogICAgIDxzcGFuIHN0eWxlPSJmb250LXNpemU6MTJweDtmb250LWZhbWlseTpNaWNyb3NvZnQgWWFIZWk7Zm9udC13ZWlnaHQ6NDAwO2NvbG9yOnJnYmEoMTQ1LDE0NSwxNDUsMSk7bGluZS1oZWlnaHQ6MjRweDsiPuaKgOacryBR576k77yaMTQyMjE1NjMxPC9zcGFuPgogICAgICA8L2Rpdj4KICAgIDxkaXY+CiAgICAgPHNwYW4gc3R5bGU9ImZvbnQtc2l6ZToxMnB4O2ZvbnQtZmFtaWx5Ok1pY3Jvc29mdCBZYUhlaTtmb250LXdlaWdodDo0MDA7Y29sb3I6cmdiYSgxNDUsMTQ1LDE0NSwxKTtsaW5lLWhlaWdodDoyNHB4OyI+6YKu5pS/57yW5Y+377yaNTEwMzA4PC9zcGFuPgogICAgICA8L2Rpdj4KICA8L2Rpdj4KPC9kaXY+CiAgICAgICAgICAgICAgICAgICAgICAgICAgICA=') WHERE ID = '1267779342914686976';
UPDATE PORTAL_SYS_COLUMN SET TEMPLATE_HTML = 'PGRpdiBzdHlsZT0icGFkZGluZy10b3A6MTBweDtwYWRkaW5nLWJvdHRvbToxMHB4O3RleHQtYWxpZ246Y2VudGVyO2Rpc3BsYXk6IGZsZXg7anVzdGlmeS1jb250ZW50OiBjZW50ZXI7Ij4KICA8ZGl2IHN0eWxlPSJmbG9hdDpsZWZ0OyI+CiAgICA8ZGl2PgogICAgPHNwYW4gc3R5bGU9ImZvbnQtc2l6ZToxNnB4O2ZvbnQtZmFtaWx5Ok1pY3Jvc29mdCBZYUhlaTtmb250LXdlaWdodDo0MDA7Y29sb3I6cmdiYSg4NSw4NSw4NSwxKTtsaW5lLWhlaWdodDozMHB4OyI+5ZKo6K+i5LiO5pyN5YqhPC9zcGFuPgogICAgICA8L2Rpdj4KICAgIDxkaXY+CiAgICAgPHNwYW4gc3R5bGU9ImZvbnQtc2l6ZToxMnB4O2ZvbnQtZmFtaWx5Ok1pY3Jvc29mdCBZYUhlaTtmb250LXdlaWdodDo0MDA7Y29sb3I6cmdiYSgxNDUsMTQ1LDE0NSwxKTtsaW5lLWhlaWdodDoyNHB4OyJvbmNsaWNrPSJqYXZhc2NyaXB0OndpbmRvdy5vcGVuKCdodHRwOi8vd3d3LmhvdGVudC5jb20vc29sdXRpb25zLmh0bWwnKSI+6Kej5Yaz5pa55qGIPC9zcGFuPgogICAgICA8L2Rpdj4KICAgIDxkaXY+CiAgICAgPHNwYW4gc3R5bGU9ImZvbnQtc2l6ZToxMnB4O2ZvbnQtZmFtaWx5Ok1pY3Jvc29mdCBZYUhlaTtmb250LXdlaWdodDo0MDA7Y29sb3I6cmdiYSgxNDUsMTQ1LDE0NSwxKTtsaW5lLWhlaWdodDoyNHB4OyJvbmNsaWNrPSJqYXZhc2NyaXB0OndpbmRvdy5vcGVuKCdodHRwOi8vd3d3LmhvdGVudC5jb20vcHJvZHVjdHMuaHRtbCcpIj7kuqflk4HkuK3lv4M8L3NwYW4+CiAgICAgIDwvZGl2PgogICAgPGRpdj4KICAgICA8c3BhbiBzdHlsZT0iZm9udC1zaXplOjEycHg7Zm9udC1mYW1pbHk6TWljcm9zb2Z0IFlhSGVpO2ZvbnQtd2VpZ2h0OjQwMDtjb2xvcjpyZ2JhKDE0NSwxNDUsMTQ1LDEpO2xpbmUtaGVpZ2h0OjI0cHg7Im9uY2xpY2s9ImphdmFzY3JpcHQ6d2luZG93Lm9wZW4oJ2h0dHA6Ly93d3cuaG90ZW50LmNvbS9jYXNlLmh0bWwnKSI+5a6i5oi35qGI5L6LPC9zcGFuPgogICAgICA8L2Rpdj4KICAgIDxkaXY+CiAgICAgPHNwYW4gc3R5bGU9ImZvbnQtc2l6ZToxMnB4O2ZvbnQtZmFtaWx5Ok1pY3Jvc29mdCBZYUhlaTtmb250LXdlaWdodDo0MDA7Y29sb3I6cmdiYSgxNDUsMTQ1LDE0NSwxKTtsaW5lLWhlaWdodDoyNHB4OyJvbmNsaWNrPSJqYXZhc2NyaXB0OndpbmRvdy5vcGVuKCdodHRwOi8vd3d3LmhvdGVudC5jb20vYnVzaW5lc3MuaHRtbCcpIj7kuJrliqHlkIjkvZw8L3NwYW4+CiAgICAgIDwvZGl2PgogIDwvZGl2PgogIDxkaXYgc3R5bGU9ImZsb2F0OmxlZnQ7IHBhZGRpbmctbGVmdDoxOTBweDsiPgogICAgPGRpdj4KICAgIDxzcGFuIHN0eWxlPSJmb250LXNpemU6MTZweDtmb250LWZhbWlseTpNaWNyb3NvZnQgWWFIZWk7Zm9udC13ZWlnaHQ6NDAwO2NvbG9yOnJnYmEoODUsODUsODUsMSk7bGluZS1oZWlnaHQ6MzBweDsiPuWSqOivouS4juacjeWKoTwvc3Bhbj4KICAgICAgPC9kaXY+CiAgICA8ZGl2PgogICAgIDxzcGFuIHN0eWxlPSJmb250LXNpemU6MTJweDtmb250LWZhbWlseTpNaWNyb3NvZnQgWWFIZWk7Zm9udC13ZWlnaHQ6NDAwO2NvbG9yOnJnYmEoMTQ1LDE0NSwxNDUsMSk7bGluZS1oZWlnaHQ6MjRweDsib25jbGljaz0iamF2YXNjcmlwdDp3aW5kb3cub3BlbignaHR0cDovL3d3dy5ob3RlbnQuY29tL2gtY29sLTEwOS5odG1sJykiPkhvdGVudCBFSVA8L3NwYW4+CiAgICAgIDwvZGl2PgogICAgPGRpdj4KICAgICA8c3BhbiBzdHlsZT0iZm9udC1zaXplOjEycHg7Zm9udC1mYW1pbHk6TWljcm9zb2Z0IFlhSGVpO2ZvbnQtd2VpZ2h0OjQwMDtjb2xvcjpyZ2JhKDE0NSwxNDUsMTQ1LDEpO2xpbmUtaGVpZ2h0OjI0cHg7Im9uY2xpY2s9ImphdmFzY3JpcHQ6d2luZG93Lm9wZW4oJ2h0dHA6Ly93d3cuaG90ZW50LmNvbS9oLWNvbC0xNTk' WHERE ID = '1267789510905827328';
UPDATE PORTAL_SYS_COLUMN SET TEMPLATE_HTML=CONCAT(TEMPLATE_HTML, 'uaHRtbCcpIj5Ib3RlbnQgTVMgQlBNPC9zcGFuPgogICAgICA8L2Rpdj4KICAgIDxkaXY+CiAgICAgPHNwYW4gc3R5bGU9ImZvbnQtc2l6ZToxMnB4O2ZvbnQtZmFtaWx5Ok1pY3Jvc29mdCBZYUhlaTtmb250LXdlaWdodDo0MDA7Y29sb3I6cmdiYSgxNDUsMTQ1LDE0NSwxKTtsaW5lLWhlaWdodDoyNHB4OyJvbmNsaWNrPSJqYXZhc2NyaXB0OndpbmRvdy5vcGVuKCdodHRwOi8vd3d3LmhvdGVudC5jb20vaC1jb2wtMTUyLmh0bWwnKSI+SG90ZW50IFBvcnRhbDwvc3Bhbj4KICAgICAgPC9kaXY+CiAgICA8ZGl2PgogICAgIDxzcGFuIHN0eWxlPSJmb250LXNpemU6MTJweDtmb250LWZhbWlseTpNaWNyb3NvZnQgWWFIZWk7Zm9udC13ZWlnaHQ6NDAwO2NvbG9yOnJnYmEoMTQ1LDE0NSwxNDUsMSk7bGluZS1oZWlnaHQ6MjRweDsib25jbGljaz0iamF2YXNjcmlwdDp3aW5kb3cub3BlbignaHR0cDovL3d3dy5ob3RlbnQuY29tL2gtY29sLTE1My5odG1sJykiPkhvdGVudCBNb2JpbGU8L3NwYW4+CiAgICAgIDwvZGl2PgogIDwvZGl2PgogIDxkaXYgc3R5bGU9ImZsb2F0OmxlZnQ7IHBhZGRpbmctbGVmdDoxOTBweDtwYWRkaW5nLXRvcDoxMHB4Ij4KICAgICA8ZGl2IHN0eWxlPSJmbG9hdDpsZWZ0OyI+CiAgPGltZyBzcmM9Ii9tdnVlL2ltZy93ZWJzaXRlLXFyY29kZS5qcGciICBzdHlsZT0id2lkdGg6OTBweDtoZWlnaHQ6OTBweDtiYWNrZ3JvdW5kOnJnYmEoMjQ1LDI0NSwyNDUsMSk7Ij48YnIvPgogICAgPHNwYW4gc3R5bGU9ImZvbnQtc2l6ZToxMnB4O2ZvbnQtZmFtaWx5Ok1pY3Jvc29mdCBZYUhlaTtmb250LXdlaWdodDo0MDA7Y29sb3I6cmdiYSgxNDUsMTQ1LDE0NSwxKTtsaW5lLWhlaWdodDoyNHB4OyI+5a6P5aSp5a6Y572RPC9zcGFuPiAKICAgIDwvZGl2PgogICAgPGRpdiBzdHlsZT0iZmxvYXQ6cmlnaHQ7cGFkZGluZy1sZWZ0OjIwcHg7Ij4KICA8aW1nIHNyYz0iL212dWUvaW1nL2d6aC1xcmNvZGUuanBnIiAgc3R5bGU9IndpZHRoOjkwcHg7aGVpZ2h0OjkwcHg7YmFja2dyb3VuZDpyZ2JhKDI0NSwyNDUsMjQ1LDEpOyI+PGJyLz4KICAgIDxzcGFuIHN0eWxlPSJmb250LXNpemU6MTJweDtmb250LWZhbWlseTpNaWNyb3NvZnQgWWFIZWk7Zm9udC13ZWlnaHQ6NDAwO2NvbG9yOnJnYmEoMTQ1LDE0NSwxNDUsMSk7bGluZS1oZWlnaHQ6MjRweDsiPuWuj+WkqeWFrOS8l+WPtzwvc3Bhbj4gCiAgICA8L2Rpdj4KICA8L2Rpdj4KICA8ZGl2IHN0eWxlPSJmbG9hdDpsZWZ0O3BhZGRpbmctbGVmdDoxOTBweDsiPgogICAgPGRpdj4KICAgIDxzcGFuIHN0eWxlPSJmb250LXNpemU6MTZweDtmb250LWZhbWlseTpNaWNyb3NvZnQgWWFIZWk7Zm9udC13ZWlnaHQ6NDAwO2NvbG9yOnJnYmEoODUsODUsODUsMSk7bGluZS1oZWlnaHQ6MzBweDsiPuiBlOezu+aIkeS7rDwvc3Bhbj4KICAgICAgPC9kaXY+CiAgICA8ZGl2PgogICAgIDxzcGFuIHN0eWxlPSJmb250LXNpemU6MTJweDtmb250LWZhbWlseTpNaWNyb3NvZnQgWWFIZWk7Zm9udC13ZWlnaHQ6NDAwO2NvbG9yOnJnYmEoMTQ1LDE0NSwxNDUsMSk7bGluZS1oZWlnaHQ6MjRweDsiPuWFrOWPuOeUteivne+8mjAyMC04OTA4OTEyMzwvc3Bhbj4KICAgICAgPC9kaXY+CiAgICA8ZGl2PgogICAgIDxzcGFuIHN0eWxlPSJmb250LXNpemU6MTJweDtmb250LWZhbWlseTpNaWNyb3NvZnQgWWFIZWk7Zm9udC13ZWlnaHQ6NDAwO2NvbG9yOnJnYmEoMTQ1LDE0NSwxNDUsMSk7bGluZS1oZWlnaHQ6MjRweDsiPuS8oOecn+WPt+egge+8mjAyMC04OTA4OTM2Njwvc3Bhbj4KICAgICAgPC9kaXY+CiAgICA8ZGl2PgogICAgIDxzcGFuIHN0eWxlPSJmb250LXNpemU6MTJweDtmb250LWZhbWlseTpNaWNyb3NvZnQgWWFIZWk7Zm9udC13ZWlnaHQ6NDAwO2NvbG9yOnJnYmEoMTQ1LDE0NSwxNDUsMSk7bGluZS1oZWlnaHQ6MjRweDsiPuaKgOacryBR576k77yaMTQyMjE1NjMxPC9zcGFuPgogICAgICA8L2Rpdj4KICAgIDxkaXY+CiAgICAgPHNwYW4gc3R5bGU9ImZvbnQtc2l6ZToxMnB4O2ZvbnQtZmFtaWx5Ok1pY3Jvc29mdCBZYUhlaTtmb250LXdlaWdodDo0MDA7Y29sb3I6cmdiYSgxNDUsMTQ1LDE0NSwxKTtsaW5lLWhlaWdodDoyNHB4OyI+6YKu5pS/57yW5Y+377yaNTEwMzA4PC9zcGFuPgogICAgICA8L2Rpdj4KICA8L2Rpdj4KPC9kaXY+CiAgICAgICAgICAgICAgICAgICAgICAgICAgICA=') WHERE ID = '1267789510905827328';
-- 2020-09-15 李洪桥 应用中心报错问题
alter table portal_sys_app alter column is_publish_ type varchar(1) using is_publish_::varchar(1);
-- 2020-09-15 李洪桥 首页报错问题
alter table portal_sys_my_layout alter column user_id type varchar(64) using user_id::varchar(64);
-- 2020-09-16 lingpj 日志配置模块名调整
UPDATE PORTAL_SYS_LOGS_SETTINGS SET MODULE_TYPE_ = 'eip-form' WHERE ID_ = '3';
UPDATE PORTAL_SYS_LOGS_SETTINGS SET MODULE_TYPE_ = 'eip-bpm-model' WHERE ID_ = '4';
UPDATE PORTAL_SYS_LOGS_SETTINGS SET MODULE_TYPE_ = 'eip-bpm-runtime' WHERE ID_ = '5';
-- 手机端信息台(功能迁移)
create table portal_sys_news_column
(
ID_ varchar(64) not null,
PORTAL_NEWS_ID_ VARCHAR(64),
NAME_ VARCHAR(255),
TYPE_ VARCHAR(10),
TENANT_ID_ VARCHAR(64)
);
comment on column portal_sys_news_column.ID_ is '主键';
comment on column portal_sys_news_column.PORTAL_NEWS_ID_ is '公告Id';
comment on column portal_sys_news_column.NAME_ is '公告名称';
comment on column portal_sys_news_column.TYPE_ is '类型';
comment on column portal_sys_news_column.TENANT_ID_ is '租户Id';
-- 添加新闻公告栏目
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_) VALUES ('1295248036242526208', '信息台', 'csxwgg', null, 0, 3, '${portal}/sysIndexNewsColumn/v1/getAllList', null, null, 327, null, 'PGluZGV4TmV3c0NvbHVtbiAgOmRhdGFMaXN0PSJkYXRhIiA+PC9pbmRleE5ld3NDb2x1bW4+Cg==', 1, null, null, null, null, null, 0, null, null, '1', '1', '2020-08-17 14:36:11', '2020-08-17 14:58:24', null, null, null, '-1');
-- 2020-09-17 表ACT_GE_BYTEARRAY的generated_修改类型
alter table ACT_GE_BYTEARRAY drop column if exists generated_;
alter table ACT_GE_BYTEARRAY add column generated_ bool;
-- 2020/09/17 李洪桥 新闻公告添加是否已发布到手机端的表示
alter table portal_news_tree_
add MOBILE_ISSUE_ integer;
comment on column portal_news_tree_.MOBILE_ISSUE_ is '手机端是否发布 0:未发布 1:发布';
-- 更新移动端默认布局-20200918-lucong
UPDATE portal_sys_layout_manage SET DESIGN_HTML='eyJsaXN0IjpbeyJ0eXBlIjoiZ3JpZCIsIm5hbWUiOiLmoIXmoLzluIPlsYAiLCJpY29uIjoiaWNvbi1ncmlkIiwiY29sdW1ucyI6W3sic3BhbiI6MjQsImxpc3QiOlt7Im5hbWUiOiLmrKLov47kvb/nlKjnp7vliqjnq68iLCJhbGlhcyI6Im1vYmlsZWdyeHgiLCJvcHRpb25zIjp7InJlbW90ZUZ1bmMiOiJmdW5jXzE1OTExNDkxNDcwMDBfMTg2MzUifSwia2V5IjoiMTU5MTE0OTE0NzAwMF8xODYzNSIsIm1vZGVsIjoidW5kZWZpbmVkXzE1OTExNDkxNDcwMDBfMTg2MzUiLCJydWxlcyI6W119XX1dLCJvcHRpb25zIjp7Imd1dHRlciI6MCwianVzdGlmeSI6InN0YXJ0IiwiYWxpZ24iOiJ0b3AiLCJyZW1vdGVGdW5jIjoiZnVuY18xNTkxMTQ5MTE5MDAwXzE2MTcyIn0sImtleSI6IjE1OTExNDkxMTkwMDBfMTYxNzIiLCJtb2RlbCI6ImdyaWRfMTU5MTE0OTExOTAwMF8xNjE3MiIsInJ1bGVzIjpbXX0seyJ0eXBlIjoiZ3JpZCIsIm5hbWUiOiLmoIXmoLzluIPlsYAiLCJpY29uIjoiaWNvbi1ncmlkIiwiY29sdW1ucyI6W3sic3BhbiI6MjQsImxpc3QiOlt7Im5hbWUiOiLnp7vliqjnq6/mlbDmja7lj7AiLCJhbGlhcyI6InlkZHNqdCIsIm9wdGlvbnMiOnsicmVtb3RlRnVuYyI6ImZ1bmNfMTU5MTE0OTE0ODAwMF81MzcyOSJ9LCJrZXkiOiIxNTkxMTQ5MTQ4MDAwXzUzNzI5IiwibW9kZWwiOiJ1bmRlZmluZWRfMTU5MTE0OTE0ODAwMF81MzcyOSIsInJ1bGVzIjpbXX1dfV0sIm9wdGlvbnMiOnsiZ3V0dGVyIjowLCJqdXN0aWZ5Ijoic3RhcnQiLCJhbGlnbiI6InRvcCIsInJlbW90ZUZ1bmMiOiJmdW5jXzE1OTExNDkxMzIwMDBfNzEyOTEifSwia2V5IjoiMTU5MTE0OTEzMjAwMF83MTI5MSIsIm1vZGVsIjoiZ3JpZF8xNTkxMTQ5MTMyMDAwXzcxMjkxIiwicnVsZXMiOltdfSx7InR5cGUiOiJncmlkIiwibmFtZSI6IuagheagvOW4g+WxgCIsImljb24iOiJpY29uLWdyaWQiLCJjb2x1bW5zIjpbeyJzcGFuIjoyNCwibGlzdCI6W3sibmFtZSI6IuS/oeaBr+WPsCIsImFsaWFzIjoiY3N4d2dnIiwib3B0aW9ucyI6eyJyZW1vdGVGdW5jIjoiZnVuY18xNjAwMzM5NzI5MDAwXzUzMzYifSwia2V5IjoiMTYwMDMzOTcyOTAwMF81MzM2IiwibW9kZWwiOiJ1bmRlZmluZWRfMTYwMDMzOTcyOTAwMF81MzM2IiwicnVsZXMiOltdfV19XSwib3B0aW9ucyI6eyJndXR0ZXIiOjAsImp1c3RpZnkiOiJzdGFydCIsImFsaWduIjoidG9wIiwicmVtb3RlRnVuYyI6ImZ1bmNfMTU5MTE0OTEzOTAwMF8yNzcwNCJ9LCJrZXkiOiIxNTkxMTQ5MTM5MDAwXzI3NzA0IiwibW9kZWwiOiJncmlkXzE1OTExNDkxMzkwMDBfMjc3MDQiLCJydWxlcyI6W119XSwiY29uZmlnIjp7ImxhYmVsV2lkdGgiOjEwMCwibGFiZWxQb3NpdGlvbiI6InJpZ2h0Iiwic2l6ZSI6InNtYWxsIn19' WHERE id='1';
-- 更新移动端栏目名称-20200918-lucong
UPDATE PORTAL_SYS_COLUMN SET NAME='数据台' WHERE ID='1267991710768697344';
UPDATE PORTAL_SYS_COLUMN SET NAME='欢迎使用宏天EIP' WHERE ID='1267991368769343488';
-- 移动端数据台展示效果-20200918-lucong
UPDATE PORTAL_SYS_COLUMN SET
TEMPLATE_HTML='PGRpdiBpZD0iYXBwIj4KPGVsLXJvdyA6Z3V0dGVyPSIyMCIgc3R5bGU9InBhZGRpbmctdG9wOjZweDtwYWRkaW5nLWJvdHRvbTo1cHg7Ij4KICA8ZWwtY29sIDpzcGFuPSI4Ij4KIDxkaXY+CiAgICA8cm91dGVyLWxpbmsgdG89Ii93b3JrL215TWF0dGVycyIgdGFnPSJkaXYiPgogICAgICAgIDxkaXYgY2xhc3M9ImNvbnRhaW5lciI+CiAgICAgICAgICAgICAgICA8ZGl2IGNsYXNzPSJjb250YWluZXJfaWNvbiBpY29uX19ibHVlX19iZyI+5YqePC9kaXY+CiAgICAgICAgICAgICAgICA8ZGl2IGNsYXNzPSJjb250YWluZXJfYm94Ij4gCiAgICAgICAgICAgICAgICAgICAgPHAgY2xhc3M9ImNvbnRhaW5lcl9ib3hfdGl0bGUiPuaIkeeahOW+heWKnjwvcD4KICAgICAgICAgICAgICAgICAgICA8cCBjbGFzcz0iY29udGFpbmVyX2JveF9jb3VudCI+KHt7ZGF0YS5teVRha3MuZGF0YVRleHR9fSk8L3A+CiAgICAgICAgICAgICAgICA8L2Rpdj4KICAgICAgICA8L2Rpdj4KICAgIDwvcm91dGVyLWxpbms+CiAgPC9kaXY+CiAgPC9lbC1jb2w+CiAgPGVsLWNvbCA6c3Bhbj0iOCI+CiAgICAgPGRpdj4KCSA8cm91dGVyLWxpbmsgdG89Ii93b3JrL215UmVxdWVzdCIgdGFnPSJkaXYiPgogICAgICAgIDxkaXYgY2xhc3M9ImNvbnRhaW5lciI+CiAgICAgICAgICAgICAgICA8ZGl2IGNsYXNzPSJjb250YWluZXJfaWNvbiBpY29uX19waW5rX19iZyI+6K+3PC9kaXY+CiAgICAgICAgICAgICAgICA8ZGl2IGNsYXNzPSJjb250YWluZXJfYm94Ij4gCiAgICAgICAgICAgICAgICAgICAgPHAgY2xhc3M9ImNvbnRhaW5lcl9ib3hfdGl0bGUiPuaIkeeahOivt+axgjwvcD4KICAgICAgICAgICAgICAgICAgICA8cCBjbGFzcz0iY29udGFpbmVyX2JveF9jb3VudCI+KHt7ZGF0YS5teVJlcXVlc3QuZGF0YVRleHR9fSk8L3A+CiAgICAgICAgICAgICAgICA8L2Rpdj4KICAgICAgICA8L2Rpdj4KICAgPC9yb3V0ZXItbGluaz4KICAgIDwvZGl2PgogIDwvZWwtY29sPgogIDxlbC1jb2wgOnNwYW49IjgiPgogICAgIDxkaXY+CgkgPHJvdXRlci1saW5rIHRvPSIvd29yay9teU1hdHRlcnMvMSIgdGFnPSJkaXYiPgogICAgICAgIDxkaXYgY2xhc3M9ImNvbnRhaW5lciI+CiAgICAgICAgICAgICAgICA8ZGl2IGNsYXNzPSJjb250YWluZXJfaWNvbiBpY29uX19kZWVwX19ibHVlX19iZyI+5a6aPC9kaXY+CiAgICAgICAgICAgICAgICA8ZGl2IGNsYXNzPSJjb250YWluZXJfYm94Ij4gCiAgICAgICAgICAgICAgICAgICAgPHAgY2xhc3M9ImNvbnRhaW5lcl9ib3hfdGl0bGUiPuaIkeeahOW3suWKnjwvcD4KICAgICAgICAgICAgICAgICAgICA8cCBjbGFzcz0iY29udGFpbmVyX2JveF9jb3VudCI+KHt7ZGF0YS5teUFscmVhZHkuZGF0YVRleHR9fSk8L3A+CiAgICAgICAgICAgICAgICA8L2Rpdj4KICAgICAgICA8L2Rpdj4KICAgIDwvcm91dGVyLWxpbms+CiAgICA8L2Rpdj4KICA8L2VsLWNvbD4KPC9lbC1yb3c+CjxlbC1yb3cgOmd1dHRlcj0iMjAiIHN0eWxlPSJwYWRkaW5nLWJvdHRvbTo1cHg7cGFkZGluZy10b3A6IDVweDsiPgogIDxlbC1jb2wgOnNwYW49IjgiPgogICAgIDxkaXYgPgoJIDxyb3V0ZXItbGluayB0bz0iL3dvcmsvbXlOb3RpY2UiIHRhZz0iZGl2Ij4KICAgICAgICA8ZGl2IGNsYXNzPSJjb250YWluZXIiPgogICAgICAgICAgICA8ZGl2IGNsYXNzPSJjb250YWluZXJfaWNvbiBpY29uX195ZWxsb3dfX2JnIj7pmIU8L2Rpdj4KICAgICAgICAgICAgPGRpdiBjbGFzcz0iY29udGFpbmVyX2JveCI+IAogICAgICAgICAgICAgICAgPHAgY2xhc3M9ImNvbnRhaW5lcl9ib3hfdGl0bGUiPuaIkeeahOS8oOmYhTwvcD4KICAgICAgICAgICAgICAgIDxwIGNsYXNzPSJjb250YWluZXJfYm94X2NvdW50Ij4oe3tkYXRhLm15Tm90aWNlUmVhZC5kYXRhVGV4dH19KTwvcD4KICAgICAgICAgICAgPC9kaXY+CiAgICAgICAgPC9kaXY+CiAgICA8L3JvdXRlci1saW5rPgo8L2Rpdj4KICAgIAogIDwvZWwtY29sPgogIDxlbC1jb2wgOnNwYW49IjgiPgogICAgIDxkaXY+CgkgPHJvdXRlci1saW5rIHRvPSIvd29yay9NeVR1cm5PdXRMaXN0IiB0YWc9ImRpdiI+CiAgICAgPGRpdiBjbGFzcz0iY29udGFpbmVyIj4KICAgICAgICA8ZGl2IGNsYXNzPSJjb250YWluZXJfaWNvbiBpY29uX19wdXJwbGVfX2JnIj7ovaw8L2Rpdj4KICAgICAgICA8ZGl2IGNsYXNzPSJjb250YWluZXJfYm94Ij4gCiAgICAgICAgICAgIDxwIGNsYXNzPSJjb250YWluZXJfYm94X3RpdGxlIj7miJHnmoTovazlip48L3A+CiAgICAgICAgPC9kaXY+CiAgICA8L2Rpdj4KICAgPC9yb3V0ZXItbGluaz4KICAgIDwvZGl2PgogIDwvZWwtY29sPgogIDxlbC1jb2wgOnNwYW49IjgiPgogICAgIDxkaXY+CgkgPHJvdXRlci1saW5rIHRvPSIvd29yay9zdGFydEZsb3dMaXN0IiB0YWc9ImRpdiI+CiAgICAgPGRpdiBjbGFzcz0iY29udGFpbmVyIj4KICAgICAgICAgICAgPGRpdiBjbGFzcz0iY29udGFpbmVyX2ljb24gaWNvbl9fZ3JlZW5fX2JnIj7lu7o8L2Rpdj4KICAgICAgICAgICAgPGRpdiBjbGFzcz0iY29udGFpbmVyX2JveCI+IAogICAgICAgICAgICAgICAgPHAgY2xhc3M9ImNvbnRhaW5lcl9ib3hfdGl0bGUiPuaWsOW7uua1geeoizwvcD4KICAgICAgICAgICAgPC9kaXY+CiAgICA8L2Rpdj4KICAgPC9yb3V0ZXItbGluaz4KICAgIDwvZGl2PgogIDwvZWwtY29sPgo8L2VsLXJvdz4KPC9kaXY+',COL_HEIGHT='250' WHERE ID ='1267991710768697344';
-- 2020-09-18 赵祥云 租户参数 添加按CODE_(参数编号)、TENANT_ID_(租户ID)、TENANT_TYPE_ID_(租户类型ID)唯一索引
DROP INDEX IDX_PARAM_CODE;
CREATE UNIQUE INDEX IDX_PARAM_CODE ON UC_PARAMS (CODE_,TENANT_ID_,TENANT_TYPE_ID_);
-- 2020-09-18 邱喜达 应用中心字段修改
ALTER TABLE PORTAL_SYS_APP RENAME PAGE_ TO MENU_ID_;
ALTER TABLE PORTAL_SYS_APP ALTER COLUMN MENU_ID_ TYPE VARCHAR(64);
COMMENT ON COLUMN PORTAL_SYS_APP.MENU_ID_ IS '菜单ID';
ALTER TABLE PORTAL_SYS_APP ALTER COLUMN ICON_ TYPE TEXT;
INSERT INTO portal_sys_menu(ID_, PARENT_ID_, NAME_, ALIAS_, ACTIVE_TAB_, MENU_ICON_, OPENED_, SN_, TABS_STYLE_, PATH_, HREF_, TENANT_ID_) VALUES ('4', '-1', '应用分类菜单', 'app_menu', '', '', 1, 3, '{\"tabType\":\"border-card\"}', '-1.4.', NULL, '-1');
-- 2020-09-18 张耀祥 打印模板添加字段
-- ALTER TABLE `form_print_template`
-- ADD COLUMN `SCRIPT_STR_` clob AFTER `ALIAS_`;
-- 2020-09-21 曾善铜 初始化语句修改
alter table form_print_template
add SCRIPT_STR_ text;
-- 2020-9-22 pgsql附件上传选择数据库类型时,文件上传失败
ALTER TABLE "portal_sys_file"
ALTER COLUMN "bytes_" TYPE bytea USING "bytes_"::bytea;
-- 2020-09-23 表act_re_procdef的字段has_start_form_key_、has_graphical_notation_修改类型
alter table act_re_procdef drop column if exists has_start_form_key_;
alter table act_re_procdef add column has_start_form_key_ bool;
alter table act_re_procdef drop column if exists has_graphical_notation_;
alter table act_re_procdef add column has_graphical_notation_ bool;
-- 2020-09-23 表act_ru_execution字段修改类型
alter table act_ru_execution drop column if exists is_active_;
alter table act_ru_execution add column is_active_ bool;
alter table act_ru_execution drop column if exists is_concurrent_;
alter table act_ru_execution add column is_concurrent_ bool;
alter table act_ru_execution drop column if exists is_scope_;
alter table act_ru_execution add column is_scope_ bool;
alter table act_ru_execution drop column if exists is_event_scope_;
alter table act_ru_execution add column is_event_scope_ bool;
--2020-09-23 表portal_sys_app修改字段类型
alter table portal_sys_app alter column is_publish_ type smallint using is_publish_::smallint;
-- 2020-9-23 唐鑫 添加设置任务执行人消息模板
INSERT INTO PORTAL_SYS_MSG_TPL(ID_, NAME_, KEY_, TYPE_KEY_, IS_DEFAULT_, SUBJECT_, PLAIN_, HTML_, CREATE_BY_, CREATE_TIME_, CREATE_ORG_ID_, UPDATE_BY_, UPDATE_TIME_, SMS_TEMPLATE_NO_, VOICE_TEMPLATE_NO_, TENANT_ID_) VALUES ('21', '设置任务执行人', 'bpmtasksetexecutors-default', 'bpmtasksetexecutors', '1', '设置任务执行人通知', '设置任务执行人:${taskSubject},意见:${cause}。', '设置任务执行人:<a href=\"#\">${taskSubject}</a>,意见:${cause}。', null, null, null, null, null, null, null, '-1');
-- 2020-09-25 lingpj postgresql 定时计划表字段类型调整
ALTER TABLE QRTZ_JOB_DETAILS ALTER COLUMN IS_DURABLE TYPE VARCHAR(64) USING IS_DURABLE::VARCHAR(64);
UPDATE QRTZ_JOB_DETAILS SET IS_DURABLE='true' WHERE IS_DURABLE = '1';
UPDATE QRTZ_JOB_DETAILS SET IS_DURABLE='false' WHERE IS_DURABLE = '0';
ALTER TABLE QRTZ_JOB_DETAILS ALTER COLUMN IS_DURABLE TYPE BOOLEAN USING IS_DURABLE::BOOLEAN;
ALTER TABLE QRTZ_JOB_DETAILS ALTER COLUMN IS_NONCONCURRENT TYPE VARCHAR(64) USING IS_NONCONCURRENT::VARCHAR(64);
UPDATE QRTZ_JOB_DETAILS SET IS_NONCONCURRENT='true' WHERE IS_NONCONCURRENT = '1';
UPDATE QRTZ_JOB_DETAILS SET IS_NONCONCURRENT='false' WHERE IS_NONCONCURRENT = '0';
ALTER TABLE QRTZ_JOB_DETAILS ALTER COLUMN IS_NONCONCURRENT TYPE BOOLEAN USING IS_NONCONCURRENT::BOOLEAN;
ALTER TABLE QRTZ_JOB_DETAILS ALTER COLUMN IS_UPDATE_DATA TYPE VARCHAR(64) USING IS_UPDATE_DATA::VARCHAR(64);
UPDATE QRTZ_JOB_DETAILS SET IS_UPDATE_DATA='true' WHERE IS_UPDATE_DATA = '1';
UPDATE QRTZ_JOB_DETAILS SET IS_UPDATE_DATA='false' WHERE IS_UPDATE_DATA = '0';
ALTER TABLE QRTZ_JOB_DETAILS ALTER COLUMN IS_UPDATE_DATA TYPE BOOLEAN USING IS_UPDATE_DATA::BOOLEAN;
ALTER TABLE QRTZ_JOB_DETAILS ALTER COLUMN REQUESTS_RECOVERY TYPE VARCHAR(64) USING REQUESTS_RECOVERY::VARCHAR(64);
UPDATE QRTZ_JOB_DETAILS SET REQUESTS_RECOVERY='true' WHERE REQUESTS_RECOVERY = '1';
UPDATE QRTZ_JOB_DETAILS SET REQUESTS_RECOVERY='false' WHERE REQUESTS_RECOVERY = '0';
ALTER TABLE QRTZ_JOB_DETAILS ALTER COLUMN REQUESTS_RECOVERY TYPE BOOLEAN USING REQUESTS_RECOVERY::BOOLEAN;
ALTER TABLE QRTZ_SIMPROP_TRIGGERS ALTER COLUMN BOOL_PROP_1 TYPE VARCHAR(64) USING BOOL_PROP_1::VARCHAR(64);
UPDATE QRTZ_SIMPROP_TRIGGERS SET BOOL_PROP_1='true' WHERE BOOL_PROP_1 = '1';
UPDATE QRTZ_SIMPROP_TRIGGERS SET BOOL_PROP_1='false' WHERE BOOL_PROP_1 = '0';
ALTER TABLE QRTZ_SIMPROP_TRIGGERS ALTER COLUMN BOOL_PROP_1 TYPE BOOLEAN USING BOOL_PROP_1::BOOLEAN;
ALTER TABLE QRTZ_SIMPROP_TRIGGERS ALTER COLUMN BOOL_PROP_2 TYPE VARCHAR(64) USING BOOL_PROP_2::VARCHAR(64);
UPDATE QRTZ_SIMPROP_TRIGGERS SET BOOL_PROP_2='true' WHERE BOOL_PROP_2 = '1';
UPDATE QRTZ_SIMPROP_TRIGGERS SET BOOL_PROP_2='false' WHERE BOOL_PROP_2 = '0';
ALTER TABLE QRTZ_SIMPROP_TRIGGERS ALTER COLUMN BOOL_PROP_2 TYPE BOOLEAN USING BOOL_PROP_2::BOOLEAN;
ALTER TABLE QRTZ_FIRED_TRIGGERS ALTER COLUMN IS_NONCONCURRENT TYPE VARCHAR(64) USING IS_NONCONCURRENT::VARCHAR(64);
UPDATE QRTZ_FIRED_TRIGGERS SET IS_NONCONCURRENT='true' WHERE IS_NONCONCURRENT = '1';
UPDATE QRTZ_FIRED_TRIGGERS SET IS_NONCONCURRENT='false' WHERE IS_NONCONCURRENT = '0';
ALTER TABLE QRTZ_FIRED_TRIGGERS ALTER COLUMN IS_NONCONCURRENT TYPE BOOLEAN USING IS_NONCONCURRENT::BOOLEAN;
ALTER TABLE QRTZ_FIRED_TRIGGERS ALTER COLUMN REQUESTS_RECOVERY TYPE VARCHAR(64) USING REQUESTS_RECOVERY::VARCHAR(64);
UPDATE QRTZ_FIRED_TRIGGERS SET REQUESTS_RECOVERY='true' WHERE REQUESTS_RECOVERY = '1';
UPDATE QRTZ_FIRED_TRIGGERS SET REQUESTS_RECOVERY='false' WHERE REQUESTS_RECOVERY = '0';
ALTER TABLE QRTZ_FIRED_TRIGGERS ALTER COLUMN REQUESTS_RECOVERY TYPE BOOLEAN USING REQUESTS_RECOVERY::BOOLEAN;
-- 2020-09-25 邱喜达 个人信息面板我的代阅
UPDATE PORTAL_SYS_COLUMN SET TEMPLATE_HTML = 'PGRpdiBzdHlsZT0iaGVpZ2h0OjEwMHB4O2JhY2tncm91bmQ6cmdiYSgyNTAsMjUwLDI1MCwxKTtib3gtc2hhZG93OjBweCAxcHggMHB4IDBweCByZ2JhKDIzNiwyMzcsMjQxLDEpOyI+CiAgICA8ZGl2IHN0eWxlPSJmbG9hdDpsZWZ0OyI+CiAgICAgIDxkaXYgc3R5bGU9ImZsb2F0OmxlZnQ7d2lkdGg6NjBweDtoZWlnaHQ6NjBweDtib3JkZXItcmFkaXVzOjUwJTtwYWRkaW5nLXRvcDoyMHB4OyI+CiAgICAgIDxpbWcgc3JjPSJodHRwczovL2Z1c3MxMC5lbGVtZWNkbi5jb20vZS81ZC80YTczMWE5MDU5NGE0YWY1NDRjMGMyNTk0MTE3MWpwZWcuanBlZyIgIHN0eWxlPSJ3aWR0aDo2MHB4O2hlaWdodDo2MHB4O2JhY2tncm91bmQ6cmdiYSgyNDUsMjQ1LDI0NSwxKTtib3JkZXItcmFkaXVzOjUwJTsiPgogICAgICAgIDwvZGl2PgogICAgICA8ZGl2IHN0eWxlPSJmbG9hdDpsZWZ0OyBwYWRkaW5nLWxlZnQ6OHB4O3BhZGRpbmctdG9wOjIwcHg7Ij4KICAgICAgICA8c3BhbiBzdHlsZT0iZm9udC1zaXplOjIwcHg7Zm9udC1mYW1pbHk6TWljcm9zb2Z0IFlhSGVpO2ZvbnQtd2VpZ2h0OjQwMDtjb2xvcjpyZ2JhKDg1LDg1LDg1LDEpO2xpbmUtaGVpZ2h0OjMwcHg7Ij7mgqjlpb3vvIF7e2RhdGEudXNlcj9kYXRhLnVzZXIuZnVsbG5hbWU6IiJ9fe+8jOelneS9oOW8gOW/g+avj+S4gOWkqe+8gTwvc3Bhbj48YnIvPgogICAgICAgIDxzcGFuIHN0eWxlPSJmb250LXNpemU6MTJweDtmb250LWZhbWlseTpNaWNyb3NvZnQgWWFIZWk7Zm9udC13ZWlnaHQ6NDAwO2NvbG9yOnJnYmEoMTQ1LDE0NSwxNDUsMSk7bGluZS1oZWlnaHQ6MzBweDsiPnt7ZGF0YS5vcmc/ZGF0YS5vcmcub3JnTmFtZToiIn19PC9zcGFuPgogICAgICA8L2Rpdj4KICAgIDwvZGl2PgogICAgICA8ZGl2IHN0eWxlPSJmbG9hdDpyaWdodDtwYWRkaW5nLXRvcDoyMHB4OyI+CiAgICAgICAgIDxkaXYgc3R5bGU9ImZsb2F0OmxlZnQ7cGFkZGluZy1yaWdodDo0OHB4OyI+CiAgICAgICAgICAgIDxkaXYgc3R5bGU9ImZsb2F0OmxlZnQ7d2lkdGg6NDJweDtoZWlnaHQ6NDJweDtiYWNrZ3JvdW5kOnJnYmEoMTA0LDE5NSwyNTMsMSk7Ym9yZGVyLXJhZGl1czoyMXB4OyI+CiAgICAgICAgICAgICAgPHNwYW4gY2xhc3M9Imljb24tdG9kbyIgc3R5bGU9ImZvbnQtc2l6ZTogMjhweDsgcGFkZGluZzogOHB4OyBjb2xvcjogcmdiKDI1NSwgMjU1LCAyNTUpOyI+CiAgICAgICAgICAgICAgICA8L3NwYW4+CiAgICAgICAgPC9kaXY+CiAgICAgIDxkaXYgc3R5bGU9ImZsb2F0OmxlZnQ7IHBhZGRpbmctbGVmdDo4cHg7Ij4KICAgICAgIDxkaXYgc3R5bGU9ImhlaWdodDoxOHB4OyI+IDxzcGFuIHN0eWxlPSJmb250LXNpemU6MjBweDtmb250LWZhbWlseTpNaWNyb3NvZnQgWWFIZWk7Zm9udC13ZWlnaHQ6NDAwO2NvbG9yOnJnYmEoMjgsMjgsMjgsMSk7bGluZS1oZWlnaHQ6MzBweDsiPnt7ZGF0YS5teVRha3M/ZGF0YS5teVRha3MuZGF0YVRleHQ6IiJ9fTwvc3Bhbj48L2Rpdj4KICAgICAgIDxkaXY+IDxzcGFuIHN0eWxlPSJmb250LXNpemU6MTJweDtmb250LWZhbWlseTpNaWNyb3NvZnQgWWFIZWk7Zm9udC13ZWlnaHQ6NDAwO2NvbG9yOnJnYmEoMTQ1LDE0NSwxNDUsMSk7bGluZS1oZWlnaHQ6MzBweDsiPuW+heWKnuaVsOmHjzwvc3Bhbj48L2Rpdj4KICAgICAgPC9kaXY+CiAgICAgICAgPC9kaXY+CiAgICAgICAgIDxkaXYgc3R5bGU9IiBmbG9hdDpsZWZ0O3dpZHRoOjFweDtoZWlnaHQ6NDBweDtiYWNrZ3JvdW5kOnJnYmEoMjIwLDIyMywyMzAsMSk7Ij48L2Rpdj4KICAgICAgICAgPGRpdiBzdHlsZT0iZmxvYXQ6bGVmdDtwYWRkaW5nLWxlZnQ6MzBweDtwYWRkaW5nLXJpZ2h0OjQwcHgiPgogICAgICAgICAgIDxkaXYgc3R5bGU9ImZsb2F0OmxlZnQ7d2lkdGg6NDJweDtoZWlnaHQ6NDJweDtiYWNrZ3JvdW5kOnJnYmEoMTE3LDE3MSwyNDQsMSk7Ym9yZGVyLXJhZGl1czoyMXB4OyI+CiAgICAgICAgPHNwYW4gY2xhc3M9Imljb24tcmVxZXVzdC1zdGFydCIgc3R5bGU9ImZvbnQtc2l6ZTogMjhweDsgcGFkZGluZzogOHB4OyBjb2xvcjogcmdiKDI1NSwgMjU1LCAyNTUpOyI+CiAgICAgICAgICAgICAgICA8L3NwYW4+CiAgICAgICAgPC9kaXY+CiAgICAgIDxkaXYgc3R5bGU9ImZsb2F0OmxlZnQ7IHBhZGRpbmctbGVmdDo4cHg7Ij4KICAgICAgIDxkaXYgc3R5bGU9ImhlaWdodDoxOHB4OyI+IDxzcGFuIHN0eWxlPSJmb250LXNpemU6MjBweDtmb250LWZhbWlseTpNaWNyb3NvZnQgWWFIZWk7Zm9udC13ZWlnaHQ6NDAwO2NvbG9yOnJnYmEoMjgsMjgsMjgsMSk7bGluZS1oZWlnaHQ6MzBweDsiPnt7ZGF0YS5teVJlcXVlc3Q/ZGF0YS5teVJlcXVlc3QuZGF0YVRleHQ6IiJ9fTwvc3Bhbj48L2Rpdj4KICAgICAgIDxkaXY+IDxzcGFuIHN0eWxlPSJmb250LXNpemU6MTJweDtmb250LWZhbWlseTpNaWNyb3NvZnQgWWFIZWk7Zm9udC13ZWlnaHQ6NDAwO2NvbG9yOnJnYmEoMTQ1LDE0NSwxNDUsMSk7bGluZS1oZWlnaHQ6MzBweDsiPuaIkeeahOivt+axgjwvc3Bhbj48L2Rpdj4KICAgICAgPC9kaXY+CiAgICAgICAgPC9kaXY+CiAgICAgICAgIDxkaXYgc3R5bGU9IiBmbG9hdDpsZWZ0O3dpZHRoOjFweDtoZWlnaHQ6NDBweDtiYWNrZ3JvdW5kOnJnYmEoMjIwLDIyMywyMzAsMSk7Ij48L2Rpdj4KICAgICAgICAgPGRpdiBzdHlsZT0iZmxvYXQ6cmlnaHQ7cGFkZGluZy1sZWZ0OjMwcHg7cGFkZGluZy1yaWdodDo0MHB4Ij4KICAgICAgICAgICA8ZGl2IHN0eWxlPSJmbG9hdDpsZWZ0O3dpZHRoOjQycHg7aGVpZ2h0OjQycHg7YmFja2dyb3VuZDpyZ2JhKDI0OSwxNzgsMTAyLDEpO2JvcmRlci1yYWRpdXM6MjFweDsiPgogICAgICAgIDxzcGFuIGNsYXNzPSJpY29uLXJlYWQxIiBzdHlsZT0iZm9udC1zaXplOiAyOHB4OyBwYWRkaW5nOiA4cHg7IGNvbG9yOiByZ2IoMjU1LCAyNTUsIDI1NSk7Ij4KICAgICAgICAgICAgICAgIDwvc3Bhbj4KICAgICAgICA8L2Rpdj4KICAgICAgPGRpdiBzdHlsZT0iZmxvYXQ6bGVmdDsgcGFkZGluZy1sZWZ0OjhweDsiPgogICAgICAgPGRpdiBzdHlsZT0iaGVpZ2h0OjE4cHg7Ij4gPHNwYW4gc3R5bGU9ImZvbnQtc2l6ZToyMHB4O2ZvbnQtZmFtaWx5Ok1pY3Jvc29mdCBZYUhlaTtmb250LXdlaWdodDo0MDA7Y29sb3I6cmdiYSgyOCwyOCwyOCwxKTtsaW5lLWhlaWdodDozMHB4OyI+e3tkYXRhLm15Tm90aWNlUmVhZD9kYXRhLm15Tm90aWNlUmVhZC5kYXRhVGV4dDoiIn19PC9zcGFuPjwvZGl2PgogICAgICAgPGRpdj4gPHNwYW4gc3R5bGU9ImZvbnQtc2l6ZToxMnB4O2ZvbnQtZmFtaWx5Ok1pY3Jvc29mdCBZYUhlaTtmb250LXdlaWdodDo0MDA7Y29sb3I6cmdiYSgxNDUsMTQ1LDE0NSwxKTtsaW5lLWhlaWdodDozMHB4OyI+5oiR55qE5b6F6ZiFPC9zcGFuPjwvZGl2PgogICAgICA8L2Rpdj4KICAgICAgICA8L2Rpdj4KICAgICAgICA8L2Rpdj4KICAgIDwvZGl2Pg==' WHERE ID = '1267788067230584832';
-- 2020-9-27 曾善铜 添加部分常用脚本
insert into bpm_script (id_, name_, script_, category_, memo_, create_time_, create_by_, create_org_id_, update_by_, update_time_, tenant_id_) values (1310142489381965824, '获取当前登录用户的id', 'return scriptImpl.getCurrentUserId();', '系统脚本', '', null, 1, '', null, null, null);
insert into bpm_script (id_, name_, script_, category_, memo_, create_time_, create_by_, create_org_id_, update_by_, update_time_, tenant_id_) values (1310143493599006720, '获取当前登录用户账号', 'return scriptImpl.getCurrentAccount()', '系统脚本', '返回String', null, 1, '', null, null, null);
insert into bpm_script (id_, name_, script_, category_, memo_, create_time_, create_by_, create_org_id_, update_by_, update_time_, tenant_id_) values (1310143776035049472, '获取职务级别', 'return scriptImpl.getMainPostName("postLevel");', '系统脚本', '', null, 1, '', null,null, null);
insert into bpm_script (id_, name_, script_, category_, memo_, create_time_, create_by_, create_org_id_, update_by_, update_time_, tenant_id_) values (1310147332251193344, '根据级别获取当前登录用户组织编码', 'return scriptImpl.getString(orgScript.getParentMainOrg("1").getGroupCode());', '系统脚本', '集团1,公司2,部门3', null, 1, '', null, null, null);
insert into bpm_script (id_, name_, script_, category_, memo_, create_time_, create_by_, create_org_id_, update_by_, update_time_, tenant_id_) values (1310149027446263808, '获取当前用户的角色名称', 'return scriptImpl.getIUserRoleName();', '系统脚本', '返回字符串数组', null, 1, '', null, null, null);
insert into bpm_script (id_, name_, script_, category_, memo_, create_time_, create_by_, create_org_id_, update_by_, update_time_, tenant_id_) values (1310150341488152576, '获取组织参数值', 'return orgScript.getParamKey('''','''');', '系统脚本', '组织id,组织参数编码',null, 1, '', null,null, null);
insert into bpm_script (id_, name_, script_, category_, memo_, create_time_, create_by_, create_org_id_, update_by_, update_time_, tenant_id_) values (1310153058105298944, '根据id获取工号', 'return scriptImpl.getUser("1").getAccount();', '系统脚本', '', null, 1, '', null, null, null);
insert into bpm_script (id_, name_, script_, category_, memo_, create_time_, create_by_, create_org_id_, update_by_, update_time_, tenant_id_) values (1310155448002940928, '判断组织参数', 'return orgScript.isOrgHasParamKey('''','''')', '系统脚本', '组织ID,参数别名', null, null, null, 1, null, null);