-- 赵祥云 新增待办部门信息（部门待办数量）和待办_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_ = '<p>任务创建：流程实例<a href="${baseUrl}/fvue/navigationMsg/instance/${instId}">${instSubject}</a>，执行到${nodeName}</p>' WHERE ID_ = '1';
UPDATE PORTAL_SYS_MSG_TPL SET HTML_ = '<p>任务沟通提醒，${receiver}您好,任务：<a href="${baseUrl}/fvue/navigationMsg/task/${taskId}">${taskSubject}</a>需要与您交流，请给出意见。</p>' WHERE ID_ = '2';
UPDATE PORTAL_SYS_MSG_TPL SET HTML_ = '<p>代理通知：<br/>您的任务<a href="${baseUrl}/fvue/navigationMsg/task/${taskId}">${taskSubject}</a>，代理给${agent}</p>' WHERE ID_ = '3';
UPDATE PORTAL_SYS_MSG_TPL SET HTML_ = '<p>沟通反馈提醒，实例<a href="${baseUrl}/fvue/navigationMsg/instance/${instId}" style="white-space: normal;">${taskSubject}</a>发起的沟通，已给出意见。</p>' WHERE ID_ = '4';
UPDATE PORTAL_SYS_MSG_TPL SET HTML_ = '<p>任务流转通知：<a href="${baseUrl}/fvue/navigationMsg/task/${taskId}">${taskSubject}</a>的${nodeName}任务，已经流转给你。</p>' WHERE ID_ = '5';
UPDATE PORTAL_SYS_MSG_TPL SET HTML_ = '<p>任务转交：流程实例<a href="${baseUrl}/fvue/navigationMsg/task/${taskId}">${taskSubject}</a>，需要你办理。</p>' WHERE ID_ = '6';
UPDATE PORTAL_SYS_MSG_TPL SET HTML_ = '<p>加签通知：<br/>${sender}邀请你参与会签任务<a href="${baseUrl}/fvue/navigationMsg/task/${taskId}">${taskSubject}</a>,加签原因:${cause}</p>' WHERE ID_ = '7';
UPDATE PORTAL_SYS_MSG_TPL SET HTML_ = '<p>${nodeName}完成：流程实例: <a href="${baseUrl}/fvue/navigationMsg/instance/${instId}">${instSubject}</a>完成.</p>' WHERE ID_ = '8';
UPDATE PORTAL_SYS_MSG_TPL SET HTML_ = '<p>任务驳回：流程实例<a href="${baseUrl}/fvue/navigationMsg/instance/${instId}">${instSubject}</a>，驳回原因:${cause}</p>' WHERE ID_ = '9';
UPDATE PORTAL_SYS_MSG_TPL SET HTML_ = '<p>流程实例抄送：流程<a href="${baseUrl}/fvue/navigationMsg/instance/${instId}">${taskSubject}</a>的${instId}实例，已经抄送给您。</p>' WHERE ID_ = '10';
UPDATE PORTAL_SYS_MSG_TPL SET HTML_ = '<p>流程实例结束<a href="${baseUrl}/fvue/navigationMsg/instance/${instId}">${instSubject}</a>，意见:${cause}。</p>' WHERE ID_ = '11';
UPDATE PORTAL_SYS_MSG_TPL SET HTML_ = '<p>流转撤销：流程实例：<a href="${baseUrl}/fvue/navigationMsg/instance/${instId}">${instSubject}</a>的${nodeName}流转任务，已被撤销。</p>' WHERE ID_ = '12';
UPDATE PORTAL_SYS_MSG_TPL SET HTML_ = '<p>审批提醒：<br/>您有新的工作流需要审批<a href="${baseUrl}/fvue/navigationMsg/task/${taskId}">${taskSubject}</a></p>' WHERE ID_ = '13';
UPDATE PORTAL_SYS_MSG_TPL SET HTML_ = '<p>驳回提醒：<br/>您的<a href="${baseUrl}/fvue/navigationMsg/task/${taskId}">${taskSubject}</a>请求被驳回，请处理!</p>' WHERE ID_ = '14';
UPDATE PORTAL_SYS_MSG_TPL SET HTML_ = '<p>撤销提醒：<br/>审批任务<a href="${baseUrl}/fvue/navigationMsg/instance/${instId}">${taskSubject}</a>被撤销，撤销原因${cause}。</p>' WHERE ID_ = '15';
UPDATE PORTAL_SYS_MSG_TPL SET HTML_ = '<p>代理任务审批：<br/>您有新的代理任务需要审批<a href="${baseUrl}/fvue/navigationMsg/task/${taskId}">${taskSubject}</a>，委托人${delegate}.</p>' WHERE ID_ = '16';
UPDATE PORTAL_SYS_MSG_TPL SET HTML_ = '<p>流程实例结束<a href="${baseUrl}/fvue/navigationMsg/instance/${instId}">${taskSubject}</a>，意见:${cause}。</p>' WHERE ID_ = '17';
UPDATE PORTAL_SYS_MSG_TPL SET HTML_ = '<p>任务并行审批通知：<a href="${baseUrl}/fvue/navigationMsg/task/${taskId}">${taskSubject}</a>的${nodeName}任务，已经发起并行审批给你。</p>' WHERE ID_ = '18';
UPDATE PORTAL_SYS_MSG_TPL SET HTML_ = '<p>并行审批撤销：流程实例：<a href="${baseUrl}/fvue/navigationMsg/instance/${instId}">${taskSubject}</a>的${nodeName}并行审批任务，已被撤销。</p>' WHERE ID_ = '19';
UPDATE PORTAL_SYS_MSG_TPL SET HTML_ = '<p>流程实例已恢复运行中状态<a href="${baseUrl}/fvue/navigationMsg/instance/${instId}">${instSubject}</a>，意见:${cause}。</p>' WHERE ID_ = '20';
UPDATE PORTAL_SYS_MSG_TPL SET HTML_ = '<p>设置任务执行人：<a href="${baseUrl}/fvue/navigationMsg/instance/${instId}">${taskSubject}</a>，意见:${cause}。</p>' 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', '<p style="white-space: normal;"><span style="font-size: 20px;"><strong>联系我们<br/></strong></span></p><p style="white-space: normal;"><span style="font-size: 20px;"><strong><strong style="text-size-adjust: 100%; background-image: inherit; color: rgb(32, 151, 243); font-family: 微软雅黑;">020-89089123</strong></strong></span></p><p style="white-space: normal;"><span style="font-size: 20px;"></span></p><p style="white-space: normal;">邮　　箱：hotent@jee-soft.cn</p><p style="white-space: normal;"><span style="text-size-adjust: 100%; background-image: inherit; font-size: 13.3333px;">技术Q群：142215631</span></p><p style="white-space: normal;">地　　址：广州市海珠区新港东路1000号西塔Ｃ座2005室</p><p style="white-space: normal;"><span style="text-size-adjust: 100%; background-image: inherit; font-size: 13.3333px;">邮政编号：510308</span></p><p style="white-space: normal;">传真号码：020-89089366</p><p><br/></p>', 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, '<p><span style="font-size: 20px;"><strong>联系我们<br/></strong></span></p><p><span style="font-size: 20px;"><strong><strong style="text-size-adjust: 100%; background-image: inherit; color: rgb(32, 151, 243); font-family: 微软雅黑; white-space: normal;">020-89089123</strong></strong></span></p><p><span style="font-size: 20px;"></span></p><p>邮　　箱：hotent@jee-soft.cn</p><p><span style="text-size-adjust: 100%; background-image: inherit; font-size: 13.3333px;">技术Q群：142215631</span></p><p>地　　址：广州市海珠区新港东路1000号西塔Ｃ座2005室</p><p><span style="text-size-adjust: 100%; background-image: inherit; font-size: 13.3333px;">邮政编号：510308</span></p><p>传真号码：020-89089366</p>', 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, '<p>越来越多的大公司愿意与宏天合作</p><p><br/></p><p><strong>传统&amp;高科制造</strong></p><p>辽宁忠旺集团有限公司&nbsp;</p><p>广东科达洁能股份有限公司&nbsp;</p><p>金鹏电子信息机器有限公司&nbsp;</p><p>中国万向控股有限公司</p><p>纳思达股份有限公司</p><p>江门大长江集团</p><p>华润三九医药股份有限公司</p><p>香港澳美制药集团</p><p>深圳市汇顶科技股份有限公司</p><p>欧派集团</p><p>富士康集团</p><p>兴奇集团（广东兴奇金属有限公司）</p><p>武汉武船信息集成有限公司</p><p>广东芯智慧科技有限公司（保利地产）&nbsp;</p><p>宝时得机械（中国）有限公司&nbsp;</p><p>浙江美华包装机械有限公司</p><p>北京工大智源科技发展有限公司&nbsp;</p><p>江苏凯路威电子有限公司</p><p>北京索德电气工业有限公司&nbsp;</p><p>河南思维自动化设备股份有限公司</p><p>合肥开元精密工程有限责任公司&nbsp;</p><p>东聚电子电讯制品有限公司&nbsp;</p><p>施耐德（广州）母线有限公司&nbsp;&nbsp;</p><p><strong>通信运营</strong></p><p>中国电信股份有限公司&nbsp;</p><p>卓望数码技术（深圳）有限公司</p><p>大唐软件技术股份有限公司</p><p>广州从兴电子开发有限公司</p><p>爱立信</p><p>深圳天珑移动技术股份有限公司</p><p>福建福诺移动通信技术有限公司</p><p>江苏怡丰通信设备有限公司&nbsp;</p><p>长春市杰迅联合通信网络有限公司&nbsp;</p><p>深圳市讯方通信技术有限公司&nbsp;</p><p>宁波市安贞信息科技有限公司&nbsp;</p><p>四川川大金键信息产业有限责任公司&nbsp;</p><p>湖南创发天辰科技有限责任公司</p><p><strong>军工航空航天</strong></p><p>航天科工集团</p><p>航天恒星科技有限公司&nbsp;</p><p>中国航空无线电电子研究所&nbsp;</p><p>航天云网科技发展有限责任公司</p><p>北京仿真中心</p><p>航天软件评测中心</p><p>海南航空股份有限公司</p><p><strong>金融证券</strong></p><p>深圳证券交易所</p><p>中信集团</p><p>华泰联合证券有限责任公司</p><p>前海股权交易中心&nbsp;</p><p>易智付科技（北京）有限公司</p><p>深圳前海大道金融服务有限公司&nbsp;</p><p>深圳市金斧子网络科技有限公司</p><p>厦门弘信创业工场投资集团股份有限公司&nbsp;</p><p><strong>政府&amp;公共单位</strong></p><p>中央国债登记结算有限责任公司&nbsp;</p><p>农业部渔业渔政管理局&nbsp;</p><p>国家知识产权中心，中船，武船</p><p>兰州市政府 ，绍兴市政府，武汉城管局</p><p>北京交通大学，昆明铁路局</p><p>北京师范大学、北京工业大学</p><p>西北民族大学 、吉林大学&nbsp;</p><p>哈尔滨工程大学</p><p>广东职业技术学院</p><p>中科院深圳先进技术研究院&nbsp;</p><p>深圳市深圳通有限公司&nbsp;</p><p>哈尔滨交研交通工程有限责任公司&nbsp;</p><p><strong>能源电力</strong></p><p>国家电网，南方电网</p><p>东莞供电局，东莞电力设计院</p><p>广东电网公司电力科学研究院</p><p>国家核电示范基地有限公司</p><p>西部管道公司，山东能源集团</p><p>山西冀中能源集团</p><p>新疆石油勘察设计研究院&nbsp;</p><p>秦皇岛晨砻信息科技有限公司</p><p><strong>快消&amp;零售物流</strong></p><p>中国邮政</p><p>顺丰集团</p><p>万达集团</p><p>上海旭辉集团</p><p>茂业百货集团</p><p>天河城、天虹</p><p>印力地产</p><p>太平洋百货</p><p>银泰百货、同仁堂</p><p>深圳海雅集团</p><p>深圳海岸城集团</p><p>苏酒集团</p><p>绍兴商盈服饰有限公司&nbsp;</p><p><strong>全领域合作客户——IT&amp;互联网</strong></p><p><br/></p><p>中国电子系统技术有限公司</p><p>中国软件与技术服务股份有限公司</p><p>北京太极信息系统技术有限公司</p><p>大唐软件技术股份有限公司</p><p>广州从兴电子开发有限公司</p><p>北京北科维拓科技有限公司</p><p>西安未来国际信息股份有限公司&nbsp;</p><p>易智付科技（北京）有限公司</p><p>卓望数码技术（深圳）有限公司</p><p>中信网络科技有限公司</p><p>广州粤能信息技术有限公司&nbsp;</p><p>深圳市金斧子网络科技有限公司</p><p>北京天下图数据技术有限公司</p><p>湖南长信畅中科技股份有限公司</p><p>江苏华生恒业科技有限公司</p><p>捷达世软件（深圳）有限公司</p><p>象翌微链科技发展有限公司</p><p>上海亚太计算机信息系统有限公司</p><p>山西精英科技股份有限公司&nbsp;</p><p>深圳市中博科创信息技术有限公司</p><p>易云捷讯科技（北京）股份有限公司</p><p>石家庄惠远邮电设计咨询有限公司</p><p>秦皇岛晨砻信息科技有限公司</p><p>成都依能科技股份有限公司</p><p>山东潍科软件科技有限公司</p><p>腾讯科技（深圳）有限公司</p><p>德勤管理咨询（上海）有限公司&nbsp;</p><p>武汉武船信息集成有限公司</p><p>首都信息发展股份有限公司</p><p>湖南湘邮科技股份有限公司</p><p>湖南新云网科技有限公司</p><p>团车互联网信息服务（北京）有限公司</p><p>湖南大洋有限公司&nbsp;</p><p>北京爱迪思维科技发展有限公司</p><p>北京信普达系统工程有限公司</p><p>天津中软软件系统有限公司&nbsp;</p><p>海南残友科技发展有限公司（大德宝）</p><p>北京长远视通科技有限公司&nbsp;</p><p>广东益泰达科技发展有限公司</p><p>山东新海软件股份有限公司&nbsp;</p><p>厦门福旺达信息科技有限公司&nbsp;</p><p>河北汉佳电子科技有限公司&nbsp;</p><p>北京国研网络数据科技有限公司</p><p>北京天作科技有限公司&nbsp;</p><p>广东汇卡商务服务有限公司</p><p>镇江市新创计算机系统集成有限公司&nbsp;</p><p>厦门微谷信息技术有限公司&nbsp;</p><p>昆山百润科技有限公司&nbsp;</p><p>兰州北科维拓科技股份有限公司&nbsp;</p><p>吉林省纵横软件开发有限公司&nbsp;</p><p>中电智绘系统技术有限公司</p><p>正方软件股份有限公司&nbsp;</p><p>广州博纳信息技术有限公司</p><p>大连创盛科技有限公司&nbsp;</p><p>深圳市共济科技股份有限公司&nbsp;</p><p>海南信息岛技术服务中心有限公司&nbsp;</p><p>广州联奕信息科技有限公司</p><p>北京北斗兴业信息技术有限公司</p><p>河南思维自动化设备股份有限公司</p><p>南京英派电子科技有限公司</p><p>内蒙古坤兰科技有限责任公司&nbsp;</p><p>广州智算信息技术有限公司</p><p>深圳市奥宇节能技术股份有限公司&nbsp;</p><p>深圳市安亿通科技发展有限公司&nbsp;</p><p>天津煊塬科技有限公司&nbsp;</p><p>邯郸市帅先电子有限公司&nbsp;</p><p>武汉锐昊泰科技有限公司&nbsp;</p><p>哈尔滨金地多维科技发展有限公司&nbsp;</p><p>佛山市科瑞森科技有限公司&nbsp;</p><p>黑龙江长周科技有限公司&nbsp;</p><p>沈阳艾尔时代科技发展有限公司&nbsp;</p><p>广州市睿志信息科技有限公司</p><p>深圳天珑移动技术股份有限公司</p><p>北京灵信互动信息技术有限公司</p><p>新疆信智远达信息技术有限公司</p><p>北京旋极信息技术股份有限公司</p><p>深圳普华春天科技发展有限公司&nbsp;</p><p>深圳市前海圆舟网络科技股份有限公司</p><p>深圳国泰安教育技术股份有限公司</p><p>广州佰仲企业管理顾问有限公司&nbsp;</p><p>北京行智信天成咨询有限责任公司&nbsp;</p><p>广东地球村计算机系统有限公司</p><p>内蒙古坤兰科技有限责任公司&nbsp;</p><p>南京英派电子科技有限公司&nbsp;</p><p>广州联奕信息科技有限公司</p><p>广东金质信息技术有限公司&nbsp;</p><p>北京腾信软创科技有限公司&nbsp;</p><p>北京新锐创想科技有限公司</p><p>黑龙江长周科技有限公司&nbsp;</p><p>乌鲁木齐俊涛伟业科技有限公司</p><p>河南软信科技有限公司</p><p>长春雅森达科技有限责任公司</p><p>福建福诺移动通信技术有限公司</p><p>大唐云动力科技股份有限公司&nbsp;</p><p>辽宁同泽通信技术有限公司&nbsp;</p><p>成都汇码科技有限公司</p><p>广东凤凰高科电子商务有限公司</p><p>江西泰豪信息技术有限公司</p><p>人网(北京）信息科技有限公司</p><p><strong><br/></strong><br/></p><p><br style="white-space: normal;"/></p><p><br/></p>', 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, '<p style="white-space: normal;">我们可以是：</p><p style="white-space: normal;">移动端</p><p style="white-space: normal;">门户平台</p><p style="white-space: normal;">表单引擎</p><p style="white-space: normal;">流程引擎</p><p style="white-space: normal;">用户中心<br/></p><p style="white-space: normal;">快速开发平台</p><p><br/></p>', 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，不允许';