-- 赵祥云 新增待办部门信息（部门待办数量）和待办_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_ varchar2(1000)
/

comment on column BPM_PRO_INST.create_org_path_ is '所属组织路径'
/

-- 2020-09-29 赵祥云 给初始化常用语添加更新时间（用更新时间升序排序）
update BPM_APPROVAL_ITEM SET UPDATE_TIME_ = to_date('2020-09-29 10:30:10','yyyy-MM-dd hh24:mi:ss') WHERE ID_ = '6901702';
update BPM_APPROVAL_ITEM SET UPDATE_TIME_ = to_date('2020-09-29 10:30:11','yyyy-MM-dd hh24:mi:ss') WHERE ID_ = '752469';
update BPM_APPROVAL_ITEM SET UPDATE_TIME_ = to_date('2020-09-29 10:30:14','yyyy-MM-dd hh24:mi:ss') WHERE ID_ = '752475';
update BPM_APPROVAL_ITEM SET UPDATE_TIME_ = to_date('2020-09-29 10:30:13','yyyy-MM-dd hh24:mi:ss') WHERE ID_ = '8982173';



-- 修改BPM_CHECK_OPINION BPM_CHECK_OPINION_HI表字段长度限制，防止内审批人超时长度时报错
alter table BPM_CHECK_OPINION_HI drop column QUALFIEDS_;

alter table BPM_CHECK_OPINION_HI add QUALFIEDS_ CLOB;

alter table BPM_CHECK_OPINION_HI drop column QUALFIED_NAMES_;

alter table BPM_CHECK_OPINION_HI add QUALFIED_NAMES_ CLOB;


alter table BPM_CHECK_OPINION drop column QUALFIEDS_;

alter table BPM_CHECK_OPINION add QUALFIEDS_ CLOB;

alter table BPM_CHECK_OPINION drop column QUALFIED_NAMES_;

alter table BPM_CHECK_OPINION add QUALFIED_NAMES_ CLOB;

alter table BPM_TASK_NOTICE_DONE drop column QUALFIEDS_;

alter table BPM_TASK_NOTICE_DONE add QUALFIEDS_ CLOB;

alter table BPM_TASK_NOTICE_DONE drop column QUALFIED_NAMES_;

alter table BPM_TASK_NOTICE_DONE add QUALFIED_NAMES_ CLOB;


-- 张耀祥 添加一个内部消息的菜单
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,
	APP_ID_ VARCHAR(64) not null,
	TAG_ID_ VARCHAR(64) not null,
	TENANT_ID_ VARCHAR(64) default '-1' null,
	constraint portal_app_tags_relation_pk
		primary key (ID_)
);
comment on column portal_app_tags_relation.ID_ is '主键';
comment on column portal_app_tags_relation.APP_ID_ is '应用ID';
comment on column portal_app_tags_relation.TAG_ID_ is '标签ID';
comment on column portal_app_tags_relation.TENANT_ID_ is '租户ID';
comment on table portal_app_tags_relation is '应用标签关系表';

create table portal_app_param
(
	ID_ VARCHAR(64) not null,
	NAME_ varchar(64) null,
	ALIAS_ varchar(64) null,
	CONTROL_TYPE_ VARCHAR(64) null,
	VALUE_ CLOB null,
	APP_ID_ VARCHAR(64) null,
	TENANT_ID_ VARCHAR(64) default -1 null,
	CREATE_TIME_ timestamp null,
	constraint portal_app_param_pk
		primary key (ID_)
);
comment on column portal_app_param.ID_ is '主键';
comment on column portal_app_param.NAME_ is '参数名称';
comment on column portal_app_param.ALIAS_ is '参数编码';
comment on column portal_app_param.CONTROL_TYPE_ is '控件类型';
comment on column portal_app_param.VALUE_ is '参数值';
comment on column portal_app_param.APP_ID_ is '应用ID';
comment on column portal_app_param.TENANT_ID_ is '租户ID';
comment on column portal_app_param.CREATE_TIME_ is '创建时间';
comment on table portal_app_param is '应用参数表';

ALTER TABLE "FORM_DATA_TEMPLATE" 
ADD ("SUB_FIELD_" NCLOB);

-- 邱喜达 应用中心
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_ VARCHAR2(2000);

-- 2020-10-21 李洪桥 电子签章
create table uc_electronic_seal
(
	ID_ varchar2(64)
		constraint UC_ELECTRONIC_SEAL_PK
			primary key,
	USER_ID_ varchar2(64),
	FILE_ID_ varchar2(64),
	PASSWORD_ varchar2(64),
	IS_USE_ int,
	CREATE_TIME_ date,
	UPDATE_TIME_ date,
	CREATE_ORG_ID_ varchar2(64),
	CREATE_BY_ varchar2(64),
	UPDATE_BY_ varchar2(64),
	TENANT_ID_ varchar2(64)
)
/

comment on table uc_electronic_seal is '电子签章'
/

comment on column uc_electronic_seal.ID_ is '主键ID'
/

comment on column uc_electronic_seal.USER_ID_ is '用户ID'
/

comment on column uc_electronic_seal.FILE_ID_ is '签章图片ID'
/

comment on column uc_electronic_seal.PASSWORD_ is '使用密码'
/

comment on column uc_electronic_seal.IS_USE_ is '当前是否使用 0为当前使用  1 为非当前使用'
/


-- 2020-10-23 lingpj 定时计划两条初始化语句调整
UPDATE "QRTZ_JOB_DETAILS" SET "JOB_DATA" = HEXTORAW('230D0A23467269204F63742032332031353A33303A30372043535420323032300D0A') WHERE "SCHED_NAME" = 'quartzScheduler' AND "JOB_NAME" = '流程定时启动任务类' AND "JOB_GROUP" = '-1';
UPDATE "QRTZ_JOB_DETAILS" SET "JOB_DATA" = HEXTORAW('230D0A23467269204F63742032332031353A33303A31312043535420323032300D0A') 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 URL_ VARCHAR2(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 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-04 qiuxd 对话框添加组合对话框配置字段
ALTER TABLE form_custom_dialog ADD combine_config_ VARCHAR(2000);

-- 2020-11-04 ZST 组合对话框覆盖更新
alter table FORM_CUSTOM_DIALOG rename column COMBINE_CONFIG_ to COMBINATION_RULE_
/

-- 2020-11-5 jijx 修改人员脚本配置从子表数据中提取节点审批人的说明
update bpm_multi_script set METHOD_DESC_='从子表数据中提取节点审批人(固定值生效)'  where ID_=1318030354614980608;

-- 2020-11-05 wanghb  BPM_PRO_INST添加BPMN_INST_ID_唯一索引
CREATE UNIQUE INDEX "IDX_PRO_INST_BPMNINSTID"  ON "BPM_PRO_INST" ("BPMN_INST_ID_");

-- 2020-11-04 赵祥云 新增常用流程授权对象表
CREATE TABLE bpm_often_flow_user (
  ID_ varchar2(64) not null,
  OFTEN_FLOW_ID_ varchar2(64) null,
  OWNER_ID_ varchar2(64) null,
  OWNER_NAME_ varchar2(128) null,
  RIGHT_TYPE_ varchar2(20) null,
  TENANT_ID_ varchar2(255) null,
  constraint bpm_often_flow_user_pk
    primary key (ID_)
);

-- 2020-11-05 赵祥云 修改常用流程表字段信息设置USER_ID_和USER_NAME_可以为空
alter table bpm_often_flow modify USER_ID_ null;
alter table bpm_often_flow modify USER_NAME_ null;

-- 2020-11-5 zhangxw 修改日志表操作名称字段长度 
ALTER TABLE "PORTAL_SYS_LOGS" 
MODIFY ("OPE_NAME_" VARCHAR2(500 BYTE));


-- 2020-11-07 wanghb 调整表单元数据name字段长度
ALTER TABLE FORM_META MODIFY NAME_ VARCHAR2(128);

-- oracle  添加默认应用分类
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');

-- jjx 2020-11-9 修改人员脚本配置内容在oracle下不显示问题
UPDATE BPM_MULTI_SCRIPT 
SET ARGUMENT_ = '[
{"paraName":"arg0","paraType":"java.lang.String","paraDesc":"组织ID","paraCt":"base:org-selector","paraCtBindName":"组织ID","paraCtBindKey":"id","multiSelect":false,"$$hashKey":"object:3067"},{"paraName":"arg1","paraType":"java.lang.Boolean","paraDesc":"是否主负责人","paraCt":null,"paraCtBindName":"","paraCtBindKey":null,"multiSelect":false,"$$hashKey":"object:3068"}]' 
WHERE
	ID_ = '10';
	

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';
	
	
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":"用户帐号字段"},{"paraName":"arg3","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":"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';
	

-- 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_, 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', '', 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 RENAME COLUMN REASON_ TO REASON_BAK_;
ALTER TABLE BPM_FORM_MODIFY_RECORD ADD REASON_ CLOB;
UPDATE BPM_FORM_MODIFY_RECORD SET REASON_=REASON_BAK_;
COMMIT;
ALTER TABLE BPM_FORM_MODIFY_RECORD DROP COLUMN REASON_BAK_;

-- 2020-11-18 heyf 在form_key上添加索引
CREATE INDEX INDEX_FORMTEMP_FORMKEY ON FORM_DATA_TEMPLATE (FORM_KEY_);

-- 2020-11-23 赵祥云 新增流程实例状态排序表
CREATE TABLE BPM_PRO_INST_STATUS
(
   ID_      VARCHAR2(64)         NOT NULL,
   KEY_     VARCHAR2(255)        DEFAULT NULL,
   VALUE_   VARCHAR2(255)        DEFAULT NULL,
   CONSTRAINT PK_BPM_PRO_INST_STATUS PRIMARY KEY (ID_)
);

COMMENT ON COLUMN BPM_PRO_INST_STATUS.KEY_ IS
'流程实例状态';

COMMENT ON COLUMN BPM_PRO_INST_STATUS.VALUE_ IS
'流程实例状态对应的排序号';

-- 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 lingpj  oracle 驳回报错问题 外键级联删除 没有设置
ALTER TABLE "ACT_RU_TASK" DROP CONSTRAINT "ACT_FK_TASK_EXE";
ALTER TABLE "ACT_RU_TASK" ADD CONSTRAINT "ACT_FK_TASK_EXE" FOREIGN KEY ("EXECUTION_ID_") REFERENCES "ACT_RU_EXECUTION" ("ID_") ON DELETE CASCADE NOT DEFERRABLE INITIALLY IMMEDIATE NORELY VALIDATE;

-- 2020-11-23 邱喜达 修改自定义图标sortField类型
ALTER TABLE form_custom_chart MODIFY SORTFIELD_ VARCHAR2(4000);

-- 增加新闻分类信息-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', NULL, '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', NULL, '1', NULL, '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', NULL, '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', NULL, '1', NULL, '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', NULL, '1', NULL, '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', '超级管理员', NULL, '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', '超级管理员', NULL, '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', '超级管理员', NULL, '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', '超级管理员', NULL, '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', '超级管理员', NULL, '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', NULL, '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', NULL, '1', NULL, '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', NULL, '1', NULL, '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', NULL, '1', NULL, '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', NULL, '1', NULL, '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', NULL, '1', NULL, '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', NULL, '1', NULL, '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', NULL, '1', NULL, '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', NULL, '1', NULL, '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', NULL, '1', NULL, '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>', 1, NULL, '4', NULL, NULL, '-1', NULL, '1', NULL, '1', 1, NULL, NULL, '小宏');
UPDATE PORTAL_NEWS_NOTICE_ set CONTENT_=CONCAT(CONTENT_,'<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>深圳市安亿通科技发展有限公司&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>') WHERE ID_ = '1330747415233433600';
UPDATE PORTAL_NEWS_NOTICE_ set CONTENT_=CONCAT(CONTENT_,'<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>') WHERE ID_ = '1330747415233433600';
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', NULL, '1', NULL, '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', NULL, 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', NULL, 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 ('19', '宏天软件', '1330698840872980480', '31081', 0, NULL, '', '', NULL, 200, '', 'PGhvbWVDYXJvdXNlbCBoZWlnaHQ9JzEwMCcgY2xhc3NpZnlJZD0nMTMzMDY5ODg0MDg3Mjk4MDQ4MCcgOmludGVydmFsPScwJy8+', 2, NULL, NULL, NULL, '', '', 0, NULL, NULL, '1', '1', NULL, 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 ('20', '新闻公告信息', 'xwggxx', '31081', 4, NULL, '', '', NULL, 300, '', '', 2, NULL, NULL, NULL, '', '{"id":"1330698555119243264","name":"新闻数量统计","chartType":2}', 0, NULL, NULL, '1', '1', NULL, 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 ('21', '宏天信息', '1330747098659950592', '31081', 0, NULL, '', '', NULL, 300, '', 'PGhvbWVDYXJvdXNlbCBoZWlnaHQ9JzEwMCcgY2xhc3NpZnlJZD0nMTMzMDc0NzA5ODY1OTk1MDU5MicgOmludGVydmFsPSdudWxsJy8+', 2, NULL, NULL, NULL, '', '', 0, NULL, NULL, '1', '1', NULL, 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 ('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+CgkJCTwvZGl2PgoJCTwvZWwtY29sPgoJCTxlbC1jb2wgOnNwYW49IjMiIHN0eWxlPSJw', 2, NULL, NULL, NULL, '', '', 0, NULL, NULL, '1', '1', NULL, NULL, '', '默认分类', '', '-1');
UPDATE PORTAL_SYS_COLUMN set TEMPLATE_HTML=CONCAT(TEMPLATE_HTML,'YWRkaW5nLXRvcDo1cHgiPgoJCQk8ZGl2IHN0eWxlPSJmbG9hdDpsZWZ0OyIgIG9uY2xpY2s9IndpbmRvdy5vcGVuKCdodHRwOi8vd3d3LmhvdGVudC5jb20nLCcnLCcnKTsiPgoJCQkJPGRpdiBzdHlsZT0iZmxvYXQ6bGVmdDt3aWR0aDo0MnB4O2hlaWdodDo0MnB4O2JhY2tncm91bmQ6IzI4NTgwMztib3JkZXItcmFkaXVzOjIxcHg7Ij4KICAgICAgICAgIDxzcGFuICBzdHlsZT0iZm9udC1zaXplOiAyOHB4OyBwYWRkaW5nOiAxMnB4OyBjb2xvcjogcmdiKDI1NSwgMjU1LCAyNTUpOyI+ICBDICA8L3NwYW4+CiAgICAgICAgICAgIAoJCQkJPC9kaXY+CgkJCQk8ZGl2IHN0eWxlPSJmbG9hdDpsZWZ0OyBwYWRkaW5nLWxlZnQ6OHB4OyI+CgkJCQkJPGRpdj4gPHNwYW4gc3R5bGU9ImZvbnQtc2l6ZToyMHB4O2ZvbnQtZmFtaWx5Ok1pY3Jvc29mdCBZYUhlaTtmb250LXdlaWdodDo0MDA7Y29sb3I6cmdiYSg0MCw0MSw0MSwxKTtsaW5lLWhlaWdodDozMHB4OyI+Q1JN57O757ufPC9zcGFuPjwvZGl2PgoJCQkJPC9kaXY+CgkJCTwvZGl2PgoJCQk8ZGl2IHN0eWxlPSJmbG9hdDpyaWdodDsiPgogICAgPHNwYW4gY2xhc3M9ImVsLWRpdmlkZXIgZWwtZGl2aWRlci0tdmVydGljYWwiIHN0eWxlPSJmb250LXNpemU6NDBweDsiPgogICAgICA8L3NwYW4+CgkJCTwvZGl2PgoJCTwvZWwtY29sPgoJCQkJPGVsLWNvbCA6c3Bhbj0iMyIgc3R5bGU9InBhZGRpbmctdG9wOjVweCI+CgkJCTxkaXYgc3R5bGU9ImZsb2F0OmxlZnQ7IiAgb25jbGljaz0id2luZG93Lm9wZW4oJ2h0dHA6Ly93d3cuaG90ZW50LmNvbScsJycsJycpOyI+CgkJCQkKCQkJCTxkaXYgc3R5bGU9ImZsb2F0OmxlZnQ7d2lkdGg6NDJweDtoZWlnaHQ6NDJweDtiYWNrZ3JvdW5kOiM4YTA0Njc7Ym9yZGVyLXJhZGl1czoyMXB4OyI+CiAgICAgICAgICA8c3BhbiAgc3R5bGU9ImZvbnQtc2l6ZTogMjhweDsgcGFkZGluZzogMTBweDsgY29sb3I6IHJnYigyNTUsIDI1NSwgMjU1KTsiPiAgTyAgPC9zcGFuPgogICAgICAgICAgICAKCQkJCTwvZGl2PgoJCQkJPGRpdiBzdHlsZT0iZmxvYXQ6bGVmdDsgcGFkZGluZy1sZWZ0OjhweDsiPgoJCQkJCTxkaXY+IDxzcGFuIHN0eWxlPSJmb250LXNpemU6MjBweDtmb250LWZhbWlseTpNaWNyb3NvZnQgWWFIZWk7Zm9udC13ZWlnaHQ6NDAwO2NvbG9yOnJnYmEoNDAsNDEsNDEsMSk7bGluZS1oZWlnaHQ6MzBweDsiPk9B57O757ufPC9zcGFuPjwvZGl2PgoJCQkJPC9kaXY+CgkJCTwvZGl2PgoJCQk8ZGl2IHN0eWxlPSJmbG9hdDpyaWdodDsiPgogICAgPHNwYW4gY2xhc3M9ImVsLWRpdmlkZXIgZWwtZGl2aWRlci0tdmVydGljYWwiIHN0eWxlPSJmb250LXNpemU6NDBweDsiPgogICAgICA8L3NwYW4+CgkJCTwvZGl2PgoJCTwvZWwtY29sPgoJCQkJPGVsLWNvbCA6c3Bhbj0iMyIgc3R5bGU9InBhZGRpbmctdG9wOjVweCI+CgkJCTxkaXYgc3R5bGU9ImZsb2F0OmxlZnQ7IiAgb25jbGljaz0id2luZG93Lm9wZW4oJ2h0dHA6Ly93d3cuaG90ZW50LmNvbScsJycsJycpOyI+CgkJCgkJCQk8ZGl2IHN0eWxlPSJmbG9hdDpsZWZ0O3dpZHRoOjQycHg7aGVpZ2h0OjQycHg7YmFja2dyb3VuZDojMDg3NGIzO2JvcmRlci1yYWRpdXM6MjFweDsiPgogICAgICAgICAgPHNwYW4gIHN0eWxlPSJmb250LXNpemU6IDI4cHg7IHBhZGRpbmc6IDE0cHg7IGNvbG9yOiByZ2IoMjU1LCAyNTUsIDI1NSk7Ij4gIFQgIDwvc3Bhbj4KICAgICAgICAgICAgCgkJCQk8L2Rpdj4KCQkJCTxkaXYgc3R5bGU9ImZsb2F0OmxlZnQ7IHBhZGRpbmctbGVmdDo4cHg7Ij4KCQkJCQk8ZGl2PiA8c3BhbiBzdHlsZT0iZm9udC1zaXplOjIwcHg7Zm9udC1mYW1pbHk6TWljcm9zb2Z0IFlhSGVpO2ZvbnQtd2VpZ2h0OjQwMDtjb2xvcjpyZ2JhKDQwLDQxLDQxLDEpO2xpbmUtaGVpZ2h0OjMwcHg7Ij5UQVNL57O757ufPC9zcGFuPjwvZGl2PgoJCQkJPC9kaXY+CgkJCTwvZGl2PgoJCQk8ZGl2IHN0eWxlPSJmbG9hdDpyaWdodDsiPgogICAgPHNwYW4gY2xhc3M9ImVsLWRpdmlkZXIgZWwtZGl2aWRlci0tdmVydGljYWwiIHN0eWxlPSJmb250LXNpemU6NDBweDsiPgogICAgICA8L3NwYW4+CgkJCTwvZGl2PgoJCTwvZWwtY29sPgoJCQkJCQk8ZWwtY29sIDpzcGFuPSIzIiBzdHlsZT0icGFkZGluZy10b3A6NXB4Ij4KCQkJPGRpdiBzdHlsZT0iZmxvYXQ6bGVmdDsiICBvbmNsaWNrPSJ3aW5kb3cub3BlbignaHR0cDovL3d3dy5ob3RlbnQuY29tJywnJywnJyk7Ij4KCQkKCQkJCTxkaXYgc3R5bGU9ImZsb2F0OmxlZnQ7d2lkdGg6NDJweDtoZWlnaHQ6NDJweDtiYWNrZ3JvdW5kOnJnYigxMjUgMTQgMTUyKTtib3JkZXItcmFkaXVzOjIxcHg7Ij4KICAgICAgICAgIDxzcGFuICBzdHlsZT0iZm9udC1zaXplOiAyOHB4OyBwYWRkaW5nOiAxNHB4OyBjb2xvcjogcmdiKDI1NSwgMjU1LCAyNTUpOyI+ICBFICA8L3NwYW4+CiAgICAgICAgICAgIAoJCQkJPC9kaXY+CgkJCQk8ZGl2IHN0eWxlPSJmbG9hdDpsZWZ0OyBwYWRk') WHERE ID = '22';
UPDATE PORTAL_SYS_COLUMN set TEMPLATE_HTML=CONCAT(TEMPLATE_HTML,'aW5nLWxlZnQ6OHB4OyI+CgkJCQkJPGRpdj4gPHNwYW4gc3R5bGU9ImZvbnQtc2l6ZToyMHB4O2ZvbnQtZmFtaWx5Ok1pY3Jvc29mdCBZYUhlaTtmb250LXdlaWdodDo0MDA7Y29sb3I6cmdiYSg0MCw0MSw0MSwxKTtsaW5lLWhlaWdodDozMHB4OyI+RUlQPC9zcGFuPjwvZGl2PgoJCQkJPC9kaXY+CgkJCTwvZGl2PgoJCQk8ZGl2IHN0eWxlPSJmbG9hdDpyaWdodDsiPgogICAgPHNwYW4gY2xhc3M9ImVsLWRpdmlkZXIgZWwtZGl2aWRlci0tdmVydGljYWwiIHN0eWxlPSJmb250LXNpemU6NDBweDsiPgogICAgICA8L3NwYW4+CgkJCTwvZGl2PgoJCTwvZWwtY29sPgoJCTxlbC1jb2wgOnNwYW49IjMiIHN0eWxlPSJwYWRkaW5nLXRvcDo1cHgiPgoJCQk8ZGl2IHN0eWxlPSJmbG9hdDpsZWZ0OyIgIG9uY2xpY2s9IndpbmRvdy5vcGVuKCdodHRwOi8vd3d3LmhvdGVudC5jb20nLCcnLCcnKTsiPgoJCQoJCQkJPGRpdiBzdHlsZT0iZmxvYXQ6bGVmdDt3aWR0aDo0MnB4O2hlaWdodDo0MnB4O2JhY2tncm91bmQ6cmdiKDEyOCAxMzAgOSk7Ym9yZGVyLXJhZGl1czoyMXB4OyI+CiAgICAgICAgICA8c3BhbiAgc3R5bGU9ImZvbnQtc2l6ZTogMjhweDsgcGFkZGluZzogMTRweDsgY29sb3I6IHJnYigyNTUsIDI1NSwgMjU1KTsiPiAgSyAgPC9zcGFuPgogICAgICAgICAgICAKCQkJCTwvZGl2PgoJCQkJPGRpdiBzdHlsZT0iZmxvYXQ6bGVmdDsgcGFkZGluZy1sZWZ0OjhweDsiPgoJCQkJCTxkaXY+IDxzcGFuIHN0eWxlPSJmb250LXNpemU6MjBweDtmb250LWZhbWlseTpNaWNyb3NvZnQgWWFIZWk7Zm9udC13ZWlnaHQ6NDAwO2NvbG9yOnJnYmEoNDAsNDEsNDEsMSk7bGluZS1oZWlnaHQ6MzBweDsiPktQSTwvc3Bhbj48L2Rpdj4KCQkJCTwvZGl2PgoJCQk8L2Rpdj4KCQoJCTwvZWwtY29sPgoJPC9lbC1yb3c+CjwvZGl2PgoK') WHERE ID = '22';


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 DESIGN_HTML='eyJsaXN0IjpbeyJ0eXBlIjoiZ3JpZCIsIm5hbWUiOiLmoIXmoLzluIPlsYAiLCJpY29uIjoiaWNvbi1ncmlkIiwiY29sdW1ucyI6W3sic3BhbiI6MjAsImxpc3QiOlt7Im5hbWUiOiJiYW5uZXIiLCJhbGlhcyI6IjEzMzA2OTg4NDA4NzI5ODA0ODAiLCJvcHRpb25zIjp7InJlbW90ZUZ1bmMiOiJmdW5jXzE2MDYxMDA4MDcwMDBfNzcxMjcifSwia2V5IjoiMTYwNjEwMDgwNzAwMF83NzEyNyIsIm1vZGVsIjoidW5kZWZpbmVkXzE2MDYxMDA4MDcwMDBfNzcxMjciLCJydWxlcyI6W119XX0seyJzcGFuIjo0LCJsaXN0IjpbeyJuYW1lIjoi5bi455So5rWB56iLIiwiYWxpYXMiOiJ2dWVPZnRlbkZsb3ciLCJvcHRpb25zIjp7InJlbW90ZUZ1bmMiOiJmdW5jXzE2MDYwOTY1NzIwMDBfNjc4NTgifSwia2V5IjoiMTYwNjA5NjU3MjAwMF82Nzg1OCIsIm1vZGVsIjoidW5kZWZpbmVkXzE2MDYwOTY1NzIwMDBfNjc4NTgiLCJydWxlcyI6W119XX1dLCJvcHRpb25zIjp7Imd1dHRlciI6NSwianVzdGlmeSI6InN0YXJ0IiwiYWxpZ24iOiJ0b3AiLCJyZW1vdGVGdW5jIjoiZnVuY18xNjA2MDk2NTY1MDAwXzYyNjkxIn0sImtleSI6IjE2MDYwOTY1NjUwMDBfNjI2OTEiLCJtb2RlbCI6ImdyaWRfMTYwNjA5NjU2NTAwMF82MjY5MSIsInJ1bGVzIjpbXX0seyJuYW1lIjoi5bi455So57O757ufIiwiYWxpYXMiOiJjeXh0Iiwib3B0aW9ucyI6eyJyZW1vdGVGdW5jIjoiZnVuY18xNjA2MTMwMzY5MDAwXzI4ODUzIn0sImtleSI6IjE2MDYxMzAzNjkwMDBfMjg4NTMiLCJtb2RlbCI6InVuZGVmaW5lZF8xNjA2MTMwMzY5MDAwXzI4ODUzIiwicnVsZXMiOltdfSx7Im5hbWUiOiLkuKrkurrkv6Hmga/moI/nm64iLCJhbGlhcyI6ImdyeHhsbSIsIm9wdGlvbnMiOnsicmVtb3RlRnVuYyI6ImZ1bmNfMTYwNjEwMDgwNDAwMF8xNzA2In0sImtleSI6IjE2MDYxMDA4MDQwMDBfMTcwNiIsIm1vZGVsIjoidW5kZWZpbmVkXzE2MDYxMDA4MDQwMDBfMTcwNiIsInJ1bGVzIjpbXX0seyJ0eXBlIjoiZ3JpZCIsIm5hbWUiOiLmoIXmoLzluIPlsYAiLCJpY29uIjoiaWNvbi1ncmlkIiwiY29sdW1ucyI6W3sic3BhbiI6MTIsImxpc3QiOlt7Im5hbWUiOiLmiJHnmoTlvoXlip4iLCJhbGlhcyI6InZ1ZVRvZG8iLCJvcHRpb25zIjp7InJlbW90ZUZ1bmMiOiJmdW5jXzE2MDYxMDA3NTQwMDBfMzA1NzYifSwia2V5IjoiMTYwNjEwMDc1NDAwMF8zMDU3NiIsIm1vZGVsIjoidW5kZWZpbmVkXzE2MDYxMDA3NTQwMDBfMzA1NzYiLCJydWxlcyI6W119XX0seyJzcGFuIjoxMiwibGlzdCI6W3sibmFtZSI6IuaWsOmXu+WFrOWRiuS/oeaBryIsImFsaWFzIjoieHdnZ3h4Iiwib3B0aW9ucyI6eyJyZW1vdGVGdW5jIjoiZnVuY18xNjA2MTAwNzU5MDAwXzE0MDQ0In0sImtleSI6IjE2MDYxMDA3NTkwMDBfMTQwNDQiLCJtb2RlbCI6InVuZGVmaW5lZF8xNjA2MTAwNzU5MDAwXzE0MDQ0IiwicnVsZXMiOltdfV19XSwib3B0aW9ucyI6eyJndXR0ZXIiOjUsImp1c3RpZnkiOiJzdGFydCIsImFsaWduIjoidG9wIiwicmVtb3RlRnVuYyI6ImZ1bmNfMTYwNjA5NjU5NzAwMF81NTQ1MCJ9LCJrZXkiOiIxNjA2MDk2NTk3MDAwXzU1NDUwIiwibW9kZWwiOiJncmlkXzE2MDYwOTY1OTcwMDBfNTU0NTAiLCJydWxlcyI6W119LHsidHlwZSI6ImdyaWQiLCJuYW1lIjoi5qCF5qC85biD5bGAIiwiaWNvbiI6Imljb24tZ3JpZCIsImNvbHVtbnMiOlt7InNwYW4iOjE4LCJsaXN0IjpbeyJuYW1lIjoi57O757uf5biu5YqpIiwiYWxpYXMiOiIxMzI1Njc5MjMwMDg3OTkxMjk2Iiwib3B0aW9ucyI6eyJyZW1vdGVGdW5jIjoiZnVuY18xNjA2MDk2MDQ4MDAwXzUxNzYzIn0sImtleSI6IjE2MDYwOTYwNDgwMDBfNTE3NjMiLCJtb2RlbCI6InVuZGVmaW5lZF8xNjA2MDk2MDQ4MDAwXzUxNzYzIiwicnVsZXMiOltdfSx7Im5hbWUiOiLku7vliqHpnaLmnb8iLCJhbGlhcyI6InJ3bWJ2dWUiLCJvcHRpb25zIjp7InJlbW90ZUZ1bmMiOiJmdW5jXzE2MDYwOTYwODAwMDBfMzQ4MyJ9LCJrZXkiOiIxNjA2MDk2MDgwMDAwXzM0ODMiLCJtb2RlbCI6InVuZGVmaW5lZF8xNjA2MDk2' WHERE ID = '2';
UPDATE PORTAL_SYS_LAYOUT_MANAGE set DESIGN_HTML=CONCAT(DESIGN_HTML,'MDgwMDAwXzM0ODMiLCJydWxlcyI6W119XX0seyJzcGFuIjo2LCJsaXN0IjpbeyJuYW1lIjoi5a6P5aSp5L+h5oGvIiwiYWxpYXMiOiIxMzMwNzQ3MDk4NjU5OTUwNTkyIiwib3B0aW9ucyI6eyJyZW1vdGVGdW5jIjoiZnVuY18xNjA2MTA5OTUyMDAwXzcyNjM0In0sImtleSI6IjE2MDYxMDk5NTIwMDBfNzI2MzQiLCJtb2RlbCI6InVuZGVmaW5lZF8xNjA2MTA5OTUyMDAwXzcyNjM0IiwicnVsZXMiOltdfSx7Im5hbWUiOiLmnIDmlrDpobnnm64iLCJhbGlhcyI6Inp4eG12dWUiLCJvcHRpb25zIjp7InJlbW90ZUZ1bmMiOiJmdW5jXzE2MDYwOTYwODIwMDBfMjc5MzUifSwia2V5IjoiMTYwNjA5NjA4MjAwMF8yNzkzNSIsIm1vZGVsIjoidW5kZWZpbmVkXzE2MDYwOTYwODIwMDBfMjc5MzUiLCJydWxlcyI6W119XX1dLCJvcHRpb25zIjp7Imd1dHRlciI6NSwianVzdGlmeSI6InN0YXJ0IiwiYWxpZ24iOiJ0b3AiLCJyZW1vdGVGdW5jIjoiZnVuY18xNjA1NTk2NDIyMDAwXzI1MDgyIn0sImtleSI6IjE2MDU1OTY0MjIwMDBfMjUwODIiLCJtb2RlbCI6ImdyaWRfMTYwNTU5NjQyMjAwMF8yNTA4MiIsInJ1bGVzIjpbXX0seyJ0eXBlIjoiZ3JpZCIsIm5hbWUiOiLmoIXmoLzluIPlsYAiLCJpY29uIjoiaWNvbi1ncmlkIiwiY29sdW1ucyI6W3sic3BhbiI6MjQsImxpc3QiOlt7Im5hbWUiOiLlhbPkuo7miJHku6wiLCJhbGlhcyI6Imd5d212dWUiLCJvcHRpb25zIjp7InJlbW90ZUZ1bmMiOiJmdW5jXzE1OTExNDkyMzcwMDBfMjQ5NDUifSwia2V5IjoiMTU5MTE0OTIzNzAwMF8yNDk0NSIsIm1vZGVsIjoidW5kZWZpbmVkXzE1OTExNDkyMzcwMDBfMjQ5NDUiLCJydWxlcyI6W119XX1dLCJvcHRpb25zIjp7Imd1dHRlciI6MCwianVzdGlmeSI6InN0YXJ0IiwiYWxpZ24iOiJ0b3AiLCJyZW1vdGVGdW5jIjoiZnVuY18xNTkxMDk3MjQzMDAwXzgzMTY3In0sImtleSI6IjE1OTEwOTcyNDMwMDBfODMxNjciLCJtb2RlbCI6ImdyaWRfMTU5MTA5NzI0MzAwMF84MzE2NyIsInJ1bGVzIjpbXX1dLCJjb25maWciOnsibGFiZWxXaWR0aCI6MTAwLCJsYWJlbFBvc2l0aW9uIjoicmlnaHQiLCJzaXplIjoic21hbGwifX0=') 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 ("ALIYUN_OSS_ENDPOINT_" VARCHAR2(255))
ADD ("ALIYUN_OSS_ACCESSKEYID_" VARCHAR2(255))
ADD ("ALIYUN_OSS_ACCESSKEYSECRET_" VARCHAR2(255));
COMMENT ON COLUMN "PORTAL_FLOW_UPLOAD_PROPERTIES"."ALIYUN_OSS_ENDPOINT_" IS '访问路径 endpoint';
COMMENT ON COLUMN "PORTAL_FLOW_UPLOAD_PROPERTIES"."ALIYUN_OSS_ACCESSKEYID_" IS '访问密钥ID accessKeyId';
COMMENT ON COLUMN "PORTAL_FLOW_UPLOAD_PROPERTIES"."ALIYUN_OSS_ACCESSKEYSECRET_" IS '访问密钥 accessKeySecret'

-- 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 ( ALLOW_SHARE_ SMALLINT DEFAULT 2 );
COMMENT ON COLUMN form_data_template.ALLOW_SHARE_ IS '是否允许外链。1，允许。2，不允许';