/*
 change.sql 说明
 1.数据库相关修改添加到对应的 change.sql 文件，无需调整其他 sql  文件
 2.sql 语句验证正确后再提交
*/
-- 2022-8-3 liangjc PORTAL_SYS_MENU 增加菜单类型
ALTER TABLE PORTAL_SYS_MENU ADD TYPE_ VARCHAR2(50);
comment on column PORTAL_SYS_MENU.TYPE_ is '菜单类型';

-- 2022-08-08 增加account账号字段
ALTER TABLE portal_biz_system_auth ADD ACCOUNT_ VARCHAR2(64);
comment on column portal_biz_system_auth.ACCOUNT_ is '账号';


-- 2022-08-08 修改字段长度
alter table FORM_META modify NAME_ VARCHAR2(150);
alter table FORM_PRINT_TEMPLATE modify FILE_NAME VARCHAR2(150);

alter table PORTAL_SYS_MENU modify NAME_ VARCHAR2(150);

-- liangjc 2022-8-10 修改字段长度
alter table portal_sys_logs_settings modify REMARK_ VARCHAR2(1000);
alter table FORM_HISTORY_RECORD rename column DIY_JS_  to name_tmp;
alter table FORM_HISTORY_RECORD add DIY_JS_ clob;
update FORM_HISTORY_RECORD set DIY_JS_=trim(name_tmp);
alter table FORM_HISTORY_RECORD drop column name_tmp;

-- liangjc 2022-8-11 修改字段长度
alter table UC_ROLE modify DESCRIPTION_ VARCHAR2(150);

-- liangjc 2022-8-12 修改字段长度
alter table PORTAL_SERVICE_CHOREOGRAPHY modify NAME_ VARCHAR2(150);
alter table PORTAL_INTERFACE_MANAGER modify NAME_ VARCHAR2(150);
alter table PORTAL_CONNECTION_MANAGER modify NAME_ VARCHAR2(150);
alter table PORTAL_SYS_DATASOURCE modify NAME_ VARCHAR2(150);
alter table FORM_CUSTOM_CHART modify NAME_ VARCHAR2(150);
alter table PORTAL_SYS_APP modify NAME_ VARCHAR2(150);
alter table PORTAL_SYS_APP modify DESC_ VARCHAR2(1000);
alter table PORTAL_BIZ_SYSTEM modify SYS_CODE_ VARCHAR2(150);
alter table PORTAL_BIZ_SYSTEM modify SYS_NAME_ VARCHAR2(150);
alter table PORTAL_BIZ_SYSTEM modify ROOT_ADDRESS_ VARCHAR2(1000);
alter table PORTAL_BIZ_SYSTEM modify HOME_ADDRESS_ VARCHAR2(1000);
alter table PORTAL_BIZ_SYSTEM modify BPM_MSG_QUEUE_ VARCHAR2(150);
alter table PORTAL_SYS_MODULE modify NAME_ VARCHAR2(150);
alter table PORTAL_SYS_MODULE modify CODE_ VARCHAR2(150);
alter table PORTAL_SYS_PROPERTIES modify NAME VARCHAR2(150);
alter table PORTAL_SYS_PROPERTIES modify ALIAS VARCHAR2(150);
alter table PORTAL_SYS_PROPERTIES modify GROUP_ VARCHAR2(150);
alter table PORTAL_SYS_PROPERTIES modify DESCRIPTION VARCHAR2(1000);
alter table UC_ROLE modify NAME_ VARCHAR2(150);
alter table UC_TENANT_MANAGE modify NAME_ VARCHAR2(300);
alter table UC_TENANT_MANAGE modify NAME_FRONT_ VARCHAR2(300);
alter table UC_TENANT_MANAGE modify SHORTHAND_ VARCHAR2(150);
alter table BPM_AGENT_SETTING modify SUBJECT_ VARCHAR2(150);
alter table FORM_BO_DEF modify DESCRIPTION_ VARCHAR2(150);
alter table PORTAL_SYS_MSG_TPL modify KEY_ VARCHAR2(150);
alter table PORTAL_SYS_MSG_TPL modify SMS_TEMPLATE_NO_ VARCHAR2(150);
alter table PORTAL_SYS_MSG_TPL modify VOICE_TEMPLATE_NO_ VARCHAR2(150);
alter table PORTAL_SYS_MSG_TPL modify SUBJECT_ VARCHAR2(1000);
alter table BPM_MULTI_SCRIPT modify METHOD_DESC_ VARCHAR2(1000);
alter table BPM_SCRIPT modify NAME_ VARCHAR2(150);
alter table BPM_SCRIPT modify MEMO_ VARCHAR2(1000);
alter table PORTAL_FLOW_UPLOAD_PROPERTIES modify NAME_ VARCHAR2(150);
alter table PORTAL_FLOW_UPLOAD_PROPERTIES modify LOCATION_ VARCHAR2(300);
alter table PORTAL_FLOW_UPLOAD_PROPERTIES modify FTP_URL_ VARCHAR2(300);
alter table PORTAL_FLOW_UPLOAD_PROPERTIES modify FTP_PORT_ VARCHAR2(300);
alter table PORTAL_FLOW_UPLOAD_PROPERTIES modify FTP_USER_NAME_ VARCHAR2(150);
alter table PORTAL_FLOW_UPLOAD_PROPERTIES modify FTP_PASSWORD_ VARCHAR2(150);
alter table PORTAL_FLOW_UPLOAD_PROPERTIES modify DESC_ VARCHAR2(1000);
alter table PORTAL_BIZ_SYSTEM_AUTH modify SYS_NAME_ VARCHAR2(150);

-- yijj 修改菜单旧数据
UPDATE PORTAL_SYS_MENU
SET TYPE_ = 'catalog'
WHERE
	ID_ IN ( SELECT id_ FROM PORTAL_SYS_MENU WHERE ROUTE_EXTEND_ LIKE '%"MultilevelMenuLayout%' OR ROUTE_EXTEND_ LIKE '%"Layout%' OR ROUTE_EXTEND_ IS NULL );
UPDATE PORTAL_SYS_MENU
SET type_ = 'page'
WHERE
	id_ NOT IN ( SELECT id_ FROM PORTAL_SYS_MENU WHERE ROUTE_EXTEND_ LIKE '%"MultilevelMenuLayout%' OR ROUTE_EXTEND_ LIKE '%"Layout%' OR ROUTE_EXTEND_ IS NULL );