2020-023-xpp-001.sql 1.0 KB

1234567891011121314
  1. USE DCP;
  2. 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);
  3. -- 159,161 已执行
  4. ALTER TABLE cms_category
  5. ADD COLUMN `have_app_data_flag` char(1) COMMENT '是否维护app数据' AFTER `process_key`;
  6. ALTER TABLE cms_information_info
  7. ADD COLUMN `app_content` longtext COMMENT 'app端资讯内容' AFTER `content_html`,
  8. ADD COLUMN `app_content_html` longtext COMMENT 'app端资讯内容HTML' AFTER `app_content`;
  9. ALTER TABLE cms_information_view
  10. ADD COLUMN `app_content` longtext COMMENT 'app端资讯内容' AFTER `content_html`,
  11. ADD COLUMN `app_content_html` longtext COMMENT 'app端资讯内容HTML' AFTER `app_content`;