official-cloudpure/LonYue-master/sql/20261026_global_config_digital_base_header.sql

ALTER TABLE global_config
  ADD COLUMN digital_base_banner_url varchar(500) NULL DEFAULT '' COMMENT '数字化底座顶部Banner',
  ADD COLUMN digital_base_eyebrow varchar(100) NULL DEFAULT '' COMMENT '数字化底座Banner辅助标题',
  ADD COLUMN digital_base_title varchar(300) NULL DEFAULT '' COMMENT '数字化底座Banner主标题',
  ADD COLUMN digital_base_subtitle varchar(200) NULL DEFAULT '' COMMENT '数字化底座Banner副标题',
  ADD COLUMN digital_base_type1_name varchar(100) NULL DEFAULT '' COMMENT '数字化底座版本一名称',
  ADD COLUMN digital_base_type2_name varchar(100) NULL DEFAULT '' COMMENT '数字化底座版本二名称';

UPDATE global_config
SET digital_base_banner_url = CASE
      WHEN digital_base_banner_url IS NULL OR digital_base_banner_url = ''
        THEN 'https://img.cloudpure.cn/prod-api/profile/upload/images/digitalBase/banner.png'
      ELSE digital_base_banner_url
    END,
    digital_base_eyebrow = CASE
      WHEN digital_base_eyebrow IS NULL OR digital_base_eyebrow = '' THEN '基于钉钉'
      ELSE digital_base_eyebrow
    END,
    digital_base_title = CASE
      WHEN digital_base_title IS NULL OR digital_base_title = ''
        THEN '为您的企业打造统一协同、安全可靠、随需扩展的数字基座'
      ELSE digital_base_title
    END,
    digital_base_subtitle = CASE
      WHEN digital_base_subtitle IS NULL OR digital_base_subtitle = '' THEN '驱动组织效能与业务创新'
      ELSE digital_base_subtitle
    END,
    digital_base_type1_name = CASE
      WHEN digital_base_type1_name IS NULL OR digital_base_type1_name = '' THEN '钉钉专业版'
      ELSE digital_base_type1_name
    END,
    digital_base_type2_name = CASE
      WHEN digital_base_type2_name IS NULL OR digital_base_type2_name = '' THEN '钉钉专属版'
      ELSE digital_base_type2_name
    END;