dev/2020/2020-019(OK)/2020-019-xpp-001.sql

USE DCP;
ALTER TABLE cms_information_entity
ADD COLUMN `dynamic_business_json_name` varchar(2000) COMMENT '动态关联业务对象名称' AFTER `dynamic_business_json`;
ALTER TABLE cms_information_view
ADD COLUMN `dynamic_business_json_name` varchar(2000) COMMENT '动态关联业务对象名称' AFTER `dynamic_business_json`;
ALTER TABLE cms_information_info
ADD COLUMN `dynamic_business_json_name` varchar(2000) COMMENT '动态关联业务对象名称' AFTER `dynamic_business_json`;


ALTER TABLE cms_information_entity
ADD COLUMN `dynamic_business_type` varchar(2000) COMMENT '动态关联业务对象类型' AFTER `dynamic_business_json_name`;
ALTER TABLE cms_information_view
ADD COLUMN `dynamic_business_type` varchar(2000) COMMENT '动态关联业务对象类型' AFTER `dynamic_business_json_name`;
ALTER TABLE cms_information_info
ADD COLUMN `dynamic_business_type` varchar(2000) COMMENT '动态关联业务对象类型' AFTER `dynamic_business_json_name`;

INSERT INTO auth_privilege ( APPLICATION_ID, PRIVILEGE_KEY, PRIVILEGE_NAME, PRIVILEGE_TYPE_DICT, CREATE_USER_ID, CREATE_TIME, UPDATE_USER_ID, UPDATE_TIME,PRIVILEGE_DISPLAY_ORDER,PRIVILEGE_PARENT_ID,PRIVILEGE_ICON,PRIVILEGE_URL,PRIVILEGE_STATUS ) (SELECT 2,'ITIM.USER.MEMBER.INFO.DYNAMIC','会员关联动态管理','1','1',now(),'1',now(),4,(SELECT max(PRIVILEGE_ID) FROM auth_privilege WHERE PRIVILEGE_KEY='ITIM.USER.MEMBER.INFO'),'fa-dashboard','MemberDynamicList','0' FROM DUAL);

/*159已执行 2020年12月1日 15:12:58 ljh */