-- 创建腾讯广告转化归因表
CREATE TABLE IF NOT EXISTS `tencent_conversion` (
    `id` BIGINT NOT NULL AUTO_INCREMENT COMMENT '主键ID',
    `conversion_id` BIGINT NOT NULL COMMENT '转化ID',
    `conversion_name` VARCHAR(255) DEFAULT NULL COMMENT '转化名称',
    `create_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `update_time` DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    PRIMARY KEY (`id`),
    UNIQUE KEY `uk_conversion_id` (`conversion_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COMMENT='腾讯广告转化归因表';
