-- 2020-09-14 李洪桥 将排版规则的是否删除的字段改为字符串格式
alter table uc_shift_rule modify IS_DELE_ varchar(1) null comment '是否删除 1删除 0未删除';
alter table uc_shift_user modify IS_DELE_ varchar(1) null comment '是否已删，1已删除，0未删除';

-- 2020-09-14 赵祥云 我的企业信息栏目表添加默认应用端名称“宏天企业信息平台”
UPDATE UC_TENANT_MANAGE SET NAME_FRONT_='宏天企业信息平台' where ID_ = '-1';

-- 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-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';

-- 2020-09-16 手机端信息台(功能迁移)
create table portal_sys_news_column
(
	ID_ VARCHAR(64) not null comment '主键',
	PORTAL_NEWS_ID_ VARCHAR(64) null comment '公告ID',
	NAME_ VARCHAR(255) null comment '公告名称_',
	TYPE_ VARCHAR(10) null comment '类型',
	TENANT_ID_ VARCHAR(64) null comment '租户Id'
)
comment '新闻公告发布到手机端';
ALTER TABLE portal_sys_news_column ADD CHECK (ID_ IS NOT NULL);
-- 添加新闻公告栏目
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 李洪桥 新闻公告添加是否已发布到手机端的表示
alter table portal_news_tree_
	add MOBILE_ISSUE_ int null comment '手机端是否发布 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)唯一索引
ALTER TABLE UC_PARAMS 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 CHANGE PAGE_ MENU_ID_ VARCHAR(64) COMMENT '菜单ID';
ALTER TABLE PORTAL_SYS_APP MODIFY COLUMN ICON_ TEXT COMMENT '图标';
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_` text;

-- 2020-09-22 刘美琴 系统操作日志内容字段类型调整
ALTER TABLE portal_sys_logs MODIFY COLUMN OPE_CONTENT_  LONGTEXT CHARACTER SET UTF8;

-- 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 邱喜达 个人信息面板我的代阅
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);