-- 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}。', '设置任务执行人：${taskSubject}，意见:${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);