-- 赵祥云 新增待办部门信息（部门待办数量）和待办_xx部门(部门待办详情)栏目 INSERT INTO portal_sys_column (ID, NAME, ALIAS, CATALOG, COL_TYPE, DATA_MODE, DATA_FROM, DS_ALIAS, DS_NAME, COL_HEIGHT, COL_URL, TEMPLATE_HTML, IS_PUBLIC, SUPPORT_REFESH, REFESH_TIME, SHOW_EFFECT, MEMO, DATA_PARAM, NEEDPAGE, ORG_ID, CREATOR, CREATE_BY_, UPDATE_BY_, CREATE_TIME_, UPDATE_TIME_, REQUEST_TYPE, CATALOG_NAME, CREATE_ORG_ID_, TENANT_ID_) VALUES ('1311220566576992256', '待办_技术部', 'db_jsb', '', '0', '3', '${bpmRunTime}/runtime/task/v1/getTodoList', '', NULL, '327', '/v-flow/v-todo', 'PGVsLXRhYmxlIDpkYXRhPSJkYXRhLnJvd3MiIGFsaWduPSJsZWZ0Ij4KICAgIDxlbC10YWJsZS1jb2x1bW4gdHlwZT0iaW5kZXgiIGFsaWduPSJjZW50ZXIiIHdpZHRoPSI1MCIgbGFiZWw9IuW6j+WPtyI+PC9lbC10YWJsZS1jb2x1bW4+CiAgICA8ZWwtdGFibGUtY29sdW1uIHByb3A9InByb2NJbnN0SWQiIGxhYmVsPSLmtYHnqIvnvJblj7ciIGFsaWduPSJjZW50ZXIiIHdpZHRoPSIyMDAiIHNob3ctb3ZlcmZsb3ctdG9vbHRpcCAvPgogICAgPGVsLXRhYmxlLWNvbHVtbiBsYWJlbD0i5qCH6aKYIiBhbGlnbj0ibGVmdCIgIHNob3ctb3ZlcmZsb3ctdG9vbHRpcD4KICAgICAgICA8dGVtcGxhdGUgc2xvdC1zY29wZT0ic2NvcGUiIGFsaWduPSJsZWZ0Ij4KICAgICAgICAgICAgPHNwYW4gY2xhc3M9InRvZG8tc3ViamVjdCIgQGNsaWNrPSJoYW5kbGVUb2RvQ2xpY2soc2NvcGUucm93KSI+e3tzY29wZS5yb3cuc3ViamVjdH19PC9zcGFuPgogICAgICAgIDwvdGVtcGxhdGU+CiAgICA8L2VsLXRhYmxlLWNvbHVtbj4KICAgIDxlbC10YWJsZS1jb2x1bW4gcHJvcD0iY3JlYXRlVGltZSIgbGFiZWw9IuWIsOi+vuaXtumXtCIgd2lkdGg9IjE1MCIgc2hvdy1vdmVyZmxvdy10b29sdGlwIGFsaWduPSJjZW50ZXIiPjwvZWwtdGFibGUtY29sdW1uPgo8L2VsLXRhYmxlPg==', '2', NULL, NULL, NULL, '', '[{"name":"pageBean","type":"string","mode":"0","value":"{\\"page\\":1,\\"pageSize\\":7,\\"total\\":0,\\"showTotal\\":false}"},{"name":"querys","type":"string","mode":"0","value":"[{\\"property\\": \\"inst.CREATE_ORG_PATH_\\", \\"value\\": \\"1306170252345872384\\", \\"group\\": \\"orgId\\", \\"operation\\": \\"LIKE\\"}]"}]', '0', NULL, NULL, NULL, '1', NULL, NULL, 'POST', '', NULL, '-1'); INSERT INTO portal_sys_column (ID, NAME, ALIAS, CATALOG, COL_TYPE, DATA_MODE, DATA_FROM, DS_ALIAS, DS_NAME, COL_HEIGHT, COL_URL, TEMPLATE_HTML, IS_PUBLIC, SUPPORT_REFESH, REFESH_TIME, SHOW_EFFECT, MEMO, DATA_PARAM, NEEDPAGE, ORG_ID, CREATOR, CREATE_BY_, UPDATE_BY_, CREATE_TIME_, UPDATE_TIME_, REQUEST_TYPE, CATALOG_NAME, CREATE_ORG_ID_, TENANT_ID_) VALUES ('1311223536270053376', '待办部门信息', 'dbbmxx', '31081', '0', '3', '${bpmRunTime}/runtime/instance/v1/getDefaultInfoTodo', '', NULL, '80', '/v-flow/v-todo', 'PGRpdj4KCTxlbC1yb3cgOmd1dHRlcj0iMjAiIHN0eWxlPSJwYWRkaW5nLXRvcDogMTBweDtwYWRkaW5nLWJvdHRvbToxMHB4Ij4KCQk8ZWwtY29sIDpzcGFuPSIxMCIgc3R5bGU9InBhZGRpbmctdG9wOjVweCI+CgkJCTxkaXYgc3R5bGU9ImZsb2F0OmxlZnQ7IiBAY2xpY2s9ImhhbmRsZVRvZG9MaXN0Q2xpY2soZGF0YS5qc2IpIj4KCQkJCTxkaXYgc3R5bGU9ImZsb2F0OmxlZnQ7d2lkdGg6NDJweDtoZWlnaHQ6NDJweDtiYWNrZ3JvdW5kOnJnYmEoMTA0LDE5NSwyNTMsMSk7Ym9yZGVyLXJhZGl1czoyMXB4OyI+CiAgICAgICAgICA8c3BhbiBjbGFzcz0iaWNvbi10b2RvIiBzdHlsZT0iZm9udC1zaXplOiAyOHB4OyBwYWRkaW5nOiA4cHg7IGNvbG9yOiByZ2IoMjU1LCAyNTUsIDI1NSk7Ij4KICAgICAgICAgICAgPC9zcGFuPgoJCQkJPC9kaXY+CgkJCQk8ZGl2IHN0eWxlPSJmbG9hdDpsZWZ0OyBwYWRkaW5nLWxlZnQ6OHB4OyI+CgkJCQkJPGRpdiBzdHlsZT0iaGVpZ2h0OjE4cHg7Ij4gPHNwYW4gc3R5bGU9ImZvbnQtc2l6ZToyMHB4O2ZvbnQtZmFtaWx5Ok1pY3Jvc29mdCBZYUhlaTtmb250LXdlaWdodDo0MDA7Y29sb3I6cmdiYSgyOCwyOCwyOCwxKTtsaW5lLWhlaWdodDozMHB4OyI+e3tkYXRhLmpzYi50b2RvTnVtP2RhdGEuanNiLnRvZG9OdW06JzAnfX08L3NwYW4+PC9kaXY+CgkJCQkJPGRpdj4gPHNwYW4gc3R5bGU9ImZvbnQtc2l6ZToxMnB4O2ZvbnQtZmFtaWx5Ok1pY3Jvc29mdCBZYUhlaTtmb250LXdlaWdodDo0MDA7Y29sb3I6cmdiYSgxNDUsMTQ1LDE0NSwxKTtsaW5lLWhlaWdodDozMHB4OyI+5b6F5YqeX+aKgOacr+mDqDwvc3Bhbj48L2Rpdj4KCQkJCTwvZGl2PgoJCQk8L2Rpdj4KCQkJPGRpdiBzdHlsZT0iZmxvYXQ6cmlnaHQ7Ij4KICAgIDxzcGFuIGNsYXNzPSJlbC1kaXZpZGVyIGVsLWRpdmlkZXItLXZlcnRpY2FsIiBzdHlsZT0iZm9udC1zaXplOjQwcHg7Ij4KICAgICAgPC9zcGFuPgoJCQk8L2Rpdj4KCQk8L2VsLWNvbD4KCTwvZWwtcm93Pgo8L2Rpdj4=', '2', NULL, NULL, NULL, '', '[{"name":"jsb","type":"string","mode":"0","value":"\\"1306170252345872384\\""}]', '0', NULL, NULL, NULL, '1', NULL, NULL, 'POST', '默认分类', NULL, '-1'); -- 之前遗漏SQL -- 2020-09-28 赵祥云 流程实例表添加所属组织路径字段 alter table BPM_PRO_INST add CREATE_ORG_PATH_ varchar(1000) comment '所属组织路径'; -- 2020-09-29 赵祥云 给初始化常用语添加更新时间（用更新时间升序排序） update BPM_APPROVAL_ITEM SET UPDATE_TIME_ = '2020-09-29 10:30:10' WHERE ID_ = '6901702'; update BPM_APPROVAL_ITEM SET UPDATE_TIME_ = '2020-09-29 10:30:11' WHERE ID_ = '752469'; update BPM_APPROVAL_ITEM SET UPDATE_TIME_ = '2020-09-29 10:30:14' WHERE ID_ = '752475'; update BPM_APPROVAL_ITEM SET UPDATE_TIME_ = '2020-09-29 10:30:13' WHERE ID_ = '8982173'; -- 修改表字段类型防止超出长度审批失败 alter table bpm_check_opinion_hi modify QUALFIEDS_ text; alter table bpm_check_opinion_hi modify QUALFIED_NAMES_ text; alter table bpm_check_opinion modify QUALFIEDS_ text; alter table bpm_check_opinion modify QUALFIED_NAMES_ text; alter table bpm_task_notice_done modify QUALFIEDS_ text; alter table bpm_task_notice_done modify QUALFIED_NAMES_ text; -- 张耀祥 添加一个内部消息的菜单 INSERT INTO `portal_sys_menu` ( `ID_`, `PARENT_ID_`, `NAME_`, `ALIAS_`, `ACTIVE_TAB_`, `MENU_ICON_`, `OPENED_`, `SN_`, `TABS_STYLE_`, `PATH_`, `HREF_`, `TENANT_ID_` ) VALUES ( '1288290323419762688', '59217', '内部消息', 'v-messageReceiver', '', '', 1, 100, '', '-1.3.59217.1288290323419762688.', '', '-1' ); -- lingpj 2020-10-19 添加一条人员脚本 INSERT INTO BPM_MULTI_SCRIPT(ID_, ALIAS_NAME_, ALIAS_DESC_, CLASS_NAME_, CLASS_INS_NAME_, METHOD_NAME_, METHOD_DESC_, RETURN_TYPE_, ARGUMENT_, ENABLE_, TYPE_, TENANT_ID_) VALUES ('1318030354614980608', NULL, NULL, 'com.hotent.runtime.script.UserScript', 'userScript', 'getUserFromSubData', '从子表数据中提取节点审批人', 'java.util.Set', '[{"paraName":"arg0","paraType":"java.lang.String","paraDesc":"业务对象别名"},{"paraName":"arg1","paraType":"java.lang.String","paraDesc":"子表别名（sub_)"},{"paraName":"arg2","paraType":"java.lang.String","paraDesc":"用户ID字段"}]', 1, 2, NULL); insert into portal_sys_type(id_, type_group_key_, name_, type_key_, stru_type_, parent_id_, depth_, path_, is_leaf_, owner_id_, sn_, create_by_, create_time_, create_org_id_, update_by_, update_time_, icon_, tenant_id_) VALUES (31120,'TAG','表单标签','bdbq',1,11,1,'11.31120.','N','0',0,'1',null,null,null,null,'{}','-1'); insert into portal_sys_type(id_, type_group_key_, name_, type_key_, stru_type_, parent_id_, depth_, path_, is_leaf_, owner_id_, sn_, create_by_, create_time_, create_org_id_, update_by_, update_time_, icon_, tenant_id_) VALUES (31121,'TAG','应用标签','yybq',1,11,1,'11.31121.','N','0',0,'1',null,null,null,null,'{}','-1'); create table portal_app_tags_relation ( ID_ VARCHAR(50) not null comment '主键', APP_ID_ VARCHAR(64) not null comment '应用ID', TAG_ID_ VARCHAR(64) not null comment '标签ID', TENANT_ID_ VARCHAR(64) default '-1' null comment '租户ID', constraint portal_app_tags_relation_pk primary key (ID_) ) comment '应用标签关系表'; drop table if exists portal_app_param; create table portal_app_param ( ID_ VARCHAR(64) not null comment '主键', NAME_ varchar(64) null comment '参数名称', ALIAS_ varchar(64) null comment '参数编码', CONTROL_TYPE_ VARCHAR(64) null comment '控件类型', VALUE_ TEXT null comment '参数值', APP_ID_ VARCHAR(64) null comment '应用ID', TENANT_ID_ VARCHAR(64) default -1 null comment '租户ID', CREATE_TIME_ DATETIME null comment '创建时间', constraint portal_app_param_pk primary key (ID_) ) comment '应用参数表'; alter table form_data_template add SUB_FIELD_ TEXT null; -- 邱喜达 首页应用中心取消 update portal_sys_layout_manage set DESIGN_HTML = 'eyJsaXN0IjpbeyJ0eXBlIjoiZ3JpZCIsIm5hbWUiOiLmoIXmoLzluIPlsYAiLCJpY29uIjoiaWNvbi1ncmlkIiwiY29sdW1ucyI6W3sic3BhbiI6MTIsImxpc3QiOlt7Im5hbWUiOiLmiJHnmoTlvoXlip4iLCJhbGlhcyI6InZ1ZVRvZG8iLCJvcHRpb25zIjp7InJlbW90ZUZ1bmMiOiJmdW5jXzE1OTExNDkyMTIwMDBfODg0NzMifSwia2V5IjoiMTU5MTE0OTIxMjAwMF84ODQ3MyIsIm1vZGVsIjoidW5kZWZpbmVkXzE1OTExNDkyMTIwMDBfODg0NzMiLCJydWxlcyI6W119XX0seyJzcGFuIjoxMiwibGlzdCI6W3sibmFtZSI6IuS9k+iCsiIsImFsaWFzIjoiMTMxNDQ0NjY4NzIwNDQxMzQ0MCIsIm9wdGlvbnMiOnsicmVtb3RlRnVuYyI6ImZ1bmNfMTYwMjIyNjE2NDAwMF8zODI2MiJ9LCJrZXkiOiIxNjAyMjI2MTY0MDAwXzM4MjYyIiwibW9kZWwiOiJ1bmRlZmluZWRfMTYwMjIyNjE2NDAwMF8zODI2MiIsInJ1bGVzIjpbXX1dfV0sIm9wdGlvbnMiOnsiZ3V0dGVyIjo1LCJqdXN0aWZ5Ijoic3RhcnQiLCJhbGlnbiI6InRvcCIsInJlbW90ZUZ1bmMiOiJmdW5jXzE1OTEwOTcxNzkwMDBfNTU1NzEifSwia2V5IjoiMTU5MTA5NzE3OTAwMF81NTU3MSIsIm1vZGVsIjoiZ3JpZF8xNTkxMDk3MTc5MDAwXzU1NTcxIiwicnVsZXMiOltdfSx7InR5cGUiOiJncmlkIiwibmFtZSI6IuagheagvOW4g+WxgCIsImljb24iOiJpY29uLWdyaWQiLCJjb2x1bW5zIjpbeyJzcGFuIjoxMiwibGlzdCI6W3sibmFtZSI6IuaIkeeahOivt+axgiIsImFsaWFzIjoidnVlTXlyZXF1ZXN0Iiwib3B0aW9ucyI6eyJyZW1vdGVGdW5jIjoiZnVuY18xNTkxMTQ5MjIwMDAwXzkwMDczIn0sImtleSI6IjE1OTExNDkyMjAwMDBfOTAwNzMiLCJtb2RlbCI6InVuZGVmaW5lZF8xNTkxMTQ5MjIwMDAwXzkwMDczIiwicnVsZXMiOltdfV19LHsic3BhbiI6MTIsImxpc3QiOlt7Im5hbWUiOiLluLjnlKjmtYHnqIsiLCJhbGlhcyI6InZ1ZU9mdGVuRmxvdyIsIm9wdGlvbnMiOnsicmVtb3RlRnVuYyI6ImZ1bmNfMTYwMjIyODUwNzAwMF8zNDk2NiJ9LCJrZXkiOiIxNjAyMjI4NTA3MDAwXzM0OTY2IiwibW9kZWwiOiJ1bmRlZmluZWRfMTYwMjIyODUwNzAwMF8zNDk2NiIsInJ1bGVzIjpbXX1dfV0sIm9wdGlvbnMiOnsiZ3V0dGVyIjo1LCJqdXN0aWZ5Ijoic3RhcnQiLCJhbGlnbiI6InRvcCIsInJlbW90ZUZ1bmMiOiJmdW5jXzE1OTEwOTcyMDQwMDBfMTc3ODIifSwia2V5IjoiMTU5MTA5NzIwNDAwMF8xNzc4MiIsIm1vZGVsIjoiZ3JpZF8xNTkxMDk3MjA0MDAwXzE3NzgyIiwicnVsZXMiOltdfSx7InR5cGUiOiJncmlkIiwibmFtZSI6IuagheagvOW4g+WxgCIsImljb24iOiJpY29uLWdyaWQiLCJjb2x1bW5zIjpbeyJzcGFuIjoxMiwibGlzdCI6W3sibmFtZSI6IuS7u+WKoemdouadvyIsImFsaWFzIjoicndtYnZ1ZSIsIm9wdGlvbnMiOnsicmVtb3RlRnVuYyI6ImZ1bmNfMTU5MTE0OTIyOTAwMF8xMjEwMSJ9LCJrZXkiOiIxNTkxMTQ5MjI5MDAwXzEyMTAxIiwibW9kZWwiOiJ1bmRlZmluZWRfMTU5MTE0OTIyOTAwMF8xMjEwMSIsInJ1bGVzIjpbXX1dfSx7InNwYW4iOjYsImxpc3QiOlt7Im5hbWUiOiLmlrDpl7vlm77niYciLCJhbGlhcyI6IjEzMTQ0NjM3MDU5NDk0MDkyODAiLCJvcHRpb25zIjp7InJlbW90ZUZ1bmMiOiJmdW5jXzE2MDIyMjg1MTAwMDBfNjM2MSJ9LCJrZXkiOiIxNjAyMjI4NTEwMDAwXzYzNjEiLCJtb2RlbCI6InVuZGVmaW5lZF8xNjAyMjI4NTEwMDAwXzYzNjEiLCJydWxlcyI6W119XX0seyJzcGFuIjo2LCJsaXN0IjpbeyJuYW1lIjoi5pyA5paw6aG555uuIiwiYWxpYXMiOiJ6eHhtdnVlIiwib3B0aW9ucyI6eyJyZW1vdGVGdW5jIjoiZnVuY18xNTk4NDM1MTUzMDAwXzUyNjU5In0sImtleSI6IjE1OTg0MzUxNTMwMDBfNTI2NTkiLCJtb2RlbCI6InVuZGVmaW5lZF8xNTk4NDM1MTUzMDAwXzUyNjU5IiwicnVsZXMiOltdfV19XSwib3B0aW9ucyI6eyJndXR0ZXIiOjUsImp1c3RpZnkiOiJzdGFydCIsImFsaWduIjoidG9wIiwicmVtb3RlRnVuYyI6ImZ1bmNfMTU5MTA5NzIyMzAwMF84MzIzNCJ9LCJrZXkiOiIxNTkxMDk3MjIzMDAwXzgzMjM0IiwibW9kZWwiOiJncmlkXzE1OTEwOTcyMjMwMDBfODMyMzQiLCJydWxlcyI6W119LHsidHlwZSI6ImdyaWQiLCJuYW1lIjoi5qCF5qC85biD5bGAIiwiaWNvbiI6Imljb24tZ3JpZCIsImNvbHVtbnMiOlt7InNwYW4iOjI0LCJsaXN0IjpbeyJuYW1lIjoi5YWz5LqO5oiR5LusIiwiYWxpYXMiOiJneXdtdnVlIiwib3B0aW9ucyI6eyJyZW1vdGVGdW5jIjoiZnVuY18xNTkxMTQ5MjM3MDAwXzI0OTQ1In0sImtleSI6IjE1OTExNDkyMzcwMDBfMjQ5NDUiLCJtb2RlbCI6InVuZGVmaW5lZF8xNTkxMTQ5MjM3MDAwXzI0OTQ1IiwicnVsZXMiOltdfV19XSwib3B0aW9ucyI6eyJndXR0ZXIiOjAsImp1c3RpZnkiOiJzdGFydCIsImFsaWduIjoidG9wIiwicmVtb3RlRnVuYyI6ImZ1bmNfMTU5MTA5NzI0MzAwMF84MzE2NyJ9LCJrZXkiOiIxNTkxMDk3MjQzMDAwXzgzMTY3IiwibW9kZWwiOiJncmlkXzE1OTEwOTcyNDMwMDBfODMxNjciLCJydWxlcyI6W119XSwiY29uZmlnIjp7ImxhYmVsV2lkdGgiOjEwMCwibGFiZWxQb3NpdGlvbiI6InJpZ2h0Iiwic2l6ZSI6InNtYWxsIn19' where id = 2; -- 2020-10-19 赵祥云 表单详情表添加表单配置字段 ALTER TABLE FORM_DEFINITION ADD FORM_SETTING_ VARCHAR(2000); -- 2020-10-20 李洪桥 电子签章 CREATE TABLE `uc_electronic_seal` ( `ID_` varchar(64) NOT NULL COMMENT '主键ID', `USER_ID_` varchar(64) NULL COMMENT '用户ID', `FILE_ID_` varchar(64) NULL COMMENT '签章图片ID', `PASSWORD_` varchar(64) NULL COMMENT '使用密码', `IS_USE_` int(11) NULL COMMENT '当前是否使用', `CREATE_TIME_` datetime DEFAULT NULL COMMENT '创建时间', `UPDATE_TIME_` datetime DEFAULT NULL COMMENT '更新时间', `CREATE_ORG_ID_` varchar(64) DEFAULT NULL, `CREATE_BY_` varchar(64) DEFAULT NULL COMMENT '创建人', `UPDATE_BY_` varchar(64) DEFAULT NULL COMMENT '更新人', `TENANT_ID_` varchar(64) DEFAULT NULL COMMENT '租户ID', PRIMARY KEY (`ID_`) ); -- 2020-10-23 lingpj 定时计划两条初始化语句调整 UPDATE QRTZ_JOB_DETAILS SET JOB_DATA = 0x230D0A23467269204F63742032332031353A31383A34372043535420323032300D0A WHERE SCHED_NAME = 'quartzScheduler' AND JOB_NAME = '任务催办定时计划' AND JOB_GROUP = '-1'; UPDATE QRTZ_JOB_DETAILS SET JOB_DATA = 0x230D0A23467269204F63742032332031353A31383A35342043535420323032300D0A WHERE SCHED_NAME = 'quartzScheduler' AND JOB_NAME = '流程定时启动任务类' AND JOB_GROUP = '-1'; -- 2020-10-27 linpj 关系矩阵添加默认分类 INSERT INTO PORTAL_SYS_TYPE(ID_, TYPE_GROUP_KEY_, NAME_, TYPE_KEY_, STRU_TYPE_, PARENT_ID_, DEPTH_, PATH_, IS_LEAF_, OWNER_ID_, SN_, CREATE_BY_, CREATE_TIME_, CREATE_ORG_ID_, UPDATE_BY_, UPDATE_TIME_, ICON_, TENANT_ID_) VALUES ('1320902983285870592', 'jzfl', '默认分类', 'mrfl', '0', '1285467330515701760', 1, '1285467330515701760.1320902983285870592.', 'Y', '0', 0, '1', NULL, '', NULL, NULL, NULL, '-1'); -- 2020-10-28 lingpj 调整新闻公告url字段长度 ALTER TABLE PORTAL_NEWS_NOTICE_ MODIFY COLUMN URL_ varchar(2000); -- 2020-10-28 lingpj 移动端信息台默认授权 INSERT INTO PORTAL_SYS_AUTH_USER(ID_, AUTHORIZE_ID_, OWNER_ID_, OWNER_NAME_, RIGHT_TYPE_, OBJ_TYPE_, TENANT_ID_) VALUES ('1321385863887851520', '1295248036242526208', NULL, NULL, 'everyone', 'indexColumn', '-1'); -- 2020-10-29 jjx 修改人员脚本描述 update bpm_multi_script set METHOD_DESC_='获取上一节点执行人的部门负责人(主组织)' where ID_=11; -- 2020-10-29 曾善铜 修改应用中心请求链接 update portal_sys_column set DATA_FROM = '${portal}/portal/sysApp/v1/authList' where ID = '1298555788968726528'; -- 2020-10-29 heyf bpm_task表添加instId索引 ALTER TABLE `bpm_task` ADD INDEX `IDX_BPM_TASK_INSTID` (`PROC_INST_ID_`), ADD INDEX `IDX_BPM_TASK_STATUS` (`STATUS_`) ; -- 2020-10-29 heyf 删除act_ru_identitylink表的外键和索引 ALTER TABLE `act_ru_identitylink` DROP FOREIGN KEY `ACT_FK_ATHRZ_PROCEDEF`; ALTER TABLE `act_ru_identitylink` DROP FOREIGN KEY `ACT_FK_TSKASS_TASK`; ALTER TABLE `act_ru_identitylink` DROP INDEX `ACT_IDX_IDENT_LNK_GROUP`, DROP INDEX `ACT_IDX_ATHRZ_PROCEDEF`, DROP INDEX `ACT_FK_TSKASS_TASK`; -- 2020-10-29 heyf 表bpm_reminder_history添加task_id_的索引 ALTER TABLE `bpm_reminder_history` ADD INDEX `IDX_REMINDER_TASKID` (`TASK_ID_`) ; -- 2020-10-29 heyf 删除act_ru_task中的两个外键，添加parent_task_id的索引 ALTER TABLE `act_ru_task` DROP FOREIGN KEY `ACT_FK_TASK_PROCDEF`; ALTER TABLE `act_ru_task` DROP FOREIGN KEY `ACT_FK_TASK_PROCINST`; -- 2020-10-29 heyf 删除task_procdef索引，添加parent_task_id索引 ALTER TABLE `act_ru_task` DROP INDEX `ACT_FK_TASK_PROCDEF`, ADD INDEX `ACT_IDX_TASK_PARENTID` (`PARENT_TASK_ID_`) ; -- 2020-10-29 heyf 添加businesskey的索引 ALTER TABLE `bpm_bus_link` ADD INDEX `IDX_BUSLINK_BUSINESSKEY` (`BUSINESSKEY_STR_`) ; -- 2020-10-29 hey 业务数据模板按照tempid添加索引 ALTER TABLE `form_data_template_extend` ADD INDEX `IDX_FORM_DATA_TEMPEXTEND_TEMPID` (`FORM_DATA_TEMPLATE_ID`) ; -- 2020-10-29 jijx 修改人员脚本汇报线描述 update bpm_multi_script set ARGUMENT_='[{"paraName":"arg1","paraType":"java.lang.String","paraDesc":"类型编码","paraCt":"","paraCtBindName":"ID_","paraCtBindKey":"","multiSelect":false}]' where ID_=12; update bpm_multi_script set ARGUMENT_='[{"paraName":"arg1","paraType":"java.lang.String","paraDesc":"类型编码","paraCt":"cusdg:yhgxflxz","paraCtBindName":"ID_","paraCtBindKey":"ID_","multiSelect":false}]' where ID_=13; -- 2020-10-29 jijx 修改人员脚本配置及说明 update bpm_multi_script set ARGUMENT_='[{"paraName":"arg0","paraType":"java.lang.String","paraDesc":"业务对象别名"},{"paraName":"arg1","paraType":"java.lang.String","paraDesc":"子表别名（sub_)"},{"paraName":"arg2","paraType":"java.lang.String","paraDesc":"用户帐号字段"}]' where ID_=1318030354614980608; update bpm_multi_script set ARGUMENT_='[{"paraName":"arg0","paraType":"java.lang.String","paraDesc":"组织编码","paraCt":"base:org-selector","paraCtBindName":"id_","paraCtBindKey":"id","multiSelect":false,"$$hashKey":"object:645"}]' where ID_=2; update bpm_multi_script set ARGUMENT_ = '[{"paraName":"arg0","paraType":"java.lang.String","paraDesc":"组织编码","paraCt":"base:org-selector","paraCtBindName":"code","paraCtBindKey":"code","multiSelect":false},{"paraName":"arg1","paraType":"java.lang.String","paraDesc":"职务编码","paraCt":"base:job-selector","paraCtBindName":"code","paraCtBindKey":"code","multiSelect":false}]' where ID_=20; update bpm_multi_script set ARGUMENT_ = '[{"paraName":"arg0","paraType":"java.lang.String","paraDesc":"用户id","multiSelect":false,"paraCt":"base:user-selector","paraCtBindKey":"id","paraCtBindName":"id"},{"paraName":"arg1","paraType":"java.lang.String","paraDesc":"维度id","multiSelect":false,"paraCt":"base:dem-selector","paraCtBindKey":"id","paraCtBindName":"id"}]' where ID_=21; update bpm_multi_script set ARGUMENT_ = '[{"paraName":"arg0","paraType":"java.lang.String","paraDesc":"维度id","multiSelect":false,"paraCt":"base:dem-selector","paraCtBindKey":"id","paraCtBindName":"id"}]' where ID_=22; update bpm_multi_script set ARGUMENT_ = '[{"paraName":"arg0","paraType":"java.lang.String","paraDesc":"维度id","multiSelect":false,"paraCt":"base:dem-selector","paraCtBindKey":"id","paraCtBindName":"id"}]' where ID_=23; -- 2020-11-03 pangq 添加 用户与外部通讯录关系表 CREATE TABLE `uc_user_unite` ( `ID_` varchar(64) NOT NULL COMMENT '主键', `USER_ID_` varchar(64) DEFAULT NULL COMMENT '用户id', `OPEN_ID_` varchar(1000) DEFAULT NULL COMMENT '公众号openid', `WX_WORK_ID_` varchar(1000) DEFAULT NULL COMMENT '企业微信userid', `DINGTALK_ID_` varchar(1000) DEFAULT NULL COMMENT '阿里钉钉userid', `tenant_id_` varchar(64) DEFAULT NULL COMMENT '租户id', PRIMARY KEY (`ID_`) USING BTREE ) ENGINE=InnoDB DEFAULT CHARSET=utf8 COMMENT='用户与外部通讯录关系表'; -- 2020-11-04 jason 添加 流程仿真异常日志表 CREATE TABLE `BPM_TEST_CASE_LOGS` ( `ID_` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL, `OPE_NAME_` varchar(128) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作名称', `EXECUTION_TIME_` datetime(0) NULL DEFAULT NULL, `OPE_CONTENT_` longtext CHARACTER SET utf8 COLLATE utf8_general_ci NULL COMMENT '操作内容', `TENANT_ID_` varchar(255) 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 = Compact; SET FOREIGN_KEY_CHECKS = 1; -- 2020-11-04 qiuxd 对话框添加组合对话框配置字段 ALTER TABLE form_custom_dialog ADD combine_config_ VARCHAR(2000); -- 2020-11-04 ZST 组合对话框覆盖更新 alter table form_custom_dialog change combine_config_ COMBINATION_RULE_ VARCHAR(2000) null comment '组合规则'; -- 2020-11-5 jijx 修改人员脚本配置从子表数据中提取节点审批人的说明 update bpm_multi_script set METHOD_DESC_='从子表数据中提取节点审批人(固定值生效)' where ID_=1318030354614980608; -- 2020-11-05 wanghb BPM_PRO_INST添加BPMN_INST_ID_唯一索引 ALTER TABLE `bpm_pro_inst` ADD UNIQUE INDEX `IDX_PRO_INST_BPMNINSTID`(`BPMN_INST_ID_`); -- 2020-11-04 赵祥云 新增常用流程授权对象表 CREATE TABLE `bpm_often_flow_user` ( `ID_` varchar(64) NOT NULL COMMENT '主键ID', `OFTEN_FLOW_ID_` varchar(64) DEFAULT NULL COMMENT '常用流程表主键ID', `OWNER_ID_` varchar(64) DEFAULT NULL COMMENT '授权对象ID', `OWNER_NAME_` varchar(128) DEFAULT NULL COMMENT '授权对象名称', `RIGHT_TYPE_` varchar(20) DEFAULT NULL COMMENT '授权对象类型(角色,用户,岗位等)', `TENANT_ID_` varchar(255) DEFAULT NULL COMMENT '租户ID', PRIMARY KEY (`ID_`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- 2020-11-05 赵祥云 修改常用流程表字段信息设置USER_ID_和USER_NAME_可以为空 ALTER TABLE bpm_often_flow MODIFY COLUMN USER_ID_ VARCHAR(64) DEFAULT NULL; ALTER TABLE bpm_often_flow MODIFY COLUMN USER_NAME_ VARCHAR(128) DEFAULT NULL; -- 2020-11-5 zhangxw 修改日志表操作名称字段长度 ALTER TABLE `portal_sys_logs` MODIFY COLUMN `OPE_NAME_` varchar(500) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '操作名称' AFTER `ID_`; -- 2020-11-07 wanghb 调整表单元数据name字段长度 ALTER TABLE FORM_META MODIFY COLUMN NAME_ varchar(128); -- mysql 添加默认应用分类 INSERT INTO `portal_sys_menu`(`ID_`, `PARENT_ID_`, `NAME_`, `ALIAS_`, `ACTIVE_TAB_`, `MENU_ICON_`, `OPENED_`, `SN_`, `TABS_STYLE_`, `PATH_`, `HREF_`, `TENANT_ID_`) VALUES ('1324959516441317376', '4', '默认分类', 'default', '', '', NULL, 2, '', '-1.4.1324959516441317376.', '', '-1'); -- zhangxw 2020-11-12 添加汇报线选择器并更新至汇报线相关人员脚本 INSERT INTO form_custom_dialog(ID_, NAME_, ALIAS_, STYLE_, OBJ_NAME_, NEED_PAGE_, PAGE_SIZE_, DISPLAYFIELD_, CONDITIONFIELD_, RESULTFIELD_, SORTFIELD_, DSALIAS_, IS_TABLE_, DIY_SQL_, SQL_BUILD_TYPE_, WIDTH_, HEIGHT_, SELECT_NUM_, SYSTEM_, PARENT_CHECK_, CHILDREN_CHECK_, DS_TYPE_, URL_, REQUEST_TYPE_, DATA_PARAM_, PAGE_KEY_, PAGESIZE_KEY_, TOTAL_KEY_, LIST_KEY_, TENANT_ID_, CREATE_BY_, UPDATE_BY_, CREATE_ORG_ID_, CREATE_TIME_, UPDATE_TIME_, HEADER_) VALUES ('1326830804449497088', '汇报线选择器', 'reportLine', 1, 'portal_sys_type', 1, NULL, '{"isScript":false,"id":"ID_","pid":"PARENT_ID_","pvalue":"12","displayName":"NAME_"}', '[{"field":"TYPE_GROUP_KEY_","comment":"所属分类组业务主键","condition":"EQ","dbType":"varchar","defaultType":"2","defaultValue":"REPORT_LINE"}]', '[{"field":"ID_","comment":"ID_","idKey":"0","AggFuncOp":"","columnType":"varchar"},{"field":"NAME_","comment":"NAME_","idKey":"0","AggFuncOp":"","columnType":"varchar"},{"field":"TYPE_KEY_","comment":"TYPE_KEY_","idKey":"0","AggFuncOp":"","columnType":"varchar"}]', '[]', 'LOCAL', 1, NULL, 0, 800, 600, 1, 0, NULL, NULL, 'dataSource', NULL, 'POST', NULL, 'page', 'pageSize', 'total', 'rows', '-1', '1', '1', '', '2020-11-12 18:14:50', '2020-11-12 18:44:19', NULL); UPDATE bpm_multi_script SET ARGUMENT_ = '[{"paraName":"arg1","paraType":"java.lang.String","paraDesc":"类型编码","paraCt":"cusdg:reportLine","paraCtBindName":"ID_","paraCtBindKey":"TYPE_KEY_","multiSelect":false}]' WHERE METHOD_NAME_ = 'getByRelPreNode'; UPDATE bpm_multi_script SET ARGUMENT_ = '[{"paraName":"arg1","paraType":"java.lang.String","paraDesc":"类型编码","paraCt":"cusdg:reportLine","paraCtBindName":"ID_","paraCtBindKey":"TYPE_KEY_","multiSelect":false}]' WHERE METHOD_NAME_ = 'getByRelStartUser'; -- zhangxw 2020-11-16 更新消息模板中html链接地址（查看消息时，点击标题链接到对应页面） UPDATE PORTAL_SYS_MSG_TPL SET HTML_ = '

任务创建：流程实例${instSubject}，执行到${nodeName}

' WHERE ID_ = '1'; UPDATE PORTAL_SYS_MSG_TPL SET HTML_ = '

任务沟通提醒，${receiver}您好,任务：${taskSubject}需要与您交流，请给出意见。

' WHERE ID_ = '2'; UPDATE PORTAL_SYS_MSG_TPL SET HTML_ = '

代理通知：
您的任务${taskSubject}，代理给${agent}

' WHERE ID_ = '3'; UPDATE PORTAL_SYS_MSG_TPL SET HTML_ = '

沟通反馈提醒，实例${taskSubject}发起的沟通，已给出意见。

' WHERE ID_ = '4'; UPDATE PORTAL_SYS_MSG_TPL SET HTML_ = '

任务流转通知：${taskSubject}的${nodeName}任务，已经流转给你。

' WHERE ID_ = '5'; UPDATE PORTAL_SYS_MSG_TPL SET HTML_ = '

任务转交：流程实例${taskSubject}，需要你办理。

' WHERE ID_ = '6'; UPDATE PORTAL_SYS_MSG_TPL SET HTML_ = '

加签通知：
${sender}邀请你参与会签任务${taskSubject},加签原因:${cause}

' WHERE ID_ = '7'; UPDATE PORTAL_SYS_MSG_TPL SET HTML_ = '

${nodeName}完成：流程实例: ${instSubject}完成.

' WHERE ID_ = '8'; UPDATE PORTAL_SYS_MSG_TPL SET HTML_ = '

任务驳回：流程实例${instSubject}，驳回原因:${cause}

' WHERE ID_ = '9'; UPDATE PORTAL_SYS_MSG_TPL SET HTML_ = '

流程实例抄送：流程${taskSubject}的${instId}实例，已经抄送给您。

' WHERE ID_ = '10'; UPDATE PORTAL_SYS_MSG_TPL SET HTML_ = '

流程实例结束${instSubject}，意见:${cause}。

' WHERE ID_ = '11'; UPDATE PORTAL_SYS_MSG_TPL SET HTML_ = '

流转撤销：流程实例：${instSubject}的${nodeName}流转任务，已被撤销。

' WHERE ID_ = '12'; UPDATE PORTAL_SYS_MSG_TPL SET HTML_ = '

审批提醒：
您有新的工作流需要审批${taskSubject}

' WHERE ID_ = '13'; UPDATE PORTAL_SYS_MSG_TPL SET HTML_ = '

驳回提醒：
您的${taskSubject}请求被驳回，请处理!

' WHERE ID_ = '14'; UPDATE PORTAL_SYS_MSG_TPL SET HTML_ = '

撤销提醒：
审批任务${taskSubject}被撤销，撤销原因${cause}。

' WHERE ID_ = '15'; UPDATE PORTAL_SYS_MSG_TPL SET HTML_ = '

代理任务审批：
您有新的代理任务需要审批${taskSubject}，委托人${delegate}.

' WHERE ID_ = '16'; UPDATE PORTAL_SYS_MSG_TPL SET HTML_ = '

流程实例结束${taskSubject}，意见:${cause}。

' WHERE ID_ = '17'; UPDATE PORTAL_SYS_MSG_TPL SET HTML_ = '

任务并行审批通知：${taskSubject}的${nodeName}任务，已经发起并行审批给你。

' WHERE ID_ = '18'; UPDATE PORTAL_SYS_MSG_TPL SET HTML_ = '

并行审批撤销：流程实例：${taskSubject}的${nodeName}并行审批任务，已被撤销。

' WHERE ID_ = '19'; UPDATE PORTAL_SYS_MSG_TPL SET HTML_ = '

流程实例已恢复运行中状态${instSubject}，意见:${cause}。

' WHERE ID_ = '20'; UPDATE PORTAL_SYS_MSG_TPL SET HTML_ = '

设置任务执行人：${taskSubject}，意见:${cause}。

' WHERE ID_ = '21'; -- 2020-11-17 lingpj 调整修改原因字段长度 ALTER TABLE BPM_FORM_MODIFY_RECORD MODIFY COLUMN REASON_ TEXT; -- 2020-11-18 heyf 在form_key上添加索引 ALTER TABLE `form_data_template` ADD INDEX `INDEX_FORMTEMP_FORMKEY`(`FORM_KEY_`); -- 2020-11-23 赵祥云 新增流程实例状态排序表 CREATE TABLE `bpm_pro_inst_status` ( `ID_` varchar(64) NOT NULL, `KEY_` varchar(255) DEFAULT NULL COMMENT '流程实例状态', `VALUE_` varchar(255) DEFAULT NULL COMMENT '流程实例状态对应的排序号', PRIMARY KEY (`ID_`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8; -- 2020-11-23 赵祥云 初始化流程实例状态排序表数据 INSERT INTO bpm_pro_inst_status (ID_, KEY_, VALUE_) VALUES ('1', 'draft', '1'); INSERT INTO bpm_pro_inst_status (ID_, KEY_, VALUE_) VALUES ('2', 'revoke', '2'); INSERT INTO bpm_pro_inst_status (ID_, KEY_, VALUE_) VALUES ('3', 'back', '3'); INSERT INTO bpm_pro_inst_status (ID_, KEY_, VALUE_) VALUES ('4', 'backToStart', '4'); INSERT INTO bpm_pro_inst_status (ID_, KEY_, VALUE_) VALUES ('5', 'running', '5'); INSERT INTO bpm_pro_inst_status (ID_, KEY_, VALUE_) VALUES ('6', 'manualend', '6'); INSERT INTO bpm_pro_inst_status (ID_, KEY_, VALUE_) VALUES ('7', 'end', '7'); -- 2020-11-23 邱喜达 修改自定义图标sortField类型 ALTER TABLE form_custom_chart MODIFY COLUMN SORTFIELD_ TEXT DEFAULT NULL COMMENT '排序设置'; -- 增加新闻分类信息-lucong INSERT INTO `portal_news_tree_`(`ID_`, `NAME_`, `PATH_`, `PARENT_ID_`, `RANK_`, `SN_`, `PARENT_NAME_`, `TENANT_ID_`, `CREATE_TIME_`, `CREATE_BY_`, `UPDATE_TIME_`, `UPDATE_BY_`, `COL_HEIGHT_`, `COLUMN_ID_`, `INTERVAL_TIME_`, `MOBILE_ISSUE_`) VALUES ('1325679193043898368', '宏天软件', '100.1325679193043898368.', '100', 2, 1, '新闻公告', '-1', '2020-11-09 13:58:44', '1', NULL, NULL, 100, NULL, NULL, 0); INSERT INTO `portal_news_tree_`(`ID_`, `NAME_`, `PATH_`, `PARENT_ID_`, `RANK_`, `SN_`, `PARENT_NAME_`, `TENANT_ID_`, `CREATE_TIME_`, `CREATE_BY_`, `UPDATE_TIME_`, `UPDATE_BY_`, `COL_HEIGHT_`, `COLUMN_ID_`, `INTERVAL_TIME_`, `MOBILE_ISSUE_`) VALUES ('1325679230087991296', '系统帮助', '100.1325679193043898368.1325679230087991296.', '1325679193043898368', 3, NULL, '宏天软件', '-1', '2020-11-09 13:58:53', '1', '2020-11-09 14:32:27', '1', 0, '1325681915189137408', NULL, 1); INSERT INTO `portal_news_tree_`(`ID_`, `NAME_`, `PATH_`, `PARENT_ID_`, `RANK_`, `SN_`, `PARENT_NAME_`, `TENANT_ID_`, `CREATE_TIME_`, `CREATE_BY_`, `UPDATE_TIME_`, `UPDATE_BY_`, `COL_HEIGHT_`, `COLUMN_ID_`, `INTERVAL_TIME_`, `MOBILE_ISSUE_`) VALUES ('1325679288829218816', '宏天软件', '200.1325679288829218816.', '200', 2, 1, '轮播图', '-1', '2020-11-09 13:59:07', '1', NULL, NULL, 0, NULL, NULL, 0); INSERT INTO `portal_news_tree_`(`ID_`, `NAME_`, `PATH_`, `PARENT_ID_`, `RANK_`, `SN_`, `PARENT_NAME_`, `TENANT_ID_`, `CREATE_TIME_`, `CREATE_BY_`, `UPDATE_TIME_`, `UPDATE_BY_`, `COL_HEIGHT_`, `COLUMN_ID_`, `INTERVAL_TIME_`, `MOBILE_ISSUE_`) VALUES ('1330698840872980480', '宏天软件', '200.1325679288829218816.1330698840872980480.', '1325679288829218816', 3, 1, '宏天软件', '-1', '2020-11-23 10:25:02', '1', '2020-11-23 10:30:03', '1', 100, '1330699934319644672', 0, 0); INSERT INTO `portal_news_tree_`(`ID_`, `NAME_`, `PATH_`, `PARENT_ID_`, `RANK_`, `SN_`, `PARENT_NAME_`, `TENANT_ID_`, `CREATE_TIME_`, `CREATE_BY_`, `UPDATE_TIME_`, `UPDATE_BY_`, `COL_HEIGHT_`, `COLUMN_ID_`, `INTERVAL_TIME_`, `MOBILE_ISSUE_`) VALUES ('1330747098659950592', '宏天信息', '200.1325679288829218816.1330747098659950592.', '1325679288829218816', 3, 2, '宏天软件', '-1', '2020-11-23 13:36:47', '1', '2020-11-23 13:38:40', '1', 100, '1330747571286708224', NULL, 0); -- 插入新闻公告附件 lucong INSERT INTO `portal_sys_file`(`ID_`, `XB_TYPE_ID_`, `FILE_NAME_`, `FILE_TYPE_`, `STORE_TYPE_`, `FILE_PATH_`, `BYTES_`, `BYTE_COUNT_`, `EXT_`, `NOTE_`, `CREATE_BY_`, `CREATOR_NAME_`, `CREATE_TIME_`, `IS_DEL_`, `PROP1_`, `PROP2_`, `PROP3_`, `PROP4_`, `PROP5_`, `PROP6_`, `TYPE_`, `TENANT_ID_`, `CREATE_ORG_ID_`, `UPDATE_BY_`, `UPDATE_TIME_`) VALUES ('1', NULL, '产品中心', NULL, 'folder', 'images\\one.png', NULL, 262022, 'png', '255.88 KB', '1', '超级管理员', '2020-11-23 15:08:52', '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '-1', '', NULL, NULL); INSERT INTO `portal_sys_file`(`ID_`, `XB_TYPE_ID_`, `FILE_NAME_`, `FILE_TYPE_`, `STORE_TYPE_`, `FILE_PATH_`, `BYTES_`, `BYTE_COUNT_`, `EXT_`, `NOTE_`, `CREATE_BY_`, `CREATOR_NAME_`, `CREATE_TIME_`, `IS_DEL_`, `PROP1_`, `PROP2_`, `PROP3_`, `PROP4_`, `PROP5_`, `PROP6_`, `TYPE_`, `TENANT_ID_`, `CREATE_ORG_ID_`, `UPDATE_BY_`, `UPDATE_TIME_`) VALUES ('2', NULL, '我们的产品', NULL, 'folder', 'images\\two.png', NULL, 153785, 'png', '150.18 KB', '1', '超级管理员', '2020-11-23 15:08:45', '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '-1', '', NULL, NULL); INSERT INTO `portal_sys_file`(`ID_`, `XB_TYPE_ID_`, `FILE_NAME_`, `FILE_TYPE_`, `STORE_TYPE_`, `FILE_PATH_`, `BYTES_`, `BYTE_COUNT_`, `EXT_`, `NOTE_`, `CREATE_BY_`, `CREATOR_NAME_`, `CREATE_TIME_`, `IS_DEL_`, `PROP1_`, `PROP2_`, `PROP3_`, `PROP4_`, `PROP5_`, `PROP6_`, `TYPE_`, `TENANT_ID_`, `CREATE_ORG_ID_`, `UPDATE_BY_`, `UPDATE_TIME_`) VALUES ('3', NULL, '客户案例', NULL, 'folder', 'images\\three.png', NULL, 281358, 'png', '274.76 KB', '1', '超级管理员', '2020-11-23 15:08:09', '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '-1', '', NULL, NULL); INSERT INTO `portal_sys_file`(`ID_`, `XB_TYPE_ID_`, `FILE_NAME_`, `FILE_TYPE_`, `STORE_TYPE_`, `FILE_PATH_`, `BYTES_`, `BYTE_COUNT_`, `EXT_`, `NOTE_`, `CREATE_BY_`, `CREATOR_NAME_`, `CREATE_TIME_`, `IS_DEL_`, `PROP1_`, `PROP2_`, `PROP3_`, `PROP4_`, `PROP5_`, `PROP6_`, `TYPE_`, `TENANT_ID_`, `CREATE_ORG_ID_`, `UPDATE_BY_`, `UPDATE_TIME_`) VALUES ('4', NULL, '解决方案', NULL, 'folder', 'images\\four.png', NULL, 283864, 'png', '277.21 KB', '1', '超级管理员', '2020-11-23 15:07:55', '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '-1', '', NULL, NULL); INSERT INTO `portal_sys_file`(`ID_`, `XB_TYPE_ID_`, `FILE_NAME_`, `FILE_TYPE_`, `STORE_TYPE_`, `FILE_PATH_`, `BYTES_`, `BYTE_COUNT_`, `EXT_`, `NOTE_`, `CREATE_BY_`, `CREATOR_NAME_`, `CREATE_TIME_`, `IS_DEL_`, `PROP1_`, `PROP2_`, `PROP3_`, `PROP4_`, `PROP5_`, `PROP6_`, `TYPE_`, `TENANT_ID_`, `CREATE_ORG_ID_`, `UPDATE_BY_`, `UPDATE_TIME_`) VALUES ('5', NULL, '业务咨询', NULL, 'folder', 'images\\five.png', NULL, 14812, 'png', '14.46 KB', '1', '超级管理员', '2020-11-23 15:07:44', '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '-1', '', NULL, NULL); INSERT INTO `portal_sys_file`(`ID_`, `XB_TYPE_ID_`, `FILE_NAME_`, `FILE_TYPE_`, `STORE_TYPE_`, `FILE_PATH_`, `BYTES_`, `BYTE_COUNT_`, `EXT_`, `NOTE_`, `CREATE_BY_`, `CREATOR_NAME_`, `CREATE_TIME_`, `IS_DEL_`, `PROP1_`, `PROP2_`, `PROP3_`, `PROP4_`, `PROP5_`, `PROP6_`, `TYPE_`, `TENANT_ID_`, `CREATE_ORG_ID_`, `UPDATE_BY_`, `UPDATE_TIME_`) VALUES ('6', NULL, '费用预算明细表_导入模板', NULL, 'folder', 'images\\six.png', NULL, 5632, 'xls', '5.50 KB', '1324559179100327936', 'yh1', '2020-11-23 14:50:07', '0', NULL, NULL, NULL, NULL, NULL, NULL, NULL, '-1', '', NULL, NULL); -- 插入新闻公告内容 lucong INSERT INTO `portal_news_notice_`(`ID_`, `CLASSIFY_ID_`, `CLASSIFY_NAME_`, `CLASSIFY_PATH_`, `TITLE_`, `IS_URL_`, `URL_`, `CONTENT_`, `SN_`, `END_TIME_`, `ROTATING_DISPLAY_PICTURES_`, `TITLE_DESCRIPTION_`, `PAGE_HEIGHT_`, `TENANT_ID_`, `CREATE_TIME_`, `CREATE_BY_`, `UPDATE_TIME_`, `UPDATE_BY_`, `TYPE_`, `ICON_`, `FILE_`, `DRAFTER_`) VALUES ('1325679810151845888', '1325679230087991296', '知识必读', '100.1325679193043898368.1325679230087991296.', '宏天软件EIP产品帮助说明', 'true', 'http://www.hotent.org:5171/eip_saas/', NULL, 1, NULL, NULL, '', '800', '-1', '2020-11-09 14:01:11', '1', '2020-11-23 13:42:42', '1', 2, NULL, NULL, '小宏'); INSERT INTO `portal_news_notice_`(`ID_`, `CLASSIFY_ID_`, `CLASSIFY_NAME_`, `CLASSIFY_PATH_`, `TITLE_`, `IS_URL_`, `URL_`, `CONTENT_`, `SN_`, `END_TIME_`, `ROTATING_DISPLAY_PICTURES_`, `TITLE_DESCRIPTION_`, `PAGE_HEIGHT_`, `TENANT_ID_`, `CREATE_TIME_`, `CREATE_BY_`, `UPDATE_TIME_`, `UPDATE_BY_`, `TYPE_`, `ICON_`, `FILE_`, `DRAFTER_`) VALUES ('1325680074938257408', '1325679230087991296', '知识必读', '100.1325679193043898368.1325679230087991296.', '小宏来帮您', 'true', 'https://bot.4paradigm.com/web/chat/14420/510cee75-4203-4966-888f-850abcd8da9c', NULL, 2, NULL, NULL, '', '800', '-1', '2020-11-09 14:02:14', '1', '2020-11-23 13:42:46', '1', 2, NULL, NULL, '小宏'); INSERT INTO `portal_news_notice_`(`ID_`, `CLASSIFY_ID_`, `CLASSIFY_NAME_`, `CLASSIFY_PATH_`, `TITLE_`, `IS_URL_`, `URL_`, `CONTENT_`, `SN_`, `END_TIME_`, `ROTATING_DISPLAY_PICTURES_`, `TITLE_DESCRIPTION_`, `PAGE_HEIGHT_`, `TENANT_ID_`, `CREATE_TIME_`, `CREATE_BY_`, `UPDATE_TIME_`, `UPDATE_BY_`, `TYPE_`, `ICON_`, `FILE_`, `DRAFTER_`) VALUES ('1325681305643520000', '1325679230087991296', '系统帮助', '100.1325679193043898368.1325679230087991296.', '版本更新说明', 'true', 'http://www.hotent.org:5171/eip_saas/mdFile/update/eip_saas_725.html', NULL, 3, NULL, NULL, '', '800', '-1', '2020-11-09 14:07:08', '1', '2020-11-09 14:15:49', '1', 2, NULL, NULL, '小宏'); INSERT INTO `portal_news_notice_`(`ID_`, `CLASSIFY_ID_`, `CLASSIFY_NAME_`, `CLASSIFY_PATH_`, `TITLE_`, `IS_URL_`, `URL_`, `CONTENT_`, `SN_`, `END_TIME_`, `ROTATING_DISPLAY_PICTURES_`, `TITLE_DESCRIPTION_`, `PAGE_HEIGHT_`, `TENANT_ID_`, `CREATE_TIME_`, `CREATE_BY_`, `UPDATE_TIME_`, `UPDATE_BY_`, `TYPE_`, `ICON_`, `FILE_`, `DRAFTER_`) VALUES ('1325681714877566976', '1325679230087991296', '系统帮助', '100.1325679193043898368.1325679230087991296.', '欢迎了解宏天软件', 'true', 'https://www.hotent.com/', NULL, 4, NULL, NULL, '', '800', '-1', '2020-11-09 14:08:45', '1', '2020-11-09 14:15:44', '1', 2, NULL, NULL, '小宏'); INSERT INTO `portal_news_notice_`(`ID_`, `CLASSIFY_ID_`, `CLASSIFY_NAME_`, `CLASSIFY_PATH_`, `TITLE_`, `IS_URL_`, `URL_`, `CONTENT_`, `SN_`, `END_TIME_`, `ROTATING_DISPLAY_PICTURES_`, `TITLE_DESCRIPTION_`, `PAGE_HEIGHT_`, `TENANT_ID_`, `CREATE_TIME_`, `CREATE_BY_`, `UPDATE_TIME_`, `UPDATE_BY_`, `TYPE_`, `ICON_`, `FILE_`, `DRAFTER_`) VALUES ('1325681895811452928', '1325679230087991296', '系统帮助', '100.1325679193043898368.1325679230087991296.', '宏天软件最新产品试用', 'true', 'http://sso.hotent.com/login', NULL, 5, NULL, NULL, '', '800', '-1', '2020-11-09 14:09:29', '1', '2020-11-09 14:15:40', '1', 2, NULL, NULL, '小宏'); INSERT INTO `portal_news_notice_`(`ID_`, `CLASSIFY_ID_`, `CLASSIFY_NAME_`, `CLASSIFY_PATH_`, `TITLE_`, `IS_URL_`, `URL_`, `CONTENT_`, `SN_`, `END_TIME_`, `ROTATING_DISPLAY_PICTURES_`, `TITLE_DESCRIPTION_`, `PAGE_HEIGHT_`, `TENANT_ID_`, `CREATE_TIME_`, `CREATE_BY_`, `UPDATE_TIME_`, `UPDATE_BY_`, `TYPE_`, `ICON_`, `FILE_`, `DRAFTER_`) VALUES ('1330711296110366720', '1330698840872980480', '宏天软件', '200.1325679288829218816.1330698840872980480.', '产品中心', 'false', 'https://www.hotent.com/products.html', '

联系我们

020-89089123

邮　　箱：hotent@jee-soft.cn

技术Q群：142215631

地　　址：广州市海珠区新港东路1000号西塔Ｃ座2005室

邮政编号：510308

传真号码：020-89089366


', 0, NULL, '3', NULL, '800', '-1', '2020-11-23 11:14:31', '1', '2020-11-23 15:08:53', '1', 1, NULL, NULL, '小宏'); INSERT INTO `portal_news_notice_`(`ID_`, `CLASSIFY_ID_`, `CLASSIFY_NAME_`, `CLASSIFY_PATH_`, `TITLE_`, `IS_URL_`, `URL_`, `CONTENT_`, `SN_`, `END_TIME_`, `ROTATING_DISPLAY_PICTURES_`, `TITLE_DESCRIPTION_`, `PAGE_HEIGHT_`, `TENANT_ID_`, `CREATE_TIME_`, `CREATE_BY_`, `UPDATE_TIME_`, `UPDATE_BY_`, `TYPE_`, `ICON_`, `FILE_`, `DRAFTER_`) VALUES ('1330711456060149760', '1330698840872980480', '宏天软件', '200.1325679288829218816.1330698840872980480.', '解决方案', 'true', 'https://www.hotent.com/solutions.html', NULL, 0, NULL, '1', NULL, '800', '-1', '2020-11-23 11:15:09', '1', '2020-11-23 15:07:57', '1', 1, NULL, NULL, '小宏'); INSERT INTO `portal_news_notice_`(`ID_`, `CLASSIFY_ID_`, `CLASSIFY_NAME_`, `CLASSIFY_PATH_`, `TITLE_`, `IS_URL_`, `URL_`, `CONTENT_`, `SN_`, `END_TIME_`, `ROTATING_DISPLAY_PICTURES_`, `TITLE_DESCRIPTION_`, `PAGE_HEIGHT_`, `TENANT_ID_`, `CREATE_TIME_`, `CREATE_BY_`, `UPDATE_TIME_`, `UPDATE_BY_`, `TYPE_`, `ICON_`, `FILE_`, `DRAFTER_`) VALUES ('1330712214058962944', '1330698840872980480', '宏天软件', '200.1325679288829218816.1330698840872980480.', '客户案例', 'true', 'https://www.hotent.com/case.html', NULL, 0, NULL, '2', NULL, '800', '-1', '2020-11-23 11:18:10', '1', '2020-11-23 15:08:11', '1', 1, NULL, NULL, '小宏'); INSERT INTO `portal_news_notice_`(`ID_`, `CLASSIFY_ID_`, `CLASSIFY_NAME_`, `CLASSIFY_PATH_`, `TITLE_`, `IS_URL_`, `URL_`, `CONTENT_`, `SN_`, `END_TIME_`, `ROTATING_DISPLAY_PICTURES_`, `TITLE_DESCRIPTION_`, `PAGE_HEIGHT_`, `TENANT_ID_`, `CREATE_TIME_`, `CREATE_BY_`, `UPDATE_TIME_`, `UPDATE_BY_`, `TYPE_`, `ICON_`, `FILE_`, `DRAFTER_`) VALUES ('1330747232420499456', '1330747098659950592', '宏天信息', '200.1325679288829218816.1330747098659950592.', '商务咨询', 'false', NULL, '

联系我们

020-89089123

邮　　箱：hotent@jee-soft.cn

技术Q群：142215631

地　　址：广州市海珠区新港东路1000号西塔Ｃ座2005室

邮政编号：510308

传真号码：020-89089366

', 3, NULL, '6', NULL, NULL, '-1', '2020-11-23 13:37:19', '1', '2020-11-23 13:39:56', '1', 1, NULL, NULL, '小宏'); INSERT INTO `portal_news_notice_`(`ID_`, `CLASSIFY_ID_`, `CLASSIFY_NAME_`, `CLASSIFY_PATH_`, `TITLE_`, `IS_URL_`, `URL_`, `CONTENT_`, `SN_`, `END_TIME_`, `ROTATING_DISPLAY_PICTURES_`, `TITLE_DESCRIPTION_`, `PAGE_HEIGHT_`, `TENANT_ID_`, `CREATE_TIME_`, `CREATE_BY_`, `UPDATE_TIME_`, `UPDATE_BY_`, `TYPE_`, `ICON_`, `FILE_`, `DRAFTER_`) VALUES ('1330747415233433600', '1330747098659950592', '宏天信息', '200.1325679288829218816.1330747098659950592.', '客户墙', 'false', NULL, '

越来越多的大公司愿意与宏天合作


传统&高科制造

辽宁忠旺集团有限公司 

广东科达洁能股份有限公司 

金鹏电子信息机器有限公司 

中国万向控股有限公司

纳思达股份有限公司

江门大长江集团

华润三九医药股份有限公司

香港澳美制药集团

深圳市汇顶科技股份有限公司

欧派集团

富士康集团

兴奇集团（广东兴奇金属有限公司）

武汉武船信息集成有限公司

广东芯智慧科技有限公司（保利地产） 

宝时得机械（中国）有限公司 

浙江美华包装机械有限公司

北京工大智源科技发展有限公司 

江苏凯路威电子有限公司

北京索德电气工业有限公司 

河南思维自动化设备股份有限公司

合肥开元精密工程有限责任公司 

东聚电子电讯制品有限公司 

施耐德（广州）母线有限公司  

通信运营

中国电信股份有限公司 

卓望数码技术（深圳）有限公司

大唐软件技术股份有限公司

广州从兴电子开发有限公司

爱立信

深圳天珑移动技术股份有限公司

福建福诺移动通信技术有限公司

江苏怡丰通信设备有限公司 

长春市杰迅联合通信网络有限公司 

深圳市讯方通信技术有限公司 

宁波市安贞信息科技有限公司 

四川川大金键信息产业有限责任公司 

湖南创发天辰科技有限责任公司

军工航空航天

航天科工集团

航天恒星科技有限公司 

中国航空无线电电子研究所 

航天云网科技发展有限责任公司

北京仿真中心

航天软件评测中心

海南航空股份有限公司

金融证券

深圳证券交易所

中信集团

华泰联合证券有限责任公司

前海股权交易中心 

易智付科技（北京）有限公司

深圳前海大道金融服务有限公司 

深圳市金斧子网络科技有限公司

厦门弘信创业工场投资集团股份有限公司 

政府&公共单位

中央国债登记结算有限责任公司 

农业部渔业渔政管理局 

国家知识产权中心，中船，武船

兰州市政府 ，绍兴市政府，武汉城管局

北京交通大学，昆明铁路局

北京师范大学、北京工业大学

西北民族大学 、吉林大学 

哈尔滨工程大学

广东职业技术学院

中科院深圳先进技术研究院 

深圳市深圳通有限公司 

哈尔滨交研交通工程有限责任公司 

能源电力

国家电网，南方电网

东莞供电局，东莞电力设计院

广东电网公司电力科学研究院

国家核电示范基地有限公司

西部管道公司，山东能源集团

山西冀中能源集团

新疆石油勘察设计研究院 

秦皇岛晨砻信息科技有限公司

快消&零售物流

中国邮政

顺丰集团

万达集团

上海旭辉集团

茂业百货集团

天河城、天虹

印力地产

太平洋百货

银泰百货、同仁堂

深圳海雅集团

深圳海岸城集团

苏酒集团

绍兴商盈服饰有限公司 

全领域合作客户——IT&互联网


中国电子系统技术有限公司

中国软件与技术服务股份有限公司

北京太极信息系统技术有限公司

大唐软件技术股份有限公司

广州从兴电子开发有限公司

北京北科维拓科技有限公司

西安未来国际信息股份有限公司 

易智付科技（北京）有限公司

卓望数码技术（深圳）有限公司

中信网络科技有限公司

广州粤能信息技术有限公司 

深圳市金斧子网络科技有限公司

北京天下图数据技术有限公司

湖南长信畅中科技股份有限公司

江苏华生恒业科技有限公司

捷达世软件（深圳）有限公司

象翌微链科技发展有限公司

上海亚太计算机信息系统有限公司

山西精英科技股份有限公司 

深圳市中博科创信息技术有限公司

易云捷讯科技（北京）股份有限公司

石家庄惠远邮电设计咨询有限公司

秦皇岛晨砻信息科技有限公司

成都依能科技股份有限公司

山东潍科软件科技有限公司

腾讯科技（深圳）有限公司

德勤管理咨询（上海）有限公司 

武汉武船信息集成有限公司

首都信息发展股份有限公司

湖南湘邮科技股份有限公司

湖南新云网科技有限公司

团车互联网信息服务（北京）有限公司

湖南大洋有限公司 

北京爱迪思维科技发展有限公司

北京信普达系统工程有限公司

天津中软软件系统有限公司 

海南残友科技发展有限公司（大德宝）

北京长远视通科技有限公司 

广东益泰达科技发展有限公司

山东新海软件股份有限公司 

厦门福旺达信息科技有限公司 

河北汉佳电子科技有限公司 

北京国研网络数据科技有限公司

北京天作科技有限公司 

广东汇卡商务服务有限公司

镇江市新创计算机系统集成有限公司 

厦门微谷信息技术有限公司 

昆山百润科技有限公司 

兰州北科维拓科技股份有限公司 

吉林省纵横软件开发有限公司 

中电智绘系统技术有限公司

正方软件股份有限公司 

广州博纳信息技术有限公司

大连创盛科技有限公司 

深圳市共济科技股份有限公司 

海南信息岛技术服务中心有限公司 

广州联奕信息科技有限公司

北京北斗兴业信息技术有限公司

河南思维自动化设备股份有限公司

南京英派电子科技有限公司

内蒙古坤兰科技有限责任公司 

广州智算信息技术有限公司

深圳市奥宇节能技术股份有限公司 

深圳市安亿通科技发展有限公司 

天津煊塬科技有限公司 

邯郸市帅先电子有限公司 

武汉锐昊泰科技有限公司 

哈尔滨金地多维科技发展有限公司 

佛山市科瑞森科技有限公司 

黑龙江长周科技有限公司 

沈阳艾尔时代科技发展有限公司 

广州市睿志信息科技有限公司

深圳天珑移动技术股份有限公司

北京灵信互动信息技术有限公司

新疆信智远达信息技术有限公司

北京旋极信息技术股份有限公司

深圳普华春天科技发展有限公司 

深圳市前海圆舟网络科技股份有限公司

深圳国泰安教育技术股份有限公司

广州佰仲企业管理顾问有限公司 

北京行智信天成咨询有限责任公司 

广东地球村计算机系统有限公司

内蒙古坤兰科技有限责任公司 

南京英派电子科技有限公司 

广州联奕信息科技有限公司

广东金质信息技术有限公司 

北京腾信软创科技有限公司 

北京新锐创想科技有限公司

黑龙江长周科技有限公司 

乌鲁木齐俊涛伟业科技有限公司

河南软信科技有限公司

长春雅森达科技有限责任公司

福建福诺移动通信技术有限公司

大唐云动力科技股份有限公司 

辽宁同泽通信技术有限公司 

成都汇码科技有限公司

广东凤凰高科电子商务有限公司

江西泰豪信息技术有限公司

人网(北京）信息科技有限公司





', 1, NULL, '4', NULL, NULL, '-1', '2020-11-23 13:38:03', '1', '2020-11-23 13:39:44', '1', 1, NULL, NULL, '小宏'); INSERT INTO `portal_news_notice_`(`ID_`, `CLASSIFY_ID_`, `CLASSIFY_NAME_`, `CLASSIFY_PATH_`, `TITLE_`, `IS_URL_`, `URL_`, `CONTENT_`, `SN_`, `END_TIME_`, `ROTATING_DISPLAY_PICTURES_`, `TITLE_DESCRIPTION_`, `PAGE_HEIGHT_`, `TENANT_ID_`, `CREATE_TIME_`, `CREATE_BY_`, `UPDATE_TIME_`, `UPDATE_BY_`, `TYPE_`, `ICON_`, `FILE_`, `DRAFTER_`) VALUES ('1330747528550944768', '1330747098659950592', '宏天信息', '200.1325679288829218816.1330747098659950592.', '核心功能', 'false', NULL, '

我们可以是：

移动端

门户平台

表单引擎

流程引擎

用户中心

快速开发平台


', 2, NULL, '5', NULL, NULL, '-1', '2020-11-23 13:38:30', '1', '2020-11-23 13:39:49', '1', 1, NULL, NULL, '小宏'); -- 增加移动端栏目-lucong INSERT INTO `portal_sys_news_column`(`ID_`, `PORTAL_NEWS_ID_`, `NAME_`, `TYPE_`, `TENANT_ID_`) VALUES ('1330779070446833664', '1325679230087991296', '系统帮助', '0', '-1'); INSERT INTO `portal_sys_news_column`(`ID_`, `PORTAL_NEWS_ID_`, `NAME_`, `TYPE_`, `TENANT_ID_`) VALUES ('1330779114596077568', '1330747098659950592', '宏天信息', '1', '-1'); -- 增加数据报表 INSERT INTO `form_custom_chart`(`ID_`, `NAME_`, `ALIAS_`, `STYLE_`, `OBJ_NAME_`, `DISPLAYFIELD_`, `CONDITIONFIELD_`, `RESULTFIELD_`, `SORTFIELD_`, `DSALIAS_`, `IS_TABLE_`, `DIY_SQL_`, `WIDTH_`, `HEIGHT_`, `XAXIS_FIELD_`, `YAXIS_UNIT_`, `CONF_`, `TENANT_ID_`, `CREATE_TIME_`, `UPDATE_TIME_`, `CREATE_BY_`, `UPDATE_BY_`, `CREATE_ORG_ID_`) VALUES ('1330698555119243264', '新闻数量统计', 'xwsltj', 1, NULL, '[{"comment":"数量","dbType":"bigint","field":"NO","nameKey":"0","type":"line","yAxis":1}]', '[]', NULL, '[]', 'LOCAL', 2, 'select classify_name_,count(classify_name_) as no from portal_news_notice_ group by classify_name_', 400, 200, '[{"comment":"新闻类型","dbType":"varchar","field":"CLASSIFY_NAME_","nameKey":"0"}]', NULL, '{"maxLength":0,"yMin":"1","xShowAll":"1","theme":"default","title":{"show":true,"textStyle":{"fontStyle":"normal","fontFamily":"sans-serif","fontSize":18},"subtext":"","left":"auto","top":"auto"},"legend":{"show":true,"type":"plain","left":"auto","top":"auto","orient":"horizontal"},"series":{"doubleYAxis":true,"stack":false,"showType":true,"smooth":true,"dataZoom":false}}', '-1', '2020-11-23 10:23:53', NULL, '1', NULL, ''); -- 调整门户默认栏目-lucong UPDATE `portal_sys_column` SET `COL_HEIGHT` = 300 WHERE `ID` = '1267768754310352896'; UPDATE `portal_sys_column` SET `COL_HEIGHT` = 200 WHERE `ID` = '1267776505338007552'; UPDATE `portal_sys_column` SET `TEMPLATE_HTML` = 'PGVsLXRhYmxlIDpkYXRhPSJkYXRhLnJvd3MiIGFsaWduPSJsZWZ0Ij4KICAgIDxlbC10YWJsZS1jb2x1bW4gdHlwZT0iaW5kZXgiIGFsaWduPSJsZWZ0IiBsYWJlbD0i5bqP5Y+3Ij48L2VsLXRhYmxlLWNvbHVtbj4KICAgIDxlbC10YWJsZS1jb2x1bW4gbGFiZWw9Iuagh+mimCIgYWxpZ249ImxlZnQiIHdpZHRoPSIzMDAiIHNob3ctb3ZlcmZsb3ctdG9vbHRpcD4KICAgICAgICA8dGVtcGxhdGUgc2xvdC1zY29wZT0ic2NvcGUiIGFsaWduPSJsZWZ0Ij4KICAgICAgICAgICAgPHNwYW4gY2xhc3M9InRvZG8tc3ViamVjdCIgQGNsaWNrPSJoYW5kbGVUb2RvQ2xpY2soc2NvcGUucm93KSI+e3tzY29wZS5yb3cuc3ViamVjdH19PC9zcGFuPgogICAgICAgIDwvdGVtcGxhdGU+CiAgICA8L2VsLXRhYmxlLWNvbHVtbj4KICAgIDxlbC10YWJsZS1jb2x1bW4gcHJvcD0iY3JlYXRlVGltZSIgbGFiZWw9IuWIsOi+vuaXtumXtCIgc2hvdy1vdmVyZmxvdy10b29sdGlwIGFsaWduPSJsZWZ0Ij48L2VsLXRhYmxlLWNvbHVtbj4KICAgIDxlbC10YWJsZS1jb2x1bW4gd2lkdGg9IjkwIiBhbGlnbj0ibGVmdCIgbGFiZWw9Iuexu+WeiyI+CiAgICAgICAgPHRlbXBsYXRlIHNsb3Qtc2NvcGU9Insgcm93IH0iPgogICAgICAgICAgICAgIDxzcGFuIHNpemU9InNtYWxsIiBjbGFzcz0iYmx1ZS1jb2xvciI+e3sKICAgICAgICAgICAgICAgIHN0YXR1c1tyb3cuc3RhdHVzXSArCiAgICAgICAgICAgICAgICAocm93Lmluc3RJc0ZvcmJpZGRlbiA9PT0gIjEiID8gIijmjILotbcpIiA6ICIiKQogICAgICAgICAgICAgIH19PC9zcGFuPgogICAgICAgICAgICA8L3RlbXBsYXRlPgogICAgPC9lbC10YWJsZS1jb2x1bW4+CjwvZWwtdGFibGU+' WHERE `ALIAS` = 'vueTodo'; INSERT INTO `portal_sys_column`(`ID`, `NAME`, `ALIAS`, `CATALOG`, `COL_TYPE`, `DATA_MODE`, `DATA_FROM`, `DS_ALIAS`, `DS_NAME`, `COL_HEIGHT`, `COL_URL`, `TEMPLATE_HTML`, `IS_PUBLIC`, `SUPPORT_REFESH`, `REFESH_TIME`, `SHOW_EFFECT`, `MEMO`, `DATA_PARAM`, `NEEDPAGE`, `ORG_ID`, `CREATOR`, `CREATE_BY_`, `UPDATE_BY_`, `CREATE_TIME_`, `UPDATE_TIME_`, `REQUEST_TYPE`, `CATALOG_NAME`, `CREATE_ORG_ID_`, `TENANT_ID_`) VALUES ('18', '系统帮助', '1325679230087991296', '31081', 0, NULL, '', '', NULL, 300, '/newsList/1325679230087991296', 'PGhvbWUtbmV3cy1saXN0IGNsYXNzaWZ5SWQ9JzEzMjU2NzkyMzAwODc5OTEyOTYnLz4=', 2, NULL, NULL, NULL, '', '', 0, NULL, NULL, '1', '1', '2020-11-09 14:09:33', '2020-11-23 11:08:24', '', '默认分类', '', '-1'); INSERT INTO `portal_sys_column`(`ID`, `NAME`, `ALIAS`, `CATALOG`, `COL_TYPE`, `DATA_MODE`, `DATA_FROM`, `DS_ALIAS`, `DS_NAME`, `COL_HEIGHT`, `COL_URL`, `TEMPLATE_HTML`, `IS_PUBLIC`, `SUPPORT_REFESH`, `REFESH_TIME`, `SHOW_EFFECT`, `MEMO`, `DATA_PARAM`, `NEEDPAGE`, `ORG_ID`, `CREATOR`, `CREATE_BY_`, `UPDATE_BY_`, `CREATE_TIME_`, `UPDATE_TIME_`, `REQUEST_TYPE`, `CATALOG_NAME`, `CREATE_ORG_ID_`, `TENANT_ID_`) VALUES ('19', '宏天软件', '1330698840872980480', '31081', 0, NULL, '', '', NULL, 200, '', 'PGhvbWVDYXJvdXNlbCBoZWlnaHQ9JzEwMCcgY2xhc3NpZnlJZD0nMTMzMDY5ODg0MDg3Mjk4MDQ4MCcgOmludGVydmFsPScwJy8+', 2, NULL, NULL, NULL, '', '', 0, NULL, NULL, '1', '1', '2020-11-23 10:29:22', '2020-11-23 10:31:59', '', '默认分类', '', '-1'); INSERT INTO `portal_sys_column`(`ID`, `NAME`, `ALIAS`, `CATALOG`, `COL_TYPE`, `DATA_MODE`, `DATA_FROM`, `DS_ALIAS`, `DS_NAME`, `COL_HEIGHT`, `COL_URL`, `TEMPLATE_HTML`, `IS_PUBLIC`, `SUPPORT_REFESH`, `REFESH_TIME`, `SHOW_EFFECT`, `MEMO`, `DATA_PARAM`, `NEEDPAGE`, `ORG_ID`, `CREATOR`, `CREATE_BY_`, `UPDATE_BY_`, `CREATE_TIME_`, `UPDATE_TIME_`, `REQUEST_TYPE`, `CATALOG_NAME`, `CREATE_ORG_ID_`, `TENANT_ID_`) VALUES ('20', '新闻公告信息', 'xwggxx', '31081', 4, NULL, '', '', NULL, 300, '', '', 2, NULL, NULL, NULL, '', '{"id":"1330698555119243264","name":"新闻数量统计","chartType":2}', 0, NULL, NULL, '1', '1', '2020-11-23 11:04:59', '2020-11-23 11:05:48', '', '默认分类', '', '-1'); INSERT INTO `portal_sys_column`(`ID`, `NAME`, `ALIAS`, `CATALOG`, `COL_TYPE`, `DATA_MODE`, `DATA_FROM`, `DS_ALIAS`, `DS_NAME`, `COL_HEIGHT`, `COL_URL`, `TEMPLATE_HTML`, `IS_PUBLIC`, `SUPPORT_REFESH`, `REFESH_TIME`, `SHOW_EFFECT`, `MEMO`, `DATA_PARAM`, `NEEDPAGE`, `ORG_ID`, `CREATOR`, `CREATE_BY_`, `UPDATE_BY_`, `CREATE_TIME_`, `UPDATE_TIME_`, `REQUEST_TYPE`, `CATALOG_NAME`, `CREATE_ORG_ID_`, `TENANT_ID_`) VALUES ('21', '宏天信息', '1330747098659950592', '31081', 0, NULL, '', '', NULL, 300, '', 'PGhvbWVDYXJvdXNlbCBoZWlnaHQ9JzEwMCcgY2xhc3NpZnlJZD0nMTMzMDc0NzA5ODY1OTk1MDU5MicgOmludGVydmFsPSdudWxsJy8+', 2, NULL, NULL, NULL, '', '', 0, NULL, NULL, '1', '1', '2020-11-23 13:38:40', '2020-11-23 13:39:03', '', '默认分类', '', '-1'); INSERT INTO `portal_sys_column`(`ID`, `NAME`, `ALIAS`, `CATALOG`, `COL_TYPE`, `DATA_MODE`, `DATA_FROM`, `DS_ALIAS`, `DS_NAME`, `COL_HEIGHT`, `COL_URL`, `TEMPLATE_HTML`, `IS_PUBLIC`, `SUPPORT_REFESH`, `REFESH_TIME`, `SHOW_EFFECT`, `MEMO`, `DATA_PARAM`, `NEEDPAGE`, `ORG_ID`, `CREATOR`, `CREATE_BY_`, `UPDATE_BY_`, `CREATE_TIME_`, `UPDATE_TIME_`, `REQUEST_TYPE`, `CATALOG_NAME`, `CREATE_ORG_ID_`, `TENANT_ID_`) VALUES ('22', '常用系统', 'cyxt', '31081', 0, NULL, '', '', NULL, 80, '', 'PGRpdiBzdHlsZT0idGV4dC1hbGlnbjpjZW50ZXIiPgoJPGVsLXJvdyA6Z3V0dGVyPSIyMCIgc3R5bGU9InBhZGRpbmctdG9wOiAxMHB4O3BhZGRpbmctYm90dG9tOjEwcHg7Ij4KCgkJPGVsLWNvbCA6c3Bhbj0iMyIgc3R5bGU9InBhZGRpbmctdG9wOjVweCI+CgkJCTxkaXYgc3R5bGU9ImZsb2F0OmxlZnQ7IiBvbmNsaWNrPSJ3aW5kb3cub3BlbignaHR0cDovL3d3dy5ob3RlbnQuY29tJywnJywnJyk7Ij4KCQkJCTxkaXYgc3R5bGU9ImZsb2F0OmxlZnQ7d2lkdGg6NDJweDtoZWlnaHQ6NDJweDtiYWNrZ3JvdW5kOiMwZjBjZTg7Ym9yZGVyLXJhZGl1czoyMXB4OyI+CiAgICAgICAgICA8c3BhbiAgc3R5bGU9ImZvbnQtc2l6ZTogMjhweDsgcGFkZGluZzogMTRweDsgY29sb3I6IHJnYigyNTUsIDI1NSwgMjU1KTsiPiAgRSAgPC9zcGFuPgogICAgICAgICAgICAKCQkJCTwvZGl2PgoJCQkJPGRpdiBzdHlsZT0iZmxvYXQ6bGVmdDsgcGFkZGluZy1sZWZ0OjhweDsiPgoJCQkJCQkJCQkJPGRpdj4gPHNwYW4gc3R5bGU9ImZvbnQtc2l6ZToyMHB4O2ZvbnQtZmFtaWx5Ok1pY3Jvc29mdCBZYUhlaTtmb250LXdlaWdodDo0MDA7Y29sb3I6cmdiYSg0MCw0MSw0MSwxKTtsaW5lLWhlaWdodDozMHB4OyI+RVJQ566h55CG57O757ufPC9zcGFuPjwvZGl2PgoJCQkJPC9kaXY+CgkJCTwvZGl2PgoJCQk8ZGl2IHN0eWxlPSJmbG9hdDpyaWdodDsiPgogICAgPHNwYW4gY2xhc3M9ImVsLWRpdmlkZXIgZWwtZGl2aWRlci0tdmVydGljYWwiIHN0eWxlPSJmb250LXNpemU6NDBweDsiPgogICAgICA8L3NwYW4+CgkJCTwvZGl2PgoJCTwvZWwtY29sPgoJCTxlbC1jb2wgOnNwYW49IjMiIHN0eWxlPSJwYWRkaW5nLXRvcDo1cHgiPgoJCQk8ZGl2IHN0eWxlPSJmbG9hdDpsZWZ0OyIgIG9uY2xpY2s9IndpbmRvdy5vcGVuKCdodHRwOi8vd3d3LmhvdGVudC5jb20nLCcnLCcnKTsiPgoJCQkJPGRpdiBzdHlsZT0iZmxvYXQ6bGVmdDt3aWR0aDo0MnB4O2hlaWdodDo0MnB4O2JhY2tncm91bmQ6IzI5MjkyOTtib3JkZXItcmFkaXVzOjIxcHg7Ij4KICAgICAgICAgIDxzcGFuICBzdHlsZT0iZm9udC1zaXplOiAyOHB4OyBwYWRkaW5nOiAxNHB4OyBjb2xvcjogcmdiKDI1NSwgMjU1LCAyNTUpOyI+ICBQICA8L3NwYW4+CiAgICAgICAgICAgIAoJCQkJPC9kaXY+CgkJCQk8ZGl2IHN0eWxlPSJmbG9hdDpsZWZ0OyBwYWRkaW5nLWxlZnQ6OHB4OyI+CgkJCQkJPGRpdj4gPHNwYW4gc3R5bGU9ImZvbnQtc2l6ZToyMHB4O2ZvbnQtZmFtaWx5Ok1pY3Jvc29mdCBZYUhlaTtmb250LXdlaWdodDo0MDA7Y29sb3I6cmdiYSg0MCw0MSw0MSwxKTtsaW5lLWhlaWdodDozMHB4OyI+UE3ns7vnu588L3NwYW4+PC9kaXY+CgkJCQk8L2Rpdj4KCQkJPC9kaXY+CgkJCTxkaXYgc3R5bGU9ImZsb2F0OnJpZ2h0OyI+CiAgICA8c3BhbiBjbGFzcz0iZWwtZGl2aWRlciBlbC1kaXZpZGVyLS12ZXJ0aWNhbCIgc3R5bGU9ImZvbnQtc2l6ZTo0MHB4OyI+CiAgICAgIDwvc3Bhbj4KCQkJPC9kaXY+CgkJPC9lbC1jb2w+CgkJPGVsLWNvbCA6c3Bhbj0iMyIgc3R5bGU9InBhZGRpbmctdG9wOjVweCI+CgkJCTxkaXYgc3R5bGU9ImZsb2F0OmxlZnQ7IiAgb25jbGljaz0id2luZG93Lm9wZW4oJ2h0dHA6Ly93d3cuaG90ZW50LmNvbScsJycsJycpOyI+CgkJCQk8ZGl2IHN0eWxlPSJmbG9hdDpsZWZ0O3dpZHRoOjQycHg7aGVpZ2h0OjQycHg7YmFja2dyb3VuZDojYTUwMTAxO2JvcmRlci1yYWRpdXM6MjFweDsiPgogICAgICAgICAgPHNwYW4gIHN0eWxlPSJmb250LXNpemU6IDI4cHg7IHBhZGRpbmc6IDE0cHg7IGNvbG9yOiByZ2IoMjU1LCAyNTUsIDI1NSk7Ij4gIEsgIDwvc3Bhbj4KICAgICAgICAgICAgCgkJCQk8L2Rpdj4KCQkJCTwvZGl2PgoJCQkJPGRpdiBzdHlsZT0iZmxvYXQ6bGVmdDsgcGFkZGluZy1sZWZ0OjhweDsiPgoJCQkJCTxkaXY+IDxzcGFuIHN0eWxlPSJmb250LXNpemU6MjBweDtmb250LWZhbWlseTpNaWNyb3NvZnQgWWFIZWk7Zm9udC13ZWlnaHQ6NDAwO2NvbG9yOnJnYmEoNDAsNDEsNDEsMSk7bGluZS1oZWlnaHQ6MzBweDsiPktN57O757ufPC9zcGFuPjwvZGl2PgoJCQkJPC9kaXY+CgoJCQk8ZGl2IHN0eWxlPSJmbG9hdDpyaWdodDsiPgogICAgPHNwYW4gY2xhc3M9ImVsLWRpdmlkZXIgZWwtZGl2aWRlci0tdmVydGljYWwiIHN0eWxlPSJmb250LXNpemU6NDBweDsiPgogICAgICA8L3NwYW4+CgkJCTwvZGl2PgoJCTwvZWwtY29sPgoJCTxlbC1jb2wgOnNwYW49IjMiIHN0eWxlPSJwYWRkaW5nLXRvcDo1cHgiPgoJCQk8ZGl2IHN0eWxlPSJmbG9hdDpsZWZ0OyIgIG9uY2xpY2s9IndpbmRvdy5vcGVuKCdodHRwOi8vd3d3LmhvdGVudC5jb20nLCcnLCcnKTsiPgoJCQkJPGRpdiBzdHlsZT0iZmxvYXQ6bGVmdDt3aWR0aDo0MnB4O2hlaWdodDo0MnB4O2JhY2tncm91bmQ6IzI4NTgwMztib3JkZXItcmFkaXVzOjIxcHg7Ij4KICAgICAgICAgIDxzcGFuICBzdHlsZT0iZm9udC1zaXplOiAyOHB4OyBwYWRkaW5nOiAxMnB4OyBjb2xvcjogcmdiKDI1NSwgMjU1LCAyNTUpOyI+ICBDICA8L3NwYW4+CiAgICAgICAgICAgIAoJCQkJPC9kaXY+CgkJCQk8ZGl2IHN0eWxlPSJmbG9hdDpsZWZ0OyBwYWRkaW5nLWxlZnQ6OHB4OyI+CgkJCQkJPGRpdj4gPHNwYW4gc3R5bGU9ImZvbnQtc2l6ZToyMHB4O2ZvbnQtZmFtaWx5Ok1pY3Jvc29mdCBZYUhlaTtmb250LXdlaWdodDo0MDA7Y29sb3I6cmdiYSg0MCw0MSw0MSwxKTtsaW5lLWhlaWdodDozMHB4OyI+Q1JN57O757ufPC9zcGFuPjwvZGl2PgoJCQkJPC9kaXY+CgkJCTwvZGl2PgoJCQk8ZGl2IHN0eWxlPSJmbG9hdDpyaWdodDsiPgogICAgPHNwYW4gY2xhc3M9ImVsLWRpdmlkZXIgZWwtZGl2aWRlci0tdmVydGljYWwiIHN0eWxlPSJmb250LXNpemU6NDBweDsiPgogICAgICA8L3NwYW4+CgkJCTwvZGl2PgoJCTwvZWwtY29sPgoJCQkJPGVsLWNvbCA6c3Bhbj0iMyIgc3R5bGU9InBhZGRpbmctdG9wOjVweCI+CgkJCTxkaXYgc3R5bGU9ImZsb2F0OmxlZnQ7IiAgb25jbGljaz0id2luZG93Lm9wZW4oJ2h0dHA6Ly93d3cuaG90ZW50LmNvbScsJycsJycpOyI+CgkJCQkKCQkJCTxkaXYgc3R5bGU9ImZsb2F0OmxlZnQ7d2lkdGg6NDJweDtoZWlnaHQ6NDJweDtiYWNrZ3JvdW5kOiM4YTA0Njc7Ym9yZGVyLXJhZGl1czoyMXB4OyI+CiAgICAgICAgICA8c3BhbiAgc3R5bGU9ImZvbnQtc2l6ZTogMjhweDsgcGFkZGluZzogMTBweDsgY29sb3I6IHJnYigyNTUsIDI1NSwgMjU1KTsiPiAgTyAgPC9zcGFuPgogICAgICAgICAgICAKCQkJCTwvZGl2PgoJCQkJPGRpdiBzdHlsZT0iZmxvYXQ6bGVmdDsgcGFkZGluZy1sZWZ0OjhweDsiPgoJCQkJCTxkaXY+IDxzcGFuIHN0eWxlPSJmb250LXNpemU6MjBweDtmb250LWZhbWlseTpNaWNyb3NvZnQgWWFIZWk7Zm9udC13ZWlnaHQ6NDAwO2NvbG9yOnJnYmEoNDAsNDEsNDEsMSk7bGluZS1oZWlnaHQ6MzBweDsiPk9B57O757ufPC9zcGFuPjwvZGl2PgoJCQkJPC9kaXY+CgkJCTwvZGl2PgoJCQk8ZGl2IHN0eWxlPSJmbG9hdDpyaWdodDsiPgogICAgPHNwYW4gY2xhc3M9ImVsLWRpdmlkZXIgZWwtZGl2aWRlci0tdmVydGljYWwiIHN0eWxlPSJmb250LXNpemU6NDBweDsiPgogICAgICA8L3NwYW4+CgkJCTwvZGl2PgoJCTwvZWwtY29sPgoJCQkJPGVsLWNvbCA6c3Bhbj0iMyIgc3R5bGU9InBhZGRpbmctdG9wOjVweCI+CgkJCTxkaXYgc3R5bGU9ImZsb2F0OmxlZnQ7IiAgb25jbGljaz0id2luZG93Lm9wZW4oJ2h0dHA6Ly93d3cuaG90ZW50LmNvbScsJycsJycpOyI+CgkJCgkJCQk8ZGl2IHN0eWxlPSJmbG9hdDpsZWZ0O3dpZHRoOjQycHg7aGVpZ2h0OjQycHg7YmFja2dyb3VuZDojMDg3NGIzO2JvcmRlci1yYWRpdXM6MjFweDsiPgogICAgICAgICAgPHNwYW4gIHN0eWxlPSJmb250LXNpemU6IDI4cHg7IHBhZGRpbmc6IDE0cHg7IGNvbG9yOiByZ2IoMjU1LCAyNTUsIDI1NSk7Ij4gIFQgIDwvc3Bhbj4KICAgICAgICAgICAgCgkJCQk8L2Rpdj4KCQkJCTxkaXYgc3R5bGU9ImZsb2F0OmxlZnQ7IHBhZGRpbmctbGVmdDo4cHg7Ij4KCQkJCQk8ZGl2PiA8c3BhbiBzdHlsZT0iZm9udC1zaXplOjIwcHg7Zm9udC1mYW1pbHk6TWljcm9zb2Z0IFlhSGVpO2ZvbnQtd2VpZ2h0OjQwMDtjb2xvcjpyZ2JhKDQwLDQxLDQxLDEpO2xpbmUtaGVpZ2h0OjMwcHg7Ij5UQVNL57O757ufPC9zcGFuPjwvZGl2PgoJCQkJPC9kaXY+CgkJCTwvZGl2PgoJCQk8ZGl2IHN0eWxlPSJmbG9hdDpyaWdodDsiPgogICAgPHNwYW4gY2xhc3M9ImVsLWRpdmlkZXIgZWwtZGl2aWRlci0tdmVydGljYWwiIHN0eWxlPSJmb250LXNpemU6NDBweDsiPgogICAgICA8L3NwYW4+CgkJCTwvZGl2PgoJCTwvZWwtY29sPgoJCQkJCQk8ZWwtY29sIDpzcGFuPSIzIiBzdHlsZT0icGFkZGluZy10b3A6NXB4Ij4KCQkJPGRpdiBzdHlsZT0iZmxvYXQ6bGVmdDsiICBvbmNsaWNrPSJ3aW5kb3cub3BlbignaHR0cDovL3d3dy5ob3RlbnQuY29tJywnJywnJyk7Ij4KCQkKCQkJCTxkaXYgc3R5bGU9ImZsb2F0OmxlZnQ7d2lkdGg6NDJweDtoZWlnaHQ6NDJweDtiYWNrZ3JvdW5kOnJnYigxMjUgMTQgMTUyKTtib3JkZXItcmFkaXVzOjIxcHg7Ij4KICAgICAgICAgIDxzcGFuICBzdHlsZT0iZm9udC1zaXplOiAyOHB4OyBwYWRkaW5nOiAxNHB4OyBjb2xvcjogcmdiKDI1NSwgMjU1LCAyNTUpOyI+ICBFICA8L3NwYW4+CiAgICAgICAgICAgIAoJCQkJPC9kaXY+CgkJCQk8ZGl2IHN0eWxlPSJmbG9hdDpsZWZ0OyBwYWRkaW5nLWxlZnQ6OHB4OyI+CgkJCQkJPGRpdj4gPHNwYW4gc3R5bGU9ImZvbnQtc2l6ZToyMHB4O2ZvbnQtZmFtaWx5Ok1pY3Jvc29mdCBZYUhlaTtmb250LXdlaWdodDo0MDA7Y29sb3I6cmdiYSg0MCw0MSw0MSwxKTtsaW5lLWhlaWdodDozMHB4OyI+RUlQPC9zcGFuPjwvZGl2PgoJCQkJPC9kaXY+CgkJCTwvZGl2PgoJCQk8ZGl2IHN0eWxlPSJmbG9hdDpyaWdodDsiPgogICAgPHNwYW4gY2xhc3M9ImVsLWRpdmlkZXIgZWwtZGl2aWRlci0tdmVydGljYWwiIHN0eWxlPSJmb250LXNpemU6NDBweDsiPgogICAgICA8L3NwYW4+CgkJCTwvZGl2PgoJCTwvZWwtY29sPgoJCTxlbC1jb2wgOnNwYW49IjMiIHN0eWxlPSJwYWRkaW5nLXRvcDo1cHgiPgoJCQk8ZGl2IHN0eWxlPSJmbG9hdDpsZWZ0OyIgIG9uY2xpY2s9IndpbmRvdy5vcGVuKCdodHRwOi8vd3d3LmhvdGVudC5jb20nLCcnLCcnKTsiPgoJCQoJCQkJPGRpdiBzdHlsZT0iZmxvYXQ6bGVmdDt3aWR0aDo0MnB4O2hlaWdodDo0MnB4O2JhY2tncm91bmQ6cmdiKDEyOCAxMzAgOSk7Ym9yZGVyLXJhZGl1czoyMXB4OyI+CiAgICAgICAgICA8c3BhbiAgc3R5bGU9ImZvbnQtc2l6ZTogMjhweDsgcGFkZGluZzogMTRweDsgY29sb3I6IHJnYigyNTUsIDI1NSwgMjU1KTsiPiAgSyAgPC9zcGFuPgogICAgICAgICAgICAKCQkJCTwvZGl2PgoJCQkJPGRpdiBzdHlsZT0iZmxvYXQ6bGVmdDsgcGFkZGluZy1sZWZ0OjhweDsiPgoJCQkJCTxkaXY+IDxzcGFuIHN0eWxlPSJmb250LXNpemU6MjBweDtmb250LWZhbWlseTpNaWNyb3NvZnQgWWFIZWk7Zm9udC13ZWlnaHQ6NDAwO2NvbG9yOnJnYmEoNDAsNDEsNDEsMSk7bGluZS1oZWlnaHQ6MzBweDsiPktQSTwvc3Bhbj48L2Rpdj4KCQkJCTwvZGl2PgoJCQk8L2Rpdj4KCQoJCTwvZWwtY29sPgoJPC9lbC1yb3c+CjwvZGl2PgoK', 2, NULL, NULL, NULL, '', '', 0, NULL, NULL, '1', '1', '2020-11-23 19:18:19', '2020-11-23 20:23:04', '', '默认分类', '', '-1'); INSERT INTO `portal_sys_auth_user`(`ID_`, `AUTHORIZE_ID_`, `OWNER_ID_`, `OWNER_NAME_`, `RIGHT_TYPE_`, `OBJ_TYPE_`, `TENANT_ID_`) VALUES ('18', '18', 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 ('19', '19', 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 ('20', '20', 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 ('21', '21', 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 ('22', '22', NULL, NULL, 'everyone', 'indexColumn', '-1'); delete from portal_sys_auth_user where AUTHORIZE_ID_ not in (select id from portal_sys_column); -- 调整应用端默认门户-lucong UPDATE `portal_sys_layout_manage` SET `NAME` = '应用端-系统默认布局', `MEMO` = '', `TEMPLATE_HTML` = '', `DESIGN_HTML` = 'eyJsaXN0IjpbeyJ0eXBlIjoiZ3JpZCIsIm5hbWUiOiLmoIXmoLzluIPlsYAiLCJpY29uIjoiaWNvbi1ncmlkIiwiY29sdW1ucyI6W3sic3BhbiI6MjAsImxpc3QiOlt7Im5hbWUiOiJiYW5uZXIiLCJhbGlhcyI6IjEzMzA2OTg4NDA4NzI5ODA0ODAiLCJvcHRpb25zIjp7InJlbW90ZUZ1bmMiOiJmdW5jXzE2MDYxMDA4MDcwMDBfNzcxMjcifSwia2V5IjoiMTYwNjEwMDgwNzAwMF83NzEyNyIsIm1vZGVsIjoidW5kZWZpbmVkXzE2MDYxMDA4MDcwMDBfNzcxMjciLCJydWxlcyI6W119XX0seyJzcGFuIjo0LCJsaXN0IjpbeyJuYW1lIjoi5bi455So5rWB56iLIiwiYWxpYXMiOiJ2dWVPZnRlbkZsb3ciLCJvcHRpb25zIjp7InJlbW90ZUZ1bmMiOiJmdW5jXzE2MDYwOTY1NzIwMDBfNjc4NTgifSwia2V5IjoiMTYwNjA5NjU3MjAwMF82Nzg1OCIsIm1vZGVsIjoidW5kZWZpbmVkXzE2MDYwOTY1NzIwMDBfNjc4NTgiLCJydWxlcyI6W119XX1dLCJvcHRpb25zIjp7Imd1dHRlciI6NSwianVzdGlmeSI6InN0YXJ0IiwiYWxpZ24iOiJ0b3AiLCJyZW1vdGVGdW5jIjoiZnVuY18xNjA2MDk2NTY1MDAwXzYyNjkxIn0sImtleSI6IjE2MDYwOTY1NjUwMDBfNjI2OTEiLCJtb2RlbCI6ImdyaWRfMTYwNjA5NjU2NTAwMF82MjY5MSIsInJ1bGVzIjpbXX0seyJuYW1lIjoi5bi455So57O757ufIiwiYWxpYXMiOiJjeXh0Iiwib3B0aW9ucyI6eyJyZW1vdGVGdW5jIjoiZnVuY18xNjA2MTMwMzY5MDAwXzI4ODUzIn0sImtleSI6IjE2MDYxMzAzNjkwMDBfMjg4NTMiLCJtb2RlbCI6InVuZGVmaW5lZF8xNjA2MTMwMzY5MDAwXzI4ODUzIiwicnVsZXMiOltdfSx7Im5hbWUiOiLkuKrkurrkv6Hmga/moI/nm64iLCJhbGlhcyI6ImdyeHhsbSIsIm9wdGlvbnMiOnsicmVtb3RlRnVuYyI6ImZ1bmNfMTYwNjEwMDgwNDAwMF8xNzA2In0sImtleSI6IjE2MDYxMDA4MDQwMDBfMTcwNiIsIm1vZGVsIjoidW5kZWZpbmVkXzE2MDYxMDA4MDQwMDBfMTcwNiIsInJ1bGVzIjpbXX0seyJ0eXBlIjoiZ3JpZCIsIm5hbWUiOiLmoIXmoLzluIPlsYAiLCJpY29uIjoiaWNvbi1ncmlkIiwiY29sdW1ucyI6W3sic3BhbiI6MTIsImxpc3QiOlt7Im5hbWUiOiLmiJHnmoTlvoXlip4iLCJhbGlhcyI6InZ1ZVRvZG8iLCJvcHRpb25zIjp7InJlbW90ZUZ1bmMiOiJmdW5jXzE2MDYxMDA3NTQwMDBfMzA1NzYifSwia2V5IjoiMTYwNjEwMDc1NDAwMF8zMDU3NiIsIm1vZGVsIjoidW5kZWZpbmVkXzE2MDYxMDA3NTQwMDBfMzA1NzYiLCJydWxlcyI6W119XX0seyJzcGFuIjoxMiwibGlzdCI6W3sibmFtZSI6IuaWsOmXu+WFrOWRiuS/oeaBryIsImFsaWFzIjoieHdnZ3h4Iiwib3B0aW9ucyI6eyJyZW1vdGVGdW5jIjoiZnVuY18xNjA2MTAwNzU5MDAwXzE0MDQ0In0sImtleSI6IjE2MDYxMDA3NTkwMDBfMTQwNDQiLCJtb2RlbCI6InVuZGVmaW5lZF8xNjA2MTAwNzU5MDAwXzE0MDQ0IiwicnVsZXMiOltdfV19XSwib3B0aW9ucyI6eyJndXR0ZXIiOjUsImp1c3RpZnkiOiJzdGFydCIsImFsaWduIjoidG9wIiwicmVtb3RlRnVuYyI6ImZ1bmNfMTYwNjA5NjU5NzAwMF81NTQ1MCJ9LCJrZXkiOiIxNjA2MDk2NTk3MDAwXzU1NDUwIiwibW9kZWwiOiJncmlkXzE2MDYwOTY1OTcwMDBfNTU0NTAiLCJydWxlcyI6W119LHsidHlwZSI6ImdyaWQiLCJuYW1lIjoi5qCF5qC85biD5bGAIiwiaWNvbiI6Imljb24tZ3JpZCIsImNvbHVtbnMiOlt7InNwYW4iOjE4LCJsaXN0IjpbeyJuYW1lIjoi57O757uf5biu5YqpIiwiYWxpYXMiOiIxMzI1Njc5MjMwMDg3OTkxMjk2Iiwib3B0aW9ucyI6eyJyZW1vdGVGdW5jIjoiZnVuY18xNjA2MDk2MDQ4MDAwXzUxNzYzIn0sImtleSI6IjE2MDYwOTYwNDgwMDBfNTE3NjMiLCJtb2RlbCI6InVuZGVmaW5lZF8xNjA2MDk2MDQ4MDAwXzUxNzYzIiwicnVsZXMiOltdfSx7Im5hbWUiOiLku7vliqHpnaLmnb8iLCJhbGlhcyI6InJ3bWJ2dWUiLCJvcHRpb25zIjp7InJlbW90ZUZ1bmMiOiJmdW5jXzE2MDYwOTYwODAwMDBfMzQ4MyJ9LCJrZXkiOiIxNjA2MDk2MDgwMDAwXzM0ODMiLCJtb2RlbCI6InVuZGVmaW5lZF8xNjA2MDk2MDgwMDAwXzM0ODMiLCJydWxlcyI6W119XX0seyJzcGFuIjo2LCJsaXN0IjpbeyJuYW1lIjoi5a6P5aSp5L+h5oGvIiwiYWxpYXMiOiIxMzMwNzQ3MDk4NjU5OTUwNTkyIiwib3B0aW9ucyI6eyJyZW1vdGVGdW5jIjoiZnVuY18xNjA2MTA5OTUyMDAwXzcyNjM0In0sImtleSI6IjE2MDYxMDk5NTIwMDBfNzI2MzQiLCJtb2RlbCI6InVuZGVmaW5lZF8xNjA2MTA5OTUyMDAwXzcyNjM0IiwicnVsZXMiOltdfSx7Im5hbWUiOiLmnIDmlrDpobnnm64iLCJhbGlhcyI6Inp4eG12dWUiLCJvcHRpb25zIjp7InJlbW90ZUZ1bmMiOiJmdW5jXzE2MDYwOTYwODIwMDBfMjc5MzUifSwia2V5IjoiMTYwNjA5NjA4MjAwMF8yNzkzNSIsIm1vZGVsIjoidW5kZWZpbmVkXzE2MDYwOTYwODIwMDBfMjc5MzUiLCJydWxlcyI6W119XX1dLCJvcHRpb25zIjp7Imd1dHRlciI6NSwianVzdGlmeSI6InN0YXJ0IiwiYWxpZ24iOiJ0b3AiLCJyZW1vdGVGdW5jIjoiZnVuY18xNjA1NTk2NDIyMDAwXzI1MDgyIn0sImtleSI6IjE2MDU1OTY0MjIwMDBfMjUwODIiLCJtb2RlbCI6ImdyaWRfMTYwNTU5NjQyMjAwMF8yNTA4MiIsInJ1bGVzIjpbXX0seyJ0eXBlIjoiZ3JpZCIsIm5hbWUiOiLmoIXmoLzluIPlsYAiLCJpY29uIjoiaWNvbi1ncmlkIiwiY29sdW1ucyI6W3sic3BhbiI6MjQsImxpc3QiOlt7Im5hbWUiOiLlhbPkuo7miJHku6wiLCJhbGlhcyI6Imd5d212dWUiLCJvcHRpb25zIjp7InJlbW90ZUZ1bmMiOiJmdW5jXzE1OTExNDkyMzcwMDBfMjQ5NDUifSwia2V5IjoiMTU5MTE0OTIzNzAwMF8yNDk0NSIsIm1vZGVsIjoidW5kZWZpbmVkXzE1OTExNDkyMzcwMDBfMjQ5NDUiLCJydWxlcyI6W119XX1dLCJvcHRpb25zIjp7Imd1dHRlciI6MCwianVzdGlmeSI6InN0YXJ0IiwiYWxpZ24iOiJ0b3AiLCJyZW1vdGVGdW5jIjoiZnVuY18xNTkxMDk3MjQzMDAwXzgzMTY3In0sImtleSI6IjE1OTEwOTcyNDMwMDBfODMxNjciLCJtb2RlbCI6ImdyaWRfMTU5MTA5NzI0MzAwMF84MzE2NyIsInJ1bGVzIjpbXX1dLCJjb25maWciOnsibGFiZWxXaWR0aCI6MTAwLCJsYWJlbFBvc2l0aW9uIjoicmlnaHQiLCJzaXplIjoic21hbGwifX0=', `IS_DEF` = 1, `LAYOUT_TYPE` = 2, `ORG_ID` = '', `ORG_NAME` = NULL, `ENABLE` = 1, `SHARE_TO_SUB` = 0, `TENANT_ID_` = '-1' WHERE `ID` = '2'; -- 2020-11-25 jjx 删除人员脚本中与下属管理相关的配置 delete from bpm_multi_script where ID_ = "21"; delete from bpm_multi_script where ID_ = "22"; delete from bpm_multi_script where ID_ = "23"; -- 2020-11-25 曾善铜 门户栏目更新 update portal_sys_column set TEMPLATE_HTML = 'PGVsLXRhYmxlIDpkYXRhPSJkYXRhLnJvd3MiIGFsaWduPSJsZWZ0Ij4KICAgIDxlbC10YWJsZS1jb2x1bW4gdHlwZT0iaW5kZXgiIGFsaWduPSJsZWZ0IiBsYWJlbD0i5bqP5Y+3Ij48L2VsLXRhYmxlLWNvbHVtbj4KICAgIDxlbC10YWJsZS1jb2x1bW4gbGFiZWw9Iuagh+mimCIgYWxpZ249ImxlZnQiIHdpZHRoPSIzMDAiIHNob3ctb3ZlcmZsb3ctdG9vbHRpcD4KICAgICAgICA8dGVtcGxhdGUgc2xvdC1zY29wZT0ic2NvcGUiIGFsaWduPSJsZWZ0Ij4KICAgICAgICAgICAgPHNwYW4gY2xhc3M9InRvZG8tc3ViamVjdCIgQGNsaWNrPSJoYW5kbGVUb2RvQ2xpY2soc2NvcGUucm93KSIgQGNvbnRleHRtZW51LnByZXZlbnQ9ImhhbmRsZVRvZG9DbGljayhzY29wZS5yb3csdHJ1ZSkiPnt7c2NvcGUucm93LnN1YmplY3R9fTwvc3Bhbj4KICAgICAgICA8L3RlbXBsYXRlPgogICAgPC9lbC10YWJsZS1jb2x1bW4+CiAgICA8ZWwtdGFibGUtY29sdW1uIHByb3A9ImNyZWF0ZVRpbWUiIGxhYmVsPSLliLDovr7ml7bpl7QiIHNob3ctb3ZlcmZsb3ctdG9vbHRpcCBhbGlnbj0ibGVmdCI+PC9lbC10YWJsZS1jb2x1bW4+CiAgICA8ZWwtdGFibGUtY29sdW1uIGFsaWduPSJsZWZ0IiBsYWJlbD0i5Y+R6LW35Lq6IiBwcm9wPSJjcmVhdG9yIj48L2VsLXRhYmxlLWNvbHVtbj4KICAgIDxlbC10YWJsZS1jb2x1bW4gYWxpZ249ImxlZnQiIGxhYmVsPSLmiYDlsZ7mtYHnqIsiIHByb3A9InByb2NEZWZOYW1lIj48L2VsLXRhYmxlLWNvbHVtbj4KPC9lbC10YWJsZT4=' where ALIAS = 'vueTodo'; update portal_sys_column set TEMPLATE_HTML = 'PGVsLXRhYmxlIDpkYXRhPSJkYXRhLnJvd3MiPgogICAgPGVsLXRhYmxlLWNvbHVtbiB0eXBlPSJpbmRleCIgYWxpZ249ImxlZnQiIGxhYmVsPSLluo/lj7ciPjwvZWwtdGFibGUtY29sdW1uPgogICAgPGVsLXRhYmxlLWNvbHVtbiBhbGlnbj0ibGVmdCIgbGFiZWw9IueKtuaAgSI+CiAgICAgICAgPHRlbXBsYXRlIHNsb3Qtc2NvcGU9InNjb3BlIj4KICAgICAgICAgICAgPHNwYW4gdi1pZj0ic2NvcGUucm93LnN0YXR1cz09J3Jldm9rZSciIHN0eWxlPSJjb2xvcjojZjcxMDEwIj7mkqTlm548L3NwYW4+CiAgICAgICAgICAgIDxzcGFuIHYtaWY9InNjb3BlLnJvdy5zdGF0dXM9PSdyZXZva2VUb1N0YXJ0JyIgc3R5bGU9ImNvbG9yOiNmNzEwMTAiPuaSpOWbnuWIsOWPkei1t+S6ujwvc3Bhbj4KICAgICAgICAgICAgPHNwYW4gdi1pZj0ic2NvcGUucm93LnN0YXR1cz09J2RyYWZ0JyIgc3R5bGU9ImNvbG9yOiNjMmE0MzciPuiNieeovzwvc3Bhbj4KCQkJCQkJPHNwYW4gdi1pZj0ic2NvcGUucm93LnN0YXR1cz09J3J1bm5pbmcnIiBzdHlsZT0iY29sb3I6IzMxODQwOSI+5q2j5Zyo6L+Q6KGMPC9zcGFuPgogICAgICAgICAgICA8c3BhbiB2LWlmPSJzY29wZS5yb3cuc3RhdHVzPT0nZW5kJyIgc3R5bGU9ImNvbG9yOiM5MDkzOTkiPue7k+adnzwvc3Bhbj4KICAgICAgICAgICAgPHNwYW4gdi1pZj0ic2NvcGUucm93LnN0YXR1cz09J21hbnVhbGVuZCciIHN0eWxlPSJjb2xvcjojOTA5Mzk5Ij7kurrlt6Xnu5PmnZ88L3NwYW4+CiAgICAgICAgICAgIDxzcGFuIHYtaWY9InNjb3BlLnJvdy5zdGF0dXM9PSdiYWNrJyIgc3R5bGU9ImNvbG9yOiNmNzEwMTAiPumps+Wbnjwvc3Bhbj4KICAgICAgICAgICAgPHNwYW4gdi1pZj0ic2NvcGUucm93LnN0YXR1cz09J2JhY2tUb1N0YXJ0JyIgc3R5bGU9ImNvbG9yOiNmNzEwMTAiPumps+WbnueahOWPkei1t+S6ujwvc3Bhbj4KICAgICAgICA8L3RlbXBsYXRlPgogICAgPC9lbC10YWJsZS1jb2x1bW4+CiAgICA8ZWwtdGFibGUtY29sdW1uIGxhYmVsPSLmoIfpopgiIGFsaWduPSJsZWZ0IiBzaG93LW92ZXJmbG93LXRvb2x0aXAgd2lkdGg9IjMwMCI+CiAgICAgICAgPHRlbXBsYXRlIHNsb3Qtc2NvcGU9InNjb3BlIj4KICAgICAgICAgICAgPHNwYW4gdi1pZj0ic2NvcGUucm93LnN0YXR1cz09J3J1bm5pbmcnIHx8IHNjb3BlLnJvdy5zdGF0dXM9PSdiYWNrJyB8fCBzY29wZS5yb3cuc3RhdHVzPT0ncmV2b2tlJyIKICAgICAgICAgICAgICAgIGNsYXNzPSJ0b2RvLXN1YmplY3QiCiAgICAgICAgICAgICAgICBAY2xpY2s9ImhhbmRsZVJvd0NsaWNrKCcvaW5zdC8nK3Njb3BlLnJvdy5pZCsgJy9yZXF1ZXN0JykiIEBjb250ZXh0bWVudS5wcmV2ZW50PSJoYW5kbGVSb3dDbGljaygnL2luc3QvJytzY29wZS5yb3cuaWQrICcvcmVxdWVzdCcsdHJ1ZSkiPnt7c2NvcGUucm93LnN1YmplY3R9fTwvc3Bhbj4KICAgICAgICAgICAgPHNwYW4gdi1lbHNlLWlmPSJzY29wZS5yb3cuc3RhdHVzPT0nZHJhZnQnIiBjbGFzcz0idG9kby1zdWJqZWN0IgogICAgICAgICAgICAgICAgQGNsaWNrPSJoYW5kbGVSb3dDbGljaygnL3N0YXJ0Lycrc2NvcGUucm93LnByb2NEZWZJZCsnLycrc2NvcGUucm93LmlkKSIgQGNvbnRleHRtZW51LnByZXZlbnQ9ImhhbmRsZVJvd0NsaWNrKCcvc3RhcnQvJytzY29wZS5yb3cucHJvY0RlZklkKycvJytzY29wZS5yb3cuaWQsdHJ1ZSkiPnt7c2NvcGUucm93LnN1YmplY3R9fTwvc3Bhbj4KICAgICAgICAgICAgPHNwYW4gdi1lbHNlIGNsYXNzPSJ0b2RvLXN1YmplY3QiCiAgICAgICAgICAgICAgICBAY2xpY2s9ImhhbmRsZVJvd0NsaWNrKCcvaW5zdC8nK3Njb3BlLnJvdy5pZCkiIEBjb250ZXh0bWVudS5wcmV2ZW50PSJoYW5kbGVSb3dDbGljaygnL2luc3QvJytzY29wZS5yb3cuaWQsdHJ1ZSkiPnt7c2NvcGUucm93LnN1YmplY3R9fTwvc3Bhbj4KICAgICAgICA8L3RlbXBsYXRlPgogICAgPC9lbC10YWJsZS1jb2x1bW4+CiAgICA8ZWwtdGFibGUtY29sdW1uIHByb3A9ImNyZWF0ZVRpbWUiIGxhYmVsPSLlj5Hotbfml7bpl7QiIHNob3ctb3ZlcmZsb3ctdG9vbHRpcCBhbGlnbj0ibGVmdCIgd2lkdGg9IjE1MCI+PC9lbC10YWJsZS1jb2x1bW4+CjwvZWwtdGFibGU+' where ALIAS = 'vueMyrequest'; -- 2020-11-26 周进起 流程附件上传配置表 添加阿里云OSS三个字段 ALTER TABLE `portal_flow_upload_properties` ADD COLUMN `ALIYUN_OSS_ENDPOINT_` varchar(255) NULL COMMENT '访问路径 endpoint' AFTER `TENANT_ID_`, ADD COLUMN `ALIYUN_OSS_ACCESSKEYID_` varchar(255) NULL COMMENT '访问密钥ID accessKeyId' AFTER `ALIYUN_OSS_ENDPOINT_`, ADD COLUMN `ALIYUN_OSS_ACCESSKEYSECRET_` varchar(255) NULL COMMENT '访问密钥 accessKeySecret' AFTER `ALIYUN_OSS_ACCESSKEYID_`; -- 2020-11-26 周进起 系统属性表 更新文件存储方式描叙字段 UPDATE `portal_sys_properties` SET `DESCRIPTION` = '可用参数值：database（保存在数据库）；folder（保存在服务器文件目录）；ftp（上传到ftp）；aliyunOss（上传到阿里云OSS）' WHERE `ALIAS` = 'file.saveType'; -- 2020-11-26 lingpj 调整角色管理菜单 UPDATE PORTAL_SYS_MENU SET PARENT_ID_ = '3441009' WHERE ID_ = '1290961424914452480'; UPDATE PORTAL_SYS_MENU SET PARENT_ID_ = '3441009' WHERE ID_ = '1290961558574338048'; DELETE FROM PORTAL_SYS_MENU WHERE ID_ = '3441030'; -- 2020-11-27 wanghb 数据列表新增是否允许外链字段 ALTER TABLE `form_data_template` ADD COLUMN `ALLOW_SHARE_` SMALLINT ( 6 ) DEFAULT 2 COMMENT '是否允许外链。1，允许。2，不允许';