ALTER TABLE experience_approval
  ADD COLUMN landing_page varchar(500) NULL DEFAULT '' COMMENT '落地页地址',
  ADD COLUMN page_title varchar(200) NULL DEFAULT '' COMMENT '页面标题',
  ADD COLUMN referrer varchar(500) NULL DEFAULT '' COMMENT '来源地址',
  ADD COLUMN utm_source varchar(100) NULL DEFAULT '' COMMENT 'UTM来源',
  ADD COLUMN utm_medium varchar(100) NULL DEFAULT '' COMMENT 'UTM媒介',
  ADD COLUMN utm_campaign varchar(100) NULL DEFAULT '' COMMENT 'UTM活动',
  ADD COLUMN utm_term varchar(100) NULL DEFAULT '' COMMENT 'UTM词',
  ADD COLUMN utm_content varchar(100) NULL DEFAULT '' COMMENT 'UTM内容',
  ADD COLUMN first_source varchar(500) NULL DEFAULT '' COMMENT '首次来源',
  ADD COLUMN latest_source varchar(500) NULL DEFAULT '' COMMENT '最近来源';

CREATE INDEX idx_experience_approval_utm_source ON experience_approval (utm_source);
CREATE INDEX idx_experience_approval_create_time ON experience_approval (create_time);