| 123456789101112131415 |
- 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);
|
