/*
 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 '模块名称';

-- jjｘ 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_`;