USE DCP;
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.LEAGUE.MEMBER.DYNAMIC','联盟成员关联动态管理','1','1',now(),'1',now(),4,(SELECT max(PRIVILEGE_ID) FROM auth_privilege WHERE PRIVILEGE_KEY='ITIM.USER.LEAGUE.MEMBER'),'fa-dashboard','LeagueMemberDynamicList','0' FROM DUAL);
-- 159，161 已执行

ALTER TABLE cms_category
ADD COLUMN `have_app_data_flag` char(1) COMMENT '是否维护app数据' AFTER `process_key`;

ALTER TABLE cms_information_info
ADD COLUMN `app_content` longtext COMMENT 'app端资讯内容' AFTER `content_html`,
ADD COLUMN `app_content_html` longtext COMMENT 'app端资讯内容HTML' AFTER `app_content`;

ALTER TABLE cms_information_view
ADD COLUMN `app_content` longtext COMMENT 'app端资讯内容' AFTER `content_html`,
ADD COLUMN `app_content_html` longtext COMMENT 'app端资讯内容HTML' AFTER `app_content`;